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 = 47

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 47 · 248 ✖
id ▼ item_id store_id base_price delivery_price effective_date
18881 Bagel 18881 47 47 400 430 2024-06-28
18882 Cookie Crumble Cheesecake 18882 47 47 720 770 2024-06-28
18883 Good Ol' NY Cheesecake 18883 47 47 720 770 2024-06-28
18884 Signature Chocolate Cake 18884 47 47 720 770 2024-06-28
18885 Starbucks® Coffee Tiramisu Cake 18885 47 47 750 800 2024-06-28
18886 Strawberry Shortcake 18886 47 47 720 770 2024-06-28
18887 Chocolate Chunk Monster Cookie 18887 47 47 390 440 2024-06-28
18888 Banana Walnut Muffin 18888 47 47 450 500 2024-06-28
18889 Blueberry Crumble Muffin 18889 47 47 450 500 2024-06-28
18890 Chocolate Crumble Muffin 18890 47 47 450 500 2024-06-28
18891 Pancakes 18891 47 47 550 600 2024-06-28
18892 Almond Croissant 18892 47 47 470 520 2024-06-28
18893 Buttery Croissant 18893 47 47 400 430 2024-06-28
18894 Chocolate Croissant 18894 47 47 440 490 2024-06-28
18895 Creamy Chicken Foldover 18895 47 47 550 600 2024-06-28
18896 Sausage Roll 18896 47 47 550 600 2024-06-28
18897 Buttery Scone 18897 47 47 400 430 2024-06-28
18898 Country Chicken Pie 18898 47 47 690 740 2024-06-28
18899 Deep Dish Beef Pie 18899 47 47 690 740 2024-06-28
18900 Spinach & Mushroom Quiche 18900 47 47 690 740 2024-06-28
18901 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 18901 47 47 390 420 2024-06-28
18902 Mixed Nuts 18902 47 47 490 540 2024-06-28
18903 Caramel Waffles 18903 47 47 390 420 2024-06-28
18904 Chicken Ham & Cheese Panwich 18904 47 47 690 740 2024-06-28
18905 Egg Mayo & Cheese Multigrain Croissant 18905 47 47 690 740 2024-06-28
18906 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 18906 47 47 690 740 2024-06-28
18907 Rosemary Chicken & Emmental Cheese Croissant 18907 47 47 690 740 2024-06-28
18908 Scrambled Egg & Turkey Ham Pita 18908 47 47 690 740 2024-06-28
18909 Turkey Ham & Triple Cheese Toast 18909 47 47 690 740 2024-06-28
18910 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 18910 47 47 790 840 2024-06-28
18911 Ham & Cheese Croissant 18911 47 47 690 740 2024-06-28
18912 Sriracha Chicken Whole Wheat Pita 18912 47 47 750 800 2024-06-28
18913 Blueberry Acai Yogurt Parfait 18913 47 47 650 700 2024-06-28
18914 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 18914 47 47 650 700 2024-06-28
18915 Caramel Frappuccino® 18915 47 47 720 770 2024-06-28
18916 Dark Mocha Frappuccino® 18916 47 47 780 830 2024-06-28
18917 Java Chip Frappuccino® 18917 47 47 780 830 2024-06-28
18918 Mocha Frappuccino® 18918 47 47 720 770 2024-06-28
18919 Caramel Macchiato Frappuccino® 18919 47 47 780 830 2024-06-28
18920 Espresso Frappuccino® 18920 47 47 720 770 2024-06-28
18921 White Chocolate Mocha Frappuccino® 18921 47 47 720 770 2024-06-28
18922 Chocolate Chip Cream Frappuccino® 18922 47 47 780 830 2024-06-28
18923 Hojicha Tea Cream Frappuccino® 18923 47 47 760 810 2024-06-28
18924 Vanilla Cream Frappuccino® 18924 47 47 720 770 2024-06-28
18925 Mango Passion Fruit & Hibiscus 18925 47 47 720 770 2024-06-28
18926 Raspberry Black Currant & Oolong 18926 47 47 720 770 2024-06-28
18927 Coffee Traveller 18927 47 47 3120 3170 2024-06-28
18928 Caffè Americano 18928 47 47 540 590 2024-06-28
18929 Cappuccino 18929 47 47 680 730 2024-06-28
18930 Caffè Mocha 18930 47 47 750 800 2024-06-28
18931 Caramel Macchiato 18931 47 47 760 810 2024-06-28
18932 Espresso 18932 47 47 390 440 2024-06-28
18933 Caffè Latte 18933 47 47 680 730 2024-06-28
18934 Oatmilk Latte 18934 47 47 760 810 2024-06-28
18935 Vanilla Latte 18935 47 47 750 800 2024-06-28
18936 White Chocolate Mocha 18936 47 47 750 800 2024-06-28
18937 Flat White 18937 47 47 760 810 2024-06-28
18938 Ristretto Bianco 18938 47 47 760 810 2024-06-28
18939 Iced Caffè Americano 18939 47 47 540 590 2024-06-28
18940 Iced Cappuccino 18940 47 47 680 730 2024-06-28
18941 Iced Caffè Mocha 18941 47 47 750 800 2024-06-28
18942 Iced Caramel Macchiato 18942 47 47 760 810 2024-06-28
18943 Iced Caffè Latte 18943 47 47 680 730 2024-06-28
18944 Iced Oatmilk Latte 18944 47 47 760 810 2024-06-28
18945 Iced Vanilla Latte 18945 47 47 750 800 2024-06-28
18946 Iced White Chocolate Mocha 18946 47 47 750 800 2024-06-28
18947 Signature Hot Chocolate 18947 47 47 720 770 2024-06-28
18948 Signature Iced Chocolate 18948 47 47 720 770 2024-06-28
18949 Carrot Juice 18949 47 47 490 540 2024-06-28
18950 Cloudy Apple Juice 18950 47 47 490 540 2024-06-28
18951 Cranberry Red Grapefruit Juice 18951 47 47 490 540 2024-06-28
18952 Orange Juice 18952 47 47 490 540 2024-06-28
18953 Evian 18953 47 47 350 400 2024-06-28
18954 Sparkling Water 18954 47 47 450 500 2024-06-28
18955 Chai Tea 18955 47 47 500 550 2024-06-28
18956 Earl Grey Tea 18956 47 47 500 550 2024-06-28
18957 English Breakfast Tea 18957 47 47 500 550 2024-06-28
18958 Emperor’s Clouds & Mist™ Tea 18958 47 47 500 550 2024-06-28
18959 Mint Blend Tea 18959 47 47 500 550 2024-06-28
18960 Chamomile Tea 18960 47 47 500 550 2024-06-28
18961 Pure Matcha Latte 18961 47 47 740 790 2024-06-28
18962 Chai Tea Latte 18962 47 47 680 730 2024-06-28
18963 Earl Grey Tea Latte 18963 47 47 680 730 2024-06-28
18964 English Breakfast Tea Latte 18964 47 47 680 730 2024-06-28
18965 Hojicha Tea Latte 18965 47 47 740 790 2024-06-28
18966 Zen Clouds Oolong Tea 18966 47 47 500 550 2024-06-28
18967 Zen Clouds Oolong with Ruby Grapefruit and Honey 18967 47 47 630 680 2024-06-28
18968 Youthberry™ Tea 18968 47 47 500 550 2024-06-28
18969 Iced Shaken Black Tea Lemonade 18969 47 47 610 660 2024-06-28
18970 Iced Shaken Strawberry Black Tea Lemonade 18970 47 47 630 680 2024-06-28
18971 Iced Shaken Hibiscus Tea Lemonade 18971 47 47 610 660 2024-06-28
18972 Iced Shaken Hibiscus Tea with Pomegranate Pearls 18972 47 47 730 780 2024-06-28
18973 Iced Pure Matcha Latte 18973 47 47 740 790 2024-06-28
18974 Iced Chai Tea Latte 18974 47 47 680 730 2024-06-28
18975 Iced Black Tea Latte 18975 47 47 680 730 2024-06-28
18976 Iced Hojicha Tea Latte 18976 47 47 740 790 2024-06-28
18977 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 18977 47 47 630 680 2024-06-28
18978 Iced Shaken Zen Clouds Oolong Lemonade 18978 47 47 610 660 2024-06-28
18979 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 18979 47 47 630 680 2024-06-28
18980 Origami Pike Place® Roast 18980 47 47 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");