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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 109 · 182 ✖

effective_date 1

  • 2024-06-28 · 182 ✖
id ▼ item_id store_id base_price delivery_price effective_date
8802 Bagel 8802 109 109 400 430 2024-06-28
8803 Cookie Crumble Cheesecake 8803 109 109 720 770 2024-06-28
8804 Good Ol' NY Cheesecake 8804 109 109 720 770 2024-06-28
8805 Signature Chocolate Cake 8805 109 109 720 770 2024-06-28
8806 Starbucks® Coffee Tiramisu Cake 8806 109 109 750 800 2024-06-28
8807 Strawberry Shortcake 8807 109 109 720 770 2024-06-28
8808 Chocolate Chunk Monster Cookie 8808 109 109 390 440 2024-06-28
8809 Banana Walnut Muffin 8809 109 109 450 500 2024-06-28
8810 Blueberry Crumble Muffin 8810 109 109 450 500 2024-06-28
8811 Chocolate Crumble Muffin 8811 109 109 450 500 2024-06-28
8812 Pancakes 8812 109 109 550 600 2024-06-28
8813 Almond Croissant 8813 109 109 470 520 2024-06-28
8814 Buttery Croissant 8814 109 109 400 430 2024-06-28
8815 Chocolate Croissant 8815 109 109 440 490 2024-06-28
8816 Creamy Chicken Foldover 8816 109 109 550 600 2024-06-28
8817 Sausage Roll 8817 109 109 550 600 2024-06-28
8818 Buttery Scone 8818 109 109 400 430 2024-06-28
8819 Country Chicken Pie 8819 109 109 690 740 2024-06-28
8820 Deep Dish Beef Pie 8820 109 109 690 740 2024-06-28
8821 Spinach & Mushroom Quiche 8821 109 109 690 740 2024-06-28
8822 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 8822 109 109 390 420 2024-06-28
8823 Mixed Nuts 8823 109 109 490 540 2024-06-28
8824 Caramel Waffles 8824 109 109 390 420 2024-06-28
8825 Chicken Ham & Cheese Panwich 8825 109 109 690 740 2024-06-28
8826 Egg Mayo & Cheese Multigrain Croissant 8826 109 109 690 740 2024-06-28
8827 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 8827 109 109 690 740 2024-06-28
8828 Rosemary Chicken & Emmental Cheese Croissant 8828 109 109 690 740 2024-06-28
8829 Scrambled Egg & Turkey Ham Pita 8829 109 109 690 740 2024-06-28
8830 Turkey Ham & Triple Cheese Toast 8830 109 109 690 740 2024-06-28
8831 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 8831 109 109 790 840 2024-06-28
8832 Ham & Cheese Croissant 8832 109 109 690 740 2024-06-28
8833 Sriracha Chicken Whole Wheat Pita 8833 109 109 750 800 2024-06-28
8834 Blueberry Acai Yogurt Parfait 8834 109 109 650 700 2024-06-28
8835 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 8835 109 109 650 700 2024-06-28
8836 Caramel Frappuccino® 8836 109 109 720 770 2024-06-28
8837 Dark Mocha Frappuccino® 8837 109 109 780 830 2024-06-28
8838 Java Chip Frappuccino® 8838 109 109 780 830 2024-06-28
8839 Mocha Frappuccino® 8839 109 109 720 770 2024-06-28
8840 Caramel Macchiato Frappuccino® 8840 109 109 780 830 2024-06-28
8841 Espresso Frappuccino® 8841 109 109 720 770 2024-06-28
8842 White Chocolate Mocha Frappuccino® 8842 109 109 720 770 2024-06-28
8843 Chocolate Chip Cream Frappuccino® 8843 109 109 780 830 2024-06-28
8844 Hojicha Tea Cream Frappuccino® 8844 109 109 760 810 2024-06-28
8845 Vanilla Cream Frappuccino® 8845 109 109 720 770 2024-06-28
8846 Mango Passion Fruit & Hibiscus 8846 109 109 720 770 2024-06-28
8847 Raspberry Black Currant & Oolong 8847 109 109 720 770 2024-06-28
8848 Coffee Traveller 8848 109 109 3120 3170 2024-06-28
8849 Caffè Americano 8849 109 109 540 590 2024-06-28
8850 Cappuccino 8850 109 109 680 730 2024-06-28
8851 Caffè Mocha 8851 109 109 750 800 2024-06-28
8852 Caramel Macchiato 8852 109 109 760 810 2024-06-28
8853 Espresso 8853 109 109 390 440 2024-06-28
8854 Caffè Latte 8854 109 109 680 730 2024-06-28
8855 Oatmilk Latte 8855 109 109 760 810 2024-06-28
8856 Vanilla Latte 8856 109 109 750 800 2024-06-28
8857 White Chocolate Mocha 8857 109 109 750 800 2024-06-28
8858 Flat White 8858 109 109 760 810 2024-06-28
8859 Ristretto Bianco 8859 109 109 760 810 2024-06-28
8860 Iced Caffè Americano 8860 109 109 540 590 2024-06-28
8861 Iced Cappuccino 8861 109 109 680 730 2024-06-28
8862 Iced Caffè Mocha 8862 109 109 750 800 2024-06-28
8863 Iced Caramel Macchiato 8863 109 109 760 810 2024-06-28
8864 Iced Caffè Latte 8864 109 109 680 730 2024-06-28
8865 Iced Oatmilk Latte 8865 109 109 760 810 2024-06-28
8866 Iced Vanilla Latte 8866 109 109 750 800 2024-06-28
8867 Iced White Chocolate Mocha 8867 109 109 750 800 2024-06-28
8868 Signature Hot Chocolate 8868 109 109 720 770 2024-06-28
8869 Signature Iced Chocolate 8869 109 109 720 770 2024-06-28
8870 Carrot Juice 8870 109 109 490 540 2024-06-28
8871 Cloudy Apple Juice 8871 109 109 490 540 2024-06-28
8872 Cranberry Red Grapefruit Juice 8872 109 109 490 540 2024-06-28
8873 Orange Juice 8873 109 109 490 540 2024-06-28
8874 Evian 8874 109 109 350 400 2024-06-28
8875 Sparkling Water 8875 109 109 450 500 2024-06-28
8876 Chai Tea 8876 109 109 500 550 2024-06-28
8877 Earl Grey Tea 8877 109 109 500 550 2024-06-28
8878 English Breakfast Tea 8878 109 109 500 550 2024-06-28
8879 Emperor’s Clouds & Mist™ Tea 8879 109 109 500 550 2024-06-28
8880 Mint Blend Tea 8880 109 109 500 550 2024-06-28
8881 Chamomile Tea 8881 109 109 500 550 2024-06-28
8882 Pure Matcha Latte 8882 109 109 740 790 2024-06-28
8883 Chai Tea Latte 8883 109 109 680 730 2024-06-28
8884 Earl Grey Tea Latte 8884 109 109 680 730 2024-06-28
8885 English Breakfast Tea Latte 8885 109 109 680 730 2024-06-28
8886 Hojicha Tea Latte 8886 109 109 740 790 2024-06-28
8887 Zen Clouds Oolong Tea 8887 109 109 500 550 2024-06-28
8888 Zen Clouds Oolong with Ruby Grapefruit and Honey 8888 109 109 630 680 2024-06-28
8889 Youthberry™ Tea 8889 109 109 500 550 2024-06-28
8890 Iced Shaken Black Tea Lemonade 8890 109 109 610 660 2024-06-28
8891 Iced Shaken Strawberry Black Tea Lemonade 8891 109 109 630 680 2024-06-28
8892 Iced Shaken Hibiscus Tea Lemonade 8892 109 109 610 660 2024-06-28
8893 Iced Shaken Hibiscus Tea with Pomegranate Pearls 8893 109 109 730 780 2024-06-28
8894 Iced Pure Matcha Latte 8894 109 109 740 790 2024-06-28
8895 Iced Chai Tea Latte 8895 109 109 680 730 2024-06-28
8896 Iced Black Tea Latte 8896 109 109 680 730 2024-06-28
8897 Iced Hojicha Tea Latte 8897 109 109 740 790 2024-06-28
8898 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 8898 109 109 630 680 2024-06-28
8899 Iced Shaken Zen Clouds Oolong Lemonade 8899 109 109 610 660 2024-06-28
8900 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 8900 109 109 630 680 2024-06-28
8901 Origami Pike Place® Roast 8901 109 109 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");