view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by family_name_short 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ISR | Israel | RDN | Democratic List of Nazareth | Reshima Demokratit shel Natzrat | Reshima Demokratit shel Natzrat | spec | Special issue | 34 | 1824 | 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 | ||||||||||||
ISR | Israel | ReLo | Fighters List | Reshimat HaLohmim | Reshimat HaLohmim | spec | Special issue | 34 | 2309 | 16 | ||||||||||||
ISR | Israel | SV | Cooperation and Brotherhood | Shituf VeAhvah | Shituf VeAahvah | spec | Special issue | 34 | 1839 | 16 | ||||||||||||
ISR | Israel | Shas | Sephardi Guardians | Shomrei Sfarad | Shomrei Sfarad | spec | Special issue | 7.0417 | 2.1637 | 9.6842 | 72533 | 6555 | 34 | 788 | 16 | |||||||
ISR | Israel | THTH | Movement for the Renewal of Social Zionism | Tenoa'a leHithadshut Tzionut Hevratit | Tenoa'a leHithadshut Tzionut Hevratit | spec | Special issue | 34 | 2354 | 16 | ||||||||||||
ISR | Israel | Taal | Arab Movement for Renewal | Tnu'a Aravit LeHithadshut | Tnu'a Aravit LeHithadshut | spec | Special issue | 34 | 2353 | 16 | ||||||||||||
ISR | Israel | Vitzo | Women's International Zionist Organization | Vitzo | Vitzo | spec | Special issue | 34 | 2310 | 16 | ||||||||||||
ITA | Italy | AIE | Associative Italians Abroad | Associativo Italiani all'Estero | Associativo Italiani all'Estero | spec | Special issue | 26 | 927 | 16 | ||||||||||||
ITA | Italy | Fed | Federalism | Federalismo – Europa dei Popoli | Federalismo -- Europa dei Popoli | spec | Special issue | 26 | 473 | 16 | ||||||||||||
ITA | Italy | LL | Lombard League | Liga Lombarda | Liga Lombarda | spec | Special issue | 26 | 1560 | 16 | ||||||||||||
ITA | Italy | LV | Venetian League | Liga Veneta | Liga Veneta | spec | Special issue | 26 | 1080 | 16 | ||||||||||||
ITA | Italy | MIS | Movement for the Independence of Sicily | Movimento Indipendentista Siciliano | Movimento Indipendentista Siciliano | spec | Special issue | 26 | 1028 | 16 | ||||||||||||
ITA | Italy | PNP | National Pensioners' Party | Partito Nazionale Pensionati | Partito Nazionale Pensionati | spec | Special issue | 26 | 613 | 16 | ||||||||||||
ITA | Italy | PP | Pensioners' Party | Partito Pensionati | Partito Pensionati | spec | Special issue | 5.75 | 4.5 | 8.0 | 6.0 | 830 | 26 | 502 | 16 | |||||||
ITA | Italy | SVP | South Tyrol Peoples Party | Südtiroler Volkspartei | Suedtiroler Volkspartei | spec | Special issue | 5.4 | 5.085 | 6.9 | 7.6083 | 827 | 26 | 1030 | 16 | |||||||
ITA | Italy | UV | Valdotanian Union | Union Valdôtaine | Union Valdotaine | spec | Special issue | 26 | 974 | 16 | ||||||||||||
JPN | Japan | NHK | The party that protects those who do not pay the NHK license fee | NHK jushinryō o shiharawanai kokumin o mamoru tō | NHK jushinryo o shiharawanai kokumin o mamoru to | spec | Special issue | 5 | 2853 | 16 | ||||||||||||
LTU | Lithuania | DK | The Way of Courage | Drąsos kelias | Drasos kelias | spec | Special issue | 15 | 2121 | 16 | ||||||||||||
LTU | Lithuania | LLL | Lithuanian Liberty League | Lietuvos laisvės lyga | Lietuvos laisves lyga | spec | Special issue | 15 | 1782 | 16 | ||||||||||||
LTU | Lithuania | LLRA | Election Action of Lithuania's Poles | Lietuvos lenkų rinkimų akcija | Lietuvos lenku rinkimu akcija | spec | Special issue | 3.865 | 3.9 | 7.325 | 7.4667 | 88951 | 1440952 | 2511 | 15 | 28 | 16 | |||||
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 | ||||||
LTU | Lithuania | LRS | Lithuanian Russian Union | Lietuvos rusų sąjunga | Lietuvos rusu sajunga | spec | Special issue | 2.2 | 2.25 | 7.0 | 5.3333 | 204 | 1440524 | 2503 | 15 | 863 | 16 | |||||
LTU | Lithuania | LTMA | Alliance of the Lithuanian National Minorities | Lietuvos tautinių mažumų aljansas | Lietuvos tautiniu mazumu aljansas | spec | Special issue | 15 | 2036 | 16 | ||||||||||||
LTU | Lithuania | Zp | Samogitian Party | Žemaičių partija | Zemaiciu partija | spec | Special issue | 15 | 2025 | 16 | ||||||||||||
LUX | Luxembourg | Bl | Citizens' List | Biergerlëscht | Biergerlescht | spec | Special issue | 416 | 1442009 | 7 | 1130 | 16 | ||||||||||
LUX | Luxembourg | GLS | Group for Luxembourgian Sovereignty | Groupement fir d'Lëtzebuerger Souveränitéit | Groupement fir d'Letzebuerger Souveraniteit | spec | Special issue | 7 | 2146 | 16 | ||||||||||||
LUX | Luxembourg | MIP | Popular Independent Movement | Mouvement indépendant populaire | Mouvement independant populaire | spec | Special issue | 7 | 1462 | 16 | ||||||||||||
LUX | Luxembourg | Pi | Pirate Party Luxembourg | Piratepartei Lëtzebuerg | Piratepartei Letzebuerg | spec | Special issue | 7 | 2256 | 16 | ||||||||||||
LUX | Luxembourg | VL | Volt Luxembourg | Volt Luxembourg | Volt Luxembourg | spec | Special issue | 7 | 2766 | 16 | ||||||||||||
LUX | Luxembourg | Z-EF | Coerced Conscripts | Zwangsrekrutéierten | Zwangsrekruteierten | spec | Special issue | 7 | 202 | 16 | ||||||||||||
LVA | Latvia | AP! | Development/For! | Attīstībai/Par! | Attistibai/Par! | spec | Special issue | 55 | 2878 | 16 | ||||||||||||
LVA | Latvia | LG | Light of Latgale | Latgales Gaisma | Latgales Gaisma | spec | Special issue | 55 | 956 | 16 | ||||||||||||
LVA | Latvia | LKPP | Latvias Party of Russian Citizens | Latvijas Krievu pilsoņu partija | Latvijas Krievu pilsonu partija | spec | Special issue | 55 | 1083 | 16 | ||||||||||||
LVA | Latvia | LP | Liepaja Party | Liepājas Partija | Liepajas Partija | spec | Special issue | 55 | 2891 | 16 | ||||||||||||
LVA | Latvia | LTF | Popular Front of Latvia | Latvijas Tautas fronte | Latvijas Tautas fronte | spec | Special issue | 55 | 42 | 16 | ||||||||||||
LVA | Latvia | S! | For Stability! | Stabilitātei! | Stabilitatei | spec | Special issue | 55 | 2875 | 16 | ||||||||||||
LVA | Latvia | SV | Sovereign Power | Suverēnā vara | Suverena vara | spec | Special issue | 55 | 2882 | 16 | ||||||||||||
LVA | Latvia | TKL | People's Servants for Latvia | Tautas kalpi Latvijai | Tautas kalpi Latvijai | spec | Special issue | 55 | 2881 | 16 | ||||||||||||
MLT | Malta | GP | Gozo Party | Gozo Party | Gozo Party | spec | Special issue | 72 | 1298 | 16 | ||||||||||||
MLT | Malta | JP | Jones Party | Jones Party | Jones Party | spec | Special issue | 72 | 248 | 16 | ||||||||||||
NLD | Netherlands | 50+ | 50PLUS | 50PLUS | 50PLUS | spec | Special issue | 8 | 2109 | 16 | ||||||||||||
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 | ||||||||||||
NLD | Netherlands | EuTr | Europe Transparent | Europa Transparant | Europa Transparant | spec | Special issue | 8 | 339 | 16 | ||||||||||||
NLD | Netherlands | PvdD | Party for the Animals | Partij voor de Dieren | Partij voor de Dieren | spec | Special issue | 300 | 1528006 | 1018 | 8 | 990 | 16 | |||||||||
NLD | Netherlands | VN | Volt Netherlands | Volt Nederland | Volt Nederland | spec | Special issue | 8 | 2735 | 16 | ||||||||||||
NOR | Norway | A | Teetotaler Party | Avholdspartiet | Avholdspartiet | spec | Special issue | 9 | 2544 | 16 | ||||||||||||
NOR | Norway | Hf | Resistance Movement | Hjemmefronten | Hjemmefronten | spec | Special issue | 9 | 17 | 16 | ||||||||||||
NOR | Norway | P | Pensioners Party | Pensjonistpartiet | Pensjonistpartiet | spec | Special issue | 9 | 733 | 16 | ||||||||||||
NZL | New Zealand | ALCP | Aotearoa Legalise Cannabis Party | Aotearoa Legalise Cannabis Party | Aotearoa Legalise Cannabis Party | spec | Special issue | 11 | 2073 | 16 | ||||||||||||
NZL | New Zealand | MP | Maori Party | Māori Party | Maori Party | spec | Special issue | 64951 | 11 | 114 | 16 | |||||||||||
NZL | New Zealand | Mana | Mana Party | Mana Party | Mana Party | spec | Special issue | 11 | 1972 | 16 | ||||||||||||
NZL | New Zealand | OR | Outdoor Recreation New Zealand | Outdoor Recreation New Zealand | Outdoor Recreation New Zealand | spec | Special issue | 11 | 2074 | 16 | ||||||||||||
NZL | New Zealand | RM | Ratana Movement | Rātana Movement | Rtana Movement | spec | Special issue | 11 | 2470 | 16 | ||||||||||||
NZL | New Zealand | SC|DP | Social Credit | Democratic Party | Social Credit | Democratic Party | Social Credit | Democratic Party | spec | Special issue | 5.6 | 64951 | 1202 | 11 | 1636 | 16 | |||||||||
POL | Poland | KPEiR | National Party of Pensioners and Retired | Krajowa Partia Emerytów i Rencistów | Krajowa Partia Emerytow i Rencistow | spec | Special issue | 74 | 109 | 16 | ||||||||||||
POL | Poland | KPEiR-RP | National Agreement of Pensioners and Retired of the Republic Poland | Krajowe Porozumienie Emerytów i Rencistów Rzeczypospolitej Polskiej | Krajowe Porozumienie Emerytow i Rencistow Rzeczypospolitej Polskiej | spec | Special issue | 74 | 1275 | 16 | ||||||||||||
POL | Poland | MN | German minority | Mniejszość niemiecka w Polsce | Mniejszosc niemiecka | spec | Special issue | 92953 | 74 | 900 | 16 | |||||||||||
POL | Poland | RAS | Movement for Silesian Autonomy | Ruch Autonomii Śląska | Ruch Autonomii Slaska | spec | Special issue | 92952 | 74 | 1208 | 16 | |||||||||||
PRT | Portugal | PSN | National Solidarity Party | Partido da Solidariedade Nacional | Partido da Solidariedade Nacional | spec | Special issue | 7.5 | 35951 | 1207 | 63 | 82 | 16 | |||||||||
ROU | Romania | PPR | Party of Pensioners of Romania | Partidul Pensionarilor din Romania | Partidul Pensionarilor din Romania | spec | Special issue | 23 | 2106 | 16 | ||||||||||||
SVK | Slovakia | NS | New Slovakia | Nové Slovensko | Nove Slovensko | spec | Special issue | 1 | 2237 | 16 | ||||||||||||
SVK | Slovakia | SPK | Party against Corruption, for Order, Labour and Money for all Decent Citizens | Strana proti korupcii, za poriadok, prácu a peniaze pre všetkých slušných obcanov | Strana proti korupcii, za poriadok, pracu a peniaze pre vsetkych slusnych obcanov | spec | Special issue | 1 | 2238 | 16 | ||||||||||||
SVN | Slovenia | DEMOS | Democratic Opposition of Slovenia | Demokratična opozicija Slovenije | Demokraticna opozicija Slovenije | spec | Special issue | 60 | 321 | 16 | ||||||||||||
SVN | Slovenia | DeSUS | Democratic Party of Pensioners of Slovenia | Demokratična stranka upokojencev Slovenije | Demokraticna stranka upokojencev Slovenije | spec | Special issue | 3.2292 | 3.225 | 5.0708 | 7.0936 | 97951 | 260 | 1705951 | 4183 | 2906 | 60 | 1587 | 16 | |||
SVN | Slovenia | GZD | Healthy Society Movement | Gibanje Zdrava Družba | Gibanje Zdrava Druzba | spec | Special issue | 60 | 2886 | 16 | ||||||||||||
SVN | Slovenia | GZS | Voice of Slovenian women | Glas žensk Slovenije | Glas zensk Slovenije | spec | Special issue | 60 | 2022 | 16 | ||||||||||||
SVN | Slovenia | Ita | Italian national community | Italijanska narodna skupnost | Italijanska narodna skupnost | spec | Special issue | 60 | 199 | 16 | ||||||||||||
SVN | Slovenia | Mad | Hungarian national community | Madžarska narodna skupnost | Madzarska narodna skupnost | spec | Special issue | 60 | 65 | 16 | ||||||||||||
SVN | Slovenia | PSS | Slovenian Pirate Party | Piratska stranka Slovenije | Piratska stranka Slovenije | spec | Special issue | 60 | 2338 | 16 | ||||||||||||
SVN | Slovenia | Resni.ca | Resni.ca | Resni.ca | Resni ca | spec | Special issue | 60 | 2885 | 16 | ||||||||||||
SVN | Slovenia | SO | Slovenia is Ours | Slovenija je naša | Slovenija je nasa | spec | Special issue | 60 | 2019 | 16 | ||||||||||||
SWE | Sweden | Fi | Feminist Initiative | Feministiskt initiativ | Feministiskt initiativ | spec | Special issue | 286 | 35 | 1521 | 16 | |||||||||||
SWE | Sweden | Jl | June List | Junilistan | Junilistan | spec | Special issue | 5.67 | 5.89 | 5.14 | 1.5167 | 284 | 1609 | 35 | 404 | 16 | ||||||
SWE | Sweden | Pi | Pirate Party | Piratpartiet | Piratpartiet | spec | Special issue | 287 | 1752000 | 1611 | 35 | 721 | 16 | |||||||||
SWE | Sweden | SJ | Sarajevo List | Sarajevolistan | Sarajevolistan | spec | Special issue | 35 | 1806 | 16 | ||||||||||||
SWE | Sweden | SPI | Swedish Senior Citizen Interest Party | Sveriges pensionärers intresseparti | Sveriges pensionarers intresseparti | spec | Special issue | 35 | 407 | 16 | ||||||||||||
TUR | Turkey | RP | Welfare (Virtue) Party | Refah (Fazilet) Partisi | Refah (Fazilet) Partisi | spec | Special issue | 8.3333 | 74715 | 4008 | 20 | 1122 | 16 | |||||||||
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 | 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 | ||||||
AUS | Australia | DLP | Democratic Labour Party | Democratic Labour Party | Democratic Labour Party | soc | Social democracy | 4.1667 | 3.5 | 3.5 | 63330 | 204 | 33 | 1306 | 11 | |||||||
AUS | Australia | Katter | Katter's Australian Party | Katter's Australian Party | Katter's Australian Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 33 | 2258 | 11 | |||||||||
AUS | Australia | LCL | Liberal and Country League | Liberal and Country League | Liberal and Country League | soc | Social democracy | 3.3 | 3.5 | 3.5 | 33 | 1919 | 11 | |||||||||
AUS | Australia | LLP | Lang Labour Party | Lang Labour Party | Lang Labour Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 33 | 303 | 11 | |||||||||
AUS | Australia | NL | National Labor | National Labor | National Labor | soc | Social democracy | 3.3 | 3.5 | 3.5 | 33 | 2003 | 11 | |||||||||
AUT | Austria | Fritz | The Citizens' Forum Austria | Bürgerforum Österreich – Liste Fritz Dinkhauser | Buergerforum Oesterreich -- Liste Fritz Dinkhauser | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 59 | 1746 | 11 | ||||||||
AUT | Austria | SPO | Social Democratic Party of Austria | Sozialdemokratische Partei Österreichs | Sozialdemokratische Partei Oesterreichs | soc | Social democracy | 3.7293 | 3.4728 | 3.4766 | 8.4495 | 42320 | 11 | 1040320 | 202 | 308 | 1301 | 4865 | 1301 | 59 | 973 | 11 |
BEL | Belgium | BSP-PSB | Belgian Socialist Party | Belgische Socialistische Partij – Parti Socialiste Belge | Belgische Socialistische Partij -- Parti Socialiste Belge | soc | Social democracy | 2.5 | 3.5 | 3.5 | 8.1 | 21320 | 302 | 64 | 167 | 11 | ||||||
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 | ||||||||
BEL | Belgium | FP|VNV | Front Party | Flemish National Union | Frontpartij | Vlaams Nationaal Verbond | Frontpartij | Vlaams Nationaal Verbond | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 64 | 2424 | 11 | ||||||||
BEL | Belgium | KLS | Cartel of Liberals and Socialists | Kartel Liberale en Socialistische | Kartel Liberale en Socialistische | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 64 | 1335 | 11 | ||||||||
BEL | Belgium | PS | Socialist Party [Francophone] | Parti Socialiste | Parti Socialiste | soc | Social democracy | 2.9307 | 2.5938 | 3.1712 | 8.1465 | 21322 | 24 | 1056322 | 302 | 403 | 102 | 5023 | 102 | 64 | 1378 | 11 |
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 | ||||||
BEL | Belgium | SP | Socialist Party | Socialistische Partij | Socialistische Partij | soc | Social democracy | 3.2459 | 3.0183 | 3.0805 | 7.9023 | 21321 | 18 | 1056327 | 304 | 404 | 103 | 5043 | 103 | 64 | 1029 | 11 |
BEL | Belgium | SPa+Spi | Socialist Party Different / Social Liberal Party | Socialistische Partij Anders / Sociaal-Liberale Partij | Socialistische Partij Anders / Sociaal-Liberale Partij | soc | Social democracy | 3.255 | 3.0183 | 3.0805 | 7.6571 | 21321 | 5043 | 103 | 64 | 1113 | 11 | |||||
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 | ||||||||
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 | |||||||
BGR | Bulgaria | BSP | Bulgarian Socialist Party | Balgarska Sotsialisticheska Partiya | Balgarska Potsialisticheska Partiya | soc | Social democracy | 3.0064 | 2.9187 | 4.5029 | 8.1871 | 80220 | 26 | 1100300 | 702 | 841 | 10 | 982 | 11 | |||
BGR | Bulgaria | D21 | Movement 21 | Dvizhenie 21 | Dvizhenie 21 | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2379 | 11 | ||||||||
BGR | Bulgaria | DAR | Democratic Alternative for the Republic | Demokratichna Alternativa za Republikata | Demokratichna Alternativa za Republikata | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2170 | 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;