item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
249 rows where store_id = 110
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 13
- 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
- 2024-11-17 1
store_id 1
- 110 · 249 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 8620 | Bagel 8620 | 110 110 | 400 | 430 | 2024-06-28 |
| 8621 | Cookie Crumble Cheesecake 8621 | 110 110 | 720 | 770 | 2024-06-28 |
| 8622 | Good Ol' NY Cheesecake 8622 | 110 110 | 720 | 770 | 2024-06-28 |
| 8623 | Signature Chocolate Cake 8623 | 110 110 | 720 | 770 | 2024-06-28 |
| 8624 | Starbucks® Coffee Tiramisu Cake 8624 | 110 110 | 750 | 800 | 2024-06-28 |
| 8625 | Strawberry Shortcake 8625 | 110 110 | 720 | 770 | 2024-06-28 |
| 8626 | Chocolate Chunk Monster Cookie 8626 | 110 110 | 390 | 440 | 2024-06-28 |
| 8627 | Banana Walnut Muffin 8627 | 110 110 | 450 | 500 | 2024-06-28 |
| 8628 | Blueberry Crumble Muffin 8628 | 110 110 | 450 | 500 | 2024-06-28 |
| 8629 | Chocolate Crumble Muffin 8629 | 110 110 | 450 | 500 | 2024-06-28 |
| 8630 | Pancakes 8630 | 110 110 | 550 | 600 | 2024-06-28 |
| 8631 | Almond Croissant 8631 | 110 110 | 470 | 520 | 2024-06-28 |
| 8632 | Buttery Croissant 8632 | 110 110 | 400 | 430 | 2024-06-28 |
| 8633 | Chocolate Croissant 8633 | 110 110 | 440 | 490 | 2024-06-28 |
| 8634 | Creamy Chicken Foldover 8634 | 110 110 | 550 | 600 | 2024-06-28 |
| 8635 | Sausage Roll 8635 | 110 110 | 550 | 600 | 2024-06-28 |
| 8636 | Buttery Scone 8636 | 110 110 | 400 | 430 | 2024-06-28 |
| 8637 | Country Chicken Pie 8637 | 110 110 | 690 | 740 | 2024-06-28 |
| 8638 | Deep Dish Beef Pie 8638 | 110 110 | 690 | 740 | 2024-06-28 |
| 8639 | Spinach & Mushroom Quiche 8639 | 110 110 | 690 | 740 | 2024-06-28 |
| 8640 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 8640 | 110 110 | 390 | 420 | 2024-06-28 |
| 8641 | Mixed Nuts 8641 | 110 110 | 490 | 540 | 2024-06-28 |
| 8642 | Caramel Waffles 8642 | 110 110 | 390 | 420 | 2024-06-28 |
| 8643 | Chicken Ham & Cheese Panwich 8643 | 110 110 | 690 | 740 | 2024-06-28 |
| 8644 | Egg Mayo & Cheese Multigrain Croissant 8644 | 110 110 | 690 | 740 | 2024-06-28 |
| 8645 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 8645 | 110 110 | 690 | 740 | 2024-06-28 |
| 8646 | Rosemary Chicken & Emmental Cheese Croissant 8646 | 110 110 | 690 | 740 | 2024-06-28 |
| 8647 | Scrambled Egg & Turkey Ham Pita 8647 | 110 110 | 690 | 740 | 2024-06-28 |
| 8648 | Turkey Ham & Triple Cheese Toast 8648 | 110 110 | 690 | 740 | 2024-06-28 |
| 8649 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 8649 | 110 110 | 790 | 840 | 2024-06-28 |
| 8650 | Ham & Cheese Croissant 8650 | 110 110 | 690 | 740 | 2024-06-28 |
| 8651 | Sriracha Chicken Whole Wheat Pita 8651 | 110 110 | 750 | 800 | 2024-06-28 |
| 8652 | Blueberry Acai Yogurt Parfait 8652 | 110 110 | 650 | 700 | 2024-06-28 |
| 8653 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 8653 | 110 110 | 650 | 700 | 2024-06-28 |
| 8654 | Caramel Frappuccino® 8654 | 110 110 | 720 | 770 | 2024-06-28 |
| 8655 | Dark Mocha Frappuccino® 8655 | 110 110 | 780 | 830 | 2024-06-28 |
| 8656 | Java Chip Frappuccino® 8656 | 110 110 | 780 | 830 | 2024-06-28 |
| 8657 | Mocha Frappuccino® 8657 | 110 110 | 720 | 770 | 2024-06-28 |
| 8658 | Caramel Macchiato Frappuccino® 8658 | 110 110 | 780 | 830 | 2024-06-28 |
| 8659 | Espresso Frappuccino® 8659 | 110 110 | 720 | 770 | 2024-06-28 |
| 8660 | White Chocolate Mocha Frappuccino® 8660 | 110 110 | 720 | 770 | 2024-06-28 |
| 8661 | Chocolate Chip Cream Frappuccino® 8661 | 110 110 | 780 | 830 | 2024-06-28 |
| 8662 | Hojicha Tea Cream Frappuccino® 8662 | 110 110 | 760 | 810 | 2024-06-28 |
| 8663 | Vanilla Cream Frappuccino® 8663 | 110 110 | 720 | 770 | 2024-06-28 |
| 8664 | Mango Passion Fruit & Hibiscus 8664 | 110 110 | 720 | 770 | 2024-06-28 |
| 8665 | Raspberry Black Currant & Oolong 8665 | 110 110 | 720 | 770 | 2024-06-28 |
| 8666 | Coffee Traveller 8666 | 110 110 | 3120 | 3170 | 2024-06-28 |
| 8667 | Caffè Americano 8667 | 110 110 | 540 | 590 | 2024-06-28 |
| 8668 | Cappuccino 8668 | 110 110 | 680 | 730 | 2024-06-28 |
| 8669 | Caffè Mocha 8669 | 110 110 | 750 | 800 | 2024-06-28 |
| 8670 | Caramel Macchiato 8670 | 110 110 | 760 | 810 | 2024-06-28 |
| 8671 | Espresso 8671 | 110 110 | 390 | 440 | 2024-06-28 |
| 8672 | Caffè Latte 8672 | 110 110 | 680 | 730 | 2024-06-28 |
| 8673 | Oatmilk Latte 8673 | 110 110 | 760 | 810 | 2024-06-28 |
| 8674 | Vanilla Latte 8674 | 110 110 | 750 | 800 | 2024-06-28 |
| 8675 | White Chocolate Mocha 8675 | 110 110 | 750 | 800 | 2024-06-28 |
| 8676 | Flat White 8676 | 110 110 | 760 | 810 | 2024-06-28 |
| 8677 | Ristretto Bianco 8677 | 110 110 | 760 | 810 | 2024-06-28 |
| 8678 | Iced Caffè Americano 8678 | 110 110 | 540 | 590 | 2024-06-28 |
| 8679 | Iced Cappuccino 8679 | 110 110 | 680 | 730 | 2024-06-28 |
| 8680 | Iced Caffè Mocha 8680 | 110 110 | 750 | 800 | 2024-06-28 |
| 8681 | Iced Caramel Macchiato 8681 | 110 110 | 760 | 810 | 2024-06-28 |
| 8682 | Iced Caffè Latte 8682 | 110 110 | 680 | 730 | 2024-06-28 |
| 8683 | Iced Oatmilk Latte 8683 | 110 110 | 760 | 810 | 2024-06-28 |
| 8684 | Iced Vanilla Latte 8684 | 110 110 | 750 | 800 | 2024-06-28 |
| 8685 | Iced White Chocolate Mocha 8685 | 110 110 | 750 | 800 | 2024-06-28 |
| 8686 | Signature Hot Chocolate 8686 | 110 110 | 720 | 770 | 2024-06-28 |
| 8687 | Signature Iced Chocolate 8687 | 110 110 | 720 | 770 | 2024-06-28 |
| 8688 | Carrot Juice 8688 | 110 110 | 490 | 540 | 2024-06-28 |
| 8689 | Cloudy Apple Juice 8689 | 110 110 | 490 | 540 | 2024-06-28 |
| 8690 | Cranberry Red Grapefruit Juice 8690 | 110 110 | 490 | 540 | 2024-06-28 |
| 8691 | Orange Juice 8691 | 110 110 | 490 | 540 | 2024-06-28 |
| 8692 | Evian 8692 | 110 110 | 350 | 400 | 2024-06-28 |
| 8693 | Sparkling Water 8693 | 110 110 | 450 | 500 | 2024-06-28 |
| 8694 | Chai Tea 8694 | 110 110 | 500 | 550 | 2024-06-28 |
| 8695 | Earl Grey Tea 8695 | 110 110 | 500 | 550 | 2024-06-28 |
| 8696 | English Breakfast Tea 8696 | 110 110 | 500 | 550 | 2024-06-28 |
| 8697 | Emperor’s Clouds & Mist™ Tea 8697 | 110 110 | 500 | 550 | 2024-06-28 |
| 8698 | Mint Blend Tea 8698 | 110 110 | 500 | 550 | 2024-06-28 |
| 8699 | Chamomile Tea 8699 | 110 110 | 500 | 550 | 2024-06-28 |
| 8700 | Pure Matcha Latte 8700 | 110 110 | 740 | 790 | 2024-06-28 |
| 8701 | Chai Tea Latte 8701 | 110 110 | 680 | 730 | 2024-06-28 |
| 8702 | Earl Grey Tea Latte 8702 | 110 110 | 680 | 730 | 2024-06-28 |
| 8703 | English Breakfast Tea Latte 8703 | 110 110 | 680 | 730 | 2024-06-28 |
| 8704 | Hojicha Tea Latte 8704 | 110 110 | 740 | 790 | 2024-06-28 |
| 8705 | Zen Clouds Oolong Tea 8705 | 110 110 | 500 | 550 | 2024-06-28 |
| 8706 | Zen Clouds Oolong with Ruby Grapefruit and Honey 8706 | 110 110 | 630 | 680 | 2024-06-28 |
| 8707 | Youthberry™ Tea 8707 | 110 110 | 500 | 550 | 2024-06-28 |
| 8708 | Iced Shaken Black Tea Lemonade 8708 | 110 110 | 610 | 660 | 2024-06-28 |
| 8709 | Iced Shaken Strawberry Black Tea Lemonade 8709 | 110 110 | 630 | 680 | 2024-06-28 |
| 8710 | Iced Shaken Hibiscus Tea Lemonade 8710 | 110 110 | 610 | 660 | 2024-06-28 |
| 8711 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 8711 | 110 110 | 730 | 780 | 2024-06-28 |
| 8712 | Iced Pure Matcha Latte 8712 | 110 110 | 740 | 790 | 2024-06-28 |
| 8713 | Iced Chai Tea Latte 8713 | 110 110 | 680 | 730 | 2024-06-28 |
| 8714 | Iced Black Tea Latte 8714 | 110 110 | 680 | 730 | 2024-06-28 |
| 8715 | Iced Hojicha Tea Latte 8715 | 110 110 | 740 | 790 | 2024-06-28 |
| 8716 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 8716 | 110 110 | 630 | 680 | 2024-06-28 |
| 8717 | Iced Shaken Zen Clouds Oolong Lemonade 8717 | 110 110 | 610 | 660 | 2024-06-28 |
| 8718 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 8718 | 110 110 | 630 | 680 | 2024-06-28 |
| 8719 | Origami Pike Place® Roast 8719 | 110 110 | 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");