stores
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
1 row where delivery_status = 1 and open_now = 0
This data as json, CSV (advanced)
| id ▼ | branch_code | outlet_code | store_code | store_name | address | postal_code | phone_no | longitude | latitude | monp_status | delivery_status | open_now | service_hours | amenities |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 150 | 13608 | 608 | FRT | Frasers Tower | 182 Cecil Street #01-05/08, Frasers Tower, Singapore | 069547 | 6041 2695 | 103.84691740793842 | 1.2801037730240543 | 1 | 1 | 0 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"07:00","OpenTo":"21:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"07:00","OpenTo":"21:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"07:00","OpenTo":"21:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"07:00","OpenTo":"21:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"07:00","OpenTo":"21:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"08:00","OpenTo":"16:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"","OpenTo":"","Is24Hours":false,"IsClosed":true},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"","OpenTo":"","Is24Hours":false,"IsClosed":true},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"07:00","OpenTo":"21:00","Is24Hours":false,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"NitroColdBrew":true,"StarbucksReserve":false} |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "stores" ("id" INTEGER NOT NULL PRIMARY KEY, "branch_code" VARCHAR(255) NOT NULL, "outlet_code" VARCHAR(255) NOT NULL, "store_code" VARCHAR(255) NOT NULL, "store_name" VARCHAR(255) NOT NULL, "address" VARCHAR(255) NOT NULL, "postal_code" VARCHAR(255) NOT NULL, "phone_no" VARCHAR(255) NOT NULL, "longitude" REAL NOT NULL, "latitude" REAL NOT NULL, "monp_status" INTEGER NOT NULL, "delivery_status" INTEGER NOT NULL, "open_now" INTEGER NOT NULL, "service_hours" JSON NOT NULL, "amenities" JSON NOT NULL);
CREATE UNIQUE INDEX "store_branch_code" ON "stores" ("branch_code");
CREATE INDEX "store_longitude_latitude" ON "stores" ("longitude", "latitude");