item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
248 rows where store_id = 132
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 12
- 2024-06-28 182
- 2024-11-10 14
- 2024-09-15 10
- 2024-11-03 9
- 2024-07-17 7
- 2024-07-28 5
- 2024-08-18 5
- 2024-07-03 4
- 2024-10-06 4
- 2024-10-13 4
- 2024-07-14 2
- 2024-09-29 2
store_id 1
- 132 · 248 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 5158 | Bagel 5158 | 132 132 | 400 | 430 | 2024-06-28 |
| 5159 | Cookie Crumble Cheesecake 5159 | 132 132 | 720 | 770 | 2024-06-28 |
| 5160 | Good Ol' NY Cheesecake 5160 | 132 132 | 720 | 770 | 2024-06-28 |
| 5161 | Signature Chocolate Cake 5161 | 132 132 | 720 | 770 | 2024-06-28 |
| 5162 | Starbucks® Coffee Tiramisu Cake 5162 | 132 132 | 750 | 800 | 2024-06-28 |
| 5163 | Strawberry Shortcake 5163 | 132 132 | 720 | 770 | 2024-06-28 |
| 5164 | Chocolate Chunk Monster Cookie 5164 | 132 132 | 390 | 440 | 2024-06-28 |
| 5165 | Banana Walnut Muffin 5165 | 132 132 | 450 | 500 | 2024-06-28 |
| 5166 | Blueberry Crumble Muffin 5166 | 132 132 | 450 | 500 | 2024-06-28 |
| 5167 | Chocolate Crumble Muffin 5167 | 132 132 | 450 | 500 | 2024-06-28 |
| 5168 | Pancakes 5168 | 132 132 | 550 | 600 | 2024-06-28 |
| 5169 | Almond Croissant 5169 | 132 132 | 470 | 520 | 2024-06-28 |
| 5170 | Buttery Croissant 5170 | 132 132 | 400 | 430 | 2024-06-28 |
| 5171 | Chocolate Croissant 5171 | 132 132 | 440 | 490 | 2024-06-28 |
| 5172 | Creamy Chicken Foldover 5172 | 132 132 | 550 | 600 | 2024-06-28 |
| 5173 | Sausage Roll 5173 | 132 132 | 550 | 600 | 2024-06-28 |
| 5174 | Buttery Scone 5174 | 132 132 | 400 | 430 | 2024-06-28 |
| 5175 | Country Chicken Pie 5175 | 132 132 | 690 | 740 | 2024-06-28 |
| 5176 | Deep Dish Beef Pie 5176 | 132 132 | 690 | 740 | 2024-06-28 |
| 5177 | Spinach & Mushroom Quiche 5177 | 132 132 | 690 | 740 | 2024-06-28 |
| 5178 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 5178 | 132 132 | 390 | 420 | 2024-06-28 |
| 5179 | Mixed Nuts 5179 | 132 132 | 490 | 540 | 2024-06-28 |
| 5180 | Caramel Waffles 5180 | 132 132 | 390 | 420 | 2024-06-28 |
| 5181 | Chicken Ham & Cheese Panwich 5181 | 132 132 | 690 | 740 | 2024-06-28 |
| 5182 | Egg Mayo & Cheese Multigrain Croissant 5182 | 132 132 | 690 | 740 | 2024-06-28 |
| 5183 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 5183 | 132 132 | 690 | 740 | 2024-06-28 |
| 5184 | Rosemary Chicken & Emmental Cheese Croissant 5184 | 132 132 | 690 | 740 | 2024-06-28 |
| 5185 | Scrambled Egg & Turkey Ham Pita 5185 | 132 132 | 690 | 740 | 2024-06-28 |
| 5186 | Turkey Ham & Triple Cheese Toast 5186 | 132 132 | 690 | 740 | 2024-06-28 |
| 5187 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 5187 | 132 132 | 790 | 840 | 2024-06-28 |
| 5188 | Ham & Cheese Croissant 5188 | 132 132 | 690 | 740 | 2024-06-28 |
| 5189 | Sriracha Chicken Whole Wheat Pita 5189 | 132 132 | 750 | 800 | 2024-06-28 |
| 5190 | Blueberry Acai Yogurt Parfait 5190 | 132 132 | 650 | 700 | 2024-06-28 |
| 5191 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 5191 | 132 132 | 650 | 700 | 2024-06-28 |
| 5192 | Caramel Frappuccino® 5192 | 132 132 | 720 | 770 | 2024-06-28 |
| 5193 | Dark Mocha Frappuccino® 5193 | 132 132 | 780 | 830 | 2024-06-28 |
| 5194 | Java Chip Frappuccino® 5194 | 132 132 | 780 | 830 | 2024-06-28 |
| 5195 | Mocha Frappuccino® 5195 | 132 132 | 720 | 770 | 2024-06-28 |
| 5196 | Caramel Macchiato Frappuccino® 5196 | 132 132 | 780 | 830 | 2024-06-28 |
| 5197 | Espresso Frappuccino® 5197 | 132 132 | 720 | 770 | 2024-06-28 |
| 5198 | White Chocolate Mocha Frappuccino® 5198 | 132 132 | 720 | 770 | 2024-06-28 |
| 5199 | Chocolate Chip Cream Frappuccino® 5199 | 132 132 | 780 | 830 | 2024-06-28 |
| 5200 | Hojicha Tea Cream Frappuccino® 5200 | 132 132 | 760 | 810 | 2024-06-28 |
| 5201 | Vanilla Cream Frappuccino® 5201 | 132 132 | 720 | 770 | 2024-06-28 |
| 5202 | Mango Passion Fruit & Hibiscus 5202 | 132 132 | 720 | 770 | 2024-06-28 |
| 5203 | Raspberry Black Currant & Oolong 5203 | 132 132 | 720 | 770 | 2024-06-28 |
| 5204 | Coffee Traveller 5204 | 132 132 | 3120 | 3170 | 2024-06-28 |
| 5205 | Caffè Americano 5205 | 132 132 | 540 | 590 | 2024-06-28 |
| 5206 | Cappuccino 5206 | 132 132 | 680 | 730 | 2024-06-28 |
| 5207 | Caffè Mocha 5207 | 132 132 | 750 | 800 | 2024-06-28 |
| 5208 | Caramel Macchiato 5208 | 132 132 | 760 | 810 | 2024-06-28 |
| 5209 | Espresso 5209 | 132 132 | 390 | 440 | 2024-06-28 |
| 5210 | Caffè Latte 5210 | 132 132 | 680 | 730 | 2024-06-28 |
| 5211 | Oatmilk Latte 5211 | 132 132 | 760 | 810 | 2024-06-28 |
| 5212 | Vanilla Latte 5212 | 132 132 | 750 | 800 | 2024-06-28 |
| 5213 | White Chocolate Mocha 5213 | 132 132 | 750 | 800 | 2024-06-28 |
| 5214 | Flat White 5214 | 132 132 | 760 | 810 | 2024-06-28 |
| 5215 | Ristretto Bianco 5215 | 132 132 | 760 | 810 | 2024-06-28 |
| 5216 | Iced Caffè Americano 5216 | 132 132 | 540 | 590 | 2024-06-28 |
| 5217 | Iced Cappuccino 5217 | 132 132 | 680 | 730 | 2024-06-28 |
| 5218 | Iced Caffè Mocha 5218 | 132 132 | 750 | 800 | 2024-06-28 |
| 5219 | Iced Caramel Macchiato 5219 | 132 132 | 760 | 810 | 2024-06-28 |
| 5220 | Iced Caffè Latte 5220 | 132 132 | 680 | 730 | 2024-06-28 |
| 5221 | Iced Oatmilk Latte 5221 | 132 132 | 760 | 810 | 2024-06-28 |
| 5222 | Iced Vanilla Latte 5222 | 132 132 | 750 | 800 | 2024-06-28 |
| 5223 | Iced White Chocolate Mocha 5223 | 132 132 | 750 | 800 | 2024-06-28 |
| 5224 | Signature Hot Chocolate 5224 | 132 132 | 720 | 770 | 2024-06-28 |
| 5225 | Signature Iced Chocolate 5225 | 132 132 | 720 | 770 | 2024-06-28 |
| 5226 | Carrot Juice 5226 | 132 132 | 490 | 540 | 2024-06-28 |
| 5227 | Cloudy Apple Juice 5227 | 132 132 | 490 | 540 | 2024-06-28 |
| 5228 | Cranberry Red Grapefruit Juice 5228 | 132 132 | 490 | 540 | 2024-06-28 |
| 5229 | Orange Juice 5229 | 132 132 | 490 | 540 | 2024-06-28 |
| 5230 | Evian 5230 | 132 132 | 350 | 400 | 2024-06-28 |
| 5231 | Sparkling Water 5231 | 132 132 | 450 | 500 | 2024-06-28 |
| 5232 | Chai Tea 5232 | 132 132 | 500 | 550 | 2024-06-28 |
| 5233 | Earl Grey Tea 5233 | 132 132 | 500 | 550 | 2024-06-28 |
| 5234 | English Breakfast Tea 5234 | 132 132 | 500 | 550 | 2024-06-28 |
| 5235 | Emperor’s Clouds & Mist™ Tea 5235 | 132 132 | 500 | 550 | 2024-06-28 |
| 5236 | Mint Blend Tea 5236 | 132 132 | 500 | 550 | 2024-06-28 |
| 5237 | Chamomile Tea 5237 | 132 132 | 500 | 550 | 2024-06-28 |
| 5238 | Pure Matcha Latte 5238 | 132 132 | 740 | 790 | 2024-06-28 |
| 5239 | Chai Tea Latte 5239 | 132 132 | 680 | 730 | 2024-06-28 |
| 5240 | Earl Grey Tea Latte 5240 | 132 132 | 680 | 730 | 2024-06-28 |
| 5241 | English Breakfast Tea Latte 5241 | 132 132 | 680 | 730 | 2024-06-28 |
| 5242 | Hojicha Tea Latte 5242 | 132 132 | 740 | 790 | 2024-06-28 |
| 5243 | Zen Clouds Oolong Tea 5243 | 132 132 | 500 | 550 | 2024-06-28 |
| 5244 | Zen Clouds Oolong with Ruby Grapefruit and Honey 5244 | 132 132 | 630 | 680 | 2024-06-28 |
| 5245 | Youthberry™ Tea 5245 | 132 132 | 500 | 550 | 2024-06-28 |
| 5246 | Iced Shaken Black Tea Lemonade 5246 | 132 132 | 610 | 660 | 2024-06-28 |
| 5247 | Iced Shaken Strawberry Black Tea Lemonade 5247 | 132 132 | 630 | 680 | 2024-06-28 |
| 5248 | Iced Shaken Hibiscus Tea Lemonade 5248 | 132 132 | 610 | 660 | 2024-06-28 |
| 5249 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 5249 | 132 132 | 730 | 780 | 2024-06-28 |
| 5250 | Iced Pure Matcha Latte 5250 | 132 132 | 740 | 790 | 2024-06-28 |
| 5251 | Iced Chai Tea Latte 5251 | 132 132 | 680 | 730 | 2024-06-28 |
| 5252 | Iced Black Tea Latte 5252 | 132 132 | 680 | 730 | 2024-06-28 |
| 5253 | Iced Hojicha Tea Latte 5253 | 132 132 | 740 | 790 | 2024-06-28 |
| 5254 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 5254 | 132 132 | 630 | 680 | 2024-06-28 |
| 5255 | Iced Shaken Zen Clouds Oolong Lemonade 5255 | 132 132 | 610 | 660 | 2024-06-28 |
| 5256 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 5256 | 132 132 | 630 | 680 | 2024-06-28 |
| 5257 | Origami Pike Place® Roast 5257 | 132 132 | 990 | 1040 | 2024-06-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");