item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
249 rows where store_id = 93
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 13
- 2024-06-28 182
- 2024-11-10 14
- 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
- 2024-11-17 1
store_id 1
- 93 · 249 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 11536 | Bagel 11536 | 93 93 | 400 | 430 | 2024-06-28 |
| 11537 | Cookie Crumble Cheesecake 11537 | 93 93 | 720 | 770 | 2024-06-28 |
| 11538 | Good Ol' NY Cheesecake 11538 | 93 93 | 720 | 770 | 2024-06-28 |
| 11539 | Signature Chocolate Cake 11539 | 93 93 | 720 | 770 | 2024-06-28 |
| 11540 | Starbucks® Coffee Tiramisu Cake 11540 | 93 93 | 750 | 800 | 2024-06-28 |
| 11541 | Strawberry Shortcake 11541 | 93 93 | 720 | 770 | 2024-06-28 |
| 11542 | Chocolate Chunk Monster Cookie 11542 | 93 93 | 390 | 440 | 2024-06-28 |
| 11543 | Banana Walnut Muffin 11543 | 93 93 | 450 | 500 | 2024-06-28 |
| 11544 | Blueberry Crumble Muffin 11544 | 93 93 | 450 | 500 | 2024-06-28 |
| 11545 | Chocolate Crumble Muffin 11545 | 93 93 | 450 | 500 | 2024-06-28 |
| 11546 | Pancakes 11546 | 93 93 | 550 | 600 | 2024-06-28 |
| 11547 | Almond Croissant 11547 | 93 93 | 470 | 520 | 2024-06-28 |
| 11548 | Buttery Croissant 11548 | 93 93 | 400 | 430 | 2024-06-28 |
| 11549 | Chocolate Croissant 11549 | 93 93 | 440 | 490 | 2024-06-28 |
| 11550 | Creamy Chicken Foldover 11550 | 93 93 | 550 | 600 | 2024-06-28 |
| 11551 | Sausage Roll 11551 | 93 93 | 550 | 600 | 2024-06-28 |
| 11552 | Buttery Scone 11552 | 93 93 | 400 | 430 | 2024-06-28 |
| 11553 | Country Chicken Pie 11553 | 93 93 | 690 | 740 | 2024-06-28 |
| 11554 | Deep Dish Beef Pie 11554 | 93 93 | 690 | 740 | 2024-06-28 |
| 11555 | Spinach & Mushroom Quiche 11555 | 93 93 | 690 | 740 | 2024-06-28 |
| 11556 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 11556 | 93 93 | 390 | 420 | 2024-06-28 |
| 11557 | Mixed Nuts 11557 | 93 93 | 490 | 540 | 2024-06-28 |
| 11558 | Caramel Waffles 11558 | 93 93 | 390 | 420 | 2024-06-28 |
| 11559 | Chicken Ham & Cheese Panwich 11559 | 93 93 | 690 | 740 | 2024-06-28 |
| 11560 | Egg Mayo & Cheese Multigrain Croissant 11560 | 93 93 | 690 | 740 | 2024-06-28 |
| 11561 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 11561 | 93 93 | 690 | 740 | 2024-06-28 |
| 11562 | Rosemary Chicken & Emmental Cheese Croissant 11562 | 93 93 | 690 | 740 | 2024-06-28 |
| 11563 | Scrambled Egg & Turkey Ham Pita 11563 | 93 93 | 690 | 740 | 2024-06-28 |
| 11564 | Turkey Ham & Triple Cheese Toast 11564 | 93 93 | 690 | 740 | 2024-06-28 |
| 11565 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 11565 | 93 93 | 790 | 840 | 2024-06-28 |
| 11566 | Ham & Cheese Croissant 11566 | 93 93 | 690 | 740 | 2024-06-28 |
| 11567 | Sriracha Chicken Whole Wheat Pita 11567 | 93 93 | 750 | 800 | 2024-06-28 |
| 11568 | Blueberry Acai Yogurt Parfait 11568 | 93 93 | 650 | 700 | 2024-06-28 |
| 11569 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 11569 | 93 93 | 650 | 700 | 2024-06-28 |
| 11570 | Caramel Frappuccino® 11570 | 93 93 | 720 | 770 | 2024-06-28 |
| 11571 | Dark Mocha Frappuccino® 11571 | 93 93 | 780 | 830 | 2024-06-28 |
| 11572 | Java Chip Frappuccino® 11572 | 93 93 | 780 | 830 | 2024-06-28 |
| 11573 | Mocha Frappuccino® 11573 | 93 93 | 720 | 770 | 2024-06-28 |
| 11574 | Caramel Macchiato Frappuccino® 11574 | 93 93 | 780 | 830 | 2024-06-28 |
| 11575 | Espresso Frappuccino® 11575 | 93 93 | 720 | 770 | 2024-06-28 |
| 11576 | White Chocolate Mocha Frappuccino® 11576 | 93 93 | 720 | 770 | 2024-06-28 |
| 11577 | Chocolate Chip Cream Frappuccino® 11577 | 93 93 | 780 | 830 | 2024-06-28 |
| 11578 | Hojicha Tea Cream Frappuccino® 11578 | 93 93 | 760 | 810 | 2024-06-28 |
| 11579 | Vanilla Cream Frappuccino® 11579 | 93 93 | 720 | 770 | 2024-06-28 |
| 11580 | Mango Passion Fruit & Hibiscus 11580 | 93 93 | 720 | 770 | 2024-06-28 |
| 11581 | Raspberry Black Currant & Oolong 11581 | 93 93 | 720 | 770 | 2024-06-28 |
| 11582 | Coffee Traveller 11582 | 93 93 | 3120 | 3170 | 2024-06-28 |
| 11583 | Caffè Americano 11583 | 93 93 | 540 | 590 | 2024-06-28 |
| 11584 | Cappuccino 11584 | 93 93 | 680 | 730 | 2024-06-28 |
| 11585 | Caffè Mocha 11585 | 93 93 | 750 | 800 | 2024-06-28 |
| 11586 | Caramel Macchiato 11586 | 93 93 | 760 | 810 | 2024-06-28 |
| 11587 | Espresso 11587 | 93 93 | 390 | 440 | 2024-06-28 |
| 11588 | Caffè Latte 11588 | 93 93 | 680 | 730 | 2024-06-28 |
| 11589 | Oatmilk Latte 11589 | 93 93 | 760 | 810 | 2024-06-28 |
| 11590 | Vanilla Latte 11590 | 93 93 | 750 | 800 | 2024-06-28 |
| 11591 | White Chocolate Mocha 11591 | 93 93 | 750 | 800 | 2024-06-28 |
| 11592 | Flat White 11592 | 93 93 | 760 | 810 | 2024-06-28 |
| 11593 | Ristretto Bianco 11593 | 93 93 | 760 | 810 | 2024-06-28 |
| 11594 | Iced Caffè Americano 11594 | 93 93 | 540 | 590 | 2024-06-28 |
| 11595 | Iced Cappuccino 11595 | 93 93 | 680 | 730 | 2024-06-28 |
| 11596 | Iced Caffè Mocha 11596 | 93 93 | 750 | 800 | 2024-06-28 |
| 11597 | Iced Caramel Macchiato 11597 | 93 93 | 760 | 810 | 2024-06-28 |
| 11598 | Iced Caffè Latte 11598 | 93 93 | 680 | 730 | 2024-06-28 |
| 11599 | Iced Oatmilk Latte 11599 | 93 93 | 760 | 810 | 2024-06-28 |
| 11600 | Iced Vanilla Latte 11600 | 93 93 | 750 | 800 | 2024-06-28 |
| 11601 | Iced White Chocolate Mocha 11601 | 93 93 | 750 | 800 | 2024-06-28 |
| 11602 | Signature Hot Chocolate 11602 | 93 93 | 720 | 770 | 2024-06-28 |
| 11603 | Signature Iced Chocolate 11603 | 93 93 | 720 | 770 | 2024-06-28 |
| 11604 | Carrot Juice 11604 | 93 93 | 490 | 540 | 2024-06-28 |
| 11605 | Cloudy Apple Juice 11605 | 93 93 | 490 | 540 | 2024-06-28 |
| 11606 | Cranberry Red Grapefruit Juice 11606 | 93 93 | 490 | 540 | 2024-06-28 |
| 11607 | Orange Juice 11607 | 93 93 | 490 | 540 | 2024-06-28 |
| 11608 | Evian 11608 | 93 93 | 350 | 400 | 2024-06-28 |
| 11609 | Sparkling Water 11609 | 93 93 | 450 | 500 | 2024-06-28 |
| 11610 | Chai Tea 11610 | 93 93 | 500 | 550 | 2024-06-28 |
| 11611 | Earl Grey Tea 11611 | 93 93 | 500 | 550 | 2024-06-28 |
| 11612 | English Breakfast Tea 11612 | 93 93 | 500 | 550 | 2024-06-28 |
| 11613 | Emperor’s Clouds & Mist™ Tea 11613 | 93 93 | 500 | 550 | 2024-06-28 |
| 11614 | Mint Blend Tea 11614 | 93 93 | 500 | 550 | 2024-06-28 |
| 11615 | Chamomile Tea 11615 | 93 93 | 500 | 550 | 2024-06-28 |
| 11616 | Pure Matcha Latte 11616 | 93 93 | 740 | 790 | 2024-06-28 |
| 11617 | Chai Tea Latte 11617 | 93 93 | 680 | 730 | 2024-06-28 |
| 11618 | Earl Grey Tea Latte 11618 | 93 93 | 680 | 730 | 2024-06-28 |
| 11619 | English Breakfast Tea Latte 11619 | 93 93 | 680 | 730 | 2024-06-28 |
| 11620 | Hojicha Tea Latte 11620 | 93 93 | 740 | 790 | 2024-06-28 |
| 11621 | Zen Clouds Oolong Tea 11621 | 93 93 | 500 | 550 | 2024-06-28 |
| 11622 | Zen Clouds Oolong with Ruby Grapefruit and Honey 11622 | 93 93 | 630 | 680 | 2024-06-28 |
| 11623 | Youthberry™ Tea 11623 | 93 93 | 500 | 550 | 2024-06-28 |
| 11624 | Iced Shaken Black Tea Lemonade 11624 | 93 93 | 610 | 660 | 2024-06-28 |
| 11625 | Iced Shaken Strawberry Black Tea Lemonade 11625 | 93 93 | 630 | 680 | 2024-06-28 |
| 11626 | Iced Shaken Hibiscus Tea Lemonade 11626 | 93 93 | 610 | 660 | 2024-06-28 |
| 11627 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 11627 | 93 93 | 730 | 780 | 2024-06-28 |
| 11628 | Iced Pure Matcha Latte 11628 | 93 93 | 740 | 790 | 2024-06-28 |
| 11629 | Iced Chai Tea Latte 11629 | 93 93 | 680 | 730 | 2024-06-28 |
| 11630 | Iced Black Tea Latte 11630 | 93 93 | 680 | 730 | 2024-06-28 |
| 11631 | Iced Hojicha Tea Latte 11631 | 93 93 | 740 | 790 | 2024-06-28 |
| 11632 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 11632 | 93 93 | 630 | 680 | 2024-06-28 |
| 11633 | Iced Shaken Zen Clouds Oolong Lemonade 11633 | 93 93 | 610 | 660 | 2024-06-28 |
| 11634 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 11634 | 93 93 | 630 | 680 | 2024-06-28 |
| 11635 | Origami Pike Place® Roast 11635 | 93 93 | 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");