Skip to main content

Data Dictionary

Column Type Label Beskrivelse
TRI_FACILITY_ID text TRI Facility ID

The TRI Facility Identification Number assigned by the EPA/TRI.

DOC_CTRL_NUM text Document Control Number

The Document Control Number is a unique ID that is assigned to each TRI reporting form.

FACILITY_NAME text Facility Name

Facility Name

STREET_ADDRESS text Street Address

Street Address where facility is located

CITY_NAME text City

Name of city where facility is located

COUNTY_NAME text County

Name of county where facility is located

STATE_COUNTY_FIPS_CODE text State County FIPS Code

FIPS Code for State and County where facility is located

STATE_ABBR text State

Abbreviation of state where the facility is located

ZIP_CODE text ZIP Code

ZIP code where facility is located. Either 5 or 9 characters. No hyphens.

REGION text Region

The EPA region in which the facility is located.

FAC_CLOSED_IND text Facility Closed Indicator

A flag that indicates whether a facility is open (value =' 0'), closed (value = '1'), or inactive for TRI (value = '2').

ASGN_FEDERAL_IND text Federal Indicator

An identifier that indicates the ownership status of a facility. A Federal facility is a facility owned or operated by the Federal government. This includes facilities that are operated by contractors to the Federal government (i.e., a facility where the land is owned by the Federal government but a private company is under contract to run the facility's operations). The types of Federal facilities that report to TRI are broader than the types of private sector facilities that report to TRI (e.g., DOD military bases). Values: C = 'Commercial', F = 'Federal facility', and G = 'Government owned/contractor operated' (GOCO).

ASGN_AGENCY text Agency Abbreviation

An abbreviation for the name of the agency supported by a federal or Government Owned/Contractor Operated (GOCO) reporting site.

PARENT_CO_DB_NUM text Parent Company DB Number

The number which has been assigned to the parent company by Dun & Bradstreet. Dun & Bradstreet is a private financial tracking and accounting firm. Not all parent companies will have a Dun & Bradstreet number. 'NA' indicates that the facility or establishment's parent company does not have a Dun & Bradstreet number.

PARENT_CO_NAME text Parent Company Name

Name of the corporation or other business company that is the ultimate parent company, located in the United States, of the facility or establishment submitting the data. The parent company is the company that directly owns at least 50 percent of the voting stock of the reporting company. This does not include foreign parent companies. 'NA' indicates that the facility does not have a parent company.

STANDARDIZED_PARENT_COMPANY text Standardized Parent Company

A data field developed by EPA that is intended to best reflect the current ultimate US parent company for the facility. EPA developed this field to facilitate the aggregation of TRI facility-level information to the associated parent company by ensuring that each company is referenced consistently by the same name. Filers often submit names with small variations (e.g., Exopack vs. Exopack Holdings Corp) that make aggregation at the corporate level challenging when using parent names as reported. The standardized parent company field was developed by standardizing the self-submitted parent company names through a process described on the TRI website (e.g., eliminating periods, standardizing common acronyms such as Inc and Corp, etc.). The process also includes the replacement of subsidiary names with the name of the ultimate US parent in cases where EPA identified a subsidiary in the submitted parent company field.

EPA_REGISTRY_ID text FRS ID

Indicates the Facility Registry Service (FRS) id for a TRI Facility, POTW Facility or Off-site Transfer Location facility. The Facility Registry Service (FRS) is a centrally managed database at EPA that identifies facilities, sites or places subject to environmental regulations or of environmental interest. Using the FRS Id (EPA_REGISTRY_ID), data users can link data from different EPA programs together. See the Facility Registry Service at https://www.epa.gov/frs for more details.

TRADE_SECRET_IND text Trade Secret Indicator

Indicator that shows whether the identity of the toxic chemical has been claimed a trade secret. If the facility has indicated that the chemical name is a trade secret, the chemical name will not be released to the public. Values: 1 = 'Trade Secret' box checked, 0 = 'Trade Secret' box not checked.

REPORTING_YEAR int4 Year

The Reporting Year - Year the chemical was released or managed as waste

CAS_NUM text CAS Registry Number

The Chemical Abstract Service (CAS) registry number of the fluorinated green house gas (F-GHG) for which emissions are reported.

ELEMENTAL_METAL_INCLUDED text Metal Flag

"Is a flag that indicates when release and management data for a metal compound (i.e., Lead compounds) have been reported in combination with the data for the corresponding elemental metal (i.e., Lead). An option was added in reporting year (RY) 2018 to the TRI Form R that allows facilities to submit a combined report for a metal compound and the corresponding elemental metal provided they are both (individually) above reporting thresholds. For example, a facility could report their releases and other waste manage for both Copper compounds and Copper on one form R given both were individually above the reporting thresholds. This data element, Elemental_Metal_Included, indicates when that has happened. A value of 'Y' indicates the Form R report contains combined data for a metal compound (i.e., Mercury Compounds) and the corresponding elemental metal (i.e., Mercury).

When the value of this data element is 'Y', the chemical name that will be displayed in all Envirofacts reports will be in format of 'Metal and Metal Compounds' (i.e., 'Copper and Copper Compounds')."

TRI_CHEM_ID text

The TRI Facility Identification Number assigned by the EPA/TRI.

CHEM_NAME text Chemical Name

The official name of the toxic chemical, toxic chemical mixture, (e.g., xylene mixed isomers), or chemical category as it appears on the EPCRA Section 313 list. This space will be empty if a trade secret was claimed for the toxic chemical and information is provided in Section 1.3 (MIXTURE_NAME) or 2.1 (GENERIC_CHEM_NAME).

METAL_IND text Metal Indicator

Indicates whether the chemical is a metal or metal compound. If the value for this data element is 1, 2, 3 or 4, the chemical is a metal or metal compound. If the value is 0, the chemical is not a metal or metal compound. See the values below that define the categories of metals and metal compounds: 0 = Chemical is not a Metal or Metal Compound 1 = Parent Metals and Metal Compound Categories 2 = Individually Listed Metal Compounds 3 = Barium and Barium Compounds 4 = Metals with Qualifiers In EZ tables - Indicates whether the chemical is a metal or metal compound. Values are: 'Y'-chemical is a metal or metal compound. 'N'-chemical is not a metal or metal compound.

PBT_IND text PBT Indicator

A value of 'Y' indicates the chemical is a PBT chemical. A value of 'N' indicates the chemical is not a PBT chemical.

LIST_3350 text Regulation 3350

Indicates whether the chemical is reportable under Regulation 3350

CARCINOGEN text Carcinogen Flag

Indicates whether the chemical is reportable as a carcinogen under the CARC.

CLEAN_AIR text Clean Air Act

A value of "Y" indicates that this chemical is monitored under the Federal Clean Air Act.

PRIMARY_SIC_CODE text Primary SIC Code

"The Standard Industrial Classification (SIC) code or codes which describes the primary activity conducted at a facility. SIC codes are 4 digit numbers used by the Bureau of Census as part of a system to categorize and track the types of business activities conducted in the United States. The first two digits of the code represent the major industry group (e.g., SIC code 25XX indicates Furniture and Fixtures) and the second two digits represent the specific subset of that group (e.g., 2511 indicates wood household furniture). EPA instructs facilities to enter their primary SIC code first. Many facilities do not report their primary SIC code first. A facility may be comprised of one or more establishments. An establishment is an economic unit, generally at a single physical location, where business is conducted or where services or industrial operations are performed. Generally, each establishment will have a unique SIC code."

SIC_CODES text SIC Codes

The Standard Industrial Classification (SIC) code or codes which best describes the activities conducted at the facility or establishment. A possibility of 6 SIC codes may be stored within this field.

PRIMARY_NAICS_CODE text Primary NAICS Code

The North American Industry Classification System (NAICS) Codes(s) that best describes the primary activity conducted ata facility. NAICS codes are 6 digit numbers used by the Bureau of Census as part of a system to categorizeand track the types of business activities conducted in the United States. The individual digits within the NAICS code indicate different levels of granularity in identifying a business. A facility may be comprised of one or more establishments. An establishment is an economic unit, generally at a single physical location, where businessis conducted or where services or industrial operations are performed. Each establishment may have a unique NAICS code.

NAICS_CODES text NAICS Codes

The North American Industrial Classification System (NAICS) code or codes that best describes the activities conducted at the facility or establishment. A possibility of 6 NAICS codes may be stored within this field. All NAICS codes reported on the Form R or Form A are sorted from lowest to highest, concatenated into one text string and stored in this field. The order of the NAICS codes in the text string may NOT be in the same as the order they were entered on the form. For example: On the form, the NAICS codes may appear in this order 1) 325193 2) 325998 3) 325199 4) 325113. However, the value of this data element would be 3251133251932325199325998.If you are searching for a form with a specific PRIMARY NAICS code, do not use this data element in your search criteria. It will not indicate the Primary NAICS code. Instead use the PRIMARY_NAICS_CODE data element.If your are searching for a form that had a NAICS reported as either the primary OR a secondary NAICS code, then use this data element in your search. If other words, if it doesn't matter whether the NAICS code you are searching for is a primary or secondary NAICS code, use this data element in your search.

INDUSTRY_CODE int4 Industry Code

The Industry code identifies what industry or sector (Coal Mining, Metal Mining, Electrical Utilities, etc.) a TRI submission (form R or form A) belongs to. Industry sector codes are used to categorize and analyze TRI data. One of their primary uses of the INDUSTRY_CODE is to facilitate the display of industrial trends. Here is the complete list of TRI Industry Codes and their corresponding names. Note that this list of values appears in the TRI_CODE_DESC table where TABLE_ID = '26'. https://enviro.epa.gov/enviro/ef_metadata_html.tri_page?p_column_name=INDUSTRY_CODE

SRS_ID text SRS ID

This is the unique identifier assigned to a substance for internal tracking within EPA systems.

PFAS_IND text PFAS Indicator

A value of 'Y' indicates the chemical is a PFAS chemical. A value of 'N' indicates the chemical is not a PFAS chemical.

ENVIRONMENTAL_MEDIUM text Environmental Medium Code

Code indicating the environmental medium to which the toxic chemical is released from the facility.

RELEASE_RANGE_CODE text Release Range Code

The code that corresponds to the amount of toxic chemical released annually by the reporting facility, reported as a range for releases less than 1,000 pounds. When a facility uses a range code, the amount reported to TRI is the midpoint of the range. On Form R, letter codes are used to represent ranges: A = 1-10 pounds, B = 11-499 pounds, and C = 500-999 pounds. The letters are converted to numbers for storage in the TRIS database where '1' represents range 'A', '3' represents range 'B',and '4' represents range 'C'. The historical value '2' = 1-499 pounds.

REL_EST_AMT float8 Release Estimated Amount

The release estimate (in pounds) reported by the facility. If a release estimate range was reported, then the mid-point of the range was used to populate the release estimate amount.

RELEASE_NA text Release Not Applicable

Indicates whether 'NA' (Not Applicable) was entered on Form R for the release estimate. Values: 1 = 'Yes', 0 = 'No'.

RELEASE_BASIS_EST_CODE text Release Basis Estimate Code

The code representing the technique used to develop the estimate of releases reported in the "Total Release" box (TOTAL_RELEASE). https://enviro.epa.gov/enviro/ef_metadata_html.tri_page?p_column_name=release_basis_est_code

TOTAL_RELEASE float8 Total Release

The total amount (in pounds) of the toxic chemical released to air, water, land, and underground injection wells during the calendar year (January 1 - December 31). Release amounts may be reported as specific numbers or as ranges (RELEASE_RANGE_CODE). https://enviro.epa.gov/enviro/ef_metadata_html.tri_page?p_column_name=TOTAL_RELEASE

Yderligere information

Felt Værdi
Data last updated 8. juli 2025
Metadata last updated 8. juli 2025
Oprettet 16. september 2020
Format CSV
Licens Creative Commons CCZero
Datastore activeTrue
Has viewsTrue
Id1809697b-86ed-4ce2-b813-179b95d6c833
Package id2cff4c07-423a-4b61-af08-7288fbb773eb
Position2
Size20,3 Mb
Stateactive
Url typedatapusher

Data Use Agreement

You must agree to the terms below to access the site.

Terms of use

The Western Pennsylvania Regional Data Center (WPRDC) is a project led by the University Center of Social and Urban Research (UCSUR) at the University of Pittsburgh ("University") in collaboration with City of Pittsburgh and The County of Allegheny in Pennsylvania. The WPRDC and the WPRDC Project is supported by a grant from the Richard King Mellon Foundation.

This Data Use Agreement covers the terms and conditions that you must agree to before you access or use the Data on deposit with the WPRDC. By using the data available on the WPRDC website portal, you agree to the terms and conditions of your access to the WPRDC and your use of the Data on deposit with the WPRDC.

Intending to be legally bound, you agree to the following:

  1. Effective Date: The effective date of the Agreement is the date of your signature or click through acceptance of these terms, and the terms shall continue to bind you with every subsequent attempt to access or use Data from the WPRDC.
  2. Definitions: "Data" for purposes of this Agreement, shall mean all information of varying formats which has been deposited with the WPRDC by The City, The County, and other third parties, to make such information available for public access. Data may cover, but is not limited to topics including property ownership, budgets, transportation, education, public safety, public services, and geographic information. Data may consist of, but is not limited to administrative records created by government or other organizations, statistical information designed to improve the function of government and organizations, and information created about government and organizations. The Data on deposit with the WPRDC is not intended to and should not contain Non-Public Information, as defined below.
  3. "Non-Public Information" for the purposes of this Agreement shall mean information that may not be disclosed to the public for the following reasons: The information is exempt from disclosure or the information is prohibited from being disclosed under State and Federal Laws and regulations including the Pennsylvania Right to Know Act, 65 P.S § 67.101 et seq., the Criminal History Record Information Act, 18 Pa.C.S. §§ 9101-9183, the Health Insurance Portability and Accountability Act (HIPAA), and other applicable privacy laws; The information is covered by a contractual non-disclosure obligation; The information is covered by confidentiality and fiduciary obligations; or The information is private, proprietary or privileged. "User" shall mean any individual who seeks access to or uses WPRDC Data. "Third Party Links" shall mean any website links to other data and data resources provided by the WPRDC portal/website.
  4. Grant of Access and Use of WPRDC Data: Subject to the compliance with the User Terms and Conditions set forth below, UCSUR hereby grants User permission to access and use the Data from the WPRDC pursuant to the license terms, restrictions, or designations placed upon the Data by the Data owner and depositor. This grant shall not include permission to use Non-Public Information which is inadvertently deposited in the WPRDC.
  5. User Terms and Conditions:

    The User is subject to the following terms and conditions with respect to the User's access and use of WPRDC Data.

    1. User shall accept complete responsibility for its access to and use of the Data derived from the WPRDC, or any derivatives User makes of the Data.
    2. User shall abide by the licensing terms if provided by the data owner and WPRDC as publisher.
    3. User shall abide by the terms and conditions of any Third Party Links when accessing data from the WPRDC through such Third Party Links.
    4. User agrees to immediately notify the WPRDC Project Manager, Robert Gradeck, at 412-624-9177 or via email at rmg44@pitt.edu when Non-Public Information is suspected or discovered through User access to the WPRDC. User agrees to refrain from use of any Non-Public Information inadvertently on deposit and accessible from the WPRDC.
    5. User understands that UCSUR may, on its own and without notice, remove Data and Third Party Data Links from the WPRDC.
    6. User understands and agrees that there is no obligation for UCSUR to update or provide customized Data under this Agreement.
    7. User shall comply with all Federal, State, and local laws and regulations governing regarding use of the Data and Third Party Data Links.
    8. User shall provide feedback, questions, concerns, or comments regarding access or use of Data on deposit with the WPRDC by contacting the WPRDC Project Manager, Robert Gradeck, at 412-624-9177 or rmg44@pitt.edu.
  6. Ownership of Data: Ownership of the Data in the WPRDC and through Third Party Links shall remain and belong to the person or party that created it and/or deposited it in the WPRDC. Nothing in this Agreement shall be construed as a transfer or assignment of ownership of any data, copyrights, or other intellectual property.
  7. Disclaimers/No Warranties/As Is and As Available: DISCLAIMER. THE UNIVERSITY, THE CITY, AND THE COUNTY OF ALLEGHENY HEREBY DISCLAIM ALL IMPLIED AND EXPRESS WARRANTIES OF ANY KIND WITH REGARD TO DATA MADE AVAILABLE IN THE WPRDC AND ACCESSED BY USER THROUGH THE WPRDC, INCLUDING, BUT NOT LIMITED TO, THE WARRANTIES OF MERCHANTABILITY AND OF FITNESS FOR ANY PARTICULAR PURPOSE SPECIFIC PURPOSE. THE UNIVERSITY DOES NOT WARRANT THE COMPLETENESS OR ACCURACY OF THE DATA MADE AVAILABLE THROUGH THE WPRDC. USER HEREBY ACKNOWLEDGES AND ACCEPTS THE ABOVE DISCLAIMERS AND USES ALL OF THE DATA IN THE WPRDC AT ITS OWN RISK AND ON AN "AS IS" AND "AS AVAILABLE" BASIS.
  8. Indemnification: User agrees to indemnify, release, and hold harmless the University of Pittsburgh, UCSUR, The City of Pittsburgh, and The County of Allegheny, to include its elected officials, officers, appointees, employees and agents, from any and all liability for claims arising out of my access to and/or use of Data made available through the WPRDC.
  9. Assignability: User agrees that this Agreement may not be assigned by User. This Agreement may be assigned at any time by University without prior notice to Licensee.
  10. Governing Law, Jurisdiction, and Venue: User agrees that this Agreement shall be construed and enforced according to the laws of the Commonwealth of Pennsylvania and the sole jurisdiction and venue for the resolution of any dispute arising from or relating to the Agreement shall be the state and federal courts located within the County of Allegheny, Pennsylvania.

Through clicking the button below, the User represents that they are over the age of 18 and understands and agrees to the terms and conditions set forth above.