view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by country_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
SVK | Slovakia | DS | Democratic Party | Demokratická strana | Demokraticka strana | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 96420 | 1 | 1000 | 3 | |||||||
SVK | Slovakia | DUS | Democratic Union | Demokratická únia | Demokraticka unia | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 96421 | 1 | 1495 | 6 | |||||||
SVK | Slovakia | DV | Good Choice | Dobrá voľba | Dobra volba | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 1 | 2797 | 11 | ||||||||
SVK | Slovakia | HZD | Movement for Democracy | Hnutie za demokraciu | Hnutie za demokraciu | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 1 | 2160 | 26 | ||||||||
SVK | Slovakia | HZDS | Movement for a Democratic Slovakia | Hnutie za demokratické Slovensko | Hnutie za demokraticke Slovensko | con | Conservative | 4.8914 | 4.8199 | 5.9161 | 7.2855 | 96711 | 255 | 1703711 | 3403 | 3876 | 2801 | 1 | 1142 | 26 | ||
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 | ||||||||||||
SVK | Slovakia | KDH | Christian Democratic Movement | Kresťanskodemokratické hnutie | Krest'anskodemokraticke hnutie | chr | Christian democracy | 7.1082 | 6.9698 | 8.8217 | 6.6998 | 96521 | 254 | 1703521 | 3405 | 3902 | 2805 | 1 | 1432 | 3 | ||
SVK | Slovakia | KDZP | Christian Democracy -- Life and Prosperity | Kresťanská demokracia – Život a prosperita | Krestanska demokracia -- Zivot a prosperita | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 1 | 2783 | 3 | ||||||||
SVK | Slovakia | KSS | Communist Party of Slovakia | Komunistická strana Slovenska | Komunisticka strana Slovenska | com | Communist/Socialist | 0.5275 | 0.937 | 4.5302 | 3.5075 | 96222 | 1703222 | 3928 | 2807 | 1 | 44 | 14 | ||||
SVK | Slovakia | KSU | Christian Social Union | Krest’anská sociálna únia Slovenska | Krestanska socialna unia Slovenska | chr | Christian democracy | 6.6667 | 5.7 | 7.1 | 8.3 | 3406 | 1 | 936 | 3 | |||||||
SVK | Slovakia | KU | Christian Union | Kresťanská únia | Krestanska unia | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 1 | 2750 | 3 | ||||||||
SVK | Slovakia | LsNS | People's Party Our Slovakia | Ľudová strana Naše Slovensko | Ludova strana Nase Slovensko | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 1 | 586 | 40 | ||||||||
SVK | Slovakia | Lu+Ls | People's Union -- Liberal Party | Ludová únia – Liberálna strana | Ludova unia -- Liberalna strana | con | Conservative | 7.3684 | 5.2632 | 6.3158 | 9.4737 | 3954 | 1 | 1615 | 26 | |||||||
SVK | Slovakia | MH | Most-Hid | Most-Híd | Most-Hid | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 2813 | 1 | 1620 | 26 | |||||||
SVK | Slovakia | MK | Hungarian Coalition | Maďarskej koalície – Magyar koalíció | Ma'arskej koalicie -- Magyar koalicio | con | Conservative | 6.5005 | 6.0172 | 6.1761 | 9.3803 | 96952 | 259 | 1703954 | 4105 | 2804 | 1 | 559 | 26 | |||
SVK | Slovakia | MKDM | Hungarian Christian Democratic Movement | Maďarské kresťanskodemokratické hnutie – Magyar kereszténydemokrata mozgalom | Madarske krestanskodemokraticke hnutie -- Magyar keresztenydemokrata mozgalom | chr | Christian democracy | 6.6667 | 5.7 | 7.1 | 8.3 | 3407 | 1 | 2247 | 3 | |||||||
SVK | Slovakia | MOS | Hungarian Civic Party | Maďarská občianska strana – Magyar polgári párt | Madarska obcianska strana -- Magyar polgari part | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 1 | 2246 | 6 | ||||||||
SVK | Slovakia | MS | Beautiful Slovakia | Magnificat Slovakia | Magnificat Slovakia | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 1 | 2390 | 3 | ||||||||
SVK | Slovakia | NDS | National Democratic Party | Národno-demokratická strana | Narodno-demokraticka strana | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 96712 | 1 | 1228 | 40 | |||||||
SVK | Slovakia | NOVA | New Majority | Nová väčšina | Nova vacsina | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 1 | 2803 | 3 | ||||||||
SVK | Slovakia | NS | New Slovakia | Nové Slovensko | Nove Slovensko | spec | Special issue | 1 | 2237 | 16 | ||||||||||||
SVK | Slovakia | NaS-NS | Nation and Justice -- Our Party | Národ a spravodlivosť – Naša strana | Narod a spravodlivost -- Nasa strana | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 1 | 2391 | 40 | ||||||||
SVK | Slovakia | OKS | Civic Conservative Party | Obcianska konzervatívna strana | Obcianska konzervatIvna strana | con | Conservative | 8.4211 | 8.4211 | 8.4211 | 2.6316 | 3977 | 1 | 1645 | 26 | |||||||
SVK | Slovakia | OLaNO | Ordinary People and Independent | Obyčajní ľudia a nezávislé osobnosti | Obycajni ludia a nezavisle osobnosti | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 1 | 1759 | 26 | ||||||||
SVK | Slovakia | PS | Progressive Slovakia | Progresívne Slovensko | Progresivne Slovensko | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 1 | 2751 | 6 | ||||||||
SVK | Slovakia | PSNS | Real Slovak National Party | Pravá Slovenská národná strana | Prava Slovenska narodna strana | right | Right-wing | 8.5 | 3.75 | 8.62 | 3.45 | 2808 | 1 | 20 | 40 | |||||||
SVK | Slovakia | PaS | Law and Justice | Právo a spravodlivost | Pravo a spravodlivost | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 1 | 2389 | 14 | ||||||||
SVK | Slovakia | S | Network | Sieť | Siet | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 1 | 2624 | 26 | ||||||||
SVK | Slovakia | S-E | Coexistence | Spolužitie – Együttélés | Spoluzitie -- Egyutteles | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 1 | 2248 | 26 | ||||||||
SVK | Slovakia | SDA | Social Democratic Alternative | Sociálnodemokratická alternatíva | Socialnodemokraticka alternativa | soc | Social democracy | 3.0526 | 2.5965 | 1.7544 | 8.1754 | 4027 | 1 | 64 | 11 | |||||||
SVK | Slovakia | SDK | Slovak Democratic Coalition | Slovenská demokratická koalícia | Slovenska demokraticka koalicia | chr | Christian democracy | 7.19 | 7.77 | 4.02 | 9.225 | 96522 | 2802 | 1 | 313 | 3 | ||||||
SVK | Slovakia | SDKU-DS | Slovak Democratic and Christian Union -- Democratic Party | Slovenská demokratická a kresťanská únia – Demokratická strana | Slovenska demokraticka a krestanska unia -- Demokraticka strana | chr | Christian democracy | 7.3591 | 7.4401 | 5.0433 | 9.3905 | 96523 | 256 | 1703523 | 4079 | 2802 | 1 | 131 | 3 | |||
SVK | Slovakia | SDL | Party of the Democratic Left | Strana demokratickej ľavice | Strana demokratickej lavice | com | Communist/Socialist | 3.2398 | 2.5658 | 1.9079 | 7.7961 | 96220 | 3402 | 4053 | 1 | 1415 | 14 | |||||
SVK | Slovakia | SDL-05 | Party of the Democratic Left -- 2005 | Strana demokratickej ľavice – 2005 | Strana demokratickej lavice -- 2005 | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 1 | 2317 | 11 | ||||||||
SVK | Slovakia | SDSS | Social Democratic Party of Slovakia | Sociálnodemokratická strana Slovenska | Socialnodemokraticka strana Slovenska | soc | Social democracy | 4.8111 | 3.5 | 3.5 | 8.1 | 3404 | 1 | 1651 | 11 | |||||||
SVK | Slovakia | SF | Free Forum | Slobodné fórum | Slobodne forum | lib | Liberal | 5.46 | 6.58 | 3.18 | 7.95 | 1703524 | 2811 | 1 | 752 | 6 | ||||||
SVK | Slovakia | SNS | Slovak National Party | Slovenská národná strana | Slovenska narodna strana | right | Right-wing | 7.0198 | 4.5191 | 8.46 | 3.838 | 96710 | 257 | 1703710 | 3401 | 4131 | 2809 | 1 | 1072 | 40 | ||
SVK | Slovakia | SOP | Party of Civic Understanding | Strana občianskeho porozumenia | Strana obcianskeho porozumenia | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 96422 | 1 | 1016 | 11 | |||||||
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 | ||||||||||||
SVK | Slovakia | SPOLU | TOGETHER -- Civic Democracy | SPOLU – občianska demokracia | SPOLU -- obcianska demokracia | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 1 | 2752 | 6 | ||||||||
SVK | Slovakia | SPV | Alliance of Farmers and the Countryside | Spojenestvo poľnohospodárov a vidieka | Spojenestvo polnohospodarov a vidieka | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 1 | 2233 | 2 | ||||||||
SVK | Slovakia | SR | We are family -- Boris Kollar | Sme Rodina – Boris Kollár | Sme Rodina -- Boris Kollar | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 1 | 2623 | 40 | ||||||||
SVK | Slovakia | SSL | Freedom Party | Strana slobody | Strana slobody | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 1 | 2232 | 6 | ||||||||
SVK | Slovakia | SV | Common Choice | Spoločná voľba | Spolocna Vol'ba | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 96221 | 1 | 527 | 14 | |||||||
SVK | Slovakia | SZ-92 | Green Party -- 1992 | Strana zelených – 1992 | Strana zelenych -- 1992 | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 1 | 2235 | 19 | ||||||||
SVK | Slovakia | SZS | Green Party | Strana zelených | Strana Zelenych | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 96111 | 1 | 874 | 19 | |||||||
SVK | Slovakia | SaS | Freedom and Solidarity | Sloboda a solidarita | Sloboda a solidarita | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 2812 | 1 | 1460 | 6 | |||||||
SVK | Slovakia | Smer | Direction -- Social Democracy | Smer – sociálna demokracia | Smer -- socialna demokracia | soc | Social democracy | 3.3799 | 3.5124 | 3.6548 | 7.1697 | 96423 | 258 | 1703423 | 4157 | 2803 | 1 | 220 | 11 | |||
SVK | Slovakia | TIP | TIP Party -- We create another policy | Strana TIP – Tvoríme inú politiku | Strana TIP -- Tvorime inu politiku | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 1 | 2388 | 6 | ||||||||
SVK | Slovakia | V | Homeland | Vlasť | Vlast | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 1 | 2798 | 40 | ||||||||
SVK | Slovakia | VPN | Public against Violence | Verejnosť proti násiliu | Verejnos' proti nasiliu | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 96430 | 1 | 1061 | 6 | |||||||
SVK | Slovakia | ZAL | For the People | Za ľudí | Za ludi | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 1 | 2796 | 6 | ||||||||
SVK | Slovakia | ZRS | Association of Workers of Slovakia | Združenie robotníkov Slovenska | Zdruzenie robotnikov Slovenska | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 96210 | 1 | 1563 | 14 | |||||||
SVK | Slovakia | ZZ | Change from the Bottom, DU | Zmena zdola, DÚ | Zmena zdola, DU | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 1 | 2013 | 6 | ||||||||
SVK | Slovakia | etc | others | others | others | none | no family | 1 | 1659 | 12 | ||||||||||||
SVK | Slovakia | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 1 | 1359 | 12 | ||||||||||||
JPN | Japan | CDP | Constitutional Democratic Party of Japan | Rikken Minshutō | Rikken Minshuto | soc | Social democracy | 3.3 | 3.5 | 3.5 | 5 | 2657 | 11 | |||||||||
JPN | Japan | CoP | Cooperative Party | Kyoudoutou | Kyoudoutou | soc | Social democracy | 3.3 | 3.5 | 3.5 | 5 | 1738 | 11 | |||||||||
JPN | Japan | DP | Democratic Party | Minshutō | Minshuto | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 1734 | 26 | |||||||||
JPN | Japan | DPJ | Democratic Party of Japan | Minshutō | Minshuto | con | Conservative | 5.5717 | 5.06 | 4.1541 | 71624 | 8352 | 5 | 439 | 26 | |||||||
JPN | Japan | DPP | Democratic Party for the People | Kokumin Minshu-tō | Kokumin Minshu-to | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 2827 | 26 | |||||||||
JPN | Japan | DRP | Democratic Reform Party | Min-kai-ren | Min-kai-ren | soc | Social democracy | 3.3 | 3.5 | 3.5 | 5 | 163 | 11 | |||||||||
JPN | Japan | DSP | Democratic Socialist Party | Minshu Shakai-tō | Minshu Shakai-to | soc | Social democracy | 6.1556 | 3.5 | 3.5 | 71321 | 2204 | 5 | 1053 | 11 | |||||||
JPN | Japan | HRP | Happiness Realization Party | Kōfuku Jitsugen-tō | Kofuku Jitsugen-to | right | Right-wing | 8.8 | 5.9 | 8.5 | 5 | 2851 | 40 | |||||||||
JPN | Japan | IC | Independent's Club | Mushozoku-no-kai | Mushozoku-no-kai | none | no family | 5 | 695 | 12 | ||||||||||||
JPN | Japan | JCP | Japan Communist Party | Nihon Kyōsan-tō | Nihon Kyosan-to | com | Communist/Socialist | 1.148 | 4.072 | 4.032 | 71220 | 2201 | 8376 | 5 | 1540 | 14 | ||||||
JPN | Japan | JDP | Japan Democratic Party | Nihon Minshutō | Nihon Minshuto | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 1722 | 26 | |||||||||
JPN | Japan | JLP | Japan Liberal Party | Nihon Jiyūtō | Nihon Jiyuto | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 1726 | 26 | |||||||||
JPN | Japan | JNP | Japan New Party | Nihon Shintō | Nihon Shin-to | lib | Liberal | 8.2556 | 6.7 | 3.6 | 71952 | 2205 | 5 | 1327 | 6 | |||||||
JPN | Japan | JRP | Japan Renewal Party | Shinseitō | Shinsei-to | con | Conservative | 8.2556 | 6.4 | 6.9 | 71622 | 2205 | 5 | 547 | 26 | |||||||
JPN | Japan | JReP | Japan Restoration Party | Nippon Ishin no Kai | Nippon Ishin no Kai | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 2136 | 26 | |||||||||
JPN | Japan | JSP | Japan Socialist Party | Nihon Shakai-tō | Nihon Shakai-to | soc | Social democracy | 2.6344 | 4.1367 | 3.121 | 71320 | 2202 | 8472 | 5 | 940 | 11 | ||||||
JPN | Japan | JaRep | Japan Innovation Party | Nippon Ishin no Kai | Nippon Ishin no Kai | right | Right-wing | 8.8 | 5.9 | 8.5 | 5 | 2826 | 40 | |||||||||
JPN | Japan | K | Komeito Party | Kōmeitō | Komeito | con | Conservative | 5.6871 | 4.4549 | 6.25 | 71530 | 2203 | 8400 | 5 | 837 | 26 | ||||||
JPN | Japan | LDP | Liberal Democratic Party | Jiyū Minshutō | Jiyu Minshuto | con | Conservative | 8.0252 | 4.8094 | 7.7747 | 71620 | 2205 | 8424 | 5 | 1193 | 26 | ||||||
JPN | Japan | LFP | Labour Farmer Party | Rōdōnōmintō | Rodonominto | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 5 | 1736 | 14 | |||||||||
JPN | Japan | LL | Liberal League | Jiyu Rengo | Jiyu Rengo | lib | Liberal | 6.0 | 6.7 | 3.6 | 5 | 1165 | 6 | |||||||||
JPN | Japan | LP | Liberal Party | Jiyū-tō | Jiyu-to | con | Conservative | 7.4 | 6.4 | 6.9 | 71625 | 5 | 462 | 26 | ||||||||
JPN | Japan | LP(H) | Liberal Party (Hatoyama) | Nihon Jiyūtō (Hatoyama) | Nihon Jiyuto (Hatoyama) | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 1755 | 26 | |||||||||
JPN | Japan | LWSP | Left Wing Socialist Party | Saha Shakai Tô | Saha Shakai To | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 5 | 1723 | 14 | |||||||||
JPN | Japan | NCP | New Conservative Party | Hoshu Shintō | Hoshu Shinto | con | Conservative | 8.2675 | 5.6522 | 8.032 | 71626 | 8448 | 5 | 1382 | 26 | |||||||
JPN | Japan | NCoP | National Cooperative Party | Kokumin Kyôdô Tô | Kokumin Kyodo To | lib | Liberal | 6.0 | 6.7 | 3.6 | 5 | 1733 | 6 | |||||||||
JPN | Japan | NFP | New Frontier Party | Shinshin-to | Shinshin-to | con | Conservative | 8.2556 | 6.4 | 6.9 | 71623 | 2205 | 5 | 1136 | 26 | |||||||
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 | ||||||||||||
JPN | Japan | NLC | New Liberal Club | Shin-jiyū-kurabu | Shin jiyu karuba | con | Conservative | 7.4 | 6.4 | 6.9 | 71621 | 5 | 170 | 26 | ||||||||
JPN | Japan | NPD | New Party Daichi | Shintō Daichi | Shinto Daichi | lib | Liberal | 6.0 | 6.7 | 3.6 | 5 | 247 | 6 | |||||||||
JPN | Japan | NPN | New Party Nippon | Shintō Nippon | Shinto Nippon | lib | Liberal | 6.0 | 6.7 | 3.6 | 5 | 1175 | 6 | |||||||||
JPN | Japan | NPS | New Party Sakigake | Shinto Sakigake | Shinto Sakigake | con | Conservative | 7.4 | 6.4 | 6.9 | 71951 | 5 | 1146 | 26 | ||||||||
JPN | Japan | PFG | Party for Future Generations | Jisedai No Tou | Jisedai No Tou | right | Right-wing | 8.8 | 5.9 | 8.5 | 5 | 2404 | 40 | |||||||||
JPN | Japan | PH | Party of Hope | Kibō no Tō | Kibo no To | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 2656 | 26 | |||||||||
JPN | Japan | PLFP | People's Life First Party | Kokumin no Seikatsu ga Daiichi | Seikatsu no Tō | Kokumin no Seikatsu ga Daiichi | Seikatsu no To | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 2069 | 26 | |||||||||
JPN | Japan | PNP | People's New Party | Kokumin Shinto | Kokumin Shinto | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 4 | 26 | |||||||||
JPN | Japan | PR | Peace and Reform | Heiwa Kaikaku | Heiwa Kaikaku | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 2068 | 26 | |||||||||
JPN | Japan | RWSP | Right Wing Socialist Party | Uha Shakai Tô | Uha Shakai To | soc | Social democracy | 3.3 | 3.5 | 3.5 | 5 | 1724 | 11 | |||||||||
JPN | Japan | ReiShin | Reiwa Shinsengumi | Reiwa Shinsengumi | Reiwa Shinsengumi | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 5 | 2828 | 14 | |||||||||
JPN | Japan | SDF | Socialist Democratic Federation | Shaminren | Shaminren | soc | Social democracy | 3.3 | 3.5 | 3.5 | 71322 | 5 | 86 | 11 | ||||||||
JPN | Japan | SRP | Social Reform Party | Yakaikakushintou zu | Yakaikakushintou zu | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 5 | 1737 | 14 |
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;