Merged dataset of all incidents.
1 |
A data frame with 53940 rows and 60 variables:
Identify if record meets the significant criteria or not: If there was fatality, injury, fire, explosion, total property damage $50K or more in 1984 dollars, non-HVL loss >= 50bbls, HVL loss >= 5bbls, then SIGNIFICANT=’YES’, else SIGNIFICANT=’NO’. See also: https://www.phmsa.dot.gov/sites/phmsa.dot.gov/files/docs/pdmpublic_incident_page_allrpt.pdf.
Identify if record meets the SERIOUS criteria or not: If there was fatality or injury then SERIOUS = ‘YES’ else SERIOUS = ’NO’.
Unique incident ID. Also called report ID or report number.
Unique operator ID.
Name of the pipelines operator at the time of the incident (year).
State of incidents (for offshore, the state of nearby coast).
Whether the oil spill occured onshore or offshore.
Part of system involved in accident.
Item involved in accident.
Year item installed that involved in accident.
Cause, coded by PHMSA.
Cause of the incident.
Subcause of the incident, coded by PHMSA.
Total number of Fatalities.
Total number of Injuries.
Total costs (in US$).
Converted Property Damage to Year 1984 dollars.
Volume of the spill (barrels).
Estimated volume of commodity recovered (barrels).
Did a fire occur?
Did an explosion occur?
Volume of substance unintentionally released (in barrels) minus volume recovered.
Year accident occurred, derived from accident date.
Date of the spill.
Accident location latitude.
Accident location longitude.
Water Contamination.
Year that the failed item was manufactured (for 2010 onward: pipe or valve only).
Anticipated remediation - Surface water.
Anticipated remediation - Ground water.
Anticipated remediation - Soil.
Anticipated remediation - Vegetation.
Anticipated remediation - Wildlife.
Gammas (topic weights) for topic 1 in the narrative which describes the management of incident reports.
Gammas (topic weights) for topic 2 which describes the management of spills.
Gammas (topic weights) for topic 3 which contains terms related to contractors and excavation.
Gammas (topic weights) for topic 4 which is related to storms, water and related damages.
Gammas (topic weights) for topic 5 which is related to the remote operation of pipelines from control centers.
Gammas (topic weights) for topic 6 which is related to service and repair of pipelines.
Gammas (topic weights) for topic 7 which is related to pumps and their components.
Gammas (topic weights) for topic 8 which describes procedures.
Gammas (topic weights) for topic 9 which contains terms relating to the different commodities being transported.
Gammas (topic weights) for topic 10 which contains terms related to the remote monitoring of pipelines.
Gammas (topic weights) for topic 11 which contains terms such as flow, pressure, and relief.
Gammas (topic weights) for topic 12 which describes corrosion-related damages.
Gammas (topic weights) for topic 13 which includes gaskets and related terms.
Gammas (topic weights) for topic 14 which is related to the reporting of spills.
Gammas (topic weights) for topic 15 which describes the personnels onsite response.
Gammas (topic weights) for topic 16 which includes terms related to valves.
Gammas (topic weights) for topic 17 which contains terms related to a leak and cleanup.
Gammas (topic weights) for topic 18 which describes the contamination of the environment that resulted from a spill.
Gammas (topic weights) for topic 19 which is related to the release of oil.
Gammas (topic weights) for topic 20 which contains words related to a release of crude oil.
Gammas (topic weights) for topic 21 which is related to fire and emergencies.
Gammas (topic weights) for topic 22 which is related to storage tanks.
Gammas (topic weights) for topic 23 which describes cracks and other kinds of failure.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.