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

Orders

@kaggle.anas123siddiqui_zomato_database.orders

3 MB
150281 rows
7 columns

unnamed_0 Unnamed: 0	order_date Order Date	sales_qty Sales Qty	sales_amount Sales Amount	currency Currency	user_id User Id	r_id R Id
	Tue Oct 10 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	100	41241	INR	49226	567335
1	Tue May 08 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3	-1	INR	77359	531342
2	Fri Apr 06 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	875	INR	5321	158203
3	Wed Apr 11 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	583	INR	21343	187912
4	Mon Jun 18 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	6	7176	INR	75378	543530
5	Mon Nov 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	59	500	USD	34323	158204
6	Wed Nov 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	36	250	USD	33246	156588
7	Thu Nov 23 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	39	21412	INR	87420	244866
8	Mon Nov 27 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	35	19213	INR	31017	156602
9	Tue Nov 28 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	310	170185	INR	72391	158193


CREATE TABLE orders (
  "unnamed_0" BIGINT,
  "order_date" TIMESTAMP,
  "sales_qty" BIGINT,
  "sales_amount" BIGINT,
  "currency" VARCHAR,
  "user_id" BIGINT,
  "r_id" DOUBLE
);