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.

View the data >

Tutorial: Using the Data

Data Sources

Community Health Status Indicators (data released 2009)

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 Name: The name of the county where the information was collected. County names are listed as provided on the United States Census Bureau's list of 2010 FIPS Codes for Counties and County Equivalient Entities.

Population Size: The total number of individuals residing in the county. This data is a mid-year estimate of resident population for 2008

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 Behavioral Risk Factor Surveillance System (BRFSS), 2000-2006, survey. Data is only provided for counties with more than 50 respondents to the BRFSS survey

Poverty Rate: The percentage of the total population who fall below the poverty level obtained from Small Area Income Poverty Estimates (SAIPE) in 2008

Percent Asian: The proportion of the county’s population that falls into the racial or ethnic category of Asian from US Census Bureau mid-year estimates of the resident population of 2008

Percent Black: The proportion of the county’s population that falls into the racial or ethnic category of Black from US Census Bureau mid-year estimates of the resident population of 2008

Percent Hispanic: The proportion of the county’s population that falls into the racial or ethnic category of Hispanic from US Census Bureau mid-year estimates of the resident population of 2008

Percent Native American: The proportion of the county’s population that falls into the racial or ethnic category of Native American from US Census Bureau mid-year estimates of the resident population of 2008

Percent White: The proportion of the county’s population that falls into the racial or ethnic category of White from US Census Bureau mid-year estimates of the resident population of 2008

Percent Age <19: The proportion of the county’s population that falls into the age category of less than 19 years old from US Census Bureau mid-year estimates of the resident population of 2008

Percent Age 19-64: The proportion of the county’s population that falls into the age category of 19 to 64 years old from US Census Bureau mid-year estimates of the resident population of 2008

Percent Age 65-84: The proportion of the county’s population that falls into the age category of 65 to 84 years old from US Census Bureau mid-year estimates of the resident population of 2008

Percent Age >84: The proportion of the county’s population that falls into the age category of greater than 84 years old from US Census Bureau mid-year estimates of the resident population of 2008

Without HS Diploma: The estimated number individuals in the county without a high school (HS) diploma from US Census Bureau mid-year estimates of the resident population of 2008

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

Unemployed: The estimated number 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 2008

HPSA: These are counties that have been designated as single-county, primary medical care, health professional shortage areas, as determined by the US Secretary of Health and Human Services, current as of September 30, 2009. A zero (0) represents "No" indicating that the county is not HPSA-designated while a one (1) represents "Yes" indicating that the county is HPSA-designated

View the data >

Tutorial: Using Excel Output