007 -- Persons suspected of offences by main activity and age group 2011-2017
Tables
-
Dim Age Group, T007 Persons Suspected Of Offences By Main Activity And Age Group 2011 2017TSV
Dimension Age_group (Ikäluokka)
-
Dim Crime, T007 Persons Suspected Of Offences By Main Activity And Age Group 2011 2017TSV
Dimension Crime (Rikos)
-
Dim Main Activity, T007 Persons Suspected Of Offences By Main Activity And Age Group 2011 2017TSV
Dimension Main_activity (Pääasiallinen toiminta)
-
Dim Sex, T007 Persons Suspected Of Offences By Main Activity And Age Group 2011 2017TSV
Dimension Sex (Sukupuoli)
-
Dim Year, T007 Persons Suspected Of Offences By Main Activity And Age Group 2011 2017TSV
Dimension Year (Vuosi)
-
Fact, T007 Persons Suspected Of Offences By Main Activity And Age Group 2011 2017TSV
Persons suspected of offences by Year, Age group, Crime, Sex and Main activity
Column Descriptions
Fact, T007 Persons Suspected Of Offences By Main Activity And Age Group 2011 2017
Column | Type | Comment |
---|---|---|
year | int | Datasource did not contain a description for Year. Column year has 213885 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 213885 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 213885 rows, out of which 30870 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 213885 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. |
main_activity | int | Datasource did not contain a description for Main_activity. Column main_activity has 213885 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 99. |
persons_suspected_of_offences | int | Datasource did not contain a description for Persons_suspected_of_offences. Column persons_suspected_of_offences has 213885 rows, out of which 82073 are empty, making the null percent 38.37. Minimum value is 1 and maximum value is 795820. |
orig_extractdate | string | The date when the data was originally fetched from the source. |
Dim Year, T007 Persons Suspected Of Offences By Main Activity And Age Group 2011 2017
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 Age Group, T007 Persons Suspected Of Offences By Main Activity And Age Group 2011 2017
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 Crime, T007 Persons Suspected Of Offences By Main Activity And Age Group 2011 2017
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 Main Activity, T007 Persons Suspected Of Offences By Main Activity And Age Group 2011 2017
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 0 and maximum value is 99. |
label | string | 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 string is Employed and maximum string is No population information. |
orig_extractdate | string | The date when the data was originally fetched from the source. |
Dim Sex, T007 Persons Suspected Of Offences By Main Activity And Age Group 2011 2017
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. |
Additional Info
Last Updated | May 5, 2019 |
---|---|
Created | April 14, 2019 |