Generators and plants (Form 860, 2001 to 2025), utilities and sales (Form 861, 2012 to 2025), plant operations and fuel (Form 923, 2001 to 2025).
Publisher: U.S. Energy Information Administration
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| year | string | 2020 |
| month | string | 1 |
| plant_id | string | 7 |
| plant_name | string | Gadsden |
| plant_state | string | AL |
| purchase_type | string | S |
| contract_expiration_date | string | . |
| energy_source | string | NG |
| fuel_group | string | Natural Gas |
| coalmine_type | string | S |
| coalmine_state | string | AL |
| coalmine_county | string | 127 |
| coalmine_msha_id | string | 0103376 |
| coalmine_name | string | TOWN CREEK |
| supplier | string | VARIOUS (NATURAL GAS SPOT PURCHASES ONLY) |
| quantity | string | 264421 |
| average_heat_content | string | 1.025 |
| average_sulfur_content | string | 0 |
| average_ash_content | string | 0 |
| average_mercury_content | string | 0 |
| fuel_cost | string | 217.8 |
| regulated | string | REG |
| operator_name | string | Alabama Power Co |
| operator_id | string | 195 |
| reporting_frequency | string | M |
| primary_transportation_mode | string | PL |
| secondary_transportation_mode | string | TR |
| natural_gas_supply_contract_type | string | F |
| natural_gas_delivery_contract_type | string | F |
| moisture_content | string | . |
| chlorine_content | string | . |
| balancing_authority_code | string | SOCO |
| natural_gas_transportation_service | string |
Settings, Connectors, Add custom connector. Paste this address:
https://data.nysgpt.com/mcp
claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp
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.
$1,500/month
20,000 queries and 1 TB scanned a day, for a lab, department or team.
SubscribePayment is by card through Stripe. The key appears on screen as soon as payment completes.