FRS Download Summary and Data Element Dictionary
ECHO incorporates data from the Facility Registry Service (FRS) to link records representing data about the same facility across different programmatic database systems. On this page:
FRS Description
EPA's Facility Registry Service (FRS) is a centrally managed database that identifies facilities, sites, or places (program interest) subject to environmental regulations or of environmental interest. It assigns a unique identifier to each program interest, and provides a cross-reference (linkage) to data records about that interest which reside in many of EPA’s programmatic data management systems.
Using the FRS program interest linkage, records included in ECHO's FRS Facilities and Linkages file are those with a valid FRS ID and which are cross-referenced by ID number to data contained in ICIS-Air, ICIS FE&C, ICIS-NPDES, TRI, NEI, GHG (E-GGRT), RCRAInfo, SDWIS, RMP, CEDRI, CAMD, EIS, TSCA, or Superfund Enterprise Management System (SEMS).
Note that this is not a complete FRS download; users interested in such should refer to the FRS Data Resources.
FRS File Data Elements
The ZIP file contains the following download files:
- Facilities contains FRS Name and Address information along with "Registry_ID," the unique FRS Facility identifier.
- Program Links contains the linkages between program record (identified by Program Acronym and Program System Identifier) to the FRS Facility (identified by the Registry ID).
- NAICS and SIC contain the industrial classification codes for each facility in FRS.
Facilities (FRS_FACILITIES.csv)
Element Name | Data Type | Length | Long Name |
---|---|---|---|
FAC_NAME | Char | 200 | Facility name |
FAC_STREET | Char | 200 | Street address |
FAC_CITY | Char | 100 | City |
FAC_STATE | Char | 2 | State abbreviation |
FAC_ZIP | Char | 10 | Postal ZIP code |
REGISTRY_ID | Char | 36 | FRS Registry ID [Primary Key] |
FAC_COUNTY | Char | 100 | County name |
FAC_EPA_REGION | Char | 2 | EPA Region Code |
LATITUDE_MEASURE | Num | 22 | Latitude Coordinate |
LONGITUDE_MEASURE | Num | 22 | Longitude Coordinate |
Program Links (FRS_PROGRAM_LINKS.csv)
Element Name | Data Type | Length | Long Name |
---|---|---|---|
PGM_SYS_ACRNM | Char | 60 | Program System Acronym [Primary Key] |
PGM_SYS_ID | Char | 90 | Program System Identification Number [Primary Key] |
REGISTRY_ID | Char | 26 | FRS Registry ID |
PRIMARY_NAME | Char | 200 | Facility name in the program system |
LOCATION_ADDRESS | Char | 200 | Street address (physical location) |
SUPPLEMENTAL_LOCATION | Char | 200 | Supplemental address information |
CITY_NAME | Char | 100 | City Name |
COUNTY_NAME | Char | 100 | County Name |
FIPS_CODE | Char | 10 | Federal Information Processing Standard (FIPS) county code |
STATE_CODE | Char | 2 | State abbreviation |
STATE_NAME | Char | 100 | State name |
COUNTRY_NAME | Char | 100 | Country name |
POSTAL_CODE | Char | 10 | Postal ZIP code |
North American Industry Classification System (NAICS) (FRS_NAICS_CODES.csv)
Element Name | Data Type | Length | Long Name |
---|---|---|---|
PGM_SYS_ID | Char | 90 | Program System Identification Number [Primary Key] |
PGM_SYS_ACRNM | Char | 60 | Program System Acronym [Primary Key] |
NAICS_CODE | Char | 6 | Six-digit North American Industry Classification System (NAICS) Code |
REGISTRY_ID | Char | 36 | FRS Registry ID |
Standard Industrial Classification (SIC) (FRS_SIC_CODES.csv)
Element Name | Data Type | Length | Long Name |
---|---|---|---|
PGM_SYS_ID | Char | 90 | Program System Identification Number [Primary Key] |
PGM_SYS_ACRNM | Char | 60 | Program System Acronym [Primary Key] |
SIC_CODE | Char | 4 | Four-digit Standard Industrial Classification (SIC) Code |
REGISTRY_ID | Char | 36 | FRS Registry ID |