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

Puolueiden äänimäärät ja valittujen lukumäärä kunnittain (pienet puolueet), hylätyt liput sekä ennakkoäänestäneet kunnallisvaaleissa 2004

Puolueiden äänimäärät ja valittujen lukumäärä kunnittain (pienet puolueet), hylätyt liput sekä ennakkoäänestäneet kunnallisvaaleissa 2004

Tables

Column Descriptions

Dim aanestystiedot ja puolueiden kannatus, T050 kvaa 2004 tau 114 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 14 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 302.
label string The label for the dimension value. Column label has 14 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is EKA and maximum string is Ennakkoon äänestäneet.

Dim lukumaaratiedot, T050 kvaa 2004 tau 114 fi px, Latest

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 Lkm1 and maximum string is Lkm3.
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 Osuus % and maximum string is Valittujen lukumäärä.

Dim vaalipiiri ja kunta, T050 kvaa 2004 tau 114 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 474 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 474 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 004 Alahärmä and maximum string is 976 Ylitornio.
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T050 kvaa 2004 tau 114 fi px, Full history

Column Type Comment
vaalipiiri_ja_kunta int Datasource did not contain a description for Vaalipiiri_ja_kunta. Column vaalipiiri_ja_kunta has 19908 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.
lukumaaratiedot string Datasource did not contain a description for Lukumaaratiedot. Column lukumaaratiedot has 19908 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 Lkm3.
aanestystiedot_ja_puolueiden_kannatus int Datasource did not contain a description for Aanestystiedot_ja_puolueiden_kannatus. Column aanestystiedot_ja_puolueiden_kannatus has 19908 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 302.
kunnallisvaalit_2004 int Datasource did not contain a description for Kunnallisvaalit_2004. Column kunnallisvaalit_2004 has 19908 rows, out of which 14200 are empty, making the null percent 71.33. Minimum value is 0 and maximum value is 2388130.
orig_extractdate string The date when the data was originally fetched from the source.

Dim aanestystiedot ja puolueiden kannatus, T050 kvaa 2004 tau 114 fi px, Full history

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

Dim lukumaaratiedot, T050 kvaa 2004 tau 114 fi 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 Lkm1 and maximum string is Lkm3.
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 Osuus % and maximum string is Valittujen lukumäärä.
orig_extractdate string The date when the data was originally fetched from the source.

Dim vaalipiiri ja kunta, T050 kvaa 2004 tau 114 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 474 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 474 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 004 Alahärmä and maximum string is 976 Ylitornio.

Fact, T050 kvaa 2004 tau 114 fi px, Latest

Column Type Comment
vaalipiiri_ja_kunta int Datasource did not contain a description for Vaalipiiri_ja_kunta. Column vaalipiiri_ja_kunta has 19908 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.
lukumaaratiedot string Datasource did not contain a description for Lukumaaratiedot. Column lukumaaratiedot has 19908 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 Lkm3.
aanestystiedot_ja_puolueiden_kannatus int Datasource did not contain a description for Aanestystiedot_ja_puolueiden_kannatus. Column aanestystiedot_ja_puolueiden_kannatus has 19908 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 302.
kunnallisvaalit_2004 int Datasource did not contain a description for Kunnallisvaalit_2004. Column kunnallisvaalit_2004 has 19908 rows, out of which 14200 are empty, making the null percent 71.33. Minimum value is 0 and maximum value is 2388130.

Additional Info

Last Updated September 22, 2019
Created August 6, 2019