NYSgptData LibraryConnectPricing

Candidate disbursements

Itemised spending by candidate committees.

43.5MRecords
9Tables
243Fields
CurrentYears

Publisher: Federal Election Commission

Try it

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

Tables
Fields in candidate_disbursement_2012
FieldTypeExample
com_idstringC00933440
com_namstringREFORM TEXAS WITH DANIEL M SIMS
can_idstringS6TX00586
can_namstringSIMS, DANIEL M
ele_yeastring2026
can_offstringS
can_off_stastringTX
can_off_disstring00
lin_numstring17
lin_imastringhttp://docquery.fec.gov/cgi-bin/fecimg/?202603309856874617
rec_com_idstringC00929844
rec_namstringANEDOT
rec_str1string3723 GREENVILLE AVE
rec_str2stringSTE 41002
rec_citstringDALLAS
rec_stastringTX
rec_zipstring75206
dis_datstring2026-02-28
dis_amostring$268.81
dis_pur_desstringANEDOT TRANSACTION FEE
mem_codstringX
mem_texstring*
cat_codstring001
cat_desstringAdministrative/Salary/Overhead Expenses
tra_idstringSB17.4204
bac_ref_idstringSB17.4170
filenamestring/data/j/data_fec_gov/x/candidate_disbursement2026/TX_S6TX005
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 Federal Campaign Finance