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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 142 · 182 ✖

effective_date 1

  • 2024-06-28 · 182 ✖
id ▼ item_id store_id base_price delivery_price effective_date
3509 Bagel 3509 142 142 400 430 2024-06-28
3510 Cookie Crumble Cheesecake 3510 142 142 720 770 2024-06-28
3511 Good Ol' NY Cheesecake 3511 142 142 720 770 2024-06-28
3512 Signature Chocolate Cake 3512 142 142 720 770 2024-06-28
3513 Starbucks® Coffee Tiramisu Cake 3513 142 142 750 800 2024-06-28
3514 Strawberry Shortcake 3514 142 142 720 770 2024-06-28
3515 Chocolate Chunk Monster Cookie 3515 142 142 390 440 2024-06-28
3516 Banana Walnut Muffin 3516 142 142 450 500 2024-06-28
3517 Blueberry Crumble Muffin 3517 142 142 450 500 2024-06-28
3518 Chocolate Crumble Muffin 3518 142 142 450 500 2024-06-28
3519 Pancakes 3519 142 142 550 600 2024-06-28
3520 Almond Croissant 3520 142 142 470 520 2024-06-28
3521 Buttery Croissant 3521 142 142 400 430 2024-06-28
3522 Chocolate Croissant 3522 142 142 440 490 2024-06-28
3523 Creamy Chicken Foldover 3523 142 142 550 600 2024-06-28
3524 Sausage Roll 3524 142 142 550 600 2024-06-28
3525 Buttery Scone 3525 142 142 400 430 2024-06-28
3526 Country Chicken Pie 3526 142 142 690 740 2024-06-28
3527 Deep Dish Beef Pie 3527 142 142 690 740 2024-06-28
3528 Spinach & Mushroom Quiche 3528 142 142 690 740 2024-06-28
3529 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 3529 142 142 390 420 2024-06-28
3530 Mixed Nuts 3530 142 142 490 540 2024-06-28
3531 Caramel Waffles 3531 142 142 390 420 2024-06-28
3532 Chicken Ham & Cheese Panwich 3532 142 142 690 740 2024-06-28
3533 Egg Mayo & Cheese Multigrain Croissant 3533 142 142 690 740 2024-06-28
3534 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 3534 142 142 690 740 2024-06-28
3535 Rosemary Chicken & Emmental Cheese Croissant 3535 142 142 690 740 2024-06-28
3536 Scrambled Egg & Turkey Ham Pita 3536 142 142 690 740 2024-06-28
3537 Turkey Ham & Triple Cheese Toast 3537 142 142 690 740 2024-06-28
3538 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 3538 142 142 790 840 2024-06-28
3539 Ham & Cheese Croissant 3539 142 142 690 740 2024-06-28
3540 Sriracha Chicken Whole Wheat Pita 3540 142 142 750 800 2024-06-28
3541 Blueberry Acai Yogurt Parfait 3541 142 142 650 700 2024-06-28
3542 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 3542 142 142 650 700 2024-06-28
3543 Caramel Frappuccino® 3543 142 142 720 770 2024-06-28
3544 Dark Mocha Frappuccino® 3544 142 142 780 830 2024-06-28
3545 Java Chip Frappuccino® 3545 142 142 780 830 2024-06-28
3546 Mocha Frappuccino® 3546 142 142 720 770 2024-06-28
3547 Caramel Macchiato Frappuccino® 3547 142 142 780 830 2024-06-28
3548 Espresso Frappuccino® 3548 142 142 720 770 2024-06-28
3549 White Chocolate Mocha Frappuccino® 3549 142 142 720 770 2024-06-28
3550 Chocolate Chip Cream Frappuccino® 3550 142 142 780 830 2024-06-28
3551 Hojicha Tea Cream Frappuccino® 3551 142 142 760 810 2024-06-28
3552 Vanilla Cream Frappuccino® 3552 142 142 720 770 2024-06-28
3553 Mango Passion Fruit & Hibiscus 3553 142 142 720 770 2024-06-28
3554 Raspberry Black Currant & Oolong 3554 142 142 720 770 2024-06-28
3555 Coffee Traveller 3555 142 142 3120 3170 2024-06-28
3556 Caffè Americano 3556 142 142 540 590 2024-06-28
3557 Cappuccino 3557 142 142 680 730 2024-06-28
3558 Caffè Mocha 3558 142 142 750 800 2024-06-28
3559 Caramel Macchiato 3559 142 142 760 810 2024-06-28
3560 Espresso 3560 142 142 390 440 2024-06-28
3561 Caffè Latte 3561 142 142 680 730 2024-06-28
3562 Oatmilk Latte 3562 142 142 760 810 2024-06-28
3563 Vanilla Latte 3563 142 142 750 800 2024-06-28
3564 White Chocolate Mocha 3564 142 142 750 800 2024-06-28
3565 Flat White 3565 142 142 760 810 2024-06-28
3566 Ristretto Bianco 3566 142 142 760 810 2024-06-28
3567 Iced Caffè Americano 3567 142 142 540 590 2024-06-28
3568 Iced Cappuccino 3568 142 142 680 730 2024-06-28
3569 Iced Caffè Mocha 3569 142 142 750 800 2024-06-28
3570 Iced Caramel Macchiato 3570 142 142 760 810 2024-06-28
3571 Iced Caffè Latte 3571 142 142 680 730 2024-06-28
3572 Iced Oatmilk Latte 3572 142 142 760 810 2024-06-28
3573 Iced Vanilla Latte 3573 142 142 750 800 2024-06-28
3574 Iced White Chocolate Mocha 3574 142 142 750 800 2024-06-28
3575 Signature Hot Chocolate 3575 142 142 720 770 2024-06-28
3576 Signature Iced Chocolate 3576 142 142 720 770 2024-06-28
3577 Carrot Juice 3577 142 142 490 540 2024-06-28
3578 Cloudy Apple Juice 3578 142 142 490 540 2024-06-28
3579 Cranberry Red Grapefruit Juice 3579 142 142 490 540 2024-06-28
3580 Orange Juice 3580 142 142 490 540 2024-06-28
3581 Evian 3581 142 142 350 400 2024-06-28
3582 Sparkling Water 3582 142 142 450 500 2024-06-28
3583 Chai Tea 3583 142 142 500 550 2024-06-28
3584 Earl Grey Tea 3584 142 142 500 550 2024-06-28
3585 English Breakfast Tea 3585 142 142 500 550 2024-06-28
3586 Emperor’s Clouds & Mist™ Tea 3586 142 142 500 550 2024-06-28
3587 Mint Blend Tea 3587 142 142 500 550 2024-06-28
3588 Chamomile Tea 3588 142 142 500 550 2024-06-28
3589 Pure Matcha Latte 3589 142 142 740 790 2024-06-28
3590 Chai Tea Latte 3590 142 142 680 730 2024-06-28
3591 Earl Grey Tea Latte 3591 142 142 680 730 2024-06-28
3592 English Breakfast Tea Latte 3592 142 142 680 730 2024-06-28
3593 Hojicha Tea Latte 3593 142 142 740 790 2024-06-28
3594 Zen Clouds Oolong Tea 3594 142 142 500 550 2024-06-28
3595 Zen Clouds Oolong with Ruby Grapefruit and Honey 3595 142 142 630 680 2024-06-28
3596 Youthberry™ Tea 3596 142 142 500 550 2024-06-28
3597 Iced Shaken Black Tea Lemonade 3597 142 142 610 660 2024-06-28
3598 Iced Shaken Strawberry Black Tea Lemonade 3598 142 142 630 680 2024-06-28
3599 Iced Shaken Hibiscus Tea Lemonade 3599 142 142 610 660 2024-06-28
3600 Iced Shaken Hibiscus Tea with Pomegranate Pearls 3600 142 142 730 780 2024-06-28
3601 Iced Pure Matcha Latte 3601 142 142 740 790 2024-06-28
3602 Iced Chai Tea Latte 3602 142 142 680 730 2024-06-28
3603 Iced Black Tea Latte 3603 142 142 680 730 2024-06-28
3604 Iced Hojicha Tea Latte 3604 142 142 740 790 2024-06-28
3605 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 3605 142 142 630 680 2024-06-28
3606 Iced Shaken Zen Clouds Oolong Lemonade 3606 142 142 610 660 2024-06-28
3607 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 3607 142 142 630 680 2024-06-28
3608 Origami Pike Place® Roast 3608 142 142 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");