party_name_change
Data source: ParlGov · About: simonw/parlgov-datasette
5 rows where "date" is on date 1970-07-01 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: party_change
Link | rowid ▲ | comment | data_source | name | name_english | party_change | name_short | party_id | name_ascii | date | name_nonlatin | id | description |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
423 | 423 | Provisional Sinn Féin | Provisional Sinn Fein | 1 | PSF | Sinn Féin 2217 | Provisional Sinn Fein | 1970-07-01 | 475 | ||||
422 | 422 | Official Sinn Féin | Official Sinn Fein | 1 | SF | Sinn Féin The Workers' Party 433 | Official Sinn Fein | 1970-07-01 | 474 | ||||
344 | 344 | Nieuwe Midden Partij | New Middle Party | 0 | NMP | Midden Partij 87 | Nieuwe Midden Partij | 1970-07-01 | 390 | ||||
86 | 86 | Kristeligt Folkeparti | Christian People's Party | False | KrF | Kristeligt Folkeparti 1331 | Kristeligt Folkeparti | 1970-07-01 | 93 | ||||
29 | 29 | Socialistiko Komma Kyprou | Socialist Party of Cyprus | False | EDEK | Kinima Sosialdimokraton EDEK 945 | Socialistiko Komma Kyprou | 1970-07-01 | 33 |
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]) );