item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
248 rows where store_id = 99
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 12
- 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
store_id 1
- 99 · 248 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 10442 | Bagel 10442 | 99 99 | 400 | 430 | 2024-06-28 |
| 10443 | Cookie Crumble Cheesecake 10443 | 99 99 | 720 | 770 | 2024-06-28 |
| 10444 | Good Ol' NY Cheesecake 10444 | 99 99 | 720 | 770 | 2024-06-28 |
| 10445 | Signature Chocolate Cake 10445 | 99 99 | 720 | 770 | 2024-06-28 |
| 10446 | Starbucks® Coffee Tiramisu Cake 10446 | 99 99 | 750 | 800 | 2024-06-28 |
| 10447 | Strawberry Shortcake 10447 | 99 99 | 720 | 770 | 2024-06-28 |
| 10448 | Chocolate Chunk Monster Cookie 10448 | 99 99 | 390 | 440 | 2024-06-28 |
| 10449 | Banana Walnut Muffin 10449 | 99 99 | 450 | 500 | 2024-06-28 |
| 10450 | Blueberry Crumble Muffin 10450 | 99 99 | 450 | 500 | 2024-06-28 |
| 10451 | Chocolate Crumble Muffin 10451 | 99 99 | 450 | 500 | 2024-06-28 |
| 10452 | Pancakes 10452 | 99 99 | 550 | 600 | 2024-06-28 |
| 10453 | Almond Croissant 10453 | 99 99 | 470 | 520 | 2024-06-28 |
| 10454 | Buttery Croissant 10454 | 99 99 | 400 | 430 | 2024-06-28 |
| 10455 | Chocolate Croissant 10455 | 99 99 | 440 | 490 | 2024-06-28 |
| 10456 | Creamy Chicken Foldover 10456 | 99 99 | 550 | 600 | 2024-06-28 |
| 10457 | Sausage Roll 10457 | 99 99 | 550 | 600 | 2024-06-28 |
| 10458 | Buttery Scone 10458 | 99 99 | 400 | 430 | 2024-06-28 |
| 10459 | Country Chicken Pie 10459 | 99 99 | 690 | 740 | 2024-06-28 |
| 10460 | Deep Dish Beef Pie 10460 | 99 99 | 690 | 740 | 2024-06-28 |
| 10461 | Spinach & Mushroom Quiche 10461 | 99 99 | 690 | 740 | 2024-06-28 |
| 10462 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 10462 | 99 99 | 390 | 420 | 2024-06-28 |
| 10463 | Mixed Nuts 10463 | 99 99 | 490 | 540 | 2024-06-28 |
| 10464 | Caramel Waffles 10464 | 99 99 | 390 | 420 | 2024-06-28 |
| 10465 | Chicken Ham & Cheese Panwich 10465 | 99 99 | 690 | 740 | 2024-06-28 |
| 10466 | Egg Mayo & Cheese Multigrain Croissant 10466 | 99 99 | 690 | 740 | 2024-06-28 |
| 10467 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 10467 | 99 99 | 690 | 740 | 2024-06-28 |
| 10468 | Rosemary Chicken & Emmental Cheese Croissant 10468 | 99 99 | 690 | 740 | 2024-06-28 |
| 10469 | Scrambled Egg & Turkey Ham Pita 10469 | 99 99 | 690 | 740 | 2024-06-28 |
| 10470 | Turkey Ham & Triple Cheese Toast 10470 | 99 99 | 690 | 740 | 2024-06-28 |
| 10471 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 10471 | 99 99 | 790 | 840 | 2024-06-28 |
| 10472 | Ham & Cheese Croissant 10472 | 99 99 | 690 | 740 | 2024-06-28 |
| 10473 | Sriracha Chicken Whole Wheat Pita 10473 | 99 99 | 750 | 800 | 2024-06-28 |
| 10474 | Blueberry Acai Yogurt Parfait 10474 | 99 99 | 650 | 700 | 2024-06-28 |
| 10475 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 10475 | 99 99 | 650 | 700 | 2024-06-28 |
| 10476 | Caramel Frappuccino® 10476 | 99 99 | 720 | 770 | 2024-06-28 |
| 10477 | Dark Mocha Frappuccino® 10477 | 99 99 | 780 | 830 | 2024-06-28 |
| 10478 | Java Chip Frappuccino® 10478 | 99 99 | 780 | 830 | 2024-06-28 |
| 10479 | Mocha Frappuccino® 10479 | 99 99 | 720 | 770 | 2024-06-28 |
| 10480 | Caramel Macchiato Frappuccino® 10480 | 99 99 | 780 | 830 | 2024-06-28 |
| 10481 | Espresso Frappuccino® 10481 | 99 99 | 720 | 770 | 2024-06-28 |
| 10482 | White Chocolate Mocha Frappuccino® 10482 | 99 99 | 720 | 770 | 2024-06-28 |
| 10483 | Chocolate Chip Cream Frappuccino® 10483 | 99 99 | 780 | 830 | 2024-06-28 |
| 10484 | Hojicha Tea Cream Frappuccino® 10484 | 99 99 | 760 | 810 | 2024-06-28 |
| 10485 | Vanilla Cream Frappuccino® 10485 | 99 99 | 720 | 770 | 2024-06-28 |
| 10486 | Mango Passion Fruit & Hibiscus 10486 | 99 99 | 720 | 770 | 2024-06-28 |
| 10487 | Raspberry Black Currant & Oolong 10487 | 99 99 | 720 | 770 | 2024-06-28 |
| 10488 | Coffee Traveller 10488 | 99 99 | 3120 | 3170 | 2024-06-28 |
| 10489 | Caffè Americano 10489 | 99 99 | 540 | 590 | 2024-06-28 |
| 10490 | Cappuccino 10490 | 99 99 | 680 | 730 | 2024-06-28 |
| 10491 | Caffè Mocha 10491 | 99 99 | 750 | 800 | 2024-06-28 |
| 10492 | Caramel Macchiato 10492 | 99 99 | 760 | 810 | 2024-06-28 |
| 10493 | Espresso 10493 | 99 99 | 390 | 440 | 2024-06-28 |
| 10494 | Caffè Latte 10494 | 99 99 | 680 | 730 | 2024-06-28 |
| 10495 | Oatmilk Latte 10495 | 99 99 | 760 | 810 | 2024-06-28 |
| 10496 | Vanilla Latte 10496 | 99 99 | 750 | 800 | 2024-06-28 |
| 10497 | White Chocolate Mocha 10497 | 99 99 | 750 | 800 | 2024-06-28 |
| 10498 | Flat White 10498 | 99 99 | 760 | 810 | 2024-06-28 |
| 10499 | Ristretto Bianco 10499 | 99 99 | 760 | 810 | 2024-06-28 |
| 10500 | Iced Caffè Americano 10500 | 99 99 | 540 | 590 | 2024-06-28 |
| 10501 | Iced Cappuccino 10501 | 99 99 | 680 | 730 | 2024-06-28 |
| 10502 | Iced Caffè Mocha 10502 | 99 99 | 750 | 800 | 2024-06-28 |
| 10503 | Iced Caramel Macchiato 10503 | 99 99 | 760 | 810 | 2024-06-28 |
| 10504 | Iced Caffè Latte 10504 | 99 99 | 680 | 730 | 2024-06-28 |
| 10505 | Iced Oatmilk Latte 10505 | 99 99 | 760 | 810 | 2024-06-28 |
| 10506 | Iced Vanilla Latte 10506 | 99 99 | 750 | 800 | 2024-06-28 |
| 10507 | Iced White Chocolate Mocha 10507 | 99 99 | 750 | 800 | 2024-06-28 |
| 10508 | Signature Hot Chocolate 10508 | 99 99 | 720 | 770 | 2024-06-28 |
| 10509 | Signature Iced Chocolate 10509 | 99 99 | 720 | 770 | 2024-06-28 |
| 10510 | Carrot Juice 10510 | 99 99 | 490 | 540 | 2024-06-28 |
| 10511 | Cloudy Apple Juice 10511 | 99 99 | 490 | 540 | 2024-06-28 |
| 10512 | Cranberry Red Grapefruit Juice 10512 | 99 99 | 490 | 540 | 2024-06-28 |
| 10513 | Orange Juice 10513 | 99 99 | 490 | 540 | 2024-06-28 |
| 10514 | Evian 10514 | 99 99 | 350 | 400 | 2024-06-28 |
| 10515 | Sparkling Water 10515 | 99 99 | 450 | 500 | 2024-06-28 |
| 10516 | Chai Tea 10516 | 99 99 | 500 | 550 | 2024-06-28 |
| 10517 | Earl Grey Tea 10517 | 99 99 | 500 | 550 | 2024-06-28 |
| 10518 | English Breakfast Tea 10518 | 99 99 | 500 | 550 | 2024-06-28 |
| 10519 | Emperor’s Clouds & Mist™ Tea 10519 | 99 99 | 500 | 550 | 2024-06-28 |
| 10520 | Mint Blend Tea 10520 | 99 99 | 500 | 550 | 2024-06-28 |
| 10521 | Chamomile Tea 10521 | 99 99 | 500 | 550 | 2024-06-28 |
| 10522 | Pure Matcha Latte 10522 | 99 99 | 740 | 790 | 2024-06-28 |
| 10523 | Chai Tea Latte 10523 | 99 99 | 680 | 730 | 2024-06-28 |
| 10524 | Earl Grey Tea Latte 10524 | 99 99 | 680 | 730 | 2024-06-28 |
| 10525 | English Breakfast Tea Latte 10525 | 99 99 | 680 | 730 | 2024-06-28 |
| 10526 | Hojicha Tea Latte 10526 | 99 99 | 740 | 790 | 2024-06-28 |
| 10527 | Zen Clouds Oolong Tea 10527 | 99 99 | 500 | 550 | 2024-06-28 |
| 10528 | Zen Clouds Oolong with Ruby Grapefruit and Honey 10528 | 99 99 | 630 | 680 | 2024-06-28 |
| 10529 | Youthberry™ Tea 10529 | 99 99 | 500 | 550 | 2024-06-28 |
| 10530 | Iced Shaken Black Tea Lemonade 10530 | 99 99 | 610 | 660 | 2024-06-28 |
| 10531 | Iced Shaken Strawberry Black Tea Lemonade 10531 | 99 99 | 630 | 680 | 2024-06-28 |
| 10532 | Iced Shaken Hibiscus Tea Lemonade 10532 | 99 99 | 610 | 660 | 2024-06-28 |
| 10533 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 10533 | 99 99 | 730 | 780 | 2024-06-28 |
| 10534 | Iced Pure Matcha Latte 10534 | 99 99 | 740 | 790 | 2024-06-28 |
| 10535 | Iced Chai Tea Latte 10535 | 99 99 | 680 | 730 | 2024-06-28 |
| 10536 | Iced Black Tea Latte 10536 | 99 99 | 680 | 730 | 2024-06-28 |
| 10537 | Iced Hojicha Tea Latte 10537 | 99 99 | 740 | 790 | 2024-06-28 |
| 10538 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 10538 | 99 99 | 630 | 680 | 2024-06-28 |
| 10539 | Iced Shaken Zen Clouds Oolong Lemonade 10539 | 99 99 | 610 | 660 | 2024-06-28 |
| 10540 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 10540 | 99 99 | 630 | 680 | 2024-06-28 |
| 10541 | Origami Pike Place® Roast 10541 | 99 99 | 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");