nbadbArena Data Lab
Data DictionaryScoreboard KeyStaging44 waypoints

Stat Legend

Data Dictionary — Staging

Field-level documentation for all staging schema tables

Generated pageCommand-ownedSchema metadata

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.

Best for
Normalization checks

confirm how raw fields were cleaned up for staging and load

Best signal
Join-ready keys

staging names, foreign keys, and cleaned types usually get clearer here

Ownership
Command-owned

regenerate from schema metadata instead of hand-editing

How to work this page
1

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.

2

Watch the cleaned keys and types

Staging is where foreign-key hints, renamed identifiers, and typed columns start becoming useful for SQL.

3

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.

43 table blocks26 Staging familiesTOC-driven
League Dash

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

2
Play By

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

2
Player Shoot

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

2
Arena Info

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

1
Common All

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

1
Common Team

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

1
Draft Combine

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

1
Draft History

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

1
Game Leaders

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

1
Game Rotation

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

1
League Game

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

1
League Lineup

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

1
League Standings

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

1
Player Game

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

1
Player Index

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

1
Player Perf

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

1
Schedule League

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

1
Scoreboard V2

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

1
Shot Chart

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

1
Synergy Play

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

1
Team Details

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

1
Team Game

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

1
Team Info

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

1
Win Probability

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

1

Data Dictionary — Staging

staging_arena_info

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreSummaryV3.ArenaInfo.gameId
arena_idInt64YesArena identifierBoxScoreSummaryV3.ArenaInfo.arenaId
arena_nameStringYesArena nameBoxScoreSummaryV3.ArenaInfo.arenaName
arena_cityStringYesArena cityBoxScoreSummaryV3.ArenaInfo.arenaCity
arena_stateStringYesArena state or provinceBoxScoreSummaryV3.ArenaInfo.arenaState
arena_countryStringYesArena countryBoxScoreSummaryV3.ArenaInfo.arenaCountry
arena_timezoneStringYesArena timezoneBoxScoreSummaryV3.ArenaInfo.arenaTimezone

staging_box_score_advanced_player

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreAdvancedV3.PlayerStats.GAME_ID
team_idInt64NoTeam identifier (FK → staging_team.team_id)BoxScoreAdvancedV3.PlayerStats.TEAM_ID
player_idInt64NoUnique player identifier (FK → staging_player.person_id)BoxScoreAdvancedV3.PlayerStats.PLAYER_ID
player_nameStringYesPlayer full nameBoxScoreAdvancedV3.PlayerStats.PLAYER_NAME
minStringYesMinutes played as stringBoxScoreAdvancedV3.PlayerStats.MIN
e_off_ratingFloat64YesEstimated offensive ratingBoxScoreAdvancedV3.PlayerStats.E_OFF_RATING
off_ratingFloat64YesOffensive ratingBoxScoreAdvancedV3.PlayerStats.OFF_RATING
e_def_ratingFloat64YesEstimated defensive ratingBoxScoreAdvancedV3.PlayerStats.E_DEF_RATING
def_ratingFloat64YesDefensive ratingBoxScoreAdvancedV3.PlayerStats.DEF_RATING
e_net_ratingFloat64YesEstimated net ratingBoxScoreAdvancedV3.PlayerStats.E_NET_RATING
net_ratingFloat64YesNet ratingBoxScoreAdvancedV3.PlayerStats.NET_RATING
ast_pctFloat64YesAssist percentageBoxScoreAdvancedV3.PlayerStats.AST_PCT
ast_tovFloat64YesAssist to turnover ratioBoxScoreAdvancedV3.PlayerStats.AST_TOV
ast_ratioFloat64YesAssist ratioBoxScoreAdvancedV3.PlayerStats.AST_RATIO
oreb_pctFloat64YesOffensive rebound percentageBoxScoreAdvancedV3.PlayerStats.OREB_PCT
dreb_pctFloat64YesDefensive rebound percentageBoxScoreAdvancedV3.PlayerStats.DREB_PCT
reb_pctFloat64YesTotal rebound percentageBoxScoreAdvancedV3.PlayerStats.REB_PCT
tov_pctFloat64YesTurnover percentageBoxScoreAdvancedV3.PlayerStats.TOV_PCT
efg_pctFloat64YesEffective field goal percentageBoxScoreAdvancedV3.PlayerStats.EFG_PCT
ts_pctFloat64YesTrue shooting percentageBoxScoreAdvancedV3.PlayerStats.TS_PCT
usg_pctFloat64YesUsage percentageBoxScoreAdvancedV3.PlayerStats.USG_PCT
e_usg_pctFloat64YesEstimated usage percentageBoxScoreAdvancedV3.PlayerStats.E_USG_PCT
e_paceFloat64YesEstimated paceBoxScoreAdvancedV3.PlayerStats.E_PACE
paceFloat64YesPace factorBoxScoreAdvancedV3.PlayerStats.PACE
pace_per40Float64YesPace per 40 minutesBoxScoreAdvancedV3.PlayerStats.PACE_PER40
possFloat64YesPossessionsBoxScoreAdvancedV3.PlayerStats.POSS
pieFloat64YesPlayer impact estimateBoxScoreAdvancedV3.PlayerStats.PIE

staging_box_score_defensive_player

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreDefensiveV2.PlayerStats.GAME_ID
team_idInt64NoTeam identifier (FK → staging_team.team_id)BoxScoreDefensiveV2.PlayerStats.TEAM_ID
player_idInt64NoUnique player identifier (FK → staging_player.person_id)BoxScoreDefensiveV2.PlayerStats.PLAYER_ID
player_nameStringYesPlayer full nameBoxScoreDefensiveV2.PlayerStats.PLAYER_NAME
minStringYesMinutes played as stringBoxScoreDefensiveV2.PlayerStats.MIN
matchup_minFloat64YesMinutes in matchup defenseBoxScoreDefensiveV2.PlayerStats.MATCHUP_MIN
partial_possFloat64YesPartial possessions defendedBoxScoreDefensiveV2.PlayerStats.PARTIAL_POSS
switches_onFloat64YesNumber of defensive switchesBoxScoreDefensiveV2.PlayerStats.SWITCHES_ON
player_ptsFloat64YesPoints allowed on defenseBoxScoreDefensiveV2.PlayerStats.PLAYER_PTS
def_fgmFloat64YesDefended field goals madeBoxScoreDefensiveV2.PlayerStats.DEF_FGM
def_fgaFloat64YesDefended field goals attemptedBoxScoreDefensiveV2.PlayerStats.DEF_FGA
def_fg_pctFloat64YesDefended field goal percentageBoxScoreDefensiveV2.PlayerStats.DEF_FG_PCT

staging_box_score_four_factors_player

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreFourFactorsV3.PlayerStats.GAME_ID
team_idInt64NoTeam identifier (FK → staging_team.team_id)BoxScoreFourFactorsV3.PlayerStats.TEAM_ID
player_idInt64NoUnique player identifier (FK → staging_player.person_id)BoxScoreFourFactorsV3.PlayerStats.PLAYER_ID
player_nameStringYesPlayer full nameBoxScoreFourFactorsV3.PlayerStats.PLAYER_NAME
minStringYesMinutes played as stringBoxScoreFourFactorsV3.PlayerStats.MIN
effective_field_goal_percentageFloat64YesEffective field goal percentageBoxScoreFourFactorsV3.PlayerStats.EFG_PCT
free_throw_attempt_rateFloat64YesFree throw attempt rateBoxScoreFourFactorsV3.PlayerStats.FTA_RATE
team_turnover_percentageFloat64YesTeam turnover percentageBoxScoreFourFactorsV3.PlayerStats.TM_TOV_PCT
offensive_rebound_percentageFloat64YesOffensive rebound percentageBoxScoreFourFactorsV3.PlayerStats.OREB_PCT
opp_effective_field_goal_percentageFloat64YesOpponent effective field goal percentageBoxScoreFourFactorsV3.PlayerStats.OPP_EFG_PCT
opp_free_throw_attempt_rateFloat64YesOpponent free throw attempt rateBoxScoreFourFactorsV3.PlayerStats.OPP_FTA_RATE
opp_team_turnover_percentageFloat64YesOpponent team turnover percentageBoxScoreFourFactorsV3.PlayerStats.OPP_TOV_PCT
opp_offensive_rebound_percentageFloat64YesOpponent offensive rebound percentageBoxScoreFourFactorsV3.PlayerStats.OPP_OREB_PCT

staging_box_score_four_factors_team

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreFourFactorsV3.TeamStats.GAME_ID
team_idInt64NoTeam identifier (FK → staging_team.team_id)BoxScoreFourFactorsV3.TeamStats.TEAM_ID
team_nameStringYesTeam nameBoxScoreFourFactorsV3.TeamStats.TEAM_NAME
team_abbreviationStringYesTeam abbreviation codeBoxScoreFourFactorsV3.TeamStats.TEAM_ABBREVIATION
effective_field_goal_percentageFloat64YesEffective field goal percentageBoxScoreFourFactorsV3.TeamStats.EFG_PCT
free_throw_attempt_rateFloat64YesFree throw attempt rateBoxScoreFourFactorsV3.TeamStats.FTA_RATE
team_turnover_percentageFloat64YesTeam turnover percentageBoxScoreFourFactorsV3.TeamStats.TM_TOV_PCT
offensive_rebound_percentageFloat64YesOffensive rebound percentageBoxScoreFourFactorsV3.TeamStats.OREB_PCT
opp_effective_field_goal_percentageFloat64YesOpponent effective field goal percentageBoxScoreFourFactorsV3.TeamStats.OPP_EFG_PCT
opp_free_throw_attempt_rateFloat64YesOpponent free throw attempt rateBoxScoreFourFactorsV3.TeamStats.OPP_FTA_RATE
opp_team_turnover_percentageFloat64YesOpponent team turnover percentageBoxScoreFourFactorsV3.TeamStats.OPP_TOV_PCT
opp_offensive_rebound_percentageFloat64YesOpponent offensive rebound percentageBoxScoreFourFactorsV3.TeamStats.OPP_OREB_PCT

staging_box_score_hustle_player

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreHustleV2.PlayerStats.GAME_ID
team_idInt64NoTeam identifier (FK → staging_team.team_id)BoxScoreHustleV2.PlayerStats.TEAM_ID
player_idInt64NoUnique player identifier (FK → staging_player.person_id)BoxScoreHustleV2.PlayerStats.PLAYER_ID
player_nameStringYesPlayer full nameBoxScoreHustleV2.PlayerStats.PLAYER_NAME
minStringYesMinutes played as stringBoxScoreHustleV2.PlayerStats.MIN
contested_shotsFloat64YesContested shotsBoxScoreHustleV2.PlayerStats.CONTESTED_SHOTS
contested_shots_2ptFloat64YesContested two-point shotsBoxScoreHustleV2.PlayerStats.CONTESTED_SHOTS_2PT
contested_shots_3ptFloat64YesContested three-point shotsBoxScoreHustleV2.PlayerStats.CONTESTED_SHOTS_3PT
deflectionsFloat64YesDeflectionsBoxScoreHustleV2.PlayerStats.DEFLECTIONS
charges_drawnFloat64YesCharges drawnBoxScoreHustleV2.PlayerStats.CHARGES_DRAWN
screen_assistsFloat64YesScreen assistsBoxScoreHustleV2.PlayerStats.SCREEN_ASSISTS
screen_ast_ptsFloat64YesPoints from screen assistsBoxScoreHustleV2.PlayerStats.SCREEN_AST_PTS
loose_balls_recoveredFloat64YesLoose balls recoveredBoxScoreHustleV2.PlayerStats.LOOSE_BALLS_RECOVERED
box_outsFloat64YesBox outsBoxScoreHustleV2.PlayerStats.BOX_OUTS

staging_box_score_matchups

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifier (FK → staging_game_log.game_id)BoxScoreMatchupsV3.PlayerStats.GAME_ID
off_team_idInt64YesOffensive team identifier (FK → staging_team.team_id)BoxScoreMatchupsV3.PlayerStats.OFF_TEAM_ID
off_team_abbreviationStringYesOffensive team abbreviationBoxScoreMatchupsV3.PlayerStats.OFF_TEAM_ABBREVIATION
def_team_idInt64YesDefensive team identifier (FK → staging_team.team_id)BoxScoreMatchupsV3.PlayerStats.DEF_TEAM_ID
def_team_abbreviationStringYesDefensive team abbreviationBoxScoreMatchupsV3.PlayerStats.DEF_TEAM_ABBREVIATION
off_player_idInt64YesOffensive player identifier (FK → staging_player.person_id)BoxScoreMatchupsV3.PlayerStats.OFF_PLAYER_ID
off_player_nameStringYesOffensive player nameBoxScoreMatchupsV3.PlayerStats.OFF_PLAYER_NAME
def_player_idInt64YesDefensive player identifier (FK → staging_player.person_id)BoxScoreMatchupsV3.PlayerStats.DEF_PLAYER_ID
def_player_nameStringYesDefensive player nameBoxScoreMatchupsV3.PlayerStats.DEF_PLAYER_NAME
matchup_minFloat64YesMinutes in matchupBoxScoreMatchupsV3.PlayerStats.MATCHUP_MIN
partial_possFloat64YesPartial possessions in matchupBoxScoreMatchupsV3.PlayerStats.PARTIAL_POSS
player_ptsFloat64YesPlayer points in matchupBoxScoreMatchupsV3.PlayerStats.PLAYER_PTS
team_ptsFloat64YesTeam points in matchupBoxScoreMatchupsV3.PlayerStats.TEAM_PTS
matchup_astFloat64YesAssists in matchupBoxScoreMatchupsV3.PlayerStats.MATCHUP_AST
matchup_tovFloat64YesTurnovers in matchupBoxScoreMatchupsV3.PlayerStats.MATCHUP_TOV
matchup_blkFloat64YesBlocks in matchupBoxScoreMatchupsV3.PlayerStats.MATCHUP_BLK
matchup_fgmFloat64YesField goals made in matchupBoxScoreMatchupsV3.PlayerStats.MATCHUP_FGM
matchup_fgaFloat64YesField goals attemptedBoxScoreMatchupsV3.PlayerStats.MATCHUP_FGA
matchup_fg_pctFloat64YesField goal pct in matchupBoxScoreMatchupsV3.PlayerStats.MATCHUP_FG_PCT
matchup_fg3mFloat64YesThree-pointers madeBoxScoreMatchupsV3.PlayerStats.MATCHUP_FG3M
matchup_fg3aFloat64YesThree-pointers attemptedBoxScoreMatchupsV3.PlayerStats.MATCHUP_FG3A
matchup_fg3_pctFloat64YesThree-point pct in matchupBoxScoreMatchupsV3.PlayerStats.MATCHUP_FG3_PCT
help_blkFloat64YesHelp blocks in matchupBoxScoreMatchupsV3.PlayerStats.HELP_BLK
help_fgmFloat64YesHelp field goals madeBoxScoreMatchupsV3.PlayerStats.HELP_FGM
help_fgaFloat64YesHelp field goals attemptedBoxScoreMatchupsV3.PlayerStats.HELP_FGA
help_fg_pctFloat64YesHelp field goal percentageBoxScoreMatchupsV3.PlayerStats.HELP_FG_PCT
matchup_ftmFloat64YesFree throws made in matchupBoxScoreMatchupsV3.PlayerStats.MATCHUP_FTM
matchup_ftaFloat64YesFree throws attemptedBoxScoreMatchupsV3.PlayerStats.MATCHUP_FTA
switches_onFloat64YesSwitches onto playerBoxScoreMatchupsV3.PlayerStats.SWITCHES_ON

staging_box_score_player_track

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScorePlayerTrackV3.PlayerStats.GAME_ID
team_idInt64NoTeam identifier (FK → staging_team.team_id)BoxScorePlayerTrackV3.PlayerStats.TEAM_ID
player_idInt64NoUnique player identifier (FK → staging_player.person_id)BoxScorePlayerTrackV3.PlayerStats.PLAYER_ID
player_nameStringYesPlayer full nameBoxScorePlayerTrackV3.PlayerStats.PLAYER_NAME
minStringYesMinutes played as stringBoxScorePlayerTrackV3.PlayerStats.MIN
spdFloat64YesAverage speed in mphBoxScorePlayerTrackV3.PlayerStats.SPD
distFloat64YesDistance covered in milesBoxScorePlayerTrackV3.PlayerStats.DIST
orbcFloat64YesOffensive rebound chancesBoxScorePlayerTrackV3.PlayerStats.ORBC
drbcFloat64YesDefensive rebound chancesBoxScorePlayerTrackV3.PlayerStats.DRBC
rbcFloat64YesTotal rebound chancesBoxScorePlayerTrackV3.PlayerStats.RBC
tchsFloat64YesTouchesBoxScorePlayerTrackV3.PlayerStats.TCHS
sastFloat64YesSecondary assistsBoxScorePlayerTrackV3.PlayerStats.SAST
ftastFloat64YesFree throw assistsBoxScorePlayerTrackV3.PlayerStats.FTAST
passFloat64YesPasses madeBoxScorePlayerTrackV3.PlayerStats.PASS
cfgmFloat64YesContested field goals madeBoxScorePlayerTrackV3.PlayerStats.CFGM
cfgaFloat64YesContested field goals attemptedBoxScorePlayerTrackV3.PlayerStats.CFGA
cfg_pctFloat64YesContested field goal percentageBoxScorePlayerTrackV3.PlayerStats.CFG_PCT
ufgmFloat64YesUncontested field goals madeBoxScorePlayerTrackV3.PlayerStats.UFGM
ufgaFloat64YesUncontested field goals attemptedBoxScorePlayerTrackV3.PlayerStats.UFGA
ufg_pctFloat64YesUncontested field goal percentageBoxScorePlayerTrackV3.PlayerStats.UFG_PCT
dfgmFloat64YesDefended field goals madeBoxScorePlayerTrackV3.PlayerStats.DFGM
dfgaFloat64YesDefended field goals attemptedBoxScorePlayerTrackV3.PlayerStats.DFGA
dfg_pctFloat64YesDefended field goal percentageBoxScorePlayerTrackV3.PlayerStats.DFG_PCT

staging_box_score_traditional_player

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreTraditionalV3.PlayerStats.GAME_ID
team_idInt64NoTeam identifier (FK → staging_team.team_id)BoxScoreTraditionalV3.PlayerStats.TEAM_ID
team_abbreviationStringYesTeam abbreviation codeBoxScoreTraditionalV3.PlayerStats.TEAM_ABBREVIATION
team_cityStringYesTeam city nameBoxScoreTraditionalV3.PlayerStats.TEAM_CITY
player_idInt64NoUnique player identifier (FK → staging_player.person_id)BoxScoreTraditionalV3.PlayerStats.PLAYER_ID
player_nameStringYesPlayer full nameBoxScoreTraditionalV3.PlayerStats.PLAYER_NAME
nicknameStringYesPlayer nicknameBoxScoreTraditionalV3.PlayerStats.NICKNAME
start_positionStringYesStarting position (F/C/G)BoxScoreTraditionalV3.PlayerStats.START_POSITION
commentStringYesPlayer status commentBoxScoreTraditionalV3.PlayerStats.COMMENT
minStringYesMinutes played as stringBoxScoreTraditionalV3.PlayerStats.MIN
fgmFloat64YesField goals madeBoxScoreTraditionalV3.PlayerStats.FGM
fgaFloat64YesField goals attemptedBoxScoreTraditionalV3.PlayerStats.FGA
fg_pctFloat64YesField goal percentageBoxScoreTraditionalV3.PlayerStats.FG_PCT
fg3mFloat64YesThree-point field goals madeBoxScoreTraditionalV3.PlayerStats.FG3M
fg3aFloat64YesThree-point field goals attemptedBoxScoreTraditionalV3.PlayerStats.FG3A
fg3_pctFloat64YesThree-point field goal percentageBoxScoreTraditionalV3.PlayerStats.FG3_PCT
ftmFloat64YesFree throws madeBoxScoreTraditionalV3.PlayerStats.FTM
ftaFloat64YesFree throws attemptedBoxScoreTraditionalV3.PlayerStats.FTA
ft_pctFloat64YesFree throw percentageBoxScoreTraditionalV3.PlayerStats.FT_PCT
orebFloat64YesOffensive reboundsBoxScoreTraditionalV3.PlayerStats.OREB
drebFloat64YesDefensive reboundsBoxScoreTraditionalV3.PlayerStats.DREB
rebFloat64YesTotal reboundsBoxScoreTraditionalV3.PlayerStats.REB
astFloat64YesAssistsBoxScoreTraditionalV3.PlayerStats.AST
stlFloat64YesStealsBoxScoreTraditionalV3.PlayerStats.STL
blkFloat64YesBlocksBoxScoreTraditionalV3.PlayerStats.BLK
tovFloat64YesTurnoversBoxScoreTraditionalV3.PlayerStats.TOV
pfFloat64YesPersonal foulsBoxScoreTraditionalV3.PlayerStats.PF
ptsFloat64YesPoints scoredBoxScoreTraditionalV3.PlayerStats.PTS
plus_minusFloat64YesPlus-minus differentialBoxScoreTraditionalV3.PlayerStats.PLUS_MINUS

staging_box_score_traditional_team

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreTraditionalV3.TeamStats.GAME_ID
team_idInt64NoTeam identifier (FK → staging_team.team_id)BoxScoreTraditionalV3.TeamStats.TEAM_ID
team_nameStringYesTeam nameBoxScoreTraditionalV3.TeamStats.TEAM_NAME
team_abbreviationStringYesTeam abbreviation codeBoxScoreTraditionalV3.TeamStats.TEAM_ABBREVIATION
team_cityStringYesTeam city nameBoxScoreTraditionalV3.TeamStats.TEAM_CITY
minFloat64YesTotal team minutes playedBoxScoreTraditionalV3.TeamStats.MIN
fgmFloat64YesField goals madeBoxScoreTraditionalV3.TeamStats.FGM
fgaFloat64YesField goals attemptedBoxScoreTraditionalV3.TeamStats.FGA
fg_pctFloat64YesField goal percentageBoxScoreTraditionalV3.TeamStats.FG_PCT
fg3mFloat64YesThree-point field goals madeBoxScoreTraditionalV3.TeamStats.FG3M
fg3aFloat64YesThree-point field goals attemptedBoxScoreTraditionalV3.TeamStats.FG3A
fg3_pctFloat64YesThree-point field goal percentageBoxScoreTraditionalV3.TeamStats.FG3_PCT
ftmFloat64YesFree throws madeBoxScoreTraditionalV3.TeamStats.FTM
ftaFloat64YesFree throws attemptedBoxScoreTraditionalV3.TeamStats.FTA
ft_pctFloat64YesFree throw percentageBoxScoreTraditionalV3.TeamStats.FT_PCT
orebFloat64YesOffensive reboundsBoxScoreTraditionalV3.TeamStats.OREB
drebFloat64YesDefensive reboundsBoxScoreTraditionalV3.TeamStats.DREB
rebFloat64YesTotal reboundsBoxScoreTraditionalV3.TeamStats.REB
astFloat64YesAssistsBoxScoreTraditionalV3.TeamStats.AST
stlFloat64YesStealsBoxScoreTraditionalV3.TeamStats.STL
blkFloat64YesBlocksBoxScoreTraditionalV3.TeamStats.BLK
tovFloat64YesTurnoversBoxScoreTraditionalV3.TeamStats.TOV
pfFloat64YesPersonal foulsBoxScoreTraditionalV3.TeamStats.PF
ptsFloat64YesPoints scoredBoxScoreTraditionalV3.TeamStats.PTS
plus_minusFloat64YesPlus-minus differentialBoxScoreTraditionalV3.TeamStats.PLUS_MINUS

staging_common_all_players

ColumnTypeNullableDescriptionSource
person_idInt64NoUnique player identifierCommonAllPlayers.CommonAllPlayers.PERSON_ID
display_last_comma_firstStringYesPlayer name as Last, FirstCommonAllPlayers.CommonAllPlayers.DISPLAY_LAST_COMMA_FIRST
display_first_lastStringNoPlayer name as First LastCommonAllPlayers.CommonAllPlayers.DISPLAY_FIRST_LAST
roster_statusInt64YesActive roster flag (0 or 1)CommonAllPlayers.CommonAllPlayers.ROSTER_STATUS
from_yearStringYesFirst year in the leagueCommonAllPlayers.CommonAllPlayers.FROM_YEAR
to_yearStringYesLast year in the leagueCommonAllPlayers.CommonAllPlayers.TO_YEAR
playercodeStringYesPlayer code slugCommonAllPlayers.CommonAllPlayers.PLAYERCODE
team_idInt64YesTeam identifier (FK → staging_team.team_id)CommonAllPlayers.CommonAllPlayers.TEAM_ID
team_cityStringYesTeam city nameCommonAllPlayers.CommonAllPlayers.TEAM_CITY
team_nameStringYesTeam nameCommonAllPlayers.CommonAllPlayers.TEAM_NAME
team_abbreviationStringYesTeam abbreviation codeCommonAllPlayers.CommonAllPlayers.TEAM_ABBREVIATION
team_codeStringYesTeam code slugCommonAllPlayers.CommonAllPlayers.TEAM_CODE
games_played_flagStringYesFlag indicating games playedCommonAllPlayers.CommonAllPlayers.GAMES_PLAYED_FLAG

staging_common_team_years

ColumnTypeNullableDescriptionSource
league_idStringNoLeague identifierCommonTeamYears.TeamYears.LEAGUE_ID
team_idInt64NoUnique team identifierCommonTeamYears.TeamYears.TEAM_ID
min_yearStringYesFirst year of team activityCommonTeamYears.TeamYears.MIN_YEAR
max_yearStringYesLast year of team activityCommonTeamYears.TeamYears.MAX_YEAR
abbreviationStringNoTeam abbreviation codeCommonTeamYears.TeamYears.ABBREVIATION

staging_draft_combine_stats

ColumnTypeNullableDescriptionSource
seasonStringNoCombine season yearDraftCombineStats.DraftCombineStats.SEASON
player_idInt64NoUnique player identifier (FK → staging_player.person_id)DraftCombineStats.DraftCombineStats.PLAYER_ID
first_nameStringYesPlayer first nameDraftCombineStats.DraftCombineStats.FIRST_NAME
last_nameStringYesPlayer last nameDraftCombineStats.DraftCombineStats.LAST_NAME
player_nameStringYesPlayer full nameDraftCombineStats.DraftCombineStats.PLAYER_NAME
positionStringYesPlayer positionDraftCombineStats.DraftCombineStats.POSITION
height_wo_shoesFloat64YesHeight without shoes in inchesDraftCombineStats.DraftCombineStats.HEIGHT_WO_SHOES
height_wo_shoes_ft_inStringYesHeight without shoes in feet-inchesDraftCombineStats.DraftCombineStats.HEIGHT_WO_SHOES_FT_IN
height_w_shoesFloat64YesHeight with shoes in inchesDraftCombineStats.DraftCombineStats.HEIGHT_W_SHOES
height_w_shoes_ft_inStringYesHeight with shoes in feet-inchesDraftCombineStats.DraftCombineStats.HEIGHT_W_SHOES_FT_IN
weightFloat64YesPlayer weight in poundsDraftCombineStats.DraftCombineStats.WEIGHT
wingspanFloat64YesWingspan in inchesDraftCombineStats.DraftCombineStats.WINGSPAN
wingspan_ft_inStringYesWingspan in feet-inchesDraftCombineStats.DraftCombineStats.WINGSPAN_FT_IN
standing_reachFloat64YesStanding reach in inchesDraftCombineStats.DraftCombineStats.STANDING_REACH
standing_reach_ft_inStringYesStanding reach in feet-inchesDraftCombineStats.DraftCombineStats.STANDING_REACH_FT_IN
body_fat_pctFloat64YesBody fat percentageDraftCombineStats.DraftCombineStats.BODY_FAT_PCT
hand_lengthFloat64YesHand length in inchesDraftCombineStats.DraftCombineStats.HAND_LENGTH
hand_widthFloat64YesHand width in inchesDraftCombineStats.DraftCombineStats.HAND_WIDTH
standing_vertical_leapFloat64YesStanding vertical leap in inchesDraftCombineStats.DraftCombineStats.STANDING_VERTICAL_LEAP
max_vertical_leapFloat64YesMaximum vertical leap in inchesDraftCombineStats.DraftCombineStats.MAX_VERTICAL_LEAP
lane_agility_timeFloat64YesLane agility drill time in secondsDraftCombineStats.DraftCombineStats.LANE_AGILITY_TIME
modified_lane_agility_timeFloat64YesModified lane agility time in secondsDraftCombineStats.DraftCombineStats.MODIFIED_LANE_AGILITY_TIME
three_quarter_sprintFloat64YesThree-quarter court sprint time in secondsDraftCombineStats.DraftCombineStats.THREE_QUARTER_SPRINT
bench_pressFloat64YesBench press repetitionsDraftCombineStats.DraftCombineStats.BENCH_PRESS

staging_draft_history

ColumnTypeNullableDescriptionSource
person_idInt64NoUnique player identifier (FK → staging_player.person_id)DraftHistory.DraftHistory.PERSON_ID
player_nameStringYesPlayer full nameDraftHistory.DraftHistory.PLAYER_NAME
seasonStringNoDraft season yearDraftHistory.DraftHistory.SEASON
round_numberInt64YesDraft round numberDraftHistory.DraftHistory.ROUND_NUMBER
round_pickInt64YesPick number within the roundDraftHistory.DraftHistory.ROUND_PICK
overall_pickInt64YesOverall draft pick numberDraftHistory.DraftHistory.OVERALL_PICK
draft_typeStringYesType of draftDraftHistory.DraftHistory.DRAFT_TYPE
team_idInt64YesTeam identifier (FK → staging_team.team_id)DraftHistory.DraftHistory.TEAM_ID
team_cityStringYesTeam city nameDraftHistory.DraftHistory.TEAM_CITY
team_nameStringYesTeam nameDraftHistory.DraftHistory.TEAM_NAME
team_abbreviationStringYesTeam abbreviation codeDraftHistory.DraftHistory.TEAM_ABBREVIATION
organizationStringYesPre-draft organizationDraftHistory.DraftHistory.ORGANIZATION
organization_typeStringYesType of pre-draft organizationDraftHistory.DraftHistory.ORGANIZATION_TYPE
player_profile_flagInt64YesPlayer profile availability flagDraftHistory.DraftHistory.PLAYER_PROFILE_FLAG

staging_game_leaders

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierScoreboardV3.GameLeaders.gameId
team_idInt64NoTeam identifier (FK → staging_team.team_id)ScoreboardV3.GameLeaders.teamId
leader_typeStringNoLeader category (home or away)ScoreboardV3.GameLeaders.leaderType
person_idInt64NoUnique player identifier (FK → staging_player.person_id)ScoreboardV3.GameLeaders.personId
nameStringNoPlayer display nameScoreboardV3.GameLeaders.name
player_slugStringYesPlayer URL slugScoreboardV3.GameLeaders.playerSlug
jersey_numStringYesPlayer jersey numberScoreboardV3.GameLeaders.jerseyNum
positionStringYesPlayer positionScoreboardV3.GameLeaders.position
team_tricodeStringYesThree-letter team codeScoreboardV3.GameLeaders.teamTricode
pointsFloat64YesPoints scoredScoreboardV3.GameLeaders.points
reboundsFloat64YesTotal reboundsScoreboardV3.GameLeaders.rebounds
assistsFloat64YesTotal assistsScoreboardV3.GameLeaders.assists

staging_game_rotation

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierGameRotation.HomeTeam.GAME_ID
team_idInt64YesTeam identifier (FK → staging_team.team_id)GameRotation.HomeTeam.TEAM_ID
team_cityStringYesTeam city nameGameRotation.HomeTeam.TEAM_CITY
team_nameStringYesTeam nameGameRotation.HomeTeam.TEAM_NAME
person_idInt64YesPlayer person identifier (FK → staging_player.person_id)GameRotation.HomeTeam.PERSON_ID
player_firstStringYesPlayer first nameGameRotation.HomeTeam.PLAYER_FIRST
player_lastStringYesPlayer last nameGameRotation.HomeTeam.PLAYER_LAST
in_time_realFloat64YesReal time player entered gameGameRotation.HomeTeam.IN_TIME_REAL
out_time_realFloat64YesReal time player exited gameGameRotation.HomeTeam.OUT_TIME_REAL
player_ptsFloat64YesPoints scored during stintGameRotation.HomeTeam.PLAYER_PTS
pt_diffFloat64YesPoint differential during stintGameRotation.HomeTeam.PT_DIFF
usg_pctFloat64YesUsage percentage during stintGameRotation.HomeTeam.USG_PCT

staging_league_dash_player_stats

ColumnTypeNullableDescriptionSource
player_idInt64NoUnique player identifier (FK → staging_player.person_id)LeagueDashPlayerStats.LeagueDashPlayerStats.PLAYER_ID
player_nameStringYesPlayer full nameLeagueDashPlayerStats.LeagueDashPlayerStats.PLAYER_NAME
team_idInt64NoTeam identifier (FK → staging_team.team_id)LeagueDashPlayerStats.LeagueDashPlayerStats.TEAM_ID
team_abbreviationStringYesTeam abbreviation codeLeagueDashPlayerStats.LeagueDashPlayerStats.TEAM_ABBREVIATION
ageFloat64YesPlayer ageLeagueDashPlayerStats.LeagueDashPlayerStats.AGE
gpInt64YesGames playedLeagueDashPlayerStats.LeagueDashPlayerStats.GP
wInt64YesWinsLeagueDashPlayerStats.LeagueDashPlayerStats.W
lInt64YesLossesLeagueDashPlayerStats.LeagueDashPlayerStats.L
w_pctFloat64YesWin percentageLeagueDashPlayerStats.LeagueDashPlayerStats.W_PCT
minFloat64YesMinutes playedLeagueDashPlayerStats.LeagueDashPlayerStats.MIN
fgmFloat64YesField goals madeLeagueDashPlayerStats.LeagueDashPlayerStats.FGM
fgaFloat64YesField goals attemptedLeagueDashPlayerStats.LeagueDashPlayerStats.FGA
fg_pctFloat64YesField goal percentageLeagueDashPlayerStats.LeagueDashPlayerStats.FG_PCT
fg3mFloat64YesThree-point field goals madeLeagueDashPlayerStats.LeagueDashPlayerStats.FG3M
fg3aFloat64YesThree-point field goals attemptedLeagueDashPlayerStats.LeagueDashPlayerStats.FG3A
fg3_pctFloat64YesThree-point field goal percentageLeagueDashPlayerStats.LeagueDashPlayerStats.FG3_PCT
ftmFloat64YesFree throws madeLeagueDashPlayerStats.LeagueDashPlayerStats.FTM
ftaFloat64YesFree throws attemptedLeagueDashPlayerStats.LeagueDashPlayerStats.FTA
ft_pctFloat64YesFree throw percentageLeagueDashPlayerStats.LeagueDashPlayerStats.FT_PCT
orebFloat64YesOffensive reboundsLeagueDashPlayerStats.LeagueDashPlayerStats.OREB
drebFloat64YesDefensive reboundsLeagueDashPlayerStats.LeagueDashPlayerStats.DREB
rebFloat64YesTotal reboundsLeagueDashPlayerStats.LeagueDashPlayerStats.REB
astFloat64YesAssistsLeagueDashPlayerStats.LeagueDashPlayerStats.AST
tovFloat64YesTurnoversLeagueDashPlayerStats.LeagueDashPlayerStats.TOV
stlFloat64YesStealsLeagueDashPlayerStats.LeagueDashPlayerStats.STL
blkFloat64YesBlocksLeagueDashPlayerStats.LeagueDashPlayerStats.BLK
blkaFloat64YesBlocked attemptsLeagueDashPlayerStats.LeagueDashPlayerStats.BLKA
pfFloat64YesPersonal foulsLeagueDashPlayerStats.LeagueDashPlayerStats.PF
pfdFloat64YesPersonal fouls drawnLeagueDashPlayerStats.LeagueDashPlayerStats.PFD
ptsFloat64YesPoints scoredLeagueDashPlayerStats.LeagueDashPlayerStats.PTS
plus_minusFloat64YesPlus-minus differentialLeagueDashPlayerStats.LeagueDashPlayerStats.PLUS_MINUS
nba_fantasy_ptsFloat64YesNBA fantasy pointsLeagueDashPlayerStats.LeagueDashPlayerStats.NBA_FANTASY_PTS
dd2Float64YesDouble-doublesLeagueDashPlayerStats.LeagueDashPlayerStats.DD2
td3Float64YesTriple-doublesLeagueDashPlayerStats.LeagueDashPlayerStats.TD3
gp_rankInt64YesGames played rankLeagueDashPlayerStats.LeagueDashPlayerStats.GP_RANK
w_rankInt64YesWins rankLeagueDashPlayerStats.LeagueDashPlayerStats.W_RANK
l_rankInt64YesLosses rankLeagueDashPlayerStats.LeagueDashPlayerStats.L_RANK
w_pct_rankInt64YesWin percentage rankLeagueDashPlayerStats.LeagueDashPlayerStats.W_PCT_RANK
min_rankInt64YesMinutes played rankLeagueDashPlayerStats.LeagueDashPlayerStats.MIN_RANK
fgm_rankInt64YesField goals made rankLeagueDashPlayerStats.LeagueDashPlayerStats.FGM_RANK
fga_rankInt64YesField goals attempted rankLeagueDashPlayerStats.LeagueDashPlayerStats.FGA_RANK
fg_pct_rankInt64YesField goal percentage rankLeagueDashPlayerStats.LeagueDashPlayerStats.FG_PCT_RANK
fg3m_rankInt64YesThree-point field goals made rankLeagueDashPlayerStats.LeagueDashPlayerStats.FG3M_RANK
fg3a_rankInt64YesThree-point field goals attempted rankLeagueDashPlayerStats.LeagueDashPlayerStats.FG3A_RANK
fg3_pct_rankInt64YesThree-point percentage rankLeagueDashPlayerStats.LeagueDashPlayerStats.FG3_PCT_RANK
ftm_rankInt64YesFree throws made rankLeagueDashPlayerStats.LeagueDashPlayerStats.FTM_RANK
fta_rankInt64YesFree throws attempted rankLeagueDashPlayerStats.LeagueDashPlayerStats.FTA_RANK
ft_pct_rankInt64YesFree throw percentage rankLeagueDashPlayerStats.LeagueDashPlayerStats.FT_PCT_RANK
oreb_rankInt64YesOffensive rebounds rankLeagueDashPlayerStats.LeagueDashPlayerStats.OREB_RANK
dreb_rankInt64YesDefensive rebounds rankLeagueDashPlayerStats.LeagueDashPlayerStats.DREB_RANK
reb_rankInt64YesTotal rebounds rankLeagueDashPlayerStats.LeagueDashPlayerStats.REB_RANK
ast_rankInt64YesAssists rankLeagueDashPlayerStats.LeagueDashPlayerStats.AST_RANK
tov_rankInt64YesTurnovers rankLeagueDashPlayerStats.LeagueDashPlayerStats.TOV_RANK
stl_rankInt64YesSteals rankLeagueDashPlayerStats.LeagueDashPlayerStats.STL_RANK
blk_rankInt64YesBlocks rankLeagueDashPlayerStats.LeagueDashPlayerStats.BLK_RANK
blka_rankInt64YesBlocked attempts rankLeagueDashPlayerStats.LeagueDashPlayerStats.BLKA_RANK
pf_rankInt64YesPersonal fouls rankLeagueDashPlayerStats.LeagueDashPlayerStats.PF_RANK
pfd_rankInt64YesPersonal fouls drawn rankLeagueDashPlayerStats.LeagueDashPlayerStats.PFD_RANK
pts_rankInt64YesPoints scored rankLeagueDashPlayerStats.LeagueDashPlayerStats.PTS_RANK
plus_minus_rankInt64YesPlus-minus rankLeagueDashPlayerStats.LeagueDashPlayerStats.PLUS_MINUS_RANK
nba_fantasy_pts_rankInt64YesNBA fantasy points rankLeagueDashPlayerStats.LeagueDashPlayerStats.NBA_FANTASY_PTS_RANK
dd2_rankInt64YesDouble-doubles rankLeagueDashPlayerStats.LeagueDashPlayerStats.DD2_RANK
td3_rankInt64YesTriple-doubles rankLeagueDashPlayerStats.LeagueDashPlayerStats.TD3_RANK
cfidInt64YesCustom filter identifierLeagueDashPlayerStats.LeagueDashPlayerStats.CFID
cfparamsStringYesCustom filter parametersLeagueDashPlayerStats.LeagueDashPlayerStats.CFPARAMS

staging_league_dash_team_stats

ColumnTypeNullableDescriptionSource
team_idInt64NoUnique team identifier (FK → staging_team.team_id)LeagueDashTeamStats.LeagueDashTeamStats.TEAM_ID
team_nameStringYesTeam nameLeagueDashTeamStats.LeagueDashTeamStats.TEAM_NAME
gpInt64YesGames playedLeagueDashTeamStats.LeagueDashTeamStats.GP
wInt64YesWinsLeagueDashTeamStats.LeagueDashTeamStats.W
lInt64YesLossesLeagueDashTeamStats.LeagueDashTeamStats.L
w_pctFloat64YesWin percentageLeagueDashTeamStats.LeagueDashTeamStats.W_PCT
minFloat64YesMinutes playedLeagueDashTeamStats.LeagueDashTeamStats.MIN
fgmFloat64YesField goals madeLeagueDashTeamStats.LeagueDashTeamStats.FGM
fgaFloat64YesField goals attemptedLeagueDashTeamStats.LeagueDashTeamStats.FGA
fg_pctFloat64YesField goal percentageLeagueDashTeamStats.LeagueDashTeamStats.FG_PCT
fg3mFloat64YesThree-point field goals madeLeagueDashTeamStats.LeagueDashTeamStats.FG3M
fg3aFloat64YesThree-point field goals attemptedLeagueDashTeamStats.LeagueDashTeamStats.FG3A
fg3_pctFloat64YesThree-point field goal percentageLeagueDashTeamStats.LeagueDashTeamStats.FG3_PCT
ftmFloat64YesFree throws madeLeagueDashTeamStats.LeagueDashTeamStats.FTM
ftaFloat64YesFree throws attemptedLeagueDashTeamStats.LeagueDashTeamStats.FTA
ft_pctFloat64YesFree throw percentageLeagueDashTeamStats.LeagueDashTeamStats.FT_PCT
orebFloat64YesOffensive reboundsLeagueDashTeamStats.LeagueDashTeamStats.OREB
drebFloat64YesDefensive reboundsLeagueDashTeamStats.LeagueDashTeamStats.DREB
rebFloat64YesTotal reboundsLeagueDashTeamStats.LeagueDashTeamStats.REB
astFloat64YesAssistsLeagueDashTeamStats.LeagueDashTeamStats.AST
tovFloat64YesTurnoversLeagueDashTeamStats.LeagueDashTeamStats.TOV
stlFloat64YesStealsLeagueDashTeamStats.LeagueDashTeamStats.STL
blkFloat64YesBlocksLeagueDashTeamStats.LeagueDashTeamStats.BLK
blkaFloat64YesBlocked attemptsLeagueDashTeamStats.LeagueDashTeamStats.BLKA
pfFloat64YesPersonal foulsLeagueDashTeamStats.LeagueDashTeamStats.PF
pfdFloat64YesPersonal fouls drawnLeagueDashTeamStats.LeagueDashTeamStats.PFD
ptsFloat64YesPoints scoredLeagueDashTeamStats.LeagueDashTeamStats.PTS
plus_minusFloat64YesPlus-minus differentialLeagueDashTeamStats.LeagueDashTeamStats.PLUS_MINUS
gp_rankInt64YesGames played rankLeagueDashTeamStats.LeagueDashTeamStats.GP_RANK
w_rankInt64YesWins rankLeagueDashTeamStats.LeagueDashTeamStats.W_RANK
l_rankInt64YesLosses rankLeagueDashTeamStats.LeagueDashTeamStats.L_RANK
w_pct_rankInt64YesWin percentage rankLeagueDashTeamStats.LeagueDashTeamStats.W_PCT_RANK
min_rankInt64YesMinutes played rankLeagueDashTeamStats.LeagueDashTeamStats.MIN_RANK
fgm_rankInt64YesField goals made rankLeagueDashTeamStats.LeagueDashTeamStats.FGM_RANK
fga_rankInt64YesField goals attempted rankLeagueDashTeamStats.LeagueDashTeamStats.FGA_RANK
fg_pct_rankInt64YesField goal percentage rankLeagueDashTeamStats.LeagueDashTeamStats.FG_PCT_RANK
fg3m_rankInt64YesThree-point field goals made rankLeagueDashTeamStats.LeagueDashTeamStats.FG3M_RANK
fg3a_rankInt64YesThree-point field goals attempted rankLeagueDashTeamStats.LeagueDashTeamStats.FG3A_RANK
fg3_pct_rankInt64YesThree-point percentage rankLeagueDashTeamStats.LeagueDashTeamStats.FG3_PCT_RANK
ftm_rankInt64YesFree throws made rankLeagueDashTeamStats.LeagueDashTeamStats.FTM_RANK
fta_rankInt64YesFree throws attempted rankLeagueDashTeamStats.LeagueDashTeamStats.FTA_RANK
ft_pct_rankInt64YesFree throw percentage rankLeagueDashTeamStats.LeagueDashTeamStats.FT_PCT_RANK
oreb_rankInt64YesOffensive rebounds rankLeagueDashTeamStats.LeagueDashTeamStats.OREB_RANK
dreb_rankInt64YesDefensive rebounds rankLeagueDashTeamStats.LeagueDashTeamStats.DREB_RANK
reb_rankInt64YesTotal rebounds rankLeagueDashTeamStats.LeagueDashTeamStats.REB_RANK
ast_rankInt64YesAssists rankLeagueDashTeamStats.LeagueDashTeamStats.AST_RANK
tov_rankInt64YesTurnovers rankLeagueDashTeamStats.LeagueDashTeamStats.TOV_RANK
stl_rankInt64YesSteals rankLeagueDashTeamStats.LeagueDashTeamStats.STL_RANK
blk_rankInt64YesBlocks rankLeagueDashTeamStats.LeagueDashTeamStats.BLK_RANK
blka_rankInt64YesBlocked attempts rankLeagueDashTeamStats.LeagueDashTeamStats.BLKA_RANK
pf_rankInt64YesPersonal fouls rankLeagueDashTeamStats.LeagueDashTeamStats.PF_RANK
pfd_rankInt64YesPersonal fouls drawn rankLeagueDashTeamStats.LeagueDashTeamStats.PFD_RANK
pts_rankInt64YesPoints scored rankLeagueDashTeamStats.LeagueDashTeamStats.PTS_RANK
plus_minus_rankInt64YesPlus-minus rankLeagueDashTeamStats.LeagueDashTeamStats.PLUS_MINUS_RANK
cfidInt64YesCustom filter identifierLeagueDashTeamStats.LeagueDashTeamStats.CFID
cfparamsStringYesCustom filter parametersLeagueDashTeamStats.LeagueDashTeamStats.CFPARAMS

staging_league_game_log

ColumnTypeNullableDescriptionSource
season_idStringNoSeason identifierLeagueGameLog.LeagueGameLog.SEASON_ID
team_idInt64NoUnique team identifier (FK → staging_team.team_id)LeagueGameLog.LeagueGameLog.TEAM_ID
team_abbreviationStringNoTeam abbreviation codeLeagueGameLog.LeagueGameLog.TEAM_ABBREVIATION
team_nameStringNoTeam nameLeagueGameLog.LeagueGameLog.TEAM_NAME
game_idStringNoUnique game identifierLeagueGameLog.LeagueGameLog.GAME_ID
game_dateStringNoDate of the gameLeagueGameLog.LeagueGameLog.GAME_DATE
matchupStringNoMatchup string (e.g. LAL vs. BOS)LeagueGameLog.LeagueGameLog.MATCHUP
wlStringYesWin or loss indicatorLeagueGameLog.LeagueGameLog.WL
wInt64YesWinsLeagueGameLog.LeagueGameLog.W
lInt64YesLossesLeagueGameLog.LeagueGameLog.L
w_pctFloat64YesWin percentageLeagueGameLog.LeagueGameLog.W_PCT
minFloat64YesMinutes playedLeagueGameLog.LeagueGameLog.MIN
fgmFloat64YesField goals madeLeagueGameLog.LeagueGameLog.FGM
fgaFloat64YesField goals attemptedLeagueGameLog.LeagueGameLog.FGA
fg_pctFloat64YesField goal percentageLeagueGameLog.LeagueGameLog.FG_PCT
fg3mFloat64YesThree-point field goals madeLeagueGameLog.LeagueGameLog.FG3M
fg3aFloat64YesThree-point field goals attemptedLeagueGameLog.LeagueGameLog.FG3A
fg3_pctFloat64YesThree-point field goal percentageLeagueGameLog.LeagueGameLog.FG3_PCT
ftmFloat64YesFree throws madeLeagueGameLog.LeagueGameLog.FTM
ftaFloat64YesFree throws attemptedLeagueGameLog.LeagueGameLog.FTA
ft_pctFloat64YesFree throw percentageLeagueGameLog.LeagueGameLog.FT_PCT
orebFloat64YesOffensive reboundsLeagueGameLog.LeagueGameLog.OREB
drebFloat64YesDefensive reboundsLeagueGameLog.LeagueGameLog.DREB
rebFloat64YesTotal reboundsLeagueGameLog.LeagueGameLog.REB
astFloat64YesAssistsLeagueGameLog.LeagueGameLog.AST
stlFloat64YesStealsLeagueGameLog.LeagueGameLog.STL
blkFloat64YesBlocksLeagueGameLog.LeagueGameLog.BLK
tovFloat64YesTurnoversLeagueGameLog.LeagueGameLog.TOV
pfFloat64YesPersonal foulsLeagueGameLog.LeagueGameLog.PF
ptsFloat64YesPoints scoredLeagueGameLog.LeagueGameLog.PTS
plus_minusFloat64YesPlus-minus differentialLeagueGameLog.LeagueGameLog.PLUS_MINUS
video_availableInt64YesVideo availability flagLeagueGameLog.LeagueGameLog.VIDEO_AVAILABLE

staging_league_lineup_viz

ColumnTypeNullableDescriptionSource
group_idStringNoLineup group identifierLeagueLineupViz.LeagueLineupViz.GROUP_ID
group_nameStringYesLineup player namesLeagueLineupViz.LeagueLineupViz.GROUP_NAME
team_idInt64NoTeam identifier (FK → staging_team.team_id)LeagueLineupViz.LeagueLineupViz.TEAM_ID
team_abbreviationStringYesTeam abbreviation codeLeagueLineupViz.LeagueLineupViz.TEAM_ABBREVIATION
minFloat64YesMinutes playedLeagueLineupViz.LeagueLineupViz.MIN
off_ratingFloat64YesOffensive ratingLeagueLineupViz.LeagueLineupViz.OFF_RATING
def_ratingFloat64YesDefensive ratingLeagueLineupViz.LeagueLineupViz.DEF_RATING
net_ratingFloat64YesNet ratingLeagueLineupViz.LeagueLineupViz.NET_RATING
paceFloat64YesPace factorLeagueLineupViz.LeagueLineupViz.PACE
ts_pctFloat64YesTrue shooting percentageLeagueLineupViz.LeagueLineupViz.TS_PCT
fta_rateFloat64YesFree throw attempt rateLeagueLineupViz.LeagueLineupViz.FTA_RATE
tm_ast_pctFloat64YesTeam assist percentageLeagueLineupViz.LeagueLineupViz.TM_AST_PCT
pct_fga_2ptFloat64YesPercentage of field goal attempts from two-point rangeLeagueLineupViz.LeagueLineupViz.PCT_FGA_2PT
pct_fga_3ptFloat64YesPercentage of field goal attempts from three-point rangeLeagueLineupViz.LeagueLineupViz.PCT_FGA_3PT
pct_pts_2pt_mrFloat64YesPercentage of points from mid-range two-pointersLeagueLineupViz.LeagueLineupViz.PCT_PTS_2PT_MR
pct_pts_fbFloat64YesPercentage of points from fast breaksLeagueLineupViz.LeagueLineupViz.PCT_PTS_FB
pct_pts_ftFloat64YesPercentage of points from free throwsLeagueLineupViz.LeagueLineupViz.PCT_PTS_FT
pct_pts_paintFloat64YesPercentage of points in the paintLeagueLineupViz.LeagueLineupViz.PCT_PTS_PAINT
pct_ast_fgmFloat64YesPercentage of assisted field goalsLeagueLineupViz.LeagueLineupViz.PCT_AST_FGM
pct_uast_fgmFloat64YesPercentage of unassisted field goalsLeagueLineupViz.LeagueLineupViz.PCT_UAST_FGM
opp_fg3_pctFloat64YesOpponent three-point percentageLeagueLineupViz.LeagueLineupViz.OPP_FG3_PCT
opp_efg_pctFloat64YesOpponent effective field goal percentageLeagueLineupViz.LeagueLineupViz.OPP_EFG_PCT
opp_fta_rateFloat64YesOpponent free throw attempt rateLeagueLineupViz.LeagueLineupViz.OPP_FTA_RATE
opp_tov_pctFloat64YesOpponent turnover percentageLeagueLineupViz.LeagueLineupViz.OPP_TOV_PCT

staging_league_standings_v3

ColumnTypeNullableDescriptionSource
league_idStringNoLeague identifierLeagueStandingsV3.Standings.LeagueID
season_idStringYesSeason identifierLeagueStandingsV3.Standings.SeasonID
team_idInt64NoUnique team identifier (FK → staging_team.team_id)LeagueStandingsV3.Standings.TeamID
team_cityStringYesTeam city nameLeagueStandingsV3.Standings.TeamCity
team_nameStringYesTeam nameLeagueStandingsV3.Standings.TeamName
team_slugStringYesURL-friendly team slugLeagueStandingsV3.Standings.TeamSlug
conferenceStringYesConference nameLeagueStandingsV3.Standings.Conference
conference_recordStringYesWin-loss record in conferenceLeagueStandingsV3.Standings.ConferenceRecord
playoff_rankInt64YesPlayoff seeding rankLeagueStandingsV3.Standings.PlayoffRank
clinch_indicatorStringYesClinch status indicatorLeagueStandingsV3.Standings.ClinchIndicator
divisionStringYesDivision nameLeagueStandingsV3.Standings.Division
division_recordStringYesWin-loss record in divisionLeagueStandingsV3.Standings.DivisionRecord
division_rankInt64YesRank within divisionLeagueStandingsV3.Standings.DivisionRank
winsInt64YesTotal winsLeagueStandingsV3.Standings.WINS
lossesInt64YesTotal lossesLeagueStandingsV3.Standings.LOSSES
win_pctFloat64YesWinning percentageLeagueStandingsV3.Standings.WinPCT
league_rankInt64YesOverall league rankLeagueStandingsV3.Standings.LeagueRank
recordStringYesOverall win-loss recordLeagueStandingsV3.Standings.Record
homeStringYesHome win-loss recordLeagueStandingsV3.Standings.HOME
roadStringYesRoad win-loss recordLeagueStandingsV3.Standings.ROAD
l10StringYesRecord in last 10 gamesLeagueStandingsV3.Standings.L10
long_win_streakInt64YesLongest winning streakLeagueStandingsV3.Standings.LongWinStreak
long_loss_streakInt64YesLongest losing streakLeagueStandingsV3.Standings.LongLossStreak
current_streakStringYesCurrent win or loss streakLeagueStandingsV3.Standings.CurrentStreak
ot_recordStringYesOvertime win-loss recordLeagueStandingsV3.Standings.OT_Record
three_pts_or_lessStringYesRecord in games decided by 3 points or lessLeagueStandingsV3.Standings.ThreePTSOrLess
ten_pts_or_moreStringYesRecord in games decided by 10 points or moreLeagueStandingsV3.Standings.TenPTSOrMore
conference_games_backFloat64YesGames behind conference leaderLeagueStandingsV3.Standings.ConferenceGamesBack
division_games_backFloat64YesGames behind division leaderLeagueStandingsV3.Standings.DivisionGamesBack
clinched_conference_titleInt64YesWhether team clinched conferenceLeagueStandingsV3.Standings.ClinchedConferenceTitle
clinched_division_titleInt64YesWhether team clinched divisionLeagueStandingsV3.Standings.ClinchedDivisionTitle
clinched_playoff_birthInt64YesWhether team clinched playoff berthLeagueStandingsV3.Standings.ClinchedPlayoffBirth
eliminated_conferenceInt64YesWhether team eliminated from conference playoff contentionLeagueStandingsV3.Standings.EliminatedConference
pts_pgFloat64YesPoints per gameLeagueStandingsV3.Standings.PointsPG
opp_pts_pgFloat64YesOpponent points per gameLeagueStandingsV3.Standings.OppPointsPG
diff_pts_pgFloat64YesPoint differential per gameLeagueStandingsV3.Standings.DiffPointsPG

staging_play_by_play_v2

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierPlayByPlayV2.PlayByPlay.GAME_ID
eventnumInt64NoEvent sequence numberPlayByPlayV2.PlayByPlay.EVENTNUM
eventmsgtypeInt64NoEvent message type codePlayByPlayV2.PlayByPlay.EVENTMSGTYPE
eventmsgactiontypeInt64NoEvent message action type codePlayByPlayV2.PlayByPlay.EVENTMSGACTIONTYPE
periodInt64NoGame period numberPlayByPlayV2.PlayByPlay.PERIOD
wctimestringStringYesWall clock time stringPlayByPlayV2.PlayByPlay.WCTIMESTRING
pctimestringStringYesPeriod clock time stringPlayByPlayV2.PlayByPlay.PCTIMESTRING
homedescriptionStringYesPlay description for home teamPlayByPlayV2.PlayByPlay.HOMEDESCRIPTION
neutraldescriptionStringYesNeutral play descriptionPlayByPlayV2.PlayByPlay.NEUTRALDESCRIPTION
visitordescriptionStringYesPlay description for visitor teamPlayByPlayV2.PlayByPlay.VISITORDESCRIPTION
scoreStringYesCurrent game scorePlayByPlayV2.PlayByPlay.SCORE
scoremarginStringYesScore margin valuePlayByPlayV2.PlayByPlay.SCOREMARGIN
person1typeInt64YesPerson 1 type identifierPlayByPlayV2.PlayByPlay.PERSON1TYPE
player1_idInt64YesPlayer 1 unique identifier (FK → staging_player.person_id)PlayByPlayV2.PlayByPlay.PLAYER1_ID
player1_nameStringYesPlayer 1 full namePlayByPlayV2.PlayByPlay.PLAYER1_NAME
player1_team_idInt64YesPlayer 1 team identifier (FK → staging_team.team_id)PlayByPlayV2.PlayByPlay.PLAYER1_TEAM_ID
player1_team_cityStringYesPlayer 1 team cityPlayByPlayV2.PlayByPlay.PLAYER1_TEAM_CITY
player1_team_nicknameStringYesPlayer 1 team nicknamePlayByPlayV2.PlayByPlay.PLAYER1_TEAM_NICKNAME
player1_team_abbreviationStringYesPlayer 1 team abbreviationPlayByPlayV2.PlayByPlay.PLAYER1_TEAM_ABBREVIATION
person2typeInt64YesPerson 2 type identifierPlayByPlayV2.PlayByPlay.PERSON2TYPE
player2_idInt64YesPlayer 2 unique identifier (FK → staging_player.person_id)PlayByPlayV2.PlayByPlay.PLAYER2_ID
player2_nameStringYesPlayer 2 full namePlayByPlayV2.PlayByPlay.PLAYER2_NAME
player2_team_idInt64YesPlayer 2 team identifier (FK → staging_team.team_id)PlayByPlayV2.PlayByPlay.PLAYER2_TEAM_ID
player2_team_cityStringYesPlayer 2 team cityPlayByPlayV2.PlayByPlay.PLAYER2_TEAM_CITY
player2_team_nicknameStringYesPlayer 2 team nicknamePlayByPlayV2.PlayByPlay.PLAYER2_TEAM_NICKNAME
player2_team_abbreviationStringYesPlayer 2 team abbreviationPlayByPlayV2.PlayByPlay.PLAYER2_TEAM_ABBREVIATION
person3typeInt64YesPerson 3 type identifierPlayByPlayV2.PlayByPlay.PERSON3TYPE
player3_idInt64YesPlayer 3 unique identifier (FK → staging_player.person_id)PlayByPlayV2.PlayByPlay.PLAYER3_ID
player3_nameStringYesPlayer 3 full namePlayByPlayV2.PlayByPlay.PLAYER3_NAME
player3_team_idInt64YesPlayer 3 team identifier (FK → staging_team.team_id)PlayByPlayV2.PlayByPlay.PLAYER3_TEAM_ID
player3_team_cityStringYesPlayer 3 team cityPlayByPlayV2.PlayByPlay.PLAYER3_TEAM_CITY
player3_team_nicknameStringYesPlayer 3 team nicknamePlayByPlayV2.PlayByPlay.PLAYER3_TEAM_NICKNAME
player3_team_abbreviationStringYesPlayer 3 team abbreviationPlayByPlayV2.PlayByPlay.PLAYER3_TEAM_ABBREVIATION
video_available_flagInt64YesVideo availability flagPlayByPlayV2.PlayByPlay.VIDEO_AVAILABLE_FLAG

staging_play_by_play_v3

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierPlayByPlayV3.PlayByPlay.GAME_ID
action_numberInt64NoSequential action number within gamePlayByPlayV3.PlayByPlay.ACTION_NUMBER
clockStringYesGame clock time stringPlayByPlayV3.PlayByPlay.CLOCK
periodInt64NoGame period numberPlayByPlayV3.PlayByPlay.PERIOD
team_idInt64YesTeam identifier (FK → staging_team.team_id)PlayByPlayV3.PlayByPlay.TEAM_ID
team_tricodeStringYesThree-letter team abbreviation codePlayByPlayV3.PlayByPlay.TEAM_TRICODE
person_idInt64YesPerson identifier (FK → staging_player.person_id)PlayByPlayV3.PlayByPlay.PERSON_ID
player_nameStringYesFull player namePlayByPlayV3.PlayByPlay.PLAYER_NAME
player_name_iStringYesPlayer name in initial formatPlayByPlayV3.PlayByPlay.PLAYER_NAME_I
x_legacyFloat64YesLegacy x-coordinate of actionPlayByPlayV3.PlayByPlay.X_LEGACY
y_legacyFloat64YesLegacy y-coordinate of actionPlayByPlayV3.PlayByPlay.Y_LEGACY
shot_distanceFloat64YesDistance of shot in feetPlayByPlayV3.PlayByPlay.SHOT_DISTANCE
shot_resultStringYesResult of shot attemptPlayByPlayV3.PlayByPlay.SHOT_RESULT
is_field_goalInt64YesFlag indicating if action is a field goal attemptPlayByPlayV3.PlayByPlay.IS_FIELD_GOAL
score_homeStringYesHome team scorePlayByPlayV3.PlayByPlay.SCORE_HOME
score_awayStringYesAway team scorePlayByPlayV3.PlayByPlay.SCORE_AWAY
points_totalInt64YesTotal points scored on the playPlayByPlayV3.PlayByPlay.POINTS_TOTAL
locationStringYesHome or away location indicatorPlayByPlayV3.PlayByPlay.LOCATION
descriptionStringYesText description of the playPlayByPlayV3.PlayByPlay.DESCRIPTION
action_typeStringYesType of action performedPlayByPlayV3.PlayByPlay.ACTION_TYPE
sub_typeStringYesSub-type of action performedPlayByPlayV3.PlayByPlay.SUB_TYPE
video_availableInt64YesVideo availability flagPlayByPlayV3.PlayByPlay.VIDEO_AVAILABLE
action_idInt64YesUnique action identifierPlayByPlayV3.PlayByPlay.ACTION_ID

staging_player_dashboard_clutch

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

staging_player_dashboard_game_splits

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

staging_player_dashboard_general_splits

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

staging_player_dashboard_last_n_games

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

staging_player_dashboard_shooting_splits

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

staging_player_dashboard_team_performance

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

staging_player_dashboard_year_over_year

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

staging_player_game_log

ColumnTypeNullableDescriptionSource
season_idStringNoSeason identifierPlayerGameLog.PlayerGameLog.SEASON_ID
player_idInt64NoUnique player identifier (FK → staging_player.person_id)PlayerGameLog.PlayerGameLog.PLAYER_ID
game_idStringNoUnique game identifierPlayerGameLog.PlayerGameLog.GAME_ID
game_dateStringNoDate of the gamePlayerGameLog.PlayerGameLog.GAME_DATE
matchupStringNoMatchup string (e.g. LAL vs. BOS)PlayerGameLog.PlayerGameLog.MATCHUP
wlStringYesWin or loss indicatorPlayerGameLog.PlayerGameLog.WL
minFloat64YesMinutes playedPlayerGameLog.PlayerGameLog.MIN
fgmFloat64YesField goals madePlayerGameLog.PlayerGameLog.FGM
fgaFloat64YesField goals attemptedPlayerGameLog.PlayerGameLog.FGA
fg_pctFloat64YesField goal percentagePlayerGameLog.PlayerGameLog.FG_PCT
fg3mFloat64YesThree-point field goals madePlayerGameLog.PlayerGameLog.FG3M
fg3aFloat64YesThree-point field goals attemptedPlayerGameLog.PlayerGameLog.FG3A
fg3_pctFloat64YesThree-point field goal percentagePlayerGameLog.PlayerGameLog.FG3_PCT
ftmFloat64YesFree throws madePlayerGameLog.PlayerGameLog.FTM
ftaFloat64YesFree throws attemptedPlayerGameLog.PlayerGameLog.FTA
ft_pctFloat64YesFree throw percentagePlayerGameLog.PlayerGameLog.FT_PCT
orebFloat64YesOffensive reboundsPlayerGameLog.PlayerGameLog.OREB
drebFloat64YesDefensive reboundsPlayerGameLog.PlayerGameLog.DREB
rebFloat64YesTotal reboundsPlayerGameLog.PlayerGameLog.REB
astFloat64YesAssistsPlayerGameLog.PlayerGameLog.AST
stlFloat64YesStealsPlayerGameLog.PlayerGameLog.STL
blkFloat64YesBlocksPlayerGameLog.PlayerGameLog.BLK
tovFloat64YesTurnoversPlayerGameLog.PlayerGameLog.TOV
pfFloat64YesPersonal foulsPlayerGameLog.PlayerGameLog.PF
ptsFloat64YesPoints scoredPlayerGameLog.PlayerGameLog.PTS
plus_minusFloat64YesPlus-minus differentialPlayerGameLog.PlayerGameLog.PLUS_MINUS

staging_player_index

ColumnTypeNullableDescriptionSource
person_idInt64NoUnique player identifierPlayerIndex.PlayerIndex.PERSON_ID
player_last_nameStringNoPlayer last namePlayerIndex.PlayerIndex.PLAYER_LAST_NAME
player_first_nameStringNoPlayer first namePlayerIndex.PlayerIndex.PLAYER_FIRST_NAME
player_slugStringYesURL-friendly player slugPlayerIndex.PlayerIndex.PLAYER_SLUG
team_idInt64YesTeam identifier (FK → staging_team.team_id)PlayerIndex.PlayerIndex.TEAM_ID
team_slugStringYesURL-friendly team slugPlayerIndex.PlayerIndex.TEAM_SLUG
is_defunctInt64YesWhether team is defunctPlayerIndex.PlayerIndex.IS_DEFUNCT
team_cityStringYesTeam city namePlayerIndex.PlayerIndex.TEAM_CITY
team_nameStringYesTeam namePlayerIndex.PlayerIndex.TEAM_NAME
team_abbreviationStringYesTeam abbreviation codePlayerIndex.PlayerIndex.TEAM_ABBREVIATION
jersey_numberStringYesJersey number as stringPlayerIndex.PlayerIndex.JERSEY_NUMBER
positionStringYesPlayer positionPlayerIndex.PlayerIndex.POSITION
heightStringYesPlayer height as stringPlayerIndex.PlayerIndex.HEIGHT
weightStringYesPlayer weight as stringPlayerIndex.PlayerIndex.WEIGHT
collegeStringYesCollege attendedPlayerIndex.PlayerIndex.COLLEGE
countryStringYesCountry of originPlayerIndex.PlayerIndex.COUNTRY
draft_yearInt64YesYear draftedPlayerIndex.PlayerIndex.DRAFT_YEAR
draft_roundInt64YesRound draftedPlayerIndex.PlayerIndex.DRAFT_ROUND
draft_numberInt64YesOverall draft pick numberPlayerIndex.PlayerIndex.DRAFT_NUMBER
roster_statusFloat64YesActive roster statusPlayerIndex.PlayerIndex.ROSTER_STATUS
ptsFloat64YesPoints per gamePlayerIndex.PlayerIndex.PTS
rebFloat64YesRebounds per gamePlayerIndex.PlayerIndex.REB
astFloat64YesAssists per gamePlayerIndex.PlayerIndex.AST
stats_timeframeStringYesTimeframe for statsPlayerIndex.PlayerIndex.STATS_TIMEFRAME
from_yearStringYesFirst year in the leaguePlayerIndex.PlayerIndex.FROM_YEAR
to_yearStringYesLast year in the leaguePlayerIndex.PlayerIndex.TO_YEAR

staging_player_perf_pts_scored

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

staging_player_shoot_assisted_by

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

staging_player_shoot_type_summary

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

staging_schedule_league_v2

ColumnTypeNullableDescriptionSource
game_dateStringNoDate of the gameScheduleLeagueV2.ScheduleLeagueV2.GAME_DATE
game_idStringNoUnique game identifierScheduleLeagueV2.ScheduleLeagueV2.GAME_ID
game_codeStringYesGame code stringScheduleLeagueV2.ScheduleLeagueV2.GAME_CODE
game_statusInt64YesGame status codeScheduleLeagueV2.ScheduleLeagueV2.GAME_STATUS
game_status_textStringYesGame status display textScheduleLeagueV2.ScheduleLeagueV2.GAME_STATUS_TEXT
game_sequenceInt64YesGame sequence number for the dayScheduleLeagueV2.ScheduleLeagueV2.GAME_SEQUENCE
game_date_estStringYesGame date in Eastern timeScheduleLeagueV2.ScheduleLeagueV2.GAME_DATE_EST
game_time_estStringYesGame time in Eastern timeScheduleLeagueV2.ScheduleLeagueV2.GAME_TIME_EST
game_date_time_estStringYesGame date and time in Eastern timeScheduleLeagueV2.ScheduleLeagueV2.GAME_DATE_TIME_EST
game_date_utcStringYesGame date in UTCScheduleLeagueV2.ScheduleLeagueV2.GAME_DATE_UTC
game_time_utcStringYesGame time in UTCScheduleLeagueV2.ScheduleLeagueV2.GAME_TIME_UTC
game_date_time_utcStringYesGame date and time in UTCScheduleLeagueV2.ScheduleLeagueV2.GAME_DATE_TIME_UTC
away_team_idInt64YesAway team identifier (FK → staging_team.team_id)ScheduleLeagueV2.ScheduleLeagueV2.AWAY_TEAM_ID
away_team_nameStringYesAway team nameScheduleLeagueV2.ScheduleLeagueV2.AWAY_TEAM_NAME
away_team_cityStringYesAway team cityScheduleLeagueV2.ScheduleLeagueV2.AWAY_TEAM_CITY
away_team_tricodeStringYesAway team three-letter codeScheduleLeagueV2.ScheduleLeagueV2.AWAY_TEAM_TRICODE
away_team_slugStringYesAway team URL slugScheduleLeagueV2.ScheduleLeagueV2.AWAY_TEAM_SLUG
away_team_winsInt64YesAway team win countScheduleLeagueV2.ScheduleLeagueV2.AWAY_TEAM_WINS
away_team_lossesInt64YesAway team loss countScheduleLeagueV2.ScheduleLeagueV2.AWAY_TEAM_LOSSES
away_team_scoreInt64YesAway team scoreScheduleLeagueV2.ScheduleLeagueV2.AWAY_TEAM_SCORE
home_team_idInt64YesHome team identifier (FK → staging_team.team_id)ScheduleLeagueV2.ScheduleLeagueV2.HOME_TEAM_ID
home_team_nameStringYesHome team nameScheduleLeagueV2.ScheduleLeagueV2.HOME_TEAM_NAME
home_team_cityStringYesHome team cityScheduleLeagueV2.ScheduleLeagueV2.HOME_TEAM_CITY
home_team_tricodeStringYesHome team three-letter codeScheduleLeagueV2.ScheduleLeagueV2.HOME_TEAM_TRICODE
home_team_slugStringYesHome team URL slugScheduleLeagueV2.ScheduleLeagueV2.HOME_TEAM_SLUG
home_team_winsInt64YesHome team win countScheduleLeagueV2.ScheduleLeagueV2.HOME_TEAM_WINS
home_team_lossesInt64YesHome team loss countScheduleLeagueV2.ScheduleLeagueV2.HOME_TEAM_LOSSES
home_team_scoreInt64YesHome team scoreScheduleLeagueV2.ScheduleLeagueV2.HOME_TEAM_SCORE
arena_nameStringYesArena nameScheduleLeagueV2.ScheduleLeagueV2.ARENA_NAME
arena_cityStringYesArena cityScheduleLeagueV2.ScheduleLeagueV2.ARENA_CITY
arena_stateStringYesArena stateScheduleLeagueV2.ScheduleLeagueV2.ARENA_STATE
postponed_statusStringYesPostponement statusScheduleLeagueV2.ScheduleLeagueV2.POSTPONED_STATUS
branch_linkStringYesBranch deep link URLScheduleLeagueV2.ScheduleLeagueV2.BRANCH_LINK
game_subtypeStringYesGame subtype classificationScheduleLeagueV2.ScheduleLeagueV2.GAME_SUBTYPE
series_conferenceStringYesPlayoff series conferenceScheduleLeagueV2.ScheduleLeagueV2.SERIES_CONFERENCE
series_textStringYesPlayoff series status textScheduleLeagueV2.ScheduleLeagueV2.SERIES_TEXT
if_necessaryStringYesIf-necessary game indicatorScheduleLeagueV2.ScheduleLeagueV2.IF_NECESSARY
series_game_numberStringYesGame number in playoff seriesScheduleLeagueV2.ScheduleLeagueV2.SERIES_GAME_NUMBER

staging_scoreboard_v2

ColumnTypeNullableDescriptionSource
game_date_estStringNoGame date in Eastern timeScoreboardV2.GameHeader.GAME_DATE_EST
game_sequenceInt64YesGame sequence number for the dayScoreboardV2.GameHeader.GAME_SEQUENCE
game_idStringNoUnique game identifierScoreboardV2.GameHeader.GAME_ID
game_status_idInt64YesGame status identifierScoreboardV2.GameHeader.GAME_STATUS_ID
game_status_textStringYesGame status display textScoreboardV2.GameHeader.GAME_STATUS_TEXT
gamecodeStringYesGame code stringScoreboardV2.GameHeader.GAMECODE
home_team_idInt64YesHome team identifier (FK → staging_team.team_id)ScoreboardV2.GameHeader.HOME_TEAM_ID
visitor_team_idInt64YesVisitor team identifier (FK → staging_team.team_id)ScoreboardV2.GameHeader.VISITOR_TEAM_ID
seasonStringYesSeason year stringScoreboardV2.GameHeader.SEASON
live_periodInt64YesCurrent live periodScoreboardV2.GameHeader.LIVE_PERIOD
live_pc_timeStringYesLive game clock timeScoreboardV2.GameHeader.LIVE_PC_TIME
natl_tv_broadcaster_abbreviationStringYesNational TV broadcaster abbreviationScoreboardV2.GameHeader.NATL_TV_BROADCASTER_ABBREVIATION
home_tv_broadcaster_abbreviationStringYesHome TV broadcaster abbreviationScoreboardV2.GameHeader.HOME_TV_BROADCASTER_ABBREVIATION
away_tv_broadcaster_abbreviationStringYesAway TV broadcaster abbreviationScoreboardV2.GameHeader.AWAY_TV_BROADCASTER_ABBREVIATION
live_period_time_bcastStringYesLive period time broadcast stringScoreboardV2.GameHeader.LIVE_PERIOD_TIME_BCAST
arena_nameStringYesArena nameScoreboardV2.GameHeader.ARENA_NAME
wh_statusInt64YesWagering hub status flagScoreboardV2.GameHeader.WH_STATUS

staging_shot_chart_detail

ColumnTypeNullableDescriptionSource
grid_typeStringYesShot chart grid typeShotChartDetail.Shot_Chart_Detail.GRID_TYPE
game_idStringNoUnique game identifierShotChartDetail.Shot_Chart_Detail.GAME_ID
game_event_idInt64YesEvent identifier within gameShotChartDetail.Shot_Chart_Detail.GAME_EVENT_ID
player_idInt64NoUnique player identifier (FK → staging_player.person_id)ShotChartDetail.Shot_Chart_Detail.PLAYER_ID
player_nameStringYesPlayer full nameShotChartDetail.Shot_Chart_Detail.PLAYER_NAME
team_idInt64YesTeam identifier (FK → staging_team.team_id)ShotChartDetail.Shot_Chart_Detail.TEAM_ID
team_nameStringYesTeam nameShotChartDetail.Shot_Chart_Detail.TEAM_NAME
periodInt64YesGame period numberShotChartDetail.Shot_Chart_Detail.PERIOD
minutes_remainingInt64YesMinutes remaining in periodShotChartDetail.Shot_Chart_Detail.MINUTES_REMAINING
seconds_remainingInt64YesSeconds remaining in periodShotChartDetail.Shot_Chart_Detail.SECONDS_REMAINING
event_typeStringYesShot event type (Made/Missed)ShotChartDetail.Shot_Chart_Detail.EVENT_TYPE
action_typeStringYesSpecific shot action typeShotChartDetail.Shot_Chart_Detail.ACTION_TYPE
shot_typeStringYesShot type (2PT/3PT Field Goal)ShotChartDetail.Shot_Chart_Detail.SHOT_TYPE
shot_zone_basicStringYesBasic shot zone categoryShotChartDetail.Shot_Chart_Detail.SHOT_ZONE_BASIC
shot_zone_areaStringYesShot zone area on courtShotChartDetail.Shot_Chart_Detail.SHOT_ZONE_AREA
shot_zone_rangeStringYesShot distance range bucketShotChartDetail.Shot_Chart_Detail.SHOT_ZONE_RANGE
shot_distanceInt64YesShot distance in feetShotChartDetail.Shot_Chart_Detail.SHOT_DISTANCE
loc_xInt64YesShot X coordinate on courtShotChartDetail.Shot_Chart_Detail.LOC_X
loc_yInt64YesShot Y coordinate on courtShotChartDetail.Shot_Chart_Detail.LOC_Y
shot_attempted_flagInt64YesFlag indicating shot was attemptedShotChartDetail.Shot_Chart_Detail.SHOT_ATTEMPTED_FLAG
shot_made_flagInt64YesFlag indicating shot was madeShotChartDetail.Shot_Chart_Detail.SHOT_MADE_FLAG
game_dateStringYesDate of the gameShotChartDetail.Shot_Chart_Detail.GAME_DATE
htmStringYesHome team abbreviationShotChartDetail.Shot_Chart_Detail.HTM
vtmStringYesVisitor team abbreviationShotChartDetail.Shot_Chart_Detail.VTM

staging_synergy_play_types

ColumnTypeNullableDescriptionSource
season_idStringNoNBA season identifierSynergyPlayTypes.SynergyPlayType.SEASON_ID
team_idInt64YesTeam identifier (FK → staging_team.team_id)SynergyPlayTypes.SynergyPlayType.TEAM_ID
team_abbreviationStringYesTeam abbreviation codeSynergyPlayTypes.SynergyPlayType.TEAM_ABBREVIATION
team_nameStringYesTeam nameSynergyPlayTypes.SynergyPlayType.TEAM_NAME
player_idInt64YesUnique player identifier (FK → staging_player.person_id)SynergyPlayTypes.SynergyPlayType.PLAYER_ID
player_nameStringYesPlayer full nameSynergyPlayTypes.SynergyPlayType.PLAYER_NAME
play_typeStringNoSynergy play type classificationSynergyPlayTypes.SynergyPlayType.PLAY_TYPE
type_groupingStringNoOffensive or defensive groupingSynergyPlayTypes.SynergyPlayType.TYPE_GROUPING
percentileFloat64YesPercentile rank for play typeSynergyPlayTypes.SynergyPlayType.PERCENTILE
gpInt64YesGames playedSynergyPlayTypes.SynergyPlayType.GP
poss_pctFloat64YesPercentage of possessionsSynergyPlayTypes.SynergyPlayType.POSS_PCT
pppFloat64YesPoints per possessionSynergyPlayTypes.SynergyPlayType.PPP
fg_pctFloat64YesField goal percentageSynergyPlayTypes.SynergyPlayType.FG_PCT
ft_pct_adjustFloat64YesFree throw percentage adjustedSynergyPlayTypes.SynergyPlayType.FT_PCT_ADJUST
to_pctFloat64YesTurnover percentageSynergyPlayTypes.SynergyPlayType.TO_PCT
sf_pctFloat64YesShooting foul percentageSynergyPlayTypes.SynergyPlayType.SF_PCT
plusone_pctFloat64YesAnd-one conversion percentageSynergyPlayTypes.SynergyPlayType.PLUSONE_PCT
score_pctFloat64YesScoring percentageSynergyPlayTypes.SynergyPlayType.SCORE_PCT
efg_pctFloat64YesEffective field goal percentageSynergyPlayTypes.SynergyPlayType.EFG_PCT
possInt64YesTotal possessionsSynergyPlayTypes.SynergyPlayType.POSS
ptsFloat64YesTotal points scoredSynergyPlayTypes.SynergyPlayType.PTS
fgmInt64YesField goals madeSynergyPlayTypes.SynergyPlayType.FGM
fgaInt64YesField goals attemptedSynergyPlayTypes.SynergyPlayType.FGA
fgmxInt64YesField goals missedSynergyPlayTypes.SynergyPlayType.FGMX

staging_team_details

ColumnTypeNullableDescriptionSource
team_idInt64NoUnique team identifierTeamDetails.TeamBackground.TEAM_ID
abbreviationStringNoTeam abbreviation codeTeamDetails.TeamBackground.ABBREVIATION
nicknameStringNoTeam nicknameTeamDetails.TeamBackground.NICKNAME
yearfoundedInt64YesYear the team was foundedTeamDetails.TeamBackground.YEARFOUNDED
cityStringYesTeam city nameTeamDetails.TeamBackground.CITY
arenaStringYesHome arena nameTeamDetails.TeamBackground.ARENA
arenacapacityInt64YesArena seating capacityTeamDetails.TeamBackground.ARENACAPACITY
ownerStringYesTeam owner nameTeamDetails.TeamBackground.OWNER
generalmanagerStringYesGeneral manager nameTeamDetails.TeamBackground.GENERALMANAGER
headcoachStringYesHead coach nameTeamDetails.TeamBackground.HEADCOACH
dleagueaffiliationStringYesG-League affiliate team nameTeamDetails.TeamBackground.DLEAGUEAFFILIATION

staging_team_game_log

ColumnTypeNullableDescriptionSource
season_idStringNoSeason identifierTeamGameLog.TeamGameLog.SEASON_ID
team_idInt64NoUnique team identifier (FK → staging_team.team_id)TeamGameLog.TeamGameLog.TEAM_ID
team_abbreviationStringNoTeam abbreviation codeTeamGameLog.TeamGameLog.TEAM_ABBREVIATION
team_nameStringNoTeam nameTeamGameLog.TeamGameLog.TEAM_NAME
game_idStringNoUnique game identifierTeamGameLog.TeamGameLog.GAME_ID
game_dateStringNoDate of the gameTeamGameLog.TeamGameLog.GAME_DATE
matchupStringNoMatchup string (e.g. LAL vs. BOS)TeamGameLog.TeamGameLog.MATCHUP
wlStringYesWin or loss indicatorTeamGameLog.TeamGameLog.WL
wInt64YesWinsTeamGameLog.TeamGameLog.W
lInt64YesLossesTeamGameLog.TeamGameLog.L
w_pctFloat64YesWin percentageTeamGameLog.TeamGameLog.W_PCT
minFloat64YesMinutes playedTeamGameLog.TeamGameLog.MIN
fgmFloat64YesField goals madeTeamGameLog.TeamGameLog.FGM
fgaFloat64YesField goals attemptedTeamGameLog.TeamGameLog.FGA
fg_pctFloat64YesField goal percentageTeamGameLog.TeamGameLog.FG_PCT
fg3mFloat64YesThree-point field goals madeTeamGameLog.TeamGameLog.FG3M
fg3aFloat64YesThree-point field goals attemptedTeamGameLog.TeamGameLog.FG3A
fg3_pctFloat64YesThree-point field goal percentageTeamGameLog.TeamGameLog.FG3_PCT
ftmFloat64YesFree throws madeTeamGameLog.TeamGameLog.FTM
ftaFloat64YesFree throws attemptedTeamGameLog.TeamGameLog.FTA
ft_pctFloat64YesFree throw percentageTeamGameLog.TeamGameLog.FT_PCT
orebFloat64YesOffensive reboundsTeamGameLog.TeamGameLog.OREB
drebFloat64YesDefensive reboundsTeamGameLog.TeamGameLog.DREB
rebFloat64YesTotal reboundsTeamGameLog.TeamGameLog.REB
astFloat64YesAssistsTeamGameLog.TeamGameLog.AST
stlFloat64YesStealsTeamGameLog.TeamGameLog.STL
blkFloat64YesBlocksTeamGameLog.TeamGameLog.BLK
tovFloat64YesTurnoversTeamGameLog.TeamGameLog.TOV
pfFloat64YesPersonal foulsTeamGameLog.TeamGameLog.PF
ptsFloat64YesPoints scoredTeamGameLog.TeamGameLog.PTS
plus_minusFloat64YesPlus-minus differentialTeamGameLog.TeamGameLog.PLUS_MINUS
video_availableInt64YesVideo availability flagTeamGameLog.TeamGameLog.VIDEO_AVAILABLE

staging_team_info_common

ColumnTypeNullableDescriptionSource
team_idInt64NoUnique team identifierTeamInfoCommon.TeamInfoCommon.TEAM_ID
season_yearStringYesSeason year stringTeamInfoCommon.TeamInfoCommon.SEASON_YEAR
team_cityStringYesTeam city nameTeamInfoCommon.TeamInfoCommon.TEAM_CITY
team_nameStringNoTeam nameTeamInfoCommon.TeamInfoCommon.TEAM_NAME
team_abbreviationStringNoTeam abbreviation codeTeamInfoCommon.TeamInfoCommon.TEAM_ABBREVIATION
team_conferenceStringYesConference nameTeamInfoCommon.TeamInfoCommon.TEAM_CONFERENCE
team_divisionStringYesDivision nameTeamInfoCommon.TeamInfoCommon.TEAM_DIVISION
team_codeStringYesTeam code slugTeamInfoCommon.TeamInfoCommon.TEAM_CODE
team_slugStringYesURL-friendly team slugTeamInfoCommon.TeamInfoCommon.TEAM_SLUG
wInt64YesWinsTeamInfoCommon.TeamInfoCommon.W
lInt64YesLossesTeamInfoCommon.TeamInfoCommon.L
pctFloat64YesWin percentageTeamInfoCommon.TeamInfoCommon.PCT
conf_rankInt64YesConference rankingTeamInfoCommon.TeamInfoCommon.CONF_RANK
div_rankInt64YesDivision rankingTeamInfoCommon.TeamInfoCommon.DIV_RANK
min_yearStringYesFirst year of team activityTeamInfoCommon.TeamInfoCommon.MIN_YEAR
max_yearStringYesLast year of team activityTeamInfoCommon.TeamInfoCommon.MAX_YEAR

staging_win_probability

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierWinProbabilityPBP.WinProbPBP.GAME_ID
event_numInt64NoEvent sequence numberWinProbabilityPBP.WinProbPBP.EVENT_NUM
home_pctFloat64YesHome team win probabilityWinProbabilityPBP.WinProbPBP.HOME_PCT
visitor_pctFloat64YesVisitor team win probabilityWinProbabilityPBP.WinProbPBP.VISITOR_PCT
home_ptsInt64YesHome team pointsWinProbabilityPBP.WinProbPBP.HOME_PTS
visitor_ptsInt64YesVisitor team pointsWinProbabilityPBP.WinProbPBP.VISITOR_PTS
home_score_marginInt64YesHome team score marginWinProbabilityPBP.WinProbPBP.HOME_SCORE_MARGIN
periodInt64YesGame period numberWinProbabilityPBP.WinProbPBP.PERIOD
seconds_remainingFloat64YesSeconds remaining in periodWinProbabilityPBP.WinProbPBP.SECONDS_REMAINING
home_team_idInt64YesHome team identifier (FK → staging_team.team_id)WinProbabilityPBP.WinProbPBP.HOME_TEAM_ID
home_team_abbStringYesHome team abbreviation codeWinProbabilityPBP.WinProbPBP.HOME_TEAM_ABB
visitor_team_idInt64YesVisitor team identifier (FK → staging_team.team_id)WinProbabilityPBP.WinProbPBP.VISITOR_TEAM_ID
visitor_team_abbStringYesVisitor team abbreviation codeWinProbabilityPBP.WinProbPBP.VISITOR_TEAM_ABB
descriptionStringYesText description of the playWinProbabilityPBP.WinProbPBP.DESCRIPTION
locationStringYesHome or away location indicatorWinProbabilityPBP.WinProbPBP.LOCATION
pctimestringStringYesPeriod clock time stringWinProbabilityPBP.WinProbPBP.PCTIMESTRING
is_score_changeInt64YesFlag indicating if score changedWinProbabilityPBP.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.

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.

Section hub

On this page