party_name_change
Data source: ParlGov · About: simonw/parlgov-datasette
5 rows where "date" is on date 1920-07-01 sorted by description
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4 | 4 | Bondepartiet | Farmer's Party | 1 | Bp | Senterpartiet 702 | Bondepartiet | 1920-07-01 | 4 | ||||
233 | 233 | Parti communiste française | French Communist Party | False | PCF | Parti communiste française 686 | Parti communiste francais | 1920-07-01 | 271 | ||||
541 | 541 | National Liberal and Conservative Party | National Liberal and Conservative Party | 0 | NLCP | Progressive Conservative Party of Canada 794 | National Liberal and Conservative Party | 1920-07-01 | 601 | ||||
614 | 614 | Wirtschaftspartei des deutschen Mittelstandes | Economic Party of the German Middle Classes | 0 | WP | Wirtschaftspartei 2698 | Wirtschaftspartei des deutschen Mittelstandes | 1920-07-01 | 674 | ||||
628 | 628 | Vereinigte Landwirtschaftliche Berufsvereinigung Thüringens | United Agricultural Professional Association of Thuringia | 0 | VLBT | Landbund Thüringen 2704 | Vereinigte Landwirtschaftliche Berufsvereinigung Thueringens | 1920-07-01 | 690 |
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]) );