Created
January 5, 2014 22:34
-
-
Save JoeGermuska/8274958 to your computer and use it in GitHub Desktop.
Low earning counties: find all tracts in the US where no one earns more than $50K a year, and list the counties they are contained by and the median income for that county. Source: Table B19001 'Household Income in the Past 12 Months (In 2012 Inflation-adjusted Dollars)' American Community Survey as loaded in Census Reporter Postgres database (h…
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select c.geoid, c.name, d2.B19013001, count(*) | |
| from acs2012_5yr.geoheader c, | |
| acs2012_5yr.geoheader g, | |
| acs2012_5yr.B19001 d, | |
| acs2012_5yr.B19013 d2 | |
| where B19001011 = 0 | |
| and B19001012 = 0 | |
| and B19001013 = 0 | |
| and B19001014 = 0 | |
| and B19001015 = 0 | |
| and B19001016 = 0 | |
| and B19001017 = 0 | |
| and d.geoid = g.geoid | |
| and g.sumlevel = '140' | |
| and c.sumlevel = '050' | |
| and c.state = g.state | |
| and c.county = g.county | |
| and c.geoid = d2.geoid | |
| group by c.geoid, c.name, d2.B19013001 | |
| order by d2.B19013001, count(*) desc; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| geoid | name | b19013001 | count | |
| --------------+--------------------------------------------+-----------+------- | |
| 05000US72123 | Salinas Municipio, Puerto Rico | 13386 | 1 | |
| 05000US72055 | Guánica Municipio, Puerto Rico | 13567 | 1 | |
| 05000US72079 | Lajas Municipio, Puerto Rico | 13698 | 1 | |
| 05000US72115 | Quebradillas Municipio, Puerto Rico | 14255 | 1 | |
| 05000US72071 | Isabela Municipio, Puerto Rico | 14570 | 1 | |
| 05000US72059 | Guayanilla Municipio, Puerto Rico | 14679 | 1 | |
| 05000US72109 | Patillas Municipio, Puerto Rico | 14777 | 1 | |
| 05000US72017 | Barceloneta Municipio, Puerto Rico | 15034 | 1 | |
| 05000US72097 | Mayagüez Municipio, Puerto Rico | 15060 | 2 | |
| 05000US72003 | Aguada Municipio, Puerto Rico | 15106 | 1 | |
| 05000US72005 | Aguadilla Municipio, Puerto Rico | 15302 | 2 | |
| 05000US72111 | Peñuelas Municipio, Puerto Rico | 15541 | 1 | |
| 05000US72023 | Cabo Rojo Municipio, Puerto Rico | 16003 | 2 | |
| 05000US72095 | Maunabo Municipio, Puerto Rico | 16043 | 1 | |
| 05000US72015 | Arroyo Municipio, Puerto Rico | 16114 | 1 | |
| 05000US72049 | Culebra Municipio, Puerto Rico | 16375 | 1 | |
| 05000US72145 | Vega Baja Municipio, Puerto Rico | 16462 | 1 | |
| 05000US72117 | Rincón Municipio, Puerto Rico | 16548 | 1 | |
| 05000US72147 | Vieques Municipio, Puerto Rico | 16598 | 1 | |
| 05000US72103 | Naguabo Municipio, Puerto Rico | 16706 | 1 | |
| 05000US72011 | Añasco Municipio, Puerto Rico | 16771 | 1 | |
| 05000US72075 | Juana Díaz Municipio, Puerto Rico | 16938 | 1 | |
| 05000US72013 | Arecibo Municipio, Puerto Rico | 17077 | 1 | |
| 05000US72113 | Ponce Municipio, Puerto Rico | 17459 | 1 | |
| 05000US72057 | Guayama Municipio, Puerto Rico | 17496 | 1 | |
| 05000US72091 | Manatí Municipio, Puerto Rico | 17513 | 1 | |
| 05000US72143 | Vega Alta Municipio, Puerto Rico | 17616 | 1 | |
| 05000US72027 | Camuy Municipio, Puerto Rico | 17762 | 1 | |
| 05000US72033 | Cataño Municipio, Puerto Rico | 17780 | 10 | |
| 05000US72151 | Yabucoa Municipio, Puerto Rico | 17926 | 1 | |
| 05000US72133 | Santa Isabel Municipio, Puerto Rico | 18024 | 1 | |
| 05000US72065 | Hatillo Municipio, Puerto Rico | 18669 | 1 | |
| 05000US72087 | Loíza Municipio, Puerto Rico | 19100 | 1 | |
| 05000US72069 | Humacao Municipio, Puerto Rico | 19918 | 1 | |
| 05000US72089 | Luquillo Municipio, Puerto Rico | 20084 | 1 | |
| 05000US72037 | Ceiba Municipio, Puerto Rico | 20455 | 2 | |
| 05000US72053 | Fajardo Municipio, Puerto Rico | 21194 | 1 | |
| 05000US72119 | Río Grande Municipio, Puerto Rico | 22491 | 1 | |
| 05000US72127 | San Juan Municipio, Puerto Rico | 23100 | 14 | |
| 05000US72137 | Toa Baja Municipio, Puerto Rico | 23572 | 1 | |
| 05000US45089 | Williamsburg County, South Carolina | 25174 | 1 | |
| 05000US48489 | Willacy County, Texas | 26369 | 1 | |
| 05000US45061 | Lee County, South Carolina | 27755 | 1 | |
| 05000US72051 | Dorado Municipio, Puerto Rico | 28530 | 1 | |
| 05000US72031 | Carolina Municipio, Puerto Rico | 29470 | 2 | |
| 05000US47029 | Cocke County, Tennessee | 29764 | 1 | |
| 05000US28143 | Tunica County, Mississippi | 30463 | 1 | |
| 05000US51590 | Danville city, Virginia | 30505 | 1 | |
| 05000US45029 | Colleton County, South Carolina | 31289 | 1 | |
| 05000US48061 | Cameron County, Texas | 32558 | 3 | |
| 05000US48215 | Hidalgo County, Texas | 33218 | 1 | |
| 05000US45027 | Clarendon County, South Carolina | 33267 | 1 | |
| 05000US26131 | Ontonagon County, Michigan | 33769 | 1 | |
| 05000US51025 | Brunswick County, Virginia | 33859 | 1 | |
| 05000US12093 | Okeechobee County, Florida | 34289 | 1 | |
| 05000US36005 | Bronx County, New York | 34300 | 6 | |
| 05000US51131 | Northampton County, Virginia | 34304 | 1 | |
| 05000US26053 | Gogebic County, Michigan | 34397 | 1 | |
| 05000US12107 | Putnam County, Florida | 34429 | 1 | |
| 05000US26061 | Houghton County, Michigan | 34453 | 2 | |
| 05000US12123 | Taylor County, Florida | 34634 | 1 | |
| 05000US04012 | La Paz County, Arizona | 35093 | 1 | |
| 05000US12075 | Levy County, Florida | 35093 | 1 | |
| 05000US12043 | Glades County, Florida | 35219 | 1 | |
| 05000US21061 | Edmonson County, Kentucky | 35243 | 1 | |
| 05000US12055 | Highlands County, Florida | 35350 | 3 | |
| 05000US26069 | Iosco County, Michigan | 35396 | 1 | |
| 05000US12029 | Dixie County, Florida | 35476 | 1 | |
| 05000US47017 | Carroll County, Tennessee | 35595 | 1 | |
| 05000US12051 | Hendry County, Florida | 35736 | 1 | |
| 05000US45011 | Barnwell County, South Carolina | 35748 | 1 | |
| 05000US17109 | McDonough County, Illinois | 35812 | 1 | |
| 05000US23029 | Washington County, Maine | 36486 | 1 | |
| 05000US45053 | Jasper County, South Carolina | 36504 | 1 | |
| 05000US22071 | Orleans Parish, Louisiana | 36681 | 5 | |
| 05000US26001 | Alcona County, Michigan | 36931 | 1 | |
| 05000US26011 | Arenac County, Michigan | 36937 | 2 | |
| 05000US47053 | Gibson County, Tennessee | 36981 | 1 | |
| 05000US42101 | Philadelphia County, Pennsylvania | 37016 | 9 | |
| 05000US51670 | Hopewell city, Virginia | 37029 | 1 | |
| 05000US55051 | Iron County, Wisconsin | 37112 | 1 | |
| 05000US41045 | Malheur County, Oregon | 37191 | 1 | |
| 05000US48261 | Kenedy County, Texas | 37206 | 1 | |
| 05000US54011 | Cabell County, West Virginia | 37238 | 1 | |
| 05000US12037 | Franklin County, Florida | 37428 | 2 | |
| 05000US26153 | Schoolcraft County, Michigan | 37468 | 1 | |
| 05000US48041 | Brazos County, Texas | 37638 | 1 | |
| 05000US21047 | Christian County, Kentucky | 37750 | 2 | |
| 05000US48375 | Potter County, Texas | 37848 | 1 | |
| 05000US41011 | Coos County, Oregon | 37853 | 1 | |
| 05000US48273 | Kleberg County, Texas | 38058 | 1 | |
| 05000US47031 | Coffee County, Tennessee | 38151 | 1 | |
| 05000US26031 | Cheboygan County, Michigan | 38166 | 1 | |
| 05000US18035 | Delaware County, Indiana | 38215 | 1 | |
| 05000US28067 | Jones County, Mississippi | 38233 | 1 | |
| 05000US26107 | Mecosta County, Michigan | 38332 | 1 | |
| 05000US26003 | Alger County, Michigan | 38348 | 1 | |
| 05000US41015 | Curry County, Oregon | 38401 | 1 | |
| 05000US21143 | Lyon County, Kentucky | 38414 | 1 | |
| 05000US48479 | Webb County, Texas | 38421 | 1 | |
| 05000US51081 | Greensville County, Virginia | 38423 | 1 | |
| 05000US26097 | Mackinac County, Michigan | 38507 | 1 | |
| 05000US18105 | Monroe County, Indiana | 38675 | 1 | |
| 05000US48253 | Jones County, Texas | 38896 | 1 | |
| 05000US22073 | Ouachita Parish, Louisiana | 38899 | 1 | |
| 05000US26007 | Alpena County, Michigan | 38900 | 1 | |
| 05000US12017 | Citrus County, Florida | 39034 | 1 | |
| 05000US26141 | Presque Isle County, Michigan | 39109 | 1 | |
| 05000US32023 | Nye County, Nevada | 39150 | 1 | |
| 05000US55003 | Ashland County, Wisconsin | 39157 | 1 | |
| 05000US20209 | Wyandotte County, Kansas | 39163 | 8 | |
| 05000US13191 | McIntosh County, Georgia | 39506 | 2 | |
| 05000US12045 | Gulf County, Florida | 39535 | 1 | |
| 05000US26013 | Baraga County, Michigan | 39594 | 1 | |
| 05000US51183 | Sussex County, Virginia | 39603 | 1 | |
| 05000US06015 | Del Norte County, California | 39626 | 1 | |
| 05000US26127 | Oceana County, Michigan | 39667 | 1 | |
| 05000US48141 | El Paso County, Texas | 39699 | 1 | |
| 05000US12083 | Marion County, Florida | 39770 | 2 | |
| 05000US26151 | Sanilac County, Michigan | 40019 | 1 | |
| 05000US13183 | Long County, Georgia | 40044 | 1 | |
| 05000US01015 | Calhoun County, Alabama | 40093 | 1 | |
| 05000US41019 | Douglas County, Oregon | 40096 | 1 | |
| 05000US47161 | Stewart County, Tennessee | 40200 | 2 | |
| 05000US26057 | Gratiot County, Michigan | 40224 | 1 | |
| 05000US05091 | Miller County, Arkansas | 40314 | 1 | |
| 05000US26063 | Huron County, Michigan | 40349 | 1 | |
| 05000US22017 | Caddo Parish, Louisiana | 40497 | 1 | |
| 05000US48465 | Val Verde County, Texas | 40509 | 1 | |
| 05000US22087 | St. Bernard Parish, Louisiana | 40590 | 1 | |
| 05000US22101 | St. Mary Parish, Louisiana | 40738 | 1 | |
| 05000US51001 | Accomack County, Virginia | 40780 | 4 | |
| 05000US30067 | Park County, Montana | 40781 | 1 | |
| 05000US24510 | Baltimore city, Maryland | 40803 | 2 | |
| 05000US06023 | Humboldt County, California | 40830 | 1 | |
| 05000US26121 | Muskegon County, Michigan | 40843 | 1 | |
| 05000US26109 | Menominee County, Michigan | 40865 | 1 | |
| 05000US53049 | Pacific County, Washington | 40873 | 1 | |
| 05000US08043 | Fremont County, Colorado | 40893 | 3 | |
| 05000US26105 | Mason County, Michigan | 40957 | 1 | |
| 05000US39101 | Marion County, Ohio | 40966 | 1 | |
| 05000US39007 | Ashtabula County, Ohio | 41075 | 1 | |
| 05000US12053 | Hernando County, Florida | 41098 | 1 | |
| 05000US26033 | Chippewa County, Michigan | 41114 | 5 | |
| 05000US04027 | Yuma County, Arizona | 41156 | 3 | |
| 05000US12065 | Jefferson County, Florida | 41163 | 1 | |
| 05000US26101 | Manistee County, Michigan | 41228 | 1 | |
| 05000US28081 | Lee County, Mississippi | 41242 | 1 | |
| 05000US39095 | Lucas County, Ohio | 41436 | 1 | |
| 05000US13215 | Muscogee County, Georgia | 41443 | 1 | |
| 05000US26163 | Wayne County, Michigan | 41504 | 10 | |
| 05000US55075 | Marinette County, Wisconsin | 41533 | 1 | |
| 05000US24039 | Somerset County, Maryland | 41558 | 2 | |
| 05000US48309 | McLennan County, Texas | 41589 | 1 | |
| 05000US45041 | Florence County, South Carolina | 41738 | 1 | |
| 05000US08101 | Pueblo County, Colorado | 41820 | 3 | |
| 05000US41057 | Tillamook County, Oregon | 41869 | 1 | |
| 05000US36013 | Chautauqua County, New York | 41975 | 1 | |
| 05000US41041 | Lincoln County, Oregon | 41996 | 1 | |
| 05000US17087 | Johnson County, Illinois | 42027 | 1 | |
| 05000US37087 | Haywood County, North Carolina | 42089 | 1 | |
| 05000US36003 | Allegany County, New York | 42095 | 1 | |
| 05000US45051 | Horry County, South Carolina | 42183 | 2 | |
| 05000US26083 | Keweenaw County, Michigan | 42406 | 1 | |
| 05000US26095 | Luce County, Michigan | 42414 | 2 | |
| 05000US53027 | Grays Harbor County, Washington | 42440 | 1 | |
| 05000US45043 | Georgetown County, South Carolina | 42472 | 1 | |
| 05000US26041 | Delta County, Michigan | 42504 | 2 | |
| 05000US13063 | Clayton County, Georgia | 42569 | 1 | |
| 05000US41039 | Lane County, Oregon | 42628 | 1 | |
| 05000US26049 | Genesee County, Michigan | 42730 | 2 | |
| 05000US56001 | Albany County, Wyoming | 42882 | 1 | |
| 05000US01097 | Mobile County, Alabama | 42973 | 3 | |
| 05000US47179 | Washington County, Tennessee | 42995 | 1 | |
| 05000US36025 | Delaware County, New York | 43004 | 1 | |
| 05000US47145 | Roane County, Tennessee | 43017 | 1 | |
| 05000US51155 | Pulaski County, Virginia | 43072 | 2 | |
| 05000US48321 | Matagorda County, Texas | 43146 | 1 | |
| 05000US26009 | Antrim County, Michigan | 43171 | 1 | |
| 05000US36009 | Cattaraugus County, New York | 43202 | 1 | |
| 05000US47155 | Sevier County, Tennessee | 43300 | 1 | |
| 05000US20161 | Riley County, Kansas | 43364 | 1 | |
| 05000US42063 | Indiana County, Pennsylvania | 43408 | 1 | |
| 05000US12127 | Volusia County, Florida | 43419 | 1 | |
| 05000US37173 | Swain County, North Carolina | 43426 | 1 | |
| 05000US26157 | Tuscola County, Michigan | 43463 | 1 | |
| 05000US12086 | Miami-Dade County, Florida | 43464 | 14 | |
| 05000US26021 | Berrien County, Michigan | 43471 | 1 | |
| 05000US42079 | Luzerne County, Pennsylvania | 43486 | 1 | |
| 05000US28047 | Harrison County, Mississippi | 43593 | 2 | |
| 05000US55079 | Milwaukee County, Wisconsin | 43599 | 3 | |
| 05000US12105 | Polk County, Florida | 43606 | 1 | |
| 05000US37095 | Hyde County, North Carolina | 43608 | 2 | |
| 05000US18163 | Vanderburgh County, Indiana | 43645 | 1 | |
| 05000US06045 | Mendocino County, California | 43721 | 1 | |
| 05000US28045 | Hancock County, Mississippi | 43727 | 1 | |
| 05000US36089 | St. Lawrence County, New York | 43745 | 1 | |
| 05000US48245 | Jefferson County, Texas | 43750 | 4 | |
| 05000US12101 | Pasco County, Florida | 43787 | 1 | |
| 05000US06107 | Tulare County, California | 43803 | 1 | |
| 05000US12033 | Escambia County, Florida | 43806 | 1 | |
| 05000US37137 | Pamlico County, North Carolina | 43825 | 1 | |
| 05000US39035 | Cuyahoga County, Ohio | 43861 | 7 | |
| 05000US39113 | Montgomery County, Ohio | 43895 | 1 | |
| 05000US12111 | St. Lucie County, Florida | 43923 | 2 | |
| 05000US48303 | Lubbock County, Texas | 43993 | 1 | |
| 05000US18157 | Tippecanoe County, Indiana | 44047 | 1 | |
| 05000US37141 | Pender County, North Carolina | 44071 | 1 | |
| 05000US21221 | Trigg County, Kentucky | 44144 | 2 | |
| 05000US47001 | Anderson County, Tennessee | 44154 | 1 | |
| 05000US51710 | Norfolk city, Virginia | 44164 | 4 | |
| 05000US51121 | Montgomery County, Virginia | 44166 | 1 | |
| 05000US18095 | Madison County, Indiana | 44245 | 1 | |
| 05000US22019 | Calcasieu Parish, Louisiana | 44247 | 2 | |
| 05000US12131 | Walton County, Florida | 44254 | 1 | |
| 05000US13179 | Liberty County, Georgia | 44295 | 1 | |
| 05000US48451 | Tom Green County, Texas | 44310 | 1 | |
| 05000US41007 | Clatsop County, Oregon | 44330 | 1 | |
| 05000US22113 | Vermilion Parish, Louisiana | 44339 | 1 | |
| 05000US48441 | Taylor County, Texas | 44372 | 3 | |
| 05000US45003 | Aiken County, South Carolina | 44399 | 1 | |
| 05000US26159 | Van Buren County, Michigan | 44425 | 1 | |
| 05000US12015 | Charlotte County, Florida | 44596 | 1 | |
| 05000US22045 | Iberia Parish, Louisiana | 44611 | 1 | |
| 05000US55007 | Bayfield County, Wisconsin | 44626 | 1 | |
| 05000US48007 | Aransas County, Texas | 44769 | 1 | |
| 05000US30101 | Toole County, Montana | 45057 | 1 | |
| 05000US40109 | Oklahoma County, Oklahoma | 45082 | 1 | |
| 05000US48057 | Calhoun County, Texas | 45122 | 1 | |
| 05000US36047 | Kings County, New York | 45215 | 14 | |
| 05000US48183 | Gregg County, Texas | 45233 | 1 | |
| 05000US42049 | Erie County, Pennsylvania | 45249 | 2 | |
| 05000US12061 | Indian River County, Florida | 45274 | 2 | |
| 05000US19193 | Woodbury County, Iowa | 45289 | 1 | |
| 05000US26103 | Marquette County, Michigan | 45349 | 1 | |
| 05000US55031 | Douglas County, Wisconsin | 45370 | 1 | |
| 05000US37051 | Cumberland County, North Carolina | 45413 | 4 | |
| 05000US26065 | Ingham County, Michigan | 45567 | 8 | |
| 05000US48485 | Wichita County, Texas | 45589 | 1 | |
| 05000US13051 | Chatham County, Georgia | 45653 | 3 | |
| 05000US06019 | Fresno County, California | 45741 | 1 | |
| 05000US02198 | Prince of Wales-Hyder Census Area, Alaska | 45774 | 1 | |
| 05000US37133 | Onslow County, North Carolina | 45812 | 2 | |
| 05000US12073 | Leon County, Florida | 45915 | 1 | |
| 05000US12103 | Pinellas County, Florida | 46051 | 2 | |
| 05000US26017 | Bay County, Michigan | 46068 | 1 | |
| 05000US05119 | Pulaski County, Arkansas | 46102 | 1 | |
| 05000US24019 | Dorchester County, Maryland | 46199 | 1 | |
| 05000US37081 | Guilford County, North Carolina | 46223 | 1 | |
| 05000US27137 | St. Louis County, Minnesota | 46231 | 1 | |
| 05000US47157 | Shelby County, Tennessee | 46251 | 5 | |
| 05000US51740 | Portsmouth city, Virginia | 46269 | 1 | |
| 05000US40031 | Comanche County, Oklahoma | 46320 | 1 | |
| 05000US47009 | Blount County, Tennessee | 46347 | 1 | |
| 05000US53009 | Clallam County, Washington | 46431 | 1 | |
| 05000US04019 | Pima County, Arizona | 46443 | 1 | |
| 05000US37019 | Brunswick County, North Carolina | 46490 | 1 | |
| 05000US48355 | Nueces County, Texas | 46499 | 2 | |
| 05000US37089 | Henderson County, North Carolina | 46503 | 1 | |
| 05000US47065 | Hamilton County, Tennessee | 46544 | 3 | |
| 05000US36045 | Jefferson County, New York | 46549 | 2 | |
| 05000US26075 | Jackson County, Michigan | 46572 | 1 | |
| 05000US47037 | Davidson County, Tennessee | 46676 | 4 | |
| 05000US21111 | Jefferson County, Kentucky | 46701 | 1 | |
| 05000US51175 | Southampton County, Virginia | 46703 | 1 | |
| 05000US42119 | Union County, Pennsylvania | 46737 | 3 | |
| 05000US53031 | Jefferson County, Washington | 46870 | 1 | |
| 05000US37093 | Hoke County, North Carolina | 46900 | 1 | |
| 05000US39043 | Erie County, Ohio | 46906 | 1 | |
| 05000US12119 | Sumter County, Florida | 46981 | 2 | |
| 05000US29095 | Jackson County, Missouri | 47023 | 4 | |
| 05000US53071 | Walla Walla County, Washington | 47166 | 1 | |
| 05000US26029 | Charlevoix County, Michigan | 47177 | 1 | |
| 05000US27075 | Lake County, Minnesota | 47210 | 1 | |
| 05000US47093 | Knox County, Tennessee | 47270 | 1 | |
| 05000US36075 | Oswego County, New York | 47288 | 1 | |
| 05000US48423 | Smith County, Texas | 47312 | 1 | |
| 05000US12005 | Bay County, Florida | 47364 | 1 | |
| 05000US26019 | Benzie County, Michigan | 47491 | 1 | |
| 05000US37031 | Carteret County, North Carolina | 47506 | 3 | |
| 05000US36039 | Greene County, New York | 47539 | 1 | |
| 05000US17201 | Winnebago County, Illinois | 47573 | 1 | |
| 05000US26067 | Ionia County, Michigan | 47580 | 1 | |
| 05000US23013 | Knox County, Maine | 47714 | 1 | |
| 05000US06029 | Kern County, California | 47727 | 4 | |
| 05000US36063 | Niagara County, New York | 47736 | 2 | |
| 05000US18091 | LaPorte County, Indiana | 47754 | 1 | |
| 05000US26147 | St. Clair County, Michigan | 47877 | 1 | |
| 05000US12081 | Manatee County, Florida | 47910 | 1 | |
| 05000US36015 | Chemung County, New York | 48128 | 1 | |
| 05000US12035 | Flagler County, Florida | 48134 | 1 | |
| 05000US06109 | Tuolumne County, California | 48169 | 1 | |
| 05000US22033 | East Baton Rouge Parish, Louisiana | 48274 | 1 | |
| 05000US45079 | Richland County, South Carolina | 48420 | 4 | |
| 05000US12095 | Orange County, Florida | 48429 | 1 | |
| 05000US12071 | Lee County, Florida | 48453 | 2 | |
| 05000US22051 | Jefferson Parish, Louisiana | 48522 | 3 | |
| 05000US23009 | Hancock County, Maine | 48635 | 1 | |
| 05000US55029 | Door County, Wisconsin | 48707 | 1 | |
| 05000US06031 | Kings County, California | 48761 | 2 | |
| 05000US12115 | Sarasota County, Florida | 48900 | 1 | |
| 05000US12031 | Duval County, Florida | 48906 | 1 | |
| 05000US08031 | Denver County, Colorado | 49091 | 2 | |
| 05000US12009 | Brevard County, Florida | 49099 | 3 | |
| 05000US39061 | Hamilton County, Ohio | 49104 | 1 | |
| 05000US48029 | Bexar County, Texas | 49141 | 4 | |
| 05000US36065 | Oneida County, New York | 49148 | 5 | |
| 05000US48113 | Dallas County, Texas | 49159 | 2 | |
| 05000US18089 | Lake County, Indiana | 49315 | 1 | |
| 05000US12057 | Hillsborough County, Florida | 49450 | 11 | |
| 05000US47125 | Montgomery County, Tennessee | 49459 | 1 | |
| 05000US51103 | Lancaster County, Virginia | 49516 | 1 | |
| 05000US22109 | Terrebonne Parish, Louisiana | 49545 | 1 | |
| 05000US19169 | Story County, Iowa | 49683 | 1 | |
| 05000US42027 | Centre County, Pennsylvania | 49706 | 2 | |
| 05000US28059 | Jackson County, Mississippi | 49750 | 1 | |
| 05000US37077 | Granville County, North Carolina | 49893 | 1 | |
| 05000US36029 | Erie County, New York | 49977 | 6 | |
| 05000US13127 | Glynn County, Georgia | 49986 | 1 | |
| 05000US48027 | Bell County, Texas | 50085 | 3 | |
| 05000US55071 | Manitowoc County, Wisconsin | 50091 | 1 | |
| 05000US48469 | Victoria County, Texas | 50097 | 1 | |
| 05000US48099 | Coryell County, Texas | 50104 | 1 | |
| 05000US36073 | Orleans County, New York | 50113 | 1 | |
| 05000US45019 | Charleston County, South Carolina | 50289 | 1 | |
| 05000US27031 | Cook County, Minnesota | 50309 | 1 | |
| 05000US37129 | New Hanover County, North Carolina | 50420 | 2 | |
| 05000US23015 | Lincoln County, Maine | 50494 | 1 | |
| 05000US12085 | Martin County, Florida | 50573 | 2 | |
| 05000US22057 | Lafourche Parish, Louisiana | 50574 | 1 | |
| 05000US42003 | Allegheny County, Pennsylvania | 50664 | 9 | |
| 05000US26047 | Emmet County, Michigan | 50686 | 1 | |
| 05000US39049 | Franklin County, Ohio | 50700 | 1 | |
| 05000US01003 | Baldwin County, Alabama | 50706 | 1 | |
| 05000US55083 | Oconto County, Wisconsin | 50763 | 1 | |
| 05000US36011 | Cayuga County, New York | 50950 | 1 | |
| 05000US37063 | Durham County, North Carolina | 50997 | 2 | |
| 05000US26005 | Allegan County, Michigan | 51030 | 1 | |
| 05000US13089 | DeKalb County, Georgia | 51252 | 2 | |
| 05000US45015 | Berkeley County, South Carolina | 51476 | 1 | |
| 05000US34011 | Cumberland County, New Jersey | 51530 | 4 | |
| 05000US48473 | Waller County, Texas | 51576 | 1 | |
| 05000US51053 | Dinwiddie County, Virginia | 51582 | 1 | |
| 05000US41051 | Multnomah County, Oregon | 51582 | 1 | |
| 05000US51650 | Hampton city, Virginia | 51584 | 1 | |
| 05000US12011 | Broward County, Florida | 51603 | 2 | |
| 05000US26055 | Grand Traverse County, Michigan | 51641 | 1 | |
| 05000US39093 | Lorain County, Ohio | 51756 | 1 | |
| 05000US53021 | Franklin County, Washington | 51770 | 1 | |
| 05000US31109 | Lancaster County, Nebraska | 51810 | 3 | |
| 05000US51133 | Northumberland County, Virginia | 51911 | 1 | |
| 05000US15001 | Hawaii County, Hawaii | 52098 | 17 | |
| 05000US26087 | Lapeer County, Michigan | 52369 | 1 | |
| 05000US45091 | York County, South Carolina | 52571 | 1 | |
| 05000US10005 | Sussex County, Delaware | 52692 | 1 | |
| 05000US25025 | Suffolk County, Massachusetts | 52700 | 11 | |
| 05000US36055 | Monroe County, New York | 52700 | 3 | |
| 05000US53055 | San Juan County, Washington | 52712 | 1 | |
| 05000US12099 | Palm Beach County, Florida | 52806 | 9 | |
| 05000US55117 | Sheboygan County, Wisconsin | 52967 | 1 | |
| 05000US27123 | Ramsey County, Minnesota | 53152 | 2 | |
| 05000US48201 | Harris County, Texas | 53160 | 3 | |
| 05000US31055 | Douglas County, Nebraska | 53295 | 1 | |
| 05000US12129 | Wakulla County, Florida | 53385 | 1 | |
| 05000US12087 | Monroe County, Florida | 53418 | 3 | |
| 05000US55009 | Brown County, Wisconsin | 53419 | 1 | |
| 05000US39173 | Wood County, Ohio | 53441 | 1 | |
| 05000US36117 | Wayne County, New York | 53497 | 1 | |
| 05000US26099 | Macomb County, Michigan | 53628 | 4 | |
| 05000US45063 | Lexington County, South Carolina | 53644 | 1 | |
| 05000US39129 | Pickaway County, Ohio | 53750 | 1 | |
| 05000US21029 | Bullitt County, Kentucky | 53922 | 1 | |
| 05000US26089 | Leelanau County, Michigan | 53982 | 1 | |
| 05000US32510 | Carson City, Nevada | 53987 | 1 | |
| 05000US32031 | Washoe County, Nevada | 53994 | 6 | |
| 05000US12091 | Okaloosa County, Florida | 54118 | 2 | |
| 05000US13039 | Camden County, Georgia | 54155 | 1 | |
| 05000US36051 | Livingston County, New York | 54244 | 1 | |
| 05000US04013 | Maricopa County, Arizona | 54385 | 11 | |
| 05000US34001 | Atlantic County, New Jersey | 54559 | 1 | |
| 05000US24043 | Washington County, Maryland | 54561 | 1 | |
| 05000US26115 | Monroe County, Michigan | 54588 | 1 | |
| 05000US56021 | Laramie County, Wyoming | 54596 | 1 | |
| 05000US24029 | Kent County, Maryland | 54614 | 1 | |
| 05000US17031 | Cook County, Illinois | 54648 | 5 | |
| 05000US06071 | San Bernardino County, California | 54750 | 3 | |
| 05000US40027 | Cleveland County, Oklahoma | 54883 | 1 | |
| 05000US55101 | Racine County, Wisconsin | 54900 | 1 | |
| 05000US34013 | Essex County, New Jersey | 55027 | 2 | |
| 05000US47149 | Rutherford County, Tennessee | 55105 | 1 | |
| 05000US55059 | Kenosha County, Wisconsin | 55117 | 1 | |
| 05000US37135 | Orange County, North Carolina | 55241 | 1 | |
| 05000US51115 | Mathews County, Virginia | 55590 | 1 | |
| 05000US55061 | Kewaunee County, Wisconsin | 55611 | 1 | |
| 05000US51119 | Middlesex County, Virginia | 55625 | 1 | |
| 05000US23023 | Sagadahoc County, Maine | 55634 | 1 | |
| 05000US26139 | Ottawa County, Michigan | 55760 | 1 | |
| 05000US37055 | Dare County, North Carolina | 55780 | 2 | |
| 05000US10001 | Kent County, Delaware | 55786 | 1 | |
| 05000US37119 | Mecklenburg County, North Carolina | 55961 | 3 | |
| 05000US25005 | Bristol County, Massachusetts | 55995 | 1 | |
| 05000US12021 | Collier County, Florida | 56104 | 1 | |
| 05000US39085 | Lake County, Ohio | 56231 | 1 | |
| 05000US06037 | Los Angeles County, California | 56241 | 31 | |
| 05000US34009 | Cape May County, New Jersey | 56370 | 1 | |
| 05000US48453 | Travis County, Texas | 56403 | 3 | |
| 05000US53057 | Skagit County, Washington | 56457 | 1 | |
| 05000US45013 | Beaufort County, South Carolina | 56581 | 1 | |
| 05000US08123 | Weld County, Colorado | 56589 | 1 | |
| 05000US08001 | Adams County, Colorado | 56633 | 1 | |
| 05000US23031 | York County, Maine | 56656 | 1 | |
| 05000US36081 | Queens County, New York | 56780 | 23 | |
| 05000US48439 | Tarrant County, Texas | 56859 | 1 | |
| 05000US06065 | Riverside County, California | 57096 | 2 | |
| 05000US23005 | Cumberland County, Maine | 57159 | 1 | |
| 05000US12089 | Nassau County, Florida | 57163 | 1 | |
| 05000US22075 | Plaquemines Parish, Louisiana | 57386 | 1 | |
| 05000US37053 | Currituck County, North Carolina | 57446 | 1 | |
| 05000US12113 | Santa Rosa County, Florida | 57491 | 1 | |
| 05000US08041 | El Paso County, Colorado | 57531 | 1 | |
| 05000US34031 | Passaic County, New Jersey | 57540 | 1 | |
| 05000US13121 | Fulton County, Georgia | 57664 | 3 | |
| 05000US19153 | Polk County, Iowa | 58096 | 1 | |
| 05000US35043 | Sandoval County, New Mexico | 58116 | 1 | |
| 05000US24047 | Worcester County, Maryland | 58138 | 2 | |
| 05000US34017 | Hudson County, New Jersey | 58722 | 1 | |
| 05000US34033 | Salem County, New Jersey | 59336 | 1 | |
| 05000US36001 | Albany County, New York | 59359 | 1 | |
| 05000US48329 | Midland County, Texas | 59391 | 1 | |
| 05000US53029 | Island County, Washington | 59500 | 1 | |
| 05000US49035 | Salt Lake County, Utah | 59626 | 2 | |
| 05000US06079 | San Luis Obispo County, California | 59628 | 2 | |
| 05000US49049 | Utah County, Utah | 59864 | 1 | |
| 05000US06053 | Monterey County, California | 60143 | 3 | |
| 05000US53005 | Benton County, Washington | 60300 | 1 | |
| 05000US25001 | Barnstable County, Massachusetts | 60424 | 1 | |
| 05000US22103 | St. Tammany Parish, Louisiana | 60813 | 1 | |
| 05000US42041 | Cumberland County, Pennsylvania | 60883 | 2 | |
| 05000US34029 | Ocean County, New Jersey | 61038 | 3 | |
| 05000US17113 | McLean County, Illinois | 61049 | 1 | |
| 05000US32005 | Douglas County, Nevada | 61099 | 1 | |
| 05000US25015 | Hampshire County, Massachusetts | 61264 | 1 | |
| 05000US51087 | Henrico County, Virginia | 61300 | 1 | |
| 05000US48167 | Galveston County, Texas | 61555 | 1 | |
| 05000US53035 | Kitsap County, Washington | 61776 | 1 | |
| 05000US55025 | Dane County, Wisconsin | 61790 | 2 | |
| 05000US44003 | Kent County, Rhode Island | 61884 | 1 | |
| 05000US49045 | Tooele County, Utah | 61933 | 1 | |
| 05000US09009 | New Haven County, Connecticut | 62234 | 1 | |
| 05000US22023 | Cameron Parish, Louisiana | 62353 | 1 | |
| 05000US18127 | Porter County, Indiana | 62457 | 3 | |
| 05000US06083 | Santa Barbara County, California | 62723 | 2 | |
| 05000US24041 | Talbot County, Maryland | 62942 | 1 | |
| 05000US53067 | Thurston County, Washington | 63224 | 1 | |
| 05000US06073 | San Diego County, California | 63373 | 5 | |
| 05000US06097 | Sonoma County, California | 63565 | 1 | |
| 05000US13029 | Bryan County, Georgia | 63818 | 1 | |
| 05000US50007 | Chittenden County, Vermont | 63900 | 1 | |
| 05000US15009 | Maui County, Hawaii | 64058 | 4 | |
| 05000US42045 | Delaware County, Pennsylvania | 64242 | 1 | |
| 05000US11001 | District of Columbia, District of Columbia | 64267 | 3 | |
| 05000US12109 | St. Johns County, Florida | 64346 | 2 | |
| 05000US10003 | New Castle County, Delaware | 64670 | 2 | |
| 05000US15007 | Kauai County, Hawaii | 64752 | 4 | |
| 05000US09003 | Hartford County, Connecticut | 64752 | 3 | |
| 05000US26125 | Oakland County, Michigan | 65637 | 1 | |
| 05000US37183 | Wake County, North Carolina | 65826 | 2 | |
| 05000US25007 | Dukes County, Massachusetts | 65896 | 1 | |
| 05000US25027 | Worcester County, Massachusetts | 65968 | 1 | |
| 05000US51810 | Virginia Beach city, Virginia | 65980 | 1 | |
| 05000US24005 | Baltimore County, Maryland | 66068 | 4 | |
| 05000US15005 | Kalawao County, Hawaii | 66250 | 1 | |
| 05000US06087 | Santa Cruz County, California | 66571 | 1 | |
| 05000US25009 | Essex County, Massachusetts | 66918 | 1 | |
| 05000US21015 | Boone County, Kentucky | 67125 | 1 | |
| 05000US29165 | Platte County, Missouri | 67419 | 1 | |
| 05000US36091 | Saratoga County, New York | 67712 | 1 | |
| 05000US48039 | Brazoria County, Texas | 68008 | 1 | |
| 05000US09011 | New London County, Connecticut | 68310 | 1 | |
| 05000US53061 | Snohomish County, Washington | 68338 | 2 | |
| 05000US36061 | New York County, New York | 68370 | 9 | |
| 05000US08059 | Jefferson County, Colorado | 68748 | 2 | |
| 05000US06095 | Solano County, California | 69006 | 2 | |
| 05000US06055 | Napa County, California | 69571 | 1 | |
| 05000US44005 | Newport County, Rhode Island | 69826 | 1 | |
| 05000US06017 | El Dorado County, California | 70117 | 1 | |
| 05000US33011 | Hillsborough County, New Hampshire | 70472 | 1 | |
| 05000US53033 | King County, Washington | 71175 | 1 | |
| 05000US29183 | St. Charles County, Missouri | 71416 | 1 | |
| 05000US36027 | Dutchess County, New York | 71508 | 2 | |
| 05000US06001 | Alameda County, California | 71516 | 2 | |
| 05000US39165 | Warren County, Ohio | 72055 | 1 | |
| 05000US15003 | Honolulu County, Hawaii | 72292 | 11 | |
| 05000US44009 | Washington County, Rhode Island | 72391 | 2 | |
| 05000US06061 | Placer County, California | 73356 | 1 | |
| 05000US36085 | Richmond County, New York | 73496 | 2 | |
| 05000US34021 | Mercer County, New Jersey | 73759 | 1 | |
| 05000US06075 | San Francisco County, California | 73802 | 2 | |
| 05000US25023 | Plymouth County, Massachusetts | 74722 | 2 | |
| 05000US20091 | Johnson County, Kansas | 75139 | 3 | |
| 05000US48071 | Chambers County, Texas | 75200 | 2 | |
| 05000US06059 | Orange County, California | 75566 | 2 | |
| 05000US55089 | Ozaukee County, Wisconsin | 75854 | 1 | |
| 05000US17197 | Will County, Illinois | 76352 | 1 | |
| 05000US06111 | Ventura County, California | 76483 | 2 | |
| 05000US09007 | Middlesex County, Connecticut | 76659 | 1 | |
| 05000US02185 | North Slope Borough, Alaska | 76679 | 1 | |
| 05000US42017 | Bucks County, Pennsylvania | 76859 | 1 | |
| 05000US33015 | Rockingham County, New Hampshire | 77939 | 2 | |
| 05000US06013 | Contra Costa County, California | 78187 | 1 | |
| 05000US42091 | Montgomery County, Pennsylvania | 78984 | 1 | |
| 05000US17097 | Lake County, Illinois | 79085 | 2 | |
| 05000US08014 | Broomfield County, Colorado | 80483 | 3 | |
| 05000US27163 | Washington County, Minnesota | 80747 | 2 | |
| 05000US09013 | Tolland County, Connecticut | 80887 | 1 | |
| 05000US36119 | Westchester County, New York | 81093 | 6 | |
| 05000US25017 | Middlesex County, Massachusetts | 81420 | 1 | |
| 05000US51199 | York County, Virginia | 82454 | 1 | |
| 05000US09001 | Fairfield County, Connecticut | 82614 | 1 | |
| 05000US25019 | Nantucket County, Massachusetts | 83546 | 1 | |
| 05000US48157 | Fort Bend County, Texas | 84211 | 1 | |
| 05000US34025 | Monmouth County, New Jersey | 84746 | 1 | |
| 05000US24037 | St. Mary's County, Maryland | 85032 | 1 | |
| 05000US51735 | Poquoson city, Virginia | 85033 | 1 | |
| 05000US24035 | Queen Anne's County, Maryland | 86013 | 3 | |
| 05000US42029 | Chester County, Pennsylvania | 86184 | 1 | |
| 05000US24003 | Anne Arundel County, Maryland | 86987 | 3 | |
| 05000US06081 | San Mateo County, California | 87751 | 2 | |
| 05000US36103 | Suffolk County, New York | 87778 | 1 | |
| 05000US06041 | Marin County, California | 90962 | 2 | |
| 05000US24009 | Calvert County, Maryland | 92395 | 1 | |
| 05000US24017 | Charles County, Maryland | 93063 | 1 | |
| 05000US51153 | Prince William County, Virginia | 96160 | 1 | |
| 05000US36059 | Nassau County, New York | 97049 | 8 | |
| 05000US51013 | Arlington County, Virginia | 102459 | 2 | |
| 05000US51059 | Fairfax County, Virginia | 109383 | 3 | |
| 05000US51107 | Loudoun County, Virginia | 122068 | 1 | |
| (537 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment