view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by chess
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BEL | Belgium | ROSSEM | Radical Reformers Fighting for an Upright Society | Radikale Omvormers Strijdersen Stubbelaars vor Maatschappij | Radikale Omvormers Strijdersen Stubbelaars vor Maatschappij | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 113 | 64 | 748 | 6 | |||||||
BEL | Belgium | RW | Walloon Rally | Rassemblement Wallon | Rassemblement Wallon | soc | Social democracy | 2.6 | 3.5 | 3.5 | 8.1 | 21911 | 303 | 64 | 460 | 11 | ||||||
BEL | Belgium | Rex | Rexist Party | Parti Rexiste | Parti Rexiste | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 64 | 2425 | 40 | ||||||||
BEL | Belgium | RvA-UpD | Respect for Labour | Respect voor Arbeid en Democratie – Union pour la Democratie et le Respect du Travail | Respect voor Arbeid en Democratie -- Union pour la Democratie et le Respect du Travail | right | Right-wing | 9.2 | 5.9 | 8.5 | 2.3 | 312 | 64 | 1440 | 40 | |||||||
BEL | Belgium | UDB | Belgian Democratic Union | Union Democratique Belge | Union Democratique Belge | code | to be coded | 64 | 1181 | 28 | ||||||||||||
BEL | Belgium | V | Alive | Vivant | Vivant | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 64 | 620 | 6 | ||||||||
BEL | Belgium | WOW | Growing Old in Dignity | Waardig Ouder Worden | Growing Old in Dignity | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 64 | 470 | 40 | ||||||||
BEL | Belgium | etc | others | others | others | none | no family | 64 | 2488 | 12 | ||||||||||||
BEL | Belgium | no-seat | no seat | no seat | no seat | none | no family | 64 | 2052 | 12 | ||||||||||||
BEL | Belgium | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 64 | 1458 | 12 | ||||||||||||
BEL | Belgium | one-seat | one seat | one seat | one seat | none | no family | 64 | 2300 | 12 | ||||||||||||
BGR | Bulgaria | ABV | Alternative for Bulgarian Revival | Alternativa za balgarsko vazrazhdane | Alternativa za balgarsko vazrazhdane | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2364 | 11 | ||||||||
BGR | Bulgaria | BBB | Bulgarian Business Bloc | Balgarski Biznes Blok | Balgarski Biznes Blok | lib | Liberal | 6.6784 | 7.076 | 5.1974 | 7.6842 | 80901 | 708 | 737 | 10 | 599 | 6 | |||||
BGR | Bulgaria | BBZ | Bulgaria Without Censorship | Balgarija bes Zensura | Balgarija bes Zensura | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2362 | 26 | ||||||||
BGR | Bulgaria | BE | Euro-Left Coalition | Balgarska Evrolevica | Balgarska Evrolevica | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 80320 | 10 | 710 | 11 | |||||||
BGR | Bulgaria | BNG | Bulgaria for Citizens Movement | Dvizhenie "Balgariya na grazhdanite" | Dvizhenie "Balgariya na grazhdanite" | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2213 | 26 | ||||||||
BGR | Bulgaria | BNO|BN | Bulgarian National Unification | Bulgarian Summer | Bŭlgarsko natsionalno obedinenie | Balgarsko lyato | Bulgarsko natsionalno obedinenie | Balgarsko lyato | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 2840 | 40 | ||||||||
BGR | Bulgaria | BNRP | Bulgarian National Radical Party | Balgarska Natsionalnoradikalna Partiya | Balgarska Natsionalnoradikalna Partiya | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 364 | 40 | ||||||||
BGR | Bulgaria | BSP | Bulgarian Socialist Party | Balgarska Sotsialisticheska Partiya | Balgarska Potsialisticheska Partiya | soc | Social democracy | 3.0064 | 2.9187 | 4.5029 | 8.1871 | 80220 | 26 | 1100300 | 702 | 841 | 10 | 982 | 11 | |||
BGR | Bulgaria | BV | Bulgarian Rise | Balgarski vazhod | Balgarski vazhod | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2871 | 26 | ||||||||
BGR | Bulgaria | BZNS-NP | Bulgarian Agrarian National Union -- "Nikola Petkov" | Balgarski Zemedelski Naroden Suyuz – "Nikola Petkov" | Balgarski Zemedelski Naroden Suyuz -- "Nikola Petkov" | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 10 | 2173 | 2 | ||||||||
BGR | Bulgaria | CSD | Centre -- Freedom and Dignity | Tsentŭr – Svoboda i dostoĭnstvo | Center -- Svoboda i dostojnstvo | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2595 | 6 | ||||||||
BGR | Bulgaria | D21 | Movement 21 | Dvizhenie 21 | Dvizhenie 21 | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2379 | 11 | ||||||||
BGR | Bulgaria | DAR | Democratic Alternative for the Republic | Demokratichna Alternativa za Republikata | Demokratichna Alternativa za Republikata | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2170 | 11 | ||||||||
BGR | Bulgaria | DG | George's Day Movement | Dvizhenie Gergyovden | Dvizhenie Gergyovden | right | Right-wing | 6.3158 | 6.1053 | 2.8289 | 8.3158 | 920 | 10 | 1362 | 40 | |||||||
BGR | Bulgaria | DOST | Democrats for Responsibility, Solidarity and Tolerance | Demokrati za Otgovornost, Svoboda i Tolerantnost | Demokrati za Otgovornost, Svoboda i Tolerantnost | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2639 | 6 | ||||||||
BGR | Bulgaria | DP | Democratic Party | Demokraticheska Partiya | Demokraticheska Partiya | chr | Christian democracy | 9.4444 | 5.7 | 7.1 | 8.3 | 709 | 10 | 542 | 3 | |||||||
BGR | Bulgaria | DaB | Yes, Bulgaria! | Da Bulgaria! | Da Bulgaria! | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2638 | 6 | ||||||||
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 | I-MK | Independent -- Mincho Kuminev | Independent – Mincho Kuminev | Independent -- Mincho Kuminev | none | no family | 10 | 2774 | 12 | ||||||||||||
BGR | Bulgaria | IS | Stand up! | Izpravi se! | Izpravi se! | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2838 | 11 | ||||||||
BGR | Bulgaria | ITN | There Is Such a People | Ima takav narod | Ima takav narod | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2836 | 26 | ||||||||
BGR | Bulgaria | KPB | Communist Party of Bulgaria | Komunisticheska Partiya na Balgariya | Komunisticheska Partiya na Balgariya | com | Communist/Socialist | 0.3684 | 1.7368 | 7.8289 | 2.8655 | 701 | 763 | 10 | 1570 | 14 | ||||||
BGR | Bulgaria | KR | Coalition of the Rose | Koalitsiya na Rozata | Koalitsiya na Rozata | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2179 | 11 | ||||||||
BGR | Bulgaria | NFSB | National Front for the Salvation of Bulgaria | Natsionalen Front za Spasenie na Balgariya | Natsionalen Front za Spasenie na Balgariya | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 2211 | 40 | ||||||||
BGR | Bulgaria | NV | New Times | Novoto vreme | Novoto vreme | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 10 | 2180 | 19 | ||||||||
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 | PBSD | Party of Bulgarian Social Democrats | Partiya Balgarski Sotsialdemokrati | Partiya Balgarski Sotsialdemokrati | soc | Social democracy | 3.7778 | 4.6316 | 3.4211 | 9.0 | 703 | 815 | 10 | 1161 | 11 | ||||||
BGR | Bulgaria | PKE | Political Club "Ecoglasnost" | Politicheski Klub "Ekoglasnost" | Politicheski Klub "Ekoglasnost" | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 80110 | 10 | 1548 | 19 | |||||||
BGR | Bulgaria | PP | We Continue the Change | Prodalzhavame promyanata | Prodalzhavame promyanata | spec | Special issue | 10 | 2847 | 16 | ||||||||||||
BGR | Bulgaria | PS | Patriotic Union | Patriotichen Suyuz | Patriotichen Suyuz | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2177 | 26 | ||||||||
BGR | Bulgaria | R | Revival | Vazrazhdane | Vazrazhdane | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 2640 | 40 | ||||||||
BGR | Bulgaria | RB | Reformist Bloc | Reformatorski Blok | Reformatorski Blok | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2363 | 26 | ||||||||
BGR | Bulgaria | RzB | Republicans for Bulgaria | Republikantsi za Balgariya | Republikantsi za Balgariya | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2814 | 26 | ||||||||
BGR | Bulgaria | SDS | Union of Democratic Forces | Suyuz na Demokratichnite Sili | Suyuz na Demokratichnite Sili | chr | Christian democracy | 6.1111 | 5.7 | 7.1 | 8.3 | 80410 | 33 | 707 | 10 | 423 | 3 | |||||
BGR | Bulgaria | SDS-l | Union of Democratic Forces -- Liberal | Suyuz na Demokratichnite Sili – Liberali | Suyuz na Demokratichnite Sili -- Liberali | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2175 | 6 | ||||||||
BGR | Bulgaria | SDS-ts | Union of Democratic Forces -- Centre | Suyuz na Demokratichnite Sili – Tsentur | Suyuz na Demokratichnite Sili -- Tsentur | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2174 | 11 | ||||||||
BGR | Bulgaria | SEK | Middle European Class | Sredna evropeĭska klasa | Sredna evropeiska klasa | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2870 | 6 | ||||||||
BGR | Bulgaria | SK | Blue Coalition | Sinyata Koalitsiya | Sinyata Koalitsiya | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 1100001 | 10 | 1254 | 26 | |||||||
BGR | Bulgaria | SNI | "New Choice" Union | Suyuz "Nov izbor" | Suyuz "Nov izbor" | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2176 | 6 | ||||||||
BGR | Bulgaria | VB | Volt Bulgaria | Volt Bulgaria | Volt Bulgaria | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2869 | 6 | ||||||||
BGR | Bulgaria | VMRO | IMRO -- Bulgarian National Movement | VMRO – Balgarsko Natsionalno Dvizhenie | VMRO -- Balgarsko Natsionalno Dvizhenie | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2212 | 26 | ||||||||
BGR | Bulgaria | Volya | Will | Volya | Volya | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 2637 | 40 | ||||||||
BGR | Bulgaria | ZNS | Agrarian People's Union | Zemedelski Naroden Suyuz | Zemedelski Naroden Suyuz | agr | Agrarian | 5.5263 | 5.7895 | 5.9398 | 8.9474 | 80810 | 704 | 867 | 10 | 353 | 2 | |||||
BGR | Bulgaria | ZP | Green Party of Bulgaria | Zelena Partiya | Zelena Partija | eco | Green/Ecologist | 5.5556 | 2.5 | 1.8 | 6.5 | 705 | 10 | 963 | 19 | |||||||
BGR | Bulgaria | ZS-AS | Agrarian Union "Aleksandar Stamboliyski" | Zemedelski Suyuz "Aleksandar Stamboliyski" | Zemedelski Suyuz "Aleksandar Stamboliyski" | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 80812 | 10 | 529 | 2 | |||||||
BGR | Bulgaria | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 10 | 133 | 12 | ||||||||||||
CAN | Canada | BPC | Bloc Populaire Canadien | Bloc Populaire Canadien | Bloc Populaire Canadien | spec | Special issue | 29 | 1307 | 16 | ||||||||||||
CAN | Canada | BQ | Quebec Bloc | Bloc Québécois | Bloc Quebecois | soc | Social democracy | 3.0215 | 3.1207 | 2.2063 | 62901 | 802 | 5213 | 29 | 448 | 11 | ||||||
CAN | Canada | CCF|NDP | Co-operative Commonwealth Federation | New Democratic Party | Co-operative Commonwealth Federation | New Democratic Party | Co-operative Commonwealth Federation | New Democratic Party | soc | Social democracy | 2.46 | 1.9195 | 1.1134 | 62320 | 401 | 801 | 5293 | 29 | 296 | 11 | |||||
CAN | Canada | CPC | Conservative Party of Canada | Conservative Party of Canada | Conservative Party of Canada | con | Conservative | 8.6608 | 8.7668 | 9.0688 | 5233 | 29 | 1255 | 26 | ||||||||
CAN | Canada | CP|LPP | Communist (Labour-Progressive) Party | Communist (Labour-Progressive) Party | Communist (Labour-Progressive) Party | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 29 | 556 | 14 | |||||||||
CAN | Canada | GPC | Green Party of Canada | Green Party of Canada | Green Party of Canada | eco | Green/Ecologist | 1.9018 | 2.2467 | 2.0327 | 5253 | 29 | 1259 | 19 | ||||||||
CAN | Canada | L | Labour Party | Labour Party | Labour Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 29 | 2427 | 11 | |||||||||
CAN | Canada | L-P | Liberal-Progressive | Liberal-Progressive | Liberal-Progressive | lib | Liberal | 6.0 | 6.7 | 3.6 | 29 | 2011 | 6 | |||||||||
CAN | Canada | LL | Liberal-Labour | Liberal-Labour | Liberal-Labour | lib | Liberal | 6.0 | 6.7 | 3.6 | 29 | 2085 | 6 | |||||||||
CAN | Canada | LP | Liberal Party of Canada | Liberal Party of Canada | Liberal Party of Canada | lib | Liberal | 5.0552 | 5.3509 | 3.4615 | 62420 | 402 | 803 | 5273 | 29 | 368 | 6 | |||||
CAN | Canada | NPC | National Party of Canada | National Party of Canada | National Party of Canada | soc | Social democracy | 3.3 | 3.5 | 3.5 | 29 | 2142 | 11 | |||||||||
CAN | Canada | PCP | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | con | Conservative | 6.7112 | 6.9659 | 5.997 | 62620 | 403 | 804 | 5313 | 29 | 794 | 26 | |||||
CAN | Canada | PPC | People's Party of Canada | People's Party of Canada | People's Party of Canada | right | Right-wing | 8.8 | 5.9 | 8.5 | 29 | 2791 | 40 | |||||||||
CAN | Canada | PPC-19 | Progressive Party of Canada (1919) | Progressive Party of Canada (1919) | Progressive Party of Canada (1919) | agr | Agrarian | 5.3 | 4.9 | 6.5 | 29 | 2566 | 2 | |||||||||
CAN | Canada | PR | Rhinoceros Party | Parti Rhinoceros | Parti Rhinoceros | spec | Special issue | 29 | 2148 | 16 | ||||||||||||
CAN | Canada | RP | Reconstruction Party of Canada | Reconstruction Party of Canada | Reconstruction Party of Canada | con | Conservative | 7.4 | 6.4 | 6.9 | 29 | 2565 | 26 | |||||||||
CAN | Canada | RPC | Reform Party of Canada | Reform Party of Canada | Reform Party of Canada | con | Conservative | 8.7748 | 8.7668 | 9.0688 | 62621 | 805 | 5233 | 29 | 897 | 26 | ||||||
CAN | Canada | SCR | Social Credit Rally | Ralliement créditiste | Ralliement creditiste | spec | Special issue | 29 | 677 | 16 | ||||||||||||
CAN | Canada | SSC | Social Credit Party of Canada | Social Credit Party of Canada | Social Credit Party of Canada | con | Conservative | 7.8 | 6.4 | 6.9 | 62951 | 404 | 29 | 1392 | 26 | |||||||
CAN | Canada | UE | Union of Electors | Union [Candidats] des électeurs | Union [Candidats] des electeurs | spec | Special issue | 29 | 2162 | 16 | ||||||||||||
CAN | Canada | etc | others | others | others | none | no family | 29 | 2577 | 12 | ||||||||||||
CAN | Canada | no-seat | no seat | no seat | no seat | none | no family | 29 | 2067 | 12 | ||||||||||||
CAN | Canada | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 29 | 1189 | 12 | ||||||||||||
CHE | Switzerland | BHB | Young Peasants Movement | Bauernheimatbewegung – Jeunes paysans | Bauernheimatbewegung -- Jeunes paysans | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 40 | 1957 | 19 | ||||||||
CHE | Switzerland | DG | Democratic Group | Gruppe der Demokraten – Groupe des democrates | Gruppe der Demokraten -- Groupe des democrates | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 40 | 886 | 11 | ||||||||
CHE | Switzerland | EJ | Agreement Jura | Entente jurassienne | Entente jurassienne | code | to be coded | 40 | 1964 | 28 | ||||||||||||
CHE | Switzerland | FDP-PRD | Radical Democratic Party | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Freisinnig-Demokratische Partei der Schweiz -- Parti Radical-Democratique Suisse | lib | Liberal | 6.3249 | 8.0105 | 3.4159 | 6.4439 | 43420 | 289 | 3803 | 1703 | 8028 | 40 | 26 | 6 | |||
CHE | Switzerland | FGr-ASF | Feminists and Green-Alternative Groups | Feministische und grün-alternative Gruppierungen – Alternative socialiste verte et groupements féministes | Feministische und gruen-alternative Gruppierungen -- Alternative socialiste verte et groupements feministes | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 2.5 | 1712 | 40 | 569 | 19 | |||||||
CHE | Switzerland | FPS | Automobile Party | Freedom Party of Switzerland | Auto-Partei | Freiheitspartei der Schweiz | Auto-Partei | Freiheitspartei der Schweiz | right | Right-wing | 8.0556 | 5.9 | 8.5 | 0.0 | 43951 | 3806 | 1713 | 40 | 1602 | 40 | |||||
CHE | Switzerland | GV | Grutli Society | Grütliverein – Grutléen | Gruetli Society -- Grutleen | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 40 | 1951 | 11 | ||||||||
CHE | Switzerland | KHM | Committee Herbert Maeder | Komitee Herbert Maeder | Komitee Herbert Maeder | none | no family | 40 | 1967 | 12 | ||||||||||||
CHE | Switzerland | LF/PEB | Liberal Socialist Party | Liberalsozialistische Partei / Freiwirtschaftliche Bewegung – Parti d'économie franche | Liberalsozialistische Partei / Freiwirtschaftliche Bewegung -- Parti d economie franche | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 40 | 1960 | 6 | ||||||||
CHE | Switzerland | LPS | Liberal Party of Switzerland | Liberale Partei der Schweiz – Parti liberal suisse | Liberale Partei der Schweiz -- Parti liberal suisse | lib | Liberal | 7.2961 | 8.477 | 4.2441 | 7.6667 | 43531 | 3805 | 1702 | 8060 | 40 | 458 | 6 | ||||
CHE | Switzerland | LdU-ADI | Independents Alliance | Landesring der Unabhängigen – Alliance des Indépendants | Landesring der Unabhaengigen -- Alliance des Independants | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 43321 | 40 | 1264 | 11 | |||||||
CHE | Switzerland | MCR | Geneva Citizens' Movement | Mouvement Citoyens Genevois | Mouvement Citoyens Genevois | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 40 | 2599 | 40 | ||||||||
CHE | Switzerland | NA|SD | National Action -- Swiss Democrats | Nationale Aktion – Action Nationale | Schweizer Demokraten – Démocrates Suisses | Nationale Aktion -- Action Nationale | Schweizer Demokraten -- Democrates Suisses | right | Right-wing | 9.4247 | 6.2573 | 9.0409 | 0.2384 | 43710 | 1709 | 8092 | 40 | 628 | 40 | |||||
CHE | Switzerland | POCH | Progressive Organisations of Switzerland | Progressive Organisationen der Schweiz – Organisations progressistes de Suisse | Progressive Organisationen der Schweiz -- Organisations progressistes de Suisse | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 40 | 964 | 14 | ||||||||
CHE | Switzerland | PSA | Autonomous Socialist Party | Partito socialista autonomo | Partito socialista autonomo | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 5.0 | 1710 | 40 | 224 | 14 | |||||||
CHE | Switzerland | RB | Republican Movement | Republikanische Bewegung | Republikanische Bewegung | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 40 | 564 | 40 | ||||||||
CHE | Switzerland | S | Solidarity | solidaritéS | solidariteS | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 40 | 1226 | 14 | ||||||||
CHE | Switzerland | UDE | National Union | Union de défense économique | Union de defense economique | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 40 | 1954 | 40 |
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;