item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
250 rows where store_id = 15
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 12
- 2024-06-28 184
- 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
- 15 · 250 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 24358 | Bagel 24358 | 15 15 | 360 | 390 | 2024-06-28 |
| 24359 | Cookie Crumble Cheesecake 24359 | 15 15 | 650 | 700 | 2024-06-28 |
| 24360 | Good Ol' NY Cheesecake 24360 | 15 15 | 650 | 700 | 2024-06-28 |
| 24361 | Signature Chocolate Cake 24361 | 15 15 | 650 | 700 | 2024-06-28 |
| 24362 | Starbucks® Coffee Tiramisu Cake 24362 | 15 15 | 670 | 720 | 2024-06-28 |
| 24363 | Strawberry Shortcake 24363 | 15 15 | 650 | 700 | 2024-06-28 |
| 24364 | Chocolate Chunk Monster Cookie 24364 | 15 15 | 350 | 400 | 2024-06-28 |
| 24365 | Banana Walnut Muffin 24365 | 15 15 | 400 | 450 | 2024-06-28 |
| 24366 | Blueberry Crumble Muffin 24366 | 15 15 | 400 | 450 | 2024-06-28 |
| 24367 | Chocolate Crumble Muffin 24367 | 15 15 | 400 | 450 | 2024-06-28 |
| 24368 | Pancakes 24368 | 15 15 | 490 | 540 | 2024-06-28 |
| 24369 | Almond Croissant 24369 | 15 15 | 420 | 470 | 2024-06-28 |
| 24370 | Buttery Croissant 24370 | 15 15 | 360 | 390 | 2024-06-28 |
| 24371 | Chocolate Croissant 24371 | 15 15 | 390 | 440 | 2024-06-28 |
| 24372 | Creamy Chicken Foldover 24372 | 15 15 | 490 | 540 | 2024-06-28 |
| 24373 | Sausage Roll 24373 | 15 15 | 490 | 540 | 2024-06-28 |
| 24374 | Buttery Scone 24374 | 15 15 | 360 | 390 | 2024-06-28 |
| 24375 | Country Chicken Pie 24375 | 15 15 | 620 | 670 | 2024-06-28 |
| 24376 | Deep Dish Beef Pie 24376 | 15 15 | 620 | 670 | 2024-06-28 |
| 24377 | Spinach & Mushroom Quiche 24377 | 15 15 | 620 | 670 | 2024-06-28 |
| 24378 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 24378 | 15 15 | 350 | 380 | 2024-06-28 |
| 24379 | Mixed Nuts 24379 | 15 15 | 440 | 490 | 2024-06-28 |
| 24380 | Caramel Waffles 24380 | 15 15 | 350 | 380 | 2024-06-28 |
| 24381 | Chicken Ham & Cheese Panwich 24381 | 15 15 | 620 | 670 | 2024-06-28 |
| 24382 | Egg Mayo & Cheese Multigrain Croissant 24382 | 15 15 | 620 | 670 | 2024-06-28 |
| 24383 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 24383 | 15 15 | 620 | 670 | 2024-06-28 |
| 24384 | Rosemary Chicken & Emmental Cheese Croissant 24384 | 15 15 | 620 | 670 | 2024-06-28 |
| 24385 | Scrambled Egg & Turkey Ham Pita 24385 | 15 15 | 620 | 670 | 2024-06-28 |
| 24386 | Turkey Ham & Triple Cheese Toast 24386 | 15 15 | 620 | 670 | 2024-06-28 |
| 24387 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 24387 | 15 15 | 710 | 760 | 2024-06-28 |
| 24388 | Ham & Cheese Croissant 24388 | 15 15 | 620 | 670 | 2024-06-28 |
| 24389 | Sriracha Chicken Whole Wheat Pita 24389 | 15 15 | 670 | 720 | 2024-06-28 |
| 24390 | Blueberry Acai Yogurt Parfait 24390 | 15 15 | 580 | 630 | 2024-06-28 |
| 24391 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 24391 | 15 15 | 580 | 630 | 2024-06-28 |
| 24392 | Caramel Frappuccino® 24392 | 15 15 | 650 | 700 | 2024-06-28 |
| 24393 | Dark Mocha Frappuccino® 24393 | 15 15 | 710 | 760 | 2024-06-28 |
| 24394 | Java Chip Frappuccino® 24394 | 15 15 | 710 | 760 | 2024-06-28 |
| 24395 | Mocha Frappuccino® 24395 | 15 15 | 650 | 700 | 2024-06-28 |
| 24396 | Caramel Macchiato Frappuccino® 24396 | 15 15 | 710 | 760 | 2024-06-28 |
| 24397 | Espresso Frappuccino® 24397 | 15 15 | 650 | 700 | 2024-06-28 |
| 24398 | White Chocolate Mocha Frappuccino® 24398 | 15 15 | 650 | 700 | 2024-06-28 |
| 24399 | Chocolate Chip Cream Frappuccino® 24399 | 15 15 | 710 | 760 | 2024-06-28 |
| 24400 | Hojicha Tea Cream Frappuccino® 24400 | 15 15 | 690 | 740 | 2024-06-28 |
| 24401 | Vanilla Cream Frappuccino® 24401 | 15 15 | 650 | 700 | 2024-06-28 |
| 24402 | Mango Passion Fruit & Hibiscus 24402 | 15 15 | 650 | 700 | 2024-06-28 |
| 24403 | Raspberry Black Currant & Oolong 24403 | 15 15 | 650 | 700 | 2024-06-28 |
| 24404 | Coffee Traveller 24404 | 15 15 | 2800 | 2850 | 2024-06-28 |
| 24405 | Caffè Americano 24405 | 15 15 | 490 | 540 | 2024-06-28 |
| 24406 | Cappuccino 24406 | 15 15 | 620 | 670 | 2024-06-28 |
| 24407 | Caffè Mocha 24407 | 15 15 | 680 | 730 | 2024-06-28 |
| 24408 | Caramel Macchiato 24408 | 15 15 | 690 | 740 | 2024-06-28 |
| 24409 | Espresso 24409 | 15 15 | 350 | 400 | 2024-06-28 |
| 24410 | Caffè Latte 24410 | 15 15 | 620 | 670 | 2024-06-28 |
| 24411 | Oatmilk Latte 24411 | 15 15 | 690 | 740 | 2024-06-28 |
| 24412 | Vanilla Latte 24412 | 15 15 | 680 | 730 | 2024-06-28 |
| 24413 | White Chocolate Mocha 24413 | 15 15 | 680 | 730 | 2024-06-28 |
| 24414 | Flat White 24414 | 15 15 | 690 | 740 | 2024-06-28 |
| 24415 | Ristretto Bianco 24415 | 15 15 | 690 | 740 | 2024-06-28 |
| 24416 | Iced Caffè Americano 24416 | 15 15 | 490 | 540 | 2024-06-28 |
| 24417 | Iced Cappuccino 24417 | 15 15 | 620 | 670 | 2024-06-28 |
| 24418 | Iced Caffè Mocha 24418 | 15 15 | 680 | 730 | 2024-06-28 |
| 24419 | Iced Caramel Macchiato 24419 | 15 15 | 690 | 740 | 2024-06-28 |
| 24420 | Iced Caffè Latte 24420 | 15 15 | 620 | 670 | 2024-06-28 |
| 24421 | Iced Oatmilk Latte 24421 | 15 15 | 690 | 740 | 2024-06-28 |
| 24422 | Iced Vanilla Latte 24422 | 15 15 | 680 | 730 | 2024-06-28 |
| 24423 | Iced White Chocolate Mocha 24423 | 15 15 | 680 | 730 | 2024-06-28 |
| 24424 | Signature Hot Chocolate 24424 | 15 15 | 650 | 700 | 2024-06-28 |
| 24425 | Signature Iced Chocolate 24425 | 15 15 | 650 | 700 | 2024-06-28 |
| 24426 | Carrot Juice 24426 | 15 15 | 440 | 490 | 2024-06-28 |
| 24427 | Cloudy Apple Juice 24427 | 15 15 | 440 | 490 | 2024-06-28 |
| 24428 | Cranberry Red Grapefruit Juice 24428 | 15 15 | 440 | 490 | 2024-06-28 |
| 24429 | Orange Juice 24429 | 15 15 | 440 | 490 | 2024-06-28 |
| 24430 | Evian 24430 | 15 15 | 310 | 360 | 2024-06-28 |
| 24431 | Sparkling Water 24431 | 15 15 | 400 | 450 | 2024-06-28 |
| 24432 | Chai Tea 24432 | 15 15 | 450 | 500 | 2024-06-28 |
| 24433 | Earl Grey Tea 24433 | 15 15 | 450 | 500 | 2024-06-28 |
| 24434 | English Breakfast Tea 24434 | 15 15 | 450 | 500 | 2024-06-28 |
| 24435 | Emperor’s Clouds & Mist™ Tea 24435 | 15 15 | 450 | 500 | 2024-06-28 |
| 24436 | Mint Blend Tea 24436 | 15 15 | 450 | 500 | 2024-06-28 |
| 24437 | Chamomile Tea 24437 | 15 15 | 450 | 500 | 2024-06-28 |
| 24438 | Pure Matcha Latte 24438 | 15 15 | 670 | 720 | 2024-06-28 |
| 24439 | Chai Tea Latte 24439 | 15 15 | 620 | 670 | 2024-06-28 |
| 24440 | Earl Grey Tea Latte 24440 | 15 15 | 620 | 670 | 2024-06-28 |
| 24441 | English Breakfast Tea Latte 24441 | 15 15 | 620 | 670 | 2024-06-28 |
| 24442 | Hojicha Tea Latte 24442 | 15 15 | 670 | 720 | 2024-06-28 |
| 24443 | Zen Clouds Oolong Tea 24443 | 15 15 | 450 | 500 | 2024-06-28 |
| 24444 | Zen Clouds Oolong with Ruby Grapefruit and Honey 24444 | 15 15 | 580 | 630 | 2024-06-28 |
| 24445 | Youthberry™ Tea 24445 | 15 15 | 450 | 500 | 2024-06-28 |
| 24446 | Iced Shaken Black Tea Lemonade 24446 | 15 15 | 560 | 610 | 2024-06-28 |
| 24447 | Iced Shaken Strawberry Black Tea Lemonade 24447 | 15 15 | 580 | 630 | 2024-06-28 |
| 24448 | Iced Shaken Hibiscus Tea Lemonade 24448 | 15 15 | 560 | 610 | 2024-06-28 |
| 24449 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 24449 | 15 15 | 660 | 710 | 2024-06-28 |
| 24450 | Iced Pure Matcha Latte 24450 | 15 15 | 670 | 720 | 2024-06-28 |
| 24451 | Iced Chai Tea Latte 24451 | 15 15 | 620 | 670 | 2024-06-28 |
| 24452 | Iced Black Tea Latte 24452 | 15 15 | 620 | 670 | 2024-06-28 |
| 24453 | Iced Hojicha Tea Latte 24453 | 15 15 | 670 | 720 | 2024-06-28 |
| 24454 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 24454 | 15 15 | 580 | 630 | 2024-06-28 |
| 24455 | Iced Shaken Zen Clouds Oolong Lemonade 24455 | 15 15 | 560 | 610 | 2024-06-28 |
| 24456 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 24456 | 15 15 | 580 | 630 | 2024-06-28 |
| 24457 | Origami Pike Place® Roast 24457 | 15 15 | 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");