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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 116 · 249 ✖
id ▼ item_id store_id base_price delivery_price effective_date
7528 Bagel 7528 116 116 400 430 2024-06-28
7529 Cookie Crumble Cheesecake 7529 116 116 720 770 2024-06-28
7530 Good Ol' NY Cheesecake 7530 116 116 720 770 2024-06-28
7531 Signature Chocolate Cake 7531 116 116 720 770 2024-06-28
7532 Starbucks® Coffee Tiramisu Cake 7532 116 116 750 800 2024-06-28
7533 Strawberry Shortcake 7533 116 116 720 770 2024-06-28
7534 Chocolate Chunk Monster Cookie 7534 116 116 390 440 2024-06-28
7535 Banana Walnut Muffin 7535 116 116 450 500 2024-06-28
7536 Blueberry Crumble Muffin 7536 116 116 450 500 2024-06-28
7537 Chocolate Crumble Muffin 7537 116 116 450 500 2024-06-28
7538 Pancakes 7538 116 116 550 600 2024-06-28
7539 Almond Croissant 7539 116 116 470 520 2024-06-28
7540 Buttery Croissant 7540 116 116 400 430 2024-06-28
7541 Chocolate Croissant 7541 116 116 440 490 2024-06-28
7542 Creamy Chicken Foldover 7542 116 116 550 600 2024-06-28
7543 Sausage Roll 7543 116 116 550 600 2024-06-28
7544 Buttery Scone 7544 116 116 400 430 2024-06-28
7545 Country Chicken Pie 7545 116 116 690 740 2024-06-28
7546 Deep Dish Beef Pie 7546 116 116 690 740 2024-06-28
7547 Spinach & Mushroom Quiche 7547 116 116 690 740 2024-06-28
7548 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 7548 116 116 390 420 2024-06-28
7549 Mixed Nuts 7549 116 116 490 540 2024-06-28
7550 Caramel Waffles 7550 116 116 390 420 2024-06-28
7551 Chicken Ham & Cheese Panwich 7551 116 116 690 740 2024-06-28
7552 Egg Mayo & Cheese Multigrain Croissant 7552 116 116 690 740 2024-06-28
7553 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 7553 116 116 690 740 2024-06-28
7554 Rosemary Chicken & Emmental Cheese Croissant 7554 116 116 690 740 2024-06-28
7555 Scrambled Egg & Turkey Ham Pita 7555 116 116 690 740 2024-06-28
7556 Turkey Ham & Triple Cheese Toast 7556 116 116 690 740 2024-06-28
7557 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 7557 116 116 790 840 2024-06-28
7558 Ham & Cheese Croissant 7558 116 116 690 740 2024-06-28
7559 Sriracha Chicken Whole Wheat Pita 7559 116 116 750 800 2024-06-28
7560 Blueberry Acai Yogurt Parfait 7560 116 116 650 700 2024-06-28
7561 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 7561 116 116 650 700 2024-06-28
7562 Caramel Frappuccino® 7562 116 116 720 770 2024-06-28
7563 Dark Mocha Frappuccino® 7563 116 116 780 830 2024-06-28
7564 Java Chip Frappuccino® 7564 116 116 780 830 2024-06-28
7565 Mocha Frappuccino® 7565 116 116 720 770 2024-06-28
7566 Caramel Macchiato Frappuccino® 7566 116 116 780 830 2024-06-28
7567 Espresso Frappuccino® 7567 116 116 720 770 2024-06-28
7568 White Chocolate Mocha Frappuccino® 7568 116 116 720 770 2024-06-28
7569 Chocolate Chip Cream Frappuccino® 7569 116 116 780 830 2024-06-28
7570 Hojicha Tea Cream Frappuccino® 7570 116 116 760 810 2024-06-28
7571 Vanilla Cream Frappuccino® 7571 116 116 720 770 2024-06-28
7572 Mango Passion Fruit & Hibiscus 7572 116 116 720 770 2024-06-28
7573 Raspberry Black Currant & Oolong 7573 116 116 720 770 2024-06-28
7574 Coffee Traveller 7574 116 116 3120 3170 2024-06-28
7575 Caffè Americano 7575 116 116 540 590 2024-06-28
7576 Cappuccino 7576 116 116 680 730 2024-06-28
7577 Caffè Mocha 7577 116 116 750 800 2024-06-28
7578 Caramel Macchiato 7578 116 116 760 810 2024-06-28
7579 Espresso 7579 116 116 390 440 2024-06-28
7580 Caffè Latte 7580 116 116 680 730 2024-06-28
7581 Oatmilk Latte 7581 116 116 760 810 2024-06-28
7582 Vanilla Latte 7582 116 116 750 800 2024-06-28
7583 White Chocolate Mocha 7583 116 116 750 800 2024-06-28
7584 Flat White 7584 116 116 760 810 2024-06-28
7585 Ristretto Bianco 7585 116 116 760 810 2024-06-28
7586 Iced Caffè Americano 7586 116 116 540 590 2024-06-28
7587 Iced Cappuccino 7587 116 116 680 730 2024-06-28
7588 Iced Caffè Mocha 7588 116 116 750 800 2024-06-28
7589 Iced Caramel Macchiato 7589 116 116 760 810 2024-06-28
7590 Iced Caffè Latte 7590 116 116 680 730 2024-06-28
7591 Iced Oatmilk Latte 7591 116 116 760 810 2024-06-28
7592 Iced Vanilla Latte 7592 116 116 750 800 2024-06-28
7593 Iced White Chocolate Mocha 7593 116 116 750 800 2024-06-28
7594 Signature Hot Chocolate 7594 116 116 720 770 2024-06-28
7595 Signature Iced Chocolate 7595 116 116 720 770 2024-06-28
7596 Carrot Juice 7596 116 116 490 540 2024-06-28
7597 Cloudy Apple Juice 7597 116 116 490 540 2024-06-28
7598 Cranberry Red Grapefruit Juice 7598 116 116 490 540 2024-06-28
7599 Orange Juice 7599 116 116 490 540 2024-06-28
7600 Evian 7600 116 116 350 400 2024-06-28
7601 Sparkling Water 7601 116 116 450 500 2024-06-28
7602 Chai Tea 7602 116 116 500 550 2024-06-28
7603 Earl Grey Tea 7603 116 116 500 550 2024-06-28
7604 English Breakfast Tea 7604 116 116 500 550 2024-06-28
7605 Emperor’s Clouds & Mist™ Tea 7605 116 116 500 550 2024-06-28
7606 Mint Blend Tea 7606 116 116 500 550 2024-06-28
7607 Chamomile Tea 7607 116 116 500 550 2024-06-28
7608 Pure Matcha Latte 7608 116 116 740 790 2024-06-28
7609 Chai Tea Latte 7609 116 116 680 730 2024-06-28
7610 Earl Grey Tea Latte 7610 116 116 680 730 2024-06-28
7611 English Breakfast Tea Latte 7611 116 116 680 730 2024-06-28
7612 Hojicha Tea Latte 7612 116 116 740 790 2024-06-28
7613 Zen Clouds Oolong Tea 7613 116 116 500 550 2024-06-28
7614 Zen Clouds Oolong with Ruby Grapefruit and Honey 7614 116 116 630 680 2024-06-28
7615 Youthberry™ Tea 7615 116 116 500 550 2024-06-28
7616 Iced Shaken Black Tea Lemonade 7616 116 116 610 660 2024-06-28
7617 Iced Shaken Strawberry Black Tea Lemonade 7617 116 116 630 680 2024-06-28
7618 Iced Shaken Hibiscus Tea Lemonade 7618 116 116 610 660 2024-06-28
7619 Iced Shaken Hibiscus Tea with Pomegranate Pearls 7619 116 116 730 780 2024-06-28
7620 Iced Pure Matcha Latte 7620 116 116 740 790 2024-06-28
7621 Iced Chai Tea Latte 7621 116 116 680 730 2024-06-28
7622 Iced Black Tea Latte 7622 116 116 680 730 2024-06-28
7623 Iced Hojicha Tea Latte 7623 116 116 740 790 2024-06-28
7624 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 7624 116 116 630 680 2024-06-28
7625 Iced Shaken Zen Clouds Oolong Lemonade 7625 116 116 610 660 2024-06-28
7626 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 7626 116 116 630 680 2024-06-28
7627 Origami Pike Place® Roast 7627 116 116 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");