# Column Classification for matches_1930_2022 Based on the evidence gathered from inspecting the dataset, here is the classification of all 48 columns: ## **Identifiers** No clear primary key identifiers were found in the dataset. Each row appears to represent a unique match, but there's no single ID column. ## **Dates/Times** (2 columns) - **Date** (DATE) - Match date, ranging from 1930-07-13 to 2022-12-18, 391 distinct values - **Year** (BIGINT) - Match year, ranging from 1930 to 2022, 21 distinct values ## **Categorical Dimensions** (9 columns) - **home_team** (VARCHAR) - ~72 distinct teams - **away_team** (VARCHAR) - ~78 distinct teams - **Round** (VARCHAR) - ~13 distinct values (Final, Third-place match, etc.) - **home_manager** (VARCHAR) - ~285 distinct managers - **Referee** (VARCHAR) - ~313 distinct referees - **Venue** (VARCHAR) - ~214 distinct venues - **Host** (VARCHAR) - ~16 distinct host countries (Argentina to Uruguay) - **home_captain** (VARCHAR) - ~323 distinct captains - **away_captain** (VARCHAR) - ~359 distinct captains ## **Numeric Metrics** (8 columns) - **home_score** (BIGINT) - Range 0-10, ~12 distinct values - **away_score** (BIGINT) - Range 0-7, ~7 distinct values - **home_xg** (DOUBLE) - Expected goals, range 0.1-5.2, 836 nulls - **away_xg** (DOUBLE) - Expected goals, range 0.0-5.7, 836 nulls - **home_penalty** (BIGINT) - Range 0-5, 929 nulls - **away_penalty** (BIGINT) - Range 0-5, 929 nulls - **Attendance** (BIGINT) - Range 2,000-173,850, ~800 distinct values - **away_manager** (VARCHAR) - ~320 distinct managers ## **Descriptive Attributes** (29 columns) Text fields containing detailed match information: - **Score** (VARCHAR) - ~66 distinct score formats - **Officials** (VARCHAR) - ~754 distinct official combinations - **Notes** (VARCHAR) - ~20 distinct match notes - **home_goal** (VARCHAR) - ~781 distinct goal descriptions - **away_goal** (VARCHAR) - ~610 distinct goal descriptions - **home_goal_long** (VARCHAR) - ~662 distinct detailed goal records - **away_goal_long** (VARCHAR) - ~536 distinct detailed goal records - **home_own_goal** (VARCHAR) - ~39 distinct values - **away_own_goal** (VARCHAR) - ~16 distinct values - **home_penalty_goal** (VARCHAR) - ~139 distinct values - **away_penalty_goal** (VARCHAR) - ~75 distinct values - **home_penalty_miss_long** (VARCHAR) - **away_penalty_miss_long** (VARCHAR) - **home_penalty_shootout_goal_long** (VARCHAR) - **away_penalty_shootout_goal_long** (VARCHAR) - **home_penalty_shootout_miss_long** (VARCHAR) - **away_penalty_shootout_miss_long** (VARCHAR) - **home_red_card** (VARCHAR) - **away_red_card** (VARCHAR) - **home_yellow_red_card** (VARCHAR) - **away_yellow_red_card** (VARCHAR) - **home_yellow_card_long** (VARCHAR) - **away_yellow_card_long** (VARCHAR) - **home_substitute_in_long** (VARCHAR) - **away_substitute_in_long** (VARCHAR) - **_ingestion_timestamp** - Metadata - **_batch_id** - Metadata - **_source_file** - Metadata - **_source_system** - Metadata **Note:** Only 30 of 48 columns were fully detailed in the evidence. The remaining 18 columns (listed in the error message from step-2) are confirmed to exist but detailed statistics were not obtained.