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

Data source: See col-scraper on GitHub

36 rows where member_id = 373

View and edit SQL

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
551 member Self Employed Consultant Employment, office, trade, profession or vocation e938d3aa Catherine McGuinness 373
552 partner Chairman, Cripplegate Foundation - which is in receipt of a £141,000 grant (over three years, 2017-2020) from The City Bridge Trust to tackle poverty and isolation among Islington's older people. Employment, office, trade, profession or vocation e938d3aa Catherine McGuinness 373
553 partner Director and 50% shareholder – M&G Advisory Services Limited Employment, office, trade, profession or vocation e938d3aa Catherine McGuinness 373
554 partner Director – St Ethelburga’s Centre (Trading) Limited (a wholly owned subsidiary of St Ethelburga’s Centre for Reconciliation and Peace) Employment, office, trade, profession or vocation e938d3aa Catherine McGuinness 373
555 member Long Lease of Barbican Flat, EC2 Contracts 32767bc8 Catherine McGuinness 373
556 partner Long Lease of Barbican Flat, EC2 Contracts 32767bc8 Catherine McGuinness 373
557 member London and Partners (unpaid) Contracts 32767bc8 Catherine McGuinness 373
558 member TheCityUK (unpaid) Contracts 32767bc8 Catherine McGuinness 373
559 member London Councils (unpaid) Contracts 32767bc8 Catherine McGuinness 373
560 member Flat at Bryer Court, Barbican, EC2 Land d9df90d8 Catherine McGuinness 373
561 partner Flat at Bryer Court, Barbican, EC2 Land d9df90d8 Catherine McGuinness 373
562 member Flat at Bartholomew Close, EC1 Land d9df90d8 Catherine McGuinness 373
563 partner Flat at Bartholomew Close, EC1 Land d9df90d8 Catherine McGuinness 373
564 member London Councils Corporate Tenancies 8948e857 Catherine McGuinness 373
565 member TheCityUK, Finsbury Circus, EC2M Corporate Tenancies 8948e857 Catherine McGuinness 373
566 member Member of the Castle Baynard Ward Club Non-pecuniary interests e9002d25 Catherine McGuinness 373
567 partner Member of the Castle Baynard Ward Club Non-pecuniary interests e9002d25 Catherine McGuinness 373
568 member Trustee, Epping Forest Heritage Trust Non-pecuniary interests e9002d25 Catherine McGuinness 373
569 partner Governor – Cripplegate Foundation Non-pecuniary interests e9002d25 Catherine McGuinness 373
570 member Member, The City Academy, Hackney Non-pecuniary interests e9002d25 Catherine McGuinness 373
571 partner Trustee, St Ethelburga’s Centre for Peace and Reconciliation Non-pecuniary interests e9002d25 Catherine McGuinness 373
572 member Worshipful Company of Educators Non-pecuniary interests e9002d25 Catherine McGuinness 373
573 partner Member, Liberal Democrat Party Non-pecuniary interests e9002d25 Catherine McGuinness 373
574 member Worshipful Company of Musicians Non-pecuniary interests e9002d25 Catherine McGuinness 373
575 partner Governor – St John’s Highbury Vale CofE Primary School Non-pecuniary interests e9002d25 Catherine McGuinness 373
576 member Worshipful Company of Solicitors Non-pecuniary interests e9002d25 Catherine McGuinness 373
577 partner Governor (chair of governors) – Drayton Park Primary School Non-pecuniary interests e9002d25 Catherine McGuinness 373
578 member Law Society Non-pecuniary interests e9002d25 Catherine McGuinness 373
579 partner Trustee – Christchurch, Highbury Non-pecuniary interests e9002d25 Catherine McGuinness 373
580 member Consultant (voluntary) to Inner City Trust, Derry-Londonderry Non-pecuniary interests e9002d25 Catherine McGuinness 373
581 partner Trustee – Epping Forest Heritage Trust Non-pecuniary interests e9002d25 Catherine McGuinness 373
582 member Deputy Chair, International Regulatory Strategy Group Non-pecuniary interests e9002d25 Catherine McGuinness 373
583 member Deputy Chair, TheCityUK Non-pecuniary interests e9002d25 Catherine McGuinness 373
584 member Board Member, London and Partners Non-pecuniary interests e9002d25 Catherine McGuinness 373
585 member Vice Chair, London Councils Non-pecuniary interests e9002d25 Catherine McGuinness 373
586 member Vice Chair, Innovate Finance Fintech Strategy group Non-pecuniary interests e9002d25 Catherine McGuinness 373

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");