008 -- Persons suspected of offences by level of education and age gruop 2011-2017

Tables

Dim age group, Statfinpas rpk pxt 008 201700 px, Full historyTSV
Dimension Age_group (Ikäluokka)
Dim age group, Statfinpas rpk pxt 008 201700 px, LatestTSV
Dimension Age_group (Ikäluokka)
Dim crime, Statfinpas rpk pxt 008 201700 px, Full historyTSV
Dimension Crime (Rikos)
Dim crime, Statfinpas rpk pxt 008 201700 px, LatestTSV
Dimension Crime (Rikos)
Dim level of education, Statfinpas rpk pxt 008 201700 px, Full historyTSV
Dimension Level_of_education (Koulutusaste)
Dim level of education, Statfinpas rpk pxt 008 201700 px, LatestTSV
Dimension Level_of_education (Koulutusaste)
Dim sex, Statfinpas rpk pxt 008 201700 px, Full historyTSV
Dimension Sex (Sukupuoli)
Dim sex, Statfinpas rpk pxt 008 201700 px, LatestTSV
Dimension Sex (Sukupuoli)
Dim year, Statfinpas rpk pxt 008 201700 px, Full historyTSV
Dimension Year (Vuosi)
Dim year, Statfinpas rpk pxt 008 201700 px, LatestTSV
Dimension Year (Vuosi)
Fact, Statfinpas rpk pxt 008 201700 px, Full historyTSV
Persons suspected of offences by Year, Age group, Crime, Sex and Level of education
Fact, Statfinpas rpk pxt 008 201700 px, LatestTSV
Persons suspected of offences by Year, Age group, Crime, Sex and Level of education

Column Descriptions

Fact, Statfinpas rpk pxt 008 201700 px, Full history

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 244440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2011 and maximum value is 2017.
age_group	int	Datasource did not contain a description for Age_group. Column age_group has 244440 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 14.
crime	int	Datasource did not contain a description for Crime. Column crime has 244440 rows, out of which 35280 are empty, making the null percent 14.43. Minimum value is 101 and maximum value is 603.
sex	string	Datasource did not contain a description for Sex. Column sex has 244440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is M and maximum string is N.
level_of_education	int	Datasource did not contain a description for Level_of_education. Column level_of_education has 244440 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 7.
persons_suspected_of_offences	int	Datasource did not contain a description for Persons_suspected_of_offences. Column persons_suspected_of_offences has 244440 rows, out of which 118485 are empty, making the null percent 48.47. Minimum value is 1 and maximum value is 795820.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfinpas rpk pxt 008 201700 px, Latest

Column	Type	Comment
year	int	Datasource did not contain a description for Year. Column year has 244440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2011 and maximum value is 2017.
age_group	int	Datasource did not contain a description for Age_group. Column age_group has 244440 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 14.
crime	int	Datasource did not contain a description for Crime. Column crime has 244440 rows, out of which 35280 are empty, making the null percent 14.43. Minimum value is 101 and maximum value is 603.
sex	string	Datasource did not contain a description for Sex. Column sex has 244440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is M and maximum string is N.
level_of_education	int	Datasource did not contain a description for Level_of_education. Column level_of_education has 244440 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 7.
persons_suspected_of_offences	int	Datasource did not contain a description for Persons_suspected_of_offences. Column persons_suspected_of_offences has 244440 rows, out of which 118485 are empty, making the null percent 48.47. Minimum value is 1 and maximum value is 795820.

Dim level of education, Statfinpas rpk pxt 008 201700 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 8 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 7.
label	string	The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Education total and maximum string is No population information.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim age group, Statfinpas rpk pxt 008 201700 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 15 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 14.
label	string	The label for the dimension value. Column label has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 - 14 and maximum string is Over 70.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim sex, Statfinpas rpk pxt 008 201700 px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is M and maximum string is N.
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 Men and maximum string is Woman.

Dim year, Statfinpas rpk pxt 008 201700 px, Latest

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

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

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

Dim crime, Statfinpas rpk pxt 008 201700 px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 97 rows, out of which 14 are empty, making the null percent 14.43. Minimum value is 101 and maximum value is 603.
label	string	The label for the dimension value. Column label has 97 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: .Alcohol offences total... and first 25 characters of maximum string: Traffic infraction, viola...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim sex, Statfinpas rpk pxt 008 201700 px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is M and maximum string is N.
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 Men and maximum string is Woman.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim age group, Statfinpas rpk pxt 008 201700 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 15 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 14.
label	string	The label for the dimension value. Column label has 15 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 - 14 and maximum string is Over 70.

Dim level of education, Statfinpas rpk pxt 008 201700 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 8 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 7.
label	string	The label for the dimension value. Column label has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Education total and maximum string is No population information.

Dim crime, Statfinpas rpk pxt 008 201700 px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 97 rows, out of which 14 are empty, making the null percent 14.43. Minimum value is 101 and maximum value is 603.
label	string	The label for the dimension value. Column label has 97 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: .Alcohol offences total... and first 25 characters of maximum string: Traffic infraction, viola...

Additional Info

Last Updated	September 22, 2019
Created	August 5, 2019