Stat Legend
Data Dictionary — Staging
Field-level documentation for all staging schema tables
Generated field inventory
Read staging as the translation layer
This inventory shows where raw payloads start sounding like a warehouse. Use it to verify normalized names, key cleanup, and source carry-through before you reason about downstream joins.
confirm how raw fields were cleaned up for staging and load
staging names, foreign keys, and cleaned types usually get clearer here
regenerate from schema metadata instead of hand-editing
Compare staging names to the raw counterpart
This is the right page when the upstream field exists, but you need the normalized warehouse-facing name.
Watch the cleaned keys and types
Staging is where foreign-key hints, renamed identifiers, and typed columns start becoming useful for SQL.
Follow the possession downstream
Once the staging shape is clear, switch to relationships or lineage to understand impact and joins.
Quick scan
Jump by cleaned staging family
Scan the normalized table groups first so you do not have to read the full staging inventory top to bottom.
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.
Data Dictionary — Staging
staging_arena_info
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
game_id | String | No | Unique game identifier | BoxScoreSummaryV3.ArenaInfo.gameId |
arena_id | Int64 | Yes | Arena identifier | BoxScoreSummaryV3.ArenaInfo.arenaId |
arena_name | String | Yes | Arena name | BoxScoreSummaryV3.ArenaInfo.arenaName |
arena_city | String | Yes | Arena city | BoxScoreSummaryV3.ArenaInfo.arenaCity |
arena_state | String | Yes | Arena state or province | BoxScoreSummaryV3.ArenaInfo.arenaState |
arena_country | String | Yes | Arena country | BoxScoreSummaryV3.ArenaInfo.arenaCountry |
arena_timezone | String | Yes | Arena timezone | BoxScoreSummaryV3.ArenaInfo.arenaTimezone |
staging_box_score_advanced_player
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
game_id | String | No | Unique game identifier | BoxScoreAdvancedV3.PlayerStats.GAME_ID |
team_id | Int64 | No | Team identifier (FK → staging_team.team_id) | BoxScoreAdvancedV3.PlayerStats.TEAM_ID |
player_id | Int64 | No | Unique player identifier (FK → staging_player.person_id) | BoxScoreAdvancedV3.PlayerStats.PLAYER_ID |
player_name | String | Yes | Player full name | BoxScoreAdvancedV3.PlayerStats.PLAYER_NAME |
min | String | Yes | Minutes played as string | BoxScoreAdvancedV3.PlayerStats.MIN |
e_off_rating | Float64 | Yes | Estimated offensive rating | BoxScoreAdvancedV3.PlayerStats.E_OFF_RATING |
off_rating | Float64 | Yes | Offensive rating | BoxScoreAdvancedV3.PlayerStats.OFF_RATING |
e_def_rating | Float64 | Yes | Estimated defensive rating | BoxScoreAdvancedV3.PlayerStats.E_DEF_RATING |
def_rating | Float64 | Yes | Defensive rating | BoxScoreAdvancedV3.PlayerStats.DEF_RATING |
e_net_rating | Float64 | Yes | Estimated net rating | BoxScoreAdvancedV3.PlayerStats.E_NET_RATING |
net_rating | Float64 | Yes | Net rating | BoxScoreAdvancedV3.PlayerStats.NET_RATING |
ast_pct | Float64 | Yes | Assist percentage | BoxScoreAdvancedV3.PlayerStats.AST_PCT |
ast_tov | Float64 | Yes | Assist to turnover ratio | BoxScoreAdvancedV3.PlayerStats.AST_TOV |
ast_ratio | Float64 | Yes | Assist ratio | BoxScoreAdvancedV3.PlayerStats.AST_RATIO |
oreb_pct | Float64 | Yes | Offensive rebound percentage | BoxScoreAdvancedV3.PlayerStats.OREB_PCT |
dreb_pct | Float64 | Yes | Defensive rebound percentage | BoxScoreAdvancedV3.PlayerStats.DREB_PCT |
reb_pct | Float64 | Yes | Total rebound percentage | BoxScoreAdvancedV3.PlayerStats.REB_PCT |
tov_pct | Float64 | Yes | Turnover percentage | BoxScoreAdvancedV3.PlayerStats.TOV_PCT |
efg_pct | Float64 | Yes | Effective field goal percentage | BoxScoreAdvancedV3.PlayerStats.EFG_PCT |
ts_pct | Float64 | Yes | True shooting percentage | BoxScoreAdvancedV3.PlayerStats.TS_PCT |
usg_pct | Float64 | Yes | Usage percentage | BoxScoreAdvancedV3.PlayerStats.USG_PCT |
e_usg_pct | Float64 | Yes | Estimated usage percentage | BoxScoreAdvancedV3.PlayerStats.E_USG_PCT |
e_pace | Float64 | Yes | Estimated pace | BoxScoreAdvancedV3.PlayerStats.E_PACE |
pace | Float64 | Yes | Pace factor | BoxScoreAdvancedV3.PlayerStats.PACE |
pace_per40 | Float64 | Yes | Pace per 40 minutes | BoxScoreAdvancedV3.PlayerStats.PACE_PER40 |
poss | Float64 | Yes | Possessions | BoxScoreAdvancedV3.PlayerStats.POSS |
pie | Float64 | Yes | Player impact estimate | BoxScoreAdvancedV3.PlayerStats.PIE |
staging_box_score_defensive_player
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
game_id | String | No | Unique game identifier | BoxScoreDefensiveV2.PlayerStats.GAME_ID |
team_id | Int64 | No | Team identifier (FK → staging_team.team_id) | BoxScoreDefensiveV2.PlayerStats.TEAM_ID |
player_id | Int64 | No | Unique player identifier (FK → staging_player.person_id) | BoxScoreDefensiveV2.PlayerStats.PLAYER_ID |
player_name | String | Yes | Player full name | BoxScoreDefensiveV2.PlayerStats.PLAYER_NAME |
min | String | Yes | Minutes played as string | BoxScoreDefensiveV2.PlayerStats.MIN |
matchup_min | Float64 | Yes | Minutes in matchup defense | BoxScoreDefensiveV2.PlayerStats.MATCHUP_MIN |
partial_poss | Float64 | Yes | Partial possessions defended | BoxScoreDefensiveV2.PlayerStats.PARTIAL_POSS |
switches_on | Float64 | Yes | Number of defensive switches | BoxScoreDefensiveV2.PlayerStats.SWITCHES_ON |
player_pts | Float64 | Yes | Points allowed on defense | BoxScoreDefensiveV2.PlayerStats.PLAYER_PTS |
def_fgm | Float64 | Yes | Defended field goals made | BoxScoreDefensiveV2.PlayerStats.DEF_FGM |
def_fga | Float64 | Yes | Defended field goals attempted | BoxScoreDefensiveV2.PlayerStats.DEF_FGA |
def_fg_pct | Float64 | Yes | Defended field goal percentage | BoxScoreDefensiveV2.PlayerStats.DEF_FG_PCT |
staging_box_score_four_factors_player
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
game_id | String | No | Unique game identifier | BoxScoreFourFactorsV3.PlayerStats.GAME_ID |
team_id | Int64 | No | Team identifier (FK → staging_team.team_id) | BoxScoreFourFactorsV3.PlayerStats.TEAM_ID |
player_id | Int64 | No | Unique player identifier (FK → staging_player.person_id) | BoxScoreFourFactorsV3.PlayerStats.PLAYER_ID |
player_name | String | Yes | Player full name | BoxScoreFourFactorsV3.PlayerStats.PLAYER_NAME |
min | String | Yes | Minutes played as string | BoxScoreFourFactorsV3.PlayerStats.MIN |
effective_field_goal_percentage | Float64 | Yes | Effective field goal percentage | BoxScoreFourFactorsV3.PlayerStats.EFG_PCT |
free_throw_attempt_rate | Float64 | Yes | Free throw attempt rate | BoxScoreFourFactorsV3.PlayerStats.FTA_RATE |
team_turnover_percentage | Float64 | Yes | Team turnover percentage | BoxScoreFourFactorsV3.PlayerStats.TM_TOV_PCT |
offensive_rebound_percentage | Float64 | Yes | Offensive rebound percentage | BoxScoreFourFactorsV3.PlayerStats.OREB_PCT |
opp_effective_field_goal_percentage | Float64 | Yes | Opponent effective field goal percentage | BoxScoreFourFactorsV3.PlayerStats.OPP_EFG_PCT |
opp_free_throw_attempt_rate | Float64 | Yes | Opponent free throw attempt rate | BoxScoreFourFactorsV3.PlayerStats.OPP_FTA_RATE |
opp_team_turnover_percentage | Float64 | Yes | Opponent team turnover percentage | BoxScoreFourFactorsV3.PlayerStats.OPP_TOV_PCT |
opp_offensive_rebound_percentage | Float64 | Yes | Opponent offensive rebound percentage | BoxScoreFourFactorsV3.PlayerStats.OPP_OREB_PCT |
staging_box_score_four_factors_team
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
game_id | String | No | Unique game identifier | BoxScoreFourFactorsV3.TeamStats.GAME_ID |
team_id | Int64 | No | Team identifier (FK → staging_team.team_id) | BoxScoreFourFactorsV3.TeamStats.TEAM_ID |
team_name | String | Yes | Team name | BoxScoreFourFactorsV3.TeamStats.TEAM_NAME |
team_abbreviation | String | Yes | Team abbreviation code | BoxScoreFourFactorsV3.TeamStats.TEAM_ABBREVIATION |
effective_field_goal_percentage | Float64 | Yes | Effective field goal percentage | BoxScoreFourFactorsV3.TeamStats.EFG_PCT |
free_throw_attempt_rate | Float64 | Yes | Free throw attempt rate | BoxScoreFourFactorsV3.TeamStats.FTA_RATE |
team_turnover_percentage | Float64 | Yes | Team turnover percentage | BoxScoreFourFactorsV3.TeamStats.TM_TOV_PCT |
offensive_rebound_percentage | Float64 | Yes | Offensive rebound percentage | BoxScoreFourFactorsV3.TeamStats.OREB_PCT |
opp_effective_field_goal_percentage | Float64 | Yes | Opponent effective field goal percentage | BoxScoreFourFactorsV3.TeamStats.OPP_EFG_PCT |
opp_free_throw_attempt_rate | Float64 | Yes | Opponent free throw attempt rate | BoxScoreFourFactorsV3.TeamStats.OPP_FTA_RATE |
opp_team_turnover_percentage | Float64 | Yes | Opponent team turnover percentage | BoxScoreFourFactorsV3.TeamStats.OPP_TOV_PCT |
opp_offensive_rebound_percentage | Float64 | Yes | Opponent offensive rebound percentage | BoxScoreFourFactorsV3.TeamStats.OPP_OREB_PCT |
staging_box_score_hustle_player
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
game_id | String | No | Unique game identifier | BoxScoreHustleV2.PlayerStats.GAME_ID |
team_id | Int64 | No | Team identifier (FK → staging_team.team_id) | BoxScoreHustleV2.PlayerStats.TEAM_ID |
player_id | Int64 | No | Unique player identifier (FK → staging_player.person_id) | BoxScoreHustleV2.PlayerStats.PLAYER_ID |
player_name | String | Yes | Player full name | BoxScoreHustleV2.PlayerStats.PLAYER_NAME |
min | String | Yes | Minutes played as string | BoxScoreHustleV2.PlayerStats.MIN |
contested_shots | Float64 | Yes | Contested shots | BoxScoreHustleV2.PlayerStats.CONTESTED_SHOTS |
contested_shots_2pt | Float64 | Yes | Contested two-point shots | BoxScoreHustleV2.PlayerStats.CONTESTED_SHOTS_2PT |
contested_shots_3pt | Float64 | Yes | Contested three-point shots | BoxScoreHustleV2.PlayerStats.CONTESTED_SHOTS_3PT |
deflections | Float64 | Yes | Deflections | BoxScoreHustleV2.PlayerStats.DEFLECTIONS |
charges_drawn | Float64 | Yes | Charges drawn | BoxScoreHustleV2.PlayerStats.CHARGES_DRAWN |
screen_assists | Float64 | Yes | Screen assists | BoxScoreHustleV2.PlayerStats.SCREEN_ASSISTS |
screen_ast_pts | Float64 | Yes | Points from screen assists | BoxScoreHustleV2.PlayerStats.SCREEN_AST_PTS |
loose_balls_recovered | Float64 | Yes | Loose balls recovered | BoxScoreHustleV2.PlayerStats.LOOSE_BALLS_RECOVERED |
box_outs | Float64 | Yes | Box outs | BoxScoreHustleV2.PlayerStats.BOX_OUTS |
staging_box_score_matchups
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
game_id | String | No | Unique game identifier (FK → staging_game_log.game_id) | BoxScoreMatchupsV3.PlayerStats.GAME_ID |
off_team_id | Int64 | Yes | Offensive team identifier (FK → staging_team.team_id) | BoxScoreMatchupsV3.PlayerStats.OFF_TEAM_ID |
off_team_abbreviation | String | Yes | Offensive team abbreviation | BoxScoreMatchupsV3.PlayerStats.OFF_TEAM_ABBREVIATION |
def_team_id | Int64 | Yes | Defensive team identifier (FK → staging_team.team_id) | BoxScoreMatchupsV3.PlayerStats.DEF_TEAM_ID |
def_team_abbreviation | String | Yes | Defensive team abbreviation | BoxScoreMatchupsV3.PlayerStats.DEF_TEAM_ABBREVIATION |
off_player_id | Int64 | Yes | Offensive player identifier (FK → staging_player.person_id) | BoxScoreMatchupsV3.PlayerStats.OFF_PLAYER_ID |
off_player_name | String | Yes | Offensive player name | BoxScoreMatchupsV3.PlayerStats.OFF_PLAYER_NAME |
def_player_id | Int64 | Yes | Defensive player identifier (FK → staging_player.person_id) | BoxScoreMatchupsV3.PlayerStats.DEF_PLAYER_ID |
def_player_name | String | Yes | Defensive player name | BoxScoreMatchupsV3.PlayerStats.DEF_PLAYER_NAME |
matchup_min | Float64 | Yes | Minutes in matchup | BoxScoreMatchupsV3.PlayerStats.MATCHUP_MIN |
partial_poss | Float64 | Yes | Partial possessions in matchup | BoxScoreMatchupsV3.PlayerStats.PARTIAL_POSS |
player_pts | Float64 | Yes | Player points in matchup | BoxScoreMatchupsV3.PlayerStats.PLAYER_PTS |
team_pts | Float64 | Yes | Team points in matchup | BoxScoreMatchupsV3.PlayerStats.TEAM_PTS |
matchup_ast | Float64 | Yes | Assists in matchup | BoxScoreMatchupsV3.PlayerStats.MATCHUP_AST |
matchup_tov | Float64 | Yes | Turnovers in matchup | BoxScoreMatchupsV3.PlayerStats.MATCHUP_TOV |
matchup_blk | Float64 | Yes | Blocks in matchup | BoxScoreMatchupsV3.PlayerStats.MATCHUP_BLK |
matchup_fgm | Float64 | Yes | Field goals made in matchup | BoxScoreMatchupsV3.PlayerStats.MATCHUP_FGM |
matchup_fga | Float64 | Yes | Field goals attempted | BoxScoreMatchupsV3.PlayerStats.MATCHUP_FGA |
matchup_fg_pct | Float64 | Yes | Field goal pct in matchup | BoxScoreMatchupsV3.PlayerStats.MATCHUP_FG_PCT |
matchup_fg3m | Float64 | Yes | Three-pointers made | BoxScoreMatchupsV3.PlayerStats.MATCHUP_FG3M |
matchup_fg3a | Float64 | Yes | Three-pointers attempted | BoxScoreMatchupsV3.PlayerStats.MATCHUP_FG3A |
matchup_fg3_pct | Float64 | Yes | Three-point pct in matchup | BoxScoreMatchupsV3.PlayerStats.MATCHUP_FG3_PCT |
help_blk | Float64 | Yes | Help blocks in matchup | BoxScoreMatchupsV3.PlayerStats.HELP_BLK |
help_fgm | Float64 | Yes | Help field goals made | BoxScoreMatchupsV3.PlayerStats.HELP_FGM |
help_fga | Float64 | Yes | Help field goals attempted | BoxScoreMatchupsV3.PlayerStats.HELP_FGA |
help_fg_pct | Float64 | Yes | Help field goal percentage | BoxScoreMatchupsV3.PlayerStats.HELP_FG_PCT |
matchup_ftm | Float64 | Yes | Free throws made in matchup | BoxScoreMatchupsV3.PlayerStats.MATCHUP_FTM |
matchup_fta | Float64 | Yes | Free throws attempted | BoxScoreMatchupsV3.PlayerStats.MATCHUP_FTA |
switches_on | Float64 | Yes | Switches onto player | BoxScoreMatchupsV3.PlayerStats.SWITCHES_ON |
staging_box_score_player_track
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
game_id | String | No | Unique game identifier | BoxScorePlayerTrackV3.PlayerStats.GAME_ID |
team_id | Int64 | No | Team identifier (FK → staging_team.team_id) | BoxScorePlayerTrackV3.PlayerStats.TEAM_ID |
player_id | Int64 | No | Unique player identifier (FK → staging_player.person_id) | BoxScorePlayerTrackV3.PlayerStats.PLAYER_ID |
player_name | String | Yes | Player full name | BoxScorePlayerTrackV3.PlayerStats.PLAYER_NAME |
min | String | Yes | Minutes played as string | BoxScorePlayerTrackV3.PlayerStats.MIN |
spd | Float64 | Yes | Average speed in mph | BoxScorePlayerTrackV3.PlayerStats.SPD |
dist | Float64 | Yes | Distance covered in miles | BoxScorePlayerTrackV3.PlayerStats.DIST |
orbc | Float64 | Yes | Offensive rebound chances | BoxScorePlayerTrackV3.PlayerStats.ORBC |
drbc | Float64 | Yes | Defensive rebound chances | BoxScorePlayerTrackV3.PlayerStats.DRBC |
rbc | Float64 | Yes | Total rebound chances | BoxScorePlayerTrackV3.PlayerStats.RBC |
tchs | Float64 | Yes | Touches | BoxScorePlayerTrackV3.PlayerStats.TCHS |
sast | Float64 | Yes | Secondary assists | BoxScorePlayerTrackV3.PlayerStats.SAST |
ftast | Float64 | Yes | Free throw assists | BoxScorePlayerTrackV3.PlayerStats.FTAST |
pass | Float64 | Yes | Passes made | BoxScorePlayerTrackV3.PlayerStats.PASS |
cfgm | Float64 | Yes | Contested field goals made | BoxScorePlayerTrackV3.PlayerStats.CFGM |
cfga | Float64 | Yes | Contested field goals attempted | BoxScorePlayerTrackV3.PlayerStats.CFGA |
cfg_pct | Float64 | Yes | Contested field goal percentage | BoxScorePlayerTrackV3.PlayerStats.CFG_PCT |
ufgm | Float64 | Yes | Uncontested field goals made | BoxScorePlayerTrackV3.PlayerStats.UFGM |
ufga | Float64 | Yes | Uncontested field goals attempted | BoxScorePlayerTrackV3.PlayerStats.UFGA |
ufg_pct | Float64 | Yes | Uncontested field goal percentage | BoxScorePlayerTrackV3.PlayerStats.UFG_PCT |
dfgm | Float64 | Yes | Defended field goals made | BoxScorePlayerTrackV3.PlayerStats.DFGM |
dfga | Float64 | Yes | Defended field goals attempted | BoxScorePlayerTrackV3.PlayerStats.DFGA |
dfg_pct | Float64 | Yes | Defended field goal percentage | BoxScorePlayerTrackV3.PlayerStats.DFG_PCT |
staging_box_score_traditional_player
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
game_id | String | No | Unique game identifier | BoxScoreTraditionalV3.PlayerStats.GAME_ID |
team_id | Int64 | No | Team identifier (FK → staging_team.team_id) | BoxScoreTraditionalV3.PlayerStats.TEAM_ID |
team_abbreviation | String | Yes | Team abbreviation code | BoxScoreTraditionalV3.PlayerStats.TEAM_ABBREVIATION |
team_city | String | Yes | Team city name | BoxScoreTraditionalV3.PlayerStats.TEAM_CITY |
player_id | Int64 | No | Unique player identifier (FK → staging_player.person_id) | BoxScoreTraditionalV3.PlayerStats.PLAYER_ID |
player_name | String | Yes | Player full name | BoxScoreTraditionalV3.PlayerStats.PLAYER_NAME |
nickname | String | Yes | Player nickname | BoxScoreTraditionalV3.PlayerStats.NICKNAME |
start_position | String | Yes | Starting position (F/C/G) | BoxScoreTraditionalV3.PlayerStats.START_POSITION |
comment | String | Yes | Player status comment | BoxScoreTraditionalV3.PlayerStats.COMMENT |
min | String | Yes | Minutes played as string | BoxScoreTraditionalV3.PlayerStats.MIN |
fgm | Float64 | Yes | Field goals made | BoxScoreTraditionalV3.PlayerStats.FGM |
fga | Float64 | Yes | Field goals attempted | BoxScoreTraditionalV3.PlayerStats.FGA |
fg_pct | Float64 | Yes | Field goal percentage | BoxScoreTraditionalV3.PlayerStats.FG_PCT |
fg3m | Float64 | Yes | Three-point field goals made | BoxScoreTraditionalV3.PlayerStats.FG3M |
fg3a | Float64 | Yes | Three-point field goals attempted | BoxScoreTraditionalV3.PlayerStats.FG3A |
fg3_pct | Float64 | Yes | Three-point field goal percentage | BoxScoreTraditionalV3.PlayerStats.FG3_PCT |
ftm | Float64 | Yes | Free throws made | BoxScoreTraditionalV3.PlayerStats.FTM |
fta | Float64 | Yes | Free throws attempted | BoxScoreTraditionalV3.PlayerStats.FTA |
ft_pct | Float64 | Yes | Free throw percentage | BoxScoreTraditionalV3.PlayerStats.FT_PCT |
oreb | Float64 | Yes | Offensive rebounds | BoxScoreTraditionalV3.PlayerStats.OREB |
dreb | Float64 | Yes | Defensive rebounds | BoxScoreTraditionalV3.PlayerStats.DREB |
reb | Float64 | Yes | Total rebounds | BoxScoreTraditionalV3.PlayerStats.REB |
ast | Float64 | Yes | Assists | BoxScoreTraditionalV3.PlayerStats.AST |
stl | Float64 | Yes | Steals | BoxScoreTraditionalV3.PlayerStats.STL |
blk | Float64 | Yes | Blocks | BoxScoreTraditionalV3.PlayerStats.BLK |
tov | Float64 | Yes | Turnovers | BoxScoreTraditionalV3.PlayerStats.TOV |
pf | Float64 | Yes | Personal fouls | BoxScoreTraditionalV3.PlayerStats.PF |
pts | Float64 | Yes | Points scored | BoxScoreTraditionalV3.PlayerStats.PTS |
plus_minus | Float64 | Yes | Plus-minus differential | BoxScoreTraditionalV3.PlayerStats.PLUS_MINUS |
staging_box_score_traditional_team
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
game_id | String | No | Unique game identifier | BoxScoreTraditionalV3.TeamStats.GAME_ID |
team_id | Int64 | No | Team identifier (FK → staging_team.team_id) | BoxScoreTraditionalV3.TeamStats.TEAM_ID |
team_name | String | Yes | Team name | BoxScoreTraditionalV3.TeamStats.TEAM_NAME |
team_abbreviation | String | Yes | Team abbreviation code | BoxScoreTraditionalV3.TeamStats.TEAM_ABBREVIATION |
team_city | String | Yes | Team city name | BoxScoreTraditionalV3.TeamStats.TEAM_CITY |
min | Float64 | Yes | Total team minutes played | BoxScoreTraditionalV3.TeamStats.MIN |
fgm | Float64 | Yes | Field goals made | BoxScoreTraditionalV3.TeamStats.FGM |
fga | Float64 | Yes | Field goals attempted | BoxScoreTraditionalV3.TeamStats.FGA |
fg_pct | Float64 | Yes | Field goal percentage | BoxScoreTraditionalV3.TeamStats.FG_PCT |
fg3m | Float64 | Yes | Three-point field goals made | BoxScoreTraditionalV3.TeamStats.FG3M |
fg3a | Float64 | Yes | Three-point field goals attempted | BoxScoreTraditionalV3.TeamStats.FG3A |
fg3_pct | Float64 | Yes | Three-point field goal percentage | BoxScoreTraditionalV3.TeamStats.FG3_PCT |
ftm | Float64 | Yes | Free throws made | BoxScoreTraditionalV3.TeamStats.FTM |
fta | Float64 | Yes | Free throws attempted | BoxScoreTraditionalV3.TeamStats.FTA |
ft_pct | Float64 | Yes | Free throw percentage | BoxScoreTraditionalV3.TeamStats.FT_PCT |
oreb | Float64 | Yes | Offensive rebounds | BoxScoreTraditionalV3.TeamStats.OREB |
dreb | Float64 | Yes | Defensive rebounds | BoxScoreTraditionalV3.TeamStats.DREB |
reb | Float64 | Yes | Total rebounds | BoxScoreTraditionalV3.TeamStats.REB |
ast | Float64 | Yes | Assists | BoxScoreTraditionalV3.TeamStats.AST |
stl | Float64 | Yes | Steals | BoxScoreTraditionalV3.TeamStats.STL |
blk | Float64 | Yes | Blocks | BoxScoreTraditionalV3.TeamStats.BLK |
tov | Float64 | Yes | Turnovers | BoxScoreTraditionalV3.TeamStats.TOV |
pf | Float64 | Yes | Personal fouls | BoxScoreTraditionalV3.TeamStats.PF |
pts | Float64 | Yes | Points scored | BoxScoreTraditionalV3.TeamStats.PTS |
plus_minus | Float64 | Yes | Plus-minus differential | BoxScoreTraditionalV3.TeamStats.PLUS_MINUS |
staging_common_all_players
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
person_id | Int64 | No | Unique player identifier | CommonAllPlayers.CommonAllPlayers.PERSON_ID |
display_last_comma_first | String | Yes | Player name as Last, First | CommonAllPlayers.CommonAllPlayers.DISPLAY_LAST_COMMA_FIRST |
display_first_last | String | No | Player name as First Last | CommonAllPlayers.CommonAllPlayers.DISPLAY_FIRST_LAST |
roster_status | Int64 | Yes | Active roster flag (0 or 1) | CommonAllPlayers.CommonAllPlayers.ROSTER_STATUS |
from_year | String | Yes | First year in the league | CommonAllPlayers.CommonAllPlayers.FROM_YEAR |
to_year | String | Yes | Last year in the league | CommonAllPlayers.CommonAllPlayers.TO_YEAR |
playercode | String | Yes | Player code slug | CommonAllPlayers.CommonAllPlayers.PLAYERCODE |
team_id | Int64 | Yes | Team identifier (FK → staging_team.team_id) | CommonAllPlayers.CommonAllPlayers.TEAM_ID |
team_city | String | Yes | Team city name | CommonAllPlayers.CommonAllPlayers.TEAM_CITY |
team_name | String | Yes | Team name | CommonAllPlayers.CommonAllPlayers.TEAM_NAME |
team_abbreviation | String | Yes | Team abbreviation code | CommonAllPlayers.CommonAllPlayers.TEAM_ABBREVIATION |
team_code | String | Yes | Team code slug | CommonAllPlayers.CommonAllPlayers.TEAM_CODE |
games_played_flag | String | Yes | Flag indicating games played | CommonAllPlayers.CommonAllPlayers.GAMES_PLAYED_FLAG |
staging_common_team_years
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
league_id | String | No | League identifier | CommonTeamYears.TeamYears.LEAGUE_ID |
team_id | Int64 | No | Unique team identifier | CommonTeamYears.TeamYears.TEAM_ID |
min_year | String | Yes | First year of team activity | CommonTeamYears.TeamYears.MIN_YEAR |
max_year | String | Yes | Last year of team activity | CommonTeamYears.TeamYears.MAX_YEAR |
abbreviation | String | No | Team abbreviation code | CommonTeamYears.TeamYears.ABBREVIATION |
staging_draft_combine_stats
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
season | String | No | Combine season year | DraftCombineStats.DraftCombineStats.SEASON |
player_id | Int64 | No | Unique player identifier (FK → staging_player.person_id) | DraftCombineStats.DraftCombineStats.PLAYER_ID |
first_name | String | Yes | Player first name | DraftCombineStats.DraftCombineStats.FIRST_NAME |
last_name | String | Yes | Player last name | DraftCombineStats.DraftCombineStats.LAST_NAME |
player_name | String | Yes | Player full name | DraftCombineStats.DraftCombineStats.PLAYER_NAME |
position | String | Yes | Player position | DraftCombineStats.DraftCombineStats.POSITION |
height_wo_shoes | Float64 | Yes | Height without shoes in inches | DraftCombineStats.DraftCombineStats.HEIGHT_WO_SHOES |
height_wo_shoes_ft_in | String | Yes | Height without shoes in feet-inches | DraftCombineStats.DraftCombineStats.HEIGHT_WO_SHOES_FT_IN |
height_w_shoes | Float64 | Yes | Height with shoes in inches | DraftCombineStats.DraftCombineStats.HEIGHT_W_SHOES |
height_w_shoes_ft_in | String | Yes | Height with shoes in feet-inches | DraftCombineStats.DraftCombineStats.HEIGHT_W_SHOES_FT_IN |
weight | Float64 | Yes | Player weight in pounds | DraftCombineStats.DraftCombineStats.WEIGHT |
wingspan | Float64 | Yes | Wingspan in inches | DraftCombineStats.DraftCombineStats.WINGSPAN |
wingspan_ft_in | String | Yes | Wingspan in feet-inches | DraftCombineStats.DraftCombineStats.WINGSPAN_FT_IN |
standing_reach | Float64 | Yes | Standing reach in inches | DraftCombineStats.DraftCombineStats.STANDING_REACH |
standing_reach_ft_in | String | Yes | Standing reach in feet-inches | DraftCombineStats.DraftCombineStats.STANDING_REACH_FT_IN |
body_fat_pct | Float64 | Yes | Body fat percentage | DraftCombineStats.DraftCombineStats.BODY_FAT_PCT |
hand_length | Float64 | Yes | Hand length in inches | DraftCombineStats.DraftCombineStats.HAND_LENGTH |
hand_width | Float64 | Yes | Hand width in inches | DraftCombineStats.DraftCombineStats.HAND_WIDTH |
standing_vertical_leap | Float64 | Yes | Standing vertical leap in inches | DraftCombineStats.DraftCombineStats.STANDING_VERTICAL_LEAP |
max_vertical_leap | Float64 | Yes | Maximum vertical leap in inches | DraftCombineStats.DraftCombineStats.MAX_VERTICAL_LEAP |
lane_agility_time | Float64 | Yes | Lane agility drill time in seconds | DraftCombineStats.DraftCombineStats.LANE_AGILITY_TIME |
modified_lane_agility_time | Float64 | Yes | Modified lane agility time in seconds | DraftCombineStats.DraftCombineStats.MODIFIED_LANE_AGILITY_TIME |
three_quarter_sprint | Float64 | Yes | Three-quarter court sprint time in seconds | DraftCombineStats.DraftCombineStats.THREE_QUARTER_SPRINT |
bench_press | Float64 | Yes | Bench press repetitions | DraftCombineStats.DraftCombineStats.BENCH_PRESS |
staging_draft_history
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
person_id | Int64 | No | Unique player identifier (FK → staging_player.person_id) | DraftHistory.DraftHistory.PERSON_ID |
player_name | String | Yes | Player full name | DraftHistory.DraftHistory.PLAYER_NAME |
season | String | No | Draft season year | DraftHistory.DraftHistory.SEASON |
round_number | Int64 | Yes | Draft round number | DraftHistory.DraftHistory.ROUND_NUMBER |
round_pick | Int64 | Yes | Pick number within the round | DraftHistory.DraftHistory.ROUND_PICK |
overall_pick | Int64 | Yes | Overall draft pick number | DraftHistory.DraftHistory.OVERALL_PICK |
draft_type | String | Yes | Type of draft | DraftHistory.DraftHistory.DRAFT_TYPE |
team_id | Int64 | Yes | Team identifier (FK → staging_team.team_id) | DraftHistory.DraftHistory.TEAM_ID |
team_city | String | Yes | Team city name | DraftHistory.DraftHistory.TEAM_CITY |
team_name | String | Yes | Team name | DraftHistory.DraftHistory.TEAM_NAME |
team_abbreviation | String | Yes | Team abbreviation code | DraftHistory.DraftHistory.TEAM_ABBREVIATION |
organization | String | Yes | Pre-draft organization | DraftHistory.DraftHistory.ORGANIZATION |
organization_type | String | Yes | Type of pre-draft organization | DraftHistory.DraftHistory.ORGANIZATION_TYPE |
player_profile_flag | Int64 | Yes | Player profile availability flag | DraftHistory.DraftHistory.PLAYER_PROFILE_FLAG |
staging_game_leaders
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
game_id | String | No | Unique game identifier | ScoreboardV3.GameLeaders.gameId |
team_id | Int64 | No | Team identifier (FK → staging_team.team_id) | ScoreboardV3.GameLeaders.teamId |
leader_type | String | No | Leader category (home or away) | ScoreboardV3.GameLeaders.leaderType |
person_id | Int64 | No | Unique player identifier (FK → staging_player.person_id) | ScoreboardV3.GameLeaders.personId |
name | String | No | Player display name | ScoreboardV3.GameLeaders.name |
player_slug | String | Yes | Player URL slug | ScoreboardV3.GameLeaders.playerSlug |
jersey_num | String | Yes | Player jersey number | ScoreboardV3.GameLeaders.jerseyNum |
position | String | Yes | Player position | ScoreboardV3.GameLeaders.position |
team_tricode | String | Yes | Three-letter team code | ScoreboardV3.GameLeaders.teamTricode |
points | Float64 | Yes | Points scored | ScoreboardV3.GameLeaders.points |
rebounds | Float64 | Yes | Total rebounds | ScoreboardV3.GameLeaders.rebounds |
assists | Float64 | Yes | Total assists | ScoreboardV3.GameLeaders.assists |
staging_game_rotation
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
game_id | String | No | Unique game identifier | GameRotation.HomeTeam.GAME_ID |
team_id | Int64 | Yes | Team identifier (FK → staging_team.team_id) | GameRotation.HomeTeam.TEAM_ID |
team_city | String | Yes | Team city name | GameRotation.HomeTeam.TEAM_CITY |
team_name | String | Yes | Team name | GameRotation.HomeTeam.TEAM_NAME |
person_id | Int64 | Yes | Player person identifier (FK → staging_player.person_id) | GameRotation.HomeTeam.PERSON_ID |
player_first | String | Yes | Player first name | GameRotation.HomeTeam.PLAYER_FIRST |
player_last | String | Yes | Player last name | GameRotation.HomeTeam.PLAYER_LAST |
in_time_real | Float64 | Yes | Real time player entered game | GameRotation.HomeTeam.IN_TIME_REAL |
out_time_real | Float64 | Yes | Real time player exited game | GameRotation.HomeTeam.OUT_TIME_REAL |
player_pts | Float64 | Yes | Points scored during stint | GameRotation.HomeTeam.PLAYER_PTS |
pt_diff | Float64 | Yes | Point differential during stint | GameRotation.HomeTeam.PT_DIFF |
usg_pct | Float64 | Yes | Usage percentage during stint | GameRotation.HomeTeam.USG_PCT |
staging_league_dash_player_stats
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
player_id | Int64 | No | Unique player identifier (FK → staging_player.person_id) | LeagueDashPlayerStats.LeagueDashPlayerStats.PLAYER_ID |
player_name | String | Yes | Player full name | LeagueDashPlayerStats.LeagueDashPlayerStats.PLAYER_NAME |
team_id | Int64 | No | Team identifier (FK → staging_team.team_id) | LeagueDashPlayerStats.LeagueDashPlayerStats.TEAM_ID |
team_abbreviation | String | Yes | Team abbreviation code | LeagueDashPlayerStats.LeagueDashPlayerStats.TEAM_ABBREVIATION |
age | Float64 | Yes | Player age | LeagueDashPlayerStats.LeagueDashPlayerStats.AGE |
gp | Int64 | Yes | Games played | LeagueDashPlayerStats.LeagueDashPlayerStats.GP |
w | Int64 | Yes | Wins | LeagueDashPlayerStats.LeagueDashPlayerStats.W |
l | Int64 | Yes | Losses | LeagueDashPlayerStats.LeagueDashPlayerStats.L |
w_pct | Float64 | Yes | Win percentage | LeagueDashPlayerStats.LeagueDashPlayerStats.W_PCT |
min | Float64 | Yes | Minutes played | LeagueDashPlayerStats.LeagueDashPlayerStats.MIN |
fgm | Float64 | Yes | Field goals made | LeagueDashPlayerStats.LeagueDashPlayerStats.FGM |
fga | Float64 | Yes | Field goals attempted | LeagueDashPlayerStats.LeagueDashPlayerStats.FGA |
fg_pct | Float64 | Yes | Field goal percentage | LeagueDashPlayerStats.LeagueDashPlayerStats.FG_PCT |
fg3m | Float64 | Yes | Three-point field goals made | LeagueDashPlayerStats.LeagueDashPlayerStats.FG3M |
fg3a | Float64 | Yes | Three-point field goals attempted | LeagueDashPlayerStats.LeagueDashPlayerStats.FG3A |
fg3_pct | Float64 | Yes | Three-point field goal percentage | LeagueDashPlayerStats.LeagueDashPlayerStats.FG3_PCT |
ftm | Float64 | Yes | Free throws made | LeagueDashPlayerStats.LeagueDashPlayerStats.FTM |
fta | Float64 | Yes | Free throws attempted | LeagueDashPlayerStats.LeagueDashPlayerStats.FTA |
ft_pct | Float64 | Yes | Free throw percentage | LeagueDashPlayerStats.LeagueDashPlayerStats.FT_PCT |
oreb | Float64 | Yes | Offensive rebounds | LeagueDashPlayerStats.LeagueDashPlayerStats.OREB |
dreb | Float64 | Yes | Defensive rebounds | LeagueDashPlayerStats.LeagueDashPlayerStats.DREB |
reb | Float64 | Yes | Total rebounds | LeagueDashPlayerStats.LeagueDashPlayerStats.REB |
ast | Float64 | Yes | Assists | LeagueDashPlayerStats.LeagueDashPlayerStats.AST |
tov | Float64 | Yes | Turnovers | LeagueDashPlayerStats.LeagueDashPlayerStats.TOV |
stl | Float64 | Yes | Steals | LeagueDashPlayerStats.LeagueDashPlayerStats.STL |
blk | Float64 | Yes | Blocks | LeagueDashPlayerStats.LeagueDashPlayerStats.BLK |
blka | Float64 | Yes | Blocked attempts | LeagueDashPlayerStats.LeagueDashPlayerStats.BLKA |
pf | Float64 | Yes | Personal fouls | LeagueDashPlayerStats.LeagueDashPlayerStats.PF |
pfd | Float64 | Yes | Personal fouls drawn | LeagueDashPlayerStats.LeagueDashPlayerStats.PFD |
pts | Float64 | Yes | Points scored | LeagueDashPlayerStats.LeagueDashPlayerStats.PTS |
plus_minus | Float64 | Yes | Plus-minus differential | LeagueDashPlayerStats.LeagueDashPlayerStats.PLUS_MINUS |
nba_fantasy_pts | Float64 | Yes | NBA fantasy points | LeagueDashPlayerStats.LeagueDashPlayerStats.NBA_FANTASY_PTS |
dd2 | Float64 | Yes | Double-doubles | LeagueDashPlayerStats.LeagueDashPlayerStats.DD2 |
td3 | Float64 | Yes | Triple-doubles | LeagueDashPlayerStats.LeagueDashPlayerStats.TD3 |
gp_rank | Int64 | Yes | Games played rank | LeagueDashPlayerStats.LeagueDashPlayerStats.GP_RANK |
w_rank | Int64 | Yes | Wins rank | LeagueDashPlayerStats.LeagueDashPlayerStats.W_RANK |
l_rank | Int64 | Yes | Losses rank | LeagueDashPlayerStats.LeagueDashPlayerStats.L_RANK |
w_pct_rank | Int64 | Yes | Win percentage rank | LeagueDashPlayerStats.LeagueDashPlayerStats.W_PCT_RANK |
min_rank | Int64 | Yes | Minutes played rank | LeagueDashPlayerStats.LeagueDashPlayerStats.MIN_RANK |
fgm_rank | Int64 | Yes | Field goals made rank | LeagueDashPlayerStats.LeagueDashPlayerStats.FGM_RANK |
fga_rank | Int64 | Yes | Field goals attempted rank | LeagueDashPlayerStats.LeagueDashPlayerStats.FGA_RANK |
fg_pct_rank | Int64 | Yes | Field goal percentage rank | LeagueDashPlayerStats.LeagueDashPlayerStats.FG_PCT_RANK |
fg3m_rank | Int64 | Yes | Three-point field goals made rank | LeagueDashPlayerStats.LeagueDashPlayerStats.FG3M_RANK |
fg3a_rank | Int64 | Yes | Three-point field goals attempted rank | LeagueDashPlayerStats.LeagueDashPlayerStats.FG3A_RANK |
fg3_pct_rank | Int64 | Yes | Three-point percentage rank | LeagueDashPlayerStats.LeagueDashPlayerStats.FG3_PCT_RANK |
ftm_rank | Int64 | Yes | Free throws made rank | LeagueDashPlayerStats.LeagueDashPlayerStats.FTM_RANK |
fta_rank | Int64 | Yes | Free throws attempted rank | LeagueDashPlayerStats.LeagueDashPlayerStats.FTA_RANK |
ft_pct_rank | Int64 | Yes | Free throw percentage rank | LeagueDashPlayerStats.LeagueDashPlayerStats.FT_PCT_RANK |
oreb_rank | Int64 | Yes | Offensive rebounds rank | LeagueDashPlayerStats.LeagueDashPlayerStats.OREB_RANK |
dreb_rank | Int64 | Yes | Defensive rebounds rank | LeagueDashPlayerStats.LeagueDashPlayerStats.DREB_RANK |
reb_rank | Int64 | Yes | Total rebounds rank | LeagueDashPlayerStats.LeagueDashPlayerStats.REB_RANK |
ast_rank | Int64 | Yes | Assists rank | LeagueDashPlayerStats.LeagueDashPlayerStats.AST_RANK |
tov_rank | Int64 | Yes | Turnovers rank | LeagueDashPlayerStats.LeagueDashPlayerStats.TOV_RANK |
stl_rank | Int64 | Yes | Steals rank | LeagueDashPlayerStats.LeagueDashPlayerStats.STL_RANK |
blk_rank | Int64 | Yes | Blocks rank | LeagueDashPlayerStats.LeagueDashPlayerStats.BLK_RANK |
blka_rank | Int64 | Yes | Blocked attempts rank | LeagueDashPlayerStats.LeagueDashPlayerStats.BLKA_RANK |
pf_rank | Int64 | Yes | Personal fouls rank | LeagueDashPlayerStats.LeagueDashPlayerStats.PF_RANK |
pfd_rank | Int64 | Yes | Personal fouls drawn rank | LeagueDashPlayerStats.LeagueDashPlayerStats.PFD_RANK |
pts_rank | Int64 | Yes | Points scored rank | LeagueDashPlayerStats.LeagueDashPlayerStats.PTS_RANK |
plus_minus_rank | Int64 | Yes | Plus-minus rank | LeagueDashPlayerStats.LeagueDashPlayerStats.PLUS_MINUS_RANK |
nba_fantasy_pts_rank | Int64 | Yes | NBA fantasy points rank | LeagueDashPlayerStats.LeagueDashPlayerStats.NBA_FANTASY_PTS_RANK |
dd2_rank | Int64 | Yes | Double-doubles rank | LeagueDashPlayerStats.LeagueDashPlayerStats.DD2_RANK |
td3_rank | Int64 | Yes | Triple-doubles rank | LeagueDashPlayerStats.LeagueDashPlayerStats.TD3_RANK |
cfid | Int64 | Yes | Custom filter identifier | LeagueDashPlayerStats.LeagueDashPlayerStats.CFID |
cfparams | String | Yes | Custom filter parameters | LeagueDashPlayerStats.LeagueDashPlayerStats.CFPARAMS |
staging_league_dash_team_stats
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
team_id | Int64 | No | Unique team identifier (FK → staging_team.team_id) | LeagueDashTeamStats.LeagueDashTeamStats.TEAM_ID |
team_name | String | Yes | Team name | LeagueDashTeamStats.LeagueDashTeamStats.TEAM_NAME |
gp | Int64 | Yes | Games played | LeagueDashTeamStats.LeagueDashTeamStats.GP |
w | Int64 | Yes | Wins | LeagueDashTeamStats.LeagueDashTeamStats.W |
l | Int64 | Yes | Losses | LeagueDashTeamStats.LeagueDashTeamStats.L |
w_pct | Float64 | Yes | Win percentage | LeagueDashTeamStats.LeagueDashTeamStats.W_PCT |
min | Float64 | Yes | Minutes played | LeagueDashTeamStats.LeagueDashTeamStats.MIN |
fgm | Float64 | Yes | Field goals made | LeagueDashTeamStats.LeagueDashTeamStats.FGM |
fga | Float64 | Yes | Field goals attempted | LeagueDashTeamStats.LeagueDashTeamStats.FGA |
fg_pct | Float64 | Yes | Field goal percentage | LeagueDashTeamStats.LeagueDashTeamStats.FG_PCT |
fg3m | Float64 | Yes | Three-point field goals made | LeagueDashTeamStats.LeagueDashTeamStats.FG3M |
fg3a | Float64 | Yes | Three-point field goals attempted | LeagueDashTeamStats.LeagueDashTeamStats.FG3A |
fg3_pct | Float64 | Yes | Three-point field goal percentage | LeagueDashTeamStats.LeagueDashTeamStats.FG3_PCT |
ftm | Float64 | Yes | Free throws made | LeagueDashTeamStats.LeagueDashTeamStats.FTM |
fta | Float64 | Yes | Free throws attempted | LeagueDashTeamStats.LeagueDashTeamStats.FTA |
ft_pct | Float64 | Yes | Free throw percentage | LeagueDashTeamStats.LeagueDashTeamStats.FT_PCT |
oreb | Float64 | Yes | Offensive rebounds | LeagueDashTeamStats.LeagueDashTeamStats.OREB |
dreb | Float64 | Yes | Defensive rebounds | LeagueDashTeamStats.LeagueDashTeamStats.DREB |
reb | Float64 | Yes | Total rebounds | LeagueDashTeamStats.LeagueDashTeamStats.REB |
ast | Float64 | Yes | Assists | LeagueDashTeamStats.LeagueDashTeamStats.AST |
tov | Float64 | Yes | Turnovers | LeagueDashTeamStats.LeagueDashTeamStats.TOV |
stl | Float64 | Yes | Steals | LeagueDashTeamStats.LeagueDashTeamStats.STL |
blk | Float64 | Yes | Blocks | LeagueDashTeamStats.LeagueDashTeamStats.BLK |
blka | Float64 | Yes | Blocked attempts | LeagueDashTeamStats.LeagueDashTeamStats.BLKA |
pf | Float64 | Yes | Personal fouls | LeagueDashTeamStats.LeagueDashTeamStats.PF |
pfd | Float64 | Yes | Personal fouls drawn | LeagueDashTeamStats.LeagueDashTeamStats.PFD |
pts | Float64 | Yes | Points scored | LeagueDashTeamStats.LeagueDashTeamStats.PTS |
plus_minus | Float64 | Yes | Plus-minus differential | LeagueDashTeamStats.LeagueDashTeamStats.PLUS_MINUS |
gp_rank | Int64 | Yes | Games played rank | LeagueDashTeamStats.LeagueDashTeamStats.GP_RANK |
w_rank | Int64 | Yes | Wins rank | LeagueDashTeamStats.LeagueDashTeamStats.W_RANK |
l_rank | Int64 | Yes | Losses rank | LeagueDashTeamStats.LeagueDashTeamStats.L_RANK |
w_pct_rank | Int64 | Yes | Win percentage rank | LeagueDashTeamStats.LeagueDashTeamStats.W_PCT_RANK |
min_rank | Int64 | Yes | Minutes played rank | LeagueDashTeamStats.LeagueDashTeamStats.MIN_RANK |
fgm_rank | Int64 | Yes | Field goals made rank | LeagueDashTeamStats.LeagueDashTeamStats.FGM_RANK |
fga_rank | Int64 | Yes | Field goals attempted rank | LeagueDashTeamStats.LeagueDashTeamStats.FGA_RANK |
fg_pct_rank | Int64 | Yes | Field goal percentage rank | LeagueDashTeamStats.LeagueDashTeamStats.FG_PCT_RANK |
fg3m_rank | Int64 | Yes | Three-point field goals made rank | LeagueDashTeamStats.LeagueDashTeamStats.FG3M_RANK |
fg3a_rank | Int64 | Yes | Three-point field goals attempted rank | LeagueDashTeamStats.LeagueDashTeamStats.FG3A_RANK |
fg3_pct_rank | Int64 | Yes | Three-point percentage rank | LeagueDashTeamStats.LeagueDashTeamStats.FG3_PCT_RANK |
ftm_rank | Int64 | Yes | Free throws made rank | LeagueDashTeamStats.LeagueDashTeamStats.FTM_RANK |
fta_rank | Int64 | Yes | Free throws attempted rank | LeagueDashTeamStats.LeagueDashTeamStats.FTA_RANK |
ft_pct_rank | Int64 | Yes | Free throw percentage rank | LeagueDashTeamStats.LeagueDashTeamStats.FT_PCT_RANK |
oreb_rank | Int64 | Yes | Offensive rebounds rank | LeagueDashTeamStats.LeagueDashTeamStats.OREB_RANK |
dreb_rank | Int64 | Yes | Defensive rebounds rank | LeagueDashTeamStats.LeagueDashTeamStats.DREB_RANK |
reb_rank | Int64 | Yes | Total rebounds rank | LeagueDashTeamStats.LeagueDashTeamStats.REB_RANK |
ast_rank | Int64 | Yes | Assists rank | LeagueDashTeamStats.LeagueDashTeamStats.AST_RANK |
tov_rank | Int64 | Yes | Turnovers rank | LeagueDashTeamStats.LeagueDashTeamStats.TOV_RANK |
stl_rank | Int64 | Yes | Steals rank | LeagueDashTeamStats.LeagueDashTeamStats.STL_RANK |
blk_rank | Int64 | Yes | Blocks rank | LeagueDashTeamStats.LeagueDashTeamStats.BLK_RANK |
blka_rank | Int64 | Yes | Blocked attempts rank | LeagueDashTeamStats.LeagueDashTeamStats.BLKA_RANK |
pf_rank | Int64 | Yes | Personal fouls rank | LeagueDashTeamStats.LeagueDashTeamStats.PF_RANK |
pfd_rank | Int64 | Yes | Personal fouls drawn rank | LeagueDashTeamStats.LeagueDashTeamStats.PFD_RANK |
pts_rank | Int64 | Yes | Points scored rank | LeagueDashTeamStats.LeagueDashTeamStats.PTS_RANK |
plus_minus_rank | Int64 | Yes | Plus-minus rank | LeagueDashTeamStats.LeagueDashTeamStats.PLUS_MINUS_RANK |
cfid | Int64 | Yes | Custom filter identifier | LeagueDashTeamStats.LeagueDashTeamStats.CFID |
cfparams | String | Yes | Custom filter parameters | LeagueDashTeamStats.LeagueDashTeamStats.CFPARAMS |
staging_league_game_log
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
season_id | String | No | Season identifier | LeagueGameLog.LeagueGameLog.SEASON_ID |
team_id | Int64 | No | Unique team identifier (FK → staging_team.team_id) | LeagueGameLog.LeagueGameLog.TEAM_ID |
team_abbreviation | String | No | Team abbreviation code | LeagueGameLog.LeagueGameLog.TEAM_ABBREVIATION |
team_name | String | No | Team name | LeagueGameLog.LeagueGameLog.TEAM_NAME |
game_id | String | No | Unique game identifier | LeagueGameLog.LeagueGameLog.GAME_ID |
game_date | String | No | Date of the game | LeagueGameLog.LeagueGameLog.GAME_DATE |
matchup | String | No | Matchup string (e.g. LAL vs. BOS) | LeagueGameLog.LeagueGameLog.MATCHUP |
wl | String | Yes | Win or loss indicator | LeagueGameLog.LeagueGameLog.WL |
w | Int64 | Yes | Wins | LeagueGameLog.LeagueGameLog.W |
l | Int64 | Yes | Losses | LeagueGameLog.LeagueGameLog.L |
w_pct | Float64 | Yes | Win percentage | LeagueGameLog.LeagueGameLog.W_PCT |
min | Float64 | Yes | Minutes played | LeagueGameLog.LeagueGameLog.MIN |
fgm | Float64 | Yes | Field goals made | LeagueGameLog.LeagueGameLog.FGM |
fga | Float64 | Yes | Field goals attempted | LeagueGameLog.LeagueGameLog.FGA |
fg_pct | Float64 | Yes | Field goal percentage | LeagueGameLog.LeagueGameLog.FG_PCT |
fg3m | Float64 | Yes | Three-point field goals made | LeagueGameLog.LeagueGameLog.FG3M |
fg3a | Float64 | Yes | Three-point field goals attempted | LeagueGameLog.LeagueGameLog.FG3A |
fg3_pct | Float64 | Yes | Three-point field goal percentage | LeagueGameLog.LeagueGameLog.FG3_PCT |
ftm | Float64 | Yes | Free throws made | LeagueGameLog.LeagueGameLog.FTM |
fta | Float64 | Yes | Free throws attempted | LeagueGameLog.LeagueGameLog.FTA |
ft_pct | Float64 | Yes | Free throw percentage | LeagueGameLog.LeagueGameLog.FT_PCT |
oreb | Float64 | Yes | Offensive rebounds | LeagueGameLog.LeagueGameLog.OREB |
dreb | Float64 | Yes | Defensive rebounds | LeagueGameLog.LeagueGameLog.DREB |
reb | Float64 | Yes | Total rebounds | LeagueGameLog.LeagueGameLog.REB |
ast | Float64 | Yes | Assists | LeagueGameLog.LeagueGameLog.AST |
stl | Float64 | Yes | Steals | LeagueGameLog.LeagueGameLog.STL |
blk | Float64 | Yes | Blocks | LeagueGameLog.LeagueGameLog.BLK |
tov | Float64 | Yes | Turnovers | LeagueGameLog.LeagueGameLog.TOV |
pf | Float64 | Yes | Personal fouls | LeagueGameLog.LeagueGameLog.PF |
pts | Float64 | Yes | Points scored | LeagueGameLog.LeagueGameLog.PTS |
plus_minus | Float64 | Yes | Plus-minus differential | LeagueGameLog.LeagueGameLog.PLUS_MINUS |
video_available | Int64 | Yes | Video availability flag | LeagueGameLog.LeagueGameLog.VIDEO_AVAILABLE |
staging_league_lineup_viz
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
group_id | String | No | Lineup group identifier | LeagueLineupViz.LeagueLineupViz.GROUP_ID |
group_name | String | Yes | Lineup player names | LeagueLineupViz.LeagueLineupViz.GROUP_NAME |
team_id | Int64 | No | Team identifier (FK → staging_team.team_id) | LeagueLineupViz.LeagueLineupViz.TEAM_ID |
team_abbreviation | String | Yes | Team abbreviation code | LeagueLineupViz.LeagueLineupViz.TEAM_ABBREVIATION |
min | Float64 | Yes | Minutes played | LeagueLineupViz.LeagueLineupViz.MIN |
off_rating | Float64 | Yes | Offensive rating | LeagueLineupViz.LeagueLineupViz.OFF_RATING |
def_rating | Float64 | Yes | Defensive rating | LeagueLineupViz.LeagueLineupViz.DEF_RATING |
net_rating | Float64 | Yes | Net rating | LeagueLineupViz.LeagueLineupViz.NET_RATING |
pace | Float64 | Yes | Pace factor | LeagueLineupViz.LeagueLineupViz.PACE |
ts_pct | Float64 | Yes | True shooting percentage | LeagueLineupViz.LeagueLineupViz.TS_PCT |
fta_rate | Float64 | Yes | Free throw attempt rate | LeagueLineupViz.LeagueLineupViz.FTA_RATE |
tm_ast_pct | Float64 | Yes | Team assist percentage | LeagueLineupViz.LeagueLineupViz.TM_AST_PCT |
pct_fga_2pt | Float64 | Yes | Percentage of field goal attempts from two-point range | LeagueLineupViz.LeagueLineupViz.PCT_FGA_2PT |
pct_fga_3pt | Float64 | Yes | Percentage of field goal attempts from three-point range | LeagueLineupViz.LeagueLineupViz.PCT_FGA_3PT |
pct_pts_2pt_mr | Float64 | Yes | Percentage of points from mid-range two-pointers | LeagueLineupViz.LeagueLineupViz.PCT_PTS_2PT_MR |
pct_pts_fb | Float64 | Yes | Percentage of points from fast breaks | LeagueLineupViz.LeagueLineupViz.PCT_PTS_FB |
pct_pts_ft | Float64 | Yes | Percentage of points from free throws | LeagueLineupViz.LeagueLineupViz.PCT_PTS_FT |
pct_pts_paint | Float64 | Yes | Percentage of points in the paint | LeagueLineupViz.LeagueLineupViz.PCT_PTS_PAINT |
pct_ast_fgm | Float64 | Yes | Percentage of assisted field goals | LeagueLineupViz.LeagueLineupViz.PCT_AST_FGM |
pct_uast_fgm | Float64 | Yes | Percentage of unassisted field goals | LeagueLineupViz.LeagueLineupViz.PCT_UAST_FGM |
opp_fg3_pct | Float64 | Yes | Opponent three-point percentage | LeagueLineupViz.LeagueLineupViz.OPP_FG3_PCT |
opp_efg_pct | Float64 | Yes | Opponent effective field goal percentage | LeagueLineupViz.LeagueLineupViz.OPP_EFG_PCT |
opp_fta_rate | Float64 | Yes | Opponent free throw attempt rate | LeagueLineupViz.LeagueLineupViz.OPP_FTA_RATE |
opp_tov_pct | Float64 | Yes | Opponent turnover percentage | LeagueLineupViz.LeagueLineupViz.OPP_TOV_PCT |
staging_league_standings_v3
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
league_id | String | No | League identifier | LeagueStandingsV3.Standings.LeagueID |
season_id | String | Yes | Season identifier | LeagueStandingsV3.Standings.SeasonID |
team_id | Int64 | No | Unique team identifier (FK → staging_team.team_id) | LeagueStandingsV3.Standings.TeamID |
team_city | String | Yes | Team city name | LeagueStandingsV3.Standings.TeamCity |
team_name | String | Yes | Team name | LeagueStandingsV3.Standings.TeamName |
team_slug | String | Yes | URL-friendly team slug | LeagueStandingsV3.Standings.TeamSlug |
conference | String | Yes | Conference name | LeagueStandingsV3.Standings.Conference |
conference_record | String | Yes | Win-loss record in conference | LeagueStandingsV3.Standings.ConferenceRecord |
playoff_rank | Int64 | Yes | Playoff seeding rank | LeagueStandingsV3.Standings.PlayoffRank |
clinch_indicator | String | Yes | Clinch status indicator | LeagueStandingsV3.Standings.ClinchIndicator |
division | String | Yes | Division name | LeagueStandingsV3.Standings.Division |
division_record | String | Yes | Win-loss record in division | LeagueStandingsV3.Standings.DivisionRecord |
division_rank | Int64 | Yes | Rank within division | LeagueStandingsV3.Standings.DivisionRank |
wins | Int64 | Yes | Total wins | LeagueStandingsV3.Standings.WINS |
losses | Int64 | Yes | Total losses | LeagueStandingsV3.Standings.LOSSES |
win_pct | Float64 | Yes | Winning percentage | LeagueStandingsV3.Standings.WinPCT |
league_rank | Int64 | Yes | Overall league rank | LeagueStandingsV3.Standings.LeagueRank |
record | String | Yes | Overall win-loss record | LeagueStandingsV3.Standings.Record |
home | String | Yes | Home win-loss record | LeagueStandingsV3.Standings.HOME |
road | String | Yes | Road win-loss record | LeagueStandingsV3.Standings.ROAD |
l10 | String | Yes | Record in last 10 games | LeagueStandingsV3.Standings.L10 |
long_win_streak | Int64 | Yes | Longest winning streak | LeagueStandingsV3.Standings.LongWinStreak |
long_loss_streak | Int64 | Yes | Longest losing streak | LeagueStandingsV3.Standings.LongLossStreak |
current_streak | String | Yes | Current win or loss streak | LeagueStandingsV3.Standings.CurrentStreak |
ot_record | String | Yes | Overtime win-loss record | LeagueStandingsV3.Standings.OT_Record |
three_pts_or_less | String | Yes | Record in games decided by 3 points or less | LeagueStandingsV3.Standings.ThreePTSOrLess |
ten_pts_or_more | String | Yes | Record in games decided by 10 points or more | LeagueStandingsV3.Standings.TenPTSOrMore |
conference_games_back | Float64 | Yes | Games behind conference leader | LeagueStandingsV3.Standings.ConferenceGamesBack |
division_games_back | Float64 | Yes | Games behind division leader | LeagueStandingsV3.Standings.DivisionGamesBack |
clinched_conference_title | Int64 | Yes | Whether team clinched conference | LeagueStandingsV3.Standings.ClinchedConferenceTitle |
clinched_division_title | Int64 | Yes | Whether team clinched division | LeagueStandingsV3.Standings.ClinchedDivisionTitle |
clinched_playoff_birth | Int64 | Yes | Whether team clinched playoff berth | LeagueStandingsV3.Standings.ClinchedPlayoffBirth |
eliminated_conference | Int64 | Yes | Whether team eliminated from conference playoff contention | LeagueStandingsV3.Standings.EliminatedConference |
pts_pg | Float64 | Yes | Points per game | LeagueStandingsV3.Standings.PointsPG |
opp_pts_pg | Float64 | Yes | Opponent points per game | LeagueStandingsV3.Standings.OppPointsPG |
diff_pts_pg | Float64 | Yes | Point differential per game | LeagueStandingsV3.Standings.DiffPointsPG |
staging_play_by_play_v2
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
game_id | String | No | Unique game identifier | PlayByPlayV2.PlayByPlay.GAME_ID |
eventnum | Int64 | No | Event sequence number | PlayByPlayV2.PlayByPlay.EVENTNUM |
eventmsgtype | Int64 | No | Event message type code | PlayByPlayV2.PlayByPlay.EVENTMSGTYPE |
eventmsgactiontype | Int64 | No | Event message action type code | PlayByPlayV2.PlayByPlay.EVENTMSGACTIONTYPE |
period | Int64 | No | Game period number | PlayByPlayV2.PlayByPlay.PERIOD |
wctimestring | String | Yes | Wall clock time string | PlayByPlayV2.PlayByPlay.WCTIMESTRING |
pctimestring | String | Yes | Period clock time string | PlayByPlayV2.PlayByPlay.PCTIMESTRING |
homedescription | String | Yes | Play description for home team | PlayByPlayV2.PlayByPlay.HOMEDESCRIPTION |
neutraldescription | String | Yes | Neutral play description | PlayByPlayV2.PlayByPlay.NEUTRALDESCRIPTION |
visitordescription | String | Yes | Play description for visitor team | PlayByPlayV2.PlayByPlay.VISITORDESCRIPTION |
score | String | Yes | Current game score | PlayByPlayV2.PlayByPlay.SCORE |
scoremargin | String | Yes | Score margin value | PlayByPlayV2.PlayByPlay.SCOREMARGIN |
person1type | Int64 | Yes | Person 1 type identifier | PlayByPlayV2.PlayByPlay.PERSON1TYPE |
player1_id | Int64 | Yes | Player 1 unique identifier (FK → staging_player.person_id) | PlayByPlayV2.PlayByPlay.PLAYER1_ID |
player1_name | String | Yes | Player 1 full name | PlayByPlayV2.PlayByPlay.PLAYER1_NAME |
player1_team_id | Int64 | Yes | Player 1 team identifier (FK → staging_team.team_id) | PlayByPlayV2.PlayByPlay.PLAYER1_TEAM_ID |
player1_team_city | String | Yes | Player 1 team city | PlayByPlayV2.PlayByPlay.PLAYER1_TEAM_CITY |
player1_team_nickname | String | Yes | Player 1 team nickname | PlayByPlayV2.PlayByPlay.PLAYER1_TEAM_NICKNAME |
player1_team_abbreviation | String | Yes | Player 1 team abbreviation | PlayByPlayV2.PlayByPlay.PLAYER1_TEAM_ABBREVIATION |
person2type | Int64 | Yes | Person 2 type identifier | PlayByPlayV2.PlayByPlay.PERSON2TYPE |
player2_id | Int64 | Yes | Player 2 unique identifier (FK → staging_player.person_id) | PlayByPlayV2.PlayByPlay.PLAYER2_ID |
player2_name | String | Yes | Player 2 full name | PlayByPlayV2.PlayByPlay.PLAYER2_NAME |
player2_team_id | Int64 | Yes | Player 2 team identifier (FK → staging_team.team_id) | PlayByPlayV2.PlayByPlay.PLAYER2_TEAM_ID |
player2_team_city | String | Yes | Player 2 team city | PlayByPlayV2.PlayByPlay.PLAYER2_TEAM_CITY |
player2_team_nickname | String | Yes | Player 2 team nickname | PlayByPlayV2.PlayByPlay.PLAYER2_TEAM_NICKNAME |
player2_team_abbreviation | String | Yes | Player 2 team abbreviation | PlayByPlayV2.PlayByPlay.PLAYER2_TEAM_ABBREVIATION |
person3type | Int64 | Yes | Person 3 type identifier | PlayByPlayV2.PlayByPlay.PERSON3TYPE |
player3_id | Int64 | Yes | Player 3 unique identifier (FK → staging_player.person_id) | PlayByPlayV2.PlayByPlay.PLAYER3_ID |
player3_name | String | Yes | Player 3 full name | PlayByPlayV2.PlayByPlay.PLAYER3_NAME |
player3_team_id | Int64 | Yes | Player 3 team identifier (FK → staging_team.team_id) | PlayByPlayV2.PlayByPlay.PLAYER3_TEAM_ID |
player3_team_city | String | Yes | Player 3 team city | PlayByPlayV2.PlayByPlay.PLAYER3_TEAM_CITY |
player3_team_nickname | String | Yes | Player 3 team nickname | PlayByPlayV2.PlayByPlay.PLAYER3_TEAM_NICKNAME |
player3_team_abbreviation | String | Yes | Player 3 team abbreviation | PlayByPlayV2.PlayByPlay.PLAYER3_TEAM_ABBREVIATION |
video_available_flag | Int64 | Yes | Video availability flag | PlayByPlayV2.PlayByPlay.VIDEO_AVAILABLE_FLAG |
staging_play_by_play_v3
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
game_id | String | No | Unique game identifier | PlayByPlayV3.PlayByPlay.GAME_ID |
action_number | Int64 | No | Sequential action number within game | PlayByPlayV3.PlayByPlay.ACTION_NUMBER |
clock | String | Yes | Game clock time string | PlayByPlayV3.PlayByPlay.CLOCK |
period | Int64 | No | Game period number | PlayByPlayV3.PlayByPlay.PERIOD |
team_id | Int64 | Yes | Team identifier (FK → staging_team.team_id) | PlayByPlayV3.PlayByPlay.TEAM_ID |
team_tricode | String | Yes | Three-letter team abbreviation code | PlayByPlayV3.PlayByPlay.TEAM_TRICODE |
person_id | Int64 | Yes | Person identifier (FK → staging_player.person_id) | PlayByPlayV3.PlayByPlay.PERSON_ID |
player_name | String | Yes | Full player name | PlayByPlayV3.PlayByPlay.PLAYER_NAME |
player_name_i | String | Yes | Player name in initial format | PlayByPlayV3.PlayByPlay.PLAYER_NAME_I |
x_legacy | Float64 | Yes | Legacy x-coordinate of action | PlayByPlayV3.PlayByPlay.X_LEGACY |
y_legacy | Float64 | Yes | Legacy y-coordinate of action | PlayByPlayV3.PlayByPlay.Y_LEGACY |
shot_distance | Float64 | Yes | Distance of shot in feet | PlayByPlayV3.PlayByPlay.SHOT_DISTANCE |
shot_result | String | Yes | Result of shot attempt | PlayByPlayV3.PlayByPlay.SHOT_RESULT |
is_field_goal | Int64 | Yes | Flag indicating if action is a field goal attempt | PlayByPlayV3.PlayByPlay.IS_FIELD_GOAL |
score_home | String | Yes | Home team score | PlayByPlayV3.PlayByPlay.SCORE_HOME |
score_away | String | Yes | Away team score | PlayByPlayV3.PlayByPlay.SCORE_AWAY |
points_total | Int64 | Yes | Total points scored on the play | PlayByPlayV3.PlayByPlay.POINTS_TOTAL |
location | String | Yes | Home or away location indicator | PlayByPlayV3.PlayByPlay.LOCATION |
description | String | Yes | Text description of the play | PlayByPlayV3.PlayByPlay.DESCRIPTION |
action_type | String | Yes | Type of action performed | PlayByPlayV3.PlayByPlay.ACTION_TYPE |
sub_type | String | Yes | Sub-type of action performed | PlayByPlayV3.PlayByPlay.SUB_TYPE |
video_available | Int64 | Yes | Video availability flag | PlayByPlayV3.PlayByPlay.VIDEO_AVAILABLE |
action_id | Int64 | Yes | Unique action identifier | PlayByPlayV3.PlayByPlay.ACTION_ID |
staging_player_dashboard_clutch
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
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 | Queried player identifier. | `` |
season_year | String | No | Queried season year. | `` |
season_type | String | No | Queried season type. | `` |
staging_player_dashboard_game_splits
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
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 | Queried player identifier. | `` |
season_year | String | No | Queried season year. | `` |
season_type | String | No | Queried season type. | `` |
staging_player_dashboard_general_splits
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
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 | Queried player identifier. | `` |
season_year | String | No | Queried season year. | `` |
season_type | String | No | Queried season type. | `` |
staging_player_dashboard_last_n_games
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
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 | Queried player identifier. | `` |
season_year | String | No | Queried season year. | `` |
season_type | String | No | Queried season type. | `` |
staging_player_dashboard_shooting_splits
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
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 | Queried player identifier. | `` |
season_year | String | No | Queried season year. | `` |
season_type | String | No | Queried season type. | `` |
staging_player_dashboard_team_performance
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
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 | Queried player identifier. | `` |
season_year | String | No | Queried season year. | `` |
season_type | String | No | Queried season type. | `` |
staging_player_dashboard_year_over_year
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
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 | 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 | Queried player identifier. | `` |
season_year | String | No | Queried season year. | `` |
season_type | String | No | Queried season type. | `` |
staging_player_game_log
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
season_id | String | No | Season identifier | PlayerGameLog.PlayerGameLog.SEASON_ID |
player_id | Int64 | No | Unique player identifier (FK → staging_player.person_id) | PlayerGameLog.PlayerGameLog.PLAYER_ID |
game_id | String | No | Unique game identifier | PlayerGameLog.PlayerGameLog.GAME_ID |
game_date | String | No | Date of the game | PlayerGameLog.PlayerGameLog.GAME_DATE |
matchup | String | No | Matchup string (e.g. LAL vs. BOS) | PlayerGameLog.PlayerGameLog.MATCHUP |
wl | String | Yes | Win or loss indicator | PlayerGameLog.PlayerGameLog.WL |
min | Float64 | Yes | Minutes played | PlayerGameLog.PlayerGameLog.MIN |
fgm | Float64 | Yes | Field goals made | PlayerGameLog.PlayerGameLog.FGM |
fga | Float64 | Yes | Field goals attempted | PlayerGameLog.PlayerGameLog.FGA |
fg_pct | Float64 | Yes | Field goal percentage | PlayerGameLog.PlayerGameLog.FG_PCT |
fg3m | Float64 | Yes | Three-point field goals made | PlayerGameLog.PlayerGameLog.FG3M |
fg3a | Float64 | Yes | Three-point field goals attempted | PlayerGameLog.PlayerGameLog.FG3A |
fg3_pct | Float64 | Yes | Three-point field goal percentage | PlayerGameLog.PlayerGameLog.FG3_PCT |
ftm | Float64 | Yes | Free throws made | PlayerGameLog.PlayerGameLog.FTM |
fta | Float64 | Yes | Free throws attempted | PlayerGameLog.PlayerGameLog.FTA |
ft_pct | Float64 | Yes | Free throw percentage | PlayerGameLog.PlayerGameLog.FT_PCT |
oreb | Float64 | Yes | Offensive rebounds | PlayerGameLog.PlayerGameLog.OREB |
dreb | Float64 | Yes | Defensive rebounds | PlayerGameLog.PlayerGameLog.DREB |
reb | Float64 | Yes | Total rebounds | PlayerGameLog.PlayerGameLog.REB |
ast | Float64 | Yes | Assists | PlayerGameLog.PlayerGameLog.AST |
stl | Float64 | Yes | Steals | PlayerGameLog.PlayerGameLog.STL |
blk | Float64 | Yes | Blocks | PlayerGameLog.PlayerGameLog.BLK |
tov | Float64 | Yes | Turnovers | PlayerGameLog.PlayerGameLog.TOV |
pf | Float64 | Yes | Personal fouls | PlayerGameLog.PlayerGameLog.PF |
pts | Float64 | Yes | Points scored | PlayerGameLog.PlayerGameLog.PTS |
plus_minus | Float64 | Yes | Plus-minus differential | PlayerGameLog.PlayerGameLog.PLUS_MINUS |
staging_player_index
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
person_id | Int64 | No | Unique player identifier | PlayerIndex.PlayerIndex.PERSON_ID |
player_last_name | String | No | Player last name | PlayerIndex.PlayerIndex.PLAYER_LAST_NAME |
player_first_name | String | No | Player first name | PlayerIndex.PlayerIndex.PLAYER_FIRST_NAME |
player_slug | String | Yes | URL-friendly player slug | PlayerIndex.PlayerIndex.PLAYER_SLUG |
team_id | Int64 | Yes | Team identifier (FK → staging_team.team_id) | PlayerIndex.PlayerIndex.TEAM_ID |
team_slug | String | Yes | URL-friendly team slug | PlayerIndex.PlayerIndex.TEAM_SLUG |
is_defunct | Int64 | Yes | Whether team is defunct | PlayerIndex.PlayerIndex.IS_DEFUNCT |
team_city | String | Yes | Team city name | PlayerIndex.PlayerIndex.TEAM_CITY |
team_name | String | Yes | Team name | PlayerIndex.PlayerIndex.TEAM_NAME |
team_abbreviation | String | Yes | Team abbreviation code | PlayerIndex.PlayerIndex.TEAM_ABBREVIATION |
jersey_number | String | Yes | Jersey number as string | PlayerIndex.PlayerIndex.JERSEY_NUMBER |
position | String | Yes | Player position | PlayerIndex.PlayerIndex.POSITION |
height | String | Yes | Player height as string | PlayerIndex.PlayerIndex.HEIGHT |
weight | String | Yes | Player weight as string | PlayerIndex.PlayerIndex.WEIGHT |
college | String | Yes | College attended | PlayerIndex.PlayerIndex.COLLEGE |
country | String | Yes | Country of origin | PlayerIndex.PlayerIndex.COUNTRY |
draft_year | Int64 | Yes | Year drafted | PlayerIndex.PlayerIndex.DRAFT_YEAR |
draft_round | Int64 | Yes | Round drafted | PlayerIndex.PlayerIndex.DRAFT_ROUND |
draft_number | Int64 | Yes | Overall draft pick number | PlayerIndex.PlayerIndex.DRAFT_NUMBER |
roster_status | Float64 | Yes | Active roster status | PlayerIndex.PlayerIndex.ROSTER_STATUS |
pts | Float64 | Yes | Points per game | PlayerIndex.PlayerIndex.PTS |
reb | Float64 | Yes | Rebounds per game | PlayerIndex.PlayerIndex.REB |
ast | Float64 | Yes | Assists per game | PlayerIndex.PlayerIndex.AST |
stats_timeframe | String | Yes | Timeframe for stats | PlayerIndex.PlayerIndex.STATS_TIMEFRAME |
from_year | String | Yes | First year in the league | PlayerIndex.PlayerIndex.FROM_YEAR |
to_year | String | Yes | Last year in the league | PlayerIndex.PlayerIndex.TO_YEAR |
staging_player_perf_pts_scored
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
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 | Queried player identifier. | `` |
season_year | String | No | Queried season year. | `` |
season_type | String | No | Queried season type. | `` |
staging_player_shoot_assisted_by
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
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 | Queried player identifier. | `` |
season_year | String | No | Queried season year. | `` |
season_type | String | No | Queried season type. | `` |
staging_player_shoot_type_summary
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
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 | Queried player identifier. | `` |
season_year | String | No | Queried season year. | `` |
season_type | String | No | Queried season type. | `` |
staging_schedule_league_v2
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
game_date | String | No | Date of the game | ScheduleLeagueV2.ScheduleLeagueV2.GAME_DATE |
game_id | String | No | Unique game identifier | ScheduleLeagueV2.ScheduleLeagueV2.GAME_ID |
game_code | String | Yes | Game code string | ScheduleLeagueV2.ScheduleLeagueV2.GAME_CODE |
game_status | Int64 | Yes | Game status code | ScheduleLeagueV2.ScheduleLeagueV2.GAME_STATUS |
game_status_text | String | Yes | Game status display text | ScheduleLeagueV2.ScheduleLeagueV2.GAME_STATUS_TEXT |
game_sequence | Int64 | Yes | Game sequence number for the day | ScheduleLeagueV2.ScheduleLeagueV2.GAME_SEQUENCE |
game_date_est | String | Yes | Game date in Eastern time | ScheduleLeagueV2.ScheduleLeagueV2.GAME_DATE_EST |
game_time_est | String | Yes | Game time in Eastern time | ScheduleLeagueV2.ScheduleLeagueV2.GAME_TIME_EST |
game_date_time_est | String | Yes | Game date and time in Eastern time | ScheduleLeagueV2.ScheduleLeagueV2.GAME_DATE_TIME_EST |
game_date_utc | String | Yes | Game date in UTC | ScheduleLeagueV2.ScheduleLeagueV2.GAME_DATE_UTC |
game_time_utc | String | Yes | Game time in UTC | ScheduleLeagueV2.ScheduleLeagueV2.GAME_TIME_UTC |
game_date_time_utc | String | Yes | Game date and time in UTC | ScheduleLeagueV2.ScheduleLeagueV2.GAME_DATE_TIME_UTC |
away_team_id | Int64 | Yes | Away team identifier (FK → staging_team.team_id) | ScheduleLeagueV2.ScheduleLeagueV2.AWAY_TEAM_ID |
away_team_name | String | Yes | Away team name | ScheduleLeagueV2.ScheduleLeagueV2.AWAY_TEAM_NAME |
away_team_city | String | Yes | Away team city | ScheduleLeagueV2.ScheduleLeagueV2.AWAY_TEAM_CITY |
away_team_tricode | String | Yes | Away team three-letter code | ScheduleLeagueV2.ScheduleLeagueV2.AWAY_TEAM_TRICODE |
away_team_slug | String | Yes | Away team URL slug | ScheduleLeagueV2.ScheduleLeagueV2.AWAY_TEAM_SLUG |
away_team_wins | Int64 | Yes | Away team win count | ScheduleLeagueV2.ScheduleLeagueV2.AWAY_TEAM_WINS |
away_team_losses | Int64 | Yes | Away team loss count | ScheduleLeagueV2.ScheduleLeagueV2.AWAY_TEAM_LOSSES |
away_team_score | Int64 | Yes | Away team score | ScheduleLeagueV2.ScheduleLeagueV2.AWAY_TEAM_SCORE |
home_team_id | Int64 | Yes | Home team identifier (FK → staging_team.team_id) | ScheduleLeagueV2.ScheduleLeagueV2.HOME_TEAM_ID |
home_team_name | String | Yes | Home team name | ScheduleLeagueV2.ScheduleLeagueV2.HOME_TEAM_NAME |
home_team_city | String | Yes | Home team city | ScheduleLeagueV2.ScheduleLeagueV2.HOME_TEAM_CITY |
home_team_tricode | String | Yes | Home team three-letter code | ScheduleLeagueV2.ScheduleLeagueV2.HOME_TEAM_TRICODE |
home_team_slug | String | Yes | Home team URL slug | ScheduleLeagueV2.ScheduleLeagueV2.HOME_TEAM_SLUG |
home_team_wins | Int64 | Yes | Home team win count | ScheduleLeagueV2.ScheduleLeagueV2.HOME_TEAM_WINS |
home_team_losses | Int64 | Yes | Home team loss count | ScheduleLeagueV2.ScheduleLeagueV2.HOME_TEAM_LOSSES |
home_team_score | Int64 | Yes | Home team score | ScheduleLeagueV2.ScheduleLeagueV2.HOME_TEAM_SCORE |
arena_name | String | Yes | Arena name | ScheduleLeagueV2.ScheduleLeagueV2.ARENA_NAME |
arena_city | String | Yes | Arena city | ScheduleLeagueV2.ScheduleLeagueV2.ARENA_CITY |
arena_state | String | Yes | Arena state | ScheduleLeagueV2.ScheduleLeagueV2.ARENA_STATE |
postponed_status | String | Yes | Postponement status | ScheduleLeagueV2.ScheduleLeagueV2.POSTPONED_STATUS |
branch_link | String | Yes | Branch deep link URL | ScheduleLeagueV2.ScheduleLeagueV2.BRANCH_LINK |
game_subtype | String | Yes | Game subtype classification | ScheduleLeagueV2.ScheduleLeagueV2.GAME_SUBTYPE |
series_conference | String | Yes | Playoff series conference | ScheduleLeagueV2.ScheduleLeagueV2.SERIES_CONFERENCE |
series_text | String | Yes | Playoff series status text | ScheduleLeagueV2.ScheduleLeagueV2.SERIES_TEXT |
if_necessary | String | Yes | If-necessary game indicator | ScheduleLeagueV2.ScheduleLeagueV2.IF_NECESSARY |
series_game_number | String | Yes | Game number in playoff series | ScheduleLeagueV2.ScheduleLeagueV2.SERIES_GAME_NUMBER |
staging_scoreboard_v2
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
game_date_est | String | No | Game date in Eastern time | ScoreboardV2.GameHeader.GAME_DATE_EST |
game_sequence | Int64 | Yes | Game sequence number for the day | ScoreboardV2.GameHeader.GAME_SEQUENCE |
game_id | String | No | Unique game identifier | ScoreboardV2.GameHeader.GAME_ID |
game_status_id | Int64 | Yes | Game status identifier | ScoreboardV2.GameHeader.GAME_STATUS_ID |
game_status_text | String | Yes | Game status display text | ScoreboardV2.GameHeader.GAME_STATUS_TEXT |
gamecode | String | Yes | Game code string | ScoreboardV2.GameHeader.GAMECODE |
home_team_id | Int64 | Yes | Home team identifier (FK → staging_team.team_id) | ScoreboardV2.GameHeader.HOME_TEAM_ID |
visitor_team_id | Int64 | Yes | Visitor team identifier (FK → staging_team.team_id) | ScoreboardV2.GameHeader.VISITOR_TEAM_ID |
season | String | Yes | Season year string | ScoreboardV2.GameHeader.SEASON |
live_period | Int64 | Yes | Current live period | ScoreboardV2.GameHeader.LIVE_PERIOD |
live_pc_time | String | Yes | Live game clock time | ScoreboardV2.GameHeader.LIVE_PC_TIME |
natl_tv_broadcaster_abbreviation | String | Yes | National TV broadcaster abbreviation | ScoreboardV2.GameHeader.NATL_TV_BROADCASTER_ABBREVIATION |
home_tv_broadcaster_abbreviation | String | Yes | Home TV broadcaster abbreviation | ScoreboardV2.GameHeader.HOME_TV_BROADCASTER_ABBREVIATION |
away_tv_broadcaster_abbreviation | String | Yes | Away TV broadcaster abbreviation | ScoreboardV2.GameHeader.AWAY_TV_BROADCASTER_ABBREVIATION |
live_period_time_bcast | String | Yes | Live period time broadcast string | ScoreboardV2.GameHeader.LIVE_PERIOD_TIME_BCAST |
arena_name | String | Yes | Arena name | ScoreboardV2.GameHeader.ARENA_NAME |
wh_status | Int64 | Yes | Wagering hub status flag | ScoreboardV2.GameHeader.WH_STATUS |
staging_shot_chart_detail
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
grid_type | String | Yes | Shot chart grid type | ShotChartDetail.Shot_Chart_Detail.GRID_TYPE |
game_id | String | No | Unique game identifier | ShotChartDetail.Shot_Chart_Detail.GAME_ID |
game_event_id | Int64 | Yes | Event identifier within game | ShotChartDetail.Shot_Chart_Detail.GAME_EVENT_ID |
player_id | Int64 | No | Unique player identifier (FK → staging_player.person_id) | ShotChartDetail.Shot_Chart_Detail.PLAYER_ID |
player_name | String | Yes | Player full name | ShotChartDetail.Shot_Chart_Detail.PLAYER_NAME |
team_id | Int64 | Yes | Team identifier (FK → staging_team.team_id) | ShotChartDetail.Shot_Chart_Detail.TEAM_ID |
team_name | String | Yes | Team name | ShotChartDetail.Shot_Chart_Detail.TEAM_NAME |
period | Int64 | Yes | Game period number | ShotChartDetail.Shot_Chart_Detail.PERIOD |
minutes_remaining | Int64 | Yes | Minutes remaining in period | ShotChartDetail.Shot_Chart_Detail.MINUTES_REMAINING |
seconds_remaining | Int64 | Yes | Seconds remaining in period | ShotChartDetail.Shot_Chart_Detail.SECONDS_REMAINING |
event_type | String | Yes | Shot event type (Made/Missed) | ShotChartDetail.Shot_Chart_Detail.EVENT_TYPE |
action_type | String | Yes | Specific shot action type | ShotChartDetail.Shot_Chart_Detail.ACTION_TYPE |
shot_type | String | Yes | Shot type (2PT/3PT Field Goal) | ShotChartDetail.Shot_Chart_Detail.SHOT_TYPE |
shot_zone_basic | String | Yes | Basic shot zone category | ShotChartDetail.Shot_Chart_Detail.SHOT_ZONE_BASIC |
shot_zone_area | String | Yes | Shot zone area on court | ShotChartDetail.Shot_Chart_Detail.SHOT_ZONE_AREA |
shot_zone_range | String | Yes | Shot distance range bucket | ShotChartDetail.Shot_Chart_Detail.SHOT_ZONE_RANGE |
shot_distance | Int64 | Yes | Shot distance in feet | ShotChartDetail.Shot_Chart_Detail.SHOT_DISTANCE |
loc_x | Int64 | Yes | Shot X coordinate on court | ShotChartDetail.Shot_Chart_Detail.LOC_X |
loc_y | Int64 | Yes | Shot Y coordinate on court | ShotChartDetail.Shot_Chart_Detail.LOC_Y |
shot_attempted_flag | Int64 | Yes | Flag indicating shot was attempted | ShotChartDetail.Shot_Chart_Detail.SHOT_ATTEMPTED_FLAG |
shot_made_flag | Int64 | Yes | Flag indicating shot was made | ShotChartDetail.Shot_Chart_Detail.SHOT_MADE_FLAG |
game_date | String | Yes | Date of the game | ShotChartDetail.Shot_Chart_Detail.GAME_DATE |
htm | String | Yes | Home team abbreviation | ShotChartDetail.Shot_Chart_Detail.HTM |
vtm | String | Yes | Visitor team abbreviation | ShotChartDetail.Shot_Chart_Detail.VTM |
staging_synergy_play_types
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
season_id | String | No | NBA season identifier | SynergyPlayTypes.SynergyPlayType.SEASON_ID |
team_id | Int64 | Yes | Team identifier (FK → staging_team.team_id) | SynergyPlayTypes.SynergyPlayType.TEAM_ID |
team_abbreviation | String | Yes | Team abbreviation code | SynergyPlayTypes.SynergyPlayType.TEAM_ABBREVIATION |
team_name | String | Yes | Team name | SynergyPlayTypes.SynergyPlayType.TEAM_NAME |
player_id | Int64 | Yes | Unique player identifier (FK → staging_player.person_id) | SynergyPlayTypes.SynergyPlayType.PLAYER_ID |
player_name | String | Yes | Player full name | SynergyPlayTypes.SynergyPlayType.PLAYER_NAME |
play_type | String | No | Synergy play type classification | SynergyPlayTypes.SynergyPlayType.PLAY_TYPE |
type_grouping | String | No | Offensive or defensive grouping | SynergyPlayTypes.SynergyPlayType.TYPE_GROUPING |
percentile | Float64 | Yes | Percentile rank for play type | SynergyPlayTypes.SynergyPlayType.PERCENTILE |
gp | Int64 | Yes | Games played | SynergyPlayTypes.SynergyPlayType.GP |
poss_pct | Float64 | Yes | Percentage of possessions | SynergyPlayTypes.SynergyPlayType.POSS_PCT |
ppp | Float64 | Yes | Points per possession | SynergyPlayTypes.SynergyPlayType.PPP |
fg_pct | Float64 | Yes | Field goal percentage | SynergyPlayTypes.SynergyPlayType.FG_PCT |
ft_pct_adjust | Float64 | Yes | Free throw percentage adjusted | SynergyPlayTypes.SynergyPlayType.FT_PCT_ADJUST |
to_pct | Float64 | Yes | Turnover percentage | SynergyPlayTypes.SynergyPlayType.TO_PCT |
sf_pct | Float64 | Yes | Shooting foul percentage | SynergyPlayTypes.SynergyPlayType.SF_PCT |
plusone_pct | Float64 | Yes | And-one conversion percentage | SynergyPlayTypes.SynergyPlayType.PLUSONE_PCT |
score_pct | Float64 | Yes | Scoring percentage | SynergyPlayTypes.SynergyPlayType.SCORE_PCT |
efg_pct | Float64 | Yes | Effective field goal percentage | SynergyPlayTypes.SynergyPlayType.EFG_PCT |
poss | Int64 | Yes | Total possessions | SynergyPlayTypes.SynergyPlayType.POSS |
pts | Float64 | Yes | Total points scored | SynergyPlayTypes.SynergyPlayType.PTS |
fgm | Int64 | Yes | Field goals made | SynergyPlayTypes.SynergyPlayType.FGM |
fga | Int64 | Yes | Field goals attempted | SynergyPlayTypes.SynergyPlayType.FGA |
fgmx | Int64 | Yes | Field goals missed | SynergyPlayTypes.SynergyPlayType.FGMX |
staging_team_details
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
team_id | Int64 | No | Unique team identifier | TeamDetails.TeamBackground.TEAM_ID |
abbreviation | String | No | Team abbreviation code | TeamDetails.TeamBackground.ABBREVIATION |
nickname | String | No | Team nickname | TeamDetails.TeamBackground.NICKNAME |
yearfounded | Int64 | Yes | Year the team was founded | TeamDetails.TeamBackground.YEARFOUNDED |
city | String | Yes | Team city name | TeamDetails.TeamBackground.CITY |
arena | String | Yes | Home arena name | TeamDetails.TeamBackground.ARENA |
arenacapacity | Int64 | Yes | Arena seating capacity | TeamDetails.TeamBackground.ARENACAPACITY |
owner | String | Yes | Team owner name | TeamDetails.TeamBackground.OWNER |
generalmanager | String | Yes | General manager name | TeamDetails.TeamBackground.GENERALMANAGER |
headcoach | String | Yes | Head coach name | TeamDetails.TeamBackground.HEADCOACH |
dleagueaffiliation | String | Yes | G-League affiliate team name | TeamDetails.TeamBackground.DLEAGUEAFFILIATION |
staging_team_game_log
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
season_id | String | No | Season identifier | TeamGameLog.TeamGameLog.SEASON_ID |
team_id | Int64 | No | Unique team identifier (FK → staging_team.team_id) | TeamGameLog.TeamGameLog.TEAM_ID |
team_abbreviation | String | No | Team abbreviation code | TeamGameLog.TeamGameLog.TEAM_ABBREVIATION |
team_name | String | No | Team name | TeamGameLog.TeamGameLog.TEAM_NAME |
game_id | String | No | Unique game identifier | TeamGameLog.TeamGameLog.GAME_ID |
game_date | String | No | Date of the game | TeamGameLog.TeamGameLog.GAME_DATE |
matchup | String | No | Matchup string (e.g. LAL vs. BOS) | TeamGameLog.TeamGameLog.MATCHUP |
wl | String | Yes | Win or loss indicator | TeamGameLog.TeamGameLog.WL |
w | Int64 | Yes | Wins | TeamGameLog.TeamGameLog.W |
l | Int64 | Yes | Losses | TeamGameLog.TeamGameLog.L |
w_pct | Float64 | Yes | Win percentage | TeamGameLog.TeamGameLog.W_PCT |
min | Float64 | Yes | Minutes played | TeamGameLog.TeamGameLog.MIN |
fgm | Float64 | Yes | Field goals made | TeamGameLog.TeamGameLog.FGM |
fga | Float64 | Yes | Field goals attempted | TeamGameLog.TeamGameLog.FGA |
fg_pct | Float64 | Yes | Field goal percentage | TeamGameLog.TeamGameLog.FG_PCT |
fg3m | Float64 | Yes | Three-point field goals made | TeamGameLog.TeamGameLog.FG3M |
fg3a | Float64 | Yes | Three-point field goals attempted | TeamGameLog.TeamGameLog.FG3A |
fg3_pct | Float64 | Yes | Three-point field goal percentage | TeamGameLog.TeamGameLog.FG3_PCT |
ftm | Float64 | Yes | Free throws made | TeamGameLog.TeamGameLog.FTM |
fta | Float64 | Yes | Free throws attempted | TeamGameLog.TeamGameLog.FTA |
ft_pct | Float64 | Yes | Free throw percentage | TeamGameLog.TeamGameLog.FT_PCT |
oreb | Float64 | Yes | Offensive rebounds | TeamGameLog.TeamGameLog.OREB |
dreb | Float64 | Yes | Defensive rebounds | TeamGameLog.TeamGameLog.DREB |
reb | Float64 | Yes | Total rebounds | TeamGameLog.TeamGameLog.REB |
ast | Float64 | Yes | Assists | TeamGameLog.TeamGameLog.AST |
stl | Float64 | Yes | Steals | TeamGameLog.TeamGameLog.STL |
blk | Float64 | Yes | Blocks | TeamGameLog.TeamGameLog.BLK |
tov | Float64 | Yes | Turnovers | TeamGameLog.TeamGameLog.TOV |
pf | Float64 | Yes | Personal fouls | TeamGameLog.TeamGameLog.PF |
pts | Float64 | Yes | Points scored | TeamGameLog.TeamGameLog.PTS |
plus_minus | Float64 | Yes | Plus-minus differential | TeamGameLog.TeamGameLog.PLUS_MINUS |
video_available | Int64 | Yes | Video availability flag | TeamGameLog.TeamGameLog.VIDEO_AVAILABLE |
staging_team_info_common
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
team_id | Int64 | No | Unique team identifier | TeamInfoCommon.TeamInfoCommon.TEAM_ID |
season_year | String | Yes | Season year string | TeamInfoCommon.TeamInfoCommon.SEASON_YEAR |
team_city | String | Yes | Team city name | TeamInfoCommon.TeamInfoCommon.TEAM_CITY |
team_name | String | No | Team name | TeamInfoCommon.TeamInfoCommon.TEAM_NAME |
team_abbreviation | String | No | Team abbreviation code | TeamInfoCommon.TeamInfoCommon.TEAM_ABBREVIATION |
team_conference | String | Yes | Conference name | TeamInfoCommon.TeamInfoCommon.TEAM_CONFERENCE |
team_division | String | Yes | Division name | TeamInfoCommon.TeamInfoCommon.TEAM_DIVISION |
team_code | String | Yes | Team code slug | TeamInfoCommon.TeamInfoCommon.TEAM_CODE |
team_slug | String | Yes | URL-friendly team slug | TeamInfoCommon.TeamInfoCommon.TEAM_SLUG |
w | Int64 | Yes | Wins | TeamInfoCommon.TeamInfoCommon.W |
l | Int64 | Yes | Losses | TeamInfoCommon.TeamInfoCommon.L |
pct | Float64 | Yes | Win percentage | TeamInfoCommon.TeamInfoCommon.PCT |
conf_rank | Int64 | Yes | Conference ranking | TeamInfoCommon.TeamInfoCommon.CONF_RANK |
div_rank | Int64 | Yes | Division ranking | TeamInfoCommon.TeamInfoCommon.DIV_RANK |
min_year | String | Yes | First year of team activity | TeamInfoCommon.TeamInfoCommon.MIN_YEAR |
max_year | String | Yes | Last year of team activity | TeamInfoCommon.TeamInfoCommon.MAX_YEAR |
staging_win_probability
| Column | Type | Nullable | Description | Source |
|---|---|---|---|---|
game_id | String | No | Unique game identifier | WinProbabilityPBP.WinProbPBP.GAME_ID |
event_num | Int64 | No | Event sequence number | WinProbabilityPBP.WinProbPBP.EVENT_NUM |
home_pct | Float64 | Yes | Home team win probability | WinProbabilityPBP.WinProbPBP.HOME_PCT |
visitor_pct | Float64 | Yes | Visitor team win probability | WinProbabilityPBP.WinProbPBP.VISITOR_PCT |
home_pts | Int64 | Yes | Home team points | WinProbabilityPBP.WinProbPBP.HOME_PTS |
visitor_pts | Int64 | Yes | Visitor team points | WinProbabilityPBP.WinProbPBP.VISITOR_PTS |
home_score_margin | Int64 | Yes | Home team score margin | WinProbabilityPBP.WinProbPBP.HOME_SCORE_MARGIN |
period | Int64 | Yes | Game period number | WinProbabilityPBP.WinProbPBP.PERIOD |
seconds_remaining | Float64 | Yes | Seconds remaining in period | WinProbabilityPBP.WinProbPBP.SECONDS_REMAINING |
home_team_id | Int64 | Yes | Home team identifier (FK → staging_team.team_id) | WinProbabilityPBP.WinProbPBP.HOME_TEAM_ID |
home_team_abb | String | Yes | Home team abbreviation code | WinProbabilityPBP.WinProbPBP.HOME_TEAM_ABB |
visitor_team_id | Int64 | Yes | Visitor team identifier (FK → staging_team.team_id) | WinProbabilityPBP.WinProbPBP.VISITOR_TEAM_ID |
visitor_team_abb | String | Yes | Visitor team abbreviation code | WinProbabilityPBP.WinProbPBP.VISITOR_TEAM_ABB |
description | String | Yes | Text description of the play | WinProbabilityPBP.WinProbPBP.DESCRIPTION |
location | String | Yes | Home or away location indicator | WinProbabilityPBP.WinProbPBP.LOCATION |
pctimestring | String | Yes | Period clock time string | WinProbabilityPBP.WinProbPBP.PCTIMESTRING |
is_score_change | Int64 | Yes | Flag indicating if score changed | WinProbabilityPBP.WinProbPBP.IS_SCORE_CHANGE |
Companion cuts
Turn cleaned field names into SQL decisions
These companion pages turn staging inventories into practical naming, join, and dependency guidance.
Decode staging naming habits
Use the naming guide when the cleaned column is clearer than raw, but still needs interpretation.
Turn staging keys into relationship plans
Move from renamed identifiers to the actual join lanes used in warehouse reads.
Trace downstream tables before you change anything
Check impact radius when a staging field or table might feed multiple facts, dimensions, or aggregates.
Next possession
Use staging names as the translation layer
Staging fields are where raw payloads start sounding like a warehouse. These next stops help you decode normalized names, trace upstream sources, and turn cleaned columns into join decisions.
Field Reference
Translate staging naming habits into semantic meaning before reading transform code.
Relationships
Use the cleaned keys and renamed columns to plan safe star-schema joins.
Table Lineage
Trace where a staging field comes from and which downstream outputs inherit it.