item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
204 rows where effective_date = "2024-06-28" and store_id = 3
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
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");