incidents_2002: Annual data on oil spills in the US from 2004 to 2010

In julianbarg/oildata: Access data on the American oil pipeline system and oil spills

Description

Distribution, Transmission & Gathering, LNG, and Liquid Accident and Incident Data.

Usage

incidents_2002

Format

A data frame with columns:

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.

DOR

report_type

ID

Unique operator ID.

OWNER_OPERATOR_ID

name

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

OPSTREET

OPCITY

OPCOUNTY

OPSTATE

OPZIP

IHOUR

IDATE

year

Year accident occurred, derived from accident date.

lat

Accident location latitude.

long

Accident location longitude.

ACCITY

ACCOUNTY

ACSTATE

ACZIP

MPVST

SURVNO

TELRN

TELDT

PPPRP

EMRPRP

ENVPRP

OPCPRP

OPCPRPO

PRODPRP

OOPRP

OOPPRP

OOPPRPO

cost

Total costs (in US$).

cost_1984

Converted Property Damage to Year 1984 dollars.

SPILLED

COMM

commodity

The type of commodity being spilled (Crude, HVL, etc.).

SPUNIT_TEXT

LOSS

RECOV

MAP_CAUSE

Cause, coded by PHMSA.

LINE_SEG

IFED

INTER

on_offshore

Whether the oil spill occured onshore or offshore.

OFFAREA

BNUMB

OFFST

OCS

OPPROP

PIPEROW

HCA

HCADESC

system

Part of system involved in accident.

SYSPRTO

item

Failure occurred on item.

FAIL_OCO

installation_year

Year the component that failed was installed.

INC_PRS

MOP

OPRS

LRTYPE_TEXT

LRTYPEO

LEAK_TEXT

PUNC_DIAM

RUPTURE_TEXT

RUPLN

PROPLN

UBLKVM

UBLKVA

UBLKVR

UBLKVC

DBLKVM

DBLKVA

DBLKVR

DBLKVC

SEGISO

VLVDIST

SEGCONF

INLINE_TEXT

DRHRMF

DRHRMFY

DRLRMF

DRLRMFY

DRUT

DRUTY

DRGEO

DRGEOY

DRCAL

DRCALY

DRCRK

DRCRKY

DRHARD

DRHARDY

DROTH

DROTHY

NPS

WALLTHK

SPEC

SMYS

SEAM

VALVE

MANU

manufacture_year

Year failed item was manufactured.

LOCLK_TEXT

LOCLKO

DEPTH_COV

fatalities

Total number of fatalities.

EFAT

NFAT

GPFAT

injuries

Total number of injured

EINJ

NINJ

GPINJ

SHUTDOWN

SHUTDAY

SHUTHR

SHUTMIN

fire

Gas ignite (TRUE/FALSE).

explosion

Explosion (TRUE/FALSE).

EVAC

EVACNO

EVAC_REASON_TEXT

STHH

STMN

FISH

BIRDS

TERRESTRIAL

SOIL

SOIL_YRD

IMPACT

REMEDIAL

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.

water_contamination

Water contaminated?

AMT_IN_WATER

OCEAN

SURFACE

GROUNDW

DRINK

DRINKSRC_TEXT

COMP_BASED

DETECTED_TEXT

DETECTEDO

DURLEAK_DAY

DURLEAK_HR

CAUSE_DETAILS

PIPE_COAT_TEXT

VIS_EXAM_TEXT

VIS_EXAMO

COR_CAUSE_TEXT

COR_CAUSEO

PROT

CPYR

PREV_DAM

PREV_DAM_YR

PREV_DAM_MO

PREV_DAM_UK

EARTH_MOVE_TEXT

EARTH_MOVEO

FLOODS_TEXT

FLOODSO

TEMPER_TEXT

TEMPERO

THIRD_PARTY_GRP_TEXT

THIRD_PARTY_TYPE_TEXT

THIRD_PARTY_TYPEO

EXCAV_TYPE_TEXT

EXCAV_ON

EXCAV_LAST_CONTACT

NOTIF

NOTIF_DATE

NOTIF_RCVD_TEXT

MARKED

TEMP_MARK_TEXT

PERM_MARK

ACC_MARK_TEXT

MKD_IN_TIME

FIRE_EXPLO_TEXT

PIPE_BODY_TEXT

PIPE_BODYO

COMPONENT_TEXT

COMPONENTO

JOINT_TEXT

JOINTO

BUTT_TEXT

BUTTO

FILLET_TEXT

FILLETO

PIPE_SEAM_TEXT

PIPE_SEAMO

FAIL_TYPE_TEXT

CONS_DEF_TEXT

PIPE_DAMAGE

PRS_TEST

TEST_YR

TEST_MO

TEST_DAY

TEST_MED_TEXT

TEST_MEDO

TEST_TP

TEST_PRS

MALFUNC_TEXT

MALFUNCO

THREADS_TEXT

THREADSO

SEAL_TEXT

SEALO

IO_TYPE_TEXT

IO_TYPEO

IO_DRUG

IO_ALCO

MISC

UNKNOWN_TEXT

PNAME

PHONE

PEMAIL

PPPRPCURRENT

EMRPRPCURRENT

ENVPRPCURRENT

OPCPRPCURRENT

PRODPRPCURRENT

OOPRPCURRENT

OOPPRPCURRENT

TOTAL_COST_CURRENT

cause

Cause of the incident.

subcause

Subcause of the incident, coded by PHMSA.

SPILL_TYPE_CATEGORY

narrative

Written description of the incident.

volume

Volume of oil spilled (in barrels).

recovered

Estimated volume of commodity recovered (in barrels).

date

Date of the spill.

state

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

net_loss

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

Details

Title 49 of the Code of Federal Regulations (49 CFR Parts 191, 195) requires pipeline operators to submit incident reports within 30 days of a pipeline incident or accident. The CFR defines accidents and incidents, as well as criteria for submitting reports to the Office of Pipeline Safety. The following kinds of information are collected: * Key report information * In-depth location information * Facility information * Operating information * Drug and Alcohol information * Cause of the accident/incident Specific information includes the time and location of the incident(s), number of any injuries and/ or fatalities, commodity spilled/gas released, causes of failure and evacuation procedures. The reports are used for identifying long- and short-term trends at the national, state and operator-specific levels. The frequency, causes, and consequences of the incidents provide insight into the safety metrics currently used by PHMSA, state partners, and other pipeline safety stakeholders, including the pipeline industry and general public. PHMSA also uses the data for inspection planning and risk assessment.

Source

United States Department of Transportation (DOT) Pipeline and Hazardous Materials Safety Administration (PHMSA). https://www.phmsa.dot.gov/data-and-statistics/pipeline/distribution-transmission-gathering-lng-and-liquid-accident-and-incident-data (right side bar).

Examples

## Not run: 
 incidents_2002

## End(Not run)

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