politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where comment = "Mattarella was one of the founders of the Democratic Party (PD) in 2007 and was officially endorsed by the party." sorted by comment
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|
286 | 286 | 287 | Italy 26 | 2015-02-03 | 2022-01-29 | 8465 | Sergio Mattarella | Partito Democratico 382 | reuters | Mattarella was one of the founders of the Democratic Party (PD) in 2007 and was officially endorsed by the party. |
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]) );
comment 1 ✖