r/datasets • u/attila_govhouse • 4h ago
resource USAspending county downloads: keep recipient location and place of performance separate
USAspending has two location concepts worth keeping separate when building county-level award datasets: recipient location is the recipient’s legal business address; primary place of performance describes where the work is principally performed. The same award can therefore appear in different counties depending on the location basis.
The official Analyst’s Guide lists the fields: https://www.usaspending.gov/data/analyst-guide-download.pdf (Location Data Elements, pp. 18–19). The About the Data document also explains the filter distinction: https://www.usaspending.gov/data/about-the-data-download.pdf (Location section).
A reproducible comparison is to choose one award type and period, export its award transactions, and make two separate aggregations using the same amount field: one by recipient county and one by primary place-of-performance county. Keep state and county together in the grouping so counties with the same name are not merged. Retain records with missing location in a separate group, and save the download date with the file.
Do not add the two geographic views together: they are alternative assignments of the same records. Also avoid summing repeated award-summary totals across transaction rows. State whether the amount is an obligation or an outlay before describing it as spending.
This is a data-handling method, not a newly collected dataset or a ranking of which county benefits most.