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

17 rows where member_id = 1666

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
1251 1251 partner Director, Mr Pilates Limited London SE1 Employment, office, trade, profession or vocation e938d3aa Keith David Forbes Bottomley 1666
1252 1252 member Member - Bridge Ward Club Non-pecuniary interests e9002d25 Keith David Forbes Bottomley 1666
1253 1253 member Member - Broad Street Ward Club Non-pecuniary interests e9002d25 Keith David Forbes Bottomley 1666
1254 1254 member Member - Candlewick Ward Club Non-pecuniary interests e9002d25 Keith David Forbes Bottomley 1666
1255 1255 member Member - Royal Society of St George (City Branch) Non-pecuniary interests e9002d25 Keith David Forbes Bottomley 1666
1256 1256 member Freemason - United Grand Lodge of England Non-pecuniary interests e9002d25 Keith David Forbes Bottomley 1666
1257 1257 member Liveryman - Worshipful Company of Wheelwrights Non-pecuniary interests e9002d25 Keith David Forbes Bottomley 1666
1258 1258 member Member - Conservative Party Non-pecuniary interests e9002d25 Keith David Forbes Bottomley 1666
1259 1259 member Chartered Institute of Bankers Non-pecuniary interests e9002d25 Keith David Forbes Bottomley 1666
1260 1260 member Liveryman - Worshipful Company of Pattenmakers Non-pecuniary interests e9002d25 Keith David Forbes Bottomley 1666
1261 1261 member Trustee and Chairman - Partnership for Young London Non-pecuniary interests e9002d25 Keith David Forbes Bottomley 1666
1262 1262 member Trustee - Central Foundation Schools of London Non-pecuniary interests e9002d25 Keith David Forbes Bottomley 1666
1263 1263 member Trustee - Housing for the Homeless Central Fund Non-pecuniary interests e9002d25 Keith David Forbes Bottomley 1666
1264 1264 member Trustee and Hon Treasurer – Barts Guild Non-pecuniary interests e9002d25 Keith David Forbes Bottomley 1666
1265 1265 member Trustee and Hon Treasurer – The Friends of St Margaret Pattens Church Eastcheap Non-pecuniary interests e9002d25 Keith David Forbes Bottomley 1666
1266 1266 member Court member and Director - The Guild of Freemen of the City of London Non-pecuniary interests e9002d25 Keith David Forbes Bottomley 1666
1267 1267 member Member – Ned’s Club Non-pecuniary interests e9002d25 Keith David Forbes Bottomley 1666

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