Court Geometry
Schema Reference — Staging
Complete schema docs for staging tier
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.
confirm renamed fields, typing, and foreign-key hints in the warehouse-ready layer
staging blocks often reveal the intended join anchors for downstream models
regenerate from schema metadata instead of hand-editing
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.
Focus on renamed identifiers and typed columns
Those are usually the signals that matter most when you are planning joins or debugging transform assumptions.
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.
Jump into the matching table family, then read the exact block.
+3 more in the page TOC and section list.
Jump into the matching table family, then read the exact block.
+1 more in the page TOC and section list.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Jump into the matching table family, then read the exact block.
Schema Reference — Staging
This tier contains 43 schema(s).
staging_arena_info
Class: StagingArenaInfoSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
game_id | String | No | — | Unique game identifier |
arena_id | Int64 | Yes | — | Arena identifier |
arena_name | String | Yes | — | Arena name |
arena_city | String | Yes | — | Arena city |
arena_state | String | Yes | — | Arena state or province |
arena_country | String | Yes | — | Arena country |
arena_timezone | String | Yes | — | Arena timezone |
staging_box_score_advanced_player
Class: StagingBoxScoreAdvancedPlayerSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
game_id | String | No | — | Unique game identifier |
team_id | Int64 | No | FK→staging_team.team_id | Team identifier |
player_id | Int64 | No | gt=0, FK→staging_player.person_id | Unique player identifier |
player_name | String | Yes | — | Player full name |
min | String | Yes | — | Minutes played as string |
e_off_rating | Float64 | Yes | — | Estimated offensive rating |
off_rating | Float64 | Yes | — | Offensive rating |
e_def_rating | Float64 | Yes | — | Estimated defensive rating |
def_rating | Float64 | Yes | — | Defensive rating |
e_net_rating | Float64 | Yes | — | Estimated net rating |
net_rating | Float64 | Yes | — | Net rating |
ast_pct | Float64 | Yes | — | Assist percentage |
ast_tov | Float64 | Yes | — | Assist to turnover ratio |
ast_ratio | Float64 | Yes | — | Assist ratio |
oreb_pct | Float64 | Yes | — | Offensive rebound percentage |
dreb_pct | Float64 | Yes | — | Defensive rebound percentage |
reb_pct | Float64 | Yes | — | Total rebound percentage |
tov_pct | Float64 | Yes | — | Turnover percentage |
efg_pct | Float64 | Yes | — | Effective field goal percentage |
ts_pct | Float64 | Yes | — | True shooting percentage |
usg_pct | Float64 | Yes | — | Usage percentage |
e_usg_pct | Float64 | Yes | — | Estimated usage percentage |
e_pace | Float64 | Yes | — | Estimated pace |
pace | Float64 | Yes | — | Pace factor |
pace_per40 | Float64 | Yes | — | Pace per 40 minutes |
poss | Float64 | Yes | — | Possessions |
pie | Float64 | Yes | — | Player impact estimate |
staging_box_score_defensive_player
Class: StagingBoxScoreDefensivePlayerSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
game_id | String | No | — | Unique game identifier |
team_id | Int64 | No | FK→staging_team.team_id | Team identifier |
player_id | Int64 | No | gt=0, FK→staging_player.person_id | Unique player identifier |
player_name | String | Yes | — | Player full name |
min | String | Yes | — | Minutes played as string |
matchup_min | Float64 | Yes | — | Minutes in matchup defense |
partial_poss | Float64 | Yes | — | Partial possessions defended |
switches_on | Float64 | Yes | — | Number of defensive switches |
player_pts | Float64 | Yes | — | Points allowed on defense |
def_fgm | Float64 | Yes | — | Defended field goals made |
def_fga | Float64 | Yes | — | Defended field goals attempted |
def_fg_pct | Float64 | Yes | — | Defended field goal percentage |
staging_box_score_four_factors_player
Class: StagingBoxScoreFourFactorsPlayerSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
game_id | String | No | — | Unique game identifier |
team_id | Int64 | No | FK→staging_team.team_id | Team identifier |
player_id | Int64 | No | gt=0, FK→staging_player.person_id | Unique player identifier |
player_name | String | Yes | — | Player full name |
min | String | Yes | — | Minutes played as string |
effective_field_goal_percentage | Float64 | Yes | — | Effective field goal percentage |
free_throw_attempt_rate | Float64 | Yes | — | Free throw attempt rate |
team_turnover_percentage | Float64 | Yes | — | Team turnover percentage |
offensive_rebound_percentage | Float64 | Yes | — | Offensive rebound percentage |
opp_effective_field_goal_percentage | Float64 | Yes | — | Opponent effective field goal percentage |
opp_free_throw_attempt_rate | Float64 | Yes | — | Opponent free throw attempt rate |
opp_team_turnover_percentage | Float64 | Yes | — | Opponent team turnover percentage |
opp_offensive_rebound_percentage | Float64 | Yes | — | Opponent offensive rebound percentage |
staging_box_score_four_factors_team
Class: StagingBoxScoreFourFactorsTeamSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
game_id | String | No | — | Unique game identifier |
team_id | Int64 | No | FK→staging_team.team_id | Team identifier |
team_name | String | Yes | — | Team name |
team_abbreviation | String | Yes | — | Team abbreviation code |
effective_field_goal_percentage | Float64 | Yes | — | Effective field goal percentage |
free_throw_attempt_rate | Float64 | Yes | — | Free throw attempt rate |
team_turnover_percentage | Float64 | Yes | — | Team turnover percentage |
offensive_rebound_percentage | Float64 | Yes | — | Offensive rebound percentage |
opp_effective_field_goal_percentage | Float64 | Yes | — | Opponent effective field goal percentage |
opp_free_throw_attempt_rate | Float64 | Yes | — | Opponent free throw attempt rate |
opp_team_turnover_percentage | Float64 | Yes | — | Opponent team turnover percentage |
opp_offensive_rebound_percentage | Float64 | Yes | — | Opponent offensive rebound percentage |
staging_box_score_hustle_player
Class: StagingBoxScoreHustlePlayerSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
game_id | String | No | — | Unique game identifier |
team_id | Int64 | No | FK→staging_team.team_id | Team identifier |
player_id | Int64 | No | gt=0, FK→staging_player.person_id | Unique player identifier |
player_name | String | Yes | — | Player full name |
min | String | Yes | — | Minutes played as string |
contested_shots | Float64 | Yes | — | Contested shots |
contested_shots_2pt | Float64 | Yes | — | Contested two-point shots |
contested_shots_3pt | Float64 | Yes | — | Contested three-point shots |
deflections | Float64 | Yes | — | Deflections |
charges_drawn | Float64 | Yes | — | Charges drawn |
screen_assists | Float64 | Yes | — | Screen assists |
screen_ast_pts | Float64 | Yes | — | Points from screen assists |
loose_balls_recovered | Float64 | Yes | — | Loose balls recovered |
box_outs | Float64 | Yes | — | Box outs |
staging_box_score_matchups
Class: StagingBoxScoreMatchupsSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
game_id | String | No | FK→staging_game_log.game_id | Unique game identifier |
off_team_id | Int64 | Yes | gt=0, FK→staging_team.team_id | Offensive team identifier |
off_team_abbreviation | String | Yes | — | Offensive team abbreviation |
def_team_id | Int64 | Yes | gt=0, FK→staging_team.team_id | Defensive team identifier |
def_team_abbreviation | String | Yes | — | Defensive team abbreviation |
off_player_id | Int64 | Yes | gt=0, FK→staging_player.person_id | Offensive player identifier |
off_player_name | String | Yes | — | Offensive player name |
def_player_id | Int64 | Yes | gt=0, FK→staging_player.person_id | Defensive player identifier |
def_player_name | String | Yes | — | Defensive player name |
matchup_min | Float64 | Yes | — | Minutes in matchup |
partial_poss | Float64 | Yes | — | Partial possessions in matchup |
player_pts | Float64 | Yes | — | Player points in matchup |
team_pts | Float64 | Yes | — | Team points in matchup |
matchup_ast | Float64 | Yes | — | Assists in matchup |
matchup_tov | Float64 | Yes | — | Turnovers in matchup |
matchup_blk | Float64 | Yes | — | Blocks in matchup |
matchup_fgm | Float64 | Yes | — | Field goals made in matchup |
matchup_fga | Float64 | Yes | — | Field goals attempted |
matchup_fg_pct | Float64 | Yes | — | Field goal pct in matchup |
matchup_fg3m | Float64 | Yes | — | Three-pointers made |
matchup_fg3a | Float64 | Yes | — | Three-pointers attempted |
matchup_fg3_pct | Float64 | Yes | — | Three-point pct in matchup |
help_blk | Float64 | Yes | — | Help blocks in matchup |
help_fgm | Float64 | Yes | — | Help field goals made |
help_fga | Float64 | Yes | — | Help field goals attempted |
help_fg_pct | Float64 | Yes | — | Help field goal percentage |
matchup_ftm | Float64 | Yes | — | Free throws made in matchup |
matchup_fta | Float64 | Yes | — | Free throws attempted |
switches_on | Float64 | Yes | — | Switches onto player |
staging_box_score_player_track
Class: StagingBoxScorePlayerTrackSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
game_id | String | No | — | Unique game identifier |
team_id | Int64 | No | FK→staging_team.team_id | Team identifier |
player_id | Int64 | No | gt=0, FK→staging_player.person_id | Unique player identifier |
player_name | String | Yes | — | Player full name |
min | String | Yes | — | Minutes played as string |
spd | Float64 | Yes | — | Average speed in mph |
dist | Float64 | Yes | — | Distance covered in miles |
orbc | Float64 | Yes | — | Offensive rebound chances |
drbc | Float64 | Yes | — | Defensive rebound chances |
rbc | Float64 | Yes | — | Total rebound chances |
tchs | Float64 | Yes | — | Touches |
sast | Float64 | Yes | — | Secondary assists |
ftast | Float64 | Yes | — | Free throw assists |
pass | Float64 | Yes | — | Passes made |
cfgm | Float64 | Yes | — | Contested field goals made |
cfga | Float64 | Yes | — | Contested field goals attempted |
cfg_pct | Float64 | Yes | — | Contested field goal percentage |
ufgm | Float64 | Yes | — | Uncontested field goals made |
ufga | Float64 | Yes | — | Uncontested field goals attempted |
ufg_pct | Float64 | Yes | — | Uncontested field goal percentage |
dfgm | Float64 | Yes | — | Defended field goals made |
dfga | Float64 | Yes | — | Defended field goals attempted |
dfg_pct | Float64 | Yes | — | Defended field goal percentage |
staging_box_score_traditional_player
Class: StagingBoxScoreTraditionalPlayerSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
game_id | String | No | — | Unique game identifier |
team_id | Int64 | No | FK→staging_team.team_id | Team identifier |
team_abbreviation | String | Yes | — | Team abbreviation code |
team_city | String | Yes | — | Team city name |
player_id | Int64 | No | gt=0, FK→staging_player.person_id | Unique player identifier |
player_name | String | Yes | — | Player full name |
nickname | String | Yes | — | Player nickname |
start_position | String | Yes | — | Starting position (F/C/G) |
comment | String | Yes | — | Player status comment |
min | String | Yes | — | Minutes played as string |
fgm | Float64 | Yes | — | Field goals made |
fga | Float64 | Yes | — | Field goals attempted |
fg_pct | Float64 | Yes | — | Field goal percentage |
fg3m | Float64 | Yes | — | Three-point field goals made |
fg3a | Float64 | Yes | — | Three-point field goals attempted |
fg3_pct | Float64 | Yes | — | Three-point field goal percentage |
ftm | Float64 | Yes | — | Free throws made |
fta | Float64 | Yes | — | Free throws attempted |
ft_pct | Float64 | Yes | — | Free throw percentage |
oreb | Float64 | Yes | — | Offensive rebounds |
dreb | Float64 | Yes | — | Defensive rebounds |
reb | Float64 | Yes | — | Total rebounds |
ast | Float64 | Yes | — | Assists |
stl | Float64 | Yes | — | Steals |
blk | Float64 | Yes | — | Blocks |
tov | Float64 | Yes | — | Turnovers |
pf | Float64 | Yes | — | Personal fouls |
pts | Float64 | Yes | — | Points scored |
plus_minus | Float64 | Yes | — | Plus-minus differential |
staging_box_score_traditional_team
Class: StagingBoxScoreTraditionalTeamSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
game_id | String | No | — | Unique game identifier |
team_id | Int64 | No | FK→staging_team.team_id | Team identifier |
team_name | String | Yes | — | Team name |
team_abbreviation | String | Yes | — | Team abbreviation code |
team_city | String | Yes | — | Team city name |
min | Float64 | Yes | — | Total team minutes played |
fgm | Float64 | Yes | — | Field goals made |
fga | Float64 | Yes | — | Field goals attempted |
fg_pct | Float64 | Yes | — | Field goal percentage |
fg3m | Float64 | Yes | — | Three-point field goals made |
fg3a | Float64 | Yes | — | Three-point field goals attempted |
fg3_pct | Float64 | Yes | — | Three-point field goal percentage |
ftm | Float64 | Yes | — | Free throws made |
fta | Float64 | Yes | — | Free throws attempted |
ft_pct | Float64 | Yes | — | Free throw percentage |
oreb | Float64 | Yes | — | Offensive rebounds |
dreb | Float64 | Yes | — | Defensive rebounds |
reb | Float64 | Yes | — | Total rebounds |
ast | Float64 | Yes | — | Assists |
stl | Float64 | Yes | — | Steals |
blk | Float64 | Yes | — | Blocks |
tov | Float64 | Yes | — | Turnovers |
pf | Float64 | Yes | — | Personal fouls |
pts | Float64 | Yes | — | Points scored |
plus_minus | Float64 | Yes | — | Plus-minus differential |
staging_common_all_players
Class: StagingCommonAllPlayersSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
person_id | Int64 | No | gt=0 | Unique player identifier |
display_last_comma_first | String | Yes | — | Player name as Last, First |
display_first_last | String | No | — | Player name as First Last |
roster_status | Int64 | Yes | in=[0, 1] | Active roster flag (0 or 1) |
from_year | String | Yes | — | First year in the league |
to_year | String | Yes | — | Last year in the league |
playercode | String | Yes | — | Player code slug |
team_id | Int64 | Yes | FK→staging_team.team_id | Team identifier |
team_city | String | Yes | — | Team city name |
team_name | String | Yes | — | Team name |
team_abbreviation | String | Yes | — | Team abbreviation code |
team_code | String | Yes | — | Team code slug |
games_played_flag | String | Yes | — | Flag indicating games played |
staging_common_team_years
Class: StagingCommonTeamYearsSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
league_id | String | No | — | League identifier |
team_id | Int64 | No | gt=0 | Unique team identifier |
min_year | String | Yes | — | First year of team activity |
max_year | String | Yes | — | Last year of team activity |
abbreviation | String | No | — | Team abbreviation code |
staging_draft_combine_stats
Class: StagingDraftCombineStatsSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
season | String | No | — | Combine season year |
player_id | Int64 | No | gt=0, FK→staging_player.person_id | Unique player identifier |
first_name | String | Yes | — | Player first name |
last_name | String | Yes | — | Player last name |
player_name | String | Yes | — | Player full name |
position | String | Yes | — | Player position |
height_wo_shoes | Float64 | Yes | gt=0 | Height without shoes in inches |
height_wo_shoes_ft_in | String | Yes | — | Height without shoes in feet-inches |
height_w_shoes | Float64 | Yes | gt=0 | Height with shoes in inches |
height_w_shoes_ft_in | String | Yes | — | Height with shoes in feet-inches |
weight | Float64 | Yes | gt=0 | Player weight in pounds |
wingspan | Float64 | Yes | gt=0 | Wingspan in inches |
wingspan_ft_in | String | Yes | — | Wingspan in feet-inches |
standing_reach | Float64 | Yes | gt=0 | Standing reach in inches |
standing_reach_ft_in | String | Yes | — | Standing reach in feet-inches |
body_fat_pct | Float64 | Yes | — | Body fat percentage |
hand_length | Float64 | Yes | gt=0 | Hand length in inches |
hand_width | Float64 | Yes | gt=0 | Hand width in inches |
standing_vertical_leap | Float64 | Yes | gt=0 | Standing vertical leap in inches |
max_vertical_leap | Float64 | Yes | gt=0 | Maximum vertical leap in inches |
lane_agility_time | Float64 | Yes | gt=0 | Lane agility drill time in seconds |
modified_lane_agility_time | Float64 | Yes | gt=0 | Modified lane agility time in seconds |
three_quarter_sprint | Float64 | Yes | gt=0 | Three-quarter court sprint time in seconds |
bench_press | Float64 | Yes | — | Bench press repetitions |
staging_draft_history
Class: StagingDraftHistorySchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
person_id | Int64 | No | gt=0, FK→staging_player.person_id | Unique player identifier |
player_name | String | Yes | — | Player full name |
season | String | No | — | Draft season year |
round_number | Int64 | Yes | in=[1, 2] | Draft round number |
round_pick | Int64 | Yes | gt=0 | Pick number within the round |
overall_pick | Int64 | Yes | gt=0 | Overall draft pick number |
draft_type | String | Yes | — | Type of draft |
team_id | Int64 | Yes | FK→staging_team.team_id | Team identifier |
team_city | String | Yes | — | Team city name |
team_name | String | Yes | — | Team name |
team_abbreviation | String | Yes | — | Team abbreviation code |
organization | String | Yes | — | Pre-draft organization |
organization_type | String | Yes | — | Type of pre-draft organization |
player_profile_flag | Int64 | Yes | — | Player profile availability flag |
staging_game_leaders
Class: StagingGameLeadersSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
game_id | String | No | — | Unique game identifier |
team_id | Int64 | No | gt=0, FK→staging_team.team_id | Team identifier |
leader_type | String | No | — | Leader category (home or away) |
person_id | Int64 | No | gt=0, FK→staging_player.person_id | Unique player identifier |
name | String | No | — | Player display name |
player_slug | String | Yes | — | Player URL slug |
jersey_num | String | Yes | — | Player jersey number |
position | String | Yes | — | Player position |
team_tricode | String | Yes | — | Three-letter team code |
points | Float64 | Yes | — | Points scored |
rebounds | Float64 | Yes | — | Total rebounds |
assists | Float64 | Yes | — | Total assists |
staging_game_rotation
Class: StagingGameRotationSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
game_id | String | No | — | Unique game identifier |
team_id | Int64 | Yes | FK→staging_team.team_id | Team identifier |
team_city | String | Yes | — | Team city name |
team_name | String | Yes | — | Team name |
person_id | Int64 | Yes | FK→staging_player.person_id | Player person identifier |
player_first | String | Yes | — | Player first name |
player_last | String | Yes | — | Player last name |
in_time_real | Float64 | Yes | — | Real time player entered game |
out_time_real | Float64 | Yes | — | Real time player exited game |
player_pts | Float64 | Yes | — | Points scored during stint |
pt_diff | Float64 | Yes | — | Point differential during stint |
usg_pct | Float64 | Yes | — | Usage percentage during stint |
staging_league_dash_player_stats
Class: StagingLeagueDashPlayerStatsSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
player_id | Int64 | No | FK→staging_player.person_id | Unique player identifier |
player_name | String | Yes | — | Player full name |
team_id | Int64 | No | FK→staging_team.team_id | Team identifier |
team_abbreviation | String | Yes | — | Team abbreviation code |
age | Float64 | Yes | — | Player age |
gp | Int64 | Yes | — | Games played |
w | Int64 | Yes | — | Wins |
l | Int64 | Yes | — | Losses |
w_pct | Float64 | Yes | — | Win percentage |
min | Float64 | Yes | — | Minutes played |
fgm | Float64 | Yes | — | Field goals made |
fga | Float64 | Yes | — | Field goals attempted |
fg_pct | Float64 | Yes | — | Field goal percentage |
fg3m | Float64 | Yes | — | Three-point field goals made |
fg3a | Float64 | Yes | — | Three-point field goals attempted |
fg3_pct | Float64 | Yes | — | Three-point field goal percentage |
ftm | Float64 | Yes | — | Free throws made |
fta | Float64 | Yes | — | Free throws attempted |
ft_pct | Float64 | Yes | — | Free throw percentage |
oreb | Float64 | Yes | — | Offensive rebounds |
dreb | Float64 | Yes | — | Defensive rebounds |
reb | Float64 | Yes | — | Total rebounds |
ast | Float64 | Yes | — | Assists |
tov | Float64 | Yes | — | Turnovers |
stl | Float64 | Yes | — | Steals |
blk | Float64 | Yes | — | Blocks |
blka | Float64 | Yes | — | Blocked attempts |
pf | Float64 | Yes | — | Personal fouls |
pfd | Float64 | Yes | — | Personal fouls drawn |
pts | Float64 | Yes | — | Points scored |
plus_minus | Float64 | Yes | — | Plus-minus differential |
nba_fantasy_pts | Float64 | Yes | — | NBA fantasy points |
dd2 | Float64 | Yes | — | Double-doubles |
td3 | Float64 | Yes | — | Triple-doubles |
gp_rank | Int64 | Yes | — | Games played rank |
w_rank | Int64 | Yes | — | Wins rank |
l_rank | Int64 | Yes | — | Losses rank |
w_pct_rank | Int64 | Yes | — | Win percentage rank |
min_rank | Int64 | Yes | — | Minutes played rank |
fgm_rank | Int64 | Yes | — | Field goals made rank |
fga_rank | Int64 | Yes | — | Field goals attempted rank |
fg_pct_rank | Int64 | Yes | — | Field goal percentage rank |
fg3m_rank | Int64 | Yes | — | Three-point field goals made rank |
fg3a_rank | Int64 | Yes | — | Three-point field goals attempted rank |
fg3_pct_rank | Int64 | Yes | — | Three-point percentage rank |
ftm_rank | Int64 | Yes | — | Free throws made rank |
fta_rank | Int64 | Yes | — | Free throws attempted rank |
ft_pct_rank | Int64 | Yes | — | Free throw percentage rank |
oreb_rank | Int64 | Yes | — | Offensive rebounds rank |
dreb_rank | Int64 | Yes | — | Defensive rebounds rank |
reb_rank | Int64 | Yes | — | Total rebounds rank |
ast_rank | Int64 | Yes | — | Assists rank |
tov_rank | Int64 | Yes | — | Turnovers rank |
stl_rank | Int64 | Yes | — | Steals rank |
blk_rank | Int64 | Yes | — | Blocks rank |
blka_rank | Int64 | Yes | — | Blocked attempts rank |
pf_rank | Int64 | Yes | — | Personal fouls rank |
pfd_rank | Int64 | Yes | — | Personal fouls drawn rank |
pts_rank | Int64 | Yes | — | Points scored rank |
plus_minus_rank | Int64 | Yes | — | Plus-minus rank |
nba_fantasy_pts_rank | Int64 | Yes | — | NBA fantasy points rank |
dd2_rank | Int64 | Yes | — | Double-doubles rank |
td3_rank | Int64 | Yes | — | Triple-doubles rank |
cfid | Int64 | Yes | — | Custom filter identifier |
cfparams | String | Yes | — | Custom filter parameters |
staging_league_dash_team_stats
Class: StagingLeagueDashTeamStatsSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
team_id | Int64 | No | FK→staging_team.team_id | Unique team identifier |
team_name | String | Yes | — | Team name |
gp | Int64 | Yes | — | Games played |
w | Int64 | Yes | — | Wins |
l | Int64 | Yes | — | Losses |
w_pct | Float64 | Yes | — | Win percentage |
min | Float64 | Yes | — | Minutes played |
fgm | Float64 | Yes | — | Field goals made |
fga | Float64 | Yes | — | Field goals attempted |
fg_pct | Float64 | Yes | — | Field goal percentage |
fg3m | Float64 | Yes | — | Three-point field goals made |
fg3a | Float64 | Yes | — | Three-point field goals attempted |
fg3_pct | Float64 | Yes | — | Three-point field goal percentage |
ftm | Float64 | Yes | — | Free throws made |
fta | Float64 | Yes | — | Free throws attempted |
ft_pct | Float64 | Yes | — | Free throw percentage |
oreb | Float64 | Yes | — | Offensive rebounds |
dreb | Float64 | Yes | — | Defensive rebounds |
reb | Float64 | Yes | — | Total rebounds |
ast | Float64 | Yes | — | Assists |
tov | Float64 | Yes | — | Turnovers |
stl | Float64 | Yes | — | Steals |
blk | Float64 | Yes | — | Blocks |
blka | Float64 | Yes | — | Blocked attempts |
pf | Float64 | Yes | — | Personal fouls |
pfd | Float64 | Yes | — | Personal fouls drawn |
pts | Float64 | Yes | — | Points scored |
plus_minus | Float64 | Yes | — | Plus-minus differential |
gp_rank | Int64 | Yes | — | Games played rank |
w_rank | Int64 | Yes | — | Wins rank |
l_rank | Int64 | Yes | — | Losses rank |
w_pct_rank | Int64 | Yes | — | Win percentage rank |
min_rank | Int64 | Yes | — | Minutes played rank |
fgm_rank | Int64 | Yes | — | Field goals made rank |
fga_rank | Int64 | Yes | — | Field goals attempted rank |
fg_pct_rank | Int64 | Yes | — | Field goal percentage rank |
fg3m_rank | Int64 | Yes | — | Three-point field goals made rank |
fg3a_rank | Int64 | Yes | — | Three-point field goals attempted rank |
fg3_pct_rank | Int64 | Yes | — | Three-point percentage rank |
ftm_rank | Int64 | Yes | — | Free throws made rank |
fta_rank | Int64 | Yes | — | Free throws attempted rank |
ft_pct_rank | Int64 | Yes | — | Free throw percentage rank |
oreb_rank | Int64 | Yes | — | Offensive rebounds rank |
dreb_rank | Int64 | Yes | — | Defensive rebounds rank |
reb_rank | Int64 | Yes | — | Total rebounds rank |
ast_rank | Int64 | Yes | — | Assists rank |
tov_rank | Int64 | Yes | — | Turnovers rank |
stl_rank | Int64 | Yes | — | Steals rank |
blk_rank | Int64 | Yes | — | Blocks rank |
blka_rank | Int64 | Yes | — | Blocked attempts rank |
pf_rank | Int64 | Yes | — | Personal fouls rank |
pfd_rank | Int64 | Yes | — | Personal fouls drawn rank |
pts_rank | Int64 | Yes | — | Points scored rank |
plus_minus_rank | Int64 | Yes | — | Plus-minus rank |
cfid | Int64 | Yes | — | Custom filter identifier |
cfparams | String | Yes | — | Custom filter parameters |
staging_league_game_log
Class: StagingLeagueGameLogSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
season_id | String | No | — | Season identifier |
team_id | Int64 | No | gt=0, FK→staging_team.team_id | Unique team identifier |
team_abbreviation | String | No | — | Team abbreviation code |
team_name | String | No | — | Team name |
game_id | String | No | — | Unique game identifier |
game_date | String | No | — | Date of the game |
matchup | String | No | — | Matchup string (e.g. LAL vs. BOS) |
wl | String | Yes | in=['W', 'L'] | Win or loss indicator |
w | Int64 | Yes | — | Wins |
l | Int64 | Yes | — | Losses |
w_pct | Float64 | Yes | — | Win percentage |
min | Float64 | Yes | — | Minutes played |
fgm | Float64 | Yes | — | Field goals made |
fga | Float64 | Yes | — | Field goals attempted |
fg_pct | Float64 | Yes | — | Field goal percentage |
fg3m | Float64 | Yes | — | Three-point field goals made |
fg3a | Float64 | Yes | — | Three-point field goals attempted |
fg3_pct | Float64 | Yes | — | Three-point field goal percentage |
ftm | Float64 | Yes | — | Free throws made |
fta | Float64 | Yes | — | Free throws attempted |
ft_pct | Float64 | Yes | — | Free throw percentage |
oreb | Float64 | Yes | — | Offensive rebounds |
dreb | Float64 | Yes | — | Defensive rebounds |
reb | Float64 | Yes | — | Total rebounds |
ast | Float64 | Yes | — | Assists |
stl | Float64 | Yes | — | Steals |
blk | Float64 | Yes | — | Blocks |
tov | Float64 | Yes | — | Turnovers |
pf | Float64 | Yes | — | Personal fouls |
pts | Float64 | Yes | — | Points scored |
plus_minus | Float64 | Yes | — | Plus-minus differential |
video_available | Int64 | Yes | — | Video availability flag |
staging_league_lineup_viz
Class: StagingLeagueLineupVizSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
group_id | String | No | — | Lineup group identifier |
group_name | String | Yes | — | Lineup player names |
team_id | Int64 | No | FK→staging_team.team_id | Team identifier |
team_abbreviation | String | Yes | — | Team abbreviation code |
min | Float64 | Yes | — | Minutes played |
off_rating | Float64 | Yes | — | Offensive rating |
def_rating | Float64 | Yes | — | Defensive rating |
net_rating | Float64 | Yes | — | Net rating |
pace | Float64 | Yes | — | Pace factor |
ts_pct | Float64 | Yes | — | True shooting percentage |
fta_rate | Float64 | Yes | — | Free throw attempt rate |
tm_ast_pct | Float64 | Yes | — | Team assist percentage |
pct_fga_2pt | Float64 | Yes | — | Percentage of field goal attempts from two-point range |
pct_fga_3pt | Float64 | Yes | — | Percentage of field goal attempts from three-point range |
pct_pts_2pt_mr | Float64 | Yes | — | Percentage of points from mid-range two-pointers |
pct_pts_fb | Float64 | Yes | — | Percentage of points from fast breaks |
pct_pts_ft | Float64 | Yes | — | Percentage of points from free throws |
pct_pts_paint | Float64 | Yes | — | Percentage of points in the paint |
pct_ast_fgm | Float64 | Yes | — | Percentage of assisted field goals |
pct_uast_fgm | Float64 | Yes | — | Percentage of unassisted field goals |
opp_fg3_pct | Float64 | Yes | — | Opponent three-point percentage |
opp_efg_pct | Float64 | Yes | — | Opponent effective field goal percentage |
opp_fta_rate | Float64 | Yes | — | Opponent free throw attempt rate |
opp_tov_pct | Float64 | Yes | — | Opponent turnover percentage |
staging_league_standings_v3
Class: StagingLeagueStandingsV3Schema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
league_id | String | No | — | League identifier |
season_id | String | Yes | — | Season identifier |
team_id | Int64 | No | gt=0, FK→staging_team.team_id | Unique team identifier |
team_city | String | Yes | — | Team city name |
team_name | String | Yes | — | Team name |
team_slug | String | Yes | — | URL-friendly team slug |
conference | String | Yes | in=['East', 'West'] | Conference name |
conference_record | String | Yes | — | Win-loss record in conference |
playoff_rank | Int64 | Yes | gt=0 | Playoff seeding rank |
clinch_indicator | String | Yes | — | Clinch status indicator |
division | String | Yes | — | Division name |
division_record | String | Yes | — | Win-loss record in division |
division_rank | Int64 | Yes | gt=0 | Rank within division |
wins | Int64 | Yes | — | Total wins |
losses | Int64 | Yes | — | Total losses |
win_pct | Float64 | Yes | — | Winning percentage |
league_rank | Int64 | Yes | gt=0 | Overall league rank |
record | String | Yes | — | Overall win-loss record |
home | String | Yes | — | Home win-loss record |
road | String | Yes | — | Road win-loss record |
l10 | String | Yes | — | Record in last 10 games |
long_win_streak | Int64 | Yes | — | Longest winning streak |
long_loss_streak | Int64 | Yes | — | Longest losing streak |
current_streak | String | Yes | — | Current win or loss streak |
ot_record | String | Yes | — | Overtime win-loss record |
three_pts_or_less | String | Yes | — | Record in games decided by 3 points or less |
ten_pts_or_more | String | Yes | — | Record in games decided by 10 points or more |
conference_games_back | Float64 | Yes | — | Games behind conference leader |
division_games_back | Float64 | Yes | — | Games behind division leader |
clinched_conference_title | Int64 | Yes | in=[0, 1] | Whether team clinched conference |
clinched_division_title | Int64 | Yes | in=[0, 1] | Whether team clinched division |
clinched_playoff_birth | Int64 | Yes | in=[0, 1] | Whether team clinched playoff berth |
eliminated_conference | Int64 | Yes | in=[0, 1] | Whether team eliminated from conference playoff contention |
pts_pg | Float64 | Yes | — | Points per game |
opp_pts_pg | Float64 | Yes | — | Opponent points per game |
diff_pts_pg | Float64 | Yes | — | Point differential per game |
staging_play_by_play_v2
Class: StagingPlayByPlayV2Schema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
game_id | String | No | — | Unique game identifier |
eventnum | Int64 | No | — | Event sequence number |
eventmsgtype | Int64 | No | — | Event message type code |
eventmsgactiontype | Int64 | No | — | Event message action type code |
period | Int64 | No | range=[1, 10] | Game period number |
wctimestring | String | Yes | — | Wall clock time string |
pctimestring | String | Yes | — | Period clock time string |
homedescription | String | Yes | — | Play description for home team |
neutraldescription | String | Yes | — | Neutral play description |
visitordescription | String | Yes | — | Play description for visitor team |
score | String | Yes | — | Current game score |
scoremargin | String | Yes | — | Score margin value |
person1type | Int64 | Yes | — | Person 1 type identifier |
player1_id | Int64 | Yes | FK→staging_player.person_id | Player 1 unique identifier |
player1_name | String | Yes | — | Player 1 full name |
player1_team_id | Int64 | Yes | FK→staging_team.team_id | Player 1 team identifier |
player1_team_city | String | Yes | — | Player 1 team city |
player1_team_nickname | String | Yes | — | Player 1 team nickname |
player1_team_abbreviation | String | Yes | — | Player 1 team abbreviation |
person2type | Int64 | Yes | — | Person 2 type identifier |
player2_id | Int64 | Yes | FK→staging_player.person_id | Player 2 unique identifier |
player2_name | String | Yes | — | Player 2 full name |
player2_team_id | Int64 | Yes | FK→staging_team.team_id | Player 2 team identifier |
player2_team_city | String | Yes | — | Player 2 team city |
player2_team_nickname | String | Yes | — | Player 2 team nickname |
player2_team_abbreviation | String | Yes | — | Player 2 team abbreviation |
person3type | Int64 | Yes | — | Person 3 type identifier |
player3_id | Int64 | Yes | FK→staging_player.person_id | Player 3 unique identifier |
player3_name | String | Yes | — | Player 3 full name |
player3_team_id | Int64 | Yes | FK→staging_team.team_id | Player 3 team identifier |
player3_team_city | String | Yes | — | Player 3 team city |
player3_team_nickname | String | Yes | — | Player 3 team nickname |
player3_team_abbreviation | String | Yes | — | Player 3 team abbreviation |
video_available_flag | Int64 | Yes | — | Video availability flag |
staging_play_by_play_v3
Class: StagingPlayByPlayV3Schema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
game_id | String | No | — | Unique game identifier |
action_number | Int64 | No | — | Sequential action number within game |
clock | String | Yes | — | Game clock time string |
period | Int64 | No | range=[1, 10] | Game period number |
team_id | Int64 | Yes | FK→staging_team.team_id | Team identifier |
team_tricode | String | Yes | — | Three-letter team abbreviation code |
person_id | Int64 | Yes | FK→staging_player.person_id | Person identifier |
player_name | String | Yes | — | Full player name |
player_name_i | String | Yes | — | Player name in initial format |
x_legacy | Float64 | Yes | — | Legacy x-coordinate of action |
y_legacy | Float64 | Yes | — | Legacy y-coordinate of action |
shot_distance | Float64 | Yes | — | Distance of shot in feet |
shot_result | String | Yes | — | Result of shot attempt |
is_field_goal | Int64 | Yes | in=[0, 1] | Flag indicating if action is a field goal attempt |
score_home | String | Yes | — | Home team score |
score_away | String | Yes | — | Away team score |
points_total | Int64 | Yes | — | Total points scored on the play |
location | String | Yes | — | Home or away location indicator |
description | String | Yes | — | Text description of the play |
action_type | String | Yes | — | Type of action performed |
sub_type | String | Yes | — | Sub-type of action performed |
video_available | Int64 | Yes | — | Video availability flag |
action_id | Int64 | Yes | — | Unique action identifier |
staging_player_dashboard_clutch
Class: StagingPlayerDashboardClutchSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
cfid | Int64 | Yes | — | Context filter identifier returned by nba_api. |
cfparams | String | Yes | — | Serialized context filter parameters returned by nba_api. |
fgm_rank | Int64 | Yes | — | Field goals made rank. |
fga_rank | Int64 | Yes | — | Field goals attempted rank. |
fg_pct_rank | Int64 | Yes | — | Field goal percentage rank. |
fg3m_rank | Int64 | Yes | — | Three-pointers made rank. |
fg3a_rank | Int64 | Yes | — | Three-pointers attempted rank. |
fg3_pct_rank | Int64 | Yes | — | Three-point percentage rank. |
blka_rank | Int64 | Yes | — | Blocked attempts rank. |
gp_rank | Int64 | Yes | — | Games played rank. |
w_rank | Int64 | Yes | — | Wins rank. |
l_rank | Int64 | Yes | — | Losses rank. |
w_pct_rank | Int64 | Yes | — | Win percentage rank. |
min_rank | Int64 | Yes | — | Minutes played rank. |
ftm_rank | Int64 | Yes | — | Free throws made rank. |
fta_rank | Int64 | Yes | — | Free throws attempted rank. |
ft_pct_rank | Int64 | Yes | — | Free throw percentage rank. |
oreb_rank | Int64 | Yes | — | Offensive rebounds rank. |
dreb_rank | Int64 | Yes | — | Defensive rebounds rank. |
reb_rank | Int64 | Yes | — | Rebounds rank. |
ast_rank | Int64 | Yes | — | Assists rank. |
tov_rank | Int64 | Yes | — | Turnovers rank. |
stl_rank | Int64 | Yes | — | Steals rank. |
blk_rank | Int64 | Yes | — | Blocks rank. |
pf_rank | Int64 | Yes | — | Personal fouls rank. |
pfd_rank | Int64 | Yes | — | Personal fouls drawn rank. |
pts_rank | Int64 | Yes | — | Points rank. |
plus_minus_rank | Int64 | Yes | — | Plus-minus rank. |
nba_fantasy_pts_rank | Int64 | Yes | — | NBA fantasy points rank. |
dd2_rank | Int64 | Yes | — | Double-doubles rank. |
td3_rank | Int64 | Yes | — | Triple-doubles rank. |
fgm | Float64 | Yes | — | Field goals made. |
fga | Float64 | Yes | — | Field goals attempted. |
fg_pct | Float64 | Yes | — | Field goal percentage. |
fg3m | Float64 | Yes | — | Three-pointers made. |
fg3a | Float64 | Yes | — | Three-pointers attempted. |
fg3_pct | Float64 | Yes | — | Three-point percentage. |
blka | Float64 | Yes | — | Blocked attempts. |
gp | Int64 | Yes | — | Games played. |
w | Int64 | Yes | — | Wins. |
l | Int64 | Yes | — | Losses. |
w_pct | Float64 | Yes | — | Win percentage. |
min | Float64 | Yes | — | Minutes played. |
ftm | Float64 | Yes | — | Free throws made. |
fta | Float64 | Yes | — | Free throws attempted. |
ft_pct | Float64 | Yes | — | Free throw percentage. |
oreb | Float64 | Yes | — | Offensive rebounds. |
dreb | Float64 | Yes | — | Defensive rebounds. |
reb | Float64 | Yes | — | Total rebounds. |
ast | Float64 | Yes | — | Assists. |
tov | Float64 | Yes | — | Turnovers. |
stl | Float64 | Yes | — | Steals. |
blk | Float64 | Yes | — | Blocks. |
pf | Float64 | Yes | — | Personal fouls. |
pfd | Float64 | Yes | — | Personal fouls drawn. |
pts | Float64 | Yes | — | Points scored. |
plus_minus | Float64 | Yes | — | Plus-minus differential. |
nba_fantasy_pts | Float64 | Yes | — | NBA fantasy points. |
dd2 | Float64 | Yes | — | Double-doubles. |
td3 | Float64 | Yes | — | Triple-doubles. |
group_set | String | Yes | — | Grouping set returned by the player dashboard endpoint. |
group_value | String | Yes | — | Grouping value returned by the player dashboard endpoint. |
player_id | Int64 | No | gt=0 | Queried player identifier. |
season_year | String | No | — | Queried season year. |
season_type | String | No | — | Queried season type. |
staging_player_dashboard_game_splits
Class: StagingPlayerDashboardGameSplitsSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
cfid | Int64 | Yes | — | Context filter identifier returned by nba_api. |
cfparams | String | Yes | — | Serialized context filter parameters returned by nba_api. |
fgm_rank | Int64 | Yes | — | Field goals made rank. |
fga_rank | Int64 | Yes | — | Field goals attempted rank. |
fg_pct_rank | Int64 | Yes | — | Field goal percentage rank. |
fg3m_rank | Int64 | Yes | — | Three-pointers made rank. |
fg3a_rank | Int64 | Yes | — | Three-pointers attempted rank. |
fg3_pct_rank | Int64 | Yes | — | Three-point percentage rank. |
blka_rank | Int64 | Yes | — | Blocked attempts rank. |
gp_rank | Int64 | Yes | — | Games played rank. |
w_rank | Int64 | Yes | — | Wins rank. |
l_rank | Int64 | Yes | — | Losses rank. |
w_pct_rank | Int64 | Yes | — | Win percentage rank. |
min_rank | Int64 | Yes | — | Minutes played rank. |
ftm_rank | Int64 | Yes | — | Free throws made rank. |
fta_rank | Int64 | Yes | — | Free throws attempted rank. |
ft_pct_rank | Int64 | Yes | — | Free throw percentage rank. |
oreb_rank | Int64 | Yes | — | Offensive rebounds rank. |
dreb_rank | Int64 | Yes | — | Defensive rebounds rank. |
reb_rank | Int64 | Yes | — | Rebounds rank. |
ast_rank | Int64 | Yes | — | Assists rank. |
tov_rank | Int64 | Yes | — | Turnovers rank. |
stl_rank | Int64 | Yes | — | Steals rank. |
blk_rank | Int64 | Yes | — | Blocks rank. |
pf_rank | Int64 | Yes | — | Personal fouls rank. |
pfd_rank | Int64 | Yes | — | Personal fouls drawn rank. |
pts_rank | Int64 | Yes | — | Points rank. |
plus_minus_rank | Int64 | Yes | — | Plus-minus rank. |
nba_fantasy_pts_rank | Int64 | Yes | — | NBA fantasy points rank. |
dd2_rank | Int64 | Yes | — | Double-doubles rank. |
td3_rank | Int64 | Yes | — | Triple-doubles rank. |
fgm | Float64 | Yes | — | Field goals made. |
fga | Float64 | Yes | — | Field goals attempted. |
fg_pct | Float64 | Yes | — | Field goal percentage. |
fg3m | Float64 | Yes | — | Three-pointers made. |
fg3a | Float64 | Yes | — | Three-pointers attempted. |
fg3_pct | Float64 | Yes | — | Three-point percentage. |
blka | Float64 | Yes | — | Blocked attempts. |
gp | Int64 | Yes | — | Games played. |
w | Int64 | Yes | — | Wins. |
l | Int64 | Yes | — | Losses. |
w_pct | Float64 | Yes | — | Win percentage. |
min | Float64 | Yes | — | Minutes played. |
ftm | Float64 | Yes | — | Free throws made. |
fta | Float64 | Yes | — | Free throws attempted. |
ft_pct | Float64 | Yes | — | Free throw percentage. |
oreb | Float64 | Yes | — | Offensive rebounds. |
dreb | Float64 | Yes | — | Defensive rebounds. |
reb | Float64 | Yes | — | Total rebounds. |
ast | Float64 | Yes | — | Assists. |
tov | Float64 | Yes | — | Turnovers. |
stl | Float64 | Yes | — | Steals. |
blk | Float64 | Yes | — | Blocks. |
pf | Float64 | Yes | — | Personal fouls. |
pfd | Float64 | Yes | — | Personal fouls drawn. |
pts | Float64 | Yes | — | Points scored. |
plus_minus | Float64 | Yes | — | Plus-minus differential. |
nba_fantasy_pts | Float64 | Yes | — | NBA fantasy points. |
dd2 | Float64 | Yes | — | Double-doubles. |
td3 | Float64 | Yes | — | Triple-doubles. |
group_set | String | Yes | — | Grouping set returned by the player dashboard endpoint. |
group_value | String | Yes | — | Grouping value returned by the player dashboard endpoint. |
player_id | Int64 | No | gt=0 | Queried player identifier. |
season_year | String | No | — | Queried season year. |
season_type | String | No | — | Queried season type. |
staging_player_dashboard_general_splits
Class: StagingPlayerDashboardGeneralSplitsSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
cfid | Int64 | Yes | — | Context filter identifier returned by nba_api. |
cfparams | String | Yes | — | Serialized context filter parameters returned by nba_api. |
fgm_rank | Int64 | Yes | — | Field goals made rank. |
fga_rank | Int64 | Yes | — | Field goals attempted rank. |
fg_pct_rank | Int64 | Yes | — | Field goal percentage rank. |
fg3m_rank | Int64 | Yes | — | Three-pointers made rank. |
fg3a_rank | Int64 | Yes | — | Three-pointers attempted rank. |
fg3_pct_rank | Int64 | Yes | — | Three-point percentage rank. |
blka_rank | Int64 | Yes | — | Blocked attempts rank. |
gp_rank | Int64 | Yes | — | Games played rank. |
w_rank | Int64 | Yes | — | Wins rank. |
l_rank | Int64 | Yes | — | Losses rank. |
w_pct_rank | Int64 | Yes | — | Win percentage rank. |
min_rank | Int64 | Yes | — | Minutes played rank. |
ftm_rank | Int64 | Yes | — | Free throws made rank. |
fta_rank | Int64 | Yes | — | Free throws attempted rank. |
ft_pct_rank | Int64 | Yes | — | Free throw percentage rank. |
oreb_rank | Int64 | Yes | — | Offensive rebounds rank. |
dreb_rank | Int64 | Yes | — | Defensive rebounds rank. |
reb_rank | Int64 | Yes | — | Rebounds rank. |
ast_rank | Int64 | Yes | — | Assists rank. |
tov_rank | Int64 | Yes | — | Turnovers rank. |
stl_rank | Int64 | Yes | — | Steals rank. |
blk_rank | Int64 | Yes | — | Blocks rank. |
pf_rank | Int64 | Yes | — | Personal fouls rank. |
pfd_rank | Int64 | Yes | — | Personal fouls drawn rank. |
pts_rank | Int64 | Yes | — | Points rank. |
plus_minus_rank | Int64 | Yes | — | Plus-minus rank. |
nba_fantasy_pts_rank | Int64 | Yes | — | NBA fantasy points rank. |
dd2_rank | Int64 | Yes | — | Double-doubles rank. |
td3_rank | Int64 | Yes | — | Triple-doubles rank. |
fgm | Float64 | Yes | — | Field goals made. |
fga | Float64 | Yes | — | Field goals attempted. |
fg_pct | Float64 | Yes | — | Field goal percentage. |
fg3m | Float64 | Yes | — | Three-pointers made. |
fg3a | Float64 | Yes | — | Three-pointers attempted. |
fg3_pct | Float64 | Yes | — | Three-point percentage. |
blka | Float64 | Yes | — | Blocked attempts. |
gp | Int64 | Yes | — | Games played. |
w | Int64 | Yes | — | Wins. |
l | Int64 | Yes | — | Losses. |
w_pct | Float64 | Yes | — | Win percentage. |
min | Float64 | Yes | — | Minutes played. |
ftm | Float64 | Yes | — | Free throws made. |
fta | Float64 | Yes | — | Free throws attempted. |
ft_pct | Float64 | Yes | — | Free throw percentage. |
oreb | Float64 | Yes | — | Offensive rebounds. |
dreb | Float64 | Yes | — | Defensive rebounds. |
reb | Float64 | Yes | — | Total rebounds. |
ast | Float64 | Yes | — | Assists. |
tov | Float64 | Yes | — | Turnovers. |
stl | Float64 | Yes | — | Steals. |
blk | Float64 | Yes | — | Blocks. |
pf | Float64 | Yes | — | Personal fouls. |
pfd | Float64 | Yes | — | Personal fouls drawn. |
pts | Float64 | Yes | — | Points scored. |
plus_minus | Float64 | Yes | — | Plus-minus differential. |
nba_fantasy_pts | Float64 | Yes | — | NBA fantasy points. |
dd2 | Float64 | Yes | — | Double-doubles. |
td3 | Float64 | Yes | — | Triple-doubles. |
group_set | String | Yes | — | Grouping set returned by the player dashboard endpoint. |
group_value | String | Yes | — | Grouping value returned by the player dashboard endpoint. |
player_id | Int64 | No | gt=0 | Queried player identifier. |
season_year | String | No | — | Queried season year. |
season_type | String | No | — | Queried season type. |
staging_player_dashboard_last_n_games
Class: StagingPlayerDashboardLastNGamesSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
cfid | Int64 | Yes | — | Context filter identifier returned by nba_api. |
cfparams | String | Yes | — | Serialized context filter parameters returned by nba_api. |
fgm_rank | Int64 | Yes | — | Field goals made rank. |
fga_rank | Int64 | Yes | — | Field goals attempted rank. |
fg_pct_rank | Int64 | Yes | — | Field goal percentage rank. |
fg3m_rank | Int64 | Yes | — | Three-pointers made rank. |
fg3a_rank | Int64 | Yes | — | Three-pointers attempted rank. |
fg3_pct_rank | Int64 | Yes | — | Three-point percentage rank. |
blka_rank | Int64 | Yes | — | Blocked attempts rank. |
gp_rank | Int64 | Yes | — | Games played rank. |
w_rank | Int64 | Yes | — | Wins rank. |
l_rank | Int64 | Yes | — | Losses rank. |
w_pct_rank | Int64 | Yes | — | Win percentage rank. |
min_rank | Int64 | Yes | — | Minutes played rank. |
ftm_rank | Int64 | Yes | — | Free throws made rank. |
fta_rank | Int64 | Yes | — | Free throws attempted rank. |
ft_pct_rank | Int64 | Yes | — | Free throw percentage rank. |
oreb_rank | Int64 | Yes | — | Offensive rebounds rank. |
dreb_rank | Int64 | Yes | — | Defensive rebounds rank. |
reb_rank | Int64 | Yes | — | Rebounds rank. |
ast_rank | Int64 | Yes | — | Assists rank. |
tov_rank | Int64 | Yes | — | Turnovers rank. |
stl_rank | Int64 | Yes | — | Steals rank. |
blk_rank | Int64 | Yes | — | Blocks rank. |
pf_rank | Int64 | Yes | — | Personal fouls rank. |
pfd_rank | Int64 | Yes | — | Personal fouls drawn rank. |
pts_rank | Int64 | Yes | — | Points rank. |
plus_minus_rank | Int64 | Yes | — | Plus-minus rank. |
nba_fantasy_pts_rank | Int64 | Yes | — | NBA fantasy points rank. |
dd2_rank | Int64 | Yes | — | Double-doubles rank. |
td3_rank | Int64 | Yes | — | Triple-doubles rank. |
fgm | Float64 | Yes | — | Field goals made. |
fga | Float64 | Yes | — | Field goals attempted. |
fg_pct | Float64 | Yes | — | Field goal percentage. |
fg3m | Float64 | Yes | — | Three-pointers made. |
fg3a | Float64 | Yes | — | Three-pointers attempted. |
fg3_pct | Float64 | Yes | — | Three-point percentage. |
blka | Float64 | Yes | — | Blocked attempts. |
gp | Int64 | Yes | — | Games played. |
w | Int64 | Yes | — | Wins. |
l | Int64 | Yes | — | Losses. |
w_pct | Float64 | Yes | — | Win percentage. |
min | Float64 | Yes | — | Minutes played. |
ftm | Float64 | Yes | — | Free throws made. |
fta | Float64 | Yes | — | Free throws attempted. |
ft_pct | Float64 | Yes | — | Free throw percentage. |
oreb | Float64 | Yes | — | Offensive rebounds. |
dreb | Float64 | Yes | — | Defensive rebounds. |
reb | Float64 | Yes | — | Total rebounds. |
ast | Float64 | Yes | — | Assists. |
tov | Float64 | Yes | — | Turnovers. |
stl | Float64 | Yes | — | Steals. |
blk | Float64 | Yes | — | Blocks. |
pf | Float64 | Yes | — | Personal fouls. |
pfd | Float64 | Yes | — | Personal fouls drawn. |
pts | Float64 | Yes | — | Points scored. |
plus_minus | Float64 | Yes | — | Plus-minus differential. |
nba_fantasy_pts | Float64 | Yes | — | NBA fantasy points. |
dd2 | Float64 | Yes | — | Double-doubles. |
td3 | Float64 | Yes | — | Triple-doubles. |
group_set | String | Yes | — | Grouping set returned by the player dashboard endpoint. |
group_value | String | Yes | — | Grouping value returned by the player dashboard endpoint. |
player_id | Int64 | No | gt=0 | Queried player identifier. |
season_year | String | No | — | Queried season year. |
season_type | String | No | — | Queried season type. |
staging_player_dashboard_shooting_splits
Class: StagingPlayerDashboardShootingSplitsSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
cfid | Int64 | Yes | — | Context filter identifier returned by nba_api. |
cfparams | String | Yes | — | Serialized context filter parameters returned by nba_api. |
efg_pct_rank | Int64 | Yes | — | Effective field goal percentage rank. |
pct_ast_2pm_rank | Int64 | Yes | — | Assisted two-point make percentage rank. |
pct_uast_2pm_rank | Int64 | Yes | — | Unassisted two-point make percentage rank. |
pct_ast_3pm_rank | Int64 | Yes | — | Assisted three-point make percentage rank. |
pct_uast_3pm_rank | Int64 | Yes | — | Unassisted three-point make percentage rank. |
pct_ast_fgm_rank | Int64 | Yes | — | Assisted field goal make percentage rank. |
pct_uast_fgm_rank | Int64 | Yes | — | Unassisted field goal make percentage rank. |
fgm_rank | Int64 | Yes | — | Field goals made rank. |
fga_rank | Int64 | Yes | — | Field goals attempted rank. |
fg_pct_rank | Int64 | Yes | — | Field goal percentage rank. |
fg3m_rank | Int64 | Yes | — | Three-pointers made rank. |
fg3a_rank | Int64 | Yes | — | Three-pointers attempted rank. |
fg3_pct_rank | Int64 | Yes | — | Three-point percentage rank. |
blka_rank | Int64 | Yes | — | Blocked attempts rank. |
efg_pct | Float64 | Yes | — | Effective field goal percentage. |
pct_ast_2pm | Float64 | Yes | — | Share of made twos that were assisted. |
pct_uast_2pm | Float64 | Yes | — | Share of made twos that were unassisted. |
pct_ast_3pm | Float64 | Yes | — | Share of made threes that were assisted. |
pct_uast_3pm | Float64 | Yes | — | Share of made threes that were unassisted. |
pct_ast_fgm | Float64 | Yes | — | Share of made field goals that were assisted. |
pct_uast_fgm | Float64 | Yes | — | Share of made field goals that were unassisted. |
fgm | Float64 | Yes | — | Field goals made. |
fga | Float64 | Yes | — | Field goals attempted. |
fg_pct | Float64 | Yes | — | Field goal percentage. |
fg3m | Float64 | Yes | — | Three-pointers made. |
fg3a | Float64 | Yes | — | Three-pointers attempted. |
fg3_pct | Float64 | Yes | — | Three-point percentage. |
blka | Float64 | Yes | — | Blocked attempts. |
group_set | String | Yes | — | Grouping set returned by the player dashboard endpoint. |
group_value | String | Yes | — | Grouping value returned by the player dashboard endpoint. |
player_id | Int64 | No | gt=0 | Queried player identifier. |
season_year | String | No | — | Queried season year. |
season_type | String | No | — | Queried season type. |
staging_player_dashboard_team_performance
Class: StagingPlayerDashboardTeamPerformanceSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
cfid | Int64 | Yes | — | Context filter identifier returned by nba_api. |
cfparams | String | Yes | — | Serialized context filter parameters returned by nba_api. |
fgm_rank | Int64 | Yes | — | Field goals made rank. |
fga_rank | Int64 | Yes | — | Field goals attempted rank. |
fg_pct_rank | Int64 | Yes | — | Field goal percentage rank. |
fg3m_rank | Int64 | Yes | — | Three-pointers made rank. |
fg3a_rank | Int64 | Yes | — | Three-pointers attempted rank. |
fg3_pct_rank | Int64 | Yes | — | Three-point percentage rank. |
blka_rank | Int64 | Yes | — | Blocked attempts rank. |
gp_rank | Int64 | Yes | — | Games played rank. |
w_rank | Int64 | Yes | — | Wins rank. |
l_rank | Int64 | Yes | — | Losses rank. |
w_pct_rank | Int64 | Yes | — | Win percentage rank. |
min_rank | Int64 | Yes | — | Minutes played rank. |
ftm_rank | Int64 | Yes | — | Free throws made rank. |
fta_rank | Int64 | Yes | — | Free throws attempted rank. |
ft_pct_rank | Int64 | Yes | — | Free throw percentage rank. |
oreb_rank | Int64 | Yes | — | Offensive rebounds rank. |
dreb_rank | Int64 | Yes | — | Defensive rebounds rank. |
reb_rank | Int64 | Yes | — | Rebounds rank. |
ast_rank | Int64 | Yes | — | Assists rank. |
tov_rank | Int64 | Yes | — | Turnovers rank. |
stl_rank | Int64 | Yes | — | Steals rank. |
blk_rank | Int64 | Yes | — | Blocks rank. |
pf_rank | Int64 | Yes | — | Personal fouls rank. |
pfd_rank | Int64 | Yes | — | Personal fouls drawn rank. |
pts_rank | Int64 | Yes | — | Points rank. |
plus_minus_rank | Int64 | Yes | — | Plus-minus rank. |
nba_fantasy_pts_rank | Int64 | Yes | — | NBA fantasy points rank. |
dd2_rank | Int64 | Yes | — | Double-doubles rank. |
td3_rank | Int64 | Yes | — | Triple-doubles rank. |
fgm | Float64 | Yes | — | Field goals made. |
fga | Float64 | Yes | — | Field goals attempted. |
fg_pct | Float64 | Yes | — | Field goal percentage. |
fg3m | Float64 | Yes | — | Three-pointers made. |
fg3a | Float64 | Yes | — | Three-pointers attempted. |
fg3_pct | Float64 | Yes | — | Three-point percentage. |
blka | Float64 | Yes | — | Blocked attempts. |
gp | Int64 | Yes | — | Games played. |
w | Int64 | Yes | — | Wins. |
l | Int64 | Yes | — | Losses. |
w_pct | Float64 | Yes | — | Win percentage. |
min | Float64 | Yes | — | Minutes played. |
ftm | Float64 | Yes | — | Free throws made. |
fta | Float64 | Yes | — | Free throws attempted. |
ft_pct | Float64 | Yes | — | Free throw percentage. |
oreb | Float64 | Yes | — | Offensive rebounds. |
dreb | Float64 | Yes | — | Defensive rebounds. |
reb | Float64 | Yes | — | Total rebounds. |
ast | Float64 | Yes | — | Assists. |
tov | Float64 | Yes | — | Turnovers. |
stl | Float64 | Yes | — | Steals. |
blk | Float64 | Yes | — | Blocks. |
pf | Float64 | Yes | — | Personal fouls. |
pfd | Float64 | Yes | — | Personal fouls drawn. |
pts | Float64 | Yes | — | Points scored. |
plus_minus | Float64 | Yes | — | Plus-minus differential. |
nba_fantasy_pts | Float64 | Yes | — | NBA fantasy points. |
dd2 | Float64 | Yes | — | Double-doubles. |
td3 | Float64 | Yes | — | Triple-doubles. |
group_set | String | Yes | — | Grouping set returned by the player dashboard endpoint. |
group_value | String | Yes | — | Grouping value returned by the player dashboard endpoint. |
player_id | Int64 | No | gt=0 | Queried player identifier. |
season_year | String | No | — | Queried season year. |
season_type | String | No | — | Queried season type. |
staging_player_dashboard_year_over_year
Class: StagingPlayerDashboardYearOverYearSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
cfid | Int64 | Yes | — | Context filter identifier returned by nba_api. |
cfparams | String | Yes | — | Serialized context filter parameters returned by nba_api. |
fgm_rank | Int64 | Yes | — | Field goals made rank. |
fga_rank | Int64 | Yes | — | Field goals attempted rank. |
fg_pct_rank | Int64 | Yes | — | Field goal percentage rank. |
fg3m_rank | Int64 | Yes | — | Three-pointers made rank. |
fg3a_rank | Int64 | Yes | — | Three-pointers attempted rank. |
fg3_pct_rank | Int64 | Yes | — | Three-point percentage rank. |
blka_rank | Int64 | Yes | — | Blocked attempts rank. |
gp_rank | Int64 | Yes | — | Games played rank. |
w_rank | Int64 | Yes | — | Wins rank. |
l_rank | Int64 | Yes | — | Losses rank. |
w_pct_rank | Int64 | Yes | — | Win percentage rank. |
min_rank | Int64 | Yes | — | Minutes played rank. |
ftm_rank | Int64 | Yes | — | Free throws made rank. |
fta_rank | Int64 | Yes | — | Free throws attempted rank. |
ft_pct_rank | Int64 | Yes | — | Free throw percentage rank. |
oreb_rank | Int64 | Yes | — | Offensive rebounds rank. |
dreb_rank | Int64 | Yes | — | Defensive rebounds rank. |
reb_rank | Int64 | Yes | — | Rebounds rank. |
ast_rank | Int64 | Yes | — | Assists rank. |
tov_rank | Int64 | Yes | — | Turnovers rank. |
stl_rank | Int64 | Yes | — | Steals rank. |
blk_rank | Int64 | Yes | — | Blocks rank. |
pf_rank | Int64 | Yes | — | Personal fouls rank. |
pfd_rank | Int64 | Yes | — | Personal fouls drawn rank. |
pts_rank | Int64 | Yes | — | Points rank. |
plus_minus_rank | Int64 | Yes | — | Plus-minus rank. |
nba_fantasy_pts_rank | Int64 | Yes | — | NBA fantasy points rank. |
dd2_rank | Int64 | Yes | — | Double-doubles rank. |
td3_rank | Int64 | Yes | — | Triple-doubles rank. |
fgm | Float64 | Yes | — | Field goals made. |
fga | Float64 | Yes | — | Field goals attempted. |
fg_pct | Float64 | Yes | — | Field goal percentage. |
fg3m | Float64 | Yes | — | Three-pointers made. |
fg3a | Float64 | Yes | — | Three-pointers attempted. |
fg3_pct | Float64 | Yes | — | Three-point percentage. |
blka | Float64 | Yes | — | Blocked attempts. |
gp | Int64 | Yes | — | Games played. |
w | Int64 | Yes | — | Wins. |
l | Int64 | Yes | — | Losses. |
w_pct | Float64 | Yes | — | Win percentage. |
min | Float64 | Yes | — | Minutes played. |
ftm | Float64 | Yes | — | Free throws made. |
fta | Float64 | Yes | — | Free throws attempted. |
ft_pct | Float64 | Yes | — | Free throw percentage. |
oreb | Float64 | Yes | — | Offensive rebounds. |
dreb | Float64 | Yes | — | Defensive rebounds. |
reb | Float64 | Yes | — | Total rebounds. |
ast | Float64 | Yes | — | Assists. |
tov | Float64 | Yes | — | Turnovers. |
stl | Float64 | Yes | — | Steals. |
blk | Float64 | Yes | — | Blocks. |
pf | Float64 | Yes | — | Personal fouls. |
pfd | Float64 | Yes | — | Personal fouls drawn. |
pts | Float64 | Yes | — | Points scored. |
plus_minus | Float64 | Yes | — | Plus-minus differential. |
nba_fantasy_pts | Float64 | Yes | — | NBA fantasy points. |
dd2 | Float64 | Yes | — | Double-doubles. |
td3 | Float64 | Yes | — | Triple-doubles. |
team_id | Int64 | Yes | gt=0 | Team identifier for the season row. |
team_abbreviation | String | Yes | — | Team abbreviation. |
max_game_date | String | Yes | — | Most recent game date in the split. |
group_set | String | Yes | — | Grouping set returned by the player dashboard endpoint. |
group_value | String | Yes | — | Grouping value returned by the player dashboard endpoint. |
player_id | Int64 | No | gt=0 | Queried player identifier. |
season_year | String | No | — | Queried season year. |
season_type | String | No | — | Queried season type. |
staging_player_game_log
Class: StagingPlayerGameLogSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
season_id | String | No | — | Season identifier |
player_id | Int64 | No | gt=0, FK→staging_player.person_id | Unique player identifier |
game_id | String | No | — | Unique game identifier |
game_date | String | No | — | Date of the game |
matchup | String | No | — | Matchup string (e.g. LAL vs. BOS) |
wl | String | Yes | in=['W', 'L'] | Win or loss indicator |
min | Float64 | Yes | — | Minutes played |
fgm | Float64 | Yes | — | Field goals made |
fga | Float64 | Yes | — | Field goals attempted |
fg_pct | Float64 | Yes | — | Field goal percentage |
fg3m | Float64 | Yes | — | Three-point field goals made |
fg3a | Float64 | Yes | — | Three-point field goals attempted |
fg3_pct | Float64 | Yes | — | Three-point field goal percentage |
ftm | Float64 | Yes | — | Free throws made |
fta | Float64 | Yes | — | Free throws attempted |
ft_pct | Float64 | Yes | — | Free throw percentage |
oreb | Float64 | Yes | — | Offensive rebounds |
dreb | Float64 | Yes | — | Defensive rebounds |
reb | Float64 | Yes | — | Total rebounds |
ast | Float64 | Yes | — | Assists |
stl | Float64 | Yes | — | Steals |
blk | Float64 | Yes | — | Blocks |
tov | Float64 | Yes | — | Turnovers |
pf | Float64 | Yes | — | Personal fouls |
pts | Float64 | Yes | — | Points scored |
plus_minus | Float64 | Yes | — | Plus-minus differential |
staging_player_index
Class: StagingPlayerIndexSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
person_id | Int64 | No | gt=0 | Unique player identifier |
player_last_name | String | No | — | Player last name |
player_first_name | String | No | — | Player first name |
player_slug | String | Yes | — | URL-friendly player slug |
team_id | Int64 | Yes | FK→staging_team.team_id | Team identifier |
team_slug | String | Yes | — | URL-friendly team slug |
is_defunct | Int64 | Yes | — | Whether team is defunct |
team_city | String | Yes | — | Team city name |
team_name | String | Yes | — | Team name |
team_abbreviation | String | Yes | — | Team abbreviation code |
jersey_number | String | Yes | — | Jersey number as string |
position | String | Yes | — | Player position |
height | String | Yes | — | Player height as string |
weight | String | Yes | — | Player weight as string |
college | String | Yes | — | College attended |
country | String | Yes | — | Country of origin |
draft_year | Int64 | Yes | gt=1946 | Year drafted |
draft_round | Int64 | Yes | in=[1, 2] | Round drafted |
draft_number | Int64 | Yes | gt=0 | Overall draft pick number |
roster_status | Float64 | Yes | — | Active roster status |
pts | Float64 | Yes | — | Points per game |
reb | Float64 | Yes | — | Rebounds per game |
ast | Float64 | Yes | — | Assists per game |
stats_timeframe | String | Yes | — | Timeframe for stats |
from_year | String | Yes | — | First year in the league |
to_year | String | Yes | — | Last year in the league |
staging_player_perf_pts_scored
Class: StagingPlayerPerfPtsScoredSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
cfid | Int64 | Yes | — | Context filter identifier returned by nba_api. |
cfparams | String | Yes | — | Serialized context filter parameters returned by nba_api. |
fgm_rank | Int64 | Yes | — | Field goals made rank. |
fga_rank | Int64 | Yes | — | Field goals attempted rank. |
fg_pct_rank | Int64 | Yes | — | Field goal percentage rank. |
fg3m_rank | Int64 | Yes | — | Three-pointers made rank. |
fg3a_rank | Int64 | Yes | — | Three-pointers attempted rank. |
fg3_pct_rank | Int64 | Yes | — | Three-point percentage rank. |
blka_rank | Int64 | Yes | — | Blocked attempts rank. |
gp_rank | Int64 | Yes | — | Games played rank. |
w_rank | Int64 | Yes | — | Wins rank. |
l_rank | Int64 | Yes | — | Losses rank. |
w_pct_rank | Int64 | Yes | — | Win percentage rank. |
min_rank | Int64 | Yes | — | Minutes played rank. |
ftm_rank | Int64 | Yes | — | Free throws made rank. |
fta_rank | Int64 | Yes | — | Free throws attempted rank. |
ft_pct_rank | Int64 | Yes | — | Free throw percentage rank. |
oreb_rank | Int64 | Yes | — | Offensive rebounds rank. |
dreb_rank | Int64 | Yes | — | Defensive rebounds rank. |
reb_rank | Int64 | Yes | — | Rebounds rank. |
ast_rank | Int64 | Yes | — | Assists rank. |
tov_rank | Int64 | Yes | — | Turnovers rank. |
stl_rank | Int64 | Yes | — | Steals rank. |
blk_rank | Int64 | Yes | — | Blocks rank. |
pf_rank | Int64 | Yes | — | Personal fouls rank. |
pfd_rank | Int64 | Yes | — | Personal fouls drawn rank. |
pts_rank | Int64 | Yes | — | Points rank. |
plus_minus_rank | Int64 | Yes | — | Plus-minus rank. |
nba_fantasy_pts_rank | Int64 | Yes | — | NBA fantasy points rank. |
dd2_rank | Int64 | Yes | — | Double-doubles rank. |
td3_rank | Int64 | Yes | — | Triple-doubles rank. |
fgm | Float64 | Yes | — | Field goals made. |
fga | Float64 | Yes | — | Field goals attempted. |
fg_pct | Float64 | Yes | — | Field goal percentage. |
fg3m | Float64 | Yes | — | Three-pointers made. |
fg3a | Float64 | Yes | — | Three-pointers attempted. |
fg3_pct | Float64 | Yes | — | Three-point percentage. |
blka | Float64 | Yes | — | Blocked attempts. |
gp | Int64 | Yes | — | Games played. |
w | Int64 | Yes | — | Wins. |
l | Int64 | Yes | — | Losses. |
w_pct | Float64 | Yes | — | Win percentage. |
min | Float64 | Yes | — | Minutes played. |
ftm | Float64 | Yes | — | Free throws made. |
fta | Float64 | Yes | — | Free throws attempted. |
ft_pct | Float64 | Yes | — | Free throw percentage. |
oreb | Float64 | Yes | — | Offensive rebounds. |
dreb | Float64 | Yes | — | Defensive rebounds. |
reb | Float64 | Yes | — | Total rebounds. |
ast | Float64 | Yes | — | Assists. |
tov | Float64 | Yes | — | Turnovers. |
stl | Float64 | Yes | — | Steals. |
blk | Float64 | Yes | — | Blocks. |
pf | Float64 | Yes | — | Personal fouls. |
pfd | Float64 | Yes | — | Personal fouls drawn. |
pts | Float64 | Yes | — | Points scored. |
plus_minus | Float64 | Yes | — | Plus-minus differential. |
nba_fantasy_pts | Float64 | Yes | — | NBA fantasy points. |
dd2 | Float64 | Yes | — | Double-doubles. |
td3 | Float64 | Yes | — | Triple-doubles. |
group_value_order | Int64 | Yes | — | Sort order for grouped dashboard rows. |
group_value_2 | String | Yes | — | Secondary grouping value returned by the endpoint. |
group_set | String | Yes | — | Grouping set returned by the player dashboard endpoint. |
group_value | String | Yes | — | Grouping value returned by the player dashboard endpoint. |
player_id | Int64 | No | gt=0 | Queried player identifier. |
season_year | String | No | — | Queried season year. |
season_type | String | No | — | Queried season type. |
staging_player_shoot_assisted_by
Class: StagingPlayerShootAssistedBySchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
cfid | Int64 | Yes | — | Context filter identifier returned by nba_api. |
cfparams | String | Yes | — | Serialized context filter parameters returned by nba_api. |
efg_pct_rank | Int64 | Yes | — | Effective field goal percentage rank. |
pct_ast_2pm_rank | Int64 | Yes | — | Assisted two-point make percentage rank. |
pct_uast_2pm_rank | Int64 | Yes | — | Unassisted two-point make percentage rank. |
pct_ast_3pm_rank | Int64 | Yes | — | Assisted three-point make percentage rank. |
pct_uast_3pm_rank | Int64 | Yes | — | Unassisted three-point make percentage rank. |
pct_ast_fgm_rank | Int64 | Yes | — | Assisted field goal make percentage rank. |
pct_uast_fgm_rank | Int64 | Yes | — | Unassisted field goal make percentage rank. |
fgm_rank | Int64 | Yes | — | Field goals made rank. |
fga_rank | Int64 | Yes | — | Field goals attempted rank. |
fg_pct_rank | Int64 | Yes | — | Field goal percentage rank. |
fg3m_rank | Int64 | Yes | — | Three-pointers made rank. |
fg3a_rank | Int64 | Yes | — | Three-pointers attempted rank. |
fg3_pct_rank | Int64 | Yes | — | Three-point percentage rank. |
blka_rank | Int64 | Yes | — | Blocked attempts rank. |
efg_pct | Float64 | Yes | — | Effective field goal percentage. |
pct_ast_2pm | Float64 | Yes | — | Share of made twos that were assisted. |
pct_uast_2pm | Float64 | Yes | — | Share of made twos that were unassisted. |
pct_ast_3pm | Float64 | Yes | — | Share of made threes that were assisted. |
pct_uast_3pm | Float64 | Yes | — | Share of made threes that were unassisted. |
pct_ast_fgm | Float64 | Yes | — | Share of made field goals that were assisted. |
pct_uast_fgm | Float64 | Yes | — | Share of made field goals that were unassisted. |
fgm | Float64 | Yes | — | Field goals made. |
fga | Float64 | Yes | — | Field goals attempted. |
fg_pct | Float64 | Yes | — | Field goal percentage. |
fg3m | Float64 | Yes | — | Three-pointers made. |
fg3a | Float64 | Yes | — | Three-pointers attempted. |
fg3_pct | Float64 | Yes | — | Three-point percentage. |
blka | Float64 | Yes | — | Blocked attempts. |
player_name | String | Yes | — | Player name returned by the assisted-by split. |
group_set | String | Yes | — | Grouping set returned by the player dashboard endpoint. |
player_id | Int64 | No | gt=0 | Queried player identifier. |
season_year | String | No | — | Queried season year. |
season_type | String | No | — | Queried season type. |
staging_player_shoot_type_summary
Class: StagingPlayerShootTypeSummarySchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
cfid | Int64 | Yes | — | Context filter identifier returned by nba_api. |
cfparams | String | Yes | — | Serialized context filter parameters returned by nba_api. |
efg_pct | Float64 | Yes | — | Effective field goal percentage. |
pct_ast_2pm | Float64 | Yes | — | Share of made twos that were assisted. |
pct_uast_2pm | Float64 | Yes | — | Share of made twos that were unassisted. |
pct_ast_3pm | Float64 | Yes | — | Share of made threes that were assisted. |
pct_uast_3pm | Float64 | Yes | — | Share of made threes that were unassisted. |
pct_ast_fgm | Float64 | Yes | — | Share of made field goals that were assisted. |
pct_uast_fgm | Float64 | Yes | — | Share of made field goals that were unassisted. |
fgm | Float64 | Yes | — | Field goals made. |
fga | Float64 | Yes | — | Field goals attempted. |
fg_pct | Float64 | Yes | — | Field goal percentage. |
fg3m | Float64 | Yes | — | Three-pointers made. |
fg3a | Float64 | Yes | — | Three-pointers attempted. |
fg3_pct | Float64 | Yes | — | Three-point percentage. |
blka | Float64 | Yes | — | Blocked attempts. |
group_set | String | Yes | — | Grouping set returned by the player dashboard endpoint. |
group_value | String | Yes | — | Grouping value returned by the player dashboard endpoint. |
player_id | Int64 | No | gt=0 | Queried player identifier. |
season_year | String | No | — | Queried season year. |
season_type | String | No | — | Queried season type. |
staging_schedule_league_v2
Class: StagingScheduleLeagueV2Schema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
game_date | String | No | — | Date of the game |
game_id | String | No | — | Unique game identifier |
game_code | String | Yes | — | Game code string |
game_status | Int64 | Yes | in=[1, 2, 3] | Game status code |
game_status_text | String | Yes | — | Game status display text |
game_sequence | Int64 | Yes | — | Game sequence number for the day |
game_date_est | String | Yes | — | Game date in Eastern time |
game_time_est | String | Yes | — | Game time in Eastern time |
game_date_time_est | String | Yes | — | Game date and time in Eastern time |
game_date_utc | String | Yes | — | Game date in UTC |
game_time_utc | String | Yes | — | Game time in UTC |
game_date_time_utc | String | Yes | — | Game date and time in UTC |
away_team_id | Int64 | Yes | FK→staging_team.team_id | Away team identifier |
away_team_name | String | Yes | — | Away team name |
away_team_city | String | Yes | — | Away team city |
away_team_tricode | String | Yes | — | Away team three-letter code |
away_team_slug | String | Yes | — | Away team URL slug |
away_team_wins | Int64 | Yes | — | Away team win count |
away_team_losses | Int64 | Yes | — | Away team loss count |
away_team_score | Int64 | Yes | — | Away team score |
home_team_id | Int64 | Yes | FK→staging_team.team_id | Home team identifier |
home_team_name | String | Yes | — | Home team name |
home_team_city | String | Yes | — | Home team city |
home_team_tricode | String | Yes | — | Home team three-letter code |
home_team_slug | String | Yes | — | Home team URL slug |
home_team_wins | Int64 | Yes | — | Home team win count |
home_team_losses | Int64 | Yes | — | Home team loss count |
home_team_score | Int64 | Yes | — | Home team score |
arena_name | String | Yes | — | Arena name |
arena_city | String | Yes | — | Arena city |
arena_state | String | Yes | — | Arena state |
postponed_status | String | Yes | — | Postponement status |
branch_link | String | Yes | — | Branch deep link URL |
game_subtype | String | Yes | — | Game subtype classification |
series_conference | String | Yes | — | Playoff series conference |
series_text | String | Yes | — | Playoff series status text |
if_necessary | String | Yes | — | If-necessary game indicator |
series_game_number | String | Yes | — | Game number in playoff series |
staging_scoreboard_v2
Class: StagingScoreboardV2Schema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
game_date_est | String | No | — | Game date in Eastern time |
game_sequence | Int64 | Yes | — | Game sequence number for the day |
game_id | String | No | — | Unique game identifier |
game_status_id | Int64 | Yes | in=[1, 2, 3] | Game status identifier |
game_status_text | String | Yes | — | Game status display text |
gamecode | String | Yes | — | Game code string |
home_team_id | Int64 | Yes | FK→staging_team.team_id | Home team identifier |
visitor_team_id | Int64 | Yes | FK→staging_team.team_id | Visitor team identifier |
season | String | Yes | — | Season year string |
live_period | Int64 | Yes | — | Current live period |
live_pc_time | String | Yes | — | Live game clock time |
natl_tv_broadcaster_abbreviation | String | Yes | — | National TV broadcaster abbreviation |
home_tv_broadcaster_abbreviation | String | Yes | — | Home TV broadcaster abbreviation |
away_tv_broadcaster_abbreviation | String | Yes | — | Away TV broadcaster abbreviation |
live_period_time_bcast | String | Yes | — | Live period time broadcast string |
arena_name | String | Yes | — | Arena name |
wh_status | Int64 | Yes | — | Wagering hub status flag |
staging_shot_chart_detail
Class: StagingShotChartDetailSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
grid_type | String | Yes | — | Shot chart grid type |
game_id | String | No | — | Unique game identifier |
game_event_id | Int64 | Yes | — | Event identifier within game |
player_id | Int64 | No | gt=0, FK→staging_player.person_id | Unique player identifier |
player_name | String | Yes | — | Player full name |
team_id | Int64 | Yes | FK→staging_team.team_id | Team identifier |
team_name | String | Yes | — | Team name |
period | Int64 | Yes | gt=0 | Game period number |
minutes_remaining | Int64 | Yes | — | Minutes remaining in period |
seconds_remaining | Int64 | Yes | — | Seconds remaining in period |
event_type | String | Yes | — | Shot event type (Made/Missed) |
action_type | String | Yes | — | Specific shot action type |
shot_type | String | Yes | — | Shot type (2PT/3PT Field Goal) |
shot_zone_basic | String | Yes | — | Basic shot zone category |
shot_zone_area | String | Yes | — | Shot zone area on court |
shot_zone_range | String | Yes | — | Shot distance range bucket |
shot_distance | Int64 | Yes | — | Shot distance in feet |
loc_x | Int64 | Yes | — | Shot X coordinate on court |
loc_y | Int64 | Yes | — | Shot Y coordinate on court |
shot_attempted_flag | Int64 | Yes | in=[0, 1] | Flag indicating shot was attempted |
shot_made_flag | Int64 | Yes | in=[0, 1] | Flag indicating shot was made |
game_date | String | Yes | — | Date of the game |
htm | String | Yes | — | Home team abbreviation |
vtm | String | Yes | — | Visitor team abbreviation |
staging_synergy_play_types
Class: StagingSynergyPlayTypesSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
season_id | String | No | — | NBA season identifier |
team_id | Int64 | Yes | gt=0, FK→staging_team.team_id | Team identifier |
team_abbreviation | String | Yes | — | Team abbreviation code |
team_name | String | Yes | — | Team name |
player_id | Int64 | Yes | gt=0, FK→staging_player.person_id | Unique player identifier |
player_name | String | Yes | — | Player full name |
play_type | String | No | — | Synergy play type classification |
type_grouping | String | No | — | Offensive or defensive grouping |
percentile | Float64 | Yes | — | Percentile rank for play type |
gp | Int64 | Yes | — | Games played |
poss_pct | Float64 | Yes | — | Percentage of possessions |
ppp | Float64 | Yes | — | Points per possession |
fg_pct | Float64 | Yes | — | Field goal percentage |
ft_pct_adjust | Float64 | Yes | — | Free throw percentage adjusted |
to_pct | Float64 | Yes | — | Turnover percentage |
sf_pct | Float64 | Yes | — | Shooting foul percentage |
plusone_pct | Float64 | Yes | — | And-one conversion percentage |
score_pct | Float64 | Yes | — | Scoring percentage |
efg_pct | Float64 | Yes | — | Effective field goal percentage |
poss | Int64 | Yes | — | Total possessions |
pts | Float64 | Yes | — | Total points scored |
fgm | Int64 | Yes | — | Field goals made |
fga | Int64 | Yes | — | Field goals attempted |
fgmx | Int64 | Yes | — | Field goals missed |
staging_team_details
Class: StagingTeamDetailsSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
team_id | Int64 | No | gt=0 | Unique team identifier |
abbreviation | String | No | — | Team abbreviation code |
nickname | String | No | — | Team nickname |
yearfounded | Int64 | Yes | gt=1900 | Year the team was founded |
city | String | Yes | — | Team city name |
arena | String | Yes | — | Home arena name |
arenacapacity | Int64 | Yes | gt=0 | Arena seating capacity |
owner | String | Yes | — | Team owner name |
generalmanager | String | Yes | — | General manager name |
headcoach | String | Yes | — | Head coach name |
dleagueaffiliation | String | Yes | — | G-League affiliate team name |
staging_team_game_log
Class: StagingTeamGameLogSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
season_id | String | No | — | Season identifier |
team_id | Int64 | No | gt=0, FK→staging_team.team_id | Unique team identifier |
team_abbreviation | String | No | — | Team abbreviation code |
team_name | String | No | — | Team name |
game_id | String | No | — | Unique game identifier |
game_date | String | No | — | Date of the game |
matchup | String | No | — | Matchup string (e.g. LAL vs. BOS) |
wl | String | Yes | in=['W', 'L'] | Win or loss indicator |
w | Int64 | Yes | — | Wins |
l | Int64 | Yes | — | Losses |
w_pct | Float64 | Yes | — | Win percentage |
min | Float64 | Yes | — | Minutes played |
fgm | Float64 | Yes | — | Field goals made |
fga | Float64 | Yes | — | Field goals attempted |
fg_pct | Float64 | Yes | — | Field goal percentage |
fg3m | Float64 | Yes | — | Three-point field goals made |
fg3a | Float64 | Yes | — | Three-point field goals attempted |
fg3_pct | Float64 | Yes | — | Three-point field goal percentage |
ftm | Float64 | Yes | — | Free throws made |
fta | Float64 | Yes | — | Free throws attempted |
ft_pct | Float64 | Yes | — | Free throw percentage |
oreb | Float64 | Yes | — | Offensive rebounds |
dreb | Float64 | Yes | — | Defensive rebounds |
reb | Float64 | Yes | — | Total rebounds |
ast | Float64 | Yes | — | Assists |
stl | Float64 | Yes | — | Steals |
blk | Float64 | Yes | — | Blocks |
tov | Float64 | Yes | — | Turnovers |
pf | Float64 | Yes | — | Personal fouls |
pts | Float64 | Yes | — | Points scored |
plus_minus | Float64 | Yes | — | Plus-minus differential |
video_available | Int64 | Yes | — | Video availability flag |
staging_team_info_common
Class: StagingTeamInfoCommonSchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
team_id | Int64 | No | gt=0 | Unique team identifier |
season_year | String | Yes | — | Season year string |
team_city | String | Yes | — | Team city name |
team_name | String | No | — | Team name |
team_abbreviation | String | No | — | Team abbreviation code |
team_conference | String | Yes | — | Conference name |
team_division | String | Yes | — | Division name |
team_code | String | Yes | — | Team code slug |
team_slug | String | Yes | — | URL-friendly team slug |
w | Int64 | Yes | — | Wins |
l | Int64 | Yes | — | Losses |
pct | Float64 | Yes | — | Win percentage |
conf_rank | Int64 | Yes | gt=0 | Conference ranking |
div_rank | Int64 | Yes | gt=0 | Division ranking |
min_year | String | Yes | — | First year of team activity |
max_year | String | Yes | — | Last year of team activity |
staging_win_probability
Class: StagingWinProbabilitySchema
Coerce: True | Strict: False
| Column | Type | Nullable | Constraints | Description |
|---|---|---|---|---|
game_id | String | No | — | Unique game identifier |
event_num | Int64 | No | — | Event sequence number |
home_pct | Float64 | Yes | — | Home team win probability |
visitor_pct | Float64 | Yes | — | Visitor team win probability |
home_pts | Int64 | Yes | — | Home team points |
visitor_pts | Int64 | Yes | — | Visitor team points |
home_score_margin | Int64 | Yes | — | Home team score margin |
period | Int64 | Yes | gt=0 | Game period number |
seconds_remaining | Float64 | Yes | — | Seconds remaining in period |
home_team_id | Int64 | Yes | FK→staging_team.team_id | Home team identifier |
home_team_abb | String | Yes | — | Home team abbreviation code |
visitor_team_id | Int64 | Yes | FK→staging_team.team_id | Visitor team identifier |
visitor_team_abb | String | Yes | — | Visitor team abbreviation code |
description | String | Yes | — | Text description of the play |
location | String | Yes | — | Home or away location indicator |
pctimestring | String | Yes | — | Period clock time string |
is_score_change | Int64 | Yes | in=[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.
Translate cleaned keys into relationship lanes
Use the join playbook when staging identifiers are clear and the next step is SQL shape.
Trace which facts and dimensions inherit this stage
Best next stop when a staging change might ripple through multiple downstream outputs.
Decode warehouse-friendly field names
Use the field guide when cleanup improved the name but not the full semantic picture.
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.
Relationships
Turn normalized keys into concrete join lanes across player, team, game, and event analysis.
Table Lineage
Trace which staging tables feed the downstream dimensions, facts, and aggregates you care about.
Field Reference
Use the naming guide when staging cleanup introduced warehouse-style field conventions.