view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by country_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
JPN | Japan | TPJ | Tomorrow Party of Japan | Nippon Mirai no Tō | Nippon Mirai no To | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 5 | 2785 | 19 | |||||||||
JPN | Japan | YP | Your Party | Minna no Tō | Minna no To | lib | Liberal | 6.0 | 6.7 | 3.6 | 5 | 1124 | 6 | |||||||||
JPN | Japan | etc | others | others | others | none | no family | 5 | 1055 | 12 | ||||||||||||
JPN | Japan | no-seat | no seat | no seat | no seat | none | no family | 5 | 2141 | 12 | ||||||||||||
JPN | Japan | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 5 | 905 | 12 | ||||||||||||
JPN | Japan | one-seat | one seat | one seat | one seat | none | no family | 5 | 2297 | 12 | ||||||||||||
JPN | Japan | vac | vacancy | vacancy | vacancy | none | no family | 5 | 1812 | 12 | ||||||||||||
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 | 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 | |||||||||
LUX | Luxembourg | Bl | Citizens' List | Biergerlëscht | Biergerlescht | spec | Special issue | 416 | 1442009 | 7 | 1130 | 16 | ||||||||||
LUX | Luxembourg | CSV | Christian Social People's Party | Chrëschtlech Sozial Vollekspartei | Chreschtlech Sozial Vollekspartei | chr | Christian democracy | 6.4474 | 6.7105 | 7.5 | 23520 | 210 | 1442520 | 901 | 6886 | 7 | 1234 | 3 | ||||
LUX | Luxembourg | DL | The Left | Déi Lénk | Dei Lenk | com | Communist/Socialist | 0.5263 | 0.8772 | 1.0526 | 215 | 1442222 | 6906 | 7 | 457 | 14 | ||||||
LUX | Luxembourg | DP | Democratic Party | Demokratesch Partei | Demokratesch Partei | lib | Liberal | 6.5789 | 7.3684 | 2.7632 | 23420 | 212 | 1442420 | 903 | 6926 | 7 | 967 | 6 | ||||
LUX | Luxembourg | DeLe | Democratic List | Demokratesch Lëscht | Demokratesch Lescht | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2448 | 6 | |||||||||
LUX | Luxembourg | FV | Independent People's Party | Fräi Vollekspartei | Frai Vollekspartei | code | to be coded | 7 | 2451 | 28 | ||||||||||||
LUX | Luxembourg | GLEI | Green Left Ecological Initiative | Greng Lëscht Ekologesch Initiativ | Greng Lescht Ekologesch Initiativ | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 23111 | 906 | 7 | 1158 | 19 | |||||||
LUX | Luxembourg | GLS | Group for Luxembourgian Sovereignty | Groupement fir d'Lëtzebuerger Souveränitéit | Groupement fir d'Letzebuerger Souveraniteit | spec | Special issue | 7 | 2146 | 16 | ||||||||||||
LUX | Luxembourg | Greng | The Greens | Déi Gréng | Dei Greng | eco | Green/Ecologist | 2.5 | 1.5789 | 0.7895 | 23113 | 213 | 1442113 | 6946 | 7 | 310 | 19 | |||||
LUX | Luxembourg | KPL | Communist Party of Luxembourg | Kommunistesch Partei Lëtzebuerg | Kommunistesch Partei Letzebuerg | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 23220 | 216 | 1442220 | 904 | 7 | 151 | 14 | |||||
LUX | Luxembourg | LL | Liberal League | Liberal Liga | Liberal Liga | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2453 | 6 | |||||||||
LUX | Luxembourg | LSAP | Luxembourg Socialist Workers' Party | Lëtzebuerger Sozialistesch Aarbechterpartei | Letzebuerger Sozialistesch Aarbechterpartei | soc | Social democracy | 3.2895 | 3.9474 | 1.3158 | 23320 | 211 | 1442320 | 902 | 6966 | 7 | 701 | 11 | ||||
LUX | Luxembourg | LiLe | Left Liberals | Liberal Lénk | Left Liberals | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2531 | 6 | |||||||||
LUX | Luxembourg | MIP | Popular Independent Movement | Mouvement indépendant populaire | Mouvement independant populaire | spec | Special issue | 7 | 1462 | 16 | ||||||||||||
LUX | Luxembourg | NB | National Movement | National Bewegong | National Bewegong | right | Right-wing | 8.8 | 5.9 | 8.5 | 908 | 7 | 374 | 40 | ||||||||
LUX | Luxembourg | ONP | Independent National Party | Onofhängeg Nationalpartei | Onofhangeg Nationalpartei | right | Right-wing | 8.8 | 5.9 | 8.5 | 7 | 2450 | 40 | |||||||||
LUX | Luxembourg | ONV | National Independent Union | Onofhängeg National Vereenegung | Onofhangeg National Vereenegung | right | Right-wing | 8.8 | 5.9 | 8.5 | 7 | 2529 | 40 | |||||||||
LUX | Luxembourg | PBMA | Free List of Peasants, Middle Classes and Workers | Partei vun de Baueren, dem Mëttelstand an den Aarbechter | Partei vun de Baueren, dem Mettelstand an den Aarbechter | none | no family | 7 | 2449 | 12 | ||||||||||||
LUX | Luxembourg | PD | Party of the Right | Rietspartei | Rietspartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7 | 2527 | 26 | |||||||||
LUX | Luxembourg | PDPN | Progressive Democratic Party of the North | Fortschrëttlech-demokratesch Partei | Fortschrettlech-demokratesch Partei | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2538 | 6 | |||||||||
LUX | Luxembourg | PICM | Independent Party of the Middle Class | Parti Indépendant des Classes Moyennes | Parti Independant des Classes Moyennes | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2139 | 6 | |||||||||
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 | |||||||||
LUX | Luxembourg | PIE | Independents of the East | Parti des Indépendants de l'Est | Parti des Indpendants de l'Est | none | no family | 7 | 2452 | 12 | ||||||||||||
LUX | Luxembourg | PL | Liberal Party | Parti Libéral | Parti Liberal | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2140 | 6 | |||||||||
LUX | Luxembourg | PRL | Radical Liberal Party | Radikal-Liberal Partei | Radikal-Liberal Partei | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2455 | 6 | |||||||||
LUX | Luxembourg | Pi | Pirate Party Luxembourg | Piratepartei Lëtzebuerg | Piratepartei Letzebuerg | spec | Special issue | 7 | 2256 | 16 | ||||||||||||
LUX | Luxembourg | RP | Radical Left / Radical Party | Gauche radicale / Parti radical | Gauche radicale / Parti radical | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2533 | 6 | |||||||||
LUX | Luxembourg | RPMC | Radical Party (Marcel Cahen) | Radikal Partei (Marcel Cahen) | Radikal Partei (Marcel Cahen) | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2535 | 6 | |||||||||
LUX | Luxembourg | RSP | Radical Socialist Party | Radikal-Sozialistesch Partei | Radikal-Sozialistesch Partei | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2456 | 6 | |||||||||
LUX | Luxembourg | SDP | Social Democratic Party | Sozialdemokratesch Partei | Sozialdemokratesch Partei | soc | Social democracy | 3.3 | 3.5 | 3.5 | 7 | 1134 | 11 | |||||||||
LUX | Luxembourg | SI | Jean Gremling List -- Independent Socialists | Jean Gremling List – Socialistes Indépendants | Jean Gremling List -- Socialistes Independants | soc | Social democracy | 3.3 | 3.5 | 3.5 | 7 | 1339 | 11 | |||||||||
LUX | Luxembourg | VL | Volt Luxembourg | Volt Luxembourg | Volt Luxembourg | spec | Special issue | 7 | 2766 | 16 | ||||||||||||
LUX | Luxembourg | Z-EF | Coerced Conscripts | Zwangsrekrutéierten | Zwangsrekruteierten | spec | Special issue | 7 | 202 | 16 | ||||||||||||
LUX | Luxembourg | no-seat | no seat | no seat | no seat | none | no family | 7 | 2149 | 12 | ||||||||||||
LUX | Luxembourg | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 7 | 1002 | 12 | ||||||||||||
LUX | Luxembourg | one-seat | one seat | one seat | one seat | none | no family | 7 | 2290 | 12 | ||||||||||||
NLD | Netherlands | 50+ | 50PLUS | 50PLUS | 50PLUS | spec | Special issue | 8 | 2109 | 16 | ||||||||||||
NLD | Netherlands | AOV|VSP | General Senior Union | United Seniors Party | Algemeen Ouderen Verbond | Verenigde Senioren Partij | Algemeen Ouderen Verbond | Verenigde Senioren Partij | spec | Special issue | 8 | 112 | 16 | ||||||||||||
NLD | Netherlands | ARP | Anti-Revolutionary Party | Anti-Revolutionaire Partij | Anti-Revolutionaire Partij | chr | Christian democracy | 5.8067 | 5.6933 | 6.7724 | 8.2894 | 22523 | 1001 | 1001 | 8 | 300 | 3 | |||||
NLD | Netherlands | BBB | Farmer-Citizen Movement | BoerBurgerBeweging | BoerBurgerBeweging | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 8 | 2824 | 2 | ||||||||
NLD | Netherlands | BVL | League of Free Liberals | Bond van Vrije Liberalen | Bond van Vrije Liberalen | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 8 | 2459 | 6 | ||||||||
NLD | Netherlands | Bp | Farmers Party | Boerenpartij | Boerenpartij | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 8 | 1595 | 2 | ||||||||
NLD | Netherlands | CD | Centre Democrats | Centrum Democraten | Centrum Democraten | right | Right-wing | 9.4097 | 8.5714 | 9.25 | 1.312 | 2609 | 1009 | 1009 | 8 | 209 | 40 | |||||
NLD | Netherlands | CDA | Christian Democratic Appeal | Christen Democratisch Appèl | Christen Democratisch Appel | chr | Christian democracy | 5.9376 | 5.8848 | 6.6882 | 7.7157 | 22521 | 293 | 1528521 | 1106 | 2604 | 1001 | 7040 | 1001 | 8 | 235 | 3 |
NLD | Netherlands | CDU | Christian Democratic Union | Christelijk-Democratische Unie | Christelijk-Democratische Unie | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 8 | 2542 | 3 | ||||||||
NLD | Netherlands | CHU | Christian Historical Union | Christelijk-Historische Unie | Christelijk-Historische Unie | chr | Christian democracy | 5.8067 | 5.6933 | 6.7724 | 8.2894 | 22525 | 1001 | 1001 | 8 | 405 | 3 | |||||
NLD | Netherlands | CP | Centre Party | Centrumpartij | Centrumpartij | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 8 | 275 | 40 | ||||||||
NLD | Netherlands | CPN | Communist Party of the Netherlands | Communistische Partij Nederland | Communistische Partij Nederland | com | Communist/Socialist | 0.8 | 1.4 | 3.0 | 5.0 | 1102 | 1012 | 8 | 1194 | 14 | ||||||
NLD | Netherlands | CU | ChristianUnion | ChristenUnie | ChristenUnie | chr | Christian democracy | 6.1732 | 4.6769 | 8.6005 | 4.4157 | 22526 | 294 | 1528526 | 7060 | 1016 | 8 | 1206 | 3 | |||
NLD | Netherlands | D66 | Democrats 66 | Democraten 66 | Democraten 66 | lib | Liberal | 4.5066 | 4.9917 | 1.7625 | 8.6233 | 22330 | 295 | 1528330 | 1105 | 2603 | 1004 | 7080 | 1004 | 8 | 345 | 6 |
NLD | Netherlands | DENK | Think | Beweging DENK | Beweging DENK | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 8 | 2641 | 11 | ||||||||
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 | ||||||
NLD | Netherlands | EB | Economic League | Economische Bond | Economische Bond | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 8 | 2457 | 6 | ||||||||
NLD | Netherlands | EuTr | Europe Transparent | Europa Transparant | Europa Transparant | spec | Special issue | 8 | 339 | 16 | ||||||||||||
NLD | Netherlands | FvD | Forum for Democracy | Forum voor Democratie | Forum voor Democratie | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 8 | 2642 | 40 | ||||||||
NLD | Netherlands | GL | GreenLeft | GroenLinks | GroenLinks | eco | Green/Ecologist | 2.0454 | 2.1108 | 1.644 | 6.1973 | 22110 | 297 | 1528110 | 2601 | 1005 | 7100 | 1005 | 8 | 756 | 19 | |
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 | ||||
NLD | Netherlands | Groen | The Greens | De Groenen | De Groenen | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 8 | 2009 | 19 | ||||||||
NLD | Netherlands | HGS | New Reformed State Party | Hervormd Gereformeerde Staatspartij | Hervormd Gereformeerde Staatspartij | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 8 | 2464 | 3 | ||||||||
NLD | Netherlands | JA21 | Right Answer 2021 | Juiste Antwoord21 | Juiste Antwoord21 | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 8 | 2823 | 40 | ||||||||
NLD | Netherlands | KNP | Catholic National Party | Katholieke Nationale Partij | Katholieke Nationale Partij | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 8 | 3 | 3 | ||||||||
NLD | Netherlands | KVP | Catholic Peoples Party | Katholieke Volkspartij | Katholieke Volkspartij | chr | Christian democracy | 5.9473 | 5.8848 | 6.6882 | 7.7157 | 22522 | 1106 | 1001 | 7040 | 1001 | 8 | 451 | 3 | |||
NLD | Netherlands | LN | Livable Netherlands | Leefbaar Nederland | Leefbaar Nederland | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 22430 | 8 | 744 | 40 | |||||||
NLD | Netherlands | LPF | Fortuyn List | Lijst Pim Fortuyn | Lijst Pim Fortuyn | right | Right-wing | 8.5609 | 8.0776 | 4.7759 | 2.5798 | 22720 | 7120 | 1015 | 8 | 456 | 40 | |||||
NLD | Netherlands | LSP | Liberal State Party "The Freedom League" | Liberale Staatspartij "de Vrijheidsbond" | Liberale Staatspartij "de Vrijheidsbond" | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 8 | 2461 | 6 | ||||||||
NLD | Netherlands | LU | Liberal Union | Liberale Unie | Liberale Unie | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 8 | 2462 | 6 | ||||||||
NLD | Netherlands | MP | Middle Party | Midden Partij | Midden Partij | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 8 | 87 | 26 | ||||||||
NLD | Netherlands | MPSL | Middle Party for City and Country | Middenpartij voor Stad en Land | Middenpartij voor Stad en Land | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 8 | 2714 | 6 | ||||||||
NLD | Netherlands | NSB | National Socialist Movement in the Netherlands | Nationaal-Socialistische Beweging in Nederland | Nationaal-Socialistische Beweging in Nederland | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 8 | 2463 | 40 | ||||||||
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 | ||||||||
NLD | Netherlands | PPR | Radical Political Party | Politieke Partij Radikalen | Politieke Partij Radikalen | eco | Green/Ecologist | 1.6 | 2.5 | 1.8 | 5.0 | 22310 | 1103 | 1010 | 8 | 342 | 19 | |||||
NLD | Netherlands | PSP | Pacifist Socialist Party | Pacifistisch Socialistische Partij | Pacifistisch Socialistische Partij | com | Communist/Socialist | 0.6 | 1.4 | 3.0 | 5.0 | 1101 | 1011 | 8 | 1452 | 14 | ||||||
NLD | Netherlands | PVV | Party for Freedom | Partij voor de Vrijheid | Partij voor de Vrijheid | right | Right-wing | 8.8 | 8.29 | 6.57 | 0.9167 | 301 | 1528600 | 1017 | 8 | 1501 | 40 | |||||
NLD | Netherlands | PvdA | Labour Party | Partij van de Arbeid | Partij van de Arbeid | soc | Social democracy | 3.6118 | 3.868 | 3.2028 | 7.9904 | 22320 | 299 | 1528320 | 1104 | 2602 | 1002 | 7140 | 1002 | 8 | 742 | 11 |
NLD | Netherlands | PvdD | Party for the Animals | Partij voor de Dieren | Partij voor de Dieren | spec | Special issue | 300 | 1528006 | 1018 | 8 | 990 | 16 | |||||||||
NLD | Netherlands | RKP | Roman Catholic Party | Roomsch Katholieke Partij | Roomsch Katholieke Partij | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 8 | 2539 | 3 | ||||||||
NLD | Netherlands | RKVP | Roman Catholic People's Party | Roomsch-Katholieke Volkspartij | Roomsch-Katholieke Volkspartij | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 8 | 2466 | 3 | ||||||||
NLD | Netherlands | RPF | Reformatory Political Federation | Reformatorische Politieke Federati | Reformatorische Politieke Federati | chr | Christian democracy | 8.2963 | 6.0 | 8.5455 | 3.5447 | 1109 | 2608 | 1008 | 1008 | 8 | 212 | 3 | ||||
NLD | Netherlands | RSP | Revolutionary Socialist Party | Revolutionair Socialistische Partij | Revolutionair Socialistische Partij | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 8 | 2465 | 14 | ||||||||
NLD | Netherlands | S+G+R | Reformatory Political Federation / Reformed Political League / Political Reformed Party | Staatkundig Gereformeerde Partij / Gereformeerd Politiek Verbond / Reformatorische Politieke Federatie | Staatkundig Gereformeerde Partij / Gereformeerd Politiek Verbond / Reformatorische Politieke Federatie | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 8 | 1771 | 26 | ||||||||
NLD | Netherlands | SDAP | Social Democratic Workers' Party | Sociaal Democratische Arbeiders Partij | Sociaal Democratische Arbeiders Partij | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 8 | 1451 | 11 | ||||||||
NLD | Netherlands | SGP | Political Reformed Party | Staatkundig Gereformeerde Partij | Staatkundig Gereformeerde Partij | con | Conservative | 8.7531 | 6.3487 | 9.7744 | 2.9307 | 294 | 1528527 | 1110 | 2607 | 1006 | 7160 | 1019 | 8 | 1251 | 26 | |
NLD | Netherlands | SP | Socialist Party | Socialistiese Partij | Socialistiese Partij | com | Communist/Socialist | 1.3682 | 1.0421 | 4.2099 | 2.5049 | 22220 | 304 | 1528220 | 7180 | 1014 | 8 | 357 | 14 | |||
NLD | Netherlands | VDB | Free-thinking Democratic League | Vrijzinnig Democratische Bond | Vrijzinnig Democratische Bond | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 8 | 944 | 6 | ||||||||
NLD | Netherlands | VN | Volt Netherlands | Volt Nederland | Volt Nederland | spec | Special issue | 8 | 2735 | 16 | ||||||||||||
NLD | Netherlands | VVD | People's Party for Freedom and Democracy | Volkspartij voor Vrijheid en Democratie | Volkspartij voor Vrijheid en Democratie | lib | Liberal | 7.3482 | 7.8979 | 4.3887 | 5.9471 | 22420 | 305 | 1528420 | 1107 | 2605 | 1003 | 7200 | 1003 | 8 | 1409 | 6 |
NLD | Netherlands | no-seat | no seat | no seat | no seat | none | no family | 8 | 2110 | 12 | ||||||||||||
NLD | Netherlands | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 8 | 674 | 12 | ||||||||||||
NLD | Netherlands | one-seat | one seat | one seat | one seat | none | no family | 8 | 2288 | 12 | ||||||||||||
NOR | Norway | A | Teetotaler Party | Avholdspartiet | Avholdspartiet | spec | Special issue | 9 | 2544 | 16 | ||||||||||||
NOR | Norway | AD|DRF | Labour Democrats | Radical People's Party | Arbeiderdemokratene | Det radikale Folkeparti | Arbeiderdemokratene | Det radikale Folkeparti | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 9 | 2415 | 14 |
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;