Prepared for Caren B. | Delivered May 29, 2021
Northern California City with Highest Uninsured Target Population
Review your project details
Identify the city in Northern California that has the highest concentration of 25-40 year-
making between $40,000-$75,000 that do not have healthcare.
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.
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,
, Sonoma, Stanislaus, Sutter, Tehama, Trinity, Tulare, Tuolumne, Yolo and Yuba.
The uninsured rate by county for California can be found
. The highest percentage of uninsured people in California by far is in Del Norte, Lassen, Modoc, Plumas, and Siskiyou Counties at
, followed by Alpine, Amador, Calaveras, Inyo, Mariposa, Mono, and Tuolumne Counties at
A data table from the US Census Bureau showing the number of people in each county age 25-39 is available
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
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
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.
Your research manager recommends working with a
3572 assignments | 5.0