view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
274 rows where family_name = "Liberal" sorted by state_market
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LVA | Latvia | TSP | National Harmony Party | Tautas Saskaņas Partija | Tautas Saskanas Partija | lib | Liberal | 1.864 | 2.1751 | 5.2767 | 5.7675 | 87421 | 2184 | 2402 | 55 | 32 | 6 | |||||
SVN | Slovenia | AS | Active Slovenia | Aktivna Slovenija | Aktivna Slovenija | lib | Liberal | 4.6 | 3.8 | 2.6 | 7.3333 | 2909 | 60 | 380 | 6 | |||||||
GBR | United Kingdom | Lib | Liberals | Liberals | Liberals | lib | Liberal | 4.2875 | 4.1064 | 2.6109 | 9.2231 | 51420 | 1605 | 1104 | 1104 | 44 | 659 | 6 | ||||
LTU | Lithuania | NS-SL | New Union (Social Liberals) | Naujoji sąjunga (socialliberalai) | Naujoji sajunga (socialliberalai) | lib | Liberal | 4.2686 | 4.1125 | 4.9071 | 8.6647 | 88410 | 1440410 | 2376 | 2504 | 15 | 856 | 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 | |||||
LTU | Lithuania | DP | Labour Party | Darbo partija | Darbo partija | lib | Liberal | 3.86 | 4.29 | 5.8 | 8.5667 | 199 | 1440322 | 2516 | 15 | 581 | 6 | |||||
BGR | Bulgaria | DPS | Movement for Rights and Freedoms | Dvizhenie za Prava i Svobodi | Dvizhenie za Prava i Svobodi | lib | Liberal | 4.5828 | 4.413 | 6.229 | 9.0094 | 80951 | 31 | 1100900 | 894 | 2004 | 10 | 1286 | 6 | |||
ITA | Italy | IdV | Italy of Values | Italia dei Valori | Italia dei Valori | lib | Liberal | 4.8712 | 4.5664 | 5.5255 | 7.1295 | 32902 | 176 | 1380902 | 6686 | 828 | 26 | 693 | 6 | |||
SVN | Slovenia | LDS | Liberal Democracy of Slovenia | Liberalna demokracija Slovenije | Liberalna demokracija Slovenije | lib | Liberal | 3.7351 | 4.6316 | 2.5756 | 9.1901 | 97421 | 261 | 1705421 | 4209 | 2901 | 60 | 1252 | 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 | |||||
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 | |||||||
HRV | Croatia | DC | Democratic Centre | Demokratski centar | Demokratski centar | lib | Liberal | 5.9649 | 4.8421 | 6.4912 | 7.3684 | 1042 | 62 | 1081 | 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 |
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 | |||||
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 | ||||
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 |
CAN | Canada | LP | Liberal Party of Canada | Liberal Party of Canada | Liberal Party of Canada | lib | Liberal | 5.0552 | 5.3509 | 3.4615 | 62420 | 402 | 803 | 5273 | 29 | 368 | 6 | |||||
ISL | Iceland | Ff | Liberal Party | Frjálslyndi flokkurinn | Frjalslyndi flokkurinn | lib | Liberal | 6.2201 | 5.5981 | 3.0 | 15420 | 6231 | 56 | 506 | 6 | |||||||
ITA | Italy | PRI | Republican Party | Partito Repubblicano Italiano | Partito Repubblicano Italiano | lib | Liberal | 4.9704 | 5.8 | 5.1667 | 9.0278 | 32410 | 1006 | 2106 | 806 | 806 | 26 | 93 | 6 | |||
BGR | Bulgaria | NDSV | National Movement Simeon II | Natsionalno Dvizhenie Simeon Vtori | Natsionalno Dvizhenie Simeon Vtori | lib | Liberal | 5.7567 | 5.8948 | 4.008 | 9.3468 | 80902 | 32 | 1100400 | 946 | 2001 | 10 | 544 | 6 | |||
NOR | Norway | V | Liberal Party of Norway | Venstre | Venstre | lib | Liberal | 5.1467 | 5.9148 | 3.2581 | 4.0766 | 12420 | 1303 | 2906 | 1508 | 7614 | 3507 | 9 | 647 | 6 | ||
CYP | Cyprus | ED | United Democrats | Enomeni Dimokrates | Enomeni Dimokrates | lib | Liberal | 7.1053 | 6.0526 | 4.3421 | 55423 | 5423 | 51 | 1523 | 6 | |||||||
HRV | Croatia | IDS | Istrian Democratic Assembly | Istarski demokratski sabor | Istarski demokratski sabor | lib | Liberal | 3.4211 | 6.2281 | 2.5439 | 9.2105 | 81953 | 1224 | 62 | 1627 | 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 | |||
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 | |||||
NZL | New Zealand | UFNZ | United Future New Zealand | United Future New Zealand | United Future New Zealand | lib | Liberal | 6.1219 | 6.3158 | 3.6 | 64421 | 7332 | 11 | 1313 | 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 | LS | Liberal Party | Liberalna stranka | Liberalna stranka | lib | Liberal | 2.807 | 6.5789 | 1.4035 | 8.5965 | 1276 | 62 | 1457 | 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 | ||||||
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 | |||||
AUS | Australia | AP | Australia Party | Australia Party | Australia Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1760 | 6 | |||||||||
AUS | Australia | CouLP | Country Liberal Party | Country Liberal Party | Country Liberal Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 215 | 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 | |||||||||
AUS | Australia | FTP | Free Trade Party | Free Trade Party | Free Trade Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1938 | 6 | |||||||||
AUS | Australia | LD-NSW | Liberal Democratic Party (New South Wales) | Liberal Democratic Party (New South Wales) | Liberal Democratic Party (New South Wales) | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1927 | 6 | |||||||||
AUS | Australia | LNPQ | Liberal National Party of Queensland | Liberal National Party of Queensland | Liberal National Party of Queensland | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 154 | 6 | |||||||||
AUS | Australia | NXT | Nick Xenophon Team | Nick Xenophon Team | Nick Xenophon Team | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 2630 | 6 | |||||||||
AUS | Australia | PUP | Palmer United Party | Palmer United Party | Palmer United Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 2259 | 6 | |||||||||
AUS | Australia | WAP | Western Australian Party | Western Australian Party | Western Australian Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1906 | 6 | |||||||||
AUT | Austria | BD | Centrist Democrats | Bürgerliche Demokraten | Buergerliche Demokraten | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 59 | 2688 | 6 | ||||||||
AUT | Austria | DD | German-Democrats | Deutschdemokraten | Deutschdemokraten | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 59 | 2675 | 6 | ||||||||
AUT | Austria | NEOS | NEOS -- The New Austria | NEOS – Das Neue Österreich | NEOS -- Das Neue Oesterreich | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 59 | 2255 | 6 | ||||||||
AUT | Austria | TS | Team Stronach | Team Stronach | Team Stronach | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 59 | 2150 | 6 | ||||||||
BEL | Belgium | LD|LDD | List Dedecker | Libertarian, Direct, Democratic | Lijst Dedecker | Libertair, Direct, Democratisch | Lijst Dedecker | Libertair, Direct, Democratisch | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 14 | 1056600 | 117 | 64 | 221 | 6 | |||||
BEL | Belgium | LP-PL | Liberal Party | Liberale Partij – Parti libéral | Liberale Partij -- Parti liberal | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 21420 | 64 | 63 | 6 | |||||||
BEL | Belgium | PL(B) | Liberal Party [Brussels Region] | Parti Libéral [Région bruxelloise] | Parti Liberal [Region bruxelloise] | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 21424 | 64 | 640 | 6 | |||||||
BEL | Belgium | ROSSEM | Radical Reformers Fighting for an Upright Society | Radikale Omvormers Strijdersen Stubbelaars vor Maatschappij | Radikale Omvormers Strijdersen Stubbelaars vor Maatschappij | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 113 | 64 | 748 | 6 | |||||||
BEL | Belgium | Spirit | Spirit | Spirit | Spirit | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 20 | 1056328 | 118 | 64 | 1487 | 6 | |||||
BEL | Belgium | V | Alive | Vivant | Vivant | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 64 | 620 | 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 | ||||||||
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 | ||||||||
BGR | Bulgaria | DaB | Yes, Bulgaria! | Da Bulgaria! | Da Bulgaria! | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2638 | 6 | ||||||||
BGR | Bulgaria | Lider | Lider | Lider | Lider | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 2011 | 10 | 566 | 6 | |||||||
BGR | Bulgaria | SDS-l | Union of Democratic Forces -- Liberal | Suyuz na Demokratichnite Sili – Liberali | Suyuz na Demokratichnite Sili -- Liberali | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2175 | 6 | ||||||||
BGR | Bulgaria | SEK | Middle European Class | Sredna evropeĭska klasa | Sredna evropeiska klasa | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2870 | 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 | ||||||||
BGR | Bulgaria | VB | Volt Bulgaria | Volt Bulgaria | Volt Bulgaria | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2869 | 6 | ||||||||
CAN | Canada | L-P | Liberal-Progressive | Liberal-Progressive | Liberal-Progressive | lib | Liberal | 6.0 | 6.7 | 3.6 | 29 | 2011 | 6 | |||||||||
CAN | Canada | LL | Liberal-Labour | Liberal-Labour | Liberal-Labour | lib | Liberal | 6.0 | 6.7 | 3.6 | 29 | 2085 | 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 | ||||||||
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 | Anex | Independents Movement | Independents Movement | Independents Movement | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 2817 | 6 | |||||||||
CYP | Cyprus | DP | Democratic Alignment | Dimokratiki Parataxi | Dimokratiki Parataxi | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 2741 | 6 | |||||||||
CYP | Cyprus | EK | European Party | Evropaiko Komma | Evropaiko Komma | lib | Liberal | 6.0 | 6.7 | 3.6 | 52 | 1196600 | 51 | 491 | 6 | |||||||
CYP | Cyprus | EnKe | Union Centre | Enosi Kentrou | Enosi Kentrou | lib | Liberal | 6.0 | 6.7 | 3.6 | 51 | 1777 | 6 | |||||||||
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 | |||||||||
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 | |||||
DNK | Denmark | RF | Justice Party | Retsforbund | Retsforbund | lib | Liberal | 6.0 | 6.7 | 3.6 | 0.2333 | 13952 | 205 | 21 | 1606 | 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 |
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;