view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by seats descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GBR | United Kingdom | parliament | 1931-10-27 | 54.98 | 470 | 615 | Con | Conservatives | Conservatives | 7.4261 | 44 | 910 | 909 | 1290 | 773 |
GBR | United Kingdom | parliament | 1997-05-01 | 43.2 | 419 | 659 | Lab | Labour Party | Labour | 4.3562 | 44 | 315 | 514 | 678 | 1556 |
GBR | United Kingdom | parliament | 1924-10-29 | 47.2 | 412 | 615 | Con | Conservatives | Conservatives | 7.4261 | 44 | 908 | 907 | 1292 | 773 |
GBR | United Kingdom | parliament | 2001-06-07 | 40.7 | 412 | 659 | Lab | Labour Party | Labour | 4.3562 | 44 | 208 | 315 | 838 | 1556 |
GBR | United Kingdom | parliament | 1983-06-09 | 42.4 | 397 | 650 | Con | Conservatives | Conservatives | 7.4261 | 44 | 290 | 243 | 273 | 773 |
GBR | United Kingdom | parliament | 1945-07-05 | 48.0 | 393 | 640 | Lab | Labour Party | Labour | 4.3562 | 44 | 609 | 911 | 1520 | 1556 |
GBR | United Kingdom | parliament | 1935-11-14 | 47.72 | 387 | 615 | Con | Conservatives | Conservatives | 7.4261 | 44 | 911 | 910 | 1287 | 773 |
GBR | United Kingdom | parliament | 1987-06-11 | 42.3 | 376 | 650 | Con | Conservatives | Conservatives | 7.4261 | 44 | 490 | 290 | 646 | 773 |
GBR | United Kingdom | parliament | 2019-12-12 | 43.63 | 365 | 650 | Con | Conservatives | Conservatives | 7.4261 | 44 | 1086 | 1013 | 1599 | 773 |
GBR | United Kingdom | parliament | 1966-03-31 | 48.0 | 364 | 630 | Lab | Labour Party | Labour | 4.3562 | 44 | 583 | 223 | 760 | 1556 |
TUR | Turkey | parliament | 2002-11-03 | 34.28 | 363 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 808 | 809 | 1101 | 901 |
FRA | France | parliament | 2002-06-16 | 33.3 | 356 | 577 | UMP|LR | Union pour un mouvement populaire | Les Républicains | Union for a Popular Movement | The Republicans | 7.4997 | 43 | 403 | 479 | 711 | 658 |
GBR | United Kingdom | parliament | 2005-05-05 | 35.2 | 355 | 646 | Lab | Labour Party | Labour | 4.3562 | 44 | 233 | 208 | 19 | 1556 |
GBR | United Kingdom | parliament | 1959-10-08 | 345 | 630 | Con | Conservatives | Conservatives | 7.4261 | 44 | 161 | 678 | 404 | 773 | |
GBR | United Kingdom | parliament | 1922-11-15 | 38.23 | 344 | 615 | Con | Conservatives | Conservatives | 7.4261 | 44 | 906 | 905 | 1294 | 773 |
TUR | Turkey | parliament | 2007-07-22 | 46.66 | 341 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 807 | 808 | 1077 | 901 |
GBR | United Kingdom | parliament | 1979-05-03 | 43.9 | 339 | 635 | Con | Conservatives | Conservatives | 7.4261 | 44 | 243 | 40 | 590 | 773 |
GBR | United Kingdom | parliament | 1992-04-09 | 41.9 | 336 | 651 | Con | Conservatives | Conservatives | 7.4261 | 44 | 514 | 490 | 515 | 773 |
GBR | United Kingdom | parliament | 1918-12-14 | 32.5 | 332 | 707 | Con | Conservatives | Conservatives | 7.4261 | 44 | 905 | 773 | ||
GBR | United Kingdom | parliament | 2015-05-07 | 36.93 | 331 | 650 | Con | Conservatives | Conservatives | 7.4261 | 44 | 856 | 582 | 874 | 773 |
GBR | United Kingdom | parliament | 1970-06-18 | 46.4 | 330 | 630 | Con | Conservatives | Conservatives | 7.4261 | 44 | 311 | 583 | 733 | 773 |
TUR | Turkey | parliament | 2011-06-12 | 49.83 | 327 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 806 | 807 | 1076 | 901 |
GBR | United Kingdom | parliament | 1955-05-26 | 324 | 630 | Con | Conservatives | Conservatives | 7.4261 | 44 | 678 | 102 | 729 | 773 | |
GBR | United Kingdom | parliament | 1974-10-10 | 39.2 | 319 | 635 | Lab | Labour Party | Labour | 4.3562 | 44 | 40 | 568 | 419 | 1556 |
GBR | United Kingdom | parliament | 2017-06-08 | 42.45 | 318 | 650 | Con | Conservatives | Conservatives | 7.4261 | 44 | 1013 | 856 | 1489 | 773 |
GBR | United Kingdom | parliament | 1964-10-15 | 44.1 | 317 | 630 | Lab | Labour Party | Labour | 4.3562 | 44 | 223 | 161 | 63 | 1556 |
TUR | Turkey | parliament | 2015-11-01 | 49.5 | 317 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 997 | 975 | 1173 | 901 |
GBR | United Kingdom | parliament | 1950-02-23 | 46.1 | 315 | 625 | Lab | Labour Party | Labour | 4.3562 | 44 | 625 | 609 | 99 | 1556 |
FRA | France | parliament | 2007-06-17 | 39.54 | 313 | 577 | UMP|LR | Union pour un mouvement populaire | Les Républicains | Union for a Popular Movement | The Republicans | 7.4997 | 43 | 171 | 403 | 807 | 658 |
FRA | France | parliament | 2017-06-18 | 28.21 | 308 | 577 | REM|R | La République En Marche! | Renaissance | The Republic Onwards! | Renaissance | 6.0 | 43 | 1014 | 782 | 1508 | 2643 |
JPN | Japan | parliament | 2009-08-30 | 42.41 | 308 | 480 | DPJ | Minshutō | Democratic Party of Japan | 5.5717 | 5 | 327 | 554 | 494 | 439 |
GBR | United Kingdom | parliament | 2010-05-06 | 36.1 | 307 | 650 | Con | Conservatives | Conservatives | 7.4261 | 44 | 582 | 233 | 119 | 773 |
ITA | Italy | parliament | 1948-04-18 | 48.5 | 305 | 574 | DC | Democrazia Cristiana | Christian Democrats | 5.6611 | 26 | 467 | 503 | 501 | 1633 |
GBR | United Kingdom | parliament | 1951-10-25 | 302 | 625 | Con | Conservatives | Conservatives | 7.4261 | 44 | 102 | 625 | 88 | 773 | |
GBR | United Kingdom | parliament | 1974-02-28 | 37.2 | 301 | 635 | Lab | Labour Party | Labour | 4.3562 | 44 | 568 | 311 | 216 | 1556 |
JPN | Japan | parliament | 1960-11-20 | 58.1 | 300 | 467 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 345 | 645 | 241 | 1193 |
JPN | Japan | parliament | 1986-07-06 | 49.42 | 300 | 512 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 506 | 138 | 568 | 1193 |
DEU | Germany | parliament | 1998-09-27 | 40.9 | 298 | 669 | SPD | Sozialdemokratische Partei Deutschlands | Social Democratic Party of Germany | 3.6451 | 54 | 679 | 595 | 778 | 558 |
GBR | United Kingdom | parliament | 1964-10-15 | 298 | 630 | Con | Conservatives | Conservatives | 7.4261 | 44 | 223 | 161 | 63 | 773 | |
JPN | Japan | parliament | 1958-05-22 | 59.0 | 298 | 467 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 645 | 692 | 887 | 1193 |
GBR | United Kingdom | parliament | 1974-02-28 | 38.0 | 297 | 635 | Con | Conservatives | Conservatives | 7.4261 | 44 | 568 | 311 | 216 | 773 |
ITA | Italy | parliament | 2013-02-25 | 26.27 | 297 | 630 | PD | Partito Democratico | Democratic Party | 2.6216 | 26 | 789 | 111 | 983 | 382 |
JPN | Japan | parliament | 2005-09-11 | 38.18 | 296 | 480 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 554 | 511 | 770 | 1193 |
GBR | United Kingdom | parliament | 1951-10-25 | 48.8 | 295 | 625 | Lab | Labour Party | Labour | 4.3562 | 44 | 102 | 625 | 88 | 1556 |
TUR | Turkey | parliament | 2018-06-24 | 42.62 | 295 | 600 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 1032 | 997 | 1487 | 901 |
JPN | Japan | parliament | 1963-11-21 | 56.0 | 294 | 467 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 640 | 345 | 48 | 1193 |
JPN | Japan | parliament | 2012-12-16 | 27.6 | 294 | 480 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 788 | 327 | 969 | 1193 |
TUR | Turkey | parliament | 1987-10-29 | 36.31 | 292 | 450 | ANAP | Anavatan Partisi | Motherland Party | 6.213 | 20 | 812 | 813 | 1087 | 1334 |
JPN | Japan | parliament | 2014-12-14 | 33.11 | 290 | 475 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 850 | 788 | 1044 | 1193 |
DEU | Germany | parliament | 1933-03-05 | 43.91 | 288 | 647 | NSDAP | Nationalsozialistische Deutsche Arbeiterpartei | National Socialist German Workers' Party | 8.8 | 54 | 1040 | 1039 | 1578 | 2695 |
GBR | United Kingdom | parliament | 1970-06-18 | 43.1 | 288 | 630 | Lab | Labour Party | Labour | 4.3562 | 44 | 311 | 583 | 733 | 1556 |
JPN | Japan | parliament | 1969-12-27 | 47.63 | 288 | 486 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 603 | 367 | 787 | 1193 |
GBR | United Kingdom | parliament | 1929-05-30 | 36.96 | 287 | 615 | Lab | Labour Party | Labour | 4.3562 | 44 | 909 | 908 | 1291 | 1556 |
JPN | Japan | parliament | 1980-06-22 | 47.9 | 284 | 511 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 113 | 433 | 727 | 1193 |
FRA | France | parliament | 1968-06-30 | 38.0 | 282 | 470 | G | Gaulliste | Gaullists | 8.2 | 43 | 386 | 291 | 662 | 1094 |
GBR | United Kingdom | parliament | 1950-02-23 | 282 | 625 | Con | Conservatives | Conservatives | 7.4261 | 44 | 625 | 609 | 99 | 773 | |
JPN | Japan | parliament | 2017-10-22 | 33.28 | 281 | 465 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 1022 | 850 | 1156 | 1193 |
FRA | France | parliament | 2012-06-17 | 29.35 | 280 | 577 | PS | Parti socialiste | Socialist Party | 3.2493 | 43 | 782 | 171 | 1037 | 1539 |
JPN | Japan | parliament | 1967-01-29 | 49.2 | 280 | 486 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 367 | 640 | 8 | 1193 |
GBR | United Kingdom | parliament | 1955-05-26 | 46.4 | 277 | 630 | Lab | Labour Party | Labour | 4.3562 | 44 | 678 | 102 | 729 | 1556 |
GBR | United Kingdom | parliament | 1974-10-10 | 35.8 | 277 | 635 | Con | Conservatives | Conservatives | 7.4261 | 44 | 40 | 568 | 419 | 773 |
ITA | Italy | parliament | 2008-04-13 | 38.23 | 276 | 630 | FI-PdL | Forza Italia – Il Popolo della Libertà | Go Italy -- The People of Freedom | 7.1459 | 26 | 111 | 107 | 117 | 596 |
JPN | Japan | parliament | 1990-02-18 | 46.16 | 275 | 512 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 25 | 506 | 106 | 1193 |
ITA | Italy | parliament | 1958-05-25 | 42.4 | 273 | 596 | DC | Democrazia Cristiana | Christian Democrats | 5.6611 | 26 | 507 | 642 | 280 | 1633 |
GBR | United Kingdom | parliament | 1992-04-09 | 34.9 | 271 | 651 | Lab | Labour Party | Labour | 4.3562 | 44 | 514 | 490 | 515 | 1556 |
JPN | Japan | parliament | 1972-12-10 | 46.85 | 271 | 491 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 333 | 603 | 656 | 1193 |
GBR | United Kingdom | parliament | 1979-05-03 | 36.9 | 269 | 635 | Lab | Labour Party | Labour | 4.3562 | 44 | 243 | 40 | 590 | 1556 |
DEU | Germany | parliament | 1990-12-02 | 36.7 | 268 | 662 | CDU | Christlich Demokratische Union | Christian Democratic Union | 6.2503 | 54 | 445 | 588 | 286 | 808 |
FRA | France | parliament | 1981-06-21 | 36.0 | 268 | 474 | PS | Parti socialiste | Socialist Party | 3.2493 | 43 | 20 | 496 | 1148 | 1539 |
ITA | Italy | parliament | 1968-05-19 | 39.1 | 266 | 630 | DC | Democrazia Cristiana | Christian Democrats | 5.6611 | 26 | 261 | 380 | 433 | 1633 |
ITA | Italy | parliament | 1972-05-07 | 38.7 | 266 | 630 | DC | Democrazia Cristiana | Christian Democrats | 5.6611 | 26 | 65 | 261 | 398 | 1633 |
JPN | Japan | parliament | 1949-01-23 | 43.9 | 264 | 466 | JLP | Nihon Jiyūtō | Japan Liberal Party | 7.4 | 5 | 695 | 696 | 894 | 1726 |
ITA | Italy | parliament | 1953-06-07 | 40.1 | 263 | 590 | DC | Democrazia Cristiana | Christian Democrats | 5.6611 | 26 | 642 | 467 | 597 | 1633 |
ROU | Romania | parliament | 1990-05-20 | 66.3 | 263 | 396 | PD | Partidul Democrat | Democratic Party | 5.3875 | 23 | 633 | 1604 | 419 | |
GBR | United Kingdom | parliament | 2017-06-08 | 39.99 | 262 | 650 | Lab | Labour Party | Labour | 4.3562 | 44 | 1013 | 856 | 1489 | 1556 |
ITA | Italy | parliament | 1976-06-20 | 38.7 | 262 | 630 | DC | Democrazia Cristiana | Christian Democrats | 5.6611 | 26 | 502 | 65 | 842 | 1633 |
ITA | Italy | parliament | 1979-06-03 | 38.3 | 262 | 630 | DC | Democrazia Cristiana | Christian Democrats | 5.6611 | 26 | 604 | 502 | 638 | 1633 |
FRA | France | parliament | 1988-06-12 | 34.9 | 260 | 555 | PS | Parti socialiste | Socialist Party | 3.2493 | 43 | 643 | 623 | 1150 | 1539 |
GBR | United Kingdom | parliament | 1929-05-30 | 38.22 | 260 | 615 | Con | Conservatives | Conservatives | 7.4261 | 44 | 909 | 908 | 1291 | 773 |
ITA | Italy | parliament | 1963-04-28 | 38.3 | 260 | 630 | DC | Democrazia Cristiana | Christian Democrats | 5.6611 | 26 | 380 | 507 | 347 | 1633 |
GBR | United Kingdom | parliament | 1923-12-06 | 38.0 | 258 | 615 | Con | Conservatives | Conservatives | 7.4261 | 44 | 907 | 906 | 1293 | 773 |
GBR | United Kingdom | parliament | 1959-10-08 | 43.8 | 258 | 630 | Lab | Labour Party | Labour | 4.3562 | 44 | 161 | 678 | 404 | 1556 |
GBR | United Kingdom | parliament | 2010-05-06 | 29.0 | 258 | 650 | Lab | Labour Party | Labour | 4.3562 | 44 | 582 | 233 | 119 | 1556 |
TUR | Turkey | parliament | 2015-06-07 | 40.87 | 258 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 975 | 806 | 1143 | 901 |
DEU | Germany | parliament | 2013-09-22 | 34.1 | 255 | 631 | CDU | Christlich Demokratische Union | Christian Democratic Union | 6.2503 | 54 | 800 | 93 | 472 | 808 |
DEU | Germany | parliament | 1994-10-16 | 36.4 | 252 | 672 | SPD | Sozialdemokratische Partei Deutschlands | Social Democratic Party of Germany | 3.6451 | 54 | 595 | 445 | 862 | 558 |
FRA | France | parliament | 1997-06-01 | 23.5 | 252 | 577 | PS | Parti socialiste | Socialist Party | 3.2493 | 43 | 479 | 664 | 422 | 1539 |
DEU | Germany | parliament | 2002-09-22 | 38.5 | 251 | 603 | SPD | Sozialdemokratische Partei Deutschlands | Social Democratic Party of Germany | 3.6451 | 54 | 385 | 679 | 107 | 558 |
GBR | United Kingdom | parliament | 1966-03-31 | 250 | 630 | Con | Conservatives | Conservatives | 7.4261 | 44 | 583 | 223 | 760 | 773 | |
JPN | Japan | parliament | 1983-12-18 | 45.76 | 250 | 511 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 138 | 113 | 242 | 1193 |
JPN | Japan | parliament | 1976-12-05 | 41.78 | 249 | 511 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 53 | 333 | 59 | 1193 |
FRA | France | parliament | 1993-03-28 | 20.4 | 248 | 577 | RPR | Rassemblement pour la république | Rally for the Republic | 7.4997 | 43 | 664 | 643 | 199 | 138 |
JPN | Japan | parliament | 1979-10-07 | 44.59 | 248 | 511 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 433 | 53 | 227 | 1193 |
FRA | France | parliament | 2022-06-19 | 25.75 | 245 | 577 | REM|R | La République En Marche! | Renaissance | The Republic Onwards! | Renaissance | 6.0 | 43 | 1110 | 1014 | 1673 | 2643 |
DEU | Germany | parliament | 1994-10-16 | 34.2 | 244 | 672 | CDU | Christlich Demokratische Union | Christian Democratic Union | 6.2503 | 54 | 595 | 445 | 862 | 808 |
JPN | Japan | parliament | 1952-10-01 | 47.9 | 240 | 466 | JLP | Nihon Jiyūtō | Japan Liberal Party | 7.4 | 5 | 694 | 695 | 895 | 1726 |
DEU | Germany | parliament | 1990-12-02 | 33.5 | 239 | 662 | SPD | Sozialdemokratische Partei Deutschlands | Social Democratic Party of Germany | 3.6451 | 54 | 445 | 588 | 286 | 558 |
FRA | France | parliament | 1906-05-20 | 28.53 | 239 | 575 | PR | Parti radical-socialiste | Radical Socialist Party | 3.9896 | 43 | 986 | 987 | 1409 | 401 |
JPN | Japan | parliament | 1996-10-20 | 32.76 | 239 | 500 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 628 | 57 | 800 | 1193 |
JPN | Japan | parliament | 2003-11-09 | 35.0 | 237 | 480 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 511 | 237 | 840 | 1193 |
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;