item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 36
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 11
- 2024-06-28 182
- 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
- 36 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 20521 | Bagel 20521 | 36 36 | 400 | 430 | 2024-06-28 |
| 20522 | Cookie Crumble Cheesecake 20522 | 36 36 | 720 | 770 | 2024-06-28 |
| 20523 | Good Ol' NY Cheesecake 20523 | 36 36 | 720 | 770 | 2024-06-28 |
| 20524 | Signature Chocolate Cake 20524 | 36 36 | 720 | 770 | 2024-06-28 |
| 20525 | Starbucks® Coffee Tiramisu Cake 20525 | 36 36 | 750 | 800 | 2024-06-28 |
| 20526 | Strawberry Shortcake 20526 | 36 36 | 720 | 770 | 2024-06-28 |
| 20527 | Chocolate Chunk Monster Cookie 20527 | 36 36 | 390 | 440 | 2024-06-28 |
| 20528 | Banana Walnut Muffin 20528 | 36 36 | 450 | 500 | 2024-06-28 |
| 20529 | Blueberry Crumble Muffin 20529 | 36 36 | 450 | 500 | 2024-06-28 |
| 20530 | Chocolate Crumble Muffin 20530 | 36 36 | 450 | 500 | 2024-06-28 |
| 20531 | Pancakes 20531 | 36 36 | 550 | 600 | 2024-06-28 |
| 20532 | Almond Croissant 20532 | 36 36 | 470 | 520 | 2024-06-28 |
| 20533 | Buttery Croissant 20533 | 36 36 | 400 | 430 | 2024-06-28 |
| 20534 | Chocolate Croissant 20534 | 36 36 | 440 | 490 | 2024-06-28 |
| 20535 | Creamy Chicken Foldover 20535 | 36 36 | 550 | 600 | 2024-06-28 |
| 20536 | Sausage Roll 20536 | 36 36 | 550 | 600 | 2024-06-28 |
| 20537 | Buttery Scone 20537 | 36 36 | 400 | 430 | 2024-06-28 |
| 20538 | Country Chicken Pie 20538 | 36 36 | 690 | 740 | 2024-06-28 |
| 20539 | Deep Dish Beef Pie 20539 | 36 36 | 690 | 740 | 2024-06-28 |
| 20540 | Spinach & Mushroom Quiche 20540 | 36 36 | 690 | 740 | 2024-06-28 |
| 20541 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 20541 | 36 36 | 390 | 420 | 2024-06-28 |
| 20542 | Mixed Nuts 20542 | 36 36 | 490 | 540 | 2024-06-28 |
| 20543 | Caramel Waffles 20543 | 36 36 | 390 | 420 | 2024-06-28 |
| 20544 | Chicken Ham & Cheese Panwich 20544 | 36 36 | 690 | 740 | 2024-06-28 |
| 20545 | Egg Mayo & Cheese Multigrain Croissant 20545 | 36 36 | 690 | 740 | 2024-06-28 |
| 20546 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 20546 | 36 36 | 690 | 740 | 2024-06-28 |
| 20547 | Rosemary Chicken & Emmental Cheese Croissant 20547 | 36 36 | 690 | 740 | 2024-06-28 |
| 20548 | Scrambled Egg & Turkey Ham Pita 20548 | 36 36 | 690 | 740 | 2024-06-28 |
| 20549 | Turkey Ham & Triple Cheese Toast 20549 | 36 36 | 690 | 740 | 2024-06-28 |
| 20550 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 20550 | 36 36 | 790 | 840 | 2024-06-28 |
| 20551 | Ham & Cheese Croissant 20551 | 36 36 | 690 | 740 | 2024-06-28 |
| 20552 | Sriracha Chicken Whole Wheat Pita 20552 | 36 36 | 750 | 800 | 2024-06-28 |
| 20553 | Blueberry Acai Yogurt Parfait 20553 | 36 36 | 650 | 700 | 2024-06-28 |
| 20554 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 20554 | 36 36 | 650 | 700 | 2024-06-28 |
| 20555 | Caramel Frappuccino® 20555 | 36 36 | 720 | 770 | 2024-06-28 |
| 20556 | Dark Mocha Frappuccino® 20556 | 36 36 | 780 | 830 | 2024-06-28 |
| 20557 | Java Chip Frappuccino® 20557 | 36 36 | 780 | 830 | 2024-06-28 |
| 20558 | Mocha Frappuccino® 20558 | 36 36 | 720 | 770 | 2024-06-28 |
| 20559 | Caramel Macchiato Frappuccino® 20559 | 36 36 | 780 | 830 | 2024-06-28 |
| 20560 | Espresso Frappuccino® 20560 | 36 36 | 720 | 770 | 2024-06-28 |
| 20561 | White Chocolate Mocha Frappuccino® 20561 | 36 36 | 720 | 770 | 2024-06-28 |
| 20562 | Chocolate Chip Cream Frappuccino® 20562 | 36 36 | 780 | 830 | 2024-06-28 |
| 20563 | Hojicha Tea Cream Frappuccino® 20563 | 36 36 | 760 | 810 | 2024-06-28 |
| 20564 | Vanilla Cream Frappuccino® 20564 | 36 36 | 720 | 770 | 2024-06-28 |
| 20565 | Mango Passion Fruit & Hibiscus 20565 | 36 36 | 720 | 770 | 2024-06-28 |
| 20566 | Raspberry Black Currant & Oolong 20566 | 36 36 | 720 | 770 | 2024-06-28 |
| 20567 | Coffee Traveller 20567 | 36 36 | 3120 | 3170 | 2024-06-28 |
| 20568 | Caffè Americano 20568 | 36 36 | 540 | 590 | 2024-06-28 |
| 20569 | Cappuccino 20569 | 36 36 | 680 | 730 | 2024-06-28 |
| 20570 | Caffè Mocha 20570 | 36 36 | 750 | 800 | 2024-06-28 |
| 20571 | Caramel Macchiato 20571 | 36 36 | 760 | 810 | 2024-06-28 |
| 20572 | Espresso 20572 | 36 36 | 390 | 440 | 2024-06-28 |
| 20573 | Caffè Latte 20573 | 36 36 | 680 | 730 | 2024-06-28 |
| 20574 | Oatmilk Latte 20574 | 36 36 | 760 | 810 | 2024-06-28 |
| 20575 | Vanilla Latte 20575 | 36 36 | 750 | 800 | 2024-06-28 |
| 20576 | White Chocolate Mocha 20576 | 36 36 | 750 | 800 | 2024-06-28 |
| 20577 | Flat White 20577 | 36 36 | 760 | 810 | 2024-06-28 |
| 20578 | Ristretto Bianco 20578 | 36 36 | 760 | 810 | 2024-06-28 |
| 20579 | Iced Caffè Americano 20579 | 36 36 | 540 | 590 | 2024-06-28 |
| 20580 | Iced Cappuccino 20580 | 36 36 | 680 | 730 | 2024-06-28 |
| 20581 | Iced Caffè Mocha 20581 | 36 36 | 750 | 800 | 2024-06-28 |
| 20582 | Iced Caramel Macchiato 20582 | 36 36 | 760 | 810 | 2024-06-28 |
| 20583 | Iced Caffè Latte 20583 | 36 36 | 680 | 730 | 2024-06-28 |
| 20584 | Iced Oatmilk Latte 20584 | 36 36 | 760 | 810 | 2024-06-28 |
| 20585 | Iced Vanilla Latte 20585 | 36 36 | 750 | 800 | 2024-06-28 |
| 20586 | Iced White Chocolate Mocha 20586 | 36 36 | 750 | 800 | 2024-06-28 |
| 20587 | Signature Hot Chocolate 20587 | 36 36 | 720 | 770 | 2024-06-28 |
| 20588 | Signature Iced Chocolate 20588 | 36 36 | 720 | 770 | 2024-06-28 |
| 20589 | Carrot Juice 20589 | 36 36 | 490 | 540 | 2024-06-28 |
| 20590 | Cloudy Apple Juice 20590 | 36 36 | 490 | 540 | 2024-06-28 |
| 20591 | Cranberry Red Grapefruit Juice 20591 | 36 36 | 490 | 540 | 2024-06-28 |
| 20592 | Orange Juice 20592 | 36 36 | 490 | 540 | 2024-06-28 |
| 20593 | Evian 20593 | 36 36 | 350 | 400 | 2024-06-28 |
| 20594 | Sparkling Water 20594 | 36 36 | 450 | 500 | 2024-06-28 |
| 20595 | Chai Tea 20595 | 36 36 | 500 | 550 | 2024-06-28 |
| 20596 | Earl Grey Tea 20596 | 36 36 | 500 | 550 | 2024-06-28 |
| 20597 | English Breakfast Tea 20597 | 36 36 | 500 | 550 | 2024-06-28 |
| 20598 | Emperor’s Clouds & Mist™ Tea 20598 | 36 36 | 500 | 550 | 2024-06-28 |
| 20599 | Mint Blend Tea 20599 | 36 36 | 500 | 550 | 2024-06-28 |
| 20600 | Chamomile Tea 20600 | 36 36 | 500 | 550 | 2024-06-28 |
| 20601 | Pure Matcha Latte 20601 | 36 36 | 740 | 790 | 2024-06-28 |
| 20602 | Chai Tea Latte 20602 | 36 36 | 680 | 730 | 2024-06-28 |
| 20603 | Earl Grey Tea Latte 20603 | 36 36 | 680 | 730 | 2024-06-28 |
| 20604 | English Breakfast Tea Latte 20604 | 36 36 | 680 | 730 | 2024-06-28 |
| 20605 | Hojicha Tea Latte 20605 | 36 36 | 740 | 790 | 2024-06-28 |
| 20606 | Zen Clouds Oolong Tea 20606 | 36 36 | 500 | 550 | 2024-06-28 |
| 20607 | Zen Clouds Oolong with Ruby Grapefruit and Honey 20607 | 36 36 | 630 | 680 | 2024-06-28 |
| 20608 | Youthberry™ Tea 20608 | 36 36 | 500 | 550 | 2024-06-28 |
| 20609 | Iced Shaken Black Tea Lemonade 20609 | 36 36 | 610 | 660 | 2024-06-28 |
| 20610 | Iced Shaken Strawberry Black Tea Lemonade 20610 | 36 36 | 630 | 680 | 2024-06-28 |
| 20611 | Iced Shaken Hibiscus Tea Lemonade 20611 | 36 36 | 610 | 660 | 2024-06-28 |
| 20612 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 20612 | 36 36 | 730 | 780 | 2024-06-28 |
| 20613 | Iced Pure Matcha Latte 20613 | 36 36 | 740 | 790 | 2024-06-28 |
| 20614 | Iced Chai Tea Latte 20614 | 36 36 | 680 | 730 | 2024-06-28 |
| 20615 | Iced Black Tea Latte 20615 | 36 36 | 680 | 730 | 2024-06-28 |
| 20616 | Iced Hojicha Tea Latte 20616 | 36 36 | 740 | 790 | 2024-06-28 |
| 20617 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 20617 | 36 36 | 630 | 680 | 2024-06-28 |
| 20618 | Iced Shaken Zen Clouds Oolong Lemonade 20618 | 36 36 | 610 | 660 | 2024-06-28 |
| 20619 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 20619 | 36 36 | 630 | 680 | 2024-06-28 |
| 20620 | Origami Pike Place® Roast 20620 | 36 36 | 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");