item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 14
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
- 14 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 24542 | Bagel 24542 | 14 14 | 400 | 430 | 2024-06-28 |
| 24543 | Cookie Crumble Cheesecake 24543 | 14 14 | 720 | 770 | 2024-06-28 |
| 24544 | Good Ol' NY Cheesecake 24544 | 14 14 | 720 | 770 | 2024-06-28 |
| 24545 | Signature Chocolate Cake 24545 | 14 14 | 720 | 770 | 2024-06-28 |
| 24546 | Starbucks® Coffee Tiramisu Cake 24546 | 14 14 | 750 | 800 | 2024-06-28 |
| 24547 | Strawberry Shortcake 24547 | 14 14 | 720 | 770 | 2024-06-28 |
| 24548 | Chocolate Chunk Monster Cookie 24548 | 14 14 | 390 | 440 | 2024-06-28 |
| 24549 | Banana Walnut Muffin 24549 | 14 14 | 450 | 500 | 2024-06-28 |
| 24550 | Blueberry Crumble Muffin 24550 | 14 14 | 450 | 500 | 2024-06-28 |
| 24551 | Chocolate Crumble Muffin 24551 | 14 14 | 450 | 500 | 2024-06-28 |
| 24552 | Pancakes 24552 | 14 14 | 550 | 600 | 2024-06-28 |
| 24553 | Almond Croissant 24553 | 14 14 | 470 | 520 | 2024-06-28 |
| 24554 | Buttery Croissant 24554 | 14 14 | 400 | 430 | 2024-06-28 |
| 24555 | Chocolate Croissant 24555 | 14 14 | 440 | 490 | 2024-06-28 |
| 24556 | Creamy Chicken Foldover 24556 | 14 14 | 550 | 600 | 2024-06-28 |
| 24557 | Sausage Roll 24557 | 14 14 | 550 | 600 | 2024-06-28 |
| 24558 | Buttery Scone 24558 | 14 14 | 400 | 430 | 2024-06-28 |
| 24559 | Country Chicken Pie 24559 | 14 14 | 690 | 740 | 2024-06-28 |
| 24560 | Deep Dish Beef Pie 24560 | 14 14 | 690 | 740 | 2024-06-28 |
| 24561 | Spinach & Mushroom Quiche 24561 | 14 14 | 690 | 740 | 2024-06-28 |
| 24562 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 24562 | 14 14 | 390 | 420 | 2024-06-28 |
| 24563 | Mixed Nuts 24563 | 14 14 | 490 | 540 | 2024-06-28 |
| 24564 | Caramel Waffles 24564 | 14 14 | 390 | 420 | 2024-06-28 |
| 24565 | Chicken Ham & Cheese Panwich 24565 | 14 14 | 690 | 740 | 2024-06-28 |
| 24566 | Egg Mayo & Cheese Multigrain Croissant 24566 | 14 14 | 690 | 740 | 2024-06-28 |
| 24567 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 24567 | 14 14 | 690 | 740 | 2024-06-28 |
| 24568 | Rosemary Chicken & Emmental Cheese Croissant 24568 | 14 14 | 690 | 740 | 2024-06-28 |
| 24569 | Scrambled Egg & Turkey Ham Pita 24569 | 14 14 | 690 | 740 | 2024-06-28 |
| 24570 | Turkey Ham & Triple Cheese Toast 24570 | 14 14 | 690 | 740 | 2024-06-28 |
| 24571 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 24571 | 14 14 | 790 | 840 | 2024-06-28 |
| 24572 | Ham & Cheese Croissant 24572 | 14 14 | 690 | 740 | 2024-06-28 |
| 24573 | Sriracha Chicken Whole Wheat Pita 24573 | 14 14 | 750 | 800 | 2024-06-28 |
| 24574 | Blueberry Acai Yogurt Parfait 24574 | 14 14 | 650 | 700 | 2024-06-28 |
| 24575 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 24575 | 14 14 | 650 | 700 | 2024-06-28 |
| 24576 | Caramel Frappuccino® 24576 | 14 14 | 720 | 770 | 2024-06-28 |
| 24577 | Dark Mocha Frappuccino® 24577 | 14 14 | 780 | 830 | 2024-06-28 |
| 24578 | Java Chip Frappuccino® 24578 | 14 14 | 780 | 830 | 2024-06-28 |
| 24579 | Mocha Frappuccino® 24579 | 14 14 | 720 | 770 | 2024-06-28 |
| 24580 | Caramel Macchiato Frappuccino® 24580 | 14 14 | 780 | 830 | 2024-06-28 |
| 24581 | Espresso Frappuccino® 24581 | 14 14 | 720 | 770 | 2024-06-28 |
| 24582 | White Chocolate Mocha Frappuccino® 24582 | 14 14 | 720 | 770 | 2024-06-28 |
| 24583 | Chocolate Chip Cream Frappuccino® 24583 | 14 14 | 780 | 830 | 2024-06-28 |
| 24584 | Hojicha Tea Cream Frappuccino® 24584 | 14 14 | 760 | 810 | 2024-06-28 |
| 24585 | Vanilla Cream Frappuccino® 24585 | 14 14 | 720 | 770 | 2024-06-28 |
| 24586 | Mango Passion Fruit & Hibiscus 24586 | 14 14 | 720 | 770 | 2024-06-28 |
| 24587 | Raspberry Black Currant & Oolong 24587 | 14 14 | 720 | 770 | 2024-06-28 |
| 24588 | Coffee Traveller 24588 | 14 14 | 3120 | 3170 | 2024-06-28 |
| 24589 | Caffè Americano 24589 | 14 14 | 540 | 590 | 2024-06-28 |
| 24590 | Cappuccino 24590 | 14 14 | 680 | 730 | 2024-06-28 |
| 24591 | Caffè Mocha 24591 | 14 14 | 750 | 800 | 2024-06-28 |
| 24592 | Caramel Macchiato 24592 | 14 14 | 760 | 810 | 2024-06-28 |
| 24593 | Espresso 24593 | 14 14 | 390 | 440 | 2024-06-28 |
| 24594 | Caffè Latte 24594 | 14 14 | 680 | 730 | 2024-06-28 |
| 24595 | Oatmilk Latte 24595 | 14 14 | 760 | 810 | 2024-06-28 |
| 24596 | Vanilla Latte 24596 | 14 14 | 750 | 800 | 2024-06-28 |
| 24597 | White Chocolate Mocha 24597 | 14 14 | 750 | 800 | 2024-06-28 |
| 24598 | Flat White 24598 | 14 14 | 760 | 810 | 2024-06-28 |
| 24599 | Ristretto Bianco 24599 | 14 14 | 760 | 810 | 2024-06-28 |
| 24600 | Iced Caffè Americano 24600 | 14 14 | 540 | 590 | 2024-06-28 |
| 24601 | Iced Cappuccino 24601 | 14 14 | 680 | 730 | 2024-06-28 |
| 24602 | Iced Caffè Mocha 24602 | 14 14 | 750 | 800 | 2024-06-28 |
| 24603 | Iced Caramel Macchiato 24603 | 14 14 | 760 | 810 | 2024-06-28 |
| 24604 | Iced Caffè Latte 24604 | 14 14 | 680 | 730 | 2024-06-28 |
| 24605 | Iced Oatmilk Latte 24605 | 14 14 | 760 | 810 | 2024-06-28 |
| 24606 | Iced Vanilla Latte 24606 | 14 14 | 750 | 800 | 2024-06-28 |
| 24607 | Iced White Chocolate Mocha 24607 | 14 14 | 750 | 800 | 2024-06-28 |
| 24608 | Signature Hot Chocolate 24608 | 14 14 | 720 | 770 | 2024-06-28 |
| 24609 | Signature Iced Chocolate 24609 | 14 14 | 720 | 770 | 2024-06-28 |
| 24610 | Carrot Juice 24610 | 14 14 | 490 | 540 | 2024-06-28 |
| 24611 | Cloudy Apple Juice 24611 | 14 14 | 490 | 540 | 2024-06-28 |
| 24612 | Cranberry Red Grapefruit Juice 24612 | 14 14 | 490 | 540 | 2024-06-28 |
| 24613 | Orange Juice 24613 | 14 14 | 490 | 540 | 2024-06-28 |
| 24614 | Evian 24614 | 14 14 | 350 | 400 | 2024-06-28 |
| 24615 | Sparkling Water 24615 | 14 14 | 450 | 500 | 2024-06-28 |
| 24616 | Chai Tea 24616 | 14 14 | 500 | 550 | 2024-06-28 |
| 24617 | Earl Grey Tea 24617 | 14 14 | 500 | 550 | 2024-06-28 |
| 24618 | English Breakfast Tea 24618 | 14 14 | 500 | 550 | 2024-06-28 |
| 24619 | Emperor’s Clouds & Mist™ Tea 24619 | 14 14 | 500 | 550 | 2024-06-28 |
| 24620 | Mint Blend Tea 24620 | 14 14 | 500 | 550 | 2024-06-28 |
| 24621 | Chamomile Tea 24621 | 14 14 | 500 | 550 | 2024-06-28 |
| 24622 | Pure Matcha Latte 24622 | 14 14 | 740 | 790 | 2024-06-28 |
| 24623 | Chai Tea Latte 24623 | 14 14 | 680 | 730 | 2024-06-28 |
| 24624 | Earl Grey Tea Latte 24624 | 14 14 | 680 | 730 | 2024-06-28 |
| 24625 | English Breakfast Tea Latte 24625 | 14 14 | 680 | 730 | 2024-06-28 |
| 24626 | Hojicha Tea Latte 24626 | 14 14 | 740 | 790 | 2024-06-28 |
| 24627 | Zen Clouds Oolong Tea 24627 | 14 14 | 500 | 550 | 2024-06-28 |
| 24628 | Zen Clouds Oolong with Ruby Grapefruit and Honey 24628 | 14 14 | 630 | 680 | 2024-06-28 |
| 24629 | Youthberry™ Tea 24629 | 14 14 | 500 | 550 | 2024-06-28 |
| 24630 | Iced Shaken Black Tea Lemonade 24630 | 14 14 | 610 | 660 | 2024-06-28 |
| 24631 | Iced Shaken Strawberry Black Tea Lemonade 24631 | 14 14 | 630 | 680 | 2024-06-28 |
| 24632 | Iced Shaken Hibiscus Tea Lemonade 24632 | 14 14 | 610 | 660 | 2024-06-28 |
| 24633 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 24633 | 14 14 | 730 | 780 | 2024-06-28 |
| 24634 | Iced Pure Matcha Latte 24634 | 14 14 | 740 | 790 | 2024-06-28 |
| 24635 | Iced Chai Tea Latte 24635 | 14 14 | 680 | 730 | 2024-06-28 |
| 24636 | Iced Black Tea Latte 24636 | 14 14 | 680 | 730 | 2024-06-28 |
| 24637 | Iced Hojicha Tea Latte 24637 | 14 14 | 740 | 790 | 2024-06-28 |
| 24638 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 24638 | 14 14 | 630 | 680 | 2024-06-28 |
| 24639 | Iced Shaken Zen Clouds Oolong Lemonade 24639 | 14 14 | 610 | 660 | 2024-06-28 |
| 24640 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 24640 | 14 14 | 630 | 680 | 2024-06-28 |
| 24641 | Origami Pike Place® Roast 24641 | 14 14 | 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");