view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
4 rows where country_name = "Spain" and family_name = "Christian democracy"
This data as json, CSV (advanced)
Suggested facets: state_market, liberty_authority, eu_anti_pro
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ESP | Spain | CDS | Democratic and Social Centre | Centró Democrático y Social | Centro Democratico y Social | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 9.7167 | 33512 | 503 | 27 | 637 | 3 | ||||||
ESP | Spain | EDC | Electoral Coalition of Christian Democratic Team | Coalición Electoral Equipo de la Democracia Cristiana | Coalicion Electoral Equipo de la Democracia Cristiana | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 27 | 2084 | 3 | ||||||||
ESP | Spain | PNV | Basque Nationalist Party | Partido Nacionalista Vasco – Euzko Alderdi Jeltzalea | Partido Nacionalista Vasco -- Euzko Alderdi Jeltzalea | chr | Christian democracy | 6.2144 | 5.7468 | 6.5139 | 7.8556 | 33902 | 358 | 1724902 | 1409 | 3606 | 506 | 7780 | 506 | 27 | 1361 | 3 |
ESP | Spain | UCDCC | Union of Centre and Christian Democracy of Catalonia | Unió del Centre i la Democràcia Cristiana de Catalunya | Unio del Centre i la Democracia Cristiana de Catalunya | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 27 | 62 | 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;