colmem: interests: 13 rows where member

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

13 rows where member_id = 1943

Search:

descending

Link	rowid ▼	kind	name	category_id	member_id
1352	1352	member	London Office Managing Partner and UK Vice Chairman Deloitte LLP, 66 Shoe Lane, London, EC4A 3BQ	Employment, office, trade, profession or vocation e938d3aa	Angus Knowles-Cutler 1943
1353	1353	partner	Sales Assistant, Bonhams Auction House, 101 New Bond Street, London	Employment, office, trade, profession or vocation e938d3aa	Angus Knowles-Cutler 1943
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
1355	1355	member	I am a partner of Deloitte LLP which has leaseholds at; 2 New Street Square, 3 New Street Square, Hill House 1 Little New Street, Athene Place 66 Shoe Lane and Stonecutter Court in Stonecutter Street - all in the City of London.	Land d9df90d8	Angus Knowles-Cutler 1943
1356	1356	member	In 2018 Deloitte will occupy 1 New Street Square, London EC4	Licences 613aec30	Angus Knowles-Cutler 1943
1357	1357	member	As above if this includes interests under a Limited Liability Partnership	Securities 4bd97394	Angus Knowles-Cutler 1943
1358	1358	member	Chairman of the Castle Baynard Ward Club	Non-pecuniary interests e9002d25	Angus Knowles-Cutler 1943
1359	1359	member	Liveryman of the Worshipful Company of Gardeners	Non-pecuniary interests e9002d25	Angus Knowles-Cutler 1943
1360	1360	member	Commissioner of the London Skills Commission, organised by London First	Non-pecuniary interests e9002d25	Angus Knowles-Cutler 1943
1361	1361	member	Fellow of the Royal Society of Arts	Non-pecuniary interests e9002d25	Angus Knowles-Cutler 1943
1362	1362	member	ICAEW	Non-pecuniary interests e9002d25	Angus Knowles-Cutler 1943
1363	1363	member	Deputy Chair of the London Economic Action Partnership (the London LEP) and business lead; appointed by the Mayor of London	Non-pecuniary interests e9002d25	Angus Knowles-Cutler 1943
1364	1364	member	Visiting Professor, Centre for the Digital Economy, University of Surrey	Non-pecuniary interests e9002d25	Angus Knowles-Cutler 1943

Advanced export

JSON shape: default, array, newline-delimited

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