PUDL Data Dictionary#
The following data tables have been cleaned and transformed by our ETL process. Please note that tables beginning with “denorm” are temporary tables whose names and metadata will shortly change, as we migrate new tables into our database.
advanced_metering_infrastructure_eia861#
The data contain number of meters from automated meter readings (AMR) and advanced metering infrastructure (AMI) by state, sector, and balancing authority. The energy served (in megawatthours) for AMI systems is provided. Form EIA-861 respondents also report the number of standard meters (non AMR/AMI) in their system. Historical Changes: We started collecting the number of standard meters in 2013. The monthly survey collected these data from January 2011 to January 2017. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
advanced_metering_infrastructure |
integer |
N/A |
automated_meter_reading |
integer |
N/A |
balancing_authority_code_eia |
string |
EIA short code identifying a balancing authority. |
customer_class |
string |
High level categorization of customer type. |
daily_digital_access_customers |
integer |
N/A |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
direct_load_control_customers |
integer |
N/A |
energy_served_ami_mwh |
number |
N/A |
entity_type |
string |
Entity type of principal owner. |
home_area_network |
integer |
N/A |
non_amr_ami |
integer |
N/A |
report_date |
date |
Date reported. |
short_form |
boolean |
N/A |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
averaging_periods_eia#
A coding table describing the averaging period specified by emissions statutes and regulation for in the EIA-860. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
balance_sheet_assets_ferc1#
Comparative Balance Sheet (Assets and Other Debits). Schedule 110. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
asset_type |
string |
Type of asset being reported to the balance_sheet_assets_ferc1 table. |
balance |
string |
Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy. |
ending_balance |
number |
Account balance at end of year. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
starting_balance |
number |
Account balance at beginning of year. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
balance_sheet_liabilities_ferc1#
Comparative balance sheet (liabilities and other credits) Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balance |
string |
Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy. |
ending_balance |
number |
Account balance at end of year. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
liability_type |
string |
Type of liability being reported to the balance_sheet_liabilities_ferc1 table. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
starting_balance |
number |
Account balance at beginning of year. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
boiler_cooling_assn_eia860#
A table that links EIA boiler IDs to EIA cooling system IDs. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
boiler_id |
string |
Alphanumeric boiler ID. |
cooling_id_eia |
string |
The cooling system identification number reported to EIA. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
report_date |
date |
Date reported. |
boiler_emissions_control_equipment_assn_eia860#
A table that links EIA boiler IDs to emissions control IDs for NOx, SO2, mercury, and particulate monitoring. The relationship between the IDs is sometimes many to many. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
boiler_id |
string |
Alphanumeric boiler ID. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
emission_control_id_eia |
string |
The emission control ID used to collect so2, nox, particulate, and mercury emissions data. This column should be used in conjunction with emissions_control_type as it's not guaranteed to be unique. |
emission_control_id_type |
string |
The type of emissions control id: so2, nox, particulate, or mercury. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
report_date |
date |
Date reported. |
boiler_fuel_eia923#
EIA-923 Monthly Boiler Fuel Consumption and Emissions, from EIA-923 Schedule 3.
Reports the quantity of each type of fuel consumed by each boiler on a monthly basis, as well as the sulfur and ash content of those fuels. Fuel quantity is reported in standard EIA fuel units (tons, barrels, Mcf). Heat content per unit of fuel is also reported, making this table useful for calculating the thermal efficiency (heat rate) of various generation units.
This table provides better coverage of the entire fleet of generators than the
generation_fuel_eia923
table, but the fuel consumption reported here is
not directly
associated with a generator. This complicates the heat rate calculation, since
the
associations between individual boilers and generators are incomplete and can
be
complex.
Note that a small number of respondents only report annual fuel consumption, and all of it is reported in December. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
ash_content_pct |
number |
Ash content percentage by weight to the nearest 0.1 percent. |
boiler_id |
string |
Alphanumeric boiler ID. |
energy_source_code |
string |
A 2-3 letter code indicating the energy source (e.g. fuel type) associated with the record. |
fuel_consumed_units |
number |
Consumption of the fuel type in physical unit. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_mmbtu_per_unit |
number |
Heat content of the fuel in millions of Btus per physical unit. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
report_date |
date |
Date reported. |
sulfur_content_pct |
number |
Sulfur content percentage by weight to the nearest 0.01 percent. |
boiler_generator_assn_eia860#
Associations between boilers and generators as reported in EIA-860 Schedule 6, Part A. Augmented with various heuristics within PUDL. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
bga_source |
string |
The source from where the unit_id_pudl is compiled. The unit_id_pudl comes directly from EIA 860, or string association (which looks at all the boilers and generators that are not associated with a unit and tries to find a matching string in the respective collection of boilers or generator), or from a unit connection (where the unit_id_eia is employed to find additional boiler generator connections). |
boiler_generator_assn_type_code |
string |
Indicates whether boiler associations with generator during the year were actual or theoretical. Only available before 2013. |
boiler_id |
string |
Alphanumeric boiler ID. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
report_date |
date |
Date reported. |
steam_plant_type_code |
integer |
Code that describes types of steam plants from EIA 860. See steam_plant_types_eia table for more details. |
unit_id_eia |
string |
EIA-assigned unit identification code. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
boiler_generator_assn_types_eia#
A coding table describing different types of boiler-generator associations in the EIA-860. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
boiler_stack_flue_assn_eia860#
A table that links EIA boiler IDs to EIA stack and/or flue system IDs. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
boiler_id |
string |
Alphanumeric boiler ID. |
flue_id_eia |
string |
The flue identification value reported to EIA. The flue is a duct, pipe, or opening that transports exhast gases through the stack. This field was reported in conjunction with stack_id_eia until 2013 when stack_flue_id_eia took their place. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
report_date |
date |
Date reported. |
stack_flue_id_eia |
string |
The stack or flue identification value reported to EIA. This denotes the place where emissions from the combusion process are released into the atmosphere. Prior to 2013, this was reported as stack_id_eia and flue_id_eia. |
stack_flue_id_pudl |
string |
A stack and/or flue identification value created by PUDL for use as part of the primary key for the stack flue equipment and boiler association tables. For 2013 and onward, this value is equal to the value for stack_flue_id_eia. Prior to 2013, this value is equal to the value for stack_id_eia and the value for flue_id_eia seperated by an underscore or just the stack_flue_eia in cases where flue_id_eia is NA. |
stack_id_eia |
string |
The stack identification value reported to EIA. Stacks or chimneys are the place where emissions from the combustion process are released into the atmosphere. This field was reported in conjunction with flue_id_eia until 2013 when stack_flue_id_eia took their place. |
boiler_status_eia#
A coding table describing different types of boiler status in the EIA-860. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
boiler_types_eia#
A coding table describing different types of boiler regulatory types in the EIA-860. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
boilers_eia860#
Annually varying boiler attributes, compiled from across all EIA-860 data. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
air_flow_100pct_load_cubic_feet_per_minute |
number |
Total air flow including excess air at 100 percent load, reported at standard temperature and pressure (i.e. 68 F and one atmosphere pressure). |
boiler_fuel_code_1 |
string |
The code representing the most predominant type of energy that fuels the boiler. |
boiler_fuel_code_2 |
string |
The code representing the second most predominant type of energy that fuels the boiler. |
boiler_fuel_code_3 |
string |
The code representing the third most predominant type of energy that fuels the boiler. |
boiler_fuel_code_4 |
string |
The code representing the fourth most predominant type of energy that fuels the boiler. |
boiler_id |
string |
Alphanumeric boiler ID. |
boiler_operating_date |
date |
Date the boiler began or is planned to begin commercial operation. |
boiler_retirement_date |
date |
Date of the scheduled or effected retirement of the boiler. |
boiler_status |
string |
EIA short code identifying boiler operational status. |
boiler_type |
string |
EIA short code indicating the standards under which the boiler is operating as described in the U.S. EPA regulation under 40 CFR. |
compliance_year_mercury |
integer |
Year boiler was or is expected to be in compliance with federal, state and/or local regulations for mercury emissions. |
compliance_year_nox |
integer |
Year boiler was or is expected to be in compliance with federal, state and/or local regulations for nitrogen oxide emissions. |
compliance_year_particulate |
integer |
Year boiler was or is expected to be in compliance with federal, state and/or local regulations for particulate matter emissions. |
compliance_year_so2 |
integer |
Year boiler was or is expected to be in compliance with federal, state and/or local regulations for sulfur dioxide emissions. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
efficiency_100pct_load |
number |
Boiler efficiency percentage when burning at 100 percent load to the nearest 0.1 percent. |
efficiency_50pct_load |
number |
Boiler efficiency percentage when burning at 50 percent load to the nearest 0.1 percent. |
firing_rate_using_coal_tons_per_hour |
number |
Design firing rate at maximum continuous steam flow for coal to the nearest 0.1 ton per hour. |
firing_rate_using_gas_mcf_per_hour |
number |
Design firing rate at maximum continuous steam flow for gas to the nearest 0.1 cubic feet per hour. |
firing_rate_using_oil_bbls_per_hour |
number |
Design firing rate at maximum continuous steam flow for pet coke to the nearest 0.1 barrels per hour. |
firing_rate_using_other_fuels |
number |
Design firing rate at maximum continuous steam flow for energy sources other than coal, petroleum, or natural gas. |
firing_type_1 |
string |
EIA short code indicating the type of firing used by this boiler. |
firing_type_2 |
string |
EIA short code indicating the type of firing used by this boiler. |
firing_type_3 |
string |
EIA short code indicating the type of firing used by this boiler. |
fly_ash_reinjection |
boolean |
Indicates whether the boiler is capable of re-injecting fly ash. |
hrsg |
boolean |
indicates if the boiler is a heat recovery steam generator (HRSG). |
max_steam_flow_1000_lbs_per_hour |
number |
Maximum continuous steam flow at 100 percent load. |
mercury_control_existing_strategy_1 |
string |
Existing strategy to comply with the most stringent mercury regulation. |
mercury_control_existing_strategy_2 |
string |
Existing strategy to comply with the most stringent mercury regulation. |
mercury_control_existing_strategy_3 |
string |
Existing strategy to comply with the most stringent mercury regulation. |
mercury_control_existing_strategy_4 |
string |
Existing strategy to comply with the most stringent mercury regulation. |
mercury_control_existing_strategy_5 |
string |
Existing strategy to comply with the most stringent mercury regulation. |
mercury_control_existing_strategy_6 |
string |
Existing strategy to comply with the most stringent mercury regulation. |
mercury_control_proposed_strategy_1 |
string |
Proposed strategy to comply with the most stringent mercury regulation. |
mercury_control_proposed_strategy_2 |
string |
Proposed strategy to comply with the most stringent mercury regulation. |
mercury_control_proposed_strategy_3 |
string |
Proposed strategy to comply with the most stringent mercury regulation. |
new_source_review |
boolean |
Indicates whether the boiler is subject to New Source Review requirements. |
new_source_review_date |
date |
Month of issued New Source Review permit. |
new_source_review_permit |
string |
New Source Review permit number. |
nox_control_existing_caaa_compliance_strategy_1 |
string |
Existing strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
nox_control_existing_caaa_compliance_strategy_2 |
string |
Existing strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
nox_control_existing_caaa_compliance_strategy_3 |
string |
Existing strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
nox_control_existing_strategy_1 |
string |
Existing strategy to comply with the most stringent nitrogen oxide regulation. |
nox_control_existing_strategy_2 |
string |
Existing strategy to comply with the most stringent nitrogen oxide regulation. |
nox_control_existing_strategy_3 |
string |
Existing strategy to comply with the most stringent nitrogen oxide regulation. |
nox_control_manufacturer |
string |
Name of nitrogen oxide control manufacturer. |
nox_control_manufacturer_code |
string |
Code indicating the nitrogen oxide control burner manufacturer. |
nox_control_out_of_compliance_strategy_1 |
string |
If boiler is not in compliance with nitrogen oxide regulations, strategy for compliance. |
nox_control_out_of_compliance_strategy_2 |
string |
If boiler is not in compliance with nitrogen oxide regulations, strategy for compliance. |
nox_control_out_of_compliance_strategy_3 |
string |
If boiler is not in compliance with nitrogen oxide regulations, strategy for compliance. |
nox_control_planned_caaa_compliance_strategy_1 |
string |
Planned strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
nox_control_planned_caaa_compliance_strategy_2 |
string |
Planned strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
nox_control_planned_caaa_compliance_strategy_3 |
string |
Planned strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
nox_control_proposed_strategy_1 |
string |
Proposed strategy to comply with the most stringent nitrogen oxide regulation. |
nox_control_proposed_strategy_2 |
string |
Proposed strategy to comply with the most stringent nitrogen oxide regulation. |
nox_control_proposed_strategy_3 |
string |
Proposed strategy to comply with the most stringent nitrogen oxide regulation. |
nox_control_status_code |
string |
Nitrogen oxide control status code. |
particulate_control_out_of_compliance_strategy_1 |
string |
If boiler is not in compliance with particulate matter regulations, strategy for compliance. |
particulate_control_out_of_compliance_strategy_2 |
string |
If boiler is not in compliance with particulate matter regulations, strategy for compliance. |
particulate_control_out_of_compliance_strategy_3 |
string |
If boiler is not in compliance with particulate matter regulations, strategy for compliance. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
regulation_mercury |
string |
Most stringent type of statute or regulation code under which the boiler is operating for mercury control standards. |
regulation_nox |
string |
EIA short code for most stringent type of statute or regulation code under which the boiler is operating for nitrogen oxide control standards. |
regulation_particulate |
string |
EIA short code for most stringent type of statute or regulation code under which the boiler is operating for particulate matter control standards. |
regulation_so2 |
string |
EIA short code for most stringent type of statute or regulation code under which the boiler is operating for sulfur dioxide control standards. |
report_date |
date |
Date reported. |
so2_control_existing_caaa_compliance_strategy_1 |
string |
Existing strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
so2_control_existing_caaa_compliance_strategy_2 |
string |
Existing strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
so2_control_existing_caaa_compliance_strategy_3 |
string |
Existing strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
so2_control_existing_strategy_1 |
string |
Existing strategy to comply with the most stringent sulfur dioxide regulation. |
so2_control_existing_strategy_2 |
string |
Existing strategy to comply with the most stringent sulfur dioxide regulation. |
so2_control_existing_strategy_3 |
string |
Existing strategy to comply with the most stringent sulfur dioxide regulation. |
so2_control_out_of_compliance_strategy_1 |
string |
If boiler is not in compliance with sulfur dioxide regulations, strategy for compliance. |
so2_control_out_of_compliance_strategy_2 |
string |
If boiler is not in compliance with sulfur dioxide regulations, strategy for compliance. |
so2_control_out_of_compliance_strategy_3 |
string |
If boiler is not in compliance with sulfur dioxide regulations, strategy for compliance. |
so2_control_planned_caaa_compliance_strategy_1 |
string |
Planned strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
so2_control_planned_caaa_compliance_strategy_2 |
string |
Planned strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
so2_control_planned_caaa_compliance_strategy_3 |
string |
Planned strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
so2_control_proposed_strategy_1 |
string |
Proposed strategy to comply with the most stringent sulfur dioxide regulation. |
so2_control_proposed_strategy_2 |
string |
Proposed strategy to comply with the most stringent sulfur dioxide regulation. |
so2_control_proposed_strategy_3 |
string |
Proposed strategy to comply with the most stringent sulfur dioxide regulation. |
standard_nox_rate |
number |
Numeric value for the unit of measurement specified for nitrogen oxide. |
standard_particulate_rate |
number |
Numeric value for the unit of measurement specified for particulate matter. |
standard_so2_percent_scrubbed |
number |
The percent of sulfur dioxide to be scrubbed specified by the most stringent sulfur dioxide regulation. |
standard_so2_rate |
number |
Numeric value for the unit of measurement specified for sulfur dioxide. |
turndown_ratio |
number |
The turndown ratio for the boiler. |
unit_nox |
string |
Numeric value for the unit of measurement specified for nitrogen oxide. |
unit_particulate |
string |
Numeric value for the unit of measurement specified for particulate matter. |
unit_so2 |
string |
Numeric value for the unit of measurement specified for sulfur dioxide. |
waste_heat_input_mmbtu_per_hour |
number |
Design waste-heat input rate at maximum continuous steam flow where a waste-heat boiler is a boiler that receives all or a substantial portion of its energy input from the noncumbustible exhaust gases of a separate fuel-burning process (MMBtu per hour). |
wet_dry_bottom |
string |
Wet or Dry Bottom where Wet Bottom is defined as slag tanks that are installed at furnace throat to contain and remove molten ash from the furnace, and Dry Bottom is defined as having no slag tanks at furnace throat area, throat area is clear, and bottom ash drops through throat to bottom ash water hoppers. |
boilers_entity_eia#
Static boiler attributes compiled from the EIA-860 and EIA-923 data. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
boiler_id |
string |
Alphanumeric boiler ID. |
boiler_manufacturer |
string |
Name of boiler manufacturer. |
boiler_manufacturer_code |
string |
EIA short code for boiler manufacturer. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
capacity_factor_by_generator_monthly#
Monthly estimates of generator capacity factor. Capacity factor is calculated based on reported generator capacity and the allocated net generation reported in the generation and generation fuel tables. Note that the values in this table are unfiltered and we expect some of the values are unreasonable and out of bounds.This table should not be used without filtering values to within logical boundaries. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
capacity_factor |
number |
Fraction of potential generation that was actually reported for a plant part. |
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
report_date |
date |
Date reported. |
capacity_factor_by_generator_yearly#
Yearly estimates of generator capacity factor. Capacity factor is calculated based on reported generator capacity and the allocated net generation reported in the generation and generation fuel tables. Note that the values in this table are unfiltered and we expect some of the values are unreasonable and out of bounds.This table should not be used without filtering values to within logical boundaries. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
capacity_factor |
number |
Fraction of potential generation that was actually reported for a plant part. |
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
report_date |
date |
Date reported. |
cash_flow_ferc1#
The structured portion of the FERC1 cash flow table - Schedule 120. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
amount |
number |
Reported amount of dollars. This could be a balance or a change in value. |
amount_type |
string |
Label describing the type of amount being reported. This could be a balance or a change in value. |
balance |
string |
Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
coalmine_eia923#
Attributes of coal mines reporting deliveries in the Fuel Receipts and Costs table, via EIA-923 Schedule 2, Part C.
This table is produced during the transformation of fuel delivery data, in order to produce a better normalized database. The same coalmines report many individual deliveries, and repeating their attributes many times in the fuel receipts and costs table is duplicative. Unfortunately the coalmine attributes do not generally use a controlled vocabulary or well defined IDs and so in practice there are many distinct records in this table that correspond to the same mines in reality.
We have not yet taken the time to rigorously clean this data, but it could be linked with both Mining Safety and Health Administration (MSHA) and USGS data to provide more insight into where coal is coming from, and what the employment and geological context is for those supplies. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
county_id_fips |
string |
County ID from the Federal Information Processing Standard Publication 6-4. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
mine_id_msha |
integer |
MSHA issued mine identifier. |
mine_id_pudl |
integer |
Dynamically assigned PUDL mine identifier. |
mine_name |
string |
Coal mine name. |
mine_type_code |
string |
Type of coal mine. |
state |
string |
Two letter US state abbreviation. |
coalmine_types_eia#
A coding table describing different types of coalmines reported as fuel sources in the EIA-923. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
compiled_geometry_utility_eia861#
County-level spatial data for EIA861 utilities. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
area_km2 |
number |
County area in km2. |
county |
string |
County name. |
county_id_fips |
string |
County ID from the Federal Information Processing Standard Publication 6-4. |
county_name_census |
string |
County name as specified in Census DP1 Data. |
population |
number |
County population, sourced from Census DP1 data. |
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
state_id_fips |
string |
Two digit state FIPS code. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
contract_types_eia#
A coding table describing the various types of fuel supply contracts reported in EIA-923. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
data_maturities#
Level of maturities of data records. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
datasources#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
datasource |
string |
Code identifying a dataset available within PUDL. |
doi |
string |
Unique digitial object identifier of Zenodo archive. |
partitions |
string |
The data parititions used to generate this instance of the database. |
pudl_version |
string |
The version of PUDL used to generate this database. |
demand_hourly_pa_ferc714#
Hourly electricity demand by planning area. FERC Form 714, Part III, Schedule 2a. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
demand_mwh |
number |
N/A |
report_date |
date |
Date reported. |
respondent_id_ferc714 |
integer |
N/A |
timezone |
string |
IANA timezone name |
utc_datetime |
datetime |
N/A |
demand_response_eia861#
The data contain energy demand response programs by state, sector, and balancing authority. We collect data for the number of customers enrolled, energy savings, potential and actual peak savings, and associated costs. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
actual_peak_demand_savings_mw |
number |
N/A |
balancing_authority_code_eia |
string |
EIA short code identifying a balancing authority. |
customer_class |
string |
High level categorization of customer type. |
customer_incentives_cost |
number |
N/A |
customers |
number |
Number of customers. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
energy_savings_mwh |
number |
N/A |
other_costs |
number |
N/A |
potential_peak_demand_savings_mw |
number |
N/A |
report_date |
date |
Date reported. |
short_form |
boolean |
N/A |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
demand_response_water_heater_eia861#
The number of grid connected water heaters enrolled in demand response programs. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balancing_authority_code_eia |
string |
EIA short code identifying a balancing authority. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
water_heater |
integer |
N/A |
demand_side_management_ee_dr_eia861#
The data contain energy efficiency incremental data, energy efficiency annual data, load management incremental data, load management annual data, annual costs, and the customer counts of price response and time response programs by sector. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
annual_indirect_program_cost |
number |
N/A |
annual_total_cost |
number |
N/A |
customer_class |
string |
High level categorization of customer type. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
energy_efficiency_annual_actual_peak_reduction_mw |
number |
N/A |
energy_efficiency_annual_cost |
number |
N/A |
energy_efficiency_annual_effects_mwh |
number |
N/A |
energy_efficiency_annual_incentive_payment |
number |
N/A |
energy_efficiency_incremental_actual_peak_reduction_mw |
number |
N/A |
energy_efficiency_incremental_effects_mwh |
number |
N/A |
load_management_annual_actual_peak_reduction_mw |
number |
N/A |
load_management_annual_cost |
number |
N/A |
load_management_annual_effects_mwh |
number |
N/A |
load_management_annual_incentive_payment |
number |
N/A |
load_management_annual_potential_peak_reduction_mw |
number |
N/A |
load_management_incremental_actual_peak_reduction_mw |
number |
N/A |
load_management_incremental_effects_mwh |
number |
N/A |
load_management_incremental_potential_peak_reduction_mw |
number |
N/A |
nerc_region |
string |
NERC region in which the plant is located |
price_responsiveness_customers |
integer |
N/A |
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
time_responsiveness_customers |
integer |
N/A |
utility_id_eia |
integer |
The EIA Utility Identification number. |
demand_side_management_misc_eia861#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
energy_savings_estimates_independently_verified |
boolean |
N/A |
energy_savings_independently_verified |
boolean |
N/A |
entity_type |
string |
Entity type of principal owner. |
major_program_changes |
boolean |
N/A |
nerc_region |
string |
NERC region in which the plant is located |
price_responsive_programs |
boolean |
N/A |
report_date |
date |
Date reported. |
reported_as_another_company |
string |
N/A |
short_form |
boolean |
N/A |
state |
string |
Two letter US state abbreviation. |
time_responsive_programs |
boolean |
N/A |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
demand_side_management_sales_eia861#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
nerc_region |
string |
NERC region in which the plant is located |
report_date |
date |
Date reported. |
sales_for_resale_mwh |
number |
N/A |
sales_to_ultimate_consumers_mwh |
number |
N/A |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
denorm_balance_sheet_assets_ferc1#
Denormalized table that contains FERC balance sheet asset information. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
asset_type |
string |
Type of asset being reported to the balance_sheet_assets_ferc1 table. |
balance |
string |
Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy. |
ending_balance |
number |
Account balance at end of year. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
starting_balance |
number |
Account balance at beginning of year. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
denorm_balance_sheet_liabilities_ferc1#
Denormalized table that contains FERC balance sheet liability information. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balance |
string |
Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy. |
ending_balance |
number |
Account balance at end of year. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
liability_type |
string |
Type of liability being reported to the balance_sheet_liabilities_ferc1 table. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
starting_balance |
number |
Account balance at beginning of year. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
denorm_boiler_fuel_eia923#
EIA-923 Monthly Boiler Fuel Consumption and Emissions, from EIA-923 Schedule 3.
Reports the quantity of each type of fuel consumed by each boiler on a monthly basis, as well as the sulfur and ash content of those fuels. Fuel quantity is reported in standard EIA fuel units (tons, barrels, Mcf). Heat content per unit of fuel is also reported, making this table useful for calculating the thermal efficiency (heat rate) of various generation units.
This table provides better coverage of the entire fleet of generators than the
generation_fuel_eia923
table, but the fuel consumption reported here is
not directly
associated with a generator. This complicates the heat rate calculation, since
the
associations between individual boilers and generators are incomplete and can
be
complex.
Note that a small number of respondents only report annual fuel consumption, and all of it is reported in December. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
ash_content_pct |
number |
Ash content percentage by weight to the nearest 0.1 percent. |
boiler_id |
string |
Alphanumeric boiler ID. |
energy_source_code |
string |
A 2-3 letter code indicating the energy source (e.g. fuel type) associated with the record. |
fuel_consumed_mmbtu |
number |
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_consumed_units |
number |
Consumption of the fuel type in physical unit. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_mmbtu_per_unit |
number |
Heat content of the fuel in millions of Btus per physical unit. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
report_date |
date |
Date reported. |
sulfur_content_pct |
number |
Sulfur content percentage by weight to the nearest 0.01 percent. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
denorm_boiler_fuel_monthly_eia923#
EIA-923 Monthly Boiler Fuel Consumption and Emissions, from EIA-923 Schedule 3.
Reports the quantity of each type of fuel consumed by each boiler on a monthly basis, as well as the sulfur and ash content of those fuels. Fuel quantity is reported in standard EIA fuel units (tons, barrels, Mcf). Heat content per unit of fuel is also reported, making this table useful for calculating the thermal efficiency (heat rate) of various generation units.
This table provides better coverage of the entire fleet of generators than the
generation_fuel_eia923
table, but the fuel consumption reported here is
not directly
associated with a generator. This complicates the heat rate calculation, since
the
associations between individual boilers and generators are incomplete and can
be
complex.
Note that a small number of respondents only report annual fuel consumption, and all of it is reported in December. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
ash_content_pct |
number |
Ash content percentage by weight to the nearest 0.1 percent. |
boiler_id |
string |
Alphanumeric boiler ID. |
energy_source_code |
string |
A 2-3 letter code indicating the energy source (e.g. fuel type) associated with the record. |
fuel_consumed_mmbtu |
number |
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_consumed_units |
number |
Consumption of the fuel type in physical unit. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_mmbtu_per_unit |
number |
Heat content of the fuel in millions of Btus per physical unit. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
report_date |
date |
Date reported. |
sulfur_content_pct |
number |
Sulfur content percentage by weight to the nearest 0.01 percent. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
denorm_boiler_fuel_yearly_eia923#
EIA-923 Monthly Boiler Fuel Consumption and Emissions, from EIA-923 Schedule 3.
Reports the quantity of each type of fuel consumed by each boiler on a monthly basis, as well as the sulfur and ash content of those fuels. Fuel quantity is reported in standard EIA fuel units (tons, barrels, Mcf). Heat content per unit of fuel is also reported, making this table useful for calculating the thermal efficiency (heat rate) of various generation units.
This table provides better coverage of the entire fleet of generators than the
generation_fuel_eia923
table, but the fuel consumption reported here is
not directly
associated with a generator. This complicates the heat rate calculation, since
the
associations between individual boilers and generators are incomplete and can
be
complex.
Note that a small number of respondents only report annual fuel consumption, and all of it is reported in December. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
ash_content_pct |
number |
Ash content percentage by weight to the nearest 0.1 percent. |
boiler_id |
string |
Alphanumeric boiler ID. |
energy_source_code |
string |
A 2-3 letter code indicating the energy source (e.g. fuel type) associated with the record. |
fuel_consumed_mmbtu |
number |
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_consumed_units |
number |
Consumption of the fuel type in physical unit. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_mmbtu_per_unit |
number |
Heat content of the fuel in millions of Btus per physical unit. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
report_date |
date |
Date reported. |
sulfur_content_pct |
number |
Sulfur content percentage by weight to the nearest 0.01 percent. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
denorm_boilers_eia#
Denormalized table containing all EIA boiler attributes. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
air_flow_100pct_load_cubic_feet_per_minute |
number |
Total air flow including excess air at 100 percent load, reported at standard temperature and pressure (i.e. 68 F and one atmosphere pressure). |
boiler_fuel_code_1 |
string |
The code representing the most predominant type of energy that fuels the boiler. |
boiler_fuel_code_2 |
string |
The code representing the second most predominant type of energy that fuels the boiler. |
boiler_fuel_code_3 |
string |
The code representing the third most predominant type of energy that fuels the boiler. |
boiler_fuel_code_4 |
string |
The code representing the fourth most predominant type of energy that fuels the boiler. |
boiler_id |
string |
Alphanumeric boiler ID. |
boiler_manufacturer |
string |
Name of boiler manufacturer. |
boiler_manufacturer_code |
string |
EIA short code for boiler manufacturer. |
boiler_operating_date |
date |
Date the boiler began or is planned to begin commercial operation. |
boiler_retirement_date |
date |
Date of the scheduled or effected retirement of the boiler. |
boiler_status |
string |
EIA short code identifying boiler operational status. |
boiler_type |
string |
EIA short code indicating the standards under which the boiler is operating as described in the U.S. EPA regulation under 40 CFR. |
city |
string |
N/A |
compliance_year_mercury |
integer |
Year boiler was or is expected to be in compliance with federal, state and/or local regulations for mercury emissions. |
compliance_year_nox |
integer |
Year boiler was or is expected to be in compliance with federal, state and/or local regulations for nitrogen oxide emissions. |
compliance_year_particulate |
integer |
Year boiler was or is expected to be in compliance with federal, state and/or local regulations for particulate matter emissions. |
compliance_year_so2 |
integer |
Year boiler was or is expected to be in compliance with federal, state and/or local regulations for sulfur dioxide emissions. |
county |
string |
County name. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
efficiency_100pct_load |
number |
Boiler efficiency percentage when burning at 100 percent load to the nearest 0.1 percent. |
efficiency_50pct_load |
number |
Boiler efficiency percentage when burning at 50 percent load to the nearest 0.1 percent. |
firing_rate_using_coal_tons_per_hour |
number |
Design firing rate at maximum continuous steam flow for coal to the nearest 0.1 ton per hour. |
firing_rate_using_gas_mcf_per_hour |
number |
Design firing rate at maximum continuous steam flow for gas to the nearest 0.1 cubic feet per hour. |
firing_rate_using_oil_bbls_per_hour |
number |
Design firing rate at maximum continuous steam flow for pet coke to the nearest 0.1 barrels per hour. |
firing_rate_using_other_fuels |
number |
Design firing rate at maximum continuous steam flow for energy sources other than coal, petroleum, or natural gas. |
firing_type_1 |
string |
EIA short code indicating the type of firing used by this boiler. |
firing_type_2 |
string |
EIA short code indicating the type of firing used by this boiler. |
firing_type_3 |
string |
EIA short code indicating the type of firing used by this boiler. |
fly_ash_reinjection |
boolean |
Indicates whether the boiler is capable of re-injecting fly ash. |
hrsg |
boolean |
indicates if the boiler is a heat recovery steam generator (HRSG). |
latitude |
number |
Latitude of the plant's location, in degrees. |
longitude |
number |
Longitude of the plant's location, in degrees. |
max_steam_flow_1000_lbs_per_hour |
number |
Maximum continuous steam flow at 100 percent load. |
mercury_control_existing_strategy_1 |
string |
Existing strategy to comply with the most stringent mercury regulation. |
mercury_control_existing_strategy_2 |
string |
Existing strategy to comply with the most stringent mercury regulation. |
mercury_control_existing_strategy_3 |
string |
Existing strategy to comply with the most stringent mercury regulation. |
mercury_control_existing_strategy_4 |
string |
Existing strategy to comply with the most stringent mercury regulation. |
mercury_control_existing_strategy_5 |
string |
Existing strategy to comply with the most stringent mercury regulation. |
mercury_control_existing_strategy_6 |
string |
Existing strategy to comply with the most stringent mercury regulation. |
mercury_control_proposed_strategy_1 |
string |
Proposed strategy to comply with the most stringent mercury regulation. |
mercury_control_proposed_strategy_2 |
string |
Proposed strategy to comply with the most stringent mercury regulation. |
mercury_control_proposed_strategy_3 |
string |
Proposed strategy to comply with the most stringent mercury regulation. |
new_source_review |
boolean |
Indicates whether the boiler is subject to New Source Review requirements. |
new_source_review_date |
date |
Month of issued New Source Review permit. |
new_source_review_permit |
string |
New Source Review permit number. |
nox_control_existing_caaa_compliance_strategy_1 |
string |
Existing strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
nox_control_existing_caaa_compliance_strategy_2 |
string |
Existing strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
nox_control_existing_caaa_compliance_strategy_3 |
string |
Existing strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
nox_control_existing_strategy_1 |
string |
Existing strategy to comply with the most stringent nitrogen oxide regulation. |
nox_control_existing_strategy_2 |
string |
Existing strategy to comply with the most stringent nitrogen oxide regulation. |
nox_control_existing_strategy_3 |
string |
Existing strategy to comply with the most stringent nitrogen oxide regulation. |
nox_control_manufacturer |
string |
Name of nitrogen oxide control manufacturer. |
nox_control_manufacturer_code |
string |
Code indicating the nitrogen oxide control burner manufacturer. |
nox_control_out_of_compliance_strategy_1 |
string |
If boiler is not in compliance with nitrogen oxide regulations, strategy for compliance. |
nox_control_out_of_compliance_strategy_2 |
string |
If boiler is not in compliance with nitrogen oxide regulations, strategy for compliance. |
nox_control_out_of_compliance_strategy_3 |
string |
If boiler is not in compliance with nitrogen oxide regulations, strategy for compliance. |
nox_control_planned_caaa_compliance_strategy_1 |
string |
Planned strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
nox_control_planned_caaa_compliance_strategy_2 |
string |
Planned strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
nox_control_planned_caaa_compliance_strategy_3 |
string |
Planned strategies to meet the nitrogen oxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
nox_control_proposed_strategy_1 |
string |
Proposed strategy to comply with the most stringent nitrogen oxide regulation. |
nox_control_proposed_strategy_2 |
string |
Proposed strategy to comply with the most stringent nitrogen oxide regulation. |
nox_control_proposed_strategy_3 |
string |
Proposed strategy to comply with the most stringent nitrogen oxide regulation. |
nox_control_status_code |
string |
Nitrogen oxide control status code. |
particulate_control_out_of_compliance_strategy_1 |
string |
If boiler is not in compliance with particulate matter regulations, strategy for compliance. |
particulate_control_out_of_compliance_strategy_2 |
string |
If boiler is not in compliance with particulate matter regulations, strategy for compliance. |
particulate_control_out_of_compliance_strategy_3 |
string |
If boiler is not in compliance with particulate matter regulations, strategy for compliance. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
regulation_mercury |
string |
Most stringent type of statute or regulation code under which the boiler is operating for mercury control standards. |
regulation_nox |
string |
EIA short code for most stringent type of statute or regulation code under which the boiler is operating for nitrogen oxide control standards. |
regulation_particulate |
string |
EIA short code for most stringent type of statute or regulation code under which the boiler is operating for particulate matter control standards. |
regulation_so2 |
string |
EIA short code for most stringent type of statute or regulation code under which the boiler is operating for sulfur dioxide control standards. |
report_date |
date |
Date reported. |
so2_control_existing_caaa_compliance_strategy_1 |
string |
Existing strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
so2_control_existing_caaa_compliance_strategy_2 |
string |
Existing strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
so2_control_existing_caaa_compliance_strategy_3 |
string |
Existing strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
so2_control_existing_strategy_1 |
string |
Existing strategy to comply with the most stringent sulfur dioxide regulation. |
so2_control_existing_strategy_2 |
string |
Existing strategy to comply with the most stringent sulfur dioxide regulation. |
so2_control_existing_strategy_3 |
string |
Existing strategy to comply with the most stringent sulfur dioxide regulation. |
so2_control_out_of_compliance_strategy_1 |
string |
If boiler is not in compliance with sulfur dioxide regulations, strategy for compliance. |
so2_control_out_of_compliance_strategy_2 |
string |
If boiler is not in compliance with sulfur dioxide regulations, strategy for compliance. |
so2_control_out_of_compliance_strategy_3 |
string |
If boiler is not in compliance with sulfur dioxide regulations, strategy for compliance. |
so2_control_planned_caaa_compliance_strategy_1 |
string |
Planned strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
so2_control_planned_caaa_compliance_strategy_2 |
string |
Planned strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
so2_control_planned_caaa_compliance_strategy_3 |
string |
Planned strategies to meet the sulfur dioxide requirements of Title IV of the Clean Air Act Amendment of 1990. |
so2_control_proposed_strategy_1 |
string |
Proposed strategy to comply with the most stringent sulfur dioxide regulation. |
so2_control_proposed_strategy_2 |
string |
Proposed strategy to comply with the most stringent sulfur dioxide regulation. |
so2_control_proposed_strategy_3 |
string |
Proposed strategy to comply with the most stringent sulfur dioxide regulation. |
standard_nox_rate |
number |
Numeric value for the unit of measurement specified for nitrogen oxide. |
standard_particulate_rate |
number |
Numeric value for the unit of measurement specified for particulate matter. |
standard_so2_percent_scrubbed |
number |
The percent of sulfur dioxide to be scrubbed specified by the most stringent sulfur dioxide regulation. |
standard_so2_rate |
number |
Numeric value for the unit of measurement specified for sulfur dioxide. |
state |
string |
Two letter US state abbreviation. |
street_address |
string |
N/A |
timezone |
string |
IANA timezone name |
turndown_ratio |
number |
The turndown ratio for the boiler. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
unit_nox |
string |
Numeric value for the unit of measurement specified for nitrogen oxide. |
unit_particulate |
string |
Numeric value for the unit of measurement specified for particulate matter. |
unit_so2 |
string |
Numeric value for the unit of measurement specified for sulfur dioxide. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
waste_heat_input_mmbtu_per_hour |
number |
Design waste-heat input rate at maximum continuous steam flow where a waste-heat boiler is a boiler that receives all or a substantial portion of its energy input from the noncumbustible exhaust gases of a separate fuel-burning process (MMBtu per hour). |
wet_dry_bottom |
string |
Wet or Dry Bottom where Wet Bottom is defined as slag tanks that are installed at furnace throat to contain and remove molten ash from the furnace, and Dry Bottom is defined as having no slag tanks at furnace throat area, throat area is clear, and bottom ash drops through throat to bottom ash water hoppers. |
zip_code |
string |
Five digit US Zip Code. |
denorm_cash_flow_ferc1#
Denormalized table that contains FERC cash flow information. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
amount |
number |
Reported amount of dollars. This could be a balance or a change in value. |
amount_type |
string |
Label describing the type of amount being reported. This could be a balance or a change in value. |
balance |
string |
Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
denorm_depreciation_amortization_summary_ferc1#
Denormalized table that contains FERC depreciation amortization information. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
dollar_value |
number |
Dollar value of reported income, expense, asset, or liability. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
ferc_account_label |
string |
Long FERC account identifier derived from values reported in the XBRL taxonomies. May also refer to aggregations of individual FERC accounts. |
plant_function |
string |
Functional role played by utility plant (steam production, nuclear production, distribution, transmission, etc.). |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
utility_type |
string |
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility. |
denorm_electric_energy_dispositions_ferc1#
Denormalized table that contains FERC electric energy dispositions information. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
energy_disposition_type |
string |
Type of energy disposition reported in the electric_energy_dispositions_ferc1. Dispositions include sales to customers, re-sales of energy, energy used internally, losses, etc. |
energy_mwh |
number |
Sources and uses of energy in MWh. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
denorm_electric_energy_sources_ferc1#
Denormalized table that contains FERC electric energy sources information. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
energy_mwh |
number |
Sources and uses of energy in MWh. |
energy_source_type |
string |
Type of energy source reported in the electric_energy_sources_ferc1 table. There are three groups of energy sources: generation, power exchanges and transmission. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
denorm_electric_operating_expenses_ferc1#
Denormalized table that contains FERC electric operating expense information. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
dollar_value |
number |
Dollar value of reported income, expense, asset, or liability. |
expense_type |
string |
The type of expense. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
utility_type |
string |
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility. |
denorm_electric_operating_revenues_ferc1#
Denormalized table that contains FERC electric operating revenue information. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
avg_customers_per_month |
number |
Average number of customers per month. |
dollar_value |
number |
Dollar value of reported income, expense, asset, or liability. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
revenue_type |
string |
Label describing types of revenues. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
sales_mwh |
number |
Quantity of electricity sold in MWh. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
utility_type |
string |
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility. |
denorm_electric_plant_depreciation_changes_ferc1#
Denormalized table that contains FERC electric plant depreciation changes information. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balance |
string |
Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy. |
depreciation_type |
string |
Type of depreciation provision within FERC Account 108, including cost ofremoval, depreciation expenses, salvage, cost of retired plant, etc. |
dollar_value |
number |
Dollar value of reported income, expense, asset, or liability. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
plant_status |
string |
Utility plant financial status (in service, future, leased, total). |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
utility_type |
string |
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility. |
denorm_electric_plant_depreciation_functional_ferc1#
Denormalized accumulated provision for depreciation of electric utility plant (Account 108). Schedule 219 Section B: Functional plant classifications. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balance |
string |
Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy. |
depreciation_type |
string |
Type of depreciation provision within FERC Account 108, including cost ofremoval, depreciation expenses, salvage, cost of retired plant, etc. |
ending_balance |
number |
Account balance at end of year. |
plant_function |
string |
Functional role played by utility plant (steam production, nuclear production, distribution, transmission, etc.). |
plant_status |
string |
Utility plant financial status (in service, future, leased, total). |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
utility_type |
string |
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility. |
denorm_electricity_sales_by_rate_schedule_ferc1#
Denormalized table that contains FERC electricity sales by rate schedule information. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
avg_customers_per_month |
number |
Average number of customers per month. |
billing_status |
string |
Whether an amount is billed, unbilled, or both. Billed amounts pertain to the exchange of energy and unbilled amounts pertain to other sources of revenue such as contracts with peaker plants to keep them on standby or charging rent to host cell antennas on transmission towers. |
dollar_value |
number |
Dollar value of reported income, expense, asset, or liability. |
kwh_per_customer |
number |
kwh per customer. |
rate_schedule_description |
string |
Free-form description of what the rate schedule name is. Not standardized. Often a sub-category of rate_schedule_type. |
rate_schedule_type |
string |
Categorization of rate schedule type. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
revenue_per_kwh |
number |
N/A |
sales_mwh |
number |
Quantity of electricity sold in MWh. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
denorm_emissions_control_equipment_eia860#
The cost, type, operating status, retirement date, and install year of emissions control equipment reported to EIA. Includes control ids for sulfur dioxide (SO2), particulate matter, mercury, nitrogen oxide (NOX), and acid (HCl) gas monitoring. The denormalized version contains plant name, utility id, pudl id, and utility name columns. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
acid_gas_control |
boolean |
Indicates whether the emissions control equipment controls acid (HCl) gas. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
emission_control_equipment_cost |
number |
The total cost to install a piece of emission control equipment. |
emission_control_equipment_type_code |
string |
Short code indicating the type of emission control equipment installed. |
emission_control_id_pudl |
number |
A PUDL-generated ID used to distinguish emission control units in the same report year and plant id. This ID should not be used to track units over time or between plants. |
emission_control_operating_date |
date |
The date a piece of emissions control equipment began operating. Derived from month and year columns in the raw data. |
emission_control_retirement_date |
date |
The expected or actual retirement date for a piece of emissions control equipment. Derived from month and year columns in the raw data. |
mercury_control_id_eia |
string |
Mercury control identification number. This ID is not a unique identifier. |
nox_control_id_eia |
string |
Nitrogen oxide control identification number. This ID is not a unique identifier. |
operational_status |
string |
The operating status of the asset. For generators this is based on which tab the generator was listed in in EIA 860. |
operational_status_code |
string |
The operating status of the asset. |
particulate_control_id_eia |
string |
Particulate matter control identification number. This ID is not a unique identifier. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
report_year |
integer |
Four-digit year in which the data was reported. |
so2_control_id_eia |
string |
Sulfur dioxide control identification number. This ID is not a unique identifier. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
denorm_fuel_by_plant_ferc1#
A table summarizing FERC fuel data by plant, using FERC Form 1 data. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
coal_fraction_cost |
number |
Coal cost as a percentage of overall fuel cost. |
coal_fraction_mmbtu |
number |
Coal heat content as a percentage of overall fuel heat content (mmBTU). |
fuel_cost |
number |
Total fuel cost for plant (in $USD). |
fuel_mmbtu |
number |
Total heat content for plant (in MMBtu). |
gas_fraction_cost |
number |
Natural gas cost as a percentage of overall fuel cost. |
gas_fraction_mmbtu |
number |
Natural gas heat content as a percentage of overall fuel heat content (MMBtu). |
nuclear_fraction_cost |
number |
Nuclear cost as a percentage of overall fuel cost. |
nuclear_fraction_mmbtu |
number |
Nuclear heat content as a percentage of overall fuel heat content (MMBtu). |
oil_fraction_cost |
number |
Oil cost as a percentage of overall fuel cost. |
oil_fraction_mmbtu |
number |
Oil heat content as a percentage of overall fuel heat content (MMBtu). |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_ferc1 |
string |
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant. |
primary_fuel_by_cost |
string |
Primary fuel for plant as a percentage of cost. |
primary_fuel_by_mmbtu |
string |
Primary fuel for plant as a percentage of heat content. |
report_year |
integer |
Four-digit year in which the data was reported. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
waste_fraction_cost |
number |
Waste-heat cost as a percentage of overall fuel cost. |
waste_fraction_mmbtu |
number |
Waste-heat heat content as a percentage of overall fuel heat content (MMBtu). |
denorm_fuel_ferc1#
Denormalized table that contains fuel information from FERC Form 1. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
fuel_consumed_mmbtu |
number |
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_consumed_total_cost |
number |
Total cost of consumed fuel. |
fuel_consumed_units |
number |
Consumption of the fuel type in physical unit. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_cost_per_unit_burned |
number |
Average cost of fuel consumed in the report year per reported fuel unit (USD). |
fuel_cost_per_unit_delivered |
number |
Average cost of fuel delivered in the report year per reported fuel unit (USD). |
fuel_mmbtu_per_unit |
number |
Heat content of the fuel in millions of Btus per physical unit. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
fuel_units |
string |
Reported unit of measure for fuel. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_ferc1 |
string |
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
denorm_fuel_receipts_costs_eia923#
Data describing fuel deliveries to power plants, reported in EIA-923 Schedule 2, Part A.
Each record describes an individual fuel delivery. There can be multiple deliveries of the same type of fuel from the same supplier to the same plant in a single month, so the table has no natural primary key.
There can be a significant delay between the receipt of fuel and its consumption, so using this table to infer monthly attributes associated with power generation may not be entirely accurate. However, this is the most granular data we have describing fuel costs, and we use it in calculating the marginal cost of electricity for individual generation units.
Under some circumstances utilities are allowed to treat the price of fuel as proprietary business data, meaning it is redacted from the publicly available spreadsheets. It's still reported to EIA and influences the aggregated (state, region, annual, etc.) fuel prices they publish. From 2009-2021 about 1/3 of all prices are redacted. The missing data is not randomly distributed. Deregulated markets dominated by merchant generators (independent power producers) redact much more data, and natural gas is by far the most likely fuel to have its price redacted. This means, for instance, that the entire Northeastern US reports essentially no fine-grained data about its natural gas prices.
Additional data which we haven't yet integrated is available in a similar format from 2002-2008 via the EIA-423, and going back as far as 1972 from the FERC-423. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
ash_content_pct |
number |
Ash content percentage by weight to the nearest 0.1 percent. |
bulk_agg_fuel_cost_per_mmbtu |
number |
Fuel cost per mmbtu reported in the EIA bulk electricity data. This is an aggregate average fuel price for a whole state, region, month, sector, etc. Used to fill in missing fuel prices. |
chlorine_content_ppm |
number |
N/A |
coalmine_county_id_fips |
string |
County ID from the Federal Information Processing Standard Publication 6-4. This is the county where the coal mine is located. |
contract_expiration_date |
date |
Date contract expires.Format: MMYY. |
contract_type_code |
string |
Purchase type under which receipts occurred in the reporting month. C: Contract, NC: New Contract, S: Spot Purchase, T: Tolling Agreement. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
energy_source_code |
string |
A 2-3 letter code indicating the energy source (e.g. fuel type) associated with the record. |
fuel_consumed_mmbtu |
number |
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_cost_from_eiaapi |
boolean |
Indicates whether the fuel cost was derived from the EIA API. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_group_code |
string |
Fuel groups used in the Electric Power Monthly |
fuel_mmbtu_per_unit |
number |
Heat content of the fuel in millions of Btus per physical unit. |
fuel_received_units |
number |
Quanity of fuel received in tons, barrel, or Mcf. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
mercury_content_ppm |
number |
Mercury content in parts per million (ppm) to the nearest 0.001 ppm. |
mine_id_msha |
integer |
MSHA issued mine identifier. |
mine_name |
string |
Coal mine name. |
mine_state |
string |
State where the coal mine is located. Two letter abbreviation. |
mine_type_code |
string |
Type of coal mine. |
moisture_content_pct |
number |
N/A |
natural_gas_delivery_contract_type_code |
string |
Contract type for natrual gas delivery service: |
natural_gas_transport_code |
string |
Contract type for natural gas transportation service. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
primary_transportation_mode_code |
string |
Transportation mode for the longest distance transported. |
report_date |
date |
Date reported. |
secondary_transportation_mode_code |
string |
Transportation mode for the second longest distance transported. |
state |
string |
Two letter US state abbreviation. |
sulfur_content_pct |
number |
Sulfur content percentage by weight to the nearest 0.01 percent. |
supplier_name |
string |
Company that sold the fuel to the plant or, in the case of Natural Gas, pipline owner. |
total_fuel_cost |
number |
Total annual reported fuel costs for the plant part. Includes costs from all fuels. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
denorm_fuel_receipts_costs_monthly_eia923#
Data describing fuel deliveries to power plants, reported in EIA-923 Schedule 2, Part A.
Each record describes an individual fuel delivery. There can be multiple deliveries of the same type of fuel from the same supplier to the same plant in a single month, so the table has no natural primary key.
There can be a significant delay between the receipt of fuel and its consumption, so using this table to infer monthly attributes associated with power generation may not be entirely accurate. However, this is the most granular data we have describing fuel costs, and we use it in calculating the marginal cost of electricity for individual generation units.
Under some circumstances utilities are allowed to treat the price of fuel as proprietary business data, meaning it is redacted from the publicly available spreadsheets. It's still reported to EIA and influences the aggregated (state, region, annual, etc.) fuel prices they publish. From 2009-2021 about 1/3 of all prices are redacted. The missing data is not randomly distributed. Deregulated markets dominated by merchant generators (independent power producers) redact much more data, and natural gas is by far the most likely fuel to have its price redacted. This means, for instance, that the entire Northeastern US reports essentially no fine-grained data about its natural gas prices.
Additional data which we haven't yet integrated is available in a similar format from 2002-2008 via the EIA-423, and going back as far as 1972 from the FERC-423. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
ash_content_pct |
number |
Ash content percentage by weight to the nearest 0.1 percent. |
chlorine_content_ppm |
number |
N/A |
fuel_consumed_mmbtu |
number |
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_cost_from_eiaapi |
boolean |
Indicates whether the fuel cost was derived from the EIA API. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_mmbtu_per_unit |
number |
Heat content of the fuel in millions of Btus per physical unit. |
fuel_received_units |
number |
Quanity of fuel received in tons, barrel, or Mcf. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
mercury_content_ppm |
number |
Mercury content in parts per million (ppm) to the nearest 0.001 ppm. |
moisture_content_pct |
number |
N/A |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
sulfur_content_pct |
number |
Sulfur content percentage by weight to the nearest 0.01 percent. |
total_fuel_cost |
number |
Total annual reported fuel costs for the plant part. Includes costs from all fuels. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
denorm_fuel_receipts_costs_yearly_eia923#
Data describing fuel deliveries to power plants, reported in EIA-923 Schedule 2, Part A.
Each record describes an individual fuel delivery. There can be multiple deliveries of the same type of fuel from the same supplier to the same plant in a single month, so the table has no natural primary key.
There can be a significant delay between the receipt of fuel and its consumption, so using this table to infer monthly attributes associated with power generation may not be entirely accurate. However, this is the most granular data we have describing fuel costs, and we use it in calculating the marginal cost of electricity for individual generation units.
Under some circumstances utilities are allowed to treat the price of fuel as proprietary business data, meaning it is redacted from the publicly available spreadsheets. It's still reported to EIA and influences the aggregated (state, region, annual, etc.) fuel prices they publish. From 2009-2021 about 1/3 of all prices are redacted. The missing data is not randomly distributed. Deregulated markets dominated by merchant generators (independent power producers) redact much more data, and natural gas is by far the most likely fuel to have its price redacted. This means, for instance, that the entire Northeastern US reports essentially no fine-grained data about its natural gas prices.
Additional data which we haven't yet integrated is available in a similar format from 2002-2008 via the EIA-423, and going back as far as 1972 from the FERC-423. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
ash_content_pct |
number |
Ash content percentage by weight to the nearest 0.1 percent. |
chlorine_content_ppm |
number |
N/A |
fuel_consumed_mmbtu |
number |
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_cost_from_eiaapi |
boolean |
Indicates whether the fuel cost was derived from the EIA API. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_mmbtu_per_unit |
number |
Heat content of the fuel in millions of Btus per physical unit. |
fuel_received_units |
number |
Quanity of fuel received in tons, barrel, or Mcf. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
mercury_content_ppm |
number |
Mercury content in parts per million (ppm) to the nearest 0.001 ppm. |
moisture_content_pct |
number |
N/A |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
sulfur_content_pct |
number |
Sulfur content percentage by weight to the nearest 0.01 percent. |
total_fuel_cost |
number |
Total annual reported fuel costs for the plant part. Includes costs from all fuels. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
denorm_generation_eia923#
EIA-923 Monthly Generating Unit Net Generation. From EIA-923 Schedule 3.
Reports the net electricity generated by each reporting generator on a monthly
basis.
This is the most granular information we have about how much electricity
individual
generators are producing, but only about half of all the generation reported
in the
generation_fuel_eia923
appears in this table due to the different
reporting
requirements imposed on different types and sizes of generators.
Whenever possible, we use this generator-level net generation to estimate the heat rates of generation units and the marginal cost of electricity on a per-generator basis, but those calculations depend on plant-level fuel costs and sometimes uncertain or incomplete boiler-generator associations.
Note that a small number of respondents only report annual net generation, and all of it is reported in December. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
report_date |
date |
Date reported. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
denorm_generation_fuel_combined_eia923#
EIA-923 Monthly Generation and Fuel Consumption Time Series. From EIA-923 Schedule 3.
Denormalized, combined data from the generation_fuel_eia923
and
generation_fuel_nuclear_eia923
with nuclear generation aggregated from the
nuclear
generation unit level up to the plant prime mover level, so as to be
compatible with
fossil fuel generation data.
Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
energy_source_code |
string |
A 2-3 letter code indicating the energy source (e.g. fuel type) associated with the record. |
fuel_consumed_for_electricity_mmbtu |
number |
Total consumption of fuel to produce electricity, in physical unit, year to date. |
fuel_consumed_for_electricity_units |
number |
Consumption for electric generation of the fuel type in physical unit. |
fuel_consumed_mmbtu |
number |
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_consumed_units |
number |
Consumption of the fuel type in physical unit. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_mmbtu_per_unit |
number |
Heat content of the fuel in millions of Btus per physical unit. |
fuel_type_code_aer |
string |
A partial aggregation of the reported fuel type codes into larger categories used by EIA in, for example, the Annual Energy Review (AER). Two or three letter alphanumeric. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
report_date |
date |
Date reported. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
denorm_generation_fuel_combined_monthly_eia923#
EIA-923 Monthly Generation and Fuel Consumption Time Series. From EIA-923 Schedule 3.
Denormalized, combined data from the generation_fuel_eia923
and
generation_fuel_nuclear_eia923
with nuclear generation aggregated from the
nuclear
generation unit level up to the plant prime mover level, so as to be
compatible with
fossil fuel generation data.
Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
energy_source_code |
string |
A 2-3 letter code indicating the energy source (e.g. fuel type) associated with the record. |
fuel_consumed_for_electricity_mmbtu |
number |
Total consumption of fuel to produce electricity, in physical unit, year to date. |
fuel_consumed_for_electricity_units |
number |
Consumption for electric generation of the fuel type in physical unit. |
fuel_consumed_mmbtu |
number |
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_consumed_units |
number |
Consumption of the fuel type in physical unit. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_mmbtu_per_unit |
number |
Heat content of the fuel in millions of Btus per physical unit. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
report_date |
date |
Date reported. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
denorm_generation_fuel_combined_yearly_eia923#
EIA-923 Monthly Generation and Fuel Consumption Time Series. From EIA-923 Schedule 3.
Denormalized, combined data from the generation_fuel_eia923
and
generation_fuel_nuclear_eia923
with nuclear generation aggregated from the
nuclear
generation unit level up to the plant prime mover level, so as to be
compatible with
fossil fuel generation data.
Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
energy_source_code |
string |
A 2-3 letter code indicating the energy source (e.g. fuel type) associated with the record. |
fuel_consumed_for_electricity_mmbtu |
number |
Total consumption of fuel to produce electricity, in physical unit, year to date. |
fuel_consumed_for_electricity_units |
number |
Consumption for electric generation of the fuel type in physical unit. |
fuel_consumed_mmbtu |
number |
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_consumed_units |
number |
Consumption of the fuel type in physical unit. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_mmbtu_per_unit |
number |
Heat content of the fuel in millions of Btus per physical unit. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
report_date |
date |
Date reported. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
denorm_generation_monthly_eia923#
EIA-923 Monthly Generating Unit Net Generation. From EIA-923 Schedule 3.
Reports the net electricity generated by each reporting generator on a monthly
basis.
This is the most granular information we have about how much electricity
individual
generators are producing, but only about half of all the generation reported
in the
generation_fuel_eia923
appears in this table due to the different
reporting
requirements imposed on different types and sizes of generators.
Whenever possible, we use this generator-level net generation to estimate the heat rates of generation units and the marginal cost of electricity on a per-generator basis, but those calculations depend on plant-level fuel costs and sometimes uncertain or incomplete boiler-generator associations.
Note that a small number of respondents only report annual net generation, and all of it is reported in December. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
report_date |
date |
Date reported. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
denorm_generation_yearly_eia923#
EIA-923 Monthly Generating Unit Net Generation. From EIA-923 Schedule 3.
Reports the net electricity generated by each reporting generator on a monthly
basis.
This is the most granular information we have about how much electricity
individual
generators are producing, but only about half of all the generation reported
in the
generation_fuel_eia923
appears in this table due to the different
reporting
requirements imposed on different types and sizes of generators.
Whenever possible, we use this generator-level net generation to estimate the heat rates of generation units and the marginal cost of electricity on a per-generator basis, but those calculations depend on plant-level fuel costs and sometimes uncertain or incomplete boiler-generator associations.
Note that a small number of respondents only report annual net generation, and all of it is reported in December. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
report_date |
date |
Date reported. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
denorm_generators_eia#
Denormalized table containing all EIA generator attributes. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
associated_combined_heat_power |
boolean |
Indicates whether the generator is associated with a combined heat and power system |
bga_source |
string |
The source from where the unit_id_pudl is compiled. The unit_id_pudl comes directly from EIA 860, or string association (which looks at all the boilers and generators that are not associated with a unit and tries to find a matching string in the respective collection of boilers or generator), or from a unit connection (where the unit_id_eia is employed to find additional boiler generator connections). |
bypass_heat_recovery |
boolean |
Can this generator operate while bypassing the heat recovery steam generator? |
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
carbon_capture |
boolean |
Indicates whether the generator uses carbon capture technology. |
city |
string |
N/A |
cofire_fuels |
boolean |
Can the generator co-fire fuels?. |
county |
string |
County name. |
current_planned_generator_operating_date |
date |
The most recently updated effective date on which the generator is scheduled to start operation |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
deliver_power_transgrid |
boolean |
Indicate whether the generator can deliver power to the transmission grid. |
distributed_generation |
boolean |
Whether the generator is considered distributed generation |
duct_burners |
boolean |
Indicates whether the unit has duct-burners for supplementary firing of the turbine exhaust gas |
energy_source_1_transport_1 |
string |
Primary mode of transport for energy source 1. |
energy_source_1_transport_2 |
string |
Secondary mode of transport for energy source 1. |
energy_source_1_transport_3 |
string |
Tertiary mode of transport for energy source 1. |
energy_source_2_transport_1 |
string |
Primary mode of transport for energy source 2. |
energy_source_2_transport_2 |
string |
Secondary mode of transport for energy source 2. |
energy_source_2_transport_3 |
string |
Tertiary mode of transport for energy source 2. |
energy_source_code_1 |
string |
The code representing the most predominant type of energy that fuels the generator. |
energy_source_code_2 |
string |
The code representing the second most predominant type of energy that fuels the generator |
energy_source_code_3 |
string |
The code representing the third most predominant type of energy that fuels the generator |
energy_source_code_4 |
string |
The code representing the fourth most predominant type of energy that fuels the generator |
energy_source_code_5 |
string |
The code representing the fifth most predominant type of energy that fuels the generator |
energy_source_code_6 |
string |
The code representing the sixth most predominant type of energy that fuels the generator |
energy_storage_capacity_mwh |
number |
Energy storage capacity in MWh (e.g. for batteries). |
ferc_qualifying_facility |
boolean |
Indicatates whether or not a generator is a qualifying FERC cogeneation facility. |
fluidized_bed_tech |
boolean |
Indicates whether the generator uses fluidized bed technology |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
fuel_type_count |
integer |
A count of how many different simple energy sources there are associated with a generator. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
generator_operating_date |
date |
Date the generator began commercial operation. |
generator_retirement_date |
date |
Date of the scheduled or effected retirement of the generator. |
latitude |
number |
Latitude of the plant's location, in degrees. |
longitude |
number |
Longitude of the plant's location, in degrees. |
minimum_load_mw |
number |
The minimum load at which the generator can operate at continuosuly. |
multiple_fuels |
boolean |
Can the generator burn multiple fuels? |
nameplate_power_factor |
number |
The nameplate power factor of the generator. |
net_capacity_mwdc |
number |
Generation capacity in megawatts of direct current that is subject to a net metering agreement. Typically used for behind-the-meter solar PV. |
operating_switch |
string |
Indicates whether the fuel switching generator can switch when operating |
operational_status |
string |
The operating status of the asset. For generators this is based on which tab the generator was listed in in EIA 860. |
operational_status_code |
string |
The operating status of the asset. |
original_planned_generator_operating_date |
date |
The date the generator was originally scheduled to be operational |
other_combustion_tech |
boolean |
Indicates whether the generator uses other combustion technologies |
other_modifications_date |
date |
Planned effective date that the generator is scheduled to enter commercial operation after any other planned modification is complete. |
other_planned_modifications |
boolean |
Indicates whether there are there other modifications planned for the generator. |
owned_by_non_utility |
boolean |
Whether any part of generator is owned by a nonutilty |
ownership_code |
string |
Identifies the ownership for each generator. |
planned_derate_date |
date |
Planned effective month that the generator is scheduled to enter operation after the derate modification. |
planned_energy_source_code_1 |
string |
New energy source code for the planned repowered generator. |
planned_generator_retirement_date |
date |
Planned effective date of the scheduled retirement of the generator. |
planned_modifications |
boolean |
Indicates whether there are any planned capacity uprates/derates, repowering, other modifications, or generator retirements scheduled for the next 5 years. |
planned_net_summer_capacity_derate_mw |
number |
Decrease in summer capacity expected to be realized from the derate modification to the equipment. |
planned_net_summer_capacity_uprate_mw |
number |
Increase in summer capacity expected to be realized from the modification to the equipment. |
planned_net_winter_capacity_derate_mw |
number |
Decrease in winter capacity expected to be realized from the derate modification to the equipment. |
planned_net_winter_capacity_uprate_mw |
number |
Increase in winter capacity expected to be realized from the uprate modification to the equipment. |
planned_new_capacity_mw |
number |
The expected new namplate capacity for the generator. |
planned_new_prime_mover_code |
string |
New prime mover for the planned repowered generator. |
planned_repower_date |
date |
Planned effective date that the generator is scheduled to enter operation after the repowering is complete. |
planned_uprate_date |
date |
Planned effective date that the generator is scheduled to enter operation after the uprate modification. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
previously_canceled |
boolean |
Indicates whether the generator was previously reported as indefinitely postponed or canceled |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
pulverized_coal_tech |
boolean |
Indicates whether the generator uses pulverized coal technology |
reactive_power_output_mvar |
number |
Reactive Power Output (MVAr) |
report_date |
date |
Date reported. |
rto_iso_lmp_node_id |
string |
The designation used to identify the price node in RTO/ISO Locational Marginal Price reports |
rto_iso_location_wholesale_reporting_id |
string |
The designation used to report ths specific location of the wholesale sales transactions to FERC for the Electric Quarterly Report |
solid_fuel_gasification |
boolean |
Indicates whether the generator is part of a solid fuel gasification system |
startup_source_code_1 |
string |
The code representing the first, second, third or fourth start-up and flame stabilization energy source used by the combustion unit(s) associated with this generator. |
startup_source_code_2 |
string |
The code representing the first, second, third or fourth start-up and flame stabilization energy source used by the combustion unit(s) associated with this generator. |
startup_source_code_3 |
string |
The code representing the first, second, third or fourth start-up and flame stabilization energy source used by the combustion unit(s) associated with this generator. |
startup_source_code_4 |
string |
The code representing the first, second, third or fourth start-up and flame stabilization energy source used by the combustion unit(s) associated with this generator. |
state |
string |
Two letter US state abbreviation. |
stoker_tech |
boolean |
Indicates whether the generator uses stoker technology |
street_address |
string |
N/A |
subcritical_tech |
boolean |
Indicates whether the generator uses subcritical technology |
summer_capacity_estimate |
boolean |
Whether the summer capacity value was an estimate |
summer_capacity_mw |
number |
The net summer capacity. |
summer_estimated_capability_mw |
number |
EIA estimated summer capacity (in MWh). |
supercritical_tech |
boolean |
Indicates whether the generator uses supercritical technology |
switch_oil_gas |
boolean |
Indicates whether the generator switch between oil and natural gas. |
syncronized_transmission_grid |
boolean |
Indicates whether standby generators (SB status) can be synchronized to the grid. |
technology_description |
string |
High level description of the technology used by the generator to produce electricity. |
time_cold_shutdown_full_load_code |
string |
The minimum amount of time required to bring the unit to full load from shutdown. |
timezone |
string |
IANA timezone name |
topping_bottoming_code |
string |
If the generator is associated with a combined heat and power system, indicates whether the generator is part of a topping cycle or a bottoming cycle |
turbines_inverters_hydrokinetics |
integer |
Number of wind turbines, or hydrokinetic buoys. |
turbines_num |
integer |
Number of wind turbines, or hydrokinetic buoys. |
ultrasupercritical_tech |
boolean |
Indicates whether the generator uses ultra-supercritical technology |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
uprate_derate_completed_date |
date |
The date when the uprate or derate was completed. |
uprate_derate_during_year |
boolean |
Was an uprate or derate completed on this generator during the reporting year? |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
winter_capacity_estimate |
boolean |
Whether the winter capacity value was an estimate |
winter_capacity_mw |
number |
The net winter capacity. |
winter_estimated_capability_mw |
number |
EIA estimated winter capacity (in MWh). |
zip_code |
string |
Five digit US Zip Code. |
denorm_income_statement_ferc1#
Denormalized table that contains FERC income statement information. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balance |
string |
Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy. |
dollar_value |
number |
Dollar value of reported income, expense, asset, or liability. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
income_type |
string |
Type of income reported in income_statement_ferc1 table. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
utility_type |
string |
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility. |
denorm_other_regulatory_liabilities_ferc1#
Denormalized table that contains FERC other regulatory liabilities information. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
account_detail |
string |
Description of the account number credited from making debit adjustment to other regulatory liabilities. |
decrease_in_other_regulatory_liabilities |
number |
The decrease during the reporting period of other regulatory liabilities. |
description |
string |
Long human-readable description of the meaning of a code/label. |
ending_balance |
number |
Account balance at end of year. |
increase_in_other_regulatory_liabilities |
number |
The increase during the reporting period of other regulatory liabilities. |
report_year |
integer |
Four-digit year in which the data was reported. |
starting_balance |
number |
Account balance at beginning of year. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
denorm_ownership_eia860#
Generator Ownership, reported in EIA-860 Schedule 4. Includes only jointly or third-party owned generators. Denormalized to include plant and utility names and other associated IDs. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
country |
string |
Three letter country abbreviation. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
fraction_owned |
number |
Proportion of generator ownership attributable to this utility. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
owner_city |
string |
City of owner. |
owner_street_address |
string |
Steet address of owner. |
owner_zip_code |
string |
Zip code of owner. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA utility Identification number for the owner company that is responsible for the day-to-day operations of the generator, not the operator utility. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
denorm_plant_in_service_ferc1#
Denormalized table of FERC Form 1 Electric Plant in Service data. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
additions |
number |
Cost of acquisition of items classified within the account. |
adjustments |
number |
Cost of adjustments to the account. |
ending_balance |
number |
Account balance at end of year. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
ferc_account_label |
string |
Long FERC account identifier derived from values reported in the XBRL taxonomies. May also refer to aggregations of individual FERC accounts. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
retirements |
number |
Cost of disposal of items classified within the account. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
starting_balance |
number |
Account balance at beginning of year. |
transfers |
number |
Cost of transfers into (out of) the account. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
utility_type |
string |
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility. |
denorm_plants_all_ferc1#
Denormalized table combining the steam, small generators, hydro, and pumped storage tables from FERC Form 1. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
asset_retirement_cost |
number |
Asset retirement cost (USD). |
avg_num_employees |
number |
N/A |
capacity_factor |
number |
Fraction of potential generation that was actually reported for a plant part. |
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
capex_annual_addition |
number |
Annual capital addition into capex_total. |
capex_annual_addition_rolling |
number |
Year-to-date capital addition into capex_total. |
capex_annual_per_kw |
number |
Annual capital addition into capex_total per kw. |
capex_annual_per_mw |
number |
Annual capital addition into capex_total per MW. |
capex_annual_per_mw_rolling |
number |
Year-to-date capital addition into capex_total per MW. |
capex_annual_per_mwh |
number |
Annual capital addition into capex_total per MWh. |
capex_annual_per_mwh_rolling |
number |
Year-to-date capital addition into capex_total per MWh. |
capex_equipment |
number |
Cost of plant: equipment (USD). |
capex_equipment_electric |
number |
Cost of plant: accessory electric equipment (USD). |
capex_equipment_misc |
number |
Cost of plant: miscellaneous power plant equipment (USD). |
capex_facilities |
number |
Cost of plant: reservoirs, dams, and waterways (USD). |
capex_land |
number |
Cost of plant: land and land rights (USD). |
capex_per_mw |
number |
Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD. |
capex_roads |
number |
Cost of plant: roads, railroads, and bridges (USD). |
capex_structures |
number |
Cost of plant: structures and improvements (USD). |
capex_total |
number |
Total cost of plant (USD). |
capex_wheels_turbines_generators |
number |
Cost of plant: water wheels, turbines, and generators (USD). |
capex_wo_retirement_total |
number |
Total cost of plant (USD) without retirements. |
construction_type |
string |
Type of plant construction ('outdoor', 'semioutdoor', or 'conventional'). Categorized by PUDL based on our best guess of intended value in FERC1 freeform strings. |
construction_year |
integer |
Year the plant's oldest still operational unit was built. |
energy_used_for_pumping_mwh |
number |
Energy used for pumping, in megawatt-hours. |
ferc_license_id |
string |
The FERC license ID of a project. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_cost_per_mwh |
number |
Derived from MCOE, a unit level value. Average fuel cost per MWh of heat content in nominal USD. |
fuel_type |
string |
N/A |
installation_year |
integer |
Year the plant's most recently built unit was installed. |
license_id_ferc1 |
integer |
FERC issued operating license ID for the facility, if available. This value is extracted from the original plant name where possible. |
net_capacity_adverse_conditions_mw |
number |
Net plant capability under the least favorable operating conditions, in megawatts. |
net_capacity_favorable_conditions_mw |
number |
Net plant capability under the most favorable operating conditions, in megawatts. |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
net_load_mwh |
number |
Net output for load (net generation - energy used for pumping) in megawatt-hours. |
not_water_limited_capacity_mw |
number |
Plant capacity in MW when not limited by condenser water. |
opex_allowances |
number |
Allowances. |
opex_boiler |
number |
Maintenance of boiler (or reactor) plant. |
opex_coolants |
number |
Cost of coolants and water (nuclear plants only) |
opex_dams |
number |
Production expenses: maintenance of reservoirs, dams, and waterways (USD). |
opex_electric |
number |
Production expenses: electric expenses (USD). |
opex_engineering |
number |
Production expenses: maintenance, supervision, and engineering (USD). |
opex_fuel |
number |
Production expenses: fuel (USD). |
opex_generation_misc |
number |
Production expenses: miscellaneous power generation expenses (USD). |
opex_hydraulic |
number |
Production expenses: hydraulic expenses (USD). |
opex_maintenance |
number |
Production expenses: Maintenance (USD). |
opex_misc_plant |
number |
Production expenses: maintenance of miscellaneous hydraulic plant (USD). |
opex_misc_power |
number |
Miscellaneous steam (or nuclear) expenses. |
opex_misc_steam |
number |
Maintenance of miscellaneous steam (or nuclear) plant. |
opex_nonfuel_per_mwh |
number |
Investments in non-fuel production expenses per Mwh. |
opex_operations |
number |
Production expenses: operations, supervision, and engineering (USD). |
opex_per_mwh |
number |
Total production expenses (USD per MWh generated). |
opex_plant |
number |
Production expenses: maintenance of electric plant (USD). |
opex_production_before_pumping |
number |
Total production expenses before pumping (USD). |
opex_production_total |
number |
Total operating expenses. |
opex_pumped_storage |
number |
Production expenses: pumped storage (USD). |
opex_pumping |
number |
Production expenses: We are here to PUMP YOU UP! (USD). |
opex_rents |
number |
Production expenses: rents (USD). |
opex_steam |
number |
Steam expenses. |
opex_steam_other |
number |
Steam from other sources. |
opex_structures |
number |
Production expenses: maintenance of structures (USD). |
opex_total |
number |
Total production expenses, excluding fuel (USD). |
opex_total_nonfuel |
number |
Total production expenses, excluding fuel (USD). |
opex_transfer |
number |
Steam transferred (Credit). |
opex_water_for_power |
number |
Production expenses: water for power (USD). |
peak_demand_mw |
number |
Net peak demand for 60 minutes. Note: in some cases peak demand for other time periods may have been reported instead, if hourly peak demand was unavailable. |
plant_capability_mw |
number |
Net plant capability in megawatts. |
plant_hours_connected_while_generating |
number |
Hours the plant was connected to load while generating in the report year. |
plant_id_ferc1 |
integer |
Algorithmically assigned PUDL FERC Plant ID. WARNING: NOT STABLE BETWEEN PUDL DB INITIALIZATIONS. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_ferc1 |
string |
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant. |
plant_type |
string |
N/A |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
water_limited_capacity_mw |
number |
Plant capacity in MW when limited by condenser water. |
denorm_plants_eia#
Denormalized table containing all EIA plant attributes. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
ash_impoundment |
boolean |
Is there an ash impoundment (e.g. pond, reservoir) at the plant? |
ash_impoundment_lined |
boolean |
If there is an ash impoundment at the plant, is the impoundment lined? |
ash_impoundment_status |
string |
If there is an ash impoundment at the plant, the ash impoundment status as of December 31 of the reporting year. |
balancing_authority_code_eia |
string |
EIA short code identifying a balancing authority. |
balancing_authority_code_eia_consistent_rate |
number |
Percentage consistency of balancing authority code across entity records. |
balancing_authority_name_eia |
string |
Name of the balancing authority. |
city |
string |
N/A |
county |
string |
County name. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
datum |
string |
Geodetic coordinate system identifier (e.g. NAD27, NAD83, or WGS84). |
energy_storage |
boolean |
Indicates if the facility has energy storage capabilities. |
ferc_cogen_docket_no |
string |
The docket number relating to the FERC cogenerator status. See FERC Form 556. |
ferc_cogen_status |
boolean |
Indicates whether the plant has FERC qualifying facility cogenerator status. See FERC Form 556. |
ferc_exempt_wholesale_generator |
boolean |
Indicates whether the plant has FERC qualifying facility exempt wholesale generator status |
ferc_exempt_wholesale_generator_docket_no |
string |
The docket number relating to the FERC qualifying facility exempt wholesale generator status. |
ferc_qualifying_facility_docket_no |
string |
The docket number relating to the FERC qualifying facility cogenerator status. See FERC Form 556. |
ferc_small_power_producer |
boolean |
Indicates whether the plant has FERC qualifying facility small power producer status. See FERC Form 556. |
ferc_small_power_producer_docket_no |
string |
The docket number relating to the FERC qualifying facility small power producer status. See FERC Form 556. |
grid_voltage_1_kv |
number |
Plant's grid voltage at point of interconnection to transmission or distibution facilities |
grid_voltage_2_kv |
number |
Plant's grid voltage at point of interconnection to transmission or distibution facilities |
grid_voltage_3_kv |
number |
Plant's grid voltage at point of interconnection to transmission or distibution facilities |
iso_rto_code |
string |
The code of the plant's ISO or RTO. NA if not reported in that year. |
latitude |
number |
Latitude of the plant's location, in degrees. |
liquefied_natural_gas_storage |
boolean |
Indicates if the facility have the capability to store the natural gas in the form of liquefied natural gas. |
longitude |
number |
Longitude of the plant's location, in degrees. |
natural_gas_local_distribution_company |
string |
Names of Local Distribution Company (LDC), connected to natural gas burning power plants. |
natural_gas_pipeline_name_1 |
string |
The name of the owner or operator of natural gas pipeline that connects directly to this facility or that connects to a lateral pipeline owned by this facility. |
natural_gas_pipeline_name_2 |
string |
The name of the owner or operator of natural gas pipeline that connects directly to this facility or that connects to a lateral pipeline owned by this facility. |
natural_gas_pipeline_name_3 |
string |
The name of the owner or operator of natural gas pipeline that connects directly to this facility or that connects to a lateral pipeline owned by this facility. |
natural_gas_storage |
boolean |
Indicates if the facility have on-site storage of natural gas. |
nerc_region |
string |
NERC region in which the plant is located |
net_metering |
boolean |
Did this plant have a net metering agreement in effect during the reporting year? (Only displayed for facilities that report the sun or wind as an energy source). This field was only reported up until 2015 |
pipeline_notes |
string |
Additional owner or operator of natural gas pipeline. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
primary_purpose_id_naics |
integer |
North American Industry Classification System (NAICS) code that best describes the primary purpose of the reporting plant |
regulatory_status_code |
string |
Indicates whether the plant is regulated or non-regulated. |
report_date |
date |
Date reported. |
reporting_frequency_code |
string |
Code that specifies what time period data has to be reported (i.e. monthly data or annual totals) and how often the power plant reports this data to EIA. See reporting_frequencies_eia for more details. |
sector_id_eia |
integer |
EIA assigned sector ID, corresponding to high level NAICS sector, designated by the primary purpose, regulatory status and plant-level combined heat and power status |
sector_name_eia |
string |
EIA assigned sector name, corresponding to high level NAICS sector, designated by the primary purpose, regulatory status and plant-level combined heat and power status |
service_area |
string |
Service area in which plant is located; for unregulated companies, it's the electric utility with which plant is interconnected |
state |
string |
Two letter US state abbreviation. |
street_address |
string |
N/A |
timezone |
string |
IANA timezone name |
transmission_distribution_owner_id |
integer |
EIA-assigned code for owner of transmission/distribution system to which the plant is interconnected. |
transmission_distribution_owner_name |
string |
Name of the owner of the transmission or distribution system to which the plant is interconnected. |
transmission_distribution_owner_state |
string |
State location for owner of transmission/distribution system to which the plant is interconnected. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
water_source |
string |
Name of water source associated with the plant. |
zip_code |
string |
Five digit US Zip Code. |
denorm_plants_hydro_ferc1#
Denormalized table that contains small plant information from FERC Form 1. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
asset_retirement_cost |
number |
Asset retirement cost (USD). |
avg_num_employees |
number |
N/A |
capacity_factor |
number |
Fraction of potential generation that was actually reported for a plant part. |
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
capex_equipment |
number |
Cost of plant: equipment (USD). |
capex_facilities |
number |
Cost of plant: reservoirs, dams, and waterways (USD). |
capex_land |
number |
Cost of plant: land and land rights (USD). |
capex_per_mw |
number |
Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD. |
capex_roads |
number |
Cost of plant: roads, railroads, and bridges (USD). |
capex_structures |
number |
Cost of plant: structures and improvements (USD). |
capex_total |
number |
Total cost of plant (USD). |
construction_type |
string |
Type of plant construction ('outdoor', 'semioutdoor', or 'conventional'). Categorized by PUDL based on our best guess of intended value in FERC1 freeform strings. |
construction_year |
integer |
Year the plant's oldest still operational unit was built. |
installation_year |
integer |
Year the plant's most recently built unit was installed. |
net_capacity_adverse_conditions_mw |
number |
Net plant capability under the least favorable operating conditions, in megawatts. |
net_capacity_favorable_conditions_mw |
number |
Net plant capability under the most favorable operating conditions, in megawatts. |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
opex_dams |
number |
Production expenses: maintenance of reservoirs, dams, and waterways (USD). |
opex_electric |
number |
Production expenses: electric expenses (USD). |
opex_engineering |
number |
Production expenses: maintenance, supervision, and engineering (USD). |
opex_generation_misc |
number |
Production expenses: miscellaneous power generation expenses (USD). |
opex_hydraulic |
number |
Production expenses: hydraulic expenses (USD). |
opex_misc_plant |
number |
Production expenses: maintenance of miscellaneous hydraulic plant (USD). |
opex_operations |
number |
Production expenses: operations, supervision, and engineering (USD). |
opex_per_mwh |
number |
Total production expenses (USD per MWh generated). |
opex_plant |
number |
Production expenses: maintenance of electric plant (USD). |
opex_rents |
number |
Production expenses: rents (USD). |
opex_structures |
number |
Production expenses: maintenance of structures (USD). |
opex_total |
number |
Total production expenses, excluding fuel (USD). |
opex_total_nonfuel |
number |
Total production expenses, excluding fuel (USD). |
opex_water_for_power |
number |
Production expenses: water for power (USD). |
peak_demand_mw |
number |
Net peak demand for 60 minutes. Note: in some cases peak demand for other time periods may have been reported instead, if hourly peak demand was unavailable. |
plant_hours_connected_while_generating |
number |
Hours the plant was connected to load while generating in the report year. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_ferc1 |
string |
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant. |
plant_type |
string |
N/A |
project_num |
integer |
FERC Licensed Project Number. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
denorm_plants_pumped_storage_ferc1#
Denormalized table that contains pumped storage plant information from FERC Form 1. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
asset_retirement_cost |
number |
Asset retirement cost (USD). |
avg_num_employees |
number |
N/A |
capacity_factor |
number |
Fraction of potential generation that was actually reported for a plant part. |
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
capex_equipment_electric |
number |
Cost of plant: accessory electric equipment (USD). |
capex_equipment_misc |
number |
Cost of plant: miscellaneous power plant equipment (USD). |
capex_facilities |
number |
Cost of plant: reservoirs, dams, and waterways (USD). |
capex_land |
number |
Cost of plant: land and land rights (USD). |
capex_per_mw |
number |
Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD. |
capex_roads |
number |
Cost of plant: roads, railroads, and bridges (USD). |
capex_structures |
number |
Cost of plant: structures and improvements (USD). |
capex_total |
number |
Total cost of plant (USD). |
capex_wheels_turbines_generators |
number |
Cost of plant: water wheels, turbines, and generators (USD). |
construction_type |
string |
Type of plant construction ('outdoor', 'semioutdoor', or 'conventional'). Categorized by PUDL based on our best guess of intended value in FERC1 freeform strings. |
construction_year |
integer |
Year the plant's oldest still operational unit was built. |
energy_used_for_pumping_mwh |
number |
Energy used for pumping, in megawatt-hours. |
installation_year |
integer |
Year the plant's most recently built unit was installed. |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
net_load_mwh |
number |
Net output for load (net generation - energy used for pumping) in megawatt-hours. |
opex_dams |
number |
Production expenses: maintenance of reservoirs, dams, and waterways (USD). |
opex_electric |
number |
Production expenses: electric expenses (USD). |
opex_engineering |
number |
Production expenses: maintenance, supervision, and engineering (USD). |
opex_generation_misc |
number |
Production expenses: miscellaneous power generation expenses (USD). |
opex_misc_plant |
number |
Production expenses: maintenance of miscellaneous hydraulic plant (USD). |
opex_operations |
number |
Production expenses: operations, supervision, and engineering (USD). |
opex_per_mwh |
number |
Total production expenses (USD per MWh generated). |
opex_plant |
number |
Production expenses: maintenance of electric plant (USD). |
opex_production_before_pumping |
number |
Total production expenses before pumping (USD). |
opex_pumped_storage |
number |
Production expenses: pumped storage (USD). |
opex_pumping |
number |
Production expenses: We are here to PUMP YOU UP! (USD). |
opex_rents |
number |
Production expenses: rents (USD). |
opex_structures |
number |
Production expenses: maintenance of structures (USD). |
opex_total |
number |
Total production expenses, excluding fuel (USD). |
opex_total_nonfuel |
number |
Total production expenses, excluding fuel (USD). |
opex_water_for_power |
number |
Production expenses: water for power (USD). |
peak_demand_mw |
number |
Net peak demand for 60 minutes. Note: in some cases peak demand for other time periods may have been reported instead, if hourly peak demand was unavailable. |
plant_capability_mw |
number |
Net plant capability in megawatts. |
plant_hours_connected_while_generating |
number |
Hours the plant was connected to load while generating in the report year. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_ferc1 |
string |
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant. |
project_num |
integer |
FERC Licensed Project Number. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
denorm_plants_small_ferc1#
Denormalized table that contains small plant information from FERC Form 1. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
capex_per_mw |
number |
Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD. |
capex_total |
number |
Total cost of plant (USD). |
construction_year |
integer |
Year the plant's oldest still operational unit was built. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_type |
string |
N/A |
license_id_ferc1 |
integer |
FERC issued operating license ID for the facility, if available. This value is extracted from the original plant name where possible. |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
opex_fuel |
number |
Production expenses: fuel (USD). |
opex_maintenance |
number |
Production expenses: Maintenance (USD). |
opex_operations |
number |
Production expenses: operations, supervision, and engineering (USD). |
opex_total |
number |
Total production expenses, excluding fuel (USD). |
opex_total_nonfuel |
number |
Total production expenses, excluding fuel (USD). |
peak_demand_mw |
number |
Net peak demand for 60 minutes. Note: in some cases peak demand for other time periods may have been reported instead, if hourly peak demand was unavailable. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_ferc1 |
string |
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant. |
plant_type |
string |
N/A |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
denorm_plants_steam_ferc1#
Denormalized table that contains steam plant information from FERC Form 1. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
asset_retirement_cost |
number |
Asset retirement cost (USD). |
avg_num_employees |
number |
N/A |
capacity_factor |
number |
Fraction of potential generation that was actually reported for a plant part. |
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
capex_annual_addition |
number |
Annual capital addition into capex_total. |
capex_annual_addition_rolling |
number |
Year-to-date capital addition into capex_total. |
capex_annual_per_kw |
number |
Annual capital addition into capex_total per kw. |
capex_annual_per_mw |
number |
Annual capital addition into capex_total per MW. |
capex_annual_per_mw_rolling |
number |
Year-to-date capital addition into capex_total per MW. |
capex_annual_per_mwh |
number |
Annual capital addition into capex_total per MWh. |
capex_annual_per_mwh_rolling |
number |
Year-to-date capital addition into capex_total per MWh. |
capex_equipment |
number |
Cost of plant: equipment (USD). |
capex_land |
number |
Cost of plant: land and land rights (USD). |
capex_per_mw |
number |
Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD. |
capex_structures |
number |
Cost of plant: structures and improvements (USD). |
capex_total |
number |
Total cost of plant (USD). |
capex_wo_retirement_total |
number |
Total cost of plant (USD) without retirements. |
construction_type |
string |
Type of plant construction ('outdoor', 'semioutdoor', or 'conventional'). Categorized by PUDL based on our best guess of intended value in FERC1 freeform strings. |
construction_year |
integer |
Year the plant's oldest still operational unit was built. |
installation_year |
integer |
Year the plant's most recently built unit was installed. |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
not_water_limited_capacity_mw |
number |
Plant capacity in MW when not limited by condenser water. |
opex_allowances |
number |
Allowances. |
opex_boiler |
number |
Maintenance of boiler (or reactor) plant. |
opex_coolants |
number |
Cost of coolants and water (nuclear plants only) |
opex_electric |
number |
Production expenses: electric expenses (USD). |
opex_engineering |
number |
Production expenses: maintenance, supervision, and engineering (USD). |
opex_fuel |
number |
Production expenses: fuel (USD). |
opex_fuel_per_mwh |
number |
Production expenses: fuel (USD) per megawatt-hour (Mwh). |
opex_misc_power |
number |
Miscellaneous steam (or nuclear) expenses. |
opex_misc_steam |
number |
Maintenance of miscellaneous steam (or nuclear) plant. |
opex_nonfuel_per_mwh |
number |
Investments in non-fuel production expenses per Mwh. |
opex_operations |
number |
Production expenses: operations, supervision, and engineering (USD). |
opex_per_mwh |
number |
Total production expenses (USD per MWh generated). |
opex_plants |
number |
Maintenance of electrical plant. |
opex_production_total |
number |
Total operating expenses. |
opex_rents |
number |
Production expenses: rents (USD). |
opex_steam |
number |
Steam expenses. |
opex_steam_other |
number |
Steam from other sources. |
opex_structures |
number |
Production expenses: maintenance of structures (USD). |
opex_total_nonfuel |
number |
Total production expenses, excluding fuel (USD). |
opex_transfer |
number |
Steam transferred (Credit). |
peak_demand_mw |
number |
Net peak demand for 60 minutes. Note: in some cases peak demand for other time periods may have been reported instead, if hourly peak demand was unavailable. |
plant_capability_mw |
number |
Net plant capability in megawatts. |
plant_hours_connected_while_generating |
number |
Hours the plant was connected to load while generating in the report year. |
plant_id_ferc1 |
integer |
Algorithmically assigned PUDL FERC Plant ID. WARNING: NOT STABLE BETWEEN PUDL DB INITIALIZATIONS. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_ferc1 |
string |
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant. |
plant_type |
string |
N/A |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
water_limited_capacity_mw |
number |
Plant capacity in MW when limited by condenser water. |
denorm_plants_utilities_eia#
Denormalized table containing all plant and utility IDs and names from EIA. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
report_date |
date |
Date reported. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
denorm_plants_utilities_ferc1#
Denormalized table that contains FERC plant and utility information. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_ferc1 |
string |
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
denorm_purchased_power_ferc1#
Denormalized table of FERC Form 1 Purchased Power data. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
billing_demand_mw |
number |
Monthly average billing demand (for requirements purchases, and any transactions involving demand charges). In megawatts. |
coincident_peak_demand_mw |
number |
Average monthly coincident peak (CP) demand (for requirements purchases, and any transactions involving demand charges). Monthly CP demand is the metered demand during the hour (60-minute integration) in which the supplier's system reaches its monthly peak. In megawatts. |
delivered_mwh |
number |
Gross megawatt-hours delivered in power exchanges and used as the basis for settlement. |
demand_charges |
number |
Demand charges (USD). |
energy_charges |
number |
Energy charges (USD). |
non_coincident_peak_demand_mw |
number |
Average monthly non-coincident peak (NCP) demand (for requirements purhcases, and any transactions involving demand charges). Monthly NCP demand is the maximum metered hourly (60-minute integration) demand in a month. In megawatts. |
other_charges |
number |
Other charges, including out-of-period adjustments (USD). |
purchase_type_code |
string |
Categorization based on the original contractual terms and conditions of the service. Must be one of 'requirements', 'long_firm', 'intermediate_firm', 'short_firm', 'long_unit', 'intermediate_unit', 'electricity_exchange', 'other_service', or 'adjustment'. Requirements service is ongoing high reliability service, with load integrated into system resource planning. 'Long term' means 5+ years. 'Intermediate term' is 1-5 years. 'Short term' is less than 1 year. 'Firm' means not interruptible for economic reasons. 'unit' indicates service from a particular designated generating unit. 'exchange' is an in-kind transaction. |
purchased_mwh |
number |
Megawatt-hours shown on bills rendered to the respondent. Includes both electricity purchased for storage and non-storage purposes, which were lumped together prior to 2021. |
purchased_other_than_storage_mwh |
number |
Number of megawatt hours purchased during the period for other than energy storage. |
purchased_storage_mwh |
number |
Number of megawatt hours purchased during the period for energy storage. |
received_mwh |
number |
Gross megawatt-hours received in power exchanges and used as the basis for settlement. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
seller_name |
string |
Name of the seller, or the other party in an exchange transaction. |
tariff |
string |
FERC Rate Schedule Number or Tariff. (Note: may be incomplete if originally reported on multiple lines.) |
total_settlement |
number |
Sum of demand, energy, and other charges (USD). For power exchanges, the settlement amount for the net receipt of energy. If more energy was delivered than received, this amount is negative. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
denorm_retained_earnings_ferc1#
Denormalized table that contains FERC retained earnings information. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balance |
string |
Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy. |
earnings_type |
string |
Label describing types of earnings. |
ending_balance |
number |
Account balance at end of year. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
starting_balance |
number |
Account balance at beginning of year. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
denorm_transmission_statistics_ferc1#
Denormalized table that contains FERC transmission statistics information. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
capex_land |
number |
Cost of plant: land and land rights (USD). |
capex_other |
number |
Other costs associated with the plant (USD). |
capex_total |
number |
Total cost of plant (USD). |
conductor_size_and_material |
string |
Size of transmission conductor and material of the transmission line. |
designed_voltage_kv |
number |
Manufactured (Designed) voltage, expressed in kilo-volts, for three-phase 60 cycle alternative current transmission lines |
end_point |
string |
The end point of a transmission line. |
num_transmission_circuits |
integer |
Number of circuits in a transmission line. |
operating_voltage_kv |
number |
The operating voltage, expressed kilo-volts, for three-phase 60 cycle alternative current transmission lines. |
opex_maintenance |
number |
Production expenses: Maintenance (USD). |
opex_operations |
number |
Production expenses: operations, supervision, and engineering (USD). |
opex_rents |
number |
Production expenses: rents (USD). |
opex_total |
number |
Total production expenses, excluding fuel (USD). |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
start_point |
string |
The starting point of a transmission line. |
supporting_structure_type |
string |
Supporting structure of the transmission line. |
transmission_line_and_structures_length_miles |
number |
Length (in pole miles or circuit miles (if transmission lines are underground)) for lines that are agrregated with other lines / structures (whose cost are aggregated and combined with other structures). |
transmission_line_length_miles |
number |
Length (in pole miles or circuit miles (if transmission lines are underground)) for lines that are stand alone structures (whose cost are reported on a stand-alone basis). |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
denorm_utilities_eia#
Denormalized table containing all EIA utility attributes. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
address_2 |
string |
N/A |
attention_line |
string |
N/A |
city |
string |
N/A |
contact_firstname |
string |
First name of utility contact 1. |
contact_firstname_2 |
string |
First name of utility contact 2. |
contact_lastname |
string |
Last name of utility contact 1. |
contact_lastname_2 |
string |
Last name of utility contact 2. |
contact_title |
string |
Title of of utility contact 1. |
contact_title_2 |
string |
Title of utility contact 2. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
entity_type |
string |
Entity type of principal owner. |
phone_extension |
string |
Phone extension for utility contact 1 |
phone_extension_2 |
string |
Phone extension for utility contact 2 |
phone_number |
string |
Phone number for utility contact 1. |
phone_number_2 |
string |
Phone number for utility contact 2. |
plants_reported_asset_manager |
boolean |
Is the reporting entity an asset manager of power plants reported on Schedule 2 of the form? |
plants_reported_operator |
boolean |
Is the reporting entity an operator of power plants reported on Schedule 2 of the form? |
plants_reported_other_relationship |
boolean |
Does the reporting entity have any other relationship to the power plants reported on Schedule 2 of the form? |
plants_reported_owner |
boolean |
Is the reporting entity an owner of power plants reported on Schedule 2 of the form? |
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
street_address |
string |
N/A |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
zip_code |
string |
Five digit US Zip Code. |
zip_code_4 |
string |
Four digit US Zip Code suffix. |
denorm_utility_plant_summary_ferc1#
Denormalized table that contains FERC utility plant summary information. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
ending_balance |
number |
Account balance at end of year. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
utility_plant_asset_type |
string |
Type of utility plant asset reported in the utility_plant_summary_ferc1 table. Assets include those leased to others, held for future use, construction work-in-progress and details of accumulated depreciation. |
utility_type |
string |
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility. |
utility_type_other |
string |
Freeform description of type of utility reported in one of the other three other utility_type sections in the utility_plant_summary_ferc1 table. This field is reported only in the DBF reporting years (1994-2020). |
depreciation_amortization_summary_ferc1#
Depreciation and Amortization of Electric Plant (Account 403, 404, 405) Section A: Summary of depreciation and amortization changes. Schedule 336a of FERC Form 1. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
dollar_value |
number |
Dollar value of reported income, expense, asset, or liability. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
ferc_account_label |
string |
Long FERC account identifier derived from values reported in the XBRL taxonomies. May also refer to aggregations of individual FERC accounts. |
plant_function |
string |
Functional role played by utility plant (steam production, nuclear production, distribution, transmission, etc.). |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_type |
string |
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility. |
distributed_generation_fuel_eia861#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
estimated_or_actual_fuel_data |
string |
N/A |
fuel_class |
string |
N/A |
fuel_pct |
number |
N/A |
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
distributed_generation_misc_eia861#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
backup_capacity_mw |
number |
N/A |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
distributed_generation_owned_capacity_mw |
number |
N/A |
estimated_or_actual_capacity_data |
string |
N/A |
generators_num_less_1_mw |
number |
N/A |
generators_number |
number |
N/A |
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
total_capacity_less_1_mw |
number |
N/A |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
distributed_generation_tech_eia861#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
estimated_or_actual_tech_data |
string |
N/A |
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
tech_class |
string |
N/A |
utility_id_eia |
integer |
The EIA Utility Identification number. |
distribution_systems_eia861#
The number of distribution circuits and circuits with voltage optimization by state. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
circuits_with_voltage_optimization |
integer |
N/A |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
distribution_circuits |
integer |
N/A |
report_date |
date |
Date reported. |
short_form |
boolean |
N/A |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
dynamic_pricing_eia861#
The number of customers enrolled in dynamic pricing programs by state, sector, and balancing authority. Respondents check if one or more customers are enrolled in time-of-use pricing, real time pricing, variable peak pricing, critical peak pricing, and critical peak rebates. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balancing_authority_code_eia |
string |
EIA short code identifying a balancing authority. |
critical_peak_pricing |
boolean |
N/A |
critical_peak_rebate |
boolean |
N/A |
customer_class |
string |
High level categorization of customer type. |
customers |
number |
Number of customers. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
real_time_pricing |
boolean |
N/A |
report_date |
date |
Date reported. |
short_form |
boolean |
N/A |
state |
string |
Two letter US state abbreviation. |
time_of_use_pricing |
boolean |
N/A |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
variable_peak_pricing |
boolean |
N/A |
electric_energy_dispositions_ferc1#
Electric Energy Account, dispositions only. Schedule 401a. Electricity utilities delived to end users, internal losses, etc. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
energy_disposition_type |
string |
Type of energy disposition reported in the electric_energy_dispositions_ferc1. Dispositions include sales to customers, re-sales of energy, energy used internally, losses, etc. |
energy_mwh |
number |
Sources and uses of energy in MWh. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
electric_energy_sources_ferc1#
Electric Energy Account, sources only. Schedule 401a. Amount of electricity the utility obtained from each of several sources, by year. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
energy_mwh |
number |
Sources and uses of energy in MWh. |
energy_source_type |
string |
Type of energy source reported in the electric_energy_sources_ferc1 table. There are three groups of energy sources: generation, power exchanges and transmission. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
electric_operating_expenses_ferc1#
Operating and maintenance costs associated with producing electricty, reported in Schedule 320 of FERC Form 1. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
dollar_value |
number |
Dollar value of reported income, expense, asset, or liability. |
expense_type |
string |
The type of expense. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_type |
string |
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility. |
electric_operating_revenues_ferc1#
Electric operating revenues - The structed part of schedule 300.There are a number of revenue_type's that do not have sales_mwh,or avg_customers_per_month provided, in which case these columnswill be NULL. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
avg_customers_per_month |
number |
Average number of customers per month. |
dollar_value |
number |
Dollar value of reported income, expense, asset, or liability. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
revenue_type |
string |
Label describing types of revenues. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
sales_mwh |
number |
Quantity of electricity sold in MWh. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_type |
string |
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility. |
electric_plant_depreciation_changes_ferc1#
Accumulated provision for depreciation of electric utility plant (Account 108). Schedule 219 Section A: balances and changes during year. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balance |
string |
Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy. |
depreciation_type |
string |
Type of depreciation provision within FERC Account 108, including cost ofremoval, depreciation expenses, salvage, cost of retired plant, etc. |
dollar_value |
number |
Dollar value of reported income, expense, asset, or liability. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
plant_status |
string |
Utility plant financial status (in service, future, leased, total). |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_type |
string |
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility. |
electric_plant_depreciation_functional_ferc1#
Accumulated provision for depreciation of electric utility plant (Account 108). Schedule 219 Section B: Functional plant classifications. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balance |
string |
Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy. |
depreciation_type |
string |
Type of depreciation provision within FERC Account 108, including cost ofremoval, depreciation expenses, salvage, cost of retired plant, etc. |
ending_balance |
number |
Account balance at end of year. |
plant_function |
string |
Functional role played by utility plant (steam production, nuclear production, distribution, transmission, etc.). |
plant_status |
string |
Utility plant financial status (in service, future, leased, total). |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_type |
string |
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility. |
electricity_sales_by_rate_schedule_ferc1#
The pre-2021 data in this table (extracted from FoxProDB vs. XBRL) is extremely unstructured. Where the post-2020 data (from XBRL) sorts the data into rate schedule types: residential, industrial, commercial, public_lighting, public_authorities, railroads, interdepartmental, provision_for_rate_refund, commercial_and_industrial, total, and billing status: billed, unbilled, total, the pre-2021 data stuffs all of that information (if you're lucky) into the rate_schedule_description column. There's no point trying to parse through the pre 2021 rate_schedule_description column en masse because it's just too messy. The contents of rate_schedule_description often contain numbers and acronyms that have little to no meaning out of context. The table is structured somewhat like the FERC1 small generators table with headings about rate structure type also embedded into the rate_schedule_description column. To all who dare, beware.
This table is a combination of one pre-2021 (DBF) table and nine post-2020 (XBRL) tables–one for each rate schedule type plus totals–hence increase in data clarity post-2020. The rate_schedule_type and billing_status columns are only relevant for post-2020 data as they can be reliably parsed from each of the tables and incorporated into columns. The rate_schedule_description is supposed to contain sub-rate_schedule_type names for charges (Ex: Residential 1, Residential 2, etc.). However, the pre-2021 data contains a little bit of everything (or nothing) and the post-2020 has some totals or wonky data thrown in. That's to say, even when working with post-2020 data, be wary of aggregating the data. That's what the "total" rows are for.
The values that come from from the totals table are marked with the string "total" in the rate_schedule_description column. The totals table is a product of the transition to XBRL, so these distinguishable totals are only available for data post-2020 (otherwise you could try keyword searching for "total" in rate_schedule_description). The total table contains two types of totals, the utility totals accross all rate schedules in a given year (marked with rate_schedule_description = "total" and rate_schedule_type = "total") and each of the utility's individual rate schedule totals in a given year (marked with rate_schedule_description = "total" and rate_schdedule_type = "residential" or any other rate schdedule type).
The rate schedule based XBRL tables only report billed values whereas the total tables report billed, unbilled, and total values. (See the column description for more info on the difference between billed and unbilled). This is important to consider if you're endeavoring to compare the subtotal values with the total values. We have not attempted to fix or verify any subtotals or totals that don't add up.
Another important note is the possability of unit discrepancies in certain columns. The revenue_per_kwh column does not specify reporting units, and closer inspection of the data reveals two clear peaks approximate two orders of magnitude appart. This indicates that values may be reported in both dollars and cents. However, because the price of energy per kwh varies so much regionally, we cannot guarantee which is which and have not put any cleaning mechanisms in place to account for this. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
avg_customers_per_month |
number |
Average number of customers per month. |
billing_status |
string |
Whether an amount is billed, unbilled, or both. Billed amounts pertain to the exchange of energy and unbilled amounts pertain to other sources of revenue such as contracts with peaker plants to keep them on standby or charging rent to host cell antennas on transmission towers. |
dollar_value |
number |
Dollar value of reported income, expense, asset, or liability. |
kwh_per_customer |
number |
kwh per customer. |
rate_schedule_description |
string |
Free-form description of what the rate schedule name is. Not standardized. Often a sub-category of rate_schedule_type. |
rate_schedule_type |
string |
Categorization of rate schedule type. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
revenue_per_kwh |
number |
N/A |
sales_mwh |
number |
Quantity of electricity sold in MWh. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
emission_control_equipment_types_eia#
A coding table describing the type of emissions control equipment installed on a boiler. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
emissions_control_equipment_eia860#
The cost, type, operating status, retirement date, and install year of emissions control equipment reported to EIA. Includes control ids for sulfur dioxide (SO2), particulate matter, mercury, nitrogen oxide (NOX), and acid (HCl) gas monitoring. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
acid_gas_control |
boolean |
Indicates whether the emissions control equipment controls acid (HCl) gas. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
emission_control_equipment_cost |
number |
The total cost to install a piece of emission control equipment. |
emission_control_equipment_type_code |
string |
Short code indicating the type of emission control equipment installed. |
emission_control_id_pudl |
number |
A PUDL-generated ID used to distinguish emission control units in the same report year and plant id. This ID should not be used to track units over time or between plants. |
emission_control_operating_date |
date |
The date a piece of emissions control equipment began operating. Derived from month and year columns in the raw data. |
emission_control_retirement_date |
date |
The expected or actual retirement date for a piece of emissions control equipment. Derived from month and year columns in the raw data. |
mercury_control_id_eia |
string |
Mercury control identification number. This ID is not a unique identifier. |
nox_control_id_eia |
string |
Nitrogen oxide control identification number. This ID is not a unique identifier. |
operational_status_code |
string |
The operating status of the asset. |
particulate_control_id_eia |
string |
Particulate matter control identification number. This ID is not a unique identifier. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
report_year |
integer |
Four-digit year in which the data was reported. |
so2_control_id_eia |
string |
Sulfur dioxide control identification number. This ID is not a unique identifier. |
energy_efficiency_eia861#
Incremental energy savings, peak demand savings, weighted average life cycle, and associated costs for the reporting year and life cycle of energy efficiency programs. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balancing_authority_code_eia |
string |
EIA short code identifying a balancing authority. |
customer_class |
string |
High level categorization of customer type. |
customer_incentives_incremental_cost |
number |
N/A |
customer_incentives_incremental_life_cycle_cost |
number |
N/A |
customer_other_costs_incremental_life_cycle_cost |
number |
N/A |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
incremental_energy_savings_mwh |
number |
N/A |
incremental_life_cycle_energy_savings_mwh |
number |
N/A |
incremental_life_cycle_peak_reduction_mwh |
number |
N/A |
incremental_peak_reduction_mw |
number |
N/A |
other_costs_incremental_cost |
number |
N/A |
report_date |
date |
Date reported. |
short_form |
boolean |
N/A |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
weighted_average_life_years |
number |
N/A |
energy_sources_eia#
Codes and metadata pertaining to energy sources reported to EIA. Compiled from EIA-860 instructions and EIA-923 file layout spreadsheets. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
fuel_derived_from |
string |
Original fuel from which this refined fuel was derived. |
fuel_group_eia |
string |
High level fuel group defined in the 2021-2023 EIA Form 860 instructions, Table 28. |
fuel_phase |
string |
Physical phase of matter of the fuel. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
fuel_units |
string |
Reported unit of measure for fuel. |
label |
string |
Longer human-readable code using snake_case |
max_fuel_mmbtu_per_unit |
number |
Maximum heat content per physical unit of fuel in MMBtu. |
min_fuel_mmbtu_per_unit |
number |
Minimum heat content per physical unit of fuel in MMBtu. |
entity_types_eia#
Descriptive labels for EIA entity type and ownership codes, taken from the EIA-861 form instructions, valid through 2023-05-31. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
environmental_equipment_manufacturers_eia#
A coding table describing manufacturers of boilers and environmental control equipment in the EIA-860. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
epacamd_eia#
This crosswalk table comes from the EPA's Github repo camd-eia-crosswalk: https://github.com/USEPA/camd-eia-crosswalk. It's purpose is to connect EPA units with EIA plants, boilers, and generators. The camd-eia-crosswalk README and our Data Source documentation page on EPA Hourly Continuous Emission Monitoring System (CEMS) depict the complicated relationship between EIA and EPA data, specifically the nature of EPA vs. EIA "units" and the level of granularity that one can connect the two sources.
The crosswalk table is generated using EIA data from 2018 meaning that any plants that have shifted before or since then aren't accurately reflected in the data. We're hoping to create a temporal version of the crosswalk at some point.
Our version of the crosswalk clarifies some of the column names and removes
unmatched
rows. The pudl.etl.glue_assets.epacamd_eia()
function doc strings
explain
what changes are made from the EPA's version.
Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
boiler_id |
string |
Alphanumeric boiler ID. |
emissions_unit_id_epa |
string |
Emissions (smokestack) unit monitored by EPA CEMS. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
generator_id_epa |
string |
Generator ID used by the EPA. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_epa |
integer |
The ORISPL ID used by EPA to refer to the plant. Usually but not always the same as plant_id_eia. |
report_year |
integer |
Four-digit year in which the data was reported. |
epacamd_eia_subplant_ids#
This table is an augmented version of the epacamd_eia crosswalk table which initally comes from the EPA's Github repo camd-eia- crosswalk: https://github.com/USEPA/camd-eia-crosswalk. It's purpose is to connect EPA units with EIA units, and generators.
This table identifies subplants within plant_ids, which are the smallest coherent units for aggregation. plant_id refers to a legal entity that often contains multiple distinct power plants, even of different technology or fuel types.
EPA CEMS data combines information from several parts of a power plant: * emissions from smokestacks * fuel use from combustors * electricty production from generators But smokestacks, combustors, and generators can be connected in complex, many- to-many relationships. This complexity makes attribution difficult for, as an example, allocating pollution to energy producers. Furthermore, heterogeneity within plant_ids make aggregation to the parent entity difficult or inappropriate.
This table inherits from the EPA's crosswalk, the ID's from EPA CAMD hourly_emissions_epacems table itself, the boiler_generator_assn_eia860 table and the generators_eia860 table. While the epacamd_eia table is the core backbone of the table, EPA CAMD id's ensure there is complete coverage of EPA CAMD reporting units. The EIA 860 table addition ensures there is also complete coverage of those units as well.
For more information about the how this subplant_id is made, see the documentation for pudl.etl.glue_assets.make_subplant_ids and pudl.etl.glue_assets.update_subplant_ids from: https://catalystcoop-pudl.readthedocs.io/en/latest/autoapi/index.html
But by analyzing the relationships between combustors and generators, as provided in the epacamd_eia crosswalk, we can identify distinct power plants. These are the smallest coherent units of aggregation.
This table does not have primary keys because the primary keys would have been: plant_id_eia, generator_id, subplant_id and emissions_unit_id_epa, but there are some null records in the generator_id column because ~2 percent of all EPA CAMD records are not successfully mapped to EIA generators. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
emissions_unit_id_epa |
string |
Emissions (smokestack) unit monitored by EPA CEMS. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_epa |
integer |
The ORISPL ID used by EPA to refer to the plant. Usually but not always the same as plant_id_eia. |
subplant_id |
integer |
Sub-plant ID links EPA CEMS emissions units to EIA units. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
ferc_accounts#
Account numbers from the FERC Uniform System of Accounts for Electric Plant, which is defined in Code of Federal Regulations (CFR) Title 18, Chapter I, Subchapter C, Part 101. (See e.g. https://www.law.cornell.edu/cfr/text/18/part-101). Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
ferc_account_description |
string |
N/A |
ferc_account_id |
string |
Account identifier from FERC's Uniform System of Accounts for Electric Plant. Includes higher level labeled categories. |
fipsified_respondents_ferc714#
Annual respondents with the county FIPS IDs for their service territories. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balancing_authority_code_eia |
string |
EIA short code identifying a balancing authority. |
balancing_authority_id_eia |
integer |
EIA balancing authority ID. This is often (but not always!) the same as the utility ID associated with the same legal entity. |
balancing_authority_name_eia |
string |
Name of the balancing authority. |
county |
string |
County name. |
county_id_fips |
string |
County ID from the Federal Information Processing Standard Publication 6-4. |
eia_code |
integer |
N/A |
report_date |
date |
Date reported. |
respondent_id_ferc714 |
integer |
N/A |
respondent_name_ferc714 |
string |
N/A |
respondent_type |
string |
N/A |
state |
string |
Two letter US state abbreviation. |
state_id_fips |
string |
Two digit state FIPS code. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
firing_types_eia#
A coding table describing different boiler firing types in the EIA-860. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
fuel_cost_by_generator_monthly#
Monthly estimate of per-generator fuel costs both per MMBTU and per MWh. These calculations are based on the allocation of net generation and fuel consumption as well as plant-level delivered fuel prices reported in the fuel receipts and cost table. The intermediary heat rate calculation depends on having the unit ID filled in, which means fuel cost coverage is low. The fuel costs are also currently aggregated to coarse fuel categories rather than using the more detailed energy source codes.Note that the values in this table are unfiltered and we expect some of the values are unreasonable and out of bounds.This table should not be used without filtering values to within logical boundaries. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
fuel_cost_from_eiaapi |
boolean |
Indicates whether the fuel cost was derived from the EIA API. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_cost_per_mwh |
number |
Derived from MCOE, a unit level value. Average fuel cost per MWh of heat content in nominal USD. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
fuel_type_count |
integer |
A count of how many different simple energy sources there are associated with a generator. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
heat_rate_mmbtu_mwh |
number |
Fuel content per unit of electricity generated. Coming from MCOE calculation. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
report_date |
date |
Date reported. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
fuel_cost_by_generator_yearly#
Yearly estimate of per-generator fuel costs both per MMBTU and per MWh. These calculations are based on the allocation of net generation and fuel consumption as well as plant-level delivered fuel prices reported in the fuel receipts and cost table. The intermediary heat rate calculation depends on having the unit ID filled in, which means fuel cost coverage is low. The fuel costs are also currently aggregated to coarse fuel categories rather than using the more detailed energy source codes.Note that the values in this table are unfiltered and we expect some of the values are unreasonable and out of bounds.This table should not be used without filtering values to within logical boundaries. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
fuel_cost_from_eiaapi |
boolean |
Indicates whether the fuel cost was derived from the EIA API. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_cost_per_mwh |
number |
Derived from MCOE, a unit level value. Average fuel cost per MWh of heat content in nominal USD. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
fuel_type_count |
integer |
A count of how many different simple energy sources there are associated with a generator. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
heat_rate_mmbtu_mwh |
number |
Fuel content per unit of electricity generated. Coming from MCOE calculation. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
report_date |
date |
Date reported. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
fuel_ferc1#
Annual fuel cost and quantity for steam plants with a capacity of 25+ MW, internal combustion and gas-turbine plants of 10+ MW, and all nuclear plants. As reported on page 402 of FERC Form 1 and extracted from the f1_fuel table in FERC's FoxPro Database. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
fuel_consumed_units |
number |
Consumption of the fuel type in physical unit. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_cost_per_unit_burned |
number |
Average cost of fuel consumed in the report year per reported fuel unit (USD). |
fuel_cost_per_unit_delivered |
number |
Average cost of fuel delivered in the report year per reported fuel unit (USD). |
fuel_mmbtu_per_unit |
number |
Heat content of the fuel in millions of Btus per physical unit. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
fuel_units |
string |
Reported unit of measure for fuel. |
plant_name_ferc1 |
string |
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
fuel_receipts_costs_aggs_eia#
Aggregated fuel receipts and costs from the EIA bulk electricty data. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
fuel_agg |
string |
Category of fuel aggregation in EIA bulk electricity data. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_received_mmbtu |
number |
Aggregated fuel receipts, in MMBtu, in EIA bulk electricity data. |
geo_agg |
string |
Category of geographic aggregation in EIA bulk electricity data. |
report_date |
date |
Date reported. |
sector_agg |
string |
Category of sectoral aggregation in EIA bulk electricity data. |
temporal_agg |
string |
Category of temporal aggregation in EIA bulk electricity data. |
fuel_receipts_costs_eia923#
Data describing fuel deliveries to power plants, reported in EIA-923 Schedule 2, Part A.
Each record describes an individual fuel delivery. There can be multiple deliveries of the same type of fuel from the same supplier to the same plant in a single month, so the table has no natural primary key.
There can be a significant delay between the receipt of fuel and its consumption, so using this table to infer monthly attributes associated with power generation may not be entirely accurate. However, this is the most granular data we have describing fuel costs, and we use it in calculating the marginal cost of electricity for individual generation units.
Under some circumstances utilities are allowed to treat the price of fuel as proprietary business data, meaning it is redacted from the publicly available spreadsheets. It's still reported to EIA and influences the aggregated (state, region, annual, etc.) fuel prices they publish. From 2009-2021 about 1/3 of all prices are redacted. The missing data is not randomly distributed. Deregulated markets dominated by merchant generators (independent power producers) redact much more data, and natural gas is by far the most likely fuel to have its price redacted. This means, for instance, that the entire Northeastern US reports essentially no fine-grained data about its natural gas prices.
Additional data which we haven't yet integrated is available in a similar format from 2002-2008 via the EIA-423, and going back as far as 1972 from the FERC-423. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
ash_content_pct |
number |
Ash content percentage by weight to the nearest 0.1 percent. |
chlorine_content_ppm |
number |
N/A |
contract_expiration_date |
date |
Date contract expires.Format: MMYY. |
contract_type_code |
string |
Purchase type under which receipts occurred in the reporting month. C: Contract, NC: New Contract, S: Spot Purchase, T: Tolling Agreement. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
energy_source_code |
string |
A 2-3 letter code indicating the energy source (e.g. fuel type) associated with the record. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_group_code |
string |
Fuel groups used in the Electric Power Monthly |
fuel_mmbtu_per_unit |
number |
Heat content of the fuel in millions of Btus per physical unit. |
fuel_received_units |
number |
Quanity of fuel received in tons, barrel, or Mcf. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
mercury_content_ppm |
number |
Mercury content in parts per million (ppm) to the nearest 0.001 ppm. |
mine_id_pudl |
integer |
Dynamically assigned PUDL mine identifier. |
moisture_content_pct |
number |
N/A |
natural_gas_delivery_contract_type_code |
string |
Contract type for natrual gas delivery service: |
natural_gas_transport_code |
string |
Contract type for natural gas transportation service. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
primary_transportation_mode_code |
string |
Transportation mode for the longest distance transported. |
report_date |
date |
Date reported. |
secondary_transportation_mode_code |
string |
Transportation mode for the second longest distance transported. |
sulfur_content_pct |
number |
Sulfur content percentage by weight to the nearest 0.01 percent. |
supplier_name |
string |
Company that sold the fuel to the plant or, in the case of Natural Gas, pipline owner. |
fuel_transportation_modes_eia#
Long descriptions of the fuel transportation modes reported in the EIA-860 and EIA-923. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
fuel_types_aer_eia#
Descriptive labels for aggregated fuel types used in the Annual Energy Review. See EIA-923 Fuel Code table for additional information. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
generation_eia923#
EIA-923 Monthly Generating Unit Net Generation. From EIA-923 Schedule 3.
Reports the net electricity generated by each reporting generator on a monthly
basis.
This is the most granular information we have about how much electricity
individual
generators are producing, but only about half of all the generation reported
in the
generation_fuel_eia923
appears in this table due to the different
reporting
requirements imposed on different types and sizes of generators.
Whenever possible, we use this generator-level net generation to estimate the heat rates of generation units and the marginal cost of electricity on a per-generator basis, but those calculations depend on plant-level fuel costs and sometimes uncertain or incomplete boiler-generator associations.
Note that a small number of respondents only report annual net generation, and all of it is reported in December. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
report_date |
date |
Date reported. |
generation_fuel_by_generator_energy_source_monthly_eia923#
Monthly estimated net generation and fuel consumption associated with each combination of generator, energy source, and prime mover. First, the net electricity generation and fuel consumption reported in the EIA-923 generation fuel are allocated to individual generators. Then, these allocations are aggregated to unique generator, prime mover, and energy source code combinations. This process does not distinguish between primary and secondary energy_sources for generators. Net generation is allocated equally between energy source codes, so if a plant has multiple generators with the same prime_mover_code but different energy source codes the generation_fuel_eia923 records will be associated similarly between these two generators. Allocated net generation will still be proportional to each generator's net generation or capacity. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
energy_source_code |
string |
A 2-3 letter code indicating the energy source (e.g. fuel type) associated with the record. |
energy_source_code_num |
string |
Name of the energy_source_code_N column that this energy source code was reported in for the generator referenced in the same record. |
fuel_consumed_for_electricity_mmbtu |
number |
Total consumption of fuel to produce electricity, in physical unit, year to date. |
fuel_consumed_mmbtu |
number |
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
report_date |
date |
Date reported. |
generation_fuel_by_generator_energy_source_owner_yearly_eia923#
Yearly estimated net generation and fuel consumption for each generator, associated with each combination of generator, energy source, prime mover, and owner. First, the net electricity generation and fuel consumption reported in the EIA-923 generation fuel are allocated to individual generators. Then, these allocations are aggregated to unique generator, prime mover, energy source code, and owner combinations. Note that the utility_id_eia in this table refers to the OWNER of the generator, not the operator. This process does not distinguish between primary and secondary energy_sources for generators. Net generation is allocated equally between energy source codes, so if a plant has multiple generators with the same prime_mover_code but different energy source codes the generation_fuel_eia923 records will be associated similarly between these two generators. Allocated net generation will still be proportional to each generator's net generation or capacity. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
energy_source_code |
string |
A 2-3 letter code indicating the energy source (e.g. fuel type) associated with the record. |
energy_source_code_num |
string |
Name of the energy_source_code_N column that this energy source code was reported in for the generator referenced in the same record. |
fraction_owned |
number |
Proportion of generator ownership attributable to this utility. |
fuel_consumed_for_electricity_mmbtu |
number |
Total consumption of fuel to produce electricity, in physical unit, year to date. |
fuel_consumed_mmbtu |
number |
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
ownership_record_type |
string |
Whether each generator record is for one owner or represents a total of all ownerships. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
report_date |
date |
Date reported. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
generation_fuel_by_generator_energy_source_yearly_eia923#
Yearly estimated net generation and fuel consumption associated with each combination of generator, energy source, and prime mover. First, the net electricity generation and fuel consumption reported in the EIA-923 generation fuel are allocated to individual generators. Then, these allocations are aggregated to unique generator, prime mover, and energy source code combinations. This process does not distinguish between primary and secondary energy_sources for generators. Net generation is allocated equally between energy source codes, so if a plant has multiple generators with the same prime_mover_code but different energy source codes the generation_fuel_eia923 records will be associated similarly between these two generators. Allocated net generation will still be proportional to each generator's net generation or capacity. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
energy_source_code |
string |
A 2-3 letter code indicating the energy source (e.g. fuel type) associated with the record. |
energy_source_code_num |
string |
Name of the energy_source_code_N column that this energy source code was reported in for the generator referenced in the same record. |
fuel_consumed_for_electricity_mmbtu |
number |
Total consumption of fuel to produce electricity, in physical unit, year to date. |
fuel_consumed_mmbtu |
number |
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
report_date |
date |
Date reported. |
generation_fuel_by_generator_monthly_eia923#
Monthly estimated net generation and fuel consumption by generator. Based on allocating net electricity generation and fuel consumption reported in the EIA-923 generation and generation_fuel tables to individual generators. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
fuel_consumed_for_electricity_mmbtu |
number |
Total consumption of fuel to produce electricity, in physical unit, year to date. |
fuel_consumed_mmbtu |
number |
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
report_date |
date |
Date reported. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
generation_fuel_by_generator_yearly_eia923#
Yearly estimated net generation and fuel consumption by generator. Based on allocating net electricity generation and fuel consumption reported in the EIA-923 generation and generation_fuel tables to individual generators. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
fuel_consumed_for_electricity_mmbtu |
number |
Total consumption of fuel to produce electricity, in physical unit, year to date. |
fuel_consumed_mmbtu |
number |
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
report_date |
date |
Date reported. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
generation_fuel_eia923#
EIA-923 Monthly Generation and Fuel Consumption Time Series. From EIA-923 Schedule 3.
Monthly electricity generation and fuel consumption reported for each
combination of
fuel and prime mover within a plant. This data can't be easily linked to
individual
boilers, generators, and generation units, but it is provides the most
complete coverage
of fuel consumption and electricity generation for the entire generation
fleet. We use
the primary fuels and prime movers reported for each generator along with
their
capacities to attribute fuel consumption and generation when it isn't directly
reported
in the generation_eia923
and boiler_fuel_eia923
tables in order to
calculate
capacity factors, heat rates, and the marginal cost of electricity.
The table makes a distinction between all fuel consumed and fuel consumed for electricity generation because some units are also combined heat and power (CHP) units, and also provide high temperature process heat at the expense of net electricity generation.
Note that a small number of respondents only report annual fuel consumption and net generation, and all of it is reported in December. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
energy_source_code |
string |
A 2-3 letter code indicating the energy source (e.g. fuel type) associated with the record. |
fuel_consumed_for_electricity_mmbtu |
number |
Total consumption of fuel to produce electricity, in physical unit, year to date. |
fuel_consumed_for_electricity_units |
number |
Consumption for electric generation of the fuel type in physical unit. |
fuel_consumed_mmbtu |
number |
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_consumed_units |
number |
Consumption of the fuel type in physical unit. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_mmbtu_per_unit |
number |
Heat content of the fuel in millions of Btus per physical unit. |
fuel_type_code_aer |
string |
A partial aggregation of the reported fuel type codes into larger categories used by EIA in, for example, the Annual Energy Review (AER). Two or three letter alphanumeric. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
report_date |
date |
Date reported. |
generation_fuel_nuclear_eia923#
EIA-923 Monthly Generation and Fuel Consumption Time Series. From EIA-923 Schedule 3.
Monthly electricity generation and fuel consumption reported for each combination of fuel and prime mover within a nuclear generation unit. This data is originally reported alongside similar information for fossil fuel plants, but the nuclear data is reported by (nuclear) generation unit rather than fuel type and prime mover, and so has a different primary key. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
energy_source_code |
string |
A 2-3 letter code indicating the energy source (e.g. fuel type) associated with the record. |
fuel_consumed_for_electricity_mmbtu |
number |
Total consumption of fuel to produce electricity, in physical unit, year to date. |
fuel_consumed_for_electricity_units |
number |
Consumption for electric generation of the fuel type in physical unit. |
fuel_consumed_mmbtu |
number |
Total consumption of fuel in physical unit, year to date. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_consumed_units |
number |
Consumption of the fuel type in physical unit. Note: this is the total quantity consumed for both electricity and, in the case of combined heat and power plants, process steam production. |
fuel_mmbtu_per_unit |
number |
Heat content of the fuel in millions of Btus per physical unit. |
fuel_type_code_aer |
string |
A partial aggregation of the reported fuel type codes into larger categories used by EIA in, for example, the Annual Energy Review (AER). Two or three letter alphanumeric. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
nuclear_unit_id |
string |
For nuclear plants only, the unit number .One digit numeric. Nuclear plants are the only type of plants for which data are shown explicitly at the generating unit level. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
report_date |
date |
Date reported. |
generators_eia860#
Annually varying generator attributes compiled from across EIA-860 and EIA-923 data. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
carbon_capture |
boolean |
Indicates whether the generator uses carbon capture technology. |
cofire_fuels |
boolean |
Can the generator co-fire fuels?. |
current_planned_generator_operating_date |
date |
The most recently updated effective date on which the generator is scheduled to start operation |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
deliver_power_transgrid |
boolean |
Indicate whether the generator can deliver power to the transmission grid. |
distributed_generation |
boolean |
Whether the generator is considered distributed generation |
energy_source_1_transport_1 |
string |
Primary mode of transport for energy source 1. |
energy_source_1_transport_2 |
string |
Secondary mode of transport for energy source 1. |
energy_source_1_transport_3 |
string |
Tertiary mode of transport for energy source 1. |
energy_source_2_transport_1 |
string |
Primary mode of transport for energy source 2. |
energy_source_2_transport_2 |
string |
Secondary mode of transport for energy source 2. |
energy_source_2_transport_3 |
string |
Tertiary mode of transport for energy source 2. |
energy_source_code_1 |
string |
The code representing the most predominant type of energy that fuels the generator. |
energy_source_code_2 |
string |
The code representing the second most predominant type of energy that fuels the generator |
energy_source_code_3 |
string |
The code representing the third most predominant type of energy that fuels the generator |
energy_source_code_4 |
string |
The code representing the fourth most predominant type of energy that fuels the generator |
energy_source_code_5 |
string |
The code representing the fifth most predominant type of energy that fuels the generator |
energy_source_code_6 |
string |
The code representing the sixth most predominant type of energy that fuels the generator |
energy_storage_capacity_mwh |
number |
Energy storage capacity in MWh (e.g. for batteries). |
ferc_qualifying_facility |
boolean |
Indicatates whether or not a generator is a qualifying FERC cogeneation facility. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
generator_retirement_date |
date |
Date of the scheduled or effected retirement of the generator. |
minimum_load_mw |
number |
The minimum load at which the generator can operate at continuosuly. |
multiple_fuels |
boolean |
Can the generator burn multiple fuels? |
nameplate_power_factor |
number |
The nameplate power factor of the generator. |
net_capacity_mwdc |
number |
Generation capacity in megawatts of direct current that is subject to a net metering agreement. Typically used for behind-the-meter solar PV. |
operational_status |
string |
The operating status of the asset. For generators this is based on which tab the generator was listed in in EIA 860. |
operational_status_code |
string |
The operating status of the asset. |
other_modifications_date |
date |
Planned effective date that the generator is scheduled to enter commercial operation after any other planned modification is complete. |
other_planned_modifications |
boolean |
Indicates whether there are there other modifications planned for the generator. |
owned_by_non_utility |
boolean |
Whether any part of generator is owned by a nonutilty |
ownership_code |
string |
Identifies the ownership for each generator. |
planned_derate_date |
date |
Planned effective month that the generator is scheduled to enter operation after the derate modification. |
planned_energy_source_code_1 |
string |
New energy source code for the planned repowered generator. |
planned_generator_retirement_date |
date |
Planned effective date of the scheduled retirement of the generator. |
planned_modifications |
boolean |
Indicates whether there are any planned capacity uprates/derates, repowering, other modifications, or generator retirements scheduled for the next 5 years. |
planned_net_summer_capacity_derate_mw |
number |
Decrease in summer capacity expected to be realized from the derate modification to the equipment. |
planned_net_summer_capacity_uprate_mw |
number |
Increase in summer capacity expected to be realized from the modification to the equipment. |
planned_net_winter_capacity_derate_mw |
number |
Decrease in winter capacity expected to be realized from the derate modification to the equipment. |
planned_net_winter_capacity_uprate_mw |
number |
Increase in winter capacity expected to be realized from the uprate modification to the equipment. |
planned_new_capacity_mw |
number |
The expected new namplate capacity for the generator. |
planned_new_prime_mover_code |
string |
New prime mover for the planned repowered generator. |
planned_repower_date |
date |
Planned effective date that the generator is scheduled to enter operation after the repowering is complete. |
planned_uprate_date |
date |
Planned effective date that the generator is scheduled to enter operation after the uprate modification. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
reactive_power_output_mvar |
number |
Reactive Power Output (MVAr) |
report_date |
date |
Date reported. |
startup_source_code_1 |
string |
The code representing the first, second, third or fourth start-up and flame stabilization energy source used by the combustion unit(s) associated with this generator. |
startup_source_code_2 |
string |
The code representing the first, second, third or fourth start-up and flame stabilization energy source used by the combustion unit(s) associated with this generator. |
startup_source_code_3 |
string |
The code representing the first, second, third or fourth start-up and flame stabilization energy source used by the combustion unit(s) associated with this generator. |
startup_source_code_4 |
string |
The code representing the first, second, third or fourth start-up and flame stabilization energy source used by the combustion unit(s) associated with this generator. |
summer_capacity_estimate |
boolean |
Whether the summer capacity value was an estimate |
summer_capacity_mw |
number |
The net summer capacity. |
summer_estimated_capability_mw |
number |
EIA estimated summer capacity (in MWh). |
switch_oil_gas |
boolean |
Indicates whether the generator switch between oil and natural gas. |
syncronized_transmission_grid |
boolean |
Indicates whether standby generators (SB status) can be synchronized to the grid. |
technology_description |
string |
High level description of the technology used by the generator to produce electricity. |
time_cold_shutdown_full_load_code |
string |
The minimum amount of time required to bring the unit to full load from shutdown. |
turbines_inverters_hydrokinetics |
integer |
Number of wind turbines, or hydrokinetic buoys. |
turbines_num |
integer |
Number of wind turbines, or hydrokinetic buoys. |
uprate_derate_completed_date |
date |
The date when the uprate or derate was completed. |
uprate_derate_during_year |
boolean |
Was an uprate or derate completed on this generator during the reporting year? |
utility_id_eia |
integer |
The EIA Utility Identification number. |
winter_capacity_estimate |
boolean |
Whether the winter capacity value was an estimate |
winter_capacity_mw |
number |
The net winter capacity. |
winter_estimated_capability_mw |
number |
EIA estimated winter capacity (in MWh). |
generators_entity_eia#
Static generator attributes compiled from across the EIA-860 and EIA-923 data. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
associated_combined_heat_power |
boolean |
Indicates whether the generator is associated with a combined heat and power system |
bypass_heat_recovery |
boolean |
Can this generator operate while bypassing the heat recovery steam generator? |
duct_burners |
boolean |
Indicates whether the unit has duct-burners for supplementary firing of the turbine exhaust gas |
fluidized_bed_tech |
boolean |
Indicates whether the generator uses fluidized bed technology |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
generator_operating_date |
date |
Date the generator began commercial operation. |
operating_switch |
string |
Indicates whether the fuel switching generator can switch when operating |
original_planned_generator_operating_date |
date |
The date the generator was originally scheduled to be operational |
other_combustion_tech |
boolean |
Indicates whether the generator uses other combustion technologies |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
previously_canceled |
boolean |
Indicates whether the generator was previously reported as indefinitely postponed or canceled |
pulverized_coal_tech |
boolean |
Indicates whether the generator uses pulverized coal technology |
rto_iso_lmp_node_id |
string |
The designation used to identify the price node in RTO/ISO Locational Marginal Price reports |
rto_iso_location_wholesale_reporting_id |
string |
The designation used to report ths specific location of the wholesale sales transactions to FERC for the Electric Quarterly Report |
solid_fuel_gasification |
boolean |
Indicates whether the generator is part of a solid fuel gasification system |
stoker_tech |
boolean |
Indicates whether the generator uses stoker technology |
subcritical_tech |
boolean |
Indicates whether the generator uses subcritical technology |
supercritical_tech |
boolean |
Indicates whether the generator uses supercritical technology |
topping_bottoming_code |
string |
If the generator is associated with a combined heat and power system, indicates whether the generator is part of a topping cycle or a bottoming cycle |
ultrasupercritical_tech |
boolean |
Indicates whether the generator uses ultra-supercritical technology |
green_pricing_eia861#
Green pricing program revenue, sales, and customer count by sector and state. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
customer_class |
string |
High level categorization of customer type. |
customers |
number |
Number of customers. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
green_pricing_revenue |
number |
N/A |
rec_revenue |
number |
N/A |
rec_sales_mwh |
number |
N/A |
report_date |
date |
Date reported. |
sales_mwh |
number |
Quantity of electricity sold in MWh. |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
heat_rate_by_generator_monthly#
Monthly heat rate estimates by generator. These are actually just generation unit level heat rates, which have been broadcast across all constituent generator IDs, since heat rates really only have a well-defined meaning in the context of a generation unit.Note that the values in this table are unfiltered and we expect some of the values are unreasonable and out of bounds.This table should not be used without filtering values to within logical boundaries. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
fuel_type_count |
integer |
A count of how many different simple energy sources there are associated with a generator. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
heat_rate_mmbtu_mwh |
number |
Fuel content per unit of electricity generated. Coming from MCOE calculation. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
report_date |
date |
Date reported. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
heat_rate_by_generator_yearly#
Yearly heat rate estimates by generator. These are actually just generation unit level heat rates, which have been broadcast across all constituent generator IDs, since heat rates really only have a well-defined meaning in the context of a generation unit.Note that the values in this table are unfiltered and we expect some of the values are unreasonable and out of bounds.This table should not be used without filtering values to within logical boundaries. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
fuel_type_count |
integer |
A count of how many different simple energy sources there are associated with a generator. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
heat_rate_mmbtu_mwh |
number |
Fuel content per unit of electricity generated. Coming from MCOE calculation. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
report_date |
date |
Date reported. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
heat_rate_by_unit_monthly#
Monthly heat rate estimates by generation unit. Generation units are
identified by unit_id_pudl
and are composed of a set of interconnected
boilers and generators. Note that the values in this table are unfiltered and
we expect some of the values are unreasonable and out of bounds.This table
should not be used without filtering values to within logical boundaries.
Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
fuel_consumed_for_electricity_mmbtu |
number |
Total consumption of fuel to produce electricity, in physical unit, year to date. |
heat_rate_mmbtu_mwh |
number |
Fuel content per unit of electricity generated. Coming from MCOE calculation. |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
report_date |
date |
Date reported. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
heat_rate_by_unit_yearly#
Yearly heat rate estimates by generation unit. Generation units are identified
by unit_id_pudl
and are composed of a set of interconnected boilers and
generators. Note that the values in this table are unfiltered and we expect
some of the values are unreasonable and out of bounds.This table should not be
used without filtering values to within logical boundaries.
Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
fuel_consumed_for_electricity_mmbtu |
number |
Total consumption of fuel to produce electricity, in physical unit, year to date. |
heat_rate_mmbtu_mwh |
number |
Fuel content per unit of electricity generated. Coming from MCOE calculation. |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
report_date |
date |
Date reported. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
hourly_emissions_epacems#
Hourly emissions and plant operational data reported via Continuous Emissions Monitoring Systems as required by 40 CFR Part 75. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
co2_mass_measurement_code |
string |
Identifies whether the reported value of emissions was measured, calculated, or measured and substitute. |
co2_mass_tons |
number |
Carbon dioxide emissions in short tons. |
emissions_unit_id_epa |
string |
Emissions (smokestack) unit monitored by EPA CEMS. |
gross_load_mw |
number |
Average power in megawatts delivered during time interval measured. |
heat_content_mmbtu |
number |
The energy contained in fuel burned, measured in million BTU. |
nox_mass_lbs |
number |
NOx emissions in pounds. |
nox_mass_measurement_code |
string |
Identifies whether the reported value of emissions was measured, calculated, or measured and substitute. |
operating_datetime_utc |
datetime |
Date and time measurement began (UTC). |
operating_time_hours |
number |
Length of time interval measured. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_epa |
integer |
The ORISPL ID used by EPA to refer to the plant. Usually but not always the same as plant_id_eia. |
so2_mass_lbs |
number |
Sulfur dioxide emissions in pounds. |
so2_mass_measurement_code |
string |
Identifies whether the reported value of emissions was measured, calculated, or measured and substitute. |
state |
string |
Two letter US state abbreviation. |
steam_load_1000_lbs |
number |
Total steam pressure produced by a unit during the reported hour. |
year |
integer |
Year the data was reported in, used for partitioning EPA CEMS. |
income_statement_ferc1#
Statement of Income. Schedule 114. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balance |
string |
Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy. |
dollar_value |
number |
Dollar value of reported income, expense, asset, or liability. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
income_type |
string |
Type of income reported in income_statement_ferc1 table. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_type |
string |
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility. |
mcoe_generators_monthly#
The marginal cost of energy table with Monthly generator capacity factor, heat rate, fuel cost per MMBTU and fuel cost, but with additional potentially useful generator attributes merged on.See the description in the MCOE table for more explanation of these calculations. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
capacity_factor |
number |
Fraction of potential generation that was actually reported for a plant part. |
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
energy_source_code_1 |
string |
The code representing the most predominant type of energy that fuels the generator. |
fuel_cost_from_eiaapi |
boolean |
Indicates whether the fuel cost was derived from the EIA API. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_cost_per_mwh |
number |
Derived from MCOE, a unit level value. Average fuel cost per MWh of heat content in nominal USD. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
generator_operating_date |
date |
Date the generator began commercial operation. |
generator_retirement_date |
date |
Date of the scheduled or effected retirement of the generator. |
heat_rate_mmbtu_mwh |
number |
Fuel content per unit of electricity generated. Coming from MCOE calculation. |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
operational_status |
string |
The operating status of the asset. For generators this is based on which tab the generator was listed in in EIA 860. |
planned_generator_retirement_date |
date |
Planned effective date of the scheduled retirement of the generator. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
report_date |
date |
Date reported. |
technology_description |
string |
High level description of the technology used by the generator to produce electricity. |
total_fuel_cost |
number |
Total annual reported fuel costs for the plant part. Includes costs from all fuels. |
total_mmbtu |
number |
Total annual heat content of fuel consumed by a plant part record in the plant parts list. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
mcoe_generators_yearly#
The marginal cost of energy table with Yearly generator capacity factor, heat rate, fuel cost per MMBTU and fuel cost, but with additional potentially useful generator attributes merged on.See the description in the MCOE table for more explanation of these calculations. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
capacity_factor |
number |
Fraction of potential generation that was actually reported for a plant part. |
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
energy_source_code_1 |
string |
The code representing the most predominant type of energy that fuels the generator. |
fuel_cost_from_eiaapi |
boolean |
Indicates whether the fuel cost was derived from the EIA API. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_cost_per_mwh |
number |
Derived from MCOE, a unit level value. Average fuel cost per MWh of heat content in nominal USD. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
generator_operating_date |
date |
Date the generator began commercial operation. |
generator_retirement_date |
date |
Date of the scheduled or effected retirement of the generator. |
heat_rate_mmbtu_mwh |
number |
Fuel content per unit of electricity generated. Coming from MCOE calculation. |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
operational_status |
string |
The operating status of the asset. For generators this is based on which tab the generator was listed in in EIA 860. |
planned_generator_retirement_date |
date |
Planned effective date of the scheduled retirement of the generator. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
report_date |
date |
Date reported. |
technology_description |
string |
High level description of the technology used by the generator to produce electricity. |
total_fuel_cost |
number |
Total annual reported fuel costs for the plant part. Includes costs from all fuels. |
total_mmbtu |
number |
Total annual heat content of fuel consumed by a plant part record in the plant parts list. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
mcoe_monthly#
Monthly generator capacity factor, heat rate, fuel cost per MMBTU and fuel cost per MWh. These calculations are based on the allocation of net generation reported on the basis of plant, prime mover and energy source to individual generators. Heat rates by generator-month are estimated by using allocated estimates for per-generator net generation and fuel consumption as well as the boiler_fuel_eia923 table, which reports fuel consumed by boiler. Heat rates are necessary to estimate the amount of fuel consumed by a generation unit, and thus the fuel cost per MWh generated. Plant specific fuel prices are taken from the fuel_receipts_costs_eia923 table, which only has ~70% coverage, leading to some generators with heat rate estimates still lacking fuel cost estimates. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
capacity_factor |
number |
Fraction of potential generation that was actually reported for a plant part. |
fuel_cost_from_eiaapi |
boolean |
Indicates whether the fuel cost was derived from the EIA API. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_cost_per_mwh |
number |
Derived from MCOE, a unit level value. Average fuel cost per MWh of heat content in nominal USD. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
heat_rate_mmbtu_mwh |
number |
Fuel content per unit of electricity generated. Coming from MCOE calculation. |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
report_date |
date |
Date reported. |
total_fuel_cost |
number |
Total annual reported fuel costs for the plant part. Includes costs from all fuels. |
total_mmbtu |
number |
Total annual heat content of fuel consumed by a plant part record in the plant parts list. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
mcoe_yearly#
Yearly generator capacity factor, heat rate, fuel cost per MMBTU and fuel cost per MWh. These calculations are based on the allocation of net generation reported on the basis of plant, prime mover and energy source to individual generators. Heat rates by generator-month are estimated by using allocated estimates for per-generator net generation and fuel consumption as well as the boiler_fuel_eia923 table, which reports fuel consumed by boiler. Heat rates are necessary to estimate the amount of fuel consumed by a generation unit, and thus the fuel cost per MWh generated. Plant specific fuel prices are taken from the fuel_receipts_costs_eia923 table, which only has ~70% coverage, leading to some generators with heat rate estimates still lacking fuel cost estimates. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
capacity_factor |
number |
Fraction of potential generation that was actually reported for a plant part. |
fuel_cost_from_eiaapi |
boolean |
Indicates whether the fuel cost was derived from the EIA API. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_cost_per_mwh |
number |
Derived from MCOE, a unit level value. Average fuel cost per MWh of heat content in nominal USD. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
heat_rate_mmbtu_mwh |
number |
Fuel content per unit of electricity generated. Coming from MCOE calculation. |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
report_date |
date |
Date reported. |
total_fuel_cost |
number |
Total annual reported fuel costs for the plant part. Includes costs from all fuels. |
total_mmbtu |
number |
Total annual heat content of fuel consumed by a plant part record in the plant parts list. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
mega_generators_eia#
A mega table of all EIA generators with ownership integrated. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
capacity_eoy_mw |
number |
Total end of year installed (nameplate) capacity for a plant part, in megawatts. |
capacity_factor |
number |
Fraction of potential generation that was actually reported for a plant part. |
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
energy_source_code_1 |
string |
The code representing the most predominant type of energy that fuels the generator. |
ferc_acct_name |
string |
Name of FERC account, derived from technology description and prime mover code. |
fraction_owned |
number |
Proportion of generator ownership attributable to this utility. |
fuel_cost_from_eiaapi |
boolean |
Indicates whether the fuel cost was derived from the EIA API. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_cost_per_mwh |
number |
Derived from MCOE, a unit level value. Average fuel cost per MWh of heat content in nominal USD. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
generator_operating_date |
date |
Date the generator began commercial operation. |
generator_operating_year |
integer |
Year a generator went into service. |
generator_retirement_date |
date |
Date of the scheduled or effected retirement of the generator. |
heat_rate_mmbtu_mwh |
number |
Fuel content per unit of electricity generated. Coming from MCOE calculation. |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
operational_status |
string |
The operating status of the asset. For generators this is based on which tab the generator was listed in in EIA 860. |
operational_status_pudl |
string |
The operating status of the asset using PUDL categories. |
ownership_record_type |
string |
Whether each generator record is for one owner or represents a total of all ownerships. |
planned_generator_retirement_date |
date |
Planned effective date of the scheduled retirement of the generator. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
report_date |
date |
Date reported. |
technology_description |
string |
High level description of the technology used by the generator to produce electricity. |
total_fuel_cost |
number |
Total annual reported fuel costs for the plant part. Includes costs from all fuels. |
total_mmbtu |
number |
Total annual heat content of fuel consumed by a plant part record in the plant parts list. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
mercury_compliance_strategies_eia#
A coding table describing different compliance strategies used to control mercury in the EIA-860. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
mergers_eia861#
Information about utility mergers and acquisitions. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
entity_type |
string |
Entity type of principal owner. |
merge_address |
string |
N/A |
merge_city |
string |
N/A |
merge_company |
string |
N/A |
merge_date |
date |
N/A |
merge_state |
string |
Two letter US state abbreviations and three letter ISO-3166-1 country codes for international mines. |
new_parent |
string |
N/A |
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
zip_code |
string |
Five digit US Zip Code. |
zip_code_4 |
string |
Four digit US Zip Code suffix. |
momentary_interruptions_eia#
A coding table for utility definitions of momentary service interruptions. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
net_metering_customer_fuel_class_eia861#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balancing_authority_code_eia |
string |
EIA short code identifying a balancing authority. |
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
customer_class |
string |
High level categorization of customer type. |
customers |
number |
Number of customers. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
energy_displaced_mwh |
number |
N/A |
report_date |
date |
Date reported. |
short_form |
boolean |
N/A |
sold_to_utility_mwh |
number |
N/A |
state |
string |
Two letter US state abbreviation. |
tech_class |
string |
N/A |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
net_metering_misc_eia861#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balancing_authority_code_eia |
string |
EIA short code identifying a balancing authority. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
pv_current_flow_type |
string |
N/A |
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
non_net_metering_customer_fuel_class_eia861#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balancing_authority_code_eia |
string |
EIA short code identifying a balancing authority. |
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
customer_class |
string |
High level categorization of customer type. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
tech_class |
string |
N/A |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
non_net_metering_misc_eia861#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
backup_capacity_mw |
number |
N/A |
balancing_authority_code_eia |
string |
EIA short code identifying a balancing authority. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
generators_number |
number |
N/A |
pv_current_flow_type |
string |
N/A |
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_owned_capacity_mw |
number |
N/A |
nox_compliance_strategies_eia#
A coding table describing different compliance strategies used to control nitrogen oxide in the EIA-860. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
nox_control_status_eia#
A coding table describing the operational status of nitrogen oxide control units associated with boilers in the EIA-860 data. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
nox_units_eia#
A coding table describing different units of measurement for nitrogen oxide in the EIA-860. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
operational_data_misc_eia861#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
consumed_by_facility_mwh |
number |
N/A |
consumed_by_respondent_without_charge_mwh |
number |
N/A |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
data_observed |
boolean |
Is the value observed (True) or imputed (False). |
entity_type |
string |
Entity type of principal owner. |
exchange_energy_delivered_mwh |
number |
N/A |
exchange_energy_received_mwh |
number |
N/A |
furnished_without_charge_mwh |
number |
N/A |
nerc_region |
string |
NERC region in which the plant is located |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
net_power_exchanged_mwh |
number |
N/A |
net_wheeled_power_mwh |
number |
N/A |
report_date |
date |
Date reported. |
retail_sales_mwh |
number |
N/A |
sales_for_resale_mwh |
number |
N/A |
short_form |
boolean |
N/A |
state |
string |
Two letter US state abbreviation. |
summer_peak_demand_mw |
number |
N/A |
total_disposition_mwh |
number |
N/A |
total_energy_losses_mwh |
number |
N/A |
total_sources_mwh |
number |
N/A |
transmission_by_other_losses_mwh |
number |
N/A |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
wheeled_power_delivered_mwh |
number |
N/A |
wheeled_power_received_mwh |
number |
N/A |
wholesale_power_purchases_mwh |
number |
N/A |
winter_peak_demand_mw |
number |
N/A |
operational_data_revenue_eia861#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
nerc_region |
string |
NERC region in which the plant is located |
report_date |
date |
Date reported. |
revenue |
number |
N/A |
revenue_class |
string |
N/A |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
operational_status_eia#
Codes and metadata pertaining to operational status reported to EIA. Compiled from EIA-860 instructions and EIA-923 file layout spreadsheets. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
operational_status |
string |
The operating status of the asset. For generators this is based on which tab the generator was listed in in EIA 860. |
other_regulatory_liabilities_ferc1#
Other regulatory liabilities, including rate order docket number. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
account_detail |
string |
Description of the account number credited from making debit adjustment to other regulatory liabilities. |
decrease_in_other_regulatory_liabilities |
number |
The decrease during the reporting period of other regulatory liabilities. |
description |
string |
Long human-readable description of the meaning of a code/label. |
ending_balance |
number |
Account balance at end of year. |
increase_in_other_regulatory_liabilities |
number |
The increase during the reporting period of other regulatory liabilities. |
report_year |
integer |
Four-digit year in which the data was reported. |
starting_balance |
number |
Account balance at beginning of year. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
ownership_eia860#
Generator Ownership, reported in EIA-860 Schedule 4. Includes only jointly or third-party owned generators. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
country |
string |
Three letter country abbreviation. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
fraction_owned |
number |
Proportion of generator ownership attributable to this utility. |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
owner_city |
string |
City of owner. |
owner_street_address |
string |
Steet address of owner. |
owner_zip_code |
string |
Zip code of owner. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA utility Identification number for the owner company that is responsible for the day-to-day operations of the generator, not the operator utility. |
utility_name_eia |
string |
The name of the utility. |
particulate_compliance_strategies_eia#
A coding table describing different compliance strategies used to control particulate matter in the EIA-860. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
particulate_units_eia#
A coding table describing different units of measurement for particulate matter in the EIA-860. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
plant_in_service_ferc1#
Balances and changes to FERC Electric Plant in Service accounts, as reported on FERC Form 1, Schedule 204. Data originally from the f1_plant_in_srvce table in FERC's FoxPro database. Account numbers correspond to the FERC Uniform System of Accounts for Electric Plant, which is defined in Code of Federal Regulations (CFR) Title 18, Chapter I, Subchapter C, Part 101. (See e.g. https://www.law.cornell.edu/cfr/text/18/part-101). Each FERC respondent reports starting and ending balances for each account annually. Balances are organization wide, and are not broken down on a per-plant basis. End of year balance should equal beginning year balance plus the sum of additions, retirements, adjustments, and transfers. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
additions |
number |
Cost of acquisition of items classified within the account. |
adjustments |
number |
Cost of adjustments to the account. |
ending_balance |
number |
Account balance at end of year. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
ferc_account_label |
string |
Long FERC account identifier derived from values reported in the XBRL taxonomies. May also refer to aggregations of individual FERC accounts. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
retirements |
number |
Cost of disposal of items classified within the account. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
starting_balance |
number |
Account balance at beginning of year. |
transfers |
number |
Cost of transfers into (out of) the account. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_type |
string |
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility. |
plant_parts_eia#
Output table with the aggregation of all EIA plant parts. For use with matching to FERC 1. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
appro_part_label |
string |
Plant part of the associated true granularity record. |
appro_record_id_eia |
string |
EIA record ID of the associated true granularity record. |
capacity_eoy_mw |
number |
Total end of year installed (nameplate) capacity for a plant part, in megawatts. |
capacity_factor |
number |
Fraction of potential generation that was actually reported for a plant part. |
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
construction_year |
integer |
Year the plant's oldest still operational unit was built. |
energy_source_code_1 |
string |
The code representing the most predominant type of energy that fuels the generator. |
ferc1_generator_agg_id |
integer |
ID dynamically assigned by PUDL to EIA records with multiple matches to a single FERC ID in the FERC-EIA manual matching process. |
ferc_acct_name |
string |
Name of FERC account, derived from technology description and prime mover code. |
fraction_owned |
number |
Proportion of generator ownership attributable to this utility. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_cost_per_mwh |
number |
Derived from MCOE, a unit level value. Average fuel cost per MWh of heat content in nominal USD. |
fuel_type_code_pudl |
string |
Simplified fuel type code used in PUDL |
generator_id |
string |
Generator ID is usually numeric, but sometimes includes letters. Make sure you treat it as a string! |
generator_operating_year |
integer |
Year a generator went into service. |
generator_retirement_date |
date |
Date of the scheduled or effected retirement of the generator. |
heat_rate_mmbtu_mwh |
number |
Fuel content per unit of electricity generated. Coming from MCOE calculation. |
installation_year |
integer |
Year the plant's most recently built unit was installed. |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
operational_status |
string |
The operating status of the asset. For generators this is based on which tab the generator was listed in in EIA 860. |
operational_status_pudl |
string |
The operating status of the asset using PUDL categories. |
ownership_dupe |
boolean |
Whether a plant part record has a duplicate record with different ownership status. |
ownership_record_type |
string |
Whether each generator record is for one owner or represents a total of all ownerships. |
planned_generator_retirement_date |
date |
Planned effective date of the scheduled retirement of the generator. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_id_report_year |
string |
PUDL plant ID and report year of the record. |
plant_name_eia |
string |
Plant name. |
plant_name_ppe |
string |
Derived plant name that includes EIA plant name and other strings associated with ID and PK columns of the plant part. |
plant_part |
string |
The part of the plant a record corresponds to. |
plant_part_id_eia |
string |
Contains EIA plant ID, plant part, ownership, and EIA utility id |
prime_mover_code |
string |
Code for the type of prime mover (e.g. CT, CG) |
record_count |
integer |
Number of distinct generator IDs that partcipated in the aggregation for a plant part list record. |
record_id_eia |
string |
Identifier for EIA plant parts analysis records. |
report_date |
date |
Date reported. |
report_year |
integer |
Four-digit year in which the data was reported. |
technology_description |
string |
High level description of the technology used by the generator to produce electricity. |
total_fuel_cost |
number |
Total annual reported fuel costs for the plant part. Includes costs from all fuels. |
total_mmbtu |
number |
Total annual heat content of fuel consumed by a plant part record in the plant parts list. |
true_gran |
boolean |
Indicates whether a plant part list record is associated with the highest priority plant part for all identical records. |
unit_id_pudl |
integer |
Dynamically assigned PUDL unit id. WARNING: This ID is not guaranteed to be static long term as the input data and algorithm may evolve over time. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
plants_eia#
Association between EIA Plant IDs and manually assigned PUDL Plant IDs Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_eia |
string |
Plant name. |
plants_eia860#
Annually varying plant attributes, compiled from across all EIA-860 and EIA-923 data. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
ash_impoundment |
boolean |
Is there an ash impoundment (e.g. pond, reservoir) at the plant? |
ash_impoundment_lined |
boolean |
If there is an ash impoundment at the plant, is the impoundment lined? |
ash_impoundment_status |
string |
If there is an ash impoundment at the plant, the ash impoundment status as of December 31 of the reporting year. |
balancing_authority_code_eia |
string |
EIA short code identifying a balancing authority. |
balancing_authority_name_eia |
string |
Name of the balancing authority. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
datum |
string |
Geodetic coordinate system identifier (e.g. NAD27, NAD83, or WGS84). |
energy_storage |
boolean |
Indicates if the facility has energy storage capabilities. |
ferc_cogen_docket_no |
string |
The docket number relating to the FERC cogenerator status. See FERC Form 556. |
ferc_cogen_status |
boolean |
Indicates whether the plant has FERC qualifying facility cogenerator status. See FERC Form 556. |
ferc_exempt_wholesale_generator |
boolean |
Indicates whether the plant has FERC qualifying facility exempt wholesale generator status |
ferc_exempt_wholesale_generator_docket_no |
string |
The docket number relating to the FERC qualifying facility exempt wholesale generator status. |
ferc_qualifying_facility_docket_no |
string |
The docket number relating to the FERC qualifying facility cogenerator status. See FERC Form 556. |
ferc_small_power_producer |
boolean |
Indicates whether the plant has FERC qualifying facility small power producer status. See FERC Form 556. |
ferc_small_power_producer_docket_no |
string |
The docket number relating to the FERC qualifying facility small power producer status. See FERC Form 556. |
grid_voltage_1_kv |
number |
Plant's grid voltage at point of interconnection to transmission or distibution facilities |
grid_voltage_2_kv |
number |
Plant's grid voltage at point of interconnection to transmission or distibution facilities |
grid_voltage_3_kv |
number |
Plant's grid voltage at point of interconnection to transmission or distibution facilities |
iso_rto_code |
string |
The code of the plant's ISO or RTO. NA if not reported in that year. |
liquefied_natural_gas_storage |
boolean |
Indicates if the facility have the capability to store the natural gas in the form of liquefied natural gas. |
natural_gas_local_distribution_company |
string |
Names of Local Distribution Company (LDC), connected to natural gas burning power plants. |
natural_gas_pipeline_name_1 |
string |
The name of the owner or operator of natural gas pipeline that connects directly to this facility or that connects to a lateral pipeline owned by this facility. |
natural_gas_pipeline_name_2 |
string |
The name of the owner or operator of natural gas pipeline that connects directly to this facility or that connects to a lateral pipeline owned by this facility. |
natural_gas_pipeline_name_3 |
string |
The name of the owner or operator of natural gas pipeline that connects directly to this facility or that connects to a lateral pipeline owned by this facility. |
natural_gas_storage |
boolean |
Indicates if the facility have on-site storage of natural gas. |
nerc_region |
string |
NERC region in which the plant is located |
net_metering |
boolean |
Did this plant have a net metering agreement in effect during the reporting year? (Only displayed for facilities that report the sun or wind as an energy source). This field was only reported up until 2015 |
pipeline_notes |
string |
Additional owner or operator of natural gas pipeline. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
primary_purpose_id_naics |
integer |
North American Industry Classification System (NAICS) code that best describes the primary purpose of the reporting plant |
regulatory_status_code |
string |
Indicates whether the plant is regulated or non-regulated. |
report_date |
date |
Date reported. |
reporting_frequency_code |
string |
Code that specifies what time period data has to be reported (i.e. monthly data or annual totals) and how often the power plant reports this data to EIA. See reporting_frequencies_eia for more details. |
sector_id_eia |
integer |
EIA assigned sector ID, corresponding to high level NAICS sector, designated by the primary purpose, regulatory status and plant-level combined heat and power status |
sector_name_eia |
string |
EIA assigned sector name, corresponding to high level NAICS sector, designated by the primary purpose, regulatory status and plant-level combined heat and power status |
service_area |
string |
Service area in which plant is located; for unregulated companies, it's the electric utility with which plant is interconnected |
transmission_distribution_owner_id |
integer |
EIA-assigned code for owner of transmission/distribution system to which the plant is interconnected. |
transmission_distribution_owner_name |
string |
Name of the owner of the transmission or distribution system to which the plant is interconnected. |
transmission_distribution_owner_state |
string |
State location for owner of transmission/distribution system to which the plant is interconnected. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
water_source |
string |
Name of water source associated with the plant. |
plants_entity_eia#
Static plant attributes, compiled from across all EIA-860 and EIA-923 data. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
city |
string |
N/A |
county |
string |
County name. |
latitude |
number |
Latitude of the plant's location, in degrees. |
longitude |
number |
Longitude of the plant's location, in degrees. |
plant_id_eia |
integer |
The unique six-digit facility identification number, also called an ORISPL, assigned by the Energy Information Administration. |
plant_name_eia |
string |
Plant name. |
state |
string |
Two letter US state abbreviation. |
street_address |
string |
N/A |
timezone |
string |
IANA timezone name |
zip_code |
string |
Five digit US Zip Code. |
plants_ferc1#
FERC 1 Plants and their associated manually assigned PUDL Plant IDs Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_ferc1 |
string |
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
plants_hydro_ferc1#
Hydroelectric generating plant statistics for large plants. Large plants have an installed nameplate capacity of more than 10 MW. As reported on FERC Form 1, Schedule 406 (pages 406-407), and extracted from the f1_hydro table in FERC's FoxPro database. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
asset_retirement_cost |
number |
Asset retirement cost (USD). |
avg_num_employees |
number |
N/A |
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
capex_equipment |
number |
Cost of plant: equipment (USD). |
capex_facilities |
number |
Cost of plant: reservoirs, dams, and waterways (USD). |
capex_land |
number |
Cost of plant: land and land rights (USD). |
capex_per_mw |
number |
Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD. |
capex_roads |
number |
Cost of plant: roads, railroads, and bridges (USD). |
capex_structures |
number |
Cost of plant: structures and improvements (USD). |
capex_total |
number |
Total cost of plant (USD). |
construction_type |
string |
Type of plant construction ('outdoor', 'semioutdoor', or 'conventional'). Categorized by PUDL based on our best guess of intended value in FERC1 freeform strings. |
construction_year |
integer |
Year the plant's oldest still operational unit was built. |
installation_year |
integer |
Year the plant's most recently built unit was installed. |
net_capacity_adverse_conditions_mw |
number |
Net plant capability under the least favorable operating conditions, in megawatts. |
net_capacity_favorable_conditions_mw |
number |
Net plant capability under the most favorable operating conditions, in megawatts. |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
opex_dams |
number |
Production expenses: maintenance of reservoirs, dams, and waterways (USD). |
opex_electric |
number |
Production expenses: electric expenses (USD). |
opex_engineering |
number |
Production expenses: maintenance, supervision, and engineering (USD). |
opex_generation_misc |
number |
Production expenses: miscellaneous power generation expenses (USD). |
opex_hydraulic |
number |
Production expenses: hydraulic expenses (USD). |
opex_misc_plant |
number |
Production expenses: maintenance of miscellaneous hydraulic plant (USD). |
opex_operations |
number |
Production expenses: operations, supervision, and engineering (USD). |
opex_per_mwh |
number |
Total production expenses (USD per MWh generated). |
opex_plant |
number |
Production expenses: maintenance of electric plant (USD). |
opex_rents |
number |
Production expenses: rents (USD). |
opex_structures |
number |
Production expenses: maintenance of structures (USD). |
opex_total |
number |
Total production expenses, excluding fuel (USD). |
opex_water_for_power |
number |
Production expenses: water for power (USD). |
peak_demand_mw |
number |
Net peak demand for 60 minutes. Note: in some cases peak demand for other time periods may have been reported instead, if hourly peak demand was unavailable. |
plant_hours_connected_while_generating |
number |
Hours the plant was connected to load while generating in the report year. |
plant_name_ferc1 |
string |
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant. |
plant_type |
string |
N/A |
project_num |
integer |
FERC Licensed Project Number. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
plants_pudl#
Home table for PUDL assigned plant IDs. These IDs are manually generated each year when new FERC and EIA reporting is integrated, and any newly identified plants are added to the list with a new ID. Each ID maps to a power plant 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 Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
plant_name_pudl |
string |
Plant name, chosen arbitrarily from the several possible plant names available in the plant matching process. Included for human readability only. |
plants_pumped_storage_ferc1#
Generating plant statistics for hydroelectric pumped storage plants with an installed nameplate capacity of 10+ MW. As reported in Scheudle 408 of FERC Form 1 and extracted from the f1_pumped_storage table in FERC's Visual FoxPro Database. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
asset_retirement_cost |
number |
Asset retirement cost (USD). |
avg_num_employees |
number |
N/A |
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
capex_equipment_electric |
number |
Cost of plant: accessory electric equipment (USD). |
capex_equipment_misc |
number |
Cost of plant: miscellaneous power plant equipment (USD). |
capex_facilities |
number |
Cost of plant: reservoirs, dams, and waterways (USD). |
capex_land |
number |
Cost of plant: land and land rights (USD). |
capex_per_mw |
number |
Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD. |
capex_roads |
number |
Cost of plant: roads, railroads, and bridges (USD). |
capex_structures |
number |
Cost of plant: structures and improvements (USD). |
capex_total |
number |
Total cost of plant (USD). |
capex_wheels_turbines_generators |
number |
Cost of plant: water wheels, turbines, and generators (USD). |
construction_type |
string |
Type of plant construction ('outdoor', 'semioutdoor', or 'conventional'). Categorized by PUDL based on our best guess of intended value in FERC1 freeform strings. |
construction_year |
integer |
Year the plant's oldest still operational unit was built. |
energy_used_for_pumping_mwh |
number |
Energy used for pumping, in megawatt-hours. |
installation_year |
integer |
Year the plant's most recently built unit was installed. |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
net_load_mwh |
number |
Net output for load (net generation - energy used for pumping) in megawatt-hours. |
opex_dams |
number |
Production expenses: maintenance of reservoirs, dams, and waterways (USD). |
opex_electric |
number |
Production expenses: electric expenses (USD). |
opex_engineering |
number |
Production expenses: maintenance, supervision, and engineering (USD). |
opex_generation_misc |
number |
Production expenses: miscellaneous power generation expenses (USD). |
opex_misc_plant |
number |
Production expenses: maintenance of miscellaneous hydraulic plant (USD). |
opex_operations |
number |
Production expenses: operations, supervision, and engineering (USD). |
opex_per_mwh |
number |
Total production expenses (USD per MWh generated). |
opex_plant |
number |
Production expenses: maintenance of electric plant (USD). |
opex_production_before_pumping |
number |
Total production expenses before pumping (USD). |
opex_pumped_storage |
number |
Production expenses: pumped storage (USD). |
opex_pumping |
number |
Production expenses: We are here to PUMP YOU UP! (USD). |
opex_rents |
number |
Production expenses: rents (USD). |
opex_structures |
number |
Production expenses: maintenance of structures (USD). |
opex_total |
number |
Total production expenses, excluding fuel (USD). |
opex_water_for_power |
number |
Production expenses: water for power (USD). |
peak_demand_mw |
number |
Net peak demand for 60 minutes. Note: in some cases peak demand for other time periods may have been reported instead, if hourly peak demand was unavailable. |
plant_capability_mw |
number |
Net plant capability in megawatts. |
plant_hours_connected_while_generating |
number |
Hours the plant was connected to load while generating in the report year. |
plant_name_ferc1 |
string |
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant. |
project_num |
integer |
FERC Licensed Project Number. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
plants_small_ferc1#
The generating plant statistics for internal combustion
plants, gas turbine-plants, conventional hydro plants, and pumped storage
plants with
less than 10 MW installed nameplate capacity and steam plants with less than
25 MW
installed nameplate capacity. As reported on FERC Form 1 Schedule 410 (pages
410-411)
and extracted from the FERC Visual FoxPro and XBRL. See our
pudl.extract.ferc1.TABLE_NAME_MAP_FERC1
for links to the raw tables.
The raw version of this table is more like a digitized PDF than an actual data table. The rows contain lots of information in addition to what the columns might suggest. For instance, a single column may contain header rows, note rows, and total rows. This extraneous information is useful, but it prevents proper analysis when mixed in with the rest of the values data in the column. We employ a couple of data transformations to extract these rows from the data and preserve some of the information they contain (fuel type, plant type, FERC license, or general notes about the plant) in separate columns. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
capex_per_mw |
number |
Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD. |
capex_total |
number |
Total cost of plant (USD). |
construction_year |
integer |
Year the plant's oldest still operational unit was built. |
fuel_cost_per_mmbtu |
number |
Average fuel cost per mmBTU of heat content in nominal USD. |
fuel_type |
string |
N/A |
license_id_ferc1 |
integer |
FERC issued operating license ID for the facility, if available. This value is extracted from the original plant name where possible. |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
opex_fuel |
number |
Production expenses: fuel (USD). |
opex_maintenance |
number |
Production expenses: Maintenance (USD). |
opex_operations |
number |
Production expenses: operations, supervision, and engineering (USD). |
peak_demand_mw |
number |
Net peak demand for 60 minutes. Note: in some cases peak demand for other time periods may have been reported instead, if hourly peak demand was unavailable. |
plant_name_ferc1 |
string |
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant. |
plant_type |
string |
N/A |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
plants_steam_ferc1#
Generating plant statistics for steam plants with a capacity of 25+ MW, internal combustion and gas-turbine plants of 10+ MW, and all nuclear plants. As reported in Schedule 402 of FERC Form 1 and extracted from the f1_gnrt_plant table in FERC's Visual FoxPro Database. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
asset_retirement_cost |
number |
Asset retirement cost (USD). |
avg_num_employees |
number |
N/A |
capacity_mw |
number |
Total installed (nameplate) capacity, in megawatts. |
capex_equipment |
number |
Cost of plant: equipment (USD). |
capex_land |
number |
Cost of plant: land and land rights (USD). |
capex_per_mw |
number |
Cost of plant per megawatt of installed (nameplate) capacity. Nominal USD. |
capex_structures |
number |
Cost of plant: structures and improvements (USD). |
capex_total |
number |
Total cost of plant (USD). |
construction_type |
string |
Type of plant construction ('outdoor', 'semioutdoor', or 'conventional'). Categorized by PUDL based on our best guess of intended value in FERC1 freeform strings. |
construction_year |
integer |
Year the plant's oldest still operational unit was built. |
installation_year |
integer |
Year the plant's most recently built unit was installed. |
net_generation_mwh |
number |
Net electricity generation for the specified period in megawatt-hours (MWh). |
not_water_limited_capacity_mw |
number |
Plant capacity in MW when not limited by condenser water. |
opex_allowances |
number |
Allowances. |
opex_boiler |
number |
Maintenance of boiler (or reactor) plant. |
opex_coolants |
number |
Cost of coolants and water (nuclear plants only) |
opex_electric |
number |
Production expenses: electric expenses (USD). |
opex_engineering |
number |
Production expenses: maintenance, supervision, and engineering (USD). |
opex_fuel |
number |
Production expenses: fuel (USD). |
opex_misc_power |
number |
Miscellaneous steam (or nuclear) expenses. |
opex_misc_steam |
number |
Maintenance of miscellaneous steam (or nuclear) plant. |
opex_operations |
number |
Production expenses: operations, supervision, and engineering (USD). |
opex_per_mwh |
number |
Total production expenses (USD per MWh generated). |
opex_plants |
number |
Maintenance of electrical plant. |
opex_production_total |
number |
Total operating expenses. |
opex_rents |
number |
Production expenses: rents (USD). |
opex_steam |
number |
Steam expenses. |
opex_steam_other |
number |
Steam from other sources. |
opex_structures |
number |
Production expenses: maintenance of structures (USD). |
opex_transfer |
number |
Steam transferred (Credit). |
peak_demand_mw |
number |
Net peak demand for 60 minutes. Note: in some cases peak demand for other time periods may have been reported instead, if hourly peak demand was unavailable. |
plant_capability_mw |
number |
Net plant capability in megawatts. |
plant_hours_connected_while_generating |
number |
Hours the plant was connected to load while generating in the report year. |
plant_id_ferc1 |
integer |
Algorithmically assigned PUDL FERC Plant ID. WARNING: NOT STABLE BETWEEN PUDL DB INITIALIZATIONS. |
plant_name_ferc1 |
string |
Name of the plant, as reported to FERC. This is a freeform string, not guaranteed to be consistent across references to the same plant. |
plant_type |
string |
N/A |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
water_limited_capacity_mw |
number |
Plant capacity in MW when limited by condenser water. |
political_subdivisions#
Various static attributes associated with states, provinces, and other sub- national political subdivisions. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
country_code |
string |
Three letter ISO-3166 country code (e.g. USA or CAN). |
country_name |
string |
Full country name (e.g. United States of America). |
division_code_us_census |
string |
Three-letter US Census division code as it appears in the bulk electricity data published by the EIA. Note that EIA splits the Pacific division into distinct contiguous (CA, OR, WA) and non-contiguous (AK, HI) states. For reference see this US Census region and division map: https://www2.census.gov/geo/pdfs/maps-data/maps/reference/us_regdiv.pdf |
division_name_us_census |
string |
Longer human readable name describing the US Census division. |
is_epacems_state |
boolean |
Indicates whether the associated state reports data within the EPA's Continuous Emissions Monitoring System. |
region_name_us_census |
string |
Human-readable name of a US Census region. |
state_id_fips |
string |
Two digit state FIPS code. |
subdivision_code |
string |
Two-letter ISO-3166 political subdivision code (e.g. US state or Canadian provice abbreviations like CA or AB). |
subdivision_name |
string |
Full name of political subdivision (e.g. US state or Canadian province names like California or Alberta. |
subdivision_type |
string |
ISO-3166 political subdivision type. E.g. state, province, outlying_area. |
timezone_approx |
string |
IANA timezone name of the timezone which encompasses the largest portion of the population in the associated geographic area. |
power_purchase_types_ferc1#
Coding table defining different types of electricity power purchases. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
predicted_state_hourly_demand#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
demand_mwh |
number |
N/A |
scaled_demand_mwh |
number |
Estimated electricity demand scaled by the total sales within a state. |
state_id_fips |
string |
Two digit state FIPS code. |
utc_datetime |
datetime |
N/A |
prime_movers_eia#
Long descriptions explaining the short prime mover codes reported in the EIA-860 and EIA-923. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
purchased_power_ferc1#
Purchased Power (Account 555) including power exchanges (transactions involving a balancing of debits and credits for energy, capacity, etc.) and any settlements for imbalanced exchanges. Reported on pages 326-327 of FERC Form 1. Extracted from the f1_purchased_pwr table in FERC's Visual FoxPro database. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
billing_demand_mw |
number |
Monthly average billing demand (for requirements purchases, and any transactions involving demand charges). In megawatts. |
coincident_peak_demand_mw |
number |
Average monthly coincident peak (CP) demand (for requirements purchases, and any transactions involving demand charges). Monthly CP demand is the metered demand during the hour (60-minute integration) in which the supplier's system reaches its monthly peak. In megawatts. |
delivered_mwh |
number |
Gross megawatt-hours delivered in power exchanges and used as the basis for settlement. |
demand_charges |
number |
Demand charges (USD). |
energy_charges |
number |
Energy charges (USD). |
non_coincident_peak_demand_mw |
number |
Average monthly non-coincident peak (NCP) demand (for requirements purhcases, and any transactions involving demand charges). Monthly NCP demand is the maximum metered hourly (60-minute integration) demand in a month. In megawatts. |
other_charges |
number |
Other charges, including out-of-period adjustments (USD). |
purchase_type_code |
string |
Categorization based on the original contractual terms and conditions of the service. Must be one of 'requirements', 'long_firm', 'intermediate_firm', 'short_firm', 'long_unit', 'intermediate_unit', 'electricity_exchange', 'other_service', or 'adjustment'. Requirements service is ongoing high reliability service, with load integrated into system resource planning. 'Long term' means 5+ years. 'Intermediate term' is 1-5 years. 'Short term' is less than 1 year. 'Firm' means not interruptible for economic reasons. 'unit' indicates service from a particular designated generating unit. 'exchange' is an in-kind transaction. |
purchased_mwh |
number |
Megawatt-hours shown on bills rendered to the respondent. Includes both electricity purchased for storage and non-storage purposes, which were lumped together prior to 2021. |
purchased_other_than_storage_mwh |
number |
Number of megawatt hours purchased during the period for other than energy storage. |
purchased_storage_mwh |
number |
Number of megawatt hours purchased during the period for energy storage. |
received_mwh |
number |
Gross megawatt-hours received in power exchanges and used as the basis for settlement. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
seller_name |
string |
Name of the seller, or the other party in an exchange transaction. |
tariff |
string |
FERC Rate Schedule Number or Tariff. (Note: may be incomplete if originally reported on multiple lines.) |
total_settlement |
number |
Sum of demand, energy, and other charges (USD). For power exchanges, the settlement amount for the net receipt of energy. If more energy was delivered than received, this amount is negative. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
regulations_eia#
A coding table describing the different levels of statutes and codes under which boilers operate in the EIA-860. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
reliability_eia861#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
caidi_w_major_event_days_minus_loss_of_service_minutes |
number |
N/A |
caidi_w_major_event_days_minutes |
number |
N/A |
caidi_wo_major_event_days_minutes |
number |
N/A |
customers |
number |
Number of customers. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
entity_type |
string |
Entity type of principal owner. |
highest_distribution_voltage_kv |
number |
N/A |
inactive_accounts_included |
boolean |
N/A |
momentary_interruption_definition |
string |
N/A |
outages_recorded_automatically |
boolean |
N/A |
report_date |
date |
Date reported. |
saidi_w_major_event_days_minus_loss_of_service_minutes |
number |
N/A |
saidi_w_major_event_days_minutes |
number |
N/A |
saidi_wo_major_event_days_minutes |
number |
N/A |
saifi_w_major_event_days_customers |
number |
N/A |
saifi_w_major_event_days_minus_loss_of_service_customers |
number |
N/A |
saifi_wo_major_event_days_customers |
number |
N/A |
short_form |
boolean |
N/A |
standard |
string |
N/A |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
reporting_frequencies_eia#
A coding table describing different types of reporting frequencies in plants in the EIA-923. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
respondent_id_ferc714#
Respondent identification. FERC Form 714, Part I, Schedule 1. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
eia_code |
integer |
N/A |
respondent_id_ferc714 |
integer |
N/A |
respondent_name_ferc714 |
string |
N/A |
retained_earnings_appropriations_ferc1#
Retained Earnings - some of the unstructed part of schedule 118. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_type |
string |
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility. |
retained_earnings_ferc1#
Retained Earnings - The structed part of schedule 118. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balance |
string |
Indication of whether a column is a credit or debit, as reported in the XBRL taxonomy. |
earnings_type |
string |
Label describing types of earnings. |
ending_balance |
number |
Account balance at end of year. |
ferc_account |
string |
Actual FERC Account number (e.g. '359.1') if available, or a PUDL assigned ID when FERC accounts have been split or combined in reporting. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
starting_balance |
number |
Account balance at beginning of year. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
sales_eia861#
Annual electricity sales to ultimate customers broken down by utility, balancing authority, state, and customer class. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
balancing_authority_code_eia |
string |
EIA short code identifying a balancing authority. |
business_model |
string |
N/A |
customer_class |
string |
High level categorization of customer type. |
customers |
number |
Number of customers. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
data_observed |
boolean |
Is the value observed (True) or imputed (False). |
entity_type |
string |
Entity type of principal owner. |
report_date |
date |
Date reported. |
sales_mwh |
number |
Quantity of electricity sold in MWh. |
sales_revenue |
number |
Revenue from electricity sold. |
service_type |
string |
N/A |
short_form |
boolean |
N/A |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
sector_consolidated_eia#
Long descriptions for the EIA consolidated NAICS sector codes. Codes and descriptions taken from the EIA-923 File Layout spreadsheet. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
integer |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
service_territory_eia861#
County FIPS codes for counties composing utility service territories. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
county |
string |
County name. |
county_id_fips |
string |
County ID from the Federal Information Processing Standard Publication 6-4. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
report_date |
date |
Date reported. |
short_form |
boolean |
N/A |
state |
string |
Two letter US state abbreviation. |
state_id_fips |
string |
Two digit state FIPS code. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
so2_compliance_strategies_eia#
A coding table describing different compliance strategies used to control sulfur dioxide in the EIA-860. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
so2_units_eia#
A coding table describing different units of measurement for sulfur dioxide in the EIA-860. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
steam_plant_types_eia#
A coding table describing different types of steam plants in the EIA-860. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |
summarized_demand_ferc714#
Compile FERC 714 annualized, categorized respondents and summarize values. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
area_km2 |
number |
County area in km2. |
balancing_authority_code_eia |
string |
EIA short code identifying a balancing authority. |
balancing_authority_id_eia |
integer |
EIA balancing authority ID. This is often (but not always!) the same as the utility ID associated with the same legal entity. |
balancing_authority_name_eia |
string |
Name of the balancing authority. |
demand_annual_mwh |
number |
N/A |
demand_annual_per_capita_mwh |
number |
Per-capita annual demand, averaged using Census county-level population estimates. |
demand_density_mwh_km2 |
number |
Annual demand per km2 of a given service territory. |
eia_code |
integer |
N/A |
population |
number |
County population, sourced from Census DP1 data. |
population_density_km2 |
number |
Average population per sq. km area of a service territory. |
report_date |
date |
Date reported. |
respondent_id_ferc714 |
integer |
N/A |
respondent_name_ferc714 |
string |
N/A |
respondent_type |
string |
N/A |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
transmission_statistics_ferc1#
Transmission Line Statistics. Schedule 422 of FERC Form 1. Information describing transmission lines, the cost of lines, annual operating and capital expenses, etc. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
capex_land |
number |
Cost of Land and land rights for the transmission line. |
capex_other |
number |
Construction and other costs for the transmission line. |
capex_total |
number |
Total costs for the transmission line. |
conductor_size_and_material |
string |
Size of transmission conductor and material of the transmission line. |
designed_voltage_kv |
number |
Manufactured (Designed) voltage, expressed in kilo-volts, for three-phase 60 cycle alternative current transmission lines |
end_point |
string |
The end point of a transmission line. |
num_transmission_circuits |
integer |
Number of circuits in a transmission line. |
operating_voltage_kv |
number |
The operating voltage, expressed kilo-volts, for three-phase 60 cycle alternative current transmission lines. |
opex_maintenance |
number |
Maintenance expenses for the transmission line. |
opex_operations |
number |
Operating expenses for the transmission line. |
opex_rents |
number |
Rent expenses for the transmission line. |
opex_total |
number |
Overall expenses for the transmission line. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
start_point |
string |
The starting point of a transmission line. |
supporting_structure_type |
string |
Supporting structure of the transmission line. |
transmission_line_and_structures_length_miles |
number |
Length (in pole miles or circuit miles (if transmission lines are underground)) for lines that are agrregated with other lines / structures (whose cost are aggregated and combined with other structures). |
transmission_line_length_miles |
number |
Length (in pole miles or circuit miles (if transmission lines are underground)) for lines that are stand alone structures (whose cost are reported on a stand-alone basis). |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utilities_eia#
Associations between the EIA Utility IDs and the manually assigned PUDL Utility IDs. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_eia |
string |
The name of the utility. |
utilities_eia860#
Annually varying utility attributes, compiled from all EIA data. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
address_2 |
string |
N/A |
attention_line |
string |
N/A |
city |
string |
N/A |
contact_firstname |
string |
First name of utility contact 1. |
contact_firstname_2 |
string |
First name of utility contact 2. |
contact_lastname |
string |
Last name of utility contact 1. |
contact_lastname_2 |
string |
Last name of utility contact 2. |
contact_title |
string |
Title of of utility contact 1. |
contact_title_2 |
string |
Title of utility contact 2. |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
entity_type |
string |
Entity type of principal owner. |
phone_extension |
string |
Phone extension for utility contact 1 |
phone_extension_2 |
string |
Phone extension for utility contact 2 |
phone_number |
string |
Phone number for utility contact 1. |
phone_number_2 |
string |
Phone number for utility contact 2. |
plants_reported_asset_manager |
boolean |
Is the reporting entity an asset manager of power plants reported on Schedule 2 of the form? |
plants_reported_operator |
boolean |
Is the reporting entity an operator of power plants reported on Schedule 2 of the form? |
plants_reported_other_relationship |
boolean |
Does the reporting entity have any other relationship to the power plants reported on Schedule 2 of the form? |
plants_reported_owner |
boolean |
Is the reporting entity an owner of power plants reported on Schedule 2 of the form? |
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
street_address |
string |
N/A |
utility_id_eia |
integer |
The EIA Utility Identification number. |
zip_code |
string |
Five digit US Zip Code. |
zip_code_4 |
string |
Four digit US Zip Code suffix. |
utilities_entity_eia#
Static attributes of utilities, compiled from all EIA data. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
utilities_ferc1#
This table maps two manually assigned utility IDs: a PUDL ID and a FERC1 ID. The PUDL ID maps EIA and FERC1 utilities. The FERC1 ID maps the older DBF respondent IDs to new XBRL entity IDs. This table is generated from a table stored in the PUDL repository: src/package_data/glue/utility_id_pudl.csv Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_ferc1 |
string |
Name of the responding utility, as it is reported in FERC Form 1. For human readability only. |
utilities_ferc1_dbf#
This table maps the assign utility ID FERC1 to the native utility ID from the FERC1 DBF inputs - originally reported as respondent_id. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_ferc1_dbf |
integer |
FERC-assigned respondent_id from DBF reporting years, identifying the reporting entity. Stable from year to year. |
utilities_ferc1_xbrl#
This table maps the assign utility ID FERC1 to the native utility ID from the FERC1 XBRL inputs - originally reported as entity_id. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_id_ferc1_xbrl |
string |
FERC-assigned entity_id from XBRL reporting years, identifying the reporting entity. Stable from year to year. |
utilities_pudl#
Home table for PUDL assigned utility IDs. 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 Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_name_pudl |
string |
Utility name, chosen arbitrarily from the several possible utility names available in the utility matching process. Included for human readability only. |
utility_assn_eia861#
Association table indicating which states each utility reported data for by year. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_data_misc_eia861#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
alternative_fuel_vehicle_2_activity |
boolean |
N/A |
alternative_fuel_vehicle_activity |
boolean |
N/A |
bundled_activity |
boolean |
N/A |
buying_distribution_activity |
boolean |
N/A |
buying_transmission_activity |
boolean |
N/A |
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
distribution_activity |
boolean |
N/A |
entity_type |
string |
Entity type of principal owner. |
generation_activity |
boolean |
N/A |
nerc_region |
string |
NERC region in which the plant is located |
operates_generating_plant |
boolean |
N/A |
report_date |
date |
Date reported. |
retail_marketing_activity |
boolean |
N/A |
short_form |
boolean |
N/A |
state |
string |
Two letter US state abbreviation. |
transmission_activity |
boolean |
N/A |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_name_eia |
string |
The name of the utility. |
wholesale_marketing_activity |
boolean |
N/A |
utility_data_nerc_eia861#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
nerc_region |
string |
NERC region in which the plant is located |
nerc_regions_of_operation |
string |
N/A |
report_date |
date |
Date reported. |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_data_rto_eia861#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
data_maturity |
string |
Level of maturity of the data record. Some data sources report less-than-final data. PUDL sometimes includes this data, but use at your own risk. |
nerc_region |
string |
NERC region in which the plant is located |
report_date |
date |
Date reported. |
rtos_of_operation |
string |
N/A |
state |
string |
Two letter US state abbreviation. |
utility_id_eia |
integer |
The EIA Utility Identification number. |
utility_plant_assn#
No table description available. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
plant_id_pudl |
integer |
A manually assigned PUDL plant ID. May not be constant over time. |
utility_id_pudl |
integer |
A manually assigned PUDL utility ID. May not be stable over time. |
utility_plant_summary_ferc1#
Summary of utility plant and accumulated provisions for depreciation, amortization and depletion of utilty plant assets reported annually at the end of the report year. Schedule 200 of FERC Form 1. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
ending_balance |
number |
Account balance at end of year. |
record_id |
string |
Identifier indicating original FERC Form 1 source record. format: {table_name}_{report_year}_{report_prd}_{respondent_id}_{spplmnt_num}_{row_number}. Unique within FERC Form 1 DB tables which are not row-mapped. |
report_year |
integer |
Four-digit year in which the data was reported. |
row_type_xbrl |
string |
Indicates whether the value reported in the row is calculated, or uniquely reported within the table. |
utility_id_ferc1 |
integer |
PUDL-assigned utility ID, identifying a FERC1 utility. This is an auto-incremented ID and is not expected to be stable from year to year. |
utility_plant_asset_type |
string |
Type of utility plant asset reported in the utility_plant_summary_ferc1 table. Assets include those leased to others, held for future use, construction work-in-progress and details of accumulated depreciation. |
utility_type |
string |
Listing of utility plant types. Examples include Electric Utility, Gas Utility, and Other Utility. |
utility_type_other |
string |
Freeform description of type of utility reported in one of the other three other utility_type sections in the utility_plant_summary_ferc1 table. This field is reported only in the DBF reporting years (1994-2020). |
wet_dry_bottom_eia#
A coding table describing whether boiler has a wet or dry bottom in the EIA-860. Browse or query this table in Datasette.
Field Name |
Type |
Description |
---|---|---|
code |
string |
Originally reported short code. |
description |
string |
Long human-readable description of the meaning of a code/label. |
label |
string |
Longer human-readable code using snake_case |