item_prices

Pricing information for Starbucks menu items in Singapore

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

234 rows where store_id = 37

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 37 · 234 ✖
id ▼ item_id store_id base_price delivery_price effective_date
20339 Bagel 20339 37 37 400 430 2024-06-28
20340 Cookie Crumble Cheesecake 20340 37 37 720 770 2024-06-28
20341 Good Ol' NY Cheesecake 20341 37 37 720 770 2024-06-28
20342 Signature Chocolate Cake 20342 37 37 720 770 2024-06-28
20343 Starbucks® Coffee Tiramisu Cake 20343 37 37 750 800 2024-06-28
20344 Strawberry Shortcake 20344 37 37 720 770 2024-06-28
20345 Chocolate Chunk Monster Cookie 20345 37 37 390 440 2024-06-28
20346 Banana Walnut Muffin 20346 37 37 450 500 2024-06-28
20347 Blueberry Crumble Muffin 20347 37 37 450 500 2024-06-28
20348 Chocolate Crumble Muffin 20348 37 37 450 500 2024-06-28
20349 Pancakes 20349 37 37 550 600 2024-06-28
20350 Almond Croissant 20350 37 37 470 520 2024-06-28
20351 Buttery Croissant 20351 37 37 400 430 2024-06-28
20352 Chocolate Croissant 20352 37 37 440 490 2024-06-28
20353 Creamy Chicken Foldover 20353 37 37 550 600 2024-06-28
20354 Sausage Roll 20354 37 37 550 600 2024-06-28
20355 Buttery Scone 20355 37 37 400 430 2024-06-28
20356 Country Chicken Pie 20356 37 37 690 740 2024-06-28
20357 Deep Dish Beef Pie 20357 37 37 690 740 2024-06-28
20358 Spinach & Mushroom Quiche 20358 37 37 690 740 2024-06-28
20359 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 20359 37 37 390 420 2024-06-28
20360 Mixed Nuts 20360 37 37 490 540 2024-06-28
20361 Caramel Waffles 20361 37 37 390 420 2024-06-28
20362 Chicken Ham & Cheese Panwich 20362 37 37 690 740 2024-06-28
20363 Egg Mayo & Cheese Multigrain Croissant 20363 37 37 690 740 2024-06-28
20364 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 20364 37 37 690 740 2024-06-28
20365 Rosemary Chicken & Emmental Cheese Croissant 20365 37 37 690 740 2024-06-28
20366 Scrambled Egg & Turkey Ham Pita 20366 37 37 690 740 2024-06-28
20367 Turkey Ham & Triple Cheese Toast 20367 37 37 690 740 2024-06-28
20368 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 20368 37 37 790 840 2024-06-28
20369 Ham & Cheese Croissant 20369 37 37 690 740 2024-06-28
20370 Sriracha Chicken Whole Wheat Pita 20370 37 37 750 800 2024-06-28
20371 Blueberry Acai Yogurt Parfait 20371 37 37 650 700 2024-06-28
20372 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 20372 37 37 650 700 2024-06-28
20373 Caramel Frappuccino® 20373 37 37 720 770 2024-06-28
20374 Dark Mocha Frappuccino® 20374 37 37 780 830 2024-06-28
20375 Java Chip Frappuccino® 20375 37 37 780 830 2024-06-28
20376 Mocha Frappuccino® 20376 37 37 720 770 2024-06-28
20377 Caramel Macchiato Frappuccino® 20377 37 37 780 830 2024-06-28
20378 Espresso Frappuccino® 20378 37 37 720 770 2024-06-28
20379 White Chocolate Mocha Frappuccino® 20379 37 37 720 770 2024-06-28
20380 Chocolate Chip Cream Frappuccino® 20380 37 37 780 830 2024-06-28
20381 Hojicha Tea Cream Frappuccino® 20381 37 37 760 810 2024-06-28
20382 Vanilla Cream Frappuccino® 20382 37 37 720 770 2024-06-28
20383 Mango Passion Fruit & Hibiscus 20383 37 37 720 770 2024-06-28
20384 Raspberry Black Currant & Oolong 20384 37 37 720 770 2024-06-28
20385 Coffee Traveller 20385 37 37 3120 3170 2024-06-28
20386 Caffè Americano 20386 37 37 540 590 2024-06-28
20387 Cappuccino 20387 37 37 680 730 2024-06-28
20388 Caffè Mocha 20388 37 37 750 800 2024-06-28
20389 Caramel Macchiato 20389 37 37 760 810 2024-06-28
20390 Espresso 20390 37 37 390 440 2024-06-28
20391 Caffè Latte 20391 37 37 680 730 2024-06-28
20392 Oatmilk Latte 20392 37 37 760 810 2024-06-28
20393 Vanilla Latte 20393 37 37 750 800 2024-06-28
20394 White Chocolate Mocha 20394 37 37 750 800 2024-06-28
20395 Flat White 20395 37 37 760 810 2024-06-28
20396 Ristretto Bianco 20396 37 37 760 810 2024-06-28
20397 Iced Caffè Americano 20397 37 37 540 590 2024-06-28
20398 Iced Cappuccino 20398 37 37 680 730 2024-06-28
20399 Iced Caffè Mocha 20399 37 37 750 800 2024-06-28
20400 Iced Caramel Macchiato 20400 37 37 760 810 2024-06-28
20401 Iced Caffè Latte 20401 37 37 680 730 2024-06-28
20402 Iced Oatmilk Latte 20402 37 37 760 810 2024-06-28
20403 Iced Vanilla Latte 20403 37 37 750 800 2024-06-28
20404 Iced White Chocolate Mocha 20404 37 37 750 800 2024-06-28
20405 Signature Hot Chocolate 20405 37 37 720 770 2024-06-28
20406 Signature Iced Chocolate 20406 37 37 720 770 2024-06-28
20407 Carrot Juice 20407 37 37 490 540 2024-06-28
20408 Cloudy Apple Juice 20408 37 37 490 540 2024-06-28
20409 Cranberry Red Grapefruit Juice 20409 37 37 490 540 2024-06-28
20410 Orange Juice 20410 37 37 490 540 2024-06-28
20411 Evian 20411 37 37 350 400 2024-06-28
20412 Sparkling Water 20412 37 37 450 500 2024-06-28
20413 Chai Tea 20413 37 37 500 550 2024-06-28
20414 Earl Grey Tea 20414 37 37 500 550 2024-06-28
20415 English Breakfast Tea 20415 37 37 500 550 2024-06-28
20416 Emperor’s Clouds & Mist™ Tea 20416 37 37 500 550 2024-06-28
20417 Mint Blend Tea 20417 37 37 500 550 2024-06-28
20418 Chamomile Tea 20418 37 37 500 550 2024-06-28
20419 Pure Matcha Latte 20419 37 37 740 790 2024-06-28
20420 Chai Tea Latte 20420 37 37 680 730 2024-06-28
20421 Earl Grey Tea Latte 20421 37 37 680 730 2024-06-28
20422 English Breakfast Tea Latte 20422 37 37 680 730 2024-06-28
20423 Hojicha Tea Latte 20423 37 37 740 790 2024-06-28
20424 Zen Clouds Oolong Tea 20424 37 37 500 550 2024-06-28
20425 Zen Clouds Oolong with Ruby Grapefruit and Honey 20425 37 37 630 680 2024-06-28
20426 Youthberry™ Tea 20426 37 37 500 550 2024-06-28
20427 Iced Shaken Black Tea Lemonade 20427 37 37 610 660 2024-06-28
20428 Iced Shaken Strawberry Black Tea Lemonade 20428 37 37 630 680 2024-06-28
20429 Iced Shaken Hibiscus Tea Lemonade 20429 37 37 610 660 2024-06-28
20430 Iced Shaken Hibiscus Tea with Pomegranate Pearls 20430 37 37 730 780 2024-06-28
20431 Iced Pure Matcha Latte 20431 37 37 740 790 2024-06-28
20432 Iced Chai Tea Latte 20432 37 37 680 730 2024-06-28
20433 Iced Black Tea Latte 20433 37 37 680 730 2024-06-28
20434 Iced Hojicha Tea Latte 20434 37 37 740 790 2024-06-28
20435 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 20435 37 37 630 680 2024-06-28
20436 Iced Shaken Zen Clouds Oolong Lemonade 20436 37 37 610 660 2024-06-28
20437 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 20437 37 37 630 680 2024-06-28
20438 Origami Pike Place® Roast 20438 37 37 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");