item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 19
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 11
- 2024-06-28 182
- 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
- 19 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 23630 | Bagel 23630 | 19 19 | 400 | 430 | 2024-06-28 |
| 23631 | Cookie Crumble Cheesecake 23631 | 19 19 | 720 | 770 | 2024-06-28 |
| 23632 | Good Ol' NY Cheesecake 23632 | 19 19 | 720 | 770 | 2024-06-28 |
| 23633 | Signature Chocolate Cake 23633 | 19 19 | 720 | 770 | 2024-06-28 |
| 23634 | Starbucks® Coffee Tiramisu Cake 23634 | 19 19 | 750 | 800 | 2024-06-28 |
| 23635 | Strawberry Shortcake 23635 | 19 19 | 720 | 770 | 2024-06-28 |
| 23636 | Chocolate Chunk Monster Cookie 23636 | 19 19 | 390 | 440 | 2024-06-28 |
| 23637 | Banana Walnut Muffin 23637 | 19 19 | 450 | 500 | 2024-06-28 |
| 23638 | Blueberry Crumble Muffin 23638 | 19 19 | 450 | 500 | 2024-06-28 |
| 23639 | Chocolate Crumble Muffin 23639 | 19 19 | 450 | 500 | 2024-06-28 |
| 23640 | Pancakes 23640 | 19 19 | 550 | 600 | 2024-06-28 |
| 23641 | Almond Croissant 23641 | 19 19 | 470 | 520 | 2024-06-28 |
| 23642 | Buttery Croissant 23642 | 19 19 | 400 | 430 | 2024-06-28 |
| 23643 | Chocolate Croissant 23643 | 19 19 | 440 | 490 | 2024-06-28 |
| 23644 | Creamy Chicken Foldover 23644 | 19 19 | 550 | 600 | 2024-06-28 |
| 23645 | Sausage Roll 23645 | 19 19 | 550 | 600 | 2024-06-28 |
| 23646 | Buttery Scone 23646 | 19 19 | 400 | 430 | 2024-06-28 |
| 23647 | Country Chicken Pie 23647 | 19 19 | 690 | 740 | 2024-06-28 |
| 23648 | Deep Dish Beef Pie 23648 | 19 19 | 690 | 740 | 2024-06-28 |
| 23649 | Spinach & Mushroom Quiche 23649 | 19 19 | 690 | 740 | 2024-06-28 |
| 23650 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 23650 | 19 19 | 390 | 420 | 2024-06-28 |
| 23651 | Mixed Nuts 23651 | 19 19 | 490 | 540 | 2024-06-28 |
| 23652 | Caramel Waffles 23652 | 19 19 | 390 | 420 | 2024-06-28 |
| 23653 | Chicken Ham & Cheese Panwich 23653 | 19 19 | 690 | 740 | 2024-06-28 |
| 23654 | Egg Mayo & Cheese Multigrain Croissant 23654 | 19 19 | 690 | 740 | 2024-06-28 |
| 23655 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 23655 | 19 19 | 690 | 740 | 2024-06-28 |
| 23656 | Rosemary Chicken & Emmental Cheese Croissant 23656 | 19 19 | 690 | 740 | 2024-06-28 |
| 23657 | Scrambled Egg & Turkey Ham Pita 23657 | 19 19 | 690 | 740 | 2024-06-28 |
| 23658 | Turkey Ham & Triple Cheese Toast 23658 | 19 19 | 690 | 740 | 2024-06-28 |
| 23659 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 23659 | 19 19 | 790 | 840 | 2024-06-28 |
| 23660 | Ham & Cheese Croissant 23660 | 19 19 | 690 | 740 | 2024-06-28 |
| 23661 | Sriracha Chicken Whole Wheat Pita 23661 | 19 19 | 750 | 800 | 2024-06-28 |
| 23662 | Blueberry Acai Yogurt Parfait 23662 | 19 19 | 650 | 700 | 2024-06-28 |
| 23663 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 23663 | 19 19 | 650 | 700 | 2024-06-28 |
| 23664 | Caramel Frappuccino® 23664 | 19 19 | 720 | 770 | 2024-06-28 |
| 23665 | Dark Mocha Frappuccino® 23665 | 19 19 | 780 | 830 | 2024-06-28 |
| 23666 | Java Chip Frappuccino® 23666 | 19 19 | 780 | 830 | 2024-06-28 |
| 23667 | Mocha Frappuccino® 23667 | 19 19 | 720 | 770 | 2024-06-28 |
| 23668 | Caramel Macchiato Frappuccino® 23668 | 19 19 | 780 | 830 | 2024-06-28 |
| 23669 | Espresso Frappuccino® 23669 | 19 19 | 720 | 770 | 2024-06-28 |
| 23670 | White Chocolate Mocha Frappuccino® 23670 | 19 19 | 720 | 770 | 2024-06-28 |
| 23671 | Chocolate Chip Cream Frappuccino® 23671 | 19 19 | 780 | 830 | 2024-06-28 |
| 23672 | Hojicha Tea Cream Frappuccino® 23672 | 19 19 | 760 | 810 | 2024-06-28 |
| 23673 | Vanilla Cream Frappuccino® 23673 | 19 19 | 720 | 770 | 2024-06-28 |
| 23674 | Mango Passion Fruit & Hibiscus 23674 | 19 19 | 720 | 770 | 2024-06-28 |
| 23675 | Raspberry Black Currant & Oolong 23675 | 19 19 | 720 | 770 | 2024-06-28 |
| 23676 | Coffee Traveller 23676 | 19 19 | 3120 | 3170 | 2024-06-28 |
| 23677 | Caffè Americano 23677 | 19 19 | 540 | 590 | 2024-06-28 |
| 23678 | Cappuccino 23678 | 19 19 | 680 | 730 | 2024-06-28 |
| 23679 | Caffè Mocha 23679 | 19 19 | 750 | 800 | 2024-06-28 |
| 23680 | Caramel Macchiato 23680 | 19 19 | 760 | 810 | 2024-06-28 |
| 23681 | Espresso 23681 | 19 19 | 390 | 440 | 2024-06-28 |
| 23682 | Caffè Latte 23682 | 19 19 | 680 | 730 | 2024-06-28 |
| 23683 | Oatmilk Latte 23683 | 19 19 | 760 | 810 | 2024-06-28 |
| 23684 | Vanilla Latte 23684 | 19 19 | 750 | 800 | 2024-06-28 |
| 23685 | White Chocolate Mocha 23685 | 19 19 | 750 | 800 | 2024-06-28 |
| 23686 | Flat White 23686 | 19 19 | 760 | 810 | 2024-06-28 |
| 23687 | Ristretto Bianco 23687 | 19 19 | 760 | 810 | 2024-06-28 |
| 23688 | Iced Caffè Americano 23688 | 19 19 | 540 | 590 | 2024-06-28 |
| 23689 | Iced Cappuccino 23689 | 19 19 | 680 | 730 | 2024-06-28 |
| 23690 | Iced Caffè Mocha 23690 | 19 19 | 750 | 800 | 2024-06-28 |
| 23691 | Iced Caramel Macchiato 23691 | 19 19 | 760 | 810 | 2024-06-28 |
| 23692 | Iced Caffè Latte 23692 | 19 19 | 680 | 730 | 2024-06-28 |
| 23693 | Iced Oatmilk Latte 23693 | 19 19 | 760 | 810 | 2024-06-28 |
| 23694 | Iced Vanilla Latte 23694 | 19 19 | 750 | 800 | 2024-06-28 |
| 23695 | Iced White Chocolate Mocha 23695 | 19 19 | 750 | 800 | 2024-06-28 |
| 23696 | Signature Hot Chocolate 23696 | 19 19 | 720 | 770 | 2024-06-28 |
| 23697 | Signature Iced Chocolate 23697 | 19 19 | 720 | 770 | 2024-06-28 |
| 23698 | Carrot Juice 23698 | 19 19 | 490 | 540 | 2024-06-28 |
| 23699 | Cloudy Apple Juice 23699 | 19 19 | 490 | 540 | 2024-06-28 |
| 23700 | Cranberry Red Grapefruit Juice 23700 | 19 19 | 490 | 540 | 2024-06-28 |
| 23701 | Orange Juice 23701 | 19 19 | 490 | 540 | 2024-06-28 |
| 23702 | Evian 23702 | 19 19 | 350 | 400 | 2024-06-28 |
| 23703 | Sparkling Water 23703 | 19 19 | 450 | 500 | 2024-06-28 |
| 23704 | Chai Tea 23704 | 19 19 | 500 | 550 | 2024-06-28 |
| 23705 | Earl Grey Tea 23705 | 19 19 | 500 | 550 | 2024-06-28 |
| 23706 | English Breakfast Tea 23706 | 19 19 | 500 | 550 | 2024-06-28 |
| 23707 | Emperor’s Clouds & Mist™ Tea 23707 | 19 19 | 500 | 550 | 2024-06-28 |
| 23708 | Mint Blend Tea 23708 | 19 19 | 500 | 550 | 2024-06-28 |
| 23709 | Chamomile Tea 23709 | 19 19 | 500 | 550 | 2024-06-28 |
| 23710 | Pure Matcha Latte 23710 | 19 19 | 740 | 790 | 2024-06-28 |
| 23711 | Chai Tea Latte 23711 | 19 19 | 680 | 730 | 2024-06-28 |
| 23712 | Earl Grey Tea Latte 23712 | 19 19 | 680 | 730 | 2024-06-28 |
| 23713 | English Breakfast Tea Latte 23713 | 19 19 | 680 | 730 | 2024-06-28 |
| 23714 | Hojicha Tea Latte 23714 | 19 19 | 740 | 790 | 2024-06-28 |
| 23715 | Zen Clouds Oolong Tea 23715 | 19 19 | 500 | 550 | 2024-06-28 |
| 23716 | Zen Clouds Oolong with Ruby Grapefruit and Honey 23716 | 19 19 | 630 | 680 | 2024-06-28 |
| 23717 | Youthberry™ Tea 23717 | 19 19 | 500 | 550 | 2024-06-28 |
| 23718 | Iced Shaken Black Tea Lemonade 23718 | 19 19 | 610 | 660 | 2024-06-28 |
| 23719 | Iced Shaken Strawberry Black Tea Lemonade 23719 | 19 19 | 630 | 680 | 2024-06-28 |
| 23720 | Iced Shaken Hibiscus Tea Lemonade 23720 | 19 19 | 610 | 660 | 2024-06-28 |
| 23721 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 23721 | 19 19 | 730 | 780 | 2024-06-28 |
| 23722 | Iced Pure Matcha Latte 23722 | 19 19 | 740 | 790 | 2024-06-28 |
| 23723 | Iced Chai Tea Latte 23723 | 19 19 | 680 | 730 | 2024-06-28 |
| 23724 | Iced Black Tea Latte 23724 | 19 19 | 680 | 730 | 2024-06-28 |
| 23725 | Iced Hojicha Tea Latte 23725 | 19 19 | 740 | 790 | 2024-06-28 |
| 23726 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 23726 | 19 19 | 630 | 680 | 2024-06-28 |
| 23727 | Iced Shaken Zen Clouds Oolong Lemonade 23727 | 19 19 | 610 | 660 | 2024-06-28 |
| 23728 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 23728 | 19 19 | 630 | 680 | 2024-06-28 |
| 23729 | Origami Pike Place® Roast 23729 | 19 19 | 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");