NYSgptData LibraryConnectPricing

Power plant emissions

Hourly emissions, heat input and generation by unit, 1995 to 2025, with facility attributes.

1BRecords
2Tables
65Fields
CurrentYears

Publisher: Environmental Protection Agency, Clean Air Markets

Try it

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

Tables
Fields in campd_emissions_hourly
FieldTypeExample
statestringDC
facility_namestringBenning Generation Station
facility_idint603
unit_idstring15
associated_stacksstring
datedate2008-01-01
hourint0
operating_timedouble0.0
gross_load_mwdouble
steam_load_1000_lbhrdouble
so2_mass_lbsdouble
so2_mass_measure_indicatorstring
so2_rate_lbsmmbtudouble
so2_rate_measure_indicatorstring
co2_mass_short_tonsdouble
co2_mass_measure_indicatorstring
co2_rate_short_tonsmmbtudouble
co2_rate_measure_indicatorstring
nox_mass_lbsdouble
nox_mass_measure_indicatorstring
nox_rate_lbsmmbtudouble
nox_rate_measure_indicatorstring
heat_input_mmbtudouble
heat_input_measure_indicatorstring
primary_fuel_typestringResidual Oil
secondary_fuel_typestring
unit_typestringTangentially-fired
so2_controlsstring
nox_controlsstringSelective Catalytic Reduction
pm_controlsstring
hg_controlsstring
program_codestringARP, CAIRNOX, CAIROS, NBP
source_filestringemissions-hourly-2008-dc.csv
unit_id_1string
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 Environment