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

47 rows where kind = "member" and member_id = 511

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
1722 1722 member Director, Armadillo B Limited Employment, office, trade, profession or vocation e938d3aa Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1724 1724 member Director, Puma VCT 10 PLC Employment, office, trade, profession or vocation e938d3aa Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1725 1725 member Director, Provident and Regional LLP Employment, office, trade, profession or vocation e938d3aa Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1726 1726 member Director, EP Capital Partners LTD Employment, office, trade, profession or vocation e938d3aa Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1727 1727 member Director, The Guild of Entrepreneurs LTD Employment, office, trade, profession or vocation e938d3aa Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1728 1728 member Director, New Gresham Group LTD Employment, office, trade, profession or vocation e938d3aa Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1729 1729 member Director, Finance for Companies LTD Employment, office, trade, profession or vocation e938d3aa Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1730 1730 member Director, Human Capital Management LTD Employment, office, trade, profession or vocation e938d3aa Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1731 1731 member Director, Provident & Regional Estates LTD Employment, office, trade, profession or vocation e938d3aa Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1732 1732 member Director, Premier Non-Executives LTD Employment, office, trade, profession or vocation e938d3aa Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1733 1733 member Director, Proven Planned Exit VCT PLC Employment, office, trade, profession or vocation e938d3aa Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1734 1734 member Director, Basinghall Capital LTD Employment, office, trade, profession or vocation e938d3aa Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1735 1735 member Director, JQA LTD Employment, office, trade, profession or vocation e938d3aa Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1736 1736 member City of London Club (Freehold held) - Committee Member Licences 613aec30 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1738 1738 member Raleigh 400 Committee - Chairman Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1739 1739 member Government’s Advisory Task Force on Social Investment and Retail Participation - Member Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1740 1740 member Aldgate Community Events - Patron and Trustee Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1741 1741 member Aldgate Ward Club - Patron Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1742 1742 member Justice of the Peace (Magistrate) Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1743 1743 member Sea Change Sailing Trust - Appeal Patron Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1744 1744 member Wensleydale Longwool Sheep Breeders Association - Honorary Vice-President Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1745 1745 member ABF, The Soldiers Charity – Trustee Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1746 1746 member The Lord Mayor's Big Curry Lunch Committee - Member Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1747 1747 member The Worshipful Company of Woolmen - Past Master 2016/17 Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1748 1748 member The Guild of Entrepreneurs – Senior Warden and Trustee Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1749 1749 member The Woolmen’s Charitable Trust - Trustee Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1750 1750 member The Guild of Entrepreneurs Charitable Trust – Trustee Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1751 1751 member Co-Operation Ireland, London Executive Committee - Member Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1752 1752 member CHAMP Ireland, Advisory Board Member Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1753 1753 member Honourable Artillery Company (HAC) – Honorary Court Member Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1754 1754 member Conservative Party Business and Entrepreneurs Club Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1755 1755 member Prince of Wales (259) Lodge Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1756 1756 member Guildhall Lodge Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1757 1757 member Old Wellingtonian Sailing Association – Past Commodore Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1758 1758 member City of London Club – Committee Member Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1759 1759 member HAC Yacht Squadron Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1760 1760 member Lloyds of London Yacht Club Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1761 1761 member 1900 Club Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1762 1762 member City Livery Club Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1763 1763 member City Livery Yacht Club Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1764 1764 member Guild of Freemen Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1765 1765 member Phoenix Masters Association – Committee member Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1766 1766 member Government Task Force on Retail Social Investment Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1767 1767 member Conservative Party Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1768 1768 member Chartered Institute for Securities and Investment - Individually chartered fellow Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1769 1769 member Worshipful Company of International Bankers Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1770 1770 member CISI - Individually Chartererd Fellow Non-pecuniary interests e9002d25 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511

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 23.146ms · Data source: See col-scraper on GitHub