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 member_id = 1941

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, name, category_id

Link rowid ▼ kind name category_id member_id
811 811 member Member of the Bar of England and Wales. Temple, London EC4 Employment, office, trade, profession or vocation e938d3aa Oliver Sells QC 1941
812 812 partner Pianist, lecturer and author Employment, office, trade, profession or vocation e938d3aa Oliver Sells QC 1941
813 813 member Recorder, Ministry of Justice, London SW1 Employment, office, trade, profession or vocation e938d3aa Oliver Sells QC 1941
814 814 member Director - Houghton AC Limited Employment, office, trade, profession or vocation e938d3aa Oliver Sells QC 1941
815 815 member Tenant of the Inner Temple, London EC4 Land d9df90d8 Oliver Sells QC 1941
816 816 partner Tenant of the Inner Temple, London EC4 Land d9df90d8 Oliver Sells QC 1941
817 817 partner Leasehold property in London EC2 Land d9df90d8 Oliver Sells QC 1941
818 818 member Trustee - Breckland Society Non-pecuniary interests e9002d25 Oliver Sells QC 1941
819 819 member Governing Bencher - Inner Temple Non-pecuniary interests e9002d25 Oliver Sells QC 1941
820 820 member Member- Criminal Bar Association Non-pecuniary interests e9002d25 Oliver Sells QC 1941
821 821 member Member - American Bar Association Non-pecuniary interests e9002d25 Oliver Sells QC 1941
822 822 member Member - International Bar Association Non-pecuniary interests e9002d25 Oliver Sells QC 1941
823 823 member Adviser - Commonwealth Law Association Non-pecuniary interests e9002d25 Oliver Sells QC 1941
824 824 member Musicians' Company Non-pecuniary interests e9002d25 Oliver Sells QC 1941
825 825 member Member- Temple and Farringdon Together Non-pecuniary interests e9002d25 Oliver Sells QC 1941
826 826 member Member - Conservative Party Non-pecuniary interests e9002d25 Oliver Sells QC 1941
827 827 member Think Tank - Conservative Policy Forum Non-pecuniary interests e9002d25 Oliver Sells QC 1941
828 828 member Think Tank - RTI Limited Non-pecuniary interests e9002d25 Oliver Sells QC 1941
829 829 member Professional association - Bar Standards Board Non-pecuniary interests e9002d25 Oliver Sells QC 1941
830 830 member Trade association - Bar Council Non-pecuniary interests e9002d25 Oliver Sells QC 1941

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