view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by previous_parliament_election_id
This data as json, CSV (advanced)
election_date (date) >30 ✖
- 2014-05-25 239
- 2019-05-26 234
- 2009-06-07 217
- 2004-06-13 193
- 1999-06-13 148
- 1989-06-18 122
- 1994-06-12 109
- 1984-06-17 87
- 1979-06-10 85
- 1996-10-20 36
- 2014-05-24 36
- 2019-05-25 36
- 1992-06-06 30
- 2011-12-04 30
- 2022-11-01 30
- 2004-06-12 26
- 1991-10-20 25
- 2006-04-09 25
- 2019-05-23 25
- 2007-11-25 24
- 2009-06-04 24
- 2012-06-17 24
- 1993-06-06 23
- 1994-03-27 22
- 1995-10-01 22
- 1990-06-09 21
- 1991-10-27 21
- 1990-04-08 19
- 1996-11-03 19
- 2015-11-08 19
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
FRA | France | parliament | 1902-05-11 | 29.73 | 175 | 575 | RepG | Républicaine gauche | Left Republican | 6.0 | 43 | 987 | 2587 | ||
FRA | France | parliament | 1902-05-11 | 14.12 | 145 | 575 | C | Conservateurs | Conservatives | 7.4 | 43 | 987 | 2589 | ||
FRA | France | parliament | 1902-05-11 | 16.81 | 117 | 575 | RI | Radicaux indépendants | Independent Radicals | 7.4 | 43 | 987 | 2585 | ||
FRA | France | parliament | 1902-05-11 | 10.14 | 75 | 575 | PR | Parti radical-socialiste | Radical Socialist Party | 3.9896 | 43 | 987 | 401 | ||
FRA | France | parliament | 1902-05-11 | 6.31 | 45 | 575 | PS | Parti socialiste | Socialist Party | 3.2493 | 43 | 987 | 1539 | ||
FRA | France | parliament | 1902-05-11 | 4.59 | 18 | 575 | Rep | Republicans | Republicans | 6.0 | 43 | 987 | 2592 | ||
FRA | France | parliament | 1902-05-11 | 4.09 | 0 | 575 | SI | Socialistes indépendants | Independent Socialists | 1.3 | 43 | 987 | 2590 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 32.5 | 332 | 707 | Con | Conservatives | Conservatives | 7.4261 | 44 | 905 | 773 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 12.6 | 127 | 707 | CoLib | Coalition Liberal | Coalition Liberal | 6.0 | 44 | 905 | 2501 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 4.6 | 73 | 707 | SF | Sinn Féin | Sinn Fein | 1.3 | 44 | 905 | 689 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 20.8 | 57 | 707 | Lab | Labour Party | Labour | 4.3562 | 44 | 905 | 1556 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 5.9 | 50 | 707 | Con-18 | Conservatives [no coupon] | Conservatives | 7.4 | 44 | 905 | 2719 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 13.0 | 36 | 707 | Lib | Liberals | Liberals | 4.2875 | 44 | 905 | 659 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 1.45 | 9 | 707 | NDP | National Democratic and Labour Party | National Democratic and Labour Party | 8.8 | 44 | 905 | 2503 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 8 | 707 | etc | others | others | 44 | 905 | 453 | ||||
GBR | United Kingdom | parliament | 1918-12-14 | 2.21 | 7 | 707 | N | Nationalist Party | Nationalist Party | 3.3 | 44 | 905 | 332 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 0.5 | 4 | 707 | CoLab | Coalition Labour | Coalition Labour | 3.3 | 44 | 905 | 2508 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 0.9 | 2 | 707 | NP | National Party | National Party | 8.8 | 44 | 905 | 2504 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 0.09 | 1 | 707 | none | no party affiliation | no party affiliation | 44 | 905 | 1599 | |||
GBR | United Kingdom | parliament | 1918-12-14 | 0.3 | 1 | 707 | one-seat | one seat | one seat | 44 | 905 | 2296 | |||
GRC | Greece | parliament | 1974-11-17 | 54.4 | 220 | 300 | ND | Néa Đimokratía | New Democracy | 6.7365 | 41 | 653 | 47 | ||
GRC | Greece | parliament | 1974-11-17 | 20.4 | 60 | 300 | EDIK | Enosi Dimokratikou Kentrou | Union of the Democratic Centre | 6.0 | 41 | 653 | 489 | ||
GRC | Greece | parliament | 1974-11-17 | 13.6 | 12 | 300 | PASOK | Panellinio Sosialistikó Kínima | Panhellenic Socialist Movement | 4.4968 | 41 | 653 | 1338 | ||
GRC | Greece | parliament | 1974-11-17 | 9.5 | 8 | 300 | KKE | Kommounistikó Kómma Elládas | Communist Party of Greece | 1.253 | 41 | 653 | 614 | ||
GRC | Greece | parliament | 1974-11-17 | 1.1 | 0 | 300 | EDE | Ethnikή Dhmokratikή Έnwsis | National Democratic Union | 8.8 | 41 | 653 | 2230 | ||
HRV | Croatia | parliament | 2000-01-03 | 24.4 | 46 | 151 | HDZ | Hrvatska demokratska zajednica | Croatian Democratic Union | 7.1053 | 62 | 797 | 276 | ||
HRV | Croatia | parliament | 2000-01-03 | 40.8 | 44 | 151 | SPH | Socijaldemokratska partija Hrvatske | Social Democratic Party of Croatia | 3.2456 | 62 | 797 | 1493 | ||
HRV | Croatia | parliament | 2000-01-03 | 24 | 151 | HSLS | Hrvatska socijalno liberalna stranka | Croatian Social Liberal Party | 7.193 | 62 | 797 | 1102 | |||
HRV | Croatia | parliament | 2000-01-03 | 15.6 | 17 | 151 | HSS | Hrvatska seljačka stranka | Croatian Peasant Party | 6.2281 | 62 | 797 | 1465 | ||
HRV | Croatia | parliament | 2000-01-03 | 5.3 | 5 | 151 | HSP | Hrvatska stranka prava | Croatian Party of Rights | 8.7719 | 62 | 797 | 1044 | ||
HRV | Croatia | parliament | 2000-01-03 | 4 | 151 | IDS | Istarski demokratski sabor | Istrian Democratic Assembly | 3.4211 | 62 | 797 | 1627 | |||
HRV | Croatia | parliament | 2000-01-03 | 0.7 | 3 | 151 | none | no party affiliation | no party affiliation | 62 | 797 | 2197 | |||
HRV | Croatia | parliament | 2000-01-03 | 2 | 151 | PGS | Primorsko goranski savez | Alliance of Primorje-Gorski | 62 | 797 | 2196 | ||||
HRV | Croatia | parliament | 2000-01-03 | 2 | 151 | HNS-LD | Hrvatska narodna stranka – Liberalni demokrati | Croatian People's Party -- Liberal Democrats | 1.8421 | 62 | 797 | 1384 | |||
HRV | Croatia | parliament | 2000-01-03 | 2 | 151 | LS | Liberalna stranka | Liberal Party | 2.807 | 62 | 797 | 1457 | |||
HRV | Croatia | parliament | 2000-01-03 | 1 | 151 | one-seat | one seat | one seat | 62 | 797 | 2295 | ||||
HRV | Croatia | parliament | 2000-01-03 | 1 | 151 | ethnic | ethnic | ethnic | 62 | 797 | 2192 | ||||
HRV | Croatia | parliament | 2000-01-03 | 1.1 | 0 | 151 | HSP-1861 | Hrvatska Stranka Prava 1861 | Croatian Party of Right of 1861 | 8.8 | 62 | 797 | 2199 | ||
HRV | Croatia | parliament | 2000-01-03 | 1.9 | 0 | 151 | HSU | Hrvatska stranka umirovljenika | Croatian Party of Pensioners | 62 | 797 | 2134 | |||
HRV | Croatia | parliament | 2000-01-03 | 1.4 | 0 | 151 | HSNS | Hrvatska seljacka narodna stranka | Croatian Peasant's People's Party | 5.3 | 62 | 797 | 2202 | ||
HRV | Croatia | parliament | 2000-01-03 | 1.4 | 0 | 151 | HPS | Hrvatska pucka stranka | Croatian People's Party | 7.4 | 62 | 797 | 2203 | ||
HUN | Hungary | parliament | 1990-04-08 | 24.7 | 164 | 386 | MDF | Magyar Demokrata Fórum | Hungarian Democratic Forum | 6.4826 | 39 | 257 | 546 | ||
HUN | Hungary | parliament | 1990-04-08 | 21.4 | 93 | 386 | SzDSz | Szabad Demokraták Szövetsége | Alliance of Free Democrats | 3.9659 | 39 | 257 | 1426 | ||
HUN | Hungary | parliament | 1990-04-08 | 11.7 | 44 | 386 | FKgP | Független Kisgazda Párt | Independent Small Holders Party | 9.0186 | 39 | 257 | 870 | ||
HUN | Hungary | parliament | 1990-04-08 | 10.9 | 33 | 386 | MSZP | Magyar Szocialista Párt | Hungarian Socialist Party | 2.8743 | 39 | 257 | 1591 | ||
HUN | Hungary | parliament | 1990-04-08 | 9.0 | 22 | 386 | Fi-MPSz | Fidesz – Magyar Polgári Szövetség | Fidesz -- Hungarian Civic Union | 6.5432 | 39 | 257 | 921 | ||
HUN | Hungary | parliament | 1990-04-08 | 6.5 | 21 | 386 | KDNP | Kereszténydemokrata Néppárt | Christian Democratic People's Party | 7.4 | 39 | 257 | 434 | ||
HUN | Hungary | parliament | 1990-04-08 | 1.0 | 7 | 386 | none | független | no party affiliation | 39 | 257 | 1617 | |||
HUN | Hungary | parliament | 1990-04-08 | 3.1 | 2 | 386 | ASZ | Agrárszövetség | Agrarian Alliance | 5.3 | 39 | 257 | 1183 | ||
HUN | Hungary | parliament | 1990-04-08 | 3.6 | 0 | 386 | MSzDP | Magyarországi Szociáldemokrata Párt | Social Democratic Party | 1.3 | 39 | 257 | 418 | ||
HUN | Hungary | parliament | 1990-04-08 | 3.7 | 0 | 386 | MMP | Magyar Munkáspárt | Hungarian Workers' Party | 0.6316 | 39 | 257 | 1202 | ||
HUN | Hungary | parliament | 1990-04-08 | 1.9 | 0 | 386 | HVK | Hazafias Választási Koalíció | Patriotic Elections Coalition | 39 | 257 | 198 | |||
HUN | Hungary | parliament | 1990-04-08 | 1.9 | 0 | 386 | VP | Vállalkozók Pártja Egyesület | Entrepreneurs' Party | 6.0 | 39 | 257 | 1203 | ||
IRL | Ireland | parliament | 1922-06-22 | 38.5 | 58 | 128 | CG | Cumann na nGaedheal | Society of the Gaels | 7.4 | 37 | 912 | 2447 | ||
IRL | Ireland | parliament | 1922-06-22 | 21.8 | 36 | 128 | FF | Fianna Fáil | Fianna Fail | 6.0713 | 37 | 912 | 280 | ||
IRL | Ireland | parliament | 1922-06-22 | 21.3 | 17 | 128 | Lab | Labour Party | Labour Party | 3.6252 | 37 | 912 | 318 | ||
IRL | Ireland | parliament | 1922-06-22 | 7.8 | 9 | 128 | none | no party affiliation | no party affiliation | 37 | 912 | 30 | |||
IRL | Ireland | parliament | 1922-06-22 | 7.8 | 7 | 128 | FP | Farmers' Party | Farmers' Party | 5.3 | 37 | 912 | 2563 | ||
IRL | Ireland | parliament | 1922-06-22 | 2.3 | 1 | 128 | BP | Business and Professional Group | Business and Professional Group | 6.0 | 37 | 912 | 2523 | ||
ISL | Iceland | parliament | 1919-11-15 | 45.8 | 16 | 40 | He | Heimastjórnarflokkurinn | Home Rule Party | 6.0 | 56 | 922 | 2440 | ||
ISL | Iceland | parliament | 1919-11-15 | 25.3 | 13 | 40 | Sj-07 | Sjálfstæðisflokkurinn – 1907 | Independence Party -- 1907 | 7.4 | 56 | 922 | 2561 | ||
ISL | Iceland | parliament | 1919-11-15 | 22.2 | 11 | 40 | F | Framsóknarflokkurinn | Progressive Party | 5.0365 | 56 | 922 | 1455 | ||
ISL | Iceland | parliament | 1919-11-15 | 6.8 | 0 | 40 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 922 | 228 | ||
ISR | Israel | parliament | 1949-01-25 | 35.7 | 46 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 704 | 244 | ||
ISR | Israel | parliament | 1949-01-25 | 14.7 | 19 | 120 | Mapam | Mifleget HaPoalim HaMeuhedet | United Workers Party | 3.3 | 34 | 704 | 1168 | ||
ISR | Israel | parliament | 1949-01-25 | 12.2 | 16 | 120 | HDM | Hazit Datit Meuhedet | United Religious Front | 34 | 704 | 1821 | |||
ISR | Israel | parliament | 1949-01-25 | 11.5 | 14 | 120 | Herut | Herut | Freedom Party | 7.4 | 34 | 704 | 1204 | ||
ISR | Israel | parliament | 1949-01-25 | 5.2 | 7 | 120 | ZK | Zionim Klalim | General Zionists | 6.0 | 34 | 704 | 1472 | ||
ISR | Israel | parliament | 1949-01-25 | 4.1 | 5 | 120 | MP | Miflaga Progresivit | Progressive Party | 6.0 | 34 | 704 | 1822 | ||
ISR | Israel | parliament | 1949-01-25 | 3.5 | 4 | 120 | SVM | Sfaradim VeEdot Mizrah | Sephardim and Oriental Communities | 7.4 | 34 | 704 | 1831 | ||
ISR | Israel | parliament | 1949-01-25 | 3.5 | 4 | 120 | MiKo|Mo|Sh | HaMiflega HaKomunistit | Moked | Sheli | Communist Party | Moked | Sheli | 1.3 | 34 | 704 | 387 | ||
ISR | Israel | parliament | 1949-01-25 | 1.7 | 2 | 120 | RDN | Reshima Demokratit shel Natzrat | Democratic List of Nazareth | 34 | 704 | 1824 | |||
ISR | Israel | parliament | 1949-01-25 | 1.2 | 1 | 120 | ReLo | Reshimat HaLohmim | Fighters List | 34 | 704 | 2309 | |||
ISR | Israel | parliament | 1949-01-25 | 1.0 | 1 | 120 | HHT | Hitahdut HaTeimanim | Yemenite Association | 34 | 704 | 1827 | |||
ISR | Israel | parliament | 1949-01-25 | 1.2 | 1 | 120 | Vitzo | Vitzo | Women's International Zionist Organization | 34 | 704 | 2310 | |||
ISR | Israel | parliament | 1949-01-25 | 0.7 | 0 | 120 | no-seat | no seat | no seat | 34 | 704 | 2308 | |||
ITA | Italy | parliament | 1946-06-02 | 35.21 | 207 | 556 | DC | Democrazia Cristiana | Christian Democrats | 5.6611 | 26 | 503 | 1633 | ||
ITA | Italy | parliament | 1946-06-02 | 20.68 | 115 | 556 | PSI | Partito Socialista Italiano | Italian Socialist Party | 3.7722 | 26 | 503 | 1475 | ||
ITA | Italy | parliament | 1946-06-02 | 18.93 | 104 | 556 | PCI | Partito Comunista Italiano | Communist Party | 1.6 | 26 | 503 | 1088 | ||
ITA | Italy | parliament | 1946-06-02 | 6.78 | 42 | 556 | PLI | Partito Liberale Italiano | Italian Liberal Party | 6.45 | 26 | 503 | 487 | ||
ITA | Italy | parliament | 1946-06-02 | 5.27 | 30 | 556 | FUQ | Fronte dell'Uomo Qualunque | Front of the Ordinary Man | 7.4 | 26 | 503 | 409 | ||
ITA | Italy | parliament | 1946-06-02 | 4.36 | 23 | 556 | PRI | Partito Repubblicano Italiano | Republican Party | 4.9704 | 26 | 503 | 93 | ||
ITA | Italy | parliament | 1946-06-02 | 2.77 | 16 | 556 | PNM | Partito Nazionale Monarchico | Monarchist National Party | 8.8 | 26 | 503 | 1050 | ||
ITA | Italy | parliament | 1946-06-02 | 1.45 | 7 | 556 | PAz | Partito d'Azione | Action Party | 1.3 | 26 | 503 | 1330 | ||
ITA | Italy | parliament | 1946-06-02 | 0.74 | 4 | 556 | MIS | Movimento Indipendentista Siciliano | Movement for the Independence of Sicily | 26 | 503 | 1028 | |||
ITA | Italy | parliament | 1946-06-02 | 0.62 | 3 | 556 | one-seat | one seat | one seat | 26 | 503 | 2302 | |||
ITA | Italy | parliament | 1946-06-02 | 0.34 | 2 | 556 | PSA | Partito Sardo d'Azione | Sardinian Action Party | 4.2 | 26 | 503 | 335 | ||
ITA | Italy | parliament | 1946-06-02 | 0.42 | 2 | 556 | CDR | Concentrazione Democratica Repubblicana | Republican Democratic Concentration | 6.0 | 26 | 503 | 2044 | ||
ITA | Italy | parliament | 1946-06-02 | 0.44 | 1 | 556 | PaCoI | Partito dei Contadini d'Italia | Agrarian Party | 5.3 | 26 | 503 | 618 | ||
JPN | Japan | parliament | 1946-04-10 | 25.4 | 148 | 464 | JLP | Nihon Jiyūtō | Japan Liberal Party | 7.4 | 5 | 697 | 1726 | ||
JPN | Japan | parliament | 1946-04-10 | 20.3 | 110 | 464 | DP | Minshutō | Democratic Party | 7.4 | 5 | 697 | 1734 | ||
JPN | Japan | parliament | 1946-04-10 | 18.2 | 96 | 464 | JSP | Nihon Shakai-tō | Japan Socialist Party | 2.6344 | 5 | 697 | 940 | ||
JPN | Japan | parliament | 1946-04-10 | 6.3 | 45 | 464 | NCoP | Kokumin Kyôdô Tô | National Cooperative Party | 6.0 | 5 | 697 | 1733 | ||
JPN | Japan | parliament | 1946-04-10 | 33 | 464 | etc | others | others | 5 | 697 | 1055 | ||||
JPN | Japan | parliament | 1946-04-10 | 14.0 | 26 | 464 | none | no party affiliation | no party affiliation | 5 | 697 | 905 | |||
JPN | Japan | parliament | 1946-04-10 | 3.8 | 6 | 464 | JCP | Nihon Kyōsan-tō | Japan Communist Party | 1.148 | 5 | 697 | 1540 | ||
LTU | Lithuania | parliament | 1990-03-10 | 64 | 135 | none | no party affiliation | no party affiliation | 15 | 462 | 58 | ||||
LTU | Lithuania | parliament | 1990-03-10 | 46 | 135 | LKP | Lietuvos komunistų partija | Communist Party of Lithuania | 1.3 | 15 | 462 | 1446 | |||
LTU | Lithuania | parliament | 1990-03-10 | 9 | 135 | LSDP-89 | Lietuvos socialdemokratų partija – 1989 | Lithuanian Social Democratic Party -- 1989 | 4.0 | 15 | 462 | 1408 | |||
LTU | Lithuania | parliament | 1990-03-10 | 7 | 135 | TSKP | Lietuvos komunistų partija TSKP platformoje | Lithuanian Communist Party on the CPSU Platform | 1.3 | 15 | 462 | 1623 |
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;