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
1180 partner 133 Cromwell Tower, Barbican, EC2Y 8DD d9df90d8 392
977 partner 2/4 & 25 LONDON CENTRAL MARKETS SMITHFIELD 8948e857 1217
971 partner 2/4 SMITHFIELD d9df90d8 1217
1039 partner 20% Leaseholder 815 Frobisher Crescent, London, EC2Y 8HD 8948e857 1958
1777 partner 202 Cromwell Tower, Barbican, EC2 d9df90d8 141
973 partner 206 LONDON CENTRAL MARKETS d9df90d8 1217
979 partner 206 LONDON CENTRAL MARKETS SMITHFIELD 8948e857 1217
980 partner 210 - 213 LONDON CENTRAL MARKETS SMITHFIELD 8948e857 1217
975 partner 210-213 LONDON CENTRAL MARKETS d9df90d8 1217
969 partner 25 LCM, SMITHFIELD d9df90d8 1217
838 partner 48 Andrewes House, London EC2Y 8AX (leaseholder) d9df90d8 1957
1208 partner Address at Wormwood Street, London EC2 d9df90d8 151
1556 partner Aldgate Freedom Foundation e9002d25 265
1105 partner Andrewes House, Barbican, London. EC2Y 8AX d9df90d8 296
437 partner Artist, Church Road, Woldingham, CR3 7JX. e938d3aa 2259
1122 partner Associate Director, Youth Chamber Orchestra e938d3aa 1935
914 partner Aviva 4bd97394 1202
931 partner Baycrest Developments Ltd. e938d3aa 131
933 partner Baycrest Properties Ltd. e938d3aa 131
443 partner Beneficiary, Matterhorn Trust e938d3aa 2259
1633 partner CEO, Incom Tours and Events e938d3aa 225
295 partner Caterer - periodic event catering e938d3aa 1951
588 partner Catherine Mary Birch (Kate Birch) - NIL e938d3aa 1757
552 partner Chairman, Cripplegate Foundation - which is in receipt of a £141,000 grant (over three years, 2017-2020) from The City Bridge Trust to tackle poverty and isolation among Islington's older people. e938d3aa 373
439 partner Chairman, Heptogon Assets Ltd, Church Road, Woldingham. CR3 7JX e938d3aa 2259
441 partner Chairman, Heptogon BIR Ltd, Church Road, Woldingham. CR3 7JX e938d3aa 2259
1046 partner Charles Stanley Group PLC 4bd97394 255
187 partner City Music Foundation e938d3aa 226
1862 partner City University e938d3aa 213
1737 partner City of London Club (Freehold held) - Committee Member 613aec30 511
324 partner Civil Servant, CFTC, Three Lafayette Centre, 1155 21st Street, NW Washington, DC 20581 e938d3aa 374
405 partner Clarkson PLC 4bd97394 207
1118 partner Classical Musican e938d3aa 1935
1713 partner Co-Director - Nigerian Duty-Free Shop, Lagos, Nigeria e938d3aa 287
1652 partner Company Secretary and Shareholder - Almroth Enterprises Ltd, Asserton House, Berwick St James, Salisbury, Wiltshire SP3 4TZ e938d3aa 1210
740 partner Creative Copywriter at M-Is, Church St, Isleworth. TW7 6DA e938d3aa 2224
682 partner DB X-tracker Global Select Dividend Fund 4bd97394 257
967 partner DIRECTOR P J MARTINELLI LTD e938d3aa 1217
888 partner DIRECTOR, C.L. EAGLEN LTD e938d3aa 1202
882 partner DIRECTOR, GONVILLE HOTEL, GRESHAM HOUSE, GONVILLE PLACE, CB1 1CY e938d3aa 1202
890 partner DIRECTOR, RIDGEON ESTATE COMPANY LTD e938d3aa 1202
886 partner DIRECTOR, VENTRESS PROPERTY DEVELOPMENT LTD, GRESHAM HOUSE, GONVILLE PLACE CB1 1LY e938d3aa 1202
1381 partner Dhiren Doshi, Director of DPR WHOLESALERS LIMITED, and of RENRICK PRODUCTS LIMITED e938d3aa 1231
1568 partner Director - Intueri e938d3aa 2186
1366 partner Director - Team IT Solutions Limited, 24 Layton Road, Hounslow. TW3 1YH e938d3aa 1948
1399 partner Director Nymph Limited, Basinghall Street London EC2V 5AY e938d3aa 1323
553 partner Director and 50% shareholder – M&G Advisory Services Limited e938d3aa 373
554 partner Director – St Ethelburga’s Centre (Trading) Limited (a wholly owned subsidiary of St Ethelburga’s Centre for Reconciliation and Peace) e938d3aa 373
832 partner Director, Absalom Properties Ltd, Sevenoaks TN15 8PZ e938d3aa 132
1202 partner Director, Hampden and Co e938d3aa 151
1251 partner Director, Mr Pilates Limited London SE1 e938d3aa 1666
1622 partner Director, Spice Island Poultry Group Ltd (dormant), Interoceanic Building, Shangani, Zanzibar e938d3aa 264
633 partner Employee - Zest Food Ltd e938d3aa 1937
369 partner Employee of Capital International Ltd of 40 Grosvenor Place, London, SW1X 7GG e938d3aa 1224
1783 partner Employee, Universal Aunts, Talfourd Road, SE15 e938d3aa 291
1401 partner Entryway Limited Wellkit Property Management Limited Z/Yen Contents Limited e938d3aa 1323
456 partner Ex-Officio Committee Member, Broad Street Ward Club e9002d25 401
922 partner FARMERS LIVERY COMPANY e9002d25 1202
800 partner FLAT 5, 7 LOTHBURY CITY OF LONDON LONDON EC2R 7AP d9df90d8 1218
1842 partner Flat 1, 43 Bartholomew Close, EC1A 7HN d9df90d8 1230
1195 partner Flat 21 Tudor Rose Court, 35 Fann Street, London EC2Y 8DY d9df90d8 1888
1468 partner Flat 409, Queen's Qauy, 58 Upper Thames Street, London, EC4 8948e857 402
472 partner Flat 81, 172 Aldersgate Street, EC1A 4HV d9df90d8 397
563 partner Flat at Bartholomew Close, EC1 d9df90d8 373
561 partner Flat at Bryer Court, Barbican, EC2 d9df90d8 373
1031 partner Flat within 14 Victoria House, EC4Y 0DD d9df90d8 1221
622 partner Freehold Townhouse, EC2 d9df90d8 133
1506 partner Friend of Guildhall Art Gallery e9002d25 137
902 partner Glaxo Smithkline 4bd97394 1202
577 partner Governor (chair of governors) – Drayton Park Primary School e9002d25 373
480 partner Governor and Member, Advisory Council of Goodenough College e9002d25 397
569 partner Governor – Cripplegate Foundation e9002d25 373
575 partner Governor – St John’s Highbury Vale CofE Primary School e9002d25 373
78 partner Healthcare Assistant e938d3aa 380
1710 partner Helen Mayer StandUp4Brexit 77 Victoria Street London SW1H 0HW e938d3aa 1945
165 partner Honorary Ward Clerk, City of London Corporation, EC2P 2EJ e938d3aa 158
1656 partner I have various pensionand ISA investments which have holdings that may exceed £2,500 in various unit and investment trusts, or similar type funds which may have a place of business or land ownership within the City. All our investments are managed by professional third party managers and I have limited ability to know or find out exactly what is held at any one time. 4bd97394 1210
900 partner Imperial Brands 4bd97394 1202
1816 partner Implementation Director, Codwellers.com Limited, London, SW1 e938d3aa 383
1120 partner Instrumental Professor at Royal Academy of Music e938d3aa 1935
1121 partner Instrumental Staff at Purcell School e938d3aa 1935
2 partner Investments in professionally managed funds and venture capital trusts which may have a connection with the City 4bd97394 1659
109 partner Jagex Games Studio, Cambridge Sciene Park, 220 Milton CB4 0WA e938d3aa 1458
884 partner KEXBY FARM ING/ ABINGTON FARMS LTD, ABINGTON PARK FARM, CAMBRIDGE CB21 6AX e938d3aa 1202
296 partner Landlord - ownership and management of a freehold property in North Yorkshire. e938d3aa 1951
817 partner Leasehold property in London EC2 d9df90d8 1941
1504 partner Lessee of property at Cromwell Tower, Barbican, EC2 d9df90d8 137
1515 partner Livery Member, Coopers e9002d25 137
327 partner Liveryman of Painter Stainers 9 Little Trinity Ln, London EC4V 2AD d9df90d8 374
458 partner Liveryman of the Worshipful Company of Arts Scholars e9002d25 401
462 partner Liveryman of the Worshipful Company of Stationers and Newspaper Makers e9002d25 401
476 partner Liveryman, Worshipful Company of Educators e9002d25 397
475 partner Liveryman, Worshipful Company of Masons e9002d25 397
556 partner Long Lease of Barbican Flat, EC2 32767bc8 373
1467 partner Long lease - Floor 409, Queen's Quay, Upper Thames Street, London EC4 d9df90d8 402
57 partner Longbow Capital LLP - Partner e938d3aa 2034
1723 partner MWR InfoSecurity Ltd - Consultant (Global Operational Psychologist) e938d3aa 511
453 partner Managing Director, Historystore Ltd, Dorset e938d3aa 401
254 partner Marketing Coordinator, Sidley Austin LLP, Woolgate Exchange, 25 Basinghall Street, London, EC2V 5HA e938d3aa 1946
708 partner Medical Director for Clinical Effectiveness NHS ENGLAND e938d3aa 1223
638 partner Member - The Labour Party e9002d25 1937