```json { "classifications": [ {"column": "Name", "role": "identifier", "confidence": 1.0, "reason": "Unique supercomputer name, 293 distinct values out of 482 rows, used to identify each system"}, {"column": "Status", "role": "dimension", "confidence": 1.0, "reason": "Single categorical value 'Existing', used for filtering/grouping"}, {"column": "Certainty", "role": "dimension", "confidence": 1.0, "reason": "Categorical field with 2 values (Confirmed/Likely), used for filtering"}, {"column": "Single cluster?", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag with single value 'true', used for filtering"}, {"column": "Max OP/s (log)", "role": "measure", "confidence": 1.0, "reason": "Numeric log-scale performance metric, 239 distinct values, aggregatable"}, {"column": "H100 equivalents", "role": "measure", "confidence": 1.0, "reason": "Numeric comparison metric, 240 distinct values, aggregatable"}, {"column": "Chip type (primary)", "role": "dimension", "confidence": 1.0, "reason": "Categorical hardware type, 36 distinct values, used for grouping"}, {"column": "Chip quantity (primary)", "role": "measure", "confidence": 1.0, "reason": "Numeric quantity to aggregate, 172 distinct values"}, {"column": "Country", "role": "dimension", "confidence": 1.0, "reason": "Geographic category, 37 distinct values, used for grouping/filtering"}, {"column": "Owner", "role": "dimension", "confidence": 1.0, "reason": "Categorical owner field, 131 distinct values, used for grouping"}, {"column": "First Operational Date", "role": "dimension", "confidence": 1.0, "reason": "Date field for temporal grouping/filtering, 219 distinct values"}, {"column": "Note", "role": "attribute", "confidence": 1.0, "reason": "Free-form descriptive text, 83 distinct values, for display only"}, {"column": "Sector", "role": "dimension", "confidence": 1.0, "reason": "Categorical field with 4 values (Private/Public/etc), used for grouping"}, {"column": "Power Capacity (MW)", "role": "measure", "confidence": 1.0, "reason": "Numeric power measurement, 258 distinct values, aggregatable"}, {"column": "Hardware Cost", "role": "measure", "confidence": 1.0, "reason": "Numeric cost amount, 264 distinct values, aggregatable"}, {"column": "Location", "role": "attribute", "confidence": 1.0, "reason": "Free-form address text, 149 distinct values, for display"}, {"column": "Users", "role": "attribute", "confidence": 0.9, "reason": "Comma-separated descriptive text, 109 distinct values, for display"}, {"column": "Hardware note", "role": "attribute", "confidence": 1.0, "reason": "Free-form hardware description, 40 distinct values, for display"}, {"column": "Quote", "role": "attribute", "confidence": 1.0, "reason": "Free-form quoted text, 199 distinct values, for display"}, {"column": "First Operational Date Note", "role": "attribute", "confidence": 1.0, "reason": "Free-form date notes, 184 distinct values, for display"}, {"column": "Certainty Note", "role": "attribute", "confidence": 1.0, "reason": "Free-form certainty explanation, 43 distinct values, for display"}, {"column": "Energy Efficiency (log)", "role": "measure", "confidence": 1.0, "reason": "Numeric log-scale efficiency metric, 138 distinct values, aggregatable"}, {"column": "Builds Upon", "role": "dimension", "confidence": 0.9, "reason": "Categorical reference to predecessor system, 30 distinct values, used for filtering"}, {"column": "Superseded by", "role": "dimension", "confidence": 0.9, "reason": "Categorical reference to successor system, 30 distinct values, used for filtering"}, {"column": "Possible Duplicate", "role": "dimension", "confidence": 1.0, "reason": "Single empty value, flag field for filtering"}, {"column": "Possible Duplicate Of", "role": "dimension", "confidence": 1.0, "reason": "Single empty value, flag field for filtering"}, {"column": "Chip type (secondary)", "role": "dimension", "confidence": 1.0, "reason": "Categorical hardware type, 11 distinct values, used for grouping"}, {"column": "Chip quantity (secondary)", "role": "measure", "confidence": 1.0, "reason": "Numeric quantity, 18 distinct values, aggregatable"}, {"column": "Total number of AI chips", "role": "measure", "confidence": 1.0, "reason": "Numeric total count, 179 distinct values, aggregatable"}, {"column": "GPU Supplier (primary)", "role": "dimension", "confidence": 1.0, "reason": "Categorical supplier, 10 distinct values, used for grouping"}, {"column": "GPU supplier (secondary)", "role": "dimension", "confidence": 1.0, "reason": "Categorical supplier, 4 distinct values, used for grouping"}, {"column": "Include in Standard Analysis", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag with single value 'true', used for filtering"}, {"column": "Exclude", "role": "dimension", "confidence": 1.0, "reason": "Single empty value, flag field for filtering"}, {"column": "Rank when first operational", "role": "measure", "confidence": 0.9, "reason": "Numeric rank value, 128 distinct values, can be aggregated (avg rank)"}, {"column": "16-bit OP/s (log)", "role": "measure", "confidence": 1.0, "reason": "Numeric log-scale performance metric, 237 distinct values, aggregatable"}, {"column": "Max OP/s", "role": "measure", "confidence": 1.0, "reason": "Numeric performance metric, 241 distinct values, aggregatable"}, {"column": "8-bit OP/s", "role": "measure", "confidence": 1.0, "reason": "Numeric performance metric, 163 distinct values, aggregatable"}, {"column": "16-bit OP/s", "role": "measure", "confidence": 1.0, "reason": "Numeric performance metric, 239 distinct values, aggregatable"}, {"column": "32-bit OP/s", "role": "measure", "confidence": 1.0, "reason": "Numeric performance metric, 227 distinct values, aggregatable"}, {"column": "Calculated Power Capacity (MW)", "role": "measure", "confidence": 1.0, "reason": "Numeric calculated power, 248 distinct values, aggregatable"}, {"column": "Reported Power Capacity (MW)", "role": "measure", "confidence": 1.0, "reason": "Numeric reported power, 76 distinct values, aggregatable"}, {"column": "Energy Efficiency", "role": "measure", "confidence": 1.0, "reason": "Numeric efficiency metric, 154 distinct values, aggregatable"}, {"column": "Calculated Cost", "role": "measure", "confidence": 1.0, "reason": "Numeric calculated cost, 264 distinct values, aggregatable"}, {"column": "Reported Cost", "role": "measure", "confidence": 1.0, "reason": "Numeric reported cost, 26 distinct values, aggregatable"}, {"column": "Reported Cost (Inflation adjusted)", "role": "measure", "confidence": 1.0, "reason": "Numeric adjusted cost, 28 distinct values, aggregatable"}, {"column": "Cost Quote", "role": "attribute", "confidence": 1.0, "reason": "Free-form cost description, 28 distinct values, for display"}, {"column": "Noteworthy", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag with single value 'true', used for filtering"}, {"column": "Decommissioned Date (if applicable)", "role": "dimension", "confidence": 1.0, "reason": "Single empty value, date field for filtering"}, {"column": "Largest existing cluster when first operational", "role": "dimension", "confidence": 0.9, "reason": "Categorical reference system, 17 distinct values, used for filtering"}, {"column": "% of largest cluster when first operational", "role": "measure", "confidence": 1.0, "reason": "Numeric percentage ratio, 235 distinct values, aggregatable"}, {"column": "Source 1", "role": "attribute", "confidence": 1.0, "reason": "URL reference, 253 distinct values, for display"}, {"column": "Source 2", "role": "attribute", "confidence": 1.0, "reason": "URL reference, 99 distinct values, for display"}, {"column": "Source 3", "role": "attribute", "confidence": 1.0, "reason": "URL reference, 40 distinct values, for display"}, {"column": "Source 4", "role": "attribute", "confidence": 1.0, "reason": "URL reference, 12 distinct values, for display"}, {"column": "Source 5", "role": "attribute", "confidence": 1.0, "reason": "URL reference, 4 distinct values, for display"}, {"column": "latitude", "role": "dimension", "confidence": 1.0, "reason": "Geographic coordinate, 144 distinct values, used for spatial grouping/filtering"}, {"column": "longitude", "role": "dimension", "confidence": 1.0, "reason": "Geographic coordinate, 144 distinct values, used for spatial grouping/filtering"} ] } ```