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

16 rows where category_id = "e9002d25" and member_id = 1224

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ kind name category_id member_id
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");