scorecard_health_county_ranked
Health domain county scorecard with national and state percentile rankings. ~40 health metrics across mortality, access, behaviors, and environment with national and within-state percentile ranks.
tier —composite_index
overview
overview
All 3,222 US counties. Same source basket as scorecard_health_county; this version exposes the ranked columns.
current vintage — Mixed (matches base scorecard)
history — Snapshot only
provenance
source & licensing
authority
University of Wisconsin Population Health Institute
dataset
County Health Rankings
license
—
citation
County Health Rankings 2025 + CDC + EPA + NHTSA + CMS + ACS + SSA + HRSA - derived percentile ranks.
schema
fields
| name | type | definition |
|---|---|---|
| _ingested_at | timestamp | Timestamp when this record was written to BigQuery.Pipeline metadata field. |
| _reference_date | date | Pipeline metadata field.Pipeline metadata field. |
| _scorecard_version | string | Pipeline metadata field.Pipeline metadata field. |
| alcohol_mortality_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's alcohol-related mortality rate among all US counties nationally. Higher percentiles indicate worse performance relative to the national distribution. |
| alcohol_mortality_per_100k | float64 · rate per 100k | Age-adjusted mortality rate attributable to alcohol use per 100,000 residents, including liver disease and alcohol poisoning. Higher values indicate greater alcohol-related mortality burden. |
| alcohol_mortality_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's alcohol-related mortality rate among counties within the same state. Higher percentiles indicate worse performance relative to state peers. |
| cancer_mortality_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's cancer mortality rate among all US counties nationally. Higher percentiles indicate worse performance relative to the national distribution. |
| cancer_mortality_per_100k | float64 · rate per 100k | Age-adjusted cancer mortality rate per 100,000 residents. Higher values indicate a greater burden of cancer-related deaths. |
| cancer_mortality_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's cancer mortality rate among counties within the same state. Higher percentiles indicate worse performance relative to state peers. |
| cardiovascular_deaths_per_100k | float64 · rate per 100k | Age-adjusted cardiovascular disease mortality rate per 100,000 residents. Higher values indicate a greater burden of heart and circulatory disease deaths. |
| cardiovascular_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's cardiovascular death rate among all US counties nationally. Higher percentiles indicate worse performance relative to the national distribution. |
| cardiovascular_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's cardiovascular death rate among counties within the same state. Higher percentiles indicate worse performance relative to state peers. |
| checkup_access_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's share of adults lacking routine checkup access among all US counties nationally. Higher percentiles indicate worse access relative to the national distribution. |
| checkup_access_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's share of adults lacking routine checkup access among counties within the same state. Higher percentiles indicate worse access relative to state peers. |
| country_id | string | ISO alpha-2 country code (always 'US' for domestic tables). |
| county_idkey | string | 5-character FIPS code identifying the county.Joins dim.counties on county_id. |
| county_name | string | Human-readable county name corresponding to county_id. |
| deaths_of_despair_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's deaths-of-despair rate among all US counties nationally. Higher percentiles indicate worse performance relative to the national distribution. |
| deaths_of_despair_per_100k | float64 · rate per 100k | Combined age-adjusted mortality rate for drug overdose, suicide, and alcohol-related causes per 100,000 residents. Higher values reflect greater community-level social and economic distress. |
| deaths_of_despair_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's deaths-of-despair rate among counties within the same state. Higher percentiles indicate worse performance relative to state peers. |
| dentists_per_100k | float64 · rate per 100k | Number of dentists actively practicing in the county per 100,000 residents. Higher values indicate greater oral health care availability. |
| diabetes_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's adult diabetes prevalence among all US counties nationally. Higher percentiles indicate worse performance relative to the national distribution. |
| diabetes_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's adult diabetes prevalence among counties within the same state. Higher percentiles indicate worse performance relative to state peers. |
| drug_overdose_deaths_per_100k | float64 · rate per 100k | Age-adjusted drug overdose mortality rate per 100,000 residents. Higher values indicate a greater burden of fatal overdose events. |
| drug_overdose_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's drug overdose death rate among all US counties nationally. Higher percentiles indicate worse performance relative to the national distribution. |
| drug_overdose_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's drug overdose death rate among counties within the same state. Higher percentiles indicate worse performance relative to state peers. |
| dual_enrollment_pct | float64 · percent (0–100) | Percentage of Medicare beneficiaries who are also enrolled in Medicaid (dual-eligible). Higher values indicate greater concentration of low-income elderly and disabled residents. |
| er_visits_per_1000_benes | float64 · rate per 1,000 | Emergency department visits per 1,000 Medicare fee-for-service beneficiaries. Higher values may indicate greater acute care needs or barriers to primary care access. |
| fair_poor_health_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's share of adults reporting fair or poor health among all US counties nationally. Higher percentiles indicate worse performance relative to the national distribution. |
| fair_poor_health_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's share of adults reporting fair or poor health among counties within the same state. Higher percentiles indicate worse performance relative to state peers. |
| firearm_deaths_per_100k | float64 · rate per 100k | Age-adjusted firearm mortality rate per 100,000 residents, including homicide, suicide, and unintentional firearm deaths. Higher values indicate greater firearm-related mortality burden. |
| firearm_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's firearm death rate among all US counties nationally. Higher percentiles indicate worse performance relative to the national distribution. |
| firearm_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's firearm death rate among counties within the same state. Higher percentiles indicate worse performance relative to state peers. |
| frequent_mental_distress_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's frequent mental distress prevalence among all US counties nationally. Higher percentiles indicate worse performance relative to the national distribution. |
| frequent_mental_distress_pct | float64 · percent (0–100) | Percentage of adults who report 14 or more days of poor mental health in the past 30 days. Higher values indicate a greater population burden of mental health challenges. |
| frequent_mental_distress_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's frequent mental distress prevalence among counties within the same state. Higher percentiles indicate worse performance relative to state peers. |
| hcc_risk_score | float64 · index (base year=100) | Average Hierarchical Condition Category (HCC) risk score for Medicare beneficiaries, where 1.0 represents average national expected cost. Higher values indicate a sicker, higher-acuity beneficiary population relative to the national norm. |
| high_bp_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's adult high blood pressure prevalence among all US counties nationally. Higher percentiles indicate worse performance relative to the national distribution. |
| high_bp_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's adult high blood pressure prevalence among counties within the same state. Higher percentiles indicate worse performance relative to state peers. |
| infant_mortality_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's infant mortality rate among all US counties nationally; see infant_mortality_rate_unreliable before using for comparison. Higher percentiles indicate worse infant health outcomes relative to the national distribution. |
| infant_mortality_rate | float64 · rate per 100k | Number of deaths to infants under one year of age per 100,000 live births. Higher values indicate worse maternal and infant health outcomes; see infant_mortality_rate_unreliable for data reliability. |
| infant_mortality_rate_unreliable | bool | Boolean flag indicating that the infant_mortality_rate estimate is statistically unreliable, typically due to a small number of events. When true, the rate should not be used for ranking or comparison. |
| infant_mortality_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's infant mortality rate among counties within the same state; see infant_mortality_rate_unreliable before using for comparison. Higher percentiles indicate worse infant health outcomes relative to state peers. |
| leading_tracked_cause_of_death | string | Label identifying the single leading cause of death among the tracked mortality categories (e.g., cardiovascular disease, cancer, drug overdose) for the county in the reference period. |
| leading_tracked_cause_pct_of_tracked | float64 · percent (0–100) | Percentage of all deaths attributable to tracked causes that are accounted for by the leading tracked cause. Higher values indicate greater concentration of mortality in one cause category. |
| life_expectancy_tract_count | int64 · count | Number of census tracts contributing to the county-level life expectancy estimate. Low counts indicate the estimate is aggregated from fewer sub-county units and may be less precise. |
| life_expectancy_years | float64 · years | Estimated average number of years a person born in the county today would be expected to live, based on current age-specific mortality rates. Higher values indicate better overall population health outcomes. |
| low_birthweight_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's low birthweight rate among all US counties nationally. Higher percentiles indicate worse maternal and infant health outcomes relative to the national distribution. |
| low_birthweight_rate | float64 · percent (0–100) | Percentage of live births with a birthweight below 2,500 grams. Higher values indicate worse maternal health and prenatal care quality. |
| low_birthweight_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's low birthweight rate among counties within the same state. Higher percentiles indicate worse maternal and infant health outcomes relative to state peers. |
| median_age | float64 · years | Median age of county residents. Higher values indicate an older population, which generally correlates with greater healthcare utilization and chronic disease burden. |
| medicare_cost_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's standardized Medicare per-capita spending among all US counties nationally. Higher percentiles indicate higher healthcare cost intensity relative to the national distribution. |
| medicare_cost_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's standardized Medicare per-capita spending among counties within the same state. Higher percentiles indicate higher healthcare cost intensity relative to state peers. |
| medicare_standardized_per_capita | float64 · dollars (nominal) | Price-standardized Medicare fee-for-service spending per enrolled beneficiary, adjusted to remove regional price variation. Higher values indicate greater healthcare utilization or intensity of services among Medicare enrollees. |
| motor_vehicle_deaths_per_100k_crude | float64 · rate per 100k | Crude (not age-adjusted) motor vehicle crash mortality rate per 100,000 residents. Higher values indicate greater road safety risk; reported as crude rate due to data suppression constraints. |
| motor_vehicle_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's crude motor vehicle death rate among all US counties nationally. Higher percentiles indicate worse road safety relative to the national distribution. |
| motor_vehicle_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's crude motor vehicle death rate among counties within the same state. Higher percentiles indicate worse road safety relative to state peers. |
| obesity_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's adult obesity prevalence among all US counties nationally. Higher percentiles indicate worse performance relative to the national distribution. |
| obesity_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's adult obesity prevalence among counties within the same state. Higher percentiles indicate worse performance relative to state peers. |
| opioid_dispensing_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's opioid dispensing rate among all US counties nationally. Higher percentiles indicate greater opioid supply in the community relative to the national distribution. |
| opioid_dispensing_rate_per_100 | float64 · rate per 100 | Number of opioid prescriptions dispensed per 100 county residents per year. Higher values indicate greater opioid supply in the community, a key driver of overdose risk. |
| opioid_dispensing_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's opioid dispensing rate among counties within the same state. Higher percentiles indicate greater opioid supply in the community relative to state peers. |
| ozone_days_above_standard | float64 · count | Number of days per year on which the 8-hour ozone concentration exceeds the EPA National Ambient Air Quality Standard. Higher values indicate worse air quality and greater ozone-related health risk. |
| ozone_monitor_count | int64 · count | Number of EPA air quality monitoring stations measuring ozone in the county. Low counts may reduce the reliability of the ozone_days_above_standard estimate. |
| ozone_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's ozone exceedance days among all US counties nationally. Higher percentiles indicate worse air quality relative to the national distribution. |
| ozone_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's ozone exceedance days among counties within the same state. Higher percentiles indicate worse air quality relative to state peers. |
| pcp_density_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's primary care physician density among all US counties nationally. Higher percentiles indicate better primary care supply relative to the national distribution. |
| pcp_density_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's primary care physician density among counties within the same state. Higher percentiles indicate better primary care supply relative to state peers. |
| pct_adults_diabetes | float64 · percent (0–100) | Percentage of adults who report having been diagnosed with diabetes (excluding gestational diabetes). Higher values indicate greater prevalence of this chronic condition. |
| pct_adults_fair_poor_health | float64 · percent (0–100) | Percentage of adults who self-report their general health status as fair or poor. Higher values indicate worse overall perceived population health. |
| pct_adults_high_bp | float64 · percent (0–100) | Percentage of adults who report having been diagnosed with high blood pressure or hypertension. Higher values indicate greater cardiovascular disease risk burden. |
| pct_adults_no_checkup_access | float64 · percent (0–100) | Percentage of adults who report not having seen a doctor for a routine checkup in the past year. Higher values indicate reduced preventive care utilization and access. |
| pct_adults_obesity | float64 · percent (0–100) | Percentage of adults with a body mass index (BMI) of 30 or greater, derived from self-reported height and weight. Higher values indicate greater obesity prevalence. |
| pct_age_65_plus | float64 · percent (0–100) | Percentage of the county population aged 65 or older. Used as a demographic covariate when interpreting age-sensitive health metrics. |
| pct_any_disability | float64 · percent (0–100) | Percentage of the civilian non-institutionalized population reporting any disability (cognitive, ambulatory, hearing, vision, self-care, or independent living). Higher values indicate greater functional limitation burden. |
| pct_mortality_metrics_suppressed | float64 · percent (0–100) | Percentage of the county's mortality metrics that were suppressed due to small cell counts or other reliability thresholds. Higher values indicate that the county's mortality profile is based on fewer observable data points and may be less complete. |
| pct_places_metrics_low_confidence | float64 · percent (0–100) | Percentage of CDC PLACES model-based health behavior and outcome metrics for the county flagged as low confidence. Higher values indicate that behavioral health estimates carry greater uncertainty. |
| pct_uninsured | float64 · percent (0–100) | Percentage of the civilian non-institutionalized population without health insurance coverage. Higher values indicate greater barriers to healthcare access. |
| pm25_annual_avg | float64 · micrograms per cubic meter | Annual average concentration of fine particulate matter (PM2.5) in the air, averaged across monitoring stations in the county. Higher values indicate worse air quality and greater respiratory health risk. |
| pm25_monitor_count | int64 · count | Number of EPA air quality monitoring stations measuring PM2.5 in the county. Low counts may reduce the reliability of the pm25_annual_avg estimate. |
| pm25_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's annual average PM2.5 concentration among all US counties nationally. Higher percentiles indicate worse air quality relative to the national distribution. |
| pm25_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's annual average PM2.5 concentration among counties within the same state. Higher percentiles indicate worse air quality relative to state peers. |
| premature_death_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's premature death (YPLL) rate among all US counties nationally. Higher percentiles indicate worse performance relative to the national distribution. |
| premature_death_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's premature death (YPLL) rate among counties within the same state. Higher percentiles indicate worse performance relative to state peers. |
| premature_death_ypll_per_100k | float64 · rate per 100k | Years of Potential Life Lost (YPLL) before age 75 per 100,000 residents, age-adjusted. Higher values indicate a greater burden of premature mortality in the county. |
| primary_care_physicians_per_100k | float64 · rate per 100k | Number of primary care physicians actively practicing in the county per 100,000 residents. Higher values indicate greater primary care availability and access. |
| psychiatrist_density_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's psychiatrist density among all US counties nationally. Higher percentiles indicate better mental health specialty supply relative to the national distribution. |
| psychiatrist_density_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's psychiatrist density among counties within the same state. Higher percentiles indicate better mental health specialty supply relative to state peers. |
| psychiatrists_per_100k | float64 · rate per 100k | Number of psychiatrists actively practicing in the county per 100,000 residents. Higher values indicate greater mental health specialty care availability. |
| readmission_rate_30d | float64 · percent (0–100) | Percentage of Medicare fee-for-service hospital stays followed by a readmission within 30 days. Higher values indicate poorer care transitions and post-discharge management. |
| ssdi_beneficiaries_per_1k_workforce_proxy | float64 · rate per 1,000 | Social Security Disability Insurance (SSDI) beneficiaries per 1,000 working-age residents, used as a proxy for the county's workforce-age disability burden. Higher values indicate greater functional limitation in the labor-force-aged population. |
| ssdi_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's SSDI beneficiary rate among all US counties nationally. Higher percentiles indicate greater workforce-age disability burden relative to the national distribution. |
| ssdi_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's SSDI beneficiary rate among counties within the same state. Higher percentiles indicate greater workforce-age disability burden relative to state peers. |
| state_id | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| suicide_deaths_per_100k | float64 · rate per 100k | Age-adjusted suicide mortality rate per 100,000 residents. Higher values indicate a greater burden of suicide-related death. |
| suicide_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's suicide death rate among all US counties nationally. Higher percentiles indicate worse performance relative to the national distribution. |
| suicide_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's suicide death rate among counties within the same state. Higher percentiles indicate worse performance relative to state peers. |
| teen_birth_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's teen birth share among all US counties nationally. Higher percentiles indicate worse performance relative to the national distribution. |
| teen_birth_share_pct | float64 · percent (0–100) | Percentage of all live births in the county in which the mother was aged 15–19. Higher values reflect higher teen birth rates and associated socioeconomic risk factors. |
| teen_birth_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's teen birth share among counties within the same state. Higher percentiles indicate worse performance relative to state peers. |
| tobacco_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's adult tobacco use rate among all US counties nationally. Higher percentiles indicate worse performance relative to the national distribution. |
| tobacco_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's adult tobacco use rate among counties within the same state. Higher percentiles indicate worse performance relative to state peers. |
| tobacco_use_adult | float64 · percent (0–100) | Percentage of adults who currently use any tobacco product. Higher values indicate greater population exposure to tobacco-related health risks. |
| total_population | int64 · count | Estimated total resident population of the county. Used as the denominator basis for per-capita and per-100k rate calculations. |
| uninsured_national_pctile | float64 · percentile (0–100) | Percentile rank of the county's uninsured rate among all US counties nationally. Higher percentiles indicate worse performance relative to the national distribution. |
| uninsured_state_pctile | float64 · percentile (0–100) | Percentile rank of the county's uninsured rate among counties within the same state. Higher percentiles indicate worse performance relative to state peers. |
relationships
joins
primary key
county_id
common joins
dim.geographies on county_id
scorecard_health_county on county_id
usage
how to use this table
method
PERCENT_RANK() over national and within-state partitions for each of ~40 metrics.
do not use for
Cross-domain ranking comparison without acknowledgment of underlying tier mix; raw rate analysis (use base scorecard).
known issues
Percentile of a Tier C metric is still Tier C - ranks don't upgrade reliability.
last updated · May 5, 2026