interests
Data source: See col-scraper on GitHub
7 rows where category_id = "e9002d25" and member_id = 1943
This data as json, CSV (advanced)
Link | rowid ▼ | kind | name | category_id | member_id |
---|---|---|---|---|---|
1358 | 1358 | member | Chairman of the Castle Baynard Ward Club | Non-pecuniary interests e9002d25 | Angus Knowles-Cutler 1943 |
1359 | 1359 | member | Liveryman of the Worshipful Company of Gardeners | Non-pecuniary interests e9002d25 | Angus Knowles-Cutler 1943 |
1360 | 1360 | member | Commissioner of the London Skills Commission, organised by London First | Non-pecuniary interests e9002d25 | Angus Knowles-Cutler 1943 |
1361 | 1361 | member | Fellow of the Royal Society of Arts | Non-pecuniary interests e9002d25 | Angus Knowles-Cutler 1943 |
1362 | 1362 | member | ICAEW | Non-pecuniary interests e9002d25 | Angus Knowles-Cutler 1943 |
1363 | 1363 | member | Deputy Chair of the London Economic Action Partnership (the London LEP) and business lead; appointed by the Mayor of London | Non-pecuniary interests e9002d25 | Angus Knowles-Cutler 1943 |
1364 | 1364 | member | Visiting Professor, Centre for the Digital Economy, University of Surrey | Non-pecuniary interests e9002d25 | Angus Knowles-Cutler 1943 |
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");