item_prices

Pricing information for Starbucks menu items in Singapore

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

238 rows where store_id = 35

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 35 · 238 ✖
id ▼ item_id store_id base_price delivery_price effective_date
20703 Bagel 20703 35 35 400 430 2024-06-28
20704 Cookie Crumble Cheesecake 20704 35 35 720 770 2024-06-28
20705 Good Ol' NY Cheesecake 20705 35 35 720 770 2024-06-28
20706 Signature Chocolate Cake 20706 35 35 720 770 2024-06-28
20707 Starbucks® Coffee Tiramisu Cake 20707 35 35 750 800 2024-06-28
20708 Strawberry Shortcake 20708 35 35 720 770 2024-06-28
20709 Chocolate Chunk Monster Cookie 20709 35 35 390 440 2024-06-28
20710 Banana Walnut Muffin 20710 35 35 450 500 2024-06-28
20711 Blueberry Crumble Muffin 20711 35 35 450 500 2024-06-28
20712 Chocolate Crumble Muffin 20712 35 35 450 500 2024-06-28
20713 Pancakes 20713 35 35 550 600 2024-06-28
20714 Almond Croissant 20714 35 35 470 520 2024-06-28
20715 Buttery Croissant 20715 35 35 400 430 2024-06-28
20716 Chocolate Croissant 20716 35 35 440 490 2024-06-28
20717 Creamy Chicken Foldover 20717 35 35 550 600 2024-06-28
20718 Sausage Roll 20718 35 35 550 600 2024-06-28
20719 Buttery Scone 20719 35 35 400 430 2024-06-28
20720 Country Chicken Pie 20720 35 35 690 740 2024-06-28
20721 Deep Dish Beef Pie 20721 35 35 690 740 2024-06-28
20722 Spinach & Mushroom Quiche 20722 35 35 690 740 2024-06-28
20723 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 20723 35 35 390 420 2024-06-28
20724 Mixed Nuts 20724 35 35 490 540 2024-06-28
20725 Caramel Waffles 20725 35 35 390 420 2024-06-28
20726 Chicken Ham & Cheese Panwich 20726 35 35 690 740 2024-06-28
20727 Egg Mayo & Cheese Multigrain Croissant 20727 35 35 690 740 2024-06-28
20728 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 20728 35 35 690 740 2024-06-28
20729 Rosemary Chicken & Emmental Cheese Croissant 20729 35 35 690 740 2024-06-28
20730 Scrambled Egg & Turkey Ham Pita 20730 35 35 690 740 2024-06-28
20731 Turkey Ham & Triple Cheese Toast 20731 35 35 690 740 2024-06-28
20732 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 20732 35 35 790 840 2024-06-28
20733 Ham & Cheese Croissant 20733 35 35 690 740 2024-06-28
20734 Sriracha Chicken Whole Wheat Pita 20734 35 35 750 800 2024-06-28
20735 Blueberry Acai Yogurt Parfait 20735 35 35 650 700 2024-06-28
20736 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 20736 35 35 650 700 2024-06-28
20737 Caramel Frappuccino® 20737 35 35 720 770 2024-06-28
20738 Dark Mocha Frappuccino® 20738 35 35 780 830 2024-06-28
20739 Java Chip Frappuccino® 20739 35 35 780 830 2024-06-28
20740 Mocha Frappuccino® 20740 35 35 720 770 2024-06-28
20741 Caramel Macchiato Frappuccino® 20741 35 35 780 830 2024-06-28
20742 Espresso Frappuccino® 20742 35 35 720 770 2024-06-28
20743 White Chocolate Mocha Frappuccino® 20743 35 35 720 770 2024-06-28
20744 Chocolate Chip Cream Frappuccino® 20744 35 35 780 830 2024-06-28
20745 Hojicha Tea Cream Frappuccino® 20745 35 35 760 810 2024-06-28
20746 Vanilla Cream Frappuccino® 20746 35 35 720 770 2024-06-28
20747 Mango Passion Fruit & Hibiscus 20747 35 35 720 770 2024-06-28
20748 Raspberry Black Currant & Oolong 20748 35 35 720 770 2024-06-28
20749 Coffee Traveller 20749 35 35 3120 3170 2024-06-28
20750 Caffè Americano 20750 35 35 540 590 2024-06-28
20751 Cappuccino 20751 35 35 680 730 2024-06-28
20752 Caffè Mocha 20752 35 35 750 800 2024-06-28
20753 Caramel Macchiato 20753 35 35 760 810 2024-06-28
20754 Espresso 20754 35 35 390 440 2024-06-28
20755 Caffè Latte 20755 35 35 680 730 2024-06-28
20756 Oatmilk Latte 20756 35 35 760 810 2024-06-28
20757 Vanilla Latte 20757 35 35 750 800 2024-06-28
20758 White Chocolate Mocha 20758 35 35 750 800 2024-06-28
20759 Flat White 20759 35 35 760 810 2024-06-28
20760 Ristretto Bianco 20760 35 35 760 810 2024-06-28
20761 Iced Caffè Americano 20761 35 35 540 590 2024-06-28
20762 Iced Cappuccino 20762 35 35 680 730 2024-06-28
20763 Iced Caffè Mocha 20763 35 35 750 800 2024-06-28
20764 Iced Caramel Macchiato 20764 35 35 760 810 2024-06-28
20765 Iced Caffè Latte 20765 35 35 680 730 2024-06-28
20766 Iced Oatmilk Latte 20766 35 35 760 810 2024-06-28
20767 Iced Vanilla Latte 20767 35 35 750 800 2024-06-28
20768 Iced White Chocolate Mocha 20768 35 35 750 800 2024-06-28
20769 Signature Hot Chocolate 20769 35 35 720 770 2024-06-28
20770 Signature Iced Chocolate 20770 35 35 720 770 2024-06-28
20771 Carrot Juice 20771 35 35 490 540 2024-06-28
20772 Cloudy Apple Juice 20772 35 35 490 540 2024-06-28
20773 Cranberry Red Grapefruit Juice 20773 35 35 490 540 2024-06-28
20774 Orange Juice 20774 35 35 490 540 2024-06-28
20775 Evian 20775 35 35 350 400 2024-06-28
20776 Sparkling Water 20776 35 35 450 500 2024-06-28
20777 Chai Tea 20777 35 35 500 550 2024-06-28
20778 Earl Grey Tea 20778 35 35 500 550 2024-06-28
20779 English Breakfast Tea 20779 35 35 500 550 2024-06-28
20780 Emperor’s Clouds & Mist™ Tea 20780 35 35 500 550 2024-06-28
20781 Mint Blend Tea 20781 35 35 500 550 2024-06-28
20782 Chamomile Tea 20782 35 35 500 550 2024-06-28
20783 Pure Matcha Latte 20783 35 35 740 790 2024-06-28
20784 Chai Tea Latte 20784 35 35 680 730 2024-06-28
20785 Earl Grey Tea Latte 20785 35 35 680 730 2024-06-28
20786 English Breakfast Tea Latte 20786 35 35 680 730 2024-06-28
20787 Hojicha Tea Latte 20787 35 35 740 790 2024-06-28
20788 Zen Clouds Oolong Tea 20788 35 35 500 550 2024-06-28
20789 Zen Clouds Oolong with Ruby Grapefruit and Honey 20789 35 35 630 680 2024-06-28
20790 Youthberry™ Tea 20790 35 35 500 550 2024-06-28
20791 Iced Shaken Black Tea Lemonade 20791 35 35 610 660 2024-06-28
20792 Iced Shaken Strawberry Black Tea Lemonade 20792 35 35 630 680 2024-06-28
20793 Iced Shaken Hibiscus Tea Lemonade 20793 35 35 610 660 2024-06-28
20794 Iced Shaken Hibiscus Tea with Pomegranate Pearls 20794 35 35 730 780 2024-06-28
20795 Iced Pure Matcha Latte 20795 35 35 740 790 2024-06-28
20796 Iced Chai Tea Latte 20796 35 35 680 730 2024-06-28
20797 Iced Black Tea Latte 20797 35 35 680 730 2024-06-28
20798 Iced Hojicha Tea Latte 20798 35 35 740 790 2024-06-28
20799 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 20799 35 35 630 680 2024-06-28
20800 Iced Shaken Zen Clouds Oolong Lemonade 20800 35 35 610 660 2024-06-28
20801 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 20801 35 35 630 680 2024-06-28
20802 Origami Pike Place® Roast 20802 35 35 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");