{
    "action": "final",
    "content": "## Dataset Columns\n\nThe Zomato Restaurant Dataset contains **25 columns** across 9,551 restaurant listings. Here's what each column represents:\n\n### Identifiers\n- **Restaurant ID** (BIGINT): Unique identifier for each restaurant (9,551 distinct values)\n- **Restaurant Name** (VARCHAR): Name of the restaurant (~7,003 distinct names)\n\n### Location Information\n- **Country Code** (BIGINT): Numeric code representing the country (17 countries)\n- **City** (VARCHAR): City where the restaurant is located (147 cities)\n- **Address** (VARCHAR): Full street address (~8,428 unique addresses)\n- **Locality** (VARCHAR): Neighborhood or area name (1,237 localities)\n- **Locality Verbose** (VARCHAR): Detailed locality description (1,042 variations)\n- **Longitude** (DOUBLE): Geographic longitude coordinate\n- **Latitude** (DOUBLE): Geographic latitude coordinate\n\n### Restaurant Characteristics\n- **Cuisines** (VARCHAR): Types of cuisine offered (~1,851 distinct combinations)\n- **Average Cost for two** (BIGINT): Average cost for two people dining (ranges 0-800,000)\n- **Currency** (VARCHAR): Currency used for pricing (11 different currencies)\n- **Price range** (BIGINT): Price category from 1-4 (1=cheapest, 4=most expensive)\n\n### Service Features\n- **Has Table booking** (BOOLEAN): Whether the restaurant accepts table reservations (true/false)\n- **Has Online delivery** (BOOLEAN): Whether online delivery is available (true/false)\n- **Is delivering now** (BOOLEAN): Current delivery status (true/false)\n- **Switch to order menu** (BOOLEAN): Menu ordering toggle (always false in this dataset)\n\n### Ratings & Reviews\n- **Aggregate rating** (DOUBLE): Overall rating score (0.0 to 4.9 scale)\n- **Rating color** (VARCHAR): Color-coded rating category (6 colors: Dark Green, Green, Orange, Red, White, Yellow)\n- **Rating text** (VARCHAR): Text description of rating (6 categories: Excellent, Very Good, Good, Average, Poor, Not rated)\n- **Votes** (BIGINT): Number of user votes/reviews (0 to 10,934)\n\n### System Metadata\n- **_ingestion_timestamp** (TIMESTAMP): When the data was loaded (2026-09-28)\n- **_batch_id** (VARCHAR): Processing batch identifier\n- **_source_file** (VARCHAR): Original CSV file path\n- **_source_system** (VARCHAR): Data source system (\"api\")\n\nThe dataset provides comprehensive information for analyzing restaurant markets across multiple countries, with particular strength in location data, pricing, service features, and customer ratings."
}