party_name_change
Data source: ParlGov · About: simonw/parlgov-datasette
3 rows where "date" is on date 1917-07-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
510 | 510 | Sverges Socialdemokratiska Vänsterparti | Social Democratic Left Party of Sweden | 0 | SSV | Vänsterpartiet (kommunisterna) 882 | Sverges Socialdemokratiska Vansterparti | 1917-07-01 | 569 | ||||
540 | 540 | Unionist Party | Unionist Party | 0 | UP | Progressive Conservative Party of Canada 794 | Unionist Party | 1917-07-01 | 600 | ||||
549 | 549 | Sozialistesch Partei | Socialist Party | 0 | SP | Lëtzebuerger Sozialistesch Aarbechterpartei 701 | Sozialistesch Partei | 1917-07-01 | 609 |
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]) );