committee_membership
Data source: See col-scraper on GitHub
4 rows where committee_id = 1251
This data as json, CSV (advanced)
Link | rowid ▼ | committee_id | member_id | role |
---|---|---|---|---|
232 | 232 | Epping Forest Joint Consultative Committee 1251 | Sylvia Doreen Moys 381 | |
530 | 530 | Epping Forest Joint Consultative Committee 1251 | Gregory Alfred Lawrence 276 | |
899 | 899 | Epping Forest Joint Consultative Committee 1251 | Graeme Martyn Smith 1231 | |
1002 | 1002 | Epping Forest Joint Consultative Committee 1251 | Philip Woodhouse 1211 |
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");