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

54 rows where member_id = 397

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
469 469 member Director, Local Partnerships LLP, Local Government House, Smith Square, SW1P 3HZ Employment, office, trade, profession or vocation e938d3aa Sir David Hugh Wootton 397
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
471 471 member 999 year lease and share of freehold of Flat 81, 172 Aldersgate Street, EC1A 4HV Land d9df90d8 Sir David Hugh Wootton 397
472 472 partner Flat 81, 172 Aldersgate Street, EC1A 4HV Land d9df90d8 Sir David Hugh Wootton 397
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
474 474 member Director, Local Partnerships LLP Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
475 475 partner Liveryman, Worshipful Company of Masons Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
476 476 partner Liveryman, Worshipful Company of Educators Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
477 477 member Director, Northern Ballet Ltd Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
478 478 partner Member, Langbourn Ward Club Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
479 479 member Director, TheCityUK Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
480 480 partner Governor and Member, Advisory Council of Goodenough College Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
481 481 member Director, Charles Dickens Museum Ltd Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
482 482 member Member, City Livery Club Ltd Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
483 483 member Director, City Arts Trust Ltd Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
484 484 member Director, SBJBC UK Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
485 485 member Director, The International Dispute Resolution Centre Ltd Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
486 486 member Director, Global Law Summit Ltd Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
487 487 member Member, Guild of Freemen of the City of London Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
488 488 member Trustee of The King’s Fund Staff Pension and Life Assurance Plan Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
489 489 member Trustee, National Opera Studio Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
490 490 member Trustee, Steve Fairbairn Memorial Trust Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
491 491 member Trustee, Jesus College Boat Club Trust Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
492 492 member Trustee, Jesus College Cambridge Society Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
493 493 member Trustee, Lord Mayor's 800th Anniversary Trust Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
494 494 member Trustee, Morden College Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
495 495 member Trustee, Gad's Hill Heritage Centre Trust and Director, Charles Dickens Centre (Gad's Hill) Limited Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
496 496 member Trustee, Oxford and Cambridge Rowing Foundation Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
497 497 member Trustee, Cross-Sector Safety and Security Communications Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
498 498 member Vice President, King Edward's School, Witley Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
499 499 member Governor, Bradford Grammar School Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
500 500 member Steward, Henley Royal Regatta Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
501 501 member Member, Institute of Directors, City of London Branch Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
502 502 member Liveryman, Worshipful Company of Fletchers Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
503 503 member Liveryman, Worshipful Company of Information Technologists Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
504 504 member Liveryman and Master, Worshipful Company of Glaziers and Painters of Glass Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
505 505 member Liveryman, Worshipful Company of Clockmakers Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
506 506 member Liveryman, Worshipful Company of Bowyers Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
507 507 member Liveryman, Worshipful Company of Woolmen Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
508 508 member Liveryman, City of London Solicitors Company Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
509 509 member Honorary Liveryman, Worshipful Company of Security Professionals Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
510 510 member Freeman, Company of Watermen and Lightermen Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
511 511 member Member, Aldgate Ward Club Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
512 512 member Member, Bread Street Ward Club Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
513 513 member Member, Farringdon Ward Club Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
514 514 member Member, Langbourn Ward Club Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
515 515 member Member, Royal Society of St George, City of London Branch Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
516 516 member Member, United Wards Club Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
517 517 member Freemason, Assistant Grand Master, United Grand Lodge of England Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
518 518 member Governor, The Honourable The Irish Society Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
519 519 member Member, Institute of Cancer Research Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
520 520 member Trustee, the Glaziers Foundation Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
521 521 member One of Her Majesty's Lieutenants for the City of London Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397
522 522 member Governor and Member, Advisory Council of Goodenough College Non-pecuniary interests e9002d25 Sir David Hugh Wootton 397

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