Zomato Database

A centralized repository of information for seamless food delivery operations

@kaggle.anas123siddiqui_zomato_database

Table List

5 tables(50.84 MB)

Food

Orders

Restaurant

Users

Restaurant

@kaggle.anas123siddiqui_zomato_database.restaurant

17.48 MB
148541 rows
12 columns

unnamed_0 Unnamed: 0	id Id	name Name	city City	rating Rating	rating_count Rating Count	cost Cost	cuisine Cuisine	lic_no Lic No	link Link	address Address	menu Menu
	567335	AB FOODS POINT	Abohar	--	Too Few Ratings	₹ 200	Beverages,Pizzas	22122652000138	https://www.swiggy.com/restaurants/ab-foods-point-central-abohar-abohar-567335	AB FOODS POINT, NEAR RISHI NARANG DENTAL CLINIC , NEAR IDBI BANK, ABOHAR	Menu/567335.json
1	531342	Janta Sweet House	Abohar	4.4	50+ ratings	₹ 200	Sweets,Bakery	12117201000112	https://www.swiggy.com/restaurants/janta-sweet-house-central-abohar-abohar-531342	Janta Sweet House, Bazar No.9, Circullar Road, Abohar	Menu/531342.json
2	158203	theka coffee desi	Abohar	3.8	100+ ratings	₹ 100	Beverages	22121652000190	https://www.swiggy.com/restaurants/theka-coffee-desi-central-raipura-abohar-158203	theka coffee desi, sahtiya sadan road city	Menu/158203.json
3	187912	Singh Hut	Abohar	3.7	20+ ratings	₹ 250	Fast Food,Indian	22119652000167	https://www.swiggy.com/restaurants/singh-hut-nehru-park-main-bazar-abohar-187912	Singh Hut, CIRCULAR ROAD NEAR NEHRU PARK ABOHAR	Menu/187912.json
4	543530	GRILL MASTERS	Abohar	--	Too Few Ratings	₹ 250	Italian-American,Fast Food	12122201000053	https://www.swiggy.com/restaurants/grill-masters-central-abohar-abohar-543530	GRILL MASTERS, ADA Heights, Abohar - Hanumangarh Rd, Raipura, Abohar, Punjab 152116, India	Menu/543530.json
5	158204	Sam Uncle	Abohar	3.6	20+ ratings	₹ 200	Continental	22119652000052	https://www.swiggy.com/restaurants/sam-uncle-central-main-bazar-abohar-158204	Sam Uncle, hanumangarh road near raja bajaj showroom abohar	Menu/158204.json
6	156588	shere punjab veg	Abohar	4.0	100+ ratings	₹ 150	North Indian	22120652000021	https://www.swiggy.com/restaurants/shere-punjab-veg-central-krishna-nagri-abohar-156588	shere punjab veg, major surinder chowk near verma sons petrol pump and lic building abohar	Menu/156588.json
7	244866	Shri Balaji Vaishno Dhaba	Abohar	--	Too Few Ratings	₹ 100	North Indian	22119652000389	https://www.swiggy.com/restaurants/shri-balaji-vaishno-dhaba-central-main-bazar-abohar-244866	Shri Balaji Vaishno Dhaba, St no 13,6th chowk,main Bazar,near jain bhawan, abohar	Menu/244866.json
8	156602	Hinglaj Kachori Bhandhar	Abohar	4.2	20+ ratings	₹ 100	Snacks,Chaat	22119652000042	https://www.swiggy.com/restaurants/hinglaj-kachori-bhandhar-central-main-bazar-abohar-156602	Hinglaj Kachori Bhandhar, street no 11 circular road ,Abohar	Menu/156602.json
9	158193	yummy hub	Abohar	--	Too Few Ratings	₹ 200	Indian	22119652000045	https://www.swiggy.com/restaurants/yummy-hub-central-abohar-abohar-158193	yummy hub, hanumangarh road near dr naveen sethi hospitalabohar	Menu/158193.json


CREATE TABLE restaurant (
  "unnamed_0" BIGINT,
  "id" BIGINT,
  "name" VARCHAR,
  "city" VARCHAR,
  "rating" VARCHAR,
  "rating_count" VARCHAR,
  "cost" VARCHAR,
  "cuisine" VARCHAR,
  "lic_no" VARCHAR,
  "link" VARCHAR,
  "address" VARCHAR,
  "menu" VARCHAR
);