Hourly emissions, heat input and generation by unit, 1995 to 2025, with facility attributes.
Publisher: Environmental Protection Agency, Clean Air Markets
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| state | string | DC |
| facility_name | string | Benning Generation Station |
| facility_id | int | 603 |
| unit_id | string | 15 |
| associated_stacks | string | |
| date | date | 2008-01-01 |
| hour | int | 0 |
| operating_time | double | 0.0 |
| gross_load_mw | double | |
| steam_load_1000_lbhr | double | |
| so2_mass_lbs | double | |
| so2_mass_measure_indicator | string | |
| so2_rate_lbsmmbtu | double | |
| so2_rate_measure_indicator | string | |
| co2_mass_short_tons | double | |
| co2_mass_measure_indicator | string | |
| co2_rate_short_tonsmmbtu | double | |
| co2_rate_measure_indicator | string | |
| nox_mass_lbs | double | |
| nox_mass_measure_indicator | string | |
| nox_rate_lbsmmbtu | double | |
| nox_rate_measure_indicator | string | |
| heat_input_mmbtu | double | |
| heat_input_measure_indicator | string | |
| primary_fuel_type | string | Residual Oil |
| secondary_fuel_type | string | |
| unit_type | string | Tangentially-fired |
| so2_controls | string | |
| nox_controls | string | Selective Catalytic Reduction |
| pm_controls | string | |
| hg_controls | string | |
| program_code | string | ARP, CAIRNOX, CAIROS, NBP |
| source_file | string | emissions-hourly-2008-dc.csv |
| unit_id_1 | 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.