view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by country_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SVK | Slovakia | parliament | 1990-06-09 | 29.35 | 48 | 150 | VPN | Verejnosť proti násiliu | Public against Violence | 6.0 | 1 | 538 | 1061 | ||
SVK | Slovakia | parliament | 1990-06-09 | 19.21 | 31 | 150 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 538 | 1432 | ||
SVK | Slovakia | parliament | 1990-06-09 | 13.35 | 22 | 150 | SDL | Strana demokratickej ľavice | Party of the Democratic Left | 3.2398 | 1 | 538 | 1415 | ||
SVK | Slovakia | parliament | 1990-06-09 | 13.94 | 22 | 150 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 538 | 1072 | ||
SVK | Slovakia | parliament | 1990-06-09 | 8.66 | 14 | 150 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 538 | 559 | ||
SVK | Slovakia | parliament | 1990-06-09 | 4.4 | 7 | 150 | DS | Demokratická strana | Democratic Party | 6.2 | 1 | 538 | 1000 | ||
SVK | Slovakia | parliament | 1990-06-09 | 3.49 | 6 | 150 | SZS | Strana zelených | Green Party | 2.5 | 1 | 538 | 874 | ||
SVK | Slovakia | parliament | 1990-06-09 | 1.78 | 0 | 150 | SSL | Strana slobody | Freedom Party | 6.0 | 1 | 538 | 2232 | ||
SVK | Slovakia | parliament | 1990-06-09 | 2.52 | 0 | 150 | SPV | Spojenestvo poľnohospodárov a vidieka | Alliance of Farmers and the Countryside | 5.3 | 1 | 538 | 2233 | ||
SVK | Slovakia | parliament | 1990-06-09 | 1.82 | 0 | 150 | SDSS | Sociálnodemokratická strana Slovenska | Social Democratic Party of Slovakia | 4.8111 | 1 | 538 | 1651 | ||
SVK | Slovakia | parliament | 1992-06-06 | 37.26 | 74 | 150 | HZDS | Hnutie za demokratické Slovensko | Movement for a Democratic Slovakia | 4.8914 | 1 | 294 | 538 | 436 | 1142 |
SVK | Slovakia | parliament | 1992-06-06 | 14.7 | 29 | 150 | SDL | Strana demokratickej ľavice | Party of the Democratic Left | 3.2398 | 1 | 294 | 538 | 436 | 1415 |
SVK | Slovakia | parliament | 1992-06-06 | 8.89 | 18 | 150 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 294 | 538 | 436 | 1432 |
SVK | Slovakia | parliament | 1992-06-06 | 7.93 | 15 | 150 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 294 | 538 | 436 | 1072 |
SVK | Slovakia | parliament | 1992-06-06 | 9 | 150 | S-E | Spolužitie – Együttélés | Coexistence | 7.4 | 1 | 294 | 538 | 436 | 2248 | |
SVK | Slovakia | parliament | 1992-06-06 | 5 | 150 | MKDM | Maďarské kresťanskodemokratické hnutie – Magyar kereszténydemokrata mozgalom | Hungarian Christian Democratic Movement | 6.6667 | 1 | 294 | 538 | 436 | 2247 | |
SVK | Slovakia | parliament | 1992-06-06 | 4.0 | 0 | 150 | SDSS | Sociálnodemokratická strana Slovenska | Social Democratic Party of Slovakia | 4.8111 | 1 | 294 | 538 | 436 | 1651 |
SVK | Slovakia | parliament | 1992-06-06 | 3.05 | 0 | 150 | KSU | Krest’anská sociálna únia Slovenska | Christian Social Union | 6.6667 | 1 | 294 | 538 | 436 | 936 |
SVK | Slovakia | parliament | 1992-06-06 | 2.14 | 0 | 150 | SZS | Strana zelených | Green Party | 2.5 | 1 | 294 | 538 | 436 | 874 |
SVK | Slovakia | parliament | 1992-06-06 | 4.04 | 0 | 150 | VPN | Verejnosť proti násiliu | Public against Violence | 6.0 | 1 | 294 | 538 | 436 | 1061 |
SVK | Slovakia | parliament | 1992-06-06 | 1.08 | 0 | 150 | SZ-92 | Strana zelených – 1992 | Green Party -- 1992 | 2.5 | 1 | 294 | 538 | 436 | 2235 |
SVK | Slovakia | parliament | 1992-06-06 | 3.31 | 0 | 150 | DS | Demokratická strana | Democratic Party | 6.2 | 1 | 294 | 538 | 436 | 1000 |
SVK | Slovakia | parliament | 1992-06-06 | 2.29 | 0 | 150 | MOS | Maďarská občianska strana – Magyar polgári párt | Hungarian Civic Party | 6.0 | 1 | 294 | 538 | 436 | 2246 |
SVK | Slovakia | parliament | 1992-06-06 | 7.42 | 150 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 294 | 538 | 436 | 559 | |
SVK | Slovakia | parliament | 1994-10-01 | 34.97 | 61 | 150 | HZDS | Hnutie za demokratické Slovensko | Movement for a Democratic Slovakia | 4.8914 | 1 | 119 | 294 | 817 | 1142 |
SVK | Slovakia | parliament | 1994-10-01 | 10.42 | 18 | 150 | SV | Spoločná voľba | Common Choice | 1.3 | 1 | 119 | 294 | 817 | 527 |
SVK | Slovakia | parliament | 1994-10-01 | 10.08 | 17 | 150 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 119 | 294 | 817 | 1432 |
SVK | Slovakia | parliament | 1994-10-01 | 8.57 | 15 | 150 | DUS | Demokratická únia | Democratic Union | 6.0 | 1 | 119 | 294 | 817 | 1495 |
SVK | Slovakia | parliament | 1994-10-01 | 7.35 | 13 | 150 | ZRS | Združenie robotníkov Slovenska | Association of Workers of Slovakia | 1.3 | 1 | 119 | 294 | 817 | 1563 |
SVK | Slovakia | parliament | 1994-10-01 | 5.4 | 9 | 150 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 119 | 294 | 817 | 1072 |
SVK | Slovakia | parliament | 1994-10-01 | 9 | 150 | S-E | Spolužitie – Együttélés | Coexistence | 7.4 | 1 | 119 | 294 | 817 | 2248 | |
SVK | Slovakia | parliament | 1994-10-01 | 7 | 150 | MKDM | Maďarské kresťanskodemokratické hnutie – Magyar kereszténydemokrata mozgalom | Hungarian Christian Democratic Movement | 6.6667 | 1 | 119 | 294 | 817 | 2247 | |
SVK | Slovakia | parliament | 1994-10-01 | 1 | 150 | MOS | Maďarská občianska strana – Magyar polgári párt | Hungarian Civic Party | 6.0 | 1 | 119 | 294 | 817 | 2246 | |
SVK | Slovakia | parliament | 1994-10-01 | 3.43 | 0 | 150 | DS | Demokratická strana | Democratic Party | 6.2 | 1 | 119 | 294 | 817 | 1000 |
SVK | Slovakia | parliament | 1994-10-01 | 2.72 | 0 | 150 | KSS | Komunistická strana Slovenska | Communist Party of Slovakia | 0.5275 | 1 | 119 | 294 | 817 | 44 |
SVK | Slovakia | parliament | 1994-10-01 | 2.06 | 0 | 150 | KSU | Krest’anská sociálna únia Slovenska | Christian Social Union | 6.6667 | 1 | 119 | 294 | 817 | 936 |
SVK | Slovakia | parliament | 1994-10-01 | 1.33 | 0 | 150 | NS | Nové Slovensko | New Slovakia | 1 | 119 | 294 | 817 | 2237 | |
SVK | Slovakia | parliament | 1994-10-01 | 1.32 | 0 | 150 | SPK | Strana proti korupcii, za poriadok, prácu a peniaze pre všetkých slušných obcanov | Party against Corruption, for Order, Labour and Money for all Decent Citizens | 1 | 119 | 294 | 817 | 2238 | |
SVK | Slovakia | parliament | 1994-10-01 | 1.05 | 0 | 150 | HZPCS | Hnutie za prosperujúce Cesko a Slovensko | Movement for a Prosperous Czechia and Slovakia | 1 | 119 | 294 | 817 | 2239 | |
SVK | Slovakia | parliament | 1994-10-01 | 10.19 | 150 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 119 | 294 | 817 | 559 | |
SVK | Slovakia | parliament | 1998-09-26 | 27.0 | 43 | 150 | HZDS | Hnutie za demokratické Slovensko | Movement for a Democratic Slovakia | 4.8914 | 1 | 349 | 119 | 26 | 1142 |
SVK | Slovakia | parliament | 1998-09-26 | 26.33 | 42 | 150 | SDK | Slovenská demokratická koalícia | Slovak Democratic Coalition | 7.19 | 1 | 349 | 119 | 26 | 313 |
SVK | Slovakia | parliament | 1998-09-26 | 14.66 | 23 | 150 | SDL | Strana demokratickej ľavice | Party of the Democratic Left | 3.2398 | 1 | 349 | 119 | 26 | 1415 |
SVK | Slovakia | parliament | 1998-09-26 | 9.12 | 15 | 150 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 349 | 119 | 26 | 559 |
SVK | Slovakia | parliament | 1998-09-26 | 9.07 | 14 | 150 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 349 | 119 | 26 | 1072 |
SVK | Slovakia | parliament | 1998-09-26 | 8.01 | 13 | 150 | SOP | Strana občianskeho porozumenia | Party of Civic Understanding | 3.3 | 1 | 349 | 119 | 26 | 1016 |
SVK | Slovakia | parliament | 1998-09-26 | 2.79 | 0 | 150 | KSS | Komunistická strana Slovenska | Communist Party of Slovakia | 0.5275 | 1 | 349 | 119 | 26 | 44 |
SVK | Slovakia | parliament | 1998-09-26 | 1.3 | 0 | 150 | ZRS | Združenie robotníkov Slovenska | Association of Workers of Slovakia | 1.3 | 1 | 349 | 119 | 26 | 1563 |
SVK | Slovakia | parliament | 2002-09-21 | 19.5 | 36 | 150 | HZDS | Hnutie za demokratické Slovensko | Movement for a Democratic Slovakia | 4.8914 | 1 | 218 | 349 | 699 | 1142 |
SVK | Slovakia | parliament | 2002-09-21 | 15.09 | 28 | 150 | SDKU-DS | Slovenská demokratická a kresťanská únia – Demokratická strana | Slovak Democratic and Christian Union -- Democratic Party | 7.3591 | 1 | 218 | 349 | 699 | 131 |
SVK | Slovakia | parliament | 2002-09-21 | 13.46 | 25 | 150 | Smer | Smer – sociálna demokracia | Direction -- Social Democracy | 3.3799 | 1 | 218 | 349 | 699 | 220 |
SVK | Slovakia | parliament | 2002-09-21 | 11.16 | 20 | 150 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 218 | 349 | 699 | 559 |
SVK | Slovakia | parliament | 2002-09-21 | 8.01 | 15 | 150 | ANO | Aliancia nového občana | Alliance of the New Citizen | 7.2404 | 1 | 218 | 349 | 699 | 1200 |
SVK | Slovakia | parliament | 2002-09-21 | 8.25 | 15 | 150 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 218 | 349 | 699 | 1432 |
SVK | Slovakia | parliament | 2002-09-21 | 6.32 | 11 | 150 | KSS | Komunistická strana Slovenska | Communist Party of Slovakia | 0.5275 | 1 | 218 | 349 | 699 | 44 |
SVK | Slovakia | parliament | 2002-09-21 | 3.32 | 0 | 150 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 218 | 349 | 699 | 1072 |
SVK | Slovakia | parliament | 2002-09-21 | 1.36 | 0 | 150 | SDL | Strana demokratickej ľavice | Party of the Democratic Left | 3.2398 | 1 | 218 | 349 | 699 | 1415 |
SVK | Slovakia | parliament | 2002-09-21 | 3.65 | 0 | 150 | PSNS | Pravá Slovenská národná strana | Real Slovak National Party | 8.5 | 1 | 218 | 349 | 699 | 20 |
SVK | Slovakia | parliament | 2002-09-21 | 1.79 | 0 | 150 | SDA | Sociálnodemokratická alternatíva | Social Democratic Alternative | 3.0526 | 1 | 218 | 349 | 699 | 64 |
SVK | Slovakia | parliament | 2002-09-21 | 3.28 | 0 | 150 | HZD | Hnutie za demokraciu | Movement for Democracy | 7.4 | 1 | 218 | 349 | 699 | 2160 |
SVK | Slovakia | ep | 2004-06-13 | 16.89 | 3 | 14 | Smer | Smer – sociálna demokracia | Direction -- Social Democracy | 3.3799 | 1 | 124 | 218 | 547 | 220 |
SVK | Slovakia | ep | 2004-06-13 | 17.04 | 3 | 14 | HZDS | Hnutie za demokratické Slovensko | Movement for a Democratic Slovakia | 4.8914 | 1 | 124 | 218 | 547 | 1142 |
SVK | Slovakia | ep | 2004-06-13 | 16.19 | 3 | 14 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 124 | 218 | 547 | 1432 |
SVK | Slovakia | ep | 2004-06-13 | 17.09 | 3 | 14 | SDKU-DS | Slovenská demokratická a kresťanská únia – Demokratická strana | Slovak Democratic and Christian Union -- Democratic Party | 7.3591 | 1 | 124 | 218 | 547 | 131 |
SVK | Slovakia | ep | 2004-06-13 | 13.24 | 2 | 14 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 124 | 218 | 547 | 559 |
SVK | Slovakia | ep | 2004-06-13 | 4.65 | 0 | 14 | ANO | Aliancia nového občana | Alliance of the New Citizen | 7.2404 | 1 | 124 | 218 | 547 | 1200 |
SVK | Slovakia | ep | 2004-06-13 | 4.54 | 0 | 14 | KSS | Komunistická strana Slovenska | Communist Party of Slovakia | 0.5275 | 1 | 124 | 218 | 547 | 44 |
SVK | Slovakia | ep | 2004-06-13 | 3.25 | 0 | 14 | SF | Slobodné fórum | Free Forum | 5.46 | 1 | 124 | 218 | 547 | 752 |
SVK | Slovakia | ep | 2004-06-13 | 2.01 | 0 | 14 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 124 | 218 | 547 | 1072 |
SVK | Slovakia | ep | 2004-06-13 | 1.0 | 0 | 14 | OKS | Obcianska konzervatívna strana | Civic Conservative Party | 8.4211 | 1 | 124 | 218 | 547 | 1645 |
SVK | Slovakia | ep | 2004-06-13 | 1.69 | 0 | 14 | Lu+Ls | Ludová únia – Liberálna strana | People's Union -- Liberal Party | 7.3684 | 1 | 124 | 218 | 547 | 1615 |
SVK | Slovakia | parliament | 2006-06-17 | 29.14 | 50 | 150 | Smer | Smer – sociálna demokracia | Direction -- Social Democracy | 3.3799 | 1 | 192 | 218 | 185 | 220 |
SVK | Slovakia | parliament | 2006-06-17 | 18.35 | 31 | 150 | SDKU-DS | Slovenská demokratická a kresťanská únia – Demokratická strana | Slovak Democratic and Christian Union -- Democratic Party | 7.3591 | 1 | 192 | 218 | 185 | 131 |
SVK | Slovakia | parliament | 2006-06-17 | 11.73 | 20 | 150 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 192 | 218 | 185 | 1072 |
SVK | Slovakia | parliament | 2006-06-17 | 11.68 | 20 | 150 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 192 | 218 | 185 | 559 |
SVK | Slovakia | parliament | 2006-06-17 | 8.79 | 15 | 150 | HZDS | Hnutie za demokratické Slovensko | Movement for a Democratic Slovakia | 4.8914 | 1 | 192 | 218 | 185 | 1142 |
SVK | Slovakia | parliament | 2006-06-17 | 8.31 | 14 | 150 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 192 | 218 | 185 | 1432 |
SVK | Slovakia | parliament | 2006-06-17 | 3.88 | 0 | 150 | KSS | Komunistická strana Slovenska | Communist Party of Slovakia | 0.5275 | 1 | 192 | 218 | 185 | 44 |
SVK | Slovakia | parliament | 2006-06-17 | 1.42 | 0 | 150 | ANO | Aliancia nového občana | Alliance of the New Citizen | 7.2404 | 1 | 192 | 218 | 185 | 1200 |
SVK | Slovakia | parliament | 2006-06-17 | 3.47 | 0 | 150 | SF | Slobodné fórum | Free Forum | 5.46 | 1 | 192 | 218 | 185 | 752 |
SVK | Slovakia | ep | 2009-06-07 | 32.01 | 5 | 13 | Smer | Smer – sociálna demokracia | Direction -- Social Democracy | 3.3799 | 1 | 441 | 192 | 269 | 220 |
SVK | Slovakia | ep | 2009-06-07 | 16.98 | 2 | 13 | SDKU-DS | Slovenská demokratická a kresťanská únia – Demokratická strana | Slovak Democratic and Christian Union -- Democratic Party | 7.3591 | 1 | 441 | 192 | 269 | 131 |
SVK | Slovakia | ep | 2009-06-07 | 11.33 | 2 | 13 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 441 | 192 | 269 | 559 |
SVK | Slovakia | ep | 2009-06-07 | 10.87 | 2 | 13 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 441 | 192 | 269 | 1432 |
SVK | Slovakia | ep | 2009-06-07 | 8.97 | 1 | 13 | HZDS | Hnutie za demokratické Slovensko | Movement for a Democratic Slovakia | 4.8914 | 1 | 441 | 192 | 269 | 1142 |
SVK | Slovakia | ep | 2009-06-07 | 5.55 | 1 | 13 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 441 | 192 | 269 | 1072 |
SVK | Slovakia | ep | 2009-06-07 | 4.71 | 0 | 13 | SaS | Sloboda a solidarita | Freedom and Solidarity | 6.0 | 1 | 441 | 192 | 269 | 1460 |
SVK | Slovakia | ep | 2009-06-07 | 2.11 | 0 | 13 | SZS | Strana zelených | Green Party | 2.5 | 1 | 441 | 192 | 269 | 874 |
SVK | Slovakia | ep | 2009-06-07 | 2.1 | 0 | 13 | OKS | Obcianska konzervatívna strana | Civic Conservative Party | 8.4211 | 1 | 441 | 192 | 269 | 1645 |
SVK | Slovakia | ep | 2009-06-07 | 1.65 | 0 | 13 | KSS | Komunistická strana Slovenska | Communist Party of Slovakia | 0.5275 | 1 | 441 | 192 | 269 | 44 |
SVK | Slovakia | ep | 2009-06-07 | 1.57 | 0 | 13 | SF | Slobodné fórum | Free Forum | 5.46 | 1 | 441 | 192 | 269 | 752 |
SVK | Slovakia | parliament | 2010-06-12 | 34.79 | 62 | 150 | Smer | Smer – sociálna demokracia | Direction -- Social Democracy | 3.3799 | 1 | 524 | 192 | 269 | 220 |
SVK | Slovakia | parliament | 2010-06-12 | 15.42 | 28 | 150 | SDKU-DS | Slovenská demokratická a kresťanská únia – Demokratická strana | Slovak Democratic and Christian Union -- Democratic Party | 7.3591 | 1 | 524 | 192 | 269 | 131 |
SVK | Slovakia | parliament | 2010-06-12 | 12.14 | 18 | 150 | SaS | Sloboda a solidarita | Freedom and Solidarity | 6.0 | 1 | 524 | 192 | 269 | 1460 |
SVK | Slovakia | parliament | 2010-06-12 | 8.52 | 15 | 150 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 524 | 192 | 269 | 1432 |
SVK | Slovakia | parliament | 2010-06-12 | 8.12 | 10 | 150 | MH | Most-Híd | Most-Hid | 7.4 | 1 | 524 | 192 | 269 | 1620 |
SVK | Slovakia | parliament | 2010-06-12 | 5.07 | 9 | 150 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 524 | 192 | 269 | 1072 |
SVK | Slovakia | parliament | 2010-06-12 | 4 | 150 | OLaNO | Obyčajní ľudia a nezávislé osobnosti | Ordinary People and Independent | 7.4 | 1 | 524 | 192 | 269 | 1759 | |
SVK | Slovakia | parliament | 2010-06-12 | 4 | 150 | OKS | Obcianska konzervatívna strana | Civic Conservative Party | 8.4211 | 1 | 524 | 192 | 269 | 1645 | |
SVK | Slovakia | parliament | 2010-06-12 | 2.41 | 0 | 150 | SDL-05 | Strana demokratickej ľavice – 2005 | Party of the Democratic Left -- 2005 | 3.3 | 1 | 524 | 192 | 269 | 2317 |
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;