pipelines: Annual data on pipelines in the US from 2004 to 2019

Description Usage Format Source Examples

Description

Annual Report Data from Gas Distribution, Gas Gathering, Gas Transmission, Hazardous Liquids, Liquefied Natural Gas (LNG), and Underground Natural Gas Storage (UNGS) Facility Operators. Operators are required to submit annual reports to PHMSA. Reports include information such as total pipeline mileage, facilities, commodities transported, mileage by material, and installation dates. Organizations aggregated according to the M&A dataset in this package.

Usage

1

Format

A data frame with columns:

year

Report year.

commodity

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

ID

Unique operator ID.

name

Name of the pipelines operator at the time of the report year.

state

Headquarter state.

on_offshore

Observation describes offshore or onshroe pipelines.

hca

Miles of pipelines in High Consequences Areas.

miles

Total number of pipeline miles.

volume_crude

Volume of crude oil transported (in barrel-miles).

volume_hvl

Volume of highly volatile liquid transported (in barrel-miles).

volume_rpp

Volume of refined petroleum products transported (in barrel-miles). Before 2010, this value also contains the amount of fge transported, which is only separated out from 2010 on. The actual amount of fge transported is negligable though.

volume_other

Volume of substance other than crude, rpp, and hvl transported (in barrel-miles).

estimate_volume_crude

Estimated volume of crude oil transported (in barrel-miles). Contains the actual value transported where available from volume_crude column. Missing values are approximated as total volume multiplied by the share of offshore pipelines/onshore in the pipeline network.

estimate_volume_hvl

Estimated volume of highly volatile liquid transported (in barrel-miles). Contains the actual value transported where available from volume_hvl column. Missing values are approximated as total volume multiplied by the share of offshore/onshore pipelines in the pipeline network.

estimate_volume_rpp

Estimated volume of refined petroleum products transported (in barrel-miles). Contains the actual value transported where available from volume_rpp column. Missing values are approximated as total volume multiplied by the share of offshore/onshore pipelines in the pipeline network.

estimate_volume_other

Estimated volume of commodity other than crude, rpp, and hvl transported (in barrel-miles). Contains the actual value transported where available from volume_other column. Missing values are approximated as total volume multiplied by the share of offshore/onshore pipelines in the pipeline network.

volume_all

Combined volume of all commodities transported (in barrel-miles).

estimate_volume_all

Estimated combined volume of all commodities transported (in barrel-miles). Contains the actual value transported where available from the volume_all column. Missing values are approximated as total volume multiplied by the share of offshore/onshore pipelines in the pipeline network.

volume_specific

Volume transported of the commodity that the pipeline is designated for (in barrel-miles).

estimate_volume_specific

Estimated volume transported of the commodity that the pipeline is designated for (in barrel-miles). Contains the actual value transported where available from the volume_specific column. Missing values are approximated as total volume multiplied by the share of offshore/onshore pipelines in the pipeline network.

incidents

Total number of incidents (both significant and non-significant).

significant_incidents

Count of significant incidents. Obtained from the incident datasets.

serious_incidents

Count of serious incidents. Obtained from the incident datasets.

incidents_volume

Total number of barrels spilled across all incidents.

recovered

The volume of commodity recovered after all incidents (in barrels).

net_loss_volume

Sum of volume of commodity unintentionally released (in barrels) minus volume recovered.

significant_incidents_volume

Total number of barrels spilled across all significant incidents.

incidents_cost

Combined cost of all incidents (in 1984 dollars).

significant_incidents_cost

Combined cost of all significant incidents (in 1984 dollars).

ma_year

The first year of an M&A, or selloff of an operators in a group.

Source

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

Examples

1
2
3
4
## Not run: 
 pipelines

## End(Not run)

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