item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 84
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 11
- 2024-06-28 182
- 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
- 84 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 13204 | Bagel 13204 | 84 84 | 400 | 430 | 2024-06-28 |
| 13205 | Cookie Crumble Cheesecake 13205 | 84 84 | 720 | 770 | 2024-06-28 |
| 13206 | Good Ol' NY Cheesecake 13206 | 84 84 | 720 | 770 | 2024-06-28 |
| 13207 | Signature Chocolate Cake 13207 | 84 84 | 720 | 770 | 2024-06-28 |
| 13208 | Starbucks® Coffee Tiramisu Cake 13208 | 84 84 | 750 | 800 | 2024-06-28 |
| 13209 | Strawberry Shortcake 13209 | 84 84 | 720 | 770 | 2024-06-28 |
| 13210 | Chocolate Chunk Monster Cookie 13210 | 84 84 | 390 | 440 | 2024-06-28 |
| 13211 | Banana Walnut Muffin 13211 | 84 84 | 450 | 500 | 2024-06-28 |
| 13212 | Blueberry Crumble Muffin 13212 | 84 84 | 450 | 500 | 2024-06-28 |
| 13213 | Chocolate Crumble Muffin 13213 | 84 84 | 450 | 500 | 2024-06-28 |
| 13214 | Pancakes 13214 | 84 84 | 550 | 600 | 2024-06-28 |
| 13215 | Almond Croissant 13215 | 84 84 | 470 | 520 | 2024-06-28 |
| 13216 | Buttery Croissant 13216 | 84 84 | 400 | 430 | 2024-06-28 |
| 13217 | Chocolate Croissant 13217 | 84 84 | 440 | 490 | 2024-06-28 |
| 13218 | Creamy Chicken Foldover 13218 | 84 84 | 550 | 600 | 2024-06-28 |
| 13219 | Sausage Roll 13219 | 84 84 | 550 | 600 | 2024-06-28 |
| 13220 | Buttery Scone 13220 | 84 84 | 400 | 430 | 2024-06-28 |
| 13221 | Country Chicken Pie 13221 | 84 84 | 690 | 740 | 2024-06-28 |
| 13222 | Deep Dish Beef Pie 13222 | 84 84 | 690 | 740 | 2024-06-28 |
| 13223 | Spinach & Mushroom Quiche 13223 | 84 84 | 690 | 740 | 2024-06-28 |
| 13224 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 13224 | 84 84 | 390 | 420 | 2024-06-28 |
| 13225 | Mixed Nuts 13225 | 84 84 | 490 | 540 | 2024-06-28 |
| 13226 | Caramel Waffles 13226 | 84 84 | 390 | 420 | 2024-06-28 |
| 13227 | Chicken Ham & Cheese Panwich 13227 | 84 84 | 690 | 740 | 2024-06-28 |
| 13228 | Egg Mayo & Cheese Multigrain Croissant 13228 | 84 84 | 690 | 740 | 2024-06-28 |
| 13229 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 13229 | 84 84 | 690 | 740 | 2024-06-28 |
| 13230 | Rosemary Chicken & Emmental Cheese Croissant 13230 | 84 84 | 690 | 740 | 2024-06-28 |
| 13231 | Scrambled Egg & Turkey Ham Pita 13231 | 84 84 | 690 | 740 | 2024-06-28 |
| 13232 | Turkey Ham & Triple Cheese Toast 13232 | 84 84 | 690 | 740 | 2024-06-28 |
| 13233 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 13233 | 84 84 | 790 | 840 | 2024-06-28 |
| 13234 | Ham & Cheese Croissant 13234 | 84 84 | 690 | 740 | 2024-06-28 |
| 13235 | Sriracha Chicken Whole Wheat Pita 13235 | 84 84 | 750 | 800 | 2024-06-28 |
| 13236 | Blueberry Acai Yogurt Parfait 13236 | 84 84 | 650 | 700 | 2024-06-28 |
| 13237 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 13237 | 84 84 | 650 | 700 | 2024-06-28 |
| 13238 | Caramel Frappuccino® 13238 | 84 84 | 720 | 770 | 2024-06-28 |
| 13239 | Dark Mocha Frappuccino® 13239 | 84 84 | 780 | 830 | 2024-06-28 |
| 13240 | Java Chip Frappuccino® 13240 | 84 84 | 780 | 830 | 2024-06-28 |
| 13241 | Mocha Frappuccino® 13241 | 84 84 | 720 | 770 | 2024-06-28 |
| 13242 | Caramel Macchiato Frappuccino® 13242 | 84 84 | 780 | 830 | 2024-06-28 |
| 13243 | Espresso Frappuccino® 13243 | 84 84 | 720 | 770 | 2024-06-28 |
| 13244 | White Chocolate Mocha Frappuccino® 13244 | 84 84 | 720 | 770 | 2024-06-28 |
| 13245 | Chocolate Chip Cream Frappuccino® 13245 | 84 84 | 780 | 830 | 2024-06-28 |
| 13246 | Hojicha Tea Cream Frappuccino® 13246 | 84 84 | 760 | 810 | 2024-06-28 |
| 13247 | Vanilla Cream Frappuccino® 13247 | 84 84 | 720 | 770 | 2024-06-28 |
| 13248 | Mango Passion Fruit & Hibiscus 13248 | 84 84 | 720 | 770 | 2024-06-28 |
| 13249 | Raspberry Black Currant & Oolong 13249 | 84 84 | 720 | 770 | 2024-06-28 |
| 13250 | Coffee Traveller 13250 | 84 84 | 3120 | 3170 | 2024-06-28 |
| 13251 | Caffè Americano 13251 | 84 84 | 540 | 590 | 2024-06-28 |
| 13252 | Cappuccino 13252 | 84 84 | 680 | 730 | 2024-06-28 |
| 13253 | Caffè Mocha 13253 | 84 84 | 750 | 800 | 2024-06-28 |
| 13254 | Caramel Macchiato 13254 | 84 84 | 760 | 810 | 2024-06-28 |
| 13255 | Espresso 13255 | 84 84 | 390 | 440 | 2024-06-28 |
| 13256 | Caffè Latte 13256 | 84 84 | 680 | 730 | 2024-06-28 |
| 13257 | Oatmilk Latte 13257 | 84 84 | 760 | 810 | 2024-06-28 |
| 13258 | Vanilla Latte 13258 | 84 84 | 750 | 800 | 2024-06-28 |
| 13259 | White Chocolate Mocha 13259 | 84 84 | 750 | 800 | 2024-06-28 |
| 13260 | Flat White 13260 | 84 84 | 760 | 810 | 2024-06-28 |
| 13261 | Ristretto Bianco 13261 | 84 84 | 760 | 810 | 2024-06-28 |
| 13262 | Iced Caffè Americano 13262 | 84 84 | 540 | 590 | 2024-06-28 |
| 13263 | Iced Cappuccino 13263 | 84 84 | 680 | 730 | 2024-06-28 |
| 13264 | Iced Caffè Mocha 13264 | 84 84 | 750 | 800 | 2024-06-28 |
| 13265 | Iced Caramel Macchiato 13265 | 84 84 | 760 | 810 | 2024-06-28 |
| 13266 | Iced Caffè Latte 13266 | 84 84 | 680 | 730 | 2024-06-28 |
| 13267 | Iced Oatmilk Latte 13267 | 84 84 | 760 | 810 | 2024-06-28 |
| 13268 | Iced Vanilla Latte 13268 | 84 84 | 750 | 800 | 2024-06-28 |
| 13269 | Iced White Chocolate Mocha 13269 | 84 84 | 750 | 800 | 2024-06-28 |
| 13270 | Signature Hot Chocolate 13270 | 84 84 | 720 | 770 | 2024-06-28 |
| 13271 | Signature Iced Chocolate 13271 | 84 84 | 720 | 770 | 2024-06-28 |
| 13272 | Carrot Juice 13272 | 84 84 | 490 | 540 | 2024-06-28 |
| 13273 | Cloudy Apple Juice 13273 | 84 84 | 490 | 540 | 2024-06-28 |
| 13274 | Cranberry Red Grapefruit Juice 13274 | 84 84 | 490 | 540 | 2024-06-28 |
| 13275 | Orange Juice 13275 | 84 84 | 490 | 540 | 2024-06-28 |
| 13276 | Evian 13276 | 84 84 | 350 | 400 | 2024-06-28 |
| 13277 | Sparkling Water 13277 | 84 84 | 450 | 500 | 2024-06-28 |
| 13278 | Chai Tea 13278 | 84 84 | 500 | 550 | 2024-06-28 |
| 13279 | Earl Grey Tea 13279 | 84 84 | 500 | 550 | 2024-06-28 |
| 13280 | English Breakfast Tea 13280 | 84 84 | 500 | 550 | 2024-06-28 |
| 13281 | Emperor’s Clouds & Mist™ Tea 13281 | 84 84 | 500 | 550 | 2024-06-28 |
| 13282 | Mint Blend Tea 13282 | 84 84 | 500 | 550 | 2024-06-28 |
| 13283 | Chamomile Tea 13283 | 84 84 | 500 | 550 | 2024-06-28 |
| 13284 | Pure Matcha Latte 13284 | 84 84 | 740 | 790 | 2024-06-28 |
| 13285 | Chai Tea Latte 13285 | 84 84 | 680 | 730 | 2024-06-28 |
| 13286 | Earl Grey Tea Latte 13286 | 84 84 | 680 | 730 | 2024-06-28 |
| 13287 | English Breakfast Tea Latte 13287 | 84 84 | 680 | 730 | 2024-06-28 |
| 13288 | Hojicha Tea Latte 13288 | 84 84 | 740 | 790 | 2024-06-28 |
| 13289 | Zen Clouds Oolong Tea 13289 | 84 84 | 500 | 550 | 2024-06-28 |
| 13290 | Zen Clouds Oolong with Ruby Grapefruit and Honey 13290 | 84 84 | 630 | 680 | 2024-06-28 |
| 13291 | Youthberry™ Tea 13291 | 84 84 | 500 | 550 | 2024-06-28 |
| 13292 | Iced Shaken Black Tea Lemonade 13292 | 84 84 | 610 | 660 | 2024-06-28 |
| 13293 | Iced Shaken Strawberry Black Tea Lemonade 13293 | 84 84 | 630 | 680 | 2024-06-28 |
| 13294 | Iced Shaken Hibiscus Tea Lemonade 13294 | 84 84 | 610 | 660 | 2024-06-28 |
| 13295 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 13295 | 84 84 | 730 | 780 | 2024-06-28 |
| 13296 | Iced Pure Matcha Latte 13296 | 84 84 | 740 | 790 | 2024-06-28 |
| 13297 | Iced Chai Tea Latte 13297 | 84 84 | 680 | 730 | 2024-06-28 |
| 13298 | Iced Black Tea Latte 13298 | 84 84 | 680 | 730 | 2024-06-28 |
| 13299 | Iced Hojicha Tea Latte 13299 | 84 84 | 740 | 790 | 2024-06-28 |
| 13300 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 13300 | 84 84 | 630 | 680 | 2024-06-28 |
| 13301 | Iced Shaken Zen Clouds Oolong Lemonade 13301 | 84 84 | 610 | 660 | 2024-06-28 |
| 13302 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 13302 | 84 84 | 630 | 680 | 2024-06-28 |
| 13303 | Origami Pike Place® Roast 13303 | 84 84 | 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");