FedFlow — federal award recipient intelligence
← All previews
Sample Preview · fedflow

FedFlow — federal award recipient intelligence

USAspending publishes federal awards in three separate categories — contracts, grants, and loans — and only lets you search them one award at a time. It never gives you a ranked, exportable view of recipients funded across many awarding agencies and across award categories — the contractors who are also grantees. FedFlow does: it resolves the recipient across every award, de-duplicates name variants into one canonical entity, and rolls all three categories up to that recipient with agency breadth, geographic spread, total dollars, a dual-status flag, and a deterministic 0–1 reach/diversification score — the who-is-funded-where-and-how-broadly signal flat, siloed USAspending search can’t show on its own.

Preview-only page. It shows the structure and capability of this dataset using a limited, representative sample. The recipient reach/diversification score, the cross-agency / cross-category reach breadth, and the per-record quality score — the sellable columns — are withheld, and the full dataset is not downloadable here. It is provided separately after licensing.

Coverage & headline figures

Built from one free, public USAspending endpoint queried across three award categories and cross-linked into one recipient-resolved, scored, exportable product. Deterministic and rule-based — no LLM in the pipeline.

2,065
Federal awards
FY2023, 3 categories
844
Distinct resolved recipients
the cross-agency hub
3
Award categories unified
contracts · grants · loans
577
Cross-linked awards
recipient spans 2+ agencies/categories
6
Dual-status recipients
contractor + grantee
$4.06T
Total obligated
across all sampled awards

Category mix: Contracts 700 · Loans 700 · Grants 665. Top obligating agencies: Defense $1.76T · Energy $708B · Health & Human Services $691B · Education $363B · NASA $132B. Average record quality score 0.887 (0–1 completeness); recognizable reach leaders include Leidos (8 agencies), Lockheed Martin ($527B, 13 states, 125 awards), Boeing, and Battelle (dual-status).

Source (free, keyless, public-domain)

  • USAspending — contracts (spending_by_award, codes A/B/C/D) → federal contract awards by recipient, agency, amount, and place of performance.
  • USAspending — grants (spending_by_award, codes 02–05) → federal grant and assistance awards by recipient.
  • USAspending — loans (spending_by_award, codes 07/08) → federal loan awards (category-aware Loan Value field).

What’s in it — schema

Two cross-linked tables. recipients is the headline deliverable — the resolved, cross-agency entity; awards is the row-level award detail that rolls up into it.

Tables in the dataset
Table Grain (one row =) Notable columns Rows
recipients one resolved award recipient award_count, total_amount, agency_count, category_count, reach_score 844
awards one federal award record category, amount, is_cross_linked, quality_score 2,065

Columns in awards (row-level detail)

internal_id USAspending award id (unique)
category Contract / Grant / Loan
recipient_name Recipient name as reported by USAspending
normalized_recipient Canonical recipient key (cross-link key)
amount Award amount / loan value (unified)
awarding_agency Top-tier awarding agency
state Recipient / place-of-performance state
fiscal_year Derived fiscal year of the award
award_type Award type code group
is_cross_linked 1 if recipient spans 2+ agencies/categories — gated
quality_score 0–1 completeness score — gated

Columns in recipients (the headline table)

display_name Resolved, de-duplicated recipient name
normalized_name Canonical cross-link key (unique)
award_count Total awards for this recipient
total_amount Summed obligations across awards
states / state_count Distinct states of performance
agencies / agency_count Cross-agency reach breadth (the linkage) — gated
categories / is_dual_status Cross-category breadth & contractor+grantee flag — gated
reach_score 0–1 deterministic reach/diversification blend — gated

Sample preview gated

A representative slice of resolved recipients — the kind of broad-reach, multi-agency entities that recipient resolution surfaces. Award counts, state spread, and total obligations are shown; the cross-agency / cross-category reach and the reach score — the proprietary, sellable columns — are redacted. Eight of 844 recipients; ordering does not reflect the reach score.

recipients — 8 sample rows (reach breadth & reach score withheld)
Recipient States Awards Total obligated Cross-agency / category reach Reach score
Lockheed Martin Corp 13 125 $526.9B •••• 0.•••
The Boeing Company 8 59 $261.0B •••• 0.•••
Northrop Grumman Systems Corp 9 29 $84.9B •••• 0.•••
Raytheon Company 6 41 $75.0B •••• 0.•••
Battelle Memorial Institute 2 2 $30.9B •••• 0.•••
Leidos, Inc. 4 9 $11.2B •••• 0.•••
Science Applications International Corporation 4 5 $6.7B •••• 0.•••
Association of Universities for Research in Astronomy, Inc. 2 3 $4.6B •••• 0.•••

Request the full live sample

Get a live, end-to-end sample of FedFlow — the resolved recipients table with cross-agency / cross-category reach and diversification scores, plus the full award-level detail, dual-status flags, quality scores, and methodology.

Request the full live sample →

No full dataset is downloadable from this page. Public-domain U.S. Government data (USAspending); not affiliated with USAspending or the U.S. Treasury.