committee_membership

Data source: See col-scraper on GitHub

1,193 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link rowid ▼ committee_id member_id role
1 1 Community & Children's Services Committee 120 Graeme Harrower 1659  
2 2 223 Graeme Harrower 1659  
3 3 Culture, Heritage and Libraries Committee 177 Graeme Harrower 1659  
4 4 Planning and Transportation Committee 143 Graeme Harrower 1659  
5 5 Port Health & Environmental Services Committee 262 Graeme Harrower 1659  
6 6 Academic and Personnel Sub Committee of the Board of Governors of the City of London Freemen's School 213 Dame Fiona Woolf 396  
7 7 Board of Governors of the City of London Freemen's School 230 Dame Fiona Woolf 396  
8 8 220 Dame Fiona Woolf 396  
9 9 223 Dame Fiona Woolf 396  
10 10 Finance, General Purposes and Estates Sub-Committee of the Board of Governors of the City of London Freemen's School 212 Dame Fiona Woolf 396  
11 11 1183 Dame Fiona Woolf 396  
12 12 Board of Governors of the City of London School 233 Edward Lord 292  
13 13 Capital Buildings Committee 1255 Edward Lord 292  
14 14 Committee of Aldermanic Almoners, Common Council Governors and Donation Governors of Christ's Hospital 206 Edward Lord 292  
15 15 223 Edward Lord 292  
16 16 Courts Sub (Policy & Resources) Committee 1229 Edward Lord 292  
17 17 Establishment Committee 253 Edward Lord 292  
18 18 Finance & Estates Committee of the Board of Governors of the City of London School 1233 Edward Lord 292  
19 19 Governance Committee of the Board of Governors of the City of London School 1231 Edward Lord 292  
20 20 Gresham (City Side) Committee 259 Edward Lord 292  
21 21 Gresham Working Party 334 Edward Lord 292  
22 22 Investment Committee 176 Edward Lord 292  
23 23 Joint Consultative Committee 254 Edward Lord 292  
24 24 Markets Committee 411 Edward Lord 292  
25 25 Members Privileges Sub (Policy and Resources) Committee 407 Edward Lord 292  
26 26 Outside Bodies Sub (Policy and Resources) Committee 1205 Edward Lord 292  
27 27 Policy and Resources Committee 395 Edward Lord 292  
28 28 Property Investment Board 125 Edward Lord 292  
29 29 Public Relations and Economic Development Sub (Policy & Resources) Committee 1072 Edward Lord 292  
30 30 Reference Sub (Markets) Committee 563 Edward Lord 292  
31 31 Resource Allocation Sub (Policy and Resources) Committee 396 Edward Lord 292  
32 32 Senior Remuneration Sub-Committee 1262 Edward Lord 292  
33 33 Standards Committee 408 Edward Lord 292  
34 34 The City Bridge Trust Committee 179 Edward Lord 292  
35 35 220 Nicholas Stephen Leland Lyons 2034  
36 36 223 Nicholas Stephen Leland Lyons 2034  
37 37 Efficiency and Performance Sub (Finance) Committee 245 Nicholas Stephen Leland Lyons 2034  
38 38 Finance Committee 145 Nicholas Stephen Leland Lyons 2034  
39 39 Board of Governors of the City of London Freemen's School 230 Hugh Fenton Morris 380  
40 40 223 Hugh Fenton Morris 380  
41 41 Digital Services Sub (Finance) Committee 257 Hugh Fenton Morris 380  
42 42 Efficiency and Performance Sub (Finance) Committee 245 Hugh Fenton Morris 380  
43 43 Finance Committee 145 Hugh Fenton Morris 380  
44 44 Procurement Sub (Finance) Committee 1267 Hugh Fenton Morris 380  
45 45 Barbican Centre Board 140 Tom Hoffman 251  
46 46 Board of Governors of the City of London School for Girls 236 Tom Hoffman 251  
47 47 223 Tom Hoffman 251  
48 48 Culture, Heritage and Libraries Committee 177 Tom Hoffman 251  
49 49 Freedom Applications Committee 183 Tom Hoffman 251  
50 50 Gresham (City Side) Committee 259 Tom Hoffman 251  
51 51 Markets Committee 411 Tom Hoffman 251  
52 52 Member Development Steering Group 174 Tom Hoffman 251  
53 53 Members Privileges Sub (Policy and Resources) Committee 407 Tom Hoffman 251  
54 54 Outside Bodies Sub (Policy and Resources) Committee 1205 Tom Hoffman 251  
55 55 Policy and Resources Committee 395 Tom Hoffman 251  
56 56 Port Health & Environmental Services Committee 262 Tom Hoffman 251  
57 57 Reference Sub Committee of the Barbican Centre Board 172 Tom Hoffman 251  
58 58 Board of Governors of the City of London School for Girls 236 Emma Edhem 1458  
59 59 220 Emma Edhem 1458  
60 60 223 Emma Edhem 1458  
61 61 Planning and Transportation Committee 143 Emma Edhem 1458  
62 62 Police Authority Board 142 Emma Edhem 1458  
63 63 Professional Standards and Integrity Committee of the Police Authority Board 398 Emma Edhem 1458  
64 64 Benefices Sub (Culture, Heritage & Libraries) Committee 227 Andrew Stratton McMurtrie 1225  
65 65 223 Andrew Stratton McMurtrie 1225  
66 66 Finance Committee 145 Andrew Stratton McMurtrie 1225  
67 67 Policy and Resources Committee 395 Andrew Stratton McMurtrie 1225  
68 68 220 The Rt. Hon. the Lord Mayor, Alderman Peter Estlin 1419  
69 69 223 The Rt. Hon. the Lord Mayor, Alderman Peter Estlin 1419  
70 70 Education Board 1147 The Rt. Hon. the Lord Mayor, Alderman Peter Estlin 1419  
71 71 Gresham (City Side) Committee 259 The Rt. Hon. the Lord Mayor, Alderman Peter Estlin 1419  
72 72 Lord Mayor's Show Ltd 850 The Rt. Hon. the Lord Mayor, Alderman Peter Estlin 1419  
73 73 Policy and Resources Committee 395 The Rt. Hon. the Lord Mayor, Alderman Peter Estlin 1419  
74 74 The City Bridge Trust Committee 179 The Rt. Hon. the Lord Mayor, Alderman Peter Estlin 1419  
75 75 Board of Governors of the City of London Freemen's School 230 John Bennett 139  
76 76 223 John Bennett 139  
77 77 Culture, Heritage and Libraries Committee 177 John Bennett 139  
78 78 Gresham (City Side) Committee 259 John Bennett 139  
79 79 Port Health & Environmental Services Committee 262 John Bennett 139  
80 80 Barbican Centre Board 140 Wendy Mead 375  
81 81 Committee of Aldermanic Almoners, Common Council Governors and Donation Governors of Christ's Hospital 206 Wendy Mead 375  
82 82 223 Wendy Mead 375  
83 83 Culture, Heritage and Libraries Committee 177 Wendy Mead 375  
84 84 Gresham (City Side) Committee 259 Wendy Mead 375  
85 85 Hampstead Heath, Highgate Wood and Queen's Park Committee 250 Wendy Mead 375  
86 86 Health and Social Care Scrutiny Committee 185 Wendy Mead 375  
87 87 Livery Committee 383 Wendy Mead 375  
88 88 Markets Committee 411 Wendy Mead 375  
89 89 Open Spaces and City Gardens 175 Wendy Mead 375  
90 90 Policy and Resources Committee 395 Wendy Mead 375  
91 91 The City Bridge Trust Committee 179 Wendy Mead 375  
92 92 West Ham Park Committee 400 Wendy Mead 375  
93 93 Academic and Personnel Sub Committee of the Board of Governors of the City of London Freemen's School 213 Roger Arthur Holden Chadwick 158  
94 94 Board of Governors of the City of London Freemen's School 230 Roger Arthur Holden Chadwick 158  
95 95 Board of Governors of the City of London School 233 Roger Arthur Holden Chadwick 158  
96 96 Board of Governors of the City of London School for Girls 236 Roger Arthur Holden Chadwick 158  
97 97 Bursary Committee of the Board of Governors of the City of London Freemen's School 231 Roger Arthur Holden Chadwick 158  
98 98 223 Roger Arthur Holden Chadwick 158  
99 99 Digital Services Sub (Finance) Committee 257 Roger Arthur Holden Chadwick 158  
100 100 Finance Committee 145 Roger Arthur Holden Chadwick 158  

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