view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by election_date
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AUS | Australia | parliament | 1906-12-02 | 1.2 | 0 | 75 | none | no party affiliation | no party affiliation | 33 | 725 | 730 | 1000 | 1396 | |
BEL | Belgium | parliament | 1908-05-24 | 43.1 | 37 | 82 | KP-PC | Katholieke Partij – Parti catholique | Catholic Party | 6.2 | 64 | 872 | 871 | 1372 | 2423 |
BEL | Belgium | parliament | 1908-05-24 | 27.6 | 22 | 82 | LP-PL | Liberale Partij – Parti libéral | Liberal Party | 6.0 | 64 | 872 | 871 | 1372 | 63 |
BEL | Belgium | parliament | 1908-05-24 | 22.6 | 19 | 82 | BWP-POB | Belgische Werkliedenpartij – Parti Ouvrier Belge | Belgian Labour Party | 3.3 | 64 | 872 | 871 | 1372 | 2422 |
BEL | Belgium | parliament | 1908-05-24 | 3.3 | 3 | 82 | KLS | Kartel Liberale en Socialistische | Cartel of Liberals and Socialists | 3.3 | 64 | 872 | 871 | 1372 | 1335 |
BEL | Belgium | parliament | 1908-05-24 | 2.7 | 1 | 82 | CV | Christene Volkspartij | Christian Peoples' Party [Daens] | 6.2 | 64 | 872 | 871 | 1372 | 2481 |
CHE | Switzerland | parliament | 1908-10-25 | 50.91 | 105 | 167 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 980 | 981 | 1457 | 26 |
CHE | Switzerland | parliament | 1908-10-25 | 20.52 | 35 | 167 | KK/CVP | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien | Catholic Conservative / Christian Democratic Peoples Party | 4.7288 | 40 | 980 | 981 | 1457 | 531 |
CHE | Switzerland | parliament | 1908-10-25 | 5.93 | 15 | 167 | LPS | Liberale Partei der Schweiz – Parti liberal suisse | Liberal Party of Switzerland | 7.2961 | 40 | 980 | 981 | 1457 | 458 |
CHE | Switzerland | parliament | 1908-10-25 | 17.58 | 7 | 167 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 980 | 981 | 1457 | 35 |
CHE | Switzerland | parliament | 1908-10-25 | 3.62 | 5 | 167 | DG | Gruppe der Demokraten – Groupe des democrates | Democratic Group | 3.3 | 40 | 980 | 981 | 1457 | 886 |
CAN | Canada | parliament | 1908-10-26 | 50.45 | 135 | 221 | LP | Liberal Party of Canada | Liberal Party of Canada | 5.0552 | 29 | 885 | 884 | 1467 | 368 |
CAN | Canada | parliament | 1908-10-26 | 44.95 | 85 | 221 | PCP | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | 6.7112 | 29 | 885 | 884 | 1467 | 794 |
CAN | Canada | parliament | 1908-10-26 | 1.26 | 1 | 221 | none | no party affiliation | no party affiliation | 29 | 885 | 884 | 1467 | 1189 | |
NZL | New Zealand | parliament | 1908-12-01 | 58.67 | 50 | 80 | NZLP | New Zealand Liberal Party | New Zealand Liberal Party | 6.0 | 11 | 972 | 973 | 1309 | 2469 |
NZL | New Zealand | parliament | 1908-12-01 | 27.82 | 26 | 80 | RP | Reform Party | Reform Party | 7.4 | 11 | 972 | 973 | 1309 | 2471 |
NZL | New Zealand | parliament | 1908-12-01 | 3 | 80 | none | no party affiliation | no party affiliation | 11 | 972 | 973 | 1309 | 1262 | ||
NZL | New Zealand | parliament | 1908-12-01 | 4.1 | 1 | 80 | LP | Labour Party | Labour Party | 4.483 | 11 | 972 | 973 | 1309 | 878 |
DNK | Denmark | parliament | 1909-05-25 | 24.0 | 37 | 114 | V | Venstre | Liberal Party | 7.292 | 21 | 889 | 888 | 1363 | 1605 |
DNK | Denmark | parliament | 1909-05-25 | 28.7 | 24 | 114 | Sd | Socialdemokraterne | Social Democrats | 3.8011 | 21 | 889 | 888 | 1363 | 1629 |
DNK | Denmark | parliament | 1909-05-25 | 19.8 | 21 | 114 | KF | Konservative | Conservatives | 7.2186 | 21 | 889 | 888 | 1363 | 590 |
DNK | Denmark | parliament | 1909-05-25 | 15.5 | 15 | 114 | RV | Det Radikale Venstre | Danish Social Liberal Party | 4.8736 | 21 | 889 | 888 | 1363 | 211 |
DNK | Denmark | parliament | 1909-05-25 | 5.9 | 11 | 114 | MV | Moderate Venstre | Moderate Liberals | 6.0 | 21 | 889 | 888 | 1363 | 2430 |
DNK | Denmark | parliament | 1909-05-25 | 5.7 | 6 | 114 | none | ingen | no party affiliation | 21 | 889 | 888 | 1363 | 1128 | |
NOR | Norway | parliament | 1909-10-25 | 30.4 | 46 | 123 | V | Venstre | Liberal Party of Norway | 5.1467 | 9 | 946 | 945 | 1382 | 647 |
NOR | Norway | parliament | 1909-10-25 | 41.5 | 41 | 123 | H | Høyre | Conservative Party | 7.8994 | 9 | 946 | 945 | 1382 | 1435 |
NOR | Norway | parliament | 1909-10-25 | 23 | 123 | FV | Frisinnede Venstre | Liberal Left Party | 6.0 | 9 | 946 | 945 | 1382 | 2472 | |
NOR | Norway | parliament | 1909-10-25 | 21.6 | 11 | 123 | DNA | Det norske Arbeiderparti | Norwegian Labour Party | 3.3706 | 9 | 946 | 945 | 1382 | 104 |
NOR | Norway | parliament | 1909-10-25 | 3.7 | 2 | 123 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 946 | 945 | 1382 | 2415 |
NOR | Norway | parliament | 1909-10-25 | 1.2 | 0 | 123 | A | Avholdspartiet | Teetotaler Party | 9 | 946 | 945 | 1382 | 2544 | |
AUS | Australia | parliament | 1910-04-13 | 50.0 | 43 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 747 | 725 | 1002 | 1253 |
AUS | Australia | parliament | 1910-04-13 | 45.1 | 31 | 75 | CLP | Commonwealth Liberal Party | Commonwealth Liberal Party | 7.4 | 33 | 747 | 725 | 1002 | 2285 |
AUS | Australia | parliament | 1910-04-13 | 4.5 | 1 | 75 | none | no party affiliation | no party affiliation | 33 | 747 | 725 | 1002 | 1396 | |
AUS | Australia | parliament | 1910-04-13 | 0.4 | 0 | 75 | no-seat | no seat | no seat | 33 | 747 | 725 | 1002 | 2057 | |
FRA | France | parliament | 1910-05-08 | 20.45 | 145 | 580 | RS | Parti républicain socialiste | Republican Socialist Party | 3.3 | 43 | 988 | 986 | 1391 | 2594 |
FRA | France | parliament | 1910-05-08 | 17.43 | 137 | 580 | UR | Union républicaine | Republican Union | 8.8 | 43 | 988 | 986 | 1391 | 2581 |
FRA | France | parliament | 1910-05-08 | 11.44 | 105 | 580 | RI | Radicaux indépendants | Independent Radicals | 7.4 | 43 | 988 | 986 | 1391 | 2585 |
FRA | France | parliament | 1910-05-08 | 18.97 | 91 | 580 | C | Conservateurs | Conservatives | 7.4 | 43 | 988 | 986 | 1391 | 2589 |
FRA | France | parliament | 1910-05-08 | 13.15 | 75 | 580 | PS | Parti socialiste | Socialist Party | 3.2493 | 43 | 988 | 986 | 1391 | 1539 |
FRA | France | parliament | 1910-05-08 | 4.09 | 25 | 580 | SI | Socialistes indépendants | Independent Socialists | 1.3 | 43 | 988 | 986 | 1391 | 2590 |
FRA | France | parliament | 1910-05-08 | 2 | 580 | etc | divers | others | 43 | 988 | 986 | 1391 | 1328 | ||
FRA | France | parliament | 1910-05-08 | 12.06 | 0 | 580 | RepG | Républicaine gauche | Left Republican | 6.0 | 43 | 988 | 986 | 1391 | 2587 |
FRA | France | parliament | 1910-05-08 | 1.81 | 0 | 580 | ALP | Action libérale populaire | Liberal People's Action | 6.2 | 43 | 988 | 986 | 1391 | 2593 |
DNK | Denmark | parliament | 1910-05-20 | 34.1 | 57 | 114 | V | Venstre | Liberal Party | 7.292 | 21 | 890 | 889 | 1361 | 1605 |
DNK | Denmark | parliament | 1910-05-20 | 28.3 | 24 | 114 | Sd | Socialdemokraterne | Social Democrats | 3.8011 | 21 | 890 | 889 | 1361 | 1629 |
DNK | Denmark | parliament | 1910-05-20 | 18.6 | 20 | 114 | RV | Det Radikale Venstre | Danish Social Liberal Party | 4.8736 | 21 | 890 | 889 | 1361 | 211 |
DNK | Denmark | parliament | 1910-05-20 | 18.6 | 13 | 114 | KF | Konservative | Conservatives | 7.2186 | 21 | 890 | 889 | 1361 | 590 |
DNK | Denmark | parliament | 1910-05-20 | 0.4 | 0 | 114 | none | ingen | no party affiliation | 21 | 890 | 889 | 1361 | 1128 | |
BEL | Belgium | parliament | 1910-05-22 | 53.1 | 49 | 85 | KP-PC | Katholieke Partij – Parti catholique | Catholic Party | 6.2 | 64 | 873 | 872 | 1372 | 2423 |
BEL | Belgium | parliament | 1910-05-22 | 19.1 | 15 | 85 | KLS | Kartel Liberale en Socialistische | Cartel of Liberals and Socialists | 3.3 | 64 | 873 | 872 | 1372 | 1335 |
BEL | Belgium | parliament | 1910-05-22 | 18.6 | 15 | 85 | LP-PL | Liberale Partij – Parti libéral | Liberal Party | 6.0 | 64 | 873 | 872 | 1372 | 63 |
BEL | Belgium | parliament | 1910-05-22 | 6.7 | 6 | 85 | BWP-POB | Belgische Werkliedenpartij – Parti Ouvrier Belge | Belgian Labour Party | 3.3 | 64 | 873 | 872 | 1372 | 2422 |
BEL | Belgium | parliament | 1910-05-22 | 2.1 | 0 | 85 | CV | Christene Volkspartij | Christian Peoples' Party [Daens] | 6.2 | 64 | 873 | 872 | 1372 | 2481 |
CAN | Canada | parliament | 1911-09-21 | 50.94 | 134 | 221 | PCP | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | 6.7112 | 29 | 863 | 885 | 1468 | 794 |
CAN | Canada | parliament | 1911-09-21 | 47.69 | 82 | 221 | LP | Liberal Party of Canada | Liberal Party of Canada | 5.0552 | 29 | 863 | 885 | 1468 | 368 |
CAN | Canada | parliament | 1911-09-21 | 5 | 221 | etc | others | others | 29 | 863 | 885 | 1468 | 2577 | ||
CAN | Canada | parliament | 1911-09-21 | 0.55 | 0 | 221 | none | no party affiliation | no party affiliation | 29 | 863 | 885 | 1468 | 1189 | |
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 | ||
CHE | Switzerland | parliament | 1911-10-29 | 49.47 | 114 | 189 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 979 | 980 | 1458 | 26 |
CHE | Switzerland | parliament | 1911-10-29 | 19.14 | 38 | 189 | KK/CVP | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien | Catholic Conservative / Christian Democratic Peoples Party | 4.7288 | 40 | 979 | 980 | 1458 | 531 |
CHE | Switzerland | parliament | 1911-10-29 | 19.97 | 15 | 189 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 979 | 980 | 1458 | 35 |
CHE | Switzerland | parliament | 1911-10-29 | 6.75 | 14 | 189 | LPS | Liberale Partei der Schweiz – Parti liberal suisse | Liberal Party of Switzerland | 7.2961 | 40 | 979 | 980 | 1458 | 458 |
CHE | Switzerland | parliament | 1911-10-29 | 3.15 | 6 | 189 | DG | Gruppe der Demokraten – Groupe des democrates | Democratic Group | 3.3 | 40 | 979 | 980 | 1458 | 886 |
CHE | Switzerland | parliament | 1911-10-29 | 2 | 189 | etc | others | others | 40 | 979 | 980 | 1458 | 2579 | ||
NZL | New Zealand | parliament | 1911-12-19 | 33.37 | 37 | 80 | RP | Reform Party | Reform Party | 7.4 | 11 | 952 | 972 | 1323 | 2471 |
NZL | New Zealand | parliament | 1911-12-19 | 34.23 | 33 | 80 | NZLP | New Zealand Liberal Party | New Zealand Liberal Party | 6.0 | 11 | 952 | 972 | 1323 | 2469 |
NZL | New Zealand | parliament | 1911-12-19 | 6 | 80 | none | no party affiliation | no party affiliation | 11 | 952 | 972 | 1323 | 1262 | ||
NZL | New Zealand | parliament | 1911-12-19 | 2.62 | 4 | 80 | LP | Labour Party | Labour Party | 4.483 | 11 | 952 | 972 | 1323 | 878 |
NZL | New Zealand | parliament | 1911-12-19 | 0.45 | 0 | 80 | no-seat | no seat | no seat | 11 | 952 | 972 | 1323 | 2070 | |
BEL | Belgium | parliament | 1912-06-02 | 51.0 | 101 | 186 | KP-PC | Katholieke Partij – Parti catholique | Catholic Party | 6.2 | 64 | 874 | 873 | 1285 | 2423 |
BEL | Belgium | parliament | 1912-06-02 | 11.1 | 44 | 186 | LP-PL | Liberale Partij – Parti libéral | Liberal Party | 6.0 | 64 | 874 | 873 | 1285 | 63 |
BEL | Belgium | parliament | 1912-06-02 | 9.3 | 39 | 186 | BWP-POB | Belgische Werkliedenpartij – Parti Ouvrier Belge | Belgian Labour Party | 3.3 | 64 | 874 | 873 | 1285 | 2422 |
BEL | Belgium | parliament | 1912-06-02 | 0.7 | 2 | 186 | CV | Christene Volkspartij | Christian Peoples' Party [Daens] | 6.2 | 64 | 874 | 873 | 1285 | 2481 |
BEL | Belgium | parliament | 1912-06-02 | 27.1 | 186 | KLS | Kartel Liberale en Socialistische | Cartel of Liberals and Socialists | 3.3 | 64 | 874 | 873 | 1285 | 1335 | |
NOR | Norway | parliament | 1912-10-21 | 40.0 | 70 | 123 | V | Venstre | Liberal Party of Norway | 5.1467 | 9 | 947 | 946 | 1384 | 647 |
NOR | Norway | parliament | 1912-10-21 | 26.3 | 23 | 123 | DNA | Det norske Arbeiderparti | Norwegian Labour Party | 3.3706 | 9 | 947 | 946 | 1384 | 104 |
NOR | Norway | parliament | 1912-10-21 | 33.2 | 20 | 123 | H | Høyre | Conservative Party | 7.8994 | 9 | 947 | 946 | 1384 | 1435 |
NOR | Norway | parliament | 1912-10-21 | 6 | 123 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 947 | 946 | 1384 | 2415 | |
NOR | Norway | parliament | 1912-10-21 | 4 | 123 | FV | Frisinnede Venstre | Liberal Left Party | 6.0 | 9 | 947 | 946 | 1384 | 2472 | |
NOR | Norway | parliament | 1912-10-21 | 0.2 | 0 | 123 | no-seat | no seat | no seat | 9 | 947 | 946 | 1384 | 2100 | |
DNK | Denmark | parliament | 1913-05-20 | 28.6 | 44 | 114 | V | Venstre | Liberal Party | 7.292 | 21 | 891 | 890 | 1360 | 1605 |
DNK | Denmark | parliament | 1913-05-20 | 29.6 | 32 | 114 | Sd | Socialdemokraterne | Social Democrats | 3.8011 | 21 | 891 | 890 | 1360 | 1629 |
DNK | Denmark | parliament | 1913-05-20 | 18.7 | 31 | 114 | RV | Det Radikale Venstre | Danish Social Liberal Party | 4.8736 | 21 | 891 | 890 | 1360 | 211 |
DNK | Denmark | parliament | 1913-05-20 | 22.4 | 7 | 114 | KF | Konservative | Conservatives | 7.2186 | 21 | 891 | 890 | 1360 | 590 |
DNK | Denmark | parliament | 1913-05-20 | 0.7 | 0 | 114 | none | ingen | no party affiliation | 21 | 891 | 890 | 1360 | 1128 | |
AUS | Australia | parliament | 1913-05-31 | 48.9 | 38 | 75 | CLP | Commonwealth Liberal Party | Commonwealth Liberal Party | 7.4 | 33 | 748 | 747 | 1003 | 2285 |
AUS | Australia | parliament | 1913-05-31 | 48.5 | 37 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 748 | 747 | 1003 | 1253 |
AUS | Australia | parliament | 1913-05-31 | 2.6 | 0 | 75 | none | no party affiliation | no party affiliation | 33 | 748 | 747 | 1003 | 1396 | |
SWE | Sweden | parliament | 1914-04-07 | 37.7 | 86 | 230 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 962 | 961 | 1369 | 657 |
SWE | Sweden | parliament | 1914-04-07 | 30.1 | 73 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 962 | 961 | 1369 | 904 |
SWE | Sweden | parliament | 1914-04-07 | 32.2 | 71 | 230 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 962 | 961 | 1369 | 892 |
FRA | France | parliament | 1914-05-10 | 18.84 | 150 | 586 | UR | Union républicaine | Republican Union | 8.8 | 43 | 989 | 988 | 1398 | 2581 |
FRA | France | parliament | 1914-05-10 | 18.15 | 137 | 586 | PR | Parti radical-socialiste | Radical Socialist Party | 3.9896 | 43 | 989 | 988 | 1398 | 401 |
FRA | France | parliament | 1914-05-10 | 16.76 | 103 | 586 | PS | Parti socialiste | Socialist Party | 3.2493 | 43 | 989 | 988 | 1398 | 1539 |
FRA | France | parliament | 1914-05-10 | 16.6 | 96 | 586 | RI | Radicaux indépendants | Independent Radicals | 7.4 | 43 | 989 | 988 | 1398 | 2585 |
FRA | France | parliament | 1914-05-10 | 15.39 | 73 | 586 | C | Conservateurs | Conservatives | 7.4 | 43 | 989 | 988 | 1398 | 2589 |
FRA | France | parliament | 1914-05-10 | 3.88 | 27 | 586 | RS | Parti républicain socialiste | Republican Socialist Party | 3.3 | 43 | 989 | 988 | 1398 | 2594 |
FRA | France | parliament | 1914-05-10 | 9.72 | 0 | 586 | RepG | Républicaine gauche | Left Republican | 6.0 | 43 | 989 | 988 | 1398 | 2587 |
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;