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

33 rows where category_id = "e9002d25" and member_id = 511

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ kind name category_id member_id
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 93.58ms · Data source: See col-scraper on GitHub