interests
Data source: See col-scraper on GitHub
10 rows where category_id = "e9002d25" and member_id = 1935
This data as json, CSV (advanced)
Link | rowid ▼ | kind | name | category_id | member_id |
---|---|---|---|---|---|
1125 | 1125 | member | Planning Aid Trust (RIPI) | Non-pecuniary interests e9002d25 | William Upton QC 1935 |
1126 | 1126 | member | Sir James Reckitt Charity Trust | Non-pecuniary interests e9002d25 | William Upton QC 1935 |
1127 | 1127 | member | Fellow of Royal Society of Arts | Non-pecuniary interests e9002d25 | William Upton QC 1935 |
1128 | 1128 | member | Member of Town and Country Planning Association | Non-pecuniary interests e9002d25 | William Upton QC 1935 |
1129 | 1129 | member | Member of Amnesty International | Non-pecuniary interests e9002d25 | William Upton QC 1935 |
1130 | 1130 | member | Member of Planning Local Government & Environmental Bar Association | Non-pecuniary interests e9002d25 | William Upton QC 1935 |
1131 | 1131 | member | Honourable Society of the Inner Temple | Non-pecuniary interests e9002d25 | William Upton QC 1935 |
1132 | 1132 | member | Constitutional and Administrative Law Bar Association | Non-pecuniary interests e9002d25 | William Upton QC 1935 |
1133 | 1133 | member | UK Environmental Law Association | Non-pecuniary interests e9002d25 | William Upton QC 1935 |
1134 | 1134 | member | Member - Temple and Farringdon Together | Non-pecuniary interests e9002d25 | William Upton QC 1935 |
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");