interests
Data source: See col-scraper on GitHub
14 rows where member_id = 1223
This data as json, CSV (advanced)
Suggested facets: category_id
Link | rowid ▼ | kind | name | category_id | member_id |
---|---|---|---|---|---|
707 | 707 | member | Director, TIC Consulting Ltd | Employment, office, trade, profession or vocation e938d3aa | Jamie Ingham Clark 1223 |
708 | 708 | partner | Medical Director for Clinical Effectiveness NHS ENGLAND | Employment, office, trade, profession or vocation e938d3aa | Jamie Ingham Clark 1223 |
709 | 709 | member | Director, Electrum Holdings Ltd | Employment, office, trade, profession or vocation e938d3aa | Jamie Ingham Clark 1223 |
710 | 710 | member | LEASE OVER ONE ROOM WITHIN CLOTHWORKERS' HALL, DUNSTER COURT, LONDON | Land d9df90d8 | Jamie Ingham Clark 1223 |
711 | 711 | member | Trustee, St. George's Royal Arch Chapter No. 5 Benevolent Board | Non-pecuniary interests e9002d25 | Jamie Ingham Clark 1223 |
712 | 712 | member | Church Warden of St. Lawrence Jewry and member of Guild Church Council (ex-officio) | Non-pecuniary interests e9002d25 | Jamie Ingham Clark 1223 |
713 | 713 | member | Member, Aldgate Ward Club | Non-pecuniary interests e9002d25 | Jamie Ingham Clark 1223 |
714 | 714 | member | Trustee of the St. John Eye Hospital Group | Non-pecuniary interests e9002d25 | Jamie Ingham Clark 1223 |
715 | 715 | member | Member, Billingsgate Ward Club | Non-pecuniary interests e9002d25 | Jamie Ingham Clark 1223 |
716 | 716 | member | Liveryman of the Worship Company of Clothworkers | Non-pecuniary interests e9002d25 | Jamie Ingham Clark 1223 |
717 | 717 | member | Fellow of the Institute of Chartered Accountants in England and Wales | Non-pecuniary interests e9002d25 | Jamie Ingham Clark 1223 |
718 | 718 | member | Freemason including the Guildhall Lodge | Non-pecuniary interests e9002d25 | Jamie Ingham Clark 1223 |
719 | 719 | member | Veteran Member, Honourable Artillery Company | Non-pecuniary interests e9002d25 | Jamie Ingham Clark 1223 |
720 | 720 | member | Member, Tower Ward Club | Non-pecuniary interests e9002d25 | Jamie Ingham Clark 1223 |
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");