Source code for pudl.metadata.resources.eia860
"""Definitions of data tables primarily coming from EIA-860."""
from typing import Any
from pudl.metadata.resource_helpers import (
canonical_harvested_details,
inherits_harvested_values_details,
)
[docs]
RESOURCE_METADATA: dict[str, dict[str, Any]] = {
"core_eia860__scd_boilers": {
"description": {
"additional_summary_text": (
"boilers which may vary from year to year. Compiled from across all "
"EIA-860 data."
),
"additional_details_text": canonical_harvested_details("boilers", False),
"usage_warnings": ["harvested"],
},
"schema": {
"fields": [
"plant_id_eia",
"boiler_id",
"report_date",
"boiler_operating_date",
"boiler_status",
"boiler_retirement_date",
"boiler_type",
"firing_type_1",
"firing_type_2",
"firing_type_3",
"firing_rate_using_coal_tons_per_hour",
"firing_rate_using_oil_bbls_per_hour",
"firing_rate_using_gas_mcf_per_hour",
"firing_rate_using_other_fuels",
"boiler_fuel_code_1",
"boiler_fuel_code_2",
"boiler_fuel_code_3",
"boiler_fuel_code_4",
"waste_heat_input_mmbtu_per_hour",
"wet_dry_bottom",
"fly_ash_reinjection",
"hrsg",
"max_steam_flow_lbs_per_hour",
"turndown_ratio",
"efficiency_100pct_load",
"efficiency_50pct_load",
"air_flow_100pct_load_cubic_feet_per_minute",
"new_source_review",
"new_source_review_date",
"new_source_review_permit",
"regulation_particulate",
"regulation_so2",
"regulation_nox",
"standard_particulate_rate",
"standard_so2_rate",
"standard_nox_rate",
"unit_particulate",
"unit_so2",
"unit_nox",
"compliance_year_particulate",
"compliance_year_nox",
"compliance_year_so2",
"particulate_control_out_of_compliance_strategy_1",
"particulate_control_out_of_compliance_strategy_2",
"particulate_control_out_of_compliance_strategy_3",
"so2_control_out_of_compliance_strategy_1",
"so2_control_out_of_compliance_strategy_2",
"so2_control_out_of_compliance_strategy_3",
"so2_control_existing_caaa_compliance_strategy_1",
"so2_control_existing_caaa_compliance_strategy_2",
"so2_control_existing_caaa_compliance_strategy_3",
"so2_control_planned_caaa_compliance_strategy_1",
"so2_control_planned_caaa_compliance_strategy_2",
"so2_control_planned_caaa_compliance_strategy_3",
"nox_control_out_of_compliance_strategy_1",
"nox_control_out_of_compliance_strategy_2",
"nox_control_out_of_compliance_strategy_3",
"nox_control_existing_caaa_compliance_strategy_1",
"nox_control_existing_caaa_compliance_strategy_2",
"nox_control_existing_caaa_compliance_strategy_3",
"nox_control_planned_caaa_compliance_strategy_1",
"nox_control_planned_caaa_compliance_strategy_2",
"nox_control_planned_caaa_compliance_strategy_3",
"compliance_year_mercury",
"mercury_control_existing_strategy_1",
"mercury_control_existing_strategy_2",
"mercury_control_existing_strategy_3",
"mercury_control_existing_strategy_4",
"mercury_control_existing_strategy_5",
"mercury_control_existing_strategy_6",
"mercury_control_proposed_strategy_1",
"mercury_control_proposed_strategy_2",
"mercury_control_proposed_strategy_3",
"nox_control_existing_strategy_1",
"nox_control_existing_strategy_2",
"nox_control_existing_strategy_3",
"nox_control_manufacturer",
"nox_control_manufacturer_code",
"nox_control_proposed_strategy_1",
"nox_control_proposed_strategy_2",
"nox_control_proposed_strategy_3",
"nox_control_status_code",
"regulation_mercury",
"so2_control_existing_strategy_1",
"so2_control_existing_strategy_2",
"so2_control_existing_strategy_3",
"so2_control_proposed_strategy_1",
"so2_control_proposed_strategy_2",
"so2_control_proposed_strategy_3",
"standard_so2_percent_scrubbed",
"data_maturity",
],
"primary_key": ["plant_id_eia", "boiler_id", "report_date"],
"foreign_key_rules": {
"fields": [["plant_id_eia", "boiler_id", "report_date"]],
# TODO: Excluding monthly data tables since their report_date
# values don't match up with core_eia860__scd_generators, which is annual,
# so non-january records violate the constraint.
# See: https://github.com/catalyst-cooperative/pudl/issues/1196
"exclude": [
"core_eia923__monthly_boiler_fuel",
"out_eia923__boiler_fuel",
"out_eia923__monthly_boiler_fuel",
"core_eia923__monthly_energy_storage",
],
},
},
"field_namespace": "eia",
"sources": ["eia860", "eia923"],
"etl_group": "eia860",
},
"core_eia860__assn_boiler_generator": {
"description": {
"additional_summary_text": "boilers and generators.",
"additional_source_text": "(Schedule 6, Part A)",
"additional_details_text": "Augmented with various heuristics within PUDL.",
},
"schema": {
"fields": [
"plant_id_eia",
"report_date",
"generator_id",
"boiler_id",
"unit_id_eia",
"unit_id_pudl",
"boiler_generator_assn_type_code",
"steam_plant_type_code",
"bga_source",
"data_maturity",
],
"primary_key": ["plant_id_eia", "report_date", "generator_id", "boiler_id"],
},
"field_namespace": "eia",
"sources": ["eia860", "eia923"],
"etl_group": "eia860",
},
"core_eia860__scd_generators": {
"description": {
"additional_summary_text": (
"generators which may vary from year to year. Compiled from across "
"EIA-860 and EIA-923 data."
),
"additional_details_text": canonical_harvested_details("generators", False),
"usage_warnings": ["harvested"],
},
"schema": {
"fields": [
"plant_id_eia",
"generator_id",
"utility_id_eia",
"report_date",
"operational_status_code",
"operational_status",
"ownership_code",
"capacity_mw",
"summer_capacity_mw",
"summer_capacity_estimate",
"winter_capacity_mw",
"winter_capacity_estimate",
"net_capacity_mwdc",
"energy_storage_capacity_mwh",
"prime_mover_code",
"energy_source_code_1",
"energy_source_code_2",
"energy_source_code_3",
"energy_source_code_4",
"energy_source_code_5",
"energy_source_code_6",
"energy_source_1_transport_1",
"energy_source_1_transport_2",
"energy_source_1_transport_3",
"energy_source_2_transport_1",
"energy_source_2_transport_2",
"energy_source_2_transport_3",
"fuel_type_code_pudl",
"can_burn_multiple_fuels",
"deliver_power_transgrid",
"distributed_generation",
"synchronized_transmission_grid",
"turbines_num",
"planned_modifications",
"planned_net_summer_capacity_uprate_mw",
"planned_net_winter_capacity_uprate_mw",
"planned_uprate_date",
"planned_net_summer_capacity_derate_mw",
"planned_net_winter_capacity_derate_mw",
"planned_derate_date",
"planned_new_prime_mover_code",
"planned_energy_source_code_1",
"planned_repower_date",
"other_planned_modifications",
"other_modifications_date",
"planned_generator_retirement_date",
"carbon_capture",
"startup_source_code_1",
"startup_source_code_2",
"startup_source_code_3",
"startup_source_code_4",
"technology_description",
"turbines_inverters_hydrokinetics",
"time_cold_shutdown_full_load_code",
"planned_new_capacity_mw",
"can_cofire_fuels",
"can_switch_oil_gas",
"nameplate_power_factor",
"minimum_load_mw",
"uprate_derate_during_year",
"uprate_derate_completed_date",
"current_planned_generator_operating_date",
"summer_estimated_capability_mw",
"winter_estimated_capability_mw",
"generator_retirement_date",
"owned_by_non_utility",
"reactive_power_output_mvar",
"ferc_qualifying_facility",
"data_maturity",
],
"primary_key": ["plant_id_eia", "generator_id", "report_date"],
"foreign_key_rules": {
"fields": [["plant_id_eia", "generator_id", "report_date"]],
# TODO: Excluding monthly data tables since their report_date
# values don't match up with core_eia860__scd_generators, which is annual,
# so non-january records violate the constraint.
# See: https://github.com/catalyst-cooperative/pudl/issues/1196
"exclude": [
"core_eia923__monthly_boiler_fuel",
"out_eia923__generation",
"out_eia923__monthly_generation",
"core_eia923__fuel_receipts_costs",
"out_eia923__fuel_receipts_costs",
"out_eia923__monthly_fuel_receipts_costs",
"core_eia923__monthly_generation",
"out_eia923__monthly_generation_fuel_by_generator_energy_source",
"out_eia923__monthly_generation_fuel_by_generator",
"core_eia923__monthly_generation_fuel",
"out_eia__monthly_generators",
"core_eia860m__changelog_generators",
"core_eia923__monthly_energy_storage",
],
},
},
"field_namespace": "eia",
"sources": ["eia860", "eia923"],
"etl_group": "eia860",
},
"core_eia860__scd_ownership": {
"description": {
"additional_summary_text": "generator ownership. Includes only jointly or third-party owned generators.",
"additional_source_text": "(Schedule 4)",
},
"schema": {
"fields": [
"report_date",
"owner_utility_id_eia",
"operator_utility_id_eia",
"plant_id_eia",
"generator_id",
"owner_utility_name_eia",
"owner_state",
"owner_city",
"owner_country",
"owner_street_address",
"owner_zip_code",
"fraction_owned",
"data_maturity",
],
"primary_key": [
"report_date",
"plant_id_eia",
"generator_id",
"owner_utility_id_eia",
],
},
"field_namespace": "eia",
"sources": ["eia860"],
"etl_group": "eia860",
},
"out_eia860__yearly_ownership": {
"description": {
"additional_summary_text": "generator ownership. Includes only jointly or third-party owned generators.",
"additional_source_text": "(Schedule 4)",
"additional_details_text": "Denormalized to include plant and utility names and other associated IDs.",
},
"schema": {
"fields": [
"report_date",
"plant_id_eia",
"plant_id_pudl",
"plant_name_eia",
"owner_utility_id_eia",
"operator_utility_id_eia",
"utility_id_pudl",
"owner_utility_name_eia",
"generator_id",
"owner_state",
"owner_city",
"owner_country",
"owner_street_address",
"owner_zip_code",
"fraction_owned",
"data_maturity",
],
"primary_key": [
"report_date",
"plant_id_eia",
"generator_id",
"owner_utility_id_eia",
],
},
"field_namespace": "eia",
"sources": ["eia860"],
"etl_group": "outputs",
},
"core_eia860__scd_plants": {
"description": {
"additional_summary_text": (
"plants which may vary from year to year. Compiled from across all "
"EIA-860 and EIA-923 data."
),
"additional_details_text": canonical_harvested_details("plants", False),
"usage_warnings": ["harvested"],
},
"schema": {
"fields": [
"plant_id_eia",
"report_date",
"ash_impoundment",
"ash_impoundment_lined",
"ash_impoundment_status",
"balancing_authority_code_eia",
"balancing_authority_name_eia",
"datum",
"energy_storage",
"ferc_cogen_docket_no",
"ferc_cogen_status",
"ferc_exempt_wholesale_generator_docket_no",
"ferc_exempt_wholesale_generator",
"ferc_small_power_producer_docket_no",
"ferc_small_power_producer",
"ferc_qualifying_facility_docket_no",
"grid_voltage_1_kv",
"grid_voltage_2_kv",
"grid_voltage_3_kv",
"iso_rto_code",
"liquefied_natural_gas_storage",
"natural_gas_local_distribution_company",
"natural_gas_storage",
"natural_gas_pipeline_name_1",
"natural_gas_pipeline_name_2",
"natural_gas_pipeline_name_3",
"nerc_region",
"has_net_metering",
"pipeline_notes",
"primary_purpose_id_naics",
"regulatory_status_code",
"reporting_frequency_code",
"sector_id_eia",
"sector_name_eia",
"service_area",
"transmission_distribution_owner_id",
"transmission_distribution_owner_name",
"transmission_distribution_owner_state",
"utility_id_eia",
"water_source",
"data_maturity",
],
"primary_key": ["plant_id_eia", "report_date"],
"foreign_key_rules": {
"fields": [["plant_id_eia", "report_date"]],
# TODO: Excluding monthly data tables since their report_date
# values don't match up with core_eia860__scd_plants, which is annual,
# so non-january records fail.
# See: https://github.com/catalyst-cooperative/pudl/issues/1196
# Also all the _core tables have not yet been harvested, so if they
# contain unique plant_id_eia and report_date combinations, those would
# be expected to fail.
"exclude": [
"_core_eia923__monthly_cooling_system_information",
"_core_eia923__yearly_fgd_operation_maintenance",
"_core_eia923__yearly_byproduct_disposition",
"_core_eia923__yearly_byproduct_expenses_and_revenues",
"_core_eia923__yearly_emissions_control",
"core_eia923__monthly_boiler_fuel",
"out_eia923__boiler_fuel",
"out_eia923__monthly_boiler_fuel",
"core_eia923__fuel_receipts_costs",
"out_eia923__fuel_receipts_costs",
"out_eia923__monthly_fuel_receipts_costs",
"out_eia923__generation",
"out_eia923__monthly_generation",
"out_eia923__generation_fuel_combined",
"out_eia923__monthly_generation_fuel_combined",
"out_eia923__monthly_generation_fuel_by_generator_energy_source",
"out_eia923__monthly_generation_fuel_by_generator",
"core_eia923__monthly_generation",
"core_eia923__monthly_generation_fuel",
"core_eia923__monthly_generation_fuel_nuclear",
"out_eia__monthly_generators",
"core_eia860m__changelog_generators",
"core_eia923__monthly_energy_storage",
],
},
},
"field_namespace": "eia",
"sources": ["eia860", "eia923"],
"etl_group": "eia860",
},
"core_eia860__scd_utilities": {
"description": {
"additional_summary_text": (
"utilities which may vary from year to year. Compiled from all EIA data."
),
"additional_details_text": canonical_harvested_details("utilities", False),
"usage_warnings": ["harvested"],
},
"schema": {
"fields": [
"utility_id_eia",
"report_date",
"street_address",
"city",
"state",
"zip_code",
"plants_reported_owner",
"plants_reported_operator",
"plants_reported_asset_manager",
"plants_reported_other_relationship",
"entity_type",
"attention_line",
"address_2",
"zip_code_4",
"contact_firstname",
"contact_lastname",
"contact_title",
"phone_number",
"phone_extension",
"contact_firstname_2",
"contact_lastname_2",
"contact_title_2",
"phone_number_2",
"phone_extension_2",
"data_maturity",
],
"primary_key": ["utility_id_eia", "report_date"],
"foreign_key_rules": {
"fields": [
["utility_id_eia", "report_date"],
["owner_utility_id_eia", "report_date"],
],
# TODO: Excluding monthly data tables since their report_date
# values don't match up with core_eia860__scd_plants, which is annual, so
# non-january records fail.
# See: https://github.com/catalyst-cooperative/pudl/issues/1196
# NOTE: EIA-861 has not gone through harvesting / normalization yet.
"exclude": [
"core_eia861__yearly_advanced_metering_infrastructure",
"core_eia861__assn_balancing_authority",
"out_eia861__yearly_utility_service_territory",
"core_eia861__yearly_demand_response",
"core_eia861__yearly_demand_response_water_heater",
"core_eia861__yearly_demand_side_management_ee_dr",
"core_eia861__yearly_demand_side_management_misc",
"core_eia861__yearly_demand_side_management_sales",
"out_eia923__boiler_fuel",
"out_eia923__monthly_boiler_fuel",
"core_eia923__fuel_receipts_costs",
"out_eia923__fuel_receipts_costs",
"out_eia923__monthly_fuel_receipts_costs",
"out_eia923__generation",
"out_eia923__monthly_generation",
"out_eia923__generation_fuel_combined",
"out_eia923__monthly_generation_fuel_combined",
"out_eia923__monthly_generation_fuel_by_generator_energy_source",
"out_eia923__monthly_generation_fuel_by_generator",
"core_eia860m__changelog_generators",
# Utility IDs in this table are owners, not operators, and we are
# not yet harvesting owner_utility_id_eia from core_eia860__scd_ownership.
# See https://github.com/catalyst-cooperative/pudl/issues/1393
"out_eia923__yearly_generation_fuel_by_generator_energy_source_owner",
"core_eia861__yearly_distributed_generation_fuel",
"core_eia861__yearly_distributed_generation_misc",
"core_eia861__yearly_distributed_generation_tech",
"core_eia861__yearly_distribution_systems",
"core_eia861__yearly_dynamic_pricing",
"core_eia861__yearly_energy_efficiency",
"out_ferc714__respondents_with_fips",
"core_eia861__yearly_green_pricing",
"out_eia__monthly_generators",
"core_eia861__yearly_mergers",
"core_eia861__yearly_net_metering_customer_fuel_class",
"core_eia861__yearly_net_metering_misc",
"core_eia861__yearly_non_net_metering_customer_fuel_class",
"core_eia861__yearly_non_net_metering_misc",
"core_eia861__yearly_operational_data_misc",
"core_eia861__yearly_operational_data_revenue",
"core_eia861__yearly_reliability",
"core_eia861__yearly_sales",
"core_eia861__yearly_short_form",
"core_eia861__yearly_service_territory",
"out_ferc714__summarized_demand",
"core_eia861__assn_utility",
"core_eia861__yearly_utility_data_misc",
"core_eia861__yearly_utility_data_nerc",
"core_eia861__yearly_utility_data_rto",
"out_sec10k__quarterly_company_information",
],
},
},
"field_namespace": "eia",
"sources": ["eia860", "eia923"],
"etl_group": "eia860",
},
"core_eia860__scd_emissions_control_equipment": {
"description": {
"additional_summary_text": (
"emissions control equipment reported to EIA, including cost, type, "
"operating status, retirement date, and install year."
),
"additional_details_text": (
f"""Includes control ids for sulfur dioxide
(SO2), particulate matter, mercury, nitrogen oxide (NOX), and acid (HCl) gas
monitoring.
{inherits_harvested_values_details("plants and utilities")}"""
),
"usage_warnings": ["harvested"],
},
"schema": {
"fields": [
"report_date",
"plant_id_eia",
"emission_control_id_pudl",
"data_maturity",
"emission_control_equipment_type_code",
"operational_status_code",
"mercury_control_id_eia",
"nox_control_id_eia",
"particulate_control_id_eia",
"so2_control_id_eia",
"acid_gas_control",
"emission_control_equipment_cost",
"emission_control_operating_date",
"emission_control_retirement_date",
],
"primary_key": ["report_date", "plant_id_eia", "emission_control_id_pudl"],
},
"field_namespace": "eia",
"sources": ["eia860"],
"etl_group": "eia860",
},
"out_eia860__yearly_emissions_control_equipment": {
"description": {
"additional_summary_text": "the cost, type, operating status, retirement date, and install year of emissions control equipment reported to EIA.",
"additional_details_text": """Includes control ids for sulfur dioxide
(SO2), particulate matter, mercury, nitrogen oxide (NOX), and acid (HCl) gas monitoring.
This denormalized version includes plant name, utility id, pudl id, and utility name
columns.""",
},
"schema": {
"fields": [
"report_date",
"plant_id_eia",
"plant_id_pudl",
"plant_name_eia",
"utility_id_eia",
"utility_id_pudl",
"utility_name_eia",
"emission_control_id_pudl",
"data_maturity",
"emission_control_equipment_type_code",
"operational_status_code",
"operational_status",
"mercury_control_id_eia",
"nox_control_id_eia",
"particulate_control_id_eia",
"so2_control_id_eia",
"acid_gas_control",
"emission_control_equipment_cost",
"emission_control_operating_date",
"emission_control_retirement_date",
],
"primary_key": ["report_date", "plant_id_eia", "emission_control_id_pudl"],
},
"field_namespace": "eia",
"sources": ["eia860"],
"etl_group": "eia860",
},
"core_eia860__assn_yearly_boiler_emissions_control_equipment": {
"description": {
"additional_summary_text": (
"EIA boiler IDs and emissions control IDs for NOx, SO2, "
"mercury, and particulate monitoring."
),
"usage_warnings": [
{
"type": "custom",
"description": "The relationship between the IDs is sometimes many to many.",
},
],
},
"schema": {
"fields": [
"report_date",
"plant_id_eia",
"boiler_id",
"emission_control_id_type",
"emission_control_id_eia",
"data_maturity",
],
"primary_key": [
"report_date",
"plant_id_eia",
"boiler_id",
"emission_control_id_type",
"emission_control_id_eia",
],
},
"field_namespace": "eia",
"sources": ["eia860"],
"etl_group": "eia860",
},
"core_eia860__assn_boiler_cooling": {
"description": {
"additional_summary_text": "EIA boiler IDs and EIA cooling system IDs.",
},
"schema": {
"fields": [
"report_date",
"plant_id_eia",
"boiler_id",
"cooling_id_eia",
"data_maturity",
],
"primary_key": [
"report_date",
"plant_id_eia",
"boiler_id",
"cooling_id_eia",
],
},
"field_namespace": "eia",
"sources": ["eia860"],
"etl_group": "eia860",
},
"core_eia860__assn_boiler_stack_flue": {
"description": {
"additional_summary_text": "EIA boiler IDs and EIA stack and/or flue system IDs.",
},
"schema": {
"fields": [
"report_date",
"plant_id_eia",
"boiler_id",
"stack_id_eia",
"flue_id_eia",
"stack_flue_id_eia",
"stack_flue_id_pudl",
],
"primary_key": [
"report_date",
"plant_id_eia",
"boiler_id",
"stack_flue_id_pudl",
],
},
"field_namespace": "eia",
"sources": ["eia860"],
"etl_group": "eia860",
},
"_core_eia860__cooling_equipment": {
"description": {
"additional_summary_text": "Information about cooling equipment at generation facilities.",
"additional_source_text": "(Schedule 6D)",
"usage_warnings": [
{
"type": "unharvested",
"description": (
"This table has not been harvested with other "
"EIA 923 or 860 data. The same variables present in this table "
"may show up in other _core tables in other years."
),
},
],
"additional_details_text": """A single plant can have
several collections of cooling equipment, so each line in this table represents one
cooling system at a given plant. You can determine how to link each set of cooling
equipment to specific boilers in a plant via :ref:`core_eia860__assn_boiler_cooling`.
EIA-860 respondents are required to submit information about cooling equipment for
plants over 100 MW - including steam, combined cycle, nuclear or solar thermal
generators.
This table has been cleaned, but not tidied/normalized with other EIA 923 or 860
data. The same variables present in this table may show up in other
tables and/or in other years. Once this table has been harvested, it will be converted
into a``core`` table.""",
},
"schema": {
"fields": [
"report_date",
"plant_id_eia",
"plant_name_eia",
"cooling_id_eia",
"utility_id_eia",
"utility_name_eia",
"county",
"state",
"chlorine_equipment_cost",
"chlorine_equipment_operating_date",
"cooling_equipment_total_cost",
"cooling_status_code",
"cooling_system_operating_date",
"cooling_type_1",
"cooling_type_2",
"cooling_type_3",
"cooling_type_4",
"cooling_water_discharge",
"cooling_water_source",
"intake_distance_shore_feet",
"intake_distance_surface_feet",
"intake_rate_100pct_gallons_per_minute",
"outlet_distance_shore_feet",
"outlet_distance_surface_feet",
"percent_dry_cooling",
"plant_summer_capacity_mw",
"pond_cost",
"pond_operating_date",
"pond_surface_area_acres",
"pond_volume_acre_feet",
"power_requirement_mw",
"steam_plant_type_code",
"tower_cost",
"tower_operating_date",
"tower_type_1",
"tower_type_2",
"tower_type_3",
"tower_type_4",
"tower_water_rate_100pct_gallons_per_minute",
"water_source_code",
"water_source",
"water_type_code",
],
"primary_key": [
"plant_id_eia",
"utility_id_eia",
"cooling_id_eia",
"report_date",
],
},
"field_namespace": "eia",
"sources": ["eia860"],
"etl_group": "eia860",
},
"_core_eia860__fgd_equipment": {
"description": {
"additional_summary_text": "Information about flue gas desulfurization equipment at generation facilities.",
"additional_source_text": "(Schedule 6E)",
"usage_warnings": [
{
"type": "unharvested",
"description": (
"This table has not been harvested with other "
"EIA 923 or 860 data. The same variables present in this table "
"may show up in other _core tables in other years."
),
},
],
},
"schema": {
"fields": [
"report_date",
"plant_id_eia",
"so2_control_id_eia",
"utility_id_eia",
"utility_name_eia",
"state",
"state_id_fips",
"county",
"county_id_fips",
"fgd_operating_date",
"fgd_operational_status_code",
"flue_gas_bypass_fgd",
"byproduct_recovery",
"sludge_pond",
"sludge_pond_lined",
"pond_landfill_requirements_acre_foot_per_year",
"fgd_structure_cost",
"fgd_other_cost",
"sludge_disposal_cost",
"total_fgd_equipment_cost",
"fgd_trains_100pct",
"fgd_trains_total",
"flue_gas_entering_fgd_pct_of_total",
"flue_gas_exit_rate_cubic_feet_per_minute",
"flue_gas_exit_temperature_fahrenheit",
"so2_emission_rate_lbs_per_hour",
"so2_equipment_type_1",
"so2_equipment_type_2",
"so2_equipment_type_3",
"so2_equipment_type_4",
"so2_removal_efficiency_design",
"specifications_of_coal_ash",
"specifications_of_coal_sulfur",
"sorbent_type_1",
"sorbent_type_2",
"sorbent_type_3",
"sorbent_type_4",
"fgd_manufacturer",
"fgd_manufacturer_code",
"steam_plant_type_code",
"plant_summer_capacity_mw",
"water_source",
"data_maturity",
],
"primary_key": [
"plant_id_eia",
"so2_control_id_eia",
"report_date",
],
},
"field_namespace": "eia",
"sources": ["eia860"],
"etl_group": "eia860",
},
"core_eia860__scd_generators_wind": {
"description": {
"additional_summary_text": "wind generators that may vary from year to year.",
"additional_source_text": "(Schedule 3.2)",
"additional_details_text": (
"This table includes only those values that are unique to wind generators. "
"The rest of the columns that are reported in the EIA-860 Wind tabs are "
"included in :ref:`core_eia860__scd_generators` and :ref:`core_eia__entity_generators`."
),
},
"schema": {
"fields": [
"plant_id_eia",
"generator_id",
"report_date",
"design_wind_speed_mph",
"obstacle_id_faa",
"predominant_turbine_manufacturer",
"predominant_turbine_model",
"turbine_hub_height_feet",
"wind_quality_class",
],
"primary_key": [
"plant_id_eia",
"generator_id",
"report_date",
],
},
"field_namespace": "eia",
"sources": ["eia860"],
"etl_group": "eia860",
},
"core_eia860__scd_generators_solar": {
"description": {
"additional_summary_text": "solar generators that may vary from year to year.",
"additional_source_text": "(Schedule 3.3)",
"additional_details_text": (
"This table includes only those values that are unique to solar generators. "
"The rest of the columns that are reported in the EIA-860 Solar tabs are "
"included in :ref:`core_eia860__scd_generators` and :ref:`core_eia__entity_generators`."
),
},
"schema": {
"fields": [
"plant_id_eia",
"generator_id",
"report_date",
"standard_testing_conditions_capacity_mwdc",
"net_metering_capacity_mwdc",
"uses_net_metering_agreement",
"uses_virtual_net_metering_agreement",
"virtual_net_metering_capacity_mwdc",
"azimuth_angle_deg",
"tilt_angle_deg",
"uses_technology_lenses_mirrors",
"uses_technology_single_axis_tracking",
"uses_technology_dual_axis_tracking",
"uses_technology_fixed_tilt",
"uses_technology_east_west_fixed_tilt",
"uses_technology_parabolic_trough",
"uses_technology_linear_fresnel",
"uses_technology_power_tower",
"uses_technology_dish_engine",
"uses_technology_other",
"uses_material_crystalline_silicon",
"uses_material_thin_film_a_si",
"uses_material_thin_film_cdte",
"uses_material_thin_film_cigs",
"uses_material_thin_film_other",
"uses_material_other",
"uses_bifacial_panels",
],
"primary_key": [
"plant_id_eia",
"generator_id",
"report_date",
],
},
"field_namespace": "eia",
"sources": ["eia860"],
"etl_group": "eia860",
},
"core_eia860__scd_generators_energy_storage": {
"description": {
"additional_summary_text": "energy storage which may vary from year to year.",
"additional_source_text": "(Schedule 3)",
"additional_details_text": (
"This table includes only those values that are unique to energy storage. "
"The rest of the columns that are reported in the EIA-860 Energy Storage tabs are "
"included in :ref:`core_eia860__scd_generators` and :ref:`core_eia__entity_generators`."
),
},
"schema": {
"fields": [
"plant_id_eia",
"generator_id",
"report_date",
"max_charge_rate_mw",
"max_discharge_rate_mw",
"storage_enclosure_code",
"storage_technology_code_1",
"storage_technology_code_2",
"storage_technology_code_3",
"storage_technology_code_4",
"served_arbitrage",
"served_backup_power",
"served_co_located_renewable_firming",
"served_frequency_regulation",
"served_load_following",
"served_load_management",
"served_ramping_spinning_reserve",
"served_system_peak_shaving",
"served_transmission_and_distribution_deferral",
"served_voltage_or_reactive_power_support",
"stored_excess_wind_and_solar_generation",
"is_ac_coupled",
"is_dc_coupled",
"is_dc_coupled_tightly",
"is_independent",
"is_transmission_and_distribution_asset_support",
"is_direct_support",
"plant_id_eia_direct_support_1",
"generator_id_direct_support_1",
"plant_id_eia_direct_support_2",
"generator_id_direct_support_2",
"plant_id_eia_direct_support_3",
"generator_id_direct_support_3",
],
"primary_key": [
"plant_id_eia",
"generator_id",
"report_date",
],
},
"field_namespace": "eia",
"sources": ["eia860"],
"etl_group": "eia860",
},
"core_eia860__scd_generators_multifuel": {
"description": {
"additional_summary_text": "generators that may vary from year to year, pertaining to fuel-switching and the use of multiple fuels.",
"additional_source_text": "(Schedule 3)",
},
"schema": {
"fields": [
"report_date",
"utility_id_eia",
"utility_name_eia",
"plant_id_eia",
"plant_name_eia",
"state",
"county",
"generator_id",
"operational_status_code",
"technology_description",
"prime_mover_code",
"sector_name_eia",
"sector_id_eia",
"capacity_mw",
"summer_capacity_mw",
"winter_capacity_mw",
"current_planned_generator_operating_date",
"energy_source_code_1",
"energy_source_code_2",
"can_burn_multiple_fuels",
"can_cofire_fuels",
"cofire_energy_source_1",
"cofire_energy_source_2",
"cofire_energy_source_3",
"cofire_energy_source_4",
"cofire_energy_source_5",
"cofire_energy_source_6",
"can_switch_oil_gas",
"time_to_switch_oil_to_gas",
"time_to_switch_gas_to_oil",
"can_switch_when_operating",
"net_summer_capacity_natural_gas_mw",
"net_summer_capacity_oil_mw",
"net_winter_capacity_natural_gas_mw",
"net_winter_capacity_oil_mw",
"has_factors_that_limit_switching",
"has_storage_limits",
"has_air_permit_limits",
"has_other_factors_that_limit_switching",
"can_cofire_oil_and_gas",
"can_cofire_100_oil",
"max_oil_heat_input",
"max_oil_output_mw",
"can_fuel_switch",
"has_regulatory_limits",
"fuel_switch_energy_source_1",
"fuel_switch_energy_source_2",
"fuel_switch_energy_source_3",
"fuel_switch_energy_source_4",
"fuel_switch_energy_source_5",
"fuel_switch_energy_source_6",
],
"primary_key": [
"report_date",
"utility_id_eia",
"generator_id",
"plant_id_eia",
],
},
"field_namespace": "eia",
"sources": ["eia860"],
"etl_group": "eia860",
},
}
"""EIA-860 resource attributes organized by PUDL identifier (``resource.name``).
Keys are in alphabetical order.
See :func:`pudl.metadata.helpers.build_foreign_keys` for the expected format of
``foreign_key_rules``.
"""