To download the data set, please sign up or log in

102 -- 1.2. Number and proportion of votes cast for the candidates in the second round in Presidential election 2012, first and second round.

102 -- 1.2. Number and proportion of votes cast for the candidates in the second round in Presidential election 2012, first and second round.

Tables

Column Descriptions

Dim district, T112 pvaa 2012 tau 102 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 2679 rows, out of which 179 are empty, making the null percent 6.68. Minimum value is 5 and maximum value is 15976009.
label string The label for the dimension value. Column label has 2679 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 021 Kirkonkylä I and maximum string is 941 001 Vårdö.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T112 pvaa 2012 tau 102 px, Full history

Column Type Comment
district string Datasource did not contain a description for District. Column district has 96444 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 and maximum string is 05941001.
candidate int Datasource did not contain a description for Candidate. Column candidate has 96444 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 6.
support_for_candidates string Datasource did not contain a description for Support_for_candidates. Column support_for_candidates has 96444 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.
1_2_number_and_proportion_of_votes_cast_for_the_candidates_in_the_second_round_in_presidential_election_2012_first_and_second_round int Datasource did not contain a description for 1_2_Number_and_proportion_of_votes_cast_for_the_candidates_in_the_second_round_in_Presidential_election_2012_first_and_second_round. Column 1_2_number_and_proportion_of_votes_cast_for_the_candidates_in_the_second_round_in_presidential_election_2012_first_and_second_round has 96444 rows, out of which 1436 are empty, making the null percent 1.49. Minimum value is 0 and maximum value is 3060771.
orig_extractdate string The date when the data was originally fetched from the source.

Dim district, T112 pvaa 2012 tau 102 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 2679 rows, out of which 179 are empty, making the null percent 6.68. Minimum value is 5 and maximum value is 15976009.
label string The label for the dimension value. Column label has 2679 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 021 Kirkonkylä I and maximum string is 941 001 Vårdö.

Dim candidate, T112 pvaa 2012 tau 102 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 6.
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 Pekka Haavisto and maximum string is Total.

Dim support for candidates, T112 pvaa 2012 tau 102 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: First round, advance vote... and first 25 characters of maximum string: Second round, proportion ...
orig_extractdate string The date when the data was originally fetched from the source.

Dim support for candidates, T112 pvaa 2012 tau 102 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: First round, advance vote... and first 25 characters of maximum string: Second round, proportion ...

Dim candidate, T112 pvaa 2012 tau 102 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 6.
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 Pekka Haavisto and maximum string is Total.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T112 pvaa 2012 tau 102 px, Latest

Column Type Comment
district string Datasource did not contain a description for District. Column district has 96444 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 and maximum string is 05941001.
candidate int Datasource did not contain a description for Candidate. Column candidate has 96444 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 6.
support_for_candidates string Datasource did not contain a description for Support_for_candidates. Column support_for_candidates has 96444 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.
1_2_number_and_proportion_of_votes_cast_for_the_candidates_in_the_second_round_in_presidential_election_2012_first_and_second_round int Datasource did not contain a description for 1_2_Number_and_proportion_of_votes_cast_for_the_candidates_in_the_second_round_in_Presidential_election_2012_first_and_second_round. Column 1_2_number_and_proportion_of_votes_cast_for_the_candidates_in_the_second_round_in_presidential_election_2012_first_and_second_round has 96444 rows, out of which 1436 are empty, making the null percent 1.49. Minimum value is 0 and maximum value is 3060771.

Additional Info

Last Updated July 19, 2019
Created July 12, 2019