item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
253 rows where store_id = 147
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 13
- 2024-06-28 184
- 2024-11-10 14
- 2024-09-15 10
- 2024-11-03 9
- 2024-07-17 7
- 2024-08-18 6
- 2024-07-28 5
- 2024-10-13 5
- 2024-07-03 4
- 2024-10-06 4
- 2024-07-14 2
- 2024-09-29 2
- 2024-11-17 1
store_id 1
- 147 · 253 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 2595 | Bagel 2595 | 147 147 | 400 | 430 | 2024-06-28 |
| 2596 | Cookie Crumble Cheesecake 2596 | 147 147 | 720 | 770 | 2024-06-28 |
| 2597 | Good Ol' NY Cheesecake 2597 | 147 147 | 720 | 770 | 2024-06-28 |
| 2598 | Signature Chocolate Cake 2598 | 147 147 | 720 | 770 | 2024-06-28 |
| 2599 | Starbucks® Coffee Tiramisu Cake 2599 | 147 147 | 750 | 800 | 2024-06-28 |
| 2600 | Strawberry Shortcake 2600 | 147 147 | 720 | 770 | 2024-06-28 |
| 2601 | Chocolate Chunk Monster Cookie 2601 | 147 147 | 390 | 440 | 2024-06-28 |
| 2602 | Banana Walnut Muffin 2602 | 147 147 | 450 | 500 | 2024-06-28 |
| 2603 | Blueberry Crumble Muffin 2603 | 147 147 | 450 | 500 | 2024-06-28 |
| 2604 | Chocolate Crumble Muffin 2604 | 147 147 | 450 | 500 | 2024-06-28 |
| 2605 | Pancakes 2605 | 147 147 | 550 | 600 | 2024-06-28 |
| 2606 | Almond Croissant 2606 | 147 147 | 470 | 520 | 2024-06-28 |
| 2607 | Buttery Croissant 2607 | 147 147 | 400 | 430 | 2024-06-28 |
| 2608 | Chocolate Croissant 2608 | 147 147 | 440 | 490 | 2024-06-28 |
| 2609 | Creamy Chicken Foldover 2609 | 147 147 | 550 | 600 | 2024-06-28 |
| 2610 | Sausage Roll 2610 | 147 147 | 550 | 600 | 2024-06-28 |
| 2611 | Buttery Scone 2611 | 147 147 | 400 | 430 | 2024-06-28 |
| 2612 | Country Chicken Pie 2612 | 147 147 | 690 | 740 | 2024-06-28 |
| 2613 | Deep Dish Beef Pie 2613 | 147 147 | 690 | 740 | 2024-06-28 |
| 2614 | Spinach & Mushroom Quiche 2614 | 147 147 | 690 | 740 | 2024-06-28 |
| 2615 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 2615 | 147 147 | 390 | 420 | 2024-06-28 |
| 2616 | Mixed Nuts 2616 | 147 147 | 490 | 540 | 2024-06-28 |
| 2617 | Caramel Waffles 2617 | 147 147 | 390 | 420 | 2024-06-28 |
| 2618 | Chicken Ham & Cheese Panwich 2618 | 147 147 | 690 | 740 | 2024-06-28 |
| 2619 | Egg Mayo & Cheese Multigrain Croissant 2619 | 147 147 | 690 | 740 | 2024-06-28 |
| 2620 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 2620 | 147 147 | 690 | 740 | 2024-06-28 |
| 2621 | Rosemary Chicken & Emmental Cheese Croissant 2621 | 147 147 | 690 | 740 | 2024-06-28 |
| 2622 | Scrambled Egg & Turkey Ham Pita 2622 | 147 147 | 690 | 740 | 2024-06-28 |
| 2623 | Turkey Ham & Triple Cheese Toast 2623 | 147 147 | 690 | 740 | 2024-06-28 |
| 2624 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 2624 | 147 147 | 790 | 840 | 2024-06-28 |
| 2625 | Ham & Cheese Croissant 2625 | 147 147 | 690 | 740 | 2024-06-28 |
| 2626 | Sriracha Chicken Whole Wheat Pita 2626 | 147 147 | 750 | 800 | 2024-06-28 |
| 2627 | Blueberry Acai Yogurt Parfait 2627 | 147 147 | 650 | 700 | 2024-06-28 |
| 2628 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 2628 | 147 147 | 650 | 700 | 2024-06-28 |
| 2629 | Caramel Frappuccino® 2629 | 147 147 | 720 | 770 | 2024-06-28 |
| 2630 | Dark Mocha Frappuccino® 2630 | 147 147 | 780 | 830 | 2024-06-28 |
| 2631 | Java Chip Frappuccino® 2631 | 147 147 | 780 | 830 | 2024-06-28 |
| 2632 | Mocha Frappuccino® 2632 | 147 147 | 720 | 770 | 2024-06-28 |
| 2633 | Caramel Macchiato Frappuccino® 2633 | 147 147 | 780 | 830 | 2024-06-28 |
| 2634 | Espresso Frappuccino® 2634 | 147 147 | 720 | 770 | 2024-06-28 |
| 2635 | White Chocolate Mocha Frappuccino® 2635 | 147 147 | 720 | 770 | 2024-06-28 |
| 2636 | Chocolate Chip Cream Frappuccino® 2636 | 147 147 | 780 | 830 | 2024-06-28 |
| 2637 | Hojicha Tea Cream Frappuccino® 2637 | 147 147 | 760 | 810 | 2024-06-28 |
| 2638 | Vanilla Cream Frappuccino® 2638 | 147 147 | 720 | 770 | 2024-06-28 |
| 2639 | Mango Passion Fruit & Hibiscus 2639 | 147 147 | 720 | 770 | 2024-06-28 |
| 2640 | Raspberry Black Currant & Oolong 2640 | 147 147 | 720 | 770 | 2024-06-28 |
| 2641 | Coffee Traveller 2641 | 147 147 | 3120 | 3170 | 2024-06-28 |
| 2642 | Caffè Americano 2642 | 147 147 | 540 | 590 | 2024-06-28 |
| 2643 | Cappuccino 2643 | 147 147 | 680 | 730 | 2024-06-28 |
| 2644 | Caffè Mocha 2644 | 147 147 | 750 | 800 | 2024-06-28 |
| 2645 | Caramel Macchiato 2645 | 147 147 | 760 | 810 | 2024-06-28 |
| 2646 | Espresso 2646 | 147 147 | 390 | 440 | 2024-06-28 |
| 2647 | Caffè Latte 2647 | 147 147 | 680 | 730 | 2024-06-28 |
| 2648 | Oatmilk Latte 2648 | 147 147 | 760 | 810 | 2024-06-28 |
| 2649 | Vanilla Latte 2649 | 147 147 | 750 | 800 | 2024-06-28 |
| 2650 | White Chocolate Mocha 2650 | 147 147 | 750 | 800 | 2024-06-28 |
| 2651 | Flat White 2651 | 147 147 | 760 | 810 | 2024-06-28 |
| 2652 | Ristretto Bianco 2652 | 147 147 | 760 | 810 | 2024-06-28 |
| 2653 | Iced Caffè Americano 2653 | 147 147 | 540 | 590 | 2024-06-28 |
| 2654 | Iced Cappuccino 2654 | 147 147 | 680 | 730 | 2024-06-28 |
| 2655 | Iced Caffè Mocha 2655 | 147 147 | 750 | 800 | 2024-06-28 |
| 2656 | Iced Caramel Macchiato 2656 | 147 147 | 760 | 810 | 2024-06-28 |
| 2657 | Iced Caffè Latte 2657 | 147 147 | 680 | 730 | 2024-06-28 |
| 2658 | Iced Oatmilk Latte 2658 | 147 147 | 760 | 810 | 2024-06-28 |
| 2659 | Iced Vanilla Latte 2659 | 147 147 | 750 | 800 | 2024-06-28 |
| 2660 | Iced White Chocolate Mocha 2660 | 147 147 | 750 | 800 | 2024-06-28 |
| 2661 | Signature Hot Chocolate 2661 | 147 147 | 720 | 770 | 2024-06-28 |
| 2662 | Signature Iced Chocolate 2662 | 147 147 | 720 | 770 | 2024-06-28 |
| 2663 | Carrot Juice 2663 | 147 147 | 490 | 540 | 2024-06-28 |
| 2664 | Cloudy Apple Juice 2664 | 147 147 | 490 | 540 | 2024-06-28 |
| 2665 | Cranberry Red Grapefruit Juice 2665 | 147 147 | 490 | 540 | 2024-06-28 |
| 2666 | Orange Juice 2666 | 147 147 | 490 | 540 | 2024-06-28 |
| 2667 | Evian 2667 | 147 147 | 350 | 400 | 2024-06-28 |
| 2668 | Sparkling Water 2668 | 147 147 | 450 | 500 | 2024-06-28 |
| 2669 | Chai Tea 2669 | 147 147 | 500 | 550 | 2024-06-28 |
| 2670 | Earl Grey Tea 2670 | 147 147 | 500 | 550 | 2024-06-28 |
| 2671 | English Breakfast Tea 2671 | 147 147 | 500 | 550 | 2024-06-28 |
| 2672 | Emperor’s Clouds & Mist™ Tea 2672 | 147 147 | 500 | 550 | 2024-06-28 |
| 2673 | Mint Blend Tea 2673 | 147 147 | 500 | 550 | 2024-06-28 |
| 2674 | Chamomile Tea 2674 | 147 147 | 500 | 550 | 2024-06-28 |
| 2675 | Pure Matcha Latte 2675 | 147 147 | 740 | 790 | 2024-06-28 |
| 2676 | Chai Tea Latte 2676 | 147 147 | 680 | 730 | 2024-06-28 |
| 2677 | Earl Grey Tea Latte 2677 | 147 147 | 680 | 730 | 2024-06-28 |
| 2678 | English Breakfast Tea Latte 2678 | 147 147 | 680 | 730 | 2024-06-28 |
| 2679 | Hojicha Tea Latte 2679 | 147 147 | 740 | 790 | 2024-06-28 |
| 2680 | Zen Clouds Oolong Tea 2680 | 147 147 | 500 | 550 | 2024-06-28 |
| 2681 | Zen Clouds Oolong with Ruby Grapefruit and Honey 2681 | 147 147 | 630 | 680 | 2024-06-28 |
| 2682 | Youthberry™ Tea 2682 | 147 147 | 500 | 550 | 2024-06-28 |
| 2683 | Iced Shaken Black Tea Lemonade 2683 | 147 147 | 610 | 660 | 2024-06-28 |
| 2684 | Iced Shaken Strawberry Black Tea Lemonade 2684 | 147 147 | 630 | 680 | 2024-06-28 |
| 2685 | Iced Shaken Hibiscus Tea Lemonade 2685 | 147 147 | 610 | 660 | 2024-06-28 |
| 2686 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 2686 | 147 147 | 730 | 780 | 2024-06-28 |
| 2687 | Iced Pure Matcha Latte 2687 | 147 147 | 740 | 790 | 2024-06-28 |
| 2688 | Iced Chai Tea Latte 2688 | 147 147 | 680 | 730 | 2024-06-28 |
| 2689 | Iced Black Tea Latte 2689 | 147 147 | 680 | 730 | 2024-06-28 |
| 2690 | Iced Hojicha Tea Latte 2690 | 147 147 | 740 | 790 | 2024-06-28 |
| 2691 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 2691 | 147 147 | 630 | 680 | 2024-06-28 |
| 2692 | Iced Shaken Zen Clouds Oolong Lemonade 2692 | 147 147 | 610 | 660 | 2024-06-28 |
| 2693 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 2693 | 147 147 | 630 | 680 | 2024-06-28 |
| 2694 | Origami Pike Place® Roast 2694 | 147 147 | 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");