Shared column schema: espn nba game all team schema

Columns shared verbatim across: espn_nba_game_all, espn_nba_team_box, load_nba_team_box.

Details

col_name	types	description
game_id	integer	Unique game identifier.
season	integer	Season identifier (4-digit year or 'YYYY-YY' string).
season_type	integer	Season type (1=pre-season, 2=regular season, 3=postseason, 4=off-season for ESPN; or string label for WNBA Stats).
game_date	Date	Game date (YYYY-MM-DD).
game_date_time	POSIXct	Game start date/time (ISO 8601).
team_id	integer	Unique team identifier.
team_uid	character	ESPN universal team identifier (UID format 's:40~l:...~t:...').
team_slug	character	URL-safe team identifier (e.g. 'lasvegas-aces' / 'aces').
team_location	character	Team city or location string.
team_name	character	Full team display name (e.g. 'Las Vegas Aces').
team_abbreviation	character	Short team abbreviation (e.g. 'LAS').
team_display_name	character	Full team display name.
team_short_display_name	character	Short team display name (e.g. 'Aces').
team_color	character	Team primary color (hex without leading '#').
team_alternate_color	character	Team alternate color (hex without leading '#').
team_logo	character	Team logo image URL.
team_home_away	character	Team home away.
team_score	integer	Team's score / final score.
team_winner	logical	TRUE if the team won this game.
assists	integer	Total assists.
blocks	integer	Total blocks.
defensive_rebounds	integer	Defensive rebounds.
fast_break_points	character	Fast-break points scored.
field_goal_pct	numeric	Field goal percentage (0-1).
field_goals_made	integer	Field goals made (2-pt + 3-pt).
field_goals_attempted	integer	Field goal attempts (2-pt + 3-pt).
flagrant_fouls	integer	Total flagrant fouls.
fouls	integer	Personal fouls.
free_throw_pct	numeric	Free throw percentage (0-1).
free_throws_made	integer	Free throws made.
free_throws_attempted	integer	Free throw attempts.
largest_lead	character	Largest lead during the game.
offensive_rebounds	integer	Offensive rebounds.
points_in_paint	character	Points scored in the paint.
steals	integer	Total steals.
team_turnovers	integer	Team turnovers (turnovers credited to the team rather than a player).
technical_fouls	integer	Total technical fouls.
three_point_field_goal_pct	numeric	Three-point field goal percentage (0-1).
three_point_field_goals_made	integer	Three-point field goals made.
three_point_field_goals_attempted	integer	Three-point field goal attempts.
total_rebounds	integer	Total rebounds.
total_technical_fouls	integer	Total technical fouls (player + team).
total_turnovers	integer	Total turnovers (player + team).
turnover_points	character	Turnover points.
turnovers	integer	Total turnovers.
opponent_team_id	integer	Unique identifier for the opponent team.
opponent_team_uid	character	Opponent team uid.
opponent_team_slug	character	Opponent team slug.
opponent_team_location	character	Opponent team city / location.
opponent_team_name	character	Opponent team display name.
opponent_team_abbreviation	character	Opponent team abbreviation.
opponent_team_display_name	character	Opponent team full display name.
opponent_team_short_display_name	character	Opponent team short display name.
opponent_team_color	character	Opponent team primary color (hex).
opponent_team_alternate_color	character	Opponent team alternate color (hex).
opponent_team_logo	character	Opponent team logo URL.
opponent_team_score	integer	Opponent team's score.