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 | — | — | — |
| post_season_start_date | timestamptznullable | — | — | — |
| regular_season_start_date | timestamptznullable | — | — | — |
| stanley_cup_finals_date | timestamptznullable | — | — | — |
| start_date | timestamptz | — | — | — |
| start_year | integer | — | — | — |
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 | — | — |
| league_team_id | integernullable | — | — | Official NHL team ID from api-web.nhle.com |
| abbreviation | string | — | — | — |
| active | boolean | — | — | — |
| city | string | — | — | — |
| conference | string | — | — | — |
| division | string | — | — | — |
| full_name | string | — | — | — |
| head_coach | stringnullable | — | — | — |
| logo_url | stringnullable | — | — | URL to team logo image |
| name | string | — | — | — |
| primary_color | stringnullable | — | — | — |
| quaternary_color | stringnullable | — | — | — |
| secondary_color | stringnullable | — | — | — |
| tertiary_color | stringnullable | — | — | — |
| wikipedia_logo_url | stringnullable | — | — | — |
| wikipedia_wordmark_url | stringnullable | — | — | — |
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 | — | — | Official NHL player ID from api-web.nhle.com |
| team_id | bigintnullable | → nhl.teams | — | — |
| birth_city | stringnullable | — | — | — |
| birth_country | stringnullable | — | — | — |
| birth_date | datenullable | — | — | — |
| birth_state | stringnullable | — | — | — |
| catches | stringnullable | — | — | — |
| college | stringnullable | — | — | — |
| draft_overall_pick | integernullable | — | — | — |
| draft_pick | integernullable | — | — | — |
| draft_round | integernullable | — | — | — |
| draft_year | integernullable | — | — | — |
| experience | integernullable | — | — | Years of NHL experience |
| first_name | string | — | — | — |
| full_name | string | — | — | — |
| height | integernullable | — | — | Height in inches |
| injury_body_part | stringnullable | — | — | — |
| injury_notes | stringnullable | — | — | — |
| injury_start_date | timestamptznullable | — | — | — |
| injury_status | stringnullable | — | — | — |
| jersey | stringnullable | — | — | — |
| last_name | string | — | — | — |
| nationality | stringnullable | — | — | — |
| photo_url | stringnullable | — | — | URL to player headshot image |
| position_category | stringnullable | — | — | — |
| primary_position | string | — | — | — |
| rookie_year | integernullable | — | — | — |
| roster_status | stringnullable | — | — | 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}. |
| shoots | stringnullable | — | — | — |
| weight | integernullable | — | — | Weight in pounds |
| youth_league | stringnullable | — | — | — |
| youth_team | 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 | — | — |
| away_team_id | bigint | → nhl.teams | — | — |
| home_team_id | bigint | → nhl.teams | — | — |
| league_game_id | integernullable | — | — | Official NHL game ID from api-web.nhle.com |
| league_id | stringnullable | — | — | Official NHL game identifier |
| season_id | bigint | → nhl.seasons | — | — |
| attendance | integernullable | — | — | — |
| away_team_score | integernullable | — | — | — |
| away_team_score_overtime | integernullable | — | — | — |
| away_team_score_period1 | integernullable | — | — | — |
| away_team_score_period2 | integernullable | — | — | — |
| away_team_score_period3 | integernullable | — | — | — |
| away_team_series_wins | integernullable | — | — | — |
| channel | stringnullable | — | — | — |
| day | integer | — | — | Calendar day as a YYYYMMDD integer (e.g. 20240915), US Eastern. |
| game_time | timestamptz | — | — | Scheduled puck drop (timezone-aware). |
| home_team_score | integernullable | — | — | — |
| home_team_score_overtime | integernullable | — | — | — |
| home_team_score_period1 | integernullable | — | — | — |
| home_team_score_period2 | integernullable | — | — | — |
| home_team_score_period3 | integernullable | — | — | — |
| home_team_series_wins | integernullable | — | — | — |
| is_overtime | boolean | — | — | — |
| is_shootout | boolean | — | — | — |
| last_play | stringnullable | — | — | — |
| neutral_site | boolean | — | — | — |
| overtime_periods | integernullable | — | — | — |
| 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 | — | — | Canonical season phase (text). Was integer 1/2/3/4 before the 2026-06-29 normalization. |
| series_game_number | integernullable | — | — | — |
| status | string | — | — | — |
| time_remaining_minutes | integernullable | — | — | — |
| time_remaining_seconds | integernullable | — | — | — |
Plays
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 | — | — |
| game_id | bigint | → nhl.games | — | — |
| penalty_id | integer | — | — | — |
| player_id | bigintnullable | → nhl.players | — | — |
| team_id | bigint | → nhl.teams | — | — |
| description | stringnullable | — | — | — |
| is_bench_penalty | boolean | — | — | — |
| penalty_minutes | integer | — | — | — |
| penalty_type | string | — | — | — |
| period_number | integer | — | — | — |
| time_remaining | string | — | — | 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 | — | — |
| league_game_id | integer | — | — | Official NHL game ID from api-web.nhle.com (matches nhl.games.league_game_id). |
| period_id | integer | — | — | — |
| away_team_score | integer | — | — | — |
| home_team_score | integer | — | — | — |
| name | string | — | — | 1, 2, 3, OT, OT2, SO |
| period_number | integer | — | — | — |
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 | — | — |
| primary_assist_player_id | bigintnullable | → nhl.players | — | — |
| scored_by_player_id | bigintnullable | → nhl.players | — | — |
| scoring_play_id | integer | — | — | — |
| secondary_assist_player_id | bigintnullable | → nhl.players | — | — |
| team_id | bigint | → nhl.teams | — | — |
| away_team_score | integer | — | — | — |
| description | stringnullable | — | — | — |
| goal_type | stringnullable | — | — | — |
| home_team_score | integer | — | — | — |
| period_number | integer | — | — | — |
| time_remaining | string | — | — | 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 | — | Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo, 13 sportsdata.io. |
| operator_team_id | string | — | — | External team ID from operator |
| team_id | bigint | → nhl.teams | — | Internal nhl.teams.id reference |
| abbreviation | stringnullable | — | — | Team abbreviation for reconciliation |
| team_name | stringnullable | — | — | 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 | — | — |
| team_id | bigint | → nhl.teams | — | — |
| blocked_shots | integer | — | — | — |
| faceoff_losses | integer | — | — | — |
| faceoff_percentage | decimal | — | — | — |
| faceoff_wins | integer | — | — | — |
| games_played | integer | — | — | — |
| giveaways | integer | — | — | — |
| goal_differential | integer | — | — | — |
| goals_against | integer | — | — | — |
| goals_against_average | decimal | — | — | — |
| goals_against_per_game | decimal | — | — | — |
| goals_for | integer | — | — | — |
| goals_per_game | decimal | — | — | — |
| hits | integer | — | — | — |
| losses | integer | — | — | — |
| overtime_losses | integer | — | — | — |
| penalty_kill_goals_against | integer | — | — | — |
| penalty_kill_percentage | decimal | — | — | — |
| penalty_minutes | integer | — | — | — |
| power_play_goals | integer | — | — | — |
| power_play_opportunities | integer | — | — | — |
| power_play_percentage | decimal | — | — | — |
| pts | integer | — | — | — |
| pts_percentage | decimal | — | — | — |
| save_percentage | decimal | — | — | — |
| season_type | string | — | — | Canonical season phase (text). Was integer 1/2/3 before the 2026-06-29 normalization. |
| shooting_percentage | decimal | — | — | — |
| short_handed_goals | integer | — | — | — |
| shots_against | integer | — | — | — |
| shots_for | integer | — | — | — |
| shutouts | integer | — | — | — |
| takeaways | integer | — | — | — |
| times_shorthanded | integer | — | — | — |
| wins | integer | — | — | — |
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 | — | — |
| team_id | bigint | → nhl.teams | — | — |
| away_losses | integer | — | — | — |
| away_overtime_losses | integer | — | — | — |
| away_wins | integer | — | — | — |
| clinched_conference | boolean | — | — | — |
| clinched_division | boolean | — | — | — |
| clinched_playoffs | boolean | — | — | — |
| clinched_presidents_trophy | boolean | — | — | — |
| conference | string | — | — | — |
| conference_rank | integer | — | — | — |
| division | string | — | — | — |
| division_rank | integer | — | — | — |
| games_played | integer | — | — | — |
| goal_differential | integer | — | — | — |
| goals_against | integer | — | — | — |
| goals_for | integer | — | — | — |
| home_losses | integer | — | — | — |
| home_overtime_losses | integer | — | — | — |
| home_wins | integer | — | — | — |
| last_10_losses | integer | — | — | — |
| last_10_overtime_losses | integer | — | — | — |
| last_10_wins | integer | — | — | — |
| losses | integer | — | — | — |
| overtime_losses | integer | — | — | — |
| pts | integer | — | — | — |
| pts_percentage | decimal | — | — | — |
| rank | integer | — | — | — |
| regulation_wins | integer | — | — | — |
| season_type | string | — | — | — |
| shootout_losses | integer | — | — | — |
| shootout_wins | integer | — | — | — |
| streak | stringnullable | — | — | Current streak (W3, L2, OTL1) |
| wild_card_rank | integernullable | — | — | — |
| wins | integer | — | — | — |
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 | — | — |
| opponent_id | bigintnullable | — | — | — |
| player_id | bigint | → nhl.players | — | — |
| team_id | bigint | → nhl.teams | — | — |
| assists | integer | — | — | — |
| blocked_shots | integer | — | — | — |
| empty_net_goals | integer | — | — | — |
| even_strength_assists | integer | — | — | — |
| even_strength_goals | integer | — | — | — |
| even_strength_time_on_ice_seconds | integer | — | — | — |
| faceoff_percentage | decimal | — | — | — |
| faceoffs_lost | integer | — | — | — |
| faceoffs_won | integer | — | — | — |
| first_period_goals_against | integer | — | — | — |
| game_winning_goals | integer | — | — | — |
| games | integer | — | — | 1 if player appeared, 0 if not |
| giveaways | integer | — | — | — |
| goals | integer | — | — | — |
| goals_against | integer | — | — | — |
| goals_against_average | decimal | — | — | — |
| hits | integer | — | — | — |
| home_or_away | stringnullable | — | — | — |
| is_game_over | boolean | — | — | — |
| losses | integer | — | — | — |
| major_penalties | integer | — | — | — |
| minor_penalties | integer | — | — | — |
| minutes_played | integer | — | — | Goalie minutes played |
| overtime_goals | integer | — | — | — |
| overtime_goals_against | integer | — | — | — |
| overtime_losses | integer | — | — | — |
| penalties | integer | — | — | — |
| penalty_minutes | integer | — | — | — |
| plus_minus | integer | — | — | — |
| power_play_assists | integer | — | — | — |
| power_play_goals | integer | — | — | — |
| power_play_goals_against | integer | — | — | — |
| power_play_pts | integer | — | — | — |
| power_play_saves | integer | — | — | — |
| power_play_shots_against | integer | — | — | — |
| power_play_time_on_ice_seconds | integer | — | — | — |
| pts | integer | — | — | — |
| save_percentage | decimal | — | — | — |
| saves | integer | — | — | — |
| second_period_goals_against | integer | — | — | — |
| shifts | integer | — | — | — |
| shooting_percentage | decimal | — | — | — |
| shootout_attempts | integer | — | — | — |
| shootout_goals | integer | — | — | — |
| shootout_goals_against | integer | — | — | — |
| shootout_saves | integer | — | — | — |
| short_handed_assists | integer | — | — | — |
| short_handed_goals | integer | — | — | — |
| short_handed_goals_against | integer | — | — | — |
| short_handed_pts | integer | — | — | — |
| short_handed_saves | integer | — | — | — |
| short_handed_shots_against | integer | — | — | — |
| short_handed_time_on_ice_seconds | integer | — | — | — |
| shots | integer | — | — | — |
| shots_against | integer | — | — | — |
| shots_on_goal | integer | — | — | — |
| shutouts | integer | — | — | — |
| started | integer | — | — | — |
| takeaways | integer | — | — | — |
| third_period_goals_against | integer | — | — | — |
| time_on_ice_seconds | integer | — | — | — |
| wins | integer | — | — | — |
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 | — | — |
| team_id | bigint | → nhl.teams | — | — |
| assists | integer | — | — | — |
| blocked_shots | integer | — | — | — |
| faceoff_percentage | decimal | — | — | — |
| faceoffs_lost | integer | — | — | — |
| faceoffs_won | integer | — | — | — |
| giveaways | integer | — | — | — |
| goals | integer | — | — | — |
| goals_against | integer | — | — | — |
| hits | integer | — | — | — |
| losses | integer | — | — | — |
| overtime_losses | integer | — | — | — |
| penalties | integer | — | — | — |
| penalty_kill_goals_against | integer | — | — | — |
| penalty_kill_percentage | decimal | — | — | — |
| penalty_minutes | integer | — | — | — |
| power_play_attempts | integer | — | — | — |
| power_play_goals | integer | — | — | — |
| power_play_percentage | decimal | — | — | — |
| save_percentage | decimal | — | — | — |
| saves | integer | — | — | — |
| shooting_percentage | decimal | — | — | — |
| short_handed_goals | integer | — | — | — |
| shots | integer | — | — | — |
| shots_on_goal | integer | — | — | — |
| takeaways | integer | — | — | — |
| times_shorthanded | integer | — | — | — |
| wins | integer | — | — | — |
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 | — | Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo, 13 sportsdata.io. |
| operator_player_id | string | — | — | External player ID from operator |
| player_id | bigintnullable | → nhl.players | — | Internal nhl.players.id reference |
| decided_at | timestamptznullable | — | — | When the pin or block was decided. |
| decided_reason | stringnullable | — | — | Evidence behind a pinned or blocked decision. |
| decision | stringnullable | — | — | 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. |
| player_name | stringnullable | — | — | Player name for reconciliation |
| position | stringnullable | — | — | Position for reconciliation |
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 | — | — |
| season_id | bigint | → nhl.seasons | — | — |
| team_id | bigintnullable | → nhl.teams | — | — |
| assists | integer | — | — | — |
| assists_per_game | decimal | — | — | — |
| blocked_shots | integer | — | — | — |
| empty_net_goals | integer | — | — | — |
| even_strength_assists | integer | — | — | — |
| even_strength_goals | integer | — | — | — |
| even_strength_time_on_ice_seconds | integer | — | — | — |
| faceoff_percentage | decimal | — | — | — |
| faceoffs_lost | integer | — | — | — |
| faceoffs_won | integer | — | — | — |
| game_winning_goals | integer | — | — | — |
| games_played | integer | — | — | — |
| games_started | integer | — | — | — |
| giveaways | integer | — | — | — |
| goals | integer | — | — | — |
| goals_against | integer | — | — | — |
| goals_against_average | decimal | — | — | — |
| goals_per_game | decimal | — | — | — |
| hat_tricks | integer | — | — | — |
| hits | integer | — | — | — |
| losses | integer | — | — | — |
| major_penalties | integer | — | — | — |
| minor_penalties | integer | — | — | — |
| minutes_played | integer | — | — | — |
| overtime_goals | integer | — | — | — |
| overtime_losses | integer | — | — | — |
| penalties | integer | — | — | — |
| penalty_minutes | integer | — | — | — |
| plus_minus | integer | — | — | — |
| position | stringnullable | — | — | — |
| power_play_assists | integer | — | — | — |
| power_play_goals | integer | — | — | — |
| power_play_pts | integer | — | — | — |
| power_play_time_on_ice_seconds | integer | — | — | — |
| pts | integer | — | — | — |
| pts_per_game | decimal | — | — | — |
| save_percentage | decimal | — | — | — |
| saves | integer | — | — | — |
| season_type | string | — | — | Canonical season phase (text). Was integer 1/2/3 before the 2026-06-29 normalization. |
| shifts | integer | — | — | — |
| shooting_percentage | decimal | — | — | — |
| shootout_attempts | integer | — | — | — |
| shootout_goals | integer | — | — | — |
| shootout_goals_against | integer | — | — | — |
| shootout_misses | integer | — | — | — |
| shootout_saves | integer | — | — | — |
| short_handed_assists | integer | — | — | — |
| short_handed_goals | integer | — | — | — |
| short_handed_pts | integer | — | — | — |
| short_handed_time_on_ice_seconds | integer | — | — | — |
| shots | integer | — | — | — |
| shots_against | integer | — | — | — |
| shots_on_goal | integer | — | — | — |
| shutouts | integer | — | — | — |
| takeaways | integer | — | — | — |
| time_on_ice_per_game | decimal | — | — | — |
| time_on_ice_seconds | integer | — | — | — |
| wins | integer | — | — | — |
Odds
nhl.game_odds13 fields· 1 refsendpoints →
NHL game betting lines — moneylines, puck lines (the hockey point-spread equivalent), and over/under totals from sportsbooks, captured over time as the lines move from opening to closing.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nhl.games | — | — |
| away_money_line | integernullable | — | — | — |
| away_point_spread | decimalnullable | — | — | — |
| away_point_spread_payout | integernullable | — | — | — |
| draw_money_line | integernullable | — | — | — |
| home_money_line | integernullable | — | — | — |
| home_point_spread | decimalnullable | — | — | — |
| home_point_spread_payout | integernullable | — | — | — |
| over_payout | integernullable | — | — | — |
| over_under | decimalnullable | — | — | — |
| sportsbook | stringnullable | — | — | DraftKings, FanDuel, BetMGM, etc. |
| under_payout | integernullable | — | — | — |
Lineups & Roster
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 | — | — | — |
| player2_id | bigintnullable | — | — | — |
| player3_id | bigintnullable | — | — | — |
| player4_id | bigintnullable | — | — | — |
| player5_id | bigintnullable | — | — | — |
| season_id | bigint | → nhl.seasons | — | — |
| team_id | bigint | → nhl.teams | — | — |
| day | date | — | — | — |
| line_number | integer | — | — | — |
| line_type | string | — | — | — |
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 | — | — |
| season_id | bigint | → nhl.seasons | — | — |
| team_id | bigint | → nhl.teams | — | — |
| day | date | — | — | — |
| depth_order | integer | — | — | 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 | — | — | Official NHL arena ID from api-web.nhle.com |
| address | stringnullable | — | — | — |
| capacity | integernullable | — | — | — |
| city | string | — | — | — |
| 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 | — | — | — |
| opened_date | timestamptznullable | — | — | — |
| roof_type | stringnullable | — | — | Arena roof type (all indoor) |
| state | stringnullable | — | — | — |
| surface | string | — | — | Playing surface type |
| team_name | stringnullable | — | — | — |
| timezone | stringnullable | — | — | IANA timezone (e.g., America/New_York) |
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 | — | — |
| home_team_id | bigint | → nhl.teams | — | — |
| season_id | bigint | → nhl.seasons | — | — |
| series_id | integernullable | — | — | — |
| winner_team_id | bigintnullable | → nhl.teams | — | — |
| away_team_seed | integer | — | — | — |
| away_team_wins | integer | — | — | — |
| conference | stringnullable | — | — | — |
| games_played | integer | — | — | — |
| home_team_seed | integer | — | — | — |
| home_team_wins | integer | — | — | — |
| max_games | integer | — | — | — |
| playoff_round | string | — | — | — |
| status | string | — | — | — |
nhl.draft_picks9 fields· 3 refsendpoints →
Every NHL Draft selection — round, pick number, drafting team, the league/country the player came from, and the career stats that followed.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| draft_id | integernullable | — | — | — |
| original_team_id | integernullable | → nhl.teams | — | Team that originally owned the pick |
| player_id | bigintnullable | → nhl.players | — | — |
| team_id | bigint | → nhl.teams | — | — |
| overall_pick | integer | — | — | — |
| pick_in_round | integer | — | — | — |
| round | integer | — | — | — |
| year | integer | — | — | — |
nhl.player_injuries16 fields· 3 refsendpoints →
The ongoing injury record for each NHL player — body part, severity, designation (day-to-day, IR, LTIR), and expected return timeline.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| player_id | bigint | → nhl.players | — | — |
| season_id | bigint | → nhl.seasons | — | — |
| team_id | bigint | → nhl.teams | — | — |
| body_part | string | — | — | — |
| description | stringnullable | — | — | — |
| end_date | timestamptznullable | — | — | — |
| expected_return_date | timestamptznullable | — | — | — |
| games_missed | integer | — | — | — |
| injury_type | stringnullable | — | — | — |
| is_surgery_required | booleannullable | — | — | — |
| side | stringnullable | — | — | — |
| source | stringnullable | — | — | — |
| start_date | timestamptz | — | — | — |
| status | string | — | — | — |
| updated_date | timestamptz | — | — | — |
nhl.player_news28 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 |
| external_id | stringnullable | — | — | Unique identifier from the news provider. |
| game_id | bigintnullable | → nhl.games | — | Associated game ID when this news item relates to a specific game. |
| news_id | integernullable | — | — | External news item ID from the provider. |
| opponent_team_id | bigintnullable | → nhl.teams | — | Opponent team ID when this news item relates to an upcoming or active game matchup. |
| player_id | bigintnullable | → nhl.players | — | Player ID associated with the news report. |
| team_id | bigintnullable | → nhl.teams | — | Team ID of the player at the time of publication. |
| ai_processed | boolean | — | — | Whether this story was generated or enriched via LLM summarization. |
| author | stringnullable | — | — | Reporter or author of the article. |
| categories | stringnullable | — | — | Comma-separated raw topic tags. |
| category | stringnullable | — | — | injury, transaction, lineup, general |
| content | stringnullable | — | — | Full text content of the news report. |
| description | stringnullable | — | — | Brief synopsis or summary of the news event. |
| first_reported_at | timestamptznullable | — | — | Timestamp when this story was first reported before multi-source compaction. |
| link | stringnullable | — | — | URL link to the original article or source video. |
| news_time | timestamptz | — | — | Publication timestamp of the news story. |
| original_source | stringnullable | — | — | Original publishing outlet or syndicate. |
| original_source_url | stringnullable | — | — | Canonical permalink on the original publisher. |
| priority | integer | — | — | Display priority score (1-10). |
| situational_impact | jsonbnullable | — | — | Structured situational impact assessment and fantasy implications for the player. |
| source | stringnullable | — | — | Primary news source or publication. |
| sources | jsonbnullable | — | — | Source citations with source name, URL, author, and published timestamp. |
| status_enum | stringnullable | — | — | 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). |
| terms_of_use | stringnullable | — | — | Syndication terms and attribution. |
| title | string | — | — | Headline of the news report. |
| updated_time | timestamptznullable | — | — | Timestamp when the story was last revised. |
| urgency | stringnullable | — | — | Urgency level of the news event (BREAKING_GAME_TIME, HIGH, MEDIUM, ROUTINE). |
| url | stringnullable | — | — | Original source URL. |
nhl.team_news12 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 |
| external_id | stringnullable | — | — | Canonical external identifier for deduplication. |
| game_id | bigintnullable | → nhl.games | — | Associated game ID when news relates to a specific game. |
| opponent_team_id | bigintnullable | → nhl.teams | — | Opponent team ID when news relates to an upcoming or completed game matchup. |
| team_id | bigint | → nhl.teams | — | Team ID that this news event pertains to. |
| ai_processed | booleannullable | — | — | Whether this story was generated or enriched via LLM summarization. |
| category | stringnullable | — | — | game_preview, coaching, transaction, general |
| news_time | timestamptz | — | — | Publication timestamp of the team story. |
| sources | jsonbnullable | — | — | Source citations with publisher name, URL, author, and published timestamp. |
| summary | string | — | — | Concise journalistic summary of the team news event. |
| title | string | — | — | Headline of the team news story. |
| urgency | stringnullable | — | — | ROUTINE, MEDIUM, HIGH, BREAKING_GAME_TIME |