committee_membership
Data source: See col-scraper on GitHub
13 rows where member_id = 1231
This data as json, CSV (advanced)
Link | rowid ▼ | committee_id | member_id | role |
---|---|---|---|---|
894 | 894 | Ashtead Common Consultative Group 141 | Graeme Martyn Smith 1231 | |
895 | 895 | Burnham Beeches and Stoke Common Consultation Group 1228 | Graeme Martyn Smith 1231 | |
896 | 896 | 223 | Graeme Martyn Smith 1231 | |
897 | 897 | Epping Forest & Commons Committee 122 | Graeme Martyn Smith 1231 | |
898 | 898 | Epping Forest Consultative Committee 1253 | Graeme Martyn Smith 1231 | |
899 | 899 | Epping Forest Joint Consultative Committee 1251 | Graeme Martyn Smith 1231 | |
900 | 900 | Finance Committee 145 | Graeme Martyn Smith 1231 | |
901 | 901 | Hampstead Heath, Highgate Wood and Queen's Park Committee 250 | Graeme Martyn Smith 1231 | |
902 | 902 | Open Spaces and City Gardens 175 | Graeme Martyn Smith 1231 | |
903 | 903 | 1094 | Graeme Martyn Smith 1231 | |
904 | 904 | Wanstead Park Working Party 1208 | Graeme Martyn Smith 1231 | |
905 | 905 | West Ham Park Committee 400 | Graeme Martyn Smith 1231 | |
906 | 906 | West Wickham, Spring Park and Coulsdon Commons Consultation Group 1077 | Graeme Martyn Smith 1231 |
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");