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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 103 · 249 ✖
id ▼ item_id store_id base_price delivery_price effective_date
1481 Bagel 1481 103 103 400 430 2024-06-28
1482 Cookie Crumble Cheesecake 1482 103 103 720 770 2024-06-28
1483 Good Ol' NY Cheesecake 1483 103 103 720 770 2024-06-28
1484 Signature Chocolate Cake 1484 103 103 720 770 2024-06-28
1485 Starbucks® Coffee Tiramisu Cake 1485 103 103 750 800 2024-06-28
1486 Strawberry Shortcake 1486 103 103 720 770 2024-06-28
1487 Chocolate Chunk Monster Cookie 1487 103 103 390 440 2024-06-28
1488 Banana Walnut Muffin 1488 103 103 450 500 2024-06-28
1489 Blueberry Crumble Muffin 1489 103 103 450 500 2024-06-28
1490 Chocolate Crumble Muffin 1490 103 103 450 500 2024-06-28
1491 Pancakes 1491 103 103 550 600 2024-06-28
1492 Almond Croissant 1492 103 103 470 520 2024-06-28
1493 Buttery Croissant 1493 103 103 400 430 2024-06-28
1494 Chocolate Croissant 1494 103 103 440 490 2024-06-28
1495 Creamy Chicken Foldover 1495 103 103 550 600 2024-06-28
1496 Sausage Roll 1496 103 103 550 600 2024-06-28
1497 Buttery Scone 1497 103 103 400 430 2024-06-28
1498 Country Chicken Pie 1498 103 103 690 740 2024-06-28
1499 Deep Dish Beef Pie 1499 103 103 690 740 2024-06-28
1500 Spinach & Mushroom Quiche 1500 103 103 690 740 2024-06-28
1501 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 1501 103 103 390 420 2024-06-28
1502 Mixed Nuts 1502 103 103 490 540 2024-06-28
1503 Caramel Waffles 1503 103 103 390 420 2024-06-28
1504 Chicken Ham & Cheese Panwich 1504 103 103 690 740 2024-06-28
1505 Egg Mayo & Cheese Multigrain Croissant 1505 103 103 690 740 2024-06-28
1506 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 1506 103 103 690 740 2024-06-28
1507 Rosemary Chicken & Emmental Cheese Croissant 1507 103 103 690 740 2024-06-28
1508 Scrambled Egg & Turkey Ham Pita 1508 103 103 690 740 2024-06-28
1509 Turkey Ham & Triple Cheese Toast 1509 103 103 690 740 2024-06-28
1510 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 1510 103 103 790 840 2024-06-28
1511 Ham & Cheese Croissant 1511 103 103 690 740 2024-06-28
1512 Sriracha Chicken Whole Wheat Pita 1512 103 103 750 800 2024-06-28
1513 Blueberry Acai Yogurt Parfait 1513 103 103 650 700 2024-06-28
1514 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 1514 103 103 650 700 2024-06-28
1515 Caramel Frappuccino® 1515 103 103 720 770 2024-06-28
1516 Dark Mocha Frappuccino® 1516 103 103 780 830 2024-06-28
1517 Java Chip Frappuccino® 1517 103 103 780 830 2024-06-28
1518 Mocha Frappuccino® 1518 103 103 720 770 2024-06-28
1519 Caramel Macchiato Frappuccino® 1519 103 103 780 830 2024-06-28
1520 Espresso Frappuccino® 1520 103 103 720 770 2024-06-28
1521 White Chocolate Mocha Frappuccino® 1521 103 103 720 770 2024-06-28
1522 Chocolate Chip Cream Frappuccino® 1522 103 103 780 830 2024-06-28
1523 Hojicha Tea Cream Frappuccino® 1523 103 103 760 810 2024-06-28
1524 Vanilla Cream Frappuccino® 1524 103 103 720 770 2024-06-28
1525 Mango Passion Fruit & Hibiscus 1525 103 103 720 770 2024-06-28
1526 Raspberry Black Currant & Oolong 1526 103 103 720 770 2024-06-28
1527 Coffee Traveller 1527 103 103 3120 3170 2024-06-28
1528 Caffè Americano 1528 103 103 540 590 2024-06-28
1529 Cappuccino 1529 103 103 680 730 2024-06-28
1530 Caffè Mocha 1530 103 103 750 800 2024-06-28
1531 Caramel Macchiato 1531 103 103 760 810 2024-06-28
1532 Espresso 1532 103 103 390 440 2024-06-28
1533 Caffè Latte 1533 103 103 680 730 2024-06-28
1534 Oatmilk Latte 1534 103 103 760 810 2024-06-28
1535 Vanilla Latte 1535 103 103 750 800 2024-06-28
1536 White Chocolate Mocha 1536 103 103 750 800 2024-06-28
1537 Flat White 1537 103 103 760 810 2024-06-28
1538 Ristretto Bianco 1538 103 103 760 810 2024-06-28
1539 Iced Caffè Americano 1539 103 103 540 590 2024-06-28
1540 Iced Cappuccino 1540 103 103 680 730 2024-06-28
1541 Iced Caffè Mocha 1541 103 103 750 800 2024-06-28
1542 Iced Caramel Macchiato 1542 103 103 760 810 2024-06-28
1543 Iced Caffè Latte 1543 103 103 680 730 2024-06-28
1544 Iced Oatmilk Latte 1544 103 103 760 810 2024-06-28
1545 Iced Vanilla Latte 1545 103 103 750 800 2024-06-28
1546 Iced White Chocolate Mocha 1546 103 103 750 800 2024-06-28
1547 Signature Hot Chocolate 1547 103 103 720 770 2024-06-28
1548 Signature Iced Chocolate 1548 103 103 720 770 2024-06-28
1549 Carrot Juice 1549 103 103 490 540 2024-06-28
1550 Cloudy Apple Juice 1550 103 103 490 540 2024-06-28
1551 Cranberry Red Grapefruit Juice 1551 103 103 490 540 2024-06-28
1552 Orange Juice 1552 103 103 490 540 2024-06-28
1553 Evian 1553 103 103 350 400 2024-06-28
1554 Sparkling Water 1554 103 103 450 500 2024-06-28
1555 Chai Tea 1555 103 103 500 550 2024-06-28
1556 Earl Grey Tea 1556 103 103 500 550 2024-06-28
1557 English Breakfast Tea 1557 103 103 500 550 2024-06-28
1558 Emperor’s Clouds & Mist™ Tea 1558 103 103 500 550 2024-06-28
1559 Mint Blend Tea 1559 103 103 500 550 2024-06-28
1560 Chamomile Tea 1560 103 103 500 550 2024-06-28
1561 Pure Matcha Latte 1561 103 103 740 790 2024-06-28
1562 Chai Tea Latte 1562 103 103 680 730 2024-06-28
1563 Earl Grey Tea Latte 1563 103 103 680 730 2024-06-28
1564 English Breakfast Tea Latte 1564 103 103 680 730 2024-06-28
1565 Hojicha Tea Latte 1565 103 103 740 790 2024-06-28
1566 Zen Clouds Oolong Tea 1566 103 103 500 550 2024-06-28
1567 Zen Clouds Oolong with Ruby Grapefruit and Honey 1567 103 103 630 680 2024-06-28
1568 Youthberry™ Tea 1568 103 103 500 550 2024-06-28
1569 Iced Shaken Black Tea Lemonade 1569 103 103 610 660 2024-06-28
1570 Iced Shaken Strawberry Black Tea Lemonade 1570 103 103 630 680 2024-06-28
1571 Iced Shaken Hibiscus Tea Lemonade 1571 103 103 610 660 2024-06-28
1572 Iced Shaken Hibiscus Tea with Pomegranate Pearls 1572 103 103 730 780 2024-06-28
1573 Iced Pure Matcha Latte 1573 103 103 740 790 2024-06-28
1574 Iced Chai Tea Latte 1574 103 103 680 730 2024-06-28
1575 Iced Black Tea Latte 1575 103 103 680 730 2024-06-28
1576 Iced Hojicha Tea Latte 1576 103 103 740 790 2024-06-28
1577 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 1577 103 103 630 680 2024-06-28
1578 Iced Shaken Zen Clouds Oolong Lemonade 1578 103 103 610 660 2024-06-28
1579 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 1579 103 103 630 680 2024-06-28
1580 Origami Pike Place® Roast 1580 103 103 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");