Shared column schema: espn mbb game all plays schema

Columns shared verbatim across: espn_mbb_game_all, espn_mbb_pbp.

Details

col_name	types	description
id	character	Id.
sequence_number	character	Sequence number representing a shot-possession (V3 PBP).
text	character	Text description of the play / record.
away_score	integer	Away team score at the time of the play.
home_score	integer	Home team score at the time of the play.
scoring_play	logical	TRUE if the play resulted in points scored.
score_value	integer	Point value of the play (2 / 3 / 1).
wallclock	character	Wallclock.
shooting_play	logical	TRUE if the play was a shooting attempt.
type_id	integer	Type identifier (numeric).
type_text	character	Display text for the type field.
period_number	integer	Numeric period (1-4 for quarters; 5+ for OT).
period_display_value	character	Period display label (e.g. '1st Quarter', 'OT').
clock_display_value	character	Game clock display string (e.g. '8:32').
team_id	integer	Unique team identifier.
coordinate_x_raw	numeric	X coordinate as returned by the API before any adjustment.
coordinate_y_raw	numeric	Y coordinate as returned by the API before any adjustment.
coordinate_x	numeric	X coordinate on the court (half-court layout).
coordinate_y	numeric	Y coordinate on the court (half-court layout).
play_id	character	Unique play identifier within a game.
athlete_id_1	integer	Primary athlete identifier (e.g. shooter).
athlete_id_2	integer	Secondary athlete identifier (e.g. assister / fouler).
home_team_id	integer	Unique identifier for the home team.
home_team_mascot	character	Home team mascot.
home_team_name	character	Home team name.
home_team_abbrev	character	Home team three-letter abbreviation.
home_team_logo	character	Home team logo URL.
home_team_logo_dark	character	Home team logo URL for dark backgrounds.
home_team_full_name	character	Full home team name (e.g. 'Las Vegas Aces').
home_team_color	character	Home team primary color (hex).
home_team_alternate_color	character	Home team alternate color (hex).
home_team_score	integer	Home team's score.
home_team_winner	logical	TRUE if the home team won this game.
home_team_record	character	Home team's win-loss record.
away_team_id	integer	Unique identifier for the away team.
away_team_mascot	character	Away team mascot.
away_team_name	character	Away team name.
away_team_abbrev	character	Away team three-letter abbreviation.
away_team_logo	character	Away team logo URL.
away_team_logo_dark	character	Away team logo URL for dark backgrounds.
away_team_full_name	character	Full away team name (e.g. 'Las Vegas Aces').
away_team_color	character	Away team primary color (hex).
away_team_alternate_color	character	Away team alternate color (hex).
away_team_score	integer	Away team's score.
away_team_winner	logical	TRUE if the away team won this game.
away_team_record	character	Away team's win-loss record.
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).