party_name_change
Data source: ParlGov · About: simonw/parlgov-datasette
5 rows where "date" is on date 1902-07-01 sorted by comment
This data as json, CSV (advanced)
Suggested facets: data_source
Link | rowid | comment ▼ | data_source | name | name_english | party_change | name_short | party_id | name_ascii | date | name_nonlatin | id | description |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
523 | 523 | Frisinnade landsföreningen | Free-minded National Association | 0 | FL | Folkpartiet 892 | Frisinnade landsfreningen | 1902-07-01 | 582 | ||||
544 | 544 | Conservative | Conservative | 0 | C | Reform Party 2471 | Conservative | 1902-07-01 | 604 | ||||
545 | 545 | mackie, no-2010 | Katholische Konservative – Conservateurs catholiques | Catholic Conservatives | 0 | KK-CC | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | Katholische Konservative -- Conservateurs catholiquesdemocrate--chretien | 1902-07-01 | 605 | |||
547 | 547 | no-2010 | Liberal-Konservative – Conservateurs liberaux | Liberal Conservatives | 0 | LC | Liberale Partei der Schweiz – Parti liberal suisse 458 | Liberal-Konservative -- Conservateurs liberaux | 1902-07-01 | 607 | |||
560 | 560 | Gruppe der Demokraten – Groupe des democrates | Democratic Group | 0 | DG | Gruppe der Demokraten – Groupe des democrates 886 | Gruppe der Demokraten -- Groupe des democrates | 1902-07-01 | 620 |
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]) );