1. Home
  2. Datasets
  3. 11 bs -- Deaths by underlying ...
To download the data set, please sign up or log in

11 bs -- Deaths by underlying cause of death (54-group short list), age and gender, 1969-2017

11 bs -- Deaths by underlying cause of death (54-group short list), age and gender, 1969-2017

Tables

Column Descriptions

Dim age, Statfin ksyyt pxt 11bs px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 000 and maximum string is 95-.
label string The label for the dimension value. Column label has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 and maximum string is 95 -.
orig_extractdate string The date when the data was originally fetched from the source.

Dim age, Statfin ksyyt pxt 11bs px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 000 and maximum string is 95-.
label string The label for the dimension value. Column label has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 and maximum string is 95 -.

Dim underlying cause of death 54group short list, Statfin ksyyt pxt 11bs px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 64 rows, out of which 10 are empty, making the null percent 15.62. Minimum value is 1 and maximum value is 54.
label string The label for the dimension value. Column label has 64 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01-03 Certain infectious ... and first 25 characters of maximum string: 54 No death certificate...
orig_extractdate string The date when the data was originally fetched from the source.

Dim year, Statfin ksyyt pxt 11bs px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 49 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1969 and maximum value is 2017.
label int The label for the dimension value. Column label has 49 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1969 and maximum value is 2017.
orig_extractdate string The date when the data was originally fetched from the source.

Dim gender, Statfin ksyyt pxt 11bs px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Females and maximum string is Total.
orig_extractdate string The date when the data was originally fetched from the source.

Dim gender, Statfin ksyyt pxt 11bs px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
label string The label for the dimension value. Column label has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Females and maximum string is Total.

Fact, Statfin ksyyt pxt 11bs px, Latest

Column Type Comment
underlying_cause_of_death_54group_short_list string A change in the WHO...s coding rules has reduced pneumonia as an underlying cause since 2005. Chronic disease mentioned in the death certificate is recorded as the person's underlying cause of death instead of pneumonia. The cases mainly moved to dementia and cerebrovascular diseases. The missing death certificates belong in 1969...1997 to group 40 and from 1998 onwards to group 54. The key between the 54-group short list and the different Classification of Diseases is described on the homepage of the statistics on causes of death under Classifications. . Column underlying_cause_of_death_54group_short_list has 206976 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 and maximum s
age string Datasource did not contain a description for Age. Column age has 206976 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 000 and maximum string is 95-.
gender string Datasource did not contain a description for Gender. Column gender has 206976 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is 2.
year int Datasource did not contain a description for Year. Column year has 206976 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1969 and maximum value is 2017.
deaths int Datasource did not contain a description for Deaths. Column deaths has 206976 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 53964.

Dim underlying cause of death 54group short list, Statfin ksyyt pxt 11bs px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 64 rows, out of which 10 are empty, making the null percent 15.62. Minimum value is 1 and maximum value is 54.
label string The label for the dimension value. Column label has 64 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 01-03 Certain infectious ... and first 25 characters of maximum string: 54 No death certificate...

Dim year, Statfin ksyyt pxt 11bs px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 49 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1969 and maximum value is 2017.
label int The label for the dimension value. Column label has 49 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1969 and maximum value is 2017.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019