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

30 rows where member_id = 1224

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
368 368 member Landlord (carried on in my own name) Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
369 369 partner Employee of Capital International Ltd of 40 Grosvenor Place, London, SW1X 7GG Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
370 370 member Trustee Member - Clockwork Pharmacy Group SSAS Chalfont Court, Hill Avenue, Amersham HP6 5BB Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
371 371 member Partner - Clockwork Underwriting LLP (an admitted underwriting member of The Society of Lloyd's and capital provider to a number of syndicates open to third parties) 3 Catlegate, Grantham, Lincolnshire NG31 6SF Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
372 372 member Company Secretary, shareholder - Clockwork Retail Ltd 215-217 Victoria Park Road, London E9 7HD Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
373 373 member Company Secretary - Clockwork Pharmacy Ltd 215-217 Victoria Park Road, London E9 7HD Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
374 374 member Partner - Clockwork Hotels LLP 215-217 Victoria Park Road, London E9 7HD Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
375 375 member Director, shareholder - D P Facility Management Limited 334-336 Goswell Road, London EC1V 7RP Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
376 376 member Director, shareholder - Clockwork Farms Limited 215-217 Victoria Park Road, London E9 7HD Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
377 377 member Company Secretary - P & A Developments (London) Ltd, 215-217 Victoria Park Road, London E9 7HD Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
378 378 member Clockwork Retail Ltd Sponsorship d9d60c21 Dhruv Patel 1224
379 379 member 8/9 Ludgate Square, London, EC4M 7AS Land d9df90d8 Dhruv Patel 1224
380 380 member Shareholder in various other listed securities but none which exceeds value of £25,000 or constitutes more than 1% of the total issued share capital of the issuing company Securities 4bd97394 Dhruv Patel 1224
381 381 member Fundsmith LLP Equity Fund T Class Accumulation GBP Securities 4bd97394 Dhruv Patel 1224
382 382 member Director - City Hindus Network Non-pecuniary interests e9002d25 Dhruv Patel 1224
383 383 member Member - Aldgate Ward Club Non-pecuniary interests e9002d25 Dhruv Patel 1224
384 384 member Life Member - City & Guilds College Association Non-pecuniary interests e9002d25 Dhruv Patel 1224
385 385 member Trustee - The Lord Mayor's 800th Anniversary Awards Trust - St Botolph's Church, Aldgate High Street ,London EC3N 1AB Non-pecuniary interests e9002d25 Dhruv Patel 1224
386 386 member Liveryman, Member of Property Committee - The Worshipful Company of Clothworkers Non-pecuniary interests e9002d25 Dhruv Patel 1224
387 387 member Member - Diversity (UK) Non-pecuniary interests e9002d25 Dhruv Patel 1224
388 388 member Member - Institution of Engineering and Technology Non-pecuniary interests e9002d25 Dhruv Patel 1224
389 389 member Associate - City & Guilds of London Institute Non-pecuniary interests e9002d25 Dhruv Patel 1224
390 390 member Member (lapsed) - Chartered Insurance Institute Non-pecuniary interests e9002d25 Dhruv Patel 1224
391 391 member Member - Association of Lloyd’s Members (ALM Ltd) Non-pecuniary interests e9002d25 Dhruv Patel 1224
392 392 member Member - High Premium Group Non-pecuniary interests e9002d25 Dhruv Patel 1224
393 393 member Court Assistant - The Society of Young Freemen, Guildhall, PO Box 270, Gresham Street, London EC2P 2EJ Non-pecuniary interests e9002d25 Dhruv Patel 1224
394 394 member Member - Chartered Association of Building Engineers Lutyens House, Billing Brook Road, Northampton NN3 8NW Non-pecuniary interests e9002d25 Dhruv Patel 1224
395 395 member Chairman of Governors, Avanti Court Primary School, Carlton Drive Ilford IG6 1LZ Non-pecuniary interests e9002d25 Dhruv Patel 1224
396 396 member Member, Treasurer of U40s Section, City Livery Club, Bell Wharf Lane, Upper Thames Street London EC4R 3TB Non-pecuniary interests e9002d25 Dhruv Patel 1224
397 397 member Director - City of London Academies Trust, Guildhall PO Box 270 Gresham Street, London EC2P 2EJ Non-pecuniary interests e9002d25 Dhruv Patel 1224

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