006 -- Tieliikenteessä kuolleet ja loukkaantuneet tienkäyttäjäryhmittäin maakunnissa vuosina 2003-2019

Tables

Dim kuukausi, Statfin ton pxt 006 fi px, Full historyTSV
Dimension Kuukausi (Kuukausi)
Dim kuukausi, Statfin ton pxt 006 fi px, LatestTSV
Dimension Kuukausi (Kuukausi)
Dim maakunta, Statfin ton pxt 006 fi px, Full historyTSV
Dimension Maakunta (Maakunta)
Dim maakunta, Statfin ton pxt 006 fi px, LatestTSV
Dimension Maakunta (Maakunta)
Dim vuosi, Statfin ton pxt 006 fi px, Full historyTSV
Dimension Vuosi (Vuosi)
Dim vuosi, Statfin ton pxt 006 fi px, LatestTSV
Dimension Vuosi (Vuosi)
Fact, Statfin ton pxt 006 fi px, Full historyTSV
Kuolleet ja loukkaantuneet tiekäyttäjäryhmittäin ja kuukausittain maakunnissa muuttujina Kuukausi, Maakunta, Vuosi, Henkilövahinko, Tienkäyttäjäryhmä ja Tiedot
Fact, Statfin ton pxt 006 fi px, LatestTSV
Kuolleet ja loukkaantuneet tiekäyttäjäryhmittäin ja kuukausittain maakunnissa muuttujina Kuukausi, Maakunta, Vuosi, Henkilövahinko, Tienkäyttäjäryhmä ja Tiedot

Column Descriptions

Fact, Statfin ton pxt 006 fi px, Full history

Column	Type	Comment
kuukausi	string	Datasource did not contain a description for Kuukausi. Column kuukausi has 119340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Elokuu and maximum string is Joulukuu.
maakunta	string	Datasource did not contain a description for Maakunta. Column maakunta has 119340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahvenanmaa - Åland and maximum string is Lappi.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 119340 rows, out of which 14040 are empty, making the null percent 11.76. Minimum value is 2003 and maximum value is 2017.
henkilovahinko	string	Datasource did not contain a description for Henkilovahinko. Column henkilovahinko has 119340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kuolleet and maximum string is Vakavasti loukkaantuneet.
tienkayttajaryhma	string	Datasource did not contain a description for Tienkayttajaryhma. Column tienkayttajaryhma has 119340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Henkilöauton kuljettaja and maximum string is Muu kulkuneuvo.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 119340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lkm.
kuolleet_ja_loukkaantuneet_tiekayttajaryhmittain_ja_kuukausittain_maakunnissa	int	Datasource did not contain a description for Kuolleet_ja_loukkaantuneet_tiekayttajaryhmittain_ja_kuukausittain_maakunnissa. Column kuolleet_ja_loukkaantuneet_tiekayttajaryhmittain_ja_kuukausittain_maakunnissa has 119340 rows, out of which 77368 are empty, making the null percent 64.83. Minimum value is 1 and maximum value is 9088.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim vuosi, Statfin ton pxt 006 fi px, Latest

Column	Type	Comment
code	int	The code for the dimension value. Column code has 17 rows, out of which 2 are empty, making the null percent 11.76. Minimum value is 2003 and maximum value is 2017.
label	int	The label for the dimension value. Column label has 17 rows, out of which 2 are empty, making the null percent 11.76. Minimum value is 2003 and maximum value is 2017.

Dim kuukausi, Statfin ton pxt 006 fi 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 Elokuu and maximum string is Joulukuu.
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 Elokuu and maximum string is Joulukuu.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim kuukausi, Statfin ton pxt 006 fi 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 Elokuu and maximum string is Joulukuu.
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 Elokuu and maximum string is Joulukuu.

Fact, Statfin ton pxt 006 fi px, Latest

Column	Type	Comment
kuukausi	string	Datasource did not contain a description for Kuukausi. Column kuukausi has 119340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Elokuu and maximum string is Joulukuu.
maakunta	string	Datasource did not contain a description for Maakunta. Column maakunta has 119340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahvenanmaa - Åland and maximum string is Lappi.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 119340 rows, out of which 14040 are empty, making the null percent 11.76. Minimum value is 2003 and maximum value is 2017.
henkilovahinko	string	Datasource did not contain a description for Henkilovahinko. Column henkilovahinko has 119340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kuolleet and maximum string is Vakavasti loukkaantuneet.
tienkayttajaryhma	string	Datasource did not contain a description for Tienkayttajaryhma. Column tienkayttajaryhma has 119340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Henkilöauton kuljettaja and maximum string is Muu kulkuneuvo.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 119340 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lkm.
kuolleet_ja_loukkaantuneet_tiekayttajaryhmittain_ja_kuukausittain_maakunnissa	int	Datasource did not contain a description for Kuolleet_ja_loukkaantuneet_tiekayttajaryhmittain_ja_kuukausittain_maakunnissa. Column kuolleet_ja_loukkaantuneet_tiekayttajaryhmittain_ja_kuukausittain_maakunnissa has 119340 rows, out of which 77368 are empty, making the null percent 64.83. Minimum value is 1 and maximum value is 9088.

Dim maakunta, Statfin ton pxt 006 fi px, Full history

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

Dim vuosi, Statfin ton pxt 006 fi px, Full history

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

Dim maakunta, Statfin ton pxt 006 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahvenanmaa - Åland and maximum string is Lappi.
label	string	The label for the dimension value. Column label has 20 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahvenanmaa - Åland and maximum string is Lappi.

Additional Info

Last Updated	September 22, 2019
Created	August 6, 2019