item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
248 rows where store_id = 125
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 12
- 2024-06-28 182
- 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
store_id 1
- 125 · 248 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 6436 | Bagel 6436 | 125 125 | 400 | 430 | 2024-06-28 |
| 6437 | Cookie Crumble Cheesecake 6437 | 125 125 | 720 | 770 | 2024-06-28 |
| 6438 | Good Ol' NY Cheesecake 6438 | 125 125 | 720 | 770 | 2024-06-28 |
| 6439 | Signature Chocolate Cake 6439 | 125 125 | 720 | 770 | 2024-06-28 |
| 6440 | Starbucks® Coffee Tiramisu Cake 6440 | 125 125 | 750 | 800 | 2024-06-28 |
| 6441 | Strawberry Shortcake 6441 | 125 125 | 720 | 770 | 2024-06-28 |
| 6442 | Chocolate Chunk Monster Cookie 6442 | 125 125 | 390 | 440 | 2024-06-28 |
| 6443 | Banana Walnut Muffin 6443 | 125 125 | 450 | 500 | 2024-06-28 |
| 6444 | Blueberry Crumble Muffin 6444 | 125 125 | 450 | 500 | 2024-06-28 |
| 6445 | Chocolate Crumble Muffin 6445 | 125 125 | 450 | 500 | 2024-06-28 |
| 6446 | Pancakes 6446 | 125 125 | 550 | 600 | 2024-06-28 |
| 6447 | Almond Croissant 6447 | 125 125 | 470 | 520 | 2024-06-28 |
| 6448 | Buttery Croissant 6448 | 125 125 | 400 | 430 | 2024-06-28 |
| 6449 | Chocolate Croissant 6449 | 125 125 | 440 | 490 | 2024-06-28 |
| 6450 | Creamy Chicken Foldover 6450 | 125 125 | 550 | 600 | 2024-06-28 |
| 6451 | Sausage Roll 6451 | 125 125 | 550 | 600 | 2024-06-28 |
| 6452 | Buttery Scone 6452 | 125 125 | 400 | 430 | 2024-06-28 |
| 6453 | Country Chicken Pie 6453 | 125 125 | 690 | 740 | 2024-06-28 |
| 6454 | Deep Dish Beef Pie 6454 | 125 125 | 690 | 740 | 2024-06-28 |
| 6455 | Spinach & Mushroom Quiche 6455 | 125 125 | 690 | 740 | 2024-06-28 |
| 6456 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 6456 | 125 125 | 390 | 420 | 2024-06-28 |
| 6457 | Mixed Nuts 6457 | 125 125 | 490 | 540 | 2024-06-28 |
| 6458 | Caramel Waffles 6458 | 125 125 | 390 | 420 | 2024-06-28 |
| 6459 | Chicken Ham & Cheese Panwich 6459 | 125 125 | 690 | 740 | 2024-06-28 |
| 6460 | Egg Mayo & Cheese Multigrain Croissant 6460 | 125 125 | 690 | 740 | 2024-06-28 |
| 6461 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 6461 | 125 125 | 690 | 740 | 2024-06-28 |
| 6462 | Rosemary Chicken & Emmental Cheese Croissant 6462 | 125 125 | 690 | 740 | 2024-06-28 |
| 6463 | Scrambled Egg & Turkey Ham Pita 6463 | 125 125 | 690 | 740 | 2024-06-28 |
| 6464 | Turkey Ham & Triple Cheese Toast 6464 | 125 125 | 690 | 740 | 2024-06-28 |
| 6465 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 6465 | 125 125 | 790 | 840 | 2024-06-28 |
| 6466 | Ham & Cheese Croissant 6466 | 125 125 | 690 | 740 | 2024-06-28 |
| 6467 | Sriracha Chicken Whole Wheat Pita 6467 | 125 125 | 750 | 800 | 2024-06-28 |
| 6468 | Blueberry Acai Yogurt Parfait 6468 | 125 125 | 650 | 700 | 2024-06-28 |
| 6469 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 6469 | 125 125 | 650 | 700 | 2024-06-28 |
| 6470 | Caramel Frappuccino® 6470 | 125 125 | 720 | 770 | 2024-06-28 |
| 6471 | Dark Mocha Frappuccino® 6471 | 125 125 | 780 | 830 | 2024-06-28 |
| 6472 | Java Chip Frappuccino® 6472 | 125 125 | 780 | 830 | 2024-06-28 |
| 6473 | Mocha Frappuccino® 6473 | 125 125 | 720 | 770 | 2024-06-28 |
| 6474 | Caramel Macchiato Frappuccino® 6474 | 125 125 | 780 | 830 | 2024-06-28 |
| 6475 | Espresso Frappuccino® 6475 | 125 125 | 720 | 770 | 2024-06-28 |
| 6476 | White Chocolate Mocha Frappuccino® 6476 | 125 125 | 720 | 770 | 2024-06-28 |
| 6477 | Chocolate Chip Cream Frappuccino® 6477 | 125 125 | 780 | 830 | 2024-06-28 |
| 6478 | Hojicha Tea Cream Frappuccino® 6478 | 125 125 | 760 | 810 | 2024-06-28 |
| 6479 | Vanilla Cream Frappuccino® 6479 | 125 125 | 720 | 770 | 2024-06-28 |
| 6480 | Mango Passion Fruit & Hibiscus 6480 | 125 125 | 720 | 770 | 2024-06-28 |
| 6481 | Raspberry Black Currant & Oolong 6481 | 125 125 | 720 | 770 | 2024-06-28 |
| 6482 | Coffee Traveller 6482 | 125 125 | 3120 | 3170 | 2024-06-28 |
| 6483 | Caffè Americano 6483 | 125 125 | 540 | 590 | 2024-06-28 |
| 6484 | Cappuccino 6484 | 125 125 | 680 | 730 | 2024-06-28 |
| 6485 | Caffè Mocha 6485 | 125 125 | 750 | 800 | 2024-06-28 |
| 6486 | Caramel Macchiato 6486 | 125 125 | 760 | 810 | 2024-06-28 |
| 6487 | Espresso 6487 | 125 125 | 390 | 440 | 2024-06-28 |
| 6488 | Caffè Latte 6488 | 125 125 | 680 | 730 | 2024-06-28 |
| 6489 | Oatmilk Latte 6489 | 125 125 | 760 | 810 | 2024-06-28 |
| 6490 | Vanilla Latte 6490 | 125 125 | 750 | 800 | 2024-06-28 |
| 6491 | White Chocolate Mocha 6491 | 125 125 | 750 | 800 | 2024-06-28 |
| 6492 | Flat White 6492 | 125 125 | 760 | 810 | 2024-06-28 |
| 6493 | Ristretto Bianco 6493 | 125 125 | 760 | 810 | 2024-06-28 |
| 6494 | Iced Caffè Americano 6494 | 125 125 | 540 | 590 | 2024-06-28 |
| 6495 | Iced Cappuccino 6495 | 125 125 | 680 | 730 | 2024-06-28 |
| 6496 | Iced Caffè Mocha 6496 | 125 125 | 750 | 800 | 2024-06-28 |
| 6497 | Iced Caramel Macchiato 6497 | 125 125 | 760 | 810 | 2024-06-28 |
| 6498 | Iced Caffè Latte 6498 | 125 125 | 680 | 730 | 2024-06-28 |
| 6499 | Iced Oatmilk Latte 6499 | 125 125 | 760 | 810 | 2024-06-28 |
| 6500 | Iced Vanilla Latte 6500 | 125 125 | 750 | 800 | 2024-06-28 |
| 6501 | Iced White Chocolate Mocha 6501 | 125 125 | 750 | 800 | 2024-06-28 |
| 6502 | Signature Hot Chocolate 6502 | 125 125 | 720 | 770 | 2024-06-28 |
| 6503 | Signature Iced Chocolate 6503 | 125 125 | 720 | 770 | 2024-06-28 |
| 6504 | Carrot Juice 6504 | 125 125 | 490 | 540 | 2024-06-28 |
| 6505 | Cloudy Apple Juice 6505 | 125 125 | 490 | 540 | 2024-06-28 |
| 6506 | Cranberry Red Grapefruit Juice 6506 | 125 125 | 490 | 540 | 2024-06-28 |
| 6507 | Orange Juice 6507 | 125 125 | 490 | 540 | 2024-06-28 |
| 6508 | Evian 6508 | 125 125 | 350 | 400 | 2024-06-28 |
| 6509 | Sparkling Water 6509 | 125 125 | 450 | 500 | 2024-06-28 |
| 6510 | Chai Tea 6510 | 125 125 | 500 | 550 | 2024-06-28 |
| 6511 | Earl Grey Tea 6511 | 125 125 | 500 | 550 | 2024-06-28 |
| 6512 | English Breakfast Tea 6512 | 125 125 | 500 | 550 | 2024-06-28 |
| 6513 | Emperor’s Clouds & Mist™ Tea 6513 | 125 125 | 500 | 550 | 2024-06-28 |
| 6514 | Mint Blend Tea 6514 | 125 125 | 500 | 550 | 2024-06-28 |
| 6515 | Chamomile Tea 6515 | 125 125 | 500 | 550 | 2024-06-28 |
| 6516 | Pure Matcha Latte 6516 | 125 125 | 740 | 790 | 2024-06-28 |
| 6517 | Chai Tea Latte 6517 | 125 125 | 680 | 730 | 2024-06-28 |
| 6518 | Earl Grey Tea Latte 6518 | 125 125 | 680 | 730 | 2024-06-28 |
| 6519 | English Breakfast Tea Latte 6519 | 125 125 | 680 | 730 | 2024-06-28 |
| 6520 | Hojicha Tea Latte 6520 | 125 125 | 740 | 790 | 2024-06-28 |
| 6521 | Zen Clouds Oolong Tea 6521 | 125 125 | 500 | 550 | 2024-06-28 |
| 6522 | Zen Clouds Oolong with Ruby Grapefruit and Honey 6522 | 125 125 | 630 | 680 | 2024-06-28 |
| 6523 | Youthberry™ Tea 6523 | 125 125 | 500 | 550 | 2024-06-28 |
| 6524 | Iced Shaken Black Tea Lemonade 6524 | 125 125 | 610 | 660 | 2024-06-28 |
| 6525 | Iced Shaken Strawberry Black Tea Lemonade 6525 | 125 125 | 630 | 680 | 2024-06-28 |
| 6526 | Iced Shaken Hibiscus Tea Lemonade 6526 | 125 125 | 610 | 660 | 2024-06-28 |
| 6527 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 6527 | 125 125 | 730 | 780 | 2024-06-28 |
| 6528 | Iced Pure Matcha Latte 6528 | 125 125 | 740 | 790 | 2024-06-28 |
| 6529 | Iced Chai Tea Latte 6529 | 125 125 | 680 | 730 | 2024-06-28 |
| 6530 | Iced Black Tea Latte 6530 | 125 125 | 680 | 730 | 2024-06-28 |
| 6531 | Iced Hojicha Tea Latte 6531 | 125 125 | 740 | 790 | 2024-06-28 |
| 6532 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 6532 | 125 125 | 630 | 680 | 2024-06-28 |
| 6533 | Iced Shaken Zen Clouds Oolong Lemonade 6533 | 125 125 | 610 | 660 | 2024-06-28 |
| 6534 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 6534 | 125 125 | 630 | 680 | 2024-06-28 |
| 6535 | Origami Pike Place® Roast 6535 | 125 125 | 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");