U.S. Food & Beverage Wastewater Facilities
EPA food and beverage manufacturing facilities with wastewater permits, inspections, enforcement records and FY2025 discharge monitoring.
- Primary rows
- 2,816
- Primary fields
- 15
- Coverage
- US
- Source snapshot
- Oct 3, 2026
Each primary row: One EPA facility record with a reported food manufacturing or beverage manufacturing industry code.
Sample data
Download sample100 sample rows as CSV · all 15 primary fields.
[] / {} Empty collection0 / false Recorded valuesDownload field definitions (CSV)
Download sample documentation (ZIP)Included data
- The facility selection uses reported NAICS 311 or 3121 codes, with source permit and registry identifiers for joins.
- Eighteen tables include permit details, inspections, enforcement, effluent violations from monitoring periods beginning in 2020, and FY2025 monitoring results.
- Reported values retain their units, qualifiers and no-data codes; exact FRS identifiers link the registry reference table.
What’s in the package
- sites.csv2,816 rows · 15 fields
- permits.csv7,479 rows · 29 fields
One selected row in ICIS_PERMITS.csv; source ordinal is local to that table.
- naics.csv3,223 rows · 5 fields
One selected row in NPDES_NAICS.csv; source ordinal is local to that table.
- sics.csv3,280 rows · 5 fields
One selected row in NPDES_SICS.csv; source ordinal is local to that table.
- inspections.csv17,804 rows · 12 fields
One selected row in NPDES_INSPECTIONS.csv; source ordinal is local to that table.
- ps_violations.csv3,912 rows · 18 fields
One selected row in NPDES_PS_VIOLATIONS.csv; source ordinal is local to that table.
- cs_violations.csv479 rows · 19 fields
One selected row in NPDES_CS_VIOLATIONS.csv; source ordinal is local to that table.
- se_violations.csv3,184 rows · 15 fields
One selected row in NPDES_SE_VIOLATIONS.csv; source ordinal is local to that table.
- formal_enforcement_actions.csv994 rows · 11 fields
One selected row in NPDES_FORMAL_ENFORCEMENT_ACTIONS.csv; source ordinal is local to that table.
- informal_enforcement_actions.csv9,920 rows · 12 fields
One selected row in NPDES_INFORMAL_ENFORCEMENT_ACTIONS.csv; source ordinal is local to that table.
- qncr_history.csv53,439 rows · 9 fields
One selected row in NPDES_QNCR_HISTORY.csv; source ordinal is local to that table.
- perm_components.csv1,386 rows · 4 fields
One selected row in NPDES_PERM_COMPONENTS.csv; source ordinal is local to that table.
- perm_feature_coords.csv4,876 rows · 6 fields
One selected row in NPDES_PERM_FEATURE_COORDS.csv; source ordinal is local to that table.
- data_groups.csv9,896 rows · 8 fields
One selected row in NPDES_DATA_GROUPS.csv; source ordinal is local to that table.
- effluent_violations.csv66,861 rows · 44 fields
One selected row in NPDES_EFF_VIOLATIONS.csv; source ordinal is local to that table.
- monitoring_fy2025.csv198,476 rows · 58 fields
One selected row in NPDES_DMRS_FY2025.csv; source ordinal is local to that table.
- violation_enforcements.csv9,802 rows · 8 fields
One selected row in NPDES_VIOLATION_ENFORCEMENTS.csv; source ordinal is local to that table.
- registry_sites.csv2,471 rows · 11 fields
One selected row in FRS_FACILITIES.csv; source ordinal is local to that table.
Companion table fields
permits.csv29 fields
| Field | Definition & format |
|---|---|
Source record ID source_record_id | One-based source member row ordinal; repeated source evidence remains distinct.
|
Activity ID activity_id | The unique identifier for an activity performed at or related to a particular site. It can be used to uniquely identify a version of a permit in ICIS.
|
External permit number external_permit_nmbr | The unique identifier for a permit.
|
Version number version_nmbr | Permit version: EPA identifies 0 as current and 1 as previous.
|
Facility type indicator facility_type_indicator | Category identifying a publicly owned treatment works (POTW), non-POTW or federal facility.
|
Permit type code permit_type_code | Permit category code defined in the EPA ICIS-NPDES dictionary.
|
Major minor status flag major_minor_status_flag | A 1-character code that designates the facility as a major discharger (M), non-major discharger (N), or that no data is available (null value), such as for unpermitted facilities.
|
Permit status code permit_status_code | ICIS-NPDES designates a permit as Effective (EFF), Administratively Continued (ADC), Expired (EXP), Not Needed (NON), Pending (PND), Retired (RET), or Terminated (TRM). Active facilities are those currently in operation (indicated by any status code except NON, PND, RET, or TRM).
|
Total design flow total_design_flow_nmbr | Design capacity of the permitted discharge flow, in millions of gallons per day.
|
Actual average flow at application actual_average_flow_nmbr | Actual average discharge flow at permit application, in millions of gallons per day; not a current measured flow.
|
State water body state_water_body | The state’s code to identify the water body into which the effluent is discharged for a Permitted Feature.
|
State water body name state_water_body_name | The state’s name for the water body into which the effluent is discharged for a Permitted Feature.
|
Permit name permit_name | Name of the facility holding the NPDES discharge permit.
|
Agency type code agency_type_code | A three character code indicating the type of organization issuing or granting a permit.
|
Original issue date original_issue_date | Date the permit was originally issued.
|
Issue date issue_date | The date the permit was issued (MM/DD/YYYY).
|
Issuing agency issuing_agency | This is the name of the organization issuing or granting a permit.
|
Effective date effective_date | The date the permit became effective or is scheduled to become effective (MM/DD/YYYY).
|
Expiration date expiration_date | The date the permit expired or is scheduled to expire (MM/DD/YYYY).
|
Retirement date retirement_date | The date the permit was retired (YYYYMMDD).
|
Termination date termination_date | The date the permit was terminated (MM/DD/YYYY).
|
Permit comp status flag permit_comp_status_flag | Whether permit compliance tracking is enabled: Y means yes; EPA defines a null as no.
|
DMR non receipt flag dmr_non_receipt_flag | Whether the permit is subject to the DMR non-receipt process: Y means yes; EPA defines a null as no.
|
RNC tracking flag rnc_tracking_flag | Whether reportable-noncompliance tracking is enabled: Y means yes; EPA defines a null as no.
|
Master external permit number master_external_permit_nmbr | This is the unique identifier for the Master General Permit for a General Permit Covered Facility.
|
Tmdl interface flag tmdl_interface_flag | This field indicates whether a Permit has received TMDL information.
|
Edmr authorization flag edmr_authorization_flag | This indicates whether DMRs for the Permit may be submitted electronically.
|
Pretreatment indicator code pretreatment_indicator_code | A 1-character code which indicates if the permitted municipality is required to develop a pretreatment program.
|
Outfall watershed codes and names rad_wbd_huc12s | Hydrologic unit codes and names linked to the permit’s outfalls through EPA’s Reach Address Database; multiple watersheds can appear.
|
naics.csv5 fields
| Field | Definition & format |
|---|---|
Source record ID source_record_id | One-based source member row ordinal; repeated source evidence remains distinct.
|
NPDES ID npdes_id | NPDES permit or covered-facility identifier; appears as external_permit_nmbr in some tables.
|
NAICS code naics_code | North American Industry Classification System code reported for the permit.
|
NAICS description naics_desc | Description of the reported NAICS code.
|
Primary indicator flag primary_indicator_flag | Flag identifying the primary NAICS or SIC classification.
|
sics.csv5 fields
| Field | Definition & format |
|---|---|
Source record ID source_record_id | One-based source member row ordinal; repeated source evidence remains distinct.
|
NPDES ID npdes_id | NPDES permit or covered-facility identifier; appears as external_permit_nmbr in some tables.
|
SIC code sic_code | Standard Industrial Classification code reported for the permit.
|
SIC description sic_desc | Description of the reported SIC code.
|
Primary indicator flag primary_indicator_flag | Flag identifying the primary NAICS or SIC classification.
|
inspections.csv12 fields
| Field | Definition & format |
|---|---|
Source record ID source_record_id | One-based source member row ordinal; repeated source evidence remains distinct.
|
Registry ID registry_id | Facility Registry Service identifier; links program records to registry_sites.csv.
|
NPDES ID npdes_id | NPDES permit or covered-facility identifier; appears as external_permit_nmbr in some tables.
|
Activity ID activity_id | The unique identifier for an activity performed at or related to a particular site. It can be used to uniquely identify a version of a permit in ICIS.
|
Activity type code activity_type_code | ICIS classification code for the inspection or enforcement activity.
|
Comp monitor type code comp_monitor_type_code | Contains a code describing the type of inspection that was conducted.
|
Comp monitor type description comp_monitor_type_desc | Full text description of COMP_MONITOR_TYPE_CODE.
|
State EPA flag state_epa_flag | Identifies the agency lead (S = State, E = EPA) for the listed inspection.
|
Actual begin date actual_begin_date | Date the inspection activity began.
|
Actual end date actual_end_date | Identifies the calendar date of the listed inspection (MM/DD/YYYY).
|
Activity outcome code activity_outcome_code | Code for the outcome of the inspection activity.
|
Activity outcome description activity_outcome_desc | Description of the inspection outcome code.
|
ps_violations.csv18 fields
| Field | Definition & format |
|---|---|
Source record ID source_record_id | One-based source member row ordinal; repeated source evidence remains distinct.
|
NPDES ID npdes_id | NPDES permit or covered-facility identifier; appears as external_permit_nmbr in some tables.
|
NPDES violation ID npdes_violation_id | The system-generated unique identifier for the NPDES Violation.
|
Perm schedule event ID perm_schedule_event_id | The unique identifier of the Permit Schedule Event to which the Violation is associated; it is only used for Schedule Violations of a Permit.
|
Violation type code violation_type_code | Derived category identifying the type of violation record.
|
Violation code violation_code | The code identifying which type of violation has occurred (D80 = Required Monitoring DMR Value Non-Receipt, D90 = Limited Value Overdue Non-Receipt, E90 = Effluent Violation).
|
Violation description violation_desc | Text description of the VIOLATION_CODE.
|
Schedule event code schedule_event_code | The code indicating the particular event with which the permittee is scheduled to comply.
|
Schedule event description schedule_event_desc | Text description of the code value for SCHEDULE_EVENT_CODE.
|
Schedule date schedule_date | Due date for the permit or compliance schedule event.
|
RNC detection code rnc_detection_code | Reportable-noncompliance detection code; paired descriptions appear in violation tables.
|
RNC detection description rnc_detection_desc | Text description of the code value RNC_DETECTION_CODE.
|
RNC detection date rnc_detection_date | The date that RNC was detected. It can be detected automatically or entered manually. In cases in which RNC is detected by ICIS-NPDES, the detection date will vary according to the type of violation detected.
|
RNC resolution code rnc_resolution_code | Reportable-noncompliance resolution code; paired descriptions appear in violation tables.
|
RNC resolution description rnc_resolution_desc | Text description of the code value RNC_RESOLUTION_CODE.
|
RNC resolution date rnc_resolution_date | The date RNC was marked to its current resolution status. It can be entered manually or automatically.
|
Actual date actual_date | The date on which the activity/milestone was conducted or achieved. Date format is MM/DD/YYYY.
|
Report received date report_received_date | The date on which the regulatory authority receives a report indicating a scheduled event was completed or the date on which the regulatory authority received the required report (MM/DD/YYYY).
|
cs_violations.csv19 fields
| Field | Definition & format |
|---|---|
Source record ID source_record_id | One-based source member row ordinal; repeated source evidence remains distinct.
|
NPDES ID npdes_id | NPDES permit or covered-facility identifier; appears as external_permit_nmbr in some tables.
|
NPDES violation ID npdes_violation_id | The system-generated unique identifier for the NPDES Violation.
|
Violation type code violation_type_code | Derived category identifying the type of violation record.
|
Comp schedule event ID comp_schedule_event_id | (Compliance Schedule Event ID) The unique identifier of the Compliance Schedule Event to which the Violation is associated; it is only used for Schedule Violations of a Final Order.
|
Comp schedule number comp_schedule_nmbr | A 2-digit number which in combination with the Schedule Type and NPDES ID uniquely identifies a Compliance Schedule.
|
Violation code violation_code | The code identifying which type of violation has occurred (D80 = Required Monitoring DMR Value Non-Receipt, D90 = Limited Value Overdue Non-Receipt, E90 = Effluent Violation).
|
Violation description violation_desc | Text description of the VIOLATION_CODE.
|
Schedule event code schedule_event_code | The code indicating the particular event with which the permittee is scheduled to comply.
|
Schedule event description schedule_event_desc | Text description of the code value for SCHEDULE_EVENT_CODE.
|
Schedule date schedule_date | Due date for the permit or compliance schedule event.
|
Actual date actual_date | The date on which the activity/milestone was conducted or achieved. Date format is MM/DD/YYYY.
|
RNC detection code rnc_detection_code | Reportable-noncompliance detection code; paired descriptions appear in violation tables.
|
RNC detection description rnc_detection_desc | Text description of the code value RNC_DETECTION_CODE.
|
RNC detection date rnc_detection_date | The date that RNC was detected. It can be detected automatically or entered manually. In cases in which RNC is detected by ICIS-NPDES, the detection date will vary according to the type of violation detected.
|
RNC resolution code rnc_resolution_code | Reportable-noncompliance resolution code; paired descriptions appear in violation tables.
|
RNC resolution description rnc_resolution_desc | Text description of the code value RNC_RESOLUTION_CODE.
|
RNC resolution date rnc_resolution_date | The date RNC was marked to its current resolution status. It can be entered manually or automatically.
|
Report received date report_received_date | The date on which the regulatory authority receives a report indicating a scheduled event was completed or the date on which the regulatory authority received the required report (MM/DD/YYYY).
|
se_violations.csv15 fields
| Field | Definition & format |
|---|---|
Source record ID source_record_id | One-based source member row ordinal; repeated source evidence remains distinct.
|
NPDES ID npdes_id | NPDES permit or covered-facility identifier; appears as external_permit_nmbr in some tables.
|
NPDES violation ID npdes_violation_id | The system-generated unique identifier for the NPDES Violation.
|
Violation type code violation_type_code | Derived category identifying the type of violation record.
|
Violation code violation_code | The code identifying which type of violation has occurred (D80 = Required Monitoring DMR Value Non-Receipt, D90 = Limited Value Overdue Non-Receipt, E90 = Effluent Violation).
|
Violation description violation_desc | Text description of the VIOLATION_CODE.
|
Single event violation date single_event_violation_date | The date of a single event violation (MM/DD/YYYY).
|
Single event end date single_event_end_date | If the Single Event Violation occurred over multiple days, the date the occurrence ended.
|
Single event agency type code single_event_agency_type_code | Code identifying the organization reporting the single-event violation.
|
RNC detection code rnc_detection_code | Reportable-noncompliance detection code; paired descriptions appear in violation tables.
|
RNC detection description rnc_detection_desc | Text description of the code value RNC_DETECTION_CODE.
|
RNC detection date rnc_detection_date | The date that RNC was detected. It can be detected automatically or entered manually. In cases in which RNC is detected by ICIS-NPDES, the detection date will vary according to the type of violation detected.
|
RNC resolution code rnc_resolution_code | Reportable-noncompliance resolution code; paired descriptions appear in violation tables.
|
RNC resolution description rnc_resolution_desc | Text description of the code value RNC_RESOLUTION_CODE.
|
RNC resolution date rnc_resolution_date | The date RNC was marked to its current resolution status. It can be entered manually or automatically.
|
formal_enforcement_actions.csv11 fields
| Field | Definition & format |
|---|---|
Source record ID source_record_id | One-based source member row ordinal; repeated source evidence remains distinct.
|
NPDES ID npdes_id | NPDES permit or covered-facility identifier; appears as external_permit_nmbr in some tables.
|
Enf identifier enf_identifier | The unique identifying number of the Enforcement Action as referred to by the Court where the action was filed; the Enforcement Action Identifier. This element is commonly referred to as the case number.
|
Activity ID activity_id | The unique identifier for an activity performed at or related to a particular site. It can be used to uniquely identify a version of a permit in ICIS.
|
Activity type code activity_type_code | ICIS classification code for the inspection or enforcement activity.
|
Enf type code enf_type_code | A code describing which enforcement action was taken in response to a violation.
|
Enf type description enf_type_desc | A text description of the ENF_TYPE_CODE value.
|
Agency agency | Identifies the agency lead (S = State, E = EPA) for the listed enforcement action.
|
Settlement entered date settlement_entered_date | The date of the enforcement action (MM/DD/YYYY). Where multiple settlements are associated with a single enforcement action, this represents the earliest date entered.
|
Fed penalty assessed amt fed_penalty_assessed_amt | The dollar amount of federal civil penalties assessed or agreed to at a formal enforcement action. Where the enforcement case results in multiple settlements, this represents the sum of penalty amounts for all of the settlements.
|
State local penalty amt state_local_penalty_amt | The dollar amount of state or local civil penalties assessed or agreed to at a formal enforcement action. Where the enforcement case results in multiple settlements, this represents the sum of penalty amounts for all of the settlements.
|
informal_enforcement_actions.csv12 fields
| Field | Definition & format |
|---|---|
Source record ID source_record_id | One-based source member row ordinal; repeated source evidence remains distinct.
|
NPDES ID npdes_id | NPDES permit or covered-facility identifier; appears as external_permit_nmbr in some tables.
|
Registry ID registry_id | Facility Registry Service identifier; links program records to registry_sites.csv.
|
Agency agency | Identifies the agency lead (S = State, E = EPA) for the listed enforcement action.
|
Activity ID activity_id | The unique identifier for an activity performed at or related to a particular site. It can be used to uniquely identify a version of a permit in ICIS.
|
Activity type code activity_type_code | ICIS classification code for the inspection or enforcement activity.
|
Activity type description activity_type_desc | Description of the ICIS activity classification.
|
Enf type code enf_type_code | A code describing which enforcement action was taken in response to a violation.
|
Enf type description enf_type_desc | A text description of the ENF_TYPE_CODE value.
|
Achieved date achieved_date | The date on which an Informal Enforcement Action is achieved. For an informal action based on only oral notification, it is the date the regulated entity actually received such notification.
|
Enf identifier enf_identifier | The unique identifying number of the Enforcement Action as referred to by the Court where the action was filed; the Enforcement Action Identifier. This element is commonly referred to as the case number.
|
Official flag official_flg | Reported flag identifying an official enforcement record.
|
qncr_history.csv9 fields
| Field | Definition & format |
|---|---|
Source record ID source_record_id | One-based source member row ordinal; repeated source evidence remains distinct.
|
NPDES ID npdes_id | NPDES permit or covered-facility identifier; appears as external_permit_nmbr in some tables.
|
Fiscal year and quarter yearqtr | Federal fiscal year and quarter for the historic noncompliance status, formatted YYYYQ (Q = 1–4).
|
Historic quarterly noncompliance status hlrnc | Historic quarterly noncompliance status reconciling automatic and manual QNCR values; applies to yearqtr.
|
Quarterly effluent violation count nume90q | Count of E90 effluent violations whose DMR monitoring-period end date falls in yearqtr.
|
Quarterly compliance-schedule violation count numcvdt | Count of compliance-schedule violations with a start or end date in yearqtr; unresolved events follow EPA’s ongoing-event rules.
|
Quarterly single-event violation count numsvcd | Count of single-event violations with a start or end date in yearqtr.
|
Quarterly permit-schedule violation count numpsch | Count of permit-schedule violations with a start or end date in yearqtr; unresolved events follow EPA’s ongoing-event rules.
|
Quarterly DMR reporting violation count numd8090q | Count of D80/D90 DMR reporting violations whose DMR due date falls in yearqtr.
|
perm_components.csv4 fields
| Field | Definition & format |
|---|---|
Source record ID source_record_id | One-based source member row ordinal; repeated source evidence remains distinct.
|
External permit number external_permit_nmbr | The unique identifier for a permit.
|
Component type code component_type_code | Code identifying a permit program component.
|
Component type description component_type_desc | Description of the permit program component.
|
perm_feature_coords.csv6 fields
| Field | Definition & format |
|---|---|
Source record ID source_record_id | One-based source member row ordinal; repeated source evidence remains distinct.
|
External permit number external_permit_nmbr | The unique identifier for a permit.
|
Perm feature number perm_feature_nmbr | The identifier assigned for each location at which permit conditions are being applied.
|
Perm feature ID perm_feature_id | The unique system identifier of a permitted feature.
|
Latitude measure latitude_measure | Latitude of the permitted feature or FRS facility, according to the table.
|
Longitude measure longitude_measure | Longitude of the permitted feature or FRS facility, according to the table.
|
data_groups.csv8 fields
| Field | Definition & format |
|---|---|
Source record ID source_record_id | One-based source member row ordinal; repeated source evidence remains distinct.
|
Activity ID activity_id | The unique identifier for an activity performed at or related to a particular site. It can be used to uniquely identify a version of a permit in ICIS.
|
External permit number external_permit_nmbr | The unique identifier for a permit.
|
Version number version_nmbr | Permit version: EPA identifies 0 as current and 1 as previous.
|
NPDES data group code npdes_data_group_code | Code identifying an NPDES data group for the permit version.
|
NPDES data group description npdes_data_group_desc | Description of the NPDES data-group code.
|
Created date created_date | Date the data-group record was created.
|
Updated date updated_date | Date the data-group record was updated.
|
effluent_violations.csv44 fields
| Field | Definition & format |
|---|---|
Source record ID source_record_id | One-based source member row ordinal; repeated source evidence remains distinct.
|
NPDES ID npdes_id | NPDES permit or covered-facility identifier; appears as external_permit_nmbr in some tables.
|
Version number version_nmbr | Permit version: EPA identifies 0 as current and 1 as previous.
|
Activity ID activity_id | The unique identifier for an activity performed at or related to a particular site. It can be used to uniquely identify a version of a permit in ICIS.
|
NPDES violation ID npdes_violation_id | The system-generated unique identifier for the NPDES Violation.
|
Perm feature number perm_feature_nmbr | The identifier assigned for each location at which permit conditions are being applied.
|
Permit activity ID permit_activity_id | ICIS activity identifier of the associated permit.
|
Limit set designator limit_set_designator | The alphanumeric field that is used to designate a particular grouping of parameters within a limit set.
|
Monitoring location code monitoring_location_code | Location category where the monitoring requirement or limit applies; several locations can share a permitted feature.
|
DMR form value ID dmr_form_value_id | The sequence ID identifying the DMR Form Value.
|
DMR value number dmr_value_nmbr | Measurement reported on the DMR form; read with its reported-unit and qualifier fields.
|
DMR value ID dmr_value_id | The system-generated unique identifier for the DMR value.
|
DMR parameter ID dmr_parameter_id | ICIS identifier of the DMR parameter to which the value belongs.
|
Nodi code nodi_code | Reason an expected DMR measurement was not submitted. For example, B is below detection/no detection and C is no discharge; neither is a numeric zero.
|
Adjusted DMR value number adjusted_dmr_value_nmbr | DMR value adjusted for an effluent trade with a limit-parameter trading partner.
|
Limit value standard units limit_value_standard_units | Limit converted by ICIS to standard_unit_desc; a blank can indicate report-only monitoring.
|
Violation type code violation_type_code | Derived category identifying the type of violation record.
|
Violation type description violation_type_desc | Text description of the code value VIOLATION_TYPE_CODE.
|
Violation code violation_code | The code identifying which type of violation has occurred (D80 = Required Monitoring DMR Value Non-Receipt, D90 = Limited Value Overdue Non-Receipt, E90 = Effluent Violation).
|
Violation description violation_desc | Text description of the VIOLATION_CODE.
|
Parameter code parameter_code | The unique code identifying the parameter being limited and/or monitored.
|
Parameter description parameter_desc | Name or description of the monitored parameter identified by parameter_code.
|
Standard unit code standard_unit_code | Code for the ICIS standard unit used by values ending in standard_units.
|
Standard unit description standard_unit_desc | Description of the ICIS standard unit used by values ending in standard_units.
|
Monitoring period end date monitoring_period_end_date | The date that the monitoring period for the values covered by this DMR form ends.
|
number of report nmbr_of_report | Length of the DMR monitoring period in months, such as 1 for monthly and 3 for quarterly.
|
Exceedence pct exceedence_pct | ICIS-calculated percentage by which the reported or adjusted DMR value exceeded the limit or stay value.
|
Value qualifier code value_qualifier_code | Reported DMR value qualifier, including inequality, estimated or too-numerous-to-count codes.
|
Unit code unit_code | Code for the unit of the reported DMR value; distinct from standard_unit_code.
|
Value received date value_received_date | The date the DMR value was received by the regulatory authority.
|
Days late days_late | Days between the DMR due date and value_received_date, calculated by ICIS.
|
Adjusted DMR standard units adjusted_dmr_standard_units | Effluent-trade-adjusted DMR value converted by ICIS to standard_unit_desc.
|
Limit ID limit_id | The unique identifier for a limit parameter record.
|
DMR value standard units dmr_value_standard_units | DMR measurement converted by ICIS to the units in standard_unit_code and standard_unit_desc.
|
Value type code value_type_code | Reported quantity or concentration column category for the DMR value.
|
RNC detection code rnc_detection_code | Reportable-noncompliance detection code; paired descriptions appear in violation tables.
|
RNC detection description rnc_detection_desc | Text description of the code value RNC_DETECTION_CODE.
|
RNC detection date rnc_detection_date | The date that RNC was detected. It can be detected automatically or entered manually. In cases in which RNC is detected by ICIS-NPDES, the detection date will vary according to the type of violation detected.
|
RNC resolution code rnc_resolution_code | Reportable-noncompliance resolution code; paired descriptions appear in violation tables.
|
RNC resolution description rnc_resolution_desc | Text description of the code value RNC_RESOLUTION_CODE.
|
RNC resolution date rnc_resolution_date | The date RNC was marked to its current resolution status. It can be entered manually or automatically.
|
Statistical base code statistical_base_code | Code for the statistic applied to limit and DMR values, such as 30-day average or daily maximum.
|
Statistical base monthly avg statistical_base_monthly_avg | The data element indicating whether the statistical base code is a monthly average (A), non-monthly average (N), or neither (null) for purposes of calculating RNC.
|
Statistical base short description statistical_base_short_desc | Short description of the statistical basis applied to the limit and DMR value.
|
monitoring_fy2025.csv58 fields
| Field | Definition & format |
|---|---|
Source record ID source_record_id | One-based source member row ordinal; repeated source evidence remains distinct.
|
Activity ID activity_id | The unique identifier for an activity performed at or related to a particular site. It can be used to uniquely identify a version of a permit in ICIS.
|
External permit number external_permit_nmbr | The unique identifier for a permit.
|
Version number version_nmbr | Permit version: EPA identifies 0 as current and 1 as previous.
|
Perm feature ID perm_feature_id | The unique system identifier of a permitted feature.
|
Perm feature number perm_feature_nmbr | The identifier assigned for each location at which permit conditions are being applied.
|
Perm feature type code perm_feature_type_code | The code indicating the type of permitted feature (e.g., External Outfall, Sum).
|
Limit set ID limit_set_id | The system-generated unique identifier for a limit set.
|
Limit set designator limit_set_designator | The alphanumeric field that is used to designate a particular grouping of parameters within a limit set.
|
Limit set schedule ID limit_set_schedule_id | The system-generated unique identifier of the Limit Set Schedule.
|
Limit ID limit_id | The unique identifier for a limit parameter record.
|
Limit begin date limit_begin_date | The date on which a limit starts being in effect for a particular parameter in a limit set.
|
Limit end date limit_end_date | The date on which a limit stops being in effect for a particular parameter in a limit set.
|
number of submission nmbr_of_submission | DMR submission interval in months; blank for unscheduled limit sets.
|
number of report nmbr_of_report | Length of the DMR monitoring period in months, such as 1 for monthly and 3 for quarterly.
|
Parameter code parameter_code | The unique code identifying the parameter being limited and/or monitored.
|
Parameter description parameter_desc | Name or description of the monitored parameter identified by parameter_code.
|
Monitoring location code monitoring_location_code | Location category where the monitoring requirement or limit applies; several locations can share a permitted feature.
|
Stay type code stay_type_code | Stay treatment: X suppresses effluent violations, Y suppresses DMR non-receipt violations, and Z applies stay_value_nmbr.
|
Limit value ID limit_value_id | The system-generated unique identifier for the Limit Value.
|
Limit value type code limit_value_type_code | Reported quantity or concentration column category for the permit limit.
|
Limit value number limit_value_nmbr | Permit or final-order limit in limit_unit_desc; a blank can indicate report-only monitoring.
|
Limit unit code limit_unit_code | Code for the unit of limit_value_nmbr.
|
Limit unit description limit_unit_desc | Unit description for limit_value_nmbr.
|
Standard unit code standard_unit_code | Code for the ICIS standard unit used by values ending in standard_units.
|
Standard unit description standard_unit_desc | Description of the ICIS standard unit used by values ending in standard_units.
|
Limit value standard units limit_value_standard_units | Limit converted by ICIS to standard_unit_desc; a blank can indicate report-only monitoring.
|
Statistical base code statistical_base_code | Code for the statistic applied to limit and DMR values, such as 30-day average or daily maximum.
|
Statistical base type code statistical_base_type_code | Statistical classification used for compliance comparison, such as minimum, average or maximum.
|
Limit value qualifier code limit_value_qualifier_code | Limit qualifier: <, <=, >, >=, =, E (estimated) or T (too numerous to count).
|
Optional monitoring flag optional_monitoring_flag | Whether monitoring is optional; ICIS suppresses effluent violation generation for optional columns.
|
Limit sample type code limit_sample_type_code | The sampling method required by the permit to be used to provide values on the DMR for the limit.
|
Limit freq of analysis code limit_freq_of_analysis_code | Required sampling frequency, generally XX/YY for number of samples/time period; retain as text to avoid spreadsheet date conversion.
|
Stay value number stay_value_nmbr | Temporary limit used during an applicable stay; read with stay_type_code and the limit-unit fields.
|
Limit type code limit_type_code | The unique code that indicates whether a limit is an enforceable limit (ENF) or alert limit (ALR). Alert limits do not receive effluent violations for exceedances of the limit. Alerts limits are also referred to as benchmark thresholds.
|
DMR event ID dmr_event_id | The unique ID identifying the DMR Event. A DMR Event is a DMR submission with a DMR period end date and DMR due date.
|
Monitoring period end date monitoring_period_end_date | The date that the monitoring period for the values covered by this DMR form ends.
|
DMR sample type code dmr_sample_type_code | The sampling method used to provide the values for the DMR parameter on the DMR form.
|
DMR freq of analysis code dmr_freq_of_analysis_code | The code identifying the frequency measure used for sampling the data; this is the Frequency of Analysis reported for a DMR parameter on the DMR form.
|
Reported excursion number reported_excursion_nmbr | Number of limit exceedances reported on the DMR form.
|
DMR form value ID dmr_form_value_id | The sequence ID identifying the DMR Form Value.
|
Value type code value_type_code | Reported quantity or concentration column category for the DMR value.
|
DMR value ID dmr_value_id | The system-generated unique identifier for the DMR value.
|
DMR value number dmr_value_nmbr | Measurement reported on the DMR form; read with its reported-unit and qualifier fields.
|
DMR unit code dmr_unit_code | Code for the unit of dmr_value_nmbr.
|
DMR unit description dmr_unit_desc | Unit description for dmr_value_nmbr.
|
DMR value standard units dmr_value_standard_units | DMR measurement converted by ICIS to the units in standard_unit_code and standard_unit_desc.
|
DMR value qualifier code dmr_value_qualifier_code | Reported measurement qualifier: <, <=, >, >=, =, E (estimated) or T (too numerous to count).
|
Value received date value_received_date | The date the DMR value was received by the regulatory authority.
|
Days late days_late | Days between the DMR due date and value_received_date, calculated by ICIS.
|
Nodi code nodi_code | Reason an expected DMR measurement was not submitted. For example, B is below detection/no detection and C is no discharge; neither is a numeric zero.
|
Exceedence pct exceedence_pct | ICIS-calculated percentage by which the reported or adjusted DMR value exceeded the limit or stay value.
|
NPDES violation ID npdes_violation_id | The system-generated unique identifier for the NPDES Violation.
|
Violation code violation_code | The code identifying which type of violation has occurred (D80 = Required Monitoring DMR Value Non-Receipt, D90 = Limited Value Overdue Non-Receipt, E90 = Effluent Violation).
|
RNC detection code rnc_detection_code | Reportable-noncompliance detection code; paired descriptions appear in violation tables.
|
RNC detection date rnc_detection_date | The date that RNC was detected. It can be detected automatically or entered manually. In cases in which RNC is detected by ICIS-NPDES, the detection date will vary according to the type of violation detected.
|
RNC resolution code rnc_resolution_code | Reportable-noncompliance resolution code; paired descriptions appear in violation tables.
|
RNC resolution date rnc_resolution_date | The date RNC was marked to its current resolution status. It can be entered manually or automatically.
|
violation_enforcements.csv8 fields
| Field | Definition & format |
|---|---|
Source record ID source_record_id | One-based source member row ordinal; repeated source evidence remains distinct.
|
NPDES violation ID npdes_violation_id | The system-generated unique identifier for the NPDES Violation.
|
Violation code violation_code | The code identifying which type of violation has occurred (D80 = Required Monitoring DMR Value Non-Receipt, D90 = Limited Value Overdue Non-Receipt, E90 = Effluent Violation).
|
Violation description violation_desc | Text description of the VIOLATION_CODE.
|
Activity ID activity_id | The unique identifier for an activity performed at or related to a particular site. It can be used to uniquely identify a version of a permit in ICIS.
|
Activity type code activity_type_code | ICIS classification code for the inspection or enforcement activity.
|
Activity type description activity_type_desc | Description of the ICIS activity classification.
|
Enf identifier enf_identifier | The unique identifying number of the Enforcement Action as referred to by the Court where the action was filed; the Enforcement Action Identifier. This element is commonly referred to as the case number.
|
registry_sites.csv11 fields
| Field | Definition & format |
|---|---|
Source record ID source_record_id | One-based source member row ordinal; repeated source evidence remains distinct.
|
FRS facility name fac_name | Facility name in the Facility Registry Service (FRS).
|
FRS facility street fac_street | FRS facility street address.
|
FRS facility city fac_city | FRS facility city.
|
FRS facility state fac_state | FRS facility state.
|
FRS facility ZIP code fac_zip | FRS facility ZIP code.
|
Registry ID registry_id | Facility Registry Service identifier; links program records to registry_sites.csv.
|
FRS facility county fac_county | FRS facility county.
|
FRS EPA region fac_epa_region | EPA region containing the FRS facility.
|
Latitude measure latitude_measure | Latitude of the permitted feature or FRS facility, according to the table.
|
Longitude measure longitude_measure | Longitude of the permitted feature or FRS facility, according to the table.
|
Field coverage
Data notes
Coverage counts use the full tables. They exclude blank cells and empty JSON collections; zero and false count as populated.
- This EPA reporting population is not a complete food-plant or company census. Historical records can include inactive permits.
- Missing monitoring does not mean compliance or zero discharge. Measurement strings must be read with their units and qualifiers.
- Tables have different record types and can multiply rows when joined. Registry identifiers do not establish shared ownership or a unique campus.
- Narrative violation comments and personal contacts are excluded; source corrections made after capture are absent.