view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by party_name_ascii 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HUN | Hungary | none | no party affiliation | független | fuggetlen | none | no family | 39 | 1617 | 12 | ||||||||||||
FRA | France | ex-gau | other far-left | extrême gauche | extreme gauche | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 1250226 | 43 | 2083 | 14 | |||||||
FRA | France | ex-dro | other far-right | extrême droite | extreme droite | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 43 | 2079 | 40 | ||||||||
HRV | Croatia | ethnic | ethnic | ethnic | ethnic | none | no family | 62 | 2192 | 12 | ||||||||||||
FIN | Finland | none | no party affiliation | ei kukaan – ingen | ei kukaan -- ingen | none | no family | 67 | 1119 | 12 | ||||||||||||
ITA | Italy | etc | others | diversi | diversi | none | no family | 26 | 825 | 12 | ||||||||||||
FRA | France | d-gauche | other left | divers gauche | divers gauche | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 43 | 177 | 11 | ||||||||
FRA | France | d-eco | other ecologists | divers ecologistes | divers ecologistes | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 43 | 2249 | 19 | ||||||||
FRA | France | d-droite | other right | divers droite | divers droite | con | Conservative | 7.6583 | 9.0 | 9.0 | 5.8333 | 618 | 43 | 285 | 26 | |||||||
FRA | France | d-center | other centre | divers centre | divers centre | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 43 | 2858 | 6 | ||||||||
FRA | France | etc | others | divers | divers | none | no family | 43 | 1328 | 12 | ||||||||||||
TUR | Turkey | none | no party affiliation | bağımsız | bagimsiz | none | no family | 20 | 1399 | 12 | ||||||||||||
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 | ||||||||||||
HRV | Croatia | abroad | abroad | abroad | abroad | none | no family | 62 | 2191 | 12 | ||||||||||||
LUX | Luxembourg | Z-EF | Coerced Conscripts | Zwangsrekrutéierten | Zwangsrekruteierten | spec | Special issue | 7 | 202 | 16 | ||||||||||||
SVN | Slovenia | ZEO | League for Citizens' Equality | Zveza za enakopravnost obCanov | Zveza za enakopravnost obCanov | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2571 | 11 | ||||||||
SVK | Slovakia | ZZ | Change from the Bottom, DU | Zmena zdola, DÚ | Zmena zdola, DU | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 1 | 2013 | 6 | ||||||||
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 | ||||||||
POL | Poland | ZChN | Christian National Union | Zjednoczenie Chrześcijańsko-Narodowe | Zjednoczenie Chrzescijansko-Narodowe | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 74 | 1758 | 26 | ||||||||
HRV | Croatia | ZiZi | Human Shield | Živi zid | Zivi zid | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 62 | 2612 | 40 | ||||||||
ISR | Israel | ZK | General Zionists | Zionim Klalim | Zionim Klalim | lib | Liberal | 6.0 | 6.7 | 3.6 | 72420 | 34 | 1472 | 6 | ||||||||
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 | |||||||
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 | |||||
LTU | Lithuania | Zp | Samogitian Party | Žemaičių partija | Zemaiciu partija | spec | Special issue | 15 | 2025 | 16 | ||||||||||||
HRV | Croatia | ZZ | Greens Together | Zeleni Zajedno | Zeleni Zajedno | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 62 | 2188 | 19 | ||||||||
SVN | Slovenia | ZS | Greens of Slovenia | Zeleni Slovenije | Zeleni Slovenije | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 97110 | 60 | 1619 | 19 | |||||||
BGR | Bulgaria | ZP | Green Party of Bulgaria | Zelena Partiya | Zelena Partija | eco | Green/Ecologist | 5.5556 | 2.5 | 1.8 | 6.5 | 705 | 10 | 963 | 19 | |||||||
ISR | Israel | Z | Zehut | Zehut | Zehut | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2727 | 40 | |||||||||
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 | |||||||
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 | ||||||||
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 | ||||||||
SVN | Slovenia | Zares | For Real | Zares | Zares | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 267 | 1705324 | 2910 | 60 | 326 | 11 | |||||
LVA | Latvia | ZZS | Green and Farmers' Union | Zaļo un Zemnieku savienība | Zalo un Zemnieku savieniba | agr | Agrarian | 5.2632 | 5.3947 | 6.1184 | 6.7763 | 87110 | 198 | 1428110 | 2210 | 55 | 466 | 2 | ||||
HRV | Croatia | ZDS | Democratic Party of Zagorje | Zagorska demokratska stranka | Zagorska demokratska stranka | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 62 | 2610 | 40 | ||||||||
SVK | Slovakia | ZAL | For the People | Za ľudí | Za ludi | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 1 | 2796 | 6 | ||||||||
ISR | Israel | Yiud | Mission | Yiud | Yiud | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2355 | 40 | |||||||||
ISR | Israel | YB | Israel Our Home | Yisrael Beiteinu | Yisrael Beiteinu | right | Right-wing | 8.8 | 5.9 | 8.5 | 72625 | 34 | 1816 | 40 | ||||||||
ISR | Israel | YBA | Israel for Immigration | Yisrael Ba-Aliya | Yisrael Ba-Aliya | lib | Liberal | 6.0 | 6.7 | 3.6 | 72428 | 34 | 277 | 6 | ||||||||
ISR | Israel | YA | There is a Future | Yesh Atid | Yesh Atid | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2321 | 6 | |||||||||
TUR | Turkey | YTP | New Turkey Party | Yeni Türkiye Partisi | Yeni Turkiye Partisi | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 20 | 2304 | 11 | ||||||||
CYP | Cyprus | YH | Jasmine Movement | Yasemin Hareketi | Yasemin Hareketi | soc | Social democracy | 3.3 | 3.5 | 3.5 | 51 | 2784 | 11 | |||||||||
ISR | Israel | Y | Rightwards | Yamina | Yamina | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2726 | 40 | |||||||||
JPN | Japan | SRP | Social Reform Party | Yakaikakushintou zu | Yakaikakushintou zu | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 5 | 1737 | 14 | |||||||||
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 | |||||||
ISR | Israel | Ya-84 | Together | Yahad | Yahad | lib | Liberal | 6.0 | 6.7 | 3.6 | 72414 | 34 | 1269 | 6 | ||||||||
ISR | Israel | Yachad | Together | Yachad | Yachad | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2411 | 40 | |||||||||
DEU | Germany | WP | Economic Party | Wirtschaftspartei | Wirtschaftspartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 2698 | 26 | ||||||||
AUT | Austria | WB | Economic bloc | Wirtschaftsblock | Wirtschaftsblock | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 59 | 2699 | 40 | ||||||||
DEU | Germany | WAV | Economic Reconstruction League | Wirtschaftliche Aufbauvereinigung | Wirtschaftliche Aufbauvereinigung | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 41711 | 54 | 1420 | 40 | |||||||
POL | Poland | WIO | Spring | Wiosna | Wiosna | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 74 | 2740 | 11 | ||||||||
AUS | Australia | WAP | Western Australian Party | Western Australian Party | Western Australian Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1906 | 6 | |||||||||
NLD | Netherlands | VDB | Free-thinking Democratic League | Vrijzinnig Democratische Bond | Vrijzinnig Democratische Bond | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 8 | 944 | 6 | ||||||||
ESP | Spain | Vox | Voice | Vox | Vox | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 27 | 2380 | 40 | ||||||||
BGR | Bulgaria | Volya | Will | Volya | Volya | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 2637 | 40 | ||||||||
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 | ||||||||
CZE | Czech Republic | VB | Free Bloc | Volný blok | Volny blok | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 2854 | 40 | ||||||||
BEL | Belgium | VU | People's Union | Volksunie | Volksunie | right | Right-wing | 6.5321 | 5.8809 | 6.06 | 6.4243 | 21913 | 309 | 407 | 110 | 5003 | 110 | 64 | 290 | 40 | ||
NLD | Netherlands | VVD | People's Party for Freedom and Democracy | Volkspartij voor Vrijheid en Democratie | Volkspartij voor Vrijheid en Democratie | lib | Liberal | 7.3482 | 7.8979 | 4.3887 | 5.9471 | 22420 | 305 | 1528420 | 1107 | 2605 | 1003 | 7200 | 1003 | 8 | 1409 | 6 |
SVK | Slovakia | V | Homeland | Vlasť | Vlast | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 1 | 2798 | 40 | ||||||||
BEL | Belgium | VB | Flemish Block | Flemish Interest | Vlaams Blok | Vlaams Belang | Vlaams Blok | Vlaams Belang | right | Right-wing | 9.6622 | 7.695 | 9.5234 | 2.756 | 21914 | 19 | 1056711 | 313 | 112 | 5063 | 112 | 64 | 993 | 40 | |
BEL | Belgium | V | Alive | Vivant | Vivant | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 64 | 620 | 6 | ||||||||
ISR | Israel | Vitzo | Women's International Zionist Organization | Vitzo | Vitzo | spec | Special issue | 34 | 2310 | 16 | ||||||||||||
LVA | Latvia | VL | All For Latvia! | Visu Latvijai! | Visu Latvijai! | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 55 | 801 | 26 | ||||||||
ISL | Iceland | V | Revival | Viðreisn | Vioreisn | con | Conservative | 7.4 | 6.4 | 6.9 | 56 | 2633 | 26 | |||||||||
ISL | Iceland | Graen | Left-Green Movement | Vinstrihreyfingin – grænt framboð | Vinstrihreyfingin -- graent frambod | eco | Green/Ecologist | 1.1842 | 1.4474 | 1.6667 | 15111 | 6273 | 56 | 210 | 19 | |||||||
FIN | Finland | VIHR | Green League | Vihreä Liitto – Gröna Förbundet | Vihrea Liitto -- Grona Forbundet | eco | Green/Ecologist | 3.6465 | 3.4279 | 2.2671 | 6.9709 | 14110 | 98 | 1246110 | 1302 | 1408 | 5797 | 1408 | 67 | 1062 | 19 | |
CHE | Switzerland | V | Vigilants | Vigilance | Vigilance | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 40 | 2775 | 40 | ||||||||
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 | ||||||||
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 | V | I Believe | Verjamem | Verjamem | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2384 | 11 | ||||||||
SVK | Slovakia | VPN | Public against Violence | Verejnosť proti násiliu | Verejnos' proti nasiliu | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 96430 | 1 | 1061 | 6 | |||||||
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 | ||||||||
ITA | Italy | VA | Rainbow Greens | Verdi Arcobaleno | Verdi Arcobaleno | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 26 | 325 | 19 | ||||||||
DNK | Denmark | VS | Left Socialists | Venstresocialisterne | Venstresocialisterne | com | Communist/Socialist | 0.8 | 1.4 | 3.0 | 0.7333 | 13210 | 501 | 215 | 21 | 189 | 14 | |||||
DNK | Denmark | V | Liberal Party | Venstre | Venstre | lib | Liberal | 7.292 | 7.3696 | 4.9957 | 9.0268 | 13420 | 65 | 1208420 | 508 | 1108 | 212 | 5639 | 211 | 21 | 1605 | 6 |
NOR | Norway | V | Liberal Party of Norway | Venstre | Venstre | lib | Liberal | 5.1467 | 5.9148 | 3.2581 | 4.0766 | 12420 | 1303 | 2906 | 1508 | 7614 | 3507 | 9 | 647 | 6 | ||
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 | ||||||||
CZE | Czech Republic | VV | Public Affairs | Věci veřejné | Veci verejne | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 2110 | 68 | 336 | 6 | |||||||
BGR | Bulgaria | R | Revival | Vazrazhdane | Vazrazhdane | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 2640 | 40 | ||||||||
FIN | Finland | VSL | League for Free Finland | Vapaan Suomen Liitto – Självständighetspartiet | Vapaan Suomen Liitto -- Sjalvstandighetspartiet | spec | Special issue | 85 | 67 | 979 | 16 | |||||||||||
FIN | Finland | VL | Liberal League | Vapaamielisten Liitto – De Frisinnades Förbund | Vapaamielisten Liitto -- De Frisinnades Forbund | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 67 | 1109 | 6 | ||||||||
SWE | Sweden | VSP | Left Socialist Party | Vänstersocialistiska Partiet | Vanstersocialistiska Partiet | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 35 | 2406 | 11 | ||||||||
SWE | Sweden | V | Left Party (Communists) | Vänsterpartiet (kommunisterna) | Vansterpartiet (kommunisterna) | com | Communist/Socialist | 1.5464 | 1.4121 | 2.4562 | 1.2042 | 11220 | 282 | 1752220 | 1501 | 3701 | 1601 | 7960 | 1601 | 35 | 882 | 14 |
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 | |||||||||
HUN | Hungary | VP | Entrepreneurs' Party | Vállalkozók Pártja Egyesület | Vallalkozok Partja Egyesulet | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 39 | 1203 | 6 | ||||||||
FIN | Finland | VEU | Anti-EU Movement | Vaihtoehto EU:Lle | Vaihtoehto EU:Lle | spec | Special issue | 67 | 1649 | 16 | ||||||||||||
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 | |||||||
LTU | Lithuania | K-VRS | PEC -- Vytautas Radzvilas: Recover the State! | VRK – Vytautas Radžvilas: susigrąžinkime valstybę! | VRK -- Vytautas Radzvilas: susigrazinkime valstybe! | none | no family | 15 | 2762 | 12 | ||||||||||||
LTU | Lithuania | K-SLVE | PEC -- Strong Lithuania in United Europe | VRK – Stipri Lietuva vieningoje Europoje | VRK -- Stipri Lietuva vieningoje Europoje | none | no family | 15 | 2764 | 12 | ||||||||||||
LTU | Lithuania | K-PRPJ | PEC -- President Rolandas Paksas' Movement | VRK – Prezidento Rolando Pakso judėjimas | VRK -- Prezidento Rolando Pakso judejimas | none | no family | 15 | 2761 | 12 | ||||||||||||
LTU | Lithuania | K-LS | PEC -- Decisive Leap | VRK – Lemiamas šuolis | VRK -- Lemiamas suolis | none | no family | 15 | 2765 | 12 | ||||||||||||
LTU | Lithuania | K-AMT | PEC -- Ausra Maldeikiene's Rain | VRK – Aušros Maldeikienės traukinys | VRK -- Ausros Maldeikienes traukinys | none | no family | 15 | 2760 | 12 | ||||||||||||
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 | ||||||||
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 |
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;