item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
271 rows where store_id = 3
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 13
- 2024-06-28 204
- 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-10-27 1
store_id 1
- 3 · 271 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 25467 | Bagel 25467 | 3 3 | 400 | 430 | 2024-06-28 |
| 25468 | Cookie Crumble Cheesecake 25468 | 3 3 | 720 | 770 | 2024-06-28 |
| 25469 | Good Ol' NY Cheesecake 25469 | 3 3 | 720 | 770 | 2024-06-28 |
| 25470 | Signature Chocolate Cake 25470 | 3 3 | 720 | 770 | 2024-06-28 |
| 25471 | Starbucks® Coffee Tiramisu Cake 25471 | 3 3 | 750 | 800 | 2024-06-28 |
| 25472 | Strawberry Shortcake 25472 | 3 3 | 720 | 770 | 2024-06-28 |
| 25473 | Chocolate Chunk Monster Cookie 25473 | 3 3 | 390 | 440 | 2024-06-28 |
| 25474 | Banana Walnut Muffin 25474 | 3 3 | 450 | 500 | 2024-06-28 |
| 25475 | Blueberry Crumble Muffin 25475 | 3 3 | 450 | 500 | 2024-06-28 |
| 25476 | Chocolate Crumble Muffin 25476 | 3 3 | 450 | 500 | 2024-06-28 |
| 25477 | Pancakes 25477 | 3 3 | 550 | 600 | 2024-06-28 |
| 25478 | Almond Croissant 25478 | 3 3 | 470 | 520 | 2024-06-28 |
| 25479 | Buttery Croissant 25479 | 3 3 | 400 | 430 | 2024-06-28 |
| 25480 | Chocolate Croissant 25480 | 3 3 | 440 | 490 | 2024-06-28 |
| 25481 | Creamy Chicken Foldover 25481 | 3 3 | 550 | 600 | 2024-06-28 |
| 25482 | Sausage Roll 25482 | 3 3 | 550 | 600 | 2024-06-28 |
| 25483 | Buttery Scone 25483 | 3 3 | 400 | 430 | 2024-06-28 |
| 25484 | Country Chicken Pie 25484 | 3 3 | 690 | 740 | 2024-06-28 |
| 25485 | Deep Dish Beef Pie 25485 | 3 3 | 690 | 740 | 2024-06-28 |
| 25486 | Spinach & Mushroom Quiche 25486 | 3 3 | 690 | 740 | 2024-06-28 |
| 25487 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 25487 | 3 3 | 390 | 420 | 2024-06-28 |
| 25488 | Mixed Nuts 25488 | 3 3 | 490 | 540 | 2024-06-28 |
| 25489 | Caramel Waffles 25489 | 3 3 | 390 | 420 | 2024-06-28 |
| 25490 | Chicken Ham & Cheese Panwich 25490 | 3 3 | 690 | 740 | 2024-06-28 |
| 25491 | Egg Mayo & Cheese Multigrain Croissant 25491 | 3 3 | 690 | 740 | 2024-06-28 |
| 25492 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 25492 | 3 3 | 690 | 740 | 2024-06-28 |
| 25493 | Rosemary Chicken & Emmental Cheese Croissant 25493 | 3 3 | 690 | 740 | 2024-06-28 |
| 25494 | Scrambled Egg & Turkey Ham Pita 25494 | 3 3 | 690 | 740 | 2024-06-28 |
| 25495 | Turkey Ham & Triple Cheese Toast 25495 | 3 3 | 690 | 740 | 2024-06-28 |
| 25496 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 25496 | 3 3 | 790 | 840 | 2024-06-28 |
| 25497 | Ham & Cheese Croissant 25497 | 3 3 | 690 | 740 | 2024-06-28 |
| 25498 | Sriracha Chicken Whole Wheat Pita 25498 | 3 3 | 750 | 800 | 2024-06-28 |
| 25499 | Blueberry Acai Yogurt Parfait 25499 | 3 3 | 650 | 700 | 2024-06-28 |
| 25500 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 25500 | 3 3 | 650 | 700 | 2024-06-28 |
| 25501 | Caramel Frappuccino® 25501 | 3 3 | 720 | 770 | 2024-06-28 |
| 25502 | Dark Mocha Frappuccino® 25502 | 3 3 | 780 | 830 | 2024-06-28 |
| 25503 | Java Chip Frappuccino® 25503 | 3 3 | 780 | 830 | 2024-06-28 |
| 25504 | Mocha Frappuccino® 25504 | 3 3 | 720 | 770 | 2024-06-28 |
| 25505 | Caramel Macchiato Frappuccino® 25505 | 3 3 | 780 | 830 | 2024-06-28 |
| 25506 | Espresso Frappuccino® 25506 | 3 3 | 720 | 770 | 2024-06-28 |
| 25507 | White Chocolate Mocha Frappuccino® 25507 | 3 3 | 720 | 770 | 2024-06-28 |
| 25508 | Chocolate Chip Cream Frappuccino® 25508 | 3 3 | 780 | 830 | 2024-06-28 |
| 25509 | Hojicha Tea Cream Frappuccino® 25509 | 3 3 | 760 | 810 | 2024-06-28 |
| 25510 | Vanilla Cream Frappuccino® 25510 | 3 3 | 720 | 770 | 2024-06-28 |
| 25511 | Mango Passion Fruit & Hibiscus 25511 | 3 3 | 720 | 770 | 2024-06-28 |
| 25512 | Raspberry Black Currant & Oolong 25512 | 3 3 | 720 | 770 | 2024-06-28 |
| 25513 | Coffee Traveller 25513 | 3 3 | 3120 | 3170 | 2024-06-28 |
| 25514 | Caffè Americano 25514 | 3 3 | 540 | 590 | 2024-06-28 |
| 25515 | Cappuccino 25515 | 3 3 | 680 | 730 | 2024-06-28 |
| 25516 | Caffè Mocha 25516 | 3 3 | 750 | 800 | 2024-06-28 |
| 25517 | Caramel Macchiato 25517 | 3 3 | 760 | 810 | 2024-06-28 |
| 25518 | Espresso 25518 | 3 3 | 390 | 440 | 2024-06-28 |
| 25519 | Caffè Latte 25519 | 3 3 | 680 | 730 | 2024-06-28 |
| 25520 | Oatmilk Latte 25520 | 3 3 | 760 | 810 | 2024-06-28 |
| 25521 | Vanilla Latte 25521 | 3 3 | 750 | 800 | 2024-06-28 |
| 25522 | White Chocolate Mocha 25522 | 3 3 | 750 | 800 | 2024-06-28 |
| 25523 | Flat White 25523 | 3 3 | 760 | 810 | 2024-06-28 |
| 25524 | Ristretto Bianco 25524 | 3 3 | 760 | 810 | 2024-06-28 |
| 25525 | Iced Caffè Americano 25525 | 3 3 | 540 | 590 | 2024-06-28 |
| 25526 | Iced Cappuccino 25526 | 3 3 | 680 | 730 | 2024-06-28 |
| 25527 | Iced Caffè Mocha 25527 | 3 3 | 750 | 800 | 2024-06-28 |
| 25528 | Iced Caramel Macchiato 25528 | 3 3 | 760 | 810 | 2024-06-28 |
| 25529 | Iced Caffè Latte 25529 | 3 3 | 680 | 730 | 2024-06-28 |
| 25530 | Iced Oatmilk Latte 25530 | 3 3 | 760 | 810 | 2024-06-28 |
| 25531 | Iced Vanilla Latte 25531 | 3 3 | 750 | 800 | 2024-06-28 |
| 25532 | Iced White Chocolate Mocha 25532 | 3 3 | 750 | 800 | 2024-06-28 |
| 25533 | Signature Hot Chocolate 25533 | 3 3 | 720 | 770 | 2024-06-28 |
| 25534 | Signature Iced Chocolate 25534 | 3 3 | 720 | 770 | 2024-06-28 |
| 25535 | Carrot Juice 25535 | 3 3 | 490 | 540 | 2024-06-28 |
| 25536 | Cloudy Apple Juice 25536 | 3 3 | 490 | 540 | 2024-06-28 |
| 25537 | Cranberry Red Grapefruit Juice 25537 | 3 3 | 490 | 540 | 2024-06-28 |
| 25538 | Orange Juice 25538 | 3 3 | 490 | 540 | 2024-06-28 |
| 25539 | Evian 25539 | 3 3 | 350 | 400 | 2024-06-28 |
| 25540 | Sparkling Water 25540 | 3 3 | 450 | 500 | 2024-06-28 |
| 25541 | Chai Tea 25541 | 3 3 | 500 | 550 | 2024-06-28 |
| 25542 | Earl Grey Tea 25542 | 3 3 | 500 | 550 | 2024-06-28 |
| 25543 | English Breakfast Tea 25543 | 3 3 | 500 | 550 | 2024-06-28 |
| 25544 | Emperor’s Clouds & Mist™ Tea 25544 | 3 3 | 500 | 550 | 2024-06-28 |
| 25545 | Mint Blend Tea 25545 | 3 3 | 500 | 550 | 2024-06-28 |
| 25546 | Chamomile Tea 25546 | 3 3 | 500 | 550 | 2024-06-28 |
| 25547 | Pure Matcha Latte 25547 | 3 3 | 740 | 790 | 2024-06-28 |
| 25548 | Chai Tea Latte 25548 | 3 3 | 680 | 730 | 2024-06-28 |
| 25549 | Earl Grey Tea Latte 25549 | 3 3 | 680 | 730 | 2024-06-28 |
| 25550 | English Breakfast Tea Latte 25550 | 3 3 | 680 | 730 | 2024-06-28 |
| 25551 | Hojicha Tea Latte 25551 | 3 3 | 740 | 790 | 2024-06-28 |
| 25552 | Zen Clouds Oolong Tea 25552 | 3 3 | 500 | 550 | 2024-06-28 |
| 25553 | Zen Clouds Oolong with Ruby Grapefruit and Honey 25553 | 3 3 | 630 | 680 | 2024-06-28 |
| 25554 | Youthberry™ Tea 25554 | 3 3 | 500 | 550 | 2024-06-28 |
| 25555 | Iced Shaken Black Tea Lemonade 25555 | 3 3 | 610 | 660 | 2024-06-28 |
| 25556 | Iced Shaken Strawberry Black Tea Lemonade 25556 | 3 3 | 630 | 680 | 2024-06-28 |
| 25557 | Iced Shaken Hibiscus Tea Lemonade 25557 | 3 3 | 610 | 660 | 2024-06-28 |
| 25558 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 25558 | 3 3 | 730 | 780 | 2024-06-28 |
| 25559 | Iced Pure Matcha Latte 25559 | 3 3 | 740 | 790 | 2024-06-28 |
| 25560 | Iced Chai Tea Latte 25560 | 3 3 | 680 | 730 | 2024-06-28 |
| 25561 | Iced Black Tea Latte 25561 | 3 3 | 680 | 730 | 2024-06-28 |
| 25562 | Iced Hojicha Tea Latte 25562 | 3 3 | 740 | 790 | 2024-06-28 |
| 25563 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 25563 | 3 3 | 630 | 680 | 2024-06-28 |
| 25564 | Iced Shaken Zen Clouds Oolong Lemonade 25564 | 3 3 | 610 | 660 | 2024-06-28 |
| 25565 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 25565 | 3 3 | 630 | 680 | 2024-06-28 |
| 25566 | Origami Pike Place® Roast 25566 | 3 3 | 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");