view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by eu_anti_pro
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 | AK | Famagusta for Cyprus | Ammókhostos yia tin Kípro | Ammokhostos yia tin Kipro | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 2818 | 6 | |||||||||
CYP | Cyprus | AKEL | Progressive Party of Working People | Anorthotikó Kómma Ergazómenou Laoú | Anorthotikon Komma Ergazemenou Laou | com | Communist/Socialist | 1.0526 | 2.6316 | 6.1842 | 55321 | 49 | 1196321 | 5351 | 51 | 572 | 14 | |||||
CYP | Cyprus | AM | Awakening 2020 | Afypnisis 2020 | Afypnisis 2020 | spec | Special issue | 51 | 2819 | 16 | ||||||||||||
CYP | Cyprus | Anex | Independents Movement | Independents Movement | Independents Movement | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 2817 | 6 | |||||||||
CYP | Cyprus | DIKO | Democratic Party | Dimokratikó Kómma | Dimokratiko Komma | con | Conservative | 5.1316 | 4.0789 | 6.0526 | 55422 | 50 | 1196422 | 5369 | 51 | 851 | 26 | |||||
CYP | Cyprus | DISY | Democratic Rally | Dimokratikós Sinayermós | Dimokratikos Synagermos | con | Conservative | 8.6842 | 7.3684 | 5.0 | 55711 | 51 | 1196711 | 5387 | 51 | 1575 | 26 | |||||
CYP | Cyprus | DP | Democratic Alignment | Dimokratiki Parataxi | Dimokratiki Parataxi | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 2741 | 6 | |||||||||
CYP | Cyprus | ED | United Democrats | Enomeni Dimokrates | Enomeni Dimokrates | lib | Liberal | 7.1053 | 6.0526 | 4.3421 | 55423 | 5423 | 51 | 1523 | 6 | |||||||
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 | EK | European Party | Evropaiko Komma | Evropaiko Komma | lib | Liberal | 6.0 | 6.7 | 3.6 | 52 | 1196600 | 51 | 491 | 6 | |||||||
CYP | Cyprus | ELAM | National Popular Front | Ethniko Laiko Metopo | Ethniko Laiko Metopo | right | Right-wing | 8.8 | 5.9 | 8.5 | 51 | 1768 | 40 | |||||||||
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-VE | Yes, We Will Troll the Euro-Parliament | ANO, vytrollíme europarlament | ANO, vytrollime europarlament | spec | Special issue | 68 | 2779 | 16 | ||||||||||||
CZE | Czech Republic | HSD-SMS | Movement for Self-Governing Democracy -- Society for Moravia and Silesia | Hnutí za samosprávnou demokracii – Společnost pro Moravu a Slezsko | Hnuti za samospravnou demokracii -- Spolecnost pro Moravu a Slezsko | spec | Special issue | 82951 | 68 | 19 | 16 | |||||||||||
CZE | Czech Republic | NEI | Independent Initiative | Nezávislá iniciativa | Nezavisla iniciativa | code | to be coded | 68 | 2221 | 28 | ||||||||||||
CZE | Czech Republic | P | Oath | Přísaha | Prisaha | spec | Special issue | 68 | 2831 | 16 | ||||||||||||
CZE | Czech Republic | Pi | Czech Pirate Party | Ceska piratska strana | Ceska piratska strana | spec | Special issue | 68 | 2261 | 16 | ||||||||||||
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 | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 68 | 1567 | 12 | ||||||||||||
DEU | Germany | Grau | The Grays -- Gray Panthers | Die Grauen – Graue Panther | Die Grauen -- Graue Panther | spec | Special issue | 54 | 292 | 16 | ||||||||||||
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 | 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 | 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 | 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 | GrFa | Greenland and Faroe Islands | Grønland og Færøerne | Gronland og Faeroerne | none | no family | 21 | 1634 | 12 | ||||||||||||
DNK | Denmark | SP | Schleswig Party | Slesvigsk Parti | Slesvigsk Parti | spec | Special issue | 21 | 812 | 16 | ||||||||||||
DNK | Denmark | etc | others | others | others | none | no family | 21 | 2576 | 12 | ||||||||||||
DNK | Denmark | no-seat | no seat | no seat | no seat | none | no family | 21 | 2058 | 12 | ||||||||||||
DNK | Denmark | none | no party affiliation | ingen | ingen | none | no family | 21 | 1128 | 12 | ||||||||||||
ESP | Spain | AIC | Canary Islands Group | Agrupacion Independientes de Canarias | Agrupacion Independientes de Canarias | spec | Special issue | 27 | 411 | 16 | ||||||||||||
ESP | Spain | ARM | Ruiz-Mateos List | Agrupación Ruiz-Mateos | Agrupacion Ruiz-Mateos | spec | Special issue | 27 | 73 | 16 | ||||||||||||
ESP | Spain | Bai | Yes | Bai | Bai | spec | Special issue | 1724923 | 27 | 385 | 16 | |||||||||||
ESP | Spain | C-NE | European-Nationalist Coalition | Coalicion Nacionalista-Europea | Coalicion Nacionalista-Europea | spec | Special issue | 27 | 2172 | 16 | ||||||||||||
ESP | Spain | CEP | For the Europe of the Peoples | Coalición por la Europa de los Pueblos | Coalicion por la Europa de los Pueblos | spec | Special issue | 521 | 27 | 771 | 16 | |||||||||||
ESP | Spain | EHB | Basque Country Unite | Euskal Herria Bildu | Euskal Herria Bildu | spec | Special issue | 27 | 2603 | 16 | ||||||||||||
ESP | Spain | II-SP | Internationalist Initiative -- Solidarity between Peoples | Iniciativa Internacionalista – La Solidaridad entre los Pueblos | Iniciativa Internacionalista -- La Solidaridad entre los Pueblos | spec | Special issue | 27 | 681 | 16 | ||||||||||||
ESP | Spain | IP | Left of the Peoples | Izquierda de los Pueblos | Izquierda de los Pueblos | spec | Special issue | 27 | 121 | 16 | ||||||||||||
ESP | Spain | PACMA | Animalist Party Against Mistreatment to Animals | Partido Animalista Contra el Maltrato Animal | Partido Animalista Contra el Maltrato Animal | spec | Special issue | 27 | 2381 | 16 | ||||||||||||
ESP | Spain | etc | others | others | others | none | no family | 27 | 1377 | 12 | ||||||||||||
ESP | Spain | no-seat | no seat | no seat | no seat | none | no family | 27 | 2056 | 12 | ||||||||||||
ESP | Spain | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 27 | 1166 | 12 | ||||||||||||
ESP | Spain | one-seat | one seat | one seat | one seat | none | no family | 27 | 2294 | 12 | ||||||||||||
EST | Estonia | EPL | Estonian Pensioners' Union | Eesti Pensionaride Liit | Eesti Pensionaride Liit | spec | Special issue | 75 | 1792 | 16 | ||||||||||||
EST | Estonia | I-DK | Independent -- Dimitri Klenski | Independent – Dimitri Klenski | Independent -- Dimitri Klenski | none | no family | 75 | 2031 | 12 | ||||||||||||
EST | Estonia | I-IT | Independent -- Indrek Tarand | Independent – Indrek Tarand | Independent -- Indrek Tarand | none | no family | 75 | 2029 | 12 | ||||||||||||
EST | Estonia | I-MH | Independent -- Martin Helme | Independent – Martin Helme | Independent -- Martin Helme | none | no family | 75 | 2030 | 12 | ||||||||||||
EST | Estonia | I-RK | Independent -- Raimond Kaljulaid | Independent – Raimond Kaljulaid | Independent -- Raimond Kaljulaid | none | no family | 75 | 2738 | 12 | ||||||||||||
EST | Estonia | I-SM | Independent -- Silver Meikar | Independent – Silver Meikar | Independent -- Silver Meikar | none | no family | 75 | 2345 | 12 | ||||||||||||
EST | Estonia | I-TT | Independent -- Tanel Talve | Independent – Tanel Talve | Independent -- Tanel Talve | none | no family | 75 | 2344 | 12 | ||||||||||||
EST | Estonia | SK | Independent Royalists | Sõltumatud Kuningriiklased | Soltumatud Kuningriiklased | spec | Special issue | 83901 | 75 | 25 | 16 | |||||||||||
EST | Estonia | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 75 | 426 | 12 | ||||||||||||
FIN | Finland | AS | Aland Coalition | Åländsk Samling | Alandsk Samling | spec | Special issue | 67 | 66 | 16 | ||||||||||||
FIN | Finland | Pi | Pirate Party Finland | Piraattipuolue | Piraattipuolue | spec | Special issue | 67 | 2412 | 16 | ||||||||||||
FIN | Finland | SEP | Finnish Pensioners Party | Suomen Eläkeläisten Puolue– Finlands Pensionärers Parti | Suomen Elakelaisten Puolue -- Finlands Pensionarers Parti | spec | Special issue | 67 | 1576 | 16 | ||||||||||||
FIN | Finland | VEU | Anti-EU Movement | Vaihtoehto EU:Lle | Vaihtoehto EU:Lle | spec | Special issue | 67 | 1649 | 16 | ||||||||||||
FIN | Finland | VSL | League for Free Finland | Vapaan Suomen Liitto – Självständighetspartiet | Vapaan Suomen Liitto -- Sjalvstandighetspartiet | spec | Special issue | 85 | 67 | 979 | 16 | |||||||||||
FIN | Finland | no-seat | no seat | no seat | no seat | none | no family | 67 | 2054 | 12 | ||||||||||||
FIN | Finland | none | no party affiliation | ei kukaan – ingen | ei kukaan -- ingen | none | no family | 67 | 1119 | 12 | ||||||||||||
FIN | Finland | one-seat | one seat | one seat | one seat | none | no family | 67 | 2413 | 12 | ||||||||||||
FRA | France | IOM | Overseas Independents | Indépendants d'outre-mer | Independants d'outre-mer | spec | Special issue | 43 | 2277 | 16 | ||||||||||||
FRA | France | MIM | Martinican Independence Movement | Mouvement independantiste martiniquais | Mouvement independantiste martiniquais | spec | Special issue | 43 | 2077 | 16 | ||||||||||||
FRA | France | PA | Animalist Party | Parti animaliste | Parti animaliste | spec | Special issue | 43 | 2733 | 16 | ||||||||||||
FRA | France | etc | others | divers | divers | none | no family | 43 | 1328 | 12 | ||||||||||||
FRA | France | no-seat | no seat | no seat | no seat | none | no family | 43 | 2080 | 12 | ||||||||||||
FRA | France | none | no party affiliation | sans étiquette | sans etiquette | none | no family | 43 | 947 | 12 | ||||||||||||
FRA | France | one-seat | one seat | one seat | one seat | none | no family | 43 | 2859 | 12 | ||||||||||||
GBR | United Kingdom | CUK | Change UK | Change UK | Change UK | spec | Special issue | 44 | 2730 | 16 | ||||||||||||
GBR | United Kingdom | ED | English Democrats | English Democrats | English Democrats | spec | Special issue | 44 | 2062 | 16 | ||||||||||||
GBR | United Kingdom | R | Respect -- The Unity Coalition | Respect – The Unity Coalition | Respect -- The Unity Coalition | code | to be coded | 44 | 1057 | 28 | ||||||||||||
GBR | United Kingdom | RP | Referendum Party | Referendum Party | Referendum Party | spec | Special issue | 44 | 2103 | 16 | ||||||||||||
GBR | United Kingdom | RepLP | Republican Labour Party | Republican Labour Party | Republican Labour Party | code | to be coded | 44 | 1092 | 28 | ||||||||||||
GBR | United Kingdom | U | Unity | Unity | Unity | spec | Special issue | 44 | 349 | 16 | ||||||||||||
GBR | United Kingdom | UPUP | Ulster Popular Unionist Party | Ulster Popular Unionist Party | Ulster Popular Unionist Party | code | to be coded | 44 | 1566 | 28 | ||||||||||||
GBR | United Kingdom | UUUC | United Ulster Unionist Coalition | United Ulster Unionist Coalition | United Ulster Unionist Coalition | code | to be coded | 44 | 1363 | 28 | ||||||||||||
GBR | United Kingdom | etc | others | others | others | none | no family | 44 | 453 | 12 | ||||||||||||
GBR | United Kingdom | no-seat | no seat | no seat | no seat | none | no family | 44 | 2562 | 12 | ||||||||||||
GBR | United Kingdom | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 44 | 1599 | 12 |
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;