_core_phmsagas__yearly_distribution_by_material
Annual time series of miles of mains and the number of services in operation at the end of the year by material for each gas distribution operator.
- 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 1 - General)
- Primary key:
This table has no primary key. We expect the primary key for this table should be report_id, operator_id_phmsa, operating_state and material. However, there are nulls in the operating_state across several years of reporting.
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.
The categories of material types have changed slightly over the years (ex: cast and wrought iron were broken up in two categories before 1984).
Beginning in 2004, companies file one report per state. The operating_state column has not been normalized and may contain more than one state in earlier years of data.
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 material of the gas distribution pipe. The categories of material types have changed slightly over the years (ex: cast and wrought iron were broken up in two categories before 1984).
The miles of mains distribution pipeline.
Number of services in system at end of year.
_core_phmsagas__yearly_distribution_by_material_and_size
Annual time series of miles of mains and the number of services in operation at the end of the year by material and size of pipe.
- 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 3)
- Primary key:
This table has no primary key. We expect the primary key for this table should be report_id, operator_id_phmsa, operating_state, main_size and material. There are nulls in the operating_state across several years of reporting.
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.
The size ranges in main_size have changed slightly over the years (ex: before 1984 they reported 0.5_in_or_less whereas after they reported 1_in_or_less)
The categories of material types have changed slightly over the years (ex: cast and wrought iron were broken up in two categories before 1984).
Beginning in 2004, companies file one report per state. The operating_state column has not been normalized and may contain more than one state in earlier years of data.
Columns
Date reported.
Report number of the PHMSA Gas utility submission.
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.
Size range of mains. The size ranges have changed slightly over the years (ex: before 1984 they reported 0.5_in_or_less whereas after they reported 1_in_or_less).
The material of the gas distribution pipe. The categories of material types have changed slightly over the years (ex: cast and wrought iron were broken up in two categories before 1984).
The miles of mains distribution pipeline.
Number of services in system at end of year.
A free-form text field containing notes about the other material type. This column should only contain values in it for rows with other as the material type listed.