Developer Portal

Data Dictionary

Below you will find a list of all data points that are contained within each feed that we offer. If any of the information provided below is unclear, or if you have a specific question, please contact support.

Go to our developer portal for a full list of operations including deprecated, legacy and test endpoints.

All dates & times are in US Eastern Time.

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