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