view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
24 rows where "election_date" is on date 2009-06-04 sorted by previous_cabinet_id
This data as json, CSV (advanced)
Suggested facets: country_name_short, country_name, seats, country_id, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
NLD | Netherlands | ep | 2009-06-04 | 20.05 | 5 | 25 | CDA | Christen Democratisch Appèl | Christian Democratic Appeal | 5.9376 | 8 | 134 | 578 | 69 | 235 |
NLD | Netherlands | ep | 2009-06-04 | 16.97 | 4 | 25 | PVV | Partij voor de Vrijheid | Party for Freedom | 8.8 | 8 | 134 | 578 | 69 | 1501 |
NLD | Netherlands | ep | 2009-06-04 | 12.05 | 3 | 25 | PvdA | Partij van de Arbeid | Labour Party | 3.6118 | 8 | 134 | 578 | 69 | 742 |
NLD | Netherlands | ep | 2009-06-04 | 8.87 | 3 | 25 | GL | GroenLinks | GreenLeft | 2.0454 | 8 | 134 | 578 | 69 | 756 |
NLD | Netherlands | ep | 2009-06-04 | 11.39 | 3 | 25 | VVD | Volkspartij voor Vrijheid en Democratie | People's Party for Freedom and Democracy | 7.3482 | 8 | 134 | 578 | 69 | 1409 |
NLD | Netherlands | ep | 2009-06-04 | 11.32 | 3 | 25 | D66 | Democraten 66 | Democrats 66 | 4.5066 | 8 | 134 | 578 | 69 | 345 |
NLD | Netherlands | ep | 2009-06-04 | 7.1 | 2 | 25 | SP | Socialistiese Partij | Socialist Party | 1.3682 | 8 | 134 | 578 | 69 | 357 |
NLD | Netherlands | ep | 2009-06-04 | 6.82 | 2 | 25 | CU | ChristenUnie | ChristianUnion | 6.1732 | 8 | 134 | 578 | 69 | 1206 |
NLD | Netherlands | ep | 2009-06-04 | 3.46 | 0 | 25 | PvdD | Partij voor de Dieren | Party for the Animals | 8 | 134 | 578 | 69 | 990 | |
GBR | United Kingdom | ep | 2009-06-04 | 27.7 | 25 | 72 | Con | Conservatives | Conservatives | 7.4261 | 44 | 410 | 233 | 119 | 773 |
GBR | United Kingdom | ep | 2009-06-04 | 16.5 | 13 | 72 | UKIP | United Kingdom Independence Party | United Kingdom Independence Party | 7.8429 | 44 | 410 | 233 | 119 | 1272 |
GBR | United Kingdom | ep | 2009-06-04 | 15.7 | 13 | 72 | Lab | Labour Party | Labour | 4.3562 | 44 | 410 | 233 | 119 | 1556 |
GBR | United Kingdom | ep | 2009-06-04 | 13.7 | 11 | 72 | Lib | Liberals | Liberals | 4.2875 | 44 | 410 | 233 | 119 | 659 |
GBR | United Kingdom | ep | 2009-06-04 | 6.2 | 2 | 72 | BNP | British National Party | British National Party | 8.8 | 44 | 410 | 233 | 119 | 1250 |
GBR | United Kingdom | ep | 2009-06-04 | 2.1 | 2 | 72 | SNP | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba | Scottish National Party | 3.5871 | 44 | 410 | 233 | 119 | 1284 |
GBR | United Kingdom | ep | 2009-06-04 | 8.6 | 2 | 72 | GP | Green Party | Green Party | 2.57 | 44 | 410 | 233 | 119 | 467 |
GBR | United Kingdom | ep | 2009-06-04 | 0.8 | 1 | 72 | Plaid | Plaid Cymru | Plaid Cymru | 3.1183 | 44 | 410 | 233 | 119 | 311 |
GBR | United Kingdom | ep | 2009-06-04 | 0.8 | 1 | 72 | SF | Sinn Féin | Sinn Fein | 1.3 | 44 | 410 | 233 | 119 | 689 |
GBR | United Kingdom | ep | 2009-06-04 | 0.53 | 1 | 72 | UUP | Ulster Unionist Party | Ulster Unionist Party | 8.3 | 44 | 410 | 233 | 119 | 1210 |
GBR | United Kingdom | ep | 2009-06-04 | 0.56 | 1 | 72 | DUP | Democratic Unionist Party | Democratic Unionist Party | 7.4 | 44 | 410 | 233 | 119 | 319 |
GBR | United Kingdom | ep | 2009-06-04 | 1.8 | 0 | 72 | ED | English Democrats | English Democrats | 44 | 410 | 233 | 119 | 2062 | |
GBR | United Kingdom | ep | 2009-06-04 | 1.6 | 0 | 72 | CP | The Christian Party – Christian Peoples Alliance in England | The Christian Party -- Christian Peoples Alliance in England | 6.2 | 44 | 410 | 233 | 119 | 2063 |
GBR | United Kingdom | ep | 2009-06-04 | 1.1 | 0 | 72 | SLP | Socialist Labour Party | Socialist Labour Party | 1.3 | 44 | 410 | 233 | 119 | 2064 |
GBR | United Kingdom | ep | 2009-06-04 | 1.01 | 0 | 72 | NO2EU | NO2EU – Yes to Democracy | NO2EU -- Yes to Democracy | 1.3 | 44 | 410 | 233 | 119 | 2147 |
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;