How is your county doing, where could it do better, what’s been changing, and among similar counties, who does best?OnlyBoth has launched a County Benchmarking Engine as its newest showcase application and public service, leveraging the availability of federal as well as private-sector data on all 3,143 U.S. counties. We collected data on 104 county attributes by these topics:
- obesity and diabetes from the CDC
- population, migration, national origin, veterans, race, age, education, households, home ownership, income, poverty, jobs, unemployment, land area, oil and gas production, land area, and various county classifications, all from the USDA’s Economic Research Service
- apartment rents from HUD
- religious affiliations from ARDA (Association of Religion Data Archives)
- health-plan enrollments through HealthCare.gov
- water usage from USGS
- farmland from DHHS’s Health Resources and Services Administration
- arrests from the DOJ’s FBI (archived at Univ Michigan’s ICPSR)
Here’s an example of an “Only, both”-style insight about Bronx County in New York City:
Only Bronx County in NY has both as high a median rent for a 3-bedroom unit ($2,293) and as low a median household income ($33,687).
The flip side, for a 1-bedroom apartment this time, is seen in Audubon County, Iowa (population 5,773) about 1,200 miles away:
Only Audubon County in IA has both as high a per-capita income ($30,714) and as low a median rent for a 1-bedroom unit ($474.00).
Notably, San Francisco County in CA is among the top-15 nationwide in all these 9 categories, in order of their appearance:
- 3rd-highest Asian population (33.0%)
- 10th-least male obesity (14.8%)
- 10th-most residents employed in services (71.8%)
- 8th-highest foreign-born population (35.5%)
- 11th-highest per-capita income ($49,986)
- 11th-least obesity (15.5%)
- 10th-biggest advantage, relative to its home state, in per-capita income (+67.1%)
- 12th-least female obesity (16.1%)
- 13th-least owner-occupied housing (36.6%)
but residents pay for it with the highest median rents in the whole country, for a 0-bedroom (studio/efficiency) unit ($2,072), a 1-bedroom unit ($2,610), and a 3-bedroom unit ($4,250).
Re-visiting New York city, let’s consider this time New York County (i.e., Manhattan). It’s doing well on many dimensions, although unsurprisingly its rents are high. But there’s a residual problem:
Of the 103 counties that have at least $75,459 in median household income, only New York County in NY has decades-long substantial child poverty.
Let’s close out on a high note. Many of the data attributes involve changes over time, so the engine benchmarks not only on characteristics during a single time period, but on changes or trends from one period to a next. Elsewhere we’ve called that space-time benchmarking. Here’s a good outcome on the populous Fairfax county in Virginia, adjacent to Washington DC:
Fairfax County in VA is one of only 3 counties that improved or maxed out on all the obesity and diabetes change metrics (there are 4 of these, and each county needs at least 3 with actual values to qualify).
Fairfax County in VA improved or maxed out on these:
change over 4 years in the prevalence of female obesity = -2.2% (from 22.5% to 20.3%)
change over 4 years in the prevalence of male obesity = -0.5% (from 20.4% to 19.9%)
change over 4 years in the prevalence of obesity = -1.4% (from 21.5% to 20.1%)
change over 9 years in the prevalence of diabetes = -0.4% (from 6.6% to 6.2%)
As we’ve seen, it’s now possible, after a few days of software configuration, to create significant economic or social value by generating numerous performance insights on thousands of benchmarked entities, and later update these insights by figuratively pushing a button to update the insights with updated data.
Try the County Benchmarking Engine yourself at county.onlyboth.com.