MLB 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 | Denotes the name of the Type (e.g. Betting Market Type, Betting Event Type, Betting Period Type) |
| Active | bool (32) | NULL | No | Whether or not this betting entity is active |
BettingEntityMetadataCollection
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingBetTypes from 2021 | BettingEntityMetadata[] | NULL | No | The list of the bet types that can be found within a market |
| BettingMarketTypes from 2021 | BettingEntityMetadata[] | 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[] | NULL | No | A list of the possible BettingPeriodTypes (e.g. Full Game; 1st-5th Inning; 1st Inning) |
| BettingEventTypes from 2021 | BettingEntityMetadata[] | NULL | No | A list of the possible BettingEventTypes (e.g. Game, Future) |
| BettingOutcomeTypes from 2021 | BettingEntityMetadata[] | 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[] | 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 assocated 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 MLB season of the betting event |
| 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 book has a market set to close 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 date and time of the last update made to this betting event (in US Eastern Time) |
| GameID from 2020 | int (32) | NULL | No | The unique ID of the game tied to this BettingEvent |
| GlobalGameID from 2020 | int (32) | NULL | No | A globally unique ID for the game tied to this BettingEvent. This value is guaranteed to be unique across all sports/leagues. |
| 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 quarter of the game tied to this event |
| AwayTeam from 2020 | string (32) | NULL | No | The abbreviation [Key] of the away team |
| HomeTeam from 2020 | string (32) | NULL | No | The abbreviation [Key] of the Home Team |
| AwayTeamID from 2020 | int (32) | NULL | No | The unique TeamID of the away team in the game tied to this BettingEvent |
| HomeTeamID from 2020 | int (32) | NULL | No | The unique ID of the home team tied to this BettingEvent |
| GlobalAwayTeamID from 2020 | int (32) | NULL | No | A globally unique ID for the away team tied to this BettingEvent 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 tied to this BettingEvent. This value is guaranteed to be unique across all sports/leagues. |
| AwayTeamScore from 2020 | int (32) | NULL | Yes | Score of the away team tied to this betting event (updated after game ends to allow for resolving bets) |
| HomeTeamScore from 2020 | int (32) | NULL | Yes | Score of the home team tied to this betting event (updated after game ends to allow for resolving bets) |
| TotalScore from 2020 | int (32) | NULL | Yes | The combined scores of the home and away team of the game tied to this event (post-game) |
| AwayRotationNumber from 2020 | int (32) | NULL | No | Rotation number of away team for this game |
| HomeRotationNumber from 2020 | int (32) | NULL | No | Rotation number of home team for this game |
| 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 the game starts |
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 Game
- Betting Markets - by Market Type
- 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 assocated with the betting event |
| BettingMarketTypeID from 2020 | int (32) | NULL | Yes | The unique ID associated with the market type of the betting market |
| 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 Runs, Moneyline, Run Line, etc.) |
| BettingPeriodTypeID from 2020 | int (32) | NULL | Yes | The BettingPeriodTypeID of this market |
| BettingPeriodType from 2020 | string (32) | NULL | Yes | The BettingPeriodType of this market (e.g. Full Game; 1st-5th Inning; 2nd Inning; Regular Season) |
| Name from 2020 | string (32) | NULL | No | The generic name of this market |
| TeamID from 2020 | int (32) | NULL | Yes | The team's unique TeamID as assigned by SportsDataIO tied this market (if applicable) |
| TeamKey from 2020 | string (32) | NULL | Yes | The abbreviation [Key] of the team tied to this market (if applicable) |
| PlayerID from 2020 | int (32) | NULL | Yes | The player's unique PlayerID as assigned by SportsDataIO tied to this market (if applicable) Note: this ID will stay with the player throughout their MLB career |
| PlayerName from 2020 | string (32) | NULL | Yes | The full name of the player associated with this market |
| 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 date and time of the last update made to this betting market (in US Eastern Time) |
| AvailableSportsbooks from 2020 | Sportsbook[] (32) | NULL | No | The sportsbooks that have had odds in this 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 (true/false) |
| 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 emtpy 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 associated with the market type of the betting market |
| 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 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 Runs, Moneyline, Run Line, etc.) |
| BettingPeriodTypeID from 2021 | integer (32) | NOT NULL | No | The BettingPeriodTypeID of this market |
| BettingPeriodType from 2021 | string (100) | NOT NULL | No | The BettingPeriodType of this market (e.g. Full Game; 1st-5th Inning; 2nd Inning; Regular Season) |
| Name from 2021 | string (100) | NULL | No | The generic name of this market |
| TeamID from 2021 | integer (32) | NULL | No | The team's unique TeamID as assigned by SportsDataIO tied this market (if applicable) |
| TeamKey from 2021 | string (10) | NULL | No | The abbreviation [Key] of the team tied to this market (if applicable) |
| PlayerID from 2021 | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO tied to this result (if applicable) Note: this ID will stay with the player throughout their MLB career |
| PlayerName from 2021 | string (100) | NULL | No | The full name of the player associated with this market |
| 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 (true/false) |
BettingMarketSplit
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketID | integer (32) | NOT NULL | No | The unique ID associated with the betting market |
| BettingEventID | integer (32) | NOT NULL | No | The unique id of the associated betting event |
| BettingMarketTypeID | integer (32) | NOT NULL | No | The unique ID associated with the market type of the betting market |
| BettingMarketType | string (100) | NOT NULL | No | The name of the market type within a market (e.g. Player Prop, Team Prop, Game Prop, etc.) |
| BettingBetTypeID | integer (32) | NOT NULL | No | The ID associated with the name of the bet type within a market |
| BettingBetType | string (100) | NOT NULL | No | The name of the bet type within a market (e.g. Total Runs, Moneyline, Run Line, etc.) |
| BettingPeriodTypeID | integer (32) | NOT NULL | No | The BettingPeriodTypeID of this market |
| BettingPeriodType | string (100) | NOT NULL | No | The BettingPeriodType of this market (e.g. Full Game; 1st-5th Inning; 2nd Inning; Regular Season) |
| TeamID | integer (32) | NULL | No | The team's unique TeamID as assigned by SportsDataIO tied this market (if applicable) |
| TeamKey | string (32) | NULL | No | The abbreviation [Key] of the team tied to this market (if applicable) |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO tied to this market (if applicable) Note: this ID will stay with the player throughout their MLB career |
| PlayerName | string (100) | NULL | No | The full name of the player associated with this market |
| BettingSplits | BettingSplit[] (32) | NOT NULL | No | A list of betting splits for the BettingMarket |
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 Game
- Betting Markets - by Market Type
- 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 the betting outcome |
| BettingMarketID from 2020 | int (32) | NULL | No | The unique ID associated with the betting market |
| SportsBook from 2020 | Sportsbook (32) | NULL | No | Name of sportsbook |
| BettingOutcomeTypeID from 2020 | int (32) | NULL | Yes | The unique ID associated with this BettingOutcomeType |
| BettingOutcomeType from 2020 | string (32) | NULL | Yes | The name of BettingOutcomeType (e.g. Home; Away; Under; Over) |
| PayoutAmerican from 2020 | int (32) | NULL | Yes | The payout of the bet, shown in American odds format |
| PayoutDecimal from 2020 | decimal (32) | NULL | Yes | The payout of the bet, shown in decimal odds format |
| Value from 2020 | decimal (32) | NULL | Yes | The number associated with the outcome of a market (e.g. the run line, 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 (true/false) |
| IsAlternate from 2020 | bool (32) | NULL | No | Indicates whether this is an alternate value or the core value (true/false) |
| 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 date and time of the last update made to this betting outcome (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 team's unique TeamID as assigned by SportsDataIO tied this outcome (if applicable) |
| PlayerID from 2020 | int (32) | NULL | Yes | The player's unique PlayerID as assigned by SportsDataIO tied to this outcome (if applicable) Note: this ID will stay with the player throughout their MLB career |
| GlobalTeamID from 2020 | int (32) | NULL | Yes | A globally unique ID for this team tied to this outcome. This value is guaranteed to be unique across all sports/leagues (where applicable) |
| 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; true/false) |
| 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 the betting outcome |
| BettingResultTypeID from 2021 | integer (32) | NULL | Yes | The BettingResultTypeID of this outcome |
| BettingResultType from 2021 | string (100) | NULL | Yes | The string identifier of the BettingResultType of this outcome (e.g. Win; Loss; Push; Not Resulted; Incomplete) |
| BettingOutcomeTypeID from 2020 | int (32) | NULL | No | The unique ID associated with this BettingOutcomeType |
| BettingOutcomeType from 2020 | string (32) | NULL | No | The name of BettingOutcomeType (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 2 and the run line was -1.5, the actual value would be 2 and the bet value would be -1.5) |
| ActualValue from 2021 | decimal (32) | NULL | Yes | The value of the actual result that occured in game (i.e. If a team won a game by 2 and the spread was -1.5, the actual value would be 2 and the bet value would be -1.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 associated with the market type of the betting market |
| 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 market |
BettingSplit
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketSplitID | integer (32) | NOT NULL | No | The unique ID assciated with the betting split |
| BettingMarketID | integer (32) | NOT NULL | No | The unique ID associated with the betting market |
| BettingOutcomeTypeID | integer (32) | NULL | No | The unique ID associated with this BettingOutcomeType |
| BettingOutcomeType | string (32) | NULL | No | The name of BettingOutcomeType (e.g. Home; Away; Under; Over) |
| BetPercentage | integer (32) | NULL | Yes | Percentage of bets placed on a specific outcome |
| MoneyPercentage | integer (32) | NULL | Yes | The percentage of the money placed in wagers on this market taken by this type of bet |
| Created | datetime (32) | NOT NULL | No | The date and time this betting split was created in US Eastern Time |
| LastSeen | datetime (32) | NOT NULL | No | The date and time this set of values was last seen |
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 |
| Innings | Inning[] | NULL | No | The inning details associated with the 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 Game
- Betting Markets - by Market Type
- 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 the betting outcome |
| BettingMarketID from 2020 | int (32) | NULL | No | The unique ID associated with the betting market |
| SportsBook from 2020 | Sportsbook (32) | NULL | No | The name of sportsbook(s) |
| BettingOutcomeTypeID from 2020 | int (32) | NULL | Yes | The unique ID associated with this BettingOutcomeType |
| BettingOutcomeType from 2020 | string (32) | NULL | Yes | The name of BettingOutcomeType (e.g. Home; Away; Under; Over) |
| PayoutAmerican from 2020 | int (32) | NULL | Yes | The payout of the bet, shown in American odds format |
| PayoutDecimal from 2020 | decimal (32) | NULL | Yes | The payout of the bet, shown in decimal odds format |
| Value from 2020 | decimal (32) | NULL | Yes | The number associated with the outcome of a market (e.g. the run line, 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 ConsensusOutcome is available for betting or not |
| IsAlternate from 2020 | bool (32) | NULL | No | Indicates whether this is 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 date and time of the last update made to this record (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 consensus outcome |
| PlayerID from 2020 | int (32) | NULL | Yes | The player's unique PlayerID as assigned by SportsDataIO tied to this consensus outcome (if applicable) Note: this ID will stay with the player throughout their MLB career |
| GlobalTeamID from 2020 | int (32) | NULL | Yes | A globally unique ID for the team tied to this outcome. This value is guaranteed to be unique across all sports/leagues (where applicable) |
| 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
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| DepthChartID from 2021 | integer (32) | NOT NULL | No | The unique ID of the Depth Chard record |
| TeamID from 2021 | integer (32) | NOT NULL | No | The team's unique TeamID as assigned by SportsDataIO |
| 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 MLB career |
| Name from 2021 | string (32) | NULL | No | Player's full name |
| PositionCategory from 2021 | string (32) | NULL | No | The player's position category. Possible values: DH; IF; OF; P; PH; PR |
| Position from 2021 | string (32) | NULL | No | Player's position in the depth chart. Note: a player can be listed in multiple positions of the depth chart |
| DepthOrder from 2021 | integer (32) | NULL | Yes | The Depth Chart order of the player and where they are placed in the depth chart |
| Updated from 2021 | datetime (32) | NULL | No | The date and time of the last update made to this depth chart (in US Eastern Time) |
DfsSlate
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SlateID | integer (32) | NOT NULL | No | The SlateID that this SlateGame refers to |
| 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 or not this slate uses games that take place on different days (true/false) |
| 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. Note: 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 | The SlateGameID that this SlatePlayer refers to |
| SlateID | integer (32) | NOT NULL | No | The SlateID that this SlateGame refers to |
| GameID | integer (32) | NULL | No | The unique ID of the game tied to this SlateGame |
| 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 MLB 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). Note: 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 (10) | NULL | No | The abbreviation [Key] of the team |
| TeamID | integer (32) | NULL | No | The team's unique TeamID as assigned by SportsDataIO |
DfsSlatePlayerOwnershipProjection (From 2025)
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). |
| PlayerID | integer (32) | NOT NULL | No | Unique ID of the Associated Player. |
| ProjectedOwnershipPercentage | decimal (32) | NOT NULL | No | Projected Ownership Percentage (0-100) |
| IsCaptain | boolean (32) | NOT NULL | No | Indicates if this is the MVP/Captain slot for single game slates |
DfsSlateWithOwnershipProjection (From 2025)
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). |
| SlateOwnershipProjections | DfsSlatePlayerOwnershipProjection[] | NULL | No | The list of projected ownership |
FantasyGame
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 |
| 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 MLB 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). |
| Season | integer (32) | NULL | No | The MLB season of the game |
| Day | date | NULL | No | The date 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 | The name [Key] of the player's opponent in the game |
| 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 | Player's full name |
| Position | string (10) | NULL | No | The player's position associated with the given game or season. Possible values: 1B, 2B, 3B, C, CF, DH, IF, LF, OF, P, PH, PR, RF, RP, SP, SS |
| PositionCategory | string (10) | NULL | No | The player's position category. Possible values: DH; IF; OF; P; PH; PR |
| Games | integer (32) | NULL | No | The number of games played by the player. Note: for game feeds this will always = 1 |
| Started | integer (32) | NULL | No | Whether the player started in the game. Note: started = 1 and not starting = 0 |
| FantasyPoints | decimal (32) | NULL | No | Total fantasy points by the player during the game |
| FantasyPointsBatting | decimal (32) | NULL | No | Total batting fantasy points by the player in the game |
| FantasyPointsPitching | decimal (32) | NULL | No | Total pitching fantasy points by the player in the game |
| IsGameOver | boolean | NULL | No | Whether or not the game is over (returns ture/false) |
| FantasyPointsFanDuel | decimal (32) | NULL | No | Total FanDuel fantasy points by the player in the game |
| FantasyPointsYahoo | decimal (32) | NULL | No | Total Yahoo fantasy points by the player in the game |
| FantasyPointsDraftKings | decimal (32) | NULL | No | Total DraftKings fantasy points by the player in the game |
| FanDuelPosition | 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 |
| OppositionPositionRank | 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 date and time of the late update made to this record (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 MLB season of the game |
| SeasonType | integer (32) | NOT NULL | No | The type of season stage the game belongs to, e.g. Regular season, Post-season. For a description of possible values and how they work, see here. |
| 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. |
| Day | date | NULL | No | The date of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in US Eastern Time) |
| 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 TeamID of the away team |
| HomeTeamID | integer (32) | NOT NULL | No | The unique ID of the home team |
| RescheduledGameID | integer (32) | NULL | No | The GameID of the game that was rescheduled from this game. This only pertains to postponed games that require rescheduling. |
| StadiumID | integer (32) | NULL | No | The unique ID of the stadium |
| Channel | string (50) | NULL | No | The television station broadcasting the game |
| Inning | integer (32) | NULL | No | The inning that the game is currently in, or the inning in which the game ended. Possible values include: NULL, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, etc) |
| InningHalf | string (1) | NULL | No | The inning half that the game is currently in; or the inning half in which the game ended (possible values: T; B; E: M: NULL) |
| AwayTeamRuns | integer (32) | NULL | Yes | Number of runs scored by the away team in the game |
| HomeTeamRuns | integer (32) | NULL | Yes | Number of runs scored by the home team in the game |
| AwayTeamHits | integer (32) | NULL | Yes | Total hits by the away team in the game |
| HomeTeamHits | integer (32) | NULL | Yes | Total hits by the home team in the game |
| AwayTeamErrors | integer (32) | NULL | Yes | Total errors committed by the away team in the game |
| HomeTeamErrors | integer (32) | NULL | Yes | Total errors committed by the home team in the game |
| WinningPitcherID | integer (32) | NULL | No | The PlayerID of the pitcher who recorded the win in the game |
| LosingPitcherID | integer (32) | NULL | No | The PlayerID of the losing pitcher in the game |
| SavingPitcherID | integer (32) | NULL | No | The PlayerID of the pitcher who recorded the save in the game |
| Attendance | integer (32) | NULL | No | Total number of people who attended the game |
| AwayTeamProbablePitcherID | integer (32) | NULL | No | The PlayerID of the away team's probable pitcher |
| HomeTeamProbablePitcherID | integer (32) | NULL | No | The PlayerID of the home team's probable pitcher |
| Outs | integer (32) | NULL | No | The number of outs recorded in the current inning of the game |
| Balls | integer (32) | NULL | No | The number of balls thrown for the current at bat |
| Strikes | integer (32) | NULL | No | The number of strikes thrown for the current at bat |
| CurrentPitcherID | integer (32) | NULL | No | The PlayerID of the current pitcher |
| CurrentHitterID | integer (32) | NULL | No | The PlayerID of the current hitter |
| AwayTeamStartingPitcherID | integer (32) | NULL | No | The PlayerID of the away team's starting pitcher |
| HomeTeamStartingPitcherID | integer (32) | NULL | No | The PlayerID of the home team starting pitcher in the game |
| CurrentPitchingTeamID | integer (32) | NULL | No | The TeamID of the current pitcher's team |
| CurrentHittingTeamID | integer (32) | NULL | No | The TeamID of the current hitter's team |
| PointSpread from 2016 | decimal (32) | NULL | Yes | The consensus Run Line at game start from the perspective of the HomeTeam (in the Game table, the PointSpread field's negative numbers indicate the HomeTeam is favored; positive numbers indicate the AwayTeam is favored. Note that this rule does not hold in betting-related tables, where the run line is contingent on the bet line). Note: In MLB, Point Spread may also be referred to as Run Line |
| OverUnder from 2016 | decimal (32) | NULL | Yes | The oddsmaker total points line at game start |
| AwayTeamMoneyLine from 2016 | integer (32) | NULL | Yes | Moneyline from the perspective of the away team |
| HomeTeamMoneyLine from 2016 | integer (32) | NULL | Yes | Moneyline from the perspective of the home team |
| ForecastTempLow from 2016 | integer (32) | NULL | Yes | The forecasted low temperature on game day at this venue (in Fahrenheit) |
| ForecastTempHigh from 2016 | integer (32) | NULL | Yes | The forecasted high temperature on game day at this venue (in Fahrenheit) |
| ForecastDescription from 2016 | string (50) | NULL | Yes | The description of the weather forecast. Posible values include: Broken Clouds, Clear Sky, Few Clouds, Heavy Intensity Rain, Light Rain, Moderate Rain, Mostly Cloudy, Mostly Sunny, Overcast Clouds, Partly Cloudy, Scattered Clouds, Showers, Thunderstorms |
| ForecastWindChill from 2016 | integer (32) | NULL | Yes | The forecasted wind chill on game day at this venue. |
| ForecastWindSpeed from 2016 | integer (32) | NULL | Yes | The forecasted wind speed on game day at this venue. |
| ForecastWindDirection from 2016 | integer (32) | NULL | Yes | The wind direction isn't baseball specific. It refers to the direction that the wind is coming from. 90 would be wind coming from the east. 180 is wind from the south. 270 is a wind from the west ... and so on. |
| 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. |
| RunnerOnFirst | boolean | NULL | Yes | Indicates if there is a runner on first base |
| RunnerOnSecond | boolean | NULL | Yes | Indicates if there is a runner on second base |
| RunnerOnThird | boolean | NULL | Yes | Indicates if there is a runner on third base |
| AwayTeamStartingPitcher | string (50) | NULL | Yes | The first and last name of the away team's starting pitcher for the game |
| HomeTeamStartingPitcher | string (50) | NULL | Yes | The first and last name of the home team starting pitcher for the game |
| CurrentPitcher | string (50) | NULL | Yes | Indicates the current pitcher's name |
| CurrentHitter | string (50) | NULL | Yes | Indicates the current hitter's name |
| WinningPitcher | string (50) | NULL | Yes | The name of the pitcher who recorded the win in the game |
| LosingPitcher | string (50) | NULL | Yes | The first and last name of the losing pitcher in the game |
| SavingPitcher | string (50) | NULL | Yes | The name of the pitcher who recorded the save in the game |
| DueUpHitterID1 | integer (32) | NULL | Yes | The PlayerID of the hitter due up first from the current hitter |
| DueUpHitterID2 | integer (32) | NULL | Yes | The PlayerID of the hitter due up second from the current hitter |
| DueUpHitterID3 | integer (32) | NULL | Yes | The PlayerID of the hitter due up third from the current hitter |
| 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 moneyline payout odds when betting on the away team with the run line |
| PointSpreadHomeTeamMoneyLine from 2017 | integer (32) | NULL | Yes | The moneyline payout odds when betting on the home team with the run line |
| 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 |
| Updated | datetime | NULL | No | The date and time of the late update made to this record (in US Eastern Time) |
| Innings | Inning[] | NULL | No | The inning details associated with the game |
| GameEndDateTime | datetime | NULL | No | The date and time that the game ended in US Eastern Time |
| HomeRotationNumber from 2019 | integer (32) | NULL | Yes | Rotation number of home team for this game |
| AwayRotationNumber from 2019 | integer (32) | NULL | Yes | Rotation number of away team for this game |
| NeutralVenue from 2020 | boolean | NULL | No | Indicates whether this game is played in a neutral venue. Note: Neutral = True, not neutral = False |
| InningDescription | string (50) | NULL | No | The current status of the inning for display purposes (possible values: Top 2, Mid 2, Bot 2, End 2, etc) |
| OverPayout from 2021 | integer (32) | NULL | Yes | The sportsbook's payout for the over |
| UnderPayout from 2021 | integer (32) | NULL | Yes | The sportsbook's payout for the under |
| SeriesInfo from 2021 | Series (32) | NULL | No | Contains relevant series data for postseason series only - HomeTeamWins; AwayTeamWins; GameNumber; and MaxLength |
| DateTimeUTC from 2021 | datetime | NULL | No | The date and time of the game in UTC |
| HomeTeamOpener | boolean | NULL | No | Indicates whether the home team will use an opener as the starting pitcher. NOTE: An opener is a pitcher (typically a relief pitcher) that is only scheduled to pitch the first 1-3 innings of the game |
| AwayTeamOpener | boolean | NULL | No | Indicates whether the away team will use an opener as the starting pitcher.. NOTE: An opener is a pitcher (typically a relief pitcher) that is only scheduled to pitch the first 1-3 innings of the game |
| SuspensionResumeDay | date | NULL | No | The date a game that was suspended in play will be resumed for play. Useful for tracking when a Suspended game will return to an InProgress status. |
| SuspensionResumeDateTime | datetime | NULL | No | The date and start-time that the suspended in play game will be resumed for play. Useful for tracking when a Suspended game will return to an InProgress status. |
GameBettingSplit
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 tied to the BettingSplits |
| 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). |
| Season | integer (32) | NOT NULL | No | The MLB season of the betting split |
| Day | datetime (32) | NULL | No | The day of the game |
| AwayTeam | string (32) | NULL | No | The abbreviation [Key] of the away team |
| HomeTeam | string (32) | NULL | No | The abbreviation [Key] of the Home Team |
| BettingMarketSplits | BettingMarketSplit[] (32) | NOT NULL | No | Shows the BettingMarkets that have splits included for them 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 this game |
| Season | integer (32) | NOT NULL | No | The MLB 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). |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game in US Eastern Time |
| 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 TeamID 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 | GameOdd[] | NULL | No | List of Pregame GameOdds from different sportsbooks |
| LiveOdds | GameOdd[] | NULL | No | Shows a list of live odds from different sportsbooks |
| HomeTeamScore | integer | NULL | Yes | Score of the home team (updated after game ends to allow for resolving bets) |
| AwayTeamScore | integer | NULL | Yes | Score of the away team (updated after game ends to allow for resolving bets) |
| TotalScore | integer | NULL | Yes | The combined scores of the home and away team of the game tied to this event (post-game) |
| HomeRotationNumber | integer (32) | NULL | Yes | Rotation number of home team for this game |
| AwayRotationNumber | integer (32) | NULL | Yes | Rotation number of away team for this game |
| AlternateMarketPregameOdds | GameOdd[] | NULL | No | List of Alternate Market Game Odds from different sportsbooks. |
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 this game |
| Season | integer (32) | NOT NULL | No | The MLB 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). |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game in US Eastern Time |
| 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 TeamID of the away team |
| HomeTeamID | integer (32) | NULL | No | The unique TeamID 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 | Score of the home team (updated after game ends to allow for resolving bets) |
| AwayTeamScore | integer (32) | NULL | Yes | Score of the away team (updated after game ends to allow for resolving bets) |
| TotalScore | integer (32) | NULL | Yes | The combined scores of the home and away team of the game tied to this event (post-game) |
| HomeRotationNumber | integer (32) | NULL | Yes | Rotation number of home team for this game |
| AwayRotationNumber | integer (32) | NULL | Yes | Rotation number of away team for this game |
| AlternateMarketPregameOdds | GameOddResult[] | NULL | No | List of Alternate Market Game Odds from different sportsbooks with results |
| Inning | integer (32) | NULL | No | The inning that the game is currently in, or the inning in which the game ended. Possible values include: NULL, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, etc) |
| InningHalf | string (1) | NULL | No | The inning half that the game is currently in; or the inning half in which the game ended (possible values: T; B; E: M: NULL) |
| 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 |
| Innings | Inning[] | NULL | No | The inning details associated with the game |
| LiveOdds | GameOddResult[] | NULL | No | Shows a 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 | Unique ID of this odd |
| Sportsbook | string (25) | NOT NULL | Yes | Name of sportsbook |
| GameId | integer (32) | NOT NULL | No | The unique ID of this game |
| Created | datetime | NOT NULL | No | The date and time when these odds were first created in US Eastern Time |
| Updated | datetime | NOT NULL | No | The date and time of when these odds were last updated (in US Eatern 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 moneyline for the home team |
| AwayMoneyLine | integer (32) | NULL | Yes | The sportsbook's moneyline for the away team |
| HomePointSpread | decimal (32) | NULL | Yes | The sportsbook's run line for the home team |
| AwayPointSpread | decimal (32) | NULL | Yes | The sportsbook's run line for the away team |
| HomePointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's run line payout for the home team |
| AwayPointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's run line payout for the away team |
| OverUnder | decimal (32) | NULL | Yes | The total points line as given by the sportsbook |
| 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 |
| SportsbookUrl | string (500) | NULL | No | The URL for sportsbook event |
| OddType | string (500) | NULL | No | The market type of the odd (ex: live; pregame; 1st inning; etc) |
| 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) | NULL | No | Unique ID of this odd |
| GameOddResultTypeId | integer (32) | NULL | No | The unique ID of this GameOddResultType |
| 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; 1st inning; etc) |
| GameOddType | string (100) | NULL | No | The GameOddResultType of an outcome in the form of 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 2 and the run line was -1.5, the actual value would be 2 and the bet value would be -1.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 2 and the spread was -1.5, the actual value would be 2 and the bet value would be -1.5) |
GameOddResult
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameOddID | integer (32) | NOT NULL | No | Unique ID of this odd |
| Sportsbook | string (25) | NOT NULL | Yes | Name of sportsbook |
| GameID | integer (32) | NOT NULL | No | The unique ID of this game |
| Created | datetime | NOT NULL | No | The date and time when these odds were first created in US Eastern Time |
| Updated | datetime | NOT NULL | No | The date and time of when these odds were last updated (in US Eatern 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 moneyline for the home team |
| AwayMoneyLine | integer (32) | NULL | Yes | The sportsbook's moneyline for the away team |
| HomePointSpread | decimal (32) | NULL | Yes | The sportsbook's run line for the home team |
| AwayPointSpread | decimal (32) | NULL | Yes | The sportsbook's run line for the away team |
| HomePointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's run line payout for the home team |
| AwayPointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's run line payout for the away team |
| OverUnder | decimal (32) | NULL | Yes | The total points line as given by the sportsbook |
| 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 |
| SportsbookUrl | string (500) | NULL | No | The URL for sportsbook event |
| OddType | string (500) | NULL | No | The market type of the odd (ex: live; pregame; 1st inning; etc) |
| 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 MLB career |
| Name | string (100) | NULL | No | Player's full name |
| TeamID | integer (32) | NULL | No | The team's unique TeamID as assigned by SportsDataIO |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Position | string (10) | NULL | No | The player's position associated with the given game or season. Possible values: 1B; 2B; 3B; C; CF; DH; IF; LF; OF; P; PH; PR; RF; RP; SP; SS |
| 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 date and time the player's hosted headshot was updated in US Eastern Time |
| HostedHeadshotNoBackgroundUrl | string (500) | NULL | Yes | The player's transparent background hosted headshot URL |
| HostedHeadshotNoBackgroundUpdated | datetime | NULL | No | The last date and time the player's transparent background hosted headshot was updated in US Eastern Time |
Inning
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| InningID | integer (32) | NOT NULL | No | The unique ID of this specific inning |
| GameID | integer (32) | NOT NULL | No | The unique ID of the game tied to this Inning |
| InningNumber | integer (32) | NOT NULL | No | The current inning number of the game |
| AwayTeamRuns | integer (32) | NULL | Yes | Number of runs scored by the away team in the specific inning |
| HomeTeamRuns | integer (32) | NULL | Yes | Number of runs scored by the home team in the specific inning |
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 MLB career |
| TeamID from 2021 | integer (32) | NOT NULL | No | The team's unique TeamID as assigned by SportsDataIO |
| 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 |
| BattingOrder from 2021 | integer (32) | NULL | Yes | Where the player batted in the lineup for the game (1;2;3; etc.) |
| Position from 2021 | string (32) | NULL | No | Player's position in the starting lineup (if started); otherwise the position he substituted for |
| Starting from 2021 | bool (32) | NULL | Yes | Indicates if this player is starting. Note: started = 1 and non starting= 0 |
| Confirmed from 2021 | bool (32) | NULL | Yes | Indicates if batting order has been confirmed (true/false) |
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 the 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 assigned to this 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 published |
| TimeAgo | string (50) | NULL | No | A description of how long ago this content was published |
| Title | string (100) | NULL | No | The brief title of the news story (typically less than 100 characters) |
| Content | string (5000) | NULL | No | The entirety of the content of the news story |
| Url | string (250) | NULL | No | The website 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 of the content |
| 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 MLB career |
| TeamID | integer (32) | NULL | No | The team's unique TeamID as assigned by SportsDataIO |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team that relates to this story |
| PlayerID2 | integer (32) | NULL | No | The PlayerID of the player who relates to this story |
| TeamID2 | integer (32) | NULL | No | The TeamID of the second team that relates to this story |
| Team2 | string (10) | NULL | No | The abbreviation [Key] of the second team that relates to this story |
| OriginalSource from 2020 | string (100) | NULL | No | The original source who broke this news (before it was picked up by the publisher of this story) |
| OriginalSourceUrl from 2020 | string (1000) | NULL | No | The URL of the original source who broke this news story |
Pitch
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PitchID | integer (32) | NOT NULL | No | The unique ID of the pitch |
| PlayID | integer (32) | NOT NULL | No | The unique ID of the play assigned by SportsDataIO |
| PitchNumberThisAtBat | integer (32) | NULL | Yes | The number of pitches in the at bat in which the pitch occurred. |
| PitcherID | integer (32) | NULL | No | The PlayerID of the pitcher who threw the pitch |
| HitterID | integer (32) | NULL | No | The unique PlayerID of the hitter who represents the play |
| Outs | integer (32) | NULL | Yes | The number of outs when the pitch occurred |
| BallsBeforePitch | integer (32) | NULL | Yes | The number of balls the pitcher has thrown before the current pitch |
| StrikesBeforePitch | integer (32) | NULL | Yes | The number of strikes the pitcher has thrown before the current pitch |
| Strike | boolean | NULL | Yes | Whether the pitch was a strike (true/false) |
| Ball | boolean | NULL | Yes | Whether the pitch was a ball (true/false) |
| Foul | boolean | NULL | Yes | Whether the pitch was hit foul (true/false) |
| Swinging | boolean | NULL | Yes | Whether the hitter struck out swinging (true/false) |
| Looking | boolean | NULL | Yes | Whether or not the hitter struck out looking (returns true/false) |
Play
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayID | integer (32) | NOT NULL | No | The unique ID of the play assigned by SportsDataIO |
| InningID | integer (32) | NOT NULL | No | The unique ID associated with this specific inning in which the play occurred |
| InningNumber | integer (32) | NULL | No | The inning number in which the particular play occurred |
| InningHalf | string (1) | NULL | No | The inning half that the game is currently in; or the inning half in which the game ended (possible values: T; B; E: M: NULL) |
| PlayNumber | integer (32) | NULL | Yes | The order in which plays occurred in a game |
| InningBatterNumber | integer (32) | NULL | Yes | The batter number in the inning where the play occurred. |
| AwayTeamRuns | integer (32) | NULL | Yes | Number of runs scored by the away team on this specific play |
| HomeTeamRuns | integer (32) | NULL | Yes | Number of runs scored by the home team on this specific play |
| HitterID | integer (32) | NULL | No | The unique PlayerID of the hitter involved with the play |
| PitcherID | integer (32) | NULL | No | The PlayerID of the pitcher involved in the play |
| HitterTeamID | integer (32) | NULL | No | The TeamID of the hitter's team. |
| PitcherTeamID | integer (32) | NULL | No | The ID of the pitcher's team |
| HitterName | string (50) | NULL | No | The first and last name of the hitter involved in the play |
| PitcherName | string (50) | NULL | No | The full name of the pitcher involved in the play |
| PitcherThrowHand | string (1) | NULL | No | The throwing hand of the pitcher in which the play occurred. (right or left) |
| HitterBatHand | string (1) | NULL | No | The batter's handedness for which the play occurred. (R; L; S) |
| HitterPosition | string (10) | NULL | No | The position of the player in which the play occrred. (e.g. P;C;1B; SS; OF) |
| Outs | integer (32) | NULL | Yes | The number of outs in which the play occurred |
| Balls | integer (32) | NULL | Yes | The number of balls in the count in which the play occurred |
| Strikes | integer (32) | NULL | Yes | The number of strikes in the count in which the play occurred |
| PitchNumberThisAtBat | integer (32) | NULL | Yes | The number of pitches in the at bat in which the play occurred |
| Result | string (50) | NULL | Yes | The result of the play. Possible values include: Batter's Interference, Bunted into Double Play, Catcher's Interference, Double, Error, Fielder's Choice, Fly into Double Play, Fly Out, Foul Out, Fouled into Double Play, Ground into Double Play, Ground Out, Hit by Pitch, Home Run, Infield Fly Out, Intentional Walk, Line into Double Play, Lineout, Pop Out, Popped into Double Play, Sacrifice, Sacrifice Fly, Single, Strikeout Bunting, Strikeout Looking, Strikeout Swinging, Triple, Triple Play, Walk, Stolen Base, Caught Stealing, Passed Ball, Wild Pitch, Pick Off, Balk, Error, Fielders Indifference |
| NumberOfOutsOnPlay | integer (32) | NULL | Yes | The number of outs recorded on the play |
| RunsBattedIn | integer (32) | NULL | Yes | The number of runs batted in on the play |
| AtBat | boolean | NULL | No | Whether this plate appearance resulted in an at bat |
| Strikeout | boolean | NULL | No | Whether the play resulted with a strikeout (returns true/false) |
| Walk | boolean | NULL | No | Indicates whether the play resulted in a walk for the hitter (returns true/false) |
| Hit | boolean | NULL | No | Whether this play resulted in a hit (true/false) |
| Out | boolean | NULL | No | Whether this play resutled in an out (true/false) |
| Sacrifice | boolean | NULL | No | Whether the play resulted in a sacrifice (returns true/false) |
| Error | boolean | NULL | No | Whether this play resulted in an error (true/false) |
| Updated | date | NULL | No | The database generated timestamp of when this record was last updated (in US Eastern Time) |
| Description | string (250) | NULL | Yes | The description of the play for display purposes |
| Pitches | Pitch[] | NULL | No | The details of the pitches associated with this play |
| Runner1ID | integer (32) | NULL | No | The PlayerID of the player on first as a result of the play (post-play) |
| Runner2ID | integer (32) | NULL | No | The PlayerID of the player on second as a result of the play (post-play) |
| Runner3ID | integer (32) | NULL | No | The PlayerID of the player on third as a result of the play (post-play) |
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 |
| 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 MLB career |
| SportsDataID | string (50) | NULL | No | Deprecated. Use SportRadarPlayerID instead. |
| Status | string (50) | NULL | No | Indicates the player's status of being on an Major League Active Roster. Possible values include: Active, 40 Man Active, Non-Roster Invitee, Minors, Inactive, 7 Day Injury List, 10 Day Injury List, 15 Day Injury List, 60 Day Injury List, Restricted List, Paternity List, Bereavement List, Military List |
| TeamID | integer (32) | NULL | No | The team's unique TeamID as assigned by SportsDataIO |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team that the player belongs to |
| Jersey | integer (32) | NULL | No | The player's jersey number. |
| PositionCategory | string (10) | NULL | No | The player's position category. Possible values: DH, IF, OF, P, PH, PR |
| Position | string (10) | NULL | No | The player's position associated with the given game or season. Possible values: 1B; 2B; 3B; C; CF; DH; IF; LF; OF; P; PH; PR; RF; RP; SP; SS |
| MLBAMID | integer (32) | NULL | No | The player's unique PlayerID for cross reference use with MLB AM |
| FirstName | string (50) | NULL | No | The player's first name |
| LastName | string (50) | NULL | No | The player's last name |
| BatHand | string (1) | NULL | No | The player's batting hand. Possible values: R, L, S |
| ThrowHand | string (1) | NULL | No | The player's throwing hand. Possible values: R, L, S |
| Height | integer (32) | NULL | No | The player's height in inches |
| Weight | integer (32) | NULL | No | The weight of the player 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. Note: State will be NULL for all countries outside of North America and Australia |
| 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. Note: If the player attended a college, this field will be NULL |
| College | string (50) | NULL | No | The college that the player attended. Note: If player did not attend college this field will contain "None" and a high school will be added if applicable |
| ProDebut | date | NULL | No | The date that this player made his MLB debut. |
| Salary | integer (32) | NULL | No | Field is expected to be NULL |
| PhotoUrl | string (250) | NULL | No | Field is expected to be NULL |
| SportRadarPlayerID | string (50) | NULL | No | The player's unique PlayerID for cross reference use with Stats Player |
| RotoworldPlayerID | integer (32) | NULL | No | The player's unique PlayerID for cross reference use with Rotoworld. |
| RotoWirePlayerID | integer (32) | NULL | No | The player's unique PlayerID for cross reference use with RotoWire. |
| FantasyAlarmPlayerID | integer (32) | NULL | No | The player's unique PlayerID for cross reference use with FantasyAlarm |
| StatsPlayerID | integer (32) | NULL | No | The player's unique PlayerID for cross reference use with Stats Player. |
| 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 unique PlayerID for cross reference use with Xml Team |
| 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 | Indicates the player's injured body part. (e.g. ankle; knee; elbow; 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 unique PlayerID for cross reference use with FanDuel |
| DraftKingsPlayerID | integer (32) | NULL | No | The player's unique PlayerID for cross reference use with DraftKings. |
| YahooPlayerID | integer (32) | NULL | No | The player's unique PlayerID for cross reference use with Yahoo |
| UpcomingGameID | integer (32) | NULL | No | The unique ID of a player's next upcoming game |
| FanDuelName | string (50) | NULL | No | The player's name on FanDuel |
| DraftKingsName | string (50) | NULL | No | The player's name on DraftKings |
| YahooName | string (50) | NULL | No | The player's name as displayed on/by Yahoo |
| 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 name on Fantasy Draft |
| FantasyDraftPlayerID | integer (32) | NULL | No | The player's unique PlayerID for cross reference use with Fantasy Draft |
| Experience | string (20) | NULL | No | The player's years of experience |
| 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. |
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 MLB career |
| SportsDataID | string (50) | NULL | No | Deprecated. Use SportRadarPlayerID instead. |
| Status | string (50) | NULL | No | Indicates the player's status of being on an Major League Active Roster. Possible values include: Active, 40 Man Active, Non-Roster Invitee, Minors, Inactive, 7 Day Injury List, 10 Day Injury List, 15 Day Injury List, 60 Day Injury List, Restricted List, Paternity List, Bereavement List, Military List |
| TeamID | integer (32) | NULL | No | The team's unique TeamID as assigned by SportsDataIO |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Jersey | integer (32) | NULL | No | The player's jersey number |
| PositionCategory | string (10) | NULL | No | The player's position category. Possible values: DH, IF, OF, P, PH, PR |
| Position | string (10) | NULL | No | The player's position associated with the given game or season. Possible values: 1B; 2B; 3B; C; CF; DH; IF; LF; OF; P; PH; PR; RF; RP; SP; SS |
| 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. Note: State will be NULL for all countries outside of North America and Australia |
| 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 |
| BatHand | string (1) | NULL | No | The player's batting hand. Possible values: R, L, S |
| ThrowHand | string (1) | NULL | No | The player's throwing hand. Possible values: R, L, S |
| Height | integer (32) | NULL | No | The player's height in inches |
| Weight | integer (32) | NULL | No | The weight of the player 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 team's unique TeamID as assigned by SportsDataIO |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their MLB 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) |
| Season | integer (32) | NULL | No | The MLB season of the game |
| Name | string (50) | NULL | No | Player's full name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Position | string (10) | NULL | No | The player's position associated with the given game or season. Possible values: 1B, 2B, 3B, C, CF, DH, IF, LF, OF, P, PH, PR, RF, RP, SP, SS |
| PositionCategory | string (10) | NULL | No | The player's position category. Possible values: DH; IF; OF; P; PH; PR |
| Started | integer (32) | NULL | No | Whether the player started in the game. Note: started = 1 and not starting = 0 |
| BattingOrder | integer (32) | NULL | Yes | Where the player batted in the lineup for the game (1;2;3; etc.) |
| FanDuelSalary from 2015 | 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 2015 | 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 | Indicates the player's injured body part. (e.g. ankle; knee; elbow; etc.) |
| InjuryStartDate from 2016 | date | NULL | No | The day that the injury started or 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 daily fantasy contests. |
| FantasyDraftPosition from 2017 | string (10) | NULL | No | The player's eligible position in Fantasy Drafts daily fantasy sports platform. |
| GameID | integer (32) | NULL | No | The unique ID of the game tied to this PlayerGame record |
| OpponentID | integer (32) | NULL | No | The TeamID of the opposing team in the game |
| Opponent | string (10) | NULL | No | The name [Key] of the player's opponent in 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) |
| HomeOrAway | string (4) | NULL | No | Whether the team is home or away |
| IsGameOver | boolean | NOT NULL | No | Whether or not the player's game is over (returns 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 team's opponent. This value is guaranteed to be unique across all sports/leagues |
| Updated | datetime | NULL | No | The date and time of the late update made to this record (in US Eastern Time) |
| Games | integer (32) | NULL | No | The number of games played by the player. Note: for game feeds this will always = 1 |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the player during the game |
| AtBats | decimal (32) | NULL | Yes | Total at bats by the player in the game |
| Runs | decimal (32) | NULL | Yes | Total runs scored by the player in the game |
| Hits | decimal (32) | NULL | Yes | Total hits by the player in the game |
| Singles | decimal (32) | NULL | Yes | Total singles by the player in the game |
| Doubles | decimal (32) | NULL | Yes | Total doubles by the player in the game |
| Triples | decimal (32) | NULL | Yes | Total triples by the player in the game |
| HomeRuns | decimal (32) | NULL | Yes | Total home runs by the player in the game |
| RunsBattedIn | decimal (32) | NULL | Yes | Total runs batted in by the player in the game |
| BattingAverage | decimal (32) | NULL | Yes | Total batting average by the player in the game |
| Outs | decimal (32) | NULL | Yes | Total batting outs by the player in the game |
| Strikeouts | decimal (32) | NULL | Yes | Total strikeouts while batting by the player in the game |
| Walks | decimal (32) | NULL | Yes | Total walks recorded by the player in the game |
| HitByPitch | decimal (32) | NULL | Yes | Total times the player was hit by a pitch in the game |
| Sacrifices | decimal (32) | NULL | Yes | Total sacrifices by the player in the game |
| SacrificeFlies | decimal (32) | NULL | Yes | Total sacrifice flies by the player in the game |
| GroundIntoDoublePlay | decimal (32) | NULL | Yes | Total times the player grounded into double play (GIDP) in the game |
| StolenBases | decimal (32) | NULL | Yes | Total stolen bases by the player in the game |
| CaughtStealing | decimal (32) | NULL | Yes | Total times the player was caught stealing in the game |
| PitchesSeen | decimal (32) | NULL | Yes | Total pitches seen by the player in the game |
| OnBasePercentage | decimal (32) | NULL | Yes | Total on base percentage (OBP) by the player in the game |
| SluggingPercentage | decimal (32) | NULL | Yes | Total slugging percentage (SLG) of the player in the game |
| OnBasePlusSlugging | decimal (32) | NULL | Yes | Total on base plus slugging percentage (OPS) by the player in the game |
| Errors | decimal (32) | NULL | Yes | Total errors committed by the player in the game |
| Wins | decimal (32) | NULL | Yes | Total wins recorded by the pitcher in the game |
| Losses | decimal (32) | NULL | Yes | Total pitching losses by the player in the game. Note: this can be either 0 or 1 for single game (non-projected) fields |
| Saves | decimal (32) | NULL | Yes | Total saves by the player in the game. Note: a player can have a maximum of one save in a single game |
| InningsPitchedDecimal | decimal (32) | NULL | Yes | Decimal representation of total innings pitched by the player in the game. Note: 1 out in an inning would be .33. 2 outs would be .66. Ex: 5 full innings and 1 out would be 5.33 |
| TotalOutsPitched | decimal (32) | NULL | Yes | The total number of outs recorded by the player in the game |
| InningsPitchedFull | decimal (32) | NULL | Yes | Total full innings pitched by the player in the game. Note: if the player has pitched 5.33 innings, this will be 5 as the 6th inning was not full yet |
| InningsPitchedOuts | decimal (32) | NULL | Yes | Outs pitched beyond InningsPitchedFull by the player in the game (possible values: 0; 1; 2) |
| EarnedRunAverage | decimal (32) | NULL | Yes | Total earned run average by the player in the game |
| PitchingHits | decimal (32) | NULL | Yes | Total hits allowed while pitching by the player in the game |
| PitchingRuns | decimal (32) | NULL | Yes | Total runs allowed while pitching by the player in the game |
| PitchingEarnedRuns | decimal (32) | NULL | Yes | Total earned runs allowed while pitching by the player in the game |
| PitchingWalks | decimal (32) | NULL | Yes | Total walks allowed while pitching by the player in the game |
| PitchingStrikeouts | decimal (32) | NULL | Yes | Total strikeouts while pitching by the player in the game |
| PitchingHomeRuns | decimal (32) | NULL | Yes | Total home runs allowed while pitching by the player in the game |
| PitchesThrown | decimal (32) | NULL | Yes | Total pitches thrown by the player in the game |
| PitchesThrownStrikes | decimal (32) | NULL | Yes | Total pitches thrown for strikes by the player in the game |
| WalksHitsPerInningsPitched | decimal (32) | NULL | Yes | Total walks and hits allowed by a player divided by innings pitched (WHIP) in the game |
| PitchingBattingAverageAgainst | decimal (32) | NULL | Yes | Total batting average against (BAA) while pitching by the player in the game |
| GrandSlams | decimal (32) | NULL | Yes | Total grand slams by the player in the game |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total FanDuel fantasy points by the player in the game |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings fantasy points by the player in the game |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total Yahoo fantasy points by the player in the game |
| PlateAppearances | decimal (32) | NULL | Yes | Total plate appearances by the player in the game |
| TotalBases | decimal (32) | NULL | Yes | The total number of bases recorded by the player in the game |
| FlyOuts | decimal (32) | NULL | Yes | Total fly outs by the player in the game |
| GroundOuts | decimal (32) | NULL | Yes | Total ground outs by the player in the game |
| LineOuts | decimal (32) | NULL | Yes | Total lineouts by the player in the game |
| PopOuts | decimal (32) | NULL | Yes | Total pop outs by the player in the game |
| IntentionalWalks | decimal (32) | NULL | Yes | Total intentional walks by the player in the game |
| ReachedOnError | decimal (32) | NULL | Yes | Total times the player reached base on an error in the game |
| BallsInPlay | decimal (32) | NULL | Yes | Total balls in play by the player in the game |
| BattingAverageOnBallsInPlay | decimal (32) | NULL | Yes | Total batting average on balls in play (BABIP) by the player in the game |
| WeightedOnBasePercentage | decimal (32) | NULL | Yes | Total weighted on base average (wOBA) by the player in the game delivered as a percentage |
| PitchingSingles | decimal (32) | NULL | Yes | Total singles allowed while pitching by the player in the game |
| PitchingDoubles | decimal (32) | NULL | Yes | Total doubles allowed while pitching by the player in the game |
| PitchingTriples | decimal (32) | NULL | Yes | Total triples allowed while pitching by the player in the game |
| PitchingGrandSlams | decimal (32) | NULL | Yes | Total grand slams allowed while pitching by the player in the game |
| PitchingHitByPitch | decimal (32) | NULL | Yes | Total batters hit by pitch while pitching by the player in the game |
| PitchingSacrifices | decimal (32) | NULL | Yes | Total sacrifices while pitching by the player in the game |
| PitchingSacrificeFlies | decimal (32) | NULL | Yes | Total sacrifice flies while pitching by the player in the game |
| PitchingGroundIntoDoublePlay | decimal (32) | NULL | Yes | Total grounded into double plays while pitching by the player in the game |
| PitchingCompleteGames | decimal (32) | NULL | Yes | Total complete games while pitching by the player in the game. Note: there can only be maximum one complete game pitched per game |
| PitchingShutOuts | decimal (32) | NULL | Yes | Total shutouts while pitching by the player in the game. Note: a player can have a maximum of one shutout in a single game |
| PitchingNoHitters | decimal (32) | NULL | Yes | Total no hitters while pitching by the player in the game. Note: a player can have maximum of one no hitter in a single game |
| PitchingPerfectGames | decimal (32) | NULL | Yes | Total perfect games while pitching by the player in the game. Note: there can be a maximum of one perfect game in a single game |
| PitchingPlateAppearances | decimal (32) | NULL | Yes | Total plate appearances while pitching by the player in the game |
| PitchingTotalBases | decimal (32) | NULL | Yes | Total bases allowed while pitching by the player in the game |
| PitchingFlyOuts | decimal (32) | NULL | Yes | Total fly outs while pitching by the player in the game |
| PitchingGroundOuts | decimal (32) | NULL | Yes | Total ground outs while pitching by the player in the game |
| PitchingLineOuts | decimal (32) | NULL | Yes | Total line outs while pitching by the player in the game |
| PitchingPopOuts | decimal (32) | NULL | Yes | Total pop outs while pitching by the player in the game |
| PitchingIntentionalWalks | decimal (32) | NULL | Yes | Total intentional walks while pitching by the player in the game |
| PitchingReachedOnError | decimal (32) | NULL | Yes | Total times reached on error occurred while pitching by the player in the game |
| PitchingCatchersInterference | decimal (32) | NULL | Yes | Total catchers interference while pitching by the player in the game |
| PitchingBallsInPlay | decimal (32) | NULL | Yes | Total balls in play while pitching by the player in the game |
| PitchingOnBasePercentage | decimal (32) | NULL | Yes | Total on base percentage (OBP) while pitching by the player in the game |
| PitchingSluggingPercentage | decimal (32) | NULL | Yes | Total slugging percentage (SLG) while pitching by the player in the game |
| PitchingOnBasePlusSlugging | decimal (32) | NULL | Yes | Total on base plus slugging (OPS) while pitching by the player in the game |
| PitchingStrikeoutsPerNineInnings | decimal (32) | NULL | Yes | Total strikeouts per nine innings (K/9) while pitching by the player in the game |
| PitchingWalksPerNineInnings | decimal (32) | NULL | Yes | Total walks per nine innings (BB/9) while pitching by the player in the game |
| PitchingBattingAverageOnBallsInPlay | decimal (32) | NULL | Yes | Total batting average on balls in play (BABIP) while pitching by the player in the game |
| PitchingWeightedOnBasePercentage | decimal (32) | NULL | Yes | Total weighted on base average (wOBA) while pitching by the player in the game delivered as a percentage |
| DoublePlays | decimal (32) | NULL | Yes | Total double plays by the player in the game Note: includes all types of double plays. Ex: ground into double play, fly into double play, popped out into double play, etc. |
| PitchingDoublePlays | decimal (32) | NULL | Yes | Total double plays while pitching by the player in the game |
| BattingOrderConfirmed | boolean | NULL | Yes | Whether the batting order is confirmed (true/false) |
| IsolatedPower | decimal (32) | NULL | Yes | Total isolated power (ISO) by the player in the game |
| FieldingIndependentPitching | decimal (32) | NULL | Yes | Total fielding independent pitching (FIP) by the player in the game |
| PitchingQualityStarts | decimal (32) | NULL | Yes | Total quality starts (QS) pitched by the player in the game. Note: a player can have a maximum of one quality start in a single game |
| PitchingInningStarted | integer (32) | NULL | Yes | The inning that the pitcher entered the game (if any). |
| LeftOnBase from 2017 | decimal (32) | NULL | Yes | Total runners left on base by the player in the game |
| PitchingHolds from 2017 | decimal (32) | NULL | Yes | Total holds pitched by the player in the game. Note: a player can have maximum one hold in a single game |
| PitchingBlownSaves from 2017 | decimal (32) | NULL | Yes | Total blown saves by the player in the game. Note: a player can have a maximum of one blown save in a single game |
| SubstituteBattingOrder from 2017 | integer (32) | NULL | Yes | The position in the batting order where this player was substituted into the game (does not include players in the starting lineup) |
| SubstituteBattingOrderSequence from 2017 | integer (32) | NULL | Yes | The sequence in which this player was substituted into the game, within the particular batting order |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Total FantasyDraft fantasy points by the player in the game |
| FantasyPointsBatting | decimal (32) | NULL | No | Total batting fantasy points by the player in the game |
| FantasyPointsPitching | decimal (32) | NULL | No | Total pitching fantasy points by the player in the game |
PlayerGameBasic
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Updated | datetime | NULL | No | The date and time of the late update made to this record (in US Eastern Time) |
| Games | integer (32) | NULL | No | The number of games played by the player. Note: for game feeds this will always = 1. |
| AtBats | decimal (32) | NULL | Yes | Total at bats by the player in the game |
| Runs | decimal (32) | NULL | Yes | Total runs scored by the player in the game |
| Hits | decimal (32) | NULL | Yes | Total hits by the player in the game |
| Singles | decimal (32) | NULL | Yes | Total singles by the player in the game |
| Doubles | decimal (32) | NULL | Yes | Total double plays by the player in the game. Note: includes all types of double plays. Ex: ground into double play, fly into double play, popped out into double play, etc. |
| Triples | decimal (32) | NULL | Yes | Total triples by the player in the game |
| HomeRuns | decimal (32) | NULL | Yes | Total home runs by the player in the game |
| RunsBattedIn | decimal (32) | NULL | Yes | Total runs batted in by the player in the game |
| BattingAverage | decimal (32) | NULL | Yes | Total batting average by the player in the game |
| Outs | decimal (32) | NULL | Yes | Total batting outs by the player in the game |
| Strikeouts | decimal (32) | NULL | Yes | Total strikeouts while batting by the player in the game |
| Walks | decimal (32) | NULL | Yes | Total walks recorded by the player in the game |
| HitByPitch | decimal (32) | NULL | Yes | Total times the player was hit by a pitch in the game |
| Sacrifices | decimal (32) | NULL | Yes | Total sacrifices by the player in the game |
| SacrificeFlies | decimal (32) | NULL | Yes | Total sacrifice flies by the player in the game |
| GroundIntoDoublePlay | decimal (32) | NULL | Yes | Total times the player grounded into double play (GIDP) in the game |
| StolenBases | decimal (32) | NULL | Yes | Total stolen bases by the player in the game |
| CaughtStealing | decimal (32) | NULL | Yes | Total times the player was caught stealing in the game |
| PitchesSeen | decimal (32) | NULL | Yes | Total pitches seen by the player in the game |
| OnBasePercentage | decimal (32) | NULL | Yes | Total on base percentage (OBP) by the player in the game |
| SluggingPercentage | decimal (32) | NULL | Yes | Total slugging percentage (SLG) of the player in the game. |
| OnBasePlusSlugging | decimal (32) | NULL | Yes | Total on base plus slugging percentage (OPS) by the player in the game |
| Errors | decimal (32) | NULL | Yes | Total errors committed by the player in the game |
| Wins | decimal (32) | NULL | Yes | Total wins recorded by the pitcher in the game |
| Losses | decimal (32) | NULL | Yes | Total pitching losses by the player in the game. Note: this can be either 0 or 1 for single game (non-projected) fields. |
| Saves | decimal (32) | NULL | Yes | Total saves by the player in the game |
| InningsPitchedDecimal | decimal (32) | NULL | Yes | Decimal representation of total innings pitched by the player in the game. Note: 1 out in an inning would be .33. 2 outs would be .66. Ex: 5 full innings and 1 out would be 5.33. |
| TotalOutsPitched | decimal (32) | NULL | Yes | The total number of outs recorded by the player in the game |
| InningsPitchedFull | decimal (32) | NULL | Yes | Total full innings pitched by the player in the game. Note: if the player has pitched 5.33 innings, this will be 5 as the 6th inning was not "full" yet. |
| InningsPitchedOuts | decimal (32) | NULL | Yes | Outs pitched beyond InningsPitchedFull by the player in the game (possible values: 0; 1; 2) |
| EarnedRunAverage | decimal (32) | NULL | Yes | Total earned run average by the player in the game |
| PitchingHits | decimal (32) | NULL | Yes | Total hits allowed while pitching by the player in the game |
| PitchingRuns | decimal (32) | NULL | Yes | Total runs allowed while pitching by the player in the game |
| PitchingEarnedRuns | decimal (32) | NULL | Yes | Total earned runs allowed while pitching by the player in the game |
| PitchingWalks | decimal (32) | NULL | Yes | Total walks allowed while pitching by the player in the game |
| PitchingStrikeouts | decimal (32) | NULL | Yes | Total strikeouts while pitching by the player in the game |
| PitchingHomeRuns | decimal (32) | NULL | Yes | Total home runs allowed while pitching by the player in the game |
| PitchesThrown | decimal (32) | NULL | Yes | Total pitches thrown by the player in the game |
| PitchesThrownStrikes | decimal (32) | NULL | Yes | Total pitches thrown for strikes by the player in the game |
| WalksHitsPerInningsPitched | decimal (32) | NULL | Yes | Total walks and hits allowed by a player divided by innings pitched (WHIP) in the game |
| PitchingBattingAverageAgainst | decimal (32) | NULL | Yes | Total batting average against (BAA) while pitching by the player in the game |
| GrandSlams | decimal (32) | NULL | Yes | Total grand slams by the player in the game |
| PlateAppearances | decimal (32) | NULL | Yes | Total plate appearances by the player in the game |
| TotalBases | decimal (32) | NULL | Yes | The total number of bases recorded by the player in the game |
| FlyOuts | decimal (32) | NULL | Yes | Total fly outs by the player in the game |
| GroundOuts | decimal (32) | NULL | Yes | Total ground outs by the player in the game |
| LineOuts | decimal (32) | NULL | Yes | Total lineouts by the player in the game |
| PopOuts | decimal (32) | NULL | Yes | Total pop outs by the player in the game |
| IntentionalWalks | decimal (32) | NULL | Yes | Total intentional walks by the player in the game |
| ReachedOnError | decimal (32) | NULL | Yes | Total times the player reached base on an error in the game |
| BallsInPlay | decimal (32) | NULL | Yes | Total balls in play by the player in the game |
| BattingAverageOnBallsInPlay | decimal (32) | NULL | Yes | Total batting average on balls in play (BABIP) |
| WeightedOnBasePercentage | decimal (32) | NULL | Yes | Total weighted on base percentage (wOBA) by the player in the game |
| PitchingSingles | decimal (32) | NULL | Yes | Total singles allowed while pitching by the player in the game |
| PitchingDoubles | decimal (32) | NULL | Yes | Total doubles allowed while pitching by the player in the game |
| PitchingTriples | decimal (32) | NULL | Yes | Total triples allowed while pitching by the player in the game |
| PitchingGrandSlams | decimal (32) | NULL | Yes | Total grand slams allowed while pitching by the player in the game |
| PitchingHitByPitch | decimal (32) | NULL | Yes | Total batters hit by pitch while pitching by the player in the game |
| PitchingSacrifices | decimal (32) | NULL | Yes | Total sacrifices while pitching by the player in the game |
| PitchingSacrificeFlies | decimal (32) | NULL | Yes | Total sacrifice flies while pitching by the player in the game |
| PitchingGroundIntoDoublePlay | decimal (32) | NULL | Yes | Total grounded into double plays while pitching by the player in the game |
| PitchingCompleteGames | decimal (32) | NULL | Yes | Total complete games while pitching by the player in the game. Note: there can only be maximum one complete game pitched per game. |
| PitchingShutOuts | decimal (32) | NULL | Yes | Total shutouts while pitching by the player in the game. Note: a player can have a maximum of one shutout in a single game. |
| PitchingNoHitters | decimal (32) | NULL | Yes | Total no hitters while pitching by the player in the game |
| PitchingPerfectGames | decimal (32) | NULL | Yes | Total perfect games while pitching by the player in the game. Note: there can be a maximum of one perfect game in a single game. |
| PitchingPlateAppearances | decimal (32) | NULL | Yes | Total plate appearances while pitching by the player in the game |
| PitchingTotalBases | decimal (32) | NULL | Yes | Total bases allowed while pitching by the player in the game |
| PitchingFlyOuts | decimal (32) | NULL | Yes | Total fly outs while pitching by the player in the game |
| PitchingGroundOuts | decimal (32) | NULL | Yes | Total ground outs while pitching by the player in the game |
| PitchingLineOuts | decimal (32) | NULL | Yes | Total line outs while pitching by the player in the game |
| PitchingPopOuts | decimal (32) | NULL | Yes | Total pop outs while pitching by the player in the game |
| PitchingIntentionalWalks | decimal (32) | NULL | Yes | Total intentional walks while pitching by the player in the game |
| PitchingReachedOnError | decimal (32) | NULL | Yes | Total times reached on error occurred while pitching by the player in the game |
| PitchingCatchersInterference | decimal (32) | NULL | Yes | Total catchers interference while pitching by the player in the game |
| PitchingBallsInPlay | decimal (32) | NULL | Yes | Total balls in play while pitching by the player in the game |
| PitchingOnBasePercentage | decimal (32) | NULL | Yes | Total on base percentage (OBP) while pitching by the player in the game |
| PitchingSluggingPercentage | decimal (32) | NULL | Yes | Total slugging percentage (SLG) while pitching by the player in the game |
| PitchingOnBasePlusSlugging | decimal (32) | NULL | Yes | Total on base plus slugging (OPS) while pitching by the player in the game |
| PitchingStrikeoutsPerNineInnings | decimal (32) | NULL | Yes | Total strikeouts per nine innings (K/9) while pitching by the player in the game |
| PitchingWalksPerNineInnings | decimal (32) | NULL | Yes | Total walks per nine innings (BB/9) while pitching by the player in the game |
| PitchingBattingAverageOnBallsInPlay | decimal (32) | NULL | Yes | Total batting average on balls in play (BABIP) while pitching by the player in the game |
| PitchingWeightedOnBasePercentage | decimal (32) | NULL | Yes | Total weighted on base percentage (wOBA) while pitching by the player in the game |
| DoublePlays | decimal (32) | NULL | Yes | Total double plays, defined as one of: Bunted into Double Play, Fly into Double Play, Fouled into Double Play, Ground into Double Pla,y Line into Double Play, Popped into Double Play |
| PitchingDoublePlays | decimal (32) | NULL | Yes | Total double plays while pitching by the player in the game |
| BattingOrderConfirmed | boolean | NULL | Yes | Whether the batting order is confirmed (true/false) |
| IsolatedPower | decimal (32) | NULL | Yes | Total isolated power (ISO) by the player in the game |
| FieldingIndependentPitching | decimal (32) | NULL | Yes | Total fielding independent pitching (FIP) by the player in the game |
| PitchingQualityStarts | decimal (32) | NULL | Yes | Total quality starts (QS) pitched by the player in the game. Note: a player can have a maximum of one quality start in a single game. |
| PitchingInningStarted | integer (32) | NULL | Yes | The inning that the pitcher entered the game (if any) |
| LeftOnBase | decimal (32) | NULL | Yes | Total runners left on base by the player in the game |
| PitchingHolds | decimal (32) | NULL | Yes | Total holds pitched by the player in the game. Note: a player can have maximum one hold in a single game. |
| PitchingBlownSaves | decimal (32) | NULL | Yes | Total blown saves by the player in the game. Note: a player can have a maximum of one blown save in a single game. |
| SubstituteBattingOrder | integer (32) | NULL | Yes | The position in the batting order where this player was substituted into the game (does not include players in the starting lineup) |
| SubstituteBattingOrderSequence | integer (32) | NULL | Yes | The sequence in which this player was substituted into the game, within the particular batting order |
| GameID | integer (32) | NULL | No | The unique ID of the game tied to this PlayerGame record |
| OpponentID | integer (32) | NULL | No | The TeamID of the opposing team in the game |
| Opponent | string (10) | NULL | No | The name [Key] of the player's opponent in 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 |
| HomeOrAway | string (4) | NULL | No | Whether the team is home or away |
| IsGameOver | boolean | NOT NULL | No | Whether or not the player's game is over (returns 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 team's 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 team's unique TeamID as assigned by SportsDataIO |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their MLB 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) |
| Season | integer (32) | NULL | No | The MLB season of the game |
| Name | string (50) | NULL | No | Player's full name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Position | string (10) | NULL | No | The player's position associated with the given game or season. Possible values: 1B; 2B; 3B; C; CF; DH; IF; LF; OF; P; PH; PR; RF; RP; SP; SS. |
| PositionCategory | string (10) | NULL | No | The player's position category. Possible values: DH; IF; OF; P; PH; PR. |
| Started | integer (32) | NULL | No | Whether the player started in the game. Note: started = 1 and not starting = 0. |
| BattingOrder | integer (32) | NULL | Yes | Where the player batted in the lineup for the game (1;2;3; etc.) |
| 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 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 MLB 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) |
| Season | integer (32) | NULL | No | The MLB season of the game |
| Name | string (50) | NULL | No | The player's full name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Position | string (10) | NULL | No | Player's position in the starting lineup (if started); otherwise the position he substituted for. Possible values: 1B; 2B; 3B; C; CF; DH; IF; LF; OF; P; PH; PR; RF; RP; SP; SS |
| PositionCategory | string (10) | NULL | No | The player's position category. Possible values: DH; IF; OF; P; PH; PR |
| Started | integer (32) | NULL | No | Whether the player started in the game. Note: this field will be projecting the starters until the lineup is confirmed in which the Started field will be = 1 and BattingOrderConfirmed = True |
| BattingOrder | integer (32) | NULL | Yes | Where the player batted in the lineup for the game (1;2;3; etc). Note: this is a projected number until the lineup is confirmed, in which the confirmed position will replace it, if applicable |
| FanDuelSalary from 2015 | 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 2015 | 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 | Indicates the player's injured body part. (e.g. ankle; knee; elbow; etc.) |
| InjuryStartDate from 2016 | date | NULL | No | The day that the injury started or 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 daily fantasy contests. |
| FantasyDraftPosition from 2017 | string (10) | NULL | No | The player's eligible position in Fantasy Drafts daily fantasy sports platform. |
| GameID | integer (32) | NULL | No | The unique ID of the game tied to this PlayerGameProjection record |
| OpponentID | integer (32) | NULL | No | The TeamID of the opposing team in the game |
| Opponent | string (10) | NULL | No | The name [Key] of the player's opponent in 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 |
| HomeOrAway | string (4) | NULL | No | Whether the team is home or away |
| IsGameOver | boolean | NOT NULL | No | Whether or not the player's 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 team's opponent. This value is guaranteed to be unique across all sports/leagues. |
| Updated | datetime | NULL | No | The date and time of the late update made to this record (in US Eastern Time) |
| Games | integer (32) | NULL | No | The projected number of games played by the player. Note: for game feeds this will always = 1 |
| FantasyPoints | decimal (32) | NULL | Yes | Total projected fantasy points by the player during the game |
| AtBats | decimal (32) | NULL | Yes | Total projected at bats by the player in the game |
| Runs | decimal (32) | NULL | Yes | Total projected runs scored by the player in the game |
| Hits | decimal (32) | NULL | Yes | Total projected hits by the player in the game |
| Singles | decimal (32) | NULL | Yes | Total projected singles by the player in the game |
| Doubles | decimal (32) | NULL | Yes | Total projected doubles by the player in the game |
| Triples | decimal (32) | NULL | Yes | Total projected triples by the player in the game |
| HomeRuns | decimal (32) | NULL | Yes | Total projected home runs by the player in the game |
| RunsBattedIn | decimal (32) | NULL | Yes | Total projected runs batted in by the player in the game |
| BattingAverage | decimal (32) | NULL | Yes | Total projected batting average by the player in the game |
| Outs | decimal (32) | NULL | Yes | Total projected batting outs by the player in the game |
| Strikeouts | decimal (32) | NULL | Yes | Total projected strikeouts while batting by the player in the game |
| Walks | decimal (32) | NULL | Yes | Total projected walks by the player in the game |
| HitByPitch | decimal (32) | NULL | Yes | Total projected times the player will be hit by a pitch in the game |
| Sacrifices | decimal (32) | NULL | Yes | Total projected sacrifices by the team in the game |
| SacrificeFlies | decimal (32) | NULL | Yes | Total projected sacrifice flies by the team in the game |
| GroundIntoDoublePlay | decimal (32) | NULL | Yes | Total projected times the player grounds into double play (GIDP) in the game |
| StolenBases | decimal (32) | NULL | Yes | Total projected stolen bases by the player in the game |
| CaughtStealing | decimal (32) | NULL | Yes | Total projected times the player will be caught stealing in the game |
| PitchesSeen | decimal (32) | NULL | Yes | Total projected pitches seen by the player in the game |
| OnBasePercentage | decimal (32) | NULL | Yes | Total projected on base percentage (OBP) by the player in the game |
| SluggingPercentage | decimal (32) | NULL | Yes | Total projected slugging percentage (SLG) of the player in the game |
| OnBasePlusSlugging | decimal (32) | NULL | Yes | Total projected on base plus slugging percentage (OPS) by the player in the game |
| Errors | decimal (32) | NULL | Yes | Total projected errors committed by the player in the game |
| Wins | decimal (32) | NULL | Yes | Total projected wins by the pitcher in the game |
| Losses | decimal (32) | NULL | Yes | Total projected pitching losses by the player in the game |
| Saves | decimal (32) | NULL | Yes | Total projected saves by player in the game. Note: a player can have maximum of one save in a game |
| InningsPitchedDecimal | decimal (32) | NULL | Yes | Decimal representation of total projected innings pitched by the player in the game. Note: 1 out in an inning would be .33. 2 outs would be .66. Ex: 5 full innings and 1 out would be 5.33 |
| TotalOutsPitched | decimal (32) | NULL | Yes | Total projected outs pitched by the player in the game |
| InningsPitchedFull | decimal (32) | NULL | Yes | Total projected full innings pitched by the player in the game. Note: if the player has pitched 5.33 innings, this will be 5 as the 6th inning was not full yet |
| InningsPitchedOuts | decimal (32) | NULL | Yes | Projected outs pitched beyond InningsPitchedFull by the player in the game (possible values: 0; 1; 2) |
| EarnedRunAverage | decimal (32) | NULL | Yes | Total projected earned run average by the player in the game |
| PitchingHits | decimal (32) | NULL | Yes | Total projected hits allowed while pitching by the player in the game |
| PitchingRuns | decimal (32) | NULL | Yes | Total projected runs allowed while pitching by the player in the game |
| PitchingEarnedRuns | decimal (32) | NULL | Yes | Total projected earned runs allowed while pitching by the player in the game |
| PitchingWalks | decimal (32) | NULL | Yes | Total projected walks allowed while pitching by the player in the game |
| PitchingStrikeouts | decimal (32) | NULL | Yes | Total projected strikeouts while pitching by the player in the game |
| PitchingHomeRuns | decimal (32) | NULL | Yes | Total projected home runs allowed while pitching by the player in the game |
| PitchesThrown | decimal (32) | NULL | Yes | Total projected pitches thrown by the player in the game |
| PitchesThrownStrikes | decimal (32) | NULL | Yes | Total projected pitches thrown for strikes by the player in the game |
| WalksHitsPerInningsPitched | decimal (32) | NULL | Yes | Total projected walks and hits allowed by a player divided by innings pitched (WHIP) in the game |
| PitchingBattingAverageAgainst | decimal (32) | NULL | Yes | Total projected batting average against (BAA) while pitching by the player in the game |
| GrandSlams | decimal (32) | NULL | Yes | Total projected grand slams by the player in the game |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total projected FanDuel fantasy points by the player in the game |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total projected DraftKings fantasy points by the player in the game |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total projected Yahoo fantasy points by the player in the game |
| PlateAppearances | decimal (32) | NULL | Yes | Total projected plate appearances by the player in the game |
| TotalBases | decimal (32) | NULL | Yes | The projected total number of bases recorded by the player in the game |
| FlyOuts | decimal (32) | NULL | Yes | Total projected fly outs by the player in the game |
| GroundOuts | decimal (32) | NULL | Yes | Total projected ground outs by the player in the game |
| LineOuts | decimal (32) | NULL | Yes | Total projected lineouts by the player in the game |
| PopOuts | decimal (32) | NULL | Yes | Total projected pop outs by the player in the game |
| IntentionalWalks | decimal (32) | NULL | Yes | Total projected intentional walks by the player in the game |
| ReachedOnError | decimal (32) | NULL | Yes | Total projected times the player will reach base on an error in the game |
| BallsInPlay | decimal (32) | NULL | Yes | Total projected balls in play by the player in the game |
| BattingAverageOnBallsInPlay | decimal (32) | NULL | Yes | Total projected batting average on balls in play (BABIP) by the player in the game |
| WeightedOnBasePercentage | decimal (32) | NULL | Yes | Total projected weighted on base percentage (wOBA) by the player in the game |
| PitchingSingles | decimal (32) | NULL | Yes | Total projected singles allowed while pitching by the player in the game |
| PitchingDoubles | decimal (32) | NULL | Yes | Total projected doubles allowed while pitching by the player in the game |
| PitchingTriples | decimal (32) | NULL | Yes | Total projected triples allowed while pitching by the player in the game |
| PitchingGrandSlams | decimal (32) | NULL | Yes | Total projected grand slams allowed while pitching by the player in the game |
| PitchingHitByPitch | decimal (32) | NULL | Yes | Total projected batters hit by pitch while pitching by the player in the game |
| PitchingSacrifices | decimal (32) | NULL | Yes | Total projected sacrifices while pitching by the player in the game |
| PitchingSacrificeFlies | decimal (32) | NULL | Yes | Total projected sacrifice flies while pitching by the player in the game |
| PitchingGroundIntoDoublePlay | decimal (32) | NULL | Yes | Total projected grounded into double plays while pitching by the player in the game |
| PitchingCompleteGames | decimal (32) | NULL | Yes | Total projected complete games while pitching by the player in the game. Note: there can only be maximum one complete game pitched per game |
| PitchingShutOuts | decimal (32) | NULL | Yes | Total projected shutouts while pitching by the player in the game. Note: a player can have a maximum of one shutout in a single game |
| PitchingNoHitters | decimal (32) | NULL | Yes | Total projected no hitters while pitching by the player in the game |
| PitchingPerfectGames | decimal (32) | NULL | Yes | Total projected perfect games while pitching by the player in the game. Note: there can be a maximum of one perfect game by in a single game |
| PitchingPlateAppearances | decimal (32) | NULL | Yes | Total projected plate appearances while pitching by the player in the game |
| PitchingTotalBases | decimal (32) | NULL | Yes | Total projected bases allowed while pitching by the player in the game |
| PitchingFlyOuts | decimal (32) | NULL | Yes | Total projected fly outs while pitching by the player in the season |
| PitchingGroundOuts | decimal (32) | NULL | Yes | Total projected ground outs while pitching by the player in the game |
| PitchingLineOuts | decimal (32) | NULL | Yes | Total projected line outs while pitching by the player in the game |
| PitchingPopOuts | decimal (32) | NULL | Yes | Total projected pop outs while pitching by the player in the game |
| PitchingIntentionalWalks | decimal (32) | NULL | Yes | Total projected intentional walks while pitching by the player in the game |
| PitchingReachedOnError | decimal (32) | NULL | Yes | Total projected times reached on error occurred while pitching by the player in the game |
| PitchingCatchersInterference | decimal (32) | NULL | Yes | Total projected catchers interference while pitching by the player in the game |
| PitchingBallsInPlay | decimal (32) | NULL | Yes | Total projected balls in play while pitching by the player in the game |
| PitchingOnBasePercentage | decimal (32) | NULL | Yes | Total projected on base percentage (OBP) while pitching by the player in the game |
| PitchingSluggingPercentage | decimal (32) | NULL | Yes | Total projected slugging percentage (SLG) while pitching by the player in the game |
| PitchingOnBasePlusSlugging | decimal (32) | NULL | Yes | Total projected on base plus slugging (OPS) while pitching by the player in the game |
| PitchingStrikeoutsPerNineInnings | decimal (32) | NULL | Yes | Total projected strikeouts per nine innings (K/9) while pitching by the player in the game |
| PitchingWalksPerNineInnings | decimal (32) | NULL | Yes | Total projected walks per nine innings (BB/9) while pitching by the player in the game |
| PitchingBattingAverageOnBallsInPlay | decimal (32) | NULL | Yes | Total projected batting average on balls in play (BABIP) while pitching by the player in the game |
| PitchingWeightedOnBasePercentage | decimal (32) | NULL | Yes | Total projected weighted on base percentage (wOBA) while pitching by the player in the game |
| DoublePlays | decimal (32) | NULL | Yes | Total projected double plays hit into by the player in the game. Note: includes all types of double plays. Ex: ground into double play, fly into double play, popped out into double play, etc. |
| PitchingDoublePlays | decimal (32) | NULL | Yes | Total projected double plays while pitching by the player in the game |
| BattingOrderConfirmed | boolean | NULL | Yes | Whether the batting order is confirmed |
| IsolatedPower | decimal (32) | NULL | Yes | Total projected isolated power (ISO) by the player in the game |
| FieldingIndependentPitching | decimal (32) | NULL | Yes | Total projected fielding independent pitching (FIP) by the player in the game |
| PitchingQualityStarts | decimal (32) | NULL | Yes | Total projected quality starts (QS) pitched by the player in the game. Note: a player can have a maximum of one quality start in a single game |
| PitchingInningStarted | integer (32) | NULL | Yes | This field is expected to be NULL |
| LeftOnBase from 2017 | decimal (32) | NULL | Yes | Total projected runners left on base by the player in the game |
| PitchingHolds from 2017 | decimal (32) | NULL | Yes | Total projected holds pitched by the player in the game. Note: a player can have maximum one hold in a single game |
| PitchingBlownSaves from 2017 | decimal (32) | NULL | Yes | "Total projected blown saves by the player in the game. Note: a player can have a maximum of one blown save in a single game" |
| SubstituteBattingOrder from 2017 | integer (32) | NULL | Yes | This field is expected to be NULL |
| SubstituteBattingOrderSequence from 2017 | integer (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Total projected FantasyDraft fantasy points by the player in the game |
| FantasyPointsBatting | decimal (32) | NULL | No | Total batting fantasy points by the player in the game |
| FantasyPointsPitching | decimal (32) | NULL | No | Total projected pitching fantasy points by the player in the game |
PlayerInfo
| 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 MLB career. |
| Name | string (50) | NULL | No | Player's full name |
| TeamID | integer (32) | NULL | No | The team's unique TeamID as assigned by SportsDataIO |
| Team | string (50) | NULL | No | The abbreviation [Key] of the team |
| Position | string (50) | NULL | No | The player's position associated with the given game or season. Possible values: 1B; 2B; 3B; C; CF; DH; IF; LF; OF; P; PH; PR; RF; RP; SP; SS. |
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 team's unique TeamID as assigned by SportsDataIO |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their MLB 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) |
| Season | integer (32) | NULL | No | The MLB season for which these totals apply |
| Name | string (50) | NULL | No | Player's full name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Position | string (10) | NULL | No | The player's position associated with the given game or season. Possible values: 1B; 2B; 3B; C; CF; DH; IF; LF; OF; P; PH; PR; RF; RP; SP; SS |
| PositionCategory | string (10) | NULL | No | The player's position category. Possible values: DH; IF; OF; P; PH; PR |
| Started | integer (32) | NULL | No | Number of games started in the season |
| BattingOrder | integer (32) | NULL | No | This field is expected to be NULL |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues |
| AverageDraftPosition | decimal (32) | NULL | Yes | The auction value for this player as it pertains to auction-style drafts for season-long fantasy baseball |
| AuctionValue | integer (32) | NULL | Yes | The auction value for this player as it pertains to auction-style drafts for season-long fantasy baseball |
| Updated | datetime | NULL | No | The date and time of the late update made to this record (in US Eastern Time) |
| Games | integer (32) | NULL | No | The number of games played by the player in the season. Note: for game feeds this will always = 1 |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the player during the season |
| AtBats | decimal (32) | NULL | Yes | Total at bats by the player in the season |
| Runs | decimal (32) | NULL | Yes | Total runs scored by the player in the season |
| Hits | decimal (32) | NULL | Yes | Total hits by the player in the season |
| Singles | decimal (32) | NULL | Yes | Total singles by the player in the season |
| Doubles | decimal (32) | NULL | Yes | Total doubles by the player in the season |
| Triples | decimal (32) | NULL | Yes | Total triples by the player in the season |
| HomeRuns | decimal (32) | NULL | Yes | Total home runs by the player in the season |
| RunsBattedIn | decimal (32) | NULL | Yes | Total runs batted in by the player in the season |
| BattingAverage | decimal (32) | NULL | Yes | Total batting average by the player in the season |
| Outs | decimal (32) | NULL | Yes | Total batting outs by the player in the season |
| Strikeouts | decimal (32) | NULL | Yes | Total strikeouts while batting by the player in the season |
| Walks | decimal (32) | NULL | Yes | Total walks recorded by the player during the season |
| HitByPitch | decimal (32) | NULL | Yes | Total times the player was hit by a pitch in the season |
| Sacrifices | decimal (32) | NULL | Yes | Total sacrifices by the player in the season |
| SacrificeFlies | decimal (32) | NULL | Yes | Total sacrifice flies by the player in the season |
| GroundIntoDoublePlay | decimal (32) | NULL | Yes | Total times the player grounded into double play (GIDP) in the season |
| StolenBases | decimal (32) | NULL | Yes | Total stolen bases by the player in the season |
| CaughtStealing | decimal (32) | NULL | Yes | Total times the player was caught stealing in the season |
| PitchesSeen | decimal (32) | NULL | Yes | Total pitches seen by the player in the season |
| OnBasePercentage | decimal (32) | NULL | Yes | Total on base percentage (OBP) by the player in the season |
| SluggingPercentage | decimal (32) | NULL | Yes | Total slugging percentage (SLG) of the player in the season |
| OnBasePlusSlugging | decimal (32) | NULL | Yes | Total on base plus slugging percentage (OPS) by the player in the season |
| Errors | decimal (32) | NULL | Yes | Total errors committed by the player in the season |
| Wins | decimal (32) | NULL | Yes | Total wins recorded by the pitcher in the season |
| Losses | decimal (32) | NULL | Yes | Total pitching losses by the player in the season. Note: this can be either 0 or 1 for single game (non-projected) fields |
| Saves | decimal (32) | NULL | Yes | Total saves by the player in the season |
| InningsPitchedDecimal | decimal (32) | NULL | Yes | Decimal representation of total innings pitched by the player in the season. Note: 1 out in an inning would be .33. 2 outs would be .66. Ex: 5 full innings and 1 out would be 5.33 |
| TotalOutsPitched | decimal (32) | NULL | Yes | Total outs pitched by the player in the season |
| InningsPitchedFull | decimal (32) | NULL | Yes | Total full innings pitched by the player in the season. Note: if the player has pitched 5.33 innings, this will be 5 as the 6th inning was not full yet |
| InningsPitchedOuts | decimal (32) | NULL | Yes | Outs pitched beyond InningsPitchedFull by the player in the season (possible values: 0; 1; 2) |
| EarnedRunAverage | decimal (32) | NULL | Yes | Total earned run average by the player in the season |
| PitchingHits | decimal (32) | NULL | Yes | Total hits allowed while pitching by the player in the season |
| PitchingRuns | decimal (32) | NULL | Yes | Total runs allowed while pitching by the player in the season |
| PitchingEarnedRuns | decimal (32) | NULL | Yes | Total earned runs allowed while pitching by the player in the season |
| PitchingWalks | decimal (32) | NULL | Yes | Total walks allowed while pitching by the player in the season |
| PitchingStrikeouts | decimal (32) | NULL | Yes | Total strikeouts while pitching by the player in the season |
| PitchingHomeRuns | decimal (32) | NULL | Yes | Total home runs allowed while pitching by the player in the season |
| PitchesThrown | decimal (32) | NULL | Yes | Total pitches thrown by the player in the season |
| PitchesThrownStrikes | decimal (32) | NULL | Yes | Total pitches thrown for strikes by the player in the season |
| WalksHitsPerInningsPitched | decimal (32) | NULL | Yes | Total walks and hits allowed by a player divided by innings pitched (WHIP) in the season |
| PitchingBattingAverageAgainst | decimal (32) | NULL | Yes | Total batting average against (BAA) while pitching by the player in the season |
| GrandSlams | decimal (32) | NULL | Yes | Total grand slams by the player in the season |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total FanDuel fantasy points by the player in the season |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings fantasy points by the player in the season |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total Yahoo fantasy points by the player in the season |
| PlateAppearances | decimal (32) | NULL | Yes | Total plate appearances by the player in the season |
| TotalBases | decimal (32) | NULL | Yes | The total number of bases recorded by the player in the season |
| FlyOuts | decimal (32) | NULL | Yes | Total fly outs by the player in the season |
| GroundOuts | decimal (32) | NULL | Yes | Total ground outs by the player in the season |
| LineOuts | decimal (32) | NULL | Yes | Total lineouts by the player in the season |
| PopOuts | decimal (32) | NULL | Yes | Total pop outs by the player in the season |
| IntentionalWalks | decimal (32) | NULL | Yes | Total intentional walks by the player in the season |
| ReachedOnError | decimal (32) | NULL | Yes | Total times the player reached base on an error in the season |
| BallsInPlay | decimal (32) | NULL | Yes | Total balls in play by the player in the season |
| BattingAverageOnBallsInPlay | decimal (32) | NULL | Yes | Total batting average on balls in play (BABIP) by the player in the season |
| WeightedOnBasePercentage | decimal (32) | NULL | Yes | Total weighted on base percentage (wOBA) by the player in the season |
| PitchingSingles | decimal (32) | NULL | Yes | Total singles allowed while pitching by the player in the season |
| PitchingDoubles | decimal (32) | NULL | Yes | Total doubles allowed while pitching by the player in the season |
| PitchingTriples | decimal (32) | NULL | Yes | Total triples allowed while pitching by the player in the season |
| PitchingGrandSlams | decimal (32) | NULL | Yes | Total grand slams allowed while pitching by the player in the season |
| PitchingHitByPitch | decimal (32) | NULL | Yes | Total batters hit by pitch while pitching by the player in the season |
| PitchingSacrifices | decimal (32) | NULL | Yes | Total sacrifices while pitching by the player in the season |
| PitchingSacrificeFlies | decimal (32) | NULL | Yes | Total sacrifice flies while pitching by the player in the season |
| PitchingGroundIntoDoublePlay | decimal (32) | NULL | Yes | Total grounded into double plays while pitching by the player in the season |
| PitchingCompleteGames | decimal (32) | NULL | Yes | Total complete games while pitching by the player in the season |
| PitchingShutOuts | decimal (32) | NULL | Yes | Total shutouts while pitching by the player in the season |
| PitchingNoHitters | decimal (32) | NULL | Yes | Total no hitters while pitching by the player in the season |
| PitchingPerfectGames | decimal (32) | NULL | Yes | Total perfect games while pitching by the player in the season |
| PitchingPlateAppearances | decimal (32) | NULL | Yes | Total plate appearances while pitching by the player in the season |
| PitchingTotalBases | decimal (32) | NULL | Yes | Total bases allowed while pitching by the player in the season |
| PitchingFlyOuts | decimal (32) | NULL | Yes | Total fly outs while pitching by the player in the season |
| PitchingGroundOuts | decimal (32) | NULL | Yes | Total ground outs while pitching by the player in the season |
| PitchingLineOuts | decimal (32) | NULL | Yes | Total line outs while pitching by the player in the season |
| PitchingPopOuts | decimal (32) | NULL | Yes | Total pop outs while pitching by the player in the season |
| PitchingIntentionalWalks | decimal (32) | NULL | Yes | Total intentional walks while pitching by the player in the season |
| PitchingReachedOnError | decimal (32) | NULL | Yes | Total times reached on error occurred while pitching by the player in the season |
| PitchingCatchersInterference | decimal (32) | NULL | Yes | Total catchers interference while pitching by the player in the season |
| PitchingBallsInPlay | decimal (32) | NULL | Yes | Total balls in play while pitching by the player in the season |
| PitchingOnBasePercentage | decimal (32) | NULL | Yes | Total on base percentage (OBP) while pitching by the player in the season |
| PitchingSluggingPercentage | decimal (32) | NULL | Yes | Total slugging percentage (SLG) while pitching by the player in the season |
| PitchingOnBasePlusSlugging | decimal (32) | NULL | Yes | Total on base plus slugging (OPS) while pitching by the player in the season |
| PitchingStrikeoutsPerNineInnings | decimal (32) | NULL | Yes | Total strikeouts per nine innings (K/9) while pitching by the player in the season |
| PitchingWalksPerNineInnings | decimal (32) | NULL | Yes | Total walks per nine innings (BB/9) while pitching by the player in the season |
| PitchingBattingAverageOnBallsInPlay | decimal (32) | NULL | Yes | Total batting average on balls in play (BABIP) while pitching by the player in the season |
| PitchingWeightedOnBasePercentage | decimal (32) | NULL | Yes | Total weighted on base percentage (wOBA) while pitching by the player in the season |
| DoublePlays | decimal (32) | NULL | Yes | Total double plays by the player in the season Note: includes all types of double plays. Ex: ground into double play, fly into double play, popped out into double play, etc. |
| PitchingDoublePlays | decimal (32) | NULL | Yes | Total double plays while pitching by the player in the season |
| BattingOrderConfirmed | boolean | NULL | Yes | Whether the batting order is confirmed (true/false) |
| IsolatedPower | decimal (32) | NULL | Yes | Total isolated power (ISO) by the player in the season |
| FieldingIndependentPitching | decimal (32) | NULL | Yes | Total fielding independent pitching (FIP) by the player in the season |
| PitchingQualityStarts | decimal (32) | NULL | Yes | Total quality starts (QS) pitched by the player in the season |
| PitchingInningStarted | integer (32) | NULL | Yes | This field is expected to be NULL |
| LeftOnBase from 2017 | decimal (32) | NULL | Yes | Total left on base percentage by the player in the season |
| PitchingHolds from 2017 | decimal (32) | NULL | Yes | Total holds pitched by the player in the season |
| PitchingBlownSaves from 2017 | decimal (32) | NULL | Yes | Total blown saves by the player in the season |
| SubstituteBattingOrder from 2017 | integer (32) | NULL | Yes | This field is expected to be NULL |
| SubstituteBattingOrderSequence from 2017 | integer (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Total FantasyDraft fantasy points by the player in the season |
| FantasyPointsBatting | decimal (32) | NULL | No | Total batting fantasy points by the player in the season |
| FantasyPointsPitching | decimal (32) | NULL | No | Total pitching fantasy points by the player in the season |
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 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 MLB 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) |
| Season | integer (32) | NULL | No | The MLB season for which these totals apply |
| Name | string (50) | NULL | No | The player's full name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Position | string (10) | NULL | No | The player's position associated with the given game or season. Possible values: 1B; 2B; 3B; C; CF; DH; IF; LF; OF; P; PH; PR; RF; RP; SP; SS |
| PositionCategory | string (10) | NULL | No | The player's position category. Possible values: DH; IF; OF; P; PH; PR |
| Started | integer (32) | NULL | No | Projected number of games started in the season |
| BattingOrder | integer (32) | NULL | No | This field is expected to be NULL |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues |
| AverageDraftPosition | decimal (32) | NULL | Yes | The average draft position of the player |
| AuctionValue | integer (32) | NULL | Yes | The auction value for this player as it pertains to auction-style drafts for season-long fantasy baseball |
| Updated | datetime | NULL | No | The date and time of the late update made to this record (in US Eastern Time) |
| Games | integer (32) | NULL | No | The projected number of games played by the player in the season. Note: for game feeds this will always = 1 |
| FantasyPoints | decimal (32) | NULL | Yes | Total projected fantasy points by the player during the season |
| AtBats | decimal (32) | NULL | Yes | Total projected at bats by the player in the season |
| Runs | decimal (32) | NULL | Yes | Total projected runs scored by the player in the season |
| Hits | decimal (32) | NULL | Yes | Total projected hits by the player in the season |
| Singles | decimal (32) | NULL | Yes | Total projected singles by the player in the game |
| Doubles | decimal (32) | NULL | Yes | Total projected doubles by the player in the season |
| Triples | decimal (32) | NULL | Yes | Total projected triples by the player in the season |
| HomeRuns | decimal (32) | NULL | Yes | Total projected home runs by the player in the season |
| RunsBattedIn | decimal (32) | NULL | Yes | Total projected runs batted in by the player in the season |
| BattingAverage | decimal (32) | NULL | Yes | Total projected batting average by the player in the season |
| Outs | decimal (32) | NULL | Yes | Total projected batting outs by the player in the season |
| Strikeouts | decimal (32) | NULL | Yes | Total projected strikeouts while batting by the player in the season |
| Walks | decimal (32) | NULL | Yes | Total projected walks by the player during the season |
| HitByPitch | decimal (32) | NULL | Yes | Total projected times the player will be hit by a pitch in the season |
| Sacrifices | decimal (32) | NULL | Yes | Total projected sacrifices by the team in the season |
| SacrificeFlies | decimal (32) | NULL | Yes | Total projected sacrifice flies by the team in the season |
| GroundIntoDoublePlay | decimal (32) | NULL | Yes | Total projected times the player grounds into double play (GIDP) in the season |
| StolenBases | decimal (32) | NULL | Yes | Total projected stolen bases by the player in the season |
| CaughtStealing | decimal (32) | NULL | Yes | Total projected times the player will be caught stealing in the season |
| PitchesSeen | decimal (32) | NULL | Yes | Total projected pitches seen by the player in the season |
| OnBasePercentage | decimal (32) | NULL | Yes | Total projected on base percentage (OBP) by the player in the season |
| SluggingPercentage | decimal (32) | NULL | Yes | Total projected slugging percentage (SLG) of the player in the season |
| OnBasePlusSlugging | decimal (32) | NULL | Yes | Total projected on base plus slugging percentage (OPS) by the player in the season |
| Errors | decimal (32) | NULL | Yes | Total projected errors committed by the player in the season |
| Wins | decimal (32) | NULL | Yes | Total projected wins by the pitcher in the season |
| Losses | decimal (32) | NULL | Yes | Total projected pitching losses by the player in the season |
| Saves | decimal (32) | NULL | Yes | Total projected saves by player in the season. Note: a player can have maximum of one save in a game |
| InningsPitchedDecimal | decimal (32) | NULL | Yes | Decimal representation of total projected innings pitched by the player in the season. Note: 1 out in an inning would be .33. 2 outs would be .66. Ex: 5 full innings and 1 out would be 5.33 |
| TotalOutsPitched | decimal (32) | NULL | Yes | Total projected outs pitched by the player in the season |
| InningsPitchedFull | decimal (32) | NULL | Yes | Total projected full innings pitched by the player in the season. Note: if the player has pitched 5.33 innings, this will be 5 as the 6th inning was not full yet |
| InningsPitchedOuts | decimal (32) | NULL | Yes | Projected outs pitched beyond InningsPitchedFull by the player in the season (possible values: 0; 1; 2) |
| EarnedRunAverage | decimal (32) | NULL | Yes | Total projected earned run average by the player in the season |
| PitchingHits | decimal (32) | NULL | Yes | Total projected hits allowed while pitching by the player in the season |
| PitchingRuns | decimal (32) | NULL | Yes | Total projected runs allowed while pitching by the player in the season |
| PitchingEarnedRuns | decimal (32) | NULL | Yes | Total projected earned runs allowed while pitching by the player in the season |
| PitchingWalks | decimal (32) | NULL | Yes | Total projected walks allowed while pitching by the player in the season |
| PitchingStrikeouts | decimal (32) | NULL | Yes | Total projected strikeouts while pitching by the player in the season |
| PitchingHomeRuns | decimal (32) | NULL | Yes | Total projected home runs allowed while pitching by the player in the season |
| PitchesThrown | decimal (32) | NULL | Yes | Total projected pitches thrown by the player in the season |
| PitchesThrownStrikes | decimal (32) | NULL | Yes | Total projected pitches thrown for strikes by the player in the season |
| WalksHitsPerInningsPitched | decimal (32) | NULL | Yes | Total projected walks and hits allowed by a player divided by innings pitched (WHIP) in the season |
| PitchingBattingAverageAgainst | decimal (32) | NULL | Yes | Total projected batting average against (BAA) while pitching by the player in the season |
| GrandSlams | decimal (32) | NULL | Yes | Total projected grand slams by the player in the season |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total projected FanDuel fantasy points by the player in the season |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total projected DraftKings fantasy points by the player in the season |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total projected Yahoo fantasy points by the player in the season |
| PlateAppearances | decimal (32) | NULL | Yes | Total projected plate appearances by the player in the season |
| TotalBases | decimal (32) | NULL | Yes | The projected total number of bases recorded by the player in the season |
| FlyOuts | decimal (32) | NULL | Yes | Total projected fly outs by the player in the season |
| GroundOuts | decimal (32) | NULL | Yes | Total projected ground outs by the player in the season |
| LineOuts | decimal (32) | NULL | Yes | Total projected lineouts by the player in the season |
| PopOuts | decimal (32) | NULL | Yes | Total projected pop outs by the player in the season |
| IntentionalWalks | decimal (32) | NULL | Yes | Total projected intentional walks by the player in the season |
| ReachedOnError | decimal (32) | NULL | Yes | Total projected times the player will reach base on an error in the season |
| BallsInPlay | decimal (32) | NULL | Yes | Total projected balls in play by the player in the season |
| BattingAverageOnBallsInPlay | decimal (32) | NULL | Yes | Total projected batting average on balls in play (BABIP) by the player in the season |
| WeightedOnBasePercentage | decimal (32) | NULL | Yes | Total projected weighted on base percentage (wOBA) by the player in the season |
| PitchingSingles | decimal (32) | NULL | Yes | Total projected singles allowed while pitching by the player in the season |
| PitchingDoubles | decimal (32) | NULL | Yes | Total projected doubles allowed while pitching by the player in the season |
| PitchingTriples | decimal (32) | NULL | Yes | Total projected triples allowed while pitching by the player in the season |
| PitchingGrandSlams | decimal (32) | NULL | Yes | Total projected grand slams allowed while pitching by the player in the season |
| PitchingHitByPitch | decimal (32) | NULL | Yes | Total projected batters hit by pitch while pitching by the player in the season |
| PitchingSacrifices | decimal (32) | NULL | Yes | Total projected sacrifices while pitching by the player in the season |
| PitchingSacrificeFlies | decimal (32) | NULL | Yes | Total projected sacrifice flies while pitching by the player in the season |
| PitchingGroundIntoDoublePlay | decimal (32) | NULL | Yes | Total projected grounded into double plays while pitching by the player in the season |
| PitchingCompleteGames | decimal (32) | NULL | Yes | Total projected complete games while pitching by the player in the season |
| PitchingShutOuts | decimal (32) | NULL | Yes | Total projected shutouts while pitching by the player in the season |
| PitchingNoHitters | decimal (32) | NULL | Yes | Total projected no hitters while pitching by the player in the season |
| PitchingPerfectGames | decimal (32) | NULL | Yes | Total projected perfect games while pitching by the player in the season |
| PitchingPlateAppearances | decimal (32) | NULL | Yes | Total projected plate appearances while pitching by the player in the season |
| PitchingTotalBases | decimal (32) | NULL | Yes | Total projected bases allowed while pitching by the player in the season |
| PitchingFlyOuts | decimal (32) | NULL | Yes | Total projected fly outs while pitching by the player in the season |
| PitchingGroundOuts | decimal (32) | NULL | Yes | Total projected ground outs while pitching by the player in the season |
| PitchingLineOuts | decimal (32) | NULL | Yes | Total projected line outs while pitching by the player in the season |
| PitchingPopOuts | decimal (32) | NULL | Yes | Total projected pop outs while pitching by the player in the season |
| PitchingIntentionalWalks | decimal (32) | NULL | Yes | Total projected intentional walks while pitching by the player in the season |
| PitchingReachedOnError | decimal (32) | NULL | Yes | Total projected times reached on error occurred while pitching by the player in the season |
| PitchingCatchersInterference | decimal (32) | NULL | Yes | Total projected catchers interference while pitching by the player in the season |
| PitchingBallsInPlay | decimal (32) | NULL | Yes | Total projected balls in play while pitching by the player in the season |
| PitchingOnBasePercentage | decimal (32) | NULL | Yes | Total projected on base percentage (OBP) while pitching by the player in the season |
| PitchingSluggingPercentage | decimal (32) | NULL | Yes | Total projected slugging percentage (SLG) while pitching by the player in the season |
| PitchingOnBasePlusSlugging | decimal (32) | NULL | Yes | Total projected on base plus slugging (OPS) while pitching by the player in the season |
| PitchingStrikeoutsPerNineInnings | decimal (32) | NULL | Yes | Total projected strikeouts per nine innings (K/9) while pitching by the player in the season |
| PitchingWalksPerNineInnings | decimal (32) | NULL | Yes | Total projected walks per nine innings (BB/9) while pitching by the player in the season |
| PitchingBattingAverageOnBallsInPlay | decimal (32) | NULL | Yes | Total projected batting average on balls in play (BABIP) while pitching by the player in the season |
| PitchingWeightedOnBasePercentage | decimal (32) | NULL | Yes | Total projected weighted on base percentage (wOBA) while pitching by the player in the season |
| DoublePlays | decimal (32) | NULL | Yes | Total projected time the player will hit into a double play in the season. Note: includes all types of double plays. Ex: ground into double play, fly into double play, popped out into double play, etc. |
| PitchingDoublePlays | decimal (32) | NULL | Yes | Total projected double plays while pitching by the player in the season |
| BattingOrderConfirmed | boolean | NULL | Yes | This field is expected to be NULL |
| IsolatedPower | decimal (32) | NULL | Yes | Total projected isolated power (ISO) by the player in the season |
| FieldingIndependentPitching | decimal (32) | NULL | Yes | Total projected fielding independent pitching (FIP) by the player in the season |
| PitchingQualityStarts | decimal (32) | NULL | Yes | Total projected quality starts (QS) pitched by the player in the season |
| PitchingInningStarted | integer (32) | NULL | Yes | This field is expected to be NULL |
| LeftOnBase from 2017 | decimal (32) | NULL | Yes | Total projected runners left on base by the player in the season |
| PitchingHolds from 2017 | decimal (32) | NULL | Yes | Total projected holds pitched by the player in the season |
| PitchingBlownSaves from 2017 | decimal (32) | NULL | Yes | Total projected blown saves by the player in the season |
| SubstituteBattingOrder from 2017 | integer (32) | NULL | Yes | This field is expected to be NULL |
| SubstituteBattingOrderSequence from 2017 | integer (32) | NULL | Yes | This field is expected to be NULL |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Total projected FantasyDraft fantasy points by the player in the season |
| FantasyPointsBatting | decimal (32) | NULL | No | Total batting fantasy points by the player in the season |
| FantasyPointsPitching | decimal (32) | NULL | No | Total projected pitching fantasy points by the player in the season |
ScheduleBasic
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 |
| Season | integer (32) | NOT NULL | No | The MLB 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) |
| Status | string (20) | NULL | No | Indicates the game's status. Possible values include: Scheduled; InProgress; Final; Suspended; Delayed; Postponed; Canceled; Forfeit; NotNecessary |
| Day | date | NULL | No | The date of the game |
| DateTime | datetime | NULL | No | The date and time of the game in US Eastern Time |
| AwayTeam | string (50) | NULL | No | The abbreviation [Key] of the away team |
| HomeTeam | string (50) | NULL | No | The abbreviation [Key] of the Home Team |
| AwayTeamID | integer (32) | NULL | No | The unique TeamID of the away team |
| HomeTeamID | integer (32) | NULL | No | The unique ID of the home team |
| RescheduledGameID | integer (32) | NULL | No | The GameID of the game that was rescheduled from this game. This only pertains to postponed games that require rescheduling. |
| StadiumID | integer (32) | NULL | No | The unique ID of the stadium |
| 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. |
| Updated | datetime | NULL | No | The date and time of the late update made to this record (in US Eastern Time) |
| GameEndDateTime | datetime | NULL | No | The date and time that the game ended in US Eastern Time |
| DateTimeUTC | datetime | NULL | No | The date and time of the game in UTC |
| SeriesInfo | Series (32) | NULL | No | Contains relevant series data for postseason series only - HomeTeamWins; AwayTeamWins; GameNumber; and MaxLength |
| 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. |
| SuspensionResumeDay | date | NULL | No | The date a game that was suspended in play will be resumed for play. Useful for tracking when a Suspended game will return to an InProgress status. |
| SuspensionResumeDateTime | datetime | NULL | No | The date and start-time that the suspended in play game will be resumed for play. Useful for tracking when a Suspended game will return to an InProgress status. |
ScoreBasic
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| AwayTeamRuns | integer (32) | NULL | Yes | Number of runs scored by the away team in the game |
| HomeTeamRuns | integer (32) | NULL | Yes | Number of runs scored by the home team in the game |
| AwayTeamHits | integer (32) | NULL | Yes | Total hits by the away team in the game |
| HomeTeamHits | integer (32) | NULL | Yes | Total hits by the home team in the game |
| AwayTeamErrors | integer (32) | NULL | Yes | Total errors committed by the away team in the game |
| HomeTeamErrors | integer (32) | NULL | Yes | Total errors committed by the home team in the game |
| Attendance | integer (32) | NULL | No | Total number of people who attended the game |
| 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. |
| NeutralVenue | boolean | NULL | No | Indicates whether this game is played in a neutral venue |
| Inning | integer (32) | NULL | No | The inning that the game is currently in, or the inning in which the game ended. Possible values include: NULL, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, etc) |
| InningHalf | string (1) | NULL | No | The inning half that the game is currently in; or the inning half in which the game ended (possible values: T; B; E: M: NULL) |
| GameID | integer (32) | NULL | No | The unique ID of this game |
| Season | integer (32) | NOT NULL | No | The MLB 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) |
| Status | string (20) | NULL | No | Indicates the game's status. Possible values include: Scheduled; InProgress; Final; Suspended; Delayed; Postponed; Canceled; Forfeit; NotNecessary |
| Day | date | NULL | No | The date of the game |
| DateTime | datetime | NULL | No | The date and time of the game in US Eastern Time |
| AwayTeam | string (50) | NULL | No | The abbreviation [Key] of the away team |
| HomeTeam | string (50) | NULL | No | The abbreviation [Key] of the Home Team |
| AwayTeamID | integer (32) | NULL | No | The unique TeamID of the away team |
| HomeTeamID | integer (32) | NULL | No | The unique ID of the home team |
| RescheduledGameID | integer (32) | NULL | No | The GameID of the game that was rescheduled from this game. This only pertains to postponed games that require rescheduling. |
| StadiumID | integer (32) | NULL | No | The unique ID of the stadium |
| 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 |
| Updated | datetime | NULL | No | The date and time of the late update made to this record (in US Eastern Time) |
| GameEndDateTime | datetime | NULL | No | The date and time that the game ended in US Eastern Time |
| DateTimeUTC | datetime | NULL | No | The date and time of the game in UTC |
| SeriesInfo | Series (32) | NULL | No | Contains relevant series data for postseason series only - HomeTeamWins; AwayTeamWins; GameNumber; and MaxLength |
| 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. |
| SuspensionResumeDay | date | NULL | No | The date a game that was suspended in play will be resumed for play. Useful for tracking when a Suspended game will return to an InProgress status. |
| SuspensionResumeDateTime | datetime | NULL | No | The date and start-time that the suspended in play game will be resumed for play. Useful for tracking when a Suspended game will return to an InProgress status. |
Season
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Season | integer (32) | NOT NULL | No | The MLB season for which these totals apply |
| 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). |
| 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 | Number of wins by the home team on in the series. Note: this is for postseason series only. |
| AwayTeamWins | integer (32) | NOT NULL | No | Number of wins by the away team in the series. Note: This is for postseason series only. |
| GameNumber | integer (32) | NOT NULL | No | Game number in series. Note: this applies to postseason series only. |
| MaxLength | integer (32) | NOT NULL | No | Maximum number of games in the series. Note: this is for postseason series only. |
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 Game
- Betting Markets - by Market Type
- 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 | Unique ID of the sportsbook |
| Name | string (32) | NOT NULL | Yes | The name of the sportsbook(s) |
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 active |
| Name | string (100) | NOT NULL | No | The full name of the stadium |
| City | string (50) | NULL | No | The city where the stadium is located |
| State | string (10) | NULL | No | The state where the stadium is located (only US and Canadian stadiums will have values) |
| Country | string (10) | NULL | No | The 3-digit country code where the stadium is located |
| Capacity | integer (32) | NULL | No | The estimated seating capacity of the stadium |
| Surface | string (50) | NULL | No | The playing surface of the stadium (Grass, Artificial or Dome) |
| LeftField | integer (32) | NULL | No | The estimated distance between home plate and the left field wall |
| MidLeftField | integer (32) | NULL | No | The estimated distance between home plate and the mid left field wall |
| LeftCenterField | integer (32) | NULL | No | The estimated distance between home plate and the left center field wall |
| MidLeftCenterField | integer (32) | NULL | No | The estimated distance between home plate and the mid left center field wall |
| CenterField | integer (32) | NULL | No | The estimated distance between home plate and the center field wall |
| MidRightCenterField | integer (32) | NULL | No | The estimated distance between home plate and the mid right center field wall |
| RightCenterField | integer (32) | NULL | No | The estimated distance between home plate and the right center field wall |
| MidRightField | integer (32) | NULL | No | The estimated distance between home plate and the mid right field wall |
| RightField | integer (32) | NULL | No | The estimated distance between home plate and the right field wall |
| GeoLat | decimal (32) | NULL | No | The geographic latitude coordinate of this venue |
| GeoLong | decimal (32) | NULL | No | The geographic longitude coordinate of this venue |
| Altitude | integer (32) | NULL | No | The altitude of the stadium in feet |
| HomePlateDirection | integer (32) | NULL | No | The direction that the batter is facing while looking at the pitcher's mound. If the home plate is at the north of the stadium, the batter is facing south, so the value is given as 180 degrees. If home plate is at the east the batter faces west, so it's 270 degrees. If the home plate is at the south the batter faces north, so it's 0 degrees. If the home plate is at the west the batter faces east, so it's 90 degrees. |
| Type | string (50) | NULL | No | The type of the stadium (possible values: Outdoor, Dome, RetractableDome) |
Standing
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Season | integer (32) | NOT NULL | No | The MLB season for which these totals apply |
| 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) |
| TeamID | Integer (32) | NOT NULL | No | The team's unique TeamID as assigned by SportsDataIO |
| Key | string (10) | NOT NULL | No | Abbreviation of the team (e.g. LAD; PHI; BOS; CHC; etc.) |
| City | string (50) | NULL | No | The city/location of the team (e.g. Los Angeles; Philadelphia; Boston; Chicago; etc.) |
| Name | string (50) | NULL | No | Team's full name (city and mascot) |
| League | string (20) | NULL | No | The league of the team (possible values: AL; NL) |
| Division | string (20) | NULL | No | The division of the team (e.g. East, Central, West) |
| Wins | integer (32) | NULL | No | The total number of wins by a team in the season |
| Losses | integer (32) | NULL | No | Total number of losses by the team in the season |
| Percentage | decimal (32) | NULL | No | Winning percentage of a team |
| DivisionWins | integer (32) | NULL | No | Total number of division wins in the season |
| DivisionLosses | integer (32) | NULL | No | Total number of division losses in a season |
| GamesBehind from 2012 | decimal (32) | NULL | No | Number of games behind the first place team |
| LastTenGamesWins from 2012 | integer (32) | NULL | No | Total number of wins in the last ten games |
| LastTenGamesLosses from 2012 | integer (32) | NULL | No | Total number of losses in the last ten games |
| Streak from 2012 | string (10) | NULL | No | Current streak the team is on (e.g. Win 3, Lost 3) |
| LeagueRank | integer (32) | NULL | No | The ranking in the league |
| DivisionRank | integer (32) | NULL | No | The ranking in the division (e.g. 1, 2, 3, 4, 5) |
| WildCardRank from 2012 | integer (32) | NULL | No | The rank of the team in terms of Wild Card standings only |
| WildCardGamesBehind from 2012 | decimal (32) | NULL | No | The number of games behind a team is of the final Wild Card spot |
| HomeWins from 2012 | integer (32) | NULL | No | Total number of home wins in the season |
| HomeLosses from 2012 | integer (32) | NULL | No | Total number of home losses in the season |
| AwayWins from 2012 | integer (32) | NULL | No | Total number of away wins in the season |
| AwayLosses from 2012 | integer (32) | NULL | No | Total number of away losses in the season |
| DayWins from 2012 | integer (32) | NULL | No | Total number of wins in daytime games |
| DayLosses from 2012 | integer (32) | NULL | No | Total number of losses in daytime games |
| NightWins from 2012 | integer (32) | NULL | No | Total number of wins in nighttime games |
| NightLosses from 2012 | integer (32) | NULL | No | Total number of losses in nighttime games |
| RunsScored from 2012 | integer (32) | NULL | No | Total runs scored by the team in the season |
| RunsAgainst from 2012 | integer (32) | NULL | No | Total number of runs scored by the opponents of a specified team |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| ClinchedBestLeagueRecord | boolean | NULL | No | Returns TRUE if team has clinched the best record in their respective league; FALSE if not |
| ClinchedWildCard | boolean | NULL | No | Returns TRUE if team has clinched Wild Card spot; FALSE if not |
| ClinchedDivision | boolean | NULL | No | Returns TRUE if team has clinched their division; FALSE if not |
| EliminatedFromPlayoffContention | boolean | NULL | No | Returns TRUE if team has been eliminated from playoff contention; 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 tied to the StartingLineups |
| Season from 2021 | integer (32) | NOT NULL | No | The MLB season of the game |
| 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) |
| Day from 2021 | datetime (32) | NULL | No | The day of the game |
| DateTime from 2021 | datetime (32) | NULL | No | The date and time of the game in US Eastern Time |
| Status from 2021 | string (32) | NULL | No | Indicates the game's status. Possible values include: Scheduled; InProgress; Final; Suspended; Delayed; Postponed; Canceled; Forfeit; NotNecessary |
| HomeTeamID from 2021 | integer (32) | NULL | No | The unique ID of the home team tied to these StartingLineups |
| HomeTeam from 2021 | string (32) | NULL | No | The abbreviation [Key] of the Home Team |
| AwayTeamID from 2021 | integer (32) | NULL | No | The unique TeamID of the away team |
| AwayTeam from 2021 | string (32) | NULL | No | The abbreviation [Key] of the away team |
| HomeStartingPitcher from 2021 | Lineup (32) | NULL | No | Home team starting pitcher. Note: this is a probable pitcher until confirmed field = TRUE. |
| HomeBattingLineup from 2021 | Lineup[] (32) | NULL | No | The batting lineup of the home team |
| AwayStartingPitcher from 2021 | Lineup (32) | NULL | No | Away team starting pitcher. Note: this is a probable pitcher until confirmed field = TRUE. |
| AwayBattingLineup from 2021 | Lineup[] (32) | NULL | No | Away team batting lineup for the game |
| HomeTeamOpener | boolean | NULL | No | Indicates whether the home team will use an Opener as the starting pitcher. NOTE: An opener is a pitcher (typically a relief pitcher) that is only scheduled to pitch the first 1-3 innings of the game. |
| AwayTeamOpener | boolean | NULL | No | Indicates whether the away team will use an Opener as the starting pitcher. NOTE: An opener is a pitcher (typically a relief pitcher) that is only scheduled to pitch the first 1-3 innings of the 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 team's unique TeamID as assigned by SportsDataIO |
| [Key] | string (10) | NOT NULL | No | Abbreviation of the team (e.g. LAD, PHI, BOS, CHC, 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. Dodgers, Phillies, Red Sox, Cubs, etc.) |
| StadiumID | integer (32) | NULL | No | The unique ID of the team's current home stadium |
| League | string (10) | NULL | No | The league of the team (possible values: AL, NL) |
| Division | string (10) | NULL | No | The division of the team (e.g. East; Central; West) |
| PrimaryColor | string (6) | NULL | No | The team's primary color. (This is not licensed for public or commercial use) |
| SecondaryColor | string (6) | NULL | No | The team's secondary color. (This is not licensed for public or commercial use) |
| TertiaryColor | string (6) | NULL | No | The team's tertiary color. (This is not licensed for public or commercial use) |
| QuaternaryColor | string (6) | NULL | No | The team's quaternary 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 |
| HeadCoach | string (50) | NULL | No | The current head coach (manager) of the team |
| HittingCoach | string (50) | NULL | No | The current hitting coach of the team. Note: some teams may have multiple or no hitting coaches |
| PitchingCoach | string (50) | NULL | No | The current pitching coach of the team. Note: some teams may have multiple or no pitching coaches |
TeamDepthChart
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| DepthCharts from 2022 | DepthChart[] (32) | NULL | No | List of Depth Chart Records for Team |
| TeamID from 2022 | integer (32) | NOT NULL | No | The team's unique TeamID as assigned by SportsDataIO |
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 team's unique TeamID as assigned by SportsDataIO |
| 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) |
| Season | integer (32) | NULL | No | The MLB season of the game |
| Name | string (50) | NULL | No | Team's full name (city and mascot) |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| 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 tied to this TeamGame record |
| OpponentID | integer (32) | NULL | No | The TeamID of the opposing team in the game |
| Opponent | string (10) | NULL | No | The name [Key] of the team's opponent in 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) |
| HomeOrAway | string (4) | NULL | No | Whether the team is home or away |
| IsGameOver | boolean | NOT NULL | No | Whether or not the team's game is over (returns 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 team's opponent. This value is guaranteed to be unique across all sports/leagues. |
| Updated | datetime | NULL | No | The date and time of the late update made to this record (in US Eastern Time) |
| Games | integer (32) | NULL | No | The number of games played by the team. Note: for game feeds this will always = 1 |
| FantasyPoints | decimal (32) | NULL | Yes | This field is expected to be 0 |
| AtBats | decimal (32) | NULL | Yes | Total at bats by the team in the game |
| Runs | decimal (32) | NULL | Yes | Total runs scored by the team in the game |
| Hits | decimal (32) | NULL | Yes | Total hits by the team in the game |
| Singles | decimal (32) | NULL | Yes | Total singles by the team in the game |
| Doubles | decimal (32) | NULL | Yes | Total doubles by the team in the game |
| Triples | decimal (32) | NULL | Yes | Total triples by the team in the game |
| HomeRuns | decimal (32) | NULL | Yes | Total home runs by the team in the game |
| RunsBattedIn | decimal (32) | NULL | Yes | Total runs batted in by the team in the game |
| BattingAverage | decimal (32) | NULL | Yes | Total batting average by the team in the game |
| Outs | decimal (32) | NULL | Yes | Total batting outs by the team in the game |
| Strikeouts | decimal (32) | NULL | Yes | Total strikeouts while batting by the team in the game |
| Walks | decimal (32) | NULL | Yes | Total walks recorded by the team in the game |
| HitByPitch | decimal (32) | NULL | Yes | Total times the team was hit by a pitch in the game |
| Sacrifices | decimal (32) | NULL | Yes | Total sacrifices by the team in the game |
| SacrificeFlies | decimal (32) | NULL | Yes | Total sacrifice flies by the team in the game |
| GroundIntoDoublePlay | decimal (32) | NULL | Yes | Total times the team grounded into double play (GIDP) in the game |
| StolenBases | decimal (32) | NULL | Yes | Total stolen bases by the team in the game |
| CaughtStealing | decimal (32) | NULL | Yes | Total times the team was caught stealing in the game |
| PitchesSeen | decimal (32) | NULL | Yes | Total pitches seen by the team in the game |
| OnBasePercentage | decimal (32) | NULL | Yes | Total on base percentage (OBP) by the team in the game |
| SluggingPercentage | decimal (32) | NULL | Yes | Total slugging percentage (SLG) of the team in the game |
| OnBasePlusSlugging | decimal (32) | NULL | Yes | Total on base plus slugging percentage (OPS) by the team in the game |
| Errors | decimal (32) | NULL | Yes | Total errors committed by the team in the game |
| Wins | decimal (32) | NULL | Yes | Total wins recorded by the team in the game |
| Losses | decimal (32) | NULL | Yes | Total losses by the team in the game. Note: this can be either 0 or 1 for single game (non-projected) fields |
| Saves | decimal (32) | NULL | Yes | Total saves by the team in the game |
| InningsPitchedDecimal | decimal (32) | NULL | Yes | Decimal representation of total innings pitched by the team in the game. Note: 1 out in an inning would be .33. 2 outs would be .66. Ex: 5 full innings and 1 out would be 5.33 |
| TotalOutsPitched | decimal (32) | NULL | Yes | Total outs pitched by the team in the game |
| InningsPitchedFull | decimal (32) | NULL | Yes | Total projected full innings pitched by the team in the game. Note: if the team has pitched 5.33 innings, this will be 5 as the 6th inning was not full yet |
| InningsPitchedOuts | decimal (32) | NULL | Yes | Outs pitched beyond InningsPitchedFull by the team in the game (possible values: 0; 1; 2) |
| EarnedRunAverage | decimal (32) | NULL | Yes | Total earned run average by the team in the game |
| PitchingHits | decimal (32) | NULL | Yes | Total hits allowed while pitching by the team in the game |
| PitchingRuns | decimal (32) | NULL | Yes | Total runs allowed while pitching by the team in the game |
| PitchingEarnedRuns | decimal (32) | NULL | Yes | Total earned runs allowed while pitching by the team in the game |
| PitchingWalks | decimal (32) | NULL | Yes | Total walks allowed while pitching by the team in the game |
| PitchingStrikeouts | decimal (32) | NULL | Yes | Total strikeouts while pitching by the team in the game |
| PitchingHomeRuns | decimal (32) | NULL | Yes | Total home runs allowed while pitching by the team in the game |
| PitchesThrown | decimal (32) | NULL | Yes | Total pitches thrown by the team in the game |
| PitchesThrownStrikes | decimal (32) | NULL | Yes | Total pitches thrown for strikes by the team in the game |
| WalksHitsPerInningsPitched | decimal (32) | NULL | Yes | Total walks and hits allowed by the team divided by innings pitched (WHIP) in the game |
| PitchingBattingAverageAgainst | decimal (32) | NULL | Yes | Total batting average against (BAA) while pitching by the team in the game |
| GrandSlams | decimal (32) | NULL | Yes | Total grand slams by the team in the game |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | This field is expected to be 0 |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | This field is expected to be 0 |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | This field is expected to be 0 |
| PlateAppearances | decimal (32) | NULL | Yes | Total plate appearances by the team in the game |
| TotalBases | decimal (32) | NULL | Yes | The total number of bases recorded by the team in the game |
| FlyOuts | decimal (32) | NULL | Yes | Total fly outs by the team in the game |
| GroundOuts | decimal (32) | NULL | Yes | Total ground outs by the team in the game |
| LineOuts | decimal (32) | NULL | Yes | Total lineouts by the team in the game |
| PopOuts | decimal (32) | NULL | Yes | Total pop outs by the team in the game |
| IntentionalWalks | decimal (32) | NULL | Yes | Total intentional walks by the team in the game |
| ReachedOnError | decimal (32) | NULL | Yes | Total times the team reached base on an error in the game |
| BallsInPlay | decimal (32) | NULL | Yes | Total balls in play by the team in the game |
| BattingAverageOnBallsInPlay | decimal (32) | NULL | Yes | Total batting average on balls in play (BABIP) by the team in the game |
| WeightedOnBasePercentage | decimal (32) | NULL | Yes | Total weighted on base percentage (wOBA) by the team in the game |
| PitchingSingles | decimal (32) | NULL | Yes | Total singles allowed while pitching by the team in the game |
| PitchingDoubles | decimal (32) | NULL | Yes | Total doubles allowed while pitching by the team in the game |
| PitchingTriples | decimal (32) | NULL | Yes | Total triples allowed while pitching by the team in the game |
| PitchingGrandSlams | decimal (32) | NULL | Yes | Total grand slams allowed while pitching by the team in the game |
| PitchingHitByPitch | decimal (32) | NULL | Yes | Total batters hit by pitch while pitching by the team in the game |
| PitchingSacrifices | decimal (32) | NULL | Yes | Total sacrifices while pitching by the team in the game |
| PitchingSacrificeFlies | decimal (32) | NULL | Yes | Total sacrifice flies while pitching by the team in the game |
| PitchingGroundIntoDoublePlay | decimal (32) | NULL | Yes | Total grounded into double plays while pitching by the team in the game |
| PitchingCompleteGames | decimal (32) | NULL | Yes | Total complete games while pitching by the team in the game. Note: there can only be maximum one complete game pitched per game |
| PitchingShutOuts | decimal (32) | NULL | Yes | Total shutouts while pitching by the team in the game. Note: a team can have a maximum of one shutout in a single game |
| PitchingNoHitters | decimal (32) | NULL | Yes | Total no hitters while pitching by the team in the game. Note: there can only be maximum one no hitter pitched per game |
| PitchingPerfectGames | decimal (32) | NULL | Yes | Total perfect games while pitching by the team in the game. Note: there can be a maximum of one perfect game in a single game |
| PitchingPlateAppearances | decimal (32) | NULL | Yes | Total plate appearances while pitching by the team in the game |
| PitchingTotalBases | decimal (32) | NULL | Yes | Total bases allowed while pitching by the team in the game |
| PitchingFlyOuts | decimal (32) | NULL | Yes | Total fly outs while pitching by the team in the game |
| PitchingGroundOuts | decimal (32) | NULL | Yes | Total ground outs while pitching by the team in the game |
| PitchingLineOuts | decimal (32) | NULL | Yes | Total line outs while pitching by the team in the game |
| PitchingPopOuts | decimal (32) | NULL | Yes | Total pop outs while pitching by the team in the game |
| PitchingIntentionalWalks | decimal (32) | NULL | Yes | Total intentional walks while pitching by the team in the game |
| PitchingReachedOnError | decimal (32) | NULL | Yes | Total times reached on error occurred while pitching by the team in the game |
| PitchingCatchersInterference | decimal (32) | NULL | Yes | Total catchers interference while pitching by the team in the game |
| PitchingBallsInPlay | decimal (32) | NULL | Yes | Total balls in play while pitching by the team in the game |
| PitchingOnBasePercentage | decimal (32) | NULL | Yes | Total on base percentage (OBP) while pitching by the team in the game |
| PitchingSluggingPercentage | decimal (32) | NULL | Yes | Total slugging percentage (SLG) while pitching by the team in the game |
| PitchingOnBasePlusSlugging | decimal (32) | NULL | Yes | Total on base plus slugging (OPS) while pitching by the team in the game |
| PitchingStrikeoutsPerNineInnings | decimal (32) | NULL | Yes | Total strikeouts per nine innings (K/9) while pitching by the team in the game |
| PitchingWalksPerNineInnings | decimal (32) | NULL | Yes | Total walks per nine innings (BB/9) while pitching by the team in the game |
| PitchingBattingAverageOnBallsInPlay | decimal (32) | NULL | Yes | Total batting average on balls in play (BABIP) while pitching by the team in the game |
| PitchingWeightedOnBasePercentage | decimal (32) | NULL | Yes | Total weighted on base percentage (wOBA) while pitching by the team in the game |
| DoublePlays | decimal (32) | NULL | Yes | Total double plays by the team in the game Note: includes all types of double plays. Ex: ground into double play, fly into double play, popped out into double play, etc. |
| PitchingDoublePlays | decimal (32) | NULL | Yes | Total double plays while pitching by the team in the game |
| BattingOrderConfirmed | boolean | NULL | Yes | Whether the batting order is confirmed (true/false) |
| IsolatedPower | decimal (32) | NULL | Yes | Total isolated power (ISO) by the team in the game |
| FieldingIndependentPitching | decimal (32) | NULL | Yes | Total fielding independent pitching (FIP) by the team in the game |
| PitchingQualityStarts | decimal (32) | NULL | Yes | Total quality starts (QS) pitched by the team in the game. Note: a team can have a maximum of one quality start in a single game |
| PitchingInningStarted | integer (32) | NULL | Yes | This field is expected to be NULL |
| LeftOnBase from 2017 | decimal (32) | NULL | Yes | Total runners left on base by the team in the game |
| PitchingHolds from 2017 | decimal (32) | NULL | Yes | Total holds pitched by the team in the game |
| PitchingBlownSaves from 2017 | decimal (32) | NULL | Yes | Total blown saves by the team in the game |
| SubstituteBattingOrder from 2017 | integer (32) | NULL | Yes | The position in the batting order where this player was substituted into the game (does not include players in the starting lineup) |
| SubstituteBattingOrderSequence from 2017 | integer (32) | NULL | Yes | The sequence in which this player was substituted into the game, within the particular batting order |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Field is expected to be Null |
| FantasyPointsBatting | decimal (32) | NULL | No | Total batting fantasy points by the team in the game |
| FantasyPointsPitching | decimal (32) | NULL | No | Total pitching fantasy points by the team in the game |
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 team's unique TeamID as assigned by SportsDataIO |
| 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 opposing team related to the scop of the search |
| Opponent from 2020 | string (50) | NULL | No | The name [Key] of the team's opponent related to the scop of the search |
| Wins from 2020 | integer (32) | NOT NULL | Yes | The total number of wins by the team relating to the scope |
| Losses from 2020 | integer (32) | NOT NULL | Yes | Team losses relating to the scope |
| Ties from 2020 | integer (32) | NOT NULL | Yes | Ties by a team relating to the scope of the search |
| WinsAgainstTheSpread from 2020 | integer (32) | NULL | Yes | Total number of wins against the run line relating to the scope |
| LossesAgainstTheSpread from 2020 | integer (32) | NULL | Yes | Team losses against the run line relating to the scope |
| PushesAgainstTheSpread from 2020 | integer (32) | NULL | Yes | The amount of times a given team's final score of their game has pushed the run line (a push is neither a win nor a loss) |
| Overs from 2020 | integer (32) | NULL | Yes | Amount of times the total score goes over the OverUnder |
| Unders from 2020 | integer (32) | NULL | Yes | Amount of times the total score goes under the OverUnder |
| OverUnderPushes from 2020 | integer (32) | NULL | Yes | The amount of times a given team's final score of their game has pushed the point total (a push is neither a win nor a loss) |
| AverageScore from 2020 | decimal (32) | NULL | Yes | Average score of team |
| AverageOpponentScore from 2020 | decimal (32) | NULL | Yes | Average score of the opposing team |
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 team's unique TeamID as assigned by SportsDataIO |
| 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) |
| Season | integer (32) | NULL | No | The MLB season for which these totals apply |
| Name | string (50) | NULL | No | Team's full name (city and mascot) |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| 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 date and time of the late update made to this record (in US Eastern Time) |
| Games | integer (32) | NULL | No | The number of games played by the team in the season. Note: for game feeds this will always = 1 |
| FantasyPoints | decimal (32) | NULL | Yes | The field is expected to be 0 |
| AtBats | decimal (32) | NULL | Yes | Total at bats by the team in the season |
| Runs | decimal (32) | NULL | Yes | Total runs scored by the team in the season |
| Hits | decimal (32) | NULL | Yes | Total hits by the team in the season |
| Singles | decimal (32) | NULL | Yes | Total singles by the team in the season |
| Doubles | decimal (32) | NULL | Yes | Total doubles by the team in the season |
| Triples | decimal (32) | NULL | Yes | Total triples by the team in the season |
| HomeRuns | decimal (32) | NULL | Yes | Total home runs by the team in the season |
| RunsBattedIn | decimal (32) | NULL | Yes | Total runs batted in by the team in the season |
| BattingAverage | decimal (32) | NULL | Yes | Total batting average by the team in the season |
| Outs | decimal (32) | NULL | Yes | Total batting outs by the team in the season |
| Strikeouts | decimal (32) | NULL | Yes | Total strikeouts while batting by the team in the season |
| Walks | decimal (32) | NULL | Yes | Total walks recorded by the team during the season |
| HitByPitch | decimal (32) | NULL | Yes | Total times the team was hit by a pitch in the season |
| Sacrifices | decimal (32) | NULL | Yes | Total sacrifices by the team in the season |
| SacrificeFlies | decimal (32) | NULL | Yes | Total sacrifice flies by the team in the season |
| GroundIntoDoublePlay | decimal (32) | NULL | Yes | Total times the team grounded into double play (GIDP) in the season |
| StolenBases | decimal (32) | NULL | Yes | Total stolen bases by the team in the season |
| CaughtStealing | decimal (32) | NULL | Yes | Total times the team was caught stealing in the season |
| PitchesSeen | decimal (32) | NULL | Yes | Total pitches seen by the team in the season |
| OnBasePercentage | decimal (32) | NULL | Yes | Total on base percentage (OBP) by the team in the season |
| SluggingPercentage | decimal (32) | NULL | Yes | Total slugging percentage (SLG) of the team in the season |
| OnBasePlusSlugging | decimal (32) | NULL | Yes | Total on base plus slugging percentage (OPS) by the team in the season |
| Errors | decimal (32) | NULL | Yes | Total errors committed by the team in the season |
| Wins | decimal (32) | NULL | Yes | Total wins recorded by the team in the season |
| Losses | decimal (32) | NULL | Yes | Total losses by the team in the season. Note: this can be either 0 or 1 for single game (non-projected) fields |
| Saves | decimal (32) | NULL | Yes | Total saves by the team in the season |
| InningsPitchedDecimal | decimal (32) | NULL | Yes | Decimal representation of total innings pitched by the team in the season. Note: 1 out in an inning is 1/3 of an inning or .33. 2 outs would be 2/3 or .66. Ex: 5 full innings and 1 out would be 5.33 |
| TotalOutsPitched | decimal (32) | NULL | Yes | Total outs pitched by the team in the season |
| InningsPitchedFull | decimal (32) | NULL | Yes | Total projected full innings pitched by the team in the season. Note: if the team has pitched 5.33 innings, this will be 5 as the 6th inning was not full yet |
| InningsPitchedOuts | decimal (32) | NULL | Yes | Outs pitched beyond InningsPitchedFull by the team in the season (possible values: 0; 1; 2) |
| EarnedRunAverage | decimal (32) | NULL | Yes | Total earned run average by the team in the season |
| PitchingHits | decimal (32) | NULL | Yes | Total hits allowed while pitching by the team in the season |
| PitchingRuns | decimal (32) | NULL | Yes | Total runs allowed while pitching by the team in the season |
| PitchingEarnedRuns | decimal (32) | NULL | Yes | Total earned runs allowed while pitching by the team in the season |
| PitchingWalks | decimal (32) | NULL | Yes | Total walks allowed while pitching by the team in the season |
| PitchingStrikeouts | decimal (32) | NULL | Yes | Total strikeouts while pitching by the team in the season |
| PitchingHomeRuns | decimal (32) | NULL | Yes | Total home runs allowed while pitching by the team in the season |
| PitchesThrown | decimal (32) | NULL | Yes | Total pitches thrown by the team in the season |
| PitchesThrownStrikes | decimal (32) | NULL | Yes | Total pitches thrown for strikes by the team in the season |
| WalksHitsPerInningsPitched | decimal (32) | NULL | Yes | Total walks and hits allowed by the team divided by innings pitched (WHIP) in the season |
| PitchingBattingAverageAgainst | decimal (32) | NULL | Yes | Total batting average against (BAA) while pitching by the team in the season |
| GrandSlams | decimal (32) | NULL | Yes | Total grand slams by the team in the season |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | The field is expected to be 0 |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | The field is expected to be 0 |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | The field is expected to be 0 |
| PlateAppearances | decimal (32) | NULL | Yes | Total plate appearances by the team in the season |
| TotalBases | decimal (32) | NULL | Yes | The total number of bases recorded by the team in the season |
| FlyOuts | decimal (32) | NULL | Yes | Total fly outs by the team in the season |
| GroundOuts | decimal (32) | NULL | Yes | Total ground outs by the team in the season |
| LineOuts | decimal (32) | NULL | Yes | Total lineouts by the team in the season |
| PopOuts | decimal (32) | NULL | Yes | Total pop outs by the team in the season |
| IntentionalWalks | decimal (32) | NULL | Yes | Total intentional walks by the team in the season |
| ReachedOnError | decimal (32) | NULL | Yes | Total times the team reached base on an error in the season |
| BallsInPlay | decimal (32) | NULL | Yes | Total balls in play by the team in the season |
| BattingAverageOnBallsInPlay | decimal (32) | NULL | Yes | Total batting average on balls in play (BABIP) by the team in the season |
| WeightedOnBasePercentage | decimal (32) | NULL | Yes | Total weighted on base percentage (wOBA) by the team in the season |
| PitchingSingles | decimal (32) | NULL | Yes | Total singles allowed while pitching by the team in the season |
| PitchingDoubles | decimal (32) | NULL | Yes | Total doubles allowed while pitching by the team in the season |
| PitchingTriples | decimal (32) | NULL | Yes | Total triples allowed while pitching by the team in the season |
| PitchingGrandSlams | decimal (32) | NULL | Yes | Total grand slams allowed while pitching by the team in the season |
| PitchingHitByPitch | decimal (32) | NULL | Yes | Total batters hit by pitch while pitching by the team in the season |
| PitchingSacrifices | decimal (32) | NULL | Yes | Total sacrifices while pitching by the team in the season |
| PitchingSacrificeFlies | decimal (32) | NULL | Yes | Total sacrifice flies while pitching by the team in the season |
| PitchingGroundIntoDoublePlay | decimal (32) | NULL | Yes | Total grounded into double plays while pitching by the team in the season |
| PitchingCompleteGames | decimal (32) | NULL | Yes | Total complete games while pitching by the team in the season |
| PitchingShutOuts | decimal (32) | NULL | Yes | Total shutouts while pitching by the team in the season |
| PitchingNoHitters | decimal (32) | NULL | Yes | Total no hitters while pitching by the team in the season |
| PitchingPerfectGames | decimal (32) | NULL | Yes | Total perfect games while pitching by the team in the season |
| PitchingPlateAppearances | decimal (32) | NULL | Yes | Total plate appearances while pitching by the team in the season |
| PitchingTotalBases | decimal (32) | NULL | Yes | Total bases allowed while pitching by the team in the season |
| PitchingFlyOuts | decimal (32) | NULL | Yes | Total fly outs while pitching by the team in the season |
| PitchingGroundOuts | decimal (32) | NULL | Yes | Total ground outs while pitching by the team in the season |
| PitchingLineOuts | decimal (32) | NULL | Yes | Total line outs while pitching by the team in the season |
| PitchingPopOuts | decimal (32) | NULL | Yes | Total pop outs while pitching by the team in the season |
| PitchingIntentionalWalks | decimal (32) | NULL | Yes | Total intentional walks while pitching by the team in the season |
| PitchingReachedOnError | decimal (32) | NULL | Yes | Total times reached on error occurred while pitching by the team in the season |
| PitchingCatchersInterference | decimal (32) | NULL | Yes | Total catchers interference while pitching by the team in the season |
| PitchingBallsInPlay | decimal (32) | NULL | Yes | Total balls in play while pitching by the team in the season |
| PitchingOnBasePercentage | decimal (32) | NULL | Yes | Total on base percentage (OBP) while pitching by the team in the season |
| PitchingSluggingPercentage | decimal (32) | NULL | Yes | Total slugging percentage (SLG) while pitching by the team in the season |
| PitchingOnBasePlusSlugging | decimal (32) | NULL | Yes | Total on base plus slugging (OPS) while pitching by the team in the season |
| PitchingStrikeoutsPerNineInnings | decimal (32) | NULL | Yes | Total strikeouts per nine innings (K/9) while pitching by the team in the season |
| PitchingWalksPerNineInnings | decimal (32) | NULL | Yes | Total walks per nine innings (BB/9) while pitching by the team in the season |
| PitchingBattingAverageOnBallsInPlay | decimal (32) | NULL | Yes | Total batting average on balls in play (BABIP) while pitching by the team in the season |
| PitchingWeightedOnBasePercentage | decimal (32) | NULL | Yes | Total weighted on base percentage (wOBA) while pitching by the team in the season |
| DoublePlays | decimal (32) | NULL | Yes | Total double plays by the team in the season. Note: includes all types of double plays. Ex: ground into double play, fly into double play, popped out into double play, etc. |
| PitchingDoublePlays | decimal (32) | NULL | Yes | Total double plays while pitching by the team in the season |
| BattingOrderConfirmed | boolean | NULL | Yes | Whether the batting order is confirmed (true/false) |
| IsolatedPower | decimal (32) | NULL | Yes | Total isolated power (ISO) by the team in the season |
| FieldingIndependentPitching | decimal (32) | NULL | Yes | Total fielding independent pitching (FIP) by the team in the season |
| PitchingQualityStarts | decimal (32) | NULL | Yes | Total quality starts (QS) pitched by the team in the season |
| PitchingInningStarted | integer (32) | NULL | Yes | This field is expected to be NULL |
| LeftOnBase from 2017 | decimal (32) | NULL | Yes | Total left on base percentage by the team in the season |
| PitchingHolds from 2017 | decimal (32) | NULL | Yes | Total holds pitched by the team in the season |
| PitchingBlownSaves from 2017 | decimal (32) | NULL | Yes | Total blown saves by the team in the season |
| SubstituteBattingOrder from 2017 | integer (32) | NULL | Yes | The position in the batting order where this player was substituted into the game (does not include players in the starting lineup) |
| SubstituteBattingOrderSequence from 2017 | integer (32) | NULL | Yes | The sequence in which this player was substituted into the game; within the particular batting order |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | This field is expected to be Null |
| FantasyPointsBatting | decimal (32) | NULL | No | Total batting fantasy points by the team in the season |
| FantasyPointsPitching | decimal (32) | NULL | No | Total pitching fantasy points by the team in the season |
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 team's unique TeamID as assigned by SportsDataIO |
| 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 MLB career. |
| Name | string (32) | NOT NULL | No | Player's full name |
| FormerTeamID | integer (32) | NULL | No | TeamID of player's former team |
| FormerTeam | string (32) | NULL | No | Player's former team in abbreviated format [Key] (e.g. SD; PHI; LAD; ATL etc.) |
| TeamID | integer (32) | NULL | No | The team's unique TeamID as assigned by SportsDataIO |
| Team | string (32) | NULL | No | The abbreviation [Key] of the team |
| Type | string (50) | NULL | No | Type of Transaction. Released, Waived, Signed, Promoted, Elevated, Demoted, and Traded. |
| Date | datetime (32) | NULL | No | The date that this transaction took place |
| Note | string (100) | NULL | No | A summary of the transaction (e.g. "Harris has signed with the Diamondbacks.") |
| Created | datetime (32) | NULL | No | The date and time this transaction was created in US Eastern Time |
| Updated | datetime (32) | NULL | No | The date and time of the last update made to this transaction (in US Eastern Time) |