item_prices

Pricing information for Starbucks menu items in Singapore

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

193 rows where effective_date = "2024-06-28" and store_id = 140

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 140 · 193 ✖

effective_date 1

  • 2024-06-28 · 193 ✖
id ▼ item_id store_id base_price delivery_price effective_date
3691 Bagel 3691 140 140 400 430 2024-06-28
3692 Cookie Crumble Cheesecake 3692 140 140 720 770 2024-06-28
3693 Good Ol' NY Cheesecake 3693 140 140 720 770 2024-06-28
3694 Signature Chocolate Cake 3694 140 140 720 770 2024-06-28
3695 Starbucks® Coffee Tiramisu Cake 3695 140 140 750 800 2024-06-28
3696 Strawberry Shortcake 3696 140 140 720 770 2024-06-28
3697 Chocolate Chunk Monster Cookie 3697 140 140 390 440 2024-06-28
3698 Banana Walnut Muffin 3698 140 140 450 500 2024-06-28
3699 Blueberry Crumble Muffin 3699 140 140 450 500 2024-06-28
3700 Chocolate Crumble Muffin 3700 140 140 450 500 2024-06-28
3701 Pancakes 3701 140 140 550 600 2024-06-28
3702 Almond Croissant 3702 140 140 470 520 2024-06-28
3703 Buttery Croissant 3703 140 140 400 430 2024-06-28
3704 Chocolate Croissant 3704 140 140 440 490 2024-06-28
3705 Creamy Chicken Foldover 3705 140 140 550 600 2024-06-28
3706 Sausage Roll 3706 140 140 550 600 2024-06-28
3707 Buttery Scone 3707 140 140 400 430 2024-06-28
3708 Country Chicken Pie 3708 140 140 690 740 2024-06-28
3709 Deep Dish Beef Pie 3709 140 140 690 740 2024-06-28
3710 Spinach & Mushroom Quiche 3710 140 140 690 740 2024-06-28
3711 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 3711 140 140 390 420 2024-06-28
3712 Mixed Nuts 3712 140 140 490 540 2024-06-28
3713 Caramel Waffles 3713 140 140 390 420 2024-06-28
3714 Chicken Ham & Cheese Panwich 3714 140 140 690 740 2024-06-28
3715 Egg Mayo & Cheese Multigrain Croissant 3715 140 140 690 740 2024-06-28
3716 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 3716 140 140 690 740 2024-06-28
3717 Rosemary Chicken & Emmental Cheese Croissant 3717 140 140 690 740 2024-06-28
3718 Scrambled Egg & Turkey Ham Pita 3718 140 140 690 740 2024-06-28
3719 Turkey Ham & Triple Cheese Toast 3719 140 140 690 740 2024-06-28
3720 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 3720 140 140 790 840 2024-06-28
3721 Ham & Cheese Croissant 3721 140 140 690 740 2024-06-28
3722 Sriracha Chicken Whole Wheat Pita 3722 140 140 750 800 2024-06-28
3723 Blueberry Acai Yogurt Parfait 3723 140 140 650 700 2024-06-28
3724 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 3724 140 140 650 700 2024-06-28
3725 Buttery Croissant 3725 140 140 400 450 2024-06-28
3726 Chocolate Croissant 3726 140 140 440 490 2024-06-28
3727 Raisin Danish 3727 140 140 470 520 2024-06-28
3728 Apple Tart 3728 140 140 620 670 2024-06-28
3729 Lemon Meringue Tart 3729 140 140 620 670 2024-06-28
3730 Caramel Frappuccino® 3730 140 140 720 770 2024-06-28
3731 Dark Mocha Frappuccino® 3731 140 140 780 830 2024-06-28
3732 Java Chip Frappuccino® 3732 140 140 780 830 2024-06-28
3733 Mocha Frappuccino® 3733 140 140 720 770 2024-06-28
3734 Caramel Macchiato Frappuccino® 3734 140 140 780 830 2024-06-28
3735 Espresso Frappuccino® 3735 140 140 720 770 2024-06-28
3736 White Chocolate Mocha Frappuccino® 3736 140 140 720 770 2024-06-28
3737 Chocolate Chip Cream Frappuccino® 3737 140 140 780 830 2024-06-28
3738 Hojicha Tea Cream Frappuccino® 3738 140 140 760 810 2024-06-28
3739 Vanilla Cream Frappuccino® 3739 140 140 720 770 2024-06-28
3740 Mango Passion Fruit & Hibiscus 3740 140 140 720 770 2024-06-28
3741 Raspberry Black Currant & Oolong 3741 140 140 720 770 2024-06-28
3742 Coffee Traveller 3742 140 140 3120 3170 2024-06-28
3743 Caffè Americano 3743 140 140 540 590 2024-06-28
3744 Cappuccino 3744 140 140 680 730 2024-06-28
3745 Caffè Mocha 3745 140 140 750 800 2024-06-28
3746 Caramel Macchiato 3746 140 140 760 810 2024-06-28
3747 Espresso 3747 140 140 390 440 2024-06-28
3748 Caffè Latte 3748 140 140 680 730 2024-06-28
3749 Oatmilk Latte 3749 140 140 760 810 2024-06-28
3750 Vanilla Latte 3750 140 140 750 800 2024-06-28
3751 White Chocolate Mocha 3751 140 140 750 800 2024-06-28
3752 Flat White 3752 140 140 760 810 2024-06-28
3753 Ristretto Bianco 3753 140 140 760 810 2024-06-28
3754 Iced Caffè Americano 3754 140 140 540 590 2024-06-28
3755 Iced Cappuccino 3755 140 140 680 730 2024-06-28
3756 Iced Caffè Mocha 3756 140 140 750 800 2024-06-28
3757 Iced Caramel Macchiato 3757 140 140 760 810 2024-06-28
3758 Iced Caffè Latte 3758 140 140 680 730 2024-06-28
3759 Iced Oatmilk Latte 3759 140 140 760 810 2024-06-28
3760 Iced Vanilla Latte 3760 140 140 750 800 2024-06-28
3761 Iced White Chocolate Mocha 3761 140 140 750 800 2024-06-28
3762 Signature Hot Chocolate 3762 140 140 720 770 2024-06-28
3763 Signature Iced Chocolate 3763 140 140 720 770 2024-06-28
3764 Carrot Juice 3764 140 140 490 540 2024-06-28
3765 Cloudy Apple Juice 3765 140 140 490 540 2024-06-28
3766 Cranberry Red Grapefruit Juice 3766 140 140 490 540 2024-06-28
3767 Orange Juice 3767 140 140 490 540 2024-06-28
3768 Evian 3768 140 140 350 400 2024-06-28
3769 Sparkling Water 3769 140 140 450 500 2024-06-28
3770 Chai Tea 3770 140 140 500 550 2024-06-28
3771 Earl Grey Tea 3771 140 140 500 550 2024-06-28
3772 English Breakfast Tea 3772 140 140 500 550 2024-06-28
3773 Emperor’s Clouds & Mist™ Tea 3773 140 140 500 550 2024-06-28
3774 Mint Blend Tea 3774 140 140 500 550 2024-06-28
3775 Chamomile Tea 3775 140 140 500 550 2024-06-28
3776 Pure Matcha Latte 3776 140 140 740 790 2024-06-28
3777 Chai Tea Latte 3777 140 140 680 730 2024-06-28
3778 Earl Grey Tea Latte 3778 140 140 680 730 2024-06-28
3779 English Breakfast Tea Latte 3779 140 140 680 730 2024-06-28
3780 Hojicha Tea Latte 3780 140 140 740 790 2024-06-28
3781 Zen Clouds Oolong Tea 3781 140 140 500 550 2024-06-28
3782 Zen Clouds Oolong with Ruby Grapefruit and Honey 3782 140 140 630 680 2024-06-28
3783 Youthberry™ Tea 3783 140 140 500 550 2024-06-28
3784 Iced Shaken Black Tea Lemonade 3784 140 140 610 660 2024-06-28
3785 Iced Shaken Strawberry Black Tea Lemonade 3785 140 140 630 680 2024-06-28
3786 Iced Shaken Hibiscus Tea Lemonade 3786 140 140 610 660 2024-06-28
3787 Iced Shaken Hibiscus Tea with Pomegranate Pearls 3787 140 140 730 780 2024-06-28
3788 Iced Pure Matcha Latte 3788 140 140 740 790 2024-06-28
3789 Iced Chai Tea Latte 3789 140 140 680 730 2024-06-28
3790 Iced Black Tea Latte 3790 140 140 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");