item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
248 rows where store_id = 68
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
- 68 · 248 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 15210 | Bagel 15210 | 68 68 | 400 | 430 | 2024-06-28 |
| 15211 | Cookie Crumble Cheesecake 15211 | 68 68 | 720 | 770 | 2024-06-28 |
| 15212 | Good Ol' NY Cheesecake 15212 | 68 68 | 720 | 770 | 2024-06-28 |
| 15213 | Signature Chocolate Cake 15213 | 68 68 | 720 | 770 | 2024-06-28 |
| 15214 | Starbucks® Coffee Tiramisu Cake 15214 | 68 68 | 750 | 800 | 2024-06-28 |
| 15215 | Strawberry Shortcake 15215 | 68 68 | 720 | 770 | 2024-06-28 |
| 15216 | Chocolate Chunk Monster Cookie 15216 | 68 68 | 390 | 440 | 2024-06-28 |
| 15217 | Banana Walnut Muffin 15217 | 68 68 | 450 | 500 | 2024-06-28 |
| 15218 | Blueberry Crumble Muffin 15218 | 68 68 | 450 | 500 | 2024-06-28 |
| 15219 | Chocolate Crumble Muffin 15219 | 68 68 | 450 | 500 | 2024-06-28 |
| 15220 | Pancakes 15220 | 68 68 | 550 | 600 | 2024-06-28 |
| 15221 | Almond Croissant 15221 | 68 68 | 470 | 520 | 2024-06-28 |
| 15222 | Buttery Croissant 15222 | 68 68 | 400 | 430 | 2024-06-28 |
| 15223 | Chocolate Croissant 15223 | 68 68 | 440 | 490 | 2024-06-28 |
| 15224 | Creamy Chicken Foldover 15224 | 68 68 | 550 | 600 | 2024-06-28 |
| 15225 | Sausage Roll 15225 | 68 68 | 550 | 600 | 2024-06-28 |
| 15226 | Buttery Scone 15226 | 68 68 | 400 | 430 | 2024-06-28 |
| 15227 | Country Chicken Pie 15227 | 68 68 | 690 | 740 | 2024-06-28 |
| 15228 | Deep Dish Beef Pie 15228 | 68 68 | 690 | 740 | 2024-06-28 |
| 15229 | Spinach & Mushroom Quiche 15229 | 68 68 | 690 | 740 | 2024-06-28 |
| 15230 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 15230 | 68 68 | 390 | 420 | 2024-06-28 |
| 15231 | Mixed Nuts 15231 | 68 68 | 490 | 540 | 2024-06-28 |
| 15232 | Caramel Waffles 15232 | 68 68 | 390 | 420 | 2024-06-28 |
| 15233 | Chicken Ham & Cheese Panwich 15233 | 68 68 | 690 | 740 | 2024-06-28 |
| 15234 | Egg Mayo & Cheese Multigrain Croissant 15234 | 68 68 | 690 | 740 | 2024-06-28 |
| 15235 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 15235 | 68 68 | 690 | 740 | 2024-06-28 |
| 15236 | Rosemary Chicken & Emmental Cheese Croissant 15236 | 68 68 | 690 | 740 | 2024-06-28 |
| 15237 | Scrambled Egg & Turkey Ham Pita 15237 | 68 68 | 690 | 740 | 2024-06-28 |
| 15238 | Turkey Ham & Triple Cheese Toast 15238 | 68 68 | 690 | 740 | 2024-06-28 |
| 15239 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 15239 | 68 68 | 790 | 840 | 2024-06-28 |
| 15240 | Ham & Cheese Croissant 15240 | 68 68 | 690 | 740 | 2024-06-28 |
| 15241 | Sriracha Chicken Whole Wheat Pita 15241 | 68 68 | 750 | 800 | 2024-06-28 |
| 15242 | Blueberry Acai Yogurt Parfait 15242 | 68 68 | 650 | 700 | 2024-06-28 |
| 15243 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 15243 | 68 68 | 650 | 700 | 2024-06-28 |
| 15244 | Caramel Frappuccino® 15244 | 68 68 | 720 | 770 | 2024-06-28 |
| 15245 | Dark Mocha Frappuccino® 15245 | 68 68 | 780 | 830 | 2024-06-28 |
| 15246 | Java Chip Frappuccino® 15246 | 68 68 | 780 | 830 | 2024-06-28 |
| 15247 | Mocha Frappuccino® 15247 | 68 68 | 720 | 770 | 2024-06-28 |
| 15248 | Caramel Macchiato Frappuccino® 15248 | 68 68 | 780 | 830 | 2024-06-28 |
| 15249 | Espresso Frappuccino® 15249 | 68 68 | 720 | 770 | 2024-06-28 |
| 15250 | White Chocolate Mocha Frappuccino® 15250 | 68 68 | 720 | 770 | 2024-06-28 |
| 15251 | Chocolate Chip Cream Frappuccino® 15251 | 68 68 | 780 | 830 | 2024-06-28 |
| 15252 | Hojicha Tea Cream Frappuccino® 15252 | 68 68 | 760 | 810 | 2024-06-28 |
| 15253 | Vanilla Cream Frappuccino® 15253 | 68 68 | 720 | 770 | 2024-06-28 |
| 15254 | Mango Passion Fruit & Hibiscus 15254 | 68 68 | 720 | 770 | 2024-06-28 |
| 15255 | Raspberry Black Currant & Oolong 15255 | 68 68 | 720 | 770 | 2024-06-28 |
| 15256 | Coffee Traveller 15256 | 68 68 | 3120 | 3170 | 2024-06-28 |
| 15257 | Caffè Americano 15257 | 68 68 | 540 | 590 | 2024-06-28 |
| 15258 | Cappuccino 15258 | 68 68 | 680 | 730 | 2024-06-28 |
| 15259 | Caffè Mocha 15259 | 68 68 | 750 | 800 | 2024-06-28 |
| 15260 | Caramel Macchiato 15260 | 68 68 | 760 | 810 | 2024-06-28 |
| 15261 | Espresso 15261 | 68 68 | 390 | 440 | 2024-06-28 |
| 15262 | Caffè Latte 15262 | 68 68 | 680 | 730 | 2024-06-28 |
| 15263 | Oatmilk Latte 15263 | 68 68 | 760 | 810 | 2024-06-28 |
| 15264 | Vanilla Latte 15264 | 68 68 | 750 | 800 | 2024-06-28 |
| 15265 | White Chocolate Mocha 15265 | 68 68 | 750 | 800 | 2024-06-28 |
| 15266 | Flat White 15266 | 68 68 | 760 | 810 | 2024-06-28 |
| 15267 | Ristretto Bianco 15267 | 68 68 | 760 | 810 | 2024-06-28 |
| 15268 | Iced Caffè Americano 15268 | 68 68 | 540 | 590 | 2024-06-28 |
| 15269 | Iced Cappuccino 15269 | 68 68 | 680 | 730 | 2024-06-28 |
| 15270 | Iced Caffè Mocha 15270 | 68 68 | 750 | 800 | 2024-06-28 |
| 15271 | Iced Caramel Macchiato 15271 | 68 68 | 760 | 810 | 2024-06-28 |
| 15272 | Iced Caffè Latte 15272 | 68 68 | 680 | 730 | 2024-06-28 |
| 15273 | Iced Oatmilk Latte 15273 | 68 68 | 760 | 810 | 2024-06-28 |
| 15274 | Iced Vanilla Latte 15274 | 68 68 | 750 | 800 | 2024-06-28 |
| 15275 | Iced White Chocolate Mocha 15275 | 68 68 | 750 | 800 | 2024-06-28 |
| 15276 | Signature Hot Chocolate 15276 | 68 68 | 720 | 770 | 2024-06-28 |
| 15277 | Signature Iced Chocolate 15277 | 68 68 | 720 | 770 | 2024-06-28 |
| 15278 | Carrot Juice 15278 | 68 68 | 490 | 540 | 2024-06-28 |
| 15279 | Cloudy Apple Juice 15279 | 68 68 | 490 | 540 | 2024-06-28 |
| 15280 | Cranberry Red Grapefruit Juice 15280 | 68 68 | 490 | 540 | 2024-06-28 |
| 15281 | Orange Juice 15281 | 68 68 | 490 | 540 | 2024-06-28 |
| 15282 | Evian 15282 | 68 68 | 350 | 400 | 2024-06-28 |
| 15283 | Sparkling Water 15283 | 68 68 | 450 | 500 | 2024-06-28 |
| 15284 | Chai Tea 15284 | 68 68 | 500 | 550 | 2024-06-28 |
| 15285 | Earl Grey Tea 15285 | 68 68 | 500 | 550 | 2024-06-28 |
| 15286 | English Breakfast Tea 15286 | 68 68 | 500 | 550 | 2024-06-28 |
| 15287 | Emperor’s Clouds & Mist™ Tea 15287 | 68 68 | 500 | 550 | 2024-06-28 |
| 15288 | Mint Blend Tea 15288 | 68 68 | 500 | 550 | 2024-06-28 |
| 15289 | Chamomile Tea 15289 | 68 68 | 500 | 550 | 2024-06-28 |
| 15290 | Pure Matcha Latte 15290 | 68 68 | 740 | 790 | 2024-06-28 |
| 15291 | Chai Tea Latte 15291 | 68 68 | 680 | 730 | 2024-06-28 |
| 15292 | Earl Grey Tea Latte 15292 | 68 68 | 680 | 730 | 2024-06-28 |
| 15293 | English Breakfast Tea Latte 15293 | 68 68 | 680 | 730 | 2024-06-28 |
| 15294 | Hojicha Tea Latte 15294 | 68 68 | 740 | 790 | 2024-06-28 |
| 15295 | Zen Clouds Oolong Tea 15295 | 68 68 | 500 | 550 | 2024-06-28 |
| 15296 | Zen Clouds Oolong with Ruby Grapefruit and Honey 15296 | 68 68 | 630 | 680 | 2024-06-28 |
| 15297 | Youthberry™ Tea 15297 | 68 68 | 500 | 550 | 2024-06-28 |
| 15298 | Iced Shaken Black Tea Lemonade 15298 | 68 68 | 610 | 660 | 2024-06-28 |
| 15299 | Iced Shaken Strawberry Black Tea Lemonade 15299 | 68 68 | 630 | 680 | 2024-06-28 |
| 15300 | Iced Shaken Hibiscus Tea Lemonade 15300 | 68 68 | 610 | 660 | 2024-06-28 |
| 15301 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 15301 | 68 68 | 730 | 780 | 2024-06-28 |
| 15302 | Iced Pure Matcha Latte 15302 | 68 68 | 740 | 790 | 2024-06-28 |
| 15303 | Iced Chai Tea Latte 15303 | 68 68 | 680 | 730 | 2024-06-28 |
| 15304 | Iced Black Tea Latte 15304 | 68 68 | 680 | 730 | 2024-06-28 |
| 15305 | Iced Hojicha Tea Latte 15305 | 68 68 | 740 | 790 | 2024-06-28 |
| 15306 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 15306 | 68 68 | 630 | 680 | 2024-06-28 |
| 15307 | Iced Shaken Zen Clouds Oolong Lemonade 15307 | 68 68 | 610 | 660 | 2024-06-28 |
| 15308 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 15308 | 68 68 | 630 | 680 | 2024-06-28 |
| 15309 | Origami Pike Place® Roast 15309 | 68 68 | 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");