Fac Federal Awards By Program
fac_federal_awards_by_programList the organizations that expended money under a given federal Assistance Listing / CFDA number (e.g. "93.224" community health centers, "84.010" Title I, "20.205" highway planning), ranked by dollars expended, with the recipient name, state, audit year and whether it was a major program. Answers "who spends the money in this federal grant program and how much does each one run".
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cfda | No | Assistance Listing / CFDA number. Accepts "93.224", "93-224", "93 224", "93224", or a bare agency prefix "93" for every program at that agency. Aliases: program_number, assistance_listing, program, cfda_number. | |
| limit | No | Rows to return, 1-200 (default 25). | |
| state | No | 2-letter recipient state code to narrow the ranking, e.g. "TX". | |
| audit_year | No | Restrict to one audit year, e.g. 2023. | |
| major_only | No | Keep only programs audited as major programs. | |
| min_amount | No | Only rows expending at least this many dollars. | |
| include_recipients | No | Resolve each report_id to the recipient name and state (default true; one extra upstream call). | |
| federal_agency_prefix | No | Two-digit agency prefix on its own, e.g. "93" for HHS. Alias: prefix. | |
| federal_award_extension | No | Program extension on its own, e.g. "224". Alias: extension. |