view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by party_name_english
This data as json, CSV (advanced)
Suggested facets: family_name_short, family_name
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||
SVK | Slovakia | KDZP | Christian Democracy -- Life and Prosperity | Kresťanská demokracia – Život a prosperita | Krestanska demokracia -- Zivot a prosperita | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 1 | 2783 | 3 | ||||||||
BEL | Belgium | DC | Christian Democrats | Démocrates Chrétiens | Democrates Chretiens | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 64 | 2569 | 3 | ||||||||
ITA | Italy | CD | Democratic Centre | Centro Democratico | Centro Democratico | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 2153 | 6 | ||||||||
HRV | Croatia | SDSS | Independent Democratic Serb Party | Samostalna demokratska srpska stranka | Samostalna demokratska srpska stranka | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 3110 | 62 | 2133 | 11 | |||||||
NOR | Norway | AD|DRF | Labour Democrats | Radical People's Party | Arbeiderdemokratene | Det radikale Folkeparti | Arbeiderdemokratene | Det radikale Folkeparti | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 9 | 2415 | 14 | ||||||||
FRA | France | PUP | Proletarian Unity Party | Parti de l'Unité Prolétarienne | Parti de l'Unite Proletarienne | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 43 | 2584 | 14 | ||||||||
CHE | Switzerland | V | Vigilants | Vigilance | Vigilance | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 40 | 2775 | 40 | ||||||||
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 | ||||||||
NLD | Netherlands | 50+ | 50PLUS | 50PLUS | 50PLUS | spec | Special issue | 8 | 2109 | 16 | ||||||||||||
SVK | Slovakia | 99% | 99 Percent -- Civic Voice | 99% – občiansky hlas | 99% -- obciansky hlas | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 1 | 2015 | 14 | ||||||||
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 | |||||||
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 | ||||||||
GRC | Greece | D-FS | Action -- Liberal Alliance | Drasi – Fileleytheri Symmachia | Drasi -- Fileleytheri Symmachia | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 41 | 2096 | 6 | ||||||||
LUX | Luxembourg | AR|ADR | Action Committee Pensions | Alternative Democratic Reform Party | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | con | Conservative | 8.8158 | 6.3158 | 7.5 | 23951 | 214 | 1442951 | 907 | 6866 | 7 | 1582 | 26 | ||||
ITA | Italy | PAz | Action Party | Partito d'Azione | Partito d'Azione | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 26 | 1330 | 14 | ||||||||
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 | ||||||||
CYP | Cyprus | EP | Active Citizens | Energi Polites | Energi Polites | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 51 | 2815 | 14 | |||||||||
SVN | Slovenia | AS | Active Slovenia | Aktivna Slovenija | Aktivna Slovenija | lib | Liberal | 4.6 | 3.8 | 2.6 | 7.3333 | 2909 | 60 | 380 | 6 | |||||||
FRA | France | RDA | African Democratic Rally | Rassemblement démocratique Africain | Rassemblement democratique Africain | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 43 | 2276 | 14 | ||||||||
BEL | Belgium | AGL-Gr | Agalev -- Green | Agalev – Groen | Agalev -- Groen | eco | Green/Ecologist | 2.5762 | 2.0089 | 1.0234 | 7.2593 | 21112 | 13 | 1056112 | 305 | 401 | 105 | 4963 | 105 | 64 | 1594 | 19 |
HUN | Hungary | ASZ | Agrarian Alliance | Agrárszövetség | Agrarszovetseg | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 86811 | 39 | 1183 | 2 | |||||||
ITA | Italy | PaCoI | Agrarian Party | Partito dei Contadini d'Italia | Partito dei Contadini d'Italia | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 26 | 618 | 2 | ||||||||
BGR | Bulgaria | ZNS | Agrarian People's Union | Zemedelski Naroden Suyuz | Zemedelski Naroden Suyuz | agr | Agrarian | 5.5263 | 5.7895 | 5.9398 | 8.9474 | 80810 | 704 | 867 | 10 | 353 | 2 | |||||
BGR | Bulgaria | ZS-AS | Agrarian Union "Aleksandar Stamboliyski" | Zemedelski Suyuz "Aleksandar Stamboliyski" | Zemedelski Suyuz "Aleksandar Stamboliyski" | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 80812 | 10 | 529 | 2 | |||||||
CHE | Switzerland | EJ | Agreement Jura | Entente jurassienne | Entente jurassienne | code | to be coded | 40 | 1964 | 28 | ||||||||||||
ISR | Israel | HU | Agriculture and Development | Hakla'ut Ufituah | Hakla'ut Ufituah | spec | Special issue | 34 | 1835 | 16 | ||||||||||||
ISR | Israel | PAY | Agudat Israel Workers | Poalei Agudat Yisrael | Poalei Agudat Yisrael | spec | Special issue | 34 | 1832 | 16 | ||||||||||||
FIN | Finland | AS | Aland Coalition | Åländsk Samling | Alandsk Samling | spec | Special issue | 67 | 66 | 16 | ||||||||||||
ISR | Israel | Ma|Av | Alignment | Labor | HaMa'arakh | HaAvoda | HaMa'arakh | HaAvoda | soc | Social democracy | 3.3 | 3.5 | 3.5 | 72320 | 34 | 244 | 11 | ||||||||
BEL | Belgium | V | Alive | Vivant | Vivant | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 64 | 620 | 6 | ||||||||
LVA | Latvia | VL | All For Latvia! | Visu Latvijai! | Visu Latvijai! | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 55 | 801 | 26 | ||||||||
ISR | Israel | Kulanu | All of Us | Kulanu | Kulanu | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2410 | 6 | |||||||||
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 | ||||||||
DEU | Germany | GVP | All-German People's Party | Gesamtdeutsche Volkspartei | Gesamtdeutsche Volkspartei | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 54 | 238 | 3 | ||||||||
NZL | New Zealand | A | Alliance | Alliance | Alliance | soc | Social democracy | 2.0757 | 1.1111 | 3.5 | 64321 | 2702 | 7236 | 11 | 1444 | 11 | ||||||
PRT | Portugal | A | Alliance | Aliança | Alianca | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 63 | 2756 | 6 | ||||||||
DEU | Germany | B90/Gru | Alliance 90 / Greens | Bündnis 90 / Die Grünen | Buendnis 90 / Die Gruenen | eco | Green/Ecologist | 2.9308 | 4.3268 | 1.3251 | 7.6101 | 41113 | 115 | 1276113 | 802 | 1502 | 305 | 6015 | 304 | 54 | 772 | 19 |
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 | |||||||
GBR | United Kingdom | APoNI | Alliance Party of Northern Ireland | Alliance Party of Northern Ireland | Alliance Party of Northern Ireland | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 44 | 2731 | 6 | ||||||||
ROU | Romania | ApR | Alliance for Romania | Alianta pentru Romania | Alianta pentru Romania | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 23 | 2040 | 11 | ||||||||
AUT | Austria | BZO | Alliance for the Future of Austria | Bündnis Zukunft Österreich | Buendnis Zukunft Oesterreich | right | Right-wing | 8.83 | 6.0 | 8.83 | 2.5 | 8 | 1040600 | 1307 | 59 | 1536 | 40 | |||||
ROU | Romania | AUR | Alliance for the Unity of Romanians | Alianța pentru Unirea Românilor | Alianta pentru Unirea Romanilor | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 23 | 2807 | 40 | ||||||||
SVN | Slovenia | ZaAB | Alliance of Alenka Bratusek | Zavezništvo Alenke Bratušek | Zaveznistvo Alenke Bratusek | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2337 | 11 | ||||||||
SVK | Slovakia | ADS | Alliance of Democrats | Aliancia demokratov Slovenska | Aliancia demokratov Slovenska | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 96431 | 1 | 1624 | 6 | |||||||
SVK | Slovakia | SPV | Alliance of Farmers and the Countryside | Spojenestvo poľnohospodárov a vidieka | Spojenestvo polnohospodarov a vidieka | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 1 | 2233 | 2 | ||||||||
HUN | Hungary | SzDSz | Alliance of Free Democrats | Szabad Demokraták Szövetsége | Szabad Demokratak Szovetsege | lib | Liberal | 3.9659 | 7.7361 | 1.4381 | 9.7873 | 86422 | 163 | 1348422 | 1602 | 2028 | 2304 | 39 | 1426 | 6 | ||
HRV | Croatia | PGS | Alliance of Primorje-Gorski | Primorsko goranski savez | Primorsko goranski savez | spec | Special issue | 62 | 2196 | 16 | ||||||||||||
ISL | Iceland | BJ | Alliance of Social Democrats | Bandalag jafnaðarmanna | Bandalag jafnadarmanna | soc | Social democracy | 3.3 | 3.5 | 3.5 | 15321 | 56 | 988 | 11 | ||||||||
LTU | Lithuania | LTMA | Alliance of the Lithuanian National Minorities | Lietuvos tautinių mažumų aljansas | Lietuvos tautiniu mazumu aljansas | spec | Special issue | 15 | 2036 | 16 | ||||||||||||
SVK | Slovakia | ANO | Alliance of the New Citizen | Aliancia nového občana | Aliancia noveho obcana | lib | Liberal | 7.2404 | 7.945 | 1.9712 | 9.4714 | 96424 | 3850 | 2806 | 1 | 1200 | 6 | |||||
FRA | France | AO | Alliance of the Overseas | Alliances des outre-mers | Alliances des outre-mers | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 43 | 2400 | 14 | ||||||||
GRC | Greece | OE | Alternative Ecologists | Oikolόgoi Enallaktikoί | Oikologoi Enallaktikoi | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 3.3333 | 406 | 41 | 2163 | 19 | |||||||
AUT | Austria | ALO | Alternative List Austria | Alternative Liste Österreichs | Alternative Liste Oesterreichs | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 59 | 1739 | 19 | ||||||||
ROU | Romania | PAR | Alternative Party of Romania | Partidul Alternativa României | Partidul Alternativa Romaniei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 23 | 2087 | 26 | ||||||||
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 | ||||||||
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 | ||||||||
GBR | United Kingdom | IE | An Independence from Europe | An Independence from Europe | An Independence from Europe | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 44 | 2387 | 40 | ||||||||
ESP | Spain | PA | Andalusian Party | Partidu Andalucista | Partidu Andalucista | soc | Social democracy | 4.85 | 4.86 | 4.43 | 8.725 | 33906 | 1407 | 517 | 516 | 27 | 370 | 11 | ||||
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 | ||||||||||||
DEU | Germany | Tier | Animal Protection Party | Tierschutzpartei | Tierschutzpartei | spec | Special issue | 54 | 301 | 16 | ||||||||||||
FRA | France | PA | Animalist Party | Parti animaliste | Parti animaliste | spec | Special issue | 43 | 2733 | 16 | ||||||||||||
ESP | Spain | PACMA | Animalist Party Against Mistreatment to Animals | Partido Animalista Contra el Maltrato Animal | Partido Animalista Contra el Maltrato Animal | spec | Special issue | 27 | 2381 | 16 | ||||||||||||
IRL | Ireland | H-B | Anti H-Block | Anti H-Block | Anti H-Block | spec | Special issue | 37 | 1323 | 16 | ||||||||||||
FIN | Finland | VEU | Anti-EU Movement | Vaihtoehto EU:Lle | Vaihtoehto EU:Lle | spec | Special issue | 67 | 1649 | 16 | ||||||||||||
NLD | Netherlands | ARP | Anti-Revolutionary Party | Anti-Revolutionaire Partij | Anti-Revolutionaire Partij | chr | Christian democracy | 5.8067 | 5.6933 | 6.7724 | 8.2894 | 22523 | 1001 | 1001 | 8 | 300 | 3 | |||||
IRL | Ireland | A | Aontu | Aontú | Aontu | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2795 | 26 | ||||||||
NZL | New Zealand | ALCP | Aotearoa Legalise Cannabis Party | Aotearoa Legalise Cannabis Party | Aotearoa Legalise Cannabis Party | spec | Special issue | 11 | 2073 | 16 | ||||||||||||
ISR | Israel | Mada | Arab Democratic Party | Miflaga Demokratit Aravit – al-Hizb al-Dimuqrati al-Arabi | Miflaga Demokratit Aravit al-Hizb -- al-Dimuqrati al-Arabi | spec | Special issue | 1.0526 | 2.5387 | 7.9257 | 72901 | 6539 | 34 | 1150 | 16 | |||||||
ISR | Israel | RALEV | Arab List for Bedouin and Villagers | Reshima Aravit LeBedouim VeKfariym | Reshima Aravit LeBedouim VeKfariym | spec | Special issue | 34 | 2357 | 16 | ||||||||||||
ISR | Israel | Taal | Arab Movement for Renewal | Tnu'a Aravit LeHithadshut | Tnu'a Aravit LeHithadshut | spec | Special issue | 34 | 2353 | 16 | ||||||||||||
ESP | Spain | CA | Aragonese Council | Chunta Aragonesista | Chunta Aragonesista | spec | Special issue | 2.75 | 2.38 | 1.88 | 6.6667 | 520 | 27 | 1367 | 16 | |||||||
ESP | Spain | PAR | Aragonese Regionalist Party | Partido Aragonés Regionalista | Partido Aragones Regionalista | spec | Special issue | 7.1909 | 6.2727 | 5.9583 | 8.75 | 33904 | 1411 | 510 | 510 | 27 | 1221 | 16 | ||||
ISL | Iceland | Sjf | Association for Equality and Justice | Samtök um jatnrétti og félagshyggju | Samtok um jatnretti og felagshyggju | agr | Agrarian | 5.3 | 4.9 | 6.5 | 56 | 817 | 2 | |||||||||
SVK | Slovakia | ZRS | Association of Workers of Slovakia | Združenie robotníkov Slovenska | Zdruzenie robotnikov Slovenska | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 96210 | 1 | 1563 | 14 | |||||||
ITA | Italy | AIE | Associative Italians Abroad | Associativo Italiani all'Estero | Associativo Italiani all'Estero | spec | Special issue | 26 | 927 | 16 | ||||||||||||
BGR | Bulgaria | Ataka | Attack | Ataka | Ataka | right | Right-wing | 5.46 | 3.25 | 9.17 | 2.4333 | 27 | 1100700 | 2007 | 10 | 535 | 40 | |||||
AUS | Australia | AP | Australia Party | Australia Party | Australia Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1760 | 6 | |||||||||
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 | AD | Australian Democrats | Australian Democrats | Australian Democrats | soc | Social democracy | 3.7004 | 3.3684 | 1.1579 | 63321 | 102 | 203 | 4703 | 33 | 120 | 11 | |||||
AUS | Australia | AG | Australian Greens | Australian Greens | Australian Greens | eco | Green/Ecologist | 1.5439 | 1.2982 | 0.5614 | 4739 | 33 | 751 | 19 | ||||||||
AUS | Australia | ALP | Australian Labor Party | Australian Labor Party | Australian Labor Party | soc | Social democracy | 3.8833 | 4.0351 | 3.2632 | 63320 | 101 | 4721 | 33 | 1253 | 11 | ||||||
AUT | Austria | OVP | Austrian People's Party | Österreichische Volkspartei | Oesterreichische Volkspartei | chr | Christian democracy | 6.4733 | 6.9485 | 7.6198 | 8.8451 | 42520 | 6 | 1040520 | 203 | 309 | 1302 | 4847 | 1302 | 59 | 1013 | 3 |
CHE | Switzerland | FPS | Automobile Party | Freedom Party of Switzerland | Auto-Partei | Freiheitspartei der Schweiz | Auto-Partei | Freiheitspartei der Schweiz | right | Right-wing | 8.0556 | 5.9 | 8.5 | 0.0 | 43951 | 3806 | 1713 | 40 | 1602 | 40 | |||||
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 | |||||||
ITA | Italy | ALD | Autonomy Liberty Democracy | Autonomie Liberté Démocratie | Autonomie Liberte Democratie | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 1063 | 6 | ||||||||
CYP | Cyprus | AM | Awakening 2020 | Afypnisis 2020 | Afypnisis 2020 | spec | Special issue | 51 | 2819 | 16 | ||||||||||||
DEU | Germany | BLB | Baden Rural Federation | Badischer Landbund | Badischer Landbund | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 54 | 2707 | 2 | ||||||||
ISR | Israel | DeTo | Banner of the Torah | Degel HaTorah | Degel HaTorah | con | Conservative | 7.4 | 6.4 | 6.9 | 72614 | 34 | 249 | 26 | ||||||||
ESP | Spain | EHB | Basque Country Unite | Euskal Herria Bildu | Euskal Herria Bildu | spec | Special issue | 27 | 2603 | 16 | ||||||||||||
ESP | Spain | EE | Basque Left | Euzkadiko Ezkerra | Euzkadiko Ezkerra | com | Communist/Socialist | 2.4 | 1.4 | 3.0 | 7.2167 | 33901 | 1403 | 509 | 27 | 1026 | 14 | |||||
ESP | Spain | PNV | Basque Nationalist Party | Partido Nacionalista Vasco – Euzko Alderdi Jeltzalea | Partido Nacionalista Vasco -- Euzko Alderdi Jeltzalea | chr | Christian democracy | 6.2144 | 5.7468 | 6.5139 | 7.8556 | 33902 | 358 | 1724902 | 1409 | 3606 | 506 | 7780 | 506 | 27 | 1361 | 3 |
ESP | Spain | EA | Basque Solidarity | Eusko Alkartasuna | Eusko Alkartasuna | spec | Special issue | 4.3115 | 4.7873 | 4.555 | 7.4841 | 33903 | 1724903 | 3604 | 507 | 507 | 27 | 845 | 16 | |||
DEU | Germany | BP | Bavarian Party | Bayernpartei | Bayernpartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41911 | 54 | 1131 | 26 | |||||||
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 | BVP | Bavarian People's Party | Bayerische Volkspartei | Bayerische Volkspartei | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 54 | 2697 | 3 | ||||||||
SVK | Slovakia | MS | Beautiful Slovakia | Magnificat Slovakia | Magnificat Slovakia | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 1 | 2390 | 3 | ||||||||
BEL | Belgium | UDB | Belgian Democratic Union | Union Democratique Belge | Union Democratique Belge | code | to be coded | 64 | 1181 | 28 | ||||||||||||
BEL | Belgium | BWP-POB | Belgian Labour Party | Belgische Werkliedenpartij – Parti Ouvrier Belge | Belgische Werkliedenpartij -- Parti Ouvrier Belge | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 64 | 2422 | 11 |
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;