view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
19 rows where "election_date" is on date 2015-11-08 sorted by previous_cabinet_id
This data as json, CSV (advanced)
Suggested facets: seats, left_right
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 | 2015-11-08 | 34.08 | 50 | 151 | HDZ | Hrvatska demokratska zajednica | Croatian Democratic Union | 7.1053 | 62 | 1001 | 792 | 1056 | 276 |
HRV | Croatia | parliament | 2015-11-08 | 32.83 | 42 | 151 | SPH | Socijaldemokratska partija Hrvatske | Social Democratic Party of Croatia | 3.2456 | 62 | 1001 | 792 | 1056 | 1493 |
HRV | Croatia | parliament | 2015-11-08 | 13.42 | 19 | 151 | Most | Most nezavisnih lista | Bridge of Independent Lists | 7.4 | 62 | 1001 | 792 | 1056 | 2615 |
HRV | Croatia | parliament | 2015-11-08 | 9 | 151 | HNS-LD | Hrvatska narodna stranka – Liberalni demokrati | Croatian People's Party -- Liberal Democrats | 1.8421 | 62 | 1001 | 792 | 1056 | 1384 | |
HRV | Croatia | parliament | 2015-11-08 | 1.66 | 5 | 151 | ethnic | ethnic | ethnic | 62 | 1001 | 792 | 1056 | 2192 | |
HRV | Croatia | parliament | 2015-11-08 | 3 | 151 | HSP-AS | Hrvatska stranka prava dr. Ante Starčević | Croatian Party of Rights -- Dr. Ante Starcevic | 8.8 | 62 | 1001 | 792 | 1056 | 2181 | |
HRV | Croatia | parliament | 2015-11-08 | 3 | 151 | HL-LR | Hrvatski laburisti – Stranka rada | Croatian Labourists -- Labour Party | 1.3 | 62 | 1001 | 792 | 1056 | 2182 | |
HRV | Croatia | parliament | 2015-11-08 | 1.86 | 3 | 151 | IDS | Istarski demokratski sabor | Istrian Democratic Assembly | 3.4211 | 62 | 1001 | 792 | 1056 | 1627 |
HRV | Croatia | parliament | 2015-11-08 | 3 | 151 | SDSS | Samostalna demokratska srpska stranka | Independent Democratic Serb Party | 3.3 | 62 | 1001 | 792 | 1056 | 2133 | |
HRV | Croatia | parliament | 2015-11-08 | 2 | 151 | HSLS | Hrvatska socijalno liberalna stranka | Croatian Social Liberal Party | 7.193 | 62 | 1001 | 792 | 1056 | 1102 | |
HRV | Croatia | parliament | 2015-11-08 | 2 | 151 | HSU | Hrvatska stranka umirovljenika | Croatian Party of Pensioners | 62 | 1001 | 792 | 1056 | 2134 | ||
HRV | Croatia | parliament | 2015-11-08 | 1.35 | 2 | 151 | HDSSB | Hrvatski demokratski savez Slavonije i Baranje | Croatian Democratic Alliance of Slavonia and Baranja | 8.8 | 62 | 1001 | 792 | 1056 | 2135 |
HRV | Croatia | parliament | 2015-11-08 | 2 | 151 | one-seat | one seat | one seat | 62 | 1001 | 792 | 1056 | 2295 | ||
HRV | Croatia | parliament | 2015-11-08 | 3.34 | 2 | 151 | MB | Milan Bandić 365 – Stranka rada i solidarnosti | Milan Bandic 365 -- The Party of Labour and Solidarity | 3.3 | 62 | 1001 | 792 | 1056 | 2628 |
HRV | Croatia | parliament | 2015-11-08 | 1 | 151 | HSS | Hrvatska seljačka stranka | Croatian Peasant Party | 6.2281 | 62 | 1001 | 792 | 1056 | 1465 | |
HRV | Croatia | parliament | 2015-11-08 | 4.19 | 1 | 151 | ZiZi | Živi zid | Human Shield | 8.8 | 62 | 1001 | 792 | 1056 | 2612 |
HRV | Croatia | parliament | 2015-11-08 | 1.54 | 1 | 151 | NS | Narodna stranka – Reformisti | People's Party -- Reformists | 6.0 | 62 | 1001 | 792 | 1056 | 2614 |
HRV | Croatia | parliament | 2015-11-08 | 1 | 151 | Hrast | Hrvatski rast | Croatian Growth | 6.2 | 62 | 1001 | 792 | 1056 | 2185 | |
HRV | Croatia | parliament | 2015-11-08 | 1.73 | 0 | 151 | ORaH | Održivi razvoj Hrvatske | Sustainable Development of Croatia | 2.5 | 62 | 1001 | 792 | 1056 | 2382 |
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;