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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
end_datetimestamptznullable2021-07-20T00:00:00.000Z
post_season_start_datetimestamptznullable2021-05-22T00:00:00.000Z
regular_season_start_datetimestamptznullable2020-12-22T00:00:00.000Z
start_datetimestamptz2020-12-22T00:00:00.000Z
start_yearinteger2020
nba.teams10 fields· 2 refsendpoints →

The 30 NBA franchises, organized into the Eastern and Western Conferences with three divisions in each.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
league_team_idintegernullablenba.teams1610612738Official NBA team ID from stats.nba.com
stadium_idbigintnullablenba.stadiums
abbreviationstringBOS
activebooleantrue
citystringLos Angeles
conferencestringEastern
ValuesEasternWesternTest Conference
divisionstringAtlantic
ValuesAtlanticCentralSoutheastNorthwestPacificSouthwestTest Division
full_namestringBoston Celtics
namestringCeltics
nba.games28 fields· 5 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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
away_team_idbigintnba.teams1
home_team_idbigintnba.teams1
league_game_idstringnullablenba.games0022500650Official NBA game ID from stats.nba.com
season_idbigintnba.seasons2023
stadium_idintegernullablenba.stadiums19
attendanceintegernullable19156
away_rotation_numberintegernullable
away_teamstringBOS
away_team_scoreinteger113
channelstringnullableNBA TV
dayinteger20250413
end_timetimestamptznullable2022-11-07T07:12:00.000Z
game_labelstringnullable
game_sub_labelstringnullable
game_timetimestamptz2025-04-13T19:30:00.000Z
home_rotation_numberintegernullable
home_teamstringBOS
home_team_scoreinteger112
if_necessarybooleannullable
neutral_venuebooleanfalse
postponed_statusstringnullable
season_typestringregular_season
Valuesregular_seasonpostseasonpreseasonplay_inin_season_tournament
series_game_numberstringnullable
series_namestringnullable
series_textstringnullable
start_timetimestamptz2025-04-13T19:30:00.000Z
statusstringFinal
nba.players40 fields· 2 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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
league_player_idintegernba.players203999Official NBA player ID from stats.nba.com. Stable across seasons; use for cross-API joins to nba_stats sources.
team_idbigintnullablenba.teams12FK to nba.teams. Null for free agents and retired players.
birth_citystringnullableSomborCity of birth.
birth_countrystringnullableSerbiaCountry of birth (ISO English name).
birth_datedatenullable1995-02-19Birth date in YYYY-MM-DD form.
birth_statestringnullableState / province of birth (US/Canadian players).
display_fi_laststringnullableN. JokićDisplay name in "F. Last" form.
display_last_comma_firststringnullableJokić, NikolaDisplay name in "Last, First" form. Useful for sorted lists.
dleague_flagstringnullable00Two-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_numberstringnullable41Overall pick number within the draft (string). Empty for undrafted.
draft_roundstringnullable2Draft round (string). Empty for undrafted players.
draft_yearstringnullable2014Year the player was drafted (string form). Empty for undrafted players.
experienceintegernullable10Years of NBA experience as of the most recent season. Rookies = 0.
first_namestringNikolaPlayer's legal first name as registered with the league.
from_yearstringnullable2015Player's NBA debut year as a string (per stats.nba.com).
full_namestringNikola JokićConvenience concatenation of first_name + last_name. Use this for display.
full_position_liststringnullableGuard-ForwardHyphenated full-word position list (e.g., "Guard-Forward", "Center-Forward").
ValuesGuardForwardCenterGuard-ForwardForward-CenterCenter-ForwardForward-Guard
games_played_flagstringnullableYString "Y"/"N" indicating whether the player has played at least one regular-season game.
ValuesYN
heightintegernullable83Height in inches.
injury_body_partstringnullableAffected body part for the most recent injury (e.g., "Knee", "Ankle"). Null when injury_status is null.
Valuesanklekneeillnesshiptoebackwristfootcalfhamstringpelvisabdomenheelrestachillesthumbhand
injury_detailstringnullableFree-text injury description from the source feed.
injury_sincetimestamptznullable2026-04-12T18:30:00ZTimestamp of the injury status snapshot. Updated when player_news produces a new injury entry.
injury_statusstringnullableOUTCurrent injury status snapshot derived from player_news. Values: "OUT", "QUESTIONABLE"; null = no active injury designation (healthy).
ValuesOUTQUESTIONABLE
jerseystringnullable15Current jersey number as a string (some leagues allow leading zeros, e.g., "00").
last_affiliationstringnullableMega Basket / SerbiaMost recent pre-NBA affiliation (school, league, or team).
last_namestringJokićPlayer's legal last name.
league_slugstringnullablenikola-jokicNBA-issued URL slug (e.g., for stats.nba.com player page).
nba_flagstringnullableYString "Y"/"N" indicating NBA experience. Almost always "Y" in this table.
playercodestringnullablejokic_nikolaNBA-issued player code (lastname_firstname format).
position_categorystringnullableCenterCoarse positional grouping. One of Guard, Forward, Center, Utility.
ValuesGuardForwardCenterUtility
primary_positionstringCPrimary position. One of G, F, C, G-F, F-C. (True PG/SG/SF/PF splits live in team_depth_charts.position.)
ValuesGFCG-FF-CUnknown
roster_statusstringnullableactiveCanonical 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}.
schoolstringnullableMega BasketLast school attended before the NBA (college, prep, or international club).
team_abbreviationstringnullableDENCurrent team's tri-letter code.
team_citystringnullableDenverCurrent team's city name.
team_codestringnullablenuggetsCurrent team's lowercase URL slug.
team_namestringnullableNuggetsCurrent team's mascot name (denormalized from teams.name for read convenience).
to_yearstringnullable2025Player's most recent NBA season year. Equal to from_year for rookies.
weightintegernullable284Listed 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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintnba.games2357
team_idbigintnullablenba.teams19
astinteger0
away_scoreinteger38
blkinteger0
cum_away_possinteger13
cum_home_possinteger75
drebinteger0
end_clockintegernullable0
end_nba_event_numinteger7
fg3ainteger0
fg3minteger0
fgainteger1
fgminteger0
ftainteger0
ftminteger0
game_seconds_elapsedinteger720
home_scoreinteger82
orebinteger0
periodinteger1
pfinteger0
ptsinteger0
start_clockinteger720
start_nba_event_numinteger4
stlinteger0
time_actual_endtimestamptznullable2024-10-30T02:08:06.000Z
time_actual_starttimestamptznullable2024-10-28T23:53:48.400Z
tovinteger0
nba.play_by_plays21 fields· 5 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).

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintnba.games2377
game_possession_idbigint16457458
play_idstring0052400111_2
player_idbigintnullablenba.players49
player2_idbigintnullable49
player2_team_idbigintnullablenba.teams21
player3_idbigintnullable227
player3_team_idbigintnullablenba.teams21
team_idbigintnullablenba.teams21
end_clockintegernullable
event_seqinteger100
event_sub_typeinteger0
event_typeinteger8
home_descriptionstring
nba_event_numinteger2
neutral_descriptionstring
possession_seqinteger142
start_clockinteger720
time_actualtimestamptznullable2025-04-17T01:56:41.900Z
visitor_descriptionstring

Stats

nba.operator_team_lookups6 fields· 3 refsendpoints →

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

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
operator_idbigintmain.operators1Reference to main.operator entity
operator_team_idstringnba.teams2003External team ID from operator
team_idbigintnba.teams11Internal nba.teams.id reference
abbreviationstringnullableATLTeam abbreviation for reconciliation
team_namestringnullableAtlanta HawksTeam name for reconciliation
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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
season_idbigintnba.seasons2024
team_idbigintnba.teams11
games_playedinteger82
lossesinteger32
pts_allowedinteger0
pts_scoredinteger9372
tiesinteger0
winsinteger48
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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
season_idbigintnba.seasons2024
team_idbigintnba.teams1
away_lossesinteger6
away_winsinteger1
conference_gbdecimal0.0000Games back from conference leader
conference_rankinteger81-15 within conference
dayinteger20241103YYYYMMDD — standings as of this date (before games on this day)
division_rankinteger11-5 within division
games_playedinteger1
games_remaininginteger81
home_lossesinteger4
home_winsinteger1
l10_lossesinteger4
l10_winsinteger6
lossesinteger1
playin_gbdecimal0.0000Games back from 10th seed (play-in cutoff)
playoff_gbdecimal0.0000Games back from 6th seed (auto-qualify cutoff)
streakinteger-1Positive = win streak, negative = loss streak
win_pctdecimal0.5000
winsinteger2
nba.game_player_stats116 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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintnba.games122
player_idbigintnba.players75
team_idbigintnba.teams17
abnormal_exit_clockinteger0
abnormal_exit_periodinteger0
alley_oopsinteger0
and_onesinteger0
assist_percentagedecimalnullable0.0000
assist_ratiodecimalnullable0.0000
assist_to_turnoverdecimalnullable0.0000
assistsinteger0
avg_dribbles_per_touchdecimalnullable0.0000
avg_seconds_per_touchdecimalnullable0.0000
backcourt_violationsinteger0
balls_stolenintegernullable0
basket_interference_violationsinteger0
blocksinteger0
box_outsintegernullable0
carrying_palming_violationsinteger0
challenges_requestedinteger0
charges_takenintegernullable0
clear_path_foulsinteger0
commentstringnullable
competitive_minutesdecimal0.0
contestsintegernullable1
defensive_ratingdecimalnullable100.0000
defensive_rebound_percentagedecimalnullable0.0000
defensive_reboundsinteger1
deflectionsintegernullable1
double_doublesinteger0
double_dribble_violationsinteger0
drivesintegernullable0
dunksinteger0
effective_field_goal_percentagedecimalnullable0.0000
ejectionsinteger0
elbow_touchesintegernullable0
estimated_defensive_ratingdecimalnullable100.0000
estimated_net_ratingdecimalnullable0.0000
estimated_offensive_ratingdecimalnullable100.0000
estimated_pacedecimalnullable84.7100
estimated_usage_percentagedecimalnullable0.1670
fast_break_ptsinteger0
field_goal_percentagedecimalnullable0.0000
field_goals_attemptedinteger5
field_goals_madeinteger1
flagrant_fouls_type_1integer0
flagrant_fouls_type_2integer0
foul_trouble_severityinteger0
foulsinteger1
fouls_drawninteger0
free_throw_percentagedecimalnullable0.0000
free_throws_attemptedinteger0
free_throws_madeinteger0
front_court_touchesintegernullable14
game_dateinteger20251112
garbage_time_minutesdecimal0
goaltending_violationsinteger0
hockey_assistsintegernullable0
jump_balls_lostinteger0
jump_balls_woninteger0
lane_violationsinteger0
layupsinteger0
loose_balls_recoveredintegernullable0
minutesdecimal31.7000
minutes_deviation_pctdecimal0
net_ratingdecimalnullable0.0000
offensive_foulsinteger0
offensive_ratingdecimalnullable100.0000
offensive_rebound_percentagedecimalnullable0.0000
offensive_reboundsinteger0
paint_touchesintegernullable0
pass_percentagedecimalnullable0.0000
passesintegernullable18
passes_deflectedintegernullable0
personal_foulsinteger1
player_impact_estimatedecimal0.0000
plus_minusinteger0
possessionsinteger53
post_touchesintegernullable0
potential_assistsintegernullable0
ptsinteger0
pts_per_elbow_touchdecimalnullable
pts_per_paint_touchdecimalnullable
pts_per_post_touchdecimalnullable
pts_per_touchdecimalnullable0.0000
put_backsinteger0
rebound_percentagedecimalnullable0.0000
reboundsinteger2
role_anomalous_gamebooleanfalse
Valuesfalsetrue
role_archetypestringnullabledeep_bench
Valuesdeep_benchco_starcore_starterrotationend_of_benchalphasixth_mantwo_way
role_archetype_confidencedecimal0.6
rotation_contextstringnullablenormal
Valuesnormalgarbage_time_boostambiguous_anomalyblowout_restfoul_troublefoul_outinjury_exitdnp_coach
rotation_context_confidencedecimal0.5
screen_assistsintegernullable0
second_chance_ptsinteger0
shot_clock_violationsinteger0
shot_contested_countintegernullable1
shots_blockedintegernullable0
start_positionstringnullableG
ValuesGFC
stealsinteger0
substitutions_ininteger0
substitutions_outinteger0
technical_foulsinteger0
three_point_percentagedecimalnullable0.0000
three_pointers_attemptedinteger0
three_pointers_madeinteger0
time_of_possessiondecimalnullable0.2000
timeouts_calledinteger0
touchesintegernullable28
traveling_violationsinteger0
triple_doublesinteger0
true_shooting_percentagedecimalnullable0.0000
turnover_ratiodecimalnullable0.0000
turnoversinteger0
usage_percentagedecimalnullable0.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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintnba.games6
team_idbigintnba.teams12
assist_percentagedecimal0.6670
assist_ratiodecimal0.0000
assistsinteger24
assists_to_turnoversdecimal2.0000
bench_ptsinteger34
blocksinteger4
conference_rankinteger0Conference rank entering game
defensive_ratingdecimal100.0000
defensive_rebound_percentagedecimal0.6670
defensive_reboundsinteger32
effective_field_goal_percentagedecimal0.5000
estimated_defensive_ratingdecimal0.0000
estimated_net_ratingdecimal0.0000
estimated_offensive_ratingdecimal0.0000
estimated_pacedecimal0.0000
fast_break_ptsinteger11
field_goal_percentagedecimal0.5000
field_goals_attemptedinteger88
field_goals_madeinteger42
foulsinteger19
free_throw_attempt_ratedecimal0.2500
free_throw_percentagedecimal0.7500
free_throws_attemptedinteger21
free_throws_madeinteger17
lossinteger0
lossesinteger0Cumulative losses
minutesinteger48
net_ratingdecimal2.0000
offensive_ratingdecimal100.0000
offensive_rebound_percentagedecimal0.3330
offensive_reboundsinteger10
pacedecimal101.0000
pace_per40decimal0.0000
pct_ast_2pmdecimal0.5000
pct_ast_3pmdecimal1.0000
pct_ast_fgmdecimal0.6670
pct_fga_2ptdecimal0.0000
pct_fga_3ptdecimal0.0000
pct_pts_2ptdecimal0.5000
pct_pts_2pt_mrdecimal0.0000
pct_pts_3ptdecimal0.0000
pct_pts_fbdecimal0.0000
pct_pts_ftdecimal0.0000
pct_pts_off_tovdecimal0.0000
pct_pts_paintdecimal0.0000
pct_uast_2pmdecimal0.5000
pct_uast_3pmdecimal0.0000
pct_uast_fgmdecimal0.3330
player_impact_estimatedecimal0.0000
possessionsinteger101
ptsinteger113
pts_in_paintinteger50
pts_off_turnoversinteger17
rebound_percentagedecimal0.5000
reboundsinteger42
second_chance_ptsinteger14
stealsinteger7
steals_to_turnoversdecimal0.5000
three_point_percentagedecimal0.3330
three_pointers_attemptedinteger34
three_pointers_madeinteger12
timeouts_remaininginteger0
true_shooting_percentagedecimal0.5760
turnover_percentagedecimal0.0000
turnoversinteger13
wininteger0
winsinteger0Cumulative wins
nba.operator_player_lookups6 fields· 3 refsendpoints →

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

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
operator_idbigintmain.operators83Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo, 13 sportsdata.io, 83 stats.nba.com.
operator_player_idstringnba.players76001External player ID from operator
player_idbigintnba.players521Internal nba.players.id reference
player_namestringnullableGeorge JohnsonPlayer name for reconciliation
positionstringnullableGPosition for reconciliation
ValuesGFCG-FF-CUnknown
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).

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
player_idbigintnba.players1
season_idbigintnba.seasons2021
assist_percentagedecimal0.0000
assist_ratiodecimal0.0000
assist_to_turnoverdecimal0.0000
assistsinteger0
avg_dribbles_per_touchdecimal0.0000
avg_seconds_per_touchdecimal0.0000
blocksinteger0
defensive_ratingdecimal100.0000
defensive_rebound_percentagedecimal0.0000
defensive_reboundsinteger2
double_doublesinteger0
effective_field_goal_percentagedecimal0.5000
field_goal_percentagedecimal0.5000
field_goals_attemptedinteger6
field_goals_madeinteger1
foulsinteger0
free_throw_percentagedecimal0.0000
free_throws_attemptedinteger0
free_throws_madeinteger0
front_court_touchesinteger0
games_playedinteger1
lossesinteger0
minutesdecimal5.3000
net_ratingdecimal2.7000
offensive_ratingdecimal112.5000
offensive_rebound_percentagedecimal0.0000
offensive_reboundsinteger0
pacedecimal100.0000
player_impact_estimatedecimal0.0670
plus_minusinteger5
possessionsinteger43
ptsinteger0
rebound_percentagedecimal0.0000
reboundsinteger2
stealsinteger0
three_point_percentagedecimal0.0000
three_pointers_attemptedinteger0
three_pointers_madeinteger0
time_of_possessiondecimal0.0000
touchesinteger0
triple_doublesinteger0
true_shooting_percentagedecimal0.0000
turnover_percentagedecimal0.0000
turnoversinteger0
usage_percentagedecimal0.1670
winsinteger1

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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintnba.games16082
operator_idbigintmain.operators6Sportsbook 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_idbigintnba.seasons2021Denormalized for efficient season-level queries
captured_attimestamptz2022-04-10T00:00:00.000ZWhen this snapshot was captured
implied_away_scoredecimalnullable109.0000
implied_away_win_pctdecimalnullable0.4082
implied_home_scoredecimalnullable109.7500Calculated from spread + total
implied_home_win_pctdecimalnullable0.6296From moneyline, 0-1
is_openingbooleanfalseTrue if this is the opening line
Valuesfalsetrue
moneyline_awayintegernullable145American odds for away team win
moneyline_bet_pct_awayintegernullable
moneyline_bet_pct_homeintegernullable
moneyline_homeintegernullable-170American odds for home team win
moneyline_money_pct_awayintegernullable
moneyline_money_pct_homeintegernullable
over_oddsintegernullable0American odds for over
spreaddecimalnullable-2.5000Home team spread (e.g., -3.5 means home favored by 3.5)
spread_away_oddsintegernullable-110American odds for away spread
spread_bet_pct_awayintegernullable
spread_bet_pct_homeintegernullable
spread_home_oddsintegernullable-110American odds for home spread (e.g., -110)
spread_money_pct_awayintegernullable
spread_money_pct_homeintegernullable
totaldecimalnullable225.5000Combined score total line (e.g., 224.5)
total_bet_pct_overintegernullable
total_bet_pct_underintegernullable
total_money_pct_overintegernullable
total_money_pct_underintegernullable
under_oddsintegernullable0American 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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintnba.games769
operator_idbigintmain.operators6Data source (consensus, DraftKings, FanDuel, etc.)
season_idbigintnba.seasons2025Denormalized for efficient season-level queries
captured_attimestamptz2024-01-05T05:00:00.000ZWhen this snapshot was captured
implied_away_win_pctdecimalnullable0.5121951219512195
implied_home_win_pctdecimalnullable0.5121951219512195From moneyline, 0-1
is_openingbooleanfalseTrue if this is the first captured line for this period
moneyline_awayintegernullable-105American odds for away team win in this period
moneyline_homeintegernullable-105American odds for home team win in this period
over_oddsintegernullable-110American odds for over
period_codestring1HMarket period code (1H, 2H, Q1, Q2, Q3, Q4)
Values1HQ1Q3Q4Q22H
spreaddecimalnullable-0.5Home team spread for this period
spread_away_oddsintegernullable-110American odds for away spread
spread_home_oddsintegernullable-110American odds for home spread (e.g., -110)
totaldecimalnullable57.5Combined score total line for this period
under_oddsintegernullable-110American 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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintnba.games126
operator_idbigintmain.operators6Usually consensus
player_idbigintnba.players157
season_idbigintnba.seasons2025Denormalized for efficient season-level queries
book_countinteger3Number of curated books contributing to this consensus value
captured_attimestamptz2025-10-22T04:00:00.000ZWhen this snapshot was captured
categorystringpointsCanonical category (points, rebounds, assists, pra, etc.)
Valuespointsreboundsthree_pointers_madepts_reboundsdouble_doubleassistspts_rebounds_assistsrebounds_assistspts_assiststriple_doubleblockssteals
is_openingbooleanfalseTrue if this is the first captured line for this player/market
linedecimalnullable1.5Prop line for over/under markets (e.g., 24.5)
market_keystringplayer_pointsRaw market key from source API (e.g., player_points)
Valuesplayer_pointsplayer_reboundsplayer_threesplayer_points_reboundsplayer_double_doubleplayer_assistsplayer_points_rebounds_assistsplayer_rebounds_assistsplayer_points_assistsplayer_triple_doubleplayer_blocksplayer_steals
no_oddsintegernullable-10000American odds for no
outcome_typestringouou | yes_no
Valuesouyes_no
over_oddsintegernullable-120American odds for over
period_codestringnullableOptional period code (Q1, 1H)
subcategorystringnullableOptional subtype (alternate, boosted, etc.)
under_oddsintegernullable-110American odds for under
yes_oddsintegernullable1100American 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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
coach_idinteger57Official NBA coach/staff ID from stats.nba.com
first_namestringMike
last_namestringJones
namestringStacey Augmon
nba.team_coaching_staffs9 fields· 2 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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
coaching_staff_idbigint346
season_idbigintnba.seasons2025First season of this tenure
team_idbigintnba.teams8
coach_typestringAssistant CoachHead Coach, Assistant Coach, Trainer
ValuesAssistant CoachHead CoachTrainerAssistant Coach for Player DevelopmentAssociate Head CoachAssistant TrainerStrength and Conditioning CoachLead Assistant CoachDirector of Athletic DevelopmentInterim Head Coach
end_datedatenullable2021-10-18T04:00:00.000ZTenure end date. NULL = still active.
is_assistantbooleantrue
Valuestruefalse
sort_sequenceintegernullable4
start_datedate2025-10-21T04:00:00.000ZTenure start date (derived from season start)
nba.game_team_lineup_stints25 fields· 2 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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintnba.games127
player1_idbigint53
player2_idbigint197
player3_idbigint187
player4_idbigint178
player5_idbigint258
team_idbigintnba.teams12
assist_pctdecimal0.0000
defensive_ratingdecimal0.0000
defensive_rebound_pctdecimal1.0000
end_clockinteger0
end_event_seqinteger7200
net_ratingdecimal0.0000
offensive_ratingdecimal0.0000
offensive_rebound_pctdecimal0.0000
pacedecimal0.0000
periodinteger2
player_statsjsonb[object Object],[object Object],[object Object],[object Object],[object Object]
possessionsinteger2
pts_allowedinteger0
pts_scoredinteger0
start_clockinteger720
start_event_seqinteger100
turnover_pctdecimal0.0000
nba.game_team_rosters15 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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintnba.games724
player_idbigintnba.players197
team_idbigintnba.teams12
commentstringnullableINACTIVE_GLEAGUE_TWOWAY
confirmedbooleannullabletrueWhether the starter truth was established from post-game evidence
dayinteger20260207
injury_statusstringnullableOUTReconciled final injury designation for the roster row
ValuesOUTQUESTIONABLEPROBABLEDOUBTFUL
positionstringnullableG
ValuesGFCG-FF-C
pre_game_confirmedbooleannullabletruePre-tip lineup confidence from source (e.g. RotoWire confirmed vs expected)
pre_game_injury_statusstringnullableOUTPre-tip injury designation: OUT, DOUBTFUL, QUESTIONABLE, PROBABLE
ValuesOUTQUESTIONABLEPROBABLEDOUBTFUL
pre_game_starterbooleannullablefalsePre-tip expected starter flag from lineup sources
Valuesfalsetrue
pre_game_statusintegernullable1Pre-tip roster availability: 1=Active, 2=Inactive, 3=Out
starterbooleannullablefalseWhether the player was in the starting five (reconciled post-game)
Valuesfalsetrue
statusintegernullable1Reconciled 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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
player_idbigintnba.players337
season_idbigintnba.seasons2025
team_idbigintnba.teams4
dayinteger20260214YYYYMMDD snapshot day
depth_rankinteger11-based rank within position (1 = starter)
injury_statusstringnullableOutDay-To-Day, Out, etc. from ESPN
ValuesOutDay-To-DaySuspension
positionstringSFPG, SG, SF, PF, C
ValuesSFSGPFPGC

Misc

nba.stadiums19 fields· 1 refsendpoints →

NBA arenas — current home venues and historical buildings the league's teams have played in.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
league_stadium_idintegernullablenba.stadiums643Official NBA arena ID from stats.nba.com
addressstringnullable
capacityintegernullable
citystringMiami
closed_datetimestamptznullable
countrystringnullableUS
ValuesUSCAGBFRMXDE
descriptionstringnullableHome of the Toronto Raptors. Multi-purpose arena in downtown Toronto, opened 1999.
elevationfloatnullable198Elevation in feet above sea level
image_urlstringnullableURL to aerial/overview image of arena
latitudefloatnullable25.7814
longitudefloatnullable-80.187
namestringScotiabank Arena
opened_datetimestamptznullable
roof_typestringnullableArena roof type (all indoor)
statestringnullableCA
surfacestringnullable
team_namestringnullable
timezonestringnullableAmerica/New_YorkIANA timezone (e.g., America/New_York)
ValuesAmerica/New_YorkAmerica/ChicagoAmerica/Los_AngelesAmerica/DenverAmerica/PhoenixAmerica/Mexico_CityAmerica/TorontoAmerica/Indiana/IndianapolisEurope/LondonEurope/ParisEurope/Berlin
nba.referees13 fields· 1 refsendpoints →

NBA officials — the three-person crew of referees who work each game.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
nba_referee_idintegernba.referees202027
activebooleantrue
birth_citystringnullable
birth_countrystringnullable
birth_datedatenullable
birth_statestringnullable
collegestringnullable
experienceintegernullable
first_namestringBiniam
full_namestringBiniam Maru
jersey_numberstringnullable94
last_namestringMaru
nba.broadcasters12 fields· 2 refsendpoints →

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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
broadcaster_idintegernba.broadcasters0
broadcaster_team_idintegernba.teams0
region_idinteger0
broadcaster_abbreviationstringBSIN
broadcaster_descriptionstringnullable
broadcaster_displaystringBSIN
broadcaster_mediastringtv
broadcaster_rankinginteger0
broadcaster_scopestringlocal
Valueslocalnational
broadcaster_video_linkstringnullable
tape_delay_commentsstringnullable
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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
away_team_idbigintnba.teams13
home_team_idbigintnba.teams1
season_idbigintnba.seasons2020
series_idbigint202001
away_team_winsinteger0
games_playedinteger1
home_team_winsinteger4
max_gamesinteger7
series_namestringEast First Round
ValuesEast First RoundWest First RoundEast Play-InWest Play-InEast Conference SemifinalsWest Conference SemifinalsWest Conference FinalsEast Conference FinalsNBA Finals
series_textstringMIA won 1-0
statusstringCompleted
ValuesCompletedActive
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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
broadcaster_idbigintnba.broadcasters10
game_idbigintnba.games15975
broadcaster_typestringawayTv
ValuesawayTvhomeTvnationalTv
nba.game_referees4 fields· 2 refsendpoints →

The officiating crew assigned to each NBA game — the three referees who worked the matchup.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintnba.games4727
referee_idbigintnba.referees58
positionstringnullableReferee
ValuesRefereeCrew ChiefUmpireALTERNATE
nba.player_news16 fields· 2 refsendpoints →

News about NBA players — trades, injuries, lineup decisions, suspensions, and general beat-reporter updates.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
external_idstringnullablerotoql-14973
player_idbigintnullablenba.players165
team_idbigintnullablenba.teams16
ai_processedbooleanfalse
analysisstringnullableBarton had to be helped back to the locker room during the third quarter of Monday's loss to the Ra…
authorstringnullable
categorystringnullableinjury, transaction, lineup, general
contentstringnullable
descriptionstringnullableMurray was assigned Sunday to the D-League's Austin Spurs.
linkstringnullable
news_timetimestamptz2016-11-27T19:29:13.000Z
priorityinteger3
situational_impactjsonbnullable
sourcestringnullablerotowire
titlestringAssigned to D-League
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.

FieldTypeReferencesExampleDescription
idkeybigintPrimary Key
game_idbigintnba.games2374
opponent_team_idbigintnba.teams9
season_idbigintnba.seasons2024
team_idbigintnba.teams9
conference_rankinteger8
game_typestringregularregular, playoff, play_in, ist_group, ist_knockout, preseason, allstar
Valuesregularplayoffist_group
games_remaininginteger0
intensityinteger51-10 motivation intensity scale
is_back_to_backbooleanfalse
Valuesfalsetrue
is_clinchbooleanfalse
Valuesfalsetrue
is_eliminationbooleanfalse
Valuesfalsetrue
ist_group_rankintegernullable
ist_group_recordstringnullablee.g. 2-1
motivationstringplay_incontender, 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
Valuesplay_infringeearly_seasonseeding_battlecontendertankingplayoff_lockplayoff_competitiveplayoff_comfortableplayoff_desperateplayoff_clinchplayoff_eliminationist_contending
rest_daysinteger1
season_pctdecimal1.00000.0-1.0 how far through regular season
season_phasestringmidearly, mid, late, final_push, postseason
Valuesmidlateearlyfinal_pushpostseason
team_series_winsinteger0
win_pctdecimal0.5000