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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 23 · 248 ✖
id ▼ item_id store_id base_price delivery_price effective_date
22900 Bagel 22900 23 23 400 430 2024-06-28
22901 Cookie Crumble Cheesecake 22901 23 23 720 770 2024-06-28
22902 Good Ol' NY Cheesecake 22902 23 23 720 770 2024-06-28
22903 Signature Chocolate Cake 22903 23 23 720 770 2024-06-28
22904 Starbucks® Coffee Tiramisu Cake 22904 23 23 750 800 2024-06-28
22905 Strawberry Shortcake 22905 23 23 720 770 2024-06-28
22906 Chocolate Chunk Monster Cookie 22906 23 23 390 440 2024-06-28
22907 Banana Walnut Muffin 22907 23 23 450 500 2024-06-28
22908 Blueberry Crumble Muffin 22908 23 23 450 500 2024-06-28
22909 Chocolate Crumble Muffin 22909 23 23 450 500 2024-06-28
22910 Pancakes 22910 23 23 550 600 2024-06-28
22911 Almond Croissant 22911 23 23 470 520 2024-06-28
22912 Buttery Croissant 22912 23 23 400 430 2024-06-28
22913 Chocolate Croissant 22913 23 23 440 490 2024-06-28
22914 Creamy Chicken Foldover 22914 23 23 550 600 2024-06-28
22915 Sausage Roll 22915 23 23 550 600 2024-06-28
22916 Buttery Scone 22916 23 23 400 430 2024-06-28
22917 Country Chicken Pie 22917 23 23 690 740 2024-06-28
22918 Deep Dish Beef Pie 22918 23 23 690 740 2024-06-28
22919 Spinach & Mushroom Quiche 22919 23 23 690 740 2024-06-28
22920 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 22920 23 23 390 420 2024-06-28
22921 Mixed Nuts 22921 23 23 490 540 2024-06-28
22922 Caramel Waffles 22922 23 23 390 420 2024-06-28
22923 Chicken Ham & Cheese Panwich 22923 23 23 690 740 2024-06-28
22924 Egg Mayo & Cheese Multigrain Croissant 22924 23 23 690 740 2024-06-28
22925 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 22925 23 23 690 740 2024-06-28
22926 Rosemary Chicken & Emmental Cheese Croissant 22926 23 23 690 740 2024-06-28
22927 Scrambled Egg & Turkey Ham Pita 22927 23 23 690 740 2024-06-28
22928 Turkey Ham & Triple Cheese Toast 22928 23 23 690 740 2024-06-28
22929 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 22929 23 23 790 840 2024-06-28
22930 Ham & Cheese Croissant 22930 23 23 690 740 2024-06-28
22931 Sriracha Chicken Whole Wheat Pita 22931 23 23 750 800 2024-06-28
22932 Blueberry Acai Yogurt Parfait 22932 23 23 650 700 2024-06-28
22933 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 22933 23 23 650 700 2024-06-28
22934 Caramel Frappuccino® 22934 23 23 720 770 2024-06-28
22935 Dark Mocha Frappuccino® 22935 23 23 780 830 2024-06-28
22936 Java Chip Frappuccino® 22936 23 23 780 830 2024-06-28
22937 Mocha Frappuccino® 22937 23 23 720 770 2024-06-28
22938 Caramel Macchiato Frappuccino® 22938 23 23 780 830 2024-06-28
22939 Espresso Frappuccino® 22939 23 23 720 770 2024-06-28
22940 White Chocolate Mocha Frappuccino® 22940 23 23 720 770 2024-06-28
22941 Chocolate Chip Cream Frappuccino® 22941 23 23 780 830 2024-06-28
22942 Hojicha Tea Cream Frappuccino® 22942 23 23 760 810 2024-06-28
22943 Vanilla Cream Frappuccino® 22943 23 23 720 770 2024-06-28
22944 Mango Passion Fruit & Hibiscus 22944 23 23 720 770 2024-06-28
22945 Raspberry Black Currant & Oolong 22945 23 23 720 770 2024-06-28
22946 Coffee Traveller 22946 23 23 3120 3170 2024-06-28
22947 Caffè Americano 22947 23 23 540 590 2024-06-28
22948 Cappuccino 22948 23 23 680 730 2024-06-28
22949 Caffè Mocha 22949 23 23 750 800 2024-06-28
22950 Caramel Macchiato 22950 23 23 760 810 2024-06-28
22951 Espresso 22951 23 23 390 440 2024-06-28
22952 Caffè Latte 22952 23 23 680 730 2024-06-28
22953 Oatmilk Latte 22953 23 23 760 810 2024-06-28
22954 Vanilla Latte 22954 23 23 750 800 2024-06-28
22955 White Chocolate Mocha 22955 23 23 750 800 2024-06-28
22956 Flat White 22956 23 23 760 810 2024-06-28
22957 Ristretto Bianco 22957 23 23 760 810 2024-06-28
22958 Iced Caffè Americano 22958 23 23 540 590 2024-06-28
22959 Iced Cappuccino 22959 23 23 680 730 2024-06-28
22960 Iced Caffè Mocha 22960 23 23 750 800 2024-06-28
22961 Iced Caramel Macchiato 22961 23 23 760 810 2024-06-28
22962 Iced Caffè Latte 22962 23 23 680 730 2024-06-28
22963 Iced Oatmilk Latte 22963 23 23 760 810 2024-06-28
22964 Iced Vanilla Latte 22964 23 23 750 800 2024-06-28
22965 Iced White Chocolate Mocha 22965 23 23 750 800 2024-06-28
22966 Signature Hot Chocolate 22966 23 23 720 770 2024-06-28
22967 Signature Iced Chocolate 22967 23 23 720 770 2024-06-28
22968 Carrot Juice 22968 23 23 490 540 2024-06-28
22969 Cloudy Apple Juice 22969 23 23 490 540 2024-06-28
22970 Cranberry Red Grapefruit Juice 22970 23 23 490 540 2024-06-28
22971 Orange Juice 22971 23 23 490 540 2024-06-28
22972 Evian 22972 23 23 350 400 2024-06-28
22973 Sparkling Water 22973 23 23 450 500 2024-06-28
22974 Chai Tea 22974 23 23 500 550 2024-06-28
22975 Earl Grey Tea 22975 23 23 500 550 2024-06-28
22976 English Breakfast Tea 22976 23 23 500 550 2024-06-28
22977 Emperor’s Clouds & Mist™ Tea 22977 23 23 500 550 2024-06-28
22978 Mint Blend Tea 22978 23 23 500 550 2024-06-28
22979 Chamomile Tea 22979 23 23 500 550 2024-06-28
22980 Pure Matcha Latte 22980 23 23 740 790 2024-06-28
22981 Chai Tea Latte 22981 23 23 680 730 2024-06-28
22982 Earl Grey Tea Latte 22982 23 23 680 730 2024-06-28
22983 English Breakfast Tea Latte 22983 23 23 680 730 2024-06-28
22984 Hojicha Tea Latte 22984 23 23 740 790 2024-06-28
22985 Zen Clouds Oolong Tea 22985 23 23 500 550 2024-06-28
22986 Zen Clouds Oolong with Ruby Grapefruit and Honey 22986 23 23 630 680 2024-06-28
22987 Youthberry™ Tea 22987 23 23 500 550 2024-06-28
22988 Iced Shaken Black Tea Lemonade 22988 23 23 610 660 2024-06-28
22989 Iced Shaken Strawberry Black Tea Lemonade 22989 23 23 630 680 2024-06-28
22990 Iced Shaken Hibiscus Tea Lemonade 22990 23 23 610 660 2024-06-28
22991 Iced Shaken Hibiscus Tea with Pomegranate Pearls 22991 23 23 730 780 2024-06-28
22992 Iced Pure Matcha Latte 22992 23 23 740 790 2024-06-28
22993 Iced Chai Tea Latte 22993 23 23 680 730 2024-06-28
22994 Iced Black Tea Latte 22994 23 23 680 730 2024-06-28
22995 Iced Hojicha Tea Latte 22995 23 23 740 790 2024-06-28
22996 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 22996 23 23 630 680 2024-06-28
22997 Iced Shaken Zen Clouds Oolong Lemonade 22997 23 23 610 660 2024-06-28
22998 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 22998 23 23 630 680 2024-06-28
22999 Origami Pike Place® Roast 22999 23 23 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");