NYSgptData LibraryConnectPricing

Open Energy Data Initiative

Solar installations, technology cost baselines and the Puerto Rico grid study.

9.2MRecords
59Tables
873Fields
CurrentYears

Publisher: Department of Energy

Try it

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

Tables
oedi_tracking_the_sun3.4Moedi_atb_atbe2.3Moedi_atb_vehicles_fuels1.5Moedi_pr100_setbacks_buildings1.5Moedi_pr100_setbacks_roads245Koedi_atb_vehicles58.4Koedi_atb_atb_and_lit_redacted28.1Koedi_pr100_wrecks_and_obstructions12.7Koedi_atb_fuels11.4Koedi_atb_inputs_vehicles10.7Koedi_pr100_setbacks_xmission8.7Koedi_atb_emissions7.3Koedi_pr100_tropical_cyclone_wind_exposure6Koedi_pr100_water_bodies4.2Koedi_pr100_submarine_cable_m_buffer2.6Koedi_pr100_pipeline_areas1.5Koedi_pr100_unexploded_ordinance_areas_fuds575oedi_atb_tea462oedi_atb_vmt_ldv300oedi_pr100_nationwide_hapc236oedi_atb_emissions_h_delivery216oedi_pr100_areas_protegidas_agencia198oedi_pr100_land_protected_areas192oedi_pr100_tropical_cyclone_storm_segments176oedi_atb_fuels_marine170oedi_pr100_unexploded_ordinance_areas129oedi_pr100_noaa_charted_submarine_cables_m_buffer100oedi_atb_charger_efficiency88oedi_atb_inputs_fuels_prices_elec80oedi_atb_marine_emissions80oedi_atb_fuel_prices74oedi_atb_aviation_emissions72oedi_atb_aviation66oedi_atb_emissions_h_production56oedi_atb_vehicle_lifetime54oedi_pr100_marine_protected_areas48oedi_atb_maintenance_mdhd44oedi_atb_phev_uf_mdhd44oedi_atb_vmt_mdhd44oedi_atb_inputs_fuels_prices_h32oedi_pr100_setbacks_airport29oedi_pr100_land_nationwide_hapc27oedi_atb_phev_uf_ldv26oedi_atb_blend_ratios18oedi_atb_jet_data18oedi_pr100_ocean_disposal_sites17oedi_atb_emissions_h_onroad16oedi_atb_lhv16oedi_atb_baseline_repair_cost15oedi_pr100_setbacks_runway14oedi_pr100_danger_zones_and_restricted_areas11oedi_atb_distribution_and_taxes8oedi_atb_maintenance_cost7oedi_atb_powertrain_multipliers7oedi_pr100_artificial_reefs7oedi_atb_class_multipliers5oedi_atb_discount_rate4oedi_pr100_coastal_zone_mgmt_act_boundary4oedi_pr100_federal_and_state_waters2
Fields in oedi_tracking_the_sun
FieldTypeExample
data_provider_1stringArkansas State Energy Office
data_provider_2string-1
system_id_1string-1
system_id_2string-1
installation_datestring2010-04-29
pv_system_size_dcstring2.016
total_installed_pricestring14558.0
rebate_or_grantstring0.0
customer_segmentstringRES
expansion_systemstring0
multiple_phase_systemstring0
tts_link_idstring-1
new_constructionstring-1
trackingstring0
ground_mountedstring0
zip_codestring71953
citystringMena
utility_service_territorystringSWEPCO
third_party_ownedstring0
installer_namestringLiberty Solar
self_installedstring0
azimuth_1string-1.0
azimuth_2string-1.0
azimuth_3string-1.0
tilt_1string-1.0
tilt_2string-1.0
tilt_3string-1.0
module_manufacturer_1stringSharp
module_model_1stringND-224UC1
module_quantity_1string-1
module_manufacturer_2stringAlps Technology
module_model_2string-1
module_quantity_2string-1
module_manufacturer_3stringAlps Technology
module_model_3string-1
module_quantity_3string-1
additional_modulesstring-1
technology_module_1stringMulti-c-Si
technology_module_2string-1
technology_module_3string-1
bipv_module_1string-1
bipv_module_2string-1
bipv_module_3string-1
bifacial_module_1string-1
bifacial_module_2string-1
bifacial_module_3string-1
nameplate_capacity_module_1string224
nameplate_capacity_module_2string-1
nameplate_capacity_module_3string-1
efficiency_module_1string0.142430578
efficiency_module_2string-1.0
efficiency_module_3string-1.0
inverter_manufacturer_1stringEnphase Energy Inc.
inverter_model_1stringM190-72-240-Sxx [240V]
inverter_quantity_1string9
inverter_manufacturer_2string-1
inverter_model_2string-1
inverter_quantity_2string-1
inverter_manufacturer_3string-1
inverter_model_3string-1
inverter_quantity_3string-1
additional_invertersstring-1
micro_inverter_1string-1
micro_inverter_2string-1
micro_inverter_3string-1
built_in_meter_inverter_1string-1
built_in_meter_inverter_2string-1
built_in_meter_inverter_3string-1
output_capacity_inverter_1string-1
output_capacity_inverter_2string-1
output_capacity_inverter_3string-1
dc_optimizerstring0
inverter_loading_ratiostring1.28
battery_manufacturerstring-1
battery_modelstring-1
battery_rated_capacity_kwstring-1.0
battery_rated_capacity_kwhstring-1.0
battery_pricestring-1.0
technology_typestringpv-only
extensions_multiphase_idstring-1

1 more fields; select the table above to list them all.

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