Interests for members and their partners ('Spouse/Civil Partner/Living as such') from the Register of Interests.

Data source: See col-scraper on GitHub

8 rows where member_id = 1947

View and edit SQL

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
286 member Barrister in independent practice at the Chambers of Sir Edward Garnier QC MP, One Brick Court, Temple, London. EC4Y 9BY Employment, office, trade, profession or vocation e938d3aa Caroline Kordai Addy 1947
287 member While not the named leaseholder, as a member of chambers I have an interest in the chambers’ premises at One Brick Court, leased from the Honourable Society of the Middle Temple. Land d9df90d8 Caroline Kordai Addy 1947
288 member Pension with Standard Life. Securities 4bd97394 Caroline Kordai Addy 1947
289 partner Pension with Aviva. Securities 4bd97394 Caroline Kordai Addy 1947
290 member Member, the Honourable Society of the Inner Temple. Non-pecuniary interests e9002d25 Caroline Kordai Addy 1947
291 partner My husband is a member of Unite. Non-pecuniary interests e9002d25 Caroline Kordai Addy 1947
292 member Supporter of the Bar Council through payment of a voluntary fee. Non-pecuniary interests e9002d25 Caroline Kordai Addy 1947
293 member Member of the Management Committee of the Chambers of Sir Edward Garnier QC MP. Non-pecuniary interests e9002d25 Caroline Kordai Addy 1947

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