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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 74 · 249 ✖
id ▼ item_id store_id base_price delivery_price effective_date
14300 Bagel 14300 74 74 400 430 2024-06-28
14301 Cookie Crumble Cheesecake 14301 74 74 720 770 2024-06-28
14302 Good Ol' NY Cheesecake 14302 74 74 720 770 2024-06-28
14303 Signature Chocolate Cake 14303 74 74 720 770 2024-06-28
14304 Starbucks® Coffee Tiramisu Cake 14304 74 74 750 800 2024-06-28
14305 Strawberry Shortcake 14305 74 74 720 770 2024-06-28
14306 Chocolate Chunk Monster Cookie 14306 74 74 390 440 2024-06-28
14307 Banana Walnut Muffin 14307 74 74 450 500 2024-06-28
14308 Blueberry Crumble Muffin 14308 74 74 450 500 2024-06-28
14309 Chocolate Crumble Muffin 14309 74 74 450 500 2024-06-28
14310 Pancakes 14310 74 74 550 600 2024-06-28
14311 Almond Croissant 14311 74 74 470 520 2024-06-28
14312 Buttery Croissant 14312 74 74 400 430 2024-06-28
14313 Chocolate Croissant 14313 74 74 440 490 2024-06-28
14314 Creamy Chicken Foldover 14314 74 74 550 600 2024-06-28
14315 Sausage Roll 14315 74 74 550 600 2024-06-28
14316 Buttery Scone 14316 74 74 400 430 2024-06-28
14317 Country Chicken Pie 14317 74 74 690 740 2024-06-28
14318 Deep Dish Beef Pie 14318 74 74 690 740 2024-06-28
14319 Spinach & Mushroom Quiche 14319 74 74 690 740 2024-06-28
14320 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 14320 74 74 390 420 2024-06-28
14321 Mixed Nuts 14321 74 74 490 540 2024-06-28
14322 Caramel Waffles 14322 74 74 390 420 2024-06-28
14323 Chicken Ham & Cheese Panwich 14323 74 74 690 740 2024-06-28
14324 Egg Mayo & Cheese Multigrain Croissant 14324 74 74 690 740 2024-06-28
14325 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 14325 74 74 690 740 2024-06-28
14326 Rosemary Chicken & Emmental Cheese Croissant 14326 74 74 690 740 2024-06-28
14327 Scrambled Egg & Turkey Ham Pita 14327 74 74 690 740 2024-06-28
14328 Turkey Ham & Triple Cheese Toast 14328 74 74 690 740 2024-06-28
14329 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 14329 74 74 790 840 2024-06-28
14330 Ham & Cheese Croissant 14330 74 74 690 740 2024-06-28
14331 Sriracha Chicken Whole Wheat Pita 14331 74 74 750 800 2024-06-28
14332 Blueberry Acai Yogurt Parfait 14332 74 74 650 700 2024-06-28
14333 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 14333 74 74 650 700 2024-06-28
14334 Caramel Frappuccino® 14334 74 74 720 770 2024-06-28
14335 Dark Mocha Frappuccino® 14335 74 74 780 830 2024-06-28
14336 Java Chip Frappuccino® 14336 74 74 780 830 2024-06-28
14337 Mocha Frappuccino® 14337 74 74 720 770 2024-06-28
14338 Caramel Macchiato Frappuccino® 14338 74 74 780 830 2024-06-28
14339 Espresso Frappuccino® 14339 74 74 720 770 2024-06-28
14340 White Chocolate Mocha Frappuccino® 14340 74 74 720 770 2024-06-28
14341 Chocolate Chip Cream Frappuccino® 14341 74 74 780 830 2024-06-28
14342 Hojicha Tea Cream Frappuccino® 14342 74 74 760 810 2024-06-28
14343 Vanilla Cream Frappuccino® 14343 74 74 720 770 2024-06-28
14344 Mango Passion Fruit & Hibiscus 14344 74 74 720 770 2024-06-28
14345 Raspberry Black Currant & Oolong 14345 74 74 720 770 2024-06-28
14346 Coffee Traveller 14346 74 74 3120 3170 2024-06-28
14347 Caffè Americano 14347 74 74 540 590 2024-06-28
14348 Cappuccino 14348 74 74 680 730 2024-06-28
14349 Caffè Mocha 14349 74 74 750 800 2024-06-28
14350 Caramel Macchiato 14350 74 74 760 810 2024-06-28
14351 Espresso 14351 74 74 390 440 2024-06-28
14352 Caffè Latte 14352 74 74 680 730 2024-06-28
14353 Oatmilk Latte 14353 74 74 760 810 2024-06-28
14354 Vanilla Latte 14354 74 74 750 800 2024-06-28
14355 White Chocolate Mocha 14355 74 74 750 800 2024-06-28
14356 Flat White 14356 74 74 760 810 2024-06-28
14357 Ristretto Bianco 14357 74 74 760 810 2024-06-28
14358 Iced Caffè Americano 14358 74 74 540 590 2024-06-28
14359 Iced Cappuccino 14359 74 74 680 730 2024-06-28
14360 Iced Caffè Mocha 14360 74 74 750 800 2024-06-28
14361 Iced Caramel Macchiato 14361 74 74 760 810 2024-06-28
14362 Iced Caffè Latte 14362 74 74 680 730 2024-06-28
14363 Iced Oatmilk Latte 14363 74 74 760 810 2024-06-28
14364 Iced Vanilla Latte 14364 74 74 750 800 2024-06-28
14365 Iced White Chocolate Mocha 14365 74 74 750 800 2024-06-28
14366 Signature Hot Chocolate 14366 74 74 720 770 2024-06-28
14367 Signature Iced Chocolate 14367 74 74 720 770 2024-06-28
14368 Carrot Juice 14368 74 74 490 540 2024-06-28
14369 Cloudy Apple Juice 14369 74 74 490 540 2024-06-28
14370 Cranberry Red Grapefruit Juice 14370 74 74 490 540 2024-06-28
14371 Orange Juice 14371 74 74 490 540 2024-06-28
14372 Evian 14372 74 74 350 400 2024-06-28
14373 Sparkling Water 14373 74 74 450 500 2024-06-28
14374 Chai Tea 14374 74 74 500 550 2024-06-28
14375 Earl Grey Tea 14375 74 74 500 550 2024-06-28
14376 English Breakfast Tea 14376 74 74 500 550 2024-06-28
14377 Emperor’s Clouds & Mist™ Tea 14377 74 74 500 550 2024-06-28
14378 Mint Blend Tea 14378 74 74 500 550 2024-06-28
14379 Chamomile Tea 14379 74 74 500 550 2024-06-28
14380 Pure Matcha Latte 14380 74 74 740 790 2024-06-28
14381 Chai Tea Latte 14381 74 74 680 730 2024-06-28
14382 Earl Grey Tea Latte 14382 74 74 680 730 2024-06-28
14383 English Breakfast Tea Latte 14383 74 74 680 730 2024-06-28
14384 Hojicha Tea Latte 14384 74 74 740 790 2024-06-28
14385 Zen Clouds Oolong Tea 14385 74 74 500 550 2024-06-28
14386 Zen Clouds Oolong with Ruby Grapefruit and Honey 14386 74 74 630 680 2024-06-28
14387 Youthberry™ Tea 14387 74 74 500 550 2024-06-28
14388 Iced Shaken Black Tea Lemonade 14388 74 74 610 660 2024-06-28
14389 Iced Shaken Strawberry Black Tea Lemonade 14389 74 74 630 680 2024-06-28
14390 Iced Shaken Hibiscus Tea Lemonade 14390 74 74 610 660 2024-06-28
14391 Iced Shaken Hibiscus Tea with Pomegranate Pearls 14391 74 74 730 780 2024-06-28
14392 Iced Pure Matcha Latte 14392 74 74 740 790 2024-06-28
14393 Iced Chai Tea Latte 14393 74 74 680 730 2024-06-28
14394 Iced Black Tea Latte 14394 74 74 680 730 2024-06-28
14395 Iced Hojicha Tea Latte 14395 74 74 740 790 2024-06-28
14396 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 14396 74 74 630 680 2024-06-28
14397 Iced Shaken Zen Clouds Oolong Lemonade 14397 74 74 610 660 2024-06-28
14398 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 14398 74 74 630 680 2024-06-28
14399 Origami Pike Place® Roast 14399 74 74 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");