Challenge 2 Solutions

challenge_2
Tenzin Latoe
railroads
Data wrangling: using group() and summarise()
Author

Tenzin Latoe

Published

July 6, 2023

Code
library(tidyverse)
library(readxl)
knitr::opts_chunk$set(echo = TRUE, warning=FALSE, message=FALSE)

Challenge Overview

Today’s challenge is to

  1. read in a data set, and describe the data using both words and any supporting information (e.g., tables, etc)
  2. provide summary statistics for different interesting groups within the data, and interpret those statistics

Read in the Data

Read in one (or more) of the following data sets, available in the posts/_data folder, using the correct R package and command.

  • railroad*.csv or StateCounty2012.xls ⭐
Code
railroad <- read.csv("_data/railroad_2012_clean_county.csv")
railroad
     state               county total_employees
1       AE                  APO               2
2       AK            ANCHORAGE               7
3       AK FAIRBANKS NORTH STAR               2
4       AK               JUNEAU               3
5       AK    MATANUSKA-SUSITNA               2
6       AK                SITKA               1
7       AK SKAGWAY MUNICIPALITY              88
8       AL              AUTAUGA             102
9       AL              BALDWIN             143
10      AL              BARBOUR               1
11      AL                 BIBB              25
12      AL               BLOUNT             154
13      AL              BULLOCK              13
14      AL               BUTLER              29
15      AL              CALHOUN              45
16      AL             CHAMBERS              13
17      AL             CHEROKEE               9
18      AL              CHILTON              72
19      AL              CHOCTAW               7
20      AL               CLARKE              26
21      AL                 CLAY              10
22      AL             CLEBURNE               7
23      AL               COFFEE              14
24      AL              COLBERT             199
25      AL              CONECUH              11
26      AL                COOSA               5
27      AL            COVINGTON              12
28      AL             CRENSHAW               5
29      AL              CULLMAN             129
30      AL                 DALE              11
31      AL               DALLAS             122
32      AL               DEKALB              33
33      AL               ELMORE             116
34      AL             ESCAMBIA              47
35      AL               ETOWAH              78
36      AL              FAYETTE               3
37      AL             FRANKLIN              40
38      AL               GENEVA               8
39      AL               GREENE               7
40      AL                 HALE               8
41      AL                HENRY               1
42      AL              HOUSTON              46
43      AL              JACKSON              55
44      AL            JEFFERSON             990
45      AL                LAMAR              25
46      AL           LAUDERDALE             117
47      AL             LAWRENCE              11
48      AL                  LEE              46
49      AL            LIMESTONE               7
50      AL              LOWNDES               7
51      AL                MACON               6
52      AL              MADISON              29
53      AL              MARENGO              16
54      AL               MARION              17
55      AL             MARSHALL              29
56      AL               MOBILE             331
57      AL               MONROE              43
58      AL           MONTGOMERY             102
59      AL               MORGAN              42
60      AL                PERRY               4
61      AL              PICKENS              24
62      AL                 PIKE              19
63      AL             RANDOLPH              39
64      AL              RUSSELL              38
65      AL               SHELBY             158
66      AL             ST CLAIR             162
67      AL               SUMTER               9
68      AL            TALLADEGA              42
69      AL           TALLAPOOSA              19
70      AL           TUSCALOOSA              60
71      AL               WALKER             192
72      AL           WASHINGTON              11
73      AL               WILCOX              11
74      AL              WINSTON              45
75      AP                  APO               1
76      AR             ARKANSAS              11
77      AR               ASHLEY              18
78      AR               BAXTER              25
79      AR               BENTON              35
80      AR                BOONE               5
81      AR              BRADLEY               8
82      AR              CALHOUN               5
83      AR               CHICOT               3
84      AR                CLARK              40
85      AR                 CLAY              13
86      AR             CLEBURNE               8
87      AR            CLEVELAND              79
88      AR             COLUMBIA               5
89      AR               CONWAY              19
90      AR            CRAIGHEAD              61
91      AR             CRAWFORD              55
92      AR           CRITTENDEN              48
93      AR                CROSS              30
94      AR               DALLAS              12
95      AR                DESHA              15
96      AR                 DREW              34
97      AR             FAULKNER             289
98      AR             FRANKLIN               5
99      AR               FULTON              54
100     AR              GARLAND              68
101     AR                GRANT             167
102     AR               GREENE              15
103     AR            HEMPSTEAD               6
104     AR           HOT SPRING              79
105     AR               HOWARD              37
106     AR         INDEPENDENCE              32
107     AR                IZARD               4
108     AR              JACKSON              13
109     AR            JEFFERSON             361
110     AR              JOHNSON               7
111     AR            LAFAYETTE              11
112     AR             LAWRENCE              32
113     AR                  LEE               3
114     AR              LINCOLN              54
115     AR         LITTLE RIVER              22
116     AR                LOGAN               4
117     AR               LONOKE             330
118     AR              MADISON               7
119     AR               MARION               8
120     AR               MILLER              10
121     AR          MISSISSIPPI              18
122     AR               MONROE               7
123     AR           MONTGOMERY               2
124     AR               NEVADA              15
125     AR               NEWTON               1
126     AR             OUACHITA              15
127     AR                PERRY              22
128     AR             PHILLIPS              11
129     AR                 PIKE              10
130     AR             POINSETT               4
131     AR                 POLK              17
132     AR                 POPE              31
133     AR              PRAIRIE               5
134     AR              PULASKI             972
135     AR             RANDOLPH              19
136     AR               SALINE             262
137     AR                SCOTT               3
138     AR            SEBASTIAN              43
139     AR               SEVIER              50
140     AR                SHARP              20
141     AR           ST FRANCIS              16
142     AR                STONE               2
143     AR                UNION              20
144     AR            VAN BUREN               2
145     AR           WASHINGTON              46
146     AR                WHITE             102
147     AR                 YELL               9
148     AZ               APACHE             270
149     AZ              COCHISE              60
150     AZ             COCONINO             268
151     AZ                 GILA              37
152     AZ               GRAHAM              48
153     AZ             GREENLEE               3
154     AZ               LA PAZ              10
155     AZ             MARICOPA             462
156     AZ               MOHAVE             407
157     AZ               NAVAJO             510
158     AZ                 PIMA             749
159     AZ                PINAL             154
160     AZ           SANTA CRUZ              18
161     AZ              YAVAPAI              63
162     AZ                 YUMA              94
163     CA              ALAMEDA             346
164     CA               AMADOR               9
165     CA                BUTTE              69
166     CA            CALAVERAS              30
167     CA               COLUSA               2
168     CA         CONTRA COSTA             348
169     CA            EL DORADO             103
170     CA               FRESNO             341
171     CA                GLENN               4
172     CA             HUMBOLDT               2
173     CA             IMPERIAL              65
174     CA                 KERN             500
175     CA                KINGS              21
176     CA                 LAKE               2
177     CA               LASSEN              14
178     CA          LOS ANGELES            2545
179     CA               MADERA              39
180     CA                MARIN              12
181     CA             MARIPOSA               4
182     CA            MENDOCINO               6
183     CA               MERCED              59
184     CA                MODOC               3
185     CA                 MONO               1
186     CA             MONTEREY              29
187     CA                 NAPA              17
188     CA               NEVADA              36
189     CA               ORANGE             460
190     CA               PLACER             539
191     CA               PLUMAS              84
192     CA            RIVERSIDE            1567
193     CA           SACRAMENTO             738
194     CA           SAN BENITO              13
195     CA       SAN BERNARDINO            2888
196     CA            SAN DIEGO             206
197     CA        SAN FRANCISCO              61
198     CA          SAN JOAQUIN             474
199     CA      SAN LUIS OBISPO              98
200     CA            SAN MATEO              80
201     CA        SANTA BARBARA              36
202     CA          SANTA CLARA             244
203     CA           SANTA CRUZ              44
204     CA               SHASTA              69
205     CA               SIERRA               2
206     CA             SISKIYOU              83
207     CA               SOLANO             221
208     CA               SONOMA              38
209     CA           STANISLAUS             195
210     CA               SUTTER              54
211     CA               TEHAMA              10
212     CA              TRINITY               2
213     CA               TULARE              97
214     CA             TUOLUMNE               9
215     CA              VENTURA              68
216     CA                 YOLO              62
217     CA                 YUBA              88
218     CO                ADAMS             553
219     CO              ALAMOSA              10
220     CO             ARAPAHOE             128
221     CO            ARCHULETA               2
222     CO                 BACA               3
223     CO                 BENT               1
224     CO              BOULDER              71
225     CO           BROOMFIELD              42
226     CO              CHAFFEE               6
227     CO             CHEYENNE               1
228     CO          CLEAR CREEK               2
229     CO              CONEJOS               6
230     CO             COSTILLA               1
231     CO              CROWLEY               7
232     CO               CUSTER               3
233     CO                DELTA              16
234     CO               DENVER             503
235     CO              DOLORES               1
236     CO              DOUGLAS             112
237     CO                EAGLE              10
238     CO              EL PASO             129
239     CO               ELBERT              10
240     CO              FREMONT              28
241     CO             GARFIELD              13
242     CO               GILPIN               5
243     CO                GRAND              10
244     CO             GUNNISON               1
245     CO             HUERFANO              10
246     CO            JEFFERSON             267
247     CO                KIOWA               3
248     CO           KIT CARSON               2
249     CO             LA PLATA               1
250     CO                 LAKE               2
251     CO              LARIMER             159
252     CO           LAS ANIMAS              77
253     CO              LINCOLN               5
254     CO                LOGAN             137
255     CO                 MESA             252
256     CO               MOFFAT               6
257     CO            MONTEZUMA               2
258     CO             MONTROSE              10
259     CO               MORGAN              34
260     CO                OTERO             141
261     CO                 PARK              12
262     CO             PHILLIPS               4
263     CO               PITKIN               1
264     CO              PROWERS              26
265     CO               PUEBLO             526
266     CO           RIO GRANDE              10
267     CO                ROUTT              30
268     CO             SAGUACHE               2
269     CO             SEDGWICK              16
270     CO               SUMMIT               6
271     CO               TELLER               6
272     CO           WASHINGTON               3
273     CO                 WELD             223
274     CO                 YUMA               3
275     CT            FAIRFIELD             486
276     CT             HARTFORD             113
277     CT           LITCHFIELD              57
278     CT            MIDDLESEX             137
279     CT            NEW HAVEN            1561
280     CT           NEW LONDON             146
281     CT              TOLLAND              26
282     CT              WINDHAM              66
283     DC        WASHINGTON DC             279
284     DE                 KENT             158
285     DE           NEW CASTLE            1275
286     DE               SUSSEX              62
287     FL              ALACHUA              22
288     FL                BAKER              81
289     FL                  BAY              45
290     FL             BRADFORD              20
291     FL              BREVARD              33
292     FL              BROWARD             294
293     FL              CALHOUN               1
294     FL            CHARLOTTE              10
295     FL               CITRUS              23
296     FL                 CLAY             636
297     FL              COLLIER              14
298     FL             COLUMBIA              35
299     FL               DESOTO               9
300     FL                DIXIE               2
301     FL                DUVAL            3073
302     FL             ESCAMBIA             124
303     FL              FLAGLER              29
304     FL             FRANKLIN               2
305     FL              GADSDEN               5
306     FL            GILCHRIST               1
307     FL               GLADES               5
308     FL                 GULF               6
309     FL             HAMILTON              11
310     FL               HARDEE               2
311     FL               HENDRY               1
312     FL             HERNANDO              30
313     FL            HIGHLANDS              15
314     FL         HILLSBOROUGH             387
315     FL               HOLMES               6
316     FL         INDIAN RIVER              12
317     FL              JACKSON              12
318     FL            JEFFERSON               3
319     FL            LAFAYETTE               5
320     FL                 LAKE              77
321     FL                  LEE              43
322     FL                 LEON              21
323     FL                 LEVY               6
324     FL              LIBERTY               1
325     FL              MADISON               1
326     FL              MANATEE              23
327     FL               MARION              48
328     FL               MARTIN               9
329     FL           MIAMI-DADE             346
330     FL               MONROE               7
331     FL               NASSAU             242
332     FL             OKALOOSA               6
333     FL           OKEECHOBEE              12
334     FL               ORANGE             101
335     FL              OSCEOLA              30
336     FL           PALM BEACH             155
337     FL                PASCO              71
338     FL             PINELLAS              73
339     FL                 POLK             238
340     FL               PUTNAM              34
341     FL           SANTA ROSA              48
342     FL             SARASOTA              18
343     FL             SEMINOLE              92
344     FL             ST JOHNS             449
345     FL             ST LUCIE              56
346     FL               SUMTER              36
347     FL             SUWANNEE              11
348     FL               TAYLOR               5
349     FL                UNION              11
350     FL              VOLUSIA             175
351     FL              WAKULLA               4
352     FL               WALTON               3
353     FL           WASHINGTON              13
354     GA              APPLING              24
355     GA             ATKINSON              22
356     GA                BACON              56
357     GA              BALDWIN              11
358     GA                BANKS               1
359     GA               BARROW              32
360     GA               BARTOW             114
361     GA             BEN HILL             120
362     GA              BERRIEN              12
363     GA                 BIBB             304
364     GA             BLECKLEY              17
365     GA             BRANTLEY             112
366     GA               BROOKS               4
367     GA                BRYAN              95
368     GA              BULLOCH              42
369     GA                BURKE              17
370     GA                BUTTS              23
371     GA              CALHOUN               3
372     GA               CAMDEN              41
373     GA              CANDLER               4
374     GA              CARROLL             130
375     GA              CATOOSA             120
376     GA             CHARLTON              35
377     GA              CHATHAM             281
378     GA        CHATTAHOOCHEE               4
379     GA            CHATTOOGA               4
380     GA             CHEROKEE             129
381     GA               CLARKE               9
382     GA                 CLAY               2
383     GA              CLAYTON             194
384     GA               CLINCH              16
385     GA                 COBB             661
386     GA               COFFEE              85
387     GA             COLQUITT               5
388     GA             COLUMBIA              89
389     GA                 COOK               4
390     GA               COWETA             116
391     GA             CRAWFORD               6
392     GA                CRISP              12
393     GA                 DADE              31
394     GA               DAWSON               3
395     GA              DECATUR              11
396     GA               DEKALB             315
397     GA                DODGE               9
398     GA                DOOLY               6
399     GA            DOUGHERTY              43
400     GA              DOUGLAS             282
401     GA                EARLY               6
402     GA            EFFINGHAM             130
403     GA               ELBERT               1
404     GA              EMANUEL              33
405     GA                EVANS               5
406     GA               FANNIN               9
407     GA              FAYETTE             177
408     GA                FLOYD              31
409     GA              FORSYTH              40
410     GA             FRANKLIN               6
411     GA               FULTON             878
412     GA               GILMER               6
413     GA             GLASCOCK               1
414     GA                GLYNN              40
415     GA               GORDON              33
416     GA                GRADY               9
417     GA               GREENE               5
418     GA             GWINNETT             372
419     GA            HABERSHAM              12
420     GA                 HALL              55
421     GA              HANCOCK               4
422     GA             HARALSON              21
423     GA               HARRIS              37
424     GA                 HART              10
425     GA                HEARD               4
426     GA                HENRY             269
427     GA              HOUSTON              89
428     GA                IRWIN              24
429     GA              JACKSON              38
430     GA               JASPER              13
431     GA           JEFF DAVIS              12
432     GA            JEFFERSON              11
433     GA              JENKINS              17
434     GA              JOHNSON               4
435     GA                JONES              42
436     GA                LAMAR              19
437     GA               LANIER              10
438     GA              LAURENS              11
439     GA                  LEE              22
440     GA              LIBERTY              28
441     GA              LINCOLN              15
442     GA                 LONG               4
443     GA              LOWNDES              87
444     GA              LUMPKIN               2
445     GA                MACON               4
446     GA              MADISON               6
447     GA               MARION               7
448     GA             MCDUFFIE              32
449     GA             MCINTOSH               7
450     GA           MERIWETHER              78
451     GA               MILLER               2
452     GA             MITCHELL               6
453     GA               MONROE              63
454     GA           MONTGOMERY               4
455     GA               MORGAN               2
456     GA               MURRAY               6
457     GA             MUSCOGEE              84
458     GA               NEWTON               9
459     GA               OCONEE               7
460     GA           OGLETHORPE               3
461     GA             PAULDING             200
462     GA                PEACH              47
463     GA              PICKENS              16
464     GA               PIERCE             271
465     GA                 PIKE              17
466     GA                 POLK              65
467     GA              PULASKI               3
468     GA               PUTNAM              10
469     GA                RABUN               4
470     GA             RANDOLPH              12
471     GA             RICHMOND             206
472     GA             ROCKDALE              60
473     GA               SCHLEY               7
474     GA              SCREVEN               7
475     GA             SEMINOLE               2
476     GA             SPALDING              33
477     GA             STEPHENS               8
478     GA              STEWART               3
479     GA               SUMTER               9
480     GA               TALBOT              13
481     GA             TATTNALL               4
482     GA               TAYLOR              11
483     GA              TELFAIR               5
484     GA              TERRELL               9
485     GA               THOMAS              30
486     GA                 TIFT              13
487     GA               TOOMBS              28
488     GA             TREUTLEN               1
489     GA                TROUP              53
490     GA               TURNER               7
491     GA               TWIGGS              12
492     GA                UPSON              18
493     GA               WALKER              54
494     GA               WALTON             117
495     GA                 WARE             413
496     GA               WARREN               8
497     GA           WASHINGTON              34
498     GA                WAYNE              94
499     GA              WEBSTER               3
500     GA                WHITE               3
501     GA            WHITFIELD              22
502     GA               WILCOX              15
503     GA               WILKES               7
504     GA            WILKINSON              22
505     GA                WORTH              11
506     HI               HAWAII               1
507     HI             HONOLULU               2
508     HI                KAUAI               1
509     IA                ADAIR               5
510     IA                ADAMS               7
511     IA            ALLAMAKEE              18
512     IA            APPANOOSE              13
513     IA              AUDUBON               1
514     IA               BENTON              39
515     IA           BLACK HAWK             116
516     IA                BOONE             206
517     IA               BREMER              17
518     IA             BUCHANAN              35
519     IA          BUENA VISTA               2
520     IA               BUTLER              23
521     IA              CALHOUN              16
522     IA              CARROLL              38
523     IA                 CASS              13
524     IA                CEDAR              19
525     IA          CERRO GORDO             157
526     IA             CHEROKEE               2
527     IA            CHICKASAW               7
528     IA               CLARKE              16
529     IA                 CLAY               2
530     IA              CLAYTON              24
531     IA              CLINTON             140
532     IA             CRAWFORD               8
533     IA               DALLAS              46
534     IA                DAVIS              11
535     IA              DECATUR               9
536     IA             DELAWARE              18
537     IA           DES MOINES             179
538     IA            DICKINSON               2
539     IA              DUBUQUE              71
540     IA                EMMET               6
541     IA              FAYETTE              23
542     IA                FLOYD              34
543     IA             FRANKLIN              11
544     IA              FREMONT              15
545     IA               GREENE              19
546     IA               GRUNDY               9
547     IA              GUTHRIE              10
548     IA             HAMILTON              31
549     IA              HANCOCK              10
550     IA               HARDIN              20
551     IA             HARRISON             102
552     IA                HENRY              26
553     IA               HOWARD               1
554     IA             HUMBOLDT              17
555     IA                  IDA               1
556     IA                 IOWA              13
557     IA              JACKSON              26
558     IA               JASPER              24
559     IA            JEFFERSON              10
560     IA              JOHNSON              37
561     IA                JONES              14
562     IA               KEOKUK               3
563     IA              KOSSUTH               5
564     IA                  LEE             204
565     IA                 LINN             146
566     IA               LOUISA               7
567     IA                LUCAS               5
568     IA                 LYON               2
569     IA              MADISON              12
570     IA              MAHASKA               3
571     IA               MARION              14
572     IA             MARSHALL              90
573     IA                MILLS              96
574     IA             MITCHELL              15
575     IA               MONONA              12
576     IA               MONROE              14
577     IA           MONTGOMERY              19
578     IA            MUSCATINE              29
579     IA              O'BRIEN               1
580     IA              OSCEOLA               1
581     IA                 PAGE              13
582     IA            PALO ALTO               2
583     IA             PLYMOUTH              14
584     IA           POCAHONTAS               5
585     IA                 POLK             235
586     IA        POTTAWATTAMIE             609
587     IA            POWESHIEK               7
588     IA             RINGGOLD              13
589     IA                  SAC              10
590     IA                SCOTT             137
591     IA               SHELBY              12
592     IA                SIOUX               1
593     IA                STORY              94
594     IA                 TAMA              20
595     IA               TAYLOR               3
596     IA                UNION              70
597     IA            VAN BUREN               8
598     IA              WAPELLO              42
599     IA               WARREN              37
600     IA           WASHINGTON              10
601     IA                WAYNE               5
602     IA              WEBSTER              65
603     IA            WINNEBAGO               6
604     IA           WINNESHIEK               1
605     IA             WOODBURY             155
606     IA                WORTH              12
607     IA               WRIGHT              36
608     ID                  ADA              81
609     ID                ADAMS               2
610     ID              BANNOCK             538
611     ID            BEAR LAKE              71
612     ID              BENEWAH              10
613     ID              BINGHAM              47
614     ID                BOISE               3
615     ID               BONNER              40
616     ID           BONNEVILLE              44
617     ID             BOUNDARY              44
618     ID               CANYON             168
619     ID              CARIBOU              12
620     ID               CASSIA              16
621     ID           CLEARWATER               1
622     ID               CUSTER               1
623     ID               ELMORE               9
624     ID             FRANKLIN              20
625     ID              FREMONT               1
626     ID                  GEM              26
627     ID              GOODING               4
628     ID                IDAHO               4
629     ID            JEFFERSON               6
630     ID               JEROME              11
631     ID             KOOTENAI             205
632     ID                LATAH              11
633     ID                LEWIS               2
634     ID              LINCOLN               6
635     ID             MINIDOKA              32
636     ID            NEZ PERCE              13
637     ID               ONEIDA               8
638     ID               OWYHEE               7
639     ID              PAYETTE              23
640     ID                POWER              12
641     ID           TWIN FALLS              63
642     ID               VALLEY               1
643     ID           WASHINGTON              21
644     IL                ADAMS             116
645     IL            ALEXANDER               2
646     IL                 BOND              23
647     IL                BOONE              44
648     IL                BROWN               7
649     IL               BUREAU              35
650     IL              CALHOUN               4
651     IL              CARROLL              96
652     IL                 CASS              66
653     IL            CHAMPAIGN             131
654     IL            CHRISTIAN             104
655     IL                CLARK              24
656     IL                 CLAY              14
657     IL              CLINTON              38
658     IL                COLES              42
659     IL                 COOK            8207
660     IL             CRAWFORD              12
661     IL           CUMBERLAND               9
662     IL              DE WITT              46
663     IL               DEKALB             119
664     IL              DOUGLAS              60
665     IL               DUPAGE             837
666     IL              DUPAGEE              45
667     IL                EDGAR              12
668     IL              EDWARDS               4
669     IL            EFFINGHAM              33
670     IL              FAYETTE              32
671     IL                 FORD              23
672     IL             FRANKLIN              39
673     IL               FULTON              56
674     IL             GALLATIN               7
675     IL               GREENE              13
676     IL               GRUNDY              83
677     IL             HAMILTON              19
678     IL              HANCOCK             127
679     IL               HARDIN               1
680     IL            HENDERSON             100
681     IL                HENRY              74
682     IL             IROQUOIS              87
683     IL              JACKSON              37
684     IL               JASPER               4
685     IL            JEFFERSON              72
686     IL               JERSEY              14
687     IL           JO DAVIESS              14
688     IL              JOHNSON              26
689     IL                 KANE             577
690     IL             KANKAKEE             289
691     IL              KENDALL             122
692     IL                 KNOX             885
693     IL             LA SALLE             132
694     IL                 LAKE             340
695     IL             LAWRENCE               6
696     IL                  LEE              40
697     IL           LIVINGSTON              12
698     IL                LOGAN              16
699     IL                MACON             425
700     IL             MACOUPIN              79
701     IL              MADISON             427
702     IL               MARION             261
703     IL             MARSHALL              10
704     IL                MASON              23
705     IL               MASSAC               9
706     IL            MCDONOUGH              53
707     IL              MCHENRY             273
708     IL               MCLEAN              45
709     IL               MENARD              10
710     IL               MERCER              18
711     IL               MONROE             122
712     IL           MONTGOMERY              38
713     IL               MORGAN              43
714     IL             MOULTRIE              49
715     IL                 OGLE              75
716     IL               PEORIA             130
717     IL                PERRY              20
718     IL                PIATT              54
719     IL                 PIKE              50
720     IL                 POPE               1
721     IL              PULASKI               7
722     IL               PUTNAM               5
723     IL             RANDOLPH              68
724     IL             RICHLAND               9
725     IL          ROCK ISLAND              94
726     IL               SALINE              11
727     IL             SANGAMON             114
728     IL             SCHUYLER              32
729     IL                SCOTT              15
730     IL               SHELBY              45
731     IL             ST CLAIR             495
732     IL                STARK               5
733     IL           STEPHENSON              33
734     IL             TAZEWELL              71
735     IL                UNION              41
736     IL            VERMILION             178
737     IL               WABASH              14
738     IL               WARREN             188
739     IL           WASHINGTON              29
740     IL                WAYNE              18
741     IL                WHITE              16
742     IL            WHITESIDE             124
743     IL                 WILL            1784
744     IL           WILLIAMSON              53
745     IL            WINNEBAGO              76
746     IL             WOODFORD              14
747     IN                ADAMS              11
748     IN                ALLEN             536
749     IN          BARTHOLOMEW              12
750     IN               BENTON               6
751     IN            BLACKFORD              24
752     IN                BOONE              22
753     IN                BROWN               7
754     IN              CARROLL              26
755     IN                 CASS              35
756     IN                CLARK             131
757     IN                 CLAY              28
758     IN              CLINTON              28
759     IN             CRAWFORD              21
760     IN              DAVIESS              35
761     IN             DEARBORN              50
762     IN              DECATUR               7
763     IN               DEKALB             118
764     IN             DELAWARE             125
765     IN               DUBOIS              35
766     IN              ELKHART             306
767     IN              FAYETTE              19
768     IN                FLOYD              85
769     IN             FOUNTAIN              21
770     IN             FRANKLIN              10
771     IN               FULTON               8
772     IN               GIBSON             153
773     IN                GRANT              39
774     IN               GREENE              72
775     IN             HAMILTON              63
776     IN              HANCOCK              60
777     IN             HARRISON             147
778     IN            HENDRICKS             229
779     IN                HENRY              35
780     IN               HOWARD              34
781     IN           HUNTINGTON              66
782     IN              JACKSON              11
783     IN               JASPER              80
784     IN                  JAY              18
785     IN            JEFFERSON              10
786     IN             JENNINGS              13
787     IN              JOHNSON             165
788     IN                 KNOX              16
789     IN            KOSCIUSKO              30
790     IN             LAGRANGE              16
791     IN                 LAKE            1999
792     IN              LAPORTE             360
793     IN             LAPORTEE              24
794     IN             LAWRENCE              16
795     IN              MADISON              70
796     IN               MARION             703
797     IN             MARSHALL              40
798     IN               MARTIN               3
799     IN                MIAMI             146
800     IN               MONROE              27
801     IN           MONTGOMERY              30
802     IN               MORGAN             105
803     IN               NEWTON              18
804     IN                NOBLE              59
805     IN                 OHIO               5
806     IN               ORANGE               7
807     IN                 OWEN              19
808     IN                PARKE              10
809     IN                PERRY               7
810     IN                 PIKE              27
811     IN               PORTER             550
812     IN                POSEY              41
813     IN              PULASKI              11
814     IN               PUTNAM              41
815     IN             RANDOLPH              23
816     IN               RIPLEY               8
817     IN                 RUSH               7
818     IN                SCOTT              10
819     IN               SHELBY              43
820     IN              SPENCER              23
821     IN            ST JOSEPH             258
822     IN               STARKE              58
823     IN              STEUBEN              45
824     IN             SULLIVAN              34
825     IN           TIPPECANOE             118
826     IN               TIPTON              14
827     IN                UNION               7
828     IN          VANDERBURGH             221
829     IN           VERMILLION              23
830     IN                 VIGO             103
831     IN               WABASH              30
832     IN               WARREN               8
833     IN              WARRICK              82
834     IN           WASHINGTON              29
835     IN                WAYNE              12
836     IN                WELLS              39
837     IN                WHITE              23
838     IN              WHITLEY              38
839     KS                ALLEN              16
840     KS             ANDERSON              12
841     KS             ATCHISON              42
842     KS               BARBER              11
843     KS               BARTON              22
844     KS              BOURBON              47
845     KS                BROWN              14
846     KS               BUTLER              76
847     KS                CHASE              11
848     KS           CHAUTAUQUA               1
849     KS             CHEROKEE              38
850     KS                 CLAY               5
851     KS                CLOUD              14
852     KS               COFFEY              10
853     KS             COMANCHE               1
854     KS               COWLEY              94
855     KS             CRAWFORD             205
856     KS              DECATUR               3
857     KS            DICKINSON             138
858     KS             DONIPHAN              24
859     KS              DOUGLAS             126
860     KS              EDWARDS               4
861     KS                  ELK               7
862     KS                ELLIS              12
863     KS            ELLSWORTH               3
864     KS               FINNEY               9
865     KS                 FORD              22
866     KS             FRANKLIN              72
867     KS                GEARY              24
868     KS                 GRAY               1
869     KS              GREELEY               3
870     KS            GREENWOOD               3
871     KS             HAMILTON               1
872     KS               HARPER              14
873     KS               HARVEY             153
874     KS              HASKELL              19
875     KS             HODGEMAN               4
876     KS              JACKSON              56
877     KS            JEFFERSON             122
878     KS               JEWELL               1
879     KS              JOHNSON            1286
880     KS              KINGMAN              12
881     KS                KIOWA               1
882     KS              LABETTE              88
883     KS          LEAVENWORTH             232
884     KS              LINCOLN               2
885     KS                 LINN              31
886     KS                LOGAN               6
887     KS                 LYON              91
888     KS               MARION              46
889     KS             MARSHALL             233
890     KS            MCPHERSON              34
891     KS                MEADE               5
892     KS                MIAMI             113
893     KS             MITCHELL               2
894     KS           MONTGOMERY             111
895     KS               MORRIS              54
896     KS               NEMAHA              22
897     KS               NEOSHO              16
898     KS               NORTON               2
899     KS                OSAGE              73
900     KS              OSBORNE               1
901     KS               OTTAWA              12
902     KS               PAWNEE               1
903     KS             PHILLIPS              25
904     KS         POTTAWATOMIE              17
905     KS                PRATT              34
906     KS              RAWLINS               2
907     KS                 RENO              67
908     KS             REPUBLIC               2
909     KS                 RICE               7
910     KS                RILEY              30
911     KS                ROOKS               9
912     KS                 RUSH              10
913     KS              RUSSELL               1
914     KS               SALINE             107
915     KS                SCOTT               3
916     KS             SEDGWICK             325
917     KS               SEWARD              12
918     KS              SHAWNEE             856
919     KS              SHERMAN               9
920     KS                SMITH               2
921     KS             STAFFORD               3
922     KS              STANTON               1
923     KS              STEVENS               3
924     KS               SUMNER             168
925     KS               THOMAS               3
926     KS                TREGO               2
927     KS            WABAUNSEE              21
928     KS              WALLACE               9
929     KS           WASHINGTON              22
930     KS              WICHITA               2
931     KS               WILSON               4
932     KS              WOODSON               7
933     KS            WYANDOTTE             415
934     KY                ADAIR               1
935     KY                ALLEN               5
936     KY             ANDERSON               5
937     KY              BALLARD               7
938     KY               BARREN               5
939     KY                 BATH               3
940     KY                 BELL              27
941     KY                BOONE             236
942     KY              BOURBON               8
943     KY                 BOYD             232
944     KY                BOYLE              62
945     KY              BRACKEN              11
946     KY            BREATHITT              36
947     KY         BRECKINRIDGE              14
948     KY              BULLITT             125
949     KY               BUTLER               1
950     KY             CALDWELL              29
951     KY             CALLOWAY               4
952     KY             CAMPBELL              79
953     KY             CARLISLE               7
954     KY              CARROLL              19
955     KY               CARTER              54
956     KY                CASEY              18
957     KY            CHRISTIAN              15
958     KY                CLARK               6
959     KY                 CLAY               7
960     KY           CRITTENDEN               1
961     KY           CUMBERLAND               1
962     KY              DAVIESS              31
963     KY             EDMONSON               5
964     KY              ELLIOTT               1
965     KY               ESTILL              42
966     KY              FAYETTE              58
967     KY              FLEMING               9
968     KY                FLOYD              84
969     KY             FRANKLIN               5
970     KY               FULTON               4
971     KY             GALLATIN               8
972     KY              GARRARD               8
973     KY                GRANT              91
974     KY               GRAVES              24
975     KY              GRAYSON              11
976     KY                GREEN               4
977     KY              GREENUP             483
978     KY              HANCOCK               3
979     KY               HARDIN              67
980     KY               HARLAN              44
981     KY             HARRISON              15
982     KY                 HART               6
983     KY            HENDERSON              48
984     KY                HENRY              24
985     KY              HICKMAN               3
986     KY              HOPKINS             133
987     KY              JACKSON               4
988     KY            JEFFERSON             413
989     KY            JESSAMINE              13
990     KY              JOHNSON              50
991     KY               KENTON             244
992     KY                KNOTT              16
993     KY                 KNOX              38
994     KY                LARUE               7
995     KY               LAUREL             113
996     KY             LAWRENCE              97
997     KY                  LEE               8
998     KY               LESLIE               3
999     KY              LETCHER              22
1000    KY                LEWIS              55
1001    KY              LINCOLN             113
1002    KY           LIVINGSTON              11
1003    KY                LOGAN              16
1004    KY                 LYON               6
1005    KY              MADISON              47
1006    KY             MAGOFFIN               1
1007    KY               MARION               7
1008    KY             MARSHALL              22
1009    KY               MARTIN              16
1010    KY                MASON               8
1011    KY            MCCRACKEN              84
1012    KY             MCCREARY               7
1013    KY               MCLEAN               5
1014    KY                MEADE              28
1015    KY              MENIFEE               1
1016    KY               MERCER              55
1017    KY             METCALFE               1
1018    KY               MONROE               4
1019    KY           MONTGOMERY               5
1020    KY               MORGAN               1
1021    KY           MUHLENBERG              22
1022    KY               NELSON              59
1023    KY             NICHOLAS              11
1024    KY                 OHIO              16
1025    KY               OLDHAM              35
1026    KY                 OWEN               3
1027    KY               OWSLEY               2
1028    KY            PENDLETON              31
1029    KY                PERRY              39
1030    KY                 PIKE             231
1031    KY               POWELL               6
1032    KY              PULASKI             104
1033    KY            ROBERTSON               2
1034    KY           ROCKCASTLE              32
1035    KY                ROWAN               4
1036    KY              RUSSELL               5
1037    KY                SCOTT              15
1038    KY               SHELBY              33
1039    KY              SIMPSON               1
1040    KY              SPENCER              22
1041    KY               TAYLOR               2
1042    KY                 TODD              15
1043    KY                TRIGG               3
1044    KY              TRIMBLE               4
1045    KY                UNION               7
1046    KY               WARREN              12
1047    KY           WASHINGTON               3
1048    KY                WAYNE               2
1049    KY              WEBSTER              10
1050    KY              WHITLEY             322
1051    KY                WOLFE               3
1052    KY             WOODFORD               5
1053    LA               ACADIA              13
1054    LA                ALLEN              19
1055    LA            ASCENSION             103
1056    LA           ASSUMPTION               5
1057    LA            AVOYELLES              37
1058    LA           BEAUREGARD              43
1059    LA            BIENVILLE              21
1060    LA              BOSSIER             285
1061    LA                CADDO             546
1062    LA            CALCASIEU             280
1063    LA             CALDWELL               7
1064    LA              CAMERON               1
1065    LA            CATAHOULA               1
1066    LA            CLAIBORNE              31
1067    LA            CONCORDIA               3
1068    LA              DE SOTO              40
1069    LA     EAST BATON ROUGE             285
1070    LA         EAST CARROLL               1
1071    LA       EAST FELICIANA              11
1072    LA           EVANGELINE              11
1073    LA             FRANKLIN               4
1074    LA                GRANT              25
1075    LA               IBERIA              25
1076    LA            IBERVILLE              86
1077    LA              JACKSON              20
1078    LA            JEFFERSON             368
1079    LA      JEFFERSON DAVIS               6
1080    LA             LA SALLE               5
1081    LA            LAFAYETTE             124
1082    LA            LAFOURCHE              10
1083    LA              LINCOLN              16
1084    LA           LIVINGSTON              78
1085    LA              MADISON              10
1086    LA            MOREHOUSE              19
1087    LA         NATCHITOCHES              22
1088    LA              ORLEANS             240
1089    LA             OUACHITA             128
1090    LA          PLAQUEMINES              17
1091    LA        POINTE COUPEE              67
1092    LA              RAPIDES             158
1093    LA            RED RIVER               6
1094    LA             RICHLAND               2
1095    LA               SABINE               8
1096    LA           ST BERNARD              35
1097    LA           ST CHARLES              46
1098    LA             ST JAMES              11
1099    LA  ST JOHN THE BAPTIST              38
1100    LA            ST LANDRY              91
1101    LA            ST MARTIN              31
1102    LA              ST MARY               2
1103    LA           ST TAMMANY             128
1104    LA           TANGIPAHOA             105
1105    LA               TENSAS               1
1106    LA           TERREBONNE              14
1107    LA                UNION               8
1108    LA            VERMILION               5
1109    LA               VERNON              42
1110    LA           WASHINGTON              20
1111    LA              WEBSTER              68
1112    LA     WEST BATON ROUGE              73
1113    LA         WEST CARROLL               3
1114    LA       WEST FELICIANA               5
1115    LA                 WINN               2
1116    MA           BARNSTABLE              44
1117    MA            BERKSHIRE              50
1118    MA              BRISTOL             232
1119    MA                ESSEX             314
1120    MA             FRANKLIN             113
1121    MA              HAMPDEN             202
1122    MA            HAMPSHIRE              68
1123    MA            MIDDLESEX             673
1124    MA              NORFOLK             386
1125    MA             PLYMOUTH             429
1126    MA              SUFFOLK             558
1127    MA            WORCESTER             310
1128    MD             ALLEGANY             509
1129    MD         ANNE ARUNDEL             406
1130    MD            BALTIMORE             415
1131    MD              CALVERT             103
1132    MD             CAROLINE               8
1133    MD              CARROLL             118
1134    MD                CECIL             393
1135    MD              CHARLES             112
1136    MD           DORCHESTER               8
1137    MD            FREDERICK             157
1138    MD              GARRETT              53
1139    MD              HARFORD             248
1140    MD               HOWARD              79
1141    MD     INDEPENDENT CITY             722
1142    MD                 KENT               3
1143    MD           MONTGOMERY             302
1144    MD       PRINCE GEORGES             809
1145    MD          QUEEN ANNES              22
1146    MD             SOMERSET               1
1147    MD             ST MARYS              94
1148    MD               TALBOT               2
1149    MD           WASHINGTON             127
1150    MD             WICOMICO              12
1151    MD            WORCESTER               6
1152    ME         ANDROSCOGGIN              22
1153    ME            AROOSTOOK              57
1154    ME           CUMBERLAND              71
1155    ME             FRANKLIN               2
1156    ME              HANCOCK               3
1157    ME             KENNEBEC             109
1158    ME                 KNOX               5
1159    ME              LINCOLN               7
1160    ME               OXFORD              36
1161    ME            PENOBSCOT             117
1162    ME          PISCATAQUIS              75
1163    ME            SAGADAHOC               8
1164    ME             SOMERSET              67
1165    ME                WALDO              11
1166    ME           WASHINGTON              17
1167    ME                 YORK              47
1168    MI               ALCONA               1
1169    MI                ALGER               8
1170    MI              ALLEGAN              27
1171    MI               ALPENA               3
1172    MI               ARENAC              19
1173    MI               BARAGA               4
1174    MI                BARRY              16
1175    MI                  BAY              58
1176    MI               BENZIE               2
1177    MI              BERRIEN             136
1178    MI               BRANCH              13
1179    MI              CALHOUN             164
1180    MI                 CASS              89
1181    MI            CHEBOYGAN               2
1182    MI             CHIPPEWA               8
1183    MI                CLARE               5
1184    MI              CLINTON              10
1185    MI             CRAWFORD               1
1186    MI                DELTA             188
1187    MI            DICKINSON               7
1188    MI                EATON              42
1189    MI                EMMET               1
1190    MI              GENESEE             195
1191    MI              GLADWIN               4
1192    MI              GOGEBIC               3
1193    MI       GRAND TRAVERSE               4
1194    MI              GRATIOT               5
1195    MI            HILLSDALE              17
1196    MI             HOUGHTON               6
1197    MI                HURON               9
1198    MI               INGHAM              46
1199    MI                IONIA              32
1200    MI                IOSCO              13
1201    MI                 IRON               3
1202    MI             ISABELLA               5
1203    MI              JACKSON              77
1204    MI            KALAMAZOO              58
1205    MI             KALKASKA               3
1206    MI                 KENT             149
1207    MI                 LAKE               1
1208    MI               LAPEER              36
1209    MI             LEELANAU               3
1210    MI              LENAWEE              70
1211    MI           LIVINGSTON              33
1212    MI                 LUCE               2
1213    MI             MACKINAC               2
1214    MI               MACOMB             170
1215    MI             MANISTEE              12
1216    MI            MARQUETTE             137
1217    MI                MASON              17
1218    MI              MECOSTA               5
1219    MI            MENOMINEE              14
1220    MI              MIDLAND               5
1221    MI               MONROE             266
1222    MI             MONTCALM              17
1223    MI             MUSKEGON              24
1224    MI              NEWAYGO              15
1225    MI              OAKLAND             265
1226    MI               OCEANA               1
1227    MI               OGEMAW               6
1228    MI            ONTONAGON              11
1229    MI              OSCEOLA               2
1230    MI               OSCODA               1
1231    MI               OTSEGO               1
1232    MI               OTTAWA              40
1233    MI         PRESQUE ISLE               1
1234    MI            ROSCOMMON               2
1235    MI              SAGINAW              80
1236    MI              SANILAC              14
1237    MI          SCHOOLCRAFT              13
1238    MI           SHIAWASSEE             100
1239    MI             ST CLAIR             109
1240    MI            ST JOSEPH              42
1241    MI              TUSCOLA              38
1242    MI            VAN BUREN              27
1243    MI            WASHTENAW              63
1244    MI                WAYNE             849
1245    MI              WEXFORD               5
1246    MN               AITKIN              19
1247    MN                ANOKA             346
1248    MN               BECKER              62
1249    MN             BELTRAMI              10
1250    MN               BENTON              20
1251    MN            BIG STONE              10
1252    MN           BLUE EARTH              59
1253    MN                BROWN              25
1254    MN              CARLTON             181
1255    MN               CARVER              41
1256    MN                 CASS              20
1257    MN             CHIPPEWA               6
1258    MN              CHISAGO              91
1259    MN                 CLAY             175
1260    MN           CLEARWATER               9
1261    MN           COTTONWOOD               4
1262    MN            CROW WING             143
1263    MN               DAKOTA             348
1264    MN                DODGE               1
1265    MN              DOUGLAS              44
1266    MN            FARIBAULT               8
1267    MN             FILLMORE               4
1268    MN             FREEBORN              24
1269    MN              GOODHUE              35
1270    MN                GRANT               3
1271    MN             HENNEPIN             651
1272    MN              HOUSTON              42
1273    MN              HUBBARD              14
1274    MN               ISANTI              57
1275    MN               ITASCA              37
1276    MN              JACKSON               7
1277    MN              KANABEC              10
1278    MN            KANDIYOHI             157
1279    MN              KITTSON               4
1280    MN          KOOCHICHING              43
1281    MN        LAC QUI PARLE               2
1282    MN                 LAKE              68
1283    MN    LAKE OF THE WOODS               6
1284    MN             LE SUEUR              27
1285    MN              LINCOLN               4
1286    MN                 LYON              10
1287    MN             MAHNOMEN               7
1288    MN             MARSHALL              13
1289    MN               MARTIN               3
1290    MN               MCLEOD              46
1291    MN               MEEKER              32
1292    MN           MILLE LACS              34
1293    MN             MORRISON              43
1294    MN                MOWER              20
1295    MN               MURRAY               3
1296    MN             NICOLLET               6
1297    MN               NOBLES               6
1298    MN               NORMAN               9
1299    MN              OLMSTED              18
1300    MN           OTTER TAIL              54
1301    MN           PENNINGTON              62
1302    MN                 PINE              35
1303    MN            PIPESTONE               5
1304    MN                 POLK             106
1305    MN                 POPE              43
1306    MN               RAMSEY             579
1307    MN             RED LAKE              10
1308    MN              REDWOOD               9
1309    MN             RENVILLE              13
1310    MN                 RICE              37
1311    MN                 ROCK               9
1312    MN               ROSEAU               4
1313    MN                SCOTT              72
1314    MN            SHERBURNE             148
1315    MN               SIBLEY              11
1316    MN             ST LOUIS             595
1317    MN              STEARNS             100
1318    MN               STEELE              16
1319    MN              STEVENS               9
1320    MN                SWIFT              16
1321    MN                 TODD              28
1322    MN             TRAVERSE               2
1323    MN              WABASHA              13
1324    MN               WADENA               9
1325    MN               WASECA              49
1326    MN           WASHINGTON             207
1327    MN             WATONWAN              32
1328    MN               WILKIN              34
1329    MN               WINONA              26
1330    MN               WRIGHT              62
1331    MN      YELLOW MEDICINE               5
1332    MO                ADAIR              21
1333    MO               ANDREW              17
1334    MO             ATCHISON               5
1335    MO              AUDRAIN              25
1336    MO                BARRY              17
1337    MO               BARTON              26
1338    MO                BATES              12
1339    MO               BENTON              29
1340    MO            BOLLINGER              12
1341    MO                BOONE              52
1342    MO             BUCHANAN             150
1343    MO               BUTLER              84
1344    MO             CALDWELL              38
1345    MO             CALLAWAY              15
1346    MO               CAMDEN              11
1347    MO       CAPE GIRARDEAU              86
1348    MO              CARROLL              23
1349    MO               CARTER              20
1350    MO                 CASS             235
1351    MO                CEDAR              10
1352    MO             CHARITON              50
1353    MO            CHRISTIAN             112
1354    MO                CLARK              29
1355    MO                 CLAY             681
1356    MO              CLINTON              97
1357    MO                 COLE              46
1358    MO               COOPER              60
1359    MO             CRAWFORD              17
1360    MO                 DADE              19
1361    MO               DALLAS               8
1362    MO              DAVIESS              21
1363    MO               DEKALB              36
1364    MO                 DENT               2
1365    MO              DOUGLAS               1
1366    MO              DUNKLIN              24
1367    MO             FRANKLIN              54
1368    MO            GASCONADE              14
1369    MO               GENTRY               5
1370    MO               GREENE             362
1371    MO               GRUNDY              23
1372    MO             HARRISON              19
1373    MO                HENRY              20
1374    MO              HICKORY               3
1375    MO                 HOLT              16
1376    MO               HOWARD               7
1377    MO               HOWELL              87
1378    MO     INDEPENDENT CITY             226
1379    MO                 IRON              13
1380    MO              JACKSON            2055
1381    MO               JASPER             127
1382    MO            JEFFERSON             436
1383    MO              JOHNSON              42
1384    MO                 KNOX              16
1385    MO              LACLEDE              18
1386    MO            LAFAYETTE              74
1387    MO             LAWRENCE              64
1388    MO                LEWIS              20
1389    MO              LINCOLN              18
1390    MO                 LINN             140
1391    MO           LIVINGSTON              44
1392    MO                MACON              47
1393    MO              MADISON              30
1394    MO               MARIES               1
1395    MO               MARION              93
1396    MO             MCDONALD               5
1397    MO               MERCER               9
1398    MO               MILLER              15
1399    MO          MISSISSIPPI               1
1400    MO             MONITEAU              24
1401    MO               MONROE              24
1402    MO           MONTGOMERY               9
1403    MO               MORGAN              24
1404    MO           NEW MADRID              10
1405    MO               NEWTON              38
1406    MO              NODAWAY               7
1407    MO               OREGON             132
1408    MO                OSAGE              12
1409    MO                OZARK               5
1410    MO             PEMISCOT               3
1411    MO                PERRY              29
1412    MO               PETTIS              95
1413    MO               PHELPS              18
1414    MO                 PIKE              33
1415    MO               PLATTE              98
1416    MO                 POLK              38
1417    MO              PULASKI               5
1418    MO               PUTNAM               1
1419    MO                RALLS              23
1420    MO             RANDOLPH             138
1421    MO                  RAY             126
1422    MO             REYNOLDS               5
1423    MO               RIPLEY              48
1424    MO     SAINTE GENEVIEVE              27
1425    MO               SALINE              27
1426    MO             SCHUYLER               8
1427    MO             SCOTLAND               1
1428    MO                SCOTT             126
1429    MO              SHANNON              10
1430    MO               SHELBY              12
1431    MO           ST CHARLES             166
1432    MO             ST CLAIR               8
1433    MO          ST FRANCOIS             202
1434    MO             ST LOUIS             316
1435    MO             STODDARD              47
1436    MO                STONE              20
1437    MO             SULLIVAN               6
1438    MO                TANEY              19
1439    MO                TEXAS              34
1440    MO               VERNON              25
1441    MO               WARREN               8
1442    MO           WASHINGTON              50
1443    MO                WAYNE              38
1444    MO              WEBSTER              86
1445    MO                WORTH               3
1446    MO               WRIGHT              40
1447    MS                ADAMS               3
1448    MS               ALCORN              45
1449    MS                AMITE              16
1450    MS               ATTALA              33
1451    MS               BENTON              12
1452    MS              CARROLL              14
1453    MS            CHICKASAW              11
1454    MS              CHOCTAW               6
1455    MS            CLAIBORNE               3
1456    MS               CLARKE              15
1457    MS                 CLAY              10
1458    MS              COAHOMA               1
1459    MS               COPIAH              16
1460    MS            COVINGTON               8
1461    MS               DESOTO             341
1462    MS              FORREST              64
1463    MS             FRANKLIN              12
1464    MS               GEORGE              21
1465    MS               GREENE               2
1466    MS              GRENADA              15
1467    MS              HANCOCK              57
1468    MS             HARRISON              46
1469    MS                HINDS             130
1470    MS               HOLMES              23
1471    MS            HUMPHREYS               3
1472    MS            ISSAQUENA               1
1473    MS             ITAWAMBA               7
1474    MS              JACKSON              42
1475    MS               JASPER              10
1476    MS            JEFFERSON               4
1477    MS                JONES              10
1478    MS               KEMPER               6
1479    MS            LAFAYETTE               5
1480    MS                LAMAR              27
1481    MS           LAUDERDALE             169
1482    MS             LAWRENCE              15
1483    MS                LEAKE               6
1484    MS                  LEE              23
1485    MS              LEFLORE               1
1486    MS              LINCOLN              46
1487    MS              LOWNDES              79
1488    MS              MADISON              45
1489    MS               MARION              24
1490    MS             MARSHALL              50
1491    MS               MONROE              65
1492    MS           MONTGOMERY              15
1493    MS              NESHOBA               3
1494    MS               NEWTON              47
1495    MS              NOXUBEE               8
1496    MS            OKTIBBEHA              10
1497    MS               PANOLA              13
1498    MS          PEARL RIVER              67
1499    MS                PERRY              11
1500    MS                 PIKE              56
1501    MS             PONTOTOC               3
1502    MS             PRENTISS               1
1503    MS              QUITMAN               5
1504    MS               RANKIN             104
1505    MS                SCOTT              12
1506    MS              SHARKEY               1
1507    MS              SIMPSON              15
1508    MS                STONE               8
1509    MS            SUNFLOWER               2
1510    MS         TALLAHATCHIE               3
1511    MS                 TATE              36
1512    MS               TIPPAH               8
1513    MS           TISHOMINGO              10
1514    MS               TUNICA               3
1515    MS                UNION               8
1516    MS             WALTHALL               5
1517    MS               WARREN              49
1518    MS           WASHINGTON               4
1519    MS                WAYNE              18
1520    MS              WEBSTER               6
1521    MS            WILKINSON               5
1522    MS              WINSTON              16
1523    MS            YALOBUSHA              10
1524    MS                YAZOO               7
1525    MT           BEAVERHEAD               8
1526    MT             BIG HORN               5
1527    MT               BLAINE              32
1528    MT           BROADWATER               4
1529    MT               CARBON              40
1530    MT              CASCADE             199
1531    MT             CHOUTEAU               9
1532    MT               CUSTER              61
1533    MT              DANIELS               2
1534    MT               DAWSON             301
1535    MT           DEER LODGE              18
1536    MT               FALLON               4
1537    MT               FERGUS              11
1538    MT             FLATHEAD             367
1539    MT             GALLATIN              30
1540    MT              GLACIER              29
1541    MT        GOLDEN VALLEY               2
1542    MT              GRANITE               8
1543    MT                 HILL             513
1544    MT            JEFFERSON               8
1545    MT         JUDITH BASIN               2
1546    MT                 LAKE              46
1547    MT      LEWIS AND CLARK              83
1548    MT              LIBERTY               9
1549    MT              LINCOLN              31
1550    MT              MADISON               1
1551    MT               MCCONE               1
1552    MT              MEAGHER               1
1553    MT              MINERAL              14
1554    MT             MISSOULA             362
1555    MT          MUSSELSHELL               3
1556    MT                 PARK              64
1557    MT             PHILLIPS               9
1558    MT              PONDERA              25
1559    MT         POWDER RIVER               3
1560    MT               POWELL               9
1561    MT              PRAIRIE              11
1562    MT              RAVALLI              49
1563    MT             RICHLAND              26
1564    MT            ROOSEVELT               9
1565    MT              ROSEBUD              84
1566    MT              SANDERS              37
1567    MT             SHERIDAN               7
1568    MT           SILVER BOW              20
1569    MT           STILLWATER              52
1570    MT          SWEET GRASS               7
1571    MT                TETON               5
1572    MT                TOOLE              28
1573    MT             TREASURE               2
1574    MT               VALLEY             143
1575    MT            WHEATLAND               1
1576    MT               WIBAUX               7
1577    MT          YELLOWSTONE             525
1578    NC             ALAMANCE              14
1579    NC            ALEXANDER              10
1580    NC            ALLEGHANY               1
1581    NC                ANSON              12
1582    NC                 ASHE               3
1583    NC                AVERY               4
1584    NC             BEAUFORT               4
1585    NC               BLADEN               7
1586    NC            BRUNSWICK              22
1587    NC             BUNCOMBE              94
1588    NC                BURKE              15
1589    NC             CABARRUS              84
1590    NC             CALDWELL               5
1591    NC               CAMDEN              10
1592    NC             CARTERET               5
1593    NC              CASWELL               7
1594    NC              CATAWBA              22
1595    NC              CHATHAM               3
1596    NC             CHEROKEE               8
1597    NC               CHOWAN               2
1598    NC                 CLAY               1
1599    NC            CLEVELAND              12
1600    NC             COLUMBUS              17
1601    NC               CRAVEN              14
1602    NC           CUMBERLAND              39
1603    NC            CURRITUCK              29
1604    NC                 DARE               3
1605    NC             DAVIDSON              90
1606    NC                DAVIE              28
1607    NC               DUPLIN               4
1608    NC               DURHAM              24
1609    NC            EDGECOMBE               7
1610    NC              FORSYTH              77
1611    NC             FRANKLIN               5
1612    NC               GASTON              55
1613    NC                GATES               6
1614    NC               GRAHAM               2
1615    NC            GRANVILLE               8
1616    NC             GUILFORD              78
1617    NC              HALIFAX              36
1618    NC              HARNETT              15
1619    NC              HAYWOOD              21
1620    NC            HENDERSON              32
1621    NC             HERTFORD               3
1622    NC                 HOKE               4
1623    NC              IREDELL              48
1624    NC              JACKSON               8
1625    NC             JOHNSTON              56
1626    NC                  LEE               8
1627    NC               LENOIR               5
1628    NC              LINCOLN              19
1629    NC              MADISON              66
1630    NC               MARTIN               4
1631    NC             MCDOWELL              26
1632    NC          MECKLENBURG             224
1633    NC             MITCHELL              13
1634    NC           MONTGOMERY              22
1635    NC                MOORE              41
1636    NC                 NASH             205
1637    NC          NEW HANOVER              45
1638    NC          NORTHAMPTON              15
1639    NC               ONSLOW               4
1640    NC               ORANGE              15
1641    NC              PAMLICO               1
1642    NC           PASQUOTANK              16
1643    NC               PENDER              18
1644    NC           PERQUIMANS               2
1645    NC               PERSON               2
1646    NC                 PITT              19
1647    NC                 POLK               5
1648    NC             RANDOLPH              18
1649    NC             RICHMOND             291
1650    NC              ROBESON             122
1651    NC           ROCKINGHAM              12
1652    NC                ROWAN             228
1653    NC           RUTHERFORD              30
1654    NC              SAMPSON               5
1655    NC             SCOTLAND              30
1656    NC               STANLY              49
1657    NC               STOKES               9
1658    NC                SURRY              30
1659    NC                SWAIN               3
1660    NC         TRANSYLVANIA               4
1661    NC                UNION              50
1662    NC                VANCE               4
1663    NC                 WAKE             322
1664    NC               WARREN               6
1665    NC           WASHINGTON               6
1666    NC              WATAUGA               1
1667    NC                WAYNE              15
1668    NC               WILKES               1
1669    NC               WILSON              49
1670    NC               YADKIN               6
1671    NC               YANCEY              23
1672    ND                ADAMS               2
1673    ND               BARNES              25
1674    ND               BENSON               2
1675    ND            BOTTINEAU               6
1676    ND               BOWMAN               1
1677    ND                BURKE               7
1678    ND             BURLEIGH             317
1679    ND                 CASS             373
1680    ND             CAVALIER               2
1681    ND               DICKEY              11
1682    ND               DIVIDE              12
1683    ND                 DUNN               1
1684    ND                 EDDY               7
1685    ND               EMMONS               2
1686    ND               FOSTER              14
1687    ND        GOLDEN VALLEY               4
1688    ND          GRAND FORKS             173
1689    ND                GRANT               5
1690    ND               GRIGGS               2
1691    ND            HETTINGER               1
1692    ND               KIDDER               9
1693    ND              LAMOURE               5
1694    ND                LOGAN               2
1695    ND              MCHENRY              78
1696    ND             MCINTOSH              10
1697    ND             MCKENZIE               1
1698    ND               MCLEAN              34
1699    ND               MORTON             191
1700    ND            MOUNTRAIL              14
1701    ND               NELSON               6
1702    ND               OLIVER               2
1703    ND              PEMBINA               4
1704    ND               PIERCE               9
1705    ND               RAMSEY              14
1706    ND               RANSOM              70
1707    ND             RENVILLE               8
1708    ND             RICHLAND              58
1709    ND              ROLETTE               6
1710    ND              SARGENT               3
1711    ND             SHERIDAN               8
1712    ND                SIOUX               1
1713    ND                SLOPE               2
1714    ND                STARK              34
1715    ND             STUTSMAN              48
1716    ND               TRAILL              11
1717    ND                WALSH              76
1718    ND                 WARD             407
1719    ND                WELLS             101
1720    ND             WILLIAMS              25
1721    NE                ADAMS              77
1722    NE             ANTELOPE               2
1723    NE               ARTHUR               2
1724    NE               BANNER               8
1725    NE               BLAINE               2
1726    NE                BOONE               2
1727    NE            BOX BUTTE            1168
1728    NE                BROWN               1
1729    NE              BUFFALO             107
1730    NE                 BURT               9
1731    NE               BUTLER              40
1732    NE                 CASS             192
1733    NE                CEDAR               8
1734    NE                CHASE               2
1735    NE               CHERRY               1
1736    NE             CHEYENNE              68
1737    NE                 CLAY              13
1738    NE               COLFAX               4
1739    NE               CUMING               4
1740    NE               CUSTER              82
1741    NE               DAKOTA              35
1742    NE                DAWES             120
1743    NE               DAWSON             142
1744    NE                DEUEL              13
1745    NE                DIXON               5
1746    NE                DODGE              78
1747    NE              DOUGLAS            3797
1748    NE                DUNDY               5
1749    NE             FILLMORE              13
1750    NE             FRANKLIN               3
1751    NE             FRONTIER              30
1752    NE               FURNAS              18
1753    NE                 GAGE             152
1754    NE               GARDEN              21
1755    NE               GOSPER               9
1756    NE                GRANT               8
1757    NE              GREELEY               3
1758    NE                 HALL             135
1759    NE             HAMILTON              14
1760    NE               HARLAN               4
1761    NE                HAYES               3
1762    NE            HITCHCOCK              15
1763    NE                 HOLT               3
1764    NE               HOOKER              17
1765    NE               HOWARD              21
1766    NE            JEFFERSON              42
1767    NE              JOHNSON              30
1768    NE              KEARNEY               6
1769    NE                KEITH              98
1770    NE              KIMBALL              24
1771    NE                 KNOX               9
1772    NE            LANCASTER            1619
1773    NE              LINCOLN            2289
1774    NE                LOGAN              35
1775    NE                 LOUP               1
1776    NE              MADISON              45
1777    NE            MCPHERSON              19
1778    NE              MERRICK              14
1779    NE              MORRILL             112
1780    NE                NANCE               1
1781    NE               NEMAHA              12
1782    NE             NUCKOLLS               8
1783    NE                 OTOE              71
1784    NE               PAWNEE               7
1785    NE              PERKINS              20
1786    NE               PHELPS               7
1787    NE               PIERCE               7
1788    NE               PLATTE              92
1789    NE                 POLK               8
1790    NE           RED WILLOW             124
1791    NE           RICHARDSON              66
1792    NE                 ROCK               1
1793    NE               SALINE              41
1794    NE                SARPY             840
1795    NE             SAUNDERS             123
1796    NE         SCOTTS BLUFF             614
1797    NE               SEWARD             114
1798    NE             SHERIDAN              49
1799    NE              SHERMAN              18
1800    NE                SIOUX               1
1801    NE              STANTON              11
1802    NE               THAYER              22
1803    NE               THOMAS               5
1804    NE             THURSTON               1
1805    NE               VALLEY              13
1806    NE           WASHINGTON              75
1807    NE                WAYNE               3
1808    NE              WEBSTER               5
1809    NE                 YORK              18
1810    NH              BELKNAP               2
1811    NH              CARROLL              12
1812    NH             CHESHIRE              28
1813    NH                 COOS              19
1814    NH              GRAFTON               7
1815    NH         HILLSBOROUGH             136
1816    NH            MERRIMACK               9
1817    NH           ROCKINGHAM             146
1818    NH            STRAFFORD              27
1819    NH             SULLIVAN               7
1820    NJ             ATLANTIC              58
1821    NJ               BERGEN             513
1822    NJ           BURLINGTON             464
1823    NJ               CAMDEN             427
1824    NJ             CAPE MAY              19
1825    NJ           CUMBERLAND              39
1826    NJ                ESSEX            1097
1827    NJ           GLOUCESTER             270
1828    NJ               HUDSON             871
1829    NJ            HUNTERDON              68
1830    NJ               MERCER             361
1831    NJ            MIDDLESEX             955
1832    NJ             MONMOUTH             862
1833    NJ               MORRIS             296
1834    NJ                OCEAN             589
1835    NJ              PASSAIC             231
1836    NJ                SALEM              30
1837    NJ             SOMERSET             148
1838    NJ               SUSSEX             178
1839    NJ                UNION             738
1840    NJ               WARREN             115
1841    NM           BERNALILLO             227
1842    NM               CATRON               4
1843    NM               CHAVES              14
1844    NM               CIBOLA              27
1845    NM               COLFAX              25
1846    NM                CURRY             431
1847    NM              DE BACA               7
1848    NM             DONA ANA              91
1849    NM                 EDDY              43
1850    NM                GRANT              13
1851    NM            GUADALUPE               8
1852    NM              HIDALGO              11
1853    NM                  LEA               4
1854    NM              LINCOLN               7
1855    NM                 LUNA              41
1856    NM             MCKINLEY             240
1857    NM                OTERO              45
1858    NM                 QUAY              42
1859    NM           RIO ARRIBA               2
1860    NM            ROOSEVELT              58
1861    NM             SAN JUAN              56
1862    NM           SAN MIGUEL               6
1863    NM             SANDOVAL              80
1864    NM             SANTA FE              26
1865    NM               SIERRA               3
1866    NM              SOCORRO              12
1867    NM             TORRANCE              29
1868    NM                UNION               5
1869    NM             VALENCIA             401
1870    NV            CHURCHILL               5
1871    NV                CLARK             269
1872    NV                 ELKO              77
1873    NV             HUMBOLDT              47
1874    NV     INDEPENDENT CITY               8
1875    NV               LANDER               5
1876    NV              LINCOLN              26
1877    NV                 LYON              42
1878    NV                  NYE              12
1879    NV             PERSHING               5
1880    NV               STOREY               1
1881    NV               WASHOE             249
1882    NY               ALBANY             629
1883    NY             ALLEGANY              55
1884    NY                BRONX             648
1885    NY               BROOME             141
1886    NY          CATTARAUGUS              72
1887    NY               CAYUGA              36
1888    NY           CHAUTAUQUA              57
1889    NY              CHEMUNG              21
1890    NY             CHENANGO              39
1891    NY              CLINTON              24
1892    NY             COLUMBIA             126
1893    NY             CORTLAND              11
1894    NY             DELAWARE              25
1895    NY             DUTCHESS            1157
1896    NY                 ERIE             784
1897    NY                ESSEX              27
1898    NY             FRANKLIN              11
1899    NY               FULTON              20
1900    NY              GENESEE              46
1901    NY               GREENE             196
1902    NY             HERKIMER              48
1903    NY            JEFFERSON              19
1904    NY                KINGS             970
1905    NY                LEWIS               5
1906    NY           LIVINGSTON              71
1907    NY              MADISON              43
1908    NY               MONROE             131
1909    NY           MONTGOMERY              36
1910    NY               NASSAU            2076
1911    NY             NEW YORK             373
1912    NY              NIAGARA             119
1913    NY               ONEIDA              72
1914    NY             ONONDAGA             184
1915    NY              ONTARIO              33
1916    NY               ORANGE             342
1917    NY              ORLEANS              11
1918    NY               OSWEGO              91
1919    NY               OTSEGO              89
1920    NY               PUTNAM             317
1921    NY               QUEENS            1470
1922    NY           RENSSELAER             358
1923    NY             RICHMOND             177
1924    NY             ROCKLAND              89
1925    NY             SARATOGA             233
1926    NY          SCHENECTADY             149
1927    NY            SCHOHARIE              43
1928    NY             SCHUYLER               7
1929    NY               SENECA              13
1930    NY          ST LAWRENCE              79
1931    NY              STEUBEN              99
1932    NY              SUFFOLK            3685
1933    NY             SULLIVAN              14
1934    NY                TIOGA              32
1935    NY             TOMPKINS               8
1936    NY               ULSTER             211
1937    NY               WARREN              26
1938    NY           WASHINGTON              60
1939    NY                WAYNE              46
1940    NY          WESTCHESTER            1040
1941    NY              WYOMING              50
1942    NY                YATES               6
1943    OH                ADAMS              24
1944    OH                ALLEN              92
1945    OH              ASHLAND              56
1946    OH            ASHTABULA             270
1947    OH               ATHENS              21
1948    OH             AUGLAIZE              23
1949    OH              BELMONT              22
1950    OH                BROWN              14
1951    OH               BUTLER             220
1952    OH              CARROLL              25
1953    OH            CHAMPAIGN              28
1954    OH                CLARK              23
1955    OH             CLERMONT              68
1956    OH              CLINTON              25
1957    OH           COLUMBIANA             211
1958    OH            COSHOCTON              87
1959    OH             CRAWFORD             112
1960    OH             CUYAHOGA             552
1961    OH                DARKE              16
1962    OH             DEFIANCE              33
1963    OH             DELAWARE              58
1964    OH                 ERIE             213
1965    OH            FAIRFIELD              53
1966    OH              FAYETTE              18
1967    OH             FRANKLIN             359
1968    OH               FULTON              60
1969    OH               GALLIA              19
1970    OH               GEAUGA              29
1971    OH               GREENE              19
1972    OH             GUERNSEY              16
1973    OH             HAMILTON             278
1974    OH              HANCOCK              71
1975    OH               HARDIN              22
1976    OH             HARRISON              26
1977    OH                HENRY              38
1978    OH             HIGHLAND              15
1979    OH              HOCKING               9
1980    OH               HOLMES               4
1981    OH                HURON             674
1982    OH              JACKSON              14
1983    OH            JEFFERSON             108
1984    OH                 KNOX              17
1985    OH                 LAKE             114
1986    OH             LAWRENCE             305
1987    OH              LICKING              49
1988    OH                LOGAN              54
1989    OH               LORAIN             280
1990    OH                LUCAS             842
1991    OH              MADISON              20
1992    OH             MAHONING             176
1993    OH               MARION              60
1994    OH               MEDINA             117
1995    OH                MEIGS              20
1996    OH               MERCER               8
1997    OH                MIAMI              24
1998    OH               MONROE               4
1999    OH           MONTGOMERY              83
2000    OH               MORGAN               3
2001    OH               MORROW              21
2002    OH            MUSKINGUM              29
2003    OH                NOBLE               3
2004    OH               OTTAWA             151
2005    OH             PAULDING              18
2006    OH                PERRY              12
2007    OH             PICKAWAY              40
2008    OH                 PIKE              39
2009    OH              PORTAGE              51
2010    OH               PREBLE              12
2011    OH               PUTNAM              58
2012    OH             RICHLAND             251
2013    OH                 ROSS              40
2014    OH             SANDUSKY             129
2015    OH               SCIOTO             451
2016    OH               SENECA             175
2017    OH               SHELBY              21
2018    OH                STARK             335
2019    OH               SUMMIT             140
2020    OH             TRUMBULL             121
2021    OH           TUSCARAWAS             133
2022    OH                UNION              54
2023    OH             VAN WERT              16
2024    OH               VINTON               6
2025    OH               WARREN              69
2026    OH           WASHINGTON              22
2027    OH                WAYNE              65
2028    OH             WILLIAMS              42
2029    OH                 WOOD             316
2030    OH              WYANDOT              35
2031    OK                ADAIR               2
2032    OK              ALFALFA               5
2033    OK                ATOKA               4
2034    OK               BEAVER               1
2035    OK              BECKHAM              11
2036    OK               BLAINE               7
2037    OK                BRYAN              49
2038    OK                CADDO              24
2039    OK             CANADIAN              59
2040    OK               CARTER               8
2041    OK             CHEROKEE               6
2042    OK              CHOCTAW              32
2043    OK            CLEVELAND              41
2044    OK                 COAL               5
2045    OK             COMANCHE              15
2046    OK               COTTON               3
2047    OK                CRAIG              17
2048    OK                CREEK              75
2049    OK               CUSTER              38
2050    OK             DELAWARE              14
2051    OK                DEWEY               2
2052    OK                ELLIS               7
2053    OK             GARFIELD             161
2054    OK               GARVIN              11
2055    OK                GRADY              55
2056    OK                GRANT              12
2057    OK                GREER               5
2058    OK               HARPER               1
2059    OK              HASKELL               8
2060    OK               HUGHES               9
2061    OK              JACKSON               3
2062    OK            JEFFERSON               5
2063    OK             JOHNSTON               8
2064    OK                  KAY              66
2065    OK           KINGFISHER               7
2066    OK                KIOWA               2
2067    OK              LATIMER              43
2068    OK             LE FLORE             176
2069    OK              LINCOLN              18
2070    OK                LOGAN              19
2071    OK                 LOVE              11
2072    OK                MAJOR               5
2073    OK             MARSHALL              29
2074    OK                MAYES              19
2075    OK              MCCLAIN              27
2076    OK            MCCURTAIN              18
2077    OK             MCINTOSH              18
2078    OK               MURRAY               7
2079    OK             MUSKOGEE             127
2080    OK                NOBLE              10
2081    OK               NOWATA              34
2082    OK             OKFUSKEE               7
2083    OK             OKLAHOMA             193
2084    OK             OKMULGEE              34
2085    OK                OSAGE               1
2086    OK               OTTAWA              14
2087    OK               PAWNEE              11
2088    OK                PAYNE               9
2089    OK            PITTSBURG              23
2090    OK             PONTOTOC              37
2091    OK         POTTAWATOMIE              21
2092    OK           PUSHMATAHA              11
2093    OK               ROGERS              72
2094    OK             SEMINOLE               6
2095    OK             SEQUOYAH              48
2096    OK             STEPHENS               9
2097    OK                TEXAS               7
2098    OK                TULSA             377
2099    OK              WAGONER              19
2100    OK           WASHINGTON              31
2101    OK              WASHITA               6
2102    OK                WOODS              20
2103    OK             WOODWARD              23
2104    OR                BAKER              37
2105    OR               BENTON              15
2106    OR            CLACKAMAS             127
2107    OR              CLATSOP               4
2108    OR             COLUMBIA              48
2109    OR                 COOS              10
2110    OR                CROOK               8
2111    OR            DESCHUTES              53
2112    OR              DOUGLAS              39
2113    OR              GILLIAM               2
2114    OR                GRANT               2
2115    OR           HOOD RIVER              14
2116    OR              JACKSON              30
2117    OR            JEFFERSON              10
2118    OR            JOSEPHINE               8
2119    OR              KLAMATH             228
2120    OR                 LAKE               4
2121    OR                 LANE             229
2122    OR              LINCOLN               4
2123    OR                 LINN             103
2124    OR              MALHEUR              10
2125    OR               MARION              85
2126    OR               MORROW              39
2127    OR            MULTNOMAH             349
2128    OR                 POLK              11
2129    OR              SHERMAN               2
2130    OR            TILLAMOOK               7
2131    OR             UMATILLA             467
2132    OR                UNION             196
2133    OR              WALLOWA               6
2134    OR                WASCO              50
2135    OR           WASHINGTON              87
2136    OR              YAMHILL              38
2137    PA                ADAMS              39
2138    PA            ALLEGHENY             760
2139    PA            ARMSTRONG              39
2140    PA               BEAVER             566
2141    PA              BEDFORD             138
2142    PA                BERKS             195
2143    PA                BLAIR             910
2144    PA             BRADFORD              38
2145    PA                BUCKS            1106
2146    PA               BUTLER             136
2147    PA              CAMBRIA             420
2148    PA              CAMERON               4
2149    PA               CARBON             121
2150    PA               CENTRE              32
2151    PA              CHESTER             308
2152    PA              CLARION              22
2153    PA           CLEARFIELD             120
2154    PA              CLINTON              39
2155    PA             COLUMBIA               3
2156    PA             CRAWFORD              67
2157    PA           CUMBERLAND             299
2158    PA              DAUPHIN             357
2159    PA             DELAWARE             815
2160    PA                  ELK               7
2161    PA                 ERIE             140
2162    PA              FAYETTE             291
2163    PA             FRANKLIN              64
2164    PA               FULTON               3
2165    PA               GREENE              29
2166    PA           HUNTINGDON              47
2167    PA              INDIANA              36
2168    PA            JEFFERSON              67
2169    PA              JUNIATA              67
2170    PA           LACKAWANNA             109
2171    PA            LANCASTER             350
2172    PA             LAWRENCE             173
2173    PA              LEBANON              70
2174    PA               LEHIGH             145
2175    PA              LUZERNE              85
2176    PA             LYCOMING              58
2177    PA               MCKEAN               8
2178    PA               MERCER              84
2179    PA              MIFFLIN              53
2180    PA               MONROE             207
2181    PA           MONTGOMERY             532
2182    PA              MONTOUR               3
2183    PA          NORTHAMPTON             229
2184    PA       NORTHUMBERLAND             102
2185    PA                PERRY             169
2186    PA         PHILADELPHIA            1649
2187    PA                 PIKE              88
2188    PA               POTTER               5
2189    PA           SCHUYLKILL             131
2190    PA               SNYDER              26
2191    PA             SOMERSET             149
2192    PA          SUSQUEHANNA              84
2193    PA                TIOGA              15
2194    PA                UNION              19
2195    PA              VENANGO              16
2196    PA               WARREN              10
2197    PA           WASHINGTON             195
2198    PA                WAYNE              51
2199    PA         WESTMORELAND             392
2200    PA              WYOMING              17
2201    PA                 YORK             260
2202    RI              BRISTOL               8
2203    RI                 KENT             102
2204    RI              NEWPORT              11
2205    RI           PROVIDENCE             318
2206    RI           WASHINGTON              48
2207    SC            ABBEVILLE             124
2208    SC                AIKEN             193
2209    SC            ALLENDALE               1
2210    SC             ANDERSON              34
2211    SC              BAMBERG               6
2212    SC             BARNWELL               9
2213    SC             BEAUFORT              17
2214    SC             BERKELEY              94
2215    SC              CALHOUN               2
2216    SC           CHARLESTON             148
2217    SC             CHEROKEE               9
2218    SC              CHESTER              15
2219    SC         CHESTERFIELD              24
2220    SC            CLARENDON              18
2221    SC             COLLETON              29
2222    SC           DARLINGTON              53
2223    SC               DILLON              74
2224    SC           DORCHESTER             139
2225    SC            EDGEFIELD              17
2226    SC            FAIRFIELD              22
2227    SC             FLORENCE             220
2228    SC           GEORGETOWN              29
2229    SC           GREENVILLE             139
2230    SC            GREENWOOD              94
2231    SC              HAMPTON              25
2232    SC                HORRY              42
2233    SC               JASPER               7
2234    SC              KERSHAW              26
2235    SC            LANCASTER              19
2236    SC              LAURENS              20
2237    SC                  LEE               4
2238    SC            LEXINGTON             118
2239    SC               MARION              22
2240    SC             MARLBORO              19
2241    SC            MCCORMICK              20
2242    SC             NEWBERRY              28
2243    SC               OCONEE               5
2244    SC           ORANGEBURG              25
2245    SC              PICKENS              48
2246    SC             RICHLAND              87
2247    SC               SALUDA               5
2248    SC          SPARTANBURG             124
2249    SC               SUMTER              29
2250    SC                UNION              19
2251    SC         WILLIAMSBURG              22
2252    SC                 YORK              72
2253    SD               AURORA               1
2254    SD               BEADLE              82
2255    SD              BENNETT               2
2256    SD            BON HOMME               1
2257    SD            BROOKINGS              34
2258    SD                BROWN             127
2259    SD                BRULE               5
2260    SD                BUTTE               4
2261    SD             CAMPBELL               1
2262    SD          CHARLES MIX               1
2263    SD                 CLAY               5
2264    SD            CODINGTON              13
2265    SD               CUSTER              60
2266    SD              DAVISON               6
2267    SD                  DAY               4
2268    SD                DEUEL               3
2269    SD                DEWEY               2
2270    SD              DOUGLAS               1
2271    SD              EDMUNDS               9
2272    SD           FALL RIVER             167
2273    SD                GRANT               5
2274    SD              GREGORY               3
2275    SD               HAAKON               6
2276    SD               HAMLIN               3
2277    SD                 HAND               9
2278    SD               HANSON               1
2279    SD               HUGHES              17
2280    SD                 HYDE               1
2281    SD              JERAULD               1
2282    SD            KINGSBURY              13
2283    SD                 LAKE               3
2284    SD             LAWRENCE              19
2285    SD              LINCOLN              10
2286    SD             MARSHALL               1
2287    SD               MCCOOK               2
2288    SD                MEADE              69
2289    SD                MINER               1
2290    SD            MINNEHAHA             106
2291    SD                MOODY               2
2292    SD           PENNINGTON              49
2293    SD              PERKINS               1
2294    SD               POTTER               1
2295    SD              ROBERTS              10
2296    SD              SANBORN               8
2297    SD              SHANNON               2
2298    SD                SPINK               5
2299    SD              STANLEY               4
2300    SD                SULLY               1
2301    SD               TURNER               5
2302    SD                UNION              52
2303    SD             WALWORTH               6
2304    SD              YANKTON               5
2305    TN             ANDERSON              45
2306    TN              BEDFORD              12
2307    TN               BENTON              24
2308    TN              BLEDSOE              10
2309    TN               BLOUNT             128
2310    TN              BRADLEY              72
2311    TN             CAMPBELL              57
2312    TN               CANNON               8
2313    TN              CARROLL              57
2314    TN               CARTER              21
2315    TN             CHEATHAM              16
2316    TN              CHESTER               3
2317    TN            CLAIBORNE              32
2318    TN                COCKE              37
2319    TN               COFFEE              12
2320    TN             CROCKETT              16
2321    TN           CUMBERLAND              14
2322    TN             DAVIDSON             162
2323    TN              DECATUR               1
2324    TN               DEKALB               6
2325    TN              DICKSON              64
2326    TN                 DYER              18
2327    TN              FAYETTE              30
2328    TN             FENTRESS               5
2329    TN             FRANKLIN              36
2330    TN               GIBSON              25
2331    TN                GILES              10
2332    TN             GRAINGER              53
2333    TN               GREENE              43
2334    TN               GRUNDY              59
2335    TN              HAMBLEN              62
2336    TN             HAMILTON             429
2337    TN              HANCOCK               2
2338    TN             HARDEMAN              14
2339    TN               HARDIN              10
2340    TN              HAWKINS              57
2341    TN              HAYWOOD               4
2342    TN            HENDERSON              14
2343    TN                HENRY              22
2344    TN              HICKMAN              16
2345    TN            HUMPHREYS              24
2346    TN              JACKSON               2
2347    TN            JEFFERSON              60
2348    TN              JOHNSON               1
2349    TN                 KNOX             458
2350    TN                 LAKE               2
2351    TN           LAUDERDALE              44
2352    TN             LAWRENCE              42
2353    TN                LEWIS               6
2354    TN              LINCOLN               4
2355    TN               LOUDON              26
2356    TN              MADISON              22
2357    TN               MARION             115
2358    TN             MARSHALL              40
2359    TN                MAURY             111
2360    TN               MCMINN             114
2361    TN              MCNAIRY              17
2362    TN                MEIGS              10
2363    TN               MONROE              46
2364    TN           MONTGOMERY              27
2365    TN               MORGAN              60
2366    TN                OBION              37
2367    TN              OVERTON               1
2368    TN                PERRY               2
2369    TN              PICKETT               2
2370    TN                 POLK              41
2371    TN               PUTNAM               3
2372    TN                 RHEA              70
2373    TN                ROANE              44
2374    TN            ROBERTSON              78
2375    TN           RUTHERFORD             171
2376    TN                SCOTT              45
2377    TN           SEQUATCHIE              11
2378    TN               SEVIER              51
2379    TN               SHELBY             621
2380    TN                SMITH               7
2381    TN              STEWART               2
2382    TN             SULLIVAN              72
2383    TN               SUMNER              88
2384    TN               TIPTON              45
2385    TN            TROUSDALE               2
2386    TN               UNICOI             230
2387    TN                UNION              23
2388    TN            VAN BUREN               3
2389    TN               WARREN               6
2390    TN           WASHINGTON             164
2391    TN                WAYNE               3
2392    TN              WEAKLEY              39
2393    TN                WHITE               3
2394    TN           WILLIAMSON              77
2395    TN               WILSON              74
2396    TX             ANDERSON             241
2397    TX              ANDREWS               3
2398    TX             ANGELINA              53
2399    TX              ARANSAS               6
2400    TX               ARCHER               8
2401    TX            ARMSTRONG              12
2402    TX             ATASCOSA              64
2403    TX               AUSTIN              35
2404    TX               BAILEY               5
2405    TX              BANDERA              15
2406    TX              BASTROP             102
2407    TX               BAYLOR               1
2408    TX                  BEE               9
2409    TX                 BELL             413
2410    TX                BEXAR             950
2411    TX               BLANCO               3
2412    TX               BOSQUE              17
2413    TX                BOWIE              64
2414    TX             BRAZORIA             259
2415    TX               BRAZOS              55
2416    TX             BREWSTER              14
2417    TX              BRISCOE               3
2418    TX                BROWN              39
2419    TX             BURLESON              21
2420    TX               BURNET               6
2421    TX             CALDWELL              25
2422    TX              CALHOUN               7
2423    TX             CALLAHAN              12
2424    TX              CAMERON             119
2425    TX                 CAMP              14
2426    TX               CARSON              21
2427    TX                 CASS              54
2428    TX             CHAMBERS               9
2429    TX             CHEROKEE              57
2430    TX                 CLAY              17
2431    TX              COLEMAN              11
2432    TX               COLLIN             159
2433    TX        COLLINGSWORTH               4
2434    TX             COLORADO              16
2435    TX                COMAL             132
2436    TX             COMANCHE              15
2437    TX               CONCHO               1
2438    TX                COOKE              56
2439    TX              CORYELL              87
2440    TX             CROCKETT               1
2441    TX               CROSBY               2
2442    TX            CULBERSON              13
2443    TX               DALLAM             130
2444    TX               DALLAS             406
2445    TX           DEAF SMITH               7
2446    TX                DELTA               2
2447    TX               DENTON             394
2448    TX               DEWITT               6
2449    TX              DICKENS               2
2450    TX               DIMMIT               1
2451    TX               DONLEY               1
2452    TX                DUVAL               1
2453    TX             EASTLAND              16
2454    TX                ECTOR              20
2455    TX              EDWARDS               1
2456    TX              EL PASO             863
2457    TX                ELLIS             125
2458    TX                ERATH              20
2459    TX                FALLS              20
2460    TX               FANNIN              19
2461    TX              FAYETTE              26
2462    TX               FISHER               2
2463    TX                FLOYD               2
2464    TX                FOARD               1
2465    TX            FORT BEND             258
2466    TX            FREESTONE              87
2467    TX                 FRIO              20
2468    TX            GALVESTON             283
2469    TX                GARZA               2
2470    TX            GILLESPIE               2
2471    TX               GOLIAD               5
2472    TX             GONZALES              42
2473    TX                 GRAY              22
2474    TX              GRAYSON             151
2475    TX                GREGG             154
2476    TX               GRIMES               9
2477    TX            GUADALUPE              69
2478    TX                 HALE              10
2479    TX                 HALL               7
2480    TX             HAMILTON               2
2481    TX             HANSFORD               1
2482    TX             HARDEMAN               8
2483    TX               HARDIN             141
2484    TX               HARRIS            2535
2485    TX             HARRISON              98
2486    TX              HARTLEY               9
2487    TX                 HAYS              33
2488    TX            HENDERSON              37
2489    TX              HIDALGO              39
2490    TX                 HILL              78
2491    TX              HOCKLEY               7
2492    TX                 HOOD             102
2493    TX              HOPKINS              22
2494    TX              HOUSTON              21
2495    TX               HOWARD              75
2496    TX             HUDSPETH               7
2497    TX                 HUNT              32
2498    TX           HUTCHINSON              37
2499    TX                 JACK              33
2500    TX              JACKSON               8
2501    TX               JASPER              30
2502    TX           JEFF DAVIS               2
2503    TX            JEFFERSON             244
2504    TX             JIM HOGG               4
2505    TX            JIM WELLS              11
2506    TX              JOHNSON             429
2507    TX                JONES               7
2508    TX               KARNES               3
2509    TX              KAUFMAN              49
2510    TX              KENDALL              10
2511    TX                 KERR               5
2512    TX               KINNEY              35
2513    TX              KLEBERG              20
2514    TX                 KNOX               1
2515    TX             LA SALLE              14
2516    TX                LAMAR              26
2517    TX                 LAMB               4
2518    TX             LAMPASAS               9
2519    TX               LAVACA              14
2520    TX                  LEE              12
2521    TX                 LEON              31
2522    TX              LIBERTY             144
2523    TX            LIMESTONE              24
2524    TX             LIVE OAK               4
2525    TX                LLANO               3
2526    TX              LUBBOCK             292
2527    TX                 LYNN               2
2528    TX              MADISON               8
2529    TX               MARION              14
2530    TX               MARTIN               2
2531    TX                MASON               2
2532    TX            MATAGORDA              12
2533    TX             MAVERICK              71
2534    TX            MCCULLOCH               4
2535    TX             MCLENNAN             148
2536    TX               MEDINA              56
2537    TX              MIDLAND              30
2538    TX                MILAM              37
2539    TX                MILLS               4
2540    TX             MITCHELL              11
2541    TX             MONTAGUE              17
2542    TX           MONTGOMERY             474
2543    TX                MOORE              49
2544    TX               MORRIS              16
2545    TX               MOTLEY              17
2546    TX          NACOGDOCHES              37
2547    TX              NAVARRO              25
2548    TX               NEWTON              14
2549    TX                NOLAN              34
2550    TX               NUECES              82
2551    TX               OLDHAM               8
2552    TX               ORANGE             105
2553    TX           PALO PINTO              31
2554    TX               PANOLA              21
2555    TX               PARKER             303
2556    TX               PARMER              28
2557    TX                PECOS               2
2558    TX                 POLK              27
2559    TX               POTTER             883
2560    TX             PRESIDIO               9
2561    TX                RAINS               5
2562    TX              RANDALL              72
2563    TX                 REAL               2
2564    TX            RED RIVER               1
2565    TX               REEVES               3
2566    TX              REFUGIO               2
2567    TX            ROBERTSON              30
2568    TX             ROCKWALL              32
2569    TX              RUNNELS              10
2570    TX                 RUSK              13
2571    TX               SABINE               5
2572    TX        SAN AUGUSTINE               3
2573    TX          SAN JACINTO              24
2574    TX         SAN PATRICIO              38
2575    TX             SAN SABA               5
2576    TX               SCURRY               9
2577    TX               SHELBY              17
2578    TX              SHERMAN               1
2579    TX                SMITH             127
2580    TX            SOMERVELL               5
2581    TX                STARR               2
2582    TX             STEPHENS               1
2583    TX            STONEWALL               1
2584    TX              SWISHER              13
2585    TX              TARRANT            4235
2586    TX               TAYLOR              86
2587    TX              TERRELL              15
2588    TX                TERRY               5
2589    TX                TITUS              10
2590    TX            TOM GREEN              52
2591    TX               TRAVIS              74
2592    TX              TRINITY               6
2593    TX                TYLER              29
2594    TX               UPSHUR              41
2595    TX                UPTON               2
2596    TX               UVALDE              35
2597    TX            VAL VERDE              93
2598    TX            VAN ZANDT              47
2599    TX             VICTORIA              60
2600    TX               WALKER              38
2601    TX               WALLER              21
2602    TX                 WARD               5
2603    TX           WASHINGTON               4
2604    TX                 WEBB             291
2605    TX              WHARTON              13
2606    TX              WHEELER               4
2607    TX              WICHITA             120
2608    TX            WILBARGER               4
2609    TX              WILLACY               1
2610    TX           WILLIAMSON              77
2611    TX               WILSON              75
2612    TX                 WISE             156
2613    TX                 WOOD              60
2614    TX                YOUNG               2
2615    TX               ZAPATA               2
2616    TX               ZAVALA               4
2617    UT               BEAVER              85
2618    UT            BOX ELDER              58
2619    UT                CACHE              23
2620    UT               CARBON              52
2621    UT              DAGGETT               2
2622    UT                DAVIS             337
2623    UT             DUCHESNE              10
2624    UT                EMERY               8
2625    UT                GRAND               1
2626    UT                 IRON              48
2627    UT                 JUAB              25
2628    UT              MILLARD               8
2629    UT               MORGAN              18
2630    UT                 RICH               5
2631    UT            SALT LAKE             580
2632    UT             SAN JUAN               8
2633    UT              SANPETE               5
2634    UT               SEVIER               1
2635    UT               SUMMIT              12
2636    UT               TOOELE              52
2637    UT               UINTAH              10
2638    UT                 UTAH             186
2639    UT              WASATCH               7
2640    UT           WASHINGTON              16
2641    UT                WEBER             360
2642    VA             ACCOMACK               4
2643    VA            ALBEMARLE              28
2644    VA            ALLEGHANY             108
2645    VA               AMELIA              10
2646    VA              AMHERST              28
2647    VA           APPOMATTOX              16
2648    VA            ARLINGTON              63
2649    VA              AUGUSTA              12
2650    VA                 BATH              12
2651    VA              BEDFORD             395
2652    VA                BLAND              14
2653    VA            BOTETOURT             288
2654    VA            BRUNSWICK               9
2655    VA             BUCHANAN              25
2656    VA           BUCKINGHAM              32
2657    VA             CAMPBELL              43
2658    VA             CAROLINE              46
2659    VA              CARROLL               3
2660    VA         CHARLES CITY               6
2661    VA            CHARLOTTE              30
2662    VA         CHESTERFIELD             228
2663    VA               CLARKE               2
2664    VA                CRAIG              31
2665    VA             CULPEPER              24
2666    VA           CUMBERLAND               5
2667    VA            DICKENSON              15
2668    VA            DINWIDDIE              23
2669    VA                ESSEX               4
2670    VA              FAIRFAX             225
2671    VA             FAUQUIER              24
2672    VA                FLOYD              43
2673    VA             FLUVANNA               9
2674    VA             FRANKLIN             202
2675    VA            FREDERICK              24
2676    VA                GILES              41
2677    VA           GLOUCESTER              14
2678    VA            GOOCHLAND              15
2679    VA               GREENE               4
2680    VA          GREENSVILLE               2
2681    VA              HALIFAX              10
2682    VA              HANOVER             117
2683    VA              HENRICO             128
2684    VA                HENRY              24
2685    VA     INDEPENDENT CITY            3249
2686    VA        ISLE OF WIGHT              36
2687    VA           JAMES CITY               6
2688    VA       KING AND QUEEN               6
2689    VA          KING GEORGE               6
2690    VA         KING WILLIAM              29
2691    VA            LANCASTER               1
2692    VA                  LEE              32
2693    VA              LOUDOUN              42
2694    VA               LOUISA              31
2695    VA            LUNENBURG              43
2696    VA              MADISON               3
2697    VA              MATHEWS               3
2698    VA          MECKLENBURG               7
2699    VA            MIDDLESEX               2
2700    VA           MONTGOMERY             101
2701    VA               NELSON              12
2702    VA             NEW KENT              29
2703    VA          NORTHAMPTON               7
2704    VA             NOTTOWAY             106
2705    VA               ORANGE              35
2706    VA                 PAGE              70
2707    VA              PATRICK               9
2708    VA         PITTSYLVANIA              49
2709    VA             POWHATAN              28
2710    VA        PRINCE EDWARD              34
2711    VA        PRINCE GEORGE              13
2712    VA       PRINCE WILLIAM             110
2713    VA              PULASKI              33
2714    VA         RAPPAHANNOCK               9
2715    VA             RICHMOND               1
2716    VA              ROANOKE             193
2717    VA           ROCKBRIDGE              16
2718    VA           ROCKINGHAM              40
2719    VA              RUSSELL             172
2720    VA                SCOTT              30
2721    VA           SHENANDOAH              13
2722    VA                SMYTH              15
2723    VA          SOUTHAMPTON              26
2724    VA         SPOTSYLVANIA              46
2725    VA             STAFFORD              37
2726    VA               SUSSEX              10
2727    VA             TAZEWELL             197
2728    VA               WARREN              22
2729    VA           WASHINGTON              26
2730    VA         WESTMORELAND               7
2731    VA                 WISE             114
2732    VA                WYTHE              39
2733    VA                 YORK              20
2734    VT              ADDISON               8
2735    VT           BENNINGTON               8
2736    VT            CALEDONIA               3
2737    VT           CHITTENDEN              40
2738    VT                ESSEX               4
2739    VT             FRANKLIN              83
2740    VT           GRAND ISLE               5
2741    VT             LAMOILLE               4
2742    VT               ORANGE               9
2743    VT              ORLEANS              13
2744    VT              RUTLAND              59
2745    VT           WASHINGTON               3
2746    VT              WINDHAM              10
2747    VT              WINDSOR              10
2748    WA                ADAMS              15
2749    WA               ASOTIN              17
2750    WA               BENTON             294
2751    WA               CHELAN              79
2752    WA              CLALLAM               8
2753    WA                CLARK             850
2754    WA             COLUMBIA               2
2755    WA              COWLITZ             151
2756    WA              DOUGLAS               2
2757    WA                FERRY               1
2758    WA             FRANKLIN             148
2759    WA             GARFIELD               1
2760    WA                GRANT              22
2761    WA         GRAYS HARBOR              29
2762    WA               ISLAND              39
2763    WA            JEFFERSON               4
2764    WA                 KING            1039
2765    WA               KITSAP              60
2766    WA             KITTITAS              15
2767    WA            KLICKITAT              63
2768    WA                LEWIS              73
2769    WA              LINCOLN              12
2770    WA                MASON              20
2771    WA             OKANOGAN              15
2772    WA              PACIFIC               6
2773    WA         PEND OREILLE              21
2774    WA               PIERCE             614
2775    WA             SAN JUAN               2
2776    WA               SKAGIT              57
2777    WA             SKAMANIA              14
2778    WA            SNOHOMISH             506
2779    WA              SPOKANE             757
2780    WA              STEVENS              34
2781    WA             THURSTON              94
2782    WA            WAHKIAKUM               3
2783    WA          WALLA WALLA              45
2784    WA              WHATCOM              45
2785    WA              WHITMAN               9
2786    WA               YAKIMA              56
2787    WI                ADAMS              29
2788    WI              ASHLAND               7
2789    WI               BARRON              20
2790    WI             BAYFIELD              11
2791    WI                BROWN              76
2792    WI              BUFFALO              16
2793    WI              BURNETT               6
2794    WI              CALUMET               8
2795    WI             CHIPPEWA              35
2796    WI                CLARK               9
2797    WI             COLUMBIA             106
2798    WI             CRAWFORD              24
2799    WI                 DANE              74
2800    WI                DODGE              63
2801    WI                 DOOR               2
2802    WI              DOUGLAS             465
2803    WI                 DUNN              13
2804    WI           EAU CLAIRE              78
2805    WI          FOND DU LAC             275
2806    WI               FOREST              16
2807    WI                GRANT              33
2808    WI                GREEN              11
2809    WI           GREEN LAKE              17
2810    WI                 IOWA               5
2811    WI                 IRON               4
2812    WI              JACKSON              19
2813    WI            JEFFERSON              27
2814    WI               JUNEAU              14
2815    WI              KENOSHA             111
2816    WI             KEWAUNEE               4
2817    WI            LA CROSSE             339
2818    WI            LAFAYETTE               7
2819    WI             LANGLADE               7
2820    WI              LINCOLN              23
2821    WI            MANITOWOC              15
2822    WI             MARATHON              23
2823    WI            MARINETTE              12
2824    WI            MARQUETTE              36
2825    WI            MILWAUKEE             188
2826    WI               MONROE              51
2827    WI               OCONTO              16
2828    WI               ONEIDA              13
2829    WI            OUTAGAMIE              57
2830    WI              OZAUKEE               6
2831    WI                PEPIN              12
2832    WI               PIERCE              43
2833    WI                 POLK              23
2834    WI              PORTAGE             240
2835    WI                PRICE              10
2836    WI               RACINE             100
2837    WI                 ROCK             138
2838    WI                 RUSK              21
2839    WI                 SAUK              29
2840    WI               SAWYER              14
2841    WI              SHAWANO               9
2842    WI            SHEBOYGAN               9
2843    WI             ST CROIX             168
2844    WI               TAYLOR              15
2845    WI          TREMPEALEAU              54
2846    WI               VERNON              48
2847    WI                VILAS               5
2848    WI             WALWORTH              47
2849    WI             WASHBURN              23
2850    WI           WASHINGTON              37
2851    WI             WAUKESHA              96
2852    WI              WAUPACA              34
2853    WI             WAUSHARA              13
2854    WI            WINNEBAGO              95
2855    WI                 WOOD             119
2856    WV              BARBOUR              33
2857    WV             BERKELEY             108
2858    WV                BOONE              50
2859    WV              BRAXTON              22
2860    WV               BROOKE              19
2861    WV               CABELL             406
2862    WV                 CLAY               4
2863    WV            DODDRIDGE               4
2864    WV              FAYETTE              30
2865    WV               GILMER               1
2866    WV                GRANT               7
2867    WV           GREENBRIER              75
2868    WV            HAMPSHIRE              37
2869    WV              HANCOCK              37
2870    WV                HARDY               7
2871    WV             HARRISON              51
2872    WV              JACKSON              22
2873    WV            JEFFERSON              56
2874    WV              KANAWHA             130
2875    WV                LEWIS               3
2876    WV              LINCOLN             107
2877    WV                LOGAN              61
2878    WV               MARION              16
2879    WV             MARSHALL              26
2880    WV                MASON              34
2881    WV             MCDOWELL              43
2882    WV               MERCER             387
2883    WV              MINERAL             223
2884    WV                MINGO             168
2885    WV           MONONGALIA              19
2886    WV               MONROE              35
2887    WV               MORGAN              33
2888    WV             NICHOLAS               6
2889    WV                 OHIO              25
2890    WV            PLEASANTS               3
2891    WV           POCAHONTAS              13
2892    WV              PRESTON              35
2893    WV               PUTNAM              83
2894    WV              RALEIGH              98
2895    WV             RANDOLPH              21
2896    WV              RITCHIE               7
2897    WV                ROANE               3
2898    WV              SUMMERS             153
2899    WV               TAYLOR              94
2900    WV               TUCKER               2
2901    WV                TYLER               2
2902    WV               UPSHUR               5
2903    WV                WAYNE             217
2904    WV              WEBSTER               5
2905    WV               WETZEL               9
2906    WV                 WIRT               7
2907    WV                 WOOD             108
2908    WV              WYOMING              63
2909    WY               ALBANY              90
2910    WY             BIG HORN              70
2911    WY             CAMPBELL             386
2912    WY               CARBON             168
2913    WY             CONVERSE             211
2914    WY                CROOK              33
2915    WY              FREMONT              42
2916    WY               GOSHEN             244
2917    WY          HOT SPRINGS               4
2918    WY              JOHNSON              18
2919    WY              LARAMIE             737
2920    WY              LINCOLN              25
2921    WY              NATRONA              92
2922    WY             NIOBRARA              51
2923    WY                 PARK              29
2924    WY               PLATTE             129
2925    WY             SHERIDAN             252
2926    WY             SUBLETTE               3
2927    WY           SWEETWATER             196
2928    WY                UINTA              49
2929    WY             WASHAKIE              10
2930    WY               WESTON              37

For Challenge 2, I will be using the Roadroad CSV file data.

Describe the data

Code
#Number of columns
ncol(railroad)
[1] 3
Code
#Number of rows
nrow(railroad)
[1] 2930

Railroad data had 3 columns and 2,930 rows of data. The 3 columns are: state, country, and total employees and the rows represent the data collected from different states in the US.

Code
#Number of states represented
unique(railroad$state)
 [1] "AE" "AK" "AL" "AP" "AR" "AZ" "CA" "CO" "CT" "DC" "DE" "FL" "GA" "HI" "IA"
[16] "ID" "IL" "IN" "KS" "KY" "LA" "MA" "MD" "ME" "MI" "MN" "MO" "MS" "MT" "NC"
[31] "ND" "NE" "NH" "NJ" "NM" "NV" "NY" "OH" "OK" "OR" "PA" "RI" "SC" "SD" "TN"
[46] "TX" "UT" "VA" "VT" "WA" "WI" "WV" "WY"

There are 54 different states included in the data set, when there are only 50 states. The function above shows AE, WI, DC, and AP which are not official US states. The total employees from each state are represented by breaking down the number of employees from each county within a state. For example, there are data from 12 counties within Massachusetts.

Provide Grouped Summary Statistics

Code
railroad %>% 
  group_by(state) %>% 
  summarise(Mean = mean(total_employees), 
            Median = median(total_employees),
            Min = min(total_employees),
            #Mode = mode(total_employees), 
            Max = max(total_employees),
            Standard_Deviation = sd(total_employees),
            IQR = IQR(total_employees),
            Total=sum(total_employees))
# A tibble: 53 × 8
   state  Mean Median   Min   Max Standard_Deviation   IQR Total
   <chr> <dbl>  <dbl> <int> <int>              <dbl> <dbl> <int>
 1 AE      2      2       2     2               NA     0       2
 2 AK     17.2    2.5     1    88               34.8   4     103
 3 AL     63.5   26       1   990              130.   47    4257
 4 AP      1      1       1     1               NA     0       1
 5 AR     53.8   16.5     1   972              131.   33.8  3871
 6 AZ    210.    94       3   749              228.  296    3153
 7 CA    239.    61       1  2888              549.  188   13137
 8 CO     64.0   10       1   553              128.   39    3650
 9 CT    324    125      26  1561              520.  167.   2592
10 DC    279    279     279   279               NA     0     279
# ℹ 43 more rows

Shown above are the mean,median,min,max, standard deviation, IQR, and the total sum of the data set for the number of total employees grouped by state.

Explain and Interpret

Larger states, and high population states Texas, California, Illinois, New York ranked high in total employees; while smaller/low density population states like Hawaii, Alaska, and Vermont ranked the lowest.The state with the highest total sum of employees Hawaii with 4 employees, while Texas had the highest with 19,839 employees. This makes sense when considering according to a report by the Association of American Railroads, the state with the highest total rail miles was Texas with 10,506 miles, and the lowest was Hawaii with 0 miles. Link: https://www.aar.org/wp-content/uploads/2019/05/AAR-State-Rankings-2017.pdf