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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 59 · 182 ✖

effective_date 1

  • 2024-06-28 · 182 ✖
id ▼ item_id store_id base_price delivery_price effective_date
16859 Bagel 16859 59 59 400 430 2024-06-28
16860 Cookie Crumble Cheesecake 16860 59 59 720 770 2024-06-28
16861 Good Ol' NY Cheesecake 16861 59 59 720 770 2024-06-28
16862 Signature Chocolate Cake 16862 59 59 720 770 2024-06-28
16863 Starbucks® Coffee Tiramisu Cake 16863 59 59 750 800 2024-06-28
16864 Strawberry Shortcake 16864 59 59 720 770 2024-06-28
16865 Chocolate Chunk Monster Cookie 16865 59 59 390 440 2024-06-28
16866 Banana Walnut Muffin 16866 59 59 450 500 2024-06-28
16867 Blueberry Crumble Muffin 16867 59 59 450 500 2024-06-28
16868 Chocolate Crumble Muffin 16868 59 59 450 500 2024-06-28
16869 Pancakes 16869 59 59 550 600 2024-06-28
16870 Almond Croissant 16870 59 59 470 520 2024-06-28
16871 Buttery Croissant 16871 59 59 400 430 2024-06-28
16872 Chocolate Croissant 16872 59 59 440 490 2024-06-28
16873 Creamy Chicken Foldover 16873 59 59 550 600 2024-06-28
16874 Sausage Roll 16874 59 59 550 600 2024-06-28
16875 Buttery Scone 16875 59 59 400 430 2024-06-28
16876 Country Chicken Pie 16876 59 59 690 740 2024-06-28
16877 Deep Dish Beef Pie 16877 59 59 690 740 2024-06-28
16878 Spinach & Mushroom Quiche 16878 59 59 690 740 2024-06-28
16879 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 16879 59 59 390 420 2024-06-28
16880 Mixed Nuts 16880 59 59 490 540 2024-06-28
16881 Caramel Waffles 16881 59 59 390 420 2024-06-28
16882 Chicken Ham & Cheese Panwich 16882 59 59 690 740 2024-06-28
16883 Egg Mayo & Cheese Multigrain Croissant 16883 59 59 690 740 2024-06-28
16884 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 16884 59 59 690 740 2024-06-28
16885 Rosemary Chicken & Emmental Cheese Croissant 16885 59 59 690 740 2024-06-28
16886 Scrambled Egg & Turkey Ham Pita 16886 59 59 690 740 2024-06-28
16887 Turkey Ham & Triple Cheese Toast 16887 59 59 690 740 2024-06-28
16888 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 16888 59 59 790 840 2024-06-28
16889 Ham & Cheese Croissant 16889 59 59 690 740 2024-06-28
16890 Sriracha Chicken Whole Wheat Pita 16890 59 59 750 800 2024-06-28
16891 Blueberry Acai Yogurt Parfait 16891 59 59 650 700 2024-06-28
16892 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 16892 59 59 650 700 2024-06-28
16893 Caramel Frappuccino® 16893 59 59 720 770 2024-06-28
16894 Dark Mocha Frappuccino® 16894 59 59 780 830 2024-06-28
16895 Java Chip Frappuccino® 16895 59 59 780 830 2024-06-28
16896 Mocha Frappuccino® 16896 59 59 720 770 2024-06-28
16897 Caramel Macchiato Frappuccino® 16897 59 59 780 830 2024-06-28
16898 Espresso Frappuccino® 16898 59 59 720 770 2024-06-28
16899 White Chocolate Mocha Frappuccino® 16899 59 59 720 770 2024-06-28
16900 Chocolate Chip Cream Frappuccino® 16900 59 59 780 830 2024-06-28
16901 Hojicha Tea Cream Frappuccino® 16901 59 59 760 810 2024-06-28
16902 Vanilla Cream Frappuccino® 16902 59 59 720 770 2024-06-28
16903 Mango Passion Fruit & Hibiscus 16903 59 59 720 770 2024-06-28
16904 Raspberry Black Currant & Oolong 16904 59 59 720 770 2024-06-28
16905 Coffee Traveller 16905 59 59 3120 3170 2024-06-28
16906 Caffè Americano 16906 59 59 540 590 2024-06-28
16907 Cappuccino 16907 59 59 680 730 2024-06-28
16908 Caffè Mocha 16908 59 59 750 800 2024-06-28
16909 Caramel Macchiato 16909 59 59 760 810 2024-06-28
16910 Espresso 16910 59 59 390 440 2024-06-28
16911 Caffè Latte 16911 59 59 680 730 2024-06-28
16912 Oatmilk Latte 16912 59 59 760 810 2024-06-28
16913 Vanilla Latte 16913 59 59 750 800 2024-06-28
16914 White Chocolate Mocha 16914 59 59 750 800 2024-06-28
16915 Flat White 16915 59 59 760 810 2024-06-28
16916 Ristretto Bianco 16916 59 59 760 810 2024-06-28
16917 Iced Caffè Americano 16917 59 59 540 590 2024-06-28
16918 Iced Cappuccino 16918 59 59 680 730 2024-06-28
16919 Iced Caffè Mocha 16919 59 59 750 800 2024-06-28
16920 Iced Caramel Macchiato 16920 59 59 760 810 2024-06-28
16921 Iced Caffè Latte 16921 59 59 680 730 2024-06-28
16922 Iced Oatmilk Latte 16922 59 59 760 810 2024-06-28
16923 Iced Vanilla Latte 16923 59 59 750 800 2024-06-28
16924 Iced White Chocolate Mocha 16924 59 59 750 800 2024-06-28
16925 Signature Hot Chocolate 16925 59 59 720 770 2024-06-28
16926 Signature Iced Chocolate 16926 59 59 720 770 2024-06-28
16927 Carrot Juice 16927 59 59 490 540 2024-06-28
16928 Cloudy Apple Juice 16928 59 59 490 540 2024-06-28
16929 Cranberry Red Grapefruit Juice 16929 59 59 490 540 2024-06-28
16930 Orange Juice 16930 59 59 490 540 2024-06-28
16931 Evian 16931 59 59 350 400 2024-06-28
16932 Sparkling Water 16932 59 59 450 500 2024-06-28
16933 Chai Tea 16933 59 59 500 550 2024-06-28
16934 Earl Grey Tea 16934 59 59 500 550 2024-06-28
16935 English Breakfast Tea 16935 59 59 500 550 2024-06-28
16936 Emperor’s Clouds & Mist™ Tea 16936 59 59 500 550 2024-06-28
16937 Mint Blend Tea 16937 59 59 500 550 2024-06-28
16938 Chamomile Tea 16938 59 59 500 550 2024-06-28
16939 Pure Matcha Latte 16939 59 59 740 790 2024-06-28
16940 Chai Tea Latte 16940 59 59 680 730 2024-06-28
16941 Earl Grey Tea Latte 16941 59 59 680 730 2024-06-28
16942 English Breakfast Tea Latte 16942 59 59 680 730 2024-06-28
16943 Hojicha Tea Latte 16943 59 59 740 790 2024-06-28
16944 Zen Clouds Oolong Tea 16944 59 59 500 550 2024-06-28
16945 Zen Clouds Oolong with Ruby Grapefruit and Honey 16945 59 59 630 680 2024-06-28
16946 Youthberry™ Tea 16946 59 59 500 550 2024-06-28
16947 Iced Shaken Black Tea Lemonade 16947 59 59 610 660 2024-06-28
16948 Iced Shaken Strawberry Black Tea Lemonade 16948 59 59 630 680 2024-06-28
16949 Iced Shaken Hibiscus Tea Lemonade 16949 59 59 610 660 2024-06-28
16950 Iced Shaken Hibiscus Tea with Pomegranate Pearls 16950 59 59 730 780 2024-06-28
16951 Iced Pure Matcha Latte 16951 59 59 740 790 2024-06-28
16952 Iced Chai Tea Latte 16952 59 59 680 730 2024-06-28
16953 Iced Black Tea Latte 16953 59 59 680 730 2024-06-28
16954 Iced Hojicha Tea Latte 16954 59 59 740 790 2024-06-28
16955 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 16955 59 59 630 680 2024-06-28
16956 Iced Shaken Zen Clouds Oolong Lemonade 16956 59 59 610 660 2024-06-28
16957 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 16957 59 59 630 680 2024-06-28
16958 Origami Pike Place® Roast 16958 59 59 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");