view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
263 rows where family_name_short = "con" sorted by cmp
This data as json, CSV (advanced)
Suggested facets: castles_mair, ray
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AUS | Australia | ACP-V | Australian Country Party (Vic) | Australian Country Party (Vic) | Australian Country Party (Vic) | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1935 | 26 | |||||||||
AUS | Australia | C | Coalition | Coalition | Coalition | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1428 | 26 | |||||||||
AUS | Australia | CLP | Commonwealth Liberal Party | Commonwealth Liberal Party | Commonwealth Liberal Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 2285 | 26 | |||||||||
AUS | Australia | CPP-V | Country Progressive Party (Vic) | Country Progressive Party (Vic) | Country Progressive Party (Vic) | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1914 | 26 | |||||||||
AUS | Australia | FFP | Family First Party | Family First Party | Family First Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 446 | 26 | |||||||||
AUS | Australia | IPP-V | Independent Protectionist Party (Vic) | Independent Protectionist Party (Vic) | Independent Protectionist Party (Vic) | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1917 | 26 | |||||||||
AUS | Australia | LP | Liberal Party | Liberal Party | Liberal Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 2286 | 26 | |||||||||
AUS | Australia | NAT-WA | Nationalist | Nationalist | Nationalist | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1925 | 26 | |||||||||
AUS | Australia | PP | Protectionist Party | Protectionist Party | Protectionist Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1898 | 26 | |||||||||
AUS | Australia | QC | Queensland Country Party | Queensland Country Party | Queensland Country Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1928 | 26 | |||||||||
AUS | Australia | UAP | United Australia Party | United Australia Party | United Australia Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1912 | 26 | |||||||||
AUS | Australia | VCP | Victorian Country Party | Victorian Country Party | Victorian Country Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1920 | 26 | |||||||||
AUT | Austria | DNP | German-Nationals | Deutschnationale | Deutschnationale | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 59 | 2672 | 26 | ||||||||
AUT | Austria | DVP | German People's Party | Deutsche Volkspartei | Deutsche Volkspartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 59 | 2673 | 26 | ||||||||
AUT | Austria | GDVP | Greater German People's Party | Großdeutsche Volkspartei | Grossdeutsche Volkspartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 59 | 2674 | 26 | ||||||||
AUT | Austria | REKOS | The Reform Conservatives | Die Reformkonservativen – REKOS | Die Reformkonservativen -- REKOS | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 59 | 2339 | 26 | ||||||||
BEL | Belgium | Pp | People's Party | Parti populaire | Parti populaire | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 64 | 438 | 26 | ||||||||
BGR | Bulgaria | BBZ | Bulgaria Without Censorship | Balgarija bes Zensura | Balgarija bes Zensura | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2362 | 26 | ||||||||
BGR | Bulgaria | BNG | Bulgaria for Citizens Movement | Dvizhenie "Balgariya na grazhdanite" | Dvizhenie "Balgariya na grazhdanite" | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2213 | 26 | ||||||||
BGR | Bulgaria | BV | Bulgarian Rise | Balgarski vazhod | Balgarski vazhod | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2871 | 26 | ||||||||
BGR | Bulgaria | DSB|DB | Democrats for a Strong Bulgaria | Democratic Bulgaria | Demokrati za Silna Balgariya | Demokratichna Balgariya | Demokrati za Silna Balgariya | Demokratichna Balgariya | con | Conservative | 7.85 | 7.83 | 4.5 | 8.9667 | 28 | 1100001 | 2008 | 10 | 57 | 26 | |||||
BGR | Bulgaria | ITN | There Is Such a People | Ima takav narod | Ima takav narod | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2836 | 26 | ||||||||
BGR | Bulgaria | PS | Patriotic Union | Patriotichen Suyuz | Patriotichen Suyuz | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2177 | 26 | ||||||||
BGR | Bulgaria | RB | Reformist Bloc | Reformatorski Blok | Reformatorski Blok | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2363 | 26 | ||||||||
BGR | Bulgaria | RzB | Republicans for Bulgaria | Republikantsi za Balgariya | Republikantsi za Balgariya | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2814 | 26 | ||||||||
BGR | Bulgaria | SK | Blue Coalition | Sinyata Koalitsiya | Sinyata Koalitsiya | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 1100001 | 10 | 1254 | 26 | |||||||
BGR | Bulgaria | VMRO | IMRO -- Bulgarian National Movement | VMRO – Balgarsko Natsionalno Dvizhenie | VMRO -- Balgarsko Natsionalno Dvizhenie | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2212 | 26 | ||||||||
CAN | Canada | CPC | Conservative Party of Canada | Conservative Party of Canada | Conservative Party of Canada | con | Conservative | 8.6608 | 8.7668 | 9.0688 | 5233 | 29 | 1255 | 26 | ||||||||
CAN | Canada | RP | Reconstruction Party of Canada | Reconstruction Party of Canada | Reconstruction Party of Canada | con | Conservative | 7.4 | 6.4 | 6.9 | 29 | 2565 | 26 | |||||||||
CHE | Switzerland | BDP | Conservative Democratic Party of Switzerland | Bürgerlich–Demokratische Partei (BDP) Graubünden | Buergerlich--Demokratische Partei (BDP) Graubuenden | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 3612 | 40 | 1213 | 26 | |||||||
CYP | Cyprus | GTE | For Europe | Gia tin Evropi | For Europe | con | Conservative | 7.4 | 6.4 | 6.9 | 51 | 768 | 26 | |||||||||
CZE | Czech Republic | CP-SB | Conservative Party -- Free Bloc | Konzervativní strana – Svobodný blok | Konzervativni strana -- Svobodny blok | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 68 | 2102 | 26 | ||||||||
CZE | Czech Republic | TOP09 | Tradition Responsibility Prosperity 09 | Tradice Odpovědnost Prosperita 09 | Tradice Odpovednost Prosperita 09 | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 2109 | 68 | 2 | 26 | |||||||
CZE | Czech Republic | UPD | Dawn of Direct Democracy | Úsvit přímé demokracie | Usvit prime demokracie | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 68 | 2262 | 26 | ||||||||
DEU | Germany | DHP | German-Hanoverian Party | Deutsch-Hannoversche Partei | Deutsch-Hannoversche Partei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 2696 | 26 | ||||||||
DEU | Germany | DVP | German People's Party | Deutsche Volkspartei | Deutsche Volkspartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 2693 | 26 | ||||||||
DEU | Germany | FW | Free Voters | Freie Wähler | Freie Waehler | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 121 | 54 | 41 | 26 | |||||||
DEU | Germany | Fam | Family Party of Germany | Familien-Partei Deutschlands | Familien-Partei Deutschlands | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 1235 | 26 | ||||||||
DEU | Germany | GDP | All-German Party | Gesamtdeutsche Partei | Gesamtdeutsche Partei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 1701 | 26 | ||||||||
DEU | Germany | KVP | Conservative Peoples' Party | Konservative Volkspartei | Konservative Volkspartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 2711 | 26 | ||||||||
DEU | Germany | WP | Economic Party | Wirtschaftspartei | Wirtschaftspartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 2698 | 26 | ||||||||
DNK | Denmark | FF | People's Party (Faroe Islands) | Hin føroyski fólkaflokkurin – radikalt sjálvstýri | Hin foroyski folkaflokkurin -- radikalt sjalvstyri | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 21 | 2574 | 26 | ||||||||
DNK | Denmark | NS | National Cooperation | National Samvirke | National Samvirke | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 21 | 2431 | 26 | ||||||||
DNK | Denmark | Sbf | Union Party (Faroe Islands) | Sambandsflokkurin | Sambandsflokkurin | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 21 | 1892 | 26 | ||||||||
ESP | Spain | CDC|JxCat | Democratic Convergence | Together for Catalonia | Convergència Democràtica | Junts per Catalunya | Convergencia Democratica | Junts per Catalunya | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 27 | 2605 | 26 | ||||||||
ESP | Spain | NA+ | Sum Navarre | Navarra Suma | Navarra Suma | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 27 | 2723 | 26 | ||||||||
EST | Estonia | EV | Free Party | Eesti Vabaerakond | Eesti Vabaerakond | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 75 | 2409 | 26 | ||||||||
EST | Estonia | VEE | Russian Party in Estonia | Vene Erakond Eestis | Vene Erakond Eestis | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 75 | 2266 | 26 | ||||||||
FIN | Finland | IK | Patriotic People's Movement | Isänmaallinen Kansanliike – Fosterländska Folkrörelsen | Isanmaallinen Kansanliike -- Fosterlandska Folkrorelsen | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 67 | 957 | 26 | ||||||||
FIN | Finland | POP | Constitutional People's Party | Perustuslaillinen Oikeistopuolue – Konstitutionella högerpartiet | Perustuslaillinen Oikeistopuolue -- Konstitutionella hogerpartiet | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 67 | 1389 | 26 | ||||||||
FIN | Finland | SKYP | Finnish People's Unity Party | Suomen kansan yhtenäisyyden puolueen – Finlands folks enhetsparti | Suomen kansan yhtenaisyyden puolueen -- Finlands folks enhetsparti | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 67 | 139 | 26 | ||||||||
FIN | Finland | SP-V | Finnish Party -- Old Finns | Suomalainen puolue – Vanhasuomalaiset | Suomalainen puolue -- Vanhasuomalaiset | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 67 | 2434 | 26 | ||||||||
FRA | France | ARS | Republican and Social Action | Action républicaine et sociale | Action republicaine et sociale | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 2358 | 26 | ||||||||
FRA | France | C | Conservatives | Conservateurs | Conservateurs | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 2589 | 26 | ||||||||
FRA | France | CeD | Centre Right | Centre-droit | Centre-droit | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 2250 | 26 | ||||||||
FRA | France | DLR|DLF | Republic Arise | France Arise | Debout la république | Debout la France | Debout la republique | Debout la France | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 2399 | 26 | ||||||||
FRA | France | IR|DL | Independent Republicans | Liberal Democracy | Independants républicains | Démocratie libérale | Independants republicains | Democratie liberale | con | Conservative | 7.0577 | 7.7993 | 6.1743 | 8.246 | 1410 | 606 | 615 | 43 | 59 | 26 | |||||
FRA | France | MF | Movement for France | Mouvement pour la France | Mouvement pour la France | con | Conservative | 8.1721 | 7.5376 | 8.6774 | 1.0651 | 111 | 612 | 5831 | 612 | 43 | 1101 | 26 | ||||
FRA | France | RGR | Rally of Republican Lefts | Rassemblement des gauches républicaines | Rassemblement des gauches republicaines | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 890 | 26 | ||||||||
FRA | France | RI | Independent Radicals | Radicaux indépendants | Radicaux independants | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 2585 | 26 | ||||||||
FRA | France | RP | Progressive Republicans | Républicains progressistes | Republicains progressistes | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 2586 | 26 | ||||||||
FRA | France | RPF | Rally for France | Rassemblement pour la France | Rassemblement pour la France | con | Conservative | 7.4 | 6.7849 | 8.5048 | 1.0885 | 5873 | 43 | 2252 | 26 | |||||||
FRA | France | RPR+UDF | RPR/UDF connected list | Listes communes RPR/UDF | Listes communes RPR/UDF | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 2264 | 26 | ||||||||
FRA | France | U5R | Union for the fifth republic | Union pour la cinquième république | Union pour la cinquieme republique | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 2284 | 26 | ||||||||
FRA | France | UDI | Union of Democrats and Independents | Union des démocrates et indépendants | Union des democrates et independants | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 2273 | 26 | ||||||||
FRA | France | UPR | Popular Republican Union | Union Populaire Républicaine | Union Populaire Republicaine | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 2734 | 26 | ||||||||
FRA | France | agir | Act, the constructive right | Agir, la droite constructive | Agir, la droite constructive | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 2862 | 26 | ||||||||
FRA | France | d-droite | other right | divers droite | divers droite | con | Conservative | 7.6583 | 9.0 | 9.0 | 5.8333 | 618 | 43 | 285 | 26 | |||||||
GBR | United Kingdom | C | Constitutionalist | Constitutionalist | Constitutionalist | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 44 | 2514 | 26 | ||||||||
GBR | United Kingdom | Con-18 | Conservatives | Conservatives [no coupon] | Conservatives | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 44 | 2719 | 26 | ||||||||
GBR | United Kingdom | EuCon | Pro-Euro Conservative Party | Pro-Euro Conservative Party | Pro-Euro Conservative Party | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 44 | 2061 | 26 | ||||||||
GBR | United Kingdom | Na | National | National | National | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 44 | 2518 | 26 | ||||||||
GRC | Greece | DIANA | Democratic Renewal | Dimokratiki Ananeosi | Dimokratiki Ananeosi | con | Conservative | 7.4 | 6.4 | 6.9 | 10.0 | 149 | 405 | 41 | 1374 | 26 | ||||||
GRC | Greece | DX | Recreate Greece | Dimiourgia Xana | Dimiourgia Xana | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41 | 2095 | 26 | ||||||||
GRC | Greece | E-OAD | Greece, the Other Way | Ellada – O Allos Dromos | Ellada -- O Allos Dromos | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41 | 2744 | 26 | ||||||||
GRC | Greece | EL | Greek Solution | Elliniki Lisi | Elliniki Lisi | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41 | 2780 | 26 | ||||||||
GRC | Greece | EPL | Union for the Homeland and the People | Enosi Gia Tin Patrida Kai Ton Lao | Enosi Gia Tin Patrida Kai Ton Lao | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41 | 2348 | 26 | ||||||||
GRC | Greece | KEK | Party of Greek Hunters | Kómma Ellênòn Kynègôn | Komma Ellenon Kynegon | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41 | 2167 | 26 | ||||||||
GRC | Greece | KP | Progressive Party | Komma Proodeftikon | Komma Proodeftikon | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41 | 2123 | 26 | ||||||||
HRV | Croatia | HPS | Croatian People's Party | Hrvatska pucka stranka | Hrvatska pucka stranka | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 62 | 2203 | 26 | ||||||||
HRV | Croatia | Most | Bridge of Independent Lists | Most nezavisnih lista | Most nezavisnih lista | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 62 | 2615 | 26 | ||||||||
HRV | Croatia | NHR | Independents for Croatia | Neovisni za Hrvatsku | Neovisni za Hrvatsku | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 62 | 2770 | 26 | ||||||||
HRV | Croatia | SDA | Party of Democratic Action of Croatia | Stranka demokratske akcije Hrvatske | Stranka demokratske akcije Hrvatske | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 62 | 2270 | 26 | ||||||||
HUN | Hungary | MM | Momentum Movement | Momentum Mozgalom | Momentum Mozgalom | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 39 | 2659 | 26 | ||||||||
IRL | Ireland | A | Aontu | Aontú | Aontu | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2795 | 26 | ||||||||
IRL | Ireland | CG | Society of the Gaels | Cumann na nGaedheal | Cumann na nGaedheal | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2447 | 26 | ||||||||
IRL | Ireland | CPA | Cork Progressive Association | Cork Progressive Association | Cork Progressive Association | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2525 | 26 | ||||||||
IRL | Ireland | IFF | Independent Fianna Fail | Independent Fianna Fáil | Independent Fianna Fail | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2326 | 26 | ||||||||
IRL | Ireland | Lib | Libertas Ireland | Libertas Ireland | Libertas Ireland | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 171 | 1372001 | 37 | 1199 | 26 | ||||||
IRL | Ireland | NCP | National Centre Party | National Centre Party | National Centre Party | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2442 | 26 | ||||||||
IRL | Ireland | NLP | National League Party | National League Party | National League Party | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2443 | 26 | ||||||||
IRL | Ireland | NP | National Party | National Party | National Party | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2218 | 26 | ||||||||
IRL | Ireland | RI | Renua Ireland | Renua Ireland | Renua Ireland | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2620 | 26 | ||||||||
ISL | Iceland | Lve | Republican Party | Lýðveldisflokkurinn | Lydveldisflokkurinn | con | Conservative | 7.4 | 6.4 | 6.9 | 56 | 2005 | 26 | |||||||||
ISL | Iceland | Sj-07 | Independence Party -- 1907 | Sjálfstæðisflokkurinn – 1907 | Sjalfstaedisflokkurinn -- 1907 | con | Conservative | 7.4 | 6.4 | 6.9 | 56 | 2561 | 26 | |||||||||
ISL | Iceland | Thve | Common Wealth Party | Þjóðveldisflokkurinn | Tjodveldisflokkurin | con | Conservative | 7.4 | 6.4 | 6.9 | 56 | 2004 | 26 | |||||||||
ISL | Iceland | V | Revival | Viðreisn | Vioreisn | con | Conservative | 7.4 | 6.4 | 6.9 | 56 | 2633 | 26 | |||||||||
ISR | Israel | G-96 | Bridge -- 1996 | Gesher – 1996 | Gesher -- 1996 | con | Conservative | 7.4 | 6.4 | 6.9 | 34 | 1862 | 26 | |||||||||
ISR | Israel | RM | National List | Reshima Mamlakhtit | Reshima Mamlakhtit | con | Conservative | 7.4 | 6.4 | 6.9 | 34 | 1841 | 26 | |||||||||
ISR | Israel | SVM | Sephardim and Oriental Communities | Sfaradim VeEdot Mizrah | Sfaradim VeEdot Mizrah | con | Conservative | 7.4 | 6.4 | 6.9 | 34 | 1831 | 26 |
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;