item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 18
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
- 18 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 23812 | Bagel 23812 | 18 18 | 400 | 430 | 2024-06-28 |
| 23813 | Cookie Crumble Cheesecake 23813 | 18 18 | 720 | 770 | 2024-06-28 |
| 23814 | Good Ol' NY Cheesecake 23814 | 18 18 | 720 | 770 | 2024-06-28 |
| 23815 | Signature Chocolate Cake 23815 | 18 18 | 720 | 770 | 2024-06-28 |
| 23816 | Starbucks® Coffee Tiramisu Cake 23816 | 18 18 | 750 | 800 | 2024-06-28 |
| 23817 | Strawberry Shortcake 23817 | 18 18 | 720 | 770 | 2024-06-28 |
| 23818 | Chocolate Chunk Monster Cookie 23818 | 18 18 | 390 | 440 | 2024-06-28 |
| 23819 | Banana Walnut Muffin 23819 | 18 18 | 450 | 500 | 2024-06-28 |
| 23820 | Blueberry Crumble Muffin 23820 | 18 18 | 450 | 500 | 2024-06-28 |
| 23821 | Chocolate Crumble Muffin 23821 | 18 18 | 450 | 500 | 2024-06-28 |
| 23822 | Pancakes 23822 | 18 18 | 550 | 600 | 2024-06-28 |
| 23823 | Almond Croissant 23823 | 18 18 | 470 | 520 | 2024-06-28 |
| 23824 | Buttery Croissant 23824 | 18 18 | 400 | 430 | 2024-06-28 |
| 23825 | Chocolate Croissant 23825 | 18 18 | 440 | 490 | 2024-06-28 |
| 23826 | Creamy Chicken Foldover 23826 | 18 18 | 550 | 600 | 2024-06-28 |
| 23827 | Sausage Roll 23827 | 18 18 | 550 | 600 | 2024-06-28 |
| 23828 | Buttery Scone 23828 | 18 18 | 400 | 430 | 2024-06-28 |
| 23829 | Country Chicken Pie 23829 | 18 18 | 690 | 740 | 2024-06-28 |
| 23830 | Deep Dish Beef Pie 23830 | 18 18 | 690 | 740 | 2024-06-28 |
| 23831 | Spinach & Mushroom Quiche 23831 | 18 18 | 690 | 740 | 2024-06-28 |
| 23832 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 23832 | 18 18 | 390 | 420 | 2024-06-28 |
| 23833 | Mixed Nuts 23833 | 18 18 | 490 | 540 | 2024-06-28 |
| 23834 | Caramel Waffles 23834 | 18 18 | 390 | 420 | 2024-06-28 |
| 23835 | Chicken Ham & Cheese Panwich 23835 | 18 18 | 690 | 740 | 2024-06-28 |
| 23836 | Egg Mayo & Cheese Multigrain Croissant 23836 | 18 18 | 690 | 740 | 2024-06-28 |
| 23837 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 23837 | 18 18 | 690 | 740 | 2024-06-28 |
| 23838 | Rosemary Chicken & Emmental Cheese Croissant 23838 | 18 18 | 690 | 740 | 2024-06-28 |
| 23839 | Scrambled Egg & Turkey Ham Pita 23839 | 18 18 | 690 | 740 | 2024-06-28 |
| 23840 | Turkey Ham & Triple Cheese Toast 23840 | 18 18 | 690 | 740 | 2024-06-28 |
| 23841 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 23841 | 18 18 | 790 | 840 | 2024-06-28 |
| 23842 | Ham & Cheese Croissant 23842 | 18 18 | 690 | 740 | 2024-06-28 |
| 23843 | Sriracha Chicken Whole Wheat Pita 23843 | 18 18 | 750 | 800 | 2024-06-28 |
| 23844 | Blueberry Acai Yogurt Parfait 23844 | 18 18 | 650 | 700 | 2024-06-28 |
| 23845 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 23845 | 18 18 | 650 | 700 | 2024-06-28 |
| 23846 | Caramel Frappuccino® 23846 | 18 18 | 720 | 770 | 2024-06-28 |
| 23847 | Dark Mocha Frappuccino® 23847 | 18 18 | 780 | 830 | 2024-06-28 |
| 23848 | Java Chip Frappuccino® 23848 | 18 18 | 780 | 830 | 2024-06-28 |
| 23849 | Mocha Frappuccino® 23849 | 18 18 | 720 | 770 | 2024-06-28 |
| 23850 | Caramel Macchiato Frappuccino® 23850 | 18 18 | 780 | 830 | 2024-06-28 |
| 23851 | Espresso Frappuccino® 23851 | 18 18 | 720 | 770 | 2024-06-28 |
| 23852 | White Chocolate Mocha Frappuccino® 23852 | 18 18 | 720 | 770 | 2024-06-28 |
| 23853 | Chocolate Chip Cream Frappuccino® 23853 | 18 18 | 780 | 830 | 2024-06-28 |
| 23854 | Hojicha Tea Cream Frappuccino® 23854 | 18 18 | 760 | 810 | 2024-06-28 |
| 23855 | Vanilla Cream Frappuccino® 23855 | 18 18 | 720 | 770 | 2024-06-28 |
| 23856 | Mango Passion Fruit & Hibiscus 23856 | 18 18 | 720 | 770 | 2024-06-28 |
| 23857 | Raspberry Black Currant & Oolong 23857 | 18 18 | 720 | 770 | 2024-06-28 |
| 23858 | Coffee Traveller 23858 | 18 18 | 3120 | 3170 | 2024-06-28 |
| 23859 | Caffè Americano 23859 | 18 18 | 540 | 590 | 2024-06-28 |
| 23860 | Cappuccino 23860 | 18 18 | 680 | 730 | 2024-06-28 |
| 23861 | Caffè Mocha 23861 | 18 18 | 750 | 800 | 2024-06-28 |
| 23862 | Caramel Macchiato 23862 | 18 18 | 760 | 810 | 2024-06-28 |
| 23863 | Espresso 23863 | 18 18 | 390 | 440 | 2024-06-28 |
| 23864 | Caffè Latte 23864 | 18 18 | 680 | 730 | 2024-06-28 |
| 23865 | Oatmilk Latte 23865 | 18 18 | 760 | 810 | 2024-06-28 |
| 23866 | Vanilla Latte 23866 | 18 18 | 750 | 800 | 2024-06-28 |
| 23867 | White Chocolate Mocha 23867 | 18 18 | 750 | 800 | 2024-06-28 |
| 23868 | Flat White 23868 | 18 18 | 760 | 810 | 2024-06-28 |
| 23869 | Ristretto Bianco 23869 | 18 18 | 760 | 810 | 2024-06-28 |
| 23870 | Iced Caffè Americano 23870 | 18 18 | 540 | 590 | 2024-06-28 |
| 23871 | Iced Cappuccino 23871 | 18 18 | 680 | 730 | 2024-06-28 |
| 23872 | Iced Caffè Mocha 23872 | 18 18 | 750 | 800 | 2024-06-28 |
| 23873 | Iced Caramel Macchiato 23873 | 18 18 | 760 | 810 | 2024-06-28 |
| 23874 | Iced Caffè Latte 23874 | 18 18 | 680 | 730 | 2024-06-28 |
| 23875 | Iced Oatmilk Latte 23875 | 18 18 | 760 | 810 | 2024-06-28 |
| 23876 | Iced Vanilla Latte 23876 | 18 18 | 750 | 800 | 2024-06-28 |
| 23877 | Iced White Chocolate Mocha 23877 | 18 18 | 750 | 800 | 2024-06-28 |
| 23878 | Signature Hot Chocolate 23878 | 18 18 | 720 | 770 | 2024-06-28 |
| 23879 | Signature Iced Chocolate 23879 | 18 18 | 720 | 770 | 2024-06-28 |
| 23880 | Carrot Juice 23880 | 18 18 | 490 | 540 | 2024-06-28 |
| 23881 | Cloudy Apple Juice 23881 | 18 18 | 490 | 540 | 2024-06-28 |
| 23882 | Cranberry Red Grapefruit Juice 23882 | 18 18 | 490 | 540 | 2024-06-28 |
| 23883 | Orange Juice 23883 | 18 18 | 490 | 540 | 2024-06-28 |
| 23884 | Evian 23884 | 18 18 | 350 | 400 | 2024-06-28 |
| 23885 | Sparkling Water 23885 | 18 18 | 450 | 500 | 2024-06-28 |
| 23886 | Chai Tea 23886 | 18 18 | 500 | 550 | 2024-06-28 |
| 23887 | Earl Grey Tea 23887 | 18 18 | 500 | 550 | 2024-06-28 |
| 23888 | English Breakfast Tea 23888 | 18 18 | 500 | 550 | 2024-06-28 |
| 23889 | Emperor’s Clouds & Mist™ Tea 23889 | 18 18 | 500 | 550 | 2024-06-28 |
| 23890 | Mint Blend Tea 23890 | 18 18 | 500 | 550 | 2024-06-28 |
| 23891 | Chamomile Tea 23891 | 18 18 | 500 | 550 | 2024-06-28 |
| 23892 | Pure Matcha Latte 23892 | 18 18 | 740 | 790 | 2024-06-28 |
| 23893 | Chai Tea Latte 23893 | 18 18 | 680 | 730 | 2024-06-28 |
| 23894 | Earl Grey Tea Latte 23894 | 18 18 | 680 | 730 | 2024-06-28 |
| 23895 | English Breakfast Tea Latte 23895 | 18 18 | 680 | 730 | 2024-06-28 |
| 23896 | Hojicha Tea Latte 23896 | 18 18 | 740 | 790 | 2024-06-28 |
| 23897 | Zen Clouds Oolong Tea 23897 | 18 18 | 500 | 550 | 2024-06-28 |
| 23898 | Zen Clouds Oolong with Ruby Grapefruit and Honey 23898 | 18 18 | 630 | 680 | 2024-06-28 |
| 23899 | Youthberry™ Tea 23899 | 18 18 | 500 | 550 | 2024-06-28 |
| 23900 | Iced Shaken Black Tea Lemonade 23900 | 18 18 | 610 | 660 | 2024-06-28 |
| 23901 | Iced Shaken Strawberry Black Tea Lemonade 23901 | 18 18 | 630 | 680 | 2024-06-28 |
| 23902 | Iced Shaken Hibiscus Tea Lemonade 23902 | 18 18 | 610 | 660 | 2024-06-28 |
| 23903 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 23903 | 18 18 | 730 | 780 | 2024-06-28 |
| 23904 | Iced Pure Matcha Latte 23904 | 18 18 | 740 | 790 | 2024-06-28 |
| 23905 | Iced Chai Tea Latte 23905 | 18 18 | 680 | 730 | 2024-06-28 |
| 23906 | Iced Black Tea Latte 23906 | 18 18 | 680 | 730 | 2024-06-28 |
| 23907 | Iced Hojicha Tea Latte 23907 | 18 18 | 740 | 790 | 2024-06-28 |
| 23908 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 23908 | 18 18 | 630 | 680 | 2024-06-28 |
| 23909 | Iced Shaken Zen Clouds Oolong Lemonade 23909 | 18 18 | 610 | 660 | 2024-06-28 |
| 23910 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 23910 | 18 18 | 630 | 680 | 2024-06-28 |
| 23911 | Origami Pike Place® Roast 23911 | 18 18 | 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");