core_pudl__entity_utilities_pudl

package: pudl

Entity table containing static information about PUDL-assigned utility IDs.

Processing:

Data has been cleaned and organized into well-modeled tables that serve as building blocks for downstream wide tables and analyses.

Source:

The Public Utility Data Liberation (PUDL) Project

Primary key:

utility_id_pudl

Additional Details

These IDs are manually generated each year when new FERC and EIA reporting is integrated, and any newly found utilities are added to the list with a new ID. Each ID maps to a power plant owning or operating entity which is reported in at least one FERC or EIA data set. This table is read in from a spreadsheet stored in the PUDL repository: src/pudl/package_data/glue/pudl_id_mapping.xlsx

Columns
utility_id_pudl

A manually assigned PUDL utility ID. May not be stable over time.

utility_name_pudl

Utility name, chosen arbitrarily from the several possible utility names available in the utility matching process. Included for human readability only.