view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
3 rows where country_name_short = "LTU" and family_name = "to be coded"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LTU | Lithuania | LUP | Lithuanian Party of Economy | Lietuvos ūkio partijos | Lietuvos ukio partija | code | to be coded | 15 | 2037 | 28 | ||||||||||||
LTU | Lithuania | TPJ | National Progress Movement | Tautos pazangos judejimas | Tautos pazangos judejimas | code | to be coded | 15 | 1783 | 28 | ||||||||||||
LTU | Lithuania | UTL | Peoples Union "For Just Lithuania" | Liaudies sąjunga "Uz teisingą Lietuvą" | Peoples Union "For Just Lithuania" | code | to be coded | 15 | 2039 | 28 |
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;