colmem

Data source: See col-scraper on GitHub

Custom SQL query returning 35 rows (show)

Query parameters

This data as json, CSV

rowidkindnamecategory_idmember_id
10 member CMS Cameron McKenna has a Leasehold interest in a property in Canon Street. 8948e857 396
180 member Property in Mountjoy House, Barbican, London EC2 8948e857 363
229 member 3 Noble Street, London EC2 8948e857 1395
230 member One London Wall, London EC2 8948e857 1395
447 member Hiscox property rental across multiple sites within the City. 8948e857 2259
473 member Lease of Offices at Chronicle House, 72-74 Fleet Street, London EC4 to International Dispute Resolution Centre Limited 8948e857 397
525 member Via Janus Henderson Group PLC 8948e857 1658
564 member London Councils 8948e857 373
565 member TheCityUK, Finsbury Circus, EC2M 8948e857 373
635 member This is a Sensitive Interest, the details of which are withheld under Section 32 of the Localism Act 2011 8948e857 1937
636 partner This is a Sensitive Interest, the details of which are withheld under Section 32 of the Localism Act 2011 8948e857 1937
646 member Company Member of Sarasin & Partners LLP and the firm leases Juxon House, 100 St Paul's Churchyard, London, EC4M 8BU. 8948e857 1472
745 member Tenant at 301 Gilbert House, Barbican. London. EC2Y 8BD. 8948e857 2224
746 partner Tenant at 301 Gilbert House, Barbican. London. EC2Y 8BD. 8948e857 2224
774 member Lease from City of London Corporation dated 27.10.16 of office at 5 London Wall Buildings, London EC2M 5NS for 2 years from 29.9.2014 at a rent of £6862 pa plus service charge, insurance and VAT 8948e857 256
878 member G Lawrence Wholesale Meats Ltd 23 East Market building London Central Markets london EC1 A 9PQ 8948e857 276
879 member Smithfield Market Tenants' Association 225 Central markets London EC1A 9LH 8948e857 276
939 member 20, 22, 217/218 Central Markets, Smithfield, EC1 8948e857 131
976 member 2/4 & 25 LONDON CENTRAL MARKETS SMITHFIELD 8948e857 1217
977 partner 2/4 & 25 LONDON CENTRAL MARKETS SMITHFIELD 8948e857 1217
978 member 225 LONDON CENTRAL MARKETS (TREASURER & TRUSTEE OF SMTA) 8948e857 1217
979 partner 206 LONDON CENTRAL MARKETS SMITHFIELD 8948e857 1217
980 partner 210 - 213 LONDON CENTRAL MARKETS SMITHFIELD 8948e857 1217
1038 member 80% Leaseholder 815 Frobisher Crescent, London, EC2Y 8HD 8948e857 1958
1039 partner 20% Leaseholder 815 Frobisher Crescent, London, EC2Y 8HD 8948e857 1958
1123 member Tenant Barrister at Pump Court Temple 8948e857 1935
1344 member None other than through the Mercers Company or investment portfolios managed on a discretionary basis. 8948e857 1955
1375 member 42 BRETON HOUSE, LONDON EC2Y 8DQ 8948e857 1227
1440 member 90 Defoe House, Barbican, London. EC2Y 8ND 8948e857 382
1449 member 212 QUEEN'S QUAY, 58 UPPER THAMES STREET, LONDON. EC4V 3EJ. 8948e857 269
1468 partner Flat 409, Queen's Qauy, 58 Upper Thames Street, London, EC4 8948e857 402
1605 member Chartered Institute for Securities & Investment, Eastcheap, EC3 8948e857 399
1716 member 58 Andrewes House, Barbican, London. EC2Y 8AX 8948e857 287
1799 member Noble Street, London EC2 (DLA Piper) 8948e857 229
1800 member London Wall, London EC2 (DLA Piper) 8948e857 229