item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
238 rows where store_id = 126
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 11
- 2024-06-28 184
- 2024-09-15 10
- 2024-11-03 9
- 2024-07-17 7
- 2024-08-18 6
- 2024-07-28 5
- 2024-10-13 5
- 2024-07-03 4
- 2024-10-06 4
- 2024-07-14 2
- 2024-09-29 2
store_id 1
- 126 · 238 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 6252 | Bagel 6252 | 126 126 | 400 | 430 | 2024-06-28 |
| 6253 | Cookie Crumble Cheesecake 6253 | 126 126 | 720 | 770 | 2024-06-28 |
| 6254 | Good Ol' NY Cheesecake 6254 | 126 126 | 720 | 770 | 2024-06-28 |
| 6255 | Signature Chocolate Cake 6255 | 126 126 | 720 | 770 | 2024-06-28 |
| 6256 | Starbucks® Coffee Tiramisu Cake 6256 | 126 126 | 750 | 800 | 2024-06-28 |
| 6257 | Strawberry Shortcake 6257 | 126 126 | 720 | 770 | 2024-06-28 |
| 6258 | Chocolate Chunk Monster Cookie 6258 | 126 126 | 390 | 440 | 2024-06-28 |
| 6259 | Banana Walnut Muffin 6259 | 126 126 | 450 | 500 | 2024-06-28 |
| 6260 | Blueberry Crumble Muffin 6260 | 126 126 | 450 | 500 | 2024-06-28 |
| 6261 | Chocolate Crumble Muffin 6261 | 126 126 | 450 | 500 | 2024-06-28 |
| 6262 | Pancakes 6262 | 126 126 | 550 | 600 | 2024-06-28 |
| 6263 | Almond Croissant 6263 | 126 126 | 470 | 520 | 2024-06-28 |
| 6264 | Buttery Croissant 6264 | 126 126 | 400 | 430 | 2024-06-28 |
| 6265 | Chocolate Croissant 6265 | 126 126 | 440 | 490 | 2024-06-28 |
| 6266 | Creamy Chicken Foldover 6266 | 126 126 | 550 | 600 | 2024-06-28 |
| 6267 | Sausage Roll 6267 | 126 126 | 550 | 600 | 2024-06-28 |
| 6268 | Buttery Scone 6268 | 126 126 | 400 | 430 | 2024-06-28 |
| 6269 | Country Chicken Pie 6269 | 126 126 | 690 | 740 | 2024-06-28 |
| 6270 | Deep Dish Beef Pie 6270 | 126 126 | 690 | 740 | 2024-06-28 |
| 6271 | Spinach & Mushroom Quiche 6271 | 126 126 | 690 | 740 | 2024-06-28 |
| 6272 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 6272 | 126 126 | 390 | 420 | 2024-06-28 |
| 6273 | Mixed Nuts 6273 | 126 126 | 490 | 540 | 2024-06-28 |
| 6274 | Caramel Waffles 6274 | 126 126 | 390 | 420 | 2024-06-28 |
| 6275 | Chicken Ham & Cheese Panwich 6275 | 126 126 | 690 | 740 | 2024-06-28 |
| 6276 | Egg Mayo & Cheese Multigrain Croissant 6276 | 126 126 | 690 | 740 | 2024-06-28 |
| 6277 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 6277 | 126 126 | 690 | 740 | 2024-06-28 |
| 6278 | Rosemary Chicken & Emmental Cheese Croissant 6278 | 126 126 | 690 | 740 | 2024-06-28 |
| 6279 | Scrambled Egg & Turkey Ham Pita 6279 | 126 126 | 690 | 740 | 2024-06-28 |
| 6280 | Turkey Ham & Triple Cheese Toast 6280 | 126 126 | 690 | 740 | 2024-06-28 |
| 6281 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 6281 | 126 126 | 790 | 840 | 2024-06-28 |
| 6282 | Ham & Cheese Croissant 6282 | 126 126 | 690 | 740 | 2024-06-28 |
| 6283 | Sriracha Chicken Whole Wheat Pita 6283 | 126 126 | 750 | 800 | 2024-06-28 |
| 6284 | Blueberry Acai Yogurt Parfait 6284 | 126 126 | 650 | 700 | 2024-06-28 |
| 6285 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 6285 | 126 126 | 650 | 700 | 2024-06-28 |
| 6286 | Caramel Frappuccino® 6286 | 126 126 | 720 | 770 | 2024-06-28 |
| 6287 | Dark Mocha Frappuccino® 6287 | 126 126 | 780 | 830 | 2024-06-28 |
| 6288 | Java Chip Frappuccino® 6288 | 126 126 | 780 | 830 | 2024-06-28 |
| 6289 | Mocha Frappuccino® 6289 | 126 126 | 720 | 770 | 2024-06-28 |
| 6290 | Caramel Macchiato Frappuccino® 6290 | 126 126 | 780 | 830 | 2024-06-28 |
| 6291 | Espresso Frappuccino® 6291 | 126 126 | 720 | 770 | 2024-06-28 |
| 6292 | White Chocolate Mocha Frappuccino® 6292 | 126 126 | 720 | 770 | 2024-06-28 |
| 6293 | Chocolate Chip Cream Frappuccino® 6293 | 126 126 | 780 | 830 | 2024-06-28 |
| 6294 | Hojicha Tea Cream Frappuccino® 6294 | 126 126 | 760 | 810 | 2024-06-28 |
| 6295 | Vanilla Cream Frappuccino® 6295 | 126 126 | 720 | 770 | 2024-06-28 |
| 6296 | Mango Passion Fruit & Hibiscus 6296 | 126 126 | 720 | 770 | 2024-06-28 |
| 6297 | Raspberry Black Currant & Oolong 6297 | 126 126 | 720 | 770 | 2024-06-28 |
| 6298 | Coffee Traveller 6298 | 126 126 | 3120 | 3170 | 2024-06-28 |
| 6299 | Caffè Americano 6299 | 126 126 | 540 | 590 | 2024-06-28 |
| 6300 | Cappuccino 6300 | 126 126 | 680 | 730 | 2024-06-28 |
| 6301 | Caffè Mocha 6301 | 126 126 | 750 | 800 | 2024-06-28 |
| 6302 | Caramel Macchiato 6302 | 126 126 | 760 | 810 | 2024-06-28 |
| 6303 | Espresso 6303 | 126 126 | 390 | 440 | 2024-06-28 |
| 6304 | Caffè Latte 6304 | 126 126 | 680 | 730 | 2024-06-28 |
| 6305 | Oatmilk Latte 6305 | 126 126 | 760 | 810 | 2024-06-28 |
| 6306 | Vanilla Latte 6306 | 126 126 | 750 | 800 | 2024-06-28 |
| 6307 | White Chocolate Mocha 6307 | 126 126 | 750 | 800 | 2024-06-28 |
| 6308 | Flat White 6308 | 126 126 | 760 | 810 | 2024-06-28 |
| 6309 | Ristretto Bianco 6309 | 126 126 | 760 | 810 | 2024-06-28 |
| 6310 | Iced Caffè Americano 6310 | 126 126 | 540 | 590 | 2024-06-28 |
| 6311 | Iced Cappuccino 6311 | 126 126 | 680 | 730 | 2024-06-28 |
| 6312 | Iced Caffè Mocha 6312 | 126 126 | 750 | 800 | 2024-06-28 |
| 6313 | Iced Caramel Macchiato 6313 | 126 126 | 760 | 810 | 2024-06-28 |
| 6314 | Iced Caffè Latte 6314 | 126 126 | 680 | 730 | 2024-06-28 |
| 6315 | Iced Oatmilk Latte 6315 | 126 126 | 760 | 810 | 2024-06-28 |
| 6316 | Iced Vanilla Latte 6316 | 126 126 | 750 | 800 | 2024-06-28 |
| 6317 | Iced White Chocolate Mocha 6317 | 126 126 | 750 | 800 | 2024-06-28 |
| 6318 | Signature Hot Chocolate 6318 | 126 126 | 720 | 770 | 2024-06-28 |
| 6319 | Signature Iced Chocolate 6319 | 126 126 | 720 | 770 | 2024-06-28 |
| 6320 | Carrot Juice 6320 | 126 126 | 490 | 540 | 2024-06-28 |
| 6321 | Cloudy Apple Juice 6321 | 126 126 | 490 | 540 | 2024-06-28 |
| 6322 | Cranberry Red Grapefruit Juice 6322 | 126 126 | 490 | 540 | 2024-06-28 |
| 6323 | Orange Juice 6323 | 126 126 | 490 | 540 | 2024-06-28 |
| 6324 | Evian 6324 | 126 126 | 350 | 400 | 2024-06-28 |
| 6325 | Sparkling Water 6325 | 126 126 | 450 | 500 | 2024-06-28 |
| 6326 | Chai Tea 6326 | 126 126 | 500 | 550 | 2024-06-28 |
| 6327 | Earl Grey Tea 6327 | 126 126 | 500 | 550 | 2024-06-28 |
| 6328 | English Breakfast Tea 6328 | 126 126 | 500 | 550 | 2024-06-28 |
| 6329 | Emperor’s Clouds & Mist™ Tea 6329 | 126 126 | 500 | 550 | 2024-06-28 |
| 6330 | Mint Blend Tea 6330 | 126 126 | 500 | 550 | 2024-06-28 |
| 6331 | Chamomile Tea 6331 | 126 126 | 500 | 550 | 2024-06-28 |
| 6332 | Pure Matcha Latte 6332 | 126 126 | 740 | 790 | 2024-06-28 |
| 6333 | Chai Tea Latte 6333 | 126 126 | 680 | 730 | 2024-06-28 |
| 6334 | Earl Grey Tea Latte 6334 | 126 126 | 680 | 730 | 2024-06-28 |
| 6335 | English Breakfast Tea Latte 6335 | 126 126 | 680 | 730 | 2024-06-28 |
| 6336 | Hojicha Tea Latte 6336 | 126 126 | 740 | 790 | 2024-06-28 |
| 6337 | Zen Clouds Oolong Tea 6337 | 126 126 | 500 | 550 | 2024-06-28 |
| 6338 | Zen Clouds Oolong with Ruby Grapefruit and Honey 6338 | 126 126 | 630 | 680 | 2024-06-28 |
| 6339 | Youthberry™ Tea 6339 | 126 126 | 500 | 550 | 2024-06-28 |
| 6340 | Iced Shaken Black Tea Lemonade 6340 | 126 126 | 610 | 660 | 2024-06-28 |
| 6341 | Iced Shaken Strawberry Black Tea Lemonade 6341 | 126 126 | 630 | 680 | 2024-06-28 |
| 6342 | Iced Shaken Hibiscus Tea Lemonade 6342 | 126 126 | 610 | 660 | 2024-06-28 |
| 6343 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 6343 | 126 126 | 730 | 780 | 2024-06-28 |
| 6344 | Iced Pure Matcha Latte 6344 | 126 126 | 740 | 790 | 2024-06-28 |
| 6345 | Iced Chai Tea Latte 6345 | 126 126 | 680 | 730 | 2024-06-28 |
| 6346 | Iced Black Tea Latte 6346 | 126 126 | 680 | 730 | 2024-06-28 |
| 6347 | Iced Hojicha Tea Latte 6347 | 126 126 | 740 | 790 | 2024-06-28 |
| 6348 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 6348 | 126 126 | 630 | 680 | 2024-06-28 |
| 6349 | Iced Shaken Zen Clouds Oolong Lemonade 6349 | 126 126 | 610 | 660 | 2024-06-28 |
| 6350 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 6350 | 126 126 | 630 | 680 | 2024-06-28 |
| 6351 | Origami Pike Place® Roast 6351 | 126 126 | 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");