```json { "action": "final", "content": "## Dataset Columns: matches_1930_2022\n\nThis table contains **44 columns** documenting World Cup matches from 1930 to 2022. Here's what each column represents:\n\n### Match Identification & Context\n- **Date** (DATE) — When the match was played (1930-07-13 to 2022-12-18)\n- **Year** (BIGINT) — Tournament year (1930 to 2022)\n- **Round** (VARCHAR) — Stage of tournament (Final, Semi-finals, Group stage, etc.; 13 distinct values)\n- **Host** (VARCHAR) — Host country for that World Cup (16 different hosts)\n- **Venue** (VARCHAR) — Specific stadium where match was played (214 distinct venues)\n\n### Teams & Personnel\n- **home_team** (VARCHAR) — Home team name (72 distinct teams)\n- **away_team** (VARCHAR) — Away team name (78 distinct teams)\n- **home_manager** (VARCHAR) — Home team's manager/coach (285 distinct)\n- **away_manager** (VARCHAR) — Away team's manager/coach (320 distinct)\n- **home_captain** (VARCHAR) — Home team captain (323 distinct)\n- **away_captain** (VARCHAR) — Away team captain (359 distinct)\n\n### Match Officials\n- **Referee** (VARCHAR) — Match referee (313 distinct referees)\n- **Officials** (VARCHAR) — Full officiating crew details (referee + assistant referees)\n\n### Scores & Results\n- **home_score** (BIGINT) — Goals scored by home team (0 to 10)\n- **away_score** (BIGINT) — Goals scored by away team (0 to 7)\n- **Score** (VARCHAR) — Formatted score string including penalty shootout results\n- **home_penalty** (BIGINT) — Home team penalty shootout score (0 to 5; null for 929 matches without shootouts)\n- **away_penalty** (BIGINT) — Away team penalty shootout score (0 to 5; null for 929 matches)\n\n### Advanced Metrics\n- **home_xg** (DOUBLE) — Home team expected goals (0.1 to 5.2; null for 836 older matches)\n- **away_xg** (DOUBLE) — Away team expected goals (0.0 to 5.7; null for 836 matches)\n\n### Goal Details (text descriptions)\n- **home_goal** (VARCHAR) — Home team goal scorers and times\n- **away_goal** (VARCHAR) — Away team goal scorers and times\n- **home_goal_long** (VARCHAR) — Detailed home goals with assists\n- **away_goal_long** (VARCHAR) — Detailed away goals with assists\n- **home_penalty_goal** (VARCHAR) — Home penalty goals during regular play\n- **away_penalty_goal** (VARCHAR) — Away penalty goals during regular play\n- **home_own_goal** (VARCHAR) — Own goals benefiting home team\n- **away_own_goal** (VARCHAR) — Own goals benefiting away team\n\n### Penalty Shootout Details\n- **home_penalty_shootout_goal_long** (VARCHAR) — Home shootout goals detail\n- **away_penalty_shootout_goal_long** (VARCHAR) — Away shootout goals detail\n- **home_penalty_shootout_miss_long** (VARCHAR) — Home shootout misses detail\n- **away_penalty_shootout_miss_long** (VARCHAR) — Away shootout misses detail\n- **home_penalty_miss_long** (VARCHAR) — Home penalty misses in regular play\n- **away_penalty_miss_long** (VARCHAR) — Away penalty misses in regular play\n\n### Disciplinary Actions\n- **home_yellow_card_long** (VARCHAR) — Home team yellow cards (player, time)\n- **away_yellow_card_long** (VARCHAR) — Away team yellow cards\n- **home_red_card** (VARCHAR) — Home team red cards\n- **away_red_card** (VARCHAR) — Away team red cards\n- **home_yellow_red_card** (VARCHAR) — Home team second yellow → red cards\n- **away_yellow_red_card** (VARCHAR) — Away team second yellow → red cards\n\n### Substitutions\n- **home_substitute_in_long** (VARCHAR) — Home team substitutions detail\n- **away_substitute_in_long** (VARCHAR) — Away team substitutions detail\n\n### Other Match Data\n- **Attendance** (BIGINT) — Crowd size (2,000 to 173,850)\n- **Notes** (VARCHAR) — Special match notes (e.g., \"won on penalty kicks following extra time\")\n\nThe table contains **964 rows** total, with no null values in core fields like teams, scores, date, and attendance. Advanced metrics (xG) and penalty shootout data are only available for recent tournaments." } ```