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).
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| league_id | stringnullable | — | — | Official NHL season identifier |
| end_date | timestamptznullable | — | 2020-09-19T04:00:00.000Z | — |
| post_season_start_date | timestamptznullable | — | 2020-08-01T04:00:00.000Z | — |
| regular_season_start_date | timestamptznullable | — | 2019-10-02T04:00:00.000Z | — |
| stanley_cup_finals_date | timestamptznullable | — | 2020-09-19T04:00:00.000Z | — |
| start_date | timestamptz | — | 2019-10-02T04:00:00.000Z | — |
| start_year | integer | — | 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).
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| arena_id | bigintnullable | → nhl.arenas | 1 | — |
| league_team_id | integernullable | — | 6 | Official NHL team ID (issued by the league) |
| abbreviation | string | — | BOS | — |
| active | boolean | — | true | — |
| city | string | — | Boston | — |
| conference | string | — | Eastern | — Values EasternWestern |
| division | string | — | Atlantic | — Values AtlanticMetropolitanCentralPacific |
| full_name | string | — | Boston Boston Bruins | — |
| head_coach | stringnullable | — | — | — |
| logo_url | stringnullable | — | — | URL to team logo image |
| name | string | — | Boston Bruins | — |
| primary_color | stringnullable | — | — | — |
| quaternary_color | stringnullable | — | — | — |
| secondary_color | stringnullable | — | — | — |
| tertiary_color | stringnullable | — | — | — |
| wikipedia_logo_url | stringnullable | — | — | — |
| wikipedia_wordmark_url | stringnullable | — | — | — |
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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| arena_id | bigintnullable | → nhl.arenas | 1 | — |
| away_team_id | bigint | → nhl.teams | 1 | — |
| home_team_id | bigint | → nhl.teams | 1 | — |
| league_game_id | integernullable | — | 2024020051 | Official NHL game ID (issued by the league) |
| league_id | stringnullable | — | — | Official NHL game identifier |
| season_id | bigint | → nhl.seasons | 2021 | — |
| attendance | integernullable | — | — | — |
| away_team_score | integernullable | — | 2 | — |
| away_team_score_overtime | integernullable | — | 0 | — |
| away_team_score_period1 | integernullable | — | 0 | — |
| away_team_score_period2 | integernullable | — | 1 | — |
| away_team_score_period3 | integernullable | — | 1 | — |
| away_team_series_wins | integernullable | — | — | — |
| channel | stringnullable | — | — | — |
| day | integer | — | 20241022 | Calendar day as a YYYYMMDD integer (e.g. 20240915), US Eastern. |
| game_time | timestamptz | — | 2025-11-27T00:00:00.000Z | Scheduled puck drop (timezone-aware). |
| home_team_score | integernullable | — | 3 | — |
| home_team_score_overtime | integernullable | — | 0 | — |
| home_team_score_period1 | integernullable | — | 0 | — |
| home_team_score_period2 | integernullable | — | 1 | — |
| home_team_score_period3 | integernullable | — | 1 | — |
| home_team_series_wins | integernullable | — | — | — |
| is_overtime | boolean | — | false | — Values falsetrue |
| is_shootout | boolean | — | false | — Values falsetrue |
| last_play | stringnullable | — | — | — |
| neutral_site | boolean | — | false | — Values falsetrue |
| overtime_periods | integernullable | — | 0 | — |
| period | stringnullable | — | — | Current period (1, 2, 3, OT, SO, Final) |
| playoff_round | stringnullable | — | — | First Round, Second Round, Conference Finals, Stanley Cup Final |
| season_type | string | — | regular_season | Canonical season phase (text). Was integer 1/2/3/4 before the 2026-06-29 normalization. Values regular_seasonpostseasonpreseason |
| series_game_number | integernullable | — | — | — |
| status | string | — | Final | — |
| time_remaining_minutes | integernullable | — | — | — |
| time_remaining_seconds | integernullable | — | — | — |
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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| draft_team_id | bigintnullable | → nhl.teams | — | — |
| league_id | stringnullable | — | — | Official NHL player identifier |
| league_player_id | integer | — | 8482705 | Official NHL player ID (issued by the league) |
| team_id | bigintnullable | → nhl.teams | 27 | — |
| birth_city | stringnullable | — | Toronto | — |
| birth_country | stringnullable | — | CAN | — |
| birth_date | datenullable | — | 2004-03-30 | — |
| birth_state | stringnullable | — | Ontario | — |
| catches | stringnullable | — | L | — Values LR |
| college | stringnullable | — | — | — |
| draft_overall_pick | integernullable | — | 2 | — |
| draft_pick | integernullable | — | 1 | — |
| draft_round | integernullable | — | 1 | — |
| draft_year | integernullable | — | 2022 | — |
| experience | integernullable | — | — | Years of NHL experience |
| first_name | string | — | Ryan | — |
| full_name | string | — | Elias Pettersson | — |
| height | integernullable | — | 74 | Height in inches |
| injury_body_part | stringnullable | — | — | — |
| injury_notes | stringnullable | — | — | — |
| injury_start_date | timestamptznullable | — | — | — |
| injury_status | stringnullable | — | — | — |
| jersey | stringnullable | — | 44 | — |
| last_name | string | — | Smith | — |
| nationality | stringnullable | — | — | — |
| photo_url | stringnullable | — | https://assets.nhle.com/mugs/nhl/20262027/CBJ/8482705.png | URL to player headshot image |
| position_category | stringnullable | — | — | — |
| primary_position | string | — | D | — Values DCGLLWRWR |
| rookie_year | integernullable | — | — | — |
| roster_status | stringnullable | — | inactive | Canonical 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}. Values inactiveactive |
| shoots | stringnullable | — | L | — Values LR |
| weight | integernullable | — | 190 | Weight in pounds |
| youth_league | stringnullable | — | — | — |
| youth_team | stringnullable | — | — | — |
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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nhl.games | 15957 | — |
| league_shift_id | bigintnullable | — | — | The league's id for this shift. Empty for a shift rebuilt from the official time-on-ice report. |
| player_id | bigint | → nhl.players | 6878 | — |
| team_id | bigint | → nhl.teams | 30 | — |
| detail_code | integernullable | — | — | The league's shift detail code (0 for a regular shift). Empty for a shift rebuilt from the official time-on-ice report. |
| duration_seconds | integer | — | 43 | — |
| end_seconds | integer | — | 1200 | Seconds elapsed in the period when the shift ended |
| period | integer | — | 1 | — |
| shift_number | integer | — | 1 | The player's shift number in the game |
| start_seconds | integer | — | 0 | Seconds 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| drawn_by_player_id | bigintnullable | → nhl.players | 453 | — |
| game_id | bigint | → nhl.games | 4002 | — |
| penalty_id | integer | — | 36 | — |
| player_id | bigintnullable | → nhl.players | 1189 | — |
| team_id | bigint | → nhl.teams | 16 | — |
| description | stringnullable | — | — | — |
| is_bench_penalty | boolean | — | false | — Values falsetrue |
| penalty_minutes | integer | — | 2 | — |
| penalty_type | string | — | tripping | — |
| period_number | integer | — | 2 | — |
| time_remaining | string | — | 00:00 | Time 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.)
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nhl.games | 5762 | — |
| league_game_id | integer | — | 2020030184 | Official NHL game ID (issued by the league; matches nhl.games.league_game_id). |
| period_id | integer | — | 1 | — |
| away_team_score | integer | — | 0 | — |
| home_team_score | integer | — | 0 | — |
| name | string | — | 1st | 1, 2, 3, OT, OT2, SO Values 1st2nd3rdOvertimeShootoutOT2OT3 |
| period_number | integer | — | 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| assist1_player_id | bigintnullable | → nhl.players | 307 | — |
| assist2_player_id | bigintnullable | → nhl.players | 7123 | — |
| blocking_player_id | bigintnullable | → nhl.players | 15 | — |
| committed_by_player_id | bigintnullable | → nhl.players | 834 | Player who took the penalty |
| drawn_by_player_id | bigintnullable | → nhl.players | 308 | Player who drew the penalty |
| event_id | integer | — | 58 | The league's event number, unique within the game |
| event_owner_team_id | bigintnullable | → nhl.teams | 29 | Team credited with the event |
| game_id | bigint | → nhl.games | 15003 | — |
| goalie_in_net_id | bigintnullable | → nhl.players | 531 | Goaltender the shot was taken against |
| hittee_player_id | bigintnullable | → nhl.players | 353 | — |
| hitting_player_id | bigintnullable | → nhl.players | 7297 | — |
| losing_player_id | bigintnullable | → nhl.players | 6627 | Faceoff loser |
| player_id | bigintnullable | → nhl.players | 105 | Player of a giveaway or takeaway |
| scoring_player_id | bigintnullable | → nhl.players | 858 | — |
| served_by_player_id | bigintnullable | → nhl.players | 7393 | Player who served the penalty (bench and goalie penalties) |
| shooting_player_id | bigintnullable | → nhl.players | 6757 | — |
| winning_player_id | bigintnullable | → nhl.players | 6627 | Faceoff winner |
| away_score | integernullable | — | 1 | Away goals after the event; empty on most event types |
| away_sog | integernullable | — | 2 | Away shots on goal after the event; empty on most event types |
| home_score | integernullable | — | 1 | Home goals after the event; empty on most event types |
| home_sog | integernullable | — | 19 | Home shots on goal after the event; empty on most event types |
| penalty_desc_key | stringnullable | — | hooking | The infraction (e.g. tripping, hooking, slashing) |
| penalty_minutes | integernullable | — | 2 | — |
| penalty_type_code | stringnullable | — | MIN | Penalty class (MIN minor, MAJ major, BEN bench minor, MIS misconduct, GAM game misconduct, MAT match, PS penalty shot) Values MINMAJMISBENGAM |
| period_number | integer | — | 1 | — |
| period_type | string | — | REG | REG, OT or SO (shootout) Values REGOTSO |
| reason | stringnullable | — | wide-of-net | Why a shot missed or play stopped (e.g. wide-of-net, icing, goalie-stopped-after-sog) |
| secondary_reason | stringnullable | — | tv-timeout | — Values tv-timeouthome-timeoutvisitor-timeoutplayer-injuryice-problem |
| shot_type | stringnullable | — | wrist | wrist, snap, slap, tip-in, backhand, deflected, wrap-around, bat, poke Values wristslapsnapbackhandtip-indeflectedwrap-around |
| situation_code | stringnullable | — | 1551 | Four 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_order | integernullable | — | 8 | Order of the event within the game |
| time_in_period_seconds | integer | — | 0 | Seconds elapsed in the period when the event happened |
| time_remaining_seconds | integer | — | 1200 | Seconds left in the period when the event happened |
| type_code | integer | — | 502 | The league's numeric event type (e.g. 505 goal, 506 shot on goal, 502 faceoff) |
| type_desc_key | string | — | faceoff | Event type (e.g. goal, shot-on-goal, faceoff, hit, penalty) Values faceoffshot-on-goalhitstoppageblocked-shotmissed-shotgiveawaytakeawaypenaltygoalperiod-startperiod-enddelayed-penaltygame-endshootout-complete |
| x_coord | integernullable | — | 69 | Rink x coordinate in feet from center ice |
| y_coord | integernullable | — | 22 | Rink y coordinate in feet from center ice |
| zone_code | stringnullable | — | O | Zone of the event for the owning team (O offensive, D defensive, N neutral) Values ODN |
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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nhl.games | 4367 | — |
| primary_assist_player_id | bigintnullable | → nhl.players | 1120 | — |
| scored_by_player_id | bigintnullable | → nhl.players | 161 | — |
| scoring_play_id | integer | — | 99 | — |
| secondary_assist_player_id | bigintnullable | → nhl.players | 126 | — |
| team_id | bigint | → nhl.teams | 7 | — |
| away_team_score | integer | — | 1 | — |
| description | stringnullable | — | — | — |
| goal_type | stringnullable | — | wrist | — Values wristsnapslapbackhandtip-indeflectedwrap-aroundbatpoke |
| home_team_score | integer | — | 1 | — |
| period_number | integer | — | 3 | — |
| time_remaining | string | — | 00:59 | Time 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| operator_id | bigint | → main.operators | 1 | Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo; every id is listed at /api/v1/reference/operators. |
| operator_team_id | string | — | 4007 | External team ID from operator |
| team_id | bigint | → nhl.teams | 25 | Internal nhl.teams.id reference |
| abbreviation | stringnullable | — | ANA | Team abbreviation for reconciliation |
| team_name | stringnullable | — | Anaheim Ducks | Team 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| season_id | bigint | → nhl.seasons | 2025 | — |
| team_id | bigint | → nhl.teams | 18 | — |
| blocked_shots | integer | — | 0 | — |
| faceoff_losses | integer | — | 0 | — |
| faceoff_percentage | decimal | — | 0.0000 | — |
| faceoff_wins | integer | — | 0 | — |
| games_played | integer | — | 82 | — |
| giveaways | integer | — | 0 | — |
| goal_differential | integer | — | 21 | — |
| goals_against | integer | — | 226 | — |
| goals_against_average | decimal | — | 0.0000 | — |
| goals_against_per_game | decimal | — | 3.0000 | — |
| goals_for | integer | — | 238 | — |
| goals_per_game | decimal | — | 3.0000 | — |
| hits | integer | — | 0 | — |
| losses | integer | — | 27 | — |
| overtime_losses | integer | — | 7 | — |
| penalty_kill_goals_against | integer | — | 0 | — |
| penalty_kill_percentage | decimal | — | 0.0000 | — |
| penalty_minutes | integer | — | 0 | — |
| power_play_goals | integer | — | 0 | — |
| power_play_opportunities | integer | — | 0 | — |
| power_play_percentage | decimal | — | 0.0000 | — |
| pts | integer | — | 92 | — |
| pts_percentage | decimal | — | 0.5610 | — |
| save_percentage | decimal | — | 0.0000 | — |
| season_type | string | — | regular_season | Canonical season phase (text). Was integer 1/2/3 before the 2026-06-29 normalization. |
| shooting_percentage | decimal | — | 0.0000 | — |
| short_handed_goals | integer | — | 0 | — |
| shots_against | integer | — | 0 | — |
| shots_for | integer | — | 0 | — |
| shutouts | integer | — | 0 | — |
| takeaways | integer | — | 0 | — |
| times_shorthanded | integer | — | 0 | — |
| wins | integer | — | 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).
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| season_id | bigint | → nhl.seasons | 2025 | — |
| team_id | bigint | → nhl.teams | 18 | — |
| away_losses | integer | — | 19 | — |
| away_overtime_losses | integer | — | 4 | — |
| away_wins | integer | — | 17 | — |
| clinched_conference | boolean | — | false | — |
| clinched_division | boolean | — | false | — |
| clinched_playoffs | boolean | — | true | — Values truefalse |
| clinched_presidents_trophy | boolean | — | false | — |
| conference | string | — | Eastern | — Values EasternWestern |
| conference_rank | integer | — | 0 | — |
| division | string | — | Metropolitan | — Values MetropolitanAtlanticCentralPacificDiscover CentralMassMutual EastHonda WestScotia North |
| division_rank | integer | — | 1 | — |
| games_played | integer | — | 82 | — |
| goal_differential | integer | — | 21 | — |
| goals_against | integer | — | 226 | — |
| goals_for | integer | — | 238 | — |
| home_losses | integer | — | 13 | — |
| home_overtime_losses | integer | — | 4 | — |
| home_wins | integer | — | 20 | — |
| last_10_losses | integer | — | 4 | — |
| last_10_overtime_losses | integer | — | 1 | — |
| last_10_wins | integer | — | 6 | — |
| losses | integer | — | 27 | — |
| overtime_losses | integer | — | 7 | — |
| pts | integer | — | 92 | — |
| pts_percentage | decimal | — | 0.5610 | — |
| rank | integer | — | 1 | — |
| regulation_wins | integer | — | 30 | — |
| season_type | string | — | regular_season | — |
| shootout_losses | integer | — | 2 | — |
| shootout_wins | integer | — | 2 | — |
| streak | stringnullable | — | W1 | Current streak (W3, L2, OTL1) Values W1L1W2L2OT1W3L3W4W6OT2W5L4L5W8W7W9OT4L7 |
| wild_card_rank | integernullable | — | 0 | — |
| wins | integer | — | 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| season_id | bigint | → nhl.seasons | 2021 | — |
| team_id | bigint | → nhl.teams | 4 | — |
| away_losses | integer | — | 11 | — |
| away_overtime_losses | integer | — | 2 | — |
| away_wins | integer | — | 3 | — |
| day | integer | — | 20220429 | YYYYMMDD — the record entering this day (games before it) |
| games_played | integer | — | 82 | — |
| games_remaining | integer | — | 0 | — |
| goals_against | integer | — | 0 | — |
| goals_for | integer | — | 0 | — |
| home_losses | integer | — | 3 | — |
| home_overtime_losses | integer | — | 1 | — |
| home_wins | integer | — | 10 | — |
| l10_losses | integer | — | 3 | — |
| l10_overtime_losses | integer | — | 1 | — |
| l10_wins | integer | — | 6 | — |
| losses | integer | — | 21 | — |
| overtime_losses | integer | — | 0 | — |
| pts | integer | — | 0 | — |
| pts_percentage | decimalnullable | — | 0.5000 | — |
| regulation_wins | integer | — | 7 | — |
| season_type | string | — | regular_season | regular_season or postseason (the record is the regular-season record) Values regular_seasonpostseason |
| streak | stringnullable | — | W1 | e.g. W3, L1, OT2 |
| wins | integer | — | 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).
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nhl.games | 1 | — |
| opponent_id | bigintnullable | — | 27 | — |
| player_id | bigint | → nhl.players | 51 | — |
| team_id | bigint | → nhl.teams | 27 | — |
| assists | integer | — | 0 | — |
| blocked_shots | integer | — | 0 | — |
| empty_net_goals | integer | — | 0 | — |
| even_strength_assists | integer | — | 0 | — |
| even_strength_goals | integer | — | 0 | — |
| even_strength_time_on_ice_seconds | integer | — | 0 | — |
| faceoff_percentage | decimal | — | 0.0000 | — |
| faceoffs_lost | integer | — | 0 | — |
| faceoffs_won | integer | — | 0 | — |
| first_period_goals_against | integer | — | 0 | — |
| game_winning_goals | integer | — | 0 | — |
| games | integer | — | 1 | 1 if player appeared, 0 if not |
| giveaways | integer | — | 0 | — |
| goals | integer | — | 0 | — |
| goals_against | integer | — | 0 | — |
| goals_against_average | decimal | — | 0.0000 | — |
| hits | integer | — | 0 | — |
| home_or_away | stringnullable | — | — | — |
| is_game_over | boolean | — | true | — |
| losses | integer | — | 0 | — |
| major_penalties | integer | — | 0 | — |
| minor_penalties | integer | — | 0 | — |
| minutes_played | integer | — | 0 | Goalie minutes played |
| overtime_goals | integer | — | 0 | — |
| overtime_goals_against | integer | — | 0 | — |
| overtime_losses | integer | — | 0 | — |
| penalties | integer | — | 0 | — |
| penalty_minutes | integer | — | 0 | — |
| plus_minus | integer | — | 0 | — |
| power_play_assists | integer | — | 0 | — |
| power_play_goals | integer | — | 0 | — |
| power_play_goals_against | integer | — | 0 | — |
| power_play_pts | integer | — | 0 | — |
| power_play_saves | integer | — | 0 | — |
| power_play_shots_against | integer | — | 0 | — |
| power_play_time_on_ice_seconds | integer | — | 0 | — |
| pts | integer | — | 0 | — |
| save_percentage | decimal | — | 0.0000 | — |
| saves | integer | — | 0 | — |
| second_period_goals_against | integer | — | 0 | — |
| shifts | integer | — | 0 | — |
| shooting_percentage | decimal | — | 0.0000 | — |
| shootout_attempts | integer | — | 0 | — |
| shootout_goals | integer | — | 0 | — |
| shootout_goals_against | integer | — | 0 | — |
| shootout_saves | integer | — | 0 | — |
| short_handed_assists | integer | — | 0 | — |
| short_handed_goals | integer | — | 0 | — |
| short_handed_goals_against | integer | — | 0 | — |
| short_handed_pts | integer | — | 0 | — |
| short_handed_saves | integer | — | 0 | — |
| short_handed_shots_against | integer | — | 0 | — |
| short_handed_time_on_ice_seconds | integer | — | 0 | — |
| shots | integer | — | 0 | — |
| shots_against | integer | — | 0 | — |
| shots_on_goal | integer | — | 0 | — |
| shutouts | integer | — | 0 | — |
| started | integer | — | 0 | — |
| takeaways | integer | — | 0 | — |
| third_period_goals_against | integer | — | 0 | — |
| time_on_ice_seconds | integer | — | 0 | — |
| wins | integer | — | 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nhl.games | 1 | — |
| team_id | bigint | → nhl.teams | 7 | — |
| assists | integer | — | 4 | — |
| blocked_shots | integer | — | 12 | — |
| faceoff_percentage | decimal | — | 0.0000 | — |
| faceoffs_lost | integer | — | 0 | — |
| faceoffs_won | integer | — | 0 | — |
| giveaways | integer | — | 9 | — |
| goals | integer | — | 3 | — |
| goals_against | integer | — | 3 | — |
| hits | integer | — | 19 | — |
| losses | integer | — | 0 | — |
| overtime_losses | integer | — | 0 | — |
| penalties | integer | — | 0 | — |
| penalty_kill_goals_against | integer | — | 0 | — |
| penalty_kill_percentage | decimal | — | 0.0000 | — |
| penalty_minutes | integer | — | 6 | — |
| power_play_attempts | integer | — | 0 | — |
| power_play_goals | integer | — | 0 | — |
| power_play_percentage | decimal | — | 0.0000 | — |
| save_percentage | decimal | — | 0.0000 | — |
| saves | integer | — | 28 | — |
| shooting_percentage | decimal | — | 0.0000 | — |
| short_handed_goals | integer | — | 0 | — |
| shots | integer | — | 28 | — |
| shots_on_goal | integer | — | 28 | — |
| takeaways | integer | — | 6 | — |
| times_shorthanded | integer | — | 0 | — |
| wins | integer | — | 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nhl.games | 3020 | — |
| operator_id | bigint | → main.operators | 1 | — |
| operator_scoring_format_id | bigint | — | 2 | — |
| away_assist_fpts | decimal | — | 40.0000 | — |
| away_block_bonus_fpts | decimal | — | 0.0000 | — |
| away_blocked_shot_fpts | decimal | — | 20.8000 | — |
| away_fpts | decimal | — | 125.6000 | — |
| away_goal_fpts | decimal | — | 25.5000 | — |
| away_goalie_win_fpts | decimal | — | 0.0000 | — |
| away_goals_against_fpts | decimal | — | -10.5000 | — |
| away_hat_trick_fpts | decimal | — | 0.0000 | — |
| away_overtime_loss_fpts | decimal | — | 0.0000 | — |
| away_penalty_minutes_fpts | decimal | — | 0.0000 | — |
| away_plus_minus_fpts | decimal | — | 0.0000 | — |
| away_power_play_assist_fpts | decimal | — | 0.0000 | — |
| away_power_play_goal_fpts | decimal | — | 0.0000 | — |
| away_save_fpts | decimal | — | 22.4000 | — |
| away_shootout_goal_fpts | decimal | — | 0.0000 | — |
| away_short_handed_assist_fpts | decimal | — | 0.0000 | — |
| away_short_handed_goal_fpts | decimal | — | 0.0000 | — |
| away_shot_bonus_fpts | decimal | — | 0.0000 | — |
| away_shot_on_goal_fpts | decimal | — | 48.0000 | — |
| away_shutout_fpts | decimal | — | 0.0000 | — |
| home_assist_fpts | decimal | — | 40.0000 | — |
| home_block_bonus_fpts | decimal | — | 0.0000 | — |
| home_blocked_shot_fpts | decimal | — | 20.8000 | — |
| home_fpts | decimal | — | 133.6000 | — |
| home_goal_fpts | decimal | — | 25.5000 | — |
| home_goalie_win_fpts | decimal | — | 0.0000 | — |
| home_goals_against_fpts | decimal | — | -10.5000 | — |
| home_hat_trick_fpts | decimal | — | 0.0000 | — |
| home_overtime_loss_fpts | decimal | — | 0.0000 | — |
| home_penalty_minutes_fpts | decimal | — | 0.0000 | — |
| home_plus_minus_fpts | decimal | — | 0.0000 | — |
| home_power_play_assist_fpts | decimal | — | 0.0000 | — |
| home_power_play_goal_fpts | decimal | — | 0.0000 | — |
| home_save_fpts | decimal | — | 22.4000 | — |
| home_shootout_goal_fpts | decimal | — | 0.0000 | — |
| home_short_handed_assist_fpts | decimal | — | 0.0000 | — |
| home_short_handed_goal_fpts | decimal | — | 0.0000 | — |
| home_shot_bonus_fpts | decimal | — | 0.0000 | — |
| home_shot_on_goal_fpts | decimal | — | 48.0000 | — |
| home_shutout_fpts | decimal | — | 0.0000 | — |
| player_count | integer | — | 40 | — |
| total_assist_fpts | decimal | — | 40.0000 | — |
| total_block_bonus_fpts | decimal | — | 0.0000 | — |
| total_blocked_shot_fpts | decimal | — | 41.6000 | — |
| total_fpts | decimal | — | 264.8000 | — |
| total_goal_fpts | decimal | — | 42.5000 | — |
| total_goalie_win_fpts | decimal | — | 6.0000 | — |
| total_goals_against_fpts | decimal | — | -28.0000 | — |
| total_hat_trick_fpts | decimal | — | 0.0000 | — |
| total_overtime_loss_fpts | decimal | — | 0.0000 | — |
| total_penalty_minutes_fpts | decimal | — | 0.0000 | — |
| total_plus_minus_fpts | decimal | — | 0.0000 | — |
| total_power_play_assist_fpts | decimal | — | 0.0000 | — |
| total_power_play_goal_fpts | decimal | — | 0.0000 | — |
| total_save_fpts | decimal | — | 39.2000 | — |
| total_shootout_goal_fpts | decimal | — | 0.0000 | — |
| total_short_handed_assist_fpts | decimal | — | 0.0000 | — |
| total_short_handed_goal_fpts | decimal | — | 0.0000 | — |
| total_shot_bonus_fpts | decimal | — | 0.0000 | — |
| total_shot_on_goal_fpts | decimal | — | 96.0000 | — |
| total_shutout_fpts | decimal | — | 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nhl.games | 3020 | — |
| operator_id | bigint | → main.operators | 1 | — |
| operator_scoring_format_id | bigint | — | 2 | — |
| player_id | bigint | → nhl.players | 103 | — |
| assist_fpts | decimal | — | 0.0000 | — |
| block_bonus_fpts | decimal | — | 0.0000 | Bonus for 3+ blocked shots |
| blocked_shot_fpts | decimal | — | 0.0000 | — |
| fantasy_pts | decimal | — | 0.0000 | — |
| goal_fpts | decimal | — | 0.0000 | — |
| goalie_win_fpts | decimal | — | 0.0000 | — |
| goals_against_fpts | decimal | — | 0.0000 | Negative points for goals allowed |
| hat_trick_fpts | decimal | — | 0.0000 | Bonus for 3+ goals |
| overtime_loss_fpts | decimal | — | 0.0000 | DK: +2 for OT loss |
| penalty_minutes_fpts | decimal | — | 0.0000 | Typically negative or zero |
| plus_minus_fpts | decimal | — | 0.0000 | — |
| power_play_assist_fpts | decimal | — | 0.0000 | — |
| power_play_goal_fpts | decimal | — | 0.0000 | — |
| save_fpts | decimal | — | 0.0000 | — |
| shootout_goal_fpts | decimal | — | 0.0000 | — |
| short_handed_assist_fpts | decimal | — | 0.0000 | — |
| short_handed_goal_fpts | decimal | — | 0.0000 | — |
| shot_bonus_fpts | decimal | — | 0.0000 | Bonus for 5+ shots on goal |
| shot_on_goal_fpts | decimal | — | 0.0000 | — |
| shutout_fpts | decimal | — | 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| operator_id | bigint | → main.operators | 1 | Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo; every id is listed at /api/v1/reference/operators. |
| operator_player_id | string | — | 8478042 | External player ID from operator |
| player_id | bigintnullable | → nhl.players | 404 | Internal nhl.players.id reference |
| decided_at | timestamptznullable | — | 2026-08-19T22:09:48.576Z | When the pin or block was decided. |
| decided_reason | stringnullable | — | 6740 "C. Schneider" is a GOALIE, nhl id 8471239 (2004 draft class) = Cory Schneider; the mirror nam… | Evidence behind a pinned or blocked decision. Values 6740 "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… |
| decision | stringnullable | — | derived | How 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. Values derivedpinnedblocked |
| player_name | stringnullable | — | Alex Tuch | Player name for reconciliation |
| position | stringnullable | — | D | Position for reconciliation Values DCWGRWLW |
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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nhl.games | 3020 | — |
| operator_id | bigint | → main.operators | 1 | — |
| operator_scoring_format_id | bigint | — | 2 | — |
| team_id | bigint | → nhl.teams | 2 | — |
| player_count | integer | — | 20 | — |
| total_assist_fpts | decimal | — | 40.0000 | — |
| total_block_bonus_fpts | decimal | — | 0.0000 | — |
| total_blocked_shot_fpts | decimal | — | 20.8000 | — |
| total_fpts | decimal | — | 175.2000 | — |
| total_goal_fpts | decimal | — | 25.5000 | — |
| total_goalie_win_fpts | decimal | — | 0.0000 | — |
| total_goals_against_fpts | decimal | — | -10.5000 | — |
| total_hat_trick_fpts | decimal | — | 0.0000 | — |
| total_overtime_loss_fpts | decimal | — | 0.0000 | — |
| total_penalty_minutes_fpts | decimal | — | 0.0000 | — |
| total_plus_minus_fpts | decimal | — | 0.0000 | — |
| total_power_play_assist_fpts | decimal | — | 0.0000 | — |
| total_power_play_goal_fpts | decimal | — | 0.0000 | — |
| total_save_fpts | decimal | — | 22.4000 | — |
| total_shootout_goal_fpts | decimal | — | 0.0000 | — |
| total_short_handed_assist_fpts | decimal | — | 0.0000 | — |
| total_short_handed_goal_fpts | decimal | — | 0.0000 | — |
| total_shot_bonus_fpts | decimal | — | 0.0000 | — |
| total_shot_on_goal_fpts | decimal | — | 48.0000 | — |
| total_shutout_fpts | decimal | — | 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).
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| player_id | bigint | → nhl.players | 6 | — |
| season_id | bigint | → nhl.seasons | 2021 | — |
| team_id | bigintnullable | → nhl.teams | 22 | — |
| assists | integer | — | 0 | — |
| assists_per_game | decimal | — | 0.0000 | — |
| blocked_shots | integer | — | 0 | — |
| empty_net_goals | integer | — | 0 | — |
| even_strength_assists | integer | — | 0 | — |
| even_strength_goals | integer | — | 0 | — |
| even_strength_time_on_ice_seconds | integer | — | 0 | — |
| faceoff_percentage | decimal | — | 0.0000 | — |
| faceoffs_lost | integer | — | 0 | — |
| faceoffs_won | integer | — | 0 | — |
| game_winning_goals | integer | — | 0 | — |
| games_played | integer | — | 4 | — |
| games_started | integer | — | 0 | — |
| giveaways | integer | — | 0 | — |
| goals | integer | — | 0 | — |
| goals_against | integer | — | 0 | — |
| goals_against_average | decimal | — | 0.0000 | — |
| goals_per_game | decimal | — | 0.0000 | — |
| hat_tricks | integer | — | 0 | — |
| hits | integer | — | 0 | — |
| losses | integer | — | 0 | — |
| major_penalties | integer | — | 0 | — |
| minor_penalties | integer | — | 0 | — |
| minutes_played | integer | — | 0 | — |
| overtime_goals | integer | — | 0 | — |
| overtime_losses | integer | — | 0 | — |
| penalties | integer | — | 0 | — |
| penalty_minutes | integer | — | 0 | — |
| plus_minus | integer | — | 0 | — |
| position | stringnullable | — | — | — |
| power_play_assists | integer | — | 0 | — |
| power_play_goals | integer | — | 0 | — |
| power_play_pts | integer | — | 0 | — |
| power_play_time_on_ice_seconds | integer | — | 0 | — |
| pts | integer | — | 0 | — |
| pts_per_game | decimal | — | 0.0000 | — |
| save_percentage | decimal | — | 0.0000 | — |
| saves | integer | — | 0 | — |
| season_type | string | — | regular_season | Canonical season phase (text). Was integer 1/2/3 before the 2026-06-29 normalization. Values regular_seasonpreseasonpostseason |
| shifts | integer | — | 0 | — |
| shooting_percentage | decimal | — | 0.0000 | — |
| shootout_attempts | integer | — | 0 | — |
| shootout_goals | integer | — | 0 | — |
| shootout_goals_against | integer | — | 0 | — |
| shootout_misses | integer | — | 0 | — |
| shootout_saves | integer | — | 0 | — |
| short_handed_assists | integer | — | 0 | — |
| short_handed_goals | integer | — | 0 | — |
| short_handed_pts | integer | — | 0 | — |
| short_handed_time_on_ice_seconds | integer | — | 0 | — |
| shots | integer | — | 0 | — |
| shots_against | integer | — | 0 | — |
| shots_on_goal | integer | — | 0 | — |
| shutouts | integer | — | 0 | — |
| takeaways | integer | — | 0 | — |
| time_on_ice_per_game | decimal | — | 0.0000 | — |
| time_on_ice_seconds | integer | — | 0 | — |
| wins | integer | — | 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nhl.games | 21037 | — |
| player_id | bigint | → nhl.players | 351 | — |
| projection_id | bigint | — | 4 | Engine version id (main.projections; STAT_API_NHL 1.0). |
| team_id | bigint | → nhl.teams | 8 | — |
| a | float | — | 0 | Projected assists (mean). |
| blk | float | — | 0 | Projected blocked shots (mean). |
| blocks_3_probability | float | — | 0 | Chance of 3 or more blocked shots, 0 to 1. |
| g | float | — | 0 | Projected goals (mean), regulation and overtime; a shootout goal is so_g. |
| ga | float | — | 0 | Projected goals against (mean; 0 for a skater). |
| hat_trick_probability | float | — | 0 | Chance of 3 or more goals, 0 to 1. |
| injury_tag | stringnullable | — | IR | The injury tag of the lineup reading (IR, DTD, ...); null when none. Values IRIR-LTOUTIR-NRDTD |
| inputs_as_of | timestamptz | — | 2026-11-14T23:58:05.827Z | Time of the newest input the projection used (UTC). Always before the game's puck drop. |
| lineup_captured_at | timestamptznullable | — | 2026-11-18T13:02:04.647Z | When the lineup reading the projection used was captured (UTC); null when no reading was in. |
| lineup_unit | stringnullable | — | injured | The 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. Values injuredline1line3line2pair1pair2pair3goaliepp2pp1 |
| minutes_mean | float | — | 0 | Projected time on ice, minutes (mean). |
| minutes_p10 | float | — | 0 | Projected time on ice, 10th percentile, minutes. |
| minutes_p25 | float | — | 0 | Projected time on ice, 25th percentile, minutes. |
| minutes_p50 | float | — | 0 | Projected time on ice, median, minutes. |
| minutes_p75 | float | — | 0 | Projected time on ice, 75th percentile, minutes. |
| minutes_p90 | float | — | 0 | Projected time on ice, 90th percentile, minutes. |
| minutes_std | float | — | 0 | Standard deviation of the projected time on ice, minutes. |
| otl | float | — | 0 | Chance the goalie is charged with the overtime loss, 0 to 1 (0 for a skater). |
| play_probability | float | — | 0 | Chance the player plays (dresses for the game), 0 to 1. |
| points_3_probability | float | — | 0 | Chance of 3 or more points (goals plus assists), 0 to 1. |
| position | string | — | D | The player's position in our engine for this game — C, W, D or G. Values DWCG |
| pp_minutes_mean | float | — | 0 | Projected power-play time on ice, minutes (mean). |
| ppa | float | — | 0 | Projected power-play assists (mean), a part of a. |
| ppg | float | — | 0 | Projected power-play goals (mean), a part of g. |
| relief_probability | float | — | 0 | Chance the goalie enters in relief, 0 to 1 (0 for a skater). |
| saves_35_probability | float | — | 0 | Chance of 35 or more saves, 0 to 1. |
| sh_minutes_mean | float | — | 0 | Projected short-handed time on ice, minutes (mean). |
| sha | float | — | 0 | Projected short-handed assists (mean), a part of a. |
| shg | float | — | 0 | Projected short-handed goals (mean), a part of g. |
| shots_5_probability | float | — | 0 | Chance of 5 or more shots on goal, 0 to 1. |
| so | float | — | 0 | Chance of a shutout, 0 to 1 (0 for a skater). |
| so_g | float | — | 0 | Projected shootout goals (mean). |
| sog | float | — | 0 | Projected shots on goal (mean). |
| start_probability | float | — | 0 | Chance the player starts, 0 to 1 (a goalie's chance to start in net). |
| stat_quantiles | jsonb | — | [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. |
| sv | float | — | 0 | Projected saves (mean; 0 for a skater). |
| w | float | — | 0 | Chance the goalie is credited with the win, 0 to 1 (0 for a skater). |
| zero_reason | stringnullable | — | injured | Why the player projects no ice time (injured, or not dressed for the game); null for a player who may play. Values injurednot_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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nhl.games | 19958 | — |
| opponent_team_id | bigint | → nhl.teams | 2 | The team this team plays in the game. |
| projection_id | bigint | — | 4 | Engine version id (main.projections; STAT_API_NHL 1.0). |
| team_id | bigint | → nhl.teams | 2 | — |
| empty_net_goals_mean | float | — | 0.14 | Projected empty-net goals this team scores (mean). |
| goals_mean | float | — | 3.589 | Projected goals this team scores in regulation and overtime (mean); a shootout goal is not a goal. |
| goals_p10 | float | — | 1 | This team's projected goals, 10th percentile. |
| goals_p25 | float | — | 2 | This team's projected goals, 25th percentile. |
| goals_p50 | float | — | 3 | This team's projected goals, median. |
| goals_p75 | float | — | 4 | This team's projected goals, 75th percentile. |
| goals_p90 | float | — | 5 | This team's projected goals, 90th percentile. |
| goals_std | float | — | 1.9545022384228676 | Standard deviation of this team's projected goals. |
| implied_team_total | floatnullable | — | 3.3933218293227236 | This team's implied goals from the betting total and moneyline; null when no line was captured. |
| inputs_as_of | timestamptz | — | 2026-11-06T23:55:02.842Z | Time of the newest input the projection used (UTC). Always before the game's puck drop. |
| is_home | boolean | — | true | True when this team is the home team. Values truefalse |
| lines_captured_at | timestamptznullable | — | 2026-11-06T23:55:02.202Z | When the betting lines the projection used were captured (UTC). |
| opponent_goals_mean | float | — | 3.589 | Projected goals the opponent scores (mean). |
| overtime_probability | float | — | 0.171 | Chance the game goes to overtime, 0 to 1. |
| power_play_minutes_mean | float | — | 5.475 | Projected power-play time of this team, minutes (mean). |
| shootout_probability | float | — | 0.057 | Chance the game goes to a shootout, 0 to 1 (at most overtime_probability). |
| sog_mean | float | — | 26.389 | Projected team shots on goal (mean). |
| sog_p10 | float | — | 19 | Projected team shots on goal, 10th percentile. |
| sog_p50 | float | — | 26 | Projected team shots on goal, median. |
| sog_p90 | float | — | 35 | Projected team shots on goal, 90th percentile. |
| vegas_moneyline | integernullable | — | -110 | This team's betting moneyline that the projection used, in American odds; null when no line was captured. |
| vegas_spread | floatnullable | — | -1.5 | Betting puck line from this team's side that the projection used; null when no line was captured. |
| vegas_total | floatnullable | — | 6.5 | Betting game total the projection used; null when no line was captured before the projection. |
| win_probability | float | — | 0.61 | Chance 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nhl.games | 20339 | — |
| operator_id | bigint | → main.operators | 6 | Sportsbook id: 6 Consensus. |
| season_id | bigint | → nhl.seasons | 2026 | Denormalized for efficient season-level queries |
| book_count | integernullable | — | 6 | Number of sportsbooks in the consensus |
| captured_at | timestamptz | — | 2021-10-15T02:25:00.000Z | When this line was captured (always before puck drop) |
| implied_away_score | decimalnullable | — | — | — |
| implied_away_win_pct | decimalnullable | — | 0.5 | — |
| implied_home_score | decimalnullable | — | — | — |
| implied_home_win_pct | decimalnullable | — | 0.5 | From the moneyline, 0-1 |
| is_opening | boolean | — | false | True for the first line captured for the game Values falsetrue |
| moneyline_away | integernullable | — | -110 | American odds for an away win |
| moneyline_home | integernullable | — | -110 | American odds for a home win |
| over_odds | integernullable | — | -120 | — |
| spread | decimalnullable | — | -1.5 | Home team puck line (e.g., -1.5 means home favored by 1.5 goals) |
| spread_away_odds | integernullable | — | 210 | American odds for the away puck line |
| spread_home_odds | integernullable | — | 210 | American odds for the home puck line |
| total | decimalnullable | — | 6.5 | Combined goals total line (e.g., 6.5) |
| under_odds | integernullable | — | 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nhl.games | 7680 | — |
| operator_id | bigint | → main.operators | 6 | Sportsbook id: 6 Consensus. |
| season_id | bigint | → nhl.seasons | 2023 | — |
| book_count | integernullable | — | 3 | — |
| captured_at | timestamptz | — | 2024-01-11T23:55:39.000Z | — |
| draw_odds | integernullable | — | — | American odds for a tied period (three-way markets only) |
| implied_away_win_pct | decimalnullable | — | 0.5 | — |
| implied_home_win_pct | decimalnullable | — | 0.5 | — |
| is_opening | boolean | — | true | — |
| moneyline_away | integernullable | — | 100 | — |
| moneyline_home | integernullable | — | -145 | — |
| over_odds | integernullable | — | -135 | — |
| period_code | string | — | p1 | p1, p2 or p3 Values p1p2p3 |
| spread | decimalnullable | — | -0.5 | — |
| spread_away_odds | integernullable | — | -190 | — |
| spread_home_odds | integernullable | — | 120 | — |
| total | decimalnullable | — | 1.5 | — |
| under_odds | integernullable | — | 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nhl.games | 20032 | — |
| operator_id | bigint | → main.operators | 6 | Usually consensus (6) |
| player_id | bigint | → nhl.players | 321 | — |
| season_id | bigint | → nhl.seasons | 2026 | — |
| book_count | integer | — | 1 | — |
| captured_at | timestamptz | — | 2026-10-01T21:20:09.654Z | — |
| category | string | — | shots_on_goal | — Values shots_on_goalanytime_goalgoalspointsassistssavespower_play_pointsblocked_shots |
| is_opening | boolean | — | true | — Values truefalse |
| line | decimalnullable | — | 1.5 | — |
| market_key | string | — | player_goal_scorer_anytime | — Values player_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_odds | integernullable | — | — | — |
| outcome_type | string | — | ou | ou | yes_no Values ouyes_no |
| over_odds | integernullable | — | 10000 | — |
| period_code | stringnullable | — | — | — |
| subcategory | stringnullable | — | alternate | — |
| under_odds | integernullable | — | -115 | — |
| yes_odds | integernullable | — | 700 | — |
Lineups & Roster
nhl.coaching_staffs2 fieldsendpoints →
NHL head coaches since 2021-22.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| name | string | — | 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| player1_id | bigint | — | 1140 | — |
| player2_id | bigintnullable | — | 571 | — |
| player3_id | bigintnullable | — | 460 | — |
| player4_id | bigintnullable | — | 408 | — |
| player5_id | bigintnullable | — | 233 | — |
| season_id | bigint | → nhl.seasons | 2026 | — |
| team_id | bigint | → nhl.teams | 2 | — |
| day | date | — | 2026-11-14 | — |
| line_number | integer | — | 1 | — |
| line_type | string | — | defense_pair | — Values defense_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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| coaching_staff_id | bigint | → nhl.coaching_staffs | 3 | — |
| season_id | bigint | → nhl.seasons | 2021 | — |
| team_id | bigint | → nhl.teams | 22 | — |
| coach_type | string | — | head_coach | head_coach |
| first_day | integer | — | 20251009 | YYYYMMDD date of the coach's first game with the team that season |
| games | integer | — | 82 | Games coached for the team that season |
| last_day | integer | — | 20261117 | YYYYMMDD 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nhl.games | 3924 | — |
| player_id | bigint | → nhl.players | 7099 | — |
| team_id | bigint | → nhl.teams | 25 | — |
| day | integer | — | 20211009 | YYYYMMDD date of the game |
| dressed | boolean | — | true | True when the player dressed for the game Values truefalse |
| is_scratched | boolean | — | false | True when the player was scratched (always the opposite of dressed) Values falsetrue |
| is_starting_goalie | boolean | — | false | True for the goalie who started the game (one per team) Values falsetrue |
| position | stringnullable | — | D | C, L, R, D or G Values DCLRG |
| sweater_number | integernullable | — | 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| player_id | bigint | → nhl.players | 39 | — |
| season_id | bigint | → nhl.seasons | 2026 | — |
| team_id | bigint | → nhl.teams | 2 | — |
| day | date | — | 2026-11-14 | — |
| depth_order | integer | — | 1 | 1=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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| league_arena_id | integernullable | — | 6 | Official NHL arena ID (issued by the league) |
| address | stringnullable | — | — | — |
| capacity | integernullable | — | — | — |
| city | string | — | Salt Lake City | — |
| closed_date | timestamptznullable | — | — | — |
| country | stringnullable | — | — | — |
| description | stringnullable | — | — | — |
| elevation | floatnullable | — | — | Elevation in feet above sea level |
| image_url | stringnullable | — | — | URL to aerial/overview image of arena |
| latitude | floatnullable | — | — | — |
| longitude | floatnullable | — | — | — |
| name | string | — | TD Garden | — |
| opened_date | timestamptznullable | — | — | — |
| roof_type | stringnullable | — | Indoor | Arena roof type (all indoor) |
| state | stringnullable | — | — | — |
| surface | string | — | Ice | Playing surface type |
| team_name | stringnullable | — | — | — |
| timezone | stringnullable | — | — | 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| nhl_broadcaster_id | integer | — | 389 | The league's own id for this network. Not a broadcaster_id; game_broadcasters.broadcaster_id holds this table's id. |
| country_code | stringnullable | — | US | US or CA Values USCA |
| network | string | — | BSMW APP | Network call sign (e.g. ABC, TNT, SN1, RDS, MSG) |
nhl.referees2 fieldsendpoints →
NHL on-ice officials — the referees and linesmen who work the games.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| full_name | string | — | 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| away_team_id | bigint | → nhl.teams | 27 | — |
| home_team_id | bigint | → nhl.teams | 9 | — |
| season_id | bigint | → nhl.seasons | 2021 | — |
| series_id | integernullable | — | 1 | — |
| winner_team_id | bigintnullable | → nhl.teams | 4 | — |
| away_team_seed | integer | — | 3 | — |
| away_team_wins | integer | — | 4 | — |
| conference | stringnullable | — | — | — |
| games_played | integer | — | 6 | — |
| home_team_seed | integer | — | 1 | — |
| home_team_wins | integer | — | 4 | — |
| max_games | integer | — | 7 | — |
| playoff_round | string | — | First Round | — Values First RoundSecond RoundConference FinalsStanley Cup Final |
| status | string | — | 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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| broadcaster_id | bigint | → nhl.broadcasters | 62 | — |
| game_id | bigint | → nhl.games | 2981 | — |
| market | string | — | N | H home team's market, A away team's market, N national Values NHA |
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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nhl.games | 15253 | — |
| referee_id | bigint | → nhl.referees | 32 | — |
| position | string | — | referee | referee or linesman Values refereelinesman |
| sweater_number | integernullable | — | 79 | — |
nhl.player_news21 fields· 4 refsendpoints →
News about NHL players — trades, IR placements, line changes, suspensions, and general beat-reporter updates.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigintnullable | → nhl.games | 1930 | Associated game ID when this news item relates to a specific game. |
| news_id | integernullable | — | 38315 | External news item ID from the provider. |
| opponent_team_id | bigintnullable | → nhl.teams | 32 | Opponent team ID when this news item relates to an upcoming or active game matchup. |
| player_id | bigintnullable | → nhl.players | 195 | Player ID associated with the news report. |
| team_id | bigintnullable | → nhl.teams | 22 | Team ID of the player at the time of publication. |
| ai_processed | boolean | — | false | Whether this story was generated or enriched via LLM summarization. Values falsetrue |
| author | stringnullable | — | — | Reporter or author of the article. |
| categories | stringnullable | — | — | Comma-separated raw topic tags. |
| category | stringnullable | — | injury | injury, transaction, lineup, general Values injurytransactiongeneralcontractlineupsuspension |
| content | stringnullable | — | 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. |
| description | stringnullable | — | 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_at | timestamptznullable | — | 1970-01-01T00:00:00.000Z | Timestamp when this story was first reported before multi-source compaction. |
| news_time | timestamptz | — | 2026-09-29T04:00:00.000Z | Publication timestamp of the news story. |
| priority | integer | — | 5 | Display priority score (1-10). |
| situational_impact | jsonbnullable | — | [object Object] | Structured situational impact assessment and fantasy implications for the player. |
| status_enum | stringnullable | — | ACTIVE | Standardized 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). Values ACTIVEROUTINERELEASEDTRADEDQUESTIONABLESIGNEDRULED_OUTIR_PLACEDPROBABLEINACTIVECLEAREDSTARTINGBENCHED |
| terms_of_use | stringnullable | — | — | Syndication terms and attribution. |
| title | string | — | Torey Krug placed on IR with ankle injury | Headline of the news report. |
| updated_time | timestamptznullable | — | — | Timestamp when the story was last revised. |
| urgency | stringnullable | — | ROUTINE | Urgency level of the news event (BREAKING_GAME_TIME, HIGH, MEDIUM, ROUTINE). Values ROUTINEHIGHMEDIUMBREAKING_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.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nhl.games | 3020 | — |
| opponent_team_id | bigint | — | 4 | — |
| season_id | bigint | → nhl.seasons | 2021 | — |
| team_id | bigint | → nhl.teams | 4 | — |
| game_number | integer | — | 1 | — |
| games_remaining | integer | — | 5 | — |
| is_back_to_back | boolean | — | false | — Values falsetrue |
| is_home | boolean | — | false | — Values falsetrue |
| opponent_is_back_to_back | boolean | — | false | — Values falsetrue |
| opponent_rest_days | integernullable | — | 1 | — |
| rest_days | integernullable | — | 1 | Full days since the team's previous game (0 = back-to-back; empty for its first game) |
| season_pct | decimal | — | 1.0000 | 0.0-1.0 share of the team's games of this season type played, this one included |
| season_type | string | — | regular_season | — Values regular_seasonpostseason |
nhl.team_news10 fields· 3 refsendpoints →
News and updates about NHL teams — game previews, coaching changes, front-office moves, and beat reports.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigintnullable | → nhl.games | 20266 | Associated game ID when news relates to a specific game. |
| opponent_team_id | bigintnullable | → nhl.teams | 20 | Opponent team ID when news relates to an upcoming or completed game matchup. |
| team_id | bigint | → nhl.teams | 25 | Team ID that this news event pertains to. |
| ai_processed | booleannullable | — | true | Whether this story was generated or enriched via LLM summarization. |
| category | stringnullable | — | game_preview | game_preview, coaching, transaction, general Values game_previewtransactiongeneralcoachingdepth_chart |
| news_time | timestamptz | — | 2026-07-01T00:00:00.000Z | Publication timestamp of the team story. |
| summary | string | — | 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. |
| title | string | — | Cale Makar signs $163.2M contract, sets new NHL defenseman benchmark | Headline of the team news story. |
| urgency | stringnullable | — | ROUTINE | ROUTINE, MEDIUM, HIGH, BREAKING_GAME_TIME Values ROUTINEMEDIUMHIGHBREAKING_GAME_TIME |