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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LTU | Lithuania | parliament | 1990-03-10 | 4 | 135 | LZP | Lietuvos žalioji partija | Lithuanian Green Party | 2.5 | 15 | 462 | 21 | |||
LTU | Lithuania | parliament | 1990-03-10 | 3 | 135 | LDP | Lietuvos demokratų partija | Lithuanian Democratic Party | 5.8333 | 15 | 462 | 1144 | |||
LTU | Lithuania | parliament | 1990-03-10 | 2 | 135 | LKDP | Lietuvos krikščionys demokratai | Lithuanian Christian Democrats | 6.2385 | 15 | 462 | 675 | |||
LUX | Luxembourg | parliament | 1919-10-26 | 52.8 | 27 | 48 | PD | Rietspartei | Party of the Right | 7.4 | 7 | 930 | 2527 | ||
LUX | Luxembourg | parliament | 1919-10-26 | 15.6 | 8 | 48 | LSAP | Lëtzebuerger Sozialistesch Aarbechterpartei | Luxembourg Socialist Workers' Party | 3.2895 | 7 | 930 | 701 | ||
LUX | Luxembourg | parliament | 1919-10-26 | 14.2 | 7 | 48 | LL | Liberal Liga | Liberal League | 6.0 | 7 | 930 | 2453 | ||
LUX | Luxembourg | parliament | 1919-10-26 | 6.6 | 3 | 48 | ONP | Onofhängeg Nationalpartei | Independent National Party | 8.8 | 7 | 930 | 2450 | ||
LUX | Luxembourg | parliament | 1919-10-26 | 6.2 | 2 | 48 | FV | Fräi Vollekspartei | Independent People's Party | 7 | 930 | 2451 | |||
LUX | Luxembourg | parliament | 1919-10-26 | 0.7 | 1 | 48 | one-seat | one seat | one seat | 7 | 930 | 2290 | |||
LUX | Luxembourg | parliament | 1919-10-26 | 3.0 | 0 | 48 | no-seat | no seat | no seat | 7 | 930 | 2149 | |||
LVA | Latvia | parliament | 1990-04-29 | 68.2 | 131 | 201 | LTF | Latvijas Tautas fronte | Popular Front of Latvia | 55 | 647 | 42 | |||
LVA | Latvia | parliament | 1990-04-29 | 21.5 | 55 | 201 | LKP | Latvijas Komunistiskā partija | Communist Party of Latvia | 1.3 | 55 | 647 | 1260 | ||
LVA | Latvia | parliament | 1990-04-29 | 10.3 | 15 | 201 | none | no party affiliation | no party affiliation | 55 | 647 | 288 | |||
MLT | Malta | parliament | 1947-10-27 | 59.86 | 24 | 40 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 550 | 1003 | ||
MLT | Malta | parliament | 1947-10-27 | 18.05 | 7 | 40 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 550 | 984 | ||
MLT | Malta | parliament | 1947-10-27 | 13.28 | 4 | 40 | DAP | Democratic Action Party | Democratic Action Party | 7.4 | 72 | 550 | 816 | ||
MLT | Malta | parliament | 1947-10-27 | 5.21 | 3 | 40 | GP | Gozo Party | Gozo Party | 72 | 550 | 1298 | |||
MLT | Malta | parliament | 1947-10-27 | 3.47 | 2 | 40 | JP | Jones Party | Jones Party | 72 | 550 | 248 | |||
MLT | Malta | parliament | 1947-10-27 | 0.14 | 0 | 40 | none | no party affiliation | no party affiliation | 72 | 550 | 1572 | |||
NLD | Netherlands | parliament | 1918-07-03 | 30.0 | 30 | 93 | RKP | Roomsch Katholieke Partij | Roman Catholic Party | 6.2 | 8 | 937 | 2539 | ||
NLD | Netherlands | parliament | 1918-07-03 | 22.0 | 22 | 93 | SDAP | Sociaal Democratische Arbeiders Partij | Social Democratic Workers' Party | 3.3 | 8 | 937 | 1451 | ||
NLD | Netherlands | parliament | 1918-07-03 | 13.4 | 13 | 93 | ARP | Anti-Revolutionaire Partij | Anti-Revolutionary Party | 5.8067 | 8 | 937 | 300 | ||
NLD | Netherlands | parliament | 1918-07-03 | 6.5 | 7 | 93 | CHU | Christelijk-Historische Unie | Christian Historical Union | 5.8067 | 8 | 937 | 405 | ||
NLD | Netherlands | parliament | 1918-07-03 | 6.2 | 6 | 93 | LU | Liberale Unie | Liberal Union | 6.0 | 8 | 937 | 2462 | ||
NLD | Netherlands | parliament | 1918-07-03 | 5.3 | 5 | 93 | VDB | Vrijzinnig Democratische Bond | Free-thinking Democratic League | 6.0 | 8 | 937 | 944 | ||
NLD | Netherlands | parliament | 1918-07-03 | 3.8 | 4 | 93 | BVL | Bond van Vrije Liberalen | League of Free Liberals | 6.0 | 8 | 937 | 2459 | ||
NLD | Netherlands | parliament | 1918-07-03 | 3.1 | 3 | 93 | EB | Economische Bond | Economic League | 6.0 | 8 | 937 | 2457 | ||
NLD | Netherlands | parliament | 1918-07-03 | 2.3 | 2 | 93 | CPN | Communistische Partij Nederland | Communist Party of the Netherlands | 0.8 | 8 | 937 | 1194 | ||
NLD | Netherlands | parliament | 1918-07-03 | 0.4 | 1 | 93 | PB|NBTM | Peasants' League | Nationale Boeren-, Tuinders- en Middenstandspartij | Plattelandersbond | National Farmers', Horticulturists' and Middle Class Party | 5.3 | 8 | 937 | 2458 | ||
NLD | Netherlands | parliament | 1918-07-03 | 0 | 93 | no-seat | no seat | no seat | 8 | 937 | 2110 | ||||
NOR | Norway | parliament | 1900-07-01 | 54.0 | 77 | 114 | V | Venstre | Liberal Party of Norway | 5.1467 | 9 | 943 | 647 | ||
NOR | Norway | parliament | 1900-07-01 | 40.8 | 31 | 114 | H | Høyre | Conservative Party | 7.8994 | 9 | 943 | 1435 | ||
NOR | Norway | parliament | 1900-07-01 | 6 | 114 | MV | Moderate Venstre | Moderate Liberal Party | 6.0 | 9 | 943 | 2473 | |||
NOR | Norway | parliament | 1900-07-01 | 3.0 | 0 | 114 | DNA | Det norske Arbeiderparti | Norwegian Labour Party | 3.3706 | 9 | 943 | 104 | ||
NZL | New Zealand | parliament | 1902-11-25 | 51.77 | 47 | 80 | NZLP | New Zealand Liberal Party | New Zealand Liberal Party | 6.0 | 11 | 974 | 2469 | ||
NZL | New Zealand | parliament | 1902-11-25 | 20.57 | 19 | 80 | RP | Reform Party | Reform Party | 7.4 | 11 | 974 | 2471 | ||
NZL | New Zealand | parliament | 1902-11-25 | 10 | 80 | none | no party affiliation | no party affiliation | 11 | 974 | 1262 | ||||
NZL | New Zealand | parliament | 1902-11-25 | 4 | 80 | etc | others | others | 11 | 974 | 1365 | ||||
POL | Poland | parliament | 1989-06-18 | 173 | 460 | PZPR | Polska Zjednoczone Partia Robotnicza | Polish United Workers' Party | 1.3 | 74 | 158 | 1077 | |||
POL | Poland | parliament | 1989-06-18 | 161 | 460 | S | Solidarność | Solidarnosc | 3.3 | 74 | 158 | 108 | |||
POL | Poland | parliament | 1989-06-18 | 76 | 460 | ZSL | Zjednoczone Stronnictwo Ludowe | United People's Party | 5.3 | 74 | 158 | 822 | |||
POL | Poland | parliament | 1989-06-18 | 27 | 460 | SD | Stronnictwo Demokratyczne | Democratic Party | 1.3 | 74 | 158 | 1216 | |||
POL | Poland | parliament | 1989-06-18 | 23 | 460 | none | no party affiliation | no party affiliation | 74 | 158 | 1011 | ||||
PRT | Portugal | parliament | 1975-04-25 | 40.7 | 116 | 250 | PS | Partido Socialista | Socialist Party | 4.0492 | 63 | 247 | 725 | ||
PRT | Portugal | parliament | 1975-04-25 | 28.36 | 81 | 250 | PSD | Partido Social Democrata | Social Democratic Party | 6.2949 | 63 | 247 | 1273 | ||
PRT | Portugal | parliament | 1975-04-25 | 13.39 | 30 | 250 | PCP | Partido Comunista Português | Portuguese Communist Party | 2.1754 | 63 | 247 | 514 | ||
PRT | Portugal | parliament | 1975-04-25 | 8.18 | 16 | 250 | CDS-PP | Centro Democrático e Social – Partido Popular | Democratic and Social Centre -- People's Party | 8.0222 | 63 | 247 | 251 | ||
PRT | Portugal | parliament | 1975-04-25 | 4.45 | 5 | 250 | MDP | Movimento Democrático Português | Democratic Movement | 3.3 | 63 | 247 | 1281 | ||
PRT | Portugal | parliament | 1975-04-25 | 0.84 | 1 | 250 | UDP | União Democrática Popular | Popular Democratic Union | 1.3 | 63 | 247 | 260 | ||
PRT | Portugal | parliament | 1975-04-25 | 1 | 250 | one-seat | one seat | one seat | 63 | 247 | 2291 | ||||
PRT | Portugal | parliament | 1975-04-25 | 1.25 | 0 | 250 | FSP | Frente Socialista Popular | People's Socialist Front | 1.3 | 63 | 247 | 601 | ||
PRT | Portugal | parliament | 1975-04-25 | 1.1 | 0 | 250 | MES | Movimento de Esquerda Socialista | Movement of Socialist Left | 1.3 | 63 | 247 | 1508 | ||
SVK | Slovakia | parliament | 1990-06-09 | 29.35 | 48 | 150 | VPN | Verejnosť proti násiliu | Public against Violence | 6.0 | 1 | 538 | 1061 | ||
SVK | Slovakia | parliament | 1990-06-09 | 19.21 | 31 | 150 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 538 | 1432 | ||
SVK | Slovakia | parliament | 1990-06-09 | 13.35 | 22 | 150 | SDL | Strana demokratickej ľavice | Party of the Democratic Left | 3.2398 | 1 | 538 | 1415 | ||
SVK | Slovakia | parliament | 1990-06-09 | 13.94 | 22 | 150 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 538 | 1072 | ||
SVK | Slovakia | parliament | 1990-06-09 | 8.66 | 14 | 150 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 538 | 559 | ||
SVK | Slovakia | parliament | 1990-06-09 | 4.4 | 7 | 150 | DS | Demokratická strana | Democratic Party | 6.2 | 1 | 538 | 1000 | ||
SVK | Slovakia | parliament | 1990-06-09 | 3.49 | 6 | 150 | SZS | Strana zelených | Green Party | 2.5 | 1 | 538 | 874 | ||
SVK | Slovakia | parliament | 1990-06-09 | 1.78 | 0 | 150 | SSL | Strana slobody | Freedom Party | 6.0 | 1 | 538 | 2232 | ||
SVK | Slovakia | parliament | 1990-06-09 | 2.52 | 0 | 150 | SPV | Spojenestvo poľnohospodárov a vidieka | Alliance of Farmers and the Countryside | 5.3 | 1 | 538 | 2233 | ||
SVK | Slovakia | parliament | 1990-06-09 | 1.82 | 0 | 150 | SDSS | Sociálnodemokratická strana Slovenska | Social Democratic Party of Slovakia | 4.8111 | 1 | 538 | 1651 | ||
SVN | Slovenia | parliament | 1990-04-12 | 17.3 | 14 | 80 | ZL-SD | Združena lista – Socialni demokrati | United List -- Social Democrats | 3.0637 | 60 | 129 | 706 | ||
SVN | Slovenia | parliament | 1990-04-12 | 14.5 | 12 | 80 | LDS | Liberalna demokracija Slovenije | Liberal Democracy of Slovenia | 3.7351 | 60 | 129 | 1252 | ||
SVN | Slovenia | parliament | 1990-04-12 | 12.6 | 11 | 80 | SLS | Slovenska ljudska stranka | Slovenian People's Party | 6.6953 | 60 | 129 | 16 | ||
SVN | Slovenia | parliament | 1990-04-12 | 13.0 | 11 | 80 | NSI | Nova Slovenija – Krščanska ljudska stranka | New Slovenia -- Christian People's Party | 7.9345 | 60 | 129 | 1047 | ||
SVN | Slovenia | parliament | 1990-04-12 | 9.5 | 8 | 80 | SDZ | Slovenska demokratična zveza | Slovenian Democratic Union | 6.0 | 60 | 129 | 1371 | ||
SVN | Slovenia | parliament | 1990-04-12 | 8.8 | 8 | 80 | ZS | Zeleni Slovenije | Greens of Slovenia | 2.5 | 60 | 129 | 1619 | ||
SVN | Slovenia | parliament | 1990-04-12 | 7.4 | 6 | 80 | SDS | Slovenska demokratska stranka | Slovenian Democratic Party | 6.9996 | 60 | 129 | 179 | ||
SVN | Slovenia | parliament | 1990-04-12 | 5.4 | 5 | 80 | SSS | Socialistična stranka Slovenije | Socialist Party of Slovenia | 1.3 | 60 | 129 | 317 | ||
SVN | Slovenia | parliament | 1990-04-12 | 3.5 | 3 | 80 | SOS | Slovenska obrtniöka stranka | Slovenian Liberal Party | 6.0 | 60 | 129 | 875 | ||
SVN | Slovenia | parliament | 1990-04-12 | 1 | 80 | Mad | Madžarska narodna skupnost | Hungarian national community | 60 | 129 | 65 | ||||
SVN | Slovenia | parliament | 1990-04-12 | 1 | 80 | Ita | Italijanska narodna skupnost | Italian national community | 60 | 129 | 199 | ||||
SVN | Slovenia | parliament | 1990-04-12 | 1.6 | 0 | 80 | SOPS | Slovenska obrtno podjetniška stranka | Slovenian Craftsmen and Entreprenerial Party | 6.0 | 60 | 129 | 2275 | ||
SVN | Slovenia | parliament | 1990-04-12 | 2.0 | 0 | 80 | DZL | Driavljanska zelena lista | Civic Green List | 2.5 | 60 | 129 | 2570 | ||
SVN | Slovenia | parliament | 1990-04-12 | 2.5 | 0 | 80 | ZEO | Zveza za enakopravnost obCanov | League for Citizens' Equality | 3.3 | 60 | 129 | 2571 | ||
SWE | Sweden | parliament | 1911-09-24 | 40.2 | 102 | 230 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 961 | 892 | ||
SWE | Sweden | parliament | 1911-09-24 | 31.2 | 64 | 230 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 961 | 657 | ||
SWE | Sweden | parliament | 1911-09-24 | 28.5 | 64 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 961 | 904 | ||
TUR | Turkey | parliament | 1983-11-06 | 45.14 | 211 | 399 | ANAP | Anavatan Partisi | Motherland Party | 6.213 | 20 | 813 | 1334 | ||
TUR | Turkey | parliament | 1983-11-06 | 30.46 | 117 | 399 | SHP|CHP | Sosyal Demokrat Halçi Parti | Cumhuriyet Halk Partisi | Social Democratic Populist Party | Republican People's Party | 3.2661 | 20 | 813 | 507 | ||
TUR | Turkey | parliament | 1983-11-06 | 23.2658 | 71 | 399 | MDP | Milliyetçi Demokrasi Partisi | Nationalist Democratic Party | 8.8 | 20 | 813 | 110 | ||
LVA | Latvia | parliament | 1998-10-03 | 21.19 | 24 | 100 | TP | Tautas Partija | People's Party | 7.7544 | 55 | 615 | 534 | 2 | 811 |
LVA | Latvia | parliament | 1998-10-03 | 18.05 | 21 | 100 | LC | Latvijas Ceļš | Latvian Way | 6.125 | 55 | 615 | 534 | 2 | 526 |
LVA | Latvia | parliament | 1998-10-03 | 14.65 | 17 | 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 | 615 | 534 | 2 | 521 |
LVA | Latvia | parliament | 1998-10-03 | 14.12 | 16 | 100 | TSP | Tautas Saskaņas Partija | National Harmony Party | 1.864 | 55 | 615 | 534 | 2 | 32 |
LVA | Latvia | parliament | 1998-10-03 | 12.81 | 14 | 100 | LSDSP | Latvijas Sociāldemokrātiskā Strādnieku Partija | Latvian Social Democratic Workers' Party | 2.5 | 55 | 615 | 534 | 2 | 1656 |
LVA | Latvia | parliament | 1998-10-03 | 7.31 | 8 | 100 | JP | Jaunā partija | New Era Party | 7.4 | 55 | 615 | 534 | 2 | 550 |
LVA | Latvia | parliament | 1998-10-03 | 2.29 | 0 | 100 | LZP | Latvijas Zaļā partija | Latvian Green Party | 4.6711 | 55 | 615 | 534 | 2 | 1001 |
LVA | Latvia | parliament | 1998-10-03 | 2.47 | 0 | 100 | LZS | Latvijas Zemnieku Savienība | Farmers Union of Latvia | 4.375 | 55 | 615 | 534 | 2 | 1368 |
LVA | Latvia | parliament | 1998-10-03 | 1.6 | 0 | 100 | DPS | Demokrātiskā partija "Saimnieks" | Democratic Party Saimnieks | 6.0 | 55 | 615 | 534 | 2 | 759 |
LVA | Latvia | parliament | 1998-10-03 | 1.73 | 0 | 100 | TKL-ZP | Tautas Kustība Latvijai – Zīgerista Partija | People's Movement for Latvia -- Siegerist Party | 8.8 | 55 | 615 | 534 | 2 | 267 |
MLT | Malta | parliament | 1992-02-22 | 51.77 | 34 | 65 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 520 | 370 | 3 | 984 |
MLT | Malta | parliament | 1992-02-22 | 46.5 | 31 | 65 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 520 | 370 | 3 | 1003 |
MLT | Malta | parliament | 1992-02-22 | 1.69 | 0 | 65 | AD | Alternattiva Demokratika | Democratic Alternative | 3.7895 | 72 | 520 | 370 | 3 | 360 |
EST | Estonia | parliament | 1995-03-05 | 32.23 | 41 | 101 | EKK | Eesti Koonderakond | Estonian Coalition Party | 7.2222 | 75 | 600 | 670 | 4 | 486 |
EST | Estonia | parliament | 1995-03-05 | 16.19 | 19 | 101 | ERe | Eesti Reformierakond | Estonian Reform Party | 7.8969 | 75 | 600 | 670 | 4 | 113 |
EST | Estonia | parliament | 1995-03-05 | 14.17 | 16 | 101 | EK | Eesti Keskerakond | Estonian Centre Party | 3.9562 | 75 | 600 | 670 | 4 | 1137 |
EST | Estonia | parliament | 1995-03-05 | 7.86 | 8 | 101 | RKI | Rahvuslik Koonderakond "Isamaa" | National Coalition Party "Pro Patria" | 7.4 | 75 | 600 | 670 | 4 | 243 |
EST | Estonia | parliament | 1995-03-05 | 5.87 | 6 | 101 | K-EUR | Konstitutsioonierakond – Eestimaa Ühendatud Rahvapartei | Constitution Party -- Estonian United People's Party | 2.0282 | 75 | 600 | 670 | 4 | 1590 |
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;