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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | IOM | Overseas Independents | Indépendants d'outre-mer | Independants d'outre-mer | spec | Special issue | 43 | 2277 | 16 | ||||||||||||
FRA | France | MIM | Martinican Independence Movement | Mouvement independantiste martiniquais | Mouvement independantiste martiniquais | spec | Special issue | 43 | 2077 | 16 | ||||||||||||
FRA | France | PA | Animalist Party | Parti animaliste | Parti animaliste | spec | Special issue | 43 | 2733 | 16 | ||||||||||||
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 | CUK | Change UK | Change UK | Change UK | spec | Special issue | 44 | 2730 | 16 | ||||||||||||
GBR | United Kingdom | ED | English Democrats | English Democrats | English Democrats | spec | Special issue | 44 | 2062 | 16 | ||||||||||||
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 | RP | Referendum Party | Referendum Party | Referendum Party | spec | Special issue | 44 | 2103 | 16 | ||||||||||||
GBR | United Kingdom | RepLP | Republican Labour Party | Republican Labour Party | Republican Labour Party | code | to be coded | 44 | 1092 | 28 | ||||||||||||
GBR | United Kingdom | U | Unity | Unity | Unity | spec | Special issue | 44 | 349 | 16 | ||||||||||||
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 | ||||||||||||
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 | Emp | Independent Muslim Lists | Empistosύnh (Rodόph) | Empistosunh (Rodoph) | spec | Special issue | 41 | 1059 | 16 | ||||||||||||
GRC | Greece | PMM | Panhellenic Macedonian Front | Panellήnio Makedonikό Metwpo | Panellnnio Makedoniko Metwpo | spec | Special issue | 41 | 2169 | 16 | ||||||||||||
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 | HSU | Croatian Party of Pensioners | Hrvatska stranka umirovljenika | Hrvatska stranka umirovljenika | spec | Special issue | 3108 | 62 | 2134 | 16 | |||||||||||
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 | PGS | Alliance of Primorje-Gorski | Primorsko goranski savez | Primorsko goranski savez | spec | Special issue | 62 | 2196 | 16 | ||||||||||||
HRV | Croatia | Pi | Pirate Party Croatia | Piratska stranka | Piratska stranka | spec | Special issue | 62 | 2190 | 16 | ||||||||||||
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 | 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 | 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 | ||||||||||||
HUN | Hungary | MKKP | Hungarian Two-tailed Dog Party | Magyar Kétfarkú Kutya Párt | Magyar Ketfarku Kutya Part | spec | Special issue | 39 | 2660 | 16 | ||||||||||||
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 | DDI | Direct Democracy Ireland | Direct Democracy Ireland | Direct Democracy Ireland | spec | Special issue | 37 | 2371 | 16 | ||||||||||||
IRL | Ireland | H-B | Anti H-Block | Anti H-Block | Anti H-Block | spec | Special issue | 37 | 1323 | 16 | ||||||||||||
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 | |||||||||||
IRL | Ireland | one-seat | one seat | one seat | one seat | none | no family | 37 | 2298 | 12 | ||||||||||||
ISL | Iceland | Dawn | Dawn -- Organization of justice, fairness and democracy | Dögun – stjórnmálasamtök um réttlæti, sanngirni og lýðræði | Dogun -- stjornmalasamtok um rettlaeti, sanngirni og lydraedi | spec | Special issue | 56 | 2206 | 16 | ||||||||||||
ISL | Iceland | FH | Households Party | Flokkur Heimilanna | Flokkur Heimilanna | spec | Special issue | 56 | 2207 | 16 | ||||||||||||
ISL | Iceland | Fb | Candidature Party | Framboðsflokkurinn | Frambodsflokkurinn | spec | Special issue | 56 | 2111 | 16 | ||||||||||||
ISL | Iceland | FlF | People's Party | Flokkur fólksins | Flokkur folksins | spec | Special issue | 56 | 2632 | 16 | ||||||||||||
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 | AY | Union of Israel | Agudat Yisrael | Agudat Yisrael | spec | Special issue | 72531 | 34 | 265 | 16 | |||||||||||
ISR | Israel | AmSh | Whole Nation | Am Shalem | Am Shalem | spec | Special issue | 34 | 2324 | 16 | ||||||||||||
ISR | Israel | Gil | Pensioners of Israel | Gimla'ey Israel | Gimla'ey Israel | spec | Special issue | 34 | 1873 | 16 | ||||||||||||
ISR | Israel | HDM | United Religious Front | Hazit Datit Meuhedet | Hazit Datit Meuhedet | spec | Special issue | 34 | 1821 | 16 | ||||||||||||
ISR | Israel | HDT | Religious Torah Front | Hazit Datit Toratit | Hazit Datit Toratit | spec | Special issue | 34 | 1837 | 16 | ||||||||||||
ISR | Israel | HHT | Yemenite Association | Hitahdut HaTeimanim | Hitahdut HaTeimanim | spec | Special issue | 34 | 1827 | 16 | ||||||||||||
ISR | Israel | HU | Agriculture and Development | Hakla'ut Ufituah | Hakla'ut Ufituah | spec | Special issue | 34 | 1835 | 16 | ||||||||||||
ISR | Israel | HaMi | Mizrachi Workers | Hapoel HaMizrachi | Hapoel HaMizrachi | spec | Special issue | 34 | 1828 | 16 | ||||||||||||
ISR | Israel | KP | Progress and Development | Kidma vePituah | Kidma vePituah | spec | Special issue | 34 | 1838 | 16 | ||||||||||||
ISR | Israel | KiVe | Progress and Work | Kidma Ve'avoda | Kidma Ve'avoda | spec | Special issue | 34 | 1834 | 16 | ||||||||||||
ISR | Israel | Mizrahi | Spiritual Centre | HaMizrahi – Merkaz Ruhani | HaMizrahi -- Merkaz Ruhani | spec | Special issue | 34 | 1833 | 16 | ||||||||||||
ISR | Israel | Mo | Heritage | Morasha | Morasha | spec | Special issue | 72534 | 34 | 31 | 16 | |||||||||||
ISR | Israel | OL | Jewish Power | Otzma Leyisrael | Otzma Leyisrael | spec | Special issue | 34 | 2322 | 16 | ||||||||||||
ISR | Israel | PAY | Agudat Israel Workers | Poalei Agudat Yisrael | Poalei Agudat Yisrael | spec | Special issue | 34 | 1832 | 16 | ||||||||||||
ISR | Israel | RALEV | Arab List for Bedouin and Villagers | Reshima Aravit LeBedouim VeKfariym | Reshima Aravit LeBedouim VeKfariym | spec | Special issue | 34 | 2357 | 16 | ||||||||||||
ISR | Israel | RAM-77 | United Arab List -- 1977 | Reshima Aravit Meuhedet – 1977 | Reshima Aravit Meuhedet -- 1977 | spec | Special issue | 34 | 2311 | 16 | ||||||||||||
ISR | Israel | RDAY | Democratic List for Israeli Arabs | Reshima Demokratit LeAravei Yisrael | Reshima Demokratit LeAravei Yisrael | spec | Special issue | 34 | 1829 | 16 | ||||||||||||
ISR | Israel | RDN | Democratic List of Nazareth | Reshima Demokratit shel Natzrat | Reshima Demokratit shel Natzrat | spec | Special issue | 34 | 1824 | 16 | ||||||||||||
ISR | Israel | Raam | United Arab List | al-Qā'ima al-'Arabiyya al-Muwaḥḥada | al-Qa'ima al-'Arabiyya al-Muwahhada | spec | Special issue | 34 | 1846 | 16 | ||||||||||||
ISR | Israel | ReLo | Fighters List | Reshimat HaLohmim | Reshimat HaLohmim | spec | Special issue | 34 | 2309 | 16 | ||||||||||||
ISR | Israel | SV | Cooperation and Brotherhood | Shituf VeAhvah | Shituf VeAahvah | spec | Special issue | 34 | 1839 | 16 | ||||||||||||
ISR | Israel | THTH | Movement for the Renewal of Social Zionism | Tenoa'a leHithadshut Tzionut Hevratit | Tenoa'a leHithadshut Tzionut Hevratit | spec | Special issue | 34 | 2354 | 16 | ||||||||||||
ISR | Israel | Taal | Arab Movement for Renewal | Tnu'a Aravit LeHithadshut | Tnu'a Aravit LeHithadshut | spec | Special issue | 34 | 2353 | 16 | ||||||||||||
ISR | Israel | Vitzo | Women's International Zionist Organization | Vitzo | Vitzo | spec | Special issue | 34 | 2310 | 16 | ||||||||||||
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 | AIE | Associative Italians Abroad | Associativo Italiani all'Estero | Associativo Italiani all'Estero | spec | Special issue | 26 | 927 | 16 | ||||||||||||
ITA | Italy | Fed | Federalism | Federalismo – Europa dei Popoli | Federalismo -- Europa dei Popoli | spec | Special issue | 26 | 473 | 16 | ||||||||||||
ITA | Italy | IpF | Together for the Future | Insieme per il Futuro | Insieme per il Futuro | none | no family | 26 | 2861 | 12 | ||||||||||||
ITA | Italy | LL | Lombard League | Liga Lombarda | Liga Lombarda | spec | Special issue | 26 | 1560 | 16 | ||||||||||||
ITA | Italy | LV | Venetian League | Liga Veneta | Liga Veneta | spec | Special issue | 26 | 1080 | 16 | ||||||||||||
ITA | Italy | M5S | Five Star Movement | Movimento 5 Stelle | Movimento 5 Stelle | none | no family | 26 | 2155 | 12 | ||||||||||||
ITA | Italy | MIS | Movement for the Independence of Sicily | Movimento Indipendentista Siciliano | Movimento Indipendentista Siciliano | spec | Special issue | 26 | 1028 | 16 | ||||||||||||
ITA | Italy | PC | Prime minister | Presidente del Consiglio dei ministri | Presidente del Consiglio dei ministri | none | no family | 26 | 2001 | 12 | ||||||||||||
ITA | Italy | PNP | National Pensioners' Party | Partito Nazionale Pensionati | Partito Nazionale Pensionati | spec | Special issue | 26 | 613 | 16 | ||||||||||||
ITA | Italy | UV | Valdotanian Union | Union Valdôtaine | Union Valdotaine | spec | Special issue | 26 | 974 | 16 | ||||||||||||
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 |
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;