Tables that support the application and fall outside the datasets above.
Publisher:
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| committee_id | string | C00622357 |
| committee_name | string | 'D'MAC KINGDOM' THE GOOD NEWS OF HEALING & UNIFYING OUR GREA |
| filed_cmte_tp_desc | string | PRESIDENTIAL |
| first_receipt_dt | string | 25-JUL-16 |
| filings_url | string | https://www.fec.gov/data/filings/?data_type=processed&q_file |
| case_number | string | |
| cmte_id | string | |
| cmte_name | string | |
| report_type | string | |
| report_year | string | |
| fine_amount | string | |
| office | string | |
| state | string | |
| district | string | |
| cand_name | string | |
| late_filed_not_filed | string | |
| paid_yes_no | string | |
| line_image | string | |
| end_line_image | string | |
| timestamp | string | |
| link_image | string | |
| sponsor_name | string | |
| cash_on_hand | string | |
| coverage_end_date | string | |
| total_disbursement | string | |
| total_receipt | string | |
| date_filed | string | |
| is_lobbyist | string | |
| committee_election_state | string | |
| committee_election_district | string | |
| receipt_date | string | |
| coverage_start_date | string | |
| quarterly_contribution | string | |
| semi_annual_contribution | string | |
| filename | string | /data/j/data_fec_gov/x/UnverifiedCommittees_new.csv |
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.