view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by cmp
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BEL | Belgium | UDB | Belgian Democratic Union | Union Democratique Belge | Union Democratique Belge | code | to be coded | 64 | 1181 | 28 | ||||||||||||
BEL | Belgium | V | Alive | Vivant | Vivant | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 64 | 620 | 6 | ||||||||
BEL | Belgium | WOW | Growing Old in Dignity | Waardig Ouder Worden | Growing Old in Dignity | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 64 | 470 | 40 | ||||||||
BEL | Belgium | etc | others | others | others | none | no family | 64 | 2488 | 12 | ||||||||||||
BEL | Belgium | no-seat | no seat | no seat | no seat | none | no family | 64 | 2052 | 12 | ||||||||||||
BEL | Belgium | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 64 | 1458 | 12 | ||||||||||||
BEL | Belgium | one-seat | one seat | one seat | one seat | none | no family | 64 | 2300 | 12 | ||||||||||||
BGR | Bulgaria | ABV | Alternative for Bulgarian Revival | Alternativa za balgarsko vazrazhdane | Alternativa za balgarsko vazrazhdane | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2364 | 11 | ||||||||
BGR | Bulgaria | Ataka | Attack | Ataka | Ataka | right | Right-wing | 5.46 | 3.25 | 9.17 | 2.4333 | 27 | 1100700 | 2007 | 10 | 535 | 40 | |||||
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 | BNO|BN | Bulgarian National Unification | Bulgarian Summer | Bŭlgarsko natsionalno obedinenie | Balgarsko lyato | Bulgarsko natsionalno obedinenie | Balgarsko lyato | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 2840 | 40 | ||||||||
BGR | Bulgaria | BNRP | Bulgarian National Radical Party | Balgarska Natsionalnoradikalna Partiya | Balgarska Natsionalnoradikalna Partiya | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 364 | 40 | ||||||||
BGR | Bulgaria | BV | Bulgarian Rise | Balgarski vazhod | Balgarski vazhod | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2871 | 26 | ||||||||
BGR | Bulgaria | BZNS-NP | Bulgarian Agrarian National Union -- "Nikola Petkov" | Balgarski Zemedelski Naroden Suyuz – "Nikola Petkov" | Balgarski Zemedelski Naroden Suyuz -- "Nikola Petkov" | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 10 | 2173 | 2 | ||||||||
BGR | Bulgaria | CSD | Centre -- Freedom and Dignity | Tsentŭr – Svoboda i dostoĭnstvo | Center -- Svoboda i dostojnstvo | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2595 | 6 | ||||||||
BGR | Bulgaria | D21 | Movement 21 | Dvizhenie 21 | Dvizhenie 21 | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2379 | 11 | ||||||||
BGR | Bulgaria | DAR | Democratic Alternative for the Republic | Demokratichna Alternativa za Republikata | Demokratichna Alternativa za Republikata | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2170 | 11 | ||||||||
BGR | Bulgaria | DG | George's Day Movement | Dvizhenie Gergyovden | Dvizhenie Gergyovden | right | Right-wing | 6.3158 | 6.1053 | 2.8289 | 8.3158 | 920 | 10 | 1362 | 40 | |||||||
BGR | Bulgaria | DOST | Democrats for Responsibility, Solidarity and Tolerance | Demokrati za Otgovornost, Svoboda i Tolerantnost | Demokrati za Otgovornost, Svoboda i Tolerantnost | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2639 | 6 | ||||||||
BGR | Bulgaria | DP | Democratic Party | Demokraticheska Partiya | Demokraticheska Partiya | chr | Christian democracy | 9.4444 | 5.7 | 7.1 | 8.3 | 709 | 10 | 542 | 3 | |||||||
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 | DaB | Yes, Bulgaria! | Da Bulgaria! | Da Bulgaria! | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2638 | 6 | ||||||||
BGR | Bulgaria | ER | Euroroma | Evroroma | Evroroma | spec | Special issue | 10 | 2178 | 16 | ||||||||||||
BGR | Bulgaria | FTB | Kingdom of Bulgaria Confederation | Federatsiya Tsarstvo Balgariya | Federatsiya Tsarstvo Balgariya | spec | Special issue | 10 | 800 | 16 | ||||||||||||
BGR | Bulgaria | GERB | Citizens for European Development of Bulgaria | Grazhdani za Evropeysko Razvitie na Balgariya | Grazhdani za Evropeysko Razvitie na Balgariya | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 29 | 1100600 | 2010 | 10 | 1541 | 40 | |||||
BGR | Bulgaria | GN | People's Voice | Glas Naroden | Glas Naroden | spec | Special issue | 10 | 2214 | 16 | ||||||||||||
BGR | Bulgaria | I-MK | Independent -- Mincho Kuminev | Independent – Mincho Kuminev | Independent -- Mincho Kuminev | none | no family | 10 | 2774 | 12 | ||||||||||||
BGR | Bulgaria | IS | Stand up! | Izpravi se! | Izpravi se! | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2838 | 11 | ||||||||
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 | KPB | Communist Party of Bulgaria | Komunisticheska Partiya na Balgariya | Komunisticheska Partiya na Balgariya | com | Communist/Socialist | 0.3684 | 1.7368 | 7.8289 | 2.8655 | 701 | 763 | 10 | 1570 | 14 | ||||||
BGR | Bulgaria | KR | Coalition of the Rose | Koalitsiya na Rozata | Koalitsiya na Rozata | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2179 | 11 | ||||||||
BGR | Bulgaria | KSII | Simeon II Coalition | Koalitsiya Simeon II | Koalitsiya Simeon II | spec | Special issue | 6.86 | 6.29 | 6.33 | 7.7833 | 2006 | 10 | 15 | 16 | |||||||
BGR | Bulgaria | Lider | Lider | Lider | Lider | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 2011 | 10 | 566 | 6 | |||||||
BGR | Bulgaria | NFSB | National Front for the Salvation of Bulgaria | Natsionalen Front za Spasenie na Balgariya | Natsionalen Front za Spasenie na Balgariya | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 2211 | 40 | ||||||||
BGR | Bulgaria | NV | New Times | Novoto vreme | Novoto vreme | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 10 | 2180 | 19 | ||||||||
BGR | Bulgaria | OT-SII | Union for Tzar [Simeon II] | Obedinenie za Tsar [Simeon II] | Obedinenie za Tsar [Simeon II] | spec | Special issue | 10 | 1149 | 16 | ||||||||||||
BGR | Bulgaria | PBSD | Party of Bulgarian Social Democrats | Partiya Balgarski Sotsialdemokrati | Partiya Balgarski Sotsialdemokrati | soc | Social democracy | 3.7778 | 4.6316 | 3.4211 | 9.0 | 703 | 815 | 10 | 1161 | 11 | ||||||
BGR | Bulgaria | PP | We Continue the Change | Prodalzhavame promyanata | Prodalzhavame promyanata | spec | Special issue | 10 | 2847 | 16 | ||||||||||||
BGR | Bulgaria | PS | Patriotic Union | Patriotichen Suyuz | Patriotichen Suyuz | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2177 | 26 | ||||||||
BGR | Bulgaria | R | Revival | Vazrazhdane | Vazrazhdane | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 2640 | 40 | ||||||||
BGR | Bulgaria | RB | Reformist Bloc | Reformatorski Blok | Reformatorski Blok | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2363 | 26 | ||||||||
BGR | Bulgaria | RZS | Order, Lawfulness and Justice | Red, zakonnost i spravedlivost | Red, zakonnost i spravedlivost | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 1100601 | 2012 | 10 | 636 | 40 | ||||||
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 | SDS-l | Union of Democratic Forces -- Liberal | Suyuz na Demokratichnite Sili – Liberali | Suyuz na Demokratichnite Sili -- Liberali | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2175 | 6 | ||||||||
BGR | Bulgaria | SDS-ts | Union of Democratic Forces -- Centre | Suyuz na Demokratichnite Sili – Tsentur | Suyuz na Demokratichnite Sili -- Tsentur | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2174 | 11 | ||||||||
BGR | Bulgaria | SEK | Middle European Class | Sredna evropeĭska klasa | Sredna evropeiska klasa | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2870 | 6 | ||||||||
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 | SNI | "New Choice" Union | Suyuz "Nov izbor" | Suyuz "Nov izbor" | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2176 | 6 | ||||||||
BGR | Bulgaria | VB | Volt Bulgaria | Volt Bulgaria | Volt Bulgaria | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2869 | 6 | ||||||||
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 | ||||||||
BGR | Bulgaria | Volya | Will | Volya | Volya | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 2637 | 40 | ||||||||
BGR | Bulgaria | ZP | Green Party of Bulgaria | Zelena Partiya | Zelena Partija | eco | Green/Ecologist | 5.5556 | 2.5 | 1.8 | 6.5 | 705 | 10 | 963 | 19 | |||||||
BGR | Bulgaria | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 10 | 133 | 12 | ||||||||||||
CAN | Canada | BPC | Bloc Populaire Canadien | Bloc Populaire Canadien | Bloc Populaire Canadien | spec | Special issue | 29 | 1307 | 16 | ||||||||||||
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 | CP|LPP | Communist (Labour-Progressive) Party | Communist (Labour-Progressive) Party | Communist (Labour-Progressive) Party | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 29 | 556 | 14 | |||||||||
CAN | Canada | GPC | Green Party of Canada | Green Party of Canada | Green Party of Canada | eco | Green/Ecologist | 1.9018 | 2.2467 | 2.0327 | 5253 | 29 | 1259 | 19 | ||||||||
CAN | Canada | L | Labour Party | Labour Party | Labour Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 29 | 2427 | 11 | |||||||||
CAN | Canada | L-P | Liberal-Progressive | Liberal-Progressive | Liberal-Progressive | lib | Liberal | 6.0 | 6.7 | 3.6 | 29 | 2011 | 6 | |||||||||
CAN | Canada | LL | Liberal-Labour | Liberal-Labour | Liberal-Labour | lib | Liberal | 6.0 | 6.7 | 3.6 | 29 | 2085 | 6 | |||||||||
CAN | Canada | NPC | National Party of Canada | National Party of Canada | National Party of Canada | soc | Social democracy | 3.3 | 3.5 | 3.5 | 29 | 2142 | 11 | |||||||||
CAN | Canada | PPC | People's Party of Canada | People's Party of Canada | People's Party of Canada | right | Right-wing | 8.8 | 5.9 | 8.5 | 29 | 2791 | 40 | |||||||||
CAN | Canada | PPC-19 | Progressive Party of Canada (1919) | Progressive Party of Canada (1919) | Progressive Party of Canada (1919) | agr | Agrarian | 5.3 | 4.9 | 6.5 | 29 | 2566 | 2 | |||||||||
CAN | Canada | PR | Rhinoceros Party | Parti Rhinoceros | Parti Rhinoceros | spec | Special issue | 29 | 2148 | 16 | ||||||||||||
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 | |||||||||
CAN | Canada | SCR | Social Credit Rally | Ralliement créditiste | Ralliement creditiste | spec | Special issue | 29 | 677 | 16 | ||||||||||||
CAN | Canada | UE | Union of Electors | Union [Candidats] des électeurs | Union [Candidats] des electeurs | spec | Special issue | 29 | 2162 | 16 | ||||||||||||
CAN | Canada | etc | others | others | others | none | no family | 29 | 2577 | 12 | ||||||||||||
CAN | Canada | no-seat | no seat | no seat | no seat | none | no family | 29 | 2067 | 12 | ||||||||||||
CAN | Canada | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 29 | 1189 | 12 | ||||||||||||
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 | |||||||
CHE | Switzerland | BHB | Young Peasants Movement | Bauernheimatbewegung – Jeunes paysans | Bauernheimatbewegung -- Jeunes paysans | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 40 | 1957 | 19 | ||||||||
CHE | Switzerland | CsP-PCS | Christian Social Party | Christlich-soziale Partei – Parti chrétien-social | Christlich-soziale Partei -- Parti chretien-social | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 3611 | 40 | 1012 | 3 | |||||||
CHE | Switzerland | DG | Democratic Group | Gruppe der Demokraten – Groupe des democrates | Gruppe der Demokraten -- Groupe des democrates | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 40 | 886 | 11 | ||||||||
CHE | Switzerland | EJ | Agreement Jura | Entente jurassienne | Entente jurassienne | code | to be coded | 40 | 1964 | 28 | ||||||||||||
CHE | Switzerland | FGr-ASF | Feminists and Green-Alternative Groups | Feministische und grün-alternative Gruppierungen – Alternative socialiste verte et groupements féministes | Feministische und gruen-alternative Gruppierungen -- Alternative socialiste verte et groupements feministes | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 2.5 | 1712 | 40 | 569 | 19 | |||||||
CHE | Switzerland | GPL-PVL | Green Liberal Party | Grünliberale Partei der Schweiz – Parti Vert-Libéral | Gruenliberale Partei der Schweiz -- Parti Vert-Liberal | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 3606 | 40 | 308 | 19 | |||||||
CHE | Switzerland | GV | Grutli Society | Grütliverein – Grutléen | Gruetli Society -- Grutleen | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 40 | 1951 | 11 | ||||||||
CHE | Switzerland | KHM | Committee Herbert Maeder | Komitee Herbert Maeder | Komitee Herbert Maeder | none | no family | 40 | 1967 | 12 | ||||||||||||
CHE | Switzerland | LF/PEB | Liberal Socialist Party | Liberalsozialistische Partei / Freiwirtschaftliche Bewegung – Parti d'économie franche | Liberalsozialistische Partei / Freiwirtschaftliche Bewegung -- Parti d economie franche | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 40 | 1960 | 6 | ||||||||
CHE | Switzerland | LdT | Ticino League | Lega dei Ticinesi | Lega dei Ticinesi | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 1714 | 3610 | 40 | 1500 | 40 | ||||||
CHE | Switzerland | MCR | Geneva Citizens' Movement | Mouvement Citoyens Genevois | Mouvement Citoyens Genevois | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 40 | 2599 | 40 | ||||||||
CHE | Switzerland | POCH | Progressive Organisations of Switzerland | Progressive Organisationen der Schweiz – Organisations progressistes de Suisse | Progressive Organisationen der Schweiz -- Organisations progressistes de Suisse | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 40 | 964 | 14 | ||||||||
CHE | Switzerland | PSA | Autonomous Socialist Party | Partito socialista autonomo | Partito socialista autonomo | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 5.0 | 1710 | 40 | 224 | 14 | |||||||
CHE | Switzerland | RB | Republican Movement | Republikanische Bewegung | Republikanische Bewegung | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 40 | 564 | 40 | ||||||||
CHE | Switzerland | S | Solidarity | solidaritéS | solidariteS | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 40 | 1226 | 14 | ||||||||
CHE | Switzerland | UDE | National Union | Union de défense économique | Union de defense economique | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 40 | 1954 | 40 | ||||||||
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 | 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 | DP | Democratic Alignment | Dimokratiki Parataxi | Dimokratiki Parataxi | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 2741 | 6 | |||||||||
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 |
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;