view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by party_id descending
This data as json, CSV (advanced)
Suggested facets: family_name_short, family_name
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 | LP | Liepaja Party | Liepājas Partija | Liepajas Partija | spec | Special issue | 55 | 2891 | 16 | ||||||||||||
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 | ||||||||
ISR | Israel | Noam | Pleasentness | Lazuz | Lazuz | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2889 | 40 | |||||||||
DNK | Denmark | AE | Denmark Demokrats | Danmarksdemokraterne | Danmarksdemokraterne | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 21 | 2888 | 40 | ||||||||
DNK | Denmark | M | Moderates | Moderaterne | Moderaterne | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 21 | 2887 | 6 | ||||||||
SVN | Slovenia | GZD | Healthy Society Movement | Gibanje Zdrava Družba | Gibanje Zdrava Druzba | spec | Special issue | 60 | 2886 | 16 | ||||||||||||
SVN | Slovenia | Resni.ca | Resni.ca | Resni.ca | Resni ca | spec | Special issue | 60 | 2885 | 16 | ||||||||||||
SVN | Slovenia | PoS | Let's Connect Slovenia | Povežimo Slovenijo | Povezimo Slovenijo | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 60 | 2884 | 26 | ||||||||
LVA | Latvia | PP | Power of the People | Tautas varas spēks | Tautas varas speks | code | to be coded | 55 | 2883 | 28 | ||||||||||||
LVA | Latvia | SV | Sovereign Power | Suverēnā vara | Suverena vara | spec | Special issue | 55 | 2882 | 16 | ||||||||||||
LVA | Latvia | TKL | People's Servants for Latvia | Tautas kalpi Latvijai | Tautas kalpi Latvijai | spec | Special issue | 55 | 2881 | 16 | ||||||||||||
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 | one-seat | one seat | one seat | one seat | none | no family | 55 | 2879 | 12 | ||||||||||||
LVA | Latvia | AP! | Development/For! | Attīstībai/Par! | Attistibai/Par! | spec | Special issue | 55 | 2878 | 16 | ||||||||||||
LVA | Latvia | R | Republic | Republika | Republika | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 55 | 2877 | 11 | ||||||||
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 | S! | For Stability! | Stabilitātei! | Stabilitatei | spec | Special issue | 55 | 2875 | 16 | ||||||||||||
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 | Italexit | Italexit for Italy | Italext per l'Italia | Italexit per l'Italia | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 26 | 2873 | 26 | ||||||||
BGR | Bulgaria | BV | Bulgarian Rise | Balgarski vazhod | Balgarski vazhod | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2871 | 26 | ||||||||
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 | VB | Volt Bulgaria | Volt Bulgaria | Volt Bulgaria | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2869 | 6 | ||||||||
SVN | Slovenia | ND | Our Country | Naša dežela | Nasa dezela | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 60 | 2866 | 19 | ||||||||
SVN | Slovenia | VESNA | Vesna -- the Green Party | VESNA – zelena stranka | VESNA -- zelena stranka | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 60 | 2865 | 19 | ||||||||
PRT | Portugal | no-seat | no seat | no seat | no seat | none | no family | 63 | 2864 | 12 | ||||||||||||
FRA | France | agir | Act, the constructive right | Agir, la droite constructive | Agir, la droite constructive | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 2862 | 26 | ||||||||
ITA | Italy | IpF | Together for the Future | Insieme per il Futuro | Insieme per il Futuro | none | no family | 26 | 2861 | 12 | ||||||||||||
FRA | France | R! | Reconquest | Reconquête | Reconquete | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 43 | 2860 | 40 | ||||||||
FRA | France | one-seat | one seat | one seat | one seat | none | no family | 43 | 2859 | 12 | ||||||||||||
FRA | France | d-center | other centre | divers centre | divers centre | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 43 | 2858 | 6 | ||||||||
FRA | France | H | Horizons | Horizons | Horizons | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 43 | 2857 | 6 | ||||||||
SVN | Slovenia | GS | Freedom Movement | Gibanje Svoboda | Gibanje Svoboda | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2856 | 11 | ||||||||
HUN | Hungary | MEMO | Solution Movement | Megoldás Mozgalom | Megoldas Mozgalom | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 39 | 2855 | 6 | ||||||||
CZE | Czech Republic | VB | Free Bloc | Volný blok | Volny blok | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 2854 | 40 | ||||||||
JPN | Japan | NHK | The party that protects those who do not pay the NHK license fee | NHK jushinryō o shiharawanai kokumin o mamoru tō | NHK jushinryo o shiharawanai kokumin o mamoru to | spec | Special issue | 5 | 2853 | 16 | ||||||||||||
ISL | Iceland | SFI | Icelandic Socialist Party | Sósíalistaflokkur Íslands | Sosialistaflokkur Islands | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 56 | 2852 | 14 | |||||||||
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 | |||||||||
DEU | Germany | SSW | South Schleswig Voter League | Südschleswigscher Wählerverband | Suedschleswigscher Waehlerverband | spec | Special issue | 54 | 2850 | 16 | ||||||||||||
BGR | Bulgaria | PP | We Continue the Change | Prodalzhavame promyanata | Prodalzhavame promyanata | spec | Special issue | 10 | 2847 | 16 | ||||||||||||
BGR | Bulgaria | BNO|BN | Bulgarian National Unification | Bulgarian Summer | Bŭlgarsko natsionalno obedinenie | Balgarsko lyato | Bulgarsko natsionalno obedinenie | Balgarsko lyato | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 2840 | 40 | ||||||||
BGR | Bulgaria | IS | Stand up! | Izpravi se! | Izpravi se! | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2838 | 11 | ||||||||
BGR | Bulgaria | ITN | There Is Such a People | Ima takav narod | Ima takav narod | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2836 | 26 | ||||||||
ISR | Israel | NH | New Hope | Tikva Hadasha | Tikva Hadasha | right | Right-wing | 8.8 | 5.9 | 8.5 | 34 | 2835 | 40 | |||||||||
CZE | Czech Republic | Tri | Tricolour Citizens' Movement | Trikolóra | Trikolora | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 2832 | 40 | ||||||||
CZE | Czech Republic | P | Oath | Přísaha | Prisaha | spec | Special issue | 68 | 2831 | 16 | ||||||||||||
JPN | Japan | ReiShin | Reiwa Shinsengumi | Reiwa Shinsengumi | Reiwa Shinsengumi | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 5 | 2828 | 14 | |||||||||
JPN | Japan | DPP | Democratic Party for the People | Kokumin Minshu-tō | Kokumin Minshu-to | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 2827 | 26 | |||||||||
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 | |||||||||
NLD | Netherlands | BBB | Farmer-Citizen Movement | BoerBurgerBeweging | BoerBurgerBeweging | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 8 | 2824 | 2 | ||||||||
NLD | Netherlands | JA21 | Right Answer 2021 | Juiste Antwoord21 | Juiste Antwoord21 | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 8 | 2823 | 40 | ||||||||
DEU | Germany | dieBasis | Grassroots Democratic Party of Germany | Basisdemokratische Partei Deutschland | Basisdemokratische Partei Deutschland | spec | Special issue | 54 | 2821 | 16 | ||||||||||||
CYP | Cyprus | PL | People's Breath | Pní Laoú | Pni Laou | right | Right-wing | 8.8 | 5.9 | 8.5 | 51 | 2820 | 40 | |||||||||
CYP | Cyprus | AM | Awakening 2020 | Afypnisis 2020 | Afypnisis 2020 | spec | Special issue | 51 | 2819 | 16 | ||||||||||||
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 | |||||||||
NOR | Norway | D | Democrats | Demokratene | Demokratene | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 9 | 2816 | 26 | ||||||||
CYP | Cyprus | EP | Active Citizens | Energi Polites | Energi Polites | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 51 | 2815 | 14 | |||||||||
BGR | Bulgaria | RzB | Republicans for Bulgaria | Republikantsi za Balgariya | Republikantsi za Balgariya | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2814 | 26 | ||||||||
FRA | France | PE | Ecologist Party | Parti écologiste | Parti ecologiste | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 43 | 2813 | 19 | ||||||||
ROU | Romania | PLUS | Party of Liberty, Unity and Solidarity | Partidul Libertate, Unitate și Solidaritate | Partidul Libertate, Unitate si Solidaritate | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 23 | 2811 | 6 | ||||||||
HRV | Croatia | M! | We Can! -- Political Platform | Možemo! – politička platforma | Mozemo! -- politicka platforma | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 62 | 2810 | 19 | ||||||||
HRV | Croatia | DP | Homeland Movement | Domovinski pokret | Domovinski pokret | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 62 | 2809 | 40 | ||||||||
LVA | Latvia | KP | Movement For! | Kustība Par! | Kustiba Par! | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 55 | 2808 | 6 | ||||||||
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 | ||||||||
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 | |||||||||
LTU | Lithuania | LP | Freedom Party | Laisvės partija | Laisves partija | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 15 | 2805 | 6 | ||||||||
ESP | Spain | Equo | Equo | Equo | Equo | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 27 | 2804 | 19 | ||||||||
SVK | Slovakia | NOVA | New Majority | Nová väčšina | Nova vacsina | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 1 | 2803 | 3 | ||||||||
LTU | Lithuania | etc | others | others | others | none | no family | 15 | 2802 | 12 | ||||||||||||
FIN | Finland | LN | Movement Now | Liike Nyt | Liike Nyt | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 67 | 2801 | 6 | ||||||||
ISR | Israel | Telem | Telem | Telem | Telem | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2800 | 6 | |||||||||
ISR | Israel | HLY | Israel Resilience Party | Hosen L'Yisrael | Hosen L'Yisrael | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2799 | 6 | |||||||||
SVK | Slovakia | V | Homeland | Vlasť | Vlast | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 1 | 2798 | 40 | ||||||||
SVK | Slovakia | DV | Good Choice | Dobrá voľba | Dobra volba | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 1 | 2797 | 11 | ||||||||
SVK | Slovakia | ZAL | For the People | Za ľudí | Za ludi | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 1 | 2796 | 6 | ||||||||
IRL | Ireland | A | Aontu | Aontú | Aontu | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2795 | 26 | ||||||||
ITA | Italy | IV | Italy Alive | Italia Viva | Italia Viva | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 2794 | 6 | ||||||||
ESP | Spain | CUP | Popular Unity Candidacy | Candidatura d'Unitat Popular | Candidatura d'Unitat Popular | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 27 | 2792 | 14 | ||||||||
CAN | Canada | PPC | People's Party of Canada | People's Party of Canada | People's Party of Canada | right | Right-wing | 8.8 | 5.9 | 8.5 | 29 | 2791 | 40 | |||||||||
POL | Poland | LR | Left Together | Lewica Razem | Lewica Razem | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 74 | 2790 | 11 | ||||||||
PRT | Portugal | CH | Enough | Chega | Chega | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 63 | 2789 | 40 | ||||||||
PRT | Portugal | IL | Liberal Initiative | Iniciativa Liberal | Iniciativa Liberal | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 63 | 2788 | 6 | ||||||||
ISR | Israel | G | Bridge | Gesher | Gesher | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2787 | 6 | |||||||||
JPN | Japan | TPJ | Tomorrow Party of Japan | Nippon Mirai no Tō | Nippon Mirai no To | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 5 | 2785 | 19 | |||||||||
CYP | Cyprus | YH | Jasmine Movement | Yasemin Hareketi | Yasemin Hareketi | soc | Social democracy | 3.3 | 3.5 | 3.5 | 51 | 2784 | 11 | |||||||||
SVK | Slovakia | KDZP | Christian Democracy -- Life and Prosperity | Kresťanská demokracia – Život a prosperita | Krestanska demokracia -- Zivot a prosperita | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 1 | 2783 | 3 | ||||||||
DNK | Denmark | SK | Hard Line | Stram Kurs | Stram Kurs | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 21 | 2782 | 40 | ||||||||
DNK | Denmark | NB | The New Right | Nye Borgerlige | Nye Borgerlige | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 21 | 2781 | 40 | ||||||||
GRC | Greece | EL | Greek Solution | Elliniki Lisi | Elliniki Lisi | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41 | 2780 | 26 | ||||||||
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 | ||||||||||||
POL | Poland | PZ | The Greens | Partia Zieloni | Partia Zieloni | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 74 | 2778 | 19 | ||||||||
IRL | Ireland | D-PRB | Solidarity -- People Before Profit | Dlúthphartíocht – Pobal Roimh Bhrabús | Dluthphartiocht -- Pobal Roimh Bhrabus | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 37 | 2776 | 14 | ||||||||
CHE | Switzerland | V | Vigilants | Vigilance | Vigilance | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 40 | 2775 | 40 | ||||||||
BGR | Bulgaria | I-MK | Independent -- Mincho Kuminev | Independent – Mincho Kuminev | Independent -- Mincho Kuminev | none | no family | 10 | 2774 | 12 | ||||||||||||
HRV | Croatia | P | Intelligently | Pametno | Pametno | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 62 | 2772 | 6 | ||||||||
HRV | Croatia | START | Party of Anti-Corruption, Development and Transparency | Stranka antikorupcije, razvoja i transparentnost | Stranka antikorupcije, razvoja i transparentnost | spec | Special issue | 62 | 2771 | 16 | ||||||||||||
HRV | Croatia | NHR | Independents for Croatia | Neovisni za Hrvatsku | Neovisni za Hrvatsku | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 62 | 2770 | 26 | ||||||||
HRV | Croatia | I-MP | Independent -- Marijana Petir | Independent – Marijana Petir | Independent -- Marijana Petir | none | no family | 62 | 2769 | 12 | ||||||||||||
HRV | Croatia | I-MK | Independent -- Mislav Kolakusic | Independent – Mislav Kolakušić | Independent -- Mislav Kolakusic | none | no family | 62 | 2768 | 12 | ||||||||||||
LUX | Luxembourg | VL | Volt Luxembourg | Volt Luxembourg | Volt Luxembourg | spec | Special issue | 7 | 2766 | 16 |
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;