Author Archives: John

About John

Interested in how information intersects daily life, technology, and art. Digital Marketing - marketing ROI in healthcare Collaboration - working in social and collaborative media. Biomedical Informaticist - focusing on patient/patient, patient/provider communication.

Oregon Health Cartogram – Chronic Cardiac Diseases by County

This is my first chance to try out the Oregon cartogram I’ve been developing with some actual data. (Update Nov 28: Added disclaimer about population health veracity. This graph really is based on the OHA documents, but it has not … Continue reading

Posted in Medical Informatics, Uncategorized | 1 Comment

Reading Tufte

Finished up the first three volumes from Edward Tufte on data information and visualization. While I read a bit a few years ago, and follow data viz on Twitter and the web, it was good to sit down and go … Continue reading

Posted in Uncategorized | Leave a comment

SQL Fundamentals

Like last week’s effort with Regular Expressions, I’ve been piecing together SQL queries for some time now and decided to work through a lite tutorial. I noticed the website with the Regular Expressions tutorial also offered SQL; so I jumped … Continue reading

Posted in For Hire | Leave a comment

Regular Expressions

To clean up data for analysis, I’ve had to dip my toes into regular expressions. For example, writing a line of instructions that can separate first and last names and removing middle ones from a list of people. To do … Continue reading

Posted in For Hire | Leave a comment

Cartogram of Oregon Counties

The state of Oregon’s Open Data Portal provides access and assistance to a whole number of datasets and charts. I’ve been interested in looking at the similarities and differences between counties and locations (mostly in healthcare). I’ve done a few … Continue reading

Posted in Medical Informatics | Tagged | 3 Comments