view_party (view)

Table actions

Data source: ParlGov · About: simonw/parlgov-datasette

0 rows where family_id = 28

✎ View and edit SQL

This data as json

0 records

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;