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

14 rows where member_id = 137

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, name, category_id

Link rowid ▼ kind name category_id member_id
1502 1502 member John Lewis Partnership, Peter Jones Department Store, Sloane Square, SW1 Employment, office, trade, profession or vocation e938d3aa David John Bradshaw 137
1503 1503 member Lessee of property at Cromwell Tower, Barbican, EC2 Land d9df90d8 David John Bradshaw 137
1504 1504 partner Lessee of property at Cromwell Tower, Barbican, EC2 Land d9df90d8 David John Bradshaw 137
1505 1505 member Friend of Guildhall Art Gallery Non-pecuniary interests e9002d25 David John Bradshaw 137
1506 1506 partner Friend of Guildhall Art Gallery Non-pecuniary interests e9002d25 David John Bradshaw 137
1507 1507 member Member - Cripplegate Ward Club Non-pecuniary interests e9002d25 David John Bradshaw 137
1508 1508 partner Member, Cripplegate Ward Club Non-pecuniary interests e9002d25 David John Bradshaw 137
1509 1509 member Institute of Marketing and Sales Management Non-pecuniary interests e9002d25 David John Bradshaw 137
1510 1510 partner Member, Aldersgate Ward Club Non-pecuniary interests e9002d25 David John Bradshaw 137
1511 1511 partner Member, Bishopsgate Ward Club Non-pecuniary interests e9002d25 David John Bradshaw 137
1512 1512 partner Member, United Wards Club Non-pecuniary interests e9002d25 David John Bradshaw 137
1513 1513 partner Member, Royal Society of St George (City Branch) Non-pecuniary interests e9002d25 David John Bradshaw 137
1514 1514 partner Member, City Livery Club Non-pecuniary interests e9002d25 David John Bradshaw 137
1515 1515 partner Livery Member, Coopers Non-pecuniary interests e9002d25 David John Bradshaw 137

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