item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
238 rows where store_id = 98
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 11
- 2024-06-28 184
- 2024-09-15 10
- 2024-11-03 9
- 2024-07-17 7
- 2024-08-18 6
- 2024-07-28 5
- 2024-10-13 5
- 2024-07-03 4
- 2024-10-06 4
- 2024-07-14 2
- 2024-09-29 2
store_id 1
- 98 · 238 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 10624 | Bagel 10624 | 98 98 | 400 | 430 | 2024-06-28 |
| 10625 | Cookie Crumble Cheesecake 10625 | 98 98 | 720 | 770 | 2024-06-28 |
| 10626 | Good Ol' NY Cheesecake 10626 | 98 98 | 720 | 770 | 2024-06-28 |
| 10627 | Signature Chocolate Cake 10627 | 98 98 | 720 | 770 | 2024-06-28 |
| 10628 | Starbucks® Coffee Tiramisu Cake 10628 | 98 98 | 750 | 800 | 2024-06-28 |
| 10629 | Strawberry Shortcake 10629 | 98 98 | 720 | 770 | 2024-06-28 |
| 10630 | Chocolate Chunk Monster Cookie 10630 | 98 98 | 390 | 440 | 2024-06-28 |
| 10631 | Banana Walnut Muffin 10631 | 98 98 | 450 | 500 | 2024-06-28 |
| 10632 | Blueberry Crumble Muffin 10632 | 98 98 | 450 | 500 | 2024-06-28 |
| 10633 | Chocolate Crumble Muffin 10633 | 98 98 | 450 | 500 | 2024-06-28 |
| 10634 | Pancakes 10634 | 98 98 | 550 | 600 | 2024-06-28 |
| 10635 | Almond Croissant 10635 | 98 98 | 470 | 520 | 2024-06-28 |
| 10636 | Buttery Croissant 10636 | 98 98 | 400 | 430 | 2024-06-28 |
| 10637 | Chocolate Croissant 10637 | 98 98 | 440 | 490 | 2024-06-28 |
| 10638 | Creamy Chicken Foldover 10638 | 98 98 | 550 | 600 | 2024-06-28 |
| 10639 | Sausage Roll 10639 | 98 98 | 550 | 600 | 2024-06-28 |
| 10640 | Buttery Scone 10640 | 98 98 | 400 | 430 | 2024-06-28 |
| 10641 | Country Chicken Pie 10641 | 98 98 | 690 | 740 | 2024-06-28 |
| 10642 | Deep Dish Beef Pie 10642 | 98 98 | 690 | 740 | 2024-06-28 |
| 10643 | Spinach & Mushroom Quiche 10643 | 98 98 | 690 | 740 | 2024-06-28 |
| 10644 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 10644 | 98 98 | 390 | 420 | 2024-06-28 |
| 10645 | Mixed Nuts 10645 | 98 98 | 490 | 540 | 2024-06-28 |
| 10646 | Caramel Waffles 10646 | 98 98 | 390 | 420 | 2024-06-28 |
| 10647 | Chicken Ham & Cheese Panwich 10647 | 98 98 | 690 | 740 | 2024-06-28 |
| 10648 | Egg Mayo & Cheese Multigrain Croissant 10648 | 98 98 | 690 | 740 | 2024-06-28 |
| 10649 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 10649 | 98 98 | 690 | 740 | 2024-06-28 |
| 10650 | Rosemary Chicken & Emmental Cheese Croissant 10650 | 98 98 | 690 | 740 | 2024-06-28 |
| 10651 | Scrambled Egg & Turkey Ham Pita 10651 | 98 98 | 690 | 740 | 2024-06-28 |
| 10652 | Turkey Ham & Triple Cheese Toast 10652 | 98 98 | 690 | 740 | 2024-06-28 |
| 10653 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 10653 | 98 98 | 790 | 840 | 2024-06-28 |
| 10654 | Ham & Cheese Croissant 10654 | 98 98 | 690 | 740 | 2024-06-28 |
| 10655 | Sriracha Chicken Whole Wheat Pita 10655 | 98 98 | 750 | 800 | 2024-06-28 |
| 10656 | Blueberry Acai Yogurt Parfait 10656 | 98 98 | 650 | 700 | 2024-06-28 |
| 10657 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 10657 | 98 98 | 650 | 700 | 2024-06-28 |
| 10658 | Caramel Frappuccino® 10658 | 98 98 | 720 | 770 | 2024-06-28 |
| 10659 | Dark Mocha Frappuccino® 10659 | 98 98 | 780 | 830 | 2024-06-28 |
| 10660 | Java Chip Frappuccino® 10660 | 98 98 | 780 | 830 | 2024-06-28 |
| 10661 | Mocha Frappuccino® 10661 | 98 98 | 720 | 770 | 2024-06-28 |
| 10662 | Caramel Macchiato Frappuccino® 10662 | 98 98 | 780 | 830 | 2024-06-28 |
| 10663 | Espresso Frappuccino® 10663 | 98 98 | 720 | 770 | 2024-06-28 |
| 10664 | White Chocolate Mocha Frappuccino® 10664 | 98 98 | 720 | 770 | 2024-06-28 |
| 10665 | Chocolate Chip Cream Frappuccino® 10665 | 98 98 | 780 | 830 | 2024-06-28 |
| 10666 | Hojicha Tea Cream Frappuccino® 10666 | 98 98 | 760 | 810 | 2024-06-28 |
| 10667 | Vanilla Cream Frappuccino® 10667 | 98 98 | 720 | 770 | 2024-06-28 |
| 10668 | Mango Passion Fruit & Hibiscus 10668 | 98 98 | 720 | 770 | 2024-06-28 |
| 10669 | Raspberry Black Currant & Oolong 10669 | 98 98 | 720 | 770 | 2024-06-28 |
| 10670 | Coffee Traveller 10670 | 98 98 | 3120 | 3170 | 2024-06-28 |
| 10671 | Caffè Americano 10671 | 98 98 | 540 | 590 | 2024-06-28 |
| 10672 | Cappuccino 10672 | 98 98 | 680 | 730 | 2024-06-28 |
| 10673 | Caffè Mocha 10673 | 98 98 | 750 | 800 | 2024-06-28 |
| 10674 | Caramel Macchiato 10674 | 98 98 | 760 | 810 | 2024-06-28 |
| 10675 | Espresso 10675 | 98 98 | 390 | 440 | 2024-06-28 |
| 10676 | Caffè Latte 10676 | 98 98 | 680 | 730 | 2024-06-28 |
| 10677 | Oatmilk Latte 10677 | 98 98 | 760 | 810 | 2024-06-28 |
| 10678 | Vanilla Latte 10678 | 98 98 | 750 | 800 | 2024-06-28 |
| 10679 | White Chocolate Mocha 10679 | 98 98 | 750 | 800 | 2024-06-28 |
| 10680 | Flat White 10680 | 98 98 | 760 | 810 | 2024-06-28 |
| 10681 | Ristretto Bianco 10681 | 98 98 | 760 | 810 | 2024-06-28 |
| 10682 | Iced Caffè Americano 10682 | 98 98 | 540 | 590 | 2024-06-28 |
| 10683 | Iced Cappuccino 10683 | 98 98 | 680 | 730 | 2024-06-28 |
| 10684 | Iced Caffè Mocha 10684 | 98 98 | 750 | 800 | 2024-06-28 |
| 10685 | Iced Caramel Macchiato 10685 | 98 98 | 760 | 810 | 2024-06-28 |
| 10686 | Iced Caffè Latte 10686 | 98 98 | 680 | 730 | 2024-06-28 |
| 10687 | Iced Oatmilk Latte 10687 | 98 98 | 760 | 810 | 2024-06-28 |
| 10688 | Iced Vanilla Latte 10688 | 98 98 | 750 | 800 | 2024-06-28 |
| 10689 | Iced White Chocolate Mocha 10689 | 98 98 | 750 | 800 | 2024-06-28 |
| 10690 | Signature Hot Chocolate 10690 | 98 98 | 720 | 770 | 2024-06-28 |
| 10691 | Signature Iced Chocolate 10691 | 98 98 | 720 | 770 | 2024-06-28 |
| 10692 | Carrot Juice 10692 | 98 98 | 490 | 540 | 2024-06-28 |
| 10693 | Cloudy Apple Juice 10693 | 98 98 | 490 | 540 | 2024-06-28 |
| 10694 | Cranberry Red Grapefruit Juice 10694 | 98 98 | 490 | 540 | 2024-06-28 |
| 10695 | Orange Juice 10695 | 98 98 | 490 | 540 | 2024-06-28 |
| 10696 | Evian 10696 | 98 98 | 350 | 400 | 2024-06-28 |
| 10697 | Sparkling Water 10697 | 98 98 | 450 | 500 | 2024-06-28 |
| 10698 | Chai Tea 10698 | 98 98 | 500 | 550 | 2024-06-28 |
| 10699 | Earl Grey Tea 10699 | 98 98 | 500 | 550 | 2024-06-28 |
| 10700 | English Breakfast Tea 10700 | 98 98 | 500 | 550 | 2024-06-28 |
| 10701 | Emperor’s Clouds & Mist™ Tea 10701 | 98 98 | 500 | 550 | 2024-06-28 |
| 10702 | Mint Blend Tea 10702 | 98 98 | 500 | 550 | 2024-06-28 |
| 10703 | Chamomile Tea 10703 | 98 98 | 500 | 550 | 2024-06-28 |
| 10704 | Pure Matcha Latte 10704 | 98 98 | 740 | 790 | 2024-06-28 |
| 10705 | Chai Tea Latte 10705 | 98 98 | 680 | 730 | 2024-06-28 |
| 10706 | Earl Grey Tea Latte 10706 | 98 98 | 680 | 730 | 2024-06-28 |
| 10707 | English Breakfast Tea Latte 10707 | 98 98 | 680 | 730 | 2024-06-28 |
| 10708 | Hojicha Tea Latte 10708 | 98 98 | 740 | 790 | 2024-06-28 |
| 10709 | Zen Clouds Oolong Tea 10709 | 98 98 | 500 | 550 | 2024-06-28 |
| 10710 | Zen Clouds Oolong with Ruby Grapefruit and Honey 10710 | 98 98 | 630 | 680 | 2024-06-28 |
| 10711 | Youthberry™ Tea 10711 | 98 98 | 500 | 550 | 2024-06-28 |
| 10712 | Iced Shaken Black Tea Lemonade 10712 | 98 98 | 610 | 660 | 2024-06-28 |
| 10713 | Iced Shaken Strawberry Black Tea Lemonade 10713 | 98 98 | 630 | 680 | 2024-06-28 |
| 10714 | Iced Shaken Hibiscus Tea Lemonade 10714 | 98 98 | 610 | 660 | 2024-06-28 |
| 10715 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 10715 | 98 98 | 730 | 780 | 2024-06-28 |
| 10716 | Iced Pure Matcha Latte 10716 | 98 98 | 740 | 790 | 2024-06-28 |
| 10717 | Iced Chai Tea Latte 10717 | 98 98 | 680 | 730 | 2024-06-28 |
| 10718 | Iced Black Tea Latte 10718 | 98 98 | 680 | 730 | 2024-06-28 |
| 10719 | Iced Hojicha Tea Latte 10719 | 98 98 | 740 | 790 | 2024-06-28 |
| 10720 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 10720 | 98 98 | 630 | 680 | 2024-06-28 |
| 10721 | Iced Shaken Zen Clouds Oolong Lemonade 10721 | 98 98 | 610 | 660 | 2024-06-28 |
| 10722 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 10722 | 98 98 | 630 | 680 | 2024-06-28 |
| 10723 | Origami Pike Place® Roast 10723 | 98 98 | 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");