view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by castles_mair descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CAN | Canada | PCP | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | con | Conservative | 6.7112 | 6.9659 | 5.997 | 62620 | 403 | 804 | 5313 | 29 | 794 | 26 | |||||
CAN | Canada | LP | Liberal Party of Canada | Liberal Party of Canada | Liberal Party of Canada | lib | Liberal | 5.0552 | 5.3509 | 3.4615 | 62420 | 402 | 803 | 5273 | 29 | 368 | 6 | |||||
CAN | Canada | CCF|NDP | Co-operative Commonwealth Federation | New Democratic Party | Co-operative Commonwealth Federation | New Democratic Party | Co-operative Commonwealth Federation | New Democratic Party | soc | Social democracy | 2.46 | 1.9195 | 1.1134 | 62320 | 401 | 801 | 5293 | 29 | 296 | 11 | |||||
BEL | Belgium | VB | Flemish Block | Flemish Interest | Vlaams Blok | Vlaams Belang | Vlaams Blok | Vlaams Belang | right | Right-wing | 9.6622 | 7.695 | 9.5234 | 2.756 | 21914 | 19 | 1056711 | 313 | 112 | 5063 | 112 | 64 | 993 | 40 | |
BEL | Belgium | RvA-UpD | Respect for Labour | Respect voor Arbeid en Democratie – Union pour la Democratie et le Respect du Travail | Respect voor Arbeid en Democratie -- Union pour la Democratie et le Respect du Travail | right | Right-wing | 9.2 | 5.9 | 8.5 | 2.3 | 312 | 64 | 1440 | 40 | |||||||
BEL | Belgium | PVV|VLD | Party of Liberty and Progress | Flemish Liberals and Democrats | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten | lib | Liberal | 7.0053 | 7.7639 | 3.7139 | 8.7549 | 21421 | 16 | 1056421 | 311 | 106 | 5083 | 107 | 64 | 1110 | 6 | |
BEL | Belgium | MR | Reformist Movement | Mouvement Réformateur | Mouvement Reformateur | lib | Liberal | 6.6889 | 7.1934 | 4.2102 | 8.3003 | 21422 | 22 | 1056427 | 310 | 4983 | 106 | 64 | 915 | 6 | ||
BEL | Belgium | PRL | Liberal Reformist Party | Parti Réformateur Libéral | Parti Reformateur Liberal | lib | Liberal | 6.8551 | 7.2667 | 4.4381 | 9.0856 | 21422 | 310 | 409 | 107 | 106 | 64 | 454 | 6 | |||
BEL | Belgium | N-VA | New Flemish Alliance | Nieuw-Vlaamse Alliantie | Nieuw-Vlaamse Alliantie | con | Conservative | 6.5321 | 5.8809 | 6.06 | 6.4243 | 21913 | 15 | 1056913 | 309 | 407 | 110 | 5003 | 110 | 64 | 501 | 26 |
BEL | Belgium | VU | People's Union | Volksunie | Volksunie | right | Right-wing | 6.5321 | 5.8809 | 6.06 | 6.4243 | 21913 | 309 | 407 | 110 | 5003 | 110 | 64 | 290 | 40 | ||
BEL | Belgium | PSC-CDH | Francophone Christian Social Party -- Humanist Democratic Centre | Parti Social Chrétien – Centre Democrate Humaniste | Parti Social Chretien -- Centre Democrate Humaniste | chr | Christian democracy | 5.4974 | 5.3711 | 6.6409 | 8.7795 | 21522 | 21 | 1056522 | 308 | 405 | 108 | 4903 | 108 | 64 | 1192 | 3 |
BEL | Belgium | CVP|CD&V | Flemish Christian Peoples Party | Christian Democrats & Flemish | Christelijke Volkspartij | Christen-Democratisch en Vlaams | Christelijke Volkspartij | Christen-Democratisch en Vlaams | chr | Christian democracy | 5.7667 | 5.5876 | 7.2083 | 8.9013 | 21521 | 12 | 1056521 | 307 | 406 | 109 | 4883 | 109 | 64 | 723 | 3 |
BEL | Belgium | FDF | Francophone Democratic Front | Front Démocratique des Francophones | DéFI | Front Democratique des Francophones | lib | Liberal | 6.1259 | 6.25 | 5.8 | 8.7274 | 21912 | 306 | 408 | 111 | 111 | 64 | 969 | 6 | |||
BEL | Belgium | AGL-Gr | Agalev -- Green | Agalev – Groen | Agalev -- Groen | eco | Green/Ecologist | 2.5762 | 2.0089 | 1.0234 | 7.2593 | 21112 | 13 | 1056112 | 305 | 401 | 105 | 4963 | 105 | 64 | 1594 | 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 |
BEL | Belgium | SP | Socialist Party | Socialistische Partij | Socialistische Partij | soc | Social democracy | 3.2459 | 3.0183 | 3.0805 | 7.9023 | 21321 | 18 | 1056327 | 304 | 404 | 103 | 5043 | 103 | 64 | 1029 | 11 |
BEL | Belgium | RW | Walloon Rally | Rassemblement Wallon | Rassemblement Wallon | soc | Social democracy | 2.6 | 3.5 | 3.5 | 8.1 | 21911 | 303 | 64 | 460 | 11 | ||||||
BEL | Belgium | BSP-PSB | Belgian Socialist Party | Belgische Socialistische Partij – Parti Socialiste Belge | Belgische Socialistische Partij -- Parti Socialiste Belge | soc | Social democracy | 2.5 | 3.5 | 3.5 | 8.1 | 21320 | 302 | 64 | 167 | 11 | ||||||
BEL | Belgium | PS | Socialist Party [Francophone] | Parti Socialiste | Parti Socialiste | soc | Social democracy | 2.9307 | 2.5938 | 3.1712 | 8.1465 | 21322 | 24 | 1056322 | 302 | 403 | 102 | 5023 | 102 | 64 | 1378 | 11 |
BEL | Belgium | KPB-PCB | Communist Party | Kommunistische Partij – Parti Communiste | Kommunistische Partij -- Parti Communiste | com | Communist/Socialist | 1.4 | 1.4 | 3.0 | 4.45 | 301 | 101 | 64 | 708 | 14 | ||||||
AUT | Austria | FPO | Freedom Party of Austria | Freiheitliche Partei Österreichs | Freiheitliche Partei Oesterreichs | right | Right-wing | 8.3494 | 6.3291 | 8.5149 | 1.9815 | 42420 | 10 | 1040420 | 204 | 311 | 1303 | 4811 | 1303 | 59 | 50 | 40 |
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 |
AUT | Austria | SPO | Social Democratic Party of Austria | Sozialdemokratische Partei Österreichs | Sozialdemokratische Partei Oesterreichs | soc | Social democracy | 3.7293 | 3.4728 | 3.4766 | 8.4495 | 42320 | 11 | 1040320 | 202 | 308 | 1301 | 4865 | 1301 | 59 | 973 | 11 |
AUT | Austria | KPO | Communist Party of Austria | Kommunistische Partei Österreichs | Kommunistische Partei Oesterreichs | com | Communist/Socialist | 0.5 | 1.4 | 3.0 | 0.0 | 42220 | 3 | 1040220 | 201 | 1305 | 59 | 769 | 14 | |||
AUS | Australia | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | con | Conservative | 7.8222 | 6.2456 | 8.4561 | 63810 | 104 | 206 | 4775 | 33 | 184 | 26 | |||||
AUS | Australia | LPA | Liberal Party of Australia | Liberal Party of Australia | Liberal Party of Australia | con | Conservative | 7.3903 | 8.4211 | 6.9825 | 63620 | 103 | 205 | 4757 | 33 | 1411 | 26 | |||||
AUS | Australia | AD | Australian Democrats | Australian Democrats | Australian Democrats | soc | Social democracy | 3.7004 | 3.3684 | 1.1579 | 63321 | 102 | 203 | 4703 | 33 | 120 | 11 | |||||
AUS | Australia | ALP | Australian Labor Party | Australian Labor Party | Australian Labor Party | soc | Social democracy | 3.8833 | 4.0351 | 3.2632 | 63320 | 101 | 4721 | 33 | 1253 | 11 | ||||||
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 | |||||||||
AUS | Australia | AG | Australian Greens | Australian Greens | Australian Greens | eco | Green/Ecologist | 1.5439 | 1.2982 | 0.5614 | 4739 | 33 | 751 | 19 | ||||||||
AUS | Australia | AP | Australia Party | Australia Party | Australia Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1760 | 6 | |||||||||
AUS | Australia | C | Coalition | Coalition | Coalition | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1428 | 26 | |||||||||
AUS | Australia | CDP | Christian Democratic Party | Christian Democratic Party | Christian Democratic Party | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 33 | 1650 | 3 | |||||||||
AUS | Australia | CLP | Commonwealth Liberal Party | Commonwealth Liberal Party | Commonwealth Liberal Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 2285 | 26 | |||||||||
AUS | Australia | CPA | Communist Party of Australia | Communist Party of Australia | Communist Party of Australia | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 33 | 1922 | 14 | |||||||||
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 | |||||||||
AUS | Australia | CouLP | Country Liberal Party | Country Liberal Party | Country Liberal Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 215 | 6 | |||||||||
AUS | Australia | DLP | Democratic Labour Party | Democratic Labour Party | Democratic Labour Party | soc | Social democracy | 4.1667 | 3.5 | 3.5 | 63330 | 204 | 33 | 1306 | 11 | |||||||
AUS | Australia | EC-SA | Emergency Committee (SA) | Emergency Committee (SA) | Emergency Committee (SA) | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1904 | 6 | |||||||||
AUS | Australia | FFP | Family First Party | Family First Party | Family First Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 446 | 26 | |||||||||
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 | FTP | Free Trade Party | Free Trade Party | Free Trade Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1938 | 6 | |||||||||
AUS | Australia | INAT | Independet Nationalist | Independet Nationalist | Independet Nationalist | code | to be coded | 33 | 1903 | 28 | ||||||||||||
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 | |||||||||
AUS | Australia | IUAP-NSW | Independent UAP (NSW) | Independent UAP (NSW) | Independent UAP (NSW) | none | no family | 33 | 1941 | 12 | ||||||||||||
AUS | Australia | Katter | Katter's Australian Party | Katter's Australian Party | Katter's Australian Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 33 | 2258 | 11 | |||||||||
AUS | Australia | LCL | Liberal and Country League | Liberal and Country League | Liberal and Country League | soc | Social democracy | 3.3 | 3.5 | 3.5 | 33 | 1919 | 11 | |||||||||
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 | LD-NSW | Liberal Democratic Party (New South Wales) | Liberal Democratic Party (New South Wales) | Liberal Democratic Party (New South Wales) | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1927 | 6 | |||||||||
AUS | Australia | LLP | Lang Labour Party | Lang Labour Party | Lang Labour Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 33 | 303 | 11 | |||||||||
AUS | Australia | LNPQ | Liberal National Party of Queensland | Liberal National Party of Queensland | Liberal National Party of Queensland | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 154 | 6 | |||||||||
AUS | Australia | LP | Liberal Party | Liberal Party | Liberal Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 2286 | 26 | |||||||||
AUS | Australia | NAT | Nationalist Party of Australia | Nationalist Party of Australia | Nationalist Party of Australia | right | Right-wing | 8.8 | 5.9 | 8.5 | 33 | 1905 | 40 | |||||||||
AUS | Australia | NAT-WA | Nationalist | Nationalist | Nationalist | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1925 | 26 | |||||||||
AUS | Australia | NF-NSW | Nationalist and Farmers (NSW) | Nationalist and Farmers (NSW) | Nationalist and Farmers (NSW) | code | to be coded | 33 | 1918 | 28 | ||||||||||||
AUS | Australia | NL | National Labor | National Labor | National Labor | soc | Social democracy | 3.3 | 3.5 | 3.5 | 33 | 2003 | 11 | |||||||||
AUS | Australia | NXT | Nick Xenophon Team | Nick Xenophon Team | Nick Xenophon Team | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 2630 | 6 | |||||||||
AUS | Australia | ONP | One Nation Party | One Nation Party | One Nation Party | right | Right-wing | 8.1579 | 5.3008 | 7.9649 | 4793 | 33 | 386 | 40 | ||||||||
AUS | Australia | OPA | One Parliament for Australia | One Parliament for Australia | One Parliament for Australia | code | to be coded | 33 | 1936 | 28 | ||||||||||||
AUS | Australia | PP | Protectionist Party | Protectionist Party | Protectionist Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1898 | 26 | |||||||||
AUS | Australia | PUP | Palmer United Party | Palmer United Party | Palmer United Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 2259 | 6 | |||||||||
AUS | Australia | QC | Queensland Country Party | Queensland Country Party | Queensland Country Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1928 | 26 | |||||||||
AUS | Australia | SCP | Social Credit Party | Social Credit Party | Social Credit Party | spec | Special issue | 33 | 1911 | 16 | ||||||||||||
AUS | Australia | SL-NSW | State Labor Party (NSW) | State Labor Party (NSW) | State Labor Party (NSW) | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 33 | 1908 | 14 | |||||||||
AUS | Australia | SPA | Services Party of Australia | Services Party of Australia | Services Party of Australia | code | to be coded | 33 | 1897 | 28 | ||||||||||||
AUS | Australia | UAP | United Australia Party | United Australia Party | United Australia Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1912 | 26 | |||||||||
AUS | Australia | VCP | Victorian Country Party | Victorian Country Party | Victorian Country Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1920 | 26 | |||||||||
AUS | Australia | VFU-V | Victorian Farmers' Union | Victorian Farmers' Union | Victorian Farmers' Union | agr | Agrarian | 5.3 | 4.9 | 6.5 | 33 | 1929 | 2 | |||||||||
AUS | Australia | WAP | Western Australian Party | Western Australian Party | Western Australian Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 33 | 1906 | 6 | |||||||||
AUS | Australia | no-seat | no seat | no seat | no seat | none | no family | 33 | 2057 | 12 | ||||||||||||
AUS | Australia | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 33 | 1396 | 12 | ||||||||||||
AUS | Australia | one-seat | one seat | one seat | one seat | none | no family | 33 | 2299 | 12 | ||||||||||||
AUT | Austria | ALO | Alternative List Austria | Alternative Liste Österreichs | Alternative Liste Oesterreichs | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 59 | 1739 | 19 | ||||||||
AUT | Austria | BD | Centrist Democrats | Bürgerliche Demokraten | Buergerliche Demokraten | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 59 | 2688 | 6 | ||||||||
AUT | Austria | BZO | Alliance for the Future of Austria | Bündnis Zukunft Österreich | Buendnis Zukunft Oesterreich | right | Right-wing | 8.83 | 6.0 | 8.83 | 2.5 | 8 | 1040600 | 1307 | 59 | 1536 | 40 | |||||
AUT | Austria | CSA | Christian Social Alliance (Karl Habsburg List) | Christlich Soziale Allianz (Liste Karl Habsburg) | Christlich Soziale Allianz (Liste Karl Habsburg) | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 59 | 1752 | 3 | ||||||||
AUT | Austria | DD | German-Democrats | Deutschdemokraten | Deutschdemokraten | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 59 | 2675 | 6 | ||||||||
AUT | Austria | DFP | Democratic Progressive Party | Demokratische Fortschrittliche Partei | Demokratische Fortschrittliche Partei | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 59 | 1743 | 40 | ||||||||
AUT | Austria | DNP | German-Nationals | Deutschnationale | Deutschnationale | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 59 | 2672 | 26 | ||||||||
AUT | Austria | DNSAP | National Socialist Workers' Party | Nationalsozialistische Arbeiterpartei | Nationalsozialistische Arbeiterpartei | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 59 | 2684 | 40 | ||||||||
AUT | Austria | DU | The Independents -- Lugner's List | Die Unabhängigen – Liste Lugner | Die Unabhaengigen -- Liste Lugner | spec | Special issue | 59 | 1745 | 16 | ||||||||||||
AUT | Austria | DVP | German People's Party | Deutsche Volkspartei | Deutsche Volkspartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 59 | 2673 | 26 | ||||||||
AUT | Austria | EU-STOP | EU Withdrawal, Direct Democracy, Neutrality | EU-Austritt, Direkte Demokratie, Neutralität | EU-Austritt, Direkte Demokratie, Neutralitaet | spec | Special issue | 59 | 2340 | 16 | ||||||||||||
AUT | Austria | Fritz | The Citizens' Forum Austria | Bürgerforum Österreich – Liste Fritz Dinkhauser | Buergerforum Oesterreich -- Liste Fritz Dinkhauser | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 59 | 1746 | 11 | ||||||||
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 | ||||||||
AUT | Austria | GFOP | German Freedom and Order Party | Deutsche Freiheits und Ordnungspartei | Deutsche Freiheits und Ordnungspartei | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 59 | 2676 | 40 | ||||||||
AUT | Austria | GILT | My Vote Counts! | Liste Roland Düringer – Meine Stimme GILT | Liste Roland Dueringer -- Meine Stimme GILT | spec | Special issue | 59 | 2652 | 16 | ||||||||||||
AUT | Austria | Gruene | The Greens -- The Green Alternative | Die Grünen – Die Grüne Alternative | Die Gruenen -- Die Gruene Alternative | eco | Green/Ecologist | 2.4604 | 2.7489 | 1.4308 | 6.6845 | 42110 | 9 | 1040110 | 307 | 1304 | 4829 | 1304 | 59 | 1429 | 19 | |
AUT | Austria | HB | Homeland Block | Heimatblock | Heimatblock | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 59 | 2685 | 40 | ||||||||
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 | L | Rural Federation | Landbund für Österreich | Landbund fuer Oesterreich | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 59 | 2681 | 40 | ||||||||
AUT | Austria | LIF | Liberal Forum | Liberales Forum | Liberales Forum | lib | Liberal | 4.8806 | 7.3667 | 1.8667 | 9.6125 | 42421 | 1040422 | 310 | 1306 | 1306 | 59 | 955 | 6 | |||
AUT | Austria | Martin | Hans-Peter Martin's List | Liste Dr. Hans-Peter Martin | Liste Dr. Hans-Peter Martin | spec | Special issue | 4.2 | 5.0 | 3.4 | 2.85 | 1040951 | 1308 | 59 | 669 | 16 | ||||||
AUT | Austria | N | Citizens' Initiative for the retention of neutrality | Die Neutralen – Bürgerinitiative | Die Neutralen -- Buergerinitiative | spec | Special issue | 59 | 1750 | 16 | ||||||||||||
AUT | Austria | NDP | National Democratic Party | Nationaldemokratische Partei | Nationaldemokratische Partei | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 59 | 2679 | 40 | ||||||||
AUT | Austria | NEOS | NEOS -- The New Austria | NEOS – Das Neue Österreich | NEOS -- Das Neue Oesterreich | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 59 | 2255 | 6 | ||||||||
AUT | Austria | Nein | No -- Citizens' Initiative against EU membership | Nein – Bürgerinitiative gegen die EU Mitgliedschaft | Nein -- Buergerinitiative gegen die EU Mitgliedschaft | spec | Special issue | 59 | 1744 | 16 | ||||||||||||
AUT | Austria | PILZ | JETZT -- Pilz List | JETZT – Liste Pilz | JETZT -- Liste Pilz | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 59 | 2651 | 19 | ||||||||
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 | ||||||||
AUT | Austria | SBP | Styrian Farmers' Party | Steirische Bauernpartei | Steirische Bauernpartei | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 59 | 2677 | 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;