item_prices

Pricing information for Starbucks menu items in Singapore

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

234 rows where store_id = 96

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 96 · 234 ✖
id ▼ item_id store_id base_price delivery_price effective_date
10990 Bagel 10990 96 96 400 430 2024-06-28
10991 Cookie Crumble Cheesecake 10991 96 96 720 770 2024-06-28
10992 Good Ol' NY Cheesecake 10992 96 96 720 770 2024-06-28
10993 Signature Chocolate Cake 10993 96 96 720 770 2024-06-28
10994 Starbucks® Coffee Tiramisu Cake 10994 96 96 750 800 2024-06-28
10995 Strawberry Shortcake 10995 96 96 720 770 2024-06-28
10996 Chocolate Chunk Monster Cookie 10996 96 96 390 440 2024-06-28
10997 Banana Walnut Muffin 10997 96 96 450 500 2024-06-28
10998 Blueberry Crumble Muffin 10998 96 96 450 500 2024-06-28
10999 Chocolate Crumble Muffin 10999 96 96 450 500 2024-06-28
11000 Pancakes 11000 96 96 550 600 2024-06-28
11001 Almond Croissant 11001 96 96 470 520 2024-06-28
11002 Buttery Croissant 11002 96 96 400 430 2024-06-28
11003 Chocolate Croissant 11003 96 96 440 490 2024-06-28
11004 Creamy Chicken Foldover 11004 96 96 550 600 2024-06-28
11005 Sausage Roll 11005 96 96 550 600 2024-06-28
11006 Buttery Scone 11006 96 96 400 430 2024-06-28
11007 Country Chicken Pie 11007 96 96 690 740 2024-06-28
11008 Deep Dish Beef Pie 11008 96 96 690 740 2024-06-28
11009 Spinach & Mushroom Quiche 11009 96 96 690 740 2024-06-28
11010 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 11010 96 96 390 420 2024-06-28
11011 Mixed Nuts 11011 96 96 490 540 2024-06-28
11012 Caramel Waffles 11012 96 96 390 420 2024-06-28
11013 Chicken Ham & Cheese Panwich 11013 96 96 690 740 2024-06-28
11014 Egg Mayo & Cheese Multigrain Croissant 11014 96 96 690 740 2024-06-28
11015 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 11015 96 96 690 740 2024-06-28
11016 Rosemary Chicken & Emmental Cheese Croissant 11016 96 96 690 740 2024-06-28
11017 Scrambled Egg & Turkey Ham Pita 11017 96 96 690 740 2024-06-28
11018 Turkey Ham & Triple Cheese Toast 11018 96 96 690 740 2024-06-28
11019 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 11019 96 96 790 840 2024-06-28
11020 Ham & Cheese Croissant 11020 96 96 690 740 2024-06-28
11021 Sriracha Chicken Whole Wheat Pita 11021 96 96 750 800 2024-06-28
11022 Blueberry Acai Yogurt Parfait 11022 96 96 650 700 2024-06-28
11023 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 11023 96 96 650 700 2024-06-28
11024 Caramel Frappuccino® 11024 96 96 720 770 2024-06-28
11025 Dark Mocha Frappuccino® 11025 96 96 780 830 2024-06-28
11026 Java Chip Frappuccino® 11026 96 96 780 830 2024-06-28
11027 Mocha Frappuccino® 11027 96 96 720 770 2024-06-28
11028 Caramel Macchiato Frappuccino® 11028 96 96 780 830 2024-06-28
11029 Espresso Frappuccino® 11029 96 96 720 770 2024-06-28
11030 White Chocolate Mocha Frappuccino® 11030 96 96 720 770 2024-06-28
11031 Chocolate Chip Cream Frappuccino® 11031 96 96 780 830 2024-06-28
11032 Hojicha Tea Cream Frappuccino® 11032 96 96 760 810 2024-06-28
11033 Vanilla Cream Frappuccino® 11033 96 96 720 770 2024-06-28
11034 Mango Passion Fruit & Hibiscus 11034 96 96 720 770 2024-06-28
11035 Raspberry Black Currant & Oolong 11035 96 96 720 770 2024-06-28
11036 Coffee Traveller 11036 96 96 3120 3170 2024-06-28
11037 Caffè Americano 11037 96 96 540 590 2024-06-28
11038 Cappuccino 11038 96 96 680 730 2024-06-28
11039 Caffè Mocha 11039 96 96 750 800 2024-06-28
11040 Caramel Macchiato 11040 96 96 760 810 2024-06-28
11041 Espresso 11041 96 96 390 440 2024-06-28
11042 Caffè Latte 11042 96 96 680 730 2024-06-28
11043 Oatmilk Latte 11043 96 96 760 810 2024-06-28
11044 Vanilla Latte 11044 96 96 750 800 2024-06-28
11045 White Chocolate Mocha 11045 96 96 750 800 2024-06-28
11046 Flat White 11046 96 96 760 810 2024-06-28
11047 Ristretto Bianco 11047 96 96 760 810 2024-06-28
11048 Iced Caffè Americano 11048 96 96 540 590 2024-06-28
11049 Iced Cappuccino 11049 96 96 680 730 2024-06-28
11050 Iced Caffè Mocha 11050 96 96 750 800 2024-06-28
11051 Iced Caramel Macchiato 11051 96 96 760 810 2024-06-28
11052 Iced Caffè Latte 11052 96 96 680 730 2024-06-28
11053 Iced Oatmilk Latte 11053 96 96 760 810 2024-06-28
11054 Iced Vanilla Latte 11054 96 96 750 800 2024-06-28
11055 Iced White Chocolate Mocha 11055 96 96 750 800 2024-06-28
11056 Signature Hot Chocolate 11056 96 96 720 770 2024-06-28
11057 Signature Iced Chocolate 11057 96 96 720 770 2024-06-28
11058 Carrot Juice 11058 96 96 490 540 2024-06-28
11059 Cloudy Apple Juice 11059 96 96 490 540 2024-06-28
11060 Cranberry Red Grapefruit Juice 11060 96 96 490 540 2024-06-28
11061 Orange Juice 11061 96 96 490 540 2024-06-28
11062 Evian 11062 96 96 350 400 2024-06-28
11063 Sparkling Water 11063 96 96 450 500 2024-06-28
11064 Chai Tea 11064 96 96 500 550 2024-06-28
11065 Earl Grey Tea 11065 96 96 500 550 2024-06-28
11066 English Breakfast Tea 11066 96 96 500 550 2024-06-28
11067 Emperor’s Clouds & Mist™ Tea 11067 96 96 500 550 2024-06-28
11068 Mint Blend Tea 11068 96 96 500 550 2024-06-28
11069 Chamomile Tea 11069 96 96 500 550 2024-06-28
11070 Pure Matcha Latte 11070 96 96 740 790 2024-06-28
11071 Chai Tea Latte 11071 96 96 680 730 2024-06-28
11072 Earl Grey Tea Latte 11072 96 96 680 730 2024-06-28
11073 English Breakfast Tea Latte 11073 96 96 680 730 2024-06-28
11074 Hojicha Tea Latte 11074 96 96 740 790 2024-06-28
11075 Zen Clouds Oolong Tea 11075 96 96 500 550 2024-06-28
11076 Zen Clouds Oolong with Ruby Grapefruit and Honey 11076 96 96 630 680 2024-06-28
11077 Youthberry™ Tea 11077 96 96 500 550 2024-06-28
11078 Iced Shaken Black Tea Lemonade 11078 96 96 610 660 2024-06-28
11079 Iced Shaken Strawberry Black Tea Lemonade 11079 96 96 630 680 2024-06-28
11080 Iced Shaken Hibiscus Tea Lemonade 11080 96 96 610 660 2024-06-28
11081 Iced Shaken Hibiscus Tea with Pomegranate Pearls 11081 96 96 730 780 2024-06-28
11082 Iced Pure Matcha Latte 11082 96 96 740 790 2024-06-28
11083 Iced Chai Tea Latte 11083 96 96 680 730 2024-06-28
11084 Iced Black Tea Latte 11084 96 96 680 730 2024-06-28
11085 Iced Hojicha Tea Latte 11085 96 96 740 790 2024-06-28
11086 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 11086 96 96 630 680 2024-06-28
11087 Iced Shaken Zen Clouds Oolong Lemonade 11087 96 96 610 660 2024-06-28
11088 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 11088 96 96 630 680 2024-06-28
11089 Origami Pike Place® Roast 11089 96 96 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");