item_prices

Pricing information for Starbucks menu items in Singapore

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

225 rows where store_id = 18

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 18 · 225 ✖
id ▼ item_id store_id base_price delivery_price effective_date
23812 Bagel 23812 18 18 400 430 2024-06-28
23813 Cookie Crumble Cheesecake 23813 18 18 720 770 2024-06-28
23814 Good Ol' NY Cheesecake 23814 18 18 720 770 2024-06-28
23815 Signature Chocolate Cake 23815 18 18 720 770 2024-06-28
23816 Starbucks® Coffee Tiramisu Cake 23816 18 18 750 800 2024-06-28
23817 Strawberry Shortcake 23817 18 18 720 770 2024-06-28
23818 Chocolate Chunk Monster Cookie 23818 18 18 390 440 2024-06-28
23819 Banana Walnut Muffin 23819 18 18 450 500 2024-06-28
23820 Blueberry Crumble Muffin 23820 18 18 450 500 2024-06-28
23821 Chocolate Crumble Muffin 23821 18 18 450 500 2024-06-28
23822 Pancakes 23822 18 18 550 600 2024-06-28
23823 Almond Croissant 23823 18 18 470 520 2024-06-28
23824 Buttery Croissant 23824 18 18 400 430 2024-06-28
23825 Chocolate Croissant 23825 18 18 440 490 2024-06-28
23826 Creamy Chicken Foldover 23826 18 18 550 600 2024-06-28
23827 Sausage Roll 23827 18 18 550 600 2024-06-28
23828 Buttery Scone 23828 18 18 400 430 2024-06-28
23829 Country Chicken Pie 23829 18 18 690 740 2024-06-28
23830 Deep Dish Beef Pie 23830 18 18 690 740 2024-06-28
23831 Spinach & Mushroom Quiche 23831 18 18 690 740 2024-06-28
23832 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 23832 18 18 390 420 2024-06-28
23833 Mixed Nuts 23833 18 18 490 540 2024-06-28
23834 Caramel Waffles 23834 18 18 390 420 2024-06-28
23835 Chicken Ham & Cheese Panwich 23835 18 18 690 740 2024-06-28
23836 Egg Mayo & Cheese Multigrain Croissant 23836 18 18 690 740 2024-06-28
23837 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 23837 18 18 690 740 2024-06-28
23838 Rosemary Chicken & Emmental Cheese Croissant 23838 18 18 690 740 2024-06-28
23839 Scrambled Egg & Turkey Ham Pita 23839 18 18 690 740 2024-06-28
23840 Turkey Ham & Triple Cheese Toast 23840 18 18 690 740 2024-06-28
23841 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 23841 18 18 790 840 2024-06-28
23842 Ham & Cheese Croissant 23842 18 18 690 740 2024-06-28
23843 Sriracha Chicken Whole Wheat Pita 23843 18 18 750 800 2024-06-28
23844 Blueberry Acai Yogurt Parfait 23844 18 18 650 700 2024-06-28
23845 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 23845 18 18 650 700 2024-06-28
23846 Caramel Frappuccino® 23846 18 18 720 770 2024-06-28
23847 Dark Mocha Frappuccino® 23847 18 18 780 830 2024-06-28
23848 Java Chip Frappuccino® 23848 18 18 780 830 2024-06-28
23849 Mocha Frappuccino® 23849 18 18 720 770 2024-06-28
23850 Caramel Macchiato Frappuccino® 23850 18 18 780 830 2024-06-28
23851 Espresso Frappuccino® 23851 18 18 720 770 2024-06-28
23852 White Chocolate Mocha Frappuccino® 23852 18 18 720 770 2024-06-28
23853 Chocolate Chip Cream Frappuccino® 23853 18 18 780 830 2024-06-28
23854 Hojicha Tea Cream Frappuccino® 23854 18 18 760 810 2024-06-28
23855 Vanilla Cream Frappuccino® 23855 18 18 720 770 2024-06-28
23856 Mango Passion Fruit & Hibiscus 23856 18 18 720 770 2024-06-28
23857 Raspberry Black Currant & Oolong 23857 18 18 720 770 2024-06-28
23858 Coffee Traveller 23858 18 18 3120 3170 2024-06-28
23859 Caffè Americano 23859 18 18 540 590 2024-06-28
23860 Cappuccino 23860 18 18 680 730 2024-06-28
23861 Caffè Mocha 23861 18 18 750 800 2024-06-28
23862 Caramel Macchiato 23862 18 18 760 810 2024-06-28
23863 Espresso 23863 18 18 390 440 2024-06-28
23864 Caffè Latte 23864 18 18 680 730 2024-06-28
23865 Oatmilk Latte 23865 18 18 760 810 2024-06-28
23866 Vanilla Latte 23866 18 18 750 800 2024-06-28
23867 White Chocolate Mocha 23867 18 18 750 800 2024-06-28
23868 Flat White 23868 18 18 760 810 2024-06-28
23869 Ristretto Bianco 23869 18 18 760 810 2024-06-28
23870 Iced Caffè Americano 23870 18 18 540 590 2024-06-28
23871 Iced Cappuccino 23871 18 18 680 730 2024-06-28
23872 Iced Caffè Mocha 23872 18 18 750 800 2024-06-28
23873 Iced Caramel Macchiato 23873 18 18 760 810 2024-06-28
23874 Iced Caffè Latte 23874 18 18 680 730 2024-06-28
23875 Iced Oatmilk Latte 23875 18 18 760 810 2024-06-28
23876 Iced Vanilla Latte 23876 18 18 750 800 2024-06-28
23877 Iced White Chocolate Mocha 23877 18 18 750 800 2024-06-28
23878 Signature Hot Chocolate 23878 18 18 720 770 2024-06-28
23879 Signature Iced Chocolate 23879 18 18 720 770 2024-06-28
23880 Carrot Juice 23880 18 18 490 540 2024-06-28
23881 Cloudy Apple Juice 23881 18 18 490 540 2024-06-28
23882 Cranberry Red Grapefruit Juice 23882 18 18 490 540 2024-06-28
23883 Orange Juice 23883 18 18 490 540 2024-06-28
23884 Evian 23884 18 18 350 400 2024-06-28
23885 Sparkling Water 23885 18 18 450 500 2024-06-28
23886 Chai Tea 23886 18 18 500 550 2024-06-28
23887 Earl Grey Tea 23887 18 18 500 550 2024-06-28
23888 English Breakfast Tea 23888 18 18 500 550 2024-06-28
23889 Emperor’s Clouds & Mist™ Tea 23889 18 18 500 550 2024-06-28
23890 Mint Blend Tea 23890 18 18 500 550 2024-06-28
23891 Chamomile Tea 23891 18 18 500 550 2024-06-28
23892 Pure Matcha Latte 23892 18 18 740 790 2024-06-28
23893 Chai Tea Latte 23893 18 18 680 730 2024-06-28
23894 Earl Grey Tea Latte 23894 18 18 680 730 2024-06-28
23895 English Breakfast Tea Latte 23895 18 18 680 730 2024-06-28
23896 Hojicha Tea Latte 23896 18 18 740 790 2024-06-28
23897 Zen Clouds Oolong Tea 23897 18 18 500 550 2024-06-28
23898 Zen Clouds Oolong with Ruby Grapefruit and Honey 23898 18 18 630 680 2024-06-28
23899 Youthberry™ Tea 23899 18 18 500 550 2024-06-28
23900 Iced Shaken Black Tea Lemonade 23900 18 18 610 660 2024-06-28
23901 Iced Shaken Strawberry Black Tea Lemonade 23901 18 18 630 680 2024-06-28
23902 Iced Shaken Hibiscus Tea Lemonade 23902 18 18 610 660 2024-06-28
23903 Iced Shaken Hibiscus Tea with Pomegranate Pearls 23903 18 18 730 780 2024-06-28
23904 Iced Pure Matcha Latte 23904 18 18 740 790 2024-06-28
23905 Iced Chai Tea Latte 23905 18 18 680 730 2024-06-28
23906 Iced Black Tea Latte 23906 18 18 680 730 2024-06-28
23907 Iced Hojicha Tea Latte 23907 18 18 740 790 2024-06-28
23908 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 23908 18 18 630 680 2024-06-28
23909 Iced Shaken Zen Clouds Oolong Lemonade 23909 18 18 610 660 2024-06-28
23910 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 23910 18 18 630 680 2024-06-28
23911 Origami Pike Place® Roast 23911 18 18 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");