Developer Portal
{{url = dataItem.Url ? dataItem.Url : (dataItem.items.length ? dataItem.items[0].Url : null);"" }}
{{ dataItem.Text }}
{{ dataItem.Text }}
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.
Filter by a Subfeed...
BettingEntityMetadata
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
RecordId
from 2021 |
integer | 32 | No | No | Yes | 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 | No | No | Yes | A text value for the record (e.g. Moneyline, Player Prop, 3rd Quarter) |
BettingEntityMetadataCollection
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
BettingBetTypes
from 2021 |
BettingEntityMetadata[] | Yes | No | Yes | A list of the possible BettingBetTypes (e.g. Moneyline, Spread) | |
BettingMarketTypes
from 2021 |
BettingEntityMetadata[] | Yes | No | Yes | A list of the possible BettingMartketTypes (e.g. Game Line, Team Prop) | |
BettingPeriodTypes
from 2021 |
BettingEntityMetadata[] | Yes | No | Yes | A list of the possible BettingPeriodTypes (e.g. Full Game, Regulation Time, 1st Half) | |
BettingEventTypes
from 2021 |
BettingEntityMetadata[] | Yes | No | Yes | A list of the possible BettingEventTypes (e.g. Game, Future) | |
BettingOutcomeTypes
from 2021 |
BettingEntityMetadata[] | Yes | No | Yes | A list of the possible BettingOutcomeTypes (e.g. Home, Over) | |
ResultedMarketMetaData
from 2021 |
BettingResultingMetadata[] | 32 | Yes | No | Yes | A list of the combinations of MarketType, BetType, & PeriodType which we willl provide automated resulting for |
BettingResultTypes
from 2021 |
BettingEntityMetadata[] | Yes | No | Yes | A list of possible BettingResultTypes (eg Win, Loss, Push, NotResulted) |
BettingEvent
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
BettingEventID
from 2020 |
int | 32 | No | No | Yes | The unique identifier for this betting event |
Name
from 2020 |
string | 32 | Yes | No | Yes | The name of this betting event |
Season
from 2020 |
int | 32 | Yes | No | Yes | The season of this betting event |
BettingEventTypeID
from 2020 |
int | 32 | No | No | Yes | The identifier of the bet type of this betting event |
BettingEventType
from 2020 |
string | 32 | No | No | Yes | The name of the bet type of this betting event |
StartDate
from 2020 |
datetime | Yes | No | Yes | The furthest forward time any book has a market set to close for this betting event | |
Created
from 2020 |
datetime | Yes | No | Yes | The created date of this betting event | |
Updated
from 2020 |
datetime | Yes | No | Yes | The last updated date of this betting event | |
GameID
from 2020 |
int | 32 | Yes | No | Yes | The GameId of the game tied to this event |
GlobalGameID
from 2020 |
int | 32 | Yes | No | No | The GlobalGameId of the game tied to this event |
GameStatus
from 2020 |
string | 32 | Yes | Yes | Yes | The status of the game tied to this event |
Quarter
from 2020 |
string | 32 | Yes | Yes | Yes | The quarter of the game tied to this event |
AwayTeam
from 2020 |
string | 32 | Yes | No | Yes | The Away Team Key of the game tied to this event |
HomeTeam
from 2020 |
string | 32 | Yes | No | Yes | The Home team key of the game tied to this event |
AwayTeamID
from 2020 |
int | 32 | Yes | No | Yes | The Away team ID of the game tied to this event |
HomeTeamID
from 2020 |
int | 32 | Yes | No | Yes | The Home team ID of the game tied to this event |
GlobalAwayTeamID
from 2020 |
int | 32 | Yes | No | No | The global away team id of the game tied to this event |
GlobalHomeTeamID
from 2020 |
int | 32 | Yes | No | No | The global home team id of the game tied to this event |
AwayTeamScore
from 2020 |
int | 32 | Yes | Yes | Yes | The away team score of the game tied to this event (post-game) |
HomeTeamScore
from 2020 |
int | 32 | Yes | Yes | Yes | The home team score of the game tied to this event (post-game) |
TotalScore
from 2020 |
int | 32 | Yes | Yes | Yes | The combined scores of the home and away team of the game tied to this event (post-game) |
AwayRotationNumber
from 2020 |
int | 32 | Yes | No | Yes | The away team rotation number of the game tied to this event |
HomeRotationNumber
from 2020 |
int | 32 | Yes | No | Yes | The home team rotation number of the game tied to this event |
BettingMarkets
from 2020 |
BettingMarket[] | 32 | Yes | No | Yes | The list of betting markets for this event |
GameStartTime
from 2020 |
datetime | 32 | Yes | No | Yes | The date and time the connected game starts, where applicable |
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 | CSV | Description |
---|---|---|---|---|---|---|
BettingMarketID
from 2020 |
int | 32 | No | No | Yes | The unique identifier of this betting market |
BettingEventID
from 2020 |
int | 32 | No | No | Yes | The unique identifier of the event this betting market exists for |
BettingMarketTypeID
from 2020 |
int | 32 | Yes | Yes | Yes | The BettingMarketTypeID of this market |
BettingMarketType
from 2020 |
string | 32 | Yes | Yes | Yes | The BettingMarketType of this market |
BettingBetTypeID
from 2020 |
int | 32 | Yes | Yes | Yes | The BettingBetTypeID of this market |
BettingBetType
from 2020 |
string | 32 | Yes | Yes | Yes | The BettingBetType of this market |
BettingPeriodTypeID
from 2020 |
int | 32 | Yes | Yes | Yes | The BettingPeriodTypeID of this market |
BettingPeriodType
from 2020 |
string | 32 | Yes | Yes | Yes | The BettingPeriodType of this market |
Name
from 2020 |
string | 32 | Yes | No | Yes | The generic name of this market |
TeamID
from 2020 |
int | 32 | Yes | Yes | Yes | The team id of the team tied to this market (if applicable) |
TeamKey
from 2020 |
string | 32 | Yes | Yes | Yes | The team key of the team tied to this market (if applicable) |
PlayerID
from 2020 |
int | 32 | Yes | Yes | Yes | The player id of the player tied to this market (if applicable) |
PlayerName
from 2020 |
string | 32 | Yes | Yes | Yes | The name of the player tied to this market (if applicable) |
Created
from 2020 |
datetime | 32 | Yes | No | Yes | The created date of this market |
Updated
from 2020 |
datetime | 32 | Yes | No | Yes | The last updated date of this market |
AvailableSportsbooks
from 2020 |
Sportsbook[] | 32 | Yes | No | Yes | The sportsbooks that have had odds in this market |
AnyBetsAvailable
from 2020 |
bool | 32 | Yes | No | Yes | Shows if any bets are currently available for betting in this market |
BettingOutcomes
from 2020 |
BettingOutcome[] | 32 | Yes | No | Yes | The list of betting outcomes from each sportsbook in this market |
ConsensusOutcomes
from 2020 |
ConsensusOutcome[] | 32 | Yes | No | Yes | The single set of consesnus outcomes of this market |
IsArchived | bool | No | No | Yes | Indicates if the BettingOutcomes have been moved to the archives | |
ArchiveLocation | string | No | No | Yes | f IsArchived is true, the location (URL) from where to retrieve the archived BettingOutcomes (API key and sportsbook grouping required); otherwise an empty string |
BettingMarketResult
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
BettingMarketID
from 2021 |
integer | 32 | No | No | Yes | The unique identifier of this market |
BettingMarketTypeID
from 2021 |
integer | 32 | No | No | Yes | The BettingMarketTypeID of this market |
BettingMarketType
from 2021 |
string | 100 | No | No | Yes | The BettingMarketType of this market |
BettingBetTypeID
from 2021 |
integer | 32 | No | No | Yes | The BettingBetTypeID of this market |
BettingBetType
from 2021 |
string | 100 | No | No | Yes | The BettingBetType of this market |
BettingPeriodTypeID
from 2021 |
integer | 32 | No | No | Yes | The BettingPeriodTypeID of this market |
BettingPeriodType
from 2021 |
string | 100 | No | No | Yes | The BettingPeriodType of this market |
Name
from 2021 |
string | 100 | Yes | No | Yes | The generic name of this market |
TeamID
from 2021 |
integer | 32 | Yes | No | Yes | The team id of the team tied to this market (if applicable) |
TeamKey
from 2021 |
string | 10 | Yes | No | Yes | The team key of the team tied to this market (if applicable) |
PlayerID
from 2021 |
integer | 32 | Yes | No | Yes | The player id of the player tied to this market (if applicable) |
PlayerName
from 2021 |
string | 100 | Yes | No | Yes | The name of the player tied to this market (if applicable) |
BettingOutcomeResults
from 2021 |
BettingOutcomeResult[] | Yes | No | Yes | The list of outcomes under this market with results | |
IsMarketResultingSupported | bool | 32 | No | No | Yes | Indicates whether resulting is supported for this kind of BettingMarket |
BettingMarketSplit
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
BettingMarketID | integer | 32 | No | No | Yes | The unique id of the betting market |
BettingEventID | integer | 32 | No | No | Yes | The unique id of the associated betting event |
BettingMarketTypeID | integer | 32 | No | No | Yes | The market type id |
BettingMarketType | string | 100 | No | No | Yes | The string description of the market type |
BettingBetTypeID | integer | 32 | No | No | Yes | The bet type id |
BettingBetType | string | 100 | No | No | Yes | The string description of the bet type |
BettingPeriodTypeID | integer | 32 | No | No | Yes | The period type id |
BettingPeriodType | string | 100 | No | No | Yes | The string description of the period type |
TeamID | integer | 32 | Yes | No | Yes | The id of the team associated (where applicable) |
TeamKey | string | 32 | Yes | No | Yes | The string key of the team associated (where applicable) |
PlayerID | integer | 32 | Yes | No | Yes | The id of the player associated (where applicable) |
PlayerName | string | 100 | Yes | No | Yes | The full name of the player associated (where applicable) |
BettingSplits | BettingSplit[] | 32 | No | No | Yes | The list of Splits for the market |
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 | CSV | Description |
---|---|---|---|---|---|---|
BettingOutcomeID
from 2020 |
int | 32 | Yes | No | Yes | The unique identifier of this outcome |
BettingMarketID
from 2020 |
int | 32 | Yes | No | Yes | The unique identifier of the market this betting outcome exists for |
SportsBook
from 2020 |
Sportsbook | 32 | Yes | No | Yes | The sportsbook offering this outcome for betting |
BettingOutcomeTypeID
from 2020 |
int | 32 | Yes | Yes | Yes | The BettingOutcomeTypeID of this outcome |
BettingOutcomeType
from 2020 |
string | 32 | Yes | Yes | Yes | The BettingOutcomeType of this outcome |
PayoutAmerican
from 2020 |
int | 32 | Yes | Yes | Yes | The american odds payout |
PayoutDecimal
from 2020 |
decimal | 32 | Yes | Yes | Yes | The decimal odds payout |
Value
from 2020 |
decimal | 32 | Yes | Yes | Yes | The number associated with the outcome (spread/total/etc) |
Participant
from 2020 |
string | 32 | Yes | No | Yes | 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 | Yes | No | Yes | Is this outcome available for betting as of last update |
IsAlternate
from 2020 |
bool | 32 | Yes | No | Yes | Is this an alternate value or the core value |
Created
from 2020 |
datetime | 32 | Yes | No | Yes | The created date of the outcome |
Updated
from 2020 |
datetime | 32 | Yes | No | Yes | The last updated date of the outcome |
Unlisted
from 2020 |
datetime | 32 | Yes | No | Yes | The datetime the outcome was unlisted (no longer available for bets) |
TeamID
from 2020 |
int | 32 | Yes | Yes | Yes | The TeamID of the team assocated with this outcome (where applicable) |
PlayerID
from 2020 |
int | 32 | Yes | Yes | Yes | The PlayerID of the player assocated with this outcome (where applicable) |
GlobalTeamID
from 2020 |
int | 32 | Yes | Yes | No | The GlobalTeamID of the team assocated with this outcome (where applicable) |
SportsbookUrl
from 2020 |
string | 500 | Yes | Yes | Yes | The Url for Sportsbook event |
IsInPlay
from 2022 |
bool | 1 | Yes | No | Yes | Was this outcome created after the start time of the game (only applies when the betting event is of type game) |
SportsbookMarketID | string | 100 | Yes | Yes | No | The market ID on the given sportsbook for deeplinking (when available) |
SportsbookOutcomeID | string | 100 | Yes | Yes | No | 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 | CSV | Description |
---|---|---|---|---|---|---|
BettingOutcomeID
from 2021 |
integer | 32 | No | No | Yes | The unique identifier of the outcome |
BettingResultTypeID
from 2021 |
integer | 32 | Yes | Yes | Yes | The BettingResultType of this outcome |
BettingResultType
from 2021 |
string | 100 | Yes | Yes | Yes | The string identifier of the BettingResultType of this outcome (e.g. Won, Lost, Push, Not Resulted, Incomplete) |
BettingOutcomeTypeID
from 2020 |
int | 32 | Yes | No | Yes | The BettingOutcomeTypeID of this outcome |
BettingOutcomeType
from 2020 |
string | 32 | Yes | No | Yes | The BettingOutcomeType of this outcome |
BetValue
from 2021 |
decimal | 32 | Yes | Yes | Yes | The value that was bet in this outcome (if applicable) |
ActualValue
from 2021 |
decimal | 32 | Yes | Yes | Yes | The value that actually occurred in game (if applicable) |
BettingResultingMetadata
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
BettingMarketTypeId
from 2021 |
integer | 32 | No | No | Yes | The BettingMarketTypeID of this type of market which we can result |
BettingBetTypeId
from 2021 |
integer | 32 | No | No | Yes | The BettingBetTypeID of this type of market which we can result |
BettingPeriodTypeId
from 2021 |
integer | 32 | No | No | Yes | The BettingPeriodTypeID of this type of market which we can result |
BettingSplit
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
BettingMarketSplitID | integer | 32 | No | No | Yes | The unique id of this specific instance of the split |
BettingMarketID | integer | 32 | No | No | Yes | The id of the market associated |
BettingOutcomeTypeID | integer | 32 | Yes | No | Yes | The outcome type id this split is associated with |
BettingOutcomeType | string | 32 | Yes | No | Yes | The string description of this outcome type |
BetPercentage | integer | 32 | Yes | Yes | Yes | The percentage of the bets on this market taken by this type of bet |
MoneyPercentage | integer | 32 | Yes | Yes | Yes | The percentage of the money placed in wagers on this market taken by this type of bet |
Created | datetime | 32 | No | No | Yes | The timestamp this set of values was first seen |
LastSeen | datetime | 32 | No | No | Yes | The timestamp this set of values was last seen |
BoxScore
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
Game | Game | Yes | No | Yes | The details of the game associated with this box score | |
Innings | Inning[] | Yes | No | Yes | The details of the innings associated with this box score | |
TeamGames | TeamGame[] | Yes | No | Yes | The team game stats associated with this box score | |
PlayerGames | PlayerGame[] | Yes | No | Yes | 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 | CSV | Description |
---|---|---|---|---|---|---|
NumberOfSportsbooks
from 2020 |
int | 32 | No | Yes | Yes | The number of sportsbooks odds that went into creating this consensus outcome |
BettingOutcomeID
from 2020 |
int | 32 | Yes | No | Yes | The unique identifier of this outcome |
BettingMarketID
from 2020 |
int | 32 | Yes | No | Yes | The unique identifier of the market this betting outcome exists for |
SportsBook
from 2020 |
Sportsbook | 32 | Yes | No | Yes | The sportsbook offering this outcome for betting |
BettingOutcomeTypeID
from 2020 |
int | 32 | Yes | Yes | Yes | The BettingOutcomeTypeID of this outcome |
BettingOutcomeType
from 2020 |
string | 32 | Yes | Yes | Yes | The BettingOutcomeType of this outcome |
PayoutAmerican
from 2020 |
int | 32 | Yes | Yes | Yes | The american odds payout |
PayoutDecimal
from 2020 |
decimal | 32 | Yes | Yes | Yes | The decimal odds payout |
Value
from 2020 |
decimal | 32 | Yes | Yes | Yes | The number associated with the outcome (spread/total/etc) |
Participant
from 2020 |
string | 32 | Yes | No | Yes | 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 | Yes | No | Yes | Is this outcome available for betting as of last update |
IsAlternate
from 2020 |
bool | 32 | Yes | No | Yes | Is this an alternate value or the core value |
Created
from 2020 |
datetime | 32 | Yes | No | Yes | The created date of the outcome |
Updated
from 2020 |
datetime | 32 | Yes | No | Yes | The last updated date of the outcome |
Unlisted
from 2020 |
datetime | 32 | Yes | No | Yes | The datetime the outcome was unlisted (no longer available for bets) |
TeamID
from 2020 |
int | 32 | Yes | Yes | Yes | The TeamID of the team assocated with this outcome (where applicable) |
PlayerID
from 2020 |
int | 32 | Yes | Yes | Yes | The PlayerID of the player assocated with this outcome (where applicable) |
GlobalTeamID
from 2020 |
int | 32 | Yes | Yes | No | The GlobalTeamID of the team assocated with this outcome (where applicable) |
SportsbookUrl
from 2020 |
string | 500 | Yes | Yes | Yes | The Url for Sportsbook event |
IsInPlay
from 2022 |
bool | 1 | Yes | No | Yes | Was this outcome created after the start time of the game (only applies when the betting event is of type game) |
SportsbookMarketID | string | 100 | Yes | Yes | No | The market ID on the given sportsbook for deeplinking (when available) |
SportsbookOutcomeID | string | 100 | Yes | Yes | No | 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 | CSV | Description |
---|---|---|---|---|---|---|
DepthChartID
from 2021 |
integer | 32 | No | No | Yes | Unique ID of Depth Chard Record |
TeamID
from 2021 |
integer | 32 | No | No | Yes | Unique ID of Team |
PlayerID
from 2021 |
integer | 32 | Yes | No | Yes | Unique ID of Player |
Name
from 2021 |
string | 32 | Yes | No | Yes | Player Name |
PositionCategory
from 2021 |
string | 32 | Yes | No | Yes | Player Position Category (IF, OF, P, etc) |
Position
from 2021 |
string | 32 | Yes | No | Yes | Player Position |
DepthOrder
from 2021 |
integer | 32 | Yes | Yes | Yes | Depth Chart Order |
Updated
from 2021 |
datetime | 32 | Yes | No | Yes | Date and Time Last Updated |
DfsSlate
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
SlateID | integer | 32 | No | No | Yes | Unique ID of a Slate (assigned by SportsDataIO). |
Operator | string | 20 | Yes | No | Yes | The name of the operator who is running contests for this slate. Possible values: FanDuel, DraftKings, Yahoo, FantasyDraft, etc. |
OperatorSlateID | integer | 32 | Yes | No | Yes | Unique ID of a slate (assigned by the operator). |
OperatorName | string | 50 | Yes | No | Yes | The name of the slate (assigned by the operator). Possible values: Main, Express, Arcade, Late Night, etc. |
OperatorDay | date | Yes | No | Yes | The day (in EST/EDT) that the slate begins (assigned by the operator). | |
OperatorStartTime | datetime | Yes | No | Yes | The date/time (in EST/EDT) that the slate begins (assigned by the operator). | |
NumberOfGames | integer | 32 | Yes | No | Yes | The number of actual games that this slate covers. |
IsMultiDaySlate | boolean | Yes | No | Yes | Whether this slate uses games that take place on different days. | |
RemovedByOperator | boolean | Yes | No | Yes | Indicates whether this slate was removed/deleted by the operator. | |
OperatorGameType | string | 50 | Yes | No | Yes | The game type of the slate. Will often be null as most operators only have one game type. |
DfsSlateGames | DfsSlateGame[] | Yes | No | Yes | The games that are included in this slate | |
DfsSlatePlayers | DfsSlatePlayer[] | Yes | No | Yes | The players that are included in this slate | |
SlateRosterSlots | string[] | Yes | No | Yes | The positions that need to be filled for this particular slate | |
SalaryCap | integer | Yes | No | Yes | 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 | CSV | Description |
---|---|---|---|---|---|---|
SlateGameID | integer | 32 | No | No | Yes | Unique ID of a SlateGame (assigned by SportsDataIO). |
SlateID | integer | 32 | No | No | Yes | The SlateID that this SlateGame refers to. |
GameID | integer | 32 | Yes | No | Yes | The SportsDataIO GameID that this SlateGame refers to. This points to data in the respective sports' schedule/game/box score feeds. |
Game | Game | Yes | No | Yes | The details of the Game that this SlateGame refers to. | |
OperatorGameID | integer | 32 | Yes | No | Yes | Unique ID of a SlateGame (assigned by the operator). |
RemovedByOperator | boolean | Yes | Yes | 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 | CSV | Description |
---|---|---|---|---|---|---|
SlatePlayerID | integer | 32 | No | No | Yes | Unique ID of a SlatePlayer (assigned by SportsDataIO). |
SlateID | integer | 32 | No | No | Yes | The SlateID that this SlatePlayer refers to. |
SlateGameID | integer | 32 | Yes | No | Yes | The SlateGameID that this SlatePlayer refers to. |
PlayerID | integer | 32 | Yes | No | Yes | The SportsDataIO PlayerID that this SlatePlayer refers to. This points to data in the respective sports' player feeds. |
PlayerGameProjectionStatID | integer | 32 | Yes | No | Yes | The SportsDataIO StatID that this SlatePlayer refers to. This points to data in the respective sports' projected player game stats feeds. |
OperatorPlayerID | string | 25 | Yes | No | Yes | Unique ID of the Player (assigned by the operator). |
OperatorSlatePlayerID | string | 50 | Yes | No | Yes | Unique ID of the SlatePlayer (assigned by the operator). |
OperatorPlayerName | string | 50 | Yes | No | Yes | The player's name (assigned by the operator). |
OperatorPosition | string | 10 | Yes | No | Yes | The player's eligible positions for the contest (assigned by the operator). |
OperatorSalary | integer | 32 | Yes | No | Yes | The player's salary for the contest (assigned by the operator). |
OperatorRosterSlots | string[] | Yes | No | Yes | The player's eligible positions to be played in the contest (assigned by the operator). This would include UTIL, etc plays for those that are eligible. | |
RemovedByOperator | boolean | Yes | Yes | Yes | Indicates whether this player was removed/deleted by the operator. | |
Team | string | 10 | Yes | No | Yes | Indicates the team this player plays for |
TeamID | integer | 32 | Yes | No | Yes | Indicates the team id of the team the player plays for |
FantasyGame
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
GameID | integer | 32 | No | No | Yes | The unique ID of this game |
PlayerID | integer | 32 | No | No | Yes | Unique ID assigned to each player that stays with them throughout their career |
SeasonType | integer | 32 | Yes | No | Yes | The season type of the timeframe (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=All-Star) |
Season | integer | 32 | Yes | No | Yes | The MLB season of the game |
Day | date | Yes | No | Yes | The date of the game | |
DateTime | datetime | Yes | No | Yes | The date and time of the game | |
Team | string | 10 | Yes | No | Yes | The abbreviation of the Team |
Opponent | string | 10 | Yes | No | Yes | The name of the opponent |
HomeOrAway | string | 4 | Yes | No | Yes | Whether the team is home or away |
Jersey | integer | 32 | Yes | No | Yes | The player's jersey number. |
Name | string | 50 | Yes | No | Yes | Player's name |
Position | string | 10 | Yes | No | Yes | 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 | Yes | No | Yes | The category (P, C, 1B, OF, SS) of the players position |
Games | integer | 32 | Yes | No | Yes | The number of games played. |
Started | integer | 32 | Yes | No | Yes | Whether the player started |
FantasyPoints | decimal | 32 | Yes | No | Yes | Total fantasy points |
FantasyPointsBatting | decimal | 32 | Yes | No | Yes | Total batting fantasy points |
FantasyPointsPitching | decimal | 32 | Yes | No | Yes | Total pitching fantasy points |
IsGameOver | boolean | Yes | No | Yes | Whether the game is over (true/false) | |
FantasyPointsFanDuel | decimal | 32 | Yes | No | Yes | Total FanDuel fantasy points |
FantasyPointsYahoo | decimal | 32 | Yes | No | Yes | Total Yahoo fantasy points |
FantasyPointsDraftKings | decimal | 32 | Yes | No | Yes | Total DraftKings fantasy points |
FanDuelPosition | string | 10 | Yes | No | Yes | The player's eligible position in FanDuel's daily fantasy sports platform. |
DraftKingsPosition | string | 10 | Yes | No | Yes | The player's eligible position in DraftKings' daily fantasy sports platform. |
YahooPosition | string | 10 | Yes | No | Yes | The player's eligible position in Yahoo's daily fantasy sports platform. |
OpponentRank | integer | 32 | Yes | No | Yes | The ranking of the player's opponent with regards to fantasy points allowed. |
OppositionPositionRank | integer | 32 | Yes | No | Yes | The ranking of the player's opponent by position with regards to fantasy points allowed. |
GlobalGameID | integer | 32 | Yes | No | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
Updated | datetime | Yes | No | Yes | The timestamp of when the record was last updated (US Eastern Time). |
Game
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
GameID | integer | 32 | No | No | Yes | The unique ID of this game |
Season | integer | 32 | No | No | Yes | The MLB season of the game |
SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
Status | string | 20 | Yes | No | Yes | Indicates the game's status. Possible values include: Scheduled, InProgress, Final, Suspended, Delayed, Postponed, Canceled, Forfeit, NotNecessary |
Day | date | Yes | No | Yes | The date of the game | |
DateTime | datetime | Yes | No | Yes | The date and time of the game | |
AwayTeam | string | 10 | No | No | Yes | The abbreviation of the Away Team |
HomeTeam | string | 10 | No | No | Yes | The abbreviation of the Home Team |
AwayTeamID | integer | 32 | No | No | Yes | The unique ID of the away team |
HomeTeamID | integer | 32 | No | No | Yes | The unique ID of the home team |
RescheduledGameID | integer | 32 | Yes | No | Yes | The GameID of the game that was rescheduled from this game. This only pertains to postponed games that require rescheduling. |
StadiumID | integer | 32 | Yes | No | Yes | The unique ID of the stadium |
Channel | string | 50 | Yes | No | Yes | The television station broadcasting the game |
Inning | integer | 32 | Yes | No | Yes | 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 | Yes | No | Yes | The inning half that the game is currently in, or the inning half in which the game ended (possible values: T, B, NULL) |
AwayTeamRuns | integer | 32 | Yes | Yes | Yes | Number of runs the away team scored in this game |
HomeTeamRuns | integer | 32 | Yes | Yes | Yes | Number of runs the home team scored in this game |
AwayTeamHits | integer | 32 | Yes | Yes | Yes | Total away team hits in this game |
HomeTeamHits | integer | 32 | Yes | Yes | Yes | Total home team hits in this game |
AwayTeamErrors | integer | 32 | Yes | Yes | Yes | Total away team errors committed in this game |
HomeTeamErrors | integer | 32 | Yes | Yes | Yes | Total home team errors committed in this game |
WinningPitcherID | integer | 32 | Yes | No | Yes | The PlayerID of the winning pitcher |
LosingPitcherID | integer | 32 | Yes | No | Yes | The PlayerID of the losing pitcher |
SavingPitcherID | integer | 32 | Yes | No | Yes | The PlayerID of the saving pitcher |
Attendance | integer | 32 | Yes | No | Yes | Total number of people who attended the game |
AwayTeamProbablePitcherID | integer | 32 | Yes | No | Yes | The PlayerID of the away team's probable pitcher |
HomeTeamProbablePitcherID | integer | 32 | Yes | No | Yes | The PlayerID of the home team's probable pitcher |
Outs | integer | 32 | Yes | No | Yes | The number of outs recorded in the current inning |
Balls | integer | 32 | Yes | No | Yes | The number of balls thrown for the current at bat |
Strikes | integer | 32 | Yes | No | Yes | The number of strikes thrown for the current at bat |
CurrentPitcherID | integer | 32 | Yes | No | Yes | The PlayerID of the current pitcher |
CurrentHitterID | integer | 32 | Yes | No | Yes | The PlayerID of the current hitter |
AwayTeamStartingPitcherID | integer | 32 | Yes | No | Yes | The PlayerID of the away team's starting pitcher |
HomeTeamStartingPitcherID | integer | 32 | Yes | No | Yes | The PlayerID of the home team's starting pitcher |
CurrentPitchingTeamID | integer | 32 | Yes | No | Yes | The TeamID of the current pitcher's team |
CurrentHittingTeamID | integer | 32 | Yes | No | Yes | The TeamID of the current hitter's team |
PointSpread
from 2016 |
decimal | 32 | Yes | Yes | Yes | The oddsmaker Point Spread at game start from the perspective of the HomeTeam (negative numbers indicate the HomeTeam is favored, positive numbers indicate the AwayTeam is favored). This is updated once daily at 4:00 AM ET. |
OverUnder
from 2016 |
decimal | 32 | Yes | Yes | Yes | The oddsmaker Over/Under at game start. This is updated once daily at 4:00 AM ET. |
AwayTeamMoneyLine
from 2016 |
integer | 32 | Yes | Yes | Yes | Money line from the perspective of the away team. This is updated once daily at 4:00 AM ET. |
HomeTeamMoneyLine
from 2016 |
integer | 32 | Yes | Yes | Yes | Money line from the perspective of the home team. This is updated once daily at 4:00 AM ET. |
ForecastTempLow
from 2016 |
integer | 32 | Yes | Yes | Yes | The forecasted low temperature on game day at this venue (Fahrenheit). |
ForecastTempHigh
from 2016 |
integer | 32 | Yes | Yes | Yes | The forecasted high temperature on game day at this venue (Fahrenheit). |
ForecastDescription
from 2016 |
string | 50 | Yes | Yes | 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 | Yes | Yes | Yes | The forecasted wind chill on game day at this venue. |
ForecastWindSpeed
from 2016 |
integer | 32 | Yes | Yes | Yes | The forecasted wind speed on game day at this venue. |
ForecastWindDirection
from 2016 |
integer | 32 | Yes | Yes | 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 | Yes | Yes | 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 | Yes | Yes | Yes | Indicates if there is a runner on first | |
RunnerOnSecond | boolean | Yes | Yes | Yes | Indicates if there is a runner on second | |
RunnerOnThird | boolean | Yes | Yes | Yes | Indicates if there is a runner on third | |
AwayTeamStartingPitcher | string | 50 | Yes | Yes | Yes | Indicates the away team starting pitcher's name |
HomeTeamStartingPitcher | string | 50 | Yes | Yes | Yes | Indicates the home team starting pitcher's name |
CurrentPitcher | string | 50 | Yes | Yes | Yes | Indicates the current pitcher's name |
CurrentHitter | string | 50 | Yes | Yes | Yes | Indicates the current hitter's name |
WinningPitcher | string | 50 | Yes | Yes | Yes | Indicates the winning pitcher's name |
LosingPitcher | string | 50 | Yes | Yes | Yes | Indicates the losing pitcher's name |
SavingPitcher | string | 50 | Yes | Yes | Yes | Indicates the saving pitcher's name |
DueUpHitterID1 | integer | 32 | Yes | Yes | Yes | Indicates the hitter due up first |
DueUpHitterID2 | integer | 32 | Yes | Yes | Yes | Indicates the hitter due up second |
DueUpHitterID3 | integer | 32 | Yes | Yes | Yes | Indicates the hitter due up third |
GlobalGameID | integer | 32 | No | No | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
GlobalAwayTeamID | integer | 32 | No | No | No | A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues. |
GlobalHomeTeamID | integer | 32 | No | No | 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 | Yes | Yes | Yes | The money line payout odds when betting on the away team with the point spread. This is updated once daily at 4:00 AM ET. |
PointSpreadHomeTeamMoneyLine
from 2017 |
integer | 32 | Yes | Yes | Yes | The money line payout odds when betting on the home team with the point spread. This is updated once daily at 4:00 AM ET. |
LastPlay | string | 250 | Yes | Yes | 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 | No | No | Yes | Indicates whether the game is over and the final score has been verified and closed out. | |
Updated | datetime | Yes | No | Yes | The timestamp of when the record was last updated (US Eastern Time). | |
Innings | Inning[] | Yes | No | Yes | The details of the innings associated with this game | |
GameEndDateTime | datetime | Yes | No | Yes | The date and time that the game ended in US Eastern Time | |
HomeRotationNumber
from 2019 |
integer | 32 | Yes | Yes | Yes | Rotation number of home team for this game |
AwayRotationNumber
from 2019 |
integer | 32 | Yes | Yes | Yes | Rotation number of away team for this game |
NeutralVenue
from 2020 |
boolean | Yes | No | Yes | Indicates whether this game is played in a neutral venue | |
InningDescription | string | 50 | Yes | No | Yes | 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 | Yes | Yes | Yes | The payout when betting the Over of the Over/Under |
UnderPayout
from 2021 |
integer | 32 | Yes | Yes | Yes | The payout when betting the Under of the Over/Under |
SeriesInfo
from 2021 |
Series | 32 | Yes | No | Yes | Contains relevant series data for playoff series only - HomeTeamWins, AwayTeamWins, GameNumber, and MaxLength |
DateTimeUTC
from 2021 |
datetime | Yes | No | Yes | The date and time of the game in UTC. | |
HomeTeamOpener | boolean | Yes | No | Yes | Indicates whether the home team will utilize their bullpen instead of a dedicated starting pitcher | |
AwayTeamOpener | boolean | Yes | No | Yes | Indicated whether the away team will utilize their bullpen instead of a dedicated starting pitcher |
GameBettingSplit
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
GameID | integer | 32 | No | No | Yes | The unique id of the game record |
SeasonType | integer | 32 | No | No | Yes | The seasontype of the game |
Season | integer | 32 | No | No | Yes | The season of the game |
Day | datetime | 32 | Yes | No | Yes | The start time of the game |
AwayTeam | string | 32 | Yes | No | Yes | The away team key |
HomeTeam | string | 32 | Yes | No | Yes | The home team key |
BettingMarketSplits | BettingMarketSplit[] | 32 | No | No | Yes | The BettingMarkets included in this game that have splits |
GameInfo
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
GameId | integer | 32 | No | No | Yes | The unique ID of the game. |
Season | integer | 32 | No | No | Yes | The calendar year of the season during which this game occurs. |
SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
Day | date | Yes | No | Yes | The day that the game is scheduled to be played in UTC. | |
DateTime | datetime | Yes | No | Yes | The date/time that the game is scheduled to be played in UTC. | |
Status | string | 20 | Yes | No | Yes | Indicates the game's status. Possible values include: Scheduled, InProgress, Final, Suspended, Postponed, Delayed, Canceled |
AwayTeamId | integer | 32 | Yes | No | Yes | The TeamId of the away team. |
HomeTeamId | integer | 32 | Yes | No | Yes | The TeamId of the home team. |
AwayTeamName | string | 50 | Yes | No | Yes | The name of the away team. |
HomeTeamName | string | 50 | Yes | No | Yes | The name of the home team. |
GlobalGameId | integer | 32 | No | No | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
GlobalAwayTeamId | integer | 32 | Yes | No | No | A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues. |
GlobalHomeTeamId | integer | 32 | Yes | No | No | A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues. |
PregameOdds | GameOdd[] | Yes | No | Yes | List of Pregame GameOdds from different sportsbooks | |
LiveOdds | GameOdd[] | Yes | No | Yes | List of Live GameOdds from different sportsbooks | |
HomeTeamScore | integer | Yes | Yes | Yes | Score of the home team (updated after game ends to allow for resolving bets) | |
AwayTeamScore | integer | Yes | Yes | Yes | Score of the away team (updated after game ends to allow for resolving bets) | |
TotalScore | integer | Yes | Yes | Yes | Total scored points in the game (updated after game ends to allow for resolving bets) | |
HomeRotationNumber | integer | 32 | Yes | Yes | Yes | Rotation number of home team for this game |
AwayRotationNumber | integer | 32 | Yes | Yes | Yes | Rotation number of away team for this game |
AlternateMarketPregameOdds | GameOdd[] | Yes | No | Yes | 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 | CSV | Description |
---|---|---|---|---|---|---|
GameID | integer | 32 | No | No | Yes | The unique ID of the game. |
Season | integer | 32 | No | No | Yes | The calendar year of the season during which this game occurs. |
SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
Day | date | Yes | No | Yes | The day that the game is scheduled to be played in UTC. | |
DateTime | datetime | Yes | No | Yes | The date/time that the game is scheduled to be played in UTC. | |
Status | string | 20 | Yes | No | Yes | Indicates the game's status. Possible values include: Scheduled, InProgress, Final, Suspended, Postponed, Delayed, Canceled |
AwayTeamID | integer | 32 | Yes | No | Yes | The TeamId of the away team. |
HomeTeamID | integer | 32 | Yes | No | Yes | The TeamId of the home team. |
AwayTeamName | string | 50 | Yes | No | Yes | The name of the away team. |
HomeTeamName | string | 50 | Yes | No | Yes | The name of the home team. |
GlobalGameID | integer | 32 | No | No | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
GlobalAwayTeamID | integer | 32 | Yes | No | No | A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues. |
GlobalHomeTeamID | integer | 32 | Yes | No | No | A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues. |
PregameOdds | GameOddResult[] | Yes | No | Yes | List of Pregame GameOdds from different sportsbooks with results. | |
HomeTeamScore | integer | 32 | Yes | Yes | Yes | Score of the home team (updated after game ends to allow for resolving bets) |
AwayTeamScore | integer | 32 | Yes | Yes | Yes | Score of the away team (updated after game ends to allow for resolving bets) |
TotalScore | integer | 32 | Yes | Yes | Yes | Total scored points in the game (updated after game ends to allow for resolving bets) |
HomeRotationNumber | integer | 32 | Yes | Yes | Yes | Rotation number of home team for this game |
AwayRotationNumber | integer | 32 | Yes | Yes | Yes | Rotation number of away team for this game |
AlternateMarketPregameOdds | GameOddResult[] | Yes | No | Yes | List of Alternate Market Game Odds from different sportsbooks with results | |
Inning | integer | 32 | Yes | No | Yes | 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 | Yes | No | Yes | The inning half that the game is currently in, or the inning half in which the game ended (possible values: T, B, NULL) |
IsClosed | boolean | No | No | Yes | Indicates whether the game is over and the final score has been verified and closed out. | |
Innings | Inning[] | Yes | No | Yes | The details of the innings associated with this game | |
LiveOdds | GameOddResult[] | Yes | No | No | List of Live Odds from different sportsbooks with results |
GameOdd
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
GameOddId | integer | 32 | No | No | Yes | Unique ID of this odd |
Sportsbook | string | 25 | No | Yes | Yes | Name of sportsbook |
GameId | integer | 32 | No | No | Yes | The unique ID of the game |
Created | datetime | No | No | Yes | The timestamp of when these odds were first created, based on US Eatern Time (EST/EDT). | |
Updated | datetime | No | No | Yes | The timestamp of when these odds were last updated, based on US Eatern Time (EST/EDT). 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 | Yes | Yes | Yes | The sportsbook's money line for the home team |
AwayMoneyLine | integer | 32 | Yes | Yes | Yes | The sportsbook's money line for the away team |
HomePointSpread | decimal | 32 | Yes | Yes | Yes | The sportsbook's point spread for the home team |
AwayPointSpread | decimal | 32 | Yes | Yes | Yes | The sportsbook's point spread for the away team |
HomePointSpreadPayout | integer | 32 | Yes | Yes | Yes | The sportsbook's point spread payout for the home team |
AwayPointSpreadPayout | integer | 32 | Yes | Yes | Yes | The sportsbook's point spread payout for the away team |
OverUnder | decimal | 32 | Yes | Yes | Yes | The sportsbook's total points scored over under for the game |
OverPayout | integer | 32 | Yes | Yes | Yes | The sportsbook's payout for the over |
UnderPayout | integer | 32 | Yes | Yes | Yes | The sportsbook's payout for the under |
SportsbookId | integer | 32 | Yes | No | Yes | Unique ID of the sportsbook |
SportsbookUrl | string | 500 | Yes | No | No | The URL for sportsbook event |
OddType | string | 500 | Yes | No | Yes | The market type of the odd (ex: live, pregame, 1st-5th Inning, etc) |
Unlisted | datetime | Yes | No | No | The timestamp when these odds were no longer seen, based on US Eastern Time (EST/EDT) |
GameOddOutcome
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
GameOddId | integer | 32 | Yes | No | Yes | Unique ID of this odd |
GameOddResultTypeId | integer | 32 | Yes | No | Yes | The GameOddResultType of this outcome as an integer |
GameOddResultType | string | 100 | Yes | No | Yes | The string identifier of the GameOddResultType of this outcome (e.g. Won, Lost, Push, Not Resulted, Incomplete) |
OddType | string | 500 | Yes | No | Yes | The market type of the odd (ex: live, pregame, 1st-5th Inning, etc) |
GameOddType | string | 100 | Yes | No | Yes | The GameOddOutcomeType of this outcome as a string |
BetValue | decimal | 32 | Yes | No | Yes | The value that was bet in this outcome (if applicable) |
ActualValue | decimal | 32 | Yes | No | Yes | The value that actually occurred in game (if applicable) |
GameOddResult
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
GameOddID | integer | 32 | No | No | Yes | Unique ID of this odd |
Sportsbook | string | 25 | No | Yes | Yes | Name of sportsbook |
GameID | integer | 32 | No | No | Yes | The unique ID of the game |
Created | datetime | No | No | Yes | The timestamp of when these odds were first created, based on US Eatern Time (EST/EDT). | |
Updated | datetime | No | No | Yes | The timestamp of when these odds were last updated, based on US Eatern Time (EST/EDT). 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 | Yes | Yes | Yes | The sportsbook's money line for the home team |
AwayMoneyLine | integer | 32 | Yes | Yes | Yes | The sportsbook's money line for the away team |
HomePointSpread | decimal | 32 | Yes | Yes | Yes | The sportsbook's point spread for the home team |
AwayPointSpread | decimal | 32 | Yes | Yes | Yes | The sportsbook's point spread for the away team |
HomePointSpreadPayout | integer | 32 | Yes | Yes | Yes | The sportsbook's point spread payout for the home team |
AwayPointSpreadPayout | integer | 32 | Yes | Yes | Yes | The sportsbook's point spread payout for the away team |
OverUnder | decimal | 32 | Yes | Yes | Yes | The sportsbook's total points scored over under for the game |
OverPayout | integer | 32 | Yes | Yes | Yes | The sportsbook's payout for the over |
UnderPayout | integer | 32 | Yes | Yes | Yes | The sportsbook's payout for the under |
SportsbookID | integer | 32 | Yes | No | Yes | Unique ID of the sportsbook |
SportsbookUrl | string | 500 | Yes | No | No | The URL for sportsbook event |
OddType | string | 500 | Yes | No | Yes | The market type of the odd (ex: live, pregame, 1st-5th Inning, etc) |
GameOddOutcomeResults | GameOddOutcome[] | Yes | No | No | The list of outcomes under this Game Odd Record with results |
Headshot
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
PlayerID | integer | 32 | No | No | Yes | Unique ID of the Player (assigned by SportsDataIO). |
Name | string | 100 | Yes | No | Yes | Name of Player. |
TeamID | integer | 32 | Yes | No | Yes | Unique ID of the Team the player belongs to (assigned by SportsDataIO). |
Team | string | 10 | Yes | No | Yes | Name of the team the player belongs to. |
Position | string | 10 | Yes | No | Yes | Position player plays. |
PreferredHostedHeadshotUrl | string | 500 | Yes | No | Yes | The player's preferred hosted headshot URL. This returns the headshot with transparent background, if available. |
PreferredHostedHeadshotUpdated | datetime | Yes | No | Yes | The last updated date of the player's preferred hosted headshot. | |
HostedHeadshotWithBackgroundUrl | string | 500 | Yes | No | Yes | The player's hosted headshot URL. |
HostedHeadshotWithBackgroundUpdated | datetime | Yes | No | Yes | The last updated date of the player's hosted headshot. | |
HostedHeadshotNoBackgroundUrl | string | 500 | Yes | No | Yes | The player's transparent background hosted headshot URL. |
HostedHeadshotNoBackgroundUpdated | datetime | Yes | No | Yes | The last updated date of the player's transparent background hosted headshot. |
Inning
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
InningID | integer | 32 | No | No | Yes | The unique ID for the inning |
GameID | integer | 32 | No | No | Yes | The unique ID for the game |
InningNumber | integer | 32 | No | No | Yes | The inning number in the game |
AwayTeamRuns | integer | 32 | Yes | Yes | Yes | The number of away team runs in the inning |
HomeTeamRuns | integer | 32 | Yes | Yes | Yes | The number of home team runs in the inning |
Lineup
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
PlayerID
from 2021 |
integer | 32 | No | No | Yes | Unique ID of Player |
TeamID
from 2021 |
integer | 32 | No | No | Yes | Unique ID of Team |
Team
from 2021 |
string | 32 | No | No | Yes | Name of Team |
FirstName
from 2021 |
string | 32 | No | No | Yes | Player First Name |
LastName
from 2021 |
string | 32 | No | No | Yes | Player Last Name |
BattingOrder
from 2021 |
integer | 32 | Yes | Yes | Yes | Batting Order |
Position
from 2021 |
string | 32 | Yes | No | Yes | Player Position |
Starting
from 2021 |
bool | 32 | Yes | Yes | Yes | Indicates if this player is starting |
Confirmed
from 2021 |
bool | 32 | Yes | Yes | Yes | Indicates if batting order has been confimred |
MatchupTrends
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
UpcomingGame
from 2020 |
Game | Yes | No | Yes | Upcoming game between the team and the opponent | |
TeamTrends
from 2020 |
TeamTrends[] | Yes | No | Yes | The collection of team trends between each team | |
TeamMatchupTrends
from 2020 |
TeamGameTrends[] | Yes | No | Yes | The collection of team game trends against opponent | |
OpponentMatchupTrends
from 2020 |
TeamGameTrends[] | Yes | No | Yes | The collection of opponent game trends against team | |
PreviousGames
from 2020 |
Game[] | Yes | No | Yes | 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 | CSV | Description |
---|---|---|---|---|---|---|
NewsID | integer | 32 | No | No | Yes | Unique ID of news story |
Source | string | 50 | Yes | No | Yes | The source of the story (RotoBaller, NBCSports.com, etc.) |
Updated | datetime | No | No | Yes | The date/time that the content was published (UTC time zone) | |
TimeAgo | string | 50 | Yes | No | Yes | A description of how long ago this content was published |
Title | string | 100 | Yes | No | Yes | The brief title of the news (typically less than 100 characters) |
Content | string | 5000 | Yes | No | Yes | The full body content of the story |
Url | string | 250 | Yes | No | Yes | The url of the full story |
TermsOfUse | string | 500 | Yes | No | Yes | 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 | Yes | No | Yes | The author of the content |
Categories | string | 100 | Yes | No | Yes | 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 | Yes | No | Yes | The PlayerID of the player who relates to this story |
TeamID | integer | 32 | Yes | No | Yes | The TeamID of the team that relates to this story |
Team | string | 10 | Yes | No | Yes | The team that relates to this story |
PlayerID2 | integer | 32 | Yes | No | Yes | The PlayerID of the player who relates to this story |
TeamID2 | integer | 32 | Yes | No | Yes | The TeamID of the team that relates to this story |
Team2 | string | 10 | Yes | No | Yes | The team that relates to this story |
OriginalSource
from 2020 |
string | 100 | Yes | No | Yes | The original source who broke this news (before it was picked up by the publisher of this blurb) |
OriginalSourceUrl
from 2020 |
string | 1000 | Yes | No | Yes | The URL of the original source who broke this news blurb |
Pitch
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
PitchID | integer | 32 | No | No | Yes | The unqiue ID of the pitch. |
PlayID | integer | 32 | No | No | Yes | The unique ID of the play. |
PitchNumberThisAtBat | integer | 32 | Yes | Yes | Yes | The pitch number of the current at bat. |
PitcherID | integer | 32 | Yes | No | Yes | The unique ID of the pitcher. |
HitterID | integer | 32 | Yes | No | Yes | The unique ID of the hitter. |
Outs | integer | 32 | Yes | Yes | Yes | The number of outs hte pitcher recorded. |
BallsBeforePitch | integer | 32 | Yes | Yes | Yes | The number of balls the pitcher has thrown before the current pitch. |
StrikesBeforePitch | integer | 32 | Yes | Yes | Yes | The number of strikes the pitcher has thrown before the current pitch. |
Strike | boolean | Yes | Yes | Yes | Whether the pitch was a strike. (true/false) | |
Ball | boolean | Yes | Yes | Yes | Whether the pitch was a ball. (true/false) | |
Foul | boolean | Yes | Yes | Yes | Whether the pitch was hit foul. (true/false) | |
Swinging | boolean | Yes | Yes | Yes | Whether the hitter struck out swinging. (true/false) | |
Looking | boolean | Yes | Yes | Yes | Whether the hitter struck out looking. (true/false) |
Play
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
PlayID | integer | 32 | No | No | Yes | Unique ID for each Play. |
InningID | integer | 32 | No | No | Yes | The InningID of the Inning record, in which this Play occurred. |
InningNumber | integer | 32 | Yes | No | Yes | The inning in which the play occurred. |
InningHalf | string | 1 | Yes | No | Yes | The inning half in which the play occurred. |
PlayNumber | integer | 32 | Yes | Yes | Yes | The order in which this play occurred. |
InningBatterNumber | integer | 32 | Yes | Yes | Yes | The batter number in the inning where the play occurred. |
AwayTeamRuns | integer | 32 | Yes | Yes | Yes | This indicates the runs scored this play for the away team. |
HomeTeamRuns | integer | 32 | Yes | Yes | Yes | This indicates the runs scored this play for the home team. |
HitterID | integer | 32 | Yes | No | Yes | The HitterID who represents the play. |
PitcherID | integer | 32 | Yes | No | Yes | The PitcherID who represents the play. |
HitterTeamID | integer | 32 | Yes | No | Yes | The ID of the hitter's team. |
PitcherTeamID | integer | 32 | Yes | No | Yes | The ID of the pitcher's team. |
HitterName | string | 50 | Yes | No | Yes | The name of the hitter in the play. |
PitcherName | string | 50 | Yes | No | Yes | The name of the pitcher in the play. |
PitcherThrowHand | string | 1 | Yes | No | Yes | The throwing hand of the pitcher in which the play occurred. (right or left) |
HitterBatHand | string | 1 | Yes | No | Yes | The hand of the batter in which the play occurred. (right, left, or switch) |
HitterPosition | string | 10 | Yes | No | Yes | The position of the player in which the play occrred. (P,C,1B, SS, OF) |
Outs | integer | 32 | Yes | Yes | Yes | The number of outs in which the play occurred. |
Balls | integer | 32 | Yes | Yes | Yes | The number of balls in the count in which the play occurred. |
Strikes | integer | 32 | Yes | Yes | Yes | The number of strikes in the count in which the play occurred. |
PitchNumberThisAtBat | integer | 32 | Yes | Yes | Yes | The number of pitchers in the at bat in which the play occurred. |
Result | string | 50 | Yes | Yes | 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 | Yes | Yes | Yes | The number of outs recorded on the play. |
RunsBattedIn | integer | 32 | Yes | Yes | Yes | The number of runs batted in on the play. |
AtBat | boolean | Yes | No | Yes | Whether this play resulted in an at bat. (true/false) | |
Strikeout | boolean | Yes | No | Yes | Whether this play resulted in a strikeout. (true/false) | |
Walk | boolean | Yes | No | Yes | Whether this play resulted in a walk. (true/false) | |
Hit | boolean | Yes | No | Yes | Whether this play resulted in a hit. (true/false) | |
Out | boolean | Yes | No | Yes | Whether this play resutled in an out. (true/false) | |
Sacrifice | boolean | Yes | No | Yes | Whether this play resulted in a sacrifice. (true/false) | |
Error | boolean | Yes | No | Yes | Whether this play resulted in an error. (true/false) | |
Updated | date | Yes | No | Yes | The database generated timestamp of when this Play was last updated. | |
Description | string | 250 | Yes | Yes | Yes | The description of the play for display purposes |
Pitches | Pitch[] | Yes | No | Yes | The details of the pitches associated with this Play | |
Runner1ID | integer | 32 | Yes | No | Yes | The PlayerID of the player on first as a result of the play (post-play). |
Runner2ID | integer | 32 | Yes | No | Yes | The PlayerID of the player on second as a result of the play (post-play). |
Runner3ID | integer | 32 | Yes | No | Yes | 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 | CSV | Description |
---|---|---|---|---|---|---|
Game | Game | Yes | No | Yes | The details of the game associated with this play-by-play | |
Plays | Play[] | Yes | No | Yes | 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 | CSV | Description |
---|---|---|---|---|---|---|
PlayerID | integer | 32 | No | No | Yes | The player's unique PlayerID as assigned by SportsDataIO. |
SportsDataID | string | 50 | Yes | No | Yes | Deprecated. Use SportRadarPlayerID instead. |
Status | string | 50 | Yes | No | Yes | 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 | Yes | No | Yes | The TeamID of the team this player is employed by. |
Team | string | 10 | Yes | No | Yes | The key/abbreviation of the team this player is employed by. |
Jersey | integer | 32 | Yes | No | Yes | The player's jersey number. |
PositionCategory | string | 10 | Yes | No | Yes | The player's position category. Possible values: DH, IF, OF, P, PH, PR |
Position | string | 10 | Yes | No | Yes | The player's primary position. Possible values: 1B, 2B, 3B, C, CF, DH, IF, LF, OF, P, PH, PR, RF, RP, SP, SS |
MLBAMID | integer | 32 | Yes | No | Yes | The player's unique PlayerID for cross reference use with MLB AM. |
FirstName | string | 50 | Yes | No | Yes | The player's first name. |
LastName | string | 50 | Yes | No | Yes | The player's last name. |
BatHand | string | 1 | Yes | No | Yes | The player's batting hand. Possible values: R, L, S |
ThrowHand | string | 1 | Yes | No | Yes | The player's throwing hand. Possible values: R, L, S |
Height | integer | 32 | Yes | No | Yes | The player's height in inches. |
Weight | integer | 32 | Yes | No | Yes | The player's weight in pounds (lbs). |
BirthDate | datetime | Yes | No | Yes | The player's date of birth. | |
BirthCity | string | 50 | Yes | No | Yes | The city in which the player was born. |
BirthState | string | 50 | Yes | No | Yes | The state in which the player was born. |
BirthCountry | string | 50 | Yes | No | Yes | The country in which the player was born. |
HighSchool | string | 50 | Yes | No | Yes | The high school that the player attended. |
College | string | 50 | Yes | No | Yes | The college that the player attended. |
ProDebut | date | Yes | No | Yes | The date that this player made his MLB debut. | |
Salary | integer | 32 | Yes | No | Yes | Deprecated (do not use) |
PhotoUrl | string | 250 | Yes | No | Yes | This field is deprecated. Photos are no longer available through it. Headshots are now delivered through IMAGN. Please see our Headshots products for further information. |
SportRadarPlayerID | string | 50 | Yes | No | Yes | This player's unique ID for cross reference use with the SportRadar API. |
RotoworldPlayerID | integer | 32 | Yes | No | Yes | The player's unique PlayerID for cross reference use with Rotoworld. |
RotoWirePlayerID | integer | 32 | Yes | No | Yes | The player's unique PlayerID for cross reference use with RotoWire. |
FantasyAlarmPlayerID | integer | 32 | Yes | No | Yes | The player's unique PlayerID for cross reference use with FantasyAlarm. |
StatsPlayerID | integer | 32 | Yes | No | Yes | The player's unique PlayerID for cross reference use with Stats Player. |
SportsDirectPlayerID | integer | 32 | Yes | No | Yes | The player's unique PlayerID for cross reference use with Sports Direct. |
XmlTeamPlayerID | integer | 32 | Yes | No | Yes | The player's unique PlayerID for cross reference use with Xml Team. |
InjuryStatus | string | 50 | Yes | Yes | Yes | Indicates the player's injury status. Possible values include: Probable, Questionable, Doubtful, Out, 7 Day Disabled List, 15 Day Disabled List, 60 Day Disabled List |
InjuryBodyPart | string | 50 | Yes | Yes | Yes | Indicates the player's injured body part. (e.g. ankle, knee, etc.) |
InjuryStartDate | date | Yes | No | Yes | Indicates the start date of the player's injury. | |
InjuryNotes | string | 250 | Yes | Yes | Yes | Inidcates any notes about the player's injury. |
FanDuelPlayerID | integer | 32 | Yes | No | Yes | The player's unique PlayerID for cross reference use with FanDuel. |
DraftKingsPlayerID | integer | 32 | Yes | No | Yes | The player's unique PlayerID for cross reference use with DraftKings. |
YahooPlayerID | integer | 32 | Yes | No | Yes | The player's unique PlayerID for cross reference use with Yahoo. |
UpcomingGameID | integer | 32 | Yes | No | Yes | The GameID of this player's upcoming game. |
FanDuelName | string | 50 | Yes | No | Yes | The player's name on FanDuel. |
DraftKingsName | string | 50 | Yes | No | Yes | The player's name on Fan DraftKings. |
YahooName | string | 50 | Yes | No | Yes | The player's name on Yahoo. |
GlobalTeamID | integer | 32 | Yes | No | No | A globally unique ID for this player. This value is guaranteed to be unique across all sports/leagues. |
FantasyDraftName | string | 50 | Yes | No | Yes | The player's name on Fantasy Draft. |
FantasyDraftPlayerID | integer | 32 | Yes | No | Yes | The player's unique PlayerID for cross reference use with Fantasy Draft. |
Experience | string | 20 | Yes | No | Yes | The player's years of experience |
UsaTodayPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to USA Today headshot data feeds. |
UsaTodayHeadshotUrl | string | 100 | Yes | No | Yes | The player's headshot URL as provided by USA Today. License from USA Today is required. |
UsaTodayHeadshotNoBackgroundUrl | string | 100 | Yes | No | Yes | The player's transparent background headshot URL as provided by USA Today. License from USA Today is required. |
UsaTodayHeadshotUpdated | datetime | Yes | No | Yes | The last updated date of the player's headshot as provided by USA Today. License from USA Today is required. | |
UsaTodayHeadshotNoBackgroundUpdated | datetime | Yes | No | Yes | 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 | CSV | Description |
---|---|---|---|---|---|---|
PlayerID | integer | 32 | No | No | Yes | The player's unique PlayerID as assigned by SportsDataIO. |
SportsDataID | string | 50 | Yes | No | Yes | Deprecated. Use SportRadarPlayerID instead. |
Status | string | 50 | Yes | No | Yes | 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 | Yes | No | Yes | The TeamID of the team this player is employed by. |
Team | string | 10 | Yes | No | Yes | The key/abbreviation of the team this player is employed by. |
Jersey | integer | 32 | Yes | No | Yes | The player's jersey number. |
PositionCategory | string | 10 | Yes | No | Yes | The player's position category. Possible values: DH, IF, OF, P, PH, PR |
Position | string | 10 | Yes | No | Yes | The player's primary position. Possible values: 1B, 2B, 3B, C, CF, DH, IF, LF, OF, P, PH, PR, RF, RP, SP, SS |
FirstName | string | 50 | Yes | No | Yes | The player's first name. |
LastName | string | 50 | Yes | No | Yes | The player's last name. |
BirthDate | datetime | Yes | No | Yes | The player's date of birth. | |
BirthCity | string | 50 | Yes | No | Yes | The city in which the player was born. |
BirthState | string | 50 | Yes | No | Yes | The state in which the player was born. |
BirthCountry | string | 50 | Yes | No | Yes | The country in which the player was born. |
GlobalTeamID | integer | 32 | Yes | No | No | A globally unique ID for this player. This value is guaranteed to be unique across all sports/leagues. |
BatHand | string | 1 | Yes | No | Yes | The player's batting hand. Possible values: R, L, S |
ThrowHand | string | 1 | Yes | No | Yes | The player's throwing hand. Possible values: R, L, S |
Height | integer | 32 | Yes | No | Yes | The player's height in inches. |
Weight | integer | 32 | Yes | No | Yes | The player's weight in pounds (lbs). |
PlayerGame
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
StatID | integer | 32 | No | No | Yes | The unique ID of the stat |
TeamID | integer | 32 | Yes | No | Yes | The unique ID of the team |
PlayerID | integer | 32 | Yes | No | Yes | Unique ID assigned to each player that stays with them throughout their career |
SeasonType | integer | 32 | Yes | No | Yes | The season type of the timeframe (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=All-Star) |
Season | integer | 32 | Yes | No | Yes | The MLB season of the game |
Name | string | 50 | Yes | No | Yes | Player's name |
Team | string | 10 | Yes | No | Yes | The abbreviation of the Team |
Position | string | 10 | Yes | No | Yes | 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 | Yes | No | Yes | The category (P, C, 1B, OF, SS) of the players position |
Started | integer | 32 | Yes | No | Yes | Whether the player started |
BattingOrder | integer | 32 | Yes | Yes | Yes | Where the player batted in the line up (1,2,3, etc.) |
FanDuelSalary
from 2015 |
integer | 32 | Yes | Yes | Yes | The player's salary for FanDuel daily fantasy contests. |
DraftKingsSalary
from 2016 |
integer | 32 | Yes | Yes | Yes | The player's salary for DraftKings daily fantasy contests. |
FantasyDataSalary
from 2015 |
integer | 32 | Yes | Yes | 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 | Yes | Yes | Yes | The player's salary for Yahoo daily fantasy contests. |
InjuryStatus
from 2016 |
string | 50 | Yes | Yes | Yes | Indicates the player's injury status. Possible values include: Probable, Questionable, Doubtful, Out, 7 Day Disabled List, 15 Day Disabled List, 60 Day Disabled List |
InjuryBodyPart
from 2016 |
string | 50 | Yes | Yes | Yes | The body part that is injured (Knee, Groin, Calf, Hamstring, etc.) |
InjuryStartDate
from 2016 |
date | Yes | No | Yes | The day that the injury started or first discovered. | |
InjuryNotes
from 2016 |
string | 250 | Yes | Yes | Yes | Brief description of the player's injury and expected availability. |
FanDuelPosition
from 2016 |
string | 10 | Yes | No | Yes | The player's eligible position in FanDuel's daily fantasy sports platform. |
DraftKingsPosition
from 2016 |
string | 10 | Yes | No | Yes | The player's eligible position in DraftKings' daily fantasy sports platform. |
YahooPosition
from 2016 |
string | 10 | Yes | No | Yes | The player's eligible position in Yahoo's daily fantasy sports platform. |
OpponentRank
from 2016 |
integer | 32 | Yes | Yes | Yes | The ranking of the player's opponent with regards to fantasy points allowed. |
OpponentPositionRank
from 2016 |
integer | 32 | Yes | Yes | Yes | The ranking of the player's opponent by position with regards to fantasy points allowed. |
GlobalTeamID | integer | 32 | Yes | No | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
FantasyDraftSalary
from 2017 |
integer | 32 | Yes | Yes | Yes | The player's salary for Fantasy Draft daily fantasy contests. |
FantasyDraftPosition
from 2017 |
string | 10 | Yes | No | Yes | The player's eligible position in Fantasy Drafts daily fantasy sports platform. |
GameID | integer | 32 | Yes | No | Yes | The unique ID of this game |
OpponentID | integer | 32 | Yes | No | Yes | The unique ID of the team's opponent |
Opponent | string | 10 | Yes | No | Yes | The name of the opponent |
Day | date | Yes | No | Yes | The day of the game | |
DateTime | datetime | Yes | No | Yes | The date and time of the game | |
HomeOrAway | string | 4 | Yes | No | Yes | Whether the team is home or away |
IsGameOver | boolean | No | No | Yes | Whether the game is over (true/false) | |
GlobalGameID | integer | 32 | Yes | No | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
GlobalOpponentID | integer | 32 | Yes | No | Yes | A globally unique ID for this opponent. This value is guaranteed to be unique across all sports/leagues. |
Updated | datetime | Yes | No | Yes | The timestamp of when the record was last updated (US Eastern Time). | |
Games | integer | 32 | Yes | No | Yes | The number of games played. |
FantasyPoints | decimal | 32 | Yes | Yes | Yes | Total fantasy points |
AtBats | decimal | 32 | Yes | Yes | Yes | At bats while hitting |
Runs | decimal | 32 | Yes | Yes | Yes | Total runs scored. |
Hits | decimal | 32 | Yes | Yes | Yes | Total hits |
Singles | decimal | 32 | Yes | Yes | Yes | Total singles |
Doubles | decimal | 32 | Yes | Yes | Yes | Total doubles |
Triples | decimal | 32 | Yes | Yes | Yes | Total triples |
HomeRuns | decimal | 32 | Yes | Yes | Yes | Total home runs |
RunsBattedIn | decimal | 32 | Yes | Yes | Yes | Total runs batted in |
BattingAverage | decimal | 32 | Yes | Yes | Yes | Total batting average |
Outs | decimal | 32 | Yes | Yes | Yes | Total outs |
Strikeouts | decimal | 32 | Yes | Yes | Yes | Total strikeouts |
Walks | decimal | 32 | Yes | Yes | Yes | Total walks |
HitByPitch | decimal | 32 | Yes | Yes | Yes | Total times hit by pitch |
Sacrifices | decimal | 32 | Yes | Yes | Yes | Total sacrifices |
SacrificeFlies | decimal | 32 | Yes | Yes | Yes | Total sacrifice flies |
GroundIntoDoublePlay | decimal | 32 | Yes | Yes | Yes | Total times grounded into double play |
StolenBases | decimal | 32 | Yes | Yes | Yes | Total stolen bases |
CaughtStealing | decimal | 32 | Yes | Yes | Yes | Total caught stealing |
PitchesSeen | decimal | 32 | Yes | Yes | Yes | Total pitches seen |
OnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total on base percentage |
SluggingPercentage | decimal | 32 | Yes | Yes | Yes | Total slugging percentage |
OnBasePlusSlugging | decimal | 32 | Yes | Yes | Yes | Total on base plus percentage |
Errors | decimal | 32 | Yes | Yes | Yes | Total errors |
Wins | decimal | 32 | Yes | Yes | Yes | Total wins by the team/player |
Losses | decimal | 32 | Yes | Yes | Yes | Total losses by the team/player |
Saves | decimal | 32 | Yes | Yes | Yes | Total saves by team/player |
InningsPitchedDecimal | decimal | 32 | Yes | Yes | Yes | Decimal representation of total innings pitched (e.g. 1.33, 7.66, etc) |
TotalOutsPitched | decimal | 32 | Yes | Yes | Yes | Total outs pitched by team/player |
InningsPitchedFull | decimal | 32 | Yes | Yes | Yes | Total full innings pitched (e.g. 6, 71, 89, etc) |
InningsPitchedOuts | decimal | 32 | Yes | Yes | Yes | Outs pitched beyond InningsPitchedFull (possible values: 0, 1, 2) |
EarnedRunAverage | decimal | 32 | Yes | Yes | Yes | Total earned run average by team/player |
PitchingHits | decimal | 32 | Yes | Yes | Yes | Hits allowed while pitching |
PitchingRuns | decimal | 32 | Yes | Yes | Yes | Runs allowed while pitching |
PitchingEarnedRuns | decimal | 32 | Yes | Yes | Yes | Earned runs allowed while pitching |
PitchingWalks | decimal | 32 | Yes | Yes | Yes | Walks allowed while pitching |
PitchingStrikeouts | decimal | 32 | Yes | Yes | Yes | Strikeouts allowed while pitching |
PitchingHomeRuns | decimal | 32 | Yes | Yes | Yes | Home runs allowed while pitching |
PitchesThrown | decimal | 32 | Yes | Yes | Yes | Total pitches thrown while pitching |
PitchesThrownStrikes | decimal | 32 | Yes | Yes | Yes | Total pitches thrown for strikes while pitching |
WalksHitsPerInningsPitched | decimal | 32 | Yes | Yes | Yes | Walks plus hits per innings pitched (WHIP) while pitching |
PitchingBattingAverageAgainst | decimal | 32 | Yes | Yes | Yes | Total batting average against (BAA) while pitching |
GrandSlams | decimal | 32 | Yes | Yes | Yes | Total grand slams |
FantasyPointsFanDuel | decimal | 32 | Yes | Yes | Yes | Total FanDuel fantasy points |
FantasyPointsDraftKings | decimal | 32 | Yes | Yes | Yes | Total DraftKings fantasy points |
FantasyPointsYahoo | decimal | 32 | Yes | Yes | Yes | Total Yahoo fantasy points |
PlateAppearances | decimal | 32 | Yes | Yes | Yes | Total plate appearances |
TotalBases | decimal | 32 | Yes | Yes | Yes | Number of total bases |
FlyOuts | decimal | 32 | Yes | Yes | Yes | Total fly outs |
GroundOuts | decimal | 32 | Yes | Yes | Yes | Total ground outs |
LineOuts | decimal | 32 | Yes | Yes | Yes | Total line outs |
PopOuts | decimal | 32 | Yes | Yes | Yes | Total pop outs |
IntentionalWalks | decimal | 32 | Yes | Yes | Yes | Total intentional walks |
ReachedOnError | decimal | 32 | Yes | Yes | Yes | Total times reached on error |
BallsInPlay | decimal | 32 | Yes | Yes | Yes | Total balls in play |
BattingAverageOnBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total batting average on balls in play (BABIP) |
WeightedOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total weight on base percentage |
PitchingSingles | decimal | 32 | Yes | Yes | Yes | Total singles allowed while pitching |
PitchingDoubles | decimal | 32 | Yes | Yes | Yes | Total doubles allowed while pitching |
PitchingTriples | decimal | 32 | Yes | Yes | Yes | Total triples allowed while pitching |
PitchingGrandSlams | decimal | 32 | Yes | Yes | Yes | Total grand slams allowed while pitching |
PitchingHitByPitch | decimal | 32 | Yes | Yes | Yes | Total batters hit by pitch while pitching |
PitchingSacrifices | decimal | 32 | Yes | Yes | Yes | Total sacrifices while pitching |
PitchingSacrificeFlies | decimal | 32 | Yes | Yes | Yes | Total sacrifice flies while pitching |
PitchingGroundIntoDoublePlay | decimal | 32 | Yes | Yes | Yes | Total grounded into double plays while pitching |
PitchingCompleteGames | decimal | 32 | Yes | Yes | Yes | Total complete games while pitching |
PitchingShutOuts | decimal | 32 | Yes | Yes | Yes | Total shuouts while pitching |
PitchingNoHitters | decimal | 32 | Yes | Yes | Yes | Total no hitters while pitching |
PitchingPerfectGames | decimal | 32 | Yes | Yes | Yes | Total perfect games while pitching |
PitchingPlateAppearances | decimal | 32 | Yes | Yes | Yes | Total plate appearances while pitching |
PitchingTotalBases | decimal | 32 | Yes | Yes | Yes | Total bases while pitching |
PitchingFlyOuts | decimal | 32 | Yes | Yes | Yes | Total fly outs while pitching |
PitchingGroundOuts | decimal | 32 | Yes | Yes | Yes | Total ground outs while pitching |
PitchingLineOuts | decimal | 32 | Yes | Yes | Yes | Total line outs while pitching |
PitchingPopOuts | decimal | 32 | Yes | Yes | Yes | Total pop outs while pitching |
PitchingIntentionalWalks | decimal | 32 | Yes | Yes | Yes | Total intentional walks while pitching |
PitchingReachedOnError | decimal | 32 | Yes | Yes | Yes | Total times reached on error while pitching |
PitchingCatchersInterference | decimal | 32 | Yes | Yes | Yes | Total catchers interference while pitching |
PitchingBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total balls in play while pitching |
PitchingOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total on base percentage (OBP) while pitching |
PitchingSluggingPercentage | decimal | 32 | Yes | Yes | Yes | Total slugging percentage (SLG) while pitching |
PitchingOnBasePlusSlugging | decimal | 32 | Yes | Yes | Yes | Total on base plus slugging (OPS) while pitching |
PitchingStrikeoutsPerNineInnings | decimal | 32 | Yes | Yes | Yes | Total strikeouts per nine innings (K/9) while pitching |
PitchingWalksPerNineInnings | decimal | 32 | Yes | Yes | Yes | Total walks per nine innings (BB/9) while pitching |
PitchingBattingAverageOnBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total batting average on balls in play (BABIP) while pitching |
PitchingWeightedOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total weighted on base percentage while pitching |
DoublePlays | decimal | 32 | Yes | Yes | 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 | Yes | Yes | Yes | Total double plays while pitching |
BattingOrderConfirmed | boolean | Yes | Yes | Yes | Whether the batting order is confirmed (true/false) | |
IsolatedPower | decimal | 32 | Yes | Yes | Yes | Total isolated power (ISO) |
FieldingIndependentPitching | decimal | 32 | Yes | Yes | Yes | Total fielding independent pitching (FIP) |
PitchingQualityStarts | decimal | 32 | Yes | Yes | Yes | Total quality starts pitched |
PitchingInningStarted | integer | 32 | Yes | Yes | Yes | The inning that the pitcher entered the game (if any). |
LeftOnBase
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total left on base percentage |
PitchingHolds
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total holds pitched |
PitchingBlownSaves
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total blown saves pitched |
SubstituteBattingOrder
from 2017 |
integer | 32 | Yes | Yes | 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 | Yes | Yes | Yes | The sequence in which this player was substituted into the game, within the particular batting order |
FantasyPointsFantasyDraft | decimal | 32 | Yes | Yes | Yes | Total FantasyDraft fantasy points |
FantasyPointsBatting | decimal | 32 | Yes | No | Yes | Total batting fantasy points |
FantasyPointsPitching | decimal | 32 | Yes | No | Yes | Total pitching fantasy points |
PlayerGameBasic
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
Updated | datetime | Yes | No | Yes | The timestamp of when the record was last updated (US Eastern Time). | |
Games | integer | 32 | Yes | No | Yes | The number of games played. |
AtBats | decimal | 32 | Yes | Yes | Yes | At bats while hitting |
Runs | decimal | 32 | Yes | Yes | Yes | Total runs scored. |
Hits | decimal | 32 | Yes | Yes | Yes | Total hits |
Singles | decimal | 32 | Yes | Yes | Yes | Total singles |
Doubles | decimal | 32 | Yes | Yes | Yes | Total doubles |
Triples | decimal | 32 | Yes | Yes | Yes | Total triples |
HomeRuns | decimal | 32 | Yes | Yes | Yes | Total home runs |
RunsBattedIn | decimal | 32 | Yes | Yes | Yes | Total runs batted in |
BattingAverage | decimal | 32 | Yes | Yes | Yes | Total batting average |
Outs | decimal | 32 | Yes | Yes | Yes | Total outs |
Strikeouts | decimal | 32 | Yes | Yes | Yes | Total strikeouts |
Walks | decimal | 32 | Yes | Yes | Yes | Total walks |
HitByPitch | decimal | 32 | Yes | Yes | Yes | Total times hit by pitch |
Sacrifices | decimal | 32 | Yes | Yes | Yes | Total sacrifices |
SacrificeFlies | decimal | 32 | Yes | Yes | Yes | Total sacrifice flies |
GroundIntoDoublePlay | decimal | 32 | Yes | Yes | Yes | Total times grounded into double play |
StolenBases | decimal | 32 | Yes | Yes | Yes | Total stolen bases |
CaughtStealing | decimal | 32 | Yes | Yes | Yes | Total caught stealing |
PitchesSeen | decimal | 32 | Yes | Yes | Yes | Total pitches seen |
OnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total on base percentage |
SluggingPercentage | decimal | 32 | Yes | Yes | Yes | Total slugging percentage |
OnBasePlusSlugging | decimal | 32 | Yes | Yes | Yes | Total on base plus percentage |
Errors | decimal | 32 | Yes | Yes | Yes | Total errors |
Wins | decimal | 32 | Yes | Yes | Yes | Total wins by the team/player |
Losses | decimal | 32 | Yes | Yes | Yes | Total losses by the team/player |
Saves | decimal | 32 | Yes | Yes | Yes | Total saves by team/player |
InningsPitchedDecimal | decimal | 32 | Yes | Yes | Yes | Decimal representation of total innings pitched (e.g. 1.33, 7.66, etc) |
TotalOutsPitched | decimal | 32 | Yes | Yes | Yes | Total outs pitched by team/player |
InningsPitchedFull | decimal | 32 | Yes | Yes | Yes | Total full innings pitched (e.g. 6, 71, 89, etc) |
InningsPitchedOuts | decimal | 32 | Yes | Yes | Yes | Outs pitched beyond InningsPitchedFull (possible values: 0, 1, 2) |
EarnedRunAverage | decimal | 32 | Yes | Yes | Yes | Total earned run average by team/player |
PitchingHits | decimal | 32 | Yes | Yes | Yes | Hits allowed while pitching |
PitchingRuns | decimal | 32 | Yes | Yes | Yes | Runs allowed while pitching |
PitchingEarnedRuns | decimal | 32 | Yes | Yes | Yes | Earned runs allowed while pitching |
PitchingWalks | decimal | 32 | Yes | Yes | Yes | Walks allowed while pitching |
PitchingStrikeouts | decimal | 32 | Yes | Yes | Yes | Strikeouts allowed while pitching |
PitchingHomeRuns | decimal | 32 | Yes | Yes | Yes | Home runs allowed while pitching |
PitchesThrown | decimal | 32 | Yes | Yes | Yes | Total pitches thrown while pitching |
PitchesThrownStrikes | decimal | 32 | Yes | Yes | Yes | Total pitches thrown for strikes while pitching |
WalksHitsPerInningsPitched | decimal | 32 | Yes | Yes | Yes | Walks plus hits per innings pitched (WHIP) while pitching |
PitchingBattingAverageAgainst | decimal | 32 | Yes | Yes | Yes | Total batting average against (BAA) while pitching |
GrandSlams | decimal | 32 | Yes | Yes | Yes | Total grand slams |
PlateAppearances | decimal | 32 | Yes | Yes | Yes | Total plate appearances |
TotalBases | decimal | 32 | Yes | Yes | Yes | Number of total bases |
FlyOuts | decimal | 32 | Yes | Yes | Yes | Total fly outs |
GroundOuts | decimal | 32 | Yes | Yes | Yes | Total ground outs |
LineOuts | decimal | 32 | Yes | Yes | Yes | Total line outs |
PopOuts | decimal | 32 | Yes | Yes | Yes | Total pop outs |
IntentionalWalks | decimal | 32 | Yes | Yes | Yes | Total intentional walks |
ReachedOnError | decimal | 32 | Yes | Yes | Yes | Total times reached on error |
BallsInPlay | decimal | 32 | Yes | Yes | Yes | Total balls in play |
BattingAverageOnBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total batting average on balls in play (BABIP) |
WeightedOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total weight on base percentage |
PitchingSingles | decimal | 32 | Yes | Yes | Yes | Total singles allowed while pitching |
PitchingDoubles | decimal | 32 | Yes | Yes | Yes | Total doubles allowed while pitching |
PitchingTriples | decimal | 32 | Yes | Yes | Yes | Total triples allowed while pitching |
PitchingGrandSlams | decimal | 32 | Yes | Yes | Yes | Total grand slams allowed while pitching |
PitchingHitByPitch | decimal | 32 | Yes | Yes | Yes | Total batters hit by pitch while pitching |
PitchingSacrifices | decimal | 32 | Yes | Yes | Yes | Total sacrifices while pitching |
PitchingSacrificeFlies | decimal | 32 | Yes | Yes | Yes | Total sacrifice flies while pitching |
PitchingGroundIntoDoublePlay | decimal | 32 | Yes | Yes | Yes | Total grounded into double plays while pitching |
PitchingCompleteGames | decimal | 32 | Yes | Yes | Yes | Total complete games while pitching |
PitchingShutOuts | decimal | 32 | Yes | Yes | Yes | Total shuouts while pitching |
PitchingNoHitters | decimal | 32 | Yes | Yes | Yes | Total no hitters while pitching |
PitchingPerfectGames | decimal | 32 | Yes | Yes | Yes | Total perfect games while pitching |
PitchingPlateAppearances | decimal | 32 | Yes | Yes | Yes | Total plate appearances while pitching |
PitchingTotalBases | decimal | 32 | Yes | Yes | Yes | Total bases while pitching |
PitchingFlyOuts | decimal | 32 | Yes | Yes | Yes | Total fly outs while pitching |
PitchingGroundOuts | decimal | 32 | Yes | Yes | Yes | Total ground outs while pitching |
PitchingLineOuts | decimal | 32 | Yes | Yes | Yes | Total line outs while pitching |
PitchingPopOuts | decimal | 32 | Yes | Yes | Yes | Total pop outs while pitching |
PitchingIntentionalWalks | decimal | 32 | Yes | Yes | Yes | Total intentional walks while pitching |
PitchingReachedOnError | decimal | 32 | Yes | Yes | Yes | Total times reached on error while pitching |
PitchingCatchersInterference | decimal | 32 | Yes | Yes | Yes | Total catchers interference while pitching |
PitchingBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total balls in play while pitching |
PitchingOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total on base percentage (OBP) while pitching |
PitchingSluggingPercentage | decimal | 32 | Yes | Yes | Yes | Total slugging percentage (SLG) while pitching |
PitchingOnBasePlusSlugging | decimal | 32 | Yes | Yes | Yes | Total on base plus slugging (OPS) while pitching |
PitchingStrikeoutsPerNineInnings | decimal | 32 | Yes | Yes | Yes | Total strikeouts per nine innings (K/9) while pitching |
PitchingWalksPerNineInnings | decimal | 32 | Yes | Yes | Yes | Total walks per nine innings (BB/9) while pitching |
PitchingBattingAverageOnBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total batting average on balls in play (BABIP) while pitching |
PitchingWeightedOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total weighted on base percentage while pitching |
DoublePlays | decimal | 32 | Yes | Yes | 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 | Yes | Yes | Yes | Total double plays while pitching |
BattingOrderConfirmed | boolean | Yes | Yes | Yes | Whether the batting order is confirmed (true/false) | |
IsolatedPower | decimal | 32 | Yes | Yes | Yes | Total isolated power (ISO) |
FieldingIndependentPitching | decimal | 32 | Yes | Yes | Yes | Total fielding independent pitching (FIP) |
PitchingQualityStarts | decimal | 32 | Yes | Yes | Yes | Total quality starts pitched |
PitchingInningStarted | integer | 32 | Yes | Yes | Yes | The inning that the pitcher entered the game (if any). |
LeftOnBase | decimal | 32 | Yes | Yes | Yes | Total left on base percentage |
PitchingHolds | decimal | 32 | Yes | Yes | Yes | Total holds pitched |
PitchingBlownSaves | decimal | 32 | Yes | Yes | Yes | Total blown saves pitched |
SubstituteBattingOrder | integer | 32 | Yes | Yes | 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 | Yes | Yes | Yes | The sequence in which this player was substituted into the game, within the particular batting order |
GameID | integer | 32 | Yes | No | Yes | The unique ID of this game |
OpponentID | integer | 32 | Yes | No | Yes | The unique ID of the team's opponent |
Opponent | string | 10 | Yes | No | Yes | The name of the opponent |
Day | date | Yes | No | Yes | The day of the game | |
DateTime | datetime | Yes | No | Yes | The date and time of the game | |
HomeOrAway | string | 4 | Yes | No | Yes | Whether the team is home or away |
IsGameOver | boolean | No | No | Yes | Whether the game is over (true/false) | |
GlobalGameID | integer | 32 | Yes | No | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
GlobalOpponentID | integer | 32 | Yes | No | Yes | A globally unique ID for this opponent. This value is guaranteed to be unique across all sports/leagues. |
StatID | integer | 32 | No | No | Yes | The unique ID of the stat |
TeamID | integer | 32 | Yes | No | Yes | The unique ID of the team |
PlayerID | integer | 32 | Yes | No | Yes | Unique ID assigned to each player that stays with them throughout their career |
SeasonType | integer | 32 | Yes | No | Yes | The season type of the timeframe (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=All-Star) |
Season | integer | 32 | Yes | No | Yes | The MLB season of the game |
Name | string | 50 | Yes | No | Yes | Player's name |
Team | string | 10 | Yes | No | Yes | The abbreviation of the Team |
Position | string | 10 | Yes | No | Yes | 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 | Yes | No | Yes | The category (P, C, 1B, OF, SS) of the players position |
Started | integer | 32 | Yes | No | Yes | Whether the player started |
BattingOrder | integer | 32 | Yes | Yes | Yes | Where the player batted in the line up (1,2,3, etc.) |
GlobalTeamID | integer | 32 | Yes | No | 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 | CSV | Description |
---|---|---|---|---|---|---|
StatID | integer | 32 | No | No | Yes | The unique ID of the stat |
TeamID | integer | 32 | Yes | No | Yes | The unique ID of the team |
PlayerID | integer | 32 | Yes | No | Yes | Unique ID assigned to each player that stays with them throughout their career |
SeasonType | integer | 32 | Yes | No | Yes | The season type of the timeframe (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=All-Star) |
Season | integer | 32 | Yes | No | Yes | The MLB season of the game |
Name | string | 50 | Yes | No | Yes | Player's name |
Team | string | 10 | Yes | No | Yes | The abbreviation of the Team |
Position | string | 10 | Yes | No | Yes | 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 | Yes | No | Yes | The category (P, C, 1B, OF, SS) of the players position |
Started | integer | 32 | Yes | No | Yes | Whether the player started |
BattingOrder | integer | 32 | Yes | Yes | Yes | Where the player batted in the line up (1,2,3, etc.) |
FanDuelSalary
from 2015 |
integer | 32 | Yes | Yes | Yes | The player's salary for FanDuel daily fantasy contests. |
DraftKingsSalary
from 2016 |
integer | 32 | Yes | Yes | Yes | The player's salary for DraftKings daily fantasy contests. |
FantasyDataSalary
from 2015 |
integer | 32 | Yes | Yes | 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 | Yes | Yes | Yes | The player's salary for Yahoo daily fantasy contests. |
InjuryStatus
from 2016 |
string | 50 | Yes | Yes | Yes | Indicates the player's injury status. Possible values include: Probable, Questionable, Doubtful, Out, 7 Day Disabled List, 15 Day Disabled List, 60 Day Disabled List |
InjuryBodyPart
from 2016 |
string | 50 | Yes | Yes | Yes | The body part that is injured (Knee, Groin, Calf, Hamstring, etc.) |
InjuryStartDate
from 2016 |
date | Yes | No | Yes | The day that the injury started or first discovered. | |
InjuryNotes
from 2016 |
string | 250 | Yes | Yes | Yes | Brief description of the player's injury and expected availability. |
FanDuelPosition
from 2016 |
string | 10 | Yes | No | Yes | The player's eligible position in FanDuel's daily fantasy sports platform. |
DraftKingsPosition
from 2016 |
string | 10 | Yes | No | Yes | The player's eligible position in DraftKings' daily fantasy sports platform. |
YahooPosition
from 2016 |
string | 10 | Yes | No | Yes | The player's eligible position in Yahoo's daily fantasy sports platform. |
OpponentRank
from 2016 |
integer | 32 | Yes | Yes | Yes | The ranking of the player's opponent with regards to fantasy points allowed. |
OpponentPositionRank
from 2016 |
integer | 32 | Yes | Yes | Yes | The ranking of the player's opponent by position with regards to fantasy points allowed. |
GlobalTeamID | integer | 32 | Yes | No | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
FantasyDraftSalary
from 2017 |
integer | 32 | Yes | Yes | Yes | The player's salary for Fantasy Draft daily fantasy contests. |
FantasyDraftPosition
from 2017 |
string | 10 | Yes | No | Yes | The player's eligible position in Fantasy Drafts daily fantasy sports platform. |
GameID | integer | 32 | Yes | No | Yes | The unique ID of this game |
OpponentID | integer | 32 | Yes | No | Yes | The unique ID of the team's opponent |
Opponent | string | 10 | Yes | No | Yes | The name of the opponent |
Day | date | Yes | No | Yes | The day of the game | |
DateTime | datetime | Yes | No | Yes | The date and time of the game | |
HomeOrAway | string | 4 | Yes | No | Yes | Whether the team is home or away |
IsGameOver | boolean | No | No | Yes | Whether the game is over (true/false) | |
GlobalGameID | integer | 32 | Yes | No | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
GlobalOpponentID | integer | 32 | Yes | No | Yes | A globally unique ID for this opponent. This value is guaranteed to be unique across all sports/leagues. |
Updated | datetime | Yes | No | Yes | The timestamp of when the record was last updated (US Eastern Time). | |
Games | integer | 32 | Yes | No | Yes | The number of games played. |
FantasyPoints | decimal | 32 | Yes | Yes | Yes | Total fantasy points |
AtBats | decimal | 32 | Yes | Yes | Yes | At bats while hitting |
Runs | decimal | 32 | Yes | Yes | Yes | Total runs scored. |
Hits | decimal | 32 | Yes | Yes | Yes | Total hits |
Singles | decimal | 32 | Yes | Yes | Yes | Total singles |
Doubles | decimal | 32 | Yes | Yes | Yes | Total doubles |
Triples | decimal | 32 | Yes | Yes | Yes | Total triples |
HomeRuns | decimal | 32 | Yes | Yes | Yes | Total home runs |
RunsBattedIn | decimal | 32 | Yes | Yes | Yes | Total runs batted in |
BattingAverage | decimal | 32 | Yes | Yes | Yes | Total batting average |
Outs | decimal | 32 | Yes | Yes | Yes | Total outs |
Strikeouts | decimal | 32 | Yes | Yes | Yes | Total strikeouts |
Walks | decimal | 32 | Yes | Yes | Yes | Total walks |
HitByPitch | decimal | 32 | Yes | Yes | Yes | Total times hit by pitch |
Sacrifices | decimal | 32 | Yes | Yes | Yes | Total sacrifices |
SacrificeFlies | decimal | 32 | Yes | Yes | Yes | Total sacrifice flies |
GroundIntoDoublePlay | decimal | 32 | Yes | Yes | Yes | Total times grounded into double play |
StolenBases | decimal | 32 | Yes | Yes | Yes | Total stolen bases |
CaughtStealing | decimal | 32 | Yes | Yes | Yes | Total caught stealing |
PitchesSeen | decimal | 32 | Yes | Yes | Yes | Total pitches seen |
OnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total on base percentage |
SluggingPercentage | decimal | 32 | Yes | Yes | Yes | Total slugging percentage |
OnBasePlusSlugging | decimal | 32 | Yes | Yes | Yes | Total on base plus percentage |
Errors | decimal | 32 | Yes | Yes | Yes | Total errors |
Wins | decimal | 32 | Yes | Yes | Yes | Total wins by the team/player |
Losses | decimal | 32 | Yes | Yes | Yes | Total losses by the team/player |
Saves | decimal | 32 | Yes | Yes | Yes | Total saves by team/player |
InningsPitchedDecimal | decimal | 32 | Yes | Yes | Yes | Decimal representation of total innings pitched (e.g. 1.33, 7.66, etc) |
TotalOutsPitched | decimal | 32 | Yes | Yes | Yes | Total outs pitched by team/player |
InningsPitchedFull | decimal | 32 | Yes | Yes | Yes | Total full innings pitched (e.g. 6, 71, 89, etc) |
InningsPitchedOuts | decimal | 32 | Yes | Yes | Yes | Outs pitched beyond InningsPitchedFull (possible values: 0, 1, 2) |
EarnedRunAverage | decimal | 32 | Yes | Yes | Yes | Total earned run average by team/player |
PitchingHits | decimal | 32 | Yes | Yes | Yes | Hits allowed while pitching |
PitchingRuns | decimal | 32 | Yes | Yes | Yes | Runs allowed while pitching |
PitchingEarnedRuns | decimal | 32 | Yes | Yes | Yes | Earned runs allowed while pitching |
PitchingWalks | decimal | 32 | Yes | Yes | Yes | Walks allowed while pitching |
PitchingStrikeouts | decimal | 32 | Yes | Yes | Yes | Strikeouts allowed while pitching |
PitchingHomeRuns | decimal | 32 | Yes | Yes | Yes | Home runs allowed while pitching |
PitchesThrown | decimal | 32 | Yes | Yes | Yes | Total pitches thrown while pitching |
PitchesThrownStrikes | decimal | 32 | Yes | Yes | Yes | Total pitches thrown for strikes while pitching |
WalksHitsPerInningsPitched | decimal | 32 | Yes | Yes | Yes | Walks plus hits per innings pitched (WHIP) while pitching |
PitchingBattingAverageAgainst | decimal | 32 | Yes | Yes | Yes | Total batting average against (BAA) while pitching |
GrandSlams | decimal | 32 | Yes | Yes | Yes | Total grand slams |
FantasyPointsFanDuel | decimal | 32 | Yes | Yes | Yes | Total FanDuel fantasy points |
FantasyPointsDraftKings | decimal | 32 | Yes | Yes | Yes | Total DraftKings fantasy points |
FantasyPointsYahoo | decimal | 32 | Yes | Yes | Yes | Total Yahoo fantasy points |
PlateAppearances | decimal | 32 | Yes | Yes | Yes | Total plate appearances |
TotalBases | decimal | 32 | Yes | Yes | Yes | Number of total bases |
FlyOuts | decimal | 32 | Yes | Yes | Yes | Total fly outs |
GroundOuts | decimal | 32 | Yes | Yes | Yes | Total ground outs |
LineOuts | decimal | 32 | Yes | Yes | Yes | Total line outs |
PopOuts | decimal | 32 | Yes | Yes | Yes | Total pop outs |
IntentionalWalks | decimal | 32 | Yes | Yes | Yes | Total intentional walks |
ReachedOnError | decimal | 32 | Yes | Yes | Yes | Total times reached on error |
BallsInPlay | decimal | 32 | Yes | Yes | Yes | Total balls in play |
BattingAverageOnBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total batting average on balls in play (BABIP) |
WeightedOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total weight on base percentage |
PitchingSingles | decimal | 32 | Yes | Yes | Yes | Total singles allowed while pitching |
PitchingDoubles | decimal | 32 | Yes | Yes | Yes | Total doubles allowed while pitching |
PitchingTriples | decimal | 32 | Yes | Yes | Yes | Total triples allowed while pitching |
PitchingGrandSlams | decimal | 32 | Yes | Yes | Yes | Total grand slams allowed while pitching |
PitchingHitByPitch | decimal | 32 | Yes | Yes | Yes | Total batters hit by pitch while pitching |
PitchingSacrifices | decimal | 32 | Yes | Yes | Yes | Total sacrifices while pitching |
PitchingSacrificeFlies | decimal | 32 | Yes | Yes | Yes | Total sacrifice flies while pitching |
PitchingGroundIntoDoublePlay | decimal | 32 | Yes | Yes | Yes | Total grounded into double plays while pitching |
PitchingCompleteGames | decimal | 32 | Yes | Yes | Yes | Total complete games while pitching |
PitchingShutOuts | decimal | 32 | Yes | Yes | Yes | Total shuouts while pitching |
PitchingNoHitters | decimal | 32 | Yes | Yes | Yes | Total no hitters while pitching |
PitchingPerfectGames | decimal | 32 | Yes | Yes | Yes | Total perfect games while pitching |
PitchingPlateAppearances | decimal | 32 | Yes | Yes | Yes | Total plate appearances while pitching |
PitchingTotalBases | decimal | 32 | Yes | Yes | Yes | Total bases while pitching |
PitchingFlyOuts | decimal | 32 | Yes | Yes | Yes | Total fly outs while pitching |
PitchingGroundOuts | decimal | 32 | Yes | Yes | Yes | Total ground outs while pitching |
PitchingLineOuts | decimal | 32 | Yes | Yes | Yes | Total line outs while pitching |
PitchingPopOuts | decimal | 32 | Yes | Yes | Yes | Total pop outs while pitching |
PitchingIntentionalWalks | decimal | 32 | Yes | Yes | Yes | Total intentional walks while pitching |
PitchingReachedOnError | decimal | 32 | Yes | Yes | Yes | Total times reached on error while pitching |
PitchingCatchersInterference | decimal | 32 | Yes | Yes | Yes | Total catchers interference while pitching |
PitchingBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total balls in play while pitching |
PitchingOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total on base percentage (OBP) while pitching |
PitchingSluggingPercentage | decimal | 32 | Yes | Yes | Yes | Total slugging percentage (SLG) while pitching |
PitchingOnBasePlusSlugging | decimal | 32 | Yes | Yes | Yes | Total on base plus slugging (OPS) while pitching |
PitchingStrikeoutsPerNineInnings | decimal | 32 | Yes | Yes | Yes | Total strikeouts per nine innings (K/9) while pitching |
PitchingWalksPerNineInnings | decimal | 32 | Yes | Yes | Yes | Total walks per nine innings (BB/9) while pitching |
PitchingBattingAverageOnBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total batting average on balls in play (BABIP) while pitching |
PitchingWeightedOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total weighted on base percentage while pitching |
DoublePlays | decimal | 32 | Yes | Yes | 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 | Yes | Yes | Yes | Total double plays while pitching |
BattingOrderConfirmed | boolean | Yes | Yes | Yes | Whether the batting order is confirmed (true/false) | |
IsolatedPower | decimal | 32 | Yes | Yes | Yes | Total isolated power (ISO) |
FieldingIndependentPitching | decimal | 32 | Yes | Yes | Yes | Total fielding independent pitching (FIP) |
PitchingQualityStarts | decimal | 32 | Yes | Yes | Yes | Total quality starts pitched |
PitchingInningStarted | integer | 32 | Yes | Yes | Yes | The inning that the pitcher entered the game (if any). |
LeftOnBase
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total left on base percentage |
PitchingHolds
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total holds pitched |
PitchingBlownSaves
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total blown saves pitched |
SubstituteBattingOrder
from 2017 |
integer | 32 | Yes | Yes | 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 | Yes | Yes | Yes | The sequence in which this player was substituted into the game, within the particular batting order |
FantasyPointsFantasyDraft | decimal | 32 | Yes | Yes | Yes | Total FantasyDraft fantasy points |
FantasyPointsBatting | decimal | 32 | Yes | No | Yes | Total batting fantasy points |
FantasyPointsPitching | decimal | 32 | Yes | No | Yes | Total pitching fantasy points |
PlayerInfo
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
PlayerID | integer | 32 | No | No | Yes | Unique ID of the Player (assigned by SportsDataIO). |
Name | string | 50 | Yes | No | Yes | Name of Player. |
TeamID | integer | 32 | Yes | No | Yes | Unique ID of the Team the player belongs to (assigned by SportsDataIO). |
Team | string | 50 | Yes | No | Yes | Name of the team the player belongs to. |
Position | string | 50 | Yes | No | Yes | Position player plays. |
PlayerSeason
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
StatID | integer | 32 | No | No | Yes | The unique ID of the stat |
TeamID | integer | 32 | Yes | No | Yes | The unique ID of the player's team |
PlayerID | integer | 32 | Yes | No | Yes | Unique ID assigned to each player that stays with them throughout their career |
SeasonType | integer | 32 | Yes | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
Season | integer | 32 | Yes | No | Yes | The MLB regular season for which these totals apply |
Name | string | 50 | Yes | No | Yes | Player's name |
Team | string | 10 | Yes | No | Yes | The abbreviation of the Team |
Position | string | 10 | Yes | No | Yes | Player's position in the starting lineup (if started), otherwise the position he substituted for |
PositionCategory | string | 10 | Yes | No | Yes | Abbreviation of the player's position (P, C, 1B, OF, etc.) |
Started | integer | 32 | Yes | No | Yes | Number of games started |
BattingOrder | integer | 32 | Yes | No | Yes | Number in the batting order (1,2,3, etc.) |
GlobalTeamID | integer | 32 | Yes | No | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
AverageDraftPosition | decimal | 32 | Yes | Yes | Yes | The average draft position of the player |
AuctionValue | integer | 32 | Yes | Yes | Yes | The auction value for this player as it pertains to auction-style drafts for season-long fantasy baseball. |
Updated | datetime | Yes | No | Yes | The timestamp of when the record was last updated (US Eastern Time). | |
Games | integer | 32 | Yes | No | Yes | The number of games played. |
FantasyPoints | decimal | 32 | Yes | Yes | Yes | Total fantasy points |
AtBats | decimal | 32 | Yes | Yes | Yes | At bats while hitting |
Runs | decimal | 32 | Yes | Yes | Yes | Total runs scored. |
Hits | decimal | 32 | Yes | Yes | Yes | Total hits |
Singles | decimal | 32 | Yes | Yes | Yes | Total singles |
Doubles | decimal | 32 | Yes | Yes | Yes | Total doubles |
Triples | decimal | 32 | Yes | Yes | Yes | Total triples |
HomeRuns | decimal | 32 | Yes | Yes | Yes | Total home runs |
RunsBattedIn | decimal | 32 | Yes | Yes | Yes | Total runs batted in |
BattingAverage | decimal | 32 | Yes | Yes | Yes | Total batting average |
Outs | decimal | 32 | Yes | Yes | Yes | Total outs |
Strikeouts | decimal | 32 | Yes | Yes | Yes | Total strikeouts |
Walks | decimal | 32 | Yes | Yes | Yes | Total walks |
HitByPitch | decimal | 32 | Yes | Yes | Yes | Total times hit by pitch |
Sacrifices | decimal | 32 | Yes | Yes | Yes | Total sacrifices |
SacrificeFlies | decimal | 32 | Yes | Yes | Yes | Total sacrifice flies |
GroundIntoDoublePlay | decimal | 32 | Yes | Yes | Yes | Total times grounded into double play |
StolenBases | decimal | 32 | Yes | Yes | Yes | Total stolen bases |
CaughtStealing | decimal | 32 | Yes | Yes | Yes | Total caught stealing |
PitchesSeen | decimal | 32 | Yes | Yes | Yes | Total pitches seen |
OnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total on base percentage |
SluggingPercentage | decimal | 32 | Yes | Yes | Yes | Total slugging percentage |
OnBasePlusSlugging | decimal | 32 | Yes | Yes | Yes | Total on base plus percentage |
Errors | decimal | 32 | Yes | Yes | Yes | Total errors |
Wins | decimal | 32 | Yes | Yes | Yes | Total wins by the team/player |
Losses | decimal | 32 | Yes | Yes | Yes | Total losses by the team/player |
Saves | decimal | 32 | Yes | Yes | Yes | Total saves by team/player |
InningsPitchedDecimal | decimal | 32 | Yes | Yes | Yes | Decimal representation of total innings pitched (e.g. 1.33, 7.66, etc) |
TotalOutsPitched | decimal | 32 | Yes | Yes | Yes | Total outs pitched by team/player |
InningsPitchedFull | decimal | 32 | Yes | Yes | Yes | Total full innings pitched (e.g. 6, 71, 89, etc) |
InningsPitchedOuts | decimal | 32 | Yes | Yes | Yes | Outs pitched beyond InningsPitchedFull (possible values: 0, 1, 2) |
EarnedRunAverage | decimal | 32 | Yes | Yes | Yes | Total earned run average by team/player |
PitchingHits | decimal | 32 | Yes | Yes | Yes | Hits allowed while pitching |
PitchingRuns | decimal | 32 | Yes | Yes | Yes | Runs allowed while pitching |
PitchingEarnedRuns | decimal | 32 | Yes | Yes | Yes | Earned runs allowed while pitching |
PitchingWalks | decimal | 32 | Yes | Yes | Yes | Walks allowed while pitching |
PitchingStrikeouts | decimal | 32 | Yes | Yes | Yes | Strikeouts allowed while pitching |
PitchingHomeRuns | decimal | 32 | Yes | Yes | Yes | Home runs allowed while pitching |
PitchesThrown | decimal | 32 | Yes | Yes | Yes | Total pitches thrown while pitching |
PitchesThrownStrikes | decimal | 32 | Yes | Yes | Yes | Total pitches thrown for strikes while pitching |
WalksHitsPerInningsPitched | decimal | 32 | Yes | Yes | Yes | Walks plus hits per innings pitched (WHIP) while pitching |
PitchingBattingAverageAgainst | decimal | 32 | Yes | Yes | Yes | Total batting average against (BAA) while pitching |
GrandSlams | decimal | 32 | Yes | Yes | Yes | Total grand slams |
FantasyPointsFanDuel | decimal | 32 | Yes | Yes | Yes | Total FanDuel fantasy points |
FantasyPointsDraftKings | decimal | 32 | Yes | Yes | Yes | Total DraftKings fantasy points |
FantasyPointsYahoo | decimal | 32 | Yes | Yes | Yes | Total Yahoo fantasy points |
PlateAppearances | decimal | 32 | Yes | Yes | Yes | Total plate appearances |
TotalBases | decimal | 32 | Yes | Yes | Yes | Number of total bases |
FlyOuts | decimal | 32 | Yes | Yes | Yes | Total fly outs |
GroundOuts | decimal | 32 | Yes | Yes | Yes | Total ground outs |
LineOuts | decimal | 32 | Yes | Yes | Yes | Total line outs |
PopOuts | decimal | 32 | Yes | Yes | Yes | Total pop outs |
IntentionalWalks | decimal | 32 | Yes | Yes | Yes | Total intentional walks |
ReachedOnError | decimal | 32 | Yes | Yes | Yes | Total times reached on error |
BallsInPlay | decimal | 32 | Yes | Yes | Yes | Total balls in play |
BattingAverageOnBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total batting average on balls in play (BABIP) |
WeightedOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total weight on base percentage |
PitchingSingles | decimal | 32 | Yes | Yes | Yes | Total singles allowed while pitching |
PitchingDoubles | decimal | 32 | Yes | Yes | Yes | Total doubles allowed while pitching |
PitchingTriples | decimal | 32 | Yes | Yes | Yes | Total triples allowed while pitching |
PitchingGrandSlams | decimal | 32 | Yes | Yes | Yes | Total grand slams allowed while pitching |
PitchingHitByPitch | decimal | 32 | Yes | Yes | Yes | Total batters hit by pitch while pitching |
PitchingSacrifices | decimal | 32 | Yes | Yes | Yes | Total sacrifices while pitching |
PitchingSacrificeFlies | decimal | 32 | Yes | Yes | Yes | Total sacrifice flies while pitching |
PitchingGroundIntoDoublePlay | decimal | 32 | Yes | Yes | Yes | Total grounded into double plays while pitching |
PitchingCompleteGames | decimal | 32 | Yes | Yes | Yes | Total complete games while pitching |
PitchingShutOuts | decimal | 32 | Yes | Yes | Yes | Total shuouts while pitching |
PitchingNoHitters | decimal | 32 | Yes | Yes | Yes | Total no hitters while pitching |
PitchingPerfectGames | decimal | 32 | Yes | Yes | Yes | Total perfect games while pitching |
PitchingPlateAppearances | decimal | 32 | Yes | Yes | Yes | Total plate appearances while pitching |
PitchingTotalBases | decimal | 32 | Yes | Yes | Yes | Total bases while pitching |
PitchingFlyOuts | decimal | 32 | Yes | Yes | Yes | Total fly outs while pitching |
PitchingGroundOuts | decimal | 32 | Yes | Yes | Yes | Total ground outs while pitching |
PitchingLineOuts | decimal | 32 | Yes | Yes | Yes | Total line outs while pitching |
PitchingPopOuts | decimal | 32 | Yes | Yes | Yes | Total pop outs while pitching |
PitchingIntentionalWalks | decimal | 32 | Yes | Yes | Yes | Total intentional walks while pitching |
PitchingReachedOnError | decimal | 32 | Yes | Yes | Yes | Total times reached on error while pitching |
PitchingCatchersInterference | decimal | 32 | Yes | Yes | Yes | Total catchers interference while pitching |
PitchingBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total balls in play while pitching |
PitchingOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total on base percentage (OBP) while pitching |
PitchingSluggingPercentage | decimal | 32 | Yes | Yes | Yes | Total slugging percentage (SLG) while pitching |
PitchingOnBasePlusSlugging | decimal | 32 | Yes | Yes | Yes | Total on base plus slugging (OPS) while pitching |
PitchingStrikeoutsPerNineInnings | decimal | 32 | Yes | Yes | Yes | Total strikeouts per nine innings (K/9) while pitching |
PitchingWalksPerNineInnings | decimal | 32 | Yes | Yes | Yes | Total walks per nine innings (BB/9) while pitching |
PitchingBattingAverageOnBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total batting average on balls in play (BABIP) while pitching |
PitchingWeightedOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total weighted on base percentage while pitching |
DoublePlays | decimal | 32 | Yes | Yes | 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 | Yes | Yes | Yes | Total double plays while pitching |
BattingOrderConfirmed | boolean | Yes | Yes | Yes | Whether the batting order is confirmed (true/false) | |
IsolatedPower | decimal | 32 | Yes | Yes | Yes | Total isolated power (ISO) |
FieldingIndependentPitching | decimal | 32 | Yes | Yes | Yes | Total fielding independent pitching (FIP) |
PitchingQualityStarts | decimal | 32 | Yes | Yes | Yes | Total quality starts pitched |
PitchingInningStarted | integer | 32 | Yes | Yes | Yes | The inning that the pitcher entered the game (if any). |
LeftOnBase
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total left on base percentage |
PitchingHolds
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total holds pitched |
PitchingBlownSaves
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total blown saves pitched |
SubstituteBattingOrder
from 2017 |
integer | 32 | Yes | Yes | 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 | Yes | Yes | Yes | The sequence in which this player was substituted into the game, within the particular batting order |
FantasyPointsFantasyDraft | decimal | 32 | Yes | Yes | Yes | Total FantasyDraft fantasy points |
FantasyPointsBatting | decimal | 32 | Yes | No | Yes | Total batting fantasy points |
FantasyPointsPitching | decimal | 32 | Yes | No | Yes | Total pitching fantasy points |
PlayerSeasonProjection
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
StatID | integer | 32 | No | No | Yes | The unique ID of the stat |
TeamID | integer | 32 | Yes | No | Yes | The unique ID of the player's team |
PlayerID | integer | 32 | Yes | No | Yes | Unique ID assigned to each player that stays with them throughout their career |
SeasonType | integer | 32 | Yes | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
Season | integer | 32 | Yes | No | Yes | The MLB regular season for which these totals apply |
Name | string | 50 | Yes | No | Yes | Player's name |
Team | string | 10 | Yes | No | Yes | The abbreviation of the Team |
Position | string | 10 | Yes | No | Yes | Player's position in the starting lineup (if started), otherwise the position he substituted for |
PositionCategory | string | 10 | Yes | No | Yes | Abbreviation of the player's position (P, C, 1B, OF, etc.) |
Started | integer | 32 | Yes | No | Yes | Number of games started |
BattingOrder | integer | 32 | Yes | No | Yes | Number in the batting order (1,2,3, etc.) |
GlobalTeamID | integer | 32 | Yes | No | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
AverageDraftPosition | decimal | 32 | Yes | Yes | Yes | The average draft position of the player |
AuctionValue | integer | 32 | Yes | Yes | Yes | The auction value for this player as it pertains to auction-style drafts for season-long fantasy baseball. |
Updated | datetime | Yes | No | Yes | The timestamp of when the record was last updated (US Eastern Time). | |
Games | integer | 32 | Yes | No | Yes | The number of games played. |
FantasyPoints | decimal | 32 | Yes | Yes | Yes | Total fantasy points |
AtBats | decimal | 32 | Yes | Yes | Yes | At bats while hitting |
Runs | decimal | 32 | Yes | Yes | Yes | Total runs scored. |
Hits | decimal | 32 | Yes | Yes | Yes | Total hits |
Singles | decimal | 32 | Yes | Yes | Yes | Total singles |
Doubles | decimal | 32 | Yes | Yes | Yes | Total doubles |
Triples | decimal | 32 | Yes | Yes | Yes | Total triples |
HomeRuns | decimal | 32 | Yes | Yes | Yes | Total home runs |
RunsBattedIn | decimal | 32 | Yes | Yes | Yes | Total runs batted in |
BattingAverage | decimal | 32 | Yes | Yes | Yes | Total batting average |
Outs | decimal | 32 | Yes | Yes | Yes | Total outs |
Strikeouts | decimal | 32 | Yes | Yes | Yes | Total strikeouts |
Walks | decimal | 32 | Yes | Yes | Yes | Total walks |
HitByPitch | decimal | 32 | Yes | Yes | Yes | Total times hit by pitch |
Sacrifices | decimal | 32 | Yes | Yes | Yes | Total sacrifices |
SacrificeFlies | decimal | 32 | Yes | Yes | Yes | Total sacrifice flies |
GroundIntoDoublePlay | decimal | 32 | Yes | Yes | Yes | Total times grounded into double play |
StolenBases | decimal | 32 | Yes | Yes | Yes | Total stolen bases |
CaughtStealing | decimal | 32 | Yes | Yes | Yes | Total caught stealing |
PitchesSeen | decimal | 32 | Yes | Yes | Yes | Total pitches seen |
OnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total on base percentage |
SluggingPercentage | decimal | 32 | Yes | Yes | Yes | Total slugging percentage |
OnBasePlusSlugging | decimal | 32 | Yes | Yes | Yes | Total on base plus percentage |
Errors | decimal | 32 | Yes | Yes | Yes | Total errors |
Wins | decimal | 32 | Yes | Yes | Yes | Total wins by the team/player |
Losses | decimal | 32 | Yes | Yes | Yes | Total losses by the team/player |
Saves | decimal | 32 | Yes | Yes | Yes | Total saves by team/player |
InningsPitchedDecimal | decimal | 32 | Yes | Yes | Yes | Decimal representation of total innings pitched (e.g. 1.33, 7.66, etc) |
TotalOutsPitched | decimal | 32 | Yes | Yes | Yes | Total outs pitched by team/player |
InningsPitchedFull | decimal | 32 | Yes | Yes | Yes | Total full innings pitched (e.g. 6, 71, 89, etc) |
InningsPitchedOuts | decimal | 32 | Yes | Yes | Yes | Outs pitched beyond InningsPitchedFull (possible values: 0, 1, 2) |
EarnedRunAverage | decimal | 32 | Yes | Yes | Yes | Total earned run average by team/player |
PitchingHits | decimal | 32 | Yes | Yes | Yes | Hits allowed while pitching |
PitchingRuns | decimal | 32 | Yes | Yes | Yes | Runs allowed while pitching |
PitchingEarnedRuns | decimal | 32 | Yes | Yes | Yes | Earned runs allowed while pitching |
PitchingWalks | decimal | 32 | Yes | Yes | Yes | Walks allowed while pitching |
PitchingStrikeouts | decimal | 32 | Yes | Yes | Yes | Strikeouts allowed while pitching |
PitchingHomeRuns | decimal | 32 | Yes | Yes | Yes | Home runs allowed while pitching |
PitchesThrown | decimal | 32 | Yes | Yes | Yes | Total pitches thrown while pitching |
PitchesThrownStrikes | decimal | 32 | Yes | Yes | Yes | Total pitches thrown for strikes while pitching |
WalksHitsPerInningsPitched | decimal | 32 | Yes | Yes | Yes | Walks plus hits per innings pitched (WHIP) while pitching |
PitchingBattingAverageAgainst | decimal | 32 | Yes | Yes | Yes | Total batting average against (BAA) while pitching |
GrandSlams | decimal | 32 | Yes | Yes | Yes | Total grand slams |
FantasyPointsFanDuel | decimal | 32 | Yes | Yes | Yes | Total FanDuel fantasy points |
FantasyPointsDraftKings | decimal | 32 | Yes | Yes | Yes | Total DraftKings fantasy points |
FantasyPointsYahoo | decimal | 32 | Yes | Yes | Yes | Total Yahoo fantasy points |
PlateAppearances | decimal | 32 | Yes | Yes | Yes | Total plate appearances |
TotalBases | decimal | 32 | Yes | Yes | Yes | Number of total bases |
FlyOuts | decimal | 32 | Yes | Yes | Yes | Total fly outs |
GroundOuts | decimal | 32 | Yes | Yes | Yes | Total ground outs |
LineOuts | decimal | 32 | Yes | Yes | Yes | Total line outs |
PopOuts | decimal | 32 | Yes | Yes | Yes | Total pop outs |
IntentionalWalks | decimal | 32 | Yes | Yes | Yes | Total intentional walks |
ReachedOnError | decimal | 32 | Yes | Yes | Yes | Total times reached on error |
BallsInPlay | decimal | 32 | Yes | Yes | Yes | Total balls in play |
BattingAverageOnBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total batting average on balls in play (BABIP) |
WeightedOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total weight on base percentage |
PitchingSingles | decimal | 32 | Yes | Yes | Yes | Total singles allowed while pitching |
PitchingDoubles | decimal | 32 | Yes | Yes | Yes | Total doubles allowed while pitching |
PitchingTriples | decimal | 32 | Yes | Yes | Yes | Total triples allowed while pitching |
PitchingGrandSlams | decimal | 32 | Yes | Yes | Yes | Total grand slams allowed while pitching |
PitchingHitByPitch | decimal | 32 | Yes | Yes | Yes | Total batters hit by pitch while pitching |
PitchingSacrifices | decimal | 32 | Yes | Yes | Yes | Total sacrifices while pitching |
PitchingSacrificeFlies | decimal | 32 | Yes | Yes | Yes | Total sacrifice flies while pitching |
PitchingGroundIntoDoublePlay | decimal | 32 | Yes | Yes | Yes | Total grounded into double plays while pitching |
PitchingCompleteGames | decimal | 32 | Yes | Yes | Yes | Total complete games while pitching |
PitchingShutOuts | decimal | 32 | Yes | Yes | Yes | Total shuouts while pitching |
PitchingNoHitters | decimal | 32 | Yes | Yes | Yes | Total no hitters while pitching |
PitchingPerfectGames | decimal | 32 | Yes | Yes | Yes | Total perfect games while pitching |
PitchingPlateAppearances | decimal | 32 | Yes | Yes | Yes | Total plate appearances while pitching |
PitchingTotalBases | decimal | 32 | Yes | Yes | Yes | Total bases while pitching |
PitchingFlyOuts | decimal | 32 | Yes | Yes | Yes | Total fly outs while pitching |
PitchingGroundOuts | decimal | 32 | Yes | Yes | Yes | Total ground outs while pitching |
PitchingLineOuts | decimal | 32 | Yes | Yes | Yes | Total line outs while pitching |
PitchingPopOuts | decimal | 32 | Yes | Yes | Yes | Total pop outs while pitching |
PitchingIntentionalWalks | decimal | 32 | Yes | Yes | Yes | Total intentional walks while pitching |
PitchingReachedOnError | decimal | 32 | Yes | Yes | Yes | Total times reached on error while pitching |
PitchingCatchersInterference | decimal | 32 | Yes | Yes | Yes | Total catchers interference while pitching |
PitchingBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total balls in play while pitching |
PitchingOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total on base percentage (OBP) while pitching |
PitchingSluggingPercentage | decimal | 32 | Yes | Yes | Yes | Total slugging percentage (SLG) while pitching |
PitchingOnBasePlusSlugging | decimal | 32 | Yes | Yes | Yes | Total on base plus slugging (OPS) while pitching |
PitchingStrikeoutsPerNineInnings | decimal | 32 | Yes | Yes | Yes | Total strikeouts per nine innings (K/9) while pitching |
PitchingWalksPerNineInnings | decimal | 32 | Yes | Yes | Yes | Total walks per nine innings (BB/9) while pitching |
PitchingBattingAverageOnBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total batting average on balls in play (BABIP) while pitching |
PitchingWeightedOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total weighted on base percentage while pitching |
DoublePlays | decimal | 32 | Yes | Yes | 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 | Yes | Yes | Yes | Total double plays while pitching |
BattingOrderConfirmed | boolean | Yes | Yes | Yes | Whether the batting order is confirmed (true/false) | |
IsolatedPower | decimal | 32 | Yes | Yes | Yes | Total isolated power (ISO) |
FieldingIndependentPitching | decimal | 32 | Yes | Yes | Yes | Total fielding independent pitching (FIP) |
PitchingQualityStarts | decimal | 32 | Yes | Yes | Yes | Total quality starts pitched |
PitchingInningStarted | integer | 32 | Yes | Yes | Yes | The inning that the pitcher entered the game (if any). |
LeftOnBase
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total left on base percentage |
PitchingHolds
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total holds pitched |
PitchingBlownSaves
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total blown saves pitched |
SubstituteBattingOrder
from 2017 |
integer | 32 | Yes | Yes | 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 | Yes | Yes | Yes | The sequence in which this player was substituted into the game, within the particular batting order |
FantasyPointsFantasyDraft | decimal | 32 | Yes | Yes | Yes | Total FantasyDraft fantasy points |
FantasyPointsBatting | decimal | 32 | Yes | No | Yes | Total batting fantasy points |
FantasyPointsPitching | decimal | 32 | Yes | No | Yes | Total pitching fantasy points |
ScheduleBasic
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
GameID | integer | 32 | Yes | No | Yes | The GameID of this MLB game |
Season | integer | 32 | No | No | Yes | The MLB season of the game |
SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
Status | string | 20 | Yes | No | No | Indicates the game's status. Possible values include: Scheduled, InProgress, Final, Suspended, Delayed, Postponed, Canceled, Forfeit, NotNecessary |
Day | date | Yes | No | No | The date of the game | |
DateTime | datetime | Yes | No | No | The date and time of the game | |
AwayTeam | string | 50 | Yes | No | Yes | The abbreviation of the Away Team |
HomeTeam | string | 50 | Yes | No | Yes | The abbreviation of the Home Team |
AwayTeamID | integer | 32 | Yes | No | No | The unique ID of the away team |
HomeTeamID | integer | 32 | Yes | No | No | The unique ID of the home team |
RescheduledGameID | integer | 32 | Yes | No | Yes | The GameID of the game that was rescheduled from this game. This only pertains to postponed games that require rescheduling. |
StadiumID | integer | 32 | Yes | No | Yes | The unique ID of the stadium |
IsClosed | boolean | No | No | Yes | Indicates whether the game is over and the final score has been verified and closed out. | |
Updated | datetime | Yes | No | Yes | The timestamp of when the record was last updated (US Eastern Time). | |
GameEndDateTime | datetime | Yes | No | Yes | The date and time that the game ended in US Eastern Time | |
DateTimeUTC | datetime | Yes | No | Yes | The date and time of the game in UTC. | |
SeriesInfo | Series | 32 | Yes | No | Yes | Contains relevant series data for playoff series only - HomeTeamWins, AwayTeamWins, GameNumber, and MaxLength |
RescheduledFromGameID | integer | 32 | Yes | Yes | 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. |
ScoreBasic
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
AwayTeamRuns | integer | 32 | Yes | Yes | Yes | Number of runs the away team scored in this game |
HomeTeamRuns | integer | 32 | Yes | Yes | Yes | Number of runs the home team scored in this game |
AwayTeamHits | integer | 32 | Yes | Yes | Yes | Total away team hits in this game |
HomeTeamHits | integer | 32 | Yes | Yes | Yes | Total home team hits in this game |
AwayTeamErrors | integer | 32 | Yes | Yes | Yes | Total away team errors committed in this game |
HomeTeamErrors | integer | 32 | Yes | Yes | Yes | Total home team errors committed in this game |
Attendance | integer | 32 | Yes | No | Yes | Total number of people who attended the game |
GlobalGameID | integer | 32 | No | No | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
GlobalAwayTeamID | integer | 32 | No | No | No | A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues. |
GlobalHomeTeamID | integer | 32 | No | No | No | A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues. |
NeutralVenue | boolean | Yes | No | Yes | Indicates whether this game is played in a neutral venue | |
Inning | integer | 32 | Yes | No | Yes | 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 | Yes | No | Yes | The inning half that the game is currently in, or the inning half in which the game ended (possible values: T, B, NULL) |
GameID | integer | 32 | Yes | No | Yes | The GameID of this MLB game |
Season | integer | 32 | No | No | Yes | The MLB season of the game |
SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
Status | string | 20 | Yes | No | No | Indicates the game's status. Possible values include: Scheduled, InProgress, Final, Suspended, Delayed, Postponed, Canceled, Forfeit, NotNecessary |
Day | date | Yes | No | No | The date of the game | |
DateTime | datetime | Yes | No | No | The date and time of the game | |
AwayTeam | string | 50 | Yes | No | Yes | The abbreviation of the Away Team |
HomeTeam | string | 50 | Yes | No | Yes | The abbreviation of the Home Team |
AwayTeamID | integer | 32 | Yes | No | No | The unique ID of the away team |
HomeTeamID | integer | 32 | Yes | No | No | The unique ID of the home team |
RescheduledGameID | integer | 32 | Yes | No | Yes | The GameID of the game that was rescheduled from this game. This only pertains to postponed games that require rescheduling. |
StadiumID | integer | 32 | Yes | No | Yes | The unique ID of the stadium |
IsClosed | boolean | No | No | Yes | Indicates whether the game is over and the final score has been verified and closed out. | |
Updated | datetime | Yes | No | Yes | The timestamp of when the record was last updated (US Eastern Time). | |
GameEndDateTime | datetime | Yes | No | Yes | The date and time that the game ended in US Eastern Time | |
DateTimeUTC | datetime | Yes | No | Yes | The date and time of the game in UTC. | |
SeriesInfo | Series | 32 | Yes | No | Yes | Contains relevant series data for playoff series only - HomeTeamWins, AwayTeamWins, GameNumber, and MaxLength |
RescheduledFromGameID | integer | 32 | Yes | Yes | 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. |
Season
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
Season | integer | 32 | No | No | Yes | The MLB regular season for which these totals apply |
RegularSeasonStartDate | date | Yes | No | Yes | The start date of the regular season | |
PostSeasonStartDate | date | Yes | No | Yes | The start date of the postseason | |
SeasonType | string | 10 | Yes | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
ApiSeason | string | 10 | Yes | No | Yes | The current season's value to be used to pass into subsequent API calls (sample values: 2017REG, 2018PRE, 2018REG, 2018POST, etc) |
Series
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
HomeTeamWins | integer | 32 | No | No | Yes | Number of Wins by the Home Team |
AwayTeamWins | integer | 32 | No | No | Yes | Number of Wins by the Away Team |
GameNumber | integer | 32 | No | No | Yes | Game Number in Series |
MaxLength | integer | 32 | No | No | Yes | Maximum Number of Games in Series |
Sportsbook
Available Endpoints
This table is used in the following endpoints:
-
Props
- Betting Events - by Date
- Betting Events - by Season
- Betting Markets - by Event
- Betting Markets - by 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 | CSV | Description |
---|---|---|---|---|---|---|
SportsbookID | int | 32 | No | No | Yes | The unique identifier of the sportsbook |
Name | string | 32 | No | Yes | Yes | The name of the sportsbooks |
Stadium
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
StadiumID | integer | 32 | No | No | Yes | The unique ID of the stadium |
Active | boolean | No | No | Yes | The stadium will be set to Active if it exists. Expect available stadiums to be set to Active. For finding a team's current home stadium, Teams endpoints should be used. | |
Name | string | 100 | No | No | Yes | The full name of the stadium |
City | string | 50 | Yes | No | Yes | The city where the stadium is located |
State | string | 10 | Yes | No | Yes | The US state where the stadium is located (if Stadium is outside US, this value is NULL) |
Country | string | 10 | Yes | No | Yes | The 2-digit country code where the stadium is located |
Capacity | integer | 32 | Yes | No | Yes | The estimated seating capacity of the stadium |
Surface | string | 50 | Yes | No | Yes | The playing surface of the stadium (Grass, Artificial or Dome) |
LeftField | integer | 32 | Yes | No | Yes | The estimated distance between home plate and the left field wall. |
MidLeftField | integer | 32 | Yes | No | Yes | The estimated distance between home plate and the mid left field wall. |
LeftCenterField | integer | 32 | Yes | No | Yes | The estimated distance between home plate and the left center field wall. |
MidLeftCenterField | integer | 32 | Yes | No | Yes | The estimated distance between home plate and the mid left center field wall. |
CenterField | integer | 32 | Yes | No | Yes | The estimated distance between home plate and the center field wall. |
MidRightCenterField | integer | 32 | Yes | No | Yes | The estimated distance between home plate and the mid right center field wall. |
RightCenterField | integer | 32 | Yes | No | Yes | The estimated distance between home plate and the right center field wall. |
MidRightField | integer | 32 | Yes | No | Yes | The estimated distance between home plate and the mid right field wall. |
RightField | integer | 32 | Yes | No | Yes | The estimated distance between home plate and the right field wall. |
GeoLat | decimal | 32 | Yes | No | Yes | The geographic latitude coordinate of this venue. |
GeoLong | decimal | 32 | Yes | No | Yes | The geographic longitude coordinate of this venue. |
Altitude | integer | 32 | Yes | No | Yes | The altitude of the stadium in feet. |
HomePlateDirection | integer | 32 | Yes | No | Yes | 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 | Yes | No | Yes | 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 | CSV | Description |
---|---|---|---|---|---|---|
Season | integer | 32 | No | No | Yes | The MLB regular season for which these totals apply |
SeasonType | integer | 32 | No | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
TeamID | Integer | 32 | No | No | Yes | The unique ID for the team |
Key | string | 10 | No | No | Yes | Whether or not the team is active |
City | string | 50 | Yes | No | Yes | The name of the city |
Name | string | 50 | Yes | No | Yes | The full name of the team |
League | string | 20 | Yes | No | Yes | The league of the team (e.g. American or National) |
Division | string | 20 | Yes | No | Yes | The division of the team (e.g. East, Central, West) |
Wins | integer | 32 | Yes | No | Yes | Regular season wins |
Losses | integer | 32 | Yes | No | Yes | Regular season losses |
Percentage | decimal | 32 | Yes | No | Yes | Winning percentage |
DivisionWins | integer | 32 | Yes | No | Yes | Regular season wins within the division |
DivisionLosses | integer | 32 | Yes | No | Yes | Regular season losses within the division |
GamesBehind
from 2012 |
decimal | 32 | Yes | No | Yes | Number of games behind the first place team |
LastTenGamesWins
from 2012 |
integer | 32 | Yes | No | Yes | Number of wins in the last ten games |
LastTenGamesLosses
from 2012 |
integer | 32 | Yes | No | Yes | Number of losses in the last ten games |
Streak
from 2012 |
string | 10 | Yes | No | Yes | Current streak the team is on (e.g. Win 3, Lost 3) |
LeagueRank | integer | 32 | Yes | No | Yes | The ranking in the league |
DivisionRank | integer | 32 | Yes | No | Yes | The ranking in the division |
WildCardRank
from 2012 |
integer | 32 | Yes | No | Yes | The ranking in the wild card |
WildCardGamesBehind
from 2012 |
decimal | 32 | Yes | No | Yes | Number of games behind the team leading the wild card |
HomeWins
from 2012 |
integer | 32 | Yes | No | Yes | Number of home wins |
HomeLosses
from 2012 |
integer | 32 | Yes | No | Yes | Number of home losses |
AwayWins
from 2012 |
integer | 32 | Yes | No | Yes | Number of away wins |
AwayLosses
from 2012 |
integer | 32 | Yes | No | Yes | Number of away losses |
DayWins
from 2012 |
integer | 32 | Yes | No | Yes | Number of wins during the day |
DayLosses
from 2012 |
integer | 32 | Yes | No | Yes | Number of losses during the day |
NightWins
from 2012 |
integer | 32 | Yes | No | Yes | Number of wins at night |
NightLosses
from 2012 |
integer | 32 | Yes | No | Yes | Number of losses at night |
RunsScored
from 2012 |
integer | 32 | Yes | No | Yes | Number of runs scored |
RunsAgainst
from 2012 |
integer | 32 | Yes | No | Yes | Number of runs scored by opponents |
GlobalTeamID | integer | 32 | Yes | No | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
StartingLineups
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
GameID
from 2021 |
integer | 32 | No | No | Yes | Unique ID of Game |
Season
from 2021 |
integer | 32 | No | No | Yes | End year of season that this game belongs to |
SeasonType
from 2021 |
integer | 32 | No | No | Yes | Type of Season that this game corresponds to (eg. 1 = Regular Season, 2 = Preseason, 3 = Postseason) |
Day
from 2021 |
datetime | 32 | Yes | No | Yes | Day of Game |
DateTime
from 2021 |
datetime | 32 | Yes | No | Yes | Date and Time of Game |
Status
from 2021 |
string | 32 | Yes | No | Yes | Game Status (eg. Scheduled, Final, Cancelled) |
HomeTeamID
from 2021 |
integer | 32 | Yes | No | Yes | Unique ID of Home Team |
HomeTeam
from 2021 |
string | 32 | Yes | No | Yes | Name of Home Team |
AwayTeamID
from 2021 |
integer | 32 | Yes | No | Yes | Unique ID of Away Team |
AwayTeam
from 2021 |
string | 32 | Yes | No | Yes | Name of Away Team |
HomeStartingPitcher
from 2021 |
Lineup | 32 | Yes | No | Yes | Home Team Starting Pitcher |
HomeBattingLineup
from 2021 |
Lineup[] | 32 | Yes | No | Yes | Home Team Batting Lineup |
AwayStartingPitcher
from 2021 |
Lineup | 32 | Yes | No | Yes | Away Team Starting Pitcher |
AwayBattingLineup
from 2021 |
Lineup[] | 32 | Yes | No | Yes | Away Team Batting Lineup |
HomeTeamOpener | boolean | Yes | No | Yes | Indicates whether the home team will utilize their bullpen instead of a dedicated starting pitcher | |
AwayTeamOpener | boolean | Yes | No | Yes | Indicates whether the away team will utilize their bullpen instead of a dedicated starting pitcher |
Team
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
TeamID | integer | 32 | No | No | Yes | The auto-generated unique ID of the Team |
[Key] | string | 10 | No | No | Yes | Abbreviation of the team (e.g. LAD, PHI, BOS, CHC, etc.) |
Active | boolean | No | No | Yes | Whether or not this team is active | |
City | string | 50 | Yes | No | Yes | The city/location of the team (e.g. Los Angeles, Philadelphia, Boston, Chicago, etc.) |
Name | string | 50 | Yes | No | Yes | The mascot of the team (e.g. Dodgers, Phillies, Red Sox, Cubs, etc.) |
StadiumID | integer | 32 | Yes | No | Yes | The unique ID of the team's current home stadium |
League | string | 10 | Yes | No | Yes | The league of the team (possible values: AL, NL) |
Division | string | 10 | Yes | No | Yes | The division of the team (possible values East, Central, or West) |
PrimaryColor | string | 6 | Yes | No | Yes | The team's primary color. (This is not licensed for public or commercial use) |
SecondaryColor | string | 6 | Yes | No | Yes | The team's secondary color. (This is not licensed for public or commercial use) |
TertiaryColor | string | 6 | Yes | No | Yes | The team's tertiary color. (This is not licensed for public or commercial use) |
QuaternaryColor | string | 6 | Yes | No | Yes | The team's quaternary color. (This is not licensed for public or commercial use) |
WikipediaLogoUrl | string | 250 | Yes | No | Yes | The link to the team's logo hosted on Wikipedia. (This is not licensed for public or commercial use) |
WikipediaWordMarkUrl | string | 250 | Yes | No | Yes | The link to the team's wordmark logo hosted on Wikipedia. (This is not licensed for public or commercial use) |
GlobalTeamID | integer | 32 | No | No | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
HeadCoach | string | 50 | Yes | No | Yes | The current head coach of the team |
HittingCoach | string | 50 | Yes | No | Yes | The current hitting coach of the team |
PitchingCoach | string | 50 | Yes | No | Yes | The current pitching coach of the team |
TeamDepthChart
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
DepthCharts
from 2022 |
DepthChart[] | 32 | Yes | No | Yes | List of Depth Chart Records for Team |
TeamID
from 2022 |
integer | 32 | No | No | Yes | Unique ID of Team |
TeamGame
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
StatID | integer | 32 | No | No | Yes | The unique ID of the stat |
TeamID | integer | 32 | Yes | No | Yes | The unique ID of the team |
SeasonType | integer | 32 | Yes | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
Season | integer | 32 | Yes | No | Yes | The MLB season of the game |
Name | string | 50 | Yes | No | Yes | Team's name |
Team | string | 10 | Yes | No | Yes | The abbreviation of the Team |
GlobalTeamID | integer | 32 | Yes | No | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
GameID | integer | 32 | Yes | No | Yes | The unique ID of this game |
OpponentID | integer | 32 | Yes | No | Yes | The unique ID of the team's opponent |
Opponent | string | 10 | Yes | No | Yes | The name of the opponent |
Day | date | Yes | No | Yes | The day of the game | |
DateTime | datetime | Yes | No | Yes | The date and time of the game | |
HomeOrAway | string | 4 | Yes | No | Yes | Whether the team is home or away |
IsGameOver | boolean | No | No | Yes | Whether the game is over (true/false) | |
GlobalGameID | integer | 32 | Yes | No | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
GlobalOpponentID | integer | 32 | Yes | No | Yes | A globally unique ID for this opponent. This value is guaranteed to be unique across all sports/leagues. |
Updated | datetime | Yes | No | Yes | The timestamp of when the record was last updated (US Eastern Time). | |
Games | integer | 32 | Yes | No | Yes | The number of games played. |
FantasyPoints | decimal | 32 | Yes | Yes | Yes | Total fantasy points |
AtBats | decimal | 32 | Yes | Yes | Yes | At bats while hitting |
Runs | decimal | 32 | Yes | Yes | Yes | Total runs scored. |
Hits | decimal | 32 | Yes | Yes | Yes | Total hits |
Singles | decimal | 32 | Yes | Yes | Yes | Total singles |
Doubles | decimal | 32 | Yes | Yes | Yes | Total doubles |
Triples | decimal | 32 | Yes | Yes | Yes | Total triples |
HomeRuns | decimal | 32 | Yes | Yes | Yes | Total home runs |
RunsBattedIn | decimal | 32 | Yes | Yes | Yes | Total runs batted in |
BattingAverage | decimal | 32 | Yes | Yes | Yes | Total batting average |
Outs | decimal | 32 | Yes | Yes | Yes | Total outs |
Strikeouts | decimal | 32 | Yes | Yes | Yes | Total strikeouts |
Walks | decimal | 32 | Yes | Yes | Yes | Total walks |
HitByPitch | decimal | 32 | Yes | Yes | Yes | Total times hit by pitch |
Sacrifices | decimal | 32 | Yes | Yes | Yes | Total sacrifices |
SacrificeFlies | decimal | 32 | Yes | Yes | Yes | Total sacrifice flies |
GroundIntoDoublePlay | decimal | 32 | Yes | Yes | Yes | Total times grounded into double play |
StolenBases | decimal | 32 | Yes | Yes | Yes | Total stolen bases |
CaughtStealing | decimal | 32 | Yes | Yes | Yes | Total caught stealing |
PitchesSeen | decimal | 32 | Yes | Yes | Yes | Total pitches seen |
OnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total on base percentage |
SluggingPercentage | decimal | 32 | Yes | Yes | Yes | Total slugging percentage |
OnBasePlusSlugging | decimal | 32 | Yes | Yes | Yes | Total on base plus percentage |
Errors | decimal | 32 | Yes | Yes | Yes | Total errors |
Wins | decimal | 32 | Yes | Yes | Yes | Total wins by the team/player |
Losses | decimal | 32 | Yes | Yes | Yes | Total losses by the team/player |
Saves | decimal | 32 | Yes | Yes | Yes | Total saves by team/player |
InningsPitchedDecimal | decimal | 32 | Yes | Yes | Yes | Decimal representation of total innings pitched (e.g. 1.33, 7.66, etc) |
TotalOutsPitched | decimal | 32 | Yes | Yes | Yes | Total outs pitched by team/player |
InningsPitchedFull | decimal | 32 | Yes | Yes | Yes | Total full innings pitched (e.g. 6, 71, 89, etc) |
InningsPitchedOuts | decimal | 32 | Yes | Yes | Yes | Outs pitched beyond InningsPitchedFull (possible values: 0, 1, 2) |
EarnedRunAverage | decimal | 32 | Yes | Yes | Yes | Total earned run average by team/player |
PitchingHits | decimal | 32 | Yes | Yes | Yes | Hits allowed while pitching |
PitchingRuns | decimal | 32 | Yes | Yes | Yes | Runs allowed while pitching |
PitchingEarnedRuns | decimal | 32 | Yes | Yes | Yes | Earned runs allowed while pitching |
PitchingWalks | decimal | 32 | Yes | Yes | Yes | Walks allowed while pitching |
PitchingStrikeouts | decimal | 32 | Yes | Yes | Yes | Strikeouts allowed while pitching |
PitchingHomeRuns | decimal | 32 | Yes | Yes | Yes | Home runs allowed while pitching |
PitchesThrown | decimal | 32 | Yes | Yes | Yes | Total pitches thrown while pitching |
PitchesThrownStrikes | decimal | 32 | Yes | Yes | Yes | Total pitches thrown for strikes while pitching |
WalksHitsPerInningsPitched | decimal | 32 | Yes | Yes | Yes | Walks plus hits per innings pitched (WHIP) while pitching |
PitchingBattingAverageAgainst | decimal | 32 | Yes | Yes | Yes | Total batting average against (BAA) while pitching |
GrandSlams | decimal | 32 | Yes | Yes | Yes | Total grand slams |
FantasyPointsFanDuel | decimal | 32 | Yes | Yes | Yes | Total FanDuel fantasy points |
FantasyPointsDraftKings | decimal | 32 | Yes | Yes | Yes | Total DraftKings fantasy points |
FantasyPointsYahoo | decimal | 32 | Yes | Yes | Yes | Total Yahoo fantasy points |
PlateAppearances | decimal | 32 | Yes | Yes | Yes | Total plate appearances |
TotalBases | decimal | 32 | Yes | Yes | Yes | Number of total bases |
FlyOuts | decimal | 32 | Yes | Yes | Yes | Total fly outs |
GroundOuts | decimal | 32 | Yes | Yes | Yes | Total ground outs |
LineOuts | decimal | 32 | Yes | Yes | Yes | Total line outs |
PopOuts | decimal | 32 | Yes | Yes | Yes | Total pop outs |
IntentionalWalks | decimal | 32 | Yes | Yes | Yes | Total intentional walks |
ReachedOnError | decimal | 32 | Yes | Yes | Yes | Total times reached on error |
BallsInPlay | decimal | 32 | Yes | Yes | Yes | Total balls in play |
BattingAverageOnBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total batting average on balls in play (BABIP) |
WeightedOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total weight on base percentage |
PitchingSingles | decimal | 32 | Yes | Yes | Yes | Total singles allowed while pitching |
PitchingDoubles | decimal | 32 | Yes | Yes | Yes | Total doubles allowed while pitching |
PitchingTriples | decimal | 32 | Yes | Yes | Yes | Total triples allowed while pitching |
PitchingGrandSlams | decimal | 32 | Yes | Yes | Yes | Total grand slams allowed while pitching |
PitchingHitByPitch | decimal | 32 | Yes | Yes | Yes | Total batters hit by pitch while pitching |
PitchingSacrifices | decimal | 32 | Yes | Yes | Yes | Total sacrifices while pitching |
PitchingSacrificeFlies | decimal | 32 | Yes | Yes | Yes | Total sacrifice flies while pitching |
PitchingGroundIntoDoublePlay | decimal | 32 | Yes | Yes | Yes | Total grounded into double plays while pitching |
PitchingCompleteGames | decimal | 32 | Yes | Yes | Yes | Total complete games while pitching |
PitchingShutOuts | decimal | 32 | Yes | Yes | Yes | Total shuouts while pitching |
PitchingNoHitters | decimal | 32 | Yes | Yes | Yes | Total no hitters while pitching |
PitchingPerfectGames | decimal | 32 | Yes | Yes | Yes | Total perfect games while pitching |
PitchingPlateAppearances | decimal | 32 | Yes | Yes | Yes | Total plate appearances while pitching |
PitchingTotalBases | decimal | 32 | Yes | Yes | Yes | Total bases while pitching |
PitchingFlyOuts | decimal | 32 | Yes | Yes | Yes | Total fly outs while pitching |
PitchingGroundOuts | decimal | 32 | Yes | Yes | Yes | Total ground outs while pitching |
PitchingLineOuts | decimal | 32 | Yes | Yes | Yes | Total line outs while pitching |
PitchingPopOuts | decimal | 32 | Yes | Yes | Yes | Total pop outs while pitching |
PitchingIntentionalWalks | decimal | 32 | Yes | Yes | Yes | Total intentional walks while pitching |
PitchingReachedOnError | decimal | 32 | Yes | Yes | Yes | Total times reached on error while pitching |
PitchingCatchersInterference | decimal | 32 | Yes | Yes | Yes | Total catchers interference while pitching |
PitchingBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total balls in play while pitching |
PitchingOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total on base percentage (OBP) while pitching |
PitchingSluggingPercentage | decimal | 32 | Yes | Yes | Yes | Total slugging percentage (SLG) while pitching |
PitchingOnBasePlusSlugging | decimal | 32 | Yes | Yes | Yes | Total on base plus slugging (OPS) while pitching |
PitchingStrikeoutsPerNineInnings | decimal | 32 | Yes | Yes | Yes | Total strikeouts per nine innings (K/9) while pitching |
PitchingWalksPerNineInnings | decimal | 32 | Yes | Yes | Yes | Total walks per nine innings (BB/9) while pitching |
PitchingBattingAverageOnBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total batting average on balls in play (BABIP) while pitching |
PitchingWeightedOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total weighted on base percentage while pitching |
DoublePlays | decimal | 32 | Yes | Yes | 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 | Yes | Yes | Yes | Total double plays while pitching |
BattingOrderConfirmed | boolean | Yes | Yes | Yes | Whether the batting order is confirmed (true/false) | |
IsolatedPower | decimal | 32 | Yes | Yes | Yes | Total isolated power (ISO) |
FieldingIndependentPitching | decimal | 32 | Yes | Yes | Yes | Total fielding independent pitching (FIP) |
PitchingQualityStarts | decimal | 32 | Yes | Yes | Yes | Total quality starts pitched |
PitchingInningStarted | integer | 32 | Yes | Yes | Yes | The inning that the pitcher entered the game (if any). |
LeftOnBase
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total left on base percentage |
PitchingHolds
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total holds pitched |
PitchingBlownSaves
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total blown saves pitched |
SubstituteBattingOrder
from 2017 |
integer | 32 | Yes | Yes | 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 | Yes | Yes | Yes | The sequence in which this player was substituted into the game, within the particular batting order |
FantasyPointsFantasyDraft | decimal | 32 | Yes | Yes | Yes | Total FantasyDraft fantasy points |
FantasyPointsBatting | decimal | 32 | Yes | No | Yes | Total batting fantasy points |
FantasyPointsPitching | decimal | 32 | Yes | No | Yes | Total pitching fantasy points |
TeamGameTrends
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
Scope
from 2020 |
string | 50 | No | No | Yes | The type of Trend (e.g. Last 5 games, Last 10 games, Last 5 home games, etc.) |
TeamID
from 2020 |
integer | 32 | No | No | Yes | The auto-generated unique ID of the Team |
Team
from 2020 |
string | 50 | No | No | Yes | Abbreviation of the Team (e.g. LAD, PHI, BOS, CHC, etc.) |
OpponentID
from 2020 |
integer | 32 | Yes | No | Yes | The auto-generated unique ID of the Opponent Team |
Opponent
from 2020 |
string | 50 | Yes | No | Yes | Abbreviation of the Opponent Team (e.g. LAD, PHI, BOS, CHC, etc.) |
Wins
from 2020 |
integer | 32 | No | Yes | Yes | Wins relating to the scope |
Losses
from 2020 |
integer | 32 | No | Yes | Yes | Losses relating to the scope |
Ties
from 2020 |
integer | 32 | No | Yes | Yes | Ties relating to the scope |
WinsAgainstTheSpread
from 2020 |
integer | 32 | Yes | Yes | Yes | Wins against the spread relating to the scope |
LossesAgainstTheSpread
from 2020 |
integer | 32 | Yes | Yes | Yes | Losses against the spread relating to the scope |
PushesAgainstTheSpread
from 2020 |
integer | 32 | Yes | Yes | Yes | Pushes against the spread relating to the scope |
Overs
from 2020 |
integer | 32 | Yes | Yes | Yes | Amount of times the total score goes over the OverUnder |
Unders
from 2020 |
integer | 32 | Yes | Yes | Yes | Amount of times the total score goes under the OverUnder |
OverUnderPushes
from 2020 |
integer | 32 | Yes | Yes | Yes | Amount of times the total score pushes the OverUnder |
AverageScore
from 2020 |
decimal | 32 | Yes | Yes | Yes | Average score of team |
AverageOpponentScore
from 2020 |
decimal | 32 | Yes | Yes | Yes | Average score of opponent |
TeamSeason
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
StatID | integer | 32 | No | No | Yes | The unique ID of the stat |
TeamID | integer | 32 | Yes | No | Yes | The unique ID of the team |
SeasonType | integer | 32 | Yes | No | Yes | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 4=Offseason, 5=AllStar). |
Season | integer | 32 | Yes | No | Yes | The MLB regular season for which these totals apply |
Name | string | 50 | Yes | No | Yes | Team name |
Team | string | 10 | Yes | No | Yes | The abbreviation of the Team |
GlobalTeamID | integer | 32 | Yes | No | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
Updated | datetime | Yes | No | Yes | The timestamp of when the record was last updated (US Eastern Time). | |
Games | integer | 32 | Yes | No | Yes | The number of games played. |
FantasyPoints | decimal | 32 | Yes | Yes | Yes | Total fantasy points |
AtBats | decimal | 32 | Yes | Yes | Yes | At bats while hitting |
Runs | decimal | 32 | Yes | Yes | Yes | Total runs scored. |
Hits | decimal | 32 | Yes | Yes | Yes | Total hits |
Singles | decimal | 32 | Yes | Yes | Yes | Total singles |
Doubles | decimal | 32 | Yes | Yes | Yes | Total doubles |
Triples | decimal | 32 | Yes | Yes | Yes | Total triples |
HomeRuns | decimal | 32 | Yes | Yes | Yes | Total home runs |
RunsBattedIn | decimal | 32 | Yes | Yes | Yes | Total runs batted in |
BattingAverage | decimal | 32 | Yes | Yes | Yes | Total batting average |
Outs | decimal | 32 | Yes | Yes | Yes | Total outs |
Strikeouts | decimal | 32 | Yes | Yes | Yes | Total strikeouts |
Walks | decimal | 32 | Yes | Yes | Yes | Total walks |
HitByPitch | decimal | 32 | Yes | Yes | Yes | Total times hit by pitch |
Sacrifices | decimal | 32 | Yes | Yes | Yes | Total sacrifices |
SacrificeFlies | decimal | 32 | Yes | Yes | Yes | Total sacrifice flies |
GroundIntoDoublePlay | decimal | 32 | Yes | Yes | Yes | Total times grounded into double play |
StolenBases | decimal | 32 | Yes | Yes | Yes | Total stolen bases |
CaughtStealing | decimal | 32 | Yes | Yes | Yes | Total caught stealing |
PitchesSeen | decimal | 32 | Yes | Yes | Yes | Total pitches seen |
OnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total on base percentage |
SluggingPercentage | decimal | 32 | Yes | Yes | Yes | Total slugging percentage |
OnBasePlusSlugging | decimal | 32 | Yes | Yes | Yes | Total on base plus percentage |
Errors | decimal | 32 | Yes | Yes | Yes | Total errors |
Wins | decimal | 32 | Yes | Yes | Yes | Total wins by the team/player |
Losses | decimal | 32 | Yes | Yes | Yes | Total losses by the team/player |
Saves | decimal | 32 | Yes | Yes | Yes | Total saves by team/player |
InningsPitchedDecimal | decimal | 32 | Yes | Yes | Yes | Decimal representation of total innings pitched (e.g. 1.33, 7.66, etc) |
TotalOutsPitched | decimal | 32 | Yes | Yes | Yes | Total outs pitched by team/player |
InningsPitchedFull | decimal | 32 | Yes | Yes | Yes | Total full innings pitched (e.g. 6, 71, 89, etc) |
InningsPitchedOuts | decimal | 32 | Yes | Yes | Yes | Outs pitched beyond InningsPitchedFull (possible values: 0, 1, 2) |
EarnedRunAverage | decimal | 32 | Yes | Yes | Yes | Total earned run average by team/player |
PitchingHits | decimal | 32 | Yes | Yes | Yes | Hits allowed while pitching |
PitchingRuns | decimal | 32 | Yes | Yes | Yes | Runs allowed while pitching |
PitchingEarnedRuns | decimal | 32 | Yes | Yes | Yes | Earned runs allowed while pitching |
PitchingWalks | decimal | 32 | Yes | Yes | Yes | Walks allowed while pitching |
PitchingStrikeouts | decimal | 32 | Yes | Yes | Yes | Strikeouts allowed while pitching |
PitchingHomeRuns | decimal | 32 | Yes | Yes | Yes | Home runs allowed while pitching |
PitchesThrown | decimal | 32 | Yes | Yes | Yes | Total pitches thrown while pitching |
PitchesThrownStrikes | decimal | 32 | Yes | Yes | Yes | Total pitches thrown for strikes while pitching |
WalksHitsPerInningsPitched | decimal | 32 | Yes | Yes | Yes | Walks plus hits per innings pitched (WHIP) while pitching |
PitchingBattingAverageAgainst | decimal | 32 | Yes | Yes | Yes | Total batting average against (BAA) while pitching |
GrandSlams | decimal | 32 | Yes | Yes | Yes | Total grand slams |
FantasyPointsFanDuel | decimal | 32 | Yes | Yes | Yes | Total FanDuel fantasy points |
FantasyPointsDraftKings | decimal | 32 | Yes | Yes | Yes | Total DraftKings fantasy points |
FantasyPointsYahoo | decimal | 32 | Yes | Yes | Yes | Total Yahoo fantasy points |
PlateAppearances | decimal | 32 | Yes | Yes | Yes | Total plate appearances |
TotalBases | decimal | 32 | Yes | Yes | Yes | Number of total bases |
FlyOuts | decimal | 32 | Yes | Yes | Yes | Total fly outs |
GroundOuts | decimal | 32 | Yes | Yes | Yes | Total ground outs |
LineOuts | decimal | 32 | Yes | Yes | Yes | Total line outs |
PopOuts | decimal | 32 | Yes | Yes | Yes | Total pop outs |
IntentionalWalks | decimal | 32 | Yes | Yes | Yes | Total intentional walks |
ReachedOnError | decimal | 32 | Yes | Yes | Yes | Total times reached on error |
BallsInPlay | decimal | 32 | Yes | Yes | Yes | Total balls in play |
BattingAverageOnBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total batting average on balls in play (BABIP) |
WeightedOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total weight on base percentage |
PitchingSingles | decimal | 32 | Yes | Yes | Yes | Total singles allowed while pitching |
PitchingDoubles | decimal | 32 | Yes | Yes | Yes | Total doubles allowed while pitching |
PitchingTriples | decimal | 32 | Yes | Yes | Yes | Total triples allowed while pitching |
PitchingGrandSlams | decimal | 32 | Yes | Yes | Yes | Total grand slams allowed while pitching |
PitchingHitByPitch | decimal | 32 | Yes | Yes | Yes | Total batters hit by pitch while pitching |
PitchingSacrifices | decimal | 32 | Yes | Yes | Yes | Total sacrifices while pitching |
PitchingSacrificeFlies | decimal | 32 | Yes | Yes | Yes | Total sacrifice flies while pitching |
PitchingGroundIntoDoublePlay | decimal | 32 | Yes | Yes | Yes | Total grounded into double plays while pitching |
PitchingCompleteGames | decimal | 32 | Yes | Yes | Yes | Total complete games while pitching |
PitchingShutOuts | decimal | 32 | Yes | Yes | Yes | Total shuouts while pitching |
PitchingNoHitters | decimal | 32 | Yes | Yes | Yes | Total no hitters while pitching |
PitchingPerfectGames | decimal | 32 | Yes | Yes | Yes | Total perfect games while pitching |
PitchingPlateAppearances | decimal | 32 | Yes | Yes | Yes | Total plate appearances while pitching |
PitchingTotalBases | decimal | 32 | Yes | Yes | Yes | Total bases while pitching |
PitchingFlyOuts | decimal | 32 | Yes | Yes | Yes | Total fly outs while pitching |
PitchingGroundOuts | decimal | 32 | Yes | Yes | Yes | Total ground outs while pitching |
PitchingLineOuts | decimal | 32 | Yes | Yes | Yes | Total line outs while pitching |
PitchingPopOuts | decimal | 32 | Yes | Yes | Yes | Total pop outs while pitching |
PitchingIntentionalWalks | decimal | 32 | Yes | Yes | Yes | Total intentional walks while pitching |
PitchingReachedOnError | decimal | 32 | Yes | Yes | Yes | Total times reached on error while pitching |
PitchingCatchersInterference | decimal | 32 | Yes | Yes | Yes | Total catchers interference while pitching |
PitchingBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total balls in play while pitching |
PitchingOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total on base percentage (OBP) while pitching |
PitchingSluggingPercentage | decimal | 32 | Yes | Yes | Yes | Total slugging percentage (SLG) while pitching |
PitchingOnBasePlusSlugging | decimal | 32 | Yes | Yes | Yes | Total on base plus slugging (OPS) while pitching |
PitchingStrikeoutsPerNineInnings | decimal | 32 | Yes | Yes | Yes | Total strikeouts per nine innings (K/9) while pitching |
PitchingWalksPerNineInnings | decimal | 32 | Yes | Yes | Yes | Total walks per nine innings (BB/9) while pitching |
PitchingBattingAverageOnBallsInPlay | decimal | 32 | Yes | Yes | Yes | Total batting average on balls in play (BABIP) while pitching |
PitchingWeightedOnBasePercentage | decimal | 32 | Yes | Yes | Yes | Total weighted on base percentage while pitching |
DoublePlays | decimal | 32 | Yes | Yes | 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 | Yes | Yes | Yes | Total double plays while pitching |
BattingOrderConfirmed | boolean | Yes | Yes | Yes | Whether the batting order is confirmed (true/false) | |
IsolatedPower | decimal | 32 | Yes | Yes | Yes | Total isolated power (ISO) |
FieldingIndependentPitching | decimal | 32 | Yes | Yes | Yes | Total fielding independent pitching (FIP) |
PitchingQualityStarts | decimal | 32 | Yes | Yes | Yes | Total quality starts pitched |
PitchingInningStarted | integer | 32 | Yes | Yes | Yes | The inning that the pitcher entered the game (if any). |
LeftOnBase
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total left on base percentage |
PitchingHolds
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total holds pitched |
PitchingBlownSaves
from 2017 |
decimal | 32 | Yes | Yes | Yes | Total blown saves pitched |
SubstituteBattingOrder
from 2017 |
integer | 32 | Yes | Yes | 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 | Yes | Yes | Yes | The sequence in which this player was substituted into the game, within the particular batting order |
FantasyPointsFantasyDraft | decimal | 32 | Yes | Yes | Yes | Total FantasyDraft fantasy points |
FantasyPointsBatting | decimal | 32 | Yes | No | Yes | Total batting fantasy points |
FantasyPointsPitching | decimal | 32 | Yes | No | Yes | Total pitching fantasy points |
TeamTrends
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
Team
from 2020 |
string | 50 | Yes | No | Yes | Abbreviation of the team (e.g. LAD, PHI, BOS, CHC, etc.) |
TeamID
from 2020 |
integer | 32 | Yes | No | Yes | The auto-generated unique ID of the Team |
UpcomingGame
from 2020 |
Game | Yes | No | Yes | Upcoming game for this team | |
TeamGameTrends
from 2020 |
TeamGameTrends[] | Yes | No | Yes | The collection of Game Trends for this team |
Transaction
Available Endpoints
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
PlayerID | integer | 32 | No | No | Yes | Unique ID of Player |
Name | string | 32 | No | No | Yes | Player Name |
FormerTeamID | integer | 32 | Yes | No | Yes | ID of Player's former team |
FormerTeam | string | 32 | Yes | No | Yes | Player's former team in abbreviated format (e.g. SD, PHI, LAD, ATL etc.) |
TeamID | integer | 32 | Yes | No | Yes | Unique ID of the former team. |
Team | string | 32 | Yes | No | Yes | Player's new team, when applicable, in abbreviated format (e.g. SD, PHI, LAD, ATL etc.) |
Type | string | 50 | Yes | No | Yes | Type of Transaction. Released, Waived, Signed, Promoted, Elevated, Demoted, and Traded. |
Date | datetime | 32 | Yes | No | Yes | Date and Time Transaction took place |
Note | string | 100 | Yes | No | Yes | Transaction Summary (e.g. "Harris has signed with the Commanders.") |
Created | datetime | 32 | Yes | No | Yes | Date and Time Created |
Updated | datetime | 32 | Yes | No | Yes | Date and Time Last Updated |