1. Home
  2. Datasets
  3. 003 -- Tietoon tulleet ...
To download the data set, please sign up or log in

003 -- Tietoon tulleet rikokset ja niiden selvittäminen 2010-2017

003 -- Tietoon tulleet rikokset ja niiden selvittäminen 2010-2017

Tables

Column Descriptions

Fact, Statfinpas rpk pxt 003 201700 fi px, Latest

Column Type Comment
rikos int Datasource did not contain a description for Rikos. Column rikos has 579584 rows, out of which 111616 are empty, making the null percent 19.26. Minimum value is 110101 and maximum value is 999999.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 579584 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ep and maximum string is Syytt.
poliisilaitos int Datasource did not contain a description for Poliisilaitos. Column poliisilaitos has 579584 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 9180.
vuosi int Teon ilmoitusvuosi. Rikos on voinut tapahtua myös aiemmin, mutta se kirjataan ilmoitusvuodelle. Selvitetyissä rikoksissa selvitysvuosi. . Column vuosi has 579584 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 2017.
rikokset_ja_niiden_selvittaminen int Datasource did not contain a description for Rikokset_ja_niiden_selvittaminen. Column rikokset_ja_niiden_selvittaminen has 579584 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.

Fact, Statfinpas rpk pxt 003 201700 fi px, Full history

Column Type Comment
rikos int Datasource did not contain a description for Rikos. Column rikos has 579584 rows, out of which 111616 are empty, making the null percent 19.26. Minimum value is 110101 and maximum value is 999999.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 579584 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ep and maximum string is Syytt.
poliisilaitos int Datasource did not contain a description for Poliisilaitos. Column poliisilaitos has 579584 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 9180.
vuosi int Teon ilmoitusvuosi. Rikos on voinut tapahtua myös aiemmin, mutta se kirjataan ilmoitusvuodelle. Selvitetyissä rikoksissa selvitysvuosi. . Column vuosi has 579584 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 2017.
rikokset_ja_niiden_selvittaminen int Datasource did not contain a description for Rikokset_ja_niiden_selvittaminen. Column rikokset_ja_niiden_selvittaminen has 579584 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.
orig_extractdate string The date when the data was originally fetched from the source.

Dim rikos, Statfinpas rpk pxt 003 201700 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 1132 rows, out of which 218 are empty, making the null percent 19.26. Minimum value is 110101 and maximum value is 999999.
label string The label for the dimension value. Column label has 1132 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 11 Luku. Sotarikoksista j... and first 25 characters of maximum string: Kiinteistötoimitusrikos (...

Dim rikos, Statfinpas rpk pxt 003 201700 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 1132 rows, out of which 218 are empty, making the null percent 19.26. Minimum value is 110101 and maximum value is 999999.
label string The label for the dimension value. Column label has 1132 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 11 Luku. Sotarikoksista j... and first 25 characters of maximum string: Kiinteistötoimitusrikos (...
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfinpas rpk pxt 003 201700 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ep and maximum string is Syytt.
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. First 25 characters of minimum string: Selvitettyihin rikoksiin ... and first 25 characters of maximum string: Syyttäjälle ilmoitetut ri...
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, Statfinpas rpk pxt 003 201700 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ep and maximum string is Syytt.
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. First 25 characters of minimum string: Selvitettyihin rikoksiin ... and first 25 characters of maximum string: Syyttäjälle ilmoitetut ri...

Dim poliisilaitos, Statfinpas rpk pxt 003 201700 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 16 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 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. Minimum string is Ahvenanmaan poliisilaitos and maximum string is Rajavartiolaitos.
orig_extractdate string The date when the data was originally fetched from the source.

Dim poliisilaitos, Statfinpas rpk pxt 003 201700 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 16 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 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. Minimum string is Ahvenanmaan poliisilaitos and maximum string is Rajavartiolaitos.

Dim vuosi, Statfinpas rpk pxt 003 201700 fi 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 2010 and maximum value is 2017.
label int 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 value is 2010 and maximum value is 2017.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vuosi, Statfinpas rpk pxt 003 201700 fi 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 2010 and maximum value is 2017.
label int 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 value is 2010 and maximum value is 2017.

Additional Info

Last Updated July 10, 2019
Created July 9, 2019