item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
249 rows where store_id = 11
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
- 11 · 249 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 24724 | Bagel 24724 | 11 11 | 400 | 430 | 2024-06-28 |
| 24725 | Cookie Crumble Cheesecake 24725 | 11 11 | 720 | 770 | 2024-06-28 |
| 24726 | Good Ol' NY Cheesecake 24726 | 11 11 | 720 | 770 | 2024-06-28 |
| 24727 | Signature Chocolate Cake 24727 | 11 11 | 720 | 770 | 2024-06-28 |
| 24728 | Starbucks® Coffee Tiramisu Cake 24728 | 11 11 | 750 | 800 | 2024-06-28 |
| 24729 | Strawberry Shortcake 24729 | 11 11 | 720 | 770 | 2024-06-28 |
| 24730 | Chocolate Chunk Monster Cookie 24730 | 11 11 | 390 | 440 | 2024-06-28 |
| 24731 | Banana Walnut Muffin 24731 | 11 11 | 450 | 500 | 2024-06-28 |
| 24732 | Blueberry Crumble Muffin 24732 | 11 11 | 450 | 500 | 2024-06-28 |
| 24733 | Chocolate Crumble Muffin 24733 | 11 11 | 450 | 500 | 2024-06-28 |
| 24734 | Pancakes 24734 | 11 11 | 550 | 600 | 2024-06-28 |
| 24735 | Almond Croissant 24735 | 11 11 | 470 | 520 | 2024-06-28 |
| 24736 | Buttery Croissant 24736 | 11 11 | 400 | 430 | 2024-06-28 |
| 24737 | Chocolate Croissant 24737 | 11 11 | 440 | 490 | 2024-06-28 |
| 24738 | Creamy Chicken Foldover 24738 | 11 11 | 550 | 600 | 2024-06-28 |
| 24739 | Sausage Roll 24739 | 11 11 | 550 | 600 | 2024-06-28 |
| 24740 | Buttery Scone 24740 | 11 11 | 400 | 430 | 2024-06-28 |
| 24741 | Country Chicken Pie 24741 | 11 11 | 690 | 740 | 2024-06-28 |
| 24742 | Deep Dish Beef Pie 24742 | 11 11 | 690 | 740 | 2024-06-28 |
| 24743 | Spinach & Mushroom Quiche 24743 | 11 11 | 690 | 740 | 2024-06-28 |
| 24744 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 24744 | 11 11 | 390 | 420 | 2024-06-28 |
| 24745 | Mixed Nuts 24745 | 11 11 | 490 | 540 | 2024-06-28 |
| 24746 | Caramel Waffles 24746 | 11 11 | 390 | 420 | 2024-06-28 |
| 24747 | Chicken Ham & Cheese Panwich 24747 | 11 11 | 690 | 740 | 2024-06-28 |
| 24748 | Egg Mayo & Cheese Multigrain Croissant 24748 | 11 11 | 690 | 740 | 2024-06-28 |
| 24749 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 24749 | 11 11 | 690 | 740 | 2024-06-28 |
| 24750 | Rosemary Chicken & Emmental Cheese Croissant 24750 | 11 11 | 690 | 740 | 2024-06-28 |
| 24751 | Scrambled Egg & Turkey Ham Pita 24751 | 11 11 | 690 | 740 | 2024-06-28 |
| 24752 | Turkey Ham & Triple Cheese Toast 24752 | 11 11 | 690 | 740 | 2024-06-28 |
| 24753 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 24753 | 11 11 | 790 | 840 | 2024-06-28 |
| 24754 | Ham & Cheese Croissant 24754 | 11 11 | 690 | 740 | 2024-06-28 |
| 24755 | Sriracha Chicken Whole Wheat Pita 24755 | 11 11 | 750 | 800 | 2024-06-28 |
| 24756 | Blueberry Acai Yogurt Parfait 24756 | 11 11 | 650 | 700 | 2024-06-28 |
| 24757 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 24757 | 11 11 | 650 | 700 | 2024-06-28 |
| 24758 | Caramel Frappuccino® 24758 | 11 11 | 720 | 770 | 2024-06-28 |
| 24759 | Dark Mocha Frappuccino® 24759 | 11 11 | 780 | 830 | 2024-06-28 |
| 24760 | Java Chip Frappuccino® 24760 | 11 11 | 780 | 830 | 2024-06-28 |
| 24761 | Mocha Frappuccino® 24761 | 11 11 | 720 | 770 | 2024-06-28 |
| 24762 | Caramel Macchiato Frappuccino® 24762 | 11 11 | 780 | 830 | 2024-06-28 |
| 24763 | Espresso Frappuccino® 24763 | 11 11 | 720 | 770 | 2024-06-28 |
| 24764 | White Chocolate Mocha Frappuccino® 24764 | 11 11 | 720 | 770 | 2024-06-28 |
| 24765 | Chocolate Chip Cream Frappuccino® 24765 | 11 11 | 780 | 830 | 2024-06-28 |
| 24766 | Hojicha Tea Cream Frappuccino® 24766 | 11 11 | 760 | 810 | 2024-06-28 |
| 24767 | Vanilla Cream Frappuccino® 24767 | 11 11 | 720 | 770 | 2024-06-28 |
| 24768 | Mango Passion Fruit & Hibiscus 24768 | 11 11 | 720 | 770 | 2024-06-28 |
| 24769 | Raspberry Black Currant & Oolong 24769 | 11 11 | 720 | 770 | 2024-06-28 |
| 24770 | Coffee Traveller 24770 | 11 11 | 3120 | 3170 | 2024-06-28 |
| 24771 | Caffè Americano 24771 | 11 11 | 540 | 590 | 2024-06-28 |
| 24772 | Cappuccino 24772 | 11 11 | 680 | 730 | 2024-06-28 |
| 24773 | Caffè Mocha 24773 | 11 11 | 750 | 800 | 2024-06-28 |
| 24774 | Caramel Macchiato 24774 | 11 11 | 760 | 810 | 2024-06-28 |
| 24775 | Espresso 24775 | 11 11 | 390 | 440 | 2024-06-28 |
| 24776 | Caffè Latte 24776 | 11 11 | 680 | 730 | 2024-06-28 |
| 24777 | Oatmilk Latte 24777 | 11 11 | 760 | 810 | 2024-06-28 |
| 24778 | Vanilla Latte 24778 | 11 11 | 750 | 800 | 2024-06-28 |
| 24779 | White Chocolate Mocha 24779 | 11 11 | 750 | 800 | 2024-06-28 |
| 24780 | Flat White 24780 | 11 11 | 760 | 810 | 2024-06-28 |
| 24781 | Ristretto Bianco 24781 | 11 11 | 760 | 810 | 2024-06-28 |
| 24782 | Iced Caffè Americano 24782 | 11 11 | 540 | 590 | 2024-06-28 |
| 24783 | Iced Cappuccino 24783 | 11 11 | 680 | 730 | 2024-06-28 |
| 24784 | Iced Caffè Mocha 24784 | 11 11 | 750 | 800 | 2024-06-28 |
| 24785 | Iced Caramel Macchiato 24785 | 11 11 | 760 | 810 | 2024-06-28 |
| 24786 | Iced Caffè Latte 24786 | 11 11 | 680 | 730 | 2024-06-28 |
| 24787 | Iced Oatmilk Latte 24787 | 11 11 | 760 | 810 | 2024-06-28 |
| 24788 | Iced Vanilla Latte 24788 | 11 11 | 750 | 800 | 2024-06-28 |
| 24789 | Iced White Chocolate Mocha 24789 | 11 11 | 750 | 800 | 2024-06-28 |
| 24790 | Signature Hot Chocolate 24790 | 11 11 | 720 | 770 | 2024-06-28 |
| 24791 | Signature Iced Chocolate 24791 | 11 11 | 720 | 770 | 2024-06-28 |
| 24792 | Carrot Juice 24792 | 11 11 | 490 | 540 | 2024-06-28 |
| 24793 | Cloudy Apple Juice 24793 | 11 11 | 490 | 540 | 2024-06-28 |
| 24794 | Cranberry Red Grapefruit Juice 24794 | 11 11 | 490 | 540 | 2024-06-28 |
| 24795 | Orange Juice 24795 | 11 11 | 490 | 540 | 2024-06-28 |
| 24796 | Evian 24796 | 11 11 | 350 | 400 | 2024-06-28 |
| 24797 | Sparkling Water 24797 | 11 11 | 450 | 500 | 2024-06-28 |
| 24798 | Chai Tea 24798 | 11 11 | 500 | 550 | 2024-06-28 |
| 24799 | Earl Grey Tea 24799 | 11 11 | 500 | 550 | 2024-06-28 |
| 24800 | English Breakfast Tea 24800 | 11 11 | 500 | 550 | 2024-06-28 |
| 24801 | Emperor’s Clouds & Mist™ Tea 24801 | 11 11 | 500 | 550 | 2024-06-28 |
| 24802 | Mint Blend Tea 24802 | 11 11 | 500 | 550 | 2024-06-28 |
| 24803 | Chamomile Tea 24803 | 11 11 | 500 | 550 | 2024-06-28 |
| 24804 | Pure Matcha Latte 24804 | 11 11 | 740 | 790 | 2024-06-28 |
| 24805 | Chai Tea Latte 24805 | 11 11 | 680 | 730 | 2024-06-28 |
| 24806 | Earl Grey Tea Latte 24806 | 11 11 | 680 | 730 | 2024-06-28 |
| 24807 | English Breakfast Tea Latte 24807 | 11 11 | 680 | 730 | 2024-06-28 |
| 24808 | Hojicha Tea Latte 24808 | 11 11 | 740 | 790 | 2024-06-28 |
| 24809 | Zen Clouds Oolong Tea 24809 | 11 11 | 500 | 550 | 2024-06-28 |
| 24810 | Zen Clouds Oolong with Ruby Grapefruit and Honey 24810 | 11 11 | 630 | 680 | 2024-06-28 |
| 24811 | Youthberry™ Tea 24811 | 11 11 | 500 | 550 | 2024-06-28 |
| 24812 | Iced Shaken Black Tea Lemonade 24812 | 11 11 | 610 | 660 | 2024-06-28 |
| 24813 | Iced Shaken Strawberry Black Tea Lemonade 24813 | 11 11 | 630 | 680 | 2024-06-28 |
| 24814 | Iced Shaken Hibiscus Tea Lemonade 24814 | 11 11 | 610 | 660 | 2024-06-28 |
| 24815 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 24815 | 11 11 | 730 | 780 | 2024-06-28 |
| 24816 | Iced Pure Matcha Latte 24816 | 11 11 | 740 | 790 | 2024-06-28 |
| 24817 | Iced Chai Tea Latte 24817 | 11 11 | 680 | 730 | 2024-06-28 |
| 24818 | Iced Black Tea Latte 24818 | 11 11 | 680 | 730 | 2024-06-28 |
| 24819 | Iced Hojicha Tea Latte 24819 | 11 11 | 740 | 790 | 2024-06-28 |
| 24820 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 24820 | 11 11 | 630 | 680 | 2024-06-28 |
| 24821 | Iced Shaken Zen Clouds Oolong Lemonade 24821 | 11 11 | 610 | 660 | 2024-06-28 |
| 24822 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 24822 | 11 11 | 630 | 680 | 2024-06-28 |
| 24823 | Origami Pike Place® Roast 24823 | 11 11 | 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");