fac_search_audits
Search entity Single Audit summaries from the Federal Audit Clearinghouse. Filter by UEI, state, audit year, and federal award amounts to identify audit risk.
Instructions
Search entity Single Audit summaries from the Federal Audit Clearinghouse (keyless via the api.data.gov DEMO_KEY; api.fac.gov PostgREST general table) — the SUBCONTRACTOR / teaming AUDIT-RISK vetting entry point (2 CFR 200 Subpart F / Single Audit Act; every entity expending ≥$750K/yr in federal awards). Structured filters (all optional, AND-combined): auditeeUei (12-char SAM UEI — the PRIMARY join key to SAM/USAspending/EDGAR, → auditee_uei), auditeeState (2-letter → auditee_state), auditYear (int → audit_year), totalExpendedMin/totalExpendedMax (USD → total_amount_expended gte/lte). limit (≤100, def 25), offset. Returns { audits:[{ report_id, auditee_uei, audit_year, auditee_name, auditee_ein, auditee_state, auditee_city, total_amount_expended, fac_accepted_date }] } + honest _meta. Feed a row's report_id (or the UEI) to fac_get_findings for the audit-RISK flags. ★PII: a HARDCODED select-allowlist surfaces ONLY entity + audit-summary fields and DELIBERATELY EXCLUDES the auditee's personal-contact columns (email/phone/certifying-official name) — the vetting subject is the ENTITY; there is NO caller select/column param. HONESTY: totalAvailable is the EXACT Content-Range total (a response header under Prefer:count=exact; a '*'/absent/non-numeric denominator ⇒ totalAvailable:null + a page-fullness hedge, NEVER 0); total_amount_expended is null-never-0 (a missing amount is null, never 0); a bad column ⇒ PostgREST 400 ⇒ invalid_input (filtersDropped is ALWAYS empty); a genuine [] ⇒ honest empty; 400/403/5xx/timeout/HTML/non-array THROW (206 = success, never a fake empty). NOT a debarment/exclusion/fitness determination — an audit finding is the auditor's opinion; cross-check SAM exclusions + OFAC. Keyless-first via DEMO_KEY (~10 req/hr shared ceiling; set DATA_GOV_API_KEY for production — never logged).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Rows per page, 1..100, default 25. | |
| offset | No | 0-based row offset for pagination (default 0). | |
| auditYear | No | Filter by audit year (int, → audit_year=eq.). e.g. 2024. | |
| auditeeUei | No | Filter by 12-char SAM UEI (^[A-Z0-9]{12}$; → auditee_uei=eq. — the PRIMARY join key to SAM/USAspending/EDGAR). e.g. 'ZQGGHJH74DW7'. | |
| auditeeState | No | Filter by 2-letter US state code (uppercase; → auditee_state=eq.). e.g. 'CA'. | |
| totalExpendedMax | No | Maximum total federal awards expended (USD, → total_amount_expended=lte.). | |
| totalExpendedMin | No | Minimum total federal awards expended (USD, → total_amount_expended=gte.). |