view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
24 rows where "election_date" is on date 2007-11-25 sorted by party_name_english
This data as json, CSV (advanced)
Suggested facets: country_name_short, country_name, seats, left_right, country_id, previous_parliament_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HRV | Croatia | parliament | 2007-11-25 | 1.5 | 3 | 153 | SDSS | Samostalna demokratska srpska stranka | Independent Democratic Serb Party | 3.3 | 62 | 793 | 795 | 1053 | 2133 |
ROU | Romania | ep | 2007-11-25 | 1.4 | 0 | 35 | PNT-CD | Partidul Naţional Ţărănesc Creştin Democrat | Christian-Democratic National Peasants' Party | 5.5341 | 23 | 676 | 165 | 118 | 888 |
HRV | Croatia | parliament | 2007-11-25 | 1.8 | 3 | 153 | HDSSB | Hrvatski demokratski savez Slavonije i Baranje | Croatian Democratic Alliance of Slavonia and Baranja | 8.8 | 62 | 793 | 795 | 1053 | 2135 |
HRV | Croatia | parliament | 2007-11-25 | 35.9 | 66 | 153 | HDZ | Hrvatska demokratska zajednica | Croatian Democratic Union | 7.1053 | 62 | 793 | 795 | 1053 | 276 |
HRV | Croatia | parliament | 2007-11-25 | 4.0 | 1 | 153 | HSU | Hrvatska stranka umirovljenika | Croatian Party of Pensioners | 62 | 793 | 795 | 1053 | 2134 | |
HRV | Croatia | parliament | 2007-11-25 | 3.4 | 1 | 153 | HSP | Hrvatska stranka prava | Croatian Party of Rights | 8.7719 | 62 | 793 | 795 | 1053 | 1044 |
HRV | Croatia | parliament | 2007-11-25 | 6.4 | 6 | 153 | HSS | Hrvatska seljačka stranka | Croatian Peasant Party | 6.2281 | 62 | 793 | 795 | 1053 | 1465 |
HRV | Croatia | parliament | 2007-11-25 | 6.7 | 7 | 153 | HNS-LD | Hrvatska narodna stranka – Liberalni demokrati | Croatian People's Party -- Liberal Democrats | 1.8421 | 62 | 793 | 795 | 1053 | 1384 |
HRV | Croatia | parliament | 2007-11-25 | 2 | 153 | HSLS | Hrvatska socijalno liberalna stranka | Croatian Social Liberal Party | 7.193 | 62 | 793 | 795 | 1053 | 1102 | |
ROU | Romania | ep | 2007-11-25 | 28.8 | 13 | 35 | PD | Partidul Democrat | Democratic Party | 5.3875 | 23 | 676 | 165 | 118 | 419 |
ROU | Romania | ep | 2007-11-25 | 5.5 | 2 | 35 | UDMR | Uniunea Democrată Maghiară din România | Democratic Union of Hungarians in Romania | 6.016 | 23 | 676 | 165 | 118 | 948 |
ROU | Romania | ep | 2007-11-25 | 4.1 | 0 | 35 | PRM | Partidul România Mare | Greater Romania Party | 6.6618 | 23 | 676 | 165 | 118 | 713 |
ROU | Romania | ep | 2007-11-25 | 2.9 | 0 | 35 | PU|PC | Partidul Umanist | Partidul Conservator | Humanist Party | Conservative Party | 4.7622 | 23 | 676 | 165 | 118 | 5 |
HRV | Croatia | parliament | 2007-11-25 | 1.5 | 3 | 153 | IDS | Istarski demokratski sabor | Istrian Democratic Assembly | 3.4211 | 62 | 793 | 795 | 1053 | 1627 |
ROU | Romania | ep | 2007-11-25 | 7.8 | 3 | 35 | PLD | Partidul Liberal Democrat | Liberal Democratic Party | 6.0543 | 23 | 676 | 165 | 118 | 1485 |
ROU | Romania | ep | 2007-11-25 | 2.4 | 0 | 35 | PIN | Partidul Iniţiativa Naţională | National Initiative Party | 7.4 | 23 | 676 | 165 | 118 | 1589 |
ROU | Romania | ep | 2007-11-25 | 13.4 | 6 | 35 | PNL | Partidul Naţional Liberal | National Liberal Party | 6.0543 | 23 | 676 | 165 | 118 | 1015 |
ROU | Romania | ep | 2007-11-25 | 4.9 | 0 | 35 | PNG-CD | Partidul Noua Generaţie – Creştin Democrat | New Generation Party -- Christian Democratic | 6.2 | 23 | 676 | 165 | 118 | 1332 |
HRV | Croatia | parliament | 2007-11-25 | 1 | 153 | SDA | Stranka demokratske akcije Hrvatske | Party of Democratic Action of Croatia | 7.4 | 62 | 793 | 795 | 1053 | 2270 | |
ROU | Romania | ep | 2007-11-25 | 1.2 | 0 | 35 | PaRo | Partida Romilor | Party of the Roma | 3.3 | 23 | 676 | 165 | 118 | 254 |
ROU | Romania | ep | 2007-11-25 | 23.1 | 10 | 35 | PSD | Partidul Social Democrat | Social Democratic Party | 3.2325 | 23 | 676 | 165 | 118 | 1120 |
HRV | Croatia | parliament | 2007-11-25 | 30.8 | 56 | 153 | SPH | Socijaldemokratska partija Hrvatske | Social Democratic Party of Croatia | 3.2456 | 62 | 793 | 795 | 1053 | 1493 |
HRV | Croatia | parliament | 2007-11-25 | 4 | 153 | ethnic | ethnic | ethnic | 62 | 793 | 795 | 1053 | 2192 | ||
ROU | Romania | ep | 2007-11-25 | 3.5 | 1 | 35 | none | no party affiliation | no party affiliation | 23 | 676 | 165 | 118 | 761 |
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;