Federal Spending by State

Total awards by state of performance for our tracked agencies.

Custom SQL query returning 59 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
MD 12456 21159004302 777 11679
CA 8916 7844585789 3898 5018
DC 1527 7642402498 447 1080
VA 6714 7242912730 877 5837
NY 2451 6522212726 979 1472
PA 2401 5288721927 881 1520
TX 4883 4052160565 2077 2806
NC 2751 3786547481 1138 1613
MA 2793 3050334329 753 2040
CO 3724 2740647964 1187 2537
OH 1907 2595933020 669 1238
IL 2591 2575048259 1011 1580
MI 2251 2519203559 1189 1062
AK 2955 2212243853 1570 1385
FL 4253 2122098043 1391 2862
WA 4184 2028357765 1697 2487
NJ 1334 1821928128 554 780
MN 2360 1771405754 983 1377
GA 2490 1725784023 867 1623
CT 774 1696434425 497 277
OR 3518 1640552074 2050 1468
TN 1081 1628243117 563 518
WI 2138 1478864910 1048 1090
AZ 1525 1468204329 735 790
LA 1496 1461760054 755 741
NE 1076 1409558906 758 318
MS 1352 1401813583 793 559
MO 1443 1379159690 516 927
AR 2019 1251217517 666 1353
OK 1284 1053107747 789 495
SC 1369 1017026085 867 502
IN 1004 979661552 608 396
KS 1453 970936353 689 764
HI 1368 955405574 811 557
UT 1320 947685110 715 605
NM 1573 942316259 967 606
ID 1623 896050651 844 779
AL 1247 888628070 763 484
MT 1468 879352409 755 713
IA 3197 859136865 551 2646
WV 999 855800107 501 498
KY 910 813947392 591 319
NV 1273 747561254 900 373
ND 940 729561191 450 490
PR 933 690661193 465 468
ME 985 678612294 693 292
DE 668 558067576 389 279
SD 1235 535648266 554 681
WY 474 515882408 337 137
RI 524 465379575 389 135
NH 741 458068662 380 361
VT 664 456304991 458 206
GU 440 223705446 286 154
AS 189 207509194 183 6
VI 178 172940602 153 25
MP 266 167931239 260 6
UM 1 1267419 1 0
FM 3 324999 3 0
PW 2 321015 1 1