election
Data source: ParlGov · About: simonw/parlgov-datasette
1,021 rows sorted by country_id descending
This data as json, CSV (advanced)
Suggested facets: type_id, early, date (date)
Link | rowid | id | type_id | country_id ▲ | date | first_round_election_id | early | wikipedia | seats_total | electorate | votes_cast | votes_valid | data_source | description | comment | previous_parliament_election_id | previous_ep_election_id | previous_cabinet_id | old_countryID | old_parlID |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
72 | 72 | 83 | 13 | Estonia 75 | 2007-03-04 | 0 | http://en.wikipedia.org/wiki/Estonian_parliamentary_election,_2007 | 101 | 897243 | 555463 | 550213 | vvk | 423 423 | 130 130 | Ansip I 274 | 233 | 20070 | |||
115 | 115 | 130 | 1 | Estonia 75 | 2004-06-13 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_2004_(Estonia) | 6 | 873809 | 234485 | 232230 | vvk | 423 423 | Parts 138 | 233 | 1020040 | ||||
209 | 209 | 239 | 13 | Estonia 75 | 1999-03-07 | 0 | http://en.wikipedia.org/wiki/Estonian_parliamentary_election,_1999 | 101 | 857270 | 492356 | 484239 | vvk | 600 600 | Siimann 303 | 233 | 19990 | ||||
341 | 341 | 395 | 1 | Estonia 75 | 2009-06-07 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_2009_(Estonia) | 6 | 909628 | 399181 | 396982 | vvk | 83 83 | 130 130 | Ansip III 902 | 233 | 1020090 | |||
365 | 365 | 423 | 13 | Estonia 75 | 2003-03-02 | 0 | http://en.wikipedia.org/wiki/Estonian_parliamentary_election,_2003 | 101 | 859714 | 500686 | 494888 | vvk | 239 239 | Kallas S 152 | 233 | 20030 | ||||
516 | 516 | 600 | 13 | Estonia 75 | 1995-03-05 | 0 | http://en.wikipedia.org/wiki/Estonian_parliamentary_election,_1995 | 101 | 790392 | 545825 | 540699 | vvk | 670 670 | Tarand 4 | 233 | 19950 | ||||
579 | 579 | 670 | 13 | Estonia 75 | 1992-09-20 | 0 | http://en.wikipedia.org/wiki/Estonian_parliamentary_election,_1992 | 101 | 689241 | 467628 | 458266 | vvk | 233 | 19920 | ||||||
606 | 606 | 699 | 13 | Estonia 75 | 2011-03-06 | 0 | http://en.wikipedia.org/wiki/Estonian_parliamentary_election,_2011 | 101 | 913346 | 580264 | 575133 | vvk | Election on 6 March 2011 and constituent session on 4 April. | 83 83 | 395 395 | Ansip III 902 | ||||
727 | 727 | 822 | 1 | Estonia 75 | 2014-05-25 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_2014_(Estonia) | 6 | 902873 | 329766 | 328493 | vvk | 699 699 | 395 395 | Roivas I 1095 | |||||
758 | 758 | 853 | 13 | Estonia 75 | 2015-03-01 | 0 | http://en.wikipedia.org/wiki/Estonian_parliamentary_election,_2015 | 101 | 899793 | 577910 | 574150 | vvk | 699 699 | 822 822 | Roivas I 1095 | |||||
948 | 948 | 1044 | 13 | Estonia 75 | 2019-03-03 | 0 | https://en.wikipedia.org/wiki/2019_Estonian_parliamentary_election | 101 | 887420 | 565045 | 561141 | vvk | Elections held on 3 March 2019. | 853 853 | 822 822 | Ratas I 1495 | ||||
960 | 960 | 1056 | 1 | Estonia 75 | 2019-05-26 | 0 | https://en.wikipedia.org/wiki/2019_European_Parliament_election_in_Estonia | 6 | 885417 | 332859 | 332104 | vvk | 1044 1044 | 822 822 | Ratas II 1595 | |||||
135 | 135 | 158 | 13 | Poland 74 | 1989-06-18 | 0 | http://en.wikipedia.org/wiki/Polish_legislative_election,_1989 | 460 | 27026146 | parline | The first polish election after the breakdown of the communism had a special (semi-free or semi-democratic) character. The coding of this election will therefore absorb some more time. | 616 | 19890 | |||||||
162 | 162 | 188 | 13 | Poland 74 | 2005-09-25 | 0 | http://en.wikipedia.org/wiki/Polish_parliamentary_election,_2005 | 460 | 30229031 | 12244903 | 11804676 | pkw | Parliament decided to dissolve on 7 September 2007 (377 to 54 vote) following the collapse of the Kaczynski government. | 565 565 | 199 199 | Belka 322 | 616 | 20050 | ||
173 | 173 | 199 | 1 | Poland 74 | 2004-06-13 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_2004_(Poland) | 54 | 29986109 | 6258550 | 6091531 | pkw | 565 565 | Belka 322 | 616 | 1020040 | ||||
184 | 184 | 211 | 13 | Poland 74 | 1991-10-27 | 1 | http://en.wikipedia.org/wiki/Polish_parliamentary_election,_1991 | 460 | 27517280 | 11887949 | 11218602 | pkw | KLD and PPG created a parliamentary group named Polski Program Liberalny (Polish Liberal Program) on 6 November 1992. | 158 158 | Bielecki 75 | 616 | 19910 | |||
224 | 224 | 255 | 1 | Poland 74 | 2009-06-07 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_2009_(Poland) | 50 | 30565272 | 7505261 | 7364763 | pkw | 560 560 | 199 199 | Tusk I 164 | 616 | 1020090 | |||
234 | 234 | 268 | 13 | Poland 74 | 1993-09-19 | 1 | http://en.wikipedia.org/wiki/Polish_parliamentary_election,_1993 | 460 | 27655495 | 14415586 | 13796227 | pkw | 211 211 | Suchocka II 730 | 616 | 19930 | ||||
408 | 408 | 477 | 13 | Poland 74 | 1997-09-21 | 0 | http://en.wikipedia.org/wiki/Polish_parliamentary_election,_1997 | 460 | 28409054 | 13616378 | 13088231 | pkw | 268 268 | Cimoszewicz 437 | 616 | 19970 | ||||
479 | 479 | 560 | 13 | Poland 74 | 2007-10-19 | 1 | http://en.wikipedia.org/wiki/Elections_in_Poland#2007_Parliamentary_election | 460 | 30615471 | 16477734 | 16142202 | pkw | 188 188 | 199 199 | Kaczynski 356 | 616 | 20070 | |||
484 | 484 | 565 | 13 | Poland 74 | 2001-09-23 | 0 | http://en.wikipedia.org/wiki/Polish_parliamentary_election,_2001 | 460 | 29364455 | 13591681 | 13017929 | pkw | 477 477 | Buzek II 194 | 616 | 20010 | ||||
673 | 673 | 766 | 13 | Poland 74 | 2011-10-09 | 0 | http://en.wikipedia.org/wiki/Polish_parliamentary_election,_2011 | 460 | 30762931 | 15050027 | 14369503 | pkw | MPs from the Law and Justice Party (PiS) formed the Solidarity Poland Party (SP) on 7 November 2011. SP does not meet ParlGov inclusion criterias and is therefore not included. | 560 560 | 255 255 | Tusk I 164 | ||||
742 | 742 | 837 | 1 | Poland 74 | 2014-05-25 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_2014_%28Poland%29 | 51 | 30636537 | 7297490 | 7069485 | pkw | 766 766 | 255 255 | Tusk II 985 | |||||
900 | 900 | 996 | 13 | Poland 74 | 2015-10-25 | 0 | https://en.wikipedia.org/wiki/Polish_parliamentary_election,_2015 | 460 | 30629150 | 15595335 | 15200671 | pkw | 766 766 | 837 837 | Kopacz 1146 | |||||
971 | 971 | 1067 | 1 | Poland 74 | 2019-05-26 | 0 | https://en.wikipedia.org/wiki/2019_European_Parliament_election_in_Poland | 51 | 30118852 | 13760974 | 13647311 | pkw | 996 996 | 837 837 | Morawiecki I 1526 | |||||
986 | 986 | 1082 | 13 | Poland 74 | 2019-10-13 | 0 | https://en.wikipedia.org/wiki/2019_Polish_parliamentary_election | 460 | 30253556 | 18682535 | 18678457 | pkw | 996 996 | 1067 1067 | Morawiecki I 1526 | |||||
7 | 7 | 8 | 13 | Malta 72 | 1971-06-14 | 0 | http://en.wikipedia.org/wiki/Maltese_general_election,_1971 | 55 | 181768 | 168913 | 168059 | md | 419 419 | Borg Olivier IV 681 | 470 | 19710 | ||||
118 | 118 | 135 | 13 | Malta 72 | 1950-09-04 | 1 | http://en.wikipedia.org/wiki/Maltese_general_election,_1950 | 40 | 144516 | 106820 | 106129 | md, nyt | 550 550 | Boffa 1470 | 470 | 19500 | ||||
119 | 119 | 136 | 13 | Malta 72 | 1981-12-12 | 0 | http://en.wikipedia.org/wiki/Maltese_general_election,_1981 | 65 | 238237 | 225466 | 224151 | md | 533 533 | Mintoff IV 606 | 470 | 19810 | ||||
149 | 149 | 173 | 13 | Malta 72 | 1998-09-05 | 1 | http://en.wikipedia.org/wiki/Maltese_general_election,_1998 | 65 | 281078 | 268150 | 264492 | doi | Early election after cabinet Sant lost its parliamentary majority. | 483 483 | Sant 299 | 470 | 19980 | |||
177 | 177 | 203 | 13 | Malta 72 | 2008-03-08 | 1 | http://en.wikipedia.org/wiki/Maltese_general_election,_2008 | 69 | 315357 | 294214 | 290799 | doi | 509 509 | 346 346 | Gonzi I 298 | 470 | 20080 | |||
213 | 213 | 244 | 13 | Malta 72 | 1951-05-06 | 1 | http://en.wikipedia.org/wiki/Maltese_general_election,_1951 | 40 | 151979 | 113366 | 112625 | md | Coded as snap election since it took place before the end of the official five-year term. | 135 135 | Mizzi 1471 | 470 | 19510 | |||
237 | 237 | 272 | 13 | Malta 72 | 1953-12-14 | 1 | http://en.wikipedia.org/wiki/Maltese_general_election,_1953 | 40 | 148478 | 119333 | 118453 | md | 244 244 | Borg Olivier I 1472 | 470 | 19530 | ||||
300 | 300 | 346 | 1 | Malta 72 | 2004-06-13 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_2004_(Malta) | 5 | 304283 | 250691 | 245722 | doi | 509 509 | Gonzi I 298 | 470 | 1020040 | ||||
321 | 321 | 370 | 13 | Malta 72 | 1987-05-09 | 0 | http://en.wikipedia.org/wiki/Maltese_general_election,_1987 | 69 | 246292 | 236719 | 235168 | md | 136 136 | Mifsud Bonnici 122 | 470 | 19870 | ||||
362 | 362 | 419 | 13 | Malta 72 | 1966-03-28 | 0 | http://en.wikipedia.org/wiki/Maltese_general_election,_1966 | 50 | 161490 | 144873 | 143347 | md | 658 658 | Borg Olivier III 589 | 470 | 19660 | ||||
413 | 413 | 483 | 13 | Malta 72 | 1996-10-26 | 1 | http://en.wikipedia.org/wiki/Maltese_general_election,_1996 | 69 | 271746 | 264037 | 261224 | doi, md | 520 520 | Fenech Adami II 881 | 470 | 19960 | ||||
436 | 436 | 509 | 13 | Malta 72 | 2003-04-12 | 1 | http://en.wikipedia.org/wiki/Maltese_general_election,_2003 | 65 | 297930 | 285122 | 282213 | doi | Parliament was dissolved on 8 March 2008. | 173 173 | Fenech Adami III 582 | 470 | 20030 | |||
446 | 446 | 520 | 13 | Malta 72 | 1992-02-22 | 1 | http://en.wikipedia.org/wiki/Maltese_general_election,_1992 | 65 | 259310 | 249141 | 247139 | md, parline | 370 370 | Fenech Adami I 3 | 470 | 19920 | ||||
458 | 458 | 533 | 13 | Malta 72 | 1976-09-18 | 0 | http://en.wikipedia.org/wiki/Maltese_general_election,_1976 | 65 | 217724 | 206605 | 205440 | md | 8 8 | Mintoff III 816 | 470 | 19760 | ||||
471 | 471 | 550 | 13 | Malta 72 | 1947-10-27 | 0 | http://en.wikipedia.org/wiki/Maltese_general_election,_1947 | 40 | 140703 | 106141 | 105494 | md | 470 | 19470 | ||||||
476 | 476 | 555 | 1 | Malta 72 | 2009-06-06 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_2009_(Malta) | 5 | 322411 | 254039 | 248169 | doi | 203 203 | 346 346 | Gonzi II 468 | 470 | 1020090 | |||
527 | 527 | 611 | 13 | Malta 72 | 1955-02-28 | 1 | http://en.wikipedia.org/wiki/Maltese_general_election,_1955 | 40 | 149380 | 121243 | 120655 | md | 272 272 | Borg Olivier II 1473 | 470 | 19550 | ||||
567 | 567 | 658 | 13 | Malta 72 | 1962-02-19 | 0 | http://en.wikipedia.org/wiki/Maltese_general_election,_1962 | 50 | 166936 | 151533 | 150606 | md | 611 611 | Mintoff I 1474 | 470 | 19620 | ||||
697 | 697 | 790 | 13 | Malta 72 | 2013-03-09 | 1 | http://en.wikipedia.org/wiki/Maltese_general_election,_2013 | 69 | 333022 | 309600 | 305556 | md | 203 203 | 555 555 | Gonzi II 468 | |||||
741 | 741 | 836 | 1 | Malta 72 | 2014-05-25 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_2014_(Malta) | 6 | 344356 | 257588 | 251851 | doi | 790 790 | 555 555 | Muscat I 1046 | |||||
914 | 914 | 1010 | 13 | Malta 72 | 2017-06-03 | 1 | https://en.wikipedia.org/wiki/Maltese_general_election,_2017 | 67 | 341856 | 314696 | 310665 | 790 790 | 836 836 | Muscat I 1046 | ||||||
970 | 970 | 1066 | 1 | Malta 72 | 2019-05-25 | 0 | https://en.wikipedia.org/wiki/2019_European_Parliament_election_in_Malta | 6 | 371643 | 270022 | 260212 | ecm | 1010 1010 | 836 836 | Muscat II 1504 | |||||
23 | 23 | 27 | 13 | Czech Republic 68 | 1998-06-20 | 1 | http://en.wikipedia.org/wiki/Czech_legislative_election,_1998 | 200 | 8116836 | 5994844 | 5969505 | volby | Early election on 20 June 1998. | 301 301 | Tosovsky 76 | 203 | 19980 | |||
33 | 33 | 39 | 13 | Czech Republic 68 | 1992-06-06 | 0 | http://en.wikipedia.org/wiki/Czech_legislative_election,_1992 | 200 | 7738961 | 6583988 | 6473250 | essex | 63 63 | Pithart 262 | 203 | 19920 | ||||
44 | 44 | 50 | 13 | Czech Republic 68 | 2006-06-03 | 0 | http://en.wikipedia.org/wiki/Czech_legislative_election,_2006 | 200 | 8333305 | 5368495 | 5348976 | volby | 487 487 | 567 567 | Paroubek 15 | 203 | 20060 | |||
56 | 56 | 63 | 13 | Czech Republic 68 | 1990-06-09 | 1 | http://en.wikipedia.org/wiki/Czech_legislative_election,_1990 | 200 | 7553447 | 7310856 | 7211047 | essex, parline | 203 | 19900 | ||||||
260 | 260 | 301 | 13 | Czech Republic 68 | 1996-06-01 | 0 | http://en.wikipedia.org/wiki/Czech_legislative_election,_1996 | 200 | 7990770 | 6096404 | 6059215 | volby | 39 39 | Klaus II 835 | 203 | 19960 | ||||
417 | 417 | 487 | 13 | Czech Republic 68 | 2002-06-15 | 0 | http://en.wikipedia.org/wiki/Czech_legislative_election,_2002 | 200 | 8264484 | 4789145 | 4768006 | volby | Check parliament composition change: K or KDU-CSL/US-DU | 27 27 | Zeman 443 | 203 | 20020 | |||
442 | 442 | 516 | 1 | Czech Republic 68 | 2009-06-07 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_2009_(Czech_Republic) | 22 | 8401374 | 2371009 | 2358934 | volby | 50 50 | 567 567 | Fischer 157 | 203 | 1020090 | |||
486 | 486 | 567 | 1 | Czech Republic 68 | 2004-06-12 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_2004_(Czech_Republic) | 24 | 8283485 | 2344290 | 2332862 | volby | 487 487 | Spidla 504 | 203 | 1020040 | ||||
515 | 515 | 599 | 13 | Czech Republic 68 | 2010-05-29 | 0 | http://en.wikipedia.org/wiki/Czech_legislative_election,_2010 | 200 | 8415892 | 5263822 | 5230859 | volby | 50 50 | 516 516 | Fischer 157 | 203 | 20100 | |||
710 | 710 | 805 | 13 | Czech Republic 68 | 2013-10-25 | 1 | http://en.wikipedia.org/wiki/Czech_legislative_election,_2013 | 200 | 8424227 | 5007212 | 4969984 | volby | 599 599 | 516 516 | Rusnok 1062 | |||||
725 | 725 | 820 | 1 | Czech Republic 68 | 2014-05-24 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_2014_(Czech_Republic) | 21 | 8395132 | 1528250 | 1515492 | volby | 805 805 | 516 516 | Sobotka 1072 | |||||
924 | 924 | 1020 | 13 | Czech Republic 68 | 2017-10-21 | 0 | https://en.wikipedia.org/wiki/Czech_legislative_election,_2017 | 200 | 8374501 | 5091065 | 5060759 | volby | 805 805 | 820 820 | Sobotka 1072 | |||||
961 | 961 | 1057 | 1 | Czech Republic 68 | 2019-05-25 | 0 | https://en.wikipedia.org/wiki/2019_European_Parliament_election_in_the_Czech_Republic | 21 | 8316737 | 2388304 | 2370765 | volby | 1020 1020 | 820 820 | Babis II 1534 | |||||
1003 | 1003 | 1099 | 13 | Czech Republic 68 | 2021-10-09 | 0 | https://en.wikipedia.org/wiki/2021_Czech_legislative_election | 200 | 8274906 | 5411929 | 5375135 | volby | 1020 1020 | 1057 1057 | Babis II 1534 | |||||
12 | 12 | 15 | 13 | Finland 67 | 1999-03-21 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_1999_(Finland) | 200 | 4152430 | 2710095 | 2681291 | idea, tila | 24 24 | 652 652 | Lipponen I 100 | 246 | 19990 | |||
21 | 21 | 24 | 13 | Finland 67 | 1995-03-19 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1995 | 200 | 4088358 | 2803602 | 2780921 | idea, tila | 602 602 | 193 193 | Aho II 206 | 246 | 19950 | |||
62 | 62 | 71 | 13 | Finland 67 | 1954-03-08 | 1 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1954 | 200 | 2526969 | 2019042 | 2008257 | idea, tila | 575 575 | Tuomioja 738 | 246 | 19540 | ||||
67 | 67 | 77 | 13 | Finland 67 | 1970-03-16 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1970 | 200 | 3094359 | 2544510 | 2535782 | idea, tila | Parliament was dissolved on 29 October 1972 after the resignation of the Karjalainen III cabinet. | 460 460 | Koivisto I 203 | 246 | 19700 | |||
73 | 73 | 84 | 13 | Finland 67 | 1979-03-19 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1979 | 200 | 3858553 | 2906066 | 2894446 | idea, tila | 98 98 | Sorsa III 492 | 246 | 19790 | ||||
85 | 85 | 98 | 13 | Finland 67 | 1975-09-22 | 1 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1975 | 200 | 3741460 | 2761223 | 2749818 | idea, nyt, tila | Early election on 22 September 1975 after the fall of the Sorsa I cabinet. | 636 636 | Liinamaa 143 | 246 | 19750 | |||
88 | 88 | 101 | 13 | Finland 67 | 1945-03-18 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1945 | 200 | 2284249 | 1710251 | 1698376 | idea, tila | 297 297 | Paasikivi I 120 | 246 | 19450 | ||||
116 | 116 | 133 | 13 | Finland 67 | 1983-03-21 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1983 | 200 | 3951932 | 2992970 | 2979694 | tila | 84 84 | Sorsa V 34 | 246 | 19830 | ||||
124 | 124 | 142 | 13 | Finland 67 | 1936-07-01 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1936 | 200 | 1872908 | 1178412 | 1173382 | no-2010, tila | 689 689 | Kivimäki II 1201 | 246 | 19360 | ||||
156 | 156 | 181 | 1 | Finland 67 | 2009-06-07 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_2009_(Finland) | 13 | 4332457 | 1672434 | 1664831 | tila | 314 314 | 198 198 | Vanhanen II 277 | 246 | 1020090 | |||
161 | 161 | 187 | 13 | Finland 67 | 1948-07-02 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1948 | 200 | 2420287 | 1893837 | 1879968 | idea, tila | 101 101 | Pekkala 125 | 246 | 19480 | ||||
167 | 167 | 193 | 1 | Finland 67 | 1995-01-01 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_1999 | 16 | Elections took only place in 1996. Results reflect the initial composition of Finish MEPs, based on the party composition of the Eduskunta. | 602 602 | Aho II 206 | 246 | 1019950 | |||||||
172 | 172 | 198 | 1 | Finland 67 | 2004-06-13 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_2004_%28Finland%29 | 14 | 4227987 | 1666932 | 1656584 | ejpr | 253 253 | 334 334 | Vanhanen I 759 | 246 | 1020040 | |||
222 | 222 | 253 | 13 | Finland 67 | 2003-03-16 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_2003 | 200 | 4220951 | 2815700 | 2791757 | idea, tila | 15 15 | 334 334 | Lipponen III 663 | 246 | 20030 | |||
235 | 235 | 269 | 13 | Finland 67 | 1930-10-01 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1930 | 200 | 1722588 | 1135545 | 1130028 | no-2010, tila | 577 577 | Svinhufvud II 1204 | 246 | 19300 | ||||
258 | 258 | 297 | 13 | Finland 67 | 1939-07-01 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1939 | 200 | 1956807 | 1302348 | 1297319 | no-2010, tila | 142 142 | Cajander III 1199 | 246 | 19390 | ||||
270 | 270 | 314 | 13 | Finland 67 | 2007-03-18 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_2007 | 200 | 4292436 | 2790752 | 2771236 | idea, tila | 253 253 | 198 198 | Vanhanen I 759 | 246 | 20070 | |||
289 | 289 | 334 | 1 | Finland 67 | 1999-06-13 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_1999_(Finland) | 16 | 4165689 | 1248122 | 1242303 | ejpr, tila | 15 15 | 652 652 | Lipponen II 352 | 246 | 1019990 | |||
295 | 295 | 340 | 13 | Finland 67 | 1927-07-01 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1927 | 200 | 1638864 | 914371 | 910191 | no-2010, tila | 904 904 | Tanner 1208 | 246 | 19270 | ||||
308 | 308 | 354 | 13 | Finland 67 | 1962-02-05 | 1 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1962 | 200 | 2714838 | 2310090 | 2301998 | idea, tila | Early election on 5 Februrary 1962. | 616 616 | Miettunen I 598 | 246 | 19620 | |||
395 | 395 | 460 | 13 | Finland 67 | 1966-03-21 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1966 | 200 | 2800461 | 2378583 | 2370046 | idea, tila | 354 354 | Virolainen 139 | 246 | 19660 | ||||
453 | 453 | 527 | 13 | Finland 67 | 1987-03-16 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1987 | 200 | 4018248 | 2895488 | 2880093 | idea, tila | 133 133 | Sorsa VI 650 | 246 | 19870 | ||||
492 | 492 | 575 | 13 | Finland 67 | 1951-07-03 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1951 | 200 | 2448239 | 1825779 | 1812817 | idea, nyt, tila | President Paasikivi dissolved parliament on 8 December 1953 following a prolonged cabinet crisis (NYT). | 187 187 | Kekkonen II 639 | 246 | 19510 | |||
493 | 493 | 577 | 13 | Finland 67 | 1929-07-01 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1929 | 200 | 1719567 | 956296 | 951270 | no-2010, tila | 340 340 | Mantere 1206 | 246 | 19290 | ||||
518 | 518 | 602 | 13 | Finland 67 | 1991-03-17 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1991 | 200 | 4060778 | 2776984 | 2725918 | idea, tila | 527 527 | Holkeri II 41 | 246 | 19910 | ||||
530 | 530 | 616 | 13 | Finland 67 | 1958-07-07 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1958 | 200 | 2606258 | 1954397 | 1944235 | idea, nyt, tila | President Kekkonen dissolved parliament on 14 November 1961 because of a foreign policy crisis (NYT). | 71 71 | Kuuskoski 791 | 246 | 19580 | |||
548 | 548 | 636 | 13 | Finland 67 | 1972-01-03 | 1 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1972 | 200 | 3178169 | 2587060 | 2577949 | idea, tila | Early election on 3 January 1972 after the fall of the Karjalainen III cabinet. | 77 77 | Aura II 391 | 246 | 19720 | |||
561 | 561 | 652 | 1 | Finland 67 | 1996-10-20 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_1996_(Finland) | 16 | 4108703 | 2366504 | 2249411 | tila | 24 24 | 193 193 | Lipponen I 100 | 246 | 1019960 | |||
597 | 597 | 689 | 13 | Finland 67 | 1933-07-01 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1933 | 200 | 1789331 | 1112740 | 1107823 | no-2010, tila | 269 269 | Kivimäki I 1202 | 246 | 19330 | ||||
607 | 607 | 700 | 13 | Finland 67 | 2011-04-17 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_2011 | 200 | 4387701 | 2955865 | 2939571 | tila, vaalit | 314 314 | 181 181 | Kiviniemi 383 | |||||
728 | 728 | 823 | 1 | Finland 67 | 2014-05-25 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_2014_(Finland) | 13 | 4440297 | 1738037 | 1728294 | tila | 700 700 | 181 181 | Katainen II 1094 | |||||
760 | 760 | 855 | 13 | Finland 67 | 2015-04-19 | 0 | http://en.wikipedia.org/wiki/Finnish_parliamentary_election,_2015 | 200 | 4463333 | 2983856 | 2968459 | vaalit | 700 700 | 823 823 | Stubb II 1145 | |||||
807 | 807 | 902 | 13 | Finland 67 | 1917-10-02 | 0 | https://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1917 | 171 | 1441075 | 992762 | yle | |||||||||
808 | 808 | 903 | 13 | Finland 67 | 1919-03-03 | 0 | https://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1919 | 200 | 1438709 | 965872 | 961101 | no-2010 | 902 902 | Ingman 1220 | ||||||
809 | 809 | 904 | 13 | Finland 67 | 1922-07-03 | 0 | https://en.wikipedia.org/wiki/Finnish_parliamentary_election,_1922 | 200 | 1489022 | 870825 | 865421 | no-2010 | 903 903 | Cajander I 1215 | ||||||
949 | 949 | 1045 | 13 | Finland 67 | 2019-04-14 | 0 | https://en.wikipedia.org/wiki/2019_Finnish_parliamentary_election | 200 | 4255466 | 3099760 | 3081916 | vaalit | 855 855 | 823 823 | Sipilae II 1510 | |||||
954 | 954 | 1050 | 1 | Finland 67 | 2019-05-26 | 0 | https://en.wikipedia.org/wiki/2019_European_Parliament_election_in_Finland | 13 | 4504480 | 1836059 | 1830045 | tila | 1045 1045 | 823 823 | Sipilae II 1510 | |||||
2 | 2 | 2 | 13 | Belgium 64 | 1999-06-13 | 1 | http://en.wikipedia.org/wiki/Belgian_federal_election,_1999 | 150 | 7343464 | 6650015 | 6214074 | ibz | 332 332 | 536 536 | Dehaene II 95 | 56 | 19990 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE election("id", "type_id", "country_id", "date", "first_round_election_id", "early", "wikipedia", "seats_total", "electorate", "votes_cast", "votes_valid", "data_source", "description", "comment", "previous_parliament_election_id", "previous_ep_election_id", "previous_cabinet_id", "old_countryID", "old_parlID", FOREIGN KEY([country_id]) REFERENCES [country]([id]), FOREIGN KEY([previous_cabinet_id]) REFERENCES [cabinet]([id]), FOREIGN KEY([previous_parliament_election_id]) REFERENCES [election]([id]), FOREIGN KEY([previous_ep_election_id]) REFERENCES [election]([id]) );