FPDS Query Library
About Us
Contact Us
← Back to Top Rankings

Geography

States with Largest Contracts

States with Largest Contracts shows which states rank highest by Primary Metric in FPDS-based procurement data.

CO leads this ranking at 92.49B. The top 10 account for 82.09% of the value in this result set, indicating a very high concentration pattern.

Primary Metric Top States State Ranking All Time Federal Market

Updated 03/19/2026

Top Entity
CO
92.49B
Rows Returned
97
Top 10 Share
82.09%
Very High concentration
Ranking Metric
Primary Metric
Top States

Analysis

CO leads this ranking at 92.49B. The top 10 account for 82.09% of the value in this result set, indicating a very high concentration pattern.

Why it matters: Use this page to identify leaders, compare major participants, and understand how activity is distributed across this segment of the federal market.

Methodology: The query groups FPDS records by the ranked entity, calculates the main metric, and orders results from highest to lowest. Supporting columns add context to the leaderboard.

Key Findings

  • CO holds the top position.
  • The top 10 account for 82.09% of the value in this result set.
  • IL appears in the second position.

Limitations

  • Interpretation depends on the SQL scope and selected filters.
  • This page reflects only the returned query result set.

Query Used

-- States with Largest Contracts
SELECT
    content__award__placeOfPerformance__principalPlaceOfPerformance__stateCode AS state_code,
    max(content__award__dollarValues__obligatedAmount) AS largest_contract,
    formatReadableQuantity(max(content__award__dollarValues__obligatedAmount)) AS largest_contract_readable,
    sum(content__award__dollarValues__obligatedAmount) / count() AS avg_award_size,
    formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount) / count()) AS avg_award_size_readable,
    count() AS award_count,
    formatReadableQuantity(count()) AS award_count_readable
FROM fpds.data
WHERE
    contract_type = 1
    AND content__award__placeOfPerformance__principalPlaceOfPerformance__stateCode IS NOT NULL
    AND content__award__placeOfPerformance__principalPlaceOfPerformance__stateCode != ''
GROUP BY content__award__placeOfPerformance__principalPlaceOfPerformance__stateCode
ORDER BY largest_contract DESC
LIMIT 100

Ranking Table

This table ranks results by Primary Metric from highest to lowest.

# State Code Largest Contract Largest Contract Readable Avg Award Size Avg Award Size Readable Award Count Award Count Readable
1 CO 92,490,715,466.13
92.49 billion
 92.49 billion 224598.45 224.60 thousand 1415510 1.42 million
2 IL 86,925,943,160.00
86.93 billion
 86.93 billion 36063.61 36.06 thousand 8467676 8.47 million
3 PA 69,741,330,230.00
69.74 billion
 69.74 billion 59070.14 59.07 thousand 8564661 8.56 million
4 TX 16,597,954,142.00
16.60 billion
 16.60 billion 260082.26 260.08 thousand 5323099 5.32 million
5 WI 10,684,770,445.71
10.68 billion
 10.68 billion 73603.73 73.60 thousand 1896495 1.90 million
6 CT 8,377,436,425.00
8.38 billion
 8.38 billion 324763.04 324.76 thousand 1401966 1.40 million
7 CA 7,855,446,162.18
7.86 billion
 7.86 billion 211289.62 211.29 thousand 7944017 7.94 million
8 NM 5,855,838,300.00
5.86 billion
 5.86 billion 531167.59 531.17 thousand 594691 594.69 thousand
9 NY 5,295,000,000.00
5.29 billion
 5.29 billion 98147.94 98.15 thousand 4950948 4.95 million
10 VA 5,241,285,242.10
5.24 billion
 5.24 billion 182496.5 182.50 thousand 9476514 9.48 million
11 MD 5,059,292,057.27
5.06 billion
 5.06 billion 200613.15 200.61 thousand 4387084 4.39 million
12 WA 3,575,645,414.00
3.58 billion
 3.58 billion 177956.37 177.96 thousand 2116192 2.12 million
13 MO 3,545,501,000.00
3.55 billion
 3.55 billion 161483.26 161.48 thousand 2719994 2.72 million
14 LA 3,454,288,614.00
3.45 billion
 3.45 billion 191229.9 191.23 thousand 873282 873.28 thousand
15 MA 3,300,000,000.00
3.30 billion
 3.30 billion 163944.86 163.94 thousand 3016548 3.02 million
16 UT 3,298,936,415.00
3.30 billion
 3.30 billion 212657.38 212.66 thousand 517024 517.02 thousand
17 AZ 3,276,610,906.36
3.28 billion
 3.28 billion 286690.31 286.69 thousand 1429862 1.43 million
18 KY 3,167,466,582.27
3.17 billion
 3.17 billion 240019 240.02 thousand 914970 914.97 thousand
19 MS 2,522,463,215.00
2.52 billion
 2.52 billion 197196.03 197.20 thousand 906346 906.35 thousand
20 FL 2,423,365,242.00
2.42 billion
 2.42 billion 152490.64 152.49 thousand 3900460 3.90 million
21 DC 2,377,000,000.00
2.38 billion
 2.38 billion 234826.55 234.83 thousand 2644090 2.64 million
22 AL 2,306,836,389.00
2.31 billion
 2.31 billion 202267.46 202.27 thousand 1649370 1.65 million
23 TN 2,274,157,215.66
2.27 billion
 2.27 billion 282694.58 282.69 thousand 971309 971.31 thousand
24 GA 1,899,410,911.00
1.90 billion
 1.90 billion 106435.48 106.44 thousand 2935353 2.94 million
25 ME 1,825,665,914.00
1.83 billion
 1.83 billion 304991.51 304.99 thousand 236724 236.72 thousand
26 SC 1,746,291,822.45
1.75 billion
 1.75 billion 168465.81 168.47 thousand 1198246 1.20 million
27 OH 1,667,654,979.00
1.67 billion
 1.67 billion 107632.93 107.63 thousand 2673788 2.67 million
28 RI 1,588,138,000.00
1.59 billion
 1.59 billion 153790.38 153.79 thousand 278992 278.99 thousand
29 IN 1,289,400,000.00
1.29 billion
 1.29 billion 177948.73 177.95 thousand 943168 943.17 thousand
30 NJ 1,207,999,848.00
1.21 billion
 1.21 billion 45492.42 45.49 thousand 5901016 5.90 million
31 AS 1,184,931,979.00
1.18 billion
 1.18 billion 533885.81 533.89 thousand 11903 11.90 thousand
32 98 1,111,273,242.00
1.11 billion
 1.11 billion 1291681.57 1.29 million 20315 20.32 thousand
33 MI 1,068,052,150.00
1.07 billion
 1.07 billion 62362.83 62.36 thousand 3152999 3.15 million
34 NC 945,107,496.00
945.11 million
 945.11 million 59710.26 59.71 thousand 2888689 2.89 million
35 HI 850,000,000.00
850.00 million
 850.00 million 119465.5 119.47 thousand 728996 729.00 thousand
36 KS 834,683,475.00
834.68 million
 834.68 million 119365.51 119.37 thousand 760802 760.80 thousand
37 MN 745,011,583.71
745.01 million
 745.01 million 102709.84 102.71 thousand 1127753 1.13 million
38 OK 671,827,770.65
671.83 million
 671.83 million 125765.74 125.77 thousand 868796 868.80 thousand
39 IA 635,200,000.00
635.20 million
 635.20 million 164451.05 164.45 thousand 415756 415.76 thousand
40 MH 605,080,000.00
605.08 million
 605.08 million 493609.1 493.61 thousand 22222 22.22 thousand
41 GU 546,082,800.00
546.08 million
 546.08 million 205333.31 205.33 thousand 193898 193.90 thousand
42 NV 532,852,033.34
532.85 million
 532.85 million 224059.82 224.06 thousand 370360 370.36 thousand
43 PR 522,837,996.34
522.84 million
 522.84 million 182527.9 182.53 thousand 173341 173.34 thousand
44 WY 520,000,000.00
520.00 million
 520.00 million 102448.81 102.45 thousand 142513 142.51 thousand
45 ID 479,535,000.00
479.54 million
 479.54 million 210713.54 210.71 thousand 367177 367.18 thousand
46 NH 430,849,659.00
430.85 million
 430.85 million 211048.89 211.05 thousand 252480 252.48 thousand
47 DE 413,200,000.00
413.20 million
 413.20 million 95523.07 95.52 thousand 178326 178.33 thousand
48 AK 399,443,425.00
399.44 million
 399.44 million 182570.94 182.57 thousand 432549 432.55 thousand
49 NE 388,957,123.00
388.96 million
 388.96 million 84283.02 84.28 thousand 417192 417.19 thousand
50 VT 383,499,742.55
383.50 million
 383.50 million 112646.1 112.65 thousand 164043 164.04 thousand
51 WV 319,592,539.00
319.59 million
 319.59 million 98615.81 98.62 thousand 419312 419.31 thousand
52 AR 307,200,000.00
307.20 million
 307.20 million 74563.58 74.56 thousand 574014 574.01 thousand
53 OR 246,257,143.80
246.26 million
 246.26 million 57537.75 57.54 thousand 899584 899.58 thousand
54 FM 242,999,000.00
243.00 million
 243.00 million 297954.08 297.95 thousand 9294 9.29 thousand
55 VI 238,619,000.00
238.62 million
 238.62 million 211820.05 211.82 thousand 17967 17.97 thousand
56 PW 209,812,000.00
209.81 million
 209.81 million 261134.57 261.13 thousand 6933 6.93 thousand
57 SD 183,921,000.00
183.92 million
 183.92 million 86151.19 86.15 thousand 257978 257.98 thousand
58 MP 181,638,225.00
181.64 million
 181.64 million 167777.55 167.78 thousand 19666 19.67 thousand
59 MT 170,135,000.00
170.13 million
 170.13 million 59804.47 59.80 thousand 394777 394.78 thousand
60 ND 160,686,817.00
160.69 million
 160.69 million 92986.39 92.99 thousand 211200 211.20 thousand
61 UM 73,228,500.00
73.23 million
 73.23 million 780734.77 780.73 thousand 2228 2.23 thousand
62 AE 4,435,961.04
4.44 million
 4.44 million 88387.52 88.39 thousand 364 364.00
63 AP 4,088,803.20
4.09 million
 4.09 million 58939.72 58.94 thousand 269 269.00
64 3,928,646.00
3.93 million
 3.93 million 1279706.08 1.28 million 7 7.00
65 oh 2,100,000.00
2.10 million
 2.10 million 101561.25 101.56 thousand 119 119.00
66 US 1,878,871.23
1.88 million
 1.88 million 28546.55 28.55 thousand 160 160.00
67 01 1,752,408.02
1.75 million
 1.75 million 876204.01 876.20 thousand 2 2.00
68 AA 667,941.35
667.94 thousand
 667.94 thousand 178265.33 178.27 thousand 4 4.00
69 51 311,857.35
311.86 thousand
 311.86 thousand 39438.22 39.44 thousand 19 19.00
70 UK 230,713.00
230.71 thousand
 230.71 thousand 66741.25 66.74 thousand 4 4.00
71 mi 223,379.16
223.38 thousand
 223.38 thousand 68719.86 68.72 thousand 6 6.00
72 GM 111,052.00
111.05 thousand
 111.05 thousand 15452.14 15.45 thousand 12 12.00
73 ny 105,000.00
105.00 thousand
 105.00 thousand 30530.26 30.53 thousand 5 5.00
74 ST 98,904.00
98.90 thousand
 98.90 thousand 18017.11 18.02 thousand 20 20.00
75 TS 78,499.12
78.50 thousand
 78.50 thousand 9599.86 9.60 thousand 28 28.00
76 ca 66,625.84
66.63 thousand
 66.63 thousand 66625.84 66.63 thousand 1 1.00
77 NS 66,232.00
66.23 thousand
 66.23 thousand 34101.75 34.10 thousand 2 2.00
78 GB 59,840.00
59.84 thousand
 59.84 thousand 59840 59.84 thousand 1 1.00
79 va 57,720.00
57.72 thousand
 57.72 thousand 12938.58 12.94 thousand 25 25.00
80 pa 57,511.88
57.51 thousand
 57.51 thousand 6839.36 6.84 thousand 33 33.00
81 ON 31,020.00
31.02 thousand
 31.02 thousand 4459.44 4.46 thousand 20 20.00
82 49 25,000.00
25.00 thousand
 25.00 thousand 6911.46 6.91 thousand 55 55.00
83 / 25,000.00
25.00 thousand
 25.00 thousand 12471.47 12.47 thousand 2 2.00
84 TW 17,387.41
17.39 thousand
 17.39 thousand 8678.7 8.68 thousand 2 2.00
85 JA 16,948.00
16.95 thousand
 16.95 thousand 5091.86 5.09 thousand 9 9.00
86 SE 15,288.57
15.29 thousand
 15.29 thousand 9195.52 9.20 thousand 2 2.00
87 OL 15,000.00
15.00 thousand
 15.00 thousand 15000 15.00 thousand 1 1.00
88 GT 15,000.00
15.00 thousand
 15.00 thousand 2832.5 2.83 thousand 4 4.00
89 BL 13,578.00
13.58 thousand
 13.58 thousand 11962.5 11.96 thousand 2 2.00
90 45 11,359.52
11.36 thousand
 11.36 thousand 11359.52 11.36 thousand 1 1.00
91 08 9,955.54
9.96 thousand
 9.96 thousand 9955.54 9.96 thousand 1 1.00
92 QC 6,120.00
6.12 thousand
 6.12 thousand 6120 6.12 thousand 1 1.00
93 56 4,125.00
4.13 thousand
 4.13 thousand 4125 4.13 thousand 1 1.00
94 40 3,000.00
3.00 thousand
 3.00 thousand 3000 3.00 thousand 1 1.00
95 PK 2,236.82
2.24 thousand
 2.24 thousand 2236.82 2.24 thousand 1 1.00
96 0K 440.00
440.00
 440.00 182.66 182.66 6 6.00
97 BC -298.00
-298.00
 -298.00 -298 -298.00 1 1.00

How This Ranking Is Built

Build a ranked FPDS view for "States with Largest Contracts" using aggregated procurement data.

Query structure

  • Results are sorted from highest to lowest by the main ranking metric.
  • Grouping is used to combine FPDS records into comparable entity-level results.

Included fields

  • state_code — Defines the ranked state or geography.
  • largest_contract — Defines the main ranking metric: Primary Metric.
  • avg_award_size — Adds supporting context to the leaderboard.
  • award_count — Adds supporting context to the leaderboard.

How to use this ranking

  • Supports fast market review.
  • Helps compare leaders and close competitors.
  • Adds context beyond a raw transaction list.

Computed Metrics

Top 3 Share
66.18%
Top 5 Share
73.42%
Mean
3,881,390,617.78
Median
388,957,123.00
Max
92,490,715,466.13
Min
-298.00
Concentration
Very High
Fragmentation
Very Low

Top Entities

# Entity Value
1 CO 92.49B
2 IL 86.93B
3 PA 69.74B
4 TX 16.6B
5 WI 10.68B
6 CT 8.38B
7 CA 7.86B
8 NM 5.86B
9 NY 5.3B
10 VA 5.24B

Related Pages

More in Geography

Section

Use FPDS Query for deeper ranking analysis

Go beyond the published leaderboard with custom SQL, broader filters, saved queries, and deeper procurement market analysis across agencies, vendors, industries, PSC categories, and time windows.

Continue from this ranking into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.

Start 7-Day Trial Learn More