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

15 rows where member_id = 2105

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
1670 1670 member Senior Adviser, Bank of England, Threadneedle Street. London. EC2R 8AH. Employment, office, trade, profession or vocation e938d3aa John Petrie 2105
1671 1671 member Officer of Arms, College of Arms, Queen Victoria Street. London. EC4V 4BT Employment, office, trade, profession or vocation e938d3aa John Petrie 2105
1672 1672 member Officer of Arms, Royal Household. Buckingham Palace. London. SW1A 1AA. Employment, office, trade, profession or vocation e938d3aa John Petrie 2105
1673 1673 member Governor, United Colleges Group Non-pecuniary interests e9002d25 John Petrie 2105
1674 1674 member Member, Billingsgate Ward Club Non-pecuniary interests e9002d25 John Petrie 2105
1675 1675 member Member, Guildhall Club Non-pecuniary interests e9002d25 John Petrie 2105
1676 1676 member Member, Oxford Union Society Non-pecuniary interests e9002d25 John Petrie 2105
1677 1677 member Honorary Member, White Lion Society Non-pecuniary interests e9002d25 John Petrie 2105
1678 1678 member Member, Royal Household Film Society Non-pecuniary interests e9002d25 John Petrie 2105
1679 1679 member Member, Freemasonry including Guildhall Lodge Non-pecuniary interests e9002d25 John Petrie 2105
1680 1680 member Liveryman, Drapers' Company Non-pecuniary interests e9002d25 John Petrie 2105
1681 1681 member Freeman, International Bankers' Company Non-pecuniary interests e9002d25 John Petrie 2105
1682 1682 member Member, St John Ceremonial Team Non-pecuniary interests e9002d25 John Petrie 2105
1683 1683 member Protocol Adviser to Government House in Antigua Non-pecuniary interests e9002d25 John Petrie 2105
1684 1684 member Member, Pilgrims Society Non-pecuniary interests e9002d25 John Petrie 2105

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