item_prices

Pricing information for Starbucks menu items in Singapore

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

184 rows where effective_date = "2024-06-28" and store_id = 32

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 32 · 184 ✖

effective_date 1

  • 2024-06-28 · 184 ✖
id ▼ item_id store_id base_price delivery_price effective_date
21251 Bagel 21251 32 32 360 390 2024-06-28
21252 Cookie Crumble Cheesecake 21252 32 32 650 700 2024-06-28
21253 Good Ol' NY Cheesecake 21253 32 32 650 700 2024-06-28
21254 Signature Chocolate Cake 21254 32 32 650 700 2024-06-28
21255 Starbucks® Coffee Tiramisu Cake 21255 32 32 670 720 2024-06-28
21256 Strawberry Shortcake 21256 32 32 650 700 2024-06-28
21257 Chocolate Chunk Monster Cookie 21257 32 32 350 400 2024-06-28
21258 Banana Walnut Muffin 21258 32 32 400 450 2024-06-28
21259 Blueberry Crumble Muffin 21259 32 32 400 450 2024-06-28
21260 Chocolate Crumble Muffin 21260 32 32 400 450 2024-06-28
21261 Pancakes 21261 32 32 490 540 2024-06-28
21262 Almond Croissant 21262 32 32 420 470 2024-06-28
21263 Buttery Croissant 21263 32 32 360 390 2024-06-28
21264 Chocolate Croissant 21264 32 32 390 440 2024-06-28
21265 Creamy Chicken Foldover 21265 32 32 490 540 2024-06-28
21266 Sausage Roll 21266 32 32 490 540 2024-06-28
21267 Buttery Scone 21267 32 32 360 390 2024-06-28
21268 Country Chicken Pie 21268 32 32 620 670 2024-06-28
21269 Deep Dish Beef Pie 21269 32 32 620 670 2024-06-28
21270 Spinach & Mushroom Quiche 21270 32 32 620 670 2024-06-28
21271 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 21271 32 32 350 380 2024-06-28
21272 Mixed Nuts 21272 32 32 440 490 2024-06-28
21273 Caramel Waffles 21273 32 32 350 380 2024-06-28
21274 Chicken Ham & Cheese Panwich 21274 32 32 620 670 2024-06-28
21275 Egg Mayo & Cheese Multigrain Croissant 21275 32 32 620 670 2024-06-28
21276 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 21276 32 32 620 670 2024-06-28
21277 Rosemary Chicken & Emmental Cheese Croissant 21277 32 32 620 670 2024-06-28
21278 Scrambled Egg & Turkey Ham Pita 21278 32 32 620 670 2024-06-28
21279 Turkey Ham & Triple Cheese Toast 21279 32 32 620 670 2024-06-28
21280 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 21280 32 32 710 760 2024-06-28
21281 Ham & Cheese Croissant 21281 32 32 620 670 2024-06-28
21282 Sriracha Chicken Whole Wheat Pita 21282 32 32 670 720 2024-06-28
21283 Blueberry Acai Yogurt Parfait 21283 32 32 580 630 2024-06-28
21284 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 21284 32 32 580 630 2024-06-28
21285 Caramel Frappuccino® 21285 32 32 650 700 2024-06-28
21286 Dark Mocha Frappuccino® 21286 32 32 710 760 2024-06-28
21287 Java Chip Frappuccino® 21287 32 32 710 760 2024-06-28
21288 Mocha Frappuccino® 21288 32 32 650 700 2024-06-28
21289 Caramel Macchiato Frappuccino® 21289 32 32 710 760 2024-06-28
21290 Espresso Frappuccino® 21290 32 32 650 700 2024-06-28
21291 White Chocolate Mocha Frappuccino® 21291 32 32 650 700 2024-06-28
21292 Chocolate Chip Cream Frappuccino® 21292 32 32 710 760 2024-06-28
21293 Hojicha Tea Cream Frappuccino® 21293 32 32 690 740 2024-06-28
21294 Vanilla Cream Frappuccino® 21294 32 32 650 700 2024-06-28
21295 Mango Passion Fruit & Hibiscus 21295 32 32 650 700 2024-06-28
21296 Raspberry Black Currant & Oolong 21296 32 32 650 700 2024-06-28
21297 Coffee Traveller 21297 32 32 2800 2850 2024-06-28
21298 Caffè Americano 21298 32 32 490 540 2024-06-28
21299 Cappuccino 21299 32 32 620 670 2024-06-28
21300 Caffè Mocha 21300 32 32 680 730 2024-06-28
21301 Caramel Macchiato 21301 32 32 690 740 2024-06-28
21302 Espresso 21302 32 32 350 400 2024-06-28
21303 Caffè Latte 21303 32 32 620 670 2024-06-28
21304 Oatmilk Latte 21304 32 32 690 740 2024-06-28
21305 Vanilla Latte 21305 32 32 680 730 2024-06-28
21306 White Chocolate Mocha 21306 32 32 680 730 2024-06-28
21307 Flat White 21307 32 32 690 740 2024-06-28
21308 Ristretto Bianco 21308 32 32 690 740 2024-06-28
21309 Iced Caffè Americano 21309 32 32 490 540 2024-06-28
21310 Iced Cappuccino 21310 32 32 620 670 2024-06-28
21311 Iced Caffè Mocha 21311 32 32 680 730 2024-06-28
21312 Iced Caramel Macchiato 21312 32 32 690 740 2024-06-28
21313 Iced Caffè Latte 21313 32 32 620 670 2024-06-28
21314 Iced Oatmilk Latte 21314 32 32 690 740 2024-06-28
21315 Iced Vanilla Latte 21315 32 32 680 730 2024-06-28
21316 Iced White Chocolate Mocha 21316 32 32 680 730 2024-06-28
21317 Signature Hot Chocolate 21317 32 32 650 700 2024-06-28
21318 Signature Iced Chocolate 21318 32 32 650 700 2024-06-28
21319 Carrot Juice 21319 32 32 440 490 2024-06-28
21320 Cloudy Apple Juice 21320 32 32 440 490 2024-06-28
21321 Cranberry Red Grapefruit Juice 21321 32 32 440 490 2024-06-28
21322 Orange Juice 21322 32 32 440 490 2024-06-28
21323 Evian 21323 32 32 310 360 2024-06-28
21324 Sparkling Water 21324 32 32 400 450 2024-06-28
21325 Chai Tea 21325 32 32 450 500 2024-06-28
21326 Earl Grey Tea 21326 32 32 450 500 2024-06-28
21327 English Breakfast Tea 21327 32 32 450 500 2024-06-28
21328 Emperor’s Clouds & Mist™ Tea 21328 32 32 450 500 2024-06-28
21329 Mint Blend Tea 21329 32 32 450 500 2024-06-28
21330 Chamomile Tea 21330 32 32 450 500 2024-06-28
21331 Pure Matcha Latte 21331 32 32 670 720 2024-06-28
21332 Chai Tea Latte 21332 32 32 620 670 2024-06-28
21333 Earl Grey Tea Latte 21333 32 32 620 670 2024-06-28
21334 English Breakfast Tea Latte 21334 32 32 620 670 2024-06-28
21335 Hojicha Tea Latte 21335 32 32 670 720 2024-06-28
21336 Zen Clouds Oolong Tea 21336 32 32 450 500 2024-06-28
21337 Zen Clouds Oolong with Ruby Grapefruit and Honey 21337 32 32 580 630 2024-06-28
21338 Youthberry™ Tea 21338 32 32 450 500 2024-06-28
21339 Iced Shaken Black Tea Lemonade 21339 32 32 560 610 2024-06-28
21340 Iced Shaken Strawberry Black Tea Lemonade 21340 32 32 580 630 2024-06-28
21341 Iced Shaken Hibiscus Tea Lemonade 21341 32 32 560 610 2024-06-28
21342 Iced Shaken Hibiscus Tea with Pomegranate Pearls 21342 32 32 660 710 2024-06-28
21343 Iced Pure Matcha Latte 21343 32 32 670 720 2024-06-28
21344 Iced Chai Tea Latte 21344 32 32 620 670 2024-06-28
21345 Iced Black Tea Latte 21345 32 32 620 670 2024-06-28
21346 Iced Hojicha Tea Latte 21346 32 32 670 720 2024-06-28
21347 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 21347 32 32 580 630 2024-06-28
21348 Iced Shaken Zen Clouds Oolong Lemonade 21348 32 32 560 610 2024-06-28
21349 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 21349 32 32 580 630 2024-06-28
21350 Origami Pike Place® Roast 21350 32 32 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");