NYSgptData LibraryConnectPricing

Energy map layers, utility rates and water use

Utility rate schedules and water use by county, 2015.

353KRecords
25Tables
1,568Fields
CurrentYears

Publisher: OpenEI; U.S. Geological Survey

Try it

Runs against the full table. Enter your key; plans are below.

Tables
Fields in hifld_electric_power_transmission_lines
FieldTypeExample
objectid_1string"87074"
objectidstring"87074"
idstring"172450"
typestring"AC; OVERHEAD"
statusstring"IN SERVICE"
naics_codestring"221121"
naics_descstring"ELECTRIC BULK POWER TRANSMISSION AND CONTROL"
sourcestring"IMAGERY, OpenStreetMap, http://www.oatioasis.com/TVA/TVAdoc
sourcedatestring"1582243200000"
val_methodstring"IMAGERY"
val_datestring"1582243200000"
ownerstring"KINGSPORT POWER CO"
voltagestring"69"
volt_classstring"UNDER 100"
inferredstring"Y"
sub_1string"TAP152879"
sub_2string"UNKNOWN170573"
shape_lengstring"7316.171742337874"
shape__lengthstring"0.06276714479165356"
geometry_typestring"LineString"
geometry_wktstring"LINESTRING (-82.12785 36.5414470000001, -82.12593 36.541203
Connect

Claude

Settings, Connectors, Add custom connector. Paste this address with your key:

https://data.nysgpt.com/mcp?key=YOUR_KEY

Claude Code

claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp --header "X-Api-Key: YOUR_KEY"

HTTP

curl -s https://data.nysgpt.com/query -H "X-Api-Key: YOUR_KEY" -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). Every call needs a key; plans are below.

Pricing

Samples

$0

20,000-row samples of ten datasets, as Parquet files on Hugging Face.

Open samples

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