item_prices

Pricing information for Starbucks menu items in Singapore

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

248 rows where store_id = 51

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 51 · 248 ✖
id ▼ item_id store_id base_price delivery_price effective_date
18335 Bagel 18335 51 51 400 430 2024-06-28
18336 Cookie Crumble Cheesecake 18336 51 51 720 770 2024-06-28
18337 Good Ol' NY Cheesecake 18337 51 51 720 770 2024-06-28
18338 Signature Chocolate Cake 18338 51 51 720 770 2024-06-28
18339 Starbucks® Coffee Tiramisu Cake 18339 51 51 750 800 2024-06-28
18340 Strawberry Shortcake 18340 51 51 720 770 2024-06-28
18341 Chocolate Chunk Monster Cookie 18341 51 51 390 440 2024-06-28
18342 Banana Walnut Muffin 18342 51 51 450 500 2024-06-28
18343 Blueberry Crumble Muffin 18343 51 51 450 500 2024-06-28
18344 Chocolate Crumble Muffin 18344 51 51 450 500 2024-06-28
18345 Pancakes 18345 51 51 550 600 2024-06-28
18346 Almond Croissant 18346 51 51 470 520 2024-06-28
18347 Buttery Croissant 18347 51 51 400 430 2024-06-28
18348 Chocolate Croissant 18348 51 51 440 490 2024-06-28
18349 Creamy Chicken Foldover 18349 51 51 550 600 2024-06-28
18350 Sausage Roll 18350 51 51 550 600 2024-06-28
18351 Buttery Scone 18351 51 51 400 430 2024-06-28
18352 Country Chicken Pie 18352 51 51 690 740 2024-06-28
18353 Deep Dish Beef Pie 18353 51 51 690 740 2024-06-28
18354 Spinach & Mushroom Quiche 18354 51 51 690 740 2024-06-28
18355 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 18355 51 51 390 420 2024-06-28
18356 Mixed Nuts 18356 51 51 490 540 2024-06-28
18357 Caramel Waffles 18357 51 51 390 420 2024-06-28
18358 Chicken Ham & Cheese Panwich 18358 51 51 690 740 2024-06-28
18359 Egg Mayo & Cheese Multigrain Croissant 18359 51 51 690 740 2024-06-28
18360 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 18360 51 51 690 740 2024-06-28
18361 Rosemary Chicken & Emmental Cheese Croissant 18361 51 51 690 740 2024-06-28
18362 Scrambled Egg & Turkey Ham Pita 18362 51 51 690 740 2024-06-28
18363 Turkey Ham & Triple Cheese Toast 18363 51 51 690 740 2024-06-28
18364 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 18364 51 51 790 840 2024-06-28
18365 Ham & Cheese Croissant 18365 51 51 690 740 2024-06-28
18366 Sriracha Chicken Whole Wheat Pita 18366 51 51 750 800 2024-06-28
18367 Blueberry Acai Yogurt Parfait 18367 51 51 650 700 2024-06-28
18368 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 18368 51 51 650 700 2024-06-28
18369 Caramel Frappuccino® 18369 51 51 720 770 2024-06-28
18370 Dark Mocha Frappuccino® 18370 51 51 780 830 2024-06-28
18371 Java Chip Frappuccino® 18371 51 51 780 830 2024-06-28
18372 Mocha Frappuccino® 18372 51 51 720 770 2024-06-28
18373 Caramel Macchiato Frappuccino® 18373 51 51 780 830 2024-06-28
18374 Espresso Frappuccino® 18374 51 51 720 770 2024-06-28
18375 White Chocolate Mocha Frappuccino® 18375 51 51 720 770 2024-06-28
18376 Chocolate Chip Cream Frappuccino® 18376 51 51 780 830 2024-06-28
18377 Hojicha Tea Cream Frappuccino® 18377 51 51 760 810 2024-06-28
18378 Vanilla Cream Frappuccino® 18378 51 51 720 770 2024-06-28
18379 Mango Passion Fruit & Hibiscus 18379 51 51 720 770 2024-06-28
18380 Raspberry Black Currant & Oolong 18380 51 51 720 770 2024-06-28
18381 Coffee Traveller 18381 51 51 3120 3170 2024-06-28
18382 Caffè Americano 18382 51 51 540 590 2024-06-28
18383 Cappuccino 18383 51 51 680 730 2024-06-28
18384 Caffè Mocha 18384 51 51 750 800 2024-06-28
18385 Caramel Macchiato 18385 51 51 760 810 2024-06-28
18386 Espresso 18386 51 51 390 440 2024-06-28
18387 Caffè Latte 18387 51 51 680 730 2024-06-28
18388 Oatmilk Latte 18388 51 51 760 810 2024-06-28
18389 Vanilla Latte 18389 51 51 750 800 2024-06-28
18390 White Chocolate Mocha 18390 51 51 750 800 2024-06-28
18391 Flat White 18391 51 51 760 810 2024-06-28
18392 Ristretto Bianco 18392 51 51 760 810 2024-06-28
18393 Iced Caffè Americano 18393 51 51 540 590 2024-06-28
18394 Iced Cappuccino 18394 51 51 680 730 2024-06-28
18395 Iced Caffè Mocha 18395 51 51 750 800 2024-06-28
18396 Iced Caramel Macchiato 18396 51 51 760 810 2024-06-28
18397 Iced Caffè Latte 18397 51 51 680 730 2024-06-28
18398 Iced Oatmilk Latte 18398 51 51 760 810 2024-06-28
18399 Iced Vanilla Latte 18399 51 51 750 800 2024-06-28
18400 Iced White Chocolate Mocha 18400 51 51 750 800 2024-06-28
18401 Signature Hot Chocolate 18401 51 51 720 770 2024-06-28
18402 Signature Iced Chocolate 18402 51 51 720 770 2024-06-28
18403 Carrot Juice 18403 51 51 490 540 2024-06-28
18404 Cloudy Apple Juice 18404 51 51 490 540 2024-06-28
18405 Cranberry Red Grapefruit Juice 18405 51 51 490 540 2024-06-28
18406 Orange Juice 18406 51 51 490 540 2024-06-28
18407 Evian 18407 51 51 350 400 2024-06-28
18408 Sparkling Water 18408 51 51 450 500 2024-06-28
18409 Chai Tea 18409 51 51 500 550 2024-06-28
18410 Earl Grey Tea 18410 51 51 500 550 2024-06-28
18411 English Breakfast Tea 18411 51 51 500 550 2024-06-28
18412 Emperor’s Clouds & Mist™ Tea 18412 51 51 500 550 2024-06-28
18413 Mint Blend Tea 18413 51 51 500 550 2024-06-28
18414 Chamomile Tea 18414 51 51 500 550 2024-06-28
18415 Pure Matcha Latte 18415 51 51 740 790 2024-06-28
18416 Chai Tea Latte 18416 51 51 680 730 2024-06-28
18417 Earl Grey Tea Latte 18417 51 51 680 730 2024-06-28
18418 English Breakfast Tea Latte 18418 51 51 680 730 2024-06-28
18419 Hojicha Tea Latte 18419 51 51 740 790 2024-06-28
18420 Zen Clouds Oolong Tea 18420 51 51 500 550 2024-06-28
18421 Zen Clouds Oolong with Ruby Grapefruit and Honey 18421 51 51 630 680 2024-06-28
18422 Youthberry™ Tea 18422 51 51 500 550 2024-06-28
18423 Iced Shaken Black Tea Lemonade 18423 51 51 610 660 2024-06-28
18424 Iced Shaken Strawberry Black Tea Lemonade 18424 51 51 630 680 2024-06-28
18425 Iced Shaken Hibiscus Tea Lemonade 18425 51 51 610 660 2024-06-28
18426 Iced Shaken Hibiscus Tea with Pomegranate Pearls 18426 51 51 730 780 2024-06-28
18427 Iced Pure Matcha Latte 18427 51 51 740 790 2024-06-28
18428 Iced Chai Tea Latte 18428 51 51 680 730 2024-06-28
18429 Iced Black Tea Latte 18429 51 51 680 730 2024-06-28
18430 Iced Hojicha Tea Latte 18430 51 51 740 790 2024-06-28
18431 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 18431 51 51 630 680 2024-06-28
18432 Iced Shaken Zen Clouds Oolong Lemonade 18432 51 51 610 660 2024-06-28
18433 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 18433 51 51 630 680 2024-06-28
18434 Origami Pike Place® Roast 18434 51 51 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");