item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
249 rows where store_id = 102
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
- 102 · 249 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 9896 | Bagel 9896 | 102 102 | 400 | 430 | 2024-06-28 |
| 9897 | Cookie Crumble Cheesecake 9897 | 102 102 | 720 | 770 | 2024-06-28 |
| 9898 | Good Ol' NY Cheesecake 9898 | 102 102 | 720 | 770 | 2024-06-28 |
| 9899 | Signature Chocolate Cake 9899 | 102 102 | 720 | 770 | 2024-06-28 |
| 9900 | Starbucks® Coffee Tiramisu Cake 9900 | 102 102 | 750 | 800 | 2024-06-28 |
| 9901 | Strawberry Shortcake 9901 | 102 102 | 720 | 770 | 2024-06-28 |
| 9902 | Chocolate Chunk Monster Cookie 9902 | 102 102 | 390 | 440 | 2024-06-28 |
| 9903 | Banana Walnut Muffin 9903 | 102 102 | 450 | 500 | 2024-06-28 |
| 9904 | Blueberry Crumble Muffin 9904 | 102 102 | 450 | 500 | 2024-06-28 |
| 9905 | Chocolate Crumble Muffin 9905 | 102 102 | 450 | 500 | 2024-06-28 |
| 9906 | Pancakes 9906 | 102 102 | 550 | 600 | 2024-06-28 |
| 9907 | Almond Croissant 9907 | 102 102 | 470 | 520 | 2024-06-28 |
| 9908 | Buttery Croissant 9908 | 102 102 | 400 | 430 | 2024-06-28 |
| 9909 | Chocolate Croissant 9909 | 102 102 | 440 | 490 | 2024-06-28 |
| 9910 | Creamy Chicken Foldover 9910 | 102 102 | 550 | 600 | 2024-06-28 |
| 9911 | Sausage Roll 9911 | 102 102 | 550 | 600 | 2024-06-28 |
| 9912 | Buttery Scone 9912 | 102 102 | 400 | 430 | 2024-06-28 |
| 9913 | Country Chicken Pie 9913 | 102 102 | 690 | 740 | 2024-06-28 |
| 9914 | Deep Dish Beef Pie 9914 | 102 102 | 690 | 740 | 2024-06-28 |
| 9915 | Spinach & Mushroom Quiche 9915 | 102 102 | 690 | 740 | 2024-06-28 |
| 9916 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 9916 | 102 102 | 390 | 420 | 2024-06-28 |
| 9917 | Mixed Nuts 9917 | 102 102 | 490 | 540 | 2024-06-28 |
| 9918 | Caramel Waffles 9918 | 102 102 | 390 | 420 | 2024-06-28 |
| 9919 | Chicken Ham & Cheese Panwich 9919 | 102 102 | 690 | 740 | 2024-06-28 |
| 9920 | Egg Mayo & Cheese Multigrain Croissant 9920 | 102 102 | 690 | 740 | 2024-06-28 |
| 9921 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 9921 | 102 102 | 690 | 740 | 2024-06-28 |
| 9922 | Rosemary Chicken & Emmental Cheese Croissant 9922 | 102 102 | 690 | 740 | 2024-06-28 |
| 9923 | Scrambled Egg & Turkey Ham Pita 9923 | 102 102 | 690 | 740 | 2024-06-28 |
| 9924 | Turkey Ham & Triple Cheese Toast 9924 | 102 102 | 690 | 740 | 2024-06-28 |
| 9925 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 9925 | 102 102 | 790 | 840 | 2024-06-28 |
| 9926 | Ham & Cheese Croissant 9926 | 102 102 | 690 | 740 | 2024-06-28 |
| 9927 | Sriracha Chicken Whole Wheat Pita 9927 | 102 102 | 750 | 800 | 2024-06-28 |
| 9928 | Blueberry Acai Yogurt Parfait 9928 | 102 102 | 650 | 700 | 2024-06-28 |
| 9929 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 9929 | 102 102 | 650 | 700 | 2024-06-28 |
| 9930 | Caramel Frappuccino® 9930 | 102 102 | 720 | 770 | 2024-06-28 |
| 9931 | Dark Mocha Frappuccino® 9931 | 102 102 | 780 | 830 | 2024-06-28 |
| 9932 | Java Chip Frappuccino® 9932 | 102 102 | 780 | 830 | 2024-06-28 |
| 9933 | Mocha Frappuccino® 9933 | 102 102 | 720 | 770 | 2024-06-28 |
| 9934 | Caramel Macchiato Frappuccino® 9934 | 102 102 | 780 | 830 | 2024-06-28 |
| 9935 | Espresso Frappuccino® 9935 | 102 102 | 720 | 770 | 2024-06-28 |
| 9936 | White Chocolate Mocha Frappuccino® 9936 | 102 102 | 720 | 770 | 2024-06-28 |
| 9937 | Chocolate Chip Cream Frappuccino® 9937 | 102 102 | 780 | 830 | 2024-06-28 |
| 9938 | Hojicha Tea Cream Frappuccino® 9938 | 102 102 | 760 | 810 | 2024-06-28 |
| 9939 | Vanilla Cream Frappuccino® 9939 | 102 102 | 720 | 770 | 2024-06-28 |
| 9940 | Mango Passion Fruit & Hibiscus 9940 | 102 102 | 720 | 770 | 2024-06-28 |
| 9941 | Raspberry Black Currant & Oolong 9941 | 102 102 | 720 | 770 | 2024-06-28 |
| 9942 | Coffee Traveller 9942 | 102 102 | 3120 | 3170 | 2024-06-28 |
| 9943 | Caffè Americano 9943 | 102 102 | 540 | 590 | 2024-06-28 |
| 9944 | Cappuccino 9944 | 102 102 | 680 | 730 | 2024-06-28 |
| 9945 | Caffè Mocha 9945 | 102 102 | 750 | 800 | 2024-06-28 |
| 9946 | Caramel Macchiato 9946 | 102 102 | 760 | 810 | 2024-06-28 |
| 9947 | Espresso 9947 | 102 102 | 390 | 440 | 2024-06-28 |
| 9948 | Caffè Latte 9948 | 102 102 | 680 | 730 | 2024-06-28 |
| 9949 | Oatmilk Latte 9949 | 102 102 | 760 | 810 | 2024-06-28 |
| 9950 | Vanilla Latte 9950 | 102 102 | 750 | 800 | 2024-06-28 |
| 9951 | White Chocolate Mocha 9951 | 102 102 | 750 | 800 | 2024-06-28 |
| 9952 | Flat White 9952 | 102 102 | 760 | 810 | 2024-06-28 |
| 9953 | Ristretto Bianco 9953 | 102 102 | 760 | 810 | 2024-06-28 |
| 9954 | Iced Caffè Americano 9954 | 102 102 | 540 | 590 | 2024-06-28 |
| 9955 | Iced Cappuccino 9955 | 102 102 | 680 | 730 | 2024-06-28 |
| 9956 | Iced Caffè Mocha 9956 | 102 102 | 750 | 800 | 2024-06-28 |
| 9957 | Iced Caramel Macchiato 9957 | 102 102 | 760 | 810 | 2024-06-28 |
| 9958 | Iced Caffè Latte 9958 | 102 102 | 680 | 730 | 2024-06-28 |
| 9959 | Iced Oatmilk Latte 9959 | 102 102 | 760 | 810 | 2024-06-28 |
| 9960 | Iced Vanilla Latte 9960 | 102 102 | 750 | 800 | 2024-06-28 |
| 9961 | Iced White Chocolate Mocha 9961 | 102 102 | 750 | 800 | 2024-06-28 |
| 9962 | Signature Hot Chocolate 9962 | 102 102 | 720 | 770 | 2024-06-28 |
| 9963 | Signature Iced Chocolate 9963 | 102 102 | 720 | 770 | 2024-06-28 |
| 9964 | Carrot Juice 9964 | 102 102 | 490 | 540 | 2024-06-28 |
| 9965 | Cloudy Apple Juice 9965 | 102 102 | 490 | 540 | 2024-06-28 |
| 9966 | Cranberry Red Grapefruit Juice 9966 | 102 102 | 490 | 540 | 2024-06-28 |
| 9967 | Orange Juice 9967 | 102 102 | 490 | 540 | 2024-06-28 |
| 9968 | Evian 9968 | 102 102 | 350 | 400 | 2024-06-28 |
| 9969 | Sparkling Water 9969 | 102 102 | 450 | 500 | 2024-06-28 |
| 9970 | Chai Tea 9970 | 102 102 | 500 | 550 | 2024-06-28 |
| 9971 | Earl Grey Tea 9971 | 102 102 | 500 | 550 | 2024-06-28 |
| 9972 | English Breakfast Tea 9972 | 102 102 | 500 | 550 | 2024-06-28 |
| 9973 | Emperor’s Clouds & Mist™ Tea 9973 | 102 102 | 500 | 550 | 2024-06-28 |
| 9974 | Mint Blend Tea 9974 | 102 102 | 500 | 550 | 2024-06-28 |
| 9975 | Chamomile Tea 9975 | 102 102 | 500 | 550 | 2024-06-28 |
| 9976 | Pure Matcha Latte 9976 | 102 102 | 740 | 790 | 2024-06-28 |
| 9977 | Chai Tea Latte 9977 | 102 102 | 680 | 730 | 2024-06-28 |
| 9978 | Earl Grey Tea Latte 9978 | 102 102 | 680 | 730 | 2024-06-28 |
| 9979 | English Breakfast Tea Latte 9979 | 102 102 | 680 | 730 | 2024-06-28 |
| 9980 | Hojicha Tea Latte 9980 | 102 102 | 740 | 790 | 2024-06-28 |
| 9981 | Zen Clouds Oolong Tea 9981 | 102 102 | 500 | 550 | 2024-06-28 |
| 9982 | Zen Clouds Oolong with Ruby Grapefruit and Honey 9982 | 102 102 | 630 | 680 | 2024-06-28 |
| 9983 | Youthberry™ Tea 9983 | 102 102 | 500 | 550 | 2024-06-28 |
| 9984 | Iced Shaken Black Tea Lemonade 9984 | 102 102 | 610 | 660 | 2024-06-28 |
| 9985 | Iced Shaken Strawberry Black Tea Lemonade 9985 | 102 102 | 630 | 680 | 2024-06-28 |
| 9986 | Iced Shaken Hibiscus Tea Lemonade 9986 | 102 102 | 610 | 660 | 2024-06-28 |
| 9987 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 9987 | 102 102 | 730 | 780 | 2024-06-28 |
| 9988 | Iced Pure Matcha Latte 9988 | 102 102 | 740 | 790 | 2024-06-28 |
| 9989 | Iced Chai Tea Latte 9989 | 102 102 | 680 | 730 | 2024-06-28 |
| 9990 | Iced Black Tea Latte 9990 | 102 102 | 680 | 730 | 2024-06-28 |
| 9991 | Iced Hojicha Tea Latte 9991 | 102 102 | 740 | 790 | 2024-06-28 |
| 9992 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 9992 | 102 102 | 630 | 680 | 2024-06-28 |
| 9993 | Iced Shaken Zen Clouds Oolong Lemonade 9993 | 102 102 | 610 | 660 | 2024-06-28 |
| 9994 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 9994 | 102 102 | 630 | 680 | 2024-06-28 |
| 9995 | Origami Pike Place® Roast 9995 | 102 102 | 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");