item_prices

Pricing information for Starbucks menu items in Singapore

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

249 rows where store_id = 38

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 38 · 249 ✖
id ▼ item_id store_id base_price delivery_price effective_date
20157 Bagel 20157 38 38 400 430 2024-06-28
20158 Cookie Crumble Cheesecake 20158 38 38 720 770 2024-06-28
20159 Good Ol' NY Cheesecake 20159 38 38 720 770 2024-06-28
20160 Signature Chocolate Cake 20160 38 38 720 770 2024-06-28
20161 Starbucks® Coffee Tiramisu Cake 20161 38 38 750 800 2024-06-28
20162 Strawberry Shortcake 20162 38 38 720 770 2024-06-28
20163 Chocolate Chunk Monster Cookie 20163 38 38 390 440 2024-06-28
20164 Banana Walnut Muffin 20164 38 38 450 500 2024-06-28
20165 Blueberry Crumble Muffin 20165 38 38 450 500 2024-06-28
20166 Chocolate Crumble Muffin 20166 38 38 450 500 2024-06-28
20167 Pancakes 20167 38 38 550 600 2024-06-28
20168 Almond Croissant 20168 38 38 470 520 2024-06-28
20169 Buttery Croissant 20169 38 38 400 430 2024-06-28
20170 Chocolate Croissant 20170 38 38 440 490 2024-06-28
20171 Creamy Chicken Foldover 20171 38 38 550 600 2024-06-28
20172 Sausage Roll 20172 38 38 550 600 2024-06-28
20173 Buttery Scone 20173 38 38 400 430 2024-06-28
20174 Country Chicken Pie 20174 38 38 690 740 2024-06-28
20175 Deep Dish Beef Pie 20175 38 38 690 740 2024-06-28
20176 Spinach & Mushroom Quiche 20176 38 38 690 740 2024-06-28
20177 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 20177 38 38 390 420 2024-06-28
20178 Mixed Nuts 20178 38 38 490 540 2024-06-28
20179 Caramel Waffles 20179 38 38 390 420 2024-06-28
20180 Chicken Ham & Cheese Panwich 20180 38 38 690 740 2024-06-28
20181 Egg Mayo & Cheese Multigrain Croissant 20181 38 38 690 740 2024-06-28
20182 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 20182 38 38 690 740 2024-06-28
20183 Rosemary Chicken & Emmental Cheese Croissant 20183 38 38 690 740 2024-06-28
20184 Scrambled Egg & Turkey Ham Pita 20184 38 38 690 740 2024-06-28
20185 Turkey Ham & Triple Cheese Toast 20185 38 38 690 740 2024-06-28
20186 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 20186 38 38 790 840 2024-06-28
20187 Ham & Cheese Croissant 20187 38 38 690 740 2024-06-28
20188 Sriracha Chicken Whole Wheat Pita 20188 38 38 750 800 2024-06-28
20189 Blueberry Acai Yogurt Parfait 20189 38 38 650 700 2024-06-28
20190 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 20190 38 38 650 700 2024-06-28
20191 Caramel Frappuccino® 20191 38 38 720 770 2024-06-28
20192 Dark Mocha Frappuccino® 20192 38 38 780 830 2024-06-28
20193 Java Chip Frappuccino® 20193 38 38 780 830 2024-06-28
20194 Mocha Frappuccino® 20194 38 38 720 770 2024-06-28
20195 Caramel Macchiato Frappuccino® 20195 38 38 780 830 2024-06-28
20196 Espresso Frappuccino® 20196 38 38 720 770 2024-06-28
20197 White Chocolate Mocha Frappuccino® 20197 38 38 720 770 2024-06-28
20198 Chocolate Chip Cream Frappuccino® 20198 38 38 780 830 2024-06-28
20199 Hojicha Tea Cream Frappuccino® 20199 38 38 760 810 2024-06-28
20200 Vanilla Cream Frappuccino® 20200 38 38 720 770 2024-06-28
20201 Mango Passion Fruit & Hibiscus 20201 38 38 720 770 2024-06-28
20202 Raspberry Black Currant & Oolong 20202 38 38 720 770 2024-06-28
20203 Coffee Traveller 20203 38 38 3120 3170 2024-06-28
20204 Caffè Americano 20204 38 38 540 590 2024-06-28
20205 Cappuccino 20205 38 38 680 730 2024-06-28
20206 Caffè Mocha 20206 38 38 750 800 2024-06-28
20207 Caramel Macchiato 20207 38 38 760 810 2024-06-28
20208 Espresso 20208 38 38 390 440 2024-06-28
20209 Caffè Latte 20209 38 38 680 730 2024-06-28
20210 Oatmilk Latte 20210 38 38 760 810 2024-06-28
20211 Vanilla Latte 20211 38 38 750 800 2024-06-28
20212 White Chocolate Mocha 20212 38 38 750 800 2024-06-28
20213 Flat White 20213 38 38 760 810 2024-06-28
20214 Ristretto Bianco 20214 38 38 760 810 2024-06-28
20215 Iced Caffè Americano 20215 38 38 540 590 2024-06-28
20216 Iced Cappuccino 20216 38 38 680 730 2024-06-28
20217 Iced Caffè Mocha 20217 38 38 750 800 2024-06-28
20218 Iced Caramel Macchiato 20218 38 38 760 810 2024-06-28
20219 Iced Caffè Latte 20219 38 38 680 730 2024-06-28
20220 Iced Oatmilk Latte 20220 38 38 760 810 2024-06-28
20221 Iced Vanilla Latte 20221 38 38 750 800 2024-06-28
20222 Iced White Chocolate Mocha 20222 38 38 750 800 2024-06-28
20223 Signature Hot Chocolate 20223 38 38 720 770 2024-06-28
20224 Signature Iced Chocolate 20224 38 38 720 770 2024-06-28
20225 Carrot Juice 20225 38 38 490 540 2024-06-28
20226 Cloudy Apple Juice 20226 38 38 490 540 2024-06-28
20227 Cranberry Red Grapefruit Juice 20227 38 38 490 540 2024-06-28
20228 Orange Juice 20228 38 38 490 540 2024-06-28
20229 Evian 20229 38 38 350 400 2024-06-28
20230 Sparkling Water 20230 38 38 450 500 2024-06-28
20231 Chai Tea 20231 38 38 500 550 2024-06-28
20232 Earl Grey Tea 20232 38 38 500 550 2024-06-28
20233 English Breakfast Tea 20233 38 38 500 550 2024-06-28
20234 Emperor’s Clouds & Mist™ Tea 20234 38 38 500 550 2024-06-28
20235 Mint Blend Tea 20235 38 38 500 550 2024-06-28
20236 Chamomile Tea 20236 38 38 500 550 2024-06-28
20237 Pure Matcha Latte 20237 38 38 740 790 2024-06-28
20238 Chai Tea Latte 20238 38 38 680 730 2024-06-28
20239 Earl Grey Tea Latte 20239 38 38 680 730 2024-06-28
20240 English Breakfast Tea Latte 20240 38 38 680 730 2024-06-28
20241 Hojicha Tea Latte 20241 38 38 740 790 2024-06-28
20242 Zen Clouds Oolong Tea 20242 38 38 500 550 2024-06-28
20243 Zen Clouds Oolong with Ruby Grapefruit and Honey 20243 38 38 630 680 2024-06-28
20244 Youthberry™ Tea 20244 38 38 500 550 2024-06-28
20245 Iced Shaken Black Tea Lemonade 20245 38 38 610 660 2024-06-28
20246 Iced Shaken Strawberry Black Tea Lemonade 20246 38 38 630 680 2024-06-28
20247 Iced Shaken Hibiscus Tea Lemonade 20247 38 38 610 660 2024-06-28
20248 Iced Shaken Hibiscus Tea with Pomegranate Pearls 20248 38 38 730 780 2024-06-28
20249 Iced Pure Matcha Latte 20249 38 38 740 790 2024-06-28
20250 Iced Chai Tea Latte 20250 38 38 680 730 2024-06-28
20251 Iced Black Tea Latte 20251 38 38 680 730 2024-06-28
20252 Iced Hojicha Tea Latte 20252 38 38 740 790 2024-06-28
20253 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 20253 38 38 630 680 2024-06-28
20254 Iced Shaken Zen Clouds Oolong Lemonade 20254 38 38 610 660 2024-06-28
20255 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 20255 38 38 630 680 2024-06-28
20256 Origami Pike Place® Roast 20256 38 38 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");