item_prices

Pricing information for Starbucks menu items in Singapore

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

229 rows where store_id = 92

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 92 · 229 ✖
id ▼ item_id store_id base_price delivery_price effective_date
11718 Bagel 11718 92 92 400 430 2024-06-28
11719 Cookie Crumble Cheesecake 11719 92 92 720 770 2024-06-28
11720 Good Ol' NY Cheesecake 11720 92 92 720 770 2024-06-28
11721 Signature Chocolate Cake 11721 92 92 720 770 2024-06-28
11722 Starbucks® Coffee Tiramisu Cake 11722 92 92 750 800 2024-06-28
11723 Strawberry Shortcake 11723 92 92 720 770 2024-06-28
11724 Chocolate Chunk Monster Cookie 11724 92 92 390 440 2024-06-28
11725 Banana Walnut Muffin 11725 92 92 450 500 2024-06-28
11726 Blueberry Crumble Muffin 11726 92 92 450 500 2024-06-28
11727 Chocolate Crumble Muffin 11727 92 92 450 500 2024-06-28
11728 Pancakes 11728 92 92 550 600 2024-06-28
11729 Almond Croissant 11729 92 92 470 520 2024-06-28
11730 Buttery Croissant 11730 92 92 400 430 2024-06-28
11731 Chocolate Croissant 11731 92 92 440 490 2024-06-28
11732 Creamy Chicken Foldover 11732 92 92 550 600 2024-06-28
11733 Sausage Roll 11733 92 92 550 600 2024-06-28
11734 Buttery Scone 11734 92 92 400 430 2024-06-28
11735 Country Chicken Pie 11735 92 92 690 740 2024-06-28
11736 Deep Dish Beef Pie 11736 92 92 690 740 2024-06-28
11737 Spinach & Mushroom Quiche 11737 92 92 690 740 2024-06-28
11738 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 11738 92 92 390 420 2024-06-28
11739 Mixed Nuts 11739 92 92 490 540 2024-06-28
11740 Caramel Waffles 11740 92 92 390 420 2024-06-28
11741 Chicken Ham & Cheese Panwich 11741 92 92 690 740 2024-06-28
11742 Egg Mayo & Cheese Multigrain Croissant 11742 92 92 690 740 2024-06-28
11743 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 11743 92 92 690 740 2024-06-28
11744 Rosemary Chicken & Emmental Cheese Croissant 11744 92 92 690 740 2024-06-28
11745 Scrambled Egg & Turkey Ham Pita 11745 92 92 690 740 2024-06-28
11746 Turkey Ham & Triple Cheese Toast 11746 92 92 690 740 2024-06-28
11747 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 11747 92 92 790 840 2024-06-28
11748 Ham & Cheese Croissant 11748 92 92 690 740 2024-06-28
11749 Sriracha Chicken Whole Wheat Pita 11749 92 92 750 800 2024-06-28
11750 Blueberry Acai Yogurt Parfait 11750 92 92 650 700 2024-06-28
11751 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 11751 92 92 650 700 2024-06-28
11752 Caramel Frappuccino® 11752 92 92 720 770 2024-06-28
11753 Dark Mocha Frappuccino® 11753 92 92 780 830 2024-06-28
11754 Java Chip Frappuccino® 11754 92 92 780 830 2024-06-28
11755 Mocha Frappuccino® 11755 92 92 720 770 2024-06-28
11756 Caramel Macchiato Frappuccino® 11756 92 92 780 830 2024-06-28
11757 Espresso Frappuccino® 11757 92 92 720 770 2024-06-28
11758 White Chocolate Mocha Frappuccino® 11758 92 92 720 770 2024-06-28
11759 Chocolate Chip Cream Frappuccino® 11759 92 92 780 830 2024-06-28
11760 Hojicha Tea Cream Frappuccino® 11760 92 92 760 810 2024-06-28
11761 Vanilla Cream Frappuccino® 11761 92 92 720 770 2024-06-28
11762 Mango Passion Fruit & Hibiscus 11762 92 92 720 770 2024-06-28
11763 Raspberry Black Currant & Oolong 11763 92 92 720 770 2024-06-28
11764 Coffee Traveller 11764 92 92 3120 3170 2024-06-28
11765 Caffè Americano 11765 92 92 540 590 2024-06-28
11766 Cappuccino 11766 92 92 680 730 2024-06-28
11767 Caffè Mocha 11767 92 92 750 800 2024-06-28
11768 Caramel Macchiato 11768 92 92 760 810 2024-06-28
11769 Espresso 11769 92 92 390 440 2024-06-28
11770 Caffè Latte 11770 92 92 680 730 2024-06-28
11771 Oatmilk Latte 11771 92 92 760 810 2024-06-28
11772 Vanilla Latte 11772 92 92 750 800 2024-06-28
11773 White Chocolate Mocha 11773 92 92 750 800 2024-06-28
11774 Flat White 11774 92 92 760 810 2024-06-28
11775 Ristretto Bianco 11775 92 92 760 810 2024-06-28
11776 Iced Caffè Americano 11776 92 92 540 590 2024-06-28
11777 Iced Cappuccino 11777 92 92 680 730 2024-06-28
11778 Iced Caffè Mocha 11778 92 92 750 800 2024-06-28
11779 Iced Caramel Macchiato 11779 92 92 760 810 2024-06-28
11780 Iced Caffè Latte 11780 92 92 680 730 2024-06-28
11781 Iced Oatmilk Latte 11781 92 92 760 810 2024-06-28
11782 Iced Vanilla Latte 11782 92 92 750 800 2024-06-28
11783 Iced White Chocolate Mocha 11783 92 92 750 800 2024-06-28
11784 Signature Hot Chocolate 11784 92 92 720 770 2024-06-28
11785 Signature Iced Chocolate 11785 92 92 720 770 2024-06-28
11786 Carrot Juice 11786 92 92 490 540 2024-06-28
11787 Cloudy Apple Juice 11787 92 92 490 540 2024-06-28
11788 Cranberry Red Grapefruit Juice 11788 92 92 490 540 2024-06-28
11789 Orange Juice 11789 92 92 490 540 2024-06-28
11790 Evian 11790 92 92 350 400 2024-06-28
11791 Sparkling Water 11791 92 92 450 500 2024-06-28
11792 Chai Tea 11792 92 92 500 550 2024-06-28
11793 Earl Grey Tea 11793 92 92 500 550 2024-06-28
11794 English Breakfast Tea 11794 92 92 500 550 2024-06-28
11795 Emperor’s Clouds & Mist™ Tea 11795 92 92 500 550 2024-06-28
11796 Mint Blend Tea 11796 92 92 500 550 2024-06-28
11797 Chamomile Tea 11797 92 92 500 550 2024-06-28
11798 Pure Matcha Latte 11798 92 92 740 790 2024-06-28
11799 Chai Tea Latte 11799 92 92 680 730 2024-06-28
11800 Earl Grey Tea Latte 11800 92 92 680 730 2024-06-28
11801 English Breakfast Tea Latte 11801 92 92 680 730 2024-06-28
11802 Hojicha Tea Latte 11802 92 92 740 790 2024-06-28
11803 Zen Clouds Oolong Tea 11803 92 92 500 550 2024-06-28
11804 Zen Clouds Oolong with Ruby Grapefruit and Honey 11804 92 92 630 680 2024-06-28
11805 Youthberry™ Tea 11805 92 92 500 550 2024-06-28
11806 Iced Shaken Black Tea Lemonade 11806 92 92 610 660 2024-06-28
11807 Iced Shaken Strawberry Black Tea Lemonade 11807 92 92 630 680 2024-06-28
11808 Iced Shaken Hibiscus Tea Lemonade 11808 92 92 610 660 2024-06-28
11809 Iced Shaken Hibiscus Tea with Pomegranate Pearls 11809 92 92 730 780 2024-06-28
11810 Iced Pure Matcha Latte 11810 92 92 740 790 2024-06-28
11811 Iced Chai Tea Latte 11811 92 92 680 730 2024-06-28
11812 Iced Black Tea Latte 11812 92 92 680 730 2024-06-28
11813 Iced Hojicha Tea Latte 11813 92 92 740 790 2024-06-28
11814 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 11814 92 92 630 680 2024-06-28
11815 Iced Shaken Zen Clouds Oolong Lemonade 11815 92 92 610 660 2024-06-28
11816 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 11816 92 92 630 680 2024-06-28
11817 Origami Pike Place® Roast 11817 92 92 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");