Diabetes Demographics

According to the Centers for Disease Control and Prevention (CDC), about half of all US adults have at least one chronic condition and one quarter of all adults have at least two chronic conditions. Moreover, chronic diseases and conditions are the most common, costly and preventable of all conditions (CDC, 2015). In fact, 86% of all health care spending in 2010 was for individuals with at least one chronic health condition. Diabetes is one such chronic condition. The total estimated cost of diagnosed diabetes in 2012 was $245 billion, including $176 billion in direct medical costs and $69 billion in decreased productivity (CDC, 2015).

The purpose of this analysis is to compare diabetes rates and poverty, race, age, education level, insurance rates, unemployment rates, health care access, Medicare reimbursement rates and number of Medicare enrollees for each county and state.

This scenario includes benchmarks for each appropriate variable. State-level benchmarks are accessible by filtering by state. Scenarios with multiple outcome variables require filtering by the specific outcome to return the corresponding benchmarks.

View the data >

Tutorial: Using the Data

Data Sources

County Health Ranking (data released 2017)

Dartmouth Health Atlas - Medicare Reimbursements/Enrollee (data released 2016)

Defining the Columns

A blank entry indicates unreported data. A value of zero is a defined value and does not represent unreported data.

State: The abbreviated name of the state where the county is located.

County: The name of the county where the information was collected. County names are listed as provided on the US Census Bureau's list of 2010 FIPS Codes for Counties and County Equivalent Entities.

Population Size: The total number of individuals residing in the county. This data is derived from the Census Population Estimates from 2015.

Medicare Enrollees: The total number of Medicare beneficiaries age 65-99 in the county for 2014 enrolled in both Medicare Parts A and B. Patients enrolled in risk-bearing health maintenance organizations (HMOs) are excluded.

Medicare Reimbursements/Enrollee: The average Medicare reimbursement for 100% of the claims for each county in 2014.

Diabetes Rate: The percentage of the county’s population that have diabetes. The measure is provided by the CDC Diabetes Interactive Atlas from 2013.

Child Poverty Rate: The percentage of children in the population who fall below the poverty level obtained from Small Area Income Poverty Estimates (SAIPE) in 2015.

Percent Asian: The proportion of the county’s population that falls into the racial or ethnic category of Asian from the US Census Bureau Population Estimates from 2015.

Percent Black: The proportion of the county’s population that falls into the racial or ethnic category of Black from the US Census Bureau Population Estimates from 2015.

Percent Hispanic: The proportion of the county’s population that falls into the racial or ethnic category of Hispanic from the US Census Bureau Population Estimates from 2015.

Percent Native American: The proportion of the county’s population that falls into the racial or ethnic category of Native American from the US Census Bureau Population Estimates from 2015.

Percent White: The proportion of the county’s population that falls into the racial or ethnic category of White from the US Census Bureau Population Estimates from 2015.

Percent Age <18: The proportion of the county’s population that falls into the age category of less than 18 years old from the US Census Bureau Population Estimates from 2015.

Percent Age 65 and Older: The proportion of the county’s population that falls into the age category of 65 years old and older from the US Census Bureau Population Estimates from 2015.

Percent With HS Diploma: The estimated number individuals in the county with a high school (HS) diploma from the US Department of Education's EDFacts data from 2014-2015.

Percent Uninsured: The estimated percentage of individuals in the county under age 65 without health insurance. Data is from the Small Area Health Insurance Estimates Program (SAHIE) from 2014.

Percent Unemployed: The estimated percentage of individuals in the county who had no employment, were available for work and had made specific efforts to find employment. The number is from the annual US Bureau of Labor Statistics’ Labor Force Data in 2015.

Primary Care Physicians: The number of primary care providers per 100,000 population. The data is derived from the Small Area Resource File and the American Medical Association from 2014.

View the data >

Tutorial: Using Excel Output