view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
178 rows where family_name_short = "spec" sorted by chess
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | 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 | 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 | ||||||||||||
DEU | Germany | Tier | Animal Protection Party | Tierschutzpartei | Tierschutzpartei | spec | Special issue | 54 | 301 | 16 | ||||||||||||
DEU | Germany | VRP | Reich Party for Civil Rights and Deflation | Reichspartei für Volksrecht und Aufwertung | Reichspartei fuer Volksrecht und Aufwertung | spec | Special issue | 54 | 2710 | 16 | ||||||||||||
DEU | Germany | dieBasis | Grassroots Democratic Party of Germany | Basisdemokratische Partei Deutschland | Basisdemokratische Partei Deutschland | spec | Special issue | 54 | 2821 | 16 | ||||||||||||
DNK | Denmark | SP | Schleswig Party | Slesvigsk Parti | Slesvigsk Parti | spec | Special issue | 21 | 812 | 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 | 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 | EHB | Basque Country Unite | Euskal Herria Bildu | Euskal Herria Bildu | spec | Special issue | 27 | 2603 | 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 | ||||||||||||
EST | Estonia | EPL | Estonian Pensioners' Union | Eesti Pensionaride Liit | Eesti Pensionaride Liit | spec | Special issue | 75 | 1792 | 16 | ||||||||||||
EST | Estonia | SK | Independent Royalists | Sõltumatud Kuningriiklased | Soltumatud Kuningriiklased | spec | Special issue | 83901 | 75 | 25 | 16 | |||||||||||
FIN | Finland | AS | Aland Coalition | Åländsk Samling | Alandsk Samling | spec | Special issue | 67 | 66 | 16 | ||||||||||||
FIN | Finland | Pi | Pirate Party Finland | Piraattipuolue | Piraattipuolue | spec | Special issue | 67 | 2412 | 16 | ||||||||||||
FIN | Finland | SEP | Finnish Pensioners Party | Suomen Eläkeläisten Puolue– Finlands Pensionärers Parti | Suomen Elakelaisten Puolue -- Finlands Pensionarers Parti | spec | Special issue | 67 | 1576 | 16 | ||||||||||||
FIN | Finland | VEU | Anti-EU Movement | Vaihtoehto EU:Lle | Vaihtoehto EU:Lle | spec | Special issue | 67 | 1649 | 16 | ||||||||||||
FIN | Finland | VSL | League for Free Finland | Vapaan Suomen Liitto – Självständighetspartiet | Vapaan Suomen Liitto -- Sjalvstandighetspartiet | spec | Special issue | 85 | 67 | 979 | 16 | |||||||||||
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 | ||||||||||||
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 | RP | Referendum Party | Referendum Party | Referendum Party | spec | Special issue | 44 | 2103 | 16 | ||||||||||||
GBR | United Kingdom | U | Unity | Unity | Unity | spec | Special issue | 44 | 349 | 16 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
HUN | Hungary | MKKP | Hungarian Two-tailed Dog Party | Magyar Kétfarkú Kutya Párt | Magyar Ketfarku Kutya Part | spec | Special issue | 39 | 2660 | 16 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | ||||||||||||
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 | UV | Valdotanian Union | Union Valdôtaine | Union Valdotaine | spec | Special issue | 26 | 974 | 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 |
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;