Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

17.5 MB across 6 parts, newest sealed 12 November 2026 at 21:35 UTC. The first build wrote 6 parts and 198,335 rows.

The check passed.
  • One row per award passed.

award_key

string

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

Valid
198,335 · 100%
Missing
0 · 0%
Distinct
198,335 · 100% of valid

award_id

string

The contract or order number (PIID) as the agency assigned it.

195,546 distinct values, no chart

Valid
198,335 · 100%
Missing
0 · 0%
Distinct
195,546 · 98.6% of valid

fiscal_year

integer

Federal fiscal year in which the award was first obligated. A fiscal year runs from 1 October to 30 September.

  • 202322%
  • 202422%
  • 202221%
Valid
198,335 · 100%
Missing
0 · 0%
Distinct
6 · 0% of valid
Min
2022
25%
2023
Median
2024
75%
2025
Max
2027

fiscal_year_start

date

First day of that fiscal year, and the column the table partitions on.

6 distinct values, no chart

Valid
198,335 · 100%
Missing
0 · 0%
Distinct
6 · 0% of valid

recipient_name

string

Name of the business or organisation that received the award.

  • ATLANTIC DIVING SUPPLY, INC.2%
  • LOCKHEED MARTIN CORPORATION1%
  • STONEX FINANCIAL LTD1%
  • Other (24,813)
Valid
198,335 · 100%
Missing
0 · 0%
Distinct
24,825 · 12.5% of valid

recipient_uei

string

The recipient's Unique Entity Identifier from SAM.gov.

25,632 distinct values, no chart

Valid
198,335 · 100%
Missing
0 · 0%
Distinct
25,632 · 12.9% of valid

recipient_id

string

USAspending's recipient profile identifier.

25,631 distinct values, no chart

Valid
198,106 · 99.9%
Missing
229 · 0.1%
Missing over timeMissing share of recipient_id over time, 0% to 0%.
Distinct
25,631 · 12.9% of valid

awarding_agency

string

Top-tier federal agency that awarded the contract.

  • Department of Defense58%
  • Department of Veterans Affairs7%
  • Department of Homeland Security5%
  • Other (53)
Valid
198,330 · 100%
Missing
5 · 0%
Missing over timeMissing share of awarding_agency over time, 0% to 0%.
Distinct
65 · 0% of valid

awarding_agency_code

string

Three-digit code of the awarding agency.

65 distinct values, no chart

Valid
198,330 · 100%
Missing
5 · 0%
Missing over timeMissing share of awarding_agency_code over time, 0% to 0%.
Distinct
65 · 0% of valid

awarding_sub_agency

string

Bureau, service or component that awarded the contract.

  • Department of the Navy14%
  • Department of the Army13%
  • Defense Logistics Agency13%
  • Other (144)
Valid
198,330 · 100%
Missing
5 · 0%
Missing over timeMissing share of awarding_sub_agency over time, 0% to 0%.
Distinct
156 · 0.1% of valid

funding_agency

string

Top-tier agency that paid for the contract.

  • Department of Defense58%
  • Department of Veterans Affairs8%
  • Department of Homeland Security5%
  • Other (74)
Valid
198,334 · 100%
Missing
1 · 0%
Missing over timeMissing share of funding_agency over time, 0% to 0%.
Distinct
86 · 0% of valid

funding_sub_agency

string

Bureau, service or component that paid for the contract.

  • Department of the Navy16%
  • Department of the Air Force13%
  • Department of the Army13%
  • Other (256)
Valid
198,334 · 100%
Missing
1 · 0%
Missing over timeMissing share of funding_sub_agency over time, 0% to 0%.
Distinct
268 · 0.1% of valid

description

string

The award description as the contracting officer wrote it.

170,746 distinct values, no chart

Valid
198,334 · 100%
Missing
1 · 0%
Missing over timeMissing share of description over time, 0% to 0%.
Distinct
170,746 · 86.1% of valid

start_date

date

First day of the period of performance.

2,133 distinct values, no chart

Valid
198,335 · 100%
Missing
0 · 0%
Distinct
2,133 · 1.1% of valid

end_date

date

Current last day of the period of performance.

3,788 distinct values, no chart

Valid
198,335 · 100%
Missing
0 · 0%
Distinct
3,788 · 1.9% of valid

award_amount

decimal

Total dollars obligated on the award to date, in US dollars.

Histogram: 1000000 to 3074381757.375, 198,301; 3074381757.375 to 6147763514.75, 23; 6147763514.75 to 9221145272.125, 6; 9221145272.125 to 12294527029.5, 3; 12294527029.5 to 15367908786.875, 1; 15367908786.875 to 18441290544.25, 0; 18441290544.25 to 21514672301.625, 0; 21514672301.625 to 24588054059, 1
1000000.0024588054059.00
Valid
198,335 · 100%
Missing
0 · 0%
Distinct
189,767 · 95.7% of valid
Min
1000000.00
25%
1518957.43
Median
2607448.40
75%
5761208.00
Max
24588054059.00

total_outlays

decimal

Total dollars paid out on the award to date, in US dollars, where the agency reports outlays.

60,238 distinct values, no chart

Valid
106,950 · 53.9%
Missing
91,385 · 46.1%
Missing over timeMissing share of total_outlays over time, 39% to 100%.
Distinct
60,238 · 56.3% of valid
Min
-152588628.68
25%
0.00
Median
546414.03
75%
2209758.93
Max
2627035729.15

contract_award_type

string

Kind of contract action: definitive contract, delivery order, purchase order or BPA call.

  • DELIVERY ORDER70%
  • DEFINITIVE CONTRACT19%
  • BPA CALL7%
Valid
198,335 · 100%
Missing
0 · 0%
Distinct
4 · 0% of valid

naics_code

string

Six-digit NAICS industry code the agency assigned.

782 distinct values, no chart

Valid
198,326 · 100%
Missing
9 · 0%
Missing over timeMissing share of naics_code over time, 0% to 0%.
Distinct
782 · 0.4% of valid

naics_description

string

Publisher's name for the NAICS code.

  • COMMERCIAL AND INSTITUTIONAL BUILDING CONSTRUCTION7%
  • ENGINEERING SERVICES7%
  • RESEARCH AND DEVELOPMENT IN THE PHYSICAL, ENGINEERING, AND LIFE SCIENCES (EXCEPT NANOTECHNOLOGY AND BIOTECHNOLOGY)6%
  • Other (753)
Valid
198,326 · 100%
Missing
9 · 0%
Missing over timeMissing share of naics_description over time, 0% to 0%.
Distinct
765 · 0.4% of valid

psc_code

string

Four-character Product and Service Code saying what was bought.

1,588 distinct values, no chart

Valid
198,335 · 100%
Missing
0 · 0%
Distinct
1,588 · 0.8% of valid

psc_description

string

Publisher's name for the Product and Service Code.

  • SUPPORT- PROFESSIONAL: OTHER4%
  • SUPPORT- PROFESSIONAL: ENGINEERING/TECHNICAL3%
  • LIQUID PROPELLANTS AND FUELS, PETROLEUM BASE3%
  • Other (1,574)
Valid
198,334 · 100%
Missing
1 · 0%
Missing over timeMissing share of psc_description over time, 0% to 0%.
Distinct
1,586 · 0.8% of valid

pop_country_code

string

Three-letter country code of the primary place of performance.

193 distinct values, no chart

Valid
198,335 · 100%
Missing
0 · 0%
Distinct
193 · 0.1% of valid

pop_country

string

Country of the primary place of performance.

  • UNITED STATES92%
  • JAPAN1%
  • UNITED KINGDOM1%
  • Other (180)
Valid
198,335 · 100%
Missing
0 · 0%
Distinct
192 · 0.1% of valid

pop_state_code

string

US state or territory code of the primary place of performance.

  • VA15%
  • CA9%
  • MD8%
  • Other (47)
Valid
182,986 · 92.3%
Missing
15,349 · 7.7%
Missing over timeMissing share of pop_state_code over time, 4% to 9%.
Distinct
59 · 0% of valid

pop_state

string

US state or territory of the primary place of performance.

57 distinct values, no chart

Valid
182,962 · 92.2%
Missing
15,373 · 7.8%
Missing over timeMissing share of pop_state over time, 4% to 9%.
Distinct
57 · 0% of valid

pop_city

string

City of the primary place of performance.

5,050 distinct values, no chart

Valid
182,992 · 92.3%
Missing
15,343 · 7.7%
Missing over timeMissing share of pop_city over time, 4% to 9%.
Distinct
5,050 · 2.8% of valid

pop_county

string

County of the primary place of performance.

1,441 distinct values, no chart

Valid
182,995 · 92.3%
Missing
15,340 · 7.7%
Missing over timeMissing share of pop_county over time, 4% to 9%.
Distinct
1,441 · 0.8% of valid

pop_zip5

string

Five-digit ZIP code of the primary place of performance.

9,773 distinct values, no chart

Valid
183,042 · 92.3%
Missing
15,293 · 7.7%
Missing over timeMissing share of pop_zip5 over time, 4% to 9%.
Distinct
9,773 · 5.3% of valid

recipient_country_code

string

Three-letter country code of the recipient's address.

120 distinct values, no chart

Valid
198,335 · 100%
Missing
0 · 0%
Distinct
120 · 0.1% of valid

recipient_state_code

string

US state or territory code of the recipient's address.

  • VA22%
  • CA8%
  • MD7%
  • Other (44)
Valid
189,513 · 95.6%
Missing
8,822 · 4.4%
Missing over timeMissing share of recipient_state_code over time, 4% to 5%.
Distinct
56 · 0% of valid

recipient_city

string

City of the recipient's address.

4,740 distinct values, no chart

Valid
198,333 · 100%
Missing
2 · 0%
Missing over timeMissing share of recipient_city over time, 0% to 0%.
Distinct
4,740 · 2.4% of valid

last_modified

timestamp_utc

When USAspending last recorded a change to the award, in UTC.

172,656 distinct values, no chart

Valid
198,335 · 100%
Missing
0 · 0%
Distinct
172,656 · 87.1% of valid

base_obligation_date

date

Date of the award's first obligation.

Timeline per year: 2021-01-01, 5,937; 2022-01-01, 41,903; 2023-01-01, 44,051; 2024-01-01, 43,196; 2025-01-01, 37,304; 2026-01-01, 25,944
2021-01-012026-01-01

per year

Valid
198,335 · 100%
Missing
0 · 0%
Distinct
1,814 · 0.9% of valid

search_page

integer

The search result page the row was read from.

440 distinct values, no chart

Valid
198,335 · 100%
Missing
0 · 0%
Distinct
440 · 0.2% of valid
Min
1
25%
98
Median
197
75%
296
Max
440

Table profile

Profile of the served version, all rows, computed 16 Nov 2026, 17:50 UTC

WarningFreshnessLatest event 43 d before this version
WarningGaps256 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
WarningAnomaliesSpike on 27 Sept 2021, 41,352 rows against about 0, and 5 more
PassedUnique keysEvery award_key is unique
Rows per week
Rows per week, 262 buckets from 27 Sept 2021 to 28 Sept 2026, at most 43,948 rows, 256 empty, 6 marked as anomalies.60k27 Sept 2021: 41,352 rows, spike, about 0 expected4 Oct 2021: 0 rows11 Oct 2021: 0 rows18 Oct 2021: 0 rows25 Oct 2021: 0 rows1 Nov 2021: 0 rows8 Nov 2021: 0 rows15 Nov 2021: 0 rows22 Nov 2021: 0 rows29 Nov 2021: 0 rows6 Dec 2021: 0 rows13 Dec 2021: 0 rows20 Dec 2021: 0 rows27 Dec 2021: 0 rows3 Jan 2022: 0 rows10 Jan 2022: 0 rows17 Jan 2022: 0 rows24 Jan 2022: 0 rows31 Jan 2022: 0 rows7 Feb 2022: 0 rows14 Feb 2022: 0 rows21 Feb 2022: 0 rows28 Feb 2022: 0 rows7 Mar 2022: 0 rows14 Mar 2022: 0 rows21 Mar 2022: 0 rows28 Mar 2022: 0 rows4 Apr 2022: 0 rows11 Apr 2022: 0 rows18 Apr 2022: 0 rows25 Apr 2022: 0 rows2 May 2022: 0 rows9 May 2022: 0 rows16 May 2022: 0 rows23 May 2022: 0 rows30 May 2022: 0 rows6 Jun 2022: 0 rows13 Jun 2022: 0 rows20 Jun 2022: 0 rows27 Jun 2022: 0 rows4 Jul 2022: 0 rows11 Jul 2022: 0 rows18 Jul 2022: 0 rows25 Jul 2022: 0 rows1 Aug 2022: 0 rows8 Aug 2022: 0 rows15 Aug 2022: 0 rows22 Aug 2022: 0 rows29 Aug 2022: 0 rows5 Sept 2022: 0 rows12 Sept 2022: 0 rows19 Sept 2022: 0 rows26 Sept 2022: 43,948 rows, spike, about 0 expected3 Oct 2022: 0 rows10 Oct 2022: 0 rows17 Oct 2022: 0 rows24 Oct 2022: 0 rows31 Oct 2022: 0 rows7 Nov 2022: 0 rows14 Nov 2022: 0 rows21 Nov 2022: 0 rows28 Nov 2022: 0 rows5 Dec 2022: 0 rows12 Dec 2022: 0 rows19 Dec 2022: 0 rows26 Dec 2022: 0 rows2 Jan 2023: 0 rows9 Jan 2023: 0 rows16 Jan 2023: 0 rows23 Jan 2023: 0 rows30 Jan 2023: 0 rows6 Feb 2023: 0 rows13 Feb 2023: 0 rows20 Feb 2023: 0 rows27 Feb 2023: 0 rows6 Mar 2023: 0 rows13 Mar 2023: 0 rows20 Mar 2023: 0 rows27 Mar 2023: 0 rows3 Apr 2023: 0 rows10 Apr 2023: 0 rows17 Apr 2023: 0 rows24 Apr 2023: 0 rows1 May 2023: 0 rows8 May 2023: 0 rows15 May 2023: 0 rows22 May 2023: 0 rows29 May 2023: 0 rows5 Jun 2023: 0 rows12 Jun 2023: 0 rows19 Jun 2023: 0 rows26 Jun 2023: 0 rows3 Jul 2023: 0 rows10 Jul 2023: 0 rows17 Jul 2023: 0 rows24 Jul 2023: 0 rows31 Jul 2023: 0 rows7 Aug 2023: 0 rows14 Aug 2023: 0 rows21 Aug 2023: 0 rows28 Aug 2023: 0 rows4 Sept 2023: 0 rows11 Sept 2023: 0 rows18 Sept 2023: 0 rows25 Sept 2023: 43,183 rows, spike, about 0 expected2 Oct 2023: 0 rows9 Oct 2023: 0 rows16 Oct 2023: 0 rows23 Oct 2023: 0 rows30 Oct 2023: 0 rows6 Nov 2023: 0 rows13 Nov 2023: 0 rows20 Nov 2023: 0 rows27 Nov 2023: 0 rows4 Dec 2023: 0 rows11 Dec 2023: 0 rows18 Dec 2023: 0 rows25 Dec 2023: 0 rows1 Jan 2024: 0 rows8 Jan 2024: 0 rows15 Jan 2024: 0 rows22 Jan 2024: 0 rows29 Jan 2024: 0 rows5 Feb 2024: 0 rows12 Feb 2024: 0 rows19 Feb 2024: 0 rows26 Feb 2024: 0 rows4 Mar 2024: 0 rows11 Mar 2024: 0 rows18 Mar 2024: 0 rows25 Mar 2024: 0 rows1 Apr 2024: 0 rows8 Apr 2024: 0 rows15 Apr 2024: 0 rows22 Apr 2024: 0 rows29 Apr 2024: 0 rows6 May 2024: 0 rows13 May 2024: 0 rows20 May 2024: 0 rows27 May 2024: 0 rows3 Jun 2024: 0 rows10 Jun 2024: 0 rows17 Jun 2024: 0 rows24 Jun 2024: 0 rows1 Jul 2024: 0 rows8 Jul 2024: 0 rows15 Jul 2024: 0 rows22 Jul 2024: 0 rows29 Jul 2024: 0 rows5 Aug 2024: 0 rows12 Aug 2024: 0 rows19 Aug 2024: 0 rows26 Aug 2024: 0 rows2 Sept 2024: 0 rows9 Sept 2024: 0 rows16 Sept 2024: 0 rows23 Sept 2024: 0 rows30 Sept 2024: 38,561 rows, spike, about 0 expected7 Oct 2024: 0 rows14 Oct 2024: 0 rows21 Oct 2024: 0 rows28 Oct 2024: 0 rows4 Nov 2024: 0 rows11 Nov 2024: 0 rows18 Nov 2024: 0 rows25 Nov 2024: 0 rows2 Dec 2024: 0 rows9 Dec 2024: 0 rows16 Dec 2024: 0 rows23 Dec 2024: 0 rows30 Dec 2024: 0 rows6 Jan 2025: 0 rows13 Jan 2025: 0 rows20 Jan 2025: 0 rows27 Jan 2025: 0 rows3 Feb 2025: 0 rows10 Feb 2025: 0 rows17 Feb 2025: 0 rows24 Feb 2025: 0 rows3 Mar 2025: 0 rows10 Mar 2025: 0 rows17 Mar 2025: 0 rows24 Mar 2025: 0 rows31 Mar 2025: 0 rows7 Apr 2025: 0 rows14 Apr 2025: 0 rows21 Apr 2025: 0 rows28 Apr 2025: 0 rows5 May 2025: 0 rows12 May 2025: 0 rows19 May 2025: 0 rows26 May 2025: 0 rows2 Jun 2025: 0 rows9 Jun 2025: 0 rows16 Jun 2025: 0 rows23 Jun 2025: 0 rows30 Jun 2025: 0 rows7 Jul 2025: 0 rows14 Jul 2025: 0 rows21 Jul 2025: 0 rows28 Jul 2025: 0 rows4 Aug 2025: 0 rows11 Aug 2025: 0 rows18 Aug 2025: 0 rows25 Aug 2025: 0 rows1 Sept 2025: 0 rows8 Sept 2025: 0 rows15 Sept 2025: 0 rows22 Sept 2025: 0 rows29 Sept 2025: 30,446 rows, spike, about 0 expected6 Oct 2025: 0 rows13 Oct 2025: 0 rows20 Oct 2025: 0 rows27 Oct 2025: 0 rows3 Nov 2025: 0 rows10 Nov 2025: 0 rows17 Nov 2025: 0 rows24 Nov 2025: 0 rows1 Dec 2025: 0 rows8 Dec 2025: 0 rows15 Dec 2025: 0 rows22 Dec 2025: 0 rows29 Dec 2025: 0 rows5 Jan 2026: 0 rows12 Jan 2026: 0 rows19 Jan 2026: 0 rows26 Jan 2026: 0 rows2 Feb 2026: 0 rows9 Feb 2026: 0 rows16 Feb 2026: 0 rows23 Feb 2026: 0 rows2 Mar 2026: 0 rows9 Mar 2026: 0 rows16 Mar 2026: 0 rows23 Mar 2026: 0 rows30 Mar 2026: 0 rows6 Apr 2026: 0 rows13 Apr 2026: 0 rows20 Apr 2026: 0 rows27 Apr 2026: 0 rows4 May 2026: 0 rows11 May 2026: 0 rows18 May 2026: 0 rows25 May 2026: 0 rows1 Jun 2026: 0 rows8 Jun 2026: 0 rows15 Jun 2026: 0 rows22 Jun 2026: 0 rows29 Jun 2026: 0 rows6 Jul 2026: 0 rows13 Jul 2026: 0 rows20 Jul 2026: 0 rows27 Jul 2026: 0 rows3 Aug 2026: 0 rows10 Aug 2026: 0 rows17 Aug 2026: 0 rows24 Aug 2026: 0 rows31 Aug 2026: 0 rows7 Sept 2026: 0 rows14 Sept 2026: 0 rows21 Sept 2026: 0 rows28 Sept 2026: 845 rows, spike, about 0 expected2022Jul2023Jul2024Jul2025Jul2026Jul

Support

Talk to Mostly Right

Loading chat…