item_prices

Pricing information for Starbucks menu items in Singapore

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

249 rows where store_id = 64

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 64 · 249 ✖
id ▼ item_id store_id base_price delivery_price effective_date
15949 Bagel 15949 64 64 400 430 2024-06-28
15950 Cookie Crumble Cheesecake 15950 64 64 720 770 2024-06-28
15951 Good Ol' NY Cheesecake 15951 64 64 720 770 2024-06-28
15952 Signature Chocolate Cake 15952 64 64 720 770 2024-06-28
15953 Starbucks® Coffee Tiramisu Cake 15953 64 64 750 800 2024-06-28
15954 Strawberry Shortcake 15954 64 64 720 770 2024-06-28
15955 Chocolate Chunk Monster Cookie 15955 64 64 390 440 2024-06-28
15956 Banana Walnut Muffin 15956 64 64 450 500 2024-06-28
15957 Blueberry Crumble Muffin 15957 64 64 450 500 2024-06-28
15958 Chocolate Crumble Muffin 15958 64 64 450 500 2024-06-28
15959 Pancakes 15959 64 64 550 600 2024-06-28
15960 Almond Croissant 15960 64 64 470 520 2024-06-28
15961 Buttery Croissant 15961 64 64 400 430 2024-06-28
15962 Chocolate Croissant 15962 64 64 440 490 2024-06-28
15963 Creamy Chicken Foldover 15963 64 64 550 600 2024-06-28
15964 Sausage Roll 15964 64 64 550 600 2024-06-28
15965 Buttery Scone 15965 64 64 400 430 2024-06-28
15966 Country Chicken Pie 15966 64 64 690 740 2024-06-28
15967 Deep Dish Beef Pie 15967 64 64 690 740 2024-06-28
15968 Spinach & Mushroom Quiche 15968 64 64 690 740 2024-06-28
15969 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 15969 64 64 390 420 2024-06-28
15970 Mixed Nuts 15970 64 64 490 540 2024-06-28
15971 Caramel Waffles 15971 64 64 390 420 2024-06-28
15972 Chicken Ham & Cheese Panwich 15972 64 64 690 740 2024-06-28
15973 Egg Mayo & Cheese Multigrain Croissant 15973 64 64 690 740 2024-06-28
15974 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 15974 64 64 690 740 2024-06-28
15975 Rosemary Chicken & Emmental Cheese Croissant 15975 64 64 690 740 2024-06-28
15976 Scrambled Egg & Turkey Ham Pita 15976 64 64 690 740 2024-06-28
15977 Turkey Ham & Triple Cheese Toast 15977 64 64 690 740 2024-06-28
15978 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 15978 64 64 790 840 2024-06-28
15979 Ham & Cheese Croissant 15979 64 64 690 740 2024-06-28
15980 Sriracha Chicken Whole Wheat Pita 15980 64 64 750 800 2024-06-28
15981 Blueberry Acai Yogurt Parfait 15981 64 64 650 700 2024-06-28
15982 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 15982 64 64 650 700 2024-06-28
15983 Caramel Frappuccino® 15983 64 64 720 770 2024-06-28
15984 Dark Mocha Frappuccino® 15984 64 64 780 830 2024-06-28
15985 Java Chip Frappuccino® 15985 64 64 780 830 2024-06-28
15986 Mocha Frappuccino® 15986 64 64 720 770 2024-06-28
15987 Caramel Macchiato Frappuccino® 15987 64 64 780 830 2024-06-28
15988 Espresso Frappuccino® 15988 64 64 720 770 2024-06-28
15989 White Chocolate Mocha Frappuccino® 15989 64 64 720 770 2024-06-28
15990 Chocolate Chip Cream Frappuccino® 15990 64 64 780 830 2024-06-28
15991 Hojicha Tea Cream Frappuccino® 15991 64 64 760 810 2024-06-28
15992 Vanilla Cream Frappuccino® 15992 64 64 720 770 2024-06-28
15993 Mango Passion Fruit & Hibiscus 15993 64 64 720 770 2024-06-28
15994 Raspberry Black Currant & Oolong 15994 64 64 720 770 2024-06-28
15995 Coffee Traveller 15995 64 64 3120 3170 2024-06-28
15996 Caffè Americano 15996 64 64 540 590 2024-06-28
15997 Cappuccino 15997 64 64 680 730 2024-06-28
15998 Caffè Mocha 15998 64 64 750 800 2024-06-28
15999 Caramel Macchiato 15999 64 64 760 810 2024-06-28
16000 Espresso 16000 64 64 390 440 2024-06-28
16001 Caffè Latte 16001 64 64 680 730 2024-06-28
16002 Oatmilk Latte 16002 64 64 760 810 2024-06-28
16003 Vanilla Latte 16003 64 64 750 800 2024-06-28
16004 White Chocolate Mocha 16004 64 64 750 800 2024-06-28
16005 Flat White 16005 64 64 760 810 2024-06-28
16006 Ristretto Bianco 16006 64 64 760 810 2024-06-28
16007 Iced Caffè Americano 16007 64 64 540 590 2024-06-28
16008 Iced Cappuccino 16008 64 64 680 730 2024-06-28
16009 Iced Caffè Mocha 16009 64 64 750 800 2024-06-28
16010 Iced Caramel Macchiato 16010 64 64 760 810 2024-06-28
16011 Iced Caffè Latte 16011 64 64 680 730 2024-06-28
16012 Iced Oatmilk Latte 16012 64 64 760 810 2024-06-28
16013 Iced Vanilla Latte 16013 64 64 750 800 2024-06-28
16014 Iced White Chocolate Mocha 16014 64 64 750 800 2024-06-28
16015 Signature Hot Chocolate 16015 64 64 720 770 2024-06-28
16016 Signature Iced Chocolate 16016 64 64 720 770 2024-06-28
16017 Carrot Juice 16017 64 64 490 540 2024-06-28
16018 Cloudy Apple Juice 16018 64 64 490 540 2024-06-28
16019 Cranberry Red Grapefruit Juice 16019 64 64 490 540 2024-06-28
16020 Orange Juice 16020 64 64 490 540 2024-06-28
16021 Evian 16021 64 64 350 400 2024-06-28
16022 Sparkling Water 16022 64 64 450 500 2024-06-28
16023 Chai Tea 16023 64 64 500 550 2024-06-28
16024 Earl Grey Tea 16024 64 64 500 550 2024-06-28
16025 English Breakfast Tea 16025 64 64 500 550 2024-06-28
16026 Emperor’s Clouds & Mist™ Tea 16026 64 64 500 550 2024-06-28
16027 Mint Blend Tea 16027 64 64 500 550 2024-06-28
16028 Chamomile Tea 16028 64 64 500 550 2024-06-28
16029 Pure Matcha Latte 16029 64 64 740 790 2024-06-28
16030 Chai Tea Latte 16030 64 64 680 730 2024-06-28
16031 Earl Grey Tea Latte 16031 64 64 680 730 2024-06-28
16032 English Breakfast Tea Latte 16032 64 64 680 730 2024-06-28
16033 Hojicha Tea Latte 16033 64 64 740 790 2024-06-28
16034 Zen Clouds Oolong Tea 16034 64 64 500 550 2024-06-28
16035 Zen Clouds Oolong with Ruby Grapefruit and Honey 16035 64 64 630 680 2024-06-28
16036 Youthberry™ Tea 16036 64 64 500 550 2024-06-28
16037 Iced Shaken Black Tea Lemonade 16037 64 64 610 660 2024-06-28
16038 Iced Shaken Strawberry Black Tea Lemonade 16038 64 64 630 680 2024-06-28
16039 Iced Shaken Hibiscus Tea Lemonade 16039 64 64 610 660 2024-06-28
16040 Iced Shaken Hibiscus Tea with Pomegranate Pearls 16040 64 64 730 780 2024-06-28
16041 Iced Pure Matcha Latte 16041 64 64 740 790 2024-06-28
16042 Iced Chai Tea Latte 16042 64 64 680 730 2024-06-28
16043 Iced Black Tea Latte 16043 64 64 680 730 2024-06-28
16044 Iced Hojicha Tea Latte 16044 64 64 740 790 2024-06-28
16045 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 16045 64 64 630 680 2024-06-28
16046 Iced Shaken Zen Clouds Oolong Lemonade 16046 64 64 610 660 2024-06-28
16047 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 16047 64 64 630 680 2024-06-28
16048 Origami Pike Place® Roast 16048 64 64 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");