view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by previous_cabinet_id
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AUS | Australia | parliament | 1901-03-30 | 44.4 | 32 | 75 | PP | Protectionist Party | Protectionist Party | 7.4 | 33 | 731 | 1898 | ||
AUS | Australia | parliament | 1901-03-30 | 34.2 | 26 | 75 | FTP | Free Trade Party | Free Trade Party | 6.0 | 33 | 731 | 1938 | ||
AUS | Australia | parliament | 1901-03-30 | 19.4 | 15 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 731 | 1253 | ||
AUS | Australia | parliament | 1901-03-30 | 1.4 | 1 | 75 | none | no party affiliation | no party affiliation | 33 | 731 | 1396 | |||
AUS | Australia | parliament | 1901-03-30 | 0.6 | 1 | 75 | one-seat | one seat | one seat | 33 | 731 | 2299 | |||
AUT | Austria | parliament | 1919-02-16 | 40.75 | 72 | 170 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 1030 | 973 | ||
AUT | Austria | parliament | 1919-02-16 | 35.93 | 69 | 170 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 1030 | 1013 | ||
AUT | Austria | parliament | 1919-02-16 | 5.85 | 8 | 170 | DNP | Deutschnationale | German-Nationals | 7.4 | 59 | 1030 | 2672 | ||
AUT | Austria | parliament | 1919-02-16 | 1.9 | 5 | 170 | GFOP | Deutsche Freiheits und Ordnungspartei | German Freedom and Order Party | 8.8 | 59 | 1030 | 2676 | ||
AUT | Austria | parliament | 1919-02-16 | 1.49 | 4 | 170 | one-seat | one-seat | one-seat | 59 | 1030 | 2686 | |||
AUT | Austria | parliament | 1919-02-16 | 1.58 | 3 | 170 | SBP | Steirische Bauernpartei | Styrian Farmers' Party | 5.3 | 59 | 1030 | 2677 | ||
AUT | Austria | parliament | 1919-02-16 | 2.16 | 3 | 170 | DD | Deutschdemokraten | German-Democrats | 6.0 | 59 | 1030 | 2675 | ||
AUT | Austria | parliament | 1919-02-16 | 2.02 | 2 | 170 | DVP | Deutsche Volkspartei | German People's Party | 7.4 | 59 | 1030 | 2673 | ||
AUT | Austria | parliament | 1919-02-16 | 1.12 | 2 | 170 | KB | Kärtner Bauernbund | Carinthian Farmers' Association | 5.3 | 59 | 1030 | 2678 | ||
AUT | Austria | parliament | 1919-02-16 | 2.27 | 1 | 170 | T | Tschechoslowaken | Czechoslovakians | 59 | 1030 | 2689 | |||
AUT | Austria | parliament | 1919-02-16 | 1.64 | 1 | 170 | BD | Bürgerliche Demokraten | Centrist Democrats | 6.0 | 59 | 1030 | 2688 | ||
AUT | Austria | parliament | 1919-02-16 | 1.57 | 0 | 170 | NDP | Nationaldemokratische Partei | National Democratic Party | 8.8 | 59 | 1030 | 2679 | ||
BEL | Belgium | parliament | 1900-05-27 | 48.5 | 86 | 152 | KP-PC | Katholieke Partij – Parti catholique | Catholic Party | 6.2 | 64 | 868 | 2423 | ||
BEL | Belgium | parliament | 1900-05-27 | 22.5 | 32 | 152 | BWP-POB | Belgische Werkliedenpartij – Parti Ouvrier Belge | Belgian Labour Party | 3.3 | 64 | 868 | 2422 | ||
BEL | Belgium | parliament | 1900-05-27 | 22.7 | 31 | 152 | LP-PL | Liberale Partij – Parti libéral | Liberal Party | 6.0 | 64 | 868 | 63 | ||
BEL | Belgium | parliament | 1900-05-27 | 2 | 152 | etc | others | others | 64 | 868 | 2488 | ||||
BEL | Belgium | parliament | 1900-05-27 | 2.5 | 1 | 152 | CV | Christene Volkspartij | Christian Peoples' Party [Daens] | 6.2 | 64 | 868 | 2481 | ||
BGR | Bulgaria | parliament | 1991-10-13 | 34.36 | 110 | 240 | SDS | Suyuz na Demokratichnite Sili | Union of Democratic Forces | 6.1111 | 10 | 32 | 423 | ||
BGR | Bulgaria | parliament | 1991-10-13 | 33.14 | 106 | 240 | KzB|DL | Koalitsiya za Balgariya | Demokratichna Levitsa | Coalition for Bulgaria | Democratic Left | 2.8982 | 10 | 32 | 1160 | ||
BGR | Bulgaria | parliament | 1991-10-13 | 7.55 | 24 | 240 | DPS | Dvizhenie za Prava i Svobodi | Movement for Rights and Freedoms | 4.5828 | 10 | 32 | 1286 | ||
BGR | Bulgaria | parliament | 1991-10-13 | 3.86 | 0 | 240 | ZNS | Zemedelski Naroden Suyuz | Agrarian People's Union | 5.5263 | 10 | 32 | 353 | ||
BGR | Bulgaria | parliament | 1991-10-13 | 3.44 | 0 | 240 | BZNS-NP | Balgarski Zemedelski Naroden Suyuz – "Nikola Petkov" | Bulgarian Agrarian National Union -- "Nikola Petkov" | 5.3 | 10 | 32 | 2173 | ||
BGR | Bulgaria | parliament | 1991-10-13 | 3.2 | 0 | 240 | SDS-ts | Suyuz na Demokratichnite Sili – Tsentur | Union of Democratic Forces -- Centre | 3.3 | 10 | 32 | 2174 | ||
BGR | Bulgaria | parliament | 1991-10-13 | 1.82 | 0 | 240 | FTB | Federatsiya Tsarstvo Balgariya | Kingdom of Bulgaria Confederation | 10 | 32 | 800 | |||
BGR | Bulgaria | parliament | 1991-10-13 | 1.32 | 0 | 240 | BBB | Balgarski Biznes Blok | Bulgarian Business Bloc | 6.6784 | 10 | 32 | 599 | ||
BGR | Bulgaria | parliament | 1991-10-13 | 1.13 | 0 | 240 | BNRP | Balgarska Natsionalnoradikalna Partiya | Bulgarian National Radical Party | 8.8 | 10 | 32 | 364 | ||
BGR | Bulgaria | parliament | 1991-10-13 | 2.81 | 0 | 240 | SDS-l | Suyuz na Demokratichnite Sili – Liberali | Union of Democratic Forces -- Liberal | 6.0 | 10 | 32 | 2175 | ||
CAN | Canada | parliament | 1900-11-07 | 51.24 | 133 | 213 | LP | Liberal Party of Canada | Liberal Party of Canada | 5.0552 | 29 | 883 | 368 | ||
CAN | Canada | parliament | 1900-11-07 | 47.41 | 80 | 213 | PCP | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | 6.7112 | 29 | 883 | 794 | ||
CAN | Canada | parliament | 1900-11-07 | 0.28 | 0 | 213 | none | no party affiliation | no party affiliation | 29 | 883 | 1189 | |||
CHE | Switzerland | parliament | 1902-10-26 | 50.39 | 100 | 167 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 982 | 26 | ||
CHE | Switzerland | parliament | 1902-10-26 | 23.09 | 36 | 167 | KK/CVP | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien | Catholic Conservative / Christian Democratic Peoples Party | 4.7288 | 40 | 982 | 531 | ||
CHE | Switzerland | parliament | 1902-10-26 | 8.58 | 20 | 167 | LPS | Liberale Partei der Schweiz – Parti liberal suisse | Liberal Party of Switzerland | 7.2961 | 40 | 982 | 458 | ||
CHE | Switzerland | parliament | 1902-10-26 | 12.6 | 7 | 167 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 982 | 35 | ||
CHE | Switzerland | parliament | 1902-10-26 | 3.7 | 4 | 167 | DG | Gruppe der Demokraten – Groupe des democrates | Democratic Group | 3.3 | 40 | 982 | 886 | ||
CYP | Cyprus | parliament | 1976-09-05 | 71.2 | 21 | 35 | DIKO | Dimokratikó Kómma | Democratic Party | 5.1316 | 51 | 528 | 851 | ||
CYP | Cyprus | parliament | 1976-09-05 | 9 | 35 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 528 | 572 | |||
CYP | Cyprus | parliament | 1976-09-05 | 4 | 35 | EDEK | Kinima Sosialdimokraton EDEK | Movement for Social Democracy EDEK | 3.2895 | 51 | 528 | 945 | |||
CYP | Cyprus | parliament | 1976-09-05 | 1.2 | 1 | 35 | none | no party affiliation | no party affiliation | 51 | 528 | 534 | |||
CYP | Cyprus | parliament | 1976-09-05 | 27.6 | 0 | 35 | DISY | Dimokratikós Sinayermós | Democratic Rally | 8.6842 | 51 | 528 | 1575 | ||
CZE | Czech Republic | parliament | 1990-06-09 | 49.5 | 127 | 200 | OF | Obcanské fórum | Civic Forum | 6.0 | 68 | 63 | 743 | ||
CZE | Czech Republic | parliament | 1990-06-09 | 13.24 | 32 | 200 | KSC | Komunistická strana Československa | Communist Party of Czechoslovakia | 1.3 | 68 | 63 | 665 | ||
CZE | Czech Republic | parliament | 1990-06-09 | 10.03 | 22 | 200 | HSD-SMS | Hnutí za samosprávnou demokracii – Společnost pro Moravu a Slezsko | Movement for Self-Governing Democracy -- Society for Moravia and Silesia | 68 | 63 | 19 | |||
CZE | Czech Republic | parliament | 1990-06-09 | 8.42 | 15 | 200 | KDU-CSL | Křesťanská a demokratická unie – Československá strana lidová | Christian Democratic Union -- People's Party | 5.8099 | 68 | 63 | 1245 | ||
CZE | Czech Republic | parliament | 1990-06-09 | 4 | 200 | KDS | Krestanskodemokraticka strana | Christian Democratic Party | 8.1444 | 68 | 63 | 440 | |||
CZE | Czech Republic | parliament | 1990-06-09 | 4.11 | 0 | 200 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 63 | 789 | ||
CZE | Czech Republic | parliament | 1990-06-09 | 4.1 | 0 | 200 | SZ | Strana zelených | Green Party | 4.123 | 68 | 63 | 196 | ||
CZE | Czech Republic | parliament | 1990-06-09 | 1.0 | 0 | 200 | SPR-RSC | Sdruzení pro republiku – Republikánská strana Ceskoslovenska | Rally for the Republic -- Republican Party of Czechoslovakia | 9.7778 | 68 | 63 | 872 | ||
CZE | Czech Republic | parliament | 1990-06-09 | 2.68 | 0 | 200 | CNSP | Česká národně strana socialistická | Czech National Social(ist) Party | 8.8 | 68 | 63 | 29 | ||
CZE | Czech Republic | parliament | 1990-06-09 | 4.11 | 0 | 200 | SZV | Spojenectví zemědělců a venkova | Alliance of Farmers and the Countryside | 5.3 | 68 | 63 | 2101 | ||
CZE | Czech Republic | parliament | 1990-06-09 | 1.04 | 0 | 200 | CP-SB | Konzervativní strana – Svobodný blok | Conservative Party -- Free Bloc | 7.4 | 68 | 63 | 2102 | ||
DEU | Germany | parliament | 1919-01-19 | 37.87 | 165 | 423 | SPD | Sozialdemokratische Partei Deutschlands | Social Democratic Party of Germany | 3.6451 | 54 | 1031 | 558 | ||
DEU | Germany | parliament | 1919-01-19 | 18.32 | 74 | 423 | DDP | Deutsche Demokratische Partei | German Democratic Party | 6.0 | 54 | 1031 | 2691 | ||
DEU | Germany | parliament | 1919-01-19 | 15.45 | 73 | 423 | DZ | Deutsche Zentrumspartei | Centre Party | 6.2 | 54 | 1031 | 137 | ||
DEU | Germany | parliament | 1919-01-19 | 10.26 | 41 | 423 | DNVP | Deutschnationale Volkspartei | German National People's Party | 8.8 | 54 | 1031 | 2692 | ||
DEU | Germany | parliament | 1919-01-19 | 4.66 | 23 | 423 | DVP | Deutsche Volkspartei | German People's Party | 7.4 | 54 | 1031 | 2693 | ||
DEU | Germany | parliament | 1919-01-19 | 7.63 | 22 | 423 | USPD | Unabhängige Sozialdemokratische Partei Deutschlands | Independent Social Democratic Party of Germany | 1.3 | 54 | 1031 | 2690 | ||
DEU | Germany | parliament | 1919-01-19 | 3.77 | 16 | 423 | BVP | Bayerische Volkspartei | Bavarian People's Party | 6.2 | 54 | 1031 | 2697 | ||
DEU | Germany | parliament | 1919-01-19 | 0.9 | 4 | 423 | BBB | Bayerischer Bauernbund | Bavarian Peasants' League | 6.0 | 54 | 1031 | 2701 | ||
DEU | Germany | parliament | 1919-01-19 | 0.7 | 3 | 423 | DHP | Deutsch-Hannoversche Partei | German-Hanoverian Party | 7.4 | 54 | 1031 | 2696 | ||
DEU | Germany | parliament | 1919-01-19 | 0.38 | 2 | 423 | one-seat | one seat | one seat | 54 | 1031 | 2289 | |||
DNK | Denmark | parliament | 1901-04-03 | 42.87 | 76 | 114 | V | Venstre | Liberal Party | 7.292 | 21 | 886 | 1605 | ||
DNK | Denmark | parliament | 1901-04-03 | 11.4 | 16 | 114 | MV | Moderate Venstre | Moderate Liberals | 6.0 | 21 | 886 | 2430 | ||
DNK | Denmark | parliament | 1901-04-03 | 17.06 | 14 | 114 | Sd | Socialdemokraterne | Social Democrats | 3.8011 | 21 | 886 | 1629 | ||
DNK | Denmark | parliament | 1901-04-03 | 24.04 | 8 | 114 | KF | Konservative | Conservatives | 7.2186 | 21 | 886 | 590 | ||
ESP | Spain | parliament | 1977-06-15 | 34.52 | 166 | 350 | UCD | Unión de Centro Democrático | Union of the Democratic Centre | 7.1 | 27 | 42 | 135 | ||
ESP | Spain | parliament | 1977-06-15 | 29.39 | 118 | 350 | PSOE | Partido Socialista Obrero Español | Spanish Socialist Workers Party | 3.7377 | 27 | 42 | 902 | ||
ESP | Spain | parliament | 1977-06-15 | 9.35 | 19 | 350 | PCE|IU | Partido Communista | Izquierda Unida | Communist Party | United Left | 2.0183 | 27 | 42 | 118 | ||
ESP | Spain | parliament | 1977-06-15 | 8.23 | 16 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 42 | 645 | ||
ESP | Spain | parliament | 1977-06-15 | 2.82 | 11 | 350 | CiU | Convergència i Unió | Convergence and Union | 6.2564 | 27 | 42 | 894 | ||
ESP | Spain | parliament | 1977-06-15 | 1.62 | 8 | 350 | PNV | Partido Nacionalista Vasco – Euzko Alderdi Jeltzalea | Basque Nationalist Party | 6.2144 | 27 | 42 | 1361 | ||
ESP | Spain | parliament | 1977-06-15 | 4.47 | 6 | 350 | PSP | Partido Socialista Popular | People's Socialist Party | 4.2083 | 27 | 42 | 1790 | ||
ESP | Spain | parliament | 1977-06-15 | 0.95 | 2 | 350 | UCDCC | Unió del Centre i la Democràcia Cristiana de Catalunya | Union of Centre and Christian Democracy of Catalonia | 6.2 | 27 | 42 | 62 | ||
ESP | Spain | parliament | 1977-06-15 | 0.2 | 1 | 350 | PAR | Partido Aragonés Regionalista | Aragonese Regionalist Party | 7.1909 | 27 | 42 | 1221 | ||
ESP | Spain | parliament | 1977-06-15 | 0.16 | 1 | 350 | etc | others | others | 27 | 42 | 1377 | |||
ESP | Spain | parliament | 1977-06-15 | 0.34 | 1 | 350 | EE | Euzkadiko Ezkerra | Basque Left | 2.4 | 27 | 42 | 1026 | ||
ESP | Spain | parliament | 1977-06-15 | 0.79 | 1 | 350 | ERC | Esquerra Republicana de Catalunya | Republican Left of Catalonia | 3.1072 | 27 | 42 | 757 | ||
ESP | Spain | parliament | 1977-06-15 | 1.18 | 0 | 350 | EDC | Coalición Electoral Equipo de la Democracia Cristiana | Electoral Coalition of Christian Democratic Team | 6.2 | 27 | 42 | 2084 | ||
EST | Estonia | parliament | 1992-09-20 | 22.0 | 29 | 101 | RKI | Rahvuslik Koonderakond "Isamaa" | National Coalition Party "Pro Patria" | 7.4 | 75 | 670 | 243 | ||
EST | Estonia | parliament | 1992-09-20 | 13.6 | 17 | 101 | EKK | Eesti Koonderakond | Estonian Coalition Party | 7.2222 | 75 | 670 | 486 | ||
EST | Estonia | parliament | 1992-09-20 | 12.25 | 15 | 101 | R | Rahvarinne | Popular Front | 3.3333 | 75 | 670 | 450 | ||
EST | Estonia | parliament | 1992-09-20 | 9.73 | 12 | 101 | SDE|M | Sotsiaaldemokraatlik Erakond | Mõõdukad | Social Democratic Party | Moderates | 4.1915 | 75 | 670 | 1448 | ||
EST | Estonia | parliament | 1992-09-20 | 8.79 | 10 | 101 | ERSP | Eesti Rahvusliku Sõltumatuse Partei | Estonian National Independence Party | 7.7778 | 75 | 670 | 552 | ||
EST | Estonia | parliament | 1992-09-20 | 6.89 | 8 | 101 | EKo | Eesti Kodanik | Estonian Citizens | 8.8 | 75 | 670 | 1064 | ||
EST | Estonia | parliament | 1992-09-20 | 7.12 | 8 | 101 | SK | Sõltumatud Kuningriiklased | Independent Royalists | 75 | 670 | 25 | |||
EST | Estonia | parliament | 1992-09-20 | 2.39 | 1 | 101 | EEE | Eesti Ettevõtjate Erakond | Estonian Entrepreneur Party | 8.3333 | 75 | 670 | 1516 | ||
EST | Estonia | parliament | 1992-09-20 | 2.62 | 1 | 101 | EER-91 | Eesti Rohelised – 1991 | Estonian Greens -- 1991 | 5.5556 | 75 | 670 | 2631 | ||
EST | Estonia | parliament | 1992-09-20 | 2.91 | 0 | 101 | PK | Põllumeeste Kogu | Union of Farmers | 2.2222 | 75 | 670 | 1553 | ||
EST | Estonia | parliament | 1992-09-20 | 3.71 | 0 | 101 | EPL | Eesti Pensionaride Liit | Estonian Pensioners' Union | 75 | 670 | 1792 | |||
EST | Estonia | parliament | 1992-09-20 | 1.61 | 0 | 101 | EVP | Eesti Vasakpartei | Estonian Left Party | 1.3 | 75 | 670 | 2416 | ||
FIN | Finland | parliament | 1917-10-02 | 44.79 | 92 | 171 | SSDP | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti | Social Democratic Party of Finland | 3.5595 | 67 | 902 | 395 | ||
FIN | Finland | parliament | 1917-10-02 | 30.17 | 32 | 171 | SP-V | Suomalainen puolue – Vanhasuomalaiset | Finnish Party -- Old Finns | 7.4 | 67 | 902 | 2434 | ||
FIN | Finland | parliament | 1917-10-02 | 12.38 | 26 | 171 | KESK | Keskusta | Centre Party | 5.8027 | 67 | 902 | 94 | ||
FIN | Finland | parliament | 1917-10-02 | 10.9 | 21 | 171 | RKP-SFP | Ruotsalainen Kansanpuolue – Svenska Folkepartiet i Finland | Swedish People's Party | 6.3906 | 67 | 902 | 585 | ||
FIN | Finland | parliament | 1917-10-02 | 1.56 | 0 | 171 | SKrTL | Suomen Kristillisen Työväen Liitto – Finlands kristliga arbetarförbund | Christian Workers' Union of Finland | 3.3 | 67 | 902 | 2433 |
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;