To download the data set, please sign up or log in

014 -- Certain police tasks by municipality 1980-2017

014 -- Certain police tasks by municipality 1980-2017

Tables

Column Descriptions

Fact, Statfinpas rpk pxt 014 201700 px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 142728 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1980 and maximum value is 2017.
municipality int Datasource did not contain a description for Municipality. Column municipality has 142728 rows, out of which 456 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992.
tasks int Suicide investigation is a police task. Official statistics about suicides is published in Causes of death statistics. . Column tasks has 142728 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1801 and maximum value is 1845.
certain_police_tasks int Datasource did not contain a description for Certain_police_tasks. Column certain_police_tasks has 142728 rows, out of which 69870 are empty, making the null percent 48.95. Minimum value is 1 and maximum value is 214946.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfinpas rpk pxt 014 201700 px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 142728 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1980 and maximum value is 2017.
municipality int Datasource did not contain a description for Municipality. Column municipality has 142728 rows, out of which 456 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992.
tasks int Suicide investigation is a police task. Official statistics about suicides is published in Causes of death statistics. . Column tasks has 142728 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1801 and maximum value is 1845.
certain_police_tasks int Datasource did not contain a description for Certain_police_tasks. Column certain_police_tasks has 142728 rows, out of which 69870 are empty, making the null percent 48.95. Minimum value is 1 and maximum value is 214946.

Dim year, Statfinpas rpk pxt 014 201700 px, Latest

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

Dim year, Statfinpas rpk pxt 014 201700 px, Full history

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

Dim municipality, Statfinpas rpk pxt 014 201700 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 313 rows, out of which 1 are empty, making the null percent 0.32. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 313 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Unknown.

Dim municipality, Statfinpas rpk pxt 014 201700 px, Full history

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

Dim tasks, Statfinpas rpk pxt 014 201700 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 12 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1801 and maximum value is 1845.
label string The label for the dimension value. Column label has 12 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Deer collisions... and first 25 characters of maximum string: Persons taken into custod...

Dim tasks, Statfinpas rpk pxt 014 201700 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 12 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1801 and maximum value is 1845.
label string The label for the dimension value. Column label has 12 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Deer collisions... and first 25 characters of maximum string: Persons taken into custod...
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 22, 2019
Created July 22, 2019