item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
249 rows where store_id = 115
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 13
- 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
- 2024-11-17 1
store_id 1
- 115 · 249 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 7710 | Bagel 7710 | 115 115 | 400 | 430 | 2024-06-28 |
| 7711 | Cookie Crumble Cheesecake 7711 | 115 115 | 720 | 770 | 2024-06-28 |
| 7712 | Good Ol' NY Cheesecake 7712 | 115 115 | 720 | 770 | 2024-06-28 |
| 7713 | Signature Chocolate Cake 7713 | 115 115 | 720 | 770 | 2024-06-28 |
| 7714 | Starbucks® Coffee Tiramisu Cake 7714 | 115 115 | 750 | 800 | 2024-06-28 |
| 7715 | Strawberry Shortcake 7715 | 115 115 | 720 | 770 | 2024-06-28 |
| 7716 | Chocolate Chunk Monster Cookie 7716 | 115 115 | 390 | 440 | 2024-06-28 |
| 7717 | Banana Walnut Muffin 7717 | 115 115 | 450 | 500 | 2024-06-28 |
| 7718 | Blueberry Crumble Muffin 7718 | 115 115 | 450 | 500 | 2024-06-28 |
| 7719 | Chocolate Crumble Muffin 7719 | 115 115 | 450 | 500 | 2024-06-28 |
| 7720 | Pancakes 7720 | 115 115 | 550 | 600 | 2024-06-28 |
| 7721 | Almond Croissant 7721 | 115 115 | 470 | 520 | 2024-06-28 |
| 7722 | Buttery Croissant 7722 | 115 115 | 400 | 430 | 2024-06-28 |
| 7723 | Chocolate Croissant 7723 | 115 115 | 440 | 490 | 2024-06-28 |
| 7724 | Creamy Chicken Foldover 7724 | 115 115 | 550 | 600 | 2024-06-28 |
| 7725 | Sausage Roll 7725 | 115 115 | 550 | 600 | 2024-06-28 |
| 7726 | Buttery Scone 7726 | 115 115 | 400 | 430 | 2024-06-28 |
| 7727 | Country Chicken Pie 7727 | 115 115 | 690 | 740 | 2024-06-28 |
| 7728 | Deep Dish Beef Pie 7728 | 115 115 | 690 | 740 | 2024-06-28 |
| 7729 | Spinach & Mushroom Quiche 7729 | 115 115 | 690 | 740 | 2024-06-28 |
| 7730 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 7730 | 115 115 | 390 | 420 | 2024-06-28 |
| 7731 | Mixed Nuts 7731 | 115 115 | 490 | 540 | 2024-06-28 |
| 7732 | Caramel Waffles 7732 | 115 115 | 390 | 420 | 2024-06-28 |
| 7733 | Chicken Ham & Cheese Panwich 7733 | 115 115 | 690 | 740 | 2024-06-28 |
| 7734 | Egg Mayo & Cheese Multigrain Croissant 7734 | 115 115 | 690 | 740 | 2024-06-28 |
| 7735 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 7735 | 115 115 | 690 | 740 | 2024-06-28 |
| 7736 | Rosemary Chicken & Emmental Cheese Croissant 7736 | 115 115 | 690 | 740 | 2024-06-28 |
| 7737 | Scrambled Egg & Turkey Ham Pita 7737 | 115 115 | 690 | 740 | 2024-06-28 |
| 7738 | Turkey Ham & Triple Cheese Toast 7738 | 115 115 | 690 | 740 | 2024-06-28 |
| 7739 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 7739 | 115 115 | 790 | 840 | 2024-06-28 |
| 7740 | Ham & Cheese Croissant 7740 | 115 115 | 690 | 740 | 2024-06-28 |
| 7741 | Sriracha Chicken Whole Wheat Pita 7741 | 115 115 | 750 | 800 | 2024-06-28 |
| 7742 | Blueberry Acai Yogurt Parfait 7742 | 115 115 | 650 | 700 | 2024-06-28 |
| 7743 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 7743 | 115 115 | 650 | 700 | 2024-06-28 |
| 7744 | Caramel Frappuccino® 7744 | 115 115 | 720 | 770 | 2024-06-28 |
| 7745 | Dark Mocha Frappuccino® 7745 | 115 115 | 780 | 830 | 2024-06-28 |
| 7746 | Java Chip Frappuccino® 7746 | 115 115 | 780 | 830 | 2024-06-28 |
| 7747 | Mocha Frappuccino® 7747 | 115 115 | 720 | 770 | 2024-06-28 |
| 7748 | Caramel Macchiato Frappuccino® 7748 | 115 115 | 780 | 830 | 2024-06-28 |
| 7749 | Espresso Frappuccino® 7749 | 115 115 | 720 | 770 | 2024-06-28 |
| 7750 | White Chocolate Mocha Frappuccino® 7750 | 115 115 | 720 | 770 | 2024-06-28 |
| 7751 | Chocolate Chip Cream Frappuccino® 7751 | 115 115 | 780 | 830 | 2024-06-28 |
| 7752 | Hojicha Tea Cream Frappuccino® 7752 | 115 115 | 760 | 810 | 2024-06-28 |
| 7753 | Vanilla Cream Frappuccino® 7753 | 115 115 | 720 | 770 | 2024-06-28 |
| 7754 | Mango Passion Fruit & Hibiscus 7754 | 115 115 | 720 | 770 | 2024-06-28 |
| 7755 | Raspberry Black Currant & Oolong 7755 | 115 115 | 720 | 770 | 2024-06-28 |
| 7756 | Coffee Traveller 7756 | 115 115 | 3120 | 3170 | 2024-06-28 |
| 7757 | Caffè Americano 7757 | 115 115 | 540 | 590 | 2024-06-28 |
| 7758 | Cappuccino 7758 | 115 115 | 680 | 730 | 2024-06-28 |
| 7759 | Caffè Mocha 7759 | 115 115 | 750 | 800 | 2024-06-28 |
| 7760 | Caramel Macchiato 7760 | 115 115 | 760 | 810 | 2024-06-28 |
| 7761 | Espresso 7761 | 115 115 | 390 | 440 | 2024-06-28 |
| 7762 | Caffè Latte 7762 | 115 115 | 680 | 730 | 2024-06-28 |
| 7763 | Oatmilk Latte 7763 | 115 115 | 760 | 810 | 2024-06-28 |
| 7764 | Vanilla Latte 7764 | 115 115 | 750 | 800 | 2024-06-28 |
| 7765 | White Chocolate Mocha 7765 | 115 115 | 750 | 800 | 2024-06-28 |
| 7766 | Flat White 7766 | 115 115 | 760 | 810 | 2024-06-28 |
| 7767 | Ristretto Bianco 7767 | 115 115 | 760 | 810 | 2024-06-28 |
| 7768 | Iced Caffè Americano 7768 | 115 115 | 540 | 590 | 2024-06-28 |
| 7769 | Iced Cappuccino 7769 | 115 115 | 680 | 730 | 2024-06-28 |
| 7770 | Iced Caffè Mocha 7770 | 115 115 | 750 | 800 | 2024-06-28 |
| 7771 | Iced Caramel Macchiato 7771 | 115 115 | 760 | 810 | 2024-06-28 |
| 7772 | Iced Caffè Latte 7772 | 115 115 | 680 | 730 | 2024-06-28 |
| 7773 | Iced Oatmilk Latte 7773 | 115 115 | 760 | 810 | 2024-06-28 |
| 7774 | Iced Vanilla Latte 7774 | 115 115 | 750 | 800 | 2024-06-28 |
| 7775 | Iced White Chocolate Mocha 7775 | 115 115 | 750 | 800 | 2024-06-28 |
| 7776 | Signature Hot Chocolate 7776 | 115 115 | 720 | 770 | 2024-06-28 |
| 7777 | Signature Iced Chocolate 7777 | 115 115 | 720 | 770 | 2024-06-28 |
| 7778 | Carrot Juice 7778 | 115 115 | 490 | 540 | 2024-06-28 |
| 7779 | Cloudy Apple Juice 7779 | 115 115 | 490 | 540 | 2024-06-28 |
| 7780 | Cranberry Red Grapefruit Juice 7780 | 115 115 | 490 | 540 | 2024-06-28 |
| 7781 | Orange Juice 7781 | 115 115 | 490 | 540 | 2024-06-28 |
| 7782 | Evian 7782 | 115 115 | 350 | 400 | 2024-06-28 |
| 7783 | Sparkling Water 7783 | 115 115 | 450 | 500 | 2024-06-28 |
| 7784 | Chai Tea 7784 | 115 115 | 500 | 550 | 2024-06-28 |
| 7785 | Earl Grey Tea 7785 | 115 115 | 500 | 550 | 2024-06-28 |
| 7786 | English Breakfast Tea 7786 | 115 115 | 500 | 550 | 2024-06-28 |
| 7787 | Emperor’s Clouds & Mist™ Tea 7787 | 115 115 | 500 | 550 | 2024-06-28 |
| 7788 | Mint Blend Tea 7788 | 115 115 | 500 | 550 | 2024-06-28 |
| 7789 | Chamomile Tea 7789 | 115 115 | 500 | 550 | 2024-06-28 |
| 7790 | Pure Matcha Latte 7790 | 115 115 | 740 | 790 | 2024-06-28 |
| 7791 | Chai Tea Latte 7791 | 115 115 | 680 | 730 | 2024-06-28 |
| 7792 | Earl Grey Tea Latte 7792 | 115 115 | 680 | 730 | 2024-06-28 |
| 7793 | English Breakfast Tea Latte 7793 | 115 115 | 680 | 730 | 2024-06-28 |
| 7794 | Hojicha Tea Latte 7794 | 115 115 | 740 | 790 | 2024-06-28 |
| 7795 | Zen Clouds Oolong Tea 7795 | 115 115 | 500 | 550 | 2024-06-28 |
| 7796 | Zen Clouds Oolong with Ruby Grapefruit and Honey 7796 | 115 115 | 630 | 680 | 2024-06-28 |
| 7797 | Youthberry™ Tea 7797 | 115 115 | 500 | 550 | 2024-06-28 |
| 7798 | Iced Shaken Black Tea Lemonade 7798 | 115 115 | 610 | 660 | 2024-06-28 |
| 7799 | Iced Shaken Strawberry Black Tea Lemonade 7799 | 115 115 | 630 | 680 | 2024-06-28 |
| 7800 | Iced Shaken Hibiscus Tea Lemonade 7800 | 115 115 | 610 | 660 | 2024-06-28 |
| 7801 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 7801 | 115 115 | 730 | 780 | 2024-06-28 |
| 7802 | Iced Pure Matcha Latte 7802 | 115 115 | 740 | 790 | 2024-06-28 |
| 7803 | Iced Chai Tea Latte 7803 | 115 115 | 680 | 730 | 2024-06-28 |
| 7804 | Iced Black Tea Latte 7804 | 115 115 | 680 | 730 | 2024-06-28 |
| 7805 | Iced Hojicha Tea Latte 7805 | 115 115 | 740 | 790 | 2024-06-28 |
| 7806 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 7806 | 115 115 | 630 | 680 | 2024-06-28 |
| 7807 | Iced Shaken Zen Clouds Oolong Lemonade 7807 | 115 115 | 610 | 660 | 2024-06-28 |
| 7808 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 7808 | 115 115 | 630 | 680 | 2024-06-28 |
| 7809 | Origami Pike Place® Roast 7809 | 115 115 | 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");