item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 97
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 11
- 2024-06-28 182
- 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
- 97 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 10808 | Bagel 10808 | 97 97 | 400 | 430 | 2024-06-28 |
| 10809 | Cookie Crumble Cheesecake 10809 | 97 97 | 720 | 770 | 2024-06-28 |
| 10810 | Good Ol' NY Cheesecake 10810 | 97 97 | 720 | 770 | 2024-06-28 |
| 10811 | Signature Chocolate Cake 10811 | 97 97 | 720 | 770 | 2024-06-28 |
| 10812 | Starbucks® Coffee Tiramisu Cake 10812 | 97 97 | 750 | 800 | 2024-06-28 |
| 10813 | Strawberry Shortcake 10813 | 97 97 | 720 | 770 | 2024-06-28 |
| 10814 | Chocolate Chunk Monster Cookie 10814 | 97 97 | 390 | 440 | 2024-06-28 |
| 10815 | Banana Walnut Muffin 10815 | 97 97 | 450 | 500 | 2024-06-28 |
| 10816 | Blueberry Crumble Muffin 10816 | 97 97 | 450 | 500 | 2024-06-28 |
| 10817 | Chocolate Crumble Muffin 10817 | 97 97 | 450 | 500 | 2024-06-28 |
| 10818 | Pancakes 10818 | 97 97 | 550 | 600 | 2024-06-28 |
| 10819 | Almond Croissant 10819 | 97 97 | 470 | 520 | 2024-06-28 |
| 10820 | Buttery Croissant 10820 | 97 97 | 400 | 430 | 2024-06-28 |
| 10821 | Chocolate Croissant 10821 | 97 97 | 440 | 490 | 2024-06-28 |
| 10822 | Creamy Chicken Foldover 10822 | 97 97 | 550 | 600 | 2024-06-28 |
| 10823 | Sausage Roll 10823 | 97 97 | 550 | 600 | 2024-06-28 |
| 10824 | Buttery Scone 10824 | 97 97 | 400 | 430 | 2024-06-28 |
| 10825 | Country Chicken Pie 10825 | 97 97 | 690 | 740 | 2024-06-28 |
| 10826 | Deep Dish Beef Pie 10826 | 97 97 | 690 | 740 | 2024-06-28 |
| 10827 | Spinach & Mushroom Quiche 10827 | 97 97 | 690 | 740 | 2024-06-28 |
| 10828 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 10828 | 97 97 | 390 | 420 | 2024-06-28 |
| 10829 | Mixed Nuts 10829 | 97 97 | 490 | 540 | 2024-06-28 |
| 10830 | Caramel Waffles 10830 | 97 97 | 390 | 420 | 2024-06-28 |
| 10831 | Chicken Ham & Cheese Panwich 10831 | 97 97 | 690 | 740 | 2024-06-28 |
| 10832 | Egg Mayo & Cheese Multigrain Croissant 10832 | 97 97 | 690 | 740 | 2024-06-28 |
| 10833 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 10833 | 97 97 | 690 | 740 | 2024-06-28 |
| 10834 | Rosemary Chicken & Emmental Cheese Croissant 10834 | 97 97 | 690 | 740 | 2024-06-28 |
| 10835 | Scrambled Egg & Turkey Ham Pita 10835 | 97 97 | 690 | 740 | 2024-06-28 |
| 10836 | Turkey Ham & Triple Cheese Toast 10836 | 97 97 | 690 | 740 | 2024-06-28 |
| 10837 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 10837 | 97 97 | 790 | 840 | 2024-06-28 |
| 10838 | Ham & Cheese Croissant 10838 | 97 97 | 690 | 740 | 2024-06-28 |
| 10839 | Sriracha Chicken Whole Wheat Pita 10839 | 97 97 | 750 | 800 | 2024-06-28 |
| 10840 | Blueberry Acai Yogurt Parfait 10840 | 97 97 | 650 | 700 | 2024-06-28 |
| 10841 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 10841 | 97 97 | 650 | 700 | 2024-06-28 |
| 10842 | Caramel Frappuccino® 10842 | 97 97 | 720 | 770 | 2024-06-28 |
| 10843 | Dark Mocha Frappuccino® 10843 | 97 97 | 780 | 830 | 2024-06-28 |
| 10844 | Java Chip Frappuccino® 10844 | 97 97 | 780 | 830 | 2024-06-28 |
| 10845 | Mocha Frappuccino® 10845 | 97 97 | 720 | 770 | 2024-06-28 |
| 10846 | Caramel Macchiato Frappuccino® 10846 | 97 97 | 780 | 830 | 2024-06-28 |
| 10847 | Espresso Frappuccino® 10847 | 97 97 | 720 | 770 | 2024-06-28 |
| 10848 | White Chocolate Mocha Frappuccino® 10848 | 97 97 | 720 | 770 | 2024-06-28 |
| 10849 | Chocolate Chip Cream Frappuccino® 10849 | 97 97 | 780 | 830 | 2024-06-28 |
| 10850 | Hojicha Tea Cream Frappuccino® 10850 | 97 97 | 760 | 810 | 2024-06-28 |
| 10851 | Vanilla Cream Frappuccino® 10851 | 97 97 | 720 | 770 | 2024-06-28 |
| 10852 | Mango Passion Fruit & Hibiscus 10852 | 97 97 | 720 | 770 | 2024-06-28 |
| 10853 | Raspberry Black Currant & Oolong 10853 | 97 97 | 720 | 770 | 2024-06-28 |
| 10854 | Coffee Traveller 10854 | 97 97 | 3120 | 3170 | 2024-06-28 |
| 10855 | Caffè Americano 10855 | 97 97 | 540 | 590 | 2024-06-28 |
| 10856 | Cappuccino 10856 | 97 97 | 680 | 730 | 2024-06-28 |
| 10857 | Caffè Mocha 10857 | 97 97 | 750 | 800 | 2024-06-28 |
| 10858 | Caramel Macchiato 10858 | 97 97 | 760 | 810 | 2024-06-28 |
| 10859 | Espresso 10859 | 97 97 | 390 | 440 | 2024-06-28 |
| 10860 | Caffè Latte 10860 | 97 97 | 680 | 730 | 2024-06-28 |
| 10861 | Oatmilk Latte 10861 | 97 97 | 760 | 810 | 2024-06-28 |
| 10862 | Vanilla Latte 10862 | 97 97 | 750 | 800 | 2024-06-28 |
| 10863 | White Chocolate Mocha 10863 | 97 97 | 750 | 800 | 2024-06-28 |
| 10864 | Flat White 10864 | 97 97 | 760 | 810 | 2024-06-28 |
| 10865 | Ristretto Bianco 10865 | 97 97 | 760 | 810 | 2024-06-28 |
| 10866 | Iced Caffè Americano 10866 | 97 97 | 540 | 590 | 2024-06-28 |
| 10867 | Iced Cappuccino 10867 | 97 97 | 680 | 730 | 2024-06-28 |
| 10868 | Iced Caffè Mocha 10868 | 97 97 | 750 | 800 | 2024-06-28 |
| 10869 | Iced Caramel Macchiato 10869 | 97 97 | 760 | 810 | 2024-06-28 |
| 10870 | Iced Caffè Latte 10870 | 97 97 | 680 | 730 | 2024-06-28 |
| 10871 | Iced Oatmilk Latte 10871 | 97 97 | 760 | 810 | 2024-06-28 |
| 10872 | Iced Vanilla Latte 10872 | 97 97 | 750 | 800 | 2024-06-28 |
| 10873 | Iced White Chocolate Mocha 10873 | 97 97 | 750 | 800 | 2024-06-28 |
| 10874 | Signature Hot Chocolate 10874 | 97 97 | 720 | 770 | 2024-06-28 |
| 10875 | Signature Iced Chocolate 10875 | 97 97 | 720 | 770 | 2024-06-28 |
| 10876 | Carrot Juice 10876 | 97 97 | 490 | 540 | 2024-06-28 |
| 10877 | Cloudy Apple Juice 10877 | 97 97 | 490 | 540 | 2024-06-28 |
| 10878 | Cranberry Red Grapefruit Juice 10878 | 97 97 | 490 | 540 | 2024-06-28 |
| 10879 | Orange Juice 10879 | 97 97 | 490 | 540 | 2024-06-28 |
| 10880 | Evian 10880 | 97 97 | 350 | 400 | 2024-06-28 |
| 10881 | Sparkling Water 10881 | 97 97 | 450 | 500 | 2024-06-28 |
| 10882 | Chai Tea 10882 | 97 97 | 500 | 550 | 2024-06-28 |
| 10883 | Earl Grey Tea 10883 | 97 97 | 500 | 550 | 2024-06-28 |
| 10884 | English Breakfast Tea 10884 | 97 97 | 500 | 550 | 2024-06-28 |
| 10885 | Emperor’s Clouds & Mist™ Tea 10885 | 97 97 | 500 | 550 | 2024-06-28 |
| 10886 | Mint Blend Tea 10886 | 97 97 | 500 | 550 | 2024-06-28 |
| 10887 | Chamomile Tea 10887 | 97 97 | 500 | 550 | 2024-06-28 |
| 10888 | Pure Matcha Latte 10888 | 97 97 | 740 | 790 | 2024-06-28 |
| 10889 | Chai Tea Latte 10889 | 97 97 | 680 | 730 | 2024-06-28 |
| 10890 | Earl Grey Tea Latte 10890 | 97 97 | 680 | 730 | 2024-06-28 |
| 10891 | English Breakfast Tea Latte 10891 | 97 97 | 680 | 730 | 2024-06-28 |
| 10892 | Hojicha Tea Latte 10892 | 97 97 | 740 | 790 | 2024-06-28 |
| 10893 | Zen Clouds Oolong Tea 10893 | 97 97 | 500 | 550 | 2024-06-28 |
| 10894 | Zen Clouds Oolong with Ruby Grapefruit and Honey 10894 | 97 97 | 630 | 680 | 2024-06-28 |
| 10895 | Youthberry™ Tea 10895 | 97 97 | 500 | 550 | 2024-06-28 |
| 10896 | Iced Shaken Black Tea Lemonade 10896 | 97 97 | 610 | 660 | 2024-06-28 |
| 10897 | Iced Shaken Strawberry Black Tea Lemonade 10897 | 97 97 | 630 | 680 | 2024-06-28 |
| 10898 | Iced Shaken Hibiscus Tea Lemonade 10898 | 97 97 | 610 | 660 | 2024-06-28 |
| 10899 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 10899 | 97 97 | 730 | 780 | 2024-06-28 |
| 10900 | Iced Pure Matcha Latte 10900 | 97 97 | 740 | 790 | 2024-06-28 |
| 10901 | Iced Chai Tea Latte 10901 | 97 97 | 680 | 730 | 2024-06-28 |
| 10902 | Iced Black Tea Latte 10902 | 97 97 | 680 | 730 | 2024-06-28 |
| 10903 | Iced Hojicha Tea Latte 10903 | 97 97 | 740 | 790 | 2024-06-28 |
| 10904 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 10904 | 97 97 | 630 | 680 | 2024-06-28 |
| 10905 | Iced Shaken Zen Clouds Oolong Lemonade 10905 | 97 97 | 610 | 660 | 2024-06-28 |
| 10906 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 10906 | 97 97 | 630 | 680 | 2024-06-28 |
| 10907 | Origami Pike Place® Roast 10907 | 97 97 | 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");