item_prices

Pricing information for Starbucks menu items in Singapore

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

343 rows where store_id = 56

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 56 · 343 ✖
id ▼ item_id store_id base_price delivery_price effective_date
17420 Bagel 17420 56 56 430 460 2024-06-28
17421 Cookie Crumble Cheesecake 17421 56 56 750 800 2024-06-28
17422 Good Ol' NY Cheesecake 17422 56 56 750 800 2024-06-28
17423 Signature Chocolate Cake 17423 56 56 750 800 2024-06-28
17424 Starbucks® Coffee Tiramisu Cake 17424 56 56 780 830 2024-06-28
17425 Strawberry Shortcake 17425 56 56 750 800 2024-06-28
17426 Chocolate Chunk Monster Cookie 17426 56 56 420 470 2024-06-28
17427 Banana Walnut Muffin 17427 56 56 480 530 2024-06-28
17428 Blueberry Crumble Muffin 17428 56 56 480 530 2024-06-28
17429 Chocolate Crumble Muffin 17429 56 56 480 530 2024-06-28
17430 Pancakes 17430 56 56 580 630 2024-06-28
17431 Almond Croissant 17431 56 56 500 550 2024-06-28
17432 Buttery Croissant 17432 56 56 430 460 2024-06-28
17433 Chocolate Croissant 17433 56 56 470 520 2024-06-28
17434 Creamy Chicken Foldover 17434 56 56 580 630 2024-06-28
17435 Sausage Roll 17435 56 56 580 630 2024-06-28
17436 Buttery Scone 17436 56 56 430 460 2024-06-28
17437 Country Chicken Pie 17437 56 56 720 770 2024-06-28
17438 Deep Dish Beef Pie 17438 56 56 720 770 2024-06-28
17439 Spinach & Mushroom Quiche 17439 56 56 720 770 2024-06-28
17440 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 17440 56 56 420 450 2024-06-28
17441 Mixed Nuts 17441 56 56 520 570 2024-06-28
17442 Caramel Waffles 17442 56 56 420 450 2024-06-28
17443 Chicken Ham & Cheese Panwich 17443 56 56 720 770 2024-06-28
17444 Egg Mayo & Cheese Multigrain Croissant 17444 56 56 720 770 2024-06-28
17445 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 17445 56 56 720 770 2024-06-28
17446 Rosemary Chicken & Emmental Cheese Croissant 17446 56 56 720 770 2024-06-28
17447 Scrambled Egg & Turkey Ham Pita 17447 56 56 720 770 2024-06-28
17448 Turkey Ham & Triple Cheese Toast 17448 56 56 720 770 2024-06-28
17449 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 17449 56 56 820 870 2024-06-28
17450 Ham & Cheese Croissant 17450 56 56 720 770 2024-06-28
17451 Sriracha Chicken Whole Wheat Pita 17451 56 56 780 830 2024-06-28
17452 Blueberry Acai Yogurt Parfait 17452 56 56 680 730 2024-06-28
17453 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 17453 56 56 680 730 2024-06-28
17454 Caramel Frappuccino® 17454 56 56 780 830 2024-06-28
17455 Dark Mocha Frappuccino® 17455 56 56 840 890 2024-06-28
17456 Java Chip Frappuccino® 17456 56 56 840 890 2024-06-28
17457 Mocha Frappuccino® 17457 56 56 780 830 2024-06-28
17458 Caramel Macchiato Frappuccino® 17458 56 56 840 890 2024-06-28
17459 Espresso Frappuccino® 17459 56 56 780 830 2024-06-28
17460 White Chocolate Mocha Frappuccino® 17460 56 56 780 830 2024-06-28
17461 Chocolate Chip Cream Frappuccino® 17461 56 56 840 890 2024-06-28
17462 Hojicha Tea Cream Frappuccino® 17462 56 56 820 870 2024-06-28
17463 Vanilla Cream Frappuccino® 17463 56 56 780 830 2024-06-28
17464 Mango Passion Fruit & Hibiscus 17464 56 56 780 830 2024-06-28
17465 Raspberry Black Currant & Oolong 17465 56 56 780 830 2024-06-28
17466 Coffee Traveller 17466 56 56 3600 3650 2024-06-28
17467 Caffè Americano 17467 56 56 600 650 2024-06-28
17468 Cappuccino 17468 56 56 740 790 2024-06-28
17469 Caffè Mocha 17469 56 56 830 880 2024-06-28
17470 Caramel Macchiato 17470 56 56 840 890 2024-06-28
17471 Espresso 17471 56 56 450 500 2024-06-28
17472 Caffè Latte 17472 56 56 740 790 2024-06-28
17473 Oatmilk Latte 17473 56 56 850 900 2024-06-28
17474 Vanilla Latte 17474 56 56 830 880 2024-06-28
17475 White Chocolate Mocha 17475 56 56 830 880 2024-06-28
17476 Flat White 17476 56 56 840 890 2024-06-28
17477 Ristretto Bianco 17477 56 56 840 890 2024-06-28
17478 Iced Caffè Americano 17478 56 56 600 650 2024-06-28
17479 Iced Cappuccino 17479 56 56 740 790 2024-06-28
17480 Iced Caffè Mocha 17480 56 56 830 880 2024-06-28
17481 Iced Caramel Macchiato 17481 56 56 840 890 2024-06-28
17482 Iced Caffè Latte 17482 56 56 740 790 2024-06-28
17483 Iced Oatmilk Latte 17483 56 56 850 900 2024-06-28
17484 Iced Vanilla Latte 17484 56 56 830 880 2024-06-28
17485 Iced White Chocolate Mocha 17485 56 56 830 880 2024-06-28
17486 Signature Hot Chocolate 17486 56 56 780 830 2024-06-28
17487 Signature Iced Chocolate 17487 56 56 780 830 2024-06-28
17488 Carrot Juice 17488 56 56 550 600 2024-06-28
17489 Cloudy Apple Juice 17489 56 56 550 600 2024-06-28
17490 Cranberry Red Grapefruit Juice 17490 56 56 550 600 2024-06-28
17491 Orange Juice 17491 56 56 550 600 2024-06-28
17492 Evian 17492 56 56 410 460 2024-06-28
17493 Sparkling Water 17493 56 56 510 560 2024-06-28
17494 Chai Tea 17494 56 56 560 610 2024-06-28
17495 Earl Grey Tea 17495 56 56 560 610 2024-06-28
17496 English Breakfast Tea 17496 56 56 560 610 2024-06-28
17497 Emperor’s Clouds & Mist™ Tea 17497 56 56 560 610 2024-06-28
17498 Mint Blend Tea 17498 56 56 560 610 2024-06-28
17499 Chamomile Tea 17499 56 56 560 610 2024-06-28
17500 Pure Matcha Latte 17500 56 56 810 860 2024-06-28
17501 Chai Tea Latte 17501 56 56 740 790 2024-06-28
17502 Earl Grey Tea Latte 17502 56 56 740 790 2024-06-28
17503 English Breakfast Tea Latte 17503 56 56 740 790 2024-06-28
17504 Hojicha Tea Latte 17504 56 56 810 860 2024-06-28
17505 Zen Clouds Oolong Tea 17505 56 56 560 610 2024-06-28
17506 Zen Clouds Oolong with Ruby Grapefruit and Honey 17506 56 56 690 740 2024-06-28
17507 Youthberry™ Tea 17507 56 56 560 610 2024-06-28
17508 Iced Shaken Black Tea Lemonade 17508 56 56 670 720 2024-06-28
17509 Iced Shaken Strawberry Black Tea Lemonade 17509 56 56 690 740 2024-06-28
17510 Iced Shaken Hibiscus Tea Lemonade 17510 56 56 670 720 2024-06-28
17511 Iced Shaken Hibiscus Tea with Pomegranate Pearls 17511 56 56 790 840 2024-06-28
17512 Iced Pure Matcha Latte 17512 56 56 810 860 2024-06-28
17513 Iced Chai Tea Latte 17513 56 56 740 790 2024-06-28
17514 Iced Black Tea Latte 17514 56 56 740 790 2024-06-28
17515 Iced Hojicha Tea Latte 17515 56 56 810 860 2024-06-28
17516 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 17516 56 56 690 740 2024-06-28
17517 Iced Shaken Zen Clouds Oolong Lemonade 17517 56 56 670 720 2024-06-28
17518 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 17518 56 56 690 740 2024-06-28
17519 Origami Pike Place® Roast 17519 56 56 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");