view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
12 rows where "election_date" is on date 2004-03-14
This data as json, CSV (advanced)
Suggested facets: election_date (date)
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 | 2004-03-14 | 43.27 | 164 | 350 | PSOE | Partido Socialista Obrero Español | Spanish Socialist Workers Party | 3.7377 | 27 | 164 | 687 | 309 | 902 |
ESP | Spain | parliament | 2004-03-14 | 38.31 | 148 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 164 | 687 | 309 | 645 |
ESP | Spain | parliament | 2004-03-14 | 3.28 | 10 | 350 | CiU | Convergència i Unió | Convergence and Union | 6.2564 | 27 | 164 | 687 | 309 | 894 |
ESP | Spain | parliament | 2004-03-14 | 2.56 | 8 | 350 | ERC | Esquerra Republicana de Catalunya | Republican Left of Catalonia | 3.1072 | 27 | 164 | 687 | 309 | 757 |
ESP | Spain | parliament | 2004-03-14 | 1.65 | 7 | 350 | PNV | Partido Nacionalista Vasco – Euzko Alderdi Jeltzalea | Basque Nationalist Party | 6.2144 | 27 | 164 | 687 | 309 | 1361 |
ESP | Spain | parliament | 2004-03-14 | 5.04 | 5 | 350 | PCE|IU | Partido Communista | Izquierda Unida | Communist Party | United Left | 2.0183 | 27 | 164 | 687 | 309 | 118 |
ESP | Spain | parliament | 2004-03-14 | 0.92 | 3 | 350 | CC | Coalición Canaria | Canary Coalition | 5.9789 | 27 | 164 | 687 | 309 | 234 |
ESP | Spain | parliament | 2004-03-14 | 0.82 | 2 | 350 | BNG | Bloque Nacionalista Galego | Galician Nationalist Bloc | 2.9117 | 27 | 164 | 687 | 309 | 520 |
ESP | Spain | parliament | 2004-03-14 | 0.32 | 1 | 350 | EA | Eusko Alkartasuna | Basque Solidarity | 4.3115 | 27 | 164 | 687 | 309 | 845 |
ESP | Spain | parliament | 2004-03-14 | 0.37 | 1 | 350 | CA | Chunta Aragonesista | Aragonese Council | 2.75 | 27 | 164 | 687 | 309 | 1367 |
ESP | Spain | parliament | 2004-03-14 | 0.24 | 1 | 350 | Bai | Bai | Yes | 27 | 164 | 687 | 309 | 385 | |
ESP | Spain | parliament | 2004-03-14 | 0.71 | 0 | 350 | PA | Partidu Andalucista | Andalusian Party | 4.85 | 27 | 164 | 687 | 309 | 370 |
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;