view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by vote_share
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DNK | Denmark | parliament | 1979-10-23 | 4 | 179 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 242 | 409 | 824 | 1634 | ||
DNK | Denmark | parliament | 1981-12-08 | 4 | 179 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 179 | 242 | 379 | 1634 | ||
DNK | Denmark | parliament | 1984-01-10 | 1 | 179 | At | Atassut | Solidarity (Greenland) | 6.0 | 21 | 597 | 179 | 819 | 2575 | |
DNK | Denmark | parliament | 1984-01-10 | 1 | 179 | Si | Siumut | Forward (Greenland) | 3.3 | 21 | 597 | 179 | 819 | 74 | |
DNK | Denmark | parliament | 1984-01-10 | 1 | 179 | FF | Hin føroyski fólkaflokkurin – radikalt sjálvstýri | People's Party (Faroe Islands) | 7.4 | 21 | 597 | 179 | 819 | 2574 | |
DNK | Denmark | parliament | 1984-01-10 | 1 | 179 | Sbf | Sambandsflokkurin | Union Party (Faroe Islands) | 7.4 | 21 | 597 | 179 | 819 | 1892 | |
DNK | Denmark | ep | 1984-06-17 | 1 | 16 | GrFa | Grønland og Færøerne | Greenland and Faroe Islands | 21 | 128 | 597 | 195 | 1634 | ||
DNK | Denmark | parliament | 1987-09-08 | 1 | 179 | At | Atassut | Solidarity (Greenland) | 6.0 | 21 | 226 | 597 | 195 | 2575 | |
DNK | Denmark | parliament | 1987-09-08 | 1 | 179 | Si | Siumut | Forward (Greenland) | 3.3 | 21 | 226 | 597 | 195 | 74 | |
DNK | Denmark | parliament | 1987-09-08 | 1 | 179 | FF | Hin føroyski fólkaflokkurin – radikalt sjálvstýri | People's Party (Faroe Islands) | 7.4 | 21 | 226 | 597 | 195 | 2574 | |
DNK | Denmark | parliament | 1987-09-08 | 1 | 179 | Jf | Javnaðarflokkurin | Social Democratic Party (Faroe Islands) | 3.3 | 21 | 226 | 597 | 195 | 1894 | |
DNK | Denmark | parliament | 1988-05-10 | 1 | 179 | At | Atassut | Solidarity (Greenland) | 6.0 | 21 | 387 | 226 | 837 | 2575 | |
DNK | Denmark | parliament | 1988-05-10 | 1 | 179 | Si | Siumut | Forward (Greenland) | 3.3 | 21 | 387 | 226 | 837 | 74 | |
DNK | Denmark | parliament | 1988-05-10 | 1 | 179 | FF | Hin føroyski fólkaflokkurin – radikalt sjálvstýri | People's Party (Faroe Islands) | 7.4 | 21 | 387 | 226 | 837 | 2574 | |
DNK | Denmark | parliament | 1988-05-10 | 1 | 179 | Sbf | Sambandsflokkurin | Union Party (Faroe Islands) | 7.4 | 21 | 387 | 226 | 837 | 1892 | |
DNK | Denmark | parliament | 1990-12-12 | 1 | 179 | At | Atassut | Solidarity (Greenland) | 6.0 | 21 | 157 | 387 | 57 | 2575 | |
DNK | Denmark | parliament | 1990-12-12 | 1 | 179 | Si | Siumut | Forward (Greenland) | 3.3 | 21 | 157 | 387 | 57 | 74 | |
DNK | Denmark | parliament | 1990-12-12 | 1 | 179 | FF | Hin føroyski fólkaflokkurin – radikalt sjálvstýri | People's Party (Faroe Islands) | 7.4 | 21 | 157 | 387 | 57 | 2574 | |
DNK | Denmark | parliament | 1990-12-12 | 1 | 179 | Jf | Javnaðarflokkurin | Social Democratic Party (Faroe Islands) | 3.3 | 21 | 157 | 387 | 57 | 1894 | |
DNK | Denmark | parliament | 1994-09-21 | 1 | 179 | At | Atassut | Solidarity (Greenland) | 6.0 | 21 | 89 | 157 | 740 | 2575 | |
DNK | Denmark | parliament | 1994-09-21 | 1 | 179 | FF | Hin føroyski fólkaflokkurin – radikalt sjálvstýri | People's Party (Faroe Islands) | 7.4 | 21 | 89 | 157 | 740 | 2574 | |
DNK | Denmark | parliament | 1994-09-21 | 1 | 179 | Sbf | Sambandsflokkurin | Union Party (Faroe Islands) | 7.4 | 21 | 89 | 157 | 740 | 1892 | |
DNK | Denmark | parliament | 1994-09-21 | 1 | 179 | etc | others | others | 21 | 89 | 157 | 740 | 2576 | ||
DNK | Denmark | parliament | 1998-03-11 | 1 | 179 | Si | Siumut | Forward (Greenland) | 3.3 | 21 | 389 | 89 | 255 | 74 | |
DNK | Denmark | parliament | 1998-03-11 | 1 | 179 | FF | Hin føroyski fólkaflokkurin – radikalt sjálvstýri | People's Party (Faroe Islands) | 7.4 | 21 | 389 | 89 | 255 | 2574 | |
DNK | Denmark | parliament | 1998-03-11 | 1 | 179 | Jf | Javnaðarflokkurin | Social Democratic Party (Faroe Islands) | 3.3 | 21 | 389 | 89 | 255 | 1894 | |
DNK | Denmark | parliament | 1998-03-11 | 1 | 179 | At | Atassut | Solidarity (Greenland) | 6.0 | 21 | 389 | 89 | 255 | 2575 | |
DNK | Denmark | parliament | 2001-11-20 | 1 | 179 | IA | Inuit Ataqatigiit | Community of the People | 1.3 | 21 | 632 | 389 | 630 | 1891 | |
DNK | Denmark | parliament | 2001-11-20 | 1 | 179 | Si | Siumut | Forward (Greenland) | 3.3 | 21 | 632 | 389 | 630 | 74 | |
DNK | Denmark | parliament | 2001-11-20 | 1 | 179 | Sbf | Sambandsflokkurin | Union Party (Faroe Islands) | 7.4 | 21 | 632 | 389 | 630 | 1892 | |
DNK | Denmark | parliament | 2001-11-20 | 1 | 179 | T | Tjóðveldi | Republic (Faroe Islands) | 1.3 | 21 | 632 | 389 | 630 | 2568 | |
DNK | Denmark | parliament | 2005-02-08 | 1 | 179 | IA | Inuit Ataqatigiit | Community of the People | 1.3 | 21 | 563 | 632 | 482 | 1891 | |
DNK | Denmark | parliament | 2005-02-08 | 1 | 179 | Si | Siumut | Forward (Greenland) | 3.3 | 21 | 563 | 632 | 482 | 74 | |
DNK | Denmark | parliament | 2005-02-08 | 1 | 179 | FF | Hin føroyski fólkaflokkurin – radikalt sjálvstýri | People's Party (Faroe Islands) | 7.4 | 21 | 563 | 632 | 482 | 2574 | |
DNK | Denmark | parliament | 2005-02-08 | 1 | 179 | T | Tjóðveldi | Republic (Faroe Islands) | 1.3 | 21 | 563 | 632 | 482 | 2568 | |
DNK | Denmark | parliament | 2007-11-13 | 1 | 179 | Sbf | Sambandsflokkurin | Union Party (Faroe Islands) | 7.4 | 21 | 174 | 563 | 316 | 1892 | |
DNK | Denmark | parliament | 2007-11-13 | 1 | 179 | IA | Inuit Ataqatigiit | Community of the People | 1.3 | 21 | 174 | 563 | 316 | 1891 | |
DNK | Denmark | parliament | 2007-11-13 | 1 | 179 | Si | Siumut | Forward (Greenland) | 3.3 | 21 | 174 | 563 | 316 | 74 | |
DNK | Denmark | parliament | 2007-11-13 | 1 | 179 | T | Tjóðveldi | Republic (Faroe Islands) | 1.3 | 21 | 174 | 563 | 316 | 2568 | |
DNK | Denmark | parliament | 2011-09-15 | 1 | 179 | IA | Inuit Ataqatigiit | Community of the People | 1.3 | 21 | 722 | 174 | 71 | 1891 | |
DNK | Denmark | parliament | 2011-09-15 | 1 | 179 | Si | Siumut | Forward (Greenland) | 3.3 | 21 | 722 | 174 | 71 | 74 | |
DNK | Denmark | parliament | 2011-09-15 | 1 | 179 | Sbf | Sambandsflokkurin | Union Party (Faroe Islands) | 7.4 | 21 | 722 | 174 | 71 | 1892 | |
DNK | Denmark | parliament | 2011-09-15 | 1 | 179 | Jf | Javnaðarflokkurin | Social Democratic Party (Faroe Islands) | 3.3 | 21 | 722 | 174 | 71 | 1894 | |
DNK | Denmark | parliament | 2015-06-18 | 1 | 179 | IA | Inuit Ataqatigiit | Community of the People | 1.3 | 21 | 976 | 722 | 1074 | 1891 | |
DNK | Denmark | parliament | 2015-06-18 | 1 | 179 | Si | Siumut | Forward (Greenland) | 3.3 | 21 | 976 | 722 | 1074 | 74 | |
DNK | Denmark | parliament | 2015-06-18 | 1 | 179 | T | Tjóðveldi | Republic (Faroe Islands) | 1.3 | 21 | 976 | 722 | 1074 | 2568 | |
DNK | Denmark | parliament | 2015-06-18 | 1 | 179 | Jf | Javnaðarflokkurin | Social Democratic Party (Faroe Islands) | 3.3 | 21 | 976 | 722 | 1074 | 1894 | |
DNK | Denmark | parliament | 2019-06-05 | 1 | 179 | Sbf | Sambandsflokkurin | Union Party (Faroe Islands) | 7.4 | 21 | 1077 | 976 | 1497 | 1892 | |
DNK | Denmark | parliament | 2019-06-05 | 1 | 179 | Jf | Javnaðarflokkurin | Social Democratic Party (Faroe Islands) | 3.3 | 21 | 1077 | 976 | 1497 | 1894 | |
DNK | Denmark | parliament | 2019-06-05 | 1 | 179 | IA | Inuit Ataqatigiit | Community of the People | 1.3 | 21 | 1077 | 976 | 1497 | 1891 | |
DNK | Denmark | parliament | 2019-06-05 | 1 | 179 | Si | Siumut | Forward (Greenland) | 3.3 | 21 | 1077 | 976 | 1497 | 74 | |
DNK | Denmark | parliament | 2022-11-01 | 1 | 179 | IA | Inuit Ataqatigiit | Community of the People | 1.3 | 21 | 1116 | 1077 | 1598 | 1891 | |
DNK | Denmark | parliament | 2022-11-01 | 1 | 179 | Si | Siumut | Forward (Greenland) | 3.3 | 21 | 1116 | 1077 | 1598 | 74 | |
DNK | Denmark | parliament | 2022-11-01 | 1 | 179 | Sbf | Sambandsflokkurin | Union Party (Faroe Islands) | 7.4 | 21 | 1116 | 1077 | 1598 | 1892 | |
DNK | Denmark | parliament | 2022-11-01 | 1 | 179 | Jf | Javnaðarflokkurin | Social Democratic Party (Faroe Islands) | 3.3 | 21 | 1116 | 1077 | 1598 | 1894 | |
ESP | Spain | parliament | 1979-03-01 | 2 | 350 | one-seat | one seat | one seat | 27 | 493 | 42 | 205 | 2294 | ||
ESP | Spain | ep | 1986-01-01 | 36 | 60 | PSOE | Partido Socialista Obrero Español | Spanish Socialist Workers Party | 3.7377 | 27 | 38 | 85 | 238 | 902 | |
ESP | Spain | ep | 1986-01-01 | 17 | 60 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 38 | 85 | 238 | 645 | |
ESP | Spain | ep | 1986-01-01 | 7 | 60 | etc | others | others | 27 | 38 | 85 | 238 | 1377 | ||
ESP | Spain | parliament | 2011-11-20 | 2 | 350 | one-seat | one seat | one seat | 27 | 777 | 500 | 497 | 2294 | ||
FIN | Finland | parliament | 1933-07-01 | 14 | 200 | IK | Isänmaallinen Kansanliike – Fosterländska Folkrörelsen | Patriotic People's Movement | 7.4 | 67 | 689 | 269 | 1202 | 957 | |
FIN | Finland | ep | 1995-01-01 | 5 | 16 | KESK | Keskusta | Centre Party | 5.8027 | 67 | 193 | 602 | 206 | 94 | |
FIN | Finland | ep | 1995-01-01 | 4 | 16 | KOK | Kansallinen Kokoomus – Samlingspartiet | National Coalition Party | 7.2451 | 67 | 193 | 602 | 206 | 1118 | |
FIN | Finland | ep | 1995-01-01 | 4 | 16 | SSDP | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti | Social Democratic Party of Finland | 3.5595 | 67 | 193 | 602 | 206 | 395 | |
FIN | Finland | ep | 1995-01-01 | 1 | 16 | RKP-SFP | Ruotsalainen Kansanpuolue – Svenska Folkepartiet i Finland | Swedish People's Party | 6.3906 | 67 | 193 | 602 | 206 | 585 | |
FIN | Finland | ep | 1995-01-01 | 1 | 16 | VIHR | Vihreä Liitto – Gröna Förbundet | Green League | 3.6465 | 67 | 193 | 602 | 206 | 1062 | |
FIN | Finland | ep | 1995-01-01 | 1 | 16 | DL|VAS | Demokraattinen Liitto – Demokratiska Förbundet | Vasemmistoliitto – Vänsterförbundet | Democratic Union | Left Alliance | 2.1843 | 67 | 193 | 602 | 206 | 1292 | |
FRA | France | parliament | 1910-05-08 | 2 | 580 | etc | divers | others | 43 | 988 | 986 | 1391 | 1328 | ||
FRA | France | parliament | 1919-10-16 | 2 | 616 | etc | divers | others | 43 | 990 | 989 | 1359 | 1328 | ||
FRA | France | parliament | 1928-04-29 | 52 | 602 | RI | Radicaux indépendants | Independent Radicals | 7.4 | 43 | 985 | 991 | 1347 | 2585 | |
FRA | France | parliament | 1928-04-29 | 2 | 602 | etc | divers | others | 43 | 985 | 991 | 1347 | 1328 | ||
FRA | France | parliament | 1945-10-21 | 2 | 522 | none | sans étiquette | no party affiliation | 43 | 471 | 983 | 329 | 947 | ||
FRA | France | parliament | 1956-01-02 | 3 | 544 | etc | divers | others | 43 | 312 | 293 | 397 | 1328 | ||
FRA | France | parliament | 1978-03-19 | 124 | 474 | UDF|MD | Union pour la démocratie française | Mouvement démocrate | Union for French Democracy | Democratic Movement | 6.1017 | 43 | 496 | 357 | 21 | 509 | |
FRA | France | parliament | 1993-03-28 | 0 | 577 | GE | Generation écologie | Ecology Generation | 3.6389 | 43 | 664 | 643 | 199 | 650 | |
FRA | France | ep | 2004-06-13 | 0 | 78 | LCR | Ligue communiste révolutionnaire | Revolutionary Communist League | 0.0714 | 43 | 160 | 403 | 802 | 442 | |
FRA | France | parliament | 2007-06-17 | 1 | 577 | none | sans étiquette | no party affiliation | 43 | 171 | 403 | 807 | 947 | ||
FRA | France | ep | 2014-05-24 | 1 | 74 | PRG | Parti radical de gauche | Radical Party of the Left | 4.0813 | 43 | 824 | 782 | 1103 | 1492 | |
FRA | France | ep | 2014-05-24 | 1 | 74 | PR | Parti radical-socialiste | Radical Socialist Party | 3.9896 | 43 | 824 | 782 | 1103 | 401 | |
FRA | France | ep | 2014-05-24 | 1 | 74 | AC | Alliance centriste | Centrist Alliance | 6.0 | 43 | 824 | 782 | 1103 | 2078 | |
FRA | France | ep | 2014-05-24 | 1 | 74 | NC | Nouveau centre | New Centre | 6.0 | 43 | 824 | 782 | 1103 | 1058 | |
FRA | France | parliament | 2017-06-18 | 5 | 577 | none | sans étiquette | no party affiliation | 43 | 1014 | 782 | 1508 | 947 | ||
FRA | France | parliament | 2017-06-18 | 3 | 577 | etc | divers | others | 43 | 1014 | 782 | 1508 | 1328 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 8 | 707 | etc | others | others | 44 | 905 | 453 | ||||
GBR | United Kingdom | parliament | 1924-10-29 | 1 | 615 | N | Nationalist Party | Nationalist Party | 3.3 | 44 | 908 | 907 | 1292 | 332 | |
GBR | United Kingdom | parliament | 1945-07-05 | 19 | 640 | etc | others | others | 44 | 609 | 911 | 1520 | 453 | ||
GBR | United Kingdom | parliament | 1950-02-23 | 282 | 625 | Con | Conservatives | Conservatives | 7.4261 | 44 | 625 | 609 | 99 | 773 | |
GBR | United Kingdom | parliament | 1950-02-23 | 16 | 625 | NLP | National Liberal Party | National Liberal Party | 6.0 | 44 | 625 | 609 | 99 | 1017 | |
GBR | United Kingdom | parliament | 1950-02-23 | 1 | 625 | etc | others | others | 44 | 625 | 609 | 99 | 453 | ||
GBR | United Kingdom | parliament | 1951-10-25 | 302 | 625 | Con | Conservatives | Conservatives | 7.4261 | 44 | 102 | 625 | 88 | 773 | |
GBR | United Kingdom | parliament | 1951-10-25 | 19 | 625 | NLP | National Liberal Party | National Liberal Party | 6.0 | 44 | 102 | 625 | 88 | 1017 | |
GBR | United Kingdom | parliament | 1955-05-26 | 324 | 630 | Con | Conservatives | Conservatives | 7.4261 | 44 | 678 | 102 | 729 | 773 | |
GBR | United Kingdom | parliament | 1955-05-26 | 21 | 630 | NLP | National Liberal Party | National Liberal Party | 6.0 | 44 | 678 | 102 | 729 | 1017 | |
GBR | United Kingdom | parliament | 1959-10-08 | 345 | 630 | Con | Conservatives | Conservatives | 7.4261 | 44 | 161 | 678 | 404 | 773 | |
GBR | United Kingdom | parliament | 1959-10-08 | 20 | 630 | NLP | National Liberal Party | National Liberal Party | 6.0 | 44 | 161 | 678 | 404 | 1017 | |
GBR | United Kingdom | parliament | 1959-10-08 | 1 | 630 | etc | others | others | 44 | 161 | 678 | 404 | 453 | ||
GBR | United Kingdom | parliament | 1964-10-15 | 298 | 630 | Con | Conservatives | Conservatives | 7.4261 | 44 | 223 | 161 | 63 | 773 | |
GBR | United Kingdom | parliament | 1964-10-15 | 6 | 630 | NLP | National Liberal Party | National Liberal Party | 6.0 | 44 | 223 | 161 | 63 | 1017 | |
GBR | United Kingdom | parliament | 1966-03-31 | 250 | 630 | Con | Conservatives | Conservatives | 7.4261 | 44 | 583 | 223 | 760 | 773 | |
GBR | United Kingdom | parliament | 1966-03-31 | 3 | 630 | NLP | National Liberal Party | National Liberal Party | 6.0 | 44 | 583 | 223 | 760 | 1017 |
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;