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.

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%)

Most common county names (10 or more):
  • Washington, 31
  • Jefferson, 26
  • Franklin, 25
  • Jackson, 24
  • Lincoln, 24
  • Madison, 20
  • Clay, 18
  • Montgomery, 18
  • Union, 18
  • Marion, 17
  • Monroe, 17
  • Wayne, 16
  • Grant, 15
  • Warren, 14
  • Carroll, 13
  • Clark, 13 (including Clarke, 17)
  • Greene, 13 (including Green, 16)
  • Adams, 12
  • Douglas, 12
  • Johnson, 12
  • Lake, 12
  • Lee, 12
  • Marshall, 12
  • Polk, 12
  • Calhoun, 11
  • Crawford, 11
  • Fayette, 11
  • Morgan, 11
  • Scott, 11
  • Hamilton, 10
  • Hancock, 10
  • Henry, 10
  • Lawrence, 10
  • Logan, 10
  • Perry, 10
  • Pike, 10

State names as counties:

  • Arkansas, AR
  • Colorado, TX
  • Delaware, IN; IA; NY; OH; OK; PA
  • Hawaii, HI
  • Idaho, ID
  • Indiana, PA
  • Iowa, Iowa; WI
  • Mississippi, AR; MO
  • Nevada, AR; CA
  • New York, NY
  • Ohio, IN; KY; WV
  • Oklahoma, OK
  • Oregon, MO
  • Texas, MO; OK
  • Utah, UT
  • Washington, AL; AR; CO; FL; GA; ID; IL; IN; IA; KS; KY; LA; ME; MD; MN; MS; MO; NE; NY; NC; OH; OK; OR; PA; RI; TN; TX; UT; VA; VT; WI
  • Wyoming, NY; PA; WV
  • Most Honored State: Delaware (6) (in all fairness, Washington is a person)
  • Most Stately State: 5 way tie between AR, MO, NY, OK, PA (4 state named counties each)
Full names as county names:
  • Anne Arundel, MD
  • Ben Hill, GA
  • Charles Mix, SD
  • Deaf Smith, TX
  • Doña Ana, NM
  • Jeff Davis, GA; TX
  • Jefferson Davis, LA; MS
  • Jim Hogg, TX
  • Jim Wells, TX
  • Kit Carson, CO
  • Roger Mills, OK
  • San Luis Obispo, CA
  • Tom Green, TX

Counties honoring saints:

  • San Augustine, TX
  • San Benito, CA
  • San Bernardino, CA
  • San Diego, CA
  • San Francisco, CA
  • San Jacinto, TX
  • San Joaquin, CA
  • San Juan, CO; NM; UT; WA
  • San Luis Obispo, CA
  • San Mateo, CA
  • San Miguel, CO; NM
  • San Patricio, TX
  • San Saba, TX
  • Santa Barbara, CA
  • Santa Clara, CA
  • Santa Cruz, AZ; CA
  • Santa Fe, NM
  • Santa Rosa, FL
  • St. Bernard, LA
  • St. Charles, LA; MO
  • St. Clair, AL; IL; MI; MO
  • St. Croix, WI
  • St. Francis, AR
  • St. Francois, MO
  • St. Helena, LA
  • St. James, LA
  • St. John, LA
  • St. Johns, FL
  • St. Joseph, IN; MI
  • St. Landry, LA
  • St. Lawrence, NY
  • St. Louis, MN; MO
  • St. Lucie, FL
  • St. Martin, LA
  • St. Mary, LA
  • St. Mary's, MD
  • St. Tammany, LA
  • Ste. Genevieve, MO
  • Most Honored Saint: San Juan (4)
  • Most Pious State: CA (10)