```json { "classifications": [ { "column": "question_number", "label": "none", "confidence": 0.95, "reason": "15 distinct values in 105 rows (14.3% distinct); repeating identifier for questions, not a key" }, { "column": "question_verbatim", "label": "none", "confidence": 0.95, "reason": "15 distinct values in 105 rows (14.3% distinct); descriptive text field, not a key" }, { "column": "response_verbatim", "label": "none", "confidence": 0.95, "reason": "65 distinct values in 105 rows (61.9% distinct); response text, not unique enough for key" }, { "column": "Question", "label": "none", "confidence": 0.95, "reason": "16 distinct values in 105 rows (15.2% distinct); categorical question label, not a key" }, { "column": "Response", "label": "none", "confidence": 0.95, "reason": "65 distinct values in 105 rows (61.9% distinct); categorical response label, not unique enough" }, { "column": "Overall", "label": "near_key", "confidence": 0.92, "reason": "104 distinct values in 105 rows (99.0% distinct); nearly unique percentage values, best key candidate" }, { "column": "Gender: Male", "label": "none", "confidence": 0.9, "reason": "101 distinct values in 105 rows (96.2% distinct); demographic metric, below 98% threshold" }, { "column": "Gender: Female", "label": "none", "confidence": 0.9, "reason": "101 distinct values in 105 rows (96.2% distinct); demographic metric, below 98% threshold" }, { "column": "Age: 18–29", "label": "none", "confidence": 0.9, "reason": "103 distinct values in 105 rows (98.1% distinct); demographic metric, just at threshold but not primary" }, { "column": "Age: 30–44", "label": "none", "confidence": 0.9, "reason": "104 distinct values in 105 rows (99.0% distinct); demographic metric, not a key" }, { "column": "Age: 45–59", "label": "none", "confidence": 0.9, "reason": "102 distinct values in 105 rows (97.1% distinct); demographic metric, below 98% threshold" }, { "column": "Age: 60+", "label": "none", "confidence": 0.9, "reason": "100 distinct values in 105 rows (95.2% distinct); demographic metric, below 98% threshold" }, { "column": "Income: Under $25K", "label": "none", "confidence": 0.9, "reason": "101 distinct values in 105 rows (96.2% distinct); demographic metric, below 98% threshold" }, { "column": "Income: $25K–$50K", "label": "none", "confidence": 0.9, "reason": "101 distinct values in 105 rows (96.2% distinct); demographic metric, below 98% threshold" }, { "column": "Income: $50K–$75K", "label": "none", "confidence": 0.9, "reason": "99 distinct values in 105 rows (94.3% distinct); demographic metric, below 98% threshold" }, { "column": "Income: $75K–$100K", "label": "none", "confidence": 0.9, "reason": "97 distinct values in 105 rows (92.4% distinct); demographic metric, below 98% threshold" }, { "column": "Income: $100K+", "label": "none", "confidence": 0.9, "reason": "101 distinct values in 105 rows (96.2% distinct); demographic metric, below 98% threshold" }, { "column": "Education: Less than HS", "label": "none", "confidence": 0.9, "reason": "86 distinct values in 105 rows (81.9% distinct); demographic metric, well below 98% threshold" }, { "column": "Education: High school", "label": "none", "confidence": 0.9, "reason": "102 distinct values in 105 rows (97.1% distinct); demographic metric, below 98% threshold" }, { "column": "Education: Some college", "label": "none", "confidence": 0.9, "reason": "104 distinct values in 105 rows (99.0% distinct); demographic metric, not a key" }, { "column": "Education: Bachelor+", "label": "none", "confidence": 0.9, "reason": "104 distinct values in 105 rows (99.0% distinct); demographic metric, not a key" }, { "column": "Employment: Full-time", "label": "none", "confidence": 0.9, "reason": "105 distinct values in 105 rows (100% distinct); demographic metric, but contextually not a primary key" }, { "column": "Employment: Part-time", "label": "none", "confidence": 0.9, "reason": "102 distinct values in 105 rows (97.1% distinct); demographic metric, below 98% threshold" }, { "column": "Race: White, Non-Hispanic", "label": "none", "confidence": 0.9, "reason": "103 distinct values in 105 rows (98.1% distinct); demographic metric, just at threshold but not primary" }, { "column": "Race: Black, Non-Hispanic", "label": "none", "confidence": 0.9, "reason": "99 distinct values in 105 rows (94.3% distinct); demographic metric, below 98% threshold" }, { "column": "Race: Hispanic", "label": "none", "confidence": 0.9, "reason": "104 distinct values in 105 rows (99.0% distinct); demographic metric, not a key" }, { "column": "Race: Other/2+, Non-Hispanic", "label": "none", "confidence": 0.9, "reason": "101 distinct values in 105 rows (96.2% distinct); demographic metric, below 98% threshold" }, { "column": "Region: Northeast", "label": "none", "confidence": 0.9, "reason": "102 distinct values in 105 rows (97.1% distinct); demographic metric, below 98% threshold" }, { "column": "Region: Midwest", "label": "none", "confidence": 0.9, "reason": "105 distinct values in 105 rows (100% distinct); demographic metric, but contextually not a primary key" }, { "column": "Region: South", "label": "none", "confidence": 0.9, "reason": "100 distinct values in 105 rows (95.2% distinct); demographic metric, below 98% threshold" }, { "column": "Region: West", "label": "none", "confidence": 0.9, "reason": "102 distinct values in 105 rows (97.1% distinct); demographic metric, below 98% threshold" }, { "column": "Occupation: Software & IT", "label": "none", "confidence": 0.9, "reason": "96 distinct values in 105 rows (91.4% distinct); demographic metric, below 98% threshold" }, { "column": "Occupation: Managers", "label": "none", "confidence": 0.9, "reason": "103 distinct values in 105 rows (98.1% distinct); demographic metric, just at threshold but not primary" }, { "column": "Occupation: Business, finance & legal", "label": "none", "confidence": 0.9, "reason": "103 distinct values in 105 rows (98.1% distinct); demographic metric, just at threshold but not primary" }, { "column": "Occupation: Education & social services", "label": "none", "confidence": 0.9, "reason": "94 distinct values in 105 rows (89.5% distinct); demographic metric, below 98% threshold" }, { "column": "Occupation: Engineering & science", "label": "none", "confidence": 0.9, "reason": "90 distinct values in 105 rows (85.7% distinct); demographic metric, below 98% threshold" }, { "column": "Occupation: Healthcare", "label": "none", "confidence": 0.9, "reason": "96 distinct values in 105 rows (91.4% distinct); demographic metric, below 98% threshold" }, { "column": "Occupation: Sales, office/admin & creative", "label": "none", "confidence": 0.9, "reason": "104 distinct values in 105 rows (99.0% distinct); demographic metric, not a key" }, { "column": "Occupation: Manual & in-person services", "label": "none", "confidence": 0.9, "reason": "101 distinct values in 105 rows (96.2% distinct); demographic metric, below 98% threshold" }, { "column": "Occupation: Other (please specify)", "label": "none", "confidence": 0.9, "reason": "87 distinct values in 105 rows (82.9% distinct); demographic metric, below 98% threshold" } ] } ```