item_prices

Pricing information for Starbucks menu items in Singapore

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

182 rows where effective_date = "2024-06-28" and store_id = 123

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 123 · 182 ✖

effective_date 1

  • 2024-06-28 · 182 ✖
id ▼ item_id store_id base_price delivery_price effective_date
1845 Bagel 1845 123 123 400 430 2024-06-28
1846 Cookie Crumble Cheesecake 1846 123 123 720 770 2024-06-28
1847 Good Ol' NY Cheesecake 1847 123 123 720 770 2024-06-28
1848 Signature Chocolate Cake 1848 123 123 720 770 2024-06-28
1849 Starbucks® Coffee Tiramisu Cake 1849 123 123 750 800 2024-06-28
1850 Strawberry Shortcake 1850 123 123 720 770 2024-06-28
1851 Chocolate Chunk Monster Cookie 1851 123 123 390 440 2024-06-28
1852 Banana Walnut Muffin 1852 123 123 450 500 2024-06-28
1853 Blueberry Crumble Muffin 1853 123 123 450 500 2024-06-28
1854 Chocolate Crumble Muffin 1854 123 123 450 500 2024-06-28
1855 Pancakes 1855 123 123 550 600 2024-06-28
1856 Almond Croissant 1856 123 123 470 520 2024-06-28
1857 Buttery Croissant 1857 123 123 400 430 2024-06-28
1858 Chocolate Croissant 1858 123 123 440 490 2024-06-28
1859 Creamy Chicken Foldover 1859 123 123 550 600 2024-06-28
1860 Sausage Roll 1860 123 123 550 600 2024-06-28
1861 Buttery Scone 1861 123 123 400 430 2024-06-28
1862 Country Chicken Pie 1862 123 123 690 740 2024-06-28
1863 Deep Dish Beef Pie 1863 123 123 690 740 2024-06-28
1864 Spinach & Mushroom Quiche 1864 123 123 690 740 2024-06-28
1865 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 1865 123 123 390 420 2024-06-28
1866 Mixed Nuts 1866 123 123 490 540 2024-06-28
1867 Caramel Waffles 1867 123 123 390 420 2024-06-28
1868 Chicken Ham & Cheese Panwich 1868 123 123 690 740 2024-06-28
1869 Egg Mayo & Cheese Multigrain Croissant 1869 123 123 690 740 2024-06-28
1870 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 1870 123 123 690 740 2024-06-28
1871 Rosemary Chicken & Emmental Cheese Croissant 1871 123 123 690 740 2024-06-28
1872 Scrambled Egg & Turkey Ham Pita 1872 123 123 690 740 2024-06-28
1873 Turkey Ham & Triple Cheese Toast 1873 123 123 690 740 2024-06-28
1874 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 1874 123 123 790 840 2024-06-28
1875 Ham & Cheese Croissant 1875 123 123 690 740 2024-06-28
1876 Sriracha Chicken Whole Wheat Pita 1876 123 123 750 800 2024-06-28
1877 Blueberry Acai Yogurt Parfait 1877 123 123 650 700 2024-06-28
1878 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 1878 123 123 650 700 2024-06-28
1879 Caramel Frappuccino® 1879 123 123 720 770 2024-06-28
1880 Dark Mocha Frappuccino® 1880 123 123 780 830 2024-06-28
1881 Java Chip Frappuccino® 1881 123 123 780 830 2024-06-28
1882 Mocha Frappuccino® 1882 123 123 720 770 2024-06-28
1883 Caramel Macchiato Frappuccino® 1883 123 123 780 830 2024-06-28
1884 Espresso Frappuccino® 1884 123 123 720 770 2024-06-28
1885 White Chocolate Mocha Frappuccino® 1885 123 123 720 770 2024-06-28
1886 Chocolate Chip Cream Frappuccino® 1886 123 123 780 830 2024-06-28
1887 Hojicha Tea Cream Frappuccino® 1887 123 123 760 810 2024-06-28
1888 Vanilla Cream Frappuccino® 1888 123 123 720 770 2024-06-28
1889 Mango Passion Fruit & Hibiscus 1889 123 123 720 770 2024-06-28
1890 Raspberry Black Currant & Oolong 1890 123 123 720 770 2024-06-28
1891 Coffee Traveller 1891 123 123 3120 3170 2024-06-28
1892 Caffè Americano 1892 123 123 540 590 2024-06-28
1893 Cappuccino 1893 123 123 680 730 2024-06-28
1894 Caffè Mocha 1894 123 123 750 800 2024-06-28
1895 Caramel Macchiato 1895 123 123 760 810 2024-06-28
1896 Espresso 1896 123 123 390 440 2024-06-28
1897 Caffè Latte 1897 123 123 680 730 2024-06-28
1898 Oatmilk Latte 1898 123 123 760 810 2024-06-28
1899 Vanilla Latte 1899 123 123 750 800 2024-06-28
1900 White Chocolate Mocha 1900 123 123 750 800 2024-06-28
1901 Flat White 1901 123 123 760 810 2024-06-28
1902 Ristretto Bianco 1902 123 123 760 810 2024-06-28
1903 Iced Caffè Americano 1903 123 123 540 590 2024-06-28
1904 Iced Cappuccino 1904 123 123 680 730 2024-06-28
1905 Iced Caffè Mocha 1905 123 123 750 800 2024-06-28
1906 Iced Caramel Macchiato 1906 123 123 760 810 2024-06-28
1907 Iced Caffè Latte 1907 123 123 680 730 2024-06-28
1908 Iced Oatmilk Latte 1908 123 123 760 810 2024-06-28
1909 Iced Vanilla Latte 1909 123 123 750 800 2024-06-28
1910 Iced White Chocolate Mocha 1910 123 123 750 800 2024-06-28
1911 Signature Hot Chocolate 1911 123 123 720 770 2024-06-28
1912 Signature Iced Chocolate 1912 123 123 720 770 2024-06-28
1913 Carrot Juice 1913 123 123 490 540 2024-06-28
1914 Cloudy Apple Juice 1914 123 123 490 540 2024-06-28
1915 Cranberry Red Grapefruit Juice 1915 123 123 490 540 2024-06-28
1916 Orange Juice 1916 123 123 490 540 2024-06-28
1917 Evian 1917 123 123 350 400 2024-06-28
1918 Sparkling Water 1918 123 123 450 500 2024-06-28
1919 Chai Tea 1919 123 123 500 550 2024-06-28
1920 Earl Grey Tea 1920 123 123 500 550 2024-06-28
1921 English Breakfast Tea 1921 123 123 500 550 2024-06-28
1922 Emperor’s Clouds & Mist™ Tea 1922 123 123 500 550 2024-06-28
1923 Mint Blend Tea 1923 123 123 500 550 2024-06-28
1924 Chamomile Tea 1924 123 123 500 550 2024-06-28
1925 Pure Matcha Latte 1925 123 123 740 790 2024-06-28
1926 Chai Tea Latte 1926 123 123 680 730 2024-06-28
1927 Earl Grey Tea Latte 1927 123 123 680 730 2024-06-28
1928 English Breakfast Tea Latte 1928 123 123 680 730 2024-06-28
1929 Hojicha Tea Latte 1929 123 123 740 790 2024-06-28
1930 Zen Clouds Oolong Tea 1930 123 123 500 550 2024-06-28
1931 Zen Clouds Oolong with Ruby Grapefruit and Honey 1931 123 123 630 680 2024-06-28
1932 Youthberry™ Tea 1932 123 123 500 550 2024-06-28
1933 Iced Shaken Black Tea Lemonade 1933 123 123 610 660 2024-06-28
1934 Iced Shaken Strawberry Black Tea Lemonade 1934 123 123 630 680 2024-06-28
1935 Iced Shaken Hibiscus Tea Lemonade 1935 123 123 610 660 2024-06-28
1936 Iced Shaken Hibiscus Tea with Pomegranate Pearls 1936 123 123 730 780 2024-06-28
1937 Iced Pure Matcha Latte 1937 123 123 740 790 2024-06-28
1938 Iced Chai Tea Latte 1938 123 123 680 730 2024-06-28
1939 Iced Black Tea Latte 1939 123 123 680 730 2024-06-28
1940 Iced Hojicha Tea Latte 1940 123 123 740 790 2024-06-28
1941 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 1941 123 123 630 680 2024-06-28
1942 Iced Shaken Zen Clouds Oolong Lemonade 1942 123 123 610 660 2024-06-28
1943 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 1943 123 123 630 680 2024-06-28
1944 Origami Pike Place® Roast 1944 123 123 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");