external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
4 rows where comment = "check munzinger"
This data as json, CSV (advanced)
Suggested facets: commission_year, elected, one_seat, country_id, commission_name, start_date, end_date, president, government_party, end_date (date)
start_date (date) 2 ✖
- 1995-01-06 2
- 1999-09-16 2
Link | rowid ▼ | comment | commission_year | elected | portfolio | id | one_seat | country_id | commission_name | incumbent | person_id | person_id_source | start_date | end_date | score_position | party_id | president | highest_position | data_source | government_party | previous_cabinet_id |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
148 | 148 | check munzinger | 1995 | 1 | fisheries. consumer policy | 148 | 0 | Italy 26 | Santer | 0 | 13774 | Bonino, Emma | 1995-01-06 | 1999-03-15 | 0.33 | Radicali 1296 | 0 | mp/mep | doering | 10 | Berlusconi I 672 |
164 | 164 | check munzinger | 1995 | 0 | regional policy | 164 | 0 | Germany 54 | Santer | 0 | 13908 | Wulf-Mathies, Monika | 1995-01-06 | 1999-03-15 | 0.2 | Sozialdemokratische Partei Deutschlands 558 | 0 | union head | doering | Aliança Povo Unido 11 | Kohl V 778 |
171 | 171 | check munzinger | 1999 | 1 | health and consumer protection | 171 | 1 | Ireland 37 | Prodi | 0 | 376 | Byrne, David | 1999-09-16 | 2004-11-21 | 0.9 | Fianna Fáil 280 | 0 | attorney general | doering | 10 | Ahern I 126 |
190 | 190 | check munzinger | 1999 | 1 | president | 190 | 0 | Italy 26 | Prodi | 0 | 6321 | Prodi, Romani | 1999-09-16 | 2004-11-21 | 2.48 | Centro-sinistra 1048 | 1 | prime minister | doering | 10 | D'Alema I 214 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE external_commissioner_doering("comment", "commission_year", "elected", "portfolio", "id", "one_seat", "country_id", "commission_name", "incumbent", "person_id", "person_id_source", "start_date", "end_date", "score_position", "party_id", "president", "highest_position", "data_source", "government_party", "previous_cabinet_id", FOREIGN KEY([country_id]) REFERENCES [country]([id]), FOREIGN KEY([party_id]) REFERENCES [party]([id]), FOREIGN KEY([data_source]) REFERENCES [info_data_source]([key]), FOREIGN KEY([government_party]) REFERENCES [party]([id]), FOREIGN KEY([previous_cabinet_id]) REFERENCES [cabinet]([id]) );
comment 1 ✖