risk_management_plans

Data license: ODbL · Data source: EDGI Cloud Portal

Custom SQL query

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

Many 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_chemical

chemical_id, chemical_name, cas_number, flammable_toxic

135 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

rmp_facility_chemicals

facility_chemical_id, facility_id, chemical_id, program_level

Many rows

rmp_facility_naics

facility_naics_id, facility_id, naics_code

22,556 rows

rmp_naics

naics_code, naics_description

503 rows

sqlite_sequence

name, seq

1 row

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