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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 137 · 249 ✖
id ▼ item_id store_id base_price delivery_price effective_date
4248 Bagel 4248 137 137 400 430 2024-06-28
4249 Cookie Crumble Cheesecake 4249 137 137 720 770 2024-06-28
4250 Good Ol' NY Cheesecake 4250 137 137 720 770 2024-06-28
4251 Signature Chocolate Cake 4251 137 137 720 770 2024-06-28
4252 Starbucks® Coffee Tiramisu Cake 4252 137 137 750 800 2024-06-28
4253 Strawberry Shortcake 4253 137 137 720 770 2024-06-28
4254 Chocolate Chunk Monster Cookie 4254 137 137 390 440 2024-06-28
4255 Banana Walnut Muffin 4255 137 137 450 500 2024-06-28
4256 Blueberry Crumble Muffin 4256 137 137 450 500 2024-06-28
4257 Chocolate Crumble Muffin 4257 137 137 450 500 2024-06-28
4258 Pancakes 4258 137 137 550 600 2024-06-28
4259 Almond Croissant 4259 137 137 470 520 2024-06-28
4260 Buttery Croissant 4260 137 137 400 430 2024-06-28
4261 Chocolate Croissant 4261 137 137 440 490 2024-06-28
4262 Creamy Chicken Foldover 4262 137 137 550 600 2024-06-28
4263 Sausage Roll 4263 137 137 550 600 2024-06-28
4264 Buttery Scone 4264 137 137 400 430 2024-06-28
4265 Country Chicken Pie 4265 137 137 690 740 2024-06-28
4266 Deep Dish Beef Pie 4266 137 137 690 740 2024-06-28
4267 Spinach & Mushroom Quiche 4267 137 137 690 740 2024-06-28
4268 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 4268 137 137 390 420 2024-06-28
4269 Mixed Nuts 4269 137 137 490 540 2024-06-28
4270 Caramel Waffles 4270 137 137 390 420 2024-06-28
4271 Chicken Ham & Cheese Panwich 4271 137 137 690 740 2024-06-28
4272 Egg Mayo & Cheese Multigrain Croissant 4272 137 137 690 740 2024-06-28
4273 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 4273 137 137 690 740 2024-06-28
4274 Rosemary Chicken & Emmental Cheese Croissant 4274 137 137 690 740 2024-06-28
4275 Scrambled Egg & Turkey Ham Pita 4275 137 137 690 740 2024-06-28
4276 Turkey Ham & Triple Cheese Toast 4276 137 137 690 740 2024-06-28
4277 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 4277 137 137 790 840 2024-06-28
4278 Ham & Cheese Croissant 4278 137 137 690 740 2024-06-28
4279 Sriracha Chicken Whole Wheat Pita 4279 137 137 750 800 2024-06-28
4280 Blueberry Acai Yogurt Parfait 4280 137 137 650 700 2024-06-28
4281 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 4281 137 137 650 700 2024-06-28
4282 Caramel Frappuccino® 4282 137 137 720 770 2024-06-28
4283 Dark Mocha Frappuccino® 4283 137 137 780 830 2024-06-28
4284 Java Chip Frappuccino® 4284 137 137 780 830 2024-06-28
4285 Mocha Frappuccino® 4285 137 137 720 770 2024-06-28
4286 Caramel Macchiato Frappuccino® 4286 137 137 780 830 2024-06-28
4287 Espresso Frappuccino® 4287 137 137 720 770 2024-06-28
4288 White Chocolate Mocha Frappuccino® 4288 137 137 720 770 2024-06-28
4289 Chocolate Chip Cream Frappuccino® 4289 137 137 780 830 2024-06-28
4290 Hojicha Tea Cream Frappuccino® 4290 137 137 760 810 2024-06-28
4291 Vanilla Cream Frappuccino® 4291 137 137 720 770 2024-06-28
4292 Mango Passion Fruit & Hibiscus 4292 137 137 720 770 2024-06-28
4293 Raspberry Black Currant & Oolong 4293 137 137 720 770 2024-06-28
4294 Coffee Traveller 4294 137 137 3120 3170 2024-06-28
4295 Caffè Americano 4295 137 137 540 590 2024-06-28
4296 Cappuccino 4296 137 137 680 730 2024-06-28
4297 Caffè Mocha 4297 137 137 750 800 2024-06-28
4298 Caramel Macchiato 4298 137 137 760 810 2024-06-28
4299 Espresso 4299 137 137 390 440 2024-06-28
4300 Caffè Latte 4300 137 137 680 730 2024-06-28
4301 Oatmilk Latte 4301 137 137 760 810 2024-06-28
4302 Vanilla Latte 4302 137 137 750 800 2024-06-28
4303 White Chocolate Mocha 4303 137 137 750 800 2024-06-28
4304 Flat White 4304 137 137 760 810 2024-06-28
4305 Ristretto Bianco 4305 137 137 760 810 2024-06-28
4306 Iced Caffè Americano 4306 137 137 540 590 2024-06-28
4307 Iced Cappuccino 4307 137 137 680 730 2024-06-28
4308 Iced Caffè Mocha 4308 137 137 750 800 2024-06-28
4309 Iced Caramel Macchiato 4309 137 137 760 810 2024-06-28
4310 Iced Caffè Latte 4310 137 137 680 730 2024-06-28
4311 Iced Oatmilk Latte 4311 137 137 760 810 2024-06-28
4312 Iced Vanilla Latte 4312 137 137 750 800 2024-06-28
4313 Iced White Chocolate Mocha 4313 137 137 750 800 2024-06-28
4314 Signature Hot Chocolate 4314 137 137 720 770 2024-06-28
4315 Signature Iced Chocolate 4315 137 137 720 770 2024-06-28
4316 Carrot Juice 4316 137 137 490 540 2024-06-28
4317 Cloudy Apple Juice 4317 137 137 490 540 2024-06-28
4318 Cranberry Red Grapefruit Juice 4318 137 137 490 540 2024-06-28
4319 Orange Juice 4319 137 137 490 540 2024-06-28
4320 Evian 4320 137 137 350 400 2024-06-28
4321 Sparkling Water 4321 137 137 450 500 2024-06-28
4322 Chai Tea 4322 137 137 500 550 2024-06-28
4323 Earl Grey Tea 4323 137 137 500 550 2024-06-28
4324 English Breakfast Tea 4324 137 137 500 550 2024-06-28
4325 Emperor’s Clouds & Mist™ Tea 4325 137 137 500 550 2024-06-28
4326 Mint Blend Tea 4326 137 137 500 550 2024-06-28
4327 Chamomile Tea 4327 137 137 500 550 2024-06-28
4328 Pure Matcha Latte 4328 137 137 740 790 2024-06-28
4329 Chai Tea Latte 4329 137 137 680 730 2024-06-28
4330 Earl Grey Tea Latte 4330 137 137 680 730 2024-06-28
4331 English Breakfast Tea Latte 4331 137 137 680 730 2024-06-28
4332 Hojicha Tea Latte 4332 137 137 740 790 2024-06-28
4333 Zen Clouds Oolong Tea 4333 137 137 500 550 2024-06-28
4334 Zen Clouds Oolong with Ruby Grapefruit and Honey 4334 137 137 630 680 2024-06-28
4335 Youthberry™ Tea 4335 137 137 500 550 2024-06-28
4336 Iced Shaken Black Tea Lemonade 4336 137 137 610 660 2024-06-28
4337 Iced Shaken Strawberry Black Tea Lemonade 4337 137 137 630 680 2024-06-28
4338 Iced Shaken Hibiscus Tea Lemonade 4338 137 137 610 660 2024-06-28
4339 Iced Shaken Hibiscus Tea with Pomegranate Pearls 4339 137 137 730 780 2024-06-28
4340 Iced Pure Matcha Latte 4340 137 137 740 790 2024-06-28
4341 Iced Chai Tea Latte 4341 137 137 680 730 2024-06-28
4342 Iced Black Tea Latte 4342 137 137 680 730 2024-06-28
4343 Iced Hojicha Tea Latte 4343 137 137 740 790 2024-06-28
4344 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 4344 137 137 630 680 2024-06-28
4345 Iced Shaken Zen Clouds Oolong Lemonade 4345 137 137 610 660 2024-06-28
4346 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 4346 137 137 630 680 2024-06-28
4347 Origami Pike Place® Roast 4347 137 137 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");