Primary NAICS
primary_naics
Optional
Primary NAICS industry code of the facility.
EPA RCRA Hazardous Waste Generator Rollup — Tons, Codes, LQG
Pricing
from $4.40 / 1,000 results
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.
Handler ID
handler_id
Optional
EPA RCRA handler ID (EPA ID number) of the hazardous-waste generator.
Facility name
handler_name
Optional
Reported facility / handler name.
City
city
Optional
Facility location city.
State
state
Optional
Two-letter state code.
ZIP
zip
Optional
Facility location ZIP code.
County
county
Optional
Facility county name.
Primary NAICS
primary_naics
Optional
Primary NAICS industry code of the facility.
Report cycle
report_cycle
Optional
RCRA Biennial Report cycle year.
Total generation (tons)
total_generation_tons
Optional
Sum of hazardous-waste tons generated across the facility waste-stream lines for the cycle. NULL when no line reported a tonnage at all (never coerced to 0).
Total shipped (tons)
total_shipped_tons
Optional
Sum of hazardous-waste tons shipped off-site.
Total managed (tons)
total_managed_tons
Optional
Sum of hazardous-waste tons managed on-site across every BR line, including waste received from other companies. Null for the whole 2021 cycle, where EPA publishes no managed_tons. See managed_tons_own_generation / managed_tons_from_received for the split.
Waste streams
n_waste_streams
Optional
Number of Biennial Report lines the facility filed, of every form type. See n_generated_waste_streams / n_received_waste_streams / n_no_activity_lines for the breakdown.
Distinct waste codes
distinct_waste_codes
Optional
Sorted, de-duplicated federal RCRA waste codes ([DFKPU] plus three digits) from the waste streams this facility GENERATED. v1.1 fix: v1.0 also mined waste_code_group, which holds EPA group LABELS, and so fabricated codes such as TCMT, DMIX, UMIX, PMIX, LABP, TCOR and ONLY on 37.5% of Delaware handlers. Codes on waste RECEIVED from other companies now sit in received_waste_codes.
[ "D001", "D002", "F003"]Generator status
generator_status
Optional
Facility's most severe RCRA generator status across its streams (LQG/SQG/VSQG/etc.), mapped from the calculated generator status code.
Dominant management method
dominant_management_category
Optional
Most frequent EPA management CATEGORY across the facility lines. EPA leaves this blank on 53.6% of Delaware rows (every H141 line), so prefer top_management_method_code / management_method_breakdown.
LQG flag
large_quantity_generator_flag
Optional
True when EPA calculated generator status is LQG. NULL (not false) when EPA reported no status and generation is below the 13.2 short-ton/yr fallback line - see lqg_flag_basis.
Generation rank
generation_rank
Optional
Rank within the returned set by ranking_tons (1 = largest). See ranking_tons_basis for which measure was used.
Source URL
source_url
Optional
EPA Envirofacts efservice URL for the state+cycle this record came from.
Checked at
checked_at
Optional
ISO 8601 timestamp of the run.
Disclaimer
disclaimer
Optional
Standing note that Biennial Report tonnages are self-reported by the handler, aggregated across every waste-stream line, subject to correction, and not an official EPA determination.
Street address
street_address
Optional
Facility street address, assembled from the BR location_street_no / street1 / street2 columns. Fetched by every run since v1.0 but never emitted until v1.1.
County code
county_code
Optional
EPA county code (state prefix + 3-digit FIPS), e.g. DE003.
EPA region
epa_region
Optional
EPA region number (1-10) of the facility.
Last change date
last_change_date
Optional
Most recent RCRAInfo last_change date across the facility BR lines (YYYY-MM-DD). Data vintage for this record.
Generated waste streams
n_generated_waste_streams
Optional
Number of br_form=GM lines: waste streams the facility ITSELF generated.
Received waste streams
n_received_waste_streams
Optional
Number of br_form=WR lines: shipments of waste the facility RECEIVED from other companies (TSDF activity). 72% of Texas BR rows are WR.
No-activity lines
n_no_activity_lines
Optional
Number of br_form=XX lines: the facility filed the Biennial Report but reported no hazardous-waste activity.
Filed with no activity
filed_no_activity
Optional
True when EVERY line this facility filed was a no-activity (XX) line.
Receiving facility (TSDF)
is_receiving_facility
Optional
True when the facility filed at least one Waste Received line, i.e. it accepts hazardous waste from other generators.
Total received (tons)
total_received_tons
Optional
Tons of hazardous waste RECEIVED from other companies. Summed by v1.0 and then discarded; emitted from v1.1.
Managed (own generation, tons)
managed_tons_own_generation
Optional
On-site managed tons attributable to the facility OWN generated waste (GM lines). Null when the facility filed no GM lines.
Managed (received waste, tons)
managed_tons_from_received
Optional
On-site managed tons attributable to waste RECEIVED from other companies (WR lines). Null when the facility received nothing.
Received waste codes
received_waste_codes
Optional
Federal RCRA waste codes on waste the facility received from others. Kept out of distinct_waste_codes so another company waste is never attributed to this generator.
EPA waste-code groups
waste_code_groups
Optional
Raw EPA waste-code GROUP labels reported on the generated streams (DMIX, TCMT, LABP, ICR, F1_5 ...). These are classifications, NOT waste codes.
Listed waste codes
listed_waste_codes
Optional
Generated codes that are LISTED hazardous wastes: F (40 CFR 261.31), K (261.32), P (261.33(e)), U (261.33(f)).
Characteristic waste codes
characteristic_waste_codes
Optional
Generated D-codes: characteristic hazardous wastes (ignitability, corrosivity, reactivity, toxicity - 40 CFR 261.20-261.24).
Acute hazardous waste codes
acute_waste_codes
Optional
Generated P-codes: acutely hazardous commercial chemical products (40 CFR 261.33(e)), which carry the 1 kg/month LQG threshold.
Has listed waste
has_listed_waste
Optional
True/false when the facility filed federal codes; NULL when it filed none (not checked is not the same as none).
Has characteristic waste
has_characteristic_waste
Optional
True/false when the facility filed federal codes; NULL when it filed none.
Has acute hazardous waste
has_acute_hazardous_waste
Optional
True when any generated code is a P-code; NULL when the facility filed no federal codes.
Distinct waste code count
n_distinct_waste_codes
Optional
Count of distinct validated federal RCRA waste codes on generated streams.
Management method codes
management_method_codes
Optional
Sorted EPA management-method H-codes (H040, H061, H134, H141 ...) across the facility lines.
Top management method
top_management_method_code
Optional
H-code accounting for the most tons.
Top management method category
top_management_method_category
Optional
EPA plain-English category for the top H-code. NULL where EPA itself publishes no category (H141, H042) - no label is invented.
Top management method tons
top_management_method_tons
Optional
Tons handled under the top management method.
Off-site receiver EPA IDs
offsite_receiver_ids
Optional
EPA handler IDs of the TSDFs this generator shipped to.
Off-site receiver count
n_offsite_receivers
Optional
Number of distinct off-site receiving facilities used.
Primary receiver
primary_receiver_id
Optional
EPA ID of the receiving facility taking the most shipped tons.
Receiver states
receiver_states
Optional
States of the receiving facilities used.
Wastewater tons
wastewater_tons
Optional
Generated tons on lines EPA flags as wastewater. Null when the facility filed no generation lines.
Non-wastewater tons
nonwastewater_tons
Optional
Generated tons on lines EPA flags as non-wastewater. Null when the facility filed no generation lines.
Mixed radioactive waste
mixed_radioactive_waste_flag
Optional
True when any line reports mixed (hazardous + radioactive) waste. NULL when EPA reported nothing.
Acute waste reported
acute_waste_reported_flag
Optional
True when any line carries EPA acute_nonacute_status = A. NULL when EPA reported nothing.
Priority chemical
priority_chemical_flag
Optional
True when any line is flagged as containing an EPA priority chemical. NULL when EPA reported nothing.
State-only waste
state_only_waste_flag
Optional
True when any line is flagged federal_waste = N, i.e. hazardous under state law only. NULL when EPA reported nothing.
Waste minimization codes
waste_minimization_codes
Optional
EPA waste-minimization effort codes reported on the facility lines.
Source codes
source_codes
Optional
EPA waste-origin source codes (G01-G61) reported by the facility.
Form codes
form_codes
Optional
EPA physical/chemical waste form codes (W001, W203 ...) reported by the facility.
Generator status code
generator_status_code
Optional
Raw EPA calculated_generator_status letter behind generator_status (L/S/V/C/E/N).
All generator status codes
generator_status_codes
Optional
Every distinct status letter across the facility lines, so a mixed filing is visible.
LQG flag basis
lqg_flag_basis
Optional
How large_quantity_generator_flag was decided: epa_status (EPA answered), tonnage_heuristic (>= 13.2 short tons/yr with no EPA status), or unknown (flag is null).
Management method breakdown
management_method_breakdown
Optional
Per EPA management-method H-code: the code, EPA plain-English category (null where EPA publishes none), number of BR lines, and tons. Sorted by tons descending.
BR fetch status
br_status
Optional
Per-source outcome for the EPA Envirofacts fetch behind this row: ok, or ok_unverified_count when the efservice COUNT probe itself was unavailable so row completeness could not be proven.
Rows declared upstream
state_rows_expected
Optional
Row count efservice COUNT/JSON declared for this state and cycle. The run fails if the page loop does not retrieve exactly this many.
Rows retrieved
state_rows_retrieved
Optional
Row count actually retrieved by the page loop. Equal to state_rows_expected on every emitted row.
Prior-cycle status
prior_cycle_status
Optional
ok, unavailable (fetch failed - every prior-cycle field is null, never 0), or not_requested.
Latest cycle detected
latest_cycle_detected
Optional
Newest Biennial Report cycle EPA had data for at run time, probed live.
Newer cycle available
newer_cycle_available
Optional
True when EPA has published a cycle newer than the one requested, so a stale cycle is never served as current.
Handlers in state
state_handler_count
Optional
Total distinct handlers in the state for this cycle, counted BEFORE naicsPrefix / minTons filtering.
State total generation (tons)
state_generation_tons_total
Optional
Total hazardous-waste tons generated statewide for this cycle, counted BEFORE filtering.
Prior cycle
prior_cycle
Optional
The comparison cycle (the Biennial Report is biennial, so 2023 compares to 2021). Null when the comparison was not requested.
Prior-cycle generation (tons)
prior_cycle_generation_tons
Optional
Total generation in the prior cycle. NULL when the facility did not file then, or when the prior-cycle fetch failed - never 0.
Prior-cycle generator status
prior_cycle_generator_status
Optional
Generator status in the prior cycle.
New generator this cycle
new_generator_this_cycle
Optional
True when the facility filed this cycle but not the prior one. NULL when the prior cycle was unavailable or not requested.
Generation delta (tons)
generation_tons_delta
Optional
Current minus prior-cycle generation tons. NULL unless both cycles are known.
Generation change (%)
generation_pct_change
Optional
Percent change in generation versus the prior cycle. NULL unless both cycles are known and the prior value is above zero.
Generator status changed
generator_status_changed
Optional
True when the RCRA generator status differs from the prior cycle (e.g. SQG to LQG). NULL when the prior cycle is unknown.
Generation tonnage reported
generation_tons_reported
Optional
True when EPA published generation_tons for this facility. EPA publishes NO generation_tons or managed_tons for the entire 2021 cycle nationwide (verified live on DE, TX and CA), so this is false on every 2021 row.
Ranking tons
ranking_tons
Optional
The tonnage used for ranking, minTons filtering and share-of-state: generation tons when EPA reports them, otherwise shipped tons. Null only when neither was reported.
Ranking tons basis
ranking_tons_basis
Optional
Which measure ranking_tons came from: generation_tons, shipped_tons (the 2021-cycle fallback), or none.
State total ranking tons
state_ranking_tons_total
Optional
Statewide sum of ranking_tons for the cycle, computed before your filters.
Prior-cycle shipped (tons)
prior_cycle_shipped_tons
Optional
Tons shipped off-site in the prior cycle. shipped_tons is populated in EVERY cycle, so this is the only apples-to-apples trend that spans the 2021 generation-tonnage gap.
Shipped delta (tons)
shipped_tons_delta
Optional
Current minus prior-cycle shipped tons. Null unless both cycles reported a shipped tonnage.
Shipped change (%)
shipped_tons_pct_change
Optional
Percent change in shipped tons versus the prior cycle. Null unless both cycles are known and the prior value is above zero.