cabinet_party

Table actions

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

1 row where comment = "Harumi Inui (DRP) parliamentary vice minister for the Science and Technology Agency"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ id cabinet_id party_id pm data_source description comment
2318 2318 2571 Hosokawa 417 Min-kai-ren 163 0 jiji Democratic Reform Party (DRP) with no seats in the lower house but 11 seats in the upper house. Harumi Inui (DRP) parliamentary vice minister for the Science and Technology Agency

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE cabinet_party("id", "cabinet_id", "party_id", "pm", "data_source", "description", "comment",
   FOREIGN KEY([cabinet_id]) REFERENCES [cabinet]([id]),
   FOREIGN KEY([party_id]) REFERENCES [party]([id])
);