Based on the schema for the play-by-play tables (such as `2023_plays`), here are the columns, their data types, and what each one represents: ### Game & Timing Information * **`Season`** (`BIGINT`): The year of the NFL season (e.g., 2023). * **`Week`** (`VARCHAR`): The week of the season, including regular season weeks and playoff rounds (e.g., "WEEK 1", "WILD CARD WEEKEND"). * **`GameSlot`** (`VARCHAR`): The broadcast window or day of the game (e.g., "Thursday Night Football", "Sunday"). * **`Date`** (`VARCHAR`): The calendar date the game was played (e.g., "September 7th"). * **`Quarter`** (`VARCHAR`): The period of the game (e.g., "1st Quarter", "Overtime"). ### Team Information * **`AwayTeam`** (`VARCHAR`): The abbreviation of the visiting team (e.g., "ARI"). * **`HomeTeam`** (`VARCHAR`): The abbreviation of the home team (e.g., "WAS"). * **`TeamWithPossession`** (`VARCHAR`): The full name of the team currently on offense (e.g., "Arizona Cardinals"). ### Drive & Play Details * **`DriveNumber`** (`BIGINT`): The sequential number of the offensive drive within the game. * **`PlayNumberInDrive`** (`BIGINT`): The sequential number of the play within the current drive. * **`PlayStart`** (`VARCHAR`): The down, distance, and field position at the snap (e.g., "4th & 9 at WAS 9"). * **`PlayTimeFormation`** (`VARCHAR`): The game clock time remaining and/or formation context (e.g., "00:00 1st", "Kickoff"). * **`PlayOutcome`** (`VARCHAR`): A short summary of the play's result (e.g., "-1 Yard Pass", "Turnover on Downs"). * **`PlayDescription`** (`VARCHAR`): The detailed play-by-play text describing the events, players involved, and result of the play. ### Scoring Flags * **`IsScoringDrive`** (`BIGINT`): A boolean indicator (0 or 1) of whether the current drive eventually resulted in points. * **`IsScoringPlay`** (`BIGINT`): A boolean indicator (0 or 1) of whether this specific play resulted in points. ### System Metadata *(These columns are automatically generated during data ingestion and are used for auditing rather than analysis)* * **`_ingestion_timestamp`** (`TIMESTAMP`): When the record was loaded into the database. * **`_batch_id`** (`VARCHAR`): The identifier for the ingestion batch. * **`_source_file`** (`VARCHAR`): The original file path the data was loaded from. * **`_source_system`** (`VARCHAR`): The system that provided the data (e.g., "api").