view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
21 rows where "election_date" is on date 1990-06-09 sorted by election_type
This data as json, CSV (advanced)
Suggested facets: country_name, seats, party_name_english, left_right, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CZE | Czech Republic | parliament | 1990-06-09 | 49.5 | 127 | 200 | OF | Obcanské fórum | Civic Forum | 6.0 | 68 | 63 | 743 | ||
CZE | Czech Republic | parliament | 1990-06-09 | 13.24 | 32 | 200 | KSC | Komunistická strana Československa | Communist Party of Czechoslovakia | 1.3 | 68 | 63 | 665 | ||
CZE | Czech Republic | parliament | 1990-06-09 | 10.03 | 22 | 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 | 63 | 19 | |||
CZE | Czech Republic | parliament | 1990-06-09 | 8.42 | 15 | 200 | KDU-CSL | Křesťanská a demokratická unie – Československá strana lidová | Christian Democratic Union -- People's Party | 5.8099 | 68 | 63 | 1245 | ||
CZE | Czech Republic | parliament | 1990-06-09 | 4 | 200 | KDS | Krestanskodemokraticka strana | Christian Democratic Party | 8.1444 | 68 | 63 | 440 | |||
CZE | Czech Republic | parliament | 1990-06-09 | 4.11 | 0 | 200 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 63 | 789 | ||
CZE | Czech Republic | parliament | 1990-06-09 | 4.1 | 0 | 200 | SZ | Strana zelených | Green Party | 4.123 | 68 | 63 | 196 | ||
CZE | Czech Republic | parliament | 1990-06-09 | 1.0 | 0 | 200 | SPR-RSC | Sdruzení pro republiku – Republikánská strana Ceskoslovenska | Rally for the Republic -- Republican Party of Czechoslovakia | 9.7778 | 68 | 63 | 872 | ||
CZE | Czech Republic | parliament | 1990-06-09 | 2.68 | 0 | 200 | CNSP | Česká národně strana socialistická | Czech National Social(ist) Party | 8.8 | 68 | 63 | 29 | ||
CZE | Czech Republic | parliament | 1990-06-09 | 4.11 | 0 | 200 | SZV | Spojenectví zemědělců a venkova | Alliance of Farmers and the Countryside | 5.3 | 68 | 63 | 2101 | ||
CZE | Czech Republic | parliament | 1990-06-09 | 1.04 | 0 | 200 | CP-SB | Konzervativní strana – Svobodný blok | Conservative Party -- Free Bloc | 7.4 | 68 | 63 | 2102 | ||
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 |
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;