view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
1,699 rows sorted by country_id descending
This data as json, CSV (advanced)
Suggested facets: family_name_short, family_name, family_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EST | Estonia | E200 | Estonia 200 | Erakond Eesti 200 | Erakond Eesti 200 | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 75 | 2720 | 6 | ||||||||
EST | Estonia | EEE | Estonian Entrepreneur Party | Eesti Ettevõtjate Erakond | Eesti Ettevotjate Erakond | lib | Liberal | 8.3333 | 6.7 | 3.6 | 8.7 | 1211 | 75 | 1516 | 6 | |||||||
EST | Estonia | EER | Estonian Greens | Erakond Eestimaa Rohelised | Erakond Eestimaa Rohelised | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 79 | 1233100 | 2207 | 75 | 219 | 19 | |||||
EST | Estonia | EER-91 | Estonian Greens -- 1991 | Eesti Rohelised – 1991 | Eesti Rohelised -- 1991 | eco | Green/Ecologist | 5.5556 | 2.5 | 1.8 | 6.5 | 1206 | 75 | 2631 | 19 | |||||||
EST | Estonia | EK | Estonian Centre Party | Eesti Keskerakond | Eesti Keskerakond | soc | Social democracy | 3.9562 | 3.6421 | 4.9947 | 5.0118 | 83411 | 75 | 1233411 | 1204 | 1716 | 2202 | 75 | 1137 | 11 | ||
EST | Estonia | EKD | Estonian Christian Democrats | Eesti Kristlikud Demokraadid | Eesti Kristlikud Demokraadid | chr | Christian democracy | 7.5789 | 4.7368 | 9.7895 | 1.0526 | 76 | 1612 | 75 | 609 | 3 | ||||||
EST | Estonia | EKK | Estonian Coalition Party | Eesti Koonderakond | Eesti Koonderakond | lib | Liberal | 7.2222 | 6.7 | 3.6 | 8.7 | 83713 | 1209 | 75 | 486 | 6 | ||||||
EST | Estonia | EKo | Estonian Citizens | Eesti Kodanik | Eesti Kodanik | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 83712 | 75 | 1064 | 40 | |||||||
EST | Estonia | ELE | Richness of Life | Elurikkuse Erakond | Elurikkuse Erakond | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 75 | 2721 | 19 | ||||||||
EST | Estonia | EM | Estonian Country Union | Eesti Maaliit | Eesti Maaliit | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 75 | 2403 | 2 | ||||||||
EST | Estonia | EMK | Estonian Rural Centre Party | Eesti Maa-Keskerakond | Eesti Maa-Keskerakond | agr | Agrarian | 5.5556 | 4.9 | 6.5 | 5.4 | 1207 | 75 | 1257 | 2 | |||||||
EST | Estonia | EPL | Estonian Pensioners' Union | Eesti Pensionaride Liit | Eesti Pensionaride Liit | spec | Special issue | 75 | 1792 | 16 | ||||||||||||
EST | Estonia | EPPE | Estonian Party of Pensioners and Families | Eesti Pensionäride ja Perede Erakond | Eesti Pensionaride ja Perede Erakond | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 75 | 2402 | 2 | ||||||||
EST | Estonia | ERP | Res Publica Party | Erakond Res Publica | Erakond Res Publica | con | Conservative | 8.4962 | 8.2456 | 6.1053 | 9.2632 | 83611 | 1820 | 75 | 428 | 26 | ||||||
EST | Estonia | ERSP | Estonian National Independence Party | Eesti Rahvusliku Sõltumatuse Partei | Eesti Rahvusliku Soltumatuse Partei | con | Conservative | 7.7778 | 6.4 | 6.9 | 7.9 | 83711 | 1210 | 75 | 552 | 26 | ||||||
EST | Estonia | ERa/EKR | People's Union of Estonia / Conservative People's Party | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond | con | Conservative | 4.5812 | 4.8509 | 6.9474 | 6.0627 | 83612 | 78 | 1233612 | 1768 | 2206 | 75 | 417 | 26 | |||
EST | Estonia | ERe | Estonian Reform Party | Eesti Reformierakond | Eesti Reformierakond | lib | Liberal | 7.8969 | 8.6246 | 5.2737 | 8.5715 | 83430 | 82 | 1233430 | 1208 | 1794 | 2203 | 75 | 113 | 6 | ||
EST | Estonia | ESE-D | Estonian Blue Party -- Democrats | Eesti Sinine Erakond – Demokraadid | Eesti Sinine Erakond -- Demokraadid | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 75 | 2267 | 6 | ||||||||
EST | Estonia | ETE | Estonian Farmers Party | Eesti Talurahva Erakond | Eesti Talurahva Erakond | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 75 | 1796 | 2 | ||||||||
EST | Estonia | EV | Free Party | Eesti Vabaerakond | Eesti Vabaerakond | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 75 | 2409 | 26 | ||||||||
EST | Estonia | EVP | Estonian Left Party | Eesti Vasakpartei | Eesti Vasakpartei | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 75 | 2416 | 14 | ||||||||
EST | Estonia | I | Pro Patria Union | Isamaaliit | Isamaaliit | con | Conservative | 7.6169 | 6.414 | 7.3789 | 8.5189 | 83710 | 1212 | 1690 | 2201 | 75 | 846 | 26 | ||||
EST | Estonia | I-DK | Independent -- Dimitri Klenski | Independent – Dimitri Klenski | Independent -- Dimitri Klenski | none | no family | 75 | 2031 | 12 | ||||||||||||
EST | Estonia | I-IT | Independent -- Indrek Tarand | Independent – Indrek Tarand | Independent -- Indrek Tarand | none | no family | 75 | 2029 | 12 | ||||||||||||
EST | Estonia | I-MH | Independent -- Martin Helme | Independent – Martin Helme | Independent -- Martin Helme | none | no family | 75 | 2030 | 12 | ||||||||||||
EST | Estonia | I-RK | Independent -- Raimond Kaljulaid | Independent – Raimond Kaljulaid | Independent -- Raimond Kaljulaid | none | no family | 75 | 2738 | 12 | ||||||||||||
EST | Estonia | I-SM | Independent -- Silver Meikar | Independent – Silver Meikar | Independent -- Silver Meikar | none | no family | 75 | 2345 | 12 | ||||||||||||
EST | Estonia | I-TT | Independent -- Tanel Talve | Independent – Tanel Talve | Independent -- Tanel Talve | none | no family | 75 | 2344 | 12 | ||||||||||||
EST | Estonia | IRL | Union of Pro Patria and Res Publica | Erakond Isamaa ja Res Publica Liit | Erakond Isamaa ja Res Publica Liit | con | Conservative | 8.4962 | 8.2456 | 6.1053 | 9.2632 | 83611 | 80 | 1233613 | 1820 | 75 | 1597 | 26 | ||||
EST | Estonia | K-EUR | Constitution Party -- Estonian United People's Party | Konstitutsioonierakond – Eestimaa Ühendatud Rahvapartei | Konstitutsioonierakond -- Eestimaa Uehendatud Rahvapartei | soc | Social democracy | 2.0282 | 2.9413 | 6.3158 | 4.9241 | 83952 | 1201 | 1664 | 2205 | 75 | 1590 | 11 | ||||
EST | Estonia | PK | Union of Farmers | Põllumeeste Kogu | Pollumeeste Kogu | agr | Agrarian | 2.2222 | 4.9 | 6.5 | 5.4 | 1203 | 75 | 1553 | 2 | |||||||
EST | Estonia | R | Popular Front | Rahvarinne | Rahvarinne | soc | Social democracy | 3.3333 | 3.5 | 3.5 | 8.1 | 83421 | 1204 | 75 | 450 | 11 | ||||||
EST | Estonia | RKI | National Coalition Party "Pro Patria" | Rahvuslik Koonderakond "Isamaa" | Rahvuslik Koonderakond "Isamaa" | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 83710 | 75 | 243 | 26 | |||||||
EST | Estonia | SDE|M | Social Democratic Party | Moderates | Sotsiaaldemokraatlik Erakond | Mõõdukad | Sotsiaaldemokraatlik Erakond | Moodukad | soc | Social democracy | 4.1915 | 3.4667 | 3.1737 | 7.7982 | 83410 | 83 | 1233410 | 1205 | 1742 | 2204 | 75 | 1448 | 11 | ||
EST | Estonia | SK | Independent Royalists | Sõltumatud Kuningriiklased | Soltumatud Kuningriiklased | spec | Special issue | 83901 | 75 | 25 | 16 | |||||||||||
EST | Estonia | TEE | Future Estonia | Independence | Tuleviku Eesti | Iseseisvuspartei | Tuleviku Eesti | Iseseisvuspartei | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 75 | 1794 | 40 | ||||||||
EST | Estonia | VEE | Russian Party in Estonia | Vene Erakond Eestis | Vene Erakond Eestis | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 75 | 2266 | 26 | ||||||||
EST | Estonia | VKR | People's Party of Republicans and Conservatives | Vabariiklaste ja Konservatiivide Rahvaerakond | Vabariiklaste ja Konservatiivide Rahvaerakond | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 83610 | 75 | 1395 | 26 | |||||||
EST | Estonia | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 75 | 426 | 12 | ||||||||||||
POL | Poland | AWS | Solidarity Electoral Action | Akcja Wyborcza Solidarność Prawicy | Akcja Wyborcza Solidarnosc Prawicy | chr | Christian democracy | 7.1286 | 4.6148 | 8.1427 | 7.0491 | 92620 | 2928 | 2608 | 74 | 1355 | 3 | |||||
POL | Poland | BBWR | Non-Party Block for Supporting the Reforms | Bezpartyjny Blok Wspierania Reform | Bezpartyjny Blok Wspierania Reform | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 92901 | 74 | 1019 | 3 | |||||||
POL | Poland | ChD | Christian Democracy | Chrześcijańska Demokracja | Chrzescijanska Demokracja | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 92520 | 74 | 334 | 3 | |||||||
POL | Poland | D|W|U | Democratic | Freedom | Union | Demokratyczna | Wolności | Unia | Demokratyczna | Wolnosci | Unia | lib | Liberal | 5.2295 | 7.3132 | 2.1208 | 9.7641 | 92434 | 3180 | 2609 | 74 | 1104 | 6 | |||||
POL | Poland | IdP | Initiative for Poland | Inicjatywa dla Polski | Inicjatywa dla Polski | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 74 | 1680 | 26 | ||||||||
POL | Poland | K | Kukiz'15 | Kukiz'15 | Kukiz'15 | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 74 | 2600 | 40 | ||||||||
POL | Poland | KLD | Liberal Democratic Congress | Kongres Liberalno-Demokratyczny | Kongres Liberalno-Demokratyczny | lib | Liberal | 5.2778 | 6.7 | 3.6 | 8.7 | 92420 | 3004 | 74 | 1544 | 6 | ||||||
POL | Poland | KORWIN | Coalition for the Renewal of the Republic -- Liberty and Hope | Koalicja Odnowy Rzeczypospolitej Wolność i Nadzieja KORWiN | Koalicja Odnowy Rzeczypospolitej Wolnosc i Nadzieja KORWIN | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 74 | 2602 | 26 | ||||||||
POL | Poland | KPEiR | National Party of Pensioners and Retired | Krajowa Partia Emerytów i Rencistów | Krajowa Partia Emerytow i Rencistow | spec | Special issue | 74 | 109 | 16 | ||||||||||||
POL | Poland | KPEiR-RP | National Agreement of Pensioners and Retired of the Republic Poland | Krajowe Porozumienie Emerytów i Rencistów Rzeczypospolitej Polskiej | Krajowe Porozumienie Emerytow i Rencistow Rzeczypospolitej Polskiej | spec | Special issue | 74 | 1275 | 16 | ||||||||||||
POL | Poland | KPN | Confederation for Independent Poland | Konfederacja Polski Niepodległej | Konfederacja Polski Niepodleglej | right | Right-wing | 5.8333 | 5.9 | 8.5 | 2.3 | 92710 | 3006 | 74 | 548 | 40 | ||||||
POL | Poland | LP | Libertas Poland | Libertas Polska | Libertas Polska | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 1616010 | 74 | 1671 | 26 | |||||||
POL | Poland | LPR | League of Polish Families | Liga Polskich Rodzin | Liga Polskich Rodzin | con | Conservative | 8.8852 | 2.3257 | 9.7522 | 0.2933 | 92713 | 385 | 2954 | 2607 | 74 | 987 | 26 | ||||
POL | Poland | LR | Left Together | Lewica Razem | Lewica Razem | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 74 | 2790 | 11 | ||||||||
POL | Poland | LiD | Left and Democrats | Lewica i Demokraci | Lewica i Demokraci | soc | Social democracy | 2.6486 | 2.6316 | 2.1902 | 9.1283 | 3102 | 74 | 180 | 11 | |||||||
POL | Poland | MN | German minority | Mniejszość niemiecka w Polsce | Mniejszosc niemiecka | spec | Special issue | 92953 | 74 | 900 | 16 | |||||||||||
POL | Poland | N | Modern | Nowoczesna | Nowoczesna | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 74 | 2601 | 6 | ||||||||
POL | Poland | NCD-BdP | National Christian Democratic -- Block for Poland | Narodowo Chrześcijańsko Demokratyczny – Blok dla Polski | Narodowo Chrzescijansko Demokratyczny -- Blok dla Polski | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 74 | 1712 | 3 | ||||||||
POL | Poland | NKWW | National Voters Committee | Narodowy Komitet Wyborczy Wyborców | Narodowy Komitet Wyborczy Wyborcow | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 74 | 1678 | 3 | ||||||||
POL | Poland | PC | Centre Agreement | Porozumienie Centrum | Porozumienie Centrum | chr | Christian democracy | 5.5556 | 5.7 | 7.1 | 8.3 | 92521 | 3005 | 74 | 369 | 3 | ||||||
POL | Poland | PCD | Party of Christian Democrats | Partia Chrześcijańskich Demokratów | Partia Chrzescijanskich Demokratow | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 92522 | 74 | 696 | 3 | |||||||
POL | Poland | PL | Peasants Agreement | Porozumenie Ludowe | Porozumenie Ludowe | agr | Agrarian | 3.3333 | 4.9 | 6.5 | 5.4 | 92810 | 3002 | 74 | 619 | 2 | ||||||
POL | Poland | PO | Civic Platform | Platforma Obywatelska | Platforma Obywatelska | con | Conservative | 6.2355 | 8.236 | 3.7102 | 9.3705 | 92435 | 228 | 1616435 | 2980 | 2603 | 74 | 512 | 26 | |||
POL | Poland | PPG | Polish Economic Program [Large Beer] | Polski Program Gospodarczy [Duże Piwo] | Polski Program Gospodarczy [Duze Piwo] | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 92433 | 74 | 1691 | 6 | |||||||
POL | Poland | PR|A | Poland Together | Agreement | Polska Razem | Porozumienie | Polska Razem | Porozumienie | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 74 | 2331 | 26 | ||||||||
POL | Poland | PSL | Polish People's Party | Polskie Stronnictwo Ludowe | Polskie Stronnictwo Ludowe | agr | Agrarian | 4.1856 | 2.8942 | 6.5491 | 5.3573 | 92811 | 229 | 1616811 | 3002 | 3006 | 2606 | 74 | 664 | 2 | ||
POL | Poland | PZ | The Greens | Partia Zieloni | Partia Zieloni | eco | Green/Ecologist | 2.5 | 2.5 | 1.8 | 6.5 | 74 | 2778 | 19 | ||||||||
POL | Poland | PZPR | Polish United Workers' Party | Polska Zjednoczone Partia Robotnicza | Polska Zjednoczone Partia Robotnicza | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 74 | 1077 | 14 | ||||||||
POL | Poland | PZZ | Polish Western Union | Polski Związek Zachodni | Polski Zwiazek Zachodni | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 92711 | 74 | 1074 | 14 | |||||||
POL | Poland | PiS | Law and Justice | Prawo i Sprawiedliwość | Prawo i Sprawiedliwosc | con | Conservative | 7.6997 | 4.0466 | 8.2514 | 5.4813 | 92436 | 230 | 1616436 | 3032 | 2605 | 74 | 528 | 26 | |||
POL | Poland | PjN | Poland is the Most Important | Polska jest Najważniejsza | Polska jest Najwazniejsza | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 74 | 1679 | 26 | ||||||||
POL | Poland | PrRz | Republic Right Party | Prawica Rzeczypospolitej | Prawica Rzeczypospolitej | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 355 | 74 | 1283 | 26 | |||||||
POL | Poland | RAS | Movement for Silesian Autonomy | Ruch Autonomii Śląska | Ruch Autonomii Slaska | spec | Special issue | 92952 | 74 | 1208 | 16 | |||||||||||
POL | Poland | RKN | Catholic-National Movement | Ruch Katolicko-Narodowy | Ruch Katolicko-Narodowy | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 74 | 322 | 40 | ||||||||
POL | Poland | RN | National Movement | Ruch Narodowy | Ruch Narodowy | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 74 | 2398 | 40 | ||||||||
POL | Poland | ROP | Movement for the Reconstruction of Poland | Ruch Odbudowy Polski | Ruch Odbudowy Polski | con | Conservative | 5.7895 | 5.2632 | 6.9 | 2.6316 | 92621 | 3058 | 74 | 148 | 26 | ||||||
POL | Poland | RP | Your (Palikot's) Movement | Twój Ruch (Palikota) | Twoj Ruch (Palikota) | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 74 | 1945 | 6 | ||||||||
POL | Poland | Razem | Together Party | Partia Razem | Partia Razem | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 74 | 2625 | 11 | ||||||||
POL | Poland | RdR | Movement for the Republic | Ruch dla Rzeczypospolitej | Ruch dla Rzeczypospolitej | chr | Christian democracy | 6.2 | 5.7 | 7.1 | 8.3 | 92523 | 74 | 1710 | 3 | |||||||
POL | Poland | S | Solidarnosc | Solidarność | Solidarnosc | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 92320 | 74 | 108 | 11 | |||||||
POL | Poland | SD | Democratic Party | Stronnictwo Demokratyczne | Stronnictwo Demokratyczne | com | Communist/Socialist | 1.3 | 1.4 | 3.0 | 3.3 | 92211 | 2612 | 74 | 1216 | 14 | ||||||
POL | Poland | SDPL | Social Democracy of Poland | Socjaldemokracja Polska | Socjaldemokracja Polska | soc | Social democracy | 3.0 | 4.67 | 1.43 | 8.5667 | 2611 | 74 | 1140 | 11 | |||||||
POL | Poland | SLD | Democratic Left Alliance | Sojusz Lewicy Demokratycznej | Sojusz Lewicy Demokratycznej | soc | Social democracy | 2.8299 | 3.8505 | 1.8801 | 9.0872 | 92210 | 231 | 1616210 | 3001 | 3102 | 2601 | 74 | 629 | 11 | ||
POL | Poland | SP | United Poland | Solidarna Polska | Solidarna Polska | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 74 | 2372 | 40 | ||||||||
POL | Poland | SRP | Self-Defense of the Republic Poland | Samoobrona Rzeczypospolitej Polskiej | Samoobrona Rzeczypospolitej Polskiej | agr | Agrarian | 3.997 | 2.008 | 7.3253 | 2.1473 | 92622 | 384 | 3076 | 2604 | 74 | 207 | 2 | ||||
POL | Poland | SoPr | Labour Solidarity | Solidarność Pracy | Solidarnosc Pracy | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 92321 | 74 | 18 | 11 | |||||||
POL | Poland | UP | Labour Union | Unia Pracy | Unia Pracy | soc | Social democracy | 2.0348 | 1.8898 | 1.3726 | 8.7816 | 92322 | 3128 | 2602 | 74 | 838 | 11 | |||||
POL | Poland | UPR|KNP | Real Politics Union | Congress of the New Right | Unia Polityki Realnej | Kongres Nowej Prawicy | Unia Polityki Realnej | Kongres Nowej Prawicy | con | Conservative | 9.7368 | 9.4737 | 8.1579 | 2.3684 | 92432 | 382 | 3154 | 74 | 1549 | 26 | |||||
POL | Poland | WIO | Spring | Wiosna | Wiosna | soc | Social democracy | 3.3 | 3.5 | 3.5 | 8.1 | 74 | 2740 | 11 | ||||||||
POL | Poland | X | Party X | Partia X | Partia X | right | Right-wing | 8.8 | 5.9 | 8.5 | 2.3 | 92712 | 74 | 181 | 40 | |||||||
POL | Poland | ZChN | Christian National Union | Zjednoczenie Chrześcijańsko-Narodowe | Zjednoczenie Chrzescijansko-Narodowe | con | Conservative | 7.4 | 6.4 | 6.9 | 7.9 | 74 | 1758 | 26 | ||||||||
POL | Poland | ZSL | United People's Party | Zjednoczone Stronnictwo Ludowe | Zjednoczone Stronnictwo Ludowe | agr | Agrarian | 5.3 | 4.9 | 6.5 | 5.4 | 74 | 822 | 2 | ||||||||
POL | Poland | etc | others | others | others | none | no family | 74 | 1091 | 12 | ||||||||||||
POL | Poland | no-seat | no seat | no seat | no seat | none | no family | 74 | 2053 | 12 | ||||||||||||
POL | Poland | none | no party affiliation | no party affiliation | no party affiliation | none | no family | 74 | 1011 | 12 | ||||||||||||
POL | Poland | one-seat | one seat | one seat | one seat | none | no family | 74 | 2287 | 12 | ||||||||||||
MLT | Malta | AD | Democratic Alternative | Alternattiva Demokratika | Alternattiva Demokratika | eco | Green/Ecologist | 3.7895 | 3.2632 | 4.6316 | 224 | 1470100 | 6986 | 72 | 360 | 19 | ||||||
MLT | Malta | DAP | Democratic Action Party | Democratic Action Party | Democratic Action Party | con | Conservative | 7.4 | 6.4 | 6.9 | 72 | 816 | 26 | |||||||||
MLT | Malta | GP | Gozo Party | Gozo Party | Gozo Party | spec | Special issue | 72 | 1298 | 16 | ||||||||||||
MLT | Malta | IE | Imperium Europa | Imperu Ewropew | Imperu Ewropew | right | Right-wing | 8.8 | 5.9 | 8.5 | 72 | 1400 | 40 | |||||||||
MLT | Malta | JP | Jones Party | Jones Party | Jones Party | spec | Special issue | 72 | 248 | 16 |
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;