view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by election_date descending
This data as json, CSV (advanced)
These facets timed out: election_date
country_name_short | country_name | election_type | election_date ▲ | vote_share | seats | seats_total | party_name_short | party_name | party_name_english | left_right | country_id | election_id | previous_parliament_election_id | previous_cabinet_id | party_id |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DNK | Denmark | parliament | 2022-11-01 | 27.5 | 50 | 179 | Sd | Socialdemokraterne | Social Democrats | 3.8011 | 21 | 1116 | 1077 | 1598 | 1629 |
DNK | Denmark | parliament | 2022-11-01 | 13.3 | 23 | 179 | V | Venstre | Liberal Party | 7.292 | 21 | 1116 | 1077 | 1598 | 1605 |
DNK | Denmark | parliament | 2022-11-01 | 9.3 | 16 | 179 | M | Moderaterne | Moderates | 6.0 | 21 | 1116 | 1077 | 1598 | 2887 |
DNK | Denmark | parliament | 2022-11-01 | 8.3 | 15 | 179 | SF | Socialistisk Folkeparti | Socialist Peoples Party | 2.1347 | 21 | 1116 | 1077 | 1598 | 1644 |
DNK | Denmark | parliament | 2022-11-01 | 7.9 | 14 | 179 | NLA | Ny-Liberal Alliance | New-Liberal Alliance | 6.0 | 21 | 1116 | 1077 | 1598 | 376 |
DNK | Denmark | parliament | 2022-11-01 | 8.1 | 14 | 179 | AE | Danmarksdemokraterne | Denmark Demokrats | 8.8 | 21 | 1116 | 1077 | 1598 | 2888 |
DNK | Denmark | parliament | 2022-11-01 | 5.5 | 10 | 179 | KF | Konservative | Conservatives | 7.2186 | 21 | 1116 | 1077 | 1598 | 590 |
DNK | Denmark | parliament | 2022-11-01 | 5.1 | 9 | 179 | En-O | Enhedslisten – De Rød-Grønne | Red-Green Alliance | 0.8912 | 21 | 1116 | 1077 | 1598 | 306 |
DNK | Denmark | parliament | 2022-11-01 | 3.8 | 7 | 179 | RV | Det Radikale Venstre | Danish Social Liberal Party | 4.8736 | 21 | 1116 | 1077 | 1598 | 211 |
DNK | Denmark | parliament | 2022-11-01 | 3.7 | 6 | 179 | NB | Nye Borgerlige | The New Right | 8.8 | 21 | 1116 | 1077 | 1598 | 2781 |
DNK | Denmark | parliament | 2022-11-01 | 3.3 | 6 | 179 | A | Alternativet | The Alternative | 2.5 | 21 | 1116 | 1077 | 1598 | 2567 |
DNK | Denmark | parliament | 2022-11-01 | 2.6 | 5 | 179 | DF | Dansk Folkeparti | Danish Peoples Party | 8.2269 | 21 | 1116 | 1077 | 1598 | 1418 |
DNK | Denmark | parliament | 2022-11-01 | 1 | 179 | IA | Inuit Ataqatigiit | Community of the People | 1.3 | 21 | 1116 | 1077 | 1598 | 1891 | |
DNK | Denmark | parliament | 2022-11-01 | 1 | 179 | Si | Siumut | Forward (Greenland) | 3.3 | 21 | 1116 | 1077 | 1598 | 74 | |
DNK | Denmark | parliament | 2022-11-01 | 1 | 179 | Sbf | Sambandsflokkurin | Union Party (Faroe Islands) | 7.4 | 21 | 1116 | 1077 | 1598 | 1892 | |
DNK | Denmark | parliament | 2022-11-01 | 1 | 179 | Jf | Javnaðarflokkurin | Social Democratic Party (Faroe Islands) | 3.3 | 21 | 1116 | 1077 | 1598 | 1894 | |
DNK | Denmark | parliament | 2022-11-01 | 0.9 | 0 | 179 | no-seat | no seat | no seat | 21 | 1116 | 1077 | 1598 | 2058 | |
ISR | Israel | parliament | 2022-11-01 | 23.41 | 32 | 120 | L | Likud | The Consolidation | 6.6788 | 34 | 1117 | 1100 | 1677 | 678 |
ISR | Israel | parliament | 2022-11-01 | 17.79 | 24 | 120 | YA | Yesh Atid | There is a Future | 6.0 | 34 | 1117 | 1100 | 1677 | 2321 |
ISR | Israel | parliament | 2022-11-01 | 10.84 | 14 | 120 | HaLe-T|RZP | HaIhud HaLeumi–Tkuma | HaTzionut HaDatit | National Union--Tkuma | Religious Zionist Party | 9.5906 | 34 | 1117 | 1100 | 1677 | 1357 |
ISR | Israel | parliament | 2022-11-01 | 9.08 | 12 | 120 | KL | Kahol Lavan | Blue and White | 6.0 | 34 | 1117 | 1100 | 1677 | 2725 |
ISR | Israel | parliament | 2022-11-01 | 8.25 | 11 | 120 | Shas | Shomrei Sfarad | Sephardi Guardians | 7.0417 | 34 | 1117 | 1100 | 1677 | 788 |
ISR | Israel | parliament | 2022-11-01 | 5.88 | 7 | 120 | YaToMe | Yahadut HaTora HaMeuhedet | United Torah Judaism | 6.9396 | 34 | 1117 | 1100 | 1677 | 1303 |
ISR | Israel | parliament | 2022-11-01 | 4.48 | 6 | 120 | YB | Yisrael Beiteinu | Israel Our Home | 8.8 | 34 | 1117 | 1100 | 1677 | 1816 |
ISR | Israel | parliament | 2022-11-01 | 4.07 | 5 | 120 | Raam | al-Qā'ima al-'Arabiyya al-Muwaḥḥada | United Arab List | 34 | 1117 | 1100 | 1677 | 1846 | |
ISR | Israel | parliament | 2022-11-01 | 3.75 | 5 | 120 | R|H | Rakah | Hadash | New Communist List | Democratic Front | 1.3 | 34 | 1117 | 1100 | 1677 | 732 |
ISR | Israel | parliament | 2022-11-01 | 3.69 | 4 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 1117 | 1100 | 1677 | 244 |
ISR | Israel | parliament | 2022-11-01 | 3.16 | 0 | 120 | Meretz | Meretz | Energy | 1.7786 | 34 | 1117 | 1100 | 1677 | 1419 |
ISR | Israel | parliament | 2022-11-01 | 2.91 | 0 | 120 | Balad | Brit Le'umit Demokratit | National Democratic Assembly | 0.7407 | 34 | 1117 | 1100 | 1677 | 805 |
ISR | Israel | parliament | 2022-11-01 | 1.19 | 0 | 120 | MDL|HH | Miflaga Datit Leumit (Mafdal) | Habayit Hayehudi | National Religious Party | The Jewish Home | 8.6207 | 34 | 1117 | 1100 | 1677 | 214 |
BGR | Bulgaria | parliament | 2022-10-02 | 25.33 | 67 | 240 | GERB | Grazhdani za Evropeysko Razvitie na Balgariya | Citizens for European Development of Bulgaria | 8.8 | 10 | 1114 | 1106 | 1678 | 1541 |
BGR | Bulgaria | parliament | 2022-10-02 | 20.2 | 53 | 240 | PP | Prodalzhavame promyanata | We Continue the Change | 10 | 1114 | 1106 | 1678 | 2847 | |
BGR | Bulgaria | parliament | 2022-10-02 | 13.75 | 36 | 240 | DPS | Dvizhenie za Prava i Svobodi | Movement for Rights and Freedoms | 4.5828 | 10 | 1114 | 1106 | 1678 | 1286 |
BGR | Bulgaria | parliament | 2022-10-02 | 10.18 | 27 | 240 | R | Vazrazhdane | Revival | 8.8 | 10 | 1114 | 1106 | 1678 | 2640 |
BGR | Bulgaria | parliament | 2022-10-02 | 9.3 | 25 | 240 | BSP | Balgarska Sotsialisticheska Partiya | Bulgarian Socialist Party | 3.0064 | 10 | 1114 | 1106 | 1678 | 982 |
BGR | Bulgaria | parliament | 2022-10-02 | 7.45 | 20 | 240 | DaB | Da Bulgaria! | Yes, Bulgaria! | 6.0 | 10 | 1114 | 1106 | 1678 | 2638 |
BGR | Bulgaria | parliament | 2022-10-02 | 4.63 | 12 | 240 | BV | Balgarski vazhod | Bulgarian Rise | 7.4 | 10 | 1114 | 1106 | 1678 | 2871 |
BGR | Bulgaria | parliament | 2022-10-02 | 3.83 | 0 | 240 | ITN | Ima takav narod | There Is Such a People | 7.4 | 10 | 1114 | 1106 | 1678 | 2836 |
BGR | Bulgaria | parliament | 2022-10-02 | 1.01 | 0 | 240 | IS | Izpravi se! | Stand up! | 3.3 | 10 | 1114 | 1106 | 1678 | 2838 |
LVA | Latvia | parliament | 2022-10-01 | 18.97 | 26 | 100 | V | Vienotība | Unity | 7.4 | 55 | 1115 | 1042 | 1592 | 1666 |
LVA | Latvia | parliament | 2022-10-01 | 12.44 | 16 | 100 | ZZS | Zaļo un Zemnieku savienība | Green and Farmers' Union | 5.2632 | 55 | 1115 | 1042 | 1592 | 466 |
LVA | Latvia | parliament | 2022-10-01 | 11.01 | 15 | 100 | LZP | Latvijas Zaļā partija | Latvian Green Party | 4.6711 | 55 | 1115 | 1042 | 1592 | 1001 |
LVA | Latvia | parliament | 2022-10-01 | 9.29 | 13 | 100 | NA/TB/LNNK | Nacionālā apvienība / Tēvzemei un Brīvībai / LNNK | National Alliance / For Fatherland and Freedom / LNNK | 8.2588 | 55 | 1115 | 1042 | 1592 | 521 |
LVA | Latvia | parliament | 2022-10-01 | 6.8 | 11 | 100 | S! | Stabilitātei! | For Stability! | 55 | 1115 | 1042 | 1592 | 2875 | |
LVA | Latvia | parliament | 2022-10-01 | 6.16 | 10 | 100 | P | Progresīvie | The Progressive | 3.3 | 55 | 1115 | 1042 | 1592 | 2716 |
LVA | Latvia | parliament | 2022-10-01 | 6.24 | 9 | 100 | LPV | Latvija pirmajā vietā | Latvia First | 8.8 | 55 | 1115 | 1042 | 1592 | 2876 |
LVA | Latvia | parliament | 2022-10-01 | 3.63 | 0 | 100 | PCTVL | Par cilvēka tiesībām vienotā Latvijā | For Human Rights in a United Latvia | 1.25 | 55 | 1115 | 1042 | 1592 | 1520 |
LVA | Latvia | parliament | 2022-10-01 | 4.81 | 0 | 100 | S | Saskaņas | Harmony | 3.0 | 55 | 1115 | 1042 | 1592 | 1100 |
LVA | Latvia | parliament | 2022-10-01 | 1.76 | 0 | 100 | R | Republika | Republic | 3.3 | 55 | 1115 | 1042 | 1592 | 2877 |
LVA | Latvia | parliament | 2022-10-01 | 4.97 | 0 | 100 | AP! | Attīstībai/Par! | Development/For! | 55 | 1115 | 1042 | 1592 | 2878 | |
LVA | Latvia | parliament | 2022-10-01 | 3.09 | 0 | 100 | JKP | Jaunā konservatīvā partija | New Conservative Party | 7.4 | 55 | 1115 | 1042 | 1592 | 2717 |
LVA | Latvia | parliament | 2022-10-01 | 3.67 | 0 | 100 | KuK | Katram un katrai | For Each and Every One | 8.8 | 55 | 1115 | 1042 | 1592 | 2880 |
LVA | Latvia | parliament | 2022-10-01 | 1.0 | 0 | 100 | TKL | Tautas kalpi Latvijai | People's Servants for Latvia | 55 | 1115 | 1042 | 1592 | 2881 | |
LVA | Latvia | parliament | 2022-10-01 | 3.24 | 0 | 100 | SV | Suverēnā vara | Sovereign Power | 55 | 1115 | 1042 | 1592 | 2882 | |
LVA | Latvia | parliament | 2022-10-01 | 1.13 | 0 | 100 | PP | Tautas varas spēks | Power of the People | 55 | 1115 | 1042 | 1592 | 2883 | |
ITA | Italy | parliament | 2022-09-25 | 26.0 | 118 | 400 | FdI | Fratelli d'Italia | Brothers of Italy | 8.8 | 26 | 1113 | 1024 | 1681 | 2154 |
ITA | Italy | parliament | 2022-09-25 | 19.07 | 69 | 400 | PD | Partito Democratico | Democratic Party | 2.6216 | 26 | 1113 | 1024 | 1681 | 382 |
ITA | Italy | parliament | 2022-09-25 | 8.77 | 66 | 400 | LN | Lega Nord | North League | 7.8007 | 26 | 1113 | 1024 | 1681 | 1436 |
ITA | Italy | parliament | 2022-09-25 | 15.43 | 52 | 400 | M5S | Movimento 5 Stelle | Five Star Movement | 26 | 1113 | 1024 | 1681 | 2155 | |
ITA | Italy | parliament | 2022-09-25 | 8.11 | 44 | 400 | FI-PdL | Forza Italia – Il Popolo della Libertà | Go Italy -- The People of Freedom | 7.1459 | 26 | 1113 | 1024 | 1681 | 596 |
ITA | Italy | parliament | 2022-09-25 | 7.79 | 21 | 400 | IV | Italia Viva | Italy Alive | 6.0 | 26 | 1113 | 1024 | 1681 | 2794 |
ITA | Italy | parliament | 2022-09-25 | 3.63 | 11 | 400 | P|SDI | Partito | Socialisti Democratici Italiani | Italian Democratic Socialists | Party | 3.9895 | 26 | 1113 | 1024 | 1681 | 1278 |
ITA | Italy | parliament | 2022-09-25 | 0.91 | 9 | 400 | UC | Unione / Centro | Union / Centre | 6.1092 | 26 | 1113 | 1024 | 1681 | 226 |
ITA | Italy | parliament | 2022-09-25 | 2.83 | 3 | 400 | +EU | +Europa | More Europe | 6.0 | 26 | 1113 | 1024 | 1681 | 2737 |
ITA | Italy | parliament | 2022-09-25 | 0.42 | 3 | 400 | SVP | Südtiroler Volkspartei | South Tyrol Peoples Party | 5.4 | 26 | 1113 | 1024 | 1681 | 1030 |
ITA | Italy | parliament | 2022-09-25 | 3 | 400 | etc | diversi | others | 26 | 1113 | 1024 | 1681 | 825 | ||
ITA | Italy | parliament | 2022-09-25 | 0.76 | 1 | 400 | one-seat | one seat | one seat | 26 | 1113 | 1024 | 1681 | 2302 | |
ITA | Italy | parliament | 2022-09-25 | 1.9 | 0 | 400 | Italexit | Italext per l'Italia | Italexit for Italy | 7.4 | 26 | 1113 | 1024 | 1681 | 2873 |
ITA | Italy | parliament | 2022-09-25 | 1.24 | 0 | 400 | ISP | Italia sovrana e Popolare | Sovereign and Popular Italy | 8.8 | 26 | 1113 | 1024 | 1681 | 2874 |
ITA | Italy | parliament | 2022-09-25 | 1.43 | 0 | 400 | PRC | Partito della Rifondazione Comunista | Communist Refoundation Party | 0.8849 | 26 | 1113 | 1024 | 1681 | 1321 |
SWE | Sweden | parliament | 2022-09-11 | 30.33 | 107 | 349 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 1112 | 1041 | 1652 | 904 |
SWE | Sweden | parliament | 2022-09-11 | 20.54 | 73 | 349 | SD | Sverigedemokraterna | Sweden Democrats | 8.8 | 35 | 1112 | 1041 | 1652 | 1546 |
SWE | Sweden | parliament | 2022-09-11 | 19.1 | 68 | 349 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 1112 | 1041 | 1652 | 657 |
SWE | Sweden | parliament | 2022-09-11 | 6.71 | 24 | 349 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 1112 | 1041 | 1652 | 1461 |
SWE | Sweden | parliament | 2022-09-11 | 6.75 | 24 | 349 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 1112 | 1041 | 1652 | 882 |
SWE | Sweden | parliament | 2022-09-11 | 5.34 | 19 | 349 | KD | Kristdemokraterna | Christian Democrats | 7.195 | 35 | 1112 | 1041 | 1652 | 282 |
SWE | Sweden | parliament | 2022-09-11 | 5.08 | 18 | 349 | MP | Miljöpartiet de Gröna | Greens | 3.3789 | 35 | 1112 | 1041 | 1652 | 1154 |
SWE | Sweden | parliament | 2022-09-11 | 4.61 | 16 | 349 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 1112 | 1041 | 1652 | 892 |
SWE | Sweden | parliament | 2022-09-11 | 0.44 | 0 | 349 | no-seat | no seat | no seat | 35 | 1112 | 1041 | 1652 | 2405 | |
FRA | France | parliament | 2022-06-19 | 25.75 | 245 | 577 | REM|R | La République En Marche! | Renaissance | The Republic Onwards! | Renaissance | 6.0 | 43 | 1110 | 1014 | 1673 | 2643 |
FRA | France | parliament | 2022-06-19 | 25.66 | 131 | 577 | FI | La France Insoumise | Unbowed France | 1.3 | 43 | 1110 | 1014 | 1673 | 2644 |
FRA | France | parliament | 2022-06-19 | 18.68 | 89 | 577 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 1110 | 1014 | 1673 | 270 |
FRA | France | parliament | 2022-06-19 | 10.42 | 61 | 577 | UMP|LR | Union pour un mouvement populaire | Les Républicains | Union for a Popular Movement | The Republicans | 7.4997 | 43 | 1110 | 1014 | 1673 | 658 |
FRA | France | parliament | 2022-06-19 | 3.14 | 22 | 577 | d-gauche | divers gauche | other left | 3.3 | 43 | 1110 | 1014 | 1673 | 177 |
FRA | France | parliament | 2022-06-19 | 2.33 | 10 | 577 | d-droite | divers droite | other right | 7.6583 | 43 | 1110 | 1014 | 1673 | 285 |
FRA | France | parliament | 2022-06-19 | 1.28 | 10 | 577 | none | sans étiquette | no party affiliation | 43 | 1110 | 1014 | 1673 | 947 | |
FRA | France | parliament | 2022-06-19 | 1.25 | 4 | 577 | d-center | divers centre | other centre | 6.0 | 43 | 1110 | 1014 | 1673 | 2858 |
FRA | France | parliament | 2022-06-19 | 0.87 | 3 | 577 | UDI | Union des démocrates et indépendants | Union of Democrats and Independents | 7.4 | 43 | 1110 | 1014 | 1673 | 2273 |
FRA | France | parliament | 2022-06-19 | 0.85 | 1 | 577 | etc | divers | others | 43 | 1110 | 1014 | 1673 | 1328 | |
FRA | France | parliament | 2022-06-19 | 0.9 | 1 | 577 | one-seat | one seat | one seat | 43 | 1110 | 1014 | 1673 | 2859 | |
FRA | France | parliament | 2022-06-19 | 1.17 | 0 | 577 | ex-gau | extrême gauche | other far-left | 1.3 | 43 | 1110 | 1014 | 1673 | 2083 |
FRA | France | parliament | 2022-06-19 | 2.67 | 0 | 577 | PE | Parti écologiste | Ecologist Party | 2.5 | 43 | 1110 | 1014 | 1673 | 2813 |
FRA | France | parliament | 2022-06-19 | 4.24 | 0 | 577 | R! | Reconquête | Reconquest | 8.8 | 43 | 1110 | 1014 | 1673 | 2860 |
AUS | Australia | parliament | 2022-05-21 | 32.58 | 77 | 151 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 1111 | 1087 | 1616 | 1253 |
AUS | Australia | parliament | 2022-05-21 | 58 | 151 | C | Coalition | Coalition | 7.4 | 33 | 1111 | 1087 | 1616 | 1428 | |
AUS | Australia | parliament | 2022-05-21 | 23.89 | 27 | 151 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 1111 | 1087 | 1616 | 1411 |
AUS | Australia | parliament | 2022-05-21 | 8.0 | 21 | 151 | LNPQ | Liberal National Party of Queensland | Liberal National Party of Queensland | 6.0 | 33 | 1111 | 1087 | 1616 | 154 |
AUS | Australia | parliament | 2022-05-21 | 3.6 | 10 | 151 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 1111 | 1087 | 1616 | 184 |
AUS | Australia | parliament | 2022-05-21 | 5.29 | 10 | 151 | none | no party affiliation | no party affiliation | 33 | 1111 | 1087 | 1616 | 1396 | |
AUS | Australia | parliament | 2022-05-21 | 12.25 | 4 | 151 | AG | Australian Greens | Australian Greens | 1.5439 | 33 | 1111 | 1087 | 1616 | 751 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW view_election AS SELECT c.name_short AS country_name_short, c.name AS country_name, ii.short AS election_type, e.date AS election_date, vote_share, seats, seats_total, p.name_short AS party_name_short, p.name AS party_name, p.name_english AS party_name_english, vpp.left_right AS left_right, e.country_id AS country_id, er.election_id AS election_id, e.previous_parliament_election_id AS previous_parliament_election_id, e.previous_cabinet_id AS previous_cabinet_id, er.party_id AS party_id FROM (SELECT * FROM election_result WHERE vote_share NOT NULL OR seats NOT NULL) er LEFT OUTER JOIN election e ON er.election_id = e.id LEFT OUTER JOIN party p ON er.party_id = p.id LEFT OUTER JOIN viewcalc_party_position AS vpp ON er.party_id = vpp.party_id LEFT OUTER JOIN country c ON e.country_id = c.id LEFT OUTER JOIN info_id ii ON e.type_id = ii.id ORDER BY c.name_short, e.date, er.seats DESC;