view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
59 rows where family_name = "Agrarian" sorted by country_id
This data as json, CSV (advanced)
Suggested facets: country_name_short, country_name, left_right, state_market, liberty_authority, eu_anti_pro, huber_inglehart, country_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 | 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 | ||||||||
LUX | Luxembourg | BMP | Party of Farmers and the Middle Class | Baueren- a Mëttelstandspartei | Baueren- a Mettelstandspartei | agr | Agrarian | 5.3 | 4.9 | 6.5 | 7 | 2536 | 2 | |||||||||
NLD | Netherlands | BBB | Farmer-Citizen Movement | BoerBurgerBeweging | BoerBurgerBeweging | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 8 | 2824 | 2 | ||||||||
NLD | Netherlands | Bp | Farmers Party | Boerenpartij | Boerenpartij | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 8 | 1595 | 2 | ||||||||
NLD | Netherlands | PB|NBTM | Plattelandersbond | National Farmers', Horticulturists' and Middle Class Party | Peasants' League | Nationale Boeren-, Tuinders- en Middenstandspartij | Peasants' League | Nationale Boeren-, Tuinders- en Middenstandspartij | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 8 | 2458 | 2 | ||||||||
NOR | Norway | Sp | Centre Party | Senterpartiet | Senterpartiet | agr | Agrarian | 4.6565 | 2.807 | 5.7644 | 0.188 | 12810 | 1304 | 2904 | 1504 | 7596 | 3505 | 9 | 702 | 2 | ||
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 | 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 | 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 | |||||||
NZL | New Zealand | CouPa | Country Party | Country Party | Country Party | agr | Agrarian | 5.3 | 4.9 | 6.5 | 11 | 2467 | 2 | |||||||||
LTU | Lithuania | LVLS | Lithuanian Peasant Union | Lietuvos valstiečių sąjunga | Lietuvos valstiecic sajunga | agr | Agrarian | 3.2687 | 3.7152 | 5.8514 | 5.2909 | 2432 | 15 | 191 | 2 | |||||||
LTU | Lithuania | LVP | Lithuanian Peasant Party | Lietuvos valstiečių partija | Lietuvos valstieciu partija | agr | Agrarian | 2.645 | 2.75 | 8.0 | 6.525 | 88810 | 2507 | 15 | 1632 | 2 | ||||||
DNK | Denmark | Bo | Farmers' Party | Bondepartiet | Bondepartiet | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 21 | 2428 | 2 | ||||||||
ROU | Romania | PDAR | Democratic Agrarian Party of Romania | Partidul Democrat Agrar din România | Partidul Democrat Agrar din Romania | agr | Agrarian | 5.5556 | 4.9 | 6.5 | 5.4 | 93810 | 3207 | 23 | 1299 | 2 | ||||||
ITA | Italy | PaCoI | Agrarian Party | Partito dei Contadini d'Italia | Partito dei Contadini d'Italia | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 26 | 618 | 2 | ||||||||
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 | |||||||||
AUS | Australia | FS-NSW | Farmers and Settlers (NSW) | Farmers and Settlers (NSW) | Farmers and Settlers (NSW) | agr | Agrarian | 5.3 | 4.9 | 6.5 | 33 | 1913 | 2 | |||||||||
AUS | Australia | LCP-V | Liberal Country Party (Vic) | Liberal Country Party (Vic) | Liberal Country Party (Vic) | agr | Agrarian | 5.3 | 4.9 | 6.5 | 33 | 1939 | 2 | |||||||||
AUS | Australia | VFU-V | Victorian Farmers' Union | Victorian Farmers' Union | Victorian Farmers' Union | agr | Agrarian | 5.3 | 4.9 | 6.5 | 33 | 1929 | 2 | |||||||||
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 |
SWE | Sweden | JR | National Farmers' Union | Jordbrukarnas Riksförbund | Jordbrukarnas Riksforbund | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 35 | 2556 | 2 | ||||||||
IRL | Ireland | CnT | Party of the Land | Clann na Talmhan | Clann na Talmhan | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 53810 | 37 | 923 | 2 | |||||||
IRL | Ireland | FP | Farmers' Party | Farmers' Party | Farmers' Party | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 37 | 2563 | 2 | ||||||||
HUN | Hungary | ASZ | Agrarian Alliance | Agrárszövetség | Agrarszovetseg | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 86811 | 39 | 1183 | 2 | |||||||
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 | ||
FRA | France | CPNT | Hunting, Fishing, Nature, Tradition | Chasse, pêche, nature, traditions | Chasse, peche, nature, traditions | agr | Agrarian | 7.8 | 7.25 | 7.875 | 2.2222 | 109 | 619 | 43 | 259 | 2 | ||||||
DEU | Germany | BLB | Baden Rural Federation | Badischer Landbund | Badischer Landbund | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 54 | 2707 | 2 | ||||||||
DEU | Germany | BWB | Farmers and Wine Growers Association | Bauern- und Weingärtnerbund | Bauern- und Weingaertnerbund | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 54 | 2703 | 2 | ||||||||
DEU | Germany | DBP | German Farmers' Party | Deutsche Bauernpartei | Deutsche Bauernpartei | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 54 | 2712 | 2 | ||||||||
DEU | Germany | HBB | Hessian Farmers' Federation | Hessischer Bauernbund | Hessischer Bauernbund | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 54 | 2706 | 2 | ||||||||
DEU | Germany | LBT | Rural Federation Thuringia | Landbund Thüringen | Landbund Thueringen | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 54 | 2704 | 2 | ||||||||
DEU | Germany | SLV | Saxon Peasants | Sächsisches Landvolk | Saechsisches Landvolk | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 54 | 2708 | 2 | ||||||||
LVA | Latvia | LZ | Union of Latvian Farmers | Latviesu Zemnieku Savieniba | Latviesu Zemnieku Savieniba | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 55 | 2417 | 2 | ||||||||
LVA | Latvia | LZS | Farmers Union of Latvia | Latvijas Zemnieku Savienība | Latvijas Zemnieku Savieniba | agr | Agrarian | 4.375 | 4.835 | 6.04 | 6.4583 | 87810 | 2405 | 55 | 1368 | 2 | ||||||
LVA | Latvia | ZZS | Green and Farmers' Union | Zaļo un Zemnieku savienība | Zalo un Zemnieku savieniba | agr | Agrarian | 5.2632 | 5.3947 | 6.1184 | 6.7763 | 87110 | 198 | 1428110 | 2210 | 55 | 466 | 2 | ||||
ISL | Iceland | Ba | Farmers' Party | Bændaflokkur | Bndaflokkur | agr | Agrarian | 5.3 | 4.9 | 6.5 | 56 | 2439 | 2 | |||||||||
ISL | Iceland | F | Progressive Party | Framsóknarflokkurinn | Framsoknarflokkurinn | agr | Agrarian | 5.0365 | 5.6579 | 3.8596 | 15810 | 1703 | 6203 | 56 | 1455 | 2 | ||||||
ISL | Iceland | Sjf | Association for Equality and Justice | Samtök um jatnrétti og félagshyggju | Samtok um jatnretti og felagshyggju | agr | Agrarian | 5.3 | 4.9 | 6.5 | 56 | 817 | 2 | |||||||||
ISL | Iceland | Thod | National Party | Þjóðarflokkurinn | Thjodarflokkurinn | agr | Agrarian | 5.3 | 4.9 | 6.5 | 56 | 2116 | 2 | |||||||||
AUT | Austria | KB | Carinthian Farmers' Association | Kärtner Bauernbund | Kartner Bauernbund | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 59 | 2678 | 2 | ||||||||
AUT | Austria | SBP | Styrian Farmers' Party | Steirische Bauernpartei | Steirische Bauernpartei | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 59 | 2677 | 2 | ||||||||
HRV | Croatia | HDSS | Croatian Democratic Peasant Party | Hrvatska demokratska seljačka stranka | Hrvatska demokratska seljacka stranka | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 62 | 2198 | 2 | ||||||||
HRV | Croatia | HSNS | Croatian Peasant's People's Party | Hrvatska seljacka narodna stranka | Hrvatska seljacka narodna stranka | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 62 | 2202 | 2 | ||||||||
HRV | Croatia | HSS | Croatian Peasant Party | Hrvatska seljačka stranka | Hrvatska seljacka stranka | agr | Agrarian | 6.2281 | 4.2982 | 7.807 | 6.2281 | 81810 | 1198 | 3103 | 62 | 1465 | 2 | |||||
FIN | Finland | KESK | Centre Party | Keskusta | Keskusta | agr | Agrarian | 5.8027 | 4.9349 | 7.2203 | 5.5267 | 14810 | 90 | 1246810 | 603 | 1306 | 1403 | 5677 | 1403 | 67 | 94 | 2 |
FIN | Finland | Ka | People's Party | Kansanpuolue | Kansanpuolue | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 67 | 2292 | 2 | ||||||||
FIN | Finland | PMP | Party of Smallholders and Rural People | Pienviljelijäin ja maalaiskansan puolue | Pienviljelijain ja maalaiskansan puolue | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 67 | 2293 | 2 | ||||||||
FIN | Finland | SPP | Finnish Small Farmers' Party | Suomen Pienviljelijäin Puolue – Finska Småbrukarpartiet | Suomen Pienviljelijain Puolue -- Finska Smabrukarpartiet | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 67 | 920 | 2 | ||||||||
FIN | Finland | SP|P | Finnish Party | True Finns | Suomen Puolue | Perussuomalaiset | Suomen Puolue | Perussuomalaiset | agr | Agrarian | 6.6331 | 4.8745 | 7.999 | 1.0945 | 14820 | 89 | 1246820 | 605 | 1307 | 1405 | 5717 | 1405 | 67 | 200 | 2 |
CZE | Czech Republic | SZV | Alliance of Farmers and the Countryside | Spojenectví zemědělců a venkova | Spojenectvi zemedelcu a venkova | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 68 | 2101 | 2 | ||||||||
POL | Poland | PL | Peasants Agreement | Porozumenie Ludowe | Porozumenie Ludowe | agr | Agrarian | 3.3333 | 4.9 | 6.5 | 5.4 | 92810 | 3002 | 74 | 619 | 2 | ||||||
POL | Poland | PSL | Polish People's Party | Polskie Stronnictwo Ludowe | Polskie Stronnictwo Ludowe | agr | Agrarian | 4.1856 | 2.8942 | 6.5491 | 5.3573 | 92811 | 229 | 1616811 | 3002 | 3006 | 2606 | 74 | 664 | 2 | ||
POL | Poland | SRP | Self-Defense of the Republic Poland | Samoobrona Rzeczypospolitej Polskiej | Samoobrona Rzeczypospolitej Polskiej | agr | Agrarian | 3.997 | 2.008 | 7.3253 | 2.1473 | 92622 | 384 | 3076 | 2604 | 74 | 207 | 2 | ||||
POL | Poland | ZSL | United People's Party | Zjednoczone Stronnictwo Ludowe | Zjednoczone Stronnictwo Ludowe | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 74 | 822 | 2 | ||||||||
EST | Estonia | EM | Estonian Country Union | Eesti Maaliit | Eesti Maaliit | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 75 | 2403 | 2 | ||||||||
EST | Estonia | EMK | Estonian Rural Centre Party | Eesti Maa-Keskerakond | Eesti Maa-Keskerakond | agr | Agrarian | 5.5556 | 4.9 | 6.5 | 5.4 | 1207 | 75 | 1257 | 2 | |||||||
EST | Estonia | EPPE | Estonian Party of Pensioners and Families | Eesti Pensionäride ja Perede Erakond | Eesti Pensionaride ja Perede Erakond | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 75 | 2402 | 2 | ||||||||
EST | Estonia | ETE | Estonian Farmers Party | Eesti Talurahva Erakond | Eesti Talurahva Erakond | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 75 | 1796 | 2 | ||||||||
EST | Estonia | PK | Union of Farmers | Põllumeeste Kogu | Pollumeeste Kogu | agr | Agrarian | 2.2222 | 4.9 | 6.5 | 5.4 | 1203 | 75 | 1553 | 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;