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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 72 · 182 ✖

effective_date 1

  • 2024-06-28 · 182 ✖
id ▼ item_id store_id base_price delivery_price effective_date
14664 Bagel 14664 72 72 400 430 2024-06-28
14665 Cookie Crumble Cheesecake 14665 72 72 720 770 2024-06-28
14666 Good Ol' NY Cheesecake 14666 72 72 720 770 2024-06-28
14667 Signature Chocolate Cake 14667 72 72 720 770 2024-06-28
14668 Starbucks® Coffee Tiramisu Cake 14668 72 72 750 800 2024-06-28
14669 Strawberry Shortcake 14669 72 72 720 770 2024-06-28
14670 Chocolate Chunk Monster Cookie 14670 72 72 390 440 2024-06-28
14671 Banana Walnut Muffin 14671 72 72 450 500 2024-06-28
14672 Blueberry Crumble Muffin 14672 72 72 450 500 2024-06-28
14673 Chocolate Crumble Muffin 14673 72 72 450 500 2024-06-28
14674 Pancakes 14674 72 72 550 600 2024-06-28
14675 Almond Croissant 14675 72 72 470 520 2024-06-28
14676 Buttery Croissant 14676 72 72 400 430 2024-06-28
14677 Chocolate Croissant 14677 72 72 440 490 2024-06-28
14678 Creamy Chicken Foldover 14678 72 72 550 600 2024-06-28
14679 Sausage Roll 14679 72 72 550 600 2024-06-28
14680 Buttery Scone 14680 72 72 400 430 2024-06-28
14681 Country Chicken Pie 14681 72 72 690 740 2024-06-28
14682 Deep Dish Beef Pie 14682 72 72 690 740 2024-06-28
14683 Spinach & Mushroom Quiche 14683 72 72 690 740 2024-06-28
14684 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 14684 72 72 390 420 2024-06-28
14685 Mixed Nuts 14685 72 72 490 540 2024-06-28
14686 Caramel Waffles 14686 72 72 390 420 2024-06-28
14687 Chicken Ham & Cheese Panwich 14687 72 72 690 740 2024-06-28
14688 Egg Mayo & Cheese Multigrain Croissant 14688 72 72 690 740 2024-06-28
14689 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 14689 72 72 690 740 2024-06-28
14690 Rosemary Chicken & Emmental Cheese Croissant 14690 72 72 690 740 2024-06-28
14691 Scrambled Egg & Turkey Ham Pita 14691 72 72 690 740 2024-06-28
14692 Turkey Ham & Triple Cheese Toast 14692 72 72 690 740 2024-06-28
14693 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 14693 72 72 790 840 2024-06-28
14694 Ham & Cheese Croissant 14694 72 72 690 740 2024-06-28
14695 Sriracha Chicken Whole Wheat Pita 14695 72 72 750 800 2024-06-28
14696 Blueberry Acai Yogurt Parfait 14696 72 72 650 700 2024-06-28
14697 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 14697 72 72 650 700 2024-06-28
14698 Caramel Frappuccino® 14698 72 72 720 770 2024-06-28
14699 Dark Mocha Frappuccino® 14699 72 72 780 830 2024-06-28
14700 Java Chip Frappuccino® 14700 72 72 780 830 2024-06-28
14701 Mocha Frappuccino® 14701 72 72 720 770 2024-06-28
14702 Caramel Macchiato Frappuccino® 14702 72 72 780 830 2024-06-28
14703 Espresso Frappuccino® 14703 72 72 720 770 2024-06-28
14704 White Chocolate Mocha Frappuccino® 14704 72 72 720 770 2024-06-28
14705 Chocolate Chip Cream Frappuccino® 14705 72 72 780 830 2024-06-28
14706 Hojicha Tea Cream Frappuccino® 14706 72 72 760 810 2024-06-28
14707 Vanilla Cream Frappuccino® 14707 72 72 720 770 2024-06-28
14708 Mango Passion Fruit & Hibiscus 14708 72 72 720 770 2024-06-28
14709 Raspberry Black Currant & Oolong 14709 72 72 720 770 2024-06-28
14710 Coffee Traveller 14710 72 72 3120 3170 2024-06-28
14711 Caffè Americano 14711 72 72 540 590 2024-06-28
14712 Cappuccino 14712 72 72 680 730 2024-06-28
14713 Caffè Mocha 14713 72 72 750 800 2024-06-28
14714 Caramel Macchiato 14714 72 72 760 810 2024-06-28
14715 Espresso 14715 72 72 390 440 2024-06-28
14716 Caffè Latte 14716 72 72 680 730 2024-06-28
14717 Oatmilk Latte 14717 72 72 760 810 2024-06-28
14718 Vanilla Latte 14718 72 72 750 800 2024-06-28
14719 White Chocolate Mocha 14719 72 72 750 800 2024-06-28
14720 Flat White 14720 72 72 760 810 2024-06-28
14721 Ristretto Bianco 14721 72 72 760 810 2024-06-28
14722 Iced Caffè Americano 14722 72 72 540 590 2024-06-28
14723 Iced Cappuccino 14723 72 72 680 730 2024-06-28
14724 Iced Caffè Mocha 14724 72 72 750 800 2024-06-28
14725 Iced Caramel Macchiato 14725 72 72 760 810 2024-06-28
14726 Iced Caffè Latte 14726 72 72 680 730 2024-06-28
14727 Iced Oatmilk Latte 14727 72 72 760 810 2024-06-28
14728 Iced Vanilla Latte 14728 72 72 750 800 2024-06-28
14729 Iced White Chocolate Mocha 14729 72 72 750 800 2024-06-28
14730 Signature Hot Chocolate 14730 72 72 720 770 2024-06-28
14731 Signature Iced Chocolate 14731 72 72 720 770 2024-06-28
14732 Carrot Juice 14732 72 72 490 540 2024-06-28
14733 Cloudy Apple Juice 14733 72 72 490 540 2024-06-28
14734 Cranberry Red Grapefruit Juice 14734 72 72 490 540 2024-06-28
14735 Orange Juice 14735 72 72 490 540 2024-06-28
14736 Evian 14736 72 72 350 400 2024-06-28
14737 Sparkling Water 14737 72 72 450 500 2024-06-28
14738 Chai Tea 14738 72 72 500 550 2024-06-28
14739 Earl Grey Tea 14739 72 72 500 550 2024-06-28
14740 English Breakfast Tea 14740 72 72 500 550 2024-06-28
14741 Emperor’s Clouds & Mist™ Tea 14741 72 72 500 550 2024-06-28
14742 Mint Blend Tea 14742 72 72 500 550 2024-06-28
14743 Chamomile Tea 14743 72 72 500 550 2024-06-28
14744 Pure Matcha Latte 14744 72 72 740 790 2024-06-28
14745 Chai Tea Latte 14745 72 72 680 730 2024-06-28
14746 Earl Grey Tea Latte 14746 72 72 680 730 2024-06-28
14747 English Breakfast Tea Latte 14747 72 72 680 730 2024-06-28
14748 Hojicha Tea Latte 14748 72 72 740 790 2024-06-28
14749 Zen Clouds Oolong Tea 14749 72 72 500 550 2024-06-28
14750 Zen Clouds Oolong with Ruby Grapefruit and Honey 14750 72 72 630 680 2024-06-28
14751 Youthberry™ Tea 14751 72 72 500 550 2024-06-28
14752 Iced Shaken Black Tea Lemonade 14752 72 72 610 660 2024-06-28
14753 Iced Shaken Strawberry Black Tea Lemonade 14753 72 72 630 680 2024-06-28
14754 Iced Shaken Hibiscus Tea Lemonade 14754 72 72 610 660 2024-06-28
14755 Iced Shaken Hibiscus Tea with Pomegranate Pearls 14755 72 72 730 780 2024-06-28
14756 Iced Pure Matcha Latte 14756 72 72 740 790 2024-06-28
14757 Iced Chai Tea Latte 14757 72 72 680 730 2024-06-28
14758 Iced Black Tea Latte 14758 72 72 680 730 2024-06-28
14759 Iced Hojicha Tea Latte 14759 72 72 740 790 2024-06-28
14760 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 14760 72 72 630 680 2024-06-28
14761 Iced Shaken Zen Clouds Oolong Lemonade 14761 72 72 610 660 2024-06-28
14762 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 14762 72 72 630 680 2024-06-28
14763 Origami Pike Place® Roast 14763 72 72 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");