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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
NOR | Norway | D | Democrats | Demokratene | Demokratene | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 9 | 2816 | 26 | ||||||||
NOR | Norway | DLF | Liberal People's Party | Det Liberale Folkepartiet | Det Liberale Folkepartiet | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 12410 | 9 | 1209 | 6 | |||||||
NOR | Norway | DNA | Norwegian Labour Party | Det norske Arbeiderparti | Det norske Arbeiderparti | soc | Social democracy | 3.3706 | 2.9574 | 2.7105 | 8.2933 | 12320 | 1302 | 2903 | 1503 | 7488 | 3501 | 9 | 104 | 11 | ||
NOR | Norway | FV | Liberal Left Party | Frisinnede Venstre | Frisinnede Venstre | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 9 | 2472 | 6 | ||||||||
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 | Fr | Progress Party | Fremskrittspartiet | Fremskrittspartiet | right | Right-wing | 8.7595 | 7.5 | 5.5388 | 6.119 | 12951 | 1307 | 2909 | 1507 | 7506 | 3502 | 9 | 351 | 40 | ||
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 | Hf | Resistance Movement | Hjemmefronten | Hjemmefronten | spec | Special issue | 9 | 17 | 16 | ||||||||||||
NOR | Norway | Kp | Coastal Party | Kystpartiet | Kystpartiet | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 9 | 780 | 26 | ||||||||
NOR | Norway | KrF | Christian Democratic Party | Kristelig Folkeparti | Kristelig Folkeparti | chr | Christian democracy | 5.8516 | 4.5865 | 9.198 | 3.1003 | 12520 | 1305 | 2907 | 1505 | 7542 | 3506 | 9 | 1538 | 3 | ||
NOR | Norway | MDG | Green Party | Miljøpartiet De Grønne | Miljopartiet De Gronne | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 9 | 2254 | 19 | ||||||||
NOR | Norway | MV | Moderate Liberal Party | Moderate Venstre | Moderate Venstre | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 9 | 2473 | 6 | ||||||||
NOR | Norway | NKP | Communist Party of Norway | Norges Kommunistiske Parti | Norges Kommunistiske Parti | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 0.0 | 12220 | 1501 | 9 | 27 | 14 | ||||||
NOR | Norway | NS | National Gathering | Nasjonal Samling | Nasjonal Samling | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 9 | 2414 | 40 | ||||||||
NOR | Norway | NSA | Social Democratic Labour Party of Norway | Norges Socialdemokratiske Arbeiderparti | Norges Socialdemokratiske Arbeiderparti | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 9 | 2474 | 11 | ||||||||
NOR | Norway | P | Pensioners Party | Pensjonistpartiet | Pensjonistpartiet | spec | Special issue | 9 | 733 | 16 | ||||||||||||
NOR | Norway | RV | Red Electoral Alliance | Rød Valgallianse | Rod Valgallianse | com | Communist/Socialist | 0.4089 | 0.5764 | 1.0 | 0.4511 | 2901 | 7560 | 9 | 1638 | 14 | ||||||
NOR | Norway | SF | Socialist People's Party | Sosialistisk Folkeparti | Sosialistisk Folkeparti | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 12221 | 9 | 1773 | 14 | |||||||
NOR | Norway | SV | Socialist Left Party | Sosialistisk Venstreparti | Sosialistisk Venstreparti | com | Communist/Socialist | 1.5839 | 1.3534 | 1.5038 | 1.1568 | 12221 | 1301 | 2902 | 1502 | 7578 | 3504 | 9 | 81 | 14 | ||
NOR | Norway | Soc | Society Party | Samfundspartiet | Samfundspartiet | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 9 | 2420 | 3 | ||||||||
NOR | Norway | Sp | Centre Party | Senterpartiet | Senterpartiet | agr | Agrarian | 4.6565 | 2.807 | 5.7644 | 0.188 | 12810 | 1304 | 2904 | 1504 | 7596 | 3505 | 9 | 702 | 2 | ||
NOR | Norway | V | Liberal Party of Norway | Venstre | Venstre | lib | Liberal | 5.1467 | 5.9148 | 3.2581 | 4.0766 | 12420 | 1303 | 2906 | 1508 | 7614 | 3507 | 9 | 647 | 6 | ||
NOR | Norway | etc | others | others | others | none | no family | 9 | 2578 | 12 | ||||||||||||
NOR | Norway | no-seat | no seat | no seat | no seat | none | no family | 9 | 2100 | 12 | ||||||||||||
NOR | Norway | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 9 | 793 | 12 | ||||||||||||
NOR | Norway | one-seat | one seat | one seat | one seat | none | no family | 9 | 474 | 12 | ||||||||||||
BGR | Bulgaria | ABV | Alternative for Bulgarian Revival | Alternativa za balgarsko vazrazhdane | Alternativa za balgarsko vazrazhdane | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2364 | 11 | ||||||||
BGR | Bulgaria | Ataka | Attack | Ataka | Ataka | right | Right-wing | 5.46 | 3.25 | 9.17 | 2.4333 | 27 | 1100700 | 2007 | 10 | 535 | 40 | |||||
BGR | Bulgaria | BBB | Bulgarian Business Bloc | Balgarski Biznes Blok | Balgarski Biznes Blok | lib | Liberal | 6.6784 | 7.076 | 5.1974 | 7.6842 | 80901 | 708 | 737 | 10 | 599 | 6 | |||||
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 | BE | Euro-Left Coalition | Balgarska Evrolevica | Balgarska Evrolevica | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 80320 | 10 | 710 | 11 | |||||||
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 | BNO|BN | Bulgarian National Unification | Bulgarian Summer | Bŭlgarsko natsionalno obedinenie | Balgarsko lyato | Bulgarsko natsionalno obedinenie | Balgarsko lyato | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 2840 | 40 | ||||||||
BGR | Bulgaria | BNRP | Bulgarian National Radical Party | Balgarska Natsionalnoradikalna Partiya | Balgarska Natsionalnoradikalna Partiya | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 364 | 40 | ||||||||
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 | BSP | Bulgarian Socialist Party | Balgarska Sotsialisticheska Partiya | Balgarska Potsialisticheska Partiya | soc | Social democracy | 3.0064 | 2.9187 | 4.5029 | 8.1871 | 80220 | 26 | 1100300 | 702 | 841 | 10 | 982 | 11 | |||
BGR | Bulgaria | BV | Bulgarian Rise | Balgarski vazhod | Balgarski vazhod | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2871 | 26 | ||||||||
BGR | Bulgaria | BZNS-NP | Bulgarian Agrarian National Union -- "Nikola Petkov" | Balgarski Zemedelski Naroden Suyuz – "Nikola Petkov" | Balgarski Zemedelski Naroden Suyuz -- "Nikola Petkov" | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 10 | 2173 | 2 | ||||||||
BGR | Bulgaria | CSD | Centre -- Freedom and Dignity | Tsentŭr – Svoboda i dostoĭnstvo | Center -- Svoboda i dostojnstvo | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2595 | 6 | ||||||||
BGR | Bulgaria | D21 | Movement 21 | Dvizhenie 21 | Dvizhenie 21 | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2379 | 11 | ||||||||
BGR | Bulgaria | DAR | Democratic Alternative for the Republic | Demokratichna Alternativa za Republikata | Demokratichna Alternativa za Republikata | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2170 | 11 | ||||||||
BGR | Bulgaria | DG | George's Day Movement | Dvizhenie Gergyovden | Dvizhenie Gergyovden | right | Right-wing | 6.3158 | 6.1053 | 2.8289 | 8.3158 | 920 | 10 | 1362 | 40 | |||||||
BGR | Bulgaria | DOST | Democrats for Responsibility, Solidarity and Tolerance | Demokrati za Otgovornost, Svoboda i Tolerantnost | Demokrati za Otgovornost, Svoboda i Tolerantnost | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2639 | 6 | ||||||||
BGR | Bulgaria | DP | Democratic Party | Demokraticheska Partiya | Demokraticheska Partiya | chr | Christian democracy | 9.4444 | 5.7 | 7.1 | 8.3 | 709 | 10 | 542 | 3 | |||||||
BGR | Bulgaria | DPS | Movement for Rights and Freedoms | Dvizhenie za Prava i Svobodi | Dvizhenie za Prava i Svobodi | lib | Liberal | 4.5828 | 4.413 | 6.229 | 9.0094 | 80951 | 31 | 1100900 | 894 | 2004 | 10 | 1286 | 6 | |||
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 | DaB | Yes, Bulgaria! | Da Bulgaria! | Da Bulgaria! | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2638 | 6 | ||||||||
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 | GERB | Citizens for European Development of Bulgaria | Grazhdani za Evropeysko Razvitie na Balgariya | Grazhdani za Evropeysko Razvitie na Balgariya | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 29 | 1100600 | 2010 | 10 | 1541 | 40 | |||||
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 | IS | Stand up! | Izpravi se! | Izpravi se! | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2838 | 11 | ||||||||
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 | KPB | Communist Party of Bulgaria | Komunisticheska Partiya na Balgariya | Komunisticheska Partiya na Balgariya | com | Communist/Socialist | 0.3684 | 1.7368 | 7.8289 | 2.8655 | 701 | 763 | 10 | 1570 | 14 | ||||||
BGR | Bulgaria | KR | Coalition of the Rose | Koalitsiya na Rozata | Koalitsiya na Rozata | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2179 | 11 | ||||||||
BGR | Bulgaria | KSII | Simeon II Coalition | Koalitsiya Simeon II | Koalitsiya Simeon II | spec | Special issue | 6.86 | 6.29 | 6.33 | 7.7833 | 2006 | 10 | 15 | 16 | |||||||
BGR | Bulgaria | KzB|DL | Coalition for Bulgaria | Democratic Left | Koalitsiya za Balgariya | Demokratichna Levitsa | Koalitsiya za Balgariya | Demokratichna Levitsa | soc | Social democracy | 2.8982 | 2.9629 | 5.741 | 8.6402 | 80221 | 1100300 | 702 | 841 | 2003 | 10 | 1160 | 11 | |||
BGR | Bulgaria | Lider | Lider | Lider | Lider | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 2011 | 10 | 566 | 6 | |||||||
BGR | Bulgaria | NDSV | National Movement Simeon II | Natsionalno Dvizhenie Simeon Vtori | Natsionalno Dvizhenie Simeon Vtori | lib | Liberal | 5.7567 | 5.8948 | 4.008 | 9.3468 | 80902 | 32 | 1100400 | 946 | 2001 | 10 | 544 | 6 | |||
BGR | Bulgaria | NFSB | National Front for the Salvation of Bulgaria | Natsionalen Front za Spasenie na Balgariya | Natsionalen Front za Spasenie na Balgariya | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 2211 | 40 | ||||||||
BGR | Bulgaria | NV | New Times | Novoto vreme | Novoto vreme | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 10 | 2180 | 19 | ||||||||
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 | 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 | PBSD | Party of Bulgarian Social Democrats | Partiya Balgarski Sotsialdemokrati | Partiya Balgarski Sotsialdemokrati | soc | Social democracy | 3.7778 | 4.6316 | 3.4211 | 9.0 | 703 | 815 | 10 | 1161 | 11 | ||||||
BGR | Bulgaria | PKE | Political Club "Ecoglasnost" | Politicheski Klub "Ekoglasnost" | Politicheski Klub "Ekoglasnost" | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 80110 | 10 | 1548 | 19 | |||||||
BGR | Bulgaria | PP | We Continue the Change | Prodalzhavame promyanata | Prodalzhavame promyanata | spec | Special issue | 10 | 2847 | 16 | ||||||||||||
BGR | Bulgaria | PS | Patriotic Union | Patriotichen Suyuz | Patriotichen Suyuz | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2177 | 26 | ||||||||
BGR | Bulgaria | R | Revival | Vazrazhdane | Vazrazhdane | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 2640 | 40 | ||||||||
BGR | Bulgaria | RB | Reformist Bloc | Reformatorski Blok | Reformatorski Blok | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 10 | 2363 | 26 | ||||||||
BGR | Bulgaria | RZS | Order, Lawfulness and Justice | Red, zakonnost i spravedlivost | Red, zakonnost i spravedlivost | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 1100601 | 2012 | 10 | 636 | 40 | ||||||
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 | SDS | Union of Democratic Forces | Suyuz na Demokratichnite Sili | Suyuz na Demokratichnite Sili | chr | Christian democracy | 6.1111 | 5.7 | 7.1 | 8.3 | 80410 | 33 | 707 | 10 | 423 | 3 | |||||
BGR | Bulgaria | SDS-l | Union of Democratic Forces -- Liberal | Suyuz na Demokratichnite Sili – Liberali | Suyuz na Demokratichnite Sili -- Liberali | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2175 | 6 | ||||||||
BGR | Bulgaria | SDS-ts | Union of Democratic Forces -- Centre | Suyuz na Demokratichnite Sili – Tsentur | Suyuz na Demokratichnite Sili -- Tsentur | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 10 | 2174 | 11 | ||||||||
BGR | Bulgaria | SEK | Middle European Class | Sredna evropeĭska klasa | Sredna evropeiska klasa | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2870 | 6 | ||||||||
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 | SNI | "New Choice" Union | Suyuz "Nov izbor" | Suyuz "Nov izbor" | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2176 | 6 | ||||||||
BGR | Bulgaria | VB | Volt Bulgaria | Volt Bulgaria | Volt Bulgaria | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 10 | 2869 | 6 | ||||||||
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 | ||||||||
BGR | Bulgaria | Volya | Will | Volya | Volya | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 10 | 2637 | 40 | ||||||||
BGR | Bulgaria | ZNS | Agrarian People's Union | Zemedelski Naroden Suyuz | Zemedelski Naroden Suyuz | agr | Agrarian | 5.5263 | 5.7895 | 5.9398 | 8.9474 | 80810 | 704 | 867 | 10 | 353 | 2 | |||||
BGR | Bulgaria | ZP | Green Party of Bulgaria | Zelena Partiya | Zelena Partija | eco | Green/Ecologist | 5.5556 | 2.5 | 1.8 | 6.5 | 705 | 10 | 963 | 19 | |||||||
BGR | Bulgaria | ZS-AS | Agrarian Union "Aleksandar Stamboliyski" | Zemedelski Suyuz "Aleksandar Stamboliyski" | Zemedelski Suyuz "Aleksandar Stamboliyski" | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 80812 | 10 | 529 | 2 | |||||||
BGR | Bulgaria | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 10 | 133 | 12 | ||||||||||||
NZL | New Zealand | A | Alliance | Alliance | Alliance | soc | Social democracy | 2.0757 | 1.1111 | 3.5 | 64321 | 2702 | 7236 | 11 | 1444 | 11 | ||||||
NZL | New Zealand | ACT | ACT New Zealand | ACT New Zealand | ACT New Zealand | lib | Liberal | 9.0263 | 8.9751 | 3.6 | 64420 | 7220 | 11 | 617 | 6 | |||||||
NZL | New Zealand | ALCP | Aotearoa Legalise Cannabis Party | Aotearoa Legalise Cannabis Party | Aotearoa Legalise Cannabis Party | spec | Special issue | 11 | 2073 | 16 | ||||||||||||
NZL | New Zealand | CD/FNZ | Christian Democrat Party / Future New Zealand | Christian Democrat Party / Future New Zealand | Christian Democrat Party / Future New Zealand | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 11 | 774 | 3 | |||||||||
NZL | New Zealand | CH | Christian Heritage Party of New Zealand | Christian Heritage Party of New Zealand | Christian Heritage Party of New Zealand | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 11 | 2072 | 3 | |||||||||
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 | CPNZ | Communist Party of New Zealand | Communist Party of New Zealand | Communist Party of New Zealand | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 11 | 2076 | 14 | |||||||||
NZL | New Zealand | CouPa | Country Party | Country Party | Country Party | agr | Agrarian | 5.3 | 4.9 | 6.5 | 11 | 2467 | 2 | |||||||||
NZL | New Zealand | DLP | Democratic Labour Party | Democratic Labour Party | Democratic Labour Party | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 11 | 1968 | 14 | |||||||||
NZL | New Zealand | DP | Democrat Party | Democrat Party | Democrat Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 11 | 2468 | 6 | |||||||||
NZL | New Zealand | Greens | Green Party | Green Party | Green Party | eco | Green/Ecologist | 1.7729 | 2.2438 | 1.8 | 64110 | 7252 | 11 | 1171 | 19 | |||||||
NZL | New Zealand | LP | Labour Party | Labour Party | Labour Party | soc | Social democracy | 4.483 | 3.9889 | 3.5 | 64320 | 1201 | 2703 | 7300 | 11 | 878 | 11 | |||||
NZL | New Zealand | MP | Maori Party | Māori Party | Maori Party | spec | Special issue | 64951 | 11 | 114 | 16 | |||||||||||
NZL | New Zealand | Mana | Mana Party | Mana Party | Mana Party | spec | Special issue | 11 | 1972 | 16 | ||||||||||||
NZL | New Zealand | NC | New Conservative Party | New Conservative Party | New Conservative Party | right | Right-wing | 8.8 | 5.9 | 8.5 | 11 | 2806 | 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;