In this tutorial video, we look at Diabetes Demographics. The video guides you through how to use Tableau data analysis to compare diabetes rates and population age for each county and state.
A blank entry indicates unreported data. A value of zero is defined 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 2020 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 2020.
Medicare Enrollees: The total number of Medicare beneficiaries aged 65-99 in the county for 2019 enrolled in 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 2019.
Diabetes Rate: The percentage of the county's population that have diabetes. The CDC Diabetes Interactive Atlas provides the measure from 2018.
Child Poverty Rate: The percentage of children who fall below the poverty level obtained from Small Area Income Poverty Estimates (SAIPE) in 2020.
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 2020.
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 2020.
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 2020.
Percent Native Hawaiian or Other Pacific Islander: The proportion of the county's population that falls into the racial or ethnic category of Native Hawaiian or Other Pacific Islander from the US Census Bureau Population Estimates from 2020.
Percent Native American: The proportion of the county's population falling into the racial or ethnic category of Native American from the US Census Bureau Population Estimates from 2020.
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 2020.
Percent Age <18: The proportion of the county's population that falls into the age category of fewer than 18 years old from the US Census Bureau Population Estimates from 2020.
Percent Age 65 and Older: The proportion of the county's population falling into the age category of 65 years old and older from the US Census Bureau Population Estimates from 2020.
Percent With HS Diploma: The estimated number of individuals in the county with a high school (HS) diploma from the US Department of Education EDFacts data from 2019-2020.
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 2019.
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 2020.
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 2020.
Population Type: An indication of whether a county is predominantly metropolitan, micropolitan, or rural.
