party_name_change
Data source: ParlGov · About: simonw/parlgov-datasette
6 rows where "date" is on date 1994-07-01 sorted by name
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
552 | 552 | Association of Consumers and Taxpayers | Association of Consumers and Taxpayers | 0 | ACT | ACT New Zealand 617 | Association of Consumers and Taxpayers | 1994-07-01 | 612 | ||||
481 | 481 | Eesti Pensionäride ja Perede Erakond | Estonian Party of Pensioners and Families | 0 | EPPE | Eesti Pensionäride ja Perede Erakond 2402 | Eesti Pensionaride ja Perede Erakond | 1994-07-01 | 535 | ||||
104 | 104 | Eestimaa Ühendatud Rahvapartei | Estonian United People's Party | False | EUR | Konstitutsioonierakond – Eestimaa Ühendatud Rahvapartei 1590 | Eestimaa Uehendatud Rahvapartei | 1994-07-01 | 111 | ||||
98 | 98 | Freiheitspartei der Schweiz | Freedom Party of Switzerland | False | FPS | Auto-Partei | Freiheitspartei der Schweiz 1602 | Freiheitspartei der Schweiz | 1994-07-01 | 105 | ||||
117 | 117 | Parti radical-socialiste | Radical-Socialist Party | False | PRS | Parti radical de gauche 1492 | Parti radical-socialiste | 1994-07-01 | 125 | ||||
445 | 445 | Tuleviku Eesti Erakond | Future's Estonia Party | 0 | TEE | Tuleviku Eesti | Iseseisvuspartei 1794 | Tuleviku Eesti Erakond | 1994-07-01 | 497 |
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]) );