item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
248 rows where store_id = 41
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
- 41 · 248 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 19611 | Bagel 19611 | 41 41 | 400 | 430 | 2024-06-28 |
| 19612 | Cookie Crumble Cheesecake 19612 | 41 41 | 720 | 770 | 2024-06-28 |
| 19613 | Good Ol' NY Cheesecake 19613 | 41 41 | 720 | 770 | 2024-06-28 |
| 19614 | Signature Chocolate Cake 19614 | 41 41 | 720 | 770 | 2024-06-28 |
| 19615 | Starbucks® Coffee Tiramisu Cake 19615 | 41 41 | 750 | 800 | 2024-06-28 |
| 19616 | Strawberry Shortcake 19616 | 41 41 | 720 | 770 | 2024-06-28 |
| 19617 | Chocolate Chunk Monster Cookie 19617 | 41 41 | 390 | 440 | 2024-06-28 |
| 19618 | Banana Walnut Muffin 19618 | 41 41 | 450 | 500 | 2024-06-28 |
| 19619 | Blueberry Crumble Muffin 19619 | 41 41 | 450 | 500 | 2024-06-28 |
| 19620 | Chocolate Crumble Muffin 19620 | 41 41 | 450 | 500 | 2024-06-28 |
| 19621 | Pancakes 19621 | 41 41 | 550 | 600 | 2024-06-28 |
| 19622 | Almond Croissant 19622 | 41 41 | 470 | 520 | 2024-06-28 |
| 19623 | Buttery Croissant 19623 | 41 41 | 400 | 430 | 2024-06-28 |
| 19624 | Chocolate Croissant 19624 | 41 41 | 440 | 490 | 2024-06-28 |
| 19625 | Creamy Chicken Foldover 19625 | 41 41 | 550 | 600 | 2024-06-28 |
| 19626 | Sausage Roll 19626 | 41 41 | 550 | 600 | 2024-06-28 |
| 19627 | Buttery Scone 19627 | 41 41 | 400 | 430 | 2024-06-28 |
| 19628 | Country Chicken Pie 19628 | 41 41 | 690 | 740 | 2024-06-28 |
| 19629 | Deep Dish Beef Pie 19629 | 41 41 | 690 | 740 | 2024-06-28 |
| 19630 | Spinach & Mushroom Quiche 19630 | 41 41 | 690 | 740 | 2024-06-28 |
| 19631 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 19631 | 41 41 | 390 | 420 | 2024-06-28 |
| 19632 | Mixed Nuts 19632 | 41 41 | 490 | 540 | 2024-06-28 |
| 19633 | Caramel Waffles 19633 | 41 41 | 390 | 420 | 2024-06-28 |
| 19634 | Chicken Ham & Cheese Panwich 19634 | 41 41 | 690 | 740 | 2024-06-28 |
| 19635 | Egg Mayo & Cheese Multigrain Croissant 19635 | 41 41 | 690 | 740 | 2024-06-28 |
| 19636 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 19636 | 41 41 | 690 | 740 | 2024-06-28 |
| 19637 | Rosemary Chicken & Emmental Cheese Croissant 19637 | 41 41 | 690 | 740 | 2024-06-28 |
| 19638 | Scrambled Egg & Turkey Ham Pita 19638 | 41 41 | 690 | 740 | 2024-06-28 |
| 19639 | Turkey Ham & Triple Cheese Toast 19639 | 41 41 | 690 | 740 | 2024-06-28 |
| 19640 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 19640 | 41 41 | 790 | 840 | 2024-06-28 |
| 19641 | Ham & Cheese Croissant 19641 | 41 41 | 690 | 740 | 2024-06-28 |
| 19642 | Sriracha Chicken Whole Wheat Pita 19642 | 41 41 | 750 | 800 | 2024-06-28 |
| 19643 | Blueberry Acai Yogurt Parfait 19643 | 41 41 | 650 | 700 | 2024-06-28 |
| 19644 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 19644 | 41 41 | 650 | 700 | 2024-06-28 |
| 19645 | Caramel Frappuccino® 19645 | 41 41 | 720 | 770 | 2024-06-28 |
| 19646 | Dark Mocha Frappuccino® 19646 | 41 41 | 780 | 830 | 2024-06-28 |
| 19647 | Java Chip Frappuccino® 19647 | 41 41 | 780 | 830 | 2024-06-28 |
| 19648 | Mocha Frappuccino® 19648 | 41 41 | 720 | 770 | 2024-06-28 |
| 19649 | Caramel Macchiato Frappuccino® 19649 | 41 41 | 780 | 830 | 2024-06-28 |
| 19650 | Espresso Frappuccino® 19650 | 41 41 | 720 | 770 | 2024-06-28 |
| 19651 | White Chocolate Mocha Frappuccino® 19651 | 41 41 | 720 | 770 | 2024-06-28 |
| 19652 | Chocolate Chip Cream Frappuccino® 19652 | 41 41 | 780 | 830 | 2024-06-28 |
| 19653 | Hojicha Tea Cream Frappuccino® 19653 | 41 41 | 760 | 810 | 2024-06-28 |
| 19654 | Vanilla Cream Frappuccino® 19654 | 41 41 | 720 | 770 | 2024-06-28 |
| 19655 | Mango Passion Fruit & Hibiscus 19655 | 41 41 | 720 | 770 | 2024-06-28 |
| 19656 | Raspberry Black Currant & Oolong 19656 | 41 41 | 720 | 770 | 2024-06-28 |
| 19657 | Coffee Traveller 19657 | 41 41 | 3120 | 3170 | 2024-06-28 |
| 19658 | Caffè Americano 19658 | 41 41 | 540 | 590 | 2024-06-28 |
| 19659 | Cappuccino 19659 | 41 41 | 680 | 730 | 2024-06-28 |
| 19660 | Caffè Mocha 19660 | 41 41 | 750 | 800 | 2024-06-28 |
| 19661 | Caramel Macchiato 19661 | 41 41 | 760 | 810 | 2024-06-28 |
| 19662 | Espresso 19662 | 41 41 | 390 | 440 | 2024-06-28 |
| 19663 | Caffè Latte 19663 | 41 41 | 680 | 730 | 2024-06-28 |
| 19664 | Oatmilk Latte 19664 | 41 41 | 760 | 810 | 2024-06-28 |
| 19665 | Vanilla Latte 19665 | 41 41 | 750 | 800 | 2024-06-28 |
| 19666 | White Chocolate Mocha 19666 | 41 41 | 750 | 800 | 2024-06-28 |
| 19667 | Flat White 19667 | 41 41 | 760 | 810 | 2024-06-28 |
| 19668 | Ristretto Bianco 19668 | 41 41 | 760 | 810 | 2024-06-28 |
| 19669 | Iced Caffè Americano 19669 | 41 41 | 540 | 590 | 2024-06-28 |
| 19670 | Iced Cappuccino 19670 | 41 41 | 680 | 730 | 2024-06-28 |
| 19671 | Iced Caffè Mocha 19671 | 41 41 | 750 | 800 | 2024-06-28 |
| 19672 | Iced Caramel Macchiato 19672 | 41 41 | 760 | 810 | 2024-06-28 |
| 19673 | Iced Caffè Latte 19673 | 41 41 | 680 | 730 | 2024-06-28 |
| 19674 | Iced Oatmilk Latte 19674 | 41 41 | 760 | 810 | 2024-06-28 |
| 19675 | Iced Vanilla Latte 19675 | 41 41 | 750 | 800 | 2024-06-28 |
| 19676 | Iced White Chocolate Mocha 19676 | 41 41 | 750 | 800 | 2024-06-28 |
| 19677 | Signature Hot Chocolate 19677 | 41 41 | 720 | 770 | 2024-06-28 |
| 19678 | Signature Iced Chocolate 19678 | 41 41 | 720 | 770 | 2024-06-28 |
| 19679 | Carrot Juice 19679 | 41 41 | 490 | 540 | 2024-06-28 |
| 19680 | Cloudy Apple Juice 19680 | 41 41 | 490 | 540 | 2024-06-28 |
| 19681 | Cranberry Red Grapefruit Juice 19681 | 41 41 | 490 | 540 | 2024-06-28 |
| 19682 | Orange Juice 19682 | 41 41 | 490 | 540 | 2024-06-28 |
| 19683 | Evian 19683 | 41 41 | 350 | 400 | 2024-06-28 |
| 19684 | Sparkling Water 19684 | 41 41 | 450 | 500 | 2024-06-28 |
| 19685 | Chai Tea 19685 | 41 41 | 500 | 550 | 2024-06-28 |
| 19686 | Earl Grey Tea 19686 | 41 41 | 500 | 550 | 2024-06-28 |
| 19687 | English Breakfast Tea 19687 | 41 41 | 500 | 550 | 2024-06-28 |
| 19688 | Emperor’s Clouds & Mist™ Tea 19688 | 41 41 | 500 | 550 | 2024-06-28 |
| 19689 | Mint Blend Tea 19689 | 41 41 | 500 | 550 | 2024-06-28 |
| 19690 | Chamomile Tea 19690 | 41 41 | 500 | 550 | 2024-06-28 |
| 19691 | Pure Matcha Latte 19691 | 41 41 | 740 | 790 | 2024-06-28 |
| 19692 | Chai Tea Latte 19692 | 41 41 | 680 | 730 | 2024-06-28 |
| 19693 | Earl Grey Tea Latte 19693 | 41 41 | 680 | 730 | 2024-06-28 |
| 19694 | English Breakfast Tea Latte 19694 | 41 41 | 680 | 730 | 2024-06-28 |
| 19695 | Hojicha Tea Latte 19695 | 41 41 | 740 | 790 | 2024-06-28 |
| 19696 | Zen Clouds Oolong Tea 19696 | 41 41 | 500 | 550 | 2024-06-28 |
| 19697 | Zen Clouds Oolong with Ruby Grapefruit and Honey 19697 | 41 41 | 630 | 680 | 2024-06-28 |
| 19698 | Youthberry™ Tea 19698 | 41 41 | 500 | 550 | 2024-06-28 |
| 19699 | Iced Shaken Black Tea Lemonade 19699 | 41 41 | 610 | 660 | 2024-06-28 |
| 19700 | Iced Shaken Strawberry Black Tea Lemonade 19700 | 41 41 | 630 | 680 | 2024-06-28 |
| 19701 | Iced Shaken Hibiscus Tea Lemonade 19701 | 41 41 | 610 | 660 | 2024-06-28 |
| 19702 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 19702 | 41 41 | 730 | 780 | 2024-06-28 |
| 19703 | Iced Pure Matcha Latte 19703 | 41 41 | 740 | 790 | 2024-06-28 |
| 19704 | Iced Chai Tea Latte 19704 | 41 41 | 680 | 730 | 2024-06-28 |
| 19705 | Iced Black Tea Latte 19705 | 41 41 | 680 | 730 | 2024-06-28 |
| 19706 | Iced Hojicha Tea Latte 19706 | 41 41 | 740 | 790 | 2024-06-28 |
| 19707 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 19707 | 41 41 | 630 | 680 | 2024-06-28 |
| 19708 | Iced Shaken Zen Clouds Oolong Lemonade 19708 | 41 41 | 610 | 660 | 2024-06-28 |
| 19709 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 19709 | 41 41 | 630 | 680 | 2024-06-28 |
| 19710 | Origami Pike Place® Roast 19710 | 41 41 | 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");