view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
30 rows where "election_date" is on date 2011-12-04 sorted by party_name_english
This data as json, CSV (advanced)
Suggested facets: country_name_short, country_name, vote_share, seats_total, left_right, election_id, previous_parliament_election_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 | 2011-12-04 | 3 | 151 | SDSS | Samostalna demokratska srpska stranka | Independent Democratic Serb Party | 3.3 | 62 | 792 | 793 | 1057 | 2133 | |
HRV | Croatia | parliament | 2011-12-04 | 2.8 | 0 | 151 | PGS | Primorsko goranski savez | Alliance of Primorje-Gorski | 62 | 792 | 793 | 1057 | 2196 | |
SVN | Slovenia | parliament | 2011-12-04 | 8.37 | 8 | 90 | DL | Državljanska lista | Civic List | 6.0 | 60 | 778 | 522 | 907 | 1988 |
HRV | Croatia | parliament | 2011-12-04 | 2 | 151 | HGS | Hrvatska građanska stranka | Croatian Civic Party | 8.8 | 62 | 792 | 793 | 1057 | 2193 | |
HRV | Croatia | parliament | 2011-12-04 | 2.96 | 6 | 151 | HDSSB | Hrvatski demokratski savez Slavonije i Baranje | Croatian Democratic Alliance of Slavonia and Baranja | 8.8 | 62 | 792 | 793 | 1057 | 2135 |
HRV | Croatia | parliament | 2011-12-04 | 23.5 | 41 | 151 | HDZ | Hrvatska demokratska zajednica | Croatian Democratic Union | 7.1053 | 62 | 792 | 793 | 1057 | 276 |
HRV | Croatia | parliament | 2011-12-04 | 4.19 | 6 | 151 | HL-LR | Hrvatski laburisti – Stranka rada | Croatian Labourists -- Labour Party | 1.3 | 62 | 792 | 793 | 1057 | 2182 |
HRV | Croatia | parliament | 2011-12-04 | 3 | 151 | HSU | Hrvatska stranka umirovljenika | Croatian Party of Pensioners | 62 | 792 | 793 | 1057 | 2134 | ||
HRV | Croatia | parliament | 2011-12-04 | 3.0 | 0 | 151 | HSP | Hrvatska stranka prava | Croatian Party of Rights | 8.7719 | 62 | 792 | 793 | 1057 | 1044 |
HRV | Croatia | parliament | 2011-12-04 | 0.64 | 1 | 151 | HSP-AS | Hrvatska stranka prava dr. Ante Starčević | Croatian Party of Rights -- Dr. Ante Starcevic | 8.8 | 62 | 792 | 793 | 1057 | 2181 |
HRV | Croatia | parliament | 2011-12-04 | 0.64 | 1 | 151 | HSS | Hrvatska seljačka stranka | Croatian Peasant Party | 6.2281 | 62 | 792 | 793 | 1057 | 1465 |
HRV | Croatia | parliament | 2011-12-04 | 13 | 151 | HNS-LD | Hrvatska narodna stranka – Liberalni demokrati | Croatian People's Party -- Liberal Democrats | 1.8421 | 62 | 792 | 793 | 1057 | 1384 | |
HRV | Croatia | parliament | 2011-12-04 | 3.0 | 0 | 151 | HSLS | Hrvatska socijalno liberalna stranka | Croatian Social Liberal Party | 7.193 | 62 | 792 | 793 | 1057 | 1102 |
HRV | Croatia | parliament | 2011-12-04 | 1 | 151 | DC | Demokratski centar | Democratic Centre | 5.9649 | 62 | 792 | 793 | 1057 | 1081 | |
SVN | Slovenia | parliament | 2011-12-04 | 6.97 | 6 | 90 | DeSUS | Demokratična stranka upokojencev Slovenije | Democratic Party of Pensioners of Slovenia | 3.2292 | 60 | 778 | 522 | 907 | 1587 |
SVN | Slovenia | parliament | 2011-12-04 | 1 | 90 | Mad | Madžarska narodna skupnost | Hungarian national community | 60 | 778 | 522 | 907 | 65 | ||
HRV | Croatia | parliament | 2011-12-04 | 1.25 | 2 | 151 | I-IG | Neovisna lista – dr.sc. Ivan Grubišić | Independent List -- PhD Ivan Grubisic | 62 | 792 | 793 | 1057 | 2195 | |
HRV | Croatia | parliament | 2011-12-04 | 3 | 151 | IDS | Istarski demokratski sabor | Istrian Democratic Assembly | 3.4211 | 62 | 792 | 793 | 1057 | 1627 | |
SVN | Slovenia | parliament | 2011-12-04 | 1 | 90 | Ita | Italijanska narodna skupnost | Italian national community | 60 | 778 | 522 | 907 | 199 | ||
SVN | Slovenia | parliament | 2011-12-04 | 1.48 | 0 | 90 | LDS | Liberalna demokracija Slovenije | Liberal Democracy of Slovenia | 3.7351 | 60 | 778 | 522 | 907 | 1252 |
SVN | Slovenia | parliament | 2011-12-04 | 4.88 | 4 | 90 | NSI | Nova Slovenija – Krščanska ljudska stranka | New Slovenia -- Christian People's Party | 7.9345 | 60 | 778 | 522 | 907 | 1047 |
SVN | Slovenia | parliament | 2011-12-04 | 1.22 | 0 | 90 | TRS | Stranka za trajnostni razvoj Slovenije | Party for Sustainable Development of Slovenia | 3.3 | 60 | 778 | 522 | 907 | 1989 |
SVN | Slovenia | parliament | 2011-12-04 | 26.19 | 26 | 90 | SDS | Slovenska demokratska stranka | Slovenian Democratic Party | 6.9996 | 60 | 778 | 522 | 907 | 179 |
SVN | Slovenia | parliament | 2011-12-04 | 1.8 | 0 | 90 | SNS | Slovenska nacionalna stranka | Slovenian National Party | 4.7941 | 60 | 778 | 522 | 907 | 981 |
SVN | Slovenia | parliament | 2011-12-04 | 6.83 | 6 | 90 | SLS | Slovenska ljudska stranka | Slovenian People's Party | 6.6953 | 60 | 778 | 522 | 907 | 16 |
HRV | Croatia | parliament | 2011-12-04 | 41.08 | 61 | 151 | SPH | Socijaldemokratska partija Hrvatske | Social Democratic Party of Croatia | 3.2456 | 62 | 792 | 793 | 1057 | 1493 |
SVN | Slovenia | parliament | 2011-12-04 | 10.52 | 10 | 90 | ZL-SD | Združena lista – Socialni demokrati | United List -- Social Democrats | 3.0637 | 60 | 778 | 522 | 907 | 706 |
SVN | Slovenia | parliament | 2011-12-04 | 28.51 | 28 | 90 | LZJ-PS | Lista Zorana Jankovića – Pozitivna Slovenija | Zoran Jankovic's List -- Positive Slovenia | 3.3 | 60 | 778 | 522 | 907 | 1987 |
HRV | Croatia | parliament | 2011-12-04 | 3 | 151 | abroad | abroad | abroad | 62 | 792 | 793 | 1057 | 2191 | ||
HRV | Croatia | parliament | 2011-12-04 | 5 | 151 | ethnic | ethnic | ethnic | 62 | 792 | 793 | 1057 | 2192 |
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;