item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
248 rows where store_id = 54
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 12
- 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
store_id 1
- 54 · 248 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 17787 | Bagel 17787 | 54 54 | 400 | 430 | 2024-06-28 |
| 17788 | Cookie Crumble Cheesecake 17788 | 54 54 | 720 | 770 | 2024-06-28 |
| 17789 | Good Ol' NY Cheesecake 17789 | 54 54 | 720 | 770 | 2024-06-28 |
| 17790 | Signature Chocolate Cake 17790 | 54 54 | 720 | 770 | 2024-06-28 |
| 17791 | Starbucks® Coffee Tiramisu Cake 17791 | 54 54 | 750 | 800 | 2024-06-28 |
| 17792 | Strawberry Shortcake 17792 | 54 54 | 720 | 770 | 2024-06-28 |
| 17793 | Chocolate Chunk Monster Cookie 17793 | 54 54 | 390 | 440 | 2024-06-28 |
| 17794 | Banana Walnut Muffin 17794 | 54 54 | 450 | 500 | 2024-06-28 |
| 17795 | Blueberry Crumble Muffin 17795 | 54 54 | 450 | 500 | 2024-06-28 |
| 17796 | Chocolate Crumble Muffin 17796 | 54 54 | 450 | 500 | 2024-06-28 |
| 17797 | Pancakes 17797 | 54 54 | 550 | 600 | 2024-06-28 |
| 17798 | Almond Croissant 17798 | 54 54 | 470 | 520 | 2024-06-28 |
| 17799 | Buttery Croissant 17799 | 54 54 | 400 | 430 | 2024-06-28 |
| 17800 | Chocolate Croissant 17800 | 54 54 | 440 | 490 | 2024-06-28 |
| 17801 | Creamy Chicken Foldover 17801 | 54 54 | 550 | 600 | 2024-06-28 |
| 17802 | Sausage Roll 17802 | 54 54 | 550 | 600 | 2024-06-28 |
| 17803 | Buttery Scone 17803 | 54 54 | 400 | 430 | 2024-06-28 |
| 17804 | Country Chicken Pie 17804 | 54 54 | 690 | 740 | 2024-06-28 |
| 17805 | Deep Dish Beef Pie 17805 | 54 54 | 690 | 740 | 2024-06-28 |
| 17806 | Spinach & Mushroom Quiche 17806 | 54 54 | 690 | 740 | 2024-06-28 |
| 17807 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 17807 | 54 54 | 390 | 420 | 2024-06-28 |
| 17808 | Mixed Nuts 17808 | 54 54 | 490 | 540 | 2024-06-28 |
| 17809 | Caramel Waffles 17809 | 54 54 | 390 | 420 | 2024-06-28 |
| 17810 | Chicken Ham & Cheese Panwich 17810 | 54 54 | 690 | 740 | 2024-06-28 |
| 17811 | Egg Mayo & Cheese Multigrain Croissant 17811 | 54 54 | 690 | 740 | 2024-06-28 |
| 17812 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 17812 | 54 54 | 690 | 740 | 2024-06-28 |
| 17813 | Rosemary Chicken & Emmental Cheese Croissant 17813 | 54 54 | 690 | 740 | 2024-06-28 |
| 17814 | Scrambled Egg & Turkey Ham Pita 17814 | 54 54 | 690 | 740 | 2024-06-28 |
| 17815 | Turkey Ham & Triple Cheese Toast 17815 | 54 54 | 690 | 740 | 2024-06-28 |
| 17816 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 17816 | 54 54 | 790 | 840 | 2024-06-28 |
| 17817 | Ham & Cheese Croissant 17817 | 54 54 | 690 | 740 | 2024-06-28 |
| 17818 | Sriracha Chicken Whole Wheat Pita 17818 | 54 54 | 750 | 800 | 2024-06-28 |
| 17819 | Blueberry Acai Yogurt Parfait 17819 | 54 54 | 650 | 700 | 2024-06-28 |
| 17820 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 17820 | 54 54 | 650 | 700 | 2024-06-28 |
| 17821 | Caramel Frappuccino® 17821 | 54 54 | 720 | 770 | 2024-06-28 |
| 17822 | Dark Mocha Frappuccino® 17822 | 54 54 | 780 | 830 | 2024-06-28 |
| 17823 | Java Chip Frappuccino® 17823 | 54 54 | 780 | 830 | 2024-06-28 |
| 17824 | Mocha Frappuccino® 17824 | 54 54 | 720 | 770 | 2024-06-28 |
| 17825 | Caramel Macchiato Frappuccino® 17825 | 54 54 | 780 | 830 | 2024-06-28 |
| 17826 | Espresso Frappuccino® 17826 | 54 54 | 720 | 770 | 2024-06-28 |
| 17827 | White Chocolate Mocha Frappuccino® 17827 | 54 54 | 720 | 770 | 2024-06-28 |
| 17828 | Chocolate Chip Cream Frappuccino® 17828 | 54 54 | 780 | 830 | 2024-06-28 |
| 17829 | Hojicha Tea Cream Frappuccino® 17829 | 54 54 | 760 | 810 | 2024-06-28 |
| 17830 | Vanilla Cream Frappuccino® 17830 | 54 54 | 720 | 770 | 2024-06-28 |
| 17831 | Mango Passion Fruit & Hibiscus 17831 | 54 54 | 720 | 770 | 2024-06-28 |
| 17832 | Raspberry Black Currant & Oolong 17832 | 54 54 | 720 | 770 | 2024-06-28 |
| 17833 | Coffee Traveller 17833 | 54 54 | 3120 | 3170 | 2024-06-28 |
| 17834 | Caffè Americano 17834 | 54 54 | 540 | 590 | 2024-06-28 |
| 17835 | Cappuccino 17835 | 54 54 | 680 | 730 | 2024-06-28 |
| 17836 | Caffè Mocha 17836 | 54 54 | 750 | 800 | 2024-06-28 |
| 17837 | Caramel Macchiato 17837 | 54 54 | 760 | 810 | 2024-06-28 |
| 17838 | Espresso 17838 | 54 54 | 390 | 440 | 2024-06-28 |
| 17839 | Caffè Latte 17839 | 54 54 | 680 | 730 | 2024-06-28 |
| 17840 | Oatmilk Latte 17840 | 54 54 | 760 | 810 | 2024-06-28 |
| 17841 | Vanilla Latte 17841 | 54 54 | 750 | 800 | 2024-06-28 |
| 17842 | White Chocolate Mocha 17842 | 54 54 | 750 | 800 | 2024-06-28 |
| 17843 | Flat White 17843 | 54 54 | 760 | 810 | 2024-06-28 |
| 17844 | Ristretto Bianco 17844 | 54 54 | 760 | 810 | 2024-06-28 |
| 17845 | Iced Caffè Americano 17845 | 54 54 | 540 | 590 | 2024-06-28 |
| 17846 | Iced Cappuccino 17846 | 54 54 | 680 | 730 | 2024-06-28 |
| 17847 | Iced Caffè Mocha 17847 | 54 54 | 750 | 800 | 2024-06-28 |
| 17848 | Iced Caramel Macchiato 17848 | 54 54 | 760 | 810 | 2024-06-28 |
| 17849 | Iced Caffè Latte 17849 | 54 54 | 680 | 730 | 2024-06-28 |
| 17850 | Iced Oatmilk Latte 17850 | 54 54 | 760 | 810 | 2024-06-28 |
| 17851 | Iced Vanilla Latte 17851 | 54 54 | 750 | 800 | 2024-06-28 |
| 17852 | Iced White Chocolate Mocha 17852 | 54 54 | 750 | 800 | 2024-06-28 |
| 17853 | Signature Hot Chocolate 17853 | 54 54 | 720 | 770 | 2024-06-28 |
| 17854 | Signature Iced Chocolate 17854 | 54 54 | 720 | 770 | 2024-06-28 |
| 17855 | Carrot Juice 17855 | 54 54 | 490 | 540 | 2024-06-28 |
| 17856 | Cloudy Apple Juice 17856 | 54 54 | 490 | 540 | 2024-06-28 |
| 17857 | Cranberry Red Grapefruit Juice 17857 | 54 54 | 490 | 540 | 2024-06-28 |
| 17858 | Orange Juice 17858 | 54 54 | 490 | 540 | 2024-06-28 |
| 17859 | Evian 17859 | 54 54 | 350 | 400 | 2024-06-28 |
| 17860 | Sparkling Water 17860 | 54 54 | 450 | 500 | 2024-06-28 |
| 17861 | Chai Tea 17861 | 54 54 | 500 | 550 | 2024-06-28 |
| 17862 | Earl Grey Tea 17862 | 54 54 | 500 | 550 | 2024-06-28 |
| 17863 | English Breakfast Tea 17863 | 54 54 | 500 | 550 | 2024-06-28 |
| 17864 | Emperor’s Clouds & Mist™ Tea 17864 | 54 54 | 500 | 550 | 2024-06-28 |
| 17865 | Mint Blend Tea 17865 | 54 54 | 500 | 550 | 2024-06-28 |
| 17866 | Chamomile Tea 17866 | 54 54 | 500 | 550 | 2024-06-28 |
| 17867 | Pure Matcha Latte 17867 | 54 54 | 740 | 790 | 2024-06-28 |
| 17868 | Chai Tea Latte 17868 | 54 54 | 680 | 730 | 2024-06-28 |
| 17869 | Earl Grey Tea Latte 17869 | 54 54 | 680 | 730 | 2024-06-28 |
| 17870 | English Breakfast Tea Latte 17870 | 54 54 | 680 | 730 | 2024-06-28 |
| 17871 | Hojicha Tea Latte 17871 | 54 54 | 740 | 790 | 2024-06-28 |
| 17872 | Zen Clouds Oolong Tea 17872 | 54 54 | 500 | 550 | 2024-06-28 |
| 17873 | Zen Clouds Oolong with Ruby Grapefruit and Honey 17873 | 54 54 | 630 | 680 | 2024-06-28 |
| 17874 | Youthberry™ Tea 17874 | 54 54 | 500 | 550 | 2024-06-28 |
| 17875 | Iced Shaken Black Tea Lemonade 17875 | 54 54 | 610 | 660 | 2024-06-28 |
| 17876 | Iced Shaken Strawberry Black Tea Lemonade 17876 | 54 54 | 630 | 680 | 2024-06-28 |
| 17877 | Iced Shaken Hibiscus Tea Lemonade 17877 | 54 54 | 610 | 660 | 2024-06-28 |
| 17878 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 17878 | 54 54 | 730 | 780 | 2024-06-28 |
| 17879 | Iced Pure Matcha Latte 17879 | 54 54 | 740 | 790 | 2024-06-28 |
| 17880 | Iced Chai Tea Latte 17880 | 54 54 | 680 | 730 | 2024-06-28 |
| 17881 | Iced Black Tea Latte 17881 | 54 54 | 680 | 730 | 2024-06-28 |
| 17882 | Iced Hojicha Tea Latte 17882 | 54 54 | 740 | 790 | 2024-06-28 |
| 17883 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 17883 | 54 54 | 630 | 680 | 2024-06-28 |
| 17884 | Iced Shaken Zen Clouds Oolong Lemonade 17884 | 54 54 | 610 | 660 | 2024-06-28 |
| 17885 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 17885 | 54 54 | 630 | 680 | 2024-06-28 |
| 17886 | Origami Pike Place® Roast 17886 | 54 54 | 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");