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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 39 · 225 ✖
id ▼ item_id store_id base_price delivery_price effective_date
19975 Bagel 19975 39 39 400 430 2024-06-28
19976 Cookie Crumble Cheesecake 19976 39 39 720 770 2024-06-28
19977 Good Ol' NY Cheesecake 19977 39 39 720 770 2024-06-28
19978 Signature Chocolate Cake 19978 39 39 720 770 2024-06-28
19979 Starbucks® Coffee Tiramisu Cake 19979 39 39 750 800 2024-06-28
19980 Strawberry Shortcake 19980 39 39 720 770 2024-06-28
19981 Chocolate Chunk Monster Cookie 19981 39 39 390 440 2024-06-28
19982 Banana Walnut Muffin 19982 39 39 450 500 2024-06-28
19983 Blueberry Crumble Muffin 19983 39 39 450 500 2024-06-28
19984 Chocolate Crumble Muffin 19984 39 39 450 500 2024-06-28
19985 Pancakes 19985 39 39 550 600 2024-06-28
19986 Almond Croissant 19986 39 39 470 520 2024-06-28
19987 Buttery Croissant 19987 39 39 400 430 2024-06-28
19988 Chocolate Croissant 19988 39 39 440 490 2024-06-28
19989 Creamy Chicken Foldover 19989 39 39 550 600 2024-06-28
19990 Sausage Roll 19990 39 39 550 600 2024-06-28
19991 Buttery Scone 19991 39 39 400 430 2024-06-28
19992 Country Chicken Pie 19992 39 39 690 740 2024-06-28
19993 Deep Dish Beef Pie 19993 39 39 690 740 2024-06-28
19994 Spinach & Mushroom Quiche 19994 39 39 690 740 2024-06-28
19995 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 19995 39 39 390 420 2024-06-28
19996 Mixed Nuts 19996 39 39 490 540 2024-06-28
19997 Caramel Waffles 19997 39 39 390 420 2024-06-28
19998 Chicken Ham & Cheese Panwich 19998 39 39 690 740 2024-06-28
19999 Egg Mayo & Cheese Multigrain Croissant 19999 39 39 690 740 2024-06-28
20000 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 20000 39 39 690 740 2024-06-28
20001 Rosemary Chicken & Emmental Cheese Croissant 20001 39 39 690 740 2024-06-28
20002 Scrambled Egg & Turkey Ham Pita 20002 39 39 690 740 2024-06-28
20003 Turkey Ham & Triple Cheese Toast 20003 39 39 690 740 2024-06-28
20004 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 20004 39 39 790 840 2024-06-28
20005 Ham & Cheese Croissant 20005 39 39 690 740 2024-06-28
20006 Sriracha Chicken Whole Wheat Pita 20006 39 39 750 800 2024-06-28
20007 Blueberry Acai Yogurt Parfait 20007 39 39 650 700 2024-06-28
20008 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 20008 39 39 650 700 2024-06-28
20009 Caramel Frappuccino® 20009 39 39 720 770 2024-06-28
20010 Dark Mocha Frappuccino® 20010 39 39 780 830 2024-06-28
20011 Java Chip Frappuccino® 20011 39 39 780 830 2024-06-28
20012 Mocha Frappuccino® 20012 39 39 720 770 2024-06-28
20013 Caramel Macchiato Frappuccino® 20013 39 39 780 830 2024-06-28
20014 Espresso Frappuccino® 20014 39 39 720 770 2024-06-28
20015 White Chocolate Mocha Frappuccino® 20015 39 39 720 770 2024-06-28
20016 Chocolate Chip Cream Frappuccino® 20016 39 39 780 830 2024-06-28
20017 Hojicha Tea Cream Frappuccino® 20017 39 39 760 810 2024-06-28
20018 Vanilla Cream Frappuccino® 20018 39 39 720 770 2024-06-28
20019 Mango Passion Fruit & Hibiscus 20019 39 39 720 770 2024-06-28
20020 Raspberry Black Currant & Oolong 20020 39 39 720 770 2024-06-28
20021 Coffee Traveller 20021 39 39 3120 3170 2024-06-28
20022 Caffè Americano 20022 39 39 540 590 2024-06-28
20023 Cappuccino 20023 39 39 680 730 2024-06-28
20024 Caffè Mocha 20024 39 39 750 800 2024-06-28
20025 Caramel Macchiato 20025 39 39 760 810 2024-06-28
20026 Espresso 20026 39 39 390 440 2024-06-28
20027 Caffè Latte 20027 39 39 680 730 2024-06-28
20028 Oatmilk Latte 20028 39 39 760 810 2024-06-28
20029 Vanilla Latte 20029 39 39 750 800 2024-06-28
20030 White Chocolate Mocha 20030 39 39 750 800 2024-06-28
20031 Flat White 20031 39 39 760 810 2024-06-28
20032 Ristretto Bianco 20032 39 39 760 810 2024-06-28
20033 Iced Caffè Americano 20033 39 39 540 590 2024-06-28
20034 Iced Cappuccino 20034 39 39 680 730 2024-06-28
20035 Iced Caffè Mocha 20035 39 39 750 800 2024-06-28
20036 Iced Caramel Macchiato 20036 39 39 760 810 2024-06-28
20037 Iced Caffè Latte 20037 39 39 680 730 2024-06-28
20038 Iced Oatmilk Latte 20038 39 39 760 810 2024-06-28
20039 Iced Vanilla Latte 20039 39 39 750 800 2024-06-28
20040 Iced White Chocolate Mocha 20040 39 39 750 800 2024-06-28
20041 Signature Hot Chocolate 20041 39 39 720 770 2024-06-28
20042 Signature Iced Chocolate 20042 39 39 720 770 2024-06-28
20043 Carrot Juice 20043 39 39 490 540 2024-06-28
20044 Cloudy Apple Juice 20044 39 39 490 540 2024-06-28
20045 Cranberry Red Grapefruit Juice 20045 39 39 490 540 2024-06-28
20046 Orange Juice 20046 39 39 490 540 2024-06-28
20047 Evian 20047 39 39 350 400 2024-06-28
20048 Sparkling Water 20048 39 39 450 500 2024-06-28
20049 Chai Tea 20049 39 39 500 550 2024-06-28
20050 Earl Grey Tea 20050 39 39 500 550 2024-06-28
20051 English Breakfast Tea 20051 39 39 500 550 2024-06-28
20052 Emperor’s Clouds & Mist™ Tea 20052 39 39 500 550 2024-06-28
20053 Mint Blend Tea 20053 39 39 500 550 2024-06-28
20054 Chamomile Tea 20054 39 39 500 550 2024-06-28
20055 Pure Matcha Latte 20055 39 39 740 790 2024-06-28
20056 Chai Tea Latte 20056 39 39 680 730 2024-06-28
20057 Earl Grey Tea Latte 20057 39 39 680 730 2024-06-28
20058 English Breakfast Tea Latte 20058 39 39 680 730 2024-06-28
20059 Hojicha Tea Latte 20059 39 39 740 790 2024-06-28
20060 Zen Clouds Oolong Tea 20060 39 39 500 550 2024-06-28
20061 Zen Clouds Oolong with Ruby Grapefruit and Honey 20061 39 39 630 680 2024-06-28
20062 Youthberry™ Tea 20062 39 39 500 550 2024-06-28
20063 Iced Shaken Black Tea Lemonade 20063 39 39 610 660 2024-06-28
20064 Iced Shaken Strawberry Black Tea Lemonade 20064 39 39 630 680 2024-06-28
20065 Iced Shaken Hibiscus Tea Lemonade 20065 39 39 610 660 2024-06-28
20066 Iced Shaken Hibiscus Tea with Pomegranate Pearls 20066 39 39 730 780 2024-06-28
20067 Iced Pure Matcha Latte 20067 39 39 740 790 2024-06-28
20068 Iced Chai Tea Latte 20068 39 39 680 730 2024-06-28
20069 Iced Black Tea Latte 20069 39 39 680 730 2024-06-28
20070 Iced Hojicha Tea Latte 20070 39 39 740 790 2024-06-28
20071 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 20071 39 39 630 680 2024-06-28
20072 Iced Shaken Zen Clouds Oolong Lemonade 20072 39 39 610 660 2024-06-28
20073 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 20073 39 39 630 680 2024-06-28
20074 Origami Pike Place® Roast 20074 39 39 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");