interests

Interests for members and their partners ('Spouse/Civil Partner/Living as such') from the Register of Interests.

Data source: See col-scraper on GitHub

28 rows where category_id = "8948e857" and kind = "member"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: member_id

Link rowid ▼ kind name category_id member_id
10 10 member CMS Cameron McKenna has a Leasehold interest in a property in Canon Street. Corporate Tenancies 8948e857 Dame Fiona Woolf 396
180 180 member Property in Mountjoy House, Barbican, London EC2 Corporate Tenancies 8948e857 Barbara Patricia Newman 363
229 229 member 3 Noble Street, London EC2 Corporate Tenancies 8948e857 Sheriff Vincent Thomas Keaveny 1395
230 230 member One London Wall, London EC2 Corporate Tenancies 8948e857 Sheriff Vincent Thomas Keaveny 1395
447 447 member Hiscox property rental across multiple sites within the City. Corporate Tenancies 8948e857 Bronek Masojada 2259
473 473 member Lease of Offices at Chronicle House, 72-74 Fleet Street, London EC4 to International Dispute Resolution Centre Limited Corporate Tenancies 8948e857 Sir David Hugh Wootton 397
525 525 member Via Janus Henderson Group PLC Corporate Tenancies 8948e857 James de Sausmarez 1658
564 564 member London Councils Corporate Tenancies 8948e857 Catherine McGuinness 373
565 565 member TheCityUK, Finsbury Circus, EC2M Corporate Tenancies 8948e857 Catherine McGuinness 373
635 635 member This is a Sensitive Interest, the details of which are withheld under Section 32 of the Localism Act 2011 Corporate Tenancies 8948e857 Jason Paul Pritchard 1937
646 646 member Company Member of Sarasin & Partners LLP and the firm leases Juxon House, 100 St Paul's Churchyard, London, EC4M 8BU. Corporate Tenancies 8948e857 Nicholas Michael Bensted-Smith 1472
745 745 member Tenant at 301 Gilbert House, Barbican. London. EC2Y 8BD. Corporate Tenancies 8948e857 Natasha Maria Cabrera Lloyd-Owen 2224
774 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 Corporate Tenancies 8948e857 Michael Hudson 256
878 878 member G Lawrence Wholesale Meats Ltd 23 East Market building London Central Markets london EC1 A 9PQ Corporate Tenancies 8948e857 Gregory Alfred Lawrence 276
879 879 member Smithfield Market Tenants' Association 225 Central markets London EC1A 9LH Corporate Tenancies 8948e857 Gregory Alfred Lawrence 276
939 939 member 20, 22, 217/218 Central Markets, Smithfield, EC1 Corporate Tenancies 8948e857 George Christopher Abrahams 131
976 976 member 2/4 & 25 LONDON CENTRAL MARKETS SMITHFIELD Corporate Tenancies 8948e857 Paul Nicholas Martinelli 1217
978 978 member 225 LONDON CENTRAL MARKETS (TREASURER & TRUSTEE OF SMTA) Corporate Tenancies 8948e857 Paul Nicholas Martinelli 1217
1038 1038 member 80% Leaseholder 815 Frobisher Crescent, London, EC2Y 8HD Corporate Tenancies 8948e857 Mark Bostock 1958
1123 1123 member Tenant Barrister at Pump Court Temple Corporate Tenancies 8948e857 William Upton QC 1935
1344 1344 member None other than through the Mercers Company or investment portfolios managed on a discretionary basis. Corporate Tenancies 8948e857 Thomas Cowley Clementi 1955
1375 1375 member 42 BRETON HOUSE, LONDON EC2Y 8DQ Corporate Tenancies 8948e857 Randall Keith Anderson 1227
1440 1440 member 90 Defoe House, Barbican, London. EC2Y 8ND Corporate Tenancies 8948e857 Joyce Carruthers Nash 382
1449 1449 member 212 QUEEN'S QUAY, 58 UPPER THAMES STREET, LONDON. EC4V 3EJ. Corporate Tenancies 8948e857 Alastair John Naisbitt King 269
1605 1605 member Chartered Institute for Securities & Investment, Eastcheap, EC3 Corporate Tenancies 8948e857 Sir Alan Colin Drake Yarrow 399
1716 1716 member 58 Andrewes House, Barbican, London. EC2Y 8AX Corporate Tenancies 8948e857 Vivienne Littlechild 287
1799 1799 member Noble Street, London EC2 (DLA Piper) Corporate Tenancies 8948e857 Alison Gowman 229
1800 1800 member London Wall, London EC2 (DLA Piper) Corporate Tenancies 8948e857 Alison Gowman 229

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE interests (
        kind VARCHAR(10),
        name TEXT,
        category_id VARCHAR(8) REFERENCES interest_categories(id),
        member_id INTEGER REFERENCES members(id)
    );
CREATE INDEX interests_category_id ON interests("category_id");
CREATE INDEX interests_member_id ON interests("member_id");