{
    "action": "final",
    "content": "## Dataset Overview\n\nThis is an **NFL game scores dataset** spanning the 2010–2026 seasons, containing play-by-play data and game-level scoring records.\n\n### What a Single Row Represents\n\nThe dataset has two distinct row types across its 451 tables:\n\n**1. Game-level records** (in `raw.2010_2026_scores` — 6,185 rows)\n\nEach row represents **one NFL game**, capturing:\n- **When**: Season year, week designation (regular season weeks, playoffs, preseason), game date, and time slot (Sunday, Monday Night, Thursday, etc.)\n- **Who**: Away team and home team (39 distinct teams total)\n- **Outcome**: Away score and home score\n- **Status**: Whether the game is final, scheduled (TBD), or a bye week\n\nFor example, a single row might record that in Week 3 of the 2023 season, the Kansas City Chiefs (away) scored 41 points against the Chicago Bears (home) who scored 10, in a Sunday afternoon slot.\n\n**2. Play-by-play records** (in 430+ tables like `raw.2015_plays`, `raw.2023_WEEK_1_plays` — 1.8M+ rows total)\n\nEach row represents **one play** in an NFL game, with 20 columns tracking the play's details. These tables are organized by:\n- **Season** (e.g., `2015_plays` for all plays in 2015)\n- **Season + Week** (e.g., `2023_WEEK_1_plays` for Week 1 of 2023)\n\nThe play-by-play tables contain 55,000–57,000 plays per full season, capturing every snap, penalty, timeout, and scoring play.\n\n### Coverage\n\n- **Temporal span**: 2010–2026 (17 seasons; 2026 data is partial with only 13,183 plays)\n- **Games**: 6,185 total, though 837 have null scores (future/TBD games or byes)\n- **Plays**: 1,822,394 across all seasons\n- **Teams**: 39 distinct franchises\n\n### Key Use Cases\n\nThis dataset supports:\n- Game outcome analysis (scores, win/loss records, home/away performance)\n- Temporal trends (scoring patterns over seasons, playoff performance)\n- Team comparisons and head-to-head records\n- Play-by-play sequence analysis (when play tables are queried)\n- Scheduling patterns (game slots, bye weeks)\n\nThe pre-aggregated **gold tables** (542 available) provide ready-made breakdowns by team, season, week, game slot, and status, making common aggregations instant to query."
}