item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
238 rows where store_id = 79
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 11
- 2024-06-28 184
- 2024-09-15 10
- 2024-11-03 9
- 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
- 79 · 238 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 13750 | Bagel 13750 | 79 79 | 400 | 430 | 2024-06-28 |
| 13751 | Cookie Crumble Cheesecake 13751 | 79 79 | 720 | 770 | 2024-06-28 |
| 13752 | Good Ol' NY Cheesecake 13752 | 79 79 | 720 | 770 | 2024-06-28 |
| 13753 | Signature Chocolate Cake 13753 | 79 79 | 720 | 770 | 2024-06-28 |
| 13754 | Starbucks® Coffee Tiramisu Cake 13754 | 79 79 | 750 | 800 | 2024-06-28 |
| 13755 | Strawberry Shortcake 13755 | 79 79 | 720 | 770 | 2024-06-28 |
| 13756 | Chocolate Chunk Monster Cookie 13756 | 79 79 | 390 | 440 | 2024-06-28 |
| 13757 | Banana Walnut Muffin 13757 | 79 79 | 450 | 500 | 2024-06-28 |
| 13758 | Blueberry Crumble Muffin 13758 | 79 79 | 450 | 500 | 2024-06-28 |
| 13759 | Chocolate Crumble Muffin 13759 | 79 79 | 450 | 500 | 2024-06-28 |
| 13760 | Pancakes 13760 | 79 79 | 550 | 600 | 2024-06-28 |
| 13761 | Almond Croissant 13761 | 79 79 | 470 | 520 | 2024-06-28 |
| 13762 | Buttery Croissant 13762 | 79 79 | 400 | 430 | 2024-06-28 |
| 13763 | Chocolate Croissant 13763 | 79 79 | 440 | 490 | 2024-06-28 |
| 13764 | Creamy Chicken Foldover 13764 | 79 79 | 550 | 600 | 2024-06-28 |
| 13765 | Sausage Roll 13765 | 79 79 | 550 | 600 | 2024-06-28 |
| 13766 | Buttery Scone 13766 | 79 79 | 400 | 430 | 2024-06-28 |
| 13767 | Country Chicken Pie 13767 | 79 79 | 690 | 740 | 2024-06-28 |
| 13768 | Deep Dish Beef Pie 13768 | 79 79 | 690 | 740 | 2024-06-28 |
| 13769 | Spinach & Mushroom Quiche 13769 | 79 79 | 690 | 740 | 2024-06-28 |
| 13770 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 13770 | 79 79 | 390 | 420 | 2024-06-28 |
| 13771 | Mixed Nuts 13771 | 79 79 | 490 | 540 | 2024-06-28 |
| 13772 | Caramel Waffles 13772 | 79 79 | 390 | 420 | 2024-06-28 |
| 13773 | Chicken Ham & Cheese Panwich 13773 | 79 79 | 690 | 740 | 2024-06-28 |
| 13774 | Egg Mayo & Cheese Multigrain Croissant 13774 | 79 79 | 690 | 740 | 2024-06-28 |
| 13775 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 13775 | 79 79 | 690 | 740 | 2024-06-28 |
| 13776 | Rosemary Chicken & Emmental Cheese Croissant 13776 | 79 79 | 690 | 740 | 2024-06-28 |
| 13777 | Scrambled Egg & Turkey Ham Pita 13777 | 79 79 | 690 | 740 | 2024-06-28 |
| 13778 | Turkey Ham & Triple Cheese Toast 13778 | 79 79 | 690 | 740 | 2024-06-28 |
| 13779 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 13779 | 79 79 | 790 | 840 | 2024-06-28 |
| 13780 | Ham & Cheese Croissant 13780 | 79 79 | 690 | 740 | 2024-06-28 |
| 13781 | Sriracha Chicken Whole Wheat Pita 13781 | 79 79 | 750 | 800 | 2024-06-28 |
| 13782 | Blueberry Acai Yogurt Parfait 13782 | 79 79 | 650 | 700 | 2024-06-28 |
| 13783 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 13783 | 79 79 | 650 | 700 | 2024-06-28 |
| 13784 | Caramel Frappuccino® 13784 | 79 79 | 720 | 770 | 2024-06-28 |
| 13785 | Dark Mocha Frappuccino® 13785 | 79 79 | 780 | 830 | 2024-06-28 |
| 13786 | Java Chip Frappuccino® 13786 | 79 79 | 780 | 830 | 2024-06-28 |
| 13787 | Mocha Frappuccino® 13787 | 79 79 | 720 | 770 | 2024-06-28 |
| 13788 | Caramel Macchiato Frappuccino® 13788 | 79 79 | 780 | 830 | 2024-06-28 |
| 13789 | Espresso Frappuccino® 13789 | 79 79 | 720 | 770 | 2024-06-28 |
| 13790 | White Chocolate Mocha Frappuccino® 13790 | 79 79 | 720 | 770 | 2024-06-28 |
| 13791 | Chocolate Chip Cream Frappuccino® 13791 | 79 79 | 780 | 830 | 2024-06-28 |
| 13792 | Hojicha Tea Cream Frappuccino® 13792 | 79 79 | 760 | 810 | 2024-06-28 |
| 13793 | Vanilla Cream Frappuccino® 13793 | 79 79 | 720 | 770 | 2024-06-28 |
| 13794 | Mango Passion Fruit & Hibiscus 13794 | 79 79 | 720 | 770 | 2024-06-28 |
| 13795 | Raspberry Black Currant & Oolong 13795 | 79 79 | 720 | 770 | 2024-06-28 |
| 13796 | Coffee Traveller 13796 | 79 79 | 3120 | 3170 | 2024-06-28 |
| 13797 | Caffè Americano 13797 | 79 79 | 540 | 590 | 2024-06-28 |
| 13798 | Cappuccino 13798 | 79 79 | 680 | 730 | 2024-06-28 |
| 13799 | Caffè Mocha 13799 | 79 79 | 750 | 800 | 2024-06-28 |
| 13800 | Caramel Macchiato 13800 | 79 79 | 760 | 810 | 2024-06-28 |
| 13801 | Espresso 13801 | 79 79 | 390 | 440 | 2024-06-28 |
| 13802 | Caffè Latte 13802 | 79 79 | 680 | 730 | 2024-06-28 |
| 13803 | Oatmilk Latte 13803 | 79 79 | 760 | 810 | 2024-06-28 |
| 13804 | Vanilla Latte 13804 | 79 79 | 750 | 800 | 2024-06-28 |
| 13805 | White Chocolate Mocha 13805 | 79 79 | 750 | 800 | 2024-06-28 |
| 13806 | Flat White 13806 | 79 79 | 760 | 810 | 2024-06-28 |
| 13807 | Ristretto Bianco 13807 | 79 79 | 760 | 810 | 2024-06-28 |
| 13808 | Iced Caffè Americano 13808 | 79 79 | 540 | 590 | 2024-06-28 |
| 13809 | Iced Cappuccino 13809 | 79 79 | 680 | 730 | 2024-06-28 |
| 13810 | Iced Caffè Mocha 13810 | 79 79 | 750 | 800 | 2024-06-28 |
| 13811 | Iced Caramel Macchiato 13811 | 79 79 | 760 | 810 | 2024-06-28 |
| 13812 | Iced Caffè Latte 13812 | 79 79 | 680 | 730 | 2024-06-28 |
| 13813 | Iced Oatmilk Latte 13813 | 79 79 | 760 | 810 | 2024-06-28 |
| 13814 | Iced Vanilla Latte 13814 | 79 79 | 750 | 800 | 2024-06-28 |
| 13815 | Iced White Chocolate Mocha 13815 | 79 79 | 750 | 800 | 2024-06-28 |
| 13816 | Signature Hot Chocolate 13816 | 79 79 | 720 | 770 | 2024-06-28 |
| 13817 | Signature Iced Chocolate 13817 | 79 79 | 720 | 770 | 2024-06-28 |
| 13818 | Carrot Juice 13818 | 79 79 | 490 | 540 | 2024-06-28 |
| 13819 | Cloudy Apple Juice 13819 | 79 79 | 490 | 540 | 2024-06-28 |
| 13820 | Cranberry Red Grapefruit Juice 13820 | 79 79 | 490 | 540 | 2024-06-28 |
| 13821 | Orange Juice 13821 | 79 79 | 490 | 540 | 2024-06-28 |
| 13822 | Evian 13822 | 79 79 | 350 | 400 | 2024-06-28 |
| 13823 | Sparkling Water 13823 | 79 79 | 450 | 500 | 2024-06-28 |
| 13824 | Chai Tea 13824 | 79 79 | 500 | 550 | 2024-06-28 |
| 13825 | Earl Grey Tea 13825 | 79 79 | 500 | 550 | 2024-06-28 |
| 13826 | English Breakfast Tea 13826 | 79 79 | 500 | 550 | 2024-06-28 |
| 13827 | Emperor’s Clouds & Mist™ Tea 13827 | 79 79 | 500 | 550 | 2024-06-28 |
| 13828 | Mint Blend Tea 13828 | 79 79 | 500 | 550 | 2024-06-28 |
| 13829 | Chamomile Tea 13829 | 79 79 | 500 | 550 | 2024-06-28 |
| 13830 | Pure Matcha Latte 13830 | 79 79 | 740 | 790 | 2024-06-28 |
| 13831 | Chai Tea Latte 13831 | 79 79 | 680 | 730 | 2024-06-28 |
| 13832 | Earl Grey Tea Latte 13832 | 79 79 | 680 | 730 | 2024-06-28 |
| 13833 | English Breakfast Tea Latte 13833 | 79 79 | 680 | 730 | 2024-06-28 |
| 13834 | Hojicha Tea Latte 13834 | 79 79 | 740 | 790 | 2024-06-28 |
| 13835 | Zen Clouds Oolong Tea 13835 | 79 79 | 500 | 550 | 2024-06-28 |
| 13836 | Zen Clouds Oolong with Ruby Grapefruit and Honey 13836 | 79 79 | 630 | 680 | 2024-06-28 |
| 13837 | Youthberry™ Tea 13837 | 79 79 | 500 | 550 | 2024-06-28 |
| 13838 | Iced Shaken Black Tea Lemonade 13838 | 79 79 | 610 | 660 | 2024-06-28 |
| 13839 | Iced Shaken Strawberry Black Tea Lemonade 13839 | 79 79 | 630 | 680 | 2024-06-28 |
| 13840 | Iced Shaken Hibiscus Tea Lemonade 13840 | 79 79 | 610 | 660 | 2024-06-28 |
| 13841 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 13841 | 79 79 | 730 | 780 | 2024-06-28 |
| 13842 | Iced Pure Matcha Latte 13842 | 79 79 | 740 | 790 | 2024-06-28 |
| 13843 | Iced Chai Tea Latte 13843 | 79 79 | 680 | 730 | 2024-06-28 |
| 13844 | Iced Black Tea Latte 13844 | 79 79 | 680 | 730 | 2024-06-28 |
| 13845 | Iced Hojicha Tea Latte 13845 | 79 79 | 740 | 790 | 2024-06-28 |
| 13846 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 13846 | 79 79 | 630 | 680 | 2024-06-28 |
| 13847 | Iced Shaken Zen Clouds Oolong Lemonade 13847 | 79 79 | 610 | 660 | 2024-06-28 |
| 13848 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 13848 | 79 79 | 630 | 680 | 2024-06-28 |
| 13849 | Origami Pike Place® Roast 13849 | 79 79 | 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");