item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
249 rows where store_id = 65
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
- 65 · 249 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 15767 | Bagel 15767 | 65 65 | 400 | 430 | 2024-06-28 |
| 15768 | Cookie Crumble Cheesecake 15768 | 65 65 | 720 | 770 | 2024-06-28 |
| 15769 | Good Ol' NY Cheesecake 15769 | 65 65 | 720 | 770 | 2024-06-28 |
| 15770 | Signature Chocolate Cake 15770 | 65 65 | 720 | 770 | 2024-06-28 |
| 15771 | Starbucks® Coffee Tiramisu Cake 15771 | 65 65 | 750 | 800 | 2024-06-28 |
| 15772 | Strawberry Shortcake 15772 | 65 65 | 720 | 770 | 2024-06-28 |
| 15773 | Chocolate Chunk Monster Cookie 15773 | 65 65 | 390 | 440 | 2024-06-28 |
| 15774 | Banana Walnut Muffin 15774 | 65 65 | 450 | 500 | 2024-06-28 |
| 15775 | Blueberry Crumble Muffin 15775 | 65 65 | 450 | 500 | 2024-06-28 |
| 15776 | Chocolate Crumble Muffin 15776 | 65 65 | 450 | 500 | 2024-06-28 |
| 15777 | Pancakes 15777 | 65 65 | 550 | 600 | 2024-06-28 |
| 15778 | Almond Croissant 15778 | 65 65 | 470 | 520 | 2024-06-28 |
| 15779 | Buttery Croissant 15779 | 65 65 | 400 | 430 | 2024-06-28 |
| 15780 | Chocolate Croissant 15780 | 65 65 | 440 | 490 | 2024-06-28 |
| 15781 | Creamy Chicken Foldover 15781 | 65 65 | 550 | 600 | 2024-06-28 |
| 15782 | Sausage Roll 15782 | 65 65 | 550 | 600 | 2024-06-28 |
| 15783 | Buttery Scone 15783 | 65 65 | 400 | 430 | 2024-06-28 |
| 15784 | Country Chicken Pie 15784 | 65 65 | 690 | 740 | 2024-06-28 |
| 15785 | Deep Dish Beef Pie 15785 | 65 65 | 690 | 740 | 2024-06-28 |
| 15786 | Spinach & Mushroom Quiche 15786 | 65 65 | 690 | 740 | 2024-06-28 |
| 15787 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 15787 | 65 65 | 390 | 420 | 2024-06-28 |
| 15788 | Mixed Nuts 15788 | 65 65 | 490 | 540 | 2024-06-28 |
| 15789 | Caramel Waffles 15789 | 65 65 | 390 | 420 | 2024-06-28 |
| 15790 | Chicken Ham & Cheese Panwich 15790 | 65 65 | 690 | 740 | 2024-06-28 |
| 15791 | Egg Mayo & Cheese Multigrain Croissant 15791 | 65 65 | 690 | 740 | 2024-06-28 |
| 15792 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 15792 | 65 65 | 690 | 740 | 2024-06-28 |
| 15793 | Rosemary Chicken & Emmental Cheese Croissant 15793 | 65 65 | 690 | 740 | 2024-06-28 |
| 15794 | Scrambled Egg & Turkey Ham Pita 15794 | 65 65 | 690 | 740 | 2024-06-28 |
| 15795 | Turkey Ham & Triple Cheese Toast 15795 | 65 65 | 690 | 740 | 2024-06-28 |
| 15796 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 15796 | 65 65 | 790 | 840 | 2024-06-28 |
| 15797 | Ham & Cheese Croissant 15797 | 65 65 | 690 | 740 | 2024-06-28 |
| 15798 | Sriracha Chicken Whole Wheat Pita 15798 | 65 65 | 750 | 800 | 2024-06-28 |
| 15799 | Blueberry Acai Yogurt Parfait 15799 | 65 65 | 650 | 700 | 2024-06-28 |
| 15800 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 15800 | 65 65 | 650 | 700 | 2024-06-28 |
| 15801 | Caramel Frappuccino® 15801 | 65 65 | 720 | 770 | 2024-06-28 |
| 15802 | Dark Mocha Frappuccino® 15802 | 65 65 | 780 | 830 | 2024-06-28 |
| 15803 | Java Chip Frappuccino® 15803 | 65 65 | 780 | 830 | 2024-06-28 |
| 15804 | Mocha Frappuccino® 15804 | 65 65 | 720 | 770 | 2024-06-28 |
| 15805 | Caramel Macchiato Frappuccino® 15805 | 65 65 | 780 | 830 | 2024-06-28 |
| 15806 | Espresso Frappuccino® 15806 | 65 65 | 720 | 770 | 2024-06-28 |
| 15807 | White Chocolate Mocha Frappuccino® 15807 | 65 65 | 720 | 770 | 2024-06-28 |
| 15808 | Chocolate Chip Cream Frappuccino® 15808 | 65 65 | 780 | 830 | 2024-06-28 |
| 15809 | Hojicha Tea Cream Frappuccino® 15809 | 65 65 | 760 | 810 | 2024-06-28 |
| 15810 | Vanilla Cream Frappuccino® 15810 | 65 65 | 720 | 770 | 2024-06-28 |
| 15811 | Mango Passion Fruit & Hibiscus 15811 | 65 65 | 720 | 770 | 2024-06-28 |
| 15812 | Raspberry Black Currant & Oolong 15812 | 65 65 | 720 | 770 | 2024-06-28 |
| 15813 | Coffee Traveller 15813 | 65 65 | 3120 | 3170 | 2024-06-28 |
| 15814 | Caffè Americano 15814 | 65 65 | 540 | 590 | 2024-06-28 |
| 15815 | Cappuccino 15815 | 65 65 | 680 | 730 | 2024-06-28 |
| 15816 | Caffè Mocha 15816 | 65 65 | 750 | 800 | 2024-06-28 |
| 15817 | Caramel Macchiato 15817 | 65 65 | 760 | 810 | 2024-06-28 |
| 15818 | Espresso 15818 | 65 65 | 390 | 440 | 2024-06-28 |
| 15819 | Caffè Latte 15819 | 65 65 | 680 | 730 | 2024-06-28 |
| 15820 | Oatmilk Latte 15820 | 65 65 | 760 | 810 | 2024-06-28 |
| 15821 | Vanilla Latte 15821 | 65 65 | 750 | 800 | 2024-06-28 |
| 15822 | White Chocolate Mocha 15822 | 65 65 | 750 | 800 | 2024-06-28 |
| 15823 | Flat White 15823 | 65 65 | 760 | 810 | 2024-06-28 |
| 15824 | Ristretto Bianco 15824 | 65 65 | 760 | 810 | 2024-06-28 |
| 15825 | Iced Caffè Americano 15825 | 65 65 | 540 | 590 | 2024-06-28 |
| 15826 | Iced Cappuccino 15826 | 65 65 | 680 | 730 | 2024-06-28 |
| 15827 | Iced Caffè Mocha 15827 | 65 65 | 750 | 800 | 2024-06-28 |
| 15828 | Iced Caramel Macchiato 15828 | 65 65 | 760 | 810 | 2024-06-28 |
| 15829 | Iced Caffè Latte 15829 | 65 65 | 680 | 730 | 2024-06-28 |
| 15830 | Iced Oatmilk Latte 15830 | 65 65 | 760 | 810 | 2024-06-28 |
| 15831 | Iced Vanilla Latte 15831 | 65 65 | 750 | 800 | 2024-06-28 |
| 15832 | Iced White Chocolate Mocha 15832 | 65 65 | 750 | 800 | 2024-06-28 |
| 15833 | Signature Hot Chocolate 15833 | 65 65 | 720 | 770 | 2024-06-28 |
| 15834 | Signature Iced Chocolate 15834 | 65 65 | 720 | 770 | 2024-06-28 |
| 15835 | Carrot Juice 15835 | 65 65 | 490 | 540 | 2024-06-28 |
| 15836 | Cloudy Apple Juice 15836 | 65 65 | 490 | 540 | 2024-06-28 |
| 15837 | Cranberry Red Grapefruit Juice 15837 | 65 65 | 490 | 540 | 2024-06-28 |
| 15838 | Orange Juice 15838 | 65 65 | 490 | 540 | 2024-06-28 |
| 15839 | Evian 15839 | 65 65 | 350 | 400 | 2024-06-28 |
| 15840 | Sparkling Water 15840 | 65 65 | 450 | 500 | 2024-06-28 |
| 15841 | Chai Tea 15841 | 65 65 | 500 | 550 | 2024-06-28 |
| 15842 | Earl Grey Tea 15842 | 65 65 | 500 | 550 | 2024-06-28 |
| 15843 | English Breakfast Tea 15843 | 65 65 | 500 | 550 | 2024-06-28 |
| 15844 | Emperor’s Clouds & Mist™ Tea 15844 | 65 65 | 500 | 550 | 2024-06-28 |
| 15845 | Mint Blend Tea 15845 | 65 65 | 500 | 550 | 2024-06-28 |
| 15846 | Chamomile Tea 15846 | 65 65 | 500 | 550 | 2024-06-28 |
| 15847 | Pure Matcha Latte 15847 | 65 65 | 740 | 790 | 2024-06-28 |
| 15848 | Chai Tea Latte 15848 | 65 65 | 680 | 730 | 2024-06-28 |
| 15849 | Earl Grey Tea Latte 15849 | 65 65 | 680 | 730 | 2024-06-28 |
| 15850 | English Breakfast Tea Latte 15850 | 65 65 | 680 | 730 | 2024-06-28 |
| 15851 | Hojicha Tea Latte 15851 | 65 65 | 740 | 790 | 2024-06-28 |
| 15852 | Zen Clouds Oolong Tea 15852 | 65 65 | 500 | 550 | 2024-06-28 |
| 15853 | Zen Clouds Oolong with Ruby Grapefruit and Honey 15853 | 65 65 | 630 | 680 | 2024-06-28 |
| 15854 | Youthberry™ Tea 15854 | 65 65 | 500 | 550 | 2024-06-28 |
| 15855 | Iced Shaken Black Tea Lemonade 15855 | 65 65 | 610 | 660 | 2024-06-28 |
| 15856 | Iced Shaken Strawberry Black Tea Lemonade 15856 | 65 65 | 630 | 680 | 2024-06-28 |
| 15857 | Iced Shaken Hibiscus Tea Lemonade 15857 | 65 65 | 610 | 660 | 2024-06-28 |
| 15858 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 15858 | 65 65 | 730 | 780 | 2024-06-28 |
| 15859 | Iced Pure Matcha Latte 15859 | 65 65 | 740 | 790 | 2024-06-28 |
| 15860 | Iced Chai Tea Latte 15860 | 65 65 | 680 | 730 | 2024-06-28 |
| 15861 | Iced Black Tea Latte 15861 | 65 65 | 680 | 730 | 2024-06-28 |
| 15862 | Iced Hojicha Tea Latte 15862 | 65 65 | 740 | 790 | 2024-06-28 |
| 15863 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 15863 | 65 65 | 630 | 680 | 2024-06-28 |
| 15864 | Iced Shaken Zen Clouds Oolong Lemonade 15864 | 65 65 | 610 | 660 | 2024-06-28 |
| 15865 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 15865 | 65 65 | 630 | 680 | 2024-06-28 |
| 15866 | Origami Pike Place® Roast 15866 | 65 65 | 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");