item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
248 rows where store_id = 21
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
- 21 · 248 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 23264 | Bagel 23264 | 21 21 | 400 | 430 | 2024-06-28 |
| 23265 | Cookie Crumble Cheesecake 23265 | 21 21 | 720 | 770 | 2024-06-28 |
| 23266 | Good Ol' NY Cheesecake 23266 | 21 21 | 720 | 770 | 2024-06-28 |
| 23267 | Signature Chocolate Cake 23267 | 21 21 | 720 | 770 | 2024-06-28 |
| 23268 | Starbucks® Coffee Tiramisu Cake 23268 | 21 21 | 750 | 800 | 2024-06-28 |
| 23269 | Strawberry Shortcake 23269 | 21 21 | 720 | 770 | 2024-06-28 |
| 23270 | Chocolate Chunk Monster Cookie 23270 | 21 21 | 390 | 440 | 2024-06-28 |
| 23271 | Banana Walnut Muffin 23271 | 21 21 | 450 | 500 | 2024-06-28 |
| 23272 | Blueberry Crumble Muffin 23272 | 21 21 | 450 | 500 | 2024-06-28 |
| 23273 | Chocolate Crumble Muffin 23273 | 21 21 | 450 | 500 | 2024-06-28 |
| 23274 | Pancakes 23274 | 21 21 | 550 | 600 | 2024-06-28 |
| 23275 | Almond Croissant 23275 | 21 21 | 470 | 520 | 2024-06-28 |
| 23276 | Buttery Croissant 23276 | 21 21 | 400 | 430 | 2024-06-28 |
| 23277 | Chocolate Croissant 23277 | 21 21 | 440 | 490 | 2024-06-28 |
| 23278 | Creamy Chicken Foldover 23278 | 21 21 | 550 | 600 | 2024-06-28 |
| 23279 | Sausage Roll 23279 | 21 21 | 550 | 600 | 2024-06-28 |
| 23280 | Buttery Scone 23280 | 21 21 | 400 | 430 | 2024-06-28 |
| 23281 | Country Chicken Pie 23281 | 21 21 | 690 | 740 | 2024-06-28 |
| 23282 | Deep Dish Beef Pie 23282 | 21 21 | 690 | 740 | 2024-06-28 |
| 23283 | Spinach & Mushroom Quiche 23283 | 21 21 | 690 | 740 | 2024-06-28 |
| 23284 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 23284 | 21 21 | 390 | 420 | 2024-06-28 |
| 23285 | Mixed Nuts 23285 | 21 21 | 490 | 540 | 2024-06-28 |
| 23286 | Caramel Waffles 23286 | 21 21 | 390 | 420 | 2024-06-28 |
| 23287 | Chicken Ham & Cheese Panwich 23287 | 21 21 | 690 | 740 | 2024-06-28 |
| 23288 | Egg Mayo & Cheese Multigrain Croissant 23288 | 21 21 | 690 | 740 | 2024-06-28 |
| 23289 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 23289 | 21 21 | 690 | 740 | 2024-06-28 |
| 23290 | Rosemary Chicken & Emmental Cheese Croissant 23290 | 21 21 | 690 | 740 | 2024-06-28 |
| 23291 | Scrambled Egg & Turkey Ham Pita 23291 | 21 21 | 690 | 740 | 2024-06-28 |
| 23292 | Turkey Ham & Triple Cheese Toast 23292 | 21 21 | 690 | 740 | 2024-06-28 |
| 23293 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 23293 | 21 21 | 790 | 840 | 2024-06-28 |
| 23294 | Ham & Cheese Croissant 23294 | 21 21 | 690 | 740 | 2024-06-28 |
| 23295 | Sriracha Chicken Whole Wheat Pita 23295 | 21 21 | 750 | 800 | 2024-06-28 |
| 23296 | Blueberry Acai Yogurt Parfait 23296 | 21 21 | 650 | 700 | 2024-06-28 |
| 23297 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 23297 | 21 21 | 650 | 700 | 2024-06-28 |
| 23298 | Caramel Frappuccino® 23298 | 21 21 | 720 | 770 | 2024-06-28 |
| 23299 | Dark Mocha Frappuccino® 23299 | 21 21 | 780 | 830 | 2024-06-28 |
| 23300 | Java Chip Frappuccino® 23300 | 21 21 | 780 | 830 | 2024-06-28 |
| 23301 | Mocha Frappuccino® 23301 | 21 21 | 720 | 770 | 2024-06-28 |
| 23302 | Caramel Macchiato Frappuccino® 23302 | 21 21 | 780 | 830 | 2024-06-28 |
| 23303 | Espresso Frappuccino® 23303 | 21 21 | 720 | 770 | 2024-06-28 |
| 23304 | White Chocolate Mocha Frappuccino® 23304 | 21 21 | 720 | 770 | 2024-06-28 |
| 23305 | Chocolate Chip Cream Frappuccino® 23305 | 21 21 | 780 | 830 | 2024-06-28 |
| 23306 | Hojicha Tea Cream Frappuccino® 23306 | 21 21 | 760 | 810 | 2024-06-28 |
| 23307 | Vanilla Cream Frappuccino® 23307 | 21 21 | 720 | 770 | 2024-06-28 |
| 23308 | Mango Passion Fruit & Hibiscus 23308 | 21 21 | 720 | 770 | 2024-06-28 |
| 23309 | Raspberry Black Currant & Oolong 23309 | 21 21 | 720 | 770 | 2024-06-28 |
| 23310 | Coffee Traveller 23310 | 21 21 | 3120 | 3170 | 2024-06-28 |
| 23311 | Caffè Americano 23311 | 21 21 | 540 | 590 | 2024-06-28 |
| 23312 | Cappuccino 23312 | 21 21 | 680 | 730 | 2024-06-28 |
| 23313 | Caffè Mocha 23313 | 21 21 | 750 | 800 | 2024-06-28 |
| 23314 | Caramel Macchiato 23314 | 21 21 | 760 | 810 | 2024-06-28 |
| 23315 | Espresso 23315 | 21 21 | 390 | 440 | 2024-06-28 |
| 23316 | Caffè Latte 23316 | 21 21 | 680 | 730 | 2024-06-28 |
| 23317 | Oatmilk Latte 23317 | 21 21 | 760 | 810 | 2024-06-28 |
| 23318 | Vanilla Latte 23318 | 21 21 | 750 | 800 | 2024-06-28 |
| 23319 | White Chocolate Mocha 23319 | 21 21 | 750 | 800 | 2024-06-28 |
| 23320 | Flat White 23320 | 21 21 | 760 | 810 | 2024-06-28 |
| 23321 | Ristretto Bianco 23321 | 21 21 | 760 | 810 | 2024-06-28 |
| 23322 | Iced Caffè Americano 23322 | 21 21 | 540 | 590 | 2024-06-28 |
| 23323 | Iced Cappuccino 23323 | 21 21 | 680 | 730 | 2024-06-28 |
| 23324 | Iced Caffè Mocha 23324 | 21 21 | 750 | 800 | 2024-06-28 |
| 23325 | Iced Caramel Macchiato 23325 | 21 21 | 760 | 810 | 2024-06-28 |
| 23326 | Iced Caffè Latte 23326 | 21 21 | 680 | 730 | 2024-06-28 |
| 23327 | Iced Oatmilk Latte 23327 | 21 21 | 760 | 810 | 2024-06-28 |
| 23328 | Iced Vanilla Latte 23328 | 21 21 | 750 | 800 | 2024-06-28 |
| 23329 | Iced White Chocolate Mocha 23329 | 21 21 | 750 | 800 | 2024-06-28 |
| 23330 | Signature Hot Chocolate 23330 | 21 21 | 720 | 770 | 2024-06-28 |
| 23331 | Signature Iced Chocolate 23331 | 21 21 | 720 | 770 | 2024-06-28 |
| 23332 | Carrot Juice 23332 | 21 21 | 490 | 540 | 2024-06-28 |
| 23333 | Cloudy Apple Juice 23333 | 21 21 | 490 | 540 | 2024-06-28 |
| 23334 | Cranberry Red Grapefruit Juice 23334 | 21 21 | 490 | 540 | 2024-06-28 |
| 23335 | Orange Juice 23335 | 21 21 | 490 | 540 | 2024-06-28 |
| 23336 | Evian 23336 | 21 21 | 350 | 400 | 2024-06-28 |
| 23337 | Sparkling Water 23337 | 21 21 | 450 | 500 | 2024-06-28 |
| 23338 | Chai Tea 23338 | 21 21 | 500 | 550 | 2024-06-28 |
| 23339 | Earl Grey Tea 23339 | 21 21 | 500 | 550 | 2024-06-28 |
| 23340 | English Breakfast Tea 23340 | 21 21 | 500 | 550 | 2024-06-28 |
| 23341 | Emperor’s Clouds & Mist™ Tea 23341 | 21 21 | 500 | 550 | 2024-06-28 |
| 23342 | Mint Blend Tea 23342 | 21 21 | 500 | 550 | 2024-06-28 |
| 23343 | Chamomile Tea 23343 | 21 21 | 500 | 550 | 2024-06-28 |
| 23344 | Pure Matcha Latte 23344 | 21 21 | 740 | 790 | 2024-06-28 |
| 23345 | Chai Tea Latte 23345 | 21 21 | 680 | 730 | 2024-06-28 |
| 23346 | Earl Grey Tea Latte 23346 | 21 21 | 680 | 730 | 2024-06-28 |
| 23347 | English Breakfast Tea Latte 23347 | 21 21 | 680 | 730 | 2024-06-28 |
| 23348 | Hojicha Tea Latte 23348 | 21 21 | 740 | 790 | 2024-06-28 |
| 23349 | Zen Clouds Oolong Tea 23349 | 21 21 | 500 | 550 | 2024-06-28 |
| 23350 | Zen Clouds Oolong with Ruby Grapefruit and Honey 23350 | 21 21 | 630 | 680 | 2024-06-28 |
| 23351 | Youthberry™ Tea 23351 | 21 21 | 500 | 550 | 2024-06-28 |
| 23352 | Iced Shaken Black Tea Lemonade 23352 | 21 21 | 610 | 660 | 2024-06-28 |
| 23353 | Iced Shaken Strawberry Black Tea Lemonade 23353 | 21 21 | 630 | 680 | 2024-06-28 |
| 23354 | Iced Shaken Hibiscus Tea Lemonade 23354 | 21 21 | 610 | 660 | 2024-06-28 |
| 23355 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 23355 | 21 21 | 730 | 780 | 2024-06-28 |
| 23356 | Iced Pure Matcha Latte 23356 | 21 21 | 740 | 790 | 2024-06-28 |
| 23357 | Iced Chai Tea Latte 23357 | 21 21 | 680 | 730 | 2024-06-28 |
| 23358 | Iced Black Tea Latte 23358 | 21 21 | 680 | 730 | 2024-06-28 |
| 23359 | Iced Hojicha Tea Latte 23359 | 21 21 | 740 | 790 | 2024-06-28 |
| 23360 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 23360 | 21 21 | 630 | 680 | 2024-06-28 |
| 23361 | Iced Shaken Zen Clouds Oolong Lemonade 23361 | 21 21 | 610 | 660 | 2024-06-28 |
| 23362 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 23362 | 21 21 | 630 | 680 | 2024-06-28 |
| 23363 | Origami Pike Place® Roast 23363 | 21 21 | 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");