item_prices

Pricing information for Starbucks menu items in Singapore

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

234 rows where store_id = 34

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 34 · 234 ✖
id ▼ item_id store_id base_price delivery_price effective_date
20887 Bagel 20887 34 34 400 430 2024-06-28
20888 Cookie Crumble Cheesecake 20888 34 34 720 770 2024-06-28
20889 Good Ol' NY Cheesecake 20889 34 34 720 770 2024-06-28
20890 Signature Chocolate Cake 20890 34 34 720 770 2024-06-28
20891 Starbucks® Coffee Tiramisu Cake 20891 34 34 750 800 2024-06-28
20892 Strawberry Shortcake 20892 34 34 720 770 2024-06-28
20893 Chocolate Chunk Monster Cookie 20893 34 34 390 440 2024-06-28
20894 Banana Walnut Muffin 20894 34 34 450 500 2024-06-28
20895 Blueberry Crumble Muffin 20895 34 34 450 500 2024-06-28
20896 Chocolate Crumble Muffin 20896 34 34 450 500 2024-06-28
20897 Pancakes 20897 34 34 550 600 2024-06-28
20898 Almond Croissant 20898 34 34 470 520 2024-06-28
20899 Buttery Croissant 20899 34 34 400 430 2024-06-28
20900 Chocolate Croissant 20900 34 34 440 490 2024-06-28
20901 Creamy Chicken Foldover 20901 34 34 550 600 2024-06-28
20902 Sausage Roll 20902 34 34 550 600 2024-06-28
20903 Buttery Scone 20903 34 34 400 430 2024-06-28
20904 Country Chicken Pie 20904 34 34 690 740 2024-06-28
20905 Deep Dish Beef Pie 20905 34 34 690 740 2024-06-28
20906 Spinach & Mushroom Quiche 20906 34 34 690 740 2024-06-28
20907 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 20907 34 34 390 420 2024-06-28
20908 Mixed Nuts 20908 34 34 490 540 2024-06-28
20909 Caramel Waffles 20909 34 34 390 420 2024-06-28
20910 Chicken Ham & Cheese Panwich 20910 34 34 690 740 2024-06-28
20911 Egg Mayo & Cheese Multigrain Croissant 20911 34 34 690 740 2024-06-28
20912 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 20912 34 34 690 740 2024-06-28
20913 Rosemary Chicken & Emmental Cheese Croissant 20913 34 34 690 740 2024-06-28
20914 Scrambled Egg & Turkey Ham Pita 20914 34 34 690 740 2024-06-28
20915 Turkey Ham & Triple Cheese Toast 20915 34 34 690 740 2024-06-28
20916 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 20916 34 34 790 840 2024-06-28
20917 Ham & Cheese Croissant 20917 34 34 690 740 2024-06-28
20918 Sriracha Chicken Whole Wheat Pita 20918 34 34 750 800 2024-06-28
20919 Blueberry Acai Yogurt Parfait 20919 34 34 650 700 2024-06-28
20920 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 20920 34 34 650 700 2024-06-28
20921 Caramel Frappuccino® 20921 34 34 720 770 2024-06-28
20922 Dark Mocha Frappuccino® 20922 34 34 780 830 2024-06-28
20923 Java Chip Frappuccino® 20923 34 34 780 830 2024-06-28
20924 Mocha Frappuccino® 20924 34 34 720 770 2024-06-28
20925 Caramel Macchiato Frappuccino® 20925 34 34 780 830 2024-06-28
20926 Espresso Frappuccino® 20926 34 34 720 770 2024-06-28
20927 White Chocolate Mocha Frappuccino® 20927 34 34 720 770 2024-06-28
20928 Chocolate Chip Cream Frappuccino® 20928 34 34 780 830 2024-06-28
20929 Hojicha Tea Cream Frappuccino® 20929 34 34 760 810 2024-06-28
20930 Vanilla Cream Frappuccino® 20930 34 34 720 770 2024-06-28
20931 Mango Passion Fruit & Hibiscus 20931 34 34 720 770 2024-06-28
20932 Raspberry Black Currant & Oolong 20932 34 34 720 770 2024-06-28
20933 Coffee Traveller 20933 34 34 3120 3170 2024-06-28
20934 Caffè Americano 20934 34 34 540 590 2024-06-28
20935 Cappuccino 20935 34 34 680 730 2024-06-28
20936 Caffè Mocha 20936 34 34 750 800 2024-06-28
20937 Caramel Macchiato 20937 34 34 760 810 2024-06-28
20938 Espresso 20938 34 34 390 440 2024-06-28
20939 Caffè Latte 20939 34 34 680 730 2024-06-28
20940 Oatmilk Latte 20940 34 34 760 810 2024-06-28
20941 Vanilla Latte 20941 34 34 750 800 2024-06-28
20942 White Chocolate Mocha 20942 34 34 750 800 2024-06-28
20943 Flat White 20943 34 34 760 810 2024-06-28
20944 Ristretto Bianco 20944 34 34 760 810 2024-06-28
20945 Iced Caffè Americano 20945 34 34 540 590 2024-06-28
20946 Iced Cappuccino 20946 34 34 680 730 2024-06-28
20947 Iced Caffè Mocha 20947 34 34 750 800 2024-06-28
20948 Iced Caramel Macchiato 20948 34 34 760 810 2024-06-28
20949 Iced Caffè Latte 20949 34 34 680 730 2024-06-28
20950 Iced Oatmilk Latte 20950 34 34 760 810 2024-06-28
20951 Iced Vanilla Latte 20951 34 34 750 800 2024-06-28
20952 Iced White Chocolate Mocha 20952 34 34 750 800 2024-06-28
20953 Signature Hot Chocolate 20953 34 34 720 770 2024-06-28
20954 Signature Iced Chocolate 20954 34 34 720 770 2024-06-28
20955 Carrot Juice 20955 34 34 490 540 2024-06-28
20956 Cloudy Apple Juice 20956 34 34 490 540 2024-06-28
20957 Cranberry Red Grapefruit Juice 20957 34 34 490 540 2024-06-28
20958 Orange Juice 20958 34 34 490 540 2024-06-28
20959 Evian 20959 34 34 350 400 2024-06-28
20960 Sparkling Water 20960 34 34 450 500 2024-06-28
20961 Chai Tea 20961 34 34 500 550 2024-06-28
20962 Earl Grey Tea 20962 34 34 500 550 2024-06-28
20963 English Breakfast Tea 20963 34 34 500 550 2024-06-28
20964 Emperor’s Clouds & Mist™ Tea 20964 34 34 500 550 2024-06-28
20965 Mint Blend Tea 20965 34 34 500 550 2024-06-28
20966 Chamomile Tea 20966 34 34 500 550 2024-06-28
20967 Pure Matcha Latte 20967 34 34 740 790 2024-06-28
20968 Chai Tea Latte 20968 34 34 680 730 2024-06-28
20969 Earl Grey Tea Latte 20969 34 34 680 730 2024-06-28
20970 English Breakfast Tea Latte 20970 34 34 680 730 2024-06-28
20971 Hojicha Tea Latte 20971 34 34 740 790 2024-06-28
20972 Zen Clouds Oolong Tea 20972 34 34 500 550 2024-06-28
20973 Zen Clouds Oolong with Ruby Grapefruit and Honey 20973 34 34 630 680 2024-06-28
20974 Youthberry™ Tea 20974 34 34 500 550 2024-06-28
20975 Iced Shaken Black Tea Lemonade 20975 34 34 610 660 2024-06-28
20976 Iced Shaken Strawberry Black Tea Lemonade 20976 34 34 630 680 2024-06-28
20977 Iced Shaken Hibiscus Tea Lemonade 20977 34 34 610 660 2024-06-28
20978 Iced Shaken Hibiscus Tea with Pomegranate Pearls 20978 34 34 730 780 2024-06-28
20979 Iced Pure Matcha Latte 20979 34 34 740 790 2024-06-28
20980 Iced Chai Tea Latte 20980 34 34 680 730 2024-06-28
20981 Iced Black Tea Latte 20981 34 34 680 730 2024-06-28
20982 Iced Hojicha Tea Latte 20982 34 34 740 790 2024-06-28
20983 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 20983 34 34 630 680 2024-06-28
20984 Iced Shaken Zen Clouds Oolong Lemonade 20984 34 34 610 660 2024-06-28
20985 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 20985 34 34 630 680 2024-06-28
20986 Origami Pike Place® Roast 20986 34 34 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");