NYSgptData LibraryConnectPricing

Single audits

Audits of organizations spending federal awards, 2016 to 2026, with findings and awards.

14.1MRecords
10Tables
156Fields
CurrentYears

Publisher: Federal Audit Clearinghouse

Try it

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

Tables
Fields in fac_federal_awards
FieldTypeExample
report_idstring2026-03-GSAFAC-0000427532
auditee_ueistringJGPPBT2AGDK1
audit_yearstring2026
fac_accepted_datestring2026-09-18
award_referencestringAWARD-00025
federal_agency_prefixstring81
federal_award_extensionstring042
additional_award_identificationstring
federal_program_namestringWEATHERIZATION ASSISTANCE FOR LOW-INCOME PERSONS
amount_expendedstring-56500
cluster_namestringN/A
other_cluster_namestringBulletproff Vest
state_cluster_namestringMA Child and Adult Care Food Program
cluster_totalstring0
federal_program_totalstring157520
is_majorstringN
is_loanstringN
loan_balancestring119
is_directstringN
audit_report_typestringU
findings_countstring0
is_passthrough_awardstringN
passthrough_amountstring-5066
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 Executive Branch