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

69.97 kB
223 rows
41 columns

CREATE TABLE tri_facilities (
  "n__id" BIGINT  -- Id,
  "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" BIGINT
);

TRI Offsite

@usgov.allegheny_county_city_of_pitts_allegheny_county_toxics_29019337.tri_offsite

774.45 kB
23,904 rows
53 columns

CREATE TABLE tri_offsite (
  "n__id" BIGINT  -- Id,
  "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" BIGINT,
  "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

555.68 kB
29,329 rows
42 columns

CREATE TABLE tri_underground (
  "n__id" BIGINT  -- Id,
  "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" BIGINT,
  "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
);