interests
Data source: See col-scraper on GitHub
9 rows where category_id = "e9002d25" and member_id = 1951 sorted by member_id
This data as json, CSV (advanced)
Link | rowid | kind | name | category_id | member_id ▼ |
---|---|---|---|---|---|
299 | 299 | member | Associate, Chartered Institute of Securities and Investment | Non-pecuniary interests e9002d25 | Alexander Robertson Martin Barr 1951 |
300 | 300 | member | Member - Cordwainer Ward Club | Non-pecuniary interests e9002d25 | Alexander Robertson Martin Barr 1951 |
301 | 301 | member | Member – Bread Street Ward Club | Non-pecuniary interests e9002d25 | Alexander Robertson Martin Barr 1951 |
302 | 302 | member | Director -Sapphire IV (Investments) Ltd, 1 Le Truchot, St. Peter Port, Guernsey. GY1 1WD | Non-pecuniary interests e9002d25 | Alexander Robertson Martin Barr 1951 |
303 | 303 | member | Trustee, Thomas Carpenter's Trust (The Thomas Carpenter Educational and Apprenticing Foundation) | Non-pecuniary interests e9002d25 | Alexander Robertson Martin Barr 1951 |
304 | 304 | member | Freeman, Worshipful Company of Ironmongers | Non-pecuniary interests e9002d25 | Alexander Robertson Martin Barr 1951 |
305 | 305 | member | Director - Aberdeen Sapphire IV Ltd, 1 Le Truchot, St. Peter Port, Guernsey. GY1 1WD | Non-pecuniary interests e9002d25 | Alexander Robertson Martin Barr 1951 |
306 | 306 | member | Director - Sapphire (Investments) II Ltd, 1 Le Truchot, St. Peter Port, Guernsey. GY1 1WD | Non-pecuniary interests e9002d25 | Alexander Robertson Martin Barr 1951 |
307 | 307 | member | Director - Sapphire (PCC) Ltd, 1 Le Truchot, St. Peter Port, Guernsey. GY1 1WD | Non-pecuniary interests e9002d25 | Alexander Robertson Martin Barr 1951 |
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");