Website and analysis code for AMEND, the Archive of Massachusetts Environmental Data
In August of 2017, the MA Executive Office of Energy and Environmental Affairs (EEA) began operating an “Enterprise Data Portal” for certain state regulatory data. Initially, this has included permit, facilities, inspections, and enforcement, and drinking water testing data; more data assets are promised “regularly.”
Data on combined sewer overflows (CSOs) were added in 2022 and now incorporated in AMEND. Other data tables added to the portal in recent years are not yet integrated.
Definitions, FAQs, disclaimers, and other information related to these datasets is available in PDF format at the EEA Data Portal website’s help page and archived here:
One of these datasets, the historical drinking water quality measurement dataset, is significantly larger than the other (>200 MB in total). Because this measurement-level drinking water quality reporting is not instrumental to the goals of AMEND, we do not include it in our integrated database. We do provide an archived version of the complete drinking water dataset below.
The data from this portal has been archived on this site, last updated on 24 June 2023 09:33 am. The CSO data is queried using a separate script and was last updated on 17 October 2023 11:07 pm.
In addition to including them in them in the integrated AMEND Database, we provide our archives of each of these data assets in CSV format:
For brevity, a random sample of 10 rows from each table and a subset of all columns is shown below for illustration as to the tables’ form and content.
Enforcement Date | Enforcement Type | Facility Name | Penalty Assessed | Program | Town |
---|---|---|---|---|---|
2018-04-19T00:00:00 | Notice Of Non-Compliance | VIXS AUTO SERVICES INC | REGULATED ACTIVITY(S) | SOMERVILLE | |
2009-04-01T00:00:00 | Notice Of Non-Compliance | HAMPSHIRE REGIONAL HIGH SCHOOL | 0.0 | WATER SUPPLY/DRINKING WATER | WESTHAMPTON |
2000-07-24T00:00:00 | Notice Of Non-Compliance | MALDEN HIGH SCHOOL | REGULATED ACTIVITY(S) | MALDEN | |
1996-01-24T00:00:00 | Field Notice Of Non Compliance | MEDICALAB INC XRAY | REGULATED ACTIVITY(S) | COHASSET | |
2019-01-31T00:00:00 | Notice Of Non-Compliance | WILLIAMSBURG WATER DEPT | 0.0 | WATER SUPPLY/DRINKING WATER | WILLIAMSBURG |
2014-12-16T00:00:00 | Notice Of Non-Compliance | GARBER FAMILY DENTISTRY | REGULATED ACTIVITY(S) | SALEM | |
2002-10-24T00:00:00 | Penalty Assessment Notice | COMMONWEALTH TANK INC | 45000.0 | REGULATED ACTIVITY(S) | WAKEFIELD |
2019-10-08T00:00:00 | Reporting Penalty Assessment Notice | WEST ISLAND MARINA | 500.0 | REGULATED ACTIVITY(S) | FAIRHAVEN |
2014-12-16T00:00:00 | Notice Of Non-Compliance | AFFORDABLE DENTAL CENTER | REGULATED ACTIVITY(S) | DRACUT | |
2009-11-02T00:00:00 | Notice Of Non-Compliance | KRIPALU CENTER | 0.0 | WATER SUPPLY/DRINKING WATER | STOCKBRIDGE |
Facility Name | Facility Type | Program | Street Name | Town | Active |
---|---|---|---|---|---|
MIENTKIEWICZ JAMES | DEP REGULATED FACILITY | REGULATED ACTIVITY(S) | 560 HOLMES ST | HANSON | True |
OUR LADY OF LOURDES CHURCH | DEP REGULATED FACILITY | REGULATED ACTIVITY(S) | STATE HIGHWAY ROUTE 6 | WELLFLEET | True |
HOLIDAY AUTO SALES | DEP REGULATED FACILITY | REGULATED ACTIVITY(S) | 810 QUAKER HWY | UXBRIDGE | True |
MAY GRAPHICS & PRINTING | DEP REGULATED FACILITY | REGULATED ACTIVITY(S) | 359 LITTLETON RD | WESTFORD | True |
ANDOVER HEALTHCARE INC | DEP REGULATED FACILITY | REGULATED ACTIVITY(S) | 9 FANARAS DR | SALISBURY | True |
SIGLER MACHINE CO | DEP REGULATED FACILITY | REGULATED ACTIVITY(S) | 3 NORTHEAST BLVD | STERLING | True |
SCITUATE TOWN OF | DEP REGULATED FACILITY | REGULATED ACTIVITY(S) | SOUTHEAST CHANNEL SOUTH RIV | SCITUATE | True |
SPENCER METAL FINISHING | DEP REGULATED FACILITY | REGULATED ACTIVITY(S) | 55 MILL ST | BROOKFIELD | False |
HOLYOKE GAS & ELECTRIC DEPT | DEP REGULATED FACILITY | REGULATED ACTIVITY(S) | 102 CABOT ST | HOLYOKE | True |
ALL SET PRESS, LLC | DEP REGULATED FACILITY | REGULATED ACTIVITY(S) | 121 MADISON ST | MALDEN | False |
Facility Name | Inspection Date | Inspection Type | Program | Town |
---|---|---|---|---|
EASTHAM LANDFILL | 1996-02-09T00:00:00 | Unannounced Single-Media Inspection | REGULATED ACTIVITY(S) | EASTHAM |
CAPE COD SPACE FORCE STATION | 2009-07-15T00:00:00 | Limited Inspect for Compliance Indicators/Field Presence | REGULATED ACTIVITY(S) | BOURNE |
ASHBURNHAM WATER DEPARTMENT | 1997-03-13T00:00:00 | PERMIT (QUALIFICATION/REVIEW/COMPLIANCE) | WATER SUPPLY/DRINKING WATER | ASHBURNHAM |
SANDWICH WATER DISTRICT | 2002-05-22T00:00:00 | TECHNICAL ASSISTANCE (NON-SPECIFIC) | WATER SUPPLY/DRINKING WATER | SANDWICH |
DEERFIELD PAPER SLUDGE LANDFILL | 2016-09-13T00:00:00 | Solid Waste Visit Limited Enforcement Potential | REGULATED ACTIVITY(S) | MONROE |
TOWER STORAGE | 2000-10-24T00:00:00 | ReInspection | REGULATED ACTIVITY(S) | CLINTON |
COTTAGE STREET LANDFILL CLOSURE PROJECT | 2005-03-14T00:00:00 | Drive By Inspection | REGULATED ACTIVITY(S) | SPRINGFIELD |
FIRST BUCKEYE CORP | 2001-10-18T00:00:00 | Announced Single-Media Inspection | REGULATED ACTIVITY(S) | MARSHFIELD |
IRVING OIL TERMINALS INC | 2012-01-26T00:00:00 | Limited Inspect for Compliance Indicators/Field Presence | REGULATED ACTIVITY(S) | REVERE |
SEALED AIR CORP | 2013-01-09T00:00:00 | Limited Inspect for Compliance Indicators/Field Presence | REGULATED ACTIVITY(S) | HOLYOKE |
DateApplied | FacilityName | FinalDecisionDate | PermitNumber | PermitType | Program | Status | StreetName | Subtype | Town |
---|---|---|---|---|---|---|---|---|---|
2000-12-27T00:00:00 | SAFETY KLEEN SYSTEMS INC | 2010-11-10T00:00:00 | 51005520 | HW08 | HAZARDOUS WASTE | Approved | 50A BRIGHAM ST | TSD Operation License Or Closure Plan (IRP) | MARLBOROUGH |
1997-07-16T00:00:00 | ORLEANS MARKETPLACE | 1997-08-12T00:00:00 | 131079 | WP67 | WATER POLLUTION CONTROL | Approved | 136 RTE 6A | APPROVAL OF SEWER PUMPS PRIOR TO THE SEPTIC TANK | ORLEANS |
2000-08-24T00:00:00 | VA BOSTON HEALTHCARE SYSTEM | 2001-04-05T00:00:00 | W013009 | AQ02 | AIR QUALITY CONTROL | Approved | 940 BELMONT ST | Plan Approval Non-Major Comprehensive | BROCKTON |
MICHAEL J MORSE | 2021-10-13T14:01:14 | WS10-0002276 | WS10 | WATER SUPPLY/DRINKING WATER | Active | 20 BELLI AVE | WS10 | FITCHBURG | |
1998-02-19T00:00:00 | GRAUEL LOUISA | 1998-07-20T00:00:00 | 124153 | WW01A | WETLANDS & WATERWAYS | Approved | 288 HUCKINS NECK RD | Water-Dependent License Residential <= 4 units | BARNSTABLE |
2013-01-28T00:00:00 | CHERRY VALLEY WATER DIST | 2013-03-11T00:00:00 | X254479 | WS21C | WATER SUPPLY/DRINKING WATER | Approved | 184 HENSHAW ST | Approval to Conduct Pilot Study 200K/Under 1M GPD | LEICESTER |
DAVID SCOTT SPENCER | 2019-04-05T12:51:51 | AL-0045909 | AL | PESTICIDE | Active | 78 STANDISH AVE | PESTICIDE CREDENTIAL | PLYMOUTH | |
2022-06-22T00:00:00 | SANDWICH WATER DISTRICT | 2022-07-07T00:00:00 | X289128 | WS32 | WATER SUPPLY/DRINKING WATER | Approved | 72 TUPPER RD | Distribution Modification for Sys Serving Over 3300 People | SANDWICH |
1999-05-06T00:00:00 | FORD ROBERT | 2000-10-19T00:00:00 | 137557 | WW01A | WETLANDS & WATERWAYS | Approved | PIERCES POINT LN | Water-Dependent License Residential <= 4 units | WESTPORT |
JEFF SHILLCUTT | 2023-05-12T16:08:56 | PR-0006454 | PR | PESTICIDE | Active | ATTN: JEFF SHILLCUTT, 17635 NE 67TH CT | PRODUCT REGISTRATION | REDMOND |
Chemical Name | Class | Collected Date | Contaminant Group | Location Name | Public Water System Name | Raw or Finished | Measurement Result | Town |
---|---|---|---|---|---|---|---|---|
PARA-DICHLOROBENZENE | COM | 2023-02-01T00:00:00 | VOC | SCHOOL G.P. WELL | HAMILTON WATER DEPT | F | ND | HAMILTON |
PERFLUOROBUTANESULFONIC ACID-PFBS | NTNC | 2022-01-03T00:00:00 | PFAS | POINT OF ENTRY | JACOBS PILLOW DANCE FESTIVAL | F | ND | BECKET |
PARA-DICHLOROBENZENE | NC | 2014-08-20T00:00:00 | VOC | WELL #1 | GRAND VIEW | F | ND | MENDON |
1,1,1,2-TETRACHLOROETHANE | NC | 2022-02-14T00:00:00 | VOC | FINISHED: WELL #1 | HOLY VIRGIN MARY SPIRITUAL VINEYARD | F | ND | CHARLTON |
PCB AROCLOR 1248 | COM | 2023-05-10T00:00:00 | SOC | GP WELL # 1 | BUZZARDS BAY WATER DISTRICT | F | ND | BOURNE |
BROMOMETHANE | COM | 2023-05-03T00:00:00 | VOC | RIVERNECK #1 WELL-RAW WATER | CHELMSFORD WATER DISTRICT | R | ND | CHELMSFORD |
1,1-DICHLOROPROPENE | NC | 2021-07-07T00:00:00 | VOC | RAW WATER: WELL #1 | CHARLTON PLAZA | R | ND | CHARLTON |
ATRAZINE | COM | 2012-11-15T00:00:00 | SOC | CHURCH LANE TREATMENT PLANT | NORTH SAGAMORE WATER DISTRICT | F | ND | BOURNE |
MANGANESE | COM | 2020-09-11T00:00:00 | SECCON | VINE BROOK GWTF - FINISHED | BURLINGTON WATER DEPT | F | 0.013 | BURLINGTON |
PERFLUOROBUTANESULFONIC ACID-PFBS | COM | 2023-01-17T00:00:00 | PFAS | POINT OF ENTRY POST TREATMENT | CHESTER WATER DEPT | F | ND | CHESTER |
Year | Public Water System Name | Contaminant Group | Raw or Finished | Result |
---|---|---|---|---|
2003.0 | HARVARD RIDGE CONDOMINIUM | INORG | F | 70 |
2015.0 | TURNERS FALLS WATER DEPT | SOC | F | 45 |
1997.0 | WESTMINSTER DEPARTMENT OF PUBLIC WORKS | NITRAT | F | 1 |
1996.0 | SHARON WATER DEPT | THM | F | 1 |
2014.0 | BERLIN MEMORIAL SCHOOL | NITRIT | F | 1 |
2014.0 | MCI NORFOLK/CEDAR JUNCTION/WALPOLE | NITRAT | F | 2 |
2000.0 | AYER DPW WATER DIVISION | NITRIT | F | 1 |
2009.0 | JOHN ROAD INDUSTRIAL PARK | PERCHL | F | 1 |
2003.0 | WEST BOYLSTON WATER DISTRICT | INORG | F | 49 |
2018.0 | MONROE WATER DISTRICT | SECCON | F | 2 |
Year | Incident ID | incidentDate | Reporter Class | Event Type | Water Body | Municipality | Volume |
---|---|---|---|---|---|---|---|
2023 | 741d1606-27a2-41ec-8fcb-1bbd15521123 | 2023-04-15 | Verified Data Report | CSO – UnTreated | CONNECTICUT R. | SPRINGFIELD | 190000 |
2023 | 096c54ab-e835-4f68-aa5f-08d905a157af | 2023-08-08 | Verified Data Report | CSO – UnTreated | MOUNT HOPE BAY | FALL RIVER | 996698 |
2023 | 4452d010-b4d5-4543-aeb0-517316d0bf33 | 2023-07-29 | Public Notification Report | CSO – UnTreated | MERRIMACK RIVER | HAVERHILL | |
2022 | 36295256-5b23-4a3e-bbef-4f30887bc83e | 2022-07-12 | Verified Data Report | CSO – UnTreated | CONNECTICUT R. | HOLYOKE | 11335 |
2023 | 1d4cb7c9-bf6c-4204-bdec-38c55dd8cc9b | 2023-09-29 | Public Notification Report | CSO – UnTreated | ACUSHNET RIVER | NEW BEDFORD | |
2023 | 7ba6d447-f8f3-4285-bdbe-d087a8484cf7 | 2023-03-13 | Verified Data Report | CSO – Treated | TAUNTON RIVER | FALL RIVER | 780000 |
2023 | c88f8602-2491-4fa5-bcd6-7cd1755a9aab | 2023-04-01 | Public Notification Report | CSO – UnTreated | ACUSHNET RIVER | NEW BEDFORD | |
2023 | f594053b-655f-4c96-954d-b74e05c41c0e | 2023-06-28 | Verified Data Report | CSO – UnTreated | CHICOPEE R. | SPRINGFIELD | 249000 |
2023 | b8ea2a80-633c-45bf-acb3-0525dccc6ccc | 2023-01-26 | Public Notification Report | SSO – System Surcharging Under High Flow Conditions | Other | AMESBURY | |
2022 | 70c381ab-c2be-45c9-8ee3-de4bb5f62e66 | 2022-09-13 | Verified Data Report | CSO – UnTreated | OUTER NEW BEDFORD HARBOR | NEW BEDFORD | 160000 |