NHL Data Dictionary
Below you will find a list of all data points that are contained within each feed that we offer. If any of the information provided below is unclear, or if you have a specific question, please contact support.
Go to our developer portal for a full list of operations including deprecated, legacy and test endpoints.
All dates & times are in US Eastern Time.
BettingEntityMetadata
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| RecordId from 2021 | integer (32) | NOT NULL | No | The unique ID of this record. Unique only within the same entity type (i.e. BettingMarketTypeIDs overlap with BettingBetTypeIDs) |
| Name from 2021 | string (100) | NOT NULL | No | A text value for the record (e.g. Moneyline; Player Prop; 3rd Quarter) |
| Active | bool (32) | NULL | No | Whether or not this market is currently is use |
BettingEntityMetadataCollection
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingBetTypes from 2021 | BettingEntityMetadata[] | NULL | No | The list of the bet types that can be found within a market |
| BettingMarketTypes from 2021 | BettingEntityMetadata[] | NULL | No | A list of the possible market types within a Betting Event (e.g. Game Line, Team Prop, Player Future, etc.) |
| BettingPeriodTypes from 2021 | BettingEntityMetadata[] | NULL | No | A list of the possible BettingPeriodTypes (e.g. Full Game; Regulation; 1st Period) |
| BettingEventTypes from 2021 | BettingEntityMetadata[] | NULL | No | A list of the possible BettingEventTypes (e.g. Game, Future) |
| BettingOutcomeTypes from 2021 | BettingEntityMetadata[] | NULL | No | A list of the possible BettingOutcomeTypes (e.g. Home; Away; Under; Over) |
| ResultedMarketMetaData from 2021 | BettingResultingMetadata[] | NULL | No | A list of the combinations of MarketType, BetType, & PeriodType which we willl provide automated resulting for |
| BettingResultTypes from 2021 | BettingEntityMetadata[] | NULL | No | A list of the possible BettingResultTypes (e.g. Win; Loss; Push; Not Resulted; Incomplete) |
BettingEvent
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingEventID from 2020 | int (32) | NOT NULL | No | The unique ID associated with the betting event |
| Name from 2020 | string (32) | NULL | No | The name of this betting event |
| Season from 2020 | int (32) | NULL | No | The NHL season of the betting event |
| BettingEventTypeID from 2020 | int (32) | NOT NULL | No | The ID associated with the type of betting event |
| BettingEventType from 2020 | string (32) | NOT NULL | No | Indicates the type of betting event - Game or Future |
| StartDate from 2020 | datetime | NULL | No | The furthest forward time any book has a market set to close for this betting event |
| Created from 2020 | datetime | NULL | No | The date and time when this betting event was created in US Eastern Time. |
| Updated from 2020 | datetime | NULL | No | The timestamp of the last time this betting event was updated (in US Eastern Time) |
| GameID from 2020 | int (32) | NULL | No | The unique ID of the game tied to this BettingEvent |
| GlobalGameID from 2020 | int (32) | NULL | No | A globally unique ID for the game tied to this betting event. This value is guaranteed to be unique across all sports/leagues. |
| GameStatus from 2020 | string (32) | NULL | Yes | The status of the game tied to this event. A list of NHL game statuses can be found here. |
| Quarter from 2020 | string (32) | NULL | Yes | The quarter of the game tied to this event. Note: This field will be null unless the game is ongoing. |
| AwayTeam from 2020 | string (32) | NULL | No | The abbreviation [Key] of the away team |
| HomeTeam from 2020 | string (32) | NULL | No | The abbreviation [Key] of the home team |
| AwayTeamID from 2020 | int (32) | NULL | No | The unique TeamID of the away team in the game tied to this betting event |
| HomeTeamID from 2020 | int (32) | NULL | No | The unique ID of the home team tied to this betting event |
| GlobalAwayTeamID from 2020 | int (32) | NULL | No | A globally unique ID for the away team tied to this betting event. This value is guaranteed to be unique across all sports/leagues. |
| GlobalHomeTeamID from 2020 | int (32) | NULL | No | A globally unique ID for the home team tied to this betting event. This value is guaranteed to be unique across all sports/leagues. |
| AwayTeamScore from 2020 | int (32) | NULL | Yes | Total number of goals the away team scored in the game tied to the event (post-game) |
| HomeTeamScore from 2020 | int (32) | NULL | Yes | Total number of points the home team scored in the game tied to the event (post-game) |
| TotalScore from 2020 | int (32) | NULL | Yes | Total goals scored in the game (post-game) |
| AwayRotationNumber from 2020 | int (32) | NULL | No | The rotation number of the away team for a game |
| HomeRotationNumber from 2020 | int (32) | NULL | No | The rotation number of the home team for this game |
| BettingMarkets from 2020 | BettingMarket[] (32) | NULL | No | The list of betting markets for this event |
| GameStartTime from 2020 | datetime (32) | NULL | No | The date and time that the game attached to the betting event started. Note: Time is in US Eastern Time |
BettingMarket
Available Endpoints
This table is used in the following endpoints:
-
Props
- Betting Events - by Date
- Betting Events - by Season
- Betting Markets - by Event
- Betting Markets - by Game
- Betting Markets - by Market Type
- Betting Player Props - by Game
- Betting Markets - by Event [Sportsbook Group]
- Betting Markets - by Game [Sportsbook Group]
- Betting Markets - by Market Type [Sportsbook Group]
- Betting Player Props - by Game [Sportsbook Group]
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketID from 2020 | int (32) | NOT NULL | No | The unique ID of the betting market |
| BettingEventID from 2020 | int (32) | NOT NULL | No | The unique ID assocated with the betting event |
| BettingMarketTypeID from 2020 | int (32) | NULL | Yes | The ID associated with the name of the market type within a market |
| BettingMarketType from 2020 | string (32) | NULL | Yes | The name of the market type within a betting market (e.g. Player Prop, Team Prop, Game Prop, etc.) |
| BettingBetTypeID from 2020 | int (32) | NULL | Yes | The ID associated with the name of the bet type within a market |
| BettingBetType from 2020 | string (32) | NULL | Yes | The name of the bet type within a market (e.g. Total Points, Moneyline, Puck Line, etc.) |
| BettingPeriodTypeID from 2020 | int (32) | NULL | Yes | The ID associated with the betting period type which we can result |
| BettingPeriodType from 2020 | string (32) | NULL | Yes | The name of the period type of a market (e.g. Full Game; 1st Period; Overtime; Regular Season) |
| Name from 2020 | string (32) | NULL | No | The generic name of this market |
| TeamID from 2020 | int (32) | NULL | Yes | The unique ID of the team |
| TeamKey from 2020 | string (32) | NULL | Yes | The abbreviation [Key] of the team tied to this market result (if applicable) |
| PlayerID from 2020 | int (32) | NULL | Yes | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| PlayerName from 2020 | string (32) | NULL | Yes | The name of the player tied to this market (if applicable) |
| Created from 2020 | datetime (32) | NULL | No | The date and time when this betting market was created in US Eastern Time. |
| Updated from 2020 | datetime (32) | NULL | No | The last updated date of this market |
| AvailableSportsbooks from 2020 | Sportsbook[] (32) | NULL | No | The sportsbooks that have had odds in this market |
| AnyBetsAvailable from 2020 | bool (32) | NULL | No | A field that returns "True" if there are any available bets to make within the market in question. If there are no bets available to make, the field returns "False" |
| BettingOutcomes from 2020 | BettingOutcome[] (32) | NULL | No | The list of betting outcomes from each sportsbook in this market |
| ConsensusOutcomes from 2020 | ConsensusOutcome[] (32) | NULL | No | The single set of consensus outcomes of this market |
| IsArchived | bool | NOT NULL | No | Indicates if the BettingOutcomes have been moved to the archives |
| ArchiveLocation | string | NOT NULL | No | If IsArchived is true, this returns the URL that can be used to retrieve the archived BettingOutcomes. An API Key and Sportsbook Grouping will be required to retrieve this information. If IsArchived is false, this returns an emtpy string |
BettingMarketResult
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketID from 2021 | integer (32) | NOT NULL | No | The unique ID of the betting market |
| BettingMarketTypeID from 2021 | integer (32) | NOT NULL | No | The ID associated with the name of the market type within a market |
| BettingMarketType from 2021 | string (100) | NOT NULL | No | The name of the market type within a betting market (e.g. Player Prop, Team Prop, Game Prop, etc.) |
| BettingBetTypeID from 2021 | integer (32) | NOT NULL | No | The ID associated with the name of the bet type within a market |
| BettingBetType from 2021 | string (100) | NOT NULL | No | The name of the bet type within a market (e.g. Total Points, Moneyline, Puck Line, etc.) |
| BettingPeriodTypeID from 2021 | integer (32) | NOT NULL | No | The ID associated with the betting period type which we can result |
| BettingPeriodType from 2021 | string (100) | NOT NULL | No | The name of the period type of a market (e.g. Full Game; 1st Period; Overtime; Regular Season) |
| Name from 2021 | string (100) | NULL | No | The generic name of this market |
| TeamID from 2021 | integer (32) | NULL | No | The unique ID of the team |
| TeamKey from 2021 | string (10) | NULL | No | The abbreviation [Key] of the team tied to this market result (if applicable) |
| PlayerID from 2021 | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| PlayerName from 2021 | string (100) | NULL | No | The name of the player tied to this market (if applicable) |
| BettingOutcomeResults from 2021 | BettingOutcomeResult[] | NULL | No | The list of outcomes under this market with results |
| IsMarketResultingSupported | bool (32) | NOT NULL | No | Indicates whether resulting is supported for this kind of BettingMarket |
BettingMarketSplit
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketID from 2021 | integer (32) | NOT NULL | No | The unique ID of the betting market |
| BettingEventID from 2021 | integer (32) | NOT NULL | No | The unique ID of the betting event associated with this split |
| BettingMarketTypeID from 2021 | integer (32) | NOT NULL | No | The ID associated with the name of the market type within a market |
| BettingMarketType from 2021 | string (100) | NOT NULL | No | The name of the market type within a betting market (e.g. Player Prop, Team Prop, Game Prop, etc.) |
| BettingBetTypeID from 2021 | integer (32) | NOT NULL | No | The ID associated with the name of the bet type within a market |
| BettingBetType from 2021 | string (100) | NOT NULL | No | The name of the bet type within a market (e.g. Total Points, Moneyline, Puck Line, etc.) |
| BettingPeriodTypeID from 2021 | integer (32) | NOT NULL | No | The ID associated with the betting period type which we can result |
| BettingPeriodType from 2021 | string (100) | NOT NULL | No | The name of the period type of a market (e.g. Full Game; 1st Period; Overtime; Regular Season) |
| TeamID from 2021 | integer (32) | NULL | No | The unique ID of the team |
| TeamKey from 2021 | string (32) | NULL | No | The abbreviation [Key] of the team tied to this market split (if applicable) |
| PlayerID from 2021 | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| PlayerName from 2021 | string (100) | NULL | No | The name of the player tied to this split (if applicable) |
| BettingSplits from 2021 | BettingSplit[] (32) | NOT NULL | No | A list of betting splits |
BettingOutcome
Available Endpoints
This table is used in the following endpoints:
-
Props
- Betting Events - by Date
- Betting Events - by Season
- Betting Markets - by Event
- Betting Markets - by Game
- Betting Markets - by Market Type
- Betting Player Props - by Game
- Betting Markets - by Event [Sportsbook Group]
- Betting Markets - by Game [Sportsbook Group]
- Betting Markets - by Market Type [Sportsbook Group]
- Betting Player Props - by Game [Sportsbook Group]
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingOutcomeID from 2020 | int (32) | NULL | No | The unique ID associated with this specific outcome |
| BettingMarketID from 2020 | int (32) | NULL | No | The unique ID of the betting market |
| SportsBook from 2020 | Sportsbook (32) | NULL | No | The sportsbook offering this outcome for betting |
| BettingOutcomeTypeID from 2020 | int (32) | NULL | Yes | The ID associated with the betting outcome type |
| BettingOutcomeType from 2020 | string (32) | NULL | Yes | The name of the betting outcome within a betting market (e.g. Home; Away; Under; Over) |
| PayoutAmerican from 2020 | int (32) | NULL | Yes | The american odds payout |
| PayoutDecimal from 2020 | decimal (32) | NULL | Yes | The decimal odds payout |
| Value from 2020 | decimal (32) | NULL | Yes | The number associated with the outcome (spread/total/etc) |
| Participant from 2020 | string (32) | NULL | No | The name of the participant (typically team or player) associated with the outcome. NOTE: This is provided by the sportsbook. In the case of Player odds; we highly recommend using PlayerID as names of players can be inconsistent between sportsbooks |
| IsAvailable from 2020 | bool (32) | NULL | No | Is this outcome available for betting as of last update |
| IsAlternate from 2020 | bool (32) | NULL | No | Is this an alternate value or the core value |
| Created from 2020 | datetime (32) | NULL | No | The date and time when this betting outcome was created in US Eastern Time. |
| Updated from 2020 | datetime (32) | NULL | No | The timestamp of the last time this betting outcome was updated (in US Eastern Time) |
| Unlisted from 2020 | datetime (32) | NULL | No | The datetime the outcome was unlisted (no longer available for bets) |
| TeamID from 2020 | int (32) | NULL | Yes | The unique ID of the team |
| PlayerID from 2020 | int (32) | NULL | Yes | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| GlobalTeamID from 2020 | int (32) | NULL | Yes | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| SportsbookUrl from 2020 | string (500) | NULL | Yes | The URL for sportsbook event |
| IsInPlay from 2022 | bool (1) | NULL | No | Was this outcome created after the start time of the game (only applies when the betting event is of type game) |
| SportsbookMarketID | string (100) | NULL | Yes | The market ID of the given sportsbook when available for deep links |
| SportsbookOutcomeID | string (100) | NULL | Yes | The outcome ID of the given sportsbook when available for deep links |
BettingOutcomeResult
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingOutcomeID from 2021 | integer (32) | NOT NULL | No | The unique ID associated with this specific outcome |
| BettingResultTypeID from 2021 | integer (32) | NULL | Yes | The ID associated with the betting result type of this outcome |
| BettingResultType from 2021 | string (100) | NULL | Yes | The BettingResultType of this outcome |
| BettingOutcomeTypeID from 2020 | int (32) | NULL | No | The ID associated with the betting outcome type |
| BettingOutcomeType from 2020 | string (32) | NULL | No | The name of the betting outcome within a betting market (e.g. Home; Away; Under; Over) |
| BetValue from 2021 | decimal (32) | NULL | Yes | The offered betting line from a sportsbook for a game (i.e. If a team won a game by 2 and the spread was -1.5, the actual value would be 2 and the bet value would be -1.5) |
| ActualValue from 2021 | decimal (32) | NULL | Yes | The value of the actual result that occured in game (i.e. If a team won a game by 2 and the spread was -1.5, the actual value would be 2 and the bet value would be -1.5) |
BettingResultingMetadata
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketTypeId from 2021 | integer (32) | NOT NULL | No | The ID associated with the name of the market type within a market |
| BettingBetTypeId from 2021 | integer (32) | NOT NULL | No | The ID associated with the name of the bet type within a market |
| BettingPeriodTypeId from 2021 | integer (32) | NOT NULL | No | The ID associated with the betting period type which we can result |
BettingSplit
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| BettingMarketSplitID from 2021 | integer (32) | NOT NULL | No | The unique ID of this betting split insatnce |
| BettingMarketID from 2021 | integer (32) | NOT NULL | No | The unique ID of the betting market |
| BettingOutcomeTypeID from 2021 | integer (32) | NULL | No | The ID associated with the betting outcome type |
| BettingOutcomeType from 2021 | string (32) | NULL | No | The name of the betting outcome within a betting market (e.g. Home; Away; Under; Over) |
| BetPercentage from 2021 | integer (32) | NULL | Yes | Percentage of bets placed on a specific outcome |
| MoneyPercentage from 2021 | integer (32) | NULL | Yes | The percent of money on this outcome |
| Created from 2021 | datetime (32) | NOT NULL | No | The date and time when this betting split was created in US Eastern Time |
| LastSeen from 2021 | datetime (32) | NOT NULL | No | When this split was last updated |
BoxScore
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Game | Game | NULL | No | The details of the game associated with this box score |
| Periods | Period[] | NULL | No | The details of the periods associated with this box score |
| TeamGames | TeamGame[] | NULL | No | The team game stats associated with this box score |
| PlayerGames | PlayerGame[] | NULL | No | The player game stats associated with this box score |
| ShootoutPlays | Play[] | NULL | No | The details of any shootout plays associated with this box score |
ConsensusOutcome
Available Endpoints
This table is used in the following endpoints:
-
Props
- Betting Events - by Date
- Betting Events - by Season
- Betting Markets - by Event
- Betting Markets - by Game
- Betting Markets - by Market Type
- Betting Player Props - by Game
- Betting Markets - by Event [Sportsbook Group]
- Betting Markets - by Game [Sportsbook Group]
- Betting Markets - by Market Type [Sportsbook Group]
- Betting Player Props - by Game [Sportsbook Group]
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| NumberOfSportsbooks from 2020 | int (32) | NOT NULL | Yes | The number of sportsbooks odds that went into creating this consensus outcome |
| BettingOutcomeID from 2020 | int (32) | NULL | No | The unique ID associated with this specific outcome |
| BettingMarketID from 2020 | int (32) | NULL | No | The unique ID of the betting market |
| SportsBook from 2020 | Sportsbook (32) | NULL | No | The sportsbook offering this outcome for betting |
| BettingOutcomeTypeID from 2020 | int (32) | NULL | Yes | The ID associated with the betting outcome type |
| BettingOutcomeType from 2020 | string (32) | NULL | Yes | The name of the betting outcome within a betting market (e.g. Home; Away; Under; Over) |
| PayoutAmerican from 2020 | int (32) | NULL | Yes | The american odds payout |
| PayoutDecimal from 2020 | decimal (32) | NULL | Yes | The decimal odds payout |
| Value from 2020 | decimal (32) | NULL | Yes | The number associated with the outcome (spread/total/etc) |
| Participant from 2020 | string (32) | NULL | No | The name of the participant (typically team or player) associated with the outcome. NOTE: This is provided by the sportsbook. In the case of Player odds; we highly recommend using PlayerID as names of players can be inconsistent between sportsbooks |
| IsAvailable from 2020 | bool (32) | NULL | No | Is this outcome available for betting as of last update |
| IsAlternate from 2020 | bool (32) | NULL | No | Is this an alternate value or the core value |
| Created from 2020 | datetime (32) | NULL | No | The date and time when this consensus outcome was created in US Eastern Time. |
| Updated from 2020 | datetime (32) | NULL | No | The timestamp of the last time this consensus outcome was updated (in US Eastern Time) |
| Unlisted from 2020 | datetime (32) | NULL | No | The datetime the outcome was unlisted (no longer available for bets) |
| TeamID from 2020 | int (32) | NULL | Yes | The unique ID of the team |
| PlayerID from 2020 | int (32) | NULL | Yes | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| GlobalTeamID from 2020 | int (32) | NULL | Yes | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| SportsbookUrl from 2020 | string (500) | NULL | Yes | The URL for sportsbook event |
| IsInPlay from 2022 | bool (1) | NULL | No | Was this outcome created after the start time of the game (only applies when the betting event is of type game) |
| SportsbookMarketID | string (100) | NULL | Yes | The market ID of the given sportsbook when available for deep links |
| SportsbookOutcomeID | string (100) | NULL | Yes | The outcome ID of the given sportsbook when available for deep links |
DfsSlate
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SlateID | integer (32) | NOT NULL | No | Unique ID of a Slate (assigned by SportsDataIO). |
| Operator | string (20) | NULL | No | The name of the operator who is running contests for this slate. (possible values: FanDuel; DraftKings; Yahoo; FantasyDraft; etc.) |
| OperatorSlateID | integer (32) | NULL | No | The unique ID of a slate as assigned by the operator |
| OperatorName | string (50) | NULL | No | The name of the slate (assigned by the operator) (possible values: Main; Express; Arcade; Late Night; etc.) |
| OperatorDay | date | NULL | No | The day (in EST/EDT) that the slate begins (assigned by the operator) |
| OperatorStartTime | datetime | NULL | No | The date & time (in EST/EDT) that the slate begins as assigned by the operator |
| NumberOfGames | integer (32) | NULL | No | The number of actual games that this slate covers |
| IsMultiDaySlate | boolean | NULL | No | Whether this slate uses games that take place on different days |
| RemovedByOperator | boolean | NULL | No | Indicates whether this slate was removed/deleted by the operator |
| OperatorGameType | string (50) | NULL | No | The game type of the slate. NOTE: will often be null as most operators only have one game type |
| DfsSlateGames | DfsSlateGame[] | NULL | No | The games that are included in this slate |
| DfsSlatePlayers | DfsSlatePlayer[] | NULL | No | The players that are included in this slate |
| SlateRosterSlots | string[] | NULL | No | The positions that need to be filled for this particular slate |
| SalaryCap | integer | NULL | No | The salary cap for the current slate (is null for slates with no salary cap such a Tiers gametypes) |
DfsSlateGame
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SlateGameID | integer (32) | NOT NULL | No | Unique ID of a SlateGame (assigned by SportsDataIO). |
| SlateID | integer (32) | NOT NULL | No | The SlateID that this SlateGame refers to. |
| GameID | integer (32) | NULL | No | The unique ID of the game tied to this SlateGame |
| Game | Game | NULL | No | The details of the game that this SlateGame refers to |
| OperatorGameID | integer (32) | NULL | No | The unique ID of a SlateGame as assigned by the operator |
| RemovedByOperator | boolean | NULL | Yes | Indicates whether this slate was removed/deleted by the operator |
DfsSlatePlayer
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SlatePlayerID | integer (32) | NOT NULL | No | Unique ID of a SlatePlayer (assigned by SportsDataIO). |
| SlateID | integer (32) | NOT NULL | No | The SlateID that this SlatePlayer refers to. |
| SlateGameID | integer (32) | NULL | No | The SlateGameID that this SlatePlayer refers to. |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| PlayerGameProjectionStatID | integer (32) | NULL | No | The SportsDataIO StatID that this SlatePlayer refers to. This points to data in the respective sports' projected player game stats feeds. |
| OperatorPlayerID | string (25) | NULL | No | The unique ID of the player as assigned by the operator |
| OperatorSlatePlayerID | string (50) | NULL | No | The unique ID of the SlatePlayer as assigned by the operator |
| OperatorPlayerName | string (50) | NULL | No | The player's name as assigned by the operator |
| OperatorPosition | string (10) | NULL | No | The player's eligible positions for the contest assigned by the operator |
| OperatorSalary | integer (32) | NULL | No | The player's salary for the contest as assigned by the operator |
| OperatorRosterSlots | string[] | NULL | No | The player's eligible positions to be played in the contest as assigned by the operator. NOTE: This would include UTIL; etc plays for those that are eligible |
| RemovedByOperator | boolean | NULL | Yes | Indicates whether this slate was removed/deleted by the operator |
| Team | string (10) | NULL | No | The team the player plays for |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
FantasyGame
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID | integer (32) | NULL | No | The unique ID of this game |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 5=AllStar; 6=Exhibition). |
| Season | integer (32) | NULL | No | The NHL season of the game |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game in US Eastern Time |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team this player is employed by |
| Opponent | string (10) | NULL | No | The abbreviation [Key] of the opponent team |
| HomeOrAway | string (4) | NULL | No | Indicates whether the team is home or away |
| Jersey | integer (32) | NULL | No | The player's jersey number |
| Name | string (50) | NULL | No | The player's full name |
| Position | string (10) | NULL | No | The player's primary position. Possible values: C; RW; LW; D; or G. |
| Games | integer (32) | NULL | No | Total games played by the player in the game. NOTE: this will be 1 or 0 for single game feeds |
| Started | integer (32) | NULL | No | Indicates whether or not the player started the game Note: this will be one or zero for single game feeds |
| FantasyPoints | decimal (32) | NULL | No | Total fantasy points by the player in the game |
| IsGameOver | boolean | NOT NULL | No | Whether the game is over (returns true/false) |
| FantasyPointsFanDuel | decimal (32) | NULL | No | Total FanDuel daily fantasy points by the player in the game |
| FantasyPointsYahoo | decimal (32) | NULL | No | Total Yahoo daily fantasy points by the player in the game |
| FantasyPointsDraftKings | decimal (32) | NULL | No | Total DraftKings daily fantasy points by the player in the game |
| FanDuelPosition | string (10) | NULL | No | The player's eligible position in FanDuel's daily fantasy sports platform |
| DraftKingsPosition | string (10) | NULL | No | The player's eligible position in DraftKings' daily fantasy sports platform |
| YahooPosition | string (10) | NULL | No | The player's eligible position in Yahoo's daily fantasy sports platform. |
| OpponentRank | integer (32) | NULL | No | The ranking of the player's opponent with regards to fantasy points allowed |
| OpponentPositionRank | integer (32) | NULL | No | The ranking of the player's opponent by position with regards to fantasy points allowed |
| GlobalGameID | integer (32) | NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (in US Eastern Time) |
Game
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID | integer (32) | NOT NULL | No | The unique ID of this game |
| Season | integer (32) | NOT NULL | No | The NHL season of the game |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season, 2=Preseason, 3=Postseason, 5=AllStar, 6=Exhibition). |
| Status | string (20) | NULL | No | Indicates the game's status. Possible values include: Scheduled, InProgress, Final, F/SO, F/OT, Postponed, Canceled, NotNecessary |
| Day | date | NULL | No | The date of the game |
| DateTime | datetime | NULL | No | The date and time of the game in US Eastern Time |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (in US Eastern Time). |
| IsClosed | boolean | NULL | No | Indicates whether the game is over and the final score has been verified and closed out. NOTE: it is recommend for bet resulting to use IsClosed = True rather than simply Final game status |
| AwayTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the away team |
| HomeTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the home team |
| AwayTeamID | integer (32) | NOT NULL | No | The unique ID of the away team |
| HomeTeamID | integer (32) | NOT NULL | No | The unique ID of the home team |
| StadiumID | integer (32) | NULL | No | The unique ID of the stadium |
| Channel | string (10) | NULL | No | The television station broadcasting the game |
| Attendance | integer (32) | NULL | No | The total number of people who attended the game |
| AwayTeamScore | integer (32) | NULL | Yes | Total number of goals scored by the away team in the game |
| HomeTeamScore | integer (32) | NULL | Yes | Total number of goals scored by the home team in the game |
| Period | string (10) | NULL | No | Indicates the current period of the game. Possible values include: 1; 2; 3; OT; SO; NULL |
| TimeRemainingMinutes | integer (32) | NULL | No | Number of minutes remaining in the current period |
| TimeRemainingSeconds | integer (32) | NULL | No | Number of seconds that have passed in the current period. NOTE: this field name might be misleading as it actually represents the game clock sconds which are the number of minutes that have already passed in the period. |
| AwayTeamMoneyLine from 2016 | integer (32) | NULL | Yes | Moneyline from the perspective of the away team |
| HomeTeamMoneyLine from 2016 | integer (32) | NULL | Yes | Moneyline from the perspective of the home team |
| PointSpread from 2017 | decimal (32) | NULL | Yes | The oddsmaker puck line at game start from the perspective of the HomeTeam (negative numbers indicate the HomeTeam is favored; positive numbers indicate the AwayTeam is favored). |
| OverUnder from 2017 | decimal (32) | NULL | Yes | The sportsbook's total goals scored line (Over/Under) for the game |
| GlobalGameID | integer (32) | NOT NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| GlobalAwayTeamID | integer (32) | NOT NULL | No | A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues. |
| GlobalHomeTeamID | integer (32) | NOT NULL | No | A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues. |
| PointSpreadAwayTeamMoneyLine from 2017 | integer (32) | NULL | Yes | The payout odds when betting on the away team with the puck line |
| PointSpreadHomeTeamMoneyLine from 2017 | integer (32) | NULL | Yes | The payout odds when betting on the home team with the puck line |
| LastPlay | string (250) | NULL | No | 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[] | NULL | No | The details of the periods (including overtime if applicable) for this game. |
| GameEndDateTime | datetime | NULL | No | The date and time that the game ended in US Eastern Time |
| HomeRotationNumber | integer (32) | NULL | Yes | The rotation number of the home team for this game |
| AwayRotationNumber | integer (32) | NULL | Yes | The rotation number of the away team for a game |
| NeutralVenue from 2020 | boolean | NULL | No | Indicates whether this game is played in a neutral venue |
| OverPayout from 2021 | integer (32) | NULL | Yes | The sportsbook's payout for the over |
| UnderPayout from 2021 | integer (32) | NULL | Yes | The sportsbook's payout for the under |
| DateTimeUTC from 2021 | datetime | NULL | No | The date and time of the game in UTC |
| SeriesInfo from 2021 | Series (32) | NULL | No | Contains relevant series data for playoff series only - HomeTeamWins, AwayTeamWins, GameNumber, and MaxLength |
| RescheduledFromGameID | integer (32) | NULL | Yes | The GameID of the originally scheduled, postponed game, that this game was rescheduled from. This only pertains to games that are scheduled as "make up" games. |
| RescheduledGameID | integer (32) | NULL | Yes | The GameID of the game that was rescheduled from this game. This only pertains to postponed games that require rescheduling. |
| Referee1ID | integer (32) | NULL | Yes | The unique ID of the main referee of this game |
| Referee2ID | integer (32) | NULL | Yes | The unique ID of the secondary referee of this game |
| Linesperson1ID | integer (32) | NULL | Yes | The unique ID of the main linesperson of this game |
| Linesperson2ID | integer (32) | NULL | Yes | The unique ID of the secondary linesperson of this game |
GameBettingSplit
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID from 2021 | integer (32) | NOT NULL | No | The unique ID of the game tied to the BettingSplits Turn on screen reader support |
| SeasonType from 2021 | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 5=AllStar; 6=Exhibition). |
| Season from 2021 | integer (32) | NOT NULL | No | The end year of season (2021-22 would be 2022) |
| Day from 2021 | datetime (32) | NULL | No | The date of the game |
| AwayTeam from 2021 | string (32) | NULL | No | The abbreviation [Key] of the away team |
| HomeTeam from 2021 | string (32) | NULL | No | The abbreviation [Key] of the home team |
| BettingMarketSplits from 2021 | BettingMarketSplit[] (32) | NOT NULL | No | Shows the betting markets that have splits included for them in the game |
GameInfo
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameId | integer (32) | NOT NULL | No | The unique ID of this game |
| Season | integer (32) | NOT NULL | No | The NHL season of the game |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 5=AllStar; 6=Exhibition). |
| Day | date | NULL | No | The day that the game is scheduled to be played |
| DateTime | datetime | NULL | No | The date and time of the game in US Eastern Time |
| Status | string (20) | NULL | No | The status of the game. For a description of possible values, see here. For how suspended and postponed games are handled specifically, see here. |
| AwayTeamId | integer (32) | NULL | No | The unique ID of the away team |
| HomeTeamId | integer (32) | NULL | No | The unique ID of the home team |
| AwayTeamName | string (50) | NULL | No | The name of the away team |
| HomeTeamName | string (50) | NULL | No | The name of the home team |
| GlobalGameId | integer (32) | NOT NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| GlobalAwayTeamId | integer (32) | NULL | No | A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues. |
| GlobalHomeTeamId | integer (32) | NULL | No | A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues. |
| PregameOdds | GameOdd[] | NULL | No | List of Pregame GameOdds from different sportsbooks |
| LiveOdds | GameOdd[] | NULL | No | List of live game odds from different sportsbooks |
| HomeTeamScore | integer | NULL | Yes | Total number of goals the home team scored in the game (updated after game ends to allow for resolving bets) |
| AwayTeamScore | integer | NULL | Yes | Total number of goals the away team scored in the game (updated after game ends to allow for resolving bets) |
| TotalScore | integer | NULL | Yes | Total goals scored in the game (updated after game ends to allow for resolving bets) |
| HomeRotationNumber | integer (32) | NULL | Yes | The rotation number of the home team for this game |
| AwayRotationNumber | integer (32) | NULL | Yes | The rotation number of the away team for a game |
| AlternateMarketPregameOdds | GameOdd[] | NULL | No | A list of Alternate Market Pregame GameOdds from different sportsbooks (e.g. 1st Period; 2nd Period; etc.) |
GameInfoResult
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID | integer (32) | NOT NULL | No | The unique ID of this game |
| Season | integer (32) | NOT NULL | No | The NHL season of the game |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 5=AllStar; 6=Exhibition). |
| Day | date | NULL | No | The day that the game is scheduled to be played |
| DateTime | datetime | NULL | No | The date and time of the game in US Eastern Time |
| Status | string (20) | NULL | No | The status of the game. For a description of possible values, see here. For how suspended and postponed games are handled specifically, see here. |
| AwayTeamID | integer (32) | NULL | No | The unique ID of the away team |
| HomeTeamID | integer (32) | NULL | No | The unique ID of the home team |
| AwayTeamName | string (50) | NULL | No | The name of the away team |
| HomeTeamName | string (50) | NULL | No | The name of the home team |
| GlobalGameID | integer (32) | NOT NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| GlobalAwayTeamID | integer (32) | NULL | No | A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues. |
| GlobalTeamHomeTeamID | integer (32) | NULL | No | A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues. |
| PregameOdds | GameOddResult[] | NULL | No | List of Pregame GameOdds from different sportsbooks with results |
| HomeTeamScore | integer (32) | NULL | Yes | Total number of goals the home team scored in the game (updated after game ends to allow for resolving bets) |
| AwayTeamScore | integer (32) | NULL | Yes | Total number of goals the away team scored in the game (updated after game ends to allow for resolving bets) |
| TotalScore | integer (32) | NULL | Yes | Total goals scored in the game (updated after game ends to allow for resolving bets) |
| HomeRotationNumber | integer (32) | NULL | Yes | The rotation number of the home team for this game |
| AwayRotationNumber | integer (32) | NULL | Yes | The rotation number of the away team for this game |
| AlternateMarketPregameOdds | GameOddResult[] | NULL | No | A list of Alternate Market Pregame GameOdds from different sportsbooks (e.g. 1st Period; 2nd Period; etc.) |
| Period | string (10) | NULL | No | Indicates the current period of the game. Possible values include: 1; 2; 3; OT; SO; NULL |
| TimeRemainingMinutes | integer (32) | NULL | No | Number of minutes that have passed in the current period. NOTE: this field name might be misleading as it actually represents the game clock minutes which are the number of minutes that have already passed in the period. |
| TimeRemainingSeconds | integer (32) | NULL | No | Number of seconds that have passed in the current period. NOTE: this field name might be misleading as it actually represents the game clock sconds which are the number of minutes that have already passed in the period. |
| Periods | Period[] | NULL | No | The details of the periods (including overtime if applicable) for this game |
| IsClosed | boolean | NULL | No | Indicates whether the game is over and the final score has been verified and closed out. Note: it is recommend for bet resulting to use IsClosed = True rather than simply Final game status |
| LiveOdds | GameOddResult[] | NULL | No | List of Live Odds from different sportsbooks with results |
GameOdd
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameOddId | integer (32) | NOT NULL | No | The unique ID of this odd |
| Sportsbook | string (25) | NOT NULL | Yes | The name of the sportsbook |
| GameId | integer (32) | NOT NULL | No | The unique ID of this game |
| Created | datetime | NOT NULL | No | The date and time of when these odds were first created; based on US Eatern Time (EST/EDT) |
| Updated | datetime | NOT NULL | No | The timestamp of when these odds were last updated (in US Eastern Time) |
| HomeMoneyLine | integer (32) | NULL | Yes | The sportsbook's moneyline for the home team |
| AwayMoneyLine | integer (32) | NULL | Yes | The sportsbook's moneyline for the away team |
| HomePointSpread | decimal (32) | NULL | Yes | The sportsbook's point spread for the home team |
| AwayPointSpread | decimal (32) | NULL | Yes | The sportsbook's point spread for the away team |
| HomePointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's point spread payout for the home team |
| AwayPointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's point spread payout for the away team |
| OverUnder | decimal (32) | NULL | Yes | The sportsbook's total goals scored over under for the game |
| OverPayout | integer (32) | NULL | Yes | The sportsbook's payout for the over |
| UnderPayout | integer (32) | NULL | Yes | The sportsbook's payout for the under |
| SportsbookId | integer (32) | NULL | No | The unique ID of the sportsbook |
| OddType | string (32) | NULL | No | The market type of the odd (ex: live, pregame, 1st-pd, etc) |
| SportsbookUrl | string (500) | NULL | No | The URL for sportsbook event |
| Unlisted | datetime | NULL | No | The timestamp when these odds were no longer seen, based on US Eastern Time (EST/EDT) |
GameOddOutcome
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameOddId | integer (32) | NOT NULL | No | The unique ID of this odd |
| GameOddResultTypeId | integer (32) | NULL | No | The unique ID of this GameOddResultType |
| GameOddResultType | string (100) | NULL | No | The result/outcome of a bet (e.g. Won; Lost; Push; Not Resulted; Incomplete) |
| OddType | string (500) | NULL | No | The market type of the odd (ex: live; pregame; 1st-pd; etc) |
| GameOddType | string (100) | NULL | No | The GameOddOutcomeType of this outcome as a string |
| BetValue | decimal (32) | NULL | No | The offered betting line from a sportsbook for a game (i.e. If a team won a game by 2 and the spread was -1.5, the actual value would be 2 and the bet value would be -1.5) |
| ActualValue | decimal (32) | NULL | No | The value of the actual result that occured in game (i.e. If a team won a game by 2 and the spread was -1.5, the actual value would be 2 and the bet value would be -1.5) |
GameOddResult
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameOddID | integer (32) | NOT NULL | No | The unique ID of this odd |
| Sportsbook | string (25) | NOT NULL | No | The name of the sportsbook |
| GameID | integer (32) | NOT NULL | No | The unique ID of this game |
| Created | datetime | NOT NULL | No | The date and time of when these odds were first created; based on US Eatern Time (EST/EDT) |
| Updated | datetime | NOT NULL | No | The timestamp of when these odds were last updated (in US Eastern Time) |
| HomeMoneyLine | integer (32) | NULL | Yes | The sportsbook's moneyline for the home team |
| AwayMoneyLine | integer (32) | NULL | Yes | The sportsbook's moneyline for the away team |
| HomePointSpread | decimal (32) | NULL | Yes | The sportsbook's point spread for the home team |
| AwayPointSpread | decimal (32) | NULL | Yes | The sportsbook's point spread for the away team |
| HomePointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's point spread payout for the home team |
| AwayPointSpreadPayout | integer (32) | NULL | Yes | The sportsbook's point spread payout for the away team |
| OverUnder | decimal (32) | NULL | Yes | The sportsbook's total goals scored over under for the game |
| OverPayout | integer (32) | NULL | Yes | The sportsbook's payout for the over |
| UnderPayout | integer (32) | NULL | Yes | The sportsbook's payout for the under |
| SportsbookID | integer (32) | NULL | No | The unique ID of the sportsbook |
| SportsbookUrl | string (500) | NULL | No | The URL for sportsbook event |
| OddType | string (32) | NULL | No | The market type of the odd (ex: live, pregame, 1st-pd, etc) |
| GameOddOutcomeResults | GameOddOutcome[] | NULL | No | List of outcomes showing results of betting markets that were bet on for the given game |
GoalieDepthChart
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| TeamID | integer (32) | NOT NULL | No | The unique ID of the team |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team this player is employed by |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| Name | string (32) | NULL | No | The full name of the goaltender |
| DepthType | string (10) | NULL | No | Indicates whether it is a goalie tandem or not for a goalie depth chart (returns Tandem; Regular) |
| DisplayType | string (10) | NULL | No | If the goalie depth chart is displayed as a Tandem or as Regular |
| DepthOrder | integer (32) | NULL | No | The order of the goalie in the team's depth chart |
| Created | datetime | NULL | No | The timestamp of when this depth chart was last edited; based on US Eastern Time (EST/EDT) |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (in US Eastern Time) |
Goaltender
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerID from 2021 | integer (32) | NOT NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| TeamID from 2021 | integer (32) | NOT NULL | No | The unique ID of the team |
| Team from 2021 | string (32) | NOT NULL | No | The abbreviation [Key] of the team the goaltender belongs to |
| FirstName from 2021 | string (32) | NOT NULL | No | The first name of the goaltender |
| LastName from 2021 | string (32) | NOT NULL | No | The goaltender's last name |
| Jersey from 2021 | integer (32) | NULL | Yes | The goaltender's jersey number |
| Confirmed from 2021 | bool (32) | NOT NULL | No | Indicates whether the starting goaltender is projected or confirmed |
Headshot
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerID | integer (32) | NOT NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| Name | string (100) | NULL | No | The player's full name |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team the player belongs to |
| Position | string (10) | NULL | No | The player's primary position. Possible values: C; RW; LW; D; or G. |
| PreferredHostedHeadshotUrl | string (500) | NULL | Yes | The player's preferred hosted headshot URL. This returns the headshot with transparent background, if available. |
| PreferredHostedHeadshotUpdated | datetime | NULL | No | The last updated date of the player's preferred hosted headshot. |
| HostedHeadshotWithBackgroundUrl | string (500) | NULL | Yes | The player's hosted headshot URL |
| HostedHeadshotWithBackgroundUpdated | datetime | NULL | No | The last updated date of the player's hosted headshot |
| HostedHeadshotNoBackgroundUrl | string (500) | NULL | Yes | The player's transparent background hosted headshot URL |
| HostedHeadshotNoBackgroundUpdated | datetime | NULL | No | The last updated date of the player's transparent background hosted headshot |
MatchupTrends
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| UpcomingGame from 2020 | Game | NULL | No | Upcoming game between the team and the opponent |
| TeamTrends from 2020 | TeamTrends[] | NULL | No | The collection of team trends between each team |
| TeamMatchupTrends from 2020 | TeamGameTrends[] | NULL | No | The collection of team game trends against opponent |
| OpponentMatchupTrends from 2020 | TeamGameTrends[] | NULL | No | The collection of opponent game trends against a specific team |
| PreviousGames from 2020 | Game[] | NULL | No | The collection of last 10 game scores between each team |
News
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| NewsID | integer (32) | NOT NULL | No | The unique ID of the news story |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| Team | string (50) | NULL | No | The abbreviation [Key] of the team |
| Title | string (50) | NULL | No | The title of the news story |
| Content | string (50) | NULL | No | The full body content of the story |
| Url | string (250) | NULL | No | The URL of the full news story |
| Source | string (50) | NULL | No | The source of the story (RotoBaller, NBCSports.com, etc.) |
| TermsOfUse | string (50) | NULL | No | The terms of use with using this news item, credit must be given to the originator of the story when specified in the terms of use |
| Updated | date | NULL | No | The timestamp of when the news story was last updated |
| TimeAgo | string (50) | NULL | No | A description of how long ago this content was published |
OpponentSeason
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stat |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 5=AllStar; 6=Exhibition) |
| Season | integer (32) | NULL | No | The NHL regular season for which these totals apply |
| Name | string (50) | NULL | No | The opponent team's full name (ex. Minnesota Wild; New York Islanders) |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Wins | integer (10) | NULL | No | Total number of wins by the opposing team in the season |
| Losses | integer (10) | NULL | No | Total losses by the opposing team in the season |
| OvertimeLosses | integer (10) | NULL | No | Total number of overtime losses by the opposing team |
| OpponentPosition | string (10) | NULL | No | Indicates which position is included in opponent stats that are aggregated together |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues |
| OpponentStat | OpponentSeason | NULL | No | The aggregated season stats for this team's opponents |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (in US Eastern Time) |
| Games | integer (32) | NULL | No | Total games played by the opposing team in the season |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points scored by the opposing team in the season |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total FanDuel fantasy points scored by the opposing team in the season |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings fantasy points scored by the opposing team in the season |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total Yahoo fantasy points scored by the opposing team in the season |
| Minutes | integer (32) | NULL | Yes | Total minutes played by the opposing team in the season |
| Seconds | integer (32) | NULL | Yes | Total seconds played by the opposing team in the season |
| Goals | decimal (32) | NULL | Yes | Total goals scored by the opposing team in the season |
| Assists | decimal (32) | NULL | Yes | Total assists by the opposing team in the season |
| ShotsOnGoal | decimal (32) | NULL | Yes | Total shots on goal by the opposing team in the season |
| PowerPlayGoals | decimal (32) | NULL | Yes | Total power play goals by the opposing team in the season |
| ShortHandedGoals | decimal (32) | NULL | Yes | Total short handed goals by the opposing team in the game |
| EmptyNetGoals | decimal (32) | NULL | Yes | Total empty net goals by the opposing team in the season |
| PowerPlayAssists | decimal (32) | NULL | Yes | Total power play assists by the opposing team in the season |
| ShortHandedAssists | decimal (32) | NULL | Yes | Total short handed assists by the opposing team in the game |
| HatTricks | decimal (32) | NULL | Yes | Total number of hat tricks by the opposing team in the season |
| ShootoutGoals | decimal (32) | NULL | Yes | Total shootout goals by the opposing team in the season |
| PlusMinus | decimal (32) | NULL | Yes | Total plus/minus by the opposing team in the season |
| PenaltyMinutes | decimal (32) | NULL | Yes | Total penalty minutes by the opposing team in the season |
| Blocks | decimal (32) | NULL | Yes | Total blocked shots by the opposing team in the season |
| Hits | decimal (32) | NULL | Yes | Total hits by the opposing team in the season |
| Takeaways | decimal (32) | NULL | Yes | Total takeaways by the team in the season |
| Giveaways | decimal (32) | NULL | Yes | Total giveaways by the opposing team in the season |
| FaceoffsWon | decimal (32) | NULL | Yes | Total faceoffs won by the opposing team in the season |
| FaceoffsLost | decimal (32) | NULL | Yes | Total faceoffs lost by the opposing team in the season |
| Shifts | decimal (32) | NULL | Yes | Total shifts by the opposing team in the season |
| GoaltendingMinutes | integer (32) | NULL | Yes | Total goaltending minutes played by the opposing team in the season |
| GoaltendingSeconds | integer (32) | NULL | Yes | Total goaltending seconds played by the opposing team in the season |
| GoaltendingShotsAgainst | decimal (32) | NULL | Yes | Total goaltending shots against by the opposing team in the season |
| GoaltendingGoalsAgainst | decimal (32) | NULL | Yes | Total goals allowed by the opposing team in the season |
| GoaltendingSaves | decimal (32) | NULL | Yes | Total goaltending saves by the opposing team in the season |
| GoaltendingWins | decimal (32) | NULL | Yes | Total goaltending wins by the opposing team in the season |
| GoaltendingLosses | decimal (32) | NULL | Yes | Total goaltending losses by the opposing team in the season |
| GoaltendingShutouts | decimal (32) | NULL | Yes | Total goaltending shutouts by the opposing team in the season |
| Started from 2017 | integer (32) | NULL | No | This field is expected to be NULL |
| BenchPenaltyMinutes | decimal (32) | NULL | Yes | Total bench penalty minutes by the opposing team in the season |
| GoaltendingOvertimeLosses | decimal (32) | NULL | Yes | Total goaltending overtime losses by the opposing team in the season |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Total FantasyDraft fantasy points scored by the opposing team in the season |
Penalty
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PenaltyID | integer (32) | NOT NULL | No | The unique ID of this penalty |
| PeriodID | integer (32) | NOT NULL | No | The unique ID of the period during which this penalty occurred |
| Sequence | integer (32) | NULL | No | The sequence/order that this penalty happened |
| TimeRemainingMinutes | integer (32) | NULL | No | Number of minutes that have passed in the current period. NOTE: this field name might be misleading as it actually represents the game clock minutes which are the number of minutes that have already passed in the period. |
| TimeRemainingSeconds | integer (32) | NULL | No | Number of seconds that have passed in the current period. NOTE: this field name might be misleading as it actually represents the game clock seconds which are the number of minutes that have already passed in the period. |
| Description | string (50) | NULL | Yes | The description of the penalty |
| PenaltyMinutes | integer (32) | NULL | No | Total minutes the penalty lasts |
| PenalizedTeamID | integer (32) | NULL | Yes | The TeamID of the team who committed the penalty |
| PenalizedPlayerID | integer (32) | NULL | Yes | The PlayerID of the player who committed the penalty |
| DrawnByTeamID | integer (32) | NULL | Yes | The TeamID of the player/team that drew the penalty |
| DrawnByPlayerID | integer (32) | NULL | Yes | The PlayerID of the player who drew the penalty |
| IsBenchPenalty | boolean | NULL | No | Whether or not the penalty is a bench penalty |
| BenchPenaltyServedByPlayerID | integer (32) | NULL | No | The PlayerID of the player who served the bench penalty |
Period
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PeriodID | integer (32) | NOT NULL | No | The unique ID associated of this period |
| GameID | integer (32) | NOT NULL | No | The unique ID of this game tied to this period |
| Name | string (10) | NOT NULL | No | The name of the period (possible values: 1; 2; 3; SO; OT; OT2; OT3; OT4; etc) |
| AwayScore | integer (32) | NULL | Yes | Total goals scored by the away team in a given period |
| HomeScore | integer (32) | NULL | Yes | Total goals scored by the home team in the period |
| ScoringPlays | ScoringPlay[] | NULL | No | The details of the scoring plays that occurred during this period |
| Penalties | Penalty[] | NULL | No | The details of the penalties that occurred during this period |
Play
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayID from 2017 | integer (32) | NOT NULL | No | The unique ID of the play |
| PeriodID from 2017 | integer (32) | NOT NULL | No | The unique ID of the period during which this play occurred |
| PeriodName from 2017 | string (10) | NOT NULL | No | The name of the period that this play occurred in |
| Sequence from 2017 | integer (32) | NOT NULL | No | The order in which this play happened over the course of the game |
| ClockMinutes from 2017 | integer (32) | NULL | No | The number of minutes passed in the period when this play completed |
| ClockSeconds from 2017 | integer (32) | NULL | No | The number of seconds passed in the period when this play completed |
| AwayTeamScore from 2017 | integer (32) | NULL | No | The score of the away team after the play ended |
| HomeTeamScore from 2017 | integer (32) | NULL | No | The score of the home team after the play ended |
| TeamID from 2017 | integer (32) | NULL | No | The unique ID of the team |
| Team from 2017 | string (10) | NULL | No | The abbreviation [Key] of the team associated with this play |
| OpponentID from 2017 | integer (32) | NULL | No | The unique ID of the team's opponent associated with this play |
| Opponent from 2017 | string (10) | NULL | No | The abbreviation [Key] of the opponent team |
| Category from 2017 | string (20) | NULL | Yes | The category of the play. Possible values: Block; Faceoff; Goal; Hit; Penalty; Period; Shootout; Shot; Stoppage; Turnover |
| Type from 2017 | string (20) | NULL | 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) | NULL | Yes | The description of the play (example: Sidney Crosby won faceoff against Aaron Ekblad) |
| PlayerID from 2017 | integer (32) | NULL | Yes | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| Updated from 2017 | datetime | NULL | No | The timestamp of when the play was last updated (in US Eastern Time) |
| Created from 2017 | datetime | NULL | No | The database generated timestamp of when this play was first created; based on US Eatern Time (EST/EDT) |
| FirstAssistedByPlayerID from 2017 | integer (32) | NULL | Yes | The PlayerID of the player who got the first assist on this play (if applicable) |
| SecondAssistedByPlayerID from 2017 | integer (32) | NULL | Yes | The PlayerID of the player who got the second assist on this play (if applicable) |
| PowerPlayTeamID from 2017 | integer (32) | NULL | Yes | The unique TeamID of the team on the power play this play (if any) |
| PowerPlayTeam from 2017 | string (10) | NULL | Yes | The abbreviation [Key] of the team on the power play this play (if any) |
| OpposingPlayerID from 2017 | integer (32) | NULL | Yes | The PlayerID of the player involved in the play on the opposing team |
PlayByPlay
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Game from 2017 | Game | NULL | No | The details of the game associated with this play-by-play |
| Plays from 2017 | Play[] | NULL | No | List of Plays in the game |
Player
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerID | integer (32) | NOT NULL | No | "The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career" |
| FirstName | string (50) | NULL | No | The first name of the player |
| LastName | string (50) | NULL | No | The player's last name |
| Status | string (50) | NULL | No | The player's current status. Possible values include Active; Inactive; Injured Reserve; Minors; Suspended; Bereavement; Paternity |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team this player is employed by |
| Position | string (10) | NULL | No | The player's primary position. Possible values: C, RW, LW, D, or G. |
| Jersey | integer (32) | NULL | No | The player's jersey number |
| Catches | string (1) | NULL | No | The hand in which the player uses to catch the puck (Right or Left). Note: This field will be null for non-goaltenders |
| Shoots | string (1) | NULL | No | The hand the player shoots the puck with (right or left) |
| Height | integer (32) | NULL | No | The player's height in inches |
| Weight | integer (32) | NULL | No | The player's weight in pounds (lbs). |
| BirthDate | datetime | NULL | No | The player's date of birth |
| BirthCity | string (50) | NULL | No | The city in which the player was born |
| BirthState | string (50) | NULL | No | The US state in which the player was born. NOTE: If a player was born outside of North America or Australia, this field will be null |
| PhotoUrl | string (250) | NULL | No | This field is deprecated. Photos are no longer available through it. Headshots are now delivered through IMAGN. Please see our Headshots products for further information. |
| SportRadarPlayerID | string (50) | NULL | No | The player's cross reference PlayerID to the SportRadar API. |
| RotoworldPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to the Rotoworld news feed |
| RotoWirePlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to the RotoWire news feed |
| FantasyAlarmPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to the FantasyAlarm news feed |
| StatsPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to the STATS data feeds |
| SportsDirectPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to the SportsDirect data feeds, now part of Nielsen GraceNote. |
| XmlTeamPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to the XML Team data feeds. |
| InjuryStatus | string (50) | NULL | Yes | The player's current injury status; in the form of likelihood that player plays. Possible values: Probable; Questionable; Doubtful; Out |
| InjuryBodyPart | string (50) | NULL | Yes | The body part that is injured for the player (Knee; Groin; Calf; Upper-body; etc.) |
| InjuryStartDate | date | NULL | No | The day that the injury started or was first discovered |
| InjuryNotes | string (250) | NULL | Yes | Brief description of the player's injury and expected availability |
| FanDuelPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to FanDuel |
| DraftKingsPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to DraftKings |
| YahooPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to Yahoo Daily Fantasy Sports Contests. |
| FanDuelName | string (50) | NULL | No | The player's full name in FanDuel's daily fantasy sports platform |
| DraftKingsName | string (50) | NULL | No | The player's full name in DraftKings' daily fantasy sports platform |
| YahooName | string (50) | NULL | No | The player's full name in Yahoo's daily fantasy sports platform. |
| DepthChartPosition | string (10) | NULL | No | The position of the player in the team's depth chart |
| DepthChartOrder | integer (32) | NULL | Yes | The order of the player in the team's depth chart |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| FantasyDraftName | string (50) | NULL | No | The player's full name in FantasyDraft's daily fantasy sports platform |
| FantasyDraftPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to FantasyDraft |
| UsaTodayPlayerID | integer (32) | NULL | No | The player's cross reference PlayerID to USA Today headshot data feeds. |
| UsaTodayHeadshotUrl | string (100) | NULL | No | The player's headshot URL as provided by USA Today. License from USA Today is required. |
| UsaTodayHeadshotNoBackgroundUrl | string (100) | NULL | No | The player's transparent background headshot URL as provided by USA Today. License from USA Today is required. |
| UsaTodayHeadshotUpdated | datetime | NULL | No | The last updated date of the player's headshot as provided by USA Today. License from USA Today is required. |
| UsaTodayHeadshotNoBackgroundUpdated | datetime | NULL | No | The last updated date of the player's transparent background headshot as provided by USA Today. License from USA Today is required. |
PlayerBasic
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerID | integer (32) | NOT NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| FirstName | string (50) | NULL | No | The first name of the player |
| LastName | string (50) | NULL | No | The player's last name |
| Status | string (10) | NULL | No | The player's current status. Possible values include Active; Inactive; Injured Reserve; Minors; Suspended; Bereavement; Paternity |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team this player is employed by |
| Position | string (10) | NULL | No | The player's primary position. Possible values: C, RW, LW, D, or G. |
| Jersey | integer (32) | NULL | No | The player's jersey number |
| Height | integer (32) | NULL | No | The player's height in inches |
| Weight | integer (32) | NULL | No | The player's weight in pounds (lbs) |
| BirthDate | datetime | NULL | No | The player's date of birth |
| BirthCity | string (50) | NULL | No | The city in which the player was born |
| BirthState | string (50) | NULL | No | The US state in which the player was born. NOTE: If a player was born outside of North America or Australia, this field will be null |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
PlayerGame
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stat |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 5=AllStar; 6=Exhibition) |
| Season | integer (32) | NULL | No | The NHL season of the game |
| Name | string (50) | NULL | Yes | The player's full name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Position | string (10) | NULL | No | The player's primary position. Possible values: C; RW; LW; D; or G |
| FantasyDataSalary from 2016 | integer (32) | NULL | Yes | The player's salary as calculated by SportsDataIO (formerly known as FantasyData). Based on the same salary cap as DraftKings contests ($50,000) |
| FanDuelSalary from 2016 | integer (32) | NULL | Yes | The player's salary for FanDuel daily fantasy contests |
| DraftKingsSalary from 2016 | integer (32) | NULL | Yes | The player's salary for DraftKings daily fantasy contests |
| YahooSalary from 2016 | integer (32) | NULL | Yes | The player's salary for Yahoo daily fantasy contests. |
| InjuryStatus from 2016 | string (50) | NULL | Yes | The player's current injury status; in the form of likelihood that player plays. Possible values: Probable; Questionable; Doubtful; Out |
| InjuryBodyPart from 2016 | string (50) | NULL | Yes | The body part that is injured for the player (Knee; Groin; Calf; Upper-body; etc.) |
| InjuryStartDate from 2016 | date | NULL | No | The day that the injury started or was first discovered |
| InjuryNotes from 2016 | string (250) | NULL | Yes | Brief description of the player's injury and expected availability |
| FanDuelPosition from 2016 | string (10) | NULL | No | The player's eligible position in FanDuel's daily fantasy sports platform |
| DraftKingsPosition from 2016 | string (10) | NULL | No | The player's eligible position in DraftKings' daily fantasy sports platform |
| YahooPosition from 2016 | string (10) | NULL | No | The player's eligible position in Yahoo's daily fantasy sports platform. |
| OpponentRank from 2016 | integer (32) | NULL | Yes | The ranking of the player's opponent with regards to fantasy points allowed |
| OpponentPositionRank from 2016 | integer (32) | NULL | Yes | The ranking of the player's opponent by position with regards to fantasy points allowed |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues |
| FantasyDraftSalary from 2016 | integer (32) | NULL | Yes | The player's salary for FantasyDraft daily fantasy contests |
| FantasyDraftPosition from 2016 | string (10) | NULL | Yes | The player's eligible position in Fantasy Drafts daily fantasy sports platform. |
| EvenStrengthMinutes | int (32) | NULL | Yes | The number of minutes played at even strength by the player in the game |
| EvenStrengthSeconds | int (32) | NULL | Yes | The number of seconds played at even strength by the player in the game |
| PowerPlayMinutes | int (32) | NULL | Yes | Total minutes played by the player on the power play in the game |
| PowerPlaySeconds | int (32) | NULL | Yes | The number of seconds (remainder after minutes) played on a Power Play |
| ShortHandedMinutes | int (32) | NULL | Yes | The number of minutes played short handed by the player in the game |
| ShortHandedSeconds | int (32) | NULL | Yes | The number of seconds (remainder after minutes) played short handed by the player in the game |
| Points | decimal (32) | NULL | Yes | Total points for the player in the game. Note: points are calculated by adding up a player's goals and assists |
| GameID | integer (32) | NULL | No | The unique ID of the game tied to this PlayerGame record |
| OpponentID | integer (32) | NULL | No | The unique ID of the team's opponent |
| Opponent | string (10) | NULL | No | The abbreviation [Key] of the opponent team |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in US Eastern Time) |
| HomeOrAway | string (4) | NULL | No | Indicates whether the team is home or away |
| IsGameOver | boolean | NOT NULL | No | Whether the game is over (returns true/false) |
| GlobalGameID | integer (32) | NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues |
| GlobalOpponentID | integer (32) | NULL | No | A globally unique ID for this team's opponent. This value is guaranteed to be unique across all sports/leagues |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (in US Eastern Time) |
| Games | integer (32) | NULL | No | Total games played by the player in the game. NOTE: this will be 1 or 0 for single game feeds |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the player in the game |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total FanDuel daily fantasy points by the player in the game |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings daily fantasy points by the player in the game |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total Yahoo daily fantasy points by the player in the game |
| Minutes | integer (32) | NULL | Yes | Total minutes played by the player in the game |
| Seconds | integer (32) | NULL | Yes | Total seconds played by the player in the game |
| Goals | decimal (32) | NULL | Yes | Total goals scored by the player in the game |
| Assists | decimal (32) | NULL | Yes | Total assists by the player in the game |
| ShotsOnGoal | decimal (32) | NULL | Yes | Total shots on goal by the player in the game |
| PowerPlayGoals | decimal (32) | NULL | Yes | Total power play goals by the player in the game |
| ShortHandedGoals | decimal (32) | NULL | Yes | Total short handed goals by the player in the game |
| EmptyNetGoals | decimal (32) | NULL | Yes | Total number of empty net goals by the player in the game |
| PowerPlayAssists | decimal (32) | NULL | Yes | Total power play assists by the player in the game |
| ShortHandedAssists | decimal (32) | NULL | Yes | Total short handed assists by the player in the game |
| HatTricks | decimal (32) | NULL | Yes | Total hat tricks by the player in the game |
| ShootoutGoals | decimal (32) | NULL | Yes | Total shootout goals by the player in the game |
| PlusMinus | decimal (32) | NULL | Yes | Total plus/minus by the player in the game |
| PenaltyMinutes | decimal (32) | NULL | Yes | Total penalty minutes by the player in the game |
| Blocks | decimal (32) | NULL | Yes | Total blocked shots by the player in the game |
| Hits | decimal (32) | NULL | Yes | Total hits by the player in the game |
| Takeaways | decimal (32) | NULL | Yes | Total takeaways by the player in the game |
| Giveaways | decimal (32) | NULL | Yes | Total giveaways by the player in the game |
| FaceoffsWon | decimal (32) | NULL | Yes | Total faceoffs won by the player in the game |
| FaceoffsLost | decimal (32) | NULL | Yes | Total faceoffs lost by the player in the game |
| Shifts | decimal (32) | NULL | Yes | Total shifts by the player in the game |
| GoaltendingMinutes | integer (32) | NULL | Yes | Total goaltending minutes played by the player in the game |
| GoaltendingSeconds | integer (32) | NULL | Yes | Total goaltending seconds played by the player in the game |
| GoaltendingShotsAgainst | decimal (32) | NULL | Yes | Total goaltending shots against the player in the game |
| GoaltendingGoalsAgainst | decimal (32) | NULL | Yes | Total goals allowed by the player in the game |
| GoaltendingSaves | decimal (32) | NULL | Yes | Total goaltending saves by the player in the game |
| GoaltendingWins | decimal (32) | NULL | Yes | Total goaltending wins by the player in the game |
| GoaltendingLosses | decimal (32) | NULL | Yes | Total goaltending losses by the player in the game |
| GoaltendingShutouts | decimal (32) | NULL | Yes | Total goaltending shutouts by the player in the game |
| Started from 2017 | integer (32) | NULL | No | Indicates whether or not the player started the game. Note: this will be one or zero for single game feeds |
| BenchPenaltyMinutes | decimal (32) | NULL | Yes | Total bench penalty minutes by the player in the game. NOTE: Bench penalties are assigned to teams. This will always be 0 for players |
| GoaltendingOvertimeLosses | decimal (32) | NULL | Yes | Total goaltending overtime losses by the player in the game |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Total FantasyDraft daily fantasy points by the player in the game |
PlayerGameBasic
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (in US Eastern Time) |
| Games | integer (32) | NULL | No | Total games played by the player in the game. NOTE: this will be 1 or 0 for single game feeds |
| Minutes | integer (32) | NULL | Yes | Total minutes played by the player in the game |
| Seconds | integer (32) | NULL | Yes | Total seconds played by the player in the game |
| Goals | decimal (32) | NULL | Yes | Total goals scored by the player in the game |
| Assists | decimal (32) | NULL | Yes | Total assists by the player in the game |
| ShotsOnGoal | decimal (32) | NULL | Yes | Total shots on goal by the player in the game |
| PowerPlayGoals | decimal (32) | NULL | Yes | Total power play goals by the player in the game |
| ShortHandedGoals | decimal (32) | NULL | Yes | Total short handed goals by the player in the game |
| EmptyNetGoals | decimal (32) | NULL | Yes | Total number of empty net goals by the player in the game |
| PowerPlayAssists | decimal (32) | NULL | Yes | Total power play assists by the player in the game |
| ShortHandedAssists | decimal (32) | NULL | Yes | Total short handed assists by the player in the game |
| HatTricks | decimal (32) | NULL | Yes | Total hat tricks by the player in the game |
| ShootoutGoals | decimal (32) | NULL | Yes | Total shootout goals by the player in the game |
| PlusMinus | decimal (32) | NULL | Yes | Total plus/minus by the player in the game |
| PenaltyMinutes | decimal (32) | NULL | Yes | Total penalty minutes by the player in the game |
| Blocks | decimal (32) | NULL | Yes | Total blocked shots by the player in the game |
| Hits | decimal (32) | NULL | Yes | Total hits by the player in the game |
| Takeaways | decimal (32) | NULL | Yes | Total takeaways by the player in the game |
| Giveaways | decimal (32) | NULL | Yes | Total giveaways by the player in the game |
| FaceoffsWon | decimal (32) | NULL | Yes | Total faceoffs won by the player in the game |
| FaceoffsLost | decimal (32) | NULL | Yes | Total faceoffs lost by the player in the game |
| Shifts | decimal (32) | NULL | Yes | Total shifts by the player in the game |
| GoaltendingMinutes | integer (32) | NULL | Yes | Total goaltending minutes played by the player in the game |
| GoaltendingSeconds | integer (32) | NULL | Yes | Total goaltending seconds played by the player in the game |
| GoaltendingShotsAgainst | decimal (32) | NULL | Yes | Total goaltending shots against the player in the game |
| GoaltendingGoalsAgainst | decimal (32) | NULL | Yes | Total goals allowed by the player in the game |
| GoaltendingSaves | decimal (32) | NULL | Yes | Total goaltending saves by the player in the game |
| GoaltendingWins | decimal (32) | NULL | Yes | Total goaltending wins by the player in the game |
| GoaltendingLosses | decimal (32) | NULL | Yes | Total goaltending losses by the player in the game |
| GoaltendingShutouts | decimal (32) | NULL | Yes | Total goaltending shutouts by the player in the game |
| Started | integer (32) | NULL | No | Indicates whether or not the player started the game Note: this will be one or zero for single game feedsIndicates whether or not the player started the game. Note: this will be one or zero for single game feeds |
| BenchPenaltyMinutes | decimal (32) | NULL | Yes | Total bench pentalty minutes by the player in the game. NOTE: Bench penalties are assigned to teams. This will always be 0 for players |
| GoaltendingOvertimeLosses | decimal (32) | NULL | Yes | Total goaltending overtime losses by the player in the game |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game in US Eastern Time |
| HomeOrAway | string (4) | NULL | No | Indicates whether the team is home or away |
| IsGameOver | boolean | NOT NULL | No | Whether the game is over (returns true/false) |
| GlobalGameID | integer (32) | NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| GlobalOpponentID | integer (32) | NULL | No | A globally unique ID for this team's opponent. This value is guaranteed to be unique across all sports/leagues. |
| StatID | integer (32) | NOT NULL | No | The unique ID of the stat |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 5=AllStar; 6=Exhibition) |
| Season | integer (32) | NULL | No | The NHL season of the game |
| Name | string (50) | NULL | No | The player's full name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Position | string (10) | NULL | No | The player's primary position. Possible values: C; RW; LW; D; or G |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| Points | decimal (32) | NULL | No | Total points for the player in the game. Note: Points are calcuated by adding up a player's goals and assists |
PlayerGameProjection
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stat |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 5=AllStar; 6=Exhibition) |
| Season | integer (32) | NULL | No | The NHL season of the game |
| Name | string (50) | NULL | Yes | The player's full name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Position | string (10) | NULL | No | The player's primary position. Possible values: C; RW; LW; D; or G |
| FantasyDataSalary from 2016 | integer (32) | NULL | Yes | The player's salary as calculated by SportsDataIO (formerly known as FantasyData). Based on the same salary cap as DraftKings contests ($50,000) |
| FanDuelSalary from 2016 | integer (32) | NULL | Yes | The player's salary for FanDuel daily fantasy contests |
| DraftKingsSalary from 2016 | integer (32) | NULL | Yes | The player's salary for DraftKings daily fantasy contests |
| YahooSalary from 2016 | integer (32) | NULL | Yes | The player's salary for Yahoo daily fantasy contests |
| InjuryStatus from 2016 | string (50) | NULL | Yes | The player's current injury status; in the form of likelihood that player plays. Possible values: Probable; Questionable; Doubtful; Out |
| InjuryBodyPart from 2016 | string (50) | NULL | Yes | The body part that is injured for the player (Knee; Groin; Calf; Upper-body; etc.) |
| InjuryStartDate from 2016 | date | NULL | No | The day that the injury started or was first discovered |
| InjuryNotes from 2016 | string (250) | NULL | Yes | Brief description of the player's injury and expected availability |
| FanDuelPosition from 2016 | string (10) | NULL | No | The player's eligible position in FanDuel's daily fantasy sports platform |
| DraftKingsPosition from 2016 | string (10) | NULL | No | The player's eligible position in DraftKings' daily fantasy sports platform |
| YahooPosition from 2016 | string (10) | NULL | No | The player's eligible position in Yahoo's daily fantasy sports platform |
| OpponentRank from 2016 | integer (32) | NULL | Yes | The ranking of the player's opponent with regards to fantasy points allowed |
| OpponentPositionRank from 2016 | integer (32) | NULL | Yes | The ranking of the player's opponent by position with regards to fantasy points allowed |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues |
| FantasyDraftSalary from 2016 | integer (32) | NULL | Yes | The player's salary for FantasyDraft daily fantasy contests |
| FantasyDraftPosition from 2016 | string (10) | NULL | Yes | The player's eligible position in FantasyDrafts daily fantasy sports platform |
| EvenStrengthMinutes | int (32) | NULL | Yes | The projected number of minutes played at even strength by the player in the game |
| EvenStrengthSeconds | int (32) | NULL | Yes | The projected number of seconds played at even strength by the player in the game |
| PowerPlayMinutes | int (32) | NULL | Yes | Total projected minutes played by the player on the power play in the game |
| PowerPlaySeconds | int (32) | NULL | Yes | Total projected seconds (remainder after minutes) played by the player on the power play in the game |
| ShortHandedMinutes | int (32) | NULL | Yes | The projected number of minutes played short handed by the player in the game |
| ShortHandedSeconds | int (32) | NULL | Yes | The projected number of seconds (remainder after minutes) played short handed by the player in the game |
| Points | decimal (32) | NULL | Yes | Total projected points for the player in the game. Note: Points are calcuated by adding up a player's goals and assists |
| GameID | integer (32) | NULL | No | The unique ID of the game tied to this PlayerGameProjection record |
| OpponentID | integer (32) | NULL | No | The unique ID of the team's opponent |
| Opponent | string (10) | NULL | No | The abbreviation [Key] of the opponent team |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in US Eastern Time) |
| HomeOrAway | string (4) | NULL | No | Indicates whether the team is home or away |
| IsGameOver | boolean | NOT NULL | No | Whether the game is over (returns true/false) |
| GlobalGameID | integer (32) | NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues |
| GlobalOpponentID | integer (32) | NULL | No | A globally unique ID for this team's opponent. This value is guaranteed to be unique across all sports/leagues |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (in US Eastern Time) |
| Games | integer (32) | NULL | No | Total projected games played by the player in the game. NOTE: this will be 1 or 0 for single game feeds |
| FantasyPoints | decimal (32) | NULL | Yes | Total projected fantasy points by the player in the game |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total projected FanDuel daily fantasy points by the player in the game |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total projected DraftKings daily fantasy points by the player in the game |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total projected Yahoo daily fantasy points by the player in the game |
| Minutes | integer (32) | NULL | Yes | Total projected minutes played by the player in the game |
| Seconds | integer (32) | NULL | Yes | Total projected seconds played by the player in the game |
| Goals | decimal (32) | NULL | Yes | Total projected goals scored by the player in the game |
| Assists | decimal (32) | NULL | Yes | Total projected assists by the player in the game |
| ShotsOnGoal | decimal (32) | NULL | Yes | Total projected shots on goal by the player in the game |
| PowerPlayGoals | decimal (32) | NULL | Yes | Total projected power play goals by the team in the game |
| ShortHandedGoals | decimal (32) | NULL | Yes | Total projected short handed goals by the player in the game |
| EmptyNetGoals | decimal (32) | NULL | Yes | Total projected number of empty net goals by the player in the game |
| PowerPlayAssists | decimal (32) | NULL | Yes | Total projected power play assists by the team in the game |
| ShortHandedAssists | decimal (32) | NULL | Yes | Total projected short handed assists by the player in the game |
| HatTricks | decimal (32) | NULL | Yes | Total projected hat tricks by the team in the game |
| ShootoutGoals | decimal (32) | NULL | Yes | Total projected shootout goals by the player in the game |
| PlusMinus | decimal (32) | NULL | Yes | Total projected plus/minus by the player in the game |
| PenaltyMinutes | decimal (32) | NULL | Yes | Total projected penalty minutes by the player in the game |
| Blocks | decimal (32) | NULL | Yes | Total projected blocked shots by the player in the game |
| Hits | decimal (32) | NULL | Yes | Total projected hits by the player in the game |
| Takeaways | decimal (32) | NULL | Yes | Total projected takeaways by the player in the game |
| Giveaways | decimal (32) | NULL | Yes | Total projected giveaways by the player in the game |
| FaceoffsWon | decimal (32) | NULL | Yes | Total projected faceoffs won by the player in the game |
| FaceoffsLost | decimal (32) | NULL | Yes | Total projected faceoffs lost by the player in the game |
| Shifts | decimal (32) | NULL | Yes | Total projected shifts by the player in the game |
| GoaltendingMinutes | integer (32) | NULL | Yes | Total projected goaltending minutes played by the player in the game |
| GoaltendingSeconds | integer (32) | NULL | Yes | Total goaltending seconds played by the player in the season |
| GoaltendingShotsAgainst | decimal (32) | NULL | Yes | Total projected goaltending shots against the player in the game |
| GoaltendingGoalsAgainst | decimal (32) | NULL | Yes | Total projected goals allowed by the player in the game |
| GoaltendingSaves | decimal (32) | NULL | Yes | Total projected goaltending saves by the player in the game |
| GoaltendingWins | decimal (32) | NULL | Yes | Total projected goaltending wins by the player in the game |
| GoaltendingLosses | decimal (32) | NULL | Yes | Total projected goaltending losses by the player in the game |
| GoaltendingShutouts | decimal (32) | NULL | Yes | Total projected goaltending shutouts by the player in the game |
| Started from 2017 | integer (32) | NULL | No | Indicates whether or not the player is projected to start in the game. Note: this will be one or zero for single game feeds |
| BenchPenaltyMinutes | decimal (32) | NULL | Yes | Total projected bench penalty minutes by the player in the game. NOTE: bench penalties are assigned to teams. This will always be 0 for players |
| GoaltendingOvertimeLosses | decimal (32) | NULL | Yes | Total projected goaltending overtime losses by the player in the game |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Total projected FantasyDraft daily fantasy points by the player in the game |
PlayerLine
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| LineNumber | integer (32) | NOT NULL | Yes | The line the player is on (e.g. 1, 2, 3, or 4) |
| Position | string (10) | NOT NULL | Yes | The player's primary position. Possible values: C; RW; LW; D; or G |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| Name | string (50) | NULL | No | The full name of the player on the line |
| Shoots | string (10) | NULL | Yes | The hand the player shoots the puck with (right or left) |
| LineType | string (10) | NOT NULL | No | The type of line the player is on (e.g. EvenStrength (EV); PowerPlay (PP); ShortHanded (SH)) |
PlayerSeason
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stat |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| PlayerID | integer (32) | NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 5=AllStar; 6=Exhibition) |
| Season | integer (32) | NULL | No | The NHL regular season for which these totals apply |
| Name | string (50) | NULL | No | The player's full name |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Position | string (10) | NULL | No | The player's primary position. Possible values: C; RW; LW; D; or G |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (in US Eastern Time) |
| Games | integer (32) | NULL | No | Total games played by the player in the season |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the player in the season |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total FanDuel daily fantasy points by the player in the season |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings daily fantasy points by the player in the season |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total Yahoo daily fantasy points by the player in the season |
| Minutes | integer (32) | NULL | Yes | Total minutes played by the player in the season |
| Seconds | integer (32) | NULL | Yes | Total seconds played by the player in the season |
| Goals | decimal (32) | NULL | Yes | Total goals scored by the player in the season |
| Assists | decimal (32) | NULL | Yes | Total assists by the player in the season |
| ShotsOnGoal | decimal (32) | NULL | Yes | Total shots on goal by the player in the season |
| PowerPlayGoals | decimal (32) | NULL | Yes | Total power play goals by the player in the season |
| ShortHandedGoals | decimal (32) | NULL | Yes | Total short handed goals by the player in the season |
| EmptyNetGoals | decimal (32) | NULL | Yes | Total number of empty net goals by the player in the season |
| PowerPlayAssists | decimal (32) | NULL | Yes | Total power play assists by the player in the season |
| ShortHandedAssists | decimal (32) | NULL | Yes | Total short handed assists by the player in the season |
| HatTricks | decimal (32) | NULL | Yes | Total hat tricks by the player in the season |
| ShootoutGoals | decimal (32) | NULL | Yes | Total shootout goals by the player in the season |
| PlusMinus | decimal (32) | NULL | Yes | Total plus/minus by the player in the season |
| PenaltyMinutes | decimal (32) | NULL | Yes | Total penalty minutes by the player in the season |
| Blocks | decimal (32) | NULL | Yes | Total blocked shots by the player in the season |
| Hits | decimal (32) | NULL | Yes | Total hits by the player in the season |
| Takeaways | decimal (32) | NULL | Yes | Total takeaways by the player in the season |
| Giveaways | decimal (32) | NULL | Yes | Total giveaways by the player in the season |
| FaceoffsWon | decimal (32) | NULL | Yes | Total faceoffs won by the player in the season |
| FaceoffsLost | decimal (32) | NULL | Yes | Total faceoffs lost by the player in the season |
| Shifts | decimal (32) | NULL | Yes | Total shifts by the player in the season |
| GoaltendingMinutes | integer (32) | NULL | Yes | Total goaltending minutes played by the player in the season |
| GoaltendingSeconds | integer (32) | NULL | Yes | Total goaltending seconds played by the player in the season |
| GoaltendingShotsAgainst | decimal (32) | NULL | Yes | Total goaltending shots against the player in the season |
| GoaltendingGoalsAgainst | decimal (32) | NULL | Yes | Total goals allowed by the player in the season |
| GoaltendingSaves | decimal (32) | NULL | Yes | Total goaltending saves by the player in the season |
| GoaltendingWins | decimal (32) | NULL | Yes | Total goaltending wins by the player in the season |
| GoaltendingLosses | decimal (32) | NULL | Yes | Total goaltending losses by the player in the season |
| GoaltendingShutouts | decimal (32) | NULL | Yes | Total goaltending shutouts by the player in the season |
| Started from 2017 | integer (32) | NULL | No | Total games started by the player in the season |
| BenchPenaltyMinutes | decimal (32) | NULL | Yes | Total bench pentalty minutes by the player in the season. NOTE: Bench penalties are assigned to teams. This will always be 0 for players |
| GoaltendingOvertimeLosses | decimal (32) | NULL | Yes | Total goaltending overtime losses by the player in the season |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Total FantasyDraft daily fantasy points by the player in the season |
Referee
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| RefereeID | integer (32) | NOT NULL | No | Unique ID o Referee |
| Name | string (32) | NULL | No | The referee's full name |
| Number | integer (32) | NULL | No | The number of the referee |
| Position | string (32) | NULL | No | The position of the referee in the crew |
| College | string (32) | NULL | No | The college of the referee |
| Experience | integer (32) | NULL | No | The number of years of experience the referee has in the NHL |
ScheduleBasic
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID | integer (32) | NOT NULL | No | The unique ID of this game |
| Season | integer (32) | NOT NULL | No | The NHL season of the game |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 5=AllStar; 6=Exhibition) |
| Status | string (20) | NULL | No | Indicates the game's status. Possible values include: Scheduled, InProgress, Final, F/SO, F/OT, Postponed, Canceled, NotNecessary |
| Day | date | NULL | No | The date of the game |
| DateTime | datetime | NULL | No | The date and time of the game in US Eastern Time |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (in US Eastern Time) |
| IsClosed | boolean | NULL | No | Indicates whether the game is over and the final score has been verified and closed out. Note: it is recommend for bet resulting to use IsClosed = True rather than simply Final game status |
| AwayTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the away team |
| HomeTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the home team |
| StadiumID | integer (32) | NULL | No | The unique ID of the stadium |
| AwayTeamScore | integer (32) | NULL | Yes | Total number of goals scored by the away team in the game |
| HomeTeamScore | integer (32) | NULL | Yes | Total number of goals scored by the home team in the game |
| GlobalGameID | integer (32) | NOT NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues. |
| GlobalAwayTeamID | integer (32) | NOT NULL | No | A globally unique ID for the away team. This value is guaranteed to be unique across all sports/leagues. |
| GlobalHomeTeamID | integer (32) | NOT NULL | No | A globally unique ID for the home team. This value is guaranteed to be unique across all sports/leagues. |
| GameEndDateTime | datetime | NULL | No | The date and time that the game ended in US Eastern Time |
| NeutralVenue | boolean | NULL | No | Indicates whether this game is played in a neutral venue |
| DateTimeUTC | datetime | NULL | No | The date and time of the game in UTC |
| SeriesInfo | Series (32) | NULL | No | Contains relevant series data for playoff series only - HomeTeamWins, AwayTeamWins, GameNumber, and MaxLength |
| AwayTeamID | integer (32) | NOT NULL | No | The unique ID of the away team |
| HomeTeamID | integer (32) | NOT NULL | No | The unique ID of the home team |
| RescheduledFromGameID | integer (32) | NULL | Yes | The GameID of the originally scheduled, postponed game, that this game was rescheduled from. This only pertains to games that are scheduled as "make up" games. |
| RescheduledGameID | integer (32) | NULL | Yes | The GameID of the game that was rescheduled from this game. This only pertains to postponed games that require rescheduling. |
ScoreBasic
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID | integer (32) | NOT NULL | No | The unique ID of this game |
| Season | integer (32) | NOT NULL | No | The NHL season of the game |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 5=AllStar; 6=Exhibition) |
| Status | string (20) | NULL | No | Indicates the game's status. Possible values include: Scheduled, InProgress, Final, F/SO, F/OT, Postponed, Canceled, NotNecessary |
| Day | date | NULL | No | The date of the game |
| DateTime | datetime | NULL | No | The date and time of the game in US Eastern Time |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (in US Eastern Time) |
| IsClosed | boolean | NULL | No | Indicates whether the game is over and the final score has been verified and closed out Note: it is recommend for bet resulting to use IsClosed = True rather than simply Final game status |
| AwayTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the away team |
| HomeTeam | string (10) | NOT NULL | No | The abbreviation [Key] of the home team |
| AwayTeamID | integer (32) | NOT NULL | No | The unique ID of the away team |
| HomeTeamID | integer (32) | NOT NULL | No | The unique ID of the home team |
| StadiumID | integer (32) | NULL | No | The unique ID of the stadium |
| AwayTeamScore | integer (32) | NULL | Yes | Total number of goals scored by the away team in the game |
| HomeTeamScore | integer (32) | NULL | Yes | Total number of goals scored by the home team in the game |
| GameEndDateTime | datetime | NULL | No | The date and time that the game ended in US Eastern Time |
| DateTimeUTC | datetime | NULL | No | The date and time of the game in UTC |
ScoringPlay
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| ScoringPlayID | integer (32) | NOT NULL | No | The unique ID of the scoring play |
| PeriodID | integer (32) | NOT NULL | No | The unique ID associated of this period |
| Sequence | integer (32) | NULL | No | The sequence/order that this scoring play happened |
| TimeRemainingMinutes | integer (32) | NULL | No | Number of minutes that have passed in the current period. NOTE: this field name might be misleading as it actually represents the game clock minutes which are the number of minutes that have already passed in the period. |
| TimeRemainingSeconds | integer (32) | NULL | No | Number of seconds that have passed in the current period. NOTE: this field name might be misleading as it actually represents the game clock sconds which are the number of minutes that have already passed in the period. |
| ScoredByTeamID | integer (32) | NULL | Yes | The TeamID of the team that scored the goal |
| AllowedByTeamID | integer (32) | NULL | Yes | The TeamID of the team that allowed the goal |
| ScoredByPlayerID | integer (32) | NULL | Yes | The PlayerID of the player who scored the goal |
| AssistedByPlayerID1 | integer (32) | NULL | Yes | The PlayerID of the FIRST player who assisted on the goal |
| AssistedByPlayerID2 | integer (32) | NULL | Yes | The PlayerID of the SECOND player who assisted on the goal |
| PowerPlay | boolean | NULL | No | Whether or not the goal was scored on the power play |
| ShortHanded | boolean | NULL | No | Whether the goal was scored shorthanded |
| EmptyNet | boolean | NULL | No | Whether the goal was an empty net goal or not |
| AwayTeamScore | integer | NULL | No | The score of the away team after the conclusion of the scoring play |
| HomeTeamScore | integer | NULL | No | The score of the home team after the conclusion of the scoring play |
Season
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Season | integer (32) | NOT NULL | No | The NHL regular season for which these totals apply |
| StartYear | integer (32) | NOT NULL | No | The year in which the season started |
| EndYear | integer (32) | NOT NULL | No | The year in which the season ended |
| Description | string (10) | NULL | No | The description of the season for display purposes (possible values include: 2017-18, 2018-19, etc) |
| RegularSeasonStartDate | date | NULL | No | The start date of the regular season |
| PostSeasonStartDate | date | NULL | No | The start date of the postseason |
| SeasonType | string (10) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 5=AllStar; 6=Exhibition). |
| ApiSeason | string (10) | NULL | No | The string to pass into subsequent API calls in the season parameter (e.g. 2025REG, 2025POST, etc.) |
Series
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| HomeTeamWins | integer (32) | NOT NULL | No | Total wins in the series by the home team |
| AwayTeamWins | integer (32) | NOT NULL | No | Total wins in the series by the away team |
| GameNumber | integer (32) | NOT NULL | No | The number of the game being played in the series |
| MaxLength | integer (32) | NOT NULL | No | The maximum number of games that can be played in a postseason series |
Sportsbook
Available Endpoints
This table is used in the following endpoints:
-
Props
- Betting Events - by Date
- Betting Events - by Season
- Betting Markets - by Event
- Betting Markets - by Game
- Betting Markets - by Market Type
- Betting Player Props - by Game
- Betting Markets - by Event [Sportsbook Group]
- Betting Markets - by Game [Sportsbook Group]
- Betting Markets - by Market Type [Sportsbook Group]
- Betting Player Props - by Game [Sportsbook Group]
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| SportsbookID | int (32) | NOT NULL | No | The unique ID of the sportsbook |
| Name | string (32) | NOT NULL | Yes | The name of the sportsbook(s) |
Stadium
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StadiumID | integer (32) | NOT NULL | No | The unique ID of the arena |
| Active | boolean | NOT NULL | No | Whether or not this stadium is the home venue for an active team |
| Name | string (50) | NOT NULL | No | The full name of the arena |
| Address | string (50) | NULL | No | The address where the venue is located |
| City | string (50) | NULL | No | The city where the venue is located |
| State | string (10) | NULL | No | The US state where the arena is located (if arena is outside US, this value is NULL) |
| Zip | string (10) | NULL | No | The zip code of the arena |
| Country | string (10) | NULL | No | The country code where the arena is located |
| Capacity | integer (32) | NULL | No | The estimated seating capacity of the arena |
| GeoLat | decimal (32) | NULL | No | The geographic latitude coordinate of this venue. |
| GeoLong | decimal (32) | NULL | No | The geographic longitude coordinate of this venue. |
Standing
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Season | integer (32) | NOT NULL | No | The NHL regular season for which these totals apply |
| SeasonType | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 5=AllStar; 6=Exhibition). |
| TeamID | Integer (32) | NOT NULL | No | The unique ID of the team |
| Key | string (10) | NOT NULL | No | The abbreviation [Key] of the team associated with this market (Ex. BOS, EDM, LAK) |
| City | string (50) | NULL | No | The city/location of the team (e.g. Los Angeles; Philadelphia; Boston; Chicago; etc.) |
| Name | string (50) | NULL | No | The team's full name (ex. Minnesota Wild; New York Islanders) |
| Conference | string (20) | NULL | No | The conference of the team (possible values: Eastern; Western) |
| Division | string (20) | NULL | No | The division of the team (e.g. Atlantic; Metropolitan; Central; or Pacific) |
| Wins | integer (32) | NULL | No | Total number of wins by the team in the season |
| Losses | integer (32) | NULL | No | Total losses for a team in the regular season |
| OvertimeLosses | integer (32) | NULL | No | Total overtime losses by the team in the season |
| Percentage | decimal (32) | NULL | No | The team's winning percentage |
| ConferenceWins | integer (32) | NULL | No | Total number of conference wins for a team |
| ConferenceLosses | integer (32) | NULL | No | Total number of conference losses for a team |
| DivisionWins | integer (32) | NULL | No | Total number of division wins by the team |
| DivisionLosses | integer (32) | NULL | No | Total number of division losses by the team |
| ShutoutWins | integer (32) | NULL | No | Total regular season shutout wins by the team |
| ConferenceRank | integer (32) | NULL | No | Team rank at the conference level |
| DivisionRank | integer (32) | NULL | No | Team rank at the division level |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| ClinchedDivision | boolean | NULL | No | Returns TRUE if team has clinched their division; FALSE if not |
| ClinchedPlayoffBerth | boolean | NULL | No | Returns TRUE if team has clinched a playoff spot; FALSE if not |
| ClinchedBestRecordInConference | boolean | NULL | No | Returns TRUE if team has clinched the best record in their respective conference; FALSE if not |
| ClinchedPresidentsTrophy | boolean | NULL | No | Returns TRUE if team has clinched best record in NHL (President's Trophy); FALSE if not |
| EliminatedFromPlayoffContention | boolean | NULL | No | Returns TRUE if team has been eliminated from playoff contention; FALSE if not |
StartingGoaltenders
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GameID from 2021 | integer (32) | NOT NULL | No | The unique ID of the game tied to the StartingGoaltenders |
| Season from 2021 | integer (32) | NOT NULL | No | The end year of season (2021-22 would be 2022) |
| SeasonType from 2021 | integer (32) | NOT NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 5=AllStar; 6=Exhibition). |
| Day from 2021 | datetime (32) | NULL | No | The date of the game |
| DateTime from 2021 | datetime (32) | NULL | No | The date and time of the game in US Eastern Time |
| Status from 2021 | string (32) | NULL | No | Indicates the game's status. Possible values include: Scheduled, InProgress, Final, F/SO, F/OT, Postponed, Canceled, NotNecessary |
| HomeTeamID from 2021 | integer (32) | NULL | No | The unique ID of the home team tied to these StartingGoaltenders |
| HomeTeam from 2021 | string (32) | NULL | No | The abbreviation [Key] of the home team |
| AwayTeamID from 2021 | integer (32) | NULL | No | The unique ID of the away team as it relates to the starting goaltenders |
| AwayTeam from 2021 | string (32) | NULL | No | The abbreviation [Key] of the away team |
| HomeGoaltender from 2021 | Goaltender (32) | NULL | No | The information of the home goaltender (PlayerID, TeamID, Team, First & Last Name, Jersey Number, Confirmed) |
| AwayGoaltender from 2021 | Goaltender (32) | NULL | No | The information of the away goaltender (PlayerID, TeamID, Team, First & Last Name, Jersey Number, Confirmed) |
Team
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| TeamID | integer (32) | NOT NULL | No | The unique ID of the team |
| [Key] | string (10) | NOT NULL | No | Abbreviation of the team (e.g. LA, PHI, BOS, CHI, etc.) |
| Active | boolean | NOT NULL | No | Whether or not this team is active |
| City | string (50) | NULL | No | The city/location of the team (e.g. Los Angeles, Philadelphia, Boston, Chicago, etc.) |
| Name | string (50) | NULL | No | The mascot of the team (e.g. Kings, Flyers, Bruins, Blackhawks, etc.) |
| StadiumID | integer (32) | NULL | No | The unique ID of the team's current home arena |
| Conference | string (20) | NULL | No | The conference of the team (possible values: Eastern, Western) |
| Division | string (20) | NULL | No | The division of the team (e.g. Atlantic; Metropolitan; Central; or Pacific) |
| PrimaryColor | string (6) | NULL | No | The team's first color (This is not licensed for public or commercial use) |
| SecondaryColor | string (6) | NULL | No | The team's second color (This is not licensed for public or commercial use) |
| TertiaryColor | string (6) | NULL | No | The team's third color (This is not licensed for public or commercial use) |
| QuaternaryColor | string (6) | NULL | No | The team's fourth color (This is not licensed for public or commercial use) |
| WikipediaLogoUrl | string (250) | NULL | No | The link to the team's logo hosted on Wikipedia. (This is not licensed for public or commercial use) |
| WikipediaWordMarkUrl | string (250) | NULL | No | The link to the team's wordmark logo hosted on Wikipedia. (This is not licensed for public or commercial use) |
| GlobalTeamID | integer (32) | NOT NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues. |
| HeadCoach | string (50) | NULL | No | The current head coach of the team |
TeamGame
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stat |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 5=AllStar; 6=Exhibition) |
| Season | integer (32) | NULL | No | The NHL season of the game |
| Name | string (50) | NULL | No | The team's full name (ex. Minnesota Wild; New York Islanders) |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Wins | integer (10) | NULL | No | Total number of wins by the team in the game. NOTE: this will be one for single game feeds |
| Losses | integer (10) | NULL | No | Total losses for the team in the game. NOTE: this will be a maximum of one for single game feeds |
| OvertimeLosses | integer (10) | NULL | No | Total overtime losses by the team in the game |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues |
| GameID | integer (32) | NULL | No | The unique ID of the game tied to this TeamGame record |
| OpponentID | integer (32) | NULL | No | The unique ID of the team's opponent |
| Opponent | string (10) | NULL | No | The abbreviation [Key] of the opponent team |
| Day | date | NULL | No | The day of the game |
| DateTime | datetime | NULL | No | The date and time of the game (in US Eastern Time) |
| HomeOrAway | string (4) | NULL | No | Indicates whether the team is home or away |
| IsGameOver | boolean | NOT NULL | No | Whether the game is over (returns true/false) |
| GlobalGameID | integer (32) | NULL | No | A globally unique ID for this game. This value is guaranteed to be unique across all sports/leagues |
| GlobalOpponentID | integer (32) | NULL | No | A globally unique ID for this team's opponent. This value is guaranteed to be unique across all sports/leagues |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (in US Eastern Time) |
| Games | integer (32) | NULL | No | Total games played by the team in the game. NOTE: this will be 1 or 0 for single game feeds |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the team in the game |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total FanDuel daily fantasy points by the team in the game |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings daily fantasy points by the team in the game |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total Yahoo daily fantasy points by the team in the game |
| Minutes | integer (32) | NULL | Yes | Total minutes played by the team in the game |
| Seconds | integer (32) | NULL | Yes | Total seconds played by the team in the game |
| Goals | decimal (32) | NULL | Yes | Total goals scored by the team in the game |
| Assists | decimal (32) | NULL | Yes | Total assists by the team in the game |
| ShotsOnGoal | decimal (32) | NULL | Yes | Total shots on goal by the team in the game |
| PowerPlayGoals | decimal (32) | NULL | Yes | Total power play goals by the team in the game |
| ShortHandedGoals | decimal (32) | NULL | Yes | Total short handed goals by the team in the game |
| EmptyNetGoals | decimal (32) | NULL | Yes | Total number of empty net goals by the team in the game |
| PowerPlayAssists | decimal (32) | NULL | Yes | Total power play assists by the team in the game |
| ShortHandedAssists | decimal (32) | NULL | Yes | Total short handed assists by the team in the game |
| HatTricks | decimal (32) | NULL | Yes | Total hat tricks by the team in the game |
| ShootoutGoals | decimal (32) | NULL | Yes | Total shootout goals by the team in the game |
| PlusMinus | decimal (32) | NULL | Yes | Total plus/minus by the team in the game |
| PenaltyMinutes | decimal (32) | NULL | Yes | Total penalty minutes by the team in the game |
| Blocks | decimal (32) | NULL | Yes | Total blocked shots by the team in the game |
| Hits | decimal (32) | NULL | Yes | Total hits by the team in the game |
| Takeaways | decimal (32) | NULL | Yes | Total takeaways by the team in the game |
| Giveaways | decimal (32) | NULL | Yes | Total giveaways by the team in the game |
| FaceoffsWon | decimal (32) | NULL | Yes | Total faceoffs won by the team in the game |
| FaceoffsLost | decimal (32) | NULL | Yes | Total faceoffs lost by the team in the game |
| Shifts | decimal (32) | NULL | Yes | Total shifts by the team in the game |
| GoaltendingMinutes | integer (32) | NULL | Yes | Total goaltending minutes played by the team in the game |
| GoaltendingSeconds | integer (32) | NULL | Yes | Total goaltending seconds played by the team in the game |
| GoaltendingShotsAgainst | decimal (32) | NULL | Yes | Total goaltending shots against the team in the game |
| GoaltendingGoalsAgainst | decimal (32) | NULL | Yes | Total goals allowed by the team in the game |
| GoaltendingSaves | decimal (32) | NULL | Yes | Total goaltending saves by the team in the game |
| GoaltendingWins | decimal (32) | NULL | Yes | Total goaltending wins by the team in the game |
| GoaltendingLosses | decimal (32) | NULL | Yes | Total goaltending losses by the team in the game |
| GoaltendingShutouts | decimal (32) | NULL | Yes | Total goaltending shutouts by the team in the game |
| Started from 2017 | integer (32) | NULL | No | This field is expected to be NULL |
| BenchPenaltyMinutes | decimal (32) | NULL | Yes | Total bench penalty minutes by the team in the game |
| GoaltendingOvertimeLosses | decimal (32) | NULL | Yes | Total goaltending overtime losses by the team in the game |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Total FantasyDraft daily fantasy points by the team in the game |
TeamGameTrends
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Scope from 2020 | string (50) | NOT NULL | No | The type of Trend (e.g. Last 5 games, Last 10 games, Last 5 home games, etc.) |
| TeamID from 2020 | integer (32) | NOT NULL | No | The unique ID of the team |
| Team from 2020 | string (50) | NOT NULL | No | The abbreviation [Key] of the team |
| OpponentID from 2020 | integer (32) | NULL | No | The unique ID of the team's opponent |
| Opponent from 2020 | string (50) | NULL | No | The abbreviation [Key] of the opponent team |
| Wins from 2020 | integer (32) | NOT NULL | Yes | Total number of wins relating to the scope (Examples of Scopes include: Last 3 Games; Last 5 Home Games; Last 10 Games as favorite, etc.) |
| Losses from 2020 | integer (32) | NOT NULL | Yes | Total losses by the team relating to the scope (Examples of Scopes include: Last 3 Games; Last 5 Home Games; Last 10 Games as favorite, etc.) |
| Ties from 2020 | integer (32) | NOT NULL | Yes | Ties relating to the scope (Examples of Scopes include: Last 3 Games; Last 5 Home Games; Last 10 Games as favorite, etc.) |
| WinsAgainstTheSpread from 2020 | integer (32) | NULL | Yes | Total number of wins against the spread relating to the scope (Examples of Scopes include: Last 3 Games; Last 5 Home Games; Last 10 Games as favorite, etc.) |
| LossesAgainstTheSpread from 2020 | integer (32) | NULL | Yes | Total losses against the puck line by the team relating to the scope (Examples of Scopes include: Last 3 Games; Last 5 Home Games; Last 10 Games as favorite, etc.) |
| PushesAgainstTheSpread from 2020 | integer (32) | NULL | Yes | Pushes against the puck line relating to the scope (Examples of Scopes include: Last 3 Games; Last 5 Home Games; Last 10 Games as favorite, etc.) |
| Overs from 2020 | integer (32) | NULL | Yes | Amount of times the total score goes over the total goals line |
| Unders from 2020 | integer (32) | NULL | Yes | Amount of times the total score goes under the toal goals line |
| OverUnderPushes from 2020 | integer (32) | NULL | Yes | Amount of times the total score pushes the total goals line |
| AverageScore from 2020 | decimal (32) | NULL | Yes | The average goals per game scored by the team relating to the scope (Examples of Scopes include: Last 3 Games; Last 5 Home Games; Last 10 Games as favorite, etc.) |
| AverageOpponentScore from 2020 | decimal (32) | NULL | Yes | The average goals per game scored by the opposing teams relating to the scope (Examples of Scopes include: Last 3 Games; Last 5 Home Games; Last 10 Games as favorite, etc.) |
TeamGoalieDepthChart
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| GoalieDepthCharts | GoalieDepthChart[] (32) | NULL | No | List of players that make up the goalie depth chart for each team |
| TeamID | integer (32) | NOT NULL | No | The unique ID of the team |
TeamLine
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| TeamID | Integer (32) | NOT NULL | No | The unique ID of the team |
| Key | string (10) | NOT NULL | No | "The abbreviation [Key] of the team associated with this market (Ex. BOS, EDM, LAK)" |
| FullName | string (50) | NOT NULL | No | The team's full name (ex. Minnesota Wild; New York Islanders) |
| EvenStrengthLines | PlayerLine[] | NULL | No | The even strength lines for this team |
| PowerPlayLines | PlayerLine[] | NULL | No | The power play lines for a given team |
| ShortHandedLines | PlayerLine[] | NULL | No | The short-handed/penalty-kill lines for this team |
TeamSeason
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| StatID | integer (32) | NOT NULL | No | The unique ID of the stat |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| SeasonType | integer (32) | NULL | No | The type of season that this record corresponds to (1=Regular Season; 2=Preseason; 3=Postseason; 5=AllStar; 6=Exhibition) |
| Season | integer (32) | NULL | No | The NHL regular season for which these totals apply |
| Name | string (50) | NULL | No | The team's full name (ex. Minnesota Wild; New York Islanders) |
| Team | string (10) | NULL | No | The abbreviation [Key] of the team |
| Wins | integer (10) | NULL | No | Total number of wins by the team in the season |
| Losses | integer (10) | NULL | No | Total losses for the team in the season |
| OvertimeLosses | integer (10) | NULL | No | Total overtime losses by the team in the season |
| OpponentPosition | string (10) | NULL | No | Indicates which position is included in opponent stats that are aggregated together |
| GlobalTeamID | integer (32) | NULL | No | A globally unique ID for this team. This value is guaranteed to be unique across all sports/leagues |
| OpponentStat | OpponentSeason | NULL | No | The aggregated season stats for this team's opponents |
| Updated | datetime | NULL | No | The timestamp of when the record was last updated (in US Eastern Time) |
| Games | integer (32) | NULL | No | Total games played by the team in the season |
| FantasyPoints | decimal (32) | NULL | Yes | Total fantasy points by the team in the season |
| FantasyPointsFanDuel | decimal (32) | NULL | Yes | Total FanDuel daily fantasy points by the team in the season |
| FantasyPointsDraftKings | decimal (32) | NULL | Yes | Total DraftKings daily fantasy points by the team in the season |
| FantasyPointsYahoo | decimal (32) | NULL | Yes | Total Yahoo daily fantasy points by the team in the season |
| Minutes | integer (32) | NULL | Yes | Total minutes played by the team in the season |
| Seconds | integer (32) | NULL | Yes | Total seconds played by the team in the season |
| Goals | decimal (32) | NULL | Yes | Total goals scored by the team in the season |
| Assists | decimal (32) | NULL | Yes | Total assists by the team in the season |
| ShotsOnGoal | decimal (32) | NULL | Yes | Total shots on goal by the team in the season |
| PowerPlayGoals | decimal (32) | NULL | Yes | Total power play goals by the team in the season |
| ShortHandedGoals | decimal (32) | NULL | Yes | Total short handed goals by the team in the season |
| EmptyNetGoals | decimal (32) | NULL | Yes | Total number of empty net goals by the team in the season |
| PowerPlayAssists | decimal (32) | NULL | Yes | Total power play assists by the team in the season |
| ShortHandedAssists | decimal (32) | NULL | Yes | Total short handed assists by the team in the season |
| HatTricks | decimal (32) | NULL | Yes | Total hat tricks by the team in the season |
| ShootoutGoals | decimal (32) | NULL | Yes | Total shootout goals by the team in the season |
| PlusMinus | decimal (32) | NULL | Yes | Total plus/minus by the team in the season |
| PenaltyMinutes | decimal (32) | NULL | Yes | Total penalty minutes by the team in the season |
| Blocks | decimal (32) | NULL | Yes | Total blocked shots by the team in the season |
| Hits | decimal (32) | NULL | Yes | Total hits by the team in the season |
| Takeaways | decimal (32) | NULL | Yes | Total takeaways by the team in the season |
| Giveaways | decimal (32) | NULL | Yes | Total giveaways by the team in the season |
| FaceoffsWon | decimal (32) | NULL | Yes | Total faceoffs won by the team in the season |
| FaceoffsLost | decimal (32) | NULL | Yes | Total faceoffs lost by the team in the season |
| Shifts | decimal (32) | NULL | Yes | Total shifts by the team in the season |
| GoaltendingMinutes | integer (32) | NULL | Yes | Total goaltending minutes by the team in the season |
| GoaltendingSeconds | integer (32) | NULL | Yes | Total goaltending seconds by the team in the season |
| GoaltendingShotsAgainst | decimal (32) | NULL | Yes | Total goaltending shots against the team in the season |
| GoaltendingGoalsAgainst | decimal (32) | NULL | Yes | Total goals allowed by the team in the season |
| GoaltendingSaves | decimal (32) | NULL | Yes | Total goaltending saves by the team in the season |
| GoaltendingWins | decimal (32) | NULL | Yes | Total goaltending wins by the team in the season |
| GoaltendingLosses | decimal (32) | NULL | Yes | Total goaltending losses by the team in the season |
| GoaltendingShutouts | decimal (32) | NULL | Yes | Total goaltending shutouts by the team in the season |
| Started from 2017 | integer (32) | NULL | No | This field is expected to be NULL |
| BenchPenaltyMinutes | decimal (32) | NULL | Yes | Total bench penalty minutes by the team in the season |
| GoaltendingOvertimeLosses | decimal (32) | NULL | Yes | Total goaltending overtime losses by the team in the season |
| FantasyPointsFantasyDraft | decimal (32) | NULL | Yes | Total FantasyDraft daily fantasy points by the team in the season |
TeamTrends
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| Team from 2020 | string (50) | NULL | No | The abbreviation [Key] of the team |
| TeamID from 2020 | integer (32) | NULL | No | The unique ID of the team |
| UpcomingGame from 2020 | Game | NULL | No | Upcoming game for this team |
| TeamGameTrends from 2020 | TeamGameTrends[] | NULL | No | The collection of Game Trends for this team |
Transaction
Available Endpoints
This table is used in the following endpoints:
| Name | Type (Size) | Nullable | Scrambled | Description |
|---|---|---|---|---|
| PlayerID | integer (32) | NOT NULL | No | The player's unique PlayerID as assigned by SportsDataIO. Note: this ID will stay with the player throughout their entire career |
| Name | string (32) | NOT NULL | No | The player's full name |
| FormerTeamID | integer (32) | NULL | No | The ID of the player's former team |
| FormerTeam | string (32) | NULL | No | The [Key] of the player's former team (e.g. BOS; PHI; DET; EDM, etc.) |
| TeamID | integer (32) | NULL | No | The unique ID of the team |
| Team | string (32) | NULL | No | The abbreviation [Key] of the team involved in the transaction |
| Type | string (50) | NULL | No | Type of transaction that occurred |
| Date | datetime (32) | NULL | No | The date this transaction was created |
| Note | string (100) | NULL | No | A summary of the transaction that occurred (e.g. "Harris has signed with the Canucks.") |
| Created | datetime (32) | NULL | No | The date and time this transaction was created |
| Updated | datetime (32) | NULL | No | The date and time this transaction was last updated (in US Eastern Time) |