view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by country_name_short 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
TUR | Turkey | AKP | Justice and Development Party | Adalet ve Kalkınma Partisi | Adalet ve Kalkinma Partisi | con | Conservative | 6.9873 | 3.797 | 8.499 | 8.6278 | 74622 | 306 | 8140 | 3401 | 20 | 901 | 26 | ||||
TUR | Turkey | ANAP | Motherland Party | Anavatan Partisi | Anavatan Partisi | con | Conservative | 6.213 | 5.7287 | 5.8991 | 9.2308 | 74623 | 4007 | 8162 | 20 | 1334 | 26 | |||||
TUR | Turkey | BBP | Great Union Party | Büyük Birlik Partisi | Buyuk Birlik Partisi | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 74626 | 20 | 240 | 40 | |||||||
TUR | Turkey | DSP | Democratic Left Party | Demokratik Sol Parti | Demokratik Sol Parti | soc | Social democracy | 3.8377 | 2.8138 | 5.2851 | 5.7263 | 74324 | 310 | 4005 | 8228 | 20 | 329 | 11 | ||||
TUR | Turkey | DTuP | Democratic Turkey Party | Democrat Türkiye Partisi | Democrat Turkiye Partisi | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 20 | 2315 | 26 | ||||||||
TUR | Turkey | DYP | Right Path Party | Doğru Yol Partisi | Dogru Yol Partisi | con | Conservative | 6.8239 | 5.2047 | 7.6316 | 6.7057 | 74624 | 4006 | 8250 | 3404 | 20 | 1141 | 26 | ||||
TUR | Turkey | GP | Young Party | Genç Parti | Genc Parti | right | Right-wing | 8.3821 | 6.2657 | 7.5731 | 2.5359 | 8272 | 3405 | 20 | 1647 | 40 | ||||||
TUR | Turkey | HADEP | People's Democracy Party | Halkın Demokrasi Partisi | Halkin Demokrasi Partisi | com | Communist/Socialist | 2.2267 | 2.5329 | 5.0175 | 8.5088 | 309 | 8206 | 3406 | 20 | 2305 | 14 | |||||
TUR | Turkey | HDP | Peoples' Democratic Party | Halkların Demokratik Partisi | Halklarin Demokratik Partisi | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 20 | 2572 | 14 | ||||||||
TUR | Turkey | IYI | Iyi Party | İyi Parti | Iyi Parti | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 20 | 2702 | 40 | ||||||||
TUR | Turkey | MDP | Nationalist Democratic Party | Milliyetçi Demokrasi Partisi | Milliyetci Demokrasi Partisi | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 74711 | 20 | 110 | 40 | |||||||
TUR | Turkey | MHP | National Action Party | Milliyetçi Hareket Partisi | Milliyetci Hareket Partisi | right | Right-wing | 8.6587 | 4.0081 | 9.4332 | 2.0078 | 74712 | 308 | 4009 | 8294 | 3403 | 20 | 408 | 40 | |||
TUR | Turkey | RP | Welfare (Virtue) Party | Refah (Fazilet) Partisi | Refah (Fazilet) Partisi | spec | Special issue | 8.3333 | 74715 | 4008 | 20 | 1122 | 16 | |||||||||
TUR | Turkey | SHP|CHP | Social Democratic Populist Party | Republican People's Party | Sosyal Demokrat Halçi Parti | Cumhuriyet Halk Partisi | Sosyal Demokrat Halci Parti | Cumhuriyet Halk Partisi | soc | Social democracy | 3.2661 | 2.8138 | 4.6154 | 7.3887 | 74321 | 307 | 4004 | 8184 | 3402 | 20 | 507 | 11 | |||
TUR | Turkey | SP | Felicity Party | Saadet Partisi | Saadet Partisi | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 316 | 20 | 1315 | 26 | |||||||
TUR | Turkey | YTP | New Turkey Party | Yeni Türkiye Partisi | Yeni Turkiye Partisi | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 20 | 2304 | 11 | ||||||||
TUR | Turkey | no-seat | no seat | no seat | no seat | none | no family | 20 | 2316 | 12 | ||||||||||||
TUR | Turkey | none | no party affiliation | bağımsız | bagimsiz | none | no family | 20 | 1399 | 12 | ||||||||||||
SWE | Sweden | C | Centre Party | Centerpartiet | Centerpartiet | agr | Agrarian | 5.8084 | 5.9903 | 6.0583 | 5.5679 | 11810 | 279 | 1752810 | 1504 | 3705 | 1603 | 7840 | 1603 | 35 | 1461 | 2 |
SWE | Sweden | FP | People's Party | Folkpartiet | Folkpartiet | lib | Liberal | 6.2906 | 7.3062 | 2.8515 | 9.4643 | 11420 | 280 | 1752420 | 1503 | 3704 | 1604 | 7860 | 1604 | 35 | 892 | 6 |
SWE | Sweden | Fi | Feminist Initiative | Feministiskt initiativ | Feministiskt initiativ | spec | Special issue | 286 | 35 | 1521 | 16 | |||||||||||
SWE | Sweden | JR | National Farmers' Union | Jordbrukarnas Riksförbund | Jordbrukarnas Riksforbund | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 35 | 2556 | 2 | ||||||||
SWE | Sweden | Jl | June List | Junilistan | Junilistan | spec | Special issue | 5.67 | 5.89 | 5.14 | 1.5167 | 284 | 1609 | 35 | 404 | 16 | ||||||
SWE | Sweden | KD | Christian Democrats | Kristdemokraterna | Kristdemokraterna | chr | Christian democracy | 7.195 | 6.7938 | 7.9997 | 7.8597 | 11520 | 283 | 1752520 | 3706 | 1606 | 7880 | 1606 | 35 | 282 | 3 | |
SWE | Sweden | M | Moderate Party | Moderaterna | Moderaterna | con | Conservative | 7.8907 | 8.4089 | 5.6977 | 8.5872 | 11620 | 278 | 1752620 | 1505 | 3707 | 1605 | 7900 | 1605 | 35 | 657 | 26 |
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 | |
SWE | Sweden | MbS | Citizens Coalition | Medborgerlig samling | Medborgerlig samling | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 35 | 802 | 26 | ||||||||
SWE | Sweden | Mi | Middle Parties | Mittenpartierna | Mittenpartierna | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 35 | 1010 | 6 | ||||||||
SWE | Sweden | NP-AV | National Party [General Electoral League] | Nationella partiet [Allmänna Valmansförbundet] | Nationella partiet [Allmanna Valmansforbundet] | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 35 | 2608 | 26 | ||||||||
SWE | Sweden | NyD | New Democracy | Ny Demokrati | Ny Demokrati | right | Right-wing | 8.9944 | 8.0 | 6.0 | 7.5 | 11951 | 3708 | 1608 | 1608 | 35 | 951 | 40 | ||||
SWE | Sweden | Pi | Pirate Party | Piratpartiet | Piratpartiet | spec | Special issue | 287 | 1752000 | 1611 | 35 | 721 | 16 | |||||||||
SWE | Sweden | SAP | Social Democrats | Socialdemokraterna | Socialdemokraterna | soc | Social democracy | 3.4447 | 3.5655 | 4.4407 | 7.4445 | 11320 | 277 | 1752320 | 1502 | 3702 | 1602 | 7940 | 1602 | 35 | 904 | 11 |
SWE | Sweden | SD | Sweden Democrats | Sverigedemokraterna | Sverigedemokraterna | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 285 | 1752700 | 1610 | 35 | 1546 | 40 | |||||
SWE | Sweden | SJ | Sarajevo List | Sarajevolistan | Sarajevolistan | spec | Special issue | 35 | 1806 | 16 | ||||||||||||
SWE | Sweden | SKP-H | Communist Party of Sweden [Hoglund] | Sveriges Kommunistiska Parti [Höglund] | Sveriges Kommunistiska Parti [Hoglund] | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 35 | 2475 | 14 | ||||||||
SWE | Sweden | SLP | Liberal Party of Sweden | Sveriges Liberala Parti | Sveriges Liberala Parti | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 35 | 2477 | 6 | ||||||||
SWE | Sweden | SP | Socialist Party | Socialistiska partiet | Socialistiska partiet | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 35 | 2478 | 14 | ||||||||
SWE | Sweden | SPI | Swedish Senior Citizen Interest Party | Sveriges pensionärers intresseparti | Sveriges pensionarers intresseparti | spec | Special issue | 35 | 407 | 16 | ||||||||||||
SWE | Sweden | SSV-21 | Social Democratic Left Party of Sweden -- 1921 | Sverges Socialdemokratiska Vänsterparti – 1921 | Sverges Socialdemokratiska Vansterparti -- 1921 | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 35 | 2557 | 14 | ||||||||
SWE | Sweden | V | Left Party (Communists) | Vänsterpartiet (kommunisterna) | Vansterpartiet (kommunisterna) | com | Communist/Socialist | 1.5464 | 1.4121 | 2.4562 | 1.2042 | 11220 | 282 | 1752220 | 1501 | 3701 | 1601 | 7960 | 1601 | 35 | 882 | 14 |
SWE | Sweden | VSP | Left Socialist Party | Vänstersocialistiska Partiet | Vanstersocialistiska Partiet | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 35 | 2406 | 11 | ||||||||
SWE | Sweden | no-seat | no seat | no seat | no seat | none | no family | 35 | 2405 | 12 | ||||||||||||
SWE | Sweden | none | no party affiliation | partilös | partilos | none | no family | 35 | 786 | 12 | ||||||||||||
SVN | Slovenia | AS | Active Slovenia | Aktivna Slovenija | Aktivna Slovenija | lib | Liberal | 4.6 | 3.8 | 2.6 | 7.3333 | 2909 | 60 | 380 | 6 | |||||||
SVN | Slovenia | DD | Good Country | Dobra Drzava | Dobra Drzava | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2669 | 11 | ||||||||
SVN | Slovenia | DEMOS | Democratic Opposition of Slovenia | Demokratična opozicija Slovenije | Demokraticna opozicija Slovenije | spec | Special issue | 60 | 321 | 16 | ||||||||||||
SVN | Slovenia | DL | Civic List | Državljanska lista | Drzavljanska lista | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 60 | 1988 | 6 | ||||||||
SVN | Slovenia | DOM | Homeland League | Domovinska liga | Domovinska liga | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 60 | 2754 | 40 | ||||||||
SVN | Slovenia | DS | Democratic Party | Demokratska stranka | Demokratska stranka | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 97430 | 60 | 143 | 11 | |||||||
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 | ||||||||
SVN | Slovenia | DeSUS | Democratic Party of Pensioners of Slovenia | Demokratična stranka upokojencev Slovenije | Demokraticna stranka upokojencev Slovenije | spec | Special issue | 3.2292 | 3.225 | 5.0708 | 7.0936 | 97951 | 260 | 1705951 | 4183 | 2906 | 60 | 1587 | 16 | |||
SVN | Slovenia | GS | Freedom Movement | Gibanje Svoboda | Gibanje Svoboda | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2856 | 11 | ||||||||
SVN | Slovenia | GZD | Healthy Society Movement | Gibanje Zdrava Družba | Gibanje Zdrava Druzba | spec | Special issue | 60 | 2886 | 16 | ||||||||||||
SVN | Slovenia | GZS | Voice of Slovenian women | Glas žensk Slovenije | Glas zensk Slovenije | spec | Special issue | 60 | 2022 | 16 | ||||||||||||
SVN | Slovenia | I-JK | Independent -- Jelko Kacin | Independent – Jelko Kacin | Independent -- Jelko Kacin | none | no family | 60 | 2383 | 12 | ||||||||||||
SVN | Slovenia | IDS | Initiative for Democratic Socialism | Iniciativa za demokratični socializem | Iniciativa za demokraticni socializem | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 60 | 2335 | 14 | ||||||||
SVN | Slovenia | Ita | Italian national community | Italijanska narodna skupnost | Italijanska narodna skupnost | spec | Special issue | 60 | 199 | 16 | ||||||||||||
SVN | Slovenia | KS | Christian Socialists | Krščanski socialisti | Krscanski socialisti | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 60 | 2241 | 3 | ||||||||
SVN | Slovenia | L | The Left | Levica | Levica | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 60 | 2670 | 14 | ||||||||
SVN | Slovenia | LDS | Liberal Democracy of Slovenia | Liberalna demokracija Slovenije | Liberalna demokracija Slovenije | lib | Liberal | 3.7351 | 4.6316 | 2.5756 | 9.1901 | 97421 | 261 | 1705421 | 4209 | 2901 | 60 | 1252 | 6 | |||
SVN | Slovenia | LDSS | Liberal Democratic Party of Slovenia | Liberalno demokratska stranka Slovenije | Liberalno demokratska stranka Slovenije | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 60 | 2243 | 6 | ||||||||
SVN | Slovenia | LIPA | Party Lime Tree | Stranka Lipa | Stranka Lipa | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 60 | 1946 | 40 | ||||||||
SVN | Slovenia | LMS | List of Marjan Sarec | Lista Marjana Šarca | Lista Marjana Sarca | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2668 | 11 | ||||||||
SVN | Slovenia | LZJ-PS | Zoran Jankovic's List -- Positive Slovenia | Lista Zorana Jankovića – Pozitivna Slovenija | Lista Zorana Jankovica -- Pozitivna Slovenija | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 1987 | 11 | ||||||||
SVN | Slovenia | Mad | Hungarian national community | Madžarska narodna skupnost | Madzarska narodna skupnost | spec | Special issue | 60 | 65 | 16 | ||||||||||||
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 | ||||||||
SVN | Slovenia | NDS | National Democratic Party | Narodno demokratska stranka | Narodno demokratska stranka | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 60 | 2573 | 26 | ||||||||
SVN | Slovenia | NSI | New Slovenia -- Christian People's Party | Nova Slovenija – Krščanska ljudska stranka | Nova Slovenija -- Krscanska ljudska stranka | chr | Christian democracy | 7.9345 | 5.9719 | 8.3998 | 8.4866 | 97522 | 262 | 1705522 | 4235 | 2905 | 60 | 1047 | 3 | |||
SVN | Slovenia | PSS | Slovenian Pirate Party | Piratska stranka Slovenije | Piratska stranka Slovenije | spec | Special issue | 60 | 2338 | 16 | ||||||||||||
SVN | Slovenia | PoS | Let's Connect Slovenia | Povežimo Slovenijo | Povezimo Slovenijo | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 60 | 2884 | 26 | ||||||||
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 | ||||||||
SVN | Slovenia | Resni.ca | Resni.ca | Resni.ca | Resni ca | spec | Special issue | 60 | 2885 | 16 | ||||||||||||
SVN | Slovenia | S | Solidarity | Solidarnost | Solidarnost | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2386 | 11 | ||||||||
SVN | Slovenia | SDS | Slovenian Democratic Party | Slovenska demokratska stranka | Slovenska demokratska stranka | chr | Christian democracy | 6.9996 | 5.6339 | 6.7947 | 8.804 | 97320 | 263 | 1705320 | 4261 | 2902 | 60 | 179 | 3 | |||
SVN | Slovenia | SDZ | Slovenian Democratic Union | Slovenska demokratična zveza | Slovenska demokraticna zveza | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 60 | 1371 | 6 | ||||||||
SVN | Slovenia | SF | Slovenian Forum | Slovenski forum | Slovenski forum | code | to be coded | 60 | 2245 | 28 | ||||||||||||
SVN | Slovenia | SLS | Slovenian People's Party | Slovenska ljudska stranka | Slovenska ljudska stranka | chr | Christian democracy | 6.6953 | 5.0282 | 7.6299 | 6.8549 | 97521 | 264 | 1705521 | 4287 | 2904 | 60 | 16 | 3 | |||
SVN | Slovenia | SMC | Modern Center Party | Stranka modernega | Stranka modernega | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2333 | 11 | ||||||||
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 | 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 | |||
SVN | Slovenia | SO | Slovenia is Ours | Slovenija je naša | Slovenija je nasa | spec | Special issue | 60 | 2019 | 16 | ||||||||||||
SVN | Slovenia | SOPS | Slovenian Craftsmen and Entreprenerial Party | Slovenska obrtno podjetniška stranka | Slovenska obrtno podjetniska stranka | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 60 | 2275 | 6 | ||||||||
SVN | Slovenia | SOS | Slovenian Liberal Party | Slovenska obrtniöka stranka | Slovenska obrtnioka stranka | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 60 | 875 | 6 | ||||||||
SVN | Slovenia | SS | Dream Job | Sanjska služba | Sanjska sluzba | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 60 | 2385 | 19 | ||||||||
SVN | Slovenia | SSS | Socialist Party of Slovenia | Socialistična stranka Slovenije | Socialisticna stranka Slovenije | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 60 | 317 | 14 | ||||||||
SVN | Slovenia | TRS | Party for Sustainable Development of Slovenia | Stranka za trajnostni razvoj Slovenije | Stranka za trajnostni razvoj Slovenije | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 1989 | 11 | ||||||||
SVN | Slovenia | V | I Believe | Verjamem | Verjamem | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2384 | 11 | ||||||||
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 | ||||||||
SVN | Slovenia | ZEO | League for Citizens' Equality | Zveza za enakopravnost obCanov | Zveza za enakopravnost obCanov | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2571 | 11 | ||||||||
SVN | Slovenia | ZL-SD | United List -- Social Democrats | Združena lista – Socialni demokrati | Zdruzena lista -- Socialni demokrati | soc | Social democracy | 3.0637 | 3.8001 | 2.9642 | 8.1513 | 97321 | 266 | 1705323 | 4365 | 2903 | 60 | 706 | 11 | |||
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 | |||||||
SVN | Slovenia | ZaAB | Alliance of Alenka Bratusek | Zavezništvo Alenke Bratušek | Zaveznistvo Alenke Bratusek | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 60 | 2337 | 11 | ||||||||
SVN | Slovenia | Zares | For Real | Zares | Zares | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 267 | 1705324 | 2910 | 60 | 326 | 11 | |||||
SVN | Slovenia | ZdLe | United Left | Združena levica | Zdruzena levica | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 60 | 2334 | 14 | ||||||||
SVN | Slovenia | etc | others | others | others | none | no family | 60 | 753 | 12 | ||||||||||||
SVN | Slovenia | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 60 | 1370 | 12 | ||||||||||||
SVK | Slovakia | 99% | 99 Percent -- Civic Voice | 99% – občiansky hlas | 99% -- obciansky hlas | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 1 | 2015 | 14 | ||||||||
SVK | Slovakia | ADS | Alliance of Democrats | Aliancia demokratov Slovenska | Aliancia demokratov Slovenska | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 96431 | 1 | 1624 | 6 | |||||||
SVK | Slovakia | ANO | Alliance of the New Citizen | Aliancia nového občana | Aliancia noveho obcana | lib | Liberal | 7.2404 | 7.945 | 1.9712 | 9.4714 | 96424 | 3850 | 2806 | 1 | 1200 | 6 |
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;