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 69988 521221014677 33350 36638
TX 40932 382462972958 18614 22318
VA 64555 344094481672 9457 55098
NY 29977 263642145052 18377 11600
NM 8214 220010347533 5431 2783
DC 59959 213215670958 4371 55588
MD 51820 181284256891 8772 43048
FL 31814 177457451658 14479 17335
TN 12143 175417549417 6408 5735
WA 21784 147206166446 10470 11314
IL 20218 134336193402 11016 9202
PA 23767 124537373554 13200 10567
SC 10329 98796695621 6205 4124
CO 24067 95155674136 9418 14649
PR 7155 90493888552 4623 2532
NJ 19050 89718509121 8277 10773
AZ 13340 84243663710 7943 5397
OH 20670 81597938285 11363 9307
LA 12005 79890925835 6716 5289
NC 17181 76636723522 9838 7343
MA 24713 75315122928 12018 12695
GA 16378 72102084993 8110 8268
AL 15121 68380869073 8222 6899
MO 11879 65999375478 5992 5887
MI 14994 65575949984 9970 5024
WI 11514 48394843749 7038 4476
ID 5395 45113636134 3753 1642
MS 8284 40428696948 5169 3115
IN 10057 40249608361 6343 3714
KY 9394 39091248752 5809 3585
NV 5740 38958462760 4266 1474
MN 11973 38739746066 7231 4742
OK 17081 36633589287 7051 10030
OR 12667 35678870734 7851 4816
CT 8183 32764436289 5321 2862
AK 12051 31681286368 7050 5001
KS 6957 29850113119 4461 2496
WV 8150 27415866224 3925 4225
UT 6760 26344967303 4186 2574
VI 1579 26240087752 970 609
AR 7522 23662979923 4766 2756
IA 8889 21430090318 4843 4046
HI 8090 18905433252 4148 3942
NE 5631 17397199580 4071 1560
MT 6392 14990579637 4723 1669
SD 5769 12090281189 3563 2206
ME 5319 11984243942 4227 1092
RI 4231 11928305577 3243 988
NH 5646 11151334226 3056 2590
ND 4404 9786445891 3234 1170
DE 3336 9662867050 2484 852
WY 3259 9384132086 2416 843
VT 3196 8647758279 2455 741
GU 1486 3725800093 1050 436
MP 1053 2659145839 769 284
AS 726 1603814877 597 129
FM 85 301481832 68 17
PW 51 119619242 41 10
MH 45 100500316 37 8
UM 1 1267419 1 0
AP 2 103040 0 2