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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 112 · 182 ✖

effective_date 1

  • 2024-06-28 · 182 ✖
id ▼ item_id store_id base_price delivery_price effective_date
8256 Bagel 8256 112 112 400 430 2024-06-28
8257 Cookie Crumble Cheesecake 8257 112 112 720 770 2024-06-28
8258 Good Ol' NY Cheesecake 8258 112 112 720 770 2024-06-28
8259 Signature Chocolate Cake 8259 112 112 720 770 2024-06-28
8260 Starbucks® Coffee Tiramisu Cake 8260 112 112 750 800 2024-06-28
8261 Strawberry Shortcake 8261 112 112 720 770 2024-06-28
8262 Chocolate Chunk Monster Cookie 8262 112 112 390 440 2024-06-28
8263 Banana Walnut Muffin 8263 112 112 450 500 2024-06-28
8264 Blueberry Crumble Muffin 8264 112 112 450 500 2024-06-28
8265 Chocolate Crumble Muffin 8265 112 112 450 500 2024-06-28
8266 Pancakes 8266 112 112 550 600 2024-06-28
8267 Almond Croissant 8267 112 112 470 520 2024-06-28
8268 Buttery Croissant 8268 112 112 400 430 2024-06-28
8269 Chocolate Croissant 8269 112 112 440 490 2024-06-28
8270 Creamy Chicken Foldover 8270 112 112 550 600 2024-06-28
8271 Sausage Roll 8271 112 112 550 600 2024-06-28
8272 Buttery Scone 8272 112 112 400 430 2024-06-28
8273 Country Chicken Pie 8273 112 112 690 740 2024-06-28
8274 Deep Dish Beef Pie 8274 112 112 690 740 2024-06-28
8275 Spinach & Mushroom Quiche 8275 112 112 690 740 2024-06-28
8276 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 8276 112 112 390 420 2024-06-28
8277 Mixed Nuts 8277 112 112 490 540 2024-06-28
8278 Caramel Waffles 8278 112 112 390 420 2024-06-28
8279 Chicken Ham & Cheese Panwich 8279 112 112 690 740 2024-06-28
8280 Egg Mayo & Cheese Multigrain Croissant 8280 112 112 690 740 2024-06-28
8281 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 8281 112 112 690 740 2024-06-28
8282 Rosemary Chicken & Emmental Cheese Croissant 8282 112 112 690 740 2024-06-28
8283 Scrambled Egg & Turkey Ham Pita 8283 112 112 690 740 2024-06-28
8284 Turkey Ham & Triple Cheese Toast 8284 112 112 690 740 2024-06-28
8285 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 8285 112 112 790 840 2024-06-28
8286 Ham & Cheese Croissant 8286 112 112 690 740 2024-06-28
8287 Sriracha Chicken Whole Wheat Pita 8287 112 112 750 800 2024-06-28
8288 Blueberry Acai Yogurt Parfait 8288 112 112 650 700 2024-06-28
8289 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 8289 112 112 650 700 2024-06-28
8290 Caramel Frappuccino® 8290 112 112 720 770 2024-06-28
8291 Dark Mocha Frappuccino® 8291 112 112 780 830 2024-06-28
8292 Java Chip Frappuccino® 8292 112 112 780 830 2024-06-28
8293 Mocha Frappuccino® 8293 112 112 720 770 2024-06-28
8294 Caramel Macchiato Frappuccino® 8294 112 112 780 830 2024-06-28
8295 Espresso Frappuccino® 8295 112 112 720 770 2024-06-28
8296 White Chocolate Mocha Frappuccino® 8296 112 112 720 770 2024-06-28
8297 Chocolate Chip Cream Frappuccino® 8297 112 112 780 830 2024-06-28
8298 Hojicha Tea Cream Frappuccino® 8298 112 112 760 810 2024-06-28
8299 Vanilla Cream Frappuccino® 8299 112 112 720 770 2024-06-28
8300 Mango Passion Fruit & Hibiscus 8300 112 112 720 770 2024-06-28
8301 Raspberry Black Currant & Oolong 8301 112 112 720 770 2024-06-28
8302 Coffee Traveller 8302 112 112 3120 3170 2024-06-28
8303 Caffè Americano 8303 112 112 540 590 2024-06-28
8304 Cappuccino 8304 112 112 680 730 2024-06-28
8305 Caffè Mocha 8305 112 112 750 800 2024-06-28
8306 Caramel Macchiato 8306 112 112 760 810 2024-06-28
8307 Espresso 8307 112 112 390 440 2024-06-28
8308 Caffè Latte 8308 112 112 680 730 2024-06-28
8309 Oatmilk Latte 8309 112 112 760 810 2024-06-28
8310 Vanilla Latte 8310 112 112 750 800 2024-06-28
8311 White Chocolate Mocha 8311 112 112 750 800 2024-06-28
8312 Flat White 8312 112 112 760 810 2024-06-28
8313 Ristretto Bianco 8313 112 112 760 810 2024-06-28
8314 Iced Caffè Americano 8314 112 112 540 590 2024-06-28
8315 Iced Cappuccino 8315 112 112 680 730 2024-06-28
8316 Iced Caffè Mocha 8316 112 112 750 800 2024-06-28
8317 Iced Caramel Macchiato 8317 112 112 760 810 2024-06-28
8318 Iced Caffè Latte 8318 112 112 680 730 2024-06-28
8319 Iced Oatmilk Latte 8319 112 112 760 810 2024-06-28
8320 Iced Vanilla Latte 8320 112 112 750 800 2024-06-28
8321 Iced White Chocolate Mocha 8321 112 112 750 800 2024-06-28
8322 Signature Hot Chocolate 8322 112 112 720 770 2024-06-28
8323 Signature Iced Chocolate 8323 112 112 720 770 2024-06-28
8324 Carrot Juice 8324 112 112 490 540 2024-06-28
8325 Cloudy Apple Juice 8325 112 112 490 540 2024-06-28
8326 Cranberry Red Grapefruit Juice 8326 112 112 490 540 2024-06-28
8327 Orange Juice 8327 112 112 490 540 2024-06-28
8328 Evian 8328 112 112 350 400 2024-06-28
8329 Sparkling Water 8329 112 112 450 500 2024-06-28
8330 Chai Tea 8330 112 112 500 550 2024-06-28
8331 Earl Grey Tea 8331 112 112 500 550 2024-06-28
8332 English Breakfast Tea 8332 112 112 500 550 2024-06-28
8333 Emperor’s Clouds & Mist™ Tea 8333 112 112 500 550 2024-06-28
8334 Mint Blend Tea 8334 112 112 500 550 2024-06-28
8335 Chamomile Tea 8335 112 112 500 550 2024-06-28
8336 Pure Matcha Latte 8336 112 112 740 790 2024-06-28
8337 Chai Tea Latte 8337 112 112 680 730 2024-06-28
8338 Earl Grey Tea Latte 8338 112 112 680 730 2024-06-28
8339 English Breakfast Tea Latte 8339 112 112 680 730 2024-06-28
8340 Hojicha Tea Latte 8340 112 112 740 790 2024-06-28
8341 Zen Clouds Oolong Tea 8341 112 112 500 550 2024-06-28
8342 Zen Clouds Oolong with Ruby Grapefruit and Honey 8342 112 112 630 680 2024-06-28
8343 Youthberry™ Tea 8343 112 112 500 550 2024-06-28
8344 Iced Shaken Black Tea Lemonade 8344 112 112 610 660 2024-06-28
8345 Iced Shaken Strawberry Black Tea Lemonade 8345 112 112 630 680 2024-06-28
8346 Iced Shaken Hibiscus Tea Lemonade 8346 112 112 610 660 2024-06-28
8347 Iced Shaken Hibiscus Tea with Pomegranate Pearls 8347 112 112 730 780 2024-06-28
8348 Iced Pure Matcha Latte 8348 112 112 740 790 2024-06-28
8349 Iced Chai Tea Latte 8349 112 112 680 730 2024-06-28
8350 Iced Black Tea Latte 8350 112 112 680 730 2024-06-28
8351 Iced Hojicha Tea Latte 8351 112 112 740 790 2024-06-28
8352 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 8352 112 112 630 680 2024-06-28
8353 Iced Shaken Zen Clouds Oolong Lemonade 8353 112 112 610 660 2024-06-28
8354 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 8354 112 112 630 680 2024-06-28
8355 Origami Pike Place® Roast 8355 112 112 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");