item_prices

Pricing information for Starbucks menu items in Singapore

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

249 rows where store_id = 139

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 139 · 249 ✖
id ▼ item_id store_id base_price delivery_price effective_date
3884 Bagel 3884 139 139 400 430 2024-06-28
3885 Cookie Crumble Cheesecake 3885 139 139 720 770 2024-06-28
3886 Good Ol' NY Cheesecake 3886 139 139 720 770 2024-06-28
3887 Signature Chocolate Cake 3887 139 139 720 770 2024-06-28
3888 Starbucks® Coffee Tiramisu Cake 3888 139 139 750 800 2024-06-28
3889 Strawberry Shortcake 3889 139 139 720 770 2024-06-28
3890 Chocolate Chunk Monster Cookie 3890 139 139 390 440 2024-06-28
3891 Banana Walnut Muffin 3891 139 139 450 500 2024-06-28
3892 Blueberry Crumble Muffin 3892 139 139 450 500 2024-06-28
3893 Chocolate Crumble Muffin 3893 139 139 450 500 2024-06-28
3894 Pancakes 3894 139 139 550 600 2024-06-28
3895 Almond Croissant 3895 139 139 470 520 2024-06-28
3896 Buttery Croissant 3896 139 139 400 430 2024-06-28
3897 Chocolate Croissant 3897 139 139 440 490 2024-06-28
3898 Creamy Chicken Foldover 3898 139 139 550 600 2024-06-28
3899 Sausage Roll 3899 139 139 550 600 2024-06-28
3900 Buttery Scone 3900 139 139 400 430 2024-06-28
3901 Country Chicken Pie 3901 139 139 690 740 2024-06-28
3902 Deep Dish Beef Pie 3902 139 139 690 740 2024-06-28
3903 Spinach & Mushroom Quiche 3903 139 139 690 740 2024-06-28
3904 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 3904 139 139 390 420 2024-06-28
3905 Mixed Nuts 3905 139 139 490 540 2024-06-28
3906 Caramel Waffles 3906 139 139 390 420 2024-06-28
3907 Chicken Ham & Cheese Panwich 3907 139 139 690 740 2024-06-28
3908 Egg Mayo & Cheese Multigrain Croissant 3908 139 139 690 740 2024-06-28
3909 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 3909 139 139 690 740 2024-06-28
3910 Rosemary Chicken & Emmental Cheese Croissant 3910 139 139 690 740 2024-06-28
3911 Scrambled Egg & Turkey Ham Pita 3911 139 139 690 740 2024-06-28
3912 Turkey Ham & Triple Cheese Toast 3912 139 139 690 740 2024-06-28
3913 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 3913 139 139 790 840 2024-06-28
3914 Ham & Cheese Croissant 3914 139 139 690 740 2024-06-28
3915 Sriracha Chicken Whole Wheat Pita 3915 139 139 750 800 2024-06-28
3916 Blueberry Acai Yogurt Parfait 3916 139 139 650 700 2024-06-28
3917 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 3917 139 139 650 700 2024-06-28
3918 Caramel Frappuccino® 3918 139 139 720 770 2024-06-28
3919 Dark Mocha Frappuccino® 3919 139 139 780 830 2024-06-28
3920 Java Chip Frappuccino® 3920 139 139 780 830 2024-06-28
3921 Mocha Frappuccino® 3921 139 139 720 770 2024-06-28
3922 Caramel Macchiato Frappuccino® 3922 139 139 780 830 2024-06-28
3923 Espresso Frappuccino® 3923 139 139 720 770 2024-06-28
3924 White Chocolate Mocha Frappuccino® 3924 139 139 720 770 2024-06-28
3925 Chocolate Chip Cream Frappuccino® 3925 139 139 780 830 2024-06-28
3926 Hojicha Tea Cream Frappuccino® 3926 139 139 760 810 2024-06-28
3927 Vanilla Cream Frappuccino® 3927 139 139 720 770 2024-06-28
3928 Mango Passion Fruit & Hibiscus 3928 139 139 720 770 2024-06-28
3929 Raspberry Black Currant & Oolong 3929 139 139 720 770 2024-06-28
3930 Coffee Traveller 3930 139 139 3120 3170 2024-06-28
3931 Caffè Americano 3931 139 139 540 590 2024-06-28
3932 Cappuccino 3932 139 139 680 730 2024-06-28
3933 Caffè Mocha 3933 139 139 750 800 2024-06-28
3934 Caramel Macchiato 3934 139 139 760 810 2024-06-28
3935 Espresso 3935 139 139 390 440 2024-06-28
3936 Caffè Latte 3936 139 139 680 730 2024-06-28
3937 Oatmilk Latte 3937 139 139 760 810 2024-06-28
3938 Vanilla Latte 3938 139 139 750 800 2024-06-28
3939 White Chocolate Mocha 3939 139 139 750 800 2024-06-28
3940 Flat White 3940 139 139 760 810 2024-06-28
3941 Ristretto Bianco 3941 139 139 760 810 2024-06-28
3942 Iced Caffè Americano 3942 139 139 540 590 2024-06-28
3943 Iced Cappuccino 3943 139 139 680 730 2024-06-28
3944 Iced Caffè Mocha 3944 139 139 750 800 2024-06-28
3945 Iced Caramel Macchiato 3945 139 139 760 810 2024-06-28
3946 Iced Caffè Latte 3946 139 139 680 730 2024-06-28
3947 Iced Oatmilk Latte 3947 139 139 760 810 2024-06-28
3948 Iced Vanilla Latte 3948 139 139 750 800 2024-06-28
3949 Iced White Chocolate Mocha 3949 139 139 750 800 2024-06-28
3950 Signature Hot Chocolate 3950 139 139 720 770 2024-06-28
3951 Signature Iced Chocolate 3951 139 139 720 770 2024-06-28
3952 Carrot Juice 3952 139 139 490 540 2024-06-28
3953 Cloudy Apple Juice 3953 139 139 490 540 2024-06-28
3954 Cranberry Red Grapefruit Juice 3954 139 139 490 540 2024-06-28
3955 Orange Juice 3955 139 139 490 540 2024-06-28
3956 Evian 3956 139 139 350 400 2024-06-28
3957 Sparkling Water 3957 139 139 450 500 2024-06-28
3958 Chai Tea 3958 139 139 500 550 2024-06-28
3959 Earl Grey Tea 3959 139 139 500 550 2024-06-28
3960 English Breakfast Tea 3960 139 139 500 550 2024-06-28
3961 Emperor’s Clouds & Mist™ Tea 3961 139 139 500 550 2024-06-28
3962 Mint Blend Tea 3962 139 139 500 550 2024-06-28
3963 Chamomile Tea 3963 139 139 500 550 2024-06-28
3964 Pure Matcha Latte 3964 139 139 740 790 2024-06-28
3965 Chai Tea Latte 3965 139 139 680 730 2024-06-28
3966 Earl Grey Tea Latte 3966 139 139 680 730 2024-06-28
3967 English Breakfast Tea Latte 3967 139 139 680 730 2024-06-28
3968 Hojicha Tea Latte 3968 139 139 740 790 2024-06-28
3969 Zen Clouds Oolong Tea 3969 139 139 500 550 2024-06-28
3970 Zen Clouds Oolong with Ruby Grapefruit and Honey 3970 139 139 630 680 2024-06-28
3971 Youthberry™ Tea 3971 139 139 500 550 2024-06-28
3972 Iced Shaken Black Tea Lemonade 3972 139 139 610 660 2024-06-28
3973 Iced Shaken Strawberry Black Tea Lemonade 3973 139 139 630 680 2024-06-28
3974 Iced Shaken Hibiscus Tea Lemonade 3974 139 139 610 660 2024-06-28
3975 Iced Shaken Hibiscus Tea with Pomegranate Pearls 3975 139 139 730 780 2024-06-28
3976 Iced Pure Matcha Latte 3976 139 139 740 790 2024-06-28
3977 Iced Chai Tea Latte 3977 139 139 680 730 2024-06-28
3978 Iced Black Tea Latte 3978 139 139 680 730 2024-06-28
3979 Iced Hojicha Tea Latte 3979 139 139 740 790 2024-06-28
3980 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 3980 139 139 630 680 2024-06-28
3981 Iced Shaken Zen Clouds Oolong Lemonade 3981 139 139 610 660 2024-06-28
3982 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 3982 139 139 630 680 2024-06-28
3983 Origami Pike Place® Roast 3983 139 139 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");