incidents: Merged dataset of all incidents.

Description Usage Format

Description

Merged dataset of all incidents.

Usage

1

Format

A data frame with 53940 rows and 60 variables:

DATAFILE_AS_OF
significant

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.

serious

Identify if record meets the SERIOUS criteria or not: If there was fatality or injury then SERIOUS = ‘YES’ else SERIOUS = ’NO’.

incident_ID

Unique incident ID. Also called report ID or report number.

ID

Unique operator ID.

name

Name of the pipelines operator at the time of the incident (year).

state

State of incidents (for offshore, the state of nearby coast).

on_offshore

Whether the oil spill occured onshore or offshore.

system

Part of system involved in accident.

item

Item involved in accident.

installation_year

Year item installed that involved in accident.

MAP_CAUSE

Cause, coded by PHMSA.

cause

Cause of the incident.

subcause

Subcause of the incident, coded by PHMSA.

fatalities

Total number of Fatalities.

injuries

Total number of Injuries.

cost

Total costs (in US$).

cost_1984

Converted Property Damage to Year 1984 dollars.

TOTAL_COST_CURRENT
commodity
volume

Volume of the spill (barrels).

recovered

Estimated volume of commodity recovered (barrels).

fire

Did a fire occur?

explosion

Did an explosion occur?

narrative
net_loss

Volume of substance unintentionally released (in barrels) minus volume recovered.

year

Year accident occurred, derived from accident date.

date

Date of the spill.

lat

Accident location latitude.

long

Accident location longitude.

water_contamination

Water Contamination.

manufacture_year

Year that the failed item was manufactured (for 2010 onward: pipe or valve only).

surface_water_remediation

Anticipated remediation - Surface water.

groundwater_remediation

Anticipated remediation - Ground water.

soil_remediation

Anticipated remediation - Soil.

vegetation_remediation

Anticipated remediation - Vegetation.

wildlife_remediation

Anticipated remediation - Wildlife.

topic_1

Gammas (topic weights) for topic 1 in the narrative which describes the management of incident reports.

topic_2

Gammas (topic weights) for topic 2 which describes the management of spills.

topic_3

Gammas (topic weights) for topic 3 which contains terms related to contractors and excavation.

topic_4

Gammas (topic weights) for topic 4 which is related to storms, water and related damages.

topic_5

Gammas (topic weights) for topic 5 which is related to the remote operation of pipelines from control centers.

topic_6

Gammas (topic weights) for topic 6 which is related to service and repair of pipelines.

topic_7

Gammas (topic weights) for topic 7 which is related to pumps and their components.

topic_8

Gammas (topic weights) for topic 8 which describes procedures.

topic_9

Gammas (topic weights) for topic 9 which contains terms relating to the different commodities being transported.

topic_10

Gammas (topic weights) for topic 10 which contains terms related to the remote monitoring of pipelines.

topic_11

Gammas (topic weights) for topic 11 which contains terms such as flow, pressure, and relief.

topic_12

Gammas (topic weights) for topic 12 which describes corrosion-related damages.

topic_13

Gammas (topic weights) for topic 13 which includes gaskets and related terms.

topic_14

Gammas (topic weights) for topic 14 which is related to the reporting of spills.

topic_15

Gammas (topic weights) for topic 15 which describes the personnels onsite response.

topic_16

Gammas (topic weights) for topic 16 which includes terms related to valves.

topic_17

Gammas (topic weights) for topic 17 which contains terms related to a leak and cleanup.

topic_18

Gammas (topic weights) for topic 18 which describes the contamination of the environment that resulted from a spill.

topic_19

Gammas (topic weights) for topic 19 which is related to the release of oil.

topic_20

Gammas (topic weights) for topic 20 which contains words related to a release of crude oil.

topic_21

Gammas (topic weights) for topic 21 which is related to fire and emergencies.

topic_22

Gammas (topic weights) for topic 22 which is related to storage tanks.

topic_23

Gammas (topic weights) for topic 23 which describes cracks and other kinds of failure.


julianbarg/oildata documentation built on Nov. 27, 2020, 4 p.m.