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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 55 · 234 ✖
id ▼ item_id store_id base_price delivery_price effective_date
17605 Bagel 17605 55 55 400 430 2024-06-28
17606 Cookie Crumble Cheesecake 17606 55 55 720 770 2024-06-28
17607 Good Ol' NY Cheesecake 17607 55 55 720 770 2024-06-28
17608 Signature Chocolate Cake 17608 55 55 720 770 2024-06-28
17609 Starbucks® Coffee Tiramisu Cake 17609 55 55 750 800 2024-06-28
17610 Strawberry Shortcake 17610 55 55 720 770 2024-06-28
17611 Chocolate Chunk Monster Cookie 17611 55 55 390 440 2024-06-28
17612 Banana Walnut Muffin 17612 55 55 450 500 2024-06-28
17613 Blueberry Crumble Muffin 17613 55 55 450 500 2024-06-28
17614 Chocolate Crumble Muffin 17614 55 55 450 500 2024-06-28
17615 Pancakes 17615 55 55 550 600 2024-06-28
17616 Almond Croissant 17616 55 55 470 520 2024-06-28
17617 Buttery Croissant 17617 55 55 400 430 2024-06-28
17618 Chocolate Croissant 17618 55 55 440 490 2024-06-28
17619 Creamy Chicken Foldover 17619 55 55 550 600 2024-06-28
17620 Sausage Roll 17620 55 55 550 600 2024-06-28
17621 Buttery Scone 17621 55 55 400 430 2024-06-28
17622 Country Chicken Pie 17622 55 55 690 740 2024-06-28
17623 Deep Dish Beef Pie 17623 55 55 690 740 2024-06-28
17624 Spinach & Mushroom Quiche 17624 55 55 690 740 2024-06-28
17625 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 17625 55 55 390 420 2024-06-28
17626 Mixed Nuts 17626 55 55 490 540 2024-06-28
17627 Caramel Waffles 17627 55 55 390 420 2024-06-28
17628 Chicken Ham & Cheese Panwich 17628 55 55 690 740 2024-06-28
17629 Egg Mayo & Cheese Multigrain Croissant 17629 55 55 690 740 2024-06-28
17630 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 17630 55 55 690 740 2024-06-28
17631 Rosemary Chicken & Emmental Cheese Croissant 17631 55 55 690 740 2024-06-28
17632 Scrambled Egg & Turkey Ham Pita 17632 55 55 690 740 2024-06-28
17633 Turkey Ham & Triple Cheese Toast 17633 55 55 690 740 2024-06-28
17634 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 17634 55 55 790 840 2024-06-28
17635 Ham & Cheese Croissant 17635 55 55 690 740 2024-06-28
17636 Sriracha Chicken Whole Wheat Pita 17636 55 55 750 800 2024-06-28
17637 Blueberry Acai Yogurt Parfait 17637 55 55 650 700 2024-06-28
17638 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 17638 55 55 650 700 2024-06-28
17639 Caramel Frappuccino® 17639 55 55 720 770 2024-06-28
17640 Dark Mocha Frappuccino® 17640 55 55 780 830 2024-06-28
17641 Java Chip Frappuccino® 17641 55 55 780 830 2024-06-28
17642 Mocha Frappuccino® 17642 55 55 720 770 2024-06-28
17643 Caramel Macchiato Frappuccino® 17643 55 55 780 830 2024-06-28
17644 Espresso Frappuccino® 17644 55 55 720 770 2024-06-28
17645 White Chocolate Mocha Frappuccino® 17645 55 55 720 770 2024-06-28
17646 Chocolate Chip Cream Frappuccino® 17646 55 55 780 830 2024-06-28
17647 Hojicha Tea Cream Frappuccino® 17647 55 55 760 810 2024-06-28
17648 Vanilla Cream Frappuccino® 17648 55 55 720 770 2024-06-28
17649 Mango Passion Fruit & Hibiscus 17649 55 55 720 770 2024-06-28
17650 Raspberry Black Currant & Oolong 17650 55 55 720 770 2024-06-28
17651 Coffee Traveller 17651 55 55 3120 3170 2024-06-28
17652 Caffè Americano 17652 55 55 540 590 2024-06-28
17653 Cappuccino 17653 55 55 680 730 2024-06-28
17654 Caffè Mocha 17654 55 55 750 800 2024-06-28
17655 Caramel Macchiato 17655 55 55 760 810 2024-06-28
17656 Espresso 17656 55 55 390 440 2024-06-28
17657 Caffè Latte 17657 55 55 680 730 2024-06-28
17658 Oatmilk Latte 17658 55 55 760 810 2024-06-28
17659 Vanilla Latte 17659 55 55 750 800 2024-06-28
17660 White Chocolate Mocha 17660 55 55 750 800 2024-06-28
17661 Flat White 17661 55 55 760 810 2024-06-28
17662 Ristretto Bianco 17662 55 55 760 810 2024-06-28
17663 Iced Caffè Americano 17663 55 55 540 590 2024-06-28
17664 Iced Cappuccino 17664 55 55 680 730 2024-06-28
17665 Iced Caffè Mocha 17665 55 55 750 800 2024-06-28
17666 Iced Caramel Macchiato 17666 55 55 760 810 2024-06-28
17667 Iced Caffè Latte 17667 55 55 680 730 2024-06-28
17668 Iced Oatmilk Latte 17668 55 55 760 810 2024-06-28
17669 Iced Vanilla Latte 17669 55 55 750 800 2024-06-28
17670 Iced White Chocolate Mocha 17670 55 55 750 800 2024-06-28
17671 Signature Hot Chocolate 17671 55 55 720 770 2024-06-28
17672 Signature Iced Chocolate 17672 55 55 720 770 2024-06-28
17673 Carrot Juice 17673 55 55 490 540 2024-06-28
17674 Cloudy Apple Juice 17674 55 55 490 540 2024-06-28
17675 Cranberry Red Grapefruit Juice 17675 55 55 490 540 2024-06-28
17676 Orange Juice 17676 55 55 490 540 2024-06-28
17677 Evian 17677 55 55 350 400 2024-06-28
17678 Sparkling Water 17678 55 55 450 500 2024-06-28
17679 Chai Tea 17679 55 55 500 550 2024-06-28
17680 Earl Grey Tea 17680 55 55 500 550 2024-06-28
17681 English Breakfast Tea 17681 55 55 500 550 2024-06-28
17682 Emperor’s Clouds & Mist™ Tea 17682 55 55 500 550 2024-06-28
17683 Mint Blend Tea 17683 55 55 500 550 2024-06-28
17684 Chamomile Tea 17684 55 55 500 550 2024-06-28
17685 Pure Matcha Latte 17685 55 55 740 790 2024-06-28
17686 Chai Tea Latte 17686 55 55 680 730 2024-06-28
17687 Earl Grey Tea Latte 17687 55 55 680 730 2024-06-28
17688 English Breakfast Tea Latte 17688 55 55 680 730 2024-06-28
17689 Hojicha Tea Latte 17689 55 55 740 790 2024-06-28
17690 Zen Clouds Oolong Tea 17690 55 55 500 550 2024-06-28
17691 Zen Clouds Oolong with Ruby Grapefruit and Honey 17691 55 55 630 680 2024-06-28
17692 Youthberry™ Tea 17692 55 55 500 550 2024-06-28
17693 Iced Shaken Black Tea Lemonade 17693 55 55 610 660 2024-06-28
17694 Iced Shaken Strawberry Black Tea Lemonade 17694 55 55 630 680 2024-06-28
17695 Iced Shaken Hibiscus Tea Lemonade 17695 55 55 610 660 2024-06-28
17696 Iced Shaken Hibiscus Tea with Pomegranate Pearls 17696 55 55 730 780 2024-06-28
17697 Iced Pure Matcha Latte 17697 55 55 740 790 2024-06-28
17698 Iced Chai Tea Latte 17698 55 55 680 730 2024-06-28
17699 Iced Black Tea Latte 17699 55 55 680 730 2024-06-28
17700 Iced Hojicha Tea Latte 17700 55 55 740 790 2024-06-28
17701 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 17701 55 55 630 680 2024-06-28
17702 Iced Shaken Zen Clouds Oolong Lemonade 17702 55 55 610 660 2024-06-28
17703 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 17703 55 55 630 680 2024-06-28
17704 Origami Pike Place® Roast 17704 55 55 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");