U.S. EPA Superfund Sites and Cleanup Status Database v.1.0.0
1,721 Database Records
Explore 1,721 sites in the U.S. Environmental Protection Agency's official proposed, final, and deleted National Priorities List universe. Each primary record preserves the stable EPA and SEMS identifiers, official site name and location, EPA region, primary site coordinate when available, federal-facility and Native American interest flags, exact NPL lifecycle status, official site category, HRS score when supplied, and proposed, final, and deleted milestone dates. A normalized contaminant table retains distinct EPA site-to-contaminant and CAS relationships without collapsing cardinality or implying current concentrations, media, property conditions, or health risk. The protected release includes matching UTF-8 CSV, JSON, SQLite, schemas, samples, statistics, source documentation, and careful limitations.
Table Schema Database Field Statistics
Release structure
U.S. EPA Superfund Sites and Cleanup Status Database
Review the published tables, record coverage, and field names included with release 1.0.0.
- Database
- #808
- Version
- 1.0.0
- Format
- XML schema
Data dictionary
Tables and fields
| Field | Type | Required | Description |
|---|---|---|---|
| epa_site_id | text | Yes | Stable 12-character EPA site identifier preserved as text. |
| sems_site_id | text | Yes | SEMS internal site identifier preserved as text, including leading zeroes. |
| site_name | text | Yes | Official SEMS site name. |
| street_address | text | Yes | Official site-level street address assembled from the two source address fields. |
| city | text | Yes | Official city or nearest-place value. |
| county | text | No | Official county value. |
| state | text | Yes | Official two-character state or territory code. |
| zip_code | text | No | Official ZIP code preserved as text, including leading zeroes. |
| epa_region | text | Yes | Official EPA region code preserved as text. |
| latitude | number | Yes | EPA primary latitude when supplied. |
| longitude | number | Yes | EPA primary longitude when supplied. |
| coordinate_source | text | Yes | Official FOIA-015 SEMS report. |
| coordinate_precision_class | text | Yes | Point representation classified only as EPA primary site coordinate or unavailable; not a parcel boundary. |
| federal_facility_flag | boolean | Yes | True only when the official FF field is Y. |
| native_american_interest_flag | boolean | Yes | True only when the official NAI field is Y. |
| tribe_names | text | No | Official source tribe-name value when supplied. |
| npl_status | text | Yes | Controlled release value: PROPOSED, FINAL, or DELETED. |
| npl_status_official | text | Yes | Exact official NPL status wording from the source. |
| site_category | text | Yes | Official SEMS site category. |
| site_category_code | text | Yes | Official SEMS site category code. |
| hrs_score | number | No | Official Hazard Ranking System score when supplied; not an exposure or property-risk score. |
| proposed_npl_date | text | Yes | Official proposed NPL date in ISO format when supplied. |
| final_npl_date | text | No | Official finalized listing date in ISO format when supplied. |
| deleted_npl_date | text | No | Official NPL deletion date in ISO format when supplied. |
| lifecycle_chronology_note | text | No | Explicit note when official dates show a prior deletion followed by later relisting. |
| contaminant_count | integer | Yes | Count of distinct official site-to-contaminant relationships retained in the normalized table. |
| official_profile_url | text | Yes | EPA Superfund profile route keyed by the official SEMS site ID. |
| source_updated_date | text | Yes | Official report publication date. |
| source_url | text | Yes | Direct official EPA source endpoint. |
| retrieved_at | text | Yes | UTC source retrieval timestamp. |
| reviewed_date | text | Yes | Oddity release review date. |
Release at a glance
What is inside this database
Validated release statistics.
epa_site_idStable 12-character EPA site identifier preserved as text.
- Distinct
- 1,721
- Missing
- 0.0%
sems_site_idSEMS internal site identifier preserved as text, including leading zeroes.
- Distinct
- 1,721
- Missing
- 0.0%
site_nameOfficial SEMS site name.
- Distinct
- 1,721
- Missing
- 0.0%
street_addressOfficial site-level street address assembled from the two source address fields.
- Distinct
- 1,701
- Missing
- 0.0%
cityOfficial city or nearest-place value.
- Distinct
- 1,275
- Missing
- 0.0%
countyOfficial county value.
- Distinct
- 589
- Missing
- 1.5%
stateOfficial two-character state or territory code.
- Distinct
- 56
- Missing
- 0.0%
zip_codeOfficial ZIP code preserved as text, including leading zeroes.
- Distinct
- 1,451
- Missing
- 0.1%
epa_regionOfficial EPA region code preserved as text.
- Distinct
- 10
- Missing
- 0.0%
latitudeEPA primary latitude when supplied.
- Distinct
- 1,712
- Missing
- 0.0%
longitudeEPA primary longitude when supplied.
- Distinct
- 1,715
- Missing
- 0.0%
coordinate_sourceOfficial FOIA-015 SEMS report.
- Distinct
- 1
- Missing
- 0.0%
coordinate_precision_classPoint representation classified only as EPA primary site coordinate or unavailable; not a parcel boundary.
- Distinct
- 1
- Missing
- 0.0%
federal_facility_flagTrue only when the official FF field is Y.
- Distinct
- 2
- Missing
- 0.0%
native_american_interest_flagTrue only when the official NAI field is Y.
- Distinct
- 2
- Missing
- 0.0%
tribe_namesOfficial source tribe-name value when supplied.
- Distinct
- 114
- Missing
- 89.6%
npl_statusControlled release value: PROPOSED, FINAL, or DELETED.
- Distinct
- 3
- Missing
- 0.0%
npl_status_officialExact official NPL status wording from the source.
- Distinct
- 3
- Missing
- 0.0%
site_categoryOfficial SEMS site category.
- Distinct
- 60
- Missing
- 0.0%
site_category_codeOfficial SEMS site category code.
- Distinct
- 60
- Missing
- 0.0%
hrs_scoreOfficial Hazard Ranking System score when supplied; not an exposure or property-risk score.
- Distinct
- 769
- Missing
- 6.5%
proposed_npl_dateOfficial proposed NPL date in ISO format when supplied.
- Distinct
- 90
- Missing
- 0.0%
final_npl_dateOfficial finalized listing date in ISO format when supplied.
- Distinct
- 93
- Missing
- 1.8%
deleted_npl_dateOfficial NPL deletion date in ISO format when supplied.
- Distinct
- 346
- Missing
- 74.8%
lifecycle_chronology_noteExplicit note when official dates show a prior deletion followed by later relisting.
- Distinct
- 3
- Missing
- 99.8%
contaminant_countCount of distinct official site-to-contaminant relationships retained in the normalized table.
- Distinct
- 129
- Missing
- 0.0%
official_profile_urlEPA Superfund profile route keyed by the official SEMS site ID.
- Distinct
- 1,721
- Missing
- 0.0%
source_updated_dateOfficial report publication date.
- Distinct
- 1
- Missing
- 0.0%
source_urlDirect official EPA source endpoint.
- Distinct
- 1
- Missing
- 0.0%
retrieved_atUTC source retrieval timestamp.
- Distinct
- 1
- Missing
- 0.0%
reviewed_dateOddity release review date.
- Distinct
- 1
- Missing
- 0.0%
Records Information
One primary record represents one stable 12-character EPA site ID in the official proposed, final, or deleted NPL universe. Repeated workbook rows are consolidated only when every site-level field agrees. Contaminants remain a normalized one-to-many relation keyed to the EPA site ID. The broader active and archived SEMS evaluated-site inventories are outside this release and are not mislabeled as NPL sites.
Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.
RECENT DATA UPDATES
Custom Data Solutions
Tell us the industry, geography, fields, and format you need. We can help assemble a practical dataset for your project.
Discuss your data needs