interests
Data source: See col-scraper on GitHub
5 rows where member_id = 2058
This data as json, CSV (advanced)
Suggested facets: category_id
Link | rowid ▼ | kind | name | category_id | member_id |
---|---|---|---|---|---|
398 | 398 | member | Chief Operating Officer UBS Investment Bank 5 Broadgate London EC2M 2QS | Employment, office, trade, profession or vocation e938d3aa | Benjamin Daniel Murphy 2058 |
399 | 399 | member | 5 Broadgate, London. EC2M 2QS | Land d9df90d8 | Benjamin Daniel Murphy 2058 |
400 | 400 | member | Cripplegate House, 1 Golden Lane, London. EC1Y 0RR | Land d9df90d8 | Benjamin Daniel Murphy 2058 |
401 | 401 | member | Chairman of the Board of Governors, Epping St. John's Church of England School, Bury Lane, Epping, Essex, CM16 5JB (a member of the Burnt Mill Multi Academy Trust who operates schools within London) | Non-pecuniary interests e9002d25 | Benjamin Daniel Murphy 2058 |
402 | 402 | member | Member - Bishopsgate Ward Club | Non-pecuniary interests e9002d25 | Benjamin Daniel Murphy 2058 |
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");