item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
204 rows where effective_date = "2024-06-28" and store_id = 69
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
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");