item_prices

Pricing information for Starbucks menu items in Singapore

Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com

248 rows where store_id = 146

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 146 · 248 ✖
id ▼ item_id store_id base_price delivery_price effective_date
2779 Bagel 2779 146 146 400 430 2024-06-28
2780 Cookie Crumble Cheesecake 2780 146 146 720 770 2024-06-28
2781 Good Ol' NY Cheesecake 2781 146 146 720 770 2024-06-28
2782 Signature Chocolate Cake 2782 146 146 720 770 2024-06-28
2783 Starbucks® Coffee Tiramisu Cake 2783 146 146 750 800 2024-06-28
2784 Strawberry Shortcake 2784 146 146 720 770 2024-06-28
2785 Chocolate Chunk Monster Cookie 2785 146 146 390 440 2024-06-28
2786 Banana Walnut Muffin 2786 146 146 450 500 2024-06-28
2787 Blueberry Crumble Muffin 2787 146 146 450 500 2024-06-28
2788 Chocolate Crumble Muffin 2788 146 146 450 500 2024-06-28
2789 Pancakes 2789 146 146 550 600 2024-06-28
2790 Almond Croissant 2790 146 146 470 520 2024-06-28
2791 Buttery Croissant 2791 146 146 400 430 2024-06-28
2792 Chocolate Croissant 2792 146 146 440 490 2024-06-28
2793 Creamy Chicken Foldover 2793 146 146 550 600 2024-06-28
2794 Sausage Roll 2794 146 146 550 600 2024-06-28
2795 Buttery Scone 2795 146 146 400 430 2024-06-28
2796 Country Chicken Pie 2796 146 146 690 740 2024-06-28
2797 Deep Dish Beef Pie 2797 146 146 690 740 2024-06-28
2798 Spinach & Mushroom Quiche 2798 146 146 690 740 2024-06-28
2799 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 2799 146 146 390 420 2024-06-28
2800 Mixed Nuts 2800 146 146 490 540 2024-06-28
2801 Caramel Waffles 2801 146 146 390 420 2024-06-28
2802 Chicken Ham & Cheese Panwich 2802 146 146 690 740 2024-06-28
2803 Egg Mayo & Cheese Multigrain Croissant 2803 146 146 690 740 2024-06-28
2804 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 2804 146 146 690 740 2024-06-28
2805 Rosemary Chicken & Emmental Cheese Croissant 2805 146 146 690 740 2024-06-28
2806 Scrambled Egg & Turkey Ham Pita 2806 146 146 690 740 2024-06-28
2807 Turkey Ham & Triple Cheese Toast 2807 146 146 690 740 2024-06-28
2808 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 2808 146 146 790 840 2024-06-28
2809 Ham & Cheese Croissant 2809 146 146 690 740 2024-06-28
2810 Sriracha Chicken Whole Wheat Pita 2810 146 146 750 800 2024-06-28
2811 Blueberry Acai Yogurt Parfait 2811 146 146 650 700 2024-06-28
2812 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 2812 146 146 650 700 2024-06-28
2813 Caramel Frappuccino® 2813 146 146 720 770 2024-06-28
2814 Dark Mocha Frappuccino® 2814 146 146 780 830 2024-06-28
2815 Java Chip Frappuccino® 2815 146 146 780 830 2024-06-28
2816 Mocha Frappuccino® 2816 146 146 720 770 2024-06-28
2817 Caramel Macchiato Frappuccino® 2817 146 146 780 830 2024-06-28
2818 Espresso Frappuccino® 2818 146 146 720 770 2024-06-28
2819 White Chocolate Mocha Frappuccino® 2819 146 146 720 770 2024-06-28
2820 Chocolate Chip Cream Frappuccino® 2820 146 146 780 830 2024-06-28
2821 Hojicha Tea Cream Frappuccino® 2821 146 146 760 810 2024-06-28
2822 Vanilla Cream Frappuccino® 2822 146 146 720 770 2024-06-28
2823 Mango Passion Fruit & Hibiscus 2823 146 146 720 770 2024-06-28
2824 Raspberry Black Currant & Oolong 2824 146 146 720 770 2024-06-28
2825 Coffee Traveller 2825 146 146 3120 3170 2024-06-28
2826 Caffè Americano 2826 146 146 540 590 2024-06-28
2827 Cappuccino 2827 146 146 680 730 2024-06-28
2828 Caffè Mocha 2828 146 146 750 800 2024-06-28
2829 Caramel Macchiato 2829 146 146 760 810 2024-06-28
2830 Espresso 2830 146 146 390 440 2024-06-28
2831 Caffè Latte 2831 146 146 680 730 2024-06-28
2832 Oatmilk Latte 2832 146 146 760 810 2024-06-28
2833 Vanilla Latte 2833 146 146 750 800 2024-06-28
2834 White Chocolate Mocha 2834 146 146 750 800 2024-06-28
2835 Flat White 2835 146 146 760 810 2024-06-28
2836 Ristretto Bianco 2836 146 146 760 810 2024-06-28
2837 Iced Caffè Americano 2837 146 146 540 590 2024-06-28
2838 Iced Cappuccino 2838 146 146 680 730 2024-06-28
2839 Iced Caffè Mocha 2839 146 146 750 800 2024-06-28
2840 Iced Caramel Macchiato 2840 146 146 760 810 2024-06-28
2841 Iced Caffè Latte 2841 146 146 680 730 2024-06-28
2842 Iced Oatmilk Latte 2842 146 146 760 810 2024-06-28
2843 Iced Vanilla Latte 2843 146 146 750 800 2024-06-28
2844 Iced White Chocolate Mocha 2844 146 146 750 800 2024-06-28
2845 Signature Hot Chocolate 2845 146 146 720 770 2024-06-28
2846 Signature Iced Chocolate 2846 146 146 720 770 2024-06-28
2847 Carrot Juice 2847 146 146 490 540 2024-06-28
2848 Cloudy Apple Juice 2848 146 146 490 540 2024-06-28
2849 Cranberry Red Grapefruit Juice 2849 146 146 490 540 2024-06-28
2850 Orange Juice 2850 146 146 490 540 2024-06-28
2851 Evian 2851 146 146 350 400 2024-06-28
2852 Sparkling Water 2852 146 146 450 500 2024-06-28
2853 Chai Tea 2853 146 146 500 550 2024-06-28
2854 Earl Grey Tea 2854 146 146 500 550 2024-06-28
2855 English Breakfast Tea 2855 146 146 500 550 2024-06-28
2856 Emperor’s Clouds & Mist™ Tea 2856 146 146 500 550 2024-06-28
2857 Mint Blend Tea 2857 146 146 500 550 2024-06-28
2858 Chamomile Tea 2858 146 146 500 550 2024-06-28
2859 Pure Matcha Latte 2859 146 146 740 790 2024-06-28
2860 Chai Tea Latte 2860 146 146 680 730 2024-06-28
2861 Earl Grey Tea Latte 2861 146 146 680 730 2024-06-28
2862 English Breakfast Tea Latte 2862 146 146 680 730 2024-06-28
2863 Hojicha Tea Latte 2863 146 146 740 790 2024-06-28
2864 Zen Clouds Oolong Tea 2864 146 146 500 550 2024-06-28
2865 Zen Clouds Oolong with Ruby Grapefruit and Honey 2865 146 146 630 680 2024-06-28
2866 Youthberry™ Tea 2866 146 146 500 550 2024-06-28
2867 Iced Shaken Black Tea Lemonade 2867 146 146 610 660 2024-06-28
2868 Iced Shaken Strawberry Black Tea Lemonade 2868 146 146 630 680 2024-06-28
2869 Iced Shaken Hibiscus Tea Lemonade 2869 146 146 610 660 2024-06-28
2870 Iced Shaken Hibiscus Tea with Pomegranate Pearls 2870 146 146 730 780 2024-06-28
2871 Iced Pure Matcha Latte 2871 146 146 740 790 2024-06-28
2872 Iced Chai Tea Latte 2872 146 146 680 730 2024-06-28
2873 Iced Black Tea Latte 2873 146 146 680 730 2024-06-28
2874 Iced Hojicha Tea Latte 2874 146 146 740 790 2024-06-28
2875 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 2875 146 146 630 680 2024-06-28
2876 Iced Shaken Zen Clouds Oolong Lemonade 2876 146 146 610 660 2024-06-28
2877 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 2877 146 146 630 680 2024-06-28
2878 Origami Pike Place® Roast 2878 146 146 990 1040 2024-06-28

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");