view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by family_name 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
IRL | Ireland | one-seat | one seat | one seat | one seat | none | no family | 37 | 2298 | 12 | ||||||||||||
ISL | Iceland | no-seat | no seat | no seat | no seat | none | no family | 56 | 2112 | 12 | ||||||||||||
ISL | Iceland | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 56 | 134 | 12 | ||||||||||||
ISR | Israel | etc | others | others | others | none | no family | 34 | 2352 | 12 | ||||||||||||
ISR | Israel | no-seat | no seat | no seat | no seat | none | no family | 34 | 2308 | 12 | ||||||||||||
ISR | Israel | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 34 | 123 | 12 | ||||||||||||
ISR | Israel | one-seat | one seat | one seat | one seat | none | no family | 34 | 2313 | 12 | ||||||||||||
ITA | Italy | IpF | Together for the Future | Insieme per il Futuro | Insieme per il Futuro | none | no family | 26 | 2861 | 12 | ||||||||||||
ITA | Italy | M5S | Five Star Movement | Movimento 5 Stelle | Movimento 5 Stelle | none | no family | 26 | 2155 | 12 | ||||||||||||
ITA | Italy | PC | Prime minister | Presidente del Consiglio dei ministri | Presidente del Consiglio dei ministri | none | no family | 26 | 2001 | 12 | ||||||||||||
ITA | Italy | etc | others | diversi | diversi | none | no family | 26 | 825 | 12 | ||||||||||||
ITA | Italy | no-seat | no seat | no seat | no seat | none | no family | 26 | 2059 | 12 | ||||||||||||
ITA | Italy | none | no party affiliation | senzo partito | senzo partito | none | no family | 26 | 1552 | 12 | ||||||||||||
ITA | Italy | one-seat | one seat | one seat | one seat | none | no family | 26 | 2302 | 12 | ||||||||||||
JPN | Japan | IC | Independent's Club | Mushozoku-no-kai | Mushozoku-no-kai | none | no family | 5 | 695 | 12 | ||||||||||||
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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | etc | others | others | others | none | no family | 1 | 1659 | 12 | ||||||||||||
SVK | Slovakia | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 1 | 1359 | 12 | ||||||||||||
SVN | Slovenia | I-JK | Independent -- Jelko Kacin | Independent – Jelko Kacin | Independent -- Jelko Kacin | none | no family | 60 | 2383 | 12 | ||||||||||||
SVN | Slovenia | etc | others | others | others | none | no family | 60 | 753 | 12 | ||||||||||||
SVN | Slovenia | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 60 | 1370 | 12 | ||||||||||||
SWE | Sweden | no-seat | no seat | no seat | no seat | none | no family | 35 | 2405 | 12 | ||||||||||||
SWE | Sweden | none | no party affiliation | partilös | partilos | none | no family | 35 | 786 | 12 | ||||||||||||
TUR | Turkey | no-seat | no seat | no seat | no seat | none | no family | 20 | 2316 | 12 | ||||||||||||
TUR | Turkey | none | no party affiliation | bağımsız | bagimsiz | none | no family | 20 | 1399 | 12 | ||||||||||||
AUS | Australia | SCP | Social Credit Party | Social Credit Party | Social Credit Party | spec | Special issue | 33 | 1911 | 16 | ||||||||||||
AUT | Austria | DU | The Independents -- Lugner's List | Die Unabhängigen – Liste Lugner | Die Unabhaengigen -- Liste Lugner | spec | Special issue | 59 | 1745 | 16 | ||||||||||||
AUT | Austria | EU-STOP | EU Withdrawal, Direct Democracy, Neutrality | EU-Austritt, Direkte Demokratie, Neutralität | EU-Austritt, Direkte Demokratie, Neutralitaet | spec | Special issue | 59 | 2340 | 16 | ||||||||||||
AUT | Austria | GILT | My Vote Counts! | Liste Roland Düringer – Meine Stimme GILT | Liste Roland Dueringer -- Meine Stimme GILT | spec | Special issue | 59 | 2652 | 16 | ||||||||||||
AUT | Austria | Martin | Hans-Peter Martin's List | Liste Dr. Hans-Peter Martin | Liste Dr. Hans-Peter Martin | spec | Special issue | 4.2 | 5.0 | 3.4 | 2.85 | 1040951 | 1308 | 59 | 669 | 16 | ||||||
AUT | Austria | N | Citizens' Initiative for the retention of neutrality | Die Neutralen – Bürgerinitiative | Die Neutralen -- Buergerinitiative | spec | Special issue | 59 | 1750 | 16 | ||||||||||||
AUT | Austria | Nein | No -- Citizens' Initiative against EU membership | Nein – Bürgerinitiative gegen die EU Mitgliedschaft | Nein -- Buergerinitiative gegen die EU Mitgliedschaft | spec | Special issue | 59 | 1744 | 16 | ||||||||||||
AUT | Austria | T | Czechoslovakians | Tschechoslowaken | Tschechoslowaken | spec | Special issue | 59 | 2689 | 16 | ||||||||||||
BGR | Bulgaria | ER | Euroroma | Evroroma | Evroroma | spec | Special issue | 10 | 2178 | 16 | ||||||||||||
BGR | Bulgaria | FTB | Kingdom of Bulgaria Confederation | Federatsiya Tsarstvo Balgariya | Federatsiya Tsarstvo Balgariya | spec | Special issue | 10 | 800 | 16 | ||||||||||||
BGR | Bulgaria | GN | People's Voice | Glas Naroden | Glas Naroden | spec | Special issue | 10 | 2214 | 16 | ||||||||||||
BGR | Bulgaria | KSII | Simeon II Coalition | Koalitsiya Simeon II | Koalitsiya Simeon II | spec | Special issue | 6.86 | 6.29 | 6.33 | 7.7833 | 2006 | 10 | 15 | 16 | |||||||
BGR | Bulgaria | OT-SII | Union for Tzar [Simeon II] | Obedinenie za Tsar [Simeon II] | Obedinenie za Tsar [Simeon II] | spec | Special issue | 10 | 1149 | 16 | ||||||||||||
BGR | Bulgaria | PP | We Continue the Change | Prodalzhavame promyanata | Prodalzhavame promyanata | spec | Special issue | 10 | 2847 | 16 | ||||||||||||
CAN | Canada | BPC | Bloc Populaire Canadien | Bloc Populaire Canadien | Bloc Populaire Canadien | spec | Special issue | 29 | 1307 | 16 | ||||||||||||
CAN | Canada | PR | Rhinoceros Party | Parti Rhinoceros | Parti Rhinoceros | spec | Special issue | 29 | 2148 | 16 | ||||||||||||
CAN | Canada | SCR | Social Credit Rally | Ralliement créditiste | Ralliement creditiste | spec | Special issue | 29 | 677 | 16 | ||||||||||||
CAN | Canada | UE | Union of Electors | Union [Candidats] des électeurs | Union [Candidats] des electeurs | spec | Special issue | 29 | 2162 | 16 | ||||||||||||
CYP | Cyprus | AM | Awakening 2020 | Afypnisis 2020 | Afypnisis 2020 | spec | Special issue | 51 | 2819 | 16 | ||||||||||||
CYP | Cyprus | KGTZTK | Animal Party Cyprus | Kinima gia ta zoa tis Kíprou | Kinima gia ta zoa tis Kiprou | spec | Special issue | 51 | 2627 | 16 | ||||||||||||
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 | ||||||||||||
CZE | Czech Republic | HSD-SMS | Movement for Self-Governing Democracy -- Society for Moravia and Silesia | Hnutí za samosprávnou demokracii – Společnost pro Moravu a Slezsko | Hnuti za samospravnou demokracii -- Spolecnost pro Moravu a Slezsko | spec | Special issue | 82951 | 68 | 19 | 16 | |||||||||||
CZE | Czech Republic | P | Oath | Přísaha | Prisaha | spec | Special issue | 68 | 2831 | 16 | ||||||||||||
CZE | Czech Republic | Pi | Czech Pirate Party | Ceska piratska strana | Ceska piratska strana | spec | Special issue | 68 | 2261 | 16 | ||||||||||||
CZE | Czech Republic | SPP | Party of the Friends of Beer | Strana prátel piva | Strana pratel piva | spec | Special issue | 68 | 2222 | 16 | ||||||||||||
DEU | Germany | Grau | The Grays -- Gray Panthers | Die Grauen – Graue Panther | Die Grauen -- Graue Panther | spec | Special issue | 54 | 292 | 16 | ||||||||||||
DEU | Germany | PARTEI | The PARTY | Die PARTEI | Die PARTEI | spec | Special issue | 54 | 2649 | 16 | ||||||||||||
DEU | Germany | Pi | German Pirate Party | Piratenpartei Deutschland | Piratenpartei Deutschland | spec | Special issue | 54 | 865 | 16 | ||||||||||||
DEU | Germany | SSW | South Schleswig Voter League | Südschleswigscher Wählerverband | Suedschleswigscher Waehlerverband | spec | Special issue | 54 | 2850 | 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;