usaspending_recipients

One row per federal-award recipient, ingested from the USASpending.gov /api/v2/recipient/ endpoint by build_usaspending_recipients. A keyless (no API key) org-resolution reference dimension keyed by UEI and name — the organizations that receive federal money — complementary to the SAM entity registry and the fec_committees table for resolving and enriching the organizations that comment on rulemakings by their federal funding. Scope is deliberately bounded to the top-N recipients by all-time federal award amount (the endpoint reports ~18M recipients, too many for a daily full walk); the transform merges each run's top-N with the prior table so coverage stays monotonic. All columns are stored as VARCHAR.

• Parquet file: usaspending_recipients.parquet
• Queryable via MCP query_sql: Yes

Column	Type	Description
recipient_id	VARCHAR	USASpending recipient hash + level suffix (e.g. 7fe0d08f-...-R). Primary key / dedup key — unique per recipient_level.
uei	VARCHAR	Unique Entity Identifier (SAM.gov UEI, e.g. JE73CDQUAPA7). The org-resolution join key to SAM and other UEI-keyed sources. May be null for older records.
duns	VARCHAR	Legacy DUNS number, when present. Superseded by UEI; often null for newer records.
name	VARCHAR	Recipient name as recorded by USASpending (e.g. LOCKHEED MARTIN CORP). The name-resolution key.
recipient_level	VARCHAR	Recipient rollup level: P (parent), C (child), or R (standalone recipient with no parent). The same UEI can appear at multiple levels.
total_award_amount	VARCHAR	All-time federal award dollars for the recipient at this level, as a numeric string (e.g. 63465270734.15). The bounding sort key (top-N by amount).