view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by vote_share
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 | 2022-05-21 | 58 | 151 | C | Coalition | Coalition | 7.4 | 33 | 1111 | 1087 | 1616 | 1428 | |
AUT | Austria | parliament | 1920-10-17 | 7 | 183 | L | Landbund für Österreich | Rural Federation | 8.8 | 59 | 1026 | 1030 | 1537 | 2681 | |
AUT | Austria | parliament | 1920-10-17 | 0 | 183 | KB | Kärtner Bauernbund | Carinthian Farmers' Association | 5.3 | 59 | 1026 | 1030 | 1537 | 2678 | |
AUT | Austria | parliament | 1920-10-17 | 0 | 183 | DNSAP | Nationalsozialistische Arbeiterpartei | National Socialist Workers' Party | 8.8 | 59 | 1026 | 1030 | 1537 | 2684 | |
AUT | Austria | parliament | 1923-10-21 | 10 | 165 | GDVP | Großdeutsche Volkspartei | Greater German People's Party | 7.4 | 59 | 1027 | 1026 | 1542 | 2674 | |
AUT | Austria | parliament | 1923-10-21 | 5 | 165 | L | Landbund für Österreich | Rural Federation | 8.8 | 59 | 1027 | 1026 | 1542 | 2681 | |
AUT | Austria | parliament | 1927-04-24 | 12 | 165 | GDVP | Großdeutsche Volkspartei | Greater German People's Party | 7.4 | 59 | 1028 | 1027 | 1546 | 2674 | |
AUT | Austria | parliament | 1930-11-09 | 10 | 165 | GDVP | Großdeutsche Volkspartei | Greater German People's Party | 7.4 | 59 | 1029 | 1028 | 1550 | 2674 | |
AUT | Austria | parliament | 1930-11-09 | 9 | 165 | L | Landbund für Österreich | Rural Federation | 8.8 | 59 | 1029 | 1028 | 1550 | 2681 | |
AUT | Austria | ep | 1995-01-01 | 8 | 21 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 13 | 66 | 294 | 973 | |
AUT | Austria | ep | 1995-01-01 | 6 | 21 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 13 | 66 | 294 | 1013 | |
AUT | Austria | ep | 1995-01-01 | 5 | 21 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 13 | 66 | 294 | 50 | |
AUT | Austria | ep | 1995-01-01 | 1 | 21 | LIF | Liberales Forum | Liberal Forum | 4.8806 | 59 | 13 | 66 | 294 | 955 | |
AUT | Austria | ep | 1995-01-01 | 1 | 21 | Gruene | Die Grünen – Die Grüne Alternative | The Greens -- The Green Alternative | 2.4604 | 59 | 13 | 66 | 294 | 1429 | |
BEL | Belgium | parliament | 1900-05-27 | 2 | 152 | etc | others | others | 64 | 868 | 2488 | ||||
BEL | Belgium | parliament | 1965-05-23 | 2 | 212 | one-seat | one seat | one seat | 64 | 150 | 425 | 613 | 2300 | ||
BEL | Belgium | parliament | 1974-03-10 | 3 | 212 | PL(B) | Parti Libéral [Région bruxelloise] | Liberal Party [Brussels Region] | 6.0 | 64 | 384 | 591 | 859 | 640 | |
BEL | Belgium | parliament | 1977-04-17 | 2 | 212 | PL(B) | Parti Libéral [Région bruxelloise] | Liberal Party [Brussels Region] | 6.0 | 64 | 420 | 384 | 451 | 640 | |
BEL | Belgium | parliament | 1978-12-17 | 1 | 212 | PL(B) | Parti Libéral [Région bruxelloise] | Liberal Party [Brussels Region] | 6.0 | 64 | 663 | 420 | 233 | 640 | |
BGR | Bulgaria | ep | 2007-01-01 | 6 | 18 | KzB|DL | Koalitsiya za Balgariya | Demokratichna Levitsa | Coalition for Bulgaria | Democratic Left | 2.8982 | 10 | 449 | 618 | 425 | 1160 | |
BGR | Bulgaria | ep | 2007-01-01 | 4 | 18 | NDSV | Natsionalno Dvizhenie Simeon Vtori | National Movement Simeon II | 5.7567 | 10 | 449 | 618 | 425 | 544 | |
BGR | Bulgaria | ep | 2007-01-01 | 3 | 18 | DPS | Dvizhenie za Prava i Svobodi | Movement for Rights and Freedoms | 4.5828 | 10 | 449 | 618 | 425 | 1286 | |
BGR | Bulgaria | ep | 2007-01-01 | 2 | 18 | ODS | Obedineni Demokratichni Sili | United Democratic Forces | 6.9611 | 10 | 449 | 618 | 425 | 784 | |
BGR | Bulgaria | ep | 2007-01-01 | 1 | 18 | BNS | Balgarski Naroden Suyuz | Bulgarian People's Union | 5.8 | 10 | 449 | 618 | 425 | 1375 | |
BGR | Bulgaria | ep | 2007-01-01 | 1 | 18 | Ataka | Ataka | Attack | 5.46 | 10 | 449 | 618 | 425 | 535 | |
BGR | Bulgaria | ep | 2007-01-01 | 1 | 18 | DSB|DB | Demokrati za Silna Balgariya | Demokratichna Balgariya | Democrats for a Strong Bulgaria | Democratic Bulgaria | 7.85 | 10 | 449 | 618 | 425 | 57 | |
CAN | Canada | parliament | 1911-09-21 | 5 | 221 | etc | others | others | 29 | 863 | 885 | 1468 | 2577 | ||
CAN | Canada | parliament | 1921-12-06 | 1 | 235 | etc | others | others | 29 | 861 | 862 | 1169 | 2577 | ||
CAN | Canada | parliament | 1925-10-29 | 2 | 245 | etc | others | others | 29 | 860 | 861 | 1168 | 2577 | ||
CAN | Canada | parliament | 1926-09-14 | 1 | 245 | etc | others | others | 29 | 859 | 860 | 1168 | 2577 | ||
CAN | Canada | parliament | 1935-10-14 | 7 | 245 | etc | others | others | 29 | 857 | 858 | 1166 | 2577 | ||
CAN | Canada | parliament | 1940-03-26 | 5 | 245 | etc | others | others | 29 | 854 | 857 | 1165 | 2577 | ||
CAN | Canada | parliament | 1945-06-11 | 8 | 245 | none | no party affiliation | no party affiliation | 29 | 189 | 854 | 1164 | 1189 | ||
CAN | Canada | parliament | 1949-06-27 | 6 | 262 | none | no party affiliation | no party affiliation | 29 | 112 | 189 | 534 | 1189 | ||
CAN | Canada | parliament | 1953-08-10 | 4 | 265 | none | no party affiliation | no party affiliation | 29 | 292 | 112 | 750 | 1189 | ||
CAN | Canada | parliament | 1957-06-10 | 4 | 265 | none | no party affiliation | no party affiliation | 29 | 562 | 292 | 327 | 1189 | ||
CAN | Canada | parliament | 1965-11-08 | 2 | 265 | none | no party affiliation | no party affiliation | 29 | 282 | 424 | 857 | 1189 | ||
CHE | Switzerland | parliament | 1911-10-29 | 2 | 189 | etc | others | others | 40 | 979 | 980 | 1458 | 2579 | ||
CHE | Switzerland | parliament | 1914-10-25 | 2 | 189 | etc | others | others | 40 | 978 | 979 | 1459 | 2579 | ||
CHE | Switzerland | parliament | 1917-10-28 | 5 | 189 | etc | others | others | 40 | 977 | 978 | 1463 | 2579 | ||
CHE | Switzerland | parliament | 1919-10-26 | 2 | 189 | GV | Grütliverein – Grutléen | Grutli Society | 3.3 | 40 | 770 | 977 | 1464 | 1951 | |
CHE | Switzerland | parliament | 1919-10-26 | 1 | 189 | one-seat | one seat | one seat | 40 | 770 | 977 | 1464 | 2303 | ||
CHE | Switzerland | parliament | 1922-10-29 | 1 | 198 | one-seat | one seat | one seat | 40 | 773 | 770 | 981 | 2303 | ||
CHE | Switzerland | parliament | 1922-10-29 | 0 | 198 | GV | Grütliverein – Grutléen | Grutli Society | 3.3 | 40 | 773 | 770 | 981 | 1951 | |
CHE | Switzerland | parliament | 1925-10-25 | 1 | 198 | UDE | Union de défense économique | National Union | 8.8 | 40 | 774 | 773 | 980 | 1954 | |
CHE | Switzerland | parliament | 1925-10-25 | 0 | 198 | LF/PEB | Liberalsozialistische Partei / Freiwirtschaftliche Bewegung – Parti d'économie franche | Liberal Socialist Party | 6.0 | 40 | 774 | 773 | 980 | 1960 | |
CHE | Switzerland | parliament | 1928-10-28 | 1 | 198 | UDE | Union de défense économique | National Union | 8.8 | 40 | 772 | 774 | 979 | 1954 | |
CHE | Switzerland | parliament | 1931-10-25 | 1 | 187 | one-seat | one seat | one seat | 40 | 768 | 772 | 978 | 2303 | ||
CHE | Switzerland | parliament | 1935-10-27 | 4 | 187 | BHB | Bauernheimatbewegung – Jeunes paysans | Young Peasants Movement | 2.5 | 40 | 769 | 768 | 975 | 1957 | |
CHE | Switzerland | parliament | 1935-10-27 | 3 | 187 | one-seat | one seat | one seat | 40 | 769 | 768 | 975 | 2303 | ||
CHE | Switzerland | parliament | 1939-10-29 | 3 | 187 | BHB | Bauernheimatbewegung – Jeunes paysans | Young Peasants Movement | 2.5 | 40 | 767 | 769 | 974 | 1957 | |
CHE | Switzerland | parliament | 1939-10-29 | 1 | 187 | LF/PEB | Liberalsozialistische Partei / Freiwirtschaftliche Bewegung – Parti d'économie franche | Liberal Socialist Party | 6.0 | 40 | 767 | 769 | 974 | 1960 | |
CHE | Switzerland | parliament | 1943-10-31 | 3 | 194 | BHB | Bauernheimatbewegung – Jeunes paysans | Young Peasants Movement | 2.5 | 40 | 771 | 767 | 973 | 1957 | |
CHE | Switzerland | parliament | 1943-10-31 | 2 | 194 | one-seat | one seat | one seat | 40 | 771 | 767 | 973 | 2303 | ||
CHE | Switzerland | parliament | 1943-10-31 | 0 | 194 | LF/PEB | Liberalsozialistische Partei / Freiwirtschaftliche Bewegung – Parti d'économie franche | Liberal Socialist Party | 6.0 | 40 | 771 | 767 | 973 | 1960 | |
CHE | Switzerland | parliament | 1947-10-26 | 1 | 194 | LF/PEB | Liberalsozialistische Partei / Freiwirtschaftliche Bewegung – Parti d'économie franche | Liberal Socialist Party | 6.0 | 40 | 684 | 771 | 972 | 1960 | |
CHE | Switzerland | parliament | 1967-10-29 | 1 | 200 | one-seat | one seat | one seat | 40 | 373 | 108 | 513 | 2303 | ||
CHE | Switzerland | parliament | 1979-10-21 | 1 | 200 | EJ | Entente jurassienne | Agreement Jura | 40 | 435 | 371 | 20 | 1964 | ||
CHE | Switzerland | parliament | 1979-10-21 | 1 | 200 | one-seat | one seat | one seat | 40 | 435 | 371 | 20 | 2303 | ||
CHE | Switzerland | parliament | 1983-10-23 | 1 | 200 | KHM | Komitee Herbert Maeder | Committee Herbert Maeder | 40 | 631 | 435 | 723 | 1967 | ||
CHE | Switzerland | parliament | 1983-10-23 | 1 | 200 | one-seat | one seat | one seat | 40 | 631 | 435 | 723 | 2303 | ||
CHE | Switzerland | parliament | 1987-10-18 | 1 | 200 | KHM | Komitee Herbert Maeder | Committee Herbert Maeder | 40 | 358 | 631 | 129 | 1967 | ||
CHE | Switzerland | parliament | 1991-10-20 | 1 | 200 | EJ | Entente jurassienne | Agreement Jura | 40 | 521 | 358 | 426 | 1964 | ||
CHE | Switzerland | parliament | 1991-10-20 | 1 | 200 | KHM | Komitee Herbert Maeder | Committee Herbert Maeder | 40 | 521 | 358 | 426 | 1967 | ||
CHE | Switzerland | parliament | 2011-10-23 | 1 | 200 | one-seat | one seat | one seat | 40 | 779 | 310 | 903 | 2303 | ||
CHE | Switzerland | parliament | 2015-10-18 | 1 | 200 | etc | others | others | 40 | 995 | 779 | 989 | 2579 | ||
CHE | Switzerland | parliament | 2019-10-20 | 1 | 200 | S | solidaritéS | Solidarity | 1.3 | 40 | 1083 | 995 | 1212 | 1226 | |
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 | |||
CZE | Czech Republic | parliament | 1990-06-09 | 4 | 200 | KDS | Krestanskodemokraticka strana | Christian Democratic Party | 8.1444 | 68 | 63 | 440 | |||
CZE | Czech Republic | parliament | 1992-06-06 | 10 | 200 | KDS | Krestanskodemokraticka strana | Christian Democratic Party | 8.1444 | 68 | 39 | 63 | 262 | 440 | |
CZE | Czech Republic | parliament | 2002-06-15 | 9 | 200 | US | Unie svobody | Freedom Union | 7.2204 | 68 | 487 | 27 | 443 | 688 | |
CZE | Czech Republic | parliament | 2010-05-29 | 3 | 200 | STAN | Starostové a nezávislí | Mayors and Independents | 6.0 | 68 | 599 | 50 | 157 | 2024 | |
CZE | Czech Republic | parliament | 2013-10-25 | 5 | 200 | STAN | Starostové a nezávislí | Mayors and Independents | 6.0 | 68 | 805 | 599 | 1062 | 2024 | |
DEU | Germany | ep | 2014-05-25 | 2 | 96 | one-seat | one seat | one seat | 54 | 825 | 800 | 1071 | 2289 | ||
DNK | Denmark | parliament | 1903-06-16 | 1 | 114 | none | ingen | no party affiliation | 21 | 887 | 886 | 1365 | 1128 | ||
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 | ||
DNK | Denmark | parliament | 1945-10-30 | 1 | 149 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 121 | 901 | 10 | 1634 | ||
DNK | Denmark | parliament | 1947-10-28 | 2 | 150 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 541 | 121 | 387 | 1634 | ||
DNK | Denmark | parliament | 1950-09-05 | 2 | 151 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 430 | 541 | 408 | 1634 | ||
DNK | Denmark | parliament | 1953-04-21 | 2 | 151 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 213 | 430 | 36 | 1634 | ||
DNK | Denmark | parliament | 1953-09-22 | 4 | 179 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 630 | 213 | 359 | 1634 | ||
DNK | Denmark | parliament | 1957-05-14 | 4 | 179 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 263 | 630 | 218 | 1634 | ||
DNK | Denmark | parliament | 1960-11-15 | 4 | 179 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 73 | 263 | 467 | 1634 | ||
DNK | Denmark | parliament | 1964-09-22 | 4 | 179 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 288 | 73 | 841 | 1634 | ||
DNK | Denmark | parliament | 1966-11-22 | 4 | 179 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 97 | 288 | 660 | 1634 | ||
DNK | Denmark | parliament | 1968-01-23 | 4 | 179 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 531 | 97 | 825 | 1634 | ||
DNK | Denmark | parliament | 1971-09-21 | 4 | 179 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 400 | 531 | 596 | 1634 | ||
DNK | Denmark | parliament | 1973-12-04 | 4 | 179 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 64 | 400 | 320 | 1634 | ||
DNK | Denmark | parliament | 1973-12-04 | 1 | 179 | SP | Slesvigsk Parti | Schleswig Party | 21 | 64 | 400 | 320 | 812 | ||
DNK | Denmark | parliament | 1973-12-04 | 1 | 179 | DU | De Uafhængige | Independents Party | 6.0 | 21 | 64 | 400 | 320 | 538 | |
DNK | Denmark | parliament | 1975-01-09 | 4 | 179 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 464 | 64 | 744 | 1634 | ||
DNK | Denmark | parliament | 1975-01-09 | 1 | 179 | SP | Slesvigsk Parti | Schleswig Party | 21 | 464 | 64 | 744 | 812 | ||
DNK | Denmark | parliament | 1977-02-15 | 4 | 179 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 409 | 464 | 50 | 1634 | ||
DNK | Denmark | parliament | 1977-02-15 | 1 | 179 | SP | Slesvigsk Parti | Schleswig Party | 21 | 409 | 464 | 50 | 812 | ||
DNK | Denmark | ep | 1979-06-10 | 1 | 16 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 271 | 409 | 824 | 1634 |
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;