view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by state_market
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
JPN | Japan | IC | Independent's Club | Mushozoku-no-kai | Mushozoku-no-kai | none | no family | 5 | 695 | 12 | ||||||||||||
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 | ||||||||||||
JPN | Japan | etc | others | others | others | none | no family | 5 | 1055 | 12 | ||||||||||||
JPN | Japan | no-seat | no seat | no seat | no seat | none | no family | 5 | 2141 | 12 | ||||||||||||
JPN | Japan | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 5 | 905 | 12 | ||||||||||||
JPN | Japan | one-seat | one seat | one seat | one seat | none | no family | 5 | 2297 | 12 | ||||||||||||
JPN | Japan | vac | vacancy | vacancy | vacancy | none | no family | 5 | 1812 | 12 | ||||||||||||
LTU | Lithuania | DK | The Way of Courage | Drąsos kelias | Drasos kelias | spec | Special issue | 15 | 2121 | 16 | ||||||||||||
LTU | Lithuania | K-AMT | PEC -- Ausra Maldeikiene's Rain | VRK – Aušros Maldeikienės traukinys | VRK -- Ausros Maldeikienes traukinys | none | no family | 15 | 2760 | 12 | ||||||||||||
LTU | Lithuania | K-LS | PEC -- Decisive Leap | VRK – Lemiamas šuolis | VRK -- Lemiamas suolis | none | no family | 15 | 2765 | 12 | ||||||||||||
LTU | Lithuania | K-PRPJ | PEC -- President Rolandas Paksas' Movement | VRK – Prezidento Rolando Pakso judėjimas | VRK -- Prezidento Rolando Pakso judejimas | none | no family | 15 | 2761 | 12 | ||||||||||||
LTU | Lithuania | K-SLVE | PEC -- Strong Lithuania in United Europe | VRK – Stipri Lietuva vieningoje Europoje | VRK -- Stipri Lietuva vieningoje Europoje | none | no family | 15 | 2764 | 12 | ||||||||||||
LTU | Lithuania | K-VRS | PEC -- Vytautas Radzvilas: Recover the State! | VRK – Vytautas Radžvilas: susigrąžinkime valstybę! | VRK -- Vytautas Radzvilas: susigrazinkime valstybe! | none | no family | 15 | 2762 | 12 | ||||||||||||
LTU | Lithuania | LLL | Lithuanian Liberty League | Lietuvos laisvės lyga | Lietuvos laisves lyga | spec | Special issue | 15 | 1782 | 16 | ||||||||||||
LTU | Lithuania | LTMA | Alliance of the Lithuanian National Minorities | Lietuvos tautinių mažumų aljansas | Lietuvos tautiniu mazumu aljansas | spec | Special issue | 15 | 2036 | 16 | ||||||||||||
LTU | Lithuania | LUP | Lithuanian Party of Economy | Lietuvos ūkio partijos | Lietuvos ukio partija | code | to be coded | 15 | 2037 | 28 | ||||||||||||
LTU | Lithuania | TPJ | National Progress Movement | Tautos pazangos judejimas | Tautos pazangos judejimas | code | to be coded | 15 | 1783 | 28 | ||||||||||||
LTU | Lithuania | UTL | Peoples Union "For Just Lithuania" | Liaudies sąjunga "Uz teisingą Lietuvą" | Peoples Union "For Just Lithuania" | code | to be coded | 15 | 2039 | 28 | ||||||||||||
LTU | Lithuania | Zp | Samogitian Party | Žemaičių partija | Zemaiciu partija | spec | Special issue | 15 | 2025 | 16 | ||||||||||||
LTU | Lithuania | etc | others | others | others | none | no family | 15 | 2802 | 12 | ||||||||||||
LTU | Lithuania | no-seat | no seat | no seat | no seat | none | no family | 15 | 2636 | 12 | ||||||||||||
LTU | Lithuania | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 15 | 58 | 12 | ||||||||||||
LTU | Lithuania | one-seat | one seat | one seat | one seat | none | no family | 15 | 652 | 12 | ||||||||||||
LUX | Luxembourg | Bl | Citizens' List | Biergerlëscht | Biergerlescht | spec | Special issue | 416 | 1442009 | 7 | 1130 | 16 | ||||||||||
LUX | Luxembourg | FV | Independent People's Party | Fräi Vollekspartei | Frai Vollekspartei | code | to be coded | 7 | 2451 | 28 | ||||||||||||
LUX | Luxembourg | GLS | Group for Luxembourgian Sovereignty | Groupement fir d'Lëtzebuerger Souveränitéit | Groupement fir d'Letzebuerger Souveraniteit | spec | Special issue | 7 | 2146 | 16 | ||||||||||||
LUX | Luxembourg | MIP | Popular Independent Movement | Mouvement indépendant populaire | Mouvement independant populaire | spec | Special issue | 7 | 1462 | 16 | ||||||||||||
LUX | Luxembourg | PBMA | Free List of Peasants, Middle Classes and Workers | Partei vun de Baueren, dem Mëttelstand an den Aarbechter | Partei vun de Baueren, dem Mettelstand an den Aarbechter | none | no family | 7 | 2449 | 12 | ||||||||||||
LUX | Luxembourg | PIE | Independents of the East | Parti des Indépendants de l'Est | Parti des Indpendants de l'Est | none | no family | 7 | 2452 | 12 | ||||||||||||
LUX | Luxembourg | Pi | Pirate Party Luxembourg | Piratepartei Lëtzebuerg | Piratepartei Letzebuerg | spec | Special issue | 7 | 2256 | 16 | ||||||||||||
LUX | Luxembourg | VL | Volt Luxembourg | Volt Luxembourg | Volt Luxembourg | spec | Special issue | 7 | 2766 | 16 | ||||||||||||
LUX | Luxembourg | Z-EF | Coerced Conscripts | Zwangsrekrutéierten | Zwangsrekruteierten | spec | Special issue | 7 | 202 | 16 | ||||||||||||
LUX | Luxembourg | no-seat | no seat | no seat | no seat | none | no family | 7 | 2149 | 12 | ||||||||||||
LUX | Luxembourg | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 7 | 1002 | 12 | ||||||||||||
LUX | Luxembourg | one-seat | one seat | one seat | one seat | none | no family | 7 | 2290 | 12 | ||||||||||||
LVA | Latvia | AP! | Development/For! | Attīstībai/Par! | Attistibai/Par! | spec | Special issue | 55 | 2878 | 16 | ||||||||||||
LVA | Latvia | LG | Light of Latgale | Latgales Gaisma | Latgales Gaisma | spec | Special issue | 55 | 956 | 16 | ||||||||||||
LVA | Latvia | LKPP | Latvias Party of Russian Citizens | Latvijas Krievu pilsoņu partija | Latvijas Krievu pilsonu partija | spec | Special issue | 55 | 1083 | 16 | ||||||||||||
LVA | Latvia | LP | Liepaja Party | Liepājas Partija | Liepajas Partija | spec | Special issue | 55 | 2891 | 16 | ||||||||||||
LVA | Latvia | LTF | Popular Front of Latvia | Latvijas Tautas fronte | Latvijas Tautas fronte | spec | Special issue | 55 | 42 | 16 | ||||||||||||
LVA | Latvia | MPA-LNP | Political Association of the Underprivileged and Latvian Independence Party | Maznodrošināto politiskā apvienība un Latviešu neatkarības partija | Maznodrosinato politiska apvieniba un Latviesu neatkaribas partija | code | to be coded | 55 | 1163 | 28 | ||||||||||||
LVA | Latvia | PP | Power of the People | Tautas varas spēks | Tautas varas speks | code | to be coded | 55 | 2883 | 28 | ||||||||||||
LVA | Latvia | S! | For Stability! | Stabilitātei! | Stabilitatei | spec | Special issue | 55 | 2875 | 16 | ||||||||||||
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 | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 55 | 288 | 12 | ||||||||||||
LVA | Latvia | one-seat | one seat | one seat | one seat | none | no family | 55 | 2879 | 12 | ||||||||||||
MLT | Malta | GP | Gozo Party | Gozo Party | Gozo Party | spec | Special issue | 72 | 1298 | 16 | ||||||||||||
MLT | Malta | JP | Jones Party | Jones Party | Jones Party | spec | Special issue | 72 | 248 | 16 | ||||||||||||
MLT | Malta | no-seat | no seat | no seat | no seat | none | no family | 72 | 2171 | 12 | ||||||||||||
MLT | Malta | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 72 | 1572 | 12 | ||||||||||||
NLD | Netherlands | 50+ | 50PLUS | 50PLUS | 50PLUS | spec | Special issue | 8 | 2109 | 16 | ||||||||||||
NLD | Netherlands | AOV|VSP | General Senior Union | United Seniors Party | Algemeen Ouderen Verbond | Verenigde Senioren Partij | Algemeen Ouderen Verbond | Verenigde Senioren Partij | spec | Special issue | 8 | 112 | 16 | ||||||||||||
NLD | Netherlands | EuTr | Europe Transparent | Europa Transparant | Europa Transparant | spec | Special issue | 8 | 339 | 16 | ||||||||||||
NLD | Netherlands | PvdD | Party for the Animals | Partij voor de Dieren | Partij voor de Dieren | spec | Special issue | 300 | 1528006 | 1018 | 8 | 990 | 16 | |||||||||
NLD | Netherlands | VN | Volt Netherlands | Volt Nederland | Volt Nederland | spec | Special issue | 8 | 2735 | 16 | ||||||||||||
NLD | Netherlands | no-seat | no seat | no seat | no seat | none | no family | 8 | 2110 | 12 | ||||||||||||
NLD | Netherlands | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 8 | 674 | 12 | ||||||||||||
NLD | Netherlands | one-seat | one seat | one seat | one seat | none | no family | 8 | 2288 | 12 | ||||||||||||
NOR | Norway | A | Teetotaler Party | Avholdspartiet | Avholdspartiet | spec | Special issue | 9 | 2544 | 16 | ||||||||||||
NOR | Norway | Hf | Resistance Movement | Hjemmefronten | Hjemmefronten | spec | Special issue | 9 | 17 | 16 | ||||||||||||
NOR | Norway | P | Pensioners Party | Pensjonistpartiet | Pensjonistpartiet | spec | Special issue | 9 | 733 | 16 | ||||||||||||
NOR | Norway | etc | others | others | others | none | no family | 9 | 2578 | 12 | ||||||||||||
NOR | Norway | no-seat | no seat | no seat | no seat | none | no family | 9 | 2100 | 12 | ||||||||||||
NOR | Norway | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 9 | 793 | 12 | ||||||||||||
NOR | Norway | one-seat | one seat | one seat | one seat | none | no family | 9 | 474 | 12 | ||||||||||||
NZL | New Zealand | ALCP | Aotearoa Legalise Cannabis Party | Aotearoa Legalise Cannabis Party | Aotearoa Legalise Cannabis Party | spec | Special issue | 11 | 2073 | 16 | ||||||||||||
NZL | New Zealand | MP | Maori Party | Māori Party | Maori Party | spec | Special issue | 64951 | 11 | 114 | 16 | |||||||||||
NZL | New Zealand | Mana | Mana Party | Mana Party | Mana Party | spec | Special issue | 11 | 1972 | 16 | ||||||||||||
NZL | New Zealand | OR | Outdoor Recreation New Zealand | Outdoor Recreation New Zealand | Outdoor Recreation New Zealand | spec | Special issue | 11 | 2074 | 16 | ||||||||||||
NZL | New Zealand | RM | Ratana Movement | Rātana Movement | Rtana Movement | spec | Special issue | 11 | 2470 | 16 | ||||||||||||
NZL | New Zealand | SC|DP | Social Credit | Democratic Party | Social Credit | Democratic Party | Social Credit | Democratic Party | spec | Special issue | 5.6 | 64951 | 1202 | 11 | 1636 | 16 | |||||||||
NZL | New Zealand | etc | others | others | others | none | no family | 11 | 1365 | 12 | ||||||||||||
NZL | New Zealand | no-seat | no seat | no seat | no seat | none | no family | 11 | 2070 | 12 | ||||||||||||
NZL | New Zealand | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 11 | 1262 | 12 | ||||||||||||
POL | Poland | KPEiR | National Party of Pensioners and Retired | Krajowa Partia Emerytów i Rencistów | Krajowa Partia Emerytow i Rencistow | spec | Special issue | 74 | 109 | 16 | ||||||||||||
POL | Poland | KPEiR-RP | National Agreement of Pensioners and Retired of the Republic Poland | Krajowe Porozumienie Emerytów i Rencistów Rzeczypospolitej Polskiej | Krajowe Porozumienie Emerytow i Rencistow Rzeczypospolitej Polskiej | spec | Special issue | 74 | 1275 | 16 | ||||||||||||
POL | Poland | MN | German minority | Mniejszość niemiecka w Polsce | Mniejszosc niemiecka | spec | Special issue | 92953 | 74 | 900 | 16 | |||||||||||
POL | Poland | RAS | Movement for Silesian Autonomy | Ruch Autonomii Śląska | Ruch Autonomii Slaska | spec | Special issue | 92952 | 74 | 1208 | 16 | |||||||||||
POL | Poland | etc | others | others | others | none | no family | 74 | 1091 | 12 | ||||||||||||
POL | Poland | no-seat | no seat | no seat | no seat | none | no family | 74 | 2053 | 12 | ||||||||||||
POL | Poland | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 74 | 1011 | 12 | ||||||||||||
POL | Poland | one-seat | one seat | one seat | one seat | none | no family | 74 | 2287 | 12 | ||||||||||||
PRT | Portugal | PSN | National Solidarity Party | Partido da Solidariedade Nacional | Partido da Solidariedade Nacional | spec | Special issue | 7.5 | 35951 | 1207 | 63 | 82 | 16 | |||||||||
PRT | Portugal | no-seat | no seat | no seat | no seat | none | no family | 63 | 2864 | 12 | ||||||||||||
PRT | Portugal | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 63 | 729 | 12 | ||||||||||||
PRT | Portugal | one-seat | one seat | one seat | one seat | none | no family | 63 | 2291 | 12 | ||||||||||||
ROU | Romania | GDC | Democratic Group of the Centre | Grupul Democrat de Centru | Grupul Democrat de Centru | code | to be coded | 93529 | 23 | 152 | 28 | |||||||||||
ROU | Romania | I-GCT | Independent -- Gregoriana Carmen Tudoran | Independent – Gregoriana Carmen Tudoran | Independent -- Gregoriana Carmen Tudoran | none | no family | 23 | 2749 | 12 | ||||||||||||
ROU | Romania | I-GNS | Independent -- George-Nicolae Simion | Independent – George-Nicolae Simion | Independent -- George-Nicolae Simion | none | no family | 23 | 2748 | 12 | ||||||||||||
ROU | Romania | I-MD | Independent -- Mircea Diaconu | Mircea Diaconu | Mircea Diaconu | none | no family | 23 | 2394 | 12 | ||||||||||||
ROU | Romania | I-PC | Independent -- Peter Costea | Independent – Peter Costea | Independent -- Peter Costea | none | no family | 23 | 2747 | 12 | ||||||||||||
ROU | Romania | PPR | Party of Pensioners of Romania | Partidul Pensionarilor din Romania | Partidul Pensionarilor din Romania | spec | Special issue | 23 | 2106 | 16 | ||||||||||||
ROU | Romania | PaRe | Republican Party | Partidul Republican | Partidul Republican | code | to be coded | 23 | 2098 | 28 | ||||||||||||
ROU | Romania | etnice | Romanian ethnic minorities parties | Partidele minorităţilor etnice din România | Partidele minoritatilor etnice din Romania | none | no family | 23 | 425 | 12 | ||||||||||||
ROU | Romania | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 23 | 761 | 12 | ||||||||||||
ROU | Romania | one-seat | one seat | one seat | one seat | none | no family | 23 | 441 | 12 | ||||||||||||
SVK | Slovakia | HZPCS | Movement for a Prosperous Czechia and Slovakia | Hnutie za prosperujúce Cesko a Slovensko | Hnutie za prosperujuce Cesko a Slovensko | code | to be coded | 1 | 2239 | 28 | ||||||||||||
SVK | Slovakia | NS | New Slovakia | Nové Slovensko | Nove Slovensko | spec | Special issue | 1 | 2237 | 16 | ||||||||||||
SVK | Slovakia | SPK | Party against Corruption, for Order, Labour and Money for all Decent Citizens | Strana proti korupcii, za poriadok, prácu a peniaze pre všetkých slušných obcanov | Strana proti korupcii, za poriadok, pracu a peniaze pre vsetkych slusnych obcanov | spec | Special issue | 1 | 2238 | 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;