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

009 -- Persons suspected of offences by socio-economic group and age gruop 2011-2017

009 -- Persons suspected of offences by socio-economic group and age gruop 2011-2017

Tables

Column Descriptions

Dim year, Statfinpas rpk pxt 009 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 year, Statfinpas rpk pxt 009 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 crime, Statfinpas rpk pxt 009 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 age group, Statfinpas rpk pxt 009 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 sex, Statfinpas rpk pxt 009 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 sex, Statfinpas rpk pxt 009 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.

Fact, Statfinpas rpk pxt 009 201700 px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 305550 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 305550 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 305550 rows, out of which 44100 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 305550 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.
socioeconomic_group int Datasource did not contain a description for Socioeconomic_group. Column socioeconomic_group has 305550 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 91.
persons_suspected_of_offences int Datasource did not contain a description for Persons_suspected_of_offences. Column persons_suspected_of_offences has 305550 rows, out of which 125883 are empty, making the null percent 41.20. Minimum value is 1 and maximum value is 795820.

Dim crime, Statfinpas rpk pxt 009 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...

Fact, Statfinpas rpk pxt 009 201700 px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 305550 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 305550 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 305550 rows, out of which 44100 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 305550 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.
socioeconomic_group int Datasource did not contain a description for Socioeconomic_group. Column socioeconomic_group has 305550 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 91.
persons_suspected_of_offences int Datasource did not contain a description for Persons_suspected_of_offences. Column persons_suspected_of_offences has 305550 rows, out of which 125883 are empty, making the null percent 41.20. Minimum value is 1 and maximum value is 795820.
orig_extractdate string The date when the data was originally fetched from the source.

Dim socioeconomic group, Statfinpas rpk pxt 009 201700 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 0 and maximum value is 91.
label string 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 string is Lower-level employees and maximum string is No population information.
orig_extractdate string The date when the data was originally fetched from the source.

Dim socioeconomic group, Statfinpas rpk pxt 009 201700 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 0 and maximum value is 91.
label string 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 string is Lower-level employees and maximum string is No population information.

Dim age group, Statfinpas rpk pxt 009 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.

Additional Info

Last Updated September 20, 2019
Created August 4, 2019