item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
249 rows where store_id = 129
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
- 129 · 249 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 5706 | Bagel 5706 | 129 129 | 400 | 430 | 2024-06-28 |
| 5707 | Cookie Crumble Cheesecake 5707 | 129 129 | 720 | 770 | 2024-06-28 |
| 5708 | Good Ol' NY Cheesecake 5708 | 129 129 | 720 | 770 | 2024-06-28 |
| 5709 | Signature Chocolate Cake 5709 | 129 129 | 720 | 770 | 2024-06-28 |
| 5710 | Starbucks® Coffee Tiramisu Cake 5710 | 129 129 | 750 | 800 | 2024-06-28 |
| 5711 | Strawberry Shortcake 5711 | 129 129 | 720 | 770 | 2024-06-28 |
| 5712 | Chocolate Chunk Monster Cookie 5712 | 129 129 | 390 | 440 | 2024-06-28 |
| 5713 | Banana Walnut Muffin 5713 | 129 129 | 450 | 500 | 2024-06-28 |
| 5714 | Blueberry Crumble Muffin 5714 | 129 129 | 450 | 500 | 2024-06-28 |
| 5715 | Chocolate Crumble Muffin 5715 | 129 129 | 450 | 500 | 2024-06-28 |
| 5716 | Pancakes 5716 | 129 129 | 550 | 600 | 2024-06-28 |
| 5717 | Almond Croissant 5717 | 129 129 | 470 | 520 | 2024-06-28 |
| 5718 | Buttery Croissant 5718 | 129 129 | 400 | 430 | 2024-06-28 |
| 5719 | Chocolate Croissant 5719 | 129 129 | 440 | 490 | 2024-06-28 |
| 5720 | Creamy Chicken Foldover 5720 | 129 129 | 550 | 600 | 2024-06-28 |
| 5721 | Sausage Roll 5721 | 129 129 | 550 | 600 | 2024-06-28 |
| 5722 | Buttery Scone 5722 | 129 129 | 400 | 430 | 2024-06-28 |
| 5723 | Country Chicken Pie 5723 | 129 129 | 690 | 740 | 2024-06-28 |
| 5724 | Deep Dish Beef Pie 5724 | 129 129 | 690 | 740 | 2024-06-28 |
| 5725 | Spinach & Mushroom Quiche 5725 | 129 129 | 690 | 740 | 2024-06-28 |
| 5726 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 5726 | 129 129 | 390 | 420 | 2024-06-28 |
| 5727 | Mixed Nuts 5727 | 129 129 | 490 | 540 | 2024-06-28 |
| 5728 | Caramel Waffles 5728 | 129 129 | 390 | 420 | 2024-06-28 |
| 5729 | Chicken Ham & Cheese Panwich 5729 | 129 129 | 690 | 740 | 2024-06-28 |
| 5730 | Egg Mayo & Cheese Multigrain Croissant 5730 | 129 129 | 690 | 740 | 2024-06-28 |
| 5731 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 5731 | 129 129 | 690 | 740 | 2024-06-28 |
| 5732 | Rosemary Chicken & Emmental Cheese Croissant 5732 | 129 129 | 690 | 740 | 2024-06-28 |
| 5733 | Scrambled Egg & Turkey Ham Pita 5733 | 129 129 | 690 | 740 | 2024-06-28 |
| 5734 | Turkey Ham & Triple Cheese Toast 5734 | 129 129 | 690 | 740 | 2024-06-28 |
| 5735 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 5735 | 129 129 | 790 | 840 | 2024-06-28 |
| 5736 | Ham & Cheese Croissant 5736 | 129 129 | 690 | 740 | 2024-06-28 |
| 5737 | Sriracha Chicken Whole Wheat Pita 5737 | 129 129 | 750 | 800 | 2024-06-28 |
| 5738 | Blueberry Acai Yogurt Parfait 5738 | 129 129 | 650 | 700 | 2024-06-28 |
| 5739 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 5739 | 129 129 | 650 | 700 | 2024-06-28 |
| 5740 | Caramel Frappuccino® 5740 | 129 129 | 720 | 770 | 2024-06-28 |
| 5741 | Dark Mocha Frappuccino® 5741 | 129 129 | 780 | 830 | 2024-06-28 |
| 5742 | Java Chip Frappuccino® 5742 | 129 129 | 780 | 830 | 2024-06-28 |
| 5743 | Mocha Frappuccino® 5743 | 129 129 | 720 | 770 | 2024-06-28 |
| 5744 | Caramel Macchiato Frappuccino® 5744 | 129 129 | 780 | 830 | 2024-06-28 |
| 5745 | Espresso Frappuccino® 5745 | 129 129 | 720 | 770 | 2024-06-28 |
| 5746 | White Chocolate Mocha Frappuccino® 5746 | 129 129 | 720 | 770 | 2024-06-28 |
| 5747 | Chocolate Chip Cream Frappuccino® 5747 | 129 129 | 780 | 830 | 2024-06-28 |
| 5748 | Hojicha Tea Cream Frappuccino® 5748 | 129 129 | 760 | 810 | 2024-06-28 |
| 5749 | Vanilla Cream Frappuccino® 5749 | 129 129 | 720 | 770 | 2024-06-28 |
| 5750 | Mango Passion Fruit & Hibiscus 5750 | 129 129 | 720 | 770 | 2024-06-28 |
| 5751 | Raspberry Black Currant & Oolong 5751 | 129 129 | 720 | 770 | 2024-06-28 |
| 5752 | Coffee Traveller 5752 | 129 129 | 3120 | 3170 | 2024-06-28 |
| 5753 | Caffè Americano 5753 | 129 129 | 540 | 590 | 2024-06-28 |
| 5754 | Cappuccino 5754 | 129 129 | 680 | 730 | 2024-06-28 |
| 5755 | Caffè Mocha 5755 | 129 129 | 750 | 800 | 2024-06-28 |
| 5756 | Caramel Macchiato 5756 | 129 129 | 760 | 810 | 2024-06-28 |
| 5757 | Espresso 5757 | 129 129 | 390 | 440 | 2024-06-28 |
| 5758 | Caffè Latte 5758 | 129 129 | 680 | 730 | 2024-06-28 |
| 5759 | Oatmilk Latte 5759 | 129 129 | 760 | 810 | 2024-06-28 |
| 5760 | Vanilla Latte 5760 | 129 129 | 750 | 800 | 2024-06-28 |
| 5761 | White Chocolate Mocha 5761 | 129 129 | 750 | 800 | 2024-06-28 |
| 5762 | Flat White 5762 | 129 129 | 760 | 810 | 2024-06-28 |
| 5763 | Ristretto Bianco 5763 | 129 129 | 760 | 810 | 2024-06-28 |
| 5764 | Iced Caffè Americano 5764 | 129 129 | 540 | 590 | 2024-06-28 |
| 5765 | Iced Cappuccino 5765 | 129 129 | 680 | 730 | 2024-06-28 |
| 5766 | Iced Caffè Mocha 5766 | 129 129 | 750 | 800 | 2024-06-28 |
| 5767 | Iced Caramel Macchiato 5767 | 129 129 | 760 | 810 | 2024-06-28 |
| 5768 | Iced Caffè Latte 5768 | 129 129 | 680 | 730 | 2024-06-28 |
| 5769 | Iced Oatmilk Latte 5769 | 129 129 | 760 | 810 | 2024-06-28 |
| 5770 | Iced Vanilla Latte 5770 | 129 129 | 750 | 800 | 2024-06-28 |
| 5771 | Iced White Chocolate Mocha 5771 | 129 129 | 750 | 800 | 2024-06-28 |
| 5772 | Signature Hot Chocolate 5772 | 129 129 | 720 | 770 | 2024-06-28 |
| 5773 | Signature Iced Chocolate 5773 | 129 129 | 720 | 770 | 2024-06-28 |
| 5774 | Carrot Juice 5774 | 129 129 | 490 | 540 | 2024-06-28 |
| 5775 | Cloudy Apple Juice 5775 | 129 129 | 490 | 540 | 2024-06-28 |
| 5776 | Cranberry Red Grapefruit Juice 5776 | 129 129 | 490 | 540 | 2024-06-28 |
| 5777 | Orange Juice 5777 | 129 129 | 490 | 540 | 2024-06-28 |
| 5778 | Evian 5778 | 129 129 | 350 | 400 | 2024-06-28 |
| 5779 | Sparkling Water 5779 | 129 129 | 450 | 500 | 2024-06-28 |
| 5780 | Chai Tea 5780 | 129 129 | 500 | 550 | 2024-06-28 |
| 5781 | Earl Grey Tea 5781 | 129 129 | 500 | 550 | 2024-06-28 |
| 5782 | English Breakfast Tea 5782 | 129 129 | 500 | 550 | 2024-06-28 |
| 5783 | Emperor’s Clouds & Mist™ Tea 5783 | 129 129 | 500 | 550 | 2024-06-28 |
| 5784 | Mint Blend Tea 5784 | 129 129 | 500 | 550 | 2024-06-28 |
| 5785 | Chamomile Tea 5785 | 129 129 | 500 | 550 | 2024-06-28 |
| 5786 | Pure Matcha Latte 5786 | 129 129 | 740 | 790 | 2024-06-28 |
| 5787 | Chai Tea Latte 5787 | 129 129 | 680 | 730 | 2024-06-28 |
| 5788 | Earl Grey Tea Latte 5788 | 129 129 | 680 | 730 | 2024-06-28 |
| 5789 | English Breakfast Tea Latte 5789 | 129 129 | 680 | 730 | 2024-06-28 |
| 5790 | Hojicha Tea Latte 5790 | 129 129 | 740 | 790 | 2024-06-28 |
| 5791 | Zen Clouds Oolong Tea 5791 | 129 129 | 500 | 550 | 2024-06-28 |
| 5792 | Zen Clouds Oolong with Ruby Grapefruit and Honey 5792 | 129 129 | 630 | 680 | 2024-06-28 |
| 5793 | Youthberry™ Tea 5793 | 129 129 | 500 | 550 | 2024-06-28 |
| 5794 | Iced Shaken Black Tea Lemonade 5794 | 129 129 | 610 | 660 | 2024-06-28 |
| 5795 | Iced Shaken Strawberry Black Tea Lemonade 5795 | 129 129 | 630 | 680 | 2024-06-28 |
| 5796 | Iced Shaken Hibiscus Tea Lemonade 5796 | 129 129 | 610 | 660 | 2024-06-28 |
| 5797 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 5797 | 129 129 | 730 | 780 | 2024-06-28 |
| 5798 | Iced Pure Matcha Latte 5798 | 129 129 | 740 | 790 | 2024-06-28 |
| 5799 | Iced Chai Tea Latte 5799 | 129 129 | 680 | 730 | 2024-06-28 |
| 5800 | Iced Black Tea Latte 5800 | 129 129 | 680 | 730 | 2024-06-28 |
| 5801 | Iced Hojicha Tea Latte 5801 | 129 129 | 740 | 790 | 2024-06-28 |
| 5802 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 5802 | 129 129 | 630 | 680 | 2024-06-28 |
| 5803 | Iced Shaken Zen Clouds Oolong Lemonade 5803 | 129 129 | 610 | 660 | 2024-06-28 |
| 5804 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 5804 | 129 129 | 630 | 680 | 2024-06-28 |
| 5805 | Origami Pike Place® Roast 5805 | 129 129 | 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");