1. Home
  2. Datasets
  3. 1.2. Toiselle kierrokselle ...
To download the data set, please sign up or log in

1.2. Toiselle kierrokselle päässeiden ehdokkaiden saamat äänimäärät ja äänimääräosuudet presidentinvaalissa 2006, 1 ja 2 vaali.

1.2. Toiselle kierrokselle päässeiden ehdokkaiden saamat äänimäärät ja äänimääräosuudet presidentinvaalissa 2006, 1 ja 2 vaali.

Tables

Column Descriptions

Fact, T110 pvaa tau 102 fi px, Latest

Column Type Comment
alue string Datasource did not contain a description for Alue. Column alue has 113364 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 004 and maximum string is 05941001.
ehdokas int Datasource did not contain a description for Ehdokas. Column ehdokas has 113364 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 9.
ehdokkaiden_kannatus string Datasource did not contain a description for Ehdokkaiden_kannatus. Column ehdokkaiden_kannatus has 113364 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Sar1 and maximum string is Sar12.
presidentinvaalit_2006 int Datasource did not contain a description for Presidentinvaalit_2006. Column presidentinvaalit_2006 has 113364 rows, out of which 2084 are empty, making the null percent 1.84. Minimum value is 0 and maximum value is 3149313.

Fact, T110 pvaa tau 102 fi px, Full history

Column Type Comment
alue string Datasource did not contain a description for Alue. Column alue has 113364 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 004 and maximum string is 05941001.
ehdokas int Datasource did not contain a description for Ehdokas. Column ehdokas has 113364 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 9.
ehdokkaiden_kannatus string Datasource did not contain a description for Ehdokkaiden_kannatus. Column ehdokkaiden_kannatus has 113364 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Sar1 and maximum string is Sar12.
presidentinvaalit_2006 int Datasource did not contain a description for Presidentinvaalit_2006. Column presidentinvaalit_2006 has 113364 rows, out of which 2084 are empty, making the null percent 1.84. Minimum value is 0 and maximum value is 3149313.
orig_extractdate string The date when the data was originally fetched from the source.

Dim ehdokas, T110 pvaa tau 102 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 9.
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 Sauli Niinistö and maximum string is Yhteensä.
orig_extractdate string The date when the data was originally fetched from the source.

Dim ehdokas, T110 pvaa tau 102 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 9.
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 Sauli Niinistö and maximum string is Yhteensä.

Dim alue, T110 pvaa tau 102 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 3149 rows, out of which 176 are empty, making the null percent 5.59. Minimum value is 4 and maximum value is 15976012.
label string The label for the dimension value. Column label has 3149 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 004 001 Hakola and maximum string is 941 001 Ä-alue 001.

Dim alue, T110 pvaa tau 102 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 3149 rows, out of which 176 are empty, making the null percent 5.59. Minimum value is 4 and maximum value is 15976012.
label string The label for the dimension value. Column label has 3149 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 004 001 Hakola and maximum string is 941 001 Ä-alue 001.
orig_extractdate string The date when the data was originally fetched from the source.

Dim ehdokkaiden kannatus, T110 pvaa tau 102 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 12 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Sar1 and maximum string is Sar12.
label string The label for the dimension value. Column label has 12 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 1 vaali, ennakkoääniä... and first 25 characters of maximum string: 2 vaali, osuus vaalipäivä...
orig_extractdate string The date when the data was originally fetched from the source.

Dim ehdokkaiden kannatus, T110 pvaa tau 102 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 12 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Sar1 and maximum string is Sar12.
label string The label for the dimension value. Column label has 12 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 1 vaali, ennakkoääniä... and first 25 characters of maximum string: 2 vaali, osuus vaalipäivä...

Additional Info

Last Updated July 21, 2019
Created July 14, 2019