item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
249 rows where store_id = 104
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
- 104 · 249 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 9714 | Bagel 9714 | 104 104 | 400 | 430 | 2024-06-28 |
| 9715 | Cookie Crumble Cheesecake 9715 | 104 104 | 720 | 770 | 2024-06-28 |
| 9716 | Good Ol' NY Cheesecake 9716 | 104 104 | 720 | 770 | 2024-06-28 |
| 9717 | Signature Chocolate Cake 9717 | 104 104 | 720 | 770 | 2024-06-28 |
| 9718 | Starbucks® Coffee Tiramisu Cake 9718 | 104 104 | 750 | 800 | 2024-06-28 |
| 9719 | Strawberry Shortcake 9719 | 104 104 | 720 | 770 | 2024-06-28 |
| 9720 | Chocolate Chunk Monster Cookie 9720 | 104 104 | 390 | 440 | 2024-06-28 |
| 9721 | Banana Walnut Muffin 9721 | 104 104 | 450 | 500 | 2024-06-28 |
| 9722 | Blueberry Crumble Muffin 9722 | 104 104 | 450 | 500 | 2024-06-28 |
| 9723 | Chocolate Crumble Muffin 9723 | 104 104 | 450 | 500 | 2024-06-28 |
| 9724 | Pancakes 9724 | 104 104 | 550 | 600 | 2024-06-28 |
| 9725 | Almond Croissant 9725 | 104 104 | 470 | 520 | 2024-06-28 |
| 9726 | Buttery Croissant 9726 | 104 104 | 400 | 430 | 2024-06-28 |
| 9727 | Chocolate Croissant 9727 | 104 104 | 440 | 490 | 2024-06-28 |
| 9728 | Creamy Chicken Foldover 9728 | 104 104 | 550 | 600 | 2024-06-28 |
| 9729 | Sausage Roll 9729 | 104 104 | 550 | 600 | 2024-06-28 |
| 9730 | Buttery Scone 9730 | 104 104 | 400 | 430 | 2024-06-28 |
| 9731 | Country Chicken Pie 9731 | 104 104 | 690 | 740 | 2024-06-28 |
| 9732 | Deep Dish Beef Pie 9732 | 104 104 | 690 | 740 | 2024-06-28 |
| 9733 | Spinach & Mushroom Quiche 9733 | 104 104 | 690 | 740 | 2024-06-28 |
| 9734 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 9734 | 104 104 | 390 | 420 | 2024-06-28 |
| 9735 | Mixed Nuts 9735 | 104 104 | 490 | 540 | 2024-06-28 |
| 9736 | Caramel Waffles 9736 | 104 104 | 390 | 420 | 2024-06-28 |
| 9737 | Chicken Ham & Cheese Panwich 9737 | 104 104 | 690 | 740 | 2024-06-28 |
| 9738 | Egg Mayo & Cheese Multigrain Croissant 9738 | 104 104 | 690 | 740 | 2024-06-28 |
| 9739 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 9739 | 104 104 | 690 | 740 | 2024-06-28 |
| 9740 | Rosemary Chicken & Emmental Cheese Croissant 9740 | 104 104 | 690 | 740 | 2024-06-28 |
| 9741 | Scrambled Egg & Turkey Ham Pita 9741 | 104 104 | 690 | 740 | 2024-06-28 |
| 9742 | Turkey Ham & Triple Cheese Toast 9742 | 104 104 | 690 | 740 | 2024-06-28 |
| 9743 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 9743 | 104 104 | 790 | 840 | 2024-06-28 |
| 9744 | Ham & Cheese Croissant 9744 | 104 104 | 690 | 740 | 2024-06-28 |
| 9745 | Sriracha Chicken Whole Wheat Pita 9745 | 104 104 | 750 | 800 | 2024-06-28 |
| 9746 | Blueberry Acai Yogurt Parfait 9746 | 104 104 | 650 | 700 | 2024-06-28 |
| 9747 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 9747 | 104 104 | 650 | 700 | 2024-06-28 |
| 9748 | Caramel Frappuccino® 9748 | 104 104 | 720 | 770 | 2024-06-28 |
| 9749 | Dark Mocha Frappuccino® 9749 | 104 104 | 780 | 830 | 2024-06-28 |
| 9750 | Java Chip Frappuccino® 9750 | 104 104 | 780 | 830 | 2024-06-28 |
| 9751 | Mocha Frappuccino® 9751 | 104 104 | 720 | 770 | 2024-06-28 |
| 9752 | Caramel Macchiato Frappuccino® 9752 | 104 104 | 780 | 830 | 2024-06-28 |
| 9753 | Espresso Frappuccino® 9753 | 104 104 | 720 | 770 | 2024-06-28 |
| 9754 | White Chocolate Mocha Frappuccino® 9754 | 104 104 | 720 | 770 | 2024-06-28 |
| 9755 | Chocolate Chip Cream Frappuccino® 9755 | 104 104 | 780 | 830 | 2024-06-28 |
| 9756 | Hojicha Tea Cream Frappuccino® 9756 | 104 104 | 760 | 810 | 2024-06-28 |
| 9757 | Vanilla Cream Frappuccino® 9757 | 104 104 | 720 | 770 | 2024-06-28 |
| 9758 | Mango Passion Fruit & Hibiscus 9758 | 104 104 | 720 | 770 | 2024-06-28 |
| 9759 | Raspberry Black Currant & Oolong 9759 | 104 104 | 720 | 770 | 2024-06-28 |
| 9760 | Coffee Traveller 9760 | 104 104 | 3120 | 3170 | 2024-06-28 |
| 9761 | Caffè Americano 9761 | 104 104 | 540 | 590 | 2024-06-28 |
| 9762 | Cappuccino 9762 | 104 104 | 680 | 730 | 2024-06-28 |
| 9763 | Caffè Mocha 9763 | 104 104 | 750 | 800 | 2024-06-28 |
| 9764 | Caramel Macchiato 9764 | 104 104 | 760 | 810 | 2024-06-28 |
| 9765 | Espresso 9765 | 104 104 | 390 | 440 | 2024-06-28 |
| 9766 | Caffè Latte 9766 | 104 104 | 680 | 730 | 2024-06-28 |
| 9767 | Oatmilk Latte 9767 | 104 104 | 760 | 810 | 2024-06-28 |
| 9768 | Vanilla Latte 9768 | 104 104 | 750 | 800 | 2024-06-28 |
| 9769 | White Chocolate Mocha 9769 | 104 104 | 750 | 800 | 2024-06-28 |
| 9770 | Flat White 9770 | 104 104 | 760 | 810 | 2024-06-28 |
| 9771 | Ristretto Bianco 9771 | 104 104 | 760 | 810 | 2024-06-28 |
| 9772 | Iced Caffè Americano 9772 | 104 104 | 540 | 590 | 2024-06-28 |
| 9773 | Iced Cappuccino 9773 | 104 104 | 680 | 730 | 2024-06-28 |
| 9774 | Iced Caffè Mocha 9774 | 104 104 | 750 | 800 | 2024-06-28 |
| 9775 | Iced Caramel Macchiato 9775 | 104 104 | 760 | 810 | 2024-06-28 |
| 9776 | Iced Caffè Latte 9776 | 104 104 | 680 | 730 | 2024-06-28 |
| 9777 | Iced Oatmilk Latte 9777 | 104 104 | 760 | 810 | 2024-06-28 |
| 9778 | Iced Vanilla Latte 9778 | 104 104 | 750 | 800 | 2024-06-28 |
| 9779 | Iced White Chocolate Mocha 9779 | 104 104 | 750 | 800 | 2024-06-28 |
| 9780 | Signature Hot Chocolate 9780 | 104 104 | 720 | 770 | 2024-06-28 |
| 9781 | Signature Iced Chocolate 9781 | 104 104 | 720 | 770 | 2024-06-28 |
| 9782 | Carrot Juice 9782 | 104 104 | 490 | 540 | 2024-06-28 |
| 9783 | Cloudy Apple Juice 9783 | 104 104 | 490 | 540 | 2024-06-28 |
| 9784 | Cranberry Red Grapefruit Juice 9784 | 104 104 | 490 | 540 | 2024-06-28 |
| 9785 | Orange Juice 9785 | 104 104 | 490 | 540 | 2024-06-28 |
| 9786 | Evian 9786 | 104 104 | 350 | 400 | 2024-06-28 |
| 9787 | Sparkling Water 9787 | 104 104 | 450 | 500 | 2024-06-28 |
| 9788 | Chai Tea 9788 | 104 104 | 500 | 550 | 2024-06-28 |
| 9789 | Earl Grey Tea 9789 | 104 104 | 500 | 550 | 2024-06-28 |
| 9790 | English Breakfast Tea 9790 | 104 104 | 500 | 550 | 2024-06-28 |
| 9791 | Emperor’s Clouds & Mist™ Tea 9791 | 104 104 | 500 | 550 | 2024-06-28 |
| 9792 | Mint Blend Tea 9792 | 104 104 | 500 | 550 | 2024-06-28 |
| 9793 | Chamomile Tea 9793 | 104 104 | 500 | 550 | 2024-06-28 |
| 9794 | Pure Matcha Latte 9794 | 104 104 | 740 | 790 | 2024-06-28 |
| 9795 | Chai Tea Latte 9795 | 104 104 | 680 | 730 | 2024-06-28 |
| 9796 | Earl Grey Tea Latte 9796 | 104 104 | 680 | 730 | 2024-06-28 |
| 9797 | English Breakfast Tea Latte 9797 | 104 104 | 680 | 730 | 2024-06-28 |
| 9798 | Hojicha Tea Latte 9798 | 104 104 | 740 | 790 | 2024-06-28 |
| 9799 | Zen Clouds Oolong Tea 9799 | 104 104 | 500 | 550 | 2024-06-28 |
| 9800 | Zen Clouds Oolong with Ruby Grapefruit and Honey 9800 | 104 104 | 630 | 680 | 2024-06-28 |
| 9801 | Youthberry™ Tea 9801 | 104 104 | 500 | 550 | 2024-06-28 |
| 9802 | Iced Shaken Black Tea Lemonade 9802 | 104 104 | 610 | 660 | 2024-06-28 |
| 9803 | Iced Shaken Strawberry Black Tea Lemonade 9803 | 104 104 | 630 | 680 | 2024-06-28 |
| 9804 | Iced Shaken Hibiscus Tea Lemonade 9804 | 104 104 | 610 | 660 | 2024-06-28 |
| 9805 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 9805 | 104 104 | 730 | 780 | 2024-06-28 |
| 9806 | Iced Pure Matcha Latte 9806 | 104 104 | 740 | 790 | 2024-06-28 |
| 9807 | Iced Chai Tea Latte 9807 | 104 104 | 680 | 730 | 2024-06-28 |
| 9808 | Iced Black Tea Latte 9808 | 104 104 | 680 | 730 | 2024-06-28 |
| 9809 | Iced Hojicha Tea Latte 9809 | 104 104 | 740 | 790 | 2024-06-28 |
| 9810 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 9810 | 104 104 | 630 | 680 | 2024-06-28 |
| 9811 | Iced Shaken Zen Clouds Oolong Lemonade 9811 | 104 104 | 610 | 660 | 2024-06-28 |
| 9812 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 9812 | 104 104 | 630 | 680 | 2024-06-28 |
| 9813 | Origami Pike Place® Roast 9813 | 104 104 | 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");