view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by party_name 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ISL | Iceland | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 56 | 134 | 12 | ||||||||||||
ISR | Israel | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 34 | 123 | 12 | ||||||||||||
JPN | Japan | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 5 | 905 | 12 | ||||||||||||
LTU | Lithuania | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 15 | 58 | 12 | ||||||||||||
LUX | Luxembourg | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 7 | 1002 | 12 | ||||||||||||
LVA | Latvia | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 55 | 288 | 12 | ||||||||||||
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 | ||||||||||||
DNK | Denmark | none | no party affiliation | ingen | ingen | none | no family | 21 | 1128 | 12 | ||||||||||||
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 | ||||||||
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 | |||||
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 | ||||||||
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 | ||||
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 | |||||
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 | |||||||||
BEL | Belgium | WOW | Growing Old in Dignity | Waardig Ouder Worden | Growing Old in Dignity | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 64 | 470 | 40 | ||||||||
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 | |||||||
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 |
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 | ||||||||
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 | |
ISL | Iceland | V | Revival | Viðreisn | Vioreisn | con | Conservative | 7.4 | 6.4 | 6.9 | 56 | 2633 | 26 | |||||||||
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 | 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 | |
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 |
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;