view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
120 rows where family_name = "Christian democracy"
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ROU | Romania | CDR | Romanian Democratic Convention | Convenţia Democrată Română | Conventia Democrata Romana | chr | Christian democracy | 6.29 | 6.71 | 4.43 | 9.7667 | 93411 | 2707 | 23 | 356 | 3 | ||||||
ROU | Romania | FC | Civic Force | Forța Civică | Forta Civica | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 23 | 2129 | 3 | ||||||||
ROU | Romania | PMP | People's Movement Party | Partidul Mișcarea Populară | Partidul Miscarea Populara | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 23 | 2395 | 3 | ||||||||
ROU | Romania | PNG-CD | New Generation Party -- Christian Democratic | Partidul Noua Generaţie – Creştin Democrat | Partidul Noua Generatie -- Crestin Democrat | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 23 | 1332 | 3 | ||||||||
ROU | Romania | PNT-CD | Christian-Democratic National Peasants' Party | Partidul Naţional Ţărănesc Creştin Democrat | Partidul National Taranesc Crestin Democrat | chr | Christian democracy | 5.5341 | 4.9393 | 6.8421 | 8.8158 | 93521 | 1642800 | 3205 | 3278 | 23 | 888 | 3 | ||||
SVK | Slovakia | DS | Democratic Party | Demokratická strana | Demokraticka strana | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 96420 | 1 | 1000 | 3 | |||||||
SVK | Slovakia | KDH | Christian Democratic Movement | Kresťanskodemokratické hnutie | Krest'anskodemokraticke hnutie | chr | Christian democracy | 7.1082 | 6.9698 | 8.8217 | 6.6998 | 96521 | 254 | 1703521 | 3405 | 3902 | 2805 | 1 | 1432 | 3 | ||
SVK | Slovakia | KDZP | Christian Democracy -- Life and Prosperity | Kresťanská demokracia – Život a prosperita | Krestanska demokracia -- Zivot a prosperita | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 1 | 2783 | 3 | ||||||||
SVK | Slovakia | KSU | Christian Social Union | Krest’anská sociálna únia Slovenska | Krestanska socialna unia Slovenska | chr | Christian democracy | 6.6667 | 5.7 | 7.1 | 8.3 | 3406 | 1 | 936 | 3 | |||||||
SVK | Slovakia | KU | Christian Union | Kresťanská únia | Krestanska unia | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 1 | 2750 | 3 | ||||||||
SVK | Slovakia | MKDM | Hungarian Christian Democratic Movement | Maďarské kresťanskodemokratické hnutie – Magyar kereszténydemokrata mozgalom | Madarske krestanskodemokraticke hnutie -- Magyar keresztenydemokrata mozgalom | chr | Christian democracy | 6.6667 | 5.7 | 7.1 | 8.3 | 3407 | 1 | 2247 | 3 | |||||||
SVK | Slovakia | MS | Beautiful Slovakia | Magnificat Slovakia | Magnificat Slovakia | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 1 | 2390 | 3 | ||||||||
SVK | Slovakia | NOVA | New Majority | Nová väčšina | Nova vacsina | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 1 | 2803 | 3 | ||||||||
SVK | Slovakia | SDK | Slovak Democratic Coalition | Slovenská demokratická koalícia | Slovenska demokraticka koalicia | chr | Christian democracy | 7.19 | 7.77 | 4.02 | 9.225 | 96522 | 2802 | 1 | 313 | 3 | ||||||
SVK | Slovakia | SDKU-DS | Slovak Democratic and Christian Union -- Democratic Party | Slovenská demokratická a kresťanská únia – Demokratická strana | Slovenska demokraticka a krestanska unia -- Demokraticka strana | chr | Christian democracy | 7.3591 | 7.4401 | 5.0433 | 9.3905 | 96523 | 256 | 1703523 | 4079 | 2802 | 1 | 131 | 3 | |||
SVN | Slovenia | KS | Christian Socialists | Krščanski socialisti | Krscanski socialisti | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 60 | 2241 | 3 | ||||||||
SVN | Slovenia | NSI | New Slovenia -- Christian People's Party | Nova Slovenija – Krščanska ljudska stranka | Nova Slovenija -- Krscanska ljudska stranka | chr | Christian democracy | 7.9345 | 5.9719 | 8.3998 | 8.4866 | 97522 | 262 | 1705522 | 4235 | 2905 | 60 | 1047 | 3 | |||
SVN | Slovenia | SDS | Slovenian Democratic Party | Slovenska demokratska stranka | Slovenska demokratska stranka | chr | Christian democracy | 6.9996 | 5.6339 | 6.7947 | 8.804 | 97320 | 263 | 1705320 | 4261 | 2902 | 60 | 179 | 3 | |||
SVN | Slovenia | SLS | Slovenian People's Party | Slovenska ljudska stranka | Slovenska ljudska stranka | chr | Christian democracy | 6.6953 | 5.0282 | 7.6299 | 6.8549 | 97521 | 264 | 1705521 | 4287 | 2904 | 60 | 16 | 3 | |||
SWE | Sweden | KD | Christian Democrats | Kristdemokraterna | Kristdemokraterna | chr | Christian democracy | 7.195 | 6.7938 | 7.9997 | 7.8597 | 11520 | 283 | 1752520 | 3706 | 1606 | 7880 | 1606 | 35 | 282 | 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;