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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 53 · 248 ✖
id ▼ item_id store_id base_price delivery_price effective_date
17969 Bagel 17969 53 53 400 430 2024-06-28
17970 Cookie Crumble Cheesecake 17970 53 53 720 770 2024-06-28
17971 Good Ol' NY Cheesecake 17971 53 53 720 770 2024-06-28
17972 Signature Chocolate Cake 17972 53 53 720 770 2024-06-28
17973 Starbucks® Coffee Tiramisu Cake 17973 53 53 750 800 2024-06-28
17974 Strawberry Shortcake 17974 53 53 720 770 2024-06-28
17975 Chocolate Chunk Monster Cookie 17975 53 53 390 440 2024-06-28
17976 Banana Walnut Muffin 17976 53 53 450 500 2024-06-28
17977 Blueberry Crumble Muffin 17977 53 53 450 500 2024-06-28
17978 Chocolate Crumble Muffin 17978 53 53 450 500 2024-06-28
17979 Pancakes 17979 53 53 550 600 2024-06-28
17980 Almond Croissant 17980 53 53 470 520 2024-06-28
17981 Buttery Croissant 17981 53 53 400 430 2024-06-28
17982 Chocolate Croissant 17982 53 53 440 490 2024-06-28
17983 Creamy Chicken Foldover 17983 53 53 550 600 2024-06-28
17984 Sausage Roll 17984 53 53 550 600 2024-06-28
17985 Buttery Scone 17985 53 53 400 430 2024-06-28
17986 Country Chicken Pie 17986 53 53 690 740 2024-06-28
17987 Deep Dish Beef Pie 17987 53 53 690 740 2024-06-28
17988 Spinach & Mushroom Quiche 17988 53 53 690 740 2024-06-28
17989 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 17989 53 53 390 420 2024-06-28
17990 Mixed Nuts 17990 53 53 490 540 2024-06-28
17991 Caramel Waffles 17991 53 53 390 420 2024-06-28
17992 Chicken Ham & Cheese Panwich 17992 53 53 690 740 2024-06-28
17993 Egg Mayo & Cheese Multigrain Croissant 17993 53 53 690 740 2024-06-28
17994 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 17994 53 53 690 740 2024-06-28
17995 Rosemary Chicken & Emmental Cheese Croissant 17995 53 53 690 740 2024-06-28
17996 Scrambled Egg & Turkey Ham Pita 17996 53 53 690 740 2024-06-28
17997 Turkey Ham & Triple Cheese Toast 17997 53 53 690 740 2024-06-28
17998 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 17998 53 53 790 840 2024-06-28
17999 Ham & Cheese Croissant 17999 53 53 690 740 2024-06-28
18000 Sriracha Chicken Whole Wheat Pita 18000 53 53 750 800 2024-06-28
18001 Blueberry Acai Yogurt Parfait 18001 53 53 650 700 2024-06-28
18002 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 18002 53 53 650 700 2024-06-28
18003 Caramel Frappuccino® 18003 53 53 720 770 2024-06-28
18004 Dark Mocha Frappuccino® 18004 53 53 780 830 2024-06-28
18005 Java Chip Frappuccino® 18005 53 53 780 830 2024-06-28
18006 Mocha Frappuccino® 18006 53 53 720 770 2024-06-28
18007 Caramel Macchiato Frappuccino® 18007 53 53 780 830 2024-06-28
18008 Espresso Frappuccino® 18008 53 53 720 770 2024-06-28
18009 White Chocolate Mocha Frappuccino® 18009 53 53 720 770 2024-06-28
18010 Chocolate Chip Cream Frappuccino® 18010 53 53 780 830 2024-06-28
18011 Hojicha Tea Cream Frappuccino® 18011 53 53 760 810 2024-06-28
18012 Vanilla Cream Frappuccino® 18012 53 53 720 770 2024-06-28
18013 Mango Passion Fruit & Hibiscus 18013 53 53 720 770 2024-06-28
18014 Raspberry Black Currant & Oolong 18014 53 53 720 770 2024-06-28
18015 Coffee Traveller 18015 53 53 3120 3170 2024-06-28
18016 Caffè Americano 18016 53 53 540 590 2024-06-28
18017 Cappuccino 18017 53 53 680 730 2024-06-28
18018 Caffè Mocha 18018 53 53 750 800 2024-06-28
18019 Caramel Macchiato 18019 53 53 760 810 2024-06-28
18020 Espresso 18020 53 53 390 440 2024-06-28
18021 Caffè Latte 18021 53 53 680 730 2024-06-28
18022 Oatmilk Latte 18022 53 53 760 810 2024-06-28
18023 Vanilla Latte 18023 53 53 750 800 2024-06-28
18024 White Chocolate Mocha 18024 53 53 750 800 2024-06-28
18025 Flat White 18025 53 53 760 810 2024-06-28
18026 Ristretto Bianco 18026 53 53 760 810 2024-06-28
18027 Iced Caffè Americano 18027 53 53 540 590 2024-06-28
18028 Iced Cappuccino 18028 53 53 680 730 2024-06-28
18029 Iced Caffè Mocha 18029 53 53 750 800 2024-06-28
18030 Iced Caramel Macchiato 18030 53 53 760 810 2024-06-28
18031 Iced Caffè Latte 18031 53 53 680 730 2024-06-28
18032 Iced Oatmilk Latte 18032 53 53 760 810 2024-06-28
18033 Iced Vanilla Latte 18033 53 53 750 800 2024-06-28
18034 Iced White Chocolate Mocha 18034 53 53 750 800 2024-06-28
18035 Signature Hot Chocolate 18035 53 53 720 770 2024-06-28
18036 Signature Iced Chocolate 18036 53 53 720 770 2024-06-28
18037 Carrot Juice 18037 53 53 490 540 2024-06-28
18038 Cloudy Apple Juice 18038 53 53 490 540 2024-06-28
18039 Cranberry Red Grapefruit Juice 18039 53 53 490 540 2024-06-28
18040 Orange Juice 18040 53 53 490 540 2024-06-28
18041 Evian 18041 53 53 350 400 2024-06-28
18042 Sparkling Water 18042 53 53 450 500 2024-06-28
18043 Chai Tea 18043 53 53 500 550 2024-06-28
18044 Earl Grey Tea 18044 53 53 500 550 2024-06-28
18045 English Breakfast Tea 18045 53 53 500 550 2024-06-28
18046 Emperor’s Clouds & Mist™ Tea 18046 53 53 500 550 2024-06-28
18047 Mint Blend Tea 18047 53 53 500 550 2024-06-28
18048 Chamomile Tea 18048 53 53 500 550 2024-06-28
18049 Pure Matcha Latte 18049 53 53 740 790 2024-06-28
18050 Chai Tea Latte 18050 53 53 680 730 2024-06-28
18051 Earl Grey Tea Latte 18051 53 53 680 730 2024-06-28
18052 English Breakfast Tea Latte 18052 53 53 680 730 2024-06-28
18053 Hojicha Tea Latte 18053 53 53 740 790 2024-06-28
18054 Zen Clouds Oolong Tea 18054 53 53 500 550 2024-06-28
18055 Zen Clouds Oolong with Ruby Grapefruit and Honey 18055 53 53 630 680 2024-06-28
18056 Youthberry™ Tea 18056 53 53 500 550 2024-06-28
18057 Iced Shaken Black Tea Lemonade 18057 53 53 610 660 2024-06-28
18058 Iced Shaken Strawberry Black Tea Lemonade 18058 53 53 630 680 2024-06-28
18059 Iced Shaken Hibiscus Tea Lemonade 18059 53 53 610 660 2024-06-28
18060 Iced Shaken Hibiscus Tea with Pomegranate Pearls 18060 53 53 730 780 2024-06-28
18061 Iced Pure Matcha Latte 18061 53 53 740 790 2024-06-28
18062 Iced Chai Tea Latte 18062 53 53 680 730 2024-06-28
18063 Iced Black Tea Latte 18063 53 53 680 730 2024-06-28
18064 Iced Hojicha Tea Latte 18064 53 53 740 790 2024-06-28
18065 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 18065 53 53 630 680 2024-06-28
18066 Iced Shaken Zen Clouds Oolong Lemonade 18066 53 53 610 660 2024-06-28
18067 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 18067 53 53 630 680 2024-06-28
18068 Origami Pike Place® Roast 18068 53 53 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");