committee_membership
Data source: See col-scraper on GitHub
14 rows where committee_id = 123
This data as json, CSV (advanced)
Link | rowid ▼ | committee_id | member_id | role |
---|---|---|---|---|
159 | 159 | Licensing Committee 123 | Caroline Kordai Addy 1947 | |
177 | 177 | Licensing Committee 123 | Judith Pleasance 1212 | |
371 | 371 | Licensing Committee 123 | Peter Gerard Dunphy 200 | |
394 | 394 | Licensing Committee 123 | Jamie Ingham Clark 1223 | |
414 | 414 | Licensing Committee 123 | Sophie Anne Fernandes 217 | |
423 | 423 | Licensing Committee 123 | Karina Dostalova 1222 | |
456 | 456 | Licensing Committee 123 | Michael Hudson 256 | |
505 | 505 | Licensing Committee 123 | Mary Durcan 1957 | |
627 | 627 | Licensing Committee 123 | Graham Packham 1221 | |
764 | 764 | Licensing Committee 123 | Keith David Forbes Bottomley 1666 | |
840 | 840 | Licensing Committee 123 | Marianne Bernadette Fredericks 223 | |
942 | 942 | Licensing Committee 123 | James Richard Tumbridge 394 | |
979 | 979 | Licensing Committee 123 | Shravan Jashvantrai Joshi 2104 | |
1184 | 1184 | Licensing Committee 123 | 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");