1. Home
  2. Datasets
  3. 5.9. Earlier council ...
To download the data set, please sign up or log in

5.9. Earlier council experience of elected municipal councillors by type of municipality, sex and party in Municipal elections 2017

5.9. Earlier council experience of elected municipal councillors by type of municipality, sex and party in Municipal elections 2017

Tables

Column Descriptions

Dim sex, T730 kvaa 2017 tau 149 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 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 Both sexes and maximum string is Females.

Dim information, T730 kvaa 2017 tau 149 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 Lkm13 and maximum string is Lkm14.
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. First 25 characters of minimum string: Councillors total... and first 25 characters of maximum string: Sitting memebers of Parli...
orig_extractdate string The date when the data was originally fetched from the source.

Dim parties and constituency associations, T730 kvaa 2017 tau 149 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 IP.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T730 kvaa 2017 tau 149 px, Latest

Column Type Comment
information string Information . Column information has 612 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Lkm13 and maximum string is Lkm14.
sex int sex of the councillor . Column sex has 612 rows, out of which 204 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
area int Mainland Finland, statistical grouping of municipalities, (municipality+ statistical grouping of municipalities in force 1.1.2013) . Column area has 612 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 3000.
parties_and_constituency_associations int Parties and constituencies which nominated candidates in Municipal elections 2012 in Mainland Finland . Column parties_and_constituency_associations has 612 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.
municipal_elections_2017 int Datasource did not contain a description for Municipal_elections_2017. Column municipal_elections_2017 has 612 rows, out of which 244 are empty, making the null percent 39.87. Minimum value is 1 and maximum value is 8999.

Dim parties and constituency associations, T730 kvaa 2017 tau 149 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 IP.

Dim sex, T730 kvaa 2017 tau 149 px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 1 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 Both sexes and maximum string is Females.
orig_extractdate string The date when the data was originally fetched from the source.

Dim area, T730 kvaa 2017 tau 149 px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 4 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 3000.
label string The label for the dimension value. Column label has 4 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Mainland Finland and maximum string is Rural municipalities.

Dim area, T730 kvaa 2017 tau 149 px, Full history

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

Fact, T730 kvaa 2017 tau 149 px, Full history

Column Type Comment
information string Information . Column information has 612 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Lkm13 and maximum string is Lkm14.
sex int sex of the councillor . Column sex has 612 rows, out of which 204 are empty, making the null percent 33.33. Minimum value is 1 and maximum value is 2.
area int Mainland Finland, statistical grouping of municipalities, (municipality+ statistical grouping of municipalities in force 1.1.2013) . Column area has 612 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 3000.
parties_and_constituency_associations int Parties and constituencies which nominated candidates in Municipal elections 2012 in Mainland Finland . Column parties_and_constituency_associations has 612 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.
municipal_elections_2017 int Datasource did not contain a description for Municipal_elections_2017. Column municipal_elections_2017 has 612 rows, out of which 244 are empty, making the null percent 39.87. Minimum value is 1 and maximum value is 8999.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 22, 2019
Created July 20, 2019