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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 119 · 234 ✖
id ▼ item_id store_id base_price delivery_price effective_date
6982 Bagel 6982 119 119 400 430 2024-06-28
6983 Cookie Crumble Cheesecake 6983 119 119 720 770 2024-06-28
6984 Good Ol' NY Cheesecake 6984 119 119 720 770 2024-06-28
6985 Signature Chocolate Cake 6985 119 119 720 770 2024-06-28
6986 Starbucks® Coffee Tiramisu Cake 6986 119 119 750 800 2024-06-28
6987 Strawberry Shortcake 6987 119 119 720 770 2024-06-28
6988 Chocolate Chunk Monster Cookie 6988 119 119 390 440 2024-06-28
6989 Banana Walnut Muffin 6989 119 119 450 500 2024-06-28
6990 Blueberry Crumble Muffin 6990 119 119 450 500 2024-06-28
6991 Chocolate Crumble Muffin 6991 119 119 450 500 2024-06-28
6992 Pancakes 6992 119 119 550 600 2024-06-28
6993 Almond Croissant 6993 119 119 470 520 2024-06-28
6994 Buttery Croissant 6994 119 119 400 430 2024-06-28
6995 Chocolate Croissant 6995 119 119 440 490 2024-06-28
6996 Creamy Chicken Foldover 6996 119 119 550 600 2024-06-28
6997 Sausage Roll 6997 119 119 550 600 2024-06-28
6998 Buttery Scone 6998 119 119 400 430 2024-06-28
6999 Country Chicken Pie 6999 119 119 690 740 2024-06-28
7000 Deep Dish Beef Pie 7000 119 119 690 740 2024-06-28
7001 Spinach & Mushroom Quiche 7001 119 119 690 740 2024-06-28
7002 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 7002 119 119 390 420 2024-06-28
7003 Mixed Nuts 7003 119 119 490 540 2024-06-28
7004 Caramel Waffles 7004 119 119 390 420 2024-06-28
7005 Chicken Ham & Cheese Panwich 7005 119 119 690 740 2024-06-28
7006 Egg Mayo & Cheese Multigrain Croissant 7006 119 119 690 740 2024-06-28
7007 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 7007 119 119 690 740 2024-06-28
7008 Rosemary Chicken & Emmental Cheese Croissant 7008 119 119 690 740 2024-06-28
7009 Scrambled Egg & Turkey Ham Pita 7009 119 119 690 740 2024-06-28
7010 Turkey Ham & Triple Cheese Toast 7010 119 119 690 740 2024-06-28
7011 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 7011 119 119 790 840 2024-06-28
7012 Ham & Cheese Croissant 7012 119 119 690 740 2024-06-28
7013 Sriracha Chicken Whole Wheat Pita 7013 119 119 750 800 2024-06-28
7014 Blueberry Acai Yogurt Parfait 7014 119 119 650 700 2024-06-28
7015 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 7015 119 119 650 700 2024-06-28
7016 Caramel Frappuccino® 7016 119 119 720 770 2024-06-28
7017 Dark Mocha Frappuccino® 7017 119 119 780 830 2024-06-28
7018 Java Chip Frappuccino® 7018 119 119 780 830 2024-06-28
7019 Mocha Frappuccino® 7019 119 119 720 770 2024-06-28
7020 Caramel Macchiato Frappuccino® 7020 119 119 780 830 2024-06-28
7021 Espresso Frappuccino® 7021 119 119 720 770 2024-06-28
7022 White Chocolate Mocha Frappuccino® 7022 119 119 720 770 2024-06-28
7023 Chocolate Chip Cream Frappuccino® 7023 119 119 780 830 2024-06-28
7024 Hojicha Tea Cream Frappuccino® 7024 119 119 760 810 2024-06-28
7025 Vanilla Cream Frappuccino® 7025 119 119 720 770 2024-06-28
7026 Mango Passion Fruit & Hibiscus 7026 119 119 720 770 2024-06-28
7027 Raspberry Black Currant & Oolong 7027 119 119 720 770 2024-06-28
7028 Coffee Traveller 7028 119 119 3120 3170 2024-06-28
7029 Caffè Americano 7029 119 119 540 590 2024-06-28
7030 Cappuccino 7030 119 119 680 730 2024-06-28
7031 Caffè Mocha 7031 119 119 750 800 2024-06-28
7032 Caramel Macchiato 7032 119 119 760 810 2024-06-28
7033 Espresso 7033 119 119 390 440 2024-06-28
7034 Caffè Latte 7034 119 119 680 730 2024-06-28
7035 Oatmilk Latte 7035 119 119 760 810 2024-06-28
7036 Vanilla Latte 7036 119 119 750 800 2024-06-28
7037 White Chocolate Mocha 7037 119 119 750 800 2024-06-28
7038 Flat White 7038 119 119 760 810 2024-06-28
7039 Ristretto Bianco 7039 119 119 760 810 2024-06-28
7040 Iced Caffè Americano 7040 119 119 540 590 2024-06-28
7041 Iced Cappuccino 7041 119 119 680 730 2024-06-28
7042 Iced Caffè Mocha 7042 119 119 750 800 2024-06-28
7043 Iced Caramel Macchiato 7043 119 119 760 810 2024-06-28
7044 Iced Caffè Latte 7044 119 119 680 730 2024-06-28
7045 Iced Oatmilk Latte 7045 119 119 760 810 2024-06-28
7046 Iced Vanilla Latte 7046 119 119 750 800 2024-06-28
7047 Iced White Chocolate Mocha 7047 119 119 750 800 2024-06-28
7048 Signature Hot Chocolate 7048 119 119 720 770 2024-06-28
7049 Signature Iced Chocolate 7049 119 119 720 770 2024-06-28
7050 Carrot Juice 7050 119 119 490 540 2024-06-28
7051 Cloudy Apple Juice 7051 119 119 490 540 2024-06-28
7052 Cranberry Red Grapefruit Juice 7052 119 119 490 540 2024-06-28
7053 Orange Juice 7053 119 119 490 540 2024-06-28
7054 Evian 7054 119 119 350 400 2024-06-28
7055 Sparkling Water 7055 119 119 450 500 2024-06-28
7056 Chai Tea 7056 119 119 500 550 2024-06-28
7057 Earl Grey Tea 7057 119 119 500 550 2024-06-28
7058 English Breakfast Tea 7058 119 119 500 550 2024-06-28
7059 Emperor’s Clouds & Mist™ Tea 7059 119 119 500 550 2024-06-28
7060 Mint Blend Tea 7060 119 119 500 550 2024-06-28
7061 Chamomile Tea 7061 119 119 500 550 2024-06-28
7062 Pure Matcha Latte 7062 119 119 740 790 2024-06-28
7063 Chai Tea Latte 7063 119 119 680 730 2024-06-28
7064 Earl Grey Tea Latte 7064 119 119 680 730 2024-06-28
7065 English Breakfast Tea Latte 7065 119 119 680 730 2024-06-28
7066 Hojicha Tea Latte 7066 119 119 740 790 2024-06-28
7067 Zen Clouds Oolong Tea 7067 119 119 500 550 2024-06-28
7068 Zen Clouds Oolong with Ruby Grapefruit and Honey 7068 119 119 630 680 2024-06-28
7069 Youthberry™ Tea 7069 119 119 500 550 2024-06-28
7070 Iced Shaken Black Tea Lemonade 7070 119 119 610 660 2024-06-28
7071 Iced Shaken Strawberry Black Tea Lemonade 7071 119 119 630 680 2024-06-28
7072 Iced Shaken Hibiscus Tea Lemonade 7072 119 119 610 660 2024-06-28
7073 Iced Shaken Hibiscus Tea with Pomegranate Pearls 7073 119 119 730 780 2024-06-28
7074 Iced Pure Matcha Latte 7074 119 119 740 790 2024-06-28
7075 Iced Chai Tea Latte 7075 119 119 680 730 2024-06-28
7076 Iced Black Tea Latte 7076 119 119 680 730 2024-06-28
7077 Iced Hojicha Tea Latte 7077 119 119 740 790 2024-06-28
7078 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 7078 119 119 630 680 2024-06-28
7079 Iced Shaken Zen Clouds Oolong Lemonade 7079 119 119 610 660 2024-06-28
7080 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 7080 119 119 630 680 2024-06-28
7081 Origami Pike Place® Roast 7081 119 119 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");