VA leads this ranking at 9.48M. The top 10 account for 58.69% of the value in this result set, indicating a moderate concentration pattern.
Geography
Top States by Award Count
Top States by Award Count shows which states rank highest by Award Count in FPDS-based procurement data.
Analysis
VA leads this ranking at 9.48M. The top 10 account for 58.69% of the value in this result set, indicating a moderate 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
- VA holds the top position.
- The top 10 account for 58.69% of the value in this result set.
- PA 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
-- Top States by Award Count
SELECT
content__award__placeOfPerformance__principalPlaceOfPerformance__stateCode AS state_code,
count() AS award_count,
formatReadableQuantity(count()) AS award_count_readable,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable,
sum(content__award__dollarValues__obligatedAmount) / count() AS avg_award_size,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount) / count()) AS avg_award_size_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 award_count DESC
LIMIT 100
Ranking Table
This table ranks results by Award Count from highest to lowest.
| # | State Code | Award Count | Award Count Readable | Total Obligated | Total Obligated Readable | Avg Award Size | Avg Award Size Readable |
|---|---|---|---|---|---|---|---|
| 1 | VA |
9,476,514.00
9.48 million
|
9.48 million | 1729430707524.1 | 1.73 trillion | 182496.5 | 182.50 thousand |
| 2 | PA |
8,564,661.00
8.56 million
|
8.56 million | 505915778865.28 | 505.92 billion | 59070.14 | 59.07 thousand |
| 3 | IL |
8,467,676.00
8.47 million
|
8.47 million | 305375037154.66 | 305.38 billion | 36063.61 | 36.06 thousand |
| 4 | CA |
7,944,017.00
7.94 million
|
7.94 million | 1678488363920.5 | 1.68 trillion | 211289.62 | 211.29 thousand |
| 5 | NJ |
5,901,016.00
5.90 million
|
5.90 million | 268451553155.42 | 268.45 billion | 45492.42 | 45.49 thousand |
| 6 | TX |
5,323,099.00
5.32 million
|
5.32 million | 1384443642668.7 | 1.38 trillion | 260082.26 | 260.08 thousand |
| 7 | NY |
4,950,948.00
4.95 million
|
4.95 million | 485925394310.37 | 485.93 billion | 98147.94 | 98.15 thousand |
| 8 | MD |
4,387,084.00
4.39 million
|
4.39 million | 880106772099.77 | 880.11 billion | 200613.15 | 200.61 thousand |
| 9 | FL |
3,900,460.00
3.90 million
|
3.90 million | 594783652203.78 | 594.78 billion | 152490.64 | 152.49 thousand |
| 10 | MI |
3,152,999.00
3.15 million
|
3.15 million | 196629942579.89 | 196.63 billion | 62362.83 | 62.36 thousand |
| 11 | MA |
3,016,548.00
3.02 million
|
3.02 million | 494547550188.1 | 494.55 billion | 163944.86 | 163.94 thousand |
| 12 | GA |
2,935,353.00
2.94 million
|
2.94 million | 312425734093.09 | 312.43 billion | 106435.48 | 106.44 thousand |
| 13 | NC |
2,888,689.00
2.89 million
|
2.89 million | 172484394499.69 | 172.48 billion | 59710.26 | 59.71 thousand |
| 14 | MO |
2,719,994.00
2.72 million
|
2.72 million | 439233511418.39 | 439.23 billion | 161483.26 | 161.48 thousand |
| 15 | OH |
2,673,788.00
2.67 million
|
2.67 million | 287787646387.56 | 287.79 billion | 107632.93 | 107.63 thousand |
| 16 | DC |
2,644,090.00
2.64 million
|
2.64 million | 620902550301.26 | 620.90 billion | 234826.55 | 234.83 thousand |
| 17 | WA |
2,116,192.00
2.12 million
|
2.12 million | 376589850548.27 | 376.59 billion | 177956.37 | 177.96 thousand |
| 18 | WI |
1,896,495.00
1.90 million
|
1.90 million | 139589110179.15 | 139.59 billion | 73603.73 | 73.60 thousand |
| 19 | AL |
1,649,370.00
1.65 million
|
1.65 million | 333613887252.61 | 333.61 billion | 202267.46 | 202.27 thousand |
| 20 | AZ |
1,429,862.00
1.43 million
|
1.43 million | 409927591139.85 | 409.93 billion | 286690.31 | 286.69 thousand |
| 21 | CO |
1,415,510.00
1.42 million
|
1.42 million | 317921361454.02 | 317.92 billion | 224598.45 | 224.60 thousand |
| 22 | CT |
1,401,966.00
1.40 million
|
1.40 million | 455306744656.62 | 455.31 billion | 324763.04 | 324.76 thousand |
| 23 | SC |
1,198,246.00
1.20 million
|
1.20 million | 201863485106.38 | 201.86 billion | 168465.81 | 168.47 thousand |
| 24 | MN |
1,127,753.00
1.13 million
|
1.13 million | 115831332189.73 | 115.83 billion | 102709.84 | 102.71 thousand |
| 25 | TN |
971,309.00
971.31 thousand
|
971.31 thousand | 274583798478.7 | 274.58 billion | 282694.58 | 282.69 thousand |
| 26 | IN |
943,168.00
943.17 thousand
|
943.17 thousand | 167835550028.16 | 167.84 billion | 177948.73 | 177.95 thousand |
| 27 | KY |
914,970.00
914.97 thousand
|
914.97 thousand | 219610187872.86 | 219.61 billion | 240019 | 240.02 thousand |
| 28 | MS |
906,346.00
906.35 thousand
|
906.35 thousand | 178727835452.56 | 178.73 billion | 197196.03 | 197.20 thousand |
| 29 | OR |
899,584.00
899.58 thousand
|
899.58 thousand | 51760047807.51 | 51.76 billion | 57537.75 | 57.54 thousand |
| 30 | LA |
873,282.00
873.28 thousand
|
873.28 thousand | 166997637261.02 | 167.00 billion | 191229.9 | 191.23 thousand |
| 31 | OK |
868,796.00
868.80 thousand
|
868.80 thousand | 109264772950.13 | 109.26 billion | 125765.74 | 125.77 thousand |
| 32 | KS |
760,802.00
760.80 thousand
|
760.80 thousand | 90813525882.67 | 90.81 billion | 119365.51 | 119.37 thousand |
| 33 | HI |
728,996.00
729.00 thousand
|
729.00 thousand | 87089872830.52 | 87.09 billion | 119465.5 | 119.47 thousand |
| 34 | NM |
594,691.00
594.69 thousand
|
594.69 thousand | 315880590715.62 | 315.88 billion | 531167.59 | 531.17 thousand |
| 35 | AR |
574,014.00
574.01 thousand
|
574.01 thousand | 42800539473.83 | 42.80 billion | 74563.58 | 74.56 thousand |
| 36 | UT |
517,024.00
517.02 thousand
|
517.02 thousand | 109948969501.09 | 109.95 billion | 212657.38 | 212.66 thousand |
| 37 | AK |
432,549.00
432.55 thousand
|
432.55 thousand | 78970881505.09 | 78.97 billion | 182570.94 | 182.57 thousand |
| 38 | WV |
419,312.00
419.31 thousand
|
419.31 thousand | 41350795465.29 | 41.35 billion | 98615.81 | 98.62 thousand |
| 39 | NE |
417,192.00
417.19 thousand
|
417.19 thousand | 35162204747.91 | 35.16 billion | 84283.02 | 84.28 thousand |
| 40 | IA |
415,756.00
415.76 thousand
|
415.76 thousand | 68371513744.35 | 68.37 billion | 164451.05 | 164.45 thousand |
| 41 | MT |
394,777.00
394.78 thousand
|
394.78 thousand | 23609431143.49 | 23.61 billion | 59804.47 | 59.80 thousand |
| 42 | NV |
370,360.00
370.36 thousand
|
370.36 thousand | 82982795276.31 | 82.98 billion | 224059.82 | 224.06 thousand |
| 43 | ID |
367,177.00
367.18 thousand
|
367.18 thousand | 77369168039.06 | 77.37 billion | 210713.54 | 210.71 thousand |
| 44 | RI |
278,992.00
278.99 thousand
|
278.99 thousand | 42906286509.2 | 42.91 billion | 153790.38 | 153.79 thousand |
| 45 | SD |
257,978.00
257.98 thousand
|
257.98 thousand | 22225111789.93 | 22.23 billion | 86151.19 | 86.15 thousand |
| 46 | NH |
252,480.00
252.48 thousand
|
252.48 thousand | 53285625175.17 | 53.29 billion | 211048.89 | 211.05 thousand |
| 47 | ME |
236,724.00
236.72 thousand
|
236.72 thousand | 72198811438 | 72.20 billion | 304991.51 | 304.99 thousand |
| 48 | ND |
211,200.00
211.20 thousand
|
211.20 thousand | 19638726830.19 | 19.64 billion | 92986.39 | 92.99 thousand |
| 49 | GU |
193,898.00
193.90 thousand
|
193.90 thousand | 39813719407.2 | 39.81 billion | 205333.31 | 205.33 thousand |
| 50 | DE |
178,326.00
178.33 thousand
|
178.33 thousand | 17034247235.61 | 17.03 billion | 95523.07 | 95.52 thousand |
| 51 | PR |
173,341.00
173.34 thousand
|
173.34 thousand | 31639569268.12 | 31.64 billion | 182527.9 | 182.53 thousand |
| 52 | VT |
164,043.00
164.04 thousand
|
164.04 thousand | 18478804805.15 | 18.48 billion | 112646.1 | 112.65 thousand |
| 53 | WY |
142,513.00
142.51 thousand
|
142.51 thousand | 14600287853.6 | 14.60 billion | 102448.81 | 102.45 thousand |
| 54 | MH |
22,222.00
22.22 thousand
|
22.22 thousand | 10968981463.2 | 10.97 billion | 493609.1 | 493.61 thousand |
| 55 | 98 |
20,315.00
20.32 thousand
|
20.32 thousand | 26240511097 | 26.24 billion | 1291681.57 | 1.29 million |
| 56 | MP |
19,666.00
19.67 thousand
|
19.67 thousand | 3299513313.17 | 3.30 billion | 167777.55 | 167.78 thousand |
| 57 | VI |
17,967.00
17.97 thousand
|
17.97 thousand | 3805770883.3 | 3.81 billion | 211820.05 | 211.82 thousand |
| 58 | AS |
11,903.00
11.90 thousand
|
11.90 thousand | 6354842803.86 | 6.35 billion | 533885.81 | 533.89 thousand |
| 59 | FM |
9,294.00
9.29 thousand
|
9.29 thousand | 2769185248.33 | 2.77 billion | 297954.08 | 297.95 thousand |
| 60 | PW |
6,933.00
6.93 thousand
|
6.93 thousand | 1810445991.21 | 1.81 billion | 261134.57 | 261.13 thousand |
| 61 | UM |
2,228.00
2.23 thousand
|
2.23 thousand | 1739477089.03 | 1.74 billion | 780734.77 | 780.73 thousand |
| 62 | AE |
364.00
364.00
|
364.00 | 32173059.06 | 32.17 million | 88387.52 | 88.39 thousand |
| 63 | AP |
269.00
269.00
|
269.00 | 15854785.44 | 15.85 million | 58939.72 | 58.94 thousand |
| 64 | US |
160.00
160.00
|
160.00 | 4567448.64 | 4.57 million | 28546.55 | 28.55 thousand |
| 65 | oh |
119.00
119.00
|
119.00 | 12085789.82 | 12.09 million | 101561.25 | 101.56 thousand |
| 66 | 49 |
55.00
55.00
|
55.00 | 380130.73 | 380.13 thousand | 6911.46 | 6.91 thousand |
| 67 | pa |
33.00
33.00
|
33.00 | 225698.93 | 225.70 thousand | 6839.36 | 6.84 thousand |
| 68 | TS |
28.00
28.00
|
28.00 | 268796.14 | 268.80 thousand | 9599.86 | 9.60 thousand |
| 69 | va |
25.00
25.00
|
25.00 | 323464.61 | 323.46 thousand | 12938.58 | 12.94 thousand |
| 70 | ON |
20.00
20.00
|
20.00 | 89188.88 | 89.19 thousand | 4459.44 | 4.46 thousand |
| 71 | ST |
20.00
20.00
|
20.00 | 360342.39 | 360.34 thousand | 18017.11 | 18.02 thousand |
| 72 | 51 |
19.00
19.00
|
19.00 | 749326.27 | 749.33 thousand | 39438.22 | 39.44 thousand |
| 73 | GM |
12.00
12.00
|
12.00 | 185425.72 | 185.43 thousand | 15452.14 | 15.45 thousand |
| 74 | JA |
9.00
9.00
|
9.00 | 45826.79 | 45.83 thousand | 5091.86 | 5.09 thousand |
| 75 |
7.00
7.00
|
7.00 | 8957942.62 | 8.96 million | 1279706.08 | 1.28 million | |
| 76 | mi |
6.00
6.00
|
6.00 | 412319.16 | 412.32 thousand | 68719.86 | 68.72 thousand |
| 77 | 0K |
6.00
6.00
|
6.00 | 1096 | 1.10 thousand | 182.66 | 182.66 |
| 78 | ny |
5.00
5.00
|
5.00 | 152651.3 | 152.65 thousand | 30530.26 | 30.53 thousand |
| 79 | GT |
4.00
4.00
|
4.00 | 11330 | 11.33 thousand | 2832.5 | 2.83 thousand |
| 80 | UK |
4.00
4.00
|
4.00 | 266965 | 266.96 thousand | 66741.25 | 66.74 thousand |
| 81 | AA |
4.00
4.00
|
4.00 | 713061.35 | 713.06 thousand | 178265.33 | 178.27 thousand |
| 82 | NS |
2.00
2.00
|
2.00 | 68203.5 | 68.20 thousand | 34101.75 | 34.10 thousand |
| 83 | TW |
2.00
2.00
|
2.00 | 17357.41 | 17.36 thousand | 8678.7 | 8.68 thousand |
| 84 | BL |
2.00
2.00
|
2.00 | 23925 | 23.93 thousand | 11962.5 | 11.96 thousand |
| 85 | / |
2.00
2.00
|
2.00 | 24942.95 | 24.94 thousand | 12471.47 | 12.47 thousand |
| 86 | SE |
2.00
2.00
|
2.00 | 18391.04 | 18.39 thousand | 9195.52 | 9.20 thousand |
| 87 | 01 |
2.00
2.00
|
2.00 | 1752408.02 | 1.75 million | 876204.01 | 876.20 thousand |
| 88 | 40 |
1.00
1.00
|
1.00 | 3000 | 3.00 thousand | 3000 | 3.00 thousand |
| 89 | BC |
1.00
1.00
|
1.00 | -298 | -298.00 | -298 | -298.00 |
| 90 | 45 |
1.00
1.00
|
1.00 | 11359.52 | 11.36 thousand | 11359.52 | 11.36 thousand |
| 91 | ca |
1.00
1.00
|
1.00 | 66625.84 | 66.63 thousand | 66625.84 | 66.63 thousand |
| 92 | 56 |
1.00
1.00
|
1.00 | 4125 | 4.13 thousand | 4125 | 4.13 thousand |
| 93 | GB |
1.00
1.00
|
1.00 | 59840 | 59.84 thousand | 59840 | 59.84 thousand |
| 94 | OL |
1.00
1.00
|
1.00 | 15000 | 15.00 thousand | 15000 | 15.00 thousand |
| 95 | PK |
1.00
1.00
|
1.00 | 2236.82 | 2.24 thousand | 2236.82 | 2.24 thousand |
| 96 | 08 |
1.00
1.00
|
1.00 | 9955.54 | 9.96 thousand | 9955.54 | 9.96 thousand |
| 97 | QC |
1.00
1.00
|
1.00 | 6120 | 6.12 thousand | 6120 | 6.12 thousand |
How This Ranking Is Built
Build a ranked FPDS view for "Top States by Award Count" 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.
- COUNT logic is used because the ranking is based on volume of awards.
Included fields
- state_code — Defines the ranked state or geography.
- award_count — Defines the main ranking metric: Award Count.
- total_obligated — Adds supporting context to the leaderboard.
- avg_award_size — 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 Entities
| # | Entity | Value |
|---|---|---|
| 1 | VA | 9.48M |
| 2 | PA | 8.56M |
| 3 | IL | 8.47M |
| 4 | CA | 7.94M |
| 5 | NJ | 5.9M |
| 6 | TX | 5.32M |
| 7 | NY | 4.95M |
| 8 | MD | 4.39M |
| 9 | FL | 3.9M |
| 10 | MI | 3.15M |
Related Pages
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.