election_result
Data source: ParlGov · About: simonw/parlgov-datasette
9,716 rows sorted by data_source descending
This data as json, CSV (advanced)
Link | rowid | id | election_id | party_id | alliance_id | seats | vote_share | votes | data_source ▲ | description | comment |
---|---|---|---|---|---|---|---|---|---|---|---|
8137 | 8137 | 9450 | 997 997 | Sosyal Demokrat Halçi Parti | Cumhuriyet Halk Partisi 507 | 134 | 25.32 | 12111812 | ysk | |||
8138 | 8138 | 9451 | 997 997 | Milliyetçi Hareket Partisi 408 | 40 | 11.9 | 5694136 | ysk | |||
8139 | 8139 | 9452 | 997 997 | Halkların Demokratik Partisi 2572 | 59 | 10.76 | 5148085 | ysk | |||
8140 | 8140 | 9453 | 997 997 | Adalet ve Kalkınma Partisi 901 | 317 | 49.5 | 23681926 | ysk | |||
3017 | 3017 | 3623 | 575 575 | Pienviljelijäin ja maalaiskansan puolue 2293 | 0 | 0.27 | 4964 | yle | |||
4795 | 4795 | 5783 | 297 297 | Pienviljelijäin ja maalaiskansan puolue 2293 | 2 | 2.14 | 27783 | yle | |||
6463 | 6463 | 7705 | 340 340 | no seat 2054 | 0 | 0.15 | 1341 | yle | Talonpoikaiskansan puolue (Peasants' Party) | ||
6465 | 6465 | 7707 | 297 297 | no seat 2054 | 0.46 | 5980 | yle | Ruotsalainen vapaamielinen puolue – Svenska frisinnade partiet (Liberal Swedish Party) | |||
33 | 33 | 41 | 48 48 | Miljöpartiet de Gröna 1154 | 0 | 1.5 | 83645 | yb-swe | |||
1283 | 1283 | 1543 | 48 48 | Kristdemokraterna 282 | 2208 2208 | 1 | 0 | yb-swe | |||
1320 | 1320 | 1589 | 48 48 | Moderaterna 657 | 76 | 21.3 | 1187335 | yb-swe | |||
1334 | 1334 | 1605 | 48 48 | Vänsterpartiet (kommunisterna) 882 | 19 | 5.4 | 298419 | yb-swe | |||
1844 | 1844 | 2208 | 48 48 | Centerpartiet 1461 | 43 | 12.4 | 691258 | yb-swe | |||
3231 | 3231 | 3882 | 48 48 | Folkpartiet 892 | 51 | 14.2 | 792268 | yb-swe | |||
3406 | 3406 | 4092 | 48 48 | Socialdemokraterna 904 | 159 | 44.7 | 2487551 | yb-swe | |||
3508 | 3508 | 4222 | 41 41 | Kristdemokraterna 282 | 0 | 1.8 | 75389 | yb-swe | |||
4414 | 4414 | 5271 | 41 41 | Medborgerlig samling 802 | 3 | 1.5 | 64807 | yb-swe | |||
158 | 158 | 194 | 421 421 | Labour Party 878 | 41 | 48.31 | 559096 | yb-nzl | |||
179 | 179 | 219 | 56 56 | Labour Party 878 | 56 | 42.98 | 829154 | yb-nzl | |||
183 | 183 | 223 | 513 513 | Labour Party 878 | 43 | 39.01 | 702630 | yb-nzl | |||
205 | 205 | 249 | 117 117 | National Party 997 | 45 | 47.07 | 563875 | yb-nzl | |||
272 | 272 | 328 | 634 634 | Labour Party 878 | 45 | 34.68 | 666759 | yb-nzl | |||
408 | 408 | 497 | 321 321 | Labour Party 878 | 35 | 44.13 | 484082 | yb-nzl | |||
517 | 517 | 629 | 459 459 | Labour Party 878 | 32 | 39.7 | 636319 | yb-nzl | |||
534 | 534 | 648 | 561 561 | Alliance 1444 | 13 | 10.1 | 209347 | yb-nzl | |||
653 | 653 | 784 | 350 350 | New Labour Party 930 | 1 | 5.16 | 94171 | yb-nzl | |||
699 | 699 | 838 | 56 56 | Social Credit | Democratic Party 1636 | 2 | 7.63 | 147162 | yb-nzl | |||
846 | 846 | 1011 | 350 350 | National Party 997 | 67 | 47.82 | 872358 | yb-nzl | |||
856 | 856 | 1023 | 561 561 | New Zealand First Party 891 | 17 | 13.35 | 276603 | yb-nzl | |||
907 | 907 | 1082 | 202 202 | National Party 997 | 51 | 39.82 | 680991 | yb-nzl | |||
965 | 965 | 1149 | 561 561 | United New Zealand 917 | 1 | 0.88 | 18245 | yb-nzl | |||
1173 | 1173 | 1413 | 459 459 | National Party 997 | 55 | 47.44 | 760365 | yb-nzl | |||
1291 | 1291 | 1551 | 322 322 | National Party 997 | 39 | 44.02 | 806305 | yb-nzl | |||
1420 | 1420 | 1706 | 350 350 | Labour Party 878 | 29 | 35.14 | 640915 | yb-nzl | |||
1434 | 1434 | 1723 | 666 666 | National Party 997 | 46 | 47.59 | 557046 | yb-nzl | |||
1852 | 1852 | 2219 | 1 1 | National Party 997 | 32 | 41.5 | 581422 | yb-nzl | |||
2290 | 2290 | 2740 | 561 561 | Labour Party 878 | 37 | 28.19 | 584159 | yb-nzl | |||
2458 | 2458 | 2941 | 120 120 | National Party 997 | 45 | 45.22 | 605960 | yb-nzl | |||
2513 | 2513 | 3012 | 634 634 | National Party 997 | 50 | 35.05 | 673892 | yb-nzl | |||
2525 | 2525 | 3028 | 56 56 | National Party 997 | 37 | 35.89 | 692494 | yb-nzl | |||
2631 | 2631 | 3153 | 202 202 | Labour Party 878 | 40 | 40.41 | 691076 | yb-nzl | |||
2892 | 2892 | 3477 | 322 322 | Labour Party 878 | 58 | 47.96 | 878448 | yb-nzl | |||
3369 | 3369 | 4043 | 202 202 | Social Credit | Democratic Party 1636 | 1 | 16.07 | 274756 | yb-nzl | |||
3427 | 3427 | 4122 | 1 1 | Labour Party 878 | 55 | 48.37 | 677669 | yb-nzl | |||
3489 | 3489 | 4198 | 120 120 | Labour Party 878 | 39 | 44.18 | 592055 | yb-nzl | |||
3533 | 3533 | 4250 | 391 391 | Labour Party 878 | 35 | 41.44 | 499392 | yb-nzl | |||
3535 | 3535 | 4252 | 634 634 | Alliance 1444 | 2 | 18.21 | 350064 | yb-nzl | |||
3591 | 3591 | 4318 | 391 391 | National Party 997 | 44 | 43.64 | 525945 | yb-nzl | |||
3750 | 3750 | 4506 | 634 634 | New Zealand First Party 891 | 2 | 8.4 | 161481 | yb-nzl | |||
3767 | 3767 | 4526 | 561 561 | ACT New Zealand 617 | 8 | 6.1 | 126442 | yb-nzl | |||
3812 | 3812 | 4581 | 561 561 | National Party 997 | 44 | 33.84 | 701315 | yb-nzl | |||
3900 | 3900 | 4681 | 321 321 | National Party 997 | 45 | 44.28 | 485630 | yb-nzl | |||
3956 | 3956 | 4744 | 513 513 | National Party 997 | 47 | 38.78 | 698508 | yb-nzl | |||
4309 | 4309 | 5155 | 513 513 | Social Credit | Democratic Party 1636 | 2 | 20.65 | 372056 | yb-nzl | |||
4316 | 4316 | 5162 | 117 117 | Labour Party 878 | 35 | 43.74 | 524066 | yb-nzl | |||
4351 | 4351 | 5200 | 391 391 | Social Credit | Democratic Party 1636 | 1 | 14.48 | 174515 | yb-nzl | |||
4439 | 4439 | 5300 | 666 666 | Labour Party 878 | 34 | 43.42 | 508179 | yb-nzl | |||
4492 | 4492 | 5368 | 421 421 | National Party 997 | 39 | 44.21 | 511699 | yb-nzl | |||
4749 | 4749 | 5723 | 1 1 | Social Credit | Democratic Party 1636 | 0 | 6.65 | 93231 | yb-nzl | |||
4750 | 4750 | 5724 | 1 1 | Values Party 1761 | 0 | 1.96 | 27467 | yb-nzl | |||
5715 | 5715 | 6911 | 421 421 | Social Credit | Democratic Party 1636 | 0 | 7.22 | 83498 | yb-nzl | |||
5716 | 5716 | 6912 | 321 321 | Social Credit | Democratic Party 1636 | 0 | 11.13 | 122068 | yb-nzl | |||
5717 | 5717 | 6913 | 666 666 | Social Credit | Democratic Party 1636 | 0 | 8.62 | 100905 | yb-nzl | |||
5718 | 5718 | 6914 | 117 117 | Social Credit | Democratic Party 1636 | 0 | 7.94 | 95176 | yb-nzl | |||
5720 | 5720 | 6916 | 120 120 | Social Credit | Democratic Party 1636 | 0 | 9.07 | 121576 | yb-nzl | |||
5721 | 5721 | 6917 | 459 459 | Social Credit | Democratic Party 1636 | 0 | 7.43 | 119123 | yb-nzl | |||
5722 | 5722 | 6918 | 459 459 | Values Party 1761 | 0 | 5.19 | 83213 | yb-nzl | |||
5723 | 5723 | 6919 | 202 202 | Values Party 1761 | 0 | 2.41 | 41220 | yb-nzl | |||
5724 | 5724 | 6920 | 513 513 | no seat 2070 | 0 | 0.46 | 8332 | yb-nzl | Mana Motuhake | ||
5725 | 5725 | 6922 | 322 322 | Social Credit | Democratic Party 1636 | 0 | 5.74 | 105091 | yb-nzl | |||
5726 | 5726 | 6923 | 350 350 | Social Credit | Democratic Party 1636 | 0 | 1.67 | 30455 | yb-nzl | |||
5727 | 5727 | 6924 | 350 350 | Green Party 1171 | 0 | 6.85 | 124915 | yb-nzl | |||
5728 | 5728 | 6925 | 634 634 | Christian Heritage Party of New Zealand 2072 | 0 | 2.02 | 38749 | yb-nzl | |||
5729 | 5729 | 6926 | 561 561 | Christian Heritage Party of New Zealand 2072 | 0 | 4.33 | 89716 | yb-nzl | Electoral alliance: Christian Coalition | ||
5738 | 5738 | 6935 | 56 56 | New Zealand Party 2075 | 0 | 12.25 | 236385 | yb-nzl | |||
89 | 89 | 107 | 478 478 | Kristelig Folkeparti 1538 | 9 | 8.36 | 147068 | yb-nor | |||
1796 | 1796 | 2152 | 478 478 | Høyre 1435 | 7751 7751 | 21 | 15.91 | 279790 | yb-nor | ||
2241 | 2241 | 2680 | 517 517 | Sosialistisk Folkeparti 1773 | 2 | 6.0 | 122721 | yb-nor | |||
2622 | 2622 | 3141 | 478 478 | Venstre 647 | 7751 7751 | 20 | 12.45 | 218866 | yb-nor | ||
3295 | 3295 | 3960 | 478 478 | Norges Kommunistiske Parti 27 | 0 | 5.84 | 102722 | yb-nor | |||
3773 | 3773 | 4534 | 622 622 | Sosialistisk Folkeparti 1773 | 2 | 2.4 | 43996 | yb-nor | |||
4035 | 4035 | 4832 | 580 580 | Sosialistisk Folkeparti 1773 | 0 | 3.4 | 73284 | yb-nor | |||
4159 | 4159 | 4979 | 478 478 | Senterpartiet 702 | 7751 7751 | 6 | 4.86 | 85418 | yb-nor | ||
5807 | 5807 | 7007 | 523 523 | Rød Valgallianse 1638 | 0 | 0.43 | 9360 | yb-nor | |||
5808 | 5808 | 7008 | 429 429 | no seat 2100 | 0 | 0.52 | 9360 | yb-nor | Norwegian Social Democratic Party (Norsk Sosialdemokratisk Parti) | ||
6504 | 6504 | 7751 | 478 478 | Felleslister borgerlige 2194 | 9 | 6.14 | 107913 | yb-nor | Joint electoral list: Bondepartiet (Farmer's Party, 6 seats) Høyre (Conservative Party, 2 seats) and Venstre (Liberal Party, 1 seat) | ||
56 | 56 | 69 | 128 128 | Socialistisk Folkeparti 1644 | 1 | 9.2 | 183580 | yb-dnk | |||
77 | 77 | 92 | 668 668 | Socialdemokraterne 1629 | 3 | 16.5 | 324256 | yb-dnk | |||
127 | 127 | 156 | 668 668 | Centrumdemokraterne 1324 | 0 | 3.5 | 68717 | yb-dnk | |||
173 | 173 | 211 | 128 128 | Konservative 590 | 4 | 20.8 | 414177 | yb-dnk | |||
215 | 215 | 259 | 121 121 | Danmarks Kommunistiske Parti 1239 | 18 | 12.5 | 255236 | yb-dnk | |||
269 | 269 | 323 | 434 434 | Konservative 590 | 3 | 17.7 | 368890 | yb-dnk | |||
393 | 393 | 479 | 308 308 | Venstre 1605 | 3 | 16.6 | 297565 | yb-dnk | |||
495 | 495 | 604 | 434 434 | Det Radikale Venstre 211 | 1 | 8.5 | 176480 | yb-dnk | |||
504 | 504 | 615 | 430 430 | Konservative 590 | 27 | 17.8 | 365236 | yb-dnk | |||
515 | 515 | 627 | 668 668 | Kristeligt Folkeparti 1331 | 0 | 2.0 | 39128 | yb-dnk | |||
529 | 529 | 643 | 668 668 | Det Radikale Venstre 211 | 1 | 9.1 | 180089 | yb-dnk | |||
591 | 591 | 712 | 430 430 | Det Radikale Venstre 211 | 12 | 8.2 | 167969 | yb-dnk | |||
680 | 680 | 817 | 168 168 | Det Radikale Venstre 211 | 1 | 6.4 | 120473 | yb-dnk | |||
895 | 895 | 1069 | 668 668 | Socialistisk Folkeparti 1644 | 1 | 7.1 | 140053 | yb-dnk |
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]) );