Developer Portal
{{ 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.
BettingEntityMetadata
This table is used in the following endpoints:
NHL v3 Odds
Betting Metadata
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
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 BettingMarketTypes (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[] | 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 the possible BettingResultTypes (e.g. Won, Lost, Push) |
BettingEvent
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
This table is used in the following endpoints:
NHL v3 Odds
Betting Events by Date,
Betting Events by Season,
Betting Futures by Season,
Betting Market,
Betting Markets by Event,
Betting Markets by GameID,
Betting Markets by Market Type,
Betting Player Props by GameID
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 |
BettingMarketResult
This table is used in the following endpoints:
NHL v3 Odds
Betting Results By Market
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
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
BettingMarketID
from 2021 |
integer | 32 | No | No | Yes | Unique ID of Betting Market |
BettingEventID
from 2021 |
integer | 32 | No | No | Yes | Unique ID of associated Betting Event |
BettingMarketTypeID
from 2021 |
integer | 32 | No | No | Yes | Market Type ID (e.g. 1 => Game Line) |
BettingMarketType
from 2021 |
string | 100 | No | No | Yes | Name of Market Type |
BettingBetTypeID
from 2021 |
integer | 32 | No | No | Yes | Bet Type ID (e.g. 1 => Puck Line) |
BettingBetType
from 2021 |
string | 100 | No | No | Yes | Name of Bet Type |
BettingPeriodTypeID
from 2021 |
integer | 32 | No | No | Yes | Betting Period Type ID (e.g. 1 => Full Game) |
BettingPeriodType
from 2021 |
string | 100 | No | No | Yes | Name of Betting Period |
TeamID
from 2021 |
integer | 32 | Yes | No | Yes | ID of associated Team |
TeamKey
from 2021 |
string | 32 | Yes | No | Yes | Short Team Name |
PlayerID
from 2021 |
integer | 32 | Yes | No | Yes | ID of associated Team |
PlayerName
from 2021 |
string | 100 | Yes | No | Yes | Name of Player |
BettingSplits
from 2021 |
BettingSplit[] | 32 | No | No | Yes | List of Splits |
BettingOutcome
This table is used in the following endpoints:
NHL v3 Odds
Betting Events by Date,
Betting Events by Season,
Betting Futures by Season,
Betting Market,
Betting Markets by Event,
Betting Markets by GameID,
Betting Markets by Market Type,
Betting Player Props by GameID
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 of the given sportsbook when available for deep links |
SportsbookOutcomeID | string | 100 | Yes | Yes | No | The outcome ID of the given sportsbook when available for deep links |
BettingOutcomeResult
This table is used in the following endpoints:
NHL v3 Odds
Betting Results By Market
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, Void) |
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
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
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
BettingMarketSplitID
from 2021 |
integer | 32 | No | No | Yes | Unique ID of this Split instance |
BettingMarketID
from 2021 |
integer | 32 | No | No | Yes | ID of associated Betting Market |
BettingOutcomeTypeID
from 2021 |
integer | 32 | Yes | No | Yes | ID of associated Betting Outcome Type |
BettingOutcomeType
from 2021 |
string | 32 | Yes | No | Yes | Name of Betting Outcome Type (e.g. Home, Away, Under, Over) |
BetPercentage
from 2021 |
integer | 32 | Yes | Yes | Yes | Percent of Bets Placed on this Outcome |
MoneyPercentage
from 2021 |
integer | 32 | Yes | Yes | Yes | Percent of Money on this Outcome |
Created
from 2021 |
datetime | 32 | No | No | Yes | When this split was first seen |
LastSeen
from 2021 |
datetime | 32 | No | No | Yes | When this split was last updated |
BoxScore
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 | |
Periods | Period[] | Yes | No | Yes | The details of the periods 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 | |
ShootoutPlays | Play[] | Yes | No | Yes | The details of any shootout plays associated with this box score |
ConsensusOutcome
This table is used in the following endpoints:
NHL v3 Odds
Betting Events by Date,
Betting Events by Season,
Betting Futures by Season,
Betting Market,
Betting Markets by Event,
Betting Markets by GameID,
Betting Markets by Market Type,
Betting Player Props by GameID
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 of the given sportsbook when available for deep links |
SportsbookOutcomeID | string | 100 | Yes | Yes | No | The outcome ID of the given sportsbook when available for deep links |
DfsSlate
This table is used in the following endpoints:
NHL v3 Projections
DFS Slates by Date
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
This table is used in the following endpoints:
NHL v3 Projections
DFS Slates by Date
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 player was removed/deleted by the operator. |
DfsSlatePlayer
This table is used in the following endpoints:
NHL v3 Projections
DFS Slates by Date
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 | The team the player plays for |
TeamID | integer | 32 | Yes | No | Yes | The TeamID of the team the player plays for |
Game
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 NHL 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, F/SO, F/OT, Suspended, Postponed, Delayed, 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 | |
Updated | datetime | Yes | No | Yes | The timestamp of when the record was last updated (US Eastern Time). | |
IsClosed | boolean | Yes | No | Yes | Indicates whether the game is over and the final score has been verified and closed out. | |
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 |
StadiumID | integer | 32 | Yes | No | Yes | The unique ID of the stadium |
Channel | string | 10 | Yes | No | Yes | The television station broadcasting the game |
Attendance | integer | 32 | Yes | No | Yes | Total number of people who attended the game |
AwayTeamScore | integer | 32 | Yes | Yes | Yes | Number of goals the away team scored in this game |
HomeTeamScore | integer | 32 | Yes | Yes | Yes | Number of goals the home team scored in this game |
Period | string | 10 | Yes | No | Yes | Indicated the current period of the game. Possible values include: 1, 2, 3, OT, SO, Final, F/OT, F/SO, NULL |
TimeRemainingMinutes | integer | 32 | Yes | No | Yes | Number of minutes remaining in the current period. Possible values: 0-20. |
TimeRemainingSeconds | integer | 32 | Yes | No | Yes | Number of seconds remaining in the current period. Possible values: 0-59. |
AwayTeamMoneyLine
from 2016 |
integer | 32 | Yes | Yes | Yes | Money line from the perspective of the away team. |
HomeTeamMoneyLine
from 2016 |
integer | 32 | Yes | Yes | Yes | Money line from the perspective of the home team. |
PointSpread
from 2017 |
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 2017 |
decimal | 32 | Yes | Yes | Yes | The oddsmaker Over/Under at game start. This is updated once daily at 4:00 AM ET. |
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 | No | Yes | The description of the most recent play/event of the game. This is for display purposes and does not include corresponding data points. |
Periods | Period[] | Yes | No | Yes | The details of the periods (including overtime if applicable) for this game. | |
GameEndDateTime | datetime | Yes | No | Yes | The date and time that the game ended in US Eastern Time | |
HomeRotationNumber | integer | 32 | Yes | Yes | Yes | The rotation number of the home team for this game |
AwayRotationNumber | integer | 32 | Yes | Yes | Yes | The rotation number of the away team for this game |
NeutralVenue
from 2020 |
boolean | Yes | No | Yes | Indicates whether this game is played in a neutral venue | |
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 |
DateTimeUTC
from 2021 |
datetime | Yes | No | Yes | The date and time of the game in UTC | |
SeriesInfo
from 2021 |
Series | 32 | Yes | No | Yes | Contains relevant series data for playoff series only - HomeTeamWins, AwayTeamWins, GameNumber, and MaxLength |
GameBettingSplit
This table is used in the following endpoints:
NHL v3 Odds
Betting Splits By GameID
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
GameID
from 2021 |
integer | 32 | No | No | Yes | Unique Game ID associated with relevant game. |
SeasonType
from 2021 |
integer | 32 | No | No | Yes | Season Type (e.g. Preseason, Regular Season, Postseason) |
Season
from 2021 |
integer | 32 | No | No | Yes | End Year of Season (2021-22 would be 2022) |
Day
from 2021 |
datetime | 32 | Yes | No | Yes | Day of Game |
AwayTeam
from 2021 |
string | 32 | Yes | No | Yes | Away Team |
HomeTeam
from 2021 |
string | 32 | Yes | No | Yes | Home Team |
BettingMarketSplits
from 2021 |
BettingMarketSplit[] | 32 | No | No | Yes | The Betting Markets included in this game that have splits |
GameInfo
This table is used in the following endpoints:
NHL v3 Odds
In-Game Odds by Date,
In-Game Odds Line Movement,
Pre-Game Odds by Date,
Pre-Game Odds Line Movement,
Period Game Odds by Date,
Period Game Odds Line Movement
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, F/SO, F/OT, Suspended, Postponed, Delayed, Canceled, Forfeit |
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 | The rotation number of the home team for this game |
AwayRotationNumber | integer | 32 | Yes | Yes | Yes | The rotation number of the away team for this game |
AlternateMarketPregameOdds | GameOdd[] | Yes | No | Yes | List of Alternate Market Pregame GameOdds from different sportsbooks (ex 1st-pd, 2nd-pd, etc) |
GameOdd
This table is used in the following endpoints:
NHL v3 Odds
In-Game Odds by Date,
In-Game Odds Line Movement,
Pre-Game Odds by Date,
Pre-Game Odds Line Movement,
Period Game Odds by Date,
Period Game Odds Line Movement
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 |
OddType | string | 32 | Yes | No | Yes | The market type of the odd (ex: live, pregame, 1st-pd, etc) |
SportsbookUrl | string | 500 | Yes | No | Yes | The URL for sportsbook event |
Goaltender
This table is used in the following endpoints:
NHL v3 Projections
Starting Goaltenders by Date
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 | Goaltender First Name |
LastName
from 2021 |
string | 32 | No | No | Yes | Goaltender Last Name |
Jersey
from 2021 |
integer | 32 | Yes | Yes | Yes | Goaltender Jersey Number |
Confirmed
from 2021 |
bool | 32 | No | No | Yes | Indicates whether the starting goaltender is projected or confirmed |
Headshot
This table is used in the following endpoints:
NHL v3 Headshots
Headshots
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. |
MatchupTrends
This table is used in the following endpoints:
NHL v3 Odds
Betting Trends by Matchup
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
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 |
PlayerID | integer | 32 | Yes | No | Yes | Unique ID assigned to each player that stays with them throughout their career |
TeamID | integer | 32 | Yes | No | Yes | The unique ID of the team |
Team | string | 50 | Yes | No | Yes | The abbreviation of the Team |
Title | string | 50 | Yes | No | Yes | The brief title of the news (typically less than 100 characters) |
Content | string | 50 | Yes | No | Yes | The full body content of the story |
Url | string | 250 | Yes | No | Yes | The url of the full story |
Source | string | 50 | Yes | No | Yes | The source of the story (RotoBaller, NBCSports.com, etc.) |
TermsOfUse | string | 50 | 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 |
Updated | date | Yes | No | Yes | The date the news story was updated |
OpponentSeason
This table is used in the following endpoints:
NHL v3 Scores
Team Season Stats
NHL v3 Stats
Team Stats Allowed by Position
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 NHL 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 |
Wins | integer | 10 | Yes | No | Yes | Total number of wins |
Losses | integer | 10 | Yes | No | Yes | Total number of losses |
OvertimeLosses | integer | 10 | Yes | No | Yes | Total number of overtime losses |
OpponentPosition | string | 10 | Yes | No | Yes | Indicates which position is included in opponent stats that are aggregated together |
GlobalTeamID | integer | 32 | Yes | No | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
OpponentStat | OpponentSeason | Yes | No | Yes | The aggregated season stats for this team's opponents | |
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 |
FantasyPointsFanDuel | decimal | 32 | Yes | Yes | Yes | Total FanDuel daily fantasy points scored |
FantasyPointsDraftKings | decimal | 32 | Yes | Yes | Yes | Total DraftKings daily fantasy points scored |
FantasyPointsYahoo | decimal | 32 | Yes | Yes | Yes | Total Yahoo daily fantasy points scored |
Minutes | integer | 32 | Yes | Yes | Yes | Total number of minutes played |
Seconds | integer | 32 | Yes | Yes | Yes | Total number of seconds played |
Goals | decimal | 32 | Yes | Yes | Yes | Total number of goals scored |
Assists | decimal | 32 | Yes | Yes | Yes | Total number of assists |
ShotsOnGoal | decimal | 32 | Yes | Yes | Yes | Total number of shots on goal |
PowerPlayGoals | decimal | 32 | Yes | Yes | Yes | Total number of power play goals |
ShortHandedGoals | decimal | 32 | Yes | Yes | Yes | Total number of short handed goals |
EmptyNetGoals | decimal | 32 | Yes | Yes | Yes | Total number of empty net goals |
PowerPlayAssists | decimal | 32 | Yes | Yes | Yes | Total number of power play assists |
ShortHandedAssists | decimal | 32 | Yes | Yes | Yes | Total number of short handed assists |
HatTricks | decimal | 32 | Yes | Yes | Yes | Total number of hat tricks |
ShootoutGoals | decimal | 32 | Yes | Yes | Yes | Total number of shootout goals |
PlusMinus | decimal | 32 | Yes | Yes | Yes | Total plus minus |
PenaltyMinutes | decimal | 32 | Yes | Yes | Yes | Total pentalty minutes |
Blocks | decimal | 32 | Yes | Yes | Yes | Total blocked shots |
Hits | decimal | 32 | Yes | Yes | Yes | Total hits |
Takeaways | decimal | 32 | Yes | Yes | Yes | Total takeaways |
Giveaways | decimal | 32 | Yes | Yes | Yes | Total giveaways |
FaceoffsWon | decimal | 32 | Yes | Yes | Yes | Total faceoffs won |
FaceoffsLost | decimal | 32 | Yes | Yes | Yes | Total faceoffs lost |
Shifts | decimal | 32 | Yes | Yes | Yes | Total shifts |
GoaltendingMinutes | integer | 32 | Yes | Yes | Yes | Total goaltending minutes |
GoaltendingSeconds | integer | 32 | Yes | Yes | Yes | Total goaltending seconds |
GoaltendingShotsAgainst | decimal | 32 | Yes | Yes | Yes | Total goaltending shots against |
GoaltendingGoalsAgainst | decimal | 32 | Yes | Yes | Yes | Total goaltending goals against |
GoaltendingSaves | decimal | 32 | Yes | Yes | Yes | Total goaltending saves |
GoaltendingWins | decimal | 32 | Yes | Yes | Yes | Total goaltending wins |
GoaltendingLosses | decimal | 32 | Yes | Yes | Yes | Total goaltendings losses |
GoaltendingShutouts | decimal | 32 | Yes | Yes | Yes | Total goaltendings shutouts |
Started
from 2017 |
integer | 32 | Yes | No | Yes | Total games started |
BenchPenaltyMinutes | decimal | 32 | Yes | Yes | Yes | Total bench pentalty minutes |
GoaltendingOvertimeLosses | decimal | 32 | Yes | Yes | Yes | Total goaltending overtime losses |
FantasyPointsFantasyDraft | decimal | 32 | Yes | Yes | Yes | Total FantasyDraft daily fantasy points scored |
Penalty
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
PenaltyID | integer | 32 | No | No | Yes | The unique ID of this penalty |
PeriodID | integer | 32 | No | No | Yes | The unique ID of the period during which this penalty occurred |
Sequence | integer | 32 | Yes | No | Yes | The sequence/order that this penalty happened |
TimeRemainingMinutes | integer | 32 | Yes | No | Yes | Number of minutes that have passed in the current period. Please note this field name is misleading, and actually represents the game clock minutes, which are the number of minutes that have already passed in the period. Possible values: 0-20. |
TimeRemainingSeconds | integer | 32 | Yes | No | Yes | Number of seconds that have passed in the current period. Please note this field name is misleading, and actually represents the game clock seconds, which are the number of seconds that have already passed in the period. Possible values: 0-60. |
Description | string | 50 | Yes | Yes | Yes | The description of the penalty |
PenaltyMinutes | integer | 32 | Yes | No | Yes | The number of minutes the penalty lasts |
PenalizedTeamID | integer | 32 | Yes | Yes | Yes | The TeamID of the penalized team |
PenalizedPlayerID | integer | 32 | Yes | Yes | Yes | The PlayerID who commited the penalty |
DrawnByTeamID | integer | 32 | Yes | Yes | Yes | The TeamID of the team who drew the penalty |
DrawnByPlayerID | integer | 32 | Yes | Yes | Yes | The PlayerID who drew the penalty |
IsBenchPenalty | boolean | Yes | No | Yes | Whether or not the penalty is a bench penalty (true/false) | |
BenchPenaltyServedByPlayerID | integer | 32 | Yes | No | Yes | The PlayerID of the player who served the bench penalty |
Period
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
PeriodID | integer | 32 | No | No | Yes | Unique identifier for each period. |
GameID | integer | 32 | No | No | Yes | The unique ID for this game. |
Name | string | 10 | No | No | Yes | The Name of the Quarter (possible values: 1, 2, 3, SO, OT, OT2, OT3, OT4, etc) |
AwayScore | integer | 32 | Yes | Yes | Yes | The total goals scored by the away team in this period. |
HomeScore | integer | 32 | Yes | Yes | Yes | The total goals scored by the home team in this period. |
ScoringPlays | ScoringPlay[] | Yes | No | Yes | The details of the scoring plays that occurred during this period | |
Penalties | Penalty[] | Yes | No | Yes | The details of the penalties that occurred during this period |
Play
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
PlayID
from 2017 |
integer | 32 | No | No | Yes | The unique identifier of the play. |
PeriodID
from 2017 |
integer | 32 | No | No | Yes | The unique identifier of the Period that this play occurred in. |
PeriodName
from 2017 |
string | 10 | No | No | Yes | The name of the Period that this play occurred in. |
Sequence
from 2017 |
integer | 32 | No | No | Yes | The order in which this play happened over the course of the game. |
ClockMinutes
from 2017 |
integer | 32 | Yes | No | Yes | The number of minutes passed in the Period when this play completed. |
ClockSeconds
from 2017 |
integer | 32 | Yes | No | Yes | The number of seconds passed in the Period when this play completed. |
AwayTeamScore
from 2017 |
integer | 32 | Yes | No | Yes | The score of the away team after this play completed. |
HomeTeamScore
from 2017 |
integer | 32 | Yes | No | Yes | The score of the home team after this play completed. |
TeamID
from 2017 |
integer | 32 | Yes | No | Yes | The TeamID of the team associated with this play. |
Team
from 2017 |
string | 10 | Yes | No | Yes | The Team Key of the team associated with this play. |
OpponentID
from 2017 |
integer | 32 | Yes | No | Yes | The TeamID of the opponent associated with this play. |
Opponent
from 2017 |
string | 10 | Yes | No | Yes | The Team Key of the opponent associated with this play. |
Category
from 2017 |
string | 20 | Yes | Yes | Yes | The category the play. Possible values: Block, Faceoff, Goal, Hit, Penalty, Period, Shootout, Shot, Stoppage, Turnover |
Type
from 2017 |
string | 20 | Yes | Yes | Yes | The type of the play. Possible values: AwayTeamTimeout, Block, Boarding, Charging, CheckToTheHead, Clipping, ClosingHandOnThePuck, CrossChecking, DelayOfGame, Elbowing, Faceoff, Fighting, GameMisconduct, Giveaway, Goal, GoalieStopped, HandPass, HighSticking, HighStickOnPuck, Hit, Holding, HoldingTheStick, HomeTeamTimeout, Hooking, Icing, IllegalEquipment, Interference, Kneeing, MinorPenalty, Misconduct, NetOffPost, ObjectsOnIce, Offside, Period, PeriodEnd, PlayerEquipment, PlayerInjury, PowerPlayGoal, PuckFrozen, PuckInBench, PuckInCrowd, PuckInNetting, Referee, RinkRepair, Roughing, ShootoutGoal, ShootoutMiss, ShootoutSave, ShotMissed, ShotOnGoal, Slashing, Stoppage, Takeaway, TooManyMen, Tripping, TvTimeout, Unsportsmanlike, VideoReview |
Description
from 2017 |
string | 250 | Yes | Yes | Yes | The description of the play (example: Sidney Crosby won faceoff against Nicklas Backstrom) |
PlayerID
from 2017 |
integer | 32 | Yes | Yes | Yes | The PlayerID of the primary player on this play (if any). |
Updated
from 2017 |
datetime | Yes | No | Yes | The database generated timestamp of when this Play was last updated. | |
Created
from 2017 |
datetime | Yes | No | Yes | The database generated timestamp of when this Play was first created. | |
FirstAssistedByPlayerID
from 2017 |
integer | 32 | Yes | Yes | Yes | The PlayerID of the player who got the first assist on this play (if any). |
SecondAssistedByPlayerID
from 2017 |
integer | 32 | Yes | Yes | Yes | The PlayerID of the player who got the second assist on this play (if any). |
PowerPlayTeamID
from 2017 |
integer | 32 | Yes | Yes | Yes | The TeamID of the team on the power play this play (if any). |
PowerPlayTeam
from 2017 |
string | 10 | Yes | Yes | Yes | The TeamKey of the team on the power play this play (if any). |
OpposingPlayerID
from 2017 |
integer | 32 | Yes | Yes | Yes | The PlayerID of the player involved in the play on the opposing team. |
PlayByPlay
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
Game
from 2017 |
Game | Yes | No | Yes | Game Information. | |
Plays
from 2017 |
Play[] | Yes | No | Yes | List of Plays in the game. |
Player
This table is used in the following endpoints:
NHL v3 Scores
Player Details by Active,
Player Details by Free Agent,
Player Details by Player,
Players by Team
NHL v3 Projections
Injured Players
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
PlayerID | integer | 32 | No | No | Yes | The player's unique PlayerID as assigned by SportsDataIO. |
FirstName | string | 50 | Yes | No | Yes | The first name of the player. |
LastName | string | 50 | Yes | No | Yes | The last name of the player. |
Status | string | 10 | Yes | No | Yes | Indicates the player's status of being on an active roster. Possible values include: Active, Inactive |
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. |
Position | string | 10 | Yes | No | Yes | The player's primary position. Possible values: C, RW, LW, D, or G. |
Jersey | integer | 32 | Yes | No | Yes | The player's jersey number. |
Catches | string | 1 | Yes | No | Yes | The hand in which the player catches the puck (right or left). |
Shoots | string | 1 | Yes | No | Yes | The hand the player shoots the puck with (right or left). |
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. |
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 | The player's cross reference PlayerID to the SportRadar API. |
RotoworldPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to the Rotoworld news feed. |
RotoWirePlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to the RotoWire news feed. |
FantasyAlarmPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to the FantasyAlarm news feed. |
StatsPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to the STATS data feeds. |
SportsDirectPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to the SportsDirect data feeds. |
XmlTeamPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to the XML Team data feeds. |
InjuryStatus | string | 50 | Yes | Yes | Yes | Indicates the player's injury status. Possible values include: Probable, Questionable, Doubtful, Out |
InjuryBodyPart | string | 50 | Yes | Yes | Yes | The body part that is injured (Knee, Groin, Calf, Hamstring, etc.) |
InjuryStartDate | date | Yes | No | Yes | The day that the injury started or first discovered. | |
InjuryNotes | string | 250 | Yes | Yes | Yes | Brief description of the player's injury and expected availability. |
FanDuelPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to FanDuel. |
DraftKingsPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to DraftKings. |
YahooPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to Yahoo Daily Fantasy Sports Contests. |
FanDuelName | string | 50 | Yes | No | Yes | The player's full name in FanDuel's daily fantasy sports platform. |
DraftKingsName | string | 50 | Yes | No | Yes | The player's full name in DraftKings' daily fantasy sports platform. |
YahooName | string | 50 | Yes | No | Yes | The player's full name in Yahoo's daily fantasy sports platform. |
DepthChartPosition | string | 10 | Yes | No | Yes | The position of the player on the depth chart. |
DepthChartOrder | integer | 32 | Yes | Yes | Yes | The order of the player on the depth chart. |
GlobalTeamID | integer | 32 | Yes | No | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
FantasyDraftName | string | 50 | Yes | No | Yes | The player's full name in FantasyDraft's daily fantasy sports platform. |
FantasyDraftPlayerID | integer | 32 | Yes | No | Yes | The player's cross reference PlayerID to Fantasy Draft. |
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
This table is used in the following endpoints:
NHL v3 Scores
Players by Team (Basic)
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
PlayerID | integer | 32 | No | No | Yes | The player's unique PlayerID as assigned by SportsDataIO. |
FirstName | string | 50 | Yes | No | Yes | The first name of the player. |
LastName | string | 50 | Yes | No | Yes | The last name of the player. |
Status | string | 10 | Yes | No | Yes | Indicates the player's status of being on an active roster. Possible values include: Active, Inactive |
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. |
Position | string | 10 | Yes | No | Yes | The player's primary position. Possible values: C, RW, LW, D, or G. |
Jersey | integer | 32 | Yes | No | Yes | The player's jersey number. |
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. |
GlobalTeamID | integer | 32 | Yes | No | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
PlayerGame
This table is used in the following endpoints:
NHL v3 Stats
Box Score,
Box Scores by Date,
Box Scores by Date Delta,
Player Game Stats by Date,
Player Game Logs By Season
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 NHL 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: C, RW, LW, D, G |
FantasyDataSalary
from 2016 |
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). |
FanDuelSalary
from 2016 |
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. |
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 |
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 2016 |
integer | 32 | Yes | Yes | Yes | The player's salary for Fantasy Draft daily fantasy contests. |
FantasyDraftPosition
from 2016 |
string | 10 | Yes | Yes | 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 |
FantasyPointsFanDuel | decimal | 32 | Yes | Yes | Yes | Total FanDuel daily fantasy points scored |
FantasyPointsDraftKings | decimal | 32 | Yes | Yes | Yes | Total DraftKings daily fantasy points scored |
FantasyPointsYahoo | decimal | 32 | Yes | Yes | Yes | Total Yahoo daily fantasy points scored |
Minutes | integer | 32 | Yes | Yes | Yes | Total number of minutes played |
Seconds | integer | 32 | Yes | Yes | Yes | Total number of seconds played |
Goals | decimal | 32 | Yes | Yes | Yes | Total number of goals scored |
Assists | decimal | 32 | Yes | Yes | Yes | Total number of assists |
ShotsOnGoal | decimal | 32 | Yes | Yes | Yes | Total number of shots on goal |
PowerPlayGoals | decimal | 32 | Yes | Yes | Yes | Total number of power play goals |
ShortHandedGoals | decimal | 32 | Yes | Yes | Yes | Total number of short handed goals |
EmptyNetGoals | decimal | 32 | Yes | Yes | Yes | Total number of empty net goals |
PowerPlayAssists | decimal | 32 | Yes | Yes | Yes | Total number of power play assists |
ShortHandedAssists | decimal | 32 | Yes | Yes | Yes | Total number of short handed assists |
HatTricks | decimal | 32 | Yes | Yes | Yes | Total number of hat tricks |
ShootoutGoals | decimal | 32 | Yes | Yes | Yes | Total number of shootout goals |
PlusMinus | decimal | 32 | Yes | Yes | Yes | Total plus minus |
PenaltyMinutes | decimal | 32 | Yes | Yes | Yes | Total pentalty minutes |
Blocks | decimal | 32 | Yes | Yes | Yes | Total blocked shots |
Hits | decimal | 32 | Yes | Yes | Yes | Total hits |
Takeaways | decimal | 32 | Yes | Yes | Yes | Total takeaways |
Giveaways | decimal | 32 | Yes | Yes | Yes | Total giveaways |
FaceoffsWon | decimal | 32 | Yes | Yes | Yes | Total faceoffs won |
FaceoffsLost | decimal | 32 | Yes | Yes | Yes | Total faceoffs lost |
Shifts | decimal | 32 | Yes | Yes | Yes | Total shifts |
GoaltendingMinutes | integer | 32 | Yes | Yes | Yes | Total goaltending minutes |
GoaltendingSeconds | integer | 32 | Yes | Yes | Yes | Total goaltending seconds |
GoaltendingShotsAgainst | decimal | 32 | Yes | Yes | Yes | Total goaltending shots against |
GoaltendingGoalsAgainst | decimal | 32 | Yes | Yes | Yes | Total goaltending goals against |
GoaltendingSaves | decimal | 32 | Yes | Yes | Yes | Total goaltending saves |
GoaltendingWins | decimal | 32 | Yes | Yes | Yes | Total goaltending wins |
GoaltendingLosses | decimal | 32 | Yes | Yes | Yes | Total goaltendings losses |
GoaltendingShutouts | decimal | 32 | Yes | Yes | Yes | Total goaltendings shutouts |
Started
from 2017 |
integer | 32 | Yes | No | Yes | Total games started |
BenchPenaltyMinutes | decimal | 32 | Yes | Yes | Yes | Total bench pentalty minutes |
GoaltendingOvertimeLosses | decimal | 32 | Yes | Yes | Yes | Total goaltending overtime losses |
FantasyPointsFantasyDraft | decimal | 32 | Yes | Yes | Yes | Total FantasyDraft daily fantasy points scored |
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. |
Minutes | integer | 32 | Yes | Yes | Yes | Total number of minutes played |
Seconds | integer | 32 | Yes | Yes | Yes | Total number of seconds played |
Goals | decimal | 32 | Yes | Yes | Yes | Total number of goals scored |
Assists | decimal | 32 | Yes | Yes | Yes | Total number of assists |
ShotsOnGoal | decimal | 32 | Yes | Yes | Yes | Total number of shots on goal |
PowerPlayGoals | decimal | 32 | Yes | Yes | Yes | Total number of power play goals |
ShortHandedGoals | decimal | 32 | Yes | Yes | Yes | Total number of short handed goals |
EmptyNetGoals | decimal | 32 | Yes | Yes | Yes | Total number of empty net goals |
PowerPlayAssists | decimal | 32 | Yes | Yes | Yes | Total number of power play assists |
ShortHandedAssists | decimal | 32 | Yes | Yes | Yes | Total number of short handed assists |
HatTricks | decimal | 32 | Yes | Yes | Yes | Total number of hat tricks |
ShootoutGoals | decimal | 32 | Yes | Yes | Yes | Total number of shootout goals |
PlusMinus | decimal | 32 | Yes | Yes | Yes | Total plus minus |
PenaltyMinutes | decimal | 32 | Yes | Yes | Yes | Total pentalty minutes |
Blocks | decimal | 32 | Yes | Yes | Yes | Total blocked shots |
Hits | decimal | 32 | Yes | Yes | Yes | Total hits |
Takeaways | decimal | 32 | Yes | Yes | Yes | Total takeaways |
Giveaways | decimal | 32 | Yes | Yes | Yes | Total giveaways |
FaceoffsWon | decimal | 32 | Yes | Yes | Yes | Total faceoffs won |
FaceoffsLost | decimal | 32 | Yes | Yes | Yes | Total faceoffs lost |
Shifts | decimal | 32 | Yes | Yes | Yes | Total shifts |
GoaltendingMinutes | integer | 32 | Yes | Yes | Yes | Total goaltending minutes |
GoaltendingSeconds | integer | 32 | Yes | Yes | Yes | Total goaltending seconds |
GoaltendingShotsAgainst | decimal | 32 | Yes | Yes | Yes | Total goaltending shots against |
GoaltendingGoalsAgainst | decimal | 32 | Yes | Yes | Yes | Total goaltending goals against |
GoaltendingSaves | decimal | 32 | Yes | Yes | Yes | Total goaltending saves |
GoaltendingWins | decimal | 32 | Yes | Yes | Yes | Total goaltending wins |
GoaltendingLosses | decimal | 32 | Yes | Yes | Yes | Total goaltendings losses |
GoaltendingShutouts | decimal | 32 | Yes | Yes | Yes | Total goaltendings shutouts |
Started | integer | 32 | Yes | No | Yes | Total games started |
BenchPenaltyMinutes | decimal | 32 | Yes | Yes | Yes | Total bench pentalty minutes |
GoaltendingOvertimeLosses | decimal | 32 | Yes | Yes | Yes | Total goaltending overtime losses |
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 NHL 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: C, RW, LW, D, G |
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
This table is used in the following endpoints:
NHL v3 Projections
Projected Player Game Stats by Date (w/ Injuries, DFS Salaries)
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 NHL 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: C, RW, LW, D, G |
FantasyDataSalary
from 2016 |
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). |
FanDuelSalary
from 2016 |
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. |
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 |
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 2016 |
integer | 32 | Yes | Yes | Yes | The player's salary for Fantasy Draft daily fantasy contests. |
FantasyDraftPosition
from 2016 |
string | 10 | Yes | Yes | 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 |
FantasyPointsFanDuel | decimal | 32 | Yes | Yes | Yes | Total FanDuel daily fantasy points scored |
FantasyPointsDraftKings | decimal | 32 | Yes | Yes | Yes | Total DraftKings daily fantasy points scored |
FantasyPointsYahoo | decimal | 32 | Yes | Yes | Yes | Total Yahoo daily fantasy points scored |
Minutes | integer | 32 | Yes | Yes | Yes | Total number of minutes played |
Seconds | integer | 32 | Yes | Yes | Yes | Total number of seconds played |
Goals | decimal | 32 | Yes | Yes | Yes | Total number of goals scored |
Assists | decimal | 32 | Yes | Yes | Yes | Total number of assists |
ShotsOnGoal | decimal | 32 | Yes | Yes | Yes | Total number of shots on goal |
PowerPlayGoals | decimal | 32 | Yes | Yes | Yes | Total number of power play goals |
ShortHandedGoals | decimal | 32 | Yes | Yes | Yes | Total number of short handed goals |
EmptyNetGoals | decimal | 32 | Yes | Yes | Yes | Total number of empty net goals |
PowerPlayAssists | decimal | 32 | Yes | Yes | Yes | Total number of power play assists |
ShortHandedAssists | decimal | 32 | Yes | Yes | Yes | Total number of short handed assists |
HatTricks | decimal | 32 | Yes | Yes | Yes | Total number of hat tricks |
ShootoutGoals | decimal | 32 | Yes | Yes | Yes | Total number of shootout goals |
PlusMinus | decimal | 32 | Yes | Yes | Yes | Total plus minus |
PenaltyMinutes | decimal | 32 | Yes | Yes | Yes | Total pentalty minutes |
Blocks | decimal | 32 | Yes | Yes | Yes | Total blocked shots |
Hits | decimal | 32 | Yes | Yes | Yes | Total hits |
Takeaways | decimal | 32 | Yes | Yes | Yes | Total takeaways |
Giveaways | decimal | 32 | Yes | Yes | Yes | Total giveaways |
FaceoffsWon | decimal | 32 | Yes | Yes | Yes | Total faceoffs won |
FaceoffsLost | decimal | 32 | Yes | Yes | Yes | Total faceoffs lost |
Shifts | decimal | 32 | Yes | Yes | Yes | Total shifts |
GoaltendingMinutes | integer | 32 | Yes | Yes | Yes | Total goaltending minutes |
GoaltendingSeconds | integer | 32 | Yes | Yes | Yes | Total goaltending seconds |
GoaltendingShotsAgainst | decimal | 32 | Yes | Yes | Yes | Total goaltending shots against |
GoaltendingGoalsAgainst | decimal | 32 | Yes | Yes | Yes | Total goaltending goals against |
GoaltendingSaves | decimal | 32 | Yes | Yes | Yes | Total goaltending saves |
GoaltendingWins | decimal | 32 | Yes | Yes | Yes | Total goaltending wins |
GoaltendingLosses | decimal | 32 | Yes | Yes | Yes | Total goaltendings losses |
GoaltendingShutouts | decimal | 32 | Yes | Yes | Yes | Total goaltendings shutouts |
Started
from 2017 |
integer | 32 | Yes | No | Yes | Total games started |
BenchPenaltyMinutes | decimal | 32 | Yes | Yes | Yes | Total bench pentalty minutes |
GoaltendingOvertimeLosses | decimal | 32 | Yes | Yes | Yes | Total goaltending overtime losses |
FantasyPointsFantasyDraft | decimal | 32 | Yes | Yes | Yes | Total FantasyDraft daily fantasy points scored |
PlayerLine
This table is used in the following endpoints:
NHL v3 Stats
Line Combinations by Season
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
LineNumber | integer | 32 | No | Yes | Yes | The line the player is on (e.g. 1, 2, 3, or 4) |
Position | string | 10 | No | Yes | Yes | The position of the player on the line (e.g. C, RW, LW, or D) |
PlayerID | integer | 32 | Yes | No | Yes | Unique ID assigned to each player that stays with them throughout their career |
Name | string | 50 | Yes | No | Yes | The name of the player on the line |
Shoots | string | 10 | Yes | Yes | Yes | The handedness of the player (Possible values: left or right) |
LineType | string | 10 | No | No | Yes | The type of line the player is on (e.g. first, second, third, etc.) |
PlayerSeason
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 NHL 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 |
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 |
FantasyPointsFanDuel | decimal | 32 | Yes | Yes | Yes | Total FanDuel daily fantasy points scored |
FantasyPointsDraftKings | decimal | 32 | Yes | Yes | Yes | Total DraftKings daily fantasy points scored |
FantasyPointsYahoo | decimal | 32 | Yes | Yes | Yes | Total Yahoo daily fantasy points scored |
Minutes | integer | 32 | Yes | Yes | Yes | Total number of minutes played |
Seconds | integer | 32 | Yes | Yes | Yes | Total number of seconds played |
Goals | decimal | 32 | Yes | Yes | Yes | Total number of goals scored |
Assists | decimal | 32 | Yes | Yes | Yes | Total number of assists |
ShotsOnGoal | decimal | 32 | Yes | Yes | Yes | Total number of shots on goal |
PowerPlayGoals | decimal | 32 | Yes | Yes | Yes | Total number of power play goals |
ShortHandedGoals | decimal | 32 | Yes | Yes | Yes | Total number of short handed goals |
EmptyNetGoals | decimal | 32 | Yes | Yes | Yes | Total number of empty net goals |
PowerPlayAssists | decimal | 32 | Yes | Yes | Yes | Total number of power play assists |
ShortHandedAssists | decimal | 32 | Yes | Yes | Yes | Total number of short handed assists |
HatTricks | decimal | 32 | Yes | Yes | Yes | Total number of hat tricks |
ShootoutGoals | decimal | 32 | Yes | Yes | Yes | Total number of shootout goals |
PlusMinus | decimal | 32 | Yes | Yes | Yes | Total plus minus |
PenaltyMinutes | decimal | 32 | Yes | Yes | Yes | Total pentalty minutes |
Blocks | decimal | 32 | Yes | Yes | Yes | Total blocked shots |
Hits | decimal | 32 | Yes | Yes | Yes | Total hits |
Takeaways | decimal | 32 | Yes | Yes | Yes | Total takeaways |
Giveaways | decimal | 32 | Yes | Yes | Yes | Total giveaways |
FaceoffsWon | decimal | 32 | Yes | Yes | Yes | Total faceoffs won |
FaceoffsLost | decimal | 32 | Yes | Yes | Yes | Total faceoffs lost |
Shifts | decimal | 32 | Yes | Yes | Yes | Total shifts |
GoaltendingMinutes | integer | 32 | Yes | Yes | Yes | Total goaltending minutes |
GoaltendingSeconds | integer | 32 | Yes | Yes | Yes | Total goaltending seconds |
GoaltendingShotsAgainst | decimal | 32 | Yes | Yes | Yes | Total goaltending shots against |
GoaltendingGoalsAgainst | decimal | 32 | Yes | Yes | Yes | Total goaltending goals against |
GoaltendingSaves | decimal | 32 | Yes | Yes | Yes | Total goaltending saves |
GoaltendingWins | decimal | 32 | Yes | Yes | Yes | Total goaltending wins |
GoaltendingLosses | decimal | 32 | Yes | Yes | Yes | Total goaltendings losses |
GoaltendingShutouts | decimal | 32 | Yes | Yes | Yes | Total goaltendings shutouts |
Started
from 2017 |
integer | 32 | Yes | No | Yes | Total games started |
BenchPenaltyMinutes | decimal | 32 | Yes | Yes | Yes | Total bench pentalty minutes |
GoaltendingOvertimeLosses | decimal | 32 | Yes | Yes | Yes | Total goaltending overtime losses |
FantasyPointsFantasyDraft | decimal | 32 | Yes | Yes | Yes | Total FantasyDraft daily fantasy points scored |
ScheduleBasic
This table is used in the following endpoints:
NHL v3 Scores
Schedules (Basic)
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 NHL 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, F/SO, F/OT, Suspended, Postponed, Delayed, 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 | |
Updated | datetime | Yes | No | Yes | The timestamp of when the record was last updated (US Eastern Time). | |
IsClosed | boolean | Yes | No | Yes | Indicates whether the game is over and the final score has been verified and closed out. | |
AwayTeam | string | 10 | No | No | Yes | The abbreviation of the Away Team |
HomeTeam | string | 10 | No | No | Yes | The abbreviation of the Home Team |
StadiumID | integer | 32 | Yes | No | Yes | The unique ID of the stadium |
AwayTeamScore | integer | 32 | Yes | Yes | Yes | Number of goals the away team scored in this game |
HomeTeamScore | integer | 32 | Yes | Yes | Yes | Number of goals the home team scored in this 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. |
GameEndDateTime | datetime | Yes | No | Yes | The date and time that the game ended in US Eastern Time | |
NeutralVenue | boolean | Yes | No | Yes | Indicates whether this game is played in a neutral venue | |
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 |
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 |
ScoreBasic
This table is used in the following endpoints:
NHL v3 Scores
Games by Date (Basic)
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 NHL 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, F/SO, F/OT, Suspended, Postponed, Delayed, 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 | |
Updated | datetime | Yes | No | Yes | The timestamp of when the record was last updated (US Eastern Time). | |
IsClosed | boolean | Yes | No | Yes | Indicates whether the game is over and the final score has been verified and closed out. | |
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 |
StadiumID | integer | 32 | Yes | No | Yes | The unique ID of the stadium |
AwayTeamScore | integer | 32 | Yes | Yes | Yes | Number of goals the away team scored in this game |
HomeTeamScore | integer | 32 | Yes | Yes | Yes | Number of goals the home team scored in this game |
GameEndDateTime | datetime | Yes | No | Yes | The date and time that the game ended in US Eastern Time |
ScoringPlay
This table is used in the following endpoints:
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
ScoringPlayID | integer | 32 | No | No | Yes | The unique ID of the scoring play |
PeriodID | integer | 32 | No | No | Yes | The unique ID of the period |
Sequence | integer | 32 | Yes | No | Yes | The sequence/order that this scoring play happened |
TimeRemainingMinutes | integer | 32 | Yes | No | Yes | Number of minutes that have passed in the current period. Please note this field name is misleading, and actually represents the game clock minutes, which are the number of minutes that have already passed in the period. Possible values: 0-20. |
TimeRemainingSeconds | integer | 32 | Yes | No | Yes | Number of seconds that have passed in the current period. Please note this field name is misleading, and actually represents the game clock seconds, which are the number of seconds that have already passed in the period. Possible values: 0-60. |
ScoredByTeamID | integer | 32 | Yes | Yes | Yes | The TeamID of the team that scored the goal |
AllowedByTeamID | integer | 32 | Yes | Yes | Yes | The TeamID of the team that allowe the goal |
ScoredByPlayerID | integer | 32 | Yes | Yes | Yes | The PlayerID of the player who scored the goal |
AssistedByPlayerID1 | integer | 32 | Yes | Yes | Yes | The PlayerID of the player who assisted on the goal |
AssistedByPlayerID2 | integer | 32 | Yes | Yes | Yes | The PlayerID of the player who assisted on the goal |
PowerPlay | boolean | Yes | No | Yes | Whether the goal was scored on the power play (true/false) | |
ShortHanded | boolean | Yes | No | Yes | Whether the goal was scored shorthanded (true/false) | |
EmptyNet | boolean | Yes | No | Yes | Whether the goal was an empty net goal (true/false) | |
AwayTeamScore | integer | Yes | No | Yes | The away team score after the play ended | |
HomeTeamScore | integer | Yes | No | Yes | The home team score after the play ended |
Season
This table is used in the following endpoints:
NHL v3 Scores
Current Season
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
Season | integer | 32 | No | No | Yes | The NHL regular season for which these totals apply |
StartYear | integer | 32 | No | No | Yes | The year in which the season started |
EndYear | integer | 32 | No | No | Yes | The year in which the season ended |
Description | string | 10 | Yes | No | Yes | The description of the season for display purposes (possible values include: 2017-18, 2018-19, etc) |
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 string to pass into subsequent API calls in the season parameter |
Series
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
This table is used in the following endpoints:
NHL v3 Odds
Betting Events by Date,
Betting Events by Season,
Betting Futures by Season,
Betting Market,
Betting Markets by Event,
Betting Markets by GameID,
Betting Markets by Market Type,
Betting Player Props by GameID,
Sportsbooks (Active)
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
This table is used in the following endpoints:
NHL v3 Scores
Stadiums
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
StadiumID | integer | 32 | No | No | Yes | The unique ID of the arena |
Active | boolean | No | No | Yes | Whether or not this arena is the home venue for an active team | |
Name | string | 50 | No | No | Yes | The full name of the arena |
Address | string | 50 | Yes | No | Yes | The address where the arena is located |
City | string | 50 | Yes | No | Yes | The city where the arena is located |
State | string | 10 | Yes | No | Yes | The US state where the arena is located (if arena is outside US, this value is NULL) |
Zip | string | 10 | Yes | No | Yes | The zip code of the arena |
Country | string | 10 | Yes | No | Yes | The 2-digit country code where the arena is located |
Capacity | integer | 32 | Yes | No | Yes | The estimated seating capacity of the arena |
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. |
Standing
This table is used in the following endpoints:
NHL v3 Scores
Standings
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
Season | integer | 32 | No | No | Yes | The NHL 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 |
Conference | string | 20 | Yes | No | Yes | The conference of the team (Eastern or Western) |
Division | string | 20 | Yes | No | Yes | The division of the team (e.g. Atlantic, Metropolitan, Central, or Pacific)) |
Wins | integer | 32 | Yes | No | Yes | Regular season wins |
Losses | integer | 32 | Yes | No | Yes | Regular season losses |
OvertimeLosses | integer | 32 | Yes | No | Yes | Regular season overtime losses |
Percentage | decimal | 32 | Yes | No | Yes | Winning percentage |
ConferenceWins | integer | 32 | Yes | No | Yes | Regular season conference wins |
ConferenceLosses | integer | 32 | Yes | No | Yes | Regular season conference losses |
DivisionWins | integer | 32 | Yes | No | Yes | Regular season division wins |
DivisionLosses | integer | 32 | Yes | No | Yes | Regular season division wins |
ShutoutWins | integer | 32 | Yes | No | Yes | Regular season shutout wins |
ConferenceRank | integer | 32 | Yes | No | Yes | Regular season conference rank |
DivisionRank | integer | 32 | Yes | No | Yes | Regular season division rank |
GlobalTeamID | integer | 32 | Yes | No | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
StartingGoaltenders
This table is used in the following endpoints:
NHL v3 Projections
Starting Goaltenders by Date
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 |
SeasonType
from 2021 |
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
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 (ex. 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 |
HomeGoaltender
from 2021 |
Goaltender | 32 | Yes | No | Yes | Information on the Home Team Goaltender |
AwayGoaltender
from 2021 |
Goaltender | 32 | Yes | No | Yes | Information on the Away Team Goaltender |
Team
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. LA, PHI, BOS, CHI, 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. Kings, Flyers, Bruins, Blackhawks, etc.) |
StadiumID | integer | 32 | Yes | No | Yes | The unique ID of the team's current home arena |
Conference | string | 20 | Yes | No | Yes | The conference of the team (possible values: Eastern, Western) |
Division | string | 20 | Yes | No | Yes | The division of the team (e.g. Atlantic, Metropolitan, etc) |
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 |
TeamGame
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 NHL season of the game |
Name | string | 50 | Yes | No | Yes | Team's name |
Team | string | 10 | Yes | No | Yes | The abbreviation of the Team |
Wins | integer | 10 | Yes | No | Yes | Total number of team wins |
Losses | integer | 10 | Yes | No | Yes | Total number of team losses |
OvertimeLosses | integer | 10 | Yes | No | Yes | Total number of overtime losses |
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 |
FantasyPointsFanDuel | decimal | 32 | Yes | Yes | Yes | Total FanDuel daily fantasy points scored |
FantasyPointsDraftKings | decimal | 32 | Yes | Yes | Yes | Total DraftKings daily fantasy points scored |
FantasyPointsYahoo | decimal | 32 | Yes | Yes | Yes | Total Yahoo daily fantasy points scored |
Minutes | integer | 32 | Yes | Yes | Yes | Total number of minutes played |
Seconds | integer | 32 | Yes | Yes | Yes | Total number of seconds played |
Goals | decimal | 32 | Yes | Yes | Yes | Total number of goals scored |
Assists | decimal | 32 | Yes | Yes | Yes | Total number of assists |
ShotsOnGoal | decimal | 32 | Yes | Yes | Yes | Total number of shots on goal |
PowerPlayGoals | decimal | 32 | Yes | Yes | Yes | Total number of power play goals |
ShortHandedGoals | decimal | 32 | Yes | Yes | Yes | Total number of short handed goals |
EmptyNetGoals | decimal | 32 | Yes | Yes | Yes | Total number of empty net goals |
PowerPlayAssists | decimal | 32 | Yes | Yes | Yes | Total number of power play assists |
ShortHandedAssists | decimal | 32 | Yes | Yes | Yes | Total number of short handed assists |
HatTricks | decimal | 32 | Yes | Yes | Yes | Total number of hat tricks |
ShootoutGoals | decimal | 32 | Yes | Yes | Yes | Total number of shootout goals |
PlusMinus | decimal | 32 | Yes | Yes | Yes | Total plus minus |
PenaltyMinutes | decimal | 32 | Yes | Yes | Yes | Total pentalty minutes |
Blocks | decimal | 32 | Yes | Yes | Yes | Total blocked shots |
Hits | decimal | 32 | Yes | Yes | Yes | Total hits |
Takeaways | decimal | 32 | Yes | Yes | Yes | Total takeaways |
Giveaways | decimal | 32 | Yes | Yes | Yes | Total giveaways |
FaceoffsWon | decimal | 32 | Yes | Yes | Yes | Total faceoffs won |
FaceoffsLost | decimal | 32 | Yes | Yes | Yes | Total faceoffs lost |
Shifts | decimal | 32 | Yes | Yes | Yes | Total shifts |
GoaltendingMinutes | integer | 32 | Yes | Yes | Yes | Total goaltending minutes |
GoaltendingSeconds | integer | 32 | Yes | Yes | Yes | Total goaltending seconds |
GoaltendingShotsAgainst | decimal | 32 | Yes | Yes | Yes | Total goaltending shots against |
GoaltendingGoalsAgainst | decimal | 32 | Yes | Yes | Yes | Total goaltending goals against |
GoaltendingSaves | decimal | 32 | Yes | Yes | Yes | Total goaltending saves |
GoaltendingWins | decimal | 32 | Yes | Yes | Yes | Total goaltending wins |
GoaltendingLosses | decimal | 32 | Yes | Yes | Yes | Total goaltendings losses |
GoaltendingShutouts | decimal | 32 | Yes | Yes | Yes | Total goaltendings shutouts |
Started
from 2017 |
integer | 32 | Yes | No | Yes | Total games started |
BenchPenaltyMinutes | decimal | 32 | Yes | Yes | Yes | Total bench pentalty minutes |
GoaltendingOvertimeLosses | decimal | 32 | Yes | Yes | Yes | Total goaltending overtime losses |
FantasyPointsFantasyDraft | decimal | 32 | Yes | Yes | Yes | Total FantasyDraft daily fantasy points scored |
TeamGameTrends
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. LA, PHI, BOS, CHI, 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. LA, PHI, BOS, CHI, 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 |
TeamLine
This table is used in the following endpoints:
NHL v3 Stats
Line Combinations by Season
Name | Type | Size | Nullable | Scrambled | CSV | Description |
---|---|---|---|---|---|---|
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 |
FullName | string | 50 | No | No | Yes | The full team name |
EvenStrengthLines | PlayerLine[] | Yes | No | Yes | The even strength lines for this team | |
PowerPlayLines | PlayerLine[] | Yes | No | Yes | The power play lines for this team | |
ShortHandedLines | PlayerLine[] | Yes | No | No | The short-handed/penalty-kill lines for this team |
TeamSeason
This table is used in the following endpoints:
NHL v3 Scores
Team Season Stats
NHL v3 Stats
Team Stats Allowed by Position
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 NHL 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 |
Wins | integer | 10 | Yes | No | Yes | Total number of wins |
Losses | integer | 10 | Yes | No | Yes | Total number of losses |
OvertimeLosses | integer | 10 | Yes | No | Yes | Total number of overtime losses |
OpponentPosition | string | 10 | Yes | No | Yes | Indicates which position is included in opponent stats that are aggregated together |
GlobalTeamID | integer | 32 | Yes | No | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
OpponentStat | OpponentSeason | Yes | No | Yes | The aggregated season stats for this team's opponents | |
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 |
FantasyPointsFanDuel | decimal | 32 | Yes | Yes | Yes | Total FanDuel daily fantasy points scored |
FantasyPointsDraftKings | decimal | 32 | Yes | Yes | Yes | Total DraftKings daily fantasy points scored |
FantasyPointsYahoo | decimal | 32 | Yes | Yes | Yes | Total Yahoo daily fantasy points scored |
Minutes | integer | 32 | Yes | Yes | Yes | Total number of minutes played |
Seconds | integer | 32 | Yes | Yes | Yes | Total number of seconds played |
Goals | decimal | 32 | Yes | Yes | Yes | Total number of goals scored |
Assists | decimal | 32 | Yes | Yes | Yes | Total number of assists |
ShotsOnGoal | decimal | 32 | Yes | Yes | Yes | Total number of shots on goal |
PowerPlayGoals | decimal | 32 | Yes | Yes | Yes | Total number of power play goals |
ShortHandedGoals | decimal | 32 | Yes | Yes | Yes | Total number of short handed goals |
EmptyNetGoals | decimal | 32 | Yes | Yes | Yes | Total number of empty net goals |
PowerPlayAssists | decimal | 32 | Yes | Yes | Yes | Total number of power play assists |
ShortHandedAssists | decimal | 32 | Yes | Yes | Yes | Total number of short handed assists |
HatTricks | decimal | 32 | Yes | Yes | Yes | Total number of hat tricks |
ShootoutGoals | decimal | 32 | Yes | Yes | Yes | Total number of shootout goals |
PlusMinus | decimal | 32 | Yes | Yes | Yes | Total plus minus |
PenaltyMinutes | decimal | 32 | Yes | Yes | Yes | Total pentalty minutes |
Blocks | decimal | 32 | Yes | Yes | Yes | Total blocked shots |
Hits | decimal | 32 | Yes | Yes | Yes | Total hits |
Takeaways | decimal | 32 | Yes | Yes | Yes | Total takeaways |
Giveaways | decimal | 32 | Yes | Yes | Yes | Total giveaways |
FaceoffsWon | decimal | 32 | Yes | Yes | Yes | Total faceoffs won |
FaceoffsLost | decimal | 32 | Yes | Yes | Yes | Total faceoffs lost |
Shifts | decimal | 32 | Yes | Yes | Yes | Total shifts |
GoaltendingMinutes | integer | 32 | Yes | Yes | Yes | Total goaltending minutes |
GoaltendingSeconds | integer | 32 | Yes | Yes | Yes | Total goaltending seconds |
GoaltendingShotsAgainst | decimal | 32 | Yes | Yes | Yes | Total goaltending shots against |
GoaltendingGoalsAgainst | decimal | 32 | Yes | Yes | Yes | Total goaltending goals against |
GoaltendingSaves | decimal | 32 | Yes | Yes | Yes | Total goaltending saves |
GoaltendingWins | decimal | 32 | Yes | Yes | Yes | Total goaltending wins |
GoaltendingLosses | decimal | 32 | Yes | Yes | Yes | Total goaltendings losses |
GoaltendingShutouts |