item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 60
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
- 60 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 16677 | Bagel 16677 | 60 60 | 400 | 430 | 2024-06-28 |
| 16678 | Cookie Crumble Cheesecake 16678 | 60 60 | 720 | 770 | 2024-06-28 |
| 16679 | Good Ol' NY Cheesecake 16679 | 60 60 | 720 | 770 | 2024-06-28 |
| 16680 | Signature Chocolate Cake 16680 | 60 60 | 720 | 770 | 2024-06-28 |
| 16681 | Starbucks® Coffee Tiramisu Cake 16681 | 60 60 | 750 | 800 | 2024-06-28 |
| 16682 | Strawberry Shortcake 16682 | 60 60 | 720 | 770 | 2024-06-28 |
| 16683 | Chocolate Chunk Monster Cookie 16683 | 60 60 | 390 | 440 | 2024-06-28 |
| 16684 | Banana Walnut Muffin 16684 | 60 60 | 450 | 500 | 2024-06-28 |
| 16685 | Blueberry Crumble Muffin 16685 | 60 60 | 450 | 500 | 2024-06-28 |
| 16686 | Chocolate Crumble Muffin 16686 | 60 60 | 450 | 500 | 2024-06-28 |
| 16687 | Pancakes 16687 | 60 60 | 550 | 600 | 2024-06-28 |
| 16688 | Almond Croissant 16688 | 60 60 | 470 | 520 | 2024-06-28 |
| 16689 | Buttery Croissant 16689 | 60 60 | 400 | 430 | 2024-06-28 |
| 16690 | Chocolate Croissant 16690 | 60 60 | 440 | 490 | 2024-06-28 |
| 16691 | Creamy Chicken Foldover 16691 | 60 60 | 550 | 600 | 2024-06-28 |
| 16692 | Sausage Roll 16692 | 60 60 | 550 | 600 | 2024-06-28 |
| 16693 | Buttery Scone 16693 | 60 60 | 400 | 430 | 2024-06-28 |
| 16694 | Country Chicken Pie 16694 | 60 60 | 690 | 740 | 2024-06-28 |
| 16695 | Deep Dish Beef Pie 16695 | 60 60 | 690 | 740 | 2024-06-28 |
| 16696 | Spinach & Mushroom Quiche 16696 | 60 60 | 690 | 740 | 2024-06-28 |
| 16697 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 16697 | 60 60 | 390 | 420 | 2024-06-28 |
| 16698 | Mixed Nuts 16698 | 60 60 | 490 | 540 | 2024-06-28 |
| 16699 | Caramel Waffles 16699 | 60 60 | 390 | 420 | 2024-06-28 |
| 16700 | Chicken Ham & Cheese Panwich 16700 | 60 60 | 690 | 740 | 2024-06-28 |
| 16701 | Egg Mayo & Cheese Multigrain Croissant 16701 | 60 60 | 690 | 740 | 2024-06-28 |
| 16702 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 16702 | 60 60 | 690 | 740 | 2024-06-28 |
| 16703 | Rosemary Chicken & Emmental Cheese Croissant 16703 | 60 60 | 690 | 740 | 2024-06-28 |
| 16704 | Scrambled Egg & Turkey Ham Pita 16704 | 60 60 | 690 | 740 | 2024-06-28 |
| 16705 | Turkey Ham & Triple Cheese Toast 16705 | 60 60 | 690 | 740 | 2024-06-28 |
| 16706 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 16706 | 60 60 | 790 | 840 | 2024-06-28 |
| 16707 | Ham & Cheese Croissant 16707 | 60 60 | 690 | 740 | 2024-06-28 |
| 16708 | Sriracha Chicken Whole Wheat Pita 16708 | 60 60 | 750 | 800 | 2024-06-28 |
| 16709 | Blueberry Acai Yogurt Parfait 16709 | 60 60 | 650 | 700 | 2024-06-28 |
| 16710 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 16710 | 60 60 | 650 | 700 | 2024-06-28 |
| 16711 | Caramel Frappuccino® 16711 | 60 60 | 720 | 770 | 2024-06-28 |
| 16712 | Dark Mocha Frappuccino® 16712 | 60 60 | 780 | 830 | 2024-06-28 |
| 16713 | Java Chip Frappuccino® 16713 | 60 60 | 780 | 830 | 2024-06-28 |
| 16714 | Mocha Frappuccino® 16714 | 60 60 | 720 | 770 | 2024-06-28 |
| 16715 | Caramel Macchiato Frappuccino® 16715 | 60 60 | 780 | 830 | 2024-06-28 |
| 16716 | Espresso Frappuccino® 16716 | 60 60 | 720 | 770 | 2024-06-28 |
| 16717 | White Chocolate Mocha Frappuccino® 16717 | 60 60 | 720 | 770 | 2024-06-28 |
| 16718 | Chocolate Chip Cream Frappuccino® 16718 | 60 60 | 780 | 830 | 2024-06-28 |
| 16719 | Hojicha Tea Cream Frappuccino® 16719 | 60 60 | 760 | 810 | 2024-06-28 |
| 16720 | Vanilla Cream Frappuccino® 16720 | 60 60 | 720 | 770 | 2024-06-28 |
| 16721 | Mango Passion Fruit & Hibiscus 16721 | 60 60 | 720 | 770 | 2024-06-28 |
| 16722 | Raspberry Black Currant & Oolong 16722 | 60 60 | 720 | 770 | 2024-06-28 |
| 16723 | Coffee Traveller 16723 | 60 60 | 3120 | 3170 | 2024-06-28 |
| 16724 | Caffè Americano 16724 | 60 60 | 540 | 590 | 2024-06-28 |
| 16725 | Cappuccino 16725 | 60 60 | 680 | 730 | 2024-06-28 |
| 16726 | Caffè Mocha 16726 | 60 60 | 750 | 800 | 2024-06-28 |
| 16727 | Caramel Macchiato 16727 | 60 60 | 760 | 810 | 2024-06-28 |
| 16728 | Espresso 16728 | 60 60 | 390 | 440 | 2024-06-28 |
| 16729 | Caffè Latte 16729 | 60 60 | 680 | 730 | 2024-06-28 |
| 16730 | Oatmilk Latte 16730 | 60 60 | 760 | 810 | 2024-06-28 |
| 16731 | Vanilla Latte 16731 | 60 60 | 750 | 800 | 2024-06-28 |
| 16732 | White Chocolate Mocha 16732 | 60 60 | 750 | 800 | 2024-06-28 |
| 16733 | Flat White 16733 | 60 60 | 760 | 810 | 2024-06-28 |
| 16734 | Ristretto Bianco 16734 | 60 60 | 760 | 810 | 2024-06-28 |
| 16735 | Iced Caffè Americano 16735 | 60 60 | 540 | 590 | 2024-06-28 |
| 16736 | Iced Cappuccino 16736 | 60 60 | 680 | 730 | 2024-06-28 |
| 16737 | Iced Caffè Mocha 16737 | 60 60 | 750 | 800 | 2024-06-28 |
| 16738 | Iced Caramel Macchiato 16738 | 60 60 | 760 | 810 | 2024-06-28 |
| 16739 | Iced Caffè Latte 16739 | 60 60 | 680 | 730 | 2024-06-28 |
| 16740 | Iced Oatmilk Latte 16740 | 60 60 | 760 | 810 | 2024-06-28 |
| 16741 | Iced Vanilla Latte 16741 | 60 60 | 750 | 800 | 2024-06-28 |
| 16742 | Iced White Chocolate Mocha 16742 | 60 60 | 750 | 800 | 2024-06-28 |
| 16743 | Signature Hot Chocolate 16743 | 60 60 | 720 | 770 | 2024-06-28 |
| 16744 | Signature Iced Chocolate 16744 | 60 60 | 720 | 770 | 2024-06-28 |
| 16745 | Carrot Juice 16745 | 60 60 | 490 | 540 | 2024-06-28 |
| 16746 | Cloudy Apple Juice 16746 | 60 60 | 490 | 540 | 2024-06-28 |
| 16747 | Cranberry Red Grapefruit Juice 16747 | 60 60 | 490 | 540 | 2024-06-28 |
| 16748 | Orange Juice 16748 | 60 60 | 490 | 540 | 2024-06-28 |
| 16749 | Evian 16749 | 60 60 | 350 | 400 | 2024-06-28 |
| 16750 | Sparkling Water 16750 | 60 60 | 450 | 500 | 2024-06-28 |
| 16751 | Chai Tea 16751 | 60 60 | 500 | 550 | 2024-06-28 |
| 16752 | Earl Grey Tea 16752 | 60 60 | 500 | 550 | 2024-06-28 |
| 16753 | English Breakfast Tea 16753 | 60 60 | 500 | 550 | 2024-06-28 |
| 16754 | Emperor’s Clouds & Mist™ Tea 16754 | 60 60 | 500 | 550 | 2024-06-28 |
| 16755 | Mint Blend Tea 16755 | 60 60 | 500 | 550 | 2024-06-28 |
| 16756 | Chamomile Tea 16756 | 60 60 | 500 | 550 | 2024-06-28 |
| 16757 | Pure Matcha Latte 16757 | 60 60 | 740 | 790 | 2024-06-28 |
| 16758 | Chai Tea Latte 16758 | 60 60 | 680 | 730 | 2024-06-28 |
| 16759 | Earl Grey Tea Latte 16759 | 60 60 | 680 | 730 | 2024-06-28 |
| 16760 | English Breakfast Tea Latte 16760 | 60 60 | 680 | 730 | 2024-06-28 |
| 16761 | Hojicha Tea Latte 16761 | 60 60 | 740 | 790 | 2024-06-28 |
| 16762 | Zen Clouds Oolong Tea 16762 | 60 60 | 500 | 550 | 2024-06-28 |
| 16763 | Zen Clouds Oolong with Ruby Grapefruit and Honey 16763 | 60 60 | 630 | 680 | 2024-06-28 |
| 16764 | Youthberry™ Tea 16764 | 60 60 | 500 | 550 | 2024-06-28 |
| 16765 | Iced Shaken Black Tea Lemonade 16765 | 60 60 | 610 | 660 | 2024-06-28 |
| 16766 | Iced Shaken Strawberry Black Tea Lemonade 16766 | 60 60 | 630 | 680 | 2024-06-28 |
| 16767 | Iced Shaken Hibiscus Tea Lemonade 16767 | 60 60 | 610 | 660 | 2024-06-28 |
| 16768 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 16768 | 60 60 | 730 | 780 | 2024-06-28 |
| 16769 | Iced Pure Matcha Latte 16769 | 60 60 | 740 | 790 | 2024-06-28 |
| 16770 | Iced Chai Tea Latte 16770 | 60 60 | 680 | 730 | 2024-06-28 |
| 16771 | Iced Black Tea Latte 16771 | 60 60 | 680 | 730 | 2024-06-28 |
| 16772 | Iced Hojicha Tea Latte 16772 | 60 60 | 740 | 790 | 2024-06-28 |
| 16773 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 16773 | 60 60 | 630 | 680 | 2024-06-28 |
| 16774 | Iced Shaken Zen Clouds Oolong Lemonade 16774 | 60 60 | 610 | 660 | 2024-06-28 |
| 16775 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 16775 | 60 60 | 630 | 680 | 2024-06-28 |
| 16776 | Origami Pike Place® Roast 16776 | 60 60 | 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");