external_party_chess
Data source: ParlGov · About: simonw/parlgov-datasette
20 rows where country = 5 sorted by name_english
This data as json, CSV (advanced)
id | country | name_short | name | name_english ▼ |
---|---|---|---|---|
516 | 5 | PA | Partido Andalucista | Andalusian Party |
520 | 5 | CHA | Chunta Aragonesista | Aragonese Council |
510 | 5 | PAR | Partido Aragonés | Aragonese Party |
506 | 5 | PNV | Euzko Alderdi Jeltzalea/ Partido Nacionalista Vasco | Basque Nationalist Party |
507 | 5 | EA | Eusko Alkartasuna | Basque Solidarity |
519 | 5 | PSC | Partit dels Socialistes de Catalunya | Catalan Socialist Party |
517 | 5 | CC | Coalicion Canaria | Coalicion Canaria |
521 | 5 | CpE | Coalicion por Europa | Coalition for Europe |
505 | 5 | CiU | Convergència i Unió | Convergence and Unity |
522 | 5 | EdP-V | Europa de los Pueblos-Los Verdes | Europe of the Peoples-Greens |
513 | 5 | BNG | Bloque Nacionalista Galego | Galician Nationalist Bloc |
518 | 5 | IC | Iniciativa per Catalunya | Initiative for Catalonia |
502 | 5 | PP | Partido Popular | People's Party |
511 | 5 | ERC | Esquerra Republicana de Catalunya | Republican Left of Catalonia |
501 | 5 | PSOE | Partido Socialista Obrero Español | Spanish Socialist Workers' Party |
514 | 5 | VERDE | Los Verdes | The Greens |
523 | 5 | UPD | Union Progreso y Democracia | Union, Progress, and Democracy |
504 | 5 | IU | Izquierda Unida | United Left |
512 | 5 | UV | Unión Valenciana | Valencian Union |
508 | 5 | EH | Euskal Herritarrok | We Basque Citizens |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "external_party_chess" ( "id" integer unsigned NOT NULL PRIMARY KEY, "country" integer unsigned NOT NULL, "name_short" varchar(10) NOT NULL, "name" varchar(100) NOT NULL, "name_english" varchar(100) NOT NULL ); CREATE INDEX "external_party_chess_a9e7aee" ON "external_party_chess" ("country");