STAT-API

NHL Data Dictionary

Main

nhl.seasons8 fieldsendpoints →

Each NHL season — preseason exhibitions, the 82-game regular season, and the Stanley Cup Playoffs (Wild Card, Divisional, Conference Finals, Stanley Cup Finals).

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
league_idstringnullable——Official NHL season identifier
end_datetimestamptznullable—2020-09-19T04:00:00.000Z—
post_season_start_datetimestamptznullable—2020-08-01T04:00:00.000Z—
regular_season_start_datetimestamptznullable—2019-10-02T04:00:00.000Z—
stanley_cup_finals_datetimestamptznullable—2020-09-19T04:00:00.000Z—
start_datetimestamptz—2019-10-02T04:00:00.000Z—
start_yearinteger—2019—
nhl.teams18 fields· 1 refsendpoints →

The 32 NHL franchises, organized into the Eastern and Western Conferences with two divisions each (Atlantic, Metropolitan, Central, Pacific).

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
arena_idbigintnullable→ nhl.arenas1—
league_team_idintegernullable—6Official NHL team ID (issued by the league)
abbreviationstring—BOS—
activeboolean—true—
citystring—Boston—
conferencestring—Eastern—
ValuesEasternWestern
divisionstring—Atlantic—
ValuesAtlanticMetropolitanCentralPacific
full_namestring—Boston Boston Bruins—
head_coachstringnullable———
logo_urlstringnullable——URL to team logo image
namestring—Boston Bruins—
primary_colorstringnullable———
quaternary_colorstringnullable———
secondary_colorstringnullable———
tertiary_colorstringnullable———
wikipedia_logo_urlstringnullable———
wikipedia_wordmark_urlstringnullable———
nhl.games35 fields· 4 refsendpoints →

Every scheduled and played NHL game — preseason, the 82-game regular season, and the four-round Stanley Cup Playoffs through the Stanley Cup Final.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
arena_idbigintnullable→ nhl.arenas1—
away_team_idbigint→ nhl.teams1—
home_team_idbigint→ nhl.teams1—
league_game_idintegernullable—2024020051Official NHL game ID (issued by the league)
league_idstringnullable——Official NHL game identifier
season_idbigint→ nhl.seasons2021—
attendanceintegernullable———
away_team_scoreintegernullable—2—
away_team_score_overtimeintegernullable—0—
away_team_score_period1integernullable—0—
away_team_score_period2integernullable—1—
away_team_score_period3integernullable—1—
away_team_series_winsintegernullable———
channelstringnullable———
dayinteger—20241022Calendar day as a YYYYMMDD integer (e.g. 20240915), US Eastern.
game_timetimestamptz—2025-11-27T00:00:00.000ZScheduled puck drop (timezone-aware).
home_team_scoreintegernullable—3—
home_team_score_overtimeintegernullable—0—
home_team_score_period1integernullable—0—
home_team_score_period2integernullable—1—
home_team_score_period3integernullable—1—
home_team_series_winsintegernullable———
is_overtimeboolean—false—
Valuesfalsetrue
is_shootoutboolean—false—
Valuesfalsetrue
last_playstringnullable———
neutral_siteboolean—false—
Valuesfalsetrue
overtime_periodsintegernullable—0—
periodstringnullable——Current period (1, 2, 3, OT, SO, Final)
playoff_roundstringnullable——First Round, Second Round, Conference Finals, Stanley Cup Final
season_typestring—regular_seasonCanonical season phase (text). Was integer 1/2/3/4 before the 2026-06-29 normalization.
Valuesregular_seasonpostseasonpreseason
series_game_numberintegernullable———
statusstring—Final—
time_remaining_minutesintegernullable———
time_remaining_secondsintegernullable———
nhl.players35 fields· 2 refsendpoints →

Every individual who has played in the NHL — current rosters, AHL call-ups, free agents, and retired players, with their shooting hand, position, and home country.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
draft_team_idbigintnullable→ nhl.teams——
league_idstringnullable——Official NHL player identifier
league_player_idinteger—8482705Official NHL player ID (issued by the league)
team_idbigintnullable→ nhl.teams27—
birth_citystringnullable—Toronto—
birth_countrystringnullable—CAN—
birth_datedatenullable—2004-03-30—
birth_statestringnullable—Ontario—
catchesstringnullable—L—
ValuesLR
collegestringnullable———
draft_overall_pickintegernullable—2—
draft_pickintegernullable—1—
draft_roundintegernullable—1—
draft_yearintegernullable—2022—
experienceintegernullable——Years of NHL experience
first_namestring—Ryan—
full_namestring—Elias Pettersson—
heightintegernullable—74Height in inches
injury_body_partstringnullable———
injury_notesstringnullable———
injury_start_datetimestamptznullable———
injury_statusstringnullable———
jerseystringnullable—44—
last_namestring—Smith—
nationalitystringnullable———
photo_urlstringnullable—https://assets.nhle.com/mugs/nhl/20262027/CBJ/8482705.pngURL to player headshot image
position_categorystringnullable———
primary_positionstring—D—
ValuesDCGLLWRWR
rookie_yearintegernullable———
roster_statusstringnullable—inactiveCanonical roster status, shared across leagues. NHL source granularity is coarse: "active" (on a current api-web team roster), "free_agent" (no team), "inactive" (not currently rostered); injured_reserve where derivable. The "on a team now" set is {active, injured_reserve}.
Valuesinactiveactive
shootsstringnullable—L—
ValuesLR
weightintegernullable—190Weight in pounds
youth_leaguestringnullable———
youth_teamstringnullable———

Plays

nhl.game_shifts11 fields· 3 refsendpoints →

Every shift of every player in every NHL game since 2021-22 — the period, when the player came on and went off the ice and how long the shift lasted.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nhl.games15957—
league_shift_idbigintnullable——The league's id for this shift. Empty for a shift rebuilt from the official time-on-ice report.
player_idbigint→ nhl.players6878—
team_idbigint→ nhl.teams30—
detail_codeintegernullable——The league's shift detail code (0 for a regular shift). Empty for a shift rebuilt from the official time-on-ice report.
duration_secondsinteger—43—
end_secondsinteger—1200Seconds elapsed in the period when the shift ended
periodinteger—1—
shift_numberinteger—1The player's shift number in the game
start_secondsinteger—0Seconds elapsed in the period when the shift started
nhl.penalties12 fields· 4 refsendpoints →

Every penalty assessed in every NHL game — the player penalized, the infraction (hooking, tripping, slashing, etc.), the minutes assessed (2-minute minor, 4-minute double minor, 5-minute major, game misconduct, match penalty), and the resulting power play.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
drawn_by_player_idbigintnullable→ nhl.players453—
game_idbigint→ nhl.games4002—
penalty_idinteger—36—
player_idbigintnullable→ nhl.players1189—
team_idbigint→ nhl.teams16—
descriptionstringnullable———
is_bench_penaltyboolean—false—
Valuesfalsetrue
penalty_minutesinteger—2—
penalty_typestring—tripping—
period_numberinteger—2—
time_remainingstring—00:00Time remaining in period (MM:SS)
nhl.periods8 fields· 1 refsendpoints →

Per-period scores for every NHL game — the three regulation periods plus any overtime and the shootout, with the away and home goals in each. (Shots and penalties per period are not carried here.)

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nhl.games5762—
league_game_idinteger—2020030184Official NHL game ID (issued by the league; matches nhl.games.league_game_id).
period_idinteger—1—
away_team_scoreinteger—0—
home_team_scoreinteger—0—
namestring—1st1, 2, 3, OT, OT2, SO
Values1st2nd3rdOvertimeShootoutOT2OT3
period_numberinteger—1—
nhl.play_by_plays39 fields· 16 refsendpoints →

Every event in every NHL game since 2021-22 — faceoffs, shots on goal, missed and blocked shots, hits, giveaways, takeaways, goals, penalties and stoppages — with the period, the game clock, the rink coordinates, the players involved and the score and shots on goal after the event.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
assist1_player_idbigintnullable→ nhl.players307—
assist2_player_idbigintnullable→ nhl.players7123—
blocking_player_idbigintnullable→ nhl.players15—
committed_by_player_idbigintnullable→ nhl.players834Player who took the penalty
drawn_by_player_idbigintnullable→ nhl.players308Player who drew the penalty
event_idinteger—58The league's event number, unique within the game
event_owner_team_idbigintnullable→ nhl.teams29Team credited with the event
game_idbigint→ nhl.games15003—
goalie_in_net_idbigintnullable→ nhl.players531Goaltender the shot was taken against
hittee_player_idbigintnullable→ nhl.players353—
hitting_player_idbigintnullable→ nhl.players7297—
losing_player_idbigintnullable→ nhl.players6627Faceoff loser
player_idbigintnullable→ nhl.players105Player of a giveaway or takeaway
scoring_player_idbigintnullable→ nhl.players858—
served_by_player_idbigintnullable→ nhl.players7393Player who served the penalty (bench and goalie penalties)
shooting_player_idbigintnullable→ nhl.players6757—
winning_player_idbigintnullable→ nhl.players6627Faceoff winner
away_scoreintegernullable—1Away goals after the event; empty on most event types
away_sogintegernullable—2Away shots on goal after the event; empty on most event types
home_scoreintegernullable—1Home goals after the event; empty on most event types
home_sogintegernullable—19Home shots on goal after the event; empty on most event types
penalty_desc_keystringnullable—hookingThe infraction (e.g. tripping, hooking, slashing)
penalty_minutesintegernullable—2—
penalty_type_codestringnullable—MINPenalty class (MIN minor, MAJ major, BEN bench minor, MIS misconduct, GAM game misconduct, MAT match, PS penalty shot)
ValuesMINMAJMISBENGAM
period_numberinteger—1—
period_typestring—REGREG, OT or SO (shootout)
ValuesREGOTSO
reasonstringnullable—wide-of-netWhy a shot missed or play stopped (e.g. wide-of-net, icing, goalie-stopped-after-sog)
secondary_reasonstringnullable—tv-timeout—
Valuestv-timeouthome-timeoutvisitor-timeoutplayer-injuryice-problem
shot_typestringnullable—wristwrist, snap, slap, tip-in, backhand, deflected, wrap-around, bat, poke
Valueswristslapsnapbackhandtip-indeflectedwrap-around
situation_codestringnullable—1551Four digits: away goalie in net (1/0), away skaters, home skaters, home goalie in net (1/0); e.g. 1551 is five on five
sort_orderintegernullable—8Order of the event within the game
time_in_period_secondsinteger—0Seconds elapsed in the period when the event happened
time_remaining_secondsinteger—1200Seconds left in the period when the event happened
type_codeinteger—502The league's numeric event type (e.g. 505 goal, 506 shot on goal, 502 faceoff)
type_desc_keystring—faceoffEvent type (e.g. goal, shot-on-goal, faceoff, hit, penalty)
Valuesfaceoffshot-on-goalhitstoppageblocked-shotmissed-shotgiveawaytakeawaypenaltygoalperiod-startperiod-enddelayed-penaltygame-endshootout-complete
x_coordintegernullable—69Rink x coordinate in feet from center ice
y_coordintegernullable—22Rink y coordinate in feet from center ice
zone_codestringnullable—OZone of the event for the owning team (O offensive, D defensive, N neutral)
ValuesODN
nhl.scoring_plays13 fields· 5 refsendpoints →

Every goal scored in every NHL game — the scorer, the assists, the goaltender beaten, the strength (even strength, power play, short-handed), and the score state when the goal went in.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nhl.games4367—
primary_assist_player_idbigintnullable→ nhl.players1120—
scored_by_player_idbigintnullable→ nhl.players161—
scoring_play_idinteger—99—
secondary_assist_player_idbigintnullable→ nhl.players126—
team_idbigint→ nhl.teams7—
away_team_scoreinteger—1—
descriptionstringnullable———
goal_typestringnullable—wrist—
Valueswristsnapslapbackhandtip-indeflectedwrap-aroundbatpoke
home_team_scoreinteger—1—
period_numberinteger—3—
time_remainingstring—00:59Time remaining in period (MM:SS)

Stats

nhl.operator_team_lookups6 fields· 2 refsendpoints →

How each sportsbook and fantasy operator names every NHL team — the mapping from each operator's team code to the unified franchise record.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
operator_idbigint→ main.operators1Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo; every id is listed at /api/v1/reference/operators.
operator_team_idstring—4007External team ID from operator
team_idbigint→ nhl.teams25Internal nhl.teams.id reference
abbreviationstringnullable—ANATeam abbreviation for reconciliation
team_namestringnullable—Anaheim DucksTeam name for reconciliation
nhl.season_team_stats36 fields· 2 refsendpoints →

Season totals for each NHL team — wins, losses, overtime losses, points, goals for and against, shooting percentage, save percentage, power-play and penalty-kill efficiency, faceoff percentages.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
season_idbigint→ nhl.seasons2025—
team_idbigint→ nhl.teams18—
blocked_shotsinteger—0—
faceoff_lossesinteger—0—
faceoff_percentagedecimal—0.0000—
faceoff_winsinteger—0—
games_playedinteger—82—
giveawaysinteger—0—
goal_differentialinteger—21—
goals_againstinteger—226—
goals_against_averagedecimal—0.0000—
goals_against_per_gamedecimal—3.0000—
goals_forinteger—238—
goals_per_gamedecimal—3.0000—
hitsinteger—0—
lossesinteger—27—
overtime_lossesinteger—7—
penalty_kill_goals_againstinteger—0—
penalty_kill_percentagedecimal—0.0000—
penalty_minutesinteger—0—
power_play_goalsinteger—0—
power_play_opportunitiesinteger—0—
power_play_percentagedecimal—0.0000—
ptsinteger—92—
pts_percentagedecimal—0.5610—
save_percentagedecimal—0.0000—
season_typestring—regular_seasonCanonical season phase (text). Was integer 1/2/3 before the 2026-06-29 normalization.
shooting_percentagedecimal—0.0000—
short_handed_goalsinteger—0—
shots_againstinteger—0—
shots_forinteger—0—
shutoutsinteger—0—
takeawaysinteger—0—
times_shorthandedinteger—0—
winsinteger—35—
nhl.standings36 fields· 2 refsendpoints →

Current conference and division standings for the NHL season — wins, losses, overtime losses, points, points percentage, games behind, and home/away splits. One snapshot per team per season (no as-of-date history).

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
season_idbigint→ nhl.seasons2025—
team_idbigint→ nhl.teams18—
away_lossesinteger—19—
away_overtime_lossesinteger—4—
away_winsinteger—17—
clinched_conferenceboolean—false—
clinched_divisionboolean—false—
clinched_playoffsboolean—true—
Valuestruefalse
clinched_presidents_trophyboolean—false—
conferencestring—Eastern—
ValuesEasternWestern
conference_rankinteger—0—
divisionstring—Metropolitan—
ValuesMetropolitanAtlanticCentralPacificDiscover CentralMassMutual EastHonda WestScotia North
division_rankinteger—1—
games_playedinteger—82—
goal_differentialinteger—21—
goals_againstinteger—226—
goals_forinteger—238—
home_lossesinteger—13—
home_overtime_lossesinteger—4—
home_winsinteger—20—
last_10_lossesinteger—4—
last_10_overtime_lossesinteger—1—
last_10_winsinteger—6—
lossesinteger—27—
overtime_lossesinteger—7—
ptsinteger—92—
pts_percentagedecimal—0.5610—
rankinteger—1—
regulation_winsinteger—30—
season_typestring—regular_season—
shootout_lossesinteger—2—
shootout_winsinteger—2—
streakstringnullable—W1Current streak (W3, L2, OTL1)
ValuesW1L1W2L2OT1W3L3W4W6OT2W5L4L5W8W7W9OT4L7
wild_card_rankintegernullable—0—
winsinteger—35—
nhl.team_standings25 fields· 2 refsendpoints →

Each NHL team's record entering each of its game days — wins, losses, overtime losses, points, point percentage, goals for and against, home/away splits, last-10 record, streak and games left. Computed from the games, with no look-ahead.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
season_idbigint→ nhl.seasons2021—
team_idbigint→ nhl.teams4—
away_lossesinteger—11—
away_overtime_lossesinteger—2—
away_winsinteger—3—
dayinteger—20220429YYYYMMDD — the record entering this day (games before it)
games_playedinteger—82—
games_remaininginteger—0—
goals_againstinteger—0—
goals_forinteger—0—
home_lossesinteger—3—
home_overtime_lossesinteger—1—
home_winsinteger—10—
l10_lossesinteger—3—
l10_overtime_lossesinteger—1—
l10_winsinteger—6—
lossesinteger—21—
overtime_lossesinteger—0—
ptsinteger—0—
pts_percentagedecimalnullable—0.5000—
regulation_winsinteger—7—
season_typestring—regular_seasonregular_season or postseason (the record is the regular-season record)
Valuesregular_seasonpostseason
streakstringnullable—W1e.g. W3, L1, OT2
winsinteger—10—
nhl.game_player_stats67 fields· 3 refsendpoints →

Each NHL player's stat line for each game — goals, assists, plus-minus, shots on goal, hits, blocks, penalties in minutes, power-play points, time on ice, plus the goaltender line (saves, shots against, goals against, save percentage).

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nhl.games1—
opponent_idbigintnullable—27—
player_idbigint→ nhl.players51—
team_idbigint→ nhl.teams27—
assistsinteger—0—
blocked_shotsinteger—0—
empty_net_goalsinteger—0—
even_strength_assistsinteger—0—
even_strength_goalsinteger—0—
even_strength_time_on_ice_secondsinteger—0—
faceoff_percentagedecimal—0.0000—
faceoffs_lostinteger—0—
faceoffs_woninteger—0—
first_period_goals_againstinteger—0—
game_winning_goalsinteger—0—
gamesinteger—11 if player appeared, 0 if not
giveawaysinteger—0—
goalsinteger—0—
goals_againstinteger—0—
goals_against_averagedecimal—0.0000—
hitsinteger—0—
home_or_awaystringnullable———
is_game_overboolean—true—
lossesinteger—0—
major_penaltiesinteger—0—
minor_penaltiesinteger—0—
minutes_playedinteger—0Goalie minutes played
overtime_goalsinteger—0—
overtime_goals_againstinteger—0—
overtime_lossesinteger—0—
penaltiesinteger—0—
penalty_minutesinteger—0—
plus_minusinteger—0—
power_play_assistsinteger—0—
power_play_goalsinteger—0—
power_play_goals_againstinteger—0—
power_play_ptsinteger—0—
power_play_savesinteger—0—
power_play_shots_againstinteger—0—
power_play_time_on_ice_secondsinteger—0—
ptsinteger—0—
save_percentagedecimal—0.0000—
savesinteger—0—
second_period_goals_againstinteger—0—
shiftsinteger—0—
shooting_percentagedecimal—0.0000—
shootout_attemptsinteger—0—
shootout_goalsinteger—0—
shootout_goals_againstinteger—0—
shootout_savesinteger—0—
short_handed_assistsinteger—0—
short_handed_goalsinteger—0—
short_handed_goals_againstinteger—0—
short_handed_ptsinteger—0—
short_handed_savesinteger—0—
short_handed_shots_againstinteger—0—
short_handed_time_on_ice_secondsinteger—0—
shotsinteger—0—
shots_againstinteger—0—
shots_on_goalinteger—0—
shutoutsinteger—0—
startedinteger—0—
takeawaysinteger—0—
third_period_goals_againstinteger—0—
time_on_ice_secondsinteger—0—
winsinteger—0—
nhl.game_team_stats30 fields· 2 refsendpoints →

Each NHL team's stat line for each game — goals scored and allowed, shots on goal, power-play and penalty-kill performance, faceoff percentage, hits, blocks, and time-on-ice splits.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nhl.games1—
team_idbigint→ nhl.teams7—
assistsinteger—4—
blocked_shotsinteger—12—
faceoff_percentagedecimal—0.0000—
faceoffs_lostinteger—0—
faceoffs_woninteger—0—
giveawaysinteger—9—
goalsinteger—3—
goals_againstinteger—3—
hitsinteger—19—
lossesinteger—0—
overtime_lossesinteger—0—
penaltiesinteger—0—
penalty_kill_goals_againstinteger—0—
penalty_kill_percentagedecimal—0.0000—
penalty_minutesinteger—6—
power_play_attemptsinteger—0—
power_play_goalsinteger—0—
power_play_percentagedecimal—0.0000—
save_percentagedecimal—0.0000—
savesinteger—28—
shooting_percentagedecimal—0.0000—
short_handed_goalsinteger—0—
shotsinteger—28—
shots_on_goalinteger—28—
takeawaysinteger—6—
times_shorthandedinteger—0—
winsinteger—0—
nhl.operator_game_fantasy_stats65 fields· 2 refsendpoints →

Game-level NHL fantasy scoring summaries per operator — total points produced and the breakdown of how that total was assembled from individual stat categories.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nhl.games3020—
operator_idbigint→ main.operators1—
operator_scoring_format_idbigint—2—
away_assist_fptsdecimal—40.0000—
away_block_bonus_fptsdecimal—0.0000—
away_blocked_shot_fptsdecimal—20.8000—
away_fptsdecimal—125.6000—
away_goal_fptsdecimal—25.5000—
away_goalie_win_fptsdecimal—0.0000—
away_goals_against_fptsdecimal—-10.5000—
away_hat_trick_fptsdecimal—0.0000—
away_overtime_loss_fptsdecimal—0.0000—
away_penalty_minutes_fptsdecimal—0.0000—
away_plus_minus_fptsdecimal—0.0000—
away_power_play_assist_fptsdecimal—0.0000—
away_power_play_goal_fptsdecimal—0.0000—
away_save_fptsdecimal—22.4000—
away_shootout_goal_fptsdecimal—0.0000—
away_short_handed_assist_fptsdecimal—0.0000—
away_short_handed_goal_fptsdecimal—0.0000—
away_shot_bonus_fptsdecimal—0.0000—
away_shot_on_goal_fptsdecimal—48.0000—
away_shutout_fptsdecimal—0.0000—
home_assist_fptsdecimal—40.0000—
home_block_bonus_fptsdecimal—0.0000—
home_blocked_shot_fptsdecimal—20.8000—
home_fptsdecimal—133.6000—
home_goal_fptsdecimal—25.5000—
home_goalie_win_fptsdecimal—0.0000—
home_goals_against_fptsdecimal—-10.5000—
home_hat_trick_fptsdecimal—0.0000—
home_overtime_loss_fptsdecimal—0.0000—
home_penalty_minutes_fptsdecimal—0.0000—
home_plus_minus_fptsdecimal—0.0000—
home_power_play_assist_fptsdecimal—0.0000—
home_power_play_goal_fptsdecimal—0.0000—
home_save_fptsdecimal—22.4000—
home_shootout_goal_fptsdecimal—0.0000—
home_short_handed_assist_fptsdecimal—0.0000—
home_short_handed_goal_fptsdecimal—0.0000—
home_shot_bonus_fptsdecimal—0.0000—
home_shot_on_goal_fptsdecimal—48.0000—
home_shutout_fptsdecimal—0.0000—
player_countinteger—40—
total_assist_fptsdecimal—40.0000—
total_block_bonus_fptsdecimal—0.0000—
total_blocked_shot_fptsdecimal—41.6000—
total_fptsdecimal—264.8000—
total_goal_fptsdecimal—42.5000—
total_goalie_win_fptsdecimal—6.0000—
total_goals_against_fptsdecimal—-28.0000—
total_hat_trick_fptsdecimal—0.0000—
total_overtime_loss_fptsdecimal—0.0000—
total_penalty_minutes_fptsdecimal—0.0000—
total_plus_minus_fptsdecimal—0.0000—
total_power_play_assist_fptsdecimal—0.0000—
total_power_play_goal_fptsdecimal—0.0000—
total_save_fptsdecimal—39.2000—
total_shootout_goal_fptsdecimal—0.0000—
total_short_handed_assist_fptsdecimal—0.0000—
total_short_handed_goal_fptsdecimal—0.0000—
total_shot_bonus_fptsdecimal—0.0000—
total_shot_on_goal_fptsdecimal—96.0000—
total_shutout_fptsdecimal—0.0000—
nhl.operator_player_fantasy_stats25 fields· 3 refsendpoints →

Each NHL player's fantasy point total for each game, scored under each fantasy operator's specific scoring rules.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nhl.games3020—
operator_idbigint→ main.operators1—
operator_scoring_format_idbigint—2—
player_idbigint→ nhl.players103—
assist_fptsdecimal—0.0000—
block_bonus_fptsdecimal—0.0000Bonus for 3+ blocked shots
blocked_shot_fptsdecimal—0.0000—
fantasy_ptsdecimal—0.0000—
goal_fptsdecimal—0.0000—
goalie_win_fptsdecimal—0.0000—
goals_against_fptsdecimal—0.0000Negative points for goals allowed
hat_trick_fptsdecimal—0.0000Bonus for 3+ goals
overtime_loss_fptsdecimal—0.0000DK: +2 for OT loss
penalty_minutes_fptsdecimal—0.0000Typically negative or zero
plus_minus_fptsdecimal—0.0000—
power_play_assist_fptsdecimal—0.0000—
power_play_goal_fptsdecimal—0.0000—
save_fptsdecimal—0.0000—
shootout_goal_fptsdecimal—0.0000—
short_handed_assist_fptsdecimal—0.0000—
short_handed_goal_fptsdecimal—0.0000—
shot_bonus_fptsdecimal—0.0000Bonus for 5+ shots on goal
shot_on_goal_fptsdecimal—0.0000—
shutout_fptsdecimal—0.0000—
nhl.operator_player_lookups9 fields· 2 refsendpoints →

How each sportsbook and fantasy operator names every NHL player — the mapping from each operator's player identifier to a unified player record.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
operator_idbigint→ main.operators1Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo; every id is listed at /api/v1/reference/operators.
operator_player_idstring—8478042External player ID from operator
player_idbigintnullable→ nhl.players404Internal nhl.players.id reference
decided_attimestamptznullable—2026-08-19T22:09:48.576ZWhen the pin or block was decided.
decided_reasonstringnullable—6740 "C. Schneider" is a GOALIE, nhl id 8471239 (2004 draft class) = Cory Schneider; the mirror nam…Evidence behind a pinned or blocked decision.
Values6740 "C. Schneider" is a GOALIE, nhl id 8471239 (2004 draft class) = Cory Schneider; the mirror nam…7321 "C. Fitzgerald", nhl id 8479578 (2016 draft class = Casey, BUF 3rd rd #86); 67 NHL games match…Same human as DK 269241: 6740 is the goalie Cory Schneider (nhl 8471239).6585 "R. Carpenter" is a CENTER with 257 NHL games in our logs = Ryan Carpenter (nhl 8477846); mirr…Same human as DK 1363071: 7369 is the COL goalie D. Smith, game 2021-12-16.Mirror names this id Cole Schneider, a left wing (NSH/NYR). The only C. Schneider row we hold (6740…7153 "M. Phillips" is a RIGHT WING, nhl id 8479547 (2016 draft class) = Matthew Phillips (CGY 2016 …Mirror names this id Markus Phillips, a defenseman (LA/WPG). 7153 is the RW Matthew; no Markus Phil…Mirror names this id Cavan Fitzgerald (CAR/SJ, undrafted); no Cavan Fitzgerald row exists in nhl.pl…Mirror names this id Dalton Smith, BUF/COL. 6959 "D. Smith" (LW, nhl id 8475748 = 2010 draft class,…Mirror names this id Dustin Smith, COL, Jan-Jun 2022 only. 7369 "D. Smith" is a GOALIE whose single…Same human as DK 651123: no Cole Schneider row exists; 6740 is the goalie Cory.Same human as DK 920505: 7153 is the RW Matthew Phillips (nhl 8479547).Same human as DK 1057228: no Markus Phillips row exists; 7153 is Matthew.Same human as DK 920402: 7321 is Casey Fitzgerald (nhl 8479578).Same human as DK 894729: no Cavan Fitzgerald row exists; 7321 is Casey.Same human as DK 554479: 6959 is Dalton Smith (LW, BUF game 2019-12-31).Mirror names this id Robert "Bobo" Carpenter (NSH/NYI); he has no NHL games and no row in nhl.playe…7049 "G. Smith" (C, nhl 8476966 = 2012 draft class, DAL 4th rd = Gemel) has TBL 2019-21 and DET 202…6912 "G. Smith" (RW, nhl 8479379 = 2016 draft class, DET 2nd rd = Givani) has DET→FLA→SJS→COL in ou…
decisionstringnullable—derivedHow this mapping was decided: 'derived' (finder answer, overwritable), 'pinned' (decided on evidence, trigger-protected), 'blocked' (no player we hold is this id; player_id NULL, never retried). DB default 'derived'; a BEFORE UPDATE trigger preserves non-derived rows.
Valuesderivedpinnedblocked
player_namestringnullable—Alex TuchPlayer name for reconciliation
positionstringnullable—DPosition for reconciliation
ValuesDCWGRWLW
nhl.operator_team_fantasy_stats26 fields· 3 refsendpoints →

Each NHL team's fantasy point total for each game under each fantasy operator's scoring rules.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nhl.games3020—
operator_idbigint→ main.operators1—
operator_scoring_format_idbigint—2—
team_idbigint→ nhl.teams2—
player_countinteger—20—
total_assist_fptsdecimal—40.0000—
total_block_bonus_fptsdecimal—0.0000—
total_blocked_shot_fptsdecimal—20.8000—
total_fptsdecimal—175.2000—
total_goal_fptsdecimal—25.5000—
total_goalie_win_fptsdecimal—0.0000—
total_goals_against_fptsdecimal—-10.5000—
total_hat_trick_fptsdecimal—0.0000—
total_overtime_loss_fptsdecimal—0.0000—
total_penalty_minutes_fptsdecimal—0.0000—
total_plus_minus_fptsdecimal—0.0000—
total_power_play_assist_fptsdecimal—0.0000—
total_power_play_goal_fptsdecimal—0.0000—
total_save_fptsdecimal—22.4000—
total_shootout_goal_fptsdecimal—0.0000—
total_short_handed_assist_fptsdecimal—0.0000—
total_short_handed_goal_fptsdecimal—0.0000—
total_shot_bonus_fptsdecimal—0.0000—
total_shot_on_goal_fptsdecimal—48.0000—
total_shutout_fptsdecimal—0.0000—
nhl.season_player_stats62 fields· 3 refsendpoints →

Season totals for each NHL player — goals, assists, points, plus-minus, shots on goal, hits, blocks, penalty minutes, power-play and short-handed contributions, plus goaltender stats (wins, saves, shutouts, save percentage, goals-against average).

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
player_idbigint→ nhl.players6—
season_idbigint→ nhl.seasons2021—
team_idbigintnullable→ nhl.teams22—
assistsinteger—0—
assists_per_gamedecimal—0.0000—
blocked_shotsinteger—0—
empty_net_goalsinteger—0—
even_strength_assistsinteger—0—
even_strength_goalsinteger—0—
even_strength_time_on_ice_secondsinteger—0—
faceoff_percentagedecimal—0.0000—
faceoffs_lostinteger—0—
faceoffs_woninteger—0—
game_winning_goalsinteger—0—
games_playedinteger—4—
games_startedinteger—0—
giveawaysinteger—0—
goalsinteger—0—
goals_againstinteger—0—
goals_against_averagedecimal—0.0000—
goals_per_gamedecimal—0.0000—
hat_tricksinteger—0—
hitsinteger—0—
lossesinteger—0—
major_penaltiesinteger—0—
minor_penaltiesinteger—0—
minutes_playedinteger—0—
overtime_goalsinteger—0—
overtime_lossesinteger—0—
penaltiesinteger—0—
penalty_minutesinteger—0—
plus_minusinteger—0—
positionstringnullable———
power_play_assistsinteger—0—
power_play_goalsinteger—0—
power_play_ptsinteger—0—
power_play_time_on_ice_secondsinteger—0—
ptsinteger—0—
pts_per_gamedecimal—0.0000—
save_percentagedecimal—0.0000—
savesinteger—0—
season_typestring—regular_seasonCanonical season phase (text). Was integer 1/2/3 before the 2026-06-29 normalization.
Valuesregular_seasonpreseasonpostseason
shiftsinteger—0—
shooting_percentagedecimal—0.0000—
shootout_attemptsinteger—0—
shootout_goalsinteger—0—
shootout_goals_againstinteger—0—
shootout_missesinteger—0—
shootout_savesinteger—0—
short_handed_assistsinteger—0—
short_handed_goalsinteger—0—
short_handed_ptsinteger—0—
short_handed_time_on_ice_secondsinteger—0—
shotsinteger—0—
shots_againstinteger—0—
shots_on_goalinteger—0—
shutoutsinteger—0—
takeawaysinteger—0—
time_on_ice_per_gamedecimal—0.0000—
time_on_ice_secondsinteger—0—
winsinteger—0—

Projections

nhl.projected_player_stats43 fields· 3 refsendpoints →

Our projection of each NHL player in each game before puck drop — the chance to play and to start, the ice time with its range, the power-play and short-handed time, goals, assists, shots on goal, blocked shots, the power-play and short-handed goals and assists, shootout goals, and the goalie line (win, saves, goals against, shutout, overtime loss), with the chance of each bonus threshold. One current row per game, player and engine version, the same stat line for every DFS operator; it updates until puck drop and never changes after. GET /api/v1/dfs/slates/{slate_id}/projections serves this stat line for every seat of a DFS slate with its fantasy points.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nhl.games21037—
player_idbigint→ nhl.players351—
projection_idbigint—4Engine version id (main.projections; STAT_API_NHL 1.0).
team_idbigint→ nhl.teams8—
afloat—0Projected assists (mean).
blkfloat—0Projected blocked shots (mean).
blocks_3_probabilityfloat—0Chance of 3 or more blocked shots, 0 to 1.
gfloat—0Projected goals (mean), regulation and overtime; a shootout goal is so_g.
gafloat—0Projected goals against (mean; 0 for a skater).
hat_trick_probabilityfloat—0Chance of 3 or more goals, 0 to 1.
injury_tagstringnullable—IRThe injury tag of the lineup reading (IR, DTD, ...); null when none.
ValuesIRIR-LTOUTIR-NRDTD
inputs_as_oftimestamptz—2026-11-14T23:58:05.827ZTime of the newest input the projection used (UTC). Always before the game's puck drop.
lineup_captured_attimestamptznullable—2026-11-18T13:02:04.647ZWhen the lineup reading the projection used was captured (UTC); null when no reading was in.
lineup_unitstringnullable—injuredThe player's unit in the lineup reading the projection used — a forward line (line1 to line4), a defensive pairing (pair1 to pair3), a power-play unit (pp1, pp2), goalie or injured; null when no lineup reading was in.
Valuesinjuredline1line3line2pair1pair2pair3goaliepp2pp1
minutes_meanfloat—0Projected time on ice, minutes (mean).
minutes_p10float—0Projected time on ice, 10th percentile, minutes.
minutes_p25float—0Projected time on ice, 25th percentile, minutes.
minutes_p50float—0Projected time on ice, median, minutes.
minutes_p75float—0Projected time on ice, 75th percentile, minutes.
minutes_p90float—0Projected time on ice, 90th percentile, minutes.
minutes_stdfloat—0Standard deviation of the projected time on ice, minutes.
otlfloat—0Chance the goalie is charged with the overtime loss, 0 to 1 (0 for a skater).
play_probabilityfloat—0Chance the player plays (dresses for the game), 0 to 1.
points_3_probabilityfloat—0Chance of 3 or more points (goals plus assists), 0 to 1.
positionstring—DThe player's position in our engine for this game — C, W, D or G.
ValuesDWCG
pp_minutes_meanfloat—0Projected power-play time on ice, minutes (mean).
ppafloat—0Projected power-play assists (mean), a part of a.
ppgfloat—0Projected power-play goals (mean), a part of g.
relief_probabilityfloat—0Chance the goalie enters in relief, 0 to 1 (0 for a skater).
saves_35_probabilityfloat—0Chance of 35 or more saves, 0 to 1.
sh_minutes_meanfloat—0Projected short-handed time on ice, minutes (mean).
shafloat—0Projected short-handed assists (mean), a part of a.
shgfloat—0Projected short-handed goals (mean), a part of g.
shots_5_probabilityfloat—0Chance of 5 or more shots on goal, 0 to 1.
sofloat—0Chance of a shutout, 0 to 1 (0 for a skater).
so_gfloat—0Projected shootout goals (mean).
sogfloat—0Projected shots on goal (mean).
start_probabilityfloat—0Chance the player starts, 0 to 1 (a goalie's chance to start in net).
stat_quantilesjsonb—[object Object]The 10th percentile, median and 90th percentile of each projected stat, keyed by stat name (g, a, sog, blk, ppg, ppa, shg, sha, so_g, w, sv, ga, so, otl), each an object of p10, p50 and p90.
svfloat—0Projected saves (mean; 0 for a skater).
wfloat—0Chance the goalie is credited with the win, 0 to 1 (0 for a skater).
zero_reasonstringnullable—injuredWhy the player projects no ice time (injured, or not dressed for the game); null for a player who may play.
Valuesinjurednot_dressed
nhl.projected_team_stats29 fields· 3 refsendpoints →

Our projection of each NHL team in each game before puck drop — goals with their range, shots on goal, power-play time, win, overtime and shootout chances, and the betting lines the projection used. One current row per game, team and engine version; it updates until puck drop and never changes after. GET /api/v1/dfs/slates/{slate_id}/projections serves the same rows in its `teams` block for the games of a DFS slate.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nhl.games19958—
opponent_team_idbigint→ nhl.teams2The team this team plays in the game.
projection_idbigint—4Engine version id (main.projections; STAT_API_NHL 1.0).
team_idbigint→ nhl.teams2—
empty_net_goals_meanfloat—0.14Projected empty-net goals this team scores (mean).
goals_meanfloat—3.589Projected goals this team scores in regulation and overtime (mean); a shootout goal is not a goal.
goals_p10float—1This team's projected goals, 10th percentile.
goals_p25float—2This team's projected goals, 25th percentile.
goals_p50float—3This team's projected goals, median.
goals_p75float—4This team's projected goals, 75th percentile.
goals_p90float—5This team's projected goals, 90th percentile.
goals_stdfloat—1.9545022384228676Standard deviation of this team's projected goals.
implied_team_totalfloatnullable—3.3933218293227236This team's implied goals from the betting total and moneyline; null when no line was captured.
inputs_as_oftimestamptz—2026-11-06T23:55:02.842ZTime of the newest input the projection used (UTC). Always before the game's puck drop.
is_homeboolean—trueTrue when this team is the home team.
Valuestruefalse
lines_captured_attimestamptznullable—2026-11-06T23:55:02.202ZWhen the betting lines the projection used were captured (UTC).
opponent_goals_meanfloat—3.589Projected goals the opponent scores (mean).
overtime_probabilityfloat—0.171Chance the game goes to overtime, 0 to 1.
power_play_minutes_meanfloat—5.475Projected power-play time of this team, minutes (mean).
shootout_probabilityfloat—0.057Chance the game goes to a shootout, 0 to 1 (at most overtime_probability).
sog_meanfloat—26.389Projected team shots on goal (mean).
sog_p10float—19Projected team shots on goal, 10th percentile.
sog_p50float—26Projected team shots on goal, median.
sog_p90float—35Projected team shots on goal, 90th percentile.
vegas_moneylineintegernullable—-110This team's betting moneyline that the projection used, in American odds; null when no line was captured.
vegas_spreadfloatnullable—-1.5Betting puck line from this team's side that the projection used; null when no line was captured.
vegas_totalfloatnullable—6.5Betting game total the projection used; null when no line was captured before the projection.
win_probabilityfloat—0.61Chance this team wins, 0 to 1 (0.62 = 62%).

Odds

nhl.game_lines19 fields· 3 refsendpoints →

NHL game betting lines — moneylines, puck lines (the hockey point spread) and over/under totals, the consensus of the main sportsbooks, captured over time from the opening line to the close before puck drop.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nhl.games20339—
operator_idbigint→ main.operators6Sportsbook id: 6 Consensus.
season_idbigint→ nhl.seasons2026Denormalized for efficient season-level queries
book_countintegernullable—6Number of sportsbooks in the consensus
captured_attimestamptz—2021-10-15T02:25:00.000ZWhen this line was captured (always before puck drop)
implied_away_scoredecimalnullable———
implied_away_win_pctdecimalnullable—0.5—
implied_home_scoredecimalnullable———
implied_home_win_pctdecimalnullable—0.5From the moneyline, 0-1
is_openingboolean—falseTrue for the first line captured for the game
Valuesfalsetrue
moneyline_awayintegernullable—-110American odds for an away win
moneyline_homeintegernullable—-110American odds for a home win
over_oddsintegernullable—-120—
spreaddecimalnullable—-1.5Home team puck line (e.g., -1.5 means home favored by 1.5 goals)
spread_away_oddsintegernullable—210American odds for the away puck line
spread_home_oddsintegernullable—210American odds for the home puck line
totaldecimalnullable—6.5Combined goals total line (e.g., 6.5)
under_oddsintegernullable—100—
nhl.game_period_lines19 fields· 3 refsendpoints →

NHL period betting lines — moneyline, puck line and total for the 1st, 2nd and 3rd period, the consensus of the main sportsbooks, captured before puck drop.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nhl.games7680—
operator_idbigint→ main.operators6Sportsbook id: 6 Consensus.
season_idbigint→ nhl.seasons2023—
book_countintegernullable—3—
captured_attimestamptz—2024-01-11T23:55:39.000Z—
draw_oddsintegernullable——American odds for a tied period (three-way markets only)
implied_away_win_pctdecimalnullable—0.5—
implied_home_win_pctdecimalnullable—0.5—
is_openingboolean—true—
moneyline_awayintegernullable—100—
moneyline_homeintegernullable—-145—
over_oddsintegernullable—-135—
period_codestring—p1p1, p2 or p3
Valuesp1p2p3
spreaddecimalnullable—-0.5—
spread_away_oddsintegernullable—-190—
spread_home_oddsintegernullable—120—
totaldecimalnullable—1.5—
under_oddsintegernullable—105—
nhl.game_player_props18 fields· 4 refsendpoints →

NHL player prop bets for each game — goals, assists, points, shots on goal, saves and other player markets, the consensus of the main sportsbooks, captured before puck drop.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nhl.games20032—
operator_idbigint→ main.operators6Usually consensus (6)
player_idbigint→ nhl.players321—
season_idbigint→ nhl.seasons2026—
book_countinteger—1—
captured_attimestamptz—2026-10-01T21:20:09.654Z—
categorystring—shots_on_goal—
Valuesshots_on_goalanytime_goalgoalspointsassistssavespower_play_pointsblocked_shots
is_openingboolean—true—
Valuestruefalse
linedecimalnullable—1.5—
market_keystring—player_goal_scorer_anytime—
Valuesplayer_goal_scorer_anytimeplayer_goalsplayer_shots_on_goal_alternateplayer_shots_on_goalplayer_points_alternateplayer_goals_alternateplayer_assists_alternateplayer_pointsplayer_assistsplayer_total_saves_alternateplayer_power_play_points_alternateplayer_total_savesplayer_blocked_shots_alternateplayer_blocked_shots
no_oddsintegernullable———
outcome_typestring—ouou | yes_no
Valuesouyes_no
over_oddsintegernullable—10000—
period_codestringnullable———
subcategorystringnullable—alternate—
under_oddsintegernullable—-115—
yes_oddsintegernullable—700—

Lineups & Roster

nhl.coaching_staffs2 fieldsendpoints →

NHL head coaches since 2021-22.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
namestring—Craig Berube—
nhl.line_combinations11 fields· 2 refsendpoints →

NHL forward and defensive pair groupings — which players skate together as a line (first, second, third, fourth) or defensive pairing for each team.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
player1_idbigint—1140—
player2_idbigintnullable—571—
player3_idbigintnullable—460—
player4_idbigintnullable—408—
player5_idbigintnullable—233—
season_idbigint→ nhl.seasons2026—
team_idbigint→ nhl.teams2—
daydate—2026-11-14—
line_numberinteger—1—
line_typestring—defense_pair—
Valuesdefense_pairforward_linepower_play
nhl.team_coaching_staffs8 fields· 3 refsendpoints →

The head coach of each NHL team in each season since 2021-22 — the first and last game day the coach ran the bench and the number of games coached. A mid-season change gives the team two rows that season.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
coaching_staff_idbigint→ nhl.coaching_staffs3—
season_idbigint→ nhl.seasons2021—
team_idbigint→ nhl.teams22—
coach_typestring—head_coachhead_coach
first_dayinteger—20251009YYYYMMDD date of the coach's first game with the team that season
gamesinteger—82Games coached for the team that season
last_dayinteger—20261117YYYYMMDD date of the coach's last game with the team that season (so far)
nhl.game_team_rosters10 fields· 3 refsendpoints →

The game-day roster of each NHL game since 2021-22 — every player of each team, with the position, sweater number, whether the player dressed or was scratched, and the starting goalie.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nhl.games3924—
player_idbigint→ nhl.players7099—
team_idbigint→ nhl.teams25—
dayinteger—20211009YYYYMMDD date of the game
dressedboolean—trueTrue when the player dressed for the game
Valuestruefalse
is_scratchedboolean—falseTrue when the player was scratched (always the opposite of dressed)
Valuesfalsetrue
is_starting_goalieboolean—falseTrue for the goalie who started the game (one per team)
Valuesfalsetrue
positionstringnullable—DC, L, R, D or G
ValuesDCLRG
sweater_numberintegernullable—21—
nhl.goalie_depth_charts6 fields· 3 refsendpoints →

Each NHL team's goaltender depth — the starter, backup, and any third-string netminders, with the date the depth was last updated.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
player_idbigint→ nhl.players39—
season_idbigint→ nhl.seasons2026—
team_idbigint→ nhl.teams2—
daydate—2026-11-14—
depth_orderinteger—11=Starter, 2=Backup, 3=Third string

Misc

nhl.arenas19 fieldsendpoints →

NHL arenas — current home venues and historical buildings, with capacity, surface type, and ice-rink dimensions.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
league_arena_idintegernullable—6Official NHL arena ID (issued by the league)
addressstringnullable———
capacityintegernullable———
citystring—Salt Lake City—
closed_datetimestamptznullable———
countrystringnullable———
descriptionstringnullable———
elevationfloatnullable——Elevation in feet above sea level
image_urlstringnullable——URL to aerial/overview image of arena
latitudefloatnullable———
longitudefloatnullable———
namestring—TD Garden—
opened_datetimestamptznullable———
roof_typestringnullable—IndoorArena roof type (all indoor)
statestringnullable———
surfacestring—IcePlaying surface type
team_namestringnullable———
timezonestringnullable——IANA timezone (e.g., America/New_York)
nhl.broadcasters4 fieldsendpoints →

The TV networks and streaming services that air NHL games in the United States and Canada — national networks and team-local regional networks.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
nhl_broadcaster_idinteger—389The league's own id for this network. Not a broadcaster_id; game_broadcasters.broadcaster_id holds this table's id.
country_codestringnullable—USUS or CA
ValuesUSCA
networkstring—BSMW APPNetwork call sign (e.g. ABC, TNT, SN1, RDS, MSG)
nhl.referees2 fieldsendpoints →

NHL on-ice officials — the referees and linesmen who work the games.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
full_namestring—Brian Pochmara—
nhl.playoff_series15 fields· 4 refsendpoints →

NHL Stanley Cup Playoff series — best-of-seven matchups in each round (First Round, Second Round, Conference Finals, Stanley Cup Final), with seeds, wins, and series outcomes.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
away_team_idbigint→ nhl.teams27—
home_team_idbigint→ nhl.teams9—
season_idbigint→ nhl.seasons2021—
series_idintegernullable—1—
winner_team_idbigintnullable→ nhl.teams4—
away_team_seedinteger—3—
away_team_winsinteger—4—
conferencestringnullable———
games_playedinteger—6—
home_team_seedinteger—1—
home_team_winsinteger—4—
max_gamesinteger—7—
playoff_roundstring—First Round—
ValuesFirst RoundSecond RoundConference FinalsStanley Cup Final
statusstring—complete—
nhl.game_broadcasters4 fields· 2 refsendpoints →

Which networks aired each NHL game since 2021-22 — national carriers and the home and away teams' regional networks.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
broadcaster_idbigint→ nhl.broadcasters62—
game_idbigint→ nhl.games2981—
marketstring—NH home team's market, A away team's market, N national
ValuesNHA
nhl.game_referees5 fields· 2 refsendpoints →

The officiating crew of each NHL game since 2021-22 — two referees and two linesmen, with their sweater numbers.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nhl.games15253—
referee_idbigint→ nhl.referees32—
positionstring—refereereferee or linesman
Valuesrefereelinesman
sweater_numberintegernullable—79—
nhl.player_news21 fields· 4 refsendpoints →

News about NHL players — trades, IR placements, line changes, suspensions, and general beat-reporter updates.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigintnullable→ nhl.games1930Associated game ID when this news item relates to a specific game.
news_idintegernullable—38315External news item ID from the provider.
opponent_team_idbigintnullable→ nhl.teams32Opponent team ID when this news item relates to an upcoming or active game matchup.
player_idbigintnullable→ nhl.players195Player ID associated with the news report.
team_idbigintnullable→ nhl.teams22Team ID of the player at the time of publication.
ai_processedboolean—falseWhether this story was generated or enriched via LLM summarization.
Valuesfalsetrue
authorstringnullable——Reporter or author of the article.
categoriesstringnullable——Comma-separated raw topic tags.
categorystringnullable—injuryinjury, transaction, lineup, general
Valuesinjurytransactiongeneralcontractlineupsuspension
contentstringnullable—Carolina Hurricanes left wing William Carrier (upper body) was limited to 6:51 of ice time in Satur…Full text content of the news report.
descriptionstringnullable—Edmonton defenseman Alec Regula has been placed on injured reserve with an undisclosed injury. He i…Brief synopsis or summary of the news event.
first_reported_attimestamptznullable—1970-01-01T00:00:00.000ZTimestamp when this story was first reported before multi-source compaction.
news_timetimestamptz—2026-09-29T04:00:00.000ZPublication timestamp of the news story.
priorityinteger—5Display priority score (1-10).
situational_impactjsonbnullable—[object Object]Structured situational impact assessment and fantasy implications for the player.
status_enumstringnullable—ACTIVEStandardized player status designation (RULED_OUT, DOUBTFUL, QUESTIONABLE, PROBABLE, CLEARED, MINUTES_LIMIT, MINUTES_LIFTED, STARTING, BENCHED, INACTIVE, ACTIVE, IR_PLACED, IR_ACTIVATED, TRADED, RELEASED, SIGNED, ROUTINE).
ValuesACTIVEROUTINERELEASEDTRADEDQUESTIONABLESIGNEDRULED_OUTIR_PLACEDPROBABLEINACTIVECLEAREDSTARTINGBENCHED
terms_of_usestringnullable——Syndication terms and attribution.
titlestring—Torey Krug placed on IR with ankle injuryHeadline of the news report.
updated_timetimestamptznullable——Timestamp when the story was last revised.
urgencystringnullable—ROUTINEUrgency level of the news event (BREAKING_GAME_TIME, HIGH, MEDIUM, ROUTINE).
ValuesROUTINEHIGHMEDIUMBREAKING_GAME_TIME
nhl.team_game_contexts14 fields· 3 refsendpoints →

Schedule context of each NHL team in each game — game number, games left, share of the season played, rest days and back-to-backs for the team and its opponent.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigint→ nhl.games3020—
opponent_team_idbigint—4—
season_idbigint→ nhl.seasons2021—
team_idbigint→ nhl.teams4—
game_numberinteger—1—
games_remaininginteger—5—
is_back_to_backboolean—false—
Valuesfalsetrue
is_homeboolean—false—
Valuesfalsetrue
opponent_is_back_to_backboolean—false—
Valuesfalsetrue
opponent_rest_daysintegernullable—1—
rest_daysintegernullable—1Full days since the team's previous game (0 = back-to-back; empty for its first game)
season_pctdecimal—1.00000.0-1.0 share of the team's games of this season type played, this one included
season_typestring—regular_season—
Valuesregular_seasonpostseason
nhl.team_news10 fields· 3 refsendpoints →

News and updates about NHL teams — game previews, coaching changes, front-office moves, and beat reports.

FieldTypeReferencesExampleDescription
idkeybigint——Primary Key
game_idbigintnullable→ nhl.games20266Associated game ID when news relates to a specific game.
opponent_team_idbigintnullable→ nhl.teams20Opponent team ID when news relates to an upcoming or completed game matchup.
team_idbigint→ nhl.teams25Team ID that this news event pertains to.
ai_processedbooleannullable—trueWhether this story was generated or enriched via LLM summarization.
categorystringnullable—game_previewgame_preview, coaching, transaction, general
Valuesgame_previewtransactiongeneralcoachingdepth_chart
news_timetimestamptz—2026-07-01T00:00:00.000ZPublication timestamp of the team story.
summarystring—Colorado's franchise defenseman Cale Makar has signed a $163.2 million contract, setting a new high…Concise journalistic summary of the team news event.
titlestring—Cale Makar signs $163.2M contract, sets new NHL defenseman benchmarkHeadline of the team news story.
urgencystringnullable—ROUTINEROUTINE, MEDIUM, HIGH, BREAKING_GAME_TIME
ValuesROUTINEMEDIUMHIGHBREAKING_GAME_TIME