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 = 381

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name

Link rowid ▼ kind name category_id member_id
419 419 member Aldgate Ward Club Member Non-pecuniary interests e9002d25 Sylvia Doreen Moys 381
420 420 member Bridge Ward Club Member Non-pecuniary interests e9002d25 Sylvia Doreen Moys 381
421 421 member United Wards Club Member and elected Member of Governing Body Non-pecuniary interests e9002d25 Sylvia Doreen Moys 381
422 422 member Aldgate Ward Club Member Non-pecuniary interests e9002d25 Sylvia Doreen Moys 381
423 423 member Bridge Ward Club Member Non-pecuniary interests e9002d25 Sylvia Doreen Moys 381
424 424 member United Wards Club Member and elected Member of Governing Body Non-pecuniary interests e9002d25 Sylvia Doreen Moys 381
425 425 member Royal Society of St George, City of London Non-pecuniary interests e9002d25 Sylvia Doreen Moys 381
426 426 member City Livery Club Member Non-pecuniary interests e9002d25 Sylvia Doreen Moys 381
427 427 member City Livery Club Music Section Member Non-pecuniary interests e9002d25 Sylvia Doreen Moys 381
428 428 member FOGAG Member Non-pecuniary interests e9002d25 Sylvia Doreen Moys 381
429 429 member the Data Protection Forum Non-pecuniary interests e9002d25 Sylvia Doreen Moys 381
430 430 member ICSA Benevolent Fund Committee Member Non-pecuniary interests e9002d25 Sylvia Doreen Moys 381
431 431 member Art Fund Member Non-pecuniary interests e9002d25 Sylvia Doreen Moys 381
432 432 member National Trust Member Non-pecuniary interests e9002d25 Sylvia Doreen Moys 381
433 433 member Maritime London Member Non-pecuniary interests e9002d25 Sylvia Doreen Moys 381
434 434 member Royal National Rose Society (in Administration) Non-pecuniary interests e9002d25 Sylvia Doreen Moys 381
435 435 member Friend of Guildhall Library Non-pecuniary interests e9002d25 Sylvia Doreen Moys 381

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