view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
25 rows where "election_date" is on date 2006-04-09 sorted by party_name_english
This data as json, CSV (advanced)
Suggested facets: country_name, seats, party_name_short, party_name_english, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HUN | Hungary | parliament | 2006-04-09 | 6.5 | 20 | 386 | SzDSz | Szabad Demokraták Szövetsége | Alliance of Free Democrats | 3.9659 | 39 | 194 | 463 | 188 | 1426 |
ITA | Italy | parliament | 2006-04-09 | 0.25 | 1 | 630 | AIE | Associativo Italiani all'Estero | Associative Italians Abroad | 26 | 107 | 498 | 567 | 927 | |
ITA | Italy | parliament | 2006-04-09 | 0.09 | 1 | 630 | ALD | Autonomie Liberté Démocratie | Autonomy Liberty Democracy | 6.0 | 26 | 107 | 498 | 567 | 1063 |
ITA | Italy | parliament | 2006-04-09 | 30.43 | 220 | 630 | CeS | Centro-sinistra | Centre Left | 3.3 | 26 | 107 | 498 | 567 | 1048 |
ITA | Italy | parliament | 2006-04-09 | 0.73 | 4 | 630 | DCA | Democrazia Cristiana per le Autonomie | Christian Democracy for the Autonomies | 6.2 | 26 | 107 | 498 | 567 | 52 |
HUN | Hungary | parliament | 2006-04-09 | 23 | 386 | KDNP | Kereszténydemokrata Néppárt | Christian Democratic People's Party | 7.4 | 39 | 194 | 463 | 188 | 434 | |
ITA | Italy | parliament | 2006-04-09 | 5.69 | 41 | 630 | PRC | Partito della Rifondazione Comunista | Communist Refoundation Party | 0.8849 | 26 | 107 | 498 | 567 | 1321 |
ITA | Italy | parliament | 2006-04-09 | 2.0 | 15 | 630 | FdV | Federazione dei Verdi | Federation of the Greens | 2.3725 | 26 | 107 | 498 | 567 | 910 |
HUN | Hungary | parliament | 2006-04-09 | 42.0 | 386 | Fi+KDNP | Fidesz – Magyar Polgári Szövetség / Kereszténydemokrata Néppárt | Fidesz -- Hungarian Civic Party / Christian Democratic People's Party | 6.5432 | 39 | 194 | 463 | 188 | 437 | |
HUN | Hungary | parliament | 2006-04-09 | 141 | 386 | Fi-MPSz | Fidesz – Magyar Polgári Szövetség | Fidesz -- Hungarian Civic Union | 6.5432 | 39 | 194 | 463 | 188 | 921 | |
ITA | Italy | parliament | 2006-04-09 | 23.6 | 140 | 630 | FI-PdL | Forza Italia – Il Popolo della Libertà | Go Italy -- The People of Freedom | 7.1459 | 26 | 107 | 498 | 567 | 596 |
HUN | Hungary | parliament | 2006-04-09 | 5.0 | 11 | 386 | MDF | Magyar Demokrata Fórum | Hungarian Democratic Forum | 6.4826 | 39 | 194 | 463 | 188 | 546 |
HUN | Hungary | parliament | 2006-04-09 | 2.2 | 0 | 386 | MIEP | Magyar Igazság és Élet Pártja | Hungarian Justice and Life Party | 9.6065 | 39 | 194 | 463 | 188 | 95 |
HUN | Hungary | parliament | 2006-04-09 | 43.2 | 190 | 386 | MSZP | Magyar Szocialista Párt | Hungarian Socialist Party | 2.8743 | 39 | 194 | 463 | 188 | 1591 |
ITA | Italy | parliament | 2006-04-09 | 2.31 | 17 | 630 | IdV | Italia dei Valori | Italy of Values | 4.8712 | 26 | 107 | 498 | 567 | 693 |
ITA | Italy | parliament | 2006-04-09 | 12.01 | 71 | 630 | AN | Alleanza Nazionale | National Alliance | 8.0871 | 26 | 107 | 498 | 567 | 373 |
ITA | Italy | parliament | 2006-04-09 | 4.51 | 26 | 630 | LN | Lega Nord | North League | 7.8007 | 26 | 107 | 498 | 567 | 1436 |
ITA | Italy | parliament | 2006-04-09 | 2.25 | 16 | 630 | PdCI | Partito dei Comunisti Italiani | Party of the Italian Communists | 1.0423 | 26 | 107 | 498 | 567 | 1661 |
ITA | Italy | parliament | 2006-04-09 | 2.53 | 18 | 630 | R | Radicali | Radicals | 3.9732 | 26 | 107 | 498 | 567 | 1296 |
ITA | Italy | parliament | 2006-04-09 | 0.47 | 4 | 630 | SVP | Südtiroler Volkspartei | South Tyrol Peoples Party | 5.4 | 26 | 107 | 498 | 567 | 1030 |
ITA | Italy | parliament | 2006-04-09 | 1.08 | 6 | 630 | LUP | L'Unione-Prodi | The Union-Prodi | 2.6216 | 26 | 107 | 498 | 567 | 1246 |
ITA | Italy | parliament | 2006-04-09 | 6.75 | 39 | 630 | UC | Unione / Centro | Union / Centre | 6.1092 | 26 | 107 | 498 | 567 | 226 |
ITA | Italy | parliament | 2006-04-09 | 1.39 | 10 | 630 | UDEUR | Unione Democratici per l'Europa | Union of Democrats for Europe | 5.285 | 26 | 107 | 498 | 567 | 399 |
HUN | Hungary | parliament | 2006-04-09 | 1 | 386 | one-seat | one seat | one seat | 39 | 194 | 463 | 188 | 952 | ||
ITA | Italy | parliament | 2006-04-09 | 0.18 | 1 | 630 | one-seat | one seat | one seat | 26 | 107 | 498 | 567 | 2302 |
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;