item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
236 rows where store_id = 20
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 11
- 2024-06-28 184
- 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
- 20 · 236 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 23446 | Bagel 23446 | 20 20 | 360 | 390 | 2024-06-28 |
| 23447 | Cookie Crumble Cheesecake 23447 | 20 20 | 650 | 700 | 2024-06-28 |
| 23448 | Good Ol' NY Cheesecake 23448 | 20 20 | 650 | 700 | 2024-06-28 |
| 23449 | Signature Chocolate Cake 23449 | 20 20 | 650 | 700 | 2024-06-28 |
| 23450 | Starbucks® Coffee Tiramisu Cake 23450 | 20 20 | 670 | 720 | 2024-06-28 |
| 23451 | Strawberry Shortcake 23451 | 20 20 | 650 | 700 | 2024-06-28 |
| 23452 | Chocolate Chunk Monster Cookie 23452 | 20 20 | 350 | 400 | 2024-06-28 |
| 23453 | Banana Walnut Muffin 23453 | 20 20 | 400 | 450 | 2024-06-28 |
| 23454 | Blueberry Crumble Muffin 23454 | 20 20 | 400 | 450 | 2024-06-28 |
| 23455 | Chocolate Crumble Muffin 23455 | 20 20 | 400 | 450 | 2024-06-28 |
| 23456 | Pancakes 23456 | 20 20 | 490 | 540 | 2024-06-28 |
| 23457 | Almond Croissant 23457 | 20 20 | 420 | 470 | 2024-06-28 |
| 23458 | Buttery Croissant 23458 | 20 20 | 360 | 390 | 2024-06-28 |
| 23459 | Chocolate Croissant 23459 | 20 20 | 390 | 440 | 2024-06-28 |
| 23460 | Creamy Chicken Foldover 23460 | 20 20 | 490 | 540 | 2024-06-28 |
| 23461 | Sausage Roll 23461 | 20 20 | 490 | 540 | 2024-06-28 |
| 23462 | Buttery Scone 23462 | 20 20 | 360 | 390 | 2024-06-28 |
| 23463 | Country Chicken Pie 23463 | 20 20 | 620 | 670 | 2024-06-28 |
| 23464 | Deep Dish Beef Pie 23464 | 20 20 | 620 | 670 | 2024-06-28 |
| 23465 | Spinach & Mushroom Quiche 23465 | 20 20 | 620 | 670 | 2024-06-28 |
| 23466 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 23466 | 20 20 | 350 | 380 | 2024-06-28 |
| 23467 | Mixed Nuts 23467 | 20 20 | 440 | 490 | 2024-06-28 |
| 23468 | Caramel Waffles 23468 | 20 20 | 350 | 380 | 2024-06-28 |
| 23469 | Chicken Ham & Cheese Panwich 23469 | 20 20 | 620 | 670 | 2024-06-28 |
| 23470 | Egg Mayo & Cheese Multigrain Croissant 23470 | 20 20 | 620 | 670 | 2024-06-28 |
| 23471 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 23471 | 20 20 | 620 | 670 | 2024-06-28 |
| 23472 | Rosemary Chicken & Emmental Cheese Croissant 23472 | 20 20 | 620 | 670 | 2024-06-28 |
| 23473 | Scrambled Egg & Turkey Ham Pita 23473 | 20 20 | 620 | 670 | 2024-06-28 |
| 23474 | Turkey Ham & Triple Cheese Toast 23474 | 20 20 | 620 | 670 | 2024-06-28 |
| 23475 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 23475 | 20 20 | 710 | 760 | 2024-06-28 |
| 23476 | Ham & Cheese Croissant 23476 | 20 20 | 620 | 670 | 2024-06-28 |
| 23477 | Sriracha Chicken Whole Wheat Pita 23477 | 20 20 | 670 | 720 | 2024-06-28 |
| 23478 | Blueberry Acai Yogurt Parfait 23478 | 20 20 | 580 | 630 | 2024-06-28 |
| 23479 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 23479 | 20 20 | 580 | 630 | 2024-06-28 |
| 23480 | Caramel Frappuccino® 23480 | 20 20 | 650 | 700 | 2024-06-28 |
| 23481 | Dark Mocha Frappuccino® 23481 | 20 20 | 710 | 760 | 2024-06-28 |
| 23482 | Java Chip Frappuccino® 23482 | 20 20 | 710 | 760 | 2024-06-28 |
| 23483 | Mocha Frappuccino® 23483 | 20 20 | 650 | 700 | 2024-06-28 |
| 23484 | Caramel Macchiato Frappuccino® 23484 | 20 20 | 710 | 760 | 2024-06-28 |
| 23485 | Espresso Frappuccino® 23485 | 20 20 | 650 | 700 | 2024-06-28 |
| 23486 | White Chocolate Mocha Frappuccino® 23486 | 20 20 | 650 | 700 | 2024-06-28 |
| 23487 | Chocolate Chip Cream Frappuccino® 23487 | 20 20 | 710 | 760 | 2024-06-28 |
| 23488 | Hojicha Tea Cream Frappuccino® 23488 | 20 20 | 690 | 740 | 2024-06-28 |
| 23489 | Vanilla Cream Frappuccino® 23489 | 20 20 | 650 | 700 | 2024-06-28 |
| 23490 | Mango Passion Fruit & Hibiscus 23490 | 20 20 | 650 | 700 | 2024-06-28 |
| 23491 | Raspberry Black Currant & Oolong 23491 | 20 20 | 650 | 700 | 2024-06-28 |
| 23492 | Coffee Traveller 23492 | 20 20 | 2800 | 2850 | 2024-06-28 |
| 23493 | Caffè Americano 23493 | 20 20 | 490 | 540 | 2024-06-28 |
| 23494 | Cappuccino 23494 | 20 20 | 620 | 670 | 2024-06-28 |
| 23495 | Caffè Mocha 23495 | 20 20 | 680 | 730 | 2024-06-28 |
| 23496 | Caramel Macchiato 23496 | 20 20 | 690 | 740 | 2024-06-28 |
| 23497 | Espresso 23497 | 20 20 | 350 | 400 | 2024-06-28 |
| 23498 | Caffè Latte 23498 | 20 20 | 620 | 670 | 2024-06-28 |
| 23499 | Oatmilk Latte 23499 | 20 20 | 690 | 740 | 2024-06-28 |
| 23500 | Vanilla Latte 23500 | 20 20 | 680 | 730 | 2024-06-28 |
| 23501 | White Chocolate Mocha 23501 | 20 20 | 680 | 730 | 2024-06-28 |
| 23502 | Flat White 23502 | 20 20 | 690 | 740 | 2024-06-28 |
| 23503 | Ristretto Bianco 23503 | 20 20 | 690 | 740 | 2024-06-28 |
| 23504 | Iced Caffè Americano 23504 | 20 20 | 490 | 540 | 2024-06-28 |
| 23505 | Iced Cappuccino 23505 | 20 20 | 620 | 670 | 2024-06-28 |
| 23506 | Iced Caffè Mocha 23506 | 20 20 | 680 | 730 | 2024-06-28 |
| 23507 | Iced Caramel Macchiato 23507 | 20 20 | 690 | 740 | 2024-06-28 |
| 23508 | Iced Caffè Latte 23508 | 20 20 | 620 | 670 | 2024-06-28 |
| 23509 | Iced Oatmilk Latte 23509 | 20 20 | 690 | 740 | 2024-06-28 |
| 23510 | Iced Vanilla Latte 23510 | 20 20 | 680 | 730 | 2024-06-28 |
| 23511 | Iced White Chocolate Mocha 23511 | 20 20 | 680 | 730 | 2024-06-28 |
| 23512 | Signature Hot Chocolate 23512 | 20 20 | 650 | 700 | 2024-06-28 |
| 23513 | Signature Iced Chocolate 23513 | 20 20 | 650 | 700 | 2024-06-28 |
| 23514 | Carrot Juice 23514 | 20 20 | 440 | 490 | 2024-06-28 |
| 23515 | Cloudy Apple Juice 23515 | 20 20 | 440 | 490 | 2024-06-28 |
| 23516 | Cranberry Red Grapefruit Juice 23516 | 20 20 | 440 | 490 | 2024-06-28 |
| 23517 | Orange Juice 23517 | 20 20 | 440 | 490 | 2024-06-28 |
| 23518 | Evian 23518 | 20 20 | 310 | 360 | 2024-06-28 |
| 23519 | Sparkling Water 23519 | 20 20 | 400 | 450 | 2024-06-28 |
| 23520 | Chai Tea 23520 | 20 20 | 450 | 500 | 2024-06-28 |
| 23521 | Earl Grey Tea 23521 | 20 20 | 450 | 500 | 2024-06-28 |
| 23522 | English Breakfast Tea 23522 | 20 20 | 450 | 500 | 2024-06-28 |
| 23523 | Emperor’s Clouds & Mist™ Tea 23523 | 20 20 | 450 | 500 | 2024-06-28 |
| 23524 | Mint Blend Tea 23524 | 20 20 | 450 | 500 | 2024-06-28 |
| 23525 | Chamomile Tea 23525 | 20 20 | 450 | 500 | 2024-06-28 |
| 23526 | Pure Matcha Latte 23526 | 20 20 | 670 | 720 | 2024-06-28 |
| 23527 | Chai Tea Latte 23527 | 20 20 | 620 | 670 | 2024-06-28 |
| 23528 | Earl Grey Tea Latte 23528 | 20 20 | 620 | 670 | 2024-06-28 |
| 23529 | English Breakfast Tea Latte 23529 | 20 20 | 620 | 670 | 2024-06-28 |
| 23530 | Hojicha Tea Latte 23530 | 20 20 | 670 | 720 | 2024-06-28 |
| 23531 | Zen Clouds Oolong Tea 23531 | 20 20 | 450 | 500 | 2024-06-28 |
| 23532 | Zen Clouds Oolong with Ruby Grapefruit and Honey 23532 | 20 20 | 580 | 630 | 2024-06-28 |
| 23533 | Youthberry™ Tea 23533 | 20 20 | 450 | 500 | 2024-06-28 |
| 23534 | Iced Shaken Black Tea Lemonade 23534 | 20 20 | 560 | 610 | 2024-06-28 |
| 23535 | Iced Shaken Strawberry Black Tea Lemonade 23535 | 20 20 | 580 | 630 | 2024-06-28 |
| 23536 | Iced Shaken Hibiscus Tea Lemonade 23536 | 20 20 | 560 | 610 | 2024-06-28 |
| 23537 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 23537 | 20 20 | 660 | 710 | 2024-06-28 |
| 23538 | Iced Pure Matcha Latte 23538 | 20 20 | 670 | 720 | 2024-06-28 |
| 23539 | Iced Chai Tea Latte 23539 | 20 20 | 620 | 670 | 2024-06-28 |
| 23540 | Iced Black Tea Latte 23540 | 20 20 | 620 | 670 | 2024-06-28 |
| 23541 | Iced Hojicha Tea Latte 23541 | 20 20 | 670 | 720 | 2024-06-28 |
| 23542 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 23542 | 20 20 | 580 | 630 | 2024-06-28 |
| 23543 | Iced Shaken Zen Clouds Oolong Lemonade 23543 | 20 20 | 560 | 610 | 2024-06-28 |
| 23544 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 23544 | 20 20 | 580 | 630 | 2024-06-28 |
| 23545 | Origami Pike Place® Roast 23545 | 20 20 | 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");