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_name | type | description |
|---|---|---|
home_away | String | Home or away indicator. |
team_id | Int64 | Unique team identifier. |
team_abbrev | String | Team abbreviation. |
player_id | Int64 | Unique player identifier. |
player_name | String | Player name. |
sweater_number | Int64 | Jersey number. |
position | String | Player position. |
goals | Int64 | Goals scored. |
assists | Int64 | Assists. |
points | Int64 | Total points (goals + assists). |
plus_minus | Int64 | Plus/minus rating. |
pim | Int64 | Penalty minutes. |
hits | Int64 | Hits. |
power_play_goals | Int64 | Power-play goals. |
shots_on_goal | Int64 | Shots on goal. |
faceoff_winning_pctg | Float64 | Faceoff win percentage. |
toi | String | Time on ice. |
blocked_shots | Int64 | Blocked shots. |
shifts | Int64 | CONSTANT false in every published row: the shift-chart block is not carried on this asset. An availability flag, not a shift count. |
giveaways | Int64 | Giveaways. |
takeaways | Int64 | Takeaways. |
game_id | Int64 | Unique game identifier. |
season | Int64 | Season year (echoed from arg). |
game_date | String | Game date. |
even_strength_shots_against | String | Even-strength shots against (saves/total). |
power_play_shots_against | String | Power-play shots against (saves/total). |
shorthanded_shots_against | String | Shorthanded shots against (saves/total). |
save_shots_against | String | Total shots against (saves/total). |
save_pctg | Float64 | Save percentage. |
even_strength_goals_against | Int64 | Even-strength goals against. |
power_play_goals_against | Int64 | Power-play goals against. |
shorthanded_goals_against | Int64 | Shorthanded goals against. |
goals_against | Int64 | Goals against. |
starter | Boolean | Whether the goalie started the game. |
decision | String | Goalie decision (W/L/O). |
shots_against | Int64 | Shots faced. |
saves | Int64 | Saves 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_name | type | description |
|---|---|---|
game_id | Int32 | Unique game identifier. |
season_full | String | Full season label (e.g. 20212022). |
game_type | String | Game type the row belongs to. |
game_date | String | Game date. |
game_time | String | Scheduled start time of the game. |
home_team_abbr | String | Home team abbreviation. |
away_team_abbr | String | Away team abbreviation. |
home_team_name | String | Home team name. |
away_team_name | String | Away team name. |
home_score | Int32 | Home team final score. |
away_score | Int32 | Away team final score. |
game_state | String | Game state (e.g., FINAL, LIVE). |
venue | String | Venue where the game was played. |
series_letter | String | Playoff series identifier letter, populated only for postseason games (88 of 1,400 rows in 2024) and null for the regular season. |
playoff_round | Int32 | Playoff round identifier. |
series_game_number | Int32 | |
season | Int32 | Season year (echoed from arg). |
game_json | Boolean | Whether processed game JSON is available. |
game_json_url | String | URL to the processed game JSON. |
PBP | Boolean | Whether play-by-play data is available. |
team_box | Boolean | Whether team box score data is available. |
player_box | Boolean | Whether player box score data is available. |
skater_box | Boolean | Whether skater box data is available. |
goalie_box | Boolean | Whether goalie box data is available. |
game_info | Boolean | CONSTANT true: marks that the source game record carried a game-info block. |
game_rosters | Boolean | Whether game rosters data is available. |
scoring | Boolean | CONSTANT true: marks that the source game record carried a scoring-summary block. It is an availability flag, not a count or a scoring event. |
penalties | Boolean | CONSTANT true: marks that the source game record carried a penalty-summary block. It is an availability flag, not a penalty count. |
scratches | Boolean | True when the source game record carried a scratches block for the game. |
linescore | Boolean | CONSTANT: 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_stars | Boolean | CONSTANT true: marks that the source game record carried a three-stars block. |
shifts | Boolean | CONSTANT false in every published row: the shift-chart block is not carried on this asset. An availability flag, not a shift count. |
officials | Boolean | Whether officials data is available. |
shots_by_period | Boolean | Whether shots-by-period data is available. |
shootout | Boolean | Whether 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_name | type | description |
|---|---|---|
home_away | String | Home or away indicator. |
team_id | Int64 | Unique team identifier. |
team_abbrev | String | Team abbreviation. |
team_name | String | Team name. |
goals | Int64 | Goals scored. |
shots_on_goal | Int64 | Shots on goal. |
pim | Int64 | Penalty minutes. |
hits | Int64 | Hits. |
blocked_shots | Int64 | Blocked shots. |
giveaways | Int64 | Giveaways. |
takeaways | Int64 | Takeaways. |
power_play_goals | Int64 | Power-play goals. |
faceoff_win_pctg | Float64 | Faceoff win percentage. |
saves | Int64 | Saves made. |
save_pctg | Float64 | Save percentage. |
goals_against | Int64 | Goals against. |
game_id | Int64 | Unique game identifier. |
season | Int64 | Season year (echoed from arg). |
game_date | String | Game 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_name | type | description |
|---|---|---|
game_id | Int64 | Unique game identifier. |
season | Int64 | Season year (echoed from arg). |
game_type | String | Game type the row belongs to. |
game_date | String | Game date. |
venue | String | Venue where the game was played. |
home_team_abbr | String | Home team abbreviation. |
away_team_abbr | String | Away team abbreviation. |
home_score | Int64 | Home team final score. |
away_score | Int64 | Away team final score. |
game_state | String | Game 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_name | type | description |
|---|---|---|
player_id | Int64 | Unique player identifier. |
full_name | String | Player full name. |
first_name | String | Player first name. |
last_name | String | Player last name. |
team_abbr | String | Team abbreviation. |
team_id | Int64 | Unique team identifier. |
position_code | String | Player position code. |
sweater_number | Int64 | Jersey number. |
game_id | Int64 | Unique game identifier. |
season | Int64 | Season year (echoed from arg). |
game_date | String | Game date. |
shoots_catches | String | Handedness (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_name | type | description |
|---|---|---|
home_away | String | Home or away indicator. |
team_id | Int64 | Unique team identifier. |
team_abbrev | String | Team abbreviation. |
player_id | Int64 | Unique player identifier. |
player_name | String | Player name. |
sweater_number | Int64 | Jersey number. |
even_strength_shots_against | String | Even-strength shots against (saves/total). |
power_play_shots_against | String | Power-play shots against (saves/total). |
shorthanded_shots_against | String | Shorthanded shots against (saves/total). |
save_shots_against | String | Total shots against (saves/total). |
save_pctg | Float64 | Save percentage. |
even_strength_goals_against | Int64 | Even-strength goals against. |
power_play_goals_against | Int64 | Power-play goals against. |
shorthanded_goals_against | Int64 | Shorthanded goals against. |
pim | Int64 | Penalty minutes. |
goals_against | Int64 | Goals against. |
toi | String | Time on ice. |
starter | Boolean | Whether the goalie started the game. |
decision | String | Goalie decision (W/L/O). |
shots_against | Int64 | Shots faced. |
saves | Int64 | Saves made. |
game_id | Int64 | Unique game identifier. |
season | Int64 | Season year (echoed from arg). |
game_date | String | Game 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_name | type | description |
|---|---|---|
game_id | Int64 | Unique game identifier. |
home_team_id | Int64 | Home team identifier. |
home_team_abbr | String | Home team abbreviation. |
home_goals | Int64 | Home goals in the period. |
home_shots | Int64 | Home team shots in the period. |
away_team_id | Int64 | Away team identifier. |
away_team_abbr | String | Away team abbreviation. |
away_goals | Int64 | Away goals in the period. |
away_shots | Int64 | Away team shots in the period. |
has_shootout | Boolean | Flag 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_name | type | description |
|---|---|---|
role | String | Grouped official role (Referee/Linesperson). |
name | String | Team mascot name. |
game_id | Int64 | Unique game identifier. |
season | Int64 | Season year (echoed from arg). |
game_date | String | Game 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_name | type | description |
|---|---|---|
timeInPeriod | String | Time within the period the penalty occurred. |
type | String | Competitor type (e.g. "team"). |
duration | Int64 | Penalty duration in minutes. |
committedByPlayer.firstName.default | String | Given name of the penalized player as published in the NHL feed's default English locale. |
committedByPlayer.firstName.cs | String | Alternate 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.de | String | Alternate 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.es | String | Alternate 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.fi | String | Alternate 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.sk | String | Alternate 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.sv | String | Alternate 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.fr | String | Alternate 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.default | String | Family name of the penalized player as published in the NHL feed's default English locale. |
committedByPlayer.lastName.cs | String | Alternate 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.de | String | Alternate 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.es | String | Alternate 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.fi | String | Alternate 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.sk | String | Alternate 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.sv | String | Alternate 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.fr | String | Alternate 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.sweaterNumber | Int64 | Jersey number of the penalized player on the play. |
teamAbbrev.default | String | Three-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.default | String | Given name, in the feed's default English locale, of the opposing player credited with drawing the penalty. |
drawnBy.firstName.cs | String | Alternate 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.de | String | Alternate 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.es | String | Alternate 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.fi | String | Alternate 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.sk | String | Alternate 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.sv | String | Alternate 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.fr | String | Alternate 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.default | String | Family name, in the feed's default English locale, of the opposing player credited with drawing the penalty. |
drawnBy.lastName.cs | String | Alternate 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.de | String | Alternate 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.es | String | Alternate 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.fi | String | Alternate 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.sk | String | Alternate 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.sv | String | Alternate 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.fr | String | Alternate 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.sweaterNumber | Int64 | Jersey number of the opposing player credited with drawing the infraction; null whenever no victim is credited, as on all bench and game-misconduct penalties. |
descKey | String | Penalty description key. |
game_id | Int64 | Unique game identifier. |
period_number | Int64 | Period number (1-3 regulation, 4+ OT). |
period_type | String | Period type (REG/OT/SO). |
servedBy.default | String | Abbreviated name, in the feed's default English locale, of the player serving the penalty. |
servedBy.cs | String | Alternate 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.de | String | Alternate 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.es | String | Alternate 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.fi | String | Alternate 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.sk | String | Alternate 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.sv | String | Alternate 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_name | type | description |
|---|---|---|
home_away | String | Home or away indicator. |
team_id | Int64 | Unique team identifier. |
team_abbrev | String | Team abbreviation. |
player_id | Int64 | Unique player identifier. |
player_name | String | Player name. |
sweater_number | Int64 | Jersey number. |
position | String | Player position. |
goals | Int64 | Goals scored. |
assists | Int64 | Assists. |
points | Int64 | Total points (goals + assists). |
plus_minus | Int64 | Plus/minus rating. |
pim | Int64 | Penalty minutes. |
hits | Int64 | Hits. |
power_play_goals | Int64 | Power-play goals. |
shots_on_goal | Int64 | Shots on goal. |
faceoff_winning_pctg | Float64 | Faceoff win percentage. |
toi | String | Time on ice. |
blocked_shots | Int64 | Blocked shots. |
shifts | Int64 | CONSTANT false in every published row: the shift-chart block is not carried on this asset. An availability flag, not a shift count. |
giveaways | Int64 | Giveaways. |
takeaways | Int64 | Takeaways. |
game_id | Int64 | Unique game identifier. |
season | Int64 | Season year (echoed from arg). |
game_date | String | Game date. |
even_strength_shots_against | String | Even-strength shots against (saves/total). |
power_play_shots_against | String | Power-play shots against (saves/total). |
shorthanded_shots_against | String | Shorthanded shots against (saves/total). |
save_shots_against | String | Total shots against (saves/total). |
save_pctg | Float64 | Save percentage. |
even_strength_goals_against | Int64 | Even-strength goals against. |
power_play_goals_against | Int64 | Power-play goals against. |
shorthanded_goals_against | Int64 | Shorthanded goals against. |
goals_against | Int64 | Goals against. |
starter | Boolean | Whether the goalie started the game. |
decision | String | Goalie decision (W/L/O). |
shots_against | Int64 | Shots faced. |
saves | Int64 | Saves 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_name | type | description |
|---|---|---|
player_id | Int32 | Unique player identifier. |
full_name | String | Player full name. |
first_name | String | Player first name. |
last_name | String | Player last name. |
team_abbr | String | Team abbreviation. |
team_id | Int32 | Unique team identifier. |
position_code | String | Player position code. |
sweater_number | Int32 | Jersey number. |
season | Int32 | Season year (echoed from arg). |
game_date | String | Game 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_name | type | description |
|---|---|---|
game_id | Int32 | Unique game identifier. |
season_full | String | Full season label (e.g. 20212022). |
game_type | String | Game type the row belongs to. |
game_date | String | Game date. |
game_time | String | Scheduled start time of the game. |
home_team_abbr | String | Home team abbreviation. |
away_team_abbr | String | Away team abbreviation. |
home_team_name | String | Home team name. |
away_team_name | String | Away team name. |
home_score | Int32 | Home team final score. |
away_score | Int32 | Away team final score. |
game_state | String | Game state (e.g., FINAL, LIVE). |
venue | String | Venue where the game was played. |
series_letter | String | NHL API letter code identifying the playoff series the game belongs to (null for regular-season games). |
playoff_round | Int32 | Playoff round identifier. |
series_game_number | Int32 | |
season | Int32 | Season year (echoed from arg). |
game_json | Boolean | Whether processed game JSON is available. |
game_json_url | String | URL to the processed game JSON. |
PBP | Boolean | Whether play-by-play data is available. |
team_box | Boolean | Whether team box score data is available. |
player_box | Boolean | Whether player box score data is available. |
skater_box | Boolean | Whether skater box data is available. |
goalie_box | Boolean | Whether goalie box data is available. |
game_info | Boolean | Whether game info data is available. |
game_rosters | Boolean | Whether game rosters data is available. |
scoring | Boolean | |
penalties | Boolean | Penalty count. |
scratches | Boolean | Flag indicating a scratches payload was captured for this game in the NHL raw store. |
linescore | Boolean | Flag indicating a period-by-period linescore payload was captured for this game in the NHL raw store. |
three_stars | Boolean | Whether three stars data is available. |
shifts | Boolean | Number of shifts. |
officials | Boolean | Whether officials data is available. |
shots_by_period | Boolean | Whether shots-by-period data is available. |
shootout | Boolean | Whether 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_name | type | description |
|---|---|---|
situationCode | String | Strength/situation code for the goal. |
eventId | Int64 | Event identifier within the game. |
strength | String | Strength label (Even, Power Play, Shorthanded). |
playerId | Int64 | Player identifier involved in the event. |
firstName.default | String | Given name of the goal scorer as rendered in the NHL feed's default English locale. |
firstName.cs | String | Alternate 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.de | String | Alternate 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.es | String | Alternate 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.fi | String | Alternate 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.sk | String | Alternate 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.sv | String | Alternate 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.fr | String | Alternate 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.default | String | Family name of the goal scorer as rendered in the NHL feed's default English locale. |
lastName.cs | String | Alternate 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.fi | String | Alternate 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.sk | String | Alternate 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.sv | String | Alternate 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.de | String | Alternate 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.es | String | Alternate 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.fr | String | Alternate 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.default | String | Abbreviated name of the player as published in the NHL feed's default English locale. |
name.cs | String | Alternate 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.de | String | Alternate 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.es | String | Alternate 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.fi | String | Alternate 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.sk | String | Alternate 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.sv | String | Alternate 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.fr | String | Alternate 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.default | String | Three-letter code of the team that scored the goal, resolving to the home club exactly when isHome is true and to the visitor otherwise. |
headshot | String | URL to the player headshot image. |
highlightClipSharingUrl | String | Shareable URL for the goal highlight clip. |
highlightClip | Int64 | Highlight clip identifier. |
discreteClip | Int64 | Discrete clip identifier. |
goalsToDate | Int64 | Scorer goal total to date in the season. |
awayScore | Int64 | Away team score after the goal. |
homeScore | Int64 | Home team score after the goal. |
leadingTeamAbbrev.default | String | Three-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. |
timeInPeriod | String | Time within the period the penalty occurred. |
shotType | String | Type of shot on the goal. |
goalModifier | String | Goal modifier (e.g. empty-net, power-play). |
assists | String | Assists. |
pptReplayUrl | String | URL to the play replay, if available. |
homeTeamDefendingSide | String | Side of the ice the home team is defending. |
isHome | Boolean | Whether the scoring team is the home team. |
game_id | Int64 | Unique game identifier. |
period_number | Int64 | Period number (1-3 regulation, 4+ OT). |
period_type | String | Period type (REG/OT/SO). |
goalInGame | Int64 | Running goal count credited to the scorer within this game at the time of the goal. |
discreteClipFr | Int64 | Numeric NHL video identifier of the French-language standalone clip of the goal, always a different asset id from discreteClip. |
highlightClipSharingUrlFr | String | Shareable nhl.com URL for the French-language highlight clip; its trailing numeric segment is the same id carried in highlightClipFr. |
highlightClipFr | Int64 | NHL 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_name | type | description |
|---|---|---|
id | Int64 | Unique player identifier. |
firstName | String | Scorer first name (localized list). |
lastName | String | Scorer last name (localized list). |
game_id | Int64 | Unique 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_name | type | description |
|---|---|---|
event_team | String | Team associated with the shift change. |
period | Int64 | Period number. |
period_time | String | Elapsed time in the period (MM:SS). |
period_seconds | Int64 | Elapsed seconds in the period. |
game_seconds | Int64 | Elapsed seconds in the game. |
num_on | Int64 | Number of players coming on (line change). |
players_on | String | Names of players coming on. |
ids_on | String | Player ids coming on. |
num_off | Int64 | Number of players going off (line change). |
players_off | String | Names of players going off. |
ids_off | String | Player ids going off. |
event | String | Event description label. |
event_type | String | Standardized event type code. |
game_seconds_remaining | Int64 | Seconds remaining in regulation. |
game_id | Int64 | Unique game identifier. |
season | Int64 | Season year (echoed from arg). |
game_date | String | Game 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_name | type | description |
|---|---|---|
home | Int64 | Whether the player's team was home. |
away | Int64 | Away team shots in the period. |
game_id | Int64 | Unique game identifier. |
season | Int64 | Season year (echoed from arg). |
game_date | String | Game date. |
sequence | Int64 | Sequence order of the season row. |
playerId | Int64 | Player identifier involved in the event. |
teamAbbrev.default | String | Three-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.default | String | Given name of the shooter in the feed's default English locale; null on the per-game summary row. |
firstName.cs | String | Alternate 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.de | String | Alternate 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.es | String | Alternate 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.fi | String | Alternate 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.sk | String | Alternate 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.sv | String | Alternate 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.default | String | Family name of the shooter in the feed's default English locale; null on the per-game summary row. |
lastName.cs | String | Alternate 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.fi | String | Alternate 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.sk | String | Alternate 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.sv | String | Alternate 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. |
shotType | String | Type of shot on the goal. |
result | String | Attempt result (goal/save/miss). |
headshot | String | URL to the player headshot image. |
gameWinner | Boolean | True 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. |
homeScore | Int64 | Home team score after the goal. |
awayScore | Int64 | Away team score after the goal. |
discreteClip | Int64 | Discrete clip identifier. |
discreteClipFr | Int64 | Numeric NHL video identifier of the French-language clip of the shootout attempt, distinct from the id in discreteClip. |
highlightClipSharingUrl | String | Shareable URL for the goal highlight clip. |
highlightClipSharingUrlFr | String | Shareable URL of the French-language broadcast highlight clip for the shootout attempt. |
highlightClip | Int64 | Highlight clip identifier. |
highlightClipFr | Int64 | NHL 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_name | type | description |
|---|---|---|
period | Int64 | Period number. |
period_type | String | Period type (REG/OT/SO). |
max_regulation_periods | Int64 | Number of regulation periods the game format defines before overtime, constant at 3 for every row in the published seasons. |
ot_periods | Int64 | Overtime 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. |
away | Int64 | Away team shots in the period. |
home | Int64 | Whether the player's team was home. |
game_id | Int64 | Unique game identifier. |
season | Int64 | Season year (echoed from arg). |
game_date | String | Game 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_name | type | description |
|---|---|---|
home_away | String | Home or away indicator. |
team_id | Int64 | Unique team identifier. |
team_abbrev | String | Team abbreviation. |
player_id | Int64 | Unique player identifier. |
player_name | String | Player name. |
sweater_number | Int64 | Jersey number. |
position | String | Player position. |
goals | Int64 | Goals scored. |
assists | Int64 | Assists. |
points | Int64 | Total points (goals + assists). |
plus_minus | Int64 | Plus/minus rating. |
pim | Int64 | Penalty minutes. |
hits | Int64 | Hits. |
power_play_goals | Int64 | Power-play goals. |
shots_on_goal | Int64 | Shots on goal. |
faceoff_winning_pctg | Float64 | Faceoff win percentage. |
toi | String | Time on ice. |
blocked_shots | Int64 | Blocked shots. |
shifts | Int64 | CONSTANT false in every published row: the shift-chart block is not carried on this asset. An availability flag, not a shift count. |
giveaways | Int64 | Giveaways. |
takeaways | Int64 | Takeaways. |
game_id | Int64 | Unique game identifier. |
season | Int64 | Season year (echoed from arg). |
game_date | String | Game 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_name | type | description |
|---|---|---|
home_away | String | Home or away indicator. |
team_id | Int64 | Unique team identifier. |
team_abbrev | String | Team abbreviation. |
team_name | String | Team name. |
goals | Int64 | Goals scored. |
shots_on_goal | Int64 | Shots on goal. |
pim | Int64 | Penalty minutes. |
hits | Int64 | Hits. |
blocked_shots | Int64 | Blocked shots. |
giveaways | Int64 | Giveaways. |
takeaways | Int64 | Takeaways. |
power_play_goals | Int64 | Power-play goals. |
faceoff_win_pctg | Float64 | Faceoff win percentage. |
saves | Int64 | Saves made. |
save_pctg | Float64 | Save percentage. |
goals_against | Int64 | Goals against. |
game_id | Int64 | Unique game identifier. |
season | Int64 | Season year (echoed from arg). |
game_date | String | Game 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_name | type | description |
|---|---|---|
star | Int64 | Star ranking (1, 2, or 3). |
playerId | Int64 | Player identifier involved in the event. |
teamAbbrev | String | Penalized team abbreviation (localized list). |
headshot | String | URL to the player headshot image. |
name.default | String | Abbreviated name of the player as published in the NHL feed's default English locale. |
name.cs | String | Alternate 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.sk | String | Alternate 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.fi | String | Alternate 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.sv | String | Alternate 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.de | String | Alternate 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.es | String | Alternate 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.fr | String | Alternate 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. |
sweaterNo | Int64 | Jersey number. |
position | String | Player position. |
goals | Int64 | Goals scored. |
assists | Int64 | Assists. |
points | Int64 | Total points (goals + assists). |
goalsAgainstAverage | Float64 | Goals-against average (goalies). |
savePctg | Float64 | Save percentage (goalies). |
game_id | Int64 | Unique game identifier. |
winner_id | Int64 | Player id of the winning goalie. |
winner_name | String | Name of the winning goalie. |
loser_id | Int64 | Player id of the losing goalie. |
loser_name | String | Name 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
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_name | type | description |
|---|---|---|
league | String | League code of the table ("nhl"); the prefix of every group_id in it. |
group_id | String | SDV 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. |
level | String | Hierarchy level of the group: "league", "subdivision", "conference" or "division". |
first_season | Int32 | First season in which the group had at least one member (ENDING year: 2025 = the 2024-25 season). |
last_season | Int32 | Last season in which the group had at least one member (ENDING year: 2025 = the 2024-25 season). |
notes | String | Builder 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
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_name | type | description |
|---|---|---|
league | String | League code of the table ("nhl"); the prefix of every group_id in it. |
group_id | String | SDV 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. |
season | Int32 | Season the row describes (ENDING year: 2025 = the 2024-25 season). |
level | String | Hierarchy level of the group: "league", "subdivision", "conference" or "division". |
name | String | Full name of the group as of that season -- the label in use then, not today's name. |
short_name | String | Short display name of the group as of that season. |
abbreviation | String | Abbreviation of the group as of that season. |
parent_group_id | String | group_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_teams | Int32 | Number 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
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_name | type | description |
|---|---|---|
league | String | League code of the table ("nhl"); the prefix of every group_id in it. |
group_id | String | SDV 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. |
source | String | Source that uses this label or id (in this table: espn, nhl); "sdv" marks SDV's own labels. |
source_id | String | The 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_kind | String | Kind of label in value: "name", "short_name", "abbreviation", "slug" or "code". |
value | String | The label exactly as the source writes it; match a source's conference or division label against it to reach group_id. |
valid_from | Int32 | First season the alias is valid for, inclusive (ENDING year: 2025 = the 2024-25 season); null = unbounded. |
valid_to | Int32 | Last 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
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_name | type | description |
|---|---|---|
league | String | League code of the table ("nhl"); the prefix of every group_id in it. |
season | Int32 | Season of the membership (ENDING year: 2025 = the 2024-25 season). |
team_id | String | Team 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_source | String | Id space of team_id (in this table: espn, nhl). |
team_name | String | Team name as of that season, not today's. |
subdivision_id | String | SDV group_id of the team's subdivision that season (e.g. FBS / FCS, Division I); null where the league has no subdivision level. |
conference_id | String | SDV 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_id | String | SDV group_id of the team's division that season; null where the level does not apply. |
source | String | Source the membership was taken from -- the most reliable per-season source for that era. |
sources_agree | Boolean | Whether a second source agreed on the membership; null when only one source covers the season. |
notes | String | Builder 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)