```json { "classifications": [ {"column": "home_team", "role": "dimension", "confidence": 1.0, "reason": "Team name used for grouping and filtering"}, {"column": "away_team", "role": "dimension", "confidence": 1.0, "reason": "Team name used for grouping and filtering"}, {"column": "home_score", "role": "measure", "confidence": 1.0, "reason": "Numeric score to be aggregated (sum/avg)"}, {"column": "home_xg", "role": "measure", "confidence": 1.0, "reason": "Expected goals metric to be aggregated"}, {"column": "home_penalty", "role": "measure", "confidence": 1.0, "reason": "Penalty count to be aggregated"}, {"column": "away_score", "role": "measure", "confidence": 1.0, "reason": "Numeric score to be aggregated (sum/avg)"}, {"column": "away_xg", "role": "measure", "confidence": 1.0, "reason": "Expected goals metric to be aggregated"}, {"column": "away_penalty", "role": "measure", "confidence": 1.0, "reason": "Penalty count to be aggregated"}, {"column": "home_manager", "role": "dimension", "confidence": 0.95, "reason": "Manager name used for grouping/filtering"}, {"column": "home_captain", "role": "dimension", "confidence": 0.95, "reason": "Captain name used for grouping/filtering"}, {"column": "away_manager", "role": "dimension", "confidence": 0.95, "reason": "Manager name used for grouping/filtering"}, {"column": "away_captain", "role": "dimension", "confidence": 0.95, "reason": "Captain name used for grouping/filtering"}, {"column": "Attendance", "role": "measure", "confidence": 1.0, "reason": "Numeric attendance to be aggregated (sum/avg)"}, {"column": "Venue", "role": "dimension", "confidence": 1.0, "reason": "Venue location used for grouping/filtering"}, {"column": "Officials", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text listing officials, displayed but not grouped"}, {"column": "Round", "role": "dimension", "confidence": 1.0, "reason": "Tournament round used for grouping/filtering"}, {"column": "Date", "role": "dimension", "confidence": 1.0, "reason": "Date used for grouping and time-based filtering"}, {"column": "Score", "role": "attribute", "confidence": 0.9, "reason": "Formatted score string for display, not aggregated"}, {"column": "Referee", "role": "dimension", "confidence": 0.95, "reason": "Referee name used for grouping/filtering"}, {"column": "Notes", "role": "attribute", "confidence": 1.0, "reason": "Free-form descriptive text for display"}, {"column": "Host", "role": "dimension", "confidence": 1.0, "reason": "Host country used for grouping/filtering"}, {"column": "Year", "role": "dimension", "confidence": 1.0, "reason": "Year used for grouping and filtering"}, {"column": "home_goal", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text listing goal scorers and times"}, {"column": "away_goal", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text listing goal scorers and times"}, {"column": "home_goal_long", "role": "attribute", "confidence": 1.0, "reason": "Detailed goal information for display"}, {"column": "away_goal_long", "role": "attribute", "confidence": 1.0, "reason": "Detailed goal information for display"}, {"column": "home_own_goal", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text listing own goals"}, {"column": "away_own_goal", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text listing own goals"}, {"column": "home_penalty_goal", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text listing penalty goals"}, {"column": "away_penalty_goal", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text listing penalty goals"}, {"column": "home_penalty_miss_long", "role": "attribute", "confidence": 1.0, "reason": "Detailed penalty miss information for display"}, {"column": "away_penalty_miss_long", "role": "attribute", "confidence": 1.0, "reason": "Detailed penalty miss information for display"}, {"column": "home_penalty_shootout_goal_long", "role": "attribute", "confidence": 1.0, "reason": "Detailed shootout goal information for display"}, {"column": "away_penalty_shootout_goal_long", "role": "attribute", "confidence": 1.0, "reason": "Detailed shootout goal information for display"}, {"column": "home_penalty_shootout_miss_long", "role": "attribute", "confidence": 1.0, "reason": "Detailed shootout miss information for display"}, {"column": "away_penalty_shootout_miss_long", "role": "attribute", "confidence": 1.0, "reason": "Detailed shootout miss information for display"}, {"column": "home_red_card", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text listing red cards"}, {"column": "away_red_card", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text listing red cards"}, {"column": "home_yellow_red_card", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text listing yellow-red cards"}, {"column": "away_yellow_red_card", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text listing yellow-red cards"}, {"column": "home_yellow_card_long", "role": "attribute", "confidence": 1.0, "reason": "Detailed yellow card information for display"}, {"column": "away_yellow_card_long", "role": "attribute", "confidence": 1.0, "reason": "Detailed yellow card information for display"}, {"column": "home_substitute_in_long", "role": "attribute", "confidence": 1.0, "reason": "Detailed substitution information for display"}, {"column": "away_substitute_in_long", "role": "attribute", "confidence": 1.0, "reason": "Detailed substitution information for display"} ] } ```