NYSgptData LibraryConnectPricing

EIA plant, utility and operations surveys

Generators and plants (Form 860, 2001 to 2025), utilities and sales (Form 861, 2012 to 2025), plant operations and fuel (Form 923, 2001 to 2025).

4.1MRecords
294Tables
10,472Fields
CurrentYears

Publisher: U.S. Energy Information Administration

Try it

This runs against the full table, free, with no key.

Tables
eia923_eia_schedules_m_final_revision_sheet_page_fuel_receipts_and_costs408Keia860_generator_y_sheet_operable300Keia860_plant_y_sheet_plant157Keia923_eia_schedules_m_final_revision_sheet_page_generation_and_fuel_data155Keia923_eia_schedule_annual_environmental_information_final_revision_sheet_d_cooling_system_information115Keia861_service_territory_sheet_counties_states106Keia923_eia_schedules_m_final_revision_sheet_page_boiler_fuel_data104Keia923_eia_schedules_m_final_revision_sheet_page_plant_frame104Keia923_eia_schedules_final_revision_sheet_page_fuel_receipts_and_costs95.7Keia860_enviroassoc_y_sheet_boiler_generator94.4Keia860_geny_sheet_geny92.7Keia923_eia_schedules_m_final_sheet_page_fuel_receipts_and_costs73.1Keia923_eia_schedules_nu_sourcendisposition_final_revision_sheet_source_and_disposition73Keia860_enviroassoc_y_sheet_emissions_control_equipment72.9Keia860_utility_y_sheet_utility68.7Keia860_owner_y_sheet_ownership63.7Keia923_eiadecember_sheet_page_fuel_receipts_and_cost61.8Keia860_enviroequip_y_sheet_boiler_info_design_parameters59.8Keia860_enviroequip_y_sheet_emission_standards_strategies59.8Keia861_service_territory_sheet_counties59.4Keia923_eia_schedule_annual_envir_infor_final_sheet_d_cooling_system_information58.6Keia860_generator_y_sheet_retired_and_canceled58.2Keia923_eia_schedule_annual_environmental_information_final_revision_sheet_a_annual_byproduct_disposition54.9Keia860_solar_y_sheet_operable53.4Keia860_geny_dbf50.2Keia923_eia_schedule_annual_environmental_information_final_revision_sheet_c_air_emissions_control_info46.6Keia860_planty_sheet_planty45.2Keia923_eia_schedules_m_final_revision_sheet_page_generator_data42.6Keia860_multifuel_y_sheet_operable41.2Keia860_utily_sheet_utily38.7Keia860_enviroassoc_y_sheet_boiler_cooling38.6Keia860_enviroassoc_y_sheet_boiler_stack_flue38Keia860_generatory_sheet_operable37.6Keia861_sales_ult_cust_sheet_states37.5Keia923_eia_schedules_m_final_sheet_page_generation_and_fuel_data36.9Keia861_frame_sheet_frame34.1Keia860_enviroequip_y_sheet_stack_flue31Keia860_enviroassoc_y_sheet_boiler_particulate_matter30.9Keia923_eia_schedule_annual_environmental_information_final_sheet_d_cooling_system_information30.8Keia860_enviroequip_y_sheet_fgp29.6Keia861_advanced_meters_sheet_states28.7Keia923_eia_schedules_m_final_sheet_page_plant_frame27.8Keia861_operational_data_sheet_states27.3Keia923_eia_schedule_annual_envir_infor_final_sheet_c_air_emissions_control_info26.2Keia860_ownery_sheet_ownery25Keia923_eia_schedules_nu_sourcendisposition_final_sheet_source_and_disposition24.4Keia860_enviroequip_y_sheet_cooling24.2Keia860_generator_y_sheet_proposed23.3Keia861_utility_data_sheet_states22.7Keia860_enviroassoc_y_sheet_boiler_nox22Keia923_eia_schedules_final_revision_sheet_page_generation_and_fuel_data21.9Keia923_eia_schedule_annual_envir_infor_final_sheet_a_annual_byproduct_disposition20.2Keia861_distribution_systems_sheet_distribution_systems_states19Keia861_short_form_sheet_s18.2Keia923_eia_schedules_m_final_revision_sheet_page_oil_stocks_data18.2Keia860_enviroassoc_y_sheet_boiler_mercury17.6Keia923_eia_schedule_partsa_f_envdata_final_revision_sheet_d_cooling_operations17.5Keia860_wind_y_sheet_operable17.3Keia860_planty_dbf17.2Keia923_eia_schedule_partsa_d_envdata_final_revision_sheet_d_cooling_system_information17Keia923_eia_schedules_m_final_sheet_page_boiler_fuel_data16.6Keia923_eia_schedules_final_revision_sheet_page_boiler_fuel_data15.8Keia923_eia_schedule_annual_environmental_information_final_sheet_c_air_emissions_control_info14.2Keia860_utilityy_sheet_utilityy13.8Keia861_reliability_sheet_reliability_states13.2Keia923_eia_schedules_final_revision_sheet_page_plant_frame12.9Keia860_utily_dbf12.8Keia860_enviroassoc_y_sheet_boiler_so12.3Keia923_eia_schedule_annual_environmental_information_final_sheet_a_annual_byproduct_disposition11.5Keia860_enviroequip_y_sheet_fgd11.1Keia923_eiadecember_sheet_page_generation_and_fuel_data10.1Keia860_prgeny_sheet_prgeny9.8Keia860_eia_form_sheet_trans_dist_list9.6Keia923_eia_schedules_m_final_revision_sheet_page_file_layout8.7Keia860_eia_form_sheet_pipeline_ldc_list8.5Keia861_dynamic_pricing_sheet_dynamic_pricing_states8.4Keia860_multifuel_y_sheet_retired_and_canceled8Keia923_eia_schedules_m_final_revision_sheet_page_coal_stocks_data7.8Keia861_net_metering_sheet_states7.8Keia923_eia_schedule_partsa_f_envdata_final_revision_sheet_a_byproduct_disposition7.6Keia923_nonutility_source_and_disposition_sheet_page_source_and_disposition7.5Keia860_enviroassocy_sheet_boiler_generator7.5Keia923_eia_schedule_partsa_d_envdata_final_revision_sheet_a_annual_byproduct_disposition7.4Keia860_enviroassocy_sheet_boiler_gen7.3Keia860_planty_sheet_plant7.3Keia860_multifuely_sheet_operable7.2Keia861_energy_efficiency_sheet_energy_efficiency_states7.2Keia860_mfexisty_sheet_mfexisty7.1Keia923_eia_schedules_m_final_sheet_page_generator_data7.1Keia860_plant_sheet_plant6.9Keia923_eiadecember_sheet_page_boiler_fuel_data6.8Keia860_mfexist_sheet_mfexist6.7Keia923_eia_schedule_partsa_d_envdata_final_revision_sheet_c_air_emissions_control_info6.6Keia860_utilityy_sheet_utility6.6Keia923_eia_schedules_final_revision_sheet_page_generator_data6.5Keia860_ownery_dbf6.4Keia861_sales_ult_cust_cs_sheet_customer_sited6.3Keia860_prgeny_dbf5.9Keia861_balancing_authority_sheet_balancing_authority5.8Keia923_eia_schedule_annual_environmental_information_final_revision_sheet_b_financial_information5.5Keia923_eia_schedule_annual_environmental_information_final_revision_sheet_c_fgd_operation_maintenance5.5Keia860_layouty_sheet_field_directory5.3Keia860_enviroassocy_sheet_boiler_fgp5.1Keia860_enviroequipy_sheet_boiler4.8Keia860_enviroequipy_sheet_controls4.8Keia923_eia_schedules_final_revision_sheet_page_oil_stocks_data4.8Keia860_enviroequip_sheet_boiler4.7Keia860_enviroequip_sheet_controls4.7Keia860_ownery_sheet_ownership4.3Keia861_demand_response_sheet_demand_response_states4.2Keia860_ownershipy_sheet_ownership4.1Keia860_solar_y_sheet_retired_and_canceled4Keia860_energy_storage_y_sheet_operable3.9Keia923_eia_schedules_m_final_revision_sheet_page_energy_storage3.6Keia861_non_net_metering_distributed_sheet_states3.6Keia923_eia_schedule_partsa_f_envdata_final_revision_sheet_c_boiler_nox_operations3.3Keia860_mfexisty_sheet_mfexist3.2Keia860_eia_form_sheet_list_of_county3.2Keia860_enviroassocy_sheet_boiler_stack_flue3.1Keia860_enviroassocy_sheet_boiler_stackflue3.1Keia923_nonutility_source_and_disposition_sheet_schedule3Keia860_enviroassocy_sheet_boiler_cooler3Keia923_eia_schedule_annual_envir_infor_final_sheet_c_fgd_operation_maintenance3Keia860_enviroassocy_sheet_boiler_cool3Keia860_eia_form_sheet_wind_man_model_list3Keia923_eiadecember_sheet_page_generator_data2.9Keia923_nonutility_source_and_disposition_sheet_nonutility_schedule2.9Keia923_eia_schedules_m_final_sheet_page_energy_storage2.8Keia860_owner_dbf2.8Keia860_generatory_sheet_retired_and_canceled2.7Keia923_nonutility_source_and_disposition_sheet_source_and_disposition2.7Keia860_enviroequipy_sheet_stack_flue2.5Keia860_enviroequip_sheet_stack_flue2.4Keia860_enviroequipy_sheet_fgp2.4Keia860_enviroequip_sheet_fgp2.4Keia923_eiadecember_sheet_page_oil_stocks_data2.4Keia860_generatory_sheet_retired_canceled2.3Keia861_net_metering_sheet_tpo2.3Keia923_eia_schedules_m_final_sheet_page_oil_stocks_data2.2Keia860_eia_form_sheet_info_for_drop_downs2.1Keia923_eia_schedule_partsa_f_envdata_final_revision_sheet_e_fgp_operations2.1Keia861_net_metering_sheet_states_utility_level2.1Keia860_enviroequipy_sheet_cooling1.9Keia860_enviroequip_sheet_cooling1.9Keia860_generatory_sheet_proposed1.9Keia860_enviroassocy_sheet_boiler_fgd1.8Keia923_eia_schedules_final_revision_sheet_page_coal_stocks_data1.8Keia923_eia_schedule_annual_envir_infor_final_sheet_b_financial_information1.7Keia923_eia_schedule_annual_environmental_information_final_sheet_c_fgd_operation_maintenance1.7Keia860_energy_storage_y_sheet_proposed1.7Keia860_eia_form_sheet_sch_part_b1.6Keia861_non_net_metering_distributed_sheet_states_utility_level1.5Keia860_eia_form_sheet_ba_list1.5Keia923_eia_schedule_annual_environmental_information_final_revision_sheet_file_layout1.4Keia860_wind_y_sheet_retired_and_canceled1.4Keia860_layouty_sheet_reference_tables1.3Keia860_pcgeny_sheet_pcgeny1.1Keia923_eia_schedule_annual_environmental_information_final_sheet_b_financial_information1.1Keia861_net_metering_sheet_utility_level_states1.1Keia861_net_metering_sheet_net_metering_states1.1Keia860_intcony_sheet_intcony1Keia923_eiadecember_sheet_page_coal_stocks_data952eia861_sales_ult_cust_sheet_decoupled942eia860_eia_form_sheet_sch_part_c882eia923_eia_schedules_m_final_sheet_page_file_layout830eia923_eia_schedule_annual_envir_infor_final_sheet_file_layout828eia860_enviroequipy_sheet_fgd808eia861_service_territory_sheet_counties_territories804eia860_enviroequip_sheet_fgd787eia861_net_metering_sheet_tpo_state_level755eia923_eia_schedule_partsa_d_envdata_final_revision_sheet_b_financial_information737eia860_eia_form_sheet_pm_es_drop_down727eia923_eia_schedule_partsa_d_envdata_final_revision_sheet_c_fgd_operation_maintenance709eia923_eia_schedules_m_final_revision_sheet_page_stocks_data671eia923_eia_schedule_partsa_f_envdata_final_revision_sheet_f_fgd_operations670eia860_interconnecty_sheet_interconnection661eia923_eia_schedule_partsa_f_envdata_final_revision_sheet_b_byproduct_expenses_and_reven600eia923_eia_schedules_m_final_revision_sheet_page_petcoke_stocks_data600eia860_layouty_sheet_reference_table588eia860_eia_form_sheet_sch_part_d560eia860_interconnectiony_sheet_interconnection558eia860_multifuel_y_sheet_proposed548eia923_eia_schedules_m_final_sheet_page_coal_stocks_data520eia860_energy_storage_y_sheet_retired_and_canceled465eia861_non_net_metering_distributed_sheet_utility_level_states443eia923_eia_schedules_m_final_revision_sheet_page_puerto_rico427eia860_interconnectiony_sheet_interconnectiony418eia860_eia_form_sheet_sch_part_f415eia923_eia_schedule_annual_environmental_information_final_sheet_file_layout414eia861_distributed_generation_sheet_distributed_states409eia860_mfpropy_sheet_mfpropy399eia860_interconnecty_sheet_interconnectiony382eia923_eia_schedules_m_final_revision_sheet_page_plant_frame_puerto_rico354eia860_eia_form_sheet_sch_part_g322eia923_eia_schedules_nu_sourcendisposition_final_revision_sheet_file_layout319eia860_multifuely_sheet_retired_and_canceled316eia860_layouty_sheet_reference_table_iv294eia860_multifuely_sheet_retired278eia860_intcon_sheet_intcon239eia861_distributed_generation_sheet_dispersed_states239eia860_eia_form_sheet_sch_part_a224eia861_eia_form_sheet_general_information_a222eia860_eia_form_sheet_sch_part_e217eia860_mfprop_sheet_mfprop212eia923_eia_schedule_partsa_d_envdata_final_revision_sheet_file_layout206eia923_schedule_a_a_a_b_c_d_e_f_on_nov_sheet_layout_and_users_guide205eia923_schedule_a_a_a_b_c_d_e_f_revised_sheet_layout_and_users_guide200eia860_layout_sheet_existing_generator197eia861_eia_form_sheet_identification194eia861_eia_form_sheet_wal192eia860_f_dbf_layout_sheet_existing_generator191eia860_layout_sheet_proposed_changes_to_existing184eia923_eia_schedules_m_final_sheet_page_puerto_rico176eia861_eia_form_sheet_net_metering_a170eia861_sales_ult_cust_sheet_territories157eia861_reliability_sheet_state_totals156eia861_mergers_sheet_mergers151eia861_non_net_metering_distributed_sheet_states_state_level146eia861_eia_form_sheet_dist_reliability_b_and_c144eia861_net_metering_sheet_utility_level_tpo142eia923_eia_schedules_final_revision_sheet_page_petcoke_stocks_data142eia860_multifuely_sheet_proposed138eia861_net_metering_sheet_net_metering_tpo136eia923_eia_schedules_m_final_sheet_page_plant_frame_puerto_rico127eia923_eia_schedules_final_revision_sheet_page_stocks_data123eia923_eia_schedules_m_final_sheet_page_stocks_data122eia861_sales_ult_cust_cs_sheet_states116eia860_layout_sheet_plant112eia860_layouty_sheet_reference_tables_ii110eia860_mfpropy_sheet_mfprop106eia861_net_metering_sheet_states_state_level104eia861_eia_form_sheet_energy_efficiency_a96eia861_eia_form_sheet_mergers_and_acquist96eia861_eia_form_sheet_sales_to_ult_cust_bundled_a96eia860_f_dbf_layout_sheet_proposed_changes_to_existing93eia861_eia_form_sheet_demand_response_b90eia861_advanced_meters_sheet_territories88eia923_eia_schedules_nu_sourcendisposition_final_sheet_file_layout87eia860_layouty_sheet_reference_tables_i84eia923_eiadecember_sheet_page_petcoke_stocks_data82eia860_layout_sheet_proposed_generator76eia860_layouty_sheet_reference_tables_iii74eia860_f_dbf_layout_sheet_proposed_generator69eia860_f_dbf_layout_sheet_plant68eia861_operational_data_sheet_territories65eia861_net_metering_sheet_territories63eia861_average_bill_sheet_commercial62eia861_average_bill_sheet_industrial62eia861_average_bill_sheet_residential62eia860_layout_sheet_utily60eia861_eia_form_sheet_energy_sources_and_disp_b60eia861_eia_form_sheet_sales_to_ult_cust_delivery_c60eia861_eia_form_sheet_sales_to_ult_cust_energy_b60eia861_distribution_systems_sheet_distribution_systems_territorie55eia861_reliability_sheet_reliability_territories55eia861_utility_data_sheet_territories55eia860_layout_sheet_company54eia861_eia_form_sheet_distribution_system_info_a54eia861_eia_form_sheet_dynamic_pricing_programs_c54eia861_eia_form_sheet_electric_revenues_c54eia860_f_dbf_layout_sheet_company52eia861_delivery_companies_sheet_delivery_companies50eia923_eiadecember_sheet_page_stocks_data49eia861_eia_form_sheet_advanced_metering_d48eia861_eia_form_sheet_non_net_metering_distributed_b48eia861_non_net_metering_distributed_sheet_territories44eia923_eia_schedules_m_final_sheet_page_petcoke_stocks_data43eia861_eia_form_sheet_sch_a38eia861_eia_form_sheet_a_cont36eia861_eia_form_sheet_sale_sto_ult_cust_d36eia861_eia_form_sheet_sch32eia861_net_metering_sheet_tpo_total27eia861_eia_form_sheet_non_net_metered_distributed_b20eia861_eia_form_sheet_sch_b20eia861_energy_efficiency_sheet_energy_efficiency_territories20eia861_eia_form_sheet_service_terr_info18eia861_eia_form_sheet_sch_c17eia860_eia_form_sheet_power_plant_data14eia860_f_dbf_layout_sheet_owner14eia860_layout_sheet_owner14eia860_pcgeny_dbf14eia861_eia_form_sheet_sch_d14eia860_eia_form_sheet_sch_a13eia861_dynamic_pricing_sheet_dynamic_pricing_territories13eia861_demand_response_sheet_demand_response_territories11eia860_eia_form_sheet_sch_b10eia860_eia_form_sheet_generator_ownership7eia860_eia_form_sheet_utility7eia861_eia_form_sheet_footnotes6eia861_net_metering_sheet_utility_level_ter6eia861_net_metering_sheet_net_metering_territories5eia861_non_net_metering_distributed_sheet_utility_level_ter4eia861_distributed_generation_sheet_distributed_territories3eia861_distributed_generation_sheet_dispersed_territories1
Fields in eia923_eia_schedules_m_final_revision_sheet_page_fuel_receipts_and_costs
FieldTypeExample
yearstring2020
monthstring1
plant_idstring7
plant_namestringGadsden
plant_statestringAL
purchase_typestringS
contract_expiration_datestring.
energy_sourcestringNG
fuel_groupstringNatural Gas
coalmine_typestringS
coalmine_statestringAL
coalmine_countystring127
coalmine_msha_idstring0103376
coalmine_namestringTOWN CREEK
supplierstringVARIOUS (NATURAL GAS SPOT PURCHASES ONLY)
quantitystring264421
average_heat_contentstring1.025
average_sulfur_contentstring0
average_ash_contentstring0
average_mercury_contentstring0
fuel_coststring217.8
regulatedstringREG
operator_namestringAlabama Power Co
operator_idstring195
reporting_frequencystringM
primary_transportation_modestringPL
secondary_transportation_modestringTR
natural_gas_supply_contract_typestringF
natural_gas_delivery_contract_typestringF
moisture_contentstring.
chlorine_contentstring.
balancing_authority_codestringSOCO
natural_gas_transportation_servicestring
Connect

Claude

Settings, Connectors, Add custom connector. Paste this address:

https://data.nysgpt.com/mcp

Claude Code

claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp

HTTP

curl -s https://data.nysgpt.com/query -H "content-type: application/json" \
  -d '{"sql":"SELECT count(*) FROM govblock_awards.usaspending_contracts"}'

Any MCP client works. The tools are list_databases, list_tables, describe_table and query (Athena SQL, read-only, up to 1,000 rows a query). With a paid key, add ?key=YOUR_KEY to the address or send the header X-Api-Key.

Pricing

Free

$0

30 queries a day, 1 GB scanned per query. No key, no sign-up.

Connect

Day pass

$29

300 queries and 100 GB scanned in 24 hours. One payment.

Buy a day pass

Monthly

$149/month

2,000 queries and 200 GB scanned a day. Cancel any time.

Subscribe

Institution

$1,500/month

20,000 queries and 1 TB scanned a day, for a lab, department or team.

Subscribe

Payment is by card through Stripe. The key appears on screen as soon as payment completes.

More in Electricity Grid and Energy