008 -- Tieliikenteessä kuolleet ja loukkaantuneet onnettomuustyypin ja tienkäyttäjäryhmän mukaan vuosina 2003-2019

Tables

Dim henkilovahinko, Statfin ton pxt 008 fi px, Full historyTSV
Dimension Henkilovahinko (Henkilövahinko)
Dim henkilovahinko, Statfin ton pxt 008 fi px, LatestTSV
Dimension Henkilovahinko (Henkilövahinko)
Dim kuukausi, Statfin ton pxt 008 fi px, Full historyTSV
Dimension Kuukausi (Kuukausi)
Dim kuukausi, Statfin ton pxt 008 fi px, LatestTSV
Dimension Kuukausi (Kuukausi)
Dim onnettomuustyyppi, Statfin ton pxt 008 fi px, Full historyTSV
Dimension Onnettomuustyyppi (Onnettomuustyyppi)
Dim onnettomuustyyppi, Statfin ton pxt 008 fi px, LatestTSV
Dimension Onnettomuustyyppi (Onnettomuustyyppi)
Dim tiedot, Statfin ton pxt 008 fi px, Full historyTSV
Dimension Tiedot (Tiedot)
Dim tiedot, Statfin ton pxt 008 fi px, LatestTSV
Dimension Tiedot (Tiedot)
Dim tienkayttajaryhma, Statfin ton pxt 008 fi px, Full historyTSV
Dimension Tienkayttajaryhma (Tienkäyttäjäryhmä)
Dim tienkayttajaryhma, Statfin ton pxt 008 fi px, LatestTSV
Dimension Tienkayttajaryhma (Tienkäyttäjäryhmä)
Dim vuosi, Statfin ton pxt 008 fi px, Full historyTSV
Dimension Vuosi (Vuosi)
Dim vuosi, Statfin ton pxt 008 fi px, LatestTSV
Dimension Vuosi (Vuosi)
Fact, Statfin ton pxt 008 fi px, Full historyTSV
Kuolleet ja loukkaantuneet onnettomuustyypin ja tienkäyttäjäryhmän mukaan muuttujina Kuukausi, Onnettomuustyyppi, Vuosi, Henkilövahinko, Tiedot ja Tienkäyttäjäryhmä
Fact, Statfin ton pxt 008 fi px, LatestTSV
Kuolleet ja loukkaantuneet onnettomuustyypin ja tienkäyttäjäryhmän mukaan muuttujina Kuukausi, Onnettomuustyyppi, Vuosi, Henkilövahinko, Tiedot ja Tienkäyttäjäryhmä

Column Descriptions

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

Column	Type	Comment
code	string	The code for the dimension value. Column code has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0. Samat ajosuunnat (ajo ... and first 25 characters of maximum string: 9. Muu onnettomuus...
label	string	The label for the dimension value. Column label has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0. Samat ajosuunnat (ajo ... and first 25 characters of maximum string: 9. Muu onnettomuus...
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim tienkayttajaryhma, Statfin ton pxt 008 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 tienkayttajaryhma, Statfin ton pxt 008 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.

Dim henkilovahinko, Statfin ton pxt 008 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 tiedot, Statfin ton pxt 008 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 tiedot, Statfin ton pxt 008 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.

Fact, Statfin ton pxt 008 fi px, Latest

Column	Type	Comment
kuukausi	string	Datasource did not contain a description for Kuukausi. Column kuukausi has 65637 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.
onnettomuustyyppi	string	Datasource did not contain a description for Onnettomuustyyppi. Column onnettomuustyyppi has 65637 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0. Samat ajosuunnat (ajo ... and first 25 characters of maximum string: 9. Muu onnettomuus...
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 65637 rows, out of which 7722 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 65637 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.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 65637 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lkm.
tienkayttajaryhma	string	Datasource did not contain a description for Tienkayttajaryhma. Column tienkayttajaryhma has 65637 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.
kuolleet_ja_loukkaantuneet_onnettomuustyypin_ja_tienkayttajaryhman_mukaan	int	Datasource did not contain a description for Kuolleet_ja_loukkaantuneet_onnettomuustyypin_ja_tienkayttajaryhman_mukaan. Column kuolleet_ja_loukkaantuneet_onnettomuustyypin_ja_tienkayttajaryhman_mukaan has 65637 rows, out of which 42314 are empty, making the null percent 64.47. Minimum value is 1 and maximum value is 9088.

Fact, Statfin ton pxt 008 fi px, Full history

Column	Type	Comment
kuukausi	string	Datasource did not contain a description for Kuukausi. Column kuukausi has 65637 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.
onnettomuustyyppi	string	Datasource did not contain a description for Onnettomuustyyppi. Column onnettomuustyyppi has 65637 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0. Samat ajosuunnat (ajo ... and first 25 characters of maximum string: 9. Muu onnettomuus...
vuosi	int	Datasource did not contain a description for Vuosi. Column vuosi has 65637 rows, out of which 7722 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 65637 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.
tiedot	string	Datasource did not contain a description for Tiedot. Column tiedot has 65637 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lkm.
tienkayttajaryhma	string	Datasource did not contain a description for Tienkayttajaryhma. Column tienkayttajaryhma has 65637 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.
kuolleet_ja_loukkaantuneet_onnettomuustyypin_ja_tienkayttajaryhman_mukaan	int	Datasource did not contain a description for Kuolleet_ja_loukkaantuneet_onnettomuustyypin_ja_tienkayttajaryhman_mukaan. Column kuolleet_ja_loukkaantuneet_onnettomuustyypin_ja_tienkayttajaryhman_mukaan has 65637 rows, out of which 42314 are empty, making the null percent 64.47. Minimum value is 1 and maximum value is 9088.
orig_extractdate	string	The date when the data was originally fetched from the source.

Dim onnettomuustyyppi, Statfin ton pxt 008 fi px, Latest

Column	Type	Comment
code	string	The code for the dimension value. Column code has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0. Samat ajosuunnat (ajo ... and first 25 characters of maximum string: 9. Muu onnettomuus...
label	string	The label for the dimension value. Column label has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 0. Samat ajosuunnat (ajo ... and first 25 characters of maximum string: 9. Muu onnettomuus...

Dim vuosi, Statfin ton pxt 008 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.

Additional Info

Last Updated	July 21, 2019
Created	July 13, 2019