view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
201 rows where family_name = "Social democracy" sorted by chess
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 | 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 | ||||||||
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 | RW | Walloon Rally | Rassemblement Wallon | Rassemblement Wallon | soc | Social democracy | 2.6 | 3.5 | 3.5 | 8.1 | 21911 | 303 | 64 | 460 | 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 | ||||||||
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 | BQ | Quebec Bloc | Bloc Québécois | Bloc Quebecois | soc | Social democracy | 3.0215 | 3.1207 | 2.2063 | 62901 | 802 | 5213 | 29 | 448 | 11 | ||||||
CAN | Canada | CCF|NDP | Co-operative Commonwealth Federation | New Democratic Party | Co-operative Commonwealth Federation | New Democratic Party | Co-operative Commonwealth Federation | New Democratic Party | soc | Social democracy | 2.46 | 1.9195 | 1.1134 | 62320 | 401 | 801 | 5293 | 29 | 296 | 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 | ||||||||
CHE | Switzerland | LdU-ADI | Independents Alliance | Landesring der Unabhängigen – Alliance des Indépendants | Landesring der Unabhaengigen -- Alliance des Independants | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 43321 | 40 | 1264 | 11 | |||||||
CYP | Cyprus | EDEK | Movement for Social Democracy EDEK | Kinima Sosialdimokraton EDEK | Kinima Sosialdimokraton EDEK | soc | Social democracy | 3.2895 | 4.7368 | 5.9211 | 55323 | 54 | 1196322 | 5405 | 51 | 945 | 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 | DZJ | Pensioners for a Secure Living | Důchodci za životní jistoty | Duchodci za zivotni jistoty | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 82901 | 68 | 77 | 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 | ||||||||
EST | Estonia | R | Popular Front | Rahvarinne | Rahvarinne | soc | Social democracy | 3.3333 | 3.5 | 3.5 | 8.1 | 83421 | 1204 | 75 | 450 | 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 | ||||||||
FIN | Finland | TPSL | Social Democratic League of Workers and Smallholders | Tyäväen ja Pienviljelijäin Sosialdemokraattinen Liitto – Arbetarnas och Småbrukarnas Socialdemokratiska Förbund | Tyavaen ja Pienviljelijain Sosialdemokraattinen Liitto -- Arbetarnas och Smabrukarnas Socialdemokratiska Forbund | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 14310 | 67 | 1108 | 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 | 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 | |||||||
GBR | United Kingdom | SDP | Social Democratic Party | Social Democratic Party | Social Democratic Party | soc | Social democracy | 4.6 | 3.5 | 3.5 | 8.1 | 51330 | 1604 | 44 | 1547 | 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 | ||||||||
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 | A | Social Democratic Party | Alþýðuflokkurinn | Althyduflokkurinn | soc | Social democracy | 4.4444 | 3.5 | 3.5 | 15320 | 1704 | 56 | 228 | 11 | |||||||
ISL | Iceland | BJ | Alliance of Social Democrats | Bandalag jafnaðarmanna | Bandalag jafnadarmanna | soc | Social democracy | 3.3 | 3.5 | 3.5 | 15321 | 56 | 988 | 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 | |||||||||
ISL | Iceland | Sam | Social Democratic Alliance | Samfylkingin | Samfylkingin | soc | Social democracy | 4.0789 | 4.2982 | 1.0088 | 15328 | 6259 | 56 | 1006 | 11 | |||||||
ISL | Iceland | Th-Ff | People's Movement | Þjóðvaki – Fylking fólksins | Thjodvaki -- Fylking folksins | soc | Social democracy | 3.3 | 3.5 | 3.5 | 15323 | 56 | 205 | 11 | ||||||||
ISR | Israel | AE | One Nation | Am Ehad | Am Ehad | soc | Social democracy | 2.9825 | 1.7053 | 4.349 | 72312 | 6407 | 34 | 615 | 11 | |||||||
ISR | Israel | AhAv | Labour Unity | Ahdut HaAvoda | Ahdut HaAvoda | soc | Social democracy | 3.3 | 3.5 | 3.5 | 72325 | 34 | 1343 | 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 | 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 | 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 | 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 | 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 | 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-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 | 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 |
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;