```json { "classifications": [ {"column": "place_id", "role": "identifier", "confidence": 1.0, "reason": "Primary key with unique values per row"}, {"column": "name", "role": "attribute", "confidence": 0.95, "reason": "Descriptive place name displayed to users"}, {"column": "name_plain", "role": "attribute", "confidence": 0.95, "reason": "Plain text version of place name for display"}, {"column": "description", "role": "attribute", "confidence": 1.0, "reason": "Long-form descriptive text content"}, {"column": "type_id", "role": "identifier", "confidence": 0.95, "reason": "Foreign key to place type lookup table"}, {"column": "address", "role": "attribute", "confidence": 1.0, "reason": "Free-form address text for display"}, {"column": "city", "role": "dimension", "confidence": 0.9, "reason": "Geographic grouping dimension with medium cardinality"}, {"column": "city_plain", "role": "dimension", "confidence": 0.85, "reason": "Normalized city name for grouping"}, {"column": "state_id", "role": "identifier", "confidence": 0.95, "reason": "Foreign key to state lookup table"}, {"column": "country_id", "role": "identifier", "confidence": 0.95, "reason": "Foreign key to country lookup table"}, {"column": "postal_code", "role": "dimension", "confidence": 0.8, "reason": "Geographic grouping code with high cardinality"}, {"column": "phone", "role": "attribute", "confidence": 1.0, "reason": "Contact information for display"}, {"column": "website", "role": "attribute", "confidence": 1.0, "reason": "URL for display purposes"}, {"column": "facebook", "role": "attribute", "confidence": 1.0, "reason": "Social media handle for display"}, {"column": "twitter", "role": "attribute", "confidence": 1.0, "reason": "Social media handle for display"}, {"column": "rating_text", "role": "dimension", "confidence": 0.9, "reason": "Categorical rating label for grouping"}, {"column": "has_taps", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_bottles", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_wifi", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_togo", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_singles", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_seasonals", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_real_ales", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_rare_beers", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_macros", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_glassware", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_smoking", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_cigars", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "allows_children", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "takes_reservations", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_patio", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_tv", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_games", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "scene", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text about atmosphere"}, {"column": "staff", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text about staff"}, {"column": "parking", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text about parking"}, {"column": "music", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text about music"}, {"column": "events", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text about events"}, {"column": "noise", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text about noise level"}, {"column": "seating", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text about seating"}, {"column": "has_food", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering (single value but still a flag)"}, {"column": "food_details", "role": "attribute", "confidence": 1.0, "reason": "Descriptive text about food offerings"}, {"column": "comments", "role": "attribute", "confidence": 1.0, "reason": "Free-form comment text"}, {"column": "hours", "role": "attribute", "confidence": 1.0, "reason": "Operating hours text for display"}, {"column": "created_by", "role": "identifier", "confidence": 0.95, "reason": "Foreign key to user who created record"}, {"column": "updated_by", "role": "identifier", "confidence": 0.95, "reason": "Foreign key to user who updated record"}, {"column": "created_at", "role": "dimension", "confidence": 0.95, "reason": "Timestamp for temporal grouping and filtering"}, {"column": "phone_area_code", "role": "dimension", "confidence": 0.85, "reason": "Geographic code for grouping"}, {"column": "has_mail_order", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_intl_shipping", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "avg_rating", "role": "measure", "confidence": 1.0, "reason": "Numeric rating to be averaged or aggregated"}, {"column": "weighted_avg", "role": "measure", "confidence": 1.0, "reason": "Calculated average rating for aggregation"}, {"column": "bay_mean", "role": "measure", "confidence": 1.0, "reason": "Bayesian mean rating for aggregation"}, {"column": "percentile", "role": "measure", "confidence": 0.9, "reason": "Numeric percentile value for aggregation"}, {"column": "rating_count", "role": "measure", "confidence": 1.0, "reason": "Count metric to be summed"}, {"column": "valid_rating_count", "role": "measure", "confidence": 1.0, "reason": "Count metric to be summed"}, {"column": "updated_at", "role": "dimension", "confidence": 0.95, "reason": "Timestamp for temporal grouping and filtering"}, {"column": "currency", "role": "dimension", "confidence": 0.9, "reason": "Categorical currency code for grouping"}, {"column": "is_retired", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "is_geo_override", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "latitude", "role": "dimension", "confidence": 1.0, "reason": "Geographic coordinate for spatial filtering"}, {"column": "longitude", "role": "dimension", "confidence": 1.0, "reason": "Geographic coordinate for spatial filtering"}, {"column": "has_food_menu", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_beer_menu", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_pic", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering and grouping"}, {"column": "has_flights", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering (single value but still a flag)"}, {"column": "score", "role": "measure", "confidence": 1.0, "reason": "Numeric score to be aggregated"}, {"column": "creator_id", "role": "identifier", "confidence": 0.95, "reason": "Foreign key to creator (single value but still a key)"} ] } ```