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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 89 · 182 ✖

effective_date 1

  • 2024-06-28 · 182 ✖
id ▼ item_id store_id base_price delivery_price effective_date
12270 Bagel 12270 89 89 400 430 2024-06-28
12271 Cookie Crumble Cheesecake 12271 89 89 720 770 2024-06-28
12272 Good Ol' NY Cheesecake 12272 89 89 720 770 2024-06-28
12273 Signature Chocolate Cake 12273 89 89 720 770 2024-06-28
12274 Starbucks® Coffee Tiramisu Cake 12274 89 89 750 800 2024-06-28
12275 Strawberry Shortcake 12275 89 89 720 770 2024-06-28
12276 Chocolate Chunk Monster Cookie 12276 89 89 390 440 2024-06-28
12277 Banana Walnut Muffin 12277 89 89 450 500 2024-06-28
12278 Blueberry Crumble Muffin 12278 89 89 450 500 2024-06-28
12279 Chocolate Crumble Muffin 12279 89 89 450 500 2024-06-28
12280 Pancakes 12280 89 89 550 600 2024-06-28
12281 Almond Croissant 12281 89 89 470 520 2024-06-28
12282 Buttery Croissant 12282 89 89 400 430 2024-06-28
12283 Chocolate Croissant 12283 89 89 440 490 2024-06-28
12284 Creamy Chicken Foldover 12284 89 89 550 600 2024-06-28
12285 Sausage Roll 12285 89 89 550 600 2024-06-28
12286 Buttery Scone 12286 89 89 400 430 2024-06-28
12287 Country Chicken Pie 12287 89 89 690 740 2024-06-28
12288 Deep Dish Beef Pie 12288 89 89 690 740 2024-06-28
12289 Spinach & Mushroom Quiche 12289 89 89 690 740 2024-06-28
12290 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 12290 89 89 390 420 2024-06-28
12291 Mixed Nuts 12291 89 89 490 540 2024-06-28
12292 Caramel Waffles 12292 89 89 390 420 2024-06-28
12293 Chicken Ham & Cheese Panwich 12293 89 89 690 740 2024-06-28
12294 Egg Mayo & Cheese Multigrain Croissant 12294 89 89 690 740 2024-06-28
12295 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 12295 89 89 690 740 2024-06-28
12296 Rosemary Chicken & Emmental Cheese Croissant 12296 89 89 690 740 2024-06-28
12297 Scrambled Egg & Turkey Ham Pita 12297 89 89 690 740 2024-06-28
12298 Turkey Ham & Triple Cheese Toast 12298 89 89 690 740 2024-06-28
12299 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 12299 89 89 790 840 2024-06-28
12300 Ham & Cheese Croissant 12300 89 89 690 740 2024-06-28
12301 Sriracha Chicken Whole Wheat Pita 12301 89 89 750 800 2024-06-28
12302 Blueberry Acai Yogurt Parfait 12302 89 89 650 700 2024-06-28
12303 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 12303 89 89 650 700 2024-06-28
12304 Caramel Frappuccino® 12304 89 89 720 770 2024-06-28
12305 Dark Mocha Frappuccino® 12305 89 89 780 830 2024-06-28
12306 Java Chip Frappuccino® 12306 89 89 780 830 2024-06-28
12307 Mocha Frappuccino® 12307 89 89 720 770 2024-06-28
12308 Caramel Macchiato Frappuccino® 12308 89 89 780 830 2024-06-28
12309 Espresso Frappuccino® 12309 89 89 720 770 2024-06-28
12310 White Chocolate Mocha Frappuccino® 12310 89 89 720 770 2024-06-28
12311 Chocolate Chip Cream Frappuccino® 12311 89 89 780 830 2024-06-28
12312 Hojicha Tea Cream Frappuccino® 12312 89 89 760 810 2024-06-28
12313 Vanilla Cream Frappuccino® 12313 89 89 720 770 2024-06-28
12314 Mango Passion Fruit & Hibiscus 12314 89 89 720 770 2024-06-28
12315 Raspberry Black Currant & Oolong 12315 89 89 720 770 2024-06-28
12316 Coffee Traveller 12316 89 89 3120 3170 2024-06-28
12317 Caffè Americano 12317 89 89 540 590 2024-06-28
12318 Cappuccino 12318 89 89 680 730 2024-06-28
12319 Caffè Mocha 12319 89 89 750 800 2024-06-28
12320 Caramel Macchiato 12320 89 89 760 810 2024-06-28
12321 Espresso 12321 89 89 390 440 2024-06-28
12322 Caffè Latte 12322 89 89 680 730 2024-06-28
12323 Oatmilk Latte 12323 89 89 760 810 2024-06-28
12324 Vanilla Latte 12324 89 89 750 800 2024-06-28
12325 White Chocolate Mocha 12325 89 89 750 800 2024-06-28
12326 Flat White 12326 89 89 760 810 2024-06-28
12327 Ristretto Bianco 12327 89 89 760 810 2024-06-28
12328 Iced Caffè Americano 12328 89 89 540 590 2024-06-28
12329 Iced Cappuccino 12329 89 89 680 730 2024-06-28
12330 Iced Caffè Mocha 12330 89 89 750 800 2024-06-28
12331 Iced Caramel Macchiato 12331 89 89 760 810 2024-06-28
12332 Iced Caffè Latte 12332 89 89 680 730 2024-06-28
12333 Iced Oatmilk Latte 12333 89 89 760 810 2024-06-28
12334 Iced Vanilla Latte 12334 89 89 750 800 2024-06-28
12335 Iced White Chocolate Mocha 12335 89 89 750 800 2024-06-28
12336 Signature Hot Chocolate 12336 89 89 720 770 2024-06-28
12337 Signature Iced Chocolate 12337 89 89 720 770 2024-06-28
12338 Carrot Juice 12338 89 89 490 540 2024-06-28
12339 Cloudy Apple Juice 12339 89 89 490 540 2024-06-28
12340 Cranberry Red Grapefruit Juice 12340 89 89 490 540 2024-06-28
12341 Orange Juice 12341 89 89 490 540 2024-06-28
12342 Evian 12342 89 89 350 400 2024-06-28
12343 Sparkling Water 12343 89 89 450 500 2024-06-28
12344 Chai Tea 12344 89 89 500 550 2024-06-28
12345 Earl Grey Tea 12345 89 89 500 550 2024-06-28
12346 English Breakfast Tea 12346 89 89 500 550 2024-06-28
12347 Emperor’s Clouds & Mist™ Tea 12347 89 89 500 550 2024-06-28
12348 Mint Blend Tea 12348 89 89 500 550 2024-06-28
12349 Chamomile Tea 12349 89 89 500 550 2024-06-28
12350 Pure Matcha Latte 12350 89 89 740 790 2024-06-28
12351 Chai Tea Latte 12351 89 89 680 730 2024-06-28
12352 Earl Grey Tea Latte 12352 89 89 680 730 2024-06-28
12353 English Breakfast Tea Latte 12353 89 89 680 730 2024-06-28
12354 Hojicha Tea Latte 12354 89 89 740 790 2024-06-28
12355 Zen Clouds Oolong Tea 12355 89 89 500 550 2024-06-28
12356 Zen Clouds Oolong with Ruby Grapefruit and Honey 12356 89 89 630 680 2024-06-28
12357 Youthberry™ Tea 12357 89 89 500 550 2024-06-28
12358 Iced Shaken Black Tea Lemonade 12358 89 89 610 660 2024-06-28
12359 Iced Shaken Strawberry Black Tea Lemonade 12359 89 89 630 680 2024-06-28
12360 Iced Shaken Hibiscus Tea Lemonade 12360 89 89 610 660 2024-06-28
12361 Iced Shaken Hibiscus Tea with Pomegranate Pearls 12361 89 89 730 780 2024-06-28
12362 Iced Pure Matcha Latte 12362 89 89 740 790 2024-06-28
12363 Iced Chai Tea Latte 12363 89 89 680 730 2024-06-28
12364 Iced Black Tea Latte 12364 89 89 680 730 2024-06-28
12365 Iced Hojicha Tea Latte 12365 89 89 740 790 2024-06-28
12366 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 12366 89 89 630 680 2024-06-28
12367 Iced Shaken Zen Clouds Oolong Lemonade 12367 89 89 610 660 2024-06-28
12368 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 12368 89 89 630 680 2024-06-28
12369 Origami Pike Place® Roast 12369 89 89 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");