item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
249 rows where store_id = 135
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
- 135 · 249 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 4612 | Bagel 4612 | 135 135 | 400 | 430 | 2024-06-28 |
| 4613 | Cookie Crumble Cheesecake 4613 | 135 135 | 720 | 770 | 2024-06-28 |
| 4614 | Good Ol' NY Cheesecake 4614 | 135 135 | 720 | 770 | 2024-06-28 |
| 4615 | Signature Chocolate Cake 4615 | 135 135 | 720 | 770 | 2024-06-28 |
| 4616 | Starbucks® Coffee Tiramisu Cake 4616 | 135 135 | 750 | 800 | 2024-06-28 |
| 4617 | Strawberry Shortcake 4617 | 135 135 | 720 | 770 | 2024-06-28 |
| 4618 | Chocolate Chunk Monster Cookie 4618 | 135 135 | 390 | 440 | 2024-06-28 |
| 4619 | Banana Walnut Muffin 4619 | 135 135 | 450 | 500 | 2024-06-28 |
| 4620 | Blueberry Crumble Muffin 4620 | 135 135 | 450 | 500 | 2024-06-28 |
| 4621 | Chocolate Crumble Muffin 4621 | 135 135 | 450 | 500 | 2024-06-28 |
| 4622 | Pancakes 4622 | 135 135 | 550 | 600 | 2024-06-28 |
| 4623 | Almond Croissant 4623 | 135 135 | 470 | 520 | 2024-06-28 |
| 4624 | Buttery Croissant 4624 | 135 135 | 400 | 430 | 2024-06-28 |
| 4625 | Chocolate Croissant 4625 | 135 135 | 440 | 490 | 2024-06-28 |
| 4626 | Creamy Chicken Foldover 4626 | 135 135 | 550 | 600 | 2024-06-28 |
| 4627 | Sausage Roll 4627 | 135 135 | 550 | 600 | 2024-06-28 |
| 4628 | Buttery Scone 4628 | 135 135 | 400 | 430 | 2024-06-28 |
| 4629 | Country Chicken Pie 4629 | 135 135 | 690 | 740 | 2024-06-28 |
| 4630 | Deep Dish Beef Pie 4630 | 135 135 | 690 | 740 | 2024-06-28 |
| 4631 | Spinach & Mushroom Quiche 4631 | 135 135 | 690 | 740 | 2024-06-28 |
| 4632 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 4632 | 135 135 | 390 | 420 | 2024-06-28 |
| 4633 | Mixed Nuts 4633 | 135 135 | 490 | 540 | 2024-06-28 |
| 4634 | Caramel Waffles 4634 | 135 135 | 390 | 420 | 2024-06-28 |
| 4635 | Chicken Ham & Cheese Panwich 4635 | 135 135 | 690 | 740 | 2024-06-28 |
| 4636 | Egg Mayo & Cheese Multigrain Croissant 4636 | 135 135 | 690 | 740 | 2024-06-28 |
| 4637 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 4637 | 135 135 | 690 | 740 | 2024-06-28 |
| 4638 | Rosemary Chicken & Emmental Cheese Croissant 4638 | 135 135 | 690 | 740 | 2024-06-28 |
| 4639 | Scrambled Egg & Turkey Ham Pita 4639 | 135 135 | 690 | 740 | 2024-06-28 |
| 4640 | Turkey Ham & Triple Cheese Toast 4640 | 135 135 | 690 | 740 | 2024-06-28 |
| 4641 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 4641 | 135 135 | 790 | 840 | 2024-06-28 |
| 4642 | Ham & Cheese Croissant 4642 | 135 135 | 690 | 740 | 2024-06-28 |
| 4643 | Sriracha Chicken Whole Wheat Pita 4643 | 135 135 | 750 | 800 | 2024-06-28 |
| 4644 | Blueberry Acai Yogurt Parfait 4644 | 135 135 | 650 | 700 | 2024-06-28 |
| 4645 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 4645 | 135 135 | 650 | 700 | 2024-06-28 |
| 4646 | Caramel Frappuccino® 4646 | 135 135 | 720 | 770 | 2024-06-28 |
| 4647 | Dark Mocha Frappuccino® 4647 | 135 135 | 780 | 830 | 2024-06-28 |
| 4648 | Java Chip Frappuccino® 4648 | 135 135 | 780 | 830 | 2024-06-28 |
| 4649 | Mocha Frappuccino® 4649 | 135 135 | 720 | 770 | 2024-06-28 |
| 4650 | Caramel Macchiato Frappuccino® 4650 | 135 135 | 780 | 830 | 2024-06-28 |
| 4651 | Espresso Frappuccino® 4651 | 135 135 | 720 | 770 | 2024-06-28 |
| 4652 | White Chocolate Mocha Frappuccino® 4652 | 135 135 | 720 | 770 | 2024-06-28 |
| 4653 | Chocolate Chip Cream Frappuccino® 4653 | 135 135 | 780 | 830 | 2024-06-28 |
| 4654 | Hojicha Tea Cream Frappuccino® 4654 | 135 135 | 760 | 810 | 2024-06-28 |
| 4655 | Vanilla Cream Frappuccino® 4655 | 135 135 | 720 | 770 | 2024-06-28 |
| 4656 | Mango Passion Fruit & Hibiscus 4656 | 135 135 | 720 | 770 | 2024-06-28 |
| 4657 | Raspberry Black Currant & Oolong 4657 | 135 135 | 720 | 770 | 2024-06-28 |
| 4658 | Coffee Traveller 4658 | 135 135 | 3120 | 3170 | 2024-06-28 |
| 4659 | Caffè Americano 4659 | 135 135 | 540 | 590 | 2024-06-28 |
| 4660 | Cappuccino 4660 | 135 135 | 680 | 730 | 2024-06-28 |
| 4661 | Caffè Mocha 4661 | 135 135 | 750 | 800 | 2024-06-28 |
| 4662 | Caramel Macchiato 4662 | 135 135 | 760 | 810 | 2024-06-28 |
| 4663 | Espresso 4663 | 135 135 | 390 | 440 | 2024-06-28 |
| 4664 | Caffè Latte 4664 | 135 135 | 680 | 730 | 2024-06-28 |
| 4665 | Oatmilk Latte 4665 | 135 135 | 760 | 810 | 2024-06-28 |
| 4666 | Vanilla Latte 4666 | 135 135 | 750 | 800 | 2024-06-28 |
| 4667 | White Chocolate Mocha 4667 | 135 135 | 750 | 800 | 2024-06-28 |
| 4668 | Flat White 4668 | 135 135 | 760 | 810 | 2024-06-28 |
| 4669 | Ristretto Bianco 4669 | 135 135 | 760 | 810 | 2024-06-28 |
| 4670 | Iced Caffè Americano 4670 | 135 135 | 540 | 590 | 2024-06-28 |
| 4671 | Iced Cappuccino 4671 | 135 135 | 680 | 730 | 2024-06-28 |
| 4672 | Iced Caffè Mocha 4672 | 135 135 | 750 | 800 | 2024-06-28 |
| 4673 | Iced Caramel Macchiato 4673 | 135 135 | 760 | 810 | 2024-06-28 |
| 4674 | Iced Caffè Latte 4674 | 135 135 | 680 | 730 | 2024-06-28 |
| 4675 | Iced Oatmilk Latte 4675 | 135 135 | 760 | 810 | 2024-06-28 |
| 4676 | Iced Vanilla Latte 4676 | 135 135 | 750 | 800 | 2024-06-28 |
| 4677 | Iced White Chocolate Mocha 4677 | 135 135 | 750 | 800 | 2024-06-28 |
| 4678 | Signature Hot Chocolate 4678 | 135 135 | 720 | 770 | 2024-06-28 |
| 4679 | Signature Iced Chocolate 4679 | 135 135 | 720 | 770 | 2024-06-28 |
| 4680 | Carrot Juice 4680 | 135 135 | 490 | 540 | 2024-06-28 |
| 4681 | Cloudy Apple Juice 4681 | 135 135 | 490 | 540 | 2024-06-28 |
| 4682 | Cranberry Red Grapefruit Juice 4682 | 135 135 | 490 | 540 | 2024-06-28 |
| 4683 | Orange Juice 4683 | 135 135 | 490 | 540 | 2024-06-28 |
| 4684 | Evian 4684 | 135 135 | 350 | 400 | 2024-06-28 |
| 4685 | Sparkling Water 4685 | 135 135 | 450 | 500 | 2024-06-28 |
| 4686 | Chai Tea 4686 | 135 135 | 500 | 550 | 2024-06-28 |
| 4687 | Earl Grey Tea 4687 | 135 135 | 500 | 550 | 2024-06-28 |
| 4688 | English Breakfast Tea 4688 | 135 135 | 500 | 550 | 2024-06-28 |
| 4689 | Emperor’s Clouds & Mist™ Tea 4689 | 135 135 | 500 | 550 | 2024-06-28 |
| 4690 | Mint Blend Tea 4690 | 135 135 | 500 | 550 | 2024-06-28 |
| 4691 | Chamomile Tea 4691 | 135 135 | 500 | 550 | 2024-06-28 |
| 4692 | Pure Matcha Latte 4692 | 135 135 | 740 | 790 | 2024-06-28 |
| 4693 | Chai Tea Latte 4693 | 135 135 | 680 | 730 | 2024-06-28 |
| 4694 | Earl Grey Tea Latte 4694 | 135 135 | 680 | 730 | 2024-06-28 |
| 4695 | English Breakfast Tea Latte 4695 | 135 135 | 680 | 730 | 2024-06-28 |
| 4696 | Hojicha Tea Latte 4696 | 135 135 | 740 | 790 | 2024-06-28 |
| 4697 | Zen Clouds Oolong Tea 4697 | 135 135 | 500 | 550 | 2024-06-28 |
| 4698 | Zen Clouds Oolong with Ruby Grapefruit and Honey 4698 | 135 135 | 630 | 680 | 2024-06-28 |
| 4699 | Youthberry™ Tea 4699 | 135 135 | 500 | 550 | 2024-06-28 |
| 4700 | Iced Shaken Black Tea Lemonade 4700 | 135 135 | 610 | 660 | 2024-06-28 |
| 4701 | Iced Shaken Strawberry Black Tea Lemonade 4701 | 135 135 | 630 | 680 | 2024-06-28 |
| 4702 | Iced Shaken Hibiscus Tea Lemonade 4702 | 135 135 | 610 | 660 | 2024-06-28 |
| 4703 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 4703 | 135 135 | 730 | 780 | 2024-06-28 |
| 4704 | Iced Pure Matcha Latte 4704 | 135 135 | 740 | 790 | 2024-06-28 |
| 4705 | Iced Chai Tea Latte 4705 | 135 135 | 680 | 730 | 2024-06-28 |
| 4706 | Iced Black Tea Latte 4706 | 135 135 | 680 | 730 | 2024-06-28 |
| 4707 | Iced Hojicha Tea Latte 4707 | 135 135 | 740 | 790 | 2024-06-28 |
| 4708 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 4708 | 135 135 | 630 | 680 | 2024-06-28 |
| 4709 | Iced Shaken Zen Clouds Oolong Lemonade 4709 | 135 135 | 610 | 660 | 2024-06-28 |
| 4710 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 4710 | 135 135 | 630 | 680 | 2024-06-28 |
| 4711 | Origami Pike Place® Roast 4711 | 135 135 | 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");