item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
572 rows where effective_date = "2024-10-06"
This data as json, CSV (advanced)
Suggested facets: base_price, delivery_price, effective_date (date)
store_id >30
effective_date 1
- 2024-10-06 · 572 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 31255 | Milano Luna 30687 | 22 22 | 1690 | 1740 | 2024-10-06 |
| 31256 | Milano Sole 30688 | 22 22 | 1690 | 1740 | 2024-10-06 |
| 31257 | Gourmet Mushroom Veggie Puff 30689 | 22 22 | 580 | 630 | 2024-10-06 |
| 31258 | K-inspired Gochujang Chicken Pie 30690 | 22 22 | 780 | 830 | 2024-10-06 |
| 31259 | Milano Luna 30691 | 23 23 | 1690 | 1740 | 2024-10-06 |
| 31260 | Milano Sole 30692 | 23 23 | 1690 | 1740 | 2024-10-06 |
| 31261 | Gourmet Mushroom Veggie Puff 30693 | 23 23 | 580 | 630 | 2024-10-06 |
| 31262 | K-inspired Gochujang Chicken Pie 30694 | 23 23 | 780 | 830 | 2024-10-06 |
| 31263 | Milano Luna 30695 | 21 21 | 1690 | 1740 | 2024-10-06 |
| 31264 | Milano Sole 30696 | 21 21 | 1690 | 1740 | 2024-10-06 |
| 31265 | Gourmet Mushroom Veggie Puff 30697 | 21 21 | 580 | 630 | 2024-10-06 |
| 31266 | K-inspired Gochujang Chicken Pie 30698 | 21 21 | 780 | 830 | 2024-10-06 |
| 31267 | Milano Luna 30699 | 20 20 | 1690 | 1740 | 2024-10-06 |
| 31268 | Milano Sole 30700 | 20 20 | 1690 | 1740 | 2024-10-06 |
| 31269 | Gourmet Mushroom Veggie Puff 30701 | 20 20 | 520 | 570 | 2024-10-06 |
| 31270 | K-inspired Gochujang Chicken Pie 30702 | 20 20 | 700 | 750 | 2024-10-06 |
| 31271 | Milano Luna 30703 | 19 19 | 1690 | 1740 | 2024-10-06 |
| 31272 | Milano Sole 30704 | 19 19 | 1690 | 1740 | 2024-10-06 |
| 31273 | Gourmet Mushroom Veggie Puff 30705 | 19 19 | 580 | 630 | 2024-10-06 |
| 31274 | K-inspired Gochujang Chicken Pie 30706 | 19 19 | 780 | 830 | 2024-10-06 |
| 31275 | Milano Luna 30707 | 17 17 | 1690 | 1740 | 2024-10-06 |
| 31276 | Milano Sole 30708 | 17 17 | 1690 | 1740 | 2024-10-06 |
| 31277 | Gourmet Mushroom Veggie Puff 30709 | 17 17 | 580 | 630 | 2024-10-06 |
| 31278 | K-inspired Gochujang Chicken Pie 30710 | 17 17 | 780 | 830 | 2024-10-06 |
| 31279 | Milano Luna 30711 | 18 18 | 1690 | 1740 | 2024-10-06 |
| 31280 | Milano Sole 30712 | 18 18 | 1690 | 1740 | 2024-10-06 |
| 31281 | Gourmet Mushroom Veggie Puff 30713 | 18 18 | 580 | 630 | 2024-10-06 |
| 31282 | K-inspired Gochujang Chicken Pie 30714 | 18 18 | 780 | 830 | 2024-10-06 |
| 31283 | Milano Luna 30715 | 16 16 | 1690 | 1740 | 2024-10-06 |
| 31284 | Milano Sole 30716 | 16 16 | 1690 | 1740 | 2024-10-06 |
| 31285 | Gourmet Mushroom Veggie Puff 30717 | 16 16 | 580 | 630 | 2024-10-06 |
| 31286 | K-inspired Gochujang Chicken Pie 30718 | 16 16 | 780 | 830 | 2024-10-06 |
| 31287 | Milano Luna 30719 | 14 14 | 1690 | 1740 | 2024-10-06 |
| 31288 | Milano Sole 30720 | 14 14 | 1690 | 1740 | 2024-10-06 |
| 31289 | Gourmet Mushroom Veggie Puff 30721 | 14 14 | 580 | 630 | 2024-10-06 |
| 31290 | K-inspired Gochujang Chicken Pie 30722 | 14 14 | 780 | 830 | 2024-10-06 |
| 31291 | Milano Luna 30723 | 15 15 | 1690 | 1740 | 2024-10-06 |
| 31292 | Milano Sole 30724 | 15 15 | 1690 | 1740 | 2024-10-06 |
| 31293 | Gourmet Mushroom Veggie Puff 30725 | 15 15 | 520 | 570 | 2024-10-06 |
| 31294 | K-inspired Gochujang Chicken Pie 30726 | 15 15 | 700 | 750 | 2024-10-06 |
| 31295 | Milano Luna 30727 | 11 11 | 1690 | 1740 | 2024-10-06 |
| 31296 | Milano Sole 30728 | 11 11 | 1690 | 1740 | 2024-10-06 |
| 31297 | Gourmet Mushroom Veggie Puff 30729 | 11 11 | 580 | 630 | 2024-10-06 |
| 31298 | K-inspired Gochujang Chicken Pie 30730 | 11 11 | 780 | 830 | 2024-10-06 |
| 31299 | Milano Luna 30731 | 10 10 | 1690 | 1740 | 2024-10-06 |
| 31300 | Milano Sole 30732 | 10 10 | 1690 | 1740 | 2024-10-06 |
| 31301 | Gourmet Mushroom Veggie Puff 30733 | 10 10 | 580 | 630 | 2024-10-06 |
| 31302 | K-inspired Gochujang Chicken Pie 30734 | 10 10 | 780 | 830 | 2024-10-06 |
| 31303 | Milano Luna 30735 | 8 8 | 1690 | 1740 | 2024-10-06 |
| 31304 | Milano Sole 30736 | 8 8 | 1690 | 1740 | 2024-10-06 |
| 31305 | Gourmet Mushroom Veggie Puff 30737 | 8 8 | 580 | 630 | 2024-10-06 |
| 31306 | K-inspired Gochujang Chicken Pie 30738 | 8 8 | 780 | 830 | 2024-10-06 |
| 31307 | Milano Luna 30739 | 148 148 | 1690 | 1740 | 2024-10-06 |
| 31308 | Milano Sole 30740 | 148 148 | 1690 | 1740 | 2024-10-06 |
| 31309 | Gourmet Mushroom Veggie Puff 30741 | 148 148 | 610 | 660 | 2024-10-06 |
| 31310 | K-inspired Gochujang Chicken Pie 30742 | 148 148 | 810 | 860 | 2024-10-06 |
| 31311 | Milano Luna 30743 | 147 147 | 1690 | 1740 | 2024-10-06 |
| 31312 | Milano Sole 30744 | 147 147 | 1690 | 1740 | 2024-10-06 |
| 31313 | Gourmet Mushroom Veggie Puff 30745 | 147 147 | 580 | 630 | 2024-10-06 |
| 31314 | K-inspired Gochujang Chicken Pie 30746 | 147 147 | 780 | 830 | 2024-10-06 |
| 31315 | Milano Luna 30747 | 9 9 | 1690 | 1740 | 2024-10-06 |
| 31316 | Milano Sole 30748 | 9 9 | 1690 | 1740 | 2024-10-06 |
| 31317 | Gourmet Mushroom Veggie Puff 30749 | 9 9 | 580 | 630 | 2024-10-06 |
| 31318 | K-inspired Gochujang Chicken Pie 30750 | 9 9 | 780 | 830 | 2024-10-06 |
| 31319 | Milano Luna 30751 | 145 145 | 1690 | 1740 | 2024-10-06 |
| 31320 | Milano Sole 30752 | 145 145 | 1690 | 1740 | 2024-10-06 |
| 31321 | Gourmet Mushroom Veggie Puff 30753 | 145 145 | 580 | 630 | 2024-10-06 |
| 31322 | K-inspired Gochujang Chicken Pie 30754 | 145 145 | 780 | 830 | 2024-10-06 |
| 31323 | Milano Luna 30755 | 144 144 | 1690 | 1740 | 2024-10-06 |
| 31324 | Milano Sole 30756 | 144 144 | 1690 | 1740 | 2024-10-06 |
| 31325 | Gourmet Mushroom Veggie Puff 30757 | 144 144 | 580 | 630 | 2024-10-06 |
| 31326 | K-inspired Gochujang Chicken Pie 30758 | 144 144 | 780 | 830 | 2024-10-06 |
| 31327 | Milano Luna 30759 | 143 143 | 1690 | 1740 | 2024-10-06 |
| 31328 | Milano Sole 30760 | 143 143 | 1690 | 1740 | 2024-10-06 |
| 31329 | Gourmet Mushroom Veggie Puff 30761 | 143 143 | 580 | 630 | 2024-10-06 |
| 31330 | K-inspired Gochujang Chicken Pie 30762 | 143 143 | 780 | 830 | 2024-10-06 |
| 31331 | Milano Luna 30763 | 142 142 | 1690 | 1740 | 2024-10-06 |
| 31332 | Milano Sole 30764 | 142 142 | 1690 | 1740 | 2024-10-06 |
| 31333 | Gourmet Mushroom Veggie Puff 30765 | 142 142 | 580 | 630 | 2024-10-06 |
| 31334 | K-inspired Gochujang Chicken Pie 30766 | 142 142 | 780 | 830 | 2024-10-06 |
| 31335 | Milano Luna 30767 | 146 146 | 1690 | 1740 | 2024-10-06 |
| 31336 | Milano Sole 30768 | 146 146 | 1690 | 1740 | 2024-10-06 |
| 31337 | Gourmet Mushroom Veggie Puff 30769 | 146 146 | 580 | 630 | 2024-10-06 |
| 31338 | K-inspired Gochujang Chicken Pie 30770 | 146 146 | 780 | 830 | 2024-10-06 |
| 31339 | Milano Luna 30771 | 141 141 | 1690 | 1740 | 2024-10-06 |
| 31340 | Milano Sole 30772 | 141 141 | 1690 | 1740 | 2024-10-06 |
| 31341 | Gourmet Mushroom Veggie Puff 30773 | 141 141 | 580 | 630 | 2024-10-06 |
| 31342 | K-inspired Gochujang Chicken Pie 30774 | 141 141 | 780 | 830 | 2024-10-06 |
| 31343 | Milano Luna 30775 | 140 140 | 1690 | 1740 | 2024-10-06 |
| 31344 | Milano Sole 30776 | 140 140 | 1690 | 1740 | 2024-10-06 |
| 31345 | Gourmet Mushroom Veggie Puff 30777 | 140 140 | 580 | 630 | 2024-10-06 |
| 31346 | K-inspired Gochujang Chicken Pie 30778 | 140 140 | 780 | 830 | 2024-10-06 |
| 31347 | Milano Luna 30779 | 139 139 | 1690 | 1740 | 2024-10-06 |
| 31348 | Milano Sole 30780 | 139 139 | 1690 | 1740 | 2024-10-06 |
| 31349 | Gourmet Mushroom Veggie Puff 30781 | 139 139 | 580 | 630 | 2024-10-06 |
| 31350 | K-inspired Gochujang Chicken Pie 30782 | 139 139 | 780 | 830 | 2024-10-06 |
| 31351 | Milano Luna 30783 | 138 138 | 1690 | 1740 | 2024-10-06 |
| 31352 | Milano Sole 30784 | 138 138 | 1690 | 1740 | 2024-10-06 |
| 31353 | Gourmet Mushroom Veggie Puff 30785 | 138 138 | 580 | 630 | 2024-10-06 |
| 31354 | K-inspired Gochujang Chicken Pie 30786 | 138 138 | 780 | 830 | 2024-10-06 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "item_prices" ("id" INTEGER NOT NULL PRIMARY KEY, "item_id" INTEGER NOT NULL, "store_id" INTEGER NOT NULL, "base_price" INTEGER NOT NULL, "delivery_price" INTEGER NOT NULL, "effective_date" DATE NOT NULL, FOREIGN KEY ("item_id") REFERENCES "menu_items" ("id"), FOREIGN KEY ("store_id") REFERENCES "stores" ("id"));
CREATE INDEX "price_item_id" ON "item_prices" ("item_id");
CREATE INDEX "price_store_id" ON "item_prices" ("store_id");
CREATE UNIQUE INDEX "price_item_id_store_id_effective_date" ON "item_prices" ("item_id", "store_id", "effective_date");