Option 1:
# Import the expenditures.csv file in the data folder
expenditures <- read.csv("../data/expenditures.csv")
# Reshape this data from wide to long
long <- expenditures %>% gather(Year, Costs, 2:15)
# 2. Separate FY from the Year
tidy <- long %>% separate(Year, into = c("Period", "Year"))
Option 2:
tidy <- expenditures %>%
gather(Year, Costs, 2:15) %>%
separate(Year, into = c("Period", "Year"))
tidy
## State Period Year Costs
## 1 Alabama FY 1980 1146713
## 2 Alaska FY 1980 377947
## 3 Arizona FY 1980 949753
## 4 Arkansas FY 1980 666949
## 5 California FY 1980 9172158
## 6 Colorado FY 1980 1243049
## 7 Connecticut FY 1980 1227892
## 8 Delaware FY 1980 269108
## 9 Florida FY 1980 2766468
## 10 Georgia FY 1980 1608028
## 11 Hawaii FY 1980 351889
## 12 Idaho FY 1980 313927
## 13 Illinois FY 1980 4579355
## 14 Indiana FY 1980 1851292
## 15 Iowa FY 1980 1186659
## 16 Kansas FY 1980 830133
## 17 Kentucky FY 1980 1054459
## 18 Louisiana FY 1980 1303902
## 19 Maine FY 1980 385492
## 20 Maryland FY 1980 1783056
## 21 Massachusetts FY 1980 2638734
## 22 Michigan FY 1980 4642847
## 23 Minnesota FY 1980 1786768
## 24 Mississippi FY 1980 756018
## 25 Missouri FY 1980 1504988
## 26 Montana FY 1980 358118
## 27 Nebraska FY 1980 581615
## 28 Nevada FY 1980 281901
## 29 New Hampshire FY 1980 295400
## 30 New Jersey FY 1980 3638533
## 31 New Mexico FY 1980 515451
## 32 New York FY 1980 8760500
## 33 North Carolina FY 1980 1880862
## 34 North Dakota FY 1980 228483
## 35 Ohio FY 1980 3836576
## 36 Oklahoma FY 1980 1055844
## 37 Oregon FY 1980 1126812
## 38 Pennsylvania FY 1980 4584320
## 39 Rhode Island FY 1980 362046
## 40 South Carolina FY 1980 997984
## 41 South Dakota FY 1980 238332
## 42 Tennessee FY 1980 1319303
## 43 Texas FY 1980 4997689
## 44 Utah FY 1980 518251
## 45 Vermont FY 1980 189811
## 46 Virginia FY 1980 1881519
## 47 Washington FY 1980 1825782
## 48 West Virginia FY 1980 678386
## 49 Wisconsin FY 1980 1908523
## 50 Wyoming FY 1980 226067
## 51 Alabama FY 1990 2275233
## 52 Alaska FY 1990 828051
## 53 Arizona FY 1990 2258660
## 54 Arkansas FY 1990 1404545
## 55 California FY 1990 21485782
## 56 Colorado FY 1990 2451833
## 57 Connecticut FY 1990 3444520
## 58 Delaware FY 1990 520953
## 59 Florida FY 1990 8228531
## 60 Georgia FY 1990 4505962
## 61 Hawaii FY 1990 700012
## 62 Idaho FY 1990 627794
## 63 Illinois FY 1990 8125493
## 64 Indiana FY 1990 4074578
## 65 Iowa FY 1990 2004742
## 66 Kansas FY 1990 1848302
## 67 Kentucky FY 1990 2134011
## 68 Louisiana FY 1990 2838283
## 69 Maine FY 1990 1048195
## 70 Maryland FY 1990 3894644
## 71 Massachusetts FY 1990 4760390
## 72 Michigan FY 1990 8025621
## 73 Minnesota FY 1990 3474398
## 74 Mississippi FY 1990 1472710
## 75 Missouri FY 1990 3288738
## 76 Montana FY 1990 641345
## 77 Nebraska FY 1990 1233431
## 78 Nevada FY 1990 712898
## 79 New Hampshire FY 1990 821671
## 80 New Jersey FY 1990 8119336
## 81 New Mexico FY 1990 1020148
## 82 New York FY 1990 18090978
## 83 North Carolina FY 1990 4342826
## 84 North Dakota FY 1990 459391
## 85 Ohio FY 1990 7994379
## 86 Oklahoma FY 1990 1905332
## 87 Oregon FY 1990 2297944
## 88 Pennsylvania FY 1990 9496788
## 89 Rhode Island FY 1990 801908
## 90 South Carolina FY 1990 2322618
## 91 South Dakota FY 1990 447074
## 92 Tennessee FY 1990 2790808
## 93 Texas FY 1990 12763954
## 94 Utah FY 1990 1130135
## 95 Vermont FY 1990 546901
## 96 Virginia FY 1990 4621071
## 97 Washington FY 1990 3550819
## 98 West Virginia FY 1990 1316637
## 99 Wisconsin FY 1990 3929920
## 100 Wyoming FY 1990 509084
## 101 Alabama FY 2000 4176082
## 102 Alaska FY 2000 1183499
## 103 Arizona FY 2000 4288739
## 104 Arkansas FY 2000 2380331
## 105 California FY 2000 38129479
## 106 Colorado FY 2000 4401010
## 107 Connecticut FY 2000 5402836
## 108 Delaware FY 2000 937630
## 109 Florida FY 2000 13885988
## 110 Georgia FY 2000 9158624
## 111 Hawaii FY 2000 1213695
## 112 Idaho FY 2000 1302817
## 113 Illinois FY 2000 14462773
## 114 Indiana FY 2000 7110930
## 115 Iowa FY 2000 3264336
## 116 Kansas FY 2000 2971814
## 117 Kentucky FY 2000 3837794
## 118 Louisiana FY 2000 4391189
## 119 Maine FY 2000 1604438
## 120 Maryland FY 2000 6545135
## 121 Massachusetts FY 2000 8564039
## 122 Michigan FY 2000 13994294
## 123 Minnesota FY 2000 6140442
## 124 Mississippi FY 2000 2510376
## 125 Missouri FY 2000 5655531
## 126 Montana FY 2000 994770
## 127 Nebraska FY 2000 1926500
## 128 Nevada FY 2000 1875467
## 129 New Hampshire FY 2000 1418503
## 130 New Jersey FY 2000 13327645
## 131 New Mexico FY 2000 1890274
## 132 New York FY 2000 28433240
## 133 North Carolina FY 2000 7713293
## 134 North Dakota FY 2000 638946
## 135 Ohio FY 2000 12974575
## 136 Oklahoma FY 2000 3382581
## 137 Oregon FY 2000 3896287
## 138 Pennsylvania FY 2000 14120112
## 139 Rhode Island FY 2000 1393143
## 140 South Carolina FY 2000 4087355
## 141 South Dakota FY 2000 737998
## 142 Tennessee FY 2000 4931734
## 143 Texas FY 2000 25098703
## 144 Utah FY 2000 2102655
## 145 Vermont FY 2000 870198
## 146 Virginia FY 2000 7757598
## 147 Washington FY 2000 6399885
## 148 West Virginia FY 2000 2086937
## 149 Wisconsin FY 2000 6852178
## 150 Wyoming FY 2000 683918
## 151 Alabama FY 2001 4354794
## 152 Alaska FY 2001 1229036
## 153 Arizona FY 2001 4846105
## 154 Arkansas FY 2001 2505179
## 155 California FY 2001 42908787
## 156 Colorado FY 2001 4758173
## 157 Connecticut FY 2001 5693207
## 158 Delaware FY 2001 1027224
## 159 Florida FY 2001 15023514
## 160 Georgia FY 2001 10011343
## 161 Hawaii FY 2001 1215968
## 162 Idaho FY 2001 1403190
## 163 Illinois FY 2001 15634490
## 164 Indiana FY 2001 7548487
## 165 Iowa FY 2001 3430885
## 166 Kansas FY 2001 3264698
## 167 Kentucky FY 2001 4047392
## 168 Louisiana FY 2001 4485878
## 169 Maine FY 2001 1704422
## 170 Maryland FY 2001 7044881
## 171 Massachusetts FY 2001 9272387
## 172 Michigan FY 2001 14243597
## 173 Minnesota FY 2001 6531198
## 174 Mississippi FY 2001 2576457
## 175 Missouri FY 2001 6076169
## 176 Montana FY 2001 1041760
## 177 Nebraska FY 2001 2067290
## 178 Nevada FY 2001 1978480
## 179 New Hampshire FY 2001 1518792
## 180 New Jersey FY 2001 14773650
## 181 New Mexico FY 2001 2022093
## 182 New York FY 2001 30884292
## 183 North Carolina FY 2001 8201901
## 184 North Dakota FY 2001 668814
## 185 Ohio FY 2001 13893495
## 186 Oklahoma FY 2001 3750542
## 187 Oregon FY 2001 4112069
## 188 Pennsylvania FY 2001 14895316
## 189 Rhode Island FY 2001 1465703
## 190 South Carolina FY 2001 4492161
## 191 South Dakota FY 2001 796133
## 192 Tennessee FY 2001 5170379
## 193 Texas FY 2001 26546557
## 194 Utah FY 2001 2250339
## 195 Vermont FY 2001 934031
## 196 Virginia FY 2001 8335805
## 197 Washington FY 2001 6782136
## 198 West Virginia FY 2001 2157568
## 199 Wisconsin FY 2001 7249081
## 200 Wyoming FY 2001 704695
## 201 Alabama FY 2002 4444390
## 202 Alaska FY 2002 1284854
## 203 Arizona FY 2002 5395814
## 204 Arkansas FY 2002 2822877
## 205 California FY 2002 46265544
## 206 Colorado FY 2002 5151003
## 207 Connecticut FY 2002 6031062
## 208 Delaware FY 2002 1072875
## 209 Florida FY 2002 15535864
## 210 Georgia FY 2002 10853496
## 211 Hawaii FY 2002 1348381
## 212 Idaho FY 2002 1481803
## 213 Illinois FY 2002 16480787
## 214 Indiana FY 2002 7704547
## 215 Iowa FY 2002 3565796
## 216 Kansas FY 2002 3450923
## 217 Kentucky FY 2002 4268608
## 218 Louisiana FY 2002 4802565
## 219 Maine FY 2002 1812798
## 220 Maryland FY 2002 7480723
## 221 Massachusetts FY 2002 9957292
## 222 Michigan FY 2002 14975150
## 223 Minnesota FY 2002 6586559
## 224 Mississippi FY 2002 2642116
## 225 Missouri FY 2002 6491885
## 226 Montana FY 2002 1073005
## 227 Nebraska FY 2002 2206946
## 228 Nevada FY 2002 2169000
## 229 New Hampshire FY 2002 1641378
## 230 New Jersey FY 2002 15822609
## 231 New Mexico FY 2002 2204165
## 232 New York FY 2002 32218975
## 233 North Carolina FY 2002 8543290
## 234 North Dakota FY 2002 711437
## 235 Ohio FY 2002 14774065
## 236 Oklahoma FY 2002 3875547
## 237 Oregon FY 2002 4214512
## 238 Pennsylvania FY 2002 15550975
## 239 Rhode Island FY 2002 1533455
## 240 South Carolina FY 2002 4744809
## 241 South Dakota FY 2002 819296
## 242 Tennessee FY 2002 5501029
## 243 Texas FY 2002 28191128
## 244 Utah FY 2002 2374702
## 245 Vermont FY 2002 992149
## 246 Virginia FY 2002 8718554
## 247 Washington FY 2002 7103817
## 248 West Virginia FY 2002 2219013
## 249 Wisconsin FY 2002 7592176
## 250 Wyoming FY 2002 761830
## 251 Alabama FY 2003 4657643
## 252 Alaska FY 2003 1326226
## 253 Arizona FY 2003 5892227
## 254 Arkansas FY 2003 2923401
## 255 California FY 2003 47983402
## 256 Colorado FY 2003 5551506
## 257 Connecticut FY 2003 6302988
## 258 Delaware FY 2003 1127745
## 259 Florida FY 2003 16355123
## 260 Georgia FY 2003 11630576
## 261 Hawaii FY 2003 1489092
## 262 Idaho FY 2003 1511862
## 263 Illinois FY 2003 17271301
## 264 Indiana FY 2003 8088684
## 265 Iowa FY 2003 3652022
## 266 Kansas FY 2003 3510675
## 267 Kentucky FY 2003 4401627
## 268 Louisiana FY 2003 5056583
## 269 Maine FY 2003 1909268
## 270 Maryland FY 2003 7933055
## 271 Massachusetts FY 2003 10281820
## 272 Michigan FY 2003 15674698
## 273 Minnesota FY 2003 6867403
## 274 Mississippi FY 2003 2853531
## 275 Missouri FY 2003 6793957
## 276 Montana FY 2003 1124291
## 277 Nebraska FY 2003 2304223
## 278 Nevada FY 2003 2251044
## 279 New Hampshire FY 2003 1781594
## 280 New Jersey FY 2003 17185966
## 281 New Mexico FY 2003 2281608
## 282 New York FY 2003 34546965
## 283 North Carolina FY 2003 8766968
## 284 North Dakota FY 2003 716007
## 285 Ohio FY 2003 15868494
## 286 Oklahoma FY 2003 3804570
## 287 Oregon FY 2003 4150747
## 288 Pennsylvania FY 2003 16344439
## 289 Rhode Island FY 2003 1647587
## 290 South Carolina FY 2003 4888250
## 291 South Dakota FY 2003 851429
## 292 Tennessee FY 2003 5674773
## 293 Texas FY 2003 30399603
## 294 Utah FY 2003 2366897
## 295 Vermont FY 2003 1045213
## 296 Virginia FY 2003 9208329
## 297 Washington FY 2003 7359566
## 298 West Virginia FY 2003 2349833
## 299 Wisconsin FY 2003 7934755
## 300 Wyoming FY 2003 791732
## 301 Alabama FY 2004 4812479
## 302 Alaska FY 2004 1354846
## 303 Arizona FY 2004 6071785
## 304 Arkansas FY 2004 3109644
## 305 California FY 2004 49215866
## 306 Colorado FY 2004 5666191
## 307 Connecticut FY 2004 6600767
## 308 Delaware FY 2004 1201631
## 309 Florida FY 2004 17578884
## 310 Georgia FY 2004 11788616
## 311 Hawaii FY 2004 1566792
## 312 Idaho FY 2004 1555006
## 313 Illinois FY 2004 18081827
## 314 Indiana FY 2004 8524980
## 315 Iowa FY 2004 3669797
## 316 Kansas FY 2004 3658421
## 317 Kentucky FY 2004 4553382
## 318 Louisiana FY 2004 5290964
## 319 Maine FY 2004 1969497
## 320 Maryland FY 2004 8198454
## 321 Massachusetts FY 2004 10799765
## 322 Michigan FY 2004 15983044
## 323 Minnesota FY 2004 7084005
## 324 Mississippi FY 2004 3059569
## 325 Missouri FY 2004 6832454
## 326 Montana FY 2004 1160838
## 327 Nebraska FY 2004 2413404
## 328 Nevada FY 2004 2470581
## 329 New Hampshire FY 2004 1900240
## 330 New Jersey FY 2004 18416695
## 331 New Mexico FY 2004 2446115
## 332 New York FY 2004 36205111
## 333 North Carolina FY 2004 8994620
## 334 North Dakota FY 2004 749697
## 335 Ohio FY 2004 16662985
## 336 Oklahoma FY 2004 3853308
## 337 Oregon FY 2004 4199485
## 338 Pennsylvania FY 2004 17680332
## 339 Rhode Island FY 2004 1765585
## 340 South Carolina FY 2004 5017833
## 341 South Dakota FY 2004 887328
## 342 Tennessee FY 2004 6056657
## 343 Texas FY 2004 30974890
## 344 Utah FY 2004 2475550
## 345 Vermont FY 2004 1111029
## 346 Virginia FY 2004 9798239
## 347 Washington FY 2004 7549235
## 348 West Virginia FY 2004 2415043
## 349 Wisconsin FY 2004 8131276
## 350 Wyoming FY 2004 814092
## 351 Alabama FY 2005 5164406
## 352 Alaska FY 2005 1442269
## 353 Arizona FY 2005 6579957
## 354 Arkansas FY 2005 3546999
## 355 California FY 2005 50918654
## 356 Colorado FY 2005 5994440
## 357 Connecticut FY 2005 7080396
## 358 Delaware FY 2005 1299349
## 359 Florida FY 2005 19042877
## 360 Georgia FY 2005 12528856
## 361 Hawaii FY 2005 1648086
## 362 Idaho FY 2005 1618215
## 363 Illinois FY 2005 18658428
## 364 Indiana FY 2005 9108931
## 365 Iowa FY 2005 3808200
## 366 Kansas FY 2005 3718153
## 367 Kentucky FY 2005 4812591
## 368 Louisiana FY 2005 5554766
## 369 Maine FY 2005 2056266
## 370 Maryland FY 2005 8682586
## 371 Massachusetts FY 2005 11357857
## 372 Michigan FY 2005 16353921
## 373 Minnesota FY 2005 7310284
## 374 Mississippi FY 2005 3243888
## 375 Missouri FY 2005 7115207
## 376 Montana FY 2005 1193182
## 377 Nebraska FY 2005 2512914
## 378 Nevada FY 2005 2722264
## 379 New Hampshire FY 2005 2021144
## 380 New Jersey FY 2005 19669576
## 381 New Mexico FY 2005 2554638
## 382 New York FY 2005 38866853
## 383 North Carolina FY 2005 9835550
## 384 North Dakota FY 2005 832157
## 385 Ohio FY 2005 17167866
## 386 Oklahoma FY 2005 4161024
## 387 Oregon FY 2005 4458028
## 388 Pennsylvania FY 2005 18711100
## 389 Rhode Island FY 2005 1825900
## 390 South Carolina FY 2005 5312739
## 391 South Dakota FY 2005 916563
## 392 Tennessee FY 2005 6446691
## 393 Texas FY 2005 31919107
## 394 Utah FY 2005 2627022
## 395 Vermont FY 2005 1177478
## 396 Virginia FY 2005 10705162
## 397 Washington FY 2005 7870979
## 398 West Virginia FY 2005 2527767
## 399 Wisconsin FY 2005 8435359
## 400 Wyoming FY 2005 863423
## 401 Alabama FY 2006 5699076
## 402 Alaska FY 2006 1529645
## 403 Arizona FY 2006 7130341
## 404 Arkansas FY 2006 3808011
## 405 California FY 2006 53436103
## 406 Colorado FY 2006 6368289
## 407 Connecticut FY 2006 7517025
## 408 Delaware FY 2006 1405465
## 409 Florida FY 2006 20897327
## 410 Georgia FY 2006 13739263
## 411 Hawaii FY 2006 1805521
## 412 Idaho FY 2006 1694827
## 413 Illinois FY 2006 19244908
## 414 Indiana FY 2006 9241986
## 415 Iowa FY 2006 4039389
## 416 Kansas FY 2006 4039417
## 417 Kentucky FY 2006 5213620
## 418 Louisiana FY 2006 5554278
## 419 Maine FY 2006 2119408
## 420 Maryland FY 2006 9381613
## 421 Massachusetts FY 2006 11747010
## 422 Michigan FY 2006 16681981
## 423 Minnesota FY 2006 7686638
## 424 Mississippi FY 2006 3550261
## 425 Missouri FY 2006 7592485
## 426 Montana FY 2006 1254360
## 427 Nebraska FY 2006 2672629
## 428 Nevada FY 2006 2959728
## 429 New Hampshire FY 2006 2139113
## 430 New Jersey FY 2006 20869993
## 431 New Mexico FY 2006 2729707
## 432 New York FY 2006 41149457
## 433 North Carolina FY 2006 10476056
## 434 North Dakota FY 2006 857774
## 435 Ohio FY 2006 17829599
## 436 Oklahoma FY 2006 4406002
## 437 Oregon FY 2006 4773751
## 438 Pennsylvania FY 2006 19631006
## 439 Rhode Island FY 2006 1934429
## 440 South Carolina FY 2006 5696629
## 441 South Dakota FY 2006 948671
## 442 Tennessee FY 2006 6681445
## 443 Texas FY 2006 33851773
## 444 Utah FY 2006 2778236
## 445 Vermont FY 2006 1237442
## 446 Virginia FY 2006 11470735
## 447 Washington FY 2006 8239716
## 448 West Virginia FY 2006 2651491
## 449 Wisconsin FY 2006 8745195
## 450 Wyoming FY 2006 965350
## 451 Alabama FY 2007 6245031
## 452 Alaska FY 2007 1634316
## 453 Arizona FY 2007 7815720
## 454 Arkansas FY 2007 3997701
## 455 California FY 2007 57352599
## 456 Colorado FY 2007 6579053
## 457 Connecticut FY 2007 7855459
## 458 Delaware FY 2007 1437707
## 459 Florida FY 2007 22887024
## 460 Georgia FY 2007 14828715
## 461 Hawaii FY 2007 2045198
## 462 Idaho FY 2007 1777491
## 463 Illinois FY 2007 20326591
## 464 Indiana FY 2007 9497077
## 465 Iowa FY 2007 4231932
## 466 Kansas FY 2007 4339477
## 467 Kentucky FY 2007 5424621
## 468 Louisiana FY 2007 6040368
## 469 Maine FY 2007 2258764
## 470 Maryland FY 2007 10210303
## 471 Massachusetts FY 2007 12383447
## 472 Michigan FY 2007 17013259
## 473 Minnesota FY 2007 8060410
## 474 Mississippi FY 2007 3692358
## 475 Missouri FY 2007 7957705
## 476 Montana FY 2007 1320112
## 477 Nebraska FY 2007 2825608
## 478 Nevada FY 2007 3311471
## 479 New Hampshire FY 2007 2246692
## 480 New Jersey FY 2007 22448262
## 481 New Mexico FY 2007 2904474
## 482 New York FY 2007 43679908
## 483 North Carolina FY 2007 11248336
## 484 North Dakota FY 2007 838221
## 485 Ohio FY 2007 18251361
## 486 Oklahoma FY 2007 4750536
## 487 Oregon FY 2007 5039632
## 488 Pennsylvania FY 2007 20404304
## 489 Rhode Island FY 2007 2039633
## 490 South Carolina FY 2007 6023043
## 491 South Dakota FY 2007 977006
## 492 Tennessee FY 2007 6975099
## 493 Texas FY 2007 36105784
## 494 Utah FY 2007 2987810
## 495 Vermont FY 2007 1300149
## 496 Virginia FY 2007 12465858
## 497 Washington FY 2007 8752007
## 498 West Virginia FY 2007 2742344
## 499 Wisconsin FY 2007 9029660
## 500 Wyoming FY 2007 1124564
## 501 Alabama FY 2008 6832439
## 502 Alaska FY 2008 1918375
## 503 Arizona FY 2008 8403221
## 504 Arkansas FY 2008 4156368
## 505 California FY 2008 61570555
## 506 Colorado FY 2008 7338766
## 507 Connecticut FY 2008 8336789
## 508 Delaware FY 2008 1489594
## 509 Florida FY 2008 24224114
## 510 Georgia FY 2008 16030039
## 511 Hawaii FY 2008 2122779
## 512 Idaho FY 2008 1891505
## 513 Illinois FY 2008 21874484
## 514 Indiana FY 2008 9281709
## 515 Iowa FY 2008 4499236
## 516 Kansas FY 2008 4633517
## 517 Kentucky FY 2008 5822550
## 518 Louisiana FY 2008 6814455
## 519 Maine FY 2008 2308071
## 520 Maryland FY 2008 11211176
## 521 Massachusetts FY 2008 13182987
## 522 Michigan FY 2008 17053521
## 523 Minnesota FY 2008 8426264
## 524 Mississippi FY 2008 3898401
## 525 Missouri FY 2008 8526641
## 526 Montana FY 2008 1392449
## 527 Nebraska FY 2008 2970323
## 528 Nevada FY 2008 3515004
## 529 New Hampshire FY 2008 2399330
## 530 New Jersey FY 2008 24357079
## 531 New Mexico FY 2008 3057061
## 532 New York FY 2008 46443426
## 533 North Carolina FY 2008 11482912
## 534 North Dakota FY 2008 886317
## 535 Ohio FY 2008 18892374
## 536 Oklahoma FY 2008 4932913
## 537 Oregon FY 2008 5409630
## 538 Pennsylvania FY 2008 21157430
## 539 Rhode Island FY 2008 2134609
## 540 South Carolina FY 2008 6453817
## 541 South Dakota FY 2008 1037875
## 542 Tennessee FY 2008 7540306
## 543 Texas FY 2008 39033235
## 544 Utah FY 2008 3444936
## 545 Vermont FY 2008 1356165
## 546 Virginia FY 2008 13125666
## 547 Washington FY 2008 9331539
## 548 West Virginia FY 2008 2841962
## 549 Wisconsin FY 2008 9366134
## 550 Wyoming FY 2008 1191736
## 551 Alabama FY 2009 6683843
## 552 Alaska FY 2009 2007319
## 553 Arizona FY 2009 8726755
## 554 Arkansas FY 2009 4240839
## 555 California FY 2009 60080929
## 556 Colorado FY 2009 7187267
## 557 Connecticut FY 2009 8708294
## 558 Delaware FY 2009 1518786
## 559 Florida FY 2009 23328028
## 560 Georgia FY 2009 15976945
## 561 Hawaii FY 2009 2225438
## 562 Idaho FY 2009 1957740
## 563 Illinois FY 2009 23495271
## 564 Indiana FY 2009 9680895
## 565 Iowa FY 2009 4731463
## 566 Kansas FY 2009 4806603
## 567 Kentucky FY 2009 5886890
## 568 Louisiana FY 2009 7276651
## 569 Maine FY 2009 2350447
## 570 Maryland FY 2009 11591965
## 571 Massachusetts FY 2009 13937097
## 572 Michigan FY 2009 17217584
## 573 Minnesota FY 2009 9182281
## 574 Mississippi FY 2009 3967232
## 575 Missouri FY 2009 8827224
## 576 Montana FY 2009 1436062
## 577 Nebraska FY 2009 3053575
## 578 Nevada FY 2009 3606035
## 579 New Hampshire FY 2009 2490623
## 580 New Jersey FY 2009 23446911
## 581 New Mexico FY 2009 3186252
## 582 New York FY 2009 48635363
## 583 North Carolina FY 2009 12598382
## 584 North Dakota FY 2009 928528
## 585 Ohio FY 2009 19387318
## 586 Oklahoma FY 2009 5082062
## 587 Oregon FY 2009 5529831
## 588 Pennsylvania FY 2009 21831816
## 589 Rhode Island FY 2009 2139317
## 590 South Carolina FY 2009 6626763
## 591 South Dakota FY 2009 1080054
## 592 Tennessee FY 2009 7768063
## 593 Texas FY 2009 40688181
## 594 Utah FY 2009 3638775
## 595 Vermont FY 2009 1413329
## 596 Virginia FY 2009 13505290
## 597 Washington FY 2009 9940325
## 598 West Virginia FY 2009 2998657
## 599 Wisconsin FY 2009 9696228
## 600 Wyoming FY 2009 1268407
## 601 Alabama FY 2010 6670517
## 602 Alaska FY 2010 2084019
## 603 Arizona FY 2010 8482552
## 604 Arkansas FY 2010 4459910
## 605 California FY 2010 58248662
## 606 Colorado FY 2010 7429302
## 607 Connecticut FY 2010 8853337
## 608 Delaware FY 2010 1549812
## 609 Florida FY 2010 23349314
## 610 Georgia FY 2010 15730409
## 611 Hawaii FY 2010 2136144
## 612 Idaho FY 2010 1961857
## 613 Illinois FY 2010 24695773
## 614 Indiana FY 2010 9921243
## 615 Iowa FY 2010 4794308
## 616 Kansas FY 2010 4731676
## 617 Kentucky FY 2010 6091814
## 618 Louisiana FY 2010 7393452
## 619 Maine FY 2010 2370085
## 620 Maryland FY 2010 11883677
## 621 Massachusetts FY 2010 13356373
## 622 Michigan FY 2010 17227515
## 623 Minnesota FY 2010 8927288
## 624 Mississippi FY 2010 3990876
## 625 Missouri FY 2010 8923448
## 626 Montana FY 2010 1498252
## 627 Nebraska FY 2010 3213646
## 628 Nevada FY 2010 3592994
## 629 New Hampshire FY 2010 2576956
## 630 New Jersey FY 2010 24261392
## 631 New Mexico FY 2010 3217328
## 632 New York FY 2010 50251461
## 633 North Carolina FY 2010 12200362
## 634 North Dakota FY 2010 1000095
## 635 Ohio FY 2010 19801670
## 636 Oklahoma FY 2010 5192124
## 637 Oregon FY 2010 5401667
## 638 Pennsylvania FY 2010 22733518
## 639 Rhode Island FY 2010 2136582
## 640 South Carolina FY 2010 6566165
## 641 South Dakota FY 2010 1115861
## 642 Tennessee FY 2010 7894661
## 643 Texas FY 2010 42621886
## 644 Utah FY 2010 3635085
## 645 Vermont FY 2010 1432683
## 646 Virginia FY 2010 13193633
## 647 Washington FY 2010 9832913
## 648 West Virginia FY 2010 3328177
## 649 Wisconsin FY 2010 9966244
## 650 Wyoming FY 2010 1334655
## 651 Alabama FY 2011 6592925
## 652 Alaska FY 2011 2201270
## 653 Arizona FY 2011 8340211
## 654 Arkansas FY 2011 4578136
## 655 California FY 2011 57526835
## 656 Colorado FY 2011 7409462
## 657 Connecticut FY 2011 9094036
## 658 Delaware FY 2011 1613304
## 659 Florida FY 2011 23870090
## 660 Georgia FY 2011 15527907
## 661 Hawaii FY 2011 2141561
## 662 Idaho FY 2011 1881746
## 663 Illinois FY 2011 24554467
## 664 Indiana FY 2011 9687949
## 665 Iowa FY 2011 4855871
## 666 Kansas FY 2011 4741372
## 667 Kentucky FY 2011 6211453
## 668 Louisiana FY 2011 7522098
## 669 Maine FY 2011 2377878
## 670 Maryland FY 2011 12035719
## 671 Massachusetts FY 2011 13649965
## 672 Michigan FY 2011 16786444
## 673 Minnesota FY 2011 8944867
## 674 Mississippi FY 2011 3887981
## 675 Missouri FY 2011 8691887
## 676 Montana FY 2011 1518818
## 677 Nebraska FY 2011 3298536
## 678 Nevada FY 2011 3676997
## 679 New Hampshire FY 2011 2637911
## 680 New Jersey FY 2011 23639281
## 681 New Mexico FY 2011 3127463
## 682 New York FY 2011 51509285
## 683 North Carolina FY 2011 12322555
## 684 North Dakota FY 2011 1049772
## 685 Ohio FY 2011 19988921
## 686 Oklahoma FY 2011 5036031
## 687 Oregon FY 2011 5430888
## 688 Pennsylvania FY 2011 23485203
## 689 Rhode Island FY 2011 2149366
## 690 South Carolina FY 2011 6461884
## 691 South Dakota FY 2011 1126503
## 692 Tennessee FY 2011 8377599
## 693 Texas FY 2011 42864291
## 694 Utah FY 2011 3704133
## 695 Vermont FY 2011 1424507
## 696 Virginia FY 2011 12968457
## 697 Washington FY 2011 10040312
## 698 West Virginia FY 2011 3388294
## 699 Wisconsin FY 2011 10333016
## 700 Wyoming FY 2011 1398444