award_key
stringUSAspending's unique award identifier, built from the contract number, the awarding office's agency code and the parent contract.
198,335 distinct values, no chart
- Valid
- 198,335 · 100%
- Missing
- 0 · 0%
- Distinct
- 198,335 · 100% of valid
20.7 MB across 6 parts, newest sealed 13 November 2026 at 23:25 UTC. The last refresh changed nothing.
USAspending's unique award identifier, built from the contract number, the awarding office's agency code and the parent contract.
198,335 distinct values, no chart
The contract or order number (PIID) as the agency assigned it.
195,546 distinct values, no chart
Federal fiscal year in which the award was first obligated. A fiscal year runs from 1 October to 30 September.
First day of that fiscal year, and the column the table partitions on.
6 distinct values, no chart
Date of the award's first obligation.
per year
First day of the period of performance.
2,133 distinct values, no chart
Current last day of the period of performance.
3,788 distinct values, no chart
Days from the start to the current end of the period of performance, by rule from the two dates.
Total dollars obligated on the award to date, in US dollars.
Size band of the obligated amount, by rule: 1M to 5M, 5M to 25M, 25M to 100M, 100M to 1B, or over 1B US dollars. Under 1M marks an award whose obligations have since fallen below the one million dollar floor.
Total dollars paid out on the award to date, in US dollars, where the agency reports outlays.
60,238 distinct values, no chart
Kind of contract action: definitive contract, delivery order, purchase order or BPA call.
The award description as the contracting officer wrote it.
170,746 distinct values, no chart
What the government bought, one of thirteen fixed categories. The Product and Service Code decides it where the code is specific. For generic codes a classification model (gemini-decision-1) read the code names and the description and this is its most probable label.
Where the category came from: psc rule or model.
The model's probability for its label, from 0 to 1. Empty where the PSC rule decided.
Whether the award is about artificial intelligence or machine learning. A classification model (gemini-decision-1) answered for research, IT and keyword-matching awards, true when its probability of yes is at least one half. All other awards are false by rule.
The model's probability that the award is about artificial intelligence or machine learning. Empty where the rule decided.
Name of the business or organisation that received the award.
The recipient's Unique Entity Identifier from SAM.gov.
25,632 distinct values, no chart
USAspending's recipient profile identifier.
25,631 distinct values, no chart
P when the recipient is itself a parent company, C when it is a child of a parent, R when no parent is recorded.
Name of the recipient's parent company as USAspending records it. A parent-level recipient is its own parent.
Unique Entity Identifier of the parent company.
24,055 distinct values, no chart
True when the recipient's USAspending business types include small business.
US stock ticker of the parent company, or of the recipient when the parent has none. Found by an exact match of the normalized company name against SEC registrant names of listed securities. Empty when no listed company has the same name.
Which name matched the listed company: parent name or recipient name.
The SEC registrant name the ticker belongs to.
469 distinct values, no chart
The SEC Central Index Key of the matched company.
469 distinct values, no chart
Top-tier federal agency that awarded the contract.
Bureau, service or component that awarded the contract.
Top-tier agency that paid for the contract.
Bureau, service or component that paid for the contract.
Six-digit NAICS industry code the agency assigned.
782 distinct values, no chart
Publisher's name for the NAICS code.
NAICS sector name, by rule from the first two digits of the code.
Four-character Product and Service Code saying what was bought.
1,588 distinct values, no chart
Publisher's name for the Product and Service Code.
Product, service or research and development, by rule from the first character of the Product and Service Code.
Three-letter country code of the primary place of performance.
193 distinct values, no chart
Country of the primary place of performance.
US state or territory code of the primary place of performance.
US state or territory of the primary place of performance.
57 distinct values, no chart
City of the primary place of performance.
5,050 distinct values, no chart
County of the primary place of performance.
1,441 distinct values, no chart
Five-digit ZIP code of the primary place of performance.
9,773 distinct values, no chart
Three-letter country code of the recipient's address.
120 distinct values, no chart
US state or territory code of the recipient's address.
City of the recipient's address.
4,740 distinct values, no chart
When USAspending last recorded a change to the award, in UTC.
172,656 distinct values, no chart
Profile of the served version, all rows, computed 16 Nov 2026, 17:12 UTC
| Warning | Freshness | Latest event 44 d before this version |
|---|---|---|
| Warning | Gaps | 256 empty weeks, 4 Oct 2021 to 19 Sept 2022, 3 Oct 2022 to 18 Sept 2023, 2 Oct 2023 to 23 Sept 2024 and 2 more |
| Warning | Anomalies | Spike on 27 Sept 2021, 41,352 rows against about 0, and 5 more |
| Passed | Unique keys | Every award_key is unique |