Skip to main content

NHL dataset loaders — Other

load_nhl_player_boxscore​

Release: nhl_player_boxscores · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_player_boxscores/player_box_{season}.parquet

Returns​

col_nametypedescription
home_awayStringHome or away indicator.
team_idInt64Unique team identifier.
team_abbrevStringTeam abbreviation.
player_idInt64Unique player identifier.
player_nameStringPlayer name.
sweater_numberInt64Jersey number.
positionStringPlayer position.
goalsInt64Goals scored.
assistsInt64Assists.
pointsInt64Total points (goals + assists).
plus_minusInt64Plus/minus rating.
pimInt64Penalty minutes.
hitsInt64Hits.
power_play_goalsInt64Power-play goals.
shots_on_goalInt64Shots on goal.
faceoff_winning_pctgFloat64Faceoff win percentage.
toiStringTime on ice.
blocked_shotsInt64Blocked shots.
shiftsInt64CONSTANT false in every published row: the shift-chart block is not carried on this asset. An availability flag, not a shift count.
giveawaysInt64Giveaways.
takeawaysInt64Takeaways.
game_idInt64Unique game identifier.
seasonInt64Season year (echoed from arg).
game_dateStringGame date.
even_strength_shots_againstStringEven-strength shots against (saves/total).
power_play_shots_againstStringPower-play shots against (saves/total).
shorthanded_shots_againstStringShorthanded shots against (saves/total).
save_shots_againstStringTotal shots against (saves/total).
save_pctgFloat64Save percentage.
even_strength_goals_againstInt64Even-strength goals against.
power_play_goals_againstInt64Power-play goals against.
shorthanded_goals_againstInt64Shorthanded goals against.
goals_againstInt64Goals against.
starterBooleanWhether the goalie started the game.
decisionStringGoalie decision (W/L/O).
shots_againstInt64Shots faced.
savesInt64Saves made.
load_nhl_player_boxscore(seasons=2024)

load_nhl_schedule​

Release: nhl_schedules · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_schedules/nhl_schedule_{season}.parquet

Returns​

col_nametypedescription
game_idInt32Unique game identifier.
season_fullStringFull season label (e.g. 20212022).
game_typeStringGame type the row belongs to.
game_dateStringGame date.
game_timeStringScheduled start time of the game.
home_team_abbrStringHome team abbreviation.
away_team_abbrStringAway team abbreviation.
home_team_nameStringHome team name.
away_team_nameStringAway team name.
home_scoreInt32Home team final score.
away_scoreInt32Away team final score.
game_stateStringGame state (e.g., FINAL, LIVE).
venueStringVenue where the game was played.
series_letterStringPlayoff series identifier letter, populated only for postseason games (88 of 1,400 rows in 2024) and null for the regular season.
playoff_roundInt32Playoff round identifier.
series_game_numberInt32
seasonInt32Season year (echoed from arg).
game_jsonBooleanWhether processed game JSON is available.
game_json_urlStringURL to the processed game JSON.
PBPBooleanWhether play-by-play data is available.
team_boxBooleanWhether team box score data is available.
player_boxBooleanWhether player box score data is available.
skater_boxBooleanWhether skater box data is available.
goalie_boxBooleanWhether goalie box data is available.
game_infoBooleanCONSTANT true: marks that the source game record carried a game-info block.
game_rostersBooleanWhether game rosters data is available.
scoringBooleanCONSTANT true: marks that the source game record carried a scoring-summary block. It is an availability flag, not a count or a scoring event.
penaltiesBooleanCONSTANT true: marks that the source game record carried a penalty-summary block. It is an availability flag, not a penalty count.
scratchesBooleanTrue when the source game record carried a scratches block for the game.
linescoreBooleanCONSTANT: true on every published row, so it carries no information as shipped. It marks that a linescore block existed on the source game record.
three_starsBooleanCONSTANT true: marks that the source game record carried a three-stars block.
shiftsBooleanCONSTANT false in every published row: the shift-chart block is not carried on this asset. An availability flag, not a shift count.
officialsBooleanWhether officials data is available.
shots_by_periodBooleanWhether shots-by-period data is available.
shootoutBooleanWhether shootout data is available.
load_nhl_schedule(seasons=2024)

load_nhl_team_boxscore​

Release: nhl_team_boxscores · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_team_boxscores/team_box_{season}.parquet

Returns​

col_nametypedescription
home_awayStringHome or away indicator.
team_idInt64Unique team identifier.
team_abbrevStringTeam abbreviation.
team_nameStringTeam name.
goalsInt64Goals scored.
shots_on_goalInt64Shots on goal.
pimInt64Penalty minutes.
hitsInt64Hits.
blocked_shotsInt64Blocked shots.
giveawaysInt64Giveaways.
takeawaysInt64Takeaways.
power_play_goalsInt64Power-play goals.
faceoff_win_pctgFloat64Faceoff win percentage.
savesInt64Saves made.
save_pctgFloat64Save percentage.
goals_againstInt64Goals against.
game_idInt64Unique game identifier.
seasonInt64Season year (echoed from arg).
game_dateStringGame date.
load_nhl_team_boxscore(seasons=2024)

load_nhl_game_info​

Release: nhl_game_info · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_game_info/game_info_{season}.parquet

Returns​

col_nametypedescription
game_idInt64Unique game identifier.
seasonInt64Season year (echoed from arg).
game_typeStringGame type the row belongs to.
game_dateStringGame date.
venueStringVenue where the game was played.
home_team_abbrStringHome team abbreviation.
away_team_abbrStringAway team abbreviation.
home_scoreInt64Home team final score.
away_scoreInt64Away team final score.
game_stateStringGame state (e.g., FINAL, LIVE).
load_nhl_game_info(seasons=2024)

load_nhl_game_rosters​

Release: nhl_game_rosters · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_game_rosters/game_rosters_{season}.parquet

Returns​

col_nametypedescription
player_idInt64Unique player identifier.
full_nameStringPlayer full name.
first_nameStringPlayer first name.
last_nameStringPlayer last name.
team_abbrStringTeam abbreviation.
team_idInt64Unique team identifier.
position_codeStringPlayer position code.
sweater_numberInt64Jersey number.
game_idInt64Unique game identifier.
seasonInt64Season year (echoed from arg).
game_dateStringGame date.
shoots_catchesStringHandedness (shoots/catches).
load_nhl_game_rosters(seasons=2024)

load_nhl_goalie_boxscores​

Release: nhl_goalie_boxscores · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_goalie_boxscores/goalie_box_{season}.parquet

Returns​

col_nametypedescription
home_awayStringHome or away indicator.
team_idInt64Unique team identifier.
team_abbrevStringTeam abbreviation.
player_idInt64Unique player identifier.
player_nameStringPlayer name.
sweater_numberInt64Jersey number.
even_strength_shots_againstStringEven-strength shots against (saves/total).
power_play_shots_againstStringPower-play shots against (saves/total).
shorthanded_shots_againstStringShorthanded shots against (saves/total).
save_shots_againstStringTotal shots against (saves/total).
save_pctgFloat64Save percentage.
even_strength_goals_againstInt64Even-strength goals against.
power_play_goals_againstInt64Power-play goals against.
shorthanded_goals_againstInt64Shorthanded goals against.
pimInt64Penalty minutes.
goals_againstInt64Goals against.
toiStringTime on ice.
starterBooleanWhether the goalie started the game.
decisionStringGoalie decision (W/L/O).
shots_againstInt64Shots faced.
savesInt64Saves made.
game_idInt64Unique game identifier.
seasonInt64Season year (echoed from arg).
game_dateStringGame date.
load_nhl_goalie_boxscores(seasons=2024)

load_nhl_linescore​

Release: nhl_linescore · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_linescore/linescore_{season}.parquet

Returns​

col_nametypedescription
game_idInt64Unique game identifier.
home_team_idInt64Home team identifier.
home_team_abbrStringHome team abbreviation.
home_goalsInt64Home goals in the period.
home_shotsInt64Home team shots in the period.
away_team_idInt64Away team identifier.
away_team_abbrStringAway team abbreviation.
away_goalsInt64Away goals in the period.
away_shotsInt64Away team shots in the period.
has_shootoutBooleanFlag for whether the game went to shootout.
load_nhl_linescore(seasons=2024)

load_nhl_officials​

Release: nhl_officials · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_officials/officials_{season}.parquet

Returns​

col_nametypedescription
roleStringGrouped official role (Referee/Linesperson).
nameStringTeam mascot name.
game_idInt64Unique game identifier.
seasonInt64Season year (echoed from arg).
game_dateStringGame date.
load_nhl_officials(seasons=2025)

load_nhl_penalties​

Release: nhl_penalties · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_penalties/penalties_{season}.parquet

Returns​

col_nametypedescription
timeInPeriodStringTime within the period the penalty occurred.
typeStringCompetitor type (e.g. "team").
durationInt64Penalty duration in minutes.
committedByPlayer.firstName.defaultStringGiven name of the penalized player as published in the NHL feed's default English locale.
committedByPlayer.firstName.csStringAlternate given name for the penalized player under the NHL feed's Czech key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
committedByPlayer.firstName.deStringAlternate given name for the penalized player under the NHL feed's German key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
committedByPlayer.firstName.esStringAlternate given name for the penalized player under the NHL feed's Spanish key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
committedByPlayer.firstName.fiStringAlternate given name for the penalized player under the NHL feed's Finnish key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
committedByPlayer.firstName.skStringAlternate given name for the penalized player under the NHL feed's Slovak key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
committedByPlayer.firstName.svStringAlternate given name for the penalized player under the NHL feed's Swedish key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
committedByPlayer.firstName.frStringAlternate given name for the penalized player under the NHL feed's French key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
committedByPlayer.lastName.defaultStringFamily name of the penalized player as published in the NHL feed's default English locale.
committedByPlayer.lastName.csStringAlternate rendering of the family name published under the NHL feed's Czech key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
committedByPlayer.lastName.deStringAlternate rendering of the penalized player's family name under the NHL feed's German key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
committedByPlayer.lastName.esStringAlternate rendering of the penalized player's family name under the NHL feed's Spanish key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
committedByPlayer.lastName.fiStringAlternate rendering of the family name published under the NHL feed's Finnish key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
committedByPlayer.lastName.skStringAlternate rendering of the family name published under the NHL feed's Slovak key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
committedByPlayer.lastName.svStringAlternate rendering of the family name published under the NHL feed's Swedish key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
committedByPlayer.lastName.frStringAlternate rendering of the family name published under the NHL feed's French key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
committedByPlayer.sweaterNumberInt64Jersey number of the penalized player on the play.
teamAbbrev.defaultStringThree-letter code of the team charged with the penalty, matching the committing player's boxscore team rather than the team that drew it.
drawnBy.firstName.defaultStringGiven name, in the feed's default English locale, of the opposing player credited with drawing the penalty.
drawnBy.firstName.csStringAlternate given name for the opposing player credited with drawing the penalty under the NHL feed's Czech key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
drawnBy.firstName.deStringAlternate given name for the opposing player credited with drawing the penalty under the NHL feed's German key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
drawnBy.firstName.esStringAlternate given name for the opposing player credited with drawing the penalty under the NHL feed's Spanish key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
drawnBy.firstName.fiStringAlternate given name for the opposing player credited with drawing the penalty under the NHL feed's Finnish key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
drawnBy.firstName.skStringAlternate given name for the opposing player credited with drawing the penalty under the NHL feed's Slovak key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
drawnBy.firstName.svStringAlternate given name for the opposing player credited with drawing the penalty under the NHL feed's Swedish key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
drawnBy.firstName.frStringAlternate given name for the opposing player credited with drawing the penalty under the NHL feed's French key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
drawnBy.lastName.defaultStringFamily name, in the feed's default English locale, of the opposing player credited with drawing the penalty.
drawnBy.lastName.csStringAlternate rendering of the family name published under the NHL feed's Czech key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
drawnBy.lastName.deStringAlternate rendering of the opposing player credited with drawing the penalty's family name under the NHL feed's German key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
drawnBy.lastName.esStringAlternate rendering of the opposing player credited with drawing the penalty's family name under the NHL feed's Spanish key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
drawnBy.lastName.fiStringAlternate rendering of the family name published under the NHL feed's Finnish key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
drawnBy.lastName.skStringAlternate rendering of the family name published under the NHL feed's Slovak key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
drawnBy.lastName.svStringAlternate rendering of the family name published under the NHL feed's Swedish key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
drawnBy.lastName.frStringAlternate rendering of the family name published under the NHL feed's French key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
drawnBy.sweaterNumberInt64Jersey number of the opposing player credited with drawing the infraction; null whenever no victim is credited, as on all bench and game-misconduct penalties.
descKeyStringPenalty description key.
game_idInt64Unique game identifier.
period_numberInt64Period number (1-3 regulation, 4+ OT).
period_typeStringPeriod type (REG/OT/SO).
servedBy.defaultStringAbbreviated name, in the feed's default English locale, of the player serving the penalty.
servedBy.csStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's Czech key, differing from the default by diacritics or by an alternate given-name form.
servedBy.deStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's German key, differing from the default by diacritics or by an alternate given-name form.
servedBy.esStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's Spanish key, differing from the default by diacritics or by an alternate given-name form.
servedBy.fiStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's Finnish key, differing from the default by diacritics or by an alternate given-name form.
servedBy.skStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's Slovak key, differing from the default by diacritics or by an alternate given-name form.
servedBy.svStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's Swedish key, differing from the default by diacritics or by an alternate given-name form.
load_nhl_penalties(seasons=2024)

load_nhl_player_boxscores​

Release: nhl_player_boxscores · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_player_boxscores/player_box_{season}.parquet

Returns​

col_nametypedescription
home_awayStringHome or away indicator.
team_idInt64Unique team identifier.
team_abbrevStringTeam abbreviation.
player_idInt64Unique player identifier.
player_nameStringPlayer name.
sweater_numberInt64Jersey number.
positionStringPlayer position.
goalsInt64Goals scored.
assistsInt64Assists.
pointsInt64Total points (goals + assists).
plus_minusInt64Plus/minus rating.
pimInt64Penalty minutes.
hitsInt64Hits.
power_play_goalsInt64Power-play goals.
shots_on_goalInt64Shots on goal.
faceoff_winning_pctgFloat64Faceoff win percentage.
toiStringTime on ice.
blocked_shotsInt64Blocked shots.
shiftsInt64CONSTANT false in every published row: the shift-chart block is not carried on this asset. An availability flag, not a shift count.
giveawaysInt64Giveaways.
takeawaysInt64Takeaways.
game_idInt64Unique game identifier.
seasonInt64Season year (echoed from arg).
game_dateStringGame date.
even_strength_shots_againstStringEven-strength shots against (saves/total).
power_play_shots_againstStringPower-play shots against (saves/total).
shorthanded_shots_againstStringShorthanded shots against (saves/total).
save_shots_againstStringTotal shots against (saves/total).
save_pctgFloat64Save percentage.
even_strength_goals_againstInt64Even-strength goals against.
power_play_goals_againstInt64Power-play goals against.
shorthanded_goals_againstInt64Shorthanded goals against.
goals_againstInt64Goals against.
starterBooleanWhether the goalie started the game.
decisionStringGoalie decision (W/L/O).
shots_againstInt64Shots faced.
savesInt64Saves made.
load_nhl_player_boxscores(seasons=2010)

load_nhl_rosters​

Release: nhl_rosters · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_rosters/rosters_{season}.parquet

Returns​

col_nametypedescription
player_idInt32Unique player identifier.
full_nameStringPlayer full name.
first_nameStringPlayer first name.
last_nameStringPlayer last name.
team_abbrStringTeam abbreviation.
team_idInt32Unique team identifier.
position_codeStringPlayer position code.
sweater_numberInt32Jersey number.
seasonInt32Season year (echoed from arg).
game_dateStringGame date.
load_nhl_rosters(seasons=2010)

load_nhl_schedules​

Release: nhl_schedules · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_schedules/nhl_schedule_{season}.parquet

Returns​

col_nametypedescription
game_idInt32Unique game identifier.
season_fullStringFull season label (e.g. 20212022).
game_typeStringGame type the row belongs to.
game_dateStringGame date.
game_timeStringScheduled start time of the game.
home_team_abbrStringHome team abbreviation.
away_team_abbrStringAway team abbreviation.
home_team_nameStringHome team name.
away_team_nameStringAway team name.
home_scoreInt32Home team final score.
away_scoreInt32Away team final score.
game_stateStringGame state (e.g., FINAL, LIVE).
venueStringVenue where the game was played.
series_letterStringNHL API letter code identifying the playoff series the game belongs to (null for regular-season games).
playoff_roundInt32Playoff round identifier.
series_game_numberInt32
seasonInt32Season year (echoed from arg).
game_jsonBooleanWhether processed game JSON is available.
game_json_urlStringURL to the processed game JSON.
PBPBooleanWhether play-by-play data is available.
team_boxBooleanWhether team box score data is available.
player_boxBooleanWhether player box score data is available.
skater_boxBooleanWhether skater box data is available.
goalie_boxBooleanWhether goalie box data is available.
game_infoBooleanWhether game info data is available.
game_rostersBooleanWhether game rosters data is available.
scoringBoolean
penaltiesBooleanPenalty count.
scratchesBooleanFlag indicating a scratches payload was captured for this game in the NHL raw store.
linescoreBooleanFlag indicating a period-by-period linescore payload was captured for this game in the NHL raw store.
three_starsBooleanWhether three stars data is available.
shiftsBooleanNumber of shifts.
officialsBooleanWhether officials data is available.
shots_by_periodBooleanWhether shots-by-period data is available.
shootoutBooleanWhether shootout data is available.
load_nhl_schedules(seasons=2010)

load_nhl_scoring​

Release: nhl_scoring · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_scoring/scoring_{season}.parquet

Returns​

col_nametypedescription
situationCodeStringStrength/situation code for the goal.
eventIdInt64Event identifier within the game.
strengthStringStrength label (Even, Power Play, Shorthanded).
playerIdInt64Player identifier involved in the event.
firstName.defaultStringGiven name of the goal scorer as rendered in the NHL feed's default English locale.
firstName.csStringAlternate given name for the player under the NHL feed's Czech key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
firstName.deStringAlternate given name for the player under the NHL feed's German key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
firstName.esStringAlternate given name for the player under the NHL feed's Spanish key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
firstName.fiStringAlternate given name for the player under the NHL feed's Finnish key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
firstName.skStringAlternate given name for the player under the NHL feed's Slovak key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
firstName.svStringAlternate given name for the player under the NHL feed's Swedish key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
firstName.frStringAlternate given name for the player under the NHL feed's French key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
lastName.defaultStringFamily name of the goal scorer as rendered in the NHL feed's default English locale.
lastName.csStringAlternate rendering of the family name published under the NHL feed's Czech key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
lastName.fiStringAlternate rendering of the family name published under the NHL feed's Finnish key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
lastName.skStringAlternate rendering of the family name published under the NHL feed's Slovak key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
lastName.svStringAlternate rendering of the family name published under the NHL feed's Swedish key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
lastName.deStringAlternate rendering of the player's family name under the NHL feed's German key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
lastName.esStringAlternate rendering of the player's family name under the NHL feed's Spanish key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
lastName.frStringAlternate rendering of the family name published under the NHL feed's French key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
name.defaultStringAbbreviated name of the player as published in the NHL feed's default English locale.
name.csStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's Czech key, differing from the default by diacritics or by an alternate given-name form.
name.deStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's German key, differing from the default by diacritics or by an alternate given-name form.
name.esStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's Spanish key, differing from the default by diacritics or by an alternate given-name form.
name.fiStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's Finnish key, differing from the default by diacritics or by an alternate given-name form.
name.skStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's Slovak key, differing from the default by diacritics or by an alternate given-name form.
name.svStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's Swedish key, differing from the default by diacritics or by an alternate given-name form.
name.frStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's French key, differing from the default by diacritics or by an alternate given-name form.
teamAbbrev.defaultStringThree-letter code of the team that scored the goal, resolving to the home club exactly when isHome is true and to the visitor otherwise.
headshotStringURL to the player headshot image.
highlightClipSharingUrlStringShareable URL for the goal highlight clip.
highlightClipInt64Highlight clip identifier.
discreteClipInt64Discrete clip identifier.
goalsToDateInt64Scorer goal total to date in the season.
awayScoreInt64Away team score after the goal.
homeScoreInt64Home team score after the goal.
leadingTeamAbbrev.defaultStringThree-letter code of the team ahead on the scoreboard immediately after this goal, null exactly when the goal tied the game and not always the scoring team.
timeInPeriodStringTime within the period the penalty occurred.
shotTypeStringType of shot on the goal.
goalModifierStringGoal modifier (e.g. empty-net, power-play).
assistsStringAssists.
pptReplayUrlStringURL to the play replay, if available.
homeTeamDefendingSideStringSide of the ice the home team is defending.
isHomeBooleanWhether the scoring team is the home team.
game_idInt64Unique game identifier.
period_numberInt64Period number (1-3 regulation, 4+ OT).
period_typeStringPeriod type (REG/OT/SO).
goalInGameInt64Running goal count credited to the scorer within this game at the time of the goal.
discreteClipFrInt64Numeric NHL video identifier of the French-language standalone clip of the goal, always a different asset id from discreteClip.
highlightClipSharingUrlFrStringShareable nhl.com URL for the French-language highlight clip; its trailing numeric segment is the same id carried in highlightClipFr.
highlightClipFrInt64NHL video id of the French-language highlight clip for the goal. Stored as Float64 even though it is a whole 13-digit identifier, so cast before using it as a key.
load_nhl_scoring(seasons=2024)

load_nhl_scratches​

Release: nhl_scratches · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_scratches/scratches_{season}.parquet

Returns​

col_nametypedescription
idInt64Unique player identifier.
firstNameStringScorer first name (localized list).
lastNameStringScorer last name (localized list).
game_idInt64Unique game identifier.
load_nhl_scratches(seasons=2024)

load_nhl_shifts​

Release: nhl_shifts · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_shifts/shifts_{season}.parquet

Returns​

col_nametypedescription
event_teamStringTeam associated with the shift change.
periodInt64Period number.
period_timeStringElapsed time in the period (MM:SS).
period_secondsInt64Elapsed seconds in the period.
game_secondsInt64Elapsed seconds in the game.
num_onInt64Number of players coming on (line change).
players_onStringNames of players coming on.
ids_onStringPlayer ids coming on.
num_offInt64Number of players going off (line change).
players_offStringNames of players going off.
ids_offStringPlayer ids going off.
eventStringEvent description label.
event_typeStringStandardized event type code.
game_seconds_remainingInt64Seconds remaining in regulation.
game_idInt64Unique game identifier.
seasonInt64Season year (echoed from arg).
game_dateStringGame date.
load_nhl_shifts(seasons=2025)

load_nhl_shootout​

Release: nhl_shootout · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_shootout/shootout_summary_{season}.parquet

Returns​

col_nametypedescription
homeInt64Whether the player's team was home.
awayInt64Away team shots in the period.
game_idInt64Unique game identifier.
seasonInt64Season year (echoed from arg).
game_dateStringGame date.
sequenceInt64Sequence order of the season row.
playerIdInt64Player identifier involved in the event.
teamAbbrev.defaultStringThree-letter code of the shooting player's team; null on the per-game summary row that instead carries the home and away shootout goal totals.
firstName.defaultStringGiven name of the shooter in the feed's default English locale; null on the per-game summary row.
firstName.csStringAlternate given name published under the NHL feed's Czech key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
firstName.deStringAlternate given name published under the NHL feed's German key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
firstName.esStringAlternate given name published under the NHL feed's Spanish key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
firstName.fiStringAlternate given name published under the NHL feed's Finnish key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
firstName.skStringAlternate given name published under the NHL feed's Slovak key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
firstName.svStringAlternate given name published under the NHL feed's Swedish key. Verified against the data it is frequently a different name form rather than a re-spelling (Joshua published as Josh, Aliaksei as Alexei), so it is not a reliable transliteration of the default.
lastName.defaultStringFamily name of the shooter in the feed's default English locale; null on the per-game summary row.
lastName.csStringAlternate rendering of the family name published under the NHL feed's Czech key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
lastName.fiStringAlternate rendering of the family name published under the NHL feed's Finnish key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
lastName.skStringAlternate rendering of the family name published under the NHL feed's Slovak key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
lastName.svStringAlternate rendering of the family name published under the NHL feed's Swedish key. It differs from the default in orthography -- usually restoring diacritics the default folds to ASCII, though for some names it strips them instead -- so treat it as an alternate spelling, not a canonical one.
shotTypeStringType of shot on the goal.
resultStringAttempt result (goal/save/miss).
headshotStringURL to the player headshot image.
gameWinnerBooleanTrue on the single attempt per shootout credited as the game-deciding goal, false on every other attempt and null on the per-game summary row.
homeScoreInt64Home team score after the goal.
awayScoreInt64Away team score after the goal.
discreteClipInt64Discrete clip identifier.
discreteClipFrInt64Numeric NHL video identifier of the French-language clip of the shootout attempt, distinct from the id in discreteClip.
highlightClipSharingUrlStringShareable URL for the goal highlight clip.
highlightClipSharingUrlFrStringShareable URL of the French-language broadcast highlight clip for the shootout attempt.
highlightClipInt64Highlight clip identifier.
highlightClipFrInt64NHL video identifier of the French-language highlight clip for the shootout attempt.
load_nhl_shootout(seasons=2025)

load_nhl_shots_by_period​

Release: nhl_shots_by_period · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_shots_by_period/shots_by_period_{season}.parquet

Returns​

col_nametypedescription
periodInt64Period number.
period_typeStringPeriod type (REG/OT/SO).
max_regulation_periodsInt64Number of regulation periods the game format defines before overtime, constant at 3 for every row in the published seasons.
ot_periodsInt64Overtime period ordinal taken from the NHL period descriptor, populated only from the second overtime onward so period 5 rows carry 2 and all other rows are null.
awayInt64Away team shots in the period.
homeInt64Whether the player's team was home.
game_idInt64Unique game identifier.
seasonInt64Season year (echoed from arg).
game_dateStringGame date.
load_nhl_shots_by_period(seasons=2025)

load_nhl_skater_boxscores​

Release: nhl_skater_boxscores · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_skater_boxscores/skater_box_{season}.parquet

Returns​

col_nametypedescription
home_awayStringHome or away indicator.
team_idInt64Unique team identifier.
team_abbrevStringTeam abbreviation.
player_idInt64Unique player identifier.
player_nameStringPlayer name.
sweater_numberInt64Jersey number.
positionStringPlayer position.
goalsInt64Goals scored.
assistsInt64Assists.
pointsInt64Total points (goals + assists).
plus_minusInt64Plus/minus rating.
pimInt64Penalty minutes.
hitsInt64Hits.
power_play_goalsInt64Power-play goals.
shots_on_goalInt64Shots on goal.
faceoff_winning_pctgFloat64Faceoff win percentage.
toiStringTime on ice.
blocked_shotsInt64Blocked shots.
shiftsInt64CONSTANT false in every published row: the shift-chart block is not carried on this asset. An availability flag, not a shift count.
giveawaysInt64Giveaways.
takeawaysInt64Takeaways.
game_idInt64Unique game identifier.
seasonInt64Season year (echoed from arg).
game_dateStringGame date.
load_nhl_skater_boxscores(seasons=2024)

load_nhl_team_boxscores​

Release: nhl_team_boxscores · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_team_boxscores/team_box_{season}.parquet

Returns​

col_nametypedescription
home_awayStringHome or away indicator.
team_idInt64Unique team identifier.
team_abbrevStringTeam abbreviation.
team_nameStringTeam name.
goalsInt64Goals scored.
shots_on_goalInt64Shots on goal.
pimInt64Penalty minutes.
hitsInt64Hits.
blocked_shotsInt64Blocked shots.
giveawaysInt64Giveaways.
takeawaysInt64Takeaways.
power_play_goalsInt64Power-play goals.
faceoff_win_pctgFloat64Faceoff win percentage.
savesInt64Saves made.
save_pctgFloat64Save percentage.
goals_againstInt64Goals against.
game_idInt64Unique game identifier.
seasonInt64Season year (echoed from arg).
game_dateStringGame date.
load_nhl_team_boxscores(seasons=2010)

load_nhl_three_stars​

Release: nhl_three_stars · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_three_stars/three_stars_{season}.parquet

Returns​

col_nametypedescription
starInt64Star ranking (1, 2, or 3).
playerIdInt64Player identifier involved in the event.
teamAbbrevStringPenalized team abbreviation (localized list).
headshotStringURL to the player headshot image.
name.defaultStringAbbreviated name of the player as published in the NHL feed's default English locale.
name.csStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's Czech key, differing from the default by diacritics or by an alternate given-name form.
name.skStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's Slovak key, differing from the default by diacritics or by an alternate given-name form.
name.fiStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's Finnish key, differing from the default by diacritics or by an alternate given-name form.
name.svStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's Swedish key, differing from the default by diacritics or by an alternate given-name form.
name.deStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's German key, differing from the default by diacritics or by an alternate given-name form.
name.esStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's Spanish key, differing from the default by diacritics or by an alternate given-name form.
name.frStringAlternate abbreviated name (first initial plus family name) published under the NHL feed's French key, differing from the default by diacritics or by an alternate given-name form.
sweaterNoInt64Jersey number.
positionStringPlayer position.
goalsInt64Goals scored.
assistsInt64Assists.
pointsInt64Total points (goals + assists).
goalsAgainstAverageFloat64Goals-against average (goalies).
savePctgFloat64Save percentage (goalies).
game_idInt64Unique game identifier.
winner_idInt64Player id of the winning goalie.
winner_nameStringName of the winning goalie.
loser_idInt64Player id of the losing goalie.
loser_nameStringName of the losing goalie.
load_nhl_three_stars(seasons=2024)

load_nhl_groups​

Release: nhl_groups · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_groups/nhl_groups.parquet

Coverage

One season-less file: one row per group lineage (the league, subdivisions, conferences, divisions) with the first and last season it had members. group_id is SDV's own id (e.g. nhl:metropolitan) and names a lineage: a rename that keeps continuity keeps the id, a new body gets a new one, and notes records each call. Seasons are the ENDING year (2025 = the 2024-25 season).

Returns​

col_nametypedescription
leagueStringLeague code of the table ("nhl"); the prefix of every group_id in it.
group_idStringSDV group id, {league}:{slug}. It names a lineage: renames that keep continuity keep the id, and a new body (a new conference, or a merger the sources treat as new) gets a new one.
levelStringHierarchy level of the group: "league", "subdivision", "conference" or "division".
first_seasonInt32First season in which the group had at least one member (ENDING year: 2025 = the 2024-25 season).
last_seasonInt32Last season in which the group had at least one member (ENDING year: 2025 = the 2024-25 season).
notesStringBuilder notes on the group: the lineage decisions behind its group_id and any source caveats.
load_nhl_groups()

load_nhl_group_seasons​

Release: nhl_groups · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_groups/nhl_group_seasons.parquet

Coverage

One season-less file: one row per group per season it existed, with its name, short name, abbreviation and parent group AS OF that season (never today's label applied to the past) and its member count. season is the ENDING year (2025 = the 2024-25 season).

Returns​

col_nametypedescription
leagueStringLeague code of the table ("nhl"); the prefix of every group_id in it.
group_idStringSDV group id, {league}:{slug}. It names a lineage: renames that keep continuity keep the id, and a new body (a new conference, or a merger the sources treat as new) gets a new one.
seasonInt32Season the row describes (ENDING year: 2025 = the 2024-25 season).
levelStringHierarchy level of the group: "league", "subdivision", "conference" or "division".
nameStringFull name of the group as of that season -- the label in use then, not today's name.
short_nameStringShort display name of the group as of that season.
abbreviationStringAbbreviation of the group as of that season.
parent_group_idStringgroup_id one level up as of that season (division -> conference -> subdivision -> league); null at the top level or where no higher group applied that season.
n_teamsInt32Number of member teams in the group that season.
load_nhl_group_seasons()

load_nhl_group_aliases​

Release: nhl_groups · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_groups/nhl_group_aliases.parquet

Coverage

One season-less file: every name, abbreviation, slug and source id that a source (espn, nhl) uses for a group, each with the seasons it is valid for (valid_from / valid_to, inclusive; null = unbounded). Match a source's conference or division label here to reach group_id.

Returns​

col_nametypedescription
leagueStringLeague code of the table ("nhl"); the prefix of every group_id in it.
group_idStringSDV group id, {league}:{slug}. It names a lineage: renames that keep continuity keep the id, and a new body (a new conference, or a merger the sources treat as new) gets a new one.
sourceStringSource that uses this label or id (in this table: espn, nhl); "sdv" marks SDV's own labels.
source_idStringThe source's own id for the group (ESPN group id, NCAA conf_id, CFBD id, MLB division id) when it has one; null otherwise.
name_kindStringKind of label in value: "name", "short_name", "abbreviation", "slug" or "code".
valueStringThe label exactly as the source writes it; match a source's conference or division label against it to reach group_id.
valid_fromInt32First season the alias is valid for, inclusive (ENDING year: 2025 = the 2024-25 season); null = unbounded.
valid_toInt32Last season the alias is valid for, inclusive (ENDING year: 2025 = the 2024-25 season); null = unbounded (still in use).
load_nhl_group_aliases()

load_nhl_team_group_seasons​

Release: nhl_groups · asset https://github.com/sportsdataverse/sportsdataverse-data/releases/download/nhl_groups/nhl_team_group_seasons_{season}.parquet

Coverage

One row per team per season: the SDV subdivision, conference and division group ids the team belonged to that season (null where a level does not apply), the team name as of that season, where the membership came from, and whether a second source agreed (null when only one source covers the season). team_id is a string: the ESPN team id where ESPN covers the team, otherwise the NHL id; team_id_source names the id space. season is the ENDING year (2025 = the 2024-25 season); seasons 1918-2026. No 2005 asset (the 2004-05 lockout).

Returns​

col_nametypedescription
leagueStringLeague code of the table ("nhl"); the prefix of every group_id in it.
seasonInt32Season of the membership (ENDING year: 2025 = the 2024-25 season).
team_idStringTeam id as a string: the ESPN team id where ESPN covers the team, otherwise the league's own id; team_id_source says which.
team_id_sourceStringId space of team_id (in this table: espn, nhl).
team_nameStringTeam name as of that season, not today's.
subdivision_idStringSDV group_id of the team's subdivision that season (e.g. FBS / FCS, Division I); null where the league has no subdivision level.
conference_idStringSDV group_id of the team's conference that season; null where the team had no conference (an independent, or a season played without conferences).
division_idStringSDV group_id of the team's division that season; null where the level does not apply.
sourceStringSource the membership was taken from -- the most reliable per-season source for that era.
sources_agreeBooleanWhether a second source agreed on the membership; null when only one source covers the season.
notesStringBuilder notes on the team-season, such as a source disagreement or which of several listed memberships was kept.
load_nhl_team_group_seasons(seasons=2024)