view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
263 rows where family_name_short = "con" sorted by family_name
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 | N-VA | New Flemish Alliance | Nieuw-Vlaamse Alliantie | Nieuw-Vlaamse Alliantie | con | Conservative | 6.5321 | 5.8809 | 6.06 | 6.4243 | 21913 | 15 | 1056913 | 309 | 407 | 110 | 5003 | 110 | 64 | 501 | 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 | BNS | Bulgarian People's Union | Balgarski Naroden Suyuz | Balgarski Naroden Suyuz | con | Conservative | 5.8 | 6.0 | 5.44 | 8.3333 | 80811 | 2009 | 10 | 1375 | 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 | ODS | United Democratic Forces | Obedineni Demokratichni Sili | Obedineni Demokratichni Sili | con | Conservative | 6.9611 | 6.917 | 3.8431 | 9.7427 | 80411 | 706 | 972 | 2002 | 10 | 784 | 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 | |||||||
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 | EDU-UDF | Federal Democratic Union of Switzerland | Eidgenössisch-Demokratische Union – Union Démocratique Fédérale | Eidgenoessisch-Demokratische Union -- Union Democratique Federale | con | Conservative | 8.6579 | 6.3816 | 9.4247 | 0.9868 | 43711 | 7996 | 3608 | 40 | 1318 | 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 | ODS | Civic Democratic Party | Občanská demokratická strana | Obcanska demokraticka strana | con | Conservative | 7.3637 | 7.8985 | 4.0087 | 4.456 | 82413 | 59 | 1203413 | 1005 | 1458 | 2102 | 68 | 829 | 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 | 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 | CD | Centre Democrats | Centrumdemokraterne | Centrumdemokraterne | con | Conservative | 5.5609 | 4.8029 | 4.9307 | 9.1468 | 13330 | 506 | 1105 | 204 | 5477 | 204 | 21 | 1324 | 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 | KF | Conservatives | Konservative | Konservative | con | Conservative | 7.2186 | 7.2931 | 6.5055 | 7.7791 | 13620 | 66 | 1208620 | 509 | 1107 | 203 | 5549 | 203 | 21 | 590 | 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 | AP-P | People's Alliance-Party | Alianza-Partido Popular | Alianza-Partido Popular | con | Conservative | 7.5969 | 7.619 | 7.8127 | 7.7368 | 33610 | 274 | 1724610 | 1412 | 3608 | 502 | 7800 | 502 | 27 | 645 | 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 | CiU | Convergence and Union | Convergència i Unió | Convergencia i Unio | con | Conservative | 6.2564 | 6.3998 | 6.1104 | 8.7309 | 33611 | 357 | 1724007 | 1408 | 3607 | 505 | 7740 | 505 | 27 | 894 | 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 | ERa/EKR | People's Union of Estonia / Conservative People's Party | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond | con | Conservative | 4.5812 | 4.8509 | 6.9474 | 6.0627 | 83612 | 78 | 1233612 | 1768 | 2206 | 75 | 417 | 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 | I | Pro Patria Union | Isamaaliit | Isamaaliit | con | Conservative | 7.6169 | 6.414 | 7.3789 | 8.5189 | 83710 | 1212 | 1690 | 2201 | 75 | 846 | 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 | KOK | National Coalition Party | Kansallinen Kokoomus – Samlingspartiet | Kansallinen Kokoomus -- Samlingspartiet | con | Conservative | 7.2451 | 7.6408 | 5.5872 | 9.0846 | 14620 | 86 | 1246620 | 608 | 1308 | 1402 | 5697 | 1402 | 67 | 1118 | 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 | CNIP | National Centre of Independents and Peasants [Conservatives] | Centre national des indépendants et paysans | Centre national des independants et paysans | con | Conservative | 7.5636 | 6.4495 | 7.2219 | 7.2286 | 31622 | 707 | 609 | 609 | 43 | 1414 | 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 | 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 | PR | Radical Socialist Party | Parti radical-socialiste | Parti radical-socialiste | con | Conservative | 3.9896 | 4.1676 | 4.2381 | 7.9361 | 31421 | 704 | 603 | 603 | 43 | 401 | 26 | ||||
FRA | France | PRL | Conservatives | Parti républicain de la liberté | Parti republicain de la liberte | con | Conservative | 7.5636 | 6.4495 | 7.2219 | 7.2286 | 31622 | 707 | 609 | 609 | 43 | 1297 | 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 | Rally for the Republic | Rassemblement pour la république | Rassemblement pour la republique | con | Conservative | 7.4997 | 6.5934 | 7.1854 | 6.9862 | 31621 | 706 | 1411 | 609 | 5887 | 609 | 43 | 138 | 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 | UDF|MD | Union for French Democracy | Democratic Movement | Union pour la démocratie française | Mouvement démocrate | Union pour la democratie francaise | Mouvement democrate | con | Conservative | 6.1017 | 6.2021 | 5.4999 | 8.8995 | 31624 | 705 | 1409 | 5901 | 613 | 43 | 509 | 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 | UMP|LR | Union for a Popular Movement | The Republicans | Union pour un mouvement populaire | Les Républicains | Union pour un mouvement populaire | Les Republicains | con | Conservative | 7.4997 | 6.5934 | 7.1854 | 6.9862 | 31626 | 110 | 1250626 | 706 | 1411 | 609 | 5887 | 609 | 43 | 658 | 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 |
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;