view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by country_name descending
This data as json, CSV (advanced)
Suggested facets: family_name_short, family_name
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GBR | United Kingdom | APoNI | Alliance Party of Northern Ireland | Alliance Party of Northern Ireland | Alliance Party of Northern Ireland | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 44 | 2731 | 6 | ||||||||
GBR | United Kingdom | BNP | British National Party | British National Party | British National Party | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 417 | 1826720 | 1109 | 44 | 1250 | 40 | |||||
GBR | United Kingdom | BP | Brexit Party | Brexit Party | Brexit Party | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 44 | 2729 | 40 | ||||||||
GBR | United Kingdom | C | Constitutionalist | Constitutionalist | Constitutionalist | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 44 | 2514 | 26 | ||||||||
GBR | United Kingdom | CNL | Conservatives and National Liberals | Conservatives and National Liberals | Conservatives and National Liberals | con | Conservative | 7.8 | 6.4 | 6.9 | 7.9 | 51620 | 1606 | 44 | 1496 | 26 | ||||||
GBR | United Kingdom | CP | The Christian Party -- Christian Peoples Alliance in England | The Christian Party – Christian Peoples Alliance in England | The Christian Party -- Christian Peoples Alliance in England | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 44 | 2063 | 3 | ||||||||
GBR | United Kingdom | CPGB | Communist Party of Great Britain | Communist Party of Great Britain | Communist Party of Great Britain | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 44 | 1276 | 14 | ||||||||
GBR | United Kingdom | CUK | Change UK | Change UK | Change UK | spec | Special issue | 44 | 2730 | 16 | ||||||||||||
GBR | United Kingdom | CoLab | Coalition Labour | Coalition Labour | Coalition Labour | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 44 | 2508 | 11 | ||||||||
GBR | United Kingdom | CoLib | Coalition Liberal | Coalition Liberal | Coalition Liberal | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 44 | 2501 | 6 | ||||||||
GBR | United Kingdom | Con | Conservatives | Conservatives | Conservatives | con | Conservative | 7.4261 | 7.5725 | 7.1901 | 2.3243 | 51620 | 418 | 1826620 | 1606 | 603 | 1101 | 5103 | 1101 | 44 | 773 | 26 |
GBR | United Kingdom | Con-18 | Conservatives | Conservatives [no coupon] | Conservatives | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 44 | 2719 | 26 | ||||||||
GBR | United Kingdom | DUP | Democratic Unionist Party | Democratic Unionist Party | Democratic Unionist Party | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 51903 | 44 | 319 | 26 | |||||||
GBR | United Kingdom | ED | English Democrats | English Democrats | English Democrats | spec | Special issue | 44 | 2062 | 16 | ||||||||||||
GBR | United Kingdom | EuCon | Pro-Euro Conservative Party | Pro-Euro Conservative Party | Pro-Euro Conservative Party | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 44 | 2061 | 26 | ||||||||
GBR | United Kingdom | GP | Green Party | Green Party | Green Party | eco | Green/Ecologist | 2.57 | 2.3775 | 2.0139 | 4.9858 | 420 | 1826110 | 1107 | 1107 | 44 | 467 | 19 | ||||
GBR | United Kingdom | IE | An Independence from Europe | An Independence from Europe | An Independence from Europe | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 44 | 2387 | 40 | ||||||||
GBR | United Kingdom | IL | Independent Liberal | Independent Liberal | Independent Liberal | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 44 | 2517 | 6 | ||||||||
GBR | United Kingdom | ILP | Independent Labour Party | Independent Labour Party | Independent Labour Party | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 44 | 1205 | 14 | ||||||||
GBR | United Kingdom | Lab | Labour | Labour Party | Labour Party | soc | Social democracy | 4.3562 | 4.5741 | 4.2779 | 6.9923 | 51320 | 421 | 1826320 | 1601 | 601 | 1102 | 5147 | 1102 | 44 | 1556 | 11 |
GBR | United Kingdom | Lib | Liberals | Liberals | Liberals | lib | Liberal | 4.2875 | 4.1064 | 2.6109 | 9.2231 | 51420 | 1605 | 1104 | 1104 | 44 | 659 | 6 | ||||
GBR | United Kingdom | N | Nationalist Party | Nationalist Party | Nationalist Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 44 | 332 | 11 | ||||||||
GBR | United Kingdom | NDP | National Democratic and Labour Party | National Democratic and Labour Party | National Democratic and Labour Party | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 44 | 2503 | 40 | ||||||||
GBR | United Kingdom | NF | National Front | National Front | National Front | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 44 | 1126 | 40 | ||||||||
GBR | United Kingdom | NLO | National Labour Organisation | National Labour Organisation | National Labour Organisation | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 44 | 2479 | 11 | ||||||||
GBR | United Kingdom | NLP | National Liberal Party | National Liberal Party | National Liberal Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 44 | 1017 | 6 | ||||||||
GBR | United Kingdom | NO2EU | NO2EU -- Yes to Democracy | NO2EU – Yes to Democracy | NO2EU -- Yes to Democracy | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 44 | 2147 | 14 | ||||||||
GBR | United Kingdom | NP | National Party | National Party | National Party | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 44 | 2504 | 40 | ||||||||
GBR | United Kingdom | Na | National | National | National | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 44 | 2518 | 26 | ||||||||
GBR | United Kingdom | Plaid | Plaid Cymru | Plaid Cymru | Plaid Cymru | spec | Special issue | 3.1183 | 2.6251 | 3.7107 | 7.8314 | 1826901 | 1602 | 1106 | 5169 | 1106 | 44 | 311 | 16 | |||
GBR | United Kingdom | R | Respect -- The Unity Coalition | Respect – The Unity Coalition | Respect -- The Unity Coalition | code | to be coded | 44 | 1057 | 28 | ||||||||||||
GBR | United Kingdom | RP | Referendum Party | Referendum Party | Referendum Party | spec | Special issue | 44 | 2103 | 16 | ||||||||||||
GBR | United Kingdom | RepLP | Republican Labour Party | Republican Labour Party | Republican Labour Party | code | to be coded | 44 | 1092 | 28 | ||||||||||||
GBR | United Kingdom | SDLP | Social Democratic and Labour Party | Social Democratic and Labour Party | Social Democratic and Labour Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.6667 | 1103 | 44 | 1023 | 11 | |||||||
GBR | United Kingdom | SDP | Social Democratic Party | Social Democratic Party | Social Democratic Party | soc | Social democracy | 4.6 | 3.5 | 3.5 | 8.1 | 51330 | 1604 | 44 | 1547 | 11 | ||||||
GBR | United Kingdom | SF | Sinn Fein | Sinn Féin | Sinn Fein | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 51210 | 44 | 689 | 14 | |||||||
GBR | United Kingdom | SLP | Socialist Labour Party | Socialist Labour Party | Socialist Labour Party | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 44 | 2064 | 14 | ||||||||
GBR | United Kingdom | SNP | Scottish National Party | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba | Scottish National Party -- Partaidh Naiseanta na h-Alba | soc | Social democracy | 3.5871 | 3.0627 | 3.9623 | 7.8641 | 51902 | 1826902 | 1603 | 1105 | 5191 | 1105 | 44 | 1284 | 11 | ||
GBR | United Kingdom | U | Unity | Unity | Unity | spec | Special issue | 44 | 349 | 16 | ||||||||||||
GBR | United Kingdom | UKIP | United Kingdom Independence Party | United Kingdom Independence Party | United Kingdom Independence Party | right | Right-wing | 7.8429 | 8.0938 | 7.8507 | 0.0 | 51951 | 423 | 1826951 | 1108 | 1108 | 44 | 1272 | 40 | |||
GBR | United Kingdom | UPUP | Ulster Popular Unionist Party | Ulster Popular Unionist Party | Ulster Popular Unionist Party | code | to be coded | 44 | 1566 | 28 | ||||||||||||
GBR | United Kingdom | UUP | Ulster Unionist Party | Ulster Unionist Party | Ulster Unionist Party | con | Conservative | 8.3 | 6.4 | 6.9 | 7.9 | 51621 | 1607 | 44 | 1210 | 26 | ||||||
GBR | United Kingdom | UUUC | United Ulster Unionist Coalition | United Ulster Unionist Coalition | United Ulster Unionist Coalition | code | to be coded | 44 | 1363 | 28 | ||||||||||||
GBR | United Kingdom | VUPP | Vanguard Unionist Progressive Party | Vanguard Unionist Progressive Party | Vanguard Unionist Progressive Party | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 44 | 646 | 40 | ||||||||
GBR | United Kingdom | etc | others | others | others | none | no family | 44 | 453 | 12 | ||||||||||||
GBR | United Kingdom | no-seat | no seat | no seat | no seat | none | no family | 44 | 2562 | 12 | ||||||||||||
GBR | United Kingdom | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 44 | 1599 | 12 | ||||||||||||
GBR | United Kingdom | one-seat | one seat | one seat | one seat | none | no family | 44 | 2296 | 12 | ||||||||||||
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 | ||||||||||||
CHE | Switzerland | BDP | Conservative Democratic Party of Switzerland | Bürgerlich–Demokratische Partei (BDP) Graubünden | Buergerlich--Demokratische Partei (BDP) Graubuenden | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 3612 | 40 | 1213 | 26 | |||||||
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 | CsP-PCS | Christian Social Party | Christlich-soziale Partei – Parti chrétien-social | Christlich-soziale Partei -- Parti chretien-social | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 3611 | 40 | 1012 | 3 | |||||||
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 | EDU-UDF | Federal Democratic Union of Switzerland | Eidgenössisch-Demokratische Union – Union Démocratique Fédérale | Eidgenoessisch-Demokratische Union -- Union Democratique Federale | con | Conservative | 8.6579 | 6.3816 | 9.4247 | 0.9868 | 43711 | 7996 | 3608 | 40 | 1318 | 26 | |||||
CHE | Switzerland | EJ | Agreement Jura | Entente jurassienne | Entente jurassienne | code | to be coded | 40 | 1964 | 28 | ||||||||||||
CHE | Switzerland | EVP-PEP | Protestant Peoples Party | Evangelische Volkspartei der Schweiz – Parti Populaire Evangelique Suisse | Evangelische Volkspartei der Schweiz -- Parti Populaire Evangelique Suisse | chr | Christian democracy | 4.9248 | 4.4498 | 7.5812 | 5.0504 | 43530 | 394 | 1706 | 8012 | 3607 | 40 | 602 | 3 | |||
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 | GPL-PVL | Green Liberal Party | Grünliberale Partei der Schweiz – Parti Vert-Libéral | Gruenliberale Partei der Schweiz -- Parti Vert-Liberal | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 3606 | 40 | 308 | 19 | |||||||
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 | Grue | Greens | Grüne – Écologiste | Gruene -- Ecologiste | eco | Green/Ecologist | 1.6886 | 1.7263 | 1.0316 | 6.507 | 43110 | 290 | 1711 | 8044 | 3605 | 40 | 141 | 19 | |||
CHE | Switzerland | KHM | Committee Herbert Maeder | Komitee Herbert Maeder | Komitee Herbert Maeder | none | no family | 40 | 1967 | 12 | ||||||||||||
CHE | Switzerland | KK/CVP | Catholic Conservative / Christian Democratic Peoples Party | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien | Katholische Konservative / Christlichdemokratische Volkspartei -- Conservateurs catholiques / Parti democrate-chretien | chr | Christian democracy | 4.7288 | 5.6421 | 7.1414 | 6.3386 | 43520 | 288 | 3802 | 1701 | 7980 | 3604 | 40 | 531 | 3 | ||
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 | LdT | Ticino League | Lega dei Ticinesi | Lega dei Ticinesi | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 1714 | 3610 | 40 | 1500 | 40 | ||||||
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 | PdA | Swiss Party of Labour | Partei der Arbeit der Schweiz | Partei der Arbeit der Schweiz | com | Communist/Socialist | 0.5263 | 0.5835 | 1.6148 | 6.8893 | 43220 | 1707 | 8076 | 3609 | 40 | 1167 | 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 | SP-PS | Social Democratic Party of Switzerland | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Sozialdemokratische Partei der Schweiz -- Parti Socialiste Suisse | soc | Social democracy | 1.8319 | 1.7579 | 1.2281 | 9.0614 | 43320 | 291 | 3801 | 1704 | 8108 | 3602 | 40 | 35 | 11 | ||
CHE | Switzerland | SVP-UDC | Swiss People's Party | Schweizerische Volkspartei – Union Démocratique du Centre | Schweizerische Volkspartei -- Union Democratique du Centre | agr | Agrarian | 7.3575 | 8.9684 | 8.3385 | 0.6368 | 43810 | 292 | 3804 | 1705 | 8124 | 3601 | 40 | 750 | 2 | ||
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 | ||||||||
CHE | Switzerland | V | Vigilants | Vigilance | Vigilance | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 40 | 2775 | 40 | ||||||||
CHE | Switzerland | etc | others | others | others | none | no family | 40 | 2579 | 12 | ||||||||||||
CHE | Switzerland | none | no party affiliation | parteilos | parteilos | none | no family | 40 | 1211 | 12 | ||||||||||||
CHE | Switzerland | one-seat | one seat | one seat | one seat | none | no family | 40 | 2303 | 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 |
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;