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 (issued by the league) |
| 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 (issued by the league) |
| 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 | — | 2024-10-16T01:46: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 (issued by the league). Stable across seasons; use it to join other data that carries the league id. |
| 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 the league: "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 (as the league records it). |
| 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 of the player (as in the league 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 | 19 | — |
| 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. Every counting stat and the minutes follow the league's official box score: read at the final whistle, 1 hour later, and each morning for the 3 days after the game. A later correction by the league replaces the value in place (no revision history). A DFS contest's points stay the operator's settled values (see /api/v1/dfs/contests/{contest_id}/download).
| 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 | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| and_ones | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| 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 | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| balls_stolen | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| basket_interference_violations | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| blocks | integer | — | 0 | — |
| box_outs | integernullable | — | 0 | — |
| carrying_palming_violations | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| challenges_requested | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| 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 | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| drives | integernullable | — | 0 | — |
| dunks | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| effective_field_goal_percentage | decimalnullable | — | 0.0000 | — |
| ejections | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| 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.0000 | — |
| fast_break_pts | integernullable | — | — | Fast-break points. Null when the source of the game gives none (most games): never a made-up 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 | — | 19 | — |
| game_date | integer | — | 20251112 | — |
| garbage_time_minutes | decimal | — | 0 | — |
| goaltending_violations | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| hockey_assists | integernullable | — | 0 | — |
| jump_balls_lost | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| jump_balls_won | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| lane_violations | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| layups | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| loose_balls_recovered | integernullable | — | 0 | — |
| minutes | decimal | — | 12.0000 | — |
| minutes_deviation_pct | decimal | — | 0 | — |
| net_rating | decimalnullable | — | 0.0000 | — |
| offensive_fouls | integernullable | — | — | Offensive fouls. A SUBSET of personal_fouls, not an addition to it. Null when the source of the game gives no count (the league's official box has none): never a made-up 0. |
| 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 | — | 21 | — |
| passes_deflected | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| 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 | — | -2 | — |
| 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 | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| 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 | integernullable | — | — | Second-chance points. Null when the source of the game gives none (most games): never a made-up 0. |
| shot_clock_violations | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| shot_contested_count | integernullable | — | 1 | — |
| shots_blocked | integernullable | — | 0 | — |
| start_position | stringnullable | — | G | — Values GFC |
| steals | integer | — | 0 | — |
| substitutions_in | integernullable | — | 3 | Times the player came on the floor: each change of the team's five between two lineup stints of the game (nba/game_team_lineup_stints). The first five of the game, and a period that starts with the same five, count none. Null when the game has no lineup stints. Written by the next morning's load. |
| substitutions_out | integernullable | — | 3 | Times the player went off the floor: each change of the team's five between two lineup stints of the game (nba/game_team_lineup_stints). Null when the game has no lineup stints. Written by the next morning's load. |
| technical_fouls | integernullable | — | — | Technical fouls. The one foul type the NBA keeps OUT of the personal count; 2 means ejection. Null when the source of the game gives no count (the league's official box has none): never a made-up 0. |
| three_point_percentage | decimalnullable | — | 0.0000 | — |
| three_pointers_attempted | integer | — | 0 | — |
| three_pointers_made | integer | — | 0 | — |
| time_of_possession | decimalnullable | — | 0.2000 | — |
| timeouts_called | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| touches | integernullable | — | 26 | — |
| traveling_violations | integernullable | — | — | No source fills this field yet: null, never a made-up 0 (2026-10-26). |
| 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 | — | 18.8000 | — |
| assists | integer | — | 24 | — |
| assists_to_turnovers | decimal | — | 2.0000 | — |
| bench_pts | integer | — | 34 | — |
| blocks | integer | — | 4 | — |
| conference_rank | integer | — | 10 | 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 | — | 1 | — |
| losses | integer | — | 3 | 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.6670 | — |
| pct_fga_3pt | decimal | — | 0.3330 | — |
| pct_pts_2pt | decimal | — | 0.5000 | — |
| pct_pts_2pt_mr | decimal | — | 0.0000 | — |
| pct_pts_3pt | decimal | — | 0.3330 | — |
| pct_pts_fb | decimal | — | 0.0960 | — |
| pct_pts_ft | decimal | — | 0.1670 | — |
| pct_pts_off_tov | decimal | — | 0.1430 | — |
| pct_pts_paint | decimal | — | 0.4000 | — |
| pct_uast_2pm | decimal | — | 0.5000 | — |
| pct_uast_3pm | decimal | — | 0.0000 | — |
| pct_uast_fgm | decimal | — | 0.3330 | — |
| player_impact_estimate | decimal | — | 0.4620 | — |
| 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 | — | 12 | — |
| 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.1172 | — |
| turnovers | integer | — | 13 | — |
| win | integer | — | 0 | — |
| wins | integer | — | 1 | 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 | 176 | — |
| 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 | — | 0.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 | — | 0 | — |
| 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.0000 | — |
| touches | integer | — | 0 | — |
| 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 | — |
Projections
nba.projected_player_stats37 fields· 3 refsendpoints →
Our projection of each NBA player in each game before tip — the chance to play and to start, minutes with their range, usage rate, points, rebounds, assists, steals, blocks, threes and turnovers, the common combos, and double-double and triple-double chances. One current row per game, player and engine version, the same stat line for every DFS operator; it updates until tip 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, and GET /api/v1/dfs/contests/{contest_id}/projections adds the contest's projected ownership.
| Field | Type | References | Example | Description |
|---|---|---|---|---|
| idkey | bigint | — | — | Primary Key |
| game_id | bigint | → nba.games | 6029937 | — |
| player_id | bigint | → nba.players | 221 | — |
| projection_id | bigint | — | 3 | Engine version id (main.projections; STAT_API_NBA 2.2, the NFL engine's version). |
| team_id | bigint | → nba.teams | 17 | — |
| ast | float | — | 0 | Projected assists (mean). |
| blk | float | — | 0 | Projected blocks (mean). |
| double_double_probability | float | — | 0 | Chance of a double-double, 0 to 1. |
| expected_starter | booleannullable | — | false | True when the player was in the expected starting lineup when the projection ran; null when no lineup was known. Values falsetrue |
| fg3m | float | — | 0 | Projected three-pointers made (mean). |
| inputs_as_of | timestamptz | — | 2026-01-31T00:29:59.999Z | Time of the newest input the projection used (UTC). Always before the game's tip. |
| lineup_confirmed | booleannullable | — | true | True when that starting lineup was confirmed; null when no lineup was known. |
| minutes_mean | float | — | 0 | Projected minutes (mean). |
| minutes_p10 | float | — | 0 | Projected minutes, 10th percentile. |
| minutes_p25 | float | — | 0 | Projected minutes, 25th percentile. |
| minutes_p50 | float | — | 0 | Projected minutes, median. |
| minutes_p75 | float | — | 0 | Projected minutes, 75th percentile. |
| minutes_p90 | float | — | 0 | Projected minutes, 90th percentile. |
| minutes_std | float | — | 0 | Standard deviation of the projected minutes. |
| play_probability | float | — | 1 | Chance the player plays, 0 to 1. |
| position | stringnullable | — | G | The player's position as the roster service gave it for this game. Values GFCG-FF-C |
| pra | float | — | 0 | Projected points + rebounds + assists (mean). |
| pts | float | — | 0 | Projected points (mean). |
| pts_ast | float | — | 0 | Projected points + assists (mean). |
| pts_reb | float | — | 0 | Projected points + rebounds (mean). |
| reb | float | — | 0 | Projected rebounds (mean). |
| reb_ast | float | — | 0 | Projected rebounds + assists (mean). |
| start_probability | float | — | 0 | Chance the player starts, 0 to 1. |
| stat_quantiles | jsonb | — | [object Object] | The 10th percentile, median and 90th percentile of each projected stat, keyed by stat name (pts, reb, ast, stl, blk, fg3m, tov), each an object of p10, p50 and p90. |
| status | stringnullable | — | available | The player's status for this game when the projection ran, the newest change before tip from any source (the official injury report, the league's inactive list, DraftKings, FanDuel or a media report); null when no source gave one. Values availableoutquestionableprobable |
| status_source | stringnullable | — | fanduel | Which source gave the status: an operator (draftkings, fanduel), a media report (media), or the league: league_report (the official injury report) or league_inactive_list (the league's inactive list). Values fandueldraftkingsleague_reportmedia |
| stl | float | — | 0 | Projected steals (mean). |
| stocks | float | — | 0 | Projected steals + blocks (mean). |
| tov | float | — | 0 | Projected turnovers (mean). |
| triple_double_probability | float | — | 0 | Chance of a triple-double, 0 to 1. |
| usage_rate | float | — | 0 | Projected usage rate (USG%) while on the floor — the player's share of the possessions his team uses (field-goal attempts + 0.44 × free-throw attempts + turnovers), scaled to five players on the floor. It sets his share of the team's projected points; 0 when he does not play. |
| zero_reason | stringnullable | — | out | Why the player projects 0 minutes (ruled out, inactive, not on the roster); null for a player who may play. |
nba.projected_team_stats33 fields· 3 refsendpoints →
Our projection of each NBA team in each game before tip — possessions and pace, total points with their range, win and overtime chances, team stat totals, and the betting lines the projection used. One current row per game, team and engine version; it updates until tip 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 | → nba.games | 6029936 | — |
| opponent_team_id | bigint | → nba.teams | 24 | The team this team plays in the game. |
| projection_id | bigint | — | 3 | Engine version id (main.projections; STAT_API_NBA 2.2, the NFL engine's version). |
| team_id | bigint | → nba.teams | 24 | — |
| ast_mean | float | — | 26.193 | Projected team assists. |
| blk_mean | float | — | 4.514 | Projected team blocks. |
| fg3m_mean | float | — | 13.099 | Projected team three-pointers made. |
| implied_team_total | floatnullable | — | 115.5 | This team's implied points from the betting total and spread; null when no line was captured. |
| inputs_as_of | timestamptz | — | 2025-04-13T19:29:59.999Z | Time of the newest input the projection used (UTC). Always before the game's tip. |
| is_home | boolean | — | true | True when this team is the home team. Values truefalse |
| lines_captured_at | timestamptznullable | — | 2024-11-04T05:00:00.000Z | When the betting lines the projection used were captured (UTC). |
| offensive_rating | float | — | 113.57116578410486 | Projected points per 100 possessions. |
| opponent_points_mean | float | — | 115.5 | Projected points the opponent scores (mean). |
| overtime_probability | float | — | 0.056 | Chance the game goes to overtime, 0 to 1. |
| pace_per_48 | float | — | 95.80466291019982 | Projected pace — possessions per 48 minutes. |
| possessions_mean | float | — | 96.42541443256545 | Projected possessions of the game (mean). |
| possessions_p10 | float | — | 90.95248584451933 | Projected possessions, 10th percentile. |
| possessions_p50 | float | — | 95.89911660868471 | Projected possessions, median. |
| possessions_p90 | float | — | 102.29353326932566 | Projected possessions, 90th percentile. |
| reb_mean | float | — | 44.12 | Projected team rebounds (the sum of its players' projected rebounds). |
| stl_mean | float | — | 7.564 | Projected team steals. |
| team_points_mean | float | — | 115.5 | Projected points this team scores (mean) — the team's total output. |
| team_points_p10 | float | — | 101 | This team's projected points, 10th percentile. |
| team_points_p25 | float | — | 107 | This team's projected points, 25th percentile. |
| team_points_p50 | float | — | 114 | This team's projected points, median. |
| team_points_p75 | float | — | 123 | This team's projected points, 75th percentile. |
| team_points_p90 | float | — | 130 | This team's projected points, 90th percentile. |
| team_points_std | float | — | 11.765627905046122 | Standard deviation of this team's projected points. |
| tov_mean | float | — | 13.687 | Projected team turnovers. |
| vegas_spread | floatnullable | — | 3.5 | Betting spread from this team's side that the projection used; null when no line was captured. |
| vegas_total | floatnullable | — | 227.5 | Betting game total the projection used; null when no line was captured before the projection. |
| win_probability | float | — | 0.613 | Chance this team wins, 0 to 1 (0.62 = 62%). |
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 | — | -110 | 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 | — | -110 | 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 (issued by the league) |
| 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 | 96 | — |
| season_id | bigint | → nba.seasons | 2026 | First season of this tenure |
| team_id | bigint | → nba.teams | 26 | — |
| coach_type | string | — | Assistant Coach | Head Coach, Assistant Coach, Trainer Values Assistant CoachHead CoachTrainerAssistant Coach for Player DevelopmentAssociate Head CoachLead Assistant CoachAssistant TrainerStrength and Conditioning 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 | 57 | — |
| player2_id | bigint | → nba.players | 197 | — |
| player3_id | bigint | → nba.players | 187 | — |
| player4_id | bigint | → nba.players | 294 | — |
| 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 | — | 1 | — |
| 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_rosters12 fields· 3 refsendpoints →
The gameday roster for each NBA game — every player of each team, with the player's status, injury designation, starting role and depth-chart slot. mode=pre (the default) shows each value as it stood at tip for that game; mode=full shows the post-game values. The depth-chart slot is the one at tip in both modes.
| 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 | mode=pre: the reason on the league's injury report for this game, as published before tip. mode=full: the note of the post-game roster. |
| confirmed | booleannullable | — | true | mode=pre: the team's starting lineup was confirmed before tip (null when no lineup was known). mode=full: the starter value comes from post-game evidence. |
| depth_order | integernullable | — | — | Depth-chart rank at depth_position for this game (1 = first at the position, 2 = second, etc.), as the team's depth chart stood at tip; the same in mode=pre and mode=full. From the depth chart published before tip; for a game without one, from a chart built from the team's previous games. Null when the chart leaves the player out or the team has no chart for the game. |
| depth_position | stringnullable | — | — | Position slot of depth_order on the depth chart for this game (PG, SG, SF, PF, C). A player listed at two positions shows the one where his rank is better; on a tie, the first in PG, SG, SF, PF, C order. |
| injury_status | stringnullable | — | OUT | OUT, DOUBTFUL, QUESTIONABLE or PROBABLE. mode=pre: the designation that stood at tip for this game (null when available or unknown). mode=full: the post-game value. Values OUTQUESTIONABLEPROBABLEDOUBTFUL |
| position | stringnullable | — | G | — Values GFCG-FF-C |
| starter | booleannullable | — | false | mode=pre: in the starting lineup known before tip (null when no lineup was known). mode=full: started the game. Values falsetrue |
| status | integernullable | — | 1 | Roster availability: 1=Active, 2=Inactive, 3=Out. mode=pre: as it stood at tip for this game (3 when ruled out, 1 for any other designation, null when nothing was known before tip). mode=full: the post-game value. |
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 | 428 | — |
| 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 | Injury designation (Day-To-Day, Out, etc.) 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 (issued by the league) |
| address | stringnullable | — | — | — |
| capacity | integernullable | — | — | — |
| city | string | — | Orlando | — |
| closed_date | timestamptznullable | — | — | — |
| country | stringnullable | — | — | — Values USGBFRDEAEJPCAMX |
| 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/EdmontonAmerica/Montreal |
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 | — | Scott | — |
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; every id is listed at /api/v1/reference/operators. |
| 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_news18 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 |
| 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. |
| 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. |
| 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_news10 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 |
| 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. |
| 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 |