item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 38
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
- 38 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 20157 | Bagel 20157 | 38 38 | 400 | 430 | 2024-06-28 |
| 20158 | Cookie Crumble Cheesecake 20158 | 38 38 | 720 | 770 | 2024-06-28 |
| 20159 | Good Ol' NY Cheesecake 20159 | 38 38 | 720 | 770 | 2024-06-28 |
| 20160 | Signature Chocolate Cake 20160 | 38 38 | 720 | 770 | 2024-06-28 |
| 20161 | Starbucks® Coffee Tiramisu Cake 20161 | 38 38 | 750 | 800 | 2024-06-28 |
| 20162 | Strawberry Shortcake 20162 | 38 38 | 720 | 770 | 2024-06-28 |
| 20163 | Chocolate Chunk Monster Cookie 20163 | 38 38 | 390 | 440 | 2024-06-28 |
| 20164 | Banana Walnut Muffin 20164 | 38 38 | 450 | 500 | 2024-06-28 |
| 20165 | Blueberry Crumble Muffin 20165 | 38 38 | 450 | 500 | 2024-06-28 |
| 20166 | Chocolate Crumble Muffin 20166 | 38 38 | 450 | 500 | 2024-06-28 |
| 20167 | Pancakes 20167 | 38 38 | 550 | 600 | 2024-06-28 |
| 20168 | Almond Croissant 20168 | 38 38 | 470 | 520 | 2024-06-28 |
| 20169 | Buttery Croissant 20169 | 38 38 | 400 | 430 | 2024-06-28 |
| 20170 | Chocolate Croissant 20170 | 38 38 | 440 | 490 | 2024-06-28 |
| 20171 | Creamy Chicken Foldover 20171 | 38 38 | 550 | 600 | 2024-06-28 |
| 20172 | Sausage Roll 20172 | 38 38 | 550 | 600 | 2024-06-28 |
| 20173 | Buttery Scone 20173 | 38 38 | 400 | 430 | 2024-06-28 |
| 20174 | Country Chicken Pie 20174 | 38 38 | 690 | 740 | 2024-06-28 |
| 20175 | Deep Dish Beef Pie 20175 | 38 38 | 690 | 740 | 2024-06-28 |
| 20176 | Spinach & Mushroom Quiche 20176 | 38 38 | 690 | 740 | 2024-06-28 |
| 20177 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 20177 | 38 38 | 390 | 420 | 2024-06-28 |
| 20178 | Mixed Nuts 20178 | 38 38 | 490 | 540 | 2024-06-28 |
| 20179 | Caramel Waffles 20179 | 38 38 | 390 | 420 | 2024-06-28 |
| 20180 | Chicken Ham & Cheese Panwich 20180 | 38 38 | 690 | 740 | 2024-06-28 |
| 20181 | Egg Mayo & Cheese Multigrain Croissant 20181 | 38 38 | 690 | 740 | 2024-06-28 |
| 20182 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 20182 | 38 38 | 690 | 740 | 2024-06-28 |
| 20183 | Rosemary Chicken & Emmental Cheese Croissant 20183 | 38 38 | 690 | 740 | 2024-06-28 |
| 20184 | Scrambled Egg & Turkey Ham Pita 20184 | 38 38 | 690 | 740 | 2024-06-28 |
| 20185 | Turkey Ham & Triple Cheese Toast 20185 | 38 38 | 690 | 740 | 2024-06-28 |
| 20186 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 20186 | 38 38 | 790 | 840 | 2024-06-28 |
| 20187 | Ham & Cheese Croissant 20187 | 38 38 | 690 | 740 | 2024-06-28 |
| 20188 | Sriracha Chicken Whole Wheat Pita 20188 | 38 38 | 750 | 800 | 2024-06-28 |
| 20189 | Blueberry Acai Yogurt Parfait 20189 | 38 38 | 650 | 700 | 2024-06-28 |
| 20190 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 20190 | 38 38 | 650 | 700 | 2024-06-28 |
| 20191 | Caramel Frappuccino® 20191 | 38 38 | 720 | 770 | 2024-06-28 |
| 20192 | Dark Mocha Frappuccino® 20192 | 38 38 | 780 | 830 | 2024-06-28 |
| 20193 | Java Chip Frappuccino® 20193 | 38 38 | 780 | 830 | 2024-06-28 |
| 20194 | Mocha Frappuccino® 20194 | 38 38 | 720 | 770 | 2024-06-28 |
| 20195 | Caramel Macchiato Frappuccino® 20195 | 38 38 | 780 | 830 | 2024-06-28 |
| 20196 | Espresso Frappuccino® 20196 | 38 38 | 720 | 770 | 2024-06-28 |
| 20197 | White Chocolate Mocha Frappuccino® 20197 | 38 38 | 720 | 770 | 2024-06-28 |
| 20198 | Chocolate Chip Cream Frappuccino® 20198 | 38 38 | 780 | 830 | 2024-06-28 |
| 20199 | Hojicha Tea Cream Frappuccino® 20199 | 38 38 | 760 | 810 | 2024-06-28 |
| 20200 | Vanilla Cream Frappuccino® 20200 | 38 38 | 720 | 770 | 2024-06-28 |
| 20201 | Mango Passion Fruit & Hibiscus 20201 | 38 38 | 720 | 770 | 2024-06-28 |
| 20202 | Raspberry Black Currant & Oolong 20202 | 38 38 | 720 | 770 | 2024-06-28 |
| 20203 | Coffee Traveller 20203 | 38 38 | 3120 | 3170 | 2024-06-28 |
| 20204 | Caffè Americano 20204 | 38 38 | 540 | 590 | 2024-06-28 |
| 20205 | Cappuccino 20205 | 38 38 | 680 | 730 | 2024-06-28 |
| 20206 | Caffè Mocha 20206 | 38 38 | 750 | 800 | 2024-06-28 |
| 20207 | Caramel Macchiato 20207 | 38 38 | 760 | 810 | 2024-06-28 |
| 20208 | Espresso 20208 | 38 38 | 390 | 440 | 2024-06-28 |
| 20209 | Caffè Latte 20209 | 38 38 | 680 | 730 | 2024-06-28 |
| 20210 | Oatmilk Latte 20210 | 38 38 | 760 | 810 | 2024-06-28 |
| 20211 | Vanilla Latte 20211 | 38 38 | 750 | 800 | 2024-06-28 |
| 20212 | White Chocolate Mocha 20212 | 38 38 | 750 | 800 | 2024-06-28 |
| 20213 | Flat White 20213 | 38 38 | 760 | 810 | 2024-06-28 |
| 20214 | Ristretto Bianco 20214 | 38 38 | 760 | 810 | 2024-06-28 |
| 20215 | Iced Caffè Americano 20215 | 38 38 | 540 | 590 | 2024-06-28 |
| 20216 | Iced Cappuccino 20216 | 38 38 | 680 | 730 | 2024-06-28 |
| 20217 | Iced Caffè Mocha 20217 | 38 38 | 750 | 800 | 2024-06-28 |
| 20218 | Iced Caramel Macchiato 20218 | 38 38 | 760 | 810 | 2024-06-28 |
| 20219 | Iced Caffè Latte 20219 | 38 38 | 680 | 730 | 2024-06-28 |
| 20220 | Iced Oatmilk Latte 20220 | 38 38 | 760 | 810 | 2024-06-28 |
| 20221 | Iced Vanilla Latte 20221 | 38 38 | 750 | 800 | 2024-06-28 |
| 20222 | Iced White Chocolate Mocha 20222 | 38 38 | 750 | 800 | 2024-06-28 |
| 20223 | Signature Hot Chocolate 20223 | 38 38 | 720 | 770 | 2024-06-28 |
| 20224 | Signature Iced Chocolate 20224 | 38 38 | 720 | 770 | 2024-06-28 |
| 20225 | Carrot Juice 20225 | 38 38 | 490 | 540 | 2024-06-28 |
| 20226 | Cloudy Apple Juice 20226 | 38 38 | 490 | 540 | 2024-06-28 |
| 20227 | Cranberry Red Grapefruit Juice 20227 | 38 38 | 490 | 540 | 2024-06-28 |
| 20228 | Orange Juice 20228 | 38 38 | 490 | 540 | 2024-06-28 |
| 20229 | Evian 20229 | 38 38 | 350 | 400 | 2024-06-28 |
| 20230 | Sparkling Water 20230 | 38 38 | 450 | 500 | 2024-06-28 |
| 20231 | Chai Tea 20231 | 38 38 | 500 | 550 | 2024-06-28 |
| 20232 | Earl Grey Tea 20232 | 38 38 | 500 | 550 | 2024-06-28 |
| 20233 | English Breakfast Tea 20233 | 38 38 | 500 | 550 | 2024-06-28 |
| 20234 | Emperor’s Clouds & Mist™ Tea 20234 | 38 38 | 500 | 550 | 2024-06-28 |
| 20235 | Mint Blend Tea 20235 | 38 38 | 500 | 550 | 2024-06-28 |
| 20236 | Chamomile Tea 20236 | 38 38 | 500 | 550 | 2024-06-28 |
| 20237 | Pure Matcha Latte 20237 | 38 38 | 740 | 790 | 2024-06-28 |
| 20238 | Chai Tea Latte 20238 | 38 38 | 680 | 730 | 2024-06-28 |
| 20239 | Earl Grey Tea Latte 20239 | 38 38 | 680 | 730 | 2024-06-28 |
| 20240 | English Breakfast Tea Latte 20240 | 38 38 | 680 | 730 | 2024-06-28 |
| 20241 | Hojicha Tea Latte 20241 | 38 38 | 740 | 790 | 2024-06-28 |
| 20242 | Zen Clouds Oolong Tea 20242 | 38 38 | 500 | 550 | 2024-06-28 |
| 20243 | Zen Clouds Oolong with Ruby Grapefruit and Honey 20243 | 38 38 | 630 | 680 | 2024-06-28 |
| 20244 | Youthberry™ Tea 20244 | 38 38 | 500 | 550 | 2024-06-28 |
| 20245 | Iced Shaken Black Tea Lemonade 20245 | 38 38 | 610 | 660 | 2024-06-28 |
| 20246 | Iced Shaken Strawberry Black Tea Lemonade 20246 | 38 38 | 630 | 680 | 2024-06-28 |
| 20247 | Iced Shaken Hibiscus Tea Lemonade 20247 | 38 38 | 610 | 660 | 2024-06-28 |
| 20248 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 20248 | 38 38 | 730 | 780 | 2024-06-28 |
| 20249 | Iced Pure Matcha Latte 20249 | 38 38 | 740 | 790 | 2024-06-28 |
| 20250 | Iced Chai Tea Latte 20250 | 38 38 | 680 | 730 | 2024-06-28 |
| 20251 | Iced Black Tea Latte 20251 | 38 38 | 680 | 730 | 2024-06-28 |
| 20252 | Iced Hojicha Tea Latte 20252 | 38 38 | 740 | 790 | 2024-06-28 |
| 20253 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 20253 | 38 38 | 630 | 680 | 2024-06-28 |
| 20254 | Iced Shaken Zen Clouds Oolong Lemonade 20254 | 38 38 | 610 | 660 | 2024-06-28 |
| 20255 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 20255 | 38 38 | 630 | 680 | 2024-06-28 |
| 20256 | Origami Pike Place® Roast 20256 | 38 38 | 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");