AMEND Data Sets

AMEND Database

The Archive of Massachusetts ENvironmental Data includes data from a variety of governmental and other public sources, unified in a freely distributed database. The tables from this database are also provided individually as csv files at the links below.

Download the AMEND SQLite unified database. SQLite databases are a simple and efficient format for distributing queryable datasets. You can read more about sqlitehere and read about how to interact with SQLite databases in the R and python languages here. Each analysis on this site draws directly from this database, so the open source scripts underlying those analyses can also serve as tutorials for using the database.

Test a live demo of the AMEND database in your browser. You can execute sample queries and generate results from the database on this page, without the need for any special software.

Each individual constituent dataset in the AMEND database is listed below. Each dataset page describes the source of the data, uses visualizations or tables to illustrate its content, and provides a download of a csv-formatted version of the dataset.

MA Environmental Datasets

• MA Energy and Environmental Affairs Data Portal Assets
• EPA Region 1 NPDES permit documets
• EPA 303(d) Integrated List of MA Impaired Waters
• EPA Massachusetts EJSCREEN data
• Massachusetts Department of Environmental Protection enforcement action data
• Massachusetts Department of Environmental Protection staffing data
• MA MS4 Municipal Stormwater Annual Reports
• Massachusetts Department of Environmental Protection budget data
• New England Center for Investigative Reporting 2011 MA Combined Sewer Overflow data

Supporting Datasets

• US Census American Community Survey data
• US Census State Population Estimate data
• The Environmental Council of States state environmental budget data
• Massachusetts Daily Precipitation
• Social Security Administration wage data