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

18 rows where member_id = 1231

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
1380 1380 member Owner /Managing Director - Firecrest Risk Limited Employment, office, trade, profession or vocation e938d3aa Graeme Martyn Smith 1231
1381 1381 partner Dhiren Doshi, Director of DPR WHOLESALERS LIMITED, and of RENRICK PRODUCTS LIMITED Employment, office, trade, profession or vocation e938d3aa Graeme Martyn Smith 1231
1382 1382 member Liveryman - Worshipful Company of Information Technologists Non-pecuniary interests e9002d25 Graeme Martyn Smith 1231
1383 1383 member Member - Farringdon Ward Club Non-pecuniary interests e9002d25 Graeme Martyn Smith 1231
1384 1384 member Member - Epping Forest Conservative Association Non-pecuniary interests e9002d25 Graeme Martyn Smith 1231
1385 1385 member Member - Stonewall Non-pecuniary interests e9002d25 Graeme Martyn Smith 1231
1386 1386 member Member - Butterfly Conservation Non-pecuniary interests e9002d25 Graeme Martyn Smith 1231
1387 1387 member Member - International Information Systems Security Certifications Consortium Inc. Non-pecuniary interests e9002d25 Graeme Martyn Smith 1231
1388 1388 member Member - ISACA Non-pecuniary interests e9002d25 Graeme Martyn Smith 1231
1389 1389 member Friend of the Museum of London Non-pecuniary interests e9002d25 Graeme Martyn Smith 1231
1390 1390 member Friend of the City of London Festival Non-pecuniary interests e9002d25 Graeme Martyn Smith 1231
1391 1391 member Friend of the Guildhall Art Gallery Non-pecuniary interests e9002d25 Graeme Martyn Smith 1231
1392 1392 member Member - National Secular Society Non-pecuniary interests e9002d25 Graeme Martyn Smith 1231
1393 1393 member City University London Alumni Non-pecuniary interests e9002d25 Graeme Martyn Smith 1231
1394 1394 member Friend of Copped Hall Trust Non-pecuniary interests e9002d25 Graeme Martyn Smith 1231
1395 1395 member Associate Member of Epping Forest Centenary Trust Non-pecuniary interests e9002d25 Graeme Martyn Smith 1231
1396 1396 member Member - International Association of Privacy Professionals Non-pecuniary interests e9002d25 Graeme Martyn Smith 1231
1397 1397 member Member, Old Bancroftians' Association Non-pecuniary interests e9002d25 Graeme Martyn Smith 1231

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