Tracking Covid-19 in Connecticut

Summary of Connecticut Covid-19 based on Department of Public Health Data with some comparisons to national data. This has been updated each weekday during 2020 and most of 2021. There are also notes on sources of data for Covid-19 in Connecticut.

June 22, 2020

Covid-19 Cases in Connecticut

Summary of Connecticut Covid-19 based on Department of Public Health Data. In June there is a second blog post with more detail. Both posts have been updated each weekday during 2020 and most of 2021.

March 29, 2020

Apple Health Export Part I

This post is Part I of a dive into the contents of the Apple Health Export. It will work through the mechanics of moving data from the Apple Health app out of your iPhone and into R where you can analyze it. It also will describe in detail the problem of adjusting the time stamps for daylight savings time and travel across time zones. Unfortunately the topic of time zones and the Apple Health Export is a complicated subject.

February 16, 2020

Working with New Haven Area Census Data Using R

Using the tidycensus package to explore census data. This post shows R code to fetch and map census data, but also gives some tips on how to explore the almost overwhelmind variety of variables available via the Census Bureau.

April 11, 2019

Guilford Demographics

A description of the demographic structure of Guilford by age compared with other towns. Also provides some background on the geographic location of registered voters in Guilford. This post is very similar to the previous post; it does not include the R code so it is much more readable.

September 9, 2018

Guilford Registered Voters: An R Sampler

Exploraton of geotagging and gender identification based on voter registration dataset for Guilford. Explores geotagging, identifing gender from first name, US Census, and general data clean-up. To see just the interesting plots without lots of R-related detail, skip this post and read the next one instead.

September 8, 2018

Web Scraping Javascript Content

An example of using a “headless browser” to scrape web content produced by javascript. The data is about compensation of university CEOs and was published by the Chronicle of Higher Education.

July 22, 2018