election_result
Data source: ParlGov · About: simonw/parlgov-datasette
9,716 rows sorted by seats descending
This data as json, CSV (advanced)
Link | rowid | id | election_id | party_id | alliance_id | seats ▲ | vote_share | votes | data_source | description | comment |
---|---|---|---|---|---|---|---|---|---|---|---|
7486 | 7486 | 8788 | 910 910 | Conservatives 773 | 470 | 54.98 | 11905925 | bef-7 | Electoral alliance: National Government | ||
2774 | 2774 | 3325 | 315 315 | Labour Party 1556 | 419 | 43.2 | 13518167 | bef-7 | |||
760 | 760 | 910 | 208 208 | Labour Party 1556 | 412 | 40.7 | 10724953 | bef-7 | |||
7472 | 7472 | 8771 | 908 908 | Conservatives 773 | 412 | 47.2 | 7854523 | bef-7 | |||
1843 | 1843 | 2207 | 290 290 | Conservatives 773 | 397 | 42.4 | 13012316 | ||||
3689 | 3689 | 4433 | 609 609 | Labour Party 1556 | 393 | 48.0 | 11967746 | bef-7 | |||
7495 | 7495 | 8800 | 911 911 | Conservatives 773 | 387 | 47.72 | 10496300 | bef-7 | Electoral alliance: National Government | ||
1607 | 1607 | 1928 | 490 490 | Conservatives 773 | 376 | 42.3 | 13760583 | ||||
9181 | 9181 | 10520 | 1086 1086 | Conservatives 773 | 365 | 43.63 | 13966451 | bbc | |||
904 | 904 | 1078 | 583 583 | Labour Party 1556 | 364 | 48.0 | 13096629 | ||||
6482 | 6482 | 7729 | 808 808 | Adalet ve Kalkınma Partisi 901 | 363 | 34.28 | 10808229 | tuik | |||
4361 | 4361 | 5211 | 403 403 | Union pour un mouvement populaire | Les Républicains 658 | 7537 7537 | 356 | 33.3 | 8408023 | asn, no-2010 | ||
2158 | 2158 | 2582 | 233 233 | Labour Party 1556 | 355 | 35.2 | 9552436 | ejpr | |||
122 | 122 | 150 | 161 161 | Conservatives 773 | 4770 4770 | 345 | craig | ||||
7460 | 7460 | 8749 | 906 906 | Conservatives 773 | 344 | 38.23 | 5502298 | bef-7 | |||
6454 | 6454 | 7696 | 807 807 | Adalet ve Kalkınma Partisi 901 | 341 | 46.66 | 16327291 | tuik | |||
1958 | 1958 | 2346 | 243 243 | Conservatives 773 | 339 | 43.9 | 13697923 | ||||
1716 | 1716 | 2062 | 514 514 | Conservatives 773 | 336 | 41.9 | 14093007 | ||||
7448 | 7448 | 8730 | 905 905 | Conservatives 773 | 332 | 32.5 | 3472738 | bef-7 | Electoral alliance: Coalition Government (candidates with "coupon" endorsement) | ||
7159 | 7159 | 8422 | 856 856 | Conservatives 773 | 331 | 36.93 | 11334576 | bbc | |||
3025 | 3025 | 3632 | 311 311 | Conservatives 773 | 330 | 46.4 | 13145123 | ||||
6448 | 6448 | 7689 | 806 806 | Adalet ve Kalkınma Partisi 901 | 327 | 49.83 | 21399082 | tuik | |||
1432 | 1432 | 1721 | 678 678 | Conservatives 773 | 2134 2134 | 324 | craig | ||||
961 | 961 | 1145 | 40 40 | Labour Party 1556 | 319 | 39.2 | 11457079 | ||||
8340 | 8340 | 9659 | 1013 1013 | Conservatives 773 | 318 | 42.45 | 13669883 | bbc | Includes the seat (1) and votes (34,299) of the speaker John Bercow. | ||
2908 | 2908 | 3495 | 223 223 | Labour Party 1556 | 317 | 44.1 | 12205808 | ||||
8140 | 8140 | 9453 | 997 997 | Adalet ve Kalkınma Partisi 901 | 317 | 49.5 | 23681926 | ysk | |||
2307 | 2307 | 2759 | 625 625 | Labour Party 1556 | 315 | 46.1 | 13266176 | ||||
2985 | 2985 | 3587 | 171 171 | Union pour un mouvement populaire | Les Républicains 658 | 7536 7536 | 313 | 39.54 | 10289737 | ref | ||
2136 | 2136 | 2558 | 327 327 | Minshutō 439 | 308 | 42.41 | 29844799 | ejpr | |||
8355 | 8355 | 9675 | 1014 1014 | La République En Marche! | Renaissance 2643 | 308 | 28.21 | 6391269 | ref | |||
228 | 228 | 272 | 582 582 | Conservatives 773 | 307 | 36.1 | 10726614 | bbc | |||
2364 | 2364 | 2827 | 467 467 | Democrazia Cristiana 1633 | 305 | 48.5 | 12740042 | archivio | |||
4447 | 4447 | 5309 | 102 102 | Conservatives 773 | 4617 4617 | 302 | craig | ||||
114 | 114 | 138 | 568 568 | Labour Party 1556 | 301 | 37.2 | 11645616 | ||||
2909 | 2909 | 3496 | 506 506 | Jiyū Minshutō 1193 | 300 | 49.42 | 29875501 | parline | |||
4099 | 4099 | 4912 | 345 345 | Jiyū Minshutō 1193 | 300 | 58.1 | 22950404 | no-2001 | |||
150 | 150 | 185 | 679 679 | Sozialdemokratische Partei Deutschlands 558 | 298 | 40.9 | 20181269 | bwl | |||
339 | 339 | 413 | 645 645 | Jiyū Minshutō 1193 | 298 | 59.0 | 23480170 | no-2001 | |||
3288 | 3288 | 3953 | 223 223 | Conservatives 773 | 4958 4958 | 298 | craig | ||||
920 | 920 | 1102 | 568 568 | Conservatives 773 | 297 | 38.0 | 11872180 | ||||
5992 | 5992 | 7205 | 789 789 | Partito Democratico 382 | 7177 7177 | 297 | 26.27 | 8934009 | mdi | ||
3939 | 3939 | 4726 | 554 554 | Jiyū Minshutō 1193 | 296 | 38.18 | 25887798 | parline | |||
138 | 138 | 170 | 102 102 | Labour Party 1556 | 295 | 48.8 | 13948883 | ||||
8533 | 8533 | 9861 | 1032 1032 | Adalet ve Kalkınma Partisi 901 | 295 | 42.62 | 21335581 | hp | Electoral Alliance: People's Alliance (AKP, MHP) | ||
2310 | 2310 | 2762 | 640 640 | Jiyū Minshutō 1193 | 294 | 56.0 | 22972892 | no-2001 | |||
5917 | 5917 | 7128 | 788 788 | Jiyū Minshutō 1193 | 294 | 27.6 | 16624457 | er | |||
6517 | 6517 | 7766 | 812 812 | Anavatan Partisi 1334 | 292 | 36.31 | 8704335 | tuik | |||
7094 | 7094 | 8357 | 850 850 | Jiyū Minshutō 1193 | 290 | 33.11 | 17658916 | ||||
2451 | 2451 | 2934 | 311 311 | Labour Party 1556 | 288 | 43.1 | 12208758 | ||||
3798 | 3798 | 4564 | 603 603 | Jiyū Minshutō 1193 | 288 | 47.63 | 22381570 | parline | |||
8659 | 8659 | 9987 | 1040 1040 | Nationalsozialistische Deutsche Arbeiterpartei 2695 | 288 | 43.91 | 17277328 | wid | |||
7481 | 7481 | 8781 | 909 909 | Labour Party 1556 | 287 | 36.96 | 8370417 | bef-7 | |||
2524 | 2524 | 3026 | 113 113 | Jiyū Minshutō 1193 | 284 | 47.9 | 28262441 | parline | |||
786 | 786 | 938 | 386 386 | Gaulliste 1094 | 7681 7681 | 282 | 38.0 | 8422413 | mackie | ||
2464 | 2464 | 2947 | 625 625 | Conservatives 773 | 5062 5062 | 282 | craig | ||||
8435 | 8435 | 9755 | 1022 1022 | Jiyū Minshutō 1193 | 281 | 33.28 | 18555717 | mic | |||
2686 | 2686 | 3217 | 367 367 | Jiyū Minshutō 1193 | 280 | 49.2 | 22613191 | no-2001 | |||
5749 | 5749 | 6949 | 782 782 | Parti socialiste 1539 | 7533 7533 | 280 | 29.35 | 7618326 | ref | ||
3654 | 3654 | 4394 | 40 40 | Conservatives 773 | 277 | 35.8 | 10462565 | craig | |||
3998 | 3998 | 4792 | 678 678 | Labour Party 1556 | 277 | 46.4 | 12405254 | ||||
8487 | 8487 | 9810 | 111 111 | Forza Italia – Il Popolo della Libertà 596 | 7307 7307 | 276 | 38.23 | 13965781 | archivio, mdi | Electoral alliance: The People of Freedom (Il Popolo della Libertà) with National Alliance (Alleanza Nazionale) and smaller parties formed a united list, a parliamentary group and a party in 2009. | FI seats calculated by remainder of alliance seats |
3913 | 3913 | 4698 | 25 25 | Jiyū Minshutō 1193 | 275 | 46.16 | 30315417 | parline | |||
55 | 55 | 68 | 507 507 | Democrazia Cristiana 1633 | 273 | 42.4 | 12520207 | archivio | |||
84 | 84 | 101 | 514 514 | Labour Party 1556 | 271 | 34.9 | 11560484 | ||||
3653 | 3653 | 4393 | 333 333 | Jiyū Minshutō 1193 | 271 | 46.85 | 24563199 | parline | |||
2882 | 2882 | 3466 | 243 243 | Labour Party 1556 | 269 | 36.9 | 11532218 | ||||
1571 | 1571 | 1886 | 20 20 | Parti socialiste 1539 | 7618 7618 | 268 | 36.0 | 8947811 | no-2010 | ||
3319 | 3319 | 3987 | 445 445 | Christlich Demokratische Union 808 | 5568 5568 | 268 | 36.7 | 17055116 | bwl | ||
463 | 463 | 565 | 65 65 | Democrazia Cristiana 1633 | 266 | 38.7 | 12912466 | archivio | |||
3990 | 3990 | 4782 | 261 261 | Democrazia Cristiana 1633 | 266 | 39.1 | 12437848 | archivio | |||
4632 | 4632 | 5584 | 695 695 | Nihon Jiyūtō 1726 | 264 | 43.9 | 13420269 | mackie | |||
784 | 784 | 936 | 642 642 | Democrazia Cristiana 1633 | 263 | 40.1 | 10862073 | archivio | |||
2911 | 2911 | 3499 | 633 633 | Partidul Democrat 419 | 263 | 66.3 | 9089659 | essex | |||
2212 | 2212 | 2643 | 604 604 | Democrazia Cristiana 1633 | 262 | 38.3 | 14046291 | archivio | |||
3797 | 3797 | 4563 | 502 502 | Democrazia Cristiana 1633 | 262 | 38.7 | 14209519 | archivio | |||
8341 | 8341 | 9660 | 1013 1013 | Labour Party 1556 | 262 | 39.99 | 12878460 | bbc | |||
2274 | 2274 | 2720 | 380 380 | Democrazia Cristiana 1633 | 260 | 38.3 | 11773182 | archivio | |||
3986 | 3986 | 4778 | 643 643 | Parti socialiste 1539 | 7597 7597 | 260 | 34.9 | 8381827 | no-2010 | ||
7480 | 7480 | 8780 | 909 909 | Conservatives 773 | 260 | 38.22 | 8656225 | bef-7 | |||
2475 | 2475 | 2960 | 582 582 | Labour Party 1556 | 258 | 29.0 | 8609527 | bbc | |||
4073 | 4073 | 4882 | 161 161 | Labour Party 1556 | 258 | 43.8 | 12216172 | ||||
7467 | 7467 | 8762 | 907 907 | Conservatives 773 | 258 | 38.0 | 5514541 | bef-7 | |||
7908 | 7908 | 9219 | 975 975 | Adalet ve Kalkınma Partisi 901 | 258 | 40.87 | 18867411 | tuik | |||
6305 | 6305 | 7540 | 800 800 | Christlich Demokratische Union 808 | 7539 7539 | 255 | 34.1 | 14921877 | bwl | ||
27 | 27 | 34 | 595 595 | Sozialdemokratische Partei Deutschlands 558 | 252 | 36.4 | 17140354 | bwl | |||
3718 | 3718 | 4468 | 479 479 | Parti socialiste 1539 | 7551 7551 | 252 | 23.5 | 5977045 | asn, no-2010 | ||
1352 | 1352 | 1628 | 385 385 | Sozialdemokratische Partei Deutschlands 558 | 251 | 38.5 | 18488668 | bwl | |||
3918 | 3918 | 4703 | 138 138 | Jiyū Minshutō 1193 | 250 | 45.76 | 25982785 | parline | |||
4238 | 4238 | 5074 | 583 583 | Conservatives 773 | 1458 1458 | 250 | craig | ||||
1549 | 1549 | 1857 | 53 53 | Jiyū Minshutō 1193 | 249 | 41.78 | 23653626 | parline | |||
1428 | 1428 | 1717 | 664 664 | Rassemblement pour la république 138 | 7589 7589 | 248 | 20.4 | 5188196 | asn, no-2010 | ||
1959 | 1959 | 2347 | 433 433 | Jiyū Minshutō 1193 | 248 | 44.59 | 24084140 | parline | |||
9554 | 9554 | 10918 | 1110 1110 | La République En Marche! | Renaissance 2643 | 245 | 25.75 | 5857364 | ref | Electoral alliance: Ensemble (Ensemble Citoyens) | ||
805 | 805 | 963 | 595 595 | Christlich Demokratische Union 808 | 5569 5569 | 244 | 34.2 | 16089960 | bwl | ||
4599 | 4599 | 5551 | 694 694 | Nihon Jiyūtō 1726 | 240 | 47.9 | 16937225 | mackie | |||
345 | 345 | 421 | 445 445 | Sozialdemokratische Partei Deutschlands 558 | 239 | 33.5 | 15545366 | bwl | |||
1728 | 1728 | 2076 | 628 628 | Jiyū Minshutō 1193 | 239 | 32.76 | 18205955 | parline | |||
8029 | 8029 | 9341 | 986 986 | Parti radical-socialiste 401 | 239 | 28.53 | 2515000 | no-2010 | |||
525 | 525 | 638 | 511 511 | Jiyū Minshutō 1193 | 237 | 35.0 | 20660185 | ejpr |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE election_result("id", "election_id", "party_id", "alliance_id", "seats", "vote_share", "votes", "data_source", "description", "comment", FOREIGN KEY([election_id]) REFERENCES [election]([id]), FOREIGN KEY([party_id]) REFERENCES [party]([id]), FOREIGN KEY([alliance_id]) REFERENCES [election_result]([id]), FOREIGN KEY([data_source]) REFERENCES [info_data_source]([key]) );