Audits of organizations spending federal awards, 2016 to 2026, with findings and awards.
Publisher: Federal Audit Clearinghouse
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| report_id | string | 2026-03-GSAFAC-0000427532 |
| auditee_uei | string | JGPPBT2AGDK1 |
| audit_year | string | 2026 |
| fac_accepted_date | string | 2026-09-18 |
| award_reference | string | AWARD-00025 |
| federal_agency_prefix | string | 81 |
| federal_award_extension | string | 042 |
| additional_award_identification | string | |
| federal_program_name | string | WEATHERIZATION ASSISTANCE FOR LOW-INCOME PERSONS |
| amount_expended | string | -56500 |
| cluster_name | string | N/A |
| other_cluster_name | string | Bulletproff Vest |
| state_cluster_name | string | MA Child and Adult Care Food Program |
| cluster_total | string | 0 |
| federal_program_total | string | 157520 |
| is_major | string | N |
| is_loan | string | N |
| loan_balance | string | 119 |
| is_direct | string | N |
| audit_report_type | string | U |
| findings_count | string | 0 |
| is_passthrough_award | string | N |
| passthrough_amount | string | -5066 |
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.