item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
239 rows where store_id = 87
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 11
- 2024-06-28 193
- 2024-09-15 10
- 2024-07-17 7
- 2024-07-28 7
- 2024-08-18 5
- 2024-07-03 4
- 2024-10-06 4
- 2024-10-13 4
- 2024-07-14 2
- 2024-09-29 2
- 2024-10-27 1
store_id 1
- 87 · 239 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 12647 | Bagel 12647 | 87 87 | 400 | 430 | 2024-06-28 |
| 12648 | Cookie Crumble Cheesecake 12648 | 87 87 | 720 | 770 | 2024-06-28 |
| 12649 | Good Ol' NY Cheesecake 12649 | 87 87 | 720 | 770 | 2024-06-28 |
| 12650 | Signature Chocolate Cake 12650 | 87 87 | 720 | 770 | 2024-06-28 |
| 12651 | Starbucks® Coffee Tiramisu Cake 12651 | 87 87 | 750 | 800 | 2024-06-28 |
| 12652 | Strawberry Shortcake 12652 | 87 87 | 720 | 770 | 2024-06-28 |
| 12653 | Chocolate Chunk Monster Cookie 12653 | 87 87 | 390 | 440 | 2024-06-28 |
| 12654 | Banana Walnut Muffin 12654 | 87 87 | 450 | 500 | 2024-06-28 |
| 12655 | Blueberry Crumble Muffin 12655 | 87 87 | 450 | 500 | 2024-06-28 |
| 12656 | Chocolate Crumble Muffin 12656 | 87 87 | 450 | 500 | 2024-06-28 |
| 12657 | Pancakes 12657 | 87 87 | 550 | 600 | 2024-06-28 |
| 12658 | Almond Croissant 12658 | 87 87 | 470 | 520 | 2024-06-28 |
| 12659 | Buttery Croissant 12659 | 87 87 | 400 | 430 | 2024-06-28 |
| 12660 | Chocolate Croissant 12660 | 87 87 | 440 | 490 | 2024-06-28 |
| 12661 | Creamy Chicken Foldover 12661 | 87 87 | 550 | 600 | 2024-06-28 |
| 12662 | Sausage Roll 12662 | 87 87 | 550 | 600 | 2024-06-28 |
| 12663 | Buttery Scone 12663 | 87 87 | 400 | 430 | 2024-06-28 |
| 12664 | Country Chicken Pie 12664 | 87 87 | 690 | 740 | 2024-06-28 |
| 12665 | Deep Dish Beef Pie 12665 | 87 87 | 690 | 740 | 2024-06-28 |
| 12666 | Spinach & Mushroom Quiche 12666 | 87 87 | 690 | 740 | 2024-06-28 |
| 12667 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 12667 | 87 87 | 390 | 420 | 2024-06-28 |
| 12668 | Mixed Nuts 12668 | 87 87 | 490 | 540 | 2024-06-28 |
| 12669 | Caramel Waffles 12669 | 87 87 | 390 | 420 | 2024-06-28 |
| 12670 | Chicken Ham & Cheese Panwich 12670 | 87 87 | 690 | 740 | 2024-06-28 |
| 12671 | Egg Mayo & Cheese Multigrain Croissant 12671 | 87 87 | 690 | 740 | 2024-06-28 |
| 12672 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 12672 | 87 87 | 690 | 740 | 2024-06-28 |
| 12673 | Rosemary Chicken & Emmental Cheese Croissant 12673 | 87 87 | 690 | 740 | 2024-06-28 |
| 12674 | Scrambled Egg & Turkey Ham Pita 12674 | 87 87 | 690 | 740 | 2024-06-28 |
| 12675 | Turkey Ham & Triple Cheese Toast 12675 | 87 87 | 690 | 740 | 2024-06-28 |
| 12676 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 12676 | 87 87 | 790 | 840 | 2024-06-28 |
| 12677 | Ham & Cheese Croissant 12677 | 87 87 | 690 | 740 | 2024-06-28 |
| 12678 | Sriracha Chicken Whole Wheat Pita 12678 | 87 87 | 750 | 800 | 2024-06-28 |
| 12679 | Blueberry Acai Yogurt Parfait 12679 | 87 87 | 650 | 700 | 2024-06-28 |
| 12680 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 12680 | 87 87 | 650 | 700 | 2024-06-28 |
| 12681 | Buttery Croissant 12681 | 87 87 | 400 | 450 | 2024-06-28 |
| 12682 | Chocolate Croissant 12682 | 87 87 | 440 | 490 | 2024-06-28 |
| 12683 | Raisin Danish 12683 | 87 87 | 470 | 520 | 2024-06-28 |
| 12684 | Apple Tart 12684 | 87 87 | 620 | 670 | 2024-06-28 |
| 12685 | Lemon Meringue Tart 12685 | 87 87 | 620 | 670 | 2024-06-28 |
| 12686 | Caramel Frappuccino® 12686 | 87 87 | 720 | 770 | 2024-06-28 |
| 12687 | Dark Mocha Frappuccino® 12687 | 87 87 | 780 | 830 | 2024-06-28 |
| 12688 | Java Chip Frappuccino® 12688 | 87 87 | 780 | 830 | 2024-06-28 |
| 12689 | Mocha Frappuccino® 12689 | 87 87 | 720 | 770 | 2024-06-28 |
| 12690 | Caramel Macchiato Frappuccino® 12690 | 87 87 | 780 | 830 | 2024-06-28 |
| 12691 | Espresso Frappuccino® 12691 | 87 87 | 720 | 770 | 2024-06-28 |
| 12692 | White Chocolate Mocha Frappuccino® 12692 | 87 87 | 720 | 770 | 2024-06-28 |
| 12693 | Chocolate Chip Cream Frappuccino® 12693 | 87 87 | 780 | 830 | 2024-06-28 |
| 12694 | Hojicha Tea Cream Frappuccino® 12694 | 87 87 | 760 | 810 | 2024-06-28 |
| 12695 | Vanilla Cream Frappuccino® 12695 | 87 87 | 720 | 770 | 2024-06-28 |
| 12696 | Mango Passion Fruit & Hibiscus 12696 | 87 87 | 720 | 770 | 2024-06-28 |
| 12697 | Raspberry Black Currant & Oolong 12697 | 87 87 | 720 | 770 | 2024-06-28 |
| 12698 | Coffee Traveller 12698 | 87 87 | 3120 | 3170 | 2024-06-28 |
| 12699 | Caffè Americano 12699 | 87 87 | 540 | 590 | 2024-06-28 |
| 12700 | Cappuccino 12700 | 87 87 | 680 | 730 | 2024-06-28 |
| 12701 | Caffè Mocha 12701 | 87 87 | 750 | 800 | 2024-06-28 |
| 12702 | Caramel Macchiato 12702 | 87 87 | 760 | 810 | 2024-06-28 |
| 12703 | Espresso 12703 | 87 87 | 390 | 440 | 2024-06-28 |
| 12704 | Caffè Latte 12704 | 87 87 | 680 | 730 | 2024-06-28 |
| 12705 | Oatmilk Latte 12705 | 87 87 | 760 | 810 | 2024-06-28 |
| 12706 | Vanilla Latte 12706 | 87 87 | 750 | 800 | 2024-06-28 |
| 12707 | White Chocolate Mocha 12707 | 87 87 | 750 | 800 | 2024-06-28 |
| 12708 | Flat White 12708 | 87 87 | 760 | 810 | 2024-06-28 |
| 12709 | Ristretto Bianco 12709 | 87 87 | 760 | 810 | 2024-06-28 |
| 12710 | Iced Caffè Americano 12710 | 87 87 | 540 | 590 | 2024-06-28 |
| 12711 | Iced Cappuccino 12711 | 87 87 | 680 | 730 | 2024-06-28 |
| 12712 | Iced Caffè Mocha 12712 | 87 87 | 750 | 800 | 2024-06-28 |
| 12713 | Iced Caramel Macchiato 12713 | 87 87 | 760 | 810 | 2024-06-28 |
| 12714 | Iced Caffè Latte 12714 | 87 87 | 680 | 730 | 2024-06-28 |
| 12715 | Iced Oatmilk Latte 12715 | 87 87 | 760 | 810 | 2024-06-28 |
| 12716 | Iced Vanilla Latte 12716 | 87 87 | 750 | 800 | 2024-06-28 |
| 12717 | Iced White Chocolate Mocha 12717 | 87 87 | 750 | 800 | 2024-06-28 |
| 12718 | Signature Hot Chocolate 12718 | 87 87 | 720 | 770 | 2024-06-28 |
| 12719 | Signature Iced Chocolate 12719 | 87 87 | 720 | 770 | 2024-06-28 |
| 12720 | Carrot Juice 12720 | 87 87 | 490 | 540 | 2024-06-28 |
| 12721 | Cloudy Apple Juice 12721 | 87 87 | 490 | 540 | 2024-06-28 |
| 12722 | Cranberry Red Grapefruit Juice 12722 | 87 87 | 490 | 540 | 2024-06-28 |
| 12723 | Orange Juice 12723 | 87 87 | 490 | 540 | 2024-06-28 |
| 12724 | Evian 12724 | 87 87 | 350 | 400 | 2024-06-28 |
| 12725 | Sparkling Water 12725 | 87 87 | 450 | 500 | 2024-06-28 |
| 12726 | Chai Tea 12726 | 87 87 | 500 | 550 | 2024-06-28 |
| 12727 | Earl Grey Tea 12727 | 87 87 | 500 | 550 | 2024-06-28 |
| 12728 | English Breakfast Tea 12728 | 87 87 | 500 | 550 | 2024-06-28 |
| 12729 | Emperor’s Clouds & Mist™ Tea 12729 | 87 87 | 500 | 550 | 2024-06-28 |
| 12730 | Mint Blend Tea 12730 | 87 87 | 500 | 550 | 2024-06-28 |
| 12731 | Chamomile Tea 12731 | 87 87 | 500 | 550 | 2024-06-28 |
| 12732 | Pure Matcha Latte 12732 | 87 87 | 740 | 790 | 2024-06-28 |
| 12733 | Chai Tea Latte 12733 | 87 87 | 680 | 730 | 2024-06-28 |
| 12734 | Earl Grey Tea Latte 12734 | 87 87 | 680 | 730 | 2024-06-28 |
| 12735 | English Breakfast Tea Latte 12735 | 87 87 | 680 | 730 | 2024-06-28 |
| 12736 | Hojicha Tea Latte 12736 | 87 87 | 740 | 790 | 2024-06-28 |
| 12737 | Zen Clouds Oolong Tea 12737 | 87 87 | 500 | 550 | 2024-06-28 |
| 12738 | Zen Clouds Oolong with Ruby Grapefruit and Honey 12738 | 87 87 | 630 | 680 | 2024-06-28 |
| 12739 | Youthberry™ Tea 12739 | 87 87 | 500 | 550 | 2024-06-28 |
| 12740 | Iced Shaken Black Tea Lemonade 12740 | 87 87 | 610 | 660 | 2024-06-28 |
| 12741 | Iced Shaken Strawberry Black Tea Lemonade 12741 | 87 87 | 630 | 680 | 2024-06-28 |
| 12742 | Iced Shaken Hibiscus Tea Lemonade 12742 | 87 87 | 610 | 660 | 2024-06-28 |
| 12743 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 12743 | 87 87 | 730 | 780 | 2024-06-28 |
| 12744 | Iced Pure Matcha Latte 12744 | 87 87 | 740 | 790 | 2024-06-28 |
| 12745 | Iced Chai Tea Latte 12745 | 87 87 | 680 | 730 | 2024-06-28 |
| 12746 | Iced Black Tea Latte 12746 | 87 87 | 680 | 730 | 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");