election_result
Data source: ParlGov · About: simonw/parlgov-datasette
9,716 rows sorted by comment descending
This data as json, CSV (advanced)
Link | rowid | id | election_id | party_id | alliance_id | seats | vote_share | votes | data_source | description | comment ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|
2739 | 2739 | 3282 | 551 551 | Unione Democratica 475 | 1975 1975 | ejpr | Alliance: Popular Party for Prodi (PpP) | ||||
4094 | 4094 | 4907 | 551 551 | Partito Popolare Italiano 142 | 1975 1975 | ejpr | Alliance: Popular Party for Prodi (PpP) | ||||
3137 | 3137 | 3771 | 107 107 | Movimento per l'Autonomia 1040 | 2846 2846 | Alliance: Pact for the Autonomies (PPA) | |||||
3096 | 3096 | 3720 | 498 498 | Partito | Socialisti Democratici Italiani 1278 | 4669 4669 | ejpr | Alliance: Greens and Social Democrats (Giras) | ||||
226 | 226 | 270 | 551 551 | Patto Segni 827 | 1975 1975 | Alliance: Dini List -- Italian Renewal (DINI-RI) | |||||
4484 | 4484 | 5360 | 551 551 | Partito | Socialisti Democratici Italiani 1278 | 1975 1975 | Alliance: Dini List -- Italian Renewal (DINI-RI) | |||||
2416 | 2416 | 2889 | 498 498 | Unione Democratici per l'Europa 399 | 4669 4669 | ejpr | Alliance: Democracy is Freedom -- The Daisy (DL-M) | ||||
3435 | 3435 | 4130 | 498 498 | I Democratici 961 | 4669 4669 | ejpr | Alliance: Democracy is Freedom -- The Daisy (DL-M) | ||||
3794 | 3794 | 4560 | 498 498 | Partito Popolare Italiano 142 | 4669 4669 | ejpr | Alliance: Democracy is Freedom -- The Daisy (DL-M) | ||||
4522 | 4522 | 5404 | 498 498 | Lista Dini – Rinnovamento Italiano 630 | 4669 4669 | ejpr | Alliance: Democracy is Freedom -- The Daisy (DL-M) | ||||
198 | 198 | 241 | 498 498 | Centro Cristiano Democratico 99 | 4991 4991 | ejpr | Alliance: Christian Democratic Center / United Christian Democrats (CCD/CDU) | ||||
750 | 750 | 898 | 551 551 | Centro Cristiano Democratico 99 | 3265 3265 | ejpr | Alliance: Christian Democratic Center / United Christian Democrats (CCD/CDU) | ||||
1308 | 1308 | 1574 | 551 551 | Cristiani Democratici Uniti 128 | 3265 3265 | ejpr | Alliance: Christian Democratic Center / United Christian Democrats (CCD/CDU) | ||||
4514 | 4514 | 5392 | 498 498 | Cristiani Democratici Uniti 128 | 4991 4991 | ejpr | Alliance: Christian Democratic Center / United Christian Democrats (CCD/CDU) | ||||
1087 | 1087 | 1298 | 107 107 | Democratici di Sinistra 809 | 530 530 | ejpr | Alliance: Centre Left (S) | ||||
1722 | 1722 | 2069 | 107 107 | Democrazia è Libertà – La Margherita 1005 | 530 530 | ejpr | Alliance: Centre Left (S) | ||||
8465 | 8465 | 9788 | 1024 1024 | Centro Democratico 2153 | 9785 9785 | 1 | mdi | Alliance: +Europa (+E) | |||
8495 | 8495 | 9818 | 1024 1024 | +Europa 2737 | 9785 9785 | 2 | 2.76 | 905818 | Alliance: +Europa (+E) | ||
3518 | 3518 | 4233 | 486 486 | Partij van de Arbeid – Parti du Travail de Belgique 256 | 0 | 1.55 | 101088 | ibz | Added results of PVDA+ (52918, 0.81) PTB+ (38857, 0.60) PTB+PVDA+ (9313, 0.14) | ||
6602 | 6602 | 7857 | 816 816 | Partij van de Arbeid – Parti du Travail de Belgique 256 | 2 | 3.72 | 251276 | ibz | Added results of PVDA+ (118333, 1.75, 0) and PTB-GO!, PTB+PVDA+, PTB+ (132943, 1,97, 2) | ||
6356 | 6356 | 7592 | 664 664 | Les Verts 873 | 0 | 7.64 | 1943774 | asn, no-2010 | According to asn Génération Ecologie, Verts gained 19.2 percent of the first votes. However this seems unrealistic regarding their number of votes. Vote share is therefore calculated. | ||
2869 | 2869 | 3449 | 111 111 | Alleanza Nazionale 373 | 7307 7307 | archivio | 90 MPs on PdL list | ||||
6082 | 6082 | 7308 | 789 789 | Partito | Socialisti Democratici Italiani 1278 | 7177 7177 | 4 MPs elected on PD list. Source is unclear. | |||||
428 | 428 | 523 | 111 111 | Liberal Democratici 906 | 7307 7307 | 3 MPs on PdL list | |||||
2597 | 2597 | 3110 | 111 111 | Democrazia Cristiana per le Autonomie 52 | 7307 7307 | archivio | 3 MPs on PdL list | ||||
4186 | 4186 | 5014 | 118 118 | PDS | Die Linke 791 | 54 | 8.7 | 4118194 | bwl, wid | Electoral alliance with WASG members on PDS lists. | 29 seats won in new federal states ( former East Germany) and Berlin. | |
5501 | 5501 | 6636 | 775 775 | National Party 997 | 33 | 42.69 | 402056 | no-2001, wilson | 2 seats uncontested. | ||
2230 | 2230 | 2668 | 280 280 | Radicali 1296 | 2226 2226 | 1 | 1.24 | 430150 | archivio, ep | Lega antiproibizionisti droga (Anti Drug League) | 1 seat Lega antiproibizionisti droga (Anti Drug League), 1 seat Federalists (Federalisti) in PLI-PRI-FED alliance |
7565 | 7565 | 8873 | 923 923 | Sjálfstæðisflokkurinn 1342 | 23 | 53.6 | 16272 | "only a loose electoral alliance" (McHale 1983, 520) | |||
654 | 654 | 785 | 224 224 | Fidesz – Magyar Polgári Szövetség 921 | 12 | 47.4 | 1457750 | ovb | "http://valasztas.hu/vteup04/l1.html (...) According to this, KDNP did not participate at all in 2004 (that time, this party was virtually non-existent)." personal communication with Zsófia Papp (HAS Centre for Social Sciences, Budapest) 2014 | ||
1452 | 1452 | 1744 | 401 401 | Nieuw-Vlaamse Alliantie 501 | 4517 4517 | cevipol, pc | "When Verhofstadt interim/temporary (it had a fixed date of end) cabinet was formed in December 2007, the appointment of Vandeurzen (CD&V) as minister led to the appointment of his substitute in parliament, who happened to be belonging to the NV-A. Hence, the composition of the group then 24 CD&V and 6 NV-A." (Source: Patrick Dumont, University of Luxembourg; personal communication 30 January 2012) | ||||
8317 | 8317 | 9636 | 1011 1011 | Demokrati za Silna Balgariya | Demokratichna Balgariya 57 | 0 | 2.54 | 86984 | cik | New Republic | "New Republic was established before the latest parliamentary elections by Kanev and other DSB-friendly figures and members of the Public Board of the Right-wing Reformist Bloc coalition where DSB was a partner before leaving it over policy differences." (BTA 10 June 2017) | |
1 | 1 | 1 | 34 34 | Fine Gael 1393 | 4 | 24.27 | 276095 | eed | |||
2 | 2 | 2 | 140 140 | Comunista dos Trabalhadores Portugueses / Movimento Reorganizativo do Partido do Proletariado 281 | 0 | 1.11 | 36294 | cne | |||
3 | 3 | 3 | 15 15 | Keskusta 94 | 48 | 22.4 | 600592 | tila | |||
4 | 4 | 4 | 373 373 | Gruppe der Demokraten – Groupe des democrates 886 | 3 | 1.4 | 14270 | bafs | |||
5 | 5 | 6 | 604 604 | Südtiroler Volkspartei 1030 | 4 | 0.56 | 204899 | archivio | |||
6 | 6 | 7 | 412 412 | Centerpartiet 1461 | 27 | 7.7 | 425153 | ||||
7 | 7 | 8 | 80 80 | Slovenska ljudska stranka 16 | 7 | 6.82 | 66032 | voltive | |||
8 | 8 | 9 | 130 130 | Eesti Reformierakond 113 | 1 | 12.2 | 28377 | vvk | |||
9 | 9 | 12 | 108 108 | Evangelische Volkspartei der Schweiz – Parti Populaire Evangelique Suisse 602 | 2 | 1.6 | 15690 | bafs | |||
10 | 10 | 13 | 512 512 | Miljöpartiet de Gröna 1154 | 25 | 7.34 | 437435 | val | |||
11 | 11 | 14 | 467 467 | Partito Liberale Italiano 487 | 19 | 3.8 | 1003727 | archivio | Electoral alliance: National Bloc (Blocco Nazionale) | ||
12 | 12 | 16 | 427 427 | Partei der Arbeit der Schweiz 1167 | 2 | 1.0 | 18878 | bafs | |||
13 | 13 | 17 | 204 204 | Gereformeerd Politiek Verbond 625 | 1 | 0.86 | 59156 | verk | |||
14 | 14 | 18 | 412 412 | Socialdemokraterna 904 | 161 | 45.3 | 2513905 | ||||
15 | 15 | 19 | 107 107 | Partito della Rifondazione Comunista 1321 | 530 530 | 41 | 5.69 | 2229464 | ejpr | ||
16 | 16 | 20 | 644 644 | Kommunistische Partij – Parti Communiste 708 | 12 | 7.5 | 376765 | ibz | |||
17 | 17 | 21 | 213 213 | Dansk Samling 412 | 0 | 0.8 | 16383 | folketing | |||
18 | 18 | 22 | 357 357 | Centre démocratie et progrés 885 | 7683 7683 | 21 | 3.8 | 914397 | mackie | ||
19 | 19 | 25 | 375 375 | Parti socialiste 1539 | 7676 7676 | 44 | 15.5 | 3171459 | mackie | ||
20 | 20 | 26 | 257 257 | Szabad Demokraták Szövetsége 1426 | 93 | 21.4 | 1050799 | essex | |||
21 | 21 | 27 | 314 314 | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | 45 | 21.4 | 594194 | tila | |||
22 | 22 | 28 | 519 519 | Europa Transparant 339 | 2 | 7.33 | 349156 | verk | |||
23 | 23 | 29 | 214 214 | no party affiliation 58 | 6 | vrk | |||||
24 | 24 | 30 | 81 81 | Democraten 66 345 | 17 | 11.06 | 961121 | verk | |||
25 | 25 | 31 | 326 326 | Federazione dei Verdi 910 | 3 | 3.2 | 1055797 | archivio | |||
26 | 26 | 32 | 14 14 | Comunista dos Trabalhadores Portugueses / Movimento Reorganizativo do Partido do Proletariado 281 | 0 | 0.81 | 24022 | cne | |||
27 | 27 | 34 | 595 595 | Sozialdemokratische Partei Deutschlands 558 | 252 | 36.4 | 17140354 | bwl | |||
28 | 28 | 35 | 582 582 | Sinn Féin 689 | 5 | 0.6 | 171942 | bbc | |||
29 | 29 | 36 | 658 658 | Partit Laburista 1003 | 16 | 33.85 | 50974 | md | |||
30 | 30 | 37 | 531 531 | Liberalt Centrum 1478 | 0 | 1.3 | 37407 | folketing | |||
31 | 31 | 38 | 354 354 | Suomen Puolue | Perussuomalaiset 200 | 0 | 2.2 | 49773 | tila | |||
32 | 32 | 39 | 164 164 | Partido Communista | Izquierda Unida 118 | 5 | 5.04 | 1284081 | epp | |||
33 | 33 | 41 | 48 48 | Miljöpartiet de Gröna 1154 | 0 | 1.5 | 83645 | yb-swe | |||
34 | 34 | 42 | 613 613 | Néa Đimokratía 47 | 9 | 32.7 | 2133372 | ejpr | |||
35 | 35 | 43 | 145 145 | Jaunais Laiks 1518 | 2 | 19.71 | 113593 | cvk | |||
36 | 36 | 44 | 335 335 | GroenLinks 756 | 8 | 5.14 | 495802 | verk | |||
37 | 37 | 45 | 318 318 | Alþýðubandalagið 1360 | 9 | 13.9 | 13403 | hagstofa | |||
38 | 38 | 46 | 118 118 | Bündnis 90 / Die Grünen 772 | 51 | 8.1 | 3838326 | bwl | |||
39 | 39 | 47 | 21 21 | Partei der Arbeit der Schweiz 1167 | 5 | 2.7 | 25659 | bafs | |||
40 | 40 | 48 | 46 46 | Progressive Democrats 651 | 1 | 11.9 | 194059 | ep | |||
41 | 41 | 50 | 545 545 | Parti Social Chrétien – Christelijke Volkspartij 1051 | 95 | 41.1 | 2123408 | ibz | |||
42 | 42 | 52 | 582 582 | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba 1284 | 6 | 1.7 | 491386 | bbc | |||
43 | 43 | 53 | 508 508 | Synaspismós tīs Aristerás 1441 | 21 | 11.0 | 734611 | no-2010 | |||
44 | 44 | 55 | 17 17 | Partito Socialista Democratico Italiano 242 | 17 | 3.0 | 1140209 | archivio | |||
45 | 45 | 56 | 605 605 | Federazione dei Verdi 910 | 16 | 2.8 | 1093037 | archivio | |||
46 | 46 | 57 | 44 44 | Alianza-Partido Popular 645 | 28 | 40.59 | 7453900 | epp | |||
47 | 47 | 59 | 118 118 | Christlich Demokratische Union 808 | 5572 5572 | 180 | 27.8 | 13136740 | |||
48 | 48 | 60 | 507 507 | Partito Monarchico Popolare 421 | 14 | 2.6 | 776919 | archivio | |||
49 | 49 | 61 | 338 338 | Zeleni Slovenije 1619 | 0 | 1.76 | 18853 | voltive | |||
50 | 50 | 62 | 527 527 | Ruotsalainen Kansanpuolue – Svenska Folkepartiet i Finland 585 | 12 | 5.3 | 152597 | tila | |||
51 | 51 | 63 | 409 409 | no seat 2058 | 0 | 0.9 | 26889 | folketing | Pensioners Party (Pensionistpartiet) | ||
52 | 52 | 64 | 687 687 | Partido Nacionalista Vasco – Euzko Alderdi Jeltzalea 1361 | 7 | 1.55 | 353953 | epp | |||
53 | 53 | 65 | 385 385 | Bündnis 90 / Die Grünen 772 | 55 | 8.6 | 4110355 | bwl | |||
54 | 54 | 66 | 566 566 | Tėvynės sąjunga 1045 | 70 | 31.34 | 409585 | vrk | |||
55 | 55 | 68 | 507 507 | Democrazia Cristiana 1633 | 273 | 42.4 | 12520207 | archivio | |||
56 | 56 | 69 | 128 128 | Socialistisk Folkeparti 1644 | 1 | 9.2 | 183580 | yb-dnk | |||
57 | 57 | 70 | 252 252 | Partido Communista | Izquierda Unida 118 | 18 | 9.63 | 2253722 | epp | |||
58 | 58 | 71 | 519 519 | Partij van de Arbeid 742 | 7 | 23.6 | 1124549 | verk | |||
59 | 59 | 72 | 88 88 | Sameiningarflokkur alþýðu – Sósíalistaflokkurinn 1319 | 7 | 16.0 | 12422 | gud97 | |||
60 | 60 | 73 | 116 116 | Centrumpartij 275 | 1 | 0.83 | 68423 | verk | |||
61 | 61 | 74 | 146 146 | Unione Democratica di Centro 397 | 5220 5220 | 4 | ejpr | ||||
62 | 62 | 75 | 333 333 | Nihon Kyōsan-tō 1540 | 38 | 10.49 | 5496828 | parline | |||
63 | 63 | 76 | 568 568 | Democratic Unionist Party 319 | 2691 2691 | 1 | ark | ||||
64 | 64 | 78 | 64 64 | Danmarks Kommunistiske Parti 1239 | 6 | 3.6 | 110715 | folketing | |||
65 | 65 | 79 | 59 59 | one seat 652 | 1 | vrk | Moderniųjų krikščionių demokratų sąjunga (Modern Christian-Democratic Union) | ||||
66 | 66 | 80 | 407 407 | Centre national des indépendants et paysans 1414 | 7677 7677 | 32 | 11.5 | 2111167 | mackie | ||
67 | 67 | 81 | 8 8 | Partit Laburista 1003 | 28 | 50.84 | 85448 | md | |||
68 | 68 | 82 | 54 54 | Folkpartiet 892 | 2 | w |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE election_result("id", "election_id", "party_id", "alliance_id", "seats", "vote_share", "votes", "data_source", "description", "comment", FOREIGN KEY([election_id]) REFERENCES [election]([id]), FOREIGN KEY([party_id]) REFERENCES [party]([id]), FOREIGN KEY([alliance_id]) REFERENCES [election_result]([id]), FOREIGN KEY([data_source]) REFERENCES [info_data_source]([key]) );