view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
201 rows where family_name = "Social democracy"
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 | Mapam | United Workers Party | Mifleget HaPoalim HaMeuhedet | Mifleget HaPoalim HaMeuhedet | soc | Social democracy | 3.3 | 3.5 | 3.5 | 72311 | 34 | 1168 | 11 | ||||||||
ISR | Israel | Ma|Av | Alignment | Labor | HaMa'arakh | HaAvoda | HaMa'arakh | HaAvoda | soc | Social democracy | 3.3 | 3.5 | 3.5 | 72320 | 34 | 244 | 11 | ||||||||
ISR | Israel | Meimad | Meimad | Medina Yehudit Medina Demokratit | Medina Yehudit Medina Demokratit | soc | Social democracy | 3.3 | 3.5 | 3.5 | 34 | 1867 | 11 | |||||||||
ISR | Israel | Meretz | Energy | Meretz | Meretz | soc | Social democracy | 1.7786 | 3.2632 | 0.6667 | 72326 | 6505 | 34 | 1419 | 11 | |||||||
ISR | Israel | Rafi | Israeli Workers List | Reshimat Poalei Yisrael | Reshimat Poalei Yisrael | soc | Social democracy | 3.3 | 3.5 | 3.5 | 72322 | 34 | 767 | 11 | ||||||||
ISR | Israel | Ratz | Movement for Civil Rights and Peace | Hatnuah Lezhiot Ha'ezrach | Hatnuah Lezhiot Ha'ezrach | soc | Social democracy | 3.3 | 3.5 | 3.5 | 72310 | 34 | 305 | 11 | ||||||||
ITA | Italy | CeS | Centre Left | Centro-sinistra | Centro-sinistra | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 32329 | 837 | 26 | 1048 | 11 | ||||||
ITA | Italy | DINI-RI | Dini List -- Italian Renewal | Lista Dini – Rinnovamento Italiano | Lista Dini -- Rinnovamento Italiano | soc | Social democracy | 5.0317 | 5.9683 | 5.515 | 8.6833 | 32321 | 825 | 26 | 630 | 11 | ||||||
ITA | Italy | DS | Democrats of the Left | Democratici di Sinistra | Democratici di Sinistra | soc | Social democracy | 2.6277 | 3.1839 | 2.5869 | 9.069 | 32220 | 2102 | 802 | 6626 | 802 | 26 | 809 | 11 | |||
ITA | Italy | LT | List for Trieste | Lista per Trieste | Lista per Trieste | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 26 | 55 | 11 | ||||||||
ITA | Italy | LUP | The Union-Prodi | L'Unione-Prodi | L'Unione-Prodi | soc | Social democracy | 2.6216 | 2.9825 | 2.0943 | 7.834 | 32329 | 6626 | 26 | 1246 | 11 | ||||||
ITA | Italy | NPSI | New PSI | Nuovo Partito Socialisti Italiani | Nuovo Partito Socialisti Italiani | soc | Social democracy | 5.43 | 5.67 | 3.57 | 7.2167 | 32611 | 835 | 26 | 1287 | 11 | ||||||
ITA | Italy | PD | Democratic Party | Partito Democratico | Partito Democratico | soc | Social democracy | 2.6216 | 2.9825 | 2.0943 | 7.834 | 180 | 1380331 | 6626 | 837 | 26 | 382 | 11 | ||||
ITA | Italy | PSA | Sardinian Action Party | Partito Sardo d'Azione | Partito Sardo d'Azione | soc | Social democracy | 4.2 | 3.6667 | 6.25 | 7.0833 | 824 | 26 | 335 | 11 | |||||||
ITA | Italy | PSDI | Italian Democratic Socialist Party | Partito Socialista Democratico Italiano | Partito Socialista Democratico Italiano | soc | Social democracy | 4.6206 | 3.915 | 2.99 | 8.8222 | 32330 | 1007 | 2105 | 807 | 807 | 26 | 242 | 11 | |||
ITA | Italy | PSI | Italian Socialist Party | Partito Socialista Italiano | Partito Socialista Italiano | soc | Social democracy | 3.7722 | 3.5 | 3.5 | 8.75 | 32320 | 1005 | 2104 | 804 | 839 | 26 | 1475 | 11 | |||
ITA | Italy | P|SDI | Italian Democratic Socialists | Party | Partito | Socialisti Democratici Italiani | Partito | Socialisti Democratici Italiani | soc | Social democracy | 3.9895 | 4.3906 | 3.208 | 7.0658 | 6826 | 26 | 1278 | 11 | |||||||
ITA | Italy | R | Radicals | Radicali | Radicali | soc | Social democracy | 3.9732 | 7.0784 | 0.3338 | 8.2722 | 32310 | 1004 | 814 | 6786 | 813 | 26 | 1296 | 11 | |||
JPN | Japan | CDP | Constitutional Democratic Party of Japan | Rikken Minshutō | Rikken Minshuto | soc | Social democracy | 3.3 | 3.5 | 3.5 | 5 | 2657 | 11 | |||||||||
JPN | Japan | CoP | Cooperative Party | Kyoudoutou | Kyoudoutou | soc | Social democracy | 3.3 | 3.5 | 3.5 | 5 | 1738 | 11 | |||||||||
JPN | Japan | DRP | Democratic Reform Party | Min-kai-ren | Min-kai-ren | soc | Social democracy | 3.3 | 3.5 | 3.5 | 5 | 163 | 11 | |||||||||
JPN | Japan | DSP | Democratic Socialist Party | Minshu Shakai-tō | Minshu Shakai-to | soc | Social democracy | 6.1556 | 3.5 | 3.5 | 71321 | 2204 | 5 | 1053 | 11 | |||||||
JPN | Japan | JSP | Japan Socialist Party | Nihon Shakai-tō | Nihon Shakai-to | soc | Social democracy | 2.6344 | 4.1367 | 3.121 | 71320 | 2202 | 8472 | 5 | 940 | 11 | ||||||
JPN | Japan | RWSP | Right Wing Socialist Party | Uha Shakai Tô | Uha Shakai To | soc | Social democracy | 3.3 | 3.5 | 3.5 | 5 | 1724 | 11 | |||||||||
JPN | Japan | SDF | Socialist Democratic Federation | Shaminren | Shaminren | soc | Social democracy | 3.3 | 3.5 | 3.5 | 71322 | 5 | 86 | 11 | ||||||||
LTU | Lithuania | LDDP | Democratic Labour Party of Lithuania | Lietuvos demokratinė darbo partija | Lietuvos demokratine darbo partija | soc | Social democracy | 3.3333 | 3.5 | 3.5 | 8.1 | 88220 | 2401 | 15 | 519 | 11 | ||||||
LTU | Lithuania | LMP-NDP | Lithuanian Womens Party -- New Democratic Party | Lietuvos moterų partija – Naujosios demokratijos partija | Lietuvos moteru partija -- Naujosios demokratijos partija | soc | Social democracy | 3.2 | 3.75 | 6.25 | 7.0 | 2502 | 15 | 1261 | 11 | |||||||
LTU | Lithuania | LSDDP | Social Democratic Labour Party of Lithuania | Lietuvos socialdemokratų darbo partija | Lietuvos socialdemokratu darbo partija | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 15 | 2763 | 11 | ||||||||
LTU | Lithuania | LSDP | Lithuanian Social Democratic Party | Lietuvos socialdemokratų partija | Lietuvos socialdemokratu partija | soc | Social democracy | 3.1972 | 3.8262 | 5.2732 | 9.0702 | 88320 | 203 | 1440320 | 2320 | 2501 | 15 | 1277 | 11 | |||
LTU | Lithuania | LSDP-89 | Lithuanian Social Democratic Party -- 1989 | Lietuvos socialdemokratų partija – 1989 | Lietuvos socialdemokratu partija -- 1989 | soc | Social democracy | 4.0 | 3.5 | 3.5 | 8.1 | 88320 | 2402 | 15 | 1408 | 11 | ||||||
LUX | Luxembourg | LSAP | Luxembourg Socialist Workers' Party | Lëtzebuerger Sozialistesch Aarbechterpartei | Letzebuerger Sozialistesch Aarbechterpartei | soc | Social democracy | 3.2895 | 3.9474 | 1.3158 | 23320 | 211 | 1442320 | 902 | 6966 | 7 | 701 | 11 | ||||
LUX | Luxembourg | SDP | Social Democratic Party | Sozialdemokratesch Partei | Sozialdemokratesch Partei | soc | Social democracy | 3.3 | 3.5 | 3.5 | 7 | 1134 | 11 | |||||||||
LUX | Luxembourg | SI | Jean Gremling List -- Independent Socialists | Jean Gremling List – Socialistes Indépendants | Jean Gremling List -- Socialistes Independants | soc | Social democracy | 3.3 | 3.5 | 3.5 | 7 | 1339 | 11 | |||||||||
LVA | Latvia | L | Equal Rights | Līdztiesība | Lidztiesiba | soc | Social democracy | 1.25 | 2.1093 | 5.5837 | 4.8684 | 87951 | 2106 | 2402 | 55 | 928 | 11 | |||||
LVA | Latvia | LSDSP | Latvian Social Democratic Workers' Party | Latvijas Sociāldemokrātiskā Strādnieku Partija | Latvijas Socialdemokratu Stradnieku Partija | soc | Social democracy | 2.5 | 2.625 | 6.835 | 6.875 | 87311 | 2408 | 55 | 1656 | 11 | ||||||
LVA | Latvia | P | The Progressive | Progresīvie | Progresivie | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 55 | 2716 | 11 | ||||||||
LVA | Latvia | PCTVL | For Human Rights in a United Latvia | Par cilvēka tiesībām vienotā Latvijā | Par cilveka tiesibam vienota Latvija | soc | Social democracy | 1.25 | 2.1093 | 5.5837 | 4.8684 | 87422 | 192 | 1428422 | 2106 | 2402 | 55 | 1520 | 11 | |||
LVA | Latvia | PPA | Political Party "Alternative" | Politiskā Partija "Alternative" | Politiska Partija "Alternative" | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 55 | 2393 | 11 | ||||||||
LVA | Latvia | R | Republic | Republika | Republika | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 55 | 2877 | 11 | ||||||||
LVA | Latvia | S | Harmony | Saskaņas | Saskanas | soc | Social democracy | 3.0 | 3.25 | 4.25 | 7.5 | 195 | 1428317 | 2410 | 55 | 1100 | 11 | |||||
LVA | Latvia | SDLP | Social Democratic Welfare Party | Sociāldemokrātiskā Labklājības partija | Socialdemokratiska Labklajibas partija | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 55 | 257 | 11 | ||||||||
LVA | Latvia | SDP | Social Democratic Party | Sociāldemokrātiskā partija | Socialdemokratiska partija | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 55 | 1608 | 11 | ||||||||
MLT | Malta | MWP | Malta Workers' Party | Malta Workers' Party | Malta Workers' Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 72 | 1274 | 11 | |||||||||
MLT | Malta | PDN | Democratic Nationalist Party | Partit Democratiku Nazzjonalista | Partit Democratiku Nazzjonalista | soc | Social democracy | 3.3 | 3.5 | 3.5 | 72 | 393 | 11 | |||||||||
MLT | Malta | PHN | Christian Workers' Party | Partit Haddiema Nsara | Partit Haddiema Nsara | soc | Social democracy | 3.3 | 3.5 | 3.5 | 72 | 1225 | 11 | |||||||||
MLT | Malta | PL | Malta Labour Party | Partit Laburista | Partit Laburista | soc | Social democracy | 4.2105 | 5.1128 | 6.3158 | 54320 | 226 | 1470300 | 7004 | 72 | 1003 | 11 | |||||
NLD | Netherlands | DENK | Think | Beweging DENK | Beweging DENK | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 8 | 2641 | 11 | ||||||||
NLD | Netherlands | PvdA | Labour Party | Partij van de Arbeid | Partij van de Arbeid | soc | Social democracy | 3.6118 | 3.868 | 3.2028 | 7.9904 | 22320 | 299 | 1528320 | 1104 | 2602 | 1002 | 7140 | 1002 | 8 | 742 | 11 |
NLD | Netherlands | SDAP | Social Democratic Workers' Party | Sociaal Democratische Arbeiders Partij | Sociaal Democratische Arbeiders Partij | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 8 | 1451 | 11 | ||||||||
NOR | Norway | DNA | Norwegian Labour Party | Det norske Arbeiderparti | Det norske Arbeiderparti | soc | Social democracy | 3.3706 | 2.9574 | 2.7105 | 8.2933 | 12320 | 1302 | 2903 | 1503 | 7488 | 3501 | 9 | 104 | 11 | ||
NOR | Norway | NSA | Social Democratic Labour Party of Norway | Norges Socialdemokratiske Arbeiderparti | Norges Socialdemokratiske Arbeiderparti | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 9 | 2474 | 11 | ||||||||
NZL | New Zealand | A | Alliance | Alliance | Alliance | soc | Social democracy | 2.0757 | 1.1111 | 3.5 | 64321 | 2702 | 7236 | 11 | 1444 | 11 | ||||||
NZL | New Zealand | LP | Labour Party | Labour Party | Labour Party | soc | Social democracy | 4.483 | 3.9889 | 3.5 | 64320 | 1201 | 2703 | 7300 | 11 | 878 | 11 | |||||
NZL | New Zealand | NLP | New Labour Party | New Labour Party | New Labour Party | soc | Social democracy | 2.7778 | 3.5 | 3.5 | 2701 | 11 | 930 | 11 | ||||||||
NZL | New Zealand | PP | Progressive Party | Progressive Party | Progressive Party | soc | Social democracy | 3.0194 | 2.6316 | 3.5 | 64422 | 7316 | 11 | 354 | 11 | |||||||
NZL | New Zealand | SDP | Social Democratic Party | Social Democratic Party | Social Democratic Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 11 | 2549 | 11 | |||||||||
POL | Poland | LR | Left Together | Lewica Razem | Lewica Razem | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 74 | 2790 | 11 | ||||||||
POL | Poland | LiD | Left and Democrats | Lewica i Demokraci | Lewica i Demokraci | soc | Social democracy | 2.6486 | 2.6316 | 2.1902 | 9.1283 | 3102 | 74 | 180 | 11 | |||||||
POL | Poland | Razem | Together Party | Partia Razem | Partia Razem | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 74 | 2625 | 11 | ||||||||
POL | Poland | S | Solidarnosc | Solidarność | Solidarnosc | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 92320 | 74 | 108 | 11 | |||||||
POL | Poland | SDPL | Social Democracy of Poland | Socjaldemokracja Polska | Socjaldemokracja Polska | soc | Social democracy | 3.0 | 4.67 | 1.43 | 8.5667 | 2611 | 74 | 1140 | 11 | |||||||
POL | Poland | SLD | Democratic Left Alliance | Sojusz Lewicy Demokratycznej | Sojusz Lewicy Demokratycznej | soc | Social democracy | 2.8299 | 3.8505 | 1.8801 | 9.0872 | 92210 | 231 | 1616210 | 3001 | 3102 | 2601 | 74 | 629 | 11 | ||
POL | Poland | SoPr | Labour Solidarity | Solidarność Pracy | Solidarnosc Pracy | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 92321 | 74 | 18 | 11 | |||||||
POL | Poland | UP | Labour Union | Unia Pracy | Unia Pracy | soc | Social democracy | 2.0348 | 1.8898 | 1.3726 | 8.7816 | 92322 | 3128 | 2602 | 74 | 838 | 11 | |||||
POL | Poland | WIO | Spring | Wiosna | Wiosna | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 74 | 2740 | 11 | ||||||||
PRT | Portugal | ASDI | Independent Social Democrats | Associação Social Democrata Independente | Associacao Social Democrata Independente | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 35316 | 63 | 622 | 11 | |||||||
PRT | Portugal | ID | Democratic Intervention | Intervençao Democrática | Intervencao Democratica | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 35315 | 63 | 889 | 11 | |||||||
PRT | Portugal | L | Livre | Livre – Liberdade, Esquerda, Europa e Ecologia | Livre -- Liberdade, Esquerda, Europa e Ecologia | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 63 | 2374 | 11 | ||||||||
PRT | Portugal | MDP | Democratic Movement | Movimento Democrático Português | Movimento Democratico Portugues | soc | Social democracy | 3.3 | 3.5 | 3.5 | 2.5 | 35310 | 1212 | 63 | 1281 | 11 | ||||||
PRT | Portugal | PRD | Democratic Renewal Party | Partido Renovador Democrático | Partido Renovador Democratico | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.3333 | 35312 | 1204 | 63 | 341 | 11 | ||||||
PRT | Portugal | PS | Socialist Party | Partido Socialista | Partido Socialista | soc | Social democracy | 4.0492 | 4.2716 | 3.5411 | 9.2233 | 35311 | 246 | 1620311 | 3102 | 1205 | 7704 | 1205 | 63 | 725 | 11 | |
PRT | Portugal | UEDS | Leftwing Union for the Socialist Democracy | União da Esquerda para a Democracia Socialista | Uniao de Esquerda para a Democracia Socialista | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 35317 | 63 | 565 | 11 | |||||||
ROU | Romania | ApR | Alliance for Romania | Alianta pentru Romania | Alianta pentru Romania | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 23 | 2040 | 11 | ||||||||
ROU | Romania | PSD | Social Democratic Party | Partidul Social Democrat | Partidul Social Democrat | soc | Social democracy | 3.2325 | 2.4518 | 6.2794 | 8.6459 | 93221 | 252 | 1642300 | 3202 | 3330 | 2701 | 23 | 1120 | 11 | ||
ROU | Romania | PSDR | Romanian Social Democratic Party | Partidul Social Democrat Român | Partidul Social Democrat Roman | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 93320 | 23 | 1601 | 11 | |||||||
ROU | Romania | PaRo | Party of the Roma | Partida Romilor | Partida Romilor | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 23 | 254 | 11 | ||||||||
ROU | Romania | UNPR | National Union for the Progress of Romania | Uniunea Naţională pentru Progresul României | Uniunea Nationala pentru Progresul Romaniei | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 23 | 2002 | 11 | ||||||||
SVK | Slovakia | DV | Good Choice | Dobrá voľba | Dobra volba | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 1 | 2797 | 11 | ||||||||
SVK | Slovakia | SDA | Social Democratic Alternative | Sociálnodemokratická alternatíva | Socialnodemokraticka alternativa | soc | Social democracy | 3.0526 | 2.5965 | 1.7544 | 8.1754 | 4027 | 1 | 64 | 11 | |||||||
SVK | Slovakia | SDL-05 | Party of the Democratic Left -- 2005 | Strana demokratickej ľavice – 2005 | Strana demokratickej lavice -- 2005 | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 1 | 2317 | 11 | ||||||||
SVK | Slovakia | SDSS | Social Democratic Party of Slovakia | Sociálnodemokratická strana Slovenska | Socialnodemokraticka strana Slovenska | soc | Social democracy | 4.8111 | 3.5 | 3.5 | 8.1 | 3404 | 1 | 1651 | 11 | |||||||
SVK | Slovakia | SOP | Party of Civic Understanding | Strana občianskeho porozumenia | Strana obcianskeho porozumenia | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 96422 | 1 | 1016 | 11 | |||||||
SVK | Slovakia | Smer | Direction -- Social Democracy | Smer – sociálna demokracia | Smer -- socialna demokracia | soc | Social democracy | 3.3799 | 3.5124 | 3.6548 | 7.1697 | 96423 | 258 | 1703423 | 4157 | 2803 | 1 | 220 | 11 | |||
SVN | Slovenia | DD | Good Country | Dobra Drzava | Dobra Drzava | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2669 | 11 | ||||||||
SVN | Slovenia | DS | Democratic Party | Demokratska stranka | Demokratska stranka | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 97430 | 60 | 143 | 11 | |||||||
SVN | Slovenia | GS | Freedom Movement | Gibanje Svoboda | Gibanje Svoboda | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2856 | 11 | ||||||||
SVN | Slovenia | LMS | List of Marjan Sarec | Lista Marjana Šarca | Lista Marjana Sarca | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2668 | 11 | ||||||||
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 | ||||||||
SVN | Slovenia | S | Solidarity | Solidarnost | Solidarnost | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2386 | 11 | ||||||||
SVN | Slovenia | SMC | Modern Center Party | Stranka modernega | Stranka modernega | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2333 | 11 | ||||||||
SVN | Slovenia | TRS | Party for Sustainable Development of Slovenia | Stranka za trajnostni razvoj Slovenije | Stranka za trajnostni razvoj Slovenije | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 1989 | 11 | ||||||||
SVN | Slovenia | V | I Believe | Verjamem | Verjamem | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2384 | 11 | ||||||||
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 | ||||||||
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 | 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 | |||||
SWE | Sweden | SAP | Social Democrats | Socialdemokraterna | Socialdemokraterna | soc | Social democracy | 3.4447 | 3.5655 | 4.4407 | 7.4445 | 11320 | 277 | 1752320 | 1502 | 3702 | 1602 | 7940 | 1602 | 35 | 904 | 11 |
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 | ||||||||
TUR | Turkey | DSP | Democratic Left Party | Demokratik Sol Parti | Demokratik Sol Parti | soc | Social democracy | 3.8377 | 2.8138 | 5.2851 | 5.7263 | 74324 | 310 | 4005 | 8228 | 20 | 329 | 11 | ||||
TUR | Turkey | SHP|CHP | Social Democratic Populist Party | Republican People's Party | Sosyal Demokrat Halçi Parti | Cumhuriyet Halk Partisi | Sosyal Demokrat Halci Parti | Cumhuriyet Halk Partisi | soc | Social democracy | 3.2661 | 2.8138 | 4.6154 | 7.3887 | 74321 | 307 | 4004 | 8184 | 3402 | 20 | 507 | 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;