This was one of the final stories in a series looking at the quality of drinking water and lead risks in Connecticut communities.
This story in particular was an attempt to localize a story written at Vox.com. Their script was written in Python and it took me the morning to translate it to R. Then I wrote my own version of the story, created my own graphics, and did some additional demographic analysis to see if their risk map correlated with the rate of lead-poisoned children.
The other stories in the series:
Most CT schools don’t test water for lead, but that could change [story]
Where children suffer from lead poisoning in Connecticut [story]
Drinking water violations across Connecticut [story and database]
The database for this last listed link was created by my colleague because there were so many rows of data that pulling it in normally would not be feasible.