view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by party_name_english descending
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MLT | Malta | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 72 | 1572 | 12 | ||||||||||||
NLD | Netherlands | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 8 | 674 | 12 | ||||||||||||
NOR | Norway | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 9 | 793 | 12 | ||||||||||||
NZL | New Zealand | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 11 | 1262 | 12 | ||||||||||||
POL | Poland | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 74 | 1011 | 12 | ||||||||||||
PRT | Portugal | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 63 | 729 | 12 | ||||||||||||
ROU | Romania | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 23 | 761 | 12 | ||||||||||||
SVK | Slovakia | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 1 | 1359 | 12 | ||||||||||||
SVN | Slovenia | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 60 | 1370 | 12 | ||||||||||||
SWE | Sweden | none | no party affiliation | partilös | partilos | none | no family | 35 | 786 | 12 | ||||||||||||
TUR | Turkey | none | no party affiliation | bağımsız | bagimsiz | none | no family | 20 | 1399 | 12 | ||||||||||||
HRV | Croatia | ethnic | ethnic | ethnic | ethnic | none | no family | 62 | 2192 | 12 | ||||||||||||
HRV | Croatia | abroad | abroad | abroad | abroad | none | no family | 62 | 2191 | 12 | ||||||||||||
SVN | Slovenia | LZJ-PS | Zoran Jankovic's List -- Positive Slovenia | Lista Zorana Jankovića – Pozitivna Slovenija | Lista Zorana Jankovica -- Pozitivna Slovenija | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 1987 | 11 | ||||||||
ISR | Israel | Z | Zehut | Zehut | Zehut | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2727 | 40 | |||||||||
SVN | Slovenia | SMS | Youth Party of Slovenia | Stranka mladih Slovenije | Stranka mladih Slovenije | eco | Green/Ecologist | 4.2263 | 4.2719 | 2.7009 | 7.1388 | 97952 | 268 | 1705952 | 4313 | 2908 | 60 | 1512 | 19 | |||
HRV | Croatia | AM | Youth Action | Akcija mladih | Akcija mladih | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 62 | 2186 | 19 | ||||||||
JPN | Japan | YP | Your Party | Minna no Tō | Minna no To | lib | Liberal | 6.0 | 6.7 | 3.6 | 5 | 1124 | 6 | |||||||||
POL | Poland | RP | Your (Palikot's) Movement | Twój Ruch (Palikota) | Twoj Ruch (Palikota) | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 74 | 1945 | 6 | ||||||||
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 | ||||||||
TUR | Turkey | GP | Young Party | Genç Parti | Genc Parti | right | Right-wing | 8.3821 | 6.2657 | 7.5731 | 2.5359 | 8272 | 3405 | 20 | 1647 | 40 | ||||||
LTU | Lithuania | JL | Young Lithuania | Jaunoji Lietuva | Jaunoji Lietuva | right | Right-wing | 9.8 | 2.25 | 8.6 | 1.0 | 2513 | 15 | 383 | 40 | |||||||
FIN | Finland | NSP | Young Finns | Nuorsuomalaiset – Ungfinnarna | Nuorsuomalaiset -- Ungfinnarna | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 14430 | 1412 | 67 | 1009 | 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 | ||||||||||||
BGR | Bulgaria | DaB | Yes, Bulgaria! | Da Bulgaria! | Da Bulgaria! | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2638 | 6 | ||||||||
ESP | Spain | Bai | Yes | Bai | Bai | spec | Special issue | 1724923 | 27 | 385 | 16 | |||||||||||
ISR | Israel | HHT | Yemenite Association | Hitahdut HaTeimanim | Hitahdut HaTeimanim | spec | Special issue | 34 | 1827 | 16 | ||||||||||||
LTU | Lithuania | TAIP | YES -- Homeland Revival and Perspective | Tėvynės atgimimas ir perspektyva | Tevynes atgimimas ir perspektyva | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 15 | 2122 | 6 | ||||||||
FRA | France | LO | Workers' Struggle | Lutte ouvrière | Lutte ouvriere | com | Communist/Socialist | 0.0 | 1.4 | 3.0 | 3.3 | 101 | 1402 | 43 | 1176 | 14 | ||||||
ESP | Spain | PTE-UC | Workers' Party of Spain -- Communist Unity | Partido de los Trabajadores de España-Unidad Comunista | Partido de los Trabajadores de Espana -- Unidad Comunista | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 27 | 2028 | 14 | ||||||||
CZE | Czech Republic | DSSS | Workers' Party of Social Justice | Dělnická strana sociální spravedlnosti | Delnicka strana socialni spravedlnosti | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 795 | 40 | ||||||||
BEL | Belgium | PA-PTB | Workers' Party of Belgium | Partij van de Arbeid – Parti du Travail de Belgique | Partij van de Arbeid -- Parti du Travail de Belgique | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 17 | 1056222 | 119 | 64 | 256 | 14 | |||||
PRT | Portugal | POUS | Workers Party of Socialist Unity | Partido Operário de Unidade Socialista | Partido Operario de Unidade Socialista | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 63 | 375 | 14 | ||||||||
ISR | Israel | Vitzo | Women's International Zionist Organization | Vitzo | Vitzo | spec | Special issue | 34 | 2310 | 16 | ||||||||||||
ISL | Iceland | KL | Women's Alliance | Kvennalistinn | Kvennalistinn | eco | Green/Ecologist | 2.2222 | 2.5 | 1.8 | 15951 | 1701 | 56 | 147 | 19 | |||||||
BGR | Bulgaria | Volya | Will | Volya | Volya | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 2637 | 40 | ||||||||
ISR | Israel | AmSh | Whole Nation | Am Shalem | Am Shalem | spec | Special issue | 34 | 2324 | 16 | ||||||||||||
LVA | Latvia | KPV-LV | Who owns the state? | Kam pieder valsts? | Kam pieder valsts? | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 55 | 2715 | 40 | ||||||||
AUS | Australia | WAP | Western Australian Party | Western Australian Party | Western Australian Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1906 | 6 | |||||||||
TUR | Turkey | RP | Welfare (Virtue) Party | Refah (Fazilet) Partisi | Refah (Fazilet) Partisi | spec | Special issue | 8.3333 | 74715 | 4008 | 20 | 1122 | 16 | |||||||||
PRT | Portugal | NC | We, the Citizens! | Nós, Cidadãos! | Nos, Cidadaos! | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 63 | 2758 | 6 | ||||||||
SVK | Slovakia | SR | We are family -- Boris Kollar | Sme Rodina – Boris Kollár | Sme Rodina -- Boris Kollar | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 1 | 2623 | 40 | ||||||||
BGR | Bulgaria | PP | We Continue the Change | Prodalzhavame promyanata | Prodalzhavame promyanata | spec | Special issue | 10 | 2847 | 16 | ||||||||||||
HRV | Croatia | M! | We Can! -- Political Platform | Možemo! – politička platforma | Mozemo! -- politicka platforma | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 62 | 2810 | 19 | ||||||||
ESP | Spain | P | We Can | Podemos | Podemos | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 27 | 2376 | 14 | ||||||||
BEL | Belgium | RW | Walloon Rally | Rassemblement Wallon | Rassemblement Wallon | soc | Social democracy | 2.6 | 3.5 | 3.5 | 8.1 | 21911 | 303 | 64 | 460 | 11 | ||||||
NLD | Netherlands | VN | Volt Netherlands | Volt Nederland | Volt Nederland | spec | Special issue | 8 | 2735 | 16 | ||||||||||||
LUX | Luxembourg | VL | Volt Luxembourg | Volt Luxembourg | Volt Luxembourg | spec | Special issue | 7 | 2766 | 16 | ||||||||||||
BGR | Bulgaria | VB | Volt Bulgaria | Volt Bulgaria | Volt Bulgaria | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2869 | 6 | ||||||||
SVN | Slovenia | GZS | Voice of Slovenian women | Glas žensk Slovenije | Glas zensk Slovenije | spec | Special issue | 60 | 2022 | 16 | ||||||||||||
CZE | Czech Republic | H | Voice | Hlas | Hlas | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 68 | 2739 | 6 | ||||||||
ESP | Spain | Vox | Voice | Vox | Vox | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 27 | 2380 | 40 | ||||||||
AUS | Australia | VFU-V | Victorian Farmers' Union | Victorian Farmers' Union | Victorian Farmers' Union | agr | Agrarian | 5.3 | 4.9 | 6.5 | 33 | 1929 | 2 | |||||||||
AUS | Australia | VCP | Victorian Country Party | Victorian Country Party | Victorian Country Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1920 | 26 | |||||||||
SVN | Slovenia | VESNA | Vesna -- the Green Party | VESNA – zelena stranka | VESNA -- zelena stranka | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 60 | 2865 | 19 | ||||||||
ITA | Italy | LV | Venetian League | Liga Veneta | Liga Veneta | spec | Special issue | 26 | 1080 | 16 | ||||||||||||
GBR | United Kingdom | VUPP | Vanguard Unionist Progressive Party | Vanguard Unionist Progressive Party | Vanguard Unionist Progressive Party | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 44 | 646 | 40 | ||||||||
NZL | New Zealand | VP | Values Party | Values Party | Values Party | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 11 | 1761 | 19 | |||||||||
ESP | Spain | UV | Valencian Union | Union Valenciana | Union Valenciana | spec | Special issue | 6.0417 | 5.7273 | 5.875 | 8.8769 | 512 | 512 | 27 | 443 | 16 | ||||||
ITA | Italy | UV | Valdotanian Union | Union Valdôtaine | Union Valdotaine | spec | Special issue | 26 | 974 | 16 | ||||||||||||
GBR | United Kingdom | U | Unity | Unity | Unity | spec | Special issue | 44 | 349 | 16 | ||||||||||||
LVA | Latvia | V | Unity | Vienotība | Vienotiba | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 2412 | 55 | 1666 | 26 | |||||||
LVA | Latvia | ViLa | United for Latvia | Vienoti Latvijai | Vienoti Latvijai | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 55 | 2367 | 6 | ||||||||
ISR | Israel | Mapam | United Workers Party | Mifleget HaPoalim HaMeuhedet | Mifleget HaPoalim HaMeuhedet | soc | Social democracy | 3.3 | 3.5 | 3.5 | 72311 | 34 | 1168 | 11 | ||||||||
ESP | Spain | UP | United We Can | Unidas Podemos | Unidas Podemos | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 27 | 2724 | 14 | ||||||||
GBR | United Kingdom | UUUC | United Ulster Unionist Coalition | United Ulster Unionist Coalition | United Ulster Unionist Coalition | code | to be coded | 44 | 1363 | 28 | ||||||||||||
ISR | Israel | YaToMe | United Torah Judaism | Yahadut HaTora HaMeuhedet | Yahadut HaTora HaMeuhedet | con | Conservative | 6.9396 | 2.8146 | 9.7556 | 72535 | 6589 | 34 | 1303 | 26 | |||||||
ISL | Iceland | SA-S | United Socialist Party | Sameiningarflokkur alþýðu – Sósíalistaflokkurinn | Sameiningarflokkur althyou -- Sosialistaflokkurinn | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 15220 | 56 | 1319 | 14 | ||||||||
ROU | Romania | PRU | United Romania Party | Partidul România Unită | Partidul Romania Unita | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 23 | 2648 | 40 | ||||||||
ISR | Israel | HDM | United Religious Front | Hazit Datit Meuhedet | Hazit Datit Meuhedet | spec | Special issue | 34 | 1821 | 16 | ||||||||||||
POL | Poland | SP | United Poland | Solidarna Polska | Solidarna Polska | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 74 | 2372 | 40 | ||||||||
POL | Poland | ZSL | United People's Party | Zjednoczone Stronnictwo Ludowe | Zjednoczone Stronnictwo Ludowe | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 74 | 822 | 2 | ||||||||
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 | ||||||||
ESP | Spain | HB | United People | Herri Batasuna | Herri Batasuna | spec | Special issue | 0.5909 | 1.8 | 4.3889 | 3.25 | 1401 | 3601 | 508 | 508 | 27 | 1317 | 16 | ||||
NZL | New Zealand | UNZ | United New Zealand | United New Zealand | United New Zealand | con | Conservative | 6.1219 | 6.3158 | 6.9 | 64421 | 7332 | 11 | 917 | 26 | |||||||
SVN | Slovenia | ZL-SD | United List -- Social Democrats | Združena lista – Socialni demokrati | Zdruzena lista -- Socialni demokrati | soc | Social democracy | 3.0637 | 3.8001 | 2.9642 | 8.1513 | 97321 | 266 | 1705323 | 4365 | 2903 | 60 | 706 | 11 | |||
SVN | Slovenia | ZdLe | United Left | Združena levica | Zdruzena levica | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 60 | 2334 | 14 | ||||||||
GBR | United Kingdom | UKIP | United Kingdom Independence Party | United Kingdom Independence Party | United Kingdom Independence Party | right | Right-wing | 7.8429 | 8.0938 | 7.8507 | 0.0 | 51951 | 423 | 1826951 | 1108 | 1108 | 44 | 1272 | 40 | |||
AUT | Austria | VGO | United Greens Austria | Vereinte Grüne Österreichs | Vereinte Gruene Oesterreichs | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 59 | 1740 | 19 | ||||||||
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 | |||||||
LTU | Lithuania | LiCS-TPP | United Faction of the Liberal and Centre Union and Nations Resurrection Party | Liberaly ir centro sąjunga ir Tautos prisikelimo partija | Liberaly ir centro sajunga ir Tautos prisikelimo partija | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 15 | 2007 | 26 | ||||||||
CYP | Cyprus | ED | United Democrats | Enomeni Dimokrates | Enomeni Dimokrates | lib | Liberal | 7.1053 | 6.0526 | 4.3421 | 55423 | 5423 | 51 | 1523 | 6 | |||||||
GRC | Greece | EDA | United Democratic Left | Eniaia Dimokratiki Aristera | Eniaia Dimokratiki Aristera | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 41 | 597 | 14 | ||||||||
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 | ||||
ITA | Italy | CDU | United Christian Democrats | Cristiani Democratici Uniti | Cristiani Democratici Uniti | chr | Christian democracy | 6.1667 | 5.145 | 7.7583 | 7.4426 | 818 | 818 | 26 | 128 | 3 | ||||||
AUS | Australia | UAP | United Australia Party | United Australia Party | United Australia Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1912 | 26 | |||||||||
ISR | Israel | RAM-77 | United Arab List -- 1977 | Reshima Aravit Meuhedet – 1977 | Reshima Aravit Meuhedet -- 1977 | spec | Special issue | 34 | 2311 | 16 | ||||||||||||
ISR | Israel | Raam | United Arab List | al-Qā'ima al-'Arabiyya al-Muwaḥḥada | al-Qa'ima al-'Arabiyya al-Muwahhada | spec | Special issue | 34 | 1846 | 16 | ||||||||||||
ESP | Spain | UPyD | Union, Progress and Democracy | Unión Progreso y Democracia | Union Progreso y Democracia | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 276 | 1724010 | 523 | 27 | 551 | 6 | |||||
ESP | Spain | UCD | Union of the Democratic Centre | Unión de Centro Democrático | Union de Centro Democratico | lib | Liberal | 7.1 | 6.7 | 3.6 | 8.7 | 33430 | 1410 | 27 | 135 | 6 | ||||||
GRC | Greece | EDIK | Union of the Democratic Centre | Enosi Dimokratikou Kentrou | Enosi Dimokratikou Kentrou | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 34510 | 41 | 489 | 6 | |||||||
ITA | Italy | UDR | Union of republican democrats | Unione dei democratici per la repubblica | Unione dei democratici per la repubblica | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 26 | 1145 | 3 | ||||||||
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 | ||||
LTU | Lithuania | LPKTS | Union of Lithuanian Political Prisoners and Deportees | Lietuvos politinių kalinių ir terminių sąjunga | Lietuvos politiniu kaliniu ir tremtiniu sajunga | spec | Special issue | 9.8 | 2.25 | 8.6 | 1.0 | 88523 | 2513 | 15 | 1447 | 16 | ||||||
ISL | Iceland | Sfvm | Union of Liberals and Leftist | Samtök frjálslyndra og vinstri manna | Samtok frjalslyndra og vinstri manna | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 15322 | 56 | 53 | 14 | ||||||||
LVA | Latvia | LZ | Union of Latvian Farmers | Latviesu Zemnieku Savieniba | Latviesu Zemnieku Savieniba | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 55 | 2417 | 2 | ||||||||
ISR | Israel | AY | Union of Israel | Agudat Yisrael | Agudat Yisrael | spec | Special issue | 72531 | 34 | 265 | 16 | |||||||||||
EST | Estonia | PK | Union of Farmers | Põllumeeste Kogu | Pollumeeste Kogu | agr | Agrarian | 2.2222 | 4.9 | 6.5 | 5.4 | 1203 | 75 | 1553 | 2 | |||||||
CAN | Canada | UE | Union of Electors | Union [Candidats] des électeurs | Union [Candidats] des electeurs | spec | Special issue | 29 | 2162 | 16 | ||||||||||||
ITA | Italy | UDEUR | Union of Democrats for Europe | Unione Democratici per l'Europa | Unione Democratici per l'Europa | chr | Christian democracy | 5.285 | 4.61 | 7.195 | 8.3833 | 829 | 26 | 399 | 3 |
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;