view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by party_name descending
This data as json, CSV (advanced)
Suggested facets: family_name, family_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HRV | Croatia | ZiZi | Human Shield | Živi zid | Zivi zid | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 62 | 2612 | 40 | ||||||||
LTU | Lithuania | Zp | Samogitian Party | Žemaičių partija | Zemaiciu partija | spec | Special issue | 15 | 2025 | 16 | ||||||||||||
SVK | Slovakia | LsNS | People's Party Our Slovakia | Ľudová strana Naše Slovensko | Ludova strana Nase Slovensko | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 1 | 586 | 40 | ||||||||
TUR | Turkey | IYI | Iyi Party | İyi Parti | Iyi Parti | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 20 | 2702 | 40 | ||||||||
CZE | Czech Republic | CSSD | Czech Social Democratic Party | Česká strana sociálně demokratická | Ceska strana socialne demokraticka | soc | Social democracy | 3.0463 | 3.0031 | 4.2463 | 8.5647 | 82320 | 55 | 1203320 | 1002 | 1328 | 2101 | 68 | 789 | 11 | ||
CZE | Czech Republic | CNSP | Czech National Social(ist) Party | Česká národně strana socialistická | Ceska narodne strana socialisticka | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 68 | 29 | 40 | ||||||||
ISL | Iceland | Thve | Common Wealth Party | Þjóðveldisflokkurinn | Tjodveldisflokkurin | con | Conservative | 7.4 | 6.4 | 6.9 | 56 | 2004 | 26 | |||||||||
ISL | Iceland | Thva | National Preservation Party | Þjóðvarnarflokkurinn | Thjodvarnarflokkurinn | lib | Liberal | 6.0 | 6.7 | 3.6 | 15710 | 56 | 1172 | 6 | ||||||||
ISL | Iceland | Th-Ff | People's Movement | Þjóðvaki – Fylking fólksins | Thjodvaki -- Fylking folksins | soc | Social democracy | 3.3 | 3.5 | 3.5 | 15323 | 56 | 205 | 11 | ||||||||
ISL | Iceland | Thod | National Party | Þjóðarflokkurinn | Thjodarflokkurinn | agr | Agrarian | 5.3 | 4.9 | 6.5 | 56 | 2116 | 2 | |||||||||
CZE | Czech Republic | UPD | Dawn of Direct Democracy | Úsvit přímé demokracie | Usvit prime demokracie | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 68 | 2262 | 26 | ||||||||
AUT | Austria | OVP | Austrian People's Party | Österreichische Volkspartei | Oesterreichische Volkspartei | chr | Christian democracy | 6.4733 | 6.9485 | 7.6198 | 8.8451 | 42520 | 6 | 1040520 | 203 | 309 | 1302 | 4847 | 1302 | 59 | 1013 | 3 |
DEU | Germany | ODP | Ecological Democratic Party | Ökologisch-Demokratische Partei | Okologisch-Demokratische Partei | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 54 | 2736 | 19 | ||||||||
ISL | Iceland | IL | Icelandic Movement -- Living Country | Íslandshreyfingin – lifandi land | Islandshreyfingin -- lifandi land | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 56 | 2115 | 19 | |||||||||
BEL | Belgium | Ecolo | Confederated ecologists for the organisation of original struggles | Écologistes Confédérés pour l'organisation de luttes originales | Ecologistes Confederes pour l'organisation de luttes originales | eco | Green/Ecologist | 2.641 | 2.3887 | 1.3744 | 7.5411 | 21111 | 23 | 1056111 | 305 | 402 | 104 | 4923 | 104 | 64 | 161 | 19 |
FIN | Finland | AS | Aland Coalition | Åländsk Samling | Alandsk Samling | spec | Special issue | 67 | 66 | 16 | ||||||||||||
JPN | Japan | vac | vacancy | vacancy | vacancy | none | no family | 5 | 1812 | 12 | ||||||||||||
CHE | Switzerland | S | Solidarity | solidaritéS | solidariteS | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 40 | 1226 | 14 | ||||||||
ITA | Italy | none | no party affiliation | senzo partito | senzo partito | none | no family | 26 | 1552 | 12 | ||||||||||||
FRA | France | none | no party affiliation | sans étiquette | sans etiquette | none | no family | 43 | 947 | 12 | ||||||||||||
SWE | Sweden | none | no party affiliation | partilös | partilos | none | no family | 35 | 786 | 12 | ||||||||||||
CHE | Switzerland | none | no party affiliation | parteilos | parteilos | none | no family | 40 | 1211 | 12 | ||||||||||||
DEU | Germany | none | no party affiliation | parteilos | parteilos | none | no family | 54 | 610 | 12 | ||||||||||||
AUT | Austria | etc | others | others | others | none | no family | 59 | 2687 | 12 | ||||||||||||
BEL | Belgium | etc | others | others | others | none | no family | 64 | 2488 | 12 | ||||||||||||
CAN | Canada | etc | others | others | others | none | no family | 29 | 2577 | 12 | ||||||||||||
CHE | Switzerland | etc | others | others | others | none | no family | 40 | 2579 | 12 | ||||||||||||
DNK | Denmark | etc | others | others | others | none | no family | 21 | 2576 | 12 | ||||||||||||
ESP | Spain | etc | others | others | others | none | no family | 27 | 1377 | 12 | ||||||||||||
GBR | United Kingdom | etc | others | others | others | none | no family | 44 | 453 | 12 | ||||||||||||
ISR | Israel | etc | others | others | others | none | no family | 34 | 2352 | 12 | ||||||||||||
JPN | Japan | etc | others | others | others | none | no family | 5 | 1055 | 12 | ||||||||||||
LTU | Lithuania | etc | others | others | others | none | no family | 15 | 2802 | 12 | ||||||||||||
NOR | Norway | etc | others | others | others | none | no family | 9 | 2578 | 12 | ||||||||||||
NZL | New Zealand | etc | others | others | others | none | no family | 11 | 1365 | 12 | ||||||||||||
POL | Poland | etc | others | others | others | none | no family | 74 | 1091 | 12 | ||||||||||||
SVK | Slovakia | etc | others | others | others | none | no family | 1 | 1659 | 12 | ||||||||||||
SVN | Slovenia | etc | others | others | others | none | no family | 60 | 753 | 12 | ||||||||||||
AUT | Austria | one-seat | one-seat | one-seat | one-seat | none | no family | 59 | 2686 | 12 | ||||||||||||
AUS | Australia | one-seat | one seat | one seat | one seat | none | no family | 33 | 2299 | 12 | ||||||||||||
BEL | Belgium | one-seat | one seat | one seat | one seat | none | no family | 64 | 2300 | 12 | ||||||||||||
CHE | Switzerland | one-seat | one seat | one seat | one seat | none | no family | 40 | 2303 | 12 | ||||||||||||
DEU | Germany | one-seat | one seat | one seat | one seat | none | no family | 54 | 2289 | 12 | ||||||||||||
ESP | Spain | one-seat | one seat | one seat | one seat | none | no family | 27 | 2294 | 12 | ||||||||||||
FIN | Finland | one-seat | one seat | one seat | one seat | none | no family | 67 | 2413 | 12 | ||||||||||||
FRA | France | one-seat | one seat | one seat | one seat | none | no family | 43 | 2859 | 12 | ||||||||||||
GBR | United Kingdom | one-seat | one seat | one seat | one seat | none | no family | 44 | 2296 | 12 | ||||||||||||
HRV | Croatia | one-seat | one seat | one seat | one seat | none | no family | 62 | 2295 | 12 | ||||||||||||
HUN | Hungary | one-seat | one seat | one seat | one seat | none | no family | 39 | 952 | 12 | ||||||||||||
IRL | Ireland | one-seat | one seat | one seat | one seat | none | no family | 37 | 2298 | 12 | ||||||||||||
ISR | Israel | one-seat | one seat | one seat | one seat | none | no family | 34 | 2313 | 12 | ||||||||||||
ITA | Italy | one-seat | one seat | one seat | one seat | none | no family | 26 | 2302 | 12 | ||||||||||||
JPN | Japan | one-seat | one seat | one seat | one seat | none | no family | 5 | 2297 | 12 | ||||||||||||
LTU | Lithuania | one-seat | one seat | one seat | one seat | none | no family | 15 | 652 | 12 | ||||||||||||
LUX | Luxembourg | one-seat | one seat | one seat | one seat | none | no family | 7 | 2290 | 12 | ||||||||||||
LVA | Latvia | one-seat | one seat | one seat | one seat | none | no family | 55 | 2879 | 12 | ||||||||||||
NLD | Netherlands | one-seat | one seat | one seat | one seat | none | no family | 8 | 2288 | 12 | ||||||||||||
NOR | Norway | one-seat | one seat | one seat | one seat | none | no family | 9 | 474 | 12 | ||||||||||||
POL | Poland | one-seat | one seat | one seat | one seat | none | no family | 74 | 2287 | 12 | ||||||||||||
PRT | Portugal | one-seat | one seat | one seat | one seat | none | no family | 63 | 2291 | 12 | ||||||||||||
ROU | Romania | one-seat | one seat | one seat | one seat | none | no family | 23 | 441 | 12 | ||||||||||||
AUS | Australia | no-seat | no seat | no seat | no seat | none | no family | 33 | 2057 | 12 | ||||||||||||
AUT | Austria | no-seat | no seat | no seat | no seat | none | no family | 59 | 2055 | 12 | ||||||||||||
BEL | Belgium | no-seat | no seat | no seat | no seat | none | no family | 64 | 2052 | 12 | ||||||||||||
CAN | Canada | no-seat | no seat | no seat | no seat | none | no family | 29 | 2067 | 12 | ||||||||||||
DEU | Germany | no-seat | no seat | no seat | no seat | none | no family | 54 | 2034 | 12 | ||||||||||||
DNK | Denmark | no-seat | no seat | no seat | no seat | none | no family | 21 | 2058 | 12 | ||||||||||||
ESP | Spain | no-seat | no seat | no seat | no seat | none | no family | 27 | 2056 | 12 | ||||||||||||
FIN | Finland | no-seat | no seat | no seat | no seat | none | no family | 67 | 2054 | 12 | ||||||||||||
FRA | France | no-seat | no seat | no seat | no seat | none | no family | 43 | 2080 | 12 | ||||||||||||
GBR | United Kingdom | no-seat | no seat | no seat | no seat | none | no family | 44 | 2562 | 12 | ||||||||||||
GRC | Greece | no-seat | no seat | no seat | no seat | none | no family | 41 | 2168 | 12 | ||||||||||||
HUN | Hungary | no-seat | no seat | no seat | no seat | none | no family | 39 | 2350 | 12 | ||||||||||||
IRL | Ireland | no-seat | no seat | no seat | no-seat | none | no family | 37 | 2216 | 12 | ||||||||||||
ISL | Iceland | no-seat | no seat | no seat | no seat | none | no family | 56 | 2112 | 12 | ||||||||||||
ISR | Israel | no-seat | no seat | no seat | no seat | none | no family | 34 | 2308 | 12 | ||||||||||||
ITA | Italy | no-seat | no seat | no seat | no seat | none | no family | 26 | 2059 | 12 | ||||||||||||
JPN | Japan | no-seat | no seat | no seat | no seat | none | no family | 5 | 2141 | 12 | ||||||||||||
LTU | Lithuania | no-seat | no seat | no seat | no seat | none | no family | 15 | 2636 | 12 | ||||||||||||
LUX | Luxembourg | no-seat | no seat | no seat | no seat | none | no family | 7 | 2149 | 12 | ||||||||||||
MLT | Malta | no-seat | no seat | no seat | no seat | none | no family | 72 | 2171 | 12 | ||||||||||||
NLD | Netherlands | no-seat | no seat | no seat | no seat | none | no family | 8 | 2110 | 12 | ||||||||||||
NOR | Norway | no-seat | no seat | no seat | no seat | none | no family | 9 | 2100 | 12 | ||||||||||||
NZL | New Zealand | no-seat | no seat | no seat | no seat | none | no family | 11 | 2070 | 12 | ||||||||||||
POL | Poland | no-seat | no seat | no seat | no seat | none | no family | 74 | 2053 | 12 | ||||||||||||
PRT | Portugal | no-seat | no seat | no seat | no seat | none | no family | 63 | 2864 | 12 | ||||||||||||
SWE | Sweden | no-seat | no seat | no seat | no seat | none | no family | 35 | 2405 | 12 | ||||||||||||
TUR | Turkey | no-seat | no seat | no seat | no seat | none | no family | 20 | 2316 | 12 | ||||||||||||
AUS | Australia | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 33 | 1396 | 12 | ||||||||||||
BEL | Belgium | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 64 | 1458 | 12 | ||||||||||||
BGR | Bulgaria | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 10 | 133 | 12 | ||||||||||||
CAN | Canada | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 29 | 1189 | 12 | ||||||||||||
CYP | Cyprus | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 51 | 534 | 12 | ||||||||||||
CZE | Czech Republic | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 68 | 1567 | 12 | ||||||||||||
ESP | Spain | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 27 | 1166 | 12 | ||||||||||||
EST | Estonia | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 75 | 426 | 12 | ||||||||||||
GBR | United Kingdom | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 44 | 1599 | 12 | ||||||||||||
GRC | Greece | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 41 | 1358 | 12 | ||||||||||||
HRV | Croatia | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 62 | 2197 | 12 | ||||||||||||
IRL | Ireland | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 1372000 | 37 | 30 | 12 |
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;