colmem

Data source: See col-scraper on GitHub

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidkindnamecategory_idmember_id
176 member Honorary Treasurer of the Guild Church of St Lawrence Jewry e9002d25 158
177 member Chairman of Governors - City of London Freemen's School e9002d25 158
181 member Livery man of the Turners, Coopers and Tallow Chandlers Companies e9002d25 363
182 member Freeman of the Arts Scholars e9002d25 363
183 member Aldersgate Ward Club e9002d25 363
184 member The Royal Soceity of St George City Branch e9002d25 363
185 member City Livery Club e9002d25 363
188 member The Worshipful Company Of Musicians e9002d25 226
189 member The Worshipful Company Of International Bankers e9002d25 226
190 member The Worshipful Company Of Cordwainers e9002d25 226
191 member The Worshipful Company Of Security Profressionals e9002d25 226
192 member The Guild of PR Practitioners e9002d25 226
193 member Freemason e9002d25 226
194 member Royal Society St George City Branch e9002d25 226
195 member United Wards Club e9002d25 226
196 member Trustee - Emanuel Hospital e9002d25 226
197 member Trustee - Mansion House Scholarship Scheme e9002d25 226
198 member Trustee - St Paul's Cathedral School Foundation e9002d25 226
199 member Trustee - St Paul's Cathedral Foundation e9002d25 226
200 member Trustee - Bridewell Royal Hospital e9002d25 226
201 member Trustee - The Lord Mayor's Trust for Charities e9002d25 226
202 member Trustee and Chairman - English Chamber Orchestra and Music Society e9002d25 226
203 member Trustee - Thomas Carpenter Educ and Apprenticing Foundation e9002d25 226
204 member Trustee and Chairman - The Tenebrae Choir e9002d25 226
205 member Trustee and Chairman - City Music Foundation e9002d25 226
206 member Lord Mayor's Appeal Charity e9002d25 226
207 member Trustee - Barbican Centre Trust e9002d25 226
208 member St.Pauls Cathedral Foundation e9002d25 226
209 member English Chamber Orchestra and Music Society Ltd. e9002d25 226
210 member The Tenebrae Chior e9002d25 226
211 member City Music Foundation e9002d25 226
212 member Barbican Centre Trust e9002d25 226
213 member Sedbergh School e9002d25 226
214 member Multrees Investor Services (subsidiary of SERB Pension) e9002d25 226
215 member SEB Life Ireland (related to SEB London) e9002d25 226
217 member Labour Party e9002d25 1213
218 member Community Trade Union e9002d25 1213
219 member Bishopsgate Institute e9002d25 1213
221 member Adviser to the Finance and General Purposes Committee - Walcot Foundation e9002d25 1950
222 member Member - 20th Century Society e9002d25 1950
223 member Member - Barbican Centre e9002d25 1950
224 member Member - The Labour Party e9002d25 1950
225 member Think Tank - Progress e9002d25 1950
226 member Professional Association - Institute of Chartered Accountants Scotland e9002d25 1950
227 member Trade Union membership - Unite e9002d25 1950
231 member Director/Trustee - Exaudi e9002d25 1395
232 member Director/Trustee - Actors Touring Company e9002d25 1395
233 member Trustee - Farringdon Within Ward Trust e9002d25 1395
234 member Member, City Livery Club e9002d25 1395
235 member Member, Farringdon Ward Club e9002d25 1395
236 member Equestrian Order of The Holy Sepulchre of Jerusalem e9002d25 1395
237 member The Military and Hospitaller Order of St. Lazarus of Jerusalem e9002d25 1395
238 member Liveryman, City of London Solicitors' Company e9002d25 1395
239 member Liverymen, Woolmens' Company e9002d25 1395
240 member Member, Countryside Alliance e9002d25 1395
241 member Member, Law Society of England and Wales e9002d25 1395
242 member Member, City of London Law Society e9002d25 1395
243 member Member, Royal Society of St. George e9002d25 1395
244 member Liveryman, Worshipful Company of Distillers e9002d25 1395
245 member Member, City of London Circle, Catenian Association e9002d25 1395
246 member Member, Livery Lounge Party e9002d25 1395
247 member Liveryman, Worshipful Company of Spectacle Makers e9002d25 1395
248 member Member, City Pickwick Club e9002d25 1395
249 member Member, GB Executive, Co-operation Ireland e9002d25 1395
258 member Association of Certified Chartered Accountants (ACCA) e9002d25 1946
259 member Institute of Leadership and Management (ILM) e9002d25 1946
260 member Member, Society of Local Authority Chief Executives (SOLACE) e9002d25 1946
261 member Co-Founder, City Commonwealth Economic Forum e9002d25 1946
262 member Trustee, South London Anglo Indian Association e9002d25 1946
263 member Member, Chartered Institute of Securities and Investment (CISI) e9002d25 1946
264 member Member, UNISON e9002d25 1946
265 member Member, Clapham Old Xaverians e9002d25 1946
266 member Brother of the Cantenians e9002d25 1946
267 member Member, Aldgate Ward Club e9002d25 1946
271 member DIRECTOR, HEATHBANK MANAGEMENT e9002d25 1229
272 member DIRECTOR, BABY FUND TRADING LTD e9002d25 1229
273 member DIRECTOR, COMPEER e9002d25 1229
274 member MEMBER, CONSERVATIVE & UNIONIST PARTY e9002d25 1229
275 member FREEMASON OF TWO LODGES AND ONE CHAPTER e9002d25 1229
276 member MEMBER, SPECULATIVE SOCIETY OF EDINBURGH e9002d25 1229
277 member LIVERYMAN, DRAPERS' COMPANY e9002d25 1229
278 member MEMBER, VINTRY & DOWGATE WARD CLUBS e9002d25 1229
279 member MEMBER, BRITISH CZECH-SLOVAKIAN ASSOCIATION e9002d25 1229
280 member MEMBER, OGNISKIE POLSKIE e9002d25 1229
281 member MEMBER, ANGLO-CHILEAN SOCIETY e9002d25 1229
282 member MEMBER, OLD KIRKHAMIAN ASSOCIATION e9002d25 1229
283 member MENTOR, GREENWICH EDUCATIONAL TRUST e9002d25 1229
284 member COMMUNICANT MEMBER OF THE CHURCH OF ENGLAND e9002d25 1229
285 member TRUSTEE, CITY & METROPOLITAN CHARITY e9002d25 1229
290 member Member, the Honourable Society of the Inner Temple. e9002d25 1947
291 partner My husband is a member of Unite. e9002d25 1947
292 member Supporter of the Bar Council through payment of a voluntary fee. e9002d25 1947
293 member Member of the Management Committee of the Chambers of Sir Edward Garnier QC MP. e9002d25 1947
299 member Associate, Chartered Institute of Securities and Investment e9002d25 1951
300 member Member - Cordwainer Ward Club e9002d25 1951
301 member Member – Bread Street Ward Club e9002d25 1951
302 member Director -Sapphire IV (Investments) Ltd, 1 Le Truchot, St. Peter Port, Guernsey. GY1 1WD e9002d25 1951
303 member Trustee, Thomas Carpenter's Trust (The Thomas Carpenter Educational and Apprenticing Foundation) e9002d25 1951
304 member Freeman, Worshipful Company of Ironmongers e9002d25 1951
305 member Director - Aberdeen Sapphire IV Ltd, 1 Le Truchot, St. Peter Port, Guernsey. GY1 1WD e9002d25 1951
306 member Director - Sapphire (Investments) II Ltd, 1 Le Truchot, St. Peter Port, Guernsey. GY1 1WD e9002d25 1951