Here is the list of columns in the **Zomato Restaurant Dataset**, along with their data types and a description of what each one represents: ### Identifiers & Attributes * **`Restaurant ID`** (BIGINT): A unique identifier assigned to each restaurant. * **`Restaurant Name`** (VARCHAR): The name of the restaurant. * **`Cuisines`** (VARCHAR): A comma-separated list of the types of cuisines offered by the restaurant. ### Location Data * **`Country Code`** (BIGINT): A numerical code representing the country where the restaurant is located. * **`City`** (VARCHAR): The city where the restaurant is located. * **`Address`** (VARCHAR): The full street address of the restaurant. * **`Locality`** (VARCHAR): The specific neighborhood or locality where the restaurant is situated. * **`Locality Verbose`** (VARCHAR): A more detailed description of the locality, typically combining the locality and the city. * **`Longitude`** (DOUBLE): The longitudinal coordinate of the restaurant's location. * **`Latitude`** (DOUBLE): The latitudinal coordinate of the restaurant's location. ### Pricing & Currency * **`Average Cost for two`** (BIGINT): The estimated average cost for two people to dine at the restaurant. * **`Currency`** (VARCHAR): The local currency in which the average cost is measured (e.g., Indian Rupees, Dollars). * **`Price range`** (BIGINT): A categorical value (typically 1 to 4) representing the price bracket of the restaurant, from least to most expensive. ### Services & Features * **`Has Table booking`** (BOOLEAN): Indicates whether the restaurant accepts table reservations (`true` or `false`). * **`Has Online delivery`** (BOOLEAN): Indicates whether the restaurant offers online food delivery (`true` or `false`). * **`Is delivering now`** (BOOLEAN): Indicates whether the restaurant is currently actively delivering orders (`true` or `false`). * **`Switch to order menu`** (BOOLEAN): Indicates if there is an option to switch to an online ordering menu (in this dataset, it appears to be uniformly `false`). ### Ratings & Reviews * **`Aggregate rating`** (DOUBLE): The overall average rating given to the restaurant by users (ranging from 0.0 to 4.9). * **`Rating color`** (VARCHAR): A color code associated with the rating tier (e.g., Dark Green for excellent, Yellow for average). * **`Rating text`** (VARCHAR): A textual description of the rating (e.g., "Excellent", "Very Good", "Average"). * **`Votes`** (BIGINT): The total number of user votes or reviews the restaurant has received. ### System Metadata (Internal) * **`_ingestion_timestamp`** (TIMESTAMP): The exact date and time when this row was loaded into the database. * **`_batch_id`** (VARCHAR): The identifier for the specific data load batch. * **`_source_file`** (VARCHAR): The file path from which the data was ingested. * **`_source_system`** (VARCHAR): The system that provided the data (e.g., `api`).