1. Home
  2. Datasets
  3. 5.3. Numbers and percentage ...
To download the data set, please sign up or log in

5.3. Numbers and percentage shares of elected councillors by party and constituency in Municipal elections 2017

5.3. Numbers and percentage shares of elected councillors by party and constituency in Municipal elections 2017

Tables

Column Descriptions

Dim sex, T630 kvaa 2017 tau 139 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 2.
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 Men and maximum string is Women.

Dim sex, T630 kvaa 2017 tau 139 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 2.
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 Men and maximum string is Women.
orig_extractdate string The date when the data was originally fetched from the source.

Dim number of elected councillors, T630 kvaa 2017 tau 139 px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 2 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 Sar2.
label string The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Number of elected council... and first 25 characters of maximum string: Proportion of elected cou...

Dim number of elected councillors, T630 kvaa 2017 tau 139 px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 2 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 Sar2.
label string The label for the dimension value. Column label has 2 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Number of elected council... and first 25 characters of maximum string: Proportion of elected cou...
orig_extractdate string The date when the data was originally fetched from the source.

Dim party, T630 kvaa 2017 tau 139 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 17 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 99.
label string The label for the dimension value. Column label has 17 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Constituency associations and maximum string is KTP.
orig_extractdate string The date when the data was originally fetched from the source.

Dim party, T630 kvaa 2017 tau 139 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 17 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 99.
label string The label for the dimension value. Column label has 17 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Constituency associations and maximum string is KTP.

Fact, T630 kvaa 2017 tau 139 px, Full history

Column Type Comment
district int Datasource did not contain a description for District. Column district has 31416 rows, out of which 1326 are empty, making the null percent 4.22. Minimum value is 5 and maximum value is 992.
party int Datasource did not contain a description for Party. Column party has 31416 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 99.
number_of_elected_councillors string Datasource did not contain a description for Number_of_elected_councillors. Column number_of_elected_councillors has 31416 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 Sar2.
sex int Datasource did not contain a description for Sex. Column sex has 31416 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 2.
municipal_elections_2017 int Datasource did not contain a description for Municipal_elections_2017. Column municipal_elections_2017 has 31416 rows, out of which 19916 are empty, making the null percent 63.39. Minimum value is 0 and maximum value is 8999.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T630 kvaa 2017 tau 139 px, Latest

Column Type Comment
district int Datasource did not contain a description for District. Column district has 31416 rows, out of which 1326 are empty, making the null percent 4.22. Minimum value is 5 and maximum value is 992.
party int Datasource did not contain a description for Party. Column party has 31416 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 99.
number_of_elected_councillors string Datasource did not contain a description for Number_of_elected_councillors. Column number_of_elected_councillors has 31416 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 Sar2.
sex int Datasource did not contain a description for Sex. Column sex has 31416 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 2.
municipal_elections_2017 int Datasource did not contain a description for Municipal_elections_2017. Column municipal_elections_2017 has 31416 rows, out of which 19916 are empty, making the null percent 63.39. Minimum value is 0 and maximum value is 8999.

Dim district, T630 kvaa 2017 tau 139 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 308 rows, out of which 13 are empty, making the null percent 4.22. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 308 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 Alajärvi and maximum string is 976 Ylitornio.
orig_extractdate string The date when the data was originally fetched from the source.

Dim district, T630 kvaa 2017 tau 139 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 308 rows, out of which 13 are empty, making the null percent 4.22. Minimum value is 5 and maximum value is 992.
label string The label for the dimension value. Column label has 308 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 005 Alajärvi and maximum string is 976 Ylitornio.

Additional Info

Last Updated July 20, 2019
Created July 13, 2019