risk_management_plans
Data license: ODbL · Data source: EDGI Cloud Portal
Tables
accident_chemicals_view
accident_chemical_id, accident_id, facility_id, facility_name, facility_address, city, state, county, date_of_accident, chemical_name, quantity_released_lbs, percent_weight
2,301 rows
facility_accidents_view
id, facility_accident_id, accident_id, facility_id, facility_name, facility_address, city, state, county, date_of_accident, time_accident_began, release_duration, naics_code, chemical_names, latitude, longitude, popup
1,554 rows
facility_view
epa_facility_id, report, facility_name, facility_address, city, state, county, zip, facility_duns, receipt_date, report_created_date, naics_codes, chemical_names, latitude, longitude, popup
21,561 rows
rmp_accident_chemicals
accident_chemical_id, facility_accident_chemical_id, facility_accident_id, quantity_released_lbs, percent_weight, chemical_id
2,301 rows
rmp_facility
epa_facility_id, report, facility_name, facility_address, city, state, county, zip, facility_duns, latitude, longitude, receipt_date, report_created_date, popup
21,561 rows
rmp_facility_accidents
facility_accident_id, accident_id, facility_id, date_of_accident, time_accident_began, release_duration, naics_code
1,554 rows
tbl_accident_details
EPA_Facility_ID, Accident_History_ID, Facility_Accident_ID, Date_of_Accident, Time_Accident_Began, NAICS_Code_of_Process_Involved, NAICS_Description, Release_Duration_Hours, Release_Duration_Minutes, Gas_Release, Liquid_Spill_Evaporation, Fire, Explosion, Uncontrolled_Runaway_Reaction, Storage_Vessel, Piping, Process_Vessel, Transfer_Hose, Valve, Pump, Joint, Other_Release_Source, Wind_Speed, Wind_Speed_Units, Wind_Direction, Temperature, Atmospheric_Stability_Class, Precipitation_Present, Unknown_Weather_Conditions, Employee_Contractor_Deaths, Public_Responder_Deaths, Public_Deaths, Employee_Contractor_Injuries, Public_Responder_Injuries, Public_Injuries, On_Site_Property_Damage_Dollar, Off_Site_Deaths, Off_Site_Hospitalizations, Off_Site_Public_Deaths, Off_Site_Other_Medical_Treatments, Evacuated, Sheltered_in_Place, Off_Site_Property_Damage_Dollar, Fish_or_Animal_Kills, Tree_Lawn_Shrub_or_Crop_Damage, Water_Contamination, Soil_Contamination, Other_Environmental_Damage, Initiating_Event, Contributing_Equipment_Failure, Contributing_Human_Error, Contributing_Improper_Procedures, Contributing_Overpressurization, Contributing_Upset_Condition, Contributing_By_Pass_Condition, Contributing_Maintenance_Activity_Inactivity, Contributing_Process_Design_Failure, Contributing_Unsuitable_Equipment, Contributing_Unusual_Weather_Condition, Contributing_Management_Error, Contributing_Other, Off_Site_Responders_Notified, Change_Improved_Upgraded_Equipment, Change_Revised_Maintenance, Change_Revised_Training, Change_Revised_Operating_Procedures, Change_New_Process_Controls, Change_New_Mitigation_Systems, Change_Revised_Emergency_Response_Plan, Change_Changed_Process, Change_Reduced_Inventory, Change_None, Change_Other
1,554 rows
... and 15 hidden tables