item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
249 rows where store_id = 134
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
- 134 · 249 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 4794 | Bagel 4794 | 134 134 | 400 | 430 | 2024-06-28 |
| 4795 | Cookie Crumble Cheesecake 4795 | 134 134 | 720 | 770 | 2024-06-28 |
| 4796 | Good Ol' NY Cheesecake 4796 | 134 134 | 720 | 770 | 2024-06-28 |
| 4797 | Signature Chocolate Cake 4797 | 134 134 | 720 | 770 | 2024-06-28 |
| 4798 | Starbucks® Coffee Tiramisu Cake 4798 | 134 134 | 750 | 800 | 2024-06-28 |
| 4799 | Strawberry Shortcake 4799 | 134 134 | 720 | 770 | 2024-06-28 |
| 4800 | Chocolate Chunk Monster Cookie 4800 | 134 134 | 390 | 440 | 2024-06-28 |
| 4801 | Banana Walnut Muffin 4801 | 134 134 | 450 | 500 | 2024-06-28 |
| 4802 | Blueberry Crumble Muffin 4802 | 134 134 | 450 | 500 | 2024-06-28 |
| 4803 | Chocolate Crumble Muffin 4803 | 134 134 | 450 | 500 | 2024-06-28 |
| 4804 | Pancakes 4804 | 134 134 | 550 | 600 | 2024-06-28 |
| 4805 | Almond Croissant 4805 | 134 134 | 470 | 520 | 2024-06-28 |
| 4806 | Buttery Croissant 4806 | 134 134 | 400 | 430 | 2024-06-28 |
| 4807 | Chocolate Croissant 4807 | 134 134 | 440 | 490 | 2024-06-28 |
| 4808 | Creamy Chicken Foldover 4808 | 134 134 | 550 | 600 | 2024-06-28 |
| 4809 | Sausage Roll 4809 | 134 134 | 550 | 600 | 2024-06-28 |
| 4810 | Buttery Scone 4810 | 134 134 | 400 | 430 | 2024-06-28 |
| 4811 | Country Chicken Pie 4811 | 134 134 | 690 | 740 | 2024-06-28 |
| 4812 | Deep Dish Beef Pie 4812 | 134 134 | 690 | 740 | 2024-06-28 |
| 4813 | Spinach & Mushroom Quiche 4813 | 134 134 | 690 | 740 | 2024-06-28 |
| 4814 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 4814 | 134 134 | 390 | 420 | 2024-06-28 |
| 4815 | Mixed Nuts 4815 | 134 134 | 490 | 540 | 2024-06-28 |
| 4816 | Caramel Waffles 4816 | 134 134 | 390 | 420 | 2024-06-28 |
| 4817 | Chicken Ham & Cheese Panwich 4817 | 134 134 | 690 | 740 | 2024-06-28 |
| 4818 | Egg Mayo & Cheese Multigrain Croissant 4818 | 134 134 | 690 | 740 | 2024-06-28 |
| 4819 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 4819 | 134 134 | 690 | 740 | 2024-06-28 |
| 4820 | Rosemary Chicken & Emmental Cheese Croissant 4820 | 134 134 | 690 | 740 | 2024-06-28 |
| 4821 | Scrambled Egg & Turkey Ham Pita 4821 | 134 134 | 690 | 740 | 2024-06-28 |
| 4822 | Turkey Ham & Triple Cheese Toast 4822 | 134 134 | 690 | 740 | 2024-06-28 |
| 4823 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 4823 | 134 134 | 790 | 840 | 2024-06-28 |
| 4824 | Ham & Cheese Croissant 4824 | 134 134 | 690 | 740 | 2024-06-28 |
| 4825 | Sriracha Chicken Whole Wheat Pita 4825 | 134 134 | 750 | 800 | 2024-06-28 |
| 4826 | Blueberry Acai Yogurt Parfait 4826 | 134 134 | 650 | 700 | 2024-06-28 |
| 4827 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 4827 | 134 134 | 650 | 700 | 2024-06-28 |
| 4828 | Caramel Frappuccino® 4828 | 134 134 | 720 | 770 | 2024-06-28 |
| 4829 | Dark Mocha Frappuccino® 4829 | 134 134 | 780 | 830 | 2024-06-28 |
| 4830 | Java Chip Frappuccino® 4830 | 134 134 | 780 | 830 | 2024-06-28 |
| 4831 | Mocha Frappuccino® 4831 | 134 134 | 720 | 770 | 2024-06-28 |
| 4832 | Caramel Macchiato Frappuccino® 4832 | 134 134 | 780 | 830 | 2024-06-28 |
| 4833 | Espresso Frappuccino® 4833 | 134 134 | 720 | 770 | 2024-06-28 |
| 4834 | White Chocolate Mocha Frappuccino® 4834 | 134 134 | 720 | 770 | 2024-06-28 |
| 4835 | Chocolate Chip Cream Frappuccino® 4835 | 134 134 | 780 | 830 | 2024-06-28 |
| 4836 | Hojicha Tea Cream Frappuccino® 4836 | 134 134 | 760 | 810 | 2024-06-28 |
| 4837 | Vanilla Cream Frappuccino® 4837 | 134 134 | 720 | 770 | 2024-06-28 |
| 4838 | Mango Passion Fruit & Hibiscus 4838 | 134 134 | 720 | 770 | 2024-06-28 |
| 4839 | Raspberry Black Currant & Oolong 4839 | 134 134 | 720 | 770 | 2024-06-28 |
| 4840 | Coffee Traveller 4840 | 134 134 | 3120 | 3170 | 2024-06-28 |
| 4841 | Caffè Americano 4841 | 134 134 | 540 | 590 | 2024-06-28 |
| 4842 | Cappuccino 4842 | 134 134 | 680 | 730 | 2024-06-28 |
| 4843 | Caffè Mocha 4843 | 134 134 | 750 | 800 | 2024-06-28 |
| 4844 | Caramel Macchiato 4844 | 134 134 | 760 | 810 | 2024-06-28 |
| 4845 | Espresso 4845 | 134 134 | 390 | 440 | 2024-06-28 |
| 4846 | Caffè Latte 4846 | 134 134 | 680 | 730 | 2024-06-28 |
| 4847 | Oatmilk Latte 4847 | 134 134 | 760 | 810 | 2024-06-28 |
| 4848 | Vanilla Latte 4848 | 134 134 | 750 | 800 | 2024-06-28 |
| 4849 | White Chocolate Mocha 4849 | 134 134 | 750 | 800 | 2024-06-28 |
| 4850 | Flat White 4850 | 134 134 | 760 | 810 | 2024-06-28 |
| 4851 | Ristretto Bianco 4851 | 134 134 | 760 | 810 | 2024-06-28 |
| 4852 | Iced Caffè Americano 4852 | 134 134 | 540 | 590 | 2024-06-28 |
| 4853 | Iced Cappuccino 4853 | 134 134 | 680 | 730 | 2024-06-28 |
| 4854 | Iced Caffè Mocha 4854 | 134 134 | 750 | 800 | 2024-06-28 |
| 4855 | Iced Caramel Macchiato 4855 | 134 134 | 760 | 810 | 2024-06-28 |
| 4856 | Iced Caffè Latte 4856 | 134 134 | 680 | 730 | 2024-06-28 |
| 4857 | Iced Oatmilk Latte 4857 | 134 134 | 760 | 810 | 2024-06-28 |
| 4858 | Iced Vanilla Latte 4858 | 134 134 | 750 | 800 | 2024-06-28 |
| 4859 | Iced White Chocolate Mocha 4859 | 134 134 | 750 | 800 | 2024-06-28 |
| 4860 | Signature Hot Chocolate 4860 | 134 134 | 720 | 770 | 2024-06-28 |
| 4861 | Signature Iced Chocolate 4861 | 134 134 | 720 | 770 | 2024-06-28 |
| 4862 | Carrot Juice 4862 | 134 134 | 490 | 540 | 2024-06-28 |
| 4863 | Cloudy Apple Juice 4863 | 134 134 | 490 | 540 | 2024-06-28 |
| 4864 | Cranberry Red Grapefruit Juice 4864 | 134 134 | 490 | 540 | 2024-06-28 |
| 4865 | Orange Juice 4865 | 134 134 | 490 | 540 | 2024-06-28 |
| 4866 | Evian 4866 | 134 134 | 350 | 400 | 2024-06-28 |
| 4867 | Sparkling Water 4867 | 134 134 | 450 | 500 | 2024-06-28 |
| 4868 | Chai Tea 4868 | 134 134 | 500 | 550 | 2024-06-28 |
| 4869 | Earl Grey Tea 4869 | 134 134 | 500 | 550 | 2024-06-28 |
| 4870 | English Breakfast Tea 4870 | 134 134 | 500 | 550 | 2024-06-28 |
| 4871 | Emperor’s Clouds & Mist™ Tea 4871 | 134 134 | 500 | 550 | 2024-06-28 |
| 4872 | Mint Blend Tea 4872 | 134 134 | 500 | 550 | 2024-06-28 |
| 4873 | Chamomile Tea 4873 | 134 134 | 500 | 550 | 2024-06-28 |
| 4874 | Pure Matcha Latte 4874 | 134 134 | 740 | 790 | 2024-06-28 |
| 4875 | Chai Tea Latte 4875 | 134 134 | 680 | 730 | 2024-06-28 |
| 4876 | Earl Grey Tea Latte 4876 | 134 134 | 680 | 730 | 2024-06-28 |
| 4877 | English Breakfast Tea Latte 4877 | 134 134 | 680 | 730 | 2024-06-28 |
| 4878 | Hojicha Tea Latte 4878 | 134 134 | 740 | 790 | 2024-06-28 |
| 4879 | Zen Clouds Oolong Tea 4879 | 134 134 | 500 | 550 | 2024-06-28 |
| 4880 | Zen Clouds Oolong with Ruby Grapefruit and Honey 4880 | 134 134 | 630 | 680 | 2024-06-28 |
| 4881 | Youthberry™ Tea 4881 | 134 134 | 500 | 550 | 2024-06-28 |
| 4882 | Iced Shaken Black Tea Lemonade 4882 | 134 134 | 610 | 660 | 2024-06-28 |
| 4883 | Iced Shaken Strawberry Black Tea Lemonade 4883 | 134 134 | 630 | 680 | 2024-06-28 |
| 4884 | Iced Shaken Hibiscus Tea Lemonade 4884 | 134 134 | 610 | 660 | 2024-06-28 |
| 4885 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 4885 | 134 134 | 730 | 780 | 2024-06-28 |
| 4886 | Iced Pure Matcha Latte 4886 | 134 134 | 740 | 790 | 2024-06-28 |
| 4887 | Iced Chai Tea Latte 4887 | 134 134 | 680 | 730 | 2024-06-28 |
| 4888 | Iced Black Tea Latte 4888 | 134 134 | 680 | 730 | 2024-06-28 |
| 4889 | Iced Hojicha Tea Latte 4889 | 134 134 | 740 | 790 | 2024-06-28 |
| 4890 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 4890 | 134 134 | 630 | 680 | 2024-06-28 |
| 4891 | Iced Shaken Zen Clouds Oolong Lemonade 4891 | 134 134 | 610 | 660 | 2024-06-28 |
| 4892 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 4892 | 134 134 | 630 | 680 | 2024-06-28 |
| 4893 | Origami Pike Place® Roast 4893 | 134 134 | 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");