11 tb -- Persons suspected of offences by International Classification of Crimes ICCS, 2013-2018

Tables

Dim age group, Statfin rpk pxt 11tb px, Full historyTSV
Dimension Age_group (Ikäryhmä)
Dim age group, Statfin rpk pxt 11tb px, LatestTSV
Dimension Age_group (Ikäryhmä)
Dim iccs, Statfin rpk pxt 11tb px, Full historyTSV
Dimension ICCS (ICCS rikosluokka)
Dim iccs, Statfin rpk pxt 11tb px, LatestTSV
Dimension ICCS (ICCS rikosluokka)
Dim nationality, Statfin rpk pxt 11tb px, Full historyTSV
Dimension Nationality (Kansalaisuus)
Dim nationality, Statfin rpk pxt 11tb px, LatestTSV
Dimension Nationality (Kansalaisuus)
Dim sex, Statfin rpk pxt 11tb px, Full historyTSV
Dimension Sex (Sukupuoli)
Dim sex, Statfin rpk pxt 11tb px, LatestTSV
Dimension Sex (Sukupuoli)
Dim year, Statfin rpk pxt 11tb px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfin rpk pxt 11tb px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfin rpk pxt 11tb px, Full historyTSV
International Classification of Crimes ICCS by ICCS, Sex, Nationality, Age group, Year and Information
Fact, Statfin rpk pxt 11tb px, LatestTSV
International Classification of Crimes ICCS by ICCS, Sex, Nationality, Age group, Year and Information

Column Descriptions

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

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

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

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

Dim year, Statfin rpk pxt 11tb px, Latest

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

Dim sex, Statfin rpk pxt 11tb 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.

Dim iccs, Statfin rpk pxt 11tb px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 320 rows, out of which 1 are empty, making the null percent 0.31. Minimum value is 10000 and maximum value is 110900.
label	string	The label for the dimension value. Column label has 320 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0101 Intentional homicide... and first 25 characters of maximum string: 1109 Other criminal acts...
orig_extractdate	string	The date when the data was originally fetched from the source.

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

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

Dim nationality, Statfin rpk pxt 11tb px, Latest

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

Fact, Statfin rpk pxt 11tb px, Latest

Column	Type	Comment
iccs	int	Datasource did not contain a description for ICCS. Column iccs has 115200 rows, out of which 360 are empty, making the null percent 0.31. Minimum value is 10000 and maximum value is 110900.
sex	string	Datasource did not contain a description for Sex. Column sex has 115200 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.
nationality	int	Datasource did not contain a description for Nationality. Column nationality has 115200 rows, out of which 46080 are empty, making the null percent 40.00. Minimum value is 1 and maximum value is 999.
age_group	string	Datasource did not contain a description for Age_group. Column age_group has 115200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ala and maximum string is X.
year	int	Datasource did not contain a description for Year. Column year has 115200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2013 and maximum value is 2018.
persons_suspected_total	int	Datasource did not contain a description for Persons_suspected_total. Column persons_suspected_total has 115200 rows, out of which 53421 are empty, making the null percent 46.37. Minimum value is 0 and maximum value is 719100.
persons_suspected_principal_offence_rule	int	Datasource did not contain a description for Persons_suspected_principal_offence_rule. Column persons_suspected_principal_offence_rule has 115200 rows, out of which 53144 are empty, making the null percent 46.13. Minimum value is 0 and maximum value is 454726.

Dim iccs, Statfin rpk pxt 11tb px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 320 rows, out of which 1 are empty, making the null percent 0.31. Minimum value is 10000 and maximum value is 110900.
label	string	The label for the dimension value. Column label has 320 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0101 Intentional homicide... and first 25 characters of maximum string: 1109 Other criminal acts...

Fact, Statfin rpk pxt 11tb px, Full history

Column	Type	Comment
iccs	int	Datasource did not contain a description for ICCS. Column iccs has 115200 rows, out of which 360 are empty, making the null percent 0.31. Minimum value is 10000 and maximum value is 110900.
sex	string	Datasource did not contain a description for Sex. Column sex has 115200 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.
nationality	int	Datasource did not contain a description for Nationality. Column nationality has 115200 rows, out of which 46080 are empty, making the null percent 40.00. Minimum value is 1 and maximum value is 999.
age_group	string	Datasource did not contain a description for Age_group. Column age_group has 115200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ala and maximum string is X.
year	int	Datasource did not contain a description for Year. Column year has 115200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2013 and maximum value is 2018.
persons_suspected_total	int	Datasource did not contain a description for Persons_suspected_total. Column persons_suspected_total has 115200 rows, out of which 53421 are empty, making the null percent 46.37. Minimum value is 0 and maximum value is 719100.
persons_suspected_principal_offence_rule	int	Datasource did not contain a description for Persons_suspected_principal_offence_rule. Column persons_suspected_principal_offence_rule has 115200 rows, out of which 53144 are empty, making the null percent 46.13. Minimum value is 0 and maximum value is 454726.
orig_extractdate	string	The date when the data was originally fetched from the source.

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

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

Additional Info

Last Updated	August 4, 2019
Created	August 2, 2019