About this Dataset

Toxics Release Inventory Facility List

The Toxics Release Inventory (TRI) tracks the management of certain toxic chemicals that may pose a threat to human health and the environment. Certain industrial facilities in the U.S. must report annually how much of each chemical is recycled, combusted for energy recovery, treated for destruction, and disposed of or otherwise released on- and off-site. This information is collectively referred to as production-related waste managed.

Descriptions of data terms and field names: https://www.epa.gov/toxics-release-inventory-tri-program/descriptions-tri-data-terms-text-version
Factors to consider when using this data: https://www.epa.gov/toxics-release-inventory-tri-program/factors-consider-when-using-toxics-release-inventory-data
Organization: State of Connecticut
Last updated: 2020-11-12T14:56:06.210993
Tags: release, toxic, tri

Tables

Table 1

@usgov.state_of_connecticut_toxics_release_inventory_facility_list.table_1

304.79 kB
2,125 rows
115 columns

CREATE TABLE table_1 (
  "n_1_year" BIGINT  -- 1. YEAR,
  "n_2_trifd" VARCHAR  -- 2. TRIFD,
  "n_3_frs_id" BIGINT  -- 3. FRS ID,
  "n_4_facility_name" VARCHAR  -- 4. FACILITY NAME,
  "n_5_street_address" VARCHAR  -- 5. STREET ADDRESS,
  "n_6_city" VARCHAR  -- 6. CITY,
  "n_7_county" VARCHAR  -- 7. COUNTY,
  "n_8_st" VARCHAR  -- 8. ST,
  "n_9_zip" BIGINT  -- 9. ZIP,
  "n_10_bia" VARCHAR  -- 10. BIA,
  "n_11_tribe" VARCHAR  -- 11. TRIBE,
  "n_12_latitude" DOUBLE  -- 12. LATITUDE,
  "n_13_longitude" DOUBLE  -- 13. LONGITUDE,
  "n_14_parent_co_name" VARCHAR  -- 14. PARENT CO NAME,
  "n_15_parent_co_db_num" VARCHAR  -- 15. PARENT CO DB NUM,
  "n_16_standard_parent_co_name" VARCHAR  -- 16. STANDARD PARENT CO NAME,
  "n_17_federal_facility" BOOLEAN  -- 17. FEDERAL FACILITY,
  "n_18_industry_sector_code" BIGINT  -- 18. INDUSTRY SECTOR CODE,
  "n_19_industry_sector" VARCHAR  -- 19. INDUSTRY SECTOR,
  "n_20_primary_sic" VARCHAR  -- 20. PRIMARY SIC,
  "n_21_sic_2" VARCHAR  -- 21. SIC 2,
  "n_22_sic_3" VARCHAR  -- 22. SIC 3,
  "n_23_sic_4" VARCHAR  -- 23. SIC 4,
  "n_24_sic_5" VARCHAR  -- 24. SIC 5,
  "n_25_sic_6" VARCHAR  -- 25. SIC 6,
  "n_26_primary_naics" BIGINT  -- 26. PRIMARY NAICS,
  "n_27_naics_2" DOUBLE  -- 27. NAICS 2,
  "n_28_naics_3" DOUBLE  -- 28. NAICS 3,
  "n_29_naics_4" DOUBLE  -- 29. NAICS 4,
  "n_30_naics_5" DOUBLE  -- 30. NAICS 5,
  "n_31_naics_6" DOUBLE  -- 31. NAICS 6,
  "n_32_doc_ctrl_num" BIGINT  -- 32. DOC CTRL NUM,
  "n_33_chemical" VARCHAR  -- 33. CHEMICAL,
  "n_34_elemental_metal_included" BOOLEAN  -- 34. ELEMENTAL METAL INCLUDED,
  "n_35_cas_compound_id" VARCHAR  -- 35. CAS #/COMPOUND ID,
  "n_36_srs_id" DOUBLE  -- 36. SRS ID,
  "n_37_clean_air_act_chemical" BOOLEAN  -- 37. CLEAN AIR ACT CHEMICAL,
  "n_38_classification" VARCHAR  -- 38. CLASSIFICATION,
  "n_39_metal" BOOLEAN  -- 39. METAL,
  "n_40_metal_category" BIGINT  -- 40. METAL CATEGORY,
  "n_41_carcinogen" BOOLEAN  -- 41. CARCINOGEN,
  "n_42_form_type" VARCHAR  -- 42. FORM TYPE,
  "n_43_unit_of_measure" VARCHAR  -- 43. UNIT OF MEASURE,
  "n_44_5_1_fugitive_air" DOUBLE  -- 44. 5.1 - FUGITIVE AIR,
  "n_45_5_2_stack_air" DOUBLE  -- 45. 5.2 - STACK AIR,
  "n_46_5_3_water" DOUBLE  -- 46. 5.3 - WATER,
  "n_47_5_4_underground" BIGINT  -- 47. 5.4 - UNDERGROUND,
  "n_48_5_4_1_underground_cl_i" BIGINT  -- 48. 5.4.1 - UNDERGROUND CL I,
  "n_49_5_4_2_underground_c_ii_v" BIGINT  -- 49. 5.4.2 - UNDERGROUND C II-V,
  "n_50_5_5_1_landfills" BIGINT  -- 50. 5.5.1 - LANDFILLS,
  "n_51_5_5_1a_rcra_c_landfill" BIGINT  -- 51. 5.5.1A - RCRA C LANDFILL,
  "n_52_5_5_1b_other_landfills" DOUBLE  -- 52. 5.5.1B - OTHER LANDFILLS,
  "n_53_5_5_2_land_treatment" BIGINT  -- 53. 5.5.2 - LAND TREATMENT,
  "n_54_5_5_3_surface_impndmnt" BIGINT  -- 54. 5.5.3 - SURFACE IMPNDMNT,
  "n_55_5_5_3a_rcra_surface_im" BIGINT  -- 55. 5.5.3A - RCRA SURFACE IM,
  "n_56_5_5_3b_other_surface_i" DOUBLE  -- 56. 5.5.3B - OTHER SURFACE I,
  "n_57_5_5_4_other_disposal" DOUBLE  -- 57. 5.5.4 - OTHER DISPOSAL,
  "n_58_on_site_release_total" DOUBLE  -- 58. ON-SITE RELEASE TOTAL,
  "n_59_6_1_potw_trns_rlse" DOUBLE  -- 59. 6.1 - POTW - TRNS RLSE,
  "n_60_6_1_potw_trns_trt" DOUBLE  -- 60. 6.1 - POTW - TRNS TRT,
  "n_61_potw_total_transfers" DOUBLE  -- 61. POTW - TOTAL TRANSFERS,
  "n_62_6_2_m10" DOUBLE  -- 62. 6.2 - M10,
  "n_63_6_2_m41" DOUBLE  -- 63. 6.2 - M41,
  "n_64_6_2_m62" DOUBLE  -- 64. 6.2 - M62,
  "n_65_6_2_m40_metal" BIGINT  -- 65. 6.2 - M40 METAL,
  "n_66_6_2_m61_metal" BIGINT  -- 66. 6.2 - M61 METAL,
  "n_67_6_2_m71" BIGINT  -- 67. 6.2 - M71,
  "n_68_6_2_m81" DOUBLE  -- 68. 6.2 - M81,
  "n_69_6_2_m82" BIGINT  -- 69. 6.2 - M82,
  "n_70_6_2_m72" BIGINT  -- 70. 6.2 - M72,
  "n_71_6_2_m63" BIGINT  -- 71. 6.2 - M63,
  "n_72_6_2_m66" DOUBLE  -- 72. 6.2 - M66,
  "n_73_6_2_m67" DOUBLE  -- 73. 6.2 - M67,
  "n_74_6_2_m64" DOUBLE  -- 74. 6.2 - M64,
  "n_75_6_2_m65" DOUBLE  -- 75. 6.2 - M65,
  "n_76_6_2_m73" BIGINT  -- 76. 6.2 - M73,
  "n_77_6_2_m79" DOUBLE  -- 77. 6.2 - M79,
  "n_78_6_2_m90" DOUBLE  -- 78. 6.2 - M90,
  "n_79_6_2_m94" DOUBLE  -- 79. 6.2 - M94,
  "n_80_6_2_m99" DOUBLE  -- 80. 6.2 - M99,
  "n_81_off_site_release_total" DOUBLE  -- 81. OFF-SITE RELEASE TOTAL,
  "n_82_6_2_m20" DOUBLE  -- 82. 6.2 - M20,
  "n_83_6_2_m24" DOUBLE  -- 83. 6.2 - M24,
  "n_84_6_2_m26" DOUBLE  -- 84. 6.2 - M26,
  "n_85_6_2_m28" DOUBLE  -- 85. 6.2 - M28,
  "n_86_6_2_m93" DOUBLE  -- 86. 6.2 - M93,
  "n_87_off_site_recycled_total" DOUBLE  -- 87. OFF-SITE RECYCLED TOTAL,
  "n_88_6_2_m56" DOUBLE  -- 88. 6.2 - M56,
  "n_89_6_2_m92" DOUBLE  -- 89. 6.2 - M92,
  "n_90_off_site_energy_recovery_t" DOUBLE  -- 90. OFF-SITE ENERGY RECOVERY T,
  "n_91_6_2_m40_non_metal" DOUBLE  -- 91. 6.2 - M40 NON-METAL,
  "n_92_6_2_m50" DOUBLE  -- 92. 6.2 - M50,
  "n_93_6_2_m54" DOUBLE  -- 93. 6.2 - M54,
  "n_94_6_2_m61_non_metal" DOUBLE  -- 94. 6.2 - M61 NON-METAL,
  "n_95_6_2_m69" DOUBLE  -- 95. 6.2 - M69,
  "n_96_6_2_m95" BIGINT  -- 96. 6.2 - M95,
  "n_97_off_site_treated_total" DOUBLE  -- 97. OFF-SITE TREATED TOTAL,
  "n_98_6_2_unclassified" BIGINT  -- 98. 6.2 - UNCLASSIFIED,
  "n_99_6_2_total_transfer" DOUBLE  -- 99. 6.2 - TOTAL TRANSFER,
  "n_100_total_releases" DOUBLE  -- 100. TOTAL RELEASES
);