item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
195 rows where effective_date = "2024-06-28" and store_id = 88
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
---|---|---|---|---|---|
12452 | Bagel 12452 | 88 88 | 400 | 430 | 2024-06-28 |
12453 | Cookie Crumble Cheesecake 12453 | 88 88 | 720 | 770 | 2024-06-28 |
12454 | Good Ol' NY Cheesecake 12454 | 88 88 | 720 | 770 | 2024-06-28 |
12455 | Signature Chocolate Cake 12455 | 88 88 | 720 | 770 | 2024-06-28 |
12456 | Starbucks® Coffee Tiramisu Cake 12456 | 88 88 | 750 | 800 | 2024-06-28 |
12457 | Strawberry Shortcake 12457 | 88 88 | 720 | 770 | 2024-06-28 |
12458 | Chocolate Chunk Monster Cookie 12458 | 88 88 | 390 | 440 | 2024-06-28 |
12459 | Banana Walnut Muffin 12459 | 88 88 | 450 | 500 | 2024-06-28 |
12460 | Blueberry Crumble Muffin 12460 | 88 88 | 450 | 500 | 2024-06-28 |
12461 | Chocolate Crumble Muffin 12461 | 88 88 | 450 | 500 | 2024-06-28 |
12462 | Pancakes 12462 | 88 88 | 550 | 600 | 2024-06-28 |
12463 | Almond Croissant 12463 | 88 88 | 470 | 520 | 2024-06-28 |
12464 | Buttery Croissant 12464 | 88 88 | 400 | 430 | 2024-06-28 |
12465 | Chocolate Croissant 12465 | 88 88 | 440 | 490 | 2024-06-28 |
12466 | Creamy Chicken Foldover 12466 | 88 88 | 550 | 600 | 2024-06-28 |
12467 | Sausage Roll 12467 | 88 88 | 550 | 600 | 2024-06-28 |
12468 | Buttery Scone 12468 | 88 88 | 400 | 430 | 2024-06-28 |
12469 | Country Chicken Pie 12469 | 88 88 | 690 | 740 | 2024-06-28 |
12470 | Deep Dish Beef Pie 12470 | 88 88 | 690 | 740 | 2024-06-28 |
12471 | Spinach & Mushroom Quiche 12471 | 88 88 | 690 | 740 | 2024-06-28 |
12472 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 12472 | 88 88 | 390 | 420 | 2024-06-28 |
12473 | Mixed Nuts 12473 | 88 88 | 490 | 540 | 2024-06-28 |
12474 | Caramel Waffles 12474 | 88 88 | 390 | 420 | 2024-06-28 |
12475 | Chicken Ham & Cheese Panwich 12475 | 88 88 | 690 | 740 | 2024-06-28 |
12476 | Egg Mayo & Cheese Multigrain Croissant 12476 | 88 88 | 690 | 740 | 2024-06-28 |
12477 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 12477 | 88 88 | 690 | 740 | 2024-06-28 |
12478 | Rosemary Chicken & Emmental Cheese Croissant 12478 | 88 88 | 690 | 740 | 2024-06-28 |
12479 | Scrambled Egg & Turkey Ham Pita 12479 | 88 88 | 690 | 740 | 2024-06-28 |
12480 | Turkey Ham & Triple Cheese Toast 12480 | 88 88 | 690 | 740 | 2024-06-28 |
12481 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 12481 | 88 88 | 790 | 840 | 2024-06-28 |
12482 | Ham & Cheese Croissant 12482 | 88 88 | 690 | 740 | 2024-06-28 |
12483 | Sriracha Chicken Whole Wheat Pita 12483 | 88 88 | 750 | 800 | 2024-06-28 |
12484 | Blueberry Acai Yogurt Parfait 12484 | 88 88 | 650 | 700 | 2024-06-28 |
12485 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 12485 | 88 88 | 650 | 700 | 2024-06-28 |
12486 | Buttery Croissant 12486 | 88 88 | 400 | 450 | 2024-06-28 |
12487 | Chocolate Croissant 12487 | 88 88 | 440 | 490 | 2024-06-28 |
12488 | Raisin Danish 12488 | 88 88 | 470 | 520 | 2024-06-28 |
12489 | Apple Tart 12489 | 88 88 | 620 | 670 | 2024-06-28 |
12490 | Lemon Meringue Tart 12490 | 88 88 | 620 | 670 | 2024-06-28 |
12491 | Caramel Frappuccino® 12491 | 88 88 | 720 | 770 | 2024-06-28 |
12492 | Dark Mocha Frappuccino® 12492 | 88 88 | 780 | 830 | 2024-06-28 |
12493 | Java Chip Frappuccino® 12493 | 88 88 | 780 | 830 | 2024-06-28 |
12494 | Mocha Frappuccino® 12494 | 88 88 | 720 | 770 | 2024-06-28 |
12495 | Caramel Macchiato Frappuccino® 12495 | 88 88 | 780 | 830 | 2024-06-28 |
12496 | Espresso Frappuccino® 12496 | 88 88 | 720 | 770 | 2024-06-28 |
12497 | White Chocolate Mocha Frappuccino® 12497 | 88 88 | 720 | 770 | 2024-06-28 |
12498 | Chocolate Chip Cream Frappuccino® 12498 | 88 88 | 780 | 830 | 2024-06-28 |
12499 | Hojicha Tea Cream Frappuccino® 12499 | 88 88 | 760 | 810 | 2024-06-28 |
12500 | Vanilla Cream Frappuccino® 12500 | 88 88 | 720 | 770 | 2024-06-28 |
12501 | Mango Passion Fruit & Hibiscus 12501 | 88 88 | 720 | 770 | 2024-06-28 |
12502 | Raspberry Black Currant & Oolong 12502 | 88 88 | 720 | 770 | 2024-06-28 |
12503 | Coffee Traveller 12503 | 88 88 | 3120 | 3170 | 2024-06-28 |
12504 | Caffè Americano 12504 | 88 88 | 540 | 590 | 2024-06-28 |
12505 | Cappuccino 12505 | 88 88 | 680 | 730 | 2024-06-28 |
12506 | Caffè Mocha 12506 | 88 88 | 750 | 800 | 2024-06-28 |
12507 | Caramel Macchiato 12507 | 88 88 | 760 | 810 | 2024-06-28 |
12508 | Espresso 12508 | 88 88 | 390 | 440 | 2024-06-28 |
12509 | Caffè Latte 12509 | 88 88 | 680 | 730 | 2024-06-28 |
12510 | Oatmilk Latte 12510 | 88 88 | 760 | 810 | 2024-06-28 |
12511 | Vanilla Latte 12511 | 88 88 | 750 | 800 | 2024-06-28 |
12512 | White Chocolate Mocha 12512 | 88 88 | 750 | 800 | 2024-06-28 |
12513 | Flat White 12513 | 88 88 | 760 | 810 | 2024-06-28 |
12514 | Ristretto Bianco 12514 | 88 88 | 760 | 810 | 2024-06-28 |
12515 | Iced Caffè Americano 12515 | 88 88 | 540 | 590 | 2024-06-28 |
12516 | Iced Cappuccino 12516 | 88 88 | 680 | 730 | 2024-06-28 |
12517 | Iced Caffè Mocha 12517 | 88 88 | 750 | 800 | 2024-06-28 |
12518 | Iced Caramel Macchiato 12518 | 88 88 | 760 | 810 | 2024-06-28 |
12519 | Iced Caffè Latte 12519 | 88 88 | 680 | 730 | 2024-06-28 |
12520 | Iced Oatmilk Latte 12520 | 88 88 | 760 | 810 | 2024-06-28 |
12521 | Iced Vanilla Latte 12521 | 88 88 | 750 | 800 | 2024-06-28 |
12522 | Iced White Chocolate Mocha 12522 | 88 88 | 750 | 800 | 2024-06-28 |
12523 | Signature Hot Chocolate 12523 | 88 88 | 720 | 770 | 2024-06-28 |
12524 | Signature Iced Chocolate 12524 | 88 88 | 720 | 770 | 2024-06-28 |
12525 | Carrot Juice 12525 | 88 88 | 490 | 540 | 2024-06-28 |
12526 | Cloudy Apple Juice 12526 | 88 88 | 490 | 540 | 2024-06-28 |
12527 | Cranberry Red Grapefruit Juice 12527 | 88 88 | 490 | 540 | 2024-06-28 |
12528 | Orange Juice 12528 | 88 88 | 490 | 540 | 2024-06-28 |
12529 | Evian 12529 | 88 88 | 350 | 400 | 2024-06-28 |
12530 | Sparkling Water 12530 | 88 88 | 450 | 500 | 2024-06-28 |
12531 | Chai Tea 12531 | 88 88 | 500 | 550 | 2024-06-28 |
12532 | Earl Grey Tea 12532 | 88 88 | 500 | 550 | 2024-06-28 |
12533 | English Breakfast Tea 12533 | 88 88 | 500 | 550 | 2024-06-28 |
12534 | Emperor’s Clouds & Mist™ Tea 12534 | 88 88 | 500 | 550 | 2024-06-28 |
12535 | Mint Blend Tea 12535 | 88 88 | 500 | 550 | 2024-06-28 |
12536 | Chamomile Tea 12536 | 88 88 | 500 | 550 | 2024-06-28 |
12537 | Pure Matcha Latte 12537 | 88 88 | 740 | 790 | 2024-06-28 |
12538 | Chai Tea Latte 12538 | 88 88 | 680 | 730 | 2024-06-28 |
12539 | Earl Grey Tea Latte 12539 | 88 88 | 680 | 730 | 2024-06-28 |
12540 | English Breakfast Tea Latte 12540 | 88 88 | 680 | 730 | 2024-06-28 |
12541 | Hojicha Tea Latte 12541 | 88 88 | 740 | 790 | 2024-06-28 |
12542 | Zen Clouds Oolong Tea 12542 | 88 88 | 500 | 550 | 2024-06-28 |
12543 | Zen Clouds Oolong with Ruby Grapefruit and Honey 12543 | 88 88 | 630 | 680 | 2024-06-28 |
12544 | Youthberry™ Tea 12544 | 88 88 | 500 | 550 | 2024-06-28 |
12545 | Iced Shaken Black Tea Lemonade 12545 | 88 88 | 610 | 660 | 2024-06-28 |
12546 | Iced Shaken Strawberry Black Tea Lemonade 12546 | 88 88 | 630 | 680 | 2024-06-28 |
12547 | Iced Shaken Hibiscus Tea Lemonade 12547 | 88 88 | 610 | 660 | 2024-06-28 |
12548 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 12548 | 88 88 | 730 | 780 | 2024-06-28 |
12549 | Iced Pure Matcha Latte 12549 | 88 88 | 740 | 790 | 2024-06-28 |
12550 | Iced Chai Tea Latte 12550 | 88 88 | 680 | 730 | 2024-06-28 |
12551 | Iced Black Tea Latte 12551 | 88 88 | 680 | 730 | 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");