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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
1465 1465 member Underwriter, Lloyds of London, 1 Lime Street, London. EC3 Employment, office, trade, profession or vocation e938d3aa Ian Christopher Norman Seaton 402
1466 1466 member 187 Andrewes' House, Barbican, London/ EC2 Land d9df90d8 Ian Christopher Norman Seaton 402
1467 1467 partner Long lease - Floor 409, Queen's Quay, Upper Thames Street, London EC4 Land d9df90d8 Ian Christopher Norman Seaton 402
1468 1468 partner Flat 409, Queen's Qauy, 58 Upper Thames Street, London, EC4 Corporate Tenancies 8948e857 Ian Christopher Norman Seaton 402
1469 1469 member Board Member - The Crown and Manor Boys' Club, Hoxton Non-pecuniary interests e9002d25 Ian Christopher Norman Seaton 402
1470 1470 member Church Warden, St Lawrence Jewry Non-pecuniary interests e9002d25 Ian Christopher Norman Seaton 402
1471 1471 member Member,the Society of the Middle Temple Non-pecuniary interests e9002d25 Ian Christopher Norman Seaton 402
1472 1472 member The worshipful Company of Girdlers' - Member of the Court Non-pecuniary interests e9002d25 Ian Christopher Norman Seaton 402
1473 1473 member Lime Street & Cornhill Ward Club Member Non-pecuniary interests e9002d25 Ian Christopher Norman Seaton 402

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