NYSgptData LibraryConnectPricing

FERC financial forms

Annual reports of electric utilities, gas and oil pipelines and service companies, and hourly planning-area demand.

82.2MRecords
1,139Tables
20,908Fields
CurrentYears

Publisher: Federal Energy Regulatory Commission, through the PUDL project

Try it

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

Tables
ferc714_core_hourly_planning_area_demand19.5Mferc714_out_hourly_planning_area_demand19.5Mferc714_out_hourly_estimated_state_demand8.9Mferc714_xbrl_planning_area_hourly_demand_and_forecast_summer_and_winter_peak_demand_and_annual_net_energy_for_load_03_2_instant4.9Mferc714_xbrl_balancing_authority_area_system_lambda_data_and_description_of_economic_dispatch_02_6_instant2.5Mferc1_dbf_f1_cash_flow1.1Mferc1_dbf_f1_substations1.1Mferc1_dbf_f1_footnote_tbl1Mferc1_dbf_f1_retained_erng796Kferc6_dbf_f6_stmnt_cash_flow779Kferc1_dbf_f1_324_elc_expns728Kferc2_dbf_f2_120_stmnt_cash_flow665Kferc1_dbf_f1_xmssn_line561Kferc1_dbf_f1_comp_balance_db557Kferc1_dbf_f1_elc_op_mnt_expn501Kferc1_dbf_f1_bal_sheet_cr492Kferc1_dbf_f1_incm_stmnt_2418Kferc1_dbf_f1_xmssn_elc_fothr410Kferc1_dbf_f1_othr_reg_assets369Kferc6_dbf_f6_comp_bal_sheet341Kferc2_dbf_f2_520_nat_gas302Kferc1_dbf_f1_plant_in_srvce292Kferc2_dbf_f2_114_stmt_income287Kferc1_xbrl_substations_426_duration286Kferc1_xbrl_substations_426_instant286Kferc1_dbf_f1_sales_by_sched271Kferc1_dbf_f1_work266Kferc1_dbf_f1_edcfu_epda247Kferc2_dbf_f2_118_stmnt_ret_earn242Kferc1_dbf_f1_income_stmnt239Kferc2_dbf_f2_521_month_1233Kferc2_dbf_f2_521_month_2232Kferc2_dbf_f2_521_month_3232Kferc1_dbf_f1_325_elc_cust226Kferc1_dbf_f1_slry_wg_dstrbtn219Kferc714_xbrl_balancing_authority_area_system_lambda_data_and_description_of_economic_dispatch_02_6_duration216Kferc714_xbrl_planning_area_hourly_demand_and_forecast_summer_and_winter_peak_demand_and_annual_net_energy_for_load_03_2_duration216Kferc1_dbf_f1_elctrc_oper_rev211Kferc2_dbf_f2_110_comp_bal_debit206Kferc1_dbf_f1_purchased_pwr205Kferc6_dbf_f6_pipeline_tax203Kferc6_dbf_f6_op_exp_accts202Kferc1_dbf_f1_othr_reg_liab200Kferc714_out_respondents_with_fips184Kferc2_dbf_f2_footnotes182Kferc1_xbrl_construction_work_in_progress_electric_216_duration178Kferc2_dbf_f2_112_comp_bal_credit175Kferc2_dbf_f2_footnote_xref174Kferc1_xbrl_transmission_line_statistics_422_duration167Kferc1_dbf_f1_taxacc_ppchrgyr161Kferc1_dbf_f1_schedules_list160Kferc1_dbf_f1_sale_for_resale158Kferc1_dbf_f1_fuel155Kferc6_dbf_f6_stats_oper152Kferc6_dbf_f6_income_stmnt150Kferc2_dbf_f2_317_gas_op_maint149Kferc1_dbf_f1_long_term_debt148Kferc2_dbf_f2_admin140Kferc2_dbf_f2_354_dist_wages134Kferc1_dbf_f1_s0_filing_log129Kferc1_dbf_f1_231_trn_stdycst126Kferc1_xbrl_transmission_service_and_generation_interconnection_study_costs_231_duration124Kferc1_dbf_f1_400_sys_peak122Kferc1_dbf_f1_xmssn_elc_bothr109Kferc1_dbf_f1_utltyplnt_smmry107Kferc6_dbf_f6_undiv_joint_int_prop95.1Kferc2_dbf_f2_311_gas_stor_exp94Kferc1_dbf_f1_accumdepr_prvsn93.7Kferc2_dbf_f2_299_mthqtr_rev_sched92.9Kferc6_dbf_f6_unapprop_ret_inc92.3Kferc1_xbrl_construction_work_in_progress_electric_216_instant92.2Kferc1_dbf_f1_reconrpt_netinc91.4Kferc2_dbf_f2_219_depr_util_plant88.6Kferc6_dbf_f6_acc_depr_system86.9Kferc2_dbf_f2_204_gas_plant_in_srv84Kferc6_dbf_f6_miles_pipe_a82.7Kferc1_dbf_f1_miscgen_expnelc79.1Kferc2_dbf_f2_s0_row_literals75.3Kferc1_dbf_f1_row_lit_tbl74.9Kferc1_dbf_f1_co_directors74Kferc1_dbf_f1_misc_dfrrd_dr73.9Kferc6_dbf_f6_annual_cost_serv73.1Kferc2_dbf_f2_518_trans_peak71.1Kferc2_dbf_f2_200_sum_util_plant70.7Kferc1_dbf_f1_reg_comm_expn69.9Kferc1_dbf_f1_elctrc_erg_acct69.4Kferc1_dbf_f1_397_isorto_stl69Kferc2_dbf_f2_262_taxes_accrued68.4Kferc714_xbrl_generating_plants_included_in_reporting_balancing_authority_area_02_1_duration68.3Kferc2_dbf_f2_312_gas_admin_exp68.2Kferc1_dbf_f1_cmpinc_hedge67.9Kferc6_dbf_f6_carrier_property67.7Kferc1_dbf_f1_officers_co67Kferc1_xbrl_factors_used_in_estimating_depreciation_charges_section_c_336_duration63.9Kferc1_dbf_f1_399_mth_peak62.7Kferc6_dbf_f6_acc_depr_carrier60.5Kferc6_dbf_f6_principal_officers60.2Kferc1_dbf_f1_208_elc_dep58.8Kferc2_dbf_f2_002_list_schedules58.4Kferc1_dbf_f1_r_d_demo_actvty58.2Kferc1_dbf_f1_mthly_peak_otpt58.2Kferc1_dbf_f1_othr_dfrrd_cr58.1Kferc1_dbf_f1_338_dep_depl57.6Kferc6_dbf_f6_list_of_sched57.4Kferc1_dbf_f1_pccidica55.2Kferc6_dbf_f6_s0_admin54.8Kferc1_dbf_f1_respdnt_control54.6Kferc1_dbf_f1_steam51.8Kferc1_dbf_f1_adit_other50.5Kferc1_xbrl_purchased_power_326_duration50.2Kferc1_dbf_f1_429_trans_aff49.4Kferc1_dbf_f1_othr_pd_in_cptl49.4Kferc1_dbf_f1_mtrl_spply48.5Kferc1_xbrl_other_regulatory_assets_account_182_3_232_instant48.5Kferc1_dbf_f1_sbsdry_detail47.5Kferc6_xbrl_miles_of_pipeline_operated_at_end_of_year_602_duration46.1Kferc1_dbf_f1_331_transiso45.6Kferc1_dbf_f1_adit_190_detail43.9Kferc2_dbf_f2_s0_supp43.2Kferc1_xbrl_taxes_accrued_prepaid_and_charged_during_year_262_instant42.6Kferc2_dbf_f2_310_gas_prod_sply_exp41.7Kferc6_dbf_f6_300_op_revenues41.1Kferc1_xbrl_taxes_accrued_prepaid_and_charged_during_year_262_duration40.9Kferc2_dbf_f2_508_comp_stations40.4Kferc1_dbf_f1_dacs_epda39.7Kferc2_dbf_f2_232_othr_reg_assets39.1Kferc2_dbf_f2_357_chrgs_services39.1Kferc2_dbf_f2_261_reconcil_net_inc37.3Kferc6_dbf_f6_s0_row_literals37.2Kferc1_dbf_f1_capital_stock37.2Kferc6_xbrl_pipeline_taxes_other_than_income_taxes_305_duration36.4Kferc1_xbrl_transmission_of_electricity_for_others_328_duration36.3Kferc1_dbf_f1_plant35.4Kferc1_dbf_f1_adit_other_prop34.5Kferc714_xbrl_adjacent_balancing_authority_area_interconnections_02_4_duration33.6Kferc2_dbf_f2_309_gas_rev_and_deks32.6Kferc1_dbf_f1_security_holder31.3Kferc1_xbrl_other_regulatory_liabilities_account_254_278_instant30.3Kferc1_dbf_f1_nonutility_prop30Kferc1_xbrl_other_regulatory_assets_account_182_3_232_duration29.5Kferc1_xbrl_taxes_accrued_prepaid_and_charged_during_year_totals_262_instant28.6Kferc1_xbrl_list_of_schedules_002_duration28Kferc1_dbf_f1_106_200927.1Kferc1_dbf_f1_note_fin_stmnt26.8Kferc1_xbrl_taxes_accrued_prepaid_and_charged_during_year_totals_262_duration26.7Kferc1_dbf_f1_400a_iso_peak26.6Kferc2_dbf_f2_210_plant_in_svc26.5Kferc1_dbf_f1_accumdfrrdtaxcr26.2Kferc2_dbf_f2_304_rev_gas_trans25.7Kferc2_dbf_f2_234_accum_dfrrd_tax25.2Kferc1_dbf_f1_xmssn_adds25.2Kferc2_dbf_f2_339_depr_gas_plant25.2Kferc2_dbf_f2_276_dfrrd_tax_other24.6Kferc60_dbf_f60_xvi_chrg_serv24.5Kferc2_dbf_f2_274_dfrrd_tax_prop24.4Kferc1_xbrl_sales_of_electricity_by_rate_schedules_account_442_commercial_304_duration24.4Kferc1_dbf_f1_allowances22.9Kferc2_dbf_f2_278_other_reg_liab22.7Kferc6_dbf_f6_analysis_inc_tax22.6Kferc714_core_yearly_planning_area_demand_forecast22.4Kferc6_dbf_f6_paid_in_cap21.3Kferc60_dbf_f60_i_comp_bal21Kferc2_dbf_f2_358_trans_affil20.9Kferc6_xbrl_statistics_of_operations_600_duration20.9Kferc6_xbrl_list_of_schedule_002_duration20.5Kferc6_dbf_f6_noncarrier_prop20.5Kferc1_dbf_f1_gnrt_plant20.4Kferc2_xbrl_taxes_accrued_prepaid_and_charged_during_year_distribution_of_taxes_charged_show_utility_dept_where_applicable_and_acct_charged_262_duration20.3Kferc2_dbf_f2_338_depr_depl_amort_b20.1Kferc1_xbrl_sales_for_resale_account_447_310_duration19.8Kferc6_dbf_f6_pipeline_tax_a19.8Kferc1_xbrl_sales_of_electricity_by_rate_schedules_account_440_residential_304_duration19.6Kferc2_dbf_f2a_002_list_schedules19.4Kferc6_dbf_f6_long_term_debt19.4Kferc2_dbf_f2_308_other_gas_rev19.1Kferc1_dbf_f1_email18.9Kferc1_xbrl_other_regulatory_liabilities_account_254_278_duration18.9Kferc2_dbf_f2_117_cmpinc_hedge18.8Kferc2_dbf_f2_512_gas_storage18.7Kferc1_dbf_f1_nuclear_fuel18Kferc2_xbrl_taxes_accrued_prepaid_and_charged_during_year_distribution_of_taxes_charged_show_utility_dept_where_applicable_and_acct_charged_262_instant17.7Kferc2_dbf_f2_514_trans_lines17.7Kferc2_dbf_f2_300_gas_op_rev17.7Kferc1_dbf_f1_adit_amrt_prop17.2Kferc1_dbf_f1_hydro16.9Kferc6_dbf_f6_email16.9Kferc1_dbf_f1_s0_checks16.7Kferc6_dbf_f6_footnote_xref16.7Kferc1_dbf_f1_electric16.5Kferc1_dbf_f1_important_chg16.5Kferc1_xbrl_miscellaneous_deferred_debits_account_186_233_instant16.5Kferc6_xbrl_principal_general_officers_104_duration16.4Kferc1_dbf_f1_ident_attsttn16.2Kferc2_dbf_f2_521_ship_supplied_gas16Kferc1_xbrl_monthly_transmission_system_peak_load_400_duration15.9Kferc1_xbrl_other_deferred_credits_account_253_269_instant15.7Kferc6_dbf_f6_cntrl_over_resp15.6Kferc1_xbrl_information_on_formula_rates_106_duration15.5Kferc2_xbrl_taxes_accrued_prepaid_and_charged_during_year_distribution_of_taxes_charged_total_262_duration15.1Kferc6_dbf_f6_int_div_inc15Kferc2_dbf_f2_335_misc_gen_expense14.9Kferc6_dbf_f6_recv_affiliated14.8Kferc1_xbrl_sales_of_electricity_by_rate_schedules_account_442_industrial_304_duration14.7Kferc6_dbf_f6_op_rev_accts14.5Kferc2_dbf_f2_340_partic_inc_int14.5Kferc2_xbrl_charges_for_outside_professional_and_other_consultative_services_357_duration14.5Kferc1_xbrl_distribution_of_salaries_and_wages_other_accounts_354_duration14.3Kferc6_dbf_f6_directors14.2Kferc1_xbrl_accumulated_deferred_income_taxes_account_190_electric_234_instant14.2Kferc1_xbrl_monthly_peaks_and_output_401b_duration14Kferc1_xbrl_accumulated_deferred_investment_tax_credits_account_255_266_duration14Kferc60_dbf_f60_s0_row_literals14Kferc60_dbf_f60_v_acct_rev_assoc13.7Kferc1_dbf_f1_106a_200913.7Kferc2_dbf_f2_331_gas_utility_op13.6Kferc2_xbrl_monthly_quantity_revenue_data_by_rate_schedule_transportation_299_duration13.4Kferc2_dbf_f2_256_long_term_debt13.4Kferc1_xbrl_accumulated_deferred_income_taxes_other_account_283_electric_276_duration13.4Kferc6_dbf_f6_ident_attsttn13.4Kferc1_xbrl_transactions_with_associated_affiliated_companies_provided_by_429_duration13.1Kferc2_dbf_f2_216_const_work_gas13Kferc1_xbrl_electric_plant_held_for_future_use_214_duration12.8Kferc60_dbf_f60_xv_comp_inc_stmnt12.7Kferc2_dbf_f2_352_emp_benefits12.6Kferc60_dbf_f60_457_bill_assoc_comp12.5Kferc1_xbrl_miscellaneous_general_expenses_335_duration12.5Kferc1_xbrl_accumulated_deferred_income_taxes_other_account_283_electric_276_instant12.4Kferc6_xbrl_statistics_of_operations_operator_600a_duration12.4Kferc2_dbf_f2_253_other_capital12.3Kferc1_xbrl_regulatory_commission_expenses_350_duration12.3Kferc2_xbrl_list_of_schedules_002_duration12.3Kferc6_dbf_f6_s0_supp12.2Kferc1_dbf_f1_cptl_stk_expns12.2Kferc2_dbf_f2_107_security_holder_a12.1Kferc1_xbrl_officers_104_duration12.1Kferc1_xbrl_statement_of_cash_flows_sequence_other_adjustments_to_operating_cash_flows_120_duration12Kferc6_dbf_f6_footnotes12Kferc1_dbf_f1_envrnmntl_expns11.9Kferc1_dbf_f1_398_ancl_ps11.8Kferc1_xbrl_regulatory_commission_expenses_350_instant11.7Kferc60_dbf_f60_s0_supp11.4Kferc2_dbf_f2_email11.3Kferc6_dbf_f6_pay_oth_emp11.3Kferc2_xbrl_revenues_from_transportation_of_gas_of_others_through_transmission_facilities_account_489_2_304_duration11.3Kferc6_dbf_f6_payables_affil11.2Kferc2_dbf_f2_328_exchange_imbalance11.1Kferc2_xbrl_taxes_accrued_prepaid_and_charged_during_year_distribution_of_taxes_charged_total_262_instant11.1Kferc1_dbf_f1_cmpinc_hedge_a11.1Kferc60_dbf_f60_ii_compprop11Kferc1_xbrl_accumulated_deferred_income_taxes_account_190_electric_234_duration11Kferc1_dbf_f1_envrnmntl_fclty10.9Kferc6_dbf_f6_s0_filing_log10.6Kferc1_xbrl_long_term_debt_bonds_221_256_duration10.5Kferc1_xbrl_long_term_debt_bonds_221_256_instant10.4Kferc1_dbf_f1_unrcvrd_cost10.3Kferc1_dbf_f1_construction10.3Kferc1_xbrl_investments_in_subsidiary_companies_224_instant10.1Kferc6_dbf_f6_important_changes10Kferc1_dbf_f1_csscslc_pcsircs9.9Kferc1_xbrl_directors_105_duration9.7Kferc1_dbf_f1_overhead9.6Kferc2_dbf_f2_350_reg_comm_expense9.5Kferc1_dbf_f1_106b_20099.5Kferc6_dbf_f6_op_rev_accts_a9.4Kferc1_dbf_f1_rg_trn_srv_rev9.4Kferc6_dbf_f6_note_fin_stmnt9.3Kferc1_xbrl_other_deferred_credits_account_253_269_duration9.3Kferc2_dbf_f2_233_misc_dfrrd_db9.3Kferc2_dbf_f2_268_misc_curr_liab9.1Kferc2_dbf_f2_269_other_dfrrd_cr9.1Kferc60_xbrl_accounts_receivable_from_associate_companies_005_instant9.1Kferc6_xbrl_income_from_noncarrier_property_335_duration9.1Kferc6_dbf_f6_cmpinc_hedge9Kferc1_xbrl_transactions_with_associated_affiliated_companies_provided_for_429_duration9Kferc2_xbrl_shipper_supplied_gas_for_the_current_quarter_521_m1_duration8.9Kferc2_dbf_f2_122_note_fin_stmnt8.9Kferc1_xbrl_accumulated_deferred_income_taxes_other_property_account_282_non_utility_details_274_instant8.9Kferc6_xbrl_statement_of_cash_flows_other_adjustments_to_operating_cash_charges_120_duration8.8Kferc2_xbrl_compressor_stations_508_duration8.8Kferc6_dbf_f6_misc_ret_inc8.8Kferc2_dbf_f2_336_depr_depl_amort_a8.7Kferc1_xbrl_long_term_debt_other_long_term_debt_224_256_duration8.7Kferc2_xbrl_construction_work_in_progress_gas_details_216_duration8.7Kferc1_xbrl_miscellaneous_deferred_debits_account_186_233_duration8.5Kferc1_xbrl_amounts_included_in_iso_rto_settlement_statements_other_397_duration8.5Kferc1_xbrl_steam_electric_generating_plant_statistics_large_plants_fuel_statistics_402_duration8.5Kferc2_dbf_f2_108_important_changes8.5Kferc2_xbrl_shipper_supplied_gas_for_the_current_quarter_521_m2_duration8.5Kferc2_xbrl_shipper_supplied_gas_for_the_current_quarter_521_m3_duration8.5Kferc2_dbf_f2_224_subsid_invest8.4Kferc6_xbrl_directors_105_duration8.4Kferc2_dbf_f2_513_gas_storage_cont8.3Kferc1_xbrl_long_term_debt_other_long_term_debt_224_256_instant8.3Kferc2_dbf_f2_220_gas_stored8.3Kferc6_dbf_f6_invest_affil8.2Kferc1_xbrl_investments_in_subsidiary_companies_224_duration8.1Kferc6_xbrl_operating_expense_accounts_account_610_302_duration8Kferc1_xbrl_research_development_and_demonstration_activities_352_duration8Kferc1_xbrl_steam_electric_generating_plant_statistics_large_plants_402_duration7.9Kferc1_xbrl_accumulated_deferred_income_taxes_account_190_gas_234_instant7.9Kferc6_dbf_f6_ctrl_by_resp7.9Kferc1_xbrl_accumulated_deferred_income_taxes_other_property_account_282_classified_by_business_activities_274_instant7.7Kferc1_xbrl_transmission_of_electricity_by_others_332_duration7.7Kferc2_dbf_f2_258_unamort_debt7.7Kferc1_xbrl_summary_of_depreciation_and_amortization_charges_section_a_336_duration7.6Kferc1_xbrl_accumulated_deferred_investment_tax_credits_account_255_266_instant7.5Kferc1_xbrl_allowances_accounts_158_1_and_158_2_228a_instant7.5Kferc1_xbrl_allowances_accounts_158_1_and_158_2_section_b_228b_instant7.5Kferc1_xbrl_accumulated_deferred_income_taxes_account_190_other_234_instant7.5Kferc60_dbf_f60_footnotes7.5Kferc2_dbf_f2_332_trans_comp_other7.5Kferc714_xbrl_electric_utilities_that_compose_the_planning_area_03_1_duration7.5Kferc6_dbf_f6_approp_ret_inc7.4Kferc2_xbrl_shipper_supplied_gas_for_the_current_quarter_other_gas_acquired_to_meet_deficiency_521_m1_duration7.2Kferc2_xbrl_shipper_supplied_gas_for_the_current_quarter_other_gas_acquired_to_meet_deficiency_521_m2_duration7.2Kferc2_xbrl_shipper_supplied_gas_for_the_current_quarter_other_gas_acquired_to_meet_deficiency_521_m3_duration7.2Kferc1_xbrl_accumulated_deferred_income_taxes_other_account_283_gas_276_instant7.2Kferc6_dbf_f6_stats_oper_a7.2Kferc2_dbf_f2_218_oh_formula_cmpnts7.1Kferc1_xbrl_information_on_formula_rates_106a_duration7.1Kferc1_dbf_f1_allowances_nox7.1Kferc1_xbrl_reconciliation_of_reported_net_income_with_taxable_income_for_federal_income_taxes_deductions_on_return_not_charged_against_book_income_261_duration7Kferc2_dbf_f2_313_disc_neg_rate_serv7Kferc6_dbf_f6_inc_noncarrier6.9Kferc6_dbf_f6_invest_affiliated6.8Kferc6_dbf_f6_miles_pipeline6.8Kferc1_xbrl_transmission_lines_added_during_year_424_duration6.7Kferc1_xbrl_monthly_iso_rto_transmission_system_peak_load_400a_duration6.7Kferc6_xbrl_operating_revenue_accounts_account_600_interstate_301_duration6.7Kferc6_dbf_f6_s0_col_literals6.7Kferc2_xbrl_transactions_with_associated_affiliated_companies_provided_by_affiliated_company_358_duration6.6Kferc1_xbrl_accumulated_deferred_income_taxes_account_190_234_instant6.6Kferc1_xbrl_electric_plant_held_for_future_use_214_instant6.5Kferc2_dbf_f2_001_ident_attsttn6.4Kferc6_xbrl_noncarrier_property_220_instant6.4Kferc6_xbrl_noncarrier_property_220_duration6.3Kferc6_xbrl_operating_revenue_accounts_account_600_301_duration6.3Kferc6_xbrl_operating_revenues_300_duration6.3Kferc2_dbf_f2_222_investments6.2Kferc1_xbrl_statement_of_income_114_duration6.2Kferc6_dbf_f6_miles_pipe_c6.2Kferc1_dbf_f1_pumped_storage6.2Kferc1_xbrl_steam_electric_generating_plant_statistics_large_plants_402_instant6.1Kferc2_dbf_f2_102_ctrl_over_resp6.1Kferc2_xbrl_shipper_supplied_gas_for_the_current_quarter_other_disposition_of_excess_gas_521_m1_duration6.1Kferc2_xbrl_shipper_supplied_gas_for_the_current_quarter_other_disposition_of_excess_gas_521_m2_duration6.1Kferc2_xbrl_shipper_supplied_gas_for_the_current_quarter_other_disposition_of_excess_gas_521_m3_duration6.1Kferc1_dbf_f1_security6Kferc1_xbrl_accumulated_deferred_income_taxes_other_account_283_classified_by_business_activities_276_instant5.9Kferc714_xbrl_balancing_authority_area_net_energy_for_load_and_peak_demand_sources_by_month_02_3_duration5.8Kferc1_dbf_f1_elc_oper_rev_nb5.8Kferc1_xbrl_statement_of_cash_flows_sequence_other_operating_cash_flows_120_duration5.7Kferc1_xbrl_generating_plant_statistics_410_duration5.7Kferc1_xbrl_generating_plant_statistics_small_plants_410_duration5.7Kferc1_dbf_f1_general_info5.7Kferc714_xbrl_planning_area_hourly_demand_and_forecast_summer_and_winter_peak_demand_and_annual_net_energy_for_load_table_03_2_duration5.7Kferc2_xbrl_construction_work_in_progress_gas_details_216_instant5.6Kferc1_xbrl_accumulated_provision_for_depreciation_of_electric_utility_plant_functional_classification_section_b_219_instant5.6Kferc1_xbrl_accumulated_provision_for_depreciation_of_electric_utility_plant_changes_section_a_219_instant5.6Kferc6_dbf_f6_miles_pipe_b5.6Kferc1_xbrl_sales_of_electricity_by_rate_schedules_account_444_public_street_and_highway_lighting_304_duration5.5Kferc6_xbrl_analysis_of_federal_income_and_other_taxes_deferred_230_duration5.4Kferc1_dbf_f1_control_respdnt5.3Kferc1_xbrl_transmission_of_electricity_by_iso_rtos_331_duration5.3Kferc1_xbrl_reconciliation_of_reported_net_income_with_taxable_income_for_federal_income_taxes_deductions_recorded_on_books_not_deducted_for_return_261_duration5.2Kferc1_xbrl_accumulated_deferred_income_taxes_other_account_283_gas_276_duration5.2Kferc6_xbrl_receivables_from_affiliated_companies_200_instant5.1Kferc1_dbf_f1_xtraordnry_loss5.1Kferc60_xbrl_current_and_accrued_liabilities_accounts_payable_013_instant5.1Kferc6_dbf_f6_miles_pipe_d5Kferc2_dbf_f2_519_aux_peak5Kferc60_dbf_f60_xiii_curr_acc_liab5Kferc1_dbf_f1_leased5Kferc1_xbrl_accumulated_deferred_income_taxes_other_property_account_282_non_utility_details_274_duration5Kferc6_xbrl_payments_for_services_rendered_by_other_than_employees_351_duration5Kferc714_xbrl_balancing_authority_area_monthly_capabilities_at_time_of_monthly_peak_demand_02_2_duration5Kferc6_xbrl_receivables_from_affiliated_companies_200_duration4.9Kferc6_dbf_f6_s0_pins4.9Kferc1_xbrl_information_on_formula_rates_106b_duration4.8Kferc1_xbrl_reconciliation_of_reported_net_income_with_taxable_income_for_federal_income_taxes_show_computation_of_tax_261_duration4.8Kferc1_xbrl_sales_of_electricity_by_rate_schedules_account_445_other_sales_to_public_authorities_304_duration4.8Kferc60_xbrl_accounts_receivable_from_associate_companies_005_duration4.8Kferc1_xbrl_generating_plant_statistics_410_instant4.7Kferc1_xbrl_generating_plant_statistics_small_plants_410_instant4.7Kferc2_dbf_f2_230_prepayments4.7Kferc6_xbrl_payables_to_affiliated_companies_225_instant4.7Kferc1_xbrl_summary_of_utility_plant_and_accumulated_provisions_for_depreciation_amortization_and_depletion_200_instant4.7Kferc6_xbrl_statement_of_cash_flows_construction_and_acquisition_of_plant_120_duration4.6Kferc1_xbrl_accumulated_provision_for_depreciation_of_electric_utility_plant_changes_section_a_219_duration4.6Kferc1_xbrl_statement_of_cash_flows_sequence_other_items_for_investing_cash_flows_120_duration4.5Kferc1_xbrl_accumulated_provision_for_depreciation_of_electric_utility_plant_changes_section_a_sequence_other_items_219_duration4.5Kferc60_xbrl_analysis_of_billing_associate_companies_account_457_017_duration4.4Kferc1_xbrl_corporations_controlled_by_respondent_103_duration4.4Kferc714_out_georeferenced_respondents4.4Kferc714_out_summarized_demand4.4Kferc2_dbf_f2_212_prop_cap_lease_from4.3Kferc6_dbf_f6_other_defer_chrgs4.3Kferc2_dbf_f2_217_nontradrate_newproj4.3Kferc714_xbrl_balancing_authority_area_scheduled_and_actual_interchange_02_5_duration4.3Kferc1_xbrl_statement_of_cash_flows_other_payment_for_retirement_to_financing_acitivities_120_duration4.3K
Fields in ferc714_core_hourly_planning_area_demand
FieldTypeExample
respondent_id_ferc714bigint123
respondent_id_ferc714_csvbigint234
respondent_id_ferc714_xbrlstring
report_datedate2015-01-01
datetime_utctimestamp2015-06-02 20:00:00.000
timezonestringAmerica/New_York
demand_mwhdouble5343.0
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