NYSgptData LibraryConnectPricing

Texas (ERCOT)

Settlement point prices, 60-day disclosure reports, ancillary services, current operating plans and system conditions.

978MRecords
675Tables
13,124Fields
CurrentYears

Publisher: Electric Reliability Council of Texas

Try it

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

Tables
ercot_lmp_by_bus_price_corrections_cdr_pricecorrection_rtm_eblmp_to_np122Mercot_60_day_sced_disclosure_d_sced_resource_as_offers_mar47.6Mercot_lmp_by_bus_cdr_lmpselectbusnp41.6Mercot_60_day_sced_disclosure_d_sced_resource_as_offers_feb41Mercot_as_demand_curves_weekly_ruc_cdr_wrucasdcnp25.8Mercot_60_day_dam_disclosure_d_dam_ptpobligationbidawards_may20.9Mercot_60_day_dam_disclosure_d_dam_ptpobligationbids_may20.9Mercot_60_day_dam_disclosure_d_dam_ptpobligationbidawards_jun20.2Mercot_60_day_dam_disclosure_d_dam_ptpobligationbids_jun20.2Mercot_as_demand_curves_hourly_ruc_cdr_hrucasdcnp20.2Mercot_60_day_dam_disclosure_d_dam_ptpobligationbidawards_aug19.9Mercot_60_day_dam_disclosure_d_dam_ptpobligationbids_aug19.9Mercot_60_day_dam_disclosure_d_dam_ptpobligationbidawards_jul19.5Mercot_60_day_dam_disclosure_d_dam_ptpobligationbids_jul19.5Mercot_indicative_lmp_by_settlement_point_cdr_rtdlmprnlzhubnp19.5Mercot_60_day_dam_disclosure_d_dam_ptpobligationbidawards_apr18.2Mercot_60_day_dam_disclosure_d_dam_ptpobligationbids_apr18.2Mercot_lmp_by_bus_dam_cdr_damhrlmpnp14.8Mercot_60_day_dam_disclosure_d_dam_ptpobligationbidawards_mar13Mercot_60_day_dam_disclosure_d_dam_ptpobligationbids_mar13Mercot_60_day_dam_disclosure_d_dam_ptpobligationbidawards_sep12.8Mercot_60_day_dam_disclosure_d_dam_ptpobligationbids_sep12.8Mercot_60_day_dam_disclosure_d_dam_ptpobligationbidawards_jan12.6Mercot_60_day_dam_disclosure_d_dam_ptpobligationbids_jan12.6Mercot_as_demand_curves_dam_and_sced_cdr_damscedasdcnp12.6Mercot_60_day_dam_disclosure_d_dam_ptpobligationbidawards_oct12.5Mercot_60_day_dam_disclosure_d_dam_ptpobligationbids_oct12.5Mercot_60_day_dam_disclosure_d_dam_ptpobligationbidawards_dec12.4Mercot_60_day_dam_disclosure_d_dam_ptpobligationbids_dec12.4Mercot_60_day_dam_disclosure_d_dam_ptpobligationbidawards_nov12Mercot_60_day_dam_disclosure_d_dam_ptpobligationbids_nov12Mercot_60_day_dam_disclosure_d_dam_ptpobligationbidawards_feb10.7Mercot_60_day_dam_disclosure_d_dam_ptpobligationbids_feb10.7Mercot_60_day_sced_disclosure_d_sced_resource_as_offers_apr7.7Mercot_60_day_sced_disclosure_d_sced_gen_resource_data_feb5.7Mercot_60_day_dam_disclosure_d_dam_energybidawards_aug4Mercot_60_day_dam_disclosure_d_dam_energybids_aug4Mercot_60_day_dam_disclosure_d_dam_energybidawards_jul3.8Mercot_60_day_dam_disclosure_d_dam_energybids_jul3.8Mercot_as_demand_curves_daily_ruc_cdr_drucasdcnp3.7Mercot_60_day_sced_disclosure_d_sced_resource_as_offers_aug3.1Mercot_60_day_dam_disclosure_d_dam_gen_resource_data_jul3.1Mercot_cop_adjustment_period_snapshot_60_day_d_cop_adjustment_period_snapshot_nov3.1Mercot_60_day_sced_disclosure_d_sced_smne_gen_res_mar3.1Mercot_60_day_dam_disclosure_d_dam_gen_resource_data_may3.1Mercot_60_day_dam_disclosure_d_dam_gen_resource_data_aug3Mercot_cop_adjustment_period_snapshot_60_day_d_cop_adjustment_period_snapshot_aug3Mercot_60_day_dam_disclosure_d_dam_gen_resource_data_jun3Mercot_60_day_dam_disclosure_d_dam_gen_resource_data_apr3Mercot_60_day_dam_disclosure_d_dam_energybidawards_jun2.9Mercot_60_day_dam_disclosure_d_dam_energybids_jun2.9Mercot_60_day_dam_disclosure_d_dam_energyonlyofferawards_aug2.9Mercot_60_day_dam_disclosure_d_dam_energyonlyoffers_aug2.9Mercot_60_day_dam_disclosure_d_dam_energyonlyofferawards_jul2.8Mercot_60_day_dam_disclosure_d_dam_energyonlyoffers_jul2.8Mercot_60_day_dam_disclosure_d_dam_energybidawards_may2.7Mercot_60_day_dam_disclosure_d_dam_energybids_may2.7Mercot_lmp_by_settlement_point_price_corrections_cdr_pricecorrection_rtm_splmp_to_np2.5Mercot_60_day_dam_disclosure_d_dam_energybidawards_apr2.4Mercot_60_day_dam_disclosure_d_dam_energybids_apr2.4Mercot_60_day_dam_disclosure_d_dam_energyonlyofferawards_may2.4Mercot_60_day_dam_disclosure_d_dam_energyonlyoffers_may2.4Mercot_60_day_dam_disclosure_d_dam_energyonlyofferawards_jun2.3Mercot_60_day_dam_disclosure_d_dam_energyonlyoffers_jun2.3Mercot_60_day_dam_disclosure_d_dam_gen_resource_data_mar2.3Mercot_60_day_sced_disclosure_d_sced_gen_resource_data_mar2.3Mercot_60_day_dam_disclosure_d_dam_gen_resource_data_jan2.2Mercot_60_day_dam_disclosure_d_dam_gen_resource_data_dec2.2Mercot_60_day_dam_disclosure_d_dam_gen_resource_data_oct2.2Mercot_60_day_dam_disclosure_d_dam_energyonlyofferawards_apr2.1Mercot_60_day_dam_disclosure_d_dam_energyonlyoffers_apr2.1Mercot_60_day_dam_disclosure_d_dam_gen_resource_data_nov2.1Mercot_60_day_dam_disclosure_d_dam_gen_resource_data_sep2.1Mercot_60_day_dam_disclosure_d_dam_energybids_mar2.1Mercot_60_day_dam_disclosure_d_dam_energybidawards_mar2.1Mercot_60_day_dam_disclosure_d_dam_energybidawards_oct2Mercot_60_day_dam_disclosure_d_dam_energybids_oct2Mercot_60_day_dam_disclosure_d_dam_energybidawards_dec1.9Mercot_60_day_dam_disclosure_d_dam_energybids_dec1.9Mercot_60_day_dam_disclosure_d_dam_gen_resource_data_feb1.9Mercot_60_day_dam_disclosure_d_dam_energybidawards_jan1.9Mercot_60_day_dam_disclosure_d_dam_energybids_jan1.9Mercot_60_day_dam_disclosure_d_dam_energybidawards_sep1.8Mercot_60_day_dam_disclosure_d_dam_energybids_sep1.8Mercot_60_day_dam_disclosure_d_dam_energybidawards_nov1.8Mercot_60_day_dam_disclosure_d_dam_energybids_nov1.8Mercot_60_day_sced_disclosure_d_sced_smne_gen_res_jun1.8Mercot_60_day_dam_disclosure_d_dam_energybidawards_feb1.7Mercot_60_day_dam_disclosure_d_dam_energybids_feb1.7Mercot_cop_adjustment_period_snapshot_60_day_d_cop_adjustment_period_snapshot_dec1.7Mercot_cop_adjustment_period_snapshot_60_day_d_cop_adjustment_period_snapshot_jan1.6Mercot_60_day_sced_disclosure_d_sced_resource_as_offers_may1.6Mercot_60_day_sced_disclosure_d_sced_resource_as_offers_sep1.6Mercot_60_day_sced_disclosure_d_sced_resource_as_offers_jul1.5Mercot_60_day_sced_disclosure_d_esr_data_in_sced_feb1.5Mercot_60_day_sced_disclosure_d_sced_resource_as_offers_jun1.5Mercot_60_day_sced_disclosure_d_sced_smne_gen_res_jul1.5Mercot_60_day_sced_disclosure_d_sced_gen_resource_data_jun1.5Mercot_cop_adjustment_period_snapshot_60_day_d_cop_adjustment_period_snapshot_may1.5Mercot_60_day_dam_disclosure_d_dam_energyonlyofferawards_jan1.4Mercot_60_day_dam_disclosure_d_dam_energyonlyoffers_jan1.4Mercot_60_day_dam_disclosure_d_dam_energyonlyofferawards_mar1.4Mercot_60_day_dam_disclosure_d_dam_energyonlyoffers_mar1.4Mercot_cop_adjustment_period_snapshot_60_day_d_cop_adjustment_period_snapshot_apr1.4Mercot_60_day_sced_disclosure_d_load_resource_data_in_sced_mar1.4Mercot_60_day_dam_disclosure_d_dam_load_resource_data_jul1.4Mercot_60_day_dam_disclosure_d_dam_load_resource_data_may1.4Mercot_60_day_sced_disclosure_d_sced_gen_resource_data_aug1.3Mercot_60_day_dam_disclosure_d_dam_load_resource_data_aug1.3Mercot_60_day_sced_disclosure_d_sced_gen_resource_data_jul1.3Mercot_60_day_sced_disclosure_d_sced_smne_gen_res_jan1.3Mercot_60_day_dam_disclosure_d_dam_load_resource_data_jun1.3Mercot_60_day_dam_disclosure_d_dam_load_resource_data_apr1.3Mercot_60_day_dam_disclosure_d_dam_energyonlyofferawards_dec1.3Mercot_60_day_dam_disclosure_d_dam_energyonlyoffers_dec1.3Mercot_60_day_sced_disclosure_d_sced_gen_resource_data_apr1.3Mercot_60_day_dam_disclosure_d_dam_energyonlyofferawards_sep1.3Mercot_60_day_dam_disclosure_d_dam_energyonlyoffers_sep1.3Mercot_60_day_sced_disclosure_d_sced_smne_gen_res_aug1.3Mercot_60_day_dam_disclosure_d_dam_energyonlyofferawards_feb1.3Mercot_60_day_dam_disclosure_d_dam_energyonlyoffers_feb1.3Mercot_highest_price_as_offer_selected_sced_d_sced_highest_price_as_offer_selected_aug1.2Mercot_60_day_sced_disclosure_d_sced_smne_gen_res_apr1.2Mercot_60_day_dam_disclosure_d_dam_energyonlyofferawards_nov1.2Mercot_60_day_dam_disclosure_d_dam_energyonlyoffers_nov1.2Mercot_60_day_dam_disclosure_d_dam_energyonlyofferawards_oct1.1Mercot_60_day_dam_disclosure_d_dam_energyonlyoffers_oct1.1Mercot_60_day_dam_disclosure_d_dam_load_resource_data_jan1.1Mercot_60_day_dam_disclosure_d_dam_load_resource_data_dec1.1Mercot_60_day_dam_disclosure_d_dam_load_resource_data_oct1Mercot_60_day_sced_disclosure_d_sced_smne_gen_res_nov1Mercot_60_day_dam_disclosure_d_dam_load_resource_data_nov1Mercot_60_day_dam_disclosure_d_dam_load_resource_data_sep1Mercot_60_day_dam_disclosure_d_dam_load_resource_data_mar995Kercot_60_day_sced_disclosure_d_sced_gen_resource_data_jan970Kercot_60_day_sced_disclosure_d_sced_smne_gen_res_oct949Kercot_dam_asdc_aggregated_cdr_damasaggnp910Kercot_60_day_sced_disclosure_d_load_resource_data_in_sced_jun865Kercot_60_day_dam_disclosure_d_dam_load_resource_data_feb807Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_option_may806Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_optionawards_may806Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_option_apr788Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_optionawards_apr788Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_option_aug774Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_optionawards_aug774Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_option_jun765Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_optionawards_jun765Kercot_60_day_sced_disclosure_d_sced_gen_resource_data_nov764Kercot_60_day_dam_disclosure_d_dam_generation_resource_asoffers_aug760Kercot_60_day_sced_disclosure_d_sced_gen_resource_data_may759Kercot_60_day_dam_disclosure_d_dam_generation_resource_asoffers_apr758Kercot_60_day_sced_disclosure_d_sced_smne_gen_res_may749Kercot_60_day_sced_disclosure_d_load_resource_data_in_sced_jul742Kercot_60_day_dam_disclosure_d_dam_generation_resource_asoffers_jul730Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_option_jul723Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_optionawards_jul723Kercot_60_day_sced_disclosure_d_load_resource_data_in_sced_aug702Kercot_60_day_sced_disclosure_d_sced_gen_resource_data_oct690Kercot_3_day_highest_price_offered_sced_d_highest_price_offered_sced_aug683Kercot_60_day_sced_disclosure_d_load_resource_data_in_sced_apr681Kercot_60_day_dam_disclosure_d_dam_generation_resource_asoffers_may680Kercot_60_day_dam_disclosure_d_dam_generation_resource_asoffers_jun624Kercot_dam_total_energy_sold_cdr_damtotqtyengysoldnp623Kercot_60_day_sced_disclosure_d_load_resource_data_in_sced_jan585Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_option_mar583Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_optionawards_mar583Kercot_60_day_dam_disclosure_d_dam_generation_resource_asoffers_mar579Kercot_60_day_dam_disclosure_d_dam_generation_resource_asoffers_sep569Kercot_60_day_dam_disclosure_d_dam_generation_resource_asoffers_oct568Kercot_60_day_dam_disclosure_d_dam_generation_resource_asoffers_nov565Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_option_oct564Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_optionawards_oct564Kercot_60_day_dam_disclosure_d_dam_generation_resource_asoffers_dec549Kercot_60_day_dam_disclosure_d_dam_generation_resource_asoffers_jan549Kercot_60_day_sced_disclosure_d_sced_smne_gen_res_feb512Kercot_60_day_dam_disclosure_d_dam_load_resource_asoffers_jul511Kercot_60_day_dam_disclosure_d_dam_load_resource_asoffers_may509Kercot_60_day_dam_disclosure_d_dam_load_resource_asoffers_aug499Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_option_sep495Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_optionawards_sep495Kercot_60_day_dam_disclosure_d_dam_load_resource_asoffers_apr494Kercot_60_day_sced_disclosure_d_sced_dsr_load_data_mar494Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_option_jan481Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_optionawards_jan481Kercot_60_day_dam_disclosure_d_dam_load_resource_asoffers_jun481Kercot_60_day_sced_disclosure_d_sced_smne_gen_res_dec476Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_option_nov472Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_optionawards_nov472Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_option_dec470Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_optionawards_dec470Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_option_feb452Kercot_60_day_dam_disclosure_d_dam_ptp_obligation_optionawards_feb452Kercot_60_day_dam_disclosure_d_dam_generation_resource_asoffers_feb450Kercot_lmp_by_settlement_point_cdr_lmpsrosnodenp449Kercot_60_day_sced_disclosure_d_load_resource_data_in_sced_nov443Kercot_60_day_sced_disclosure_d_sced_gen_resource_data_sep440Kercot_as_reports_sced_day_agg_sced_as_offers_regup_aug427Kercot_60_day_sced_disclosure_d_load_resource_data_in_sced_oct408Kercot_60_day_sced_disclosure_d_load_resource_data_in_sced_may407Kercot_as_reports_sced_day_agg_sced_as_offers_regdn_aug404Kercot_60_day_dam_disclosure_d_dam_load_resource_asoffers_sep394Kercot_60_day_dam_disclosure_d_dam_load_resource_asoffers_oct389Kercot_60_day_dam_disclosure_d_dam_load_resource_asoffers_dec387Kercot_60_day_dam_disclosure_d_dam_load_resource_asoffers_nov364Kercot_60_day_dam_disclosure_d_dam_load_resource_asoffers_jan350Kercot_60_day_sced_disclosure_d_sced_gen_resource_data_dec347Kercot_60_day_dam_disclosure_d_dam_load_resource_asoffers_mar342Kercot_60_day_sced_disclosure_d_sced_smne_gen_res_sep310Kercot_60_day_sced_disclosure_d_load_resource_data_in_sced_feb295Kercot_60_day_dam_disclosure_d_dam_load_resource_asoffers_feb285Kercot_as_reports_sced_day_agg_sced_as_offers_nspin_aug279Kercot_60_day_sced_disclosure_d_sced_dsr_load_data_jun261Kercot_as_reports_sced_day_agg_sced_as_offers_ecrss_aug253Kercot_60_day_dam_disclosure_d_dam_esr_data_jul238Kercot_60_day_dam_disclosure_d_dam_esr_data_may233Kercot_60_day_dam_disclosure_d_dam_esr_data_jun229Kercot_60_day_dam_disclosure_d_dam_esr_data_aug225Kercot_60_day_dam_disclosure_d_dam_esr_asoffers_jul225Kercot_60_day_dam_disclosure_d_dam_esr_data_mar225Kercot_60_day_dam_disclosure_d_dam_esr_data_apr223Kercot_60_day_sced_disclosure_d_sced_dsr_load_data_jul219Kercot_60_day_sced_disclosure_d_load_resource_data_in_sced_sep214Kercot_60_day_dam_disclosure_d_dam_esr_asoffers_aug214Kercot_60_day_dam_disclosure_d_dam_esr_asoffers_jun213Kercot_as_reports_sced_day_agg_sced_as_offers_rrspfr_aug213Kercot_60_day_sced_disclosure_d_sced_dsr_load_data_jan212Kercot_60_day_sced_disclosure_d_load_resource_data_in_sced_dec212Kercot_60_day_dam_disclosure_d_dam_esr_asoffers_may199Kercot_60_day_dam_disclosure_d_dam_esr_asoffers_mar197Kercot_60_day_sced_disclosure_d_esr_data_in_sced_aug193Kercot_60_day_dam_disclosure_d_dam_esr_asoffers_apr190Kercot_60_day_sced_disclosure_d_esr_data_in_sced_apr187Kercot_60_day_dam_disclosure_d_dam_esr_data_feb177Kercot_60_day_sced_disclosure_d_sced_dsr_load_data_nov171Kercot_ccp_resource_names_settlement_points155Kercot_hourly_resource_outage_capacity_reports_cdr_hrlyresoutcapnp151Kercot_60_day_sced_disclosure_d_sced_dsr_load_data_aug151Kercot_60_day_dam_disclosure_d_dam_esr_asoffers_feb150Kercot_60_day_sced_disclosure_d_sced_dsr_load_data_oct150Kercot_60_day_sced_disclosure_d_sced_dsr_load_data_apr139Kercot_hub_name_dc_ties_settlement_points135Kercot_lmp_by_bus_cdr_lmpselectbusnp_retry116Kercot_cop_adjustment_period_snapshot_60_day_d_cop_adjustment_period_snapshot_oct106Kercot_cop_adjustment_period_snapshot_60_day_d_cop_adjustment_period_snapshot_jul103Kercot_60_day_sced_disclosure_d_esr_data_in_sced_sep97.2Kercot_60_day_sced_disclosure_d_esr_data_in_sced_may96.2Kercot_60_day_sced_disclosure_d_esr_data_in_sced_jul94Kercot_60_day_sced_disclosure_d_esr_data_in_sced_jun93.6Kercot_60_day_sced_disclosure_d_sced_dsr_load_data_may93.2Kercot_dam_total_energy_purchased_cdr_damtotqtyengybuynp91.7Kercot_as_reports_sced_day_agg_sced_as_offers_regup_sep79.1Kercot_60_day_sced_disclosure_d_sced_dsr_load_data_dec75.2Kercot_as_reports_sced_day_agg_sced_as_offers_regdn_sep69.9Kercot_60_day_dam_disclosure_d_dam_qse_self_arranged_as_may69.3Kercot_60_day_dam_disclosure_d_dam_qse_self_arranged_as_apr68.6Kercot_60_day_dam_disclosure_d_dam_qse_self_arranged_as_jul68.2Kercot_60_day_sced_disclosure_d_sced_qse_self_arranged_as_mar67.9Kercot_60_day_dam_disclosure_d_dam_qse_self_arranged_as_aug67.5Kercot_60_day_dam_disclosure_d_dam_qse_self_arranged_as_jun65.7Kercot_60_day_sced_disclosure_d_sced_dsr_load_data_feb60.3Kercot_cop_adjustment_period_snapshot_60_day_d_cop_adjustment_period_snapshot_sep51.5Kercot_60_day_dam_disclosure_d_dam_qse_self_arranged_as_oct50.3Kercot_60_day_dam_disclosure_d_dam_qse_self_arranged_as_mar50.3Kercot_as_reports_sced_day_agg_sced_as_offers_nspin_sep49.9Kercot_60_day_dam_disclosure_d_dam_qse_self_arranged_as_dec49.8Kercot_60_day_dam_disclosure_d_dam_qse_self_arranged_as_sep49.7Kercot_60_day_dam_disclosure_d_dam_qse_self_arranged_as_jan48.7Kercot_hourly_wind_report_cdr_wpphrlyavgactnp48.6Kercot_60_day_dam_disclosure_d_dam_qse_self_arranged_as_nov48Kercot_load_forecast_by_model_cdr_lfmodweathernp47.6Kercot_as_reports_sced_day_agg_sced_as_offers_ecrss_sep44.2Kercot_60_day_sced_disclosure_d_sced_qse_self_arranged_as_jun43.2Kercot_highest_price_as_offer_selected_dam_d_dam_highest_price_as_offer_selected_aug40.3Kercot_highest_price_as_offer_selected_sced_d_sced_highest_price_as_offer_selected_jul40.2Kercot_60_day_dam_disclosure_d_dam_qse_self_arranged_as_feb40.1Kercot_as_deployment_factors_hourly_ruc_cdr_hrucasdfnp39.7Kercot_lmp_by_settlement_point_price_corrections_settlement_points38.7Kercot_60_day_sced_disclosure_d_sced_qse_self_arranged_as_apr37.1Kercot_as_reports_sced_day_agg_sced_as_offers_rrspfr_sep37.1Kercot_60_day_sced_disclosure_d_sced_eoc_updates_in_ophour_nov37Kercot_60_day_sced_disclosure_d_sced_qse_self_arranged_as_jul36.3Kercot_as_reports_dam_d_agg_dam_as_offers_regdn_aug35.4Kercot_as_reports_dam_d_agg_dam_as_offers_regup_aug35.2Kercot_highest_price_as_offer_selected_sced_d_sced_highest_price_as_offer_selected_sep35.1Kercot_60_day_dam_disclosure_d_dam_as_only_offers_may34.4Kercot_60_day_sced_disclosure_d_sced_qse_self_arranged_as_aug34.4Kercot_60_day_dam_disclosure_d_dam_as_only_offers_jul34Kercot_60_day_dam_disclosure_d_dam_as_only_offers_jun31Kercot_as_reports_dam_d_agg_dam_as_offers_rrspfr_aug31Kercot_60_day_dam_disclosure_d_dam_as_only_offers_apr30.9Kercot_60_day_dam_disclosure_d_dam_as_only_offers_aug30.7Kercot_as_deployment_factors_weekly_ruc_cdr_wrucasdfnp30.2Kercot_as_plan_cdr_asplannp29.4Kercot_3_day_highest_price_offered_sced_d_highest_price_offered_sced_jul28.2Kercot_as_reports_dam_d_agg_dam_as_offers_nspin_aug24.8Kercot_60_day_sced_disclosure_d_sced_qse_self_arranged_as_jan24.6Kercot_as_reports_dam_d_agg_dam_as_offers_ecrss_aug24.2Kercot_60_day_sced_disclosure_d_sced_dsr_load_data_sep24.2Kercot_3_day_highest_price_bids_selected_sced_d_highest_price_bids_selected_dispatched_in_sced_apr23.9Kercot_3_day_highest_price_bids_selected_sced_d_highest_price_bids_selected_dispatched_in_sced_mar22.9Kercot_3_day_highest_price_bids_selected_sced_d_highest_price_bids_selected_dispatched_in_sced_may22.8Kercot_60_day_sced_disclosure_d_sced_eoc_updates_in_ophour_aug22.8Kercot_indicative_mcpc_rtd_cdr_rtdmcpcnp22.7Kercot_load_forecast_by_forecast_zone_cdr_lfccongestnp22.7Kercot_60_day_dam_disclosure_d_dam_as_only_offers_mar20.6Kercot_60_day_sced_disclosure_d_sced_qse_self_arranged_as_may20.4Kercot_60_day_sced_disclosure_d_sced_qse_self_arranged_as_oct19.9Kercot_lmp_by_settlement_point_settlement_points19.3Kercot_noie_mapping_settlement_points19.3Kercot_resource_node_to_unit_settlement_points19.3Kercot_60_day_sced_disclosure_d_sced_qse_self_arranged_as_nov19.2Kercot_60_day_dam_disclosure_d_dam_as_only_awards_may16.8Kercot_60_day_dam_disclosure_d_dam_as_only_awards_jul16.5Kercot_60_day_dam_disclosure_d_dam_as_only_awards_apr15.8Kercot_60_day_dam_disclosure_d_dam_as_only_awards_jun15.7Kercot_60_day_dam_disclosure_d_dam_as_only_offers_feb15.6Kercot_60_day_dam_disclosure_d_dam_as_only_awards_aug15Kercot_3_day_highest_price_bids_selected_sced_d_highest_price_bids_selected_dispatched_in_sced_jun14.6Kercot_60_day_sced_disclosure_d_sced_as_offer_updates_in_opperiod_aug14.3Kercot_as_reports_sced_day_agg_sced_as_offers_rrsffr_aug13.3Kercot_3_day_highest_price_bids_selected_sced_d_highest_price_bids_selected_dispatched_in_sced_aug13.2Kercot_ccp_resource_names_resource_node_to_unit13Kercot_hourly_solar_report_cdr_pvgrhrlyavgactnp12.5Kercot_60_day_sced_disclosure_d_sced_as_offer_updates_in_opperiod_apr11.7Kercot_as_reports_sced_day_agg_sced_as_offers_rrsufr_aug11.7Kercot_60_day_sced_disclosure_d_sced_eoc_updates_in_ophour_jul11.5Kercot_hub_name_dc_ties_resource_node_to_unit11.4Kercot_3_day_highest_price_bids_selected_sced_d_highest_price_bids_selected_dispatched_in_sced_jul11.1Kercot_60_day_sced_disclosure_d_sced_eoc_updates_in_ophour_dec10.9Kercot_60_day_sced_disclosure_d_sced_qse_self_arranged_as_sep10.5Kercot_60_day_dam_disclosure_d_dam_as_only_awards_mar10.4Kercot_60_day_sced_disclosure_d_sced_qse_self_arranged_as_dec10Kercot_aggregate_gen_summary_2_day_d_agg_gen_summary_aug9.6Kercot_aggregate_gen_summary_2_day_d_agg_gen_summary_houston_aug9.6Kercot_aggregate_gen_summary_2_day_d_agg_gen_summary_north_aug9.6Kercot_aggregate_gen_summary_2_day_d_agg_gen_summary_south_aug9.6Kercot_aggregate_gen_summary_2_day_d_agg_gen_summary_west_aug9.6Kercot_aggregate_gen_summary_2_day_d_agg_load_summary_aug9.6Kercot_aggregate_gen_summary_2_day_d_agg_load_summary_houston_aug9.6Kercot_aggregate_gen_summary_2_day_d_agg_load_summary_north_aug9.6Kercot_aggregate_gen_summary_2_day_d_agg_load_summary_south_aug9.6Kercot_aggregate_gen_summary_2_day_d_agg_load_summary_west_aug9.6Kercot_aggregate_gen_summary_2_day_d_agg_output_sched_aug9.6Kercot_aggregate_gen_summary_2_day_d_agg_output_sched_houston_aug9.6Kercot_aggregate_gen_summary_2_day_d_agg_output_sched_north_aug9.6Kercot_aggregate_gen_summary_2_day_d_agg_output_sched_south_aug9.6Kercot_aggregate_gen_summary_2_day_d_agg_output_sched_west_aug9.6Kercot_aggregate_load_summary_2_day_d_agg_gen_summary_aug9.6Kercot_aggregate_load_summary_2_day_d_agg_gen_summary_houston_aug9.6Kercot_aggregate_load_summary_2_day_d_agg_gen_summary_north_aug9.6Kercot_aggregate_load_summary_2_day_d_agg_gen_summary_south_aug9.6Kercot_aggregate_load_summary_2_day_d_agg_gen_summary_west_aug9.6Kercot_aggregate_load_summary_2_day_d_agg_load_summary_aug9.6Kercot_aggregate_load_summary_2_day_d_agg_load_summary_houston_aug9.6Kercot_aggregate_load_summary_2_day_d_agg_load_summary_north_aug9.6Kercot_aggregate_load_summary_2_day_d_agg_load_summary_south_aug9.6Kercot_aggregate_load_summary_2_day_d_agg_load_summary_west_aug9.6Kercot_aggregate_load_summary_2_day_d_agg_output_sched_aug9.6Kercot_aggregate_load_summary_2_day_d_agg_output_sched_houston_aug9.6Kercot_aggregate_load_summary_2_day_d_agg_output_sched_north_aug9.6Kercot_aggregate_load_summary_2_day_d_agg_output_sched_south_aug9.6Kercot_aggregate_load_summary_2_day_d_agg_output_sched_west_aug9.6Kercot_aggregate_output_schedule_2_day_d_agg_gen_summary_aug9.6Kercot_aggregate_output_schedule_2_day_d_agg_gen_summary_houston_aug9.6Kercot_aggregate_output_schedule_2_day_d_agg_gen_summary_north_aug9.6Kercot_aggregate_output_schedule_2_day_d_agg_gen_summary_south_aug9.6Kercot_aggregate_output_schedule_2_day_d_agg_gen_summary_west_aug9.6Kercot_aggregate_output_schedule_2_day_d_agg_load_summary_aug9.6Kercot_aggregate_output_schedule_2_day_d_agg_load_summary_houston_aug9.6Kercot_aggregate_output_schedule_2_day_d_agg_load_summary_north_aug9.6Kercot_aggregate_output_schedule_2_day_d_agg_load_summary_south_aug9.6Kercot_aggregate_output_schedule_2_day_d_agg_load_summary_west_aug9.6Kercot_aggregate_output_schedule_2_day_d_agg_output_sched_aug9.6Kercot_aggregate_output_schedule_2_day_d_agg_output_sched_houston_aug9.6Kercot_aggregate_output_schedule_2_day_d_agg_output_sched_north_aug9.6Kercot_aggregate_output_schedule_2_day_d_agg_output_sched_south_aug9.6Kercot_aggregate_output_schedule_2_day_d_agg_output_sched_west_aug9.6Kercot_60_day_dam_disclosure_d_dam_as_only_awards_feb9.4Kercot_as_total_capability9.2Kercot_load_forecast_by_weather_zone_cdr_lfcweathernp8.6Kercot_as_reports_sced_day_agg_sced_as_offers_ecrsm_aug8.5Kercot_dam_total_as_sold_cdr_damassoldnp8.2Kercot_60_day_sced_disclosure_d_sced_as_offer_updates_in_opperiod_jun8Kercot_60_day_sced_disclosure_d_sced_as_offer_updates_in_opperiod_jul7.9Kercot_60_day_dam_disclosure_d_dam_esr_data_sep7.9Kercot_60_day_sced_disclosure_d_sced_qse_self_arranged_as_feb_correction7.8Kercot_as_plan7.7Kercot_60_day_dam_disclosure_d_dam_esr_asoffers_sep7.6Kercot_60_day_sced_disclosure_d_sced_as_offer_updates_in_opperiod_sep7.4Kercot_60_day_sced_disclosure_d_sced_as_offer_updates_in_opperiod_may7.3Kercot_60_day_sced_disclosure_d_sced_eoc_updates_in_ophour_oct6.6Kercot_ccp_resource_names_noie_mapping6.5Kercot_as_prices6.5Kercot_60_day_dam_disclosure_disc6.4Kercot_3_day_highest_price_offered_sced6.4Kercot_60_day_sced_disclosure_d_sced_as_offer_updates_in_opperiod_feb6Kercot_as_reports_dam_d_agg_dam_as_offers_regup_sep6Kercot_as_reports_dam_d_agg_dam_as_offers_regdn_sep5.8Kercot_hub_name_dc_ties_noie_mapping5.7Kercot_60_day_sced_disclosure_d_sced_eoc_updates_in_ophour_jun5.7K
Fields in ercot_lmp_by_bus_price_corrections_cdr_pricecorrection_rtm_eblmp_to_np
FieldTypeExample
scedtimestampstring01/24/2026 18:55:19
electricbusnamestringHM_KR
lmporiginalstring184.39
lmpcorrectedstring179.65
pricecorrectiontimestring07/22/2026 16:00:00
dstflagstringN
filenamestring/data/j/ercot_lmp_by_bus_price_corrections/x/2026/08/31/dc77
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