item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
229 rows where store_id = 52
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 10
- 2024-06-28 184
- 2024-09-15 10
- 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
- 52 · 229 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 18151 | Bagel 18151 | 52 52 | 400 | 430 | 2024-06-28 |
| 18152 | Cookie Crumble Cheesecake 18152 | 52 52 | 720 | 770 | 2024-06-28 |
| 18153 | Good Ol' NY Cheesecake 18153 | 52 52 | 720 | 770 | 2024-06-28 |
| 18154 | Signature Chocolate Cake 18154 | 52 52 | 720 | 770 | 2024-06-28 |
| 18155 | Starbucks® Coffee Tiramisu Cake 18155 | 52 52 | 750 | 800 | 2024-06-28 |
| 18156 | Strawberry Shortcake 18156 | 52 52 | 720 | 770 | 2024-06-28 |
| 18157 | Chocolate Chunk Monster Cookie 18157 | 52 52 | 390 | 440 | 2024-06-28 |
| 18158 | Banana Walnut Muffin 18158 | 52 52 | 450 | 500 | 2024-06-28 |
| 18159 | Blueberry Crumble Muffin 18159 | 52 52 | 450 | 500 | 2024-06-28 |
| 18160 | Chocolate Crumble Muffin 18160 | 52 52 | 450 | 500 | 2024-06-28 |
| 18161 | Pancakes 18161 | 52 52 | 550 | 600 | 2024-06-28 |
| 18162 | Almond Croissant 18162 | 52 52 | 470 | 520 | 2024-06-28 |
| 18163 | Buttery Croissant 18163 | 52 52 | 400 | 430 | 2024-06-28 |
| 18164 | Chocolate Croissant 18164 | 52 52 | 440 | 490 | 2024-06-28 |
| 18165 | Creamy Chicken Foldover 18165 | 52 52 | 550 | 600 | 2024-06-28 |
| 18166 | Sausage Roll 18166 | 52 52 | 550 | 600 | 2024-06-28 |
| 18167 | Buttery Scone 18167 | 52 52 | 400 | 430 | 2024-06-28 |
| 18168 | Country Chicken Pie 18168 | 52 52 | 690 | 740 | 2024-06-28 |
| 18169 | Deep Dish Beef Pie 18169 | 52 52 | 690 | 740 | 2024-06-28 |
| 18170 | Spinach & Mushroom Quiche 18170 | 52 52 | 690 | 740 | 2024-06-28 |
| 18171 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 18171 | 52 52 | 390 | 420 | 2024-06-28 |
| 18172 | Mixed Nuts 18172 | 52 52 | 490 | 540 | 2024-06-28 |
| 18173 | Caramel Waffles 18173 | 52 52 | 390 | 420 | 2024-06-28 |
| 18174 | Chicken Ham & Cheese Panwich 18174 | 52 52 | 690 | 740 | 2024-06-28 |
| 18175 | Egg Mayo & Cheese Multigrain Croissant 18175 | 52 52 | 690 | 740 | 2024-06-28 |
| 18176 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 18176 | 52 52 | 690 | 740 | 2024-06-28 |
| 18177 | Rosemary Chicken & Emmental Cheese Croissant 18177 | 52 52 | 690 | 740 | 2024-06-28 |
| 18178 | Scrambled Egg & Turkey Ham Pita 18178 | 52 52 | 690 | 740 | 2024-06-28 |
| 18179 | Turkey Ham & Triple Cheese Toast 18179 | 52 52 | 690 | 740 | 2024-06-28 |
| 18180 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 18180 | 52 52 | 790 | 840 | 2024-06-28 |
| 18181 | Ham & Cheese Croissant 18181 | 52 52 | 690 | 740 | 2024-06-28 |
| 18182 | Sriracha Chicken Whole Wheat Pita 18182 | 52 52 | 750 | 800 | 2024-06-28 |
| 18183 | Blueberry Acai Yogurt Parfait 18183 | 52 52 | 650 | 700 | 2024-06-28 |
| 18184 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 18184 | 52 52 | 650 | 700 | 2024-06-28 |
| 18185 | Caramel Frappuccino® 18185 | 52 52 | 720 | 770 | 2024-06-28 |
| 18186 | Dark Mocha Frappuccino® 18186 | 52 52 | 780 | 830 | 2024-06-28 |
| 18187 | Java Chip Frappuccino® 18187 | 52 52 | 780 | 830 | 2024-06-28 |
| 18188 | Mocha Frappuccino® 18188 | 52 52 | 720 | 770 | 2024-06-28 |
| 18189 | Caramel Macchiato Frappuccino® 18189 | 52 52 | 780 | 830 | 2024-06-28 |
| 18190 | Espresso Frappuccino® 18190 | 52 52 | 720 | 770 | 2024-06-28 |
| 18191 | White Chocolate Mocha Frappuccino® 18191 | 52 52 | 720 | 770 | 2024-06-28 |
| 18192 | Chocolate Chip Cream Frappuccino® 18192 | 52 52 | 780 | 830 | 2024-06-28 |
| 18193 | Hojicha Tea Cream Frappuccino® 18193 | 52 52 | 760 | 810 | 2024-06-28 |
| 18194 | Vanilla Cream Frappuccino® 18194 | 52 52 | 720 | 770 | 2024-06-28 |
| 18195 | Mango Passion Fruit & Hibiscus 18195 | 52 52 | 720 | 770 | 2024-06-28 |
| 18196 | Raspberry Black Currant & Oolong 18196 | 52 52 | 720 | 770 | 2024-06-28 |
| 18197 | Coffee Traveller 18197 | 52 52 | 3120 | 3170 | 2024-06-28 |
| 18198 | Caffè Americano 18198 | 52 52 | 540 | 590 | 2024-06-28 |
| 18199 | Cappuccino 18199 | 52 52 | 680 | 730 | 2024-06-28 |
| 18200 | Caffè Mocha 18200 | 52 52 | 750 | 800 | 2024-06-28 |
| 18201 | Caramel Macchiato 18201 | 52 52 | 760 | 810 | 2024-06-28 |
| 18202 | Espresso 18202 | 52 52 | 390 | 440 | 2024-06-28 |
| 18203 | Caffè Latte 18203 | 52 52 | 680 | 730 | 2024-06-28 |
| 18204 | Oatmilk Latte 18204 | 52 52 | 760 | 810 | 2024-06-28 |
| 18205 | Vanilla Latte 18205 | 52 52 | 750 | 800 | 2024-06-28 |
| 18206 | White Chocolate Mocha 18206 | 52 52 | 750 | 800 | 2024-06-28 |
| 18207 | Flat White 18207 | 52 52 | 760 | 810 | 2024-06-28 |
| 18208 | Ristretto Bianco 18208 | 52 52 | 760 | 810 | 2024-06-28 |
| 18209 | Iced Caffè Americano 18209 | 52 52 | 540 | 590 | 2024-06-28 |
| 18210 | Iced Cappuccino 18210 | 52 52 | 680 | 730 | 2024-06-28 |
| 18211 | Iced Caffè Mocha 18211 | 52 52 | 750 | 800 | 2024-06-28 |
| 18212 | Iced Caramel Macchiato 18212 | 52 52 | 760 | 810 | 2024-06-28 |
| 18213 | Iced Caffè Latte 18213 | 52 52 | 680 | 730 | 2024-06-28 |
| 18214 | Iced Oatmilk Latte 18214 | 52 52 | 760 | 810 | 2024-06-28 |
| 18215 | Iced Vanilla Latte 18215 | 52 52 | 750 | 800 | 2024-06-28 |
| 18216 | Iced White Chocolate Mocha 18216 | 52 52 | 750 | 800 | 2024-06-28 |
| 18217 | Signature Hot Chocolate 18217 | 52 52 | 720 | 770 | 2024-06-28 |
| 18218 | Signature Iced Chocolate 18218 | 52 52 | 720 | 770 | 2024-06-28 |
| 18219 | Carrot Juice 18219 | 52 52 | 490 | 540 | 2024-06-28 |
| 18220 | Cloudy Apple Juice 18220 | 52 52 | 490 | 540 | 2024-06-28 |
| 18221 | Cranberry Red Grapefruit Juice 18221 | 52 52 | 490 | 540 | 2024-06-28 |
| 18222 | Orange Juice 18222 | 52 52 | 490 | 540 | 2024-06-28 |
| 18223 | Evian 18223 | 52 52 | 350 | 400 | 2024-06-28 |
| 18224 | Sparkling Water 18224 | 52 52 | 450 | 500 | 2024-06-28 |
| 18225 | Chai Tea 18225 | 52 52 | 500 | 550 | 2024-06-28 |
| 18226 | Earl Grey Tea 18226 | 52 52 | 500 | 550 | 2024-06-28 |
| 18227 | English Breakfast Tea 18227 | 52 52 | 500 | 550 | 2024-06-28 |
| 18228 | Emperor’s Clouds & Mist™ Tea 18228 | 52 52 | 500 | 550 | 2024-06-28 |
| 18229 | Mint Blend Tea 18229 | 52 52 | 500 | 550 | 2024-06-28 |
| 18230 | Chamomile Tea 18230 | 52 52 | 500 | 550 | 2024-06-28 |
| 18231 | Pure Matcha Latte 18231 | 52 52 | 740 | 790 | 2024-06-28 |
| 18232 | Chai Tea Latte 18232 | 52 52 | 680 | 730 | 2024-06-28 |
| 18233 | Earl Grey Tea Latte 18233 | 52 52 | 680 | 730 | 2024-06-28 |
| 18234 | English Breakfast Tea Latte 18234 | 52 52 | 680 | 730 | 2024-06-28 |
| 18235 | Hojicha Tea Latte 18235 | 52 52 | 740 | 790 | 2024-06-28 |
| 18236 | Zen Clouds Oolong Tea 18236 | 52 52 | 500 | 550 | 2024-06-28 |
| 18237 | Zen Clouds Oolong with Ruby Grapefruit and Honey 18237 | 52 52 | 630 | 680 | 2024-06-28 |
| 18238 | Youthberry™ Tea 18238 | 52 52 | 500 | 550 | 2024-06-28 |
| 18239 | Iced Shaken Black Tea Lemonade 18239 | 52 52 | 610 | 660 | 2024-06-28 |
| 18240 | Iced Shaken Strawberry Black Tea Lemonade 18240 | 52 52 | 630 | 680 | 2024-06-28 |
| 18241 | Iced Shaken Hibiscus Tea Lemonade 18241 | 52 52 | 610 | 660 | 2024-06-28 |
| 18242 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 18242 | 52 52 | 730 | 780 | 2024-06-28 |
| 18243 | Iced Pure Matcha Latte 18243 | 52 52 | 740 | 790 | 2024-06-28 |
| 18244 | Iced Chai Tea Latte 18244 | 52 52 | 680 | 730 | 2024-06-28 |
| 18245 | Iced Black Tea Latte 18245 | 52 52 | 680 | 730 | 2024-06-28 |
| 18246 | Iced Hojicha Tea Latte 18246 | 52 52 | 740 | 790 | 2024-06-28 |
| 18247 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 18247 | 52 52 | 630 | 680 | 2024-06-28 |
| 18248 | Iced Shaken Zen Clouds Oolong Lemonade 18248 | 52 52 | 610 | 660 | 2024-06-28 |
| 18249 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 18249 | 52 52 | 630 | 680 | 2024-06-28 |
| 18250 | Origami Pike Place® Roast 18250 | 52 52 | 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");