Baselight

Restaurants & Members & Orders Dataset

Restaurant members and order details

@kaggle.vainero_restaurants_customers_orders_dataset

Monthly Member Totals
@kaggle.vainero_restaurants_customers_orders_dataset.monthly_member_totals

  • 47.02 KB
  • 1200 rows
  • 14 columns
member_id

Member Id

first_name

First Name

surname

Surname

sex

Sex

email

Email

city

City

year

Year

month

Month

order_count

Order Count

meals_count

Meals Count

monthly_budget

Monthly Budget

total_expense

Total Expense

balance

Balance

commission

Commission

47JoyceNewtonFJoyce.Ne@gmail.comHerzelia2020117371836.15500-1336.15136.27949999999998
126MaceyAlmondMMacey.Almond@yahoo.comTel Aviv2020130642676.9800000000011000-1676.980000000001214.98500000000004
68AydinHirstMAydin.Hirst@hotmail.comTel Aviv2020124522286.531000-1286.5299999999995164.93849999999998
193MiraKentMMi.Kent@walla.co.ilTel Aviv2020124542547.62500-2047.62193.59125
53Lilly-AnnFreyFLi.Fr@hotmail.comTel Aviv2020123502456.641000-1456.64193.9765
115RamiSextonMRami.Sexton@hotmail.comRamat Gan2020125622760.2300000000005600-2160.2300000000005211.09775
192AmritHaworthMAm.Ha@hotmail.comGivatayim2020121462044.01999999999951000-1044.0199999999995151.01574999999997
19NicoHastingsMNi.Hastings@walla.co.ilGivatayim2020120361747.42999999999981000-747.4299999999998128.37675
176AmmanZavalaFAm.Zavala@gmail.comGivatayim2020121512225.54600-1625.54159.10449999999997
130HaleemahDavidsonFHaleemah.Da@yahoo.comTel Aviv2020120522503.431000-1503.4299999999998203.56175

CREATE TABLE monthly_member_totals (
  "member_id" BIGINT,
  "first_name" VARCHAR,
  "surname" VARCHAR,
  "sex" VARCHAR,
  "email" VARCHAR,
  "city" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "order_count" BIGINT,
  "meals_count" BIGINT,
  "monthly_budget" DOUBLE,
  "total_expense" DOUBLE,
  "balance" DOUBLE,
  "commission" DOUBLE
);

Share link

Anyone who has the link will be able to view this.