core_phmsagas__yearly_distribution_by_install_decade
Return to SearchAnnual 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:
2025
- Processing:
Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.
- 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, commodity, install_decade
Additional Details
PHMSA indicated that some operators may have reported negative mains_miles or services values to reconcile totals across Parts B1 and B4, but that negative values are not valid. These negative values have been replaced with zero.
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.
Two-letter postal abbreviation for the state or territory the distribution utility is reporting for.
The decade the distribution pipeline was installed.
The miles of mains distribution pipeline.
Number of services in system at end of year.