item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
182 rows where effective_date = "2024-06-28" and store_id = 5
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 367 | Bagel 367 | 5 5 | 400 | 430 | 2024-06-28 |
| 368 | Cookie Crumble Cheesecake 368 | 5 5 | 720 | 770 | 2024-06-28 |
| 369 | Good Ol' NY Cheesecake 369 | 5 5 | 720 | 770 | 2024-06-28 |
| 370 | Signature Chocolate Cake 370 | 5 5 | 720 | 770 | 2024-06-28 |
| 371 | Starbucks® Coffee Tiramisu Cake 371 | 5 5 | 750 | 800 | 2024-06-28 |
| 372 | Strawberry Shortcake 372 | 5 5 | 720 | 770 | 2024-06-28 |
| 373 | Chocolate Chunk Monster Cookie 373 | 5 5 | 390 | 440 | 2024-06-28 |
| 374 | Banana Walnut Muffin 374 | 5 5 | 450 | 500 | 2024-06-28 |
| 375 | Blueberry Crumble Muffin 375 | 5 5 | 450 | 500 | 2024-06-28 |
| 376 | Chocolate Crumble Muffin 376 | 5 5 | 450 | 500 | 2024-06-28 |
| 377 | Pancakes 377 | 5 5 | 550 | 600 | 2024-06-28 |
| 378 | Almond Croissant 378 | 5 5 | 470 | 520 | 2024-06-28 |
| 379 | Buttery Croissant 379 | 5 5 | 400 | 430 | 2024-06-28 |
| 380 | Chocolate Croissant 380 | 5 5 | 440 | 490 | 2024-06-28 |
| 381 | Creamy Chicken Foldover 381 | 5 5 | 550 | 600 | 2024-06-28 |
| 382 | Sausage Roll 382 | 5 5 | 550 | 600 | 2024-06-28 |
| 383 | Buttery Scone 383 | 5 5 | 400 | 430 | 2024-06-28 |
| 384 | Country Chicken Pie 384 | 5 5 | 690 | 740 | 2024-06-28 |
| 385 | Deep Dish Beef Pie 385 | 5 5 | 690 | 740 | 2024-06-28 |
| 386 | Spinach & Mushroom Quiche 386 | 5 5 | 690 | 740 | 2024-06-28 |
| 387 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 387 | 5 5 | 390 | 420 | 2024-06-28 |
| 388 | Mixed Nuts 388 | 5 5 | 490 | 540 | 2024-06-28 |
| 389 | Caramel Waffles 389 | 5 5 | 390 | 420 | 2024-06-28 |
| 390 | Chicken Ham & Cheese Panwich 390 | 5 5 | 690 | 740 | 2024-06-28 |
| 391 | Egg Mayo & Cheese Multigrain Croissant 391 | 5 5 | 690 | 740 | 2024-06-28 |
| 392 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 392 | 5 5 | 690 | 740 | 2024-06-28 |
| 393 | Rosemary Chicken & Emmental Cheese Croissant 393 | 5 5 | 690 | 740 | 2024-06-28 |
| 394 | Scrambled Egg & Turkey Ham Pita 394 | 5 5 | 690 | 740 | 2024-06-28 |
| 395 | Turkey Ham & Triple Cheese Toast 395 | 5 5 | 690 | 740 | 2024-06-28 |
| 396 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 396 | 5 5 | 790 | 840 | 2024-06-28 |
| 397 | Ham & Cheese Croissant 397 | 5 5 | 690 | 740 | 2024-06-28 |
| 398 | Sriracha Chicken Whole Wheat Pita 398 | 5 5 | 750 | 800 | 2024-06-28 |
| 399 | Blueberry Acai Yogurt Parfait 399 | 5 5 | 650 | 700 | 2024-06-28 |
| 400 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 400 | 5 5 | 650 | 700 | 2024-06-28 |
| 401 | Caramel Frappuccino® 401 | 5 5 | 720 | 770 | 2024-06-28 |
| 402 | Dark Mocha Frappuccino® 402 | 5 5 | 780 | 830 | 2024-06-28 |
| 403 | Java Chip Frappuccino® 403 | 5 5 | 780 | 830 | 2024-06-28 |
| 404 | Mocha Frappuccino® 404 | 5 5 | 720 | 770 | 2024-06-28 |
| 405 | Caramel Macchiato Frappuccino® 405 | 5 5 | 780 | 830 | 2024-06-28 |
| 406 | Espresso Frappuccino® 406 | 5 5 | 720 | 770 | 2024-06-28 |
| 407 | White Chocolate Mocha Frappuccino® 407 | 5 5 | 720 | 770 | 2024-06-28 |
| 408 | Chocolate Chip Cream Frappuccino® 408 | 5 5 | 780 | 830 | 2024-06-28 |
| 409 | Hojicha Tea Cream Frappuccino® 409 | 5 5 | 760 | 810 | 2024-06-28 |
| 410 | Vanilla Cream Frappuccino® 410 | 5 5 | 720 | 770 | 2024-06-28 |
| 411 | Mango Passion Fruit & Hibiscus 411 | 5 5 | 720 | 770 | 2024-06-28 |
| 412 | Raspberry Black Currant & Oolong 412 | 5 5 | 720 | 770 | 2024-06-28 |
| 413 | Coffee Traveller 413 | 5 5 | 3120 | 3170 | 2024-06-28 |
| 414 | Caffè Americano 414 | 5 5 | 540 | 590 | 2024-06-28 |
| 415 | Cappuccino 415 | 5 5 | 680 | 730 | 2024-06-28 |
| 416 | Caffè Mocha 416 | 5 5 | 750 | 800 | 2024-06-28 |
| 417 | Caramel Macchiato 417 | 5 5 | 760 | 810 | 2024-06-28 |
| 418 | Espresso 418 | 5 5 | 390 | 440 | 2024-06-28 |
| 419 | Caffè Latte 419 | 5 5 | 680 | 730 | 2024-06-28 |
| 420 | Oatmilk Latte 420 | 5 5 | 760 | 810 | 2024-06-28 |
| 421 | Vanilla Latte 421 | 5 5 | 750 | 800 | 2024-06-28 |
| 422 | White Chocolate Mocha 422 | 5 5 | 750 | 800 | 2024-06-28 |
| 423 | Flat White 423 | 5 5 | 760 | 810 | 2024-06-28 |
| 424 | Ristretto Bianco 424 | 5 5 | 760 | 810 | 2024-06-28 |
| 425 | Iced Caffè Americano 425 | 5 5 | 540 | 590 | 2024-06-28 |
| 426 | Iced Cappuccino 426 | 5 5 | 680 | 730 | 2024-06-28 |
| 427 | Iced Caffè Mocha 427 | 5 5 | 750 | 800 | 2024-06-28 |
| 428 | Iced Caramel Macchiato 428 | 5 5 | 760 | 810 | 2024-06-28 |
| 429 | Iced Caffè Latte 429 | 5 5 | 680 | 730 | 2024-06-28 |
| 430 | Iced Oatmilk Latte 430 | 5 5 | 760 | 810 | 2024-06-28 |
| 431 | Iced Vanilla Latte 431 | 5 5 | 750 | 800 | 2024-06-28 |
| 432 | Iced White Chocolate Mocha 432 | 5 5 | 750 | 800 | 2024-06-28 |
| 433 | Signature Hot Chocolate 433 | 5 5 | 720 | 770 | 2024-06-28 |
| 434 | Signature Iced Chocolate 434 | 5 5 | 720 | 770 | 2024-06-28 |
| 435 | Carrot Juice 435 | 5 5 | 490 | 540 | 2024-06-28 |
| 436 | Cloudy Apple Juice 436 | 5 5 | 490 | 540 | 2024-06-28 |
| 437 | Cranberry Red Grapefruit Juice 437 | 5 5 | 490 | 540 | 2024-06-28 |
| 438 | Orange Juice 438 | 5 5 | 490 | 540 | 2024-06-28 |
| 439 | Evian 439 | 5 5 | 350 | 400 | 2024-06-28 |
| 440 | Sparkling Water 440 | 5 5 | 450 | 500 | 2024-06-28 |
| 441 | Chai Tea 441 | 5 5 | 500 | 550 | 2024-06-28 |
| 442 | Earl Grey Tea 442 | 5 5 | 500 | 550 | 2024-06-28 |
| 443 | English Breakfast Tea 443 | 5 5 | 500 | 550 | 2024-06-28 |
| 444 | Emperor’s Clouds & Mist™ Tea 444 | 5 5 | 500 | 550 | 2024-06-28 |
| 445 | Mint Blend Tea 445 | 5 5 | 500 | 550 | 2024-06-28 |
| 446 | Chamomile Tea 446 | 5 5 | 500 | 550 | 2024-06-28 |
| 447 | Pure Matcha Latte 447 | 5 5 | 740 | 790 | 2024-06-28 |
| 448 | Chai Tea Latte 448 | 5 5 | 680 | 730 | 2024-06-28 |
| 449 | Earl Grey Tea Latte 449 | 5 5 | 680 | 730 | 2024-06-28 |
| 450 | English Breakfast Tea Latte 450 | 5 5 | 680 | 730 | 2024-06-28 |
| 451 | Hojicha Tea Latte 451 | 5 5 | 740 | 790 | 2024-06-28 |
| 452 | Zen Clouds Oolong Tea 452 | 5 5 | 500 | 550 | 2024-06-28 |
| 453 | Zen Clouds Oolong with Ruby Grapefruit and Honey 453 | 5 5 | 630 | 680 | 2024-06-28 |
| 454 | Youthberry™ Tea 454 | 5 5 | 500 | 550 | 2024-06-28 |
| 455 | Iced Shaken Black Tea Lemonade 455 | 5 5 | 610 | 660 | 2024-06-28 |
| 456 | Iced Shaken Strawberry Black Tea Lemonade 456 | 5 5 | 630 | 680 | 2024-06-28 |
| 457 | Iced Shaken Hibiscus Tea Lemonade 457 | 5 5 | 610 | 660 | 2024-06-28 |
| 458 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 458 | 5 5 | 730 | 780 | 2024-06-28 |
| 459 | Iced Pure Matcha Latte 459 | 5 5 | 740 | 790 | 2024-06-28 |
| 460 | Iced Chai Tea Latte 460 | 5 5 | 680 | 730 | 2024-06-28 |
| 461 | Iced Black Tea Latte 461 | 5 5 | 680 | 730 | 2024-06-28 |
| 462 | Iced Hojicha Tea Latte 462 | 5 5 | 740 | 790 | 2024-06-28 |
| 463 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 463 | 5 5 | 630 | 680 | 2024-06-28 |
| 464 | Iced Shaken Zen Clouds Oolong Lemonade 464 | 5 5 | 610 | 660 | 2024-06-28 |
| 465 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 465 | 5 5 | 630 | 680 | 2024-06-28 |
| 466 | Origami Pike Place® Roast 466 | 5 5 | 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");