NYSgptData LibraryConnectPricing

Other tables

Tables that support the application and fall outside the datasets above.

31.8KRecords
1Tables
35Fields
CurrentYears

Publisher:

Try it

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

Tables
Fields in data_fec_gov
FieldTypeExample
committee_idstringC00622357
committee_namestring'D'MAC KINGDOM' THE GOOD NEWS OF HEALING & UNIFYING OUR GREA
filed_cmte_tp_descstringPRESIDENTIAL
first_receipt_dtstring25-JUL-16
filings_urlstringhttps://www.fec.gov/data/filings/?data_type=processed&q_file
case_numberstring
cmte_idstring
cmte_namestring
report_typestring
report_yearstring
fine_amountstring
officestring
statestring
districtstring
cand_namestring
late_filed_not_filedstring
paid_yes_nostring
line_imagestring
end_line_imagestring
timestampstring
link_imagestring
sponsor_namestring
cash_on_handstring
coverage_end_datestring
total_disbursementstring
total_receiptstring
date_filedstring
is_lobbyiststring
committee_election_statestring
committee_election_districtstring
receipt_datestring
coverage_start_datestring
quarterly_contributionstring
semi_annual_contributionstring
filenamestring/data/j/data_fec_gov/x/UnverifiedCommittees_new.csv
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