Icon for Socrata external plugin
Open repository in Console
Updated over 1 year ago
Indexed 3 hours ago

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 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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"pa-gov/safe-drinking-water-sample-results-information-f6wi-njzk\".\"safe_drinking_water_sample_results_information\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • safe_drinking_water_sample_results_information
Upstream Metadata