```json { "action": "final", "content": "The dataset consists of two main types of tables: a comprehensive game scores table (`2010_2026_scores`) and play-by-play tables for each season (e.g., `2023_plays`). \n\nHere are the columns, their data types, and their meanings for both table structures:\n\n### Game Scores Table (`2010_2026_scores`)\nThis table contains game-level summaries and final scores for all games from 2010 to 2026.\n\n* **Season** (`BIGINT`): The year of the NFL season.\n* **Week** (`VARCHAR`): The week of the season (e.g., \"Week 1\", \"WILD CARD WEEKEND\").\n* **GameStatus** (`VARCHAR`): The current status of the game (e.g., \"FINAL\", \"TBD\", \"BYE\").\n* **GameSlot** (`VARCHAR`): The day or broadcast slot of the game (e.g., \"Sunday Night Football\", \"Thursday\").\n* **GameDate** (`VARCHAR`): The specific date the game was played.\n* **AwayTeam** (`VARCHAR`): The abbreviation of the visiting team (e.g., \"ARI\").\n* **AwayScore** (`DOUBLE`): The final points scored by the away team.\n* **HomeTeam** (`VARCHAR`): The abbreviation of the hosting team.\n* **HomeScore** (`DOUBLE`): The final points scored by the home team.\n\n### Play-by-Play Tables (e.g., `2023_plays`)\nThese tables contain granular, play-by-play event logs for every game in a specific season.\n\n* **Season** (`BIGINT`): The year of the NFL season.\n* **Week** (`VARCHAR`): The week of the season.\n* **GameSlot** (`VARCHAR`): The day or broadcast slot of the game.\n* **Date** (`VARCHAR`): The date the game was played.\n* **AwayTeam** (`VARCHAR`): The abbreviation of the visiting team.\n* **HomeTeam** (`VARCHAR`): The abbreviation of the hosting team.\n* **Quarter** (`VARCHAR`): The quarter of the game (e.g., \"1st Quarter\", \"Overtime\").\n* **DriveNumber** (`BIGINT`): The sequential number of the drive within the game.\n* **TeamWithPossession** (`VARCHAR`): The full name of the team currently on offense.\n* **IsScoringDrive** (`BIGINT`): A boolean indicator (0 or 1) of whether the drive eventually resulted in points.\n* **PlayNumberInDrive** (`BIGINT`): The sequential number of the play within the current drive.\n* **IsScoringPlay** (`BIGINT`): A boolean indicator (0 or 1) of whether this specific play resulted in points.\n* **PlayOutcome** (`VARCHAR`): A short categorization of the play's result (e.g., \"Turnover on Downs\", \"Pass\").\n* **PlayStart** (`VARCHAR`): The down, distance, and field position at the snap (e.g., \"4th & 9 at WAS 9\").\n* **PlayTimeFormation** (`VARCHAR`): The game clock time remaining and the offensive formation.\n* **PlayDescription** (`VARCHAR`): A detailed text narrative of the play's events and players involved.\n\n*(Note: Both tables also include standard system metadata columns: `_ingestion_timestamp`, `_batch_id`, `_source_file`, and `_source_system`)*." } ```