item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 128
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
- 128 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 5888 | Bagel 5888 | 128 128 | 400 | 430 | 2024-06-28 |
| 5889 | Cookie Crumble Cheesecake 5889 | 128 128 | 720 | 770 | 2024-06-28 |
| 5890 | Good Ol' NY Cheesecake 5890 | 128 128 | 720 | 770 | 2024-06-28 |
| 5891 | Signature Chocolate Cake 5891 | 128 128 | 720 | 770 | 2024-06-28 |
| 5892 | Starbucks® Coffee Tiramisu Cake 5892 | 128 128 | 750 | 800 | 2024-06-28 |
| 5893 | Strawberry Shortcake 5893 | 128 128 | 720 | 770 | 2024-06-28 |
| 5894 | Chocolate Chunk Monster Cookie 5894 | 128 128 | 390 | 440 | 2024-06-28 |
| 5895 | Banana Walnut Muffin 5895 | 128 128 | 450 | 500 | 2024-06-28 |
| 5896 | Blueberry Crumble Muffin 5896 | 128 128 | 450 | 500 | 2024-06-28 |
| 5897 | Chocolate Crumble Muffin 5897 | 128 128 | 450 | 500 | 2024-06-28 |
| 5898 | Pancakes 5898 | 128 128 | 550 | 600 | 2024-06-28 |
| 5899 | Almond Croissant 5899 | 128 128 | 470 | 520 | 2024-06-28 |
| 5900 | Buttery Croissant 5900 | 128 128 | 400 | 430 | 2024-06-28 |
| 5901 | Chocolate Croissant 5901 | 128 128 | 440 | 490 | 2024-06-28 |
| 5902 | Creamy Chicken Foldover 5902 | 128 128 | 550 | 600 | 2024-06-28 |
| 5903 | Sausage Roll 5903 | 128 128 | 550 | 600 | 2024-06-28 |
| 5904 | Buttery Scone 5904 | 128 128 | 400 | 430 | 2024-06-28 |
| 5905 | Country Chicken Pie 5905 | 128 128 | 690 | 740 | 2024-06-28 |
| 5906 | Deep Dish Beef Pie 5906 | 128 128 | 690 | 740 | 2024-06-28 |
| 5907 | Spinach & Mushroom Quiche 5907 | 128 128 | 690 | 740 | 2024-06-28 |
| 5908 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 5908 | 128 128 | 390 | 420 | 2024-06-28 |
| 5909 | Mixed Nuts 5909 | 128 128 | 490 | 540 | 2024-06-28 |
| 5910 | Caramel Waffles 5910 | 128 128 | 390 | 420 | 2024-06-28 |
| 5911 | Chicken Ham & Cheese Panwich 5911 | 128 128 | 690 | 740 | 2024-06-28 |
| 5912 | Egg Mayo & Cheese Multigrain Croissant 5912 | 128 128 | 690 | 740 | 2024-06-28 |
| 5913 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 5913 | 128 128 | 690 | 740 | 2024-06-28 |
| 5914 | Rosemary Chicken & Emmental Cheese Croissant 5914 | 128 128 | 690 | 740 | 2024-06-28 |
| 5915 | Scrambled Egg & Turkey Ham Pita 5915 | 128 128 | 690 | 740 | 2024-06-28 |
| 5916 | Turkey Ham & Triple Cheese Toast 5916 | 128 128 | 690 | 740 | 2024-06-28 |
| 5917 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 5917 | 128 128 | 790 | 840 | 2024-06-28 |
| 5918 | Ham & Cheese Croissant 5918 | 128 128 | 690 | 740 | 2024-06-28 |
| 5919 | Sriracha Chicken Whole Wheat Pita 5919 | 128 128 | 750 | 800 | 2024-06-28 |
| 5920 | Blueberry Acai Yogurt Parfait 5920 | 128 128 | 650 | 700 | 2024-06-28 |
| 5921 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 5921 | 128 128 | 650 | 700 | 2024-06-28 |
| 5922 | Caramel Frappuccino® 5922 | 128 128 | 720 | 770 | 2024-06-28 |
| 5923 | Dark Mocha Frappuccino® 5923 | 128 128 | 780 | 830 | 2024-06-28 |
| 5924 | Java Chip Frappuccino® 5924 | 128 128 | 780 | 830 | 2024-06-28 |
| 5925 | Mocha Frappuccino® 5925 | 128 128 | 720 | 770 | 2024-06-28 |
| 5926 | Caramel Macchiato Frappuccino® 5926 | 128 128 | 780 | 830 | 2024-06-28 |
| 5927 | Espresso Frappuccino® 5927 | 128 128 | 720 | 770 | 2024-06-28 |
| 5928 | White Chocolate Mocha Frappuccino® 5928 | 128 128 | 720 | 770 | 2024-06-28 |
| 5929 | Chocolate Chip Cream Frappuccino® 5929 | 128 128 | 780 | 830 | 2024-06-28 |
| 5930 | Hojicha Tea Cream Frappuccino® 5930 | 128 128 | 760 | 810 | 2024-06-28 |
| 5931 | Vanilla Cream Frappuccino® 5931 | 128 128 | 720 | 770 | 2024-06-28 |
| 5932 | Mango Passion Fruit & Hibiscus 5932 | 128 128 | 720 | 770 | 2024-06-28 |
| 5933 | Raspberry Black Currant & Oolong 5933 | 128 128 | 720 | 770 | 2024-06-28 |
| 5934 | Coffee Traveller 5934 | 128 128 | 3120 | 3170 | 2024-06-28 |
| 5935 | Caffè Americano 5935 | 128 128 | 540 | 590 | 2024-06-28 |
| 5936 | Cappuccino 5936 | 128 128 | 680 | 730 | 2024-06-28 |
| 5937 | Caffè Mocha 5937 | 128 128 | 750 | 800 | 2024-06-28 |
| 5938 | Caramel Macchiato 5938 | 128 128 | 760 | 810 | 2024-06-28 |
| 5939 | Espresso 5939 | 128 128 | 390 | 440 | 2024-06-28 |
| 5940 | Caffè Latte 5940 | 128 128 | 680 | 730 | 2024-06-28 |
| 5941 | Oatmilk Latte 5941 | 128 128 | 760 | 810 | 2024-06-28 |
| 5942 | Vanilla Latte 5942 | 128 128 | 750 | 800 | 2024-06-28 |
| 5943 | White Chocolate Mocha 5943 | 128 128 | 750 | 800 | 2024-06-28 |
| 5944 | Flat White 5944 | 128 128 | 760 | 810 | 2024-06-28 |
| 5945 | Ristretto Bianco 5945 | 128 128 | 760 | 810 | 2024-06-28 |
| 5946 | Iced Caffè Americano 5946 | 128 128 | 540 | 590 | 2024-06-28 |
| 5947 | Iced Cappuccino 5947 | 128 128 | 680 | 730 | 2024-06-28 |
| 5948 | Iced Caffè Mocha 5948 | 128 128 | 750 | 800 | 2024-06-28 |
| 5949 | Iced Caramel Macchiato 5949 | 128 128 | 760 | 810 | 2024-06-28 |
| 5950 | Iced Caffè Latte 5950 | 128 128 | 680 | 730 | 2024-06-28 |
| 5951 | Iced Oatmilk Latte 5951 | 128 128 | 760 | 810 | 2024-06-28 |
| 5952 | Iced Vanilla Latte 5952 | 128 128 | 750 | 800 | 2024-06-28 |
| 5953 | Iced White Chocolate Mocha 5953 | 128 128 | 750 | 800 | 2024-06-28 |
| 5954 | Signature Hot Chocolate 5954 | 128 128 | 720 | 770 | 2024-06-28 |
| 5955 | Signature Iced Chocolate 5955 | 128 128 | 720 | 770 | 2024-06-28 |
| 5956 | Carrot Juice 5956 | 128 128 | 490 | 540 | 2024-06-28 |
| 5957 | Cloudy Apple Juice 5957 | 128 128 | 490 | 540 | 2024-06-28 |
| 5958 | Cranberry Red Grapefruit Juice 5958 | 128 128 | 490 | 540 | 2024-06-28 |
| 5959 | Orange Juice 5959 | 128 128 | 490 | 540 | 2024-06-28 |
| 5960 | Evian 5960 | 128 128 | 350 | 400 | 2024-06-28 |
| 5961 | Sparkling Water 5961 | 128 128 | 450 | 500 | 2024-06-28 |
| 5962 | Chai Tea 5962 | 128 128 | 500 | 550 | 2024-06-28 |
| 5963 | Earl Grey Tea 5963 | 128 128 | 500 | 550 | 2024-06-28 |
| 5964 | English Breakfast Tea 5964 | 128 128 | 500 | 550 | 2024-06-28 |
| 5965 | Emperor’s Clouds & Mist™ Tea 5965 | 128 128 | 500 | 550 | 2024-06-28 |
| 5966 | Mint Blend Tea 5966 | 128 128 | 500 | 550 | 2024-06-28 |
| 5967 | Chamomile Tea 5967 | 128 128 | 500 | 550 | 2024-06-28 |
| 5968 | Pure Matcha Latte 5968 | 128 128 | 740 | 790 | 2024-06-28 |
| 5969 | Chai Tea Latte 5969 | 128 128 | 680 | 730 | 2024-06-28 |
| 5970 | Earl Grey Tea Latte 5970 | 128 128 | 680 | 730 | 2024-06-28 |
| 5971 | English Breakfast Tea Latte 5971 | 128 128 | 680 | 730 | 2024-06-28 |
| 5972 | Hojicha Tea Latte 5972 | 128 128 | 740 | 790 | 2024-06-28 |
| 5973 | Zen Clouds Oolong Tea 5973 | 128 128 | 500 | 550 | 2024-06-28 |
| 5974 | Zen Clouds Oolong with Ruby Grapefruit and Honey 5974 | 128 128 | 630 | 680 | 2024-06-28 |
| 5975 | Youthberry™ Tea 5975 | 128 128 | 500 | 550 | 2024-06-28 |
| 5976 | Iced Shaken Black Tea Lemonade 5976 | 128 128 | 610 | 660 | 2024-06-28 |
| 5977 | Iced Shaken Strawberry Black Tea Lemonade 5977 | 128 128 | 630 | 680 | 2024-06-28 |
| 5978 | Iced Shaken Hibiscus Tea Lemonade 5978 | 128 128 | 610 | 660 | 2024-06-28 |
| 5979 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 5979 | 128 128 | 730 | 780 | 2024-06-28 |
| 5980 | Iced Pure Matcha Latte 5980 | 128 128 | 740 | 790 | 2024-06-28 |
| 5981 | Iced Chai Tea Latte 5981 | 128 128 | 680 | 730 | 2024-06-28 |
| 5982 | Iced Black Tea Latte 5982 | 128 128 | 680 | 730 | 2024-06-28 |
| 5983 | Iced Hojicha Tea Latte 5983 | 128 128 | 740 | 790 | 2024-06-28 |
| 5984 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 5984 | 128 128 | 630 | 680 | 2024-06-28 |
| 5985 | Iced Shaken Zen Clouds Oolong Lemonade 5985 | 128 128 | 610 | 660 | 2024-06-28 |
| 5986 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 5986 | 128 128 | 630 | 680 | 2024-06-28 |
| 5987 | Origami Pike Place® Roast 5987 | 128 128 | 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");