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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 131 · 184 ✖

effective_date 1

  • 2024-06-28 · 184 ✖
id ▼ item_id store_id base_price delivery_price effective_date
5340 Bagel 5340 131 131 400 430 2024-06-28
5341 Cookie Crumble Cheesecake 5341 131 131 720 770 2024-06-28
5342 Good Ol' NY Cheesecake 5342 131 131 720 770 2024-06-28
5343 Signature Chocolate Cake 5343 131 131 720 770 2024-06-28
5344 Starbucks® Coffee Tiramisu Cake 5344 131 131 750 800 2024-06-28
5345 Strawberry Shortcake 5345 131 131 720 770 2024-06-28
5346 Chocolate Chunk Monster Cookie 5346 131 131 390 440 2024-06-28
5347 Banana Walnut Muffin 5347 131 131 450 500 2024-06-28
5348 Blueberry Crumble Muffin 5348 131 131 450 500 2024-06-28
5349 Chocolate Crumble Muffin 5349 131 131 450 500 2024-06-28
5350 Pancakes 5350 131 131 550 600 2024-06-28
5351 Almond Croissant 5351 131 131 470 520 2024-06-28
5352 Buttery Croissant 5352 131 131 400 430 2024-06-28
5353 Chocolate Croissant 5353 131 131 440 490 2024-06-28
5354 Creamy Chicken Foldover 5354 131 131 550 600 2024-06-28
5355 Sausage Roll 5355 131 131 550 600 2024-06-28
5356 Buttery Scone 5356 131 131 400 430 2024-06-28
5357 Country Chicken Pie 5357 131 131 690 740 2024-06-28
5358 Deep Dish Beef Pie 5358 131 131 690 740 2024-06-28
5359 Spinach & Mushroom Quiche 5359 131 131 690 740 2024-06-28
5360 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 5360 131 131 390 420 2024-06-28
5361 Mixed Nuts 5361 131 131 490 540 2024-06-28
5362 Caramel Waffles 5362 131 131 390 420 2024-06-28
5363 Chicken Ham & Cheese Panwich 5363 131 131 690 740 2024-06-28
5364 Egg Mayo & Cheese Multigrain Croissant 5364 131 131 690 740 2024-06-28
5365 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 5365 131 131 690 740 2024-06-28
5366 Rosemary Chicken & Emmental Cheese Croissant 5366 131 131 690 740 2024-06-28
5367 Scrambled Egg & Turkey Ham Pita 5367 131 131 690 740 2024-06-28
5368 Turkey Ham & Triple Cheese Toast 5368 131 131 690 740 2024-06-28
5369 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 5369 131 131 790 840 2024-06-28
5370 Ham & Cheese Croissant 5370 131 131 690 740 2024-06-28
5371 Sriracha Chicken Whole Wheat Pita 5371 131 131 750 800 2024-06-28
5372 Blueberry Acai Yogurt Parfait 5372 131 131 650 700 2024-06-28
5373 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 5373 131 131 650 700 2024-06-28
5374 Caramel Frappuccino® 5374 131 131 720 770 2024-06-28
5375 Dark Mocha Frappuccino® 5375 131 131 780 830 2024-06-28
5376 Java Chip Frappuccino® 5376 131 131 780 830 2024-06-28
5377 Mocha Frappuccino® 5377 131 131 720 770 2024-06-28
5378 Caramel Macchiato Frappuccino® 5378 131 131 780 830 2024-06-28
5379 Espresso Frappuccino® 5379 131 131 720 770 2024-06-28
5380 White Chocolate Mocha Frappuccino® 5380 131 131 720 770 2024-06-28
5381 Chocolate Chip Cream Frappuccino® 5381 131 131 780 830 2024-06-28
5382 Hojicha Tea Cream Frappuccino® 5382 131 131 760 810 2024-06-28
5383 Vanilla Cream Frappuccino® 5383 131 131 720 770 2024-06-28
5384 Mango Passion Fruit & Hibiscus 5384 131 131 720 770 2024-06-28
5385 Raspberry Black Currant & Oolong 5385 131 131 720 770 2024-06-28
5386 Coffee Traveller 5386 131 131 3120 3170 2024-06-28
5387 Caffè Americano 5387 131 131 540 590 2024-06-28
5388 Cappuccino 5388 131 131 680 730 2024-06-28
5389 Caffè Mocha 5389 131 131 750 800 2024-06-28
5390 Caramel Macchiato 5390 131 131 760 810 2024-06-28
5391 Espresso 5391 131 131 390 440 2024-06-28
5392 Caffè Latte 5392 131 131 680 730 2024-06-28
5393 Oatmilk Latte 5393 131 131 760 810 2024-06-28
5394 Vanilla Latte 5394 131 131 750 800 2024-06-28
5395 White Chocolate Mocha 5395 131 131 750 800 2024-06-28
5396 Flat White 5396 131 131 760 810 2024-06-28
5397 Ristretto Bianco 5397 131 131 760 810 2024-06-28
5398 Iced Caffè Americano 5398 131 131 540 590 2024-06-28
5399 Iced Cappuccino 5399 131 131 680 730 2024-06-28
5400 Iced Caffè Mocha 5400 131 131 750 800 2024-06-28
5401 Iced Caramel Macchiato 5401 131 131 760 810 2024-06-28
5402 Iced Caffè Latte 5402 131 131 680 730 2024-06-28
5403 Iced Oatmilk Latte 5403 131 131 760 810 2024-06-28
5404 Iced Vanilla Latte 5404 131 131 750 800 2024-06-28
5405 Iced White Chocolate Mocha 5405 131 131 750 800 2024-06-28
5406 Signature Hot Chocolate 5406 131 131 720 770 2024-06-28
5407 Signature Iced Chocolate 5407 131 131 720 770 2024-06-28
5408 Carrot Juice 5408 131 131 490 540 2024-06-28
5409 Cloudy Apple Juice 5409 131 131 490 540 2024-06-28
5410 Cranberry Red Grapefruit Juice 5410 131 131 490 540 2024-06-28
5411 Orange Juice 5411 131 131 490 540 2024-06-28
5412 Evian 5412 131 131 350 400 2024-06-28
5413 Sparkling Water 5413 131 131 450 500 2024-06-28
5414 Chai Tea 5414 131 131 500 550 2024-06-28
5415 Earl Grey Tea 5415 131 131 500 550 2024-06-28
5416 English Breakfast Tea 5416 131 131 500 550 2024-06-28
5417 Emperor’s Clouds & Mist™ Tea 5417 131 131 500 550 2024-06-28
5418 Mint Blend Tea 5418 131 131 500 550 2024-06-28
5419 Chamomile Tea 5419 131 131 500 550 2024-06-28
5420 Pure Matcha Latte 5420 131 131 740 790 2024-06-28
5421 Chai Tea Latte 5421 131 131 680 730 2024-06-28
5422 Earl Grey Tea Latte 5422 131 131 680 730 2024-06-28
5423 English Breakfast Tea Latte 5423 131 131 680 730 2024-06-28
5424 Hojicha Tea Latte 5424 131 131 740 790 2024-06-28
5425 Zen Clouds Oolong Tea 5425 131 131 500 550 2024-06-28
5426 Zen Clouds Oolong with Ruby Grapefruit and Honey 5426 131 131 630 680 2024-06-28
5427 Youthberry™ Tea 5427 131 131 500 550 2024-06-28
5428 Iced Shaken Black Tea Lemonade 5428 131 131 610 660 2024-06-28
5429 Iced Shaken Strawberry Black Tea Lemonade 5429 131 131 630 680 2024-06-28
5430 Iced Shaken Hibiscus Tea Lemonade 5430 131 131 610 660 2024-06-28
5431 Iced Shaken Hibiscus Tea with Pomegranate Pearls 5431 131 131 730 780 2024-06-28
5432 Iced Pure Matcha Latte 5432 131 131 740 790 2024-06-28
5433 Iced Chai Tea Latte 5433 131 131 680 730 2024-06-28
5434 Iced Black Tea Latte 5434 131 131 680 730 2024-06-28
5435 Iced Hojicha Tea Latte 5435 131 131 740 790 2024-06-28
5436 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 5436 131 131 630 680 2024-06-28
5437 Iced Shaken Zen Clouds Oolong Lemonade 5437 131 131 610 660 2024-06-28
5438 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 5438 131 131 630 680 2024-06-28
5439 Origami Pike Place® Roast 5439 131 131 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");