```json { "slots": [ { "scope": "dataset", "slot": "nature", "value": { "nature": "observational" }, "evidence": { "reasoning": "This dataset records historical FIFA World Cup match results, rankings, and tournament outcomes from 1930-2022, plus a future schedule for 2026. The data measures phenomena (match outcomes, team rankings, attendance) that occurred through competitive play, not through a business process controlled by the dataset owner. The Kaggle source confirms this is a curated historical sports dataset." } }, { "scope": "dataset", "slot": "decisions_served", "value": { "decisions": [ "Which teams to analyze for historical performance patterns when predicting tournament outcomes", "Whether a team's FIFA ranking correlates with World Cup success", "Which historical matches to study when preparing scouting reports", "How to allocate tournament hosting resources based on historical attendance patterns", "Which referee assignments or venue selections correlate with match outcomes" ] }, "evidence": { "reasoning": "The dataset combines historical match results with rankings and tournament metadata, enabling analysts to evaluate team performance trends, validate ranking systems against actual results, and inform tournament planning decisions based on attendance and operational patterns." } }, { "scope": "dataset", "slot": "levers", "value": { "levers": [] }, "evidence": { "reasoning": "This is observational sports data recording match outcomes, rankings, and tournament results. No operator controls which team wins matches, what FIFA rankings are assigned, or historical attendance figures. The 2026 schedule is a plan, not a lever—actual match outcomes remain uncontrolled." } }, { "scope": "dataset", "slot": "audience", "value": { "audience": [ "Sports analysts and statisticians", "Tournament organizers and FIFA officials", "Team coaches and scouting staff", "Sports journalists and commentators", "Betting analysts and predictive modelers", "Academic researchers studying sports competition" ] }, "evidence": { "reasoning": "The combination of match-level detail, rankings at specific dates, and tournament summaries serves multiple audiences: analysts studying performance, organizers planning events, coaches preparing strategies, and researchers modeling competitive outcomes." } }, { "scope": "table:fifa_ranking_2022_10_06", "slot": "role", "value": { "role": "dimension" } }, { "scope": "table:fifa_ranking_2022_10_06", "slot": "grain", "value": { "unit": "one row per team at the 2022-10-06 ranking snapshot", "key_columns": ["team", "team_code"] }, "evidence": { "reasoning": "Each row represents a unique team's ranking position on October 6, 2022. The _ingestion_timestamp shows a single snapshot date, and all 211 teams have unique ranks. This is a point-in-time dimension table capturing team standings before the 2022 World Cup." } }, { "scope": "table:fifa_ranking_2022_10_06", "slot": "temporal_posture", "value": { "posture": "snapshot", "columns": ["_ingestion_timestamp"] }, "evidence": { "reasoning": "The table represents a single point-in-time snapshot (2022-10-06 per filename and ingestion timestamp). The 'previous_rank' and 'previous_points' columns reference an earlier state, but the table itself is a static snapshot, not a time series." } }, { "scope": "table:fifa_ranking_2022_10_06", "slot": "column_bindings", "value": { "bindings": [ {"column": "team", "binding": "identifier"}, {"column": "team_code", "binding": "identifier"}, {"column": "association", "binding": "category"}, {"column": "rank", "binding": "measure"}, {"column": "previous_rank", "binding": "measure"}, {"column": "points", "binding": "measure"}, {"column": "previous_points", "binding": "measure"} ] }, "evidence": { "reasoning": "Rank, previous_rank, points, and previous_points are measures representing team performance metrics. Association is a categorical grouping (confederation). Team and team_code are identifiers for the grain." } }, { "scope": "table:fifa_ranking_2026_06_08", "slot": "role", "value": { "role": "dimension" }, "evidence": { "reasoning": "Despite having 'rated_matches' as a measure, this table's primary purpose is to provide team rankings as of June 8, 2026—a reference dimension for team standings. The measure is descriptive metadata about ranking calculation, not a fact being analyzed." } }, { "scope": "table:fifa_ranking_2026_06_08", "slot": "grain", "value": { "unit": "one row per team at the 2026-06-08 ranking snapshot", "key_columns": ["team", "team_code"] }, "evidence": { "reasoning": "Parallel structure to fifa_ranking_2022_10_06 but with an additional 'rated_matches' column. Each row represents a unique team's ranking on June 8, 2026, just before the 2026 World Cup begins (per schedule_2026 starting June 11)." } }, { "scope": "table:fifa_ranking_2026_06_08", "slot": "temporal_posture", "value": { "posture": "snapshot", "columns": ["_ingestion_timestamp"] } }, { "scope": "table:fifa_ranking_2026_06_08", "slot": "column_bindings", "value": { "bindings": [ {"column": "team", "binding": "identifier"}, {"column": "team_code", "binding": "identifier"}, {"column": "association", "binding": "category"}, {"column": "rank", "binding": "measure"}, {"column": "previous_rank", "binding": "measure"}, {"column": "points", "binding": "measure"}, {"column": "previous_points", "binding": "measure"}, {"column": "rated_matches", "binding": "measure"} ] } }, { "scope": "table:matches_1930_2022", "slot": "role", "value": { "role": "fact" } }, { "scope": "table:matches_1930_2022", "slot": "grain", "value": { "unit": "one row per World Cup match", "key_columns": ["home_team", "away_team", "Date"] }, "evidence": { "reasoning": "Each row represents a single match between two teams on a specific date. The composite key of home_team, away_team, and Date uniquely identifies matches across all World Cups from 1930-2022 (964 matches across 22 tournaments)." } }, { "scope": "table:matches_1930_2022", "slot": "temporal_posture", "value": { "posture": "typed", "columns": ["Date", "Year"] }, "evidence": { "reasoning": "Date is the primary temporal dimension (match date), and Year provides tournament-level temporal grouping. Both are typed temporal columns enabling time-based analysis of match history." } }, { "scope": "table:matches_1930_2022", "slot": "column_bindings", "value": { "bindings": [ {"column": "home_team", "binding": "identifier"}, {"column": "away_team", "binding": "identifier"}, {"column": "Date", "binding": "temporal"}, {"column": "Year", "binding": "temporal"}, {"column": "home_score", "binding": "measure"}, {"column": "away_score", "binding": "measure"}, {"column": "home_xg", "binding": "measure"}, {"column": "away_xg", "binding": "measure"}, {"column": "home_penalty", "binding": "measure"}, {"column": "away_penalty", "binding": "measure"}, {"column": "Attendance", "binding": "measure"}, {"column": "Round", "binding": "category"}, {"column": "Host", "binding": "category"}, {"column": "Venue", "binding": "category"}, {"column": "Referee", "binding": "category"}, {"column": "home_manager", "binding": "category"}, {"column": "away_manager", "binding": "category"}, {"column": "home_captain", "binding": "category"}, {"column": "away_captain", "binding": "category"} ] }, "evidence": { "reasoning": "Scores, xG, penalties, and attendance are match outcome measures. Round, Host, Venue, Referee, managers, and captains are categorical context. The numerous goal/card detail columns are textual attributes documenting match events, not measures for aggregation." } }, { "scope": "table:schedule_2026", "slot": "role", "value": { "role": "dimension" }, "evidence": { "reasoning": "This table lists planned future matches for the 2026 World Cup with empty Score and Referee fields. It serves as a reference dimension for scheduled matchups, not a fact table recording outcomes." } }, { "scope": "table:schedule_2026", "slot": "grain", "value": { "unit": "one row per scheduled 2026 World Cup match", "key_columns": ["Date", "Time", "home_team", "away_team"] }, "evidence": { "reasoning": "Each row represents a planned match with specific date, time, and team pairing. The composite key uniquely identifies each of the 72 scheduled group stage matches." } }, { "scope": "table:schedule_2026", "slot": "temporal_posture", "value": { "posture": "typed", "columns": ["Date", "Day", "Time", "Year"] }, "evidence": { "reasoning": "Date is the primary temporal dimension, with Day providing day-of-week context and Time specifying match kickoff. Year is constant (2026) but typed temporal." } }, { "scope": "table:schedule_2026", "slot": "column_bindings", "value": { "bindings": [ {"column": "Date", "binding": "temporal"}, {"column": "Time", "binding": "temporal"}, {"column": "Day", "binding": "temporal"}, {"column": "Year", "binding": "temporal"}, {"column": "home_team", "binding": "identifier"}, {"column": "away_team", "binding": "identifier"}, {"column": "Round", "binding": "category"} ] } }, { "scope": "table:world_cup", "slot": "role", "value": { "role": "fact" } }, { "scope": "table:world_cup", "slot": "grain", "value": { "unit": "one row per World Cup tournament", "key_columns": ["Year"] } }, { "scope": "table:world_cup", "slot": "temporal_posture", "value": { "posture": "typed", "columns": ["Year"] } }, { "scope": "table:world_cup", "slot": "column_bindings", "value": { "bindings": [ {"column": "Year", "binding": "temporal"}, {"column": "Host", "binding": "category"}, {"column": "Champion", "binding": "category"}, {"column": "Runner-Up", "binding": "category"}, {"column": "Teams", "binding": "measure"}, {"column": "Matches", "binding": "measure"}, {"column": "Attendance", "binding": "measure"}, {"column": "AttendanceAvg", "binding": "measure"}, {"column": "TopScorrer", "binding": "category"} ] }, "evidence": { "reasoning": "Teams, Matches, Attendance, and AttendanceAvg are tournament-level aggregate measures. Host, Champion, Runner-Up, and TopScorrer are categorical outcomes. Year is the temporal grain." } } ] } ```