1. Home
  2. Datasets
  3. Ensimmäisen oikeusasteen ...
To download the data set, please sign up or log in

Ensimmäisen oikeusasteen sakkotuomiot ja rangaistusmääräykset päiväsakon luku- ja rahamäärän, sukupuolen, iän ja rikosryhmän mukaan, 2014

Ensimmäisen oikeusasteen sakkotuomiot ja rangaistusmääräykset päiväsakon luku- ja rahamäärän, sukupuolen, iän ja rikosryhmän mukaan, 2014

Tables

Column Descriptions

Fact, T095 syyttr tau 301 fi px, Full history

Column Type Comment
sukupuoli string Datasource did not contain a description for Sukupuoli. Column sukupuoli has 685440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is 9.
ikaluokka string Datasource did not contain a description for Ikaluokka. Column ikaluokka has 685440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 and maximum string is 11.
rikosryhma int Datasource did not contain a description for Rikosryhma. Column rikosryhma has 685440 rows, out of which 120960 are empty, making the null percent 17.65. Minimum value is 0 and maximum value is 99.
paivasakko int Datasource did not contain a description for Paivasakko. Column paivasakko has 685440 rows, out of which 122400 are empty, making the null percent 17.86. Minimum value is 101 and maximum value is 311.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 685440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2014.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 685440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Sakko_rm and maximum string is Yhtsak_rm.
rangaistumaaraykset_ja_sakkotuomiot_ensimmaisessa_oikeusasteessa_paivasakon_luku_ja_rahamaaran_sukupuolen_ian_ja_rikosryhman_mukaan_2014 int Datasource did not contain a description for Rangaistumaaraykset_ja_sakkotuomiot_ensimmaisessa_oikeusasteessa_paivasakon_luku_ja_rahamaaran_sukupuolen_ian_ja_rikosryhman_mukaan_2014. Column rangaistumaaraykset_ja_sakkotuomiot_ensimmaisessa_oikeusasteessa_paivasakon_luku_ja_rahamaaran_sukupuolen_ian_ja_rikosryhman_mukaan_2014 has 685440 rows, out of which 513118 are empty, making the null percent 74.86. Minimum value is 1 and maximum value is 198035.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T095 syyttr tau 301 fi px, Latest

Column Type Comment
sukupuoli string Datasource did not contain a description for Sukupuoli. Column sukupuoli has 685440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is 9.
ikaluokka string Datasource did not contain a description for Ikaluokka. Column ikaluokka has 685440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 01 and maximum string is 11.
rikosryhma int Datasource did not contain a description for Rikosryhma. Column rikosryhma has 685440 rows, out of which 120960 are empty, making the null percent 17.65. Minimum value is 0 and maximum value is 99.
paivasakko int Datasource did not contain a description for Paivasakko. Column paivasakko has 685440 rows, out of which 122400 are empty, making the null percent 17.86. Minimum value is 101 and maximum value is 311.
vuosi int Datasource did not contain a description for Vuosi. Column vuosi has 685440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2014.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 685440 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Sakko_rm and maximum string is Yhtsak_rm.
rangaistumaaraykset_ja_sakkotuomiot_ensimmaisessa_oikeusasteessa_paivasakon_luku_ja_rahamaaran_sukupuolen_ian_ja_rikosryhman_mukaan_2014 int Datasource did not contain a description for Rangaistumaaraykset_ja_sakkotuomiot_ensimmaisessa_oikeusasteessa_paivasakon_luku_ja_rahamaaran_sukupuolen_ian_ja_rikosryhman_mukaan_2014. Column rangaistumaaraykset_ja_sakkotuomiot_ensimmaisessa_oikeusasteessa_paivasakon_luku_ja_rahamaaran_sukupuolen_ian_ja_rikosryhman_mukaan_2014 has 685440 rows, out of which 513118 are empty, making the null percent 74.86. Minimum value is 1 and maximum value is 198035.

Additional Info

Last Updated July 19, 2019
Created July 14, 2019