view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by eu_anti_pro descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BGR | Bulgaria | SNI | "New Choice" Union | Suyuz "Nov izbor" | Suyuz "Nov izbor" | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2176 | 6 | ||||||||
BGR | Bulgaria | VB | Volt Bulgaria | Volt Bulgaria | Volt Bulgaria | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2869 | 6 | ||||||||
CHE | Switzerland | LF/PEB | Liberal Socialist Party | Liberalsozialistische Partei / Freiwirtschaftliche Bewegung – Parti d'économie franche | Liberalsozialistische Partei / Freiwirtschaftliche Bewegung -- Parti d economie franche | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 40 | 1960 | 6 | ||||||||
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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | VV | Public Affairs | Věci veřejné | Veci verejne | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 2110 | 68 | 336 | 6 | |||||||
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 | 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 | FVP | Free People's Party | Freie Volkspartei | Freie Volkspartei | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 54 | 358 | 6 | ||||||||
DNK | Denmark | At | Solidarity (Greenland) | Atassut | Atassut | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 21 | 2575 | 6 | ||||||||
DNK | Denmark | DU | Independents Party | De Uafhængige | De Uafhaengige | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 13421 | 21 | 538 | 6 | |||||||
DNK | Denmark | EP | Industry Party | Erhvervspartiet | Erhvervspartiet | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 21 | 2429 | 6 | ||||||||
DNK | Denmark | LC | Liberal Centre | Liberalt Centrum | Liberalt Centrum | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 13422 | 21 | 1478 | 6 | |||||||
DNK | Denmark | M | Moderates | Moderaterne | Moderaterne | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 21 | 2887 | 6 | ||||||||
DNK | Denmark | MV | Moderate Liberals | Moderate Venstre | Moderate Venstre | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 21 | 2430 | 6 | ||||||||
DNK | Denmark | NLA | New-Liberal Alliance | Ny-Liberal Alliance | Ny-Liberal Alliance | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 72 | 1208421 | 218 | 21 | 376 | 6 | |||||
ESP | Spain | Cs | Citizens -- Party of the Citizenry | Ciudadanos – Partido de la Ciudadanía | Ciudadanos -- Partido de la Ciudadania | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 27 | 2375 | 6 | ||||||||
ESP | Spain | PDP | Popular Democratic Party | Partido Demócrata Popular | Partido Democrata Popular | lib | Liberal | 5.9944 | 6.7 | 3.6 | 8.7 | 33438 | 1410 | 3605 | 27 | 1224 | 6 | |||||
ESP | Spain | PL | Liberal Party | Partido Liberal | Partido Liberal | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 33439 | 27 | 424 | 6 | |||||||
ESP | Spain | UCD | Union of the Democratic Centre | Unión de Centro Democrático | Union de Centro Democratico | lib | Liberal | 7.1 | 6.7 | 3.6 | 8.7 | 33430 | 1410 | 27 | 135 | 6 | ||||||
ESP | Spain | UPyD | Union, Progress and Democracy | Unión Progreso y Democracia | Union Progreso y Democracia | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 276 | 1724010 | 523 | 27 | 551 | 6 | |||||
EST | Estonia | E200 | Estonia 200 | Erakond Eesti 200 | Erakond Eesti 200 | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 75 | 2720 | 6 | ||||||||
EST | Estonia | EEE | Estonian Entrepreneur Party | Eesti Ettevõtjate Erakond | Eesti Ettevotjate Erakond | lib | Liberal | 8.3333 | 6.7 | 3.6 | 8.7 | 1211 | 75 | 1516 | 6 | |||||||
EST | Estonia | EKK | Estonian Coalition Party | Eesti Koonderakond | Eesti Koonderakond | lib | Liberal | 7.2222 | 6.7 | 3.6 | 8.7 | 83713 | 1209 | 75 | 486 | 6 | ||||||
EST | Estonia | ESE-D | Estonian Blue Party -- Democrats | Eesti Sinine Erakond – Demokraadid | Eesti Sinine Erakond -- Demokraadid | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 75 | 2267 | 6 | ||||||||
FIN | Finland | LN | Movement Now | Liike Nyt | Liike Nyt | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 67 | 2801 | 6 | ||||||||
FIN | Finland | NSP | Young Finns | Nuorsuomalaiset – Ungfinnarna | Nuorsuomalaiset -- Ungfinnarna | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 14430 | 1412 | 67 | 1009 | 6 | ||||||
FIN | Finland | VL | Liberal League | Vapaamielisten Liitto – De Frisinnades Förbund | Vapaamielisten Liitto -- De Frisinnades Forbund | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 67 | 1109 | 6 | ||||||||
FRA | France | AC | Centrist Alliance | Alliance centriste | Alliance centriste | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 43 | 2078 | 6 | ||||||||
FRA | France | H | Horizons | Horizons | Horizons | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 43 | 2857 | 6 | ||||||||
FRA | France | NC | New Centre | Nouveau centre | Nouveau centre | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 43 | 1058 | 6 | ||||||||
FRA | France | REM|R | The Republic Onwards! | Renaissance | La République En Marche! | Renaissance | La Republique En Marche! | Renaissance | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 43 | 2643 | 6 | ||||||||
FRA | France | Rep | Republicans | Republicans | Republicans | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 43 | 2592 | 6 | ||||||||
FRA | France | RepG | Left Republican | Républicaine gauche | Republicaine gauche | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 43 | 2587 | 6 | ||||||||
FRA | France | d-center | other centre | divers centre | divers centre | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 43 | 2858 | 6 | ||||||||
GBR | United Kingdom | APoNI | Alliance Party of Northern Ireland | Alliance Party of Northern Ireland | Alliance Party of Northern Ireland | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 44 | 2731 | 6 | ||||||||
GBR | United Kingdom | CoLib | Coalition Liberal | Coalition Liberal | Coalition Liberal | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 44 | 2501 | 6 | ||||||||
GBR | United Kingdom | IL | Independent Liberal | Independent Liberal | Independent Liberal | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 44 | 2517 | 6 | ||||||||
GBR | United Kingdom | NLP | National Liberal Party | National Liberal Party | National Liberal Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 44 | 1017 | 6 | ||||||||
GRC | Greece | D-FS | Action -- Liberal Alliance | Drasi – Fileleytheri Symmachia | Drasi -- Fileleytheri Symmachia | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 41 | 2096 | 6 | ||||||||
GRC | Greece | DISY | Democratic Alliance | Dimokratiki Symmachia | Dimokratiki Symmachia | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 41 | 2094 | 6 | ||||||||
GRC | Greece | EDIK | Union of the Democratic Centre | Enosi Dimokratikou Kentrou | Enosi Dimokratikou Kentrou | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 34510 | 41 | 489 | 6 | |||||||
GRC | Greece | EEP | Greek European Citizens | Ellines Eyropaioi Polites | Ellines Eyropaioi Polites | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 41 | 2347 | 6 | ||||||||
GRC | Greece | KF | Liberal Party | Komma ton Fileleftheron | Komma ton Fileleftheron | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 41 | 2125 | 6 | ||||||||
GRC | Greece | KN | Party of New Liberals | Komma Neofileleftheron | Komma Neofileleftheron | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 41 | 463 | 6 | ||||||||
GRC | Greece | OF | The Liberals | Oi Fileleftheroi | Oi Fileleftheroi | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 41 | 2166 | 6 | ||||||||
HRV | Croatia | NS | People's Party -- Reformists | Narodna stranka – Reformisti | Narodna stranka -- Reformisti | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 62 | 2614 | 6 | ||||||||
HRV | Croatia | P | Intelligently | Pametno | Pametno | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 62 | 2772 | 6 | ||||||||
HUN | Hungary | MEMO | Solution Movement | Megoldás Mozgalom | Megoldas Mozgalom | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 39 | 2855 | 6 | ||||||||
HUN | Hungary | VP | Entrepreneurs' Party | Vállalkozók Pártja Egyesület | Vallalkozok Partja Egyesulet | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 39 | 1203 | 6 | ||||||||
IRL | Ireland | BP | Business and Professional Group | Business and Professional Group | Business and Professional Group | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 37 | 2523 | 6 | ||||||||
IRL | Ireland | I-PC | Independent -- Pat Cox | Independent – Pat Cox | Independent -- Pat Cox | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 37 | 2328 | 6 | ||||||||
ITA | Italy | +EU | More Europe | +Europa | +Europa | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 2737 | 6 | ||||||||
ITA | Italy | ALD | Autonomy Liberty Democracy | Autonomie Liberté Démocratie | Autonomie Liberte Democratie | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 1063 | 6 | ||||||||
ITA | Italy | CD | Democratic Centre | Centro Democratico | Centro Democratico | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 2153 | 6 | ||||||||
ITA | Italy | CDR | Republican Democratic Concentration | Concentrazione Democratica Repubblicana | Concentrazione Democratica Repubblicana | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 2044 | 6 | ||||||||
ITA | Italy | FiD | Stop the Decline | Fermare il Declino | Fermare il Declino | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 2158 | 6 | ||||||||
ITA | Italy | IV | Italy Alive | Italia Viva | Italia Viva | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 2794 | 6 | ||||||||
ITA | Italy | LD | Liberal Democrats | Liberal Democratici | Liberal Democratici | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 906 | 6 | ||||||||
ITA | Italy | PLD | Liberal Democratic Pole | Polo Liberal-Democratico | Polo Liberal-Democratico | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 671 | 6 | ||||||||
ITA | Italy | SC | Civic Choice | Scelta Civica | Scelta Civica | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 2156 | 6 | ||||||||
ITA | Italy | UD | Democratic Union | Unione Democratica | Unione Democratica | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 475 | 6 | ||||||||
ITA | Italy | UdCe | Democratic Union of the Centre | Unione Democratica di Centro | Unione Democratica di Centro | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 397 | 6 | ||||||||
LTU | Lithuania | LDP | Lithuanian Democratic Party | Lietuvos demokratų partija | Lietuvos demokratu partija | lib | Liberal | 5.8333 | 6.7 | 3.6 | 8.7 | 88522 | 2407 | 15 | 1144 | 6 | ||||||
LTU | Lithuania | LLS | Lithuanian Freedom Union (Liberals) | Lietuvos laisvės sąjunga (liberalai) | Lietuvos laisves sajunga (liberalai) | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 15 | 2634 | 6 | ||||||||
LTU | Lithuania | LP | Freedom Party | Laisvės partija | Laisves partija | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 15 | 2805 | 6 | ||||||||
LTU | Lithuania | PDP | Civic Democratic Party | Pilietinės demokratijos partija | Pilietines demokratijos partija | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 15 | 676 | 6 | ||||||||
LTU | Lithuania | TAIP | YES -- Homeland Revival and Perspective | Tėvynės atgimimas ir perspektyva | Tevynes atgimimas ir perspektyva | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 15 | 2122 | 6 | ||||||||
LTU | Lithuania | TPP | National Resurrection Party | Tautos prisikėlimo partija | Tautos prisikelimo partija | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 208 | 1440001 | 2517 | 15 | 1502 | 6 | |||||
LVA | Latvia | DCP | Democratic Centre Party | Demokrātiskā Centra Partija | Demokratiska Centra Partija | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 87430 | 55 | 384 | 6 | |||||||
LVA | Latvia | DPS | Democratic Party Saimnieks | Demokrātiskā partija "Saimnieks" | Demokratiska partija "Saimnieks" | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 87411 | 55 | 759 | 6 | |||||||
LVA | Latvia | KP | Movement For! | Kustība Par! | Kustiba Par! | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 55 | 2808 | 6 | ||||||||
LVA | Latvia | LA | For Latvia's Development | Latvijas attīstībai | Latvijas attistibai | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 55 | 2392 | 6 | ||||||||
LVA | Latvia | SCP | Society for Other Politics | Sabiedrība citai politikai | Sabiedriba citai politikai | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 194 | 1428425 | 55 | 962 | 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 | ||||||||
LVA | Latvia | ViLa | United for Latvia | Vienoti Latvijai | Vienoti Latvijai | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 55 | 2367 | 6 | ||||||||
NLD | Netherlands | BVL | League of Free Liberals | Bond van Vrije Liberalen | Bond van Vrije Liberalen | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 8 | 2459 | 6 | ||||||||
NLD | Netherlands | EB | Economic League | Economische Bond | Economische Bond | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 8 | 2457 | 6 | ||||||||
NLD | Netherlands | LSP | Liberal State Party "The Freedom League" | Liberale Staatspartij "de Vrijheidsbond" | Liberale Staatspartij "de Vrijheidsbond" | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 8 | 2461 | 6 | ||||||||
NLD | Netherlands | LU | Liberal Union | Liberale Unie | Liberale Unie | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 8 | 2462 | 6 | ||||||||
NLD | Netherlands | MPSL | Middle Party for City and Country | Middenpartij voor Stad en Land | Middenpartij voor Stad en Land | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 8 | 2714 | 6 | ||||||||
NLD | Netherlands | VDB | Free-thinking Democratic League | Vrijzinnig Democratische Bond | Vrijzinnig Democratische Bond | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 8 | 944 | 6 | ||||||||
NOR | Norway | DLF | Liberal People's Party | Det Liberale Folkepartiet | Det Liberale Folkepartiet | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 12410 | 9 | 1209 | 6 | |||||||
NOR | Norway | FV | Liberal Left Party | Frisinnede Venstre | Frisinnede Venstre | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 9 | 2472 | 6 | ||||||||
NOR | Norway | MV | Moderate Liberal Party | Moderate Venstre | Moderate Venstre | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 9 | 2473 | 6 | ||||||||
POL | Poland | KLD | Liberal Democratic Congress | Kongres Liberalno-Demokratyczny | Kongres Liberalno-Demokratyczny | lib | Liberal | 5.2778 | 6.7 | 3.6 | 8.7 | 92420 | 3004 | 74 | 1544 | 6 | ||||||
POL | Poland | N | Modern | Nowoczesna | Nowoczesna | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 74 | 2601 | 6 | ||||||||
POL | Poland | PPG | Polish Economic Program [Large Beer] | Polski Program Gospodarczy [Duże Piwo] | Polski Program Gospodarczy [Duze Piwo] | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 92433 | 74 | 1691 | 6 | |||||||
POL | Poland | RP | Your (Palikot's) Movement | Twój Ruch (Palikota) | Twoj Ruch (Palikota) | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 74 | 1945 | 6 | ||||||||
PRT | Portugal | A | Alliance | Aliança | Alianca | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 63 | 2756 | 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;