STAT-API

NBA GraphQL Reference

Every NBA game across the 82-game regular season, the In-Season Tournament, the play-in round, and the four-round playoffs through the Finals — with the players, coaching staffs, depth charts, injuries, betting markets, and possession-level play-by-play behind them.

Every GraphQL type, relation, argument, and field — generated from the served schema, so it can never disagree with the API. Each column is documented inline; relations and foreign keys link straight to the type they resolve to. Root fields take the same filters as REST; requests are metered by rows resolved, nested lists included.

Main

seasonsNBASeasons
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.
Fields (8)
idBigIntkey

Primary Key

start_dateString
ex: 2016-10-25T04:00:00.000Z
end_dateStringnullable
ex: 2017-06-12T04:00:00.000Z
start_yearInt
ex: 2016
regular_season_start_dateStringnullable
ex: 2016-10-25T04:00:00.000Z
post_season_start_dateStringnullable
ex: 2017-04-15T04:00:00.000Z
created_atString
updated_atString
Relations (11)
game_lines[NBAGameLines!]!→ NBAGameLines

nba.game_lines rows whose season_id references this row.

game_period_lines[NBAGamePeriodLines!]!→ NBAGamePeriodLines

nba.game_period_lines rows whose season_id references this row.

game_player_props[NBAGamePlayerProps!]!→ NBAGamePlayerProps

nba.game_player_props rows whose season_id references this row.

games[NBAGames!]!→ NBAGames

nba.games rows whose season_id references this row.

playoffs[NBAPlayoffs!]!→ NBAPlayoffs

nba.playoffs rows whose season_id references this row.

season_player_stats[NBASeasonPlayerStats!]!→ NBASeasonPlayerStats

nba.season_player_stats rows whose season_id references this row.

season_team_stats[NBASeasonTeamStats!]!→ NBASeasonTeamStats

nba.season_team_stats rows whose season_id references this row.

team_coaching_staffs[NBATeamCoachingStaffs!]!→ NBATeamCoachingStaffs

nba.team_coaching_staffs rows whose season_id references this row.

team_depth_charts[NBATeamDepthCharts!]!→ NBATeamDepthCharts

nba.team_depth_charts rows whose season_id references this row.

team_game_contexts[NBATeamGameContexts!]!→ NBATeamGameContexts

nba.team_game_contexts rows whose season_id references this row.

team_standings[NBATeamStandings!]!→ NBATeamStandings

nba.team_standings rows whose season_id references this row.

Arguments (2)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
teamsNBATeams
The 30 NBA franchises, organized into the Eastern and Western Conferences with three divisions in each.
Fields (12)
idBigIntkey

Primary Key

abbreviationString
ex: BOS
cityString
ex: Los Angeles
league_team_idIntnullable

Official NBA team ID (issued by the league)

ex: 1610612738
conferenceString
ex: EasternValues:EasternWestern
divisionString
ex: AtlanticValues:AtlanticCentralSoutheastNorthwestPacificSouthwest
full_nameString
ex: Boston Celtics
nameString
ex: Celtics
activeBoolean
ex: true
stadium_idBigIntnullable→ NBAStadiums
created_atString
updated_atString
Relations (26)
stadiumNBAStadiums→ NBAStadiums

The nba.stadiums row referenced by stadium_id; null when unlinked.

game_player_stats[NBAGamePlayerStats!]!→ NBAGamePlayerStats

nba.game_player_stats rows whose team_id references this row.

game_possessions[NBAGamePossessions!]!→ NBAGamePossessions

nba.game_possessions rows whose team_id references this row.

game_team_lineup_stints[NBAGameTeamLineupStints!]!→ NBAGameTeamLineupStints

nba.game_team_lineup_stints rows whose team_id references this row.

game_team_rosters[NBAGameTeamRosters!]!→ NBAGameTeamRosters

nba.game_team_rosters rows whose team_id references this row.

game_team_stats[NBAGameTeamStats!]!→ NBAGameTeamStats

nba.game_team_stats rows whose team_id references this row.

games_by_away_team_id[NBAGames!]!→ NBAGames

nba.games rows whose away_team_id references this row.

games_by_home_team_id[NBAGames!]!→ NBAGames

nba.games rows whose home_team_id references this row.

operator_team_lookups[NBAOperatorTeamLookups!]!→ NBAOperatorTeamLookups

nba.operator_team_lookups rows whose team_id references this row.

play_by_plays_by_player2_team_id[NBAPlayByPlays!]!→ NBAPlayByPlays

nba.play_by_plays rows whose player2_team_id references this row.

play_by_plays_by_player3_team_id[NBAPlayByPlays!]!→ NBAPlayByPlays

nba.play_by_plays rows whose player3_team_id references this row.

play_by_plays_by_team_id[NBAPlayByPlays!]!→ NBAPlayByPlays

nba.play_by_plays rows whose team_id references this row.

player_news_by_opponent_team_id[NBAPlayerNews!]!→ NBAPlayerNews

nba.player_news rows whose opponent_team_id references this row.

player_news_by_team_id[NBAPlayerNews!]!→ NBAPlayerNews

nba.player_news rows whose team_id references this row.

players[NBAPlayers!]!→ NBAPlayers

nba.players rows whose team_id references this row.

playoffs_by_away_team_id[NBAPlayoffs!]!→ NBAPlayoffs

nba.playoffs rows whose away_team_id references this row.

playoffs_by_home_team_id[NBAPlayoffs!]!→ NBAPlayoffs

nba.playoffs rows whose home_team_id references this row.

projected_player_stats[NBAProjectedPlayerStats!]!→ NBAProjectedPlayerStats

nba.projected_player_stats rows whose team_id references this row.

projected_team_stats_by_opponent_team_id[NBAProjectedTeamStats!]!→ NBAProjectedTeamStats

nba.projected_team_stats rows whose opponent_team_id references this row.

projected_team_stats_by_team_id[NBAProjectedTeamStats!]!→ NBAProjectedTeamStats

nba.projected_team_stats rows whose team_id references this row.

season_team_stats[NBASeasonTeamStats!]!→ NBASeasonTeamStats

nba.season_team_stats rows whose team_id references this row.

team_coaching_staffs[NBATeamCoachingStaffs!]!→ NBATeamCoachingStaffs

nba.team_coaching_staffs rows whose team_id references this row.

team_depth_charts[NBATeamDepthCharts!]!→ NBATeamDepthCharts

nba.team_depth_charts rows whose team_id references this row.

team_game_contexts_by_opponent_team_id[NBATeamGameContexts!]!→ NBATeamGameContexts

nba.team_game_contexts rows whose opponent_team_id references this row.

team_game_contexts_by_team_id[NBATeamGameContexts!]!→ NBATeamGameContexts

nba.team_game_contexts rows whose team_id references this row.

team_standings[NBATeamStandings!]!→ NBATeamStandings

nba.team_standings rows whose team_id references this row.

Arguments (3)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • activeBooleanFilter by active status (defaults to true to show only currently-active rows; pass active=false to include inactive).
gamesNBAGames
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.
Required filters: one of season_id.
Fields (29)
idBigIntkey

Primary Key

season_idBigInt→ NBASeasons
ex: 2023
game_timeStringnullable

Scheduled tip-off (timezone-aware); null when the league published no time.

ex: 2025-04-13T19:30:00.000Z
league_game_idStringnullable

Official NBA game ID (issued by the league)

ex: 0022500650
home_team_idBigInt→ NBATeams
ex: 1
away_team_idBigInt→ NBATeams
ex: 1
statusString
ex: Final
end_timeStringnullable
ex: 2024-10-16T01:46:00.000Z
season_typeString
ex: regular_seasonValues:regular_seasonpostseasonpreseasonplay_inin_season_tournament
dayInt
ex: 20250413
away_teamString
ex: BOS
home_teamString
ex: BOS
stadium_idIntnullable→ NBAStadiums
ex: 19
channelStringnullable
ex: NBA TV
attendanceIntnullable
ex: 19156
away_team_scoreInt
ex: 113
home_team_scoreInt
ex: 112
home_rotation_numberIntnullable
away_rotation_numberIntnullable
neutral_venueBoolean
ex: falseValues:falsetrue
series_nameStringnullable
if_necessaryBooleannullable
series_game_numberStringnullable
game_labelStringnullable
game_sub_labelStringnullable
series_textStringnullable
postponed_statusStringnullable
created_atString
updated_atString
Relations (19)
away_team_refNBATeams→ NBATeams

The nba.teams row referenced by away_team_id; null when unlinked.

home_team_refNBATeams→ NBATeams

The nba.teams row referenced by home_team_id; null when unlinked.

seasonNBASeasons→ NBASeasons

The nba.seasons row referenced by season_id; null when unlinked.

stadiumNBAStadiums→ NBAStadiums

The nba.stadiums row referenced by stadium_id; null when unlinked.

game_broadcasters[NBAGameBroadcasters!]!→ NBAGameBroadcasters

nba.game_broadcasters rows whose game_id references this row.

game_lines[NBAGameLines!]!→ NBAGameLines

nba.game_lines rows whose game_id references this row.

game_period_lines[NBAGamePeriodLines!]!→ NBAGamePeriodLines

nba.game_period_lines rows whose game_id references this row.

game_player_props[NBAGamePlayerProps!]!→ NBAGamePlayerProps

nba.game_player_props rows whose game_id references this row.

game_player_stats[NBAGamePlayerStats!]!→ NBAGamePlayerStats

nba.game_player_stats rows whose game_id references this row.

game_possessions[NBAGamePossessions!]!→ NBAGamePossessions

nba.game_possessions rows whose game_id references this row.

game_referees[NBAGameReferees!]!→ NBAGameReferees

nba.game_referees rows whose game_id references this row.

game_team_lineup_stints[NBAGameTeamLineupStints!]!→ NBAGameTeamLineupStints

nba.game_team_lineup_stints rows whose game_id references this row.

game_team_rosters[NBAGameTeamRosters!]!→ NBAGameTeamRosters

nba.game_team_rosters rows whose game_id references this row.

game_team_stats[NBAGameTeamStats!]!→ NBAGameTeamStats

nba.game_team_stats rows whose game_id references this row.

play_by_plays[NBAPlayByPlays!]!→ NBAPlayByPlays

nba.play_by_plays rows whose game_id references this row.

player_news[NBAPlayerNews!]!→ NBAPlayerNews

nba.player_news rows whose game_id references this row.

projected_player_stats[NBAProjectedPlayerStats!]!→ NBAProjectedPlayerStats

nba.projected_player_stats rows whose game_id references this row.

projected_team_stats[NBAProjectedTeamStats!]!→ NBAProjectedTeamStats

nba.projected_team_stats rows whose game_id references this row.

team_game_contexts[NBATeamGameContexts!]!→ NBATeamGameContexts

nba.team_game_contexts rows whose game_id references this row.

Arguments (11)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • season_idIntFilter to a season. Defaults to the current season.
  • home_team_idIntFilter by home team.
  • away_team_idIntFilter by away team.
  • statusStringFilter by game status.
  • dayIntFilter by calendar day (YYYYMMDD integer, US Eastern) — e.g. day=20260609 for tonight's slate. Note season_id defaults to the current season; pass season_id explicitly when querying a past season's day.
  • day__gteIntgte comparison on day.
  • day__lteIntlte comparison on day.
  • day__betweenStringRange filter on day — pass "lo,hi".
  • season_typeStringFilter by season phase (regular_season, preseason, postseason, play_in, in_season_tournament, all_star).
playersNBAPlayers
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.
Required filters: one of roster_status.
Fields (42)
idBigIntkey

Primary Key

first_nameString

Player's legal first name as registered with the league.

ex: Nikola
last_nameString

Player's legal last name.

ex: Jokić
full_nameString

Convenience concatenation of first_name + last_name. Use this for display.

ex: Nikola Jokić
jerseyStringnullable

Current jersey number as a string (some leagues allow leading zeros, e.g., "00").

ex: 15
league_player_idInt

Official NBA player ID (issued by the league). Stable across seasons; use it to join other data that carries the league id.

ex: 203999
primary_positionString

Primary position. One of G, F, C, G-F, F-C. (True PG/SG/SF/PF splits live in team_depth_charts.position.)

ex: CValues:GFCG-FF-CUnknown
full_position_listStringnullable

Hyphenated full-word position list (e.g., "Guard-Forward", "Center-Forward").

ex: Guard-ForwardValues:GuardForwardCenterGuard-ForwardForward-CenterCenter-ForwardForward-Guard
team_idBigIntnullable→ NBATeams

FK to nba.teams. Null for free agents and retired players.

ex: 12
league_slugStringnullable

NBA-issued URL slug of the player (as in the league player page).

ex: nikola-jokic
position_categoryStringnullable

Coarse positional grouping. One of Guard, Forward, Center, Utility.

ex: CenterValues:GuardForwardCenterUtility
heightIntnullable

Height in inches.

ex: 83
weightIntnullable

Listed weight in pounds.

ex: 284
birth_dateStringnullable

Birth date in YYYY-MM-DD form.

ex: 1995-02-19
birth_cityStringnullable

City of birth.

ex: Sombor
birth_stateStringnullable

State / province of birth (US/Canadian players).

birth_countryStringnullable

Country of birth (ISO English name).

ex: Serbia
schoolStringnullable

Last school attended before the NBA (college, prep, or international club).

ex: Mega Basket
experienceIntnullable

Years of NBA experience as of the most recent season. Rookies = 0.

ex: 10
display_last_comma_firstStringnullable

Display name in "Last, First" form. Useful for sorted lists.

ex: Jokić, Nikola
display_fi_lastStringnullable

Display name in "F. Last" form.

ex: N. Jokić
last_affiliationStringnullable

Most recent pre-NBA affiliation (school, league, or team).

ex: Mega Basket / Serbia
team_nameStringnullable

Current team's mascot name (denormalized from teams.name for read convenience).

ex: Nuggets
team_abbreviationStringnullable

Current team's tri-letter code.

ex: DEN
team_codeStringnullable

Current team's lowercase URL slug.

ex: nuggets
team_cityStringnullable

Current team's city name.

ex: Denver
playercodeStringnullable

NBA-issued player code (lastname_firstname format).

ex: jokic_nikola
from_yearStringnullable

Player's NBA debut year as a string (as the league records it).

ex: 2015
to_yearStringnullable

Player's most recent NBA season year. Equal to from_year for rookies.

ex: 2025
dleague_flagStringnullable

Two-character bit-string from the league: "00" no G-League history, "01" G-League experience, "11" currently G-League-affiliated (two-way / assignment).

ex: 00
nba_flagStringnullable

String "Y"/"N" indicating NBA experience. Almost always "Y" in this table.

ex: Y
games_played_flagStringnullable

String "Y"/"N" indicating whether the player has played at least one regular-season game.

ex: YValues:YN
draft_yearStringnullable

Year the player was drafted (string form). Empty for undrafted players.

ex: 2014
draft_roundStringnullable

Draft round (string). Empty for undrafted players.

ex: 2
draft_numberStringnullable

Overall pick number within the draft (string). Empty for undrafted.

ex: 41
roster_statusStringnullable

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}.

ex: activeValues:inactiveactivefree_agent
created_atString
updated_atString
injury_statusStringnullable

Current injury status snapshot derived from player_news. Values: "OUT", "QUESTIONABLE"; null = no active injury designation (healthy).

ex: OUTValues:OUTQUESTIONABLE
injury_body_partStringnullable

Affected body part for the most recent injury (e.g., "Knee", "Ankle"). Null when injury_status is null.

Values:anklekneeillnesshiptoebackwristfootcalfhamstringpelvisabdomenheelrestachillesthumbhand
injury_detailStringnullable

Free-text injury description from the source feed.

injury_sinceStringnullable

Timestamp of the injury status snapshot. Updated when player_news produces a new injury entry.

ex: 2026-04-12T18:30:00Z
Relations (17)
teamNBATeams→ NBATeams

The nba.teams row referenced by team_id; null when unlinked.

game_player_props[NBAGamePlayerProps!]!→ NBAGamePlayerProps

nba.game_player_props rows whose player_id references this row.

game_player_stats[NBAGamePlayerStats!]!→ NBAGamePlayerStats

nba.game_player_stats rows whose player_id references this row.

game_team_lineup_stints_by_player1_id[NBAGameTeamLineupStints!]!→ NBAGameTeamLineupStints

nba.game_team_lineup_stints rows whose player1_id references this row.

game_team_lineup_stints_by_player2_id[NBAGameTeamLineupStints!]!→ NBAGameTeamLineupStints

nba.game_team_lineup_stints rows whose player2_id references this row.

game_team_lineup_stints_by_player3_id[NBAGameTeamLineupStints!]!→ NBAGameTeamLineupStints

nba.game_team_lineup_stints rows whose player3_id references this row.

game_team_lineup_stints_by_player4_id[NBAGameTeamLineupStints!]!→ NBAGameTeamLineupStints

nba.game_team_lineup_stints rows whose player4_id references this row.

game_team_lineup_stints_by_player5_id[NBAGameTeamLineupStints!]!→ NBAGameTeamLineupStints

nba.game_team_lineup_stints rows whose player5_id references this row.

game_team_rosters[NBAGameTeamRosters!]!→ NBAGameTeamRosters

nba.game_team_rosters rows whose player_id references this row.

operator_player_lookups[NBAOperatorPlayerLookups!]!→ NBAOperatorPlayerLookups

nba.operator_player_lookups rows whose player_id references this row.

play_by_plays_by_player2_id[NBAPlayByPlays!]!→ NBAPlayByPlays

nba.play_by_plays rows whose player2_id references this row.

play_by_plays_by_player3_id[NBAPlayByPlays!]!→ NBAPlayByPlays

nba.play_by_plays rows whose player3_id references this row.

play_by_plays_by_player_id[NBAPlayByPlays!]!→ NBAPlayByPlays

nba.play_by_plays rows whose player_id references this row.

player_news[NBAPlayerNews!]!→ NBAPlayerNews

nba.player_news rows whose player_id references this row.

projected_player_stats[NBAProjectedPlayerStats!]!→ NBAProjectedPlayerStats

nba.projected_player_stats rows whose player_id references this row.

season_player_stats[NBASeasonPlayerStats!]!→ NBASeasonPlayerStats

nba.season_player_stats rows whose player_id references this row.

team_depth_charts[NBATeamDepthCharts!]!→ NBATeamDepthCharts

nba.team_depth_charts rows whose player_id references this row.

Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • team_idIntFilter to players whose current team_id matches. Null team_id rows (free agents, retired) are excluded when this filter is applied.
  • roster_statusStringFilter by canonical roster status. Defaults to active (current roster); pass roster_status= explicitly for other tiers (injured_reserve, free_agent, retired, inactive). The "on a team now" set is {active, injured_reserve}.

Plays

game_possessionsNBAGamePossessions
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.
Required filters: one of game_id.
Fields (31)
idBigIntkey

Primary Key

game_idBigInt→ NBAGames
ex: 2357
team_idBigIntnullable→ NBATeams
ex: 19
start_nba_event_numInt
ex: 4
end_nba_event_numInt
ex: 7
periodInt
ex: 1
home_scoreInt
ex: 82
away_scoreInt
ex: 38
start_clockInt
ex: 720
end_clockIntnullable
ex: 0
created_atString
updated_atString
fgaInt
ex: 1
fgmInt
ex: 0
fg3aInt
ex: 0
fg3mInt
ex: 0
ftaInt
ex: 0
ftmInt
ex: 0
orebInt
ex: 0
drebInt
ex: 0
astInt
ex: 0
stlInt
ex: 0
blkInt
ex: 0
tovInt
ex: 0
pfInt
ex: 0
ptsInt
ex: 0
cum_home_possInt
ex: 75
cum_away_possInt
ex: 13
game_seconds_elapsedInt
ex: 720
time_actual_startStringnullable
ex: 2024-10-28T23:53:48.400Z
time_actual_endStringnullable
ex: 2024-10-30T02:08:06.000Z
Relations (3)
gameNBAGames→ NBAGames

The nba.games row referenced by game_id; null when unlinked.

teamNBATeams→ NBATeams

The nba.teams row referenced by team_id; null when unlinked.

play_by_plays[NBAPlayByPlays!]!→ NBAPlayByPlays

nba.play_by_plays rows whose game_possession_id references this row.

Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • team_idIntFilter by team in possession.
play_by_playsNBAPlayByPlays
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).
Required filters: one of game_id.
Fields (23)
idBigIntkey

Primary Key

play_idString
ex: 0052400111_2
nba_event_numInt
ex: 2
game_possession_idBigInt→ NBAGamePossessions
ex: 16457458
game_idBigInt→ NBAGames
ex: 2377
player_idBigIntnullable→ NBAPlayers
ex: 49
team_idBigIntnullable→ NBATeams
ex: 21
event_typeInt
ex: 8
event_sub_typeInt
ex: 0
home_descriptionString
visitor_descriptionString
neutral_descriptionString
start_clockInt
ex: 720
end_clockIntnullable
player2_idBigIntnullable→ NBAPlayers
ex: 49
player2_team_idBigIntnullable→ NBATeams
ex: 21
player3_idBigIntnullable→ NBAPlayers
ex: 227
player3_team_idBigIntnullable→ NBATeams
ex: 21
created_atString
updated_atString
time_actualStringnullable
ex: 2025-04-17T01:56:41.900Z
event_seqInt
ex: 100
possession_seqInt
ex: 142
Relations (8)
gameNBAGames→ NBAGames

The nba.games row referenced by game_id; null when unlinked.

game_possessionNBAGamePossessions→ NBAGamePossessions

The nba.game_possessions row referenced by game_possession_id; null when unlinked.

player2NBAPlayers→ NBAPlayers

The nba.players row referenced by player2_id; null when unlinked.

player2_teamNBATeams→ NBATeams

The nba.teams row referenced by player2_team_id; null when unlinked.

player3NBAPlayers→ NBAPlayers

The nba.players row referenced by player3_id; null when unlinked.

player3_teamNBATeams→ NBATeams

The nba.teams row referenced by player3_team_id; null when unlinked.

playerNBAPlayers→ NBAPlayers

The nba.players row referenced by player_id; null when unlinked.

teamNBATeams→ NBATeams

The nba.teams row referenced by team_id; null when unlinked.

Arguments (6)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • player_idIntFilter to plays involving a specific player.
  • team_idIntFilter to plays by a specific team.
  • event_typeIntFilter by event type code: 1 made shot, 2 missed shot, 3 free throw, 4 rebound, 5 turnover, 6 foul, 7 violation, 8 substitution, 9 timeout, 10 jump ball, 11 ejection, 12 period start, 13 period end, 18 instant replay (the league codes).

Stats

season_team_statsNBASeasonTeamStats
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.
Required filters: one of season_id.
Fields (11)
idBigIntkey

Primary Key

team_idBigInt→ NBATeams
ex: 19
season_idBigInt→ NBASeasons
ex: 2024
games_playedInt
ex: 82
winsInt
ex: 44
lossesInt
ex: 38
tiesInt
ex: 0
pts_scoredInt
ex: 9372
pts_allowedInt
ex: 0
created_atString
updated_atString
Relations (2)
seasonNBASeasons→ NBASeasons

The nba.seasons row referenced by season_id; null when unlinked.

teamNBATeams→ NBATeams

The nba.teams row referenced by team_id; null when unlinked.

Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • season_idIntFilter to a single season. Defaults to the current season.
  • team_idIntFilter by team.
team_standingsNBATeamStandings
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.
Required filters: one of season_id.
Fields (23)
idBigIntkey

Primary Key

season_idBigInt→ NBASeasons
ex: 2024
team_idBigInt→ NBATeams
ex: 1
dayInt

YYYYMMDD — standings as of this date (before games on this day)

ex: 20241103
winsInt
ex: 2
lossesInt
ex: 1
win_pctFloat
ex: 0.5000
conference_rankInt

1-15 within conference

ex: 8
division_rankInt

1-5 within division

ex: 1
conference_gbFloat

Games back from conference leader

ex: 0.0000
playoff_gbFloat

Games back from 6th seed (auto-qualify cutoff)

ex: 0.0000
playin_gbFloat

Games back from 10th seed (play-in cutoff)

ex: 0.0000
games_playedInt
ex: 1
games_remainingInt
ex: 81
l10_winsInt
ex: 6
l10_lossesInt
ex: 4
streakInt

Positive = win streak, negative = loss streak

ex: -1
home_winsInt
ex: 1
home_lossesInt
ex: 4
away_winsInt
ex: 1
away_lossesInt
ex: 6
created_atString
updated_atString
Relations (2)
seasonNBASeasons→ NBASeasons

The nba.seasons row referenced by season_id; null when unlinked.

teamNBATeams→ NBATeams

The nba.teams row referenced by team_id; null when unlinked.

Arguments (8)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • season_idIntFilter to a single season. Defaults to the current season.
  • team_idIntFilter by team.
  • dayIntStandings as of this day (YYYYMMDD integer). Omit for all daily snapshots, newest first; pass a day for a point-in-time table.
  • day__gteIntgte comparison on day.
  • day__lteIntlte comparison on day.
  • day__betweenStringRange filter on day — pass "lo,hi".
game_player_statsNBAGamePlayerStats
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.
Required filters: one of game_id | player_id.
Fields (115)
idBigIntkey

Primary Key

game_idBigInt→ NBAGames
ex: 122
team_idBigInt→ NBATeams
ex: 17
player_idBigInt→ NBAPlayers
ex: 75
commentStringnullable
start_positionStringnullable
ex: GValues:GFC
minutesFloat
ex: 12.0000
ptsInt
ex: 0
assistsInt
ex: 0
reboundsInt
ex: 2
stealsInt
ex: 0
blocksInt
ex: 0
turnoversInt
ex: 0
foulsInt

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.

ex: 1
field_goals_madeInt
ex: 1
field_goals_attemptedInt
ex: 5
three_pointers_madeInt
ex: 0
three_pointers_attemptedInt
ex: 0
free_throws_madeInt
ex: 0
free_throws_attemptedInt
ex: 0
offensive_reboundsInt
ex: 0
defensive_reboundsInt
ex: 1
potential_assistsIntnullable
ex: 0
shots_blockedIntnullable
ex: 0
deflectionsIntnullable
ex: 1
contestsIntnullable
ex: 1
charges_takenIntnullable
ex: 0
passes_deflectedIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

balls_stolenIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

loose_balls_recoveredIntnullable
ex: 0
personal_foulsInt

Personal fouls only — the count a player fouls out on at 6. Includes offensive and flagrant fouls, which the NBA scores as personal fouls.

ex: 1
offensive_foulsIntnullable

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.

technical_foulsIntnullable

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.

fouls_drawnInt
ex: 0
and_onesIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

traveling_violationsIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

double_dribble_violationsIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

carrying_palming_violationsIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

backcourt_violationsIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

shot_clock_violationsIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

lane_violationsIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

goaltending_violationsIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

basket_interference_violationsIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

substitutions_inIntnullable

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.

ex: 3
substitutions_outIntnullable

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.

ex: 3
jump_balls_wonIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

jump_balls_lostIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

timeouts_calledIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

challenges_requestedIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

shot_contested_countIntnullable
ex: 1
dunksIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

layupsIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

alley_oopsIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

put_backsIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

fast_break_ptsIntnullable

Fast-break points. Null when the source of the game gives none (most games): never a made-up 0.

second_chance_ptsIntnullable

Second-chance points. Null when the source of the game gives none (most games): never a made-up 0.

hockey_assistsIntnullable
ex: 0
screen_assistsIntnullable
ex: 0
box_outsIntnullable
ex: 0
ejectionsIntnullable

No source fills this field yet: null, never a made-up 0 (2026-10-26).

plus_minusInt
ex: -2
field_goal_percentageFloatnullable
ex: 0.0000
three_point_percentageFloatnullable
ex: 0.0000
free_throw_percentageFloatnullable
ex: 0.0000
triple_doublesInt
ex: 0
double_doublesInt
ex: 0
estimated_offensive_ratingFloatnullable
ex: 100.0000
offensive_ratingFloatnullable
ex: 100.0000
estimated_defensive_ratingFloatnullable
ex: 100.0000
defensive_ratingFloatnullable
ex: 100.0000
estimated_net_ratingFloatnullable
ex: 0.0000
net_ratingFloatnullable
ex: 0.0000
assist_percentageFloatnullable
ex: 0.0000
assist_to_turnoverFloatnullable
ex: 0.0000
assist_ratioFloatnullable
ex: 0.0000
offensive_rebound_percentageFloatnullable
ex: 0.0000
defensive_rebound_percentageFloatnullable
ex: 0.0000
rebound_percentageFloatnullable
ex: 0.0000
turnover_ratioFloatnullable
ex: 0.0000
effective_field_goal_percentageFloatnullable
ex: 0.0000
true_shooting_percentageFloatnullable
ex: 0.0000
usage_percentageFloatnullable
ex: 0.0000
estimated_usage_percentageFloatnullable
ex: 0.0000
estimated_paceFloatnullable
ex: 84.7100
possessionsInt
ex: 53
touchesIntnullable
ex: 26
front_court_touchesIntnullable
ex: 19
avg_seconds_per_touchFloatnullable
ex: 0.0000
avg_dribbles_per_touchFloatnullable
ex: 0.0000
elbow_touchesIntnullable
ex: 0
paint_touchesIntnullable
ex: 0
time_of_possessionFloatnullable
ex: 0.2000
post_touchesIntnullable
ex: 0
pts_per_touchFloatnullable
ex: 0.0000
pts_per_elbow_touchFloatnullable
pts_per_post_touchFloatnullable
pts_per_paint_touchFloatnullable
player_impact_estimateFloat
ex: 0.0000
drivesIntnullable
ex: 0
passesIntnullable
ex: 21
pass_percentageFloatnullable
ex: 0.0000
created_atString
updated_atString
game_dateInt
ex: 20251112
rotation_contextStringnullable
ex: normalValues:normalgarbage_time_boostambiguous_anomalyblowout_restfoul_troublefoul_outinjury_exitdnp_coach
foul_trouble_severityInt
ex: 0
abnormal_exit_periodInt
ex: 0
abnormal_exit_clockInt
ex: 0
garbage_time_minutesFloat
ex: 0
competitive_minutesFloat
ex: 0.0
rotation_context_confidenceFloat
ex: 0.5
minutes_deviation_pctFloat
ex: 0
role_archetypeStringnullable
ex: deep_benchValues:deep_benchco_starcore_starterrotationend_of_benchalphasixth_mantwo_way
role_archetype_confidenceFloat
ex: 0.6
role_anomalous_gameBoolean
ex: falseValues:falsetrue
Relations (3)
gameNBAGames→ NBAGames

The nba.games row referenced by game_id; null when unlinked.

playerNBAPlayers→ NBAPlayers

The nba.players row referenced by player_id; null when unlinked.

teamNBATeams→ NBATeams

The nba.teams row referenced by team_id; null when unlinked.

Arguments (9)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • player_idIntFilter to a single player — their full game log, newest first. Combine with game_date ranges to window it.
  • team_idIntFilter by team.
  • game_dateIntFilter by game day (YYYYMMDD integer, US Eastern).
  • game_date__gteIntgte comparison on game_date.
  • game_date__lteIntlte comparison on game_date.
  • game_date__betweenStringRange filter on game_date — pass "lo,hi".
game_team_statsNBAGameTeamStats
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.
Required filters: one of game_id.
Fields (72)
idBigIntkey

Primary Key

game_idBigInt→ NBAGames
ex: 6
team_idBigInt→ NBATeams
ex: 12
winInt
ex: 0
lossInt
ex: 1
minutesInt
ex: 48
ptsInt
ex: 113
assistsInt
ex: 24
reboundsInt
ex: 42
stealsInt
ex: 7
blocksInt
ex: 4
turnoversInt
ex: 13
foulsInt
ex: 19
field_goals_madeInt
ex: 42
field_goals_attemptedInt
ex: 88
field_goal_percentageFloat
ex: 0.5000
three_pointers_madeInt
ex: 12
three_pointers_attemptedInt
ex: 34
three_point_percentageFloat
ex: 0.3330
free_throws_madeInt
ex: 17
free_throws_attemptedInt
ex: 21
free_throw_percentageFloat
ex: 0.7500
offensive_reboundsInt
ex: 10
defensive_reboundsInt
ex: 32
fast_break_ptsInt
ex: 11
pts_in_paintInt
ex: 50
second_chance_ptsInt
ex: 12
pts_off_turnoversInt
ex: 17
bench_ptsInt
ex: 34
timeouts_remainingInt
ex: 0
assists_to_turnoversFloat
ex: 2.0000
steals_to_turnoversFloat
ex: 0.5000
defensive_ratingFloat
ex: 100.0000
offensive_ratingFloat
ex: 100.0000
net_ratingFloat
ex: 2.0000
assist_percentageFloat
ex: 0.6670
assist_ratioFloat
ex: 18.8000
offensive_rebound_percentageFloat
ex: 0.3330
defensive_rebound_percentageFloat
ex: 0.6670
rebound_percentageFloat
ex: 0.5000
turnover_percentageFloat
ex: 0.1172
possessionsInt
ex: 101
paceFloat
ex: 101.0000
pace_per40Float
ex: 0.0000
true_shooting_percentageFloat
ex: 0.5760
effective_field_goal_percentageFloat
ex: 0.5000
player_impact_estimateFloat
ex: 0.4620
estimated_offensive_ratingFloat
ex: 0.0000
estimated_defensive_ratingFloat
ex: 0.0000
estimated_net_ratingFloat
ex: 0.0000
estimated_paceFloat
ex: 0.0000
free_throw_attempt_rateFloat
ex: 0.2500
pct_fga_2ptFloat
ex: 0.6670
pct_fga_3ptFloat
ex: 0.3330
pct_pts_2ptFloat
ex: 0.5000
pct_pts_2pt_mrFloat
ex: 0.0000
pct_pts_3ptFloat
ex: 0.3330
pct_pts_fbFloat
ex: 0.0960
pct_pts_ftFloat
ex: 0.1670
pct_pts_off_tovFloat
ex: 0.1430
pct_pts_paintFloat
ex: 0.4000
pct_ast_2pmFloat
ex: 0.5000
pct_uast_2pmFloat
ex: 0.5000
pct_ast_3pmFloat
ex: 1.0000
pct_uast_3pmFloat
ex: 0.0000
pct_ast_fgmFloat
ex: 0.6670
pct_uast_fgmFloat
ex: 0.3330
created_atString
updated_atString
winsInt

Cumulative wins

ex: 1
lossesInt

Cumulative losses

ex: 3
conference_rankInt

Conference rank entering game

ex: 10
Relations (2)
gameNBAGames→ NBAGames

The nba.games row referenced by game_id; null when unlinked.

teamNBATeams→ NBATeams

The nba.teams row referenced by team_id; null when unlinked.

Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • team_idIntFilter by team.
season_player_statsNBASeasonPlayerStats
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).
Required filters: one of season_id | player_id.
Fields (51)
idBigIntkey

Primary Key

player_idBigInt→ NBAPlayers
ex: 176
season_idBigInt→ NBASeasons
ex: 2021
games_playedInt
ex: 68
created_atString
updated_atString
winsInt
ex: 1
lossesInt
ex: 1
minutesFloat
ex: 1297.0367
ptsInt
ex: 0
assistsInt
ex: 0
reboundsInt
ex: 0
stealsInt
ex: 0
blocksInt
ex: 0
turnoversInt
ex: 0
foulsInt
ex: 0
field_goals_madeInt
ex: 0
field_goals_attemptedInt
ex: 6
three_pointers_madeInt
ex: 0
three_pointers_attemptedInt
ex: 0
free_throws_madeInt
ex: 0
free_throws_attemptedInt
ex: 0
offensive_reboundsInt
ex: 0
defensive_reboundsInt
ex: 0
plus_minusInt
ex: -7
double_doublesInt
ex: 0
triple_doublesInt
ex: 0
field_goal_percentageFloat
ex: 0.5000
three_point_percentageFloat
ex: 0.0000
free_throw_percentageFloat
ex: 0.0000
offensive_ratingFloat
ex: 113.9000
defensive_ratingFloat
ex: 111.1000
net_ratingFloat
ex: 0.3000
assist_percentageFloat
ex: 0.0000
assist_to_turnoverFloat
ex: 0.0000
assist_ratioFloat
ex: 0.0000
offensive_rebound_percentageFloat
ex: 0.0000
defensive_rebound_percentageFloat
ex: 0.0000
rebound_percentageFloat
ex: 0.0620
turnover_percentageFloat
ex: 0.0000
effective_field_goal_percentageFloat
ex: 0.5000
true_shooting_percentageFloat
ex: 0.0000
usage_percentageFloat
ex: 0.1360
paceFloat
ex: 100.6900
player_impact_estimateFloat
ex: 0.0730
possessionsInt
ex: 41
touchesInt
ex: 0
front_court_touchesInt
ex: 0
time_of_possessionFloat
ex: 0.0000
avg_seconds_per_touchFloat
ex: 1.6400
avg_dribbles_per_touchFloat
ex: 0.0000
Relations (2)
playerNBAPlayers→ NBAPlayers

The nba.players row referenced by player_id; null when unlinked.

seasonNBASeasons→ NBASeasons

The nba.seasons row referenced by season_id; null when unlinked.

Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • season_idIntFilter to a single season. Defaults to the current season.
  • player_idIntFilter to a single player.

Projections

projected_player_statsNBAProjectedPlayerStats
Deprecated — use GET /api/v1/dfs/slates/{slate_id}/projections, which serves this stat line for every seat of a DFS slate with its fantasy points (and GET /api/v1/dfs/contests/{contest_id}/projections, with the contest's projected ownership). This table stays served for existing callers. 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.
Required filters: one of game_id | player_id.
Fields (39)
idBigIntkey

Primary Key

game_idBigInt→ NBAGames
ex: 6029937
player_idBigInt→ NBAPlayers
ex: 221
team_idBigInt→ NBATeams
ex: 17
projection_idBigInt

Engine version id (main.projections; STAT_API_NBA 2.2, the NFL engine's version).

ex: 3
positionStringnullable

The player's position as the roster service gave it for this game.

ex: GValues:GFCG-FF-C
statusStringnullable

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.

ex: availableValues:availableoutquestionableprobable
status_sourceStringnullable

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).

ex: fanduelValues:fandueldraftkingsleague_reportmedia
expected_starterBooleannullable

True when the player was in the expected starting lineup when the projection ran; null when no lineup was known.

ex: falseValues:falsetrue
lineup_confirmedBooleannullable

True when that starting lineup was confirmed; null when no lineup was known.

ex: true
play_probabilityFloat

Chance the player plays, 0 to 1.

ex: 1
start_probabilityFloat

Chance the player starts, 0 to 1.

ex: 0
minutes_meanFloat

Projected minutes (mean).

ex: 0
minutes_stdFloat

Standard deviation of the projected minutes.

ex: 0
minutes_p10Float

Projected minutes, 10th percentile.

ex: 0
minutes_p25Float

Projected minutes, 25th percentile.

ex: 0
minutes_p50Float

Projected minutes, median.

ex: 0
minutes_p75Float

Projected minutes, 75th percentile.

ex: 0
minutes_p90Float

Projected minutes, 90th percentile.

ex: 0
usage_rateFloat

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.

ex: 0
ptsFloat

Projected points (mean).

ex: 0
rebFloat

Projected rebounds (mean).

ex: 0
astFloat

Projected assists (mean).

ex: 0
stlFloat

Projected steals (mean).

ex: 0
blkFloat

Projected blocks (mean).

ex: 0
fg3mFloat

Projected three-pointers made (mean).

ex: 0
tovFloat

Projected turnovers (mean).

ex: 0
stat_quantilesJSON

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.

ex: [object Object]
praFloat

Projected points + rebounds + assists (mean).

ex: 0
pts_rebFloat

Projected points + rebounds (mean).

ex: 0
pts_astFloat

Projected points + assists (mean).

ex: 0
reb_astFloat

Projected rebounds + assists (mean).

ex: 0
stocksFloat

Projected steals + blocks (mean).

ex: 0
double_double_probabilityFloat

Chance of a double-double, 0 to 1.

ex: 0
triple_double_probabilityFloat

Chance of a triple-double, 0 to 1.

ex: 0
zero_reasonStringnullable

Why the player projects 0 minutes (ruled out, inactive, not on the roster); null for a player who may play.

ex: out
inputs_as_ofString

Time of the newest input the projection used (UTC). Always before the game's tip.

ex: 2026-01-31T00:29:59.999Z
created_atString
updated_atString
Relations (3)
gameNBAGames→ NBAGames

The nba.games row referenced by game_id; null when unlinked.

playerNBAPlayers→ NBAPlayers

The nba.players row referenced by player_id; null when unlinked.

teamNBATeams→ NBATeams

The nba.teams row referenced by team_id; null when unlinked.

Arguments (6)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • player_idIntFilter to a single player.
  • team_idIntFilter by team.
  • projection_idIntFilter by engine version (one id per version of our NBA engine).
projected_team_statsNBAProjectedTeamStats
Deprecated — use GET /api/v1/dfs/slates/{slate_id}/projections, whose teams block serves these team projections for the games of a DFS slate. This table stays served for existing callers. 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.
Required filters: one of game_id.
Fields (34)
idBigIntkey

Primary Key

game_idBigInt→ NBAGames
ex: 6029936
team_idBigInt→ NBATeams
ex: 24
opponent_team_idBigInt→ NBATeams

The team this team plays in the game.

ex: 24
is_homeBoolean

True when this team is the home team.

ex: trueValues:truefalse
projection_idBigInt

Engine version id (main.projections; STAT_API_NBA 2.2, the NFL engine's version).

ex: 3
possessions_meanFloat

Projected possessions of the game (mean).

ex: 96.42541443256545
possessions_p10Float

Projected possessions, 10th percentile.

ex: 90.95248584451933
possessions_p50Float

Projected possessions, median.

ex: 95.89911660868471
possessions_p90Float

Projected possessions, 90th percentile.

ex: 102.29353326932566
pace_per_48Float

Projected pace — possessions per 48 minutes.

ex: 95.80466291019982
team_points_meanFloat

Projected points this team scores (mean) — the team's total output.

ex: 115.5
team_points_stdFloat

Standard deviation of this team's projected points.

ex: 11.765627905046122
team_points_p10Float

This team's projected points, 10th percentile.

ex: 101
team_points_p25Float

This team's projected points, 25th percentile.

ex: 107
team_points_p50Float

This team's projected points, median.

ex: 114
team_points_p75Float

This team's projected points, 75th percentile.

ex: 123
team_points_p90Float

This team's projected points, 90th percentile.

ex: 130
opponent_points_meanFloat

Projected points the opponent scores (mean).

ex: 115.5
offensive_ratingFloat

Projected points per 100 possessions.

ex: 113.57116578410486
win_probabilityFloat

Chance this team wins, 0 to 1 (0.62 = 62%).

ex: 0.613
overtime_probabilityFloat

Chance the game goes to overtime, 0 to 1.

ex: 0.056
reb_meanFloat

Projected team rebounds (the sum of its players' projected rebounds).

ex: 44.12
ast_meanFloat

Projected team assists.

ex: 26.193
stl_meanFloat

Projected team steals.

ex: 7.564
blk_meanFloat

Projected team blocks.

ex: 4.514
fg3m_meanFloat

Projected team three-pointers made.

ex: 13.099
tov_meanFloat

Projected team turnovers.

ex: 13.687
vegas_totalFloatnullable

Betting game total the projection used; null when no line was captured before the projection.

ex: 227.5
vegas_spreadFloatnullable

Betting spread from this team's side that the projection used; null when no line was captured.

ex: 3.5
implied_team_totalFloatnullable

This team's implied points from the betting total and spread; null when no line was captured.

ex: 115.5
lines_captured_atStringnullable

When the betting lines the projection used were captured (UTC).

ex: 2024-11-04T05:00:00.000Z
inputs_as_ofString

Time of the newest input the projection used (UTC). Always before the game's tip.

ex: 2025-04-13T19:29:59.999Z
created_atString
Relations (3)
gameNBAGames→ NBAGames

The nba.games row referenced by game_id; null when unlinked.

opponent_teamNBATeams→ NBATeams

The nba.teams row referenced by opponent_team_id; null when unlinked.

teamNBATeams→ NBATeams

The nba.teams row referenced by team_id; null when unlinked.

Arguments (5)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • team_idIntFilter by team.
  • projection_idIntFilter by engine version (one id per version of our NBA engine).

Odds

game_linesNBAGameLines
NBA game betting lines — point spreads, moneylines, and over/under totals from sportsbooks, captured over time as the lines move from opening to closing.
Required filters: one of game_id.
Fields (32)
idBigIntkey

Primary Key

game_idBigInt→ NBAGames
ex: 16082
season_idBigInt→ NBASeasons

Denormalized for efficient season-level queries

ex: 2021
operator_idBigInt→ ReferenceOperators

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.

ex: 6
spreadFloatnullable

Home team spread (e.g., -3.5 means home favored by 3.5)

ex: -2.5000
spread_home_oddsIntnullable

American odds for home spread (e.g., -110)

ex: -110
spread_away_oddsIntnullable

American odds for away spread

ex: -110
moneyline_homeIntnullable

American odds for home team win

ex: -170
moneyline_awayIntnullable

American odds for away team win

ex: 145
totalFloatnullable

Combined score total line (e.g., 224.5)

ex: 225.5000
over_oddsIntnullable

American odds for over

ex: -110
under_oddsIntnullable

American odds for under

ex: -110
implied_home_scoreFloatnullable

Calculated from spread + total

ex: 109.7500
implied_away_scoreFloatnullable
ex: 109.0000
implied_home_win_pctFloatnullable

From moneyline, 0-1

ex: 0.6296
implied_away_win_pctFloatnullable
ex: 0.4082
captured_atString

When this snapshot was captured

ex: 2022-04-10T00:00:00.000Z
is_openingBoolean

True if this is the opening line

ex: falseValues:falsetrue
created_atString
updated_atString
spread_bet_pct_homeIntnullable
spread_bet_pct_awayIntnullable
spread_money_pct_homeIntnullable
spread_money_pct_awayIntnullable
moneyline_bet_pct_homeIntnullable
moneyline_bet_pct_awayIntnullable
moneyline_money_pct_homeIntnullable
moneyline_money_pct_awayIntnullable
total_bet_pct_overIntnullable
total_bet_pct_underIntnullable
total_money_pct_overIntnullable
total_money_pct_underIntnullable
Relations (3)
gameNBAGames→ NBAGames

The nba.games row referenced by game_id; null when unlinked.

operatorReferenceOperators→ ReferenceOperators

The main.operators row referenced by operator_id; null when unlinked.

seasonNBASeasons→ NBASeasons

The nba.seasons row referenced by season_id; null when unlinked.

Arguments (6)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • season_idIntFilter by season.
  • operator_idIntFilter by sportsbook id: 6 Consensus (full history), 1 DraftKings, 2 FanDuel, 1683 Pinnacle, 1684 BetMGM, 1685 Caesars, 1686 BetRivers, 1687 ESPN BET (per-book rows begin 2026-05).
  • is_openingBooleanFilter to opening lines only. Reliable from the 2025-26 season; earlier seasons largely lack opener flags.
game_period_linesNBAGamePeriodLines
Period-specific NBA betting lines — first-half, second-half, and individual-quarter spreads, moneylines, and totals offered alongside the full-game markets.
Required filters: one of game_id.
Fields (19)
idBigIntkey

Primary Key

game_idBigInt→ NBAGames
ex: 769
season_idBigInt→ NBASeasons

Denormalized for efficient season-level queries

ex: 2025
operator_idBigInt→ ReferenceOperators

Data source (consensus, DraftKings, FanDuel, etc.)

ex: 6
period_codeString

Market period code (1H, 2H, Q1, Q2, Q3, Q4)

ex: 1HValues:1HQ1Q3Q4Q22H
spreadFloatnullable

Home team spread for this period

ex: -0.5
spread_home_oddsIntnullable

American odds for home spread (e.g., -110)

ex: -110
spread_away_oddsIntnullable

American odds for away spread

ex: -110
moneyline_homeIntnullable

American odds for home team win in this period

ex: -105
moneyline_awayIntnullable

American odds for away team win in this period

ex: -105
totalFloatnullable

Combined score total line for this period

ex: 57.5
over_oddsIntnullable

American odds for over

ex: -110
under_oddsIntnullable

American odds for under

ex: -110
implied_home_win_pctFloatnullable

From moneyline, 0-1

ex: 0.5121951219512195
implied_away_win_pctFloatnullable
ex: 0.5121951219512195
captured_atString

When this snapshot was captured

ex: 2024-01-05T05:00:00.000Z
is_openingBoolean

True if this is the first captured line for this period

ex: false
created_atString
updated_atString
Relations (3)
gameNBAGames→ NBAGames

The nba.games row referenced by game_id; null when unlinked.

operatorReferenceOperators→ ReferenceOperators

The main.operators row referenced by operator_id; null when unlinked.

seasonNBASeasons→ NBASeasons

The nba.seasons row referenced by season_id; null when unlinked.

Arguments (6)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • season_idIntFilter by season.
  • operator_idIntFilter by sportsbook.
  • period_codeStringFilter by period (1H, 2H, Q1, Q2, Q3, Q4).
game_player_propsNBAGamePlayerProps
NBA player prop bets for each game — points, rebounds, assists, threes made, steals, blocks, and other player-statistic markets offered by sportsbooks.
Required filters: one of game_id | player_id + season_id.
Fields (20)
idBigIntkey

Primary Key

game_idBigInt→ NBAGames
ex: 126
player_idBigInt→ NBAPlayers
ex: 157
season_idBigInt→ NBASeasons

Denormalized for efficient season-level queries

ex: 2025
operator_idBigInt→ ReferenceOperators

Usually consensus

ex: 6
categoryString

Canonical category (points, rebounds, assists, pra, etc.)

ex: pointsValues:pointsreboundsthree_pointers_madepts_reboundsdouble_doubleassistspts_rebounds_assistsrebounds_assistspts_assiststriple_doubleblockssteals
market_keyString

Raw market key from source API (e.g., player_points)

ex: player_pointsValues:player_pointsplayer_reboundsplayer_threesplayer_points_reboundsplayer_double_doubleplayer_assistsplayer_points_rebounds_assistsplayer_rebounds_assistsplayer_points_assistsplayer_triple_doubleplayer_blocksplayer_steals
subcategoryStringnullable

Optional subtype (alternate, boosted, etc.)

period_codeStringnullable

Optional period code (Q1, 1H)

outcome_typeString

ou | yes_no

ex: ouValues:ouyes_no
lineFloatnullable

Prop line for over/under markets (e.g., 24.5)

ex: 1.5
over_oddsIntnullable

American odds for over

ex: -120
under_oddsIntnullable

American odds for under

ex: -110
yes_oddsIntnullable

American odds for yes

ex: 1100
no_oddsIntnullable

American odds for no

ex: -10000
book_countInt

Number of curated books contributing to this consensus value

ex: 3
captured_atString

When this snapshot was captured

ex: 2025-10-22T04:00:00.000Z
is_openingBoolean

True if this is the first captured line for this player/market

ex: false
created_atString
updated_atString
Relations (4)
gameNBAGames→ NBAGames

The nba.games row referenced by game_id; null when unlinked.

operatorReferenceOperators→ ReferenceOperators

The main.operators row referenced by operator_id; null when unlinked.

playerNBAPlayers→ NBAPlayers

The nba.players row referenced by player_id; null when unlinked.

seasonNBASeasons→ NBASeasons

The nba.seasons row referenced by season_id; null when unlinked.

Arguments (8)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • player_idIntFilter to a single player. With season_id: the player's prop history across a season.
  • season_idIntFilter by season.
  • operator_idIntFilter by sportsbook. Historical rows are operator 6 (Consensus); per-book rows (1 DraftKings, 2 FanDuel, 1683 Pinnacle, 1684 BetMGM, 1685 Caesars, 1686 BetRivers, 1687 ESPN BET) begin 2026-05.
  • categoryStringFilter by prop category (points, rebounds, assists, pra, etc.).
  • market_keyStringFilter by raw market key (e.g., player_points).

Lineups & Roster

coaching_staffsNBACoachingStaffs
NBA coaches and staff — head coaches, lead assistants, player-development coaches, and other basketball-operations staff who appear on team benches.
Fields (7)
idBigIntkey

Primary Key

first_nameString
ex: Mike
last_nameString
ex: Jones
nameString
ex: Stacey Augmon
coach_idInt

Official NBA coach/staff ID (issued by the league)

ex: 57
created_atString
updated_atString
Relations (1)
team_coaching_staffs[NBATeamCoachingStaffs!]!→ NBATeamCoachingStaffs

nba.team_coaching_staffs rows whose coaching_staff_id references this row.

Arguments (2)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
team_coaching_staffsNBATeamCoachingStaffs
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.
Required filters: one of team_id.
Fields (11)
idBigIntkey

Primary Key

team_idBigInt→ NBATeams
ex: 26
season_idBigInt→ NBASeasons

First season of this tenure

ex: 2026
coach_typeString

Head Coach, Assistant Coach, Trainer

ex: Assistant CoachValues:Assistant CoachHead CoachTrainerAssistant Coach for Player DevelopmentAssociate Head CoachLead Assistant CoachAssistant TrainerStrength and Conditioning CoachDirector of Athletic DevelopmentInterim Head Coach
is_assistantBoolean
ex: trueValues:truefalse
sort_sequenceIntnullable
ex: 4
created_atString
updated_atString
start_dateString

Tenure start date (derived from season start)

ex: 2025-10-21
end_dateStringnullable

Tenure end date. NULL = still active.

ex: 2021-10-18
coaching_staff_idBigInt→ NBACoachingStaffs
ex: 96
Relations (3)
coaching_staffNBACoachingStaffs→ NBACoachingStaffs

The nba.coaching_staffs row referenced by coaching_staff_id; null when unlinked.

seasonNBASeasons→ NBASeasons

The nba.seasons row referenced by season_id; null when unlinked.

teamNBATeams→ NBATeams

The nba.teams row referenced by team_id; null when unlinked.

Arguments (5)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • team_idIntFilter by team.
  • season_idIntFilter to a season.
  • coach_typeStringFilter by coach role (Head Coach, Assistant Coach, Trainer).
game_team_lineup_stintsNBAGameTeamLineupStints
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.
Required filters: one of game_id.
Fields (27)
idBigIntkey

Primary Key

game_idBigInt→ NBAGames
ex: 127
team_idBigInt→ NBATeams
ex: 12
periodInt
ex: 2
player1_idBigInt→ NBAPlayers
ex: 57
player2_idBigInt→ NBAPlayers
ex: 197
player3_idBigInt→ NBAPlayers
ex: 187
player4_idBigInt→ NBAPlayers
ex: 294
player5_idBigInt→ NBAPlayers
ex: 258
start_clockInt
ex: 720
end_clockInt
ex: 0
start_event_seqInt
ex: 100
end_event_seqInt
ex: 7200
possessionsInt
ex: 1
pts_scoredInt
ex: 0
pts_allowedInt
ex: 0
created_atString
updated_atString
paceFloat
ex: 0.0000
offensive_ratingFloat
ex: 0.0000
defensive_ratingFloat
ex: 0.0000
net_ratingFloat
ex: 0.0000
offensive_rebound_pctFloat
ex: 0.0000
defensive_rebound_pctFloat
ex: 1.0000
assist_pctFloat
ex: 0.0000
turnover_pctFloat
ex: 0.0000
player_statsJSON

Array of individual player box scores and metrics recorded during this lineup stint.

ex: [object Object],[object Object],[object Object],[object Object],[object Object]
Relations (7)
gameNBAGames→ NBAGames

The nba.games row referenced by game_id; null when unlinked.

player1NBAPlayers→ NBAPlayers

The nba.players row referenced by player1_id; null when unlinked.

player2NBAPlayers→ NBAPlayers

The nba.players row referenced by player2_id; null when unlinked.

player3NBAPlayers→ NBAPlayers

The nba.players row referenced by player3_id; null when unlinked.

player4NBAPlayers→ NBAPlayers

The nba.players row referenced by player4_id; null when unlinked.

player5NBAPlayers→ NBAPlayers

The nba.players row referenced by player5_id; null when unlinked.

teamNBATeams→ NBATeams

The nba.teams row referenced by team_id; null when unlinked.

Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • team_idIntFilter by team.
game_team_rostersNBAGameTeamRosters
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.
Required filters: one of game_id.
Fields (14)
idBigIntkey

Primary Key

game_idBigInt→ NBAGames
ex: 724
team_idBigInt→ NBATeams
ex: 12
player_idBigInt→ NBAPlayers
ex: 197
positionStringnullable
ex: GValues:GFCG-FF-C
commentStringnullable

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.

ex: INACTIVE_GLEAGUE_TWOWAY
created_atString
updated_atString
statusIntnullable

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.

ex: 1
starterBooleannullable

mode=pre: in the starting lineup known before tip (null when no lineup was known). mode=full: started the game.

ex: falseValues:falsetrue
injury_statusStringnullable

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.

ex: OUTValues:OUTQUESTIONABLEPROBABLEDOUBTFUL
confirmedBooleannullable

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.

ex: true
depth_positionStringnullable

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.

depth_orderIntnullable

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.

Relations (3)
gameNBAGames→ NBAGames

The nba.games row referenced by game_id; null when unlinked.

playerNBAPlayers→ NBAPlayers

The nba.players row referenced by player_id; null when unlinked.

teamNBATeams→ NBATeams

The nba.teams row referenced by team_id; null when unlinked.

Arguments (11)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • team_idIntFilter by team.
  • player_idIntFilter to a single player.
  • positionStringFilter by player position (G, F, C, G-F, F-C).
  • statusIntFilter by roster availability code (1=Active, 2=Inactive, 3=Out), as the mode shows it.
  • injury_statusStringFilter by injury designation, as the mode shows it.
  • depth_orderIntFilter by depth-chart rank (e.g., 1 for the first player at each position).
  • depth_order__lteIntlte comparison on depth_order.
  • modeTimeWallModeTime wall: PRE (default) = values at the game's kickoff, post-game fields null; FULL = the latest values before week end.
team_depth_chartsNBATeamDepthCharts
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.
Required filters: one of team_id + season_id.
Fields (10)
idBigIntkey

Primary Key

team_idBigInt→ NBATeams
ex: 4
player_idBigInt→ NBAPlayers
ex: 428
season_idBigInt→ NBASeasons
ex: 2025
dayInt

YYYYMMDD snapshot day

ex: 20260214
positionString

PG, SG, SF, PF, C

ex: SFValues:SFSGPFPGC
depth_rankInt

1-based rank within position (1 = starter)

ex: 1
injury_statusStringnullable

Injury designation (Day-To-Day, Out, etc.)

ex: OutValues:OutDay-To-DaySuspension
created_atString
updated_atString
Relations (3)
playerNBAPlayers→ NBAPlayers

The nba.players row referenced by player_id; null when unlinked.

seasonNBASeasons→ NBASeasons

The nba.seasons row referenced by season_id; null when unlinked.

teamNBATeams→ NBATeams

The nba.teams row referenced by team_id; null when unlinked.

Arguments (9)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • team_idIntFilter by team.
  • season_idIntFilter to a season. Defaults to the current season.
  • positionStringFilter by position (PG, SG, SF, PF, C).
  • dayIntSnapshot day (YYYYMMDD integer). The table holds one snapshot per day; pass the latest day for the current depth chart.
  • day__gteIntgte comparison on day.
  • day__lteIntlte comparison on day.
  • day__betweenStringRange filter on day — pass "lo,hi".

Misc

stadiumsNBAStadiums
NBA arenas — current home venues and historical buildings the league's teams have played in.
Fields (21)
idBigIntkey

Primary Key

nameString
ex: Scotiabank Arena
league_stadium_idIntnullable

Official NBA arena ID (issued by the league)

ex: 643
longitudeFloatnullable
ex: -80.187
latitudeFloatnullable
ex: 25.7814
elevationFloatnullable

Elevation in feet above sea level

ex: 198
descriptionStringnullable
ex: Home of the Toronto Raptors. Multi-purpose arena in downtown Toronto, opened 1999.
cityString
ex: Orlando
stateStringnullable
ex: FL
countryStringnullable
Values:USGBFRDEAEJPCAMX
capacityIntnullable
surfaceStringnullable
roof_typeStringnullable

Arena roof type (all indoor)

opened_dateStringnullable
closed_dateStringnullable
team_nameStringnullable
timezoneStringnullable

IANA timezone (e.g., America/New_York)

ex: America/New_YorkValues: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
addressStringnullable
image_urlStringnullable

URL to aerial/overview image of arena

created_atString
updated_atString
Relations (2)
games[NBAGames!]!→ NBAGames

nba.games rows whose stadium_id references this row.

teams[NBATeams!]!→ NBATeams

nba.teams rows whose stadium_id references this row.

Arguments (2)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
broadcastersNBABroadcasters
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.
Fields (13)
idBigIntkey

Primary Key

broadcaster_scopeString
ex: localValues:localnational
broadcaster_mediaString
ex: tv
broadcaster_displayString
ex: BSIN
broadcaster_abbreviationString
ex: BSIN
broadcaster_descriptionStringnullable
tape_delay_commentsStringnullable
region_idInt
ex: 0
broadcaster_team_idInt
ex: 0
broadcaster_rankingInt
ex: 0
created_atString
updated_atString
Relations (1)
game_broadcasters[NBAGameBroadcasters!]!→ NBAGameBroadcasters

nba.game_broadcasters rows whose broadcaster_id references this row.

Arguments (2)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
refereesNBAReferees
NBA officials — the three-person crew of referees who work each game.
Fields (15)
idBigIntkey

Primary Key

first_nameString
ex: Biniam
last_nameString
ex: Scott
full_nameString
ex: Biniam Maru
jersey_numberStringnullable
ex: 94
nba_referee_idInt
ex: 202027
experienceIntnullable
activeBoolean
ex: true
birth_dateStringnullable
birth_cityStringnullable
birth_stateStringnullable
birth_countryStringnullable
collegeStringnullable
created_atString
updated_atString
Relations (1)
game_referees[NBAGameReferees!]!→ NBAGameReferees

nba.game_referees rows whose referee_id references this row.

Arguments (3)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • activeBooleanFilter by active status (defaults to true to show only currently-active rows; pass active=false to include inactive).
operator_team_lookupsNBAOperatorTeamLookups
How each sportsbook and fantasy operator names every NBA team — the mapping from each operator's team code to the unified franchise record.
Required filters: one of operator_id.
Fields (8)
idBigIntkey

Primary Key

operator_idBigInt→ ReferenceOperators

Reference to main.operator entity

ex: 1
operator_team_idString

External team ID from operator

ex: 2003
team_idBigInt→ NBATeams

Internal nba.teams.id reference

ex: 11
team_nameStringnullable

Team name for reconciliation

ex: Atlanta Hawks
abbreviationStringnullable

Team abbreviation for reconciliation

ex: ATL
created_atString
updated_atString
Relations (2)
operatorReferenceOperators→ ReferenceOperators

The main.operators row referenced by operator_id; null when unlinked.

teamNBATeams→ NBATeams

The nba.teams row referenced by team_id; null when unlinked.

Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • operator_idIntFilter by operator.
  • team_idIntFilter by team.
playoffsNBAPlayoffs
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.
Fields (14)
idBigIntkey

Primary Key

season_idBigInt→ NBASeasons
ex: 2020
series_idBigInt
ex: 202001
series_nameString
ex: East First RoundValues:East First RoundWest First RoundEast Play-InWest Play-InEast Conference SemifinalsWest Conference SemifinalsWest Conference FinalsEast Conference FinalsNBA Finals
home_team_idBigInt→ NBATeams
ex: 1
away_team_idBigInt→ NBATeams
ex: 13
home_team_winsInt
ex: 4
away_team_winsInt
ex: 0
games_playedInt
ex: 1
max_gamesInt
ex: 7
statusString
ex: Completed
series_textString
ex: MIA won 1-0
created_atString
updated_atString
Relations (3)
away_teamNBATeams→ NBATeams

The nba.teams row referenced by away_team_id; null when unlinked.

home_teamNBATeams→ NBATeams

The nba.teams row referenced by home_team_id; null when unlinked.

seasonNBASeasons→ NBASeasons

The nba.seasons row referenced by season_id; null when unlinked.

Arguments (2)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
game_broadcastersNBAGameBroadcasters
Which networks broadcast each NBA game — the national TV partner, home and away regional carriers, radio calls, and streaming providers.
Required filters: one of game_id.
Fields (6)
idBigIntkey

Primary Key

game_idBigInt→ NBAGames
ex: 15975
broadcaster_idBigInt→ NBABroadcasters
ex: 10
broadcaster_typeString
ex: awayTvValues:awayTvhomeTvnationalTv
created_atString
updated_atString
Relations (2)
broadcasterNBABroadcasters→ NBABroadcasters

The nba.broadcasters row referenced by broadcaster_id; null when unlinked.

gameNBAGames→ NBAGames

The nba.games row referenced by game_id; null when unlinked.

Arguments (5)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • broadcaster_idIntFilter by broadcaster.
  • broadcaster_typeStringFilter by broadcaster role.
game_refereesNBAGameReferees
The officiating crew assigned to each NBA game — the three referees who worked the matchup.
Required filters: one of game_id.
Fields (6)
idBigIntkey

Primary Key

game_idBigInt→ NBAGames
ex: 4727
referee_idBigInt→ NBAReferees
ex: 58
positionStringnullable
ex: RefereeValues:RefereeCrew ChiefUmpireALTERNATE
created_atString
updated_atString
Relations (2)
gameNBAGames→ NBAGames

The nba.games row referenced by game_id; null when unlinked.

refereeNBAReferees→ NBAReferees

The nba.referees row referenced by referee_id; null when unlinked.

Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • referee_idIntFilter by referee.
operator_player_lookupsNBAOperatorPlayerLookups
How each sportsbook and fantasy operator names every NBA player — the mapping from each operator's player identifier to a unified player record.
Required filters: one of operator_id.
Fields (11)
idBigIntkey

Primary Key

operator_idBigInt→ ReferenceOperators

Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo; every id is listed at /api/v1/reference/operators.

ex: 83
operator_player_idString

External player ID from operator

ex: 76001
player_idBigIntnullable→ NBAPlayers

Internal nba.players.id reference

ex: 521
player_nameStringnullable

Player name for reconciliation

ex: George Johnson
positionStringnullable

Position for reconciliation

ex: GValues:GFCG-FF-CUnknown
created_atString
updated_atString
decisionStringnullable

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.

ex: derived
decided_reasonStringnullable

Evidence behind a pinned or blocked decision.

decided_atStringnullable

When the pin or block was decided.

Relations (2)
operatorReferenceOperators→ ReferenceOperators

The main.operators row referenced by operator_id; null when unlinked.

playerNBAPlayers→ NBAPlayers

The nba.players row referenced by player_id; null when unlinked.

Arguments (4)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • operator_idIntFilter by operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo; every id is listed at /api/v1/reference/operators.
  • player_idIntFilter to a single player.
player_newsNBAPlayerNews
News about NBA players — trades, injuries, lineup decisions, suspensions, and general beat-reporter updates.
Required filters: one of player_id | team_id.
Fields (20)
idBigIntkey

Primary Key

player_idBigIntnullable→ NBAPlayers

Player ID associated with the news report.

ex: 165
team_idBigIntnullable→ NBATeams

Team ID of the player at the time of publication.

ex: 16
titleString

Headline of the news report.

ex: Assigned to D-League
descriptionStringnullable

Brief synopsis or summary of the news event.

ex: Murray was assigned Sunday to the D-League's Austin Spurs.
analysisStringnullable

Fantasy and tactical analysis of the news.

ex: Barton had to be helped back to the locker room during the third quarter of Monday's loss to the Ra…
news_timeString

Publication timestamp of the news story.

ex: 2016-11-27T19:29:13.000Z
priorityInt

Display priority score (1-10).

ex: 3
created_atString
updated_atString
contentStringnullable

Full text content of the news report.

authorStringnullable

Reporter or author of the article.

categoryStringnullable

injury, transaction, lineup, general

ai_processedBoolean

Whether this story was generated or enriched via LLM summarization.

ex: false
situational_impactJSONnullable

Structured situational impact assessment and fantasy implications for the player.

status_enumStringnullable

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).

urgencyStringnullable

Urgency level of the news event (BREAKING_GAME_TIME, HIGH, MEDIUM, ROUTINE).

first_reported_atStringnullable

Timestamp when this story was first reported before multi-source compaction.

opponent_team_idBigIntnullable→ NBATeams

Opponent team ID when this news item relates to an upcoming or active game matchup.

game_idBigIntnullable→ NBAGames

Associated game ID when this news item relates to a specific game.

Relations (4)
gameNBAGames→ NBAGames

The nba.games row referenced by game_id; null when unlinked.

opponent_teamNBATeams→ NBATeams

The nba.teams row referenced by opponent_team_id; null when unlinked.

playerNBAPlayers→ NBAPlayers

The nba.players row referenced by player_id; null when unlinked.

teamNBATeams→ NBATeams

The nba.teams row referenced by team_id; null when unlinked.

Arguments (11)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • player_idIntFilter to news about a single player.
  • team_idIntFilter by team — a team-level news feed, newest first.
  • categoryStringFilter by news category (injury, transaction, lineup, general).
  • status_enumStringFilter by player status designation.
  • urgencyStringFilter by news urgency.
  • news_timeStringFilter by publication time (ISO 8601). Use news_time__gte to poll for items since your last check.
  • news_time__gteStringgte comparison on news_time.
  • news_time__lteStringlte comparison on news_time.
  • news_time__betweenStringRange filter on news_time — pass "lo,hi".
team_game_contextsNBATeamGameContexts
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.
Required filters: one of game_id.
Fields (22)
idBigIntkey

Primary Key

game_idBigInt→ NBAGames
ex: 2374
team_idBigInt→ NBATeams
ex: 9
season_idBigInt→ NBASeasons
ex: 2024
opponent_team_idBigInt→ NBATeams
ex: 9
motivationString

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

ex: play_inValues:play_infringeearly_seasonseeding_battlecontendertankingplayoff_lockplayoff_competitiveplayoff_comfortableplayoff_desperateplayoff_clinchplayoff_eliminationist_contending
intensityInt

1-10 motivation intensity scale

ex: 5
season_phaseString

early, mid, late, final_push, postseason

ex: midValues:midlateearlyfinal_pushpostseason
season_pctFloat

0.0-1.0 how far through regular season

ex: 1.0000
game_typeString

regular, playoff, play_in, ist_group, ist_knockout, preseason, allstar

ex: regularValues:regularplayoffist_group
conference_rankInt
ex: 8
win_pctFloat
ex: 0.5000
games_remainingInt
ex: 0
team_series_winsInt
ex: 0
is_eliminationBoolean
ex: falseValues:falsetrue
is_clinchBoolean
ex: falseValues:falsetrue
ist_group_rankIntnullable
ist_group_recordStringnullable

e.g. 2-1

rest_daysInt
ex: 1
is_back_to_backBoolean
ex: falseValues:falsetrue
created_atString
updated_atString
Relations (4)
gameNBAGames→ NBAGames

The nba.games row referenced by game_id; null when unlinked.

opponent_teamNBATeams→ NBATeams

The nba.teams row referenced by opponent_team_id; null when unlinked.

seasonNBASeasons→ NBASeasons

The nba.seasons row referenced by season_id; null when unlinked.

teamNBATeams→ NBATeams

The nba.teams row referenced by team_id; null when unlinked.

Arguments (5)
  • firstIntPage size; clamped to the table's REST default/max limits.
  • afterBigIntKeyset cursor — returns rows with id > after, ordered by id ascending.
  • game_idIntFilter to a single game.
  • team_idIntFilter by team.
  • season_idIntFilter by season.