item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
248 rows where store_id = 124
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 12
- 2024-06-28 182
- 2024-11-10 14
- 2024-09-15 10
- 2024-11-03 9
- 2024-07-17 7
- 2024-07-28 5
- 2024-08-18 5
- 2024-07-03 4
- 2024-10-06 4
- 2024-10-13 4
- 2024-07-14 2
- 2024-09-29 2
store_id 1
- 124 · 248 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 1663 | Bagel 1663 | 124 124 | 400 | 430 | 2024-06-28 |
| 1664 | Cookie Crumble Cheesecake 1664 | 124 124 | 720 | 770 | 2024-06-28 |
| 1665 | Good Ol' NY Cheesecake 1665 | 124 124 | 720 | 770 | 2024-06-28 |
| 1666 | Signature Chocolate Cake 1666 | 124 124 | 720 | 770 | 2024-06-28 |
| 1667 | Starbucks® Coffee Tiramisu Cake 1667 | 124 124 | 750 | 800 | 2024-06-28 |
| 1668 | Strawberry Shortcake 1668 | 124 124 | 720 | 770 | 2024-06-28 |
| 1669 | Chocolate Chunk Monster Cookie 1669 | 124 124 | 390 | 440 | 2024-06-28 |
| 1670 | Banana Walnut Muffin 1670 | 124 124 | 450 | 500 | 2024-06-28 |
| 1671 | Blueberry Crumble Muffin 1671 | 124 124 | 450 | 500 | 2024-06-28 |
| 1672 | Chocolate Crumble Muffin 1672 | 124 124 | 450 | 500 | 2024-06-28 |
| 1673 | Pancakes 1673 | 124 124 | 550 | 600 | 2024-06-28 |
| 1674 | Almond Croissant 1674 | 124 124 | 470 | 520 | 2024-06-28 |
| 1675 | Buttery Croissant 1675 | 124 124 | 400 | 430 | 2024-06-28 |
| 1676 | Chocolate Croissant 1676 | 124 124 | 440 | 490 | 2024-06-28 |
| 1677 | Creamy Chicken Foldover 1677 | 124 124 | 550 | 600 | 2024-06-28 |
| 1678 | Sausage Roll 1678 | 124 124 | 550 | 600 | 2024-06-28 |
| 1679 | Buttery Scone 1679 | 124 124 | 400 | 430 | 2024-06-28 |
| 1680 | Country Chicken Pie 1680 | 124 124 | 690 | 740 | 2024-06-28 |
| 1681 | Deep Dish Beef Pie 1681 | 124 124 | 690 | 740 | 2024-06-28 |
| 1682 | Spinach & Mushroom Quiche 1682 | 124 124 | 690 | 740 | 2024-06-28 |
| 1683 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 1683 | 124 124 | 390 | 420 | 2024-06-28 |
| 1684 | Mixed Nuts 1684 | 124 124 | 490 | 540 | 2024-06-28 |
| 1685 | Caramel Waffles 1685 | 124 124 | 390 | 420 | 2024-06-28 |
| 1686 | Chicken Ham & Cheese Panwich 1686 | 124 124 | 690 | 740 | 2024-06-28 |
| 1687 | Egg Mayo & Cheese Multigrain Croissant 1687 | 124 124 | 690 | 740 | 2024-06-28 |
| 1688 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 1688 | 124 124 | 690 | 740 | 2024-06-28 |
| 1689 | Rosemary Chicken & Emmental Cheese Croissant 1689 | 124 124 | 690 | 740 | 2024-06-28 |
| 1690 | Scrambled Egg & Turkey Ham Pita 1690 | 124 124 | 690 | 740 | 2024-06-28 |
| 1691 | Turkey Ham & Triple Cheese Toast 1691 | 124 124 | 690 | 740 | 2024-06-28 |
| 1692 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 1692 | 124 124 | 790 | 840 | 2024-06-28 |
| 1693 | Ham & Cheese Croissant 1693 | 124 124 | 690 | 740 | 2024-06-28 |
| 1694 | Sriracha Chicken Whole Wheat Pita 1694 | 124 124 | 750 | 800 | 2024-06-28 |
| 1695 | Blueberry Acai Yogurt Parfait 1695 | 124 124 | 650 | 700 | 2024-06-28 |
| 1696 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 1696 | 124 124 | 650 | 700 | 2024-06-28 |
| 1697 | Caramel Frappuccino® 1697 | 124 124 | 720 | 770 | 2024-06-28 |
| 1698 | Dark Mocha Frappuccino® 1698 | 124 124 | 780 | 830 | 2024-06-28 |
| 1699 | Java Chip Frappuccino® 1699 | 124 124 | 780 | 830 | 2024-06-28 |
| 1700 | Mocha Frappuccino® 1700 | 124 124 | 720 | 770 | 2024-06-28 |
| 1701 | Caramel Macchiato Frappuccino® 1701 | 124 124 | 780 | 830 | 2024-06-28 |
| 1702 | Espresso Frappuccino® 1702 | 124 124 | 720 | 770 | 2024-06-28 |
| 1703 | White Chocolate Mocha Frappuccino® 1703 | 124 124 | 720 | 770 | 2024-06-28 |
| 1704 | Chocolate Chip Cream Frappuccino® 1704 | 124 124 | 780 | 830 | 2024-06-28 |
| 1705 | Hojicha Tea Cream Frappuccino® 1705 | 124 124 | 760 | 810 | 2024-06-28 |
| 1706 | Vanilla Cream Frappuccino® 1706 | 124 124 | 720 | 770 | 2024-06-28 |
| 1707 | Mango Passion Fruit & Hibiscus 1707 | 124 124 | 720 | 770 | 2024-06-28 |
| 1708 | Raspberry Black Currant & Oolong 1708 | 124 124 | 720 | 770 | 2024-06-28 |
| 1709 | Coffee Traveller 1709 | 124 124 | 3120 | 3170 | 2024-06-28 |
| 1710 | Caffè Americano 1710 | 124 124 | 540 | 590 | 2024-06-28 |
| 1711 | Cappuccino 1711 | 124 124 | 680 | 730 | 2024-06-28 |
| 1712 | Caffè Mocha 1712 | 124 124 | 750 | 800 | 2024-06-28 |
| 1713 | Caramel Macchiato 1713 | 124 124 | 760 | 810 | 2024-06-28 |
| 1714 | Espresso 1714 | 124 124 | 390 | 440 | 2024-06-28 |
| 1715 | Caffè Latte 1715 | 124 124 | 680 | 730 | 2024-06-28 |
| 1716 | Oatmilk Latte 1716 | 124 124 | 760 | 810 | 2024-06-28 |
| 1717 | Vanilla Latte 1717 | 124 124 | 750 | 800 | 2024-06-28 |
| 1718 | White Chocolate Mocha 1718 | 124 124 | 750 | 800 | 2024-06-28 |
| 1719 | Flat White 1719 | 124 124 | 760 | 810 | 2024-06-28 |
| 1720 | Ristretto Bianco 1720 | 124 124 | 760 | 810 | 2024-06-28 |
| 1721 | Iced Caffè Americano 1721 | 124 124 | 540 | 590 | 2024-06-28 |
| 1722 | Iced Cappuccino 1722 | 124 124 | 680 | 730 | 2024-06-28 |
| 1723 | Iced Caffè Mocha 1723 | 124 124 | 750 | 800 | 2024-06-28 |
| 1724 | Iced Caramel Macchiato 1724 | 124 124 | 760 | 810 | 2024-06-28 |
| 1725 | Iced Caffè Latte 1725 | 124 124 | 680 | 730 | 2024-06-28 |
| 1726 | Iced Oatmilk Latte 1726 | 124 124 | 760 | 810 | 2024-06-28 |
| 1727 | Iced Vanilla Latte 1727 | 124 124 | 750 | 800 | 2024-06-28 |
| 1728 | Iced White Chocolate Mocha 1728 | 124 124 | 750 | 800 | 2024-06-28 |
| 1729 | Signature Hot Chocolate 1729 | 124 124 | 720 | 770 | 2024-06-28 |
| 1730 | Signature Iced Chocolate 1730 | 124 124 | 720 | 770 | 2024-06-28 |
| 1731 | Carrot Juice 1731 | 124 124 | 490 | 540 | 2024-06-28 |
| 1732 | Cloudy Apple Juice 1732 | 124 124 | 490 | 540 | 2024-06-28 |
| 1733 | Cranberry Red Grapefruit Juice 1733 | 124 124 | 490 | 540 | 2024-06-28 |
| 1734 | Orange Juice 1734 | 124 124 | 490 | 540 | 2024-06-28 |
| 1735 | Evian 1735 | 124 124 | 350 | 400 | 2024-06-28 |
| 1736 | Sparkling Water 1736 | 124 124 | 450 | 500 | 2024-06-28 |
| 1737 | Chai Tea 1737 | 124 124 | 500 | 550 | 2024-06-28 |
| 1738 | Earl Grey Tea 1738 | 124 124 | 500 | 550 | 2024-06-28 |
| 1739 | English Breakfast Tea 1739 | 124 124 | 500 | 550 | 2024-06-28 |
| 1740 | Emperor’s Clouds & Mist™ Tea 1740 | 124 124 | 500 | 550 | 2024-06-28 |
| 1741 | Mint Blend Tea 1741 | 124 124 | 500 | 550 | 2024-06-28 |
| 1742 | Chamomile Tea 1742 | 124 124 | 500 | 550 | 2024-06-28 |
| 1743 | Pure Matcha Latte 1743 | 124 124 | 740 | 790 | 2024-06-28 |
| 1744 | Chai Tea Latte 1744 | 124 124 | 680 | 730 | 2024-06-28 |
| 1745 | Earl Grey Tea Latte 1745 | 124 124 | 680 | 730 | 2024-06-28 |
| 1746 | English Breakfast Tea Latte 1746 | 124 124 | 680 | 730 | 2024-06-28 |
| 1747 | Hojicha Tea Latte 1747 | 124 124 | 740 | 790 | 2024-06-28 |
| 1748 | Zen Clouds Oolong Tea 1748 | 124 124 | 500 | 550 | 2024-06-28 |
| 1749 | Zen Clouds Oolong with Ruby Grapefruit and Honey 1749 | 124 124 | 630 | 680 | 2024-06-28 |
| 1750 | Youthberry™ Tea 1750 | 124 124 | 500 | 550 | 2024-06-28 |
| 1751 | Iced Shaken Black Tea Lemonade 1751 | 124 124 | 610 | 660 | 2024-06-28 |
| 1752 | Iced Shaken Strawberry Black Tea Lemonade 1752 | 124 124 | 630 | 680 | 2024-06-28 |
| 1753 | Iced Shaken Hibiscus Tea Lemonade 1753 | 124 124 | 610 | 660 | 2024-06-28 |
| 1754 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 1754 | 124 124 | 730 | 780 | 2024-06-28 |
| 1755 | Iced Pure Matcha Latte 1755 | 124 124 | 740 | 790 | 2024-06-28 |
| 1756 | Iced Chai Tea Latte 1756 | 124 124 | 680 | 730 | 2024-06-28 |
| 1757 | Iced Black Tea Latte 1757 | 124 124 | 680 | 730 | 2024-06-28 |
| 1758 | Iced Hojicha Tea Latte 1758 | 124 124 | 740 | 790 | 2024-06-28 |
| 1759 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 1759 | 124 124 | 630 | 680 | 2024-06-28 |
| 1760 | Iced Shaken Zen Clouds Oolong Lemonade 1760 | 124 124 | 610 | 660 | 2024-06-28 |
| 1761 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 1761 | 124 124 | 630 | 680 | 2024-06-28 |
| 1762 | Origami Pike Place® Roast 1762 | 124 124 | 990 | 1040 | 2024-06-28 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");