1. Home
  2. Datasets
  3. 006 -- Accidental or violent ...
To download the data set, please sign up or log in

006 -- Accidental or violent deaths by underlying cause of death (122-group short list), age and gender, alcohol intoxicated separately in 1998-2016

006 -- Accidental or violent deaths by underlying cause of death (122-group short list), age and gender, alcohol intoxicated separately in 1998-2016

Tables

Column Descriptions

Fact, Statfinpas ksyyt pxt 006 201600 px, Latest

Column Type Comment
accidents_and_violence_122group_short_list int Datasource did not contain a description for Accidents_and_violence_122group_short_list. Column accidents_and_violence_122group_short_list has 353628 rows, out of which 47652 are empty, making the null percent 13.48. Minimum value is 1 and maximum value is 122.
age string Datasource did not contain a description for Age. Column age has 353628 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-.
year int Datasource did not contain a description for Year. Column year has 353628 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1998 and maximum value is 2016.
gender int Datasource did not contain a description for Gender. Column gender has 353628 rows, out of which 117876 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
alcohol_intoxication int Datasource did not contain a description for Alcohol_intoxication. Column alcohol_intoxication has 353628 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 1.
deaths int Datasource did not contain a description for Deaths. Column deaths has 353628 rows, out of which 117420 are empty, making the null percent 33.20. Minimum value is 0 and maximum value is 4353.

Fact, Statfinpas ksyyt pxt 006 201600 px, Full history

Column Type Comment
accidents_and_violence_122group_short_list int Datasource did not contain a description for Accidents_and_violence_122group_short_list. Column accidents_and_violence_122group_short_list has 353628 rows, out of which 47652 are empty, making the null percent 13.48. Minimum value is 1 and maximum value is 122.
age string Datasource did not contain a description for Age. Column age has 353628 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-.
year int Datasource did not contain a description for Year. Column year has 353628 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1998 and maximum value is 2016.
gender int Datasource did not contain a description for Gender. Column gender has 353628 rows, out of which 117876 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
alcohol_intoxication int Datasource did not contain a description for Alcohol_intoxication. Column alcohol_intoxication has 353628 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 1.
deaths int Datasource did not contain a description for Deaths. Column deaths has 353628 rows, out of which 117420 are empty, making the null percent 33.20. Minimum value is 0 and maximum value is 4353.
orig_extractdate string The date when the data was originally fetched from the source.

Dim accidents and violence 122group short list, Statfinpas ksyyt pxt 006 201600 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 141 rows, out of which 19 are empty, making the null percent 13.48. Minimum value is 1 and maximum value is 122.
label string The label for the dimension value. Column label has 141 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 001-012 Transport acciden... and first 25 characters of maximum string: 122 Sequelae of other acc...
orig_extractdate string The date when the data was originally fetched from the source.

Dim accidents and violence 122group short list, Statfinpas ksyyt pxt 006 201600 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 141 rows, out of which 19 are empty, making the null percent 13.48. Minimum value is 1 and maximum value is 122.
label string The label for the dimension value. Column label has 141 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 001-012 Transport acciden... and first 25 characters of maximum string: 122 Sequelae of other acc...

Dim age, Statfinpas ksyyt pxt 006 201600 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 0 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 age, Statfinpas ksyyt pxt 006 201600 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 0 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 year, Statfinpas ksyyt pxt 006 201600 px, Latest

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

Dim year, Statfinpas ksyyt pxt 006 201600 px, Full history

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

Dim gender, Statfinpas ksyyt pxt 006 201600 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 Males.

Dim gender, Statfinpas ksyyt pxt 006 201600 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 Males.
orig_extractdate string The date when the data was originally fetched from the source.

Dim alcohol intoxication, Statfinpas ksyyt pxt 006 201600 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 2 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 1.
label string The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Deaths accompanied by alc... and first 25 characters of maximum string: Total accidental or viole...

Dim alcohol intoxication, Statfinpas ksyyt pxt 006 201600 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 2 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 1.
label string The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Deaths accompanied by alc... and first 25 characters of maximum string: Total accidental or viole...
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 31, 2019
Created July 31, 2019