1. Home
  2. Datasets
  3. 11 dg -- Duration of ...
To download the data set, please sign up or log in

11 dg -- Duration of apprehension, arrest, imprisonment and detention of an alien by police station by sex and age group, 2013-2018

11 dg -- Duration of apprehension, arrest, imprisonment and detention of an alien by police station by sex and age group, 2013-2018

Tables

Column Descriptions

Dim offence, Statfin rpk pxt 11dg px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 106 rows, out of which 11 are empty, making the null percent 10.38. Minimum value is 101 and maximum value is 899.
label string The label for the dimension value. Column label has 106 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: (Violent) resisting of an... and first 25 characters of maximum string: Other...
orig_extractdate string The date when the data was originally fetched from the source.

Dim offence, Statfin rpk pxt 11dg px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 106 rows, out of which 11 are empty, making the null percent 10.38. Minimum value is 101 and maximum value is 899.
label string The label for the dimension value. Column label has 106 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: (Violent) resisting of an... and first 25 characters of maximum string: Other...

Dim year, Statfin rpk pxt 11dg 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 age, Statfin rpk pxt 11dg px, Latest

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

Dim year, Statfin rpk pxt 11dg 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 coercive measure, Statfin rpk pxt 11dg px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is KI1SSS and maximum string is U6ASSS.
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. First 25 characters of minimum string: KI1 Apprehension... and first 25 characters of maximum string: U6A DETENTION OF A FOREIG...

Dim sex, Statfin rpk pxt 11dg px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 4 rows, out of which 2 are empty, making the null percent 50.00. Minimum value is 1 and maximum value is 2.
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 Females and maximum string is Unknown.

Fact, Statfin rpk pxt 11dg px, Full history

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 165360 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.
offence string Datasource did not contain a description for Offence. Column offence has 165360 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 00A and maximum string is 899.
coercive_measure string Datasource did not contain a description for Coercive_measure. Column coercive_measure has 165360 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is KI1SSS and maximum string is U6ASSS.
sex int Datasource did not contain a description for Sex. Column sex has 165360 rows, out of which 82680 are empty, making the null percent 50.00. Minimum value is 1 and maximum value is 2.
age string Datasource did not contain a description for Age. Column age has 165360 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 X.
duration_under_1_day int Datasource did not contain a description for Duration_under_1_day. Column duration_under_1_day has 165360 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 27597.
duration_1_to_1_9_days int Datasource did not contain a description for Duration_1_to_1_9_days. Column duration_1_to_1_9_days has 165360 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 4908.
duration_2_to_2_9_days int Datasource did not contain a description for Duration_2_to_2_9_days. Column duration_2_to_2_9_days has 165360 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 3067.
duration_3_to_3_9_days int Datasource did not contain a description for Duration_3_to_3_9_days. Column duration_3_to_3_9_days has 165360 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 1561.
duration_4_to_4_9_days int Datasource did not contain a description for Duration_4_to_4_9_days. Column duration_4_to_4_9_days has 165360 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 548.
duration_5_to_5_9_days int Datasource did not contain a description for Duration_5_to_5_9_days. Column duration_5_to_5_9_days has 165360 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 212.
duration_6_to_6_9_days int Datasource did not contain a description for Duration_6_to_6_9_days. Column duration_6_to_6_9_days has 165360 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 230.
duration_1_to_1_9_weeks int Datasource did not contain a description for Duration_1_to_1_9_weeks. Column duration_1_to_1_9_weeks has 165360 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 1047.
duration_2_to_2_9_weeks int Datasource did not contain a description for Duration_2_to_2_9_weeks. Column duration_2_to_2_9_weeks has 165360 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 273.
duration_3_weeks int Datasource did not contain a description for Duration_3_weeks. Column duration_3_weeks has 165360 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 418.
duration_1_to_1_9_months int Datasource did not contain a description for Duration_1_to_1_9_months. Column duration_1_to_1_9_months has 165360 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 274.
duration_2_to_2_9_months int Datasource did not contain a description for Duration_2_to_2_9_months. Column duration_2_to_2_9_months has 165360 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 96.
duration_3_months_and_over int Datasource did not contain a description for Duration_3_months_and_over. Column duration_3_months_and_over has 165360 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 75.
duration_not_known int Datasource did not contain a description for Duration_not_known. Column duration_not_known has 165360 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 186.
days_of_apprehension int Datasource did not contain a description for Days_of_apprehension. Column days_of_apprehension has 165360 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 61085.
days_of_arrest int Datasource did not contain a description for Days_of_arrest. Column days_of_arrest has 165360 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 19322.
days_of_detention int Datasource did not contain a description for Days_of_detention. Column days_of_detention has 165360 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 26524.
days_of_custody_of_an_alien int Datasource did not contain a description for Days_of_custody_of_an_alien. Column days_of_custody_of_an_alien has 165360 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 21247.
orig_extractdate string The date when the data was originally fetched from the source.

Dim sex, Statfin rpk pxt 11dg px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 4 rows, out of which 2 are empty, making the null percent 50.00. Minimum value is 1 and maximum value is 2.
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 Females and maximum string is Unknown.
orig_extractdate string The date when the data was originally fetched from the source.

Dim age, Statfin rpk pxt 11dg px, Full history

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

Dim coercive measure, Statfin rpk pxt 11dg px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 5 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is KI1SSS and maximum string is U6ASSS.
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. First 25 characters of minimum string: KI1 Apprehension... and first 25 characters of maximum string: U6A DETENTION OF A FOREIG...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, Statfin rpk pxt 11dg px, Latest

Column Type Comment
year int Datasource did not contain a description for Year. Column year has 165360 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.
offence string Datasource did not contain a description for Offence. Column offence has 165360 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 00A and maximum string is 899.
coercive_measure string Datasource did not contain a description for Coercive_measure. Column coercive_measure has 165360 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is KI1SSS and maximum string is U6ASSS.
sex int Datasource did not contain a description for Sex. Column sex has 165360 rows, out of which 82680 are empty, making the null percent 50.00. Minimum value is 1 and maximum value is 2.
age string Datasource did not contain a description for Age. Column age has 165360 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 X.
duration_under_1_day int Datasource did not contain a description for Duration_under_1_day. Column duration_under_1_day has 165360 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 27597.
duration_1_to_1_9_days int Datasource did not contain a description for Duration_1_to_1_9_days. Column duration_1_to_1_9_days has 165360 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 4908.
duration_2_to_2_9_days int Datasource did not contain a description for Duration_2_to_2_9_days. Column duration_2_to_2_9_days has 165360 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 3067.
duration_3_to_3_9_days int Datasource did not contain a description for Duration_3_to_3_9_days. Column duration_3_to_3_9_days has 165360 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 1561.
duration_4_to_4_9_days int Datasource did not contain a description for Duration_4_to_4_9_days. Column duration_4_to_4_9_days has 165360 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 548.
duration_5_to_5_9_days int Datasource did not contain a description for Duration_5_to_5_9_days. Column duration_5_to_5_9_days has 165360 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 212.
duration_6_to_6_9_days int Datasource did not contain a description for Duration_6_to_6_9_days. Column duration_6_to_6_9_days has 165360 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 230.
duration_1_to_1_9_weeks int Datasource did not contain a description for Duration_1_to_1_9_weeks. Column duration_1_to_1_9_weeks has 165360 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 1047.
duration_2_to_2_9_weeks int Datasource did not contain a description for Duration_2_to_2_9_weeks. Column duration_2_to_2_9_weeks has 165360 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 273.
duration_3_weeks int Datasource did not contain a description for Duration_3_weeks. Column duration_3_weeks has 165360 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 418.
duration_1_to_1_9_months int Datasource did not contain a description for Duration_1_to_1_9_months. Column duration_1_to_1_9_months has 165360 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 274.
duration_2_to_2_9_months int Datasource did not contain a description for Duration_2_to_2_9_months. Column duration_2_to_2_9_months has 165360 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 96.
duration_3_months_and_over int Datasource did not contain a description for Duration_3_months_and_over. Column duration_3_months_and_over has 165360 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 75.
duration_not_known int Datasource did not contain a description for Duration_not_known. Column duration_not_known has 165360 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 186.
days_of_apprehension int Datasource did not contain a description for Days_of_apprehension. Column days_of_apprehension has 165360 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 61085.
days_of_arrest int Datasource did not contain a description for Days_of_arrest. Column days_of_arrest has 165360 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 19322.
days_of_detention int Datasource did not contain a description for Days_of_detention. Column days_of_detention has 165360 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 26524.
days_of_custody_of_an_alien int Datasource did not contain a description for Days_of_custody_of_an_alien. Column days_of_custody_of_an_alien has 165360 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 21247.

Additional Info

Last Updated July 21, 2019
Created July 18, 2019