item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
248 rows where store_id = 101
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
- 101 · 248 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 10078 | Bagel 10078 | 101 101 | 400 | 430 | 2024-06-28 |
| 10079 | Cookie Crumble Cheesecake 10079 | 101 101 | 720 | 770 | 2024-06-28 |
| 10080 | Good Ol' NY Cheesecake 10080 | 101 101 | 720 | 770 | 2024-06-28 |
| 10081 | Signature Chocolate Cake 10081 | 101 101 | 720 | 770 | 2024-06-28 |
| 10082 | Starbucks® Coffee Tiramisu Cake 10082 | 101 101 | 750 | 800 | 2024-06-28 |
| 10083 | Strawberry Shortcake 10083 | 101 101 | 720 | 770 | 2024-06-28 |
| 10084 | Chocolate Chunk Monster Cookie 10084 | 101 101 | 390 | 440 | 2024-06-28 |
| 10085 | Banana Walnut Muffin 10085 | 101 101 | 450 | 500 | 2024-06-28 |
| 10086 | Blueberry Crumble Muffin 10086 | 101 101 | 450 | 500 | 2024-06-28 |
| 10087 | Chocolate Crumble Muffin 10087 | 101 101 | 450 | 500 | 2024-06-28 |
| 10088 | Pancakes 10088 | 101 101 | 550 | 600 | 2024-06-28 |
| 10089 | Almond Croissant 10089 | 101 101 | 470 | 520 | 2024-06-28 |
| 10090 | Buttery Croissant 10090 | 101 101 | 400 | 430 | 2024-06-28 |
| 10091 | Chocolate Croissant 10091 | 101 101 | 440 | 490 | 2024-06-28 |
| 10092 | Creamy Chicken Foldover 10092 | 101 101 | 550 | 600 | 2024-06-28 |
| 10093 | Sausage Roll 10093 | 101 101 | 550 | 600 | 2024-06-28 |
| 10094 | Buttery Scone 10094 | 101 101 | 400 | 430 | 2024-06-28 |
| 10095 | Country Chicken Pie 10095 | 101 101 | 690 | 740 | 2024-06-28 |
| 10096 | Deep Dish Beef Pie 10096 | 101 101 | 690 | 740 | 2024-06-28 |
| 10097 | Spinach & Mushroom Quiche 10097 | 101 101 | 690 | 740 | 2024-06-28 |
| 10098 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 10098 | 101 101 | 390 | 420 | 2024-06-28 |
| 10099 | Mixed Nuts 10099 | 101 101 | 490 | 540 | 2024-06-28 |
| 10100 | Caramel Waffles 10100 | 101 101 | 390 | 420 | 2024-06-28 |
| 10101 | Chicken Ham & Cheese Panwich 10101 | 101 101 | 690 | 740 | 2024-06-28 |
| 10102 | Egg Mayo & Cheese Multigrain Croissant 10102 | 101 101 | 690 | 740 | 2024-06-28 |
| 10103 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 10103 | 101 101 | 690 | 740 | 2024-06-28 |
| 10104 | Rosemary Chicken & Emmental Cheese Croissant 10104 | 101 101 | 690 | 740 | 2024-06-28 |
| 10105 | Scrambled Egg & Turkey Ham Pita 10105 | 101 101 | 690 | 740 | 2024-06-28 |
| 10106 | Turkey Ham & Triple Cheese Toast 10106 | 101 101 | 690 | 740 | 2024-06-28 |
| 10107 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 10107 | 101 101 | 790 | 840 | 2024-06-28 |
| 10108 | Ham & Cheese Croissant 10108 | 101 101 | 690 | 740 | 2024-06-28 |
| 10109 | Sriracha Chicken Whole Wheat Pita 10109 | 101 101 | 750 | 800 | 2024-06-28 |
| 10110 | Blueberry Acai Yogurt Parfait 10110 | 101 101 | 650 | 700 | 2024-06-28 |
| 10111 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 10111 | 101 101 | 650 | 700 | 2024-06-28 |
| 10112 | Caramel Frappuccino® 10112 | 101 101 | 720 | 770 | 2024-06-28 |
| 10113 | Dark Mocha Frappuccino® 10113 | 101 101 | 780 | 830 | 2024-06-28 |
| 10114 | Java Chip Frappuccino® 10114 | 101 101 | 780 | 830 | 2024-06-28 |
| 10115 | Mocha Frappuccino® 10115 | 101 101 | 720 | 770 | 2024-06-28 |
| 10116 | Caramel Macchiato Frappuccino® 10116 | 101 101 | 780 | 830 | 2024-06-28 |
| 10117 | Espresso Frappuccino® 10117 | 101 101 | 720 | 770 | 2024-06-28 |
| 10118 | White Chocolate Mocha Frappuccino® 10118 | 101 101 | 720 | 770 | 2024-06-28 |
| 10119 | Chocolate Chip Cream Frappuccino® 10119 | 101 101 | 780 | 830 | 2024-06-28 |
| 10120 | Hojicha Tea Cream Frappuccino® 10120 | 101 101 | 760 | 810 | 2024-06-28 |
| 10121 | Vanilla Cream Frappuccino® 10121 | 101 101 | 720 | 770 | 2024-06-28 |
| 10122 | Mango Passion Fruit & Hibiscus 10122 | 101 101 | 720 | 770 | 2024-06-28 |
| 10123 | Raspberry Black Currant & Oolong 10123 | 101 101 | 720 | 770 | 2024-06-28 |
| 10124 | Coffee Traveller 10124 | 101 101 | 3120 | 3170 | 2024-06-28 |
| 10125 | Caffè Americano 10125 | 101 101 | 540 | 590 | 2024-06-28 |
| 10126 | Cappuccino 10126 | 101 101 | 680 | 730 | 2024-06-28 |
| 10127 | Caffè Mocha 10127 | 101 101 | 750 | 800 | 2024-06-28 |
| 10128 | Caramel Macchiato 10128 | 101 101 | 760 | 810 | 2024-06-28 |
| 10129 | Espresso 10129 | 101 101 | 390 | 440 | 2024-06-28 |
| 10130 | Caffè Latte 10130 | 101 101 | 680 | 730 | 2024-06-28 |
| 10131 | Oatmilk Latte 10131 | 101 101 | 760 | 810 | 2024-06-28 |
| 10132 | Vanilla Latte 10132 | 101 101 | 750 | 800 | 2024-06-28 |
| 10133 | White Chocolate Mocha 10133 | 101 101 | 750 | 800 | 2024-06-28 |
| 10134 | Flat White 10134 | 101 101 | 760 | 810 | 2024-06-28 |
| 10135 | Ristretto Bianco 10135 | 101 101 | 760 | 810 | 2024-06-28 |
| 10136 | Iced Caffè Americano 10136 | 101 101 | 540 | 590 | 2024-06-28 |
| 10137 | Iced Cappuccino 10137 | 101 101 | 680 | 730 | 2024-06-28 |
| 10138 | Iced Caffè Mocha 10138 | 101 101 | 750 | 800 | 2024-06-28 |
| 10139 | Iced Caramel Macchiato 10139 | 101 101 | 760 | 810 | 2024-06-28 |
| 10140 | Iced Caffè Latte 10140 | 101 101 | 680 | 730 | 2024-06-28 |
| 10141 | Iced Oatmilk Latte 10141 | 101 101 | 760 | 810 | 2024-06-28 |
| 10142 | Iced Vanilla Latte 10142 | 101 101 | 750 | 800 | 2024-06-28 |
| 10143 | Iced White Chocolate Mocha 10143 | 101 101 | 750 | 800 | 2024-06-28 |
| 10144 | Signature Hot Chocolate 10144 | 101 101 | 720 | 770 | 2024-06-28 |
| 10145 | Signature Iced Chocolate 10145 | 101 101 | 720 | 770 | 2024-06-28 |
| 10146 | Carrot Juice 10146 | 101 101 | 490 | 540 | 2024-06-28 |
| 10147 | Cloudy Apple Juice 10147 | 101 101 | 490 | 540 | 2024-06-28 |
| 10148 | Cranberry Red Grapefruit Juice 10148 | 101 101 | 490 | 540 | 2024-06-28 |
| 10149 | Orange Juice 10149 | 101 101 | 490 | 540 | 2024-06-28 |
| 10150 | Evian 10150 | 101 101 | 350 | 400 | 2024-06-28 |
| 10151 | Sparkling Water 10151 | 101 101 | 450 | 500 | 2024-06-28 |
| 10152 | Chai Tea 10152 | 101 101 | 500 | 550 | 2024-06-28 |
| 10153 | Earl Grey Tea 10153 | 101 101 | 500 | 550 | 2024-06-28 |
| 10154 | English Breakfast Tea 10154 | 101 101 | 500 | 550 | 2024-06-28 |
| 10155 | Emperor’s Clouds & Mist™ Tea 10155 | 101 101 | 500 | 550 | 2024-06-28 |
| 10156 | Mint Blend Tea 10156 | 101 101 | 500 | 550 | 2024-06-28 |
| 10157 | Chamomile Tea 10157 | 101 101 | 500 | 550 | 2024-06-28 |
| 10158 | Pure Matcha Latte 10158 | 101 101 | 740 | 790 | 2024-06-28 |
| 10159 | Chai Tea Latte 10159 | 101 101 | 680 | 730 | 2024-06-28 |
| 10160 | Earl Grey Tea Latte 10160 | 101 101 | 680 | 730 | 2024-06-28 |
| 10161 | English Breakfast Tea Latte 10161 | 101 101 | 680 | 730 | 2024-06-28 |
| 10162 | Hojicha Tea Latte 10162 | 101 101 | 740 | 790 | 2024-06-28 |
| 10163 | Zen Clouds Oolong Tea 10163 | 101 101 | 500 | 550 | 2024-06-28 |
| 10164 | Zen Clouds Oolong with Ruby Grapefruit and Honey 10164 | 101 101 | 630 | 680 | 2024-06-28 |
| 10165 | Youthberry™ Tea 10165 | 101 101 | 500 | 550 | 2024-06-28 |
| 10166 | Iced Shaken Black Tea Lemonade 10166 | 101 101 | 610 | 660 | 2024-06-28 |
| 10167 | Iced Shaken Strawberry Black Tea Lemonade 10167 | 101 101 | 630 | 680 | 2024-06-28 |
| 10168 | Iced Shaken Hibiscus Tea Lemonade 10168 | 101 101 | 610 | 660 | 2024-06-28 |
| 10169 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 10169 | 101 101 | 730 | 780 | 2024-06-28 |
| 10170 | Iced Pure Matcha Latte 10170 | 101 101 | 740 | 790 | 2024-06-28 |
| 10171 | Iced Chai Tea Latte 10171 | 101 101 | 680 | 730 | 2024-06-28 |
| 10172 | Iced Black Tea Latte 10172 | 101 101 | 680 | 730 | 2024-06-28 |
| 10173 | Iced Hojicha Tea Latte 10173 | 101 101 | 740 | 790 | 2024-06-28 |
| 10174 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 10174 | 101 101 | 630 | 680 | 2024-06-28 |
| 10175 | Iced Shaken Zen Clouds Oolong Lemonade 10175 | 101 101 | 610 | 660 | 2024-06-28 |
| 10176 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 10176 | 101 101 | 630 | 680 | 2024-06-28 |
| 10177 | Origami Pike Place® Roast 10177 | 101 101 | 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");