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
3 member Fellow, Chartered Institute of Taxation e9002d25 1659
4 member Liveryman, Worshipful Company of Scriveners e9002d25 1659
5 member Committee Member, Bassishaw Ward Club e9002d25 1659
6 member Member, City University Club e9002d25 1659
14 member Trustee, Science Museum Group e9002d25 396
15 member Lord Mayor's Appeal e9002d25 396
16 member City Livery Club e9002d25 396
17 member Candlewick Ward Club e9002d25 396
18 member Farringdon Ward Club e9002d25 396
19 member Livery Companies - Solicitors, Plumbers, Wax Chandlers, Arbitrators, Builders' Merchants, Paviors, Fuellers, Lightmongers, Turners, Tax Advisers and Security Professionals e9002d25 396
20 member Member, The Law Society of England and Wales e9002d25 396
21 member Member, Aldersgate Group e9002d25 396
22 member Member, Middle Temple e9002d25 396
23 member Trustee, Wexford Festival Opera (UK) e9002d25 396
69 member East Anglia Art Fund e9002d25 2034
70 member The King's School, Canterbury e9002d25 2034
71 member Saint Columba's College, Dublin e9002d25 2034
72 member MEMH Trust e9002d25 2034
73 member London Music Masters e9002d25 2034
74 member St Dunstan's College e9002d25 2034
75 member Merchant Taylors' Company (Livery Company) e9002d25 2034
76 member Chartered Insurance Institute (Membership of professional association) e9002d25 2034
77 member Chairman of Longbow Capital LLP (non-remunerated directorship) e9002d25 2034
86 member Liveryman of the Worshipful Company of Management Consultants e9002d25 380
87 member Liveryman of the Worshipful Company of Makers of Playing Cards e9002d25 380
88 member Master Mason of the Guildhall Lodge of Freemasons e9002d25 380
89 member Chairman of Osprey Lodges Ltd e9002d25 380
90 member Contracted occasionally by TORI Global e9002d25 380
92 member Trustee, Corporation of the Sons and Friends of the Clergy, London e9002d25 251
93 member Chairman, Stour Festival Company Limited, Kent e9002d25 251
94 member Hon. Auditor, John Mayne Charity, Biddenden e9002d25 251
95 member Hon. Treasurer, Guildhall Historical Association e9002d25 251
96 member Hon. Treasurer and Past Chairman, Cordwainer Ward Club e9002d25 251
97 member Past Chairman, Vintry and Dowgate Wards Club e9002d25 251
98 member Life Member, City Livery Club e9002d25 251
99 member Life Member, Guild of Freemen of the City of London e9002d25 251
100 member Past Master, Lodge of Antiquity, No. 2 in the United Grand Lodge of England e9002d25 251
101 member Past Master, Worshipful Company of Tylers and Bricklayers e9002d25 251
102 member Fellow of the Institute of Chartered Accountants in England and Wales e9002d25 251
103 member Hon. Vice President, Portuguese Chamber of Commerce and Industry e9002d25 251
104 member Governor, Guy's and St Thomas' NHS Foundation Trust e9002d25 251
105 member Chairman, Caspian Sea Capital Limited e9002d25 251
106 member Director, Tower Bridge Square Management Limited e9002d25 251
107 member Partner, Tower Bridge consulting e9002d25 251
111 member City of London Committee of the Red Cross e9002d25 1458
112 member Royal Bridewell Hospital e9002d25 1458
113 member British Azerbaijan Law Association e9002d25 1458
114 member Board of the UK Hungarian Business Council e9002d25 1458
115 member Christ’s Hospital e9002d25 1458
116 member Board of Turkish British Chamber of Commerce and Industry e9002d25 1458
117 member City Giving Day e9002d25 1458
118 member Court Assistant of the Woolmen e9002d25 1458
119 member Liveryman, Salters' Company e9002d25 1225
120 member Member, Coleman Street Ward Club e9002d25 1225
121 member Member, Parish Clerks' Company e9002d25 1225
122 member Director, Stanstead Lodge Senior Club e9002d25 1225
123 member Director, City of London Academies Trust e9002d25 1225
124 member Magistrate, Central London Bench e9002d25 1225
125 member Diocesan Council of Trustees for Southwark Diocese e9002d25 1225
126 member Chairman of the Investment Committee for Southwark Diocese e9002d25 1225
127 member Member, Conservative Party e9002d25 1225
132 member Trustee, Bridewell Royal Hospital e9002d25 1419
134 member Member, Walbrook Club e9002d25 1419
135 member International Bankers e9002d25 1419
136 member Chartered Accountants e9002d25 1419
137 member Educators e9002d25 1419
138 member Ironmongers e9002d25 1419
139 member Human Resource Professionals e9002d25 1419
140 member Professional Association - ICAEW e9002d25 1419
141 member Trsut for London (City resident) e9002d25 1419
142 member Morden College, Trustee e9002d25 1419
143 member Member, Brand Finance e9002d25 1419
144 member Trustee: Lord Mayor's 800th Anniversary Awards Trust e9002d25 139
145 member Trustee: Charity of Mary Barnes e9002d25 139
146 member Trustee: The F.E. Clearly St Margaret Lothbury Church Trust e9002d25 139
147 member Broad Street Ward Club e9002d25 139
148 member Worshipful Company of International Bankers Liveryman e9002d25 139
149 member Institute of Chartered Accountants in England and Wales e9002d25 139
150 member Chartered Institute of Securities and Investments e9002d25 139
151 member Chartered Management Institution e9002d25 139
152 member Institute of Directors e9002d25 139
153 member Coordinator, Bart's Hospital Volunteers e9002d25 375
154 member Board of Management, Bart's Guild (League of Friends) e9002d25 375
155 member Friends of Bart's Great Hall and Archives e9002d25 375
156 member Trustee, Housing the Homeless Central Fund e9002d25 375
157 member Member, City Livery Club e9002d25 375
158 member Member, Aldersgate Ward Club e9002d25 375
159 member Member, Farringdon Ward Club e9002d25 375
160 member Member, London Historical Society e9002d25 375
161 member Associate Member, City of London 600 Squadron Association e9002d25 375
162 member Member, Sheriffs & Recorder's Fund e9002d25 375
163 member Member, City of London Heritage Society e9002d25 375
169 member Tower Ward Club e9002d25 158
171 member Freemason e9002d25 158
172 member Liveryman Worshipful Company of Bowyers e9002d25 158
173 member Liveryman Worshipful Company of World Traders e9002d25 158
174 member Member of the Guild Church of St Lawrence Jewry e9002d25 158
175 member Trustee of The Honourable The Irish Society e9002d25 158
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