view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
161 rows where family_name = "Communist/Socialist"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ITA | Italy | PdUP | Proletarian Unity Party | Partito di Unità Proletaria | Partito di Unita Proletaria | com | Communist/Socialist | 1.3833 | 1.0 | 3.0 | 5.8333 | 32210 | 1002 | 822 | 26 | 968 | 14 | |||||
ITA | Italy | S | Left | Sinistra | Sinistra | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 371 | 1380007 | 838 | 26 | 465 | 14 | |||||
JPN | Japan | JCP | Japan Communist Party | Nihon Kyōsan-tō | Nihon Kyosan-to | com | Communist/Socialist | 1.148 | 4.072 | 4.032 | 71220 | 2201 | 8376 | 5 | 1540 | 14 | ||||||
JPN | Japan | LFP | Labour Farmer Party | Rōdōnōmintō | Rodonominto | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 5 | 1736 | 14 | |||||||||
JPN | Japan | LWSP | Left Wing Socialist Party | Saha Shakai Tô | Saha Shakai To | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 5 | 1723 | 14 | |||||||||
JPN | Japan | ReiShin | Reiwa Shinsengumi | Reiwa Shinsengumi | Reiwa Shinsengumi | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 5 | 2828 | 14 | |||||||||
JPN | Japan | SRP | Social Reform Party | Yakaikakushintou zu | Yakaikakushintou zu | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 5 | 1737 | 14 | |||||||||
LTU | Lithuania | LKP | Communist Party of Lithuania | Lietuvos komunistų partija | Lietuvos komunistc partija | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 15 | 1446 | 14 | ||||||||
LTU | Lithuania | SPF | Socialist People's Front | Socialist People's Front | Socialist People's Front | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 206 | 2519 | 15 | 1056 | 14 | ||||||
LTU | Lithuania | TSKP | Lithuanian Communist Party on the CPSU Platform | Lietuvos komunistų partija TSKP platformoje | Lietuvos komunistu partija TSKP platformoje | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 15 | 1623 | 14 | ||||||||
LUX | Luxembourg | DL | The Left | Déi Lénk | Dei Lenk | com | Communist/Socialist | 0.5263 | 0.8772 | 1.0526 | 215 | 1442222 | 6906 | 7 | 457 | 14 | ||||||
LUX | Luxembourg | KPL | Communist Party of Luxembourg | Kommunistesch Partei Lëtzebuerg | Kommunistesch Partei Letzebuerg | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 23220 | 216 | 1442220 | 904 | 7 | 151 | 14 | |||||
LVA | Latvia | LKP | Communist Party of Latvia | Latvijas Komunistiskā partija | Latvijas Komunistiska partija | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 55 | 1260 | 14 | ||||||||
LVA | Latvia | LSP | Socialist Party of Latvia | Latvijas Sociālistiskā partija | Latvijas Socialistiska partija | com | Communist/Socialist | 1.25 | 2.1093 | 5.5837 | 4.8684 | 87310 | 2106 | 2402 | 55 | 309 | 14 | |||||
LVA | Latvia | LVP | Latvian Unity Party | Latvijas Vienības Partija | Latvijas Vienibas Partija | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 87320 | 55 | 1042 | 14 | |||||||
NLD | Netherlands | CPN | Communist Party of the Netherlands | Communistische Partij Nederland | Communistische Partij Nederland | com | Communist/Socialist | 0.8 | 1.4 | 3.0 | 5.0 | 1102 | 1012 | 8 | 1194 | 14 | ||||||
NLD | Netherlands | PSP | Pacifist Socialist Party | Pacifistisch Socialistische Partij | Pacifistisch Socialistische Partij | com | Communist/Socialist | 0.6 | 1.4 | 3.0 | 5.0 | 1101 | 1011 | 8 | 1452 | 14 | ||||||
NLD | Netherlands | RSP | Revolutionary Socialist Party | Revolutionair Socialistische Partij | Revolutionair Socialistische Partij | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 8 | 2465 | 14 | ||||||||
NLD | Netherlands | SP | Socialist Party | Socialistiese Partij | Socialistiese Partij | com | Communist/Socialist | 1.3682 | 1.0421 | 4.2099 | 2.5049 | 22220 | 304 | 1528220 | 7180 | 1014 | 8 | 357 | 14 | |||
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 | ||||||||
NOR | Norway | NKP | Communist Party of Norway | Norges Kommunistiske Parti | Norges Kommunistiske Parti | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 0.0 | 12220 | 1501 | 9 | 27 | 14 | ||||||
NOR | Norway | RV | Red Electoral Alliance | Rød Valgallianse | Rod Valgallianse | com | Communist/Socialist | 0.4089 | 0.5764 | 1.0 | 0.4511 | 2901 | 7560 | 9 | 1638 | 14 | ||||||
NOR | Norway | SF | Socialist People's Party | Sosialistisk Folkeparti | Sosialistisk Folkeparti | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 12221 | 9 | 1773 | 14 | |||||||
NOR | Norway | SV | Socialist Left Party | Sosialistisk Venstreparti | Sosialistisk Venstreparti | com | Communist/Socialist | 1.5839 | 1.3534 | 1.5038 | 1.1568 | 12221 | 1301 | 2902 | 1502 | 7578 | 3504 | 9 | 81 | 14 | ||
NZL | New Zealand | CPNZ | Communist Party of New Zealand | Communist Party of New Zealand | Communist Party of New Zealand | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 11 | 2076 | 14 | |||||||||
NZL | New Zealand | DLP | Democratic Labour Party | Democratic Labour Party | Democratic Labour Party | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 11 | 1968 | 14 | |||||||||
POL | Poland | PZPR | Polish United Workers' Party | Polska Zjednoczone Partia Robotnicza | Polska Zjednoczone Partia Robotnicza | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 74 | 1077 | 14 | ||||||||
POL | Poland | PZZ | Polish Western Union | Polski Związek Zachodni | Polski Zwiazek Zachodni | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 92711 | 74 | 1074 | 14 | |||||||
POL | Poland | SD | Democratic Party | Stronnictwo Demokratyczne | Stronnictwo Demokratyczne | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 92211 | 2612 | 74 | 1216 | 14 | ||||||
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 | ||||||||
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 | |||
PRT | Portugal | CDU | Unified Democratic Coalition | Coligação Democrático Unitária | Coligacao Democratico Unitaria | com | Communist/Socialist | 2.2233 | 1.48 | 2.6433 | 3.2 | 35229 | 234 | 1620229 | 1201 | 1201 | 63 | 1295 | 14 | |||
PRT | Portugal | FSP | People's Socialist Front | Frente Socialista Popular | Frente Socialista Popular | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 63 | 601 | 14 | ||||||||
PRT | Portugal | MES | Movement of Socialist Left | Movimento de Esquerda Socialista | Movimento de Esquerda Socialista | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 63 | 1508 | 14 | ||||||||
PRT | Portugal | PCP | Portuguese Communist Party | Partido Comunista Português | Partido Comunista Portugues | com | Communist/Socialist | 2.1754 | 1.6343 | 1.6291 | 2.0461 | 35220 | 3101 | 1209 | 7668 | 63 | 514 | 14 | ||||
PRT | Portugal | PCTP/MRPP | Communist Party of the Portuguese Workers / Reorganizative Movement of the Party of the Proletariat | Comunista dos Trabalhadores Portugueses / Movimento Reorganizativo do Partido do Proletariado | Comunista dos Trabalhadores Portugueses / Movimento Reorganizativo do Partido do Proletariado | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 237 | 63 | 281 | 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 | ||||||||
PRT | Portugal | PSR | Revolutionary Socialist Party | Partido Socialista Revolucionário | Partido Socialista Revolucionario | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 1.3833 | 1208 | 63 | 998 | 14 | |||||||
PRT | Portugal | Ref | Reformists | Reformadores | Reformadores | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 63 | 1772 | 14 | ||||||||
PRT | Portugal | UDP | Popular Democratic Union | União Democrática Popular | Uniao Democratica Popular | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 1.95 | 35210 | 1211 | 63 | 260 | 14 | ||||||
ROU | Romania | PP-DD | People's Party -- Dan Diaconescu | Partidul Poporului – Dan Diaconescu | Partidul Poporului -- Dan Diaconescu | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 23 | 2130 | 14 | ||||||||
ROU | Romania | PS | Socialist Party | Partidul Socialist | Partidul Socialist | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 23 | 2104 | 14 | ||||||||
ROU | Romania | PSM | Socialist Party of Labour | Partidul Socialist al Muncii | Partidul Socialist al Muncii | com | Communist/Socialist | 5.5556 | 1.4 | 3.0 | 3.3 | 93713 | 3210 | 23 | 562 | 14 | ||||||
ROU | Romania | PSMR | Romanian Socialist Party of Workers | Partidul Socialist Muncitoresc Roman | Partidul Socialist Muncitoresc Roman | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 23 | 2105 | 14 | ||||||||
ROU | Romania | PSoDR | Romanian Socialist Democratic Party | Partidul Socialist Democrat Român | Partidul Socialist Democrat Roman | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 93222 | 23 | 307 | 14 | |||||||
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 | ||||||||
SVK | Slovakia | KSS | Communist Party of Slovakia | Komunistická strana Slovenska | Komunisticka strana Slovenska | com | Communist/Socialist | 0.5275 | 0.937 | 4.5302 | 3.5075 | 96222 | 1703222 | 3928 | 2807 | 1 | 44 | 14 | ||||
SVK | Slovakia | PaS | Law and Justice | Právo a spravodlivost | Pravo a spravodlivost | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 1 | 2389 | 14 | ||||||||
SVK | Slovakia | SDL | Party of the Democratic Left | Strana demokratickej ľavice | Strana demokratickej lavice | com | Communist/Socialist | 3.2398 | 2.5658 | 1.9079 | 7.7961 | 96220 | 3402 | 4053 | 1 | 1415 | 14 | |||||
SVK | Slovakia | SV | Common Choice | Spoločná voľba | Spolocna Vol'ba | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 96221 | 1 | 527 | 14 | |||||||
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 | IDS | Initiative for Democratic Socialism | Iniciativa za demokratični socializem | Iniciativa za demokraticni socializem | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 60 | 2335 | 14 | ||||||||
SVN | Slovenia | L | The Left | Levica | Levica | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 60 | 2670 | 14 | ||||||||
SVN | Slovenia | SSS | Socialist Party of Slovenia | Socialistična stranka Slovenije | Socialisticna stranka Slovenije | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 60 | 317 | 14 | ||||||||
SVN | Slovenia | ZdLe | United Left | Združena levica | Zdruzena levica | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 60 | 2334 | 14 | ||||||||
SWE | Sweden | SKP-H | Communist Party of Sweden [Hoglund] | Sveriges Kommunistiska Parti [Höglund] | Sveriges Kommunistiska Parti [Hoglund] | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 35 | 2475 | 14 | ||||||||
SWE | Sweden | SP | Socialist Party | Socialistiska partiet | Socialistiska partiet | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 35 | 2478 | 14 | ||||||||
SWE | Sweden | SSV-21 | Social Democratic Left Party of Sweden -- 1921 | Sverges Socialdemokratiska Vänsterparti – 1921 | Sverges Socialdemokratiska Vansterparti -- 1921 | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 35 | 2557 | 14 | ||||||||
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 |
TUR | Turkey | HADEP | People's Democracy Party | Halkın Demokrasi Partisi | Halkin Demokrasi Partisi | com | Communist/Socialist | 2.2267 | 2.5329 | 5.0175 | 8.5088 | 309 | 8206 | 3406 | 20 | 2305 | 14 | |||||
TUR | Turkey | HDP | Peoples' Democratic Party | Halkların Demokratik Partisi | Halklarin Demokratik Partisi | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 20 | 2572 | 14 |
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;