view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by cmp
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CYP | Cyprus | EP | Active Citizens | Energi Polites | Energi Polites | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 51 | 2815 | 14 | |||||||||
CYP | Cyprus | EnKe | Union Centre | Enosi Kentrou | Enosi Kentrou | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 1777 | 6 | |||||||||
CYP | Cyprus | GTE | For Europe | Gia tin Evropi | For Europe | con | Conservative | 7.4 | 6.4 | 6.9 | 51 | 768 | 26 | |||||||||
CYP | Cyprus | Greek | Greek | Greek | Greek | none | no family | 51 | 1071 | 12 | ||||||||||||
CYP | Cyprus | I-SL | Independent -- Sener Levent | Independent – Sener Levent | Independent -- Sener Levent | none | no family | 51 | 2343 | 12 | ||||||||||||
CYP | Cyprus | KEP | Free Citizens Movement | K.E.P | K.E.P | code | to be coded | 51 | 1735 | 28 | ||||||||||||
CYP | Cyprus | KGTZTK | Animal Party Cyprus | Kinima gia ta zoa tis Kíprou | Kinima gia ta zoa tis Kiprou | spec | Special issue | 51 | 2627 | 16 | ||||||||||||
CYP | Cyprus | KINHMA | Solidarity Movement | Kinima Allileggiis | Kinima Allileggiis | right | Right-wing | 8.8 | 5.9 | 8.5 | 51 | 2626 | 40 | |||||||||
CYP | Cyprus | KOP | Ecological and Environmental Movement | Kinima Oikologoi Perivallontistoi | Kinima Oikologoi Perivallontistoi | eco | Green/Ecologist | 5.7895 | 5.5263 | 5.7895 | 53 | 1196110 | 5441 | 51 | 1621 | 19 | ||||||
CYP | Cyprus | LP | Liberal Party | Liberal Party | Liberal Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 1151 | 6 | |||||||||
CYP | Cyprus | ME | Message of Hope | Minima Elpidas | Minima Elpidas | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 2342 | 6 | |||||||||
CYP | Cyprus | NEDEPA | New Democratic Front | Nea Demokratiki Parataxi | Nea Demokratiki Parataxi | code | to be coded | 51 | 1778 | 28 | ||||||||||||
CYP | Cyprus | NO | New Horizons | Neoi Orizontes | Neoi Orizontes | right | Right-wing | 9.3421 | 6.5789 | 7.1053 | 5459 | 51 | 6 | 40 | ||||||||
CYP | Cyprus | PAME | Pancypriot Militant Front | Pankyprio Agonistiko Metopo | Pankyprio Agonistiko Metopo | right | Right-wing | 8.8 | 5.9 | 8.5 | 51 | 1776 | 40 | |||||||||
CYP | Cyprus | PL | People's Breath | Pní Laoú | Pni Laou | right | Right-wing | 8.8 | 5.9 | 8.5 | 51 | 2820 | 40 | |||||||||
CYP | Cyprus | SYM | Citizen's Alliance | Symmaxia | Symmaxia | soc | Social democracy | 3.3 | 3.5 | 3.5 | 51 | 2341 | 11 | |||||||||
CYP | Cyprus | Turkish | Turkish | Turkish | Turkish | none | no family | 51 | 1655 | 12 | ||||||||||||
CYP | Cyprus | YH | Jasmine Movement | Yasemin Hareketi | Yasemin Hareketi | soc | Social democracy | 3.3 | 3.5 | 3.5 | 51 | 2784 | 11 | |||||||||
CYP | Cyprus | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 51 | 534 | 12 | ||||||||||||
CZE | Czech Republic | ANO | Action of Dissatisfied Citizens 2011 | Akce nespokojených občanů 2011 | Akce nespokojenych obcanu 2011 | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 68 | 2263 | 6 | ||||||||
CZE | Czech Republic | ANO-VE | Yes, We Will Troll the Euro-Parliament | ANO, vytrollíme europarlament | ANO, vytrollime europarlament | spec | Special issue | 68 | 2779 | 16 | ||||||||||||
CZE | Czech Republic | CNSP | Czech National Social(ist) Party | Česká národně strana socialistická | Ceska narodne strana socialisticka | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 29 | 40 | ||||||||
CZE | Czech Republic | CP-SB | Conservative Party -- Free Bloc | Konzervativní strana – Svobodný blok | Konzervativni strana -- Svobodny blok | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 68 | 2102 | 26 | ||||||||
CZE | Czech Republic | DSSS | Workers' Party of Social Justice | Dělnická strana sociální spravedlnosti | Delnicka strana socialni spravedlnosti | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 795 | 40 | ||||||||
CZE | Czech Republic | DU | Democratic Union | Demokratická unie | Demokraticka unie | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 68 | 1616 | 6 | ||||||||
CZE | Czech Republic | EDS | European Democratic Party | Evropská demokratická strana | Evropska demokraticka strana | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 56 | 68 | 1454 | 6 | |||||||
CZE | Czech Republic | H | Voice | Hlas | Hlas | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 68 | 2739 | 6 | ||||||||
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 | KAN | Club of committed Non-Party Members | Klub angazovaných nestraníku | Klub angazovanych nestraniku | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 68 | 2220 | 6 | ||||||||
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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 |
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;