007 -- Tieliikenteessä kuolleet ja loukkaantuneet ikäluokittain tienkäyttäjäryhmän mukaan vuosina 2003-2019

Tables

Dim henkilovahinko, Statfin ton pxt 007 fi px, Full historyTSV
Dimension Henkilovahinko (Henkilövahinko)
Dim henkilovahinko, Statfin ton pxt 007 fi px, LatestTSV
Dimension Henkilovahinko (Henkilövahinko)
Dim ikaluokka, Statfin ton pxt 007 fi px, Full historyTSV
Dimension Ikaluokka (Ikaluokka)
Dim ikaluokka, Statfin ton pxt 007 fi px, LatestTSV
Dimension Ikaluokka (Ikaluokka)
Dim kuukausi, Statfin ton pxt 007 fi px, LatestTSV
Dimension Kuukausi (Kuukausi)
Dim tiedot, Statfin ton pxt 007 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
Dim tiedot, Statfin ton pxt 007 fi px, LatestTSV
Dimension Tiedot (Tiedot)
Dim tienkayttajaryhma, Statfin ton pxt 007 fi px, Full historyTSV
Dimension Tienkayttajaryhma (Tienkäyttäjäryhmä)
Dim tienkayttajaryhma, Statfin ton pxt 007 fi px, LatestTSV
Dimension Tienkayttajaryhma (Tienkäyttäjäryhmä)
Dim vuosi, Statfin ton pxt 007 fi px, Full historyTSV
Dimension Vuosi (Vuosi)
Fact, Statfin ton pxt 007 fi px, Full historyTSV
Kuolleet ja loukkaantuneet tiekäyttäjäryhmittäin ja kuukausittain muuttujina Kuukausi, Ikaluokka, Vuosi, Henkilövahinko, Tienkäyttäjäryhmä ja Tiedot
Fact, Statfin ton pxt 007 fi px, LatestTSV
Kuolleet ja loukkaantuneet tiekäyttäjäryhmittäin ja kuukausittain muuttujina Kuukausi, Ikaluokka, Vuosi, Henkilövahinko, Tienkäyttäjäryhmä ja Tiedot

Column Descriptions

Fact, Statfin ton pxt 007 fi px, Full history

Column	Type	Comment
kuukausi	string	Datasource did not contain a description for Kuukausi. Column kuukausi has 83538 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.
ikaluokka	string	Datasource did not contain a description for Ikaluokka. Column ikaluokka has 83538 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-5 and maximum string is Tuntematon.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 83538 rows, out of which 9828 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 83538 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 83538 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 83538 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	int	Datasource did not contain a description for Kuolleet_ja_loukkaantuneet_tiekayttajaryhmittain_ja_kuukausittain. Column kuolleet_ja_loukkaantuneet_tiekayttajaryhmittain_ja_kuukausittain has 83538 rows, out of which 54173 are empty, making the null percent 64.85. Minimum value is 1 and maximum value is 9088.
orig_extractdate	string	The date when the data was originally fetched from the source.

Fact, Statfin ton pxt 007 fi px, Latest

Column	Type	Comment
kuukausi	string	Datasource did not contain a description for Kuukausi. Column kuukausi has 83538 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.
ikaluokka	string	Datasource did not contain a description for Ikaluokka. Column ikaluokka has 83538 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0-5 and maximum string is Tuntematon.
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 83538 rows, out of which 9828 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 83538 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 83538 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 83538 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	int	Datasource did not contain a description for Kuolleet_ja_loukkaantuneet_tiekayttajaryhmittain_ja_kuukausittain. Column kuolleet_ja_loukkaantuneet_tiekayttajaryhmittain_ja_kuukausittain has 83538 rows, out of which 54173 are empty, making the null percent 64.85. Minimum value is 1 and maximum value is 9088.

Dim ikaluokka, Statfin ton pxt 007 fi px, Full history

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

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

Column	Type	Comment
code	string	The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lkm.
label	string	The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lukumäärä.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim ikaluokka, Statfin ton pxt 007 fi px, Latest

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

Dim tienkayttajaryhma, Statfin ton pxt 007 fi px, Full history

Column	Type	Comment
code	string	The code for the dimension value. Column code has 9 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.
label	string	The label for the dimension value. Column label has 9 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.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim tiedot, Statfin ton pxt 007 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lkm.
label	string	The label for the dimension value. Column label has 1 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lukumäärä.

Dim kuukausi, Statfin ton pxt 007 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.

Dim vuosi, Statfin ton pxt 007 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 henkilovahinko, Statfin ton pxt 007 fi px, Full history

Column	Type	Comment
code	string	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 string is Kuolleet and maximum string is Vakavasti loukkaantuneet.
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 Kuolleet and maximum string is Vakavasti loukkaantuneet.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim henkilovahinko, Statfin ton pxt 007 fi px, Latest

Column	Type	Comment
code	string	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 string is Kuolleet and maximum string is Vakavasti loukkaantuneet.
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 Kuolleet and maximum string is Vakavasti loukkaantuneet.

Dim tienkayttajaryhma, Statfin ton pxt 007 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 9 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.
label	string	The label for the dimension value. Column label has 9 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.

Additional Info

Last Updated	September 22, 2019
Created	August 6, 2019