item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
225 rows where store_id = 74
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 10
- 2024-06-28 182
- 2024-09-15 10
- 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
- 74 · 225 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 14300 | Bagel 14300 | 74 74 | 400 | 430 | 2024-06-28 |
| 14301 | Cookie Crumble Cheesecake 14301 | 74 74 | 720 | 770 | 2024-06-28 |
| 14302 | Good Ol' NY Cheesecake 14302 | 74 74 | 720 | 770 | 2024-06-28 |
| 14303 | Signature Chocolate Cake 14303 | 74 74 | 720 | 770 | 2024-06-28 |
| 14304 | Starbucks® Coffee Tiramisu Cake 14304 | 74 74 | 750 | 800 | 2024-06-28 |
| 14305 | Strawberry Shortcake 14305 | 74 74 | 720 | 770 | 2024-06-28 |
| 14306 | Chocolate Chunk Monster Cookie 14306 | 74 74 | 390 | 440 | 2024-06-28 |
| 14307 | Banana Walnut Muffin 14307 | 74 74 | 450 | 500 | 2024-06-28 |
| 14308 | Blueberry Crumble Muffin 14308 | 74 74 | 450 | 500 | 2024-06-28 |
| 14309 | Chocolate Crumble Muffin 14309 | 74 74 | 450 | 500 | 2024-06-28 |
| 14310 | Pancakes 14310 | 74 74 | 550 | 600 | 2024-06-28 |
| 14311 | Almond Croissant 14311 | 74 74 | 470 | 520 | 2024-06-28 |
| 14312 | Buttery Croissant 14312 | 74 74 | 400 | 430 | 2024-06-28 |
| 14313 | Chocolate Croissant 14313 | 74 74 | 440 | 490 | 2024-06-28 |
| 14314 | Creamy Chicken Foldover 14314 | 74 74 | 550 | 600 | 2024-06-28 |
| 14315 | Sausage Roll 14315 | 74 74 | 550 | 600 | 2024-06-28 |
| 14316 | Buttery Scone 14316 | 74 74 | 400 | 430 | 2024-06-28 |
| 14317 | Country Chicken Pie 14317 | 74 74 | 690 | 740 | 2024-06-28 |
| 14318 | Deep Dish Beef Pie 14318 | 74 74 | 690 | 740 | 2024-06-28 |
| 14319 | Spinach & Mushroom Quiche 14319 | 74 74 | 690 | 740 | 2024-06-28 |
| 14320 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 14320 | 74 74 | 390 | 420 | 2024-06-28 |
| 14321 | Mixed Nuts 14321 | 74 74 | 490 | 540 | 2024-06-28 |
| 14322 | Caramel Waffles 14322 | 74 74 | 390 | 420 | 2024-06-28 |
| 14323 | Chicken Ham & Cheese Panwich 14323 | 74 74 | 690 | 740 | 2024-06-28 |
| 14324 | Egg Mayo & Cheese Multigrain Croissant 14324 | 74 74 | 690 | 740 | 2024-06-28 |
| 14325 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 14325 | 74 74 | 690 | 740 | 2024-06-28 |
| 14326 | Rosemary Chicken & Emmental Cheese Croissant 14326 | 74 74 | 690 | 740 | 2024-06-28 |
| 14327 | Scrambled Egg & Turkey Ham Pita 14327 | 74 74 | 690 | 740 | 2024-06-28 |
| 14328 | Turkey Ham & Triple Cheese Toast 14328 | 74 74 | 690 | 740 | 2024-06-28 |
| 14329 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 14329 | 74 74 | 790 | 840 | 2024-06-28 |
| 14330 | Ham & Cheese Croissant 14330 | 74 74 | 690 | 740 | 2024-06-28 |
| 14331 | Sriracha Chicken Whole Wheat Pita 14331 | 74 74 | 750 | 800 | 2024-06-28 |
| 14332 | Blueberry Acai Yogurt Parfait 14332 | 74 74 | 650 | 700 | 2024-06-28 |
| 14333 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 14333 | 74 74 | 650 | 700 | 2024-06-28 |
| 14334 | Caramel Frappuccino® 14334 | 74 74 | 720 | 770 | 2024-06-28 |
| 14335 | Dark Mocha Frappuccino® 14335 | 74 74 | 780 | 830 | 2024-06-28 |
| 14336 | Java Chip Frappuccino® 14336 | 74 74 | 780 | 830 | 2024-06-28 |
| 14337 | Mocha Frappuccino® 14337 | 74 74 | 720 | 770 | 2024-06-28 |
| 14338 | Caramel Macchiato Frappuccino® 14338 | 74 74 | 780 | 830 | 2024-06-28 |
| 14339 | Espresso Frappuccino® 14339 | 74 74 | 720 | 770 | 2024-06-28 |
| 14340 | White Chocolate Mocha Frappuccino® 14340 | 74 74 | 720 | 770 | 2024-06-28 |
| 14341 | Chocolate Chip Cream Frappuccino® 14341 | 74 74 | 780 | 830 | 2024-06-28 |
| 14342 | Hojicha Tea Cream Frappuccino® 14342 | 74 74 | 760 | 810 | 2024-06-28 |
| 14343 | Vanilla Cream Frappuccino® 14343 | 74 74 | 720 | 770 | 2024-06-28 |
| 14344 | Mango Passion Fruit & Hibiscus 14344 | 74 74 | 720 | 770 | 2024-06-28 |
| 14345 | Raspberry Black Currant & Oolong 14345 | 74 74 | 720 | 770 | 2024-06-28 |
| 14346 | Coffee Traveller 14346 | 74 74 | 3120 | 3170 | 2024-06-28 |
| 14347 | Caffè Americano 14347 | 74 74 | 540 | 590 | 2024-06-28 |
| 14348 | Cappuccino 14348 | 74 74 | 680 | 730 | 2024-06-28 |
| 14349 | Caffè Mocha 14349 | 74 74 | 750 | 800 | 2024-06-28 |
| 14350 | Caramel Macchiato 14350 | 74 74 | 760 | 810 | 2024-06-28 |
| 14351 | Espresso 14351 | 74 74 | 390 | 440 | 2024-06-28 |
| 14352 | Caffè Latte 14352 | 74 74 | 680 | 730 | 2024-06-28 |
| 14353 | Oatmilk Latte 14353 | 74 74 | 760 | 810 | 2024-06-28 |
| 14354 | Vanilla Latte 14354 | 74 74 | 750 | 800 | 2024-06-28 |
| 14355 | White Chocolate Mocha 14355 | 74 74 | 750 | 800 | 2024-06-28 |
| 14356 | Flat White 14356 | 74 74 | 760 | 810 | 2024-06-28 |
| 14357 | Ristretto Bianco 14357 | 74 74 | 760 | 810 | 2024-06-28 |
| 14358 | Iced Caffè Americano 14358 | 74 74 | 540 | 590 | 2024-06-28 |
| 14359 | Iced Cappuccino 14359 | 74 74 | 680 | 730 | 2024-06-28 |
| 14360 | Iced Caffè Mocha 14360 | 74 74 | 750 | 800 | 2024-06-28 |
| 14361 | Iced Caramel Macchiato 14361 | 74 74 | 760 | 810 | 2024-06-28 |
| 14362 | Iced Caffè Latte 14362 | 74 74 | 680 | 730 | 2024-06-28 |
| 14363 | Iced Oatmilk Latte 14363 | 74 74 | 760 | 810 | 2024-06-28 |
| 14364 | Iced Vanilla Latte 14364 | 74 74 | 750 | 800 | 2024-06-28 |
| 14365 | Iced White Chocolate Mocha 14365 | 74 74 | 750 | 800 | 2024-06-28 |
| 14366 | Signature Hot Chocolate 14366 | 74 74 | 720 | 770 | 2024-06-28 |
| 14367 | Signature Iced Chocolate 14367 | 74 74 | 720 | 770 | 2024-06-28 |
| 14368 | Carrot Juice 14368 | 74 74 | 490 | 540 | 2024-06-28 |
| 14369 | Cloudy Apple Juice 14369 | 74 74 | 490 | 540 | 2024-06-28 |
| 14370 | Cranberry Red Grapefruit Juice 14370 | 74 74 | 490 | 540 | 2024-06-28 |
| 14371 | Orange Juice 14371 | 74 74 | 490 | 540 | 2024-06-28 |
| 14372 | Evian 14372 | 74 74 | 350 | 400 | 2024-06-28 |
| 14373 | Sparkling Water 14373 | 74 74 | 450 | 500 | 2024-06-28 |
| 14374 | Chai Tea 14374 | 74 74 | 500 | 550 | 2024-06-28 |
| 14375 | Earl Grey Tea 14375 | 74 74 | 500 | 550 | 2024-06-28 |
| 14376 | English Breakfast Tea 14376 | 74 74 | 500 | 550 | 2024-06-28 |
| 14377 | Emperor’s Clouds & Mist™ Tea 14377 | 74 74 | 500 | 550 | 2024-06-28 |
| 14378 | Mint Blend Tea 14378 | 74 74 | 500 | 550 | 2024-06-28 |
| 14379 | Chamomile Tea 14379 | 74 74 | 500 | 550 | 2024-06-28 |
| 14380 | Pure Matcha Latte 14380 | 74 74 | 740 | 790 | 2024-06-28 |
| 14381 | Chai Tea Latte 14381 | 74 74 | 680 | 730 | 2024-06-28 |
| 14382 | Earl Grey Tea Latte 14382 | 74 74 | 680 | 730 | 2024-06-28 |
| 14383 | English Breakfast Tea Latte 14383 | 74 74 | 680 | 730 | 2024-06-28 |
| 14384 | Hojicha Tea Latte 14384 | 74 74 | 740 | 790 | 2024-06-28 |
| 14385 | Zen Clouds Oolong Tea 14385 | 74 74 | 500 | 550 | 2024-06-28 |
| 14386 | Zen Clouds Oolong with Ruby Grapefruit and Honey 14386 | 74 74 | 630 | 680 | 2024-06-28 |
| 14387 | Youthberry™ Tea 14387 | 74 74 | 500 | 550 | 2024-06-28 |
| 14388 | Iced Shaken Black Tea Lemonade 14388 | 74 74 | 610 | 660 | 2024-06-28 |
| 14389 | Iced Shaken Strawberry Black Tea Lemonade 14389 | 74 74 | 630 | 680 | 2024-06-28 |
| 14390 | Iced Shaken Hibiscus Tea Lemonade 14390 | 74 74 | 610 | 660 | 2024-06-28 |
| 14391 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 14391 | 74 74 | 730 | 780 | 2024-06-28 |
| 14392 | Iced Pure Matcha Latte 14392 | 74 74 | 740 | 790 | 2024-06-28 |
| 14393 | Iced Chai Tea Latte 14393 | 74 74 | 680 | 730 | 2024-06-28 |
| 14394 | Iced Black Tea Latte 14394 | 74 74 | 680 | 730 | 2024-06-28 |
| 14395 | Iced Hojicha Tea Latte 14395 | 74 74 | 740 | 790 | 2024-06-28 |
| 14396 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 14396 | 74 74 | 630 | 680 | 2024-06-28 |
| 14397 | Iced Shaken Zen Clouds Oolong Lemonade 14397 | 74 74 | 610 | 660 | 2024-06-28 |
| 14398 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 14398 | 74 74 | 630 | 680 | 2024-06-28 |
| 14399 | Origami Pike Place® Roast 14399 | 74 74 | 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");