interests
Data source: See col-scraper on GitHub
14 rows where category_id = "e9002d25" and member_id = 384
This data as json, CSV (advanced)
Link | rowid ▼ | kind | name | category_id | member_id |
---|---|---|---|---|---|
1086 | 1086 | member | Trustee - Castle Baynard Educational Foundation and Alderman Samuel Wilson Fund | Non-pecuniary interests e9002d25 | Jeremy Lewis Simons 384 |
1087 | 1087 | member | Trustee - City of London Archaeological Trust | Non-pecuniary interests e9002d25 | Jeremy Lewis Simons 384 |
1088 | 1088 | member | Trustee - Dr Johnson House Trust | Non-pecuniary interests e9002d25 | Jeremy Lewis Simons 384 |
1089 | 1089 | member | Trustee - St Andrew Holborn and Stafford’s Charity | Non-pecuniary interests e9002d25 | Jeremy Lewis Simons 384 |
1090 | 1090 | member | Trustee - The Tree Council | Non-pecuniary interests e9002d25 | Jeremy Lewis Simons 384 |
1091 | 1091 | member | Trustee - Housing the Homeless Central Fund | Non-pecuniary interests e9002d25 | Jeremy Lewis Simons 384 |
1092 | 1092 | member | Member - Castle Baynard Ward Club | Non-pecuniary interests e9002d25 | Jeremy Lewis Simons 384 |
1093 | 1093 | member | Member - Guildhall Circle (Guildhall School Friends) | Non-pecuniary interests e9002d25 | Jeremy Lewis Simons 384 |
1094 | 1094 | member | Worshipful Company of Scientific Instrument Makers | Non-pecuniary interests e9002d25 | Jeremy Lewis Simons 384 |
1095 | 1095 | member | Member - Chartered Institute of Management | Non-pecuniary interests e9002d25 | Jeremy Lewis Simons 384 |
1096 | 1096 | member | Member - Epping Forest Heritage Trust | Non-pecuniary interests e9002d25 | Jeremy Lewis Simons 384 |
1097 | 1097 | member | Trustee, Thames 21 | Non-pecuniary interests e9002d25 | Jeremy Lewis Simons 384 |
1098 | 1098 | member | Member, Friends of Heath Hands | Non-pecuniary interests e9002d25 | Jeremy Lewis Simons 384 |
1099 | 1099 | member | Member, London Society | Non-pecuniary interests e9002d25 | Jeremy Lewis Simons 384 |
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");