view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
5 rows where country_name_short = "EST" and family_name = "Agrarian"
This data as json, CSV (advanced)
Suggested facets: left_right
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EST | Estonia | EM | Estonian Country Union | Eesti Maaliit | Eesti Maaliit | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 75 | 2403 | 2 | ||||||||
EST | Estonia | EMK | Estonian Rural Centre Party | Eesti Maa-Keskerakond | Eesti Maa-Keskerakond | agr | Agrarian | 5.5556 | 4.9 | 6.5 | 5.4 | 1207 | 75 | 1257 | 2 | |||||||
EST | Estonia | EPPE | Estonian Party of Pensioners and Families | Eesti Pensionäride ja Perede Erakond | Eesti Pensionaride ja Perede Erakond | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 75 | 2402 | 2 | ||||||||
EST | Estonia | ETE | Estonian Farmers Party | Eesti Talurahva Erakond | Eesti Talurahva Erakond | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 75 | 1796 | 2 | ||||||||
EST | Estonia | PK | Union of Farmers | Põllumeeste Kogu | Pollumeeste Kogu | agr | Agrarian | 2.2222 | 4.9 | 6.5 | 5.4 | 1203 | 75 | 1553 | 2 |
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;