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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 105 · 182 ✖

effective_date 1

  • 2024-06-28 · 182 ✖
id ▼ item_id store_id base_price delivery_price effective_date
9532 Bagel 9532 105 105 400 430 2024-06-28
9533 Cookie Crumble Cheesecake 9533 105 105 720 770 2024-06-28
9534 Good Ol' NY Cheesecake 9534 105 105 720 770 2024-06-28
9535 Signature Chocolate Cake 9535 105 105 720 770 2024-06-28
9536 Starbucks® Coffee Tiramisu Cake 9536 105 105 750 800 2024-06-28
9537 Strawberry Shortcake 9537 105 105 720 770 2024-06-28
9538 Chocolate Chunk Monster Cookie 9538 105 105 390 440 2024-06-28
9539 Banana Walnut Muffin 9539 105 105 450 500 2024-06-28
9540 Blueberry Crumble Muffin 9540 105 105 450 500 2024-06-28
9541 Chocolate Crumble Muffin 9541 105 105 450 500 2024-06-28
9542 Pancakes 9542 105 105 550 600 2024-06-28
9543 Almond Croissant 9543 105 105 470 520 2024-06-28
9544 Buttery Croissant 9544 105 105 400 430 2024-06-28
9545 Chocolate Croissant 9545 105 105 440 490 2024-06-28
9546 Creamy Chicken Foldover 9546 105 105 550 600 2024-06-28
9547 Sausage Roll 9547 105 105 550 600 2024-06-28
9548 Buttery Scone 9548 105 105 400 430 2024-06-28
9549 Country Chicken Pie 9549 105 105 690 740 2024-06-28
9550 Deep Dish Beef Pie 9550 105 105 690 740 2024-06-28
9551 Spinach & Mushroom Quiche 9551 105 105 690 740 2024-06-28
9552 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 9552 105 105 390 420 2024-06-28
9553 Mixed Nuts 9553 105 105 490 540 2024-06-28
9554 Caramel Waffles 9554 105 105 390 420 2024-06-28
9555 Chicken Ham & Cheese Panwich 9555 105 105 690 740 2024-06-28
9556 Egg Mayo & Cheese Multigrain Croissant 9556 105 105 690 740 2024-06-28
9557 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 9557 105 105 690 740 2024-06-28
9558 Rosemary Chicken & Emmental Cheese Croissant 9558 105 105 690 740 2024-06-28
9559 Scrambled Egg & Turkey Ham Pita 9559 105 105 690 740 2024-06-28
9560 Turkey Ham & Triple Cheese Toast 9560 105 105 690 740 2024-06-28
9561 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 9561 105 105 790 840 2024-06-28
9562 Ham & Cheese Croissant 9562 105 105 690 740 2024-06-28
9563 Sriracha Chicken Whole Wheat Pita 9563 105 105 750 800 2024-06-28
9564 Blueberry Acai Yogurt Parfait 9564 105 105 650 700 2024-06-28
9565 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 9565 105 105 650 700 2024-06-28
9566 Caramel Frappuccino® 9566 105 105 720 770 2024-06-28
9567 Dark Mocha Frappuccino® 9567 105 105 780 830 2024-06-28
9568 Java Chip Frappuccino® 9568 105 105 780 830 2024-06-28
9569 Mocha Frappuccino® 9569 105 105 720 770 2024-06-28
9570 Caramel Macchiato Frappuccino® 9570 105 105 780 830 2024-06-28
9571 Espresso Frappuccino® 9571 105 105 720 770 2024-06-28
9572 White Chocolate Mocha Frappuccino® 9572 105 105 720 770 2024-06-28
9573 Chocolate Chip Cream Frappuccino® 9573 105 105 780 830 2024-06-28
9574 Hojicha Tea Cream Frappuccino® 9574 105 105 760 810 2024-06-28
9575 Vanilla Cream Frappuccino® 9575 105 105 720 770 2024-06-28
9576 Mango Passion Fruit & Hibiscus 9576 105 105 720 770 2024-06-28
9577 Raspberry Black Currant & Oolong 9577 105 105 720 770 2024-06-28
9578 Coffee Traveller 9578 105 105 3120 3170 2024-06-28
9579 Caffè Americano 9579 105 105 540 590 2024-06-28
9580 Cappuccino 9580 105 105 680 730 2024-06-28
9581 Caffè Mocha 9581 105 105 750 800 2024-06-28
9582 Caramel Macchiato 9582 105 105 760 810 2024-06-28
9583 Espresso 9583 105 105 390 440 2024-06-28
9584 Caffè Latte 9584 105 105 680 730 2024-06-28
9585 Oatmilk Latte 9585 105 105 760 810 2024-06-28
9586 Vanilla Latte 9586 105 105 750 800 2024-06-28
9587 White Chocolate Mocha 9587 105 105 750 800 2024-06-28
9588 Flat White 9588 105 105 760 810 2024-06-28
9589 Ristretto Bianco 9589 105 105 760 810 2024-06-28
9590 Iced Caffè Americano 9590 105 105 540 590 2024-06-28
9591 Iced Cappuccino 9591 105 105 680 730 2024-06-28
9592 Iced Caffè Mocha 9592 105 105 750 800 2024-06-28
9593 Iced Caramel Macchiato 9593 105 105 760 810 2024-06-28
9594 Iced Caffè Latte 9594 105 105 680 730 2024-06-28
9595 Iced Oatmilk Latte 9595 105 105 760 810 2024-06-28
9596 Iced Vanilla Latte 9596 105 105 750 800 2024-06-28
9597 Iced White Chocolate Mocha 9597 105 105 750 800 2024-06-28
9598 Signature Hot Chocolate 9598 105 105 720 770 2024-06-28
9599 Signature Iced Chocolate 9599 105 105 720 770 2024-06-28
9600 Carrot Juice 9600 105 105 490 540 2024-06-28
9601 Cloudy Apple Juice 9601 105 105 490 540 2024-06-28
9602 Cranberry Red Grapefruit Juice 9602 105 105 490 540 2024-06-28
9603 Orange Juice 9603 105 105 490 540 2024-06-28
9604 Evian 9604 105 105 350 400 2024-06-28
9605 Sparkling Water 9605 105 105 450 500 2024-06-28
9606 Chai Tea 9606 105 105 500 550 2024-06-28
9607 Earl Grey Tea 9607 105 105 500 550 2024-06-28
9608 English Breakfast Tea 9608 105 105 500 550 2024-06-28
9609 Emperor’s Clouds & Mist™ Tea 9609 105 105 500 550 2024-06-28
9610 Mint Blend Tea 9610 105 105 500 550 2024-06-28
9611 Chamomile Tea 9611 105 105 500 550 2024-06-28
9612 Pure Matcha Latte 9612 105 105 740 790 2024-06-28
9613 Chai Tea Latte 9613 105 105 680 730 2024-06-28
9614 Earl Grey Tea Latte 9614 105 105 680 730 2024-06-28
9615 English Breakfast Tea Latte 9615 105 105 680 730 2024-06-28
9616 Hojicha Tea Latte 9616 105 105 740 790 2024-06-28
9617 Zen Clouds Oolong Tea 9617 105 105 500 550 2024-06-28
9618 Zen Clouds Oolong with Ruby Grapefruit and Honey 9618 105 105 630 680 2024-06-28
9619 Youthberry™ Tea 9619 105 105 500 550 2024-06-28
9620 Iced Shaken Black Tea Lemonade 9620 105 105 610 660 2024-06-28
9621 Iced Shaken Strawberry Black Tea Lemonade 9621 105 105 630 680 2024-06-28
9622 Iced Shaken Hibiscus Tea Lemonade 9622 105 105 610 660 2024-06-28
9623 Iced Shaken Hibiscus Tea with Pomegranate Pearls 9623 105 105 730 780 2024-06-28
9624 Iced Pure Matcha Latte 9624 105 105 740 790 2024-06-28
9625 Iced Chai Tea Latte 9625 105 105 680 730 2024-06-28
9626 Iced Black Tea Latte 9626 105 105 680 730 2024-06-28
9627 Iced Hojicha Tea Latte 9627 105 105 740 790 2024-06-28
9628 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 9628 105 105 630 680 2024-06-28
9629 Iced Shaken Zen Clouds Oolong Lemonade 9629 105 105 610 660 2024-06-28
9630 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 9630 105 105 630 680 2024-06-28
9631 Origami Pike Place® Roast 9631 105 105 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");