view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by liberty_authority 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
FRA | France | R! | Reconquest | Reconquête | Reconquete | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 43 | 2860 | 40 | ||||||||
FRA | France | UR | Republican Union | Union républicaine | Union republicaine | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 43 | 2581 | 40 | ||||||||
FRA | France | ex-dro | other far-right | extrême droite | extreme droite | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 43 | 2079 | 40 | ||||||||
GBR | United Kingdom | BNP | British National Party | British National Party | British National Party | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 417 | 1826720 | 1109 | 44 | 1250 | 40 | |||||
GBR | United Kingdom | BP | Brexit Party | Brexit Party | Brexit Party | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 44 | 2729 | 40 | ||||||||
GBR | United Kingdom | IE | An Independence from Europe | An Independence from Europe | An Independence from Europe | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 44 | 2387 | 40 | ||||||||
GBR | United Kingdom | NDP | National Democratic and Labour Party | National Democratic and Labour Party | National Democratic and Labour Party | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 44 | 2503 | 40 | ||||||||
GBR | United Kingdom | NF | National Front | National Front | National Front | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 44 | 1126 | 40 | ||||||||
GBR | United Kingdom | NP | National Party | National Party | National Party | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 44 | 2504 | 40 | ||||||||
GBR | United Kingdom | VUPP | Vanguard Unionist Progressive Party | Vanguard Unionist Progressive Party | Vanguard Unionist Progressive Party | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 44 | 646 | 40 | ||||||||
GRC | Greece | ANEL | Independent Greeks | Anexartitoi Ellines | Anexartitoi Ellines | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 41 | 2091 | 40 | ||||||||
GRC | Greece | EDE | National Democratic Union | Ethnikή Dhmokratikή Έnwsis | Ethnikn Dhmokratikn Enwsis | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 41 | 2230 | 40 | ||||||||
GRC | Greece | EPEN | National Political Union | Ethniki Politiki Enosis | Ethniki Politiki Enosis | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 41 | 1162 | 40 | ||||||||
GRC | Greece | LS-CA | Peoples Association -- Golden Dawn | Laikos Syndesmos – Chrysi Avg | Laikos Syndesmos -- Chrysi Avg | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 41 | 2092 | 40 | ||||||||
HRV | Croatia | DP | Homeland Movement | Domovinski pokret | Domovinski pokret | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 62 | 2809 | 40 | ||||||||
HRV | Croatia | HDSSB | Croatian Democratic Alliance of Slavonia and Baranja | Hrvatski demokratski savez Slavonije i Baranje | Hrvatski demokratski savez Slavonije i Baranje | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 3107 | 62 | 2135 | 40 | |||||||
HRV | Croatia | HGS | Croatian Civic Party | Hrvatska građanska stranka | Hrvatska gradanska stranka | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 62 | 2193 | 40 | ||||||||
HRV | Croatia | HSP-1861 | Croatian Party of Right of 1861 | Hrvatska Stranka Prava 1861 | Hrvatska Stranka Prava 1861 | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 62 | 2199 | 40 | ||||||||
HRV | Croatia | HSP-AS | Croatian Party of Rights -- Dr. Ante Starcevic | Hrvatska stranka prava dr. Ante Starčević | Hrvatska stranka prava dr. Ante Starcevic | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 62 | 2181 | 40 | ||||||||
HRV | Croatia | ZDS | Democratic Party of Zagorje | Zagorska demokratska stranka | Zagorska demokratska stranka | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 62 | 2610 | 40 | ||||||||
HRV | Croatia | ZiZi | Human Shield | Živi zid | Zivi zid | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 62 | 2612 | 40 | ||||||||
HUN | Hungary | Jobbik | Jobbik Movement for a Better Hungary | Jobbik Magyarországért Mozgalom | Jobbik Magyarorszagert Mozgalom | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 158 | 1348700 | 2308 | 39 | 600 | 40 | |||||
HUN | Hungary | MHM | Our Homeland Movement | Mi Hazánk Mozgalom | Mi Hazank Mozgalom | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 39 | 2745 | 40 | ||||||||
ISR | Israel | Atid | Future | Atid | Atid | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2356 | 40 | |||||||||
ISR | Israel | FS | Flatto-Sharon | Flatto-Sharon | Flatto-Sharon | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 1845 | 40 | |||||||||
ISR | Israel | He-TnLe | Herut -- The National Movement | Herut – HaTnu'a HaLeumit | Herut -- HaTnu'a HaLeumit | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2361 | 40 | |||||||||
ISR | Israel | Kach | Thus | Kach | Kach | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 1969 | 40 | |||||||||
ISR | Israel | MLH | New Liberal Party | Miflaga Libralit Hadasha | Miflaga Libralit Hadasha | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2312 | 40 | |||||||||
ISR | Israel | NH | New Hope | Tikva Hadasha | Tikva Hadasha | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2835 | 40 | |||||||||
ISR | Israel | Noam | Pleasentness | Lazuz | Lazuz | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2889 | 40 | |||||||||
ISR | Israel | Tzomet | Crossroads | Tzomet | Tzomet | right | Right-wing | 8.8 | 5.9 | 8.5 | 72613 | 34 | 976 | 40 | ||||||||
ISR | Israel | Y | Rightwards | Yamina | Yamina | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2726 | 40 | |||||||||
ISR | Israel | YB | Israel Our Home | Yisrael Beiteinu | Yisrael Beiteinu | right | Right-wing | 8.8 | 5.9 | 8.5 | 72625 | 34 | 1816 | 40 | ||||||||
ISR | Israel | YaHa | New Right | HaYamin HeHadash | HaYamin HeHadash | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2718 | 40 | |||||||||
ISR | Israel | Yachad | Together | Yachad | Yachad | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2411 | 40 | |||||||||
ISR | Israel | Yiud | Mission | Yiud | Yiud | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2355 | 40 | |||||||||
ISR | Israel | Z | Zehut | Zehut | Zehut | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2727 | 40 | |||||||||
ITA | Italy | ASM | Social Alternative Mussolini | Alternativa Sociale Mussolini | Alternativa Sociale Mussolini | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 26 | 323 | 40 | ||||||||
ITA | Italy | FdI | Brothers of Italy | Fratelli d'Italia | Fratelli dItalia | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 26 | 2154 | 40 | ||||||||
ITA | Italy | ISP | Sovereign and Popular Italy | Italia sovrana e Popolare | Italia Sovrana e Popolare | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 26 | 2874 | 40 | ||||||||
ITA | Italy | LAM | Southern Action League | Lega d'Azione Meridionale | Lega d'Azione Meridionale | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 26 | 436 | 40 | ||||||||
ITA | Italy | MSI | Italian Social Movement | Movimento Sociale Italiano | Movimento Sociale Italiano | right | Right-wing | 9.1778 | 5.9 | 8.5 | 2.3 | 32710 | 1010 | 2110 | 26 | 831 | 40 | |||||
ITA | Italy | PNM | Monarchist National Party | Partito Nazionale Monarchico | Partito Nazionale Monarchico | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 26 | 1050 | 40 | ||||||||
JPN | Japan | HRP | Happiness Realization Party | Kōfuku Jitsugen-tō | Kofuku Jitsugen-to | right | Right-wing | 8.8 | 5.9 | 8.5 | 5 | 2851 | 40 | |||||||||
JPN | Japan | JaRep | Japan Innovation Party | Nippon Ishin no Kai | Nippon Ishin no Kai | right | Right-wing | 8.8 | 5.9 | 8.5 | 5 | 2826 | 40 | |||||||||
JPN | Japan | PFG | Party for Future Generations | Jisedai No Tou | Jisedai No Tou | right | Right-wing | 8.8 | 5.9 | 8.5 | 5 | 2404 | 40 | |||||||||
LTU | Lithuania | LCP | Lithuanian Centre Party | Lietuvos Centro Partija | Lietuvos Centro Partija | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 15 | 2635 | 40 | ||||||||
LTU | Lithuania | LTS | Lithuanian National Union List | Lietuvių tautininkų sąjunga | Lietuviu tautininku sajunga | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 88710 | 15 | 432 | 40 | |||||||
LTU | Lithuania | Tpp | Party of National Progress | Tautos pažangos partija | Tautos pazangos partija | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 15 | 2026 | 40 | ||||||||
LUX | Luxembourg | NB | National Movement | National Bewegong | National Bewegong | right | Right-wing | 8.8 | 5.9 | 8.5 | 908 | 7 | 374 | 40 | ||||||||
LUX | Luxembourg | ONP | Independent National Party | Onofhängeg Nationalpartei | Onofhangeg Nationalpartei | right | Right-wing | 8.8 | 5.9 | 8.5 | 7 | 2450 | 40 | |||||||||
LUX | Luxembourg | ONV | National Independent Union | Onofhängeg National Vereenegung | Onofhangeg National Vereenegung | right | Right-wing | 8.8 | 5.9 | 8.5 | 7 | 2529 | 40 | |||||||||
LVA | Latvia | KPV-LV | Who owns the state? | Kam pieder valsts? | Kam pieder valsts? | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 55 | 2715 | 40 | ||||||||
LVA | Latvia | KuK | For Each and Every One | Katram un katrai | Katram un katrai | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 55 | 2880 | 40 | ||||||||
LVA | Latvia | LPV | Latvia First | Latvija pirmajā vietā | Latvija pirmaja vieta | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 55 | 2876 | 40 | ||||||||
LVA | Latvia | LuV | For Latvia and Ventspils | Latvijai un Ventspilij | Latvijai un Ventspilij | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 55 | 2890 | 40 | ||||||||
LVA | Latvia | TB | For Fatherland and Freedom | Tēvzemei un Brīvībai | Tevzemei un Brivibai | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 87721 | 55 | 203 | 40 | |||||||
LVA | Latvia | TKL-ZP | People's Movement for Latvia -- Siegerist Party | Tautas Kustība Latvijai – Zīgerista Partija | Tautas Kustiba Latvijai -- Zigerista Partija | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 87722 | 55 | 267 | 40 | |||||||
MLT | Malta | IE | Imperium Europa | Imperu Ewropew | Imperu Ewropew | right | Right-wing | 8.8 | 5.9 | 8.5 | 72 | 1400 | 40 | |||||||||
NLD | Netherlands | CP | Centre Party | Centrumpartij | Centrumpartij | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 8 | 275 | 40 | ||||||||
NLD | Netherlands | FvD | Forum for Democracy | Forum voor Democratie | Forum voor Democratie | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 8 | 2642 | 40 | ||||||||
NLD | Netherlands | JA21 | Right Answer 2021 | Juiste Antwoord21 | Juiste Antwoord21 | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 8 | 2823 | 40 | ||||||||
NLD | Netherlands | LN | Livable Netherlands | Leefbaar Nederland | Leefbaar Nederland | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 22430 | 8 | 744 | 40 | |||||||
NLD | Netherlands | NSB | National Socialist Movement in the Netherlands | Nationaal-Socialistische Beweging in Nederland | Nationaal-Socialistische Beweging in Nederland | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 8 | 2463 | 40 | ||||||||
NOR | Norway | NS | National Gathering | Nasjonal Samling | Nasjonal Samling | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 9 | 2414 | 40 | ||||||||
NZL | New Zealand | NC | New Conservative Party | New Conservative Party | New Conservative Party | right | Right-wing | 8.8 | 5.9 | 8.5 | 11 | 2806 | 40 | |||||||||
POL | Poland | K | Kukiz'15 | Kukiz'15 | Kukiz'15 | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 74 | 2600 | 40 | ||||||||
POL | Poland | KPN | Confederation for Independent Poland | Konfederacja Polski Niepodległej | Konfederacja Polski Niepodleglej | right | Right-wing | 5.8333 | 5.9 | 8.5 | 2.3 | 92710 | 3006 | 74 | 548 | 40 | ||||||
POL | Poland | RKN | Catholic-National Movement | Ruch Katolicko-Narodowy | Ruch Katolicko-Narodowy | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 74 | 322 | 40 | ||||||||
POL | Poland | RN | National Movement | Ruch Narodowy | Ruch Narodowy | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 74 | 2398 | 40 | ||||||||
POL | Poland | SP | United Poland | Solidarna Polska | Solidarna Polska | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 74 | 2372 | 40 | ||||||||
POL | Poland | X | Party X | Partia X | Partia X | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 92712 | 74 | 181 | 40 | |||||||
PRT | Portugal | CH | Enough | Chega | Chega | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 63 | 2789 | 40 | ||||||||
ROU | Romania | AUR | Alliance for the Unity of Romanians | Alianța pentru Unirea Românilor | Alianta pentru Unirea Romanilor | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 23 | 2807 | 40 | ||||||||
ROU | Romania | PRU | United Romania Party | Partidul România Unită | Partidul Romania Unita | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 23 | 2648 | 40 | ||||||||
ROU | Romania | PUNR | Romanian National Unity Party | Partidul Unitatii Naţionale a Romanilor | Partidul Unitatii Nationale a Romanilor | right | Right-wing | 5.5556 | 5.9 | 8.5 | 2.3 | 93711 | 3208 | 23 | 648 | 40 | ||||||
SVK | Slovakia | LsNS | People's Party Our Slovakia | Ľudová strana Naše Slovensko | Ludova strana Nase Slovensko | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 1 | 586 | 40 | ||||||||
SVK | Slovakia | NDS | National Democratic Party | Národno-demokratická strana | Narodno-demokraticka strana | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 96712 | 1 | 1228 | 40 | |||||||
SVK | Slovakia | NaS-NS | Nation and Justice -- Our Party | Národ a spravodlivosť – Naša strana | Narod a spravodlivost -- Nasa strana | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 1 | 2391 | 40 | ||||||||
SVK | Slovakia | SR | We are family -- Boris Kollar | Sme Rodina – Boris Kollár | Sme Rodina -- Boris Kollar | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 1 | 2623 | 40 | ||||||||
SVK | Slovakia | V | Homeland | Vlasť | Vlast | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 1 | 2798 | 40 | ||||||||
SVN | Slovenia | DOM | Homeland League | Domovinska liga | Domovinska liga | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 60 | 2754 | 40 | ||||||||
SVN | Slovenia | LIPA | Party Lime Tree | Stranka Lipa | Stranka Lipa | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 60 | 1946 | 40 | ||||||||
SWE | Sweden | SD | Sweden Democrats | Sverigedemokraterna | Sverigedemokraterna | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 285 | 1752700 | 1610 | 35 | 1546 | 40 | |||||
TUR | Turkey | BBP | Great Union Party | Büyük Birlik Partisi | Buyuk Birlik Partisi | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 74626 | 20 | 240 | 40 | |||||||
TUR | Turkey | IYI | Iyi Party | İyi Parti | Iyi Parti | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 20 | 2702 | 40 | ||||||||
TUR | Turkey | MDP | Nationalist Democratic Party | Milliyetçi Demokrasi Partisi | Milliyetci Demokrasi Partisi | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 74711 | 20 | 110 | 40 | |||||||
TUR | Turkey | AKP | Justice and Development Party | Adalet ve Kalkınma Partisi | Adalet ve Kalkinma Partisi | con | Conservative | 6.9873 | 3.797 | 8.499 | 8.6278 | 74622 | 306 | 8140 | 3401 | 20 | 901 | 26 | ||||
LVA | Latvia | LPP | Latvia's First Party | Latvijas Pirmā partija | Latvijas Pirma partija | con | Conservative | 6.3377 | 6.8461 | 8.4916 | 8.1287 | 87521 | 2080 | 2404 | 55 | 1043 | 26 | |||||
SVK | Slovakia | SNS | Slovak National Party | Slovenská národná strana | Slovenska narodna strana | right | Right-wing | 7.0198 | 4.5191 | 8.46 | 3.838 | 96710 | 257 | 1703710 | 3401 | 4131 | 2809 | 1 | 1072 | 40 | ||
AUS | Australia | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | con | Conservative | 7.8222 | 6.2456 | 8.4561 | 63810 | 104 | 206 | 4775 | 33 | 184 | 26 | |||||
SVK | Slovakia | OKS | Civic Conservative Party | Obcianska konzervatívna strana | Obcianska konzervatIvna strana | con | Conservative | 8.4211 | 8.4211 | 8.4211 | 2.6316 | 3977 | 1 | 1645 | 26 | |||||||
SVN | Slovenia | NSI | New Slovenia -- Christian People's Party | Nova Slovenija – Krščanska ljudska stranka | Nova Slovenija -- Krscanska ljudska stranka | chr | Christian democracy | 7.9345 | 5.9719 | 8.3998 | 8.4866 | 97522 | 262 | 1705522 | 4235 | 2905 | 60 | 1047 | 3 | |||
CHE | Switzerland | SVP-UDC | Swiss People's Party | Schweizerische Volkspartei – Union Démocratique du Centre | Schweizerische Volkspartei -- Union Democratique du Centre | agr | Agrarian | 7.3575 | 8.9684 | 8.3385 | 0.6368 | 43810 | 292 | 3804 | 1705 | 8124 | 3601 | 40 | 750 | 2 | ||
HUN | Hungary | KDNP | Christian Democratic People's Party | Kereszténydemokrata Néppárt | Keresztenydemokrata Neppart | chr | Christian democracy | 7.4 | 2.17 | 8.33 | 5.8333 | 86522 | 1348526 | 1604 | 2307 | 39 | 434 | 3 | ||||
FIN | Finland | KD | Christian Democrats | Kristillisdemokraatit – Kristdemokraterna | Kristillisdemokraatit -- Kristdemokraterna | chr | Christian democracy | 7.1884 | 4.9438 | 8.3076 | 3.2103 | 14520 | 92 | 1246520 | 607 | 1309 | 1409 | 5657 | 1409 | 67 | 1463 | 3 |
POL | Poland | PiS | Law and Justice | Prawo i Sprawiedliwość | Prawo i Sprawiedliwosc | con | Conservative | 7.6997 | 4.0466 | 8.2514 | 5.4813 | 92436 | 230 | 1616436 | 3032 | 2605 | 74 | 528 | 26 | |||
POL | Poland | UPR|KNP | Real Politics Union | Congress of the New Right | Unia Polityki Realnej | Kongres Nowej Prawicy | Unia Polityki Realnej | Kongres Nowej Prawicy | con | Conservative | 9.7368 | 9.4737 | 8.1579 | 2.3684 | 92432 | 382 | 3154 | 74 | 1549 | 26 | |||||
ISR | Israel | HaLe-T|RZP | National Union--Tkuma | Religious Zionist Party | HaIhud HaLeumi–Tkuma | HaTzionut HaDatit | HaIhud HaLeumi--Tkuma | HaTzionut HaDatit | right | Right-wing | 9.5906 | 5.7895 | 8.1474 | 72624 | 6455 | 34 | 1357 | 40 | |||||||
POL | Poland | AWS | Solidarity Electoral Action | Akcja Wyborcza Solidarność Prawicy | Akcja Wyborcza Solidarnosc Prawicy | chr | Christian democracy | 7.1286 | 4.6148 | 8.1427 | 7.0491 | 92620 | 2928 | 2608 | 74 | 1355 | 3 |
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;