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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 95 · 249 ✖
id ▼ item_id store_id base_price delivery_price effective_date
11172 Bagel 11172 95 95 400 430 2024-06-28
11173 Cookie Crumble Cheesecake 11173 95 95 720 770 2024-06-28
11174 Good Ol' NY Cheesecake 11174 95 95 720 770 2024-06-28
11175 Signature Chocolate Cake 11175 95 95 720 770 2024-06-28
11176 Starbucks® Coffee Tiramisu Cake 11176 95 95 750 800 2024-06-28
11177 Strawberry Shortcake 11177 95 95 720 770 2024-06-28
11178 Chocolate Chunk Monster Cookie 11178 95 95 390 440 2024-06-28
11179 Banana Walnut Muffin 11179 95 95 450 500 2024-06-28
11180 Blueberry Crumble Muffin 11180 95 95 450 500 2024-06-28
11181 Chocolate Crumble Muffin 11181 95 95 450 500 2024-06-28
11182 Pancakes 11182 95 95 550 600 2024-06-28
11183 Almond Croissant 11183 95 95 470 520 2024-06-28
11184 Buttery Croissant 11184 95 95 400 430 2024-06-28
11185 Chocolate Croissant 11185 95 95 440 490 2024-06-28
11186 Creamy Chicken Foldover 11186 95 95 550 600 2024-06-28
11187 Sausage Roll 11187 95 95 550 600 2024-06-28
11188 Buttery Scone 11188 95 95 400 430 2024-06-28
11189 Country Chicken Pie 11189 95 95 690 740 2024-06-28
11190 Deep Dish Beef Pie 11190 95 95 690 740 2024-06-28
11191 Spinach & Mushroom Quiche 11191 95 95 690 740 2024-06-28
11192 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 11192 95 95 390 420 2024-06-28
11193 Mixed Nuts 11193 95 95 490 540 2024-06-28
11194 Caramel Waffles 11194 95 95 390 420 2024-06-28
11195 Chicken Ham & Cheese Panwich 11195 95 95 690 740 2024-06-28
11196 Egg Mayo & Cheese Multigrain Croissant 11196 95 95 690 740 2024-06-28
11197 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 11197 95 95 690 740 2024-06-28
11198 Rosemary Chicken & Emmental Cheese Croissant 11198 95 95 690 740 2024-06-28
11199 Scrambled Egg & Turkey Ham Pita 11199 95 95 690 740 2024-06-28
11200 Turkey Ham & Triple Cheese Toast 11200 95 95 690 740 2024-06-28
11201 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 11201 95 95 790 840 2024-06-28
11202 Ham & Cheese Croissant 11202 95 95 690 740 2024-06-28
11203 Sriracha Chicken Whole Wheat Pita 11203 95 95 750 800 2024-06-28
11204 Blueberry Acai Yogurt Parfait 11204 95 95 650 700 2024-06-28
11205 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 11205 95 95 650 700 2024-06-28
11206 Caramel Frappuccino® 11206 95 95 720 770 2024-06-28
11207 Dark Mocha Frappuccino® 11207 95 95 780 830 2024-06-28
11208 Java Chip Frappuccino® 11208 95 95 780 830 2024-06-28
11209 Mocha Frappuccino® 11209 95 95 720 770 2024-06-28
11210 Caramel Macchiato Frappuccino® 11210 95 95 780 830 2024-06-28
11211 Espresso Frappuccino® 11211 95 95 720 770 2024-06-28
11212 White Chocolate Mocha Frappuccino® 11212 95 95 720 770 2024-06-28
11213 Chocolate Chip Cream Frappuccino® 11213 95 95 780 830 2024-06-28
11214 Hojicha Tea Cream Frappuccino® 11214 95 95 760 810 2024-06-28
11215 Vanilla Cream Frappuccino® 11215 95 95 720 770 2024-06-28
11216 Mango Passion Fruit & Hibiscus 11216 95 95 720 770 2024-06-28
11217 Raspberry Black Currant & Oolong 11217 95 95 720 770 2024-06-28
11218 Coffee Traveller 11218 95 95 3120 3170 2024-06-28
11219 Caffè Americano 11219 95 95 540 590 2024-06-28
11220 Cappuccino 11220 95 95 680 730 2024-06-28
11221 Caffè Mocha 11221 95 95 750 800 2024-06-28
11222 Caramel Macchiato 11222 95 95 760 810 2024-06-28
11223 Espresso 11223 95 95 390 440 2024-06-28
11224 Caffè Latte 11224 95 95 680 730 2024-06-28
11225 Oatmilk Latte 11225 95 95 760 810 2024-06-28
11226 Vanilla Latte 11226 95 95 750 800 2024-06-28
11227 White Chocolate Mocha 11227 95 95 750 800 2024-06-28
11228 Flat White 11228 95 95 760 810 2024-06-28
11229 Ristretto Bianco 11229 95 95 760 810 2024-06-28
11230 Iced Caffè Americano 11230 95 95 540 590 2024-06-28
11231 Iced Cappuccino 11231 95 95 680 730 2024-06-28
11232 Iced Caffè Mocha 11232 95 95 750 800 2024-06-28
11233 Iced Caramel Macchiato 11233 95 95 760 810 2024-06-28
11234 Iced Caffè Latte 11234 95 95 680 730 2024-06-28
11235 Iced Oatmilk Latte 11235 95 95 760 810 2024-06-28
11236 Iced Vanilla Latte 11236 95 95 750 800 2024-06-28
11237 Iced White Chocolate Mocha 11237 95 95 750 800 2024-06-28
11238 Signature Hot Chocolate 11238 95 95 720 770 2024-06-28
11239 Signature Iced Chocolate 11239 95 95 720 770 2024-06-28
11240 Carrot Juice 11240 95 95 490 540 2024-06-28
11241 Cloudy Apple Juice 11241 95 95 490 540 2024-06-28
11242 Cranberry Red Grapefruit Juice 11242 95 95 490 540 2024-06-28
11243 Orange Juice 11243 95 95 490 540 2024-06-28
11244 Evian 11244 95 95 350 400 2024-06-28
11245 Sparkling Water 11245 95 95 450 500 2024-06-28
11246 Chai Tea 11246 95 95 500 550 2024-06-28
11247 Earl Grey Tea 11247 95 95 500 550 2024-06-28
11248 English Breakfast Tea 11248 95 95 500 550 2024-06-28
11249 Emperor’s Clouds & Mist™ Tea 11249 95 95 500 550 2024-06-28
11250 Mint Blend Tea 11250 95 95 500 550 2024-06-28
11251 Chamomile Tea 11251 95 95 500 550 2024-06-28
11252 Pure Matcha Latte 11252 95 95 740 790 2024-06-28
11253 Chai Tea Latte 11253 95 95 680 730 2024-06-28
11254 Earl Grey Tea Latte 11254 95 95 680 730 2024-06-28
11255 English Breakfast Tea Latte 11255 95 95 680 730 2024-06-28
11256 Hojicha Tea Latte 11256 95 95 740 790 2024-06-28
11257 Zen Clouds Oolong Tea 11257 95 95 500 550 2024-06-28
11258 Zen Clouds Oolong with Ruby Grapefruit and Honey 11258 95 95 630 680 2024-06-28
11259 Youthberry™ Tea 11259 95 95 500 550 2024-06-28
11260 Iced Shaken Black Tea Lemonade 11260 95 95 610 660 2024-06-28
11261 Iced Shaken Strawberry Black Tea Lemonade 11261 95 95 630 680 2024-06-28
11262 Iced Shaken Hibiscus Tea Lemonade 11262 95 95 610 660 2024-06-28
11263 Iced Shaken Hibiscus Tea with Pomegranate Pearls 11263 95 95 730 780 2024-06-28
11264 Iced Pure Matcha Latte 11264 95 95 740 790 2024-06-28
11265 Iced Chai Tea Latte 11265 95 95 680 730 2024-06-28
11266 Iced Black Tea Latte 11266 95 95 680 730 2024-06-28
11267 Iced Hojicha Tea Latte 11267 95 95 740 790 2024-06-28
11268 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 11268 95 95 630 680 2024-06-28
11269 Iced Shaken Zen Clouds Oolong Lemonade 11269 95 95 610 660 2024-06-28
11270 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 11270 95 95 630 680 2024-06-28
11271 Origami Pike Place® Roast 11271 95 95 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");