item_prices

Pricing information for Starbucks menu items in Singapore

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

336 rows where store_id = 80

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 80 · 336 ✖
id ▼ item_id store_id base_price delivery_price effective_date
13568 Bagel 13568 80 80 430 460 2024-06-28
13569 Cookie Crumble Cheesecake 13569 80 80 750 800 2024-06-28
13570 Good Ol' NY Cheesecake 13570 80 80 750 800 2024-06-28
13571 Signature Chocolate Cake 13571 80 80 750 800 2024-06-28
13572 Starbucks® Coffee Tiramisu Cake 13572 80 80 780 830 2024-06-28
13573 Strawberry Shortcake 13573 80 80 750 800 2024-06-28
13574 Chocolate Chunk Monster Cookie 13574 80 80 420 470 2024-06-28
13575 Banana Walnut Muffin 13575 80 80 480 530 2024-06-28
13576 Blueberry Crumble Muffin 13576 80 80 480 530 2024-06-28
13577 Chocolate Crumble Muffin 13577 80 80 480 530 2024-06-28
13578 Pancakes 13578 80 80 580 630 2024-06-28
13579 Almond Croissant 13579 80 80 500 550 2024-06-28
13580 Buttery Croissant 13580 80 80 430 460 2024-06-28
13581 Chocolate Croissant 13581 80 80 470 520 2024-06-28
13582 Creamy Chicken Foldover 13582 80 80 580 630 2024-06-28
13583 Sausage Roll 13583 80 80 580 630 2024-06-28
13584 Buttery Scone 13584 80 80 430 460 2024-06-28
13585 Country Chicken Pie 13585 80 80 720 770 2024-06-28
13586 Deep Dish Beef Pie 13586 80 80 720 770 2024-06-28
13587 Spinach & Mushroom Quiche 13587 80 80 720 770 2024-06-28
13588 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 13588 80 80 420 450 2024-06-28
13589 Mixed Nuts 13589 80 80 520 570 2024-06-28
13590 Caramel Waffles 13590 80 80 420 450 2024-06-28
13591 Chicken Ham & Cheese Panwich 13591 80 80 720 770 2024-06-28
13592 Egg Mayo & Cheese Multigrain Croissant 13592 80 80 720 770 2024-06-28
13593 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 13593 80 80 720 770 2024-06-28
13594 Rosemary Chicken & Emmental Cheese Croissant 13594 80 80 720 770 2024-06-28
13595 Scrambled Egg & Turkey Ham Pita 13595 80 80 720 770 2024-06-28
13596 Turkey Ham & Triple Cheese Toast 13596 80 80 720 770 2024-06-28
13597 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 13597 80 80 820 870 2024-06-28
13598 Ham & Cheese Croissant 13598 80 80 720 770 2024-06-28
13599 Sriracha Chicken Whole Wheat Pita 13599 80 80 780 830 2024-06-28
13600 Blueberry Acai Yogurt Parfait 13600 80 80 680 730 2024-06-28
13601 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 13601 80 80 680 730 2024-06-28
13602 Caramel Frappuccino® 13602 80 80 780 830 2024-06-28
13603 Dark Mocha Frappuccino® 13603 80 80 840 890 2024-06-28
13604 Java Chip Frappuccino® 13604 80 80 840 890 2024-06-28
13605 Mocha Frappuccino® 13605 80 80 780 830 2024-06-28
13606 Caramel Macchiato Frappuccino® 13606 80 80 840 890 2024-06-28
13607 Espresso Frappuccino® 13607 80 80 780 830 2024-06-28
13608 White Chocolate Mocha Frappuccino® 13608 80 80 780 830 2024-06-28
13609 Chocolate Chip Cream Frappuccino® 13609 80 80 840 890 2024-06-28
13610 Hojicha Tea Cream Frappuccino® 13610 80 80 820 870 2024-06-28
13611 Vanilla Cream Frappuccino® 13611 80 80 780 830 2024-06-28
13612 Mango Passion Fruit & Hibiscus 13612 80 80 780 830 2024-06-28
13613 Raspberry Black Currant & Oolong 13613 80 80 780 830 2024-06-28
13614 Coffee Traveller 13614 80 80 3600 3650 2024-06-28
13615 Caffè Americano 13615 80 80 600 650 2024-06-28
13616 Cappuccino 13616 80 80 740 790 2024-06-28
13617 Caffè Mocha 13617 80 80 830 880 2024-06-28
13618 Caramel Macchiato 13618 80 80 840 890 2024-06-28
13619 Espresso 13619 80 80 450 500 2024-06-28
13620 Caffè Latte 13620 80 80 740 790 2024-06-28
13621 Oatmilk Latte 13621 80 80 850 900 2024-06-28
13622 Vanilla Latte 13622 80 80 830 880 2024-06-28
13623 White Chocolate Mocha 13623 80 80 830 880 2024-06-28
13624 Flat White 13624 80 80 840 890 2024-06-28
13625 Ristretto Bianco 13625 80 80 840 890 2024-06-28
13626 Iced Caffè Americano 13626 80 80 600 650 2024-06-28
13627 Iced Cappuccino 13627 80 80 740 790 2024-06-28
13628 Iced Caffè Mocha 13628 80 80 830 880 2024-06-28
13629 Iced Caramel Macchiato 13629 80 80 840 890 2024-06-28
13630 Iced Caffè Latte 13630 80 80 740 790 2024-06-28
13631 Iced Oatmilk Latte 13631 80 80 850 900 2024-06-28
13632 Iced Vanilla Latte 13632 80 80 830 880 2024-06-28
13633 Iced White Chocolate Mocha 13633 80 80 830 880 2024-06-28
13634 Signature Hot Chocolate 13634 80 80 780 830 2024-06-28
13635 Signature Iced Chocolate 13635 80 80 780 830 2024-06-28
13636 Carrot Juice 13636 80 80 550 600 2024-06-28
13637 Cloudy Apple Juice 13637 80 80 550 600 2024-06-28
13638 Cranberry Red Grapefruit Juice 13638 80 80 550 600 2024-06-28
13639 Orange Juice 13639 80 80 550 600 2024-06-28
13640 Evian 13640 80 80 410 460 2024-06-28
13641 Sparkling Water 13641 80 80 510 560 2024-06-28
13642 Chai Tea 13642 80 80 560 610 2024-06-28
13643 Earl Grey Tea 13643 80 80 560 610 2024-06-28
13644 English Breakfast Tea 13644 80 80 560 610 2024-06-28
13645 Emperor’s Clouds & Mist™ Tea 13645 80 80 560 610 2024-06-28
13646 Mint Blend Tea 13646 80 80 560 610 2024-06-28
13647 Chamomile Tea 13647 80 80 560 610 2024-06-28
13648 Pure Matcha Latte 13648 80 80 810 860 2024-06-28
13649 Chai Tea Latte 13649 80 80 740 790 2024-06-28
13650 Earl Grey Tea Latte 13650 80 80 740 790 2024-06-28
13651 English Breakfast Tea Latte 13651 80 80 740 790 2024-06-28
13652 Hojicha Tea Latte 13652 80 80 810 860 2024-06-28
13653 Zen Clouds Oolong Tea 13653 80 80 560 610 2024-06-28
13654 Zen Clouds Oolong with Ruby Grapefruit and Honey 13654 80 80 690 740 2024-06-28
13655 Youthberry™ Tea 13655 80 80 560 610 2024-06-28
13656 Iced Shaken Black Tea Lemonade 13656 80 80 670 720 2024-06-28
13657 Iced Shaken Strawberry Black Tea Lemonade 13657 80 80 690 740 2024-06-28
13658 Iced Shaken Hibiscus Tea Lemonade 13658 80 80 670 720 2024-06-28
13659 Iced Shaken Hibiscus Tea with Pomegranate Pearls 13659 80 80 790 840 2024-06-28
13660 Iced Pure Matcha Latte 13660 80 80 810 860 2024-06-28
13661 Iced Chai Tea Latte 13661 80 80 740 790 2024-06-28
13662 Iced Black Tea Latte 13662 80 80 740 790 2024-06-28
13663 Iced Hojicha Tea Latte 13663 80 80 810 860 2024-06-28
13664 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 13664 80 80 690 740 2024-06-28
13665 Iced Shaken Zen Clouds Oolong Lemonade 13665 80 80 670 720 2024-06-28
13666 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 13666 80 80 690 740 2024-06-28
13667 Origami Pike Place® Roast 13667 80 80 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");