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

9 rows where member_id = 213

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
1861 1861 member Business/Education Consultant Employment, office, trade, profession or vocation e938d3aa Kevin Malcolm Everett 213
1862 1862 partner City University Employment, office, trade, profession or vocation e938d3aa Kevin Malcolm Everett 213
1863 1863 member Liverymen, Worshipful Company of Educators Non-pecuniary interests e9002d25 Kevin Malcolm Everett 213
1864 1864 member Liveryman, Worshipful Company of Fletchers Non-pecuniary interests e9002d25 Kevin Malcolm Everett 213
1865 1865 member Trustee, Aldgate and Allhallows Foundation Non-pecuniary interests e9002d25 Kevin Malcolm Everett 213
1866 1866 member Member, Royal Society of St. George, City of London Branch Non-pecuniary interests e9002d25 Kevin Malcolm Everett 213
1867 1867 member Freemason Non-pecuniary interests e9002d25 Kevin Malcolm Everett 213
1868 1868 member Member, Candlewick Ward Club Non-pecuniary interests e9002d25 Kevin Malcolm Everett 213
1869 1869 member New Era Foundation Non-pecuniary interests e9002d25 Kevin Malcolm Everett 213

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