view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
274 rows where family_name_short = "lib" sorted by party_name_english
This data as json, CSV (advanced)
Suggested facets: castles_mair
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ITA | Italy | CD | Democratic Centre | Centro Democratico | Centro Democratico | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 2153 | 6 | ||||||||
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 | ||||||||
NZL | New Zealand | ACT | ACT New Zealand | ACT New Zealand | ACT New Zealand | lib | Liberal | 9.0263 | 8.9751 | 3.6 | 64420 | 7220 | 11 | 617 | 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 | ||||||||
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 | ||||||||
SVN | Slovenia | AS | Active Slovenia | Aktivna Slovenija | Aktivna Slovenija | lib | Liberal | 4.6 | 3.8 | 2.6 | 7.3333 | 2909 | 60 | 380 | 6 | |||||||
BEL | Belgium | V | Alive | Vivant | Vivant | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 64 | 620 | 6 | ||||||||
ISR | Israel | Kulanu | All of Us | Kulanu | Kulanu | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2410 | 6 | |||||||||
PRT | Portugal | A | Alliance | Aliança | Alianca | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 63 | 2756 | 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 | ||||||||
SVK | Slovakia | ADS | Alliance of Democrats | Aliancia demokratov Slovenska | Aliancia demokratov Slovenska | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 96431 | 1 | 1624 | 6 | |||||||
HUN | Hungary | SzDSz | Alliance of Free Democrats | Szabad Demokraták Szövetsége | Szabad Demokratak Szovetsege | lib | Liberal | 3.9659 | 7.7361 | 1.4381 | 9.7873 | 86422 | 163 | 1348422 | 1602 | 2028 | 2304 | 39 | 1426 | 6 | ||
SVK | Slovakia | ANO | Alliance of the New Citizen | Aliancia nového občana | Aliancia noveho obcana | lib | Liberal | 7.2404 | 7.945 | 1.9712 | 9.4714 | 96424 | 3850 | 2806 | 1 | 1200 | 6 | |||||
AUS | Australia | AP | Australia Party | Australia Party | Australia Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1760 | 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 | ||||||||
DEU | Germany | BBB | Bavarian Peasants' League | Bayerischer Bauernbund | Bayerischer Bauernbund | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 54 | 2701 | 6 | ||||||||
ISR | Israel | KL | Blue and White | Kahol Lavan | Kahol Lavan | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2725 | 6 | |||||||||
ISR | Israel | G | Bridge | Gesher | Gesher | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2787 | 6 | |||||||||
ISL | Iceland | BF | Bright Future | Björt framtíð | Bjort framtid | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 2204 | 6 | |||||||||
BGR | Bulgaria | BBB | Bulgarian Business Bloc | Balgarski Biznes Blok | Balgarski Biznes Blok | lib | Liberal | 6.6784 | 7.076 | 5.1974 | 7.6842 | 80901 | 708 | 737 | 10 | 599 | 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 | ||||||||
BGR | Bulgaria | CSD | Centre -- Freedom and Dignity | Tsentŭr – Svoboda i dostoĭnstvo | Center -- Svoboda i dostojnstvo | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2595 | 6 | ||||||||
ISL | Iceland | M | Centre Party | Miðflokkurinn | Midflokkurinn | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 2655 | 6 | |||||||||
ISR | Israel | MiHa | Centre Party | Mifleget Hamerkaz | Mifleget Hamerkaz | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 1863 | 6 | |||||||||
LTU | Lithuania | LCS | Centre Union of Lithuania | Lietuvos centro sąjunga | Lietuvos centro sajunga | lib | Liberal | 4.8833 | 6.25 | 4.2 | 9.0 | 88420 | 2403 | 2509 | 15 | 887 | 6 | |||||
FRA | France | AC | Centrist Alliance | Alliance centriste | Alliance centriste | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 43 | 2078 | 6 | ||||||||
AUT | Austria | BD | Centrist Democrats | Bürgerliche Demokraten | Buergerliche Demokraten | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 59 | 2688 | 6 | ||||||||
ISR | Israel | Shinui | Change | Shinui | Shinui | lib | Liberal | 5.4776 | 8.6207 | 1.7423 | 72413 | 6572 | 34 | 1850 | 6 | |||||||
SVK | Slovakia | ZZ | Change from the Bottom, DU | Zmena zdola, DÚ | Zmena zdola, DU | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 1 | 2013 | 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 | ||||||||
ITA | Italy | SC | Civic Choice | Scelta Civica | Scelta Civica | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 2156 | 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 | ||||||
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 | ||||||||
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 | |||||||
SVN | Slovenia | DL | Civic List | Državljanska lista | Drzavljanska lista | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 60 | 1988 | 6 | ||||||||
ISL | Iceland | B-H | Civic Movement -- The Movement | Borgarahreyfingin – Hreyfingin | Borgarahreyfingin -- Hreyfingin | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 587 | 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 | 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 | ||||||||
GBR | United Kingdom | CoLib | Coalition Liberal | Coalition Liberal | Coalition Liberal | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 44 | 2501 | 6 | ||||||||
MLT | Malta | PK | Constitutionalist Party | Partit Kostituzzjonali | Partit Kostituzzjonali | lib | Liberal | 6.0 | 6.7 | 3.6 | 72 | 1033 | 6 | |||||||||
AUS | Australia | CouLP | Country Liberal Party | Country Liberal Party | Country Liberal Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 215 | 6 | |||||||||
ISR | Israel | O | Courage | Ometz | Ometz | lib | Liberal | 6.0 | 6.7 | 3.6 | 72425 | 34 | 61 | 6 | ||||||||
HRV | Croatia | HNS-LD | Croatian People's Party -- Liberal Democrats | Hrvatska narodna stranka – Liberalni demokrati | Hrvatska narodna stranka -- Liberalni demokrati | lib | Liberal | 1.8421 | 6.5789 | 1.7544 | 8.9474 | 81712 | 1120 | 3105 | 62 | 1384 | 6 | |||||
HRV | Croatia | HSLS | Croatian Social Liberal Party | Hrvatska socijalno liberalna stranka | Hrvatska socijalno liberalna stranka | lib | Liberal | 7.193 | 4.6491 | 5.5263 | 5.0877 | 81410 | 1146 | 3104 | 62 | 1102 | 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 | ||||||||
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 |
ITA | Italy | DL-M | Democracy is Freedom -- The Daisy | Democrazia è Libertà – La Margherita | Democrazia e Liberta -- La Margherita | lib | Liberal | 3.9893 | 4.2347 | 4.7353 | 9.2935 | 32421 | 6746 | 819 | 26 | 1005 | 6 | |||||
NZL | New Zealand | DP | Democrat Party | Democrat Party | Democrat Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 11 | 2468 | 6 | |||||||||
CYP | Cyprus | DP | Democratic Alignment | Dimokratiki Parataxi | Dimokratiki Parataxi | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 2741 | 6 | |||||||||
GRC | Greece | DISY | Democratic Alliance | Dimokratiki Symmachia | Dimokratiki Symmachia | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 41 | 2094 | 6 | ||||||||
PRT | Portugal | AD | Democratic Alliance | Aliança Democrática | Alianca Democratica | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 63 | 1543 | 6 | ||||||||
HRV | Croatia | DC | Democratic Centre | Demokratski centar | Demokratski centar | lib | Liberal | 5.9649 | 4.8421 | 6.4912 | 7.3684 | 1042 | 62 | 1081 | 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 | |||||||
ROU | Romania | PD-L | Democratic Liberal Party | Partidul Democrat-Liberal | Partidul Democrat-Liberal | lib | Liberal | 5.3875 | 5.1868 | 3.9647 | 9.5309 | 248 | 1642400 | 3226 | 2704 | 23 | 958 | 6 | ||||
LUX | Luxembourg | DeLe | Democratic List | Demokratesch Lëscht | Demokratesch Lescht | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2448 | 6 | |||||||||
ISR | Israel | TDL | Democratic Movement for Change | Tnu'a Demokratit LeShinu | Tnu'a Demokratit LeShinu | lib | Liberal | 5.4776 | 8.6207 | 1.7423 | 72412 | 6572 | 34 | 1471 | 6 | |||||||
LUX | Luxembourg | DP | Democratic Party | Demokratesch Partei | Demokratesch Partei | lib | Liberal | 6.5789 | 7.3684 | 2.7632 | 23420 | 212 | 1442420 | 903 | 6926 | 7 | 967 | 6 | ||||
MLT | Malta | PD | Democratic Party | Partit Demokratiku | Partit Demokratiku | lib | Liberal | 6.0 | 6.7 | 3.6 | 72 | 2759 | 6 | |||||||||
ROU | Romania | PD | Democratic Party | Partidul Democrat | Partidul Democrat | lib | Liberal | 5.3875 | 5.1868 | 3.9647 | 9.5309 | 93322 | 3226 | 2704 | 23 | 419 | 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 | |||||||
CZE | Czech Republic | DU | Democratic Union | Demokratická unie | Demokraticka unie | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 68 | 1616 | 6 | ||||||||
ITA | Italy | UD | Democratic Union | Unione Democratica | Unione Democratica | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 475 | 6 | ||||||||
SVK | Slovakia | DUS | Democratic Union | Demokratická únia | Demokraticka unia | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 96421 | 1 | 1495 | 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 | ||||||||
POL | Poland | D|W|U | Democratic | Freedom | Union | Demokratyczna | Wolności | Unia | Demokratyczna | Wolnosci | Unia | lib | Liberal | 5.2295 | 7.3132 | 2.1208 | 9.7641 | 92434 | 3180 | 2609 | 74 | 1104 | 6 | |||||
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 |
BGR | Bulgaria | DOST | Democrats for Responsibility, Solidarity and Tolerance | Demokrati za Otgovornost, Svoboda i Tolerantnost | Demokrati za Otgovornost, Svoboda i Tolerantnost | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2639 | 6 | ||||||||
NLD | Netherlands | EB | Economic League | Economische Bond | Economische Bond | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 8 | 2457 | 6 | ||||||||
AUS | Australia | EC-SA | Emergency Committee (SA) | Emergency Committee (SA) | Emergency Committee (SA) | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1904 | 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 | ||||||||
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 | 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 | ||||||||
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 | 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 | ERe | Estonian Reform Party | Eesti Reformierakond | Eesti Reformierakond | lib | Liberal | 7.8969 | 8.6246 | 5.2737 | 8.5715 | 83430 | 82 | 1233430 | 1208 | 1794 | 2203 | 75 | 113 | 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 | |||||||
CYP | Cyprus | EK | European Party | Evropaiko Komma | Evropaiko Komma | lib | Liberal | 6.0 | 6.7 | 3.6 | 52 | 1196600 | 51 | 491 | 6 | |||||||
ITA | Italy | MRE | European Republicans Movement | Movimento Repubblicani Europei | Movimento Repubblicani Europei | lib | Liberal | 4.33 | 4.75 | 3.83 | 10.0 | 832 | 26 | 760 | 6 | |||||||
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 | |||||||||
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 | ||||||||
SVK | Slovakia | ZAL | For the People | Za ľudí | Za ludi | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 1 | 2796 | 6 | ||||||||
ISR | Israel | Kadima | Forward | Kadima | Kadima | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 1870 | 6 | |||||||||
BEL | Belgium | FDF | Francophone Democratic Front | Front Démocratique des Francophones | DéFI | Front Democratique des Francophones | lib | Liberal | 6.1259 | 6.25 | 5.8 | 8.7274 | 21912 | 306 | 408 | 111 | 111 | 64 | 969 | 6 | |||
ISR | Israel | MeHo | Free Centre | HaMerkaz HaHofshi | HaMerkaz HaHofshi | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 1889 | 6 | |||||||||
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 |
SVK | Slovakia | SF | Free Forum | Slobodné fórum | Slobodne forum | lib | Liberal | 5.46 | 6.58 | 3.18 | 7.95 | 1703524 | 2811 | 1 | 752 | 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 | ||||||||
AUS | Australia | FTP | Free Trade Party | Free Trade Party | Free Trade Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1938 | 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 | ||||||||
LTU | Lithuania | LP | Freedom Party | Laisvės partija | Laisves partija | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 15 | 2805 | 6 | ||||||||
SVK | Slovakia | SSL | Freedom Party | Strana slobody | Strana slobody | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 1 | 2232 | 6 | ||||||||
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 | ||||
SVK | Slovakia | SaS | Freedom and Solidarity | Sloboda a solidarita | Sloboda a solidarita | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 2812 | 1 | 1460 | 6 | |||||||
ISR | Israel | ZK | General Zionists | Zionim Klalim | Zionim Klalim | lib | Liberal | 6.0 | 6.7 | 3.6 | 72420 | 34 | 1472 | 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 | ||||||||
AUT | Austria | DD | German-Democrats | Deutschdemokraten | Deutschdemokraten | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 59 | 2675 | 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 | ||||||||
ISL | Iceland | He | Home Rule Party | Heimastjórnarflokkurinn | Heimastjrnarflokkurinn | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 2440 | 6 | |||||||||
PRT | Portugal | MEP | Hope for Portugal Movement | Movimento Esperança Portugal | Movimento Esperanca Portugal | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 235 | 63 | 925 | 6 | |||||||
FRA | France | H | Horizons | Horizons | Horizons | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 43 | 2857 | 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;