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.