home / colmem

interests

Interests for members and their partners ('Spouse/Civil Partner/Living as such') from the Register of Interests.

Data source: See col-scraper on GitHub

13 rows where member_id = 1757

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
587 587 member AON UK LTD - CEO Employment, office, trade, profession or vocation e938d3aa Dominic Gerard Christian 1757
588 588 partner Catherine Mary Birch (Kate Birch) - NIL Employment, office, trade, profession or vocation e938d3aa Dominic Gerard Christian 1757
589 589 member Lloyds of London - Member of Council Employment, office, trade, profession or vocation e938d3aa Dominic Gerard Christian 1757
590 590 member AON UK LTD Securities 4bd97394 Dominic Gerard Christian 1757
591 591 member Juvenile Diabetes Research Foundation Non-pecuniary interests e9002d25 Dominic Gerard Christian 1757
592 592 member Lloyd's Tercentenary Research Foundation Non-pecuniary interests e9002d25 Dominic Gerard Christian 1757
593 593 member Lime Street Ward Club Non-pecuniary interests e9002d25 Dominic Gerard Christian 1757
594 594 member Worshipful Company of Insurers Non-pecuniary interests e9002d25 Dominic Gerard Christian 1757
595 595 member City UK Advisory Board Non-pecuniary interests e9002d25 Dominic Gerard Christian 1757
596 596 member CBI - Presidents Committee Non-pecuniary interests e9002d25 Dominic Gerard Christian 1757
597 597 member Insurance Institute of London Non-pecuniary interests e9002d25 Dominic Gerard Christian 1757
598 598 member University of East Anglia - Advisory Board Non-pecuniary interests e9002d25 Dominic Gerard Christian 1757
599 599 member The Bermuda Society Non-pecuniary interests e9002d25 Dominic Gerard Christian 1757

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Queries took 175.859ms · Data source: See col-scraper on GitHub