Pricing

from $5.50 / 1,000 cleanup records

Try for free

Go to Apify Store

EPA RCRA Corrective Action Cleanup Timeline & Overdue Events

Try for free

Track RCRA corrective-action cleanups from EPA RCRAInfo: milestone dates, scheduled vs actual, schedule slip, overdue milestones, remedy status, engineering and institutional controls, and confirmed release media per facility.

Pricing

from $5.50 / 1,000 cleanup records

Rating

0.0

(0)

Developer

Kyle Maloney

Actor stats

Bookmarked

Total users

Monthly active users

7 days ago

Last modified

Categories

Real estate

Developer tools

Agents

Record type

record_type

Optional

facility for a per-handler cleanup rollup, event for a single decoded corrective-action event. One dataset can hold both when outputMode is "both".

Type:string | null

Example:

facility

RCRA handler ID

handler_id

Optional

The 12-character RCRAInfo handler identifier this record belongs to. Joins to EPA ECHO, RCRAInfo and to the rcra_ids field of epa-contaminated-site-screener.

Type:string | null

Example:

COD007079478

RCRAInfo activity location

activity_location

Optional

Two-character RCRAInfo activity location the event was filed under. Usually the state, but 94 national rows file under a location that differs from the handler-ID prefix, so this column is the authoritative one.

Type:string | null

Example:

Activity location name

activity_location_name

Optional

Plain-English name of the activity location, including the non-state codes: Navajo Nation (NN), Trust Territories (TT) and the EPA administrative locations XH and XJ.

Type:string | null

Example:

Colorado

Facility name

facility_name

Optional

Facility name from the EPA Facility Registry Service RCRAINFO record. null when the lookup was not requested, capped or unavailable - see site_lookup_status. Never taken from another EPA program at the same address.

Type:string | null

Example:

EATON AVIATION CORPORATION

Facility street address

facility_address

Optional

Street address from the EPA Facility Registry Service RCRAINFO record. null rather than guessed when the lookup did not resolve.

Type:string | null

Example:

2501 DALLAS ST

Facility city

facility_city

Optional

City from the EPA Facility Registry Service RCRAINFO record.

Type:string | null

Example:

AURORA

Facility state

facility_state

Optional

State from the EPA Facility Registry Service. Can differ from activity_location, which is where the corrective-action file is administered.

Type:string | null

Example:

Facility postal code

facility_zip

Optional

Postal code from the EPA Facility Registry Service RCRAINFO record.

Type:string | null

Example:

80010

Facility county

facility_county

Optional

County name from the EPA Facility Registry Service RCRAINFO record.

Type:string | null

Example:

ADAMS

FRS registry ID

frs_registry_id

Optional

EPA Facility Registry Service registry identifier, the cross-program key that joins this facility to Superfund, TRI, ECHO and air/water permitting records.

Type:string | null

Example:

110040845743

EPA region

epa_region_code

Optional

EPA region code the facility sits in, from the Facility Registry Service.

Type:string | null

Example:

ECHO detailed facility report URL

echo_facility_report_url

Optional

Direct link to the EPA ECHO Detailed Facility Report for this facility, built from the FRS registry ID. null when no registry ID resolved.

Type:string | null

Example:

https://echo.epa.gov/detailed-facility-report?fid=110040845743

Other EPA programs at this ID

frs_other_programs

Optional

Every EPA program acronym the Facility Registry Service returned for this identifier, e.g. SEMS or BR. Reported because one identifier can carry a DIFFERENT facility name under a different program, and only the RCRAINFO row is used for facility_name.

Type:array | null

Example:

RCRAINFO,SEMS

Facility lookup status

site_lookup_status

Optional

ok, not_found, no_rcrainfo_record, lookup_truncated, filter_not_applied, unavailable, skipped_lookup_cap or not_requested. lookup_truncated means EPA FRS holds more program rows for this identifier than one request returns and none of the rows read was the RCRAINFO row, so absence could not be proven; no_rcrainfo_record is used only when the returned set is demonstrably complete, checked against efservice's own exact COUNT. This is the null-versus-false contract for every facility_* field: null here never means "no such facility". unavailable means the FRS request could not complete, which is not evidence the facility is absent - EPA FRS flaps under concurrency and the same handler ID usually resolves on a later run.

Type:string | null

Example:

Event sequence

event_seq

Optional

RCRAInfo event sequence number within the handler. Part of the composite key that joins an event to its areas and authorities. Event rows only.

Type:string | null

Example:

Implementing agency

event_agency

Optional

RCRAInfo agency code that recorded the event: S state, E EPA, J joint, P other. Event rows only.

Type:string | null

Example:

Event owner

event_owner

Optional

RCRAInfo owner of the event record. Load-bearing: the event-code dictionary is keyed on (owner, code), and 212 codes mean different things under different owners. Event rows only.

Type:string | null

Example:

Corrective action event code

event_code

Optional

The full RCRAInfo corrective-action event code, e.g. CA400 or CA550RC. Event rows only.

Type:string | null

Example:

CA400

Event base code

event_base_code

Optional

First five characters of the event code, which identify the milestone. Event rows only.

Type:string | null

Example:

CA400

Event outcome suffix

event_code_suffix

Optional

Trailing characters of the event code, which carry the OUTCOME of the milestone, e.g. RC remedy constructed, NR no remedy constructed, YE yes, NO no. null when the code has no suffix. Event rows only.

Type:string | null

Example:

Event description

event_description

Optional

Verbatim description from EPA's CA_LU_EVENT_CODE dictionary, resolved on the (owner, code) composite key. null when the pair is not in the dictionary - never borrowed from another owner's entry for the same code. Event rows only.

Type:string | null

Example:

REMEDY DECISION

Event code active status

event_code_active_status

Optional

Y if the code is still in EPA's active vocabulary, N if retired. Retired codes are still decoded, because historical events use them. Event rows only.

Type:string | null

Example:

Decode basis

event_code_decode_basis

Optional

owner_code_exact when the (owner, code) pair resolved in EPA's dictionary, unresolved when it did not. An unresolved event keeps a null description rather than being guessed. Event rows only.

Type:string | null

Example:

owner_code_exact

Code ambiguous across owners

event_code_ambiguous_across_owners

Optional

True when this event code carries more than one meaning across RCRAInfo owners. 212 of the 1,076 codes do. Disclosed so a downstream consumer never keys on the bare code. Event rows only.

Type:boolean | null

Example:

false

National milestone stage

ladder_stage

Optional

Which rung of EPA's national corrective-action sequence this event belongs to, or null for a state-specific code that is not on the national ladder. Event rows only.

Type:string | null

Example:

remedy_decision

National milestone rank

ladder_rank

Optional

Ordinal position of ladder_stage, 1 (RFA initiated) to 18 (process terminated). null for state-specific codes. Event rows only.

Type:integer | null

Example:

Originally scheduled date

schedule_date_original

Optional

ISO date the milestone was originally scheduled for, or null when RCRAInfo published nothing usable. Event rows only.

Type:string | null

Example:

1998-10-28

Originally scheduled date (raw)

schedule_date_original_raw

Optional

The raw eight-digit value EPA published, preserved even when it was rejected as a sentinel or an implausible date, so nothing is silently discarded. Event rows only.

Type:string | null

Example:

19981028

Revised scheduled date

schedule_date_revised

Optional

ISO date the milestone was rescheduled to, or null when it was never rescheduled or the value was unusable. Event rows only.

Type:string | null

Example:

2005-03-30

Revised scheduled date (raw)

schedule_date_revised_raw

Optional

The raw eight-digit revised schedule value EPA published. Event rows only.

Type:string | null

Example:

20050330

Actual completion date

actual_date

Optional

ISO date the milestone was actually completed. null means RCRAInfo records no completion, which is NOT the same as the milestone being incomplete in the real world. Event rows only.

Type:string | null

Example:

1997-03-11

Actual completion date (raw)

actual_date_raw

Optional

The raw eight-digit completion value. Preserved when the value was a sentinel such as 19010101, which appears in the national export and is not a 1901 completion. Event rows only.

Type:string | null

Example:

19970311

EPA best date

best_date

Optional

EPA's own derived "best" date for the event, published in the export. Event rows only.

Type:string | null

Example:

1997-03-11

Schedule slip (days)

schedule_slip_days

Optional

Revised schedule date minus original schedule date, in days. Positive means the deadline moved later. null when either date was unusable - the national export contains pairs a century apart that would otherwise publish a 36,525-day slip. Event rows only.

Type:integer | null

Example:

Schedule slip status

schedule_slip_status

Optional

computed, not_rescheduled, revised_without_original, or undeterminable_bad_date. Distinguishes "was never rescheduled" from "was rescheduled but the dates cannot be trusted". Event rows only.

Type:string | null

Example:

computed

Schedule slip implausible

schedule_slip_implausible

Optional

True when a computed slip exceeds 20 years, which in this dataset indicates a data-entry artefact rather than a regulatory decision. null when there is no slip to judge. Event rows only.

Type:boolean | null

Example:

false

Milestone completed

milestone_completed

Optional

True when RCRAInfo carries a usable completion date for this event. Event rows only.

Type:boolean | null

Example:

true

Milestone past due

milestone_past_due

Optional

True when the effective scheduled date has passed and RCRAInfo records no completion. False when it is completed or the date is in the future. null when no schedule was ever recorded, because "past due" is then not a question that can be asked. Event rows only.

Type:boolean | null

Example:

false

Days past due

days_past_due

Optional

Days between the effective scheduled date and today, for a milestone with no recorded completion. null otherwise. Event rows only.

Type:integer | null

Example:

10156

Responsible person code

responsible_person

Optional

RCRAInfo responsible-person code recorded against the event. Event rows only.

Type:string | null

Example:

R0E/P

Suborganization

suborganization

Optional

RCRAInfo suborganization code recorded against the event. Event rows only.

Type:string | null

Example:

PMT

Public notes

public_notes

Optional

Free-text public note EPA or the state attached to the event. Populated on roughly 1.6% of national events. Event rows only.

Type:string | null

Example:

Interim measures completed.

Date quality flags

date_quality_flags

Optional

Which date columns on this event were rejected and why, e.g. actual_date_sentinel or schedule_date_original_implausible. Empty when every published date was usable. Event rows only.

Type:array | null

Example:

actual_date_sentinel

Linked area sequences

linked_area_seqs

Optional

CA_AREA sequence numbers this event is linked to through CA_AREA_EVENT. Empty when EPA links the event to no area - 4.6% of national events are unlinked. Event rows only.

Type:array | null

Example:

Linked area names

linked_area_names

Optional

Names of the contamination areas this event is linked to, e.g. ENTIRE FACILITY or a named solid waste management unit. Event rows only.

Type:array | null

Example:

ENTIRE FACILITY

Linked authority types

linked_authority_types

Optional

RCRAInfo authority-type codes the event was taken under, from CA_EVENT_AUTHORITY. Event rows only.

Type:array | null

Example:

Corrective Action module status

ca_module_status

Optional

Status of the RCRAInfo Corrective Action bulk module for this run. ok means the archive was downloaded, structurally verified and row-count reconciled against its own METADATA.txt.

Type:string | null

Example:

RCRAInfo export run ID

rcrainfo_run_id

Optional

The RCRAInfo bulk-export run this row was built from, resolved live on every run from EPA's manifest. A superseded export URL still answers HTTP 200 with the older snapshot instead of 404ing, so this is the only way to know which week you are reading.

Type:string | null

Example:

CSV-2026-08-16T03-00-00-0400

RCRAInfo export created

rcrainfo_created_date

Optional

Timestamp EPA created this export run.

Type:string | null

Example:

2026-08-16T07:00:00.064+00:00

Snapshot age (days)

rcrainfo_snapshot_age_days

Optional

How old the export run was when this row was produced. RCRAInfo refreshes weekly; the run fails rather than publishing anything older than maxSnapshotAgeDays.

Type:integer | null

Example:

Snapshot is current

rcrainfo_snapshot_is_current

Optional

True when the export used is the one EPA is currently publishing. False only when a caller deliberately pinned a different run, which this actor refuses to serve.

Type:boolean | null

Example:

true

Corrective Action module URL

ca_module_url

Optional

The exact S3 URL the Corrective Action archive was downloaded from, resolved from EPA's module manifest rather than constructed.

Type:string | null

Example:

https://s3.amazonaws.com/rcrainfo-ftp/Production/CSV-2026-08-16T03-00-00-0400/CA/CA.zip

Corrective Action module bytes

ca_module_bytes

Optional

Byte length of the downloaded archive, asserted equal to the fileSize EPA's manifest declares. A mismatch fails the run.

Type:integer | null

Example:

4554232

Data as of

data_as_of

Optional

Date portion of the export creation timestamp - the vintage of every corrective-action fact on this row.

Type:string | null

Example:

2026-08-16

Cleanup stage

cleanup_stage

Optional

Furthest COMPLETED rung of EPA's national corrective-action sequence for this facility, e.g. investigation_complete, remedy_decision, remedy_construction, process_terminated. null when nothing on the national ladder has been completed - see cleanup_stage_basis. Facility rows only.

Type:string | null

Example:

remedy_construction

Cleanup stage rank

cleanup_stage_rank

Optional

Ordinal position of cleanup_stage, 1 to 18. Sortable measure of how far a cleanup has progressed. Facility rows only.

Type:integer | null

Example:

Cleanup stage label

cleanup_stage_label

Optional

Human-readable label for cleanup_stage. Facility rows only.

Type:string | null

Example:

Remedy construction determination

Cleanup stage date

cleanup_stage_date

Optional

Completion date of the event that set cleanup_stage. Facility rows only.

Type:string | null

Example:

2014-06-30

Cleanup stage basis

cleanup_stage_basis

Optional

national_milestone_ladder, ladder_milestones_scheduled_none_completed, or state_specific_codes_only. The third value means the state files this cleanup entirely under its own codes, so progress cannot be placed on the national ladder - reported instead of guessed. Facility rows only.

Type:string | null

Example:

national_milestone_ladder

Cleanup complete

cleanup_complete

Optional

True when EPA records performance standards attained (CA900) or the corrective-action process terminated (CA999). null - never false - when the facility uses only state-specific codes, because completion is then genuinely unknown. Facility rows only.

Type:boolean | null

Example:

false

Corrective action open

corrective_action_open

Optional

The inverse of cleanup_complete, gated the same way: null when completion status is unknown rather than assumed open. Facility rows only.

Type:boolean | null

Example:

true

Corrective action events

ca_event_count

Optional

Number of corrective-action events RCRAInfo carries for this facility. Facility rows only.

Type:integer | null

Example:

Completed events

ca_event_completed_count

Optional

Events with a usable completion date. Facility rows only.

Type:integer | null

Example:

National ladder events

ladder_milestone_event_count

Optional

Events whose code is on EPA's national milestone ladder. Facility rows only.

Type:integer | null

Example:

State-specific events

state_specific_event_count

Optional

Events whose (owner, code) pair is not in the dictionary slice used for the national ladder. Facility rows only.

Type:integer | null

Example:

Unresolved event codes

unresolved_event_code_count

Optional

Events whose (owner, code) pair could not be resolved in EPA's own dictionary. Should be zero; a non-zero value means EPA shipped a code it does not define. Facility rows only.

Type:integer | null

Example:

First recorded event

first_recorded_event_date

Optional

Earliest completion date across this facility's corrective-action events. null when nothing has been completed. Facility rows only.

Type:string | null

Example:

1988-12-31

Last recorded event

last_recorded_event_date

Optional

Most recent completion date across this facility's events - the practical measure of whether a cleanup is still moving. Facility rows only.

Type:string | null

Example:

2019-07-22

Years since last event

years_since_last_recorded_event

Optional

Years between last_recorded_event_date and today. A large value on an open cleanup is the dormancy signal. Facility rows only.

Type:number | null

Example:

7.07

RFA completed

rfa_completed_date

Optional

Date the RCRA Facility Assessment was completed (CA050). Facility rows only.

Type:string | null

Example:

1996-09-19

Investigation determination

investigation_needed

Optional

EPA's CA070 determination: investigation_necessary or investigation_not_necessary. null when no determination is on file. Facility rows only.

Type:string | null

Example:

investigation_necessary

Investigation imposed

investigation_imposed_date

Optional

Date the RCRA Facility Investigation was imposed (CA100). Facility rows only.

Type:string | null

Example:

1997-03-11

Investigation complete

investigation_complete_date

Optional

Date the facility investigation was completed (CA200). Facility rows only.

Type:string | null

Example:

2001-09-28

Corrective measures study complete

cms_complete_date

Optional

Date the corrective measures study was completed (CA350). Facility rows only.

Type:string | null

Example:

2003-05-01

Remedy decision

remedy_decision_date

Optional

Date the remedy decision was issued (CA400). null when RCRAInfo records no completed remedy decision - which, paired with a past-due CA400 milestone, is the classic behind-schedule cleanup. Facility rows only.

Type:string | null

Example:

2004-08-16

Remedy design approved

remedy_design_approved_date

Optional

Earliest completion of corrective-measures design approval or CMI workplan approval (CA450 / CA500). Facility rows only.

Type:string | null

Example:

2006-02-14

Remedy construction status

remedy_construction_status

Optional

EPA's CA550 determination: remedy_constructed, no_remedy_constructed, operating_facility_remedy_deferral, or recorded_without_outcome_code. null when no determination is on file. Facility rows only.

Type:string | null

Example:

remedy_constructed

Remedy construction date

remedy_construction_date

Optional

Date of the latest CA550 remedy-construction determination. Facility rows only.

Type:string | null

Example:

2014-06-30

Stabilization construction completed

stabilization_construction_date

Optional

Date stabilization or interim-measure construction was completed (CA650). Facility rows only.

Type:string | null

Example:

1999-11-30

Human exposures controlled

human_exposures_controlled

Optional

EPA environmental indicator CA725: yes_human_exposures_controlled, more_information_needed, facility_does_not_meet_definition, no_control_measures_needed or previous_determination_not_applicable. null when EPA has made no determination. Facility rows only.

Type:string | null

Example:

yes_human_exposures_controlled

Human exposures determination date

human_exposures_controlled_date

Optional

Date of the latest CA725 determination. Facility rows only.

Type:string | null

Example:

2008-09-30

Groundwater migration controlled

groundwater_migration_controlled

Optional

EPA environmental indicator CA750: yes_groundwater_migration_controlled, more_information_needed, no_release_to_groundwater, facility_does_not_meet_definition or previous_determination_not_applicable. null when no determination exists. Facility rows only.

Type:string | null

Example:

yes_groundwater_migration_controlled

Groundwater determination date

groundwater_migration_controlled_date

Optional

Date of the latest CA750 determination. Facility rows only.

Type:string | null

Example:

2008-09-30

Ready for anticipated use

ready_for_anticipated_use

Optional

EPA's CA800 determination: ready_for_anticipated_use or not_ready_for_anticipated_use. The redevelopment signal for a CRE buyer. null when no determination is on file. Facility rows only.

Type:string | null

Example:

ready_for_anticipated_use

Ready for anticipated use date

ready_for_anticipated_use_date

Optional

Date of the latest CA800 determination. Facility rows only.

Type:string | null

Example:

2015-02-17

Performance standards attained

performance_standards_attained

Optional

EPA's CA900 determination: attained_controls_required or attained_no_controls_necessary. The first of the two ways a RCRA corrective action formally finishes. Facility rows only.

Type:string | null

Example:

attained_controls_required

Performance standards date

performance_standards_attained_date

Optional

Date performance standards were recorded as attained. Facility rows only.

Type:string | null

Example:

2016-03-31

Process terminated

ca_process_terminated

Optional

EPA's CA999 determination: no_further_action, remedial_activities_complete, or terminated. Facility rows only.

Type:string | null

Example:

no_further_action

Process terminated date

ca_process_terminated_date

Optional

Date the corrective-action process was recorded as terminated. Facility rows only.

Type:string | null

Example:

2018-11-05

Engineering controls established

engineering_controls_established_count

Optional

Number of CA770 engineering-control events on file - caps, barriers, groundwater controls. A property with engineering controls carries continuing obligations. Facility rows only.

Type:integer | null

Example:

Engineering control types

engineering_controls_types

Optional

Outcome suffixes of the CA770 events: GW groundwater control, NG non-groundwater control. Facility rows only.

Type:array | null

Example:

GW,NG

Engineering controls terminated

engineering_controls_terminated_count

Optional

Number of CA780 events terminating an engineering control. Facility rows only.

Type:integer | null

Example:

Institutional controls established

institutional_controls_established_count

Optional

Number of CA772 institutional-control events - deed restrictions, zoning, informational devices. These bind a future owner and are the single most consequential column for a CRE buyer. Facility rows only.

Type:integer | null

Example:

Institutional control types

institutional_controls_types

Optional

Outcome suffixes of the CA772 events: PR proprietary control, GC governmental control, EP enforcement and permit tools, ID informational device. Facility rows only.

Type:array | null

Example:

ID,PR

Institutional controls terminated

institutional_controls_terminated_count

Optional

Number of CA782 events terminating an institutional control. Facility rows only.

Type:integer | null

Example:

Past-due milestones

past_due_milestone_count

Optional

How many corrective-action milestones have a scheduled date in the past and no completion recorded in RCRAInfo. Read honestly: that can mean the milestone is genuinely outstanding OR that a completion was never entered. Facility rows only.

Type:integer | null

Example:

Oldest past-due code

past_due_oldest_code

Optional

Event code of the longest-outstanding milestone. Facility rows only.

Type:string | null

Example:

CA400

Oldest past-due description

past_due_oldest_description

Optional

EPA's description of the longest-outstanding milestone. Facility rows only.

Type:string | null

Example:

REMEDY DECISION

Oldest past-due scheduled date

past_due_oldest_scheduled_date

Optional

The effective scheduled date of the longest-outstanding milestone - revised date if one exists, otherwise the original. Facility rows only.

Type:string | null

Example:

1998-10-28

Oldest past-due days

past_due_oldest_days

Optional

How many days the longest-outstanding milestone has been past its scheduled date. Facility rows only.

Type:integer | null

Example:

10156

Past-due codes

past_due_codes

Optional

Distinct event codes with an outstanding scheduled milestone, up to 25. Facility rows only.

Type:array | null

Example:

CA400,CA450,CA500

Rescheduled milestones

rescheduled_milestone_count

Optional

How many milestones carry both an original and a revised schedule date that could be compared. Facility rows only.

Type:integer | null

Example:

Largest schedule slip (days)

max_schedule_slip_days

Optional

Largest plausible outward schedule slip on this facility, in days. Implausible pairs are excluded and counted separately rather than published. Facility rows only.

Type:integer | null

Example:

272

Largest slip code

max_schedule_slip_code

Optional

Event code carrying the largest plausible slip. Facility rows only.

Type:string | null

Example:

CA150

Largest slip description

max_schedule_slip_description

Optional

EPA description of the event carrying the largest plausible slip. Facility rows only.

Type:string | null

Example:

INVESTIGATION WORKPLAN APPROVED

Implausible slips excluded

implausible_schedule_slip_count

Optional

Number of computed slips exceeding 20 years, excluded from max_schedule_slip_days as data-entry artefacts. Reported so the exclusion is visible rather than silent. Facility rows only.

Type:integer | null

Example:

Contamination areas

area_count

Optional

Number of CA_AREA records EPA carries for this facility - the distinct areas of concern or solid waste management units under corrective action. Facility rows only.

Type:integer | null

Example:

Area names

area_names

Optional

Names of the contamination areas, up to 25. Facility rows only.

Type:array | null

Example:

ENTIRE FACILITY,OFF-SITE AREA

Entire-facility areas

entire_facility_area_count

Optional

How many areas are flagged as covering the entire facility rather than a discrete unit. Facility rows only.

Type:integer | null

Example:

Regulated-unit areas

regulated_unit_area_count

Optional

How many areas are RCRA regulated units. Facility rows only.

Type:integer | null

Example:

Reported acreage total

reported_acreage_total

Optional

Sum of AREA ACREAGE across the areas that actually report one. null when no area reports acreage - never zero, because 87% of national areas publish no acreage and a bare sum would present a fraction of the footprint as the whole. Facility rows only.

Type:number | null

Example:

12.5

Areas reporting acreage

reported_acreage_area_count

Optional

How many of this facility's areas contributed to reported_acreage_total. The denominator that makes the sum readable. Facility rows only.

Type:integer | null

Example:

Unparseable acreage values

unparseable_acreage_count

Optional

Areas whose published acreage could not be read as a number. Counted rather than coerced to zero. Facility rows only.

Type:integer | null

Example:

Air release

air_release

Optional

yes, no or not_reported. EPA's AIR RELEASE IND is three-valued and blank on 89% of national areas, so not_reported is by far the most common answer and is NOT a clean bill. Facility rows only.

Type:string | null

Example:

not_reported

Air release confirmed

air_release_confirmed

Optional

True only where EPA affirmatively records an air release, false where EPA records none, null where nothing was reported. Facility rows only.

Type:boolean | null

Groundwater release

groundwater_release

Optional

yes, no or not_reported, rolled up across the facility's areas. Facility rows only.

Type:string | null

Example:

yes

Groundwater release confirmed

groundwater_release_confirmed

Optional

True/false/null form of groundwater_release. null means not reported, never "no release". Facility rows only.

Type:boolean | null

Example:

true

Soil release

soil_release

Optional

yes, no or not_reported, rolled up across the facility's areas. Facility rows only.

Type:string | null

Example:

yes

Soil release confirmed

soil_release_confirmed

Optional

True/false/null form of soil_release. Facility rows only.

Type:boolean | null

Example:

true

Surface water release

surface_water_release

Optional

yes, no or not_reported, rolled up across the facility's areas. Facility rows only.

Type:string | null

Example:

not_reported

Surface water release confirmed

surface_water_release_confirmed

Optional

True/false/null form of surface_water_release. Facility rows only.

Type:boolean | null

Confirmed release media

confirmed_release_media

Optional

The media EPA affirmatively records a release to: air, groundwater, soil, surface_water. An empty array means none was affirmatively recorded, which is not the same as none exists. Facility rows only.

Type:array | null

Example:

groundwater,soil

Authorities on file

authority_count

Optional

Number of legal authorities RCRAInfo records for this facility's corrective action. Facility rows only.

Type:integer | null

Example:

Authority type codes

authority_types

Optional

RCRAInfo authority-type codes, e.g. C consent decree, O operating permit, V voluntary corrective action. Facility rows only.

Type:array | null

Example:

O,X

Authority type labels

authority_type_labels

Optional

Decoded authority names from EPA's CA_LU_AUTHORITY table. An unmapped code is surfaced as unmapped_authority_type: rather than dropped. Facility rows only.

Type:array | null

Example:

Operating Permit,Agency Policy/Procedure

Earliest authority date

earliest_authority_date

Optional

Earliest authority effective date on file - roughly when the cleanup obligation attached. Facility rows only.

Type:string | null

Example:

1989-01-25

Under enforcement authority

under_enforcement_authority

Optional

True when at least one authority is an order or decree rather than a permit or policy. null when EPA records no authority at all, never false. Facility rows only.

Type:boolean | null

Example:

false

Events with date-quality flags

events_with_date_quality_flags

Optional

How many of this facility's events carried a date EPA published that could not be used - a sentinel, a malformed value or a pre-RCRA year. Facility rows only.

Type:integer | null

Example:

Matched facilities total

matched_facilities_total

Optional

How many facilities matched the query before the maxResults cap was applied. Compare with the row count to see what a capped run left behind.

Type:integer | null

Example:

Results truncated

results_truncated

Optional

True when the maxResults cap stopped rows being emitted. A capped answer is never presented as a complete one.

Type:boolean | null

Example:

false

Drift gate status

drift_gate_status

Optional

verified when every live drift probe passed, verified_degraded when only a corroborating probe could not complete. A failing gate emits no rows at all, so these are the only two values that can appear on a row.

Type:string | null

Example:

verified

Drift probes verified

drift_probes_verified

Optional

Comma-separated names of the live probes that passed before any row was emitted.

Type:string | null

Example:

manifest_info,snapshot_pin,manifest_modules,module_download

Drift probes unavailable

drift_probes_unavailable

Optional

Comma-separated names of probes that could not complete. Empty on a fully verified run.

Type:string | null

Example:

Drift gate note

drift_gate_note

Optional

Human-readable disclosure when the run proceeded with a corroborating probe unavailable. null on a fully verified run.

Type:string | null

EPA ECHO Facility Radius Search by Address

malekh/epa-echo-facility-radius

Find every EPA-regulated facility within a radius of a US address, from EPA's ECHO database. Returns distance and direction, Clean Air / Clean Water / RCRA / SDWA / TRI / Superfund program IDs, compliance status, inspection dates, enforcement actions and penalty dollars.

Malek H

EPA Envirofacts Facilities Scraper

parseforge/epa-envirofacts-facilities-scraper

Scrapes EPA-regulated facility records from seven Envirofacts tables including TRI, RCRA, NPDES, and FRS. Returns each facility as a flat row with registry IDs and location, filterable by state, city, ZIP, and NAICS code.

ParseForge

EPA Envirofacts TRI Facility Scraper

crawlerbros/epa-envirofacts-scraper

Scrape EPA Envirofacts Toxic Release Inventory (TRI) facility data. Search by city, state, or facility name. Returns facility name, address, coordinates, EPA region, and parent company. No API key required.

Crawler Bros

EPA ECHO Enforcement Scraper — Violations API

nexgendata/epa-echo-enforcement-scraper

Scrape EPA ECHO facilities — CWA, CAA, RCRA programs. Identity, address, NAICS, NPDES/AIR/RCRA permits, inspections, SNC status, qtrs in significant violation, total penalties USD, 13-qtr compliance history. ESG screens, plaintiff law firms, M&A diligence, journalism.

NexGenData

EPA ECHO Violation Monitor: Facility Changes

getascraper/epa-echo-violation-monitor

Monitor official EPA ECHO facility compliance, violation, enforcement, and penalty records by facility ID, state, or EPA region. Return source-linked NEW, CHANGED, and REMOVED events for EHS, due-diligence, and compliance teams.

GetAScraper

EPA Facility Scraper — Violations & Penalties | $9.9/1K

bovi/epa-data-scraper

Search US EPA regulated facilities by state. Returns compliance status, violation history, enforcement actions, and penalties across Clean Water Act, Clean Air Act, RCRA, and Drinking Water programs.

Vitalii Bondarev

EPA TRI Toxic Release Facilities — Records API

nexgendata/epa-tri-toxic-release-facilities

EPA Toxics Release Inventory (TRI) reporting facilities by state and city: facility name, address, county, FIPS, EPA region. For ESG, environmental compliance, and community researchers.

NexGenData

EPA ECHO Compliance Diff API — CAA, CWA, RCRA, SDWA Enforcement

changewire/epa-echo-compliance

Purpose-built diff stream for EPA ECHO — facility-flip / violation-class / enforcement-case / CAA/CWA/RCRA/SDWA permit changes as JSONL. ECHO-API-native vocab vs general-purpose scrapers like Browse AI; per-record metered vs Cority $30-200k/yr seat tax for ESG, EJ, journalism, NGOs. Public runs.

ChangeWire

EPA ECHO Enforcement & Facility Watch Scraper

taroyamada/epa-echo-enforcement-facility-watch-scraper

Track EPA ECHO public facility, enforcement, and compliance-summary signals by state, program, facility, company, and watch terms.

naoki anzai

EPA RCRA Hazardous Waste Generator Rollup — Tons, Codes, LQG

malonestar/epa-rcra-hazwaste-generator-rollup

Every RCRA hazardous waste generator in a US state, rolled up from the EPA Biennial Report: tons generated, shipped, managed and received; federal waste codes split into listed, characteristic and acute; LQG/SQG status; EPA management methods; the TSDFs used; and a cycle-over-cycle trend.