view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
274 rows where family_name = "Liberal" sorted by eu_anti_pro
This data as json, CSV (advanced)
Suggested facets: castles_mair
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 | AP | Australia Party | Australia Party | Australia Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1760 | 6 | |||||||||
AUS | Australia | CouLP | Country Liberal Party | Country Liberal Party | Country Liberal Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 215 | 6 | |||||||||
AUS | Australia | EC-SA | Emergency Committee (SA) | Emergency Committee (SA) | Emergency Committee (SA) | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1904 | 6 | |||||||||
AUS | Australia | FTP | Free Trade Party | Free Trade Party | Free Trade Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1938 | 6 | |||||||||
AUS | Australia | LD-NSW | Liberal Democratic Party (New South Wales) | Liberal Democratic Party (New South Wales) | Liberal Democratic Party (New South Wales) | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1927 | 6 | |||||||||
AUS | Australia | LNPQ | Liberal National Party of Queensland | Liberal National Party of Queensland | Liberal National Party of Queensland | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 154 | 6 | |||||||||
AUS | Australia | NXT | Nick Xenophon Team | Nick Xenophon Team | Nick Xenophon Team | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 2630 | 6 | |||||||||
AUS | Australia | PUP | Palmer United Party | Palmer United Party | Palmer United Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 2259 | 6 | |||||||||
AUS | Australia | WAP | Western Australian Party | Western Australian Party | Western Australian Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1906 | 6 | |||||||||
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 | LP | Liberal Party of Canada | Liberal Party of Canada | Liberal Party of Canada | lib | Liberal | 5.0552 | 5.3509 | 3.4615 | 62420 | 402 | 803 | 5273 | 29 | 368 | 6 | |||||
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 | 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 | ED | United Democrats | Enomeni Dimokrates | Enomeni Dimokrates | lib | Liberal | 7.1053 | 6.0526 | 4.3421 | 55423 | 5423 | 51 | 1523 | 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 | EnKe | Union Centre | Enosi Kentrou | Enosi Kentrou | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 1777 | 6 | |||||||||
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 | |||||||||
ISL | Iceland | B-H | Civic Movement -- The Movement | Borgarahreyfingin – Hreyfingin | Borgarahreyfingin -- Hreyfingin | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 587 | 6 | |||||||||
ISL | Iceland | BF | Bright Future | Björt framtíð | Bjort framtid | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 2204 | 6 | |||||||||
ISL | Iceland | FF | Liberal Party | Frjálslyndi flokkurinn | Frjlslyndi flokkurinn | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 2441 | 6 | |||||||||
ISL | Iceland | Ff | Liberal Party | Frjálslyndi flokkurinn | Frjalslyndi flokkurinn | lib | Liberal | 6.2201 | 5.5981 | 3.0 | 15420 | 6231 | 56 | 506 | 6 | |||||||
ISL | Iceland | Fr | Liberals | Frjálslyndir | Frjalslyndir | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 2114 | 6 | |||||||||
ISL | Iceland | HG | RIght-Green People's Party | Hægri Grænir flokkur fólksins | Haegri Graenir flokkur folksins | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 2209 | 6 | |||||||||
ISL | Iceland | He | Home Rule Party | Heimastjórnarflokkurinn | Heimastjrnarflokkurinn | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 2440 | 6 | |||||||||
ISL | Iceland | M | Centre Party | Miðflokkurinn | Midflokkurinn | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 2655 | 6 | |||||||||
ISL | Iceland | Thva | National Preservation Party | Þjóðvarnarflokkurinn | Thjodvarnarflokkurinn | lib | Liberal | 6.0 | 6.7 | 3.6 | 15710 | 56 | 1172 | 6 | ||||||||
ISR | Israel | DS | The Third Way | HaDerekh HaShlishit | HaDerekh HaShlishit | lib | Liberal | 6.0 | 6.7 | 3.6 | 72427 | 34 | 279 | 6 | ||||||||
ISR | Israel | G | Bridge | Gesher | Gesher | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2787 | 6 | |||||||||
ISR | Israel | HLY | Israel Resilience Party | Hosen L'Yisrael | Hosen L'Yisrael | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2799 | 6 | |||||||||
ISR | Israel | Hat | The Movement | Hatnuah | Hatnuah | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2320 | 6 | |||||||||
ISR | Israel | KL | Blue and White | Kahol Lavan | Kahol Lavan | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2725 | 6 | |||||||||
ISR | Israel | Kadima | Forward | Kadima | Kadima | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 1870 | 6 | |||||||||
ISR | Israel | Kulanu | All of Us | Kulanu | Kulanu | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2410 | 6 | |||||||||
ISR | Israel | LA | Independent Liberals | Libralim Atzma'im | Libralim Atzma'im | lib | Liberal | 6.0 | 6.7 | 3.6 | 72410 | 34 | 188 | 6 | ||||||||
ISR | Israel | MP | Progressive Party | Miflaga Progresivit | Miflaga Progresivit | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 1822 | 6 | |||||||||
ISR | Israel | MeHo | Free Centre | HaMerkaz HaHofshi | HaMerkaz HaHofshi | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 1889 | 6 | |||||||||
ISR | Israel | MiHa | Centre Party | Mifleget Hamerkaz | Mifleget Hamerkaz | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 1863 | 6 | |||||||||
ISR | Israel | MiHal | Liberal Party | Miflaga Haliberalit | Miflaga Haliberalit | lib | Liberal | 6.0 | 6.7 | 3.6 | 72411 | 34 | 765 | 6 | ||||||||
ISR | Israel | O | Courage | Ometz | Ometz | lib | Liberal | 6.0 | 6.7 | 3.6 | 72425 | 34 | 61 | 6 | ||||||||
ISR | Israel | Shinui | Change | Shinui | Shinui | lib | Liberal | 5.4776 | 8.6207 | 1.7423 | 72413 | 6572 | 34 | 1850 | 6 | |||||||
ISR | Israel | TDL | Democratic Movement for Change | Tnu'a Demokratit LeShinu | Tnu'a Demokratit LeShinu | lib | Liberal | 5.4776 | 8.6207 | 1.7423 | 72412 | 6572 | 34 | 1471 | 6 | |||||||
ISR | Israel | Telem | Telem | Telem | Telem | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2800 | 6 | |||||||||
ISR | Israel | YA | There is a Future | Yesh Atid | Yesh Atid | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2321 | 6 | |||||||||
ISR | Israel | YBA | Israel for Immigration | Yisrael Ba-Aliya | Yisrael Ba-Aliya | lib | Liberal | 6.0 | 6.7 | 3.6 | 72428 | 34 | 277 | 6 | ||||||||
ISR | Israel | Ya-84 | Together | Yahad | Yahad | lib | Liberal | 6.0 | 6.7 | 3.6 | 72414 | 34 | 1269 | 6 | ||||||||
ISR | Israel | ZK | General Zionists | Zionim Klalim | Zionim Klalim | lib | Liberal | 6.0 | 6.7 | 3.6 | 72420 | 34 | 1472 | 6 | ||||||||
JPN | Japan | JNP | Japan New Party | Nihon Shintō | Nihon Shin-to | lib | Liberal | 8.2556 | 6.7 | 3.6 | 71952 | 2205 | 5 | 1327 | 6 | |||||||
JPN | Japan | LL | Liberal League | Jiyu Rengo | Jiyu Rengo | lib | Liberal | 6.0 | 6.7 | 3.6 | 5 | 1165 | 6 | |||||||||
JPN | Japan | NCoP | National Cooperative Party | Kokumin Kyôdô Tô | Kokumin Kyodo To | lib | Liberal | 6.0 | 6.7 | 3.6 | 5 | 1733 | 6 | |||||||||
JPN | Japan | NPD | New Party Daichi | Shintō Daichi | Shinto Daichi | lib | Liberal | 6.0 | 6.7 | 3.6 | 5 | 247 | 6 | |||||||||
JPN | Japan | NPN | New Party Nippon | Shintō Nippon | Shinto Nippon | lib | Liberal | 6.0 | 6.7 | 3.6 | 5 | 1175 | 6 | |||||||||
JPN | Japan | YP | Your Party | Minna no Tō | Minna no To | lib | Liberal | 6.0 | 6.7 | 3.6 | 5 | 1124 | 6 | |||||||||
LUX | Luxembourg | DP | Democratic Party | Demokratesch Partei | Demokratesch Partei | lib | Liberal | 6.5789 | 7.3684 | 2.7632 | 23420 | 212 | 1442420 | 903 | 6926 | 7 | 967 | 6 | ||||
LUX | Luxembourg | DeLe | Democratic List | Demokratesch Lëscht | Demokratesch Lescht | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2448 | 6 | |||||||||
LUX | Luxembourg | LL | Liberal League | Liberal Liga | Liberal Liga | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2453 | 6 | |||||||||
LUX | Luxembourg | LiLe | Left Liberals | Liberal Lénk | Left Liberals | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2531 | 6 | |||||||||
LUX | Luxembourg | PDPN | Progressive Democratic Party of the North | Fortschrëttlech-demokratesch Partei | Fortschrettlech-demokratesch Partei | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2538 | 6 | |||||||||
LUX | Luxembourg | PICM | Independent Party of the Middle Class | Parti Indépendant des Classes Moyennes | Parti Independant des Classes Moyennes | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2139 | 6 | |||||||||
LUX | Luxembourg | PL | Liberal Party | Parti Libéral | Parti Liberal | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2140 | 6 | |||||||||
LUX | Luxembourg | PRL | Radical Liberal Party | Radikal-Liberal Partei | Radikal-Liberal Partei | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2455 | 6 | |||||||||
LUX | Luxembourg | RP | Radical Left / Radical Party | Gauche radicale / Parti radical | Gauche radicale / Parti radical | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2533 | 6 | |||||||||
LUX | Luxembourg | RPMC | Radical Party (Marcel Cahen) | Radikal Partei (Marcel Cahen) | Radikal Partei (Marcel Cahen) | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2535 | 6 | |||||||||
LUX | Luxembourg | RSP | Radical Socialist Party | Radikal-Sozialistesch Partei | Radikal-Sozialistesch Partei | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2456 | 6 | |||||||||
MLT | Malta | PD | Democratic Party | Partit Demokratiku | Partit Demokratiku | lib | Liberal | 6.0 | 6.7 | 3.6 | 72 | 2759 | 6 | |||||||||
MLT | Malta | PK | Constitutionalist Party | Partit Kostituzzjonali | Partit Kostituzzjonali | lib | Liberal | 6.0 | 6.7 | 3.6 | 72 | 1033 | 6 | |||||||||
NZL | New Zealand | ACT | ACT New Zealand | ACT New Zealand | ACT New Zealand | lib | Liberal | 9.0263 | 8.9751 | 3.6 | 64420 | 7220 | 11 | 617 | 6 | |||||||
NZL | New Zealand | DP | Democrat Party | Democrat Party | Democrat Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 11 | 2468 | 6 | |||||||||
NZL | New Zealand | NZLP | New Zealand Liberal Party | New Zealand Liberal Party | New Zealand Liberal Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 11 | 2469 | 6 | |||||||||
NZL | New Zealand | NZP | New Zealand Party | New Zealand Party | New Zealand Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 11 | 2075 | 6 | |||||||||
NZL | New Zealand | TOP | The Opportunities Party | The Opportunities Party | The Opportunities Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 11 | 2650 | 6 | |||||||||
NZL | New Zealand | UFNZ | United Future New Zealand | United Future New Zealand | United Future New Zealand | lib | Liberal | 6.1219 | 6.3158 | 3.6 | 64421 | 7332 | 11 | 1313 | 6 | |||||||
DNK | Denmark | RF | Justice Party | Retsforbund | Retsforbund | lib | Liberal | 6.0 | 6.7 | 3.6 | 0.2333 | 13952 | 205 | 21 | 1606 | 6 | ||||||
DNK | Denmark | FrP | Progress Party | Fremskridtspartiet | Fremskridtspartiet | lib | Liberal | 9.0259 | 8.8396 | 6.6509 | 1.4475 | 13951 | 510 | 1109 | 213 | 5531 | 212 | 21 | 978 | 6 | ||
NOR | Norway | V | Liberal Party of Norway | Venstre | Venstre | lib | Liberal | 5.1467 | 5.9148 | 3.2581 | 4.0766 | 12420 | 1303 | 2906 | 1508 | 7614 | 3507 | 9 | 647 | 6 | ||
HRV | Croatia | HSLS | Croatian Social Liberal Party | Hrvatska socijalno liberalna stranka | Hrvatska socijalno liberalna stranka | lib | Liberal | 7.193 | 4.6491 | 5.5263 | 5.0877 | 81410 | 1146 | 3104 | 62 | 1102 | 6 | |||||
LVA | Latvia | TSP | National Harmony Party | Tautas Saskaņas Partija | Tautas Saskanas Partija | lib | Liberal | 1.864 | 2.1751 | 5.2767 | 5.7675 | 87421 | 2184 | 2402 | 55 | 32 | 6 | |||||
NLD | Netherlands | VVD | People's Party for Freedom and Democracy | Volkspartij voor Vrijheid en Democratie | Volkspartij voor Vrijheid en Democratie | lib | Liberal | 7.3482 | 7.8979 | 4.3887 | 5.9471 | 22420 | 305 | 1528420 | 1107 | 2605 | 1003 | 7200 | 1003 | 8 | 1409 | 6 |
CHE | Switzerland | FDP-PRD | Radical Democratic Party | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Freisinnig-Demokratische Partei der Schweiz -- Parti Radical-Democratique Suisse | lib | Liberal | 6.3249 | 8.0105 | 3.4159 | 6.4439 | 43420 | 289 | 3803 | 1703 | 8028 | 40 | 26 | 6 | |||
ITA | Italy | IdV | Italy of Values | Italia dei Valori | Italia dei Valori | lib | Liberal | 4.8712 | 4.5664 | 5.5255 | 7.1295 | 32902 | 176 | 1380902 | 6686 | 828 | 26 | 693 | 6 | |||
SVN | Slovenia | AS | Active Slovenia | Aktivna Slovenija | Aktivna Slovenija | lib | Liberal | 4.6 | 3.8 | 2.6 | 7.3333 | 2909 | 60 | 380 | 6 | |||||||
HRV | Croatia | DC | Democratic Centre | Demokratski centar | Demokratski centar | lib | Liberal | 5.9649 | 4.8421 | 6.4912 | 7.3684 | 1042 | 62 | 1081 | 6 | |||||||
ITA | Italy | PLI | Italian Liberal Party | Partito Liberale Italiano | Partito Liberale Italiano | lib | Liberal | 6.45 | 6.7 | 3.6 | 7.5 | 32420 | 1009 | 2108 | 810 | 26 | 487 | 6 | ||||
CHE | Switzerland | LPS | Liberal Party of Switzerland | Liberale Partei der Schweiz – Parti liberal suisse | Liberale Partei der Schweiz -- Parti liberal suisse | lib | Liberal | 7.2961 | 8.477 | 4.2441 | 7.6667 | 43531 | 3805 | 1702 | 8060 | 40 | 458 | 6 | ||||
BGR | Bulgaria | BBB | Bulgarian Business Bloc | Balgarski Biznes Blok | Balgarski Biznes Blok | lib | Liberal | 6.6784 | 7.076 | 5.1974 | 7.6842 | 80901 | 708 | 737 | 10 | 599 | 6 | |||||
DNK | Denmark | RV | Danish Social Liberal Party | Det Radikale Venstre | Det Radikale Venstre | lib | Liberal | 4.8736 | 5.318 | 2.3903 | 7.8594 | 13410 | 68 | 1208410 | 505 | 1104 | 202 | 5585 | 202 | 21 | 211 | 6 |
SVK | Slovakia | SF | Free Forum | Slobodné fórum | Slobodne forum | lib | Liberal | 5.46 | 6.58 | 3.18 | 7.95 | 1703524 | 2811 | 1 | 752 | 6 | ||||||
BEL | Belgium | MR | Reformist Movement | Mouvement Réformateur | Mouvement Reformateur | lib | Liberal | 6.6889 | 7.1934 | 4.2102 | 8.3003 | 21422 | 22 | 1056427 | 310 | 4983 | 106 | 64 | 915 | 6 | ||
CZE | Czech Republic | SNK-ED | SNK European Democrats | SNK Evropští demokraté | SNK Evropsti demokrate | lib | Liberal | 6.0929 | 6.5934 | 3.4947 | 8.3662 | 60 | 1510 | 2106 | 68 | 1532 | 6 | |||||
IRL | Ireland | PD | Progressive Democrats | Progressive Democrats | Progressive Democrats | lib | Liberal | 8.0109 | 8.3901 | 3.7011 | 8.4528 | 53420 | 1905 | 706 | 6367 | 706 | 37 | 651 | 6 | |||
PRT | Portugal | PSD | Social Democratic Party | Partido Social Democrata | Partido Social Democrata | lib | Liberal | 6.2949 | 6.8488 | 7.0224 | 8.4691 | 35313 | 245 | 1620313 | 3103 | 1206 | 7722 | 1206 | 63 | 1273 | 6 | |
DEU | Germany | FDP | Free Democratic Party | Freie Demokratische Partei | Freie Demokratische Partei | lib | Liberal | 5.9233 | 8.2173 | 3.0695 | 8.4855 | 41420 | 119 | 1276420 | 804 | 1504 | 303 | 5997 | 303 | 54 | 543 | 6 |
FIN | Finland | RKP-SFP | Swedish People's Party | Ruotsalainen Kansanpuolue – Svenska Folkepartiet i Finland | Ruotsalainen Kansanpuolue -- Svenska Folkepartiet i Finland | lib | Liberal | 6.3906 | 6.7295 | 3.8385 | 8.5284 | 14901 | 96 | 1246901 | 606 | 1305 | 1406 | 5757 | 1406 | 67 | 585 | 6 |
LTU | Lithuania | DP | Labour Party | Darbo partija | Darbo partija | lib | Liberal | 3.86 | 4.29 | 5.8 | 8.5667 | 199 | 1440322 | 2516 | 15 | 581 | 6 | |||||
EST | Estonia | ERe | Estonian Reform Party | Eesti Reformierakond | Eesti Reformierakond | lib | Liberal | 7.8969 | 8.6246 | 5.2737 | 8.5715 | 83430 | 82 | 1233430 | 1208 | 1794 | 2203 | 75 | 113 | 6 | ||
HRV | Croatia | LS | Liberal Party | Liberalna stranka | Liberalna stranka | lib | Liberal | 2.807 | 6.5789 | 1.4035 | 8.5965 | 1276 | 62 | 1457 | 6 | |||||||
NLD | Netherlands | D66 | Democrats 66 | Democraten 66 | Democraten 66 | lib | Liberal | 4.5066 | 4.9917 | 1.7625 | 8.6233 | 22330 | 295 | 1528330 | 1105 | 2603 | 1004 | 7080 | 1004 | 8 | 345 | 6 |
LTU | Lithuania | NS-SL | New Union (Social Liberals) | Naujoji sąjunga (socialliberalai) | Naujoji sajunga (socialliberalai) | lib | Liberal | 4.2686 | 4.1125 | 4.9071 | 8.6647 | 88410 | 1440410 | 2376 | 2504 | 15 | 856 | 6 |
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;