external_party_ray
Data source: ParlGov · About: simonw/parlgov-datasette
191 rows sorted by nation descending
This data as json, CSV (advanced)
Suggested facets: natid, partyid
Link | rowid | natid | nation ▲ | partyid | party | ename | name |
---|---|---|---|---|---|---|---|
122 | 122 | 11 | UnitedKd | 1 | TORY | Conservative Party | Conservative Party |
123 | 123 | 11 | UnitedKd | 2 | LAB | Labour | Labour |
124 | 124 | 11 | UnitedKd | 3 | SDLP | Social Democratic Labour Party | Social Democratic Labour Party |
125 | 125 | 11 | UnitedKd | 4 | SLD | Social and Liberal Democrats | Social and Liberal Democrats |
126 | 126 | 11 | UnitedKd | 5 | SNP | Scottish National Party | Scottish National Party |
127 | 127 | 11 | UnitedKd | 6 | CYMRU | Welsh Nationalist Party | Plaid Cymru |
128 | 128 | 11 | UnitedKd | 7 | GREEN | Green Party | Green Party |
129 | 129 | 11 | UnitedKd | 8 | UNION | Unionist | Unionist |
178 | 178 | 17 | Switzerl | 1 | CDPP | Christian Democratic Peoples Party | Christlich Demokratische Volkspartei |
179 | 179 | 17 | Switzerl | 2 | LIB | Liberal Party | Liberale Partei |
180 | 180 | 17 | Switzerl | 3 | RADDEM | Radical Democrats | Parti Radical-democratique |
181 | 181 | 17 | Switzerl | 4 | SDEM | Social Democrats | Sozialdemokratische Partei |
182 | 182 | 17 | Switzerl | 5 | SPP | Swiss Peoples Party | Schweizerische Volkspartei |
183 | 183 | 17 | Switzerl | 6 | PPP | Protestant Peoples Party | Evangelische Volkspartei |
184 | 184 | 17 | Switzerl | 7 | LAB | Labour Party (communist) | Partei der Arbeit der Schweiz |
185 | 185 | 17 | Switzerl | 8 | INDEP | Independents Party | Alliance des Independents |
186 | 186 | 17 | Switzerl | 9 | NAPF | Swiss Democrats | Schweizer Demokraten |
187 | 187 | 17 | Switzerl | 10 | ASP | Autonomous Socialist Party | Partito Socialista Autonomo |
188 | 188 | 17 | Switzerl | 11 | GREEN | Green Party | Grune Partei der Schweiz |
189 | 189 | 17 | Switzerl | 12 | ALTGR | Alternative Greens | Grune Alternative Schwiez |
190 | 190 | 17 | Switzerl | 13 | FREE | Freedom Party | Freiheits Partei |
191 | 191 | 17 | Switzerl | 14 | TICI | Ticino League | Lega dei Ticinesi |
170 | 170 | 16 | Sweden | 1 | V | Left Party | Vanstrepartiet |
171 | 171 | 16 | Sweden | 2 | SD | Social Democrats | Socialdemocratistiska |
172 | 172 | 16 | Sweden | 3 | CP | Center Party | Centerpartiet |
173 | 173 | 16 | Sweden | 4 | FPL | Liberal Peoples Party | Folkpartiet Liberalerna |
174 | 174 | 16 | Sweden | 5 | MOD | Moderata Samlingspartiet | Moderate Coalition Party |
175 | 175 | 16 | Sweden | 6 | KDS | Christian Democratic Community Party | Kristen Demokratisk Samling |
176 | 176 | 16 | Sweden | 7 | GRONA | Green Ecology Party | Miljopartiet Grona |
177 | 177 | 16 | Sweden | 8 | NYDEM | New Democrcy | Ny Democratia |
47 | 47 | 5 | Spain | 1 | PSOE | Spanish Socialist Workers Party | Partido Socialista Obrero Espanol |
48 | 48 | 5 | Spain | 2 | PP | Popular Party | Partido Popular |
49 | 49 | 5 | Spain | 3 | CDS | Democratic and Social Center | Centro Democratico Social |
50 | 50 | 5 | Spain | 4 | IU | United Left | Izqueirda Unida |
51 | 51 | 5 | Spain | 5 | CIU | Convergence and Union | Convergencia I Unio |
52 | 52 | 5 | Spain | 6 | PNV | Basque Nationalist Party | Partido Nacionalista Vasco |
53 | 53 | 5 | Spain | 7 | EA | Basque Unity | Euzko Alkastasuna |
54 | 54 | 5 | Spain | 8 | HB | United People | Herri Batasuna |
55 | 55 | 5 | Spain | 9 | EE | Basque Left | Eukadiko Eskerra |
56 | 56 | 5 | Spain | 10 | PAR | Aragonese Regionalist Party | Partido Aragones Regionalista |
57 | 57 | 5 | Spain | 11 | ERC | Catalan Republican Left | Esquerra Republicana de Catalunya |
58 | 58 | 5 | Spain | 12 | UV | Valencian Union | Union Valencia |
59 | 59 | 5 | Spain | 14 | BNPG | Galician Nationalist Block | Bloque Nacionalista Popolar Galego |
60 | 60 | 5 | Spain | 15 | VERDE | Green Party | Partido Verde |
61 | 61 | 5 | Spain | 16 | VE | Ecologist Greens | Verdes Ecologistas |
62 | 62 | 5 | Spain | 17 | PA | Andalusian Party | Partido Andalucista |
130 | 130 | 12 | Portugal | 1 | CDU | Unified Democratic Coalition | Coligaco Democratica Unitaria |
131 | 131 | 12 | Portugal | 2 | CDS | Social Democratic Center | Centre Social Democrats |
132 | 132 | 12 | Portugal | 3 | PPM | Popular Monarchist Party | Partido Popular Monarquico |
133 | 133 | 12 | Portugal | 4 | PRD | Democratic Renewal Party | Partido Renovador Democratico |
134 | 134 | 12 | Portugal | 5 | PS | Socialist Party | Partido Socialista Portugesa |
135 | 135 | 12 | Portugal | 6 | PSD | Social Democratic Party | Partido Social Democrata |
136 | 136 | 12 | Portugal | 7 | PSN | National Solidarity Party | Partido Solidariedade Nacional |
137 | 137 | 12 | Portugal | 8 | PSR | Revolutionary Socialist Party | Partido Socialista Revolucionario |
138 | 138 | 12 | Portugal | 9 | PCTP | Communist Party | Partido Comunista |
139 | 139 | 12 | Portugal | 10 | PDC | Christian Democratic Party | Partido Democracia Cristao |
140 | 140 | 12 | Portugal | 11 | UDP | Popular Democratic Union | Uniao Democratico Popolar |
141 | 141 | 12 | Portugal | 12 | MDP | Democratic Movement | Moviements Democratico Portuges |
142 | 142 | 12 | Portugal | 13 | VERDES | The Greens | Os Verdes |
162 | 162 | 15 | Norway | 1 | AKP | Communist Party | Kommunistiske Parti |
163 | 163 | 15 | Norway | 2 | SV | Socialist Left | Sosialistisk Venstreparti |
164 | 164 | 15 | Norway | 3 | NAP | Norwegian Labour party | Norsk Arbeiderparti |
165 | 165 | 15 | Norway | 4 | SP | Center (Agrarian) Party | Senter Parti |
166 | 166 | 15 | Norway | 5 | KFP | Christian Peoples Party | Kristelig Folkeparti |
167 | 167 | 15 | Norway | 6 | H_YRE | Right (Conservatives) | Hoyre |
168 | 168 | 15 | Norway | 7 | FP | Progress Party | Fremskrittspartiet |
169 | 169 | 15 | Norway | 8 | V | Liberals | Venstre |
109 | 109 | 10 | Netherla | 1 | CDA | Christian Democratic Appeal | Christen Democratish Appel |
110 | 110 | 10 | Netherla | 2 | PVDA | Labour Party | Partij van der Arbeid |
111 | 111 | 10 | Netherla | 3 | VVD | Liberal Party | Volkspartij voor Vrijheid en Democratie |
112 | 112 | 10 | Netherla | 4 | D66 | Democrats 66 | Democraten 66 |
113 | 113 | 10 | Netherla | 5 | LINKS | Green Left | Groen Links |
114 | 114 | 10 | Netherla | 6 | SGP | Political Reformed Party | Staatkundig Gereformeerde Partij |
115 | 115 | 10 | Netherla | 7 | GPV | Reformed Political Union | Gereformed Politiek Verbond |
116 | 116 | 10 | Netherla | 8 | RPF | Reformed Political Federation | Reformed Political Federation |
117 | 117 | 10 | Netherla | 9 | CD | Center Democrats | Centrumdemokraten |
118 | 118 | 10 | Netherla | 10 | PPR | Radical Political Party | Politieke Partij Radikalen |
119 | 119 | 10 | Netherla | 11 | PSP | Pacifistic Socialist Party | Pacifistische Socialistische Partij |
120 | 120 | 10 | Netherla | 12 | CPN | Communist Party | Communistische Partij van Nederland |
121 | 121 | 10 | Netherla | 13 | EVP | Evangelical Peoples Party | Evangelische Volkspartij |
101 | 101 | 9 | Luxembou | 1 | CSVP | Christian Social Peoples Party | Creschtlech sozial vollekspartei |
102 | 102 | 9 | Luxembou | 2 | LSAP | Socialist Labor Party | Letzbuerger Sozialistesch Arbechterpartei |
103 | 103 | 9 | Luxembou | 3 | DP | Liberal Party | Democratesch Partei |
104 | 104 | 9 | Luxembou | 4 | KPL | Communist Party of Luxembourg | Kommunistesch Partei vu Letzbuerg |
105 | 105 | 9 | Luxembou | 5 | DGA | Green Alternative | Di Greng Alternativ |
106 | 106 | 9 | Luxembou | 6 | GLEI | Green Left Ecological Initiattive | Greng Lescht Ekologesch Initiativ |
107 | 107 | 9 | Luxembou | 7 | ADR | Action Committee for Democracy and Pensions | Aktiounskomitee fir Democratie |
108 | 108 | 9 | Luxembou | 8 | NBEW | National Movement | National Bewegong |
84 | 84 | 8 | Italy | 1 | DC/PP | Christian Democrats/Popular Party | Partito Popolare |
85 | 85 | 8 | Italy | 2 | PDS | Democratic Party of the Left | Partito Democratico della Sinistra |
86 | 86 | 8 | Italy | 3 | RC | Refounded Communists | Partito Rifondazione Communista |
87 | 87 | 8 | Italy | 4 | PSI | Italian Socialists | Socialisi Italiani |
88 | 88 | 8 | Italy | 5 | MSI/AN | National Alliance | Allainza Nationale |
89 | 89 | 8 | Italy | 6 | PRI | Republican Party | Partito Repubblicano Italiano |
90 | 90 | 8 | Italy | 7 | PSDI | Italian Social Democratic Party | Partito Socialista Democratica Italiano |
91 | 91 | 8 | Italy | 8 | VERDI | The Green List | Le Liste Verdi |
92 | 92 | 8 | Italy | 9 | PAN | Pannella List | Panella Lista |
93 | 93 | 8 | Italy | 10 | PLI | Liberal Party | Partito Liberale Italiano |
94 | 94 | 8 | Italy | 12 | LEGA | Northern League | Lega Nord |
95 | 95 | 8 | Italy | 13 | RETE | The Network | La Rete |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE external_party_ray("natid", "nation", "partyid", "party", "ename", "name");