11 cg -- Crimes and their clearance after Crime nomenclature, 2010-2018

Tables

Dim offence, Statfin rpk pxt 11cg px, Full historyTSV
Dimension Offence (Rikos)
Dim offence, Statfin rpk pxt 11cg px, LatestTSV
Dimension Offence (Rikos)
Dim police department, Statfin rpk pxt 11cg px, Full historyTSV
Dimension Police_department (Poliisilaitos)
Dim police department, Statfin rpk pxt 11cg px, LatestTSV
Dimension Police_department (Poliisilaitos)
Fact, Statfin rpk pxt 11cg px, Full historyTSV
Crimes and their clearance by Police department, Offence, Year and Information
Fact, Statfin rpk pxt 11cg px, LatestTSV
Crimes and their clearance by Police department, Offence, Year and Information

Column Descriptions

Fact, Statfin rpk pxt 11cg px, Full history

Column	Type	Comment
police_department	int	Datasource did not contain a description for Police_department. Column police_department has 164304 rows, out of which 10269 are empty, making the null percent 6.25. Minimum value is 2400 and maximum value is 9180.
offence	int	Datasource did not contain a description for Offence. Column offence has 164304 rows, out of which 31248 are empty, making the null percent 19.02. Minimum value is 110101 and maximum value is 999999.
year	int	Datasource did not contain a description for Year. Column year has 164304 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2018.
offences_reported_to_the_authorities	int	Datasource did not contain a description for Offences_reported_to_the_authorities. Column offences_reported_to_the_authorities has 164304 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 962829.
solved_offences_total	int	Datasource did not contain a description for Solved_offences_total. Column solved_offences_total has 164304 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 763199.
offences_reported_to_the_prosecutor_total	int	Datasource did not contain a description for Offences_reported_to_the_prosecutor_total. Column offences_reported_to_the_prosecutor_total has 164304 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 721720.
persons_suspected_of_solved_offences	int	Datasource did not contain a description for Persons_suspected_of_solved_offences. Column persons_suspected_of_solved_offences has 164304 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 795820.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin rpk pxt 11cg px, Latest

Column	Type	Comment
police_department	int	Datasource did not contain a description for Police_department. Column police_department has 164304 rows, out of which 10269 are empty, making the null percent 6.25. Minimum value is 2400 and maximum value is 9180.
offence	int	Datasource did not contain a description for Offence. Column offence has 164304 rows, out of which 31248 are empty, making the null percent 19.02. Minimum value is 110101 and maximum value is 999999.
year	int	Datasource did not contain a description for Year. Column year has 164304 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2010 and maximum value is 2018.
offences_reported_to_the_authorities	int	Datasource did not contain a description for Offences_reported_to_the_authorities. Column offences_reported_to_the_authorities has 164304 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 962829.
solved_offences_total	int	Datasource did not contain a description for Solved_offences_total. Column solved_offences_total has 164304 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 763199.
offences_reported_to_the_prosecutor_total	int	Datasource did not contain a description for Offences_reported_to_the_prosecutor_total. Column offences_reported_to_the_prosecutor_total has 164304 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 721720.
persons_suspected_of_solved_offences	int	Datasource did not contain a description for Persons_suspected_of_solved_offences. Column persons_suspected_of_solved_offences has 164304 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 795820.

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

Column	Type	Comment
code	int	The code for the dimension value. Column code has 1141 rows, out of which 217 are empty, making the null percent 19.02. Minimum value is 110101 and maximum value is 999999.
label	string	The label for the dimension value. Column label has 1141 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Abandonment 21:14§... and first 25 characters of maximum string: Offence category unknown ...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim offence, Statfin rpk pxt 11cg px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 1141 rows, out of which 217 are empty, making the null percent 19.02. Minimum value is 110101 and maximum value is 999999.
label	string	The label for the dimension value. Column label has 1141 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Abandonment 21:14§... and first 25 characters of maximum string: Offence category unknown ...

Dim police department, Statfin rpk pxt 11cg px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 16 rows, out of which 1 are empty, making the null percent 6.25. Minimum value is 2400 and maximum value is 9180.
label	string	The label for the dimension value. Column label has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Central Finland Police De... and first 25 characters of maximum string: The Finnish Border Guard...

Dim police department, Statfin rpk pxt 11cg px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 16 rows, out of which 1 are empty, making the null percent 6.25. Minimum value is 2400 and maximum value is 9180.
label	string	The label for the dimension value. Column label has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Central Finland Police De... and first 25 characters of maximum string: The Finnish Border Guard...
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	July 21, 2019
Created	July 18, 2019