{
    "classifications": [
        {
            "column": "Company Name",
            "role": "identifier",
            "confidence": 0.7,
            "reason": "Near-unique per row (114 of 115 distinct); identifies the company/row"
        },
        {
            "column": "Founded",
            "role": "dimension",
            "confidence": 0.95,
            "reason": "Year value with 16 distinct values; used for grouping and filtering"
        },
        {
            "column": "Location",
            "role": "dimension",
            "confidence": 0.97,
            "reason": "Low-cardinality city category"
        },
        {
            "column": "Sector",
            "role": "dimension",
            "confidence": 0.96,
            "reason": "Category with 42 distinct values; used to group"
        },
        {
            "column": "What it does",
            "role": "attribute",
            "confidence": 0.97,
            "reason": "Free-form descriptive text, nearly unique"
        },
        {
            "column": "Founders",
            "role": "attribute",
            "confidence": 0.95,
            "reason": "Names of people, unique per row, displayed only"
        },
        {
            "column": "Investor",
            "role": "attribute",
            "confidence": 0.85,
            "reason": "Free-form list of investor names, high cardinality, multi-valued"
        },
        {
            "column": "Amount",
            "role": "measure",
            "confidence": 0.85,
            "reason": "Funding amount in dollars, stored as text with $ and commas; aggregated after cleaning"
        },
        {
            "column": "Stage",
            "role": "dimension",
            "confidence": 0.9,
            "reason": "Funding stage category with 12 distinct values, though some values are misplaced investor names"
        }
    ]
}