item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
249 rows where store_id = 2
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 13
- 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
- 2024-11-17 1
store_id 1
- 2 · 249 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 25671 | Bagel 25671 | 2 2 | 400 | 430 | 2024-06-28 |
| 25672 | Cookie Crumble Cheesecake 25672 | 2 2 | 720 | 770 | 2024-06-28 |
| 25673 | Good Ol' NY Cheesecake 25673 | 2 2 | 720 | 770 | 2024-06-28 |
| 25674 | Signature Chocolate Cake 25674 | 2 2 | 720 | 770 | 2024-06-28 |
| 25675 | Starbucks® Coffee Tiramisu Cake 25675 | 2 2 | 750 | 800 | 2024-06-28 |
| 25676 | Strawberry Shortcake 25676 | 2 2 | 720 | 770 | 2024-06-28 |
| 25677 | Chocolate Chunk Monster Cookie 25677 | 2 2 | 390 | 440 | 2024-06-28 |
| 25678 | Banana Walnut Muffin 25678 | 2 2 | 450 | 500 | 2024-06-28 |
| 25679 | Blueberry Crumble Muffin 25679 | 2 2 | 450 | 500 | 2024-06-28 |
| 25680 | Chocolate Crumble Muffin 25680 | 2 2 | 450 | 500 | 2024-06-28 |
| 25681 | Pancakes 25681 | 2 2 | 550 | 600 | 2024-06-28 |
| 25682 | Almond Croissant 25682 | 2 2 | 470 | 520 | 2024-06-28 |
| 25683 | Buttery Croissant 25683 | 2 2 | 400 | 430 | 2024-06-28 |
| 25684 | Chocolate Croissant 25684 | 2 2 | 440 | 490 | 2024-06-28 |
| 25685 | Creamy Chicken Foldover 25685 | 2 2 | 550 | 600 | 2024-06-28 |
| 25686 | Sausage Roll 25686 | 2 2 | 550 | 600 | 2024-06-28 |
| 25687 | Buttery Scone 25687 | 2 2 | 400 | 430 | 2024-06-28 |
| 25688 | Country Chicken Pie 25688 | 2 2 | 690 | 740 | 2024-06-28 |
| 25689 | Deep Dish Beef Pie 25689 | 2 2 | 690 | 740 | 2024-06-28 |
| 25690 | Spinach & Mushroom Quiche 25690 | 2 2 | 690 | 740 | 2024-06-28 |
| 25691 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 25691 | 2 2 | 390 | 420 | 2024-06-28 |
| 25692 | Mixed Nuts 25692 | 2 2 | 490 | 540 | 2024-06-28 |
| 25693 | Caramel Waffles 25693 | 2 2 | 390 | 420 | 2024-06-28 |
| 25694 | Chicken Ham & Cheese Panwich 25694 | 2 2 | 690 | 740 | 2024-06-28 |
| 25695 | Egg Mayo & Cheese Multigrain Croissant 25695 | 2 2 | 690 | 740 | 2024-06-28 |
| 25696 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 25696 | 2 2 | 690 | 740 | 2024-06-28 |
| 25697 | Rosemary Chicken & Emmental Cheese Croissant 25697 | 2 2 | 690 | 740 | 2024-06-28 |
| 25698 | Scrambled Egg & Turkey Ham Pita 25698 | 2 2 | 690 | 740 | 2024-06-28 |
| 25699 | Turkey Ham & Triple Cheese Toast 25699 | 2 2 | 690 | 740 | 2024-06-28 |
| 25700 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 25700 | 2 2 | 790 | 840 | 2024-06-28 |
| 25701 | Ham & Cheese Croissant 25701 | 2 2 | 690 | 740 | 2024-06-28 |
| 25702 | Sriracha Chicken Whole Wheat Pita 25702 | 2 2 | 750 | 800 | 2024-06-28 |
| 25703 | Blueberry Acai Yogurt Parfait 25703 | 2 2 | 650 | 700 | 2024-06-28 |
| 25704 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 25704 | 2 2 | 650 | 700 | 2024-06-28 |
| 25705 | Caramel Frappuccino® 25705 | 2 2 | 720 | 770 | 2024-06-28 |
| 25706 | Dark Mocha Frappuccino® 25706 | 2 2 | 780 | 830 | 2024-06-28 |
| 25707 | Java Chip Frappuccino® 25707 | 2 2 | 780 | 830 | 2024-06-28 |
| 25708 | Mocha Frappuccino® 25708 | 2 2 | 720 | 770 | 2024-06-28 |
| 25709 | Caramel Macchiato Frappuccino® 25709 | 2 2 | 780 | 830 | 2024-06-28 |
| 25710 | Espresso Frappuccino® 25710 | 2 2 | 720 | 770 | 2024-06-28 |
| 25711 | White Chocolate Mocha Frappuccino® 25711 | 2 2 | 720 | 770 | 2024-06-28 |
| 25712 | Chocolate Chip Cream Frappuccino® 25712 | 2 2 | 780 | 830 | 2024-06-28 |
| 25713 | Hojicha Tea Cream Frappuccino® 25713 | 2 2 | 760 | 810 | 2024-06-28 |
| 25714 | Vanilla Cream Frappuccino® 25714 | 2 2 | 720 | 770 | 2024-06-28 |
| 25715 | Mango Passion Fruit & Hibiscus 25715 | 2 2 | 720 | 770 | 2024-06-28 |
| 25716 | Raspberry Black Currant & Oolong 25716 | 2 2 | 720 | 770 | 2024-06-28 |
| 25717 | Coffee Traveller 25717 | 2 2 | 3120 | 3170 | 2024-06-28 |
| 25718 | Caffè Americano 25718 | 2 2 | 540 | 590 | 2024-06-28 |
| 25719 | Cappuccino 25719 | 2 2 | 680 | 730 | 2024-06-28 |
| 25720 | Caffè Mocha 25720 | 2 2 | 750 | 800 | 2024-06-28 |
| 25721 | Caramel Macchiato 25721 | 2 2 | 760 | 810 | 2024-06-28 |
| 25722 | Espresso 25722 | 2 2 | 390 | 440 | 2024-06-28 |
| 25723 | Caffè Latte 25723 | 2 2 | 680 | 730 | 2024-06-28 |
| 25724 | Oatmilk Latte 25724 | 2 2 | 760 | 810 | 2024-06-28 |
| 25725 | Vanilla Latte 25725 | 2 2 | 750 | 800 | 2024-06-28 |
| 25726 | White Chocolate Mocha 25726 | 2 2 | 750 | 800 | 2024-06-28 |
| 25727 | Flat White 25727 | 2 2 | 760 | 810 | 2024-06-28 |
| 25728 | Ristretto Bianco 25728 | 2 2 | 760 | 810 | 2024-06-28 |
| 25729 | Iced Caffè Americano 25729 | 2 2 | 540 | 590 | 2024-06-28 |
| 25730 | Iced Cappuccino 25730 | 2 2 | 680 | 730 | 2024-06-28 |
| 25731 | Iced Caffè Mocha 25731 | 2 2 | 750 | 800 | 2024-06-28 |
| 25732 | Iced Caramel Macchiato 25732 | 2 2 | 760 | 810 | 2024-06-28 |
| 25733 | Iced Caffè Latte 25733 | 2 2 | 680 | 730 | 2024-06-28 |
| 25734 | Iced Oatmilk Latte 25734 | 2 2 | 760 | 810 | 2024-06-28 |
| 25735 | Iced Vanilla Latte 25735 | 2 2 | 750 | 800 | 2024-06-28 |
| 25736 | Iced White Chocolate Mocha 25736 | 2 2 | 750 | 800 | 2024-06-28 |
| 25737 | Signature Hot Chocolate 25737 | 2 2 | 720 | 770 | 2024-06-28 |
| 25738 | Signature Iced Chocolate 25738 | 2 2 | 720 | 770 | 2024-06-28 |
| 25739 | Carrot Juice 25739 | 2 2 | 490 | 540 | 2024-06-28 |
| 25740 | Cloudy Apple Juice 25740 | 2 2 | 490 | 540 | 2024-06-28 |
| 25741 | Cranberry Red Grapefruit Juice 25741 | 2 2 | 490 | 540 | 2024-06-28 |
| 25742 | Orange Juice 25742 | 2 2 | 490 | 540 | 2024-06-28 |
| 25743 | Evian 25743 | 2 2 | 350 | 400 | 2024-06-28 |
| 25744 | Sparkling Water 25744 | 2 2 | 450 | 500 | 2024-06-28 |
| 25745 | Chai Tea 25745 | 2 2 | 500 | 550 | 2024-06-28 |
| 25746 | Earl Grey Tea 25746 | 2 2 | 500 | 550 | 2024-06-28 |
| 25747 | English Breakfast Tea 25747 | 2 2 | 500 | 550 | 2024-06-28 |
| 25748 | Emperor’s Clouds & Mist™ Tea 25748 | 2 2 | 500 | 550 | 2024-06-28 |
| 25749 | Mint Blend Tea 25749 | 2 2 | 500 | 550 | 2024-06-28 |
| 25750 | Chamomile Tea 25750 | 2 2 | 500 | 550 | 2024-06-28 |
| 25751 | Pure Matcha Latte 25751 | 2 2 | 740 | 790 | 2024-06-28 |
| 25752 | Chai Tea Latte 25752 | 2 2 | 680 | 730 | 2024-06-28 |
| 25753 | Earl Grey Tea Latte 25753 | 2 2 | 680 | 730 | 2024-06-28 |
| 25754 | English Breakfast Tea Latte 25754 | 2 2 | 680 | 730 | 2024-06-28 |
| 25755 | Hojicha Tea Latte 25755 | 2 2 | 740 | 790 | 2024-06-28 |
| 25756 | Zen Clouds Oolong Tea 25756 | 2 2 | 500 | 550 | 2024-06-28 |
| 25757 | Zen Clouds Oolong with Ruby Grapefruit and Honey 25757 | 2 2 | 630 | 680 | 2024-06-28 |
| 25758 | Youthberry™ Tea 25758 | 2 2 | 500 | 550 | 2024-06-28 |
| 25759 | Iced Shaken Black Tea Lemonade 25759 | 2 2 | 610 | 660 | 2024-06-28 |
| 25760 | Iced Shaken Strawberry Black Tea Lemonade 25760 | 2 2 | 630 | 680 | 2024-06-28 |
| 25761 | Iced Shaken Hibiscus Tea Lemonade 25761 | 2 2 | 610 | 660 | 2024-06-28 |
| 25762 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 25762 | 2 2 | 730 | 780 | 2024-06-28 |
| 25763 | Iced Pure Matcha Latte 25763 | 2 2 | 740 | 790 | 2024-06-28 |
| 25764 | Iced Chai Tea Latte 25764 | 2 2 | 680 | 730 | 2024-06-28 |
| 25765 | Iced Black Tea Latte 25765 | 2 2 | 680 | 730 | 2024-06-28 |
| 25766 | Iced Hojicha Tea Latte 25766 | 2 2 | 740 | 790 | 2024-06-28 |
| 25767 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 25767 | 2 2 | 630 | 680 | 2024-06-28 |
| 25768 | Iced Shaken Zen Clouds Oolong Lemonade 25768 | 2 2 | 610 | 660 | 2024-06-28 |
| 25769 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 25769 | 2 2 | 630 | 680 | 2024-06-28 |
| 25770 | Origami Pike Place® Roast 25770 | 2 2 | 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");