United States Counties
For years I have wanted to tackle the onerous task of tallying all the counties in the United States of America. This project has finally finished in a spreadsheet that is 1817 rows tall and 57 rows wide. All states' counties were recorded under their respective state, then copied into a single column. Duplicate names were removed to get a comprehensive list of all the unique county names. Alaska's boroughs were included with the exception of Unorganized Borough. Virginia's independent cities were not counted. Hawaii's disputed Kalawao county was not counted. Data was current as of 4.13.11.
Want to track the counties you've been to? These guys have an app for that.
Statistics:
Counties: 3094
Average per state: 61
Mode: 67
Least in a state: Delaware, 3
Most in a state: Texas, 254
Standard Deviation: 45.90
Unique names: 1802
Names occurring once: 1366 (75.8%)
Names occurring multiple: 436
Average unique names per state: 1.72
First, alphabetically: Abbeville, SC
Last, alphabetically: Ziebach, SD
No representation: X (no Xavier, Xenia or Xerxes)
State with most unique names by count: TX: 153, 60.24% (GA: 64, 39.51%)
State with most unique names by percent: HI: 4, 100% (AK: 17, 94.44%)
State with least unique names by count: DE: 1, 33.33% (RI: 2, 40%)
State with least unique names by percent: IL: 22, 21.57% (TN: 21, 22.11%)