interests
Data source: See col-scraper on GitHub
30 rows where member_id = 226
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
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");