external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
308 rows
This data as json, CSV (advanced)
commission_name 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
301 | 301 | 2019 | 1 | Equality | 305 | 1 | Malta 72 | Von der Leyen | 0 | 17179 | Helena Dalli | 2019-12-01 | 1.0 | Partit Laburista 1003 | 0 | minister of european affairs and equality | 10 | Muscat II 1504 | |||
302 | 302 | 2019 | 1 | Home Affairs | 306 | 1 | Sweden 35 | Von der Leyen | 0 | 4867 | Ylva Johansson | 2019-12-01 | 1.26 | Socialdemokraterna 904 | 0 | minister of employment | dw-05 | 10 | Lofven III 1590 | ||
303 | 303 | 2019 | 0 | Crisis Management | 307 | 1 | Slovenia 60 | Von der Leyen | 0 | 17180 | Janez Lenarčič | 2019-12-01 | 0.2 | no party affiliation 1370 | 0 | diplomat | 12 | Sarec 1555 | |||
304 | 304 | 2019 | 1 | Transport | 308 | 1 | Romania 23 | Von der Leyen | 0 | 32 | Adina Vălean | 2019-12-01 | 0.33 | Partidul Naţional Liberal 1015 | 0 | mep/mp | 10 | Orban I 1619 | |||
305 | 305 | 2019 | 0 | Neighbourhood and Enlargement | 309 | 1 | Hungary 39 | Von der Leyen | 0 | 17181 | Olivér Várhelyi | 2019-12-01 | 0.2 | Fidesz – Magyar Polgári Szövetség 921 | 0 | bureaucrat | 10 | Orban IV 1531 | |||
306 | 306 | 2019 | 1 | International Partnerships | 310 | 1 | Finland 67 | Von der Leyen | 0 | 16990 | Jutta Urpilainen | 2019-12-01 | 1.0 | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | 0 | minister of finance and deputy minister | dw-05 | 10 | Rinne 1596 | ||
307 | 307 | 2019 | 311 | 1 | Estonia 75 | Von der Leyen | 0 | 17182 | Kadri Simson | 2019-12-01 | 1.21 | Eesti Keskerakond 1137 | 0 | minister of economic affairs and infrastructure | 10 | Ratas II 1595 | |||||
308 | 308 | 2019 | 1 | Environment, Oceans and Fisheries | 312 | 1 | Lithuania 15 | Von der Leyen | 0 | 17183 | Virginijus Sinkevičius | 2019-12-01 | 1.47 | Lietuvos valstiečių sąjunga 191 | 0 | minister of economy and innovation | dr-08 | 10 | Skvernelis III 1615 |
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]) );