item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
249 rows where store_id = 133
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
- 133 · 249 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 4976 | Bagel 4976 | 133 133 | 400 | 430 | 2024-06-28 |
| 4977 | Cookie Crumble Cheesecake 4977 | 133 133 | 720 | 770 | 2024-06-28 |
| 4978 | Good Ol' NY Cheesecake 4978 | 133 133 | 720 | 770 | 2024-06-28 |
| 4979 | Signature Chocolate Cake 4979 | 133 133 | 720 | 770 | 2024-06-28 |
| 4980 | Starbucks® Coffee Tiramisu Cake 4980 | 133 133 | 750 | 800 | 2024-06-28 |
| 4981 | Strawberry Shortcake 4981 | 133 133 | 720 | 770 | 2024-06-28 |
| 4982 | Chocolate Chunk Monster Cookie 4982 | 133 133 | 390 | 440 | 2024-06-28 |
| 4983 | Banana Walnut Muffin 4983 | 133 133 | 450 | 500 | 2024-06-28 |
| 4984 | Blueberry Crumble Muffin 4984 | 133 133 | 450 | 500 | 2024-06-28 |
| 4985 | Chocolate Crumble Muffin 4985 | 133 133 | 450 | 500 | 2024-06-28 |
| 4986 | Pancakes 4986 | 133 133 | 550 | 600 | 2024-06-28 |
| 4987 | Almond Croissant 4987 | 133 133 | 470 | 520 | 2024-06-28 |
| 4988 | Buttery Croissant 4988 | 133 133 | 400 | 430 | 2024-06-28 |
| 4989 | Chocolate Croissant 4989 | 133 133 | 440 | 490 | 2024-06-28 |
| 4990 | Creamy Chicken Foldover 4990 | 133 133 | 550 | 600 | 2024-06-28 |
| 4991 | Sausage Roll 4991 | 133 133 | 550 | 600 | 2024-06-28 |
| 4992 | Buttery Scone 4992 | 133 133 | 400 | 430 | 2024-06-28 |
| 4993 | Country Chicken Pie 4993 | 133 133 | 690 | 740 | 2024-06-28 |
| 4994 | Deep Dish Beef Pie 4994 | 133 133 | 690 | 740 | 2024-06-28 |
| 4995 | Spinach & Mushroom Quiche 4995 | 133 133 | 690 | 740 | 2024-06-28 |
| 4996 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 4996 | 133 133 | 390 | 420 | 2024-06-28 |
| 4997 | Mixed Nuts 4997 | 133 133 | 490 | 540 | 2024-06-28 |
| 4998 | Caramel Waffles 4998 | 133 133 | 390 | 420 | 2024-06-28 |
| 4999 | Chicken Ham & Cheese Panwich 4999 | 133 133 | 690 | 740 | 2024-06-28 |
| 5000 | Egg Mayo & Cheese Multigrain Croissant 5000 | 133 133 | 690 | 740 | 2024-06-28 |
| 5001 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 5001 | 133 133 | 690 | 740 | 2024-06-28 |
| 5002 | Rosemary Chicken & Emmental Cheese Croissant 5002 | 133 133 | 690 | 740 | 2024-06-28 |
| 5003 | Scrambled Egg & Turkey Ham Pita 5003 | 133 133 | 690 | 740 | 2024-06-28 |
| 5004 | Turkey Ham & Triple Cheese Toast 5004 | 133 133 | 690 | 740 | 2024-06-28 |
| 5005 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 5005 | 133 133 | 790 | 840 | 2024-06-28 |
| 5006 | Ham & Cheese Croissant 5006 | 133 133 | 690 | 740 | 2024-06-28 |
| 5007 | Sriracha Chicken Whole Wheat Pita 5007 | 133 133 | 750 | 800 | 2024-06-28 |
| 5008 | Blueberry Acai Yogurt Parfait 5008 | 133 133 | 650 | 700 | 2024-06-28 |
| 5009 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 5009 | 133 133 | 650 | 700 | 2024-06-28 |
| 5010 | Caramel Frappuccino® 5010 | 133 133 | 720 | 770 | 2024-06-28 |
| 5011 | Dark Mocha Frappuccino® 5011 | 133 133 | 780 | 830 | 2024-06-28 |
| 5012 | Java Chip Frappuccino® 5012 | 133 133 | 780 | 830 | 2024-06-28 |
| 5013 | Mocha Frappuccino® 5013 | 133 133 | 720 | 770 | 2024-06-28 |
| 5014 | Caramel Macchiato Frappuccino® 5014 | 133 133 | 780 | 830 | 2024-06-28 |
| 5015 | Espresso Frappuccino® 5015 | 133 133 | 720 | 770 | 2024-06-28 |
| 5016 | White Chocolate Mocha Frappuccino® 5016 | 133 133 | 720 | 770 | 2024-06-28 |
| 5017 | Chocolate Chip Cream Frappuccino® 5017 | 133 133 | 780 | 830 | 2024-06-28 |
| 5018 | Hojicha Tea Cream Frappuccino® 5018 | 133 133 | 760 | 810 | 2024-06-28 |
| 5019 | Vanilla Cream Frappuccino® 5019 | 133 133 | 720 | 770 | 2024-06-28 |
| 5020 | Mango Passion Fruit & Hibiscus 5020 | 133 133 | 720 | 770 | 2024-06-28 |
| 5021 | Raspberry Black Currant & Oolong 5021 | 133 133 | 720 | 770 | 2024-06-28 |
| 5022 | Coffee Traveller 5022 | 133 133 | 3120 | 3170 | 2024-06-28 |
| 5023 | Caffè Americano 5023 | 133 133 | 540 | 590 | 2024-06-28 |
| 5024 | Cappuccino 5024 | 133 133 | 680 | 730 | 2024-06-28 |
| 5025 | Caffè Mocha 5025 | 133 133 | 750 | 800 | 2024-06-28 |
| 5026 | Caramel Macchiato 5026 | 133 133 | 760 | 810 | 2024-06-28 |
| 5027 | Espresso 5027 | 133 133 | 390 | 440 | 2024-06-28 |
| 5028 | Caffè Latte 5028 | 133 133 | 680 | 730 | 2024-06-28 |
| 5029 | Oatmilk Latte 5029 | 133 133 | 760 | 810 | 2024-06-28 |
| 5030 | Vanilla Latte 5030 | 133 133 | 750 | 800 | 2024-06-28 |
| 5031 | White Chocolate Mocha 5031 | 133 133 | 750 | 800 | 2024-06-28 |
| 5032 | Flat White 5032 | 133 133 | 760 | 810 | 2024-06-28 |
| 5033 | Ristretto Bianco 5033 | 133 133 | 760 | 810 | 2024-06-28 |
| 5034 | Iced Caffè Americano 5034 | 133 133 | 540 | 590 | 2024-06-28 |
| 5035 | Iced Cappuccino 5035 | 133 133 | 680 | 730 | 2024-06-28 |
| 5036 | Iced Caffè Mocha 5036 | 133 133 | 750 | 800 | 2024-06-28 |
| 5037 | Iced Caramel Macchiato 5037 | 133 133 | 760 | 810 | 2024-06-28 |
| 5038 | Iced Caffè Latte 5038 | 133 133 | 680 | 730 | 2024-06-28 |
| 5039 | Iced Oatmilk Latte 5039 | 133 133 | 760 | 810 | 2024-06-28 |
| 5040 | Iced Vanilla Latte 5040 | 133 133 | 750 | 800 | 2024-06-28 |
| 5041 | Iced White Chocolate Mocha 5041 | 133 133 | 750 | 800 | 2024-06-28 |
| 5042 | Signature Hot Chocolate 5042 | 133 133 | 720 | 770 | 2024-06-28 |
| 5043 | Signature Iced Chocolate 5043 | 133 133 | 720 | 770 | 2024-06-28 |
| 5044 | Carrot Juice 5044 | 133 133 | 490 | 540 | 2024-06-28 |
| 5045 | Cloudy Apple Juice 5045 | 133 133 | 490 | 540 | 2024-06-28 |
| 5046 | Cranberry Red Grapefruit Juice 5046 | 133 133 | 490 | 540 | 2024-06-28 |
| 5047 | Orange Juice 5047 | 133 133 | 490 | 540 | 2024-06-28 |
| 5048 | Evian 5048 | 133 133 | 350 | 400 | 2024-06-28 |
| 5049 | Sparkling Water 5049 | 133 133 | 450 | 500 | 2024-06-28 |
| 5050 | Chai Tea 5050 | 133 133 | 500 | 550 | 2024-06-28 |
| 5051 | Earl Grey Tea 5051 | 133 133 | 500 | 550 | 2024-06-28 |
| 5052 | English Breakfast Tea 5052 | 133 133 | 500 | 550 | 2024-06-28 |
| 5053 | Emperor’s Clouds & Mist™ Tea 5053 | 133 133 | 500 | 550 | 2024-06-28 |
| 5054 | Mint Blend Tea 5054 | 133 133 | 500 | 550 | 2024-06-28 |
| 5055 | Chamomile Tea 5055 | 133 133 | 500 | 550 | 2024-06-28 |
| 5056 | Pure Matcha Latte 5056 | 133 133 | 740 | 790 | 2024-06-28 |
| 5057 | Chai Tea Latte 5057 | 133 133 | 680 | 730 | 2024-06-28 |
| 5058 | Earl Grey Tea Latte 5058 | 133 133 | 680 | 730 | 2024-06-28 |
| 5059 | English Breakfast Tea Latte 5059 | 133 133 | 680 | 730 | 2024-06-28 |
| 5060 | Hojicha Tea Latte 5060 | 133 133 | 740 | 790 | 2024-06-28 |
| 5061 | Zen Clouds Oolong Tea 5061 | 133 133 | 500 | 550 | 2024-06-28 |
| 5062 | Zen Clouds Oolong with Ruby Grapefruit and Honey 5062 | 133 133 | 630 | 680 | 2024-06-28 |
| 5063 | Youthberry™ Tea 5063 | 133 133 | 500 | 550 | 2024-06-28 |
| 5064 | Iced Shaken Black Tea Lemonade 5064 | 133 133 | 610 | 660 | 2024-06-28 |
| 5065 | Iced Shaken Strawberry Black Tea Lemonade 5065 | 133 133 | 630 | 680 | 2024-06-28 |
| 5066 | Iced Shaken Hibiscus Tea Lemonade 5066 | 133 133 | 610 | 660 | 2024-06-28 |
| 5067 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 5067 | 133 133 | 730 | 780 | 2024-06-28 |
| 5068 | Iced Pure Matcha Latte 5068 | 133 133 | 740 | 790 | 2024-06-28 |
| 5069 | Iced Chai Tea Latte 5069 | 133 133 | 680 | 730 | 2024-06-28 |
| 5070 | Iced Black Tea Latte 5070 | 133 133 | 680 | 730 | 2024-06-28 |
| 5071 | Iced Hojicha Tea Latte 5071 | 133 133 | 740 | 790 | 2024-06-28 |
| 5072 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 5072 | 133 133 | 630 | 680 | 2024-06-28 |
| 5073 | Iced Shaken Zen Clouds Oolong Lemonade 5073 | 133 133 | 610 | 660 | 2024-06-28 |
| 5074 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 5074 | 133 133 | 630 | 680 | 2024-06-28 |
| 5075 | Origami Pike Place® Roast 5075 | 133 133 | 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");