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.

REST endpoint →Open in playground →

Fields (8)

idBigIntkey

Primary Key

start_dateString

ex: 2020-12-22T00:00:00.000Z

end_dateStringnullable

ex: 2021-07-20T00:00:00.000Z

start_yearInt

ex: 2020

regular_season_start_dateStringnullable

ex: 2020-12-22T00:00:00.000Z

post_season_start_dateStringnullable

ex: 2021-05-22T00: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.

REST endpoint →Open in playground →

Fields (12)

idBigIntkey

Primary Key

abbreviationString

ex: BOS

cityString

ex: Los Angeles

league_team_idIntnullable→ NBATeams

Official NBA team ID from stats.nba.com

ex: 1610612738

conferenceString

ex: EasternValues:EasternWesternTest Conference

divisionString

ex: AtlanticValues:AtlanticCentralSoutheastNorthwestPacificSouthwestTest Division

full_nameString

ex: Boston Celtics

nameString

ex: Celtics

activeBoolean

ex: true

stadium_idBigIntnullable→ NBAStadiums

created_atString

updated_atString

Relations (22)

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.

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[NBAPlayerNews!]!→ NBAPlayerNews

nba.player_news rows whose team_id references this row.

players[NBAPlayers!]!→ NBAPlayers

nba.players 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_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.

games_by_home_team_id[NBAGames!]!→ NBAGames

nba.games rows whose home_team_id references this row.

games_by_away_team_id[NBAGames!]!→ NBAGames

nba.games 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.

playoffs_by_away_team_id[NBAPlayoffs!]!→ NBAPlayoffs

nba.playoffs rows whose away_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.

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.

REST endpoint →Open in playground →

Required filters: one of season_id.

Fields (30)

idBigIntkey

Primary Key

season_idBigInt→ NBASeasons

ex: 2023

game_timeString

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

league_game_idStringnullable→ NBAGames

Official NBA game ID from stats.nba.com

ex: 0022500650

home_team_idBigInt→ NBATeams

ex: 1

away_team_idBigInt→ NBATeams

ex: 1

statusString

ex: Final

start_timeString

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

end_timeStringnullable

ex: 2022-11-07T07:12: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: false

series_nameStringnullable

if_necessaryBooleannullable

series_game_numberStringnullable

game_labelStringnullable

game_sub_labelStringnullable

series_textStringnullable

postponed_statusStringnullable

created_atString

updated_atString

Relations (16)

seasonNBASeasons→ NBASeasons

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

home_team_refNBATeams→ NBATeams

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

away_team_refNBATeams→ NBATeams

The nba.teams row referenced by away_team_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.

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.

REST endpoint →Open in playground →

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→ NBAPlayers

Official NBA player ID from stats.nba.com. Stable across seasons; use for cross-API joins to nba_stats sources.

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 (e.g., for stats.nba.com 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 (per stats.nba.com).

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 stats.nba.com: "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 (16)

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.

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.

REST endpoint →Open in playground →

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

REST endpoint →Open in playground →

Required filters: one of game_id.

Fields (23)

idBigIntkey

Primary Key

play_idString

ex: 0052400111_2

nba_event_numInt

ex: 2

game_possession_idBigInt

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

ex: 49

player2_team_idBigIntnullable→ NBATeams

ex: 21

player3_idBigIntnullable

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 (stats.nba.com 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.

REST endpoint →Open in playground →

Required filters: one of season_id.

Fields (11)

idBigIntkey

Primary Key

team_idBigInt→ NBATeams

ex: 11

season_idBigInt→ NBASeasons

ex: 2024

games_playedInt

ex: 82

winsInt

ex: 48

lossesInt

ex: 32

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.

REST endpoint →Open in playground →

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.

REST endpoint →Open in playground →

Required filters: one of game_id | player_id.

Fields (118)

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: 31.7000

ptsInt

ex: 0

assistsInt

ex: 0

reboundsInt

ex: 2

stealsInt

ex: 0

blocksInt

ex: 0

turnoversInt

ex: 0

foulsInt

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

ex: 0

balls_stolenIntnullable

ex: 0

loose_balls_recoveredIntnullable

ex: 0

personal_foulsInt

ex: 1

offensive_foulsInt

ex: 0

technical_foulsInt

ex: 0

flagrant_fouls_type_1Int

ex: 0

flagrant_fouls_type_2Int

ex: 0

clear_path_foulsInt

ex: 0

fouls_drawnInt

ex: 0

and_onesInt

ex: 0

traveling_violationsInt

ex: 0

double_dribble_violationsInt

ex: 0

carrying_palming_violationsInt

ex: 0

backcourt_violationsInt

ex: 0

shot_clock_violationsInt

ex: 0

lane_violationsInt

ex: 0

goaltending_violationsInt

ex: 0

basket_interference_violationsInt

ex: 0

substitutions_inInt

ex: 0

substitutions_outInt

ex: 0

jump_balls_wonInt

ex: 0

jump_balls_lostInt

ex: 0

timeouts_calledInt

ex: 0

challenges_requestedInt

ex: 0

shot_contested_countIntnullable

ex: 1

dunksInt

ex: 0

layupsInt

ex: 0

alley_oopsInt

ex: 0

put_backsInt

ex: 0

fast_break_ptsInt

ex: 0

second_chance_ptsInt

ex: 0

hockey_assistsIntnullable

ex: 0

screen_assistsIntnullable

ex: 0

box_outsIntnullable

ex: 0

ejectionsInt

ex: 0

plus_minusInt

ex: 0

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

estimated_paceFloatnullable

ex: 84.7100

possessionsInt

ex: 53

touchesIntnullable

ex: 28

front_court_touchesIntnullable

ex: 14

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: 18

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.

REST endpoint →Open in playground →

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: 0

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: 14

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: 0.0000

offensive_rebound_percentageFloat

ex: 0.3330

defensive_rebound_percentageFloat

ex: 0.6670

rebound_percentageFloat

ex: 0.5000

turnover_percentageFloat

ex: 0.0000

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

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

pct_fga_3ptFloat

ex: 0.0000

pct_pts_2ptFloat

ex: 0.5000

pct_pts_2pt_mrFloat

ex: 0.0000

pct_pts_3ptFloat

ex: 0.0000

pct_pts_fbFloat

ex: 0.0000

pct_pts_ftFloat

ex: 0.0000

pct_pts_off_tovFloat

ex: 0.0000

pct_pts_paintFloat

ex: 0.0000

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: 0

lossesInt

Cumulative losses

ex: 0

conference_rankInt

Conference rank entering game

ex: 0

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

REST endpoint →Open in playground →

Required filters: one of season_id | player_id.

Fields (51)

idBigIntkey

Primary Key

player_idBigInt→ NBAPlayers

ex: 1

season_idBigInt→ NBASeasons

ex: 2021

games_playedInt

ex: 1

created_atString

updated_atString

winsInt

ex: 1

lossesInt

ex: 0

minutesFloat

ex: 5.3000

ptsInt

ex: 0

assistsInt

ex: 0

reboundsInt

ex: 2

stealsInt

ex: 0

blocksInt

ex: 0

turnoversInt

ex: 0

foulsInt

ex: 0

field_goals_madeInt

ex: 1

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: 2

plus_minusInt

ex: 5

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: 112.5000

defensive_ratingFloat

ex: 100.0000

net_ratingFloat

ex: 2.7000

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

turnover_percentageFloat

ex: 0.0000

effective_field_goal_percentageFloat

ex: 0.5000

true_shooting_percentageFloat

ex: 0.0000

usage_percentageFloat

ex: 0.1670

paceFloat

ex: 100.0000

player_impact_estimateFloat

ex: 0.0670

possessionsInt

ex: 43

touchesInt

ex: 0

front_court_touchesInt

ex: 0

time_of_possessionFloat

ex: 0.0000

avg_seconds_per_touchFloat

ex: 0.0000

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.

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.

REST endpoint →Open in playground →

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: 0

under_oddsIntnullable

American odds for under

ex: 0

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.

REST endpoint →Open in playground →

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.

REST endpoint →Open in playground →

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.

REST endpoint →Open in playground →

Fields (7)

idBigIntkey

Primary Key

first_nameString

ex: Mike

last_nameString

ex: Jones

nameString

ex: Stacey Augmon

coach_idInt

Official NBA coach/staff ID from stats.nba.com

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.

REST endpoint →Open in playground →

Required filters: one of team_id.

Fields (11)

idBigIntkey

Primary Key

team_idBigInt→ NBATeams

ex: 8

season_idBigInt→ NBASeasons

First season of this tenure

ex: 2025

coach_typeString

Head Coach, Assistant Coach, Trainer

ex: Assistant CoachValues:Assistant CoachHead CoachTrainerAssistant Coach for Player DevelopmentAssociate Head CoachAssistant TrainerStrength and Conditioning CoachLead Assistant 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-21T04:00:00.000Z

end_dateStringnullable

Tenure end date. NULL = still active.

ex: 2021-10-18T04:00:00.000Z

coaching_staff_idBigInt

ex: 346

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.

REST endpoint →Open in playground →

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

ex: 53

player2_idBigInt

ex: 197

player3_idBigInt

ex: 187

player4_idBigInt

ex: 178

player5_idBigInt

ex: 258

start_clockInt

ex: 720

end_clockInt

ex: 0

start_event_seqInt

ex: 100

end_event_seqInt

ex: 7200

possessionsInt

ex: 2

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

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

REST endpoint →Open in playground →

Required filters: one of game_id.

Fields (17)

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

ex: INACTIVE_GLEAGUE_TWOWAY

dayInt

ex: 20260207

created_atString

updated_atString

pre_game_statusIntnullable

Pre-tip roster availability: 1=Active, 2=Inactive, 3=Out

ex: 1

pre_game_starterBooleannullable

Pre-tip expected starter flag from lineup sources

ex: falseValues:falsetrue

pre_game_injury_statusStringnullable

Pre-tip injury designation: OUT, DOUBTFUL, QUESTIONABLE, PROBABLE

ex: OUTValues:OUTQUESTIONABLEPROBABLEDOUBTFUL

pre_game_confirmedBooleannullable

Pre-tip lineup confidence from source (e.g. RotoWire confirmed vs expected)

ex: true

statusIntnullable

Reconciled final roster availability: 1=Active, 2=Inactive, 3=Out

ex: 1

starterBooleannullable

Whether the player was in the starting five (reconciled post-game)

ex: falseValues:falsetrue

injury_statusStringnullable

Reconciled final injury designation for the roster row

ex: OUTValues:OUTQUESTIONABLEPROBABLEDOUBTFUL

confirmedBooleannullable

Whether the starter truth was established from post-game evidence

ex: true

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 (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.
player_idIntFilter to a single player.

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.

REST endpoint →Open in playground →

Required filters: one of team_id + season_id.

Fields (10)

idBigIntkey

Primary Key

team_idBigInt→ NBATeams

ex: 4

player_idBigInt→ NBAPlayers

ex: 337

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

Day-To-Day, Out, etc. from ESPN

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.

REST endpoint →Open in playground →

Fields (21)

idBigIntkey

Primary Key

nameString

ex: Scotiabank Arena

league_stadium_idIntnullable→ NBAStadiums

Official NBA arena ID from stats.nba.com

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: Miami

stateStringnullable

ex: CA

countryStringnullable

ex: USValues:USCAGBFRMXDE

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/Berlin

addressStringnullable

image_urlStringnullable

URL to aerial/overview image of arena

created_atString

updated_atString

Relations (2)

teams[NBATeams!]!→ NBATeams

nba.teams rows whose stadium_id references this row.

games[NBAGames!]!→ NBAGames

nba.games 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.

refereesNBAReferees

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

REST endpoint →Open in playground →

Fields (15)

idBigIntkey

Primary Key

first_nameString

ex: Biniam

last_nameString

ex: Maru

full_nameString

ex: Biniam Maru

jersey_numberStringnullable

ex: 94

nba_referee_idInt→ NBAReferees

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

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.

REST endpoint →Open in playground →

Fields (14)

idBigIntkey

Primary Key

broadcaster_scopeString

ex: localValues:localnational

broadcaster_mediaString

ex: tv

broadcaster_idInt→ NBABroadcasters

ex: 0

broadcaster_displayString

ex: BSIN

broadcaster_abbreviationString

ex: BSIN

broadcaster_descriptionStringnullable

tape_delay_commentsStringnullable

broadcaster_video_linkStringnullable

region_idInt

ex: 0

broadcaster_team_idInt→ NBATeams

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.

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.

REST endpoint →Open in playground →

Required filters: one of operator_id.

Fields (8)

idBigIntkey

Primary Key

operator_idBigInt→ ReferenceOperators

Reference to main.operator entity

ex: 1

operator_team_idString→ NBATeams

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.

REST endpoint →Open in playground →

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: CompletedValues:CompletedActive

series_textString

ex: MIA won 1-0

created_atString

updated_atString

Relations (3)

seasonNBASeasons→ NBASeasons

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

home_teamNBATeams→ NBATeams

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

away_teamNBATeams→ NBATeams

The nba.teams row referenced by away_team_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.

REST endpoint →Open in playground →

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.

REST endpoint →Open in playground →

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.

REST endpoint →Open in playground →

Required filters: one of operator_id.

Fields (8)

idBigIntkey

Primary Key

operator_idBigInt→ ReferenceOperators

Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo, 13 sportsdata.io, 83 stats.nba.com.

ex: 83

operator_player_idString→ NBAPlayers

External player ID from operator

ex: 76001

player_idBigInt→ 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

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, 13 sportsdata.io, 83 stats.nba.com.
player_idIntFilter to a single player.

player_newsNBAPlayerNews

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

REST endpoint →Open in playground →

Required filters: one of player_id | team_id.

Fields (18)

idBigIntkey

Primary Key

player_idBigIntnullable→ NBAPlayers

ex: 165

team_idBigIntnullable→ NBATeams

ex: 16

titleString

ex: Assigned to D-League

descriptionStringnullable

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

analysisStringnullable

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

sourceStringnullable

ex: rotowire

linkStringnullable

news_timeString

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

priorityInt

ex: 3

created_atString

updated_atString

contentStringnullable

authorStringnullable

categoryStringnullable

injury, transaction, lineup, general

external_idStringnullable

ex: rotoql-14973

ai_processedBoolean

ex: false

situational_impactJSONnullable

Relations (2)

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

REST endpoint →Open in playground →

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.

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.

opponent_teamNBATeams→ NBATeams

The nba.teams row referenced by opponent_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.