```json { "classifications": [ { "column": "web-scraper-order", "role": "identifier", "confidence": 0.95, "reason": "Unique scraper-generated ID for each row, used for tracking/ordering" }, { "column": "web-scraper-start-url", "role": "attribute", "confidence": 0.9, "reason": "Single constant URL value, descriptive metadata about data source" }, { "column": "MatchLink", "role": "attribute", "confidence": 0.85, "reason": "Single constant value 'bout', descriptive label with no analytical value" }, { "column": "MatchLink-href", "role": "identifier", "confidence": 0.95, "reason": "Unique URL per match, serves as match identifier/key" }, { "column": "f_boxer", "role": "dimension", "confidence": 0.95, "reason": "Boxer name, low cardinality (5 values), used to group/filter matches" }, { "column": "s_boxer", "role": "dimension", "confidence": 0.95, "reason": "Opponent name, medium cardinality (26 values), used to group/filter" }, { "column": "f_boxer_result", "role": "dimension", "confidence": 0.95, "reason": "Categorical outcome (won/lost/drawn), used for filtering and grouping" }, { "column": "f_boxer_stance", "role": "dimension", "confidence": 0.9, "reason": "Categorical boxing stance, single value but still a grouping attribute" }, { "column": "f_boxer_age", "role": "measure", "confidence": 0.85, "reason": "Numeric age value that can be averaged/aggregated across matches" }, { "column": "f_boxer_height", "role": "attribute", "confidence": 0.9, "reason": "Physical measurement with units as formatted text, displayed not aggregated" }, { "column": "f_boxer_reach", "role": "attribute", "confidence": 0.9, "reason": "Physical measurement with units as formatted text, displayed not aggregated" }, { "column": "f_boxer_won", "role": "measure", "confidence": 0.95, "reason": "Numeric count of wins, aggregated with sum/avg" }, { "column": "f_boxer_lost", "role": "measure", "confidence": 0.95, "reason": "Numeric count of losses, aggregated with sum/avg" }, { "column": "f_boxer_drawn", "role": "measure", "confidence": 0.95, "reason": "Numeric count of draws, aggregated with sum/avg" }, { "column": "f_boxer_KOs", "role": "measure", "confidence": 0.95, "reason": "Numeric count of knockouts, aggregated with sum/avg" }, { "column": "f_boxer_ranking", "role": "measure", "confidence": 0.85, "reason": "Numeric ranking value that can be averaged/compared across matches" }, { "column": "s_boxer_ranking", "role": "measure", "confidence": 0.85, "reason": "Numeric ranking value that can be averaged/compared across matches" }, { "column": "s_boxer_age", "role": "measure", "confidence": 0.85, "reason": "Numeric age value that can be averaged/aggregated across matches" }, { "column": "s_boxer_stance", "role": "dimension", "confidence": 0.95, "reason": "Categorical boxing stance (orthodox/southpaw), used for grouping" }, { "column": "s_boxer_reach", "role": "attribute", "confidence": 0.9, "reason": "Physical measurement with units as formatted text, displayed not aggregated" }, { "column": "s_boxer_height", "role": "attribute", "confidence": 0.9, "reason": "Physical measurement with units as formatted text, displayed not aggregated" }, { "column": "s_boxer_won", "role": "measure", "confidence": 0.95, "reason": "Numeric count of wins, aggregated with sum/avg" }, { "column": "s_boxer_lost", "role": "measure", "confidence": 0.95, "reason": "Numeric count of losses, aggregated with sum/avg" }, { "column": "s_boxer_drawn", "role": "measure", "confidence": 0.95, "reason": "Numeric count of draws, aggregated with sum/avg" }, { "column": "s_boxer_KOs", "role": "measure", "confidence": 0.95, "reason": "Numeric count of knockouts, aggregated with sum/avg" }, { "column": "rounds", "role": "attribute", "confidence": 0.9, "reason": "Free-form text with match details and round info, displayed not aggregated" } ] } ```