NYSgptData LibraryConnectPricing

Other grid operators

Sample and reference tables from five further operators.

6.8KRecords
143Tables
1,144Fields
CurrentYears

Publisher: SPP, MISO, IESO, ISO New England and AESO

Try it

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

Tables
spp_west_interchange_real_time1.1Kspp_interchange_real_time1Kmiso_area_control_error843spp_binding_constraints_real_time_5_min482spp_fuel_mix_by_baa_detailed178spp_fuel_mix_detailed178spp_fuel_mix_by_baa176spp_fuel_mix175ieso_load_zonal_5_min158isone_fuel_mix118isone_interchange_15_min117isone_load116miso_binding_constraint_overrides_real_time_5_min116miso_lmp_real_time_5_min102ieso_intertie_flow_5_min76ieso_intertie_limits_real_time_5_min73isone_btm_solar58isone_load_forecast57ieso_real_time_totals55miso_fuel_mix55ieso_lmp_real_time_5_min_intertie54ieso_lmp_real_time_5_min_ontario_zonal54ieso_lmp_real_time_5_min_virtual_zonal53miso_load53spp_as_prices_real_time_5_min53ieso_lmp_real_time_5_min52spp_load51spp_load_by_baa51ieso_lmp_real_time_operating_reserves49isone_lmp_real_time_5_min47ieso_transmission_outages_planned40isone_lmp_day_ahead_hourly30isone_reserve_zone_prices_designations_real_time_5_min_final26miso_load_forecast24aeso_fuel_mix23aeso_interchange23aeso_supply_and_demand23aeso_system_marginal_price23isone_external_flows_5_min22miso_interchange_5_min22aeso_load17aeso_load_forecast17aeso_pool_price17aeso_pool_price_forecast17ieso_load_zonal_hourly17ieso_solar_embedded_forecast17ieso_solar_market_participant_forecast17ieso_wind_embedded_forecast17ieso_wind_market_participant_forecast17ieso_lmp_predispatch_hourly14ieso_lmp_predispatch_hourly_intertie14ieso_lmp_predispatch_hourly_ontario_zonal14ieso_lmp_predispatch_hourly_virtual_zonal14ieso_load14ieso_shadow_prices_day_ahead_hourly14ieso_shadow_prices_real_time_5_min14miso_binding_constraints_day_ahead_hourly14miso_binding_constraints_real_time_5_min14miso_zonal_load_hourly14ieso_forecast_surplus_baseload_generation13miso_multiday_operating_margin13miso_multiday_operating_margin_regional13ieso_outage_transmission_limits12isone_ancillary_services_strike_prices_day_ahead10ieso_fuel_mix9ieso_generator_report_hourly9ieso_intertie_actual_schedule_flow_hourly9spp_load_forecast9spp_load_forecast_by_baa9spp_load_forecast_short_term9spp_market_clearing_real_time9spp_operating_reserves9spp_solar_and_wind_forecast_short_term9spp_ver_curtailments9spp_ver_curtailments_by_baa9spp_lmp_real_time_5_min8spp_solar_and_wind_forecast_by_reserve_zone8ieso_in_service_transmission_limits7ieso_intertie_limits_day_ahead_hourly7ieso_lmp_day_ahead_operating_reserves7isone_wind_forecast_hourly7miso_lmp_day_ahead_hourly7miso_look_ahead_hourly7miso_subregional_power_balance_constraints_day_ahead_hourly7spp_binding_constraints_day_ahead_hourly7spp_lmp_day_ahead_hourly7spp_lmp_day_ahead_hourly_by_bus7spp_load_by_baa_hourly7spp_load_forecast_mid_term7spp_market_clearing_day_ahead7spp_solar_and_wind_forecast_mid_term7ieso_adequacy_report_forecast6ieso_lmp_day_ahead_hourly6ieso_lmp_day_ahead_hourly_intertie6ieso_lmp_day_ahead_hourly_ontario_zonal6ieso_lmp_day_ahead_hourly_virtual_zonal6isone_reserve_requirements_real_time_5_min6isone_reserve_zone_prices_designations_real_time_5_min6isone_solar_forecast_hourly6miso_generation_outages_estimated6miso_generation_outages_forecast6isone_binding_constraints_day_ahead_hourly5isone_interchange_hourly5isone_reserve_requirements_prices_forecast_day_ahead5isone_reserve_zone_prices_designations_real_time_hourly_prelim5isone_capacity_forecast_7_day4isone_surplus_capacity_interface_margins4aeso_daily_average_pool_price3isone_binding_constraints_preliminary_real_time_15_min3isone_binding_constraints_preliminary_real_time_5_min3isone_total_transfer_capability3miso_as_mcp_day_ahead_ex_ante3miso_as_mcp_day_ahead_ex_post3miso_as_mcp_real_time_5_min_ex_ante3miso_as_mcp_real_time_5_min_ex_post_final3miso_as_mcp_real_time_5_min_ex_post_prelim3miso_as_mcp_real_time_hourly_ex_post_final3miso_as_mcp_real_time_hourly_ex_post_prelim3miso_generation_fuel_mix_by_region_day_ahead3miso_generation_fuel_mix_by_region_real_time3miso_interchange_hourly3miso_lmp_day_ahead_hourly_ex_ante3miso_lmp_day_ahead_hourly_ex_post3miso_lmp_real_time_5_min_ex_ante3miso_lmp_real_time_5_min_ex_post_final3miso_lmp_real_time_5_min_ex_post_prelim3miso_lmp_real_time_hourly_ex_post_final3miso_lmp_real_time_hourly_ex_post_prelim3miso_lmp_real_time_hourly_prelim3miso_load_forecast_mid_term_by_region3miso_subregional_power_balance_constraints_real_time_5_min3spp_generation_capacity_on_outage3spp_hourly_load3miso_binding_constraints_real_time_intraday2miso_lmp_real_time_hourly_final2miso_solar_forecast_hourly2miso_wind_forecast_hourly2spp_as_prices_day_ahead2spp_lmp_real_time_by_bus2spp_load_hourly2miso_load_by_region_hourly1miso_load_forecast_mid_term1spp_as_prices1
Fields in spp_west_interchange_real_time
FieldTypeExample
urlstring"https://portal.spp.org/chart-api/interchange-trend-swpw/asF
statusstring200
bytesstring249345
keystring"raw/spp/spp_west_interchange_real_time/2026/08/31/0fbb32829
sha1_12string"0fbb32829a94"
content_typestring"text/csv"
fetched_atstring"2026-08-31T15:48:02Z"
filenamestring/data/j/spp_west_interchange_real_time/x/2026/08/31/_index/1
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