item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 48
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 11
- 2024-06-28 182
- 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
- 48 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 18699 | Bagel 18699 | 48 48 | 400 | 430 | 2024-06-28 |
| 18700 | Cookie Crumble Cheesecake 18700 | 48 48 | 720 | 770 | 2024-06-28 |
| 18701 | Good Ol' NY Cheesecake 18701 | 48 48 | 720 | 770 | 2024-06-28 |
| 18702 | Signature Chocolate Cake 18702 | 48 48 | 720 | 770 | 2024-06-28 |
| 18703 | Starbucks® Coffee Tiramisu Cake 18703 | 48 48 | 750 | 800 | 2024-06-28 |
| 18704 | Strawberry Shortcake 18704 | 48 48 | 720 | 770 | 2024-06-28 |
| 18705 | Chocolate Chunk Monster Cookie 18705 | 48 48 | 390 | 440 | 2024-06-28 |
| 18706 | Banana Walnut Muffin 18706 | 48 48 | 450 | 500 | 2024-06-28 |
| 18707 | Blueberry Crumble Muffin 18707 | 48 48 | 450 | 500 | 2024-06-28 |
| 18708 | Chocolate Crumble Muffin 18708 | 48 48 | 450 | 500 | 2024-06-28 |
| 18709 | Pancakes 18709 | 48 48 | 550 | 600 | 2024-06-28 |
| 18710 | Almond Croissant 18710 | 48 48 | 470 | 520 | 2024-06-28 |
| 18711 | Buttery Croissant 18711 | 48 48 | 400 | 430 | 2024-06-28 |
| 18712 | Chocolate Croissant 18712 | 48 48 | 440 | 490 | 2024-06-28 |
| 18713 | Creamy Chicken Foldover 18713 | 48 48 | 550 | 600 | 2024-06-28 |
| 18714 | Sausage Roll 18714 | 48 48 | 550 | 600 | 2024-06-28 |
| 18715 | Buttery Scone 18715 | 48 48 | 400 | 430 | 2024-06-28 |
| 18716 | Country Chicken Pie 18716 | 48 48 | 690 | 740 | 2024-06-28 |
| 18717 | Deep Dish Beef Pie 18717 | 48 48 | 690 | 740 | 2024-06-28 |
| 18718 | Spinach & Mushroom Quiche 18718 | 48 48 | 690 | 740 | 2024-06-28 |
| 18719 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 18719 | 48 48 | 390 | 420 | 2024-06-28 |
| 18720 | Mixed Nuts 18720 | 48 48 | 490 | 540 | 2024-06-28 |
| 18721 | Caramel Waffles 18721 | 48 48 | 390 | 420 | 2024-06-28 |
| 18722 | Chicken Ham & Cheese Panwich 18722 | 48 48 | 690 | 740 | 2024-06-28 |
| 18723 | Egg Mayo & Cheese Multigrain Croissant 18723 | 48 48 | 690 | 740 | 2024-06-28 |
| 18724 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 18724 | 48 48 | 690 | 740 | 2024-06-28 |
| 18725 | Rosemary Chicken & Emmental Cheese Croissant 18725 | 48 48 | 690 | 740 | 2024-06-28 |
| 18726 | Scrambled Egg & Turkey Ham Pita 18726 | 48 48 | 690 | 740 | 2024-06-28 |
| 18727 | Turkey Ham & Triple Cheese Toast 18727 | 48 48 | 690 | 740 | 2024-06-28 |
| 18728 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 18728 | 48 48 | 790 | 840 | 2024-06-28 |
| 18729 | Ham & Cheese Croissant 18729 | 48 48 | 690 | 740 | 2024-06-28 |
| 18730 | Sriracha Chicken Whole Wheat Pita 18730 | 48 48 | 750 | 800 | 2024-06-28 |
| 18731 | Blueberry Acai Yogurt Parfait 18731 | 48 48 | 650 | 700 | 2024-06-28 |
| 18732 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 18732 | 48 48 | 650 | 700 | 2024-06-28 |
| 18733 | Caramel Frappuccino® 18733 | 48 48 | 720 | 770 | 2024-06-28 |
| 18734 | Dark Mocha Frappuccino® 18734 | 48 48 | 780 | 830 | 2024-06-28 |
| 18735 | Java Chip Frappuccino® 18735 | 48 48 | 780 | 830 | 2024-06-28 |
| 18736 | Mocha Frappuccino® 18736 | 48 48 | 720 | 770 | 2024-06-28 |
| 18737 | Caramel Macchiato Frappuccino® 18737 | 48 48 | 780 | 830 | 2024-06-28 |
| 18738 | Espresso Frappuccino® 18738 | 48 48 | 720 | 770 | 2024-06-28 |
| 18739 | White Chocolate Mocha Frappuccino® 18739 | 48 48 | 720 | 770 | 2024-06-28 |
| 18740 | Chocolate Chip Cream Frappuccino® 18740 | 48 48 | 780 | 830 | 2024-06-28 |
| 18741 | Hojicha Tea Cream Frappuccino® 18741 | 48 48 | 760 | 810 | 2024-06-28 |
| 18742 | Vanilla Cream Frappuccino® 18742 | 48 48 | 720 | 770 | 2024-06-28 |
| 18743 | Mango Passion Fruit & Hibiscus 18743 | 48 48 | 720 | 770 | 2024-06-28 |
| 18744 | Raspberry Black Currant & Oolong 18744 | 48 48 | 720 | 770 | 2024-06-28 |
| 18745 | Coffee Traveller 18745 | 48 48 | 3120 | 3170 | 2024-06-28 |
| 18746 | Caffè Americano 18746 | 48 48 | 540 | 590 | 2024-06-28 |
| 18747 | Cappuccino 18747 | 48 48 | 680 | 730 | 2024-06-28 |
| 18748 | Caffè Mocha 18748 | 48 48 | 750 | 800 | 2024-06-28 |
| 18749 | Caramel Macchiato 18749 | 48 48 | 760 | 810 | 2024-06-28 |
| 18750 | Espresso 18750 | 48 48 | 390 | 440 | 2024-06-28 |
| 18751 | Caffè Latte 18751 | 48 48 | 680 | 730 | 2024-06-28 |
| 18752 | Oatmilk Latte 18752 | 48 48 | 760 | 810 | 2024-06-28 |
| 18753 | Vanilla Latte 18753 | 48 48 | 750 | 800 | 2024-06-28 |
| 18754 | White Chocolate Mocha 18754 | 48 48 | 750 | 800 | 2024-06-28 |
| 18755 | Flat White 18755 | 48 48 | 760 | 810 | 2024-06-28 |
| 18756 | Ristretto Bianco 18756 | 48 48 | 760 | 810 | 2024-06-28 |
| 18757 | Iced Caffè Americano 18757 | 48 48 | 540 | 590 | 2024-06-28 |
| 18758 | Iced Cappuccino 18758 | 48 48 | 680 | 730 | 2024-06-28 |
| 18759 | Iced Caffè Mocha 18759 | 48 48 | 750 | 800 | 2024-06-28 |
| 18760 | Iced Caramel Macchiato 18760 | 48 48 | 760 | 810 | 2024-06-28 |
| 18761 | Iced Caffè Latte 18761 | 48 48 | 680 | 730 | 2024-06-28 |
| 18762 | Iced Oatmilk Latte 18762 | 48 48 | 760 | 810 | 2024-06-28 |
| 18763 | Iced Vanilla Latte 18763 | 48 48 | 750 | 800 | 2024-06-28 |
| 18764 | Iced White Chocolate Mocha 18764 | 48 48 | 750 | 800 | 2024-06-28 |
| 18765 | Signature Hot Chocolate 18765 | 48 48 | 720 | 770 | 2024-06-28 |
| 18766 | Signature Iced Chocolate 18766 | 48 48 | 720 | 770 | 2024-06-28 |
| 18767 | Carrot Juice 18767 | 48 48 | 490 | 540 | 2024-06-28 |
| 18768 | Cloudy Apple Juice 18768 | 48 48 | 490 | 540 | 2024-06-28 |
| 18769 | Cranberry Red Grapefruit Juice 18769 | 48 48 | 490 | 540 | 2024-06-28 |
| 18770 | Orange Juice 18770 | 48 48 | 490 | 540 | 2024-06-28 |
| 18771 | Evian 18771 | 48 48 | 350 | 400 | 2024-06-28 |
| 18772 | Sparkling Water 18772 | 48 48 | 450 | 500 | 2024-06-28 |
| 18773 | Chai Tea 18773 | 48 48 | 500 | 550 | 2024-06-28 |
| 18774 | Earl Grey Tea 18774 | 48 48 | 500 | 550 | 2024-06-28 |
| 18775 | English Breakfast Tea 18775 | 48 48 | 500 | 550 | 2024-06-28 |
| 18776 | Emperor’s Clouds & Mist™ Tea 18776 | 48 48 | 500 | 550 | 2024-06-28 |
| 18777 | Mint Blend Tea 18777 | 48 48 | 500 | 550 | 2024-06-28 |
| 18778 | Chamomile Tea 18778 | 48 48 | 500 | 550 | 2024-06-28 |
| 18779 | Pure Matcha Latte 18779 | 48 48 | 740 | 790 | 2024-06-28 |
| 18780 | Chai Tea Latte 18780 | 48 48 | 680 | 730 | 2024-06-28 |
| 18781 | Earl Grey Tea Latte 18781 | 48 48 | 680 | 730 | 2024-06-28 |
| 18782 | English Breakfast Tea Latte 18782 | 48 48 | 680 | 730 | 2024-06-28 |
| 18783 | Hojicha Tea Latte 18783 | 48 48 | 740 | 790 | 2024-06-28 |
| 18784 | Zen Clouds Oolong Tea 18784 | 48 48 | 500 | 550 | 2024-06-28 |
| 18785 | Zen Clouds Oolong with Ruby Grapefruit and Honey 18785 | 48 48 | 630 | 680 | 2024-06-28 |
| 18786 | Youthberry™ Tea 18786 | 48 48 | 500 | 550 | 2024-06-28 |
| 18787 | Iced Shaken Black Tea Lemonade 18787 | 48 48 | 610 | 660 | 2024-06-28 |
| 18788 | Iced Shaken Strawberry Black Tea Lemonade 18788 | 48 48 | 630 | 680 | 2024-06-28 |
| 18789 | Iced Shaken Hibiscus Tea Lemonade 18789 | 48 48 | 610 | 660 | 2024-06-28 |
| 18790 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 18790 | 48 48 | 730 | 780 | 2024-06-28 |
| 18791 | Iced Pure Matcha Latte 18791 | 48 48 | 740 | 790 | 2024-06-28 |
| 18792 | Iced Chai Tea Latte 18792 | 48 48 | 680 | 730 | 2024-06-28 |
| 18793 | Iced Black Tea Latte 18793 | 48 48 | 680 | 730 | 2024-06-28 |
| 18794 | Iced Hojicha Tea Latte 18794 | 48 48 | 740 | 790 | 2024-06-28 |
| 18795 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 18795 | 48 48 | 630 | 680 | 2024-06-28 |
| 18796 | Iced Shaken Zen Clouds Oolong Lemonade 18796 | 48 48 | 610 | 660 | 2024-06-28 |
| 18797 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 18797 | 48 48 | 630 | 680 | 2024-06-28 |
| 18798 | Origami Pike Place® Roast 18798 | 48 48 | 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");