item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 17
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
- 17 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 23994 | Bagel 23994 | 17 17 | 400 | 430 | 2024-06-28 |
| 23995 | Cookie Crumble Cheesecake 23995 | 17 17 | 720 | 770 | 2024-06-28 |
| 23996 | Good Ol' NY Cheesecake 23996 | 17 17 | 720 | 770 | 2024-06-28 |
| 23997 | Signature Chocolate Cake 23997 | 17 17 | 720 | 770 | 2024-06-28 |
| 23998 | Starbucks® Coffee Tiramisu Cake 23998 | 17 17 | 750 | 800 | 2024-06-28 |
| 23999 | Strawberry Shortcake 23999 | 17 17 | 720 | 770 | 2024-06-28 |
| 24000 | Chocolate Chunk Monster Cookie 24000 | 17 17 | 390 | 440 | 2024-06-28 |
| 24001 | Banana Walnut Muffin 24001 | 17 17 | 450 | 500 | 2024-06-28 |
| 24002 | Blueberry Crumble Muffin 24002 | 17 17 | 450 | 500 | 2024-06-28 |
| 24003 | Chocolate Crumble Muffin 24003 | 17 17 | 450 | 500 | 2024-06-28 |
| 24004 | Pancakes 24004 | 17 17 | 550 | 600 | 2024-06-28 |
| 24005 | Almond Croissant 24005 | 17 17 | 470 | 520 | 2024-06-28 |
| 24006 | Buttery Croissant 24006 | 17 17 | 400 | 430 | 2024-06-28 |
| 24007 | Chocolate Croissant 24007 | 17 17 | 440 | 490 | 2024-06-28 |
| 24008 | Creamy Chicken Foldover 24008 | 17 17 | 550 | 600 | 2024-06-28 |
| 24009 | Sausage Roll 24009 | 17 17 | 550 | 600 | 2024-06-28 |
| 24010 | Buttery Scone 24010 | 17 17 | 400 | 430 | 2024-06-28 |
| 24011 | Country Chicken Pie 24011 | 17 17 | 690 | 740 | 2024-06-28 |
| 24012 | Deep Dish Beef Pie 24012 | 17 17 | 690 | 740 | 2024-06-28 |
| 24013 | Spinach & Mushroom Quiche 24013 | 17 17 | 690 | 740 | 2024-06-28 |
| 24014 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 24014 | 17 17 | 390 | 420 | 2024-06-28 |
| 24015 | Mixed Nuts 24015 | 17 17 | 490 | 540 | 2024-06-28 |
| 24016 | Caramel Waffles 24016 | 17 17 | 390 | 420 | 2024-06-28 |
| 24017 | Chicken Ham & Cheese Panwich 24017 | 17 17 | 690 | 740 | 2024-06-28 |
| 24018 | Egg Mayo & Cheese Multigrain Croissant 24018 | 17 17 | 690 | 740 | 2024-06-28 |
| 24019 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 24019 | 17 17 | 690 | 740 | 2024-06-28 |
| 24020 | Rosemary Chicken & Emmental Cheese Croissant 24020 | 17 17 | 690 | 740 | 2024-06-28 |
| 24021 | Scrambled Egg & Turkey Ham Pita 24021 | 17 17 | 690 | 740 | 2024-06-28 |
| 24022 | Turkey Ham & Triple Cheese Toast 24022 | 17 17 | 690 | 740 | 2024-06-28 |
| 24023 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 24023 | 17 17 | 790 | 840 | 2024-06-28 |
| 24024 | Ham & Cheese Croissant 24024 | 17 17 | 690 | 740 | 2024-06-28 |
| 24025 | Sriracha Chicken Whole Wheat Pita 24025 | 17 17 | 750 | 800 | 2024-06-28 |
| 24026 | Blueberry Acai Yogurt Parfait 24026 | 17 17 | 650 | 700 | 2024-06-28 |
| 24027 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 24027 | 17 17 | 650 | 700 | 2024-06-28 |
| 24028 | Caramel Frappuccino® 24028 | 17 17 | 720 | 770 | 2024-06-28 |
| 24029 | Dark Mocha Frappuccino® 24029 | 17 17 | 780 | 830 | 2024-06-28 |
| 24030 | Java Chip Frappuccino® 24030 | 17 17 | 780 | 830 | 2024-06-28 |
| 24031 | Mocha Frappuccino® 24031 | 17 17 | 720 | 770 | 2024-06-28 |
| 24032 | Caramel Macchiato Frappuccino® 24032 | 17 17 | 780 | 830 | 2024-06-28 |
| 24033 | Espresso Frappuccino® 24033 | 17 17 | 720 | 770 | 2024-06-28 |
| 24034 | White Chocolate Mocha Frappuccino® 24034 | 17 17 | 720 | 770 | 2024-06-28 |
| 24035 | Chocolate Chip Cream Frappuccino® 24035 | 17 17 | 780 | 830 | 2024-06-28 |
| 24036 | Hojicha Tea Cream Frappuccino® 24036 | 17 17 | 760 | 810 | 2024-06-28 |
| 24037 | Vanilla Cream Frappuccino® 24037 | 17 17 | 720 | 770 | 2024-06-28 |
| 24038 | Mango Passion Fruit & Hibiscus 24038 | 17 17 | 720 | 770 | 2024-06-28 |
| 24039 | Raspberry Black Currant & Oolong 24039 | 17 17 | 720 | 770 | 2024-06-28 |
| 24040 | Coffee Traveller 24040 | 17 17 | 3120 | 3170 | 2024-06-28 |
| 24041 | Caffè Americano 24041 | 17 17 | 540 | 590 | 2024-06-28 |
| 24042 | Cappuccino 24042 | 17 17 | 680 | 730 | 2024-06-28 |
| 24043 | Caffè Mocha 24043 | 17 17 | 750 | 800 | 2024-06-28 |
| 24044 | Caramel Macchiato 24044 | 17 17 | 760 | 810 | 2024-06-28 |
| 24045 | Espresso 24045 | 17 17 | 390 | 440 | 2024-06-28 |
| 24046 | Caffè Latte 24046 | 17 17 | 680 | 730 | 2024-06-28 |
| 24047 | Oatmilk Latte 24047 | 17 17 | 760 | 810 | 2024-06-28 |
| 24048 | Vanilla Latte 24048 | 17 17 | 750 | 800 | 2024-06-28 |
| 24049 | White Chocolate Mocha 24049 | 17 17 | 750 | 800 | 2024-06-28 |
| 24050 | Flat White 24050 | 17 17 | 760 | 810 | 2024-06-28 |
| 24051 | Ristretto Bianco 24051 | 17 17 | 760 | 810 | 2024-06-28 |
| 24052 | Iced Caffè Americano 24052 | 17 17 | 540 | 590 | 2024-06-28 |
| 24053 | Iced Cappuccino 24053 | 17 17 | 680 | 730 | 2024-06-28 |
| 24054 | Iced Caffè Mocha 24054 | 17 17 | 750 | 800 | 2024-06-28 |
| 24055 | Iced Caramel Macchiato 24055 | 17 17 | 760 | 810 | 2024-06-28 |
| 24056 | Iced Caffè Latte 24056 | 17 17 | 680 | 730 | 2024-06-28 |
| 24057 | Iced Oatmilk Latte 24057 | 17 17 | 760 | 810 | 2024-06-28 |
| 24058 | Iced Vanilla Latte 24058 | 17 17 | 750 | 800 | 2024-06-28 |
| 24059 | Iced White Chocolate Mocha 24059 | 17 17 | 750 | 800 | 2024-06-28 |
| 24060 | Signature Hot Chocolate 24060 | 17 17 | 720 | 770 | 2024-06-28 |
| 24061 | Signature Iced Chocolate 24061 | 17 17 | 720 | 770 | 2024-06-28 |
| 24062 | Carrot Juice 24062 | 17 17 | 490 | 540 | 2024-06-28 |
| 24063 | Cloudy Apple Juice 24063 | 17 17 | 490 | 540 | 2024-06-28 |
| 24064 | Cranberry Red Grapefruit Juice 24064 | 17 17 | 490 | 540 | 2024-06-28 |
| 24065 | Orange Juice 24065 | 17 17 | 490 | 540 | 2024-06-28 |
| 24066 | Evian 24066 | 17 17 | 350 | 400 | 2024-06-28 |
| 24067 | Sparkling Water 24067 | 17 17 | 450 | 500 | 2024-06-28 |
| 24068 | Chai Tea 24068 | 17 17 | 500 | 550 | 2024-06-28 |
| 24069 | Earl Grey Tea 24069 | 17 17 | 500 | 550 | 2024-06-28 |
| 24070 | English Breakfast Tea 24070 | 17 17 | 500 | 550 | 2024-06-28 |
| 24071 | Emperor’s Clouds & Mist™ Tea 24071 | 17 17 | 500 | 550 | 2024-06-28 |
| 24072 | Mint Blend Tea 24072 | 17 17 | 500 | 550 | 2024-06-28 |
| 24073 | Chamomile Tea 24073 | 17 17 | 500 | 550 | 2024-06-28 |
| 24074 | Pure Matcha Latte 24074 | 17 17 | 740 | 790 | 2024-06-28 |
| 24075 | Chai Tea Latte 24075 | 17 17 | 680 | 730 | 2024-06-28 |
| 24076 | Earl Grey Tea Latte 24076 | 17 17 | 680 | 730 | 2024-06-28 |
| 24077 | English Breakfast Tea Latte 24077 | 17 17 | 680 | 730 | 2024-06-28 |
| 24078 | Hojicha Tea Latte 24078 | 17 17 | 740 | 790 | 2024-06-28 |
| 24079 | Zen Clouds Oolong Tea 24079 | 17 17 | 500 | 550 | 2024-06-28 |
| 24080 | Zen Clouds Oolong with Ruby Grapefruit and Honey 24080 | 17 17 | 630 | 680 | 2024-06-28 |
| 24081 | Youthberry™ Tea 24081 | 17 17 | 500 | 550 | 2024-06-28 |
| 24082 | Iced Shaken Black Tea Lemonade 24082 | 17 17 | 610 | 660 | 2024-06-28 |
| 24083 | Iced Shaken Strawberry Black Tea Lemonade 24083 | 17 17 | 630 | 680 | 2024-06-28 |
| 24084 | Iced Shaken Hibiscus Tea Lemonade 24084 | 17 17 | 610 | 660 | 2024-06-28 |
| 24085 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 24085 | 17 17 | 730 | 780 | 2024-06-28 |
| 24086 | Iced Pure Matcha Latte 24086 | 17 17 | 740 | 790 | 2024-06-28 |
| 24087 | Iced Chai Tea Latte 24087 | 17 17 | 680 | 730 | 2024-06-28 |
| 24088 | Iced Black Tea Latte 24088 | 17 17 | 680 | 730 | 2024-06-28 |
| 24089 | Iced Hojicha Tea Latte 24089 | 17 17 | 740 | 790 | 2024-06-28 |
| 24090 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 24090 | 17 17 | 630 | 680 | 2024-06-28 |
| 24091 | Iced Shaken Zen Clouds Oolong Lemonade 24091 | 17 17 | 610 | 660 | 2024-06-28 |
| 24092 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 24092 | 17 17 | 630 | 680 | 2024-06-28 |
| 24093 | Origami Pike Place® Roast 24093 | 17 17 | 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");