view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
263 rows where family_name = "Conservative"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
FRA | France | agir | Act, the constructive right | Agir, la droite constructive | Agir, la droite constructive | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 2862 | 26 | ||||||||
FRA | France | d-droite | other right | divers droite | divers droite | con | Conservative | 7.6583 | 9.0 | 9.0 | 5.8333 | 618 | 43 | 285 | 26 | |||||||
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 | 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 | 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 | Na | National | National | National | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 44 | 2518 | 26 | ||||||||
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 | ||||||
GRC | Greece | DIANA | Democratic Renewal | Dimokratiki Ananeosi | Dimokratiki Ananeosi | con | Conservative | 7.4 | 6.4 | 6.9 | 10.0 | 149 | 405 | 41 | 1374 | 26 | ||||||
GRC | Greece | DX | Recreate Greece | Dimiourgia Xana | Dimiourgia Xana | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41 | 2095 | 26 | ||||||||
GRC | Greece | E-OAD | Greece, the Other Way | Ellada – O Allos Dromos | Ellada -- O Allos Dromos | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41 | 2744 | 26 | ||||||||
GRC | Greece | EL | Greek Solution | Elliniki Lisi | Elliniki Lisi | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41 | 2780 | 26 | ||||||||
GRC | Greece | EP | National Alignment | Ethniki Parataxis | Ethniki Parataxis | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 34610 | 41 | 1027 | 26 | |||||||
GRC | Greece | EPL | Union for the Homeland and the People | Enosi Gia Tin Patrida Kai Ton Lao | Enosi Gia Tin Patrida Kai Ton Lao | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41 | 2348 | 26 | ||||||||
GRC | Greece | KEK | Party of Greek Hunters | Kómma Ellênòn Kynègôn | Komma Ellenon Kynegon | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41 | 2167 | 26 | ||||||||
GRC | Greece | KP | Progressive Party | Komma Proodeftikon | Komma Proodeftikon | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41 | 2123 | 26 | ||||||||
GRC | Greece | POLAN | Political Spring | Politiki Anixi | Politiki Anixi | con | Conservative | 7.5714 | 6.7143 | 7.0 | 7.9488 | 34512 | 408 | 408 | 41 | 1412 | 26 | |||||
HRV | Croatia | HPS | Croatian People's Party | Hrvatska pucka stranka | Hrvatska pucka stranka | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 62 | 2203 | 26 | ||||||||
HRV | Croatia | Most | Bridge of Independent Lists | Most nezavisnih lista | Most nezavisnih lista | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 62 | 2615 | 26 | ||||||||
HRV | Croatia | NHR | Independents for Croatia | Neovisni za Hrvatsku | Neovisni za Hrvatsku | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 62 | 2770 | 26 | ||||||||
HRV | Croatia | SDA | Party of Democratic Action of Croatia | Stranka demokratske akcije Hrvatske | Stranka demokratske akcije Hrvatske | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 62 | 2270 | 26 | ||||||||
HUN | Hungary | FKgP | Independent Small Holders Party | Független Kisgazda Párt | Fuggetlen Kisgazda Part | con | Conservative | 9.0186 | 4.7149 | 8.6235 | 3.7053 | 86810 | 1606 | 1898 | 39 | 870 | 26 | |||||
HUN | Hungary | Fi+KDNP | Fidesz -- Hungarian Civic Party / Christian Democratic People's Party | Fidesz – Magyar Polgári Szövetség / Kereszténydemokrata Néppárt | Fidesz -- Magyar Polgari Szovetseg / Keresztenydemokrata Neppart | con | Conservative | 6.5432 | 3.9949 | 7.5275 | 6.6143 | 86421 | 157 | 1348421 | 1603 | 1872 | 2302 | 39 | 437 | 26 | ||
HUN | Hungary | Fi-MPSz | Fidesz -- Hungarian Civic Union | Fidesz – Magyar Polgári Szövetség | Fidesz -- Magyar Polgari Szovetseg | con | Conservative | 6.5432 | 3.9949 | 7.5275 | 6.6143 | 86421 | 157 | 1348421 | 1603 | 1872 | 2302 | 39 | 921 | 26 | ||
HUN | Hungary | MDF | Hungarian Democratic Forum | Magyar Demokrata Fórum | Magyar Demokrata Forum | con | Conservative | 6.4826 | 5.0761 | 6.8263 | 8.4922 | 86521 | 159 | 1348521 | 1605 | 1924 | 2303 | 39 | 546 | 26 | ||
HUN | Hungary | MM | Momentum Movement | Momentum Mozgalom | Momentum Mozgalom | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 39 | 2659 | 26 | ||||||||
IRL | Ireland | A | Aontu | Aontú | Aontu | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2795 | 26 | ||||||||
IRL | Ireland | CG | Society of the Gaels | Cumann na nGaedheal | Cumann na nGaedheal | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2447 | 26 | ||||||||
IRL | Ireland | CPA | Cork Progressive Association | Cork Progressive Association | Cork Progressive Association | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2525 | 26 | ||||||||
IRL | Ireland | CnP | Republican Party | Clann na Poblachta | Clann na Poblachta | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 53714 | 37 | 92 | 26 | |||||||
IRL | Ireland | FF | Fianna Fail | Fianna Fáil | Fianna Fail | con | Conservative | 6.0713 | 5.8991 | 6.9898 | 7.8389 | 53620 | 167 | 1372620 | 903 | 1903 | 701 | 6287 | 701 | 37 | 280 | 26 |
IRL | Ireland | IFF | Independent Fianna Fail | Independent Fianna Fáil | Independent Fianna Fail | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2326 | 26 | ||||||||
IRL | Ireland | Lib | Libertas Ireland | Libertas Ireland | Libertas Ireland | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 171 | 1372001 | 37 | 1199 | 26 | ||||||
IRL | Ireland | NCP | National Centre Party | National Centre Party | National Centre Party | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2442 | 26 | ||||||||
IRL | Ireland | NLP | National League Party | National League Party | National League Party | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2443 | 26 | ||||||||
IRL | Ireland | NP | National Party | National Party | National Party | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2218 | 26 | ||||||||
IRL | Ireland | RI | Renua Ireland | Renua Ireland | Renua Ireland | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2620 | 26 | ||||||||
ISL | Iceland | Bf-87 | Citizens' Party -- 1987 | Borgaraflokkurinn – 1987 | Borgaraflokkurinn -- 1987 | con | Conservative | 7.4 | 6.4 | 6.9 | 15621 | 56 | 828 | 26 | ||||||||
ISL | Iceland | Lve | Republican Party | Lýðveldisflokkurinn | Lydveldisflokkurinn | con | Conservative | 7.4 | 6.4 | 6.9 | 56 | 2005 | 26 | |||||||||
ISL | Iceland | Sj | Independence Party | Sjálfstæðisflokkurinn | Sjalfstaedisflokkurinn | con | Conservative | 7.4854 | 7.6316 | 4.0351 | 15620 | 1705 | 6217 | 56 | 1342 | 26 | ||||||
ISL | Iceland | Sj-07 | Independence Party -- 1907 | Sjálfstæðisflokkurinn – 1907 | Sjalfstaedisflokkurinn -- 1907 | con | Conservative | 7.4 | 6.4 | 6.9 | 56 | 2561 | 26 | |||||||||
ISL | Iceland | Thve | Common Wealth Party | Þjóðveldisflokkurinn | Tjodveldisflokkurin | con | Conservative | 7.4 | 6.4 | 6.9 | 56 | 2004 | 26 | |||||||||
ISL | Iceland | V | Revival | Viðreisn | Vioreisn | con | Conservative | 7.4 | 6.4 | 6.9 | 56 | 2633 | 26 | |||||||||
ISR | Israel | DeTo | Banner of the Torah | Degel HaTorah | Degel HaTorah | con | Conservative | 7.4 | 6.4 | 6.9 | 72614 | 34 | 249 | 26 | ||||||||
ISR | Israel | G-96 | Bridge -- 1996 | Gesher – 1996 | Gesher -- 1996 | con | Conservative | 7.4 | 6.4 | 6.9 | 34 | 1862 | 26 | |||||||||
ISR | Israel | Herut | Freedom Party | Herut | Herut | con | Conservative | 7.4 | 6.4 | 6.9 | 72620 | 34 | 1204 | 26 | ||||||||
ISR | Israel | L | The Consolidation | Likud | Likud | con | Conservative | 6.6788 | 7.4912 | 6.0 | 72622 | 6488 | 34 | 678 | 26 | |||||||
ISR | Israel | M | Homeland | Moledet | Moledet | con | Conservative | 7.4 | 6.4 | 6.9 | 72615 | 34 | 980 | 26 | ||||||||
ISR | Israel | RM | National List | Reshima Mamlakhtit | Reshima Mamlakhtit | con | Conservative | 7.4 | 6.4 | 6.9 | 34 | 1841 | 26 | |||||||||
ISR | Israel | SVM | Sephardim and Oriental Communities | Sfaradim VeEdot Mizrah | Sfaradim VeEdot Mizrah | con | Conservative | 7.4 | 6.4 | 6.9 | 34 | 1831 | 26 | |||||||||
ISR | Israel | Sh | Peace-Zion | Shlomtzion | Shlomtzion | con | Conservative | 7.4 | 6.4 | 6.9 | 72623 | 34 | 106 | 26 | ||||||||
ISR | Israel | Tami | Movement for the Heritage of Israel | Tnu'at Masoret Yisrael | Tnu'at Masoret Yisrael | con | Conservative | 7.4 | 6.4 | 6.9 | 72532 | 34 | 588 | 26 | ||||||||
ISR | Israel | Tehiya | Revival | Tehiya | Tehiya | con | Conservative | 7.4 | 6.4 | 6.9 | 72612 | 34 | 1660 | 26 | ||||||||
ISR | Israel | Tnufa | Momentum | Tnufa | Tnufa | con | Conservative | 7.4 | 6.4 | 6.9 | 34 | 2360 | 26 | |||||||||
ISR | Israel | YaToMe | United Torah Judaism | Yahadut HaTora HaMeuhedet | Yahadut HaTora HaMeuhedet | con | Conservative | 6.9396 | 2.8146 | 9.7556 | 72535 | 6589 | 34 | 1303 | 26 | |||||||
ITA | Italy | AN | National Alliance | Alleanza Nazionale | Alleanza Nazionale | con | Conservative | 8.0871 | 4.9559 | 8.8366 | 4.3389 | 32710 | 805 | 6606 | 805 | 26 | 373 | 26 | ||||
ITA | Italy | CeD | Centre Right | Centro-destra | Centro-destra | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 32629 | 26 | 67 | 26 | |||||||
ITA | Italy | FI-PdL | Go Italy -- The People of Freedom | Forza Italia – Il Popolo della Libertà | Forza Italia -- Il Popolo della Liberta | con | Conservative | 7.1459 | 7.913 | 6.5983 | 5.0946 | 32610 | 186 | 1380630 | 816 | 6646 | 815 | 26 | 596 | 26 | ||
ITA | Italy | FLI | Future and Freedom for Italy | Futuro e libertà per l'Italia | Futuro e liberta per l'Italia | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 26 | 1477 | 26 | ||||||||
ITA | Italy | FUQ | Front of the Ordinary Man | Fronte dell'Uomo Qualunque | Fronte dell'Uomo Qualunque | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 26 | 409 | 26 | ||||||||
ITA | Italy | Italexit | Italexit for Italy | Italext per l'Italia | Italexit per l'Italia | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 26 | 2873 | 26 | ||||||||
ITA | Italy | NCD | New Centre-Right | Popular Alternative | Nuovo Centrodestra | Alternativa Popolare | Nuovo Centrodestra | Alternativa Popolare | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 26 | 2268 | 26 | ||||||||
ITA | Italy | PDIUM | Italian Democratic Party of Monarchist Unity | Partito Democratico Italiano di Unità Monarchica | Partito Democratico Italiano di Unita Monarchica | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 26 | 1702 | 26 | ||||||||
ITA | Italy | PMP | Popular Monarchist Party | Partito Monarchico Popolare | Partito Monarchico Popolare | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 26 | 421 | 26 | ||||||||
ITA | Italy | USEI | South American Union Italian Emigrants | Unione Sudamericana Emigrati Italiani | Unione Sudamericana Emigrati Italiani | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 26 | 2671 | 26 | ||||||||
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 | 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 | 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 | 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 | 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 | NCP | New Conservative Party | Hoshu Shintō | Hoshu Shinto | con | Conservative | 8.2675 | 5.6522 | 8.032 | 71626 | 8448 | 5 | 1382 | 26 | |||||||
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 | NLC | New Liberal Club | Shin-jiyū-kurabu | Shin jiyu karuba | con | Conservative | 7.4 | 6.4 | 6.9 | 71621 | 5 | 170 | 26 | ||||||||
JPN | Japan | NPS | New Party Sakigake | Shinto Sakigake | Shinto Sakigake | con | Conservative | 7.4 | 6.4 | 6.9 | 71951 | 5 | 1146 | 26 | ||||||||
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 | |||||||||
LTU | Lithuania | LiCS-TPP | United Faction of the Liberal and Centre Union and Nations Resurrection Party | Liberaly ir centro sąjunga ir Tautos prisikelimo partija | Liberaly ir centro sajunga ir Tautos prisikelimo partija | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 15 | 2007 | 26 | ||||||||
LTU | Lithuania | TS-LK | Homeland Union | Tėvynės sąjunga | Tevynes sajunga | con | Conservative | 7.4004 | 6.694 | 7.1939 | 9.7006 | 88620 | 209 | 1440620 | 2406 | 2404 | 2506 | 15 | 1045 | 26 | ||
LTU | Lithuania | TT-LDP | Order and Justice -- Liberal Democratic Party | Tvarka ir teisingumas – Liberalų demokratų partija | Tvarka ir teisingumas -- Liberalu demokratu partija | con | Conservative | 5.2955 | 4.9093 | 7.2116 | 7.3184 | 207 | 1440621 | 2236 | 2515 | 15 | 1421 | 26 | ||||
LUX | Luxembourg | AR|ADR | Action Committee Pensions | Alternative Democratic Reform Party | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | con | Conservative | 8.8158 | 6.3158 | 7.5 | 23951 | 214 | 1442951 | 907 | 6866 | 7 | 1582 | 26 | ||||
LUX | Luxembourg | PD | Party of the Right | Rietspartei | Rietspartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7 | 2527 | 26 | |||||||||
LUX | Luxembourg | PID | Party for Full Democracy | Partei fir Integral Demokratie | Partei fir Integral Demokratie | con | Conservative | 7.4 | 6.4 | 6.9 | 7 | 2257 | 26 | |||||||||
LVA | Latvia | JD | New Democrats | Jaunie Demokrāti | Jaunie Demokrati | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 55 | 1294 | 26 | ||||||||
LVA | Latvia | JKP | New Conservative Party | Jaunā konservatīvā partija | Jauna konservativa partija | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 55 | 2717 | 26 | ||||||||
LVA | Latvia | JL | New Era | Jaunais Laiks | Jaunais laiks | con | Conservative | 7.3026 | 7.0789 | 5.6407 | 8.7865 | 87423 | 353 | 1428423 | 2054 | 2401 | 55 | 1518 | 26 | |||
LVA | Latvia | JP | New Era Party | Jaunā partija | Jauna partija | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 87431 | 55 | 550 | 26 | |||||||
LVA | Latvia | K | Conservative Party | Konservatīvā partija | Konservativa partija | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 55 | 1351 | 26 | ||||||||
LVA | Latvia | LPP | Latvia's First Party | Latvijas Pirmā partija | Latvijas Pirma partija | con | Conservative | 6.3377 | 6.8461 | 8.4916 | 8.1287 | 87521 | 2080 | 2404 | 55 | 1043 | 26 | |||||
LVA | Latvia | LPP/LC | Latvian First Party / Latvian Way Party | Latvijas Pirmā partija / Latvijas Ceļš | Latvijas Pirma partija / Latvijas Cels | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 191 | 1428424 | 55 | 662 | 26 | ||||||
LVA | Latvia | LRa | Latvian Association of Regions | Latvijas Reģionu apvienība | Latvijas Regionu apvieniba | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 55 | 2366 | 26 |
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;