Safe Drinking Water Sample Results Information Systems Pennsylvania 2010 - Current Environmental Protection

Pennsylvania collects and manages public drinking water system information in the Pennsylvania Drinking Water Information System (PADWIS). <br>

The data includes water system inventory information, drinking water sample results for testing required by the regulations and violations of PA Safe Drinking Water Regulations, pertaining to monitoring/reporting requirements, MCL exceedances, and treatment techniques.

Much of this data is searchable via the www.drinkingwater.state.pa.us website. This set contains drinking water sample results reported on behalf of Pennsylvania’s regulated public water supplies.

The data is updated quarterly.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"pa-gov/safe-drinking-water-sample-results-information-f6wi-njzk\".\"safe_drinking_water_sample_results_information\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.