item_prices

Pricing information for Starbucks menu items in Singapore

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

249 rows where store_id = 14

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 14 · 249 ✖
id ▼ item_id store_id base_price delivery_price effective_date
24542 Bagel 24542 14 14 400 430 2024-06-28
24543 Cookie Crumble Cheesecake 24543 14 14 720 770 2024-06-28
24544 Good Ol' NY Cheesecake 24544 14 14 720 770 2024-06-28
24545 Signature Chocolate Cake 24545 14 14 720 770 2024-06-28
24546 Starbucks® Coffee Tiramisu Cake 24546 14 14 750 800 2024-06-28
24547 Strawberry Shortcake 24547 14 14 720 770 2024-06-28
24548 Chocolate Chunk Monster Cookie 24548 14 14 390 440 2024-06-28
24549 Banana Walnut Muffin 24549 14 14 450 500 2024-06-28
24550 Blueberry Crumble Muffin 24550 14 14 450 500 2024-06-28
24551 Chocolate Crumble Muffin 24551 14 14 450 500 2024-06-28
24552 Pancakes 24552 14 14 550 600 2024-06-28
24553 Almond Croissant 24553 14 14 470 520 2024-06-28
24554 Buttery Croissant 24554 14 14 400 430 2024-06-28
24555 Chocolate Croissant 24555 14 14 440 490 2024-06-28
24556 Creamy Chicken Foldover 24556 14 14 550 600 2024-06-28
24557 Sausage Roll 24557 14 14 550 600 2024-06-28
24558 Buttery Scone 24558 14 14 400 430 2024-06-28
24559 Country Chicken Pie 24559 14 14 690 740 2024-06-28
24560 Deep Dish Beef Pie 24560 14 14 690 740 2024-06-28
24561 Spinach & Mushroom Quiche 24561 14 14 690 740 2024-06-28
24562 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 24562 14 14 390 420 2024-06-28
24563 Mixed Nuts 24563 14 14 490 540 2024-06-28
24564 Caramel Waffles 24564 14 14 390 420 2024-06-28
24565 Chicken Ham & Cheese Panwich 24565 14 14 690 740 2024-06-28
24566 Egg Mayo & Cheese Multigrain Croissant 24566 14 14 690 740 2024-06-28
24567 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 24567 14 14 690 740 2024-06-28
24568 Rosemary Chicken & Emmental Cheese Croissant 24568 14 14 690 740 2024-06-28
24569 Scrambled Egg & Turkey Ham Pita 24569 14 14 690 740 2024-06-28
24570 Turkey Ham & Triple Cheese Toast 24570 14 14 690 740 2024-06-28
24571 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 24571 14 14 790 840 2024-06-28
24572 Ham & Cheese Croissant 24572 14 14 690 740 2024-06-28
24573 Sriracha Chicken Whole Wheat Pita 24573 14 14 750 800 2024-06-28
24574 Blueberry Acai Yogurt Parfait 24574 14 14 650 700 2024-06-28
24575 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 24575 14 14 650 700 2024-06-28
24576 Caramel Frappuccino® 24576 14 14 720 770 2024-06-28
24577 Dark Mocha Frappuccino® 24577 14 14 780 830 2024-06-28
24578 Java Chip Frappuccino® 24578 14 14 780 830 2024-06-28
24579 Mocha Frappuccino® 24579 14 14 720 770 2024-06-28
24580 Caramel Macchiato Frappuccino® 24580 14 14 780 830 2024-06-28
24581 Espresso Frappuccino® 24581 14 14 720 770 2024-06-28
24582 White Chocolate Mocha Frappuccino® 24582 14 14 720 770 2024-06-28
24583 Chocolate Chip Cream Frappuccino® 24583 14 14 780 830 2024-06-28
24584 Hojicha Tea Cream Frappuccino® 24584 14 14 760 810 2024-06-28
24585 Vanilla Cream Frappuccino® 24585 14 14 720 770 2024-06-28
24586 Mango Passion Fruit & Hibiscus 24586 14 14 720 770 2024-06-28
24587 Raspberry Black Currant & Oolong 24587 14 14 720 770 2024-06-28
24588 Coffee Traveller 24588 14 14 3120 3170 2024-06-28
24589 Caffè Americano 24589 14 14 540 590 2024-06-28
24590 Cappuccino 24590 14 14 680 730 2024-06-28
24591 Caffè Mocha 24591 14 14 750 800 2024-06-28
24592 Caramel Macchiato 24592 14 14 760 810 2024-06-28
24593 Espresso 24593 14 14 390 440 2024-06-28
24594 Caffè Latte 24594 14 14 680 730 2024-06-28
24595 Oatmilk Latte 24595 14 14 760 810 2024-06-28
24596 Vanilla Latte 24596 14 14 750 800 2024-06-28
24597 White Chocolate Mocha 24597 14 14 750 800 2024-06-28
24598 Flat White 24598 14 14 760 810 2024-06-28
24599 Ristretto Bianco 24599 14 14 760 810 2024-06-28
24600 Iced Caffè Americano 24600 14 14 540 590 2024-06-28
24601 Iced Cappuccino 24601 14 14 680 730 2024-06-28
24602 Iced Caffè Mocha 24602 14 14 750 800 2024-06-28
24603 Iced Caramel Macchiato 24603 14 14 760 810 2024-06-28
24604 Iced Caffè Latte 24604 14 14 680 730 2024-06-28
24605 Iced Oatmilk Latte 24605 14 14 760 810 2024-06-28
24606 Iced Vanilla Latte 24606 14 14 750 800 2024-06-28
24607 Iced White Chocolate Mocha 24607 14 14 750 800 2024-06-28
24608 Signature Hot Chocolate 24608 14 14 720 770 2024-06-28
24609 Signature Iced Chocolate 24609 14 14 720 770 2024-06-28
24610 Carrot Juice 24610 14 14 490 540 2024-06-28
24611 Cloudy Apple Juice 24611 14 14 490 540 2024-06-28
24612 Cranberry Red Grapefruit Juice 24612 14 14 490 540 2024-06-28
24613 Orange Juice 24613 14 14 490 540 2024-06-28
24614 Evian 24614 14 14 350 400 2024-06-28
24615 Sparkling Water 24615 14 14 450 500 2024-06-28
24616 Chai Tea 24616 14 14 500 550 2024-06-28
24617 Earl Grey Tea 24617 14 14 500 550 2024-06-28
24618 English Breakfast Tea 24618 14 14 500 550 2024-06-28
24619 Emperor’s Clouds & Mist™ Tea 24619 14 14 500 550 2024-06-28
24620 Mint Blend Tea 24620 14 14 500 550 2024-06-28
24621 Chamomile Tea 24621 14 14 500 550 2024-06-28
24622 Pure Matcha Latte 24622 14 14 740 790 2024-06-28
24623 Chai Tea Latte 24623 14 14 680 730 2024-06-28
24624 Earl Grey Tea Latte 24624 14 14 680 730 2024-06-28
24625 English Breakfast Tea Latte 24625 14 14 680 730 2024-06-28
24626 Hojicha Tea Latte 24626 14 14 740 790 2024-06-28
24627 Zen Clouds Oolong Tea 24627 14 14 500 550 2024-06-28
24628 Zen Clouds Oolong with Ruby Grapefruit and Honey 24628 14 14 630 680 2024-06-28
24629 Youthberry™ Tea 24629 14 14 500 550 2024-06-28
24630 Iced Shaken Black Tea Lemonade 24630 14 14 610 660 2024-06-28
24631 Iced Shaken Strawberry Black Tea Lemonade 24631 14 14 630 680 2024-06-28
24632 Iced Shaken Hibiscus Tea Lemonade 24632 14 14 610 660 2024-06-28
24633 Iced Shaken Hibiscus Tea with Pomegranate Pearls 24633 14 14 730 780 2024-06-28
24634 Iced Pure Matcha Latte 24634 14 14 740 790 2024-06-28
24635 Iced Chai Tea Latte 24635 14 14 680 730 2024-06-28
24636 Iced Black Tea Latte 24636 14 14 680 730 2024-06-28
24637 Iced Hojicha Tea Latte 24637 14 14 740 790 2024-06-28
24638 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 24638 14 14 630 680 2024-06-28
24639 Iced Shaken Zen Clouds Oolong Lemonade 24639 14 14 610 660 2024-06-28
24640 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 24640 14 14 630 680 2024-06-28
24641 Origami Pike Place® Roast 24641 14 14 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");