item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
249 rows where store_id = 44
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 13
- 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
- 2024-11-17 1
store_id 1
- 44 · 249 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 19429 | Bagel 19429 | 44 44 | 400 | 430 | 2024-06-28 |
| 19430 | Cookie Crumble Cheesecake 19430 | 44 44 | 720 | 770 | 2024-06-28 |
| 19431 | Good Ol' NY Cheesecake 19431 | 44 44 | 720 | 770 | 2024-06-28 |
| 19432 | Signature Chocolate Cake 19432 | 44 44 | 720 | 770 | 2024-06-28 |
| 19433 | Starbucks® Coffee Tiramisu Cake 19433 | 44 44 | 750 | 800 | 2024-06-28 |
| 19434 | Strawberry Shortcake 19434 | 44 44 | 720 | 770 | 2024-06-28 |
| 19435 | Chocolate Chunk Monster Cookie 19435 | 44 44 | 390 | 440 | 2024-06-28 |
| 19436 | Banana Walnut Muffin 19436 | 44 44 | 450 | 500 | 2024-06-28 |
| 19437 | Blueberry Crumble Muffin 19437 | 44 44 | 450 | 500 | 2024-06-28 |
| 19438 | Chocolate Crumble Muffin 19438 | 44 44 | 450 | 500 | 2024-06-28 |
| 19439 | Pancakes 19439 | 44 44 | 550 | 600 | 2024-06-28 |
| 19440 | Almond Croissant 19440 | 44 44 | 470 | 520 | 2024-06-28 |
| 19441 | Buttery Croissant 19441 | 44 44 | 400 | 430 | 2024-06-28 |
| 19442 | Chocolate Croissant 19442 | 44 44 | 440 | 490 | 2024-06-28 |
| 19443 | Creamy Chicken Foldover 19443 | 44 44 | 550 | 600 | 2024-06-28 |
| 19444 | Sausage Roll 19444 | 44 44 | 550 | 600 | 2024-06-28 |
| 19445 | Buttery Scone 19445 | 44 44 | 400 | 430 | 2024-06-28 |
| 19446 | Country Chicken Pie 19446 | 44 44 | 690 | 740 | 2024-06-28 |
| 19447 | Deep Dish Beef Pie 19447 | 44 44 | 690 | 740 | 2024-06-28 |
| 19448 | Spinach & Mushroom Quiche 19448 | 44 44 | 690 | 740 | 2024-06-28 |
| 19449 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 19449 | 44 44 | 390 | 420 | 2024-06-28 |
| 19450 | Mixed Nuts 19450 | 44 44 | 490 | 540 | 2024-06-28 |
| 19451 | Caramel Waffles 19451 | 44 44 | 390 | 420 | 2024-06-28 |
| 19452 | Chicken Ham & Cheese Panwich 19452 | 44 44 | 690 | 740 | 2024-06-28 |
| 19453 | Egg Mayo & Cheese Multigrain Croissant 19453 | 44 44 | 690 | 740 | 2024-06-28 |
| 19454 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 19454 | 44 44 | 690 | 740 | 2024-06-28 |
| 19455 | Rosemary Chicken & Emmental Cheese Croissant 19455 | 44 44 | 690 | 740 | 2024-06-28 |
| 19456 | Scrambled Egg & Turkey Ham Pita 19456 | 44 44 | 690 | 740 | 2024-06-28 |
| 19457 | Turkey Ham & Triple Cheese Toast 19457 | 44 44 | 690 | 740 | 2024-06-28 |
| 19458 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 19458 | 44 44 | 790 | 840 | 2024-06-28 |
| 19459 | Ham & Cheese Croissant 19459 | 44 44 | 690 | 740 | 2024-06-28 |
| 19460 | Sriracha Chicken Whole Wheat Pita 19460 | 44 44 | 750 | 800 | 2024-06-28 |
| 19461 | Blueberry Acai Yogurt Parfait 19461 | 44 44 | 650 | 700 | 2024-06-28 |
| 19462 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 19462 | 44 44 | 650 | 700 | 2024-06-28 |
| 19463 | Caramel Frappuccino® 19463 | 44 44 | 720 | 770 | 2024-06-28 |
| 19464 | Dark Mocha Frappuccino® 19464 | 44 44 | 780 | 830 | 2024-06-28 |
| 19465 | Java Chip Frappuccino® 19465 | 44 44 | 780 | 830 | 2024-06-28 |
| 19466 | Mocha Frappuccino® 19466 | 44 44 | 720 | 770 | 2024-06-28 |
| 19467 | Caramel Macchiato Frappuccino® 19467 | 44 44 | 780 | 830 | 2024-06-28 |
| 19468 | Espresso Frappuccino® 19468 | 44 44 | 720 | 770 | 2024-06-28 |
| 19469 | White Chocolate Mocha Frappuccino® 19469 | 44 44 | 720 | 770 | 2024-06-28 |
| 19470 | Chocolate Chip Cream Frappuccino® 19470 | 44 44 | 780 | 830 | 2024-06-28 |
| 19471 | Hojicha Tea Cream Frappuccino® 19471 | 44 44 | 760 | 810 | 2024-06-28 |
| 19472 | Vanilla Cream Frappuccino® 19472 | 44 44 | 720 | 770 | 2024-06-28 |
| 19473 | Mango Passion Fruit & Hibiscus 19473 | 44 44 | 720 | 770 | 2024-06-28 |
| 19474 | Raspberry Black Currant & Oolong 19474 | 44 44 | 720 | 770 | 2024-06-28 |
| 19475 | Coffee Traveller 19475 | 44 44 | 3120 | 3170 | 2024-06-28 |
| 19476 | Caffè Americano 19476 | 44 44 | 540 | 590 | 2024-06-28 |
| 19477 | Cappuccino 19477 | 44 44 | 680 | 730 | 2024-06-28 |
| 19478 | Caffè Mocha 19478 | 44 44 | 750 | 800 | 2024-06-28 |
| 19479 | Caramel Macchiato 19479 | 44 44 | 760 | 810 | 2024-06-28 |
| 19480 | Espresso 19480 | 44 44 | 390 | 440 | 2024-06-28 |
| 19481 | Caffè Latte 19481 | 44 44 | 680 | 730 | 2024-06-28 |
| 19482 | Oatmilk Latte 19482 | 44 44 | 760 | 810 | 2024-06-28 |
| 19483 | Vanilla Latte 19483 | 44 44 | 750 | 800 | 2024-06-28 |
| 19484 | White Chocolate Mocha 19484 | 44 44 | 750 | 800 | 2024-06-28 |
| 19485 | Flat White 19485 | 44 44 | 760 | 810 | 2024-06-28 |
| 19486 | Ristretto Bianco 19486 | 44 44 | 760 | 810 | 2024-06-28 |
| 19487 | Iced Caffè Americano 19487 | 44 44 | 540 | 590 | 2024-06-28 |
| 19488 | Iced Cappuccino 19488 | 44 44 | 680 | 730 | 2024-06-28 |
| 19489 | Iced Caffè Mocha 19489 | 44 44 | 750 | 800 | 2024-06-28 |
| 19490 | Iced Caramel Macchiato 19490 | 44 44 | 760 | 810 | 2024-06-28 |
| 19491 | Iced Caffè Latte 19491 | 44 44 | 680 | 730 | 2024-06-28 |
| 19492 | Iced Oatmilk Latte 19492 | 44 44 | 760 | 810 | 2024-06-28 |
| 19493 | Iced Vanilla Latte 19493 | 44 44 | 750 | 800 | 2024-06-28 |
| 19494 | Iced White Chocolate Mocha 19494 | 44 44 | 750 | 800 | 2024-06-28 |
| 19495 | Signature Hot Chocolate 19495 | 44 44 | 720 | 770 | 2024-06-28 |
| 19496 | Signature Iced Chocolate 19496 | 44 44 | 720 | 770 | 2024-06-28 |
| 19497 | Carrot Juice 19497 | 44 44 | 490 | 540 | 2024-06-28 |
| 19498 | Cloudy Apple Juice 19498 | 44 44 | 490 | 540 | 2024-06-28 |
| 19499 | Cranberry Red Grapefruit Juice 19499 | 44 44 | 490 | 540 | 2024-06-28 |
| 19500 | Orange Juice 19500 | 44 44 | 490 | 540 | 2024-06-28 |
| 19501 | Evian 19501 | 44 44 | 350 | 400 | 2024-06-28 |
| 19502 | Sparkling Water 19502 | 44 44 | 450 | 500 | 2024-06-28 |
| 19503 | Chai Tea 19503 | 44 44 | 500 | 550 | 2024-06-28 |
| 19504 | Earl Grey Tea 19504 | 44 44 | 500 | 550 | 2024-06-28 |
| 19505 | English Breakfast Tea 19505 | 44 44 | 500 | 550 | 2024-06-28 |
| 19506 | Emperor’s Clouds & Mist™ Tea 19506 | 44 44 | 500 | 550 | 2024-06-28 |
| 19507 | Mint Blend Tea 19507 | 44 44 | 500 | 550 | 2024-06-28 |
| 19508 | Chamomile Tea 19508 | 44 44 | 500 | 550 | 2024-06-28 |
| 19509 | Pure Matcha Latte 19509 | 44 44 | 740 | 790 | 2024-06-28 |
| 19510 | Chai Tea Latte 19510 | 44 44 | 680 | 730 | 2024-06-28 |
| 19511 | Earl Grey Tea Latte 19511 | 44 44 | 680 | 730 | 2024-06-28 |
| 19512 | English Breakfast Tea Latte 19512 | 44 44 | 680 | 730 | 2024-06-28 |
| 19513 | Hojicha Tea Latte 19513 | 44 44 | 740 | 790 | 2024-06-28 |
| 19514 | Zen Clouds Oolong Tea 19514 | 44 44 | 500 | 550 | 2024-06-28 |
| 19515 | Zen Clouds Oolong with Ruby Grapefruit and Honey 19515 | 44 44 | 630 | 680 | 2024-06-28 |
| 19516 | Youthberry™ Tea 19516 | 44 44 | 500 | 550 | 2024-06-28 |
| 19517 | Iced Shaken Black Tea Lemonade 19517 | 44 44 | 610 | 660 | 2024-06-28 |
| 19518 | Iced Shaken Strawberry Black Tea Lemonade 19518 | 44 44 | 630 | 680 | 2024-06-28 |
| 19519 | Iced Shaken Hibiscus Tea Lemonade 19519 | 44 44 | 610 | 660 | 2024-06-28 |
| 19520 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 19520 | 44 44 | 730 | 780 | 2024-06-28 |
| 19521 | Iced Pure Matcha Latte 19521 | 44 44 | 740 | 790 | 2024-06-28 |
| 19522 | Iced Chai Tea Latte 19522 | 44 44 | 680 | 730 | 2024-06-28 |
| 19523 | Iced Black Tea Latte 19523 | 44 44 | 680 | 730 | 2024-06-28 |
| 19524 | Iced Hojicha Tea Latte 19524 | 44 44 | 740 | 790 | 2024-06-28 |
| 19525 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 19525 | 44 44 | 630 | 680 | 2024-06-28 |
| 19526 | Iced Shaken Zen Clouds Oolong Lemonade 19526 | 44 44 | 610 | 660 | 2024-06-28 |
| 19527 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 19527 | 44 44 | 630 | 680 | 2024-06-28 |
| 19528 | Origami Pike Place® Roast 19528 | 44 44 | 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");