item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 4
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
- 4 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 549 | Bagel 549 | 4 4 | 400 | 430 | 2024-06-28 |
| 550 | Cookie Crumble Cheesecake 550 | 4 4 | 720 | 770 | 2024-06-28 |
| 551 | Good Ol' NY Cheesecake 551 | 4 4 | 720 | 770 | 2024-06-28 |
| 552 | Signature Chocolate Cake 552 | 4 4 | 720 | 770 | 2024-06-28 |
| 553 | Starbucks® Coffee Tiramisu Cake 553 | 4 4 | 750 | 800 | 2024-06-28 |
| 554 | Strawberry Shortcake 554 | 4 4 | 720 | 770 | 2024-06-28 |
| 555 | Chocolate Chunk Monster Cookie 555 | 4 4 | 390 | 440 | 2024-06-28 |
| 556 | Banana Walnut Muffin 556 | 4 4 | 450 | 500 | 2024-06-28 |
| 557 | Blueberry Crumble Muffin 557 | 4 4 | 450 | 500 | 2024-06-28 |
| 558 | Chocolate Crumble Muffin 558 | 4 4 | 450 | 500 | 2024-06-28 |
| 559 | Pancakes 559 | 4 4 | 550 | 600 | 2024-06-28 |
| 560 | Almond Croissant 560 | 4 4 | 470 | 520 | 2024-06-28 |
| 561 | Buttery Croissant 561 | 4 4 | 400 | 430 | 2024-06-28 |
| 562 | Chocolate Croissant 562 | 4 4 | 440 | 490 | 2024-06-28 |
| 563 | Creamy Chicken Foldover 563 | 4 4 | 550 | 600 | 2024-06-28 |
| 564 | Sausage Roll 564 | 4 4 | 550 | 600 | 2024-06-28 |
| 565 | Buttery Scone 565 | 4 4 | 400 | 430 | 2024-06-28 |
| 566 | Country Chicken Pie 566 | 4 4 | 690 | 740 | 2024-06-28 |
| 567 | Deep Dish Beef Pie 567 | 4 4 | 690 | 740 | 2024-06-28 |
| 568 | Spinach & Mushroom Quiche 568 | 4 4 | 690 | 740 | 2024-06-28 |
| 569 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 569 | 4 4 | 390 | 420 | 2024-06-28 |
| 570 | Mixed Nuts 570 | 4 4 | 490 | 540 | 2024-06-28 |
| 571 | Caramel Waffles 571 | 4 4 | 390 | 420 | 2024-06-28 |
| 572 | Chicken Ham & Cheese Panwich 572 | 4 4 | 690 | 740 | 2024-06-28 |
| 573 | Egg Mayo & Cheese Multigrain Croissant 573 | 4 4 | 690 | 740 | 2024-06-28 |
| 574 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 574 | 4 4 | 690 | 740 | 2024-06-28 |
| 575 | Rosemary Chicken & Emmental Cheese Croissant 575 | 4 4 | 690 | 740 | 2024-06-28 |
| 576 | Scrambled Egg & Turkey Ham Pita 576 | 4 4 | 690 | 740 | 2024-06-28 |
| 577 | Turkey Ham & Triple Cheese Toast 577 | 4 4 | 690 | 740 | 2024-06-28 |
| 578 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 578 | 4 4 | 790 | 840 | 2024-06-28 |
| 579 | Ham & Cheese Croissant 579 | 4 4 | 690 | 740 | 2024-06-28 |
| 580 | Sriracha Chicken Whole Wheat Pita 580 | 4 4 | 750 | 800 | 2024-06-28 |
| 581 | Blueberry Acai Yogurt Parfait 581 | 4 4 | 650 | 700 | 2024-06-28 |
| 582 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 582 | 4 4 | 650 | 700 | 2024-06-28 |
| 583 | Caramel Frappuccino® 583 | 4 4 | 720 | 770 | 2024-06-28 |
| 584 | Dark Mocha Frappuccino® 584 | 4 4 | 780 | 830 | 2024-06-28 |
| 585 | Java Chip Frappuccino® 585 | 4 4 | 780 | 830 | 2024-06-28 |
| 586 | Mocha Frappuccino® 586 | 4 4 | 720 | 770 | 2024-06-28 |
| 587 | Caramel Macchiato Frappuccino® 587 | 4 4 | 780 | 830 | 2024-06-28 |
| 588 | Espresso Frappuccino® 588 | 4 4 | 720 | 770 | 2024-06-28 |
| 589 | White Chocolate Mocha Frappuccino® 589 | 4 4 | 720 | 770 | 2024-06-28 |
| 590 | Chocolate Chip Cream Frappuccino® 590 | 4 4 | 780 | 830 | 2024-06-28 |
| 591 | Hojicha Tea Cream Frappuccino® 591 | 4 4 | 760 | 810 | 2024-06-28 |
| 592 | Vanilla Cream Frappuccino® 592 | 4 4 | 720 | 770 | 2024-06-28 |
| 593 | Mango Passion Fruit & Hibiscus 593 | 4 4 | 720 | 770 | 2024-06-28 |
| 594 | Raspberry Black Currant & Oolong 594 | 4 4 | 720 | 770 | 2024-06-28 |
| 595 | Coffee Traveller 595 | 4 4 | 3120 | 3170 | 2024-06-28 |
| 596 | Caffè Americano 596 | 4 4 | 540 | 590 | 2024-06-28 |
| 597 | Cappuccino 597 | 4 4 | 680 | 730 | 2024-06-28 |
| 598 | Caffè Mocha 598 | 4 4 | 750 | 800 | 2024-06-28 |
| 599 | Caramel Macchiato 599 | 4 4 | 760 | 810 | 2024-06-28 |
| 600 | Espresso 600 | 4 4 | 390 | 440 | 2024-06-28 |
| 601 | Caffè Latte 601 | 4 4 | 680 | 730 | 2024-06-28 |
| 602 | Oatmilk Latte 602 | 4 4 | 760 | 810 | 2024-06-28 |
| 603 | Vanilla Latte 603 | 4 4 | 750 | 800 | 2024-06-28 |
| 604 | White Chocolate Mocha 604 | 4 4 | 750 | 800 | 2024-06-28 |
| 605 | Flat White 605 | 4 4 | 760 | 810 | 2024-06-28 |
| 606 | Ristretto Bianco 606 | 4 4 | 760 | 810 | 2024-06-28 |
| 607 | Iced Caffè Americano 607 | 4 4 | 540 | 590 | 2024-06-28 |
| 608 | Iced Cappuccino 608 | 4 4 | 680 | 730 | 2024-06-28 |
| 609 | Iced Caffè Mocha 609 | 4 4 | 750 | 800 | 2024-06-28 |
| 610 | Iced Caramel Macchiato 610 | 4 4 | 760 | 810 | 2024-06-28 |
| 611 | Iced Caffè Latte 611 | 4 4 | 680 | 730 | 2024-06-28 |
| 612 | Iced Oatmilk Latte 612 | 4 4 | 760 | 810 | 2024-06-28 |
| 613 | Iced Vanilla Latte 613 | 4 4 | 750 | 800 | 2024-06-28 |
| 614 | Iced White Chocolate Mocha 614 | 4 4 | 750 | 800 | 2024-06-28 |
| 615 | Signature Hot Chocolate 615 | 4 4 | 720 | 770 | 2024-06-28 |
| 616 | Signature Iced Chocolate 616 | 4 4 | 720 | 770 | 2024-06-28 |
| 617 | Carrot Juice 617 | 4 4 | 490 | 540 | 2024-06-28 |
| 618 | Cloudy Apple Juice 618 | 4 4 | 490 | 540 | 2024-06-28 |
| 619 | Cranberry Red Grapefruit Juice 619 | 4 4 | 490 | 540 | 2024-06-28 |
| 620 | Orange Juice 620 | 4 4 | 490 | 540 | 2024-06-28 |
| 621 | Evian 621 | 4 4 | 350 | 400 | 2024-06-28 |
| 622 | Sparkling Water 622 | 4 4 | 450 | 500 | 2024-06-28 |
| 623 | Chai Tea 623 | 4 4 | 500 | 550 | 2024-06-28 |
| 624 | Earl Grey Tea 624 | 4 4 | 500 | 550 | 2024-06-28 |
| 625 | English Breakfast Tea 625 | 4 4 | 500 | 550 | 2024-06-28 |
| 626 | Emperor’s Clouds & Mist™ Tea 626 | 4 4 | 500 | 550 | 2024-06-28 |
| 627 | Mint Blend Tea 627 | 4 4 | 500 | 550 | 2024-06-28 |
| 628 | Chamomile Tea 628 | 4 4 | 500 | 550 | 2024-06-28 |
| 629 | Pure Matcha Latte 629 | 4 4 | 740 | 790 | 2024-06-28 |
| 630 | Chai Tea Latte 630 | 4 4 | 680 | 730 | 2024-06-28 |
| 631 | Earl Grey Tea Latte 631 | 4 4 | 680 | 730 | 2024-06-28 |
| 632 | English Breakfast Tea Latte 632 | 4 4 | 680 | 730 | 2024-06-28 |
| 633 | Hojicha Tea Latte 633 | 4 4 | 740 | 790 | 2024-06-28 |
| 634 | Zen Clouds Oolong Tea 634 | 4 4 | 500 | 550 | 2024-06-28 |
| 635 | Zen Clouds Oolong with Ruby Grapefruit and Honey 635 | 4 4 | 630 | 680 | 2024-06-28 |
| 636 | Youthberry™ Tea 636 | 4 4 | 500 | 550 | 2024-06-28 |
| 637 | Iced Shaken Black Tea Lemonade 637 | 4 4 | 610 | 660 | 2024-06-28 |
| 638 | Iced Shaken Strawberry Black Tea Lemonade 638 | 4 4 | 630 | 680 | 2024-06-28 |
| 639 | Iced Shaken Hibiscus Tea Lemonade 639 | 4 4 | 610 | 660 | 2024-06-28 |
| 640 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 640 | 4 4 | 730 | 780 | 2024-06-28 |
| 641 | Iced Pure Matcha Latte 641 | 4 4 | 740 | 790 | 2024-06-28 |
| 642 | Iced Chai Tea Latte 642 | 4 4 | 680 | 730 | 2024-06-28 |
| 643 | Iced Black Tea Latte 643 | 4 4 | 680 | 730 | 2024-06-28 |
| 644 | Iced Hojicha Tea Latte 644 | 4 4 | 740 | 790 | 2024-06-28 |
| 645 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 645 | 4 4 | 630 | 680 | 2024-06-28 |
| 646 | Iced Shaken Zen Clouds Oolong Lemonade 646 | 4 4 | 610 | 660 | 2024-06-28 |
| 647 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 647 | 4 4 | 630 | 680 | 2024-06-28 |
| 648 | Origami Pike Place® Roast 648 | 4 4 | 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");