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

26 rows where category_id = "e9002d25" and member_id = 1260

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ kind name category_id member_id
1057 1057 member Hon. President Bassishaw Ward Club Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1058 1058 member Liveryman, Worshipful Company of International Bankers Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1059 1059 member Liveryman, Worshipful Company of Solicitors Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1060 1060 member Liveryman, Worshipful Company of Pewterers Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1061 1061 member Liveryman, Worshipful Company of Firefighters Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1062 1062 member Honorary Liveryman, Worshipful Company of Paviors Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1063 1063 member Member, The City Livery Club Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1064 1064 member Member, The Royal Society of St.George, London Branch Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1065 1065 member Member, United Wards Club Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1066 1066 member Member, Thomas Sutton Circle, The Charterhouse Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1067 1067 member Member of The Board and Court of the Guild of Freemen of The City of London Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1068 1068 member Member, City of London Club Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1069 1069 member Member, The Law Society of England & Wales Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1070 1070 member Member, City of London Law Society Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1071 1071 member Justice of the Peace, Central London Justice Area Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1072 1072 member Churchwarden, St Lawrence Jewry Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1073 1073 member Governor, Corporation of the Sons of the Clergy Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1074 1074 member Life Governor, RNLI Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1075 1075 member Member, Incorporation of Wrights Craft, Glasgow Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1076 1076 member Court Member, Worshipful Company of Pewterers Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1077 1077 member Court Member,Worshipful Company of International Bankers Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1078 1078 member Court Member,Guild of Freemen of The City of London Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1079 1079 member Member, Freemasons Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1080 1080 member Stonewall Ambassador and Role Model Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1081 1081 member Vice Chairman of Governors, King Edwards School Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260
1082 1082 member Trustee, Mansion House Scholarship Scheme Non-pecuniary interests e9002d25 Timothy Russell Hailes 1260

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