stores
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
23 rows where delivery_status = 0 and open_now = 1
This data as json, CSV (advanced)
Suggested facets: postal_code, service_hours, 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} |
| 24 | 13360 | 360 | OF | One Fullerton | 1 Fullerton Road #01-04, One Fullerton, Singapore 0 | 49213 | 6910 1193 | 103.85383566289575 | 1.2857998525962435 | 1 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"07:30:00","OpenTo":"22:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"07:30:00","OpenTo":"22:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"07:30:00","OpenTo":"22:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"07:30:00","OpenTo":"22:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"07:30:00","OpenTo":"22:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"07:00:00","OpenTo":"22:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"07:00:00","OpenTo":"22:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"07:30:00","OpenTo":"22:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"07:30:00","OpenTo":"22:30:00","Is24Hours":false,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"NitroColdBrew":true,"StarbucksReserve":false} |
| 26 | 13506 | 506 | ORG | Orchard Gateway | 277 Orchard Road #B2-04, Orchard Gateway, Singapore | 238858 | 6910 0939 | 103.83903803561407 | 1.300599587933889 | 1 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"08:00:00","OpenTo":"22:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"08:00:00","OpenTo":"22:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"08:00:00","OpenTo":"22:30:00","Is24Hours":false,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"NitroColdBrew":false,"StarbucksReserve":false} |
| 27 | 13337 | 337 | PG | Paragon | 290 Orchard Road #B1-34, Paragon Shopping Centre, Singapore | 238859 | 6910 1163 | 103.83562282328074 | 1.3034968684935992 | 1 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"NitroColdBrew":false,"StarbucksReserve":false} |
| 31 | 13427 | 427 | RW | Resorts World Sentosa | 28 Sentosa Gateway #01-202, Singapore 0 | 98138 | 6910 1223 | 103.81995055921236 | 1.2563162987945744 | 1 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"07:30:00","OpenTo":"23:00:00","Is24Hours":false,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"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} |
| 58 | 13581 | 581 | VC3 | VivoCity | 1 Harbourfront Walk #01-43, Vivocity, Singapore 0 | 98585 | 6974 7311 | 103.82291216151958 | 1.264179213584204 | 1 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"08:00:00","OpenTo":"22:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"08:00:00","OpenTo":"22:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"08:00:00","OpenTo":"22:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"08:00:00","OpenTo":"22:30:00","Is24Hours":false,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"NitroColdBrew":true,"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} |
| 72 | 13598 | 598 | RH2 | Raffles Hospital | 585 North Bridge Road #01-03, Raffles Hospital, Singapore | 188770 | 6910 1189 | 103.85709769168228 | 1.3014324906162043 | 1 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"07:30:00","OpenTo":"20:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"07:30:00","OpenTo":"20:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"07:30:00","OpenTo":"20:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"07:30:00","OpenTo":"20:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"07:30:00","OpenTo":"20:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"08:00:00","OpenTo":"20:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"08:00:00","OpenTo":"20:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"08:00:00","OpenTo":"20:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"08:00:00","OpenTo":"20:00:00","Is24Hours":false,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"NitroColdBrew":false,"StarbucksReserve":false} |
| 73 | 13599 | 599 | SA2 | Starbucks Sentosa Sensoryscape | 3 Siloso Road #01-03/04 Singapore 0 | 98977 | 69741330 | 103.81920467498594 | 1.2543227232260383 | 1 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"08:00:00","OpenTo":"21:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"08:00:00","OpenTo":"21:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"08:00:00","OpenTo":"21:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"08:00:00","OpenTo":"21:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"08:00:00","OpenTo":"21:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"08:00:00","OpenTo":"21:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"NitroColdBrew":false,"StarbucksReserve":false} |
| 78 | 13589 | 589 | LZD | Lazada One | 51 Bras Basah Road #01-06, Lazada One, Singapore | 189554 | 6910 1181 | 103.85005736252644 | 1.2977677225309534 | 1 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"07:30:00","OpenTo":"21:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"07:30:00","OpenTo":"21:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"07:30:00","OpenTo":"21:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"07:30:00","OpenTo":"21:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"07:30:00","OpenTo":"21:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"NitroColdBrew":false,"StarbucksReserve":false} |
| 79 | 13590 | 590 | TAK | Takashimaya | 391A Orchard Road #B1-01, Takashimaya Shopping Centre, Singapore | 238873 | 6910 0971 | 103.83470946148468 | 1.3024522449933018 | 1 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"08:00:00","OpenTo":"21:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"08:00:00","OpenTo":"21:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"08:00:00","OpenTo":"21:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"08:00:00","OpenTo":"21:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"08:00:00","OpenTo":"21:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"08:00:00","OpenTo":"21:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"08:00:00","OpenTo":"21:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"08:00:00","OpenTo":"21:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"08:00:00","OpenTo":"21:30:00","Is24Hours":false,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"NitroColdBrew":true,"StarbucksReserve":false} |
| 80 | 13602 | 602 | ACG | Active Garden | 18 Marina Gardens Drive, #01-01, Singapore | 018953 | 6910 1311 | 103.86217820692866 | 1.285597976695167 | 1 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"NitroColdBrew":false,"StarbucksReserve":false} |
| 81 | 13591 | 591 | GEH | Gleneagles Hospital | 6A Napier Road #02-27/30, Gleneagles Hospital, Singapore | 258500 | 6910 1241 | 103.82024999979852 | 1.3075061943712722 | 1 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"07:00:00","OpenTo":"21:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"07:00:00","OpenTo":"21:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"07:00:00","OpenTo":"21:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"07:00:00","OpenTo":"21:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"07:00:00","OpenTo":"21:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"07:30:00","OpenTo":"19:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"07:30:00","OpenTo":"19:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"07:30:00","OpenTo":"19:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"07:00:00","OpenTo":"21:00:00","Is24Hours":false,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"NitroColdBrew":false,"StarbucksReserve":false} |
| 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} |
| 85 | 13596 | 596 | BRP | Bird Paradise | 20 Mandai Lake Road #02-05, Singapore | 729825 | 6025 1675 | 103.7832165441795 | 1.4070052772406347 | 1 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"08:00:00","OpenTo":"18:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"08:00:00","OpenTo":"18:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"08:00:00","OpenTo":"18:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"08:00:00","OpenTo":"18:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"08:00:00","OpenTo":"18:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"08:00:00","OpenTo":"19:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"08:00:00","OpenTo":"19:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"08:00:00","OpenTo":"19:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"08:00:00","OpenTo":"19:00:00","Is24Hours":false,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"NitroColdBrew":true,"StarbucksReserve":false} |
| 111 | 13385 | 385 | CL | CityLink Mall | One Raffles Link #B1-15/17, Citylink Mall, Singapore 0 | 39393 | 6910 1299 | 103.8557999814162 | 1.2920292851775692 | 1 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"08:00:00","OpenTo":"18:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"08:00:00","OpenTo":"18:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"08:00:00","OpenTo":"18:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"08:00:00","OpenTo":"18:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"08:00:00","OpenTo":"18:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"10:00:00","OpenTo":"19:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"10:00:00","OpenTo":"18:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"10:00:00","OpenTo":"18:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"10:00:00","OpenTo":"18:00:00","Is24Hours":false,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"NitroColdBrew":false,"StarbucksReserve":false} |
| 115 | 13338 | 338 | CS | Concourse | 300 Beach Road 1st Storey Lobby, The Concourse, Singapore | 199555 | 6910 1125 | 103.86261130157742 | 1.3011253541619427 | 1 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"07:30:00","OpenTo":"19:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"07:30:00","OpenTo":"19:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"07:30:00","OpenTo":"19:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"07:30:00","OpenTo":"19:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"07:30:00","OpenTo":"19:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"08:00:00","OpenTo":"13:00: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":"","OpenTo":"","Is24Hours":false,"IsClosed":true}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"NitroColdBrew":false,"StarbucksReserve":false} |
| 119 | 13381 | 381 | CU | City House | 36 Robinson Road #01-02, City House, Singapore 0 | 68877 | 6910 1187 | 103.84962759420686 | 1.2815510237690966 | 1 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"07:30:00","OpenTo":"20:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"07:30:00","OpenTo":"20:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"07:30:00","OpenTo":"20:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"07:30:00","OpenTo":"20:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"07:30:00","OpenTo":"20:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"08:00:00","OpenTo":"15:00: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:30:00","OpenTo":"20:00:00","Is24Hours":false,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"NitroColdBrew":false,"StarbucksReserve":false} |
| 127 | 13585 | 585 | GBB | Gardens by the Bay | 18 Marina Gardens Drive #02-03, Gardens by the Bay, Singapore 0 | 18953 | 6993 3677 | 103.86542571226353 | 1.282403798393352 | 1 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"08:00:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"08:00:00","OpenTo":"23:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"07:30:00","OpenTo":"23:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"07:30:00","OpenTo":"22:00:00","Is24Hours":false,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"NitroColdBrew":false,"StarbucksReserve":false} |
| 148 | 13544 | 544 | MBS | Marina Bay Sands | 2 Bayfront Avenue #B2-56, The Shoppes at Marina Bay Sands, Singapore 0 | 18972 | 6910 1323 | 103.8600215664893 | 1.2858193235938349 | 1 | 0 | 1 | [{"DayOfWeek":1,"DayOfWeekString":"MONDAY","OpenFrom":"08:00:00","OpenTo":"23:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":2,"DayOfWeekString":"TUESDAY","OpenFrom":"08:00:00","OpenTo":"23:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":3,"DayOfWeekString":"WEDNESDAY","OpenFrom":"08:00:00","OpenTo":"23:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":4,"DayOfWeekString":"THURSDAY","OpenFrom":"08:00:00","OpenTo":"23:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":5,"DayOfWeekString":"FRIDAY","OpenFrom":"08:00:00","OpenTo":"23:59:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":6,"DayOfWeekString":"SATURDAY","OpenFrom":"08:00:00","OpenTo":"23:59:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":7,"DayOfWeekString":"SUNDAY","OpenFrom":"08:00:00","OpenTo":"23:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":8,"DayOfWeekString":"PUBLIC_HOLIDAY","OpenFrom":"08:00:00","OpenTo":"23:30:00","Is24Hours":false,"IsClosed":false},{"DayOfWeek":9,"DayOfWeekString":"EVE_OF_PUBLIC_HOLIDAY","OpenFrom":"08:00:00","OpenTo":"23:59:00","Is24Hours":false,"IsClosed":false}] | {"24Hours":false,"Cashless":false,"FreeWifi":true,"MobileOrderandPay":true,"NitroColdBrew":true,"StarbucksReserve":true} |
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");