view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
178 rows where family_name_short = "spec" sorted by country_id
This data as json, CSV (advanced)
Suggested facets: state_market, liberty_authority, cmp
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||
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 | ||||||||||||
LUX | Luxembourg | Bl | Citizens' List | Biergerlëscht | Biergerlescht | spec | Special issue | 416 | 1442009 | 7 | 1130 | 16 | ||||||||||
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 | 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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | |||||||||
LTU | Lithuania | DK | The Way of Courage | Drąsos kelias | Drasos kelias | spec | Special issue | 15 | 2121 | 16 | ||||||||||||
LTU | Lithuania | LLL | Lithuanian Liberty League | Lietuvos laisvės lyga | Lietuvos laisves lyga | spec | Special issue | 15 | 1782 | 16 | ||||||||||||
LTU | Lithuania | LLRA | Election Action of Lithuania's Poles | Lietuvos lenkų rinkimų akcija | Lietuvos lenku rinkimu akcija | spec | Special issue | 3.865 | 3.9 | 7.325 | 7.4667 | 88951 | 1440952 | 2511 | 15 | 28 | 16 | |||||
LTU | Lithuania | LPKTS | Union of Lithuanian Political Prisoners and Deportees | Lietuvos politinių kalinių ir terminių sąjunga | Lietuvos politiniu kaliniu ir tremtiniu sajunga | spec | Special issue | 9.8 | 2.25 | 8.6 | 1.0 | 88523 | 2513 | 15 | 1447 | 16 | ||||||
LTU | Lithuania | LRS | Lithuanian Russian Union | Lietuvos rusų sąjunga | Lietuvos rusu sajunga | spec | Special issue | 2.2 | 2.25 | 7.0 | 5.3333 | 204 | 1440524 | 2503 | 15 | 863 | 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 | Zp | Samogitian Party | Žemaičių partija | Zemaiciu partija | spec | Special issue | 15 | 2025 | 16 | ||||||||||||
TUR | Turkey | RP | Welfare (Virtue) Party | Refah (Fazilet) Partisi | Refah (Fazilet) Partisi | spec | Special issue | 8.3333 | 74715 | 4008 | 20 | 1122 | 16 | |||||||||
DNK | Denmark | Fobe | People's Movement against the EU | Folkebevægelsen mod EU | Folkebevaegelsen mod EU | spec | Special issue | 1.835 | 1.835 | 3.875 | 0.0917 | 73 | 1208954 | 217 | 21 | 749 | 16 | |||||
DNK | Denmark | JuBe | June Movement | JuniBevægelsen | JuniBevaegelsen | spec | Special issue | 2.585 | 2.415 | 3.875 | 0.5405 | 67 | 1208955 | 216 | 21 | 1450 | 16 | |||||
DNK | Denmark | SP | Schleswig Party | Slesvigsk Parti | Slesvigsk Parti | spec | Special issue | 21 | 812 | 16 | ||||||||||||
ROU | Romania | PPR | Party of Pensioners of Romania | Partidul Pensionarilor din Romania | Partidul Pensionarilor din Romania | spec | Special issue | 23 | 2106 | 16 | ||||||||||||
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 | 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 | MIS | Movement for the Independence of Sicily | Movimento Indipendentista Siciliano | Movimento Indipendentista Siciliano | spec | Special issue | 26 | 1028 | 16 | ||||||||||||
ITA | Italy | PNP | National Pensioners' Party | Partito Nazionale Pensionati | Partito Nazionale Pensionati | spec | Special issue | 26 | 613 | 16 | ||||||||||||
ITA | Italy | PP | Pensioners' Party | Partito Pensionati | Partito Pensionati | spec | Special issue | 5.75 | 4.5 | 8.0 | 6.0 | 830 | 26 | 502 | 16 | |||||||
ITA | Italy | SVP | South Tyrol Peoples Party | Südtiroler Volkspartei | Suedtiroler Volkspartei | spec | Special issue | 5.4 | 5.085 | 6.9 | 7.6083 | 827 | 26 | 1030 | 16 | |||||||
ITA | Italy | UV | Valdotanian Union | Union Valdôtaine | Union Valdotaine | spec | Special issue | 26 | 974 | 16 | ||||||||||||
ESP | Spain | AIC | Canary Islands Group | Agrupacion Independientes de Canarias | Agrupacion Independientes de Canarias | spec | Special issue | 27 | 411 | 16 | ||||||||||||
ESP | Spain | ARM | Ruiz-Mateos List | Agrupación Ruiz-Mateos | Agrupacion Ruiz-Mateos | spec | Special issue | 27 | 73 | 16 | ||||||||||||
ESP | Spain | BNG | Galician Nationalist Bloc | Bloque Nacionalista Galego | Bloque Nacionalista Galego | spec | Special issue | 2.9117 | 2.81 | 2.9378 | 6.6096 | 33908 | 356 | 1724908 | 514 | 513 | 27 | 520 | 16 | |||
ESP | Spain | Bai | Yes | Bai | Bai | spec | Special issue | 1724923 | 27 | 385 | 16 | |||||||||||
ESP | Spain | C-NE | European-Nationalist Coalition | Coalicion Nacionalista-Europea | Coalicion Nacionalista-Europea | spec | Special issue | 27 | 2172 | 16 | ||||||||||||
ESP | Spain | CA | Aragonese Council | Chunta Aragonesista | Chunta Aragonesista | spec | Special issue | 2.75 | 2.38 | 1.88 | 6.6667 | 520 | 27 | 1367 | 16 | |||||||
ESP | Spain | CC | Canary Coalition | Coalición Canaria | Coalicion Canaria | spec | Special issue | 5.9789 | 5.9 | 5.7694 | 8.0278 | 33907 | 392 | 1724907 | 517 | 27 | 234 | 16 | ||||
ESP | Spain | CEP | For the Europe of the Peoples | Coalición por la Europa de los Pueblos | Coalicion por la Europa de los Pueblos | spec | Special issue | 521 | 27 | 771 | 16 | |||||||||||
ESP | Spain | EA | Basque Solidarity | Eusko Alkartasuna | Eusko Alkartasuna | spec | Special issue | 4.3115 | 4.7873 | 4.555 | 7.4841 | 33903 | 1724903 | 3604 | 507 | 507 | 27 | 845 | 16 | |||
ESP | Spain | EHB | Basque Country Unite | Euskal Herria Bildu | Euskal Herria Bildu | spec | Special issue | 27 | 2603 | 16 | ||||||||||||
ESP | Spain | ERC | Republican Left of Catalonia | Esquerra Republicana de Catalunya | Esquerra Republicana de Catalunya | spec | Special issue | 3.1072 | 2.9073 | 2.7325 | 7.0389 | 33905 | 270 | 1724905 | 1406 | 511 | 511 | 27 | 757 | 16 | ||
ESP | Spain | HB | United People | Herri Batasuna | Herri Batasuna | spec | Special issue | 0.5909 | 1.8 | 4.3889 | 3.25 | 1401 | 3601 | 508 | 508 | 27 | 1317 | 16 | ||||
ESP | Spain | II-SP | Internationalist Initiative -- Solidarity between Peoples | Iniciativa Internacionalista – La Solidaridad entre los Pueblos | Iniciativa Internacionalista -- La Solidaridad entre los Pueblos | spec | Special issue | 27 | 681 | 16 | ||||||||||||
ESP | Spain | IP | Left of the Peoples | Izquierda de los Pueblos | Izquierda de los Pueblos | spec | Special issue | 27 | 121 | 16 | ||||||||||||
ESP | Spain | PACMA | Animalist Party Against Mistreatment to Animals | Partido Animalista Contra el Maltrato Animal | Partido Animalista Contra el Maltrato Animal | spec | Special issue | 27 | 2381 | 16 | ||||||||||||
ESP | Spain | PAR | Aragonese Regionalist Party | Partido Aragonés Regionalista | Partido Aragones Regionalista | spec | Special issue | 7.1909 | 6.2727 | 5.9583 | 8.75 | 33904 | 1411 | 510 | 510 | 27 | 1221 | 16 | ||||
ESP | Spain | UV | Valencian Union | Union Valenciana | Union Valenciana | spec | Special issue | 6.0417 | 5.7273 | 5.875 | 8.8769 | 512 | 512 | 27 | 443 | 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 | ||||||||||||
AUS | Australia | SCP | Social Credit Party | Social Credit Party | Social Credit Party | spec | Special issue | 33 | 1911 | 16 | ||||||||||||
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 | Balad | National Democratic Assembly | Brit Le'umit Demokratit | Brit Le'umit Demokratit | spec | Special issue | 0.7407 | 2.4163 | 5.2322 | 6423 | 34 | 805 | 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 | Mada | Arab Democratic Party | Miflaga Demokratit Aravit – al-Hizb al-Dimuqrati al-Arabi | Miflaga Demokratit Aravit al-Hizb -- al-Dimuqrati al-Arabi | spec | Special issue | 1.0526 | 2.5387 | 7.9257 | 72901 | 6539 | 34 | 1150 | 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 | Shas | Sephardi Guardians | Shomrei Sfarad | Shomrei Sfarad | spec | Special issue | 7.0417 | 2.1637 | 9.6842 | 72533 | 6555 | 34 | 788 | 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 | ||||||||||||
SWE | Sweden | Fi | Feminist Initiative | Feministiskt initiativ | Feministiskt initiativ | spec | Special issue | 286 | 35 | 1521 | 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;