item_prices

Pricing information for Starbucks menu items in Singapore

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

225 rows where store_id = 111

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 111 · 225 ✖
id ▼ item_id store_id base_price delivery_price effective_date
8438 Bagel 8438 111 111 400 430 2024-06-28
8439 Cookie Crumble Cheesecake 8439 111 111 720 770 2024-06-28
8440 Good Ol' NY Cheesecake 8440 111 111 720 770 2024-06-28
8441 Signature Chocolate Cake 8441 111 111 720 770 2024-06-28
8442 Starbucks® Coffee Tiramisu Cake 8442 111 111 750 800 2024-06-28
8443 Strawberry Shortcake 8443 111 111 720 770 2024-06-28
8444 Chocolate Chunk Monster Cookie 8444 111 111 390 440 2024-06-28
8445 Banana Walnut Muffin 8445 111 111 450 500 2024-06-28
8446 Blueberry Crumble Muffin 8446 111 111 450 500 2024-06-28
8447 Chocolate Crumble Muffin 8447 111 111 450 500 2024-06-28
8448 Pancakes 8448 111 111 550 600 2024-06-28
8449 Almond Croissant 8449 111 111 470 520 2024-06-28
8450 Buttery Croissant 8450 111 111 400 430 2024-06-28
8451 Chocolate Croissant 8451 111 111 440 490 2024-06-28
8452 Creamy Chicken Foldover 8452 111 111 550 600 2024-06-28
8453 Sausage Roll 8453 111 111 550 600 2024-06-28
8454 Buttery Scone 8454 111 111 400 430 2024-06-28
8455 Country Chicken Pie 8455 111 111 690 740 2024-06-28
8456 Deep Dish Beef Pie 8456 111 111 690 740 2024-06-28
8457 Spinach & Mushroom Quiche 8457 111 111 690 740 2024-06-28
8458 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 8458 111 111 390 420 2024-06-28
8459 Mixed Nuts 8459 111 111 490 540 2024-06-28
8460 Caramel Waffles 8460 111 111 390 420 2024-06-28
8461 Chicken Ham & Cheese Panwich 8461 111 111 690 740 2024-06-28
8462 Egg Mayo & Cheese Multigrain Croissant 8462 111 111 690 740 2024-06-28
8463 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 8463 111 111 690 740 2024-06-28
8464 Rosemary Chicken & Emmental Cheese Croissant 8464 111 111 690 740 2024-06-28
8465 Scrambled Egg & Turkey Ham Pita 8465 111 111 690 740 2024-06-28
8466 Turkey Ham & Triple Cheese Toast 8466 111 111 690 740 2024-06-28
8467 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 8467 111 111 790 840 2024-06-28
8468 Ham & Cheese Croissant 8468 111 111 690 740 2024-06-28
8469 Sriracha Chicken Whole Wheat Pita 8469 111 111 750 800 2024-06-28
8470 Blueberry Acai Yogurt Parfait 8470 111 111 650 700 2024-06-28
8471 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 8471 111 111 650 700 2024-06-28
8472 Caramel Frappuccino® 8472 111 111 720 770 2024-06-28
8473 Dark Mocha Frappuccino® 8473 111 111 780 830 2024-06-28
8474 Java Chip Frappuccino® 8474 111 111 780 830 2024-06-28
8475 Mocha Frappuccino® 8475 111 111 720 770 2024-06-28
8476 Caramel Macchiato Frappuccino® 8476 111 111 780 830 2024-06-28
8477 Espresso Frappuccino® 8477 111 111 720 770 2024-06-28
8478 White Chocolate Mocha Frappuccino® 8478 111 111 720 770 2024-06-28
8479 Chocolate Chip Cream Frappuccino® 8479 111 111 780 830 2024-06-28
8480 Hojicha Tea Cream Frappuccino® 8480 111 111 760 810 2024-06-28
8481 Vanilla Cream Frappuccino® 8481 111 111 720 770 2024-06-28
8482 Mango Passion Fruit & Hibiscus 8482 111 111 720 770 2024-06-28
8483 Raspberry Black Currant & Oolong 8483 111 111 720 770 2024-06-28
8484 Coffee Traveller 8484 111 111 3120 3170 2024-06-28
8485 Caffè Americano 8485 111 111 540 590 2024-06-28
8486 Cappuccino 8486 111 111 680 730 2024-06-28
8487 Caffè Mocha 8487 111 111 750 800 2024-06-28
8488 Caramel Macchiato 8488 111 111 760 810 2024-06-28
8489 Espresso 8489 111 111 390 440 2024-06-28
8490 Caffè Latte 8490 111 111 680 730 2024-06-28
8491 Oatmilk Latte 8491 111 111 760 810 2024-06-28
8492 Vanilla Latte 8492 111 111 750 800 2024-06-28
8493 White Chocolate Mocha 8493 111 111 750 800 2024-06-28
8494 Flat White 8494 111 111 760 810 2024-06-28
8495 Ristretto Bianco 8495 111 111 760 810 2024-06-28
8496 Iced Caffè Americano 8496 111 111 540 590 2024-06-28
8497 Iced Cappuccino 8497 111 111 680 730 2024-06-28
8498 Iced Caffè Mocha 8498 111 111 750 800 2024-06-28
8499 Iced Caramel Macchiato 8499 111 111 760 810 2024-06-28
8500 Iced Caffè Latte 8500 111 111 680 730 2024-06-28
8501 Iced Oatmilk Latte 8501 111 111 760 810 2024-06-28
8502 Iced Vanilla Latte 8502 111 111 750 800 2024-06-28
8503 Iced White Chocolate Mocha 8503 111 111 750 800 2024-06-28
8504 Signature Hot Chocolate 8504 111 111 720 770 2024-06-28
8505 Signature Iced Chocolate 8505 111 111 720 770 2024-06-28
8506 Carrot Juice 8506 111 111 490 540 2024-06-28
8507 Cloudy Apple Juice 8507 111 111 490 540 2024-06-28
8508 Cranberry Red Grapefruit Juice 8508 111 111 490 540 2024-06-28
8509 Orange Juice 8509 111 111 490 540 2024-06-28
8510 Evian 8510 111 111 350 400 2024-06-28
8511 Sparkling Water 8511 111 111 450 500 2024-06-28
8512 Chai Tea 8512 111 111 500 550 2024-06-28
8513 Earl Grey Tea 8513 111 111 500 550 2024-06-28
8514 English Breakfast Tea 8514 111 111 500 550 2024-06-28
8515 Emperor’s Clouds & Mist™ Tea 8515 111 111 500 550 2024-06-28
8516 Mint Blend Tea 8516 111 111 500 550 2024-06-28
8517 Chamomile Tea 8517 111 111 500 550 2024-06-28
8518 Pure Matcha Latte 8518 111 111 740 790 2024-06-28
8519 Chai Tea Latte 8519 111 111 680 730 2024-06-28
8520 Earl Grey Tea Latte 8520 111 111 680 730 2024-06-28
8521 English Breakfast Tea Latte 8521 111 111 680 730 2024-06-28
8522 Hojicha Tea Latte 8522 111 111 740 790 2024-06-28
8523 Zen Clouds Oolong Tea 8523 111 111 500 550 2024-06-28
8524 Zen Clouds Oolong with Ruby Grapefruit and Honey 8524 111 111 630 680 2024-06-28
8525 Youthberry™ Tea 8525 111 111 500 550 2024-06-28
8526 Iced Shaken Black Tea Lemonade 8526 111 111 610 660 2024-06-28
8527 Iced Shaken Strawberry Black Tea Lemonade 8527 111 111 630 680 2024-06-28
8528 Iced Shaken Hibiscus Tea Lemonade 8528 111 111 610 660 2024-06-28
8529 Iced Shaken Hibiscus Tea with Pomegranate Pearls 8529 111 111 730 780 2024-06-28
8530 Iced Pure Matcha Latte 8530 111 111 740 790 2024-06-28
8531 Iced Chai Tea Latte 8531 111 111 680 730 2024-06-28
8532 Iced Black Tea Latte 8532 111 111 680 730 2024-06-28
8533 Iced Hojicha Tea Latte 8533 111 111 740 790 2024-06-28
8534 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 8534 111 111 630 680 2024-06-28
8535 Iced Shaken Zen Clouds Oolong Lemonade 8535 111 111 610 660 2024-06-28
8536 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 8536 111 111 630 680 2024-06-28
8537 Origami Pike Place® Roast 8537 111 111 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");