Fac Findings Search
fac_findings_searchFull-text search over audit finding NARRATIVES — the actual prose auditors wrote describing a compliance exception ("failed to submit the Federal Single Audit report within the timeframe prescribed", "total available cash was less than total advances from grantors"). This is not possible against the live FAC API, which exposes no cross-table join; it is what searching the underlying text directly unlocks. Optionally narrow by state, audit year, CFDA agency prefix, or material-weakness-only. Narrative text is only on file for more recent filings — audits migrated from the pre-2022 Census-run FAC often have none, and rows without text are simply not returned rather than shown blank. Answers "which audits mention X in their findings", e.g. "data security", "cash management", "timesheet".
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Rows to return, 1-100 (default 25). | |
| query | Yes | Search phrase, e.g. "data security" or "questioned costs travel". Uses PostgreSQL websearch syntax (quote a phrase, "-word" to exclude). Aliases: q, text. | |
| state | No | 2-letter auditee state code to narrow the search, e.g. "TX". | |
| offset | No | Rows to skip, for paging. | |
| audit_year | No | Restrict to one audit year. | |
| federal_agency_prefix | No | Restrict to findings on awards under this 2-digit agency prefix (e.g. "93" for HHS). Alias: cfda_prefix. | |
| material_weakness_only | No | Only findings flagged as a material weakness. |