item_prices

Pricing information for Starbucks menu items in Singapore

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

225 rows where store_id = 94

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 94 · 225 ✖
id ▼ item_id store_id base_price delivery_price effective_date
11354 Bagel 11354 94 94 400 430 2024-06-28
11355 Cookie Crumble Cheesecake 11355 94 94 720 770 2024-06-28
11356 Good Ol' NY Cheesecake 11356 94 94 720 770 2024-06-28
11357 Signature Chocolate Cake 11357 94 94 720 770 2024-06-28
11358 Starbucks® Coffee Tiramisu Cake 11358 94 94 750 800 2024-06-28
11359 Strawberry Shortcake 11359 94 94 720 770 2024-06-28
11360 Chocolate Chunk Monster Cookie 11360 94 94 390 440 2024-06-28
11361 Banana Walnut Muffin 11361 94 94 450 500 2024-06-28
11362 Blueberry Crumble Muffin 11362 94 94 450 500 2024-06-28
11363 Chocolate Crumble Muffin 11363 94 94 450 500 2024-06-28
11364 Pancakes 11364 94 94 550 600 2024-06-28
11365 Almond Croissant 11365 94 94 470 520 2024-06-28
11366 Buttery Croissant 11366 94 94 400 430 2024-06-28
11367 Chocolate Croissant 11367 94 94 440 490 2024-06-28
11368 Creamy Chicken Foldover 11368 94 94 550 600 2024-06-28
11369 Sausage Roll 11369 94 94 550 600 2024-06-28
11370 Buttery Scone 11370 94 94 400 430 2024-06-28
11371 Country Chicken Pie 11371 94 94 690 740 2024-06-28
11372 Deep Dish Beef Pie 11372 94 94 690 740 2024-06-28
11373 Spinach & Mushroom Quiche 11373 94 94 690 740 2024-06-28
11374 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 11374 94 94 390 420 2024-06-28
11375 Mixed Nuts 11375 94 94 490 540 2024-06-28
11376 Caramel Waffles 11376 94 94 390 420 2024-06-28
11377 Chicken Ham & Cheese Panwich 11377 94 94 690 740 2024-06-28
11378 Egg Mayo & Cheese Multigrain Croissant 11378 94 94 690 740 2024-06-28
11379 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 11379 94 94 690 740 2024-06-28
11380 Rosemary Chicken & Emmental Cheese Croissant 11380 94 94 690 740 2024-06-28
11381 Scrambled Egg & Turkey Ham Pita 11381 94 94 690 740 2024-06-28
11382 Turkey Ham & Triple Cheese Toast 11382 94 94 690 740 2024-06-28
11383 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 11383 94 94 790 840 2024-06-28
11384 Ham & Cheese Croissant 11384 94 94 690 740 2024-06-28
11385 Sriracha Chicken Whole Wheat Pita 11385 94 94 750 800 2024-06-28
11386 Blueberry Acai Yogurt Parfait 11386 94 94 650 700 2024-06-28
11387 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 11387 94 94 650 700 2024-06-28
11388 Caramel Frappuccino® 11388 94 94 720 770 2024-06-28
11389 Dark Mocha Frappuccino® 11389 94 94 780 830 2024-06-28
11390 Java Chip Frappuccino® 11390 94 94 780 830 2024-06-28
11391 Mocha Frappuccino® 11391 94 94 720 770 2024-06-28
11392 Caramel Macchiato Frappuccino® 11392 94 94 780 830 2024-06-28
11393 Espresso Frappuccino® 11393 94 94 720 770 2024-06-28
11394 White Chocolate Mocha Frappuccino® 11394 94 94 720 770 2024-06-28
11395 Chocolate Chip Cream Frappuccino® 11395 94 94 780 830 2024-06-28
11396 Hojicha Tea Cream Frappuccino® 11396 94 94 760 810 2024-06-28
11397 Vanilla Cream Frappuccino® 11397 94 94 720 770 2024-06-28
11398 Mango Passion Fruit & Hibiscus 11398 94 94 720 770 2024-06-28
11399 Raspberry Black Currant & Oolong 11399 94 94 720 770 2024-06-28
11400 Coffee Traveller 11400 94 94 3120 3170 2024-06-28
11401 Caffè Americano 11401 94 94 540 590 2024-06-28
11402 Cappuccino 11402 94 94 680 730 2024-06-28
11403 Caffè Mocha 11403 94 94 750 800 2024-06-28
11404 Caramel Macchiato 11404 94 94 760 810 2024-06-28
11405 Espresso 11405 94 94 390 440 2024-06-28
11406 Caffè Latte 11406 94 94 680 730 2024-06-28
11407 Oatmilk Latte 11407 94 94 760 810 2024-06-28
11408 Vanilla Latte 11408 94 94 750 800 2024-06-28
11409 White Chocolate Mocha 11409 94 94 750 800 2024-06-28
11410 Flat White 11410 94 94 760 810 2024-06-28
11411 Ristretto Bianco 11411 94 94 760 810 2024-06-28
11412 Iced Caffè Americano 11412 94 94 540 590 2024-06-28
11413 Iced Cappuccino 11413 94 94 680 730 2024-06-28
11414 Iced Caffè Mocha 11414 94 94 750 800 2024-06-28
11415 Iced Caramel Macchiato 11415 94 94 760 810 2024-06-28
11416 Iced Caffè Latte 11416 94 94 680 730 2024-06-28
11417 Iced Oatmilk Latte 11417 94 94 760 810 2024-06-28
11418 Iced Vanilla Latte 11418 94 94 750 800 2024-06-28
11419 Iced White Chocolate Mocha 11419 94 94 750 800 2024-06-28
11420 Signature Hot Chocolate 11420 94 94 720 770 2024-06-28
11421 Signature Iced Chocolate 11421 94 94 720 770 2024-06-28
11422 Carrot Juice 11422 94 94 490 540 2024-06-28
11423 Cloudy Apple Juice 11423 94 94 490 540 2024-06-28
11424 Cranberry Red Grapefruit Juice 11424 94 94 490 540 2024-06-28
11425 Orange Juice 11425 94 94 490 540 2024-06-28
11426 Evian 11426 94 94 350 400 2024-06-28
11427 Sparkling Water 11427 94 94 450 500 2024-06-28
11428 Chai Tea 11428 94 94 500 550 2024-06-28
11429 Earl Grey Tea 11429 94 94 500 550 2024-06-28
11430 English Breakfast Tea 11430 94 94 500 550 2024-06-28
11431 Emperor’s Clouds & Mist™ Tea 11431 94 94 500 550 2024-06-28
11432 Mint Blend Tea 11432 94 94 500 550 2024-06-28
11433 Chamomile Tea 11433 94 94 500 550 2024-06-28
11434 Pure Matcha Latte 11434 94 94 740 790 2024-06-28
11435 Chai Tea Latte 11435 94 94 680 730 2024-06-28
11436 Earl Grey Tea Latte 11436 94 94 680 730 2024-06-28
11437 English Breakfast Tea Latte 11437 94 94 680 730 2024-06-28
11438 Hojicha Tea Latte 11438 94 94 740 790 2024-06-28
11439 Zen Clouds Oolong Tea 11439 94 94 500 550 2024-06-28
11440 Zen Clouds Oolong with Ruby Grapefruit and Honey 11440 94 94 630 680 2024-06-28
11441 Youthberry™ Tea 11441 94 94 500 550 2024-06-28
11442 Iced Shaken Black Tea Lemonade 11442 94 94 610 660 2024-06-28
11443 Iced Shaken Strawberry Black Tea Lemonade 11443 94 94 630 680 2024-06-28
11444 Iced Shaken Hibiscus Tea Lemonade 11444 94 94 610 660 2024-06-28
11445 Iced Shaken Hibiscus Tea with Pomegranate Pearls 11445 94 94 730 780 2024-06-28
11446 Iced Pure Matcha Latte 11446 94 94 740 790 2024-06-28
11447 Iced Chai Tea Latte 11447 94 94 680 730 2024-06-28
11448 Iced Black Tea Latte 11448 94 94 680 730 2024-06-28
11449 Iced Hojicha Tea Latte 11449 94 94 740 790 2024-06-28
11450 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 11450 94 94 630 680 2024-06-28
11451 Iced Shaken Zen Clouds Oolong Lemonade 11451 94 94 610 660 2024-06-28
11452 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 11452 94 94 630 680 2024-06-28
11453 Origami Pike Place® Roast 11453 94 94 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");