item_prices

Pricing information for Starbucks menu items in Singapore

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

225 rows where store_id = 78

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 78 · 225 ✖
id ▼ item_id store_id base_price delivery_price effective_date
13934 Bagel 13934 78 78 400 430 2024-06-28
13935 Cookie Crumble Cheesecake 13935 78 78 720 770 2024-06-28
13936 Good Ol' NY Cheesecake 13936 78 78 720 770 2024-06-28
13937 Signature Chocolate Cake 13937 78 78 720 770 2024-06-28
13938 Starbucks® Coffee Tiramisu Cake 13938 78 78 750 800 2024-06-28
13939 Strawberry Shortcake 13939 78 78 720 770 2024-06-28
13940 Chocolate Chunk Monster Cookie 13940 78 78 390 440 2024-06-28
13941 Banana Walnut Muffin 13941 78 78 450 500 2024-06-28
13942 Blueberry Crumble Muffin 13942 78 78 450 500 2024-06-28
13943 Chocolate Crumble Muffin 13943 78 78 450 500 2024-06-28
13944 Pancakes 13944 78 78 550 600 2024-06-28
13945 Almond Croissant 13945 78 78 470 520 2024-06-28
13946 Buttery Croissant 13946 78 78 400 430 2024-06-28
13947 Chocolate Croissant 13947 78 78 440 490 2024-06-28
13948 Creamy Chicken Foldover 13948 78 78 550 600 2024-06-28
13949 Sausage Roll 13949 78 78 550 600 2024-06-28
13950 Buttery Scone 13950 78 78 400 430 2024-06-28
13951 Country Chicken Pie 13951 78 78 690 740 2024-06-28
13952 Deep Dish Beef Pie 13952 78 78 690 740 2024-06-28
13953 Spinach & Mushroom Quiche 13953 78 78 690 740 2024-06-28
13954 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 13954 78 78 390 420 2024-06-28
13955 Mixed Nuts 13955 78 78 490 540 2024-06-28
13956 Caramel Waffles 13956 78 78 390 420 2024-06-28
13957 Chicken Ham & Cheese Panwich 13957 78 78 690 740 2024-06-28
13958 Egg Mayo & Cheese Multigrain Croissant 13958 78 78 690 740 2024-06-28
13959 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 13959 78 78 690 740 2024-06-28
13960 Rosemary Chicken & Emmental Cheese Croissant 13960 78 78 690 740 2024-06-28
13961 Scrambled Egg & Turkey Ham Pita 13961 78 78 690 740 2024-06-28
13962 Turkey Ham & Triple Cheese Toast 13962 78 78 690 740 2024-06-28
13963 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 13963 78 78 790 840 2024-06-28
13964 Ham & Cheese Croissant 13964 78 78 690 740 2024-06-28
13965 Sriracha Chicken Whole Wheat Pita 13965 78 78 750 800 2024-06-28
13966 Blueberry Acai Yogurt Parfait 13966 78 78 650 700 2024-06-28
13967 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 13967 78 78 650 700 2024-06-28
13968 Caramel Frappuccino® 13968 78 78 720 770 2024-06-28
13969 Dark Mocha Frappuccino® 13969 78 78 780 830 2024-06-28
13970 Java Chip Frappuccino® 13970 78 78 780 830 2024-06-28
13971 Mocha Frappuccino® 13971 78 78 720 770 2024-06-28
13972 Caramel Macchiato Frappuccino® 13972 78 78 780 830 2024-06-28
13973 Espresso Frappuccino® 13973 78 78 720 770 2024-06-28
13974 White Chocolate Mocha Frappuccino® 13974 78 78 720 770 2024-06-28
13975 Chocolate Chip Cream Frappuccino® 13975 78 78 780 830 2024-06-28
13976 Hojicha Tea Cream Frappuccino® 13976 78 78 760 810 2024-06-28
13977 Vanilla Cream Frappuccino® 13977 78 78 720 770 2024-06-28
13978 Mango Passion Fruit & Hibiscus 13978 78 78 720 770 2024-06-28
13979 Raspberry Black Currant & Oolong 13979 78 78 720 770 2024-06-28
13980 Coffee Traveller 13980 78 78 3120 3170 2024-06-28
13981 Caffè Americano 13981 78 78 540 590 2024-06-28
13982 Cappuccino 13982 78 78 680 730 2024-06-28
13983 Caffè Mocha 13983 78 78 750 800 2024-06-28
13984 Caramel Macchiato 13984 78 78 760 810 2024-06-28
13985 Espresso 13985 78 78 390 440 2024-06-28
13986 Caffè Latte 13986 78 78 680 730 2024-06-28
13987 Oatmilk Latte 13987 78 78 760 810 2024-06-28
13988 Vanilla Latte 13988 78 78 750 800 2024-06-28
13989 White Chocolate Mocha 13989 78 78 750 800 2024-06-28
13990 Flat White 13990 78 78 760 810 2024-06-28
13991 Ristretto Bianco 13991 78 78 760 810 2024-06-28
13992 Iced Caffè Americano 13992 78 78 540 590 2024-06-28
13993 Iced Cappuccino 13993 78 78 680 730 2024-06-28
13994 Iced Caffè Mocha 13994 78 78 750 800 2024-06-28
13995 Iced Caramel Macchiato 13995 78 78 760 810 2024-06-28
13996 Iced Caffè Latte 13996 78 78 680 730 2024-06-28
13997 Iced Oatmilk Latte 13997 78 78 760 810 2024-06-28
13998 Iced Vanilla Latte 13998 78 78 750 800 2024-06-28
13999 Iced White Chocolate Mocha 13999 78 78 750 800 2024-06-28
14000 Signature Hot Chocolate 14000 78 78 720 770 2024-06-28
14001 Signature Iced Chocolate 14001 78 78 720 770 2024-06-28
14002 Carrot Juice 14002 78 78 490 540 2024-06-28
14003 Cloudy Apple Juice 14003 78 78 490 540 2024-06-28
14004 Cranberry Red Grapefruit Juice 14004 78 78 490 540 2024-06-28
14005 Orange Juice 14005 78 78 490 540 2024-06-28
14006 Evian 14006 78 78 350 400 2024-06-28
14007 Sparkling Water 14007 78 78 450 500 2024-06-28
14008 Chai Tea 14008 78 78 500 550 2024-06-28
14009 Earl Grey Tea 14009 78 78 500 550 2024-06-28
14010 English Breakfast Tea 14010 78 78 500 550 2024-06-28
14011 Emperor’s Clouds & Mist™ Tea 14011 78 78 500 550 2024-06-28
14012 Mint Blend Tea 14012 78 78 500 550 2024-06-28
14013 Chamomile Tea 14013 78 78 500 550 2024-06-28
14014 Pure Matcha Latte 14014 78 78 740 790 2024-06-28
14015 Chai Tea Latte 14015 78 78 680 730 2024-06-28
14016 Earl Grey Tea Latte 14016 78 78 680 730 2024-06-28
14017 English Breakfast Tea Latte 14017 78 78 680 730 2024-06-28
14018 Hojicha Tea Latte 14018 78 78 740 790 2024-06-28
14019 Zen Clouds Oolong Tea 14019 78 78 500 550 2024-06-28
14020 Zen Clouds Oolong with Ruby Grapefruit and Honey 14020 78 78 630 680 2024-06-28
14021 Youthberry™ Tea 14021 78 78 500 550 2024-06-28
14022 Iced Shaken Black Tea Lemonade 14022 78 78 610 660 2024-06-28
14023 Iced Shaken Strawberry Black Tea Lemonade 14023 78 78 630 680 2024-06-28
14024 Iced Shaken Hibiscus Tea Lemonade 14024 78 78 610 660 2024-06-28
14025 Iced Shaken Hibiscus Tea with Pomegranate Pearls 14025 78 78 730 780 2024-06-28
14026 Iced Pure Matcha Latte 14026 78 78 740 790 2024-06-28
14027 Iced Chai Tea Latte 14027 78 78 680 730 2024-06-28
14028 Iced Black Tea Latte 14028 78 78 680 730 2024-06-28
14029 Iced Hojicha Tea Latte 14029 78 78 740 790 2024-06-28
14030 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 14030 78 78 630 680 2024-06-28
14031 Iced Shaken Zen Clouds Oolong Lemonade 14031 78 78 610 660 2024-06-28
14032 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 14032 78 78 630 680 2024-06-28
14033 Origami Pike Place® Roast 14033 78 78 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");