view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by chess
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CHE | Switzerland | V | Vigilants | Vigilance | Vigilance | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 40 | 2775 | 40 | ||||||||
CHE | Switzerland | etc | others | others | others | none | no family | 40 | 2579 | 12 | ||||||||||||
CHE | Switzerland | none | no party affiliation | parteilos | parteilos | none | no family | 40 | 1211 | 12 | ||||||||||||
CHE | Switzerland | one-seat | one seat | one seat | one seat | none | no family | 40 | 2303 | 12 | ||||||||||||
CYP | Cyprus | ADISOK | Democratic Socialist Renewal Movement | Anorthotiko Dimokratiko Sosialistiko Kinima | Anorthotiko Dimokratiko Sosialistiko Kinima | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 51 | 1779 | 14 | |||||||||
CYP | Cyprus | ADK | Fighting Democratic Movement | Agonistiko Dimokratiko Kinima | Agonistiko Dimokratiko Kinima | right | Right-wing | 7.7632 | 5.2632 | 5.0 | 5333 | 51 | 1049 | 40 | ||||||||
CYP | Cyprus | AK | Famagusta for Cyprus | Ammókhostos yia tin Kípro | Ammokhostos yia tin Kipro | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 2818 | 6 | |||||||||
CYP | Cyprus | AKEL | Progressive Party of Working People | Anorthotikó Kómma Ergazómenou Laoú | Anorthotikon Komma Ergazemenou Laou | com | Communist/Socialist | 1.0526 | 2.6316 | 6.1842 | 55321 | 49 | 1196321 | 5351 | 51 | 572 | 14 | |||||
CYP | Cyprus | AM | Awakening 2020 | Afypnisis 2020 | Afypnisis 2020 | spec | Special issue | 51 | 2819 | 16 | ||||||||||||
CYP | Cyprus | Anex | Independents Movement | Independents Movement | Independents Movement | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 2817 | 6 | |||||||||
CYP | Cyprus | DIKO | Democratic Party | Dimokratikó Kómma | Dimokratiko Komma | con | Conservative | 5.1316 | 4.0789 | 6.0526 | 55422 | 50 | 1196422 | 5369 | 51 | 851 | 26 | |||||
CYP | Cyprus | DISY | Democratic Rally | Dimokratikós Sinayermós | Dimokratikos Synagermos | con | Conservative | 8.6842 | 7.3684 | 5.0 | 55711 | 51 | 1196711 | 5387 | 51 | 1575 | 26 | |||||
CYP | Cyprus | DP | Democratic Alignment | Dimokratiki Parataxi | Dimokratiki Parataxi | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 2741 | 6 | |||||||||
CYP | Cyprus | ED | United Democrats | Enomeni Dimokrates | Enomeni Dimokrates | lib | Liberal | 7.1053 | 6.0526 | 4.3421 | 55423 | 5423 | 51 | 1523 | 6 | |||||||
CYP | Cyprus | EDEK | Movement for Social Democracy EDEK | Kinima Sosialdimokraton EDEK | Kinima Sosialdimokraton EDEK | soc | Social democracy | 3.2895 | 4.7368 | 5.9211 | 55323 | 54 | 1196322 | 5405 | 51 | 945 | 11 | |||||
CYP | Cyprus | EK | European Party | Evropaiko Komma | Evropaiko Komma | lib | Liberal | 6.0 | 6.7 | 3.6 | 52 | 1196600 | 51 | 491 | 6 | |||||||
CYP | Cyprus | ELAM | National Popular Front | Ethniko Laiko Metopo | Ethniko Laiko Metopo | right | Right-wing | 8.8 | 5.9 | 8.5 | 51 | 1768 | 40 | |||||||||
CYP | Cyprus | EP | Active Citizens | Energi Polites | Energi Polites | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 51 | 2815 | 14 | |||||||||
CYP | Cyprus | EnKe | Union Centre | Enosi Kentrou | Enosi Kentrou | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 1777 | 6 | |||||||||
CYP | Cyprus | GTE | For Europe | Gia tin Evropi | For Europe | con | Conservative | 7.4 | 6.4 | 6.9 | 51 | 768 | 26 | |||||||||
CYP | Cyprus | Greek | Greek | Greek | Greek | none | no family | 51 | 1071 | 12 | ||||||||||||
CYP | Cyprus | I-SL | Independent -- Sener Levent | Independent – Sener Levent | Independent -- Sener Levent | none | no family | 51 | 2343 | 12 | ||||||||||||
CYP | Cyprus | KEP | Free Citizens Movement | K.E.P | K.E.P | code | to be coded | 51 | 1735 | 28 | ||||||||||||
CYP | Cyprus | KGTZTK | Animal Party Cyprus | Kinima gia ta zoa tis Kíprou | Kinima gia ta zoa tis Kiprou | spec | Special issue | 51 | 2627 | 16 | ||||||||||||
CYP | Cyprus | KINHMA | Solidarity Movement | Kinima Allileggiis | Kinima Allileggiis | right | Right-wing | 8.8 | 5.9 | 8.5 | 51 | 2626 | 40 | |||||||||
CYP | Cyprus | KOP | Ecological and Environmental Movement | Kinima Oikologoi Perivallontistoi | Kinima Oikologoi Perivallontistoi | eco | Green/Ecologist | 5.7895 | 5.5263 | 5.7895 | 53 | 1196110 | 5441 | 51 | 1621 | 19 | ||||||
CYP | Cyprus | LP | Liberal Party | Liberal Party | Liberal Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 1151 | 6 | |||||||||
CYP | Cyprus | ME | Message of Hope | Minima Elpidas | Minima Elpidas | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 2342 | 6 | |||||||||
CYP | Cyprus | NEDEPA | New Democratic Front | Nea Demokratiki Parataxi | Nea Demokratiki Parataxi | code | to be coded | 51 | 1778 | 28 | ||||||||||||
CYP | Cyprus | NO | New Horizons | Neoi Orizontes | Neoi Orizontes | right | Right-wing | 9.3421 | 6.5789 | 7.1053 | 5459 | 51 | 6 | 40 | ||||||||
CYP | Cyprus | PAME | Pancypriot Militant Front | Pankyprio Agonistiko Metopo | Pankyprio Agonistiko Metopo | right | Right-wing | 8.8 | 5.9 | 8.5 | 51 | 1776 | 40 | |||||||||
CYP | Cyprus | PL | People's Breath | Pní Laoú | Pni Laou | right | Right-wing | 8.8 | 5.9 | 8.5 | 51 | 2820 | 40 | |||||||||
CYP | Cyprus | SYM | Citizen's Alliance | Symmaxia | Symmaxia | soc | Social democracy | 3.3 | 3.5 | 3.5 | 51 | 2341 | 11 | |||||||||
CYP | Cyprus | Turkish | Turkish | Turkish | Turkish | none | no family | 51 | 1655 | 12 | ||||||||||||
CYP | Cyprus | YH | Jasmine Movement | Yasemin Hareketi | Yasemin Hareketi | soc | Social democracy | 3.3 | 3.5 | 3.5 | 51 | 2784 | 11 | |||||||||
CYP | Cyprus | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 51 | 534 | 12 | ||||||||||||
CZE | Czech Republic | ANO | Action of Dissatisfied Citizens 2011 | Akce nespokojených občanů 2011 | Akce nespokojenych obcanu 2011 | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 68 | 2263 | 6 | ||||||||
CZE | Czech Republic | ANO-VE | Yes, We Will Troll the Euro-Parliament | ANO, vytrollíme europarlament | ANO, vytrollime europarlament | spec | Special issue | 68 | 2779 | 16 | ||||||||||||
CZE | Czech Republic | CNSP | Czech National Social(ist) Party | Česká národně strana socialistická | Ceska narodne strana socialisticka | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 29 | 40 | ||||||||
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 | DSSS | Workers' Party of Social Justice | Dělnická strana sociální spravedlnosti | Delnicka strana socialni spravedlnosti | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 795 | 40 | ||||||||
CZE | Czech Republic | DU | Democratic Union | Demokratická unie | Demokraticka unie | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 68 | 1616 | 6 | ||||||||
CZE | Czech Republic | DZJ | Pensioners for a Secure Living | Důchodci za životní jistoty | Duchodci za zivotni jistoty | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 82901 | 68 | 77 | 11 | |||||||
CZE | Czech Republic | EDS | European Democratic Party | Evropská demokratická strana | Evropska demokraticka strana | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 56 | 68 | 1454 | 6 | |||||||
CZE | Czech Republic | H | Voice | Hlas | Hlas | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 68 | 2739 | 6 | ||||||||
CZE | Czech Republic | HSD-SMS | Movement for Self-Governing Democracy -- Society for Moravia and Silesia | Hnutí za samosprávnou demokracii – Společnost pro Moravu a Slezsko | Hnuti za samospravnou demokracii -- Spolecnost pro Moravu a Slezsko | spec | Special issue | 82951 | 68 | 19 | 16 | |||||||||||
CZE | Czech Republic | HSS | Movement for Social Justice | Hnutí za sociální spravedlnost | Hnuti za socialni spravedlnost | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 68 | 2223 | 11 | ||||||||
CZE | Czech Republic | KAN | Club of committed Non-Party Members | Klub angazovaných nestraníku | Klub angazovanych nestraniku | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 68 | 2220 | 6 | ||||||||
CZE | Czech Republic | KDS | Christian Democratic Party | Krestanskodemokraticka strana | Krestanskodemokraticka strana | chr | Christian democracy | 8.1444 | 5.7 | 7.1 | 8.3 | 82521 | 1008 | 68 | 440 | 3 | ||||||
CZE | Czech Republic | KSC | Communist Party of Czechoslovakia | Komunistická strana Československa | Komunisticka strana Ceskoslovenska | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 82220 | 68 | 665 | 14 | |||||||
CZE | Czech Republic | LB | Left Bloc | Levý Blok | Levy Blok | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 68 | 2224 | 14 | ||||||||
CZE | Czech Republic | LIDEM | LIDEM -- Liberal Democrats | LIDEM – liberální demokraté | LIDEM -- liberalni demokrate | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 68 | 2042 | 6 | ||||||||
CZE | Czech Republic | LSU | Liberal Social Union | Liberálně sociální unie | Liberalne socialni unie | lib | Liberal | 2.9667 | 6.7 | 3.6 | 8.7 | 82420 | 1003 | 68 | 1218 | 6 | ||||||
CZE | Czech Republic | NEI | Independent Initiative | Nezávislá iniciativa | Nezavisla iniciativa | code | to be coded | 68 | 2221 | 28 | ||||||||||||
CZE | Czech Republic | ODA | Civic Democratic Alliance | Občanská demokratická aliance | Obcanska demokraticka aliance | lib | Liberal | 7.1111 | 6.7 | 3.6 | 8.7 | 82412 | 1006 | 68 | 1123 | 6 | ||||||
CZE | Czech Republic | OF | Civic Forum | Obcanské fórum | Obcanske forum | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 82410 | 68 | 743 | 6 | |||||||
CZE | Czech Republic | OH|SD | Civic Movement | Free Democrats | Obcanské hnuti | Svobodní Demokraté | Obcanske hnuti | Svobodni Demokrate | lib | Liberal | 4.1667 | 6.7 | 3.6 | 8.7 | 1004 | 68 | 574 | 6 | |||||||
CZE | Czech Republic | P | Oath | Přísaha | Prisaha | spec | Special issue | 68 | 2831 | 16 | ||||||||||||
CZE | Czech Republic | PB | Right Bloc | Pravý Blok | Pravy Blok | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 2033 | 40 | ||||||||
CZE | Czech Republic | Pi | Czech Pirate Party | Ceska piratska strana | Ceska piratska strana | spec | Special issue | 68 | 2261 | 16 | ||||||||||||
CZE | Czech Republic | S-JB | Sovereignty -- Jana Bobosikova Bloc | Suverenita – blok Jany Bobošíkové | Suverenita -- blok Jany Bobosikove | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 1613 | 40 | ||||||||
CZE | Czech Republic | SCPZR | Czechoslovak Businessmen's, Traders' and Farmers' Party | Strana československých podnikatelů, živnostníků a rolníků | Strana ceskoslovenskych podnikatelu, zivnostniku a rolniku | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 68 | 2219 | 6 | ||||||||
CZE | Czech Republic | SPD | Freedom and Direct Democracy | Svoboda a přímá demokracie | Svoboda a prima demokracie | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 2654 | 40 | ||||||||
CZE | Czech Republic | SPOZ | Party of Civic Rights -- Zemanovci | Strana práv občanů – Zemanovci | Strana prav obcanu -- Zemanovci | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 68 | 406 | 11 | ||||||||
CZE | Czech Republic | SPP | Party of the Friends of Beer | Strana prátel piva | Strana pratel piva | spec | Special issue | 68 | 2222 | 16 | ||||||||||||
CZE | Czech Republic | SPR-RSC | Rally for the Republic -- Republican Party of Czechoslovakia | Sdruzení pro republiku – Republikánská strana Ceskoslovenska | Sdruzeni pro republiku -- Republikanska strana Ceskoslovenska | right | Right-wing | 9.7778 | 5.9 | 8.5 | 2.3 | 82710 | 1009 | 68 | 872 | 40 | ||||||
CZE | Czech Republic | SSO | Party of Free Citizens | Strana svobodných občanů | Strana svobodnych obcanu | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 63 | 68 | 363 | 40 | |||||||
CZE | Czech Republic | STAN | Mayors and Independents | Starostové a nezávislí | Starostove a nezavisli | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 68 | 2024 | 6 | ||||||||
CZE | Czech Republic | SZV | Alliance of Farmers and the Countryside | Spojenectví zemědělců a venkova | Spojenectvi zemedelcu a venkova | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 68 | 2101 | 2 | ||||||||
CZE | Czech Republic | Tri | Tricolour Citizens' Movement | Trikolóra | Trikolora | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 2832 | 40 | ||||||||
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 | ||||||||
CZE | Czech Republic | VB | Free Bloc | Volný blok | Volny blok | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 2854 | 40 | ||||||||
CZE | Czech Republic | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 68 | 1567 | 12 | ||||||||||||
DEU | Germany | AfD | Alternative for Germany | Alternative für Deutschland | Alternative fuer Deutschland | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 54 | 2253 | 40 | ||||||||
DEU | Germany | B90/Gr | Alliance 90 / Greens -- Citizens' Movement | Bündnis 90 / Grüne – BürgerInnenbewegung | Buendnis 90 / Gruene -- BuergerInnenbewegung | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 41112 | 54 | 255 | 19 | |||||||
DEU | Germany | BBB | Bavarian Peasants' League | Bayerischer Bauernbund | Bayerischer Bauernbund | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 54 | 2701 | 6 | ||||||||
DEU | Germany | BFB | Confederation of free citizens -- Offensive for Germany | Bund freier Bürger – Offensive für Deutschland | Bund freier Buerger -- Offensive fuer Deutschland | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 54 | 1720 | 40 | ||||||||
DEU | Germany | BLB | Baden Rural Federation | Badischer Landbund | Badischer Landbund | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 54 | 2707 | 2 | ||||||||
DEU | Germany | BP | Bavarian Party | Bayernpartei | Bayernpartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41911 | 54 | 1131 | 26 | |||||||
DEU | Germany | BVP | Bavarian People's Party | Bayerische Volkspartei | Bayerische Volkspartei | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 54 | 2697 | 3 | ||||||||
DEU | Germany | BWB | Farmers and Wine Growers Association | Bauern- und Weingärtnerbund | Bauern- und Weingaertnerbund | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 54 | 2703 | 2 | ||||||||
DEU | Germany | CNAG | Christian National Working Group | Christlichnationale Arbeitsgemeinschaft | Christlichnationale Arbeitsgemeinschaft | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 54 | 2713 | 3 | ||||||||
DEU | Germany | CNBL | Christian-National Peasants' and Farmers' Party | Christlich-Nationale Bauern- und Landvolkpartei | Christlich-Nationale Bauern- und Landvolkpartei | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 54 | 2709 | 3 | ||||||||
DEU | Germany | CSVD | Christian Social People's Service | Christlich-Sozialer Volksdienst | Christlich-Sozialer Volksdienst | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 54 | 2700 | 3 | ||||||||
DEU | Germany | DBP | German Farmers' Party | Deutsche Bauernpartei | Deutsche Bauernpartei | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 54 | 2712 | 2 | ||||||||
DEU | Germany | DDP | German Democratic Party | Deutsche Demokratische Partei | Deutsche Demokratische Partei | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 54 | 2691 | 6 | ||||||||
DEU | Germany | DFU | German Peace Union | Deutsche Friedensunion | Deutsche Friedensunion | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 54 | 633 | 14 | ||||||||
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 | DNVP | German National People's Party | Deutschnationale Volkspartei | Deutschnationale Volkspartei | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 54 | 2692 | 40 | ||||||||
DEU | Germany | DP | German Party | Deutsche Partei | Deutsche Partei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41620 | 54 | 912 | 26 | |||||||
DEU | Germany | DRP | German Reich Party | Deutsche Reichspartei | Deutsche Reichspartei | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 41712 | 54 | 187 | 40 | |||||||
DEU | Germany | DSP | German Social Party | Deutschsoziale Partei | Deutschsoziale Partei | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 54 | 2705 | 40 | ||||||||
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 | DZ | Centre Party | Deutsche Zentrumspartei | Deutsche Zentrumspartei | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 41522 | 54 | 137 | 3 | |||||||
DEU | Germany | FVP | Free People's Party | Freie Volkspartei | Freie Volkspartei | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 54 | 358 | 6 | ||||||||
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 | Fr | Peace alliance | Friedensliste | Friedensliste | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 54 | 1718 | 14 | ||||||||
DEU | Germany | GB/BHE | All-German Bloc / League of Expellees and Deprived of Rights | Gesamtdeutscher Block / Bund der Heimatvertriebenen und Entrechteten | Gesamtdeutscher Block / Bund der Heimatvertriebenen und Entrechteten | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 41951 | 54 | 1507 | 40 | |||||||
DEU | Germany | GDP | All-German Party | Gesamtdeutsche Partei | Gesamtdeutsche Partei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 1701 | 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;