item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
343 rows where store_id = 24
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
- 24 · 343 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 22715 | Bagel 22715 | 24 24 | 430 | 460 | 2024-06-28 |
| 22716 | Cookie Crumble Cheesecake 22716 | 24 24 | 750 | 800 | 2024-06-28 |
| 22717 | Good Ol' NY Cheesecake 22717 | 24 24 | 750 | 800 | 2024-06-28 |
| 22718 | Signature Chocolate Cake 22718 | 24 24 | 750 | 800 | 2024-06-28 |
| 22719 | Starbucks® Coffee Tiramisu Cake 22719 | 24 24 | 780 | 830 | 2024-06-28 |
| 22720 | Strawberry Shortcake 22720 | 24 24 | 750 | 800 | 2024-06-28 |
| 22721 | Chocolate Chunk Monster Cookie 22721 | 24 24 | 420 | 470 | 2024-06-28 |
| 22722 | Banana Walnut Muffin 22722 | 24 24 | 480 | 530 | 2024-06-28 |
| 22723 | Blueberry Crumble Muffin 22723 | 24 24 | 480 | 530 | 2024-06-28 |
| 22724 | Chocolate Crumble Muffin 22724 | 24 24 | 480 | 530 | 2024-06-28 |
| 22725 | Pancakes 22725 | 24 24 | 580 | 630 | 2024-06-28 |
| 22726 | Almond Croissant 22726 | 24 24 | 500 | 550 | 2024-06-28 |
| 22727 | Buttery Croissant 22727 | 24 24 | 430 | 460 | 2024-06-28 |
| 22728 | Chocolate Croissant 22728 | 24 24 | 470 | 520 | 2024-06-28 |
| 22729 | Creamy Chicken Foldover 22729 | 24 24 | 580 | 630 | 2024-06-28 |
| 22730 | Sausage Roll 22730 | 24 24 | 580 | 630 | 2024-06-28 |
| 22731 | Buttery Scone 22731 | 24 24 | 430 | 460 | 2024-06-28 |
| 22732 | Country Chicken Pie 22732 | 24 24 | 720 | 770 | 2024-06-28 |
| 22733 | Deep Dish Beef Pie 22733 | 24 24 | 720 | 770 | 2024-06-28 |
| 22734 | Spinach & Mushroom Quiche 22734 | 24 24 | 720 | 770 | 2024-06-28 |
| 22735 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 22735 | 24 24 | 420 | 450 | 2024-06-28 |
| 22736 | Mixed Nuts 22736 | 24 24 | 520 | 570 | 2024-06-28 |
| 22737 | Caramel Waffles 22737 | 24 24 | 420 | 450 | 2024-06-28 |
| 22738 | Chicken Ham & Cheese Panwich 22738 | 24 24 | 720 | 770 | 2024-06-28 |
| 22739 | Egg Mayo & Cheese Multigrain Croissant 22739 | 24 24 | 720 | 770 | 2024-06-28 |
| 22740 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 22740 | 24 24 | 720 | 770 | 2024-06-28 |
| 22741 | Rosemary Chicken & Emmental Cheese Croissant 22741 | 24 24 | 720 | 770 | 2024-06-28 |
| 22742 | Scrambled Egg & Turkey Ham Pita 22742 | 24 24 | 720 | 770 | 2024-06-28 |
| 22743 | Turkey Ham & Triple Cheese Toast 22743 | 24 24 | 720 | 770 | 2024-06-28 |
| 22744 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 22744 | 24 24 | 820 | 870 | 2024-06-28 |
| 22745 | Ham & Cheese Croissant 22745 | 24 24 | 720 | 770 | 2024-06-28 |
| 22746 | Sriracha Chicken Whole Wheat Pita 22746 | 24 24 | 780 | 830 | 2024-06-28 |
| 22747 | Blueberry Acai Yogurt Parfait 22747 | 24 24 | 680 | 730 | 2024-06-28 |
| 22748 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 22748 | 24 24 | 680 | 730 | 2024-06-28 |
| 22749 | Caramel Frappuccino® 22749 | 24 24 | 780 | 830 | 2024-06-28 |
| 22750 | Dark Mocha Frappuccino® 22750 | 24 24 | 840 | 890 | 2024-06-28 |
| 22751 | Java Chip Frappuccino® 22751 | 24 24 | 840 | 890 | 2024-06-28 |
| 22752 | Mocha Frappuccino® 22752 | 24 24 | 780 | 830 | 2024-06-28 |
| 22753 | Caramel Macchiato Frappuccino® 22753 | 24 24 | 840 | 890 | 2024-06-28 |
| 22754 | Espresso Frappuccino® 22754 | 24 24 | 780 | 830 | 2024-06-28 |
| 22755 | White Chocolate Mocha Frappuccino® 22755 | 24 24 | 780 | 830 | 2024-06-28 |
| 22756 | Chocolate Chip Cream Frappuccino® 22756 | 24 24 | 840 | 890 | 2024-06-28 |
| 22757 | Hojicha Tea Cream Frappuccino® 22757 | 24 24 | 820 | 870 | 2024-06-28 |
| 22758 | Vanilla Cream Frappuccino® 22758 | 24 24 | 780 | 830 | 2024-06-28 |
| 22759 | Mango Passion Fruit & Hibiscus 22759 | 24 24 | 780 | 830 | 2024-06-28 |
| 22760 | Raspberry Black Currant & Oolong 22760 | 24 24 | 780 | 830 | 2024-06-28 |
| 22761 | Coffee Traveller 22761 | 24 24 | 3600 | 3650 | 2024-06-28 |
| 22762 | Caffè Americano 22762 | 24 24 | 600 | 650 | 2024-06-28 |
| 22763 | Cappuccino 22763 | 24 24 | 740 | 790 | 2024-06-28 |
| 22764 | Caffè Mocha 22764 | 24 24 | 830 | 880 | 2024-06-28 |
| 22765 | Caramel Macchiato 22765 | 24 24 | 840 | 890 | 2024-06-28 |
| 22766 | Espresso 22766 | 24 24 | 450 | 500 | 2024-06-28 |
| 22767 | Caffè Latte 22767 | 24 24 | 740 | 790 | 2024-06-28 |
| 22768 | Oatmilk Latte 22768 | 24 24 | 850 | 900 | 2024-06-28 |
| 22769 | Vanilla Latte 22769 | 24 24 | 830 | 880 | 2024-06-28 |
| 22770 | White Chocolate Mocha 22770 | 24 24 | 830 | 880 | 2024-06-28 |
| 22771 | Flat White 22771 | 24 24 | 840 | 890 | 2024-06-28 |
| 22772 | Ristretto Bianco 22772 | 24 24 | 840 | 890 | 2024-06-28 |
| 22773 | Iced Caffè Americano 22773 | 24 24 | 600 | 650 | 2024-06-28 |
| 22774 | Iced Cappuccino 22774 | 24 24 | 740 | 790 | 2024-06-28 |
| 22775 | Iced Caffè Mocha 22775 | 24 24 | 830 | 880 | 2024-06-28 |
| 22776 | Iced Caramel Macchiato 22776 | 24 24 | 840 | 890 | 2024-06-28 |
| 22777 | Iced Caffè Latte 22777 | 24 24 | 740 | 790 | 2024-06-28 |
| 22778 | Iced Oatmilk Latte 22778 | 24 24 | 850 | 900 | 2024-06-28 |
| 22779 | Iced Vanilla Latte 22779 | 24 24 | 830 | 880 | 2024-06-28 |
| 22780 | Iced White Chocolate Mocha 22780 | 24 24 | 830 | 880 | 2024-06-28 |
| 22781 | Signature Hot Chocolate 22781 | 24 24 | 780 | 830 | 2024-06-28 |
| 22782 | Signature Iced Chocolate 22782 | 24 24 | 780 | 830 | 2024-06-28 |
| 22783 | Carrot Juice 22783 | 24 24 | 550 | 600 | 2024-06-28 |
| 22784 | Cloudy Apple Juice 22784 | 24 24 | 550 | 600 | 2024-06-28 |
| 22785 | Cranberry Red Grapefruit Juice 22785 | 24 24 | 550 | 600 | 2024-06-28 |
| 22786 | Orange Juice 22786 | 24 24 | 550 | 600 | 2024-06-28 |
| 22787 | Evian 22787 | 24 24 | 410 | 460 | 2024-06-28 |
| 22788 | Sparkling Water 22788 | 24 24 | 510 | 560 | 2024-06-28 |
| 22789 | Chai Tea 22789 | 24 24 | 560 | 610 | 2024-06-28 |
| 22790 | Earl Grey Tea 22790 | 24 24 | 560 | 610 | 2024-06-28 |
| 22791 | English Breakfast Tea 22791 | 24 24 | 560 | 610 | 2024-06-28 |
| 22792 | Emperor’s Clouds & Mist™ Tea 22792 | 24 24 | 560 | 610 | 2024-06-28 |
| 22793 | Mint Blend Tea 22793 | 24 24 | 560 | 610 | 2024-06-28 |
| 22794 | Chamomile Tea 22794 | 24 24 | 560 | 610 | 2024-06-28 |
| 22795 | Pure Matcha Latte 22795 | 24 24 | 810 | 860 | 2024-06-28 |
| 22796 | Chai Tea Latte 22796 | 24 24 | 740 | 790 | 2024-06-28 |
| 22797 | Earl Grey Tea Latte 22797 | 24 24 | 740 | 790 | 2024-06-28 |
| 22798 | English Breakfast Tea Latte 22798 | 24 24 | 740 | 790 | 2024-06-28 |
| 22799 | Hojicha Tea Latte 22799 | 24 24 | 810 | 860 | 2024-06-28 |
| 22800 | Zen Clouds Oolong Tea 22800 | 24 24 | 560 | 610 | 2024-06-28 |
| 22801 | Zen Clouds Oolong with Ruby Grapefruit and Honey 22801 | 24 24 | 690 | 740 | 2024-06-28 |
| 22802 | Youthberry™ Tea 22802 | 24 24 | 560 | 610 | 2024-06-28 |
| 22803 | Iced Shaken Black Tea Lemonade 22803 | 24 24 | 670 | 720 | 2024-06-28 |
| 22804 | Iced Shaken Strawberry Black Tea Lemonade 22804 | 24 24 | 690 | 740 | 2024-06-28 |
| 22805 | Iced Shaken Hibiscus Tea Lemonade 22805 | 24 24 | 670 | 720 | 2024-06-28 |
| 22806 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 22806 | 24 24 | 790 | 840 | 2024-06-28 |
| 22807 | Iced Pure Matcha Latte 22807 | 24 24 | 810 | 860 | 2024-06-28 |
| 22808 | Iced Chai Tea Latte 22808 | 24 24 | 740 | 790 | 2024-06-28 |
| 22809 | Iced Black Tea Latte 22809 | 24 24 | 740 | 790 | 2024-06-28 |
| 22810 | Iced Hojicha Tea Latte 22810 | 24 24 | 810 | 860 | 2024-06-28 |
| 22811 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 22811 | 24 24 | 690 | 740 | 2024-06-28 |
| 22812 | Iced Shaken Zen Clouds Oolong Lemonade 22812 | 24 24 | 670 | 720 | 2024-06-28 |
| 22813 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 22813 | 24 24 | 690 | 740 | 2024-06-28 |
| 22814 | Origami Pike Place® Roast 22814 | 24 24 | 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");