County Health Status Profiles by US Government | Healthcare

About this Dataset

County Health Status Profiles

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: 2024-11-26T22:44:14.140813
Tags: births, california-department-of-public-health, cdph, chsi, county, deaths, health-indicators, healthy-people, infant-mortality, morbidity, mortality, vital-statistics

Tables

County Health Status Profiles 2024: Tables 1-29

@usgov.ca_gov_county_health_status_profiles_765ed.county_health_status_profiles_2024_tables_1_29

83.73 KB
2242 rows
30 columns


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
);

County Health Status Profiles 2023: Tables 1-29

@usgov.ca_gov_county_health_status_profiles_765ed.county_health_status_profiles_2023_tables_1_29

83.67 KB
2242 rows
30 columns


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
);

County Health Status Profiles 2022: Tables 1-29

@usgov.ca_gov_county_health_status_profiles_765ed.county_health_status_profiles_2022_tables_1_29

84.91 KB
2242 rows
30 columns


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
);

County Health Status Profiles 2021: Tables 1-29

@usgov.ca_gov_county_health_status_profiles_765ed.county_health_status_profiles_2021_tables_1_29

81.66 KB
2183 rows
30 columns


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
);

Data Dictionary - County Health Status Profiles

@usgov.ca_gov_county_health_status_profiles_765ed.data_dictionary_county_health_status_profiles

6.49 KB
30 rows
4 columns


CREATE TABLE data_dictionary_county_health_status_profiles (
  "field_title" VARCHAR,
  "field_name" VARCHAR,
  "data_type" VARCHAR,
  "description" VARCHAR
);