item_prices

Pricing information for Starbucks menu items in Singapore

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

182 rows where effective_date = "2024-06-28" and store_id = 108

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 108 · 182 ✖

effective_date 1

  • 2024-06-28 · 182 ✖
id ▼ item_id store_id base_price delivery_price effective_date
8984 Bagel 8984 108 108 400 430 2024-06-28
8985 Cookie Crumble Cheesecake 8985 108 108 720 770 2024-06-28
8986 Good Ol' NY Cheesecake 8986 108 108 720 770 2024-06-28
8987 Signature Chocolate Cake 8987 108 108 720 770 2024-06-28
8988 Starbucks® Coffee Tiramisu Cake 8988 108 108 750 800 2024-06-28
8989 Strawberry Shortcake 8989 108 108 720 770 2024-06-28
8990 Chocolate Chunk Monster Cookie 8990 108 108 390 440 2024-06-28
8991 Banana Walnut Muffin 8991 108 108 450 500 2024-06-28
8992 Blueberry Crumble Muffin 8992 108 108 450 500 2024-06-28
8993 Chocolate Crumble Muffin 8993 108 108 450 500 2024-06-28
8994 Pancakes 8994 108 108 550 600 2024-06-28
8995 Almond Croissant 8995 108 108 470 520 2024-06-28
8996 Buttery Croissant 8996 108 108 400 430 2024-06-28
8997 Chocolate Croissant 8997 108 108 440 490 2024-06-28
8998 Creamy Chicken Foldover 8998 108 108 550 600 2024-06-28
8999 Sausage Roll 8999 108 108 550 600 2024-06-28
9000 Buttery Scone 9000 108 108 400 430 2024-06-28
9001 Country Chicken Pie 9001 108 108 690 740 2024-06-28
9002 Deep Dish Beef Pie 9002 108 108 690 740 2024-06-28
9003 Spinach & Mushroom Quiche 9003 108 108 690 740 2024-06-28
9004 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 9004 108 108 390 420 2024-06-28
9005 Mixed Nuts 9005 108 108 490 540 2024-06-28
9006 Caramel Waffles 9006 108 108 390 420 2024-06-28
9007 Chicken Ham & Cheese Panwich 9007 108 108 690 740 2024-06-28
9008 Egg Mayo & Cheese Multigrain Croissant 9008 108 108 690 740 2024-06-28
9009 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 9009 108 108 690 740 2024-06-28
9010 Rosemary Chicken & Emmental Cheese Croissant 9010 108 108 690 740 2024-06-28
9011 Scrambled Egg & Turkey Ham Pita 9011 108 108 690 740 2024-06-28
9012 Turkey Ham & Triple Cheese Toast 9012 108 108 690 740 2024-06-28
9013 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 9013 108 108 790 840 2024-06-28
9014 Ham & Cheese Croissant 9014 108 108 690 740 2024-06-28
9015 Sriracha Chicken Whole Wheat Pita 9015 108 108 750 800 2024-06-28
9016 Blueberry Acai Yogurt Parfait 9016 108 108 650 700 2024-06-28
9017 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 9017 108 108 650 700 2024-06-28
9018 Caramel Frappuccino® 9018 108 108 720 770 2024-06-28
9019 Dark Mocha Frappuccino® 9019 108 108 780 830 2024-06-28
9020 Java Chip Frappuccino® 9020 108 108 780 830 2024-06-28
9021 Mocha Frappuccino® 9021 108 108 720 770 2024-06-28
9022 Caramel Macchiato Frappuccino® 9022 108 108 780 830 2024-06-28
9023 Espresso Frappuccino® 9023 108 108 720 770 2024-06-28
9024 White Chocolate Mocha Frappuccino® 9024 108 108 720 770 2024-06-28
9025 Chocolate Chip Cream Frappuccino® 9025 108 108 780 830 2024-06-28
9026 Hojicha Tea Cream Frappuccino® 9026 108 108 760 810 2024-06-28
9027 Vanilla Cream Frappuccino® 9027 108 108 720 770 2024-06-28
9028 Mango Passion Fruit & Hibiscus 9028 108 108 720 770 2024-06-28
9029 Raspberry Black Currant & Oolong 9029 108 108 720 770 2024-06-28
9030 Coffee Traveller 9030 108 108 3120 3170 2024-06-28
9031 Caffè Americano 9031 108 108 540 590 2024-06-28
9032 Cappuccino 9032 108 108 680 730 2024-06-28
9033 Caffè Mocha 9033 108 108 750 800 2024-06-28
9034 Caramel Macchiato 9034 108 108 760 810 2024-06-28
9035 Espresso 9035 108 108 390 440 2024-06-28
9036 Caffè Latte 9036 108 108 680 730 2024-06-28
9037 Oatmilk Latte 9037 108 108 760 810 2024-06-28
9038 Vanilla Latte 9038 108 108 750 800 2024-06-28
9039 White Chocolate Mocha 9039 108 108 750 800 2024-06-28
9040 Flat White 9040 108 108 760 810 2024-06-28
9041 Ristretto Bianco 9041 108 108 760 810 2024-06-28
9042 Iced Caffè Americano 9042 108 108 540 590 2024-06-28
9043 Iced Cappuccino 9043 108 108 680 730 2024-06-28
9044 Iced Caffè Mocha 9044 108 108 750 800 2024-06-28
9045 Iced Caramel Macchiato 9045 108 108 760 810 2024-06-28
9046 Iced Caffè Latte 9046 108 108 680 730 2024-06-28
9047 Iced Oatmilk Latte 9047 108 108 760 810 2024-06-28
9048 Iced Vanilla Latte 9048 108 108 750 800 2024-06-28
9049 Iced White Chocolate Mocha 9049 108 108 750 800 2024-06-28
9050 Signature Hot Chocolate 9050 108 108 720 770 2024-06-28
9051 Signature Iced Chocolate 9051 108 108 720 770 2024-06-28
9052 Carrot Juice 9052 108 108 490 540 2024-06-28
9053 Cloudy Apple Juice 9053 108 108 490 540 2024-06-28
9054 Cranberry Red Grapefruit Juice 9054 108 108 490 540 2024-06-28
9055 Orange Juice 9055 108 108 490 540 2024-06-28
9056 Evian 9056 108 108 350 400 2024-06-28
9057 Sparkling Water 9057 108 108 450 500 2024-06-28
9058 Chai Tea 9058 108 108 500 550 2024-06-28
9059 Earl Grey Tea 9059 108 108 500 550 2024-06-28
9060 English Breakfast Tea 9060 108 108 500 550 2024-06-28
9061 Emperor’s Clouds & Mist™ Tea 9061 108 108 500 550 2024-06-28
9062 Mint Blend Tea 9062 108 108 500 550 2024-06-28
9063 Chamomile Tea 9063 108 108 500 550 2024-06-28
9064 Pure Matcha Latte 9064 108 108 740 790 2024-06-28
9065 Chai Tea Latte 9065 108 108 680 730 2024-06-28
9066 Earl Grey Tea Latte 9066 108 108 680 730 2024-06-28
9067 English Breakfast Tea Latte 9067 108 108 680 730 2024-06-28
9068 Hojicha Tea Latte 9068 108 108 740 790 2024-06-28
9069 Zen Clouds Oolong Tea 9069 108 108 500 550 2024-06-28
9070 Zen Clouds Oolong with Ruby Grapefruit and Honey 9070 108 108 630 680 2024-06-28
9071 Youthberry™ Tea 9071 108 108 500 550 2024-06-28
9072 Iced Shaken Black Tea Lemonade 9072 108 108 610 660 2024-06-28
9073 Iced Shaken Strawberry Black Tea Lemonade 9073 108 108 630 680 2024-06-28
9074 Iced Shaken Hibiscus Tea Lemonade 9074 108 108 610 660 2024-06-28
9075 Iced Shaken Hibiscus Tea with Pomegranate Pearls 9075 108 108 730 780 2024-06-28
9076 Iced Pure Matcha Latte 9076 108 108 740 790 2024-06-28
9077 Iced Chai Tea Latte 9077 108 108 680 730 2024-06-28
9078 Iced Black Tea Latte 9078 108 108 680 730 2024-06-28
9079 Iced Hojicha Tea Latte 9079 108 108 740 790 2024-06-28
9080 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 9080 108 108 630 680 2024-06-28
9081 Iced Shaken Zen Clouds Oolong Lemonade 9081 108 108 610 660 2024-06-28
9082 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 9082 108 108 630 680 2024-06-28
9083 Origami Pike Place® Roast 9083 108 108 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");