item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
248 rows where store_id = 121
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
- 121 · 248 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 6618 | Bagel 6618 | 121 121 | 400 | 430 | 2024-06-28 |
| 6619 | Cookie Crumble Cheesecake 6619 | 121 121 | 720 | 770 | 2024-06-28 |
| 6620 | Good Ol' NY Cheesecake 6620 | 121 121 | 720 | 770 | 2024-06-28 |
| 6621 | Signature Chocolate Cake 6621 | 121 121 | 720 | 770 | 2024-06-28 |
| 6622 | Starbucks® Coffee Tiramisu Cake 6622 | 121 121 | 750 | 800 | 2024-06-28 |
| 6623 | Strawberry Shortcake 6623 | 121 121 | 720 | 770 | 2024-06-28 |
| 6624 | Chocolate Chunk Monster Cookie 6624 | 121 121 | 390 | 440 | 2024-06-28 |
| 6625 | Banana Walnut Muffin 6625 | 121 121 | 450 | 500 | 2024-06-28 |
| 6626 | Blueberry Crumble Muffin 6626 | 121 121 | 450 | 500 | 2024-06-28 |
| 6627 | Chocolate Crumble Muffin 6627 | 121 121 | 450 | 500 | 2024-06-28 |
| 6628 | Pancakes 6628 | 121 121 | 550 | 600 | 2024-06-28 |
| 6629 | Almond Croissant 6629 | 121 121 | 470 | 520 | 2024-06-28 |
| 6630 | Buttery Croissant 6630 | 121 121 | 400 | 430 | 2024-06-28 |
| 6631 | Chocolate Croissant 6631 | 121 121 | 440 | 490 | 2024-06-28 |
| 6632 | Creamy Chicken Foldover 6632 | 121 121 | 550 | 600 | 2024-06-28 |
| 6633 | Sausage Roll 6633 | 121 121 | 550 | 600 | 2024-06-28 |
| 6634 | Buttery Scone 6634 | 121 121 | 400 | 430 | 2024-06-28 |
| 6635 | Country Chicken Pie 6635 | 121 121 | 690 | 740 | 2024-06-28 |
| 6636 | Deep Dish Beef Pie 6636 | 121 121 | 690 | 740 | 2024-06-28 |
| 6637 | Spinach & Mushroom Quiche 6637 | 121 121 | 690 | 740 | 2024-06-28 |
| 6638 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 6638 | 121 121 | 390 | 420 | 2024-06-28 |
| 6639 | Mixed Nuts 6639 | 121 121 | 490 | 540 | 2024-06-28 |
| 6640 | Caramel Waffles 6640 | 121 121 | 390 | 420 | 2024-06-28 |
| 6641 | Chicken Ham & Cheese Panwich 6641 | 121 121 | 690 | 740 | 2024-06-28 |
| 6642 | Egg Mayo & Cheese Multigrain Croissant 6642 | 121 121 | 690 | 740 | 2024-06-28 |
| 6643 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 6643 | 121 121 | 690 | 740 | 2024-06-28 |
| 6644 | Rosemary Chicken & Emmental Cheese Croissant 6644 | 121 121 | 690 | 740 | 2024-06-28 |
| 6645 | Scrambled Egg & Turkey Ham Pita 6645 | 121 121 | 690 | 740 | 2024-06-28 |
| 6646 | Turkey Ham & Triple Cheese Toast 6646 | 121 121 | 690 | 740 | 2024-06-28 |
| 6647 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 6647 | 121 121 | 790 | 840 | 2024-06-28 |
| 6648 | Ham & Cheese Croissant 6648 | 121 121 | 690 | 740 | 2024-06-28 |
| 6649 | Sriracha Chicken Whole Wheat Pita 6649 | 121 121 | 750 | 800 | 2024-06-28 |
| 6650 | Blueberry Acai Yogurt Parfait 6650 | 121 121 | 650 | 700 | 2024-06-28 |
| 6651 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 6651 | 121 121 | 650 | 700 | 2024-06-28 |
| 6652 | Caramel Frappuccino® 6652 | 121 121 | 720 | 770 | 2024-06-28 |
| 6653 | Dark Mocha Frappuccino® 6653 | 121 121 | 780 | 830 | 2024-06-28 |
| 6654 | Java Chip Frappuccino® 6654 | 121 121 | 780 | 830 | 2024-06-28 |
| 6655 | Mocha Frappuccino® 6655 | 121 121 | 720 | 770 | 2024-06-28 |
| 6656 | Caramel Macchiato Frappuccino® 6656 | 121 121 | 780 | 830 | 2024-06-28 |
| 6657 | Espresso Frappuccino® 6657 | 121 121 | 720 | 770 | 2024-06-28 |
| 6658 | White Chocolate Mocha Frappuccino® 6658 | 121 121 | 720 | 770 | 2024-06-28 |
| 6659 | Chocolate Chip Cream Frappuccino® 6659 | 121 121 | 780 | 830 | 2024-06-28 |
| 6660 | Hojicha Tea Cream Frappuccino® 6660 | 121 121 | 760 | 810 | 2024-06-28 |
| 6661 | Vanilla Cream Frappuccino® 6661 | 121 121 | 720 | 770 | 2024-06-28 |
| 6662 | Mango Passion Fruit & Hibiscus 6662 | 121 121 | 720 | 770 | 2024-06-28 |
| 6663 | Raspberry Black Currant & Oolong 6663 | 121 121 | 720 | 770 | 2024-06-28 |
| 6664 | Coffee Traveller 6664 | 121 121 | 3120 | 3170 | 2024-06-28 |
| 6665 | Caffè Americano 6665 | 121 121 | 540 | 590 | 2024-06-28 |
| 6666 | Cappuccino 6666 | 121 121 | 680 | 730 | 2024-06-28 |
| 6667 | Caffè Mocha 6667 | 121 121 | 750 | 800 | 2024-06-28 |
| 6668 | Caramel Macchiato 6668 | 121 121 | 760 | 810 | 2024-06-28 |
| 6669 | Espresso 6669 | 121 121 | 390 | 440 | 2024-06-28 |
| 6670 | Caffè Latte 6670 | 121 121 | 680 | 730 | 2024-06-28 |
| 6671 | Oatmilk Latte 6671 | 121 121 | 760 | 810 | 2024-06-28 |
| 6672 | Vanilla Latte 6672 | 121 121 | 750 | 800 | 2024-06-28 |
| 6673 | White Chocolate Mocha 6673 | 121 121 | 750 | 800 | 2024-06-28 |
| 6674 | Flat White 6674 | 121 121 | 760 | 810 | 2024-06-28 |
| 6675 | Ristretto Bianco 6675 | 121 121 | 760 | 810 | 2024-06-28 |
| 6676 | Iced Caffè Americano 6676 | 121 121 | 540 | 590 | 2024-06-28 |
| 6677 | Iced Cappuccino 6677 | 121 121 | 680 | 730 | 2024-06-28 |
| 6678 | Iced Caffè Mocha 6678 | 121 121 | 750 | 800 | 2024-06-28 |
| 6679 | Iced Caramel Macchiato 6679 | 121 121 | 760 | 810 | 2024-06-28 |
| 6680 | Iced Caffè Latte 6680 | 121 121 | 680 | 730 | 2024-06-28 |
| 6681 | Iced Oatmilk Latte 6681 | 121 121 | 760 | 810 | 2024-06-28 |
| 6682 | Iced Vanilla Latte 6682 | 121 121 | 750 | 800 | 2024-06-28 |
| 6683 | Iced White Chocolate Mocha 6683 | 121 121 | 750 | 800 | 2024-06-28 |
| 6684 | Signature Hot Chocolate 6684 | 121 121 | 720 | 770 | 2024-06-28 |
| 6685 | Signature Iced Chocolate 6685 | 121 121 | 720 | 770 | 2024-06-28 |
| 6686 | Carrot Juice 6686 | 121 121 | 490 | 540 | 2024-06-28 |
| 6687 | Cloudy Apple Juice 6687 | 121 121 | 490 | 540 | 2024-06-28 |
| 6688 | Cranberry Red Grapefruit Juice 6688 | 121 121 | 490 | 540 | 2024-06-28 |
| 6689 | Orange Juice 6689 | 121 121 | 490 | 540 | 2024-06-28 |
| 6690 | Evian 6690 | 121 121 | 350 | 400 | 2024-06-28 |
| 6691 | Sparkling Water 6691 | 121 121 | 450 | 500 | 2024-06-28 |
| 6692 | Chai Tea 6692 | 121 121 | 500 | 550 | 2024-06-28 |
| 6693 | Earl Grey Tea 6693 | 121 121 | 500 | 550 | 2024-06-28 |
| 6694 | English Breakfast Tea 6694 | 121 121 | 500 | 550 | 2024-06-28 |
| 6695 | Emperor’s Clouds & Mist™ Tea 6695 | 121 121 | 500 | 550 | 2024-06-28 |
| 6696 | Mint Blend Tea 6696 | 121 121 | 500 | 550 | 2024-06-28 |
| 6697 | Chamomile Tea 6697 | 121 121 | 500 | 550 | 2024-06-28 |
| 6698 | Pure Matcha Latte 6698 | 121 121 | 740 | 790 | 2024-06-28 |
| 6699 | Chai Tea Latte 6699 | 121 121 | 680 | 730 | 2024-06-28 |
| 6700 | Earl Grey Tea Latte 6700 | 121 121 | 680 | 730 | 2024-06-28 |
| 6701 | English Breakfast Tea Latte 6701 | 121 121 | 680 | 730 | 2024-06-28 |
| 6702 | Hojicha Tea Latte 6702 | 121 121 | 740 | 790 | 2024-06-28 |
| 6703 | Zen Clouds Oolong Tea 6703 | 121 121 | 500 | 550 | 2024-06-28 |
| 6704 | Zen Clouds Oolong with Ruby Grapefruit and Honey 6704 | 121 121 | 630 | 680 | 2024-06-28 |
| 6705 | Youthberry™ Tea 6705 | 121 121 | 500 | 550 | 2024-06-28 |
| 6706 | Iced Shaken Black Tea Lemonade 6706 | 121 121 | 610 | 660 | 2024-06-28 |
| 6707 | Iced Shaken Strawberry Black Tea Lemonade 6707 | 121 121 | 630 | 680 | 2024-06-28 |
| 6708 | Iced Shaken Hibiscus Tea Lemonade 6708 | 121 121 | 610 | 660 | 2024-06-28 |
| 6709 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 6709 | 121 121 | 730 | 780 | 2024-06-28 |
| 6710 | Iced Pure Matcha Latte 6710 | 121 121 | 740 | 790 | 2024-06-28 |
| 6711 | Iced Chai Tea Latte 6711 | 121 121 | 680 | 730 | 2024-06-28 |
| 6712 | Iced Black Tea Latte 6712 | 121 121 | 680 | 730 | 2024-06-28 |
| 6713 | Iced Hojicha Tea Latte 6713 | 121 121 | 740 | 790 | 2024-06-28 |
| 6714 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 6714 | 121 121 | 630 | 680 | 2024-06-28 |
| 6715 | Iced Shaken Zen Clouds Oolong Lemonade 6715 | 121 121 | 610 | 660 | 2024-06-28 |
| 6716 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 6716 | 121 121 | 630 | 680 | 2024-06-28 |
| 6717 | Origami Pike Place® Roast 6717 | 121 121 | 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");