item_prices

Pricing information for Starbucks menu items in Singapore

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

238 rows where store_id = 145

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 145 · 238 ✖
id ▼ item_id store_id base_price delivery_price effective_date
2961 Bagel 2961 145 145 400 430 2024-06-28
2962 Cookie Crumble Cheesecake 2962 145 145 720 770 2024-06-28
2963 Good Ol' NY Cheesecake 2963 145 145 720 770 2024-06-28
2964 Signature Chocolate Cake 2964 145 145 720 770 2024-06-28
2965 Starbucks® Coffee Tiramisu Cake 2965 145 145 750 800 2024-06-28
2966 Strawberry Shortcake 2966 145 145 720 770 2024-06-28
2967 Chocolate Chunk Monster Cookie 2967 145 145 390 440 2024-06-28
2968 Banana Walnut Muffin 2968 145 145 450 500 2024-06-28
2969 Blueberry Crumble Muffin 2969 145 145 450 500 2024-06-28
2970 Chocolate Crumble Muffin 2970 145 145 450 500 2024-06-28
2971 Pancakes 2971 145 145 550 600 2024-06-28
2972 Almond Croissant 2972 145 145 470 520 2024-06-28
2973 Buttery Croissant 2973 145 145 400 430 2024-06-28
2974 Chocolate Croissant 2974 145 145 440 490 2024-06-28
2975 Creamy Chicken Foldover 2975 145 145 550 600 2024-06-28
2976 Sausage Roll 2976 145 145 550 600 2024-06-28
2977 Buttery Scone 2977 145 145 400 430 2024-06-28
2978 Country Chicken Pie 2978 145 145 690 740 2024-06-28
2979 Deep Dish Beef Pie 2979 145 145 690 740 2024-06-28
2980 Spinach & Mushroom Quiche 2980 145 145 690 740 2024-06-28
2981 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 2981 145 145 390 420 2024-06-28
2982 Mixed Nuts 2982 145 145 490 540 2024-06-28
2983 Caramel Waffles 2983 145 145 390 420 2024-06-28
2984 Chicken Ham & Cheese Panwich 2984 145 145 690 740 2024-06-28
2985 Egg Mayo & Cheese Multigrain Croissant 2985 145 145 690 740 2024-06-28
2986 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 2986 145 145 690 740 2024-06-28
2987 Rosemary Chicken & Emmental Cheese Croissant 2987 145 145 690 740 2024-06-28
2988 Scrambled Egg & Turkey Ham Pita 2988 145 145 690 740 2024-06-28
2989 Turkey Ham & Triple Cheese Toast 2989 145 145 690 740 2024-06-28
2990 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 2990 145 145 790 840 2024-06-28
2991 Ham & Cheese Croissant 2991 145 145 690 740 2024-06-28
2992 Sriracha Chicken Whole Wheat Pita 2992 145 145 750 800 2024-06-28
2993 Blueberry Acai Yogurt Parfait 2993 145 145 650 700 2024-06-28
2994 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 2994 145 145 650 700 2024-06-28
2995 Caramel Frappuccino® 2995 145 145 720 770 2024-06-28
2996 Dark Mocha Frappuccino® 2996 145 145 780 830 2024-06-28
2997 Java Chip Frappuccino® 2997 145 145 780 830 2024-06-28
2998 Mocha Frappuccino® 2998 145 145 720 770 2024-06-28
2999 Caramel Macchiato Frappuccino® 2999 145 145 780 830 2024-06-28
3000 Espresso Frappuccino® 3000 145 145 720 770 2024-06-28
3001 White Chocolate Mocha Frappuccino® 3001 145 145 720 770 2024-06-28
3002 Chocolate Chip Cream Frappuccino® 3002 145 145 780 830 2024-06-28
3003 Hojicha Tea Cream Frappuccino® 3003 145 145 760 810 2024-06-28
3004 Vanilla Cream Frappuccino® 3004 145 145 720 770 2024-06-28
3005 Mango Passion Fruit & Hibiscus 3005 145 145 720 770 2024-06-28
3006 Raspberry Black Currant & Oolong 3006 145 145 720 770 2024-06-28
3007 Coffee Traveller 3007 145 145 3120 3170 2024-06-28
3008 Caffè Americano 3008 145 145 540 590 2024-06-28
3009 Cappuccino 3009 145 145 680 730 2024-06-28
3010 Caffè Mocha 3010 145 145 750 800 2024-06-28
3011 Caramel Macchiato 3011 145 145 760 810 2024-06-28
3012 Espresso 3012 145 145 390 440 2024-06-28
3013 Caffè Latte 3013 145 145 680 730 2024-06-28
3014 Oatmilk Latte 3014 145 145 760 810 2024-06-28
3015 Vanilla Latte 3015 145 145 750 800 2024-06-28
3016 White Chocolate Mocha 3016 145 145 750 800 2024-06-28
3017 Flat White 3017 145 145 760 810 2024-06-28
3018 Ristretto Bianco 3018 145 145 760 810 2024-06-28
3019 Iced Caffè Americano 3019 145 145 540 590 2024-06-28
3020 Iced Cappuccino 3020 145 145 680 730 2024-06-28
3021 Iced Caffè Mocha 3021 145 145 750 800 2024-06-28
3022 Iced Caramel Macchiato 3022 145 145 760 810 2024-06-28
3023 Iced Caffè Latte 3023 145 145 680 730 2024-06-28
3024 Iced Oatmilk Latte 3024 145 145 760 810 2024-06-28
3025 Iced Vanilla Latte 3025 145 145 750 800 2024-06-28
3026 Iced White Chocolate Mocha 3026 145 145 750 800 2024-06-28
3027 Signature Hot Chocolate 3027 145 145 720 770 2024-06-28
3028 Signature Iced Chocolate 3028 145 145 720 770 2024-06-28
3029 Carrot Juice 3029 145 145 490 540 2024-06-28
3030 Cloudy Apple Juice 3030 145 145 490 540 2024-06-28
3031 Cranberry Red Grapefruit Juice 3031 145 145 490 540 2024-06-28
3032 Orange Juice 3032 145 145 490 540 2024-06-28
3033 Evian 3033 145 145 350 400 2024-06-28
3034 Sparkling Water 3034 145 145 450 500 2024-06-28
3035 Chai Tea 3035 145 145 500 550 2024-06-28
3036 Earl Grey Tea 3036 145 145 500 550 2024-06-28
3037 English Breakfast Tea 3037 145 145 500 550 2024-06-28
3038 Emperor’s Clouds & Mist™ Tea 3038 145 145 500 550 2024-06-28
3039 Mint Blend Tea 3039 145 145 500 550 2024-06-28
3040 Chamomile Tea 3040 145 145 500 550 2024-06-28
3041 Pure Matcha Latte 3041 145 145 740 790 2024-06-28
3042 Chai Tea Latte 3042 145 145 680 730 2024-06-28
3043 Earl Grey Tea Latte 3043 145 145 680 730 2024-06-28
3044 English Breakfast Tea Latte 3044 145 145 680 730 2024-06-28
3045 Hojicha Tea Latte 3045 145 145 740 790 2024-06-28
3046 Zen Clouds Oolong Tea 3046 145 145 500 550 2024-06-28
3047 Zen Clouds Oolong with Ruby Grapefruit and Honey 3047 145 145 630 680 2024-06-28
3048 Youthberry™ Tea 3048 145 145 500 550 2024-06-28
3049 Iced Shaken Black Tea Lemonade 3049 145 145 610 660 2024-06-28
3050 Iced Shaken Strawberry Black Tea Lemonade 3050 145 145 630 680 2024-06-28
3051 Iced Shaken Hibiscus Tea Lemonade 3051 145 145 610 660 2024-06-28
3052 Iced Shaken Hibiscus Tea with Pomegranate Pearls 3052 145 145 730 780 2024-06-28
3053 Iced Pure Matcha Latte 3053 145 145 740 790 2024-06-28
3054 Iced Chai Tea Latte 3054 145 145 680 730 2024-06-28
3055 Iced Black Tea Latte 3055 145 145 680 730 2024-06-28
3056 Iced Hojicha Tea Latte 3056 145 145 740 790 2024-06-28
3057 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 3057 145 145 630 680 2024-06-28
3058 Iced Shaken Zen Clouds Oolong Lemonade 3058 145 145 610 660 2024-06-28
3059 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 3059 145 145 630 680 2024-06-28
3060 Origami Pike Place® Roast 3060 145 145 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");