view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by party_name_short
This data as json, CSV (advanced)
Suggested facets: family_name, family_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ITA | Italy | +EU | More Europe | +Europa | +Europa | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 2737 | 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 | ||||||||
DNK | Denmark | A | The Alternative | Alternativet | Alternativet | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 21 | 2567 | 19 | ||||||||
IRL | Ireland | A | Aontu | Aontú | Aontu | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2795 | 26 | ||||||||
ISL | Iceland | A | Social Democratic Party | Alþýðuflokkurinn | Althyduflokkurinn | soc | Social democracy | 4.4444 | 3.5 | 3.5 | 15320 | 1704 | 56 | 228 | 11 | |||||||
NOR | Norway | A | Teetotaler Party | Avholdspartiet | Avholdspartiet | spec | Special issue | 9 | 2544 | 16 | ||||||||||||
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 | ||||||||
GRC | Greece | AASA | Front of the Greek Anticapitalist Left | Antikapitalistiki Aristeri Synergasia gia tin Anatropi | Antikapitalistiki Aristeri Synergasia gia tin Anatropi | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 0.0 | 407 | 41 | 2097 | 14 | |||||||
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 | ||||||||
FRA | France | AC | Centrist Alliance | Alliance centriste | Alliance centriste | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 43 | 2078 | 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 | |||||||||
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 | |||||||
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 | |||||
ITA | Italy | AD | Democratic Alliance | Alleanza Democratica | Alleanza Democratica | chr | Christian democracy | 5.0 | 5.0 | 5.0 | 6.6667 | 32529 | 817 | 26 | 896 | 3 | ||||||
MLT | Malta | AD | Democratic Alternative | Alternattiva Demokratika | Alternattiva Demokratika | eco | Green/Ecologist | 3.7895 | 3.2632 | 4.6316 | 224 | 1470100 | 6986 | 72 | 360 | 19 | ||||||
PRT | Portugal | AD | Democratic Alliance | Aliança Democrática | Alianca Democratica | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 63 | 1543 | 6 | ||||||||
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 | ||||||||
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 | |||||||
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 | ||||||||
DNK | Denmark | AE | Denmark Demokrats | Danmarksdemokraterne | Danmarksdemokraterne | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 21 | 2888 | 40 | ||||||||
ISR | Israel | AE | One Nation | Am Ehad | Am Ehad | soc | Social democracy | 2.9825 | 1.7053 | 4.349 | 72312 | 6407 | 34 | 615 | 11 | |||||||
AUS | Australia | AG | Australian Greens | Australian Greens | Australian Greens | eco | Green/Ecologist | 1.5439 | 1.2982 | 0.5614 | 4739 | 33 | 751 | 19 | ||||||||
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 |
ESP | Spain | AIC | Canary Islands Group | Agrupacion Independientes de Canarias | Agrupacion Independientes de Canarias | spec | Special issue | 27 | 411 | 16 | ||||||||||||
ITA | Italy | AIE | Associative Italians Abroad | Associativo Italiani all'Estero | Associativo Italiani all'Estero | spec | Special issue | 26 | 927 | 16 | ||||||||||||
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 | AKEL | Progressive Party of Working People | Anorthotikó Kómma Ergazómenou Laoú | Anorthotikon Komma Ergazemenou Laou | com | Communist/Socialist | 1.0526 | 2.6316 | 6.1842 | 55321 | 49 | 1196321 | 5351 | 51 | 572 | 14 | |||||
TUR | Turkey | AKP | Justice and Development Party | Adalet ve Kalkınma Partisi | Adalet ve Kalkinma Partisi | con | Conservative | 6.9873 | 3.797 | 8.499 | 8.6278 | 74622 | 306 | 8140 | 3401 | 20 | 901 | 26 | ||||
NZL | New Zealand | ALCP | Aotearoa Legalise Cannabis Party | Aotearoa Legalise Cannabis Party | Aotearoa Legalise Cannabis Party | spec | Special issue | 11 | 2073 | 16 | ||||||||||||
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 | ||||||||
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 | ||||||||
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 | ||||||
FRA | France | ALP | Liberal People's Action | Action libérale populaire | Action liberale populaire | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 43 | 2593 | 3 | ||||||||
CYP | Cyprus | AM | Awakening 2020 | Afypnisis 2020 | Afypnisis 2020 | spec | Special issue | 51 | 2819 | 16 | ||||||||||||
HRV | Croatia | AM | Youth Action | Akcija mladih | Akcija mladih | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 62 | 2186 | 19 | ||||||||
ITA | Italy | AN | National Alliance | Alleanza Nazionale | Alleanza Nazionale | con | Conservative | 8.0871 | 4.9559 | 8.8366 | 4.3389 | 32710 | 805 | 6606 | 805 | 26 | 373 | 26 | ||||
TUR | Turkey | ANAP | Motherland Party | Anavatan Partisi | Anavatan Partisi | con | Conservative | 6.213 | 5.7287 | 5.8991 | 9.2308 | 74623 | 4007 | 8162 | 20 | 1334 | 26 | |||||
GRC | Greece | ANEL | Independent Greeks | Anexartitoi Ellines | Anexartitoi Ellines | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 41 | 2091 | 40 | ||||||||
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 | ||||||||
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 | |||||
CZE | Czech Republic | ANO-VE | Yes, We Will Troll the Euro-Parliament | ANO, vytrollíme europarlament | ANO, vytrollime europarlament | spec | Special issue | 68 | 2779 | 16 | ||||||||||||
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 | ||||||||
NLD | Netherlands | AOV|VSP | General Senior Union | United Seniors Party | Algemeen Ouderen Verbond | Verenigde Senioren Partij | Algemeen Ouderen Verbond | Verenigde Senioren Partij | spec | Special issue | 8 | 112 | 16 | ||||||||||||
AUS | Australia | AP | Australia Party | Australia Party | Australia Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1760 | 6 | |||||||||
LVA | Latvia | AP! | Development/For! | Attīstībai/Par! | Attistibai/Par! | spec | Special issue | 55 | 2878 | 16 | ||||||||||||
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 |
PRT | Portugal | APU | United People Alliance | Aliança Povo Unido | Alianca Povo Unido | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 63 | 11 | 14 | ||||||||
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 | ||||||||
ESP | Spain | ARM | Ruiz-Mateos List | Agrupación Ruiz-Mateos | Agrupacion Ruiz-Mateos | spec | Special issue | 27 | 73 | 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 | |||||
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 | ||||||||
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 | ||||
FIN | Finland | AS | Aland Coalition | Åländsk Samling | Alandsk Samling | spec | Special issue | 67 | 66 | 16 | ||||||||||||
SVN | Slovenia | AS | Active Slovenia | Aktivna Slovenija | Aktivna Slovenija | lib | Liberal | 4.6 | 3.8 | 2.6 | 7.3333 | 2909 | 60 | 380 | 6 | |||||||
PRT | Portugal | ASDI | Independent Social Democrats | Associação Social Democrata Independente | Associacao Social Democrata Independente | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 35316 | 63 | 622 | 11 | |||||||
ITA | Italy | ASM | Social Alternative Mussolini | Alternativa Sociale Mussolini | Alternativa Sociale Mussolini | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 26 | 323 | 40 | ||||||||
HUN | Hungary | ASZ | Agrarian Alliance | Agrárszövetség | Agrarszovetseg | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 86811 | 39 | 1183 | 2 | |||||||
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 | ||||||||
POL | Poland | AWS | Solidarity Electoral Action | Akcja Wyborcza Solidarność Prawicy | Akcja Wyborcza Solidarnosc Prawicy | chr | Christian democracy | 7.1286 | 4.6148 | 8.1427 | 7.0491 | 92620 | 2928 | 2608 | 74 | 1355 | 3 | |||||
ISR | Israel | AY | Union of Israel | Agudat Yisrael | Agudat Yisrael | spec | Special issue | 72531 | 34 | 265 | 16 | |||||||||||
ISL | Iceland | Ab | People's Alliance | Alþýðubandalagið | Althydubandalagid | com | Communist/Socialist | 2.2222 | 1.4 | 3.0 | 15220 | 1702 | 56 | 1360 | 14 | |||||||
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 | ||||||||
ISR | Israel | AhAv | Labour Unity | Ahdut HaAvoda | Ahdut HaAvoda | soc | Social democracy | 3.3 | 3.5 | 3.5 | 72325 | 34 | 1343 | 11 | ||||||||
ISR | Israel | AlYa | Green Leaf | Ale Yarok | Ale Yarok | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 34 | 2323 | 19 | |||||||||
ISR | Israel | AmSh | Whole Nation | Am Shalem | Am Shalem | spec | Special issue | 34 | 2324 | 16 | ||||||||||||
CYP | Cyprus | Anex | Independents Movement | Independents Movement | Independents Movement | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 2817 | 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 | ||||||||
DNK | Denmark | At | Solidarity (Greenland) | Atassut | Atassut | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 21 | 2575 | 6 | ||||||||
BGR | Bulgaria | Ataka | Attack | Ataka | Ataka | right | Right-wing | 5.46 | 3.25 | 9.17 | 2.4333 | 27 | 1100700 | 2007 | 10 | 535 | 40 | |||||
ISR | Israel | Atid | Future | Atid | Atid | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2356 | 40 | |||||||||
ISL | Iceland | B-H | Civic Movement -- The Movement | Borgarahreyfingin – Hreyfingin | Borgarahreyfingin -- Hreyfingin | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 587 | 6 | |||||||||
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 | |||||||
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 |
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 | |||||
DEU | Germany | BBB | Bavarian Peasants' League | Bayerischer Bauernbund | Bayerischer Bauernbund | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 54 | 2701 | 6 | ||||||||
NLD | Netherlands | BBB | Farmer-Citizen Movement | BoerBurgerBeweging | BoerBurgerBeweging | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 8 | 2824 | 2 | ||||||||
TUR | Turkey | BBP | Great Union Party | Büyük Birlik Partisi | Buyuk Birlik Partisi | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 74626 | 20 | 240 | 40 | |||||||
POL | Poland | BBWR | Non-Party Block for Supporting the Reforms | Bezpartyjny Blok Wspierania Reform | Bezpartyjny Blok Wspierania Reform | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 92901 | 74 | 1019 | 3 | |||||||
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 | ||||||||
AUT | Austria | BD | Centrist Democrats | Bürgerliche Demokraten | Buergerliche Demokraten | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 59 | 2688 | 6 | ||||||||
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 | |||||||
BGR | Bulgaria | BE | Euro-Left Coalition | Balgarska Evrolevica | Balgarska Evrolevica | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 80320 | 10 | 710 | 11 | |||||||
PRT | Portugal | BE | Bloc of the Left | Bloco de Esquerda | Bloco de Esquerda | com | Communist/Socialist | 1.6425 | 1.9526 | 1.267 | 3.7018 | 35211 | 232 | 1620211 | 7632 | 1208 | 63 | 557 | 14 | |||
ISL | Iceland | BF | Bright Future | Björt framtíð | Bjort framtid | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 2204 | 6 | |||||||||
DEU | Germany | BFB | Confederation of free citizens -- Offensive for Germany | Bund freier Bürger – Offensive für Deutschland | Bund freier Buerger -- Offensive fuer Deutschland | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 54 | 1720 | 40 | ||||||||
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 | ||||||||
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 | ||||||||
DEU | Germany | BLB | Baden Rural Federation | Badischer Landbund | Badischer Landbund | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 54 | 2707 | 2 | ||||||||
LUX | Luxembourg | BMP | Party of Farmers and the Middle Class | Baueren- a Mëttelstandspartei | Baueren- a Mettelstandspartei | agr | Agrarian | 5.3 | 4.9 | 6.5 | 7 | 2536 | 2 | |||||||||
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 | ||||||||
ESP | Spain | BNG | Galician Nationalist Bloc | Bloque Nacionalista Galego | Bloque Nacionalista Galego | spec | Special issue | 2.9117 | 2.81 | 2.9378 | 6.6096 | 33908 | 356 | 1724908 | 514 | 513 | 27 | 520 | 16 | |||
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 | ||||||||
GBR | United Kingdom | BNP | British National Party | British National Party | British National Party | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 417 | 1826720 | 1109 | 44 | 1250 | 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 | 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 | ||||||
DEU | Germany | BP | Bavarian Party | Bayernpartei | Bayernpartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41911 | 54 | 1131 | 26 | |||||||
GBR | United Kingdom | BP | Brexit Party | Brexit Party | Brexit Party | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 44 | 2729 | 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;