About this Dataset

Allegheny County Toxics Release Inventory

The Toxics Release Inventory (TRI) data provides information about toxic substances released into the environment or managed through recycling, energy recovery, and treatment in the United States. Annual releases are compiled and reported by the U.S. Environmental Protection Agency (EPA) and shared on the TRI Website. The TRI covers over 650 chemicals and chemical groupings across a broad range of industries. Chemicals covered are linked to cancer or other chronic human health effects, tied to significant adverse human health effects, or significant adverse environmental effects.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:07:29.274500
Tags: _etl, achd-dash, environment, health, social-determinants-of-health, toxic-release-inventory, toxics-release-inventory

Tables

TRI Facilities

@usgov.allegheny_county_city_of_pitts_allegheny_county_toxics_29019337.tri_facilities

68.06 KB
221 rows
41 columns


CREATE TABLE tri_facilities (
  "n__id" BIGINT,
  "id" VARCHAR,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city_name" VARCHAR,
  "county_name" VARCHAR,
  "state_county_fips_code" BIGINT,
  "state_abbr" VARCHAR,
  "zip_code" BIGINT,
  "region" BIGINT,
  "fac_closed_ind" BIGINT,
  "mail_name" VARCHAR,
  "mail_street_address" VARCHAR,
  "mail_city" VARCHAR,
  "mail_state_abbr" VARCHAR,
  "mail_province" VARCHAR,
  "mail_country" VARCHAR,
  "mail_zip_code" VARCHAR,
  "asgn_federal_ind" VARCHAR,
  "asgn_agency" VARCHAR,
  "frs_id" VARCHAR,
  "parent_co_db_num" VARCHAR,
  "parent_co_name" VARCHAR,
  "fac_latitude" DOUBLE,
  "fac_longitude" DOUBLE,
  "pref_latitude" DOUBLE,
  "pref_longitude" DOUBLE,
  "pref_accuracy" DOUBLE,
  "pref_collect_meth" VARCHAR,
  "pref_desc_category" VARCHAR,
  "pref_horizontal_datum" VARCHAR,
  "pref_source_scale" VARCHAR,
  "pref_qa_code" DOUBLE,
  "asgn_partial_ind" BIGINT,
  "asgn_public_contact" VARCHAR,
  "asgn_public_phone" DOUBLE,
  "asgn_public_phone_ext" DOUBLE,
  "asgn_public_contact_email" VARCHAR,
  "bia_code" VARCHAR,
  "standardized_parent_company" VARCHAR,
  "epa_registry_id" DOUBLE
);

TRI Land

@usgov.allegheny_county_city_of_pitts_allegheny_county_toxics_29019337.tri_land

975.28 KB
63801 rows
42 columns


CREATE TABLE tri_land (
  "n__id" BIGINT,
  "tri_facility_id" VARCHAR,
  "doc_ctrl_num" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city_name" VARCHAR,
  "county_name" VARCHAR,
  "state_county_fips_code" BIGINT,
  "state_abbr" VARCHAR,
  "zip_code" BIGINT,
  "region" BIGINT,
  "fac_closed_ind" BIGINT,
  "asgn_federal_ind" VARCHAR,
  "asgn_agency" VARCHAR,
  "parent_co_db_num" VARCHAR,
  "parent_co_name" VARCHAR,
  "standardized_parent_company" VARCHAR,
  "epa_registry_id" DOUBLE,
  "trade_secret_ind" BIGINT,
  "reporting_year" BIGINT,
  "cas_num" VARCHAR,
  "elemental_metal_included" VARCHAR,
  "tri_chem_id" VARCHAR,
  "chem_name" VARCHAR,
  "metal_ind" BIGINT,
  "pbt_ind" BIGINT,
  "list_3350" VARCHAR,
  "carcinogen" VARCHAR,
  "clean_air" VARCHAR,
  "primary_sic_code" VARCHAR,
  "sic_codes" VARCHAR,
  "primary_naics_code" BIGINT,
  "naics_codes" DOUBLE,
  "industry_code" BIGINT,
  "srs_id" DOUBLE,
  "pfas_ind" BIGINT,
  "environmental_medium" VARCHAR,
  "release_range_code" DOUBLE,
  "rel_est_amt" DOUBLE,
  "release_na" BIGINT,
  "release_basis_est_code" VARCHAR,
  "total_release" DOUBLE
);

TRI Offsite

@usgov.allegheny_county_city_of_pitts_allegheny_county_toxics_29019337.tri_offsite

730.97 KB
23107 rows
53 columns


CREATE TABLE tri_offsite (
  "n__id" BIGINT,
  "tri_facility_id" VARCHAR,
  "doc_ctrl_num" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city_name" VARCHAR,
  "county_name" VARCHAR,
  "state_county_fips_code" BIGINT,
  "state_abbr" VARCHAR,
  "zip_code" BIGINT,
  "region" BIGINT,
  "fac_closed_ind" BIGINT,
  "asgn_federal_ind" VARCHAR,
  "asgn_agency" VARCHAR,
  "parent_co_db_num" VARCHAR,
  "parent_co_name" VARCHAR,
  "standardized_parent_company" VARCHAR,
  "epa_registry_id" DOUBLE,
  "trade_secret_ind" BIGINT,
  "reporting_year" BIGINT,
  "cas_num" VARCHAR,
  "elemental_metal_included" DOUBLE,
  "tri_chem_id" VARCHAR,
  "chem_name" VARCHAR,
  "metal_ind" BIGINT,
  "pbt_ind" BIGINT,
  "list_3350" VARCHAR,
  "carcinogen" VARCHAR,
  "clean_air" VARCHAR,
  "primary_sic_code" VARCHAR,
  "sic_codes" VARCHAR,
  "primary_naics_code" BIGINT,
  "naics_codes" DOUBLE,
  "industry_code" BIGINT,
  "srs_id" DOUBLE,
  "pfas_ind" BIGINT,
  "transfer_loc_num" BIGINT,
  "off_site_amount_sequence" BIGINT,
  "type_of_waste_management" VARCHAR,
  "transfer_range_code" DOUBLE,
  "transfer_amt" DOUBLE,
  "transfer_est_na" BIGINT,
  "transfer_basis_est_code" VARCHAR,
  "off_site_name" VARCHAR,
  "off_site_street_address" VARCHAR,
  "transfer_city_name" VARCHAR,
  "transfer_county_name" VARCHAR,
  "transfer_state_abbr" VARCHAR,
  "transfer_zip_code" VARCHAR,
  "transfer_country_code" VARCHAR,
  "rcra_num" VARCHAR,
  "controlled_loc" BIGINT,
  "transfer_loc_epa_registry_id" DOUBLE
);

TRI Underground

@usgov.allegheny_county_city_of_pitts_allegheny_county_toxics_29019337.tri_underground

538.56 KB
28855 rows
42 columns


CREATE TABLE tri_underground (
  "n__id" BIGINT,
  "tri_facility_id" VARCHAR,
  "doc_ctrl_num" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city_name" VARCHAR,
  "county_name" VARCHAR,
  "state_county_fips_code" BIGINT,
  "state_abbr" VARCHAR,
  "zip_code" BIGINT,
  "region" BIGINT,
  "fac_closed_ind" BIGINT,
  "asgn_federal_ind" VARCHAR,
  "asgn_agency" VARCHAR,
  "parent_co_db_num" VARCHAR,
  "parent_co_name" VARCHAR,
  "standardized_parent_company" VARCHAR,
  "epa_registry_id" DOUBLE,
  "trade_secret_ind" BIGINT,
  "reporting_year" BIGINT,
  "cas_num" VARCHAR,
  "elemental_metal_included" VARCHAR,
  "tri_chem_id" VARCHAR,
  "chem_name" VARCHAR,
  "metal_ind" BIGINT,
  "pbt_ind" BIGINT,
  "list_3350" VARCHAR,
  "carcinogen" VARCHAR,
  "clean_air" VARCHAR,
  "primary_sic_code" VARCHAR,
  "sic_codes" VARCHAR,
  "primary_naics_code" BIGINT,
  "naics_codes" DOUBLE,
  "industry_code" BIGINT,
  "srs_id" DOUBLE,
  "pfas_ind" BIGINT,
  "environmental_medium" VARCHAR,
  "release_range_code" VARCHAR,
  "rel_est_amt" DOUBLE,
  "release_na" BIGINT,
  "release_basis_est_code" VARCHAR,
  "total_release" DOUBLE
);

TRI Water

@usgov.allegheny_county_city_of_pitts_allegheny_county_toxics_29019337.tri_water

448.7 KB
15984 rows
47 columns


CREATE TABLE tri_water (
  "n__id" BIGINT,
  "tri_facility_id" VARCHAR,
  "doc_ctrl_num" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city_name" VARCHAR,
  "county_name" VARCHAR,
  "state_county_fips_code" BIGINT,
  "state_abbr" VARCHAR,
  "zip_code" BIGINT,
  "region" BIGINT,
  "fac_closed_ind" BIGINT,
  "asgn_federal_ind" VARCHAR,
  "asgn_agency" VARCHAR,
  "parent_co_db_num" VARCHAR,
  "parent_co_name" VARCHAR,
  "standardized_parent_company" VARCHAR,
  "epa_registry_id" DOUBLE,
  "trade_secret_ind" BIGINT,
  "reporting_year" BIGINT,
  "cas_num" VARCHAR,
  "elemental_metal_included" DOUBLE,
  "tri_chem_id" VARCHAR,
  "chem_name" VARCHAR,
  "metal_ind" BIGINT,
  "pbt_ind" BIGINT,
  "list_3350" VARCHAR,
  "carcinogen" VARCHAR,
  "clean_air" VARCHAR,
  "primary_sic_code" VARCHAR,
  "sic_codes" VARCHAR,
  "primary_naics_code" BIGINT,
  "naics_codes" DOUBLE,
  "industry_code" BIGINT,
  "srs_id" DOUBLE,
  "pfas_ind" BIGINT,
  "environmental_medium" VARCHAR,
  "release_range_code" DOUBLE,
  "rel_est_amt" DOUBLE,
  "release_na" BIGINT,
  "release_basis_est_code" VARCHAR,
  "total_release" DOUBLE,
  "water_sequence_num" BIGINT,
  "stream_name" VARCHAR,
  "storm_water_na" VARCHAR,
  "storm_water_percent" DOUBLE,
  "reach_code" DOUBLE
);