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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 26 · 249 ✖
id ▼ item_id store_id base_price delivery_price effective_date
22351 Bagel 22351 26 26 400 430 2024-06-28
22352 Cookie Crumble Cheesecake 22352 26 26 720 770 2024-06-28
22353 Good Ol' NY Cheesecake 22353 26 26 720 770 2024-06-28
22354 Signature Chocolate Cake 22354 26 26 720 770 2024-06-28
22355 Starbucks® Coffee Tiramisu Cake 22355 26 26 750 800 2024-06-28
22356 Strawberry Shortcake 22356 26 26 720 770 2024-06-28
22357 Chocolate Chunk Monster Cookie 22357 26 26 390 440 2024-06-28
22358 Banana Walnut Muffin 22358 26 26 450 500 2024-06-28
22359 Blueberry Crumble Muffin 22359 26 26 450 500 2024-06-28
22360 Chocolate Crumble Muffin 22360 26 26 450 500 2024-06-28
22361 Pancakes 22361 26 26 550 600 2024-06-28
22362 Almond Croissant 22362 26 26 470 520 2024-06-28
22363 Buttery Croissant 22363 26 26 400 430 2024-06-28
22364 Chocolate Croissant 22364 26 26 440 490 2024-06-28
22365 Creamy Chicken Foldover 22365 26 26 550 600 2024-06-28
22366 Sausage Roll 22366 26 26 550 600 2024-06-28
22367 Buttery Scone 22367 26 26 400 430 2024-06-28
22368 Country Chicken Pie 22368 26 26 690 740 2024-06-28
22369 Deep Dish Beef Pie 22369 26 26 690 740 2024-06-28
22370 Spinach & Mushroom Quiche 22370 26 26 690 740 2024-06-28
22371 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 22371 26 26 390 420 2024-06-28
22372 Mixed Nuts 22372 26 26 490 540 2024-06-28
22373 Caramel Waffles 22373 26 26 390 420 2024-06-28
22374 Chicken Ham & Cheese Panwich 22374 26 26 690 740 2024-06-28
22375 Egg Mayo & Cheese Multigrain Croissant 22375 26 26 690 740 2024-06-28
22376 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 22376 26 26 690 740 2024-06-28
22377 Rosemary Chicken & Emmental Cheese Croissant 22377 26 26 690 740 2024-06-28
22378 Scrambled Egg & Turkey Ham Pita 22378 26 26 690 740 2024-06-28
22379 Turkey Ham & Triple Cheese Toast 22379 26 26 690 740 2024-06-28
22380 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 22380 26 26 790 840 2024-06-28
22381 Ham & Cheese Croissant 22381 26 26 690 740 2024-06-28
22382 Sriracha Chicken Whole Wheat Pita 22382 26 26 750 800 2024-06-28
22383 Blueberry Acai Yogurt Parfait 22383 26 26 650 700 2024-06-28
22384 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 22384 26 26 650 700 2024-06-28
22385 Caramel Frappuccino® 22385 26 26 720 770 2024-06-28
22386 Dark Mocha Frappuccino® 22386 26 26 780 830 2024-06-28
22387 Java Chip Frappuccino® 22387 26 26 780 830 2024-06-28
22388 Mocha Frappuccino® 22388 26 26 720 770 2024-06-28
22389 Caramel Macchiato Frappuccino® 22389 26 26 780 830 2024-06-28
22390 Espresso Frappuccino® 22390 26 26 720 770 2024-06-28
22391 White Chocolate Mocha Frappuccino® 22391 26 26 720 770 2024-06-28
22392 Chocolate Chip Cream Frappuccino® 22392 26 26 780 830 2024-06-28
22393 Hojicha Tea Cream Frappuccino® 22393 26 26 760 810 2024-06-28
22394 Vanilla Cream Frappuccino® 22394 26 26 720 770 2024-06-28
22395 Mango Passion Fruit & Hibiscus 22395 26 26 720 770 2024-06-28
22396 Raspberry Black Currant & Oolong 22396 26 26 720 770 2024-06-28
22397 Coffee Traveller 22397 26 26 3120 3170 2024-06-28
22398 Caffè Americano 22398 26 26 540 590 2024-06-28
22399 Cappuccino 22399 26 26 680 730 2024-06-28
22400 Caffè Mocha 22400 26 26 750 800 2024-06-28
22401 Caramel Macchiato 22401 26 26 760 810 2024-06-28
22402 Espresso 22402 26 26 390 440 2024-06-28
22403 Caffè Latte 22403 26 26 680 730 2024-06-28
22404 Oatmilk Latte 22404 26 26 760 810 2024-06-28
22405 Vanilla Latte 22405 26 26 750 800 2024-06-28
22406 White Chocolate Mocha 22406 26 26 750 800 2024-06-28
22407 Flat White 22407 26 26 760 810 2024-06-28
22408 Ristretto Bianco 22408 26 26 760 810 2024-06-28
22409 Iced Caffè Americano 22409 26 26 540 590 2024-06-28
22410 Iced Cappuccino 22410 26 26 680 730 2024-06-28
22411 Iced Caffè Mocha 22411 26 26 750 800 2024-06-28
22412 Iced Caramel Macchiato 22412 26 26 760 810 2024-06-28
22413 Iced Caffè Latte 22413 26 26 680 730 2024-06-28
22414 Iced Oatmilk Latte 22414 26 26 760 810 2024-06-28
22415 Iced Vanilla Latte 22415 26 26 750 800 2024-06-28
22416 Iced White Chocolate Mocha 22416 26 26 750 800 2024-06-28
22417 Signature Hot Chocolate 22417 26 26 720 770 2024-06-28
22418 Signature Iced Chocolate 22418 26 26 720 770 2024-06-28
22419 Carrot Juice 22419 26 26 490 540 2024-06-28
22420 Cloudy Apple Juice 22420 26 26 490 540 2024-06-28
22421 Cranberry Red Grapefruit Juice 22421 26 26 490 540 2024-06-28
22422 Orange Juice 22422 26 26 490 540 2024-06-28
22423 Evian 22423 26 26 350 400 2024-06-28
22424 Sparkling Water 22424 26 26 450 500 2024-06-28
22425 Chai Tea 22425 26 26 500 550 2024-06-28
22426 Earl Grey Tea 22426 26 26 500 550 2024-06-28
22427 English Breakfast Tea 22427 26 26 500 550 2024-06-28
22428 Emperor’s Clouds & Mist™ Tea 22428 26 26 500 550 2024-06-28
22429 Mint Blend Tea 22429 26 26 500 550 2024-06-28
22430 Chamomile Tea 22430 26 26 500 550 2024-06-28
22431 Pure Matcha Latte 22431 26 26 740 790 2024-06-28
22432 Chai Tea Latte 22432 26 26 680 730 2024-06-28
22433 Earl Grey Tea Latte 22433 26 26 680 730 2024-06-28
22434 English Breakfast Tea Latte 22434 26 26 680 730 2024-06-28
22435 Hojicha Tea Latte 22435 26 26 740 790 2024-06-28
22436 Zen Clouds Oolong Tea 22436 26 26 500 550 2024-06-28
22437 Zen Clouds Oolong with Ruby Grapefruit and Honey 22437 26 26 630 680 2024-06-28
22438 Youthberry™ Tea 22438 26 26 500 550 2024-06-28
22439 Iced Shaken Black Tea Lemonade 22439 26 26 610 660 2024-06-28
22440 Iced Shaken Strawberry Black Tea Lemonade 22440 26 26 630 680 2024-06-28
22441 Iced Shaken Hibiscus Tea Lemonade 22441 26 26 610 660 2024-06-28
22442 Iced Shaken Hibiscus Tea with Pomegranate Pearls 22442 26 26 730 780 2024-06-28
22443 Iced Pure Matcha Latte 22443 26 26 740 790 2024-06-28
22444 Iced Chai Tea Latte 22444 26 26 680 730 2024-06-28
22445 Iced Black Tea Latte 22445 26 26 680 730 2024-06-28
22446 Iced Hojicha Tea Latte 22446 26 26 740 790 2024-06-28
22447 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 22447 26 26 630 680 2024-06-28
22448 Iced Shaken Zen Clouds Oolong Lemonade 22448 26 26 610 660 2024-06-28
22449 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 22449 26 26 630 680 2024-06-28
22450 Origami Pike Place® Roast 22450 26 26 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");