item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 40
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 11
- 2024-06-28 182
- 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
- 40 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 19793 | Bagel 19793 | 40 40 | 400 | 430 | 2024-06-28 |
| 19794 | Cookie Crumble Cheesecake 19794 | 40 40 | 720 | 770 | 2024-06-28 |
| 19795 | Good Ol' NY Cheesecake 19795 | 40 40 | 720 | 770 | 2024-06-28 |
| 19796 | Signature Chocolate Cake 19796 | 40 40 | 720 | 770 | 2024-06-28 |
| 19797 | Starbucks® Coffee Tiramisu Cake 19797 | 40 40 | 750 | 800 | 2024-06-28 |
| 19798 | Strawberry Shortcake 19798 | 40 40 | 720 | 770 | 2024-06-28 |
| 19799 | Chocolate Chunk Monster Cookie 19799 | 40 40 | 390 | 440 | 2024-06-28 |
| 19800 | Banana Walnut Muffin 19800 | 40 40 | 450 | 500 | 2024-06-28 |
| 19801 | Blueberry Crumble Muffin 19801 | 40 40 | 450 | 500 | 2024-06-28 |
| 19802 | Chocolate Crumble Muffin 19802 | 40 40 | 450 | 500 | 2024-06-28 |
| 19803 | Pancakes 19803 | 40 40 | 550 | 600 | 2024-06-28 |
| 19804 | Almond Croissant 19804 | 40 40 | 470 | 520 | 2024-06-28 |
| 19805 | Buttery Croissant 19805 | 40 40 | 400 | 430 | 2024-06-28 |
| 19806 | Chocolate Croissant 19806 | 40 40 | 440 | 490 | 2024-06-28 |
| 19807 | Creamy Chicken Foldover 19807 | 40 40 | 550 | 600 | 2024-06-28 |
| 19808 | Sausage Roll 19808 | 40 40 | 550 | 600 | 2024-06-28 |
| 19809 | Buttery Scone 19809 | 40 40 | 400 | 430 | 2024-06-28 |
| 19810 | Country Chicken Pie 19810 | 40 40 | 690 | 740 | 2024-06-28 |
| 19811 | Deep Dish Beef Pie 19811 | 40 40 | 690 | 740 | 2024-06-28 |
| 19812 | Spinach & Mushroom Quiche 19812 | 40 40 | 690 | 740 | 2024-06-28 |
| 19813 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 19813 | 40 40 | 390 | 420 | 2024-06-28 |
| 19814 | Mixed Nuts 19814 | 40 40 | 490 | 540 | 2024-06-28 |
| 19815 | Caramel Waffles 19815 | 40 40 | 390 | 420 | 2024-06-28 |
| 19816 | Chicken Ham & Cheese Panwich 19816 | 40 40 | 690 | 740 | 2024-06-28 |
| 19817 | Egg Mayo & Cheese Multigrain Croissant 19817 | 40 40 | 690 | 740 | 2024-06-28 |
| 19818 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 19818 | 40 40 | 690 | 740 | 2024-06-28 |
| 19819 | Rosemary Chicken & Emmental Cheese Croissant 19819 | 40 40 | 690 | 740 | 2024-06-28 |
| 19820 | Scrambled Egg & Turkey Ham Pita 19820 | 40 40 | 690 | 740 | 2024-06-28 |
| 19821 | Turkey Ham & Triple Cheese Toast 19821 | 40 40 | 690 | 740 | 2024-06-28 |
| 19822 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 19822 | 40 40 | 790 | 840 | 2024-06-28 |
| 19823 | Ham & Cheese Croissant 19823 | 40 40 | 690 | 740 | 2024-06-28 |
| 19824 | Sriracha Chicken Whole Wheat Pita 19824 | 40 40 | 750 | 800 | 2024-06-28 |
| 19825 | Blueberry Acai Yogurt Parfait 19825 | 40 40 | 650 | 700 | 2024-06-28 |
| 19826 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 19826 | 40 40 | 650 | 700 | 2024-06-28 |
| 19827 | Caramel Frappuccino® 19827 | 40 40 | 720 | 770 | 2024-06-28 |
| 19828 | Dark Mocha Frappuccino® 19828 | 40 40 | 780 | 830 | 2024-06-28 |
| 19829 | Java Chip Frappuccino® 19829 | 40 40 | 780 | 830 | 2024-06-28 |
| 19830 | Mocha Frappuccino® 19830 | 40 40 | 720 | 770 | 2024-06-28 |
| 19831 | Caramel Macchiato Frappuccino® 19831 | 40 40 | 780 | 830 | 2024-06-28 |
| 19832 | Espresso Frappuccino® 19832 | 40 40 | 720 | 770 | 2024-06-28 |
| 19833 | White Chocolate Mocha Frappuccino® 19833 | 40 40 | 720 | 770 | 2024-06-28 |
| 19834 | Chocolate Chip Cream Frappuccino® 19834 | 40 40 | 780 | 830 | 2024-06-28 |
| 19835 | Hojicha Tea Cream Frappuccino® 19835 | 40 40 | 760 | 810 | 2024-06-28 |
| 19836 | Vanilla Cream Frappuccino® 19836 | 40 40 | 720 | 770 | 2024-06-28 |
| 19837 | Mango Passion Fruit & Hibiscus 19837 | 40 40 | 720 | 770 | 2024-06-28 |
| 19838 | Raspberry Black Currant & Oolong 19838 | 40 40 | 720 | 770 | 2024-06-28 |
| 19839 | Coffee Traveller 19839 | 40 40 | 3120 | 3170 | 2024-06-28 |
| 19840 | Caffè Americano 19840 | 40 40 | 540 | 590 | 2024-06-28 |
| 19841 | Cappuccino 19841 | 40 40 | 680 | 730 | 2024-06-28 |
| 19842 | Caffè Mocha 19842 | 40 40 | 750 | 800 | 2024-06-28 |
| 19843 | Caramel Macchiato 19843 | 40 40 | 760 | 810 | 2024-06-28 |
| 19844 | Espresso 19844 | 40 40 | 390 | 440 | 2024-06-28 |
| 19845 | Caffè Latte 19845 | 40 40 | 680 | 730 | 2024-06-28 |
| 19846 | Oatmilk Latte 19846 | 40 40 | 760 | 810 | 2024-06-28 |
| 19847 | Vanilla Latte 19847 | 40 40 | 750 | 800 | 2024-06-28 |
| 19848 | White Chocolate Mocha 19848 | 40 40 | 750 | 800 | 2024-06-28 |
| 19849 | Flat White 19849 | 40 40 | 760 | 810 | 2024-06-28 |
| 19850 | Ristretto Bianco 19850 | 40 40 | 760 | 810 | 2024-06-28 |
| 19851 | Iced Caffè Americano 19851 | 40 40 | 540 | 590 | 2024-06-28 |
| 19852 | Iced Cappuccino 19852 | 40 40 | 680 | 730 | 2024-06-28 |
| 19853 | Iced Caffè Mocha 19853 | 40 40 | 750 | 800 | 2024-06-28 |
| 19854 | Iced Caramel Macchiato 19854 | 40 40 | 760 | 810 | 2024-06-28 |
| 19855 | Iced Caffè Latte 19855 | 40 40 | 680 | 730 | 2024-06-28 |
| 19856 | Iced Oatmilk Latte 19856 | 40 40 | 760 | 810 | 2024-06-28 |
| 19857 | Iced Vanilla Latte 19857 | 40 40 | 750 | 800 | 2024-06-28 |
| 19858 | Iced White Chocolate Mocha 19858 | 40 40 | 750 | 800 | 2024-06-28 |
| 19859 | Signature Hot Chocolate 19859 | 40 40 | 720 | 770 | 2024-06-28 |
| 19860 | Signature Iced Chocolate 19860 | 40 40 | 720 | 770 | 2024-06-28 |
| 19861 | Carrot Juice 19861 | 40 40 | 490 | 540 | 2024-06-28 |
| 19862 | Cloudy Apple Juice 19862 | 40 40 | 490 | 540 | 2024-06-28 |
| 19863 | Cranberry Red Grapefruit Juice 19863 | 40 40 | 490 | 540 | 2024-06-28 |
| 19864 | Orange Juice 19864 | 40 40 | 490 | 540 | 2024-06-28 |
| 19865 | Evian 19865 | 40 40 | 350 | 400 | 2024-06-28 |
| 19866 | Sparkling Water 19866 | 40 40 | 450 | 500 | 2024-06-28 |
| 19867 | Chai Tea 19867 | 40 40 | 500 | 550 | 2024-06-28 |
| 19868 | Earl Grey Tea 19868 | 40 40 | 500 | 550 | 2024-06-28 |
| 19869 | English Breakfast Tea 19869 | 40 40 | 500 | 550 | 2024-06-28 |
| 19870 | Emperor’s Clouds & Mist™ Tea 19870 | 40 40 | 500 | 550 | 2024-06-28 |
| 19871 | Mint Blend Tea 19871 | 40 40 | 500 | 550 | 2024-06-28 |
| 19872 | Chamomile Tea 19872 | 40 40 | 500 | 550 | 2024-06-28 |
| 19873 | Pure Matcha Latte 19873 | 40 40 | 740 | 790 | 2024-06-28 |
| 19874 | Chai Tea Latte 19874 | 40 40 | 680 | 730 | 2024-06-28 |
| 19875 | Earl Grey Tea Latte 19875 | 40 40 | 680 | 730 | 2024-06-28 |
| 19876 | English Breakfast Tea Latte 19876 | 40 40 | 680 | 730 | 2024-06-28 |
| 19877 | Hojicha Tea Latte 19877 | 40 40 | 740 | 790 | 2024-06-28 |
| 19878 | Zen Clouds Oolong Tea 19878 | 40 40 | 500 | 550 | 2024-06-28 |
| 19879 | Zen Clouds Oolong with Ruby Grapefruit and Honey 19879 | 40 40 | 630 | 680 | 2024-06-28 |
| 19880 | Youthberry™ Tea 19880 | 40 40 | 500 | 550 | 2024-06-28 |
| 19881 | Iced Shaken Black Tea Lemonade 19881 | 40 40 | 610 | 660 | 2024-06-28 |
| 19882 | Iced Shaken Strawberry Black Tea Lemonade 19882 | 40 40 | 630 | 680 | 2024-06-28 |
| 19883 | Iced Shaken Hibiscus Tea Lemonade 19883 | 40 40 | 610 | 660 | 2024-06-28 |
| 19884 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 19884 | 40 40 | 730 | 780 | 2024-06-28 |
| 19885 | Iced Pure Matcha Latte 19885 | 40 40 | 740 | 790 | 2024-06-28 |
| 19886 | Iced Chai Tea Latte 19886 | 40 40 | 680 | 730 | 2024-06-28 |
| 19887 | Iced Black Tea Latte 19887 | 40 40 | 680 | 730 | 2024-06-28 |
| 19888 | Iced Hojicha Tea Latte 19888 | 40 40 | 740 | 790 | 2024-06-28 |
| 19889 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 19889 | 40 40 | 630 | 680 | 2024-06-28 |
| 19890 | Iced Shaken Zen Clouds Oolong Lemonade 19890 | 40 40 | 610 | 660 | 2024-06-28 |
| 19891 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 19891 | 40 40 | 630 | 680 | 2024-06-28 |
| 19892 | Origami Pike Place® Roast 19892 | 40 40 | 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");