item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
248 rows where store_id = 29
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 12
- 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
store_id 1
- 29 · 248 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 21805 | Bagel 21805 | 29 29 | 400 | 430 | 2024-06-28 |
| 21806 | Cookie Crumble Cheesecake 21806 | 29 29 | 720 | 770 | 2024-06-28 |
| 21807 | Good Ol' NY Cheesecake 21807 | 29 29 | 720 | 770 | 2024-06-28 |
| 21808 | Signature Chocolate Cake 21808 | 29 29 | 720 | 770 | 2024-06-28 |
| 21809 | Starbucks® Coffee Tiramisu Cake 21809 | 29 29 | 750 | 800 | 2024-06-28 |
| 21810 | Strawberry Shortcake 21810 | 29 29 | 720 | 770 | 2024-06-28 |
| 21811 | Chocolate Chunk Monster Cookie 21811 | 29 29 | 390 | 440 | 2024-06-28 |
| 21812 | Banana Walnut Muffin 21812 | 29 29 | 450 | 500 | 2024-06-28 |
| 21813 | Blueberry Crumble Muffin 21813 | 29 29 | 450 | 500 | 2024-06-28 |
| 21814 | Chocolate Crumble Muffin 21814 | 29 29 | 450 | 500 | 2024-06-28 |
| 21815 | Pancakes 21815 | 29 29 | 550 | 600 | 2024-06-28 |
| 21816 | Almond Croissant 21816 | 29 29 | 470 | 520 | 2024-06-28 |
| 21817 | Buttery Croissant 21817 | 29 29 | 400 | 430 | 2024-06-28 |
| 21818 | Chocolate Croissant 21818 | 29 29 | 440 | 490 | 2024-06-28 |
| 21819 | Creamy Chicken Foldover 21819 | 29 29 | 550 | 600 | 2024-06-28 |
| 21820 | Sausage Roll 21820 | 29 29 | 550 | 600 | 2024-06-28 |
| 21821 | Buttery Scone 21821 | 29 29 | 400 | 430 | 2024-06-28 |
| 21822 | Country Chicken Pie 21822 | 29 29 | 690 | 740 | 2024-06-28 |
| 21823 | Deep Dish Beef Pie 21823 | 29 29 | 690 | 740 | 2024-06-28 |
| 21824 | Spinach & Mushroom Quiche 21824 | 29 29 | 690 | 740 | 2024-06-28 |
| 21825 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 21825 | 29 29 | 390 | 420 | 2024-06-28 |
| 21826 | Mixed Nuts 21826 | 29 29 | 490 | 540 | 2024-06-28 |
| 21827 | Caramel Waffles 21827 | 29 29 | 390 | 420 | 2024-06-28 |
| 21828 | Chicken Ham & Cheese Panwich 21828 | 29 29 | 690 | 740 | 2024-06-28 |
| 21829 | Egg Mayo & Cheese Multigrain Croissant 21829 | 29 29 | 690 | 740 | 2024-06-28 |
| 21830 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 21830 | 29 29 | 690 | 740 | 2024-06-28 |
| 21831 | Rosemary Chicken & Emmental Cheese Croissant 21831 | 29 29 | 690 | 740 | 2024-06-28 |
| 21832 | Scrambled Egg & Turkey Ham Pita 21832 | 29 29 | 690 | 740 | 2024-06-28 |
| 21833 | Turkey Ham & Triple Cheese Toast 21833 | 29 29 | 690 | 740 | 2024-06-28 |
| 21834 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 21834 | 29 29 | 790 | 840 | 2024-06-28 |
| 21835 | Ham & Cheese Croissant 21835 | 29 29 | 690 | 740 | 2024-06-28 |
| 21836 | Sriracha Chicken Whole Wheat Pita 21836 | 29 29 | 750 | 800 | 2024-06-28 |
| 21837 | Blueberry Acai Yogurt Parfait 21837 | 29 29 | 650 | 700 | 2024-06-28 |
| 21838 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 21838 | 29 29 | 650 | 700 | 2024-06-28 |
| 21839 | Caramel Frappuccino® 21839 | 29 29 | 720 | 770 | 2024-06-28 |
| 21840 | Dark Mocha Frappuccino® 21840 | 29 29 | 780 | 830 | 2024-06-28 |
| 21841 | Java Chip Frappuccino® 21841 | 29 29 | 780 | 830 | 2024-06-28 |
| 21842 | Mocha Frappuccino® 21842 | 29 29 | 720 | 770 | 2024-06-28 |
| 21843 | Caramel Macchiato Frappuccino® 21843 | 29 29 | 780 | 830 | 2024-06-28 |
| 21844 | Espresso Frappuccino® 21844 | 29 29 | 720 | 770 | 2024-06-28 |
| 21845 | White Chocolate Mocha Frappuccino® 21845 | 29 29 | 720 | 770 | 2024-06-28 |
| 21846 | Chocolate Chip Cream Frappuccino® 21846 | 29 29 | 780 | 830 | 2024-06-28 |
| 21847 | Hojicha Tea Cream Frappuccino® 21847 | 29 29 | 760 | 810 | 2024-06-28 |
| 21848 | Vanilla Cream Frappuccino® 21848 | 29 29 | 720 | 770 | 2024-06-28 |
| 21849 | Mango Passion Fruit & Hibiscus 21849 | 29 29 | 720 | 770 | 2024-06-28 |
| 21850 | Raspberry Black Currant & Oolong 21850 | 29 29 | 720 | 770 | 2024-06-28 |
| 21851 | Coffee Traveller 21851 | 29 29 | 3120 | 3170 | 2024-06-28 |
| 21852 | Caffè Americano 21852 | 29 29 | 540 | 590 | 2024-06-28 |
| 21853 | Cappuccino 21853 | 29 29 | 680 | 730 | 2024-06-28 |
| 21854 | Caffè Mocha 21854 | 29 29 | 750 | 800 | 2024-06-28 |
| 21855 | Caramel Macchiato 21855 | 29 29 | 760 | 810 | 2024-06-28 |
| 21856 | Espresso 21856 | 29 29 | 390 | 440 | 2024-06-28 |
| 21857 | Caffè Latte 21857 | 29 29 | 680 | 730 | 2024-06-28 |
| 21858 | Oatmilk Latte 21858 | 29 29 | 760 | 810 | 2024-06-28 |
| 21859 | Vanilla Latte 21859 | 29 29 | 750 | 800 | 2024-06-28 |
| 21860 | White Chocolate Mocha 21860 | 29 29 | 750 | 800 | 2024-06-28 |
| 21861 | Flat White 21861 | 29 29 | 760 | 810 | 2024-06-28 |
| 21862 | Ristretto Bianco 21862 | 29 29 | 760 | 810 | 2024-06-28 |
| 21863 | Iced Caffè Americano 21863 | 29 29 | 540 | 590 | 2024-06-28 |
| 21864 | Iced Cappuccino 21864 | 29 29 | 680 | 730 | 2024-06-28 |
| 21865 | Iced Caffè Mocha 21865 | 29 29 | 750 | 800 | 2024-06-28 |
| 21866 | Iced Caramel Macchiato 21866 | 29 29 | 760 | 810 | 2024-06-28 |
| 21867 | Iced Caffè Latte 21867 | 29 29 | 680 | 730 | 2024-06-28 |
| 21868 | Iced Oatmilk Latte 21868 | 29 29 | 760 | 810 | 2024-06-28 |
| 21869 | Iced Vanilla Latte 21869 | 29 29 | 750 | 800 | 2024-06-28 |
| 21870 | Iced White Chocolate Mocha 21870 | 29 29 | 750 | 800 | 2024-06-28 |
| 21871 | Signature Hot Chocolate 21871 | 29 29 | 720 | 770 | 2024-06-28 |
| 21872 | Signature Iced Chocolate 21872 | 29 29 | 720 | 770 | 2024-06-28 |
| 21873 | Carrot Juice 21873 | 29 29 | 490 | 540 | 2024-06-28 |
| 21874 | Cloudy Apple Juice 21874 | 29 29 | 490 | 540 | 2024-06-28 |
| 21875 | Cranberry Red Grapefruit Juice 21875 | 29 29 | 490 | 540 | 2024-06-28 |
| 21876 | Orange Juice 21876 | 29 29 | 490 | 540 | 2024-06-28 |
| 21877 | Evian 21877 | 29 29 | 350 | 400 | 2024-06-28 |
| 21878 | Sparkling Water 21878 | 29 29 | 450 | 500 | 2024-06-28 |
| 21879 | Chai Tea 21879 | 29 29 | 500 | 550 | 2024-06-28 |
| 21880 | Earl Grey Tea 21880 | 29 29 | 500 | 550 | 2024-06-28 |
| 21881 | English Breakfast Tea 21881 | 29 29 | 500 | 550 | 2024-06-28 |
| 21882 | Emperor’s Clouds & Mist™ Tea 21882 | 29 29 | 500 | 550 | 2024-06-28 |
| 21883 | Mint Blend Tea 21883 | 29 29 | 500 | 550 | 2024-06-28 |
| 21884 | Chamomile Tea 21884 | 29 29 | 500 | 550 | 2024-06-28 |
| 21885 | Pure Matcha Latte 21885 | 29 29 | 740 | 790 | 2024-06-28 |
| 21886 | Chai Tea Latte 21886 | 29 29 | 680 | 730 | 2024-06-28 |
| 21887 | Earl Grey Tea Latte 21887 | 29 29 | 680 | 730 | 2024-06-28 |
| 21888 | English Breakfast Tea Latte 21888 | 29 29 | 680 | 730 | 2024-06-28 |
| 21889 | Hojicha Tea Latte 21889 | 29 29 | 740 | 790 | 2024-06-28 |
| 21890 | Zen Clouds Oolong Tea 21890 | 29 29 | 500 | 550 | 2024-06-28 |
| 21891 | Zen Clouds Oolong with Ruby Grapefruit and Honey 21891 | 29 29 | 630 | 680 | 2024-06-28 |
| 21892 | Youthberry™ Tea 21892 | 29 29 | 500 | 550 | 2024-06-28 |
| 21893 | Iced Shaken Black Tea Lemonade 21893 | 29 29 | 610 | 660 | 2024-06-28 |
| 21894 | Iced Shaken Strawberry Black Tea Lemonade 21894 | 29 29 | 630 | 680 | 2024-06-28 |
| 21895 | Iced Shaken Hibiscus Tea Lemonade 21895 | 29 29 | 610 | 660 | 2024-06-28 |
| 21896 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 21896 | 29 29 | 730 | 780 | 2024-06-28 |
| 21897 | Iced Pure Matcha Latte 21897 | 29 29 | 740 | 790 | 2024-06-28 |
| 21898 | Iced Chai Tea Latte 21898 | 29 29 | 680 | 730 | 2024-06-28 |
| 21899 | Iced Black Tea Latte 21899 | 29 29 | 680 | 730 | 2024-06-28 |
| 21900 | Iced Hojicha Tea Latte 21900 | 29 29 | 740 | 790 | 2024-06-28 |
| 21901 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 21901 | 29 29 | 630 | 680 | 2024-06-28 |
| 21902 | Iced Shaken Zen Clouds Oolong Lemonade 21902 | 29 29 | 610 | 660 | 2024-06-28 |
| 21903 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 21903 | 29 29 | 630 | 680 | 2024-06-28 |
| 21904 | Origami Pike Place® Roast 21904 | 29 29 | 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");