_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).