interests
Data source: See col-scraper on GitHub
10 rows where category_id = "e9002d25" and member_id = 1944
This data as json, CSV (advanced)
Link | rowid ▼ | kind | name | category_id | member_id |
---|---|---|---|---|---|
1521 | 1521 | member | Chair, Digital Board Royal Foundation of The Duke and Duchess of Cambridge and Prince Harry (NB role is advisory and not as a trustee) | Non-pecuniary interests e9002d25 | Tim Levene 1944 |
1522 | 1522 | member | Member of National Gallery Digital Advisory Board (NB role is advisory and not as a trustee) | Non-pecuniary interests e9002d25 | Tim Levene 1944 |
1523 | 1523 | member | John Carpenter Club (City of London School Old Boys Society) | Non-pecuniary interests e9002d25 | Tim Levene 1944 |
1524 | 1524 | member | Worshipful Company of Carmen | Non-pecuniary interests e9002d25 | Tim Levene 1944 |
1525 | 1525 | member | Member of the Bridge Ward Club | Non-pecuniary interests e9002d25 | Tim Levene 1944 |
1526 | 1526 | member | City of London Fintech Action Group | Non-pecuniary interests e9002d25 | Tim Levene 1944 |
1527 | 1527 | member | Forum of Young Global Leaders (World Economic Forum) | Non-pecuniary interests e9002d25 | Tim Levene 1944 |
1528 | 1528 | member | Global Ambassador Innovate Finance | Non-pecuniary interests e9002d25 | Tim Levene 1944 |
1529 | 1529 | member | Director 47 Queens Crescent (Management Company Ltd) - Dormant Company | Non-pecuniary interests e9002d25 | Tim Levene 1944 |
1530 | 1530 | member | Director Elmlea Consultants Ltd - Dormant Company | Non-pecuniary interests e9002d25 | Tim Levene 1944 |
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");