view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
263 rows where family_name = "Conservative" sorted by chess
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 | LPA | Liberal Party of Australia | Liberal Party of Australia | Liberal Party of Australia | con | Conservative | 7.3903 | 8.4211 | 6.9825 | 63620 | 103 | 205 | 4757 | 33 | 1411 | 26 | |||||
AUS | Australia | NAT-WA | Nationalist | Nationalist | Nationalist | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1925 | 26 | |||||||||
AUS | Australia | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | con | Conservative | 7.8222 | 6.2456 | 8.4561 | 63810 | 104 | 206 | 4775 | 33 | 184 | 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 | 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 | PCP | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | con | Conservative | 6.7112 | 6.9659 | 5.997 | 62620 | 403 | 804 | 5313 | 29 | 794 | 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 | |||||||||
CAN | Canada | RPC | Reform Party of Canada | Reform Party of Canada | Reform Party of Canada | con | Conservative | 8.7748 | 8.7668 | 9.0688 | 62621 | 805 | 5233 | 29 | 897 | 26 | ||||||
CAN | Canada | SSC | Social Credit Party of Canada | Social Credit Party of Canada | Social Credit Party of Canada | con | Conservative | 7.8 | 6.4 | 6.9 | 62951 | 404 | 29 | 1392 | 26 | |||||||
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 | 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 | 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 | BP | Bavarian Party | Bayernpartei | Bayernpartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41911 | 54 | 1131 | 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 | DP | German Party | Deutsche Partei | Deutsche Partei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41620 | 54 | 912 | 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 | ERP | Res Publica Party | Erakond Res Publica | Erakond Res Publica | con | Conservative | 8.4962 | 8.2456 | 6.1053 | 9.2632 | 83611 | 1820 | 75 | 428 | 26 | ||||||
EST | Estonia | ERSP | Estonian National Independence Party | Eesti Rahvusliku Sõltumatuse Partei | Eesti Rahvusliku Soltumatuse Partei | con | Conservative | 7.7778 | 6.4 | 6.9 | 7.9 | 83711 | 1210 | 75 | 552 | 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 | IRL | Union of Pro Patria and Res Publica | Erakond Isamaa ja Res Publica Liit | Erakond Isamaa ja Res Publica Liit | con | Conservative | 8.4962 | 8.2456 | 6.1053 | 9.2632 | 83611 | 80 | 1233613 | 1820 | 75 | 1597 | 26 | ||||
EST | Estonia | RKI | National Coalition Party "Pro Patria" | Rahvuslik Koonderakond "Isamaa" | Rahvuslik Koonderakond "Isamaa" | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 83710 | 75 | 243 | 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 | ||||||||
EST | Estonia | VKR | People's Party of Republicans and Conservatives | Vabariiklaste ja Konservatiivide Rahvaerakond | Vabariiklaste ja Konservatiivide Rahvaerakond | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 83610 | 75 | 1395 | 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 | G | Gaullists | Gaulliste | Gaulliste | con | Conservative | 8.2 | 6.4 | 6.9 | 7.9 | 31621 | 706 | 43 | 1094 | 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 | UDCA | Union for the Defence of Traders and Artisans -- Poujadists | Union de défense des commerçants et artisans – Poujadists | Union de defense des commercants et artisans -- Poujadists | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 31623 | 43 | 898 | 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 | ||||||||
GBR | United Kingdom | C | Constitutionalist | Constitutionalist | Constitutionalist | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 44 | 2514 | 26 | ||||||||
GBR | United Kingdom | CNL | Conservatives and National Liberals | Conservatives and National Liberals | Conservatives and National Liberals | con | Conservative | 7.8 | 6.4 | 6.9 | 7.9 | 51620 | 1606 | 44 | 1496 | 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 | DUP | Democratic Unionist Party | Democratic Unionist Party | Democratic Unionist Party | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 51903 | 44 | 319 | 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 | ||||||||
GBR | United Kingdom | UUP | Ulster Unionist Party | Ulster Unionist Party | Ulster Unionist Party | con | Conservative | 8.3 | 6.4 | 6.9 | 7.9 | 51621 | 1607 | 44 | 1210 | 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 | EP | National Alignment | Ethniki Parataxis | Ethniki Parataxis | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 34610 | 41 | 1027 | 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 | FKgP | Independent Small Holders Party | Független Kisgazda Párt | Fuggetlen Kisgazda Part | con | Conservative | 9.0186 | 4.7149 | 8.6235 | 3.7053 | 86810 | 1606 | 1898 | 39 | 870 | 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 |
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;