item_prices

Pricing information for Starbucks menu items in Singapore

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

182 rows where effective_date = "2024-06-28" and store_id = 83

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 83 · 182 ✖

effective_date 1

  • 2024-06-28 · 182 ✖
id ▼ item_id store_id base_price delivery_price effective_date
13386 Bagel 13386 83 83 400 430 2024-06-28
13387 Cookie Crumble Cheesecake 13387 83 83 720 770 2024-06-28
13388 Good Ol' NY Cheesecake 13388 83 83 720 770 2024-06-28
13389 Signature Chocolate Cake 13389 83 83 720 770 2024-06-28
13390 Starbucks® Coffee Tiramisu Cake 13390 83 83 750 800 2024-06-28
13391 Strawberry Shortcake 13391 83 83 720 770 2024-06-28
13392 Chocolate Chunk Monster Cookie 13392 83 83 390 440 2024-06-28
13393 Banana Walnut Muffin 13393 83 83 450 500 2024-06-28
13394 Blueberry Crumble Muffin 13394 83 83 450 500 2024-06-28
13395 Chocolate Crumble Muffin 13395 83 83 450 500 2024-06-28
13396 Pancakes 13396 83 83 550 600 2024-06-28
13397 Almond Croissant 13397 83 83 470 520 2024-06-28
13398 Buttery Croissant 13398 83 83 400 430 2024-06-28
13399 Chocolate Croissant 13399 83 83 440 490 2024-06-28
13400 Creamy Chicken Foldover 13400 83 83 550 600 2024-06-28
13401 Sausage Roll 13401 83 83 550 600 2024-06-28
13402 Buttery Scone 13402 83 83 400 430 2024-06-28
13403 Country Chicken Pie 13403 83 83 690 740 2024-06-28
13404 Deep Dish Beef Pie 13404 83 83 690 740 2024-06-28
13405 Spinach & Mushroom Quiche 13405 83 83 690 740 2024-06-28
13406 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 13406 83 83 390 420 2024-06-28
13407 Mixed Nuts 13407 83 83 490 540 2024-06-28
13408 Caramel Waffles 13408 83 83 390 420 2024-06-28
13409 Chicken Ham & Cheese Panwich 13409 83 83 690 740 2024-06-28
13410 Egg Mayo & Cheese Multigrain Croissant 13410 83 83 690 740 2024-06-28
13411 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 13411 83 83 690 740 2024-06-28
13412 Rosemary Chicken & Emmental Cheese Croissant 13412 83 83 690 740 2024-06-28
13413 Scrambled Egg & Turkey Ham Pita 13413 83 83 690 740 2024-06-28
13414 Turkey Ham & Triple Cheese Toast 13414 83 83 690 740 2024-06-28
13415 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 13415 83 83 790 840 2024-06-28
13416 Ham & Cheese Croissant 13416 83 83 690 740 2024-06-28
13417 Sriracha Chicken Whole Wheat Pita 13417 83 83 750 800 2024-06-28
13418 Blueberry Acai Yogurt Parfait 13418 83 83 650 700 2024-06-28
13419 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 13419 83 83 650 700 2024-06-28
13420 Caramel Frappuccino® 13420 83 83 720 770 2024-06-28
13421 Dark Mocha Frappuccino® 13421 83 83 780 830 2024-06-28
13422 Java Chip Frappuccino® 13422 83 83 780 830 2024-06-28
13423 Mocha Frappuccino® 13423 83 83 720 770 2024-06-28
13424 Caramel Macchiato Frappuccino® 13424 83 83 780 830 2024-06-28
13425 Espresso Frappuccino® 13425 83 83 720 770 2024-06-28
13426 White Chocolate Mocha Frappuccino® 13426 83 83 720 770 2024-06-28
13427 Chocolate Chip Cream Frappuccino® 13427 83 83 780 830 2024-06-28
13428 Hojicha Tea Cream Frappuccino® 13428 83 83 760 810 2024-06-28
13429 Vanilla Cream Frappuccino® 13429 83 83 720 770 2024-06-28
13430 Mango Passion Fruit & Hibiscus 13430 83 83 720 770 2024-06-28
13431 Raspberry Black Currant & Oolong 13431 83 83 720 770 2024-06-28
13432 Coffee Traveller 13432 83 83 3120 3170 2024-06-28
13433 Caffè Americano 13433 83 83 540 590 2024-06-28
13434 Cappuccino 13434 83 83 680 730 2024-06-28
13435 Caffè Mocha 13435 83 83 750 800 2024-06-28
13436 Caramel Macchiato 13436 83 83 760 810 2024-06-28
13437 Espresso 13437 83 83 390 440 2024-06-28
13438 Caffè Latte 13438 83 83 680 730 2024-06-28
13439 Oatmilk Latte 13439 83 83 760 810 2024-06-28
13440 Vanilla Latte 13440 83 83 750 800 2024-06-28
13441 White Chocolate Mocha 13441 83 83 750 800 2024-06-28
13442 Flat White 13442 83 83 760 810 2024-06-28
13443 Ristretto Bianco 13443 83 83 760 810 2024-06-28
13444 Iced Caffè Americano 13444 83 83 540 590 2024-06-28
13445 Iced Cappuccino 13445 83 83 680 730 2024-06-28
13446 Iced Caffè Mocha 13446 83 83 750 800 2024-06-28
13447 Iced Caramel Macchiato 13447 83 83 760 810 2024-06-28
13448 Iced Caffè Latte 13448 83 83 680 730 2024-06-28
13449 Iced Oatmilk Latte 13449 83 83 760 810 2024-06-28
13450 Iced Vanilla Latte 13450 83 83 750 800 2024-06-28
13451 Iced White Chocolate Mocha 13451 83 83 750 800 2024-06-28
13452 Signature Hot Chocolate 13452 83 83 720 770 2024-06-28
13453 Signature Iced Chocolate 13453 83 83 720 770 2024-06-28
13454 Carrot Juice 13454 83 83 490 540 2024-06-28
13455 Cloudy Apple Juice 13455 83 83 490 540 2024-06-28
13456 Cranberry Red Grapefruit Juice 13456 83 83 490 540 2024-06-28
13457 Orange Juice 13457 83 83 490 540 2024-06-28
13458 Evian 13458 83 83 350 400 2024-06-28
13459 Sparkling Water 13459 83 83 450 500 2024-06-28
13460 Chai Tea 13460 83 83 500 550 2024-06-28
13461 Earl Grey Tea 13461 83 83 500 550 2024-06-28
13462 English Breakfast Tea 13462 83 83 500 550 2024-06-28
13463 Emperor’s Clouds & Mist™ Tea 13463 83 83 500 550 2024-06-28
13464 Mint Blend Tea 13464 83 83 500 550 2024-06-28
13465 Chamomile Tea 13465 83 83 500 550 2024-06-28
13466 Pure Matcha Latte 13466 83 83 740 790 2024-06-28
13467 Chai Tea Latte 13467 83 83 680 730 2024-06-28
13468 Earl Grey Tea Latte 13468 83 83 680 730 2024-06-28
13469 English Breakfast Tea Latte 13469 83 83 680 730 2024-06-28
13470 Hojicha Tea Latte 13470 83 83 740 790 2024-06-28
13471 Zen Clouds Oolong Tea 13471 83 83 500 550 2024-06-28
13472 Zen Clouds Oolong with Ruby Grapefruit and Honey 13472 83 83 630 680 2024-06-28
13473 Youthberry™ Tea 13473 83 83 500 550 2024-06-28
13474 Iced Shaken Black Tea Lemonade 13474 83 83 610 660 2024-06-28
13475 Iced Shaken Strawberry Black Tea Lemonade 13475 83 83 630 680 2024-06-28
13476 Iced Shaken Hibiscus Tea Lemonade 13476 83 83 610 660 2024-06-28
13477 Iced Shaken Hibiscus Tea with Pomegranate Pearls 13477 83 83 730 780 2024-06-28
13478 Iced Pure Matcha Latte 13478 83 83 740 790 2024-06-28
13479 Iced Chai Tea Latte 13479 83 83 680 730 2024-06-28
13480 Iced Black Tea Latte 13480 83 83 680 730 2024-06-28
13481 Iced Hojicha Tea Latte 13481 83 83 740 790 2024-06-28
13482 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 13482 83 83 630 680 2024-06-28
13483 Iced Shaken Zen Clouds Oolong Lemonade 13483 83 83 610 660 2024-06-28
13484 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 13484 83 83 630 680 2024-06-28
13485 Origami Pike Place® Roast 13485 83 83 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");