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

Puolueiden äänimäärät ja äänestysprosentti sekä valittujen lukumäärä kunnittain kunnallisvaaleissa 2004 ja muutos edellisiin vaaleihin verrattuna

Puolueiden äänimäärät ja äänestysprosentti sekä valittujen lukumäärä kunnittain kunnallisvaaleissa 2004 ja muutos edellisiin vaaleihin verrattuna

Tables

Column Descriptions

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

Column Type Comment
code string 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 string is Lkm1 and maximum string is Lkm3.
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. First 25 characters of minimum string: Muutos edelliseen vaaliin... and first 25 characters of maximum string: Valittujen lukumäärä...

Dim lukumaaratiedot, T050 kvaa 2004 tau 111 fi px, Full history

Column Type Comment
code string 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 string is Lkm1 and maximum string is Lkm3.
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. First 25 characters of minimum string: Muutos edelliseen vaaliin... and first 25 characters of maximum string: Valittujen lukumäärä...
orig_extractdate string The date when the data was originally fetched from the source.

Fact, T050 kvaa 2004 tau 111 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 24648 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 24648 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.
puolue int Datasource did not contain a description for Puolue. Column puolue has 24648 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 299.
kunnallisvaalit_2004 int Datasource did not contain a description for Kunnallisvaalit_2004. Column kunnallisvaalit_2004 has 24648 rows, out of which 10797 are empty, making the null percent 43.80. Minimum value is -22 and maximum value is 4099864.

Dim vaalipiiri ja kunta, T050 kvaa 2004 tau 111 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.

Dim vaalipiiri ja kunta, T050 kvaa 2004 tau 111 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 111 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 24648 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 24648 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.
puolue int Datasource did not contain a description for Puolue. Column puolue has 24648 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 299.
kunnallisvaalit_2004 int Datasource did not contain a description for Kunnallisvaalit_2004. Column kunnallisvaalit_2004 has 24648 rows, out of which 10797 are empty, making the null percent 43.80. Minimum value is -22 and maximum value is 4099864.
orig_extractdate string The date when the data was originally fetched from the source.

Dim puolue, T050 kvaa 2004 tau 111 fi px, Latest

Column Type Comment
code int The code for the dimension value. Column code has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 299.
label string The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is KD and maximum string is Äänioikeutettuja yhteensä.

Dim puolue, T050 kvaa 2004 tau 111 fi px, Full history

Column Type Comment
code int The code for the dimension value. Column code has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 299.
label string The label for the dimension value. Column label has 13 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is KD and maximum string is Äänioikeutettuja yhteensä.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 21, 2019
Created July 20, 2019