item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 28
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
- 28 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 21987 | Bagel 21987 | 28 28 | 400 | 430 | 2024-06-28 |
| 21988 | Cookie Crumble Cheesecake 21988 | 28 28 | 720 | 770 | 2024-06-28 |
| 21989 | Good Ol' NY Cheesecake 21989 | 28 28 | 720 | 770 | 2024-06-28 |
| 21990 | Signature Chocolate Cake 21990 | 28 28 | 720 | 770 | 2024-06-28 |
| 21991 | Starbucks® Coffee Tiramisu Cake 21991 | 28 28 | 750 | 800 | 2024-06-28 |
| 21992 | Strawberry Shortcake 21992 | 28 28 | 720 | 770 | 2024-06-28 |
| 21993 | Chocolate Chunk Monster Cookie 21993 | 28 28 | 390 | 440 | 2024-06-28 |
| 21994 | Banana Walnut Muffin 21994 | 28 28 | 450 | 500 | 2024-06-28 |
| 21995 | Blueberry Crumble Muffin 21995 | 28 28 | 450 | 500 | 2024-06-28 |
| 21996 | Chocolate Crumble Muffin 21996 | 28 28 | 450 | 500 | 2024-06-28 |
| 21997 | Pancakes 21997 | 28 28 | 550 | 600 | 2024-06-28 |
| 21998 | Almond Croissant 21998 | 28 28 | 470 | 520 | 2024-06-28 |
| 21999 | Buttery Croissant 21999 | 28 28 | 400 | 430 | 2024-06-28 |
| 22000 | Chocolate Croissant 22000 | 28 28 | 440 | 490 | 2024-06-28 |
| 22001 | Creamy Chicken Foldover 22001 | 28 28 | 550 | 600 | 2024-06-28 |
| 22002 | Sausage Roll 22002 | 28 28 | 550 | 600 | 2024-06-28 |
| 22003 | Buttery Scone 22003 | 28 28 | 400 | 430 | 2024-06-28 |
| 22004 | Country Chicken Pie 22004 | 28 28 | 690 | 740 | 2024-06-28 |
| 22005 | Deep Dish Beef Pie 22005 | 28 28 | 690 | 740 | 2024-06-28 |
| 22006 | Spinach & Mushroom Quiche 22006 | 28 28 | 690 | 740 | 2024-06-28 |
| 22007 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 22007 | 28 28 | 390 | 420 | 2024-06-28 |
| 22008 | Mixed Nuts 22008 | 28 28 | 490 | 540 | 2024-06-28 |
| 22009 | Caramel Waffles 22009 | 28 28 | 390 | 420 | 2024-06-28 |
| 22010 | Chicken Ham & Cheese Panwich 22010 | 28 28 | 690 | 740 | 2024-06-28 |
| 22011 | Egg Mayo & Cheese Multigrain Croissant 22011 | 28 28 | 690 | 740 | 2024-06-28 |
| 22012 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 22012 | 28 28 | 690 | 740 | 2024-06-28 |
| 22013 | Rosemary Chicken & Emmental Cheese Croissant 22013 | 28 28 | 690 | 740 | 2024-06-28 |
| 22014 | Scrambled Egg & Turkey Ham Pita 22014 | 28 28 | 690 | 740 | 2024-06-28 |
| 22015 | Turkey Ham & Triple Cheese Toast 22015 | 28 28 | 690 | 740 | 2024-06-28 |
| 22016 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 22016 | 28 28 | 790 | 840 | 2024-06-28 |
| 22017 | Ham & Cheese Croissant 22017 | 28 28 | 690 | 740 | 2024-06-28 |
| 22018 | Sriracha Chicken Whole Wheat Pita 22018 | 28 28 | 750 | 800 | 2024-06-28 |
| 22019 | Blueberry Acai Yogurt Parfait 22019 | 28 28 | 650 | 700 | 2024-06-28 |
| 22020 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 22020 | 28 28 | 650 | 700 | 2024-06-28 |
| 22021 | Caramel Frappuccino® 22021 | 28 28 | 720 | 770 | 2024-06-28 |
| 22022 | Dark Mocha Frappuccino® 22022 | 28 28 | 780 | 830 | 2024-06-28 |
| 22023 | Java Chip Frappuccino® 22023 | 28 28 | 780 | 830 | 2024-06-28 |
| 22024 | Mocha Frappuccino® 22024 | 28 28 | 720 | 770 | 2024-06-28 |
| 22025 | Caramel Macchiato Frappuccino® 22025 | 28 28 | 780 | 830 | 2024-06-28 |
| 22026 | Espresso Frappuccino® 22026 | 28 28 | 720 | 770 | 2024-06-28 |
| 22027 | White Chocolate Mocha Frappuccino® 22027 | 28 28 | 720 | 770 | 2024-06-28 |
| 22028 | Chocolate Chip Cream Frappuccino® 22028 | 28 28 | 780 | 830 | 2024-06-28 |
| 22029 | Hojicha Tea Cream Frappuccino® 22029 | 28 28 | 760 | 810 | 2024-06-28 |
| 22030 | Vanilla Cream Frappuccino® 22030 | 28 28 | 720 | 770 | 2024-06-28 |
| 22031 | Mango Passion Fruit & Hibiscus 22031 | 28 28 | 720 | 770 | 2024-06-28 |
| 22032 | Raspberry Black Currant & Oolong 22032 | 28 28 | 720 | 770 | 2024-06-28 |
| 22033 | Coffee Traveller 22033 | 28 28 | 3120 | 3170 | 2024-06-28 |
| 22034 | Caffè Americano 22034 | 28 28 | 540 | 590 | 2024-06-28 |
| 22035 | Cappuccino 22035 | 28 28 | 680 | 730 | 2024-06-28 |
| 22036 | Caffè Mocha 22036 | 28 28 | 750 | 800 | 2024-06-28 |
| 22037 | Caramel Macchiato 22037 | 28 28 | 760 | 810 | 2024-06-28 |
| 22038 | Espresso 22038 | 28 28 | 390 | 440 | 2024-06-28 |
| 22039 | Caffè Latte 22039 | 28 28 | 680 | 730 | 2024-06-28 |
| 22040 | Oatmilk Latte 22040 | 28 28 | 760 | 810 | 2024-06-28 |
| 22041 | Vanilla Latte 22041 | 28 28 | 750 | 800 | 2024-06-28 |
| 22042 | White Chocolate Mocha 22042 | 28 28 | 750 | 800 | 2024-06-28 |
| 22043 | Flat White 22043 | 28 28 | 760 | 810 | 2024-06-28 |
| 22044 | Ristretto Bianco 22044 | 28 28 | 760 | 810 | 2024-06-28 |
| 22045 | Iced Caffè Americano 22045 | 28 28 | 540 | 590 | 2024-06-28 |
| 22046 | Iced Cappuccino 22046 | 28 28 | 680 | 730 | 2024-06-28 |
| 22047 | Iced Caffè Mocha 22047 | 28 28 | 750 | 800 | 2024-06-28 |
| 22048 | Iced Caramel Macchiato 22048 | 28 28 | 760 | 810 | 2024-06-28 |
| 22049 | Iced Caffè Latte 22049 | 28 28 | 680 | 730 | 2024-06-28 |
| 22050 | Iced Oatmilk Latte 22050 | 28 28 | 760 | 810 | 2024-06-28 |
| 22051 | Iced Vanilla Latte 22051 | 28 28 | 750 | 800 | 2024-06-28 |
| 22052 | Iced White Chocolate Mocha 22052 | 28 28 | 750 | 800 | 2024-06-28 |
| 22053 | Signature Hot Chocolate 22053 | 28 28 | 720 | 770 | 2024-06-28 |
| 22054 | Signature Iced Chocolate 22054 | 28 28 | 720 | 770 | 2024-06-28 |
| 22055 | Carrot Juice 22055 | 28 28 | 490 | 540 | 2024-06-28 |
| 22056 | Cloudy Apple Juice 22056 | 28 28 | 490 | 540 | 2024-06-28 |
| 22057 | Cranberry Red Grapefruit Juice 22057 | 28 28 | 490 | 540 | 2024-06-28 |
| 22058 | Orange Juice 22058 | 28 28 | 490 | 540 | 2024-06-28 |
| 22059 | Evian 22059 | 28 28 | 350 | 400 | 2024-06-28 |
| 22060 | Sparkling Water 22060 | 28 28 | 450 | 500 | 2024-06-28 |
| 22061 | Chai Tea 22061 | 28 28 | 500 | 550 | 2024-06-28 |
| 22062 | Earl Grey Tea 22062 | 28 28 | 500 | 550 | 2024-06-28 |
| 22063 | English Breakfast Tea 22063 | 28 28 | 500 | 550 | 2024-06-28 |
| 22064 | Emperor’s Clouds & Mist™ Tea 22064 | 28 28 | 500 | 550 | 2024-06-28 |
| 22065 | Mint Blend Tea 22065 | 28 28 | 500 | 550 | 2024-06-28 |
| 22066 | Chamomile Tea 22066 | 28 28 | 500 | 550 | 2024-06-28 |
| 22067 | Pure Matcha Latte 22067 | 28 28 | 740 | 790 | 2024-06-28 |
| 22068 | Chai Tea Latte 22068 | 28 28 | 680 | 730 | 2024-06-28 |
| 22069 | Earl Grey Tea Latte 22069 | 28 28 | 680 | 730 | 2024-06-28 |
| 22070 | English Breakfast Tea Latte 22070 | 28 28 | 680 | 730 | 2024-06-28 |
| 22071 | Hojicha Tea Latte 22071 | 28 28 | 740 | 790 | 2024-06-28 |
| 22072 | Zen Clouds Oolong Tea 22072 | 28 28 | 500 | 550 | 2024-06-28 |
| 22073 | Zen Clouds Oolong with Ruby Grapefruit and Honey 22073 | 28 28 | 630 | 680 | 2024-06-28 |
| 22074 | Youthberry™ Tea 22074 | 28 28 | 500 | 550 | 2024-06-28 |
| 22075 | Iced Shaken Black Tea Lemonade 22075 | 28 28 | 610 | 660 | 2024-06-28 |
| 22076 | Iced Shaken Strawberry Black Tea Lemonade 22076 | 28 28 | 630 | 680 | 2024-06-28 |
| 22077 | Iced Shaken Hibiscus Tea Lemonade 22077 | 28 28 | 610 | 660 | 2024-06-28 |
| 22078 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 22078 | 28 28 | 730 | 780 | 2024-06-28 |
| 22079 | Iced Pure Matcha Latte 22079 | 28 28 | 740 | 790 | 2024-06-28 |
| 22080 | Iced Chai Tea Latte 22080 | 28 28 | 680 | 730 | 2024-06-28 |
| 22081 | Iced Black Tea Latte 22081 | 28 28 | 680 | 730 | 2024-06-28 |
| 22082 | Iced Hojicha Tea Latte 22082 | 28 28 | 740 | 790 | 2024-06-28 |
| 22083 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 22083 | 28 28 | 630 | 680 | 2024-06-28 |
| 22084 | Iced Shaken Zen Clouds Oolong Lemonade 22084 | 28 28 | 610 | 660 | 2024-06-28 |
| 22085 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 22085 | 28 28 | 630 | 680 | 2024-06-28 |
| 22086 | Origami Pike Place® Roast 22086 | 28 28 | 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");