view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
263 rows where family_name = "Conservative" sorted by party_name_ascii
This data as json, CSV (advanced)
Suggested facets: castles_mair, ray
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||
FRA | France | ARS | Republican and Social Action | Action républicaine et sociale | Action republicaine et sociale | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 2358 | 26 | ||||||||
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 | ||||
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 | ||||||||
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 | ||||
ESP | Spain | AP-P | People's Alliance-Party | Alianza-Partido Popular | Alianza-Partido Popular | con | Conservative | 7.5969 | 7.619 | 7.8127 | 7.7368 | 33610 | 274 | 1724610 | 1412 | 3608 | 502 | 7800 | 502 | 27 | 645 | 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 | ||||
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 | |||||
IRL | Ireland | A | Aontu | Aontú | Aontu | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 37 | 2795 | 26 | ||||||||
AUS | Australia | ACP-V | Australian Country Party (Vic) | Australian Country Party (Vic) | Australian Country Party (Vic) | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1935 | 26 | |||||||||
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 | BNS | Bulgarian People's Union | Balgarski Naroden Suyuz | Balgarski Naroden Suyuz | con | Conservative | 5.8 | 6.0 | 5.44 | 8.3333 | 80811 | 2009 | 10 | 1375 | 26 | ||||||
BGR | Bulgaria | BV | Bulgarian Rise | Balgarski vazhod | Balgarski vazhod | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2871 | 26 | ||||||||
DEU | Germany | BP | Bavarian Party | Bayernpartei | Bayernpartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41911 | 54 | 1131 | 26 | |||||||
ISL | Iceland | Bf-87 | Citizens' Party -- 1987 | Borgaraflokkurinn – 1987 | Borgaraflokkurinn -- 1987 | con | Conservative | 7.4 | 6.4 | 6.9 | 15621 | 56 | 828 | 26 | ||||||||
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 | |||||||
FRA | France | CNIP | National Centre of Independents and Peasants [Conservatives] | Centre national des indépendants et paysans | Centre national des independants et paysans | con | Conservative | 7.5636 | 6.4495 | 7.2219 | 7.2286 | 31622 | 707 | 609 | 609 | 43 | 1414 | 26 | ||||
FRA | France | CeD | Centre Right | Centre-droit | Centre-droit | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 2250 | 26 | ||||||||
ITA | Italy | CeD | Centre Right | Centro-destra | Centro-destra | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 32629 | 26 | 67 | 26 | |||||||
DNK | Denmark | CD | Centre Democrats | Centrumdemokraterne | Centrumdemokraterne | con | Conservative | 5.5609 | 4.8029 | 4.9307 | 9.1468 | 13330 | 506 | 1105 | 204 | 5477 | 204 | 21 | 1324 | 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 | |||||||
AUS | Australia | C | Coalition | Coalition | Coalition | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1428 | 26 | |||||||||
AUS | Australia | CLP | Commonwealth Liberal Party | Commonwealth Liberal Party | Commonwealth Liberal Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 2285 | 26 | |||||||||
FRA | France | C | Conservatives | Conservateurs | Conservateurs | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 2589 | 26 | ||||||||
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 | ||||||||
NZL | New Zealand | CP | Conservatice Party of New Zealand | Conservative Party of New Zealand | Conservative Party of New Zealand | con | Conservative | 7.4 | 6.4 | 6.9 | 11 | 1973 | 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 | 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 | C | Constitutionalist | Constitutionalist | Constitutionalist | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 44 | 2514 | 26 | ||||||||
ESP | Spain | CDC|JxCat | Democratic Convergence | Together for Catalonia | Convergència Democràtica | Junts per Catalunya | Convergencia Democratica | Junts per Catalunya | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 27 | 2605 | 26 | ||||||||
ESP | Spain | CiU | Convergence and Union | Convergència i Unió | Convergencia i Unio | con | Conservative | 6.2564 | 6.3998 | 6.1104 | 8.7309 | 33611 | 357 | 1724007 | 1408 | 3607 | 505 | 7740 | 505 | 27 | 894 | 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 | ||||||||
AUS | Australia | CPP-V | Country Progressive Party (Vic) | Country Progressive Party (Vic) | Country Progressive Party (Vic) | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1914 | 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 | ||||||||
FRA | France | DLR|DLF | Republic Arise | France Arise | Debout la république | Debout la France | Debout la republique | Debout la France | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 43 | 2399 | 26 | ||||||||
ISR | Israel | DeTo | Banner of the Torah | Degel HaTorah | Degel HaTorah | con | Conservative | 7.4 | 6.4 | 6.9 | 72614 | 34 | 249 | 26 | ||||||||
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 | ||||||||
MLT | Malta | DAP | Democratic Action Party | Democratic Action Party | Democratic Action Party | con | Conservative | 7.4 | 6.4 | 6.9 | 72 | 816 | 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 | |||||||
NLD | Netherlands | DS70 | Democratic Socialists 70 | Democratisch Socialisten 70 | Democratisch Socialisten 70 | con | Conservative | 3.8433 | 3.9133 | 3.5288 | 8.4641 | 22524 | 1002 | 8 | 402 | 26 | ||||||
NOR | Norway | D | Democrats | Demokratene | Demokratene | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 9 | 2816 | 26 | ||||||||
BGR | Bulgaria | DSB|DB | Democrats for a Strong Bulgaria | Democratic Bulgaria | Demokrati za Silna Balgariya | Demokratichna Balgariya | Demokrati za Silna Balgariya | Demokratichna Balgariya | con | Conservative | 7.85 | 7.83 | 4.5 | 8.9667 | 28 | 1100001 | 2008 | 10 | 57 | 26 | |||||
DEU | Germany | DHP | German-Hanoverian Party | Deutsch-Hannoversche Partei | Deutsch-Hannoversche Partei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 2696 | 26 | ||||||||
DEU | Germany | DP | German Party | Deutsche Partei | Deutsche Partei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41620 | 54 | 912 | 26 | |||||||
AUT | Austria | DVP | German People's Party | Deutsche Volkspartei | Deutsche Volkspartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 59 | 2673 | 26 | ||||||||
DEU | Germany | DVP | German People's Party | Deutsche Volkspartei | Deutsche Volkspartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 2693 | 26 | ||||||||
AUT | Austria | DNP | German-Nationals | Deutschnationale | Deutschnationale | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 59 | 2672 | 26 | ||||||||
AUT | Austria | REKOS | The Reform Conservatives | Die Reformkonservativen – REKOS | Die Reformkonservativen -- REKOS | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 59 | 2339 | 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 | DIANA | Democratic Renewal | Dimokratiki Ananeosi | Dimokratiki Ananeosi | con | Conservative | 7.4 | 6.4 | 6.9 | 10.0 | 149 | 405 | 41 | 1374 | 26 | ||||||
CYP | Cyprus | DIKO | Democratic Party | Dimokratikó Kómma | Dimokratiko Komma | con | Conservative | 5.1316 | 4.0789 | 6.0526 | 55422 | 50 | 1196422 | 5369 | 51 | 851 | 26 | |||||
CYP | Cyprus | DISY | Democratic Rally | Dimokratikós Sinayermós | Dimokratikos Synagermos | con | Conservative | 8.6842 | 7.3684 | 5.0 | 55711 | 51 | 1196711 | 5387 | 51 | 1575 | 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 | ||||
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 | ||||||||
EST | Estonia | ERSP | Estonian National Independence Party | Eesti Rahvusliku Sõltumatuse Partei | Eesti Rahvusliku Soltumatuse Partei | con | Conservative | 7.7778 | 6.4 | 6.9 | 7.9 | 83711 | 1210 | 75 | 552 | 26 | ||||||
EST | Estonia | EV | Free Party | Eesti Vabaerakond | Eesti Vabaerakond | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 75 | 2409 | 26 | ||||||||
EST | Estonia | ERa/EKR | People's Union of Estonia / Conservative People's Party | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond | con | Conservative | 4.5812 | 4.8509 | 6.9474 | 6.0627 | 83612 | 78 | 1233612 | 1768 | 2206 | 75 | 417 | 26 | |||
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 | |||||
GRC | Greece | EL | Greek Solution | Elliniki Lisi | Elliniki Lisi | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 41 | 2780 | 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 | ||||||||
EST | Estonia | IRL | Union of Pro Patria and Res Publica | Erakond Isamaa ja Res Publica Liit | Erakond Isamaa ja Res Publica Liit | con | Conservative | 8.4962 | 8.2456 | 6.1053 | 9.2632 | 83611 | 80 | 1233613 | 1820 | 75 | 1597 | 26 | ||||
EST | Estonia | ERP | Res Publica Party | Erakond Res Publica | Erakond Res Publica | con | Conservative | 8.4962 | 8.2456 | 6.1053 | 9.2632 | 83611 | 1820 | 75 | 428 | 26 | ||||||
GRC | Greece | EP | National Alignment | Ethniki Parataxis | Ethniki Parataxis | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 34610 | 41 | 1027 | 26 | |||||||
DEU | Germany | Fam | Family Party of Germany | Familien-Partei Deutschlands | Familien-Partei Deutschlands | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 1235 | 26 | ||||||||
AUS | Australia | FFP | Family First Party | Family First Party | Family First Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 446 | 26 | |||||||||
NOR | Norway | FeBo | Electoral lists Conservatives | Felleslister borgerlige | Felleslister borgerlige | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 9 | 2194 | 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 |
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 | 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 | ||
CYP | Cyprus | GTE | For Europe | Gia tin Evropi | For Europe | con | Conservative | 7.4 | 6.4 | 6.9 | 51 | 768 | 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 | ||
DEU | Germany | FW | Free Voters | Freie Wähler | Freie Waehler | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 121 | 54 | 41 | 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 | ||||||||
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 | |||||
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 | ||||||||
FRA | France | G | Gaullists | Gaulliste | Gaulliste | con | Conservative | 8.2 | 6.4 | 6.9 | 7.9 | 31621 | 706 | 43 | 1094 | 26 | ||||||
NLD | Netherlands | GPV | Reformed Political League | Gereformeerd Politiek Verbond | Gereformeerd Politiek Verbond | con | Conservative | 8.1444 | 5.8 | 8.6364 | 3.4848 | 1108 | 2606 | 1007 | 1007 | 8 | 625 | 26 | ||||
DEU | Germany | GDP | All-German Party | Gesamtdeutsche Partei | Gesamtdeutsche Partei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 54 | 1701 | 26 | ||||||||
ISR | Israel | G-96 | Bridge -- 1996 | Gesher – 1996 | Gesher -- 1996 | con | Conservative | 7.4 | 6.4 | 6.9 | 34 | 1862 | 26 | |||||||||
AUT | Austria | GDVP | Greater German People's Party | Großdeutsche Volkspartei | Grossdeutsche Volkspartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 59 | 2674 | 26 | ||||||||
JPN | Japan | PR | Peace and Reform | Heiwa Kaikaku | Heiwa Kaikaku | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 2068 | 26 | |||||||||
ISR | Israel | Herut | Freedom Party | Herut | Herut | con | Conservative | 7.4 | 6.4 | 6.9 | 72620 | 34 | 1204 | 26 | ||||||||
DNK | Denmark | FF | People's Party (Faroe Islands) | Hin føroyski fólkaflokkurin – radikalt sjálvstýri | Hin foroyski folkaflokkurin -- radikalt sjalvstyri | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 21 | 2574 | 26 | ||||||||
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 | ||
JPN | Japan | NCP | New Conservative Party | Hoshu Shintō | Hoshu Shinto | con | Conservative | 8.2675 | 5.6522 | 8.032 | 71626 | 8448 | 5 | 1382 | 26 | |||||||
NOR | Norway | H | Conservative Party | Høyre | Hoyre | con | Conservative | 7.8994 | 8.2957 | 3.584 | 9.5074 | 12620 | 1306 | 2908 | 1506 | 7524 | 3503 | 9 | 1435 | 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 | ||||||||
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 | ||||||||
FRA | France | IR|DL | Independent Republicans | Liberal Democracy | Independants républicains | Démocratie libérale | Independants republicains | Democratie liberale | con | Conservative | 7.0577 | 7.7993 | 6.1743 | 8.246 | 1410 | 606 | 615 | 43 | 59 | 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 | ||||||||
AUS | Australia | IPP-V | Independent Protectionist Party (Vic) | Independent Protectionist Party (Vic) | Independent Protectionist Party (Vic) | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1917 | 26 | |||||||||
POL | Poland | IdP | Initiative for Poland | Inicjatywa dla Polski | Inicjatywa dla Polski | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 74 | 1680 | 26 | ||||||||
EST | Estonia | I | Pro Patria Union | Isamaaliit | Isamaaliit | con | Conservative | 7.6169 | 6.414 | 7.3789 | 8.5189 | 83710 | 1212 | 1690 | 2201 | 75 | 846 | 26 | ||||
FIN | Finland | IK | Patriotic People's Movement | Isänmaallinen Kansanliike – Fosterländska Folkrörelsen | Isanmaallinen Kansanliike -- Fosterlandska Folkrorelsen | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 67 | 957 | 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 | ||||||||
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 | JP | New Era Party | Jaunā partija | Jauna partija | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 87431 | 55 | 550 | 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 |
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;