view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
19 rows where "election_date" is on date 1996-11-03 sorted by party_name_english
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ROU | Romania | parliament | 1996-11-03 | 3 | 343 | PAR | Partidul Alternativa României | Alternative Party of Romania | 7.4 | 23 | 49 | 416 | 102 | 2087 | |
ROU | Romania | parliament | 1996-11-03 | 83 | 343 | PNT-CD | Partidul Naţional Ţărănesc Creştin Democrat | Christian-Democratic National Peasants' Party | 5.5341 | 23 | 49 | 416 | 102 | 888 | |
ROU | Romania | parliament | 1996-11-03 | 12.93 | 43 | 343 | PD | Partidul Democrat | Democratic Party | 5.3875 | 23 | 49 | 416 | 102 | 419 |
ROU | Romania | parliament | 1996-11-03 | 6.64 | 25 | 343 | UDMR | Uniunea Democrată Maghiară din România | Democratic Union of Hungarians in Romania | 6.016 | 23 | 49 | 416 | 102 | 948 |
ROU | Romania | parliament | 1996-11-03 | 4.46 | 19 | 343 | PRM | Partidul România Mare | Greater Romania Party | 6.6618 | 23 | 49 | 416 | 102 | 713 |
ROU | Romania | parliament | 1996-11-03 | 25 | 343 | PNL | Partidul Naţional Liberal | National Liberal Party | 6.0543 | 23 | 49 | 416 | 102 | 1015 | |
ROU | Romania | parliament | 1996-11-03 | 5 | 343 | PNL-CD | Partidul Naţional Liberal – Convenţia Democrată | National Liberal Party -- Democratic Convention | 7.4 | 23 | 49 | 416 | 102 | 2088 | |
ROU | Romania | parliament | 1996-11-03 | 1.44 | 0 | 343 | PPR | Partidul Pensionarilor din Romania | Party of Pensioners of Romania | 23 | 49 | 416 | 102 | 2106 | |
ROU | Romania | parliament | 1996-11-03 | 1.57 | 0 | 343 | PAC | Partidul Alianţa Civică | Party of the Civic Alliance | 4.4444 | 23 | 49 | 416 | 102 | 861 |
ROU | Romania | parliament | 1996-11-03 | 30.17 | 343 | CDR | Convenţia Democrată Română | Romanian Democratic Convention | 6.29 | 23 | 49 | 416 | 102 | 356 | |
ROU | Romania | parliament | 1996-11-03 | 1 | 343 | MER | Miscarea Ecologista din Romania | Romanian Ecological Movement | 2.5 | 23 | 49 | 416 | 102 | 1639 | |
ROU | Romania | parliament | 1996-11-03 | 5 | 343 | PER | Partidul Ecologist Român | Romanian Ecologist Party | 2.5 | 23 | 49 | 416 | 102 | 792 | |
ROU | Romania | parliament | 1996-11-03 | 4.36 | 18 | 343 | PUNR | Partidul Unitatii Naţionale a Romanilor | Romanian National Unity Party | 5.5556 | 23 | 49 | 416 | 102 | 648 |
ROU | Romania | parliament | 1996-11-03 | 10 | 343 | PSDR | Partidul Social Democrat Român | Romanian Social Democratic Party | 3.3 | 23 | 49 | 416 | 102 | 1601 | |
ROU | Romania | parliament | 1996-11-03 | 1.73 | 0 | 343 | PSMR | Partidul Socialist Muncitoresc Roman | Romanian Socialist Party of Workers | 1.3 | 23 | 49 | 416 | 102 | 2105 |
ROU | Romania | parliament | 1996-11-03 | 15 | 343 | etnice | Partidele minorităţilor etnice din România | Romanian ethnic minorities parties | 23 | 49 | 416 | 102 | 425 | ||
ROU | Romania | parliament | 1996-11-03 | 21.77 | 91 | 343 | PSD | Partidul Social Democrat | Social Democratic Party | 3.2325 | 23 | 49 | 416 | 102 | 1120 |
ROU | Romania | parliament | 1996-11-03 | 2.29 | 0 | 343 | PS | Partidul Socialist | Socialist Party | 1.3 | 23 | 49 | 416 | 102 | 2104 |
ROU | Romania | parliament | 1996-11-03 | 2.15 | 0 | 343 | PSM | Partidul Socialist al Muncii | Socialist Party of Labour | 5.5556 | 23 | 49 | 416 | 102 | 562 |
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;