item_prices

Pricing information for Starbucks menu items in Singapore

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

248 rows where store_id = 50

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 50 · 248 ✖
id ▼ item_id store_id base_price delivery_price effective_date
18517 Bagel 18517 50 50 400 430 2024-06-28
18518 Cookie Crumble Cheesecake 18518 50 50 720 770 2024-06-28
18519 Good Ol' NY Cheesecake 18519 50 50 720 770 2024-06-28
18520 Signature Chocolate Cake 18520 50 50 720 770 2024-06-28
18521 Starbucks® Coffee Tiramisu Cake 18521 50 50 750 800 2024-06-28
18522 Strawberry Shortcake 18522 50 50 720 770 2024-06-28
18523 Chocolate Chunk Monster Cookie 18523 50 50 390 440 2024-06-28
18524 Banana Walnut Muffin 18524 50 50 450 500 2024-06-28
18525 Blueberry Crumble Muffin 18525 50 50 450 500 2024-06-28
18526 Chocolate Crumble Muffin 18526 50 50 450 500 2024-06-28
18527 Pancakes 18527 50 50 550 600 2024-06-28
18528 Almond Croissant 18528 50 50 470 520 2024-06-28
18529 Buttery Croissant 18529 50 50 400 430 2024-06-28
18530 Chocolate Croissant 18530 50 50 440 490 2024-06-28
18531 Creamy Chicken Foldover 18531 50 50 550 600 2024-06-28
18532 Sausage Roll 18532 50 50 550 600 2024-06-28
18533 Buttery Scone 18533 50 50 400 430 2024-06-28
18534 Country Chicken Pie 18534 50 50 690 740 2024-06-28
18535 Deep Dish Beef Pie 18535 50 50 690 740 2024-06-28
18536 Spinach & Mushroom Quiche 18536 50 50 690 740 2024-06-28
18537 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 18537 50 50 390 420 2024-06-28
18538 Mixed Nuts 18538 50 50 490 540 2024-06-28
18539 Caramel Waffles 18539 50 50 390 420 2024-06-28
18540 Chicken Ham & Cheese Panwich 18540 50 50 690 740 2024-06-28
18541 Egg Mayo & Cheese Multigrain Croissant 18541 50 50 690 740 2024-06-28
18542 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 18542 50 50 690 740 2024-06-28
18543 Rosemary Chicken & Emmental Cheese Croissant 18543 50 50 690 740 2024-06-28
18544 Scrambled Egg & Turkey Ham Pita 18544 50 50 690 740 2024-06-28
18545 Turkey Ham & Triple Cheese Toast 18545 50 50 690 740 2024-06-28
18546 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 18546 50 50 790 840 2024-06-28
18547 Ham & Cheese Croissant 18547 50 50 690 740 2024-06-28
18548 Sriracha Chicken Whole Wheat Pita 18548 50 50 750 800 2024-06-28
18549 Blueberry Acai Yogurt Parfait 18549 50 50 650 700 2024-06-28
18550 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 18550 50 50 650 700 2024-06-28
18551 Caramel Frappuccino® 18551 50 50 720 770 2024-06-28
18552 Dark Mocha Frappuccino® 18552 50 50 780 830 2024-06-28
18553 Java Chip Frappuccino® 18553 50 50 780 830 2024-06-28
18554 Mocha Frappuccino® 18554 50 50 720 770 2024-06-28
18555 Caramel Macchiato Frappuccino® 18555 50 50 780 830 2024-06-28
18556 Espresso Frappuccino® 18556 50 50 720 770 2024-06-28
18557 White Chocolate Mocha Frappuccino® 18557 50 50 720 770 2024-06-28
18558 Chocolate Chip Cream Frappuccino® 18558 50 50 780 830 2024-06-28
18559 Hojicha Tea Cream Frappuccino® 18559 50 50 760 810 2024-06-28
18560 Vanilla Cream Frappuccino® 18560 50 50 720 770 2024-06-28
18561 Mango Passion Fruit & Hibiscus 18561 50 50 720 770 2024-06-28
18562 Raspberry Black Currant & Oolong 18562 50 50 720 770 2024-06-28
18563 Coffee Traveller 18563 50 50 3120 3170 2024-06-28
18564 Caffè Americano 18564 50 50 540 590 2024-06-28
18565 Cappuccino 18565 50 50 680 730 2024-06-28
18566 Caffè Mocha 18566 50 50 750 800 2024-06-28
18567 Caramel Macchiato 18567 50 50 760 810 2024-06-28
18568 Espresso 18568 50 50 390 440 2024-06-28
18569 Caffè Latte 18569 50 50 680 730 2024-06-28
18570 Oatmilk Latte 18570 50 50 760 810 2024-06-28
18571 Vanilla Latte 18571 50 50 750 800 2024-06-28
18572 White Chocolate Mocha 18572 50 50 750 800 2024-06-28
18573 Flat White 18573 50 50 760 810 2024-06-28
18574 Ristretto Bianco 18574 50 50 760 810 2024-06-28
18575 Iced Caffè Americano 18575 50 50 540 590 2024-06-28
18576 Iced Cappuccino 18576 50 50 680 730 2024-06-28
18577 Iced Caffè Mocha 18577 50 50 750 800 2024-06-28
18578 Iced Caramel Macchiato 18578 50 50 760 810 2024-06-28
18579 Iced Caffè Latte 18579 50 50 680 730 2024-06-28
18580 Iced Oatmilk Latte 18580 50 50 760 810 2024-06-28
18581 Iced Vanilla Latte 18581 50 50 750 800 2024-06-28
18582 Iced White Chocolate Mocha 18582 50 50 750 800 2024-06-28
18583 Signature Hot Chocolate 18583 50 50 720 770 2024-06-28
18584 Signature Iced Chocolate 18584 50 50 720 770 2024-06-28
18585 Carrot Juice 18585 50 50 490 540 2024-06-28
18586 Cloudy Apple Juice 18586 50 50 490 540 2024-06-28
18587 Cranberry Red Grapefruit Juice 18587 50 50 490 540 2024-06-28
18588 Orange Juice 18588 50 50 490 540 2024-06-28
18589 Evian 18589 50 50 350 400 2024-06-28
18590 Sparkling Water 18590 50 50 450 500 2024-06-28
18591 Chai Tea 18591 50 50 500 550 2024-06-28
18592 Earl Grey Tea 18592 50 50 500 550 2024-06-28
18593 English Breakfast Tea 18593 50 50 500 550 2024-06-28
18594 Emperor’s Clouds & Mist™ Tea 18594 50 50 500 550 2024-06-28
18595 Mint Blend Tea 18595 50 50 500 550 2024-06-28
18596 Chamomile Tea 18596 50 50 500 550 2024-06-28
18597 Pure Matcha Latte 18597 50 50 740 790 2024-06-28
18598 Chai Tea Latte 18598 50 50 680 730 2024-06-28
18599 Earl Grey Tea Latte 18599 50 50 680 730 2024-06-28
18600 English Breakfast Tea Latte 18600 50 50 680 730 2024-06-28
18601 Hojicha Tea Latte 18601 50 50 740 790 2024-06-28
18602 Zen Clouds Oolong Tea 18602 50 50 500 550 2024-06-28
18603 Zen Clouds Oolong with Ruby Grapefruit and Honey 18603 50 50 630 680 2024-06-28
18604 Youthberry™ Tea 18604 50 50 500 550 2024-06-28
18605 Iced Shaken Black Tea Lemonade 18605 50 50 610 660 2024-06-28
18606 Iced Shaken Strawberry Black Tea Lemonade 18606 50 50 630 680 2024-06-28
18607 Iced Shaken Hibiscus Tea Lemonade 18607 50 50 610 660 2024-06-28
18608 Iced Shaken Hibiscus Tea with Pomegranate Pearls 18608 50 50 730 780 2024-06-28
18609 Iced Pure Matcha Latte 18609 50 50 740 790 2024-06-28
18610 Iced Chai Tea Latte 18610 50 50 680 730 2024-06-28
18611 Iced Black Tea Latte 18611 50 50 680 730 2024-06-28
18612 Iced Hojicha Tea Latte 18612 50 50 740 790 2024-06-28
18613 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 18613 50 50 630 680 2024-06-28
18614 Iced Shaken Zen Clouds Oolong Lemonade 18614 50 50 610 660 2024-06-28
18615 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 18615 50 50 630 680 2024-06-28
18616 Origami Pike Place® Roast 18616 50 50 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");