About this Dataset

Death Profiles By ZIP Code

This dataset contains counts of deaths for California residents by ZIP Code based on information entered on death certificates. Final counts are derived from static data and include out-of-state deaths of California residents. The data tables include deaths of residents of California by ZIP Code of residence (by residence). The data are reported as totals, as well as stratified by age and gender. 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-23T15:40:43.467359
Tags: california-department-of-public-health, cause-of-death, cdph, center-for-health-statistics-and-informatics, chsi, death, female, gender, male, mortality, public-health, sex, vital-statistics, zip, zip-code

Tables

Data Dictionary - 1989-1998 Final Deaths By Year By ZIP Code

@usgov.ca_gov_death_profiles_by_zip_code_017c1.data_dictionary_1989_1998_final_deaths_by_year_by_zip_code

7.92 KB
12 rows
4 columns


CREATE TABLE data_dictionary_1989_1998_final_deaths_by_year_by_zip_code (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 1999-2008 Final Deaths By Year By ZIP Code

@usgov.ca_gov_death_profiles_by_zip_code_017c1.data_dictionary_1999_2008_final_deaths_by_year_by_zip_code

7.92 KB
12 rows
4 columns


CREATE TABLE data_dictionary_1999_2008_final_deaths_by_year_by_zip_code (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - 2009-2018 Final Deaths By Year By ZIP Code

@usgov.ca_gov_death_profiles_by_zip_code_017c1.data_dictionary_2009_2018_final_deaths_by_year_by_zip_code

7.92 KB
12 rows
4 columns


CREATE TABLE data_dictionary_2009_2018_final_deaths_by_year_by_zip_code (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - Deaths By ZIP Code

@usgov.ca_gov_death_profiles_by_zip_code_017c1.data_dictionary_deaths_by_zip_code

7.39 KB
12 rows
4 columns


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

1989-1998 Final Deaths By Year By ZIP Code

@usgov.ca_gov_death_profiles_by_zip_code_017c1.n_1989_1998_final_deaths_by_year_by_zip_code

769.79 KB
745920 rows
12 columns


CREATE TABLE n_1989_1998_final_deaths_by_year_by_zip_code (
  "year" BIGINT,
  "zip_code" BIGINT,
  "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
);

1999-2008 Final Deaths By Year By ZIP Code

@usgov.ca_gov_death_profiles_by_zip_code_017c1.n_1999_2008_final_deaths_by_year_by_zip_code

780.58 KB
745920 rows
12 columns


CREATE TABLE n_1999_2008_final_deaths_by_year_by_zip_code (
  "year" BIGINT,
  "zip_code" BIGINT,
  "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
);

2009-2018 Final Deaths By Year By ZIP Code

@usgov.ca_gov_death_profiles_by_zip_code_017c1.n_2009_2018_final_deaths_by_year_by_zip_code

793.54 KB
745920 rows
12 columns


CREATE TABLE n_2009_2018_final_deaths_by_year_by_zip_code (
  "year" BIGINT,
  "zip_code" BIGINT,
  "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 Year By ZIP Code

@usgov.ca_gov_death_profiles_by_zip_code_017c1.n_2019_2023_final_deaths_by_year_by_zip_code

427.97 KB
380952 rows
12 columns


CREATE TABLE n_2019_2023_final_deaths_by_year_by_zip_code (
  "year" BIGINT,
  "zip_code" BIGINT,
  "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
);