stores
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
6 rows where delivery_status = 0, monp_status = 0 and open_now = 1
This data as json, CSV (advanced)
Suggested facets: postal_code, amenities
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12 | 13391 | 391 | N1 | Airport Terminal 1 Transit | Departure / Transit Lounge East #02-66, Terminal 1 Singapore Changi Airport, Singapore | 819642 | 6910 1161 | 103.990037 | 1.362182 | 0 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":false,"MobileOrderandPay":false,"NitroColdBrew":true,"StarbucksReserve":false} |
| 42 | 13549 | 549 | T3D | Airport Terminal 3 Departure Hall | 65 Airport Boulevard #02-90, Departure Hall Level 2 Singapore Changi Airport, Singapore | 819643 | 6910 6131 | 103.98717745214255 | 1.3572645201006115 | 0 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":false,"MobileOrderandPay":false,"NitroColdBrew":true,"StarbucksReserve":false} |
| 43 | 13551 | 551 | T4D | Airport Terminal 4 | 10 Airport Boulevard Departure / Check-in Hall #02-04, Terminal 4 Singapore Changi Airport, Singapore | 819665 | 6910 6921 | 103.98382538952447 | 1.3386065315442497 | 0 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":false,"MobileOrderandPay":false,"NitroColdBrew":true,"StarbucksReserve":false} |
| 49 | 13534 | 534 | TN2 | Airport Terminal 2 Transit Hall | Departure / Transit Lounge North Level 2, Unit No. 02-158, Terminal 2 Singapore Changi Airport, Singapore | 819643 | 6910 0960 | 103.994549 | 1.360878 | 0 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":false,"MobileOrderandPay":false,"NitroColdBrew":false,"StarbucksReserve":false} |
| 69 | 13567 | 567 | JW2 | Jewel Changi Airport | 78 Airport Boulevard #02-204, Jewel Changi Airport, Singapore | 819666 | 6910 1135 | 103.990252 | 1.360062 | 0 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":false,"MobileOrderandPay":false,"NitroColdBrew":true,"StarbucksReserve":true} |
| 82 | 13593 | 593 | NA2 | Airport Terminal 2 Departure Hall | 60 Airport Boulevard #02-33, Departure Hall Terminal 2 Singapore Changi Airport, Singapore | 819643 | 6910 1231 | 103.988016316617 | 1.35421204598623 | 0 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"00:00:00","OpenTo":"23:59:00","Is24Hours":true,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":false,"MobileOrderandPay":false,"NitroColdBrew":false,"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");