view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
26 rows where "election_date" is on date 2004-06-12 sorted by election_type
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CZE | Czech Republic | ep | 2004-06-12 | 30.04 | 9 | 24 | ODS | Občanská demokratická strana | Civic Democratic Party | 7.3637 | 68 | 567 | 487 | 504 | 829 |
CZE | Czech Republic | ep | 2004-06-12 | 20.26 | 6 | 24 | KSCM | Komunistická strana Cech a Moravy | Communist Party of Bohemia and Moravia | 0.7498 | 68 | 567 | 487 | 504 | 1173 |
CZE | Czech Republic | ep | 2004-06-12 | 11.02 | 3 | 24 | SNK-ED | SNK Evropští demokraté | SNK European Democrats | 6.0929 | 68 | 567 | 487 | 504 | 1532 |
CZE | Czech Republic | ep | 2004-06-12 | 9.57 | 2 | 24 | KDU-CSL | Křesťanská a demokratická unie – Československá strana lidová | Christian Democratic Union -- People's Party | 5.8099 | 68 | 567 | 487 | 504 | 1245 |
CZE | Czech Republic | ep | 2004-06-12 | 8.18 | 2 | 24 | Ne | Nezávislí | Independent | 5.5 | 68 | 567 | 487 | 504 | 653 |
CZE | Czech Republic | ep | 2004-06-12 | 8.78 | 2 | 24 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 567 | 487 | 504 | 789 |
CZE | Czech Republic | ep | 2004-06-12 | 3.16 | 0 | 24 | SZ | Strana zelených | Green Party | 4.123 | 68 | 567 | 487 | 504 | 196 |
CZE | Czech Republic | ep | 2004-06-12 | 1.69 | 0 | 24 | US | Unie svobody | Freedom Union | 7.2204 | 68 | 567 | 487 | 504 | 688 |
CZE | Czech Republic | ep | 2004-06-12 | 1.17 | 0 | 24 | PB | Pravý Blok | Right Bloc | 8.8 | 68 | 567 | 487 | 504 | 2033 |
ITA | Italy | ep | 2004-06-12 | 31.08 | 24 | 78 | CeS | Centro-sinistra | Centre Left | 3.3 | 26 | 329 | 498 | 256 | 1048 |
ITA | Italy | ep | 2004-06-12 | 20.93 | 16 | 78 | FI-PdL | Forza Italia – Il Popolo della Libertà | Go Italy -- The People of Freedom | 7.1459 | 26 | 329 | 498 | 256 | 596 |
ITA | Italy | ep | 2004-06-12 | 11.49 | 9 | 78 | AN | Alleanza Nazionale | National Alliance | 8.0871 | 26 | 329 | 498 | 256 | 373 |
ITA | Italy | ep | 2004-06-12 | 6.06 | 5 | 78 | PRC | Partito della Rifondazione Comunista | Communist Refoundation Party | 0.8849 | 26 | 329 | 498 | 256 | 1321 |
ITA | Italy | ep | 2004-06-12 | 5.89 | 5 | 78 | UC | Unione / Centro | Union / Centre | 6.1092 | 26 | 329 | 498 | 256 | 226 |
ITA | Italy | ep | 2004-06-12 | 5.0 | 4 | 78 | LN | Lega Nord | North League | 7.8007 | 26 | 329 | 498 | 256 | 1436 |
ITA | Italy | ep | 2004-06-12 | 2.42 | 2 | 78 | PdCI | Partito dei Comunisti Italiani | Party of the Italian Communists | 1.0423 | 26 | 329 | 498 | 256 | 1661 |
ITA | Italy | ep | 2004-06-12 | 2.14 | 2 | 78 | IdV | Italia dei Valori | Italy of Values | 4.8712 | 26 | 329 | 498 | 256 | 693 |
ITA | Italy | ep | 2004-06-12 | 2.47 | 2 | 78 | FdV | Federazione dei Verdi | Federation of the Greens | 2.3725 | 26 | 329 | 498 | 256 | 910 |
ITA | Italy | ep | 2004-06-12 | 2.04 | 2 | 78 | NPSI | Nuovo Partito Socialisti Italiani | New PSI | 5.43 | 26 | 329 | 498 | 256 | 1287 |
ITA | Italy | ep | 2004-06-12 | 2.25 | 2 | 78 | R | Radicali | Radicals | 3.9732 | 26 | 329 | 498 | 256 | 1296 |
ITA | Italy | ep | 2004-06-12 | 0.45 | 1 | 78 | SVP | Südtiroler Volkspartei | South Tyrol Peoples Party | 5.4 | 26 | 329 | 498 | 256 | 1030 |
ITA | Italy | ep | 2004-06-12 | 1.29 | 1 | 78 | UDEUR | Unione Democratici per l'Europa | Union of Democrats for Europe | 5.285 | 26 | 329 | 498 | 256 | 399 |
ITA | Italy | ep | 2004-06-12 | 0.73 | 1 | 78 | MSFT | Fiamma Tricolore | Fiamma Tricolore | 9.5762 | 26 | 329 | 498 | 256 | 176 |
ITA | Italy | ep | 2004-06-12 | 1.15 | 1 | 78 | PP | Partito Pensionati | Pensioners' Party | 5.75 | 26 | 329 | 498 | 256 | 502 |
ITA | Italy | ep | 2004-06-12 | 1.23 | 1 | 78 | ASM | Alternativa Sociale Mussolini | Social Alternative Mussolini | 8.8 | 26 | 329 | 498 | 256 | 323 |
ITA | Italy | ep | 2004-06-12 | 0.09 | 78 | UV | Union Valdôtaine | Valdotanian Union | 26 | 329 | 498 | 256 | 974 |
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;