party_name_change
Data source: ParlGov · About: simonw/parlgov-datasette
6 rows where "date" is on date 1921-07-01 sorted by party_id
This data as json, CSV (advanced)
Suggested facets: data_source, party_change
Link | rowid | comment | data_source | name | name_english | party_change | name_short | party_id ▼ | name_ascii | date | name_nonlatin | id | description |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39 | 39 | Partido Communista de España | Spanish Communist Party | False | PCE | Partido Communista | Izquierda Unida 118 | Partido Communista de Espana | 1921-07-01 | 44 | ||||
7 | 7 | Sveriges Kommunistiska Parti | Communist Party of Sweden | False | SKP | Vänsterpartiet (kommunisterna) 882 | Sveriges Kommunistiska Parti | 1921-07-01 | 7 | ||||
218 | 218 | ho-86 | Kommunistische Partei der Schweiz – Parti communiste suisse | Communist Party of Switzerland | False | KPS-PCS | Partei der Arbeit der Schweiz 1167 | Kommunistische Partei der Schweiz -- Parti communiste suisse | 1921-07-01 | 252 | |||
500 | 500 | Det radikale Folkeparti | Radical People's Party | 0 | DRF | Arbeiderdemokratene | Det radikale Folkeparti 2415 | Det radikale Folkeparti | 1921-07-01 | 556 | ||||
630 | 630 | Liberale Staatspartij | Liberal State Party | 0 | LSP | Liberale Staatspartij "de Vrijheidsbond" 2461 | Liberale Staatspartij | 1921-07-01 | 692 | ||||
511 | 511 | Sverges Socialdemokratiska Vänsterparti | Social Democratic Left Party of Sweden | 0 | SSV | Sverges Socialdemokratiska Vänsterparti – 1921 2557 | Sverges Socialdemokratiska Vansterparti | 1921-07-01 | 570 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE party_name_change("comment", "data_source", "name", "name_english", "party_change", "name_short", "party_id", "name_ascii", "date", "name_nonlatin", "id", "description", FOREIGN KEY([party_id]) REFERENCES [party]([id]) );