party_name_change
Data source: ParlGov · About: simonw/parlgov-datasette
3 rows where "date" is on date 1922-06-01
This data as json, CSV (advanced)
Link | rowid ▼ | comment | data_source | name | name_english | party_change | name_short | party_id | name_ascii | date | name_nonlatin | id | description |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
528 | 528 | Sinn Féin (Pro-Treaty) | Sinn Fein (Pro-Treaty) | 0 | SF | Cumann na nGaedheal 2447 | Sinn Fein (Pro-Treaty) | 1922-06-01 | 588 | ||||
530 | 530 | Sinn Féin (Anti-Treaty) | Sinn Fein (Anti-Treaty) | 0 | SF | Fianna Fáil 280 | Sinn Fein (Anti-Treaty) | 1922-06-01 | 590 | ||||
660 | 660 | Kommunistische Partei Deutschlands | Communist Party of Germany | 0 | KPD | Kommunistische Partei Deutschlands 649 | Kommunistische Partei Deutschlands | 1922-06-01 | 723 |
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]) );