_core_phmsagas__yearly_distribution_by_install_decade
Annual time series of miles of mains and the number of services in operation at the end of the year by install decade.
- Most-recent data:
2024
- Processing:
Data has been cleaned but not tidied/normalized. Published only temporarily and may be removed without notice.
- Source:
Pipelines and Hazardous Materials Safety Administration (PHMSA) Annual Natural Gas Report (Part B - System Description / Section 4)
- Primary key:
report_id, report_date, operator_id_phmsa, operating_state, install_decade
Usage Warnings
This table has been concatenated across all years and re-organized into a logical structure, but the data has not been fully cleaned. Except some inconsistent units, data types and values over the years of reported data. Once fully cleaned, this table will be deprecated and replaced with a core table.
Some columns contain subtotals; use caution when choosing columns to aggregate.
Additional Details
The records with an install decade of total_decade are a total - beware of aggregating these values.
Columns
Report number of the PHMSA Gas utility submission.
Date reported.
PHMSA unique operator ID. A value of zero represents an unknown operator ID.
The type of gas delivered by the distribution pipeline.
State that the distribution utility is reporting for. Prior to 2004, this may be a list of states.
The decade the distribution pipeline was installed.
The miles of mains distribution pipeline.
Number of services in system at end of year.