item_prices

Pricing information for Starbucks menu items in Singapore

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

142 rows where effective_date = "2024-10-20"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

effective_date 1

  • 2024-10-20 · 142 ✖
id ▼ item_id store_id base_price delivery_price effective_date
32422 Bagel 4430 136 136 410 440 2024-10-20
32423 Cookie Crumble Cheesecake 4431 136 136 760 810 2024-10-20
32424 Good Ol' NY Cheesecake 4432 136 136 760 810 2024-10-20
32425 Signature Chocolate Cake 4433 136 136 760 810 2024-10-20
32426 Starbucks® Coffee Tiramisu Cake 4434 136 136 760 810 2024-10-20
32427 Strawberry Shortcake 4435 136 136 760 810 2024-10-20
32428 Chocolate Chunk Monster Cookie 4436 136 136 400 450 2024-10-20
32429 Banana Walnut Muffin 4437 136 136 460 510 2024-10-20
32430 Blueberry Crumble Muffin 4438 136 136 460 510 2024-10-20
32431 Chocolate Crumble Muffin 4439 136 136 460 510 2024-10-20
32432 Pancakes 4440 136 136 560 610 2024-10-20
32433 Almond Croissant 4441 136 136 480 530 2024-10-20
32434 Buttery Croissant 4442 136 136 410 440 2024-10-20
32435 Chocolate Croissant 4443 136 136 450 500 2024-10-20
32436 Creamy Chicken Foldover 4444 136 136 560 610 2024-10-20
32437 Sausage Roll 4445 136 136 560 610 2024-10-20
32438 Buttery Scone 4446 136 136 410 440 2024-10-20
32439 Country Chicken Pie 4447 136 136 700 750 2024-10-20
32440 Deep Dish Beef Pie 4448 136 136 700 750 2024-10-20
32441 Spinach & Mushroom Quiche 4449 136 136 700 750 2024-10-20
32442 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 4450 136 136 400 430 2024-10-20
32443 Mixed Nuts 4451 136 136 500 550 2024-10-20
32444 Caramel Waffles 4452 136 136 400 430 2024-10-20
32445 Chicken Ham & Cheese Panwich 4453 136 136 700 750 2024-10-20
32446 Egg Mayo & Cheese Multigrain Croissant 4454 136 136 700 750 2024-10-20
32447 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 4455 136 136 700 750 2024-10-20
32448 Rosemary Chicken & Emmental Cheese Croissant 4456 136 136 700 750 2024-10-20
32449 Scrambled Egg & Turkey Ham Pita 4457 136 136 700 750 2024-10-20
32450 Turkey Ham & Triple Cheese Toast 4458 136 136 700 750 2024-10-20
32451 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 4459 136 136 800 850 2024-10-20
32452 Ham & Cheese Croissant 4460 136 136 700 750 2024-10-20
32453 Sriracha Chicken Whole Wheat Pita 4461 136 136 760 810 2024-10-20
32454 Blueberry Acai Yogurt Parfait 4462 136 136 660 710 2024-10-20
32455 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 4463 136 136 660 710 2024-10-20
32456 Caramel Frappuccino® 4464 136 136 770 820 2024-10-20
32457 Dark Mocha Frappuccino® 4465 136 136 820 870 2024-10-20
32458 Java Chip Frappuccino® 4466 136 136 820 870 2024-10-20
32459 Mocha Frappuccino® 4467 136 136 770 820 2024-10-20
32460 Caramel Macchiato Frappuccino® 4468 136 136 820 870 2024-10-20
32461 Espresso Frappuccino® 4469 136 136 770 820 2024-10-20
32462 White Chocolate Mocha Frappuccino® 4470 136 136 770 820 2024-10-20
32463 Chocolate Chip Cream Frappuccino® 4471 136 136 820 870 2024-10-20
32464 Hojicha Tea Cream Frappuccino® 4472 136 136 820 870 2024-10-20
32465 Vanilla Cream Frappuccino® 4473 136 136 770 820 2024-10-20
32466 Mango Passion Fruit & Hibiscus 4474 136 136 770 820 2024-10-20
32467 Raspberry Black Currant & Oolong 4475 136 136 770 820 2024-10-20
32468 Coffee Traveller 4476 136 136 3150 3200 2024-10-20
32469 Caffè Americano 4477 136 136 570 620 2024-10-20
32470 Cappuccino 4478 136 136 710 760 2024-10-20
32471 Caffè Mocha 4479 136 136 790 840 2024-10-20
32472 Caramel Macchiato 4480 136 136 800 850 2024-10-20
32473 Espresso 4481 136 136 420 470 2024-10-20
32474 Caffè Latte 4482 136 136 710 760 2024-10-20
32475 Oatmilk Latte 4483 136 136 790 840 2024-10-20
32476 Vanilla Latte 4484 136 136 790 840 2024-10-20
32477 White Chocolate Mocha 4485 136 136 790 840 2024-10-20
32478 Flat White 4486 136 136 800 850 2024-10-20
32479 Ristretto Bianco 4487 136 136 800 850 2024-10-20
32480 Iced Caffè Americano 4488 136 136 570 620 2024-10-20
32481 Iced Cappuccino 4489 136 136 710 760 2024-10-20
32482 Iced Caffè Mocha 4490 136 136 790 840 2024-10-20
32483 Iced Caramel Macchiato 4491 136 136 800 850 2024-10-20
32484 Iced Caffè Latte 4492 136 136 710 760 2024-10-20
32485 Iced Oatmilk Latte 4493 136 136 790 840 2024-10-20
32486 Iced Vanilla Latte 4494 136 136 790 840 2024-10-20
32487 Iced White Chocolate Mocha 4495 136 136 790 840 2024-10-20
32488 Signature Hot Chocolate 4496 136 136 760 810 2024-10-20
32489 Signature Iced Chocolate 4497 136 136 760 810 2024-10-20
32490 Carrot Juice 4498 136 136 520 570 2024-10-20
32491 Cloudy Apple Juice 4499 136 136 520 570 2024-10-20
32492 Cranberry Red Grapefruit Juice 4500 136 136 520 570 2024-10-20
32493 Orange Juice 4501 136 136 520 570 2024-10-20
32494 Evian 4502 136 136 380 430 2024-10-20
32495 Sparkling Water 4503 136 136 480 530 2024-10-20
32496 Chai Tea 4504 136 136 530 580 2024-10-20
32497 Earl Grey Tea 4505 136 136 530 580 2024-10-20
32498 English Breakfast Tea 4506 136 136 530 580 2024-10-20
32499 Emperor’s Clouds & Mist™ Tea 4507 136 136 530 580 2024-10-20
32500 Mint Blend Tea 4508 136 136 530 580 2024-10-20
32501 Chamomile Tea 4509 136 136 530 580 2024-10-20
32502 Pure Matcha Latte 4510 136 136 780 830 2024-10-20
32503 Chai Tea Latte 4511 136 136 710 760 2024-10-20
32504 Earl Grey Tea Latte 4512 136 136 710 760 2024-10-20
32505 English Breakfast Tea Latte 4513 136 136 710 760 2024-10-20
32506 Hojicha Tea Latte 4514 136 136 780 830 2024-10-20
32507 Zen Clouds Oolong Tea 4515 136 136 530 580 2024-10-20
32508 Zen Clouds Oolong with Ruby Grapefruit and Honey 4516 136 136 670 720 2024-10-20
32509 Youthberry™ Tea 4517 136 136 530 580 2024-10-20
32510 Iced Shaken Strawberry Black Tea Lemonade 4519 136 136 670 720 2024-10-20
32511 Iced Shaken Hibiscus Tea Lemonade 4520 136 136 650 700 2024-10-20
32512 Iced Shaken Hibiscus Tea with Pomegranate Pearls 4521 136 136 770 820 2024-10-20
32513 Iced Pure Matcha Latte 4522 136 136 780 830 2024-10-20
32514 Iced Chai Tea Latte 4523 136 136 710 760 2024-10-20
32515 Iced Black Tea Latte 4524 136 136 710 760 2024-10-20
32516 Iced Hojicha Tea Latte 4525 136 136 780 830 2024-10-20
32517 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 4526 136 136 670 720 2024-10-20
32518 Iced Shaken Zen Clouds Oolong Lemonade 4527 136 136 650 700 2024-10-20
32519 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 4528 136 136 670 720 2024-10-20
32520 Freshly Brewed Coffee 4561 136 136 420 470 2024-10-20
32521 Cold Brew 4562 136 136 640 690 2024-10-20

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");