Electric Quarterly Reports from 2013: contracts and sellers held; 5.4 billion sales transactions queried in the publisher's own storage.
Publisher: Federal Energy Regulatory Commission, through the PUDL project
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| year_quarter | string | 2013q3 |
| seller_company_id_ferc | string | C000388 |
| transaction_unique_id | string | T587885 |
| seller_company_name | string | Pacific Gas and Electric Company |
| customer_company_name | string | California Independent System Operator Corporation |
| ferc_tariff_reference | string | FERC Electric Rate Tariff Volume No. 13, Sheet Nos. 1-3 |
| contract_service_agreement_id | string | 34B001 |
| seller_transaction_id | string | 631760 |
| transaction_begin_date | timestamp | 2013-07-21 15:00:00.000 |
| transaction_end_date | timestamp | 2013-07-21 16:00:00.000 |
| trade_date | date | 2013-07-21 |
| exchange_brokerage_service | string | |
| type_of_rate | string | RTO/ISO |
| timezone | string | PP |
| class_name | string | NF |
| term_name | string | ST |
| increment_name | string | H |
| increment_peaking_name | string | |
| product_name | string | ENERGY |
| rate_units | string | $/MWH |
| point_of_delivery_balancing_authority | string | CISO |
| point_of_delivery_specific_location | string | CAPTJACK_5_N506 |
| transaction_quantity | double | 6.0 |
| price | double | 1.76 |
| standardized_quantity | double | 6.0 |
| standardized_price | double | 1.76 |
| total_transmission_charge | double | 0.0 |
| total_transaction_charge | double | 10.56 |
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.