view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
30 rows where "election_date" is on date 1992-06-06 sorted by party_name_english
This data as json, CSV (advanced)
Suggested facets: country_name, seats, left_right, election_id, previous_parliament_election_id
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 | 1992-06-06 | 8.89 | 18 | 150 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 294 | 538 | 436 | 1432 |
CZE | Czech Republic | parliament | 1992-06-06 | 10 | 200 | KDS | Krestanskodemokraticka strana | Christian Democratic Party | 8.1444 | 68 | 39 | 63 | 262 | 440 | |
CZE | Czech Republic | parliament | 1992-06-06 | 6.28 | 15 | 200 | KDU-CSL | Křesťanská a demokratická unie – Československá strana lidová | Christian Democratic Union -- People's Party | 5.8099 | 68 | 39 | 63 | 262 | 1245 |
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 |
CZE | Czech Republic | parliament | 1992-06-06 | 5.93 | 14 | 200 | ODA | Občanská demokratická aliance | Civic Democratic Alliance | 7.1111 | 68 | 39 | 63 | 262 | 1123 |
CZE | Czech Republic | parliament | 1992-06-06 | 29.73 | 66 | 200 | ODS | Občanská demokratická strana | Civic Democratic Party | 7.3637 | 68 | 39 | 63 | 262 | 829 |
CZE | Czech Republic | parliament | 1992-06-06 | 4.59 | 0 | 200 | OH|SD | Obcanské hnuti | Svobodní Demokraté | Civic Movement | Free Democrats | 4.1667 | 68 | 39 | 63 | 262 | 574 |
CZE | Czech Republic | parliament | 1992-06-06 | 2.69 | 0 | 200 | KAN | Klub angazovaných nestraníku | Club of committed Non-Party Members | 6.0 | 68 | 39 | 63 | 262 | 2220 |
SVK | Slovakia | parliament | 1992-06-06 | 9 | 150 | S-E | Spolužitie – Együttélés | Coexistence | 7.4 | 1 | 294 | 538 | 436 | 2248 | |
CZE | Czech Republic | parliament | 1992-06-06 | 14.05 | 35 | 200 | KSCM | Komunistická strana Cech a Moravy | Communist Party of Bohemia and Moravia | 0.7498 | 68 | 39 | 63 | 262 | 1173 |
CZE | Czech Republic | parliament | 1992-06-06 | 6.53 | 16 | 200 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 39 | 63 | 262 | 789 |
CZE | Czech Republic | parliament | 1992-06-06 | 3.15 | 0 | 200 | SCPZR | Strana československých podnikatelů, živnostníků a rolníků | Czechoslovak Businessmen's, Traders' and Farmers' Party | 6.0 | 68 | 39 | 63 | 262 | 2219 |
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.14 | 0 | 150 | SZS | Strana zelených | Green Party | 2.5 | 1 | 294 | 538 | 436 | 874 |
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 | 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 | 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 | |
CZE | Czech Republic | parliament | 1992-06-06 | 1.37 | 0 | 200 | NEI | Nezávislá iniciativa | Independent Initiative | 68 | 39 | 63 | 262 | 2221 | |
CZE | Czech Republic | parliament | 1992-06-06 | 6.52 | 16 | 200 | LSU | Liberálně sociální unie | Liberal Social Union | 2.9667 | 68 | 39 | 63 | 262 | 1218 |
CZE | Czech Republic | parliament | 1992-06-06 | 5.87 | 14 | 200 | HSD-SMS | Hnutí za samosprávnou demokracii – Společnost pro Moravu a Slezsko | Movement for Self-Governing Democracy -- Society for Moravia and Silesia | 68 | 39 | 63 | 262 | 19 | |
CZE | Czech Republic | parliament | 1992-06-06 | 1.08 | 0 | 200 | HSS | Hnutí za sociální spravedlnost | Movement for Social Justice | 3.3 | 68 | 39 | 63 | 262 | 2223 |
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 |
CZE | Czech Republic | parliament | 1992-06-06 | 1.3 | 0 | 200 | SPP | Strana prátel piva | Party of the Friends of Beer | 68 | 39 | 63 | 262 | 2222 | |
CZE | Czech Republic | parliament | 1992-06-06 | 3.77 | 0 | 200 | DZJ | Důchodci za životní jistoty | Pensioners for a Secure Living | 3.3 | 68 | 39 | 63 | 262 | 77 |
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 |
CZE | Czech Republic | parliament | 1992-06-06 | 5.98 | 14 | 200 | SPR-RSC | Sdruzení pro republiku – Republikánská strana Ceskoslovenska | Rally for the Republic -- Republican Party of Czechoslovakia | 9.7778 | 68 | 39 | 63 | 262 | 872 |
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 | 4.0 | 0 | 150 | SDSS | Sociálnodemokratická strana Slovenska | Social Democratic Party of Slovakia | 4.8111 | 1 | 294 | 538 | 436 | 1651 |
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;