view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
201 rows where family_name = "Social democracy" sorted by ray
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 | ||||||
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 | ||||||||
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 | KzB|DL | Coalition for Bulgaria | Democratic Left | Koalitsiya za Balgariya | Demokratichna Levitsa | Koalitsiya za Balgariya | Demokratichna Levitsa | soc | Social democracy | 2.8982 | 2.9629 | 5.741 | 8.6402 | 80221 | 1100300 | 702 | 841 | 2003 | 10 | 1160 | 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 | CSSD | Czech Social Democratic Party | Česká strana sociálně demokratická | Ceska strana socialne demokraticka | soc | Social democracy | 3.0463 | 3.0031 | 4.2463 | 8.5647 | 82320 | 55 | 1203320 | 1002 | 1328 | 2101 | 68 | 789 | 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 | EK | Estonian Centre Party | Eesti Keskerakond | Eesti Keskerakond | soc | Social democracy | 3.9562 | 3.6421 | 4.9947 | 5.0118 | 83411 | 75 | 1233411 | 1204 | 1716 | 2202 | 75 | 1137 | 11 | ||
EST | Estonia | K-EUR | Constitution Party -- Estonian United People's Party | Konstitutsioonierakond – Eestimaa Ühendatud Rahvapartei | Konstitutsioonierakond -- Eestimaa Uehendatud Rahvapartei | soc | Social democracy | 2.0282 | 2.9413 | 6.3158 | 4.9241 | 83952 | 1201 | 1664 | 2205 | 75 | 1590 | 11 | ||||
EST | Estonia | R | Popular Front | Rahvarinne | Rahvarinne | soc | Social democracy | 3.3333 | 3.5 | 3.5 | 8.1 | 83421 | 1204 | 75 | 450 | 11 | ||||||
EST | Estonia | SDE|M | Social Democratic Party | Moderates | Sotsiaaldemokraatlik Erakond | Mõõdukad | Sotsiaaldemokraatlik Erakond | Moodukad | soc | Social democracy | 4.1915 | 3.4667 | 3.1737 | 7.7982 | 83410 | 83 | 1233410 | 1205 | 1742 | 2204 | 75 | 1448 | 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 | 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 | ||||||||
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 | |||||||
HRV | Croatia | SPH | Social Democratic Party of Croatia | Socijaldemokratska partija Hrvatske | Socijaldemokratska partija Hrvatske | soc | Social democracy | 3.2456 | 5.5263 | 2.3684 | 8.7719 | 81223 | 1302 | 3102 | 62 | 1493 | 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 | ||||||||
HUN | Hungary | MSZP | Hungarian Socialist Party | Magyar Szocialista Párt | Magyar Szocialista Part | soc | Social democracy | 2.8743 | 5.5702 | 3.5897 | 9.6567 | 86220 | 162 | 1348220 | 1601 | 1976 | 2301 | 39 | 1591 | 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 | 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 | 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 | 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 | 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 |
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;