item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
248 rows where store_id = 114
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
- 114 · 248 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 7892 | Bagel 7892 | 114 114 | 400 | 430 | 2024-06-28 |
| 7893 | Cookie Crumble Cheesecake 7893 | 114 114 | 720 | 770 | 2024-06-28 |
| 7894 | Good Ol' NY Cheesecake 7894 | 114 114 | 720 | 770 | 2024-06-28 |
| 7895 | Signature Chocolate Cake 7895 | 114 114 | 720 | 770 | 2024-06-28 |
| 7896 | Starbucks® Coffee Tiramisu Cake 7896 | 114 114 | 750 | 800 | 2024-06-28 |
| 7897 | Strawberry Shortcake 7897 | 114 114 | 720 | 770 | 2024-06-28 |
| 7898 | Chocolate Chunk Monster Cookie 7898 | 114 114 | 390 | 440 | 2024-06-28 |
| 7899 | Banana Walnut Muffin 7899 | 114 114 | 450 | 500 | 2024-06-28 |
| 7900 | Blueberry Crumble Muffin 7900 | 114 114 | 450 | 500 | 2024-06-28 |
| 7901 | Chocolate Crumble Muffin 7901 | 114 114 | 450 | 500 | 2024-06-28 |
| 7902 | Pancakes 7902 | 114 114 | 550 | 600 | 2024-06-28 |
| 7903 | Almond Croissant 7903 | 114 114 | 470 | 520 | 2024-06-28 |
| 7904 | Buttery Croissant 7904 | 114 114 | 400 | 430 | 2024-06-28 |
| 7905 | Chocolate Croissant 7905 | 114 114 | 440 | 490 | 2024-06-28 |
| 7906 | Creamy Chicken Foldover 7906 | 114 114 | 550 | 600 | 2024-06-28 |
| 7907 | Sausage Roll 7907 | 114 114 | 550 | 600 | 2024-06-28 |
| 7908 | Buttery Scone 7908 | 114 114 | 400 | 430 | 2024-06-28 |
| 7909 | Country Chicken Pie 7909 | 114 114 | 690 | 740 | 2024-06-28 |
| 7910 | Deep Dish Beef Pie 7910 | 114 114 | 690 | 740 | 2024-06-28 |
| 7911 | Spinach & Mushroom Quiche 7911 | 114 114 | 690 | 740 | 2024-06-28 |
| 7912 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 7912 | 114 114 | 390 | 420 | 2024-06-28 |
| 7913 | Mixed Nuts 7913 | 114 114 | 490 | 540 | 2024-06-28 |
| 7914 | Caramel Waffles 7914 | 114 114 | 390 | 420 | 2024-06-28 |
| 7915 | Chicken Ham & Cheese Panwich 7915 | 114 114 | 690 | 740 | 2024-06-28 |
| 7916 | Egg Mayo & Cheese Multigrain Croissant 7916 | 114 114 | 690 | 740 | 2024-06-28 |
| 7917 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 7917 | 114 114 | 690 | 740 | 2024-06-28 |
| 7918 | Rosemary Chicken & Emmental Cheese Croissant 7918 | 114 114 | 690 | 740 | 2024-06-28 |
| 7919 | Scrambled Egg & Turkey Ham Pita 7919 | 114 114 | 690 | 740 | 2024-06-28 |
| 7920 | Turkey Ham & Triple Cheese Toast 7920 | 114 114 | 690 | 740 | 2024-06-28 |
| 7921 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 7921 | 114 114 | 790 | 840 | 2024-06-28 |
| 7922 | Ham & Cheese Croissant 7922 | 114 114 | 690 | 740 | 2024-06-28 |
| 7923 | Sriracha Chicken Whole Wheat Pita 7923 | 114 114 | 750 | 800 | 2024-06-28 |
| 7924 | Blueberry Acai Yogurt Parfait 7924 | 114 114 | 650 | 700 | 2024-06-28 |
| 7925 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 7925 | 114 114 | 650 | 700 | 2024-06-28 |
| 7926 | Caramel Frappuccino® 7926 | 114 114 | 720 | 770 | 2024-06-28 |
| 7927 | Dark Mocha Frappuccino® 7927 | 114 114 | 780 | 830 | 2024-06-28 |
| 7928 | Java Chip Frappuccino® 7928 | 114 114 | 780 | 830 | 2024-06-28 |
| 7929 | Mocha Frappuccino® 7929 | 114 114 | 720 | 770 | 2024-06-28 |
| 7930 | Caramel Macchiato Frappuccino® 7930 | 114 114 | 780 | 830 | 2024-06-28 |
| 7931 | Espresso Frappuccino® 7931 | 114 114 | 720 | 770 | 2024-06-28 |
| 7932 | White Chocolate Mocha Frappuccino® 7932 | 114 114 | 720 | 770 | 2024-06-28 |
| 7933 | Chocolate Chip Cream Frappuccino® 7933 | 114 114 | 780 | 830 | 2024-06-28 |
| 7934 | Hojicha Tea Cream Frappuccino® 7934 | 114 114 | 760 | 810 | 2024-06-28 |
| 7935 | Vanilla Cream Frappuccino® 7935 | 114 114 | 720 | 770 | 2024-06-28 |
| 7936 | Mango Passion Fruit & Hibiscus 7936 | 114 114 | 720 | 770 | 2024-06-28 |
| 7937 | Raspberry Black Currant & Oolong 7937 | 114 114 | 720 | 770 | 2024-06-28 |
| 7938 | Coffee Traveller 7938 | 114 114 | 3120 | 3170 | 2024-06-28 |
| 7939 | Caffè Americano 7939 | 114 114 | 540 | 590 | 2024-06-28 |
| 7940 | Cappuccino 7940 | 114 114 | 680 | 730 | 2024-06-28 |
| 7941 | Caffè Mocha 7941 | 114 114 | 750 | 800 | 2024-06-28 |
| 7942 | Caramel Macchiato 7942 | 114 114 | 760 | 810 | 2024-06-28 |
| 7943 | Espresso 7943 | 114 114 | 390 | 440 | 2024-06-28 |
| 7944 | Caffè Latte 7944 | 114 114 | 680 | 730 | 2024-06-28 |
| 7945 | Oatmilk Latte 7945 | 114 114 | 760 | 810 | 2024-06-28 |
| 7946 | Vanilla Latte 7946 | 114 114 | 750 | 800 | 2024-06-28 |
| 7947 | White Chocolate Mocha 7947 | 114 114 | 750 | 800 | 2024-06-28 |
| 7948 | Flat White 7948 | 114 114 | 760 | 810 | 2024-06-28 |
| 7949 | Ristretto Bianco 7949 | 114 114 | 760 | 810 | 2024-06-28 |
| 7950 | Iced Caffè Americano 7950 | 114 114 | 540 | 590 | 2024-06-28 |
| 7951 | Iced Cappuccino 7951 | 114 114 | 680 | 730 | 2024-06-28 |
| 7952 | Iced Caffè Mocha 7952 | 114 114 | 750 | 800 | 2024-06-28 |
| 7953 | Iced Caramel Macchiato 7953 | 114 114 | 760 | 810 | 2024-06-28 |
| 7954 | Iced Caffè Latte 7954 | 114 114 | 680 | 730 | 2024-06-28 |
| 7955 | Iced Oatmilk Latte 7955 | 114 114 | 760 | 810 | 2024-06-28 |
| 7956 | Iced Vanilla Latte 7956 | 114 114 | 750 | 800 | 2024-06-28 |
| 7957 | Iced White Chocolate Mocha 7957 | 114 114 | 750 | 800 | 2024-06-28 |
| 7958 | Signature Hot Chocolate 7958 | 114 114 | 720 | 770 | 2024-06-28 |
| 7959 | Signature Iced Chocolate 7959 | 114 114 | 720 | 770 | 2024-06-28 |
| 7960 | Carrot Juice 7960 | 114 114 | 490 | 540 | 2024-06-28 |
| 7961 | Cloudy Apple Juice 7961 | 114 114 | 490 | 540 | 2024-06-28 |
| 7962 | Cranberry Red Grapefruit Juice 7962 | 114 114 | 490 | 540 | 2024-06-28 |
| 7963 | Orange Juice 7963 | 114 114 | 490 | 540 | 2024-06-28 |
| 7964 | Evian 7964 | 114 114 | 350 | 400 | 2024-06-28 |
| 7965 | Sparkling Water 7965 | 114 114 | 450 | 500 | 2024-06-28 |
| 7966 | Chai Tea 7966 | 114 114 | 500 | 550 | 2024-06-28 |
| 7967 | Earl Grey Tea 7967 | 114 114 | 500 | 550 | 2024-06-28 |
| 7968 | English Breakfast Tea 7968 | 114 114 | 500 | 550 | 2024-06-28 |
| 7969 | Emperor’s Clouds & Mist™ Tea 7969 | 114 114 | 500 | 550 | 2024-06-28 |
| 7970 | Mint Blend Tea 7970 | 114 114 | 500 | 550 | 2024-06-28 |
| 7971 | Chamomile Tea 7971 | 114 114 | 500 | 550 | 2024-06-28 |
| 7972 | Pure Matcha Latte 7972 | 114 114 | 740 | 790 | 2024-06-28 |
| 7973 | Chai Tea Latte 7973 | 114 114 | 680 | 730 | 2024-06-28 |
| 7974 | Earl Grey Tea Latte 7974 | 114 114 | 680 | 730 | 2024-06-28 |
| 7975 | English Breakfast Tea Latte 7975 | 114 114 | 680 | 730 | 2024-06-28 |
| 7976 | Hojicha Tea Latte 7976 | 114 114 | 740 | 790 | 2024-06-28 |
| 7977 | Zen Clouds Oolong Tea 7977 | 114 114 | 500 | 550 | 2024-06-28 |
| 7978 | Zen Clouds Oolong with Ruby Grapefruit and Honey 7978 | 114 114 | 630 | 680 | 2024-06-28 |
| 7979 | Youthberry™ Tea 7979 | 114 114 | 500 | 550 | 2024-06-28 |
| 7980 | Iced Shaken Black Tea Lemonade 7980 | 114 114 | 610 | 660 | 2024-06-28 |
| 7981 | Iced Shaken Strawberry Black Tea Lemonade 7981 | 114 114 | 630 | 680 | 2024-06-28 |
| 7982 | Iced Shaken Hibiscus Tea Lemonade 7982 | 114 114 | 610 | 660 | 2024-06-28 |
| 7983 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 7983 | 114 114 | 730 | 780 | 2024-06-28 |
| 7984 | Iced Pure Matcha Latte 7984 | 114 114 | 740 | 790 | 2024-06-28 |
| 7985 | Iced Chai Tea Latte 7985 | 114 114 | 680 | 730 | 2024-06-28 |
| 7986 | Iced Black Tea Latte 7986 | 114 114 | 680 | 730 | 2024-06-28 |
| 7987 | Iced Hojicha Tea Latte 7987 | 114 114 | 740 | 790 | 2024-06-28 |
| 7988 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 7988 | 114 114 | 630 | 680 | 2024-06-28 |
| 7989 | Iced Shaken Zen Clouds Oolong Lemonade 7989 | 114 114 | 610 | 660 | 2024-06-28 |
| 7990 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 7990 | 114 114 | 630 | 680 | 2024-06-28 |
| 7991 | Origami Pike Place® Roast 7991 | 114 114 | 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");