Code
library(tidyverse)
library(readxl)
knitr::opts_chunk$set(echo = TRUE, warning=FALSE, message=FALSE)Challenge 2 Solutions
challenge_2
Tenzin Latoe
railroads
Data wrangling: using group() and summarise()
Challenge Overview
Today’s challenge is to
- read in a data set, and describe the data using both words and any supporting information (e.g., tables, etc)
- 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 37For Challenge 2, I will be using the Roadroad CSV file data.
Describe the data
Code
#Number of columns
ncol(railroad)[1] 3Code
#Number of rows
nrow(railroad)[1] 2930Railroad 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 rowsShown 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