view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by election_date
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | |||
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 | |||
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 | ||
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 | ||
BEL | Belgium | parliament | 1902-05-25 | 56.0 | 54 | 85 | KP-PC | Katholieke Partij – Parti catholique | Catholic Party | 6.2 | 64 | 869 | 868 | 1374 | 2423 |
BEL | Belgium | parliament | 1902-05-25 | 25.1 | 20 | 85 | LP-PL | Liberale Partij – Parti libéral | Liberal Party | 6.0 | 64 | 869 | 868 | 1374 | 63 |
BEL | Belgium | parliament | 1902-05-25 | 15.0 | 10 | 85 | BWP-POB | Belgische Werkliedenpartij – Parti Ouvrier Belge | Belgian Labour Party | 3.3 | 64 | 869 | 868 | 1374 | 2422 |
BEL | Belgium | parliament | 1902-05-25 | 2.5 | 1 | 85 | CV | Christene Volkspartij | Christian Peoples' Party [Daens] | 6.2 | 64 | 869 | 868 | 1374 | 2481 |
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 | ||
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 | ||||
DNK | Denmark | parliament | 1903-06-16 | 47.14 | 73 | 114 | V | Venstre | Liberal Party | 7.292 | 21 | 887 | 886 | 1365 | 1605 |
DNK | Denmark | parliament | 1903-06-16 | 20.07 | 16 | 114 | Sd | Socialdemokraterne | Social Democrats | 3.8011 | 21 | 887 | 886 | 1365 | 1629 |
DNK | Denmark | parliament | 1903-06-16 | 20.49 | 12 | 114 | KF | Konservative | Conservatives | 7.2186 | 21 | 887 | 886 | 1365 | 590 |
DNK | Denmark | parliament | 1903-06-16 | 7.99 | 12 | 114 | MV | Moderate Venstre | Moderate Liberals | 6.0 | 21 | 887 | 886 | 1365 | 2430 |
DNK | Denmark | parliament | 1903-06-16 | 1 | 114 | none | ingen | no party affiliation | 21 | 887 | 886 | 1365 | 1128 | ||
NOR | Norway | parliament | 1903-09-16 | 44.8 | 52 | 117 | H | Høyre | Conservative Party | 7.8994 | 9 | 944 | 943 | 1378 | 1435 |
NOR | Norway | parliament | 1903-09-16 | 42.7 | 48 | 117 | V | Venstre | Liberal Party of Norway | 5.1467 | 9 | 944 | 943 | 1378 | 647 |
NOR | Norway | parliament | 1903-09-16 | 10 | 117 | MV | Moderate Venstre | Moderate Liberal Party | 6.0 | 9 | 944 | 943 | 1378 | 2473 | |
NOR | Norway | parliament | 1903-09-16 | 9.7 | 5 | 117 | DNA | Det norske Arbeiderparti | Norwegian Labour Party | 3.3706 | 9 | 944 | 943 | 1378 | 104 |
NOR | Norway | parliament | 1903-09-16 | 2 | 117 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 944 | 943 | 1378 | 2415 | |
AUS | Australia | parliament | 1903-12-16 | 29.7 | 26 | 75 | PP | Protectionist Party | Protectionist Party | 7.4 | 33 | 730 | 731 | 997 | 1898 |
AUS | Australia | parliament | 1903-12-16 | 34.4 | 25 | 75 | FTP | Free Trade Party | Free Trade Party | 6.0 | 33 | 730 | 731 | 997 | 1938 |
AUS | Australia | parliament | 1903-12-16 | 31.0 | 23 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 730 | 731 | 997 | 1253 |
AUS | Australia | parliament | 1903-12-16 | 0.5 | 1 | 75 | one-seat | one seat | one seat | 33 | 730 | 731 | 997 | 2299 | |
AUS | Australia | parliament | 1903-12-16 | 4.5 | 0 | 75 | none | no party affiliation | no party affiliation | 33 | 730 | 731 | 997 | 1396 | |
BEL | Belgium | parliament | 1904-05-29 | 43.5 | 38 | 81 | KP-PC | Katholieke Partij – Parti catholique | Catholic Party | 6.2 | 64 | 870 | 869 | 1376 | 2423 |
BEL | Belgium | parliament | 1904-05-29 | 25.4 | 22 | 81 | LP-PL | Liberale Partij – Parti libéral | Liberal Party | 6.0 | 64 | 870 | 869 | 1376 | 63 |
BEL | Belgium | parliament | 1904-05-29 | 25.98 | 19 | 81 | BWP-POB | Belgische Werkliedenpartij – Parti Ouvrier Belge | Belgian Labour Party | 3.3 | 64 | 870 | 869 | 1376 | 2422 |
BEL | Belgium | parliament | 1904-05-29 | 2.9 | 1 | 81 | one-seat | one seat | one seat | 64 | 870 | 869 | 1376 | 2300 | |
BEL | Belgium | parliament | 1904-05-29 | 1.8 | 1 | 81 | CV | Christene Volkspartij | Christian Peoples' Party [Daens] | 6.2 | 64 | 870 | 869 | 1376 | 2481 |
CAN | Canada | parliament | 1904-11-03 | 52.03 | 138 | 214 | LP | Liberal Party of Canada | Liberal Party of Canada | 5.0552 | 29 | 884 | 883 | 1466 | 368 |
CAN | Canada | parliament | 1904-11-03 | 46.44 | 75 | 214 | PCP | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | 6.7112 | 29 | 884 | 883 | 1466 | 794 |
CAN | Canada | parliament | 1904-11-03 | 0.34 | 1 | 214 | none | no party affiliation | no party affiliation | 29 | 884 | 883 | 1466 | 1189 | |
CHE | Switzerland | parliament | 1905-10-29 | 49.25 | 104 | 167 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 981 | 982 | 1456 | 26 |
CHE | Switzerland | parliament | 1905-10-29 | 22.51 | 36 | 167 | KK/CVP | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien | Catholic Conservative / Christian Democratic Peoples Party | 4.7288 | 40 | 981 | 982 | 1456 | 531 |
CHE | Switzerland | parliament | 1905-10-29 | 6.72 | 19 | 167 | LPS | Liberale Partei der Schweiz – Parti liberal suisse | Liberal Party of Switzerland | 7.2961 | 40 | 981 | 982 | 1456 | 458 |
CHE | Switzerland | parliament | 1905-10-29 | 4.38 | 6 | 167 | DG | Gruppe der Demokraten – Groupe des democrates | Democratic Group | 3.3 | 40 | 981 | 982 | 1456 | 886 |
CHE | Switzerland | parliament | 1905-10-29 | 14.66 | 2 | 167 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 981 | 982 | 1456 | 35 |
NZL | New Zealand | parliament | 1905-12-06 | 53.12 | 58 | 80 | NZLP | New Zealand Liberal Party | New Zealand Liberal Party | 6.0 | 11 | 973 | 974 | 1325 | 2469 |
NZL | New Zealand | parliament | 1905-12-06 | 29.67 | 16 | 80 | RP | Reform Party | Reform Party | 7.4 | 11 | 973 | 974 | 1325 | 2471 |
NZL | New Zealand | parliament | 1905-12-06 | 6 | 80 | none | no party affiliation | no party affiliation | 11 | 973 | 974 | 1325 | 1262 | ||
NZL | New Zealand | parliament | 1905-12-06 | 0.89 | 0 | 80 | LP | Labour Party | Labour Party | 4.483 | 11 | 973 | 974 | 1325 | 878 |
FRA | France | parliament | 1906-05-20 | 28.53 | 239 | 575 | PR | Parti radical-socialiste | Radical Socialist Party | 3.9896 | 43 | 986 | 987 | 1409 | 401 |
FRA | France | parliament | 1906-05-20 | 29.18 | 107 | 575 | C | Conservateurs | Conservatives | 7.4 | 43 | 986 | 987 | 1409 | 2589 |
FRA | France | parliament | 1906-05-20 | 14.06 | 67 | 575 | RP | Républicains progressistes | Progressive Republicans | 7.4 | 43 | 986 | 987 | 1409 | 2586 |
FRA | France | parliament | 1906-05-20 | 9.95 | 53 | 575 | PS | Parti socialiste | Socialist Party | 3.2493 | 43 | 986 | 987 | 1409 | 1539 |
FRA | France | parliament | 1906-05-20 | 7.99 | 52 | 575 | RepG | Républicaine gauche | Left Republican | 6.0 | 43 | 986 | 987 | 1409 | 2587 |
FRA | France | parliament | 1906-05-20 | 7.85 | 39 | 575 | RI | Radicaux indépendants | Independent Radicals | 7.4 | 43 | 986 | 987 | 1409 | 2585 |
FRA | France | parliament | 1906-05-20 | 2.33 | 18 | 575 | SI | Socialistes indépendants | Independent Socialists | 1.3 | 43 | 986 | 987 | 1409 | 2590 |
BEL | Belgium | parliament | 1906-05-27 | 54.3 | 50 | 85 | KP-PC | Katholieke Partij – Parti catholique | Catholic Party | 6.2 | 64 | 871 | 870 | 1376 | 2423 |
BEL | Belgium | parliament | 1906-05-27 | 17.7 | 15 | 85 | LP-PL | Liberale Partij – Parti libéral | Liberal Party | 6.0 | 64 | 871 | 870 | 1376 | 63 |
BEL | Belgium | parliament | 1906-05-27 | 19.1 | 14 | 85 | KLS | Kartel Liberale en Socialistische | Cartel of Liberals and Socialists | 3.3 | 64 | 871 | 870 | 1376 | 1335 |
BEL | Belgium | parliament | 1906-05-27 | 6.2 | 6 | 85 | BWP-POB | Belgische Werkliedenpartij – Parti Ouvrier Belge | Belgian Labour Party | 3.3 | 64 | 871 | 870 | 1376 | 2422 |
BEL | Belgium | parliament | 1906-05-27 | 1.0 | 0 | 85 | CV | Christene Volkspartij | Christian Peoples' Party [Daens] | 6.2 | 64 | 871 | 870 | 1376 | 2481 |
DNK | Denmark | parliament | 1906-05-29 | 31.2 | 56 | 114 | V | Venstre | Liberal Party | 7.292 | 21 | 888 | 887 | 1364 | 1605 |
DNK | Denmark | parliament | 1906-05-29 | 25.4 | 24 | 114 | Sd | Socialdemokraterne | Social Democrats | 3.8011 | 21 | 888 | 887 | 1364 | 1629 |
DNK | Denmark | parliament | 1906-05-29 | 21.0 | 12 | 114 | KF | Konservative | Conservatives | 7.2186 | 21 | 888 | 887 | 1364 | 590 |
DNK | Denmark | parliament | 1906-05-29 | 12.6 | 9 | 114 | RV | Det Radikale Venstre | Danish Social Liberal Party | 4.8736 | 21 | 888 | 887 | 1364 | 211 |
DNK | Denmark | parliament | 1906-05-29 | 6.8 | 9 | 114 | MV | Moderate Venstre | Moderate Liberals | 6.0 | 21 | 888 | 887 | 1364 | 2430 |
DNK | Denmark | parliament | 1906-05-29 | 3.0 | 4 | 114 | none | ingen | no party affiliation | 21 | 888 | 887 | 1364 | 1128 | |
NOR | Norway | parliament | 1906-08-27 | 45.1 | 73 | 123 | V | Venstre | Liberal Party of Norway | 5.1467 | 9 | 945 | 944 | 1380 | 647 |
NOR | Norway | parliament | 1906-08-27 | 32.8 | 36 | 123 | H | Høyre | Conservative Party | 7.8994 | 9 | 945 | 944 | 1380 | 1435 |
NOR | Norway | parliament | 1906-08-27 | 16.0 | 10 | 123 | DNA | Det norske Arbeiderparti | Norwegian Labour Party | 3.3706 | 9 | 945 | 944 | 1380 | 104 |
NOR | Norway | parliament | 1906-08-27 | 4.8 | 4 | 123 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 945 | 944 | 1380 | 2415 |
AUS | Australia | parliament | 1906-12-02 | 38.2 | 27 | 75 | FTP | Free Trade Party | Free Trade Party | 6.0 | 33 | 725 | 730 | 1000 | 1938 |
AUS | Australia | parliament | 1906-12-02 | 36.6 | 26 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 725 | 730 | 1000 | 1253 |
AUS | Australia | parliament | 1906-12-02 | 16.4 | 16 | 75 | PP | Protectionist Party | Protectionist Party | 7.4 | 33 | 725 | 730 | 1000 | 1898 |
AUS | Australia | parliament | 1906-12-02 | 4.8 | 4 | 75 | IPP-V | Independent Protectionist Party (Vic) | Independent Protectionist Party (Vic) | 7.4 | 33 | 725 | 730 | 1000 | 1917 |
AUS | Australia | parliament | 1906-12-02 | 2.3 | 2 | 75 | WAP | Western Australian Party | Western Australian Party | 6.0 | 33 | 725 | 730 | 1000 | 1906 |
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;