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.

SQL Fundamentals

Posted on April 17, 2020 by John

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

Posted on April 8, 2020 by John

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

Posted on September 21, 2019 by John

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

Understanding Other People

Posted on March 4, 2019 by John

When realities collide. Understand the Other communities. Links and notes on current political spheres. Continue reading →

Posted in Collaboration / Community | Leave a comment

Experiments in Clay

Posted on January 4, 2019 by John

Pottery with internal baffle to allow for a short spout on a tall jug. Continue reading →

Posted in Art | Leave a comment