{
    "action": "final",
    "content": "## What This Dataset Is About\n\nThis dataset captures **the complete competitive history and future planning of FIFA World Cup football**, spanning from the first tournament in 1930 through the upcoming 2026 edition. It combines historical match records, tournament summaries, and national team performance rankings to support analysis of World Cup outcomes, team strength evolution, and tournament planning.\n\n## What a Single Row Represents\n\nBecause this dataset contains **five independent tables**, a \"row\" means something different depending on which table you're examining:\n\n### Historical Match Records (65% of the data)\n**`raw.matches_1930_2022`** — 964 rows  \nEach row represents **one World Cup match** played between 1930 and 2022, capturing:\n- The competing teams (home and away)\n- Match outcome (scores, penalties, expected goals)\n- Context (date, venue, referee, tournament round)\n- Team leadership (captains, managers)\n\n### FIFA Rankings Snapshots (29% of the data)\n**`raw.fifa_ranking_2022_10_06`** and **`raw.fifa_ranking_2026_06_08`** — 211 rows each  \nEach row represents **one national team's ranking position** at a specific point in time:\n- October 6, 2022 snapshot\n- June 8, 2026 snapshot\n\nThese capture ranking position, points, and movement from the previous ranking period.\n\n### Tournament Summaries (1.5% of the data)\n**`raw.world_cup`** — 22 rows  \nEach row represents **one complete World Cup tournament** (1930–2022), summarizing:\n- Host nation and champion\n- Total attendance and matches played\n- Number of participating teams\n\n### Future Schedule (5% of the data)\n**`raw.schedule_2026`** — 72 rows  \nEach row represents **one planned match** in the 2026 World Cup, with fixture details like date, time, and competing teams.\n\n---\n\n**Key limitation**: These five tables have **no validated relationships** connecting them. You cannot natively join match outcomes to FIFA rankings or link tournament winners to their historical match records without manually establishing common keys (like standardized country codes or tournament identifiers)."
}