core_pudl__entity_utilities_pudl
Return to SearchEntity 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
A manually assigned PUDL utility ID. May not be stable over time.
Utility name, chosen arbitrarily from the several possible utility names available in the utility matching process. Included for human readability only.