view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by eu_anti_pro
This data as json, CSV (advanced)
Suggested facets: family_name_short, family_name
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | 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 | AG | Australian Greens | Australian Greens | Australian Greens | eco | Green/Ecologist | 1.5439 | 1.2982 | 0.5614 | 4739 | 33 | 751 | 19 | ||||||||
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 | 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 | 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 | 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 | 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 | 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 | DU | The Independents -- Lugner's List | Die Unabhängigen – Liste Lugner | Die Unabhaengigen -- Liste Lugner | spec | Special issue | 59 | 1745 | 16 | ||||||||||||
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 | 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 | N | Citizens' Initiative for the retention of neutrality | Die Neutralen – Bürgerinitiative | Die Neutralen -- Buergerinitiative | spec | Special issue | 59 | 1750 | 16 | ||||||||||||
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 | T | Czechoslovakians | Tschechoslowaken | Tschechoslowaken | spec | Special issue | 59 | 2689 | 16 | ||||||||||||
AUT | Austria | etc | others | others | others | none | no family | 59 | 2687 | 12 | ||||||||||||
AUT | Austria | no-seat | no seat | no seat | no seat | none | no family | 59 | 2055 | 12 | ||||||||||||
AUT | Austria | none | no party affiliation | Parteilose | Parteilose | none | no family | 59 | 272 | 12 | ||||||||||||
AUT | Austria | one-seat | one-seat | one-seat | one-seat | none | no family | 59 | 2686 | 12 | ||||||||||||
BEL | Belgium | UDB | Belgian Democratic Union | Union Democratique Belge | Union Democratique Belge | code | to be coded | 64 | 1181 | 28 | ||||||||||||
BEL | Belgium | etc | others | others | others | none | no family | 64 | 2488 | 12 | ||||||||||||
BEL | Belgium | no-seat | no seat | no seat | no seat | none | no family | 64 | 2052 | 12 | ||||||||||||
BEL | Belgium | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 64 | 1458 | 12 | ||||||||||||
BEL | Belgium | one-seat | one seat | one seat | one seat | none | no family | 64 | 2300 | 12 | ||||||||||||
BGR | Bulgaria | ER | Euroroma | Evroroma | Evroroma | spec | Special issue | 10 | 2178 | 16 | ||||||||||||
BGR | Bulgaria | FTB | Kingdom of Bulgaria Confederation | Federatsiya Tsarstvo Balgariya | Federatsiya Tsarstvo Balgariya | spec | Special issue | 10 | 800 | 16 | ||||||||||||
BGR | Bulgaria | GN | People's Voice | Glas Naroden | Glas Naroden | spec | Special issue | 10 | 2214 | 16 | ||||||||||||
BGR | Bulgaria | I-MK | Independent -- Mincho Kuminev | Independent – Mincho Kuminev | Independent -- Mincho Kuminev | none | no family | 10 | 2774 | 12 | ||||||||||||
BGR | Bulgaria | OT-SII | Union for Tzar [Simeon II] | Obedinenie za Tsar [Simeon II] | Obedinenie za Tsar [Simeon II] | spec | Special issue | 10 | 1149 | 16 | ||||||||||||
BGR | Bulgaria | PP | We Continue the Change | Prodalzhavame promyanata | Prodalzhavame promyanata | spec | Special issue | 10 | 2847 | 16 | ||||||||||||
BGR | Bulgaria | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 10 | 133 | 12 | ||||||||||||
CAN | Canada | BPC | Bloc Populaire Canadien | Bloc Populaire Canadien | Bloc Populaire Canadien | spec | Special issue | 29 | 1307 | 16 | ||||||||||||
CAN | Canada | BQ | Quebec Bloc | Bloc Québécois | Bloc Quebecois | soc | Social democracy | 3.0215 | 3.1207 | 2.2063 | 62901 | 802 | 5213 | 29 | 448 | 11 | ||||||
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 | |||||
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 | ||||||||
CAN | Canada | CP|LPP | Communist (Labour-Progressive) Party | Communist (Labour-Progressive) Party | Communist (Labour-Progressive) Party | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 29 | 556 | 14 | |||||||||
CAN | Canada | GPC | Green Party of Canada | Green Party of Canada | Green Party of Canada | eco | Green/Ecologist | 1.9018 | 2.2467 | 2.0327 | 5253 | 29 | 1259 | 19 | ||||||||
CAN | Canada | L | Labour Party | Labour Party | Labour Party | soc | Social democracy | 3.3 | 3.5 | 3.5 | 29 | 2427 | 11 | |||||||||
CAN | Canada | L-P | Liberal-Progressive | Liberal-Progressive | Liberal-Progressive | lib | Liberal | 6.0 | 6.7 | 3.6 | 29 | 2011 | 6 | |||||||||
CAN | Canada | LL | Liberal-Labour | Liberal-Labour | Liberal-Labour | lib | Liberal | 6.0 | 6.7 | 3.6 | 29 | 2085 | 6 | |||||||||
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 | NPC | National Party of Canada | National Party of Canada | National Party of Canada | soc | Social democracy | 3.3 | 3.5 | 3.5 | 29 | 2142 | 11 | |||||||||
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 | PPC | People's Party of Canada | People's Party of Canada | People's Party of Canada | right | Right-wing | 8.8 | 5.9 | 8.5 | 29 | 2791 | 40 | |||||||||
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 | |||||||||
CAN | Canada | PR | Rhinoceros Party | Parti Rhinoceros | Parti Rhinoceros | spec | Special issue | 29 | 2148 | 16 | ||||||||||||
CAN | Canada | RP | Reconstruction Party of Canada | Reconstruction Party of Canada | Reconstruction Party of Canada | con | Conservative | 7.4 | 6.4 | 6.9 | 29 | 2565 | 26 | |||||||||
CAN | Canada | RPC | Reform Party of Canada | Reform Party of Canada | Reform Party of Canada | con | Conservative | 8.7748 | 8.7668 | 9.0688 | 62621 | 805 | 5233 | 29 | 897 | 26 | ||||||
CAN | Canada | SCR | Social Credit Rally | Ralliement créditiste | Ralliement creditiste | spec | Special issue | 29 | 677 | 16 | ||||||||||||
CAN | Canada | SSC | Social Credit Party of Canada | Social Credit Party of Canada | Social Credit Party of Canada | con | Conservative | 7.8 | 6.4 | 6.9 | 62951 | 404 | 29 | 1392 | 26 | |||||||
CAN | Canada | UE | Union of Electors | Union [Candidats] des électeurs | Union [Candidats] des electeurs | spec | Special issue | 29 | 2162 | 16 | ||||||||||||
CAN | Canada | etc | others | others | others | none | no family | 29 | 2577 | 12 | ||||||||||||
CAN | Canada | no-seat | no seat | no seat | no seat | none | no family | 29 | 2067 | 12 | ||||||||||||
CAN | Canada | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 29 | 1189 | 12 | ||||||||||||
CHE | Switzerland | EJ | Agreement Jura | Entente jurassienne | Entente jurassienne | code | to be coded | 40 | 1964 | 28 | ||||||||||||
CHE | Switzerland | KHM | Committee Herbert Maeder | Komitee Herbert Maeder | Komitee Herbert Maeder | none | no family | 40 | 1967 | 12 | ||||||||||||
CHE | Switzerland | etc | others | others | others | none | no family | 40 | 2579 | 12 | ||||||||||||
CHE | Switzerland | none | no party affiliation | parteilos | parteilos | none | no family | 40 | 1211 | 12 | ||||||||||||
CHE | Switzerland | one-seat | one seat | one seat | one seat | none | no family | 40 | 2303 | 12 | ||||||||||||
CYP | Cyprus | ADISOK | Democratic Socialist Renewal Movement | Anorthotiko Dimokratiko Sosialistiko Kinima | Anorthotiko Dimokratiko Sosialistiko Kinima | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 51 | 1779 | 14 | |||||||||
CYP | Cyprus | ADK | Fighting Democratic Movement | Agonistiko Dimokratiko Kinima | Agonistiko Dimokratiko Kinima | right | Right-wing | 7.7632 | 5.2632 | 5.0 | 5333 | 51 | 1049 | 40 |
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;