view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
17 rows where country_name = "Italy" and family_name = "Christian democracy"
This data as json, CSV (advanced)
Suggested facets: state_market, liberty_authority, eu_anti_pro, ray, chess
country_name_short | country_name | party_name_short | party_name_english | party_name | party_name_ascii | family_name_short | family_name | left_right | state_market | liberty_authority | eu_anti_pro | cmp | euprofiler | ees | castles_mair | huber_inglehart | ray | benoit_laver | chess | country_id | party_id | family_id |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ITA | Italy | AD | Democratic Alliance | Alleanza Democratica | Alleanza Democratica | chr | Christian democracy | 5.0 | 5.0 | 5.0 | 6.6667 | 32529 | 817 | 26 | 896 | 3 | ||||||
ITA | Italy | CCD | Christian Democratic Centre | Centro Cristiano Democratico | Centro Cristiano Democratico | chr | Christian democracy | 5.9067 | 5.1167 | 7.5833 | 8.5 | 32521 | 815 | 814 | 26 | 99 | 3 | |||||
ITA | Italy | CCD+CDU | Christian Democratic Centre / United Christian Democrats | Centro Cristiano Democratico / Cristiani Democratici Uniti | Centro Cristiano Democratico / Cristiani Democratici Uniti | chr | Christian democracy | 5.9067 | 5.1167 | 7.5833 | 8.5 | 32522 | 815 | 814 | 26 | 627 | 3 | |||||
ITA | Italy | CDU | United Christian Democrats | Cristiani Democratici Uniti | Cristiani Democratici Uniti | chr | Christian democracy | 6.1667 | 5.145 | 7.7583 | 7.4426 | 818 | 818 | 26 | 128 | 3 | ||||||
ITA | Italy | CS | Social Christians | Cristiano Sociali | Cristiano Sociali | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 26 | 1431 | 3 | ||||||||
ITA | Italy | DC | Christian Democrats | Democrazia Cristiana | Democrazia Cristiana | chr | Christian democracy | 5.6611 | 5.7 | 7.1 | 8.9667 | 32520 | 1008 | 2107 | 801 | 26 | 1633 | 3 | ||||
ITA | Italy | DCA | Christian Democracy for the Autonomies | Democrazia Cristiana per le Autonomie | Democrazia Cristiana per le Autonomie | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 26 | 52 | 3 | ||||||||
ITA | Italy | DE | European Democracy | Democrazia Europea | Democrazia Europea | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 32901 | 26 | 488 | 3 | |||||||
ITA | Italy | ID | Democracy | I Democratici | I Democratici | chr | Christian democracy | 4.0844 | 4.3378 | 4.41 | 9.6944 | 819 | 26 | 961 | 3 | |||||||
ITA | Italy | MpA | Movement for Autonomy | Movimento per l'Autonomia | Movimento per l'Autonomia | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 840 | 26 | 1040 | 3 | |||||||
ITA | Italy | PPI | Italian People's Party | Partito Popolare Italiano | Partito Popolare Italiano | chr | Christian democracy | 4.6267 | 4.105 | 5.8567 | 9.0778 | 32520 | 801 | 823 | 26 | 142 | 3 | |||||
ITA | Italy | PS | Segni Pact | Patto Segni | Patto Segni | chr | Christian democracy | 6.0 | 6.4 | 4.6 | 8.3333 | 826 | 26 | 827 | 3 | |||||||
ITA | Italy | PpP | Popular Party for Prodi | Popolari per Prodi | Popolari per Prodi | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 26 | 840 | 3 | ||||||||
ITA | Italy | Rete | Movement for Democracy -- The Net | Movimento per la Democrazia – La Rete | Movimento per la Democrazia -- La Rete | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 6.6667 | 32951 | 813 | 26 | 366 | 3 | ||||||
ITA | Italy | UC | Union / Centre | Unione / Centro | Unione / Centro | chr | Christian democracy | 6.1092 | 5.1181 | 7.8038 | 7.128 | 188 | 1380523 | 818 | 6846 | 818 | 26 | 226 | 3 | |||
ITA | Italy | UDEUR | Union of Democrats for Europe | Unione Democratici per l'Europa | Unione Democratici per l'Europa | chr | Christian democracy | 5.285 | 4.61 | 7.195 | 8.3833 | 829 | 26 | 399 | 3 | |||||||
ITA | Italy | UDR | Union of republican democrats | Unione dei democratici per la repubblica | Unione dei democratici per la repubblica | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 26 | 1145 | 3 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW view_party AS SELECT c.name_short AS country_name_short, c.name AS country_name, p.name_short AS party_name_short, p.name_english AS party_name_english, p.name AS party_name, p.name_ascii AS party_name_ascii, ii.short AS family_name_short, ii.name AS family_name, left_right, state_market, liberty_authority, eu_anti_pro, cmp, euprofiler, ees, castles_mair, huber_inglehart, ray, benoit_laver, chess, country_id, p.id AS party_id, family_id FROM party p LEFT OUTER JOIN info_id ii ON p.family_id = ii.id LEFT OUTER JOIN viewcalc_party_position vpp ON p.id = vpp.party_id LEFT OUTER JOIN (SELECT id, name, name_short FROM country) c -- avoid name conflict with party table ON p.country_id = c.id ORDER BY c.name_short, p.name_short;