Baselight

Statewide Death Profiles

State of California

@usgov.ca_gov_statewide_death_profiles_47a9d

Loading...
Loading...

About this Dataset

Statewide Death Profiles

This dataset contains counts of deaths for California as a whole 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 California regardless of the place of residence (by occurrence) and deaths to California residents (by residence), whereas the provisional data table only includes deaths that occurred in California 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-23T14:51:08.452107
Tags: age, california-department-of-public-health, cdph, chsi, death, death-certificate, ethnicity, gender, mortality, occurrence, place-of-death, public-health, race, residence, sex, vital-statistics

Tables

Data Dictionary - 1970-1978 Final Deaths By Month Statewide

@usgov.ca_gov_statewide_death_profiles_47a9d.data_dictionary_1970_1978_final_deaths_by_month_statewide
  • 7.55 KB
  • 10 rows
  • 4 columns
Loading...

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

Data Dictionary - 1970-1978 Final Deaths By Year Statewide

@usgov.ca_gov_statewide_death_profiles_47a9d.data_dictionary_1970_1978_final_deaths_by_year_statewide
  • 7.49 KB
  • 9 rows
  • 4 columns
Loading...

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

Data Dictionary - 1979-1998 Final Deaths By Month Statewide

@usgov.ca_gov_statewide_death_profiles_47a9d.data_dictionary_1979_1998_final_deaths_by_month_statewide
  • 7.55 KB
  • 10 rows
  • 4 columns
Loading...

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

Data Dictionary - 1979-1998 Final Deaths By Year Statewide

@usgov.ca_gov_statewide_death_profiles_47a9d.data_dictionary_1979_1998_final_deaths_by_year_statewide
  • 7.51 KB
  • 9 rows
  • 4 columns
Loading...

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

Data Dictionary - 1999-2013 Final Deaths By Month Statewide

@usgov.ca_gov_statewide_death_profiles_47a9d.data_dictionary_1999_2013_final_deaths_by_month_statewide
  • 7.55 KB
  • 10 rows
  • 4 columns
Loading...

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

Data Dictionary - 1999-2013 Final Deaths By Year Statewide

@usgov.ca_gov_statewide_death_profiles_47a9d.data_dictionary_1999_2013_final_deaths_by_year_statewide
  • 7.51 KB
  • 9 rows
  • 4 columns
Loading...

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

Data Dictionary - 2014-2023 Final Deaths By Month Statewide

@usgov.ca_gov_statewide_death_profiles_47a9d.data_dictionary_2014_2023_final_deaths_by_month_statewide
  • 6.9 KB
  • 12 rows
  • 4 columns
Loading...

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

Data Dictionary - 2014-2023 Final Deaths By Year Statewide

@usgov.ca_gov_statewide_death_profiles_47a9d.data_dictionary_2014_2023_final_deaths_by_year_statewide
  • 7.66 KB
  • 11 rows
  • 4 columns
Loading...

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

Data Dictionary - Deaths Statewide

@usgov.ca_gov_statewide_death_profiles_47a9d.data_dictionary_deaths_statewide
  • 8.08 KB
  • 13 rows
  • 4 columns
Loading...

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

1970-1978 Final Deaths By Month Statewide

@usgov.ca_gov_statewide_death_profiles_47a9d.n_1970_1978_final_deaths_by_month_statewide
  • 18.7 KB
  • 3024 rows
  • 10 columns
Loading...

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

1970-1978 Final Deaths By Year Statewide

@usgov.ca_gov_statewide_death_profiles_47a9d.n_1970_1978_final_deaths_by_year_statewide
  • 8.09 KB
  • 252 rows
  • 9 columns
Loading...

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

1979-1998 Final Deaths By Month Statewide

@usgov.ca_gov_statewide_death_profiles_47a9d.n_1979_1998_final_deaths_by_month_statewide
  • 76.8 KB
  • 26880 rows
  • 10 columns
Loading...

CREATE TABLE n_1979_1998_final_deaths_by_month_statewide (
  "year" BIGINT,
  "month" BIGINT,
  "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 Statewide

@usgov.ca_gov_statewide_death_profiles_47a9d.n_1979_1998_final_deaths_by_year_statewide
  • 19.01 KB
  • 2240 rows
  • 9 columns
Loading...

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

1999-2013 Final Deaths By Month Statewide

@usgov.ca_gov_statewide_death_profiles_47a9d.n_1999_2013_final_deaths_by_month_statewide
  • 133.4 KB
  • 60480 rows
  • 10 columns
Loading...

CREATE TABLE n_1999_2013_final_deaths_by_month_statewide (
  "year" BIGINT,
  "month" BIGINT,
  "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 Statewide

@usgov.ca_gov_statewide_death_profiles_47a9d.n_1999_2013_final_deaths_by_year_statewide
  • 31.42 KB
  • 5488 rows
  • 9 columns
Loading...

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

2014-2023 Final Deaths By Month Statewide

@usgov.ca_gov_statewide_death_profiles_47a9d.n_2014_2023_final_deaths_by_month_statewide
  • 105.64 KB
  • 43680 rows
  • 12 columns
Loading...

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

2014-2023 Final Deaths By Year Statewide

@usgov.ca_gov_statewide_death_profiles_47a9d.n_2014_2023_final_deaths_by_year_statewide
  • 29.99 KB
  • 4162 rows
  • 11 columns
Loading...

CREATE TABLE n_2014_2023_final_deaths_by_year_statewide (
  "year" 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
);

Share link

Anyone who has the link will be able to view this.