How to get USAspending Federal Contract Awards
New US federal contract awards from USAspending: recipient organization, awarding agency, amount, NAICS, dates, award ID, and link. usaspending.gov is one page of it. A run reads that public list and saves one row per result.
One row per result
A row has Award Id, Recipient Name, Award Amount, Awarding Agency. The columns are listed in the schema on this page.
New rows from that site
Each run reads usaspending.gov again. Put it on a schedule and the next file is the latest rows from that site.
USAspending Federal Contract Awards in Excel, Sheets, or Power BI
The rows are the same in each of those tools. The guide for the one you already use starts with a free Apify account and finishes with the file.
Schema
Examples come from the actor sample, not a live result.
| Name | Description | Example |
|---|---|---|
awardId | Award Id | DEAC0576RL01830 |
recipientName | Recipient Name | BATTELLE |
awardAmount | Award Amount | 30912550571.06 |
awardingAgency | Awarding Agency | Department |
startDate | Start Date | 1978-09-15 |
endDate | End Date | 2027-09-30 |
awardUrl | Award Url | https:/ |
scrapedAt | Scraped At | 2026-09-22T12:00:00+00:00 |
awardIdAward IdDEAC0576RL01830recipientNameRecipient NameBATTELLEMEMORIAL INSTITUTE awardAmountAward Amount30912550571.06awardingAgencyAwarding AgencyDepartmentof Energy startDateStart Date1978-09-15endDateEnd Date2027-09-30awardUrlAward Urlhttps:// www.usaspending.gov/ award/ CONT_AWD_DEAC0576RL01830_8900_-NONE-_-NONE- scrapedAtScraped At2026-09-22T12:00:00+00:00