007 -- Rikesakkoon määrätyt tai tuomitut sukupuolen ja iän mukaan 2013-2017

Tables

Dim ika, Statfin syyttr pxt 007 fi px, Full historyTSV
Dimension Ika (Ikä)
Dim ika, Statfin syyttr pxt 007 fi px, LatestTSV
Dimension Ika (Ikä)
Dim rikesakon suuruus, Statfin syyttr pxt 007 fi px, Full historyTSV
Dimension Rikesakon_suuruus (Rikesakon suuruus)
Dim rikesakon suuruus, Statfin syyttr pxt 007 fi px, LatestTSV
Dimension Rikesakon_suuruus (Rikesakon suuruus)
Dim sukupuoli, Statfin syyttr pxt 007 fi px, Full historyTSV
Dimension Sukupuoli (Sukupuoli)
Dim sukupuoli, Statfin syyttr pxt 007 fi px, LatestTSV
Dimension Sukupuoli (Sukupuoli)
Dim tiedot, Statfin syyttr pxt 007 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
Dim tiedot, Statfin syyttr pxt 007 fi px, LatestTSV
Dimension Tiedot (Tiedot)
Dim vuosi, Statfin syyttr pxt 007 fi px, Full historyTSV
Dimension Vuosi (Vuosi)
Dim vuosi, Statfin syyttr pxt 007 fi px, LatestTSV
Dimension Vuosi (Vuosi)
Fact, Statfin syyttr pxt 007 fi px, Full historyTSV
007 -- Rikesakkoon määrätyt tai tuomitut sukupuolen ja iän mukaan 2013-2017
Fact, Statfin syyttr pxt 007 fi px, LatestTSV
007 -- Rikesakkoon määrätyt tai tuomitut sukupuolen ja iän mukaan 2013-2017

Column Descriptions

Fact, Statfin syyttr pxt 007 fi px, Full history

Column	Type	Comment
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 10920 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 2017.
sukupuoli	int	Datasource did not contain a description for Sukupuoli. Column sukupuoli has 10920 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 2.
ika	int	Datasource did not contain a description for Ika. Column ika has 10920 rows, out of which 8400 are empty, making the null percent 76.92. Minimum value is 15 and maximum value is 17.
rikesakon_suuruus	string	Datasource did not contain a description for Rikesakon_suuruus. Column rikesakon_suuruus has 10920 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 euroa and maximum string is 240 euroa.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 10920 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kamlkm and maximum string is Rslkm.
rikesakkoon_maaratyt_tai_tuomitut_sukupuolen_ja_ian_mukaan_20132017	int	Datasource did not contain a description for Rikesakkoon_maaratyt_tai_tuomitut_sukupuolen_ja_ian_mukaan_20132017. Column rikesakkoon_maaratyt_tai_tuomitut_sukupuolen_ja_ian_mukaan_20132017 has 10920 rows, out of which 7529 are empty, making the null percent 68.95. Minimum value is 1 and maximum value is 330602.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin syyttr pxt 007 fi px, Latest

Column	Type	Comment
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 10920 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 2017.
sukupuoli	int	Datasource did not contain a description for Sukupuoli. Column sukupuoli has 10920 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 2.
ika	int	Datasource did not contain a description for Ika. Column ika has 10920 rows, out of which 8400 are empty, making the null percent 76.92. Minimum value is 15 and maximum value is 17.
rikesakon_suuruus	string	Datasource did not contain a description for Rikesakon_suuruus. Column rikesakon_suuruus has 10920 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 euroa and maximum string is 240 euroa.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 10920 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kamlkm and maximum string is Rslkm.
rikesakkoon_maaratyt_tai_tuomitut_sukupuolen_ja_ian_mukaan_20132017	int	Datasource did not contain a description for Rikesakkoon_maaratyt_tai_tuomitut_sukupuolen_ja_ian_mukaan_20132017. Column rikesakkoon_maaratyt_tai_tuomitut_sukupuolen_ja_ian_mukaan_20132017 has 10920 rows, out of which 7529 are empty, making the null percent 68.95. Minimum value is 1 and maximum value is 330602.

Dim vuosi, Statfin syyttr pxt 007 fi px, Full history

Column	Type	Comment
code	int	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 value is 2013 and maximum value is 2017.
label	int	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. Minimum value is 2013 and maximum value is 2017.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim vuosi, Statfin syyttr pxt 007 fi px, Latest

Column	Type	Comment
code	int	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 value is 2013 and maximum value is 2017.
label	int	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. Minimum value is 2013 and maximum value is 2017.

Dim sukupuoli, Statfin syyttr pxt 007 fi px, Latest

Column	Type	Comment
code	int	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 value is 0 and maximum value is 2.
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 Miehet and maximum string is Naiset.

Dim sukupuoli, Statfin syyttr pxt 007 fi px, Full history

Column	Type	Comment
code	int	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 value is 0 and maximum value is 2.
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 Miehet and maximum string is Naiset.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim ika, Statfin syyttr pxt 007 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 13 rows, out of which 10 are empty, making the null percent 76.92. Minimum value is 15 and maximum value is 17.
label	int	The label for the dimension value. Column label has 13 rows, out of which 10 are empty, making the null percent 76.92. Minimum value is 15 and maximum value is 17.

Dim ika, Statfin syyttr pxt 007 fi px, Full history

Column	Type	Comment
code	int	The code for the dimension value. Column code has 13 rows, out of which 10 are empty, making the null percent 76.92. Minimum value is 15 and maximum value is 17.
label	int	The label for the dimension value. Column label has 13 rows, out of which 10 are empty, making the null percent 76.92. Minimum value is 15 and maximum value is 17.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim rikesakon suuruus, Statfin syyttr pxt 007 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 28 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 euroa and maximum string is 240 euroa.
label	string	The label for the dimension value. Column label has 28 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 euroa and maximum string is 240 euroa.

Dim rikesakon suuruus, Statfin syyttr pxt 007 fi px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 28 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 euroa and maximum string is 240 euroa.
label	string	The label for the dimension value. Column label has 28 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0 euroa and maximum string is 240 euroa.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim tiedot, Statfin syyttr pxt 007 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kamlkm and maximum string is Rslkm.
label	string	The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ajoneuvoa pysäyttämättä and maximum string is Rikesakkoja yhteensä.

Dim tiedot, Statfin syyttr pxt 007 fi px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kamlkm and maximum string is Rslkm.
label	string	The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ajoneuvoa pysäyttämättä and maximum string is Rikesakkoja yhteensä.
orig_extractdate	string	The date when the data was originally fetched from the source.

Additional Info

Last Updated	July 31, 2019
Created	July 31, 2019