Skip to main content

Data Dictionary

Column Type Label Description
ID text TRI Facility ID

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

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').

MAIL_NAME text Mailing Name

The name which the facility or establishment uses for receiving mail if the address used for mail is different than in the Street box. This may or may not be the same as the name listed in the Facility or Establishment Name box.

MAIL_STREET_ADDRESS text Mailing Address

The address the facility or establishment uses for receiving mail. Form R instructs the submitter to enter the address used for mail only if different than in the Street box. The TRIS database stores the address from the Street box (STREET_ADDRESS) in MAILING_STREET_ADDRESS even when the facility Mailing address is not different.

MAIL_CITY text Mailing City

The city the facility or establishment uses to receive mail. This may or may not be the same as the information reported in the City box.

MAIL_STATE_ABBR text Mailing State

The state abbreviation the facility or establishment uses to receive mail. This may or may not be the same as the information reported in the State box.

MAIL_PROVINCE text Mailing Province

The province the facility or establishment uses to receive mail. A facility may receive mail at an address outside of the United States. The province field gives a facility the flexibility needed to enter a correct mailing address outside the United States.

MAIL_COUNTRY text Mailing Country

The country the facility or establishment uses to receive mail.

MAIL_ZIP_CODE text Mailing Zip Code

The zip code the facility or establishment uses to receive mail. This may or may not be the same as the information reported in the Zip Code box.

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.

FRS_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.

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.

FAC_LATITUDE text Facility Latitude

The series of numbers that identifies the exact physical location of the facility as a measure of the angular distance north form the earth's equator to the center of the facility. The value is stored as degrees, minutes and seconds (0DDMMSS), and the first position is zero-filled. The value is positive for locations north of the equator.

FAC_LONGITUDE text Facility Longitude

The series of numbers which identifies the exact physical location of the facility as a measure of the arc or portion of the earth's equator between the meridian of the center of the facility and the prime meridian. The right-justified value is stored as degrees, minutes and seconds (0DDDMMSS). Tenths of seconds are not stored. The value is negative for locations in the Western hemisphere.

PREF_LATITUDE float8 EPA Latitude

The EPA's preferred geographic latitude estimation of the reporting facility. Value for latitude is in decimal degrees. This is a signed field.

PREF_LONGITUDE float8 EPA Longitude
PREF_ACCURACY int4 GEO Accuracy

The EPA's preferred geographic coordinate accuracy estimation for the reporting facility. Describes the accuracy value as a range (+/) in meters of the latitude and longitude.

PREF_COLLECT_METH text GEO Method

The EPA's preferred geographic coordinate collection method code for the reporting facility. Method used to determine the latitude and longitude.

PREF_DESC_CATEGORY text GEO Description

The EPA's preferred geographic coordinate description category. Describes the category of feature referenced by the latitude and longitude.

PREF_HORIZONTAL_DATUM text GEO Datum

The EPA's preferred geographic coordinate horizontal datum. Reference datum of the latitude and longitude.

PREF_SOURCE_SCALE text GEO Scale

The EPA's preferred geographic coordinate source map scale code. This is the scale of the source used to determine the latitude and longitude.

PREF_QA_CODE text GEO Quality Test

"Contains the results of four quality assurance tests (Test 1 throughTest 4 below) used to determine facility location. ""ZIP Code BoundingBox"" is a rectangle generated from the ZIP Code boundaries, which isdefined by the extreme north-south latitude and east-west longitudes,plus 1 kilometer (km) in each direction. The quality assurance tests are: Test 1 = ZIP Code Bounding Box Test 2 = ZIP Centroid Proximity Test 3 = Alternate Coordinate Proximity Test 4 = Alternate Coordinate Cluster

The results for Tests 1, 2, 3, and 4 are listed left to right in the column, respectively. The possible values and description for each result are: 0 = test was not performed 1 = test was performed and passed 2 = test was performed and failed"

ASGN_PARTIAL_IND text Entire Facility Flag

Indicates that the facility reports by establishment or groups of establishments as assigned by TRI from Form R submissions. Partial facilities may have more than one submission for the same chemical in one reporting year. Values: 0 = 'Entire facility', 1 = 'Partial facility'.

ASGN_PUBLIC_CONTACT text Public Contact Name

The name of the individual who may be contacted by the general public with questions regarding the company and the information reported to TRI as assigned by TRI from Form R submissions. This person may or may not be familiar with the information provided in the form but has been designated by the facility or establishment to handle public inquiries.

ASGN_PUBLIC_PHONE text Public Contact Phone

The phone number to reach the person identified in the Public Contact Name box (PUBLIC_CONTACT_PERSON), as assigned by TRI from Form R submissions.

ASGN_PUBLIC_PHONE_EXT text Public Phone Extention

The telephone extension of the Public Contact Person as reported on the form R

ASGN_PUBLIC_CONTACT_EMAIL text Public Contact Email

The Email address of the PUBLIC_CONTACT_PERSON.

BIA_CODE text Bureau of Indian Affairs Tribal Code

The Bureau of Indian Affairs (BIA) Tribal Code that indicates the tribal land that the facility is located on. A facility reports this three digit code to the Toxics Release Inventory (TRI) program on the form R or form A. There are over 300 BIA Tribal Codes. For a list of BIA Tribal Codes and associated Tribe Names: https://enviro.epa.gov/enviro/TRI_VIEW_TRIBES

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.

Additional Information

Field Value
Data last updated Hulyo 8, 2025
Metadata last updated Hulyo 8, 2025
Created Setyembre 16, 2020
Format CSV
License Creative Commons CCZero
Datastore activeTrue
Has viewsTrue
Idd41759fa-3099-46ae-8a0d-3198ccc80002
Package id2cff4c07-423a-4b61-af08-7288fbb773eb
Position5
Size74.6 KiB
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.