party_name_change
Data source: ParlGov · About: simonw/parlgov-datasette
2 rows where "date" is on date 1981-06-14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
311 | 311 | Majorité présidentielle [gauche] | Presidential Majority [Left] | 0 | CeG | Centre-gauche 2251 | Majorite presidentielle [gauche] | 1981-06-14 | 357 | ||||
313 | 313 | Union pour la nouvelle majorité [droite] | Union for a New Majority [Right] | 0 | CeD | Centre-droit 2250 | Union pour la nouvelle majorite [droite] | 1981-06-14 | 359 |
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]) );