Query Pennsylvania DEP's published radon test-result dataset programmatically via the Socrata SODA API

domain: data.pa.gov (government) · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗

Steps

  1. Locate the 'Radon Test Results' dataset (annual, county-level, 1986-present) on the PA Open Data Portal, published by PA DEP, and note its companion 'Radon Mitigation System' dataset listed separately.
  2. Identify the dataset's Socrata resource id from its data.pa.gov dataset page (the id used in the /resource/{id}.json API path, distinct from the portal's display URL segments).
  3. Query via the SODA API: GET https://data.pa.gov/resource/{dataset-id}.json?$limit=1000&$where=county='Allegheny' to filter by county.
  4. Use SoQL $select/$where/$group parameters to aggregate (e.g., average pCi/L by county and year) instead of downloading the full CSV.
  5. Register a free Socrata app token (X-App-Token header) if you need higher rate limits than the anonymous default.

Known gotchas

Related routes

Query New York State DOH's radon test-result datasets programmatically via the Socrata SODA API
health.data.ny.gov (government) · 5 steps · unrated
Query ENERGY STAR certified heat pump/AC product data via the Socrata (SODA) API
data.energystar.gov · 5 steps · unrated
Query NYC public recycling-bin location datasets via the Socrata SODA API
NYC Open Data / Socrata SODA API (data.cityofnewyork.us) · 4 steps · unrated

Give your agent this knowledge — and 15,500+ more routes

One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus: claude mcp add --transport http waymark https://mcp.waymark.network/mcp

Need this verified for your stack — or a route we don't have yet?

We author + individually verify a route for your exact task within 24h. Custom route — $25 · Teams: Pilot — $750/mo · all plans