view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
23 rows where "election_date" is on date 1993-06-06 sorted by election_type
This data as json, CSV (advanced)
Suggested facets: country_name_short, country_name, seats, country_id, election_id, previous_cabinet_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ESP | Spain | parliament | 1993-06-06 | 39.1 | 159 | 350 | PSOE | Partido Socialista Obrero Español | Spanish Socialist Workers Party | 3.7377 | 27 | 252 | 289 | 37 | 902 |
ESP | Spain | parliament | 1993-06-06 | 35.04 | 141 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 252 | 289 | 37 | 645 |
ESP | Spain | parliament | 1993-06-06 | 9.63 | 18 | 350 | PCE|IU | Partido Communista | Izquierda Unida | Communist Party | United Left | 2.0183 | 27 | 252 | 289 | 37 | 118 |
ESP | Spain | parliament | 1993-06-06 | 4.98 | 17 | 350 | CiU | Convergència i Unió | Convergence and Union | 6.2564 | 27 | 252 | 289 | 37 | 894 |
ESP | Spain | parliament | 1993-06-06 | 1.25 | 5 | 350 | PNV | Partido Nacionalista Vasco – Euzko Alderdi Jeltzalea | Basque Nationalist Party | 6.2144 | 27 | 252 | 289 | 37 | 1361 |
ESP | Spain | parliament | 1993-06-06 | 0.88 | 4 | 350 | CC | Coalición Canaria | Canary Coalition | 5.9789 | 27 | 252 | 289 | 37 | 234 |
ESP | Spain | parliament | 1993-06-06 | 0.88 | 2 | 350 | HB | Herri Batasuna | United People | 0.5909 | 27 | 252 | 289 | 37 | 1317 |
ESP | Spain | parliament | 1993-06-06 | 0.81 | 1 | 350 | ERC | Esquerra Republicana de Catalunya | Republican Left of Catalonia | 3.1072 | 27 | 252 | 289 | 37 | 757 |
ESP | Spain | parliament | 1993-06-06 | 0.62 | 1 | 350 | PAR | Partido Aragonés Regionalista | Aragonese Regionalist Party | 7.1909 | 27 | 252 | 289 | 37 | 1221 |
ESP | Spain | parliament | 1993-06-06 | 0.55 | 1 | 350 | EA | Eusko Alkartasuna | Basque Solidarity | 4.3115 | 27 | 252 | 289 | 37 | 845 |
ESP | Spain | parliament | 1993-06-06 | 0.48 | 1 | 350 | UV | Union Valenciana | Valencian Union | 6.0417 | 27 | 252 | 289 | 37 | 443 |
ESP | Spain | parliament | 1993-06-06 | 1.77 | 0 | 350 | CDS | Centró Democrático y Social | Democratic and Social Centre | 6.2 | 27 | 252 | 289 | 37 | 637 |
LVA | Latvia | parliament | 1993-06-06 | 32.41 | 36 | 100 | LC | Latvijas Ceļš | Latvian Way | 6.125 | 55 | 564 | 647 | 595 | 526 |
LVA | Latvia | parliament | 1993-06-06 | 13.35 | 15 | 100 | LNNK | Latvijas Nacionālās Neatkarības Kustība | Latvian National Independence Movement | 8.375 | 55 | 564 | 647 | 595 | 1557 |
LVA | Latvia | parliament | 1993-06-06 | 12.0 | 13 | 100 | TSP | Tautas Saskaņas Partija | National Harmony Party | 1.864 | 55 | 564 | 647 | 595 | 32 |
LVA | Latvia | parliament | 1993-06-06 | 10.65 | 12 | 100 | LZS | Latvijas Zemnieku Savienība | Farmers Union of Latvia | 4.375 | 55 | 564 | 647 | 595 | 1368 |
LVA | Latvia | parliament | 1993-06-06 | 5.76 | 7 | 100 | L | Līdztiesība | Equal Rights | 1.25 | 55 | 564 | 647 | 595 | 928 |
LVA | Latvia | parliament | 1993-06-06 | 5.01 | 6 | 100 | KDS | Kristīgi demokrātiskā savienība | Christian Democratic Union | 6.2 | 55 | 564 | 647 | 595 | 239 |
LVA | Latvia | parliament | 1993-06-06 | 5.35 | 6 | 100 | TB | Tēvzemei un Brīvībai | For Fatherland and Freedom | 8.8 | 55 | 564 | 647 | 595 | 203 |
LVA | Latvia | parliament | 1993-06-06 | 4.76 | 5 | 100 | DCP | Demokrātiskā Centra Partija | Democratic Centre Party | 6.0 | 55 | 564 | 647 | 595 | 384 |
LVA | Latvia | parliament | 1993-06-06 | 1.16 | 0 | 100 | LKPP | Latvijas Krievu pilsoņu partija | Latvias Party of Russian Citizens | 55 | 564 | 647 | 595 | 1083 | |
LVA | Latvia | parliament | 1993-06-06 | 1.19 | 0 | 100 | LZP | Latvijas Zaļā partija | Latvian Green Party | 4.6711 | 55 | 564 | 647 | 595 | 1001 |
LVA | Latvia | parliament | 1993-06-06 | 2.63 | 0 | 100 | LTF | Latvijas Tautas fronte | Popular Front of Latvia | 55 | 564 | 647 | 595 | 42 |
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;