_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_filings
Annual time series of filings (aka submissions) from gas distribution system operators.
- 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
- Primary key:
report_id, report_date, operator_id_phmsa
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.
Additional Details
This table contains information about the filer and filing type. This includes information about who filed but also whether this was an original filing or a correction.
Columns
Report number of the PHMSA Gas utility submission.
PHMSA unique operator ID. A value of zero represents an unknown operator ID.
Date reported.
Date on which the filing was submitted.
Initial date when filing was originally submitted.
Date when a correction filing was submitted.
Type of report submitted, either Initial or Supplemental.
When the data source was last updated.
PHMSA form revision identifier.
Name of representative who filed report.
Title of representative who filed report.
Phone number of representative who filed report.
Fax number of representative who filed report.
Email address of representative who filed report.
_core_phmsagas__yearly_distribution_leaks
Annual time series of total and hazardous leaks eliminated or repaired during the report year.
- 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 C)
- 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, leak_severity and leak_source. 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.
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.
Whether or not the leak described in this record are all leaks or hazardous leaks.
The cause of the leaks.
The number of mains distribution pipeline.
Number of services in system at end of year.
_core_phmsagas__yearly_distribution_misc
Annual time series of miscellaneous distribution information.
- 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 & C)
- Primary key:
This table has no primary key. We expect the primary key for this table should be report_id, operator_id_phmsa, and operating_state. 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.
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.
State that the distribution utility is reporting for. Prior to 2004, this may be a list of states.
The number of known system leaks at the end of the report year scheduled for repair.
The number of known leaks on main at the end of the report year scheduled for repair.
The total number of hazardous leaks caused by a mechanical joint failure.
Total number of leaks repaired, eliminated, or scheduled for repair on federal land during the reporting year.
The average system service length in feet.
Estimated number of services with Excess Flow Valve in the system at end of reported year related to natural gas distribution.
Total number of services with Excess Flow Valve installed during reported year related to natural gas distribution.
Estimated number of services with manual service line shut-off valves installed in the system at end of report year related to natural gas distribution.
Total number of manual service line shut-off valves installed during reported year related to natural gas distribution.
Unaccounted for gas as a fraction of total consumption for the 12 months ending June 30 of the reporting year. Calculated as follows: Take the sum of: (purchased gas + produced gas) minus (customer use + company use + appropriate adjustments). Then divide by the sum of (customer use + company use + appropriate adjustments). Prior to 2017, this field was calculated with a different deonominator (purchased gas + produced gas). The time period between 2010-2017 having this different calculation method ensured that there was no records that had a negative fraction. For all the other reporting years there are known and expected negative values in this column.
Number of Excavation Tickets received by the operator during the year, (i.e., receipt of information by the operator from the notification center).
core_phmsagas__yearly_distribution_operators
Annual time series of distribution operator information.
- Most-recent data:
2024
- 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 A)
- Primary key:
report_id, report_date, operator_id_phmsa
Additional Details
This table contains operator-level information including office and headquarter location.
Columns
Report number of the PHMSA Gas utility submission.
Date reported.
PHMSA unique operator ID. A value of zero represents an unknown operator ID.
PHMSA operator name.
Street address of an operator's office.
City where an operator's office is located.
County where an operator's office is located.
Zipcode where an operator's office is located.
State where an operator's office is located.
Street address for an operator's headquarters.
City where an operator's headquarters are located.
County where an operator's headquarters are located.
State where an operator's headquarters are located.
Zipcode where an operator's headquarters are located.
Any additional information which will assist in clarifying or classifying the reported data.
_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.
_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.
_core_phmsagas__yearly_distribution_excavation_damages
Annual time series of excavation damages from various sources.
- 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 D - Excavation Damage)
- Primary key:
report_id, damage_type, damage_sub_type
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.
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.
A high level category of excavation damage causes.
A sub-category of damage_type of excavation damage causes.
Number of instances of excavation damage.