nbadbArena Data Lab
Schema ReferenceHalf-Court MapRaw Reference44 waypoints

Court Geometry

Schema Reference — Raw

Complete schema docs for raw tier

Browse Schema ReferenceNext best pageOpen docs map
Generated pageCommand-ownedSchema metadata

Generated schema contract

Use raw reference as the exact extraction contract

This page is the source-of-truth contract for raw-tier schemas. It is the right place to verify upstream naming, constraints, and optionality before asking how the payload gets cleaned up downstream.

Best for
Exact contracts

confirm raw columns, nullability, and validation rules closest to extraction

Naming mode
API-shaped

raw keeps upstream texture instead of warehouse-friendly semantics

Ownership
Command-owned

regenerate from schema metadata instead of hand-editing

How to work this page
1

Go straight to the matching `raw_*` block

These pages are dense, so start with the schema that matches the endpoint or result-set family you already have in mind.

2

Read constraints and nullability before descriptions

The biggest value here is exact contract behavior, especially when upstream payloads are inconsistent or optional.

3

Leave when you need normalized names

Once the source contract is clear, switch to staging reference or a curated schema page for warehouse-facing guidance.

Quick scan

Find the source contract you actually need

These contract pages scan best when you jump straight to the matching raw family instead of reading every schema in order.

43 schema blocks25 Source familiesTOC-driven
Box Score

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

11
raw_box_score_advanced_playerraw_box_score_defensive_playerraw_box_score_four_factors_playerraw_box_score_hustle_playerraw_box_score_matchupsraw_box_score_misc_player

+5 more in the page TOC and section list.

Draft Combine

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

5
raw_draft_combine_drill_resultsraw_draft_combine_non_stationary_shootingraw_draft_combine_player_anthroraw_draft_combine_spot_shootingraw_draft_combine_stats
Common Team

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

3
raw_common_team_roster_coachesraw_common_team_rosterraw_common_team_years
Play By

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

2
raw_play_by_play_v2raw_play_by_play_v3
Shot Chart

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

2
raw_shot_chart_detailraw_shot_chart_league_wide
Common All

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

1
raw_common_all_players
Common Player

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

1
raw_common_player_info
Draft History

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

1
raw_draft_history
Franchise History

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

1
raw_franchise_history
Game Rotation

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

1
raw_game_rotation
League Game

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

1
raw_league_game_log
League Season

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

1
raw_league_season_matchups
League Standings

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

1
raw_league_standings_v3
Player Awards

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

1
raw_player_awards
Player Career

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

1
raw_player_career_stats
Player Game

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

1
raw_player_game_log
Player Index

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

1
raw_player_index
Playoff Picture

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

1
raw_playoff_picture
Schedule League

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

1
raw_schedule_league_v2
Scoreboard V2

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

1
raw_scoreboard_v2
Synergy Play

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

1
raw_synergy_play_types
Team Details

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

1
raw_team_details
Team Game

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

1
raw_team_game_log
Team Info

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

1
raw_team_info_common
Win Probability

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

1
raw_win_probability

Schema Reference — Raw

This tier contains 43 schema(s).

raw_box_score_advanced_player

Class: RawBoxScoreAdvancedPlayerSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNo—Unique game identifier
team_idInt64No—Team identifier
team_abbreviationStringYes—Team abbreviation code
team_cityStringYes—Team city name
player_idInt64Nogt=0Unique player identifier
player_nameStringYes—Player full name
nicknameStringYes—Player nickname
start_positionStringYes—Starting position (F/C/G)
commentStringYes—Player status comment
minStringYes—Minutes played as string
e_off_ratingFloat64Yes—Estimated offensive rating
off_ratingFloat64Yes—Offensive rating
e_def_ratingFloat64Yes—Estimated defensive rating
def_ratingFloat64Yes—Defensive rating
e_net_ratingFloat64Yes—Estimated net rating
net_ratingFloat64Yes—Net rating
ast_pctFloat64Yes—Assist percentage
ast_tovFloat64Yes—Assist-to-turnover ratio
ast_ratioFloat64Yes—Assist ratio
oreb_pctFloat64Yes—Offensive rebound percentage
dreb_pctFloat64Yes—Defensive rebound percentage
reb_pctFloat64Yes—Total rebound percentage
tm_tov_pctFloat64Yes—Team turnover percentage
efg_pctFloat64Yes—Effective field goal percentage
ts_pctFloat64Yes—True shooting percentage
usg_pctFloat64Yes—Usage percentage
e_usg_pctFloat64Yes—Estimated usage percentage
e_paceFloat64Yes—Estimated pace
paceFloat64Yes—Pace
pace_per40Float64Yes—Pace per 40 minutes
possFloat64Yes—Possessions
pieFloat64Yes—Player impact estimate

raw_box_score_defensive_player

Class: RawBoxScoreDefensivePlayerSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNo—Unique game identifier
team_idInt64No—Team identifier
team_abbreviationStringYes—Team abbreviation code
team_cityStringYes—Team city name
player_idInt64Nogt=0Unique player identifier
player_nameStringYes—Player full name
start_positionStringYes—Starting position (F/C/G)
commentStringYes—Player status comment
minStringYes—Minutes played as string
matchup_minStringYes—Matchup minutes as string
player_ptsFloat64Yes—Points scored by player
team_ptsFloat64Yes—Points scored by team
matchup_pctFloat64Yes—Matchup time percentage
partial_possFloat64Yes—Partial possessions
switches_onFloat64Yes—Switches drawn on defense
matchup_astFloat64Yes—Assists allowed in matchup
matchup_tovFloat64Yes—Turnovers forced in matchup
stlFloat64Yes—Steals
blkFloat64Yes—Blocks
matchup_fgmFloat64Yes—FG made allowed in matchup
matchup_fgaFloat64Yes—FG attempted in matchup
matchup_fg_pctFloat64Yes—FG percentage in matchup
matchup_fg3mFloat64Yes—3-point FG made in matchup
matchup_fg3aFloat64Yes—3-point FG attempted in matchup
matchup_fg3_pctFloat64Yes—3-point FG pct in matchup

raw_box_score_four_factors_player

Class: RawBoxScoreFourFactorsPlayerSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNo—Unique game identifier
team_idInt64No—Team identifier
team_abbreviationStringYes—Team abbreviation code
team_cityStringYes—Team city name
player_idInt64Nogt=0Unique player identifier
player_nameStringYes—Player full name
nicknameStringYes—Player nickname
start_positionStringYes—Starting position (F/C/G)
commentStringYes—Player status comment
minStringYes—Minutes played as string
efg_pctFloat64Yes—Effective field goal percentage
fta_rateFloat64Yes—Free throw attempt rate
tm_tov_pctFloat64Yes—Team turnover percentage
oreb_pctFloat64Yes—Offensive rebound percentage
opp_efg_pctFloat64Yes—Opponent effective FG percentage
opp_fta_rateFloat64Yes—Opponent free throw attempt rate
opp_tov_pctFloat64Yes—Opponent turnover percentage
opp_oreb_pctFloat64Yes—Opponent offensive rebound pct

raw_box_score_hustle_player

Class: RawBoxScoreHustlePlayerSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNo—Unique game identifier
team_idInt64No—Team identifier
team_abbreviationStringYes—Team abbreviation code
team_cityStringYes—Team city name
player_idInt64Nogt=0Unique player identifier
player_nameStringYes—Player full name
start_positionStringYes—Starting position (F/C/G)
commentStringYes—Player status comment
minStringYes—Minutes played as string
contested_shotsFloat64Yes—Total contested shots
contested_shots_2ptFloat64Yes—Contested 2-point shots
contested_shots_3ptFloat64Yes—Contested 3-point shots
deflectionsFloat64Yes—Deflections
charges_drawnFloat64Yes—Charges drawn
screen_assistsFloat64Yes—Screen assists
screen_ast_ptsFloat64Yes—Points from screen assists
loose_balls_recovered_offFloat64Yes—Offensive loose balls recovered
loose_balls_recovered_defFloat64Yes—Defensive loose balls recovered
loose_balls_recoveredFloat64Yes—Total loose balls recovered
off_boxoutsFloat64Yes—Offensive box outs
def_boxoutsFloat64Yes—Defensive box outs
box_outsFloat64Yes—Total box outs

raw_box_score_matchups

Class: RawBoxScoreMatchupsSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNo—Unique game identifier
off_team_idInt64Yes—Offensive team identifier
off_team_abbreviationStringYes—Offensive team abbreviation
def_team_idInt64Yes—Defensive team identifier
def_team_abbreviationStringYes—Defensive team abbreviation
off_player_idInt64Yes—Offensive player identifier
off_player_nameStringYes—Offensive player name
def_player_idInt64Yes—Defensive player identifier
def_player_nameStringYes—Defensive player name
matchup_minFloat64Yes—Minutes in matchup
partial_possFloat64Yes—Partial possessions in matchup
player_ptsFloat64Yes—Player points in matchup
team_ptsFloat64Yes—Team points in matchup
matchup_astFloat64Yes—Assists in matchup
matchup_tovFloat64Yes—Turnovers in matchup
matchup_blkFloat64Yes—Blocks in matchup
matchup_fgmFloat64Yes—Field goals made in matchup
matchup_fgaFloat64Yes—Field goals attempted in matchup
matchup_fg_pctFloat64Yes—Field goal pct in matchup
matchup_fg3mFloat64Yes—Three-pointers made in matchup
matchup_fg3aFloat64Yes—Three-pointers attempted
matchup_fg3_pctFloat64Yes—Three-point pct in matchup
help_blkFloat64Yes—Help blocks in matchup
help_fgmFloat64Yes—Help field goals made
help_fgaFloat64Yes—Help field goals attempted
help_fg_pctFloat64Yes—Help field goal percentage
matchup_ftmFloat64Yes—Free throws made in matchup
matchup_ftaFloat64Yes—Free throws attempted
switches_onFloat64Yes—Number of switches onto player

raw_box_score_misc_player

Class: RawBoxScoreMiscPlayerSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNo—Unique game identifier
team_idInt64No—Team identifier
team_abbreviationStringYes—Team abbreviation code
team_cityStringYes—Team city name
player_idInt64Nogt=0Unique player identifier
player_nameStringYes—Player full name
nicknameStringYes—Player nickname
start_positionStringYes—Starting position (F/C/G)
commentStringYes—Player status comment
minStringYes—Minutes played as string
pts_off_tovFloat64Yes—Points off turnovers
second_chance_ptsFloat64Yes—Second chance points
fbpsFloat64Yes—Fast break points
pitpFloat64Yes—Points in the paint
opp_pts_off_tovFloat64Yes—Opponent points off turnovers
opp_second_chance_ptsFloat64Yes—Opponent second chance points
opp_fbpsFloat64Yes—Opponent fast break points
opp_pitpFloat64Yes—Opponent points in the paint
blkFloat64Yes—Blocks
blkaFloat64Yes—Blocked shot attempts
pfFloat64Yes—Personal fouls
pfdFloat64Yes—Personal fouls drawn

raw_box_score_player_track

Class: RawBoxScorePlayerTrackSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNo—Unique game identifier
team_idInt64No—Team identifier
team_abbreviationStringYes—Team abbreviation code
team_cityStringYes—Team city name
player_idInt64Nogt=0Unique player identifier
player_nameStringYes—Player full name
nicknameStringYes—Player nickname
start_positionStringYes—Starting position (F/C/G)
commentStringYes—Player status comment
minStringYes—Minutes played as string
spdFloat64Yes—Average speed
distFloat64Yes—Distance covered
orbcFloat64Yes—Offensive rebound chances
drbcFloat64Yes—Defensive rebound chances
rbcFloat64Yes—Total rebound chances
tchsFloat64Yes—Touches
sastFloat64Yes—Secondary assists
ftastFloat64Yes—Free throw assists
pass_Float64Yes—Passes made
astFloat64Yes—Assists
cfgmFloat64Yes—Contested field goals made
cfgaFloat64Yes—Contested field goals attempted
cfg_pctFloat64Yes—Contested field goal percentage
ufgmFloat64Yes—Uncontested field goals made
ufgaFloat64Yes—Uncontested FG attempted
ufg_pctFloat64Yes—Uncontested field goal percentage
fg_pctFloat64Yes—Field goal percentage
dfgmFloat64Yes—Defended field goals made
dfgaFloat64Yes—Defended field goals attempted
dfg_pctFloat64Yes—Defended field goal percentage

raw_box_score_scoring_player

Class: RawBoxScoreScoringPlayerSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNo—Unique game identifier
team_idInt64No—Team identifier
team_abbreviationStringYes—Team abbreviation code
team_cityStringYes—Team city name
player_idInt64Nogt=0Unique player identifier
player_nameStringYes—Player full name
nicknameStringYes—Player nickname
start_positionStringYes—Starting position (F/C/G)
commentStringYes—Player status comment
minStringYes—Minutes played as string
pct_fga_2ptFloat64Yes—Percent of FGA that are 2-pointers
pct_fga_3ptFloat64Yes—Percent of FGA that are 3-pointers
pct_pts_2ptFloat64Yes—Percent of points from 2-pointers
pct_pts_2pt_mrFloat64Yes—Percent of points from mid-range
pct_pts_3ptFloat64Yes—Percent of points from 3-pointers
pct_pts_fbFloat64Yes—Percent of points from fast breaks
pct_pts_ftFloat64Yes—Percent of points from free throws
pct_pts_off_tovFloat64Yes—Percent of points off turnovers
pct_pts_pitpFloat64Yes—Percent of points in the paint
pct_ast_2pmFloat64Yes—Percent of assisted 2-point makes
pct_uast_2pmFloat64Yes—Percent of unassisted 2-point makes
pct_ast_3pmFloat64Yes—Percent of assisted 3-point makes
pct_uast_3pmFloat64Yes—Percent of unassisted 3-point makes
pct_ast_fgmFloat64Yes—Percent of assisted field goal makes
pct_uast_fgmFloat64Yes—Percent of unassisted FG makes

raw_box_score_traditional_player

Class: RawBoxScoreTraditionalPlayerSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNo—Unique game identifier
team_idInt64No—Team identifier
team_abbreviationStringYes—Team abbreviation code
team_cityStringYes—Team city name
player_idInt64Nogt=0Unique player identifier
player_nameStringYes—Player full name
nicknameStringYes—Player nickname
start_positionStringYes—Starting position (F/C/G)
commentStringYes—Player status comment
minStringYes—Minutes played as string
fgmFloat64Yes—Field goals made
fgaFloat64Yes—Field goals attempted
fg_pctFloat64Yes—Field goal percentage
fg3mFloat64Yes—Three-point field goals made
fg3aFloat64Yes—Three-point field goals attempted
fg3_pctFloat64Yes—Three-point field goal percentage
ftmFloat64Yes—Free throws made
ftaFloat64Yes—Free throws attempted
ft_pctFloat64Yes—Free throw percentage
orebFloat64Yes—Offensive rebounds
drebFloat64Yes—Defensive rebounds
rebFloat64Yes—Total rebounds
astFloat64Yes—Assists
stlFloat64Yes—Steals
blkFloat64Yes—Blocks
tovFloat64Yes—Turnovers (alias TO in some versions)
pfFloat64Yes—Personal fouls
ptsFloat64Yes—Points scored
plus_minusFloat64Yes—Plus-minus differential

raw_box_score_traditional_team

Class: RawBoxScoreTraditionalTeamSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNo—Unique game identifier
team_idInt64No—Team identifier
team_nameStringYes—Team name
team_abbreviationStringYes—Team abbreviation code
team_cityStringYes—Team city name
minFloat64Yes—Total team minutes played
fgmFloat64Yes—Field goals made
fgaFloat64Yes—Field goals attempted
fg_pctFloat64Yes—Field goal percentage
fg3mFloat64Yes—Three-point field goals made
fg3aFloat64Yes—Three-point field goals attempted
fg3_pctFloat64Yes—Three-point field goal percentage
ftmFloat64Yes—Free throws made
ftaFloat64Yes—Free throws attempted
ft_pctFloat64Yes—Free throw percentage
orebFloat64Yes—Offensive rebounds
drebFloat64Yes—Defensive rebounds
rebFloat64Yes—Total rebounds
astFloat64Yes—Assists
stlFloat64Yes—Steals
blkFloat64Yes—Blocks
tovFloat64Yes—Turnovers
pfFloat64Yes—Personal fouls
ptsFloat64Yes—Points scored
plus_minusFloat64Yes—Plus-minus differential

raw_box_score_usage_player

Class: RawBoxScoreUsagePlayerSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNo—Unique game identifier
team_idInt64No—Team identifier
team_abbreviationStringYes—Team abbreviation code
team_cityStringYes—Team city name
player_idInt64Nogt=0Unique player identifier
player_nameStringYes—Player full name
nicknameStringYes—Player nickname
start_positionStringYes—Starting position (F/C/G)
commentStringYes—Player status comment
minStringYes—Minutes played as string
usg_pctFloat64Yes—Usage percentage
pct_fgmFloat64Yes—Percent of team field goals made
pct_fgaFloat64Yes—Percent of team FG attempted
pct_fg3mFloat64Yes—Percent of team 3-point FG made
pct_fg3aFloat64Yes—Percent of team 3-point FG attempted
pct_ftmFloat64Yes—Percent of team free throws made
pct_ftaFloat64Yes—Percent of team FT attempted
pct_orebFloat64Yes—Percent of team offensive rebounds
pct_drebFloat64Yes—Percent of team defensive rebounds
pct_rebFloat64Yes—Percent of team total rebounds
pct_astFloat64Yes—Percent of team assists
pct_tovFloat64Yes—Percent of team turnovers
pct_stlFloat64Yes—Percent of team steals
pct_blkFloat64Yes—Percent of team blocks
pct_blkaFloat64Yes—Percent of team blocked attempts
pct_pfFloat64Yes—Percent of team personal fouls
pct_pfdFloat64Yes—Percent of team personal fouls drawn
pct_ptsFloat64Yes—Percent of team points

raw_common_all_players

Class: RawCommonAllPlayersSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
person_idInt64Nogt=0Unique player identifier
display_last_comma_firstStringYes—Player name as Last, First
display_first_lastStringYes—Player name as First Last
roster_statusInt64Yesin=[0, 1]Active roster flag (0 or 1)
from_yearStringYes—First year in the league
to_yearStringYes—Last year in the league
playercodeStringYes—Player code slug
team_idInt64Yes—Team identifier
team_cityStringYes—Team city name
team_nameStringYes—Team name
team_abbreviationStringYes—Team abbreviation code
team_codeStringYes—Team code slug
games_played_flagStringYes—Flag indicating games played

raw_common_player_info

Class: RawCommonPlayerInfoSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
person_idInt64Nogt=0Unique player identifier
first_nameStringYes—Player first name
last_nameStringYes—Player last name
display_first_lastStringYes—Player name as First Last
display_last_comma_firstStringYes—Player name as Last, First
display_fi_lastStringYes—Player name as F. Last
player_slugStringYes—URL-friendly player slug
birthdateStringYes—Player date of birth
schoolStringYes—School or college attended
countryStringYes—Country of origin
last_affiliationStringYes—Last team or school affiliation
heightStringYes—Player height as string
weightStringYes—Player weight as string
season_expInt64Yes—Years of NBA experience
jerseyStringYes—Jersey number as string
positionStringYes—Player position
roster_statusStringYes—Current roster status
games_played_current_season_flagStringYes—Flag for games played this season
team_idInt64Yes—Team identifier
team_nameStringYes—Team name
team_abbreviationStringYes—Team abbreviation code
team_codeStringYes—Team code slug
team_cityStringYes—Team city name
playercodeStringYes—Player code slug
from_yearInt64Yes—First year in the league
to_yearInt64Yes—Last year in the league
dleague_flagStringYes—G-League eligibility flag
nba_flagStringYes—NBA eligibility flag
games_played_flagStringYes—Flag indicating games played
draft_yearStringYes—Year drafted
draft_roundStringYes—Round drafted
draft_numberStringYes—Overall draft pick number
greatest_75_flagStringYes—NBA 75th anniversary team flag

raw_common_team_roster_coaches

Class: RawCommonTeamRosterCoachesSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
team_idInt64Nogt=0Unique team identifier
seasonStringYes—Season string
coach_idInt64Yes—Unique coach identifier
first_nameStringYes—Coach first name
last_nameStringYes—Coach last name
coach_nameStringYes—Coach full name
is_assistantInt64Yes—Flag indicating assistant coach
coach_typeStringYes—Type of coaching role
sort_sequenceInt64Yes—Display sort order
sub_sort_sequenceInt64Yes—Secondary display sort order
schoolStringYes—School or college attended

raw_common_team_roster

Class: RawCommonTeamRosterSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
teamidInt64Nogt=0Unique team identifier
seasonStringYes—Season string
leagueidStringYes—League identifier
playerStringYes—Player full name
nicknameStringYes—Player nickname
player_slugStringYes—URL-friendly player slug
numStringYes—Jersey number as string
positionStringYes—Player position
heightStringYes—Player height as string
weightStringYes—Player weight as string
birth_dateStringYes—Player date of birth
ageFloat64Yes—Player age
expStringYes—Years of experience as string
schoolStringYes—School or college attended
player_idInt64Yes—Unique player identifier
how_acquiredStringYes—How the player was acquired

raw_common_team_years

Class: RawCommonTeamYearsSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
league_idStringNo—League identifier
team_idInt64Nogt=0Unique team identifier
min_yearStringYes—First year of team activity
max_yearStringYes—Last year of team activity
abbreviationStringYes—Team abbreviation code

raw_draft_combine_drill_results

Class: RawDraftCombineDrillResultsSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
seasonStringNo—Combine season year
player_idInt64Nogt=0Unique player identifier
first_nameStringYes—Player first name
last_nameStringYes—Player last name
player_nameStringYes—Player full name
positionStringYes—Player position
standing_vertical_leapFloat64Yes—Standing vertical leap in inches
max_vertical_leapFloat64Yes—Maximum vertical leap in inches
lane_agility_timeFloat64Yes—Lane agility drill time in seconds
modified_lane_agility_timeFloat64Yes—Modified lane agility time in seconds
three_quarter_sprintFloat64Yes—Three-quarter court sprint time in seconds
bench_pressFloat64Yes—Bench press repetitions

raw_draft_combine_non_stationary_shooting

Class: RawDraftCombineNonStationaryShootingSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
seasonStringNo—Combine season year
player_idInt64Nogt=0Unique player identifier
first_nameStringYes—Player first name
last_nameStringYes—Player last name
player_nameStringYes—Player full name
positionStringYes—Player position
off_drib_fifteen_break_left_madeInt64Yes—Off-dribble fifteen-foot break left shots made
off_drib_fifteen_break_left_attemptInt64Yes—Off-dribble fifteen-foot break left shots attempted
off_drib_fifteen_break_left_pctFloat64Yes—Off-dribble fifteen-foot break left shooting percentage
off_drib_fifteen_top_key_madeInt64Yes—Off-dribble fifteen-foot top of key shots made
off_drib_fifteen_top_key_attemptInt64Yes—Off-dribble fifteen-foot top of key shots attempted
off_drib_fifteen_top_key_pctFloat64Yes—Off-dribble fifteen-foot top of key shooting percentage
off_drib_college_break_left_madeInt64Yes—Off-dribble college break left shots made
off_drib_college_break_left_attemptInt64Yes—Off-dribble college break left shots attempted
off_drib_college_break_left_pctFloat64Yes—Off-dribble college break left shooting percentage
off_drib_college_top_key_madeInt64Yes—Off-dribble college top of key shots made
off_drib_college_top_key_attemptInt64Yes—Off-dribble college top of key shots attempted
off_drib_college_top_key_pctFloat64Yes—Off-dribble college top of key shooting percentage
on_move_fifteen_madeInt64Yes—On-move fifteen-foot shots made
on_move_fifteen_attemptInt64Yes—On-move fifteen-foot shots attempted
on_move_fifteen_pctFloat64Yes—On-move fifteen-foot shooting percentage
on_move_college_madeInt64Yes—On-move college range shots made
on_move_college_attemptInt64Yes—On-move college range shots attempted
on_move_college_pctFloat64Yes—On-move college range shooting percentage

raw_draft_combine_player_anthro

Class: RawDraftCombinePlayerAnthroSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
seasonStringNo—Combine season year
player_idInt64Nogt=0Unique player identifier
first_nameStringYes—Player first name
last_nameStringYes—Player last name
player_nameStringYes—Player full name
positionStringYes—Player position
height_wo_shoesFloat64Yes—Height without shoes in inches
height_wo_shoes_ft_inStringYes—Height without shoes in feet-inches
height_w_shoesFloat64Yes—Height with shoes in inches
height_w_shoes_ft_inStringYes—Height with shoes in feet-inches
weightFloat64Yes—Player weight in pounds
wingspanFloat64Yes—Wingspan in inches
wingspan_ft_inStringYes—Wingspan in feet-inches
standing_reachFloat64Yes—Standing reach in inches
standing_reach_ft_inStringYes—Standing reach in feet-inches
body_fat_pctFloat64Yes—Body fat percentage
hand_lengthFloat64Yes—Hand length in inches
hand_widthFloat64Yes—Hand width in inches

raw_draft_combine_spot_shooting

Class: RawDraftCombineSpotShootingSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
seasonStringNo—Combine season year
player_idInt64Nogt=0Unique player identifier
first_nameStringYes—Player first name
last_nameStringYes—Player last name
player_nameStringYes—Player full name
positionStringYes—Player position
nba_break_left_madeInt64Yes—NBA break left shots made
nba_break_left_attemptInt64Yes—NBA break left shots attempted
nba_break_left_pctFloat64Yes—NBA break left shooting percentage
nba_break_right_madeInt64Yes—NBA break right shots made
nba_break_right_attemptInt64Yes—NBA break right shots attempted
nba_break_right_pctFloat64Yes—NBA break right shooting percentage
nba_corner_left_madeInt64Yes—NBA corner left shots made
nba_corner_left_attemptInt64Yes—NBA corner left shots attempted
nba_corner_left_pctFloat64Yes—NBA corner left shooting percentage
nba_corner_right_madeInt64Yes—NBA corner right shots made
nba_corner_right_attemptInt64Yes—NBA corner right shots attempted
nba_corner_right_pctFloat64Yes—NBA corner right shooting percentage
nba_top_key_madeInt64Yes—NBA top of key shots made
nba_top_key_attemptInt64Yes—NBA top of key shots attempted
nba_top_key_pctFloat64Yes—NBA top of key shooting percentage
college_break_left_madeInt64Yes—College break left shots made
college_break_left_attemptInt64Yes—College break left shots attempted
college_break_left_pctFloat64Yes—College break left shooting percentage
college_break_right_madeInt64Yes—College break right shots made
college_break_right_attemptInt64Yes—College break right shots attempted
college_break_right_pctFloat64Yes—College break right shooting percentage
college_corner_left_madeInt64Yes—College corner left shots made
college_corner_left_attemptInt64Yes—College corner left shots attempted
college_corner_left_pctFloat64Yes—College corner left shooting percentage
college_corner_right_madeInt64Yes—College corner right shots made
college_corner_right_attemptInt64Yes—College corner right shots attempted
college_corner_right_pctFloat64Yes—College corner right shooting percentage
college_top_key_madeInt64Yes—College top of key shots made
college_top_key_attemptInt64Yes—College top of key shots attempted
college_top_key_pctFloat64Yes—College top of key shooting percentage
fifteen_break_left_madeInt64Yes—Fifteen-foot break left shots made
fifteen_break_left_attemptInt64Yes—Fifteen-foot break left shots attempted
fifteen_break_left_pctFloat64Yes—Fifteen-foot break left shooting percentage
fifteen_break_right_madeInt64Yes—Fifteen-foot break right shots made
fifteen_break_right_attemptInt64Yes—Fifteen-foot break right shots attempted
fifteen_break_right_pctFloat64Yes—Fifteen-foot break right shooting percentage
fifteen_corner_left_madeInt64Yes—Fifteen-foot corner left shots made
fifteen_corner_left_attemptInt64Yes—Fifteen-foot corner left shots attempted
fifteen_corner_left_pctFloat64Yes—Fifteen-foot corner left shooting percentage
fifteen_corner_right_madeInt64Yes—Fifteen-foot corner right shots made
fifteen_corner_right_attemptInt64Yes—Fifteen-foot corner right shots attempted
fifteen_corner_right_pctFloat64Yes—Fifteen-foot corner right shooting percentage
fifteen_top_key_madeInt64Yes—Fifteen-foot top of key shots made
fifteen_top_key_attemptInt64Yes—Fifteen-foot top of key shots attempted
fifteen_top_key_pctFloat64Yes—Fifteen-foot top of key shooting percentage

raw_draft_combine_stats

Class: RawDraftCombineStatsSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
seasonStringNo—Combine season year
player_idInt64Nogt=0Unique player identifier
first_nameStringYes—Player first name
last_nameStringYes—Player last name
player_nameStringYes—Player full name
positionStringYes—Player position
height_wo_shoesFloat64Yes—Height without shoes in inches
height_wo_shoes_ft_inStringYes—Height without shoes in feet-inches
height_w_shoesFloat64Yes—Height with shoes in inches
height_w_shoes_ft_inStringYes—Height with shoes in feet-inches
weightFloat64Yes—Player weight in pounds
wingspanFloat64Yes—Wingspan in inches
wingspan_ft_inStringYes—Wingspan in feet-inches
standing_reachFloat64Yes—Standing reach in inches
standing_reach_ft_inStringYes—Standing reach in feet-inches
body_fat_pctFloat64Yes—Body fat percentage
hand_lengthFloat64Yes—Hand length in inches
hand_widthFloat64Yes—Hand width in inches
standing_vertical_leapFloat64Yes—Standing vertical leap in inches
max_vertical_leapFloat64Yes—Maximum vertical leap in inches
lane_agility_timeFloat64Yes—Lane agility drill time in seconds
modified_lane_agility_timeFloat64Yes—Modified lane agility time in seconds
three_quarter_sprintFloat64Yes—Three-quarter court sprint time in seconds
bench_pressFloat64Yes—Bench press repetitions

raw_draft_history

Class: RawDraftHistorySchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
person_idInt64Nogt=0Unique player identifier
player_nameStringYes—Player full name
seasonStringYes—Draft season year
round_numberInt64Yes—Draft round number
round_pickInt64Yes—Pick number within the round
overall_pickInt64Yes—Overall draft pick number
draft_typeStringYes—Type of draft
team_idInt64Yes—Team identifier
team_cityStringYes—Team city name
team_nameStringYes—Team name
team_abbreviationStringYes—Team abbreviation code
organizationStringYes—Pre-draft organization
organization_typeStringYes—Type of pre-draft organization
player_profile_flagInt64Yes—Player profile availability flag

raw_franchise_history

Class: RawFranchiseHistorySchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
league_idStringNo—League identifier
team_idInt64Nogt=0Unique team identifier
team_cityStringYes—Team city name
team_nameStringYes—Team name
start_yearStringYes—First year of franchise era
end_yearStringYes—Last year of franchise era
yearsInt64Yes—Total years in franchise era
gamesInt64Yes—Total games played
winsInt64Yes—Total wins
lossesInt64Yes—Total losses
win_pctFloat64Yes—Win percentage
po_appearancesInt64Yes—Playoff appearances count
div_titlesInt64Yes—Division titles won
conf_titlesInt64Yes—Conference titles won
league_titlesInt64Yes—League championships won

raw_game_rotation

Class: RawGameRotationSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNo—Unique game identifier
team_idInt64Yes—Team identifier
team_cityStringYes—Team city name
team_nameStringYes—Team name
person_idInt64Yes—Player person identifier
player_firstStringYes—Player first name
player_lastStringYes—Player last name
in_time_realFloat64Yes—Real time player entered game
out_time_realFloat64Yes—Real time player exited game
player_ptsFloat64Yes—Points scored during stint
pt_diffFloat64Yes—Point differential during stint
usg_pctFloat64Yes—Usage percentage during stint

raw_league_game_log

Class: RawLeagueGameLogSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
season_idStringNo—Season identifier
team_idInt64Nogt=0Unique team identifier
team_abbreviationStringNo—Team abbreviation code
team_nameStringNo—Team name
game_idStringNo—Unique game identifier
game_dateStringNo—Date of the game
matchupStringNo—Matchup string (e.g. LAL vs. BOS)
wlStringYes—Win or loss indicator
wInt64Yes—Wins
lInt64Yes—Losses
w_pctFloat64Yes—Win percentage
minFloat64Yes—Minutes played
fgmFloat64Yes—Field goals made
fgaFloat64Yes—Field goals attempted
fg_pctFloat64Yes—Field goal percentage
fg3mFloat64Yes—Three-point field goals made
fg3aFloat64Yes—Three-point field goals attempted
fg3_pctFloat64Yes—Three-point field goal percentage
ftmFloat64Yes—Free throws made
ftaFloat64Yes—Free throws attempted
ft_pctFloat64Yes—Free throw percentage
orebFloat64Yes—Offensive rebounds
drebFloat64Yes—Defensive rebounds
rebFloat64Yes—Total rebounds
astFloat64Yes—Assists
stlFloat64Yes—Steals
blkFloat64Yes—Blocks
tovFloat64Yes—Turnovers
pfFloat64Yes—Personal fouls
ptsFloat64Yes—Points scored
plus_minusFloat64Yes—Plus-minus differential
video_availableInt64Yes—Video availability flag

raw_league_season_matchups

Class: RawLeagueSeasonMatchupsSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
off_player_idInt64Yes—Offensive player identifier
off_player_nameStringYes—Offensive player name
def_player_idInt64Yes—Defensive player identifier
def_player_nameStringYes—Defensive player name
gpInt64Yes—Games played
matchup_minFloat64Yes—Minutes in matchup
partial_possFloat64Yes—Partial possessions in matchup
player_ptsFloat64Yes—Player points in matchup
team_ptsFloat64Yes—Team points in matchup
matchup_astFloat64Yes—Assists in matchup
matchup_tovFloat64Yes—Turnovers in matchup
matchup_blkFloat64Yes—Blocks in matchup
matchup_fgmFloat64Yes—Field goals made in matchup
matchup_fgaFloat64Yes—Field goals attempted in matchup
matchup_fg_pctFloat64Yes—Field goal pct in matchup
matchup_fg3mFloat64Yes—Three-pointers made in matchup
matchup_fg3aFloat64Yes—Three-pointers attempted
matchup_fg3_pctFloat64Yes—Three-point pct in matchup
help_blkFloat64Yes—Help blocks in matchup
help_fgmFloat64Yes—Help field goals made
help_fgaFloat64Yes—Help field goals attempted
help_fg_pctFloat64Yes—Help field goal percentage
matchup_ftmFloat64Yes—Free throws made in matchup
matchup_ftaFloat64Yes—Free throws attempted
switches_onFloat64Yes—Number of switches onto player
pct_switchedFloat64Yes—Percentage of possessions switched

raw_league_standings_v3

Class: RawLeagueStandingsV3Schema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
league_idStringNo—League identifier
season_idStringYes—Season identifier
team_idInt64Nogt=0Unique team identifier
team_cityStringYes—Team city name
team_nameStringYes—Team name
team_slugStringYes—URL-friendly team slug
conferenceStringYes—Conference name
conference_recordStringYes—Win-loss record in conference
playoff_rankInt64Yes—Playoff seeding rank
clinch_indicatorStringYes—Clinch status indicator
divisionStringYes—Division name
division_recordStringYes—Win-loss record in division
division_rankInt64Yes—Rank within division
winsInt64Yes—Total wins
lossesInt64Yes—Total losses
win_pctFloat64Yes—Winning percentage
league_rankInt64Yes—Overall league rank
recordStringYes—Overall win-loss record
homeStringYes—Home win-loss record
roadStringYes—Road win-loss record
l10StringYes—Record in last 10 games
long_win_streakInt64Yes—Longest winning streak
long_loss_streakInt64Yes—Longest losing streak
current_streakStringYes—Current win or loss streak
ot_recordStringYes—Overtime win-loss record
three_pts_or_lessStringYes—Record in games decided by 3 points or less
ten_pts_or_moreStringYes—Record in games decided by 10 points or more
conference_games_backFloat64Yes—Games behind conference leader
division_games_backFloat64Yes—Games behind division leader
clinched_conference_titleInt64Yes—Whether team clinched conference
clinched_division_titleInt64Yes—Whether team clinched division
clinched_playoff_birthInt64Yes—Whether team clinched playoff berth
eliminated_conferenceInt64Yes—Whether team eliminated from conference playoff contention
pts_pgFloat64Yes—Points per game
opp_pts_pgFloat64Yes—Opponent points per game
diff_pts_pgFloat64Yes—Point differential per game

raw_play_by_play_v2

Class: RawPlayByPlayV2Schema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNo—Unique game identifier
eventnumInt64No—Event sequence number
eventmsgtypeInt64No—Event message type code
eventmsgactiontypeInt64No—Event message action type code
periodInt64No—Game period number
wctimestringStringYes—Wall clock time string
pctimestringStringYes—Period clock time string
homedescriptionStringYes—Play description for home team
neutraldescriptionStringYes—Neutral play description
visitordescriptionStringYes—Play description for visitor team
scoreStringYes—Current game score
scoremarginStringYes—Score margin value
person1typeInt64Yes—Person 1 type identifier
player1_idInt64Yes—Player 1 unique identifier
player1_nameStringYes—Player 1 full name
player1_team_idInt64Yes—Player 1 team identifier
player1_team_cityStringYes—Player 1 team city
player1_team_nicknameStringYes—Player 1 team nickname
player1_team_abbreviationStringYes—Player 1 team abbreviation
person2typeInt64Yes—Person 2 type identifier
player2_idInt64Yes—Player 2 unique identifier
player2_nameStringYes—Player 2 full name
player2_team_idInt64Yes—Player 2 team identifier
player2_team_cityStringYes—Player 2 team city
player2_team_nicknameStringYes—Player 2 team nickname
player2_team_abbreviationStringYes—Player 2 team abbreviation
person3typeInt64Yes—Person 3 type identifier
player3_idInt64Yes—Player 3 unique identifier
player3_nameStringYes—Player 3 full name
player3_team_idInt64Yes—Player 3 team identifier
player3_team_cityStringYes—Player 3 team city
player3_team_nicknameStringYes—Player 3 team nickname
player3_team_abbreviationStringYes—Player 3 team abbreviation
video_available_flagInt64Yes—Video availability flag

raw_play_by_play_v3

Class: RawPlayByPlayV3Schema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNo—Unique game identifier
action_numberInt64No—Sequential action number within game
clockStringYes—Game clock time string
periodInt64No—Game period number
team_idInt64Yes—Team identifier
team_tricodeStringYes—Three-letter team abbreviation code
person_idInt64Yes—Person identifier
player_nameStringYes—Full player name
player_name_iStringYes—Player name in initial format
x_legacyFloat64Yes—Legacy x-coordinate of action
y_legacyFloat64Yes—Legacy y-coordinate of action
shot_distanceFloat64Yes—Distance of shot in feet
shot_resultStringYes—Result of shot attempt
is_field_goalInt64Yes—Flag indicating if action is a field goal attempt
score_homeStringYes—Home team score
score_awayStringYes—Away team score
points_totalInt64Yes—Total points scored on the play
locationStringYes—Home or away location indicator
descriptionStringYes—Text description of the play
action_typeStringYes—Type of action performed
sub_typeStringYes—Sub-type of action performed
video_availableInt64Yes—Video availability flag
action_idInt64Yes—Unique action identifier

raw_player_awards

Class: RawPlayerAwardsSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
person_idInt64Nogt=0Unique player identifier
first_nameStringYes—Player first name
last_nameStringYes—Player last name
teamStringYes—Team name at time of award
descriptionStringYes—Award description
all_nba_team_numberInt64Yes—All-NBA team number selection
seasonStringYes—Season of the award
monthStringYes—Month of the award if applicable
weekStringYes—Week of the award if applicable
conferenceStringYes—Conference for the award
typeStringYes—Award type category
subtype1StringYes—Award subtype level 1
subtype2StringYes—Award subtype level 2
subtype3StringYes—Award subtype level 3

raw_player_career_stats

Class: RawPlayerCareerStatsSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
player_idInt64Nogt=0Unique player identifier
season_idStringYes—Season identifier string
league_idStringYes—League identifier
team_idInt64Yes—Team identifier
team_abbreviationStringYes—Team abbreviation code
player_ageFloat64Yes—Player age during season
gpInt64Yes—Games played
gsInt64Yes—Games started
minFloat64Yes—Minutes played
fgmFloat64Yes—Field goals made
fgaFloat64Yes—Field goals attempted
fg_pctFloat64Yes—Field goal percentage
fg3mFloat64Yes—Three-point field goals made
fg3aFloat64Yes—Three-point field goals attempted
fg3_pctFloat64Yes—Three-point field goal percentage
ftmFloat64Yes—Free throws made
ftaFloat64Yes—Free throws attempted
ft_pctFloat64Yes—Free throw percentage
orebFloat64Yes—Offensive rebounds
drebFloat64Yes—Defensive rebounds
rebFloat64Yes—Total rebounds
astFloat64Yes—Assists
stlFloat64Yes—Steals
blkFloat64Yes—Blocks
tovFloat64Yes—Turnovers
pfFloat64Yes—Personal fouls
ptsFloat64Yes—Points scored

raw_player_game_log

Class: RawPlayerGameLogSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
season_idStringNo—Season identifier
player_idInt64Nogt=0Unique player identifier
game_idStringNo—Unique game identifier
game_dateStringNo—Date of the game
matchupStringNo—Matchup string (e.g. LAL vs. BOS)
wlStringYes—Win or loss indicator
minFloat64Yes—Minutes played
fgmFloat64Yes—Field goals made
fgaFloat64Yes—Field goals attempted
fg_pctFloat64Yes—Field goal percentage
fg3mFloat64Yes—Three-point field goals made
fg3aFloat64Yes—Three-point field goals attempted
fg3_pctFloat64Yes—Three-point field goal percentage
ftmFloat64Yes—Free throws made
ftaFloat64Yes—Free throws attempted
ft_pctFloat64Yes—Free throw percentage
orebFloat64Yes—Offensive rebounds
drebFloat64Yes—Defensive rebounds
rebFloat64Yes—Total rebounds
astFloat64Yes—Assists
stlFloat64Yes—Steals
blkFloat64Yes—Blocks
tovFloat64Yes—Turnovers
pfFloat64Yes—Personal fouls
ptsFloat64Yes—Points scored
plus_minusFloat64Yes—Plus-minus differential

raw_player_index

Class: RawPlayerIndexSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
person_idInt64Nogt=0Unique player identifier
player_last_nameStringYes—Player last name
player_first_nameStringYes—Player first name
player_slugStringYes—URL-friendly player slug
team_idInt64Yes—Team identifier
team_slugStringYes—URL-friendly team slug
is_defunctInt64Yes—Whether team is defunct
team_cityStringYes—Team city name
team_nameStringYes—Team name
team_abbreviationStringYes—Team abbreviation code
jersey_numberStringYes—Jersey number as string
positionStringYes—Player position
heightStringYes—Player height as string
weightStringYes—Player weight as string
collegeStringYes—College attended
countryStringYes—Country of origin
draft_yearInt64Yes—Year drafted
draft_roundInt64Yes—Round drafted
draft_numberInt64Yes—Overall draft pick number
roster_statusFloat64Yes—Active roster status
ptsFloat64Yes—Points per game
rebFloat64Yes—Rebounds per game
astFloat64Yes—Assists per game
stats_timeframeStringYes—Timeframe for stats
from_yearStringYes—First year in the league
to_yearStringYes—Last year in the league

raw_playoff_picture

Class: RawPlayoffPictureSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
conferenceStringNo—Conference name
high_seed_rankInt64Yes—Higher seed rank
high_seed_teamStringYes—Higher seed team name
high_seed_team_idInt64Yes—Higher seed team identifier
low_seed_rankInt64Yes—Lower seed rank
low_seed_teamStringYes—Lower seed team name
low_seed_team_idInt64Yes—Lower seed team identifier
high_seed_series_wInt64Yes—Higher seed series wins
high_seed_series_lInt64Yes—Higher seed series losses
high_seed_series_remaining_gInt64Yes—Remaining games in series
high_seed_series_remaining_home_gInt64Yes—Remaining home games in series
high_seed_series_remaining_away_gInt64Yes—Remaining away games in series

raw_schedule_league_v2

Class: RawScheduleLeagueV2Schema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_dateStringNo—Date of the game
game_idStringNo—Unique game identifier
game_codeStringYes—Game code string
game_statusInt64Yes—Game status code
game_status_textStringYes—Game status display text
game_sequenceInt64Yes—Game sequence number for the day
game_date_estStringYes—Game date in Eastern time
game_time_estStringYes—Game time in Eastern time
game_date_time_estStringYes—Game date and time in Eastern time
game_date_utcStringYes—Game date in UTC
game_time_utcStringYes—Game time in UTC
game_date_time_utcStringYes—Game date and time in UTC
away_team_idInt64Yes—Away team identifier
away_team_nameStringYes—Away team name
away_team_cityStringYes—Away team city
away_team_tricodeStringYes—Away team three-letter code
away_team_slugStringYes—Away team URL slug
away_team_winsInt64Yes—Away team win count
away_team_lossesInt64Yes—Away team loss count
away_team_scoreInt64Yes—Away team score
home_team_idInt64Yes—Home team identifier
home_team_nameStringYes—Home team name
home_team_cityStringYes—Home team city
home_team_tricodeStringYes—Home team three-letter code
home_team_slugStringYes—Home team URL slug
home_team_winsInt64Yes—Home team win count
home_team_lossesInt64Yes—Home team loss count
home_team_scoreInt64Yes—Home team score
arena_nameStringYes—Arena name
arena_cityStringYes—Arena city
arena_stateStringYes—Arena state
postponed_statusStringYes—Postponement status
branch_linkStringYes—Branch deep link URL
game_subtypeStringYes—Game subtype classification
series_conferenceStringYes—Playoff series conference
series_textStringYes—Playoff series status text
if_necessaryStringYes—If-necessary game indicator
series_game_numberStringYes—Game number in playoff series

raw_scoreboard_v2

Class: RawScoreboardV2Schema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_date_estStringNo—Game date in Eastern time
game_sequenceInt64Yes—Game sequence number for the day
game_idStringNo—Unique game identifier
game_status_idInt64Yes—Game status identifier
game_status_textStringYes—Game status display text
gamecodeStringYes—Game code string
home_team_idInt64Yes—Home team identifier
visitor_team_idInt64Yes—Visitor team identifier
seasonStringYes—Season year string
live_periodInt64Yes—Current live period
live_pc_timeStringYes—Live game clock time
natl_tv_broadcaster_abbreviationStringYes—National TV broadcaster abbreviation
home_tv_broadcaster_abbreviationStringYes—Home TV broadcaster abbreviation
away_tv_broadcaster_abbreviationStringYes—Away TV broadcaster abbreviation
live_period_time_bcastStringYes—Live period time broadcast string
arena_nameStringYes—Arena name
wh_statusInt64Yes—Wagering hub status flag

raw_shot_chart_detail

Class: RawShotChartDetailSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
grid_typeStringYes—Shot chart grid type
game_idStringNo—Unique game identifier
game_event_idInt64Yes—Event identifier within game
player_idInt64Nogt=0Unique player identifier
player_nameStringYes—Player full name
team_idInt64Yes—Team identifier
team_nameStringYes—Team name
periodInt64Yes—Game period number
minutes_remainingInt64Yes—Minutes remaining in period
seconds_remainingInt64Yes—Seconds remaining in period
event_typeStringYes—Shot event type (Made/Missed)
action_typeStringYes—Specific shot action type
shot_typeStringYes—Shot type (2PT/3PT Field Goal)
shot_zone_basicStringYes—Basic shot zone category
shot_zone_areaStringYes—Shot zone area on court
shot_zone_rangeStringYes—Shot distance range bucket
shot_distanceInt64Yes—Shot distance in feet
loc_xInt64Yes—Shot X coordinate on court
loc_yInt64Yes—Shot Y coordinate on court
shot_attempted_flagInt64Yes—Flag indicating shot was attempted
shot_made_flagInt64Yes—Flag indicating shot was made
game_dateStringYes—Date of the game
htmStringYes—Home team abbreviation
vtmStringYes—Visitor team abbreviation

raw_shot_chart_league_wide

Class: RawShotChartLeagueWideSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
grid_typeStringYes—Shot chart grid type
shot_zone_basicStringYes—Basic shot zone category
shot_zone_areaStringYes—Shot zone area on court
shot_zone_rangeStringYes—Shot distance range bucket
fgaInt64Yes—Field goals attempted
fgmInt64Yes—Field goals made
fg_pctFloat64Yes—Field goal percentage

raw_synergy_play_types

Class: RawSynergyPlayTypesSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
season_idStringYes—NBA season identifier
team_idInt64Yes—Team identifier
team_abbreviationStringYes—Team abbreviation code
team_nameStringYes—Team name
player_idInt64Yes—Unique player identifier
player_nameStringYes—Player full name
play_typeStringYes—Synergy play type classification
type_groupingStringYes—Offensive or defensive grouping
percentileFloat64Yes—Percentile rank for play type
gpInt64Yes—Games played
poss_pctFloat64Yes—Percentage of possessions
pppFloat64Yes—Points per possession
fg_pctFloat64Yes—Field goal percentage
ft_pct_adjustFloat64Yes—Free throw percentage adjusted
to_pctFloat64Yes—Turnover percentage
sf_pctFloat64Yes—Shooting foul percentage
plusone_pctFloat64Yes—And-one conversion percentage
score_pctFloat64Yes—Scoring percentage
efg_pctFloat64Yes—Effective field goal percentage
possInt64Yes—Total possessions
ptsFloat64Yes—Total points scored
fgmInt64Yes—Field goals made
fgaInt64Yes—Field goals attempted
fgmxInt64Yes—Field goals missed

raw_team_details

Class: RawTeamDetailsSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
team_idInt64Nogt=0Unique team identifier
abbreviationStringYes—Team abbreviation code
nicknameStringYes—Team nickname
yearfoundedInt64Yes—Year the team was founded
cityStringYes—Team city name
arenaStringYes—Home arena name
arenacapacityInt64Yes—Arena seating capacity
ownerStringYes—Team owner name
generalmanagerStringYes—General manager name
headcoachStringYes—Head coach name
dleagueaffiliationStringYes—G-League affiliate team name

raw_team_game_log

Class: RawTeamGameLogSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
season_idStringNo—Season identifier
team_idInt64Nogt=0Unique team identifier
team_abbreviationStringNo—Team abbreviation code
team_nameStringNo—Team name
game_idStringNo—Unique game identifier
game_dateStringNo—Date of the game
matchupStringNo—Matchup string (e.g. LAL vs. BOS)
wlStringYes—Win or loss indicator
wInt64Yes—Wins
lInt64Yes—Losses
w_pctFloat64Yes—Win percentage
minFloat64Yes—Minutes played
fgmFloat64Yes—Field goals made
fgaFloat64Yes—Field goals attempted
fg_pctFloat64Yes—Field goal percentage
fg3mFloat64Yes—Three-point field goals made
fg3aFloat64Yes—Three-point field goals attempted
fg3_pctFloat64Yes—Three-point field goal percentage
ftmFloat64Yes—Free throws made
ftaFloat64Yes—Free throws attempted
ft_pctFloat64Yes—Free throw percentage
orebFloat64Yes—Offensive rebounds
drebFloat64Yes—Defensive rebounds
rebFloat64Yes—Total rebounds
astFloat64Yes—Assists
stlFloat64Yes—Steals
blkFloat64Yes—Blocks
tovFloat64Yes—Turnovers
pfFloat64Yes—Personal fouls
ptsFloat64Yes—Points scored
plus_minusFloat64Yes—Plus-minus differential
video_availableInt64Yes—Video availability flag

raw_team_info_common

Class: RawTeamInfoCommonSchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
team_idInt64Nogt=0Unique team identifier
season_yearStringYes—Season year string
team_cityStringYes—Team city name
team_nameStringYes—Team name
team_abbreviationStringYes—Team abbreviation code
team_conferenceStringYes—Conference name
team_divisionStringYes—Division name
team_codeStringYes—Team code slug
team_slugStringYes—URL-friendly team slug
wInt64Yes—Wins
lInt64Yes—Losses
pctFloat64Yes—Win percentage
conf_rankInt64Yes—Conference ranking
div_rankInt64Yes—Division ranking
min_yearStringYes—First year of team activity
max_yearStringYes—Last year of team activity

raw_win_probability

Class: RawWinProbabilitySchema Coerce: True | Strict: False

ColumnTypeNullableConstraintsDescription
game_idStringNo—Unique game identifier
event_numInt64No—Event sequence number
home_pctFloat64Yes—Home team win probability
visitor_pctFloat64Yes—Visitor team win probability
home_ptsInt64Yes—Home team points
visitor_ptsInt64Yes—Visitor team points
home_score_marginInt64Yes—Home team score margin
periodInt64Yes—Game period number
seconds_remainingFloat64Yes—Seconds remaining in period
home_team_idInt64Yes—Home team identifier
home_team_abbStringYes—Home team abbreviation code
visitor_team_idInt64Yes—Visitor team identifier
visitor_team_abbStringYes—Visitor team abbreviation code
descriptionStringYes—Text description of the play
locationStringYes—Home or away location indicator
pctimestringStringYes—Period clock time string
is_score_changeInt64Yes—Flag indicating if score changed

Companion cuts

Use curated docs when the contract is clear but the context is not

These pages help once you have confirmed the raw shape and need meaning, feed context, or pipeline placement.

Curated naming guide

Decode raw column patterns quickly

Translate suffixes, identifiers, and repeated field families that appear across raw contracts.

Curated source context

Reconnect schemas to endpoint families

Use the endpoint scouting report when you need extractor and result-set context around a raw schema block.

Curated system map

See where raw sits in the pipeline

Move from schema-level exactness into the broader extract → stage → transform flow.

Next possession

From inbound feed to warehouse context

Raw contracts tell you exactly what arrived from nba_api. These next stops explain how those source-native fields map to endpoint families, naming conventions, and pipeline stages.

Section hub
Data Dictionary

Field Reference

Decode recurring suffixes, IDs, rates, and naming habits before scanning source-heavy column lists.

Endpoints

Endpoints

Reconnect raw schemas to the extractor families and result sets that produced them.

Diagrams

Pipeline Flow

See where raw capture sits between extraction, staging validation, and downstream transforms.

Analytics Views

Playbook for the 4 analytics_ outputs that pre-join common analytical workflows

Schema Reference — Staging

Complete schema docs for staging tier

On this page

Schema Reference — Rawraw_box_score_advanced_playerraw_box_score_defensive_playerraw_box_score_four_factors_playerraw_box_score_hustle_playerraw_box_score_matchupsraw_box_score_misc_playerraw_box_score_player_trackraw_box_score_scoring_playerraw_box_score_traditional_playerraw_box_score_traditional_teamraw_box_score_usage_playerraw_common_all_playersraw_common_player_inforaw_common_team_roster_coachesraw_common_team_rosterraw_common_team_yearsraw_draft_combine_drill_resultsraw_draft_combine_non_stationary_shootingraw_draft_combine_player_anthroraw_draft_combine_spot_shootingraw_draft_combine_statsraw_draft_historyraw_franchise_historyraw_game_rotationraw_league_game_lograw_league_season_matchupsraw_league_standings_v3raw_play_by_play_v2raw_play_by_play_v3raw_player_awardsraw_player_career_statsraw_player_game_lograw_player_indexraw_playoff_pictureraw_schedule_league_v2raw_scoreboard_v2raw_shot_chart_detailraw_shot_chart_league_wideraw_synergy_play_typesraw_team_detailsraw_team_game_lograw_team_info_commonraw_win_probability