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

20 rows where category_id = "32767bc8"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, name, member_id

Link rowid ▼ kind name category_id member_id
8 8 member CMS Cameron McKenna Nabarro Olowang has provided legal advice to the City of London Corporation and may do so again in the future. Contracts 32767bc8 Dame Fiona Woolf 396
28 28 member Bridge House Estates provides grant support to Trust for London of which I am a Trustee, nominated by the Corporation. Contracts 32767bc8 Edward Lord 292
129 129 member King Edward's School, Witley - Treasury and Cash Management with City of London Corporation Contracts 32767bc8 The Rt. Hon. the Lord Mayor, Alderman Peter Estlin 1419
168 168 member Co-operation Ireland - Chairman of GB Executive Contracts 32767bc8 Roger Arthur Holden Chadwick 158
454 454 member Historystore Ltd has a contract for the provision of antique documents and reproduction menus[ Contracts 32767bc8 John George Stewart Scott 401
470 470 member Lease of Offices at Chronicle House, 72-74 Fleet Street, London EC4 to International Dispute Resolution Centre Limited Contracts 32767bc8 Sir David Hugh Wootton 397
555 555 member Long Lease of Barbican Flat, EC2 Contracts 32767bc8 Catherine McGuinness 373
556 556 partner Long Lease of Barbican Flat, EC2 Contracts 32767bc8 Catherine McGuinness 373
557 557 member London and Partners (unpaid) Contracts 32767bc8 Catherine McGuinness 373
558 558 member TheCityUK (unpaid) Contracts 32767bc8 Catherine McGuinness 373
559 559 member London Councils (unpaid) Contracts 32767bc8 Catherine McGuinness 373
619 619 member Service Charges in respect of property at EC2 Contracts 32767bc8 Nicholas Anstee 133
620 620 partner Service Charges in respect of property at EC2 Contracts 32767bc8 Nicholas Anstee 133
772 772 member Lease from City of London Corporation dated 27.10.16 (further details contained under Corporate Tenancies) Contracts 32767bc8 Michael Hudson 256
1220 1220 member Director and Trustee- Crossrail Arts Foundation (25 Canada Square, E14) Contracts 32767bc8 Sir Michael Snyder 385
1354 1354 member Deloitte LLP is being contracted by the City of London Police to conduct a business review Contracts 32767bc8 Angus Knowles-Cutler 1943
1577 1577 member CONTRACT FOR REFURBISHMENT OF BUILDING IN GREAT ARTHUR HOUSE (CONTRACT DUE TO START JAN 2015 WITH CONTRACT VALUE OF £5.9M) - FORMER GROUP COMPANY WAS SOLD ON 30 APRIL 2017 Contracts 32767bc8 James Michael Douglas Thomson 1207
1688 1688 member Centre for London - Director (unpaid) Contracts 32767bc8 Sir Mark Boleat 136
1689 1689 member Crossrail Art Foundation - Director (unpaid) Contracts 32767bc8 Sir Mark Boleat 136
1690 1690 member London Councils Pensions Collective Investment Vehicle Joint Committee (unpaid) Contracts 32767bc8 Sir Mark Boleat 136

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");