view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
22 rows where "election_date" is on date 1994-03-27 sorted by previous_cabinet_id
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ITA | Italy | parliament | 1994-03-27 | 117 | 630 | LN | Lega Nord | North League | 7.8007 | 26 | 146 | 605 | 801 | 1436 | |
ITA | Italy | parliament | 1994-03-27 | 109 | 630 | AN | Alleanza Nazionale | National Alliance | 8.0871 | 26 | 146 | 605 | 801 | 373 | |
ITA | Italy | parliament | 1994-03-27 | 109 | 630 | DS | Democratici di Sinistra | Democrats of the Left | 2.6277 | 26 | 146 | 605 | 801 | 809 | |
ITA | Italy | parliament | 1994-03-27 | 99 | 630 | FI-PdL | Forza Italia – Il Popolo della Libertà | Go Italy -- The People of Freedom | 7.1459 | 26 | 146 | 605 | 801 | 596 | |
ITA | Italy | parliament | 1994-03-27 | 15.7 | 46 | 630 | PPI | Partito Popolare Italiano | Italian People's Party | 4.6267 | 26 | 146 | 605 | 801 | 142 |
ITA | Italy | parliament | 1994-03-27 | 39 | 630 | PRC | Partito della Rifondazione Comunista | Communist Refoundation Party | 0.8849 | 26 | 146 | 605 | 801 | 1321 | |
ITA | Italy | parliament | 1994-03-27 | 29 | 630 | CCD | Centro Cristiano Democratico | Christian Democratic Centre | 5.9067 | 26 | 146 | 605 | 801 | 99 | |
ITA | Italy | parliament | 1994-03-27 | 18 | 630 | AD | Alleanza Democratica | Democratic Alliance | 5.0 | 26 | 146 | 605 | 801 | 896 | |
ITA | Italy | parliament | 1994-03-27 | 14 | 630 | PSI | Partito Socialista Italiano | Italian Socialist Party | 3.7722 | 26 | 146 | 605 | 801 | 1475 | |
ITA | Italy | parliament | 1994-03-27 | 11 | 630 | FdV | Federazione dei Verdi | Federation of the Greens | 2.3725 | 26 | 146 | 605 | 801 | 910 | |
ITA | Italy | parliament | 1994-03-27 | 10 | 630 | none | senzo partito | no party affiliation | 26 | 146 | 605 | 801 | 1552 | ||
ITA | Italy | parliament | 1994-03-27 | 6 | 630 | Rete | Movimento per la Democrazia – La Rete | Movement for Democracy -- The Net | 6.2 | 26 | 146 | 605 | 801 | 366 | |
ITA | Italy | parliament | 1994-03-27 | 6 | 630 | R | Radicali | Radicals | 3.9732 | 26 | 146 | 605 | 801 | 1296 | |
ITA | Italy | parliament | 1994-03-27 | 5 | 630 | CS | Cristiano Sociali | Social Christians | 6.2 | 26 | 146 | 605 | 801 | 1431 | |
ITA | Italy | parliament | 1994-03-27 | 4 | 630 | UdCe | Unione Democratica di Centro | Democratic Union of the Centre | 6.0 | 26 | 146 | 605 | 801 | 397 | |
ITA | Italy | parliament | 1994-03-27 | 0.6 | 3 | 630 | SVP | Südtiroler Volkspartei | South Tyrol Peoples Party | 5.4 | 26 | 146 | 605 | 801 | 1030 |
ITA | Italy | parliament | 1994-03-27 | 2 | 630 | PLD | Polo Liberal-Democratico | Liberal Democratic Pole | 6.0 | 26 | 146 | 605 | 801 | 671 | |
ITA | Italy | parliament | 1994-03-27 | 1 | 630 | one-seat | one seat | one seat | 26 | 146 | 605 | 801 | 2302 | ||
ITA | Italy | parliament | 1994-03-27 | 0.2 | 1 | 630 | LAM | Lega d'Azione Meridionale | Southern Action League | 8.8 | 26 | 146 | 605 | 801 | 436 |
ITA | Italy | parliament | 1994-03-27 | 0.1 | 1 | 630 | UV | Union Valdôtaine | Valdotanian Union | 26 | 146 | 605 | 801 | 974 | |
ITA | Italy | parliament | 1994-03-27 | 34.3 | 630 | CeS | Centro-sinistra | Centre Left | 3.3 | 26 | 146 | 605 | 801 | 1048 | |
ITA | Italy | parliament | 1994-03-27 | 46.4 | 630 | CeD | Centro-destra | Centre Right | 7.4 | 26 | 146 | 605 | 801 | 67 |
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;