view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
19 rows where "election_date" is on date 1990-04-08 sorted by previous_cabinet_id
This data as json, CSV (advanced)
Suggested facets: country_name_short, vote_share, seats_total, party_name_english, country_id, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HUN | Hungary | parliament | 1990-04-08 | 24.7 | 164 | 386 | MDF | Magyar Demokrata Fórum | Hungarian Democratic Forum | 6.4826 | 39 | 257 | 546 | ||
HUN | Hungary | parliament | 1990-04-08 | 21.4 | 93 | 386 | SzDSz | Szabad Demokraták Szövetsége | Alliance of Free Democrats | 3.9659 | 39 | 257 | 1426 | ||
HUN | Hungary | parliament | 1990-04-08 | 11.7 | 44 | 386 | FKgP | Független Kisgazda Párt | Independent Small Holders Party | 9.0186 | 39 | 257 | 870 | ||
HUN | Hungary | parliament | 1990-04-08 | 10.9 | 33 | 386 | MSZP | Magyar Szocialista Párt | Hungarian Socialist Party | 2.8743 | 39 | 257 | 1591 | ||
HUN | Hungary | parliament | 1990-04-08 | 9.0 | 22 | 386 | Fi-MPSz | Fidesz – Magyar Polgári Szövetség | Fidesz -- Hungarian Civic Union | 6.5432 | 39 | 257 | 921 | ||
HUN | Hungary | parliament | 1990-04-08 | 6.5 | 21 | 386 | KDNP | Kereszténydemokrata Néppárt | Christian Democratic People's Party | 7.4 | 39 | 257 | 434 | ||
HUN | Hungary | parliament | 1990-04-08 | 1.0 | 7 | 386 | none | független | no party affiliation | 39 | 257 | 1617 | |||
HUN | Hungary | parliament | 1990-04-08 | 3.1 | 2 | 386 | ASZ | Agrárszövetség | Agrarian Alliance | 5.3 | 39 | 257 | 1183 | ||
HUN | Hungary | parliament | 1990-04-08 | 3.6 | 0 | 386 | MSzDP | Magyarországi Szociáldemokrata Párt | Social Democratic Party | 1.3 | 39 | 257 | 418 | ||
HUN | Hungary | parliament | 1990-04-08 | 3.7 | 0 | 386 | MMP | Magyar Munkáspárt | Hungarian Workers' Party | 0.6316 | 39 | 257 | 1202 | ||
HUN | Hungary | parliament | 1990-04-08 | 1.9 | 0 | 386 | HVK | Hazafias Választási Koalíció | Patriotic Elections Coalition | 39 | 257 | 198 | |||
HUN | Hungary | parliament | 1990-04-08 | 1.9 | 0 | 386 | VP | Vállalkozók Pártja Egyesület | Entrepreneurs' Party | 6.0 | 39 | 257 | 1203 | ||
GRC | Greece | parliament | 1990-04-08 | 46.9 | 150 | 300 | ND | Néa Đimokratía | New Democracy | 6.7365 | 41 | 284 | 508 | 716 | 47 |
GRC | Greece | parliament | 1990-04-08 | 38.6 | 123 | 300 | PASOK | Panellinio Sosialistikó Kínima | Panhellenic Socialist Movement | 4.4968 | 41 | 284 | 508 | 716 | 1338 |
GRC | Greece | parliament | 1990-04-08 | 10.3 | 19 | 300 | SYN | Synaspismós tīs Aristerás | Coalition of the Left | 2.7683 | 41 | 284 | 508 | 716 | 1441 |
GRC | Greece | parliament | 1990-04-08 | 4 | 300 | none | no party affiliation | no party affiliation | 41 | 284 | 508 | 716 | 1358 | ||
GRC | Greece | parliament | 1990-04-08 | 0.7 | 2 | 300 | Emp | Empistosύnh (Rodόph) | Independent Muslim Lists | 41 | 284 | 508 | 716 | 1059 | |
GRC | Greece | parliament | 1990-04-08 | 0.8 | 1 | 300 | OE | Oikolόgoi Enallaktikoί | Alternative Ecologists | 2.5 | 41 | 284 | 508 | 716 | 2163 |
GRC | Greece | parliament | 1990-04-08 | 0.7 | 1 | 300 | DIANA | Dimokratiki Ananeosi | Democratic Renewal | 7.4 | 41 | 284 | 508 | 716 | 1374 |
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;