EPA Air Quality Data - Pollutants
Daily air quality data collected by the EPA Air Quality Service (AQS), from 1990-2021. This dataset includes air quality statistics from AQS monitors in the area surrounding Cambridge (Kenmore, Roxbury, Von Hillern, Chelsea). Each contains a parameter code which specifies one of the six pollutants for which the EPA AQS has an Air Quality Index (AQI).
Information on how to interpret AQI values can be found here: https://www.airnow.gov/aqi/aqi-basics/
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 \"cambridgema-gov/epa-air-quality-data-pollutants-43k6-pjtt\".\"epa_air_quality_data_pollutants\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.