committee_membership
Data source: See col-scraper on GitHub
10 rows where committee_id = 1262 sorted by committee_id
This data as json, CSV (advanced)
Link | rowid | committee_id ▼ | member_id | role |
---|---|---|---|---|
32 | 32 | Senior Remuneration Sub-Committee 1262 | Edward Lord 292 | |
268 | 268 | Senior Remuneration Sub-Committee 1262 | Sir David Hugh Wootton 397 | |
297 | 297 | Senior Remuneration Sub-Committee 1262 | Catherine McGuinness 373 | |
408 | 408 | Senior Remuneration Sub-Committee 1262 | Jamie Ingham Clark 1223 | |
740 | 740 | Senior Remuneration Sub-Committee 1262 | Simon D'Olier Duckworth 151 | |
776 | 776 | Senior Remuneration Sub-Committee 1262 | Keith David Forbes Bottomley 1666 | |
810 | 810 | Senior Remuneration Sub-Committee 1262 | Jeremy Mayhew 370 | |
824 | 824 | Senior Remuneration Sub-Committee 1262 | Ruby Sayed 1938 | |
1046 | 1046 | Senior Remuneration Sub-Committee 1262 | The Revd Stephen Decatur Haines 232 | |
1189 | 1189 | Senior Remuneration Sub-Committee 1262 | 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");