item_prices

Pricing information for Starbucks menu items in Singapore

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

182 rows where effective_date = "2024-06-28" and store_id = 144

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 144 · 182 ✖

effective_date 1

  • 2024-06-28 · 182 ✖
id ▼ item_id store_id base_price delivery_price effective_date
3145 Bagel 3145 144 144 400 430 2024-06-28
3146 Cookie Crumble Cheesecake 3146 144 144 720 770 2024-06-28
3147 Good Ol' NY Cheesecake 3147 144 144 720 770 2024-06-28
3148 Signature Chocolate Cake 3148 144 144 720 770 2024-06-28
3149 Starbucks® Coffee Tiramisu Cake 3149 144 144 750 800 2024-06-28
3150 Strawberry Shortcake 3150 144 144 720 770 2024-06-28
3151 Chocolate Chunk Monster Cookie 3151 144 144 390 440 2024-06-28
3152 Banana Walnut Muffin 3152 144 144 450 500 2024-06-28
3153 Blueberry Crumble Muffin 3153 144 144 450 500 2024-06-28
3154 Chocolate Crumble Muffin 3154 144 144 450 500 2024-06-28
3155 Pancakes 3155 144 144 550 600 2024-06-28
3156 Almond Croissant 3156 144 144 470 520 2024-06-28
3157 Buttery Croissant 3157 144 144 400 430 2024-06-28
3158 Chocolate Croissant 3158 144 144 440 490 2024-06-28
3159 Creamy Chicken Foldover 3159 144 144 550 600 2024-06-28
3160 Sausage Roll 3160 144 144 550 600 2024-06-28
3161 Buttery Scone 3161 144 144 400 430 2024-06-28
3162 Country Chicken Pie 3162 144 144 690 740 2024-06-28
3163 Deep Dish Beef Pie 3163 144 144 690 740 2024-06-28
3164 Spinach & Mushroom Quiche 3164 144 144 690 740 2024-06-28
3165 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 3165 144 144 390 420 2024-06-28
3166 Mixed Nuts 3166 144 144 490 540 2024-06-28
3167 Caramel Waffles 3167 144 144 390 420 2024-06-28
3168 Chicken Ham & Cheese Panwich 3168 144 144 690 740 2024-06-28
3169 Egg Mayo & Cheese Multigrain Croissant 3169 144 144 690 740 2024-06-28
3170 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 3170 144 144 690 740 2024-06-28
3171 Rosemary Chicken & Emmental Cheese Croissant 3171 144 144 690 740 2024-06-28
3172 Scrambled Egg & Turkey Ham Pita 3172 144 144 690 740 2024-06-28
3173 Turkey Ham & Triple Cheese Toast 3173 144 144 690 740 2024-06-28
3174 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 3174 144 144 790 840 2024-06-28
3175 Ham & Cheese Croissant 3175 144 144 690 740 2024-06-28
3176 Sriracha Chicken Whole Wheat Pita 3176 144 144 750 800 2024-06-28
3177 Blueberry Acai Yogurt Parfait 3177 144 144 650 700 2024-06-28
3178 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 3178 144 144 650 700 2024-06-28
3179 Caramel Frappuccino® 3179 144 144 720 770 2024-06-28
3180 Dark Mocha Frappuccino® 3180 144 144 780 830 2024-06-28
3181 Java Chip Frappuccino® 3181 144 144 780 830 2024-06-28
3182 Mocha Frappuccino® 3182 144 144 720 770 2024-06-28
3183 Caramel Macchiato Frappuccino® 3183 144 144 780 830 2024-06-28
3184 Espresso Frappuccino® 3184 144 144 720 770 2024-06-28
3185 White Chocolate Mocha Frappuccino® 3185 144 144 720 770 2024-06-28
3186 Chocolate Chip Cream Frappuccino® 3186 144 144 780 830 2024-06-28
3187 Hojicha Tea Cream Frappuccino® 3187 144 144 760 810 2024-06-28
3188 Vanilla Cream Frappuccino® 3188 144 144 720 770 2024-06-28
3189 Mango Passion Fruit & Hibiscus 3189 144 144 720 770 2024-06-28
3190 Raspberry Black Currant & Oolong 3190 144 144 720 770 2024-06-28
3191 Coffee Traveller 3191 144 144 3120 3170 2024-06-28
3192 Caffè Americano 3192 144 144 540 590 2024-06-28
3193 Cappuccino 3193 144 144 680 730 2024-06-28
3194 Caffè Mocha 3194 144 144 750 800 2024-06-28
3195 Caramel Macchiato 3195 144 144 760 810 2024-06-28
3196 Espresso 3196 144 144 390 440 2024-06-28
3197 Caffè Latte 3197 144 144 680 730 2024-06-28
3198 Oatmilk Latte 3198 144 144 760 810 2024-06-28
3199 Vanilla Latte 3199 144 144 750 800 2024-06-28
3200 White Chocolate Mocha 3200 144 144 750 800 2024-06-28
3201 Flat White 3201 144 144 760 810 2024-06-28
3202 Ristretto Bianco 3202 144 144 760 810 2024-06-28
3203 Iced Caffè Americano 3203 144 144 540 590 2024-06-28
3204 Iced Cappuccino 3204 144 144 680 730 2024-06-28
3205 Iced Caffè Mocha 3205 144 144 750 800 2024-06-28
3206 Iced Caramel Macchiato 3206 144 144 760 810 2024-06-28
3207 Iced Caffè Latte 3207 144 144 680 730 2024-06-28
3208 Iced Oatmilk Latte 3208 144 144 760 810 2024-06-28
3209 Iced Vanilla Latte 3209 144 144 750 800 2024-06-28
3210 Iced White Chocolate Mocha 3210 144 144 750 800 2024-06-28
3211 Signature Hot Chocolate 3211 144 144 720 770 2024-06-28
3212 Signature Iced Chocolate 3212 144 144 720 770 2024-06-28
3213 Carrot Juice 3213 144 144 490 540 2024-06-28
3214 Cloudy Apple Juice 3214 144 144 490 540 2024-06-28
3215 Cranberry Red Grapefruit Juice 3215 144 144 490 540 2024-06-28
3216 Orange Juice 3216 144 144 490 540 2024-06-28
3217 Evian 3217 144 144 350 400 2024-06-28
3218 Sparkling Water 3218 144 144 450 500 2024-06-28
3219 Chai Tea 3219 144 144 500 550 2024-06-28
3220 Earl Grey Tea 3220 144 144 500 550 2024-06-28
3221 English Breakfast Tea 3221 144 144 500 550 2024-06-28
3222 Emperor’s Clouds & Mist™ Tea 3222 144 144 500 550 2024-06-28
3223 Mint Blend Tea 3223 144 144 500 550 2024-06-28
3224 Chamomile Tea 3224 144 144 500 550 2024-06-28
3225 Pure Matcha Latte 3225 144 144 740 790 2024-06-28
3226 Chai Tea Latte 3226 144 144 680 730 2024-06-28
3227 Earl Grey Tea Latte 3227 144 144 680 730 2024-06-28
3228 English Breakfast Tea Latte 3228 144 144 680 730 2024-06-28
3229 Hojicha Tea Latte 3229 144 144 740 790 2024-06-28
3230 Zen Clouds Oolong Tea 3230 144 144 500 550 2024-06-28
3231 Zen Clouds Oolong with Ruby Grapefruit and Honey 3231 144 144 630 680 2024-06-28
3232 Youthberry™ Tea 3232 144 144 500 550 2024-06-28
3233 Iced Shaken Black Tea Lemonade 3233 144 144 610 660 2024-06-28
3234 Iced Shaken Strawberry Black Tea Lemonade 3234 144 144 630 680 2024-06-28
3235 Iced Shaken Hibiscus Tea Lemonade 3235 144 144 610 660 2024-06-28
3236 Iced Shaken Hibiscus Tea with Pomegranate Pearls 3236 144 144 730 780 2024-06-28
3237 Iced Pure Matcha Latte 3237 144 144 740 790 2024-06-28
3238 Iced Chai Tea Latte 3238 144 144 680 730 2024-06-28
3239 Iced Black Tea Latte 3239 144 144 680 730 2024-06-28
3240 Iced Hojicha Tea Latte 3240 144 144 740 790 2024-06-28
3241 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 3241 144 144 630 680 2024-06-28
3242 Iced Shaken Zen Clouds Oolong Lemonade 3242 144 144 610 660 2024-06-28
3243 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 3243 144 144 630 680 2024-06-28
3244 Origami Pike Place® Roast 3244 144 144 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");