pudl.metadata.dfs

Static database tables.

Attributes

FERC_ACCOUNTS

FERC electric plant account IDs with associated row numbers and descriptions.

BALANCING_AUTHORITY_SUBREGIONS_EIA

EIA_SECTOR_AGGREGATE_ASSN

Association table describing the many-to-many relationships between plant sectors and

EIA_FUEL_AGGREGATE_ASSN

Association table describing the many-to-many relationships between fuel types and

POLITICAL_SUBDIVISIONS

Static attributes of sub-national political jurisdictions.

Module Contents

pudl.metadata.dfs.FERC_ACCOUNTS: pandas.DataFrame[source]

FERC electric plant account IDs with associated row numbers and descriptions. From FERC Form 1 pages 204-207, Electric Plant in Service. Descriptions from: https://www.law.cornell.edu/cfr/text/18/part-101

pudl.metadata.dfs.BALANCING_AUTHORITY_SUBREGIONS_EIA: pandas.DataFrame[source]
pudl.metadata.dfs.EIA_SECTOR_AGGREGATE_ASSN[source]

Association table describing the many-to-many relationships between plant sectors and various aggregates in core_eia__yearly_fuel_receipts_costs_aggs.

pudl.metadata.dfs.EIA_FUEL_AGGREGATE_ASSN[source]

Association table describing the many-to-many relationships between fuel types and various aggregates in core_eia__yearly_fuel_receipts_costs_aggs.

Missing from these aggregates are all the “other” categories of gases: OG, BFG, SGP, SC, PG. But those gases combine for about 0.2% of total MMBTU of reported fuel receipts.

pudl.metadata.dfs.POLITICAL_SUBDIVISIONS: pandas.DataFrame[source]

Static attributes of sub-national political jurisdictions.

Note AK and PR have incomplete EPA CEMS data, and so are excluded from is_epacems_state: See https://github.com/catalyst-cooperative/pudl/issues/1264