NBA Data Dictionary
Main
nba.seasons6 fieldsendpoints →
Each NBA league year, running from October through June — the 82-game regular season, the play-in tournament, and the four-round playoffs that end with the NBA Finals.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| end_date | timestamptznullable | — | 2017-06-12T04:00:00.000Z | — |
| post_season_start_date | timestamptznullable | — | 2017-04-15T04:00:00.000Z | — |
| regular_season_start_date | timestamptznullable | — | 2016-10-25T04:00:00.000Z | — |
| start_date | timestamptz | — | 2016-10-25T04:00:00.000Z | — |
| start_year | integer | — | 2016 | — |
nba.teams10 fields· 1 refsendpoints →
The 30 NBA franchises, organized into the Eastern and Western Conferences with three divisions in each.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| league_team_id | integernullable | — | 1610612738 | Official NBA team ID from stats.nba.com |
| stadium_id | bigintnullable | → nba.stadiums | — | — |
| abbreviation | string | — | BOS | — |
| active | boolean | — | true | — |
| city | string | — | Los Angeles | — |
| conference | string | — | Eastern | — Values EasternWestern |
| division | string | — | Atlantic | — Values AtlanticCentralSoutheastNorthwestPacificSouthwest |
| full_name | string | — | Boston Celtics | — |
| name | string | — | Celtics | — |
nba.games27 fields· 4 refsendpoints →
Every scheduled and played NBA game from the 2020-21 season onward — preseason, the 82-game regular season, the In-Season Tournament, the play-in round, and the four-round playoffs through the NBA Finals. All-Star exhibitions are not included.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| away_team_id | bigint | → nba.teams | 1 | — |
| home_team_id | bigint | → nba.teams | 1 | — |
| league_game_id | stringnullable | — | 0022500650 | Official NBA game ID from stats.nba.com |
| season_id | bigint | → nba.seasons | 2023 | — |
| stadium_id | integernullable | → nba.stadiums | 19 | — |
| attendance | integernullable | — | 19156 | — |
| away_rotation_number | integernullable | — | — | — |
| away_team | string | — | BOS | — |
| away_team_score | integer | — | 113 | — |
| channel | stringnullable | — | NBA TV | — |
| day | integer | — | 20250413 | — |
| end_time | timestamptznullable | — | 2025-03-20T04:11:00.000Z | — |
| game_label | stringnullable | — | — | — |
| game_sub_label | stringnullable | — | — | — |
| game_time | timestamptznullable | — | 2025-04-13T19:30:00.000Z | Scheduled tip-off (timezone-aware); null when the league published no time. |
| home_rotation_number | integernullable | — | — | — |
| home_team | string | — | BOS | — |
| home_team_score | integer | — | 112 | — |
| if_necessary | booleannullable | — | — | — |
| neutral_venue | boolean | — | false | — Values falsetrue |
| postponed_status | stringnullable | — | — | — |
| season_type | string | — | regular_season | — Values regular_seasonpostseasonpreseasonplay_inin_season_tournament |
| series_game_number | stringnullable | — | — | — |
| series_name | stringnullable | — | — | — |
| series_text | stringnullable | — | — | — |
| status | string | — | Final | — |
nba.players40 fields· 1 refsendpoints →
Every individual who has played in the NBA — current rosters, two-way and 10-day contracts, G-League call-ups, free agents, and retired veterans. The roster signal lives in `roster_status` (the canonical cross-league vocabulary) and `team_id` (null for free agents and retired players). Pass `?team_id=` to scope to one franchise's current roster, or omit it to scan the full historical roster pool.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| league_player_id | integer | — | 203999 | Official NBA player ID from stats.nba.com. Stable across seasons; use for cross-API joins to nba_stats sources. |
| team_id | bigintnullable | → nba.teams | 12 | FK to nba.teams. Null for free agents and retired players. |
| birth_city | stringnullable | — | Sombor | City of birth. |
| birth_country | stringnullable | — | Serbia | Country of birth (ISO English name). |
| birth_date | datenullable | — | 1995-02-19 | Birth date in YYYY-MM-DD form. |
| birth_state | stringnullable | — | — | State / province of birth (US/Canadian players). |
| display_fi_last | stringnullable | — | N. Jokić | Display name in "F. Last" form. |
| display_last_comma_first | stringnullable | — | Jokić, Nikola | Display name in "Last, First" form. Useful for sorted lists. |
| dleague_flag | stringnullable | — | 00 | Two-character bit-string from stats.nba.com: "00" no G-League history, "01" G-League experience, "11" currently G-League-affiliated (two-way / assignment). |
| draft_number | stringnullable | — | 41 | Overall pick number within the draft (string). Empty for undrafted. |
| draft_round | stringnullable | — | 2 | Draft round (string). Empty for undrafted players. |
| draft_year | stringnullable | — | 2014 | Year the player was drafted (string form). Empty for undrafted players. |
| experience | integernullable | — | 10 | Years of NBA experience as of the most recent season. Rookies = 0. |
| first_name | string | — | Nikola | Player's legal first name as registered with the league. |
| from_year | stringnullable | — | 2015 | Player's NBA debut year as a string (per stats.nba.com). |
| full_name | string | — | Nikola Jokić | Convenience concatenation of first_name + last_name. Use this for display. |
| full_position_list | stringnullable | — | Guard-Forward | Hyphenated full-word position list (e.g., "Guard-Forward", "Center-Forward"). Values GuardForwardCenterGuard-ForwardForward-CenterCenter-ForwardForward-Guard |
| games_played_flag | stringnullable | — | Y | String "Y"/"N" indicating whether the player has played at least one regular-season game. Values YN |
| height | integernullable | — | 83 | Height in inches. |
| injury_body_part | stringnullable | — | — | Affected body part for the most recent injury (e.g., "Knee", "Ankle"). Null when injury_status is null. Values anklekneeillnesshiptoebackwristfootcalfhamstringpelvisabdomenheelrestachillesthumbhand |
| injury_detail | stringnullable | — | — | Free-text injury description from the source feed. |
| injury_since | timestamptznullable | — | 2026-04-12T18:30:00Z | Timestamp of the injury status snapshot. Updated when player_news produces a new injury entry. |
| injury_status | stringnullable | — | OUT | Current injury status snapshot derived from player_news. Values: "OUT", "QUESTIONABLE"; null = no active injury designation (healthy). Values OUTQUESTIONABLE |
| jersey | stringnullable | — | 15 | Current jersey number as a string (some leagues allow leading zeros, e.g., "00"). |
| last_affiliation | stringnullable | — | Mega Basket / Serbia | Most recent pre-NBA affiliation (school, league, or team). |
| last_name | string | — | Jokić | Player's legal last name. |
| league_slug | stringnullable | — | nikola-jokic | NBA-issued URL slug (e.g., for stats.nba.com player page). |
| nba_flag | stringnullable | — | Y | String "Y"/"N" indicating NBA experience. Almost always "Y" in this table. |
| playercode | stringnullable | — | jokic_nikola | NBA-issued player code (lastname_firstname format). |
| position_category | stringnullable | — | Center | Coarse positional grouping. One of Guard, Forward, Center, Utility. Values GuardForwardCenterUtility |
| primary_position | string | — | C | Primary position. One of G, F, C, G-F, F-C. (True PG/SG/SF/PF splits live in team_depth_charts.position.) Values GFCG-FF-CUnknown |
| roster_status | stringnullable | — | active | Canonical roster status, shared across leagues. NBA source granularity is coarse: "active" (on an NBA roster), "free_agent" (no team), "inactive" (not currently rostered); injured_reserve/retired appear where derivable. The "on a team now" set is {active, injured_reserve}. Values inactiveactivefree_agent |
| school | stringnullable | — | Mega Basket | Last school attended before the NBA (college, prep, or international club). |
| team_abbreviation | stringnullable | — | DEN | Current team's tri-letter code. |
| team_city | stringnullable | — | Denver | Current team's city name. |
| team_code | stringnullable | — | nuggets | Current team's lowercase URL slug. |
| team_name | stringnullable | — | Nuggets | Current team's mascot name (denormalized from teams.name for read convenience). |
| to_year | stringnullable | — | 2025 | Player's most recent NBA season year. Equal to from_year for rookies. |
| weight | integernullable | — | 284 | Listed weight in pounds. |
Plays
nba.game_possessions29 fields· 2 refsendpoints →
Each offensive possession in an NBA game (regular season, play-in, IST, and playoffs — no preseason) — which team had the ball, how the possession started, how it ended (made shot, missed shot, turnover, foul), and how long it lasted.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nba.games | 2357 | — |
| team_id | bigintnullable | → nba.teams | 19 | — |
| ast | integer | — | 0 | — |
| away_score | integer | — | 38 | — |
| blk | integer | — | 0 | — |
| cum_away_poss | integer | — | 13 | — |
| cum_home_poss | integer | — | 75 | — |
| dreb | integer | — | 0 | — |
| end_clock | integernullable | — | 0 | — |
| end_nba_event_num | integer | — | 7 | — |
| fg3a | integer | — | 0 | — |
| fg3m | integer | — | 0 | — |
| fga | integer | — | 1 | — |
| fgm | integer | — | 0 | — |
| fta | integer | — | 0 | — |
| ftm | integer | — | 0 | — |
| game_seconds_elapsed | integer | — | 720 | — |
| home_score | integer | — | 82 | — |
| oreb | integer | — | 0 | — |
| period | integer | — | 1 | — |
| pf | integer | — | 0 | — |
| pts | integer | — | 0 | — |
| start_clock | integer | — | 720 | — |
| start_nba_event_num | integer | — | 4 | — |
| stl | integer | — | 0 | — |
| time_actual_end | timestamptznullable | — | 2024-10-30T02:08:06.000Z | — |
| time_actual_start | timestamptznullable | — | 2024-10-28T23:53:48.400Z | — |
| tov | integer | — | 0 | — |
nba.play_by_plays21 fields· 8 refsendpoints →
Every individual event in every NBA game (regular season, play-in, IST, and playoffs — no preseason) — made and missed shots, rebounds, assists, fouls, turnovers, blocks, steals, substitutions, and timeouts, with the game clock at the moment. Period and score context live on game_possessions (FK game_possession_id).
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nba.games | 2377 | — |
| game_possession_id | bigint | → nba.game_possessions | 16457458 | — |
| play_id | string | — | 0052400111_2 | — |
| player_id | bigintnullable | → nba.players | 49 | — |
| player2_id | bigintnullable | → nba.players | 49 | — |
| player2_team_id | bigintnullable | → nba.teams | 21 | — |
| player3_id | bigintnullable | → nba.players | 227 | — |
| player3_team_id | bigintnullable | → nba.teams | 21 | — |
| team_id | bigintnullable | → nba.teams | 21 | — |
| end_clock | integernullable | — | — | — |
| event_seq | integer | — | 100 | — |
| event_sub_type | integer | — | 0 | — |
| event_type | integer | — | 8 | — |
| home_description | string | — | — | — |
| nba_event_num | integer | — | 2 | — |
| neutral_description | string | — | — | — |
| possession_seq | integer | — | 142 | — |
| start_clock | integer | — | 720 | — |
| time_actual | timestamptznullable | — | 2025-04-17T01:56:41.900Z | — |
| visitor_description | string | — | — | — |
Stats
nba.season_team_stats9 fields· 2 refsendpoints →
Season totals for each NBA team — wins and losses, points scored and allowed, pace, offensive and defensive ratings, rebounding margins, shooting splits, and turnover differentials. Regular-season games only; playoff, play-in, and preseason totals are not included.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| season_id | bigint | → nba.seasons | 2024 | — |
| team_id | bigint | → nba.teams | 11 | — |
| games_played | integer | — | 82 | — |
| losses | integer | — | 38 | — |
| pts_allowed | integer | — | 0 | — |
| pts_scored | integer | — | 9372 | — |
| ties | integer | — | 0 | — |
| wins | integer | — | 44 | — |
nba.team_standings21 fields· 2 refsendpoints →
Conference and division standings throughout the NBA season — wins, losses, win percentage, games behind, last-10 record, win/loss streak, and home/away splits as of each date.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| season_id | bigint | → nba.seasons | 2024 | — |
| team_id | bigint | → nba.teams | 1 | — |
| away_losses | integer | — | 6 | — |
| away_wins | integer | — | 1 | — |
| conference_gb | decimal | — | 0.0000 | Games back from conference leader |
| conference_rank | integer | — | 8 | 1-15 within conference |
| day | integer | — | 20241103 | YYYYMMDD — standings as of this date (before games on this day) |
| division_rank | integer | — | 1 | 1-5 within division |
| games_played | integer | — | 1 | — |
| games_remaining | integer | — | 81 | — |
| home_losses | integer | — | 4 | — |
| home_wins | integer | — | 1 | — |
| l10_losses | integer | — | 4 | — |
| l10_wins | integer | — | 6 | — |
| losses | integer | — | 1 | — |
| playin_gb | decimal | — | 0.0000 | Games back from 10th seed (play-in cutoff) |
| playoff_gb | decimal | — | 0.0000 | Games back from 6th seed (auto-qualify cutoff) |
| streak | integer | — | -1 | Positive = win streak, negative = loss streak |
| win_pct | decimal | — | 0.5000 | — |
| wins | integer | — | 2 | — |
nba.game_player_stats113 fields· 3 refsendpoints →
Each NBA player's stat line for each game — points, rebounds, assists, steals, blocks, shooting line, three-point line, free-throw line, plus-minus, and minutes played.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nba.games | 122 | — |
| player_id | bigint | → nba.players | 75 | — |
| team_id | bigint | → nba.teams | 17 | — |
| abnormal_exit_clock | integer | — | 0 | — |
| abnormal_exit_period | integer | — | 0 | — |
| alley_oops | integer | — | 0 | — |
| and_ones | integer | — | 0 | — |
| assist_percentage | decimalnullable | — | 0.0000 | — |
| assist_ratio | decimalnullable | — | 0.0000 | — |
| assist_to_turnover | decimalnullable | — | 0.0000 | — |
| assists | integer | — | 0 | — |
| avg_dribbles_per_touch | decimalnullable | — | 0.0000 | — |
| avg_seconds_per_touch | decimalnullable | — | 0.0000 | — |
| backcourt_violations | integer | — | 0 | — |
| balls_stolen | integernullable | — | 0 | — |
| basket_interference_violations | integer | — | 0 | — |
| blocks | integer | — | 0 | — |
| box_outs | integernullable | — | 0 | — |
| carrying_palming_violations | integer | — | 0 | — |
| challenges_requested | integer | — | 0 | — |
| charges_taken | integernullable | — | 0 | — |
| comment | stringnullable | — | — | — |
| competitive_minutes | decimal | — | 0.0 | — |
| contests | integernullable | — | 1 | — |
| defensive_rating | decimalnullable | — | 100.0000 | — |
| defensive_rebound_percentage | decimalnullable | — | 0.0000 | — |
| defensive_rebounds | integer | — | 1 | — |
| deflections | integernullable | — | 1 | — |
| double_doubles | integer | — | 0 | — |
| double_dribble_violations | integer | — | 0 | — |
| drives | integernullable | — | 0 | — |
| dunks | integer | — | 0 | — |
| effective_field_goal_percentage | decimalnullable | — | 0.0000 | — |
| ejections | integer | — | 0 | — |
| elbow_touches | integernullable | — | 0 | — |
| estimated_defensive_rating | decimalnullable | — | 100.0000 | — |
| estimated_net_rating | decimalnullable | — | 0.0000 | — |
| estimated_offensive_rating | decimalnullable | — | 100.0000 | — |
| estimated_pace | decimalnullable | — | 84.7100 | — |
| estimated_usage_percentage | decimalnullable | — | 0.1670 | — |
| fast_break_pts | integer | — | 0 | — |
| field_goal_percentage | decimalnullable | — | 0.0000 | — |
| field_goals_attempted | integer | — | 5 | — |
| field_goals_made | integer | — | 1 | — |
| foul_trouble_severity | integer | — | 0 | — |
| fouls | integer | — | 1 | Total fouls: personal_fouls + technical_fouls. Use personal_fouls, not this, to judge foul trouble — a player fouls out on 6 PERSONAL fouls and technicals do not count toward that. |
| fouls_drawn | integer | — | 0 | — |
| free_throw_percentage | decimalnullable | — | 0.0000 | — |
| free_throws_attempted | integer | — | 0 | — |
| free_throws_made | integer | — | 0 | — |
| front_court_touches | integernullable | — | 14 | — |
| game_date | integer | — | 20251112 | — |
| garbage_time_minutes | decimal | — | 0 | — |
| goaltending_violations | integer | — | 0 | — |
| hockey_assists | integernullable | — | 0 | — |
| jump_balls_lost | integer | — | 0 | — |
| jump_balls_won | integer | — | 0 | — |
| lane_violations | integer | — | 0 | — |
| layups | integer | — | 0 | — |
| loose_balls_recovered | integernullable | — | 0 | — |
| minutes | decimal | — | 31.7000 | — |
| minutes_deviation_pct | decimal | — | 0 | — |
| net_rating | decimalnullable | — | 0.0000 | — |
| offensive_fouls | integer | — | 0 | Offensive fouls. A SUBSET of personal_fouls, not an addition to it. |
| offensive_rating | decimalnullable | — | 100.0000 | — |
| offensive_rebound_percentage | decimalnullable | — | 0.0000 | — |
| offensive_rebounds | integer | — | 0 | — |
| paint_touches | integernullable | — | 0 | — |
| pass_percentage | decimalnullable | — | 0.0000 | — |
| passes | integernullable | — | 18 | — |
| passes_deflected | integernullable | — | 0 | — |
| personal_fouls | integer | — | 1 | Personal fouls only — the count a player fouls out on at 6. Includes offensive and flagrant fouls, which the NBA scores as personal fouls. |
| player_impact_estimate | decimal | — | 0.0000 | — |
| plus_minus | integer | — | 0 | — |
| possessions | integer | — | 53 | — |
| post_touches | integernullable | — | 0 | — |
| potential_assists | integernullable | — | 0 | — |
| pts | integer | — | 0 | — |
| pts_per_elbow_touch | decimalnullable | — | — | — |
| pts_per_paint_touch | decimalnullable | — | — | — |
| pts_per_post_touch | decimalnullable | — | — | — |
| pts_per_touch | decimalnullable | — | 0.0000 | — |
| put_backs | integer | — | 0 | — |
| rebound_percentage | decimalnullable | — | 0.0000 | — |
| rebounds | integer | — | 2 | — |
| role_anomalous_game | boolean | — | false | — Values falsetrue |
| role_archetype | stringnullable | — | deep_bench | — Values deep_benchco_starcore_starterrotationend_of_benchalphasixth_mantwo_way |
| role_archetype_confidence | decimal | — | 0.6 | — |
| rotation_context | stringnullable | — | normal | — Values normalgarbage_time_boostambiguous_anomalyblowout_restfoul_troublefoul_outinjury_exitdnp_coach |
| rotation_context_confidence | decimal | — | 0.5 | — |
| screen_assists | integernullable | — | 0 | — |
| second_chance_pts | integer | — | 0 | — |
| shot_clock_violations | integer | — | 0 | — |
| shot_contested_count | integernullable | — | 1 | — |
| shots_blocked | integernullable | — | 0 | — |
| start_position | stringnullable | — | G | — Values GFC |
| steals | integer | — | 0 | — |
| substitutions_in | integer | — | 0 | — |
| substitutions_out | integer | — | 0 | — |
| technical_fouls | integer | — | 0 | Technical fouls. The one foul type the NBA keeps OUT of the personal count; 2 means ejection. |
| three_point_percentage | decimalnullable | — | 0.0000 | — |
| three_pointers_attempted | integer | — | 0 | — |
| three_pointers_made | integer | — | 0 | — |
| time_of_possession | decimalnullable | — | 0.2000 | — |
| timeouts_called | integer | — | 0 | — |
| touches | integernullable | — | 28 | — |
| traveling_violations | integer | — | 0 | — |
| triple_doubles | integer | — | 0 | — |
| true_shooting_percentage | decimalnullable | — | 0.0000 | — |
| turnover_ratio | decimalnullable | — | 0.0000 | — |
| turnovers | integer | — | 0 | — |
| usage_percentage | decimalnullable | — | 0.0000 | — |
nba.game_team_stats70 fields· 2 refsendpoints →
Each NBA team's stat line for each game — the same offensive, defensive, rebounding, and shooting counters as the season aggregate, broken out per game with home/away context.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nba.games | 6 | — |
| team_id | bigint | → nba.teams | 12 | — |
| assist_percentage | decimal | — | 0.6670 | — |
| assist_ratio | decimal | — | 0.0000 | — |
| assists | integer | — | 24 | — |
| assists_to_turnovers | decimal | — | 2.0000 | — |
| bench_pts | integer | — | 34 | — |
| blocks | integer | — | 4 | — |
| conference_rank | integer | — | 0 | Conference rank entering game |
| defensive_rating | decimal | — | 100.0000 | — |
| defensive_rebound_percentage | decimal | — | 0.6670 | — |
| defensive_rebounds | integer | — | 32 | — |
| effective_field_goal_percentage | decimal | — | 0.5000 | — |
| estimated_defensive_rating | decimal | — | 0.0000 | — |
| estimated_net_rating | decimal | — | 0.0000 | — |
| estimated_offensive_rating | decimal | — | 0.0000 | — |
| estimated_pace | decimal | — | 0.0000 | — |
| fast_break_pts | integer | — | 11 | — |
| field_goal_percentage | decimal | — | 0.5000 | — |
| field_goals_attempted | integer | — | 88 | — |
| field_goals_made | integer | — | 42 | — |
| fouls | integer | — | 19 | — |
| free_throw_attempt_rate | decimal | — | 0.2500 | — |
| free_throw_percentage | decimal | — | 0.7500 | — |
| free_throws_attempted | integer | — | 21 | — |
| free_throws_made | integer | — | 17 | — |
| loss | integer | — | 0 | — |
| losses | integer | — | 0 | Cumulative losses |
| minutes | integer | — | 48 | — |
| net_rating | decimal | — | 2.0000 | — |
| offensive_rating | decimal | — | 100.0000 | — |
| offensive_rebound_percentage | decimal | — | 0.3330 | — |
| offensive_rebounds | integer | — | 10 | — |
| pace | decimal | — | 101.0000 | — |
| pace_per40 | decimal | — | 0.0000 | — |
| pct_ast_2pm | decimal | — | 0.5000 | — |
| pct_ast_3pm | decimal | — | 1.0000 | — |
| pct_ast_fgm | decimal | — | 0.6670 | — |
| pct_fga_2pt | decimal | — | 0.0000 | — |
| pct_fga_3pt | decimal | — | 0.0000 | — |
| pct_pts_2pt | decimal | — | 0.5000 | — |
| pct_pts_2pt_mr | decimal | — | 0.0000 | — |
| pct_pts_3pt | decimal | — | 0.0000 | — |
| pct_pts_fb | decimal | — | 0.0000 | — |
| pct_pts_ft | decimal | — | 0.0000 | — |
| pct_pts_off_tov | decimal | — | 0.0000 | — |
| pct_pts_paint | decimal | — | 0.0000 | — |
| pct_uast_2pm | decimal | — | 0.5000 | — |
| pct_uast_3pm | decimal | — | 0.0000 | — |
| pct_uast_fgm | decimal | — | 0.3330 | — |
| player_impact_estimate | decimal | — | 0.0000 | — |
| possessions | integer | — | 101 | — |
| pts | integer | — | 113 | — |
| pts_in_paint | integer | — | 50 | — |
| pts_off_turnovers | integer | — | 17 | — |
| rebound_percentage | decimal | — | 0.5000 | — |
| rebounds | integer | — | 42 | — |
| second_chance_pts | integer | — | 14 | — |
| steals | integer | — | 7 | — |
| steals_to_turnovers | decimal | — | 0.5000 | — |
| three_point_percentage | decimal | — | 0.3330 | — |
| three_pointers_attempted | integer | — | 34 | — |
| three_pointers_made | integer | — | 12 | — |
| timeouts_remaining | integer | — | 0 | — |
| true_shooting_percentage | decimal | — | 0.5760 | — |
| turnover_percentage | decimal | — | 0.0000 | — |
| turnovers | integer | — | 13 | — |
| win | integer | — | 0 | — |
| wins | integer | — | 0 | Cumulative wins |
nba.season_player_stats49 fields· 2 refsendpoints →
Season totals for each NBA player — scoring, rebounding, assists, steals, blocks, shooting splits, advanced metrics, plus-minus, and minutes played. Regular-season games only; playoff, play-in, and preseason totals are not included. Players traded mid-season have one merged row (no per-team split).
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| player_id | bigint | → nba.players | 1 | — |
| season_id | bigint | → nba.seasons | 2021 | — |
| assist_percentage | decimal | — | 0.0000 | — |
| assist_ratio | decimal | — | 0.0000 | — |
| assist_to_turnover | decimal | — | 0.0000 | — |
| assists | integer | — | 0 | — |
| avg_dribbles_per_touch | decimal | — | 1.0000 | — |
| avg_seconds_per_touch | decimal | — | 1.6400 | — |
| blocks | integer | — | 0 | — |
| defensive_rating | decimal | — | 111.1000 | — |
| defensive_rebound_percentage | decimal | — | 0.0000 | — |
| defensive_rebounds | integer | — | 0 | — |
| double_doubles | integer | — | 0 | — |
| effective_field_goal_percentage | decimal | — | 0.5000 | — |
| field_goal_percentage | decimal | — | 0.5000 | — |
| field_goals_attempted | integer | — | 6 | — |
| field_goals_made | integer | — | 0 | — |
| fouls | integer | — | 0 | — |
| free_throw_percentage | decimal | — | 0.0000 | — |
| free_throws_attempted | integer | — | 0 | — |
| free_throws_made | integer | — | 0 | — |
| front_court_touches | integer | — | 24 | — |
| games_played | integer | — | 68 | — |
| losses | integer | — | 1 | — |
| minutes | decimal | — | 1297.0367 | — |
| net_rating | decimal | — | 0.3000 | — |
| offensive_rating | decimal | — | 113.9000 | — |
| offensive_rebound_percentage | decimal | — | 0.0000 | — |
| offensive_rebounds | integer | — | 0 | — |
| pace | decimal | — | 100.6900 | — |
| player_impact_estimate | decimal | — | 0.0730 | — |
| plus_minus | integer | — | -7 | — |
| possessions | integer | — | 41 | — |
| pts | integer | — | 0 | — |
| rebound_percentage | decimal | — | 0.0620 | — |
| rebounds | integer | — | 0 | — |
| steals | integer | — | 0 | — |
| three_point_percentage | decimal | — | 0.0000 | — |
| three_pointers_attempted | integer | — | 0 | — |
| three_pointers_made | integer | — | 0 | — |
| time_of_possession | decimal | — | 0.8000 | — |
| touches | integer | — | 160 | — |
| triple_doubles | integer | — | 0 | — |
| true_shooting_percentage | decimal | — | 0.0000 | — |
| turnover_percentage | decimal | — | 0.0000 | — |
| turnovers | integer | — | 0 | — |
| usage_percentage | decimal | — | 0.1360 | — |
| wins | integer | — | 1 | — |
Odds
nba.game_lines30 fields· 3 refsendpoints →
NBA game betting lines — point spreads, moneylines, 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 | → nba.games | 16082 | — |
| operator_id | bigint | → main.operators | 6 | Sportsbook id: 6 Consensus (full history); per-book ids (1 DraftKings, 2 FanDuel, 1683 Pinnacle, 1684 BetMGM, 1685 Caesars, 1686 BetRivers, 1687 ESPN BET) begin 2026-05. |
| season_id | bigint | → nba.seasons | 2021 | Denormalized for efficient season-level queries |
| captured_at | timestamptz | — | 2022-04-10T00:00:00.000Z | When this snapshot was captured |
| implied_away_score | decimalnullable | — | 109.0000 | — |
| implied_away_win_pct | decimalnullable | — | 0.4082 | — |
| implied_home_score | decimalnullable | — | 109.7500 | Calculated from spread + total |
| implied_home_win_pct | decimalnullable | — | 0.6296 | From moneyline, 0-1 |
| is_opening | boolean | — | false | True if this is the opening line Values falsetrue |
| moneyline_away | integernullable | — | 145 | American odds for away team win |
| moneyline_bet_pct_away | integernullable | — | — | — |
| moneyline_bet_pct_home | integernullable | — | — | — |
| moneyline_home | integernullable | — | -170 | American odds for home team win |
| moneyline_money_pct_away | integernullable | — | — | — |
| moneyline_money_pct_home | integernullable | — | — | — |
| over_odds | integernullable | — | 0 | American odds for over |
| spread | decimalnullable | — | -2.5000 | Home team spread (e.g., -3.5 means home favored by 3.5) |
| spread_away_odds | integernullable | — | -110 | American odds for away spread |
| spread_bet_pct_away | integernullable | — | — | — |
| spread_bet_pct_home | integernullable | — | — | — |
| spread_home_odds | integernullable | — | -110 | American odds for home spread (e.g., -110) |
| spread_money_pct_away | integernullable | — | — | — |
| spread_money_pct_home | integernullable | — | — | — |
| total | decimalnullable | — | 225.5000 | Combined score total line (e.g., 224.5) |
| total_bet_pct_over | integernullable | — | — | — |
| total_bet_pct_under | integernullable | — | — | — |
| total_money_pct_over | integernullable | — | — | — |
| total_money_pct_under | integernullable | — | — | — |
| under_odds | integernullable | — | 0 | American odds for under |
nba.game_period_lines17 fields· 3 refsendpoints →
Period-specific NBA betting lines — first-half, second-half, and individual-quarter spreads, moneylines, and totals offered alongside the full-game markets.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nba.games | 769 | — |
| operator_id | bigint | → main.operators | 6 | Data source (consensus, DraftKings, FanDuel, etc.) |
| season_id | bigint | → nba.seasons | 2025 | Denormalized for efficient season-level queries |
| captured_at | timestamptz | — | 2024-01-05T05:00:00.000Z | When this snapshot was captured |
| implied_away_win_pct | decimalnullable | — | 0.5121951219512195 | — |
| implied_home_win_pct | decimalnullable | — | 0.5121951219512195 | From moneyline, 0-1 |
| is_opening | boolean | — | false | True if this is the first captured line for this period |
| moneyline_away | integernullable | — | -105 | American odds for away team win in this period |
| moneyline_home | integernullable | — | -105 | American odds for home team win in this period |
| over_odds | integernullable | — | -110 | American odds for over |
| period_code | string | — | 1H | Market period code (1H, 2H, Q1, Q2, Q3, Q4) Values 1HQ1Q3Q4Q22H |
| spread | decimalnullable | — | -0.5 | Home team spread for this period |
| spread_away_odds | integernullable | — | -110 | American odds for away spread |
| spread_home_odds | integernullable | — | -110 | American odds for home spread (e.g., -110) |
| total | decimalnullable | — | 57.5 | Combined score total line for this period |
| under_odds | integernullable | — | -110 | American odds for under |
nba.game_player_props18 fields· 4 refsendpoints →
NBA player prop bets for each game — points, rebounds, assists, threes made, steals, blocks, and other player-statistic markets offered by sportsbooks.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nba.games | 126 | — |
| operator_id | bigint | → main.operators | 6 | Usually consensus |
| player_id | bigint | → nba.players | 157 | — |
| season_id | bigint | → nba.seasons | 2025 | Denormalized for efficient season-level queries |
| book_count | integer | — | 3 | Number of curated books contributing to this consensus value |
| captured_at | timestamptz | — | 2025-10-22T04:00:00.000Z | When this snapshot was captured |
| category | string | — | points | Canonical category (points, rebounds, assists, pra, etc.) Values pointsreboundsthree_pointers_madepts_reboundsdouble_doubleassistspts_rebounds_assistsrebounds_assistspts_assiststriple_doubleblockssteals |
| is_opening | boolean | — | false | True if this is the first captured line for this player/market |
| line | decimalnullable | — | 1.5 | Prop line for over/under markets (e.g., 24.5) |
| market_key | string | — | player_points | Raw market key from source API (e.g., player_points) Values player_pointsplayer_reboundsplayer_threesplayer_points_reboundsplayer_double_doubleplayer_assistsplayer_points_rebounds_assistsplayer_rebounds_assistsplayer_points_assistsplayer_triple_doubleplayer_blocksplayer_steals |
| no_odds | integernullable | — | -10000 | American odds for no |
| outcome_type | string | — | ou | ou | yes_no Values ouyes_no |
| over_odds | integernullable | — | -120 | American odds for over |
| period_code | stringnullable | — | — | Optional period code (Q1, 1H) |
| subcategory | stringnullable | — | — | Optional subtype (alternate, boosted, etc.) |
| under_odds | integernullable | — | -110 | American odds for under |
| yes_odds | integernullable | — | 1100 | American odds for yes |
Lineups & Roster
nba.coaching_staffs5 fieldsendpoints →
NBA coaches and staff — head coaches, lead assistants, player-development coaches, and other basketball-operations staff who appear on team benches.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| coach_id | integer | — | 57 | Official NBA coach/staff ID from stats.nba.com |
| first_name | string | — | Mike | — |
| last_name | string | — | Jones | — |
| name | string | — | Stacey Augmon | — |
nba.team_coaching_staffs9 fields· 3 refsendpoints →
The coaching staff each NBA team carries through the season — head coach, assistants, trainers — with the dates each staff member started and ended their tenure.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| coaching_staff_id | bigint | → nba.coaching_staffs | 395 | — |
| season_id | bigint | → nba.seasons | 2025 | First season of this tenure |
| team_id | bigint | → nba.teams | 25 | — |
| coach_type | string | — | Assistant Coach | Head Coach, Assistant Coach, Trainer Values Assistant CoachTrainerHead CoachAssistant Coach for Player DevelopmentAssociate Head CoachAssistant TrainerStrength and Conditioning CoachLead Assistant CoachDirector of Athletic DevelopmentInterim Head Coach |
| end_date | datenullable | — | 2021-10-18 | Tenure end date. NULL = still active. |
| is_assistant | boolean | — | true | — Values truefalse |
| sort_sequence | integernullable | — | 4 | — |
| start_date | date | — | 2025-10-21 | Tenure start date (derived from season start) |
nba.game_team_lineup_stints25 fields· 7 refsendpoints →
Each continuous stretch an NBA team had the same five players on the floor (regular season, play-in, IST, and playoffs — no preseason) — the five-man unit, when it started and ended, and the team's net production while it was in.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nba.games | 127 | — |
| player1_id | bigint | → nba.players | 53 | — |
| player2_id | bigint | → nba.players | 197 | — |
| player3_id | bigint | → nba.players | 187 | — |
| player4_id | bigint | → nba.players | 178 | — |
| player5_id | bigint | → nba.players | 258 | — |
| team_id | bigint | → nba.teams | 12 | — |
| assist_pct | decimal | — | 0.0000 | — |
| defensive_rating | decimal | — | 0.0000 | — |
| defensive_rebound_pct | decimal | — | 1.0000 | — |
| end_clock | integer | — | 0 | — |
| end_event_seq | integer | — | 7200 | — |
| net_rating | decimal | — | 0.0000 | — |
| offensive_rating | decimal | — | 0.0000 | — |
| offensive_rebound_pct | decimal | — | 0.0000 | — |
| pace | decimal | — | 0.0000 | — |
| period | integer | — | 2 | — |
| player_stats | jsonb | — | [object Object],[object Object],[object Object],[object Object],[object Object] | Array of individual player box scores and metrics recorded during this lineup stint. |
| possessions | integer | — | 2 | — |
| pts_allowed | integer | — | 0 | — |
| pts_scored | integer | — | 0 | — |
| start_clock | integer | — | 720 | — |
| start_event_seq | integer | — | 100 | — |
| turnover_pct | decimal | — | 0.0000 | — |
nba.game_team_rosters14 fields· 3 refsendpoints →
The gameday roster for each NBA game — every player available that night, who started, who sat, and who was on a minutes restriction, with the pre-tip snapshot and the reconciled post-game truth side by side.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nba.games | 724 | — |
| player_id | bigint | → nba.players | 197 | — |
| team_id | bigint | → nba.teams | 12 | — |
| comment | stringnullable | — | INACTIVE_GLEAGUE_TWOWAY | — |
| confirmed | booleannullable | — | true | Whether the starter truth was established from post-game evidence |
| injury_status | stringnullable | — | OUT | Reconciled final injury designation for the roster row Values OUTQUESTIONABLEPROBABLEDOUBTFUL |
| position | stringnullable | — | G | — Values GFCG-FF-C |
| pre_game_confirmed | booleannullable | — | true | Pre-tip lineup confidence from source (e.g. RotoWire confirmed vs expected) |
| pre_game_injury_status | stringnullable | — | OUT | Pre-tip injury designation: OUT, DOUBTFUL, QUESTIONABLE, PROBABLE Values OUTQUESTIONABLEPROBABLEDOUBTFUL |
| pre_game_starter | booleannullable | — | false | Pre-tip expected starter flag from lineup sources Values falsetrue |
| pre_game_status | integernullable | — | 1 | Pre-tip roster availability: 1=Active, 2=Inactive, 3=Out |
| starter | booleannullable | — | false | Whether the player was in the starting five (reconciled post-game) Values falsetrue |
| status | integernullable | — | 1 | Reconciled final roster availability: 1=Active, 2=Inactive, 3=Out |
nba.team_depth_charts8 fields· 3 refsendpoints →
Each NBA team's depth chart by position on each date — the starter, second-unit, and bench order at point guard, shooting guard, small forward, power forward, and center, with injury designations layered in.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| player_id | bigint | → nba.players | 337 | — |
| season_id | bigint | → nba.seasons | 2025 | — |
| team_id | bigint | → nba.teams | 4 | — |
| day | integer | — | 20260214 | YYYYMMDD snapshot day |
| depth_rank | integer | — | 1 | 1-based rank within position (1 = starter) |
| injury_status | stringnullable | — | Out | Day-To-Day, Out, etc. from ESPN Values OutDay-To-DaySuspension |
| position | string | — | SF | PG, SG, SF, PF, C Values SFSGPFPGC |
Misc
nba.stadiums19 fieldsendpoints →
NBA arenas — current home venues and historical buildings the league's teams have played in.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| league_stadium_id | integernullable | — | 643 | Official NBA arena ID from stats.nba.com |
| address | stringnullable | — | — | — |
| capacity | integernullable | — | — | — |
| city | string | — | Orlando | — |
| closed_date | timestamptznullable | — | — | — |
| country | stringnullable | — | US | — Values USCAMXGBFRDEAECNJP |
| description | stringnullable | — | Home of the Toronto Raptors. Multi-purpose arena in downtown Toronto, opened 1999. | — |
| elevation | floatnullable | — | 198 | Elevation in feet above sea level |
| image_url | stringnullable | — | — | URL to aerial/overview image of arena |
| latitude | floatnullable | — | 25.7814 | — |
| longitude | floatnullable | — | -80.187 | — |
| name | string | — | Scotiabank Arena | — |
| opened_date | timestamptznullable | — | — | — |
| roof_type | stringnullable | — | — | Arena roof type (all indoor) |
| state | stringnullable | — | FL | — |
| surface | stringnullable | — | — | — |
| team_name | stringnullable | — | — | — |
| timezone | stringnullable | — | America/New_York | IANA timezone (e.g., America/New_York) Values America/New_YorkAmerica/ChicagoAmerica/Los_AngelesAmerica/DenverAmerica/PhoenixAmerica/Mexico_CityAmerica/TorontoAmerica/Indiana/IndianapolisEurope/LondonEurope/ParisEurope/BerlinAsia/DubaiAmerica/Puerto_RicoAmerica/VancouverAsia/ShanghaiPacific/HonoluluAsia/TokyoAmerica/Edmonton |
nba.broadcasters11 fieldsendpoints →
Networks, regional sports networks, and streaming services that air NBA games — ESPN, TNT, ABC, NBA TV, plus team-local RSNs like YES, MSG, and Bally Sports.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| broadcaster_team_id | integer | — | 0 | — |
| region_id | integer | — | 0 | — |
| broadcaster_abbreviation | string | — | BSIN | — |
| broadcaster_description | stringnullable | — | — | — |
| broadcaster_display | string | — | BSIN | — |
| broadcaster_media | string | — | tv | — |
| broadcaster_ranking | integer | — | 0 | — |
| broadcaster_scope | string | — | local | — Values localnational |
| broadcaster_video_link | stringnullable | — | — | — |
| tape_delay_comments | stringnullable | — | — | — |
nba.referees13 fieldsendpoints →
NBA officials — the three-person crew of referees who work each game.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| nba_referee_id | integer | — | 202027 | — |
| active | boolean | — | true | — |
| birth_city | stringnullable | — | — | — |
| birth_country | stringnullable | — | — | — |
| birth_date | datenullable | — | — | — |
| birth_state | stringnullable | — | — | — |
| college | stringnullable | — | — | — |
| experience | integernullable | — | — | — |
| first_name | string | — | Biniam | — |
| full_name | string | — | Biniam Maru | — |
| jersey_number | stringnullable | — | 94 | — |
| last_name | string | — | Maru | — |
nba.operator_team_lookups6 fields· 2 refsendpoints →
How each sportsbook and fantasy operator names every NBA 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 | Reference to main.operator entity |
| operator_team_id | string | — | 2003 | External team ID from operator |
| team_id | bigint | → nba.teams | 11 | Internal nba.teams.id reference |
| abbreviation | stringnullable | — | ATL | Team abbreviation for reconciliation |
| team_name | stringnullable | — | Atlanta Hawks | Team name for reconciliation |
nba.playoffs12 fields· 3 refsendpoints →
The NBA postseason bracket — the play-in tournament, the four conference series rounds, and the NBA Finals, tracked as best-of-seven matchups with seeds, wins, and outcomes.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| away_team_id | bigint | → nba.teams | 13 | — |
| home_team_id | bigint | → nba.teams | 1 | — |
| season_id | bigint | → nba.seasons | 2020 | — |
| series_id | bigint | — | 202001 | — |
| away_team_wins | integer | — | 0 | — |
| games_played | integer | — | 1 | — |
| home_team_wins | integer | — | 4 | — |
| max_games | integer | — | 7 | — |
| series_name | string | — | East First Round | — Values East First RoundWest First RoundEast Play-InWest Play-InEast Conference SemifinalsWest Conference SemifinalsWest Conference FinalsEast Conference FinalsNBA Finals |
| series_text | string | — | MIA won 1-0 | — |
| status | string | — | Completed | — |
nba.game_broadcasters4 fields· 2 refsendpoints →
Which networks broadcast each NBA game — the national TV partner, home and away regional carriers, radio calls, and streaming providers.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| broadcaster_id | bigint | → nba.broadcasters | 10 | — |
| game_id | bigint | → nba.games | 15975 | — |
| broadcaster_type | string | — | awayTv | — Values awayTvhomeTvnationalTv |
nba.game_referees4 fields· 2 refsendpoints →
The officiating crew assigned to each NBA game — the three referees who worked the matchup.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nba.games | 4727 | — |
| referee_id | bigint | → nba.referees | 58 | — |
| position | stringnullable | — | Referee | — Values RefereeCrew ChiefUmpireALTERNATE |
nba.operator_player_lookups9 fields· 2 refsendpoints →
How each sportsbook and fantasy operator names every NBA 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 | 83 | Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo, 13 sportsdata.io, 83 stats.nba.com. |
| operator_player_id | string | — | 76001 | External player ID from operator |
| player_id | bigintnullable | → nba.players | 521 | Internal nba.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 | — | 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. |
| player_name | stringnullable | — | George Johnson | Player name for reconciliation |
| position | stringnullable | — | G | Position for reconciliation Values GFCG-FF-CUnknown |
nba.player_news22 fields· 4 refsendpoints →
News about NBA players — trades, injuries, lineup decisions, suspensions, and general beat-reporter updates.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| external_id | stringnullable | — | rotoql-14973 | Unique identifier from the news provider. |
| game_id | bigintnullable | → nba.games | — | Associated game ID when this news item relates to a specific game. |
| opponent_team_id | bigintnullable | → nba.teams | — | Opponent team ID when this news item relates to an upcoming or active game matchup. |
| player_id | bigintnullable | → nba.players | 165 | Player ID associated with the news report. |
| team_id | bigintnullable | → nba.teams | 16 | Team ID of the player at the time of publication. |
| ai_processed | boolean | — | false | Whether this story was generated or enriched via LLM summarization. |
| analysis | stringnullable | — | Barton had to be helped back to the locker room during the third quarter of Monday's loss to the Ra… | Fantasy and tactical analysis of the news. |
| author | stringnullable | — | — | Reporter or author of the article. |
| category | stringnullable | — | — | injury, transaction, lineup, general |
| content | stringnullable | — | — | Full text content of the news report. |
| description | stringnullable | — | Murray was assigned Sunday to the D-League's Austin Spurs. | 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 | — | 2016-11-27T19:29:13.000Z | Publication timestamp of the news story. |
| priority | integer | — | 3 | Display priority score (1-10). |
| situational_impact | jsonbnullable | — | — | Structured situational impact assessment and fantasy implications for the player. |
| source | stringnullable | — | rotowire | 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). |
| title | string | — | Assigned to D-League | Headline of the news report. |
| urgency | stringnullable | — | — | Urgency level of the news event (BREAKING_GAME_TIME, HIGH, MEDIUM, ROUTINE). |
nba.team_game_contexts20 fields· 4 refsendpoints →
Situational context for each NBA team in each game — how much the game matters (playoff push, tanking, contender mode, In-Season Tournament stakes), what phase of the season it's in, and how far along the schedule the team is.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nba.games | 2374 | — |
| opponent_team_id | bigint | → nba.teams | 9 | — |
| season_id | bigint | → nba.seasons | 2024 | — |
| team_id | bigint | → nba.teams | 9 | — |
| conference_rank | integer | — | 8 | — |
| game_type | string | — | regular | regular, playoff, play_in, ist_group, ist_knockout, preseason, allstar Values regularplayoffist_group |
| games_remaining | integer | — | 0 | — |
| intensity | integer | — | 5 | 1-10 motivation intensity scale |
| is_back_to_back | boolean | — | false | — Values falsetrue |
| is_clinch | boolean | — | false | — Values falsetrue |
| is_elimination | boolean | — | false | — Values falsetrue |
| ist_group_rank | integernullable | — | — | — |
| ist_group_record | stringnullable | — | — | e.g. 2-1 |
| motivation | string | — | play_in | contender, playoff_lock, seeding_battle, playoff_push, play_in, fringe, tanking, eliminated, early_season, playoff_comfortable, playoff_competitive, playoff_desperate, playoff_elimination, playoff_clinch, ist_contending, ist_eliminated, ist_knockout
Values play_infringeearly_seasonseeding_battlecontendertankingplayoff_lockplayoff_competitiveplayoff_comfortableplayoff_desperateplayoff_clinchplayoff_eliminationist_contending |
| rest_days | integer | — | 1 | — |
| season_pct | decimal | — | 1.0000 | 0.0-1.0 how far through regular season |
| season_phase | string | — | mid | early, mid, late, final_push, postseason Values midlateearlyfinal_pushpostseason |
| team_series_wins | integer | — | 0 | — |
| win_pct | decimal | — | 0.5000 | — |
nba.team_news12 fields· 3 refsendpoints →
News and updates about NBA teams — game previews, coaching changes, front-office moves, and beat reports.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| external_id | stringnullable | — | rotoworld:nba-khalifa-diop-20260902T200417 | Canonical external identifier for deduplication. |
| game_id | bigintnullable | → nba.games | — | Associated game ID when news relates to a specific game. |
| opponent_team_id | bigintnullable | → nba.teams | — | Opponent team ID when news relates to an upcoming or completed game matchup. |
| team_id | bigint | → nba.teams | 7 | Team ID that this news event pertains to. |
| ai_processed | booleannullable | — | true | Whether this story was generated or enriched via LLM summarization. |
| category | stringnullable | — | transaction | game_preview, coaching, transaction, general |
| news_time | timestamptz | — | 2026-09-02T20:04:17.734Z | Publication timestamp of the team story. |
| sources | jsonbnullable | — | [object Object] | Source citations with publisher name, URL, author, and published timestamp. |
| summary | string | — | The Cavaliers officially signed 2022 draft pick Khalifa Diop to a four-year, $9.26 million contract… | Concise journalistic summary of the team news event. |
| title | string | — | Cavaliers sign Khalifa Diop to four-year contract after two seasons overseas | Headline of the team news story. |
| urgency | stringnullable | — | ROUTINE | ROUTINE, MEDIUM, HIGH, BREAKING_GAME_TIME |