item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
238 rows where store_id = 91
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 11
- 2024-06-28 184
- 2024-09-15 10
- 2024-11-03 9
- 2024-07-17 7
- 2024-08-18 6
- 2024-07-28 5
- 2024-10-13 5
- 2024-07-03 4
- 2024-10-06 4
- 2024-07-14 2
- 2024-09-29 2
store_id 1
- 91 · 238 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 11902 | Bagel 11902 | 91 91 | 400 | 430 | 2024-06-28 |
| 11903 | Cookie Crumble Cheesecake 11903 | 91 91 | 720 | 770 | 2024-06-28 |
| 11904 | Good Ol' NY Cheesecake 11904 | 91 91 | 720 | 770 | 2024-06-28 |
| 11905 | Signature Chocolate Cake 11905 | 91 91 | 720 | 770 | 2024-06-28 |
| 11906 | Starbucks® Coffee Tiramisu Cake 11906 | 91 91 | 750 | 800 | 2024-06-28 |
| 11907 | Strawberry Shortcake 11907 | 91 91 | 720 | 770 | 2024-06-28 |
| 11908 | Chocolate Chunk Monster Cookie 11908 | 91 91 | 390 | 440 | 2024-06-28 |
| 11909 | Banana Walnut Muffin 11909 | 91 91 | 450 | 500 | 2024-06-28 |
| 11910 | Blueberry Crumble Muffin 11910 | 91 91 | 450 | 500 | 2024-06-28 |
| 11911 | Chocolate Crumble Muffin 11911 | 91 91 | 450 | 500 | 2024-06-28 |
| 11912 | Pancakes 11912 | 91 91 | 550 | 600 | 2024-06-28 |
| 11913 | Almond Croissant 11913 | 91 91 | 470 | 520 | 2024-06-28 |
| 11914 | Buttery Croissant 11914 | 91 91 | 400 | 430 | 2024-06-28 |
| 11915 | Chocolate Croissant 11915 | 91 91 | 440 | 490 | 2024-06-28 |
| 11916 | Creamy Chicken Foldover 11916 | 91 91 | 550 | 600 | 2024-06-28 |
| 11917 | Sausage Roll 11917 | 91 91 | 550 | 600 | 2024-06-28 |
| 11918 | Buttery Scone 11918 | 91 91 | 400 | 430 | 2024-06-28 |
| 11919 | Country Chicken Pie 11919 | 91 91 | 690 | 740 | 2024-06-28 |
| 11920 | Deep Dish Beef Pie 11920 | 91 91 | 690 | 740 | 2024-06-28 |
| 11921 | Spinach & Mushroom Quiche 11921 | 91 91 | 690 | 740 | 2024-06-28 |
| 11922 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 11922 | 91 91 | 390 | 420 | 2024-06-28 |
| 11923 | Mixed Nuts 11923 | 91 91 | 490 | 540 | 2024-06-28 |
| 11924 | Caramel Waffles 11924 | 91 91 | 390 | 420 | 2024-06-28 |
| 11925 | Chicken Ham & Cheese Panwich 11925 | 91 91 | 690 | 740 | 2024-06-28 |
| 11926 | Egg Mayo & Cheese Multigrain Croissant 11926 | 91 91 | 690 | 740 | 2024-06-28 |
| 11927 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 11927 | 91 91 | 690 | 740 | 2024-06-28 |
| 11928 | Rosemary Chicken & Emmental Cheese Croissant 11928 | 91 91 | 690 | 740 | 2024-06-28 |
| 11929 | Scrambled Egg & Turkey Ham Pita 11929 | 91 91 | 690 | 740 | 2024-06-28 |
| 11930 | Turkey Ham & Triple Cheese Toast 11930 | 91 91 | 690 | 740 | 2024-06-28 |
| 11931 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 11931 | 91 91 | 790 | 840 | 2024-06-28 |
| 11932 | Ham & Cheese Croissant 11932 | 91 91 | 690 | 740 | 2024-06-28 |
| 11933 | Sriracha Chicken Whole Wheat Pita 11933 | 91 91 | 750 | 800 | 2024-06-28 |
| 11934 | Blueberry Acai Yogurt Parfait 11934 | 91 91 | 650 | 700 | 2024-06-28 |
| 11935 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 11935 | 91 91 | 650 | 700 | 2024-06-28 |
| 11936 | Caramel Frappuccino® 11936 | 91 91 | 720 | 770 | 2024-06-28 |
| 11937 | Dark Mocha Frappuccino® 11937 | 91 91 | 780 | 830 | 2024-06-28 |
| 11938 | Java Chip Frappuccino® 11938 | 91 91 | 780 | 830 | 2024-06-28 |
| 11939 | Mocha Frappuccino® 11939 | 91 91 | 720 | 770 | 2024-06-28 |
| 11940 | Caramel Macchiato Frappuccino® 11940 | 91 91 | 780 | 830 | 2024-06-28 |
| 11941 | Espresso Frappuccino® 11941 | 91 91 | 720 | 770 | 2024-06-28 |
| 11942 | White Chocolate Mocha Frappuccino® 11942 | 91 91 | 720 | 770 | 2024-06-28 |
| 11943 | Chocolate Chip Cream Frappuccino® 11943 | 91 91 | 780 | 830 | 2024-06-28 |
| 11944 | Hojicha Tea Cream Frappuccino® 11944 | 91 91 | 760 | 810 | 2024-06-28 |
| 11945 | Vanilla Cream Frappuccino® 11945 | 91 91 | 720 | 770 | 2024-06-28 |
| 11946 | Mango Passion Fruit & Hibiscus 11946 | 91 91 | 720 | 770 | 2024-06-28 |
| 11947 | Raspberry Black Currant & Oolong 11947 | 91 91 | 720 | 770 | 2024-06-28 |
| 11948 | Coffee Traveller 11948 | 91 91 | 3120 | 3170 | 2024-06-28 |
| 11949 | Caffè Americano 11949 | 91 91 | 540 | 590 | 2024-06-28 |
| 11950 | Cappuccino 11950 | 91 91 | 680 | 730 | 2024-06-28 |
| 11951 | Caffè Mocha 11951 | 91 91 | 750 | 800 | 2024-06-28 |
| 11952 | Caramel Macchiato 11952 | 91 91 | 760 | 810 | 2024-06-28 |
| 11953 | Espresso 11953 | 91 91 | 390 | 440 | 2024-06-28 |
| 11954 | Caffè Latte 11954 | 91 91 | 680 | 730 | 2024-06-28 |
| 11955 | Oatmilk Latte 11955 | 91 91 | 760 | 810 | 2024-06-28 |
| 11956 | Vanilla Latte 11956 | 91 91 | 750 | 800 | 2024-06-28 |
| 11957 | White Chocolate Mocha 11957 | 91 91 | 750 | 800 | 2024-06-28 |
| 11958 | Flat White 11958 | 91 91 | 760 | 810 | 2024-06-28 |
| 11959 | Ristretto Bianco 11959 | 91 91 | 760 | 810 | 2024-06-28 |
| 11960 | Iced Caffè Americano 11960 | 91 91 | 540 | 590 | 2024-06-28 |
| 11961 | Iced Cappuccino 11961 | 91 91 | 680 | 730 | 2024-06-28 |
| 11962 | Iced Caffè Mocha 11962 | 91 91 | 750 | 800 | 2024-06-28 |
| 11963 | Iced Caramel Macchiato 11963 | 91 91 | 760 | 810 | 2024-06-28 |
| 11964 | Iced Caffè Latte 11964 | 91 91 | 680 | 730 | 2024-06-28 |
| 11965 | Iced Oatmilk Latte 11965 | 91 91 | 760 | 810 | 2024-06-28 |
| 11966 | Iced Vanilla Latte 11966 | 91 91 | 750 | 800 | 2024-06-28 |
| 11967 | Iced White Chocolate Mocha 11967 | 91 91 | 750 | 800 | 2024-06-28 |
| 11968 | Signature Hot Chocolate 11968 | 91 91 | 720 | 770 | 2024-06-28 |
| 11969 | Signature Iced Chocolate 11969 | 91 91 | 720 | 770 | 2024-06-28 |
| 11970 | Carrot Juice 11970 | 91 91 | 490 | 540 | 2024-06-28 |
| 11971 | Cloudy Apple Juice 11971 | 91 91 | 490 | 540 | 2024-06-28 |
| 11972 | Cranberry Red Grapefruit Juice 11972 | 91 91 | 490 | 540 | 2024-06-28 |
| 11973 | Orange Juice 11973 | 91 91 | 490 | 540 | 2024-06-28 |
| 11974 | Evian 11974 | 91 91 | 350 | 400 | 2024-06-28 |
| 11975 | Sparkling Water 11975 | 91 91 | 450 | 500 | 2024-06-28 |
| 11976 | Chai Tea 11976 | 91 91 | 500 | 550 | 2024-06-28 |
| 11977 | Earl Grey Tea 11977 | 91 91 | 500 | 550 | 2024-06-28 |
| 11978 | English Breakfast Tea 11978 | 91 91 | 500 | 550 | 2024-06-28 |
| 11979 | Emperor’s Clouds & Mist™ Tea 11979 | 91 91 | 500 | 550 | 2024-06-28 |
| 11980 | Mint Blend Tea 11980 | 91 91 | 500 | 550 | 2024-06-28 |
| 11981 | Chamomile Tea 11981 | 91 91 | 500 | 550 | 2024-06-28 |
| 11982 | Pure Matcha Latte 11982 | 91 91 | 740 | 790 | 2024-06-28 |
| 11983 | Chai Tea Latte 11983 | 91 91 | 680 | 730 | 2024-06-28 |
| 11984 | Earl Grey Tea Latte 11984 | 91 91 | 680 | 730 | 2024-06-28 |
| 11985 | English Breakfast Tea Latte 11985 | 91 91 | 680 | 730 | 2024-06-28 |
| 11986 | Hojicha Tea Latte 11986 | 91 91 | 740 | 790 | 2024-06-28 |
| 11987 | Zen Clouds Oolong Tea 11987 | 91 91 | 500 | 550 | 2024-06-28 |
| 11988 | Zen Clouds Oolong with Ruby Grapefruit and Honey 11988 | 91 91 | 630 | 680 | 2024-06-28 |
| 11989 | Youthberry™ Tea 11989 | 91 91 | 500 | 550 | 2024-06-28 |
| 11990 | Iced Shaken Black Tea Lemonade 11990 | 91 91 | 610 | 660 | 2024-06-28 |
| 11991 | Iced Shaken Strawberry Black Tea Lemonade 11991 | 91 91 | 630 | 680 | 2024-06-28 |
| 11992 | Iced Shaken Hibiscus Tea Lemonade 11992 | 91 91 | 610 | 660 | 2024-06-28 |
| 11993 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 11993 | 91 91 | 730 | 780 | 2024-06-28 |
| 11994 | Iced Pure Matcha Latte 11994 | 91 91 | 740 | 790 | 2024-06-28 |
| 11995 | Iced Chai Tea Latte 11995 | 91 91 | 680 | 730 | 2024-06-28 |
| 11996 | Iced Black Tea Latte 11996 | 91 91 | 680 | 730 | 2024-06-28 |
| 11997 | Iced Hojicha Tea Latte 11997 | 91 91 | 740 | 790 | 2024-06-28 |
| 11998 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 11998 | 91 91 | 630 | 680 | 2024-06-28 |
| 11999 | Iced Shaken Zen Clouds Oolong Lemonade 11999 | 91 91 | 610 | 660 | 2024-06-28 |
| 12000 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 12000 | 91 91 | 630 | 680 | 2024-06-28 |
| 12001 | Origami Pike Place® Roast 12001 | 91 91 | 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");