view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
201 rows where family_name = "Social democracy" sorted by cmp
This data as json, CSV (advanced)
Suggested facets: castles_mair
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||
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 | ||||||||
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 | 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 | ||||||||
BGR | Bulgaria | IS | Stand up! | Izpravi se! | Izpravi se! | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2838 | 11 | ||||||||
BGR | Bulgaria | KR | Coalition of the Rose | Koalitsiya na Rozata | Koalitsiya na Rozata | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2179 | 11 | ||||||||
BGR | Bulgaria | PBSD | Party of Bulgarian Social Democrats | Partiya Balgarski Sotsialdemokrati | Partiya Balgarski Sotsialdemokrati | soc | Social democracy | 3.7778 | 4.6316 | 3.4211 | 9.0 | 703 | 815 | 10 | 1161 | 11 | ||||||
BGR | Bulgaria | SDS-ts | Union of Democratic Forces -- Centre | Suyuz na Demokratichnite Sili – Tsentur | Suyuz na Demokratichnite Sili -- Tsentur | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2174 | 11 | ||||||||
CAN | Canada | L | Labour Party | Labour Party | Labour Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 29 | 2427 | 11 | |||||||||
CAN | Canada | NPC | National Party of Canada | National Party of Canada | National Party of Canada | soc | Social democracy | 3.3 | 3.5 | 3.5 | 29 | 2142 | 11 | |||||||||
CHE | Switzerland | DG | Democratic Group | Gruppe der Demokraten – Groupe des democrates | Gruppe der Demokraten -- Groupe des democrates | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 40 | 886 | 11 | ||||||||
CHE | Switzerland | GV | Grutli Society | Grütliverein – Grutléen | Gruetli Society -- Grutleen | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 40 | 1951 | 11 | ||||||||
CYP | Cyprus | SYM | Citizen's Alliance | Symmaxia | Symmaxia | soc | Social democracy | 3.3 | 3.5 | 3.5 | 51 | 2341 | 11 | |||||||||
CYP | Cyprus | YH | Jasmine Movement | Yasemin Hareketi | Yasemin Hareketi | soc | Social democracy | 3.3 | 3.5 | 3.5 | 51 | 2784 | 11 | |||||||||
CZE | Czech Republic | HSS | Movement for Social Justice | Hnutí za sociální spravedlnost | Hnuti za socialni spravedlnost | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 68 | 2223 | 11 | ||||||||
CZE | Czech Republic | SPOZ | Party of Civic Rights -- Zemanovci | Strana práv občanů – Zemanovci | Strana prav obcanu -- Zemanovci | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 68 | 406 | 11 | ||||||||
DNK | Denmark | Jf | Social Democratic Party (Faroe Islands) | Javnaðarflokkurin | Javnadarflokkurin | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 21 | 1894 | 11 | ||||||||
DNK | Denmark | Si | Forward (Greenland) | Siumut | Siumut | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 21 | 74 | 11 | ||||||||
FIN | Finland | SKrTL | Christian Workers' Union of Finland | Suomen Kristillisen Työväen Liitto – Finlands kristliga arbetarförbund | Suomen Kristillisen Tyovaen Liitto -- Finlands kristliga arbetarforbund | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 67 | 2433 | 11 | ||||||||
FRA | France | CeG | Centre Left | Centre-gauche | Centre-gauche | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 43 | 2251 | 11 | ||||||||
FRA | France | Gs | Generation.s, the movement | Génération.s, le mouvement | Generation.s, le mouvement | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 43 | 2732 | 11 | ||||||||
FRA | France | PRG | Radical Party of the Left | Parti radical de gauche | Parti radical de gauche | soc | Social democracy | 4.0813 | 4.1676 | 4.2381 | 7.9361 | 106 | 1250337 | 1407 | 603 | 603 | 43 | 1492 | 11 | |||
FRA | France | PSF | French Socialist Party | Parti socialiste français | Parti socialiste francais | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 43 | 2617 | 11 | ||||||||
FRA | France | PSdF | Socialist Party of France -- Jean Jaures Union | Parti socialiste de France – Union Jean Jaurès | Parti socialiste de France -- Union Jean Jaures | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 43 | 2618 | 11 | ||||||||
FRA | France | RS | Republican Socialist Party | Parti républicain socialiste | Parti Republicain Socialist | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 43 | 2594 | 11 | ||||||||
FRA | France | TPA | Three Parties Alliance -- Third Force | Tripartisme – Troisième force | Tripartisme -- Troisieme force | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 43 | 2279 | 11 | ||||||||
FRA | France | UDSR | Democratic and Socialist Union of the Resistance | Union démocratique et socialiste de la Résistance | Union democratique et socialiste de la Resistance | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 43 | 2280 | 11 | ||||||||
FRA | France | UFD | Union of Democratic Forces | Union des forces démocratiques | Union des forces democratiques | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 43 | 2269 | 11 | ||||||||
FRA | France | d-gauche | other left | divers gauche | divers gauche | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 43 | 177 | 11 | ||||||||
GBR | United Kingdom | CoLab | Coalition Labour | Coalition Labour | Coalition Labour | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 44 | 2508 | 11 | ||||||||
GBR | United Kingdom | N | Nationalist Party | Nationalist Party | Nationalist Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 44 | 332 | 11 | ||||||||
GBR | United Kingdom | NLO | National Labour Organisation | National Labour Organisation | National Labour Organisation | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 44 | 2479 | 11 | ||||||||
GBR | United Kingdom | SDLP | Social Democratic and Labour Party | Social Democratic and Labour Party | Social Democratic and Labour Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.6667 | 1103 | 44 | 1023 | 11 | |||||||
GRC | Greece | DIMAR | Democratic Left | Dimokratiki Aristera | Dimokratiki Aristera | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 41 | 2093 | 11 | ||||||||
GRC | Greece | EK | Union of Centrists | Enosi Kentroon | Enosi Kentroon | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 41 | 2165 | 11 | ||||||||
GRC | Greece | KDS | Party of Democratic Socialism | Komma Dimokratikou Socialismou | Komma Dimokratikou Socialismou | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 41 | 252 | 11 | ||||||||
GRC | Greece | KIDISO | Movement of Democratic Socialists | Kinima Dimokraton Sosialiston | Kinima Dimokraton Sosialiston | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 41 | 2407 | 11 | ||||||||
GRC | Greece | TP | The River | To Potami | To Potami | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 41 | 2346 | 11 | ||||||||
GRC | Greece | Tel | Dot -- Apostolos Gkletsos | Teleia – Apostolos Gkletsos | Teleia -- Apostolos Gkletsos | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 41 | 2408 | 11 | ||||||||
HRV | Croatia | MB | Milan Bandic 365 -- The Party of Labour and Solidarity | Milan Bandić 365 – Stranka rada i solidarnosti | Milan Bandic 365 -- Stranka rada i solidarnosti | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 62 | 2628 | 11 | ||||||||
HRV | Croatia | SDSS | Independent Democratic Serb Party | Samostalna demokratska srpska stranka | Samostalna demokratska srpska stranka | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 3110 | 62 | 2133 | 11 | |||||||
HUN | Hungary | DK | Democratic Coalition | Demokratikus Koalíció | Demokratikus Koalicio | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 39 | 1970 | 11 | ||||||||
HUN | Hungary | Egyutt | Together -- Party for a New Era | Együtt – A Korszakváltók Pártja | Egyutt -- A Korszakvaltok Partja | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 39 | 2318 | 11 | ||||||||
IRL | Ireland | DS | Social Democrats | Daonlathaigh Shóisialta | Daonlathaigh Shoisialta | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 37 | 2619 | 11 | ||||||||
IRL | Ireland | DSP | Democratic Socialist Party | Democratic Socialist Party | Democratic Socialist Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 5.0 | 708 | 37 | 379 | 11 | |||||||
IRL | Ireland | I-NC | Independent -- Nessa Childers | Independent – Nessa Childers | Independent -- Nessa Childers | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 37 | 2370 | 11 | ||||||||
IRL | Ireland | NL | National Labour Party | National Labour Party | National Labour Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 37 | 156 | 11 | ||||||||
ISL | Iceland | MJ | Debating Society of Social Democrats | Málfundafélag jafnaðarmanna | Malfundafelag jafnadarmanna | soc | Social democracy | 3.3 | 3.5 | 3.5 | 56 | 2314 | 11 | |||||||||
ISR | Israel | Haatz | Sia'at Ha'Atzma'ut | Sia'at Ha'Atzma'ut | Independence | soc | Social democracy | 3.3 | 3.5 | 3.5 | 34 | 2043 | 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 | |||||||||
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 | 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 | 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 | |||||||
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 | RWSP | Right Wing Socialist Party | Uha Shakai Tô | Uha Shakai To | soc | Social democracy | 3.3 | 3.5 | 3.5 | 5 | 1724 | 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 | ||||||||
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 | P | The Progressive | Progresīvie | Progresivie | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 55 | 2716 | 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 | |||||||||
NLD | Netherlands | DENK | Think | Beweging DENK | Beweging DENK | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 8 | 2641 | 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 | 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 | 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 | 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 | 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 | WIO | Spring | Wiosna | Wiosna | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 74 | 2740 | 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 | ||||||||
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 | 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 | |||||||
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 | 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 |
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;