view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by family_name descending
This data as json, CSV (advanced)
Suggested facets: family_name_short, family_name, family_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AUS | Australia | INAT | Independet Nationalist | Independet Nationalist | Independet Nationalist | code | to be coded | 33 | 1903 | 28 | ||||||||||||
AUS | Australia | NF-NSW | Nationalist and Farmers (NSW) | Nationalist and Farmers (NSW) | Nationalist and Farmers (NSW) | code | to be coded | 33 | 1918 | 28 | ||||||||||||
AUS | Australia | OPA | One Parliament for Australia | One Parliament for Australia | One Parliament for Australia | code | to be coded | 33 | 1936 | 28 | ||||||||||||
AUS | Australia | SPA | Services Party of Australia | Services Party of Australia | Services Party of Australia | code | to be coded | 33 | 1897 | 28 | ||||||||||||
BEL | Belgium | UDB | Belgian Democratic Union | Union Democratique Belge | Union Democratique Belge | code | to be coded | 64 | 1181 | 28 | ||||||||||||
CHE | Switzerland | EJ | Agreement Jura | Entente jurassienne | Entente jurassienne | code | to be coded | 40 | 1964 | 28 | ||||||||||||
CYP | Cyprus | KEP | Free Citizens Movement | K.E.P | K.E.P | code | to be coded | 51 | 1735 | 28 | ||||||||||||
CYP | Cyprus | NEDEPA | New Democratic Front | Nea Demokratiki Parataxi | Nea Demokratiki Parataxi | code | to be coded | 51 | 1778 | 28 | ||||||||||||
CZE | Czech Republic | NEI | Independent Initiative | Nezávislá iniciativa | Nezavisla iniciativa | code | to be coded | 68 | 2221 | 28 | ||||||||||||
GBR | United Kingdom | R | Respect -- The Unity Coalition | Respect – The Unity Coalition | Respect -- The Unity Coalition | code | to be coded | 44 | 1057 | 28 | ||||||||||||
GBR | United Kingdom | RepLP | Republican Labour Party | Republican Labour Party | Republican Labour Party | code | to be coded | 44 | 1092 | 28 | ||||||||||||
GBR | United Kingdom | UPUP | Ulster Popular Unionist Party | Ulster Popular Unionist Party | Ulster Popular Unionist Party | code | to be coded | 44 | 1566 | 28 | ||||||||||||
GBR | United Kingdom | UUUC | United Ulster Unionist Coalition | United Ulster Unionist Coalition | United Ulster Unionist Coalition | code | to be coded | 44 | 1363 | 28 | ||||||||||||
HUN | Hungary | HVK | Patriotic Elections Coalition | Hazafias Választási Koalíció | Hazafias Valasztasi Koalicio | code | to be coded | 39 | 198 | 28 | ||||||||||||
HUN | Hungary | KP | Republican Party | Köztársaság Párt | Koztarsasag Part | code | to be coded | 39 | 2588 | 28 | ||||||||||||
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 | ||||||||||||
LUX | Luxembourg | FV | Independent People's Party | Fräi Vollekspartei | Frai Vollekspartei | code | to be coded | 7 | 2451 | 28 | ||||||||||||
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 | ||||||||||||
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 | PaRe | Republican Party | Partidul Republican | Partidul Republican | code | to be coded | 23 | 2098 | 28 | ||||||||||||
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 | ||||||||||||
SVN | Slovenia | SF | Slovenian Forum | Slovenski forum | Slovenski forum | code | to be coded | 60 | 2245 | 28 | ||||||||||||
SVN | Slovenia | SN | Party of Independence | Stranka neodvisnih | Stranka neodvisnih | code | to be coded | 60 | 2244 | 28 | ||||||||||||
SVN | Slovenia | SNS | Slovenian National Party | Slovenska nacionalna stranka | Slovenska nacionalna stranka | code | to be coded | 4.7941 | 4.3938 | 6.0148 | 2.6754 | 97710 | 265 | 1705710 | 4339 | 2907 | 60 | 981 | 28 | |||
AUS | Australia | IUAP-NSW | Independent UAP (NSW) | Independent UAP (NSW) | Independent UAP (NSW) | none | no family | 33 | 1941 | 12 | ||||||||||||
AUS | Australia | no-seat | no seat | no seat | no seat | none | no family | 33 | 2057 | 12 | ||||||||||||
AUS | Australia | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 33 | 1396 | 12 | ||||||||||||
AUS | Australia | one-seat | one seat | one seat | one seat | none | no family | 33 | 2299 | 12 | ||||||||||||
AUT | Austria | etc | others | others | others | none | no family | 59 | 2687 | 12 | ||||||||||||
AUT | Austria | no-seat | no seat | no seat | no seat | none | no family | 59 | 2055 | 12 | ||||||||||||
AUT | Austria | none | no party affiliation | Parteilose | Parteilose | none | no family | 59 | 272 | 12 | ||||||||||||
AUT | Austria | one-seat | one-seat | one-seat | one-seat | none | no family | 59 | 2686 | 12 | ||||||||||||
BEL | Belgium | etc | others | others | others | none | no family | 64 | 2488 | 12 | ||||||||||||
BEL | Belgium | no-seat | no seat | no seat | no seat | none | no family | 64 | 2052 | 12 | ||||||||||||
BEL | Belgium | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 64 | 1458 | 12 | ||||||||||||
BEL | Belgium | one-seat | one seat | one seat | one seat | none | no family | 64 | 2300 | 12 | ||||||||||||
BGR | Bulgaria | I-MK | Independent -- Mincho Kuminev | Independent – Mincho Kuminev | Independent -- Mincho Kuminev | none | no family | 10 | 2774 | 12 | ||||||||||||
BGR | Bulgaria | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 10 | 133 | 12 | ||||||||||||
CAN | Canada | etc | others | others | others | none | no family | 29 | 2577 | 12 | ||||||||||||
CAN | Canada | no-seat | no seat | no seat | no seat | none | no family | 29 | 2067 | 12 | ||||||||||||
CAN | Canada | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 29 | 1189 | 12 | ||||||||||||
CHE | Switzerland | KHM | Committee Herbert Maeder | Komitee Herbert Maeder | Komitee Herbert Maeder | none | no family | 40 | 1967 | 12 | ||||||||||||
CHE | Switzerland | etc | others | others | others | none | no family | 40 | 2579 | 12 | ||||||||||||
CHE | Switzerland | none | no party affiliation | parteilos | parteilos | none | no family | 40 | 1211 | 12 | ||||||||||||
CHE | Switzerland | one-seat | one seat | one seat | one seat | none | no family | 40 | 2303 | 12 | ||||||||||||
CYP | Cyprus | Greek | Greek | Greek | Greek | none | no family | 51 | 1071 | 12 | ||||||||||||
CYP | Cyprus | I-SL | Independent -- Sener Levent | Independent – Sener Levent | Independent -- Sener Levent | none | no family | 51 | 2343 | 12 | ||||||||||||
CYP | Cyprus | Turkish | Turkish | Turkish | Turkish | none | no family | 51 | 1655 | 12 | ||||||||||||
CYP | Cyprus | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 51 | 534 | 12 | ||||||||||||
CZE | Czech Republic | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 68 | 1567 | 12 | ||||||||||||
DEU | Germany | no-seat | no seat | no seat | no seat | none | no family | 54 | 2034 | 12 | ||||||||||||
DEU | Germany | none | no party affiliation | parteilos | parteilos | none | no family | 54 | 610 | 12 | ||||||||||||
DEU | Germany | one-seat | one seat | one seat | one seat | none | no family | 54 | 2289 | 12 | ||||||||||||
DNK | Denmark | GrFa | Greenland and Faroe Islands | Grønland og Færøerne | Gronland og Faeroerne | none | no family | 21 | 1634 | 12 | ||||||||||||
DNK | Denmark | etc | others | others | others | none | no family | 21 | 2576 | 12 | ||||||||||||
DNK | Denmark | no-seat | no seat | no seat | no seat | none | no family | 21 | 2058 | 12 | ||||||||||||
DNK | Denmark | none | no party affiliation | ingen | ingen | none | no family | 21 | 1128 | 12 | ||||||||||||
ESP | Spain | etc | others | others | others | none | no family | 27 | 1377 | 12 | ||||||||||||
ESP | Spain | no-seat | no seat | no seat | no seat | none | no family | 27 | 2056 | 12 | ||||||||||||
ESP | Spain | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 27 | 1166 | 12 | ||||||||||||
ESP | Spain | one-seat | one seat | one seat | one seat | none | no family | 27 | 2294 | 12 | ||||||||||||
EST | Estonia | I-DK | Independent -- Dimitri Klenski | Independent – Dimitri Klenski | Independent -- Dimitri Klenski | none | no family | 75 | 2031 | 12 | ||||||||||||
EST | Estonia | I-IT | Independent -- Indrek Tarand | Independent – Indrek Tarand | Independent -- Indrek Tarand | none | no family | 75 | 2029 | 12 | ||||||||||||
EST | Estonia | I-MH | Independent -- Martin Helme | Independent – Martin Helme | Independent -- Martin Helme | none | no family | 75 | 2030 | 12 | ||||||||||||
EST | Estonia | I-RK | Independent -- Raimond Kaljulaid | Independent – Raimond Kaljulaid | Independent -- Raimond Kaljulaid | none | no family | 75 | 2738 | 12 | ||||||||||||
EST | Estonia | I-SM | Independent -- Silver Meikar | Independent – Silver Meikar | Independent -- Silver Meikar | none | no family | 75 | 2345 | 12 | ||||||||||||
EST | Estonia | I-TT | Independent -- Tanel Talve | Independent – Tanel Talve | Independent -- Tanel Talve | none | no family | 75 | 2344 | 12 | ||||||||||||
EST | Estonia | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 75 | 426 | 12 | ||||||||||||
FIN | Finland | no-seat | no seat | no seat | no seat | none | no family | 67 | 2054 | 12 | ||||||||||||
FIN | Finland | none | no party affiliation | ei kukaan – ingen | ei kukaan -- ingen | none | no family | 67 | 1119 | 12 | ||||||||||||
FIN | Finland | one-seat | one seat | one seat | one seat | none | no family | 67 | 2413 | 12 | ||||||||||||
FRA | France | etc | others | divers | divers | none | no family | 43 | 1328 | 12 | ||||||||||||
FRA | France | no-seat | no seat | no seat | no seat | none | no family | 43 | 2080 | 12 | ||||||||||||
FRA | France | none | no party affiliation | sans étiquette | sans etiquette | none | no family | 43 | 947 | 12 | ||||||||||||
FRA | France | one-seat | one seat | one seat | one seat | none | no family | 43 | 2859 | 12 | ||||||||||||
GBR | United Kingdom | etc | others | others | others | none | no family | 44 | 453 | 12 | ||||||||||||
GBR | United Kingdom | no-seat | no seat | no seat | no seat | none | no family | 44 | 2562 | 12 | ||||||||||||
GBR | United Kingdom | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 44 | 1599 | 12 | ||||||||||||
GBR | United Kingdom | one-seat | one seat | one seat | one seat | none | no family | 44 | 2296 | 12 | ||||||||||||
GRC | Greece | no-seat | no seat | no seat | no seat | none | no family | 41 | 2168 | 12 | ||||||||||||
GRC | Greece | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 41 | 1358 | 12 | ||||||||||||
HRV | Croatia | I-IG | Independent List -- PhD Ivan Grubisic | Neovisna lista – dr.sc. Ivan Grubišić | Neovisna lista -- dr.sc. Ivan Grubisic | none | no family | 62 | 2195 | 12 | ||||||||||||
HRV | Croatia | I-MK | Independent -- Mislav Kolakusic | Independent – Mislav Kolakušić | Independent -- Mislav Kolakusic | none | no family | 62 | 2768 | 12 | ||||||||||||
HRV | Croatia | I-MP | Independent -- Marijana Petir | Independent – Marijana Petir | Independent -- Marijana Petir | none | no family | 62 | 2769 | 12 | ||||||||||||
HRV | Croatia | abroad | abroad | abroad | abroad | none | no family | 62 | 2191 | 12 | ||||||||||||
HRV | Croatia | ethnic | ethnic | ethnic | ethnic | none | no family | 62 | 2192 | 12 | ||||||||||||
HRV | Croatia | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 62 | 2197 | 12 | ||||||||||||
HRV | Croatia | one-seat | one seat | one seat | one seat | none | no family | 62 | 2295 | 12 | ||||||||||||
HUN | Hungary | no-seat | no seat | no seat | no seat | none | no family | 39 | 2350 | 12 | ||||||||||||
HUN | Hungary | none | no party affiliation | független | fuggetlen | none | no family | 39 | 1617 | 12 | ||||||||||||
HUN | Hungary | one-seat | one seat | one seat | one seat | none | no family | 39 | 952 | 12 | ||||||||||||
IRL | Ireland | I-LF | Independent -- Luke Flanagan | Independent – Luke Flanagan | Independent -- Luke Flanagan | none | no family | 37 | 2369 | 12 | ||||||||||||
IRL | Ireland | I-MH | Independent -- Marian Harkin | Independent – Marian Harkin | Independent -- Marian Harkin | none | no family | 37 | 2329 | 12 | ||||||||||||
IRL | Ireland | I-TJM | Independent -- Thomas (TJ) Maher | Independent – Thomas (TJ) Maher | Independent -- Thomas (TJ) Maher | none | no family | 37 | 2327 | 12 | ||||||||||||
IRL | Ireland | IA | Independent Alliance | Independent Alliance | Independent Alliance | none | no family | 37 | 2622 | 12 | ||||||||||||
IRL | Ireland | no-seat | no seat | no seat | no-seat | none | no family | 37 | 2216 | 12 | ||||||||||||
IRL | Ireland | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 1372000 | 37 | 30 | 12 |
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;