Wonder

Log in

Research Outline

Prepared for Caren B. | Delivered May 29, 2021

Northern California City with Highest Uninsured Target Population

Goals

Identify the city in Northern California that has the highest concentration of 25-40 year-olds making between $40,000-$75,000 that do not have healthcare.

Early Findings

Data Availability

  • Pre-compiled data on this topic is limited, but data sources are available separately for each part of the query (age/income/insured status) that could be combined to triangulate an answer to the query.

Early Findings

  • Northern California is comprised of the following counties: Alameda, Alpine, Amador, Butte, Calaveras, Colusa, Contra Costa, Del Norte, El Dorado, Fresno, Glenn, Humboldt, Inyo, Kings, Lake, Lassen, Maderal, Marin, Mariposa, Mendocino, Merced, Modoc, Mono, Monterey, Napa, Nevada, Placer, Plumas, Sacramento, San Benito, San Francisco, San Joaquin, San Mateo, Santa Clara, Santa Cruz, Shasta, Sierra, Siskiyou, Solano, Sonoma, Stanislaus, Sutter, Tehama, Trinity, Tulare, Tuolumne, Yolo and Yuba.
  • The uninsured rate by county for California can be found here. The highest percentage of uninsured people in California by far is in Del Norte, Lassen, Modoc, Plumas, and Siskiyou Counties at 10.6%, followed by Alpine, Amador, Calaveras, Inyo, Mariposa, Mono, and Tuolumne Counties at 5.4%.
  • A data table from the US Census Bureau showing the number of people in each county age 25-39 is available here.  
  • A data table from the US Census Bureau showing the number of people in each county making between $35,000 to $74,999 is available here.  

Research Summary

  • The research team began by looking for a pre-compiled list/answer to the query. This information was not available.
  • Next, we broke down the query into three separate data points that need to be found and then combined: California cities by their percentage of uninsured individuals, by their percentage of individuals aged 25-40, and finally by their percentage of individuals making $40,000-$75,000 per year.
  • The research team was unable to find a ranking of cities by their uninsured population. We were able to identify the percentage of uninsured people by county. We were also able to identify census bureau data showing the number of people in each county age 25-39 and data showing the number of people in each county making between $35,000 to $74,999 per year.
  • Further research is needed to combine and manipulate the three data sources in order to identify the county in Norther California with the highest uninsured population, the largest percentage of individuals aged 25-39 and the largest percentage of individuals making between $35,000 and $74,999 per year.