nbadbArena Data Lab
Schema ReferenceHalf-Court MapStaging Reference44 waypoints

Court Geometry

Schema Reference — Staging

Complete schema docs for staging tier

Generated pageCommand-ownedSchema metadata

Generated schema contract

Use staging reference to verify cleanup before transforms

This is the half-court contract: normalized columns, typed data, and load-ready keys before star-schema transforms begin. Use it to verify cleanup choices without reading transform code first.

Best for
Cleanup verification

confirm renamed fields, typing, and foreign-key hints in the warehouse-ready layer

Best clue
FK hints

staging blocks often reveal the intended join anchors for downstream models

Ownership
Command-owned

regenerate from schema metadata instead of hand-editing

How to work this page
1

Compare to the raw contract only when needed

Staging is already cleaned up, so use raw reference only to answer what changed rather than rereading both pages in full.

2

Focus on renamed identifiers and typed columns

Those are usually the signals that matter most when you are planning joins or debugging transform assumptions.

3

Follow dependencies once the shape is clear

Switch to lineage or relationships when the next question is about impact radius or join strategy.

Quick scan

Group staging contracts by cleanup lane

Use the clustered anchors to find the normalized staging block first, then read constraints and nullability in context.

43 schema blocks26 Staging familiesTOC-driven
League Dash

Jump into the matching table family, then read the exact block.

2
Play By

Jump into the matching table family, then read the exact block.

2
Player Shoot

Jump into the matching table family, then read the exact block.

2
Arena Info

Jump into the matching table family, then read the exact block.

1
Common All

Jump into the matching table family, then read the exact block.

1
Common Team

Jump into the matching table family, then read the exact block.

1
Draft Combine

Jump into the matching table family, then read the exact block.

1
Draft History

Jump into the matching table family, then read the exact block.

1
Game Leaders

Jump into the matching table family, then read the exact block.

1
Game Rotation

Jump into the matching table family, then read the exact block.

1
League Game

Jump into the matching table family, then read the exact block.

1
League Lineup

Jump into the matching table family, then read the exact block.

1
League Standings

Jump into the matching table family, then read the exact block.

1
Player Game

Jump into the matching table family, then read the exact block.

1
Player Index

Jump into the matching table family, then read the exact block.

1
Player Perf

Jump into the matching table family, then read the exact block.

1
Schedule League

Jump into the matching table family, then read the exact block.

1
Scoreboard V2

Jump into the matching table family, then read the exact block.

1
Shot Chart

Jump into the matching table family, then read the exact block.

1
Synergy Play

Jump into the matching table family, then read the exact block.

1
Team Details

Jump into the matching table family, then read the exact block.

1
Team Game

Jump into the matching table family, then read the exact block.

1
Team Info

Jump into the matching table family, then read the exact block.

1
Win Probability

Jump into the matching table family, then read the exact block.

1

Schema Reference — Staging

This tier contains 43 schema(s).

staging_arena_info

Class: StagingArenaInfoSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNoUnique game identifier
arena_idInt64YesArena identifier
arena_nameStringYesArena name
arena_cityStringYesArena city
arena_stateStringYesArena state or province
arena_countryStringYesArena country
arena_timezoneStringYesArena timezone

staging_box_score_advanced_player

Class: StagingBoxScoreAdvancedPlayerSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNoUnique game identifier
team_idInt64NoFK→staging_team.team_idTeam identifier
player_idInt64Nogt=0, FK→staging_player.person_idUnique player identifier
player_nameStringYesPlayer full name
minStringYesMinutes played as string
e_off_ratingFloat64YesEstimated offensive rating
off_ratingFloat64YesOffensive rating
e_def_ratingFloat64YesEstimated defensive rating
def_ratingFloat64YesDefensive rating
e_net_ratingFloat64YesEstimated net rating
net_ratingFloat64YesNet rating
ast_pctFloat64YesAssist percentage
ast_tovFloat64YesAssist to turnover ratio
ast_ratioFloat64YesAssist ratio
oreb_pctFloat64YesOffensive rebound percentage
dreb_pctFloat64YesDefensive rebound percentage
reb_pctFloat64YesTotal rebound percentage
tov_pctFloat64YesTurnover percentage
efg_pctFloat64YesEffective field goal percentage
ts_pctFloat64YesTrue shooting percentage
usg_pctFloat64YesUsage percentage
e_usg_pctFloat64YesEstimated usage percentage
e_paceFloat64YesEstimated pace
paceFloat64YesPace factor
pace_per40Float64YesPace per 40 minutes
possFloat64YesPossessions
pieFloat64YesPlayer impact estimate

staging_box_score_defensive_player

Class: StagingBoxScoreDefensivePlayerSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNoUnique game identifier
team_idInt64NoFK→staging_team.team_idTeam identifier
player_idInt64Nogt=0, FK→staging_player.person_idUnique player identifier
player_nameStringYesPlayer full name
minStringYesMinutes played as string
matchup_minFloat64YesMinutes in matchup defense
partial_possFloat64YesPartial possessions defended
switches_onFloat64YesNumber of defensive switches
player_ptsFloat64YesPoints allowed on defense
def_fgmFloat64YesDefended field goals made
def_fgaFloat64YesDefended field goals attempted
def_fg_pctFloat64YesDefended field goal percentage

staging_box_score_four_factors_player

Class: StagingBoxScoreFourFactorsPlayerSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNoUnique game identifier
team_idInt64NoFK→staging_team.team_idTeam identifier
player_idInt64Nogt=0, FK→staging_player.person_idUnique player identifier
player_nameStringYesPlayer full name
minStringYesMinutes played as string
effective_field_goal_percentageFloat64YesEffective field goal percentage
free_throw_attempt_rateFloat64YesFree throw attempt rate
team_turnover_percentageFloat64YesTeam turnover percentage
offensive_rebound_percentageFloat64YesOffensive rebound percentage
opp_effective_field_goal_percentageFloat64YesOpponent effective field goal percentage
opp_free_throw_attempt_rateFloat64YesOpponent free throw attempt rate
opp_team_turnover_percentageFloat64YesOpponent team turnover percentage
opp_offensive_rebound_percentageFloat64YesOpponent offensive rebound percentage

staging_box_score_four_factors_team

Class: StagingBoxScoreFourFactorsTeamSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNoUnique game identifier
team_idInt64NoFK→staging_team.team_idTeam identifier
team_nameStringYesTeam name
team_abbreviationStringYesTeam abbreviation code
effective_field_goal_percentageFloat64YesEffective field goal percentage
free_throw_attempt_rateFloat64YesFree throw attempt rate
team_turnover_percentageFloat64YesTeam turnover percentage
offensive_rebound_percentageFloat64YesOffensive rebound percentage
opp_effective_field_goal_percentageFloat64YesOpponent effective field goal percentage
opp_free_throw_attempt_rateFloat64YesOpponent free throw attempt rate
opp_team_turnover_percentageFloat64YesOpponent team turnover percentage
opp_offensive_rebound_percentageFloat64YesOpponent offensive rebound percentage

staging_box_score_hustle_player

Class: StagingBoxScoreHustlePlayerSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNoUnique game identifier
team_idInt64NoFK→staging_team.team_idTeam identifier
player_idInt64Nogt=0, FK→staging_player.person_idUnique player identifier
player_nameStringYesPlayer full name
minStringYesMinutes played as string
contested_shotsFloat64YesContested shots
contested_shots_2ptFloat64YesContested two-point shots
contested_shots_3ptFloat64YesContested three-point shots
deflectionsFloat64YesDeflections
charges_drawnFloat64YesCharges drawn
screen_assistsFloat64YesScreen assists
screen_ast_ptsFloat64YesPoints from screen assists
loose_balls_recoveredFloat64YesLoose balls recovered
box_outsFloat64YesBox outs

staging_box_score_matchups

Class: StagingBoxScoreMatchupsSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNoFK→staging_game_log.game_idUnique game identifier
off_team_idInt64Yesgt=0, FK→staging_team.team_idOffensive team identifier
off_team_abbreviationStringYesOffensive team abbreviation
def_team_idInt64Yesgt=0, FK→staging_team.team_idDefensive team identifier
def_team_abbreviationStringYesDefensive team abbreviation
off_player_idInt64Yesgt=0, FK→staging_player.person_idOffensive player identifier
off_player_nameStringYesOffensive player name
def_player_idInt64Yesgt=0, FK→staging_player.person_idDefensive player identifier
def_player_nameStringYesDefensive player name
matchup_minFloat64YesMinutes in matchup
partial_possFloat64YesPartial possessions in matchup
player_ptsFloat64YesPlayer points in matchup
team_ptsFloat64YesTeam points in matchup
matchup_astFloat64YesAssists in matchup
matchup_tovFloat64YesTurnovers in matchup
matchup_blkFloat64YesBlocks in matchup
matchup_fgmFloat64YesField goals made in matchup
matchup_fgaFloat64YesField goals attempted
matchup_fg_pctFloat64YesField goal pct in matchup
matchup_fg3mFloat64YesThree-pointers made
matchup_fg3aFloat64YesThree-pointers attempted
matchup_fg3_pctFloat64YesThree-point pct in matchup
help_blkFloat64YesHelp blocks in matchup
help_fgmFloat64YesHelp field goals made
help_fgaFloat64YesHelp field goals attempted
help_fg_pctFloat64YesHelp field goal percentage
matchup_ftmFloat64YesFree throws made in matchup
matchup_ftaFloat64YesFree throws attempted
switches_onFloat64YesSwitches onto player

staging_box_score_player_track

Class: StagingBoxScorePlayerTrackSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNoUnique game identifier
team_idInt64NoFK→staging_team.team_idTeam identifier
player_idInt64Nogt=0, FK→staging_player.person_idUnique player identifier
player_nameStringYesPlayer full name
minStringYesMinutes played as string
spdFloat64YesAverage speed in mph
distFloat64YesDistance covered in miles
orbcFloat64YesOffensive rebound chances
drbcFloat64YesDefensive rebound chances
rbcFloat64YesTotal rebound chances
tchsFloat64YesTouches
sastFloat64YesSecondary assists
ftastFloat64YesFree throw assists
passFloat64YesPasses made
cfgmFloat64YesContested field goals made
cfgaFloat64YesContested field goals attempted
cfg_pctFloat64YesContested field goal percentage
ufgmFloat64YesUncontested field goals made
ufgaFloat64YesUncontested field goals attempted
ufg_pctFloat64YesUncontested field goal percentage
dfgmFloat64YesDefended field goals made
dfgaFloat64YesDefended field goals attempted
dfg_pctFloat64YesDefended field goal percentage

staging_box_score_traditional_player

Class: StagingBoxScoreTraditionalPlayerSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNoUnique game identifier
team_idInt64NoFK→staging_team.team_idTeam identifier
team_abbreviationStringYesTeam abbreviation code
team_cityStringYesTeam city name
player_idInt64Nogt=0, FK→staging_player.person_idUnique player identifier
player_nameStringYesPlayer full name
nicknameStringYesPlayer nickname
start_positionStringYesStarting position (F/C/G)
commentStringYesPlayer status comment
minStringYesMinutes played as string
fgmFloat64YesField goals made
fgaFloat64YesField goals attempted
fg_pctFloat64YesField goal percentage
fg3mFloat64YesThree-point field goals made
fg3aFloat64YesThree-point field goals attempted
fg3_pctFloat64YesThree-point field goal percentage
ftmFloat64YesFree throws made
ftaFloat64YesFree throws attempted
ft_pctFloat64YesFree throw percentage
orebFloat64YesOffensive rebounds
drebFloat64YesDefensive rebounds
rebFloat64YesTotal rebounds
astFloat64YesAssists
stlFloat64YesSteals
blkFloat64YesBlocks
tovFloat64YesTurnovers
pfFloat64YesPersonal fouls
ptsFloat64YesPoints scored
plus_minusFloat64YesPlus-minus differential

staging_box_score_traditional_team

Class: StagingBoxScoreTraditionalTeamSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNoUnique game identifier
team_idInt64NoFK→staging_team.team_idTeam identifier
team_nameStringYesTeam name
team_abbreviationStringYesTeam abbreviation code
team_cityStringYesTeam city name
minFloat64YesTotal team minutes played
fgmFloat64YesField goals made
fgaFloat64YesField goals attempted
fg_pctFloat64YesField goal percentage
fg3mFloat64YesThree-point field goals made
fg3aFloat64YesThree-point field goals attempted
fg3_pctFloat64YesThree-point field goal percentage
ftmFloat64YesFree throws made
ftaFloat64YesFree throws attempted
ft_pctFloat64YesFree throw percentage
orebFloat64YesOffensive rebounds
drebFloat64YesDefensive rebounds
rebFloat64YesTotal rebounds
astFloat64YesAssists
stlFloat64YesSteals
blkFloat64YesBlocks
tovFloat64YesTurnovers
pfFloat64YesPersonal fouls
ptsFloat64YesPoints scored
plus_minusFloat64YesPlus-minus differential

staging_common_all_players

Class: StagingCommonAllPlayersSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
person_idInt64Nogt=0Unique player identifier
display_last_comma_firstStringYesPlayer name as Last, First
display_first_lastStringNoPlayer name as First Last
roster_statusInt64Yesin=[0, 1]Active roster flag (0 or 1)
from_yearStringYesFirst year in the league
to_yearStringYesLast year in the league
playercodeStringYesPlayer code slug
team_idInt64YesFK→staging_team.team_idTeam identifier
team_cityStringYesTeam city name
team_nameStringYesTeam name
team_abbreviationStringYesTeam abbreviation code
team_codeStringYesTeam code slug
games_played_flagStringYesFlag indicating games played

staging_common_team_years

Class: StagingCommonTeamYearsSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
league_idStringNoLeague identifier
team_idInt64Nogt=0Unique team identifier
min_yearStringYesFirst year of team activity
max_yearStringYesLast year of team activity
abbreviationStringNoTeam abbreviation code

staging_draft_combine_stats

Class: StagingDraftCombineStatsSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
seasonStringNoCombine season year
player_idInt64Nogt=0, FK→staging_player.person_idUnique player identifier
first_nameStringYesPlayer first name
last_nameStringYesPlayer last name
player_nameStringYesPlayer full name
positionStringYesPlayer position
height_wo_shoesFloat64Yesgt=0Height without shoes in inches
height_wo_shoes_ft_inStringYesHeight without shoes in feet-inches
height_w_shoesFloat64Yesgt=0Height with shoes in inches
height_w_shoes_ft_inStringYesHeight with shoes in feet-inches
weightFloat64Yesgt=0Player weight in pounds
wingspanFloat64Yesgt=0Wingspan in inches
wingspan_ft_inStringYesWingspan in feet-inches
standing_reachFloat64Yesgt=0Standing reach in inches
standing_reach_ft_inStringYesStanding reach in feet-inches
body_fat_pctFloat64YesBody fat percentage
hand_lengthFloat64Yesgt=0Hand length in inches
hand_widthFloat64Yesgt=0Hand width in inches
standing_vertical_leapFloat64Yesgt=0Standing vertical leap in inches
max_vertical_leapFloat64Yesgt=0Maximum vertical leap in inches
lane_agility_timeFloat64Yesgt=0Lane agility drill time in seconds
modified_lane_agility_timeFloat64Yesgt=0Modified lane agility time in seconds
three_quarter_sprintFloat64Yesgt=0Three-quarter court sprint time in seconds
bench_pressFloat64YesBench press repetitions

staging_draft_history

Class: StagingDraftHistorySchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
person_idInt64Nogt=0, FK→staging_player.person_idUnique player identifier
player_nameStringYesPlayer full name
seasonStringNoDraft season year
round_numberInt64Yesin=[1, 2]Draft round number
round_pickInt64Yesgt=0Pick number within the round
overall_pickInt64Yesgt=0Overall draft pick number
draft_typeStringYesType of draft
team_idInt64YesFK→staging_team.team_idTeam identifier
team_cityStringYesTeam city name
team_nameStringYesTeam name
team_abbreviationStringYesTeam abbreviation code
organizationStringYesPre-draft organization
organization_typeStringYesType of pre-draft organization
player_profile_flagInt64YesPlayer profile availability flag

staging_game_leaders

Class: StagingGameLeadersSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNoUnique game identifier
team_idInt64Nogt=0, FK→staging_team.team_idTeam identifier
leader_typeStringNoLeader category (home or away)
person_idInt64Nogt=0, FK→staging_player.person_idUnique player identifier
nameStringNoPlayer display name
player_slugStringYesPlayer URL slug
jersey_numStringYesPlayer jersey number
positionStringYesPlayer position
team_tricodeStringYesThree-letter team code
pointsFloat64YesPoints scored
reboundsFloat64YesTotal rebounds
assistsFloat64YesTotal assists

staging_game_rotation

Class: StagingGameRotationSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNoUnique game identifier
team_idInt64YesFK→staging_team.team_idTeam identifier
team_cityStringYesTeam city name
team_nameStringYesTeam name
person_idInt64YesFK→staging_player.person_idPlayer person identifier
player_firstStringYesPlayer first name
player_lastStringYesPlayer last name
in_time_realFloat64YesReal time player entered game
out_time_realFloat64YesReal time player exited game
player_ptsFloat64YesPoints scored during stint
pt_diffFloat64YesPoint differential during stint
usg_pctFloat64YesUsage percentage during stint

staging_league_dash_player_stats

Class: StagingLeagueDashPlayerStatsSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
player_idInt64NoFK→staging_player.person_idUnique player identifier
player_nameStringYesPlayer full name
team_idInt64NoFK→staging_team.team_idTeam identifier
team_abbreviationStringYesTeam abbreviation code
ageFloat64YesPlayer age
gpInt64YesGames played
wInt64YesWins
lInt64YesLosses
w_pctFloat64YesWin percentage
minFloat64YesMinutes played
fgmFloat64YesField goals made
fgaFloat64YesField goals attempted
fg_pctFloat64YesField goal percentage
fg3mFloat64YesThree-point field goals made
fg3aFloat64YesThree-point field goals attempted
fg3_pctFloat64YesThree-point field goal percentage
ftmFloat64YesFree throws made
ftaFloat64YesFree throws attempted
ft_pctFloat64YesFree throw percentage
orebFloat64YesOffensive rebounds
drebFloat64YesDefensive rebounds
rebFloat64YesTotal rebounds
astFloat64YesAssists
tovFloat64YesTurnovers
stlFloat64YesSteals
blkFloat64YesBlocks
blkaFloat64YesBlocked attempts
pfFloat64YesPersonal fouls
pfdFloat64YesPersonal fouls drawn
ptsFloat64YesPoints scored
plus_minusFloat64YesPlus-minus differential
nba_fantasy_ptsFloat64YesNBA fantasy points
dd2Float64YesDouble-doubles
td3Float64YesTriple-doubles
gp_rankInt64YesGames played rank
w_rankInt64YesWins rank
l_rankInt64YesLosses rank
w_pct_rankInt64YesWin percentage rank
min_rankInt64YesMinutes played rank
fgm_rankInt64YesField goals made rank
fga_rankInt64YesField goals attempted rank
fg_pct_rankInt64YesField goal percentage rank
fg3m_rankInt64YesThree-point field goals made rank
fg3a_rankInt64YesThree-point field goals attempted rank
fg3_pct_rankInt64YesThree-point percentage rank
ftm_rankInt64YesFree throws made rank
fta_rankInt64YesFree throws attempted rank
ft_pct_rankInt64YesFree throw percentage rank
oreb_rankInt64YesOffensive rebounds rank
dreb_rankInt64YesDefensive rebounds rank
reb_rankInt64YesTotal rebounds rank
ast_rankInt64YesAssists rank
tov_rankInt64YesTurnovers rank
stl_rankInt64YesSteals rank
blk_rankInt64YesBlocks rank
blka_rankInt64YesBlocked attempts rank
pf_rankInt64YesPersonal fouls rank
pfd_rankInt64YesPersonal fouls drawn rank
pts_rankInt64YesPoints scored rank
plus_minus_rankInt64YesPlus-minus rank
nba_fantasy_pts_rankInt64YesNBA fantasy points rank
dd2_rankInt64YesDouble-doubles rank
td3_rankInt64YesTriple-doubles rank
cfidInt64YesCustom filter identifier
cfparamsStringYesCustom filter parameters

staging_league_dash_team_stats

Class: StagingLeagueDashTeamStatsSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
team_idInt64NoFK→staging_team.team_idUnique team identifier
team_nameStringYesTeam name
gpInt64YesGames played
wInt64YesWins
lInt64YesLosses
w_pctFloat64YesWin percentage
minFloat64YesMinutes played
fgmFloat64YesField goals made
fgaFloat64YesField goals attempted
fg_pctFloat64YesField goal percentage
fg3mFloat64YesThree-point field goals made
fg3aFloat64YesThree-point field goals attempted
fg3_pctFloat64YesThree-point field goal percentage
ftmFloat64YesFree throws made
ftaFloat64YesFree throws attempted
ft_pctFloat64YesFree throw percentage
orebFloat64YesOffensive rebounds
drebFloat64YesDefensive rebounds
rebFloat64YesTotal rebounds
astFloat64YesAssists
tovFloat64YesTurnovers
stlFloat64YesSteals
blkFloat64YesBlocks
blkaFloat64YesBlocked attempts
pfFloat64YesPersonal fouls
pfdFloat64YesPersonal fouls drawn
ptsFloat64YesPoints scored
plus_minusFloat64YesPlus-minus differential
gp_rankInt64YesGames played rank
w_rankInt64YesWins rank
l_rankInt64YesLosses rank
w_pct_rankInt64YesWin percentage rank
min_rankInt64YesMinutes played rank
fgm_rankInt64YesField goals made rank
fga_rankInt64YesField goals attempted rank
fg_pct_rankInt64YesField goal percentage rank
fg3m_rankInt64YesThree-point field goals made rank
fg3a_rankInt64YesThree-point field goals attempted rank
fg3_pct_rankInt64YesThree-point percentage rank
ftm_rankInt64YesFree throws made rank
fta_rankInt64YesFree throws attempted rank
ft_pct_rankInt64YesFree throw percentage rank
oreb_rankInt64YesOffensive rebounds rank
dreb_rankInt64YesDefensive rebounds rank
reb_rankInt64YesTotal rebounds rank
ast_rankInt64YesAssists rank
tov_rankInt64YesTurnovers rank
stl_rankInt64YesSteals rank
blk_rankInt64YesBlocks rank
blka_rankInt64YesBlocked attempts rank
pf_rankInt64YesPersonal fouls rank
pfd_rankInt64YesPersonal fouls drawn rank
pts_rankInt64YesPoints scored rank
plus_minus_rankInt64YesPlus-minus rank
cfidInt64YesCustom filter identifier
cfparamsStringYesCustom filter parameters

staging_league_game_log

Class: StagingLeagueGameLogSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
season_idStringNoSeason identifier
team_idInt64Nogt=0, FK→staging_team.team_idUnique team identifier
team_abbreviationStringNoTeam abbreviation code
team_nameStringNoTeam name
game_idStringNoUnique game identifier
game_dateStringNoDate of the game
matchupStringNoMatchup string (e.g. LAL vs. BOS)
wlStringYesin=['W', 'L']Win or loss indicator
wInt64YesWins
lInt64YesLosses
w_pctFloat64YesWin percentage
minFloat64YesMinutes played
fgmFloat64YesField goals made
fgaFloat64YesField goals attempted
fg_pctFloat64YesField goal percentage
fg3mFloat64YesThree-point field goals made
fg3aFloat64YesThree-point field goals attempted
fg3_pctFloat64YesThree-point field goal percentage
ftmFloat64YesFree throws made
ftaFloat64YesFree throws attempted
ft_pctFloat64YesFree throw percentage
orebFloat64YesOffensive rebounds
drebFloat64YesDefensive rebounds
rebFloat64YesTotal rebounds
astFloat64YesAssists
stlFloat64YesSteals
blkFloat64YesBlocks
tovFloat64YesTurnovers
pfFloat64YesPersonal fouls
ptsFloat64YesPoints scored
plus_minusFloat64YesPlus-minus differential
video_availableInt64YesVideo availability flag

staging_league_lineup_viz

Class: StagingLeagueLineupVizSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
group_idStringNoLineup group identifier
group_nameStringYesLineup player names
team_idInt64NoFK→staging_team.team_idTeam identifier
team_abbreviationStringYesTeam abbreviation code
minFloat64YesMinutes played
off_ratingFloat64YesOffensive rating
def_ratingFloat64YesDefensive rating
net_ratingFloat64YesNet rating
paceFloat64YesPace factor
ts_pctFloat64YesTrue shooting percentage
fta_rateFloat64YesFree throw attempt rate
tm_ast_pctFloat64YesTeam assist percentage
pct_fga_2ptFloat64YesPercentage of field goal attempts from two-point range
pct_fga_3ptFloat64YesPercentage of field goal attempts from three-point range
pct_pts_2pt_mrFloat64YesPercentage of points from mid-range two-pointers
pct_pts_fbFloat64YesPercentage of points from fast breaks
pct_pts_ftFloat64YesPercentage of points from free throws
pct_pts_paintFloat64YesPercentage of points in the paint
pct_ast_fgmFloat64YesPercentage of assisted field goals
pct_uast_fgmFloat64YesPercentage of unassisted field goals
opp_fg3_pctFloat64YesOpponent three-point percentage
opp_efg_pctFloat64YesOpponent effective field goal percentage
opp_fta_rateFloat64YesOpponent free throw attempt rate
opp_tov_pctFloat64YesOpponent turnover percentage

staging_league_standings_v3

Class: StagingLeagueStandingsV3Schema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
league_idStringNoLeague identifier
season_idStringYesSeason identifier
team_idInt64Nogt=0, FK→staging_team.team_idUnique team identifier
team_cityStringYesTeam city name
team_nameStringYesTeam name
team_slugStringYesURL-friendly team slug
conferenceStringYesin=['East', 'West']Conference name
conference_recordStringYesWin-loss record in conference
playoff_rankInt64Yesgt=0Playoff seeding rank
clinch_indicatorStringYesClinch status indicator
divisionStringYesDivision name
division_recordStringYesWin-loss record in division
division_rankInt64Yesgt=0Rank within division
winsInt64YesTotal wins
lossesInt64YesTotal losses
win_pctFloat64YesWinning percentage
league_rankInt64Yesgt=0Overall league rank
recordStringYesOverall win-loss record
homeStringYesHome win-loss record
roadStringYesRoad win-loss record
l10StringYesRecord in last 10 games
long_win_streakInt64YesLongest winning streak
long_loss_streakInt64YesLongest losing streak
current_streakStringYesCurrent win or loss streak
ot_recordStringYesOvertime win-loss record
three_pts_or_lessStringYesRecord in games decided by 3 points or less
ten_pts_or_moreStringYesRecord in games decided by 10 points or more
conference_games_backFloat64YesGames behind conference leader
division_games_backFloat64YesGames behind division leader
clinched_conference_titleInt64Yesin=[0, 1]Whether team clinched conference
clinched_division_titleInt64Yesin=[0, 1]Whether team clinched division
clinched_playoff_birthInt64Yesin=[0, 1]Whether team clinched playoff berth
eliminated_conferenceInt64Yesin=[0, 1]Whether team eliminated from conference playoff contention
pts_pgFloat64YesPoints per game
opp_pts_pgFloat64YesOpponent points per game
diff_pts_pgFloat64YesPoint differential per game

staging_play_by_play_v2

Class: StagingPlayByPlayV2Schema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNoUnique game identifier
eventnumInt64NoEvent sequence number
eventmsgtypeInt64NoEvent message type code
eventmsgactiontypeInt64NoEvent message action type code
periodInt64Norange=[1, 10]Game period number
wctimestringStringYesWall clock time string
pctimestringStringYesPeriod clock time string
homedescriptionStringYesPlay description for home team
neutraldescriptionStringYesNeutral play description
visitordescriptionStringYesPlay description for visitor team
scoreStringYesCurrent game score
scoremarginStringYesScore margin value
person1typeInt64YesPerson 1 type identifier
player1_idInt64YesFK→staging_player.person_idPlayer 1 unique identifier
player1_nameStringYesPlayer 1 full name
player1_team_idInt64YesFK→staging_team.team_idPlayer 1 team identifier
player1_team_cityStringYesPlayer 1 team city
player1_team_nicknameStringYesPlayer 1 team nickname
player1_team_abbreviationStringYesPlayer 1 team abbreviation
person2typeInt64YesPerson 2 type identifier
player2_idInt64YesFK→staging_player.person_idPlayer 2 unique identifier
player2_nameStringYesPlayer 2 full name
player2_team_idInt64YesFK→staging_team.team_idPlayer 2 team identifier
player2_team_cityStringYesPlayer 2 team city
player2_team_nicknameStringYesPlayer 2 team nickname
player2_team_abbreviationStringYesPlayer 2 team abbreviation
person3typeInt64YesPerson 3 type identifier
player3_idInt64YesFK→staging_player.person_idPlayer 3 unique identifier
player3_nameStringYesPlayer 3 full name
player3_team_idInt64YesFK→staging_team.team_idPlayer 3 team identifier
player3_team_cityStringYesPlayer 3 team city
player3_team_nicknameStringYesPlayer 3 team nickname
player3_team_abbreviationStringYesPlayer 3 team abbreviation
video_available_flagInt64YesVideo availability flag

staging_play_by_play_v3

Class: StagingPlayByPlayV3Schema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNoUnique game identifier
action_numberInt64NoSequential action number within game
clockStringYesGame clock time string
periodInt64Norange=[1, 10]Game period number
team_idInt64YesFK→staging_team.team_idTeam identifier
team_tricodeStringYesThree-letter team abbreviation code
person_idInt64YesFK→staging_player.person_idPerson identifier
player_nameStringYesFull player name
player_name_iStringYesPlayer name in initial format
x_legacyFloat64YesLegacy x-coordinate of action
y_legacyFloat64YesLegacy y-coordinate of action
shot_distanceFloat64YesDistance of shot in feet
shot_resultStringYesResult of shot attempt
is_field_goalInt64Yesin=[0, 1]Flag indicating if action is a field goal attempt
score_homeStringYesHome team score
score_awayStringYesAway team score
points_totalInt64YesTotal points scored on the play
locationStringYesHome or away location indicator
descriptionStringYesText description of the play
action_typeStringYesType of action performed
sub_typeStringYesSub-type of action performed
video_availableInt64YesVideo availability flag
action_idInt64YesUnique action identifier

staging_player_dashboard_clutch

Class: StagingPlayerDashboardClutchSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
cfidInt64YesContext filter identifier returned by nba_api.
cfparamsStringYesSerialized context filter parameters returned by nba_api.
fgm_rankInt64YesField goals made rank.
fga_rankInt64YesField goals attempted rank.
fg_pct_rankInt64YesField goal percentage rank.
fg3m_rankInt64YesThree-pointers made rank.
fg3a_rankInt64YesThree-pointers attempted rank.
fg3_pct_rankInt64YesThree-point percentage rank.
blka_rankInt64YesBlocked attempts rank.
gp_rankInt64YesGames played rank.
w_rankInt64YesWins rank.
l_rankInt64YesLosses rank.
w_pct_rankInt64YesWin percentage rank.
min_rankInt64YesMinutes played rank.
ftm_rankInt64YesFree throws made rank.
fta_rankInt64YesFree throws attempted rank.
ft_pct_rankInt64YesFree throw percentage rank.
oreb_rankInt64YesOffensive rebounds rank.
dreb_rankInt64YesDefensive rebounds rank.
reb_rankInt64YesRebounds rank.
ast_rankInt64YesAssists rank.
tov_rankInt64YesTurnovers rank.
stl_rankInt64YesSteals rank.
blk_rankInt64YesBlocks rank.
pf_rankInt64YesPersonal fouls rank.
pfd_rankInt64YesPersonal fouls drawn rank.
pts_rankInt64YesPoints rank.
plus_minus_rankInt64YesPlus-minus rank.
nba_fantasy_pts_rankInt64YesNBA fantasy points rank.
dd2_rankInt64YesDouble-doubles rank.
td3_rankInt64YesTriple-doubles rank.
fgmFloat64YesField goals made.
fgaFloat64YesField goals attempted.
fg_pctFloat64YesField goal percentage.
fg3mFloat64YesThree-pointers made.
fg3aFloat64YesThree-pointers attempted.
fg3_pctFloat64YesThree-point percentage.
blkaFloat64YesBlocked attempts.
gpInt64YesGames played.
wInt64YesWins.
lInt64YesLosses.
w_pctFloat64YesWin percentage.
minFloat64YesMinutes played.
ftmFloat64YesFree throws made.
ftaFloat64YesFree throws attempted.
ft_pctFloat64YesFree throw percentage.
orebFloat64YesOffensive rebounds.
drebFloat64YesDefensive rebounds.
rebFloat64YesTotal rebounds.
astFloat64YesAssists.
tovFloat64YesTurnovers.
stlFloat64YesSteals.
blkFloat64YesBlocks.
pfFloat64YesPersonal fouls.
pfdFloat64YesPersonal fouls drawn.
ptsFloat64YesPoints scored.
plus_minusFloat64YesPlus-minus differential.
nba_fantasy_ptsFloat64YesNBA fantasy points.
dd2Float64YesDouble-doubles.
td3Float64YesTriple-doubles.
group_setStringYesGrouping set returned by the player dashboard endpoint.
group_valueStringYesGrouping value returned by the player dashboard endpoint.
player_idInt64Nogt=0Queried player identifier.
season_yearStringNoQueried season year.
season_typeStringNoQueried season type.

staging_player_dashboard_game_splits

Class: StagingPlayerDashboardGameSplitsSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
cfidInt64YesContext filter identifier returned by nba_api.
cfparamsStringYesSerialized context filter parameters returned by nba_api.
fgm_rankInt64YesField goals made rank.
fga_rankInt64YesField goals attempted rank.
fg_pct_rankInt64YesField goal percentage rank.
fg3m_rankInt64YesThree-pointers made rank.
fg3a_rankInt64YesThree-pointers attempted rank.
fg3_pct_rankInt64YesThree-point percentage rank.
blka_rankInt64YesBlocked attempts rank.
gp_rankInt64YesGames played rank.
w_rankInt64YesWins rank.
l_rankInt64YesLosses rank.
w_pct_rankInt64YesWin percentage rank.
min_rankInt64YesMinutes played rank.
ftm_rankInt64YesFree throws made rank.
fta_rankInt64YesFree throws attempted rank.
ft_pct_rankInt64YesFree throw percentage rank.
oreb_rankInt64YesOffensive rebounds rank.
dreb_rankInt64YesDefensive rebounds rank.
reb_rankInt64YesRebounds rank.
ast_rankInt64YesAssists rank.
tov_rankInt64YesTurnovers rank.
stl_rankInt64YesSteals rank.
blk_rankInt64YesBlocks rank.
pf_rankInt64YesPersonal fouls rank.
pfd_rankInt64YesPersonal fouls drawn rank.
pts_rankInt64YesPoints rank.
plus_minus_rankInt64YesPlus-minus rank.
nba_fantasy_pts_rankInt64YesNBA fantasy points rank.
dd2_rankInt64YesDouble-doubles rank.
td3_rankInt64YesTriple-doubles rank.
fgmFloat64YesField goals made.
fgaFloat64YesField goals attempted.
fg_pctFloat64YesField goal percentage.
fg3mFloat64YesThree-pointers made.
fg3aFloat64YesThree-pointers attempted.
fg3_pctFloat64YesThree-point percentage.
blkaFloat64YesBlocked attempts.
gpInt64YesGames played.
wInt64YesWins.
lInt64YesLosses.
w_pctFloat64YesWin percentage.
minFloat64YesMinutes played.
ftmFloat64YesFree throws made.
ftaFloat64YesFree throws attempted.
ft_pctFloat64YesFree throw percentage.
orebFloat64YesOffensive rebounds.
drebFloat64YesDefensive rebounds.
rebFloat64YesTotal rebounds.
astFloat64YesAssists.
tovFloat64YesTurnovers.
stlFloat64YesSteals.
blkFloat64YesBlocks.
pfFloat64YesPersonal fouls.
pfdFloat64YesPersonal fouls drawn.
ptsFloat64YesPoints scored.
plus_minusFloat64YesPlus-minus differential.
nba_fantasy_ptsFloat64YesNBA fantasy points.
dd2Float64YesDouble-doubles.
td3Float64YesTriple-doubles.
group_setStringYesGrouping set returned by the player dashboard endpoint.
group_valueStringYesGrouping value returned by the player dashboard endpoint.
player_idInt64Nogt=0Queried player identifier.
season_yearStringNoQueried season year.
season_typeStringNoQueried season type.

staging_player_dashboard_general_splits

Class: StagingPlayerDashboardGeneralSplitsSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
cfidInt64YesContext filter identifier returned by nba_api.
cfparamsStringYesSerialized context filter parameters returned by nba_api.
fgm_rankInt64YesField goals made rank.
fga_rankInt64YesField goals attempted rank.
fg_pct_rankInt64YesField goal percentage rank.
fg3m_rankInt64YesThree-pointers made rank.
fg3a_rankInt64YesThree-pointers attempted rank.
fg3_pct_rankInt64YesThree-point percentage rank.
blka_rankInt64YesBlocked attempts rank.
gp_rankInt64YesGames played rank.
w_rankInt64YesWins rank.
l_rankInt64YesLosses rank.
w_pct_rankInt64YesWin percentage rank.
min_rankInt64YesMinutes played rank.
ftm_rankInt64YesFree throws made rank.
fta_rankInt64YesFree throws attempted rank.
ft_pct_rankInt64YesFree throw percentage rank.
oreb_rankInt64YesOffensive rebounds rank.
dreb_rankInt64YesDefensive rebounds rank.
reb_rankInt64YesRebounds rank.
ast_rankInt64YesAssists rank.
tov_rankInt64YesTurnovers rank.
stl_rankInt64YesSteals rank.
blk_rankInt64YesBlocks rank.
pf_rankInt64YesPersonal fouls rank.
pfd_rankInt64YesPersonal fouls drawn rank.
pts_rankInt64YesPoints rank.
plus_minus_rankInt64YesPlus-minus rank.
nba_fantasy_pts_rankInt64YesNBA fantasy points rank.
dd2_rankInt64YesDouble-doubles rank.
td3_rankInt64YesTriple-doubles rank.
fgmFloat64YesField goals made.
fgaFloat64YesField goals attempted.
fg_pctFloat64YesField goal percentage.
fg3mFloat64YesThree-pointers made.
fg3aFloat64YesThree-pointers attempted.
fg3_pctFloat64YesThree-point percentage.
blkaFloat64YesBlocked attempts.
gpInt64YesGames played.
wInt64YesWins.
lInt64YesLosses.
w_pctFloat64YesWin percentage.
minFloat64YesMinutes played.
ftmFloat64YesFree throws made.
ftaFloat64YesFree throws attempted.
ft_pctFloat64YesFree throw percentage.
orebFloat64YesOffensive rebounds.
drebFloat64YesDefensive rebounds.
rebFloat64YesTotal rebounds.
astFloat64YesAssists.
tovFloat64YesTurnovers.
stlFloat64YesSteals.
blkFloat64YesBlocks.
pfFloat64YesPersonal fouls.
pfdFloat64YesPersonal fouls drawn.
ptsFloat64YesPoints scored.
plus_minusFloat64YesPlus-minus differential.
nba_fantasy_ptsFloat64YesNBA fantasy points.
dd2Float64YesDouble-doubles.
td3Float64YesTriple-doubles.
group_setStringYesGrouping set returned by the player dashboard endpoint.
group_valueStringYesGrouping value returned by the player dashboard endpoint.
player_idInt64Nogt=0Queried player identifier.
season_yearStringNoQueried season year.
season_typeStringNoQueried season type.

staging_player_dashboard_last_n_games

Class: StagingPlayerDashboardLastNGamesSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
cfidInt64YesContext filter identifier returned by nba_api.
cfparamsStringYesSerialized context filter parameters returned by nba_api.
fgm_rankInt64YesField goals made rank.
fga_rankInt64YesField goals attempted rank.
fg_pct_rankInt64YesField goal percentage rank.
fg3m_rankInt64YesThree-pointers made rank.
fg3a_rankInt64YesThree-pointers attempted rank.
fg3_pct_rankInt64YesThree-point percentage rank.
blka_rankInt64YesBlocked attempts rank.
gp_rankInt64YesGames played rank.
w_rankInt64YesWins rank.
l_rankInt64YesLosses rank.
w_pct_rankInt64YesWin percentage rank.
min_rankInt64YesMinutes played rank.
ftm_rankInt64YesFree throws made rank.
fta_rankInt64YesFree throws attempted rank.
ft_pct_rankInt64YesFree throw percentage rank.
oreb_rankInt64YesOffensive rebounds rank.
dreb_rankInt64YesDefensive rebounds rank.
reb_rankInt64YesRebounds rank.
ast_rankInt64YesAssists rank.
tov_rankInt64YesTurnovers rank.
stl_rankInt64YesSteals rank.
blk_rankInt64YesBlocks rank.
pf_rankInt64YesPersonal fouls rank.
pfd_rankInt64YesPersonal fouls drawn rank.
pts_rankInt64YesPoints rank.
plus_minus_rankInt64YesPlus-minus rank.
nba_fantasy_pts_rankInt64YesNBA fantasy points rank.
dd2_rankInt64YesDouble-doubles rank.
td3_rankInt64YesTriple-doubles rank.
fgmFloat64YesField goals made.
fgaFloat64YesField goals attempted.
fg_pctFloat64YesField goal percentage.
fg3mFloat64YesThree-pointers made.
fg3aFloat64YesThree-pointers attempted.
fg3_pctFloat64YesThree-point percentage.
blkaFloat64YesBlocked attempts.
gpInt64YesGames played.
wInt64YesWins.
lInt64YesLosses.
w_pctFloat64YesWin percentage.
minFloat64YesMinutes played.
ftmFloat64YesFree throws made.
ftaFloat64YesFree throws attempted.
ft_pctFloat64YesFree throw percentage.
orebFloat64YesOffensive rebounds.
drebFloat64YesDefensive rebounds.
rebFloat64YesTotal rebounds.
astFloat64YesAssists.
tovFloat64YesTurnovers.
stlFloat64YesSteals.
blkFloat64YesBlocks.
pfFloat64YesPersonal fouls.
pfdFloat64YesPersonal fouls drawn.
ptsFloat64YesPoints scored.
plus_minusFloat64YesPlus-minus differential.
nba_fantasy_ptsFloat64YesNBA fantasy points.
dd2Float64YesDouble-doubles.
td3Float64YesTriple-doubles.
group_setStringYesGrouping set returned by the player dashboard endpoint.
group_valueStringYesGrouping value returned by the player dashboard endpoint.
player_idInt64Nogt=0Queried player identifier.
season_yearStringNoQueried season year.
season_typeStringNoQueried season type.

staging_player_dashboard_shooting_splits

Class: StagingPlayerDashboardShootingSplitsSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
cfidInt64YesContext filter identifier returned by nba_api.
cfparamsStringYesSerialized context filter parameters returned by nba_api.
efg_pct_rankInt64YesEffective field goal percentage rank.
pct_ast_2pm_rankInt64YesAssisted two-point make percentage rank.
pct_uast_2pm_rankInt64YesUnassisted two-point make percentage rank.
pct_ast_3pm_rankInt64YesAssisted three-point make percentage rank.
pct_uast_3pm_rankInt64YesUnassisted three-point make percentage rank.
pct_ast_fgm_rankInt64YesAssisted field goal make percentage rank.
pct_uast_fgm_rankInt64YesUnassisted field goal make percentage rank.
fgm_rankInt64YesField goals made rank.
fga_rankInt64YesField goals attempted rank.
fg_pct_rankInt64YesField goal percentage rank.
fg3m_rankInt64YesThree-pointers made rank.
fg3a_rankInt64YesThree-pointers attempted rank.
fg3_pct_rankInt64YesThree-point percentage rank.
blka_rankInt64YesBlocked attempts rank.
efg_pctFloat64YesEffective field goal percentage.
pct_ast_2pmFloat64YesShare of made twos that were assisted.
pct_uast_2pmFloat64YesShare of made twos that were unassisted.
pct_ast_3pmFloat64YesShare of made threes that were assisted.
pct_uast_3pmFloat64YesShare of made threes that were unassisted.
pct_ast_fgmFloat64YesShare of made field goals that were assisted.
pct_uast_fgmFloat64YesShare of made field goals that were unassisted.
fgmFloat64YesField goals made.
fgaFloat64YesField goals attempted.
fg_pctFloat64YesField goal percentage.
fg3mFloat64YesThree-pointers made.
fg3aFloat64YesThree-pointers attempted.
fg3_pctFloat64YesThree-point percentage.
blkaFloat64YesBlocked attempts.
group_setStringYesGrouping set returned by the player dashboard endpoint.
group_valueStringYesGrouping value returned by the player dashboard endpoint.
player_idInt64Nogt=0Queried player identifier.
season_yearStringNoQueried season year.
season_typeStringNoQueried season type.

staging_player_dashboard_team_performance

Class: StagingPlayerDashboardTeamPerformanceSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
cfidInt64YesContext filter identifier returned by nba_api.
cfparamsStringYesSerialized context filter parameters returned by nba_api.
fgm_rankInt64YesField goals made rank.
fga_rankInt64YesField goals attempted rank.
fg_pct_rankInt64YesField goal percentage rank.
fg3m_rankInt64YesThree-pointers made rank.
fg3a_rankInt64YesThree-pointers attempted rank.
fg3_pct_rankInt64YesThree-point percentage rank.
blka_rankInt64YesBlocked attempts rank.
gp_rankInt64YesGames played rank.
w_rankInt64YesWins rank.
l_rankInt64YesLosses rank.
w_pct_rankInt64YesWin percentage rank.
min_rankInt64YesMinutes played rank.
ftm_rankInt64YesFree throws made rank.
fta_rankInt64YesFree throws attempted rank.
ft_pct_rankInt64YesFree throw percentage rank.
oreb_rankInt64YesOffensive rebounds rank.
dreb_rankInt64YesDefensive rebounds rank.
reb_rankInt64YesRebounds rank.
ast_rankInt64YesAssists rank.
tov_rankInt64YesTurnovers rank.
stl_rankInt64YesSteals rank.
blk_rankInt64YesBlocks rank.
pf_rankInt64YesPersonal fouls rank.
pfd_rankInt64YesPersonal fouls drawn rank.
pts_rankInt64YesPoints rank.
plus_minus_rankInt64YesPlus-minus rank.
nba_fantasy_pts_rankInt64YesNBA fantasy points rank.
dd2_rankInt64YesDouble-doubles rank.
td3_rankInt64YesTriple-doubles rank.
fgmFloat64YesField goals made.
fgaFloat64YesField goals attempted.
fg_pctFloat64YesField goal percentage.
fg3mFloat64YesThree-pointers made.
fg3aFloat64YesThree-pointers attempted.
fg3_pctFloat64YesThree-point percentage.
blkaFloat64YesBlocked attempts.
gpInt64YesGames played.
wInt64YesWins.
lInt64YesLosses.
w_pctFloat64YesWin percentage.
minFloat64YesMinutes played.
ftmFloat64YesFree throws made.
ftaFloat64YesFree throws attempted.
ft_pctFloat64YesFree throw percentage.
orebFloat64YesOffensive rebounds.
drebFloat64YesDefensive rebounds.
rebFloat64YesTotal rebounds.
astFloat64YesAssists.
tovFloat64YesTurnovers.
stlFloat64YesSteals.
blkFloat64YesBlocks.
pfFloat64YesPersonal fouls.
pfdFloat64YesPersonal fouls drawn.
ptsFloat64YesPoints scored.
plus_minusFloat64YesPlus-minus differential.
nba_fantasy_ptsFloat64YesNBA fantasy points.
dd2Float64YesDouble-doubles.
td3Float64YesTriple-doubles.
group_setStringYesGrouping set returned by the player dashboard endpoint.
group_valueStringYesGrouping value returned by the player dashboard endpoint.
player_idInt64Nogt=0Queried player identifier.
season_yearStringNoQueried season year.
season_typeStringNoQueried season type.

staging_player_dashboard_year_over_year

Class: StagingPlayerDashboardYearOverYearSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
cfidInt64YesContext filter identifier returned by nba_api.
cfparamsStringYesSerialized context filter parameters returned by nba_api.
fgm_rankInt64YesField goals made rank.
fga_rankInt64YesField goals attempted rank.
fg_pct_rankInt64YesField goal percentage rank.
fg3m_rankInt64YesThree-pointers made rank.
fg3a_rankInt64YesThree-pointers attempted rank.
fg3_pct_rankInt64YesThree-point percentage rank.
blka_rankInt64YesBlocked attempts rank.
gp_rankInt64YesGames played rank.
w_rankInt64YesWins rank.
l_rankInt64YesLosses rank.
w_pct_rankInt64YesWin percentage rank.
min_rankInt64YesMinutes played rank.
ftm_rankInt64YesFree throws made rank.
fta_rankInt64YesFree throws attempted rank.
ft_pct_rankInt64YesFree throw percentage rank.
oreb_rankInt64YesOffensive rebounds rank.
dreb_rankInt64YesDefensive rebounds rank.
reb_rankInt64YesRebounds rank.
ast_rankInt64YesAssists rank.
tov_rankInt64YesTurnovers rank.
stl_rankInt64YesSteals rank.
blk_rankInt64YesBlocks rank.
pf_rankInt64YesPersonal fouls rank.
pfd_rankInt64YesPersonal fouls drawn rank.
pts_rankInt64YesPoints rank.
plus_minus_rankInt64YesPlus-minus rank.
nba_fantasy_pts_rankInt64YesNBA fantasy points rank.
dd2_rankInt64YesDouble-doubles rank.
td3_rankInt64YesTriple-doubles rank.
fgmFloat64YesField goals made.
fgaFloat64YesField goals attempted.
fg_pctFloat64YesField goal percentage.
fg3mFloat64YesThree-pointers made.
fg3aFloat64YesThree-pointers attempted.
fg3_pctFloat64YesThree-point percentage.
blkaFloat64YesBlocked attempts.
gpInt64YesGames played.
wInt64YesWins.
lInt64YesLosses.
w_pctFloat64YesWin percentage.
minFloat64YesMinutes played.
ftmFloat64YesFree throws made.
ftaFloat64YesFree throws attempted.
ft_pctFloat64YesFree throw percentage.
orebFloat64YesOffensive rebounds.
drebFloat64YesDefensive rebounds.
rebFloat64YesTotal rebounds.
astFloat64YesAssists.
tovFloat64YesTurnovers.
stlFloat64YesSteals.
blkFloat64YesBlocks.
pfFloat64YesPersonal fouls.
pfdFloat64YesPersonal fouls drawn.
ptsFloat64YesPoints scored.
plus_minusFloat64YesPlus-minus differential.
nba_fantasy_ptsFloat64YesNBA fantasy points.
dd2Float64YesDouble-doubles.
td3Float64YesTriple-doubles.
team_idInt64Yesgt=0Team identifier for the season row.
team_abbreviationStringYesTeam abbreviation.
max_game_dateStringYesMost recent game date in the split.
group_setStringYesGrouping set returned by the player dashboard endpoint.
group_valueStringYesGrouping value returned by the player dashboard endpoint.
player_idInt64Nogt=0Queried player identifier.
season_yearStringNoQueried season year.
season_typeStringNoQueried season type.

staging_player_game_log

Class: StagingPlayerGameLogSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
season_idStringNoSeason identifier
player_idInt64Nogt=0, FK→staging_player.person_idUnique player identifier
game_idStringNoUnique game identifier
game_dateStringNoDate of the game
matchupStringNoMatchup string (e.g. LAL vs. BOS)
wlStringYesin=['W', 'L']Win or loss indicator
minFloat64YesMinutes played
fgmFloat64YesField goals made
fgaFloat64YesField goals attempted
fg_pctFloat64YesField goal percentage
fg3mFloat64YesThree-point field goals made
fg3aFloat64YesThree-point field goals attempted
fg3_pctFloat64YesThree-point field goal percentage
ftmFloat64YesFree throws made
ftaFloat64YesFree throws attempted
ft_pctFloat64YesFree throw percentage
orebFloat64YesOffensive rebounds
drebFloat64YesDefensive rebounds
rebFloat64YesTotal rebounds
astFloat64YesAssists
stlFloat64YesSteals
blkFloat64YesBlocks
tovFloat64YesTurnovers
pfFloat64YesPersonal fouls
ptsFloat64YesPoints scored
plus_minusFloat64YesPlus-minus differential

staging_player_index

Class: StagingPlayerIndexSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
person_idInt64Nogt=0Unique player identifier
player_last_nameStringNoPlayer last name
player_first_nameStringNoPlayer first name
player_slugStringYesURL-friendly player slug
team_idInt64YesFK→staging_team.team_idTeam identifier
team_slugStringYesURL-friendly team slug
is_defunctInt64YesWhether team is defunct
team_cityStringYesTeam city name
team_nameStringYesTeam name
team_abbreviationStringYesTeam abbreviation code
jersey_numberStringYesJersey number as string
positionStringYesPlayer position
heightStringYesPlayer height as string
weightStringYesPlayer weight as string
collegeStringYesCollege attended
countryStringYesCountry of origin
draft_yearInt64Yesgt=1946Year drafted
draft_roundInt64Yesin=[1, 2]Round drafted
draft_numberInt64Yesgt=0Overall draft pick number
roster_statusFloat64YesActive roster status
ptsFloat64YesPoints per game
rebFloat64YesRebounds per game
astFloat64YesAssists per game
stats_timeframeStringYesTimeframe for stats
from_yearStringYesFirst year in the league
to_yearStringYesLast year in the league

staging_player_perf_pts_scored

Class: StagingPlayerPerfPtsScoredSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
cfidInt64YesContext filter identifier returned by nba_api.
cfparamsStringYesSerialized context filter parameters returned by nba_api.
fgm_rankInt64YesField goals made rank.
fga_rankInt64YesField goals attempted rank.
fg_pct_rankInt64YesField goal percentage rank.
fg3m_rankInt64YesThree-pointers made rank.
fg3a_rankInt64YesThree-pointers attempted rank.
fg3_pct_rankInt64YesThree-point percentage rank.
blka_rankInt64YesBlocked attempts rank.
gp_rankInt64YesGames played rank.
w_rankInt64YesWins rank.
l_rankInt64YesLosses rank.
w_pct_rankInt64YesWin percentage rank.
min_rankInt64YesMinutes played rank.
ftm_rankInt64YesFree throws made rank.
fta_rankInt64YesFree throws attempted rank.
ft_pct_rankInt64YesFree throw percentage rank.
oreb_rankInt64YesOffensive rebounds rank.
dreb_rankInt64YesDefensive rebounds rank.
reb_rankInt64YesRebounds rank.
ast_rankInt64YesAssists rank.
tov_rankInt64YesTurnovers rank.
stl_rankInt64YesSteals rank.
blk_rankInt64YesBlocks rank.
pf_rankInt64YesPersonal fouls rank.
pfd_rankInt64YesPersonal fouls drawn rank.
pts_rankInt64YesPoints rank.
plus_minus_rankInt64YesPlus-minus rank.
nba_fantasy_pts_rankInt64YesNBA fantasy points rank.
dd2_rankInt64YesDouble-doubles rank.
td3_rankInt64YesTriple-doubles rank.
fgmFloat64YesField goals made.
fgaFloat64YesField goals attempted.
fg_pctFloat64YesField goal percentage.
fg3mFloat64YesThree-pointers made.
fg3aFloat64YesThree-pointers attempted.
fg3_pctFloat64YesThree-point percentage.
blkaFloat64YesBlocked attempts.
gpInt64YesGames played.
wInt64YesWins.
lInt64YesLosses.
w_pctFloat64YesWin percentage.
minFloat64YesMinutes played.
ftmFloat64YesFree throws made.
ftaFloat64YesFree throws attempted.
ft_pctFloat64YesFree throw percentage.
orebFloat64YesOffensive rebounds.
drebFloat64YesDefensive rebounds.
rebFloat64YesTotal rebounds.
astFloat64YesAssists.
tovFloat64YesTurnovers.
stlFloat64YesSteals.
blkFloat64YesBlocks.
pfFloat64YesPersonal fouls.
pfdFloat64YesPersonal fouls drawn.
ptsFloat64YesPoints scored.
plus_minusFloat64YesPlus-minus differential.
nba_fantasy_ptsFloat64YesNBA fantasy points.
dd2Float64YesDouble-doubles.
td3Float64YesTriple-doubles.
group_value_orderInt64YesSort order for grouped dashboard rows.
group_value_2StringYesSecondary grouping value returned by the endpoint.
group_setStringYesGrouping set returned by the player dashboard endpoint.
group_valueStringYesGrouping value returned by the player dashboard endpoint.
player_idInt64Nogt=0Queried player identifier.
season_yearStringNoQueried season year.
season_typeStringNoQueried season type.

staging_player_shoot_assisted_by

Class: StagingPlayerShootAssistedBySchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
cfidInt64YesContext filter identifier returned by nba_api.
cfparamsStringYesSerialized context filter parameters returned by nba_api.
efg_pct_rankInt64YesEffective field goal percentage rank.
pct_ast_2pm_rankInt64YesAssisted two-point make percentage rank.
pct_uast_2pm_rankInt64YesUnassisted two-point make percentage rank.
pct_ast_3pm_rankInt64YesAssisted three-point make percentage rank.
pct_uast_3pm_rankInt64YesUnassisted three-point make percentage rank.
pct_ast_fgm_rankInt64YesAssisted field goal make percentage rank.
pct_uast_fgm_rankInt64YesUnassisted field goal make percentage rank.
fgm_rankInt64YesField goals made rank.
fga_rankInt64YesField goals attempted rank.
fg_pct_rankInt64YesField goal percentage rank.
fg3m_rankInt64YesThree-pointers made rank.
fg3a_rankInt64YesThree-pointers attempted rank.
fg3_pct_rankInt64YesThree-point percentage rank.
blka_rankInt64YesBlocked attempts rank.
efg_pctFloat64YesEffective field goal percentage.
pct_ast_2pmFloat64YesShare of made twos that were assisted.
pct_uast_2pmFloat64YesShare of made twos that were unassisted.
pct_ast_3pmFloat64YesShare of made threes that were assisted.
pct_uast_3pmFloat64YesShare of made threes that were unassisted.
pct_ast_fgmFloat64YesShare of made field goals that were assisted.
pct_uast_fgmFloat64YesShare of made field goals that were unassisted.
fgmFloat64YesField goals made.
fgaFloat64YesField goals attempted.
fg_pctFloat64YesField goal percentage.
fg3mFloat64YesThree-pointers made.
fg3aFloat64YesThree-pointers attempted.
fg3_pctFloat64YesThree-point percentage.
blkaFloat64YesBlocked attempts.
player_nameStringYesPlayer name returned by the assisted-by split.
group_setStringYesGrouping set returned by the player dashboard endpoint.
player_idInt64Nogt=0Queried player identifier.
season_yearStringNoQueried season year.
season_typeStringNoQueried season type.

staging_player_shoot_type_summary

Class: StagingPlayerShootTypeSummarySchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
cfidInt64YesContext filter identifier returned by nba_api.
cfparamsStringYesSerialized context filter parameters returned by nba_api.
efg_pctFloat64YesEffective field goal percentage.
pct_ast_2pmFloat64YesShare of made twos that were assisted.
pct_uast_2pmFloat64YesShare of made twos that were unassisted.
pct_ast_3pmFloat64YesShare of made threes that were assisted.
pct_uast_3pmFloat64YesShare of made threes that were unassisted.
pct_ast_fgmFloat64YesShare of made field goals that were assisted.
pct_uast_fgmFloat64YesShare of made field goals that were unassisted.
fgmFloat64YesField goals made.
fgaFloat64YesField goals attempted.
fg_pctFloat64YesField goal percentage.
fg3mFloat64YesThree-pointers made.
fg3aFloat64YesThree-pointers attempted.
fg3_pctFloat64YesThree-point percentage.
blkaFloat64YesBlocked attempts.
group_setStringYesGrouping set returned by the player dashboard endpoint.
group_valueStringYesGrouping value returned by the player dashboard endpoint.
player_idInt64Nogt=0Queried player identifier.
season_yearStringNoQueried season year.
season_typeStringNoQueried season type.

staging_schedule_league_v2

Class: StagingScheduleLeagueV2Schema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_dateStringNoDate of the game
game_idStringNoUnique game identifier
game_codeStringYesGame code string
game_statusInt64Yesin=[1, 2, 3]Game status code
game_status_textStringYesGame status display text
game_sequenceInt64YesGame sequence number for the day
game_date_estStringYesGame date in Eastern time
game_time_estStringYesGame time in Eastern time
game_date_time_estStringYesGame date and time in Eastern time
game_date_utcStringYesGame date in UTC
game_time_utcStringYesGame time in UTC
game_date_time_utcStringYesGame date and time in UTC
away_team_idInt64YesFK→staging_team.team_idAway team identifier
away_team_nameStringYesAway team name
away_team_cityStringYesAway team city
away_team_tricodeStringYesAway team three-letter code
away_team_slugStringYesAway team URL slug
away_team_winsInt64YesAway team win count
away_team_lossesInt64YesAway team loss count
away_team_scoreInt64YesAway team score
home_team_idInt64YesFK→staging_team.team_idHome team identifier
home_team_nameStringYesHome team name
home_team_cityStringYesHome team city
home_team_tricodeStringYesHome team three-letter code
home_team_slugStringYesHome team URL slug
home_team_winsInt64YesHome team win count
home_team_lossesInt64YesHome team loss count
home_team_scoreInt64YesHome team score
arena_nameStringYesArena name
arena_cityStringYesArena city
arena_stateStringYesArena state
postponed_statusStringYesPostponement status
branch_linkStringYesBranch deep link URL
game_subtypeStringYesGame subtype classification
series_conferenceStringYesPlayoff series conference
series_textStringYesPlayoff series status text
if_necessaryStringYesIf-necessary game indicator
series_game_numberStringYesGame number in playoff series

staging_scoreboard_v2

Class: StagingScoreboardV2Schema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_date_estStringNoGame date in Eastern time
game_sequenceInt64YesGame sequence number for the day
game_idStringNoUnique game identifier
game_status_idInt64Yesin=[1, 2, 3]Game status identifier
game_status_textStringYesGame status display text
gamecodeStringYesGame code string
home_team_idInt64YesFK→staging_team.team_idHome team identifier
visitor_team_idInt64YesFK→staging_team.team_idVisitor team identifier
seasonStringYesSeason year string
live_periodInt64YesCurrent live period
live_pc_timeStringYesLive game clock time
natl_tv_broadcaster_abbreviationStringYesNational TV broadcaster abbreviation
home_tv_broadcaster_abbreviationStringYesHome TV broadcaster abbreviation
away_tv_broadcaster_abbreviationStringYesAway TV broadcaster abbreviation
live_period_time_bcastStringYesLive period time broadcast string
arena_nameStringYesArena name
wh_statusInt64YesWagering hub status flag

staging_shot_chart_detail

Class: StagingShotChartDetailSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
grid_typeStringYesShot chart grid type
game_idStringNoUnique game identifier
game_event_idInt64YesEvent identifier within game
player_idInt64Nogt=0, FK→staging_player.person_idUnique player identifier
player_nameStringYesPlayer full name
team_idInt64YesFK→staging_team.team_idTeam identifier
team_nameStringYesTeam name
periodInt64Yesgt=0Game period number
minutes_remainingInt64YesMinutes remaining in period
seconds_remainingInt64YesSeconds remaining in period
event_typeStringYesShot event type (Made/Missed)
action_typeStringYesSpecific shot action type
shot_typeStringYesShot type (2PT/3PT Field Goal)
shot_zone_basicStringYesBasic shot zone category
shot_zone_areaStringYesShot zone area on court
shot_zone_rangeStringYesShot distance range bucket
shot_distanceInt64YesShot distance in feet
loc_xInt64YesShot X coordinate on court
loc_yInt64YesShot Y coordinate on court
shot_attempted_flagInt64Yesin=[0, 1]Flag indicating shot was attempted
shot_made_flagInt64Yesin=[0, 1]Flag indicating shot was made
game_dateStringYesDate of the game
htmStringYesHome team abbreviation
vtmStringYesVisitor team abbreviation

staging_synergy_play_types

Class: StagingSynergyPlayTypesSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
season_idStringNoNBA season identifier
team_idInt64Yesgt=0, FK→staging_team.team_idTeam identifier
team_abbreviationStringYesTeam abbreviation code
team_nameStringYesTeam name
player_idInt64Yesgt=0, FK→staging_player.person_idUnique player identifier
player_nameStringYesPlayer full name
play_typeStringNoSynergy play type classification
type_groupingStringNoOffensive or defensive grouping
percentileFloat64YesPercentile rank for play type
gpInt64YesGames played
poss_pctFloat64YesPercentage of possessions
pppFloat64YesPoints per possession
fg_pctFloat64YesField goal percentage
ft_pct_adjustFloat64YesFree throw percentage adjusted
to_pctFloat64YesTurnover percentage
sf_pctFloat64YesShooting foul percentage
plusone_pctFloat64YesAnd-one conversion percentage
score_pctFloat64YesScoring percentage
efg_pctFloat64YesEffective field goal percentage
possInt64YesTotal possessions
ptsFloat64YesTotal points scored
fgmInt64YesField goals made
fgaInt64YesField goals attempted
fgmxInt64YesField goals missed

staging_team_details

Class: StagingTeamDetailsSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
team_idInt64Nogt=0Unique team identifier
abbreviationStringNoTeam abbreviation code
nicknameStringNoTeam nickname
yearfoundedInt64Yesgt=1900Year the team was founded
cityStringYesTeam city name
arenaStringYesHome arena name
arenacapacityInt64Yesgt=0Arena seating capacity
ownerStringYesTeam owner name
generalmanagerStringYesGeneral manager name
headcoachStringYesHead coach name
dleagueaffiliationStringYesG-League affiliate team name

staging_team_game_log

Class: StagingTeamGameLogSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
season_idStringNoSeason identifier
team_idInt64Nogt=0, FK→staging_team.team_idUnique team identifier
team_abbreviationStringNoTeam abbreviation code
team_nameStringNoTeam name
game_idStringNoUnique game identifier
game_dateStringNoDate of the game
matchupStringNoMatchup string (e.g. LAL vs. BOS)
wlStringYesin=['W', 'L']Win or loss indicator
wInt64YesWins
lInt64YesLosses
w_pctFloat64YesWin percentage
minFloat64YesMinutes played
fgmFloat64YesField goals made
fgaFloat64YesField goals attempted
fg_pctFloat64YesField goal percentage
fg3mFloat64YesThree-point field goals made
fg3aFloat64YesThree-point field goals attempted
fg3_pctFloat64YesThree-point field goal percentage
ftmFloat64YesFree throws made
ftaFloat64YesFree throws attempted
ft_pctFloat64YesFree throw percentage
orebFloat64YesOffensive rebounds
drebFloat64YesDefensive rebounds
rebFloat64YesTotal rebounds
astFloat64YesAssists
stlFloat64YesSteals
blkFloat64YesBlocks
tovFloat64YesTurnovers
pfFloat64YesPersonal fouls
ptsFloat64YesPoints scored
plus_minusFloat64YesPlus-minus differential
video_availableInt64YesVideo availability flag

staging_team_info_common

Class: StagingTeamInfoCommonSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
team_idInt64Nogt=0Unique team identifier
season_yearStringYesSeason year string
team_cityStringYesTeam city name
team_nameStringNoTeam name
team_abbreviationStringNoTeam abbreviation code
team_conferenceStringYesConference name
team_divisionStringYesDivision name
team_codeStringYesTeam code slug
team_slugStringYesURL-friendly team slug
wInt64YesWins
lInt64YesLosses
pctFloat64YesWin percentage
conf_rankInt64Yesgt=0Conference ranking
div_rankInt64Yesgt=0Division ranking
min_yearStringYesFirst year of team activity
max_yearStringYesLast year of team activity

staging_win_probability

Class: StagingWinProbabilitySchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNoUnique game identifier
event_numInt64NoEvent sequence number
home_pctFloat64YesHome team win probability
visitor_pctFloat64YesVisitor team win probability
home_ptsInt64YesHome team points
visitor_ptsInt64YesVisitor team points
home_score_marginInt64YesHome team score margin
periodInt64Yesgt=0Game period number
seconds_remainingFloat64YesSeconds remaining in period
home_team_idInt64YesFK→staging_team.team_idHome team identifier
home_team_abbStringYesHome team abbreviation code
visitor_team_idInt64YesFK→staging_team.team_idVisitor team identifier
visitor_team_abbStringYesVisitor team abbreviation code
descriptionStringYesText description of the play
locationStringYesHome or away location indicator
pctimestringStringYesPeriod clock time string
is_score_changeInt64Yesin=[0, 1]Flag indicating if score changed

Companion cuts

Turn staging contracts into join and dependency reasoning

These curated pages help once the cleanup is confirmed and the next question becomes how that staged data behaves downstream.

Next possession

Translate staging cleanup into join intent

Staging contracts show the half-court set: renamed columns, normalized types, and load-ready keys. Use these pages to move from cleanup details into joins, dependencies, and reader-facing naming.

Section hub

On this page