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

11 cn -- Victims of certain offences by age and region, 2009-2018

11 cn -- Victims of certain offences by age and region, 2009-2018

Tables

Column Descriptions

Fact, Statfin rpk pxt 11cn px, Latest

Column Type Comment
sex string Datasource did not contain a description for Sex. Column sex has 730170 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.
region string Datasource did not contain a description for Region. Column region has 730170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MK01 and maximum string is X.
offence int Datasource did not contain a description for Offence. Column offence has 730170 rows, out of which 215460 are empty, making the null percent 29.51. Minimum value is 172201 and maximum value is 310402.
age_group string Datasource did not contain a description for Age_group. Column age_group has 730170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-4 and maximum string is X.
year int Datasource did not contain a description for Year. Column year has 730170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2009 and maximum value is 2018.
number_of_victims int Datasource did not contain a description for Number_of_victims. Column number_of_victims has 730170 rows, out of which 45486 are empty, making the null percent 6.23. Minimum value is 0 and maximum value is 53978.

Fact, Statfin rpk pxt 11cn px, Full history

Column Type Comment
sex string Datasource did not contain a description for Sex. Column sex has 730170 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.
region string Datasource did not contain a description for Region. Column region has 730170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MK01 and maximum string is X.
offence int Datasource did not contain a description for Offence. Column offence has 730170 rows, out of which 215460 are empty, making the null percent 29.51. Minimum value is 172201 and maximum value is 310402.
age_group string Datasource did not contain a description for Age_group. Column age_group has 730170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-4 and maximum string is X.
year int Datasource did not contain a description for Year. Column year has 730170 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2009 and maximum value is 2018.
number_of_victims int Datasource did not contain a description for Number_of_victims. Column number_of_victims has 730170 rows, out of which 45486 are empty, making the null percent 6.23. Minimum value is 0 and maximum value is 53978.
orig_extractdate string The date when the data was originally fetched from the source.

Dim sex, Statfin rpk pxt 11cn 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 region, Statfin rpk pxt 11cn px, Full history

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

Dim region, Statfin rpk pxt 11cn px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MK01 and maximum string is X.
label string The label for the dimension value. Column label has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MK01 Uusimaa and maximum string is Unknown.

Dim offence, Statfin rpk pxt 11cn px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 61 rows, out of which 18 are empty, making the null percent 29.51. Minimum value is 172201 and maximum value is 310402.
label string The label for the dimension value. Column label has 61 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Abuse of a victim of pros... and first 25 characters of maximum string: Coercion 25:8§...
orig_extractdate string The date when the data was originally fetched from the source.

Dim offence, Statfin rpk pxt 11cn px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 61 rows, out of which 18 are empty, making the null percent 29.51. Minimum value is 172201 and maximum value is 310402.
label string The label for the dimension value. Column label has 61 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Abuse of a victim of pros... and first 25 characters of maximum string: Coercion 25:8§...

Dim age group, Statfin rpk pxt 11cn px, Full history

Column Type Comment
code string 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 string is 0-4 and maximum string is X.
label string 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 string is 10 - 14 and maximum string is Unknown.
orig_extractdate string The date when the data was originally fetched from the source.

Dim age group, Statfin rpk pxt 11cn px, Latest

Column Type Comment
code string 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 string is 0-4 and maximum string is X.
label string 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 string is 10 - 14 and maximum string is Unknown.

Dim year, Statfin rpk pxt 11cn px, Full history

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

Dim year, Statfin rpk pxt 11cn px, Latest

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

Additional Info

Last Updated July 8, 2019
Created July 7, 2019