item_prices

Pricing information for Starbucks menu items in Singapore

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

251 rows where store_id = 45

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 45 · 251 ✖
id ▼ item_id store_id base_price delivery_price effective_date
19245 Bagel 19245 45 45 360 390 2024-06-28
19246 Cookie Crumble Cheesecake 19246 45 45 650 700 2024-06-28
19247 Good Ol' NY Cheesecake 19247 45 45 650 700 2024-06-28
19248 Signature Chocolate Cake 19248 45 45 650 700 2024-06-28
19249 Starbucks® Coffee Tiramisu Cake 19249 45 45 670 720 2024-06-28
19250 Strawberry Shortcake 19250 45 45 650 700 2024-06-28
19251 Chocolate Chunk Monster Cookie 19251 45 45 350 400 2024-06-28
19252 Banana Walnut Muffin 19252 45 45 400 450 2024-06-28
19253 Blueberry Crumble Muffin 19253 45 45 400 450 2024-06-28
19254 Chocolate Crumble Muffin 19254 45 45 400 450 2024-06-28
19255 Pancakes 19255 45 45 490 540 2024-06-28
19256 Almond Croissant 19256 45 45 420 470 2024-06-28
19257 Buttery Croissant 19257 45 45 360 390 2024-06-28
19258 Chocolate Croissant 19258 45 45 390 440 2024-06-28
19259 Creamy Chicken Foldover 19259 45 45 490 540 2024-06-28
19260 Sausage Roll 19260 45 45 490 540 2024-06-28
19261 Buttery Scone 19261 45 45 360 390 2024-06-28
19262 Country Chicken Pie 19262 45 45 620 670 2024-06-28
19263 Deep Dish Beef Pie 19263 45 45 620 670 2024-06-28
19264 Spinach & Mushroom Quiche 19264 45 45 620 670 2024-06-28
19265 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 19265 45 45 350 380 2024-06-28
19266 Mixed Nuts 19266 45 45 440 490 2024-06-28
19267 Caramel Waffles 19267 45 45 350 380 2024-06-28
19268 Chicken Ham & Cheese Panwich 19268 45 45 620 670 2024-06-28
19269 Egg Mayo & Cheese Multigrain Croissant 19269 45 45 620 670 2024-06-28
19270 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 19270 45 45 620 670 2024-06-28
19271 Rosemary Chicken & Emmental Cheese Croissant 19271 45 45 620 670 2024-06-28
19272 Scrambled Egg & Turkey Ham Pita 19272 45 45 620 670 2024-06-28
19273 Turkey Ham & Triple Cheese Toast 19273 45 45 620 670 2024-06-28
19274 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 19274 45 45 710 760 2024-06-28
19275 Ham & Cheese Croissant 19275 45 45 620 670 2024-06-28
19276 Sriracha Chicken Whole Wheat Pita 19276 45 45 670 720 2024-06-28
19277 Blueberry Acai Yogurt Parfait 19277 45 45 580 630 2024-06-28
19278 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 19278 45 45 580 630 2024-06-28
19279 Caramel Frappuccino® 19279 45 45 650 700 2024-06-28
19280 Dark Mocha Frappuccino® 19280 45 45 710 760 2024-06-28
19281 Java Chip Frappuccino® 19281 45 45 710 760 2024-06-28
19282 Mocha Frappuccino® 19282 45 45 650 700 2024-06-28
19283 Caramel Macchiato Frappuccino® 19283 45 45 710 760 2024-06-28
19284 Espresso Frappuccino® 19284 45 45 650 700 2024-06-28
19285 White Chocolate Mocha Frappuccino® 19285 45 45 650 700 2024-06-28
19286 Chocolate Chip Cream Frappuccino® 19286 45 45 710 760 2024-06-28
19287 Hojicha Tea Cream Frappuccino® 19287 45 45 690 740 2024-06-28
19288 Vanilla Cream Frappuccino® 19288 45 45 650 700 2024-06-28
19289 Mango Passion Fruit & Hibiscus 19289 45 45 650 700 2024-06-28
19290 Raspberry Black Currant & Oolong 19290 45 45 650 700 2024-06-28
19291 Coffee Traveller 19291 45 45 2800 2850 2024-06-28
19292 Caffè Americano 19292 45 45 490 540 2024-06-28
19293 Cappuccino 19293 45 45 620 670 2024-06-28
19294 Caffè Mocha 19294 45 45 680 730 2024-06-28
19295 Caramel Macchiato 19295 45 45 690 740 2024-06-28
19296 Espresso 19296 45 45 350 400 2024-06-28
19297 Caffè Latte 19297 45 45 620 670 2024-06-28
19298 Oatmilk Latte 19298 45 45 690 740 2024-06-28
19299 Vanilla Latte 19299 45 45 680 730 2024-06-28
19300 White Chocolate Mocha 19300 45 45 680 730 2024-06-28
19301 Flat White 19301 45 45 690 740 2024-06-28
19302 Ristretto Bianco 19302 45 45 690 740 2024-06-28
19303 Iced Caffè Americano 19303 45 45 490 540 2024-06-28
19304 Iced Cappuccino 19304 45 45 620 670 2024-06-28
19305 Iced Caffè Mocha 19305 45 45 680 730 2024-06-28
19306 Iced Caramel Macchiato 19306 45 45 690 740 2024-06-28
19307 Iced Caffè Latte 19307 45 45 620 670 2024-06-28
19308 Iced Oatmilk Latte 19308 45 45 690 740 2024-06-28
19309 Iced Vanilla Latte 19309 45 45 680 730 2024-06-28
19310 Iced White Chocolate Mocha 19310 45 45 680 730 2024-06-28
19311 Signature Hot Chocolate 19311 45 45 650 700 2024-06-28
19312 Signature Iced Chocolate 19312 45 45 650 700 2024-06-28
19313 Carrot Juice 19313 45 45 440 490 2024-06-28
19314 Cloudy Apple Juice 19314 45 45 440 490 2024-06-28
19315 Cranberry Red Grapefruit Juice 19315 45 45 440 490 2024-06-28
19316 Orange Juice 19316 45 45 440 490 2024-06-28
19317 Evian 19317 45 45 310 360 2024-06-28
19318 Sparkling Water 19318 45 45 400 450 2024-06-28
19319 Chai Tea 19319 45 45 450 500 2024-06-28
19320 Earl Grey Tea 19320 45 45 450 500 2024-06-28
19321 English Breakfast Tea 19321 45 45 450 500 2024-06-28
19322 Emperor’s Clouds & Mist™ Tea 19322 45 45 450 500 2024-06-28
19323 Mint Blend Tea 19323 45 45 450 500 2024-06-28
19324 Chamomile Tea 19324 45 45 450 500 2024-06-28
19325 Pure Matcha Latte 19325 45 45 670 720 2024-06-28
19326 Chai Tea Latte 19326 45 45 620 670 2024-06-28
19327 Earl Grey Tea Latte 19327 45 45 620 670 2024-06-28
19328 English Breakfast Tea Latte 19328 45 45 620 670 2024-06-28
19329 Hojicha Tea Latte 19329 45 45 670 720 2024-06-28
19330 Zen Clouds Oolong Tea 19330 45 45 450 500 2024-06-28
19331 Zen Clouds Oolong with Ruby Grapefruit and Honey 19331 45 45 580 630 2024-06-28
19332 Youthberry™ Tea 19332 45 45 450 500 2024-06-28
19333 Iced Shaken Black Tea Lemonade 19333 45 45 560 610 2024-06-28
19334 Iced Shaken Strawberry Black Tea Lemonade 19334 45 45 580 630 2024-06-28
19335 Iced Shaken Hibiscus Tea Lemonade 19335 45 45 560 610 2024-06-28
19336 Iced Shaken Hibiscus Tea with Pomegranate Pearls 19336 45 45 660 710 2024-06-28
19337 Iced Pure Matcha Latte 19337 45 45 670 720 2024-06-28
19338 Iced Chai Tea Latte 19338 45 45 620 670 2024-06-28
19339 Iced Black Tea Latte 19339 45 45 620 670 2024-06-28
19340 Iced Hojicha Tea Latte 19340 45 45 670 720 2024-06-28
19341 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 19341 45 45 580 630 2024-06-28
19342 Iced Shaken Zen Clouds Oolong Lemonade 19342 45 45 560 610 2024-06-28
19343 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 19343 45 45 580 630 2024-06-28
19344 Origami Pike Place® Roast 19344 45 45 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");