item_prices

Pricing information for Starbucks menu items in Singapore

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

249 rows where store_id = 54

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 54 · 249 ✖
id ▼ item_id store_id base_price delivery_price effective_date
17787 Bagel 17787 54 54 400 430 2024-06-28
17788 Cookie Crumble Cheesecake 17788 54 54 720 770 2024-06-28
17789 Good Ol' NY Cheesecake 17789 54 54 720 770 2024-06-28
17790 Signature Chocolate Cake 17790 54 54 720 770 2024-06-28
17791 Starbucks® Coffee Tiramisu Cake 17791 54 54 750 800 2024-06-28
17792 Strawberry Shortcake 17792 54 54 720 770 2024-06-28
17793 Chocolate Chunk Monster Cookie 17793 54 54 390 440 2024-06-28
17794 Banana Walnut Muffin 17794 54 54 450 500 2024-06-28
17795 Blueberry Crumble Muffin 17795 54 54 450 500 2024-06-28
17796 Chocolate Crumble Muffin 17796 54 54 450 500 2024-06-28
17797 Pancakes 17797 54 54 550 600 2024-06-28
17798 Almond Croissant 17798 54 54 470 520 2024-06-28
17799 Buttery Croissant 17799 54 54 400 430 2024-06-28
17800 Chocolate Croissant 17800 54 54 440 490 2024-06-28
17801 Creamy Chicken Foldover 17801 54 54 550 600 2024-06-28
17802 Sausage Roll 17802 54 54 550 600 2024-06-28
17803 Buttery Scone 17803 54 54 400 430 2024-06-28
17804 Country Chicken Pie 17804 54 54 690 740 2024-06-28
17805 Deep Dish Beef Pie 17805 54 54 690 740 2024-06-28
17806 Spinach & Mushroom Quiche 17806 54 54 690 740 2024-06-28
17807 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 17807 54 54 390 420 2024-06-28
17808 Mixed Nuts 17808 54 54 490 540 2024-06-28
17809 Caramel Waffles 17809 54 54 390 420 2024-06-28
17810 Chicken Ham & Cheese Panwich 17810 54 54 690 740 2024-06-28
17811 Egg Mayo & Cheese Multigrain Croissant 17811 54 54 690 740 2024-06-28
17812 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 17812 54 54 690 740 2024-06-28
17813 Rosemary Chicken & Emmental Cheese Croissant 17813 54 54 690 740 2024-06-28
17814 Scrambled Egg & Turkey Ham Pita 17814 54 54 690 740 2024-06-28
17815 Turkey Ham & Triple Cheese Toast 17815 54 54 690 740 2024-06-28
17816 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 17816 54 54 790 840 2024-06-28
17817 Ham & Cheese Croissant 17817 54 54 690 740 2024-06-28
17818 Sriracha Chicken Whole Wheat Pita 17818 54 54 750 800 2024-06-28
17819 Blueberry Acai Yogurt Parfait 17819 54 54 650 700 2024-06-28
17820 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 17820 54 54 650 700 2024-06-28
17821 Caramel Frappuccino® 17821 54 54 720 770 2024-06-28
17822 Dark Mocha Frappuccino® 17822 54 54 780 830 2024-06-28
17823 Java Chip Frappuccino® 17823 54 54 780 830 2024-06-28
17824 Mocha Frappuccino® 17824 54 54 720 770 2024-06-28
17825 Caramel Macchiato Frappuccino® 17825 54 54 780 830 2024-06-28
17826 Espresso Frappuccino® 17826 54 54 720 770 2024-06-28
17827 White Chocolate Mocha Frappuccino® 17827 54 54 720 770 2024-06-28
17828 Chocolate Chip Cream Frappuccino® 17828 54 54 780 830 2024-06-28
17829 Hojicha Tea Cream Frappuccino® 17829 54 54 760 810 2024-06-28
17830 Vanilla Cream Frappuccino® 17830 54 54 720 770 2024-06-28
17831 Mango Passion Fruit & Hibiscus 17831 54 54 720 770 2024-06-28
17832 Raspberry Black Currant & Oolong 17832 54 54 720 770 2024-06-28
17833 Coffee Traveller 17833 54 54 3120 3170 2024-06-28
17834 Caffè Americano 17834 54 54 540 590 2024-06-28
17835 Cappuccino 17835 54 54 680 730 2024-06-28
17836 Caffè Mocha 17836 54 54 750 800 2024-06-28
17837 Caramel Macchiato 17837 54 54 760 810 2024-06-28
17838 Espresso 17838 54 54 390 440 2024-06-28
17839 Caffè Latte 17839 54 54 680 730 2024-06-28
17840 Oatmilk Latte 17840 54 54 760 810 2024-06-28
17841 Vanilla Latte 17841 54 54 750 800 2024-06-28
17842 White Chocolate Mocha 17842 54 54 750 800 2024-06-28
17843 Flat White 17843 54 54 760 810 2024-06-28
17844 Ristretto Bianco 17844 54 54 760 810 2024-06-28
17845 Iced Caffè Americano 17845 54 54 540 590 2024-06-28
17846 Iced Cappuccino 17846 54 54 680 730 2024-06-28
17847 Iced Caffè Mocha 17847 54 54 750 800 2024-06-28
17848 Iced Caramel Macchiato 17848 54 54 760 810 2024-06-28
17849 Iced Caffè Latte 17849 54 54 680 730 2024-06-28
17850 Iced Oatmilk Latte 17850 54 54 760 810 2024-06-28
17851 Iced Vanilla Latte 17851 54 54 750 800 2024-06-28
17852 Iced White Chocolate Mocha 17852 54 54 750 800 2024-06-28
17853 Signature Hot Chocolate 17853 54 54 720 770 2024-06-28
17854 Signature Iced Chocolate 17854 54 54 720 770 2024-06-28
17855 Carrot Juice 17855 54 54 490 540 2024-06-28
17856 Cloudy Apple Juice 17856 54 54 490 540 2024-06-28
17857 Cranberry Red Grapefruit Juice 17857 54 54 490 540 2024-06-28
17858 Orange Juice 17858 54 54 490 540 2024-06-28
17859 Evian 17859 54 54 350 400 2024-06-28
17860 Sparkling Water 17860 54 54 450 500 2024-06-28
17861 Chai Tea 17861 54 54 500 550 2024-06-28
17862 Earl Grey Tea 17862 54 54 500 550 2024-06-28
17863 English Breakfast Tea 17863 54 54 500 550 2024-06-28
17864 Emperor’s Clouds & Mist™ Tea 17864 54 54 500 550 2024-06-28
17865 Mint Blend Tea 17865 54 54 500 550 2024-06-28
17866 Chamomile Tea 17866 54 54 500 550 2024-06-28
17867 Pure Matcha Latte 17867 54 54 740 790 2024-06-28
17868 Chai Tea Latte 17868 54 54 680 730 2024-06-28
17869 Earl Grey Tea Latte 17869 54 54 680 730 2024-06-28
17870 English Breakfast Tea Latte 17870 54 54 680 730 2024-06-28
17871 Hojicha Tea Latte 17871 54 54 740 790 2024-06-28
17872 Zen Clouds Oolong Tea 17872 54 54 500 550 2024-06-28
17873 Zen Clouds Oolong with Ruby Grapefruit and Honey 17873 54 54 630 680 2024-06-28
17874 Youthberry™ Tea 17874 54 54 500 550 2024-06-28
17875 Iced Shaken Black Tea Lemonade 17875 54 54 610 660 2024-06-28
17876 Iced Shaken Strawberry Black Tea Lemonade 17876 54 54 630 680 2024-06-28
17877 Iced Shaken Hibiscus Tea Lemonade 17877 54 54 610 660 2024-06-28
17878 Iced Shaken Hibiscus Tea with Pomegranate Pearls 17878 54 54 730 780 2024-06-28
17879 Iced Pure Matcha Latte 17879 54 54 740 790 2024-06-28
17880 Iced Chai Tea Latte 17880 54 54 680 730 2024-06-28
17881 Iced Black Tea Latte 17881 54 54 680 730 2024-06-28
17882 Iced Hojicha Tea Latte 17882 54 54 740 790 2024-06-28
17883 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 17883 54 54 630 680 2024-06-28
17884 Iced Shaken Zen Clouds Oolong Lemonade 17884 54 54 610 660 2024-06-28
17885 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 17885 54 54 630 680 2024-06-28
17886 Origami Pike Place® Roast 17886 54 54 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");