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 = 86

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 86 · 248 ✖
id ▼ item_id store_id base_price delivery_price effective_date
12840 Bagel 12840 86 86 400 430 2024-06-28
12841 Cookie Crumble Cheesecake 12841 86 86 720 770 2024-06-28
12842 Good Ol' NY Cheesecake 12842 86 86 720 770 2024-06-28
12843 Signature Chocolate Cake 12843 86 86 720 770 2024-06-28
12844 Starbucks® Coffee Tiramisu Cake 12844 86 86 750 800 2024-06-28
12845 Strawberry Shortcake 12845 86 86 720 770 2024-06-28
12846 Chocolate Chunk Monster Cookie 12846 86 86 390 440 2024-06-28
12847 Banana Walnut Muffin 12847 86 86 450 500 2024-06-28
12848 Blueberry Crumble Muffin 12848 86 86 450 500 2024-06-28
12849 Chocolate Crumble Muffin 12849 86 86 450 500 2024-06-28
12850 Pancakes 12850 86 86 550 600 2024-06-28
12851 Almond Croissant 12851 86 86 470 520 2024-06-28
12852 Buttery Croissant 12852 86 86 400 430 2024-06-28
12853 Chocolate Croissant 12853 86 86 440 490 2024-06-28
12854 Creamy Chicken Foldover 12854 86 86 550 600 2024-06-28
12855 Sausage Roll 12855 86 86 550 600 2024-06-28
12856 Buttery Scone 12856 86 86 400 430 2024-06-28
12857 Country Chicken Pie 12857 86 86 690 740 2024-06-28
12858 Deep Dish Beef Pie 12858 86 86 690 740 2024-06-28
12859 Spinach & Mushroom Quiche 12859 86 86 690 740 2024-06-28
12860 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 12860 86 86 390 420 2024-06-28
12861 Mixed Nuts 12861 86 86 490 540 2024-06-28
12862 Caramel Waffles 12862 86 86 390 420 2024-06-28
12863 Chicken Ham & Cheese Panwich 12863 86 86 690 740 2024-06-28
12864 Egg Mayo & Cheese Multigrain Croissant 12864 86 86 690 740 2024-06-28
12865 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 12865 86 86 690 740 2024-06-28
12866 Rosemary Chicken & Emmental Cheese Croissant 12866 86 86 690 740 2024-06-28
12867 Scrambled Egg & Turkey Ham Pita 12867 86 86 690 740 2024-06-28
12868 Turkey Ham & Triple Cheese Toast 12868 86 86 690 740 2024-06-28
12869 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 12869 86 86 790 840 2024-06-28
12870 Ham & Cheese Croissant 12870 86 86 690 740 2024-06-28
12871 Sriracha Chicken Whole Wheat Pita 12871 86 86 750 800 2024-06-28
12872 Blueberry Acai Yogurt Parfait 12872 86 86 650 700 2024-06-28
12873 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 12873 86 86 650 700 2024-06-28
12874 Caramel Frappuccino® 12874 86 86 720 770 2024-06-28
12875 Dark Mocha Frappuccino® 12875 86 86 780 830 2024-06-28
12876 Java Chip Frappuccino® 12876 86 86 780 830 2024-06-28
12877 Mocha Frappuccino® 12877 86 86 720 770 2024-06-28
12878 Caramel Macchiato Frappuccino® 12878 86 86 780 830 2024-06-28
12879 Espresso Frappuccino® 12879 86 86 720 770 2024-06-28
12880 White Chocolate Mocha Frappuccino® 12880 86 86 720 770 2024-06-28
12881 Chocolate Chip Cream Frappuccino® 12881 86 86 780 830 2024-06-28
12882 Hojicha Tea Cream Frappuccino® 12882 86 86 760 810 2024-06-28
12883 Vanilla Cream Frappuccino® 12883 86 86 720 770 2024-06-28
12884 Mango Passion Fruit & Hibiscus 12884 86 86 720 770 2024-06-28
12885 Raspberry Black Currant & Oolong 12885 86 86 720 770 2024-06-28
12886 Coffee Traveller 12886 86 86 3120 3170 2024-06-28
12887 Caffè Americano 12887 86 86 540 590 2024-06-28
12888 Cappuccino 12888 86 86 680 730 2024-06-28
12889 Caffè Mocha 12889 86 86 750 800 2024-06-28
12890 Caramel Macchiato 12890 86 86 760 810 2024-06-28
12891 Espresso 12891 86 86 390 440 2024-06-28
12892 Caffè Latte 12892 86 86 680 730 2024-06-28
12893 Oatmilk Latte 12893 86 86 760 810 2024-06-28
12894 Vanilla Latte 12894 86 86 750 800 2024-06-28
12895 White Chocolate Mocha 12895 86 86 750 800 2024-06-28
12896 Flat White 12896 86 86 760 810 2024-06-28
12897 Ristretto Bianco 12897 86 86 760 810 2024-06-28
12898 Iced Caffè Americano 12898 86 86 540 590 2024-06-28
12899 Iced Cappuccino 12899 86 86 680 730 2024-06-28
12900 Iced Caffè Mocha 12900 86 86 750 800 2024-06-28
12901 Iced Caramel Macchiato 12901 86 86 760 810 2024-06-28
12902 Iced Caffè Latte 12902 86 86 680 730 2024-06-28
12903 Iced Oatmilk Latte 12903 86 86 760 810 2024-06-28
12904 Iced Vanilla Latte 12904 86 86 750 800 2024-06-28
12905 Iced White Chocolate Mocha 12905 86 86 750 800 2024-06-28
12906 Signature Hot Chocolate 12906 86 86 720 770 2024-06-28
12907 Signature Iced Chocolate 12907 86 86 720 770 2024-06-28
12908 Carrot Juice 12908 86 86 490 540 2024-06-28
12909 Cloudy Apple Juice 12909 86 86 490 540 2024-06-28
12910 Cranberry Red Grapefruit Juice 12910 86 86 490 540 2024-06-28
12911 Orange Juice 12911 86 86 490 540 2024-06-28
12912 Evian 12912 86 86 350 400 2024-06-28
12913 Sparkling Water 12913 86 86 450 500 2024-06-28
12914 Chai Tea 12914 86 86 500 550 2024-06-28
12915 Earl Grey Tea 12915 86 86 500 550 2024-06-28
12916 English Breakfast Tea 12916 86 86 500 550 2024-06-28
12917 Emperor’s Clouds & Mist™ Tea 12917 86 86 500 550 2024-06-28
12918 Mint Blend Tea 12918 86 86 500 550 2024-06-28
12919 Chamomile Tea 12919 86 86 500 550 2024-06-28
12920 Pure Matcha Latte 12920 86 86 740 790 2024-06-28
12921 Chai Tea Latte 12921 86 86 680 730 2024-06-28
12922 Earl Grey Tea Latte 12922 86 86 680 730 2024-06-28
12923 English Breakfast Tea Latte 12923 86 86 680 730 2024-06-28
12924 Hojicha Tea Latte 12924 86 86 740 790 2024-06-28
12925 Zen Clouds Oolong Tea 12925 86 86 500 550 2024-06-28
12926 Zen Clouds Oolong with Ruby Grapefruit and Honey 12926 86 86 630 680 2024-06-28
12927 Youthberry™ Tea 12927 86 86 500 550 2024-06-28
12928 Iced Shaken Black Tea Lemonade 12928 86 86 610 660 2024-06-28
12929 Iced Shaken Strawberry Black Tea Lemonade 12929 86 86 630 680 2024-06-28
12930 Iced Shaken Hibiscus Tea Lemonade 12930 86 86 610 660 2024-06-28
12931 Iced Shaken Hibiscus Tea with Pomegranate Pearls 12931 86 86 730 780 2024-06-28
12932 Iced Pure Matcha Latte 12932 86 86 740 790 2024-06-28
12933 Iced Chai Tea Latte 12933 86 86 680 730 2024-06-28
12934 Iced Black Tea Latte 12934 86 86 680 730 2024-06-28
12935 Iced Hojicha Tea Latte 12935 86 86 740 790 2024-06-28
12936 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 12936 86 86 630 680 2024-06-28
12937 Iced Shaken Zen Clouds Oolong Lemonade 12937 86 86 610 660 2024-06-28
12938 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 12938 86 86 630 680 2024-06-28
12939 Origami Pike Place® Roast 12939 86 86 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");