nbadbArena Data Lab
Data DictionaryScoreboard KeyRaw44 waypoints

Stat Legend

Data Dictionary — Raw

Field-level documentation for all raw schema tables

Generated pageCommand-ownedSchema metadata

Generated field inventory

Read the raw dictionary like a source manifest

This page is exhaustive on purpose. Use it to confirm inbound field names, source result sets, and nullable behavior exactly as they landed before you switch to interpretation or warehouse-friendly naming.

Best for
Source fidelity

verify api-native names and payload shape without guessing

Less useful for
Join design

raw names preserve upstream texture more than analyst ergonomics

Ownership
Command-owned

regenerate from schema metadata instead of hand-editing

How to work this page
1

Start at the table heading

Match the `raw_*` block to the endpoint family or result set you are tracing.

2

Use the Source column as your replay marker

The source path tells you which nba_api payload field produced each row in the inventory.

3

Leave when the question becomes semantic

If the name is exact but still not meaningful, switch to the glossary or field-reference page.

Quick scan

Jump by source family before reading row by row

Use these anchor clusters to land on the right raw table block fast, then read the exact field inventory only where it matters.

43 table blocks25 Source familiesTOC-driven
Box Score

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

11

+5 more in the page TOC and section list.

Common Team

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

3
Play By

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

2
Shot Chart

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

2
Common All

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

1
Common Player

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
Franchise History

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 Season

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 Awards

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

1
Player Career

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
Playoff Picture

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
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 — Raw

raw_box_score_advanced_player

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreAdvancedV3.PlayerStats.GAME_ID
team_idInt64NoTeam identifierBoxScoreAdvancedV3.PlayerStats.TEAM_ID
team_abbreviationStringYesTeam abbreviation codeBoxScoreAdvancedV3.PlayerStats.TEAM_ABBREVIATION
team_cityStringYesTeam city nameBoxScoreAdvancedV3.PlayerStats.TEAM_CITY
player_idInt64NoUnique player identifierBoxScoreAdvancedV3.PlayerStats.PLAYER_ID
player_nameStringYesPlayer full nameBoxScoreAdvancedV3.PlayerStats.PLAYER_NAME
nicknameStringYesPlayer nicknameBoxScoreAdvancedV3.PlayerStats.NICKNAME
start_positionStringYesStarting position (F/C/G)BoxScoreAdvancedV3.PlayerStats.START_POSITION
commentStringYesPlayer status commentBoxScoreAdvancedV3.PlayerStats.COMMENT
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
tm_tov_pctFloat64YesTeam turnover percentageBoxScoreAdvancedV3.PlayerStats.TM_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
paceFloat64YesPaceBoxScoreAdvancedV3.PlayerStats.PACE
pace_per40Float64YesPace per 40 minutesBoxScoreAdvancedV3.PlayerStats.PACE_PER40
possFloat64YesPossessionsBoxScoreAdvancedV3.PlayerStats.POSS
pieFloat64YesPlayer impact estimateBoxScoreAdvancedV3.PlayerStats.PIE

raw_box_score_defensive_player

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreDefensiveV2.PlayerStats.GAME_ID
team_idInt64NoTeam identifierBoxScoreDefensiveV2.PlayerStats.TEAM_ID
team_abbreviationStringYesTeam abbreviation codeBoxScoreDefensiveV2.PlayerStats.TEAM_ABBREVIATION
team_cityStringYesTeam city nameBoxScoreDefensiveV2.PlayerStats.TEAM_CITY
player_idInt64NoUnique player identifierBoxScoreDefensiveV2.PlayerStats.PLAYER_ID
player_nameStringYesPlayer full nameBoxScoreDefensiveV2.PlayerStats.PLAYER_NAME
start_positionStringYesStarting position (F/C/G)BoxScoreDefensiveV2.PlayerStats.START_POSITION
commentStringYesPlayer status commentBoxScoreDefensiveV2.PlayerStats.COMMENT
minStringYesMinutes played as stringBoxScoreDefensiveV2.PlayerStats.MIN
matchup_minStringYesMatchup minutes as stringBoxScoreDefensiveV2.PlayerStats.MATCHUP_MIN
player_ptsFloat64YesPoints scored by playerBoxScoreDefensiveV2.PlayerStats.PLAYER_PTS
team_ptsFloat64YesPoints scored by teamBoxScoreDefensiveV2.PlayerStats.TEAM_PTS
matchup_pctFloat64YesMatchup time percentageBoxScoreDefensiveV2.PlayerStats.MATCHUP_PCT
partial_possFloat64YesPartial possessionsBoxScoreDefensiveV2.PlayerStats.PARTIAL_POSS
switches_onFloat64YesSwitches drawn on defenseBoxScoreDefensiveV2.PlayerStats.SWITCHES_ON
matchup_astFloat64YesAssists allowed in matchupBoxScoreDefensiveV2.PlayerStats.MATCHUP_AST
matchup_tovFloat64YesTurnovers forced in matchupBoxScoreDefensiveV2.PlayerStats.MATCHUP_TOV
stlFloat64YesStealsBoxScoreDefensiveV2.PlayerStats.STL
blkFloat64YesBlocksBoxScoreDefensiveV2.PlayerStats.BLK
matchup_fgmFloat64YesFG made allowed in matchupBoxScoreDefensiveV2.PlayerStats.MATCHUP_FGM
matchup_fgaFloat64YesFG attempted in matchupBoxScoreDefensiveV2.PlayerStats.MATCHUP_FGA
matchup_fg_pctFloat64YesFG percentage in matchupBoxScoreDefensiveV2.PlayerStats.MATCHUP_FG_PCT
matchup_fg3mFloat64Yes3-point FG made in matchupBoxScoreDefensiveV2.PlayerStats.MATCHUP_FG3M
matchup_fg3aFloat64Yes3-point FG attempted in matchupBoxScoreDefensiveV2.PlayerStats.MATCHUP_FG3A
matchup_fg3_pctFloat64Yes3-point FG pct in matchupBoxScoreDefensiveV2.PlayerStats.MATCHUP_FG3_PCT

raw_box_score_four_factors_player

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreFourFactorsV3.PlayerStats.GAME_ID
team_idInt64NoTeam identifierBoxScoreFourFactorsV3.PlayerStats.TEAM_ID
team_abbreviationStringYesTeam abbreviation codeBoxScoreFourFactorsV3.PlayerStats.TEAM_ABBREVIATION
team_cityStringYesTeam city nameBoxScoreFourFactorsV3.PlayerStats.TEAM_CITY
player_idInt64NoUnique player identifierBoxScoreFourFactorsV3.PlayerStats.PLAYER_ID
player_nameStringYesPlayer full nameBoxScoreFourFactorsV3.PlayerStats.PLAYER_NAME
nicknameStringYesPlayer nicknameBoxScoreFourFactorsV3.PlayerStats.NICKNAME
start_positionStringYesStarting position (F/C/G)BoxScoreFourFactorsV3.PlayerStats.START_POSITION
commentStringYesPlayer status commentBoxScoreFourFactorsV3.PlayerStats.COMMENT
minStringYesMinutes played as stringBoxScoreFourFactorsV3.PlayerStats.MIN
efg_pctFloat64YesEffective field goal percentageBoxScoreFourFactorsV3.PlayerStats.EFG_PCT
fta_rateFloat64YesFree throw attempt rateBoxScoreFourFactorsV3.PlayerStats.FTA_RATE
tm_tov_pctFloat64YesTeam turnover percentageBoxScoreFourFactorsV3.PlayerStats.TM_TOV_PCT
oreb_pctFloat64YesOffensive rebound percentageBoxScoreFourFactorsV3.PlayerStats.OREB_PCT
opp_efg_pctFloat64YesOpponent effective FG percentageBoxScoreFourFactorsV3.PlayerStats.OPP_EFG_PCT
opp_fta_rateFloat64YesOpponent free throw attempt rateBoxScoreFourFactorsV3.PlayerStats.OPP_FTA_RATE
opp_tov_pctFloat64YesOpponent turnover percentageBoxScoreFourFactorsV3.PlayerStats.OPP_TOV_PCT
opp_oreb_pctFloat64YesOpponent offensive rebound pctBoxScoreFourFactorsV3.PlayerStats.OPP_OREB_PCT

raw_box_score_hustle_player

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreHustleV2.PlayerStats.GAME_ID
team_idInt64NoTeam identifierBoxScoreHustleV2.PlayerStats.TEAM_ID
team_abbreviationStringYesTeam abbreviation codeBoxScoreHustleV2.PlayerStats.TEAM_ABBREVIATION
team_cityStringYesTeam city nameBoxScoreHustleV2.PlayerStats.TEAM_CITY
player_idInt64NoUnique player identifierBoxScoreHustleV2.PlayerStats.PLAYER_ID
player_nameStringYesPlayer full nameBoxScoreHustleV2.PlayerStats.PLAYER_NAME
start_positionStringYesStarting position (F/C/G)BoxScoreHustleV2.PlayerStats.START_POSITION
commentStringYesPlayer status commentBoxScoreHustleV2.PlayerStats.COMMENT
minStringYesMinutes played as stringBoxScoreHustleV2.PlayerStats.MIN
contested_shotsFloat64YesTotal contested shotsBoxScoreHustleV2.PlayerStats.CONTESTED_SHOTS
contested_shots_2ptFloat64YesContested 2-point shotsBoxScoreHustleV2.PlayerStats.CONTESTED_SHOTS_2PT
contested_shots_3ptFloat64YesContested 3-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_recovered_offFloat64YesOffensive loose balls recoveredBoxScoreHustleV2.PlayerStats.LOOSE_BALLS_RECOVERED_OFF
loose_balls_recovered_defFloat64YesDefensive loose balls recoveredBoxScoreHustleV2.PlayerStats.LOOSE_BALLS_RECOVERED_DEF
loose_balls_recoveredFloat64YesTotal loose balls recoveredBoxScoreHustleV2.PlayerStats.LOOSE_BALLS_RECOVERED
off_boxoutsFloat64YesOffensive box outsBoxScoreHustleV2.PlayerStats.OFF_BOXOUTS
def_boxoutsFloat64YesDefensive box outsBoxScoreHustleV2.PlayerStats.DEF_BOXOUTS
box_outsFloat64YesTotal box outsBoxScoreHustleV2.PlayerStats.BOX_OUTS

raw_box_score_matchups

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreMatchupsV3.PlayerStats.GAME_ID
off_team_idInt64YesOffensive team identifierBoxScoreMatchupsV3.PlayerStats.OFF_TEAM_ID
off_team_abbreviationStringYesOffensive team abbreviationBoxScoreMatchupsV3.PlayerStats.OFF_TEAM_ABBREVIATION
def_team_idInt64YesDefensive team identifierBoxScoreMatchupsV3.PlayerStats.DEF_TEAM_ID
def_team_abbreviationStringYesDefensive team abbreviationBoxScoreMatchupsV3.PlayerStats.DEF_TEAM_ABBREVIATION
off_player_idInt64YesOffensive player identifierBoxScoreMatchupsV3.PlayerStats.OFF_PLAYER_ID
off_player_nameStringYesOffensive player nameBoxScoreMatchupsV3.PlayerStats.OFF_PLAYER_NAME
def_player_idInt64YesDefensive player identifierBoxScoreMatchupsV3.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 attempted in matchupBoxScoreMatchupsV3.PlayerStats.MATCHUP_FGA
matchup_fg_pctFloat64YesField goal pct in matchupBoxScoreMatchupsV3.PlayerStats.MATCHUP_FG_PCT
matchup_fg3mFloat64YesThree-pointers made in matchupBoxScoreMatchupsV3.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_onFloat64YesNumber of switches onto playerBoxScoreMatchupsV3.PlayerStats.SWITCHES_ON

raw_box_score_misc_player

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreMiscV3.PlayerStats.GAME_ID
team_idInt64NoTeam identifierBoxScoreMiscV3.PlayerStats.TEAM_ID
team_abbreviationStringYesTeam abbreviation codeBoxScoreMiscV3.PlayerStats.TEAM_ABBREVIATION
team_cityStringYesTeam city nameBoxScoreMiscV3.PlayerStats.TEAM_CITY
player_idInt64NoUnique player identifierBoxScoreMiscV3.PlayerStats.PLAYER_ID
player_nameStringYesPlayer full nameBoxScoreMiscV3.PlayerStats.PLAYER_NAME
nicknameStringYesPlayer nicknameBoxScoreMiscV3.PlayerStats.NICKNAME
start_positionStringYesStarting position (F/C/G)BoxScoreMiscV3.PlayerStats.START_POSITION
commentStringYesPlayer status commentBoxScoreMiscV3.PlayerStats.COMMENT
minStringYesMinutes played as stringBoxScoreMiscV3.PlayerStats.MIN
pts_off_tovFloat64YesPoints off turnoversBoxScoreMiscV3.PlayerStats.PTS_OFF_TOV
second_chance_ptsFloat64YesSecond chance pointsBoxScoreMiscV3.PlayerStats.SECOND_CHANCE_PTS
fbpsFloat64YesFast break pointsBoxScoreMiscV3.PlayerStats.FBPS
pitpFloat64YesPoints in the paintBoxScoreMiscV3.PlayerStats.PITP
opp_pts_off_tovFloat64YesOpponent points off turnoversBoxScoreMiscV3.PlayerStats.OPP_PTS_OFF_TOV
opp_second_chance_ptsFloat64YesOpponent second chance pointsBoxScoreMiscV3.PlayerStats.OPP_SECOND_CHANCE_PTS
opp_fbpsFloat64YesOpponent fast break pointsBoxScoreMiscV3.PlayerStats.OPP_FBPS
opp_pitpFloat64YesOpponent points in the paintBoxScoreMiscV3.PlayerStats.OPP_PITP
blkFloat64YesBlocksBoxScoreMiscV3.PlayerStats.BLK
blkaFloat64YesBlocked shot attemptsBoxScoreMiscV3.PlayerStats.BLKA
pfFloat64YesPersonal foulsBoxScoreMiscV3.PlayerStats.PF
pfdFloat64YesPersonal fouls drawnBoxScoreMiscV3.PlayerStats.PFD

raw_box_score_player_track

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScorePlayerTrackV3.PlayerStats.GAME_ID
team_idInt64NoTeam identifierBoxScorePlayerTrackV3.PlayerStats.TEAM_ID
team_abbreviationStringYesTeam abbreviation codeBoxScorePlayerTrackV3.PlayerStats.TEAM_ABBREVIATION
team_cityStringYesTeam city nameBoxScorePlayerTrackV3.PlayerStats.TEAM_CITY
player_idInt64NoUnique player identifierBoxScorePlayerTrackV3.PlayerStats.PLAYER_ID
player_nameStringYesPlayer full nameBoxScorePlayerTrackV3.PlayerStats.PLAYER_NAME
nicknameStringYesPlayer nicknameBoxScorePlayerTrackV3.PlayerStats.NICKNAME
start_positionStringYesStarting position (F/C/G)BoxScorePlayerTrackV3.PlayerStats.START_POSITION
commentStringYesPlayer status commentBoxScorePlayerTrackV3.PlayerStats.COMMENT
minStringYesMinutes played as stringBoxScorePlayerTrackV3.PlayerStats.MIN
spdFloat64YesAverage speedBoxScorePlayerTrackV3.PlayerStats.SPD
distFloat64YesDistance coveredBoxScorePlayerTrackV3.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
pass_Float64YesPasses madeBoxScorePlayerTrackV3.PlayerStats.PASS
astFloat64YesAssistsBoxScorePlayerTrackV3.PlayerStats.AST
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 FG attemptedBoxScorePlayerTrackV3.PlayerStats.UFGA
ufg_pctFloat64YesUncontested field goal percentageBoxScorePlayerTrackV3.PlayerStats.UFG_PCT
fg_pctFloat64YesField goal percentageBoxScorePlayerTrackV3.PlayerStats.FG_PCT
dfgmFloat64YesDefended field goals madeBoxScorePlayerTrackV3.PlayerStats.DFGM
dfgaFloat64YesDefended field goals attemptedBoxScorePlayerTrackV3.PlayerStats.DFGA
dfg_pctFloat64YesDefended field goal percentageBoxScorePlayerTrackV3.PlayerStats.DFG_PCT

raw_box_score_scoring_player

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreScoringV3.PlayerStats.GAME_ID
team_idInt64NoTeam identifierBoxScoreScoringV3.PlayerStats.TEAM_ID
team_abbreviationStringYesTeam abbreviation codeBoxScoreScoringV3.PlayerStats.TEAM_ABBREVIATION
team_cityStringYesTeam city nameBoxScoreScoringV3.PlayerStats.TEAM_CITY
player_idInt64NoUnique player identifierBoxScoreScoringV3.PlayerStats.PLAYER_ID
player_nameStringYesPlayer full nameBoxScoreScoringV3.PlayerStats.PLAYER_NAME
nicknameStringYesPlayer nicknameBoxScoreScoringV3.PlayerStats.NICKNAME
start_positionStringYesStarting position (F/C/G)BoxScoreScoringV3.PlayerStats.START_POSITION
commentStringYesPlayer status commentBoxScoreScoringV3.PlayerStats.COMMENT
minStringYesMinutes played as stringBoxScoreScoringV3.PlayerStats.MIN
pct_fga_2ptFloat64YesPercent of FGA that are 2-pointersBoxScoreScoringV3.PlayerStats.PCT_FGA_2PT
pct_fga_3ptFloat64YesPercent of FGA that are 3-pointersBoxScoreScoringV3.PlayerStats.PCT_FGA_3PT
pct_pts_2ptFloat64YesPercent of points from 2-pointersBoxScoreScoringV3.PlayerStats.PCT_PTS_2PT
pct_pts_2pt_mrFloat64YesPercent of points from mid-rangeBoxScoreScoringV3.PlayerStats.PCT_PTS_2PT_MR
pct_pts_3ptFloat64YesPercent of points from 3-pointersBoxScoreScoringV3.PlayerStats.PCT_PTS_3PT
pct_pts_fbFloat64YesPercent of points from fast breaksBoxScoreScoringV3.PlayerStats.PCT_PTS_FB
pct_pts_ftFloat64YesPercent of points from free throwsBoxScoreScoringV3.PlayerStats.PCT_PTS_FT
pct_pts_off_tovFloat64YesPercent of points off turnoversBoxScoreScoringV3.PlayerStats.PCT_PTS_OFF_TOV
pct_pts_pitpFloat64YesPercent of points in the paintBoxScoreScoringV3.PlayerStats.PCT_PTS_PITP
pct_ast_2pmFloat64YesPercent of assisted 2-point makesBoxScoreScoringV3.PlayerStats.PCT_AST_2PM
pct_uast_2pmFloat64YesPercent of unassisted 2-point makesBoxScoreScoringV3.PlayerStats.PCT_UAST_2PM
pct_ast_3pmFloat64YesPercent of assisted 3-point makesBoxScoreScoringV3.PlayerStats.PCT_AST_3PM
pct_uast_3pmFloat64YesPercent of unassisted 3-point makesBoxScoreScoringV3.PlayerStats.PCT_UAST_3PM
pct_ast_fgmFloat64YesPercent of assisted field goal makesBoxScoreScoringV3.PlayerStats.PCT_AST_FGM
pct_uast_fgmFloat64YesPercent of unassisted FG makesBoxScoreScoringV3.PlayerStats.PCT_UAST_FGM

raw_box_score_traditional_player

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreTraditionalV3.PlayerStats.GAME_ID
team_idInt64NoTeam identifierBoxScoreTraditionalV3.PlayerStats.TEAM_ID
team_abbreviationStringYesTeam abbreviation codeBoxScoreTraditionalV3.PlayerStats.TEAM_ABBREVIATION
team_cityStringYesTeam city nameBoxScoreTraditionalV3.PlayerStats.TEAM_CITY
player_idInt64NoUnique player identifierBoxScoreTraditionalV3.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
tovFloat64YesTurnovers (alias TO in some versions)BoxScoreTraditionalV3.PlayerStats.TOV
pfFloat64YesPersonal foulsBoxScoreTraditionalV3.PlayerStats.PF
ptsFloat64YesPoints scoredBoxScoreTraditionalV3.PlayerStats.PTS
plus_minusFloat64YesPlus-minus differentialBoxScoreTraditionalV3.PlayerStats.PLUS_MINUS

raw_box_score_traditional_team

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreTraditionalV3.TeamStats.GAME_ID
team_idInt64NoTeam identifierBoxScoreTraditionalV3.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

raw_box_score_usage_player

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierBoxScoreUsageV3.PlayerStats.GAME_ID
team_idInt64NoTeam identifierBoxScoreUsageV3.PlayerStats.TEAM_ID
team_abbreviationStringYesTeam abbreviation codeBoxScoreUsageV3.PlayerStats.TEAM_ABBREVIATION
team_cityStringYesTeam city nameBoxScoreUsageV3.PlayerStats.TEAM_CITY
player_idInt64NoUnique player identifierBoxScoreUsageV3.PlayerStats.PLAYER_ID
player_nameStringYesPlayer full nameBoxScoreUsageV3.PlayerStats.PLAYER_NAME
nicknameStringYesPlayer nicknameBoxScoreUsageV3.PlayerStats.NICKNAME
start_positionStringYesStarting position (F/C/G)BoxScoreUsageV3.PlayerStats.START_POSITION
commentStringYesPlayer status commentBoxScoreUsageV3.PlayerStats.COMMENT
minStringYesMinutes played as stringBoxScoreUsageV3.PlayerStats.MIN
usg_pctFloat64YesUsage percentageBoxScoreUsageV3.PlayerStats.USG_PCT
pct_fgmFloat64YesPercent of team field goals madeBoxScoreUsageV3.PlayerStats.PCT_FGM
pct_fgaFloat64YesPercent of team FG attemptedBoxScoreUsageV3.PlayerStats.PCT_FGA
pct_fg3mFloat64YesPercent of team 3-point FG madeBoxScoreUsageV3.PlayerStats.PCT_FG3M
pct_fg3aFloat64YesPercent of team 3-point FG attemptedBoxScoreUsageV3.PlayerStats.PCT_FG3A
pct_ftmFloat64YesPercent of team free throws madeBoxScoreUsageV3.PlayerStats.PCT_FTM
pct_ftaFloat64YesPercent of team FT attemptedBoxScoreUsageV3.PlayerStats.PCT_FTA
pct_orebFloat64YesPercent of team offensive reboundsBoxScoreUsageV3.PlayerStats.PCT_OREB
pct_drebFloat64YesPercent of team defensive reboundsBoxScoreUsageV3.PlayerStats.PCT_DREB
pct_rebFloat64YesPercent of team total reboundsBoxScoreUsageV3.PlayerStats.PCT_REB
pct_astFloat64YesPercent of team assistsBoxScoreUsageV3.PlayerStats.PCT_AST
pct_tovFloat64YesPercent of team turnoversBoxScoreUsageV3.PlayerStats.PCT_TOV
pct_stlFloat64YesPercent of team stealsBoxScoreUsageV3.PlayerStats.PCT_STL
pct_blkFloat64YesPercent of team blocksBoxScoreUsageV3.PlayerStats.PCT_BLK
pct_blkaFloat64YesPercent of team blocked attemptsBoxScoreUsageV3.PlayerStats.PCT_BLKA
pct_pfFloat64YesPercent of team personal foulsBoxScoreUsageV3.PlayerStats.PCT_PF
pct_pfdFloat64YesPercent of team personal fouls drawnBoxScoreUsageV3.PlayerStats.PCT_PFD
pct_ptsFloat64YesPercent of team pointsBoxScoreUsageV3.PlayerStats.PCT_PTS

raw_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_lastStringYesPlayer 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 identifierCommonAllPlayers.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

raw_common_player_info

ColumnTypeNullableDescriptionSource
person_idInt64NoUnique player identifierCommonPlayerInfo.CommonPlayerInfo.PERSON_ID
first_nameStringYesPlayer first nameCommonPlayerInfo.CommonPlayerInfo.FIRST_NAME
last_nameStringYesPlayer last nameCommonPlayerInfo.CommonPlayerInfo.LAST_NAME
display_first_lastStringYesPlayer name as First LastCommonPlayerInfo.CommonPlayerInfo.DISPLAY_FIRST_LAST
display_last_comma_firstStringYesPlayer name as Last, FirstCommonPlayerInfo.CommonPlayerInfo.DISPLAY_LAST_COMMA_FIRST
display_fi_lastStringYesPlayer name as F. LastCommonPlayerInfo.CommonPlayerInfo.DISPLAY_FI_LAST
player_slugStringYesURL-friendly player slugCommonPlayerInfo.CommonPlayerInfo.PLAYER_SLUG
birthdateStringYesPlayer date of birthCommonPlayerInfo.CommonPlayerInfo.BIRTHDATE
schoolStringYesSchool or college attendedCommonPlayerInfo.CommonPlayerInfo.SCHOOL
countryStringYesCountry of originCommonPlayerInfo.CommonPlayerInfo.COUNTRY
last_affiliationStringYesLast team or school affiliationCommonPlayerInfo.CommonPlayerInfo.LAST_AFFILIATION
heightStringYesPlayer height as stringCommonPlayerInfo.CommonPlayerInfo.HEIGHT
weightStringYesPlayer weight as stringCommonPlayerInfo.CommonPlayerInfo.WEIGHT
season_expInt64YesYears of NBA experienceCommonPlayerInfo.CommonPlayerInfo.SEASON_EXP
jerseyStringYesJersey number as stringCommonPlayerInfo.CommonPlayerInfo.JERSEY
positionStringYesPlayer positionCommonPlayerInfo.CommonPlayerInfo.POSITION
roster_statusStringYesCurrent roster statusCommonPlayerInfo.CommonPlayerInfo.ROSTER_STATUS
games_played_current_season_flagStringYesFlag for games played this seasonCommonPlayerInfo.CommonPlayerInfo.GAMES_PLAYED_CURRENT_SEASON_FLAG
team_idInt64YesTeam identifierCommonPlayerInfo.CommonPlayerInfo.TEAM_ID
team_nameStringYesTeam nameCommonPlayerInfo.CommonPlayerInfo.TEAM_NAME
team_abbreviationStringYesTeam abbreviation codeCommonPlayerInfo.CommonPlayerInfo.TEAM_ABBREVIATION
team_codeStringYesTeam code slugCommonPlayerInfo.CommonPlayerInfo.TEAM_CODE
team_cityStringYesTeam city nameCommonPlayerInfo.CommonPlayerInfo.TEAM_CITY
playercodeStringYesPlayer code slugCommonPlayerInfo.CommonPlayerInfo.PLAYERCODE
from_yearInt64YesFirst year in the leagueCommonPlayerInfo.CommonPlayerInfo.FROM_YEAR
to_yearInt64YesLast year in the leagueCommonPlayerInfo.CommonPlayerInfo.TO_YEAR
dleague_flagStringYesG-League eligibility flagCommonPlayerInfo.CommonPlayerInfo.DLEAGUE_FLAG
nba_flagStringYesNBA eligibility flagCommonPlayerInfo.CommonPlayerInfo.NBA_FLAG
games_played_flagStringYesFlag indicating games playedCommonPlayerInfo.CommonPlayerInfo.GAMES_PLAYED_FLAG
draft_yearStringYesYear draftedCommonPlayerInfo.CommonPlayerInfo.DRAFT_YEAR
draft_roundStringYesRound draftedCommonPlayerInfo.CommonPlayerInfo.DRAFT_ROUND
draft_numberStringYesOverall draft pick numberCommonPlayerInfo.CommonPlayerInfo.DRAFT_NUMBER
greatest_75_flagStringYesNBA 75th anniversary team flagCommonPlayerInfo.CommonPlayerInfo.GREATEST_75_FLAG

raw_common_team_roster_coaches

ColumnTypeNullableDescriptionSource
team_idInt64NoUnique team identifierCommonTeamRoster.Coaches.TEAM_ID
seasonStringYesSeason stringCommonTeamRoster.Coaches.SEASON
coach_idInt64YesUnique coach identifierCommonTeamRoster.Coaches.COACH_ID
first_nameStringYesCoach first nameCommonTeamRoster.Coaches.FIRST_NAME
last_nameStringYesCoach last nameCommonTeamRoster.Coaches.LAST_NAME
coach_nameStringYesCoach full nameCommonTeamRoster.Coaches.COACH_NAME
is_assistantInt64YesFlag indicating assistant coachCommonTeamRoster.Coaches.IS_ASSISTANT
coach_typeStringYesType of coaching roleCommonTeamRoster.Coaches.COACH_TYPE
sort_sequenceInt64YesDisplay sort orderCommonTeamRoster.Coaches.SORT_SEQUENCE
sub_sort_sequenceInt64YesSecondary display sort orderCommonTeamRoster.Coaches.SUB_SORT_SEQUENCE
schoolStringYesSchool or college attendedCommonTeamRoster.Coaches.SCHOOL

raw_common_team_roster

ColumnTypeNullableDescriptionSource
teamidInt64NoUnique team identifierCommonTeamRoster.CommonTeamRoster.TeamID
seasonStringYesSeason stringCommonTeamRoster.CommonTeamRoster.SEASON
leagueidStringYesLeague identifierCommonTeamRoster.CommonTeamRoster.LeagueID
playerStringYesPlayer full nameCommonTeamRoster.CommonTeamRoster.PLAYER
nicknameStringYesPlayer nicknameCommonTeamRoster.CommonTeamRoster.NICKNAME
player_slugStringYesURL-friendly player slugCommonTeamRoster.CommonTeamRoster.PLAYER_SLUG
numStringYesJersey number as stringCommonTeamRoster.CommonTeamRoster.NUM
positionStringYesPlayer positionCommonTeamRoster.CommonTeamRoster.POSITION
heightStringYesPlayer height as stringCommonTeamRoster.CommonTeamRoster.HEIGHT
weightStringYesPlayer weight as stringCommonTeamRoster.CommonTeamRoster.WEIGHT
birth_dateStringYesPlayer date of birthCommonTeamRoster.CommonTeamRoster.BIRTH_DATE
ageFloat64YesPlayer ageCommonTeamRoster.CommonTeamRoster.AGE
expStringYesYears of experience as stringCommonTeamRoster.CommonTeamRoster.EXP
schoolStringYesSchool or college attendedCommonTeamRoster.CommonTeamRoster.SCHOOL
player_idInt64YesUnique player identifierCommonTeamRoster.CommonTeamRoster.PLAYER_ID
how_acquiredStringYesHow the player was acquiredCommonTeamRoster.CommonTeamRoster.HOW_ACQUIRED

raw_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
abbreviationStringYesTeam abbreviation codeCommonTeamYears.TeamYears.ABBREVIATION

raw_draft_combine_drill_results

ColumnTypeNullableDescriptionSource
seasonStringNoCombine season yearDraftCombineDrillResults.Results.SEASON
player_idInt64NoUnique player identifierDraftCombineDrillResults.Results.PLAYER_ID
first_nameStringYesPlayer first nameDraftCombineDrillResults.Results.FIRST_NAME
last_nameStringYesPlayer last nameDraftCombineDrillResults.Results.LAST_NAME
player_nameStringYesPlayer full nameDraftCombineDrillResults.Results.PLAYER_NAME
positionStringYesPlayer positionDraftCombineDrillResults.Results.POSITION
standing_vertical_leapFloat64YesStanding vertical leap in inchesDraftCombineDrillResults.Results.STANDING_VERTICAL_LEAP
max_vertical_leapFloat64YesMaximum vertical leap in inchesDraftCombineDrillResults.Results.MAX_VERTICAL_LEAP
lane_agility_timeFloat64YesLane agility drill time in secondsDraftCombineDrillResults.Results.LANE_AGILITY_TIME
modified_lane_agility_timeFloat64YesModified lane agility time in secondsDraftCombineDrillResults.Results.MODIFIED_LANE_AGILITY_TIME
three_quarter_sprintFloat64YesThree-quarter court sprint time in secondsDraftCombineDrillResults.Results.THREE_QUARTER_SPRINT
bench_pressFloat64YesBench press repetitionsDraftCombineDrillResults.Results.BENCH_PRESS

raw_draft_combine_non_stationary_shooting

ColumnTypeNullableDescriptionSource
seasonStringNoCombine season yearDraftCombineNonStationaryShooting.Results.SEASON
player_idInt64NoUnique player identifierDraftCombineNonStationaryShooting.Results.PLAYER_ID
first_nameStringYesPlayer first nameDraftCombineNonStationaryShooting.Results.FIRST_NAME
last_nameStringYesPlayer last nameDraftCombineNonStationaryShooting.Results.LAST_NAME
player_nameStringYesPlayer full nameDraftCombineNonStationaryShooting.Results.PLAYER_NAME
positionStringYesPlayer positionDraftCombineNonStationaryShooting.Results.POSITION
off_drib_fifteen_break_left_madeInt64YesOff-dribble fifteen-foot break left shots madeDraftCombineNonStationaryShooting.Results.OFF_DRIB_FIFTEEN_BREAK_LEFT_MADE
off_drib_fifteen_break_left_attemptInt64YesOff-dribble fifteen-foot break left shots attemptedDraftCombineNonStationaryShooting.Results.OFF_DRIB_FIFTEEN_BREAK_LEFT_ATTEMPT
off_drib_fifteen_break_left_pctFloat64YesOff-dribble fifteen-foot break left shooting percentageDraftCombineNonStationaryShooting.Results.OFF_DRIB_FIFTEEN_BREAK_LEFT_PCT
off_drib_fifteen_top_key_madeInt64YesOff-dribble fifteen-foot top of key shots madeDraftCombineNonStationaryShooting.Results.OFF_DRIB_FIFTEEN_TOP_KEY_MADE
off_drib_fifteen_top_key_attemptInt64YesOff-dribble fifteen-foot top of key shots attemptedDraftCombineNonStationaryShooting.Results.OFF_DRIB_FIFTEEN_TOP_KEY_ATTEMPT
off_drib_fifteen_top_key_pctFloat64YesOff-dribble fifteen-foot top of key shooting percentageDraftCombineNonStationaryShooting.Results.OFF_DRIB_FIFTEEN_TOP_KEY_PCT
off_drib_college_break_left_madeInt64YesOff-dribble college break left shots madeDraftCombineNonStationaryShooting.Results.OFF_DRIB_COLLEGE_BREAK_LEFT_MADE
off_drib_college_break_left_attemptInt64YesOff-dribble college break left shots attemptedDraftCombineNonStationaryShooting.Results.OFF_DRIB_COLLEGE_BREAK_LEFT_ATTEMPT
off_drib_college_break_left_pctFloat64YesOff-dribble college break left shooting percentageDraftCombineNonStationaryShooting.Results.OFF_DRIB_COLLEGE_BREAK_LEFT_PCT
off_drib_college_top_key_madeInt64YesOff-dribble college top of key shots madeDraftCombineNonStationaryShooting.Results.OFF_DRIB_COLLEGE_TOP_KEY_MADE
off_drib_college_top_key_attemptInt64YesOff-dribble college top of key shots attemptedDraftCombineNonStationaryShooting.Results.OFF_DRIB_COLLEGE_TOP_KEY_ATTEMPT
off_drib_college_top_key_pctFloat64YesOff-dribble college top of key shooting percentageDraftCombineNonStationaryShooting.Results.OFF_DRIB_COLLEGE_TOP_KEY_PCT
on_move_fifteen_madeInt64YesOn-move fifteen-foot shots madeDraftCombineNonStationaryShooting.Results.ON_MOVE_FIFTEEN_MADE
on_move_fifteen_attemptInt64YesOn-move fifteen-foot shots attemptedDraftCombineNonStationaryShooting.Results.ON_MOVE_FIFTEEN_ATTEMPT
on_move_fifteen_pctFloat64YesOn-move fifteen-foot shooting percentageDraftCombineNonStationaryShooting.Results.ON_MOVE_FIFTEEN_PCT
on_move_college_madeInt64YesOn-move college range shots madeDraftCombineNonStationaryShooting.Results.ON_MOVE_COLLEGE_MADE
on_move_college_attemptInt64YesOn-move college range shots attemptedDraftCombineNonStationaryShooting.Results.ON_MOVE_COLLEGE_ATTEMPT
on_move_college_pctFloat64YesOn-move college range shooting percentageDraftCombineNonStationaryShooting.Results.ON_MOVE_COLLEGE_PCT

raw_draft_combine_player_anthro

ColumnTypeNullableDescriptionSource
seasonStringNoCombine season yearDraftCombinePlayerAnthro.Results.SEASON
player_idInt64NoUnique player identifierDraftCombinePlayerAnthro.Results.PLAYER_ID
first_nameStringYesPlayer first nameDraftCombinePlayerAnthro.Results.FIRST_NAME
last_nameStringYesPlayer last nameDraftCombinePlayerAnthro.Results.LAST_NAME
player_nameStringYesPlayer full nameDraftCombinePlayerAnthro.Results.PLAYER_NAME
positionStringYesPlayer positionDraftCombinePlayerAnthro.Results.POSITION
height_wo_shoesFloat64YesHeight without shoes in inchesDraftCombinePlayerAnthro.Results.HEIGHT_WO_SHOES
height_wo_shoes_ft_inStringYesHeight without shoes in feet-inchesDraftCombinePlayerAnthro.Results.HEIGHT_WO_SHOES_FT_IN
height_w_shoesFloat64YesHeight with shoes in inchesDraftCombinePlayerAnthro.Results.HEIGHT_W_SHOES
height_w_shoes_ft_inStringYesHeight with shoes in feet-inchesDraftCombinePlayerAnthro.Results.HEIGHT_W_SHOES_FT_IN
weightFloat64YesPlayer weight in poundsDraftCombinePlayerAnthro.Results.WEIGHT
wingspanFloat64YesWingspan in inchesDraftCombinePlayerAnthro.Results.WINGSPAN
wingspan_ft_inStringYesWingspan in feet-inchesDraftCombinePlayerAnthro.Results.WINGSPAN_FT_IN
standing_reachFloat64YesStanding reach in inchesDraftCombinePlayerAnthro.Results.STANDING_REACH
standing_reach_ft_inStringYesStanding reach in feet-inchesDraftCombinePlayerAnthro.Results.STANDING_REACH_FT_IN
body_fat_pctFloat64YesBody fat percentageDraftCombinePlayerAnthro.Results.BODY_FAT_PCT
hand_lengthFloat64YesHand length in inchesDraftCombinePlayerAnthro.Results.HAND_LENGTH
hand_widthFloat64YesHand width in inchesDraftCombinePlayerAnthro.Results.HAND_WIDTH

raw_draft_combine_spot_shooting

ColumnTypeNullableDescriptionSource
seasonStringNoCombine season yearDraftCombineSpotShooting.Results.SEASON
player_idInt64NoUnique player identifierDraftCombineSpotShooting.Results.PLAYER_ID
first_nameStringYesPlayer first nameDraftCombineSpotShooting.Results.FIRST_NAME
last_nameStringYesPlayer last nameDraftCombineSpotShooting.Results.LAST_NAME
player_nameStringYesPlayer full nameDraftCombineSpotShooting.Results.PLAYER_NAME
positionStringYesPlayer positionDraftCombineSpotShooting.Results.POSITION
nba_break_left_madeInt64YesNBA break left shots madeDraftCombineSpotShooting.Results.NBA_BREAK_LEFT_MADE
nba_break_left_attemptInt64YesNBA break left shots attemptedDraftCombineSpotShooting.Results.NBA_BREAK_LEFT_ATTEMPT
nba_break_left_pctFloat64YesNBA break left shooting percentageDraftCombineSpotShooting.Results.NBA_BREAK_LEFT_PCT
nba_break_right_madeInt64YesNBA break right shots madeDraftCombineSpotShooting.Results.NBA_BREAK_RIGHT_MADE
nba_break_right_attemptInt64YesNBA break right shots attemptedDraftCombineSpotShooting.Results.NBA_BREAK_RIGHT_ATTEMPT
nba_break_right_pctFloat64YesNBA break right shooting percentageDraftCombineSpotShooting.Results.NBA_BREAK_RIGHT_PCT
nba_corner_left_madeInt64YesNBA corner left shots madeDraftCombineSpotShooting.Results.NBA_CORNER_LEFT_MADE
nba_corner_left_attemptInt64YesNBA corner left shots attemptedDraftCombineSpotShooting.Results.NBA_CORNER_LEFT_ATTEMPT
nba_corner_left_pctFloat64YesNBA corner left shooting percentageDraftCombineSpotShooting.Results.NBA_CORNER_LEFT_PCT
nba_corner_right_madeInt64YesNBA corner right shots madeDraftCombineSpotShooting.Results.NBA_CORNER_RIGHT_MADE
nba_corner_right_attemptInt64YesNBA corner right shots attemptedDraftCombineSpotShooting.Results.NBA_CORNER_RIGHT_ATTEMPT
nba_corner_right_pctFloat64YesNBA corner right shooting percentageDraftCombineSpotShooting.Results.NBA_CORNER_RIGHT_PCT
nba_top_key_madeInt64YesNBA top of key shots madeDraftCombineSpotShooting.Results.NBA_TOP_KEY_MADE
nba_top_key_attemptInt64YesNBA top of key shots attemptedDraftCombineSpotShooting.Results.NBA_TOP_KEY_ATTEMPT
nba_top_key_pctFloat64YesNBA top of key shooting percentageDraftCombineSpotShooting.Results.NBA_TOP_KEY_PCT
college_break_left_madeInt64YesCollege break left shots madeDraftCombineSpotShooting.Results.COLLEGE_BREAK_LEFT_MADE
college_break_left_attemptInt64YesCollege break left shots attemptedDraftCombineSpotShooting.Results.COLLEGE_BREAK_LEFT_ATTEMPT
college_break_left_pctFloat64YesCollege break left shooting percentageDraftCombineSpotShooting.Results.COLLEGE_BREAK_LEFT_PCT
college_break_right_madeInt64YesCollege break right shots madeDraftCombineSpotShooting.Results.COLLEGE_BREAK_RIGHT_MADE
college_break_right_attemptInt64YesCollege break right shots attemptedDraftCombineSpotShooting.Results.COLLEGE_BREAK_RIGHT_ATTEMPT
college_break_right_pctFloat64YesCollege break right shooting percentageDraftCombineSpotShooting.Results.COLLEGE_BREAK_RIGHT_PCT
college_corner_left_madeInt64YesCollege corner left shots madeDraftCombineSpotShooting.Results.COLLEGE_CORNER_LEFT_MADE
college_corner_left_attemptInt64YesCollege corner left shots attemptedDraftCombineSpotShooting.Results.COLLEGE_CORNER_LEFT_ATTEMPT
college_corner_left_pctFloat64YesCollege corner left shooting percentageDraftCombineSpotShooting.Results.COLLEGE_CORNER_LEFT_PCT
college_corner_right_madeInt64YesCollege corner right shots madeDraftCombineSpotShooting.Results.COLLEGE_CORNER_RIGHT_MADE
college_corner_right_attemptInt64YesCollege corner right shots attemptedDraftCombineSpotShooting.Results.COLLEGE_CORNER_RIGHT_ATTEMPT
college_corner_right_pctFloat64YesCollege corner right shooting percentageDraftCombineSpotShooting.Results.COLLEGE_CORNER_RIGHT_PCT
college_top_key_madeInt64YesCollege top of key shots madeDraftCombineSpotShooting.Results.COLLEGE_TOP_KEY_MADE
college_top_key_attemptInt64YesCollege top of key shots attemptedDraftCombineSpotShooting.Results.COLLEGE_TOP_KEY_ATTEMPT
college_top_key_pctFloat64YesCollege top of key shooting percentageDraftCombineSpotShooting.Results.COLLEGE_TOP_KEY_PCT
fifteen_break_left_madeInt64YesFifteen-foot break left shots madeDraftCombineSpotShooting.Results.FIFTEEN_BREAK_LEFT_MADE
fifteen_break_left_attemptInt64YesFifteen-foot break left shots attemptedDraftCombineSpotShooting.Results.FIFTEEN_BREAK_LEFT_ATTEMPT
fifteen_break_left_pctFloat64YesFifteen-foot break left shooting percentageDraftCombineSpotShooting.Results.FIFTEEN_BREAK_LEFT_PCT
fifteen_break_right_madeInt64YesFifteen-foot break right shots madeDraftCombineSpotShooting.Results.FIFTEEN_BREAK_RIGHT_MADE
fifteen_break_right_attemptInt64YesFifteen-foot break right shots attemptedDraftCombineSpotShooting.Results.FIFTEEN_BREAK_RIGHT_ATTEMPT
fifteen_break_right_pctFloat64YesFifteen-foot break right shooting percentageDraftCombineSpotShooting.Results.FIFTEEN_BREAK_RIGHT_PCT
fifteen_corner_left_madeInt64YesFifteen-foot corner left shots madeDraftCombineSpotShooting.Results.FIFTEEN_CORNER_LEFT_MADE
fifteen_corner_left_attemptInt64YesFifteen-foot corner left shots attemptedDraftCombineSpotShooting.Results.FIFTEEN_CORNER_LEFT_ATTEMPT
fifteen_corner_left_pctFloat64YesFifteen-foot corner left shooting percentageDraftCombineSpotShooting.Results.FIFTEEN_CORNER_LEFT_PCT
fifteen_corner_right_madeInt64YesFifteen-foot corner right shots madeDraftCombineSpotShooting.Results.FIFTEEN_CORNER_RIGHT_MADE
fifteen_corner_right_attemptInt64YesFifteen-foot corner right shots attemptedDraftCombineSpotShooting.Results.FIFTEEN_CORNER_RIGHT_ATTEMPT
fifteen_corner_right_pctFloat64YesFifteen-foot corner right shooting percentageDraftCombineSpotShooting.Results.FIFTEEN_CORNER_RIGHT_PCT
fifteen_top_key_madeInt64YesFifteen-foot top of key shots madeDraftCombineSpotShooting.Results.FIFTEEN_TOP_KEY_MADE
fifteen_top_key_attemptInt64YesFifteen-foot top of key shots attemptedDraftCombineSpotShooting.Results.FIFTEEN_TOP_KEY_ATTEMPT
fifteen_top_key_pctFloat64YesFifteen-foot top of key shooting percentageDraftCombineSpotShooting.Results.FIFTEEN_TOP_KEY_PCT

raw_draft_combine_stats

ColumnTypeNullableDescriptionSource
seasonStringNoCombine season yearDraftCombineStats.DraftCombineStats.SEASON
player_idInt64NoUnique player identifierDraftCombineStats.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

raw_draft_history

ColumnTypeNullableDescriptionSource
person_idInt64NoUnique player identifierDraftHistory.DraftHistory.PERSON_ID
player_nameStringYesPlayer full nameDraftHistory.DraftHistory.PLAYER_NAME
seasonStringYesDraft 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 identifierDraftHistory.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

raw_franchise_history

ColumnTypeNullableDescriptionSource
league_idStringNoLeague identifierFranchiseHistory.FranchiseHistory.LEAGUE_ID
team_idInt64NoUnique team identifierFranchiseHistory.FranchiseHistory.TEAM_ID
team_cityStringYesTeam city nameFranchiseHistory.FranchiseHistory.TEAM_CITY
team_nameStringYesTeam nameFranchiseHistory.FranchiseHistory.TEAM_NAME
start_yearStringYesFirst year of franchise eraFranchiseHistory.FranchiseHistory.START_YEAR
end_yearStringYesLast year of franchise eraFranchiseHistory.FranchiseHistory.END_YEAR
yearsInt64YesTotal years in franchise eraFranchiseHistory.FranchiseHistory.YEARS
gamesInt64YesTotal games playedFranchiseHistory.FranchiseHistory.GAMES
winsInt64YesTotal winsFranchiseHistory.FranchiseHistory.WINS
lossesInt64YesTotal lossesFranchiseHistory.FranchiseHistory.LOSSES
win_pctFloat64YesWin percentageFranchiseHistory.FranchiseHistory.WIN_PCT
po_appearancesInt64YesPlayoff appearances countFranchiseHistory.FranchiseHistory.PO_APPEARANCES
div_titlesInt64YesDivision titles wonFranchiseHistory.FranchiseHistory.DIV_TITLES
conf_titlesInt64YesConference titles wonFranchiseHistory.FranchiseHistory.CONF_TITLES
league_titlesInt64YesLeague championships wonFranchiseHistory.FranchiseHistory.LEAGUE_TITLES

raw_game_rotation

ColumnTypeNullableDescriptionSource
game_idStringNoUnique game identifierGameRotation.HomeTeam.GAME_ID
team_idInt64YesTeam identifierGameRotation.HomeTeam.TEAM_ID
team_cityStringYesTeam city nameGameRotation.HomeTeam.TEAM_CITY
team_nameStringYesTeam nameGameRotation.HomeTeam.TEAM_NAME
person_idInt64YesPlayer person identifierGameRotation.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

raw_league_game_log

ColumnTypeNullableDescriptionSource
season_idStringNoSeason identifierLeagueGameLog.LeagueGameLog.SEASON_ID
team_idInt64NoUnique team identifierLeagueGameLog.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

raw_league_season_matchups

ColumnTypeNullableDescriptionSource
off_player_idInt64YesOffensive player identifierLeagueSeasonMatchups.SeasonMatchups.OFF_PLAYER_ID
off_player_nameStringYesOffensive player nameLeagueSeasonMatchups.SeasonMatchups.OFF_PLAYER_NAME
def_player_idInt64YesDefensive player identifierLeagueSeasonMatchups.SeasonMatchups.DEF_PLAYER_ID
def_player_nameStringYesDefensive player nameLeagueSeasonMatchups.SeasonMatchups.DEF_PLAYER_NAME
gpInt64YesGames playedLeagueSeasonMatchups.SeasonMatchups.GP
matchup_minFloat64YesMinutes in matchupLeagueSeasonMatchups.SeasonMatchups.MATCHUP_MIN
partial_possFloat64YesPartial possessions in matchupLeagueSeasonMatchups.SeasonMatchups.PARTIAL_POSS
player_ptsFloat64YesPlayer points in matchupLeagueSeasonMatchups.SeasonMatchups.PLAYER_PTS
team_ptsFloat64YesTeam points in matchupLeagueSeasonMatchups.SeasonMatchups.TEAM_PTS
matchup_astFloat64YesAssists in matchupLeagueSeasonMatchups.SeasonMatchups.MATCHUP_AST
matchup_tovFloat64YesTurnovers in matchupLeagueSeasonMatchups.SeasonMatchups.MATCHUP_TOV
matchup_blkFloat64YesBlocks in matchupLeagueSeasonMatchups.SeasonMatchups.MATCHUP_BLK
matchup_fgmFloat64YesField goals made in matchupLeagueSeasonMatchups.SeasonMatchups.MATCHUP_FGM
matchup_fgaFloat64YesField goals attempted in matchupLeagueSeasonMatchups.SeasonMatchups.MATCHUP_FGA
matchup_fg_pctFloat64YesField goal pct in matchupLeagueSeasonMatchups.SeasonMatchups.MATCHUP_FG_PCT
matchup_fg3mFloat64YesThree-pointers made in matchupLeagueSeasonMatchups.SeasonMatchups.MATCHUP_FG3M
matchup_fg3aFloat64YesThree-pointers attemptedLeagueSeasonMatchups.SeasonMatchups.MATCHUP_FG3A
matchup_fg3_pctFloat64YesThree-point pct in matchupLeagueSeasonMatchups.SeasonMatchups.MATCHUP_FG3_PCT
help_blkFloat64YesHelp blocks in matchupLeagueSeasonMatchups.SeasonMatchups.HELP_BLK
help_fgmFloat64YesHelp field goals madeLeagueSeasonMatchups.SeasonMatchups.HELP_FGM
help_fgaFloat64YesHelp field goals attemptedLeagueSeasonMatchups.SeasonMatchups.HELP_FGA
help_fg_pctFloat64YesHelp field goal percentageLeagueSeasonMatchups.SeasonMatchups.HELP_FG_PCT
matchup_ftmFloat64YesFree throws made in matchupLeagueSeasonMatchups.SeasonMatchups.MATCHUP_FTM
matchup_ftaFloat64YesFree throws attemptedLeagueSeasonMatchups.SeasonMatchups.MATCHUP_FTA
switches_onFloat64YesNumber of switches onto playerLeagueSeasonMatchups.SeasonMatchups.SWITCHES_ON
pct_switchedFloat64YesPercentage of possessions switchedLeagueSeasonMatchups.SeasonMatchups.PCT_SWITCHED

raw_league_standings_v3

ColumnTypeNullableDescriptionSource
league_idStringNoLeague identifierLeagueStandingsV3.Standings.LeagueID
season_idStringYesSeason identifierLeagueStandingsV3.Standings.SeasonID
team_idInt64NoUnique team identifierLeagueStandingsV3.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

raw_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 identifierPlayByPlayV2.PlayByPlay.PLAYER1_ID
player1_nameStringYesPlayer 1 full namePlayByPlayV2.PlayByPlay.PLAYER1_NAME
player1_team_idInt64YesPlayer 1 team identifierPlayByPlayV2.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 identifierPlayByPlayV2.PlayByPlay.PLAYER2_ID
player2_nameStringYesPlayer 2 full namePlayByPlayV2.PlayByPlay.PLAYER2_NAME
player2_team_idInt64YesPlayer 2 team identifierPlayByPlayV2.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 identifierPlayByPlayV2.PlayByPlay.PLAYER3_ID
player3_nameStringYesPlayer 3 full namePlayByPlayV2.PlayByPlay.PLAYER3_NAME
player3_team_idInt64YesPlayer 3 team identifierPlayByPlayV2.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

raw_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 identifierPlayByPlayV3.PlayByPlay.TEAM_ID
team_tricodeStringYesThree-letter team abbreviation codePlayByPlayV3.PlayByPlay.TEAM_TRICODE
person_idInt64YesPerson identifierPlayByPlayV3.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

raw_player_awards

ColumnTypeNullableDescriptionSource
person_idInt64NoUnique player identifierPlayerAwards.PlayerAwards.PERSON_ID
first_nameStringYesPlayer first namePlayerAwards.PlayerAwards.FIRST_NAME
last_nameStringYesPlayer last namePlayerAwards.PlayerAwards.LAST_NAME
teamStringYesTeam name at time of awardPlayerAwards.PlayerAwards.TEAM
descriptionStringYesAward descriptionPlayerAwards.PlayerAwards.DESCRIPTION
all_nba_team_numberInt64YesAll-NBA team number selectionPlayerAwards.PlayerAwards.ALL_NBA_TEAM_NUMBER
seasonStringYesSeason of the awardPlayerAwards.PlayerAwards.SEASON
monthStringYesMonth of the award if applicablePlayerAwards.PlayerAwards.MONTH
weekStringYesWeek of the award if applicablePlayerAwards.PlayerAwards.WEEK
conferenceStringYesConference for the awardPlayerAwards.PlayerAwards.CONFERENCE
typeStringYesAward type categoryPlayerAwards.PlayerAwards.TYPE
subtype1StringYesAward subtype level 1PlayerAwards.PlayerAwards.SUBTYPE1
subtype2StringYesAward subtype level 2PlayerAwards.PlayerAwards.SUBTYPE2
subtype3StringYesAward subtype level 3PlayerAwards.PlayerAwards.SUBTYPE3

raw_player_career_stats

ColumnTypeNullableDescriptionSource
player_idInt64NoUnique player identifierPlayerCareerStats.SeasonTotalsRegularSeason.PLAYER_ID
season_idStringYesSeason identifier stringPlayerCareerStats.SeasonTotalsRegularSeason.SEASON_ID
league_idStringYesLeague identifierPlayerCareerStats.SeasonTotalsRegularSeason.LEAGUE_ID
team_idInt64YesTeam identifierPlayerCareerStats.SeasonTotalsRegularSeason.TEAM_ID
team_abbreviationStringYesTeam abbreviation codePlayerCareerStats.SeasonTotalsRegularSeason.TEAM_ABBREVIATION
player_ageFloat64YesPlayer age during seasonPlayerCareerStats.SeasonTotalsRegularSeason.PLAYER_AGE
gpInt64YesGames playedPlayerCareerStats.SeasonTotalsRegularSeason.GP
gsInt64YesGames startedPlayerCareerStats.SeasonTotalsRegularSeason.GS
minFloat64YesMinutes playedPlayerCareerStats.SeasonTotalsRegularSeason.MIN
fgmFloat64YesField goals madePlayerCareerStats.SeasonTotalsRegularSeason.FGM
fgaFloat64YesField goals attemptedPlayerCareerStats.SeasonTotalsRegularSeason.FGA
fg_pctFloat64YesField goal percentagePlayerCareerStats.SeasonTotalsRegularSeason.FG_PCT
fg3mFloat64YesThree-point field goals madePlayerCareerStats.SeasonTotalsRegularSeason.FG3M
fg3aFloat64YesThree-point field goals attemptedPlayerCareerStats.SeasonTotalsRegularSeason.FG3A
fg3_pctFloat64YesThree-point field goal percentagePlayerCareerStats.SeasonTotalsRegularSeason.FG3_PCT
ftmFloat64YesFree throws madePlayerCareerStats.SeasonTotalsRegularSeason.FTM
ftaFloat64YesFree throws attemptedPlayerCareerStats.SeasonTotalsRegularSeason.FTA
ft_pctFloat64YesFree throw percentagePlayerCareerStats.SeasonTotalsRegularSeason.FT_PCT
orebFloat64YesOffensive reboundsPlayerCareerStats.SeasonTotalsRegularSeason.OREB
drebFloat64YesDefensive reboundsPlayerCareerStats.SeasonTotalsRegularSeason.DREB
rebFloat64YesTotal reboundsPlayerCareerStats.SeasonTotalsRegularSeason.REB
astFloat64YesAssistsPlayerCareerStats.SeasonTotalsRegularSeason.AST
stlFloat64YesStealsPlayerCareerStats.SeasonTotalsRegularSeason.STL
blkFloat64YesBlocksPlayerCareerStats.SeasonTotalsRegularSeason.BLK
tovFloat64YesTurnoversPlayerCareerStats.SeasonTotalsRegularSeason.TOV
pfFloat64YesPersonal foulsPlayerCareerStats.SeasonTotalsRegularSeason.PF
ptsFloat64YesPoints scoredPlayerCareerStats.SeasonTotalsRegularSeason.PTS

raw_player_game_log

ColumnTypeNullableDescriptionSource
season_idStringNoSeason identifierPlayerGameLog.PlayerGameLog.SEASON_ID
player_idInt64NoUnique player identifierPlayerGameLog.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

raw_player_index

ColumnTypeNullableDescriptionSource
person_idInt64NoUnique player identifierPlayerIndex.PlayerIndex.PERSON_ID
player_last_nameStringYesPlayer last namePlayerIndex.PlayerIndex.PLAYER_LAST_NAME
player_first_nameStringYesPlayer first namePlayerIndex.PlayerIndex.PLAYER_FIRST_NAME
player_slugStringYesURL-friendly player slugPlayerIndex.PlayerIndex.PLAYER_SLUG
team_idInt64YesTeam identifierPlayerIndex.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

raw_playoff_picture

ColumnTypeNullableDescriptionSource
conferenceStringNoConference namePlayoffPicture.EastConfPlayoffPicture.CONFERENCE
high_seed_rankInt64YesHigher seed rankPlayoffPicture.EastConfPlayoffPicture.HIGH_SEED_RANK
high_seed_teamStringYesHigher seed team namePlayoffPicture.EastConfPlayoffPicture.HIGH_SEED_TEAM
high_seed_team_idInt64YesHigher seed team identifierPlayoffPicture.EastConfPlayoffPicture.HIGH_SEED_TEAM_ID
low_seed_rankInt64YesLower seed rankPlayoffPicture.EastConfPlayoffPicture.LOW_SEED_RANK
low_seed_teamStringYesLower seed team namePlayoffPicture.EastConfPlayoffPicture.LOW_SEED_TEAM
low_seed_team_idInt64YesLower seed team identifierPlayoffPicture.EastConfPlayoffPicture.LOW_SEED_TEAM_ID
high_seed_series_wInt64YesHigher seed series winsPlayoffPicture.EastConfPlayoffPicture.HIGH_SEED_SERIES_W
high_seed_series_lInt64YesHigher seed series lossesPlayoffPicture.EastConfPlayoffPicture.HIGH_SEED_SERIES_L
high_seed_series_remaining_gInt64YesRemaining games in seriesPlayoffPicture.EastConfPlayoffPicture.HIGH_SEED_SERIES_REMAINING_G
high_seed_series_remaining_home_gInt64YesRemaining home games in seriesPlayoffPicture.EastConfPlayoffPicture.HIGH_SEED_SERIES_REMAINING_HOME_G
high_seed_series_remaining_away_gInt64YesRemaining away games in seriesPlayoffPicture.EastConfPlayoffPicture.HIGH_SEED_SERIES_REMAINING_AWAY_G

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

raw_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 identifierScoreboardV2.GameHeader.HOME_TEAM_ID
visitor_team_idInt64YesVisitor team identifierScoreboardV2.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

raw_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 identifierShotChartDetail.Shot_Chart_Detail.PLAYER_ID
player_nameStringYesPlayer full nameShotChartDetail.Shot_Chart_Detail.PLAYER_NAME
team_idInt64YesTeam identifierShotChartDetail.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

raw_shot_chart_league_wide

ColumnTypeNullableDescriptionSource
grid_typeStringYesShot chart grid typeShotChartLeagueWide.League_Wide.GRID_TYPE
shot_zone_basicStringYesBasic shot zone categoryShotChartLeagueWide.League_Wide.SHOT_ZONE_BASIC
shot_zone_areaStringYesShot zone area on courtShotChartLeagueWide.League_Wide.SHOT_ZONE_AREA
shot_zone_rangeStringYesShot distance range bucketShotChartLeagueWide.League_Wide.SHOT_ZONE_RANGE
fgaInt64YesField goals attemptedShotChartLeagueWide.League_Wide.FGA
fgmInt64YesField goals madeShotChartLeagueWide.League_Wide.FGM
fg_pctFloat64YesField goal percentageShotChartLeagueWide.League_Wide.FG_PCT

raw_synergy_play_types

ColumnTypeNullableDescriptionSource
season_idStringYesNBA season identifierSynergyPlayTypes.SynergyPlayType.SEASON_ID
team_idInt64YesTeam identifierSynergyPlayTypes.SynergyPlayType.TEAM_ID
team_abbreviationStringYesTeam abbreviation codeSynergyPlayTypes.SynergyPlayType.TEAM_ABBREVIATION
team_nameStringYesTeam nameSynergyPlayTypes.SynergyPlayType.TEAM_NAME
player_idInt64YesUnique player identifierSynergyPlayTypes.SynergyPlayType.PLAYER_ID
player_nameStringYesPlayer full nameSynergyPlayTypes.SynergyPlayType.PLAYER_NAME
play_typeStringYesSynergy play type classificationSynergyPlayTypes.SynergyPlayType.PLAY_TYPE
type_groupingStringYesOffensive 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

raw_team_details

ColumnTypeNullableDescriptionSource
team_idInt64NoUnique team identifierTeamDetails.TeamBackground.TEAM_ID
abbreviationStringYesTeam abbreviation codeTeamDetails.TeamBackground.ABBREVIATION
nicknameStringYesTeam 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

raw_team_game_log

ColumnTypeNullableDescriptionSource
season_idStringNoSeason identifierTeamGameLog.TeamGameLog.SEASON_ID
team_idInt64NoUnique team identifierTeamGameLog.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

raw_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_nameStringYesTeam nameTeamInfoCommon.TeamInfoCommon.TEAM_NAME
team_abbreviationStringYesTeam 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

raw_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 identifierWinProbabilityPBP.WinProbPBP.HOME_TEAM_ID
home_team_abbStringYesHome team abbreviation codeWinProbabilityPBP.WinProbPBP.HOME_TEAM_ABB
visitor_team_idInt64YesVisitor team identifierWinProbabilityPBP.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

Use curated pages for interpretation, not inventory

Once you have found the exact raw field, these pages help you translate the term, decode the naming pattern, or reconnect the field to its source family.

Next possession

Decode source-native fields before you keep reading

The raw dictionary is exhaustive by design. Use these pages to translate unfamiliar terms, connect fields back to source families, and understand where raw names fit in the pipeline.

Section hub

On this page