view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
263 rows where family_name_short = "con" sorted by country_id
This data as json, CSV (advanced)
Suggested facets: ray
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 | HZD | Movement for Democracy | Hnutie za demokraciu | Hnutie za demokraciu | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 1 | 2160 | 26 | ||||||||
SVK | Slovakia | HZDS | Movement for a Democratic Slovakia | Hnutie za demokratické Slovensko | Hnutie za demokraticke Slovensko | con | Conservative | 4.8914 | 4.8199 | 5.9161 | 7.2855 | 96711 | 255 | 1703711 | 3403 | 3876 | 2801 | 1 | 1142 | 26 | ||
SVK | Slovakia | Lu+Ls | People's Union -- Liberal Party | Ludová únia – Liberálna strana | Ludova unia -- Liberalna strana | con | Conservative | 7.3684 | 5.2632 | 6.3158 | 9.4737 | 3954 | 1 | 1615 | 26 | |||||||
SVK | Slovakia | MH | Most-Hid | Most-Híd | Most-Hid | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 2813 | 1 | 1620 | 26 | |||||||
SVK | Slovakia | MK | Hungarian Coalition | Maďarskej koalície – Magyar koalíció | Ma'arskej koalicie -- Magyar koalicio | con | Conservative | 6.5005 | 6.0172 | 6.1761 | 9.3803 | 96952 | 259 | 1703954 | 4105 | 2804 | 1 | 559 | 26 | |||
SVK | Slovakia | OKS | Civic Conservative Party | Obcianska konzervatívna strana | Obcianska konzervatIvna strana | con | Conservative | 8.4211 | 8.4211 | 8.4211 | 2.6316 | 3977 | 1 | 1645 | 26 | |||||||
SVK | Slovakia | OLaNO | Ordinary People and Independent | Obyčajní ľudia a nezávislé osobnosti | Obycajni ludia a nezavisle osobnosti | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 1 | 1759 | 26 | ||||||||
SVK | Slovakia | S | Network | Sieť | Siet | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 1 | 2624 | 26 | ||||||||
SVK | Slovakia | S-E | Coexistence | Spolužitie – Együttélés | Spoluzitie -- Egyutteles | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 1 | 2248 | 26 | ||||||||
JPN | Japan | DP | Democratic Party | Minshutō | Minshuto | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 1734 | 26 | |||||||||
JPN | Japan | DPJ | Democratic Party of Japan | Minshutō | Minshuto | con | Conservative | 5.5717 | 5.06 | 4.1541 | 71624 | 8352 | 5 | 439 | 26 | |||||||
JPN | Japan | DPP | Democratic Party for the People | Kokumin Minshu-tō | Kokumin Minshu-to | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 2827 | 26 | |||||||||
JPN | Japan | JDP | Japan Democratic Party | Nihon Minshutō | Nihon Minshuto | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 1722 | 26 | |||||||||
JPN | Japan | JLP | Japan Liberal Party | Nihon Jiyūtō | Nihon Jiyuto | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 1726 | 26 | |||||||||
JPN | Japan | JRP | Japan Renewal Party | Shinseitō | Shinsei-to | con | Conservative | 8.2556 | 6.4 | 6.9 | 71622 | 2205 | 5 | 547 | 26 | |||||||
JPN | Japan | JReP | Japan Restoration Party | Nippon Ishin no Kai | Nippon Ishin no Kai | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 2136 | 26 | |||||||||
JPN | Japan | K | Komeito Party | Kōmeitō | Komeito | con | Conservative | 5.6871 | 4.4549 | 6.25 | 71530 | 2203 | 8400 | 5 | 837 | 26 | ||||||
JPN | Japan | LDP | Liberal Democratic Party | Jiyū Minshutō | Jiyu Minshuto | con | Conservative | 8.0252 | 4.8094 | 7.7747 | 71620 | 2205 | 8424 | 5 | 1193 | 26 | ||||||
JPN | Japan | LP | Liberal Party | Jiyū-tō | Jiyu-to | con | Conservative | 7.4 | 6.4 | 6.9 | 71625 | 5 | 462 | 26 | ||||||||
JPN | Japan | LP(H) | Liberal Party (Hatoyama) | Nihon Jiyūtō (Hatoyama) | Nihon Jiyuto (Hatoyama) | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 1755 | 26 | |||||||||
JPN | Japan | NCP | New Conservative Party | Hoshu Shintō | Hoshu Shinto | con | Conservative | 8.2675 | 5.6522 | 8.032 | 71626 | 8448 | 5 | 1382 | 26 | |||||||
JPN | Japan | NFP | New Frontier Party | Shinshin-to | Shinshin-to | con | Conservative | 8.2556 | 6.4 | 6.9 | 71623 | 2205 | 5 | 1136 | 26 | |||||||
JPN | Japan | NLC | New Liberal Club | Shin-jiyū-kurabu | Shin jiyu karuba | con | Conservative | 7.4 | 6.4 | 6.9 | 71621 | 5 | 170 | 26 | ||||||||
JPN | Japan | NPS | New Party Sakigake | Shinto Sakigake | Shinto Sakigake | con | Conservative | 7.4 | 6.4 | 6.9 | 71951 | 5 | 1146 | 26 | ||||||||
JPN | Japan | PH | Party of Hope | Kibō no Tō | Kibo no To | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 2656 | 26 | |||||||||
JPN | Japan | PLFP | People's Life First Party | Kokumin no Seikatsu ga Daiichi | Seikatsu no Tō | Kokumin no Seikatsu ga Daiichi | Seikatsu no To | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 2069 | 26 | |||||||||
JPN | Japan | PNP | People's New Party | Kokumin Shinto | Kokumin Shinto | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 4 | 26 | |||||||||
JPN | Japan | PR | Peace and Reform | Heiwa Kaikaku | Heiwa Kaikaku | con | Conservative | 7.4 | 6.4 | 6.9 | 5 | 2068 | 26 | |||||||||
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 | PD | Party of the Right | Rietspartei | Rietspartei | con | Conservative | 7.4 | 6.4 | 6.9 | 7 | 2527 | 26 | |||||||||
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 | |||||||||
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 | 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 | MP | Middle Party | Midden Partij | Midden Partij | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 8 | 87 | 26 | ||||||||
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 | 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 | |
NOR | Norway | D | Democrats | Demokratene | Demokratene | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 9 | 2816 | 26 | ||||||||
NOR | Norway | FeBo | Electoral lists Conservatives | Felleslister borgerlige | Felleslister borgerlige | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 9 | 2194 | 26 | ||||||||
NOR | Norway | H | Conservative Party | Høyre | Hoyre | con | Conservative | 7.8994 | 8.2957 | 3.584 | 9.5074 | 12620 | 1306 | 2908 | 1506 | 7524 | 3503 | 9 | 1435 | 26 | ||
NOR | Norway | Kp | Coastal Party | Kystpartiet | Kystpartiet | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 9 | 780 | 26 | ||||||||
BGR | Bulgaria | BBZ | Bulgaria Without Censorship | Balgarija bes Zensura | Balgarija bes Zensura | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2362 | 26 | ||||||||
BGR | Bulgaria | BNG | Bulgaria for Citizens Movement | Dvizhenie "Balgariya na grazhdanite" | Dvizhenie "Balgariya na grazhdanite" | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2213 | 26 | ||||||||
BGR | Bulgaria | BNS | Bulgarian People's Union | Balgarski Naroden Suyuz | Balgarski Naroden Suyuz | con | Conservative | 5.8 | 6.0 | 5.44 | 8.3333 | 80811 | 2009 | 10 | 1375 | 26 | ||||||
BGR | Bulgaria | BV | Bulgarian Rise | Balgarski vazhod | Balgarski vazhod | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2871 | 26 | ||||||||
BGR | Bulgaria | DSB|DB | Democrats for a Strong Bulgaria | Democratic Bulgaria | Demokrati za Silna Balgariya | Demokratichna Balgariya | Demokrati za Silna Balgariya | Demokratichna Balgariya | con | Conservative | 7.85 | 7.83 | 4.5 | 8.9667 | 28 | 1100001 | 2008 | 10 | 57 | 26 | |||||
BGR | Bulgaria | ITN | There Is Such a People | Ima takav narod | Ima takav narod | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2836 | 26 | ||||||||
BGR | Bulgaria | ODS | United Democratic Forces | Obedineni Demokratichni Sili | Obedineni Demokratichni Sili | con | Conservative | 6.9611 | 6.917 | 3.8431 | 9.7427 | 80411 | 706 | 972 | 2002 | 10 | 784 | 26 | ||||
BGR | Bulgaria | PS | Patriotic Union | Patriotichen Suyuz | Patriotichen Suyuz | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2177 | 26 | ||||||||
BGR | Bulgaria | RB | Reformist Bloc | Reformatorski Blok | Reformatorski Blok | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2363 | 26 | ||||||||
BGR | Bulgaria | RzB | Republicans for Bulgaria | Republikantsi za Balgariya | Republikantsi za Balgariya | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2814 | 26 | ||||||||
BGR | Bulgaria | SK | Blue Coalition | Sinyata Koalitsiya | Sinyata Koalitsiya | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 1100001 | 10 | 1254 | 26 | |||||||
BGR | Bulgaria | VMRO | IMRO -- Bulgarian National Movement | VMRO – Balgarsko Natsionalno Dvizhenie | VMRO -- Balgarsko Natsionalno Dvizhenie | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2212 | 26 | ||||||||
NZL | New Zealand | CP | Conservatice Party of New Zealand | Conservative Party of New Zealand | Conservative Party of New Zealand | con | Conservative | 7.4 | 6.4 | 6.9 | 11 | 1973 | 26 | |||||||||
NZL | New Zealand | NP | National Party | National Party | National Party | con | Conservative | 6.7193 | 7.2299 | 6.9 | 64620 | 1203 | 2704 | 7268 | 11 | 997 | 26 | |||||
NZL | New Zealand | NZFP | New Zealand First Party | New Zealand First Party | New Zealand First Party | con | Conservative | 6.0388 | 5.4386 | 6.9 | 64621 | 7284 | 11 | 891 | 26 | |||||||
NZL | New Zealand | RP | Reform Party | Reform Party | Reform Party | con | Conservative | 7.4 | 6.4 | 6.9 | 11 | 2471 | 26 | |||||||||
NZL | New Zealand | UNZ | United New Zealand | United New Zealand | United New Zealand | con | Conservative | 6.1219 | 6.3158 | 6.9 | 64421 | 7332 | 11 | 917 | 26 | |||||||
LTU | Lithuania | LiCS-TPP | United Faction of the Liberal and Centre Union and Nations Resurrection Party | Liberaly ir centro sąjunga ir Tautos prisikelimo partija | Liberaly ir centro sajunga ir Tautos prisikelimo partija | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 15 | 2007 | 26 | ||||||||
LTU | Lithuania | TS-LK | Homeland Union | Tėvynės sąjunga | Tevynes sajunga | con | Conservative | 7.4004 | 6.694 | 7.1939 | 9.7006 | 88620 | 209 | 1440620 | 2406 | 2404 | 2506 | 15 | 1045 | 26 | ||
LTU | Lithuania | TT-LDP | Order and Justice -- Liberal Democratic Party | Tvarka ir teisingumas – Liberalų demokratų partija | Tvarka ir teisingumas -- Liberalu demokratu partija | con | Conservative | 5.2955 | 4.9093 | 7.2116 | 7.3184 | 207 | 1440621 | 2236 | 2515 | 15 | 1421 | 26 | ||||
TUR | Turkey | AKP | Justice and Development Party | Adalet ve Kalkınma Partisi | Adalet ve Kalkinma Partisi | con | Conservative | 6.9873 | 3.797 | 8.499 | 8.6278 | 74622 | 306 | 8140 | 3401 | 20 | 901 | 26 | ||||
TUR | Turkey | ANAP | Motherland Party | Anavatan Partisi | Anavatan Partisi | con | Conservative | 6.213 | 5.7287 | 5.8991 | 9.2308 | 74623 | 4007 | 8162 | 20 | 1334 | 26 | |||||
TUR | Turkey | DTuP | Democratic Turkey Party | Democrat Türkiye Partisi | Democrat Turkiye Partisi | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 20 | 2315 | 26 | ||||||||
TUR | Turkey | DYP | Right Path Party | Doğru Yol Partisi | Dogru Yol Partisi | con | Conservative | 6.8239 | 5.2047 | 7.6316 | 6.7057 | 74624 | 4006 | 8250 | 3404 | 20 | 1141 | 26 | ||||
TUR | Turkey | SP | Felicity Party | Saadet Partisi | Saadet Partisi | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 316 | 20 | 1315 | 26 | |||||||
DNK | Denmark | CD | Centre Democrats | Centrumdemokraterne | Centrumdemokraterne | con | Conservative | 5.5609 | 4.8029 | 4.9307 | 9.1468 | 13330 | 506 | 1105 | 204 | 5477 | 204 | 21 | 1324 | 26 | ||
DNK | Denmark | FF | People's Party (Faroe Islands) | Hin føroyski fólkaflokkurin – radikalt sjálvstýri | Hin foroyski folkaflokkurin -- radikalt sjalvstyri | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 21 | 2574 | 26 | ||||||||
DNK | Denmark | KF | Conservatives | Konservative | Konservative | con | Conservative | 7.2186 | 7.2931 | 6.5055 | 7.7791 | 13620 | 66 | 1208620 | 509 | 1107 | 203 | 5549 | 203 | 21 | 590 | 26 |
DNK | Denmark | NS | National Cooperation | National Samvirke | National Samvirke | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 21 | 2431 | 26 | ||||||||
DNK | Denmark | Sbf | Union Party (Faroe Islands) | Sambandsflokkurin | Sambandsflokkurin | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 21 | 1892 | 26 | ||||||||
ROU | Romania | PAR | Alternative Party of Romania | Partidul Alternativa României | Partidul Alternativa Romaniei | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 23 | 2087 | 26 | ||||||||
ROU | Romania | PIN | National Initiative Party | Partidul Iniţiativa Naţională | Partidul Initiativa Nationala | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 23 | 1589 | 26 | ||||||||
ROU | Romania | PNL-CD | National Liberal Party -- Democratic Convention | Partidul Naţional Liberal – Convenţia Democrată | Partidul National Liberal -- Conventia Democratica | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 23 | 2088 | 26 | ||||||||
ROU | Romania | PU|PC | Humanist Party | Conservative Party | Partidul Umanist | Partidul Conservator | Partidul Umanist | Partidul Conservator | con | Conservative | 4.7622 | 4.7538 | 6.2779 | 8.2028 | 1642600 | 3356 | 2702 | 23 | 5 | 26 | |||||
ROU | Romania | UDMR | Democratic Union of Hungarians in Romania | Uniunea Democrată Maghiară din România | Uniunea Democratica Maghiara din Romania | con | Conservative | 6.016 | 5.9825 | 3.8813 | 9.4801 | 93951 | 253 | 1642900 | 3382 | 2706 | 23 | 948 | 26 | |||
ITA | Italy | AN | National Alliance | Alleanza Nazionale | Alleanza Nazionale | con | Conservative | 8.0871 | 4.9559 | 8.8366 | 4.3389 | 32710 | 805 | 6606 | 805 | 26 | 373 | 26 | ||||
ITA | Italy | CeD | Centre Right | Centro-destra | Centro-destra | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 32629 | 26 | 67 | 26 | |||||||
ITA | Italy | FI-PdL | Go Italy -- The People of Freedom | Forza Italia – Il Popolo della Libertà | Forza Italia -- Il Popolo della Liberta | con | Conservative | 7.1459 | 7.913 | 6.5983 | 5.0946 | 32610 | 186 | 1380630 | 816 | 6646 | 815 | 26 | 596 | 26 | ||
ITA | Italy | FLI | Future and Freedom for Italy | Futuro e libertà per l'Italia | Futuro e liberta per l'Italia | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 26 | 1477 | 26 | ||||||||
ITA | Italy | FUQ | Front of the Ordinary Man | Fronte dell'Uomo Qualunque | Fronte dell'Uomo Qualunque | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 26 | 409 | 26 | ||||||||
ITA | Italy | Italexit | Italexit for Italy | Italext per l'Italia | Italexit per l'Italia | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 26 | 2873 | 26 | ||||||||
ITA | Italy | NCD | New Centre-Right | Popular Alternative | Nuovo Centrodestra | Alternativa Popolare | Nuovo Centrodestra | Alternativa Popolare | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 26 | 2268 | 26 | ||||||||
ITA | Italy | PDIUM | Italian Democratic Party of Monarchist Unity | Partito Democratico Italiano di Unità Monarchica | Partito Democratico Italiano di Unita Monarchica | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 26 | 1702 | 26 | ||||||||
ITA | Italy | PMP | Popular Monarchist Party | Partito Monarchico Popolare | Partito Monarchico Popolare | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 26 | 421 | 26 | ||||||||
ITA | Italy | USEI | South American Union Italian Emigrants | Unione Sudamericana Emigrati Italiani | Unione Sudamericana Emigrati Italiani | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 26 | 2671 | 26 | ||||||||
ESP | Spain | AP-P | People's Alliance-Party | Alianza-Partido Popular | Alianza-Partido Popular | con | Conservative | 7.5969 | 7.619 | 7.8127 | 7.7368 | 33610 | 274 | 1724610 | 1412 | 3608 | 502 | 7800 | 502 | 27 | 645 | 26 |
ESP | Spain | CDC|JxCat | Democratic Convergence | Together for Catalonia | Convergència Democràtica | Junts per Catalunya | Convergencia Democratica | Junts per Catalunya | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 27 | 2605 | 26 | ||||||||
ESP | Spain | CiU | Convergence and Union | Convergència i Unió | Convergencia i Unio | con | Conservative | 6.2564 | 6.3998 | 6.1104 | 8.7309 | 33611 | 357 | 1724007 | 1408 | 3607 | 505 | 7740 | 505 | 27 | 894 | 26 |
ESP | Spain | NA+ | Sum Navarre | Navarra Suma | Navarra Suma | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 27 | 2723 | 26 | ||||||||
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 | 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 | 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 | 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 | |||||||
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 | C | Coalition | Coalition | Coalition | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 1428 | 26 | |||||||||
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 | 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 | FFP | Family First Party | Family First Party | Family First Party | con | Conservative | 7.4 | 6.4 | 6.9 | 33 | 446 | 26 | |||||||||
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 |
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;