Switch branches/tags
Nothing to show
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
..
Failed to load latest commit information.
data
maps
.Rapp.history
.gitignore
actions.R
count.html
elevated_lead_levels.Rmd
elevated_lead_levels.html
epa_scraper.R
extra_questions.R
geospatial_lead_risk.R
geospatial_lead_risk.Rmd
geospatial_lead_risk.html
ind_pages.R
index.html
lead_analysis.R
lead_analysis.Rproj
lead_risk_analysis.R
lead_risk_analysis.Rmd
lead_risk_analysis.html
most.html
no_matches.csv
population.html
readme.md
violations.R
violations.Rmd
violations.html

readme.md

Lead in water data analysis repository

This repository contains source data and analysis code for the following stories published on TrendCT.org.

It may be too technical for the average reader, but we make it accessible because we believe it is important to be as transparent as possible about our methodology so our work can be checked or expanded upon.

Check us out on Twitter @TrendCT and on Facebook/TrendCT.

What's in this repo

How to get the list of lead violations from the EPA

Lead ALE violations in CT

  1. Visit the SDWIS Federal Reports Search
  2. Click the 'Advanced Search Options' button
  3. In the top-most section, select 'Lead and Copper Report'
  4. Select 'Lead ALE Samples' under Choose Report
  5. Select 'Connecticut' from 'Primary Agency'
  6. Set Sample Start Date and Sample End Date to '1/1/2000' and '1/1/2016'
  7. Click the 'View Reports' button at the top right

How to get the list of all drinking water violations from the EPA

  1. Visit the SDWIS Federal Reports Search
  2. Click the 'Advanced Search Options' button
  3. In the top-most section, select 'Violations'
  4. Select 'Connecticut' from 'Primary Agency'
  5. Set Compliance Period Start Date and Compliance Period End Date to '1/1/2000' and '1/1/2016'
  6. Click the 'View Reports' button at the top right