view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
11 rows where "election_date" is on date 1994-05-29
This data as json, CSV (advanced)
Suggested facets: vote_share
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 | 1994-05-29 | 33.0 | 209 | 386 | MSZP | Magyar Szocialista Párt | Hungarian Socialist Party | 2.8743 | 39 | 620 | 257 | 13 | 1591 |
HUN | Hungary | parliament | 1994-05-29 | 19.7 | 69 | 386 | SzDSz | Szabad Demokraták Szövetsége | Alliance of Free Democrats | 3.9659 | 39 | 620 | 257 | 13 | 1426 |
HUN | Hungary | parliament | 1994-05-29 | 11.7 | 38 | 386 | MDF | Magyar Demokrata Fórum | Hungarian Democratic Forum | 6.4826 | 39 | 620 | 257 | 13 | 546 |
HUN | Hungary | parliament | 1994-05-29 | 8.8 | 26 | 386 | FKgP | Független Kisgazda Párt | Independent Small Holders Party | 9.0186 | 39 | 620 | 257 | 13 | 870 |
HUN | Hungary | parliament | 1994-05-29 | 7.0 | 22 | 386 | KDNP | Kereszténydemokrata Néppárt | Christian Democratic People's Party | 7.4 | 39 | 620 | 257 | 13 | 434 |
HUN | Hungary | parliament | 1994-05-29 | 7.0 | 20 | 386 | Fi-MPSz | Fidesz – Magyar Polgári Szövetség | Fidesz -- Hungarian Civic Union | 6.5432 | 39 | 620 | 257 | 13 | 921 |
HUN | Hungary | parliament | 1994-05-29 | 2.1 | 1 | 386 | ASZ | Agrárszövetség | Agrarian Alliance | 5.3 | 39 | 620 | 257 | 13 | 1183 |
HUN | Hungary | parliament | 1994-05-29 | 0.6 | 1 | 386 | VP | Vállalkozók Pártja Egyesület | Entrepreneurs' Party | 6.0 | 39 | 620 | 257 | 13 | 1203 |
HUN | Hungary | parliament | 1994-05-29 | 1.6 | 0 | 386 | MIEP | Magyar Igazság és Élet Pártja | Hungarian Justice and Life Party | 9.6065 | 39 | 620 | 257 | 13 | 95 |
HUN | Hungary | parliament | 1994-05-29 | 3.2 | 0 | 386 | MMP | Magyar Munkáspárt | Hungarian Workers' Party | 0.6316 | 39 | 620 | 257 | 13 | 1202 |
HUN | Hungary | parliament | 1994-05-29 | 2.55 | 0 | 386 | KP | Köztársaság Párt | Republican Party | 39 | 620 | 257 | 13 | 2588 |
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;