TOXICS RELEASE INVENTORY (TRI)
BASIC PLUS DATA FILES
DOCUMENTATION
FILE TYPE 5: ADDITIONAL INFORMATION ON DISPOSAL AND
OTHER RELEASES, SOURCE REDUCTION, AND RECYCLING
ACTIVITIES
Updated for RY 2017
July 2018

-------
jfll	United States
Environmental Protection
1 jg * Agency
OVERVIEW OF TRI BASIC PLUS DATA FILES
The TRI "Basic Plus" data files include nine file types that collectively contain all the data fields from the TRI
Reporting Form R and Form A (except Form R Schedule 1). The nine file types are tab-delimited text (.txt) files
packaged into a .zip file.
File
Exarrmle
Descriotion of Contents
Form R/Form A Reference
Type
1
CA_l_2017.txt
Facility data, chemical
identification, chemical uses, on-
site releases and management, off-
site transfers, summary information
Part 1 (all), Part II (section 1, 3,
4, 5, 6.1.A, 6.2ABC,
7B, 7C, 8.2.B, 8.4.B, 8.6.
The Basic Plus Data Files are identified (named) by state, file type, and reporting year:
File Name = State + File Type + Reporting Year
For example, the file "CA_l_2017.txt" contains facility, chemical identification,
chemical use, on-site release and waste management, off-site transfer and summary information (File Type 1)
for all facilities located in California (CA) for reporting year 2017.
In addition to the set of data files for each state, there are two other Basic Plus file sets: Federal and National.
The Federal files (FED_l_2017.txt, FED_2A_2017.txt, etc.) contain TRI data for all government-owned-and-
operated federal sites. The National files (US_l_2017.txt, US_2A_2017.txt, etc.) contain TRI data for all U.S.
states and territories for a specific year.

-------
DESCRIPTION OF FILE TYPE 5 CONTENTS
The "Type 5" file contains information from Section 8.11 of the TRI Reporting Form R. Section 8.11 is an
optional text section in which facilities may choose to provide more detail about activities taken to reduce
releases of the TRI chemical being reported. Collection of Section 8.11 comment data began in reporting
year 2005. Only Form R submissions that have this optional text are included in File Type 5. (Note: EPA has
received ~10 comments for Section 8.11 from facilities that submitted Form R revisions for years prior to
2005.)
All Type 5 files contain data from the following parts and sections of the Form R:
Part
Section
Description
1
1
Reporting Year
1
1
Revision Codes
1
4
Facility Identification Information
1
5
Parent Company Information
II
1
Chemical Identification Data
II
8.11
Additional Information on Source Reduction, Recycling and Pollution
Control

-------
WHAT'S IN THIS DOCUMENT
The rest of this document is organized as a four-column data table. It describes what information you will
find when you download and open any of the TRI Basic Plus Data: File Type 5 files.
Column
Description
Number (No.)
The sequential number of the data element in the record
Field Name
The name of the data element (Note: these names correspond to the various
column headings in the data files themselves.)
Data Type
'C' for character data (alphanumeric)
'N' for numeric data
'D' for date
Description
A brief statement of what the data element represents, plus its TRI System
Source (in Table Name. Field Name format) and where on the TRI Reporting
Form R the data element is reported (i.e., reference). TRI System Source refers
to the data element's physical location within EPA's Envirofacts online data
warehouse.
When you open any of the Basic Plus data files, you'll see that the contents are delimited by tabs,
meaning a tab is placed between each data element. The first row of each file contains column headers,
which correspond to the "field names" in this document.
B
C
j REPORTING YEAR TRADE SECRET INDICATOR TRIFID
NO
2	12016
3	2016
4	2016
37087TSH B M1420T
NO
NO
2740WNVRNM837TR
7585WSN DRS435H1
Example of the first four rows of a Basic Plus data file
FACILITY NAME
NOVAMET SPECIALTY PRODUCTS
ENVIRONMENTAL AIR SYSTEMS 1NC-TRJAD
SANDERSON FARMS OAKWOOD FEED MILL
REMINDER: Quantities of dioxin and dioxin-like compounds are in grams. Quantities of all other TRI chemicals
are reported in pounds. Facilities cannot use range codes to report quantities for dioxin and dioxin-like
compounds and other Persistent Bioaccumulative Toxics (PBTs).
HELPFUL RESOURCES FOR USERS OF DOWNLOADABLE DATA FILES
When using any of the downloadable TRI data files, it will be helpful for users to refer to the TRI Reporting
Form R, the TRI Reporting Forms & Instructions document, and the Envirofacts TRI data model. The Reporting
Forms & Instructions document and sample reporting forms are available online in the GuideME application at
www.epa.gov/tri/guideme. The Envirofacts TRI data model is found at https://www.epa.gov/enviro/tri-model.
These resources provide useful context and have additional details about certain data elements.

-------
FILE TYPE 5 CONTENTS
No.
Field Name
Type
Description
1
REPORTING YEAR
C
The calendar year in which the reported activities occurred.
Source: TRI_REPORTING_FORM.REPORTING_YEAR
Reference: Part 1, Section 1
2
TRIFD
C
TRI facility identification in the format zzzzznnnnnsssss, where
usually zzzzz = facility zip code, nnnnn = first five consonants
of the name, and sssss = first five non-specific characters in
the street address. The three sections of the format were
separated by hyphens prior to RY 2006.
NOTE: The content of this field is not changed to match facility
ownership, or zip code changes. Rather, the TRI Facility ID
identifies a specific geographical location which is also
identified by the latitude and longitude of that location.
Source: TRI_FACILITY.TRI_FACI LITYJD
Reference: Part 1, Section 4.1
3
FACILITY NAME
C
Name of the reporting facility.
Source: TRI_FACILITY.FACILITY_NAME
Reference: Part 1, Section 4.1
4
FACILITY STREET
C
Street address of the reporting facility.
Source: TRI_FACILITY.STREET_ADDRESS
Reference: Part 1, Section 4.1
5
FACILITY CITY
C
City in which the reporting facility is located.
Source: TRI_FACILITY.CITY_NAME
Reference: Part 1, Section 4.1
6
FACILITY COUNTY
C
County in which the reporting facility is located.
Source: TRI_FACILITY.COUNTY_NAME
Reference: Part 1, Section 4.1
7
FACILITY STATE
C
Two-letter state code of the reporting facility.
Source: TRI_FACILITY.STATE ABBR
Reference: Part 1, Section 4.1
8
FACILITY ZIP CODE
C
ZIP code of the reporting facility.
Source: TRI_FACILITY.ZIP_CODE
Reference: Part 1, Section 4.1
9
BIA CODE
C
Three-letter Bureau of Indian Affairs (BIA) code indicating the
tribal land the facility is on.
Source: TRI FACI LITY. BIA TRIBAL CODE
10
TRIBE NAME
C
The name of the Tribe.
Source: TRI_TRIBE_DESC.
11
MAILING NAME
C
The mailing name for thefacility.
Source: TRI FACILITY. MAIL NAME
12
MAILING STREET
C
Street address of the reporting facility's mailing address.
Source: TRI_FACILITY.MAIL_STREET_ADDRESS
Reference: Part 1, Section 4.1
13
MAILING CITY
C
City name of the facility's mailing address.
Source: TRI FACI LITY. MAIL CITY

-------
No.
Field Name
Type
Description



Reference: Part 1, Section 4.1
14
MAILING STATE
C
State of the reporting facility's mailing address.
Source: TRI_FACILITY.MAlL_STATE_ABBR
Reference: Part 1, Section 4.1
15
MAILING PROVINCE
C
Province of the reporting facility's mailing address.
Source: TRI_FACILITY.MAlL_PROVI NCE
Reference: Part 1, Section 4.1
16
MAILING ZIP CODE
C
ZIP code of the reporting facility's mailing address.
Source: TRI_FACILITY.MAlL_ZIP_CODE
Reference: Part 1, Section 4.1
17
ENTIRE FACILITY IND
C
Indicates whether the facility reported as an entire facility or
reported in parts. If the facility reported in parts, all the data
from the parts are disseminated together under the facility as
a whole.
Yes = entire
No = partial
Source: TRI_REPORTING_FORM.ENTIRE_FAC
Reference: Part 1, Section 4.2a
18
PARTIAL FACILITY IND
C
Indicates whether the facility reported as an entire facility or
reported in parts. If the facility reported in parts, all the data
from the parts are disseminated together under the facility as
a whole.
Yes = partial
No = entire
Source: TRI_REPORTING_FORM. PARTI ALFAC
Reference: Part 1, Section 4.2b
19
FEDERAL FACILITY IND
C
Code indicating whether a facility is a federal facility or not.
Reported by the facility.
Yes = Federal
No = non-Federal Value
Source: TRI_REPORTING_FORM.FEDERAL_FAC_IND
Reference: Part 1 Section 4.2c
20
GOCO FACILITY IND
C
Code indicating whether a facility is GOCO (Government-
Owned, Contractor-Operated) facility or not:
Yes = GOCO
No = non-GOCO
Source: TRI_REPORTING_FORM.GOCO_FLAG
Reference: Part 1 Section 4.2d
21
ASSIGNED FED. FACILITY FLAG
C
Code indicating whether the facility is federally owned or
not. Assigned by TRI.
Yes = Federal
No = Non-Federal
Reference: TRI_F ACI LITY. ASGN_FEDERAL
22
PUBLIC CONTACT NAME
C
Name of the individual whom the public may contact if
clarification of data is needed.
Source: TRI_REPORTING_FORM.PUBLIC_CONTACT_PERSON
Reference: Part 1, Section 4.4

-------
No.
Field Name
Type
Description
23
PUBLIC CONTACT PHONE
C
Area code and telephone number of the public contact.
Source: TRI_REPORTING_FORM.PUBLIC_ CONTACT_PHONE
Reference: Part 1, Section 4.4
24
PUBLIC CONTACT PHONE EXT
C
Phone extension of the public contact
Source: TRI_REPORTING_FORM.PUBLIC_PHONE_EXT
Reference: Part 1, Section 4.4
25
PUBLIC CONTACT EMAIL
C
Email address of the designated individual whom the public
may contact if clarification of the facility's reported data is
needed.
Source:
TRI_REPORTING_FORM.PUBLIC_CONTACT_PERSON_EMAIL
Reference: Part 1, Section 4.4
26
PRIMARY SIC CODE
C
Primary four-digit Standard Industrial Classification (SIC) code.
SIC codes reported by facilities from RY 1987 through 2005.
Source: TRI_SUBMISSION_SIC.SIC_CODE
Where: primary_ind ='1'
Reference: Part 1, Section 4.5a
27
SIC CODE 2
C
Second four-digit Standard Industrial Classification (SIC) code
entered by facility. SIC codes reported by facilities from
RY 1987 through 2005.
Source: TRI_SUBMISSION_SIC.SIC_CODE
Where: sic_sequence_num ='2'
Reference: Part 1, Section 4.5b
28
SIC CODE 3
C
Third four-digit Standard Industrial Classification (SIC) code
entered by facility. SIC codes reported by facilities from
RY 1987 through 2005.
Source: TRI_SUBMISSION_SIC.SIC_CODE
Where: sic_sequence_num ='3'
Reference: Part 1, Section 4.5c
29
SIC CODE 4
C
Fourth four-digit Standard Industrial Classification (SIC) code
entered by facility. SIC codes reported by facilities from RY
1987 through 2005.
Source: TRI_SUBMISSION_SIC.SIC_CODE
Where: sic_sequence_num ='4'
Reference: Part 1, Section 4.5d
30
SIC CODE 5
C
Fifth four-digit Standard Industrial Classification (SIC) code
entered by facility. SIC codes reported by facilities from RY
1987 through 2005.
Source: TRI_SUBMISSION_SIC.SIC_CODE
Where: sic_sequence_num ='5'
Reference: Part 1, Section 4.5e
31
SIC CODE 6
C
Sixth four-digit Standard Industrial Classification (SIC) code
entered by facility. SIC codes reported by facilities from RY
1987 through 2005.
Source: TRI_SUBMISSION_SIC.SIC_CODE
Where: sic_sequence_num ='6'
Reference: Part 1, Section 4.5f
32
NAICS ORIGIN
C
Indicates whether North American Industry Classification

-------
No.
Field Name
Type
Description



System (NAICS) codes were reported or assigned.
R = Reported
A = Assigned
33
PRIMARY NAICS CODE
C
Primary six-digit North American Standard Industry
Classification System (NAICS) code. NAICS codes reported
by facilities from RY 2006 to present. NAICS codes in prior
years were assigned by EPA. See Appendix A - "NAICS
Codes Assignments" for more details.
Source: TRI_SUBMISSION_NAICS.NAICS_CODE
Where: primary_ind = 'V
Reference: Part 1, Section 4.5a
34
NAICS CODE 2
C
Second six-digit North American Standard Industry
Classification System (NAICS) code entered byfacility.
NAICS codes reported by facilities from RY 2006 to present.
NAICS codes in prior years were assigned by EPA.
Source: TRI_SUBMISSION_NAICS.NAICS_CODE
Where: naics_sequence_num = 'T
Reference: Part 1, Section 4.5b
35
NAICS CODE 3
C
Third six-digit North American Standard Industry
Classification System (NAICS) code entered byfacility.
NAICS codes reported by facilities from RY 2006 to present.
NAICS codes in prior years were assigned by EPA.
Source: TRI_SUBMISSION_NAICS.NAICS_CODE
Where: naics_sequence_num = '3'
Reference: Part 1, Section 4.5c
36
NAICS CODE 4
C
Forth six-digit North American Standard Industry Classification
System (NAICS) code entered byfacility. NAICS codes reported
by facilities from RY 2006 to present. NAICS codes in prior
years were assigned by EPA.
Source: TRI_SUBMISSION_NAICS.NAICS_CODE
Where: naics_sequence_num = '4'
Reference: Part 1, Section 4.5d
37
NAICS CODE 5
C
Fifth six-digit North American Standard Industry Classification
System (NAICS) code entered byfacility. NAICS codes reported
by facilities from RY 2006 to present. NAICS codes in prior
years were assigned by EPA.
Source: TRI_SUBMISSION_NAICS.NAICS_CODE
Where: naics_sequence_num = '5'
Reference: Part 1, Section 4.5e
38
NAICS CODE 6
C
Sixth six-digit North American Standard Industry Classification
System (NAICS) code entered byfacility. NAICS codes reported
by facilities from RY 2006 to present. NAICS codes in prior
years were assigned by EPA.
Source: TRI_SUBMISSION_NAICS.NAICS_CODE
Where: naics_sequence_num = '6'
Reference: Part 1, Section 4.5f
39
LATITUDE
N
The latitude value that best represents the facility according to
EPA's Facility Registry System (FRS). In RY 2005, EPA stopped
collecting the latitude value and began obtaining it from FRS.

-------
No.
Field Name
Type
Description



Format: signed 2-digit whole number, 6 digit decimal positions
(+nn.nnnnnn).
Source: EPA's Facility Registry System
40
LONGITUDE
N
The longitude value that best represents the facility according
to EPA's Facility Registry System (FRS). In 2005, TRI stopped
collecting the longitude value and began obtaining it from FRS.
Format: signed 3-digit whole number, 6 digit decimal positions
(+nnn.nnnnnn).
Source: EPA's Facility Registry System
41
D&B NR A
C
Unique identification number assigned by Dun and
Bradstreet to the reporting facility.
Source: TRI_FACILITY_DB.DB_N U M
Reference: Part 1, Section 4.7a
42
D&B NR B
C
Unique identification number assigned by Dun and
Bradstreet to the reporting facility.
Source: TRI_FACILITY_DB.DB_N U M
Reference: Part 1, Section 4.7b
43
RCRA NR A
C
Twelve-digit alphanumeric identifier assigned by EPA per the
Resource Conservation and Recovery Act (RCRA).
Source: EPA's Facility Registry System
44
RCRA NR B
C
Twelve-digit alphanumeric identifier assigned by EPA per the
Resource Conservation and Recovery Act (RCRA).
Source: EPA's Facility Registry System
45
NPDESNRA
C
Nine-digit alphanumeric identifier assigned to a facility in
EPA's National Pollutant Discharge Elimination System
(NPDES).
Source: EPA's Facility Registry System
46
NPDESNR B
C
Nine-digit alphanumeric identifier assigned to a facility in
EPA's National Pollutant Discharge Elimination System
(NPDES).
Source: EPA's Facility Registry System
47
UIC NR A
C
Underground injection identification number, assigned by EPA
or the state, to a facility.
Source: EPA's Facility Registry System
48
UICNRB
C
Underground injection identification number, assigned by EPA
or the state, to a facility.
Source: EPA's Facility Registry System
49
PARENT COMPANY NAME
C
Name of the corporation or other business entity that
controls the reporting facility.
Source: TRI_FACILITY.PARENT_CO_N AME
Reference: Part 1, Section 5.1
50
PARENT COMPANY D&B NR
C
Unique identification number assigned by Dun and Bradstreet
to the parent company of the reporting facility.
Source: TRI_F ACI LITY. P ARE NT_CO_D B_N U M
Reference: Part 1, Section 5.2

-------
No.
Field Name
Type
Description
51
DOCUMENT CONTROL
NUMBER
C
Unique identification number assigned to each TRI submission
by EPA. Format: TTYYMMMNNNNNC, where
TT = document type
YY = reporting year
MMM = document type
NNNNN= sequential number
C = check digit
Source: TRI_REPORTING_FORM.DOC_CTRL_NUM
Reference: NA (System-generated)
52
CAS NUMBER
C
Chemical Abstracts Service (CAS) Registry Number for unique
chemical, or category code (for compounds).
NOTE: CAS number 999999999 is for sanitized trade secret
submissions; CHEM_NAME displays the reported generic
chemical name.
Source: TRI_REPORTING_FORM.TRI_CHEM_ID
Reference: Part II, Section 1.1
53
CHEMICAL NAME
C
Name of the chemical or (generic name, if the chemical is
claimed as a trade secret).
Source: TRI_REPORTING_FORM.CAS_CHEM_NAME
Reference: Part II, Section 1.2 or Part II, Section 1.3
54
CLASSIFICATION
C
Indicates the classification of the chemical. Chemicals can be
classified as either a dioxin or dioxin-like compound, a
Persistent, Bioaccumulative and Toxic chemical, or a general
EPCRA Section 313 chemical.
Values: {TRI, PBT, DIOXIN} where:
TRI = General EPCRA Section 313 Chemical
PBT = Persistent Bioaccumulative and Toxic
DIOXIN = Dioxin or Dioxin-like compound
Source: TRI_CHEM_INFO.CLASSIFICATION
Reference: NONE
55
METALJND
C
Code indicating whether the chemical is a metal or not.
Yes = Metal
No = Non-Metal
Source: TRI_CHEM_INFO.METALJND
56
REVISION CODE 1
C
If the facility revised its original TRI reporting form for this
chemical, this code indicates the reason for the revision.
Values:
RR1 = New Monitoring Data
RR2 = New Emission Factors
RR3 = New Chemical Concentration Data
RR4 = Recalculation(s)
RR5 = Other Reason(s)
Source: TRI_REPORTING_FORM.REVISION_CODE
57
REVISION CODE 2
C
If the facility revised its original TRI reporting form for this
chemical, this code indicates the reason for the revision.
Values:
RR1 = New Monitoring Data
RR2 = New Emission Factors
RR3 = New Chemical Concentration Data

-------
No.
Field Name
Type
Description



RR4 = Recalculation(s)
RR5 = Other Reason(s)
Source: TRI_REPORTING_FORM.REVISION_CODE
58
COMMENT SEQUENCE
C
This column shows the sequence in which the comments
were reported.
Source: TRI_TRIPS_COMMENT.COMMENT SEQ
59
SECTION
C
The section of the Form R in which the comment was
reported. This value will be "8.11" for all entries in this file
because this file contains only comments from Section
8.11.
Source: TRI TRIPS COMMENT.SECTION
60
COMMENT TYPE CODE
C
A code indicating what type of comment was reported.
Source: TRI_TRIPS_COMMENT.COMMENT TYPE
61
COMMENT TYPE DESCRIPTION
C
The full description of the comment type.
Source: TRI_CODE_DESC.DESCRIPT
Where: Tablejd = '24' and Comment_Type = Code
62
COMMENT TEXT
C
The comment submitted by the facility in Section 8.11 of
the Form R.
Source: TRI_TRIPS_COMMENT.COMMENT_TEXT
63
P2 CLASSIFICATION
C
For Section 8.11 comments related to pollution prevention
activities, this data element indicates the subcategory of
the comment. See Appendix B for a complete list of
subcategories and descriptions.
Source: TRI_TRIPS_C0MMENT.P2_CLASSIFICATI0N

-------
APPENDIX A - NAICS Code Assignments
Until RY 2006, the TRI Program used Standard Industrial Codes (SIC) to identify each reporting facility's
industry sector. In RY 2006, the TRI Program began using North American Industry Classification System
(NAICS) codes.
To allow for analysis of data across years, the TRI Program assigned NAICS codes to each TRI submission from
1987 through 2005. The six methods used to assign NAICS codes and the number and percentages of
assignments per method are shown in the table below. The "Order of Precedence" column indicates the order
in which the methods were used to make an assignment.
Method
Order of
Precedence
Number of NAICS codes
Assigned via Method
(in Thousands)
Percentage Per Method
Reported Data Used
1
821K
50%
SIC to NAICS Crosswalk
2
478K
29%
EPA Facility Registry System
(FRS)
3
190K
11%
Commercial Sources
4
113K
7%
Statistics
5
51K
3%
Other Methods
6
2K
Less than 1 %
Reported Data Used - In this method, the primary NAICS code reported by each facility in RY 2006 was used
to make an assignment to chemical submissions (Form Rs and Form As) for years 1987 to 2005. This method
was only used under the following conditions:
1.	The RY 2006 chemical submitted had only one primary NAICS code reported
2.	The prior year submission(s) for the same chemical had only one primary SIC code consistently
reported
3.	The SIC to NAICS Crosswalk (obtained for the U.S. Census Bureau) showed a one-to-one match
between the reported SIC and NAICS codes
This method was used to assign 50% of all NAICS codes.
SIC to NAICS Crosswalk - In this method, the TRI Program used a crosswalk or lookup table that translated SIC
codes into NAICS codes to assign a primary NAICS code to a pre-2006 TRI chemical submission. The primary SIC
code reported on the TRI form was used to lookup the corresponding NAICS code. Not all SIC codes translated
into only one NAICS code, so it was not possible to use this method to assign a NAICS code to each chemical
submission. However, it was used to make 29% of all the assignments.
EPA Facility Registry System (FRS) - In this method, the TRI Program used NAICS codes found in EPA's Facility
Registry System (FRS) to assign a primary NAICS code to each TRI chemical submission. This method was only

-------
used if FRS listed only one primary NAICS code for a facility. 11% of all assignments were made using this
method.
Commercial Sources - This method involved using various commercial services to verify NAICS code
assignments. 7% of all assignments were made using this method.
Statistics - For 3% of NAICS code assignments, the TRI Program used various statistical methods based on past
and present data.
Other Methods - Manual research (e.g., using Internet searches and other government agencies' data) and
personally contacting facilities helped the TRI Program assign NAICS codes to approximately 2,000 TRI
submissions.
APPENDIX B - Pollution Prevention Comment Categories
•	Barriers to P2: Section 8.11 comments categorized as "Barriers to P2" describe barriers the reporting
facility faced in implementing additional source reduction, recycling or pollution control activities
during the reporting year.
•	Source Reduction: Section 8.11 comments categorized as "Source Reduction" relate to any practices
that reduce the quantity of the TRI-reported chemical entering the waste stream or released into the
environment, or that reduce the hazard to human health and environment of such releases. Examples
include green chemistry and green engineering practices.
• Miscellaneous: Section 8.11 comments categorized as "Miscellaneous" are not related to P2.

-------