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

Tables

Dim age group, Statfin rpk pxt 11cn px, Full historyTSV
Dimension Age_group (Ikäryhmä)
Dim age group, Statfin rpk pxt 11cn px, LatestTSV
Dimension Age_group (Ikäryhmä)
Dim offence, Statfin rpk pxt 11cn px, Full historyTSV
Dimension Offence (Rikos)
Dim offence, Statfin rpk pxt 11cn px, LatestTSV
Dimension Offence (Rikos)
Dim region, Statfin rpk pxt 11cn px, Full historyTSV
Dimension Region (Maakunta)
Dim region, Statfin rpk pxt 11cn px, LatestTSV
Dimension Region (Maakunta)
Dim sex, Statfin rpk pxt 11cn px, Full historyTSV
Dimension Sex (Sukupuoli)
Dim year, Statfin rpk pxt 11cn px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin rpk pxt 11cn px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin rpk pxt 11cn px, Full historyTSV
Victims of certain offences by Sex, Region, Offence, Age group, Year and Information
Fact, Statfin rpk pxt 11cn px, LatestTSV
Victims of certain offences by Sex, Region, Offence, Age group, Year and Information

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