item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
257 rows where store_id = 69
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 12
- 2024-06-28 204
- 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
- 2024-10-27 1
store_id 1
- 69 · 257 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 731 | Bagel 731 | 69 69 | 400 | 430 | 2024-06-28 |
| 732 | Cookie Crumble Cheesecake 732 | 69 69 | 720 | 770 | 2024-06-28 |
| 733 | Good Ol' NY Cheesecake 733 | 69 69 | 720 | 770 | 2024-06-28 |
| 734 | Signature Chocolate Cake 734 | 69 69 | 720 | 770 | 2024-06-28 |
| 735 | Starbucks® Coffee Tiramisu Cake 735 | 69 69 | 750 | 800 | 2024-06-28 |
| 736 | Strawberry Shortcake 736 | 69 69 | 720 | 770 | 2024-06-28 |
| 737 | Chocolate Chunk Monster Cookie 737 | 69 69 | 390 | 440 | 2024-06-28 |
| 738 | Banana Walnut Muffin 738 | 69 69 | 450 | 500 | 2024-06-28 |
| 739 | Blueberry Crumble Muffin 739 | 69 69 | 450 | 500 | 2024-06-28 |
| 740 | Chocolate Crumble Muffin 740 | 69 69 | 450 | 500 | 2024-06-28 |
| 741 | Pancakes 741 | 69 69 | 550 | 600 | 2024-06-28 |
| 742 | Almond Croissant 742 | 69 69 | 470 | 520 | 2024-06-28 |
| 743 | Buttery Croissant 743 | 69 69 | 400 | 430 | 2024-06-28 |
| 744 | Chocolate Croissant 744 | 69 69 | 440 | 490 | 2024-06-28 |
| 745 | Creamy Chicken Foldover 745 | 69 69 | 550 | 600 | 2024-06-28 |
| 746 | Sausage Roll 746 | 69 69 | 550 | 600 | 2024-06-28 |
| 747 | Buttery Scone 747 | 69 69 | 400 | 430 | 2024-06-28 |
| 748 | Country Chicken Pie 748 | 69 69 | 690 | 740 | 2024-06-28 |
| 749 | Deep Dish Beef Pie 749 | 69 69 | 690 | 740 | 2024-06-28 |
| 750 | Spinach & Mushroom Quiche 750 | 69 69 | 690 | 740 | 2024-06-28 |
| 751 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 751 | 69 69 | 390 | 420 | 2024-06-28 |
| 752 | Mixed Nuts 752 | 69 69 | 490 | 540 | 2024-06-28 |
| 753 | Caramel Waffles 753 | 69 69 | 390 | 420 | 2024-06-28 |
| 754 | Chicken Ham & Cheese Panwich 754 | 69 69 | 690 | 740 | 2024-06-28 |
| 755 | Egg Mayo & Cheese Multigrain Croissant 755 | 69 69 | 690 | 740 | 2024-06-28 |
| 756 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 756 | 69 69 | 690 | 740 | 2024-06-28 |
| 757 | Rosemary Chicken & Emmental Cheese Croissant 757 | 69 69 | 690 | 740 | 2024-06-28 |
| 758 | Scrambled Egg & Turkey Ham Pita 758 | 69 69 | 690 | 740 | 2024-06-28 |
| 759 | Turkey Ham & Triple Cheese Toast 759 | 69 69 | 690 | 740 | 2024-06-28 |
| 760 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 760 | 69 69 | 790 | 840 | 2024-06-28 |
| 761 | Ham & Cheese Croissant 761 | 69 69 | 690 | 740 | 2024-06-28 |
| 762 | Sriracha Chicken Whole Wheat Pita 762 | 69 69 | 750 | 800 | 2024-06-28 |
| 763 | Blueberry Acai Yogurt Parfait 763 | 69 69 | 650 | 700 | 2024-06-28 |
| 764 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 764 | 69 69 | 650 | 700 | 2024-06-28 |
| 765 | Caramel Frappuccino® 765 | 69 69 | 720 | 770 | 2024-06-28 |
| 766 | Dark Mocha Frappuccino® 766 | 69 69 | 780 | 830 | 2024-06-28 |
| 767 | Java Chip Frappuccino® 767 | 69 69 | 780 | 830 | 2024-06-28 |
| 768 | Mocha Frappuccino® 768 | 69 69 | 720 | 770 | 2024-06-28 |
| 769 | Caramel Macchiato Frappuccino® 769 | 69 69 | 780 | 830 | 2024-06-28 |
| 770 | Espresso Frappuccino® 770 | 69 69 | 720 | 770 | 2024-06-28 |
| 771 | White Chocolate Mocha Frappuccino® 771 | 69 69 | 720 | 770 | 2024-06-28 |
| 772 | Chocolate Chip Cream Frappuccino® 772 | 69 69 | 780 | 830 | 2024-06-28 |
| 773 | Hojicha Tea Cream Frappuccino® 773 | 69 69 | 760 | 810 | 2024-06-28 |
| 774 | Vanilla Cream Frappuccino® 774 | 69 69 | 720 | 770 | 2024-06-28 |
| 775 | Mango Passion Fruit & Hibiscus 775 | 69 69 | 720 | 770 | 2024-06-28 |
| 776 | Raspberry Black Currant & Oolong 776 | 69 69 | 720 | 770 | 2024-06-28 |
| 777 | Coffee Traveller 777 | 69 69 | 3120 | 3170 | 2024-06-28 |
| 778 | Caffè Americano 778 | 69 69 | 540 | 590 | 2024-06-28 |
| 779 | Cappuccino 779 | 69 69 | 680 | 730 | 2024-06-28 |
| 780 | Caffè Mocha 780 | 69 69 | 750 | 800 | 2024-06-28 |
| 781 | Caramel Macchiato 781 | 69 69 | 760 | 810 | 2024-06-28 |
| 782 | Espresso 782 | 69 69 | 390 | 440 | 2024-06-28 |
| 783 | Caffè Latte 783 | 69 69 | 680 | 730 | 2024-06-28 |
| 784 | Oatmilk Latte 784 | 69 69 | 760 | 810 | 2024-06-28 |
| 785 | Vanilla Latte 785 | 69 69 | 750 | 800 | 2024-06-28 |
| 786 | White Chocolate Mocha 786 | 69 69 | 750 | 800 | 2024-06-28 |
| 787 | Flat White 787 | 69 69 | 760 | 810 | 2024-06-28 |
| 788 | Ristretto Bianco 788 | 69 69 | 760 | 810 | 2024-06-28 |
| 789 | Iced Caffè Americano 789 | 69 69 | 540 | 590 | 2024-06-28 |
| 790 | Iced Cappuccino 790 | 69 69 | 680 | 730 | 2024-06-28 |
| 791 | Iced Caffè Mocha 791 | 69 69 | 750 | 800 | 2024-06-28 |
| 792 | Iced Caramel Macchiato 792 | 69 69 | 760 | 810 | 2024-06-28 |
| 793 | Iced Caffè Latte 793 | 69 69 | 680 | 730 | 2024-06-28 |
| 794 | Iced Oatmilk Latte 794 | 69 69 | 760 | 810 | 2024-06-28 |
| 795 | Iced Vanilla Latte 795 | 69 69 | 750 | 800 | 2024-06-28 |
| 796 | Iced White Chocolate Mocha 796 | 69 69 | 750 | 800 | 2024-06-28 |
| 797 | Signature Hot Chocolate 797 | 69 69 | 720 | 770 | 2024-06-28 |
| 798 | Signature Iced Chocolate 798 | 69 69 | 720 | 770 | 2024-06-28 |
| 799 | Carrot Juice 799 | 69 69 | 490 | 540 | 2024-06-28 |
| 800 | Cloudy Apple Juice 800 | 69 69 | 490 | 540 | 2024-06-28 |
| 801 | Cranberry Red Grapefruit Juice 801 | 69 69 | 490 | 540 | 2024-06-28 |
| 802 | Orange Juice 802 | 69 69 | 490 | 540 | 2024-06-28 |
| 803 | Evian 803 | 69 69 | 350 | 400 | 2024-06-28 |
| 804 | Sparkling Water 804 | 69 69 | 450 | 500 | 2024-06-28 |
| 805 | Chai Tea 805 | 69 69 | 500 | 550 | 2024-06-28 |
| 806 | Earl Grey Tea 806 | 69 69 | 500 | 550 | 2024-06-28 |
| 807 | English Breakfast Tea 807 | 69 69 | 500 | 550 | 2024-06-28 |
| 808 | Emperor’s Clouds & Mist™ Tea 808 | 69 69 | 500 | 550 | 2024-06-28 |
| 809 | Mint Blend Tea 809 | 69 69 | 500 | 550 | 2024-06-28 |
| 810 | Chamomile Tea 810 | 69 69 | 500 | 550 | 2024-06-28 |
| 811 | Pure Matcha Latte 811 | 69 69 | 740 | 790 | 2024-06-28 |
| 812 | Chai Tea Latte 812 | 69 69 | 680 | 730 | 2024-06-28 |
| 813 | Earl Grey Tea Latte 813 | 69 69 | 680 | 730 | 2024-06-28 |
| 814 | English Breakfast Tea Latte 814 | 69 69 | 680 | 730 | 2024-06-28 |
| 815 | Hojicha Tea Latte 815 | 69 69 | 740 | 790 | 2024-06-28 |
| 816 | Zen Clouds Oolong Tea 816 | 69 69 | 500 | 550 | 2024-06-28 |
| 817 | Zen Clouds Oolong with Ruby Grapefruit and Honey 817 | 69 69 | 630 | 680 | 2024-06-28 |
| 818 | Youthberry™ Tea 818 | 69 69 | 500 | 550 | 2024-06-28 |
| 819 | Iced Shaken Black Tea Lemonade 819 | 69 69 | 610 | 660 | 2024-06-28 |
| 820 | Iced Shaken Strawberry Black Tea Lemonade 820 | 69 69 | 630 | 680 | 2024-06-28 |
| 821 | Iced Shaken Hibiscus Tea Lemonade 821 | 69 69 | 610 | 660 | 2024-06-28 |
| 822 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 822 | 69 69 | 730 | 780 | 2024-06-28 |
| 823 | Iced Pure Matcha Latte 823 | 69 69 | 740 | 790 | 2024-06-28 |
| 824 | Iced Chai Tea Latte 824 | 69 69 | 680 | 730 | 2024-06-28 |
| 825 | Iced Black Tea Latte 825 | 69 69 | 680 | 730 | 2024-06-28 |
| 826 | Iced Hojicha Tea Latte 826 | 69 69 | 740 | 790 | 2024-06-28 |
| 827 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 827 | 69 69 | 630 | 680 | 2024-06-28 |
| 828 | Iced Shaken Zen Clouds Oolong Lemonade 828 | 69 69 | 610 | 660 | 2024-06-28 |
| 829 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 829 | 69 69 | 630 | 680 | 2024-06-28 |
| 830 | Origami Pike Place® Roast 830 | 69 69 | 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");