County Health Status Profiles
State of California
@usgov.ca_gov_county_health_status_profiles_7e184
State of California
@usgov.ca_gov_county_health_status_profiles_7e184
County Health Status Profiles is an annually published report for the State of California by the California Department of Public Health in collaboration with the California Conference of Local Health Officers. Health indicators are measured for 58 counties and California statewide that can be directly compared to national standards and populations of similar composition. Where available, the measurements are ranked and compared with target rates established for Healthy People National Objectives.
For tables where the health indicator denominator and numerator are derived from the same data source, the denominator excludes records for which the health indicator data is missing and unable to be imputed.
For more information see the County Health Status Profiles report.
Organization: State of California
Last updated: 2025-09-23T12:48:44.299716
Tags: births, california-department-of-public-health, cdph, chsi, county, deaths, health-indicators, healthy-people, infant-mortality, morbidity, mortality, vital-statistics
CREATE TABLE county_health_status_profiles_2021_tables_1_29 (
"publication_year" BIGINT,
"table" VARCHAR,
"health_indicator_desc" VARCHAR,
"strata" VARCHAR,
"strata_name" VARCHAR,
"county" VARCHAR,
"rank_order" DOUBLE,
"denominator_total" DOUBLE,
"denominator_average" DOUBLE,
"denominator_label" VARCHAR,
"denominator_year_period" VARCHAR,
"numerator_total" DOUBLE,
"numerator_average" DOUBLE,
"numerator_label" VARCHAR,
"numerator_year_period" VARCHAR,
"rate_multiplier" BIGINT,
"rate_percentage" DOUBLE,
"rate_percentage_label" VARCHAR,
"age_adjusted_rate" DOUBLE,
"age_adjusted_rate_label" VARCHAR,
"lower_confidence_limit" DOUBLE,
"upper_confidence_limit" DOUBLE,
"healthy_people_decade" BIGINT,
"healthy_people_objective_number" VARCHAR,
"healthy_people_objective_target" DOUBLE,
"healthy_people_objective_met" VARCHAR,
"denominator_annotation_code" DOUBLE,
"numerator_annotation_code" DOUBLE,
"rates_annotation_code" DOUBLE,
"annotation_desc" VARCHAR
);CREATE TABLE county_health_status_profiles_2022_tables_1_29 (
"publication_year" BIGINT,
"table" VARCHAR,
"health_indicator_desc" VARCHAR,
"strata" VARCHAR,
"strata_name" VARCHAR,
"county" VARCHAR,
"rank_order" DOUBLE,
"denominator_total" DOUBLE,
"denominator_average" DOUBLE,
"denominator_label" VARCHAR,
"denominator_year_period" VARCHAR,
"numerator_total" DOUBLE,
"numerator_average" DOUBLE,
"numerator_label" VARCHAR,
"numerator_year_period" VARCHAR,
"rate_multiplier" BIGINT,
"rate_percentage" DOUBLE,
"rate_percentage_label" VARCHAR,
"age_adjusted_rate" DOUBLE,
"age_adjusted_rate_label" VARCHAR,
"lower_confidence_limit" DOUBLE,
"upper_confidence_limit" DOUBLE,
"healthy_people_decade" BIGINT,
"healthy_people_objective_number" VARCHAR,
"healthy_people_objective_target" DOUBLE,
"healthy_people_objective_met" VARCHAR,
"denominator_annotation_code" DOUBLE,
"numerator_annotation_code" DOUBLE,
"rates_annotation_code" DOUBLE,
"annotation_desc" VARCHAR
);CREATE TABLE county_health_status_profiles_2023_tables_1_29 (
"publication_year" BIGINT,
"table" VARCHAR,
"health_indicator_desc" VARCHAR,
"strata" VARCHAR,
"strata_name" VARCHAR,
"county" VARCHAR,
"rank_order" DOUBLE,
"denominator_total" DOUBLE,
"denominator_average" DOUBLE,
"denominator_label" VARCHAR,
"denominator_year_period" VARCHAR,
"numerator_total" DOUBLE,
"numerator_average" DOUBLE,
"numerator_label" VARCHAR,
"numerator_year_period" VARCHAR,
"rate_multiplier" BIGINT,
"rate_percentage" DOUBLE,
"rate_percentage_label" VARCHAR,
"age_adjusted_rate" DOUBLE,
"age_adjusted_rate_label" VARCHAR,
"lower_confidence_limit" DOUBLE,
"upper_confidence_limit" DOUBLE,
"healthy_people_decade" BIGINT,
"healthy_people_objective_number" VARCHAR,
"healthy_people_objective_target" DOUBLE,
"healthy_people_objective_met" VARCHAR,
"denominator_annotation_code" DOUBLE,
"numerator_annotation_code" DOUBLE,
"rates_annotation_code" DOUBLE,
"annotation_desc" VARCHAR
);CREATE TABLE county_health_status_profiles_2024_tables_1_29 (
"publication_year" BIGINT,
"table" VARCHAR,
"health_indicator_desc" VARCHAR,
"strata" VARCHAR,
"strata_name" VARCHAR,
"county" VARCHAR,
"rank_order" DOUBLE,
"denominator_total" DOUBLE,
"denominator_average" DOUBLE,
"denominator_label" VARCHAR,
"denominator_year_period" VARCHAR,
"numerator_total" DOUBLE,
"numerator_average" DOUBLE,
"numerator_label" VARCHAR,
"numerator_year_period" VARCHAR,
"rate_multiplier" BIGINT,
"rate_percentage" DOUBLE,
"rate_percentage_label" VARCHAR,
"age_adjusted_rate" DOUBLE,
"age_adjusted_rate_label" VARCHAR,
"lower_confidence_limit" DOUBLE,
"upper_confidence_limit" DOUBLE,
"healthy_people_decade" BIGINT,
"healthy_people_objective_number" VARCHAR,
"healthy_people_objective_target" DOUBLE,
"healthy_people_objective_met" VARCHAR,
"denominator_annotation_code" DOUBLE,
"numerator_annotation_code" DOUBLE,
"rates_annotation_code" DOUBLE,
"annotation_desc" VARCHAR
);CREATE TABLE county_health_status_profiles_2025_tables_1_29 (
"publication_year" BIGINT,
"table" VARCHAR,
"health_indicator_desc" VARCHAR,
"strata" VARCHAR,
"strata_name" VARCHAR,
"county" VARCHAR,
"rank_order" DOUBLE,
"denominator_total" DOUBLE,
"denominator_average" DOUBLE,
"denominator_label" VARCHAR,
"denominator_year_period" VARCHAR,
"numerator_total" DOUBLE,
"numerator_average" DOUBLE,
"numerator_label" VARCHAR,
"numerator_year_period" VARCHAR,
"rate_multiplier" BIGINT,
"rate_percentage" DOUBLE,
"rate_percentage_label" VARCHAR,
"age_adjusted_rate" DOUBLE,
"age_adjusted_rate_label" VARCHAR,
"lower_confidence_limit" DOUBLE,
"upper_confidence_limit" DOUBLE,
"healthy_people_decade" BIGINT,
"healthy_people_objective_number" VARCHAR,
"healthy_people_objective_target" DOUBLE,
"healthy_people_objective_met" VARCHAR,
"denominator_annotation_code" DOUBLE,
"numerator_annotation_code" DOUBLE,
"rates_annotation_code" DOUBLE,
"annotation_desc" VARCHAR
);CREATE TABLE data_dictionary_county_health_status_profiles (
"field_title" VARCHAR,
"field_name" VARCHAR,
"data_type" VARCHAR,
"description" VARCHAR
);CREATE TABLE n__dictionary_county_health_status_profiles_2021_tables_1_29 (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);CREATE TABLE n__dictionary_county_health_status_profiles_2022_tables_1_29 (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);CREATE TABLE n__dictionary_county_health_status_profiles_2023_tables_1_29 (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);Anyone who has the link will be able to view this.