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 | 1914-05-24 | 42.8 | 41 | 88 | KP-PC | Katholieke Partij – Parti catholique | Catholic Party | 6.2 | 64 | 875 | 874 | 1284 | 2423 |
BEL | Belgium | parliament | 1914-05-24 | 30.3 | 26 | 88 | BWP-POB | Belgische Werkliedenpartij – Parti Ouvrier Belge | Belgian Labour Party | 3.3 | 64 | 875 | 874 | 1284 | 2422 |
BEL | Belgium | parliament | 1914-05-24 | 24.5 | 20 | 88 | LP-PL | Liberale Partij – Parti libéral | Liberal Party | 6.0 | 64 | 875 | 874 | 1284 | 63 |
BEL | Belgium | parliament | 1914-05-24 | 1.7 | 1 | 88 | CV | Christene Volkspartij | Christian Peoples' Party [Daens] | 6.2 | 64 | 875 | 874 | 1284 | 2481 |
AUS | Australia | parliament | 1914-09-05 | 50.9 | 42 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 724 | 748 | 1004 | 1253 |
AUS | Australia | parliament | 1914-09-05 | 47.2 | 32 | 75 | CLP | Commonwealth Liberal Party | Commonwealth Liberal Party | 7.4 | 33 | 724 | 748 | 1004 | 2285 |
AUS | Australia | parliament | 1914-09-05 | 1.9 | 1 | 75 | none | no party affiliation | no party affiliation | 33 | 724 | 748 | 1004 | 1396 | |
SWE | Sweden | parliament | 1914-09-13 | 36.4 | 87 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 963 | 962 | 1369 | 904 |
SWE | Sweden | parliament | 1914-09-13 | 36.5 | 86 | 230 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 963 | 962 | 1369 | 657 |
SWE | Sweden | parliament | 1914-09-13 | 26.9 | 57 | 230 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 963 | 962 | 1369 | 892 |
SWE | Sweden | parliament | 1914-09-13 | 0.2 | 0 | 230 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 963 | 962 | 1369 | 1461 |
CHE | Switzerland | parliament | 1914-10-25 | 56.15 | 112 | 189 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 978 | 979 | 1459 | 26 |
CHE | Switzerland | parliament | 1914-10-25 | 21.06 | 37 | 189 | KK/CVP | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien | Catholic Conservative / Christian Democratic Peoples Party | 4.7288 | 40 | 978 | 979 | 1459 | 531 |
CHE | Switzerland | parliament | 1914-10-25 | 10.05 | 19 | 189 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 978 | 979 | 1459 | 35 |
CHE | Switzerland | parliament | 1914-10-25 | 7.39 | 15 | 189 | LPS | Liberale Partei der Schweiz – Parti liberal suisse | Liberal Party of Switzerland | 7.2961 | 40 | 978 | 979 | 1459 | 458 |
CHE | Switzerland | parliament | 1914-10-25 | 2.67 | 4 | 189 | DG | Gruppe der Demokraten – Groupe des democrates | Democratic Group | 3.3 | 40 | 978 | 979 | 1459 | 886 |
CHE | Switzerland | parliament | 1914-10-25 | 2 | 189 | etc | others | others | 40 | 978 | 979 | 1459 | 2579 | ||
NZL | New Zealand | parliament | 1914-12-11 | 45.47 | 40 | 80 | RP | Reform Party | Reform Party | 7.4 | 11 | 953 | 952 | 1320 | 2471 |
NZL | New Zealand | parliament | 1914-12-11 | 42.61 | 34 | 80 | NZLP | New Zealand Liberal Party | New Zealand Liberal Party | 6.0 | 11 | 953 | 952 | 1320 | 2469 |
NZL | New Zealand | parliament | 1914-12-11 | 4.24 | 3 | 80 | LP | Labour Party | Labour Party | 4.483 | 11 | 953 | 952 | 1320 | 878 |
NZL | New Zealand | parliament | 1914-12-11 | 4.21 | 2 | 80 | SDP | Social Democratic Party | Social Democratic Party | 3.3 | 11 | 953 | 952 | 1320 | 2549 |
NZL | New Zealand | parliament | 1914-12-11 | 3.47 | 1 | 80 | none | no party affiliation | no party affiliation | 11 | 953 | 952 | 1320 | 1262 | |
DNK | Denmark | parliament | 1915-05-07 | 43 | 114 | V | Venstre | Liberal Party | 7.292 | 21 | 999 | 891 | 1253 | 1605 | |
DNK | Denmark | parliament | 1915-05-07 | 32 | 114 | Sd | Socialdemokraterne | Social Democrats | 3.8011 | 21 | 999 | 891 | 1253 | 1629 | |
DNK | Denmark | parliament | 1915-05-07 | 31 | 114 | RV | Det Radikale Venstre | Danish Social Liberal Party | 4.8736 | 21 | 999 | 891 | 1253 | 211 | |
DNK | Denmark | parliament | 1915-05-07 | 7 | 114 | KF | Konservative | Conservatives | 7.2186 | 21 | 999 | 891 | 1253 | 590 | |
DNK | Denmark | parliament | 1915-05-07 | 1 | 114 | none | ingen | no party affiliation | 21 | 999 | 891 | 1253 | 1128 | ||
NOR | Norway | parliament | 1915-10-21 | 33.1 | 74 | 123 | V | Venstre | Liberal Party of Norway | 5.1467 | 9 | 948 | 947 | 1240 | 647 |
NOR | Norway | parliament | 1915-10-21 | 29.0 | 20 | 123 | H | Høyre | Conservative Party | 7.8994 | 9 | 948 | 947 | 1240 | 1435 |
NOR | Norway | parliament | 1915-10-21 | 32.1 | 19 | 123 | DNA | Det norske Arbeiderparti | Norwegian Labour Party | 3.3706 | 9 | 948 | 947 | 1240 | 104 |
NOR | Norway | parliament | 1915-10-21 | 4.2 | 6 | 123 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 948 | 947 | 1240 | 2415 |
NOR | Norway | parliament | 1915-10-21 | 2 | 123 | none | no party affiliation | no party affiliation | 9 | 948 | 947 | 1240 | 793 | ||
NOR | Norway | parliament | 1915-10-21 | 1.0 | 1 | 123 | Sp | Senterpartiet | Centre Party | 4.6565 | 9 | 948 | 947 | 1240 | 702 |
NOR | Norway | parliament | 1915-10-21 | 1 | 123 | FV | Frisinnede Venstre | Liberal Left Party | 6.0 | 9 | 948 | 947 | 1240 | 2472 | |
NOR | Norway | parliament | 1915-10-21 | 0.1 | 0 | 123 | A | Avholdspartiet | Teetotaler Party | 9 | 948 | 947 | 1240 | 2544 | |
AUS | Australia | parliament | 1917-05-05 | 54.2 | 53 | 75 | NAT | Nationalist Party of Australia | Nationalist Party of Australia | 8.8 | 33 | 750 | 724 | 1008 | 1905 |
AUS | Australia | parliament | 1917-05-05 | 43.9 | 22 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 750 | 724 | 1008 | 1253 |
AUS | Australia | parliament | 1917-05-05 | 1.8 | 0 | 75 | none | no party affiliation | no party affiliation | 33 | 750 | 724 | 1008 | 1396 | |
SWE | Sweden | parliament | 1917-09-16 | 31.1 | 86 | 217 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 964 | 963 | 1368 | 904 |
SWE | Sweden | parliament | 1917-09-16 | 27.6 | 62 | 217 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 964 | 963 | 1368 | 892 |
SWE | Sweden | parliament | 1917-09-16 | 24.7 | 57 | 217 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 964 | 963 | 1368 | 657 |
SWE | Sweden | parliament | 1917-09-16 | 5.3 | 9 | 217 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 964 | 963 | 1368 | 1461 |
SWE | Sweden | parliament | 1917-09-16 | 3.1 | 3 | 217 | JR | Jordbrukarnas Riksförbund | National Farmers' Union | 5.3 | 35 | 964 | 963 | 1368 | 2556 |
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 | ||
CHE | Switzerland | parliament | 1917-10-28 | 40.84 | 103 | 189 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 977 | 978 | 1463 | 26 |
CHE | Switzerland | parliament | 1917-10-28 | 16.46 | 42 | 189 | KK/CVP | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien | Catholic Conservative / Christian Democratic Peoples Party | 4.7288 | 40 | 977 | 978 | 1463 | 531 |
CHE | Switzerland | parliament | 1917-10-28 | 30.77 | 20 | 189 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 977 | 978 | 1463 | 35 |
CHE | Switzerland | parliament | 1917-10-28 | 4.89 | 12 | 189 | LPS | Liberale Partei der Schweiz – Parti liberal suisse | Liberal Party of Switzerland | 7.2961 | 40 | 977 | 978 | 1463 | 458 |
CHE | Switzerland | parliament | 1917-10-28 | 3.27 | 7 | 189 | DG | Gruppe der Demokraten – Groupe des democrates | Democratic Group | 3.3 | 40 | 977 | 978 | 1463 | 886 |
CHE | Switzerland | parliament | 1917-10-28 | 5 | 189 | etc | others | others | 40 | 977 | 978 | 1463 | 2579 | ||
CAN | Canada | parliament | 1917-12-17 | 57.0 | 153 | 235 | PCP | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | 6.7112 | 29 | 862 | 863 | 1170 | 794 |
CAN | Canada | parliament | 1917-12-17 | 39.86 | 82 | 235 | LP | Liberal Party of Canada | Liberal Party of Canada | 5.0552 | 29 | 862 | 863 | 1170 | 368 |
CAN | Canada | parliament | 1917-12-17 | 0.77 | 0 | 235 | none | no party affiliation | no party affiliation | 29 | 862 | 863 | 1170 | 1189 | |
DNK | Denmark | parliament | 1918-04-22 | 29.4 | 45 | 139 | V | Venstre | Liberal Party | 7.292 | 21 | 892 | 999 | 1252 | 1605 |
DNK | Denmark | parliament | 1918-04-22 | 28.7 | 39 | 139 | Sd | Socialdemokraterne | Social Democrats | 3.8011 | 21 | 892 | 999 | 1252 | 1629 |
DNK | Denmark | parliament | 1918-04-22 | 20.7 | 32 | 139 | RV | Det Radikale Venstre | Danish Social Liberal Party | 4.8736 | 21 | 892 | 999 | 1252 | 211 |
DNK | Denmark | parliament | 1918-04-22 | 18.3 | 22 | 139 | KF | Konservative | Conservatives | 7.2186 | 21 | 892 | 999 | 1252 | 590 |
DNK | Denmark | parliament | 1918-04-22 | 1.3 | 1 | 139 | EP | Erhvervspartiet | Industry Party | 6.0 | 21 | 892 | 999 | 1252 | 2429 |
DNK | Denmark | parliament | 1918-04-22 | 0.5 | 0 | 139 | no-seat | no seat | no seat | 21 | 892 | 999 | 1252 | 2058 | |
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 | 1918-10-21 | 28.3 | 51 | 126 | V | Venstre | Liberal Party of Norway | 5.1467 | 9 | 949 | 948 | 1239 | 647 |
NOR | Norway | parliament | 1918-10-21 | 30.4 | 40 | 126 | H | Høyre | Conservative Party | 7.8994 | 9 | 949 | 948 | 1239 | 1435 |
NOR | Norway | parliament | 1918-10-21 | 31.6 | 18 | 126 | DNA | Det norske Arbeiderparti | Norwegian Labour Party | 3.3706 | 9 | 949 | 948 | 1239 | 104 |
NOR | Norway | parliament | 1918-10-21 | 10 | 126 | FV | Frisinnede Venstre | Liberal Left Party | 6.0 | 9 | 949 | 948 | 1239 | 2472 | |
NOR | Norway | parliament | 1918-10-21 | 4.7 | 3 | 126 | Sp | Senterpartiet | Centre Party | 4.6565 | 9 | 949 | 948 | 1239 | 702 |
NOR | Norway | parliament | 1918-10-21 | 3.3 | 3 | 126 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 949 | 948 | 1239 | 2415 |
NOR | Norway | parliament | 1918-10-21 | 1.7 | 1 | 126 | none | no party affiliation | no party affiliation | 9 | 949 | 948 | 1239 | 793 | |
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 | |||
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 |
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;