view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by party_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HUN | Hungary | HVK | Patriotic Elections Coalition | Hazafias Választási Koalíció | Hazafias Valasztasi Koalicio | code | to be coded | 39 | 198 | 28 | ||||||||||||
SVN | Slovenia | Ita | Italian national community | Italijanska narodna skupnost | Italijanska narodna skupnost | spec | Special issue | 60 | 199 | 16 | ||||||||||||
FIN | Finland | SP|P | Finnish Party | True Finns | Suomen Puolue | Perussuomalaiset | Suomen Puolue | Perussuomalaiset | agr | Agrarian | 6.6331 | 4.8745 | 7.999 | 1.0945 | 14820 | 89 | 1246820 | 605 | 1307 | 1405 | 5717 | 1405 | 67 | 200 | 2 |
LUX | Luxembourg | Z-EF | Coerced Conscripts | Zwangsrekrutéierten | Zwangsrekruteierten | spec | Special issue | 7 | 202 | 16 | ||||||||||||
LVA | Latvia | TB | For Fatherland and Freedom | Tēvzemei un Brīvībai | Tevzemei un Brivibai | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 87721 | 55 | 203 | 40 | |||||||
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 | ||||||||
POL | Poland | SRP | Self-Defense of the Republic Poland | Samoobrona Rzeczypospolitej Polskiej | Samoobrona Rzeczypospolitej Polskiej | agr | Agrarian | 3.997 | 2.008 | 7.3253 | 2.1473 | 92622 | 384 | 3076 | 2604 | 74 | 207 | 2 | ||||
NLD | Netherlands | CD | Centre Democrats | Centrum Democraten | Centrum Democraten | right | Right-wing | 9.4097 | 8.5714 | 9.25 | 1.312 | 2609 | 1009 | 1009 | 8 | 209 | 40 | |||||
ISL | Iceland | Graen | Left-Green Movement | Vinstrihreyfingin – grænt framboð | Vinstrihreyfingin -- graent frambod | eco | Green/Ecologist | 1.1842 | 1.4474 | 1.6667 | 15111 | 6273 | 56 | 210 | 19 | |||||||
DNK | Denmark | RV | Danish Social Liberal Party | Det Radikale Venstre | Det Radikale Venstre | lib | Liberal | 4.8736 | 5.318 | 2.3903 | 7.8594 | 13410 | 68 | 1208410 | 505 | 1104 | 202 | 5585 | 202 | 21 | 211 | 6 |
NLD | Netherlands | RPF | Reformatory Political Federation | Reformatorische Politieke Federati | Reformatorische Politieke Federati | chr | Christian democracy | 8.2963 | 6.0 | 8.5455 | 3.5447 | 1109 | 2608 | 1008 | 1008 | 8 | 212 | 3 | ||||
FRA | France | MR | Reformers Movement | Mouvement réformateur | Mouvement reformateur | chr | Christian democracy | 5.8695 | 5.9852 | 5.4033 | 8.9659 | 31529 | 613 | 43 | 213 | 3 | ||||||
ISR | Israel | MDL|HH | National Religious Party | The Jewish Home | Miflaga Datit Leumit (Mafdal) | Habayit Hayehudi | Miflaga Datit Leumit (Mafdal) | Habayit Hayehudi | right | Right-wing | 8.6207 | 3.9035 | 9.3466 | 72530 | 6522 | 34 | 214 | 40 | |||||||
AUS | Australia | CouLP | Country Liberal Party | Country Liberal Party | Country Liberal Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 215 | 6 | |||||||||
MLT | Malta | PKP | Progressive Constitutionalist Party | Partit Kostituzzjonali Progressiv | Partit Kostituzzjonali Progressiv | con | Conservative | 7.4 | 6.4 | 6.9 | 72 | 217 | 26 | |||||||||
EST | Estonia | EER | Estonian Greens | Erakond Eestimaa Rohelised | Erakond Eestimaa Rohelised | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 79 | 1233100 | 2207 | 75 | 219 | 19 | |||||
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 | |||
BEL | Belgium | LD|LDD | List Dedecker | Libertarian, Direct, Democratic | Lijst Dedecker | Libertair, Direct, Democratisch | Lijst Dedecker | Libertair, Direct, Democratisch | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 14 | 1056600 | 117 | 64 | 221 | 6 | |||||
CHE | Switzerland | PSA | Autonomous Socialist Party | Partito socialista autonomo | Partito socialista autonomo | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 5.0 | 1710 | 40 | 224 | 14 | |||||||
ITA | Italy | UC | Union / Centre | Unione / Centro | Unione / Centro | chr | Christian democracy | 6.1092 | 5.1181 | 7.8038 | 7.128 | 188 | 1380523 | 818 | 6846 | 818 | 26 | 226 | 3 | |||
ISL | Iceland | A | Social Democratic Party | Alþýðuflokkurinn | Althyduflokkurinn | soc | Social democracy | 4.4444 | 3.5 | 3.5 | 15320 | 1704 | 56 | 228 | 11 | |||||||
FIN | Finland | Deva | Democratic Alternative | Demokraattinen Vaihtoehto – Demokratiskt Alternativs | Demokraattinen Vaihtoehto -- Demokratiskt Alternativs | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 0.55 | 14222 | 1407 | 67 | 229 | 14 | ||||||
ESP | Spain | CC | Canary Coalition | Coalición Canaria | Coalicion Canaria | spec | Special issue | 5.9789 | 5.9 | 5.7694 | 8.0278 | 33907 | 392 | 1724907 | 517 | 27 | 234 | 16 | ||||
NLD | Netherlands | CDA | Christian Democratic Appeal | Christen Democratisch Appèl | Christen Democratisch Appel | chr | Christian democracy | 5.9376 | 5.8848 | 6.6882 | 7.7157 | 22521 | 293 | 1528521 | 1106 | 2604 | 1001 | 7040 | 1001 | 8 | 235 | 3 |
DEU | Germany | GVP | All-German People's Party | Gesamtdeutsche Volkspartei | Gesamtdeutsche Volkspartei | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 54 | 238 | 3 | ||||||||
LVA | Latvia | KDS | Christian Democratic Union | Kristīgi demokrātiskā savienība | Kristigi demokratiska savieniba | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 87520 | 55 | 239 | 3 | |||||||
TUR | Turkey | BBP | Great Union Party | Büyük Birlik Partisi | Buyuk Birlik Partisi | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 74626 | 20 | 240 | 40 | |||||||
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 | |||
EST | Estonia | RKI | National Coalition Party "Pro Patria" | Rahvuslik Koonderakond "Isamaa" | Rahvuslik Koonderakond "Isamaa" | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 83710 | 75 | 243 | 26 | |||||||
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 | ||||||||
JPN | Japan | NPD | New Party Daichi | Shintō Daichi | Shinto Daichi | lib | Liberal | 6.0 | 6.7 | 3.6 | 5 | 247 | 6 | |||||||||
MLT | Malta | JP | Jones Party | Jones Party | Jones Party | spec | Special issue | 72 | 248 | 16 | ||||||||||||
ISR | Israel | DeTo | Banner of the Torah | Degel HaTorah | Degel HaTorah | con | Conservative | 7.4 | 6.4 | 6.9 | 72614 | 34 | 249 | 26 | ||||||||
PRT | Portugal | CDS-PP | Democratic and Social Centre -- People's Party | Centro Democrático e Social – Partido Popular | Centro Democratico e Social -- Partido Popular | chr | Christian democracy | 8.0222 | 8.1963 | 8.9916 | 4.3909 | 35314 | 233 | 1620314 | 3104 | 1202 | 7650 | 1202 | 63 | 251 | 3 | |
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 | ||||||||
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 | ||||||||
DEU | Germany | B90/Gr | Alliance 90 / Greens -- Citizens' Movement | Bündnis 90 / Grüne – BürgerInnenbewegung | Buendnis 90 / Gruene -- BuergerInnenbewegung | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 41112 | 54 | 255 | 19 | |||||||
BEL | Belgium | PA-PTB | Workers' Party of Belgium | Partij van de Arbeid – Parti du Travail de Belgique | Partij van de Arbeid -- Parti du Travail de Belgique | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 17 | 1056222 | 119 | 64 | 256 | 14 | |||||
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 | ||||||||
FRA | France | CPNT | Hunting, Fishing, Nature, Tradition | Chasse, pêche, nature, traditions | Chasse, peche, nature, traditions | agr | Agrarian | 7.8 | 7.25 | 7.875 | 2.2222 | 109 | 619 | 43 | 259 | 2 | ||||||
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 | ||||||
ISR | Israel | AY | Union of Israel | Agudat Yisrael | Agudat Yisrael | spec | Special issue | 72531 | 34 | 265 | 16 | |||||||||||
LVA | Latvia | TKL-ZP | People's Movement for Latvia -- Siegerist Party | Tautas Kustība Latvijai – Zīgerista Partija | Tautas Kustiba Latvijai -- Zigerista Partija | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 87722 | 55 | 267 | 40 | |||||||
FRA | France | FN | National Rally | Rassemblement National | Rassemblement National | right | Right-wing | 9.6854 | 7.4011 | 9.2889 | 0.2157 | 31720 | 113 | 1250720 | 708 | 1412 | 610 | 5817 | 610 | 43 | 270 | 40 |
AUT | Austria | none | no party affiliation | Parteilose | Parteilose | none | no family | 59 | 272 | 12 | ||||||||||||
NLD | Netherlands | CP | Centre Party | Centrumpartij | Centrumpartij | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 8 | 275 | 40 | ||||||||
HRV | Croatia | HDZ | Croatian Democratic Union | Hrvatska demokratska zajednica | Hrvatska demokratska zajednica | chr | Christian democracy | 7.1053 | 5.7018 | 6.9298 | 7.1053 | 81711 | 1094 | 3101 | 62 | 276 | 3 | |||||
ISR | Israel | YBA | Israel for Immigration | Yisrael Ba-Aliya | Yisrael Ba-Aliya | lib | Liberal | 6.0 | 6.7 | 3.6 | 72428 | 34 | 277 | 6 | ||||||||
LVA | Latvia | TPA | Political Union of Economists | Tautsaimnieku politiskā apvienība | Tautsaimnieku politiska apvieniba | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 55 | 278 | 6 | ||||||||
ISR | Israel | DS | The Third Way | HaDerekh HaShlishit | HaDerekh HaShlishit | lib | Liberal | 6.0 | 6.7 | 3.6 | 72427 | 34 | 279 | 6 | ||||||||
IRL | Ireland | FF | Fianna Fail | Fianna Fáil | Fianna Fail | con | Conservative | 6.0713 | 5.8991 | 6.9898 | 7.8389 | 53620 | 167 | 1372620 | 903 | 1903 | 701 | 6287 | 701 | 37 | 280 | 26 |
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 | |||||||
SWE | Sweden | KD | Christian Democrats | Kristdemokraterna | Kristdemokraterna | chr | Christian democracy | 7.195 | 6.7938 | 7.9997 | 7.8597 | 11520 | 283 | 1752520 | 3706 | 1606 | 7880 | 1606 | 35 | 282 | 3 | |
FRA | France | d-droite | other right | divers droite | divers droite | con | Conservative | 7.6583 | 9.0 | 9.0 | 5.8333 | 618 | 43 | 285 | 26 | |||||||
LVA | Latvia | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 55 | 288 | 12 | ||||||||||||
BEL | Belgium | VU | People's Union | Volksunie | Volksunie | right | Right-wing | 6.5321 | 5.8809 | 6.06 | 6.4243 | 21913 | 309 | 407 | 110 | 5003 | 110 | 64 | 290 | 40 | ||
DEU | Germany | Grau | The Grays -- Gray Panthers | Die Grauen – Graue Panther | Die Grauen -- Graue Panther | spec | Special issue | 54 | 292 | 16 | ||||||||||||
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 | |||||
NLD | Netherlands | ARP | Anti-Revolutionary Party | Anti-Revolutionaire Partij | Anti-Revolutionaire Partij | chr | Christian democracy | 5.8067 | 5.6933 | 6.7724 | 8.2894 | 22523 | 1001 | 1001 | 8 | 300 | 3 | |||||
DEU | Germany | Tier | Animal Protection Party | Tierschutzpartei | Tierschutzpartei | spec | Special issue | 54 | 301 | 16 | ||||||||||||
AUS | Australia | LLP | Lang Labour Party | Lang Labour Party | Lang Labour Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 33 | 303 | 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 | ||||||||
DNK | Denmark | En-O | Red-Green Alliance | Enhedslisten – De Rød-Grønne | Enhedslisten -- De Rod-Gronne | com | Communist/Socialist | 0.8912 | 1.2012 | 1.7524 | 0.9971 | 13229 | 214 | 5513 | 213 | 21 | 306 | 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 | |||||||
CHE | Switzerland | GPL-PVL | Green Liberal Party | Grünliberale Partei der Schweiz – Parti Vert-Libéral | Gruenliberale Partei der Schweiz -- Parti Vert-Liberal | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 3606 | 40 | 308 | 19 | |||||||
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 | |||||
LUX | Luxembourg | Greng | The Greens | Déi Gréng | Dei Greng | eco | Green/Ecologist | 2.5 | 1.5789 | 0.7895 | 23113 | 213 | 1442113 | 6946 | 7 | 310 | 19 | |||||
GBR | United Kingdom | Plaid | Plaid Cymru | Plaid Cymru | Plaid Cymru | spec | Special issue | 3.1183 | 2.6251 | 3.7107 | 7.8314 | 1826901 | 1602 | 1106 | 5169 | 1106 | 44 | 311 | 16 | |||
SVK | Slovakia | SDK | Slovak Democratic Coalition | Slovenská demokratická koalícia | Slovenska demokraticka koalicia | chr | Christian democracy | 7.19 | 7.77 | 4.02 | 9.225 | 96522 | 2802 | 1 | 313 | 3 | ||||||
HRV | Croatia | HB | Croatian Bloc | Hrvatski blok | Hrvatski blok | right | Right-wing | 9.386 | 3.1579 | 7.6842 | 1.8421 | 1068 | 62 | 316 | 40 | |||||||
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 | ||||||||
IRL | Ireland | Lab | Labour Party | Labour Party | Labour Party | soc | Social democracy | 3.6252 | 3.353 | 3.1071 | 7.1292 | 53320 | 170 | 1372320 | 902 | 1902 | 703 | 6347 | 703 | 37 | 318 | 11 |
GBR | United Kingdom | DUP | Democratic Unionist Party | Democratic Unionist Party | Democratic Unionist Party | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 51903 | 44 | 319 | 26 | |||||||
SVN | Slovenia | DEMOS | Democratic Opposition of Slovenia | Demokratična opozicija Slovenije | Demokraticna opozicija Slovenije | spec | Special issue | 60 | 321 | 16 | ||||||||||||
POL | Poland | RKN | Catholic-National Movement | Ruch Katolicko-Narodowy | Ruch Katolicko-Narodowy | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 74 | 322 | 40 | ||||||||
ITA | Italy | ASM | Social Alternative Mussolini | Alternativa Sociale Mussolini | Alternativa Sociale Mussolini | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 26 | 323 | 40 | ||||||||
ITA | Italy | VA | Rainbow Greens | Verdi Arcobaleno | Verdi Arcobaleno | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 26 | 325 | 19 | ||||||||
SVN | Slovenia | Zares | For Real | Zares | Zares | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 267 | 1705324 | 2910 | 60 | 326 | 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 | ||||
GBR | United Kingdom | N | Nationalist Party | Nationalist Party | Nationalist Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 44 | 332 | 11 | ||||||||
POL | Poland | ChD | Christian Democracy | Chrześcijańska Demokracja | Chrzescijanska Demokracja | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 92520 | 74 | 334 | 3 | |||||||
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 | |||||||
CZE | Czech Republic | VV | Public Affairs | Věci veřejné | Veci verejne | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 2110 | 68 | 336 | 6 | |||||||
NLD | Netherlands | EuTr | Europe Transparent | Europa Transparant | Europa Transparant | spec | Special issue | 8 | 339 | 16 | ||||||||||||
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 | ||||||
NLD | Netherlands | PPR | Radical Political Party | Politieke Partij Radikalen | Politieke Partij Radikalen | eco | Green/Ecologist | 1.6 | 2.5 | 1.8 | 5.0 | 22310 | 1103 | 1010 | 8 | 342 | 19 | |||||
NLD | Netherlands | D66 | Democrats 66 | Democraten 66 | Democraten 66 | lib | Liberal | 4.5066 | 4.9917 | 1.7625 | 8.6233 | 22330 | 295 | 1528330 | 1105 | 2603 | 1004 | 7080 | 1004 | 8 | 345 | 6 |
GBR | United Kingdom | U | Unity | Unity | Unity | spec | Special issue | 44 | 349 | 16 | ||||||||||||
NOR | Norway | Fr | Progress Party | Fremskrittspartiet | Fremskrittspartiet | right | Right-wing | 8.7595 | 7.5 | 5.5388 | 6.119 | 12951 | 1307 | 2909 | 1507 | 7506 | 3502 | 9 | 351 | 40 | ||
BGR | Bulgaria | ZNS | Agrarian People's Union | Zemedelski Naroden Suyuz | Zemedelski Naroden Suyuz | agr | Agrarian | 5.5263 | 5.7895 | 5.9398 | 8.9474 | 80810 | 704 | 867 | 10 | 353 | 2 | |||||
NZL | New Zealand | PP | Progressive Party | Progressive Party | Progressive Party | soc | Social democracy | 3.0194 | 2.6316 | 3.5 | 64422 | 7316 | 11 | 354 | 11 | |||||||
ROU | Romania | CDR | Romanian Democratic Convention | Convenţia Democrată Română | Conventia Democrata Romana | chr | Christian democracy | 6.29 | 6.71 | 4.43 | 9.7667 | 93411 | 2707 | 23 | 356 | 3 | ||||||
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 | |||
DEU | Germany | FVP | Free People's Party | Freie Volkspartei | Freie Volkspartei | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 54 | 358 | 6 | ||||||||
MLT | Malta | AD | Democratic Alternative | Alternattiva Demokratika | Alternattiva Demokratika | eco | Green/Ecologist | 3.7895 | 3.2632 | 4.6316 | 224 | 1470100 | 6986 | 72 | 360 | 19 | ||||||
CZE | Czech Republic | SSO | Party of Free Citizens | Strana svobodných občanů | Strana svobodnych obcanu | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 63 | 68 | 363 | 40 | |||||||
BGR | Bulgaria | BNRP | Bulgarian National Radical Party | Balgarska Natsionalnoradikalna Partiya | Balgarska Natsionalnoradikalna Partiya | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 364 | 40 | ||||||||
ITA | Italy | Rete | Movement for Democracy -- The Net | Movimento per la Democrazia – La Rete | Movimento per la Democrazia -- La Rete | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 6.6667 | 32951 | 813 | 26 | 366 | 3 | ||||||
DNK | Denmark | FK | Common Course | Fælles Kurs | Faelles Kurs | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 13221 | 210 | 21 | 367 | 14 | ||||||
CAN | Canada | LP | Liberal Party of Canada | Liberal Party of Canada | Liberal Party of Canada | lib | Liberal | 5.0552 | 5.3509 | 3.4615 | 62420 | 402 | 803 | 5273 | 29 | 368 | 6 |
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;