politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where data_source = "nyt" sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: start_date (date), end_date (date)
Link | rowid ▲ | id | country_id | start_date | end_date | person_id | person_id_source | party_id | data_source | description | comment |
---|---|---|---|---|---|---|---|---|---|---|---|
148 | 148 | 148 | Germany 54 | 1969-07-01 | 1974-06-30 | 8422 | Gustav Heinemann | Sozialdemokratische Partei Deutschlands 558 | nyt | President Heinemann was elected (yes: 512, no: 506, abstain: 3) on 5 March 1969 with votes from the Social Democrats (SPD) and Free Democrats (FDP). |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE politician_president("id", "country_id", "start_date", "end_date", "person_id", "person_id_source", "party_id", "data_source", "description", "comment", FOREIGN KEY([country_id]) REFERENCES [country]([id]), FOREIGN KEY([party_id]) REFERENCES [party]([id]) );