item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
368 rows where store_id = 136
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 12
- 2024-06-28 182
- 2024-10-20 142
- 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
- 2024-10-27 1
store_id 1
- 136 · 368 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 4430 | Bagel 4430 | 136 136 | 400 | 430 | 2024-06-28 |
| 4431 | Cookie Crumble Cheesecake 4431 | 136 136 | 720 | 770 | 2024-06-28 |
| 4432 | Good Ol' NY Cheesecake 4432 | 136 136 | 720 | 770 | 2024-06-28 |
| 4433 | Signature Chocolate Cake 4433 | 136 136 | 720 | 770 | 2024-06-28 |
| 4434 | Starbucks® Coffee Tiramisu Cake 4434 | 136 136 | 750 | 800 | 2024-06-28 |
| 4435 | Strawberry Shortcake 4435 | 136 136 | 720 | 770 | 2024-06-28 |
| 4436 | Chocolate Chunk Monster Cookie 4436 | 136 136 | 390 | 440 | 2024-06-28 |
| 4437 | Banana Walnut Muffin 4437 | 136 136 | 450 | 500 | 2024-06-28 |
| 4438 | Blueberry Crumble Muffin 4438 | 136 136 | 450 | 500 | 2024-06-28 |
| 4439 | Chocolate Crumble Muffin 4439 | 136 136 | 450 | 500 | 2024-06-28 |
| 4440 | Pancakes 4440 | 136 136 | 550 | 600 | 2024-06-28 |
| 4441 | Almond Croissant 4441 | 136 136 | 470 | 520 | 2024-06-28 |
| 4442 | Buttery Croissant 4442 | 136 136 | 400 | 430 | 2024-06-28 |
| 4443 | Chocolate Croissant 4443 | 136 136 | 440 | 490 | 2024-06-28 |
| 4444 | Creamy Chicken Foldover 4444 | 136 136 | 550 | 600 | 2024-06-28 |
| 4445 | Sausage Roll 4445 | 136 136 | 550 | 600 | 2024-06-28 |
| 4446 | Buttery Scone 4446 | 136 136 | 400 | 430 | 2024-06-28 |
| 4447 | Country Chicken Pie 4447 | 136 136 | 690 | 740 | 2024-06-28 |
| 4448 | Deep Dish Beef Pie 4448 | 136 136 | 690 | 740 | 2024-06-28 |
| 4449 | Spinach & Mushroom Quiche 4449 | 136 136 | 690 | 740 | 2024-06-28 |
| 4450 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 4450 | 136 136 | 390 | 420 | 2024-06-28 |
| 4451 | Mixed Nuts 4451 | 136 136 | 490 | 540 | 2024-06-28 |
| 4452 | Caramel Waffles 4452 | 136 136 | 390 | 420 | 2024-06-28 |
| 4453 | Chicken Ham & Cheese Panwich 4453 | 136 136 | 690 | 740 | 2024-06-28 |
| 4454 | Egg Mayo & Cheese Multigrain Croissant 4454 | 136 136 | 690 | 740 | 2024-06-28 |
| 4455 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 4455 | 136 136 | 690 | 740 | 2024-06-28 |
| 4456 | Rosemary Chicken & Emmental Cheese Croissant 4456 | 136 136 | 690 | 740 | 2024-06-28 |
| 4457 | Scrambled Egg & Turkey Ham Pita 4457 | 136 136 | 690 | 740 | 2024-06-28 |
| 4458 | Turkey Ham & Triple Cheese Toast 4458 | 136 136 | 690 | 740 | 2024-06-28 |
| 4459 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 4459 | 136 136 | 790 | 840 | 2024-06-28 |
| 4460 | Ham & Cheese Croissant 4460 | 136 136 | 690 | 740 | 2024-06-28 |
| 4461 | Sriracha Chicken Whole Wheat Pita 4461 | 136 136 | 750 | 800 | 2024-06-28 |
| 4462 | Blueberry Acai Yogurt Parfait 4462 | 136 136 | 650 | 700 | 2024-06-28 |
| 4463 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 4463 | 136 136 | 650 | 700 | 2024-06-28 |
| 4464 | Caramel Frappuccino® 4464 | 136 136 | 720 | 770 | 2024-06-28 |
| 4465 | Dark Mocha Frappuccino® 4465 | 136 136 | 780 | 830 | 2024-06-28 |
| 4466 | Java Chip Frappuccino® 4466 | 136 136 | 780 | 830 | 2024-06-28 |
| 4467 | Mocha Frappuccino® 4467 | 136 136 | 720 | 770 | 2024-06-28 |
| 4468 | Caramel Macchiato Frappuccino® 4468 | 136 136 | 780 | 830 | 2024-06-28 |
| 4469 | Espresso Frappuccino® 4469 | 136 136 | 720 | 770 | 2024-06-28 |
| 4470 | White Chocolate Mocha Frappuccino® 4470 | 136 136 | 720 | 770 | 2024-06-28 |
| 4471 | Chocolate Chip Cream Frappuccino® 4471 | 136 136 | 780 | 830 | 2024-06-28 |
| 4472 | Hojicha Tea Cream Frappuccino® 4472 | 136 136 | 760 | 810 | 2024-06-28 |
| 4473 | Vanilla Cream Frappuccino® 4473 | 136 136 | 720 | 770 | 2024-06-28 |
| 4474 | Mango Passion Fruit & Hibiscus 4474 | 136 136 | 720 | 770 | 2024-06-28 |
| 4475 | Raspberry Black Currant & Oolong 4475 | 136 136 | 720 | 770 | 2024-06-28 |
| 4476 | Coffee Traveller 4476 | 136 136 | 3120 | 3170 | 2024-06-28 |
| 4477 | Caffè Americano 4477 | 136 136 | 540 | 590 | 2024-06-28 |
| 4478 | Cappuccino 4478 | 136 136 | 680 | 730 | 2024-06-28 |
| 4479 | Caffè Mocha 4479 | 136 136 | 750 | 800 | 2024-06-28 |
| 4480 | Caramel Macchiato 4480 | 136 136 | 760 | 810 | 2024-06-28 |
| 4481 | Espresso 4481 | 136 136 | 390 | 440 | 2024-06-28 |
| 4482 | Caffè Latte 4482 | 136 136 | 680 | 730 | 2024-06-28 |
| 4483 | Oatmilk Latte 4483 | 136 136 | 760 | 810 | 2024-06-28 |
| 4484 | Vanilla Latte 4484 | 136 136 | 750 | 800 | 2024-06-28 |
| 4485 | White Chocolate Mocha 4485 | 136 136 | 750 | 800 | 2024-06-28 |
| 4486 | Flat White 4486 | 136 136 | 760 | 810 | 2024-06-28 |
| 4487 | Ristretto Bianco 4487 | 136 136 | 760 | 810 | 2024-06-28 |
| 4488 | Iced Caffè Americano 4488 | 136 136 | 540 | 590 | 2024-06-28 |
| 4489 | Iced Cappuccino 4489 | 136 136 | 680 | 730 | 2024-06-28 |
| 4490 | Iced Caffè Mocha 4490 | 136 136 | 750 | 800 | 2024-06-28 |
| 4491 | Iced Caramel Macchiato 4491 | 136 136 | 760 | 810 | 2024-06-28 |
| 4492 | Iced Caffè Latte 4492 | 136 136 | 680 | 730 | 2024-06-28 |
| 4493 | Iced Oatmilk Latte 4493 | 136 136 | 760 | 810 | 2024-06-28 |
| 4494 | Iced Vanilla Latte 4494 | 136 136 | 750 | 800 | 2024-06-28 |
| 4495 | Iced White Chocolate Mocha 4495 | 136 136 | 750 | 800 | 2024-06-28 |
| 4496 | Signature Hot Chocolate 4496 | 136 136 | 720 | 770 | 2024-06-28 |
| 4497 | Signature Iced Chocolate 4497 | 136 136 | 720 | 770 | 2024-06-28 |
| 4498 | Carrot Juice 4498 | 136 136 | 490 | 540 | 2024-06-28 |
| 4499 | Cloudy Apple Juice 4499 | 136 136 | 490 | 540 | 2024-06-28 |
| 4500 | Cranberry Red Grapefruit Juice 4500 | 136 136 | 490 | 540 | 2024-06-28 |
| 4501 | Orange Juice 4501 | 136 136 | 490 | 540 | 2024-06-28 |
| 4502 | Evian 4502 | 136 136 | 350 | 400 | 2024-06-28 |
| 4503 | Sparkling Water 4503 | 136 136 | 450 | 500 | 2024-06-28 |
| 4504 | Chai Tea 4504 | 136 136 | 500 | 550 | 2024-06-28 |
| 4505 | Earl Grey Tea 4505 | 136 136 | 500 | 550 | 2024-06-28 |
| 4506 | English Breakfast Tea 4506 | 136 136 | 500 | 550 | 2024-06-28 |
| 4507 | Emperor’s Clouds & Mist™ Tea 4507 | 136 136 | 500 | 550 | 2024-06-28 |
| 4508 | Mint Blend Tea 4508 | 136 136 | 500 | 550 | 2024-06-28 |
| 4509 | Chamomile Tea 4509 | 136 136 | 500 | 550 | 2024-06-28 |
| 4510 | Pure Matcha Latte 4510 | 136 136 | 740 | 790 | 2024-06-28 |
| 4511 | Chai Tea Latte 4511 | 136 136 | 680 | 730 | 2024-06-28 |
| 4512 | Earl Grey Tea Latte 4512 | 136 136 | 680 | 730 | 2024-06-28 |
| 4513 | English Breakfast Tea Latte 4513 | 136 136 | 680 | 730 | 2024-06-28 |
| 4514 | Hojicha Tea Latte 4514 | 136 136 | 740 | 790 | 2024-06-28 |
| 4515 | Zen Clouds Oolong Tea 4515 | 136 136 | 500 | 550 | 2024-06-28 |
| 4516 | Zen Clouds Oolong with Ruby Grapefruit and Honey 4516 | 136 136 | 630 | 680 | 2024-06-28 |
| 4517 | Youthberry™ Tea 4517 | 136 136 | 500 | 550 | 2024-06-28 |
| 4518 | Iced Shaken Black Tea Lemonade 4518 | 136 136 | 610 | 660 | 2024-06-28 |
| 4519 | Iced Shaken Strawberry Black Tea Lemonade 4519 | 136 136 | 630 | 680 | 2024-06-28 |
| 4520 | Iced Shaken Hibiscus Tea Lemonade 4520 | 136 136 | 610 | 660 | 2024-06-28 |
| 4521 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 4521 | 136 136 | 730 | 780 | 2024-06-28 |
| 4522 | Iced Pure Matcha Latte 4522 | 136 136 | 740 | 790 | 2024-06-28 |
| 4523 | Iced Chai Tea Latte 4523 | 136 136 | 680 | 730 | 2024-06-28 |
| 4524 | Iced Black Tea Latte 4524 | 136 136 | 680 | 730 | 2024-06-28 |
| 4525 | Iced Hojicha Tea Latte 4525 | 136 136 | 740 | 790 | 2024-06-28 |
| 4526 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 4526 | 136 136 | 630 | 680 | 2024-06-28 |
| 4527 | Iced Shaken Zen Clouds Oolong Lemonade 4527 | 136 136 | 610 | 660 | 2024-06-28 |
| 4528 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 4528 | 136 136 | 630 | 680 | 2024-06-28 |
| 4529 | Origami Pike Place® Roast 4529 | 136 136 | 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");