view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
86 rows where family_name = "Green/Ecologist" sorted by party_name_short
This data as json, CSV (advanced)
Suggested facets: state_market, liberty_authority, eu_anti_pro, cmp, castles_mair, huber_inglehart
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DNK | Denmark | A | The Alternative | Alternativet | Alternativet | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 21 | 2567 | 19 | ||||||||
MLT | Malta | AD | Democratic Alternative | Alternattiva Demokratika | Alternattiva Demokratika | eco | Green/Ecologist | 3.7895 | 3.2632 | 4.6316 | 224 | 1470100 | 6986 | 72 | 360 | 19 | ||||||
AUS | Australia | AG | Australian Greens | Australian Greens | Australian Greens | eco | Green/Ecologist | 1.5439 | 1.2982 | 0.5614 | 4739 | 33 | 751 | 19 | ||||||||
BEL | Belgium | AGL-Gr | Agalev -- Green | Agalev – Groen | Agalev -- Groen | eco | Green/Ecologist | 2.5762 | 2.0089 | 1.0234 | 7.2593 | 21112 | 13 | 1056112 | 305 | 401 | 105 | 4963 | 105 | 64 | 1594 | 19 |
AUT | Austria | ALO | Alternative List Austria | Alternative Liste Österreichs | Alternative Liste Oesterreichs | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 59 | 1739 | 19 | ||||||||
HRV | Croatia | AM | Youth Action | Akcija mladih | Akcija mladih | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 62 | 2186 | 19 | ||||||||
ISR | Israel | AlYa | Green Leaf | Ale Yarok | Ale Yarok | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 34 | 2323 | 19 | |||||||||
DEU | Germany | B90/Gr | Alliance 90 / Greens -- Citizens' Movement | Bündnis 90 / Grüne – BürgerInnenbewegung | Buendnis 90 / Gruene -- BuergerInnenbewegung | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 41112 | 54 | 255 | 19 | |||||||
DEU | Germany | B90/Gru | Alliance 90 / Greens | Bündnis 90 / Die Grünen | Buendnis 90 / Die Gruenen | eco | Green/Ecologist | 2.9308 | 4.3268 | 1.3251 | 7.6101 | 41113 | 115 | 1276113 | 802 | 1502 | 305 | 6015 | 304 | 54 | 772 | 19 |
CHE | Switzerland | BHB | Young Peasants Movement | Bauernheimatbewegung – Jeunes paysans | Bauernheimatbewegung -- Jeunes paysans | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 40 | 1957 | 19 | ||||||||
ESP | Spain | CV | Confederation of the Greens | Confederación de los Verdes | Confederacion de los Verdes | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 27 | 2325 | 19 | ||||||||
SVN | Slovenia | DZL | Civic Green List | Driavljanska zelena lista | Driavljanska zelena lista | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 60 | 2570 | 19 | ||||||||
GRC | Greece | EDOK | Greek Democratic Ecological Movement | Ellhnikό Dhmokratikό Oikologikό Kίnhma | Ellhniko Dhmokratiko Oikologiko Kinhma | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 41 | 2164 | 19 | ||||||||
EST | Estonia | EER | Estonian Greens | Erakond Eestimaa Rohelised | Erakond Eestimaa Rohelised | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 79 | 1233100 | 2207 | 75 | 219 | 19 | |||||
EST | Estonia | EER-91 | Estonian Greens -- 1991 | Eesti Rohelised – 1991 | Eesti Rohelised -- 1991 | eco | Green/Ecologist | 5.5556 | 2.5 | 1.8 | 6.5 | 1206 | 75 | 2631 | 19 | |||||||
EST | Estonia | ELE | Richness of Life | Elurikkuse Erakond | Elurikkuse Erakond | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 75 | 2721 | 19 | ||||||||
ESP | Spain | EP-V | Europe of the People -- The Greens | Europa de los Pueblos – Verdes | Europa de los Pueblos -- Verdes | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 522 | 27 | 1657 | 19 | |||||||
BEL | Belgium | Ecolo | Confederated ecologists for the organisation of original struggles | Écologistes Confédérés pour l'organisation de luttes originales | Ecologistes Confederes pour l'organisation de luttes originales | eco | Green/Ecologist | 2.641 | 2.3887 | 1.3744 | 7.5411 | 21111 | 23 | 1056111 | 305 | 402 | 104 | 4923 | 104 | 64 | 161 | 19 |
FIN | Finland | Eko | Ecological Party | Ekologinen puolue – Ekologiska partiet | Ekologinen puolue -- Ekologiska partiet | eco | Green/Ecologist | 4.75 | 4.5 | 3.75 | 2.5 | 1413 | 67 | 1105 | 19 | |||||||
ESP | Spain | Equo | Equo | Equo | Equo | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 27 | 2804 | 19 | ||||||||
CHE | Switzerland | FGr-ASF | Feminists and Green-Alternative Groups | Feministische und grün-alternative Gruppierungen – Alternative socialiste verte et groupements féministes | Feministische und gruen-alternative Gruppierungen -- Alternative socialiste verte et groupements feministes | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 2.5 | 1712 | 40 | 569 | 19 | |||||||
ITA | Italy | FdLV | Green Lists | Federazione delle Liste Verdi | Federazione delle Liste Verdi | eco | Green/Ecologist | 1.7778 | 2.5 | 1.8 | 6.5 | 32110 | 2103 | 26 | 1304 | 19 | ||||||
ITA | Italy | FdV | Federation of the Greens | Federazione dei Verdi | Federazione dei Verdi | eco | Green/Ecologist | 2.3725 | 2.9566 | 1.0675 | 7.4499 | 32110 | 2103 | 808 | 6666 | 808 | 26 | 910 | 19 | |||
FRA | France | GE | Ecology Generation | Generation écologie | Generation ecologie | eco | Green/Ecologist | 3.6389 | 2.5 | 1.8 | 7.6167 | 31111 | 703 | 1405 | 611 | 43 | 650 | 19 | ||||
NLD | Netherlands | GL | GreenLeft | GroenLinks | GroenLinks | eco | Green/Ecologist | 2.0454 | 2.1108 | 1.644 | 6.1973 | 22110 | 297 | 1528110 | 2601 | 1005 | 7100 | 1005 | 8 | 756 | 19 | |
LUX | Luxembourg | GLEI | Green Left Ecological Initiative | Greng Lëscht Ekologesch Initiativ | Greng Lescht Ekologesch Initiativ | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 23111 | 906 | 7 | 1158 | 19 | |||||||
GBR | United Kingdom | GP | Green Party | Green Party | Green Party | eco | Green/Ecologist | 2.57 | 2.3775 | 2.0139 | 4.9858 | 420 | 1826110 | 1107 | 1107 | 44 | 467 | 19 | ||||
CAN | Canada | GPC | Green Party of Canada | Green Party of Canada | Green Party of Canada | eco | Green/Ecologist | 1.9018 | 2.2467 | 2.0327 | 5253 | 29 | 1259 | 19 | ||||||||
CHE | Switzerland | GPL-PVL | Green Liberal Party | Grünliberale Partei der Schweiz – Parti Vert-Libéral | Gruenliberale Partei der Schweiz -- Parti Vert-Liberal | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 3606 | 40 | 308 | 19 | |||||||
ISL | Iceland | Graen | Left-Green Movement | Vinstrihreyfingin – grænt framboð | Vinstrihreyfingin -- graent frambod | eco | Green/Ecologist | 1.1842 | 1.4474 | 1.6667 | 15111 | 6273 | 56 | 210 | 19 | |||||||
IRL | Ireland | Green | Green Party | Green Party – Comhaontas Glas | Green Party -- Comhaontas Glas | eco | Green/Ecologist | 2.435 | 2.462 | 2.1754 | 3.0472 | 53110 | 169 | 1372110 | 705 | 6327 | 705 | 37 | 1573 | 19 | ||
NZL | New Zealand | Greens | Green Party | Green Party | Green Party | eco | Green/Ecologist | 1.7729 | 2.2438 | 1.8 | 64110 | 7252 | 11 | 1171 | 19 | |||||||
LUX | Luxembourg | Greng | The Greens | Déi Gréng | Dei Greng | eco | Green/Ecologist | 2.5 | 1.5789 | 0.7895 | 23113 | 213 | 1442113 | 6946 | 7 | 310 | 19 | |||||
NLD | Netherlands | Groen | The Greens | De Groenen | De Groenen | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 8 | 2009 | 19 | ||||||||
DNK | Denmark | Gron | Greens | De Gronne | De Gronne | eco | Green/Ecologist | 1.1111 | 2.5 | 1.8 | 2.5 | 1101 | 207 | 21 | 797 | 19 | ||||||
CHE | Switzerland | Grue | Greens | Grüne – Écologiste | Gruene -- Ecologiste | eco | Green/Ecologist | 1.6886 | 1.7263 | 1.0316 | 6.507 | 43110 | 290 | 1711 | 8044 | 3605 | 40 | 141 | 19 | |||
AUT | Austria | Gruene | The Greens -- The Green Alternative | Die Grünen – Die Grüne Alternative | Die Gruenen -- Die Gruene Alternative | eco | Green/Ecologist | 2.4604 | 2.7489 | 1.4308 | 6.6845 | 42110 | 9 | 1040110 | 307 | 1304 | 4829 | 1304 | 59 | 1429 | 19 | |
ESP | Spain | ICV | Initiative for Catalonia Greens | Iniciativa per Catalunya Verds | Iniciativa per Catalunya Verds | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 27 | 2330 | 19 | ||||||||
ISL | Iceland | IDP | Iceland Democratic Party | Lýðræðisvaktin | Lydraedisvaktin | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 56 | 2208 | 19 | |||||||||
ISL | Iceland | IL | Icelandic Movement -- Living Country | Íslandshreyfingin – lifandi land | Islandshreyfingin -- lifandi land | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 56 | 2115 | 19 | |||||||||
ISL | Iceland | KL | Women's Alliance | Kvennalistinn | Kvennalistinn | eco | Green/Ecologist | 2.2222 | 2.5 | 1.8 | 15951 | 1701 | 56 | 147 | 19 | |||||||
CYP | Cyprus | KOP | Ecological and Environmental Movement | Kinima Oikologoi Perivallontistoi | Kinima Oikologoi Perivallontistoi | eco | Green/Ecologist | 5.7895 | 5.5263 | 5.7895 | 53 | 1196110 | 5441 | 51 | 1621 | 19 | ||||||
HUN | Hungary | LMP | Politics Can Be Different | Lehet Más a Politika | Lehet Mas a Politika | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 166 | 2309 | 39 | 403 | 19 | ||||||
ESP | Spain | LVE | Greens Ecologists | Los Verdes Ecologistas | Los Verdes Ecologistas | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 27 | 2301 | 19 | ||||||||
LTU | Lithuania | LZP | Lithuanian Green Party | Lietuvos žalioji partija | Lietuvos zalioji partija | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 15 | 21 | 19 | ||||||||
LVA | Latvia | LZP | Latvian Green Party | Latvijas Zaļā partija | Latvijas Zala partija | eco | Green/Ecologist | 4.6711 | 5.0216 | 6.0661 | 6.5643 | 2210 | 2405 | 55 | 1001 | 19 | ||||||
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 | ||||||||
NOR | Norway | MDG | Green Party | Miljøpartiet De Grønne | Miljopartiet De Gronne | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 9 | 2254 | 19 | ||||||||
ROU | Romania | MER | Romanian Ecological Movement | Miscarea Ecologista din Romania | Miscarea Ecologista din Romania | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 93111 | 23 | 1639 | 19 | |||||||
SWE | Sweden | MP | Greens | Miljöpartiet de Gröna | Miljopartiet de Grona | eco | Green/Ecologist | 3.3789 | 3.3866 | 2.5198 | 0.9875 | 11110 | 281 | 1752110 | 3703 | 1607 | 7920 | 1607 | 35 | 1154 | 19 | |
PRT | Portugal | MPT | Earth Party | Partido da Terra | Partido da Terra | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 63 | 2373 | 19 | ||||||||
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 | ||||||||
BGR | Bulgaria | NV | New Times | Novoto vreme | Novoto vreme | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 10 | 2180 | 19 | ||||||||
DEU | Germany | ODP | Ecological Democratic Party | Ökologisch-Demokratische Partei | Okologisch-Demokratische Partei | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 54 | 2736 | 19 | ||||||||
GRC | Greece | OE | Alternative Ecologists | Oikolόgoi Enallaktikoί | Oikologoi Enallaktikoi | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 3.3333 | 406 | 41 | 2163 | 19 | |||||||
GRC | Greece | OP | Ecologist Greens | Oikologoi Prasinoi | Oikologoi Prasinoi | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 154 | 1300116 | 411 | 41 | 1280 | 19 | |||||
HRV | Croatia | ORaH | Sustainable Development of Croatia | Održivi razvoj Hrvatske | Odrzivi razvoj Hrvatske | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 62 | 2382 | 19 | ||||||||
PRT | Portugal | PAN | Party for Animals and Nature | Partido pelos Animais e pela Natureza | Partido pelos Animais e pela Natureza | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 63 | 1781 | 19 | ||||||||
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 | PER | Romanian Ecologist Party | Partidul Ecologist Român | Partidul Ecologist Roman | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 93112 | 23 | 792 | 19 | |||||||
PRT | Portugal | PEV | Ecology Party -- Greens | Partido Ecologista – Os Verdes | Partido Ecologista -- Os Verdes | eco | Green/Ecologist | 1.6579 | 2.1711 | 1.3158 | 3.8596 | 35110 | 1213 | 7686 | 63 | 1535 | 19 | |||||
AUT | Austria | PILZ | JETZT -- Pilz List | JETZT – Liste Pilz | JETZT -- Liste Pilz | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 59 | 2651 | 19 | ||||||||
BGR | Bulgaria | PKE | Political Club "Ecoglasnost" | Politicheski Klub "Ekoglasnost" | Politicheski Klub "Ekoglasnost" | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 80110 | 10 | 1548 | 19 | |||||||
HUN | Hungary | PM | Dialogue for Hungary | Párbeszéd Magyarországért | Parbeszed Magyarorszagert | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 39 | 2349 | 19 | ||||||||
NLD | Netherlands | PPR | Radical Political Party | Politieke Partij Radikalen | Politieke Partij Radikalen | eco | Green/Ecologist | 1.6 | 2.5 | 1.8 | 5.0 | 22310 | 1103 | 1010 | 8 | 342 | 19 | |||||
POL | Poland | PZ | The Greens | Partia Zieloni | Partia Zieloni | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 74 | 2778 | 19 | ||||||||
ISL | Iceland | Pi | Pirate Party | Pírata | Pirata | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 56 | 2205 | 19 | |||||||||
SVN | Slovenia | Pose | Let's Unite | Povežimo se | Povezimo se | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 60 | 2755 | 19 | ||||||||
DNK | Denmark | SF | Socialist Peoples Party | Socialistisk Folkeparti | Socialistisk Folkeparti | eco | Green/Ecologist | 2.1347 | 2.1035 | 2.1476 | 3.5917 | 13230 | 70 | 1208230 | 503 | 1102 | 206 | 5621 | 206 | 21 | 1644 | 19 |
SVN | Slovenia | SMS | Youth Party of Slovenia | Stranka mladih Slovenije | Stranka mladih Slovenije | eco | Green/Ecologist | 4.2263 | 4.2719 | 2.7009 | 7.1388 | 97952 | 268 | 1705952 | 4313 | 2908 | 60 | 1512 | 19 | |||
SVN | Slovenia | SS | Dream Job | Sanjska služba | Sanjska sluzba | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 60 | 2385 | 19 | ||||||||
CZE | Czech Republic | SZ | Green Party | Strana zelených | Strana zelenych | eco | Green/Ecologist | 4.123 | 3.8917 | 1.8596 | 7.8505 | 61 | 1203110 | 1536 | 2107 | 68 | 196 | 19 | ||||
SVK | Slovakia | SZ-92 | Green Party -- 1992 | Strana zelených – 1992 | Strana zelenych -- 1992 | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 1 | 2235 | 19 | ||||||||
SVK | Slovakia | SZS | Green Party | Strana zelených | Strana Zelenych | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 96111 | 1 | 874 | 19 | |||||||
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 | |||||||||
FRA | France | V | Greens | Les Verts | Les Verts | eco | Green/Ecologist | 3.155 | 2.8774 | 1.4772 | 6.4585 | 31110 | 103 | 1250110 | 703 | 1406 | 605 | 5929 | 605 | 43 | 873 | 19 |
ITA | Italy | VA | Rainbow Greens | Verdi Arcobaleno | Verdi Arcobaleno | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 26 | 325 | 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 | ||||||||
AUT | Austria | VGO | United Greens Austria | Vereinte Grüne Österreichs | Vereinte Gruene Oesterreichs | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 59 | 1740 | 19 | ||||||||
FIN | Finland | VIHR | Green League | Vihreä Liitto – Gröna Förbundet | Vihrea Liitto -- Grona Forbundet | eco | Green/Ecologist | 3.6465 | 3.4279 | 2.2671 | 6.9709 | 14110 | 98 | 1246110 | 1302 | 1408 | 5797 | 1408 | 67 | 1062 | 19 | |
NZL | New Zealand | VP | Values Party | Values Party | Values Party | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 11 | 1761 | 19 | |||||||||
ISR | Israel | Ye | The Greens | HaYerukim | HaYerukim | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 34 | 2421 | 19 | |||||||||
BGR | Bulgaria | ZP | Green Party of Bulgaria | Zelena Partiya | Zelena Partija | eco | Green/Ecologist | 5.5556 | 2.5 | 1.8 | 6.5 | 705 | 10 | 963 | 19 | |||||||
SVN | Slovenia | ZS | Greens of Slovenia | Zeleni Slovenije | Zeleni Slovenije | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 97110 | 60 | 1619 | 19 | |||||||
HRV | Croatia | ZZ | Greens Together | Zeleni Zajedno | Zeleni Zajedno | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 62 | 2188 | 19 | ||||||||
FRA | France | d-eco | other ecologists | divers ecologistes | divers ecologistes | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 43 | 2249 | 19 |
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;