Federal Spending by State

Total awards by state of performance for our tracked agencies.

Custom SQL query returning 61 rows (hide) 

SELECT state_code, COUNT(*) AS award_count, CAST(SUM(award_amount) AS INTEGER) AS total_amount, SUM(CASE WHEN award_category = 'grants' THEN 1 ELSE 0 END) AS grants, SUM(CASE WHEN award_category = 'contracts' THEN 1 ELSE 0 END) AS contracts FROM spending_awards WHERE state_code IS NOT NULL AND state_code != '' GROUP BY state_code ORDER BY total_amount DESC

Edit SQL

This data as json, CSV

state_codeaward_counttotal_amountgrantscontracts
CA 72897 532074932730 34621 38276
TX 42197 397056372730 18888 23309
VA 67204 356843104051 9700 57504
NY 30793 269032932843 18773 12020
NM 8741 221120808018 5860 2881
DC 62303 209373177582 4644 57659
MD 53142 184640188434 8990 44152
FL 32355 183600686514 14798 17557
TN 12491 177626633065 6557 5934
WA 23108 149869931252 11061 12047
IL 21497 139512076261 11437 10060
PA 24526 127871327332 13424 11102
SC 10590 99881626655 6406 4184
CO 25472 96328505913 9624 15848
PR 7297 92119500145 4730 2567
NJ 19371 91360301073 8498 10873
AZ 13822 85456190267 8375 5447
OH 22510 85129465430 11721 10789
LA 12352 80995544069 6979 5373
NC 19404 79155914542 10151 9253
MA 26473 77903495376 12459 14014
GA 17520 74255804682 8377 9143
AL 15452 69805943902 8381 7071
MI 16428 67996067234 10390 6038
MO 12417 67564127656 6158 6259
WI 12108 50120033371 7506 4602
ID 5730 45907715084 3977 1753
IN 10423 41719755990 6558 3865
MS 8579 41364360939 5396 3183
MN 12670 41121268922 7617 5053
KY 9798 40169150543 5970 3828
NV 6246 39661224520 4558 1688
OK 17550 38072712178 7644 9906
OR 13291 36538760158 8132 5159
CT 8518 34238552495 5589 2929
AK 12919 32928293879 7860 5059
KS 8122 30921087868 4662 3460
WV 8332 28356083388 4084 4248
UT 6983 26944332704 4378 2605
VI 1638 26488262087 1025 613
AR 7686 24370448467 4938 2748
IA 9733 22459128872 5029 4704
HI 8227 19474828863 4268 3959
NE 5923 17691557127 4293 1630
MT 6776 15524131969 5009 1767
RI 4563 12606730234 3460 1103
ME 5683 12557763982 4563 1120
SD 6001 12533224555 3746 2255
NH 5932 11746089389 3268 2664
DE 3634 10261359636 2672 962
ND 4578 10237800461 3360 1218
WY 3368 9685729843 2508 860
VT 3424 9318157659 2658 766
GU 1533 3949230885 1057 476
MP 1085 2856882582 789 296
AS 744 1773223669 608 136
FM 84 302476157 68 16
MH 42 88425863 36 6
PW 50 57120470 40 10
AP 2 3052766 0 2
UM 2 1297850 2 0