About this Dataset

Death Profiles By County

This dataset contains counts of deaths for California counties based on information entered on death certificates. Final counts are derived from static data and include out-of-state deaths to California residents, whereas provisional counts are derived from incomplete and dynamic data. Provisional counts are based on the records available when the data was retrieved and may not represent all deaths that occurred during the time period. Deaths involving injuries from external or environmental forces, such as accidents, homicide and suicide, often require additional investigation that tends to delay certification of the cause and manner of death. This can result in significant under-reporting of these deaths in provisional data.

The final data tables include both deaths that occurred in each California county regardless of the place of residence (by occurrence) and deaths to residents of each California county (by residence), whereas the provisional data table only includes deaths that occurred in each county regardless of the place of residence (by occurrence). The data are reported as totals, as well as stratified by age, gender, race-ethnicity, and death place type. Deaths due to all causes (ALL) and selected underlying cause of death categories are provided. See temporal coverage for more information on which combinations are available for which years.

The cause of death categories are based solely on the underlying cause of death as coded by the International Classification of Diseases. The underlying cause of death is defined by the World Health Organization (WHO) as "the disease or injury which initiated the train of events leading directly to death, or the circumstances of the accident or violence which produced the fatal injury." It is a single value assigned to each death based on the details as entered on the death certificate. When more than one cause is listed, the order in which they are listed can affect which cause is coded as the underlying cause. This means that similar events could be coded with different underlying causes of death depending on variations in how they were entered. Consequently, while underlying cause of death provides a convenient comparison between cause of death categories, it may not capture the full impact of each cause of death as it does not always take into account all conditions contributing to the death.
Organization: State of California
Last updated: 2025-07-23T19:57:35.777814
Tags: age, california-department-of-public-health, cause, cause-of-death, cdph, chsi, cod, death, death-certificate, decedent, edrs, ethnicity, gender, lcod, mortality, place-of-death, public-health, race, sex, vital-statistics

Tables

Data Dictionary - Deaths By County

@usgov.ca_gov_death_profiles_by_county_554c4.data_dictionary_deaths_by_county

8.1 KB
14 rows
4 columns


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

1970-1978 Final Deaths By Month By County

@usgov.ca_gov_death_profiles_by_county_554c4.n_1970_1978_final_deaths_by_month_by_county

236.89 KB
175392 rows
11 columns


CREATE TABLE n_1970_1978_final_deaths_by_month_by_county (
  "year" BIGINT,
  "month" BIGINT,
  "county" VARCHAR,
  "geography_type" VARCHAR,
  "strata" VARCHAR,
  "strata_name" VARCHAR,
  "cause" VARCHAR,
  "cause_desc" VARCHAR,
  "count" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_desc" VARCHAR
);

1970-1978 Final Deaths By Year By County

@usgov.ca_gov_death_profiles_by_county_554c4.n_1970_1978_final_deaths_by_year_by_county

41.46 KB
14616 rows
10 columns


CREATE TABLE n_1970_1978_final_deaths_by_year_by_county (
  "year" BIGINT,
  "county" VARCHAR,
  "geography_type" VARCHAR,
  "strata" VARCHAR,
  "strata_name" VARCHAR,
  "cause" VARCHAR,
  "cause_desc" VARCHAR,
  "count" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_desc" VARCHAR
);

1979-1988 Final Deaths By Month By County

@usgov.ca_gov_death_profiles_by_county_554c4.n_1979_1988_final_deaths_by_month_by_county

821.35 KB
779520 rows
11 columns


CREATE TABLE n_1979_1988_final_deaths_by_month_by_county (
  "year" BIGINT,
  "month" BIGINT,
  "county" VARCHAR,
  "geography_type" VARCHAR,
  "strata" VARCHAR,
  "strata_name" VARCHAR,
  "cause" VARCHAR,
  "cause_desc" VARCHAR,
  "count" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_desc" VARCHAR
);

1979-1998 Final Deaths By Year By County

@usgov.ca_gov_death_profiles_by_county_554c4.n_1979_1998_final_deaths_by_year_by_county

231.41 KB
129920 rows
10 columns


CREATE TABLE n_1979_1998_final_deaths_by_year_by_county (
  "year" BIGINT,
  "county" VARCHAR,
  "geography_type" VARCHAR,
  "strata" VARCHAR,
  "strata_name" VARCHAR,
  "cause" VARCHAR,
  "cause_desc" VARCHAR,
  "count" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_desc" VARCHAR
);

1989-1998 Final Deaths By Month By County

@usgov.ca_gov_death_profiles_by_county_554c4.n_1989_1998_final_deaths_by_month_by_county

858.23 KB
779520 rows
11 columns


CREATE TABLE n_1989_1998_final_deaths_by_month_by_county (
  "year" BIGINT,
  "month" BIGINT,
  "county" VARCHAR,
  "geography_type" VARCHAR,
  "strata" VARCHAR,
  "strata_name" VARCHAR,
  "cause" VARCHAR,
  "cause_desc" VARCHAR,
  "count" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_desc" VARCHAR
);

1999-2003 Final Deaths By Month By Occurrence County

@usgov.ca_gov_death_profiles_by_county_554c4.n_1999_2003_final_deaths_by_month_by_occurrence_county

464.43 KB
528960 rows
11 columns


CREATE TABLE n_1999_2003_final_deaths_by_month_by_occurrence_county (
  "year" BIGINT,
  "month" BIGINT,
  "county" VARCHAR,
  "geography_type" VARCHAR,
  "strata" VARCHAR,
  "strata_name" VARCHAR,
  "cause" VARCHAR,
  "cause_desc" VARCHAR,
  "count" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_desc" VARCHAR
);

1999-2003 Final Deaths By Month By Residence County

@usgov.ca_gov_death_profiles_by_county_554c4.n_1999_2003_final_deaths_by_month_by_residence_county

468.96 KB
528960 rows
11 columns


CREATE TABLE n_1999_2003_final_deaths_by_month_by_residence_county (
  "year" BIGINT,
  "month" BIGINT,
  "county" VARCHAR,
  "geography_type" VARCHAR,
  "strata" VARCHAR,
  "strata_name" VARCHAR,
  "cause" VARCHAR,
  "cause_desc" VARCHAR,
  "count" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_desc" VARCHAR
);

1999-2013 Final Deaths By Year By County

@usgov.ca_gov_death_profiles_by_county_554c4.n_1999_2013_final_deaths_by_year_by_county

415.22 KB
292320 rows
10 columns


CREATE TABLE n_1999_2013_final_deaths_by_year_by_county (
  "year" BIGINT,
  "county" VARCHAR,
  "geography_type" VARCHAR,
  "strata" VARCHAR,
  "strata_name" VARCHAR,
  "cause" VARCHAR,
  "cause_desc" VARCHAR,
  "count" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_desc" VARCHAR
);

2004-2008 Final Deaths By Month By Occurrence County

@usgov.ca_gov_death_profiles_by_county_554c4.n_2004_2008_final_deaths_by_month_by_occurrence_county

525.9 KB
612480 rows
11 columns


CREATE TABLE n_2004_2008_final_deaths_by_month_by_occurrence_county (
  "year" BIGINT,
  "month" BIGINT,
  "county" VARCHAR,
  "geography_type" VARCHAR,
  "strata" VARCHAR,
  "strata_name" VARCHAR,
  "cause" VARCHAR,
  "cause_desc" VARCHAR,
  "count" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_desc" VARCHAR
);

2004-2008 Final Deaths By Month By Residence County

@usgov.ca_gov_death_profiles_by_county_554c4.n_2004_2008_final_deaths_by_month_by_residence_county

530.43 KB
612480 rows
11 columns


CREATE TABLE n_2004_2008_final_deaths_by_month_by_residence_county (
  "year" BIGINT,
  "month" BIGINT,
  "county" VARCHAR,
  "geography_type" VARCHAR,
  "strata" VARCHAR,
  "strata_name" VARCHAR,
  "cause" VARCHAR,
  "cause_desc" VARCHAR,
  "count" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_desc" VARCHAR
);

2009-2013 Final Deaths By Month By Occurrence County

@usgov.ca_gov_death_profiles_by_county_554c4.n_2009_2013_final_deaths_by_month_by_occurrence_county

526.14 KB
612480 rows
11 columns


CREATE TABLE n_2009_2013_final_deaths_by_month_by_occurrence_county (
  "year" BIGINT,
  "month" BIGINT,
  "county" VARCHAR,
  "geography_type" VARCHAR,
  "strata" VARCHAR,
  "strata_name" VARCHAR,
  "cause" VARCHAR,
  "cause_desc" VARCHAR,
  "count" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_desc" VARCHAR
);

2009-2013 Final Deaths By Month By Residence County

@usgov.ca_gov_death_profiles_by_county_554c4.n_2009_2013_final_deaths_by_month_by_residence_county

532.2 KB
612480 rows
11 columns


CREATE TABLE n_2009_2013_final_deaths_by_month_by_residence_county (
  "year" BIGINT,
  "month" BIGINT,
  "county" VARCHAR,
  "geography_type" VARCHAR,
  "strata" VARCHAR,
  "strata_name" VARCHAR,
  "cause" VARCHAR,
  "cause_desc" VARCHAR,
  "count" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_desc" VARCHAR
);

2014-2018 Final Deaths By Month By Occurrence County

@usgov.ca_gov_death_profiles_by_county_554c4.n_2014_2018_final_deaths_by_month_by_occurrence_county

576.5 KB
633360 rows
13 columns


CREATE TABLE n_2014_2018_final_deaths_by_month_by_occurrence_county (
  "year" BIGINT,
  "month" BIGINT,
  "county" VARCHAR,
  "geography_type" VARCHAR,
  "strata" VARCHAR,
  "strata_name" VARCHAR,
  "cause" VARCHAR,
  "cause_desc" VARCHAR,
  "icd_revision" VARCHAR,
  "count" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_desc" VARCHAR,
  "data_revision_date" TIMESTAMP
);

2014-2018 Final Deaths By Month By Residence County

@usgov.ca_gov_death_profiles_by_county_554c4.n_2014_2018_final_deaths_by_month_by_residence_county

584.96 KB
633360 rows
13 columns


CREATE TABLE n_2014_2018_final_deaths_by_month_by_residence_county (
  "year" BIGINT,
  "month" BIGINT,
  "county" VARCHAR,
  "geography_type" VARCHAR,
  "strata" VARCHAR,
  "strata_name" VARCHAR,
  "cause" VARCHAR,
  "cause_desc" VARCHAR,
  "icd_revision" VARCHAR,
  "count" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_desc" VARCHAR,
  "data_revision_date" TIMESTAMP
);

2014-2023 Final Deaths By Year By County

@usgov.ca_gov_death_profiles_by_county_554c4.n_2014_2023_final_deaths_by_year_by_county

324.15 KB
211120 rows
12 columns


CREATE TABLE n_2014_2023_final_deaths_by_year_by_county (
  "year" BIGINT,
  "county" VARCHAR,
  "geography_type" VARCHAR,
  "strata" VARCHAR,
  "strata_name" VARCHAR,
  "cause" VARCHAR,
  "cause_desc" VARCHAR,
  "icd_revision" VARCHAR,
  "count" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_desc" VARCHAR,
  "data_revision_date" TIMESTAMP
);

2019-2023 Final Deaths By Month By Occurrence County

@usgov.ca_gov_death_profiles_by_county_554c4.n_2019_2023_final_deaths_by_month_by_occurrence_county

591.76 KB
633360 rows
13 columns


CREATE TABLE n_2019_2023_final_deaths_by_month_by_occurrence_county (
  "year" BIGINT,
  "month" BIGINT,
  "county" VARCHAR,
  "geography_type" VARCHAR,
  "strata" VARCHAR,
  "strata_name" VARCHAR,
  "cause" VARCHAR,
  "cause_desc" VARCHAR,
  "icd_revision" VARCHAR,
  "count" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_desc" VARCHAR,
  "data_revision_date" TIMESTAMP
);

2019-2023 Final Deaths By Month By Residence County

@usgov.ca_gov_death_profiles_by_county_554c4.n_2019_2023_final_deaths_by_month_by_residence_county

599.56 KB
633360 rows
13 columns


CREATE TABLE n_2019_2023_final_deaths_by_month_by_residence_county (
  "year" BIGINT,
  "month" BIGINT,
  "county" VARCHAR,
  "geography_type" VARCHAR,
  "strata" VARCHAR,
  "strata_name" VARCHAR,
  "cause" VARCHAR,
  "cause_desc" VARCHAR,
  "icd_revision" VARCHAR,
  "count" DOUBLE,
  "annotation_code" DOUBLE,
  "annotation_desc" VARCHAR,
  "data_revision_date" TIMESTAMP
);