![[logo] US EPA](http://www.epa.gov/epafiles/images/logo_epaseal.gif){kind=logo}
Table Name: TRI_FACILITY_HISTORY
Description: Historical representation of facility identification data. (Data in TRI_FACILITY_HISTORY were submitted on EPA Form R or Form A, Part I, Section 4, 'Facility Identification'. See specific 'Data Source' for each column.)
Relationships:
- Must have SIC data historically represented by one or more TRI_FACILITY_SIC_HISTORY related by column TRI_FACILITY_ID.
- Must have Dun & Bradstreet data historically represented by one or more TRI_FACILITY_DB_HISTORY related by column TRI_FACILITY_ID.
- May have NPDES data historically represented by one or more TRI_FACILITY_NPDES_HISTORY related by column TRI_FACILITY_ID.
- May have RCRA data historically represented by one or more TRI_FACILITY_RCRA_HISTORY related by column TRI_FACILITY_ID.
- May have UIC data historically represented by one or more TRI_FACILITY_UIC_HISTORY related by column TRI_FACILITY_ID.
- May historically represent one or more TRI_FACILITY related by column TRI_FACILITY_ID.
- ASGN_AGENCY
- ASGN_FEDERAL_IND
- ASGN_PARTIAL_IND
- ASGN_PUBLIC_CONTACT
- ASGN_PUBLIC_PHONE
- CITY_NAME
- COUNTY_NAME
- FACILITY_NAME
- FAC_LATITUDE
- FAC_LONGITUDE
- MAIL_CITY
- MAIL_COUNTRY
- MAIL_NAME
- MAIL_PROVINCE
- MAIL_STATE_ABBR
- MAIL_STREET_ADDRESS
- MAIL_ZIP_CODE
- PARENT_CO_DB_NUM
- PARENT_CO_NAME
- PREF_ACCURACY
- PREF_COLLECT_METH
- PREF_DESC_CATEGORY
- PREF_HORIZONTAL_DATUM
- PREF_LATITUDE
- PREF_LONGITUDE
- PREF_QA_CODE
- PREF_SOURCE_SCALE
- REGION
- REPORTING_YEAR
- STATE_ABBR
- STATE_COUNTY_FIPS_CODE
- STREET_ADDRESS
- TRI_FACILITY_ID
- ZIP_CODE
Return To: