Radon Mitigation System Year 1987 - Current Annual County Environmental Protection

The radon mitigation database keeps track of when mitigation has occurred at locations and of the levels of radiation reduction achieved. The data derived in the State of Pennsylvania is published and searchable online on the www.pa.gov website. This data will be updated annually for the prior calendar year in the first Quarter of the following year.

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/radon-mitigation-system-year-1987-current-annual-vm4e-6nir\".\"radon_mitigation_system_year_1987_current_annual\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.