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

30 rows where member_id = 226

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, name, category_id

Link rowid ▼ kind name category_id member_id
186 186 member UK Country Manager, SEB, One Carter Lane, EC4 Employment, office, trade, profession or vocation e938d3aa Sir Roger Gifford 226
187 187 partner City Music Foundation Employment, office, trade, profession or vocation e938d3aa Sir Roger Gifford 226
188 188 member The Worshipful Company Of Musicians Non-pecuniary interests e9002d25 Sir Roger Gifford 226
189 189 member The Worshipful Company Of International Bankers Non-pecuniary interests e9002d25 Sir Roger Gifford 226
190 190 member The Worshipful Company Of Cordwainers Non-pecuniary interests e9002d25 Sir Roger Gifford 226
191 191 member The Worshipful Company Of Security Profressionals Non-pecuniary interests e9002d25 Sir Roger Gifford 226
192 192 member The Guild of PR Practitioners Non-pecuniary interests e9002d25 Sir Roger Gifford 226
193 193 member Freemason Non-pecuniary interests e9002d25 Sir Roger Gifford 226
194 194 member Royal Society St George City Branch Non-pecuniary interests e9002d25 Sir Roger Gifford 226
195 195 member United Wards Club Non-pecuniary interests e9002d25 Sir Roger Gifford 226
196 196 member Trustee - Emanuel Hospital Non-pecuniary interests e9002d25 Sir Roger Gifford 226
197 197 member Trustee - Mansion House Scholarship Scheme Non-pecuniary interests e9002d25 Sir Roger Gifford 226
198 198 member Trustee - St Paul's Cathedral School Foundation Non-pecuniary interests e9002d25 Sir Roger Gifford 226
199 199 member Trustee - St Paul's Cathedral Foundation Non-pecuniary interests e9002d25 Sir Roger Gifford 226
200 200 member Trustee - Bridewell Royal Hospital Non-pecuniary interests e9002d25 Sir Roger Gifford 226
201 201 member Trustee - The Lord Mayor's Trust for Charities Non-pecuniary interests e9002d25 Sir Roger Gifford 226
202 202 member Trustee and Chairman - English Chamber Orchestra and Music Society Non-pecuniary interests e9002d25 Sir Roger Gifford 226
203 203 member Trustee - Thomas Carpenter Educ and Apprenticing Foundation Non-pecuniary interests e9002d25 Sir Roger Gifford 226
204 204 member Trustee and Chairman - The Tenebrae Choir Non-pecuniary interests e9002d25 Sir Roger Gifford 226
205 205 member Trustee and Chairman - City Music Foundation Non-pecuniary interests e9002d25 Sir Roger Gifford 226
206 206 member Lord Mayor's Appeal Charity Non-pecuniary interests e9002d25 Sir Roger Gifford 226
207 207 member Trustee - Barbican Centre Trust Non-pecuniary interests e9002d25 Sir Roger Gifford 226
208 208 member St.Pauls Cathedral Foundation Non-pecuniary interests e9002d25 Sir Roger Gifford 226
209 209 member English Chamber Orchestra and Music Society Ltd. Non-pecuniary interests e9002d25 Sir Roger Gifford 226
210 210 member The Tenebrae Chior Non-pecuniary interests e9002d25 Sir Roger Gifford 226
211 211 member City Music Foundation Non-pecuniary interests e9002d25 Sir Roger Gifford 226
212 212 member Barbican Centre Trust Non-pecuniary interests e9002d25 Sir Roger Gifford 226
213 213 member Sedbergh School Non-pecuniary interests e9002d25 Sir Roger Gifford 226
214 214 member Multrees Investor Services (subsidiary of SERB Pension) Non-pecuniary interests e9002d25 Sir Roger Gifford 226
215 215 member SEB Life Ireland (related to SEB London) Non-pecuniary interests e9002d25 Sir Roger Gifford 226

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 11.782ms · Data source: See col-scraper on GitHub