Build a Federal Award Lead List Without Losing Source Evidence
Turn public federal award records into a qualified account list while preserving award IDs, source URLs, dates, agencies, and defensible lead criteria.

Public procurement data can reveal companies already delivering a specific capability. It cannot tell you, by itself, whether a company is ready to buy from you. The gap between those two facts is where lead qualification belongs.
Run the USAspending Federal Awards Scraper with two or three closely related market terms. For example, data analytics and software may uncover technology contractors, but a narrower phrase such as geospatial analytics will produce a more interpretable first batch.
Preserve the evidence layer
Save these fields before enrichment:
award_idandgenerated_internal_id;recipient_nameexactly as published;award_amountwithout relabeling it as revenue;- awarding and funding agency fields;
- start and end dates;
- description and
usaspending_url; - collection timestamp and original Actor input.
Never overwrite the raw recipient name with a guessed brand name. Add a normalized company field beside it. This lets an analyst reverse a bad entity match without rerunning the search.
Define a score you can defend
A simple score can combine relevance, recency, and evidence strength. Give more weight to a description that directly matches the target capability. Use end date only as a timing signal; an active award does not prove an open buying cycle. Add a manual review flag when the description is vague or the recipient looks like an individual rather than an operating company.
Rank accounts only after grouping their distinct awards. One very large award and ten small awards describe different relationships even if the totals are similar.
Enrich after qualification
Once the award evidence narrows the market, enrich public company domains, size, and contact channels. Keep enrichment provenance separate from USAspending provenance. If an entity match is uncertain, leave the domain blank rather than attaching the wrong company.
For outreach, reference the market problem, not sensitive assumptions about a contract. Follow applicable marketing law and procurement rules. A transparent, tightly qualified list will be smaller than a bulk export—and substantially more useful.
Frequently asked questions
Should award amount be used as company revenue?
No. Award value is not recognized revenue and may represent ceilings, modifications, or multi-year activity. Keep it labeled as award amount.
What is the safest deduplication key?
Use the generated USAspending identifier for award rows, then resolve companies into a separate account table without deleting the raw evidence.
Related
100 free credits, no credit card.
About 30 real searches. Add the MCP to Claude or Cursor in two minutes.