NBA Data Dictionary
Below you will find a list of all data points that are contained within each feed that we offer. If any of the information provided below is unclear, or if you have a specific question, please contact support.
Go to our developer portal for a full list of operations including deprecated, legacy and test endpoints.
All dates & times are in US Eastern Time.
BettingEntityMetadata
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| RecordId from 2021 | integer (32) | NOT NULL | No | The ID of the record. Unique only within the same entity type (i.e. BettingMarketType IDs overlap with BettingBetType IDs) |
| Name from 2021 | string (100) | NOT NULL | No | A text value for the record (e.g. Moneyline; Player Prop; 3rd Quarter) |
| Active | bool (32) | NULL | No | Whether or not this market is currently is use. Note: Active = True & Inactive = False |
BettingEntityMetadataCollection
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingBetTypes from 2021 | BettingEntityMetadata[] (32) | NULL | No | The list of the bet types that can be found within a market |
| BettingMarketTypes from 2021 | BettingEntityMetadata[] (32) | NULL | No | A list of the possible Market Types within a Betting Event (e.g. Game Line, Team prop, Player Future, etc.) |
| BettingPeriodTypes from 2021 | BettingEntityMetadata[] (32) | NULL | No | A list of the possible BettingPeriodTypes (e.g. Full Game; Regulation Time; 1st Half) |
| BettingEventTypes from 2021 | BettingEntityMetadata[] (32) | NULL | No | A list of the possible BettingEventTypes (e.g. Game; Future) |
| BettingOutcomeTypes from 2021 | BettingEntityMetadata[] (32) | NULL | No | A list of the possible BettingOutcomeTypes (e.g. Home; Away; Under; Over) |
| ResultedMarketMetaData from 2021 | BettingResultingMetadata[] (32) | NULL | No | A list of the combinations of MarketType; BetType; & PeriodType which we willl provide automated resulting for |
| BettingResultTypes from 2021 | BettingEntityMetadata[] (32) | NULL | No | A list of the possible BettingResultTypes (e.g. Win; Loss; Push; Not Resulted; Incomplete) |
BettingEvent
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingEventID from 2020 | int (32) | NOT NULL | No | The unique ID associated with the betting event |
| Name from 2020 | string (32) | NULL | No | The name of this betting event |
| Season from 2020 | int (32) | NULL | No | The NBA season of the BettingEvent |
| BettingEventTypeID from 2020 | int (32) | NOT NULL | No | The ID associated with the type of betting event |
| BettingEventType from 2020 | string (32) | NOT NULL | No | Indicates the type of betting event - Game or Future |
| StartDate from 2020 | datetime | NULL | No | The furthest forward time any sportsbook has an event or market set to start for this betting event |
| Created from 2020 | datetime | NULL | No | The date and time when this betting event was created (in US Eastern Time) |
| Updated from 2020 | datetime | NULL | No | The timestamp of the last time this betting event was updated (in US Eastern Time) |
| GameID from 2020 | int (32) | NULL | No | The unique ID of the game associated with this BettingEvent |
| GlobalGameID from 2020 | int (32) | NULL | No | The GlobalGameID of the game tied to this event |
| GameStatus from 2020 | string (32) | NULL | Yes | The status of the game in tied to this event |
| Quarter from 2020 | string (32) | NULL | Yes | The current quarter in the game tied to this betting event. Possible values include: 1; 2; 3; 4; Half; OT; NULL |
| AwayTeam from 2020 | string (32) | NULL | No | The abbreviation [Key] of the away team tied to the event |
| HomeTeam from 2020 | string (32) | NULL | No | The abbreviation [Key] of the home team |
| AwayTeamID from 2020 | int (32) | NULL | No | The unique ID of the away team tied to the event |
| HomeTeamID from 2020 | int (32) | NULL | No | The unique ID of the home team tied to the event |
| GlobalAwayTeamID from 2020 | int (32) | NULL | No | A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues |
| GlobalHomeTeamID from 2020 | int (32) | NULL | No | A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues |
| AwayTeamScore from 2020 | int (32) | NULL | Yes | Total number of points the away team scored in the game tied to the event (post-game) |
| HomeTeamScore from 2020 | int (32) | NULL | Yes | Total points scored by the home team in the game (post-game) |
| TotalScore from 2020 | int (32) | NULL | Yes | The total amount of points scored in the game by both teams. Updated after the game ends to allow for resulting bets |
| AwayRotationNumber from 2020 | int (32) | NULL | No | Rotation number of away team for this event Note: if the betting event is a future this field will be NULL |
| HomeRotationNumber from 2020 | int (32) | NULL | No | The rotation number of the home team for this event Note: If betting event is a future this field will be NULL |
| BettingMarkets from 2020 | BettingMarket[] (32) | NULL | No | The list of betting markets for this event |
| GameStartTime from 2020 | datetime (32) | NULL | No | The date and time that the game started (in US Eastern Time) |
BettingMarket
Available Endpoints
This table is used in the following endpoints:
-
Props
- Betting Events - by Date
- Betting Events - by Season
- Betting Markets - by Event
- Betting Markets - by Market Type
- Betting Markets - by Game
- Betting Player Props - by Game
- Betting Markets - by Event [Sportsbook Group]
- Betting Markets - by Game [Sportsbook Group]
- Betting Markets - by Market Type [Sportsbook Group]
- Betting Player Props - by Game [Sportsbook Group]
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketID from 2020 | int (32) | NOT NULL | No | The unique ID associated with the betting market |
| BettingEventID from 2020 | int (32) | NOT NULL | No | The unique ID associated with the betting event |
| BettingMarketTypeID from 2020 | int (32) | NULL | Yes | Unique ID that distinguishes the different types of Market Types |
| BettingMarketType from 2020 | string (32) | NULL | Yes | The name of the market type within a market (e.g. Player Prop, Team Prop, Game Prop, etc.) |
| BettingBetTypeID from 2020 | int (32) | NULL | Yes | The ID associated with the name of the bet type within a market |
| BettingBetType from 2020 | string (32) | NULL | Yes | The name of the bet type within a market (e.g. Total Points, Moneyline, Spread, etc.) |
| BettingPeriodTypeID from 2020 | int (32) | NULL | Yes | The BettingPeriodTypeID of this type of market which we can result |
| BettingPeriodType from 2020 | string (32) | NULL | Yes | The name of the period type of this market (e.g. Full Game; 1st Half; 2nd Quarter; Regular Season) |
| Name from 2020 | string (32) | NULL | No | The generic name of this market |
| TeamID from 2020 | int (32) | NULL | Yes | The unique ID of the team tied to this market (if applicable) |
| TeamKey from 2020 | string (32) | NULL | Yes | The abbreviation [Key] of the team associated with this market (if applicable) |
| PlayerID from 2020 | int (32) | NULL | Yes | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| PlayerName from 2020 | string (32) | NULL | Yes | The name of the player tied to this market (if applicable) |
| Created from 2020 | datetime (32) | NULL | No | The date and time when this betting market was created (in US Eastern Time) |
| Updated from 2020 | datetime (32) | NULL | No | The timestamp of the last time this betting market was updated (in US Eastern Time) |
| AvailableSportsbooks from 2020 | Sportsbook[] (32) | NULL | No | A list of sportsbooks that have odds available in a given market |
| AnyBetsAvailable from 2020 | bool (32) | NULL | No | A field that returns "True" if there are any available bets to make within the market in question. If there are no bets available to make, the field returns "False" |
| BettingOutcomes from 2020 | BettingOutcome[] (32) | NULL | No | The list of betting outcomes from each sportsbook in this market |
| ConsensusOutcomes from 2020 | ConsensusOutcome[] (32) | NULL | No | The single set of consensus outcomes of this market |
| IsArchived | bool | NOT NULL | No | Indicates whether a BettingOutcome has been archived or not |
| ArchiveLocation | string | NOT NULL | No | If IsArchived is true, this returns the URL that can be used to retrieve the archived BettingOutcomes. An API Key and Sportsbook Grouping will be required to retrieve this information. If IsArchived is false, this returns an empty string |
BettingMarketResult
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketID from 2021 | integer (32) | NOT NULL | No | The unique ID associated with the betting market |
| BettingMarketTypeID from 2021 | integer (32) | NOT NULL | No | The unique ID that distinguishes the different types of Market Types |
| BettingMarketType from 2021 | string (100) | NOT NULL | No | The name of the market type within a market (e.g. Player Prop, Team Prop, Game Prop, etc.) |
| BettingBetTypeID from 2021 | integer (32) | NOT NULL | No | The unique ID associated with the name of the bet type within a market |
| BettingBetType from 2021 | string (100) | NOT NULL | No | The name of the bet type within a market (e.g. Total Points, Moneyline, Spread, etc.) |
| BettingPeriodTypeID from 2021 | integer (32) | NOT NULL | No | The BettingPeriodTypeID of this type of market which we can result |
| BettingPeriodType from 2021 | string (100) | NOT NULL | No | The name of the period type of this market (e.g. Full Game; 1st Half; 2nd Quarter; Regular Season) |
| Name from 2021 | string (100) | NULL | No | The generic name of this market |
| TeamID from 2021 | integer (32) | NULL | No | The unique ID of the team tied to this market result (if applicable) |
| TeamKey from 2021 | string (10) | NULL | No | The abbreviation [Key] of the team associated with this market |
| PlayerID from 2021 | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| PlayerName from 2021 | string (100) | NULL | No | The name of the player tied to this market (if applicable) |
| BettingOutcomeResults from 2021 | BettingOutcomeResult[] | NULL | No | The list of outcomes under this market with results |
| IsMarketResultingSupported | bool (32) | NOT NULL | No | Indicates whether resulting is supported for this kind of BettingMarket |
BettingMarketSplit
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketID from 2021 | integer (32) | NOT NULL | No | The unique ID associated with the betting market |
| BettingEventID from 2021 | integer (32) | NOT NULL | No | The unique ID of the betting event associated with this split |
| BettingMarketTypeID from 2021 | integer (32) | NOT NULL | No | The unique ID that distinguishes the different types of Market Types |
| BettingMarketType from 2021 | string (100) | NOT NULL | No | The name of the market type within a market (e.g. Player Prop, Team Prop, Game Prop, etc.) |
| BettingBetTypeID from 2021 | integer (32) | NOT NULL | No | The unique ID associated with the name of the bet type within a market |
| BettingBetType from 2021 | string (100) | NOT NULL | No | The name of the bet type within a market (e.g. Total Points, Moneyline, Spread, etc.) |
| BettingPeriodTypeID from 2021 | integer (32) | NOT NULL | No | The BettingPeriodTypeID of this type of market which we can result |
| BettingPeriodType from 2021 | string (100) | NOT NULL | No | The name of the period type of this market (e.g. Full Game; 1st Half; 2nd Quarter; Regular Season) |
| TeamID from 2021 | integer (32) | NULL | No | The unique ID of the team tied to this market split (if applicable) |
| TeamKey from 2021 | string (32) | NULL | No | The abbreviation [Key] of the team associated with this market |
| PlayerID from 2021 | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| PlayerName from 2021 | string (100) | NULL | No | The name of the player tied to this market (if applicable) |
| BettingSplits from 2021 | BettingSplit[] (32) | NOT NULL | No | A list of betting splits for a given game |
BettingOutcome
Available Endpoints
This table is used in the following endpoints:
-
Props
- Betting Events - by Date
- Betting Events - by Season
- Betting Markets - by Event
- Betting Markets - by Market Type
- Betting Markets - by Game
- Betting Player Props - by Game
- Betting Markets - by Event [Sportsbook Group]
- Betting Markets - by Game [Sportsbook Group]
- Betting Markets - by Market Type [Sportsbook Group]
- Betting Player Props - by Game [Sportsbook Group]
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingOutcomeID from 2020 | int (32) | NULL | No | The unique ID associated with this specific outcome |
| BettingMarketID from 2020 | int (32) | NULL | No | The unique ID associated with the betting market |
| SportsBook from 2020 | Sportsbook (32) | NULL | No | The sportsbook offering this outcome for betting |
| BettingOutcomeTypeID from 2020 | int (32) | NULL | Yes | The BettingOutcomeTypeID of this outcome |
| BettingOutcomeType from 2020 | string (32) | NULL | Yes | The name of outcome type (e.g. Home; Away; Under; Over) |
| PayoutAmerican from 2020 | int (32) | NULL | Yes | The american odds payout |
| PayoutDecimal from 2020 | decimal (32) | NULL | Yes | The decimal odds payout |
| Value from 2020 | decimal (32) | NULL | Yes | The number associated with the outcome of a market (e.g. the spread, game total, etc.) |
| Participant from 2020 | string (32) | NULL | No | The name of the participant (typically team or player) associated with the outcome. NOTE: this is provided by the sportsbook. In the case of Player odds, we highly recommend using PlayerID as names of players can be inconsistent between sportsbooks. |
| IsAvailable from 2020 | bool (32) | NULL | No | Indicates whether a BettingOutcome is available for betting or not |
| IsAlternate from 2020 | bool (32) | NULL | No | Is this an alternate value or the core value |
| Created from 2020 | datetime (32) | NULL | No | The date and time when this betting outcome was created (in US Eastern Time) |
| Updated from 2020 | datetime (32) | NULL | No | The timestamp of the last time this betting outcome was updated (in US Eastern Time) |
| Unlisted from 2020 | datetime (32) | NULL | No | The timestamp of when these odds were first made unavailable to be bet on any further (in US Eastern Time) |
| TeamID from 2020 | int (32) | NULL | Yes | The unique ID of the team tied to this outcome (if applicable) |
| PlayerID from 2020 | int (32) | NULL | Yes | The player's unique PlayerID as assigned by SportsDataIO (where applicable). Note: this ID will stay with the player throughout their entire career |
| GlobalTeamID from 2020 | int (32) | NULL | Yes | A globally unique ID for this team (where applicable). This value is guaranteed to be unique across all sports/leagues. |
| SportsbookUrl from 2020 | string (500) | NULL | Yes | The URL for sportsbook event |
| IsInPlay from 2022 | bool (1) | NULL | No | Was this outcome created after the start time of the game (only applies when the betting event is of type game) |
| SportsbookMarketID | string (100) | NULL | Yes | The market ID on the given sportsbook for deeplinking (when available) |
| SportsbookOutcomeID | string (100) | NULL | Yes | The outcome ID on the given sportsbook for deeplinking (when available) |
BettingOutcomeResult
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingOutcomeID from 2021 | integer (32) | NOT NULL | No | The unique ID associated with this specific outcome |
| BettingResultTypeID from 2021 | integer (32) | NULL | Yes | The BettingResultType of this outcome |
| BettingResultType from 2021 | string (100) | NULL | Yes | The string identifier of the BettingResultType of this outcome (e.g. Won, Lost, Push, Not Resulted, Incomplete) |
| BettingOutcomeTypeID from 2020 | int (32) | NULL | No | The BettingOutcomeTypeID of this outcome |
| BettingOutcomeType from 2020 | string (32) | NULL | No | The name of outcome type (e.g. Home; Away; Under; Over) |
| BetValue from 2021 | decimal (32) | NULL | Yes | The offered betting line from a sportsbook for a game (i.e. If a team won a game by 5 and the spread was -6.5, the actual value would be 5 and the bet value would be -6.5) |
| ActualValue from 2021 | decimal (32) | NULL | Yes | The value of the actual result that occurred in game (i.e. If a team won a game by 5 and the spread was -6.5, the actual value would be 5 and the bet value would be -6.5) |
BettingResultingMetadata
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketTypeId from 2021 | integer (32) | NOT NULL | No | The unique ID that distinguishes the different types of Market Types |
| BettingBetTypeId from 2021 | integer (32) | NOT NULL | No | The ID associated with the name of the bet type within a market |
| BettingPeriodTypeId from 2021 | integer (32) | NOT NULL | No | The BettingPeriodTypeID of this type of market which we can result |
BettingSplit
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketSplitID from 2021 | integer (32) | NOT NULL | No | The unique ID assciated with the betting split |
| BettingMarketID from 2021 | integer (32) | NOT NULL | No | The unique ID associated with the betting market |
| BettingOutcomeTypeID from 2021 | integer (32) | NULL | No | The BettingOutcomeTypeID of this outcome |
| BettingOutcomeType from 2021 | string (32) | NULL | No | The name of outcome type (e.g. Home; Away; Under; Over) |
| BetPercentage from 2021 | integer (32) | NULL | Yes | Percentage of bets placed on a specific outcome |
| MoneyPercentage from 2021 | integer (32) | NULL | Yes | Percent of Money on this Outcome |
| Created from 2021 | datetime (32) | NOT NULL | No | The date and time when this betting split was first seen (in US Eastern Time) |
| LastSeen from 2021 | datetime (32) | NOT NULL | No | When this split was last updated |
BoxScore
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Game | Game | NULL | No | The details of the game associated with this box score |
| Quarters | Quarter[] | NULL | No | The details of the quarters associated with this box score |
| TeamGames | TeamGame[] | NULL | No | The team game stats associated with this box score |
| PlayerGames | PlayerGame[] | NULL | No | The player game stats associated with this box score |
ConsensusOutcome
Available Endpoints
This table is used in the following endpoints:
-
Props
- Betting Events - by Date
- Betting Events - by Season
- Betting Markets - by Event
- Betting Markets - by Market Type
- Betting Markets - by Game
- Betting Player Props - by Game
- Betting Markets - by Event [Sportsbook Group]
- Betting Markets - by Game [Sportsbook Group]
- Betting Markets - by Market Type [Sportsbook Group]
- Betting Player Props - by Game [Sportsbook Group]
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| NumberOfSportsbooks from 2020 | int (32) | NOT NULL | Yes | The number of sportsbooks odds that went into creating this consensus outcome |
| BettingOutcomeID from 2020 | int (32) | NULL | No | The unique ID associated with this specific outcome |
| BettingMarketID from 2020 | int (32) | NULL | No | The unique ID associated with the betting market |
| SportsBook from 2020 | Sportsbook (32) | NULL | No | The sportsbook offering this outcome for betting |
| BettingOutcomeTypeID from 2020 | int (32) | NULL | Yes | The BettingOutcomeTypeID of this outcome |
| BettingOutcomeType from 2020 | string (32) | NULL | Yes | The name of the outcome type (e.g. Home; Away; Under; Over) |
| PayoutAmerican from 2020 | int (32) | NULL | Yes | The american odds payout |
| PayoutDecimal from 2020 | decimal (32) | NULL | Yes | The decimal odds payout |
| Value from 2020 | decimal (32) | NULL | Yes | The number associated with the outcome of a market (e.g. the spread, game total, etc.) |
| Participant from 2020 | string (32) | NULL | No | The name of the participant (typically team or player) associated with the outcome. NOTE: this is provided by the sportsbook. In the case of Player odds, we highly recommend using PlayerID as names of players can be inconsistent between sportsbooks. |
| IsAvailable from 2020 | bool (32) | NULL | No | Indicates whether this ConsensusOutcome is available for betting or not |
| IsAlternate from 2020 | bool (32) | NULL | No | Is this an alternate value or the core value |
| Created from 2020 | datetime (32) | NULL | No | The date and time when this consensus outcome was created (in US Eastern Time) |
| Updated from 2020 | datetime (32) | NULL | No | The timestamp of the last time this consensus outcome was updated (in US Eastern Time) |
| Unlisted from 2020 | datetime (32) | NULL | No | The timestamp of when these odds were first made unavailable to be bet on any further (In US Eastern Time) |
| TeamID from 2020 | int (32) | NULL | Yes | The unique ID of the team tied to this outcome (where applicable) |
| PlayerID from 2020 | int (32) | NULL | Yes | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| GlobalTeamID from 2020 | int (32) | NULL | Yes | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| SportsbookUrl from 2020 | string (500) | NULL | Yes | The URL for sportsbook event |
| IsInPlay from 2022 | bool (1) | NULL | No | Was this outcome created after the start time of the game (only applies when the betting event is of type game) |
| SportsbookMarketID | string (100) | NULL | Yes | The market ID on the given sportsbook for deeplinking (when available) |
| SportsbookOutcomeID | string (100) | NULL | Yes | The outcome ID on the given sportsbook for deeplinking (when available) |
DepthChart (From 2022)
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| TeamID | integer (32) | NOT NULL | No | The unique ID of the team |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| Name | string (32) | NULL | No | The player's full name |
| PositionCategory | string (32) | NULL | No | The player's position category. Possible values: C; F; G |
| Position | string (32) | NULL | No | The player's primary position. Possible values: C; PF; PG; SF; SG |
| DepthOrder | integer (32) | NULL | Yes | Depth Chart Order |
| Updated | datetime (32) | NULL | No | The date and time that this depth chart was last updated (in US Eastern Time) |
| DepthChartID | integer (32) | NOT NULL | No | Unique ID of Depth Chart Record |
DfsSlate
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SlateID | integer (32) | NOT NULL | No | Unique ID of a Slate (assigned by SportsDataIO). |
| Operator | string (20) | NULL | No | The name of the operator who is running contests for this slate. Possible values: FanDuel, DraftKings, Yahoo, FantasyDraft, etc. |
| OperatorSlateID | integer (32) | NULL | No | Unique ID of a slate (assigned by the operator). |
| OperatorName | string (50) | NULL | No | The name of the slate (assigned by the operator). Possible values: Main, Express, Arcade, Late Night, etc. |
| OperatorDay | date | NULL | No | The day (in EST/EDT) that the slate begins (assigned by the operator). |
| OperatorStartTime | datetime | NULL | No | The date/time (in EST/EDT) that the slate begins (assigned by the operator). |
| NumberOfGames | integer (32) | NULL | No | The number of actual games that this slate covers. |
| IsMultiDaySlate | boolean | NULL | No | Whether this slate uses games that take place on different days. |
| RemovedByOperator | boolean | NULL | No | Indicates whether this slate was removed/deleted by the operator. |
| OperatorGameType | string (50) | NULL | No | The game type of the slate. Will often be null as most operators only have one game type. |
| DfsSlateGames | DfsSlateGame[] | NULL | No | The games that are included in this slate |
| DfsSlatePlayers | DfsSlatePlayer[] | NULL | No | The players that are included in this slate |
| SlateRosterSlots | string[] | NULL | No | The positions that need to be filled for this particular slate |
| SalaryCap | integer | NULL | No | The salary cap for the current slate (is null for slates with no salary cap such a Tiers gametypes) |
DfsSlateGame
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SlateGameID | integer (32) | NOT NULL | No | Unique ID of a SlateGame (assigned by SportsDataIO). |
| SlateID | integer (32) | NOT NULL | No | The SlateID that this SlateGame refers to. |
| GameID | integer (32) | NULL | No | The unique ID of the game associated with this SlateGame. This points to data in the schedule/game/box score feeds. |
| Game | Game | NULL | No | The details of the Game that this SlateGame refers to. |
| OperatorGameID | integer (32) | NULL | No | Unique ID of a SlateGame (assigned by the operator). |
| RemovedByOperator | boolean | NULL | Yes | Indicates whether this game was removed/deleted by the operator. |
DfsSlatePlayer
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SlatePlayerID | integer (32) | NOT NULL | No | Unique ID of a SlatePlayer (assigned by SportsDataIO). |
| SlateID | integer (32) | NOT NULL | No | The SlateID that this SlatePlayer refers to. |
| SlateGameID | integer (32) | NULL | No | The SlateGameID that this SlatePlayer refers to. |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| PlayerGameProjectionStatID | integer (32) | NULL | No | The SportsDataIO StatID that this SlatePlayer refers to. This points to data in the respective sports' projected player game stats feeds. |
| OperatorPlayerID | string (25) | NULL | No | Unique ID of the Player (assigned by the operator). |
| OperatorSlatePlayerID | string (50) | NULL | No | Unique ID of the SlatePlayer (assigned by the operator). |
| OperatorPlayerName | string (50) | NULL | No | The player's name (assigned by the operator). |
| OperatorPosition | string (10) | NULL | No | The player's eligible positions for the contest (assigned by the operator). |
| OperatorSalary | integer (32) | NULL | No | The player's salary for the contest (assigned by the operator). |
| OperatorRosterSlots | string[] | NULL | No | The player's eligible positions to be played in the contest (assigned by the operator). This would include UTIL, etc plays for those that are eligible. |
| RemovedByOperator | boolean | NULL | Yes | Indicates whether this player was removed/deleted by the operator. |
| Team | string (12) | NULL | No | The abbreviation [Key] of the player's team |
| TeamID | integer (32) | NULL | No | The unique ID of the player's team |
FantasyGame
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID | integer (32) | NULL | No | The unique ID of this game |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition) |
| Season | integer (32) | NULL | No | The NBA season of the game |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in US Eastern Time) |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Opponent | string (10) | NULL | No | Abbreviation [Key] of the opponent team (e.g. LAL; PHI; BOS; CHI; etc.) |
| HomeOrAway | string (4) | NULL | No | Whether the team is home or away |
| Jersey | integer (32) | NULL | No | The player's jersey number |
| Name | string (50) | NULL | No | The player's full name |
| Position | string (10) | NULL | No | The player's primary position. Possible values: PG; SG; SF; PF; C |
| PositionCategory | string (10) | NULL | No | The player's position category. Possible values: C, F, G |
| Games | integer (32) | NULL | No | The number of games played by the player in the game Note: this will be one or zero for single game feeds |
| Started | integer (32) | NULL | No | Indicates whether or not the player started the game Note: this will be one or zero for single game feeds |
| FantasyPoints | decimal (32) | NULL | No | Total fantasy points by the player in the game |
| IsGameOver | boolean | NOT NULL | No | Whether the game is over (true/false) |
| FantasyPointsFanDuel | decimal (32) | NULL | No | Total FanDuel daily fantasy points scored |
| FantasyPointsYahoo | decimal (32) | NULL | No | Total Yahoo daily fantasy points scored |
| FantasyPointsDraftKings | decimal (32) | NULL | No | Total DraftKings daily fantasy points scored |
| FandDuelPosition | string (10) | NULL | No | The player's eligible position in FanDuel's daily fantasy sports platform. |
| DraftKingsPosition | string (10) | NULL | No | The player's eligible position in DraftKings' daily fantasy sports platform. |
| YahooPosition | string (10) | NULL | No | The player's eligible position in Yahoo's daily fantasy sports platform. |
| OpponentRank | integer (32) | NULL | No | The ranking of the player's opponent with regards to fantasy points allowed. |
| OpponentPositionRank | integer (32) | NULL | No | The ranking of the player's opponent by position with regards to fantasy points allowed. |
| GlobalGameID | integer (32) | NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| Updated | datetime | NULL | No | The timestamp of when this game was last updated (in US Eastern Time) |
Game
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID | integer (32) | NOT NULL | No | The unique ID of this game |
| Season | integer (32) | NOT NULL | No | The NBA season of the game |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition) |
| Status | string (20) | NULL | No | Indicates the game's status. Possible values include: Scheduled, InProgress, Final, F/OT, Suspended, Postponed, Delayed, Canceled, Forfeit, NotNecessary |
| Day | date | NULL | No | The date of the game |
| DateTime | datetime | NULL | No | The date and time of the game |
| AwayTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the away team |
| HomeTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the home team |
| AwayTeamID | integer (32) | NOT NULL | No | The unique ID of the away team |
| HomeTeamID | integer (32) | NOT NULL | No | The unique ID of the home team |
| StadiumID | integer (32) | NULL | No | The unique ID of the stadium |
| Channel | string (10) | NULL | No | The television station broadcasting the game |
| Attendance | integer (32) | NULL | No | The total number of people in attendance at the game |
| AwayTeamScore | integer (32) | NULL | Yes | Total number of points the away team scored in the game |
| HomeTeamScore | integer (32) | NULL | Yes | Total number of points the home team scored in this game |
| Updated | datetime | NULL | No | The timestamp of when this game was last updated (in US Eastern Time) |
| Quarter | string (10) | NULL | No | The current quarter in the game. Possible values include: 1, 2, 3, 4, Half, OT, NULL |
| TimeRemainingMinutes | integer (32) | NULL | No | The number of minutes remaining in the quarter |
| TimeRemainingSeconds | integer (32) | NULL | No | The number of seconds remaining in the quarter |
| PointSpread from 2016 | decimal (32) | NULL | Yes | The oddsmaker Point Spread at game start from the perspective of the HomeTeam (negative numbers indicate the HomeTeam is favored; positive numbers indicate the AwayTeam is favored) |
| OverUnder from 2016 | decimal (32) | NULL | Yes | The sportsbook's total points scored over under for the game |
| AwayTeamMoneyLine from 2016 | integer (32) | NULL | Yes | Money line from the perspective of the away team |
| HomeTeamMoneyLine from 2016 | integer (32) | NULL | Yes | Money line from the perspective of the home team |
| GlobalGameID | integer (32) | NOT NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| GlobalAwayTeamID | integer (32) | NOT NULL | No | A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues. |
| GlobalHomeTeamID | integer (32) | NOT NULL | No | A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues. |
| PointSpreadAwayTeamMoneyLine from 2017 | integer (32) | NULL | Yes | The money line payout odds when betting on the away team with the point spread. |
| PointSpreadHomeTeamMoneyLine from 2017 | integer (32) | NULL | Yes | The money line payout odds when betting on the away team with the point spread. |
| LastPlay | string (250) | NULL | Yes | The description of the most recent play/event of the game. This is for display purposes and does not include corresponding data points. |
| IsClosed | boolean | NOT NULL | No | Indicates whether the game is over and the final score has been verified and closed out. Note: it is recommend for bet resulting to use IsClosed = True rather than simply Final game status |
| Quarters | Quarter[] | NOT NULL | No | The details of the quarters (including overtime periods) for this game. |
| GameEndDateTime | datetime | NULL | No | The date and time that the game ended (in US Eastern Time) |
| HomeRotationNumber | integer (32) | NULL | Yes | The rotation number of the home team for this game |
| AwayRotationNumber | integer (32) | NULL | Yes | The rotation number of the away team for this game |
| NeutralVenue from 2020 | boolean | NULL | No | Indicates whether this game is played in a neutral venue |
| OverPayout from 2021 | integer (32) | NULL | Yes | The sportsbook's payout for the over on the total points line |
| UnderPayout from 2021 | integer (32) | NULL | Yes | The sportsbook's payout for the under on the total points line |
| CrewChiefID from 2021 | integer (32) | NULL | No | Unique ID of officiating Crew Chief |
| UmpireID from 2021 | integer (32) | NULL | No | Unique ID of officiating Umpire referee |
| RefereeID from 2021 | integer (32) | NULL | No | Unique ID of officiating referee |
| AlternateID from 2021 | integer (32) | NULL | No | Unique ID of officiating Alternate referee |
| DateTimeUTC from 2021 | datetime | NULL | No | The date and time of the game in UTC |
| SeriesInfo from 2021 | Series (32) | NULL | No | Contains relevant series data for playoff series only - HomeTeamWins, AwayTeamWins, GameNumber, and MaxLength |
| InseasonTournament | bool | NULL | No | A flag to indicate this game is part of the inseason NBA tournament (can be considered a part of regular season still) - a null would also indicate false |
| RescheduledFromGameID | integer (32) | NULL | Yes | The GameID of the originally scheduled, postponed game, that this game was rescheduled from. This only pertains to games that are scheduled as "make up" games. |
| RescheduledGameID | integer (32) | NULL | Yes | The GameID of the game that was rescheduled from this game. This only pertains to postponed games that require rescheduling. |
GameBettingSplit
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID from 2021 | integer (32) | NOT NULL | No | The unique ID of the game associated with this GameBettingSplit |
| SeasonType from 2021 | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition) |
| Season from 2021 | integer (32) | NOT NULL | No | The NBA season of the game |
| Day from 2021 | datetime (32) | NULL | No | The day of the game |
| AwayTeam from 2021 | string (32) | NULL | No | The abbreviation [Key] of the away team |
| HomeTeam from 2021 | string (32) | NULL | No | The abbreviation [Key] of the home team |
| BettingMarketSplits from 2021 | BettingMarketSplit[] (32) | NOT NULL | No | Shows the BettingMarketSplits included in a given game |
GameInfo
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameId | integer (32) | NOT NULL | No | The unique ID of the game. |
| Season | integer (32) | NOT NULL | No | The NBA season of the game |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition) |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game |
| Status | string (20) | NULL | No | The status of the game. For a description of possible values, see here. For how suspended and postponed games are handled specifically, see here. |
| AwayTeamId | integer (32) | NULL | No | The unique ID of the away team |
| HomeTeamId | integer (32) | NULL | No | The unique ID of the home team |
| AwayTeamName | string (50) | NULL | No | The abbreviation [Key] of the away team |
| HomeTeamName | string (50) | NULL | No | The abbreviation [Key] of the home team |
| GlobalGameId | integer (32) | NOT NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| GlobalAwayTeamId | integer (32) | NULL | No | The rotation number of the home team for this game |
| GlobalHomeTeamId | integer (32) | NULL | No | A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues. |
| PregameOdds | GameOdd[] | NULL | No | List of Pregame GameOdds from different sportsbooks |
| LiveOdds | GameOdd[] | NULL | No | List of Live GameOdds from different sportsbooks |
| HomeTeamScore | integer | NULL | Yes | Total points scored by the home team in the game (updated after the game ends to allow for resolving bets) |
| AwayTeamScore | integer | NULL | Yes | Total number of points the away team scored in the game (updated after game ends to allow for resolving bets) |
| TotalScore | integer | NULL | Yes | The total amount of points scored in the game by both teams. Updated after the game ends to allow for resulting bets |
| HomeRotationNumber | integer (32) | NULL | Yes | The Rotation number of the home team for this game |
| AwayRotationNumber | integer (32) | NULL | Yes | The rotation number of the away team for this game |
| AlternateMarketPregameOdds | GameOdd[] | NULL | Yes | A list of Alternate Market Pregame GameOdds from different sportsbooks (such as 1st-half; 1st-qtr; etc) |
GameInfoResult
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID | integer (32) | NOT NULL | No | The unique ID of the game. |
| Season | integer (32) | NOT NULL | No | The NBA season of the game |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition) |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game |
| Status | string (20) | NOT NULL | No | The status of the game. For a description of possible values, see here. For how suspended and postponed games are handled specifically, see here. |
| AwayTeamID | integer (32) | NULL | No | The unique ID of the away team |
| HomeTeamID | integer (32) | NULL | No | The unique ID of the home team |
| AwayTeamName | string (50) | NULL | No | The abbreviation [Key] of the away team |
| HomeTeamName | string (50) | NULL | No | The abbreviation [Key] of the home team |
| GlobalGameID | integer (32) | NOT NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| GlobalAwayTeamID | integer (32) | NULL | No | A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues. |
| GlobalHomeTeamID | integer (32) | NULL | No | A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues. |
| PregameOdds | GameOddResult[] | NULL | No | List of Pregame GameOdds from different sportsbooks with results |
| HomeTeamScore | integer (32) | NULL | Yes | Total points scored by the home team in the game (updated after the game ends to allow for resolving bets) |
| AwayTeamScore | integer (32) | NULL | Yes | Total number of points the away team scored in the game (updated after game ends to allow for resolving bets) |
| TotalScore | integer (32) | NULL | Yes | The total amount of points scored in the game by both teams. Updated after the game ends to allow for resulting bets |
| HomeRotationNumber | integer (32) | NULL | Yes | The rotation number of the home team for this game |
| AwayRotationNumber | integer (32) | NULL | Yes | The rotation number of the away team for this game |
| AlternateMarketPregameOdds | GameOddResult[] | NULL | Yes | A list of Alternate Market Pregame GameOdds from different sportsbooks (such as 1st-half; 1st-qtr; etc) |
| Quarter | string (10) | NULL | No | The current quarter in the game. Possible values include: 1, 2, 3, 4, Half, OT, NULL |
| TimeRemainingMinutes | integer (32) | NULL | No | The number of minutes remaining in the quarter |
| TimeRemainingSeconds | integer (32) | NULL | No | The number of seconds remaining in the quarter |
| Quarters | Quarter[] | NULL | No | The details of the quarters (including overtime periods) for this game. |
| IsClosed | boolean | NOT NULL | No | Indicates whether the game is over and the final score has been verified and closed out. Note: it is recommend for bet resulting to use IsClosed = True rather than simply Final game status |
| LiveOdds | GameOddResult[] | NULL | No | List of Live Odds from different sportsbooks with results |
GameOdd
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameOddId | integer (32) | NOT NULL | No | The unique ID of this odd |
| Sportsbook | string (25) | NOT NULL | Yes | Name of sportsbook |
| GameId | integer (32) | NOT NULL | No | The unique ID of the game associated with this GameOdd |
| Created | datetime | NOT NULL | No | The timestamp of when these odds were first created (in US Eastern Time) |
| Updated | datetime | NOT NULL | No | The timestamp of when these odds were last updated (US Eastern Time). If these are the latest odds for this game; and they have not been updated within the last few minutes; then it indicates that there were problems connecting to the sportsbook |
| HomeMoneyLine | integer (32) | NULL | Yes | The sportsbook's money line for the home team |
| AwayMoneyLine | integer (32) | NULL | Yes | The sportsbook's money line for the away team |
| HomePointSpread | decimal (32) | NULL | Yes | The sportsbook's point spread for the home team |
| AwayPointSpread | decimal (32) | NULL | Yes | The sportsbook's point spread for the away team |
| HomePointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's point spread payout for the home team |
| AwayPointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's point spread payout for the away team |
| OverUnder | decimal (32) | NULL | Yes | The sportsbook's total points scored over under for the game |
| OverPayout | integer (32) | NULL | Yes | The sportsbook's payout for the over |
| UnderPayout | integer (32) | NULL | Yes | The sportsbook's payout for the under |
| SportsbookId | integer (32) | NULL | No | Unique ID of the Sportsbook |
| OddType | string (10) | NULL | No | The market type of the odd (ex: live, pregame, 1st-half, 2nd-quarter) |
| SportsbookUrl | string (500) | NULL | No | The URL for sportsbook event |
| Unlisted | datetime | NULL | No | The timestamp of when these odds were first made unavailable to be bet on any further (in US Eastern Time) |
GameOddOutcome
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameOddId | integer (32) | NOT NULL | No | The unique ID of this odd |
| GameOddResultTypeId | integer (32) | NULL | No | The GameOddResultType of this outcome as an integer |
| GameOddResultType | string (100) | NULL | No | The result/outcome of a bet (e.g. Won; Lost; Push; Not Resulted; Incomplete) |
| OddType | string (500) | NULL | No | The market type of the odd (ex: live; pregame; 2nd quarter; etc) |
| GameOddType | string (100) | NULL | No | The GameOddOutcomeType of this outcome as a string |
| BetValue | decimal (32) | NULL | No | The offered betting line from a sportsbook for a game (i.e. If a team won a game by 5 and the spread was -6.5, the actual value would be 5 and the bet value would be -6.5) |
| ActualValue | decimal (32) | NULL | No | The value of the actual result that occured in game (i.e. If a team won a game by 5 and the spread was -6.5, the actual value would be 5 and the bet value would be -6.5) |
GameOddResult
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameOddID | integer (32) | NOT NULL | No | The unique ID of this odd |
| Sportsbook | string (25) | NOT NULL | Yes | Name of sportsbook |
| GameID | integer (32) | NOT NULL | No | The unique ID of the game associated with this GameOdd |
| Created | datetime | NOT NULL | No | The timestamp of when these odds were first created (in US Eastern Time) |
| Updated | datetime | NOT NULL | No | The timestamp of when these odds were last updated (US Eastern Time). If these are the latest odds for this game; and they have not been updated within the last few minutes; then it indicates that there were problems connecting to the sportsbook |
| HomeMoneyLine | integer (32) | NULL | Yes | The sportsbook's money line for the home team |
| AwayMoneyLine | integer (32) | NULL | Yes | The sportsbook's money line for the away team |
| HomePointSpread | decimal (32) | NULL | Yes | The sportsbook's point spread for the home team |
| AwayPointSpread | decimal (32) | NULL | Yes | The sportsbook's point spread for the away team |
| HomePointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's point spread payout for the home team |
| AwayPointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's point spread payout for the away team |
| OverUnder | decimal (32) | NULL | Yes | The sportsbook's total points scored over under for the game |
| OverPayout | integer (32) | NULL | Yes | The sportsbook's payout for the over |
| UnderPayout | integer (32) | NULL | Yes | The sportsbook's payout for the under |
| SportsbookID | integer (32) | NOT NULL | No | Unique ID of the Sportsbook |
| SportsbookUrl | string (500) | NULL | No | The URL for sportsbook event |
| OddType | string (10) | NULL | No | The market type of the odd (ex: live, pregame, 1st-half, 2nd-quarter) |
| GameOddOutcomeResults | GameOddOutcome[] | NULL | No | List of outcomes showing results of betting markets that were bet on for the given game |
Headshot
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerID | integer (32) | NOT NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| Name | string (100) | NULL | No | The player's full name |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| Team | string (10) | NULL | No | The abbreviation [Key] of the player's team |
| Position | string (10) | NULL | No | The player's primary position. Possible values: C; PF; PG; SF; SG |
| PreferredHostedHeadshotUrl | string (500) | NULL | Yes | The player's preferred hosted headshot URL. This returns the headshot with transparent background, if available. |
| PreferredHostedHeadshotUpdated | datetime | NULL | No | The last updated date of the player's preferred hosted headshot. |
| HostedHeadshotWithBackgroundUrl | string (500) | NULL | Yes | The player's hosted headshot URL. |
| HostedHeadshotWithBackgroundUpdated | datetime | NULL | No | The last updated date of the player's hosted headshot. |
| HostedHeadshotNoBackgroundUrl | string (500) | NULL | Yes | The player's transparent background hosted headshot URL. |
| HostedHeadshotNoBackgroundUpdated | datetime | NULL | No | The last updated date of the player's transparent background hosted headshot. |
Lineup
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerID from 2021 | integer (32) | NOT NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| TeamID from 2021 | integer (32) | NOT NULL | No | The unique ID of the team |
| Team from 2021 | string (32) | NOT NULL | No | The abbreviation [Key] of the team |
| FirstName from 2021 | string (32) | NOT NULL | No | The player's first name |
| LastName from 2021 | string (32) | NOT NULL | No | The player's last name |
| Position from 2021 | string (32) | NULL | No | The player's primary position. Possible values: C; PF; PG; SF; SG |
| Starting from 2021 | bool (32) | NULL | Yes | Indicates whether this player is in the starting lineup or on the bench |
| Confirmed from 2021 | bool (32) | NULL | Yes | Indicated whether the 'Starting' field has been confirmed for a player |
| LineupStatus | string (50) | NULL | Yes | Indicates whether player is starting, active, or inactive |
MatchupTrends
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| UpcomingGame from 2020 | Game | NULL | No | Next scheduled game for the team with a specified opposing team |
| TeamTrends from 2020 | TeamTrends[] | NULL | No | The collection of team trends between each team |
| TeamMatchupTrends from 2020 | TeamGameTrends[] | NULL | No | The collection of team game trends against opponent |
| OpponentMatchupTrends from 2020 | TeamGameTrends[] | NULL | No | The collection of opponent game trends against team |
| PreviousGames from 2020 | Game[] | NULL | No | The collection of last 10 game scores between each team |
News
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| NewsID | integer (32) | NOT NULL | No | The unique ID of news story |
| Source | string (50) | NULL | No | The source of the story (RotoBaller, NBCSports.com, etc.) |
| Updated | datetime | NOT NULL | No | The timestamp of when this news story was last updated (in US Eastern Time) |
| TimeAgo | string (50) | NULL | No | How long ago this news story was published |
| Title | string (100) | NULL | No | The headline of the news story (typically less than 100 characters) |
| Content | string (5000) | NULL | No | The full body content of the story |
| Url | string (250) | NULL | No | The URL of the full news story |
| TermsOfUse | string (500) | NULL | No | The terms of use with using this news item, credit must be given to the originator of the story when specified in the terms of use |
| Author | string (50) | NULL | No | The author responsible for writing the news posting |
| Categories | string (100) | NULL | No | Comma delimited meta tags describing the categories of this content. Possible tags include: Top Headlines, Breaking News, Injury, Sit/Start, Waiver Wire, Risers, Fallers, Lineups, Transactions, Free Agents, Prospects/Rookies, Game Recap, Matchup Outlook |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| TeamID | integer (32) | NULL | No | The unique ID of the team that relates to this story |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team that relates to this news story |
| PlayerID2 | integer (32) | NULL | No | The PlayerID of the additional player who relates to this story (if applicable) |
| TeamID2 | integer (32) | NULL | No | The unique ID of the additional team that relates to this news story (if applicable) |
| Team2 | string (10) | NULL | No | The abbreviation [Key] of the additional team that relates to this story (if applicable) |
| OriginalSource from 2020 | string (100) | NULL | No | The original source who broke this news (before it was picked up by the publisher of this blurb) |
| OriginalSourceUrl from 2020 | string (1000) | NULL | No | The URL of the original source who broke this news blurb |
OpponentSeason
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stat |
| TeamID | integer (32) | NULL | No | The unique ID of the opponent team |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition) |
| Season | integer (32) | NULL | No | The NBA season for which these totals apply |
| Name | string (50) | NULL | No | Full name of the opponent team |
| Team | string (10) | NULL | No | The abbreviation [Key] of the opponent team |
| Wins | integer (32) | NULL | No | Total number of wins by the opponent team in the season |
| Losses | integer (32) | NULL | No | Total number of losses by the opponent team in the season |
| OpponentPosition | string (10) | NULL | No | Indicates which position is included in opponent stats that are aggregated together |
| Possessions | decimal (32) | NULL | Yes | Total estimated possessions by the opponent team in the season |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| OpponentStat | OpponentSeason | NULL | No | The aggregated season stats for this team's opponents |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (US Eastern Time) |
| Games | integer (32) | NULL | No | Total games played by the opponent team in the season |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the opponent team in the season |
| Minutes | integer (32) | NULL | Yes | Total minutes played by the opponent team in the season |
| Seconds | integer (32) | NULL | Yes | Total seconds played by the opponent team in the season |
| FieldGoalsMade | decimal (32) | NULL | Yes | Total field goals made by the opponent team in the season |
| FieldGoalsAttempted | decimal (32) | NULL | Yes | Total field goals attempted by the opponent team in the season |
| FieldGoalsPercentage | decimal (32) | NULL | Yes | Total field goal percentage (FG%) by the opponent team in the season |
| EffectiveFieldGoalsPercentage | decimal (32) | NULL | Yes | Total effective field goal percentage (eFG%) by the opponent team in the season |
| TwoPointersMade | decimal (32) | NULL | Yes | Total two pointers made by the opponent team in the season |
| TwoPointersAttempted | decimal (32) | NULL | Yes | Total two pointers attempted by the opponent team in the season |
| TwoPointersPercentage | decimal (32) | NULL | Yes | Total two point percentage by the opponent team in the season |
| ThreePointersMade | decimal (32) | NULL | Yes | Total three pointers made by the opponent team in the season |
| ThreePointersAttempted | decimal (32) | NULL | Yes | Total three pointers attempted by the opponent team in the season |
| ThreePointersPercentage | decimal (32) | NULL | Yes | Total three point percentage (3P%) by the opponent team in the season |
| FreeThrowsMade | decimal (32) | NULL | Yes | Total free throws made by the opponent team in the season |
| FreeThrowsAttempted | decimal (32) | NULL | Yes | Total free throws attempted by the opponent team in the season |
| FreeThrowsPercentage | decimal (32) | NULL | Yes | Total free throw percentage by the opponent team in the season |
| OffensiveRebounds | decimal (32) | NULL | Yes | Total offensive rebounds by the opponent team in the season |
| DefensiveRebounds | decimal (32) | NULL | Yes | Total defensive rebounds by the opponent team in the season |
| Rebounds | decimal (32) | NULL | Yes | Total rebounds by the opponent team in the season |
| OffensiveReboundsPercentage | decimal (32) | NULL | Yes | Total offensive rebound percentage (ORB%) by the opponent team in the season |
| DefensiveReboundsPercentage | decimal (32) | NULL | Yes | Total defensive rebound percentage (DRB%) by the opponent team in the season |
| TotalReboundsPercentage | decimal (32) | NULL | Yes | Total rebound percentage (TRB%) by the opponent team in the season |
| Assists | decimal (32) | NULL | Yes | Total assists by the opponent team in the season |
| Steals | decimal (32) | NULL | Yes | Total steals by the opponent team in the season |
| BlockedShots | decimal (32) | NULL | Yes | Total blocked shots by the opponent team in the season |
| Turnovers | decimal (32) | NULL | Yes | Total turnovers by the opponent team in the season |
| PersonalFouls | decimal (32) | NULL | Yes | Total personal fouls by the opponent team in the season |
| Points | decimal (32) | NULL | Yes | Total points scored by the opponent team in the season |
| TrueShootingAttempts | decimal (32) | NULL | Yes | Total true shooting attempts by the opponent team in the season |
| TrueShootingPercentage | decimal (32) | NULL | Yes | Total true shooting percentage (TS%) by the opponent team in the season |
| PlayerEfficiencyRating | decimal (32) | NULL | Yes | Total player efficiency rating by the opponent team (PER) in the season |
| AssistsPercentage | decimal (32) | NULL | Yes | Total assist percentage (AST%) by the opponent team in the season |
| StealsPercentage | decimal (32) | NULL | Yes | Total steal percentage (STL%) by the opponent team in the season |
| BlocksPercentage | decimal (32) | NULL | Yes | Total block percentage (BLK%) by the opponent team in the season |
| TurnOversPercentage | decimal (32) | NULL | Yes | Total turnover percentage (TOV%) by the opponent team in the season |
| UsageRatePercentage | decimal (32) | NULL | Yes | Total usage rate by the opponent team in the season |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total FanDuel daily fantasy points by the opponent team in the season |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings daily fantasy points by the opponent team in the season |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total Yahoo daily fantasy points by the opponent team in the season |
| PlusMinus | decimal (32) | NULL | Yes | Total plus minus by the opponent team in the season |
| DoubleDoubles | decimal (32) | NULL | Yes | Total double-doubles by the opponent team in the season |
| TripleDoubles | decimal (32) | NULL | Yes | Total triple-doubles by the opponent team in the season |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Total FantasyDraft daily fantasy points by the opponent team in the season |
| IsClosed | boolean | NOT NULL | No | This field is expected to be FALSE |
| LineupConfirmed | boolean | NULL | No | Indicates whether starting lineup is confirmed. Note: this field will be NULL when not referencing players |
| LineupStatus | string (50) | NULL | Yes | Indicates whether player is starting, active, or inactive |
Play
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayID from 2017 | integer (32) | NOT NULL | No | The unique identifier of the play. |
| QuarterID from 2017 | integer (32) | NOT NULL | No | The unique identifier of the Quarter that this play occurred in. |
| QuarterName from 2017 | string (10) | NOT NULL | No | The name of the quarter that this play occurred in |
| Sequence from 2017 | integer (32) | NOT NULL | No | The order in which this play happened over the course of the game. |
| TimeRemainingMinutes from 2017 | integer (32) | NULL | No | The number of minutes remaining in the quarter when this play occurred |
| TimeRemainingSeconds from 2017 | integer (32) | NULL | No | The number of seconds remaining in the quarter when the play occurred |
| AwayTeamScore from 2017 | integer (32) | NULL | Yes | Total number of points the away team scored after this play completed |
| HomeTeamScore from 2017 | integer (32) | NULL | Yes | Total points scored by the home team after the completion of this play |
| PotentialPoints from 2017 | integer (32) | NULL | Yes | The points that would have been potentially scored by the shot attempt (if any). |
| Points from 2017 | integer (32) | NULL | Yes | The points scores by the shot attempt (if any). |
| ShotMade from 2017 | boolean | NULL | Yes | Whether the shot was made (if any). |
| Category from 2017 | string (20) | NULL | Yes | The category the play. Possible values: Period, Timeout, JumpBall, Shot, Rebound, Foul, Substitution, Turnover, Challenge. |
| Type from 2017 | string (20) | NULL | Yes | The type of the play. Possible values: None, Period, Timeout, JumpBall, FieldGoalMade, FieldGoalMissed, FreeThrowMade, FreeThrowMissed, Rebound, Steal, Turnover, Foul, PersonalFoul, ShootingFoul, OffensiveFoul, LooseBallFoul, TechnicalFoul, FlagrantFoul, Traveling, Palming, Goaltending, KickedBall, LaneViolation, DelayOfGame, Substitution, Ejection, and Challenge. |
| TeamID from 2017 | integer (32) | NULL | No | The unique ID of the team associated with this play |
| Team from 2017 | string (10) | NULL | No | The abbreviation [Key] of the team associated with this play |
| OpponentID from 2017 | integer (32) | NULL | No | The unique ID of the opponent team associated with this play |
| Opponent from 2017 | string (10) | NULL | No | Abbreviation [Key] of the opponent team (e.g. LAL; PHI; BOS; CHI; etc.) |
| ReceivingTeamID from 2017 | integer (32) | NULL | No | The TeamID of the team that won the jump ball. |
| ReceivingTeam from 2017 | string (10) | NULL | No | The team abbreviation [Key] of the team that won the jump ball |
| Description from 2017 | string (250) | NULL | Yes | The description of the play. |
| PlayerID from 2017 | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| AssistedByPlayerID from 2017 | integer (32) | NULL | No | The PlayerID of the player who recorded an assist on a made field goal by another player (if applicable) |
| BlockedByPlayerID from 2017 | integer (32) | NULL | No | The PlayerID of the player who blocked the field goal attempt on this play (if any). |
| FastBreak from 2017 | boolean | NULL | Yes | Indicates whether this play happened on a fast break. |
| SideOfBasket from 2017 | string (10) | NULL | Yes | The side of the basket that the field goal was attempted from (if any). Possible values: L, R |
| Updated from 2017 | datetime | NULL | No | The timestamp of when this play was last updated (in US Eastern Time) |
| Created from 2017 | datetime | NULL | No | The database generated timestamp of when this play was first created (in US Eastern Time) |
| SubstituteInPlayerID from 2017 | integer (32) | NULL | No | The PlayerID of the player who substituted into the game. |
| SubstituteOutPlayerID from 2017 | integer (32) | NULL | No | The PlayerID of the player who substituted out of the game. |
| AwayPlayerID from 2017 | integer (32) | NULL | No | The PlayerID of the player who is involved in the play from the away team (if applicable) |
| HomePlayerID from 2017 | integer (32) | NULL | No | The PlayerID of the player who is involved in the play from the home team |
| ReceivingPlayerID from 2017 | integer (32) | NULL | No | The PlayerID of the player who received the ball |
| BaselineOffsetPercentage from 2017 | decimal (32) | NULL | Yes | The baseline offset percentage of where the ball was shot/passed |
| SidelineOffsetPercentage from 2017 | decimal (32) | NULL | Yes | The sideline offset percentage of where the ball was shot/passed |
| Coordinates from 2017 | string (10) | NULL | Yes | The x/y coordinates of where the ball was shot/passed |
| StolenByPlayerID from 2017 | integer (32) | NULL | Yes | The PlayerID of the player who stole the ball (if applicable) |
PlayByPlay
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Game | Game | NULL | No | The details of the game associated with this play-by-play |
| Quarters | Quarter[] | NULL | No | The details of the quarters associated with this play-by-play |
| Plays | Play[] | NULL | No | The details of the plays associated with this play-by-play |
Player
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerID | integer (32) | NOT NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| SportsDataID | string (50) | NULL | No | Deprecated. Use SportRadarPlayerID instead. |
| Status | string (10) | NULL | No | Indicates the player's status of being on an active roster. Possible values include: Active, Inactive |
| TeamID | integer (32) | NULL | No | The unique ID of the player's team |
| Team | string (10) | NULL | No | The abbreviation [Key] of the player's team |
| Jersey | integer (32) | NULL | No | The player's jersey number. |
| PositionCategory | string (10) | NULL | No | The player's position category. Possible values: C, F, G |
| Position | string (10) | NULL | No | The player's primary position. Possible values: PG; SG; SF; PF; C |
| FirstName | string (50) | NULL | No | The player's first name. |
| LastName | string (50) | NULL | No | The player's last name. |
| Height | integer (32) | NULL | No | The player's height in inches. |
| Weight | integer (32) | NULL | No | The player's weight in pounds (lbs). |
| BirthDate | datetime | NULL | No | The player's date of birth. |
| BirthCity | string (50) | NULL | No | The city in which the player was born. |
| BirthState | string (50) | NULL | No | The state in which the player was born. |
| BirthCountry | string (50) | NULL | No | The country in which the player was born. |
| HighSchool | string (50) | NULL | No | The high school that the player attended. |
| College | string (50) | NULL | No | The college that the player attended. |
| Salary | integer (32) | NULL | No | Deprecated (do not use) |
| PhotoUrl | string (250) | NULL | No | This field is deprecated. Photos are no longer available through it. Headshots are now delivered through IMAGN. Please see our Headshots products for further information. |
| Experience | integer (32) | NULL | No | The number of years experience the player has in the NBA. |
| SportRadarPlayerID | string (50) | NULL | No | The player's cross reference PlayerID to the SportRadar API. |
| RotoworldPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to the Rotoworld news feed. |
| RotoWirePlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to the RotoWire news feed. |
| FantasyAlarmPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to the FantasyAlarm news feed. |
| StatsPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to the STATS data feeds. |
| SportsDirectPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to the SportsDirect data feeds, now part of Nielsen GraceNote. |
| XmlTeamPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to the XML Team data feeds. |
| InjuryStatus | string (50) | NULL | Yes | The player's current injury status; in the form of likelihood that player plays Possible values: Probable; Questionable; Doubtful; Out |
| InjuryBodyPart | string (50) | NULL | Yes | The body part that is injured (Knee, Groin, Calf, Hamstring, etc.) |
| InjuryStartDate | date | NULL | No | The day that the injury started or first discovered. |
| InjuryNotes | string (250) | NULL | Yes | Brief description of the player's injury and expected availability. |
| FanDuelPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to FanDuel. |
| DraftKingsPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to DraftKings. |
| YahooPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to Yahoo Daily Fantasy Sports Contests. |
| FanDuelName | string (50) | NULL | No | The player's full name in FanDuel's daily fantasy sports platform. |
| DraftKingsName | string (50) | NULL | No | The player's full name in DraftKings' daily fantasy sports platform. |
| YahooName | string (50) | NULL | No | The player's full name in Yahoo's daily fantasy sports platform. |
| DepthChartPosition | string (10) | NULL | No | The position of the player on the depth chart. |
| DepthChartOrder | integer (32) | NULL | Yes | The order of the player on the depth chart. |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| FantasyDraftName | string (50) | NULL | No | The player's full name in FantasyDraft's daily fantasy sports platform. |
| FantasyDraftPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to Fantasy Draft. |
| UsaTodayPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to USA Today headshot data feeds. |
| UsaTodayHeadshotUrl | string (100) | NULL | No | The player's headshot URL as provided by USA Today. License from USA Today is required. |
| UsaTodayHeadshotNoBackgroundUrl | string (100) | NULL | No | The player's transparent background headshot URL as provided by USA Today. License from USA Today is required. |
| UsaTodayHeadshotUpdated | datetime | NULL | No | The last updated date of the player's headshot as provided by USA Today. License from USA Today is required. |
| UsaTodayHeadshotNoBackgroundUpdated | datetime | NULL | No | The last updated date of the player's transparent background headshot as provided by USA Today. License from USA Today is required. |
| NbaDotComPlayerID | integer (32) | NULL | No | The player's personID on nba dot com |
PlayerActiveBasic
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerID | integer (32) | NOT NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| SportsDataID | string (50) | NULL | No | Deprecated. Use SportRadarPlayerID instead. |
| Status | string (10) | NULL | No | Indicates the player's status of being on an active roster. Possible values include: Active, Inactive |
| TeamID | integer (32) | NULL | No | The unique ID of the player's team |
| Team | string (10) | NULL | No | The abbreviation [Key] of the player's team |
| Jersey | integer (32) | NULL | No | The player's jersey number. |
| PositionCategory | string (10) | NULL | No | The player's position category. Possible values: C, F, G |
| Position | string (10) | NULL | No | The player's primary position. Possible values: PG; SG; SF; PF; C |
| FirstName | string (50) | NULL | No | The player's first name. |
| LastName | string (50) | NULL | No | The player's last name. |
| BirthDate | datetime | NULL | No | The player's date of birth. |
| BirthCity | string (50) | NULL | No | The city in which the player was born. |
| BirthState | string (50) | NULL | No | The state in which the player was born. |
| BirthCountry | string (50) | NULL | No | The country in which the player was born. |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| Height | integer (32) | NULL | No | The player's height in inches. |
| Weight | integer (32) | NULL | No | The player's weight in pounds (lbs). |
PlayerBasic
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerID | integer (32) | NOT NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| SportsDataID | string (50) | NULL | No | Deprecated. Use SportRadarPlayerID instead. |
| Status | string (10) | NULL | No | Indicates the player's status of being on an active roster. Possible values include: Active, Inactive |
| TeamID | integer (32) | NULL | No | The unique ID of the player's team |
| Team | string (10) | NULL | No | The abbreviation [Key] of the player's team |
| Jersey | integer (32) | NULL | No | The player's jersey number. |
| PositionCategory | string (10) | NULL | No | The player's position category. Possible values: C, F, G |
| Position | string (10) | NULL | No | The player's primary position. Possible values: PG; SG; SF; PF; C |
| FirstName | string (50) | NULL | No | The player's first name. |
| LastName | string (50) | NULL | No | The player's last name. |
| BirthDate | datetime | NULL | No | The player's date of birth. |
| BirthCity | string (50) | NULL | No | The city in which the player was born. |
| BirthState | string (50) | NULL | No | The state in which the player was born. |
| BirthCountry | string (50) | NULL | No | The country in which the player was born. |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| Height | integer (32) | NULL | No | The player's height in inches. |
| Weight | integer (32) | NULL | No | The player's weight in pounds (lbs). |
PlayerGame
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stat |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition) |
| Season | integer (32) | NULL | No | The NBA season of the game |
| Name | string (50) | NULL | No | The name of the player |
| Team | string (10) | NULL | No | The abbreviation [Key] of the player's team |
| Position | string (10) | NULL | No | The player's position associated with the given game or season. Possible values: C, F, FC, G, GF, PF, PG, SF, SG |
| Started | integer (32) | NULL | No | Indicates whether or not the player started the game Note: this will be one or zero for single game feeds |
| FanDuelSalary from 2016 | integer (32) | NULL | Yes | The player's salary for FanDuel daily fantasy contests. |
| DraftKingsSalary from 2016 | integer (32) | NULL | Yes | The player's salary for DraftKings daily fantasy contests. |
| FantasyDataSalary from 2016 | integer (32) | NULL | Yes | The player's salary as calculated by SportsDataIO (formerly known as FantasyData). Based on the same salary cap as DraftKings contests ($50,000). |
| YahooSalary from 2016 | integer (32) | NULL | Yes | The player's salary for Yahoo daily fantasy contests. |
| InjuryStatus from 2016 | string (50) | NULL | Yes | The player's current injury status; in the form of likelihood that player plays. Possible values: Probable; Questionable; Doubtful; Out |
| InjuryBodyPart from 2016 | string (50) | NULL | Yes | The body part that is injured (Knee, Groin, Calf, Hamstring, etc.) |
| InjuryStartDate from 2016 | date | NULL | No | The day that the injury started or was first discovered. |
| InjuryNotes from 2016 | string (250) | NULL | Yes | Brief description of the player's injury and expected availability. |
| FanDuelPosition from 2016 | string (10) | NULL | No | The player's eligible position in FanDuel's daily fantasy sports platform. |
| DraftKingsPosition from 2016 | string (10) | NULL | No | The player's eligible position in DraftKings' daily fantasy sports platform. |
| YahooPosition from 2016 | string (10) | NULL | No | The player's eligible position in Yahoo's daily fantasy sports platform. |
| OpponentRank from 2016 | integer (32) | NULL | Yes | The ranking of the player's opponent with regards to fantasy points allowed. |
| OpponentPositionRank from 2016 | integer (32) | NULL | Yes | The ranking of the player's opponent by position with regards to fantasy points allowed. |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| FantasyDraftSalary from 2017 | integer (32) | NULL | Yes | The player's salary for Fantasy Draft's daily fantasy contests. |
| FantasyDraftPosition from 2017 | string (10) | NULL | Yes | The player's eligible position in Fantasy Draft's daily fantasy sports platform. |
| GameID | integer (32) | NULL | No | The unique ID of the game associated with this PlayerGame record |
| OpponentID | integer (32) | NULL | No | The unique ID of the team's opponent |
| Opponent | string (10) | NULL | No | Abbreviation [Key] of the opponent team (e.g. LAL; PHI; BOS; CHI; etc.) |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game |
| HomeOrAway | string (4) | NULL | No | Whether the team is home or away |
| IsGameOver | boolean | NOT NULL | No | Whether the game is over |
| GlobalGameID | integer (32) | NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| GlobalOpponentID | integer (32) | NULL | No | A globally unique ID for this opponent. This value is guaranteed to be unique across all sports/leagues. |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (US Eastern Time) |
| Games | integer (32) | NULL | No | The number of games played by the player in the game. Note: this will be one or zero for single game feeds |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the player in the game |
| Minutes | integer (32) | NULL | Yes | Total minutes played by the player in the game |
| Seconds | integer (32) | NULL | Yes | Total seconds played by the player in the game |
| FieldGoalsMade | decimal (32) | NULL | Yes | Total field goals made by the player in the game |
| FieldGoalsAttempted | decimal (32) | NULL | Yes | Total field goals attempted by the player in the game |
| FieldGoalsPercentage | decimal (32) | NULL | Yes | Total field goal percentage (FG%) by the player in the game |
| EffectiveFieldGoalsPercentage | decimal (32) | NULL | Yes | Total effective field goals percentage (eFG%) by the player in the game |
| TwoPointersMade | decimal (32) | NULL | Yes | Total two pointers made by the player in the game |
| TwoPointersAttempted | decimal (32) | NULL | Yes | Total two pointers attempted by the player in the game |
| TwoPointersPercentage | decimal (32) | NULL | Yes | Total two point percentage by the player in the game |
| ThreePointersMade | decimal (32) | NULL | Yes | Total three pointers made by the player in the game |
| ThreePointersAttempted | decimal (32) | NULL | Yes | Total three pointers attempted by the player in the game |
| ThreePointersPercentage | decimal (32) | NULL | Yes | Total three point percentage (3P%) by the player in the game |
| FreeThrowsMade | decimal (32) | NULL | Yes | Total free throws made by the player in the game |
| FreeThrowsAttempted | decimal (32) | NULL | Yes | Total free throws attempted by the player in the game |
| FreeThrowsPercentage | decimal (32) | NULL | Yes | Total free throw percentage by the player in the game |
| OffensiveRebounds | decimal (32) | NULL | Yes | Total offensive rebounds by the player in the game |
| DefensiveRebounds | decimal (32) | NULL | Yes | Total defensive rebounds by the player in the game |
| Rebounds | decimal (32) | NULL | Yes | Total rebounds by the player in the game (offensive and defensive rebounds) |
| OffensiveReboundsPercentage | decimal (32) | NULL | Yes | Total offensive rebound percentage (ORB%) by the player in the game |
| DefensiveReboundsPercentage | decimal (32) | NULL | Yes | Total defensive rebound percentage (DRB%) by the player in the game |
| TotalReboundsPercentage | decimal (32) | NULL | Yes | Total rebound percentage (TRB%) by the player in the game |
| Assists | decimal (32) | NULL | Yes | Total assists by the player in the game |
| Steals | decimal (32) | NULL | Yes | Total steals by the player in the game |
| BlockedShots | decimal (32) | NULL | Yes | Total blocked shots by the player in the game |
| Turnovers | decimal (32) | NULL | Yes | Total turnovers by the player in the game |
| PersonalFouls | decimal (32) | NULL | Yes | Total personal fouls by the player in the game |
| Points | decimal (32) | NULL | Yes | Total points scored by the player in the game |
| TrueShootingAttempts | decimal (32) | NULL | Yes | Total true shooting attempts (TSA) by the player in the game Fomula = FGA + 0.44 * FTA |
| TrueShootingPercentage | decimal (32) | NULL | Yes | Total true shooting percentage (TS%) by the player in the game |
| PlayerEfficiencyRating | decimal (32) | NULL | Yes | The player's linear weight efficiency rating (PER) in the game |
| AssistsPercentage | decimal (32) | NULL | Yes | Total assist percentage (AST%) by the player in the game |
| StealsPercentage | decimal (32) | NULL | Yes | Total steal percentage (STL%) by the player in the game |
| BlocksPercentage | decimal (32) | NULL | Yes | Total block percentage (BLK%) by the player in the game |
| TurnOversPercentage | decimal (32) | NULL | Yes | Total turnover percentage (TOV%) by the player in the game |
| UsageRatePercentage | decimal (32) | NULL | Yes | Total usage rate percentage by the player in the game |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total FanDuel daily fantasy points by the player in the game |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings daily fantasy points by the player in the game |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total Yahoo daily fantasy points by the player in the game |
| PlusMinus | decimal (32) | NULL | Yes | Total plus minus by the player in the game |
| DoubleDoubles | decimal (32) | NULL | Yes | "Total double-doubles by the player in the game. Note: a player can record maximum of 1 double double in a single game" |
| TripleDoubles | decimal (32) | NULL | Yes | Total triple-doubles by the player in the game. Note: player can record maximum of 1 double double in a single game |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Total FantasyDraft daily fantasy points by the player in the game |
| IsClosed | boolean | NOT NULL | No | Indicates whether the game is over and the stats for this player have been verified and closed out. |
| LineupConfirmed | boolean | NULL | No | Indicates whether the starting lineup is confirmed. Note: This field will be NULL when not referencing players |
| LineupStatus | string (50) | NULL | Yes | Indicates whether the player is starting, active, or inactive |
PlayerGameBasic
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (US Eastern Time) |
| Games | integer (32) | NULL | No | The number of games played by the player in the game. Note: this will be one or zero for single game feeds |
| Minutes | integer (32) | NULL | Yes | Total minutes played by the player in the game |
| Seconds | integer (32) | NULL | Yes | Total seconds played by the player in the game |
| FieldGoalsMade | decimal (32) | NULL | Yes | Total field goals made by the player in the game |
| FieldGoalsAttempted | decimal (32) | NULL | Yes | Total field goals attempted by the player in the game |
| FieldGoalsPercentage | decimal (32) | NULL | Yes | Total field goal percentage (FG%) by the player in the game |
| EffectiveFieldGoalsPercentage | decimal (32) | NULL | Yes | Total effective field goals percentage (eFG%) by the player in the game |
| TwoPointersMade | decimal (32) | NULL | Yes | Total two pointers made by the player in the game |
| TwoPointersAttempted | decimal (32) | NULL | Yes | Total two pointers attempted by the player in the game |
| TwoPointersPercentage | decimal (32) | NULL | Yes | Total two point percentage by the player in the game |
| ThreePointersMade | decimal (32) | NULL | Yes | Total three pointers made by the player in the game |
| ThreePointersAttempted | decimal (32) | NULL | Yes | Total three pointers attempted by the player in the game |
| ThreePointersPercentage | decimal (32) | NULL | Yes | Total three point percentage (3P%) by the player in the game |
| FreeThrowsMade | decimal (32) | NULL | Yes | Total free throws made by the player in the game |
| FreeThrowsAttempted | decimal (32) | NULL | Yes | Total free throws attempted by the player in the game |
| FreeThrowsPercentage | decimal (32) | NULL | Yes | Total free throw percentage by the player in the game |
| OffensiveRebounds | decimal (32) | NULL | Yes | Total offensive rebounds by the player in the game |
| DefensiveRebounds | decimal (32) | NULL | Yes | Total defensive rebounds by the player in the game |
| Rebounds | decimal (32) | NULL | Yes | Total rebounds by the player in the game (offensive and defensive rebounds) |
| OffensiveReboundsPercentage | decimal (32) | NULL | Yes | Total offensive rebound percentage (ORB%) by the player in the game |
| DefensiveReboundsPercentage | decimal (32) | NULL | Yes | Total defensive rebound percentage (DRB%) by the player in the game |
| TotalReboundsPercentage | decimal (32) | NULL | Yes | Total rebound percentage (TRB%) by the player in the game |
| Assists | decimal (32) | NULL | Yes | Total assists by the player in the game |
| Steals | decimal (32) | NULL | Yes | Total steals by the player in the game |
| BlockedShots | decimal (32) | NULL | Yes | Total blocked shots by the player in the game |
| Turnovers | decimal (32) | NULL | Yes | Total turnovers by the player in the game |
| PersonalFouls | decimal (32) | NULL | Yes | Total personal fouls by the player in the game |
| Points | decimal (32) | NULL | Yes | Total points scored by the player in the game |
| TrueShootingAttempts | decimal (32) | NULL | Yes | Total true shooting attempts (TSA) by the player in the game |
| TrueShootingPercentage | decimal (32) | NULL | Yes | Total true shooting percentage (TS%) by the player in the game |
| PlayerEfficiencyRating | decimal (32) | NULL | Yes | The player's linear weight efficiency rating (PER) in the game |
| AssistsPercentage | decimal (32) | NULL | Yes | Total assist percentage (AST%) by the player in the game |
| StealsPercentage | decimal (32) | NULL | Yes | Total steal percentage (STL%) by the player in the game |
| BlocksPercentage | decimal (32) | NULL | Yes | Total block percentage (BLK%) by the player in the game |
| TurnOversPercentage | decimal (32) | NULL | Yes | Total turnover percentage (TOV%) by the player in the game |
| UsageRatePercentage | decimal (32) | NULL | Yes | Total usage rate percentage by the player in the game |
| PlusMinus | decimal (32) | NULL | Yes | Total plus minus by the player in the game |
| DoubleDoubles | decimal (32) | NULL | Yes | Total double-doubles by the player in the game. Note: player can record maximum of 1 double double in a single game |
| TripleDoubles | decimal (32) | NULL | Yes | Total triple-doubles by the player in the game. Note: player can record maximum of 1 double double in a single game |
| IsClosed | boolean | NOT NULL | No | Indicates whether the game is over and the stats for this player have been verified and closed out. |
| LineupConfirmed | boolean | NULL | No | Indicates whether starting lineup is confirmed. Note: This field will be NULL when not referencing players |
| LineupStatus | string (50) | NULL | Yes | Indicates whether player is starting, active, or inactive |
| GameID | integer (32) | NULL | No | The unique ID of the game associated with this PlayerGame record |
| OpponentID | integer (32) | NULL | No | The unique ID of the team's opponent |
| Opponent | string (10) | NULL | No | Abbreviation [Key] of the opponent team (e.g. LAL; PHI; BOS; CHI; etc.) |
| Day | date | NOT NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game |
| HomeOrAway | string (4) | NULL | No | Whether the team is home or away |
| IsGameOver | boolean | NOT NULL | No | Whether the game is over |
| GlobalGameID | integer (32) | NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| GlobalOpponentID | integer (32) | NULL | No | A globally unique ID for this opponent. This value is guaranteed to be unique across all sports/leagues. |
| StatID | integer (32) | NOT NULL | No | The unique ID of the stat |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition). |
| Season | integer (32) | NULL | No | The NBA season of the game |
| Name | string (50) | NULL | No | The name of the player |
| Team | string (10) | NULL | No | The abbreviation [Key] of the player's team |
| Position | string (10) | NULL | No | The player's position associated with the given game or season. Possible values: C, F, FC, G, GF, PF, PG, SF, SG |
| Started | integer (32) | NULL | No | Indicates whether or not the player started the game. Note: this will be one or zero for single game feeds |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
PlayerGameProjection
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stat |
| TeamID | integer (32) | NULL | No | The unique ID of the player's team |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition) |
| Season | integer (32) | NULL | No | The NBA season of the game |
| Name | string (50) | NULL | No | The name of the player |
| Team | string (10) | NULL | No | The abbreviation [Key] of the player's team |
| Position | string (10) | NULL | No | The player's position associated with the given game or season. Possible values: PG; SG; SF; PF; C |
| Started | integer (32) | NULL | No | "Indicates whether or not the player is projected to start in the game. Note: this will be one or zero for single game feeds" |
| FanDuelSalary from 2016 | integer (32) | NULL | Yes | The player's salary for FanDuel daily fantasy contests. |
| DraftKingsSalary from 2016 | integer (32) | NULL | Yes | The player's salary for DraftKings daily fantasy contests. |
| FantasyDataSalary from 2016 | integer (32) | NULL | Yes | The player's salary as calculated by SportsDataIO (formerly known as FantasyData). Based on the same salary cap as DraftKings contests ($50,000). |
| YahooSalary from 2016 | integer (32) | NULL | Yes | The player's salary for Yahoo daily fantasy contests. |
| InjuryStatus from 2016 | string (50) | NULL | Yes | The player's current injury status; in the form of likelihood that player plays. Possible values: Probable; Questionable; Doubtful; Out |
| InjuryBodyPart from 2016 | string (50) | NULL | Yes | The body part that is injured (Knee, Groin, Calf, Hamstring, etc.) |
| InjuryStartDate from 2016 | date | NULL | No | The day that the injury started or was first discovered. |
| InjuryNotes from 2016 | string (250) | NULL | Yes | Brief description of the player's injury and expected availability. |
| FanDuelPosition from 2016 | string (10) | NULL | No | The player's eligible position in FanDuel's daily fantasy sports platform. |
| DraftKingsPosition from 2016 | string (10) | NULL | No | The player's eligible position in DraftKings' daily fantasy sports platform |
| YahooPosition from 2016 | string (10) | NULL | No | The player's eligible position in Yahoo's daily fantasy sports platform. |
| OpponentRank from 2016 | integer (32) | NULL | Yes | The ranking of the player's opponent with regards to fantasy points allowed. |
| OpponentPositionRank from 2016 | integer (32) | NULL | Yes | The ranking of the player's opponent by position with regards to fantasy points allowed. |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| FantasyDraftSalary from 2017 | integer (32) | NULL | Yes | The player's salary for Fantasy Draft's daily fantasy contests. |
| FantasyDraftPosition from 2017 | string (10) | NULL | Yes | The player's eligible position in Fantasy Draft's daily fantasy sports platform. |
| GameID | integer (32) | NULL | No | The unique ID of the game associated with this PlayerGameProjection. |
| OpponentID | integer (32) | NULL | No | The unique ID of the team's opponent |
| Opponent | string (10) | NULL | No | Abbreviation [Key] of the opponent team (e.g. LAL; PHI; BOS; CHI; etc.) |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game |
| HomeOrAway | string (4) | NULL | No | Whether the team is home or away |
| IsGameOver | boolean | NOT NULL | No | Whether the game is over (true/false) |
| GlobalGameID | integer (32) | NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues |
| GlobalOpponentID | integer (32) | NULL | No | A globally unique ID for this opponent. This value is guaranteed to be unique across all sports/leagues. |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (in US Eastern Time) |
| Games | integer (32) | NULL | No | The projected number of games played by the player in the game. Note: this will be one or zero for single game feeds |
| FantasyPoints | decimal (32) | NULL | Yes | Total projected fantasy points by the player in the game |
| Minutes | integer (32) | NULL | Yes | Total projected minutes played by the player in the game |
| Seconds | integer (32) | NULL | Yes | Total projected seconds played by the player in the game |
| FieldGoalsMade | decimal (32) | NULL | Yes | Total projected field goals made by the player in the game |
| FieldGoalsAttempted | decimal (32) | NULL | Yes | Total projected field goals attempted by the player in the game |
| FieldGoalsPercentage | decimal (32) | NULL | Yes | Total projected field goal percentage (FG%) by the player in the game |
| EffectiveFieldGoalsPercentage | decimal (32) | NULL | Yes | Total effective field goals percentage (eFG%) by the player in the game |
| TwoPointersMade | decimal (32) | NULL | Yes | Total projected two pointers made by the player in the game |
| TwoPointersAttempted | decimal (32) | NULL | Yes | Total projected two pointers attempted by the player in the game |
| TwoPointersPercentage | decimal (32) | NULL | Yes | Total projected two point percentage by the player in the game |
| ThreePointersMade | decimal (32) | NULL | Yes | Total projected three pointers made by the player in the game |
| ThreePointersAttempted | decimal (32) | NULL | Yes | Total projected three pointers attempted by the player in the game |
| ThreePointersPercentage | decimal (32) | NULL | Yes | Total projected three point percentage (3P%) by the player in the game |
| FreeThrowsMade | decimal (32) | NULL | Yes | Total projected free throws made by the player in the game |
| FreeThrowsAttempted | decimal (32) | NULL | Yes | Total projected free throws attempted by the player in the game |
| FreeThrowsPercentage | decimal (32) | NULL | Yes | Total projected free throw percentage (FT%) by the player in the game |
| OffensiveRebounds | decimal (32) | NULL | Yes | Total projected offensive rebounds by the player in the game |
| DefensiveRebounds | decimal (32) | NULL | Yes | Total projected defensive rebounds by the player in the game |
| Rebounds | decimal (32) | NULL | Yes | Total projected rebounds by the player in the game (offensive and defensive rebounds) |
| OffensiveReboundsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| DefensiveReboundsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| TotalReboundsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| Assists | decimal (32) | NULL | Yes | Total projected assists by the player in the game |
| Steals | decimal (32) | NULL | Yes | Total projected steals by the player in the game |
| BlockedShots | decimal (32) | NULL | Yes | Total projected blocked shots by the player in the game |
| Turnovers | decimal (32) | NULL | Yes | Total projected turnovers by the player in the game |
| PersonalFouls | decimal (32) | NULL | Yes | Total projected personal fouls by the player in the game |
| Points | decimal (32) | NULL | Yes | Total projected point scored by the player in the game |
| TrueShootingAttempts | decimal (32) | NULL | Yes | Total projected true shooting attempts (TSA) by the player in the game |
| TrueShootingPercentage | decimal (32) | NULL | Yes | Total projected true shooting percentage (TS%) by the player in the game |
| PlayerEfficiencyRating | decimal (32) | NULL | Yes | This field is expected to be NULL |
| AssistsPercentage | decimal (32) | NULL | Yes | Total projected assist percentage (AST%) by the player in the game |
| StealsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| BlocksPercentage | decimal (32) | NULL | Yes | Total projected block percentage (BLK%) by the player in the game |
| TurnOversPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| UsageRatePercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total projected FanDuel daily projected fantasy points by the player in the game |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total projected DraftKings daily fantasy points by the player in the game |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total projected Yahoo daily projected fantasy points by the player in the game |
| PlusMinus | decimal (32) | NULL | Yes | Total projected plus minus by the player in the game |
| DoubleDoubles | decimal (32) | NULL | Yes | Total projected double-doubles by the player in the game |
| TripleDoubles | decimal (32) | NULL | Yes | Total projected triple-doubles by the player in the game |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Total projected FantasyDraft daily projected fantasy points by the player in the game |
| IsClosed | boolean | NOT NULL | No | This field is expected to be FALSE |
| LineupConfirmed | boolean | NULL | No | Indicates whether starting lineup is confirmed Note: This field will be NULL when not referencing players |
| LineupStatus | string (50) | NULL | Yes | Indicates whether player is starting, active, or inactive |
PlayerInfo
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerID | integer (32) | NOT NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| Name | string (50) | NULL | No | The player's full name |
| TeamID | integer (32) | NULL | No | The unique ID of the player's team |
| Team | string (50) | NULL | No | The abbreviation [Key] of the player's team |
| Position | string (50) | NULL | Yes | The player's primary position. Possible values: C; PF; PG; SF; SG |
PlayerSeason
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stat |
| TeamID | integer (32) | NULL | No | The unique ID of the player's team |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition). |
| Season | integer (32) | NULL | No | The NBA season in which these totals apply |
| Name | string (50) | NULL | No | The name of the player |
| Team | string (10) | NULL | No | The abbreviation [Key] of the player's team |
| Position | string (10) | NULL | No | The player's position associated with the given game or season. Possible values: PG; SG; SF; PF; C |
| Started | integer (32) | NULL | No | Indicates how many games the player has started in the season |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (US Eastern Time) |
| Games | integer (32) | NULL | No | The number of games played by the player in the season |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the player in the season |
| Minutes | integer (32) | NULL | Yes | Total minutes played by the player in the season |
| Seconds | integer (32) | NULL | Yes | Total seconds played by the player in the season |
| FieldGoalsMade | decimal (32) | NULL | Yes | Total field goals made by the player in the season |
| FieldGoalsAttempted | decimal (32) | NULL | Yes | Total field goals attempted by the player in the season |
| FieldGoalsPercentage | decimal (32) | NULL | Yes | Total field goal percentage (FG%) by the player in the season |
| EffectiveFieldGoalsPercentage | decimal (32) | NULL | Yes | Total effective field goals percentage (eFG%) by the player in the season |
| TwoPointersMade | decimal (32) | NULL | Yes | Total two pointers made by the player in the season |
| TwoPointersAttempted | decimal (32) | NULL | Yes | Total two pointers attempted by the player in the season |
| TwoPointersPercentage | decimal (32) | NULL | Yes | Total two point percentage by the player in the season |
| ThreePointersMade | decimal (32) | NULL | Yes | Total three pointers made by the player in the season |
| ThreePointersAttempted | decimal (32) | NULL | Yes | Total three pointers attempted by the player in the season |
| ThreePointersPercentage | decimal (32) | NULL | Yes | Total three point percentage (3P%) by the player in the season |
| FreeThrowsMade | decimal (32) | NULL | Yes | Total free throws made by the player in the season |
| FreeThrowsAttempted | decimal (32) | NULL | Yes | Total free throws attempted by the player in the season |
| FreeThrowsPercentage | decimal (32) | NULL | Yes | Total free throw percentage by the player in the season |
| OffensiveRebounds | decimal (32) | NULL | Yes | Total offensive rebounds by the player in the season |
| DefensiveRebounds | decimal (32) | NULL | Yes | Total defensive rebounds by the player in the season |
| Rebounds | decimal (32) | NULL | Yes | Total rebounds by the team in the game (offensive and defensive rebounds) |
| OffensiveReboundsPercentage | decimal (32) | NULL | Yes | Total offensive rebound percentage (ORB%) by the player in the season |
| DefensiveReboundsPercentage | decimal (32) | NULL | Yes | Total defensive rebound percentage (DRB%) by the player in the season |
| TotalReboundsPercentage | decimal (32) | NULL | Yes | Total rebound percentage (TRB%) by the player in the season |
| Assists | decimal (32) | NULL | Yes | Total assists by the player in the season |
| Steals | decimal (32) | NULL | Yes | Total steals by the player in the season |
| BlockedShots | decimal (32) | NULL | Yes | Total blocked shots by the player in the season |
| Turnovers | decimal (32) | NULL | Yes | Total turnovers by the player in the season |
| PersonalFouls | decimal (32) | NULL | Yes | Total personal fouls by the player in the season |
| Points | decimal (32) | NULL | Yes | Total points scored by the player in the season |
| TrueShootingAttempts | decimal (32) | NULL | Yes | Total true shooting attempts (TSA) by the player in the season |
| TrueShootingPercentage | decimal (32) | NULL | Yes | Total true shooting percentage (TS%) by the player in the season |
| PlayerEfficiencyRating | decimal (32) | NULL | Yes | The player's linear weight efficiency rating (PER) in the season |
| AssistsPercentage | decimal (32) | NULL | Yes | Total assist percentage (AST%) by the player in the season |
| StealsPercentage | decimal (32) | NULL | Yes | Total steal percentage (STL%) by the player in the season |
| BlocksPercentage | decimal (32) | NULL | Yes | Total block percentage (BLK%) by the player in the season |
| TurnOversPercentage | decimal (32) | NULL | Yes | Total turnover percentage (TOV%) by the player in the season |
| UsageRatePercentage | decimal (32) | NULL | Yes | Total usage rate percentage by the player in the season |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total FanDuel daily fantasy points by the player in the season |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings daily fantasy points by the player in the season |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total Yahoo daily fantasy points by the player in the season |
| PlusMinus | decimal (32) | NULL | Yes | Total plus minus by the player in the season |
| DoubleDoubles | decimal (32) | NULL | Yes | Total double-doubles by the player in the season |
| TripleDoubles | decimal (32) | NULL | Yes | Total triple-doubles by the player in the season |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Total FantasyDraft daily fantasy points by the player in the season |
| IsClosed | boolean | NOT NULL | No | This field is expected to be FALSE |
| LineupConfirmed | boolean | NULL | No | This field is expected to be NULL |
| LineupStatus | string (50) | NULL | Yes | This field is expected to be NULL |
PlayerSeasonProjection
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stat |
| TeamID | integer (32) | NULL | No | The unique ID of the player's team |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition) |
| Season | integer (32) | NULL | No | The NBA season for which these totals apply |
| Name | string (50) | NULL | No | Player's name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the player's team |
| Position | string (10) | NULL | No | The player's position associated with the given game or season. Possible values: PG; SG; SF; PF; C |
| Started | integer (32) | NULL | No | Indicates how many games the player is projected to start in the season |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (in US Eastern Time) |
| Games | integer (32) | NULL | No | The projected number of games played by the player in the season |
| FantasyPoints | decimal (32) | NULL | Yes | Total projected fantasy points by the player in the season |
| Minutes | integer (32) | NULL | Yes | Total projected minutes played by the player in the season |
| Seconds | integer (32) | NULL | Yes | Total projected seconds played by the player in the season |
| FieldGoalsMade | decimal (32) | NULL | Yes | Total projected field goals made by the player in the season |
| FieldGoalsAttempted | decimal (32) | NULL | Yes | Total projected field goals attempted by the player in the season |
| FieldGoalsPercentage | decimal (32) | NULL | Yes | Total projected field goal percentage (FG%) by the player in the season |
| EffectiveFieldGoalsPercentage | decimal (32) | NULL | Yes | Total projected effective field goals percentage (eFG%) by the player in the season |
| TwoPointersMade | decimal (32) | NULL | Yes | Total projected two pointers made by the player in the season |
| TwoPointersAttempted | decimal (32) | NULL | Yes | Total projected two pointers attempted by the player in the season |
| TwoPointersPercentage | decimal (32) | NULL | Yes | Total projected two point percentage by the player in the season |
| ThreePointersMade | decimal (32) | NULL | Yes | Total projected three pointers made by the player in the season |
| ThreePointersAttempted | decimal (32) | NULL | Yes | Total projected three pointers attempted by the player in the season |
| ThreePointersPercentage | decimal (32) | NULL | Yes | Total projected three point percentage (3P%) by the player in the season |
| FreeThrowsMade | decimal (32) | NULL | Yes | Total projected free throws made by the player in the season |
| FreeThrowsAttempted | decimal (32) | NULL | Yes | Total projected free throws attempted by the player in the season |
| FreeThrowsPercentage | decimal (32) | NULL | Yes | Total projected free throw percentage by the player in the season |
| OffensiveRebounds | decimal (32) | NULL | Yes | Total projected offensive rebounds by the player in the season |
| DefensiveRebounds | decimal (32) | NULL | Yes | Total projected defensive rebounds by the player in the season |
| Rebounds | decimal (32) | NULL | Yes | Total projected rebounds by the player in the season (offensive and defensive rebounds) |
| OffensiveReboundsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| DefensiveReboundsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| TotalReboundsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| Assists | decimal (32) | NULL | Yes | Total projected assists by the player in the season |
| Steals | decimal (32) | NULL | Yes | Total projected steals by the player in the season |
| BlockedShots | decimal (32) | NULL | Yes | Total projected blocked shots by the player in the season |
| Turnovers | decimal (32) | NULL | Yes | Total projected turnovers by the player in the season |
| PersonalFouls | decimal (32) | NULL | Yes | Total projected personal fouls by the player in the season |
| Points | decimal (32) | NULL | Yes | Total projected points scored by the player in the season |
| TrueShootingAttempts | decimal (32) | NULL | Yes | Total projected true shooting attempts (TSA) by the player in the season |
| TrueShootingPercentage | decimal (32) | NULL | Yes | "Total projected true shooting percentage (TS%) by the player in the season |
| PlayerEfficiencyRating | decimal (32) | NULL | Yes | This field is expected to be NULL |
| AssistsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| StealsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| BlocksPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| TurnOversPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| UsageRatePercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total projected FanDuel daily projected fantasy points by the player in the season |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total projected DraftKings daily fantasy points by the player in the season |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total projected Yahoo daily projected fantasy points by the player in the season |
| PlusMinus | decimal (32) | NULL | Yes | Total projected plus minus by the player in the season |
| DoubleDoubles | decimal (32) | NULL | Yes | Total projected double-doubles by the player in the season |
| TripleDoubles | decimal (32) | NULL | Yes | Total projected triple-doubles by the player in the season |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Total projected FantasyDraft daily projected fantasy points by the player in the season |
| IsClosed | boolean | NOT NULL | No | This field is expected to be FALSE |
| LineupConfirmed | boolean | NULL | No | Indicates whether starting lineup is confirmed Note: This field will be NULL when not referencing players |
| LineupStatus | string (50) | NULL | Yes | Indicates whether player is starting; active; or inactive |
Quarter
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| QuarterID | integer (32) | NOT NULL | No | Unique identifier for each Quarter. |
| GameID | integer (32) | NOT NULL | No | The unique ID of the game associated with this quarter |
| Number | integer (32) | NOT NULL | No | The Number (Order) of the Quarter in the scope of the Game. |
| Name | string (10) | NOT NULL | No | The Name of the Quarter (possible values: 1, 2, 3, 4, OT, OT2, OT3, etc) |
| AwayScore | integer (32) | NULL | Yes | The total points scored by the away team in the given period only |
| HomeScore | integer (32) | NULL | Yes | The total points scored by the home team in the given period only |
Referee
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| RefereeID from 2021 | integer (32) | NOT NULL | No | Unique ID of Referee |
| Name from 2021 | string (32) | NULL | No | The referee's full name |
| Number from 2021 | integer (32) | NULL | No | The number of the referee |
| Position from 2021 | string (32) | NULL | No | The position of the referee in the crew |
| College from 2021 | string (32) | NULL | No | The college of the referee |
| Experience from 2021 | integer (32) | NULL | No | The number of years of experience the referee has in the NBA |
RotoworldPlayerNewsItem (From 2022)
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| RotoworldPlayerNewsLine | string (50) | NOT NULL | No | Rotoworld Player News Item ID/GUID |
| Headline | string (50) | NOT NULL | No | The short headline of the news item |
| Comment | string (500) | NOT NULL | No | The longer headline used on Rotoworld Player News article |
| Impact | string (1000) | NOT NULL | No | The body of the news item |
| RotoworldCreated | date | NOT NULL | No | The date the news item was created as listed by Rotoworld Player News |
| RotoworldLastUpdated | date | NOT NULL | No | The time of the last update to this news item as listed by Rotoworld Player News |
| IsTopNews | bool | NOT NULL | No | A flag for top news items as listed by Rotoworld Player News |
| IsTransaction | bool | NULL | No | A flag to indicate this news item relates to a transaction as listed by Rotoworld Player News |
| IsRumor | bool | NULL | No | A flag to indicate the news item relates to a rumor as listed by Rotoworld Player News |
| MoreLink | string (1000) | NULL | No | A link to a source for the information in the news article |
| MoreName | string (100) | NULL | Yes | The name of the source for the info in the article |
| PlayerInfo | PlayerInfo (1000) | NULL | No | Information about the player related to the article |
| RotoworldPlayerMeta | RotoworldPlayerNewsPlayerMetaData (1000) | NULL | No | Lots of Player and Team information pertaining to the relevant player & team related to the news article as listed by Rotoworld Player News |
RotoworldPlayerNewsPlayerMetaData (From 2022)
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerFirstName | string (50) | NOT NULL | No | The first name of the player as listed by Rotoworld Player News |
| PlayerLastName | string (50) | NOT NULL | No | The last name of the player as listed by Rotoworld Player News |
| RotoworldPlayerId | string (50) | NOT NULL | No | The Rotoworld Player ID/GUID of the player related to the news item as listed by Rotoworld Player News |
| StatsPlayerID | int (32) | NULL | No | The Stats Player ID of the player related to the news item as listed by Rotoworld Player News |
| SportRadarID | string (100) | NULL | Yes | The SportRadar Player ID of the player related to the news item as listed by Rotoworld Player News |
| PlayerStatus | string (50) | NULL | No | The status of the player related to the news item as listed by Rotoworld Player News |
| TeamKey | string (5) | NULL | No | The abbreviation [Key] of the team associated with this market |
| TeamCity | string (50) | NULL | No | The city of the team related to this news story |
| TeamName | string (50) | NULL | No | The name of the team related to this news story |
| TeamColor | string (6) | NULL | No | The hex color of the team related to this news story |
ScheduleBasic
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID | integer (32) | NOT NULL | No | The unique ID of this game |
| Season | integer (32) | NOT NULL | No | The NBA season of the game |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition). |
| Status | string (20) | NULL | No | Indicates the game's status. Possible values include: Scheduled, InProgress, Final, F/OT, Suspended, Postponed, Delayed, Canceled, Forfeit, NotNecessary |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game |
| AwayTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the away team |
| HomeTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the home team |
| AwayTeamID | integer (32) | NOT NULL | No | The unique ID of the away team |
| HomeTeamID | integer (32) | NOT NULL | No | The unique ID of the home team |
| StadiumID | integer (32) | NULL | No | The unique ID of the stadium |
| AwayTeamScore | integer (32) | NULL | No | Total number of points the away team scored in the game |
| HomeTeamScore | integer (32) | NULL | No | Total number of points the home team scored in this game |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (US Eastern Time). |
| GlobalGameID | integer (32) | NOT NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| GlobalAwayTeamID | integer (32) | NOT NULL | No | A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues. |
| GlobalHomeTeamID | integer (32) | NOT NULL | No | A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues. |
| IsClosed | boolean | NOT NULL | No | Indicates whether the game is over and the final score has been verified and closed out. Note: it is recommend for bet resulting to use IsClosed = True rather than simply Final game status |
| NeutralVenue | boolean | NULL | No | Indicates whether this game is played in a neutral venue or not |
| DateTimeUTC | datetime | NULL | No | The date and time of the game in UTC |
| GameEndDateTIme | datetime | NULL | No | The date and time that the game ended in US Eastern Time |
| RescheduledFromGameID | integer (32) | NULL | Yes | The GameID of the originally scheduled, postponed game, that this game was rescheduled from. This only pertains to games that are scheduled as "make up" games. |
| RescheduledGameID | integer (32) | NULL | Yes | The GameID of the game that was rescheduled from this game. This only pertains to postponed games that require rescheduling. |
ScoreBasic
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameEndDateTime | datetime | NULL | No | The date and time that the game ended in US Eastern Time |
| SeriesInfo | Series (32) | NULL | No | Contains relevant series data for playoff series only - HomeTeamWins, AwayTeamWins, GameNumber, and MaxLength |
| AwayTeamScore2 | integer (32) | NULL | Yes | Total number of points the away team scored in the game |
| HomeTeamScore2 | integer (32) | NULL | Yes | Total number of points the home team scored in this game |
| GameID | integer (32) | NOT NULL | No | The unique ID of this game |
| Season | integer (32) | NOT NULL | No | The NBA season of the game |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition). |
| Status | string (20) | NULL | No | Indicates the game's status. Possible values include: Scheduled, InProgress, Final, F/OT, Suspended, Postponed, Delayed, Canceled, Forfeit, NotNecessary |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game |
| AwayTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the away team |
| HomeTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the home team |
| AwayTeamID | integer (32) | NOT NULL | No | The unique ID of the away team |
| HomeTeamID | integer (32) | NOT NULL | No | The unique ID of the home team |
| StadiumID | integer (32) | NULL | No | The unique ID of the stadium |
| AwayTeamScore | integer (32) | NULL | No | Total number of points the away team scored in the game |
| HomeTeamScore | integer (32) | NULL | No | Total number of points the home team scored in this game |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (US Eastern Time). |
| GlobalGameID | integer (32) | NOT NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| GlobalAwayTeamID | integer (32) | NOT NULL | No | A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues. |
| GlobalHomeTeamID | integer (32) | NOT NULL | No | A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues. |
| IsClosed | boolean | NOT NULL | No | "Indicates whether the game is over and the final score has been verified and closed out. Note: it is recommend for bet resulting to use ""IsClosed"" rather than simply ""Final"" game status" |
| NeutralVenue | boolean | NULL | No | Indicates whether this game is played in a neutral venue or not |
| DateTimeUTC | datetime | NULL | No | The date and time of the game in UTC |
| GameEndDateTIme | datetime | NULL | No | The date and time that the game ended in US Eastern Time |
| RescheduledFromGameID | integer (32) | NULL | Yes | The GameID of the originally scheduled, postponed game, that this game was rescheduled from. This only pertains to games that are scheduled as "make up" games. |
| RescheduledGameID | integer (32) | NULL | Yes | The GameID of the game that was rescheduled from this game. This only pertains to postponed games that require rescheduling. |
Season
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Season | integer (32) | NOT NULL | No | The NBA season that these totals apply for |
| StartYear | integer (32) | NOT NULL | No | The year in which the season started |
| EndYear | integer (32) | NOT NULL | No | The year in which the season ended |
| Description | string (10) | NULL | No | The description of the season for display purposes (possible values include: 2017-18, 2018-19, etc) |
| RegularSeasonStartDate | date | NULL | No | The start date of the regular season |
| PostSeasonStartDate | date | NULL | No | The start date of the postseason |
| SeasonType | string (10) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition). |
| ApiSeason | string (10) | NULL | No | The string to pass into subsequent API calls in the season parameter (e.g. 2025REG, 2025POST, etc.) |
Series
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| HomeTeamWins | integer (32) | NOT NULL | No | Total number of wins by the home team in the series |
| AwayTeamWins | integer (32) | NOT NULL | No | Total wins in the series by the away team |
| GameNumber | integer (32) | NOT NULL | No | The game number in the series |
| MaxLength | integer (32) | NOT NULL | No | The maximum number of games that can be played in a series |
Sportsbook
Available Endpoints
This table is used in the following endpoints:
-
Props
- Betting Events - by Date
- Betting Events - by Season
- Betting Markets - by Event
- Betting Markets - by Market Type
- Betting Markets - by Game
- Betting Player Props - by Game
- Betting Markets - by Event [Sportsbook Group]
- Betting Markets - by Game [Sportsbook Group]
- Betting Markets - by Market Type [Sportsbook Group]
- Betting Player Props - by Game [Sportsbook Group]
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SportsbookID | int (32) | NOT NULL | No | The unique identifier of the sportsbook |
| Name | string (32) | NOT NULL | Yes | The name of the sportsbooks |
Stadium
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StadiumID | integer (32) | NOT NULL | No | The unique ID of the stadium |
| Active | boolean | NOT NULL | No | Whether or not this stadium is the home venue for an active team |
| Name | string (50) | NOT NULL | No | The full name of the stadium |
| Address | string (50) | NULL | No | The address where the stadium is located |
| City | string (50) | NULL | No | The city where the stadium is located |
| State | string (10) | NULL | No | The US state in which the stadium is located. Note: If the stadium is outside of the US, this value is NULL |
| Zip | string (10) | NULL | No | The zip code of the stadium |
| Country | string (10) | NULL | No | The 2-digit country code where the stadium is located |
| Capacity | integer (32) | NULL | No | The estimated seating capacity of the stadium |
| GeoLat | decimal (32) | NULL | No | The geographic latitude coordinate of this venue. |
| GeoLong | decimal (32) | NULL | No | The geographic longitude coordinate of this venue. |
Standing
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Season | integer (32) | NOT NULL | No | The NBA season that these totals apply for |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition). |
| TeamID | Integer (32) | NOT NULL | No | The unique ID for the team |
| Key | string (10) | NOT NULL | No | The key (short team name) of the team |
| City | string (50) | NULL | No | The city/location of the team (e.g. Los Angeles; Philadelphia; Boston; Chicago; etc.) |
| Name | string (50) | NULL | No | The team's full name |
| Conference | string (20) | NULL | No | The conference of the team (can either be Eastern or Western) |
| Division | string (20) | NULL | No | The division of the team (e.g. Atlantic, Central, Southeast, etc.) |
| Wins | integer (32) | NULL | No | Total wins by the team |
| Losses | integer (32) | NULL | No | Total losses by the team |
| Percentage | decimal (32) | NULL | No | The team's winning percentage |
| ConferenceWins | integer (32) | NULL | No | Total conference wins |
| ConferenceLosses | integer (32) | NULL | No | Total conference losses |
| DivisionWins | integer (32) | NULL | No | Total number of division wins |
| DivisionLosses | integer (32) | NULL | No | Total number of division losses |
| HomeWins | integer (32) | NULL | No | Total number of home game wins |
| HomeLosses | integer (32) | NULL | No | Total number of home game losses |
| AwayWins | integer (32) | NULL | No | Total number of away game wins |
| AwayLosses | integer (32) | NULL | No | Total number of away game losses |
| LastTenWins | integer (32) | NULL | No | Total wins in the last 10 games |
| LastTenLosses | integer (32) | NULL | No | Total losses in the last 10 games |
| PointsPerGameFor | decimal (32) | NULL | No | Average points scored by the team per game |
| PointsPerGameAgainst | decimal (32) | NULL | No | Average points scored against the team per game |
| Streak | integer (32) | NULL | No | Total games that the streak (winning or losing) has lasted |
| GamesBack | decimal (32) | NULL | No | Total number of games behind the top ranked team for a given team |
| StreakDescription | string (10) | NULL | No | The winning or losing streak written in the form W5 or L1 |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| ConferenceRank | integer (32) | NULL | Yes | Team rank at the conference level |
| DivisionRank | integer (32) | NULL | Yes | Team rank at the division level |
| ClinchedDivision | boolean | NULL | No | Returns TRUE if a team has clinched their division; FALSE if not |
| ClinchedPlayoffBerth | boolean | NULL | No | Returns TRUE if a team has clinched a playoff spot; FALSE if not |
| WonPlayInTournament | boolean | NULL | No | Returns TRUE if a team has clinched a playoff spot through the play-in; FALSE if not |
| ClinchedPlayInTournamentBerth | boolean | NULL | No | Returns TRUE if a team has clinched a spot in the play-in; FALSE if not |
| EliminatedFromPlayoffContention | boolean | NULL | No | Returns TRUE if a team has been eliminated from playoff contention; FALSE if not |
| ClinchedConference | boolean | NULL | No | Returns TRUE if a team has clinched their conference; FALSE if not |
StartingLineups
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID from 2021 | integer (32) | NOT NULL | No | The unique ID of the game associated with this lineup |
| Season from 2021 | integer (32) | NOT NULL | No | The NBA season of the game that the lineups is associated with |
| SeasonType from 2021 | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition). |
| Day from 2021 | datetime (32) | NULL | No | The day of the game |
| DateTime from 2021 | datetime (32) | NULL | No | Date and Time of Game |
| Status from 2021 | string (32) | NULL | No | Indicates the game's status. Possible values include: Scheduled; InProgress; Final; F/OT; Suspended; Postponed; Delayed; Canceled; Forfeit; NotNecessary |
| HomeTeamID from 2021 | integer (32) | NULL | No | The unique ID of the home team |
| HomeTeam from 2021 | string (32) | NULL | No | The abbreviation [Key] of the home team |
| AwayTeamID from 2021 | integer (32) | NULL | No | Unique ID of Away Team |
| AwayTeam from 2021 | string (32) | NULL | No | The abbreviation [Key] of the away team |
| HomeLineup from 2021 | Lineup[] (32) | NULL | No | The lineup (starters and bench players) of the home team in a given game |
| AwayLineup from 2021 | Lineup[] (32) | NULL | No | The lineup (starters and bench players) of the away team in a given game |
Team
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| TeamID | integer (32) | NOT NULL | No | The unique ID of the team |
| [Key] | string (10) | NOT NULL | No | Abbreviation of the team (e.g. LAL; PHI; BOS; CHI; etc.) |
| Active | boolean | NOT NULL | No | Whether or not this team is active |
| City | string (50) | NULL | No | The city/location of the team (e.g. Los Angeles, Philadelphia, Boston, Chicago, etc.) |
| Name | string (50) | NULL | No | The mascot of the team (e.g. Lakers, 76ers, Celtics, Bulls, etc.) |
| LeagueID | integer (32) | NULL | No | This is no longer used (deprecated) |
| StadiumID | integer (32) | NULL | No | The unique ID of the team's current home stadium |
| Conference | string (20) | NULL | No | The conference of the team (possible values: Eastern, Western) |
| Division | string (20) | NULL | No | The division of the team (e.g. Atlantic, Central, Southeast, etc) |
| PrimaryColor | string (6) | NULL | No | The team's first color. (This is not licensed for public or commercial use) |
| SecondaryColor | string (6) | NULL | No | The team's second color. (This is not licensed for public or commercial use) |
| TertiaryColor | string (6) | NULL | No | The team's third color. (This is not licensed for public or commercial use) |
| QuaternaryColor | string (6) | NULL | No | The team's fourth color. (This is not licensed for public or commercial use) |
| WikipediaLogoUrl | string (250) | NULL | No | The link to the team's logo hosted on Wikipedia. (This is not licensed for public or commercial use) |
| WikipediaWordMarkUrl | string (250) | NULL | No | The link to the team's wordmark logo hosted on Wikipedia. (This is not licensed for public or commercial use) |
| GlobalTeamID | integer (32) | NOT NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| NbaDotComTeamID | integer (32) | NULL | No | The team's ID on NBAdotCom |
| HeadCoach | string (50) | NULL | No | The current head coach of the team |
TeamDepthChart (From 2022)
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| DepthCharts | DepthChart[] (32) | NULL | No | List of Depth Chart Records for Team |
| TeamID | integer (32) | NOT NULL | No | The unique ID of the team |
TeamGame
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stat |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition) |
| Season | integer (32) | NULL | No | The NBA season of the game |
| Name | string (50) | NULL | No | Team's name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Wins | integer (32) | NULL | No | Total number of team wins |
| Losses | integer (32) | NULL | No | Total number of team losses |
| Possessions | decimal (32) | NULL | Yes | Total number of estimated possessions by the team in the game |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| GameID | integer (32) | NULL | No | The unique ID of the game associated with this TeamGame record |
| OpponentID | integer (32) | NULL | No | The unique ID of the team's opponent |
| Opponent | string (10) | NULL | No | Abbreviation [Key] of the opponent team (e.g. LAL; PHI; BOS; CHI; etc.) |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game |
| HomeOrAway | string (4) | NULL | No | Whether the team is home or away |
| IsGameOver | boolean | NOT NULL | No | Whether the game is over |
| GlobalGameID | integer (32) | NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| GlobalOpponentID | integer (32) | NULL | No | A globally unique ID for this opponent. This value is guaranteed to be unique across all sports/leagues. |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (US Eastern Time) |
| Games | integer (32) | NULL | No | The number of games played by the team in the game. Note: this will be one for single game feeds |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the team in the game |
| Minutes | integer (32) | NULL | Yes | Total minutes played by the team in the game |
| Seconds | integer (32) | NULL | Yes | Total seconds played by the team in the game |
| FieldGoalsMade | decimal (32) | NULL | Yes | Total field goals made by the team in the game |
| FieldGoalsAttempted | decimal (32) | NULL | Yes | Total field goals attempted by the team in the game |
| FieldGoalsPercentage | decimal (32) | NULL | Yes | Total field goal percentage (FG%) by the team in the game |
| EffectiveFieldGoalsPercentage | decimal (32) | NULL | Yes | Total effective field goals percentage (eFG%) by the team in the game |
| TwoPointersMade | decimal (32) | NULL | Yes | Total two pointers made by the team in the game |
| TwoPointersAttempted | decimal (32) | NULL | Yes | Total two pointers attempted by the team in the game |
| TwoPointersPercentage | decimal (32) | NULL | Yes | Total two point percentage by the team in the game |
| ThreePointersMade | decimal (32) | NULL | Yes | Total three pointers made by the team in the game |
| ThreePointersAttempted | decimal (32) | NULL | Yes | Total three pointers attempted by the team in the game |
| ThreePointersPercentage | decimal (32) | NULL | Yes | Total three point percentage (3P%) by the team in the game |
| FreeThrowsMade | decimal (32) | NULL | Yes | Total free throws made by the team in the game |
| FreeThrowsAttempted | decimal (32) | NULL | Yes | Total free throws attempted by the team in the game |
| FreeThrowsPercentage | decimal (32) | NULL | Yes | Total free throw percentage by the team in the game |
| OffensiveRebounds | decimal (32) | NULL | Yes | Total offensive rebounds by the team in the game |
| DefensiveRebounds | decimal (32) | NULL | Yes | Total defensive rebounds by the team in the game |
| Rebounds | decimal (32) | NULL | Yes | Total rebounds by the team in the game (offensive and defensive rebounds) |
| OffensiveReboundsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| DefensiveReboundsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| TotalReboundsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| Assists | decimal (32) | NULL | Yes | Total assists by the team in the game |
| Steals | decimal (32) | NULL | Yes | Total steals by the team in the game |
| BlockedShots | decimal (32) | NULL | Yes | Total blocked shots by the team in the game |
| Turnovers | decimal (32) | NULL | Yes | Total turnovers by the team in the game |
| PersonalFouls | decimal (32) | NULL | Yes | Total personal fouls by the team in the game |
| Points | decimal (32) | NULL | Yes | Total points scored by the team in the game |
| TrueShootingAttempts | decimal (32) | NULL | Yes | Total true shooting attempts (TSA) by the team in the game Fomula = FGA + 0.44 * FTA. |
| TrueShootingPercentage | decimal (32) | NULL | Yes | Total true shooting percentage (TS%) by the team in the game |
| PlayerEfficiencyRating | decimal (32) | NULL | Yes | This field is expected to be NULL |
| AssistsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| StealsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| BlocksPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| TurnOversPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| UsageRatePercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total FanDuel daily fantasy points by the team in the game |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings daily fantasy points by the team in the game |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total Yahoo daily fantasy points by the team in the game |
| PlusMinus | decimal (32) | NULL | Yes | Total plus minus by the team in the game |
| DoubleDoubles | decimal (32) | NULL | Yes | Total double-doubles by the team in the game |
| TripleDoubles | decimal (32) | NULL | Yes | Total triple-doubles by the team in the game |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Total FantasyDraft daily fantasy points by the team in the game |
| IsClosed | boolean | NOT NULL | No | This field is expected to be FALSE |
| LineupConfirmed | boolean | NULL | No | Indicates whether starting lineup is confirmed. Note: This field will be NULL when not referencing players |
| LineupStatus | string (50) | NULL | Yes | This field is expected to be NULL |
TeamGameTrends
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Scope from 2020 | string (50) | NOT NULL | No | The type of Trend (e.g. Last 5 games; Last 10 games; Last 5 home games; etc.) |
| TeamID from 2020 | integer (32) | NOT NULL | No | The unique ID of the team |
| Team from 2020 | string (50) | NOT NULL | No | The abbreviation [Key] of the team |
| OpponentID from 2020 | integer (32) | NULL | No | The TeamID of the opponent team |
| Opponent from 2020 | string (50) | NULL | No | Abbreviation [Key] of the opponent team (e.g. LAL; PHI; BOS; CHI; etc.) |
| Wins from 2020 | integer (32) | NOT NULL | Yes | The total number of wins by the team relating to the scope. Examples of scopes include: Last 3 Games, Last 5 Home Games, Last 10 Games as Favorite, etc. |
| Losses from 2020 | integer (32) | NOT NULL | Yes | The total number of losses by the team relating to the scope. Examples of scopes include: Last 3 Games, Last 5 Home Games, Last 10 Games as Favorite, etc.. |
| Ties from 2020 | integer (32) | NOT NULL | Yes | The total number of ties by the team relating to the scope. Examples of scopes include: Last 3 Games, Last 5 Home Games, Last 10 Games as Favorite, etc. |
| WinsAgainstTheSpread from 2020 | integer (32) | NULL | Yes | How many games the given team has covered the spread in relating to the scope of the search. Examples of scopes include: Last 3 Games, Last 5 Home Games, Last 10 Games as Favorite, etc. |
| LossesAgainstTheSpread from 2020 | integer (32) | NULL | Yes | The total number of losses against the point spread by the team relating to the scope. Examples of scopes include: Last 3 Games, Last 5 Home Games, Last 10 Games as Favorite, etc. |
| PushesAgainstTheSpread from 2020 | integer (32) | NULL | Yes | Pushes against the spread relating to the scope. Examples of scopes include: Last 3 Games, Last 5 Home Games, Last 10 Games as Favorite, etc. |
| Overs from 2020 | integer (32) | NULL | Yes | Amount of times the total score goes over the total points line |
| Unders from 2020 | integer (32) | NULL | Yes | Amount of times the total score goes under the total points line |
| OverUnderPushes from 2020 | integer (32) | NULL | Yes | Amount of times the total score pushes the total points line |
| AverageScore from 2020 | decimal (32) | NULL | Yes | The average points per game scored by the given team over a certain scope (Last 3 Games, Last 5 Games, Last 10 Games, etc.) |
| AverageOpponentScore from 2020 | decimal (32) | NULL | Yes | The average points per game scored by the opposing teams of a given team over a certain scope (Last 3 Games, Last 5 Games, Last 10 Games, etc.) |
TeamSeason
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stat |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 4=Offseason; 5=AllStar; 6=Exhibition). |
| Season | integer (32) | NULL | No | The NBA season that these totals apply for |
| Name | string (50) | NULL | No | The name of the team |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Wins | integer (32) | NULL | No | Total number of team wins on the season |
| Losses | integer (32) | NULL | No | Total number of team losses on the season |
| OpponentPosition | string (10) | NULL | No | This field is expected to be NULL |
| Possessions | decimal (32) | NULL | Yes | Total number of estimated possessions by the team in the season |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| OpponentStat | OpponentSeason | NULL | No | The aggregated season stats for this team's opponents |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (US Eastern Time) |
| Games | integer (32) | NULL | No | The number of games played by the team in the season |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the team in the season |
| Minutes | integer (32) | NULL | Yes | Total minutes played by the team in the season |
| Seconds | integer (32) | NULL | Yes | Total seconds played by the team in the season |
| FieldGoalsMade | decimal (32) | NULL | Yes | Total field goals made by the team in the season |
| FieldGoalsAttempted | decimal (32) | NULL | Yes | Total field goals attempted by the team in the season |
| FieldGoalsPercentage | decimal (32) | NULL | Yes | Total field goal percentage (FG%) by the team in the season |
| EffectiveFieldGoalsPercentage | decimal (32) | NULL | Yes | Total effective field goals percentage (eFG%) by the team in the season |
| TwoPointersMade | decimal (32) | NULL | Yes | Total two pointers made by the team in the season |
| TwoPointersAttempted | decimal (32) | NULL | Yes | Total two pointers attempted by the team in the season |
| TwoPointersPercentage | decimal (32) | NULL | Yes | Total two point percentage by the team in the season |
| ThreePointersMade | decimal (32) | NULL | Yes | Total three pointers made by the team in the season |
| ThreePointersAttempted | decimal (32) | NULL | Yes | Total three pointers attempted by the team in the season |
| ThreePointersPercentage | decimal (32) | NULL | Yes | Total three point percentage (3P%) by the team in the season |
| FreeThrowsMade | decimal (32) | NULL | Yes | Total free throws made by the team in the season |
| FreeThrowsAttempted | decimal (32) | NULL | Yes | Total free throws attempted by the team in the season |
| FreeThrowsPercentage | decimal (32) | NULL | Yes | Total free throw percentage by the team in the season |
| OffensiveRebounds | decimal (32) | NULL | Yes | Total offensive rebounds by the team in the season |
| DefensiveRebounds | decimal (32) | NULL | Yes | Total defensive rebounds by the team in the season |
| Rebounds | decimal (32) | NULL | Yes | Total rebounds by the team in the season (offensive and defensive rebounds) |
| OffensiveReboundsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| DefensiveReboundsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| TotalReboundsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| Assists | decimal (32) | NULL | Yes | Total assists by the team in the season |
| Steals | decimal (32) | NULL | Yes | Total steals by the team in the season |
| BlockedShots | decimal (32) | NULL | Yes | Total blocked shots by the team in the season |
| Turnovers | decimal (32) | NULL | Yes | Total turnovers by the team in the season |
| PersonalFouls | decimal (32) | NULL | Yes | Total personal fouls by the team in the season |
| Points | decimal (32) | NULL | Yes | Total points scored by the team in the season |
| TrueShootingAttempts | decimal (32) | NULL | Yes | Total true shooting attempts (TSA) by the team in the season |
| TrueShootingPercentage | decimal (32) | NULL | Yes | Total true shooting percentage (TS%) by the team in the season |
| PlayerEfficiencyRating | decimal (32) | NULL | Yes | This field is expected to be NULL |
| AssistsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| StealsPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| BlocksPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| TurnOversPercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| UsageRatePercentage | decimal (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total FanDuel daily fantasy points by the team in the season |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings daily fantasy points by the team in the season |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total Yahoo daily fantasy points by the team in the season |
| PlusMinus | decimal (32) | NULL | Yes | Total plus minus by the team in the season |
| DoubleDoubles | decimal (32) | NULL | Yes | Total double-doubles by the team in the season |
| TripleDoubles | decimal (32) | NULL | Yes | Total triple-doubles by the team in the season |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Total FantasyDraft daily fantasy points by the team in the season |
| IsClosed | boolean | NOT NULL | No | This field is expected to be FALSE |
| LineupConfirmed | boolean | NULL | No | Indicates whether starting lineup is confirmed. Note: This field will be NULL when not referencing players |
| LineupStatus | string (50) | NULL | Yes | This field is expected to be NULL |
TeamTrends
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Team from 2020 | string (50) | NULL | No | The abbreviation [Key] of the team |
| TeamID from 2020 | integer (32) | NULL | No | The unique ID of the team |
| UpcomingGame from 2020 | Game | NULL | No | Next scheduled game for the team |
| TeamGameTrends from 2020 | TeamGameTrends[] | NULL | No | The collection of Game Trends for this team |
Transaction
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerID | integer (32) | NOT NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| Name | string (32) | NOT NULL | No | The player's full name |
| FormerTeamID | integer (32) | NULL | No | The unique ID of the player's former team |
| FormerTeam | string (32) | NULL | No | The abbreviation [Key] of the player's former team |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| Team | string (32) | NULL | No | The abbreviation [Key] of the player's team |
| Type | string (50) | NULL | No | The type of transaction that occurred for a player. Transaction types can be: Released; Waived; Signed; Promoted; Elevated; Demoted; and Traded. |
| Date | datetime (32) | NULL | No | The date this transaction was created |
| Note | string (100) | NULL | No | A short summary of the transaction that occurred (e.g. "Harris has signed with the Pelicans.") |
| Created | datetime (32) | NULL | No | The date and time this transaction took place |
| Updated | datetime (32) | NULL | No | The date and time that this transaction was last updated (US Eastern Time) |