item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
248 rows where store_id = 100
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
- 100 · 248 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 10260 | Bagel 10260 | 100 100 | 400 | 430 | 2024-06-28 |
| 10261 | Cookie Crumble Cheesecake 10261 | 100 100 | 720 | 770 | 2024-06-28 |
| 10262 | Good Ol' NY Cheesecake 10262 | 100 100 | 720 | 770 | 2024-06-28 |
| 10263 | Signature Chocolate Cake 10263 | 100 100 | 720 | 770 | 2024-06-28 |
| 10264 | Starbucks® Coffee Tiramisu Cake 10264 | 100 100 | 750 | 800 | 2024-06-28 |
| 10265 | Strawberry Shortcake 10265 | 100 100 | 720 | 770 | 2024-06-28 |
| 10266 | Chocolate Chunk Monster Cookie 10266 | 100 100 | 390 | 440 | 2024-06-28 |
| 10267 | Banana Walnut Muffin 10267 | 100 100 | 450 | 500 | 2024-06-28 |
| 10268 | Blueberry Crumble Muffin 10268 | 100 100 | 450 | 500 | 2024-06-28 |
| 10269 | Chocolate Crumble Muffin 10269 | 100 100 | 450 | 500 | 2024-06-28 |
| 10270 | Pancakes 10270 | 100 100 | 550 | 600 | 2024-06-28 |
| 10271 | Almond Croissant 10271 | 100 100 | 470 | 520 | 2024-06-28 |
| 10272 | Buttery Croissant 10272 | 100 100 | 400 | 430 | 2024-06-28 |
| 10273 | Chocolate Croissant 10273 | 100 100 | 440 | 490 | 2024-06-28 |
| 10274 | Creamy Chicken Foldover 10274 | 100 100 | 550 | 600 | 2024-06-28 |
| 10275 | Sausage Roll 10275 | 100 100 | 550 | 600 | 2024-06-28 |
| 10276 | Buttery Scone 10276 | 100 100 | 400 | 430 | 2024-06-28 |
| 10277 | Country Chicken Pie 10277 | 100 100 | 690 | 740 | 2024-06-28 |
| 10278 | Deep Dish Beef Pie 10278 | 100 100 | 690 | 740 | 2024-06-28 |
| 10279 | Spinach & Mushroom Quiche 10279 | 100 100 | 690 | 740 | 2024-06-28 |
| 10280 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 10280 | 100 100 | 390 | 420 | 2024-06-28 |
| 10281 | Mixed Nuts 10281 | 100 100 | 490 | 540 | 2024-06-28 |
| 10282 | Caramel Waffles 10282 | 100 100 | 390 | 420 | 2024-06-28 |
| 10283 | Chicken Ham & Cheese Panwich 10283 | 100 100 | 690 | 740 | 2024-06-28 |
| 10284 | Egg Mayo & Cheese Multigrain Croissant 10284 | 100 100 | 690 | 740 | 2024-06-28 |
| 10285 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 10285 | 100 100 | 690 | 740 | 2024-06-28 |
| 10286 | Rosemary Chicken & Emmental Cheese Croissant 10286 | 100 100 | 690 | 740 | 2024-06-28 |
| 10287 | Scrambled Egg & Turkey Ham Pita 10287 | 100 100 | 690 | 740 | 2024-06-28 |
| 10288 | Turkey Ham & Triple Cheese Toast 10288 | 100 100 | 690 | 740 | 2024-06-28 |
| 10289 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 10289 | 100 100 | 790 | 840 | 2024-06-28 |
| 10290 | Ham & Cheese Croissant 10290 | 100 100 | 690 | 740 | 2024-06-28 |
| 10291 | Sriracha Chicken Whole Wheat Pita 10291 | 100 100 | 750 | 800 | 2024-06-28 |
| 10292 | Blueberry Acai Yogurt Parfait 10292 | 100 100 | 650 | 700 | 2024-06-28 |
| 10293 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 10293 | 100 100 | 650 | 700 | 2024-06-28 |
| 10294 | Caramel Frappuccino® 10294 | 100 100 | 720 | 770 | 2024-06-28 |
| 10295 | Dark Mocha Frappuccino® 10295 | 100 100 | 780 | 830 | 2024-06-28 |
| 10296 | Java Chip Frappuccino® 10296 | 100 100 | 780 | 830 | 2024-06-28 |
| 10297 | Mocha Frappuccino® 10297 | 100 100 | 720 | 770 | 2024-06-28 |
| 10298 | Caramel Macchiato Frappuccino® 10298 | 100 100 | 780 | 830 | 2024-06-28 |
| 10299 | Espresso Frappuccino® 10299 | 100 100 | 720 | 770 | 2024-06-28 |
| 10300 | White Chocolate Mocha Frappuccino® 10300 | 100 100 | 720 | 770 | 2024-06-28 |
| 10301 | Chocolate Chip Cream Frappuccino® 10301 | 100 100 | 780 | 830 | 2024-06-28 |
| 10302 | Hojicha Tea Cream Frappuccino® 10302 | 100 100 | 760 | 810 | 2024-06-28 |
| 10303 | Vanilla Cream Frappuccino® 10303 | 100 100 | 720 | 770 | 2024-06-28 |
| 10304 | Mango Passion Fruit & Hibiscus 10304 | 100 100 | 720 | 770 | 2024-06-28 |
| 10305 | Raspberry Black Currant & Oolong 10305 | 100 100 | 720 | 770 | 2024-06-28 |
| 10306 | Coffee Traveller 10306 | 100 100 | 3120 | 3170 | 2024-06-28 |
| 10307 | Caffè Americano 10307 | 100 100 | 540 | 590 | 2024-06-28 |
| 10308 | Cappuccino 10308 | 100 100 | 680 | 730 | 2024-06-28 |
| 10309 | Caffè Mocha 10309 | 100 100 | 750 | 800 | 2024-06-28 |
| 10310 | Caramel Macchiato 10310 | 100 100 | 760 | 810 | 2024-06-28 |
| 10311 | Espresso 10311 | 100 100 | 390 | 440 | 2024-06-28 |
| 10312 | Caffè Latte 10312 | 100 100 | 680 | 730 | 2024-06-28 |
| 10313 | Oatmilk Latte 10313 | 100 100 | 760 | 810 | 2024-06-28 |
| 10314 | Vanilla Latte 10314 | 100 100 | 750 | 800 | 2024-06-28 |
| 10315 | White Chocolate Mocha 10315 | 100 100 | 750 | 800 | 2024-06-28 |
| 10316 | Flat White 10316 | 100 100 | 760 | 810 | 2024-06-28 |
| 10317 | Ristretto Bianco 10317 | 100 100 | 760 | 810 | 2024-06-28 |
| 10318 | Iced Caffè Americano 10318 | 100 100 | 540 | 590 | 2024-06-28 |
| 10319 | Iced Cappuccino 10319 | 100 100 | 680 | 730 | 2024-06-28 |
| 10320 | Iced Caffè Mocha 10320 | 100 100 | 750 | 800 | 2024-06-28 |
| 10321 | Iced Caramel Macchiato 10321 | 100 100 | 760 | 810 | 2024-06-28 |
| 10322 | Iced Caffè Latte 10322 | 100 100 | 680 | 730 | 2024-06-28 |
| 10323 | Iced Oatmilk Latte 10323 | 100 100 | 760 | 810 | 2024-06-28 |
| 10324 | Iced Vanilla Latte 10324 | 100 100 | 750 | 800 | 2024-06-28 |
| 10325 | Iced White Chocolate Mocha 10325 | 100 100 | 750 | 800 | 2024-06-28 |
| 10326 | Signature Hot Chocolate 10326 | 100 100 | 720 | 770 | 2024-06-28 |
| 10327 | Signature Iced Chocolate 10327 | 100 100 | 720 | 770 | 2024-06-28 |
| 10328 | Carrot Juice 10328 | 100 100 | 490 | 540 | 2024-06-28 |
| 10329 | Cloudy Apple Juice 10329 | 100 100 | 490 | 540 | 2024-06-28 |
| 10330 | Cranberry Red Grapefruit Juice 10330 | 100 100 | 490 | 540 | 2024-06-28 |
| 10331 | Orange Juice 10331 | 100 100 | 490 | 540 | 2024-06-28 |
| 10332 | Evian 10332 | 100 100 | 350 | 400 | 2024-06-28 |
| 10333 | Sparkling Water 10333 | 100 100 | 450 | 500 | 2024-06-28 |
| 10334 | Chai Tea 10334 | 100 100 | 500 | 550 | 2024-06-28 |
| 10335 | Earl Grey Tea 10335 | 100 100 | 500 | 550 | 2024-06-28 |
| 10336 | English Breakfast Tea 10336 | 100 100 | 500 | 550 | 2024-06-28 |
| 10337 | Emperor’s Clouds & Mist™ Tea 10337 | 100 100 | 500 | 550 | 2024-06-28 |
| 10338 | Mint Blend Tea 10338 | 100 100 | 500 | 550 | 2024-06-28 |
| 10339 | Chamomile Tea 10339 | 100 100 | 500 | 550 | 2024-06-28 |
| 10340 | Pure Matcha Latte 10340 | 100 100 | 740 | 790 | 2024-06-28 |
| 10341 | Chai Tea Latte 10341 | 100 100 | 680 | 730 | 2024-06-28 |
| 10342 | Earl Grey Tea Latte 10342 | 100 100 | 680 | 730 | 2024-06-28 |
| 10343 | English Breakfast Tea Latte 10343 | 100 100 | 680 | 730 | 2024-06-28 |
| 10344 | Hojicha Tea Latte 10344 | 100 100 | 740 | 790 | 2024-06-28 |
| 10345 | Zen Clouds Oolong Tea 10345 | 100 100 | 500 | 550 | 2024-06-28 |
| 10346 | Zen Clouds Oolong with Ruby Grapefruit and Honey 10346 | 100 100 | 630 | 680 | 2024-06-28 |
| 10347 | Youthberry™ Tea 10347 | 100 100 | 500 | 550 | 2024-06-28 |
| 10348 | Iced Shaken Black Tea Lemonade 10348 | 100 100 | 610 | 660 | 2024-06-28 |
| 10349 | Iced Shaken Strawberry Black Tea Lemonade 10349 | 100 100 | 630 | 680 | 2024-06-28 |
| 10350 | Iced Shaken Hibiscus Tea Lemonade 10350 | 100 100 | 610 | 660 | 2024-06-28 |
| 10351 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 10351 | 100 100 | 730 | 780 | 2024-06-28 |
| 10352 | Iced Pure Matcha Latte 10352 | 100 100 | 740 | 790 | 2024-06-28 |
| 10353 | Iced Chai Tea Latte 10353 | 100 100 | 680 | 730 | 2024-06-28 |
| 10354 | Iced Black Tea Latte 10354 | 100 100 | 680 | 730 | 2024-06-28 |
| 10355 | Iced Hojicha Tea Latte 10355 | 100 100 | 740 | 790 | 2024-06-28 |
| 10356 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 10356 | 100 100 | 630 | 680 | 2024-06-28 |
| 10357 | Iced Shaken Zen Clouds Oolong Lemonade 10357 | 100 100 | 610 | 660 | 2024-06-28 |
| 10358 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 10358 | 100 100 | 630 | 680 | 2024-06-28 |
| 10359 | Origami Pike Place® Roast 10359 | 100 100 | 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");