item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 73
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 11
- 2024-06-28 182
- 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
- 73 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 14482 | Bagel 14482 | 73 73 | 430 | 460 | 2024-06-28 |
| 14483 | Cookie Crumble Cheesecake 14483 | 73 73 | 750 | 800 | 2024-06-28 |
| 14484 | Good Ol' NY Cheesecake 14484 | 73 73 | 750 | 800 | 2024-06-28 |
| 14485 | Signature Chocolate Cake 14485 | 73 73 | 750 | 800 | 2024-06-28 |
| 14486 | Starbucks® Coffee Tiramisu Cake 14486 | 73 73 | 780 | 830 | 2024-06-28 |
| 14487 | Strawberry Shortcake 14487 | 73 73 | 750 | 800 | 2024-06-28 |
| 14488 | Chocolate Chunk Monster Cookie 14488 | 73 73 | 420 | 470 | 2024-06-28 |
| 14489 | Banana Walnut Muffin 14489 | 73 73 | 480 | 530 | 2024-06-28 |
| 14490 | Blueberry Crumble Muffin 14490 | 73 73 | 480 | 530 | 2024-06-28 |
| 14491 | Chocolate Crumble Muffin 14491 | 73 73 | 480 | 530 | 2024-06-28 |
| 14492 | Pancakes 14492 | 73 73 | 580 | 630 | 2024-06-28 |
| 14493 | Almond Croissant 14493 | 73 73 | 500 | 550 | 2024-06-28 |
| 14494 | Buttery Croissant 14494 | 73 73 | 430 | 460 | 2024-06-28 |
| 14495 | Chocolate Croissant 14495 | 73 73 | 470 | 520 | 2024-06-28 |
| 14496 | Creamy Chicken Foldover 14496 | 73 73 | 580 | 630 | 2024-06-28 |
| 14497 | Sausage Roll 14497 | 73 73 | 580 | 630 | 2024-06-28 |
| 14498 | Buttery Scone 14498 | 73 73 | 430 | 460 | 2024-06-28 |
| 14499 | Country Chicken Pie 14499 | 73 73 | 720 | 770 | 2024-06-28 |
| 14500 | Deep Dish Beef Pie 14500 | 73 73 | 720 | 770 | 2024-06-28 |
| 14501 | Spinach & Mushroom Quiche 14501 | 73 73 | 720 | 770 | 2024-06-28 |
| 14502 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 14502 | 73 73 | 420 | 450 | 2024-06-28 |
| 14503 | Mixed Nuts 14503 | 73 73 | 520 | 570 | 2024-06-28 |
| 14504 | Caramel Waffles 14504 | 73 73 | 420 | 450 | 2024-06-28 |
| 14505 | Chicken Ham & Cheese Panwich 14505 | 73 73 | 720 | 770 | 2024-06-28 |
| 14506 | Egg Mayo & Cheese Multigrain Croissant 14506 | 73 73 | 720 | 770 | 2024-06-28 |
| 14507 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 14507 | 73 73 | 720 | 770 | 2024-06-28 |
| 14508 | Rosemary Chicken & Emmental Cheese Croissant 14508 | 73 73 | 720 | 770 | 2024-06-28 |
| 14509 | Scrambled Egg & Turkey Ham Pita 14509 | 73 73 | 720 | 770 | 2024-06-28 |
| 14510 | Turkey Ham & Triple Cheese Toast 14510 | 73 73 | 720 | 770 | 2024-06-28 |
| 14511 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 14511 | 73 73 | 820 | 870 | 2024-06-28 |
| 14512 | Ham & Cheese Croissant 14512 | 73 73 | 720 | 770 | 2024-06-28 |
| 14513 | Sriracha Chicken Whole Wheat Pita 14513 | 73 73 | 780 | 830 | 2024-06-28 |
| 14514 | Blueberry Acai Yogurt Parfait 14514 | 73 73 | 680 | 730 | 2024-06-28 |
| 14515 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 14515 | 73 73 | 680 | 730 | 2024-06-28 |
| 14516 | Caramel Frappuccino® 14516 | 73 73 | 780 | 830 | 2024-06-28 |
| 14517 | Dark Mocha Frappuccino® 14517 | 73 73 | 840 | 890 | 2024-06-28 |
| 14518 | Java Chip Frappuccino® 14518 | 73 73 | 840 | 890 | 2024-06-28 |
| 14519 | Mocha Frappuccino® 14519 | 73 73 | 780 | 830 | 2024-06-28 |
| 14520 | Caramel Macchiato Frappuccino® 14520 | 73 73 | 840 | 890 | 2024-06-28 |
| 14521 | Espresso Frappuccino® 14521 | 73 73 | 780 | 830 | 2024-06-28 |
| 14522 | White Chocolate Mocha Frappuccino® 14522 | 73 73 | 780 | 830 | 2024-06-28 |
| 14523 | Chocolate Chip Cream Frappuccino® 14523 | 73 73 | 840 | 890 | 2024-06-28 |
| 14524 | Hojicha Tea Cream Frappuccino® 14524 | 73 73 | 820 | 870 | 2024-06-28 |
| 14525 | Vanilla Cream Frappuccino® 14525 | 73 73 | 780 | 830 | 2024-06-28 |
| 14526 | Mango Passion Fruit & Hibiscus 14526 | 73 73 | 780 | 830 | 2024-06-28 |
| 14527 | Raspberry Black Currant & Oolong 14527 | 73 73 | 780 | 830 | 2024-06-28 |
| 14528 | Coffee Traveller 14528 | 73 73 | 3600 | 3650 | 2024-06-28 |
| 14529 | Caffè Americano 14529 | 73 73 | 600 | 650 | 2024-06-28 |
| 14530 | Cappuccino 14530 | 73 73 | 740 | 790 | 2024-06-28 |
| 14531 | Caffè Mocha 14531 | 73 73 | 830 | 880 | 2024-06-28 |
| 14532 | Caramel Macchiato 14532 | 73 73 | 840 | 890 | 2024-06-28 |
| 14533 | Espresso 14533 | 73 73 | 450 | 500 | 2024-06-28 |
| 14534 | Caffè Latte 14534 | 73 73 | 740 | 790 | 2024-06-28 |
| 14535 | Oatmilk Latte 14535 | 73 73 | 850 | 900 | 2024-06-28 |
| 14536 | Vanilla Latte 14536 | 73 73 | 830 | 880 | 2024-06-28 |
| 14537 | White Chocolate Mocha 14537 | 73 73 | 830 | 880 | 2024-06-28 |
| 14538 | Flat White 14538 | 73 73 | 840 | 890 | 2024-06-28 |
| 14539 | Ristretto Bianco 14539 | 73 73 | 840 | 890 | 2024-06-28 |
| 14540 | Iced Caffè Americano 14540 | 73 73 | 600 | 650 | 2024-06-28 |
| 14541 | Iced Cappuccino 14541 | 73 73 | 740 | 790 | 2024-06-28 |
| 14542 | Iced Caffè Mocha 14542 | 73 73 | 830 | 880 | 2024-06-28 |
| 14543 | Iced Caramel Macchiato 14543 | 73 73 | 840 | 890 | 2024-06-28 |
| 14544 | Iced Caffè Latte 14544 | 73 73 | 740 | 790 | 2024-06-28 |
| 14545 | Iced Oatmilk Latte 14545 | 73 73 | 850 | 900 | 2024-06-28 |
| 14546 | Iced Vanilla Latte 14546 | 73 73 | 830 | 880 | 2024-06-28 |
| 14547 | Iced White Chocolate Mocha 14547 | 73 73 | 830 | 880 | 2024-06-28 |
| 14548 | Signature Hot Chocolate 14548 | 73 73 | 780 | 830 | 2024-06-28 |
| 14549 | Signature Iced Chocolate 14549 | 73 73 | 780 | 830 | 2024-06-28 |
| 14550 | Carrot Juice 14550 | 73 73 | 550 | 600 | 2024-06-28 |
| 14551 | Cloudy Apple Juice 14551 | 73 73 | 550 | 600 | 2024-06-28 |
| 14552 | Cranberry Red Grapefruit Juice 14552 | 73 73 | 550 | 600 | 2024-06-28 |
| 14553 | Orange Juice 14553 | 73 73 | 550 | 600 | 2024-06-28 |
| 14554 | Evian 14554 | 73 73 | 410 | 460 | 2024-06-28 |
| 14555 | Sparkling Water 14555 | 73 73 | 510 | 560 | 2024-06-28 |
| 14556 | Chai Tea 14556 | 73 73 | 560 | 610 | 2024-06-28 |
| 14557 | Earl Grey Tea 14557 | 73 73 | 560 | 610 | 2024-06-28 |
| 14558 | English Breakfast Tea 14558 | 73 73 | 560 | 610 | 2024-06-28 |
| 14559 | Emperor’s Clouds & Mist™ Tea 14559 | 73 73 | 560 | 610 | 2024-06-28 |
| 14560 | Mint Blend Tea 14560 | 73 73 | 560 | 610 | 2024-06-28 |
| 14561 | Chamomile Tea 14561 | 73 73 | 560 | 610 | 2024-06-28 |
| 14562 | Pure Matcha Latte 14562 | 73 73 | 810 | 860 | 2024-06-28 |
| 14563 | Chai Tea Latte 14563 | 73 73 | 740 | 790 | 2024-06-28 |
| 14564 | Earl Grey Tea Latte 14564 | 73 73 | 740 | 790 | 2024-06-28 |
| 14565 | English Breakfast Tea Latte 14565 | 73 73 | 740 | 790 | 2024-06-28 |
| 14566 | Hojicha Tea Latte 14566 | 73 73 | 810 | 860 | 2024-06-28 |
| 14567 | Zen Clouds Oolong Tea 14567 | 73 73 | 560 | 610 | 2024-06-28 |
| 14568 | Zen Clouds Oolong with Ruby Grapefruit and Honey 14568 | 73 73 | 690 | 740 | 2024-06-28 |
| 14569 | Youthberry™ Tea 14569 | 73 73 | 560 | 610 | 2024-06-28 |
| 14570 | Iced Shaken Black Tea Lemonade 14570 | 73 73 | 670 | 720 | 2024-06-28 |
| 14571 | Iced Shaken Strawberry Black Tea Lemonade 14571 | 73 73 | 690 | 740 | 2024-06-28 |
| 14572 | Iced Shaken Hibiscus Tea Lemonade 14572 | 73 73 | 670 | 720 | 2024-06-28 |
| 14573 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 14573 | 73 73 | 790 | 840 | 2024-06-28 |
| 14574 | Iced Pure Matcha Latte 14574 | 73 73 | 810 | 860 | 2024-06-28 |
| 14575 | Iced Chai Tea Latte 14575 | 73 73 | 740 | 790 | 2024-06-28 |
| 14576 | Iced Black Tea Latte 14576 | 73 73 | 740 | 790 | 2024-06-28 |
| 14577 | Iced Hojicha Tea Latte 14577 | 73 73 | 810 | 860 | 2024-06-28 |
| 14578 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 14578 | 73 73 | 690 | 740 | 2024-06-28 |
| 14579 | Iced Shaken Zen Clouds Oolong Lemonade 14579 | 73 73 | 670 | 720 | 2024-06-28 |
| 14580 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 14580 | 73 73 | 690 | 740 | 2024-06-28 |
| 14581 | Origami Pike Place® Roast 14581 | 73 73 | 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");