view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CZE | Czech Republic | KSCM | Communist Party of Bohemia and Moravia | Komunistická strana Cech a Moravy | Komunisticka strana Cech a Moravy | com | Communist/Socialist | 0.7498 | 1.2243 | 6.4265 | 2.4656 | 82220 | 57 | 1203220 | 1001 | 1380 | 2103 | 68 | 1173 | 14 | ||
CZE | Czech Republic | LB | Left Bloc | Levý Blok | Levy Blok | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 68 | 2224 | 14 | ||||||||
CZE | Czech Republic | LIDEM | LIDEM -- Liberal Democrats | LIDEM – liberální demokraté | LIDEM -- liberalni demokrate | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 68 | 2042 | 6 | ||||||||
CZE | Czech Republic | LSU | Liberal Social Union | Liberálně sociální unie | Liberalne socialni unie | lib | Liberal | 2.9667 | 6.7 | 3.6 | 8.7 | 82420 | 1003 | 68 | 1218 | 6 | ||||||
CZE | Czech Republic | NEI | Independent Initiative | Nezávislá iniciativa | Nezavisla iniciativa | code | to be coded | 68 | 2221 | 28 | ||||||||||||
CZE | Czech Republic | Ne | Independent | Nezávislí | Nezavisli | right | Right-wing | 5.5 | 4.5 | 4.75 | 5.0 | 2108 | 68 | 653 | 40 | |||||||
CZE | Czech Republic | ODA | Civic Democratic Alliance | Občanská demokratická aliance | Obcanska demokraticka aliance | lib | Liberal | 7.1111 | 6.7 | 3.6 | 8.7 | 82412 | 1006 | 68 | 1123 | 6 | ||||||
CZE | Czech Republic | ODS | Civic Democratic Party | Občanská demokratická strana | Obcanska demokraticka strana | con | Conservative | 7.3637 | 7.8985 | 4.0087 | 4.456 | 82413 | 59 | 1203413 | 1005 | 1458 | 2102 | 68 | 829 | 26 | ||
CZE | Czech Republic | OF | Civic Forum | Obcanské fórum | Obcanske forum | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 82410 | 68 | 743 | 6 | |||||||
CZE | Czech Republic | OH|SD | Civic Movement | Free Democrats | Obcanské hnuti | Svobodní Demokraté | Obcanske hnuti | Svobodni Demokrate | lib | Liberal | 4.1667 | 6.7 | 3.6 | 8.7 | 1004 | 68 | 574 | 6 | |||||||
CZE | Czech Republic | P | Oath | Přísaha | Prisaha | spec | Special issue | 68 | 2831 | 16 | ||||||||||||
CZE | Czech Republic | PB | Right Bloc | Pravý Blok | Pravy Blok | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 2033 | 40 | ||||||||
CZE | Czech Republic | Pi | Czech Pirate Party | Ceska piratska strana | Ceska piratska strana | spec | Special issue | 68 | 2261 | 16 | ||||||||||||
CZE | Czech Republic | S-JB | Sovereignty -- Jana Bobosikova Bloc | Suverenita – blok Jany Bobošíkové | Suverenita -- blok Jany Bobosikove | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 1613 | 40 | ||||||||
CZE | Czech Republic | SCPZR | Czechoslovak Businessmen's, Traders' and Farmers' Party | Strana československých podnikatelů, živnostníků a rolníků | Strana ceskoslovenskych podnikatelu, zivnostniku a rolniku | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 68 | 2219 | 6 | ||||||||
CZE | Czech Republic | SNK-ED | SNK European Democrats | SNK Evropští demokraté | SNK Evropsti demokrate | lib | Liberal | 6.0929 | 6.5934 | 3.4947 | 8.3662 | 60 | 1510 | 2106 | 68 | 1532 | 6 | |||||
CZE | Czech Republic | SPD | Freedom and Direct Democracy | Svoboda a přímá demokracie | Svoboda a prima demokracie | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 2654 | 40 | ||||||||
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 | ||||||||
CZE | Czech Republic | SPP | Party of the Friends of Beer | Strana prátel piva | Strana pratel piva | spec | Special issue | 68 | 2222 | 16 | ||||||||||||
CZE | Czech Republic | SPR-RSC | Rally for the Republic -- Republican Party of Czechoslovakia | Sdruzení pro republiku – Republikánská strana Ceskoslovenska | Sdruzeni pro republiku -- Republikanska strana Ceskoslovenska | right | Right-wing | 9.7778 | 5.9 | 8.5 | 2.3 | 82710 | 1009 | 68 | 872 | 40 | ||||||
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 | |||||||
CZE | Czech Republic | STAN | Mayors and Independents | Starostové a nezávislí | Starostove a nezavisli | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 68 | 2024 | 6 | ||||||||
CZE | Czech Republic | SZ | Green Party | Strana zelených | Strana zelenych | eco | Green/Ecologist | 4.123 | 3.8917 | 1.8596 | 7.8505 | 61 | 1203110 | 1536 | 2107 | 68 | 196 | 19 | ||||
CZE | Czech Republic | SZV | Alliance of Farmers and the Countryside | Spojenectví zemědělců a venkova | Spojenectvi zemedelcu a venkova | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 68 | 2101 | 2 | ||||||||
CZE | Czech Republic | TOP09 | Tradition Responsibility Prosperity 09 | Tradice Odpovědnost Prosperita 09 | Tradice Odpovednost Prosperita 09 | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 2109 | 68 | 2 | 26 | |||||||
CZE | Czech Republic | Tri | Tricolour Citizens' Movement | Trikolóra | Trikolora | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 2832 | 40 | ||||||||
CZE | Czech Republic | UPD | Dawn of Direct Democracy | Úsvit přímé demokracie | Usvit prime demokracie | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 68 | 2262 | 26 | ||||||||
CZE | Czech Republic | US | Freedom Union | Unie svobody | Unie svobody | lib | Liberal | 7.2204 | 7.5343 | 2.3792 | 9.4344 | 82421 | 62 | 1586 | 2105 | 68 | 688 | 6 | ||||
CZE | Czech Republic | VB | Free Bloc | Volný blok | Volny blok | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 2854 | 40 | ||||||||
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 | |||||||
CZE | Czech Republic | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 68 | 1567 | 12 | ||||||||||||
DEU | Germany | AfD | Alternative for Germany | Alternative für Deutschland | Alternative fuer Deutschland | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 54 | 2253 | 40 | ||||||||
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 | |||||||
DEU | Germany | B90/Gru | Alliance 90 / Greens | Bündnis 90 / Die Grünen | Buendnis 90 / Die Gruenen | eco | Green/Ecologist | 2.9308 | 4.3268 | 1.3251 | 7.6101 | 41113 | 115 | 1276113 | 802 | 1502 | 305 | 6015 | 304 | 54 | 772 | 19 |
DEU | Germany | BBB | Bavarian Peasants' League | Bayerischer Bauernbund | Bayerischer Bauernbund | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 54 | 2701 | 6 | ||||||||
DEU | Germany | BFB | Confederation of free citizens -- Offensive for Germany | Bund freier Bürger – Offensive für Deutschland | Bund freier Buerger -- Offensive fuer Deutschland | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 54 | 1720 | 40 | ||||||||
DEU | Germany | BLB | Baden Rural Federation | Badischer Landbund | Badischer Landbund | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 54 | 2707 | 2 | ||||||||
DEU | Germany | BP | Bavarian Party | Bayernpartei | Bayernpartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41911 | 54 | 1131 | 26 | |||||||
DEU | Germany | BVP | Bavarian People's Party | Bayerische Volkspartei | Bayerische Volkspartei | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 54 | 2697 | 3 | ||||||||
DEU | Germany | BWB | Farmers and Wine Growers Association | Bauern- und Weingärtnerbund | Bauern- und Weingaertnerbund | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 54 | 2703 | 2 | ||||||||
DEU | Germany | CDU | Christian Democratic Union | Christlich Demokratische Union | Christlich Demokratische Union | chr | Christian democracy | 6.2503 | 6.3498 | 6.9333 | 8.5024 | 41521 | 116 | 1276521 | 805 | 1505 | 301 | 5943 | 301 | 54 | 808 | 3 |
DEU | Germany | CDU+CSU | Christian Democratic Union / Christian Social Union | Christlich Demokratische Union / Christlich Soziale Union | Christlich Demokratische Union / Christlich Soziale Union | chr | Christian democracy | 6.2503 | 6.3498 | 6.9333 | 8.5024 | 41521 | 116 | 1276521 | 805 | 1505 | 301 | 5943 | 301 | 54 | 1727 | 3 |
DEU | Germany | CNAG | Christian National Working Group | Christlichnationale Arbeitsgemeinschaft | Christlichnationale Arbeitsgemeinschaft | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 54 | 2713 | 3 | ||||||||
DEU | Germany | CNBL | Christian-National Peasants' and Farmers' Party | Christlich-Nationale Bauern- und Landvolkpartei | Christlich-Nationale Bauern- und Landvolkpartei | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 54 | 2709 | 3 | ||||||||
DEU | Germany | CSU | Christian Social Union | Christlich Soziale Union | Christlich Soziale Union | chr | Christian democracy | 7.2871 | 6.5615 | 7.8675 | 6.668 | 41521 | 117 | 1276521 | 806 | 1506 | 309 | 5943 | 308 | 54 | 1180 | 3 |
DEU | Germany | CSVD | Christian Social People's Service | Christlich-Sozialer Volksdienst | Christlich-Sozialer Volksdienst | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 54 | 2700 | 3 | ||||||||
DEU | Germany | DBP | German Farmers' Party | Deutsche Bauernpartei | Deutsche Bauernpartei | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 54 | 2712 | 2 | ||||||||
DEU | Germany | DDP | German Democratic Party | Deutsche Demokratische Partei | Deutsche Demokratische Partei | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 54 | 2691 | 6 | ||||||||
DEU | Germany | DFU | German Peace Union | Deutsche Friedensunion | Deutsche Friedensunion | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 54 | 633 | 14 | ||||||||
DEU | Germany | DHP | German-Hanoverian Party | Deutsch-Hannoversche Partei | Deutsch-Hannoversche Partei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 2696 | 26 | ||||||||
DEU | Germany | DNVP | German National People's Party | Deutschnationale Volkspartei | Deutschnationale Volkspartei | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 54 | 2692 | 40 | ||||||||
DEU | Germany | DP | German Party | Deutsche Partei | Deutsche Partei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41620 | 54 | 912 | 26 | |||||||
DEU | Germany | DRP | German Reich Party | Deutsche Reichspartei | Deutsche Reichspartei | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 41712 | 54 | 187 | 40 | |||||||
DEU | Germany | DSP | German Social Party | Deutschsoziale Partei | Deutschsoziale Partei | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 54 | 2705 | 40 | ||||||||
DEU | Germany | DVP | German People's Party | Deutsche Volkspartei | Deutsche Volkspartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 2693 | 26 | ||||||||
DEU | Germany | DVU | German People's Union | Deutsche Volksunion | Deutsche Volksunion | right | Right-wing | 9.7256 | 5.8616 | 9.6118 | 0.9435 | 148 | 5979 | 309 | 54 | 1506 | 40 | |||||
DEU | Germany | DZ | Centre Party | Deutsche Zentrumspartei | Deutsche Zentrumspartei | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 41522 | 54 | 137 | 3 | |||||||
DEU | Germany | FDP | Free Democratic Party | Freie Demokratische Partei | Freie Demokratische Partei | lib | Liberal | 5.9233 | 8.2173 | 3.0695 | 8.4855 | 41420 | 119 | 1276420 | 804 | 1504 | 303 | 5997 | 303 | 54 | 543 | 6 |
DEU | Germany | FVP | Free People's Party | Freie Volkspartei | Freie Volkspartei | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 54 | 358 | 6 | ||||||||
DEU | Germany | FW | Free Voters | Freie Wähler | Freie Waehler | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 121 | 54 | 41 | 26 | |||||||
DEU | Germany | Fam | Family Party of Germany | Familien-Partei Deutschlands | Familien-Partei Deutschlands | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 1235 | 26 | ||||||||
DEU | Germany | Fr | Peace alliance | Friedensliste | Friedensliste | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 54 | 1718 | 14 | ||||||||
DEU | Germany | GB/BHE | All-German Bloc / League of Expellees and Deprived of Rights | Gesamtdeutscher Block / Bund der Heimatvertriebenen und Entrechteten | Gesamtdeutscher Block / Bund der Heimatvertriebenen und Entrechteten | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 41951 | 54 | 1507 | 40 | |||||||
DEU | Germany | GDP | All-German Party | Gesamtdeutsche Partei | Gesamtdeutsche Partei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 1701 | 26 | ||||||||
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 | ||||||||
DEU | Germany | Grau | The Grays -- Gray Panthers | Die Grauen – Graue Panther | Die Grauen -- Graue Panther | spec | Special issue | 54 | 292 | 16 | ||||||||||||
DEU | Germany | HBB | Hessian Farmers' Federation | Hessischer Bauernbund | Hessischer Bauernbund | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 54 | 2706 | 2 | ||||||||
DEU | Germany | KPD | Communist Party of Germany | Kommunistische Partei Deutschlands | Kommunistische Partei Deutschlands | com | Communist/Socialist | 0.957 | 0.3618 | 2.6754 | 1.9649 | 41220 | 801 | 308 | 5961 | 54 | 649 | 14 | ||||
DEU | Germany | KVP | Conservative Peoples' Party | Konservative Volkspartei | Konservative Volkspartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 2711 | 26 | ||||||||
DEU | Germany | LBT | Rural Federation Thuringia | Landbund Thüringen | Landbund Thueringen | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 54 | 2704 | 2 | ||||||||
DEU | Germany | NPD | National Democratic Party | Nationaldemokratische Partei Deutschlands | Nationaldemokratische Partei Deutschlands | right | Right-wing | 9.8246 | 4.2105 | 9.4219 | 0.7989 | 6033 | 54 | 1537 | 40 | |||||||
DEU | Germany | NSDAP | National Socialist German Workers' Party | Nationalsozialistische Deutsche Arbeiterpartei | Nationalsozialistische Deutsche Arbeiterpartei | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 54 | 2695 | 40 | ||||||||
DEU | Germany | ODP | Ecological Democratic Party | Ökologisch-Demokratische Partei | Okologisch-Demokratische Partei | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 54 | 2736 | 19 | ||||||||
DEU | Germany | PARTEI | The PARTY | Die PARTEI | Die PARTEI | spec | Special issue | 54 | 2649 | 16 | ||||||||||||
DEU | Germany | PDS|Li | PDS | The Left | PDS | Die Linke | PDS | Die Linke | com | Communist/Socialist | 1.2152 | 1.0617 | 3.205 | 4.3508 | 41221 | 1501 | 307 | 6051 | 306 | 54 | 791 | 14 | |||
DEU | Germany | Pi | German Pirate Party | Piratenpartei Deutschland | Piratenpartei Deutschland | spec | Special issue | 54 | 865 | 16 | ||||||||||||
DEU | Germany | Rep | The Republicans | Die Republikaner | Die Republikaner | right | Right-wing | 9.2752 | 6.1901 | 9.3871 | 0.941 | 133 | 1507 | 306 | 6069 | 305 | 54 | 524 | 40 | |||
DEU | Germany | SLV | Saxon Peasants | Sächsisches Landvolk | Saechsisches Landvolk | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 54 | 2708 | 2 | ||||||||
DEU | Germany | SPD | Social Democratic Party of Germany | Sozialdemokratische Partei Deutschlands | Sozialdemokratische Partei Deutschlands | soc | Social democracy | 3.6451 | 3.8443 | 3.9791 | 7.9318 | 41320 | 120 | 1276320 | 803 | 1503 | 302 | 6087 | 302 | 54 | 558 | 11 |
DEU | Germany | SSW | South Schleswig Voter League | Südschleswigscher Wählerverband | Suedschleswigscher Waehlerverband | spec | Special issue | 54 | 2850 | 16 | ||||||||||||
DEU | Germany | Tier | Animal Protection Party | Tierschutzpartei | Tierschutzpartei | spec | Special issue | 54 | 301 | 16 | ||||||||||||
DEU | Germany | USPD | Independent Social Democratic Party of Germany | Unabhängige Sozialdemokratische Partei Deutschlands | Unabhaengige Sozialdemokratische Partei Deutschlands | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 54 | 2690 | 14 | ||||||||
DEU | Germany | VRP | Reich Party for Civil Rights and Deflation | Reichspartei für Volksrecht und Aufwertung | Reichspartei fuer Volksrecht und Aufwertung | spec | Special issue | 54 | 2710 | 16 | ||||||||||||
DEU | Germany | WASG | Labour and Social Justice -- The Electoral Alternative | Arbeit & soziale Gerechtigkeit – Die Wahlalternative | Arbeit & soziale Gerechtigkeit -- Die Wahlalternative | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 54 | 796 | 14 | ||||||||
DEU | Germany | WAV | Economic Reconstruction League | Wirtschaftliche Aufbauvereinigung | Wirtschaftliche Aufbauvereinigung | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 41711 | 54 | 1420 | 40 | |||||||
DEU | Germany | WP | Economic Party | Wirtschaftspartei | Wirtschaftspartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 2698 | 26 | ||||||||
DEU | Germany | dieBasis | Grassroots Democratic Party of Germany | Basisdemokratische Partei Deutschland | Basisdemokratische Partei Deutschland | spec | Special issue | 54 | 2821 | 16 | ||||||||||||
DEU | Germany | no-seat | no seat | no seat | no seat | none | no family | 54 | 2034 | 12 | ||||||||||||
DEU | Germany | none | no party affiliation | parteilos | parteilos | none | no family | 54 | 610 | 12 | ||||||||||||
DEU | Germany | one-seat | one seat | one seat | one seat | none | no family | 54 | 2289 | 12 | ||||||||||||
DNK | Denmark | A | The Alternative | Alternativet | Alternativet | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 21 | 2567 | 19 | ||||||||
DNK | Denmark | AE | Denmark Demokrats | Danmarksdemokraterne | Danmarksdemokraterne | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 21 | 2888 | 40 | ||||||||
DNK | Denmark | At | Solidarity (Greenland) | Atassut | Atassut | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 21 | 2575 | 6 | ||||||||
DNK | Denmark | Bo | Farmers' Party | Bondepartiet | Bondepartiet | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 21 | 2428 | 2 | ||||||||
DNK | Denmark | CD | Centre Democrats | Centrumdemokraterne | Centrumdemokraterne | con | Conservative | 5.5609 | 4.8029 | 4.9307 | 9.1468 | 13330 | 506 | 1105 | 204 | 5477 | 204 | 21 | 1324 | 26 | ||
DNK | Denmark | DF | Danish Peoples Party | Dansk Folkeparti | Dansk Folkeparti | right | Right-wing | 8.2269 | 5.7081 | 7.8954 | 1.183 | 13720 | 69 | 1208720 | 5495 | 215 | 21 | 1418 | 40 | |||
DNK | Denmark | DKP | Communist Party of Denmark | Danmarks Kommunistiske Parti | Danmarks Kommunistiske Parti | com | Communist/Socialist | 1.0 | 1.4 | 3.0 | 0.4167 | 13220 | 502 | 209 | 21 | 1239 | 14 | |||||
DNK | Denmark | DNSAP | National Socialist Workers' Party of Denmark | Danmarks Nationalsocialistiske Arbejderparti | Danmarks Nationalsocialistiske Arbejderparti | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 21 | 2432 | 40 | ||||||||
DNK | Denmark | DS | Danish Union | Dansk Samling | Dansk Samling | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 13953 | 21 | 412 | 40 | |||||||
DNK | Denmark | DU | Independents Party | De Uafhængige | De Uafhaengige | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 13421 | 21 | 538 | 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;