item_prices

Pricing information for Starbucks menu items in Singapore

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

243 rows where store_id = 88

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 88 · 243 ✖
id ▼ item_id store_id base_price delivery_price effective_date
12452 Bagel 12452 88 88 400 430 2024-06-28
12453 Cookie Crumble Cheesecake 12453 88 88 720 770 2024-06-28
12454 Good Ol' NY Cheesecake 12454 88 88 720 770 2024-06-28
12455 Signature Chocolate Cake 12455 88 88 720 770 2024-06-28
12456 Starbucks® Coffee Tiramisu Cake 12456 88 88 750 800 2024-06-28
12457 Strawberry Shortcake 12457 88 88 720 770 2024-06-28
12458 Chocolate Chunk Monster Cookie 12458 88 88 390 440 2024-06-28
12459 Banana Walnut Muffin 12459 88 88 450 500 2024-06-28
12460 Blueberry Crumble Muffin 12460 88 88 450 500 2024-06-28
12461 Chocolate Crumble Muffin 12461 88 88 450 500 2024-06-28
12462 Pancakes 12462 88 88 550 600 2024-06-28
12463 Almond Croissant 12463 88 88 470 520 2024-06-28
12464 Buttery Croissant 12464 88 88 400 430 2024-06-28
12465 Chocolate Croissant 12465 88 88 440 490 2024-06-28
12466 Creamy Chicken Foldover 12466 88 88 550 600 2024-06-28
12467 Sausage Roll 12467 88 88 550 600 2024-06-28
12468 Buttery Scone 12468 88 88 400 430 2024-06-28
12469 Country Chicken Pie 12469 88 88 690 740 2024-06-28
12470 Deep Dish Beef Pie 12470 88 88 690 740 2024-06-28
12471 Spinach & Mushroom Quiche 12471 88 88 690 740 2024-06-28
12472 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 12472 88 88 390 420 2024-06-28
12473 Mixed Nuts 12473 88 88 490 540 2024-06-28
12474 Caramel Waffles 12474 88 88 390 420 2024-06-28
12475 Chicken Ham & Cheese Panwich 12475 88 88 690 740 2024-06-28
12476 Egg Mayo & Cheese Multigrain Croissant 12476 88 88 690 740 2024-06-28
12477 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 12477 88 88 690 740 2024-06-28
12478 Rosemary Chicken & Emmental Cheese Croissant 12478 88 88 690 740 2024-06-28
12479 Scrambled Egg & Turkey Ham Pita 12479 88 88 690 740 2024-06-28
12480 Turkey Ham & Triple Cheese Toast 12480 88 88 690 740 2024-06-28
12481 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 12481 88 88 790 840 2024-06-28
12482 Ham & Cheese Croissant 12482 88 88 690 740 2024-06-28
12483 Sriracha Chicken Whole Wheat Pita 12483 88 88 750 800 2024-06-28
12484 Blueberry Acai Yogurt Parfait 12484 88 88 650 700 2024-06-28
12485 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 12485 88 88 650 700 2024-06-28
12486 Buttery Croissant 12486 88 88 400 450 2024-06-28
12487 Chocolate Croissant 12487 88 88 440 490 2024-06-28
12488 Raisin Danish 12488 88 88 470 520 2024-06-28
12489 Apple Tart 12489 88 88 620 670 2024-06-28
12490 Lemon Meringue Tart 12490 88 88 620 670 2024-06-28
12491 Caramel Frappuccino® 12491 88 88 720 770 2024-06-28
12492 Dark Mocha Frappuccino® 12492 88 88 780 830 2024-06-28
12493 Java Chip Frappuccino® 12493 88 88 780 830 2024-06-28
12494 Mocha Frappuccino® 12494 88 88 720 770 2024-06-28
12495 Caramel Macchiato Frappuccino® 12495 88 88 780 830 2024-06-28
12496 Espresso Frappuccino® 12496 88 88 720 770 2024-06-28
12497 White Chocolate Mocha Frappuccino® 12497 88 88 720 770 2024-06-28
12498 Chocolate Chip Cream Frappuccino® 12498 88 88 780 830 2024-06-28
12499 Hojicha Tea Cream Frappuccino® 12499 88 88 760 810 2024-06-28
12500 Vanilla Cream Frappuccino® 12500 88 88 720 770 2024-06-28
12501 Mango Passion Fruit & Hibiscus 12501 88 88 720 770 2024-06-28
12502 Raspberry Black Currant & Oolong 12502 88 88 720 770 2024-06-28
12503 Coffee Traveller 12503 88 88 3120 3170 2024-06-28
12504 Caffè Americano 12504 88 88 540 590 2024-06-28
12505 Cappuccino 12505 88 88 680 730 2024-06-28
12506 Caffè Mocha 12506 88 88 750 800 2024-06-28
12507 Caramel Macchiato 12507 88 88 760 810 2024-06-28
12508 Espresso 12508 88 88 390 440 2024-06-28
12509 Caffè Latte 12509 88 88 680 730 2024-06-28
12510 Oatmilk Latte 12510 88 88 760 810 2024-06-28
12511 Vanilla Latte 12511 88 88 750 800 2024-06-28
12512 White Chocolate Mocha 12512 88 88 750 800 2024-06-28
12513 Flat White 12513 88 88 760 810 2024-06-28
12514 Ristretto Bianco 12514 88 88 760 810 2024-06-28
12515 Iced Caffè Americano 12515 88 88 540 590 2024-06-28
12516 Iced Cappuccino 12516 88 88 680 730 2024-06-28
12517 Iced Caffè Mocha 12517 88 88 750 800 2024-06-28
12518 Iced Caramel Macchiato 12518 88 88 760 810 2024-06-28
12519 Iced Caffè Latte 12519 88 88 680 730 2024-06-28
12520 Iced Oatmilk Latte 12520 88 88 760 810 2024-06-28
12521 Iced Vanilla Latte 12521 88 88 750 800 2024-06-28
12522 Iced White Chocolate Mocha 12522 88 88 750 800 2024-06-28
12523 Signature Hot Chocolate 12523 88 88 720 770 2024-06-28
12524 Signature Iced Chocolate 12524 88 88 720 770 2024-06-28
12525 Carrot Juice 12525 88 88 490 540 2024-06-28
12526 Cloudy Apple Juice 12526 88 88 490 540 2024-06-28
12527 Cranberry Red Grapefruit Juice 12527 88 88 490 540 2024-06-28
12528 Orange Juice 12528 88 88 490 540 2024-06-28
12529 Evian 12529 88 88 350 400 2024-06-28
12530 Sparkling Water 12530 88 88 450 500 2024-06-28
12531 Chai Tea 12531 88 88 500 550 2024-06-28
12532 Earl Grey Tea 12532 88 88 500 550 2024-06-28
12533 English Breakfast Tea 12533 88 88 500 550 2024-06-28
12534 Emperor’s Clouds & Mist™ Tea 12534 88 88 500 550 2024-06-28
12535 Mint Blend Tea 12535 88 88 500 550 2024-06-28
12536 Chamomile Tea 12536 88 88 500 550 2024-06-28
12537 Pure Matcha Latte 12537 88 88 740 790 2024-06-28
12538 Chai Tea Latte 12538 88 88 680 730 2024-06-28
12539 Earl Grey Tea Latte 12539 88 88 680 730 2024-06-28
12540 English Breakfast Tea Latte 12540 88 88 680 730 2024-06-28
12541 Hojicha Tea Latte 12541 88 88 740 790 2024-06-28
12542 Zen Clouds Oolong Tea 12542 88 88 500 550 2024-06-28
12543 Zen Clouds Oolong with Ruby Grapefruit and Honey 12543 88 88 630 680 2024-06-28
12544 Youthberry™ Tea 12544 88 88 500 550 2024-06-28
12545 Iced Shaken Black Tea Lemonade 12545 88 88 610 660 2024-06-28
12546 Iced Shaken Strawberry Black Tea Lemonade 12546 88 88 630 680 2024-06-28
12547 Iced Shaken Hibiscus Tea Lemonade 12547 88 88 610 660 2024-06-28
12548 Iced Shaken Hibiscus Tea with Pomegranate Pearls 12548 88 88 730 780 2024-06-28
12549 Iced Pure Matcha Latte 12549 88 88 740 790 2024-06-28
12550 Iced Chai Tea Latte 12550 88 88 680 730 2024-06-28
12551 Iced Black Tea Latte 12551 88 88 680 730 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");