item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
229 rows where store_id = 8
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 10
- 2024-06-28 184
- 2024-09-15 10
- 2024-07-17 7
- 2024-08-18 6
- 2024-07-28 5
- 2024-10-13 5
- 2024-07-03 4
- 2024-10-06 4
- 2024-07-14 2
- 2024-09-29 2
store_id 1
- 8 · 229 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 25283 | Bagel 25283 | 8 8 | 400 | 430 | 2024-06-28 |
| 25284 | Cookie Crumble Cheesecake 25284 | 8 8 | 720 | 770 | 2024-06-28 |
| 25285 | Good Ol' NY Cheesecake 25285 | 8 8 | 720 | 770 | 2024-06-28 |
| 25286 | Signature Chocolate Cake 25286 | 8 8 | 720 | 770 | 2024-06-28 |
| 25287 | Starbucks® Coffee Tiramisu Cake 25287 | 8 8 | 750 | 800 | 2024-06-28 |
| 25288 | Strawberry Shortcake 25288 | 8 8 | 720 | 770 | 2024-06-28 |
| 25289 | Chocolate Chunk Monster Cookie 25289 | 8 8 | 390 | 440 | 2024-06-28 |
| 25290 | Banana Walnut Muffin 25290 | 8 8 | 450 | 500 | 2024-06-28 |
| 25291 | Blueberry Crumble Muffin 25291 | 8 8 | 450 | 500 | 2024-06-28 |
| 25292 | Chocolate Crumble Muffin 25292 | 8 8 | 450 | 500 | 2024-06-28 |
| 25293 | Pancakes 25293 | 8 8 | 550 | 600 | 2024-06-28 |
| 25294 | Almond Croissant 25294 | 8 8 | 470 | 520 | 2024-06-28 |
| 25295 | Buttery Croissant 25295 | 8 8 | 400 | 430 | 2024-06-28 |
| 25296 | Chocolate Croissant 25296 | 8 8 | 440 | 490 | 2024-06-28 |
| 25297 | Creamy Chicken Foldover 25297 | 8 8 | 550 | 600 | 2024-06-28 |
| 25298 | Sausage Roll 25298 | 8 8 | 550 | 600 | 2024-06-28 |
| 25299 | Buttery Scone 25299 | 8 8 | 400 | 430 | 2024-06-28 |
| 25300 | Country Chicken Pie 25300 | 8 8 | 690 | 740 | 2024-06-28 |
| 25301 | Deep Dish Beef Pie 25301 | 8 8 | 690 | 740 | 2024-06-28 |
| 25302 | Spinach & Mushroom Quiche 25302 | 8 8 | 690 | 740 | 2024-06-28 |
| 25303 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 25303 | 8 8 | 390 | 420 | 2024-06-28 |
| 25304 | Mixed Nuts 25304 | 8 8 | 490 | 540 | 2024-06-28 |
| 25305 | Caramel Waffles 25305 | 8 8 | 390 | 420 | 2024-06-28 |
| 25306 | Chicken Ham & Cheese Panwich 25306 | 8 8 | 690 | 740 | 2024-06-28 |
| 25307 | Egg Mayo & Cheese Multigrain Croissant 25307 | 8 8 | 690 | 740 | 2024-06-28 |
| 25308 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 25308 | 8 8 | 690 | 740 | 2024-06-28 |
| 25309 | Rosemary Chicken & Emmental Cheese Croissant 25309 | 8 8 | 690 | 740 | 2024-06-28 |
| 25310 | Scrambled Egg & Turkey Ham Pita 25310 | 8 8 | 690 | 740 | 2024-06-28 |
| 25311 | Turkey Ham & Triple Cheese Toast 25311 | 8 8 | 690 | 740 | 2024-06-28 |
| 25312 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 25312 | 8 8 | 790 | 840 | 2024-06-28 |
| 25313 | Ham & Cheese Croissant 25313 | 8 8 | 690 | 740 | 2024-06-28 |
| 25314 | Sriracha Chicken Whole Wheat Pita 25314 | 8 8 | 750 | 800 | 2024-06-28 |
| 25315 | Blueberry Acai Yogurt Parfait 25315 | 8 8 | 650 | 700 | 2024-06-28 |
| 25316 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 25316 | 8 8 | 650 | 700 | 2024-06-28 |
| 25317 | Caramel Frappuccino® 25317 | 8 8 | 720 | 770 | 2024-06-28 |
| 25318 | Dark Mocha Frappuccino® 25318 | 8 8 | 780 | 830 | 2024-06-28 |
| 25319 | Java Chip Frappuccino® 25319 | 8 8 | 780 | 830 | 2024-06-28 |
| 25320 | Mocha Frappuccino® 25320 | 8 8 | 720 | 770 | 2024-06-28 |
| 25321 | Caramel Macchiato Frappuccino® 25321 | 8 8 | 780 | 830 | 2024-06-28 |
| 25322 | Espresso Frappuccino® 25322 | 8 8 | 720 | 770 | 2024-06-28 |
| 25323 | White Chocolate Mocha Frappuccino® 25323 | 8 8 | 720 | 770 | 2024-06-28 |
| 25324 | Chocolate Chip Cream Frappuccino® 25324 | 8 8 | 780 | 830 | 2024-06-28 |
| 25325 | Hojicha Tea Cream Frappuccino® 25325 | 8 8 | 760 | 810 | 2024-06-28 |
| 25326 | Vanilla Cream Frappuccino® 25326 | 8 8 | 720 | 770 | 2024-06-28 |
| 25327 | Mango Passion Fruit & Hibiscus 25327 | 8 8 | 720 | 770 | 2024-06-28 |
| 25328 | Raspberry Black Currant & Oolong 25328 | 8 8 | 720 | 770 | 2024-06-28 |
| 25329 | Coffee Traveller 25329 | 8 8 | 3120 | 3170 | 2024-06-28 |
| 25330 | Caffè Americano 25330 | 8 8 | 540 | 590 | 2024-06-28 |
| 25331 | Cappuccino 25331 | 8 8 | 680 | 730 | 2024-06-28 |
| 25332 | Caffè Mocha 25332 | 8 8 | 750 | 800 | 2024-06-28 |
| 25333 | Caramel Macchiato 25333 | 8 8 | 760 | 810 | 2024-06-28 |
| 25334 | Espresso 25334 | 8 8 | 390 | 440 | 2024-06-28 |
| 25335 | Caffè Latte 25335 | 8 8 | 680 | 730 | 2024-06-28 |
| 25336 | Oatmilk Latte 25336 | 8 8 | 760 | 810 | 2024-06-28 |
| 25337 | Vanilla Latte 25337 | 8 8 | 750 | 800 | 2024-06-28 |
| 25338 | White Chocolate Mocha 25338 | 8 8 | 750 | 800 | 2024-06-28 |
| 25339 | Flat White 25339 | 8 8 | 760 | 810 | 2024-06-28 |
| 25340 | Ristretto Bianco 25340 | 8 8 | 760 | 810 | 2024-06-28 |
| 25341 | Iced Caffè Americano 25341 | 8 8 | 540 | 590 | 2024-06-28 |
| 25342 | Iced Cappuccino 25342 | 8 8 | 680 | 730 | 2024-06-28 |
| 25343 | Iced Caffè Mocha 25343 | 8 8 | 750 | 800 | 2024-06-28 |
| 25344 | Iced Caramel Macchiato 25344 | 8 8 | 760 | 810 | 2024-06-28 |
| 25345 | Iced Caffè Latte 25345 | 8 8 | 680 | 730 | 2024-06-28 |
| 25346 | Iced Oatmilk Latte 25346 | 8 8 | 760 | 810 | 2024-06-28 |
| 25347 | Iced Vanilla Latte 25347 | 8 8 | 750 | 800 | 2024-06-28 |
| 25348 | Iced White Chocolate Mocha 25348 | 8 8 | 750 | 800 | 2024-06-28 |
| 25349 | Signature Hot Chocolate 25349 | 8 8 | 720 | 770 | 2024-06-28 |
| 25350 | Signature Iced Chocolate 25350 | 8 8 | 720 | 770 | 2024-06-28 |
| 25351 | Carrot Juice 25351 | 8 8 | 490 | 540 | 2024-06-28 |
| 25352 | Cloudy Apple Juice 25352 | 8 8 | 490 | 540 | 2024-06-28 |
| 25353 | Cranberry Red Grapefruit Juice 25353 | 8 8 | 490 | 540 | 2024-06-28 |
| 25354 | Orange Juice 25354 | 8 8 | 490 | 540 | 2024-06-28 |
| 25355 | Evian 25355 | 8 8 | 350 | 400 | 2024-06-28 |
| 25356 | Sparkling Water 25356 | 8 8 | 450 | 500 | 2024-06-28 |
| 25357 | Chai Tea 25357 | 8 8 | 500 | 550 | 2024-06-28 |
| 25358 | Earl Grey Tea 25358 | 8 8 | 500 | 550 | 2024-06-28 |
| 25359 | English Breakfast Tea 25359 | 8 8 | 500 | 550 | 2024-06-28 |
| 25360 | Emperor’s Clouds & Mist™ Tea 25360 | 8 8 | 500 | 550 | 2024-06-28 |
| 25361 | Mint Blend Tea 25361 | 8 8 | 500 | 550 | 2024-06-28 |
| 25362 | Chamomile Tea 25362 | 8 8 | 500 | 550 | 2024-06-28 |
| 25363 | Pure Matcha Latte 25363 | 8 8 | 740 | 790 | 2024-06-28 |
| 25364 | Chai Tea Latte 25364 | 8 8 | 680 | 730 | 2024-06-28 |
| 25365 | Earl Grey Tea Latte 25365 | 8 8 | 680 | 730 | 2024-06-28 |
| 25366 | English Breakfast Tea Latte 25366 | 8 8 | 680 | 730 | 2024-06-28 |
| 25367 | Hojicha Tea Latte 25367 | 8 8 | 740 | 790 | 2024-06-28 |
| 25368 | Zen Clouds Oolong Tea 25368 | 8 8 | 500 | 550 | 2024-06-28 |
| 25369 | Zen Clouds Oolong with Ruby Grapefruit and Honey 25369 | 8 8 | 630 | 680 | 2024-06-28 |
| 25370 | Youthberry™ Tea 25370 | 8 8 | 500 | 550 | 2024-06-28 |
| 25371 | Iced Shaken Black Tea Lemonade 25371 | 8 8 | 610 | 660 | 2024-06-28 |
| 25372 | Iced Shaken Strawberry Black Tea Lemonade 25372 | 8 8 | 630 | 680 | 2024-06-28 |
| 25373 | Iced Shaken Hibiscus Tea Lemonade 25373 | 8 8 | 610 | 660 | 2024-06-28 |
| 25374 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 25374 | 8 8 | 730 | 780 | 2024-06-28 |
| 25375 | Iced Pure Matcha Latte 25375 | 8 8 | 740 | 790 | 2024-06-28 |
| 25376 | Iced Chai Tea Latte 25376 | 8 8 | 680 | 730 | 2024-06-28 |
| 25377 | Iced Black Tea Latte 25377 | 8 8 | 680 | 730 | 2024-06-28 |
| 25378 | Iced Hojicha Tea Latte 25378 | 8 8 | 740 | 790 | 2024-06-28 |
| 25379 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 25379 | 8 8 | 630 | 680 | 2024-06-28 |
| 25380 | Iced Shaken Zen Clouds Oolong Lemonade 25380 | 8 8 | 610 | 660 | 2024-06-28 |
| 25381 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 25381 | 8 8 | 630 | 680 | 2024-06-28 |
| 25382 | Origami Pike Place® Roast 25382 | 8 8 | 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");