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 = 141

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 141 · 182 ✖

effective_date 1

  • 2024-06-28 · 182 ✖
id ▼ item_id store_id base_price delivery_price effective_date
2209 Bagel 2209 141 141 400 430 2024-06-28
2210 Cookie Crumble Cheesecake 2210 141 141 720 770 2024-06-28
2211 Good Ol' NY Cheesecake 2211 141 141 720 770 2024-06-28
2212 Signature Chocolate Cake 2212 141 141 720 770 2024-06-28
2213 Starbucks® Coffee Tiramisu Cake 2213 141 141 750 800 2024-06-28
2214 Strawberry Shortcake 2214 141 141 720 770 2024-06-28
2215 Chocolate Chunk Monster Cookie 2215 141 141 390 440 2024-06-28
2216 Banana Walnut Muffin 2216 141 141 450 500 2024-06-28
2217 Blueberry Crumble Muffin 2217 141 141 450 500 2024-06-28
2218 Chocolate Crumble Muffin 2218 141 141 450 500 2024-06-28
2219 Pancakes 2219 141 141 550 600 2024-06-28
2220 Almond Croissant 2220 141 141 470 520 2024-06-28
2221 Buttery Croissant 2221 141 141 400 430 2024-06-28
2222 Chocolate Croissant 2222 141 141 440 490 2024-06-28
2223 Creamy Chicken Foldover 2223 141 141 550 600 2024-06-28
2224 Sausage Roll 2224 141 141 550 600 2024-06-28
2225 Buttery Scone 2225 141 141 400 430 2024-06-28
2226 Country Chicken Pie 2226 141 141 690 740 2024-06-28
2227 Deep Dish Beef Pie 2227 141 141 690 740 2024-06-28
2228 Spinach & Mushroom Quiche 2228 141 141 690 740 2024-06-28
2229 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 2229 141 141 390 420 2024-06-28
2230 Mixed Nuts 2230 141 141 490 540 2024-06-28
2231 Caramel Waffles 2231 141 141 390 420 2024-06-28
2232 Chicken Ham & Cheese Panwich 2232 141 141 690 740 2024-06-28
2233 Egg Mayo & Cheese Multigrain Croissant 2233 141 141 690 740 2024-06-28
2234 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 2234 141 141 690 740 2024-06-28
2235 Rosemary Chicken & Emmental Cheese Croissant 2235 141 141 690 740 2024-06-28
2236 Scrambled Egg & Turkey Ham Pita 2236 141 141 690 740 2024-06-28
2237 Turkey Ham & Triple Cheese Toast 2237 141 141 690 740 2024-06-28
2238 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 2238 141 141 790 840 2024-06-28
2239 Ham & Cheese Croissant 2239 141 141 690 740 2024-06-28
2240 Sriracha Chicken Whole Wheat Pita 2240 141 141 750 800 2024-06-28
2241 Blueberry Acai Yogurt Parfait 2241 141 141 650 700 2024-06-28
2242 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 2242 141 141 650 700 2024-06-28
2243 Caramel Frappuccino® 2243 141 141 720 770 2024-06-28
2244 Dark Mocha Frappuccino® 2244 141 141 780 830 2024-06-28
2245 Java Chip Frappuccino® 2245 141 141 780 830 2024-06-28
2246 Mocha Frappuccino® 2246 141 141 720 770 2024-06-28
2247 Caramel Macchiato Frappuccino® 2247 141 141 780 830 2024-06-28
2248 Espresso Frappuccino® 2248 141 141 720 770 2024-06-28
2249 White Chocolate Mocha Frappuccino® 2249 141 141 720 770 2024-06-28
2250 Chocolate Chip Cream Frappuccino® 2250 141 141 780 830 2024-06-28
2251 Hojicha Tea Cream Frappuccino® 2251 141 141 760 810 2024-06-28
2252 Vanilla Cream Frappuccino® 2252 141 141 720 770 2024-06-28
2253 Mango Passion Fruit & Hibiscus 2253 141 141 720 770 2024-06-28
2254 Raspberry Black Currant & Oolong 2254 141 141 720 770 2024-06-28
2255 Coffee Traveller 2255 141 141 3120 3170 2024-06-28
2256 Caffè Americano 2256 141 141 540 590 2024-06-28
2257 Cappuccino 2257 141 141 680 730 2024-06-28
2258 Caffè Mocha 2258 141 141 750 800 2024-06-28
2259 Caramel Macchiato 2259 141 141 760 810 2024-06-28
2260 Espresso 2260 141 141 390 440 2024-06-28
2261 Caffè Latte 2261 141 141 680 730 2024-06-28
2262 Oatmilk Latte 2262 141 141 760 810 2024-06-28
2263 Vanilla Latte 2263 141 141 750 800 2024-06-28
2264 White Chocolate Mocha 2264 141 141 750 800 2024-06-28
2265 Flat White 2265 141 141 760 810 2024-06-28
2266 Ristretto Bianco 2266 141 141 760 810 2024-06-28
2267 Iced Caffè Americano 2267 141 141 540 590 2024-06-28
2268 Iced Cappuccino 2268 141 141 680 730 2024-06-28
2269 Iced Caffè Mocha 2269 141 141 750 800 2024-06-28
2270 Iced Caramel Macchiato 2270 141 141 760 810 2024-06-28
2271 Iced Caffè Latte 2271 141 141 680 730 2024-06-28
2272 Iced Oatmilk Latte 2272 141 141 760 810 2024-06-28
2273 Iced Vanilla Latte 2273 141 141 750 800 2024-06-28
2274 Iced White Chocolate Mocha 2274 141 141 750 800 2024-06-28
2275 Signature Hot Chocolate 2275 141 141 720 770 2024-06-28
2276 Signature Iced Chocolate 2276 141 141 720 770 2024-06-28
2277 Carrot Juice 2277 141 141 490 540 2024-06-28
2278 Cloudy Apple Juice 2278 141 141 490 540 2024-06-28
2279 Cranberry Red Grapefruit Juice 2279 141 141 490 540 2024-06-28
2280 Orange Juice 2280 141 141 490 540 2024-06-28
2281 Evian 2281 141 141 350 400 2024-06-28
2282 Sparkling Water 2282 141 141 450 500 2024-06-28
2283 Chai Tea 2283 141 141 500 550 2024-06-28
2284 Earl Grey Tea 2284 141 141 500 550 2024-06-28
2285 English Breakfast Tea 2285 141 141 500 550 2024-06-28
2286 Emperor’s Clouds & Mist™ Tea 2286 141 141 500 550 2024-06-28
2287 Mint Blend Tea 2287 141 141 500 550 2024-06-28
2288 Chamomile Tea 2288 141 141 500 550 2024-06-28
2289 Pure Matcha Latte 2289 141 141 740 790 2024-06-28
2290 Chai Tea Latte 2290 141 141 680 730 2024-06-28
2291 Earl Grey Tea Latte 2291 141 141 680 730 2024-06-28
2292 English Breakfast Tea Latte 2292 141 141 680 730 2024-06-28
2293 Hojicha Tea Latte 2293 141 141 740 790 2024-06-28
2294 Zen Clouds Oolong Tea 2294 141 141 500 550 2024-06-28
2295 Zen Clouds Oolong with Ruby Grapefruit and Honey 2295 141 141 630 680 2024-06-28
2296 Youthberry™ Tea 2296 141 141 500 550 2024-06-28
2297 Iced Shaken Black Tea Lemonade 2297 141 141 610 660 2024-06-28
2298 Iced Shaken Strawberry Black Tea Lemonade 2298 141 141 630 680 2024-06-28
2299 Iced Shaken Hibiscus Tea Lemonade 2299 141 141 610 660 2024-06-28
2300 Iced Shaken Hibiscus Tea with Pomegranate Pearls 2300 141 141 730 780 2024-06-28
2301 Iced Pure Matcha Latte 2301 141 141 740 790 2024-06-28
2302 Iced Chai Tea Latte 2302 141 141 680 730 2024-06-28
2303 Iced Black Tea Latte 2303 141 141 680 730 2024-06-28
2304 Iced Hojicha Tea Latte 2304 141 141 740 790 2024-06-28
2305 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 2305 141 141 630 680 2024-06-28
2306 Iced Shaken Zen Clouds Oolong Lemonade 2306 141 141 610 660 2024-06-28
2307 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 2307 141 141 630 680 2024-06-28
2308 Origami Pike Place® Roast 2308 141 141 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");