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

18 rows where member_id = 225

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
1633 1633 partner CEO, Incom Tours and Events Employment, office, trade, profession or vocation e938d3aa John Garbutt 225
1634 1634 member Chairman, International Students' Trust Non-pecuniary interests e9002d25 John Garbutt 225
1635 1635 member Council Member, City Livery Club (Immediate Past President) Non-pecuniary interests e9002d25 John Garbutt 225
1636 1636 member Junior Warden, Guild of Freemen of the City of London Non-pecuniary interests e9002d25 John Garbutt 225
1637 1637 member President, Walbrook Ward Club Non-pecuniary interests e9002d25 John Garbutt 225
1638 1638 member Member, Cheap Ward Club and Coleman Street Ward Club Non-pecuniary interests e9002d25 John Garbutt 225
1639 1639 member Vice-Chairman, Royal Society of St. George (City Branch) Non-pecuniary interests e9002d25 John Garbutt 225
1640 1640 member Lay Chairman/Church Warden, St. Stephen Walbrook Church Non-pecuniary interests e9002d25 John Garbutt 225
1641 1641 member Freemason Non-pecuniary interests e9002d25 John Garbutt 225
1642 1642 member Upper Bailiff (Master), Worshipful Company of Weavers Non-pecuniary interests e9002d25 John Garbutt 225
1643 1643 member Honorary Court Member, Worshipful Company of Joiners and Ceilers Non-pecuniary interests e9002d25 John Garbutt 225
1644 1644 member Liveryman, Worshipful Company of International Bankers Non-pecuniary interests e9002d25 John Garbutt 225
1645 1645 member Fellow, Chartered Institute for Security and Investment Non-pecuniary interests e9002d25 John Garbutt 225
1646 1646 member Fellow, Royal Society of Arts Non-pecuniary interests e9002d25 John Garbutt 225
1647 1647 member Fellow, Royal Geographical Society Non-pecuniary interests e9002d25 John Garbutt 225
1648 1648 member Honorary Visiting Professor, London Metropolitan University Non-pecuniary interests e9002d25 John Garbutt 225
1649 1649 member Honorary Visiting Professor, University of West London Non-pecuniary interests e9002d25 John Garbutt 225
1650 1650 member Guild of Investment Managers (Sponsoring Alderman) Non-pecuniary interests e9002d25 John Garbutt 225

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