item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
239 rows where store_id = 30
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 11
- 2024-06-28 185
- 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
- 30 · 239 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 21620 | Bagel 21620 | 30 30 | 430 | 460 | 2024-06-28 |
| 21621 | Cookie Crumble Cheesecake 21621 | 30 30 | 750 | 800 | 2024-06-28 |
| 21622 | Good Ol' NY Cheesecake 21622 | 30 30 | 750 | 800 | 2024-06-28 |
| 21623 | Signature Chocolate Cake 21623 | 30 30 | 750 | 800 | 2024-06-28 |
| 21624 | Starbucks® Coffee Tiramisu Cake 21624 | 30 30 | 780 | 830 | 2024-06-28 |
| 21625 | Strawberry Shortcake 21625 | 30 30 | 750 | 800 | 2024-06-28 |
| 21626 | Chocolate Chunk Monster Cookie 21626 | 30 30 | 420 | 470 | 2024-06-28 |
| 21627 | Banana Walnut Muffin 21627 | 30 30 | 480 | 530 | 2024-06-28 |
| 21628 | Blueberry Crumble Muffin 21628 | 30 30 | 480 | 530 | 2024-06-28 |
| 21629 | Chocolate Crumble Muffin 21629 | 30 30 | 480 | 530 | 2024-06-28 |
| 21630 | Pancakes 21630 | 30 30 | 580 | 630 | 2024-06-28 |
| 21631 | Almond Croissant 21631 | 30 30 | 500 | 550 | 2024-06-28 |
| 21632 | Buttery Croissant 21632 | 30 30 | 430 | 460 | 2024-06-28 |
| 21633 | Chocolate Croissant 21633 | 30 30 | 470 | 520 | 2024-06-28 |
| 21634 | Creamy Chicken Foldover 21634 | 30 30 | 580 | 630 | 2024-06-28 |
| 21635 | Sausage Roll 21635 | 30 30 | 580 | 630 | 2024-06-28 |
| 21636 | Buttery Scone 21636 | 30 30 | 430 | 460 | 2024-06-28 |
| 21637 | Country Chicken Pie 21637 | 30 30 | 720 | 770 | 2024-06-28 |
| 21638 | Deep Dish Beef Pie 21638 | 30 30 | 720 | 770 | 2024-06-28 |
| 21639 | Spinach & Mushroom Quiche 21639 | 30 30 | 720 | 770 | 2024-06-28 |
| 21640 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 21640 | 30 30 | 420 | 450 | 2024-06-28 |
| 21641 | Mixed Nuts 21641 | 30 30 | 520 | 570 | 2024-06-28 |
| 21642 | Caramel Waffles 21642 | 30 30 | 420 | 450 | 2024-06-28 |
| 21643 | Chicken Ham & Cheese Panwich 21643 | 30 30 | 720 | 770 | 2024-06-28 |
| 21644 | Egg Mayo & Cheese Multigrain Croissant 21644 | 30 30 | 720 | 770 | 2024-06-28 |
| 21645 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 21645 | 30 30 | 720 | 770 | 2024-06-28 |
| 21646 | Rosemary Chicken & Emmental Cheese Croissant 21646 | 30 30 | 720 | 770 | 2024-06-28 |
| 21647 | Scrambled Egg & Turkey Ham Pita 21647 | 30 30 | 720 | 770 | 2024-06-28 |
| 21648 | Turkey Ham & Triple Cheese Toast 21648 | 30 30 | 720 | 770 | 2024-06-28 |
| 21649 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 21649 | 30 30 | 820 | 870 | 2024-06-28 |
| 21650 | Ham & Cheese Croissant 21650 | 30 30 | 720 | 770 | 2024-06-28 |
| 21651 | Sriracha Chicken Whole Wheat Pita 21651 | 30 30 | 780 | 830 | 2024-06-28 |
| 21652 | Blueberry Acai Yogurt Parfait 21652 | 30 30 | 680 | 730 | 2024-06-28 |
| 21653 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 21653 | 30 30 | 680 | 730 | 2024-06-28 |
| 21654 | Caramel Frappuccino® 21654 | 30 30 | 780 | 830 | 2024-06-28 |
| 21655 | Dark Mocha Frappuccino® 21655 | 30 30 | 840 | 890 | 2024-06-28 |
| 21656 | Java Chip Frappuccino® 21656 | 30 30 | 840 | 890 | 2024-06-28 |
| 21657 | Mocha Frappuccino® 21657 | 30 30 | 780 | 830 | 2024-06-28 |
| 21658 | Caramel Macchiato Frappuccino® 21658 | 30 30 | 840 | 890 | 2024-06-28 |
| 21659 | Espresso Frappuccino® 21659 | 30 30 | 780 | 830 | 2024-06-28 |
| 21660 | White Chocolate Mocha Frappuccino® 21660 | 30 30 | 780 | 830 | 2024-06-28 |
| 21661 | Chocolate Chip Cream Frappuccino® 21661 | 30 30 | 840 | 890 | 2024-06-28 |
| 21662 | Hojicha Tea Cream Frappuccino® 21662 | 30 30 | 820 | 870 | 2024-06-28 |
| 21663 | Vanilla Cream Frappuccino® 21663 | 30 30 | 780 | 830 | 2024-06-28 |
| 21664 | Mango Passion Fruit & Hibiscus 21664 | 30 30 | 780 | 830 | 2024-06-28 |
| 21665 | Raspberry Black Currant & Oolong 21665 | 30 30 | 780 | 830 | 2024-06-28 |
| 21666 | Coffee Traveller 21666 | 30 30 | 3600 | 3650 | 2024-06-28 |
| 21667 | Caffè Americano 21667 | 30 30 | 600 | 650 | 2024-06-28 |
| 21668 | Cappuccino 21668 | 30 30 | 740 | 790 | 2024-06-28 |
| 21669 | Caffè Mocha 21669 | 30 30 | 830 | 880 | 2024-06-28 |
| 21670 | Caramel Macchiato 21670 | 30 30 | 840 | 890 | 2024-06-28 |
| 21671 | Espresso 21671 | 30 30 | 450 | 500 | 2024-06-28 |
| 21672 | Caffè Latte 21672 | 30 30 | 740 | 790 | 2024-06-28 |
| 21673 | Oatmilk Latte 21673 | 30 30 | 850 | 900 | 2024-06-28 |
| 21674 | Vanilla Latte 21674 | 30 30 | 830 | 880 | 2024-06-28 |
| 21675 | White Chocolate Mocha 21675 | 30 30 | 830 | 880 | 2024-06-28 |
| 21676 | Flat White 21676 | 30 30 | 840 | 890 | 2024-06-28 |
| 21677 | Ristretto Bianco 21677 | 30 30 | 840 | 890 | 2024-06-28 |
| 21678 | Iced Caffè Americano 21678 | 30 30 | 600 | 650 | 2024-06-28 |
| 21679 | Iced Cappuccino 21679 | 30 30 | 740 | 790 | 2024-06-28 |
| 21680 | Iced Caffè Mocha 21680 | 30 30 | 830 | 880 | 2024-06-28 |
| 21681 | Iced Caramel Macchiato 21681 | 30 30 | 840 | 890 | 2024-06-28 |
| 21682 | Iced Caffè Latte 21682 | 30 30 | 740 | 790 | 2024-06-28 |
| 21683 | Iced Oatmilk Latte 21683 | 30 30 | 850 | 900 | 2024-06-28 |
| 21684 | Iced Vanilla Latte 21684 | 30 30 | 830 | 880 | 2024-06-28 |
| 21685 | Iced White Chocolate Mocha 21685 | 30 30 | 830 | 880 | 2024-06-28 |
| 21686 | Signature Hot Chocolate 21686 | 30 30 | 780 | 830 | 2024-06-28 |
| 21687 | Signature Iced Chocolate 21687 | 30 30 | 780 | 830 | 2024-06-28 |
| 21688 | Carrot Juice 21688 | 30 30 | 550 | 600 | 2024-06-28 |
| 21689 | Cloudy Apple Juice 21689 | 30 30 | 550 | 600 | 2024-06-28 |
| 21690 | Cranberry Red Grapefruit Juice 21690 | 30 30 | 550 | 600 | 2024-06-28 |
| 21691 | Orange Juice 21691 | 30 30 | 550 | 600 | 2024-06-28 |
| 21692 | Evian 21692 | 30 30 | 410 | 460 | 2024-06-28 |
| 21693 | Sparkling Water 21693 | 30 30 | 510 | 560 | 2024-06-28 |
| 21694 | Chai Tea 21694 | 30 30 | 560 | 610 | 2024-06-28 |
| 21695 | Earl Grey Tea 21695 | 30 30 | 560 | 610 | 2024-06-28 |
| 21696 | English Breakfast Tea 21696 | 30 30 | 560 | 610 | 2024-06-28 |
| 21697 | Emperor’s Clouds & Mist™ Tea 21697 | 30 30 | 560 | 610 | 2024-06-28 |
| 21698 | Mint Blend Tea 21698 | 30 30 | 560 | 610 | 2024-06-28 |
| 21699 | Chamomile Tea 21699 | 30 30 | 560 | 610 | 2024-06-28 |
| 21700 | Pure Matcha Latte 21700 | 30 30 | 810 | 860 | 2024-06-28 |
| 21701 | Chai Tea Latte 21701 | 30 30 | 740 | 790 | 2024-06-28 |
| 21702 | Earl Grey Tea Latte 21702 | 30 30 | 740 | 790 | 2024-06-28 |
| 21703 | English Breakfast Tea Latte 21703 | 30 30 | 740 | 790 | 2024-06-28 |
| 21704 | Hojicha Tea Latte 21704 | 30 30 | 810 | 860 | 2024-06-28 |
| 21705 | Zen Clouds Oolong Tea 21705 | 30 30 | 560 | 610 | 2024-06-28 |
| 21706 | Zen Clouds Oolong with Ruby Grapefruit and Honey 21706 | 30 30 | 690 | 740 | 2024-06-28 |
| 21707 | Youthberry™ Tea 21707 | 30 30 | 560 | 610 | 2024-06-28 |
| 21708 | Iced Shaken Black Tea Lemonade 21708 | 30 30 | 670 | 720 | 2024-06-28 |
| 21709 | Iced Shaken Strawberry Black Tea Lemonade 21709 | 30 30 | 690 | 740 | 2024-06-28 |
| 21710 | Iced Shaken Hibiscus Tea Lemonade 21710 | 30 30 | 670 | 720 | 2024-06-28 |
| 21711 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 21711 | 30 30 | 790 | 840 | 2024-06-28 |
| 21712 | Iced Pure Matcha Latte 21712 | 30 30 | 810 | 860 | 2024-06-28 |
| 21713 | Iced Chai Tea Latte 21713 | 30 30 | 740 | 790 | 2024-06-28 |
| 21714 | Iced Black Tea Latte 21714 | 30 30 | 740 | 790 | 2024-06-28 |
| 21715 | Iced Hojicha Tea Latte 21715 | 30 30 | 810 | 860 | 2024-06-28 |
| 21716 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 21716 | 30 30 | 690 | 740 | 2024-06-28 |
| 21717 | Iced Shaken Zen Clouds Oolong Lemonade 21717 | 30 30 | 670 | 720 | 2024-06-28 |
| 21718 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 21718 | 30 30 | 690 | 740 | 2024-06-28 |
| 21719 | Origami Pike Place® Roast 21719 | 30 30 | 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");