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

5.8. Ehdokkaitten vaalitiedot puolueen ja kunnan ja sukupuolen mukaan kunnallisvaaleissa 2012

5.8. Ehdokkaitten vaalitiedot puolueen ja kunnan ja sukupuolen mukaan kunnallisvaaleissa 2012

Tables

Column Descriptions

Fact, T720 kvaa 2012 tau 148 fi px, Latest

Column Type Comment
kunta int Datasource did not contain a description for Kunta. Column kunta has 116964 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 153976.
puolue int Datasource did not contain a description for Puolue. Column puolue has 116964 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 100 and maximum value is 299.
sukupuoli string Datasource did not contain a description for Sukupuoli. Column sukupuoli has 116964 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is 2.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 116964 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Lkm1 and maximum string is Lkm4.
kunnallisvaalit_2012 int Datasource did not contain a description for Kunnallisvaalit_2012. Column kunnallisvaalit_2012 has 116964 rows, out of which 66972 are empty, making the null percent 57.26. Minimum value is 0 and maximum value is 2493524.

Dim kunta, T720 kvaa 2012 tau 148 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 361 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 153976.
label string The label for the dimension value. Column label has 361 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 tiedot, T720 kvaa 2012 tau 148 fi px, Full history

Column Type Comment
code string The code for the dimension value. Column code has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Lkm1 and maximum string is Lkm4.
label string The label for the dimension value. Column label has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ehdokkaat and maximum string is Osuus valituista (%).
orig_extractdate string The date when the data was originally fetched from the source.

Dim kunta, T720 kvaa 2012 tau 148 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 361 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 153976.
label string The label for the dimension value. Column label has 361 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.

Fact, T720 kvaa 2012 tau 148 fi px, Full history

Column Type Comment
kunta int Datasource did not contain a description for Kunta. Column kunta has 116964 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 153976.
puolue int Datasource did not contain a description for Puolue. Column puolue has 116964 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 100 and maximum value is 299.
sukupuoli string Datasource did not contain a description for Sukupuoli. Column sukupuoli has 116964 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1 and maximum string is 2.
tiedot string Datasource did not contain a description for Tiedot. Column tiedot has 116964 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Lkm1 and maximum string is Lkm4.
kunnallisvaalit_2012 int Datasource did not contain a description for Kunnallisvaalit_2012. Column kunnallisvaalit_2012 has 116964 rows, out of which 66972 are empty, making the null percent 57.26. Minimum value is 0 and maximum value is 2493524.
orig_extractdate string The date when the data was originally fetched from the source.

Dim sukupuoli, T720 kvaa 2012 tau 148 fi 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 Kaikki ehdokkaat and maximum string is Naisehdokkaat.

Dim puolue, T720 kvaa 2012 tau 148 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 100 and maximum value is 299.
label string The label for the dimension value. Column label has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is IP and maximum string is Valitsijayhdistykset.
orig_extractdate string The date when the data was originally fetched from the source.

Dim tiedot, T720 kvaa 2012 tau 148 fi px, Latest

Column Type Comment
code string The code for the dimension value. Column code has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Lkm1 and maximum string is Lkm4.
label string The label for the dimension value. Column label has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ehdokkaat and maximum string is Osuus valituista (%).

Dim puolue, T720 kvaa 2012 tau 148 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 100 and maximum value is 299.
label string The label for the dimension value. Column label has 18 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is IP and maximum string is Valitsijayhdistykset.

Dim sukupuoli, T720 kvaa 2012 tau 148 fi 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 Kaikki ehdokkaat and maximum string is Naisehdokkaat.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 20, 2019
Created August 5, 2019