NYSgptData LibraryConnectPricing

FERC electricity sales reports

Electric Quarterly Reports from 2013: contracts and sellers held; 5.4 billion sales transactions queried in the publisher's own storage.

5.4BRecords
4Tables
80Fields
CurrentYears

Publisher: Federal Energy Regulatory Commission, through the PUDL project

Try it

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

Tables
Fields in ferceqr_transactions
FieldTypeExample
year_quarterstring2013q3
seller_company_id_fercstringC000388
transaction_unique_idstringT587885
seller_company_namestringPacific Gas and Electric Company
customer_company_namestringCalifornia Independent System Operator Corporation
ferc_tariff_referencestringFERC Electric Rate Tariff Volume No. 13, Sheet Nos. 1-3
contract_service_agreement_idstring34B001
seller_transaction_idstring631760
transaction_begin_datetimestamp2013-07-21 15:00:00.000
transaction_end_datetimestamp2013-07-21 16:00:00.000
trade_datedate2013-07-21
exchange_brokerage_servicestring
type_of_ratestringRTO/ISO
timezonestringPP
class_namestringNF
term_namestringST
increment_namestringH
increment_peaking_namestring
product_namestringENERGY
rate_unitsstring$/MWH
point_of_delivery_balancing_authoritystringCISO
point_of_delivery_specific_locationstringCAPTJACK_5_N506
transaction_quantitydouble6.0
pricedouble1.76
standardized_quantitydouble6.0
standardized_pricedouble1.76
total_transmission_chargedouble0.0
total_transaction_chargedouble10.56
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