item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 66
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
- 66 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 15585 | Bagel 15585 | 66 66 | 400 | 430 | 2024-06-28 |
| 15586 | Cookie Crumble Cheesecake 15586 | 66 66 | 720 | 770 | 2024-06-28 |
| 15587 | Good Ol' NY Cheesecake 15587 | 66 66 | 720 | 770 | 2024-06-28 |
| 15588 | Signature Chocolate Cake 15588 | 66 66 | 720 | 770 | 2024-06-28 |
| 15589 | Starbucks® Coffee Tiramisu Cake 15589 | 66 66 | 750 | 800 | 2024-06-28 |
| 15590 | Strawberry Shortcake 15590 | 66 66 | 720 | 770 | 2024-06-28 |
| 15591 | Chocolate Chunk Monster Cookie 15591 | 66 66 | 390 | 440 | 2024-06-28 |
| 15592 | Banana Walnut Muffin 15592 | 66 66 | 450 | 500 | 2024-06-28 |
| 15593 | Blueberry Crumble Muffin 15593 | 66 66 | 450 | 500 | 2024-06-28 |
| 15594 | Chocolate Crumble Muffin 15594 | 66 66 | 450 | 500 | 2024-06-28 |
| 15595 | Pancakes 15595 | 66 66 | 550 | 600 | 2024-06-28 |
| 15596 | Almond Croissant 15596 | 66 66 | 470 | 520 | 2024-06-28 |
| 15597 | Buttery Croissant 15597 | 66 66 | 400 | 430 | 2024-06-28 |
| 15598 | Chocolate Croissant 15598 | 66 66 | 440 | 490 | 2024-06-28 |
| 15599 | Creamy Chicken Foldover 15599 | 66 66 | 550 | 600 | 2024-06-28 |
| 15600 | Sausage Roll 15600 | 66 66 | 550 | 600 | 2024-06-28 |
| 15601 | Buttery Scone 15601 | 66 66 | 400 | 430 | 2024-06-28 |
| 15602 | Country Chicken Pie 15602 | 66 66 | 690 | 740 | 2024-06-28 |
| 15603 | Deep Dish Beef Pie 15603 | 66 66 | 690 | 740 | 2024-06-28 |
| 15604 | Spinach & Mushroom Quiche 15604 | 66 66 | 690 | 740 | 2024-06-28 |
| 15605 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 15605 | 66 66 | 390 | 420 | 2024-06-28 |
| 15606 | Mixed Nuts 15606 | 66 66 | 490 | 540 | 2024-06-28 |
| 15607 | Caramel Waffles 15607 | 66 66 | 390 | 420 | 2024-06-28 |
| 15608 | Chicken Ham & Cheese Panwich 15608 | 66 66 | 690 | 740 | 2024-06-28 |
| 15609 | Egg Mayo & Cheese Multigrain Croissant 15609 | 66 66 | 690 | 740 | 2024-06-28 |
| 15610 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 15610 | 66 66 | 690 | 740 | 2024-06-28 |
| 15611 | Rosemary Chicken & Emmental Cheese Croissant 15611 | 66 66 | 690 | 740 | 2024-06-28 |
| 15612 | Scrambled Egg & Turkey Ham Pita 15612 | 66 66 | 690 | 740 | 2024-06-28 |
| 15613 | Turkey Ham & Triple Cheese Toast 15613 | 66 66 | 690 | 740 | 2024-06-28 |
| 15614 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 15614 | 66 66 | 790 | 840 | 2024-06-28 |
| 15615 | Ham & Cheese Croissant 15615 | 66 66 | 690 | 740 | 2024-06-28 |
| 15616 | Sriracha Chicken Whole Wheat Pita 15616 | 66 66 | 750 | 800 | 2024-06-28 |
| 15617 | Blueberry Acai Yogurt Parfait 15617 | 66 66 | 650 | 700 | 2024-06-28 |
| 15618 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 15618 | 66 66 | 650 | 700 | 2024-06-28 |
| 15619 | Caramel Frappuccino® 15619 | 66 66 | 720 | 770 | 2024-06-28 |
| 15620 | Dark Mocha Frappuccino® 15620 | 66 66 | 780 | 830 | 2024-06-28 |
| 15621 | Java Chip Frappuccino® 15621 | 66 66 | 780 | 830 | 2024-06-28 |
| 15622 | Mocha Frappuccino® 15622 | 66 66 | 720 | 770 | 2024-06-28 |
| 15623 | Caramel Macchiato Frappuccino® 15623 | 66 66 | 780 | 830 | 2024-06-28 |
| 15624 | Espresso Frappuccino® 15624 | 66 66 | 720 | 770 | 2024-06-28 |
| 15625 | White Chocolate Mocha Frappuccino® 15625 | 66 66 | 720 | 770 | 2024-06-28 |
| 15626 | Chocolate Chip Cream Frappuccino® 15626 | 66 66 | 780 | 830 | 2024-06-28 |
| 15627 | Hojicha Tea Cream Frappuccino® 15627 | 66 66 | 760 | 810 | 2024-06-28 |
| 15628 | Vanilla Cream Frappuccino® 15628 | 66 66 | 720 | 770 | 2024-06-28 |
| 15629 | Mango Passion Fruit & Hibiscus 15629 | 66 66 | 720 | 770 | 2024-06-28 |
| 15630 | Raspberry Black Currant & Oolong 15630 | 66 66 | 720 | 770 | 2024-06-28 |
| 15631 | Coffee Traveller 15631 | 66 66 | 3120 | 3170 | 2024-06-28 |
| 15632 | Caffè Americano 15632 | 66 66 | 540 | 590 | 2024-06-28 |
| 15633 | Cappuccino 15633 | 66 66 | 680 | 730 | 2024-06-28 |
| 15634 | Caffè Mocha 15634 | 66 66 | 750 | 800 | 2024-06-28 |
| 15635 | Caramel Macchiato 15635 | 66 66 | 760 | 810 | 2024-06-28 |
| 15636 | Espresso 15636 | 66 66 | 390 | 440 | 2024-06-28 |
| 15637 | Caffè Latte 15637 | 66 66 | 680 | 730 | 2024-06-28 |
| 15638 | Oatmilk Latte 15638 | 66 66 | 760 | 810 | 2024-06-28 |
| 15639 | Vanilla Latte 15639 | 66 66 | 750 | 800 | 2024-06-28 |
| 15640 | White Chocolate Mocha 15640 | 66 66 | 750 | 800 | 2024-06-28 |
| 15641 | Flat White 15641 | 66 66 | 760 | 810 | 2024-06-28 |
| 15642 | Ristretto Bianco 15642 | 66 66 | 760 | 810 | 2024-06-28 |
| 15643 | Iced Caffè Americano 15643 | 66 66 | 540 | 590 | 2024-06-28 |
| 15644 | Iced Cappuccino 15644 | 66 66 | 680 | 730 | 2024-06-28 |
| 15645 | Iced Caffè Mocha 15645 | 66 66 | 750 | 800 | 2024-06-28 |
| 15646 | Iced Caramel Macchiato 15646 | 66 66 | 760 | 810 | 2024-06-28 |
| 15647 | Iced Caffè Latte 15647 | 66 66 | 680 | 730 | 2024-06-28 |
| 15648 | Iced Oatmilk Latte 15648 | 66 66 | 760 | 810 | 2024-06-28 |
| 15649 | Iced Vanilla Latte 15649 | 66 66 | 750 | 800 | 2024-06-28 |
| 15650 | Iced White Chocolate Mocha 15650 | 66 66 | 750 | 800 | 2024-06-28 |
| 15651 | Signature Hot Chocolate 15651 | 66 66 | 720 | 770 | 2024-06-28 |
| 15652 | Signature Iced Chocolate 15652 | 66 66 | 720 | 770 | 2024-06-28 |
| 15653 | Carrot Juice 15653 | 66 66 | 490 | 540 | 2024-06-28 |
| 15654 | Cloudy Apple Juice 15654 | 66 66 | 490 | 540 | 2024-06-28 |
| 15655 | Cranberry Red Grapefruit Juice 15655 | 66 66 | 490 | 540 | 2024-06-28 |
| 15656 | Orange Juice 15656 | 66 66 | 490 | 540 | 2024-06-28 |
| 15657 | Evian 15657 | 66 66 | 350 | 400 | 2024-06-28 |
| 15658 | Sparkling Water 15658 | 66 66 | 450 | 500 | 2024-06-28 |
| 15659 | Chai Tea 15659 | 66 66 | 500 | 550 | 2024-06-28 |
| 15660 | Earl Grey Tea 15660 | 66 66 | 500 | 550 | 2024-06-28 |
| 15661 | English Breakfast Tea 15661 | 66 66 | 500 | 550 | 2024-06-28 |
| 15662 | Emperor’s Clouds & Mist™ Tea 15662 | 66 66 | 500 | 550 | 2024-06-28 |
| 15663 | Mint Blend Tea 15663 | 66 66 | 500 | 550 | 2024-06-28 |
| 15664 | Chamomile Tea 15664 | 66 66 | 500 | 550 | 2024-06-28 |
| 15665 | Pure Matcha Latte 15665 | 66 66 | 740 | 790 | 2024-06-28 |
| 15666 | Chai Tea Latte 15666 | 66 66 | 680 | 730 | 2024-06-28 |
| 15667 | Earl Grey Tea Latte 15667 | 66 66 | 680 | 730 | 2024-06-28 |
| 15668 | English Breakfast Tea Latte 15668 | 66 66 | 680 | 730 | 2024-06-28 |
| 15669 | Hojicha Tea Latte 15669 | 66 66 | 740 | 790 | 2024-06-28 |
| 15670 | Zen Clouds Oolong Tea 15670 | 66 66 | 500 | 550 | 2024-06-28 |
| 15671 | Zen Clouds Oolong with Ruby Grapefruit and Honey 15671 | 66 66 | 630 | 680 | 2024-06-28 |
| 15672 | Youthberry™ Tea 15672 | 66 66 | 500 | 550 | 2024-06-28 |
| 15673 | Iced Shaken Black Tea Lemonade 15673 | 66 66 | 610 | 660 | 2024-06-28 |
| 15674 | Iced Shaken Strawberry Black Tea Lemonade 15674 | 66 66 | 630 | 680 | 2024-06-28 |
| 15675 | Iced Shaken Hibiscus Tea Lemonade 15675 | 66 66 | 610 | 660 | 2024-06-28 |
| 15676 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 15676 | 66 66 | 730 | 780 | 2024-06-28 |
| 15677 | Iced Pure Matcha Latte 15677 | 66 66 | 740 | 790 | 2024-06-28 |
| 15678 | Iced Chai Tea Latte 15678 | 66 66 | 680 | 730 | 2024-06-28 |
| 15679 | Iced Black Tea Latte 15679 | 66 66 | 680 | 730 | 2024-06-28 |
| 15680 | Iced Hojicha Tea Latte 15680 | 66 66 | 740 | 790 | 2024-06-28 |
| 15681 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 15681 | 66 66 | 630 | 680 | 2024-06-28 |
| 15682 | Iced Shaken Zen Clouds Oolong Lemonade 15682 | 66 66 | 610 | 660 | 2024-06-28 |
| 15683 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 15683 | 66 66 | 630 | 680 | 2024-06-28 |
| 15684 | Origami Pike Place® Roast 15684 | 66 66 | 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");