item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
343 rows where store_id = 31
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 12
- 2024-06-28 185
- 2024-11-10 104
- 2024-09-15 10
- 2024-11-03 9
- 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
- 31 · 343 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 21435 | Bagel 21435 | 31 31 | 430 | 460 | 2024-06-28 |
| 21436 | Cookie Crumble Cheesecake 21436 | 31 31 | 750 | 800 | 2024-06-28 |
| 21437 | Good Ol' NY Cheesecake 21437 | 31 31 | 750 | 800 | 2024-06-28 |
| 21438 | Signature Chocolate Cake 21438 | 31 31 | 750 | 800 | 2024-06-28 |
| 21439 | Starbucks® Coffee Tiramisu Cake 21439 | 31 31 | 780 | 830 | 2024-06-28 |
| 21440 | Strawberry Shortcake 21440 | 31 31 | 750 | 800 | 2024-06-28 |
| 21441 | Chocolate Chunk Monster Cookie 21441 | 31 31 | 420 | 470 | 2024-06-28 |
| 21442 | Banana Walnut Muffin 21442 | 31 31 | 480 | 530 | 2024-06-28 |
| 21443 | Blueberry Crumble Muffin 21443 | 31 31 | 480 | 530 | 2024-06-28 |
| 21444 | Chocolate Crumble Muffin 21444 | 31 31 | 480 | 530 | 2024-06-28 |
| 21445 | Pancakes 21445 | 31 31 | 580 | 630 | 2024-06-28 |
| 21446 | Almond Croissant 21446 | 31 31 | 500 | 550 | 2024-06-28 |
| 21447 | Buttery Croissant 21447 | 31 31 | 430 | 460 | 2024-06-28 |
| 21448 | Chocolate Croissant 21448 | 31 31 | 470 | 520 | 2024-06-28 |
| 21449 | Creamy Chicken Foldover 21449 | 31 31 | 580 | 630 | 2024-06-28 |
| 21450 | Sausage Roll 21450 | 31 31 | 580 | 630 | 2024-06-28 |
| 21451 | Buttery Scone 21451 | 31 31 | 430 | 460 | 2024-06-28 |
| 21452 | Country Chicken Pie 21452 | 31 31 | 720 | 770 | 2024-06-28 |
| 21453 | Deep Dish Beef Pie 21453 | 31 31 | 720 | 770 | 2024-06-28 |
| 21454 | Spinach & Mushroom Quiche 21454 | 31 31 | 720 | 770 | 2024-06-28 |
| 21455 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 21455 | 31 31 | 420 | 450 | 2024-06-28 |
| 21456 | Mixed Nuts 21456 | 31 31 | 520 | 570 | 2024-06-28 |
| 21457 | Caramel Waffles 21457 | 31 31 | 420 | 450 | 2024-06-28 |
| 21458 | Chicken Ham & Cheese Panwich 21458 | 31 31 | 720 | 770 | 2024-06-28 |
| 21459 | Egg Mayo & Cheese Multigrain Croissant 21459 | 31 31 | 720 | 770 | 2024-06-28 |
| 21460 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 21460 | 31 31 | 720 | 770 | 2024-06-28 |
| 21461 | Rosemary Chicken & Emmental Cheese Croissant 21461 | 31 31 | 720 | 770 | 2024-06-28 |
| 21462 | Scrambled Egg & Turkey Ham Pita 21462 | 31 31 | 720 | 770 | 2024-06-28 |
| 21463 | Turkey Ham & Triple Cheese Toast 21463 | 31 31 | 720 | 770 | 2024-06-28 |
| 21464 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 21464 | 31 31 | 820 | 870 | 2024-06-28 |
| 21465 | Ham & Cheese Croissant 21465 | 31 31 | 720 | 770 | 2024-06-28 |
| 21466 | Sriracha Chicken Whole Wheat Pita 21466 | 31 31 | 780 | 830 | 2024-06-28 |
| 21467 | Blueberry Acai Yogurt Parfait 21467 | 31 31 | 680 | 730 | 2024-06-28 |
| 21468 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 21468 | 31 31 | 680 | 730 | 2024-06-28 |
| 21469 | Caramel Frappuccino® 21469 | 31 31 | 780 | 830 | 2024-06-28 |
| 21470 | Dark Mocha Frappuccino® 21470 | 31 31 | 840 | 890 | 2024-06-28 |
| 21471 | Java Chip Frappuccino® 21471 | 31 31 | 840 | 890 | 2024-06-28 |
| 21472 | Mocha Frappuccino® 21472 | 31 31 | 780 | 830 | 2024-06-28 |
| 21473 | Caramel Macchiato Frappuccino® 21473 | 31 31 | 840 | 890 | 2024-06-28 |
| 21474 | Espresso Frappuccino® 21474 | 31 31 | 780 | 830 | 2024-06-28 |
| 21475 | White Chocolate Mocha Frappuccino® 21475 | 31 31 | 780 | 830 | 2024-06-28 |
| 21476 | Chocolate Chip Cream Frappuccino® 21476 | 31 31 | 840 | 890 | 2024-06-28 |
| 21477 | Hojicha Tea Cream Frappuccino® 21477 | 31 31 | 820 | 870 | 2024-06-28 |
| 21478 | Vanilla Cream Frappuccino® 21478 | 31 31 | 780 | 830 | 2024-06-28 |
| 21479 | Mango Passion Fruit & Hibiscus 21479 | 31 31 | 780 | 830 | 2024-06-28 |
| 21480 | Raspberry Black Currant & Oolong 21480 | 31 31 | 780 | 830 | 2024-06-28 |
| 21481 | Coffee Traveller 21481 | 31 31 | 3600 | 3650 | 2024-06-28 |
| 21482 | Caffè Americano 21482 | 31 31 | 600 | 650 | 2024-06-28 |
| 21483 | Cappuccino 21483 | 31 31 | 740 | 790 | 2024-06-28 |
| 21484 | Caffè Mocha 21484 | 31 31 | 830 | 880 | 2024-06-28 |
| 21485 | Caramel Macchiato 21485 | 31 31 | 840 | 890 | 2024-06-28 |
| 21486 | Espresso 21486 | 31 31 | 450 | 500 | 2024-06-28 |
| 21487 | Caffè Latte 21487 | 31 31 | 740 | 790 | 2024-06-28 |
| 21488 | Oatmilk Latte 21488 | 31 31 | 850 | 900 | 2024-06-28 |
| 21489 | Vanilla Latte 21489 | 31 31 | 830 | 880 | 2024-06-28 |
| 21490 | White Chocolate Mocha 21490 | 31 31 | 830 | 880 | 2024-06-28 |
| 21491 | Flat White 21491 | 31 31 | 840 | 890 | 2024-06-28 |
| 21492 | Ristretto Bianco 21492 | 31 31 | 840 | 890 | 2024-06-28 |
| 21493 | Iced Caffè Americano 21493 | 31 31 | 600 | 650 | 2024-06-28 |
| 21494 | Iced Cappuccino 21494 | 31 31 | 740 | 790 | 2024-06-28 |
| 21495 | Iced Caffè Mocha 21495 | 31 31 | 830 | 880 | 2024-06-28 |
| 21496 | Iced Caramel Macchiato 21496 | 31 31 | 840 | 890 | 2024-06-28 |
| 21497 | Iced Caffè Latte 21497 | 31 31 | 740 | 790 | 2024-06-28 |
| 21498 | Iced Oatmilk Latte 21498 | 31 31 | 850 | 900 | 2024-06-28 |
| 21499 | Iced Vanilla Latte 21499 | 31 31 | 830 | 880 | 2024-06-28 |
| 21500 | Iced White Chocolate Mocha 21500 | 31 31 | 830 | 880 | 2024-06-28 |
| 21501 | Signature Hot Chocolate 21501 | 31 31 | 780 | 830 | 2024-06-28 |
| 21502 | Signature Iced Chocolate 21502 | 31 31 | 780 | 830 | 2024-06-28 |
| 21503 | Carrot Juice 21503 | 31 31 | 550 | 600 | 2024-06-28 |
| 21504 | Cloudy Apple Juice 21504 | 31 31 | 550 | 600 | 2024-06-28 |
| 21505 | Cranberry Red Grapefruit Juice 21505 | 31 31 | 550 | 600 | 2024-06-28 |
| 21506 | Orange Juice 21506 | 31 31 | 550 | 600 | 2024-06-28 |
| 21507 | Evian 21507 | 31 31 | 410 | 460 | 2024-06-28 |
| 21508 | Sparkling Water 21508 | 31 31 | 510 | 560 | 2024-06-28 |
| 21509 | Chai Tea 21509 | 31 31 | 560 | 610 | 2024-06-28 |
| 21510 | Earl Grey Tea 21510 | 31 31 | 560 | 610 | 2024-06-28 |
| 21511 | English Breakfast Tea 21511 | 31 31 | 560 | 610 | 2024-06-28 |
| 21512 | Emperor’s Clouds & Mist™ Tea 21512 | 31 31 | 560 | 610 | 2024-06-28 |
| 21513 | Mint Blend Tea 21513 | 31 31 | 560 | 610 | 2024-06-28 |
| 21514 | Chamomile Tea 21514 | 31 31 | 560 | 610 | 2024-06-28 |
| 21515 | Pure Matcha Latte 21515 | 31 31 | 810 | 860 | 2024-06-28 |
| 21516 | Chai Tea Latte 21516 | 31 31 | 740 | 790 | 2024-06-28 |
| 21517 | Earl Grey Tea Latte 21517 | 31 31 | 740 | 790 | 2024-06-28 |
| 21518 | English Breakfast Tea Latte 21518 | 31 31 | 740 | 790 | 2024-06-28 |
| 21519 | Hojicha Tea Latte 21519 | 31 31 | 810 | 860 | 2024-06-28 |
| 21520 | Zen Clouds Oolong Tea 21520 | 31 31 | 560 | 610 | 2024-06-28 |
| 21521 | Zen Clouds Oolong with Ruby Grapefruit and Honey 21521 | 31 31 | 690 | 740 | 2024-06-28 |
| 21522 | Youthberry™ Tea 21522 | 31 31 | 560 | 610 | 2024-06-28 |
| 21523 | Iced Shaken Black Tea Lemonade 21523 | 31 31 | 670 | 720 | 2024-06-28 |
| 21524 | Iced Shaken Strawberry Black Tea Lemonade 21524 | 31 31 | 690 | 740 | 2024-06-28 |
| 21525 | Iced Shaken Hibiscus Tea Lemonade 21525 | 31 31 | 670 | 720 | 2024-06-28 |
| 21526 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 21526 | 31 31 | 790 | 840 | 2024-06-28 |
| 21527 | Iced Pure Matcha Latte 21527 | 31 31 | 810 | 860 | 2024-06-28 |
| 21528 | Iced Chai Tea Latte 21528 | 31 31 | 740 | 790 | 2024-06-28 |
| 21529 | Iced Black Tea Latte 21529 | 31 31 | 740 | 790 | 2024-06-28 |
| 21530 | Iced Hojicha Tea Latte 21530 | 31 31 | 810 | 860 | 2024-06-28 |
| 21531 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 21531 | 31 31 | 690 | 740 | 2024-06-28 |
| 21532 | Iced Shaken Zen Clouds Oolong Lemonade 21532 | 31 31 | 670 | 720 | 2024-06-28 |
| 21533 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 21533 | 31 31 | 690 | 740 | 2024-06-28 |
| 21534 | Origami Pike Place® Roast 21534 | 31 31 | 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");