committee_membership

Data source: See col-scraper on GitHub

1,193 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee_id member_id role
101 101 Finance, General Purposes and Estates Sub-Committee of the Board of Governors of the City of London Freemen's School 212 Roger Arthur Holden Chadwick 158  
102 102 Barbican Residential Committee 153 Barbara Patricia Newman 363  
103 103 Community & Children's Services Committee 120 Barbara Patricia Newman 363  
104 104 223 Barbara Patricia Newman 363  
105 105 Culture, Heritage and Libraries Committee 177 Barbara Patricia Newman 363  
106 106 Establishment Committee 253 Barbara Patricia Newman 363  
107 107 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 Barbara Patricia Newman 363  
108 108 Integrated Commissioning Sub Committee 1247 Barbara Patricia Newman 363  
109 109 Open Spaces and City Gardens 175 Barbara Patricia Newman 363  
110 110 Planning and Transportation Committee 143 Barbara Patricia Newman 363  
111 111 Standards Committee 408 Barbara Patricia Newman 363  
112 112 Streets and Walkways Sub (Planning and Transportation) Committee 389 Barbara Patricia Newman 363  
113 113 Wanstead Park Working Party 1208 Barbara Patricia Newman 363  
114 114 West Ham Park Committee 400 Barbara Patricia Newman 363  
115 115 220 Sir Roger Gifford 226  
116 116 223 Sir Roger Gifford 226  
117 117 1183 Sir Roger Gifford 226  
118 118 Port Health & Environmental Services Committee 262 Sir Roger Gifford 226  
119 119 Barbican Centre Board 140 Tom Sleigh 1213  
120 120 223 Tom Sleigh 1213  
121 121 Finance Committee 145 Tom Sleigh 1213  
122 122 Finance Committee of the Barbican Centre Board 165 Tom Sleigh 1213  
123 123 Investment Committee 176 Tom Sleigh 1213  
124 124 Markets Committee 411 Tom Sleigh 1213  
125 125 Nominations Committee of the Barbican Centre Board 164 Tom Sleigh 1213  
126 126 Policy and Resources Committee 395 Tom Sleigh 1213  
127 127 Property Investment Board 125 Tom Sleigh 1213  
128 128 Public Relations and Economic Development Sub (Policy & Resources) Committee 1072 Tom Sleigh 1213  
129 129 Resource Allocation Sub (Policy and Resources) Committee 396 Tom Sleigh 1213  
130 130 Risk Committee of the Barbican Centre Board 249 Tom Sleigh 1213  
131 131 Community & Children's Services Committee 120 Thomas Alexander Anderson 1950  
132 132 223 Thomas Alexander Anderson 1950  
133 133 Health and Wellbeing Board 994 Thomas Alexander Anderson 1950  
134 134 Markets Committee 411 Thomas Alexander Anderson 1950  
135 135 Board of Governors of the City of London School 233 Sheriff Vincent Thomas Keaveny 1395  
136 136 220 Sheriff Vincent Thomas Keaveny 1395  
137 137 223 Sheriff Vincent Thomas Keaveny 1395  
138 138 Courts Sub (Policy & Resources) Committee 1229 Sheriff Vincent Thomas Keaveny 1395  
139 139 Freedom Applications Committee 183 Sheriff Vincent Thomas Keaveny 1395  
140 140 Governance Committee of the Board of Governors of the City of London School 1231 Sheriff Vincent Thomas Keaveny 1395  
141 141 Homelessness and Rough Sleeping Sub Committee 1261 Sheriff Vincent Thomas Keaveny 1395  
142 142 Lord Mayor's Show Ltd 850 Sheriff Vincent Thomas Keaveny 1395  
143 143 Audit and Risk Management Committee 244 Andrien Gereith Dominic Meyers 1946  
144 144 223 Andrien Gereith Dominic Meyers 1946  
145 145 Financial Investment Board 248 Andrien Gereith Dominic Meyers 1946  
146 146 Investment Committee 176 Andrien Gereith Dominic Meyers 1946  
147 147 Markets Committee 411 Andrien Gereith Dominic Meyers 1946  
148 148 Port Health & Environmental Services Committee 262 Andrien Gereith Dominic Meyers 1946  
149 149 Property Investment Board 125 Andrien Gereith Dominic Meyers 1946  
150 150 Social Investment Board 1064 Andrien Gereith Dominic Meyers 1946  
151 151 Barbican Residential Committee 153 Mark Raymond Peter Henry Delano Wheatley 1229  
152 152 223 Mark Raymond Peter Henry Delano Wheatley 1229  
153 153 Culture, Heritage and Libraries Committee 177 Mark Raymond Peter Henry Delano Wheatley 1229  
154 154 Markets Committee 411 Mark Raymond Peter Henry Delano Wheatley 1229  
155 155 Policy and Resources Committee 395 Mark Raymond Peter Henry Delano Wheatley 1229  
156 156 Port Health & Environmental Services Committee 262 Mark Raymond Peter Henry Delano Wheatley 1229  
157 157 223 Caroline Kordai Addy 1947  
158 158 Licensing (Hearing) Sub Committee 200 Caroline Kordai Addy 1947  
159 159 Licensing Committee 123 Caroline Kordai Addy 1947  
160 160 Port Health & Environmental Services Committee 262 Caroline Kordai Addy 1947  
161 161 Reference Sub (Licensing) Committee 986 Caroline Kordai Addy 1947  
162 162 Standards Committee 408 Caroline Kordai Addy 1947  
163 163 Audit and Risk Management Committee 244 Alexander Robertson Martin Barr 1951  
164 164 Board of Governors of the City of London School 233 Alexander Robertson Martin Barr 1951  
165 165 223 Alexander Robertson Martin Barr 1951  
166 166 Finance & Estates Committee of the Board of Governors of the City of London School 1233 Alexander Robertson Martin Barr 1951  
167 167 Nominations Sub Committee of the Audit and Risk Management Committee 1260 Alexander Robertson Martin Barr 1951  
168 168 Police Pensions Board 1206 Alexander Robertson Martin Barr 1951  
169 169 Port Health & Environmental Services Committee 262 Alexander Robertson Martin Barr 1951  
170 170 Barbican Residential Committee 153 Stephen Douglas Quilter 362  
171 171 223 Stephen Douglas Quilter 362  
172 172 Markets Committee 411 Stephen Douglas Quilter 362  
173 173 Barbican Centre Board 140 Judith Pleasance 1212  
174 174 223 Judith Pleasance 1212  
175 175 Culture, Heritage and Libraries Committee 177 Judith Pleasance 1212  
176 176 Finance Committee of the Barbican Centre Board 165 Judith Pleasance 1212  
177 177 Licensing Committee 123 Judith Pleasance 1212  
178 178 Livery Committee 383 Judith Pleasance 1212  
179 179 Planning and Transportation Committee 143 Judith Pleasance 1212  
180 180 Risk Committee of the Barbican Centre Board 249 Judith Pleasance 1212  
181 181 220 Matthew Richardson 374  
182 182 223 Matthew Richardson 374  
183 183 Finance Committee 145 Matthew Richardson 374  
184 184 Assessment Sub (Standards) Committee 1134 David Andrew Graves 231  
185 185 Barbican Centre Board 140 David Andrew Graves 231  
186 186 Barbican Estate Residents Consultation Committee 188 David Andrew Graves 231  
187 187 Community & Children's Services Committee 120 David Andrew Graves 231  
188 188 220 David Andrew Graves 231  
189 189 223 David Andrew Graves 231  
190 190 Finance Committee of the Barbican Centre Board 165 David Andrew Graves 231  
191 191 Housing Management and Almshouses Sub (Community and Children's Services) Committee 247 David Andrew Graves 231  
192 192 Markets Committee 411 David Andrew Graves 231  
193 193 Risk Committee of the Barbican Centre Board 249 David Andrew Graves 231  
194 194 Taught Degree Awarding Powers Sub Committee of the Board of Governors of the Guildhall School of Music & Drama 555 David Andrew Graves 231  
195 195 220 The Rt Hon the Baroness Patricia Scotland of Asthal, QC 1592  
196 196 223 The Rt Hon the Baroness Patricia Scotland of Asthal, QC 1592  
197 197 Policy and Resources Committee 395 The Rt Hon the Baroness Patricia Scotland of Asthal, QC 1592  
198 198 Board of Governors of the City of London School for Girls 236 Dhruv Patel 1224  
199 199 Community & Children's Services Committee 120 Dhruv Patel 1224  
200 200 223 Dhruv Patel 1224  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");