item_prices

Pricing information for Starbucks menu items in Singapore

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

229 rows where store_id = 57

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 57 · 229 ✖
id ▼ item_id store_id base_price delivery_price effective_date
17236 Bagel 17236 57 57 360 390 2024-06-28
17237 Cookie Crumble Cheesecake 17237 57 57 650 700 2024-06-28
17238 Good Ol' NY Cheesecake 17238 57 57 650 700 2024-06-28
17239 Signature Chocolate Cake 17239 57 57 650 700 2024-06-28
17240 Starbucks® Coffee Tiramisu Cake 17240 57 57 670 720 2024-06-28
17241 Strawberry Shortcake 17241 57 57 650 700 2024-06-28
17242 Chocolate Chunk Monster Cookie 17242 57 57 350 400 2024-06-28
17243 Banana Walnut Muffin 17243 57 57 400 450 2024-06-28
17244 Blueberry Crumble Muffin 17244 57 57 400 450 2024-06-28
17245 Chocolate Crumble Muffin 17245 57 57 400 450 2024-06-28
17246 Pancakes 17246 57 57 490 540 2024-06-28
17247 Almond Croissant 17247 57 57 420 470 2024-06-28
17248 Buttery Croissant 17248 57 57 360 390 2024-06-28
17249 Chocolate Croissant 17249 57 57 390 440 2024-06-28
17250 Creamy Chicken Foldover 17250 57 57 490 540 2024-06-28
17251 Sausage Roll 17251 57 57 490 540 2024-06-28
17252 Buttery Scone 17252 57 57 360 390 2024-06-28
17253 Country Chicken Pie 17253 57 57 620 670 2024-06-28
17254 Deep Dish Beef Pie 17254 57 57 620 670 2024-06-28
17255 Spinach & Mushroom Quiche 17255 57 57 620 670 2024-06-28
17256 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 17256 57 57 350 380 2024-06-28
17257 Mixed Nuts 17257 57 57 440 490 2024-06-28
17258 Caramel Waffles 17258 57 57 350 380 2024-06-28
17259 Chicken Ham & Cheese Panwich 17259 57 57 620 670 2024-06-28
17260 Egg Mayo & Cheese Multigrain Croissant 17260 57 57 620 670 2024-06-28
17261 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 17261 57 57 620 670 2024-06-28
17262 Rosemary Chicken & Emmental Cheese Croissant 17262 57 57 620 670 2024-06-28
17263 Scrambled Egg & Turkey Ham Pita 17263 57 57 620 670 2024-06-28
17264 Turkey Ham & Triple Cheese Toast 17264 57 57 620 670 2024-06-28
17265 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 17265 57 57 710 760 2024-06-28
17266 Ham & Cheese Croissant 17266 57 57 620 670 2024-06-28
17267 Sriracha Chicken Whole Wheat Pita 17267 57 57 670 720 2024-06-28
17268 Blueberry Acai Yogurt Parfait 17268 57 57 580 630 2024-06-28
17269 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 17269 57 57 580 630 2024-06-28
17270 Caramel Frappuccino® 17270 57 57 650 700 2024-06-28
17271 Dark Mocha Frappuccino® 17271 57 57 710 760 2024-06-28
17272 Java Chip Frappuccino® 17272 57 57 710 760 2024-06-28
17273 Mocha Frappuccino® 17273 57 57 650 700 2024-06-28
17274 Caramel Macchiato Frappuccino® 17274 57 57 710 760 2024-06-28
17275 Espresso Frappuccino® 17275 57 57 650 700 2024-06-28
17276 White Chocolate Mocha Frappuccino® 17276 57 57 650 700 2024-06-28
17277 Chocolate Chip Cream Frappuccino® 17277 57 57 710 760 2024-06-28
17278 Hojicha Tea Cream Frappuccino® 17278 57 57 690 740 2024-06-28
17279 Vanilla Cream Frappuccino® 17279 57 57 650 700 2024-06-28
17280 Mango Passion Fruit & Hibiscus 17280 57 57 650 700 2024-06-28
17281 Raspberry Black Currant & Oolong 17281 57 57 650 700 2024-06-28
17282 Coffee Traveller 17282 57 57 2800 2850 2024-06-28
17283 Caffè Americano 17283 57 57 490 540 2024-06-28
17284 Cappuccino 17284 57 57 620 670 2024-06-28
17285 Caffè Mocha 17285 57 57 680 730 2024-06-28
17286 Caramel Macchiato 17286 57 57 690 740 2024-06-28
17287 Espresso 17287 57 57 350 400 2024-06-28
17288 Caffè Latte 17288 57 57 620 670 2024-06-28
17289 Oatmilk Latte 17289 57 57 690 740 2024-06-28
17290 Vanilla Latte 17290 57 57 680 730 2024-06-28
17291 White Chocolate Mocha 17291 57 57 680 730 2024-06-28
17292 Flat White 17292 57 57 690 740 2024-06-28
17293 Ristretto Bianco 17293 57 57 690 740 2024-06-28
17294 Iced Caffè Americano 17294 57 57 490 540 2024-06-28
17295 Iced Cappuccino 17295 57 57 620 670 2024-06-28
17296 Iced Caffè Mocha 17296 57 57 680 730 2024-06-28
17297 Iced Caramel Macchiato 17297 57 57 690 740 2024-06-28
17298 Iced Caffè Latte 17298 57 57 620 670 2024-06-28
17299 Iced Oatmilk Latte 17299 57 57 690 740 2024-06-28
17300 Iced Vanilla Latte 17300 57 57 680 730 2024-06-28
17301 Iced White Chocolate Mocha 17301 57 57 680 730 2024-06-28
17302 Signature Hot Chocolate 17302 57 57 650 700 2024-06-28
17303 Signature Iced Chocolate 17303 57 57 650 700 2024-06-28
17304 Carrot Juice 17304 57 57 440 490 2024-06-28
17305 Cloudy Apple Juice 17305 57 57 440 490 2024-06-28
17306 Cranberry Red Grapefruit Juice 17306 57 57 440 490 2024-06-28
17307 Orange Juice 17307 57 57 440 490 2024-06-28
17308 Evian 17308 57 57 310 360 2024-06-28
17309 Sparkling Water 17309 57 57 400 450 2024-06-28
17310 Chai Tea 17310 57 57 450 500 2024-06-28
17311 Earl Grey Tea 17311 57 57 450 500 2024-06-28
17312 English Breakfast Tea 17312 57 57 450 500 2024-06-28
17313 Emperor’s Clouds & Mist™ Tea 17313 57 57 450 500 2024-06-28
17314 Mint Blend Tea 17314 57 57 450 500 2024-06-28
17315 Chamomile Tea 17315 57 57 450 500 2024-06-28
17316 Pure Matcha Latte 17316 57 57 670 720 2024-06-28
17317 Chai Tea Latte 17317 57 57 620 670 2024-06-28
17318 Earl Grey Tea Latte 17318 57 57 620 670 2024-06-28
17319 English Breakfast Tea Latte 17319 57 57 620 670 2024-06-28
17320 Hojicha Tea Latte 17320 57 57 670 720 2024-06-28
17321 Zen Clouds Oolong Tea 17321 57 57 450 500 2024-06-28
17322 Zen Clouds Oolong with Ruby Grapefruit and Honey 17322 57 57 580 630 2024-06-28
17323 Youthberry™ Tea 17323 57 57 450 500 2024-06-28
17324 Iced Shaken Black Tea Lemonade 17324 57 57 560 610 2024-06-28
17325 Iced Shaken Strawberry Black Tea Lemonade 17325 57 57 580 630 2024-06-28
17326 Iced Shaken Hibiscus Tea Lemonade 17326 57 57 560 610 2024-06-28
17327 Iced Shaken Hibiscus Tea with Pomegranate Pearls 17327 57 57 660 710 2024-06-28
17328 Iced Pure Matcha Latte 17328 57 57 670 720 2024-06-28
17329 Iced Chai Tea Latte 17329 57 57 620 670 2024-06-28
17330 Iced Black Tea Latte 17330 57 57 620 670 2024-06-28
17331 Iced Hojicha Tea Latte 17331 57 57 670 720 2024-06-28
17332 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 17332 57 57 580 630 2024-06-28
17333 Iced Shaken Zen Clouds Oolong Lemonade 17333 57 57 560 610 2024-06-28
17334 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 17334 57 57 580 630 2024-06-28
17335 Origami Pike Place® Roast 17335 57 57 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");