view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
2 rows where country_name = "Bulgaria" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BGR | Bulgaria | DP | Democratic Party | Demokraticheska Partiya | Demokraticheska Partiya | chr | Christian democracy | 9.4444 | 5.7 | 7.1 | 8.3 | 709 | 10 | 542 | 3 | |||||||
BGR | Bulgaria | SDS | Union of Democratic Forces | Suyuz na Demokratichnite Sili | Suyuz na Demokratichnite Sili | chr | Christian democracy | 6.1111 | 5.7 | 7.1 | 8.3 | 80410 | 33 | 707 | 10 | 423 | 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;