item_prices

Pricing information for Starbucks menu items in Singapore

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

234 rows where store_id = 61

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 61 · 234 ✖
id ▼ item_id store_id base_price delivery_price effective_date
16495 Bagel 16495 61 61 400 430 2024-06-28
16496 Cookie Crumble Cheesecake 16496 61 61 720 770 2024-06-28
16497 Good Ol' NY Cheesecake 16497 61 61 720 770 2024-06-28
16498 Signature Chocolate Cake 16498 61 61 720 770 2024-06-28
16499 Starbucks® Coffee Tiramisu Cake 16499 61 61 750 800 2024-06-28
16500 Strawberry Shortcake 16500 61 61 720 770 2024-06-28
16501 Chocolate Chunk Monster Cookie 16501 61 61 390 440 2024-06-28
16502 Banana Walnut Muffin 16502 61 61 450 500 2024-06-28
16503 Blueberry Crumble Muffin 16503 61 61 450 500 2024-06-28
16504 Chocolate Crumble Muffin 16504 61 61 450 500 2024-06-28
16505 Pancakes 16505 61 61 550 600 2024-06-28
16506 Almond Croissant 16506 61 61 470 520 2024-06-28
16507 Buttery Croissant 16507 61 61 400 430 2024-06-28
16508 Chocolate Croissant 16508 61 61 440 490 2024-06-28
16509 Creamy Chicken Foldover 16509 61 61 550 600 2024-06-28
16510 Sausage Roll 16510 61 61 550 600 2024-06-28
16511 Buttery Scone 16511 61 61 400 430 2024-06-28
16512 Country Chicken Pie 16512 61 61 690 740 2024-06-28
16513 Deep Dish Beef Pie 16513 61 61 690 740 2024-06-28
16514 Spinach & Mushroom Quiche 16514 61 61 690 740 2024-06-28
16515 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 16515 61 61 390 420 2024-06-28
16516 Mixed Nuts 16516 61 61 490 540 2024-06-28
16517 Caramel Waffles 16517 61 61 390 420 2024-06-28
16518 Chicken Ham & Cheese Panwich 16518 61 61 690 740 2024-06-28
16519 Egg Mayo & Cheese Multigrain Croissant 16519 61 61 690 740 2024-06-28
16520 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 16520 61 61 690 740 2024-06-28
16521 Rosemary Chicken & Emmental Cheese Croissant 16521 61 61 690 740 2024-06-28
16522 Scrambled Egg & Turkey Ham Pita 16522 61 61 690 740 2024-06-28
16523 Turkey Ham & Triple Cheese Toast 16523 61 61 690 740 2024-06-28
16524 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 16524 61 61 790 840 2024-06-28
16525 Ham & Cheese Croissant 16525 61 61 690 740 2024-06-28
16526 Sriracha Chicken Whole Wheat Pita 16526 61 61 750 800 2024-06-28
16527 Blueberry Acai Yogurt Parfait 16527 61 61 650 700 2024-06-28
16528 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 16528 61 61 650 700 2024-06-28
16529 Caramel Frappuccino® 16529 61 61 720 770 2024-06-28
16530 Dark Mocha Frappuccino® 16530 61 61 780 830 2024-06-28
16531 Java Chip Frappuccino® 16531 61 61 780 830 2024-06-28
16532 Mocha Frappuccino® 16532 61 61 720 770 2024-06-28
16533 Caramel Macchiato Frappuccino® 16533 61 61 780 830 2024-06-28
16534 Espresso Frappuccino® 16534 61 61 720 770 2024-06-28
16535 White Chocolate Mocha Frappuccino® 16535 61 61 720 770 2024-06-28
16536 Chocolate Chip Cream Frappuccino® 16536 61 61 780 830 2024-06-28
16537 Hojicha Tea Cream Frappuccino® 16537 61 61 760 810 2024-06-28
16538 Vanilla Cream Frappuccino® 16538 61 61 720 770 2024-06-28
16539 Mango Passion Fruit & Hibiscus 16539 61 61 720 770 2024-06-28
16540 Raspberry Black Currant & Oolong 16540 61 61 720 770 2024-06-28
16541 Coffee Traveller 16541 61 61 3120 3170 2024-06-28
16542 Caffè Americano 16542 61 61 540 590 2024-06-28
16543 Cappuccino 16543 61 61 680 730 2024-06-28
16544 Caffè Mocha 16544 61 61 750 800 2024-06-28
16545 Caramel Macchiato 16545 61 61 760 810 2024-06-28
16546 Espresso 16546 61 61 390 440 2024-06-28
16547 Caffè Latte 16547 61 61 680 730 2024-06-28
16548 Oatmilk Latte 16548 61 61 760 810 2024-06-28
16549 Vanilla Latte 16549 61 61 750 800 2024-06-28
16550 White Chocolate Mocha 16550 61 61 750 800 2024-06-28
16551 Flat White 16551 61 61 760 810 2024-06-28
16552 Ristretto Bianco 16552 61 61 760 810 2024-06-28
16553 Iced Caffè Americano 16553 61 61 540 590 2024-06-28
16554 Iced Cappuccino 16554 61 61 680 730 2024-06-28
16555 Iced Caffè Mocha 16555 61 61 750 800 2024-06-28
16556 Iced Caramel Macchiato 16556 61 61 760 810 2024-06-28
16557 Iced Caffè Latte 16557 61 61 680 730 2024-06-28
16558 Iced Oatmilk Latte 16558 61 61 760 810 2024-06-28
16559 Iced Vanilla Latte 16559 61 61 750 800 2024-06-28
16560 Iced White Chocolate Mocha 16560 61 61 750 800 2024-06-28
16561 Signature Hot Chocolate 16561 61 61 720 770 2024-06-28
16562 Signature Iced Chocolate 16562 61 61 720 770 2024-06-28
16563 Carrot Juice 16563 61 61 490 540 2024-06-28
16564 Cloudy Apple Juice 16564 61 61 490 540 2024-06-28
16565 Cranberry Red Grapefruit Juice 16565 61 61 490 540 2024-06-28
16566 Orange Juice 16566 61 61 490 540 2024-06-28
16567 Evian 16567 61 61 350 400 2024-06-28
16568 Sparkling Water 16568 61 61 450 500 2024-06-28
16569 Chai Tea 16569 61 61 500 550 2024-06-28
16570 Earl Grey Tea 16570 61 61 500 550 2024-06-28
16571 English Breakfast Tea 16571 61 61 500 550 2024-06-28
16572 Emperor’s Clouds & Mist™ Tea 16572 61 61 500 550 2024-06-28
16573 Mint Blend Tea 16573 61 61 500 550 2024-06-28
16574 Chamomile Tea 16574 61 61 500 550 2024-06-28
16575 Pure Matcha Latte 16575 61 61 740 790 2024-06-28
16576 Chai Tea Latte 16576 61 61 680 730 2024-06-28
16577 Earl Grey Tea Latte 16577 61 61 680 730 2024-06-28
16578 English Breakfast Tea Latte 16578 61 61 680 730 2024-06-28
16579 Hojicha Tea Latte 16579 61 61 740 790 2024-06-28
16580 Zen Clouds Oolong Tea 16580 61 61 500 550 2024-06-28
16581 Zen Clouds Oolong with Ruby Grapefruit and Honey 16581 61 61 630 680 2024-06-28
16582 Youthberry™ Tea 16582 61 61 500 550 2024-06-28
16583 Iced Shaken Black Tea Lemonade 16583 61 61 610 660 2024-06-28
16584 Iced Shaken Strawberry Black Tea Lemonade 16584 61 61 630 680 2024-06-28
16585 Iced Shaken Hibiscus Tea Lemonade 16585 61 61 610 660 2024-06-28
16586 Iced Shaken Hibiscus Tea with Pomegranate Pearls 16586 61 61 730 780 2024-06-28
16587 Iced Pure Matcha Latte 16587 61 61 740 790 2024-06-28
16588 Iced Chai Tea Latte 16588 61 61 680 730 2024-06-28
16589 Iced Black Tea Latte 16589 61 61 680 730 2024-06-28
16590 Iced Hojicha Tea Latte 16590 61 61 740 790 2024-06-28
16591 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 16591 61 61 630 680 2024-06-28
16592 Iced Shaken Zen Clouds Oolong Lemonade 16592 61 61 610 660 2024-06-28
16593 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 16593 61 61 630 680 2024-06-28
16594 Origami Pike Place® Roast 16594 61 61 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");