committee_membership
Data source: See col-scraper on GitHub
7 rows where committee_id = 254
This data as json, CSV (advanced)
Link | rowid ▼ | committee_id | member_id | role |
---|---|---|---|---|
23 | 23 | Joint Consultative Committee 254 | Edward Lord 292 | |
392 | 392 | Joint Consultative Committee 254 | Jamie Ingham Clark 1223 | |
762 | 762 | Joint Consultative Committee 254 | Keith David Forbes Bottomley 1666 | |
821 | 821 | Joint Consultative Committee 254 | Ruby Sayed 1938 | |
881 | 881 | Joint Consultative Committee 254 | Randall Keith Anderson 1227 | |
917 | 917 | Joint Consultative Committee 254 | Joyce Carruthers Nash 382 | |
1182 | 1182 | Joint Consultative Committee 254 | Kevin Malcolm Everett 213 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE committee_membership( committee_id INTEGER REFERENCES committees(id), member_id INTEGER REFERENCES members(id), role VARCHAR(50) ); CREATE INDEX committee_membership_committee_id ON committee_membership("committee_id"); CREATE INDEX committee_membership_member_id ON committee_membership("member_id");