item_prices

Pricing information for Starbucks menu items in Singapore

Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com

229 rows where store_id = 147

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 147 · 229 ✖
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");