item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
727 rows where effective_date = "2024-07-28"
This data as json, CSV (advanced)
Suggested facets: base_price, delivery_price, effective_date (date)
store_id >30
effective_date 1
- 2024-07-28 · 727 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 28074 | Voyage Blend 27506 | 22 22 | 1690 | 1740 | 2024-07-28 |
| 28075 | Pandan Fantasy 27507 | 22 22 | 850 | 900 | 2024-07-28 |
| 28076 | Iced Pandan Fantasy 27508 | 22 22 | 850 | 900 | 2024-07-28 |
| 28077 | Egg Mayo Sandwich 27509 | 22 22 | 720 | 770 | 2024-07-28 |
| 28078 | Honey Chicken Wholemeal Sandwich 27510 | 22 22 | 720 | 770 | 2024-07-28 |
| 28079 | Voyage Blend 27511 | 21 21 | 1690 | 1740 | 2024-07-28 |
| 28080 | Pandan Fantasy 27512 | 21 21 | 850 | 900 | 2024-07-28 |
| 28081 | Iced Pandan Fantasy 27513 | 21 21 | 850 | 900 | 2024-07-28 |
| 28082 | Egg Mayo Sandwich 27514 | 21 21 | 720 | 770 | 2024-07-28 |
| 28083 | Honey Chicken Wholemeal Sandwich 27515 | 21 21 | 720 | 770 | 2024-07-28 |
| 28084 | Voyage Blend 27516 | 20 20 | 1690 | 1740 | 2024-07-28 |
| 28085 | Pandan Fantasy 27517 | 20 20 | 760 | 810 | 2024-07-28 |
| 28086 | Iced Pandan Fantasy 27518 | 20 20 | 760 | 810 | 2024-07-28 |
| 28087 | Egg Mayo Sandwich 27519 | 20 20 | 640 | 690 | 2024-07-28 |
| 28088 | Honey Chicken Wholemeal Sandwich 27520 | 20 20 | 640 | 690 | 2024-07-28 |
| 28089 | Voyage Blend 27521 | 19 19 | 1690 | 1740 | 2024-07-28 |
| 28090 | Pandan Fantasy 27522 | 19 19 | 850 | 900 | 2024-07-28 |
| 28091 | Iced Pandan Fantasy 27523 | 19 19 | 850 | 900 | 2024-07-28 |
| 28092 | Egg Mayo Sandwich 27524 | 19 19 | 720 | 770 | 2024-07-28 |
| 28093 | Honey Chicken Wholemeal Sandwich 27525 | 19 19 | 720 | 770 | 2024-07-28 |
| 28094 | Voyage Blend 27526 | 18 18 | 1690 | 1740 | 2024-07-28 |
| 28095 | Pandan Fantasy 27527 | 18 18 | 850 | 900 | 2024-07-28 |
| 28096 | Iced Pandan Fantasy 27528 | 18 18 | 850 | 900 | 2024-07-28 |
| 28097 | Egg Mayo Sandwich 27529 | 18 18 | 720 | 770 | 2024-07-28 |
| 28098 | Honey Chicken Wholemeal Sandwich 27530 | 18 18 | 720 | 770 | 2024-07-28 |
| 28099 | Voyage Blend 27531 | 17 17 | 1690 | 1740 | 2024-07-28 |
| 28100 | Pandan Fantasy 27532 | 17 17 | 850 | 900 | 2024-07-28 |
| 28101 | Iced Pandan Fantasy 27533 | 17 17 | 850 | 900 | 2024-07-28 |
| 28102 | Egg Mayo Sandwich 27534 | 17 17 | 720 | 770 | 2024-07-28 |
| 28103 | Honey Chicken Wholemeal Sandwich 27535 | 17 17 | 720 | 770 | 2024-07-28 |
| 28104 | Voyage Blend 27536 | 16 16 | 1690 | 1740 | 2024-07-28 |
| 28105 | Pandan Fantasy 27537 | 16 16 | 850 | 900 | 2024-07-28 |
| 28106 | Iced Pandan Fantasy 27538 | 16 16 | 850 | 900 | 2024-07-28 |
| 28107 | Egg Mayo Sandwich 27539 | 16 16 | 720 | 770 | 2024-07-28 |
| 28108 | Honey Chicken Wholemeal Sandwich 27540 | 16 16 | 720 | 770 | 2024-07-28 |
| 28109 | Voyage Blend 27541 | 15 15 | 1690 | 1740 | 2024-07-28 |
| 28110 | Pandan Fantasy 27542 | 15 15 | 760 | 810 | 2024-07-28 |
| 28111 | Iced Pandan Fantasy 27543 | 15 15 | 760 | 810 | 2024-07-28 |
| 28112 | Egg Mayo Sandwich 27544 | 15 15 | 640 | 690 | 2024-07-28 |
| 28113 | Honey Chicken Wholemeal Sandwich 27545 | 15 15 | 640 | 690 | 2024-07-28 |
| 28114 | Voyage Blend 27546 | 14 14 | 1690 | 1740 | 2024-07-28 |
| 28115 | Pandan Fantasy 27547 | 14 14 | 850 | 900 | 2024-07-28 |
| 28116 | Iced Pandan Fantasy 27548 | 14 14 | 850 | 900 | 2024-07-28 |
| 28117 | Egg Mayo Sandwich 27549 | 14 14 | 720 | 770 | 2024-07-28 |
| 28118 | Honey Chicken Wholemeal Sandwich 27550 | 14 14 | 720 | 770 | 2024-07-28 |
| 28119 | Voyage Blend 27551 | 11 11 | 1690 | 1740 | 2024-07-28 |
| 28120 | Pandan Fantasy 27552 | 11 11 | 850 | 900 | 2024-07-28 |
| 28121 | Iced Pandan Fantasy 27553 | 11 11 | 850 | 900 | 2024-07-28 |
| 28122 | Egg Mayo Sandwich 27554 | 11 11 | 720 | 770 | 2024-07-28 |
| 28123 | Honey Chicken Wholemeal Sandwich 27555 | 11 11 | 720 | 770 | 2024-07-28 |
| 28124 | Voyage Blend 27556 | 10 10 | 1690 | 1740 | 2024-07-28 |
| 28125 | Butter Madeleines 27557 | 10 10 | 350 | 400 | 2024-07-28 |
| 28126 | Chocolate Hazelnut Madeleines 27558 | 10 10 | 350 | 400 | 2024-07-28 |
| 28127 | Pandan Fantasy 27559 | 10 10 | 850 | 900 | 2024-07-28 |
| 28128 | Iced Pandan Fantasy 27560 | 10 10 | 850 | 900 | 2024-07-28 |
| 28129 | Egg Mayo Sandwich 27561 | 10 10 | 720 | 770 | 2024-07-28 |
| 28130 | Honey Chicken Wholemeal Sandwich 27562 | 10 10 | 720 | 770 | 2024-07-28 |
| 28131 | Voyage Blend 27563 | 9 9 | 1690 | 1740 | 2024-07-28 |
| 28132 | Pandan Fantasy 27564 | 9 9 | 850 | 900 | 2024-07-28 |
| 28133 | Iced Pandan Fantasy 27565 | 9 9 | 850 | 900 | 2024-07-28 |
| 28134 | Egg Mayo Sandwich 27566 | 9 9 | 720 | 770 | 2024-07-28 |
| 28135 | Honey Chicken Wholemeal Sandwich 27567 | 9 9 | 720 | 770 | 2024-07-28 |
| 28136 | Voyage Blend 27568 | 8 8 | 1690 | 1740 | 2024-07-28 |
| 28137 | Pandan Fantasy 27569 | 8 8 | 850 | 900 | 2024-07-28 |
| 28138 | Iced Pandan Fantasy 27570 | 8 8 | 850 | 900 | 2024-07-28 |
| 28139 | Egg Mayo Sandwich 27571 | 8 8 | 720 | 770 | 2024-07-28 |
| 28140 | Honey Chicken Wholemeal Sandwich 27572 | 8 8 | 720 | 770 | 2024-07-28 |
| 28141 | Voyage Blend 27573 | 7 7 | 1690 | 1740 | 2024-07-28 |
| 28142 | Pandan Fantasy 27574 | 7 7 | 850 | 900 | 2024-07-28 |
| 28143 | Iced Pandan Fantasy 27575 | 7 7 | 850 | 900 | 2024-07-28 |
| 28144 | Egg Mayo Sandwich 27576 | 7 7 | 720 | 770 | 2024-07-28 |
| 28145 | Honey Chicken Wholemeal Sandwich 27577 | 7 7 | 720 | 770 | 2024-07-28 |
| 28146 | Voyage Blend 27578 | 148 148 | 1690 | 1740 | 2024-07-28 |
| 28147 | Pandan Fantasy 27579 | 148 148 | 910 | 960 | 2024-07-28 |
| 28148 | Iced Pandan Fantasy 27580 | 148 148 | 910 | 960 | 2024-07-28 |
| 28149 | Egg Mayo Sandwich 27581 | 148 148 | 750 | 800 | 2024-07-28 |
| 28150 | Honey Chicken Wholemeal Sandwich 27582 | 148 148 | 750 | 800 | 2024-07-28 |
| 28151 | Voyage Blend 27583 | 147 147 | 1690 | 1740 | 2024-07-28 |
| 28152 | Pandan Fantasy 27584 | 147 147 | 850 | 900 | 2024-07-28 |
| 28153 | Iced Pandan Fantasy 27585 | 147 147 | 850 | 900 | 2024-07-28 |
| 28154 | Egg Mayo Sandwich 27586 | 147 147 | 720 | 770 | 2024-07-28 |
| 28155 | Honey Chicken Wholemeal Sandwich 27587 | 147 147 | 720 | 770 | 2024-07-28 |
| 28156 | Voyage Blend 27588 | 146 146 | 1690 | 1740 | 2024-07-28 |
| 28157 | Pandan Fantasy 27589 | 146 146 | 850 | 900 | 2024-07-28 |
| 28158 | Iced Pandan Fantasy 27590 | 146 146 | 850 | 900 | 2024-07-28 |
| 28159 | Egg Mayo Sandwich 27591 | 146 146 | 720 | 770 | 2024-07-28 |
| 28160 | Honey Chicken Wholemeal Sandwich 27592 | 146 146 | 720 | 770 | 2024-07-28 |
| 28161 | Voyage Blend 27593 | 145 145 | 1690 | 1740 | 2024-07-28 |
| 28162 | Pandan Fantasy 27594 | 145 145 | 850 | 900 | 2024-07-28 |
| 28163 | Iced Pandan Fantasy 27595 | 145 145 | 850 | 900 | 2024-07-28 |
| 28164 | Egg Mayo Sandwich 27596 | 145 145 | 720 | 770 | 2024-07-28 |
| 28165 | Honey Chicken Wholemeal Sandwich 27597 | 145 145 | 720 | 770 | 2024-07-28 |
| 28166 | Voyage Blend 27598 | 144 144 | 1690 | 1740 | 2024-07-28 |
| 28167 | Pandan Fantasy 27599 | 144 144 | 850 | 900 | 2024-07-28 |
| 28168 | Iced Pandan Fantasy 27600 | 144 144 | 850 | 900 | 2024-07-28 |
| 28169 | Egg Mayo Sandwich 27601 | 144 144 | 720 | 770 | 2024-07-28 |
| 28170 | Honey Chicken Wholemeal Sandwich 27602 | 144 144 | 720 | 770 | 2024-07-28 |
| 28171 | Voyage Blend 27603 | 143 143 | 1690 | 1740 | 2024-07-28 |
| 28172 | Pandan Fantasy 27604 | 143 143 | 850 | 900 | 2024-07-28 |
| 28173 | Iced Pandan Fantasy 27605 | 143 143 | 850 | 900 | 2024-07-28 |
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");