home / colmem

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

16 rows where member_id = 207

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, name, category_id

Link rowid ▼ kind name category_id member_id
403 403 member Director, H. Clarkson & Co, Lower Thames Street EC3 Employment, office, trade, profession or vocation e938d3aa The Lord Mountevans, Jeffrey Evans 207
404 404 member Clarkson PLC Securities 4bd97394 The Lord Mountevans, Jeffrey Evans 207
405 405 partner Clarkson PLC Securities 4bd97394 The Lord Mountevans, Jeffrey Evans 207
406 406 member Trustee, Seafarers UK (King George’s Fund for Sailors) Non-pecuniary interests e9002d25 The Lord Mountevans, Jeffrey Evans 207
407 407 member Director and Trustee of the White Ensign Association Non-pecuniary interests e9002d25 The Lord Mountevans, Jeffrey Evans 207
408 408 member Almoner and Director of Christ’s Hospital Non-pecuniary interests e9002d25 The Lord Mountevans, Jeffrey Evans 207
409 409 member Trustee, St Paul’s Chorister Trust Non-pecuniary interests e9002d25 The Lord Mountevans, Jeffrey Evans 207
410 410 member Trustee, Mansion House Scholarship Scheme Non-pecuniary interests e9002d25 The Lord Mountevans, Jeffrey Evans 207
411 411 member President (not a Trustee) of the City of London Sea Cadets Non-pecuniary interests e9002d25 The Lord Mountevans, Jeffrey Evans 207
412 412 member Patron, Ward of Cheap Club Non-pecuniary interests e9002d25 The Lord Mountevans, Jeffrey Evans 207
413 413 member Liveryman of the Shipwrights, Goldsmiths, World Traders, Wheelwrights and Security Professionals Companies Non-pecuniary interests e9002d25 The Lord Mountevans, Jeffrey Evans 207
414 414 member Member, Institute of Chartered Shipbrokers Non-pecuniary interests e9002d25 The Lord Mountevans, Jeffrey Evans 207
415 415 member Younger Brother, Trinity House Non-pecuniary interests e9002d25 The Lord Mountevans, Jeffrey Evans 207
416 416 member Chairman, Maritime UK Non-pecuniary interests e9002d25 The Lord Mountevans, Jeffrey Evans 207
417 417 member Chairman Maritime London Non-pecuniary interests e9002d25 The Lord Mountevans, Jeffrey Evans 207
418 418 member Currently chairing the government’s "Maritime Growth Study: keeping the UK competitive" Non-pecuniary interests e9002d25 The Lord Mountevans, Jeffrey Evans 207

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");
Powered by Datasette · Queries took 18.943ms · Data source: See col-scraper on GitHub