cabinet

Table actions

Data source: ParlGov · About: simonw/parlgov-datasette

1 row where "start_date" is on date 1930-10-20

✎ View and edit SQL

This data as json, CSV (advanced)

start_date (date) 1 ✖

  • 1930-10-20 · 1 ✖
Link rowid ▼ id country_id start_date name caretaker wikipedia data_source description comment previous_cabinet_id previous_parliament_election_id previous_ep_election_id old_countryID old_cabID
1170 1170 1228 Norway 9 1930-10-20 Mowinckel IV 0 https://en.wikipedia.org/wiki/Mowinckel%27s_Second_Cabinet Cabinet lost a vote of confidence.   Mowinckel III 1229 866 866      

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE cabinet("id", "country_id", "start_date", "name", "caretaker", "wikipedia", "data_source", "description", "comment", "previous_cabinet_id", "previous_parliament_election_id", "previous_ep_election_id", "old_countryID", "old_cabID",
   FOREIGN KEY([country_id]) REFERENCES [country]([id]),
   FOREIGN KEY([data_source]) REFERENCES [info_data_source]([key]),
   FOREIGN KEY([previous_cabinet_id]) REFERENCES [cabinet]([id]),
   FOREIGN KEY([previous_parliament_election_id]) REFERENCES [election]([id]),
   FOREIGN KEY([previous_ep_election_id]) REFERENCES [election]([id])
);