home / colmem

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

29 rows where member_id = 1260

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
1054 1054 member Managing Director, JP Morgan Chase & Co. 25 Bank Street Canary Wharf London E14 5JP Employment, office, trade, profession or vocation e938d3aa Timothy Russell Hailes 1260
1055 1055 member Ten Trinity Square Club; Reignwood Group Sponsorship d9d60c21 Timothy Russell Hailes 1260
1056 1056 member JP Morgan Chase & Co. Securities 4bd97394 Timothy Russell Hailes 1260
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");
Powered by Datasette · Queries took 23.68ms · Data source: See col-scraper on GitHub