Statewide Death Profiles
State of California
@usgov.ca_gov_statewide_death_profiles_47a9d
State of California
@usgov.ca_gov_statewide_death_profiles_47a9d
CREATE TABLE data_dictionary_1970_1978_final_deaths_by_month_statewide (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);
CREATE TABLE data_dictionary_1970_1978_final_deaths_by_year_statewide (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);
CREATE TABLE data_dictionary_1979_1998_final_deaths_by_month_statewide (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);
CREATE TABLE data_dictionary_1979_1998_final_deaths_by_year_statewide (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);
CREATE TABLE data_dictionary_1999_2013_final_deaths_by_month_statewide (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);
CREATE TABLE data_dictionary_1999_2013_final_deaths_by_year_statewide (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);
CREATE TABLE data_dictionary_2014_2023_final_deaths_by_month_statewide (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);
CREATE TABLE data_dictionary_2014_2023_final_deaths_by_year_statewide (
"column" VARCHAR,
"type" VARCHAR,
"label" VARCHAR,
"description" VARCHAR
);
CREATE TABLE data_dictionary_deaths_statewide (
"field_title" VARCHAR,
"field_name" VARCHAR,
"data_type" VARCHAR,
"description" VARCHAR
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
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
);
Anyone who has the link will be able to view this.