item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 25
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
- 25 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 22533 | Bagel 22533 | 25 25 | 400 | 430 | 2024-06-28 |
| 22534 | Cookie Crumble Cheesecake 22534 | 25 25 | 720 | 770 | 2024-06-28 |
| 22535 | Good Ol' NY Cheesecake 22535 | 25 25 | 720 | 770 | 2024-06-28 |
| 22536 | Signature Chocolate Cake 22536 | 25 25 | 720 | 770 | 2024-06-28 |
| 22537 | Starbucks® Coffee Tiramisu Cake 22537 | 25 25 | 750 | 800 | 2024-06-28 |
| 22538 | Strawberry Shortcake 22538 | 25 25 | 720 | 770 | 2024-06-28 |
| 22539 | Chocolate Chunk Monster Cookie 22539 | 25 25 | 390 | 440 | 2024-06-28 |
| 22540 | Banana Walnut Muffin 22540 | 25 25 | 450 | 500 | 2024-06-28 |
| 22541 | Blueberry Crumble Muffin 22541 | 25 25 | 450 | 500 | 2024-06-28 |
| 22542 | Chocolate Crumble Muffin 22542 | 25 25 | 450 | 500 | 2024-06-28 |
| 22543 | Pancakes 22543 | 25 25 | 550 | 600 | 2024-06-28 |
| 22544 | Almond Croissant 22544 | 25 25 | 470 | 520 | 2024-06-28 |
| 22545 | Buttery Croissant 22545 | 25 25 | 400 | 430 | 2024-06-28 |
| 22546 | Chocolate Croissant 22546 | 25 25 | 440 | 490 | 2024-06-28 |
| 22547 | Creamy Chicken Foldover 22547 | 25 25 | 550 | 600 | 2024-06-28 |
| 22548 | Sausage Roll 22548 | 25 25 | 550 | 600 | 2024-06-28 |
| 22549 | Buttery Scone 22549 | 25 25 | 400 | 430 | 2024-06-28 |
| 22550 | Country Chicken Pie 22550 | 25 25 | 690 | 740 | 2024-06-28 |
| 22551 | Deep Dish Beef Pie 22551 | 25 25 | 690 | 740 | 2024-06-28 |
| 22552 | Spinach & Mushroom Quiche 22552 | 25 25 | 690 | 740 | 2024-06-28 |
| 22553 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 22553 | 25 25 | 390 | 420 | 2024-06-28 |
| 22554 | Mixed Nuts 22554 | 25 25 | 490 | 540 | 2024-06-28 |
| 22555 | Caramel Waffles 22555 | 25 25 | 390 | 420 | 2024-06-28 |
| 22556 | Chicken Ham & Cheese Panwich 22556 | 25 25 | 690 | 740 | 2024-06-28 |
| 22557 | Egg Mayo & Cheese Multigrain Croissant 22557 | 25 25 | 690 | 740 | 2024-06-28 |
| 22558 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 22558 | 25 25 | 690 | 740 | 2024-06-28 |
| 22559 | Rosemary Chicken & Emmental Cheese Croissant 22559 | 25 25 | 690 | 740 | 2024-06-28 |
| 22560 | Scrambled Egg & Turkey Ham Pita 22560 | 25 25 | 690 | 740 | 2024-06-28 |
| 22561 | Turkey Ham & Triple Cheese Toast 22561 | 25 25 | 690 | 740 | 2024-06-28 |
| 22562 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 22562 | 25 25 | 790 | 840 | 2024-06-28 |
| 22563 | Ham & Cheese Croissant 22563 | 25 25 | 690 | 740 | 2024-06-28 |
| 22564 | Sriracha Chicken Whole Wheat Pita 22564 | 25 25 | 750 | 800 | 2024-06-28 |
| 22565 | Blueberry Acai Yogurt Parfait 22565 | 25 25 | 650 | 700 | 2024-06-28 |
| 22566 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 22566 | 25 25 | 650 | 700 | 2024-06-28 |
| 22567 | Caramel Frappuccino® 22567 | 25 25 | 720 | 770 | 2024-06-28 |
| 22568 | Dark Mocha Frappuccino® 22568 | 25 25 | 780 | 830 | 2024-06-28 |
| 22569 | Java Chip Frappuccino® 22569 | 25 25 | 780 | 830 | 2024-06-28 |
| 22570 | Mocha Frappuccino® 22570 | 25 25 | 720 | 770 | 2024-06-28 |
| 22571 | Caramel Macchiato Frappuccino® 22571 | 25 25 | 780 | 830 | 2024-06-28 |
| 22572 | Espresso Frappuccino® 22572 | 25 25 | 720 | 770 | 2024-06-28 |
| 22573 | White Chocolate Mocha Frappuccino® 22573 | 25 25 | 720 | 770 | 2024-06-28 |
| 22574 | Chocolate Chip Cream Frappuccino® 22574 | 25 25 | 780 | 830 | 2024-06-28 |
| 22575 | Hojicha Tea Cream Frappuccino® 22575 | 25 25 | 760 | 810 | 2024-06-28 |
| 22576 | Vanilla Cream Frappuccino® 22576 | 25 25 | 720 | 770 | 2024-06-28 |
| 22577 | Mango Passion Fruit & Hibiscus 22577 | 25 25 | 720 | 770 | 2024-06-28 |
| 22578 | Raspberry Black Currant & Oolong 22578 | 25 25 | 720 | 770 | 2024-06-28 |
| 22579 | Coffee Traveller 22579 | 25 25 | 3120 | 3170 | 2024-06-28 |
| 22580 | Caffè Americano 22580 | 25 25 | 540 | 590 | 2024-06-28 |
| 22581 | Cappuccino 22581 | 25 25 | 680 | 730 | 2024-06-28 |
| 22582 | Caffè Mocha 22582 | 25 25 | 750 | 800 | 2024-06-28 |
| 22583 | Caramel Macchiato 22583 | 25 25 | 760 | 810 | 2024-06-28 |
| 22584 | Espresso 22584 | 25 25 | 390 | 440 | 2024-06-28 |
| 22585 | Caffè Latte 22585 | 25 25 | 680 | 730 | 2024-06-28 |
| 22586 | Oatmilk Latte 22586 | 25 25 | 760 | 810 | 2024-06-28 |
| 22587 | Vanilla Latte 22587 | 25 25 | 750 | 800 | 2024-06-28 |
| 22588 | White Chocolate Mocha 22588 | 25 25 | 750 | 800 | 2024-06-28 |
| 22589 | Flat White 22589 | 25 25 | 760 | 810 | 2024-06-28 |
| 22590 | Ristretto Bianco 22590 | 25 25 | 760 | 810 | 2024-06-28 |
| 22591 | Iced Caffè Americano 22591 | 25 25 | 540 | 590 | 2024-06-28 |
| 22592 | Iced Cappuccino 22592 | 25 25 | 680 | 730 | 2024-06-28 |
| 22593 | Iced Caffè Mocha 22593 | 25 25 | 750 | 800 | 2024-06-28 |
| 22594 | Iced Caramel Macchiato 22594 | 25 25 | 760 | 810 | 2024-06-28 |
| 22595 | Iced Caffè Latte 22595 | 25 25 | 680 | 730 | 2024-06-28 |
| 22596 | Iced Oatmilk Latte 22596 | 25 25 | 760 | 810 | 2024-06-28 |
| 22597 | Iced Vanilla Latte 22597 | 25 25 | 750 | 800 | 2024-06-28 |
| 22598 | Iced White Chocolate Mocha 22598 | 25 25 | 750 | 800 | 2024-06-28 |
| 22599 | Signature Hot Chocolate 22599 | 25 25 | 720 | 770 | 2024-06-28 |
| 22600 | Signature Iced Chocolate 22600 | 25 25 | 720 | 770 | 2024-06-28 |
| 22601 | Carrot Juice 22601 | 25 25 | 490 | 540 | 2024-06-28 |
| 22602 | Cloudy Apple Juice 22602 | 25 25 | 490 | 540 | 2024-06-28 |
| 22603 | Cranberry Red Grapefruit Juice 22603 | 25 25 | 490 | 540 | 2024-06-28 |
| 22604 | Orange Juice 22604 | 25 25 | 490 | 540 | 2024-06-28 |
| 22605 | Evian 22605 | 25 25 | 350 | 400 | 2024-06-28 |
| 22606 | Sparkling Water 22606 | 25 25 | 450 | 500 | 2024-06-28 |
| 22607 | Chai Tea 22607 | 25 25 | 500 | 550 | 2024-06-28 |
| 22608 | Earl Grey Tea 22608 | 25 25 | 500 | 550 | 2024-06-28 |
| 22609 | English Breakfast Tea 22609 | 25 25 | 500 | 550 | 2024-06-28 |
| 22610 | Emperor’s Clouds & Mist™ Tea 22610 | 25 25 | 500 | 550 | 2024-06-28 |
| 22611 | Mint Blend Tea 22611 | 25 25 | 500 | 550 | 2024-06-28 |
| 22612 | Chamomile Tea 22612 | 25 25 | 500 | 550 | 2024-06-28 |
| 22613 | Pure Matcha Latte 22613 | 25 25 | 740 | 790 | 2024-06-28 |
| 22614 | Chai Tea Latte 22614 | 25 25 | 680 | 730 | 2024-06-28 |
| 22615 | Earl Grey Tea Latte 22615 | 25 25 | 680 | 730 | 2024-06-28 |
| 22616 | English Breakfast Tea Latte 22616 | 25 25 | 680 | 730 | 2024-06-28 |
| 22617 | Hojicha Tea Latte 22617 | 25 25 | 740 | 790 | 2024-06-28 |
| 22618 | Zen Clouds Oolong Tea 22618 | 25 25 | 500 | 550 | 2024-06-28 |
| 22619 | Zen Clouds Oolong with Ruby Grapefruit and Honey 22619 | 25 25 | 630 | 680 | 2024-06-28 |
| 22620 | Youthberry™ Tea 22620 | 25 25 | 500 | 550 | 2024-06-28 |
| 22621 | Iced Shaken Black Tea Lemonade 22621 | 25 25 | 610 | 660 | 2024-06-28 |
| 22622 | Iced Shaken Strawberry Black Tea Lemonade 22622 | 25 25 | 630 | 680 | 2024-06-28 |
| 22623 | Iced Shaken Hibiscus Tea Lemonade 22623 | 25 25 | 610 | 660 | 2024-06-28 |
| 22624 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 22624 | 25 25 | 730 | 780 | 2024-06-28 |
| 22625 | Iced Pure Matcha Latte 22625 | 25 25 | 740 | 790 | 2024-06-28 |
| 22626 | Iced Chai Tea Latte 22626 | 25 25 | 680 | 730 | 2024-06-28 |
| 22627 | Iced Black Tea Latte 22627 | 25 25 | 680 | 730 | 2024-06-28 |
| 22628 | Iced Hojicha Tea Latte 22628 | 25 25 | 740 | 790 | 2024-06-28 |
| 22629 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 22629 | 25 25 | 630 | 680 | 2024-06-28 |
| 22630 | Iced Shaken Zen Clouds Oolong Lemonade 22630 | 25 25 | 610 | 660 | 2024-06-28 |
| 22631 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 22631 | 25 25 | 630 | 680 | 2024-06-28 |
| 22632 | Origami Pike Place® Roast 22632 | 25 25 | 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");