view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
2 rows where country_name = "Portugal" and 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PRT | Portugal | CDS-PP | Democratic and Social Centre -- People's Party | Centro Democrático e Social – Partido Popular | Centro Democratico e Social -- Partido Popular | chr | Christian democracy | 8.0222 | 8.1963 | 8.9916 | 4.3909 | 35314 | 233 | 1620314 | 3104 | 1202 | 7650 | 1202 | 63 | 251 | 3 | |
PRT | Portugal | PDC | Christian Democratic Party | Partido da Democracia Cristã | Partido da Democracia Crista | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 5.8333 | 1210 | 63 | 427 | 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;