interests
Data source: See col-scraper on GitHub
13 rows where category_id = "e9002d25" and member_id = 269 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | kind | name | category_id | member_id |
---|---|---|---|---|---|
1464 | 1464 | member | Member - City Livery Club | Non-pecuniary interests e9002d25 | Alastair John Naisbitt King 269 |
1463 | 1463 | member | Liveryman - Worshipful Company of Horners | Non-pecuniary interests e9002d25 | Alastair John Naisbitt King 269 |
1462 | 1462 | member | INSTITUTE OF DIRECTORS (CITY BRANCH) - CHAIRMAN | Non-pecuniary interests e9002d25 | Alastair John Naisbitt King 269 |
1461 | 1461 | member | WORSHIPFUL COMPANY OF MASONS (STONEMASONS) | Non-pecuniary interests e9002d25 | Alastair John Naisbitt King 269 |
1460 | 1460 | member | YOUNG PRESIDENTS ASSOCIATION | Non-pecuniary interests e9002d25 | Alastair John Naisbitt King 269 |
1459 | 1459 | member | GUILD OF ENTREPRENEURS | Non-pecuniary interests e9002d25 | Alastair John Naisbitt King 269 |
1458 | 1458 | member | FINANCIAL CONDUCT AUTHORITY - AUTHORISED PERSON | Non-pecuniary interests e9002d25 | Alastair John Naisbitt King 269 |
1457 | 1457 | member | WORSHIPFUL COMPANY OF PAINTERS STAINERS | Non-pecuniary interests e9002d25 | Alastair John Naisbitt King 269 |
1456 | 1456 | member | WORSHIPFUL COMPANY OF BRODERERS | Non-pecuniary interests e9002d25 | Alastair John Naisbitt King 269 |
1455 | 1455 | member | WORSHIPFUL COMPANY OF BLACKSMITHS | Non-pecuniary interests e9002d25 | Alastair John Naisbitt King 269 |
1454 | 1454 | member | QUEENHITHE WARD CLUB | Non-pecuniary interests e9002d25 | Alastair John Naisbitt King 269 |
1453 | 1453 | member | WALBROOK CLUB | Non-pecuniary interests e9002d25 | Alastair John Naisbitt King 269 |
1452 | 1452 | member | METROPOLITAN DRINKING FOUNTAIN AND CATTLE TROUGH ASSOCIATION | Non-pecuniary interests e9002d25 | Alastair John Naisbitt King 269 |
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");