Spreadsheet: 886637d1736713188-more-count-challenges-with-spilled-arrays-example2
Sheet: Combined

[NAME] | feature_name | feature_class | state_name | state_numeric | county_name | county_numeric | prim_long_dec | source_lat_dms | unit_type | census_code | census_class_code |  |  |  | Civil Class Unit [NAME] |  |  |  |  |  | HELPER DATA
 | Aberdeen | Populated Place | Arkansas | 5 | Monroe | 95 | 34.6034302 | -91.3417918 |  |  | U6 |  |  |  |  |  |  |  |  |  |  | Survey 2429 | Civil | Arkansas | 5 | [NAME] | 77 | 34.810374 | -90.8040015
45796 | Adona | Populated Place | Arkansas | 5 | [NAME] | 105 | 35.0381433 | -92.8979475 |  | 250 | P1 |  |  |  | Country |  |  |  |  |  | 55359 | Survey 490 | Civil | Arkansas | 5 | [NAME] | 77 | 34.8195404 | -90.8212242
45802 | Albion | Populated Place | Arkansas | 5 | White | 145 | 35.3425829 | -91.7895848 |  | 490 | U6 |  |  |  | County |  |  |  |  |  | 59956 | Township of Cleveland (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.3709571 | -93.1293331
45823 | Alicia | Populated Place | Arkansas | 5 | [NAME] | 75 | 35.8931295 | -91.0829015 |  | 700 | P1 |  |  |  | State |  |  |  |  |  | 59957 | Township of Harrison (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.4167892 | -93.2057234
45824 | [NAME] | Populated Place | Arkansas | 5 | Franklin | 47 | 35.4248078 | -93.7304719 |  | 730 | U5 |  |  |  |  |  |  |  |  |  | 59958 | Township of Lamartine (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.3806797 | -93.296003
45838 | Allport | Populated Place | Arkansas | 5 | Lonoke | 85 | 34.5420393 | -91.7840227 |  | 940 | P1 |  |  |  |  |  |  |  |  |  | 59959 | Township of Warren (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.3376255 | -93.3710051
45845 | Alpine | Populated Place | Arkansas | 5 | [NAME] | 19 | 34.2289863 | -93.3790695 |  | 1090 | U5 |  |  |  | ^^ Count unit_type ONLY when feature_class = "Civil" |  |  |  |  |  | 59960 | Township of Brister (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.1723539 | -93.2085
45849 | Altheimer | Populated Place | Arkansas | 5 | [NAME] | 69 | 34.3192636 | -91.8473565 |  | 1150 | P1 |  |  |  |  |  |  |  |  |  | 59961 | Township of Brown (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.0876359 | -93.0626634
45850 | Altus | Populated Place | Arkansas | 5 | Franklin | 47 | 35.4461965 | -93.7624172 |  | 1210 | P1 |  |  |  |  |  |  |  |  |  | 59962 | Township of [NAME] (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.1640205 | -93.3265586
45854 | [NAME] | Populated Place | Arkansas | 5 | Pulaski | 119 | 34.8059243 | -92.2915397 |  | 1330 | U4 |  |  |  |  |  |  |  |  |  | 59963 | Township of Calhoun (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.2167967 | -93.1223876
45859 | [NAME] | Populated Place | Arkansas | 5 | Ouachita | 103 | 33.7320525 | -92.8154405 |  | 1390 | U6 |  |  |  | Civil Class Unit [NAME] |  |  |  |  |  | 59964 | Township of Clay (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.2556838 | -93.3807272
45913 | Arden | Populated Place | Arkansas | 5 | Little River | 81 | 33.6895629 | -94.2857555 |  | 1840 | U6 |  |  |  |  |  |  |  |  |  | 59965 | Township of Cornie (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.2126303 | -93.0251638
45966 | Atkins | Populated Place | Arkansas | 5 | Pope | 115 | 35.2464719 | -92.9365581 |  | 2590 | P1 |  |  |  | Country |  |  |  |  |  | 59966 | Township of Dorcheat (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.075134 | -93.4223943
45979 | [NAME] | Populated Place | Arkansas | 5 | Lonoke | 85 | 34.9984206 | -91.9837552 |  | 2860 | P1 |  |  |  | County |  |  |  |  |  | 59967 | Township of Georgia (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.1751307 | -93.4460066
45989 | Avoca | Populated Place | Arkansas | 5 | [NAME] | 7 | 36.4020182 | -94.0707581 |  | 3040 | P1 |  |  |  | State |  |  |  |  |  | 59968 | Township of Mississippi (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.0806902 | -93.3001688
45995 | Back Gate | Populated Place | Arkansas | 5 | Desha | 41 | 33.9326028 | -91.3928981 |  | 3130 | U6 |  |  |  |  |  |  |  |  |  | 59969 | Township of Moss (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.080691 | -93.1807216
46024 | [NAME] | Populated Place | Arkansas | 5 | Searcy | 129 | 35.9136863 | -92.5976628 |  | 3190 | U6 |  |  |  | ^^ using helper arrays |  |  |  |  |  | 63755 | Arkansas County | Civil | Arkansas | 5 | Arkansas | 1 | 34.2891871 | -91.374222 | COUNTY |  | COUNTY
46076 | Banks | Populated Place | Arkansas | 5 | Bradley | 11 | 33.5748327 | -92.2690344 |  | 3430 | P1 |  |  |  |  |  |  |  |  |  | 63756 | Ashley County | Civil | Arkansas | 5 | [NAME] | 3 | 33.1912047 | -91.7684539 | COUNTY |  | COUNTY
46159 | Baucum | Populated Place | Arkansas | 5 | Pulaski | 119 | 34.7289805 | -92.1301452 |  | 4060 | U6 |  |  |  |  |  |  |  |  |  | 63757 | Bradley County | Civil | Arkansas | 5 | Bradley | 11 | 33.4664257 | -92.1623595 | COUNTY |  | COUNTY
46250 | Bearden | Populated Place | Arkansas | 5 | Ouachita | 103 | 33.7245526 | -92.6157139 |  | 4420 | P1 |  |  |  |  |  |  |  |  |  | 63758 | Calhoun County | Civil | Arkansas | 5 | [NAME] | 13 | 33.5580688 | -92.5030229 | COUNTY |  | COUNTY
46335 | Beedeville | Populated Place | Arkansas | 5 | [NAME] | 67 | 35.4289722 | -91.109845 |  | 4720 | P1 |  |  |  |  |  |  |  |  |  | 63759 | Clay County | Civil | Arkansas | 5 | Clay | 21 | 36.368346 | -90.4173718 | COUNTY |  | COUNTY
46360 | [NAME] | Populated Place | Arkansas | 5 | [NAME] | 7 | 36.4814641 | -94.2732642 |  |  |  |  |  |  |  |  |  |  |  |  | 63760 | Cleveland County | Civil | Arkansas | 5 | Cleveland | 25 | 33.898373 | -92.1851418 | COUNTY |  | COUNTY
46394 | [NAME] | Populated Place | Arkansas | 5 | Saline | 125 | 34.5645372 | -92.586828 |  | 5290 | P1 |  |  |  |  |  |  |  |  |  | 63761 | Columbia County | Civil | Arkansas | 5 | Columbia | 27 | 33.2142936 | -93.2273387 | COUNTY |  | COUNTY
46413 | Berryville | Populated Place | Arkansas | 5 | Carroll | 15 | 36.364792 | -93.5679667 |  | 5560 | P1 |  |  |  |  |  |  |  |  |  | 64286 | Township of Bear (historical) | Civil | Arkansas | 5 | Garland | 51 | 34.5389792 | -93.279355
46545 | Big Creek Corner | Populated Place | Arkansas | 5 | [NAME] | 77 | 34.6728763 | -90.890115 |  | 5905 | U6 |  |  |  |  |  |  |  |  |  | 64293 | Township of Bucksville (historical) | Civil | Arkansas | 5 | Garland | 51 | 34.6375928 | -93.3640778
55358 | Survey 2429 | Civil | Arkansas | 5 | [NAME] | 77 | 34.810374 | -90.8040015 |  |  |  |  |  |  |  |  |  |  |  |  | 66844 | Township of Wallace | Civil | Arkansas | 5 | Little River | 81 | 33.6564586 | -94.3503978
55359 | Survey 490 | Civil | Arkansas | 5 | [NAME] | 77 | 34.8195404 | -90.8212242 |  |  |  |  |  |  |  |  |  |  |  |  | 66845 | Clark County | Civil | Arkansas | 5 | [NAME] | 19 | 34.050926 | -93.1763506 | COUNTY |  | COUNTY
59956 | Township of Cleveland (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.3709571 | -93.1293331 |  |  |  |  |  |  |  |  |  |  |  |  | 66846 | Conway County | Civil | Arkansas | 5 | Conway | 29 | 35.262377 | -92.7014641 | COUNTY |  | COUNTY
59957 | Township of Harrison (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.4167892 | -93.2057234 |  |  |  |  |  |  |  |  |  |  |  |  | 66847 | Craighead County | Civil | Arkansas | 5 | Craighead | 31 | 35.8308078 | -90.6328538 | COUNTY |  | COUNTY
59958 | Township of Lamartine (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.3806797 | -93.296003 |  |  |  |  |  |  |  |  |  |  |  |  | 66848 | Cross County | Civil | Arkansas | 5 | Cross | 37 | 35.2957359 | -90.7711518 | COUNTY |  | COUNTY
59959 | Township of Warren (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.3376255 | -93.3710051 |  |  |  |  |  |  |  |  |  |  |  |  | 66849 | Dallas County | Civil | Arkansas | 5 | Dallas | 39 | 33.9698896 | -92.6543986 | COUNTY |  | COUNTY
59960 | Township of Brister (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.1723539 | -93.2085 |  |  |  |  |  |  |  |  |  |  |  |  | 66850 | Desha County | Civil | Arkansas | 5 | Desha | 41 | 33.8309808 | -91.2549721 | COUNTY |  | COUNTY
59961 | Township of Brown (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.0876359 | -93.0626634 |  |  |  |  |  |  |  |  |  |  |  |  | 68085 | State of Arkansas | Civil | Arkansas | 5 | Pulaski | 119 | 34.8999171 | -92.4383739 | STATE |  | STATE
59962 | Township of [NAME] (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.1640205 | -93.3265586
59963 | Township of Calhoun (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.2167967 | -93.1223876
59964 | Township of Clay (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.2556838 | -93.3807272
59965 | Township of Cornie (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.2126303 | -93.0251638
59966 | Township of Dorcheat (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.075134 | -93.4223943
59967 | Township of Georgia (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.1751307 | -93.4460066
59968 | Township of Mississippi (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.0806902 | -93.3001688
59969 | Township of Moss (historical) | Civil | Arkansas | 5 | Columbia | 27 | 33.080691 | -93.1807216
63709 | Unorganized Territory of Shumaker (historical) | Census | Arkansas | 5 | [NAME] | 13 | 33.6278895 | -92.5876575 |  | 93375 | [NAME]
63755 | Arkansas County | Civil | Arkansas | 5 | Arkansas | 1 | 34.2891871 | -91.374222 | COUNTY | 99001 | H1
63756 | Ashley County | Civil | Arkansas | 5 | [NAME] | 3 | 33.1912047 | -91.7684539 | COUNTY | 99003 | H1
63757 | Bradley County | Civil | Arkansas | 5 | Bradley | 11 | 33.4664257 | -92.1623595 | COUNTY | 99011 | H1
63758 | Calhoun County | Civil | Arkansas | 5 | [NAME] | 13 | 33.5580688 | -92.5030229 | COUNTY | 99013 | H1
63759 | Clay County | Civil | Arkansas | 5 | Clay | 21 | 36.368346 | -90.4173718 | COUNTY | 99021 | H1
63760 | Cleveland County | Civil | Arkansas | 5 | Cleveland | 25 | 33.898373 | -92.1851418 | COUNTY | 99025 | H1
63761 | Columbia County | Civil | Arkansas | 5 | Columbia | 27 | 33.2142936 | -93.2273387 | COUNTY | 99027 | H1
64286 | Township of Bear (historical) | Civil | Arkansas | 5 | Garland | 51 | 34.5389792 | -93.279355
64293 | Township of Bucksville (historical) | Civil | Arkansas | 5 | Garland | 51 | 34.6375928 | -93.3640778
66844 | Township of Wallace | Civil | Arkansas | 5 | Little River | 81 | 33.6564586 | -94.3503978 |  | 93843 | Z1
66845 | Clark County | Civil | Arkansas | 5 | [NAME] | 19 | 34.050926 | -93.1763506 | COUNTY | 99019 | H1
66846 | Conway County | Civil | Arkansas | 5 | Conway | 29 | 35.262377 | -92.7014641 | COUNTY | 99029 | H1
66847 | Craighead County | Civil | Arkansas | 5 | Craighead | 31 | 35.8308078 | -90.6328538 | COUNTY | 99031 | H1
66848 | Cross County | Civil | Arkansas | 5 | Cross | 37 | 35.2957359 | -90.7711518 | COUNTY | 99037 | H1
66849 | Dallas County | Civil | Arkansas | 5 | Dallas | 39 | 33.9698896 | -92.6543986 | COUNTY | 99039 | H1
66850 | Desha County | Civil | Arkansas | 5 | Desha | 41 | 33.8309808 | -91.2549721 | COUNTY | 99041 | H1
68079 | Arbor Cove | Populated Place | Arkansas | 5 | Pulaski | 119 | 34.6867592 | -92.3445971
68085 | State of Arkansas | Civil | Arkansas | 5 | Pulaski | 119 | 34.8999171 | -92.4383739 | STATE
68087 | Arrowhead Manor | Populated Place | Arkansas | 5 | Pulaski | 119 | 34.8000911 | -92.2876507
77191 | Hiwasse | Census | Arkansas | 5 | [NAME] | 7 | 36.4317426 | -94.3338218 |  | 32530 | U4
118055 | Eunola | Census | Alabama | 1 | Geneva | 61 | 31.0399013 | -85.847435
165922 | Aliceville Division (historical) | Census | Alabama | 1 | Pickens | 107 | 33.115402 | -88.1778067
165926 | Raleigh Division (historical) | Census | Alabama | 1 | Pickens | 107 | 33.1948429 | -87.9589087
224036 | Garberville | Census | California | 6 | Humboldt | 23 | 40.1001449 | -123.795029
232715 | Scotia | Census | California | 6 | Humboldt | 23 | 40.4823573 | -124.1008808