{"id":5653,"date":"2016-04-15T16:21:41","date_gmt":"2016-04-15T20:21:41","guid":{"rendered":"http:\/\/www.decisionsciencenews.com\/?p=5653"},"modified":"2016-04-15T16:27:33","modified_gmt":"2016-04-15T20:27:33","slug":"educated-counties-us","status":"publish","type":"post","link":"https:\/\/www.decisionsciencenews.com\/?p=5653","title":{"rendered":"What are the most educated counties in the US?"},"content":{"rendered":"<p>CENSUS DATA ON EDUCATIONAL ATTAINMENT BY COUNTY<\/p>\n<p style=\"text-align: center;\">\n<a href=\"http:\/\/www.decisionsciencenews.com\/2016\/04\/15\/educated-counties-us\/dc-2\/\" rel=\"attachment wp-att-5655\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5655\" src=\"http:\/\/www.decisionsciencenews.com\/wp-content\/uploads\/2016\/04\/dc.jpg\" alt=\"dc\" width=\"485\" height=\"362\" \/><\/a>\n<\/p>\n<p>People ask us &#8220;what are the most educated counties in the USA&#8221;? It turns out the <a href=\"https:\/\/www.census.gov\">census<\/a> keeps track of this sort of thing. We found a table called ACS_14_1YR_S1501.csv in the American Community Survey; look for stuff on educational attainment by county. And it was an easy bit of R to get the answers. We computed two things:<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>The percentage of the 25 and older population with a graduate or professional degree<\/li>\n<li>The percentage of the population (of any age) with a bachelor&#8217;s degree or higher<\/li>\n<\/ul>\n<p>Here&#8217;s how it came out:<\/p>\n<p><strong>Top US counties by percentage of people 25 and up with graduate or professional degrees in 2014:<br \/>\n<\/strong><\/p>\n<table border=\"1\">\n<tbody>\n<tr>\n<th>Rank<\/th>\n<th>County<\/th>\n<th>% with graduate degree<\/th>\n<\/tr>\n<tr>\n<td align=\"right\">1<\/td>\n<td>Arlington County, Virginia<\/td>\n<td align=\"right\">36.70<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">2<\/td>\n<td>Alexandria city, Virginia<\/td>\n<td align=\"right\">32.90<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">3<\/td>\n<td>Montgomery County, Maryland<\/td>\n<td align=\"right\">31.60<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">4<\/td>\n<td>District of Columbia, District of Columbia<\/td>\n<td align=\"right\">30.60<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">5<\/td>\n<td>Howard County, Maryland<\/td>\n<td align=\"right\">30.50<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">6<\/td>\n<td>Fairfax County, Virginia<\/td>\n<td align=\"right\">30.20<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">7<\/td>\n<td>Orange County, North Carolina<\/td>\n<td align=\"right\">30.00<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">8<\/td>\n<td>New York County, New York<\/td>\n<td align=\"right\">28.50<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">9<\/td>\n<td>Tompkins County, New York<\/td>\n<td align=\"right\">28.40<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">10<\/td>\n<td>Washtenaw County, Michigan<\/td>\n<td align=\"right\">28.30<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">11<\/td>\n<td>Boulder County, Colorado<\/td>\n<td align=\"right\">26.90<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">12<\/td>\n<td>Story County, Iowa<\/td>\n<td align=\"right\">26.00<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">13<\/td>\n<td>Middlesex County, Massachusetts<\/td>\n<td align=\"right\">25.70<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">14<\/td>\n<td>Marin County, California<\/td>\n<td align=\"right\">25.60<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">15<\/td>\n<td>Albemarle County, Virginia<\/td>\n<td align=\"right\">25.40<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">16<\/td>\n<td>Benton County, Oregon<\/td>\n<td align=\"right\">25.30<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">17<\/td>\n<td>Monroe County, Indiana<\/td>\n<td align=\"right\">25.20<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">18<\/td>\n<td>Loudoun County, Virginia<\/td>\n<td align=\"right\">24.80<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">19<\/td>\n<td>Riley County, Kansas<\/td>\n<td align=\"right\">23.90<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">20<\/td>\n<td>Johnson County, Iowa<\/td>\n<td align=\"right\">23.80<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">21<\/td>\n<td>Westchester County, New York<\/td>\n<td align=\"right\">23.60<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">22<\/td>\n<td>Somerset County, New Jersey<\/td>\n<td align=\"right\">23.50<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">23<\/td>\n<td>James City County, Virginia<\/td>\n<td align=\"right\">23.30<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">24<\/td>\n<td>Norfolk County, Massachusetts<\/td>\n<td align=\"right\">23.10<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">25<\/td>\n<td>Santa Clara County, California<\/td>\n<td align=\"right\">22.30<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong><br \/>\nTop US counties by percentage of people with Bachelors degrees or higher in 2014:<br \/>\n<\/strong><\/p>\n<table border=\"1\">\n<tbody>\n<tr>\n<th>Rank<\/th>\n<th>County<\/th>\n<th>% with Bachelors or higher<\/th>\n<\/tr>\n<tr>\n<td align=\"right\">1<\/td>\n<td>Arlington County, Virginia<\/td>\n<td align=\"right\">71.50<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">2<\/td>\n<td>Alexandria city, Virginia<\/td>\n<td align=\"right\">62.80<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">3<\/td>\n<td>Fairfax County, Virginia<\/td>\n<td align=\"right\">60.30<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">4<\/td>\n<td>Howard County, Maryland<\/td>\n<td align=\"right\">59.90<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">5<\/td>\n<td>New York County, New York<\/td>\n<td align=\"right\">59.90<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">6<\/td>\n<td>Loudoun County, Virginia<\/td>\n<td align=\"right\">58.70<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">7<\/td>\n<td>Montgomery County, Maryland<\/td>\n<td align=\"right\">58.50<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">8<\/td>\n<td>Boulder County, Colorado<\/td>\n<td align=\"right\">58.00<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">9<\/td>\n<td>Douglas County, Colorado<\/td>\n<td align=\"right\">56.50<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">10<\/td>\n<td>Hamilton County, Indiana<\/td>\n<td align=\"right\">56.30<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">11<\/td>\n<td>Williamson County, Tennessee<\/td>\n<td align=\"right\">56.10<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">12<\/td>\n<td>Marin County, California<\/td>\n<td align=\"right\">55.20<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">13<\/td>\n<td>District of Columbia, District of Columbia<\/td>\n<td align=\"right\">55.00<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">14<\/td>\n<td>Orange County, North Carolina<\/td>\n<td align=\"right\">55.00<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">15<\/td>\n<td>San Francisco County, California<\/td>\n<td align=\"right\">54.20<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">16<\/td>\n<td>Somerset County, New Jersey<\/td>\n<td align=\"right\">53.70<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">17<\/td>\n<td>Johnson County, Iowa<\/td>\n<td align=\"right\">53.60<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">18<\/td>\n<td>Benton County, Oregon<\/td>\n<td align=\"right\">53.50<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">19<\/td>\n<td>Washtenaw County, Michigan<\/td>\n<td align=\"right\">53.00<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">20<\/td>\n<td>Morris County, New Jersey<\/td>\n<td align=\"right\">53.00<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">21<\/td>\n<td>Johnson County, Kansas<\/td>\n<td align=\"right\">52.80<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">22<\/td>\n<td>Tompkins County, New York<\/td>\n<td align=\"right\">52.40<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">23<\/td>\n<td>Middlesex County, Massachusetts<\/td>\n<td align=\"right\">52.30<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">24<\/td>\n<td>Delaware County, Ohio<\/td>\n<td align=\"right\">52.20<\/td>\n<\/tr>\n<tr>\n<td align=\"right\">25<\/td>\n<td>Norfolk County, Massachusetts<\/td>\n<td align=\"right\">51.90<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>R Code to follow along at home<\/strong><\/p>\n<p><script src=\"https:\/\/gist.github.com\/dggoldst\/8b3fa30c600dad9f97cbc0687cfbde43.js\"><\/script><\/p>\n<p>Photo credit: https:\/\/flic.kr\/p\/aQM3Z<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The 25 US counties with the highest percentage of bachelors and graduate degrees.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[4,74],"tags":[1363,1362,1360,1346,1359,1364,1365,1208,70,1361,471,732],"class_list":["post-5653","post","type-post","status-publish","format-standard","hentry","category-encyclopedia","category-r","tag-attainment","tag-bachelors","tag-counties","tag-degrees","tag-educated","tag-graduate","tag-professional","tag-r","tag-statistics","tag-united-states","tag-us","tag-usa"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4LKj-1tb","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.decisionsciencenews.com\/index.php?rest_route=\/wp\/v2\/posts\/5653","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.decisionsciencenews.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.decisionsciencenews.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.decisionsciencenews.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.decisionsciencenews.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5653"}],"version-history":[{"count":4,"href":"https:\/\/www.decisionsciencenews.com\/index.php?rest_route=\/wp\/v2\/posts\/5653\/revisions"}],"predecessor-version":[{"id":5658,"href":"https:\/\/www.decisionsciencenews.com\/index.php?rest_route=\/wp\/v2\/posts\/5653\/revisions\/5658"}],"wp:attachment":[{"href":"https:\/\/www.decisionsciencenews.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.decisionsciencenews.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.decisionsciencenews.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}