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

14 rows where category_id = "613aec30"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, name, member_id

Link rowid ▼ kind name category_id member_id
31 31 member Tenant, Union House, Martin Lane, EC4 Licences 613aec30 Edward Lord 292
338 338 member Licences to use 1 x parking space and 1 x baggage store at Barbican, EC2 Licences 613aec30 David Andrew Graves 231
524 524 member Tenancy at will - 7B Amen Court, Warwick Lane, London. EC4M 7BU Licences 613aec30 James de Sausmarez 1658
645 645 member Company Member of Sarasin & Partners LLP and the firm leases Juxon House, 100 St Paul's Churchyard, London, EC4M 8BU. Licences 613aec30 Nicholas Michael Bensted-Smith 1472
839 839 member Own car parking space in Andrewes House Licences 613aec30 Mary Durcan 1957
840 840 partner Own car parking space in Andrewes House Licences 613aec30 Mary Durcan 1957
938 938 member Corporation Tenant - 20, 22, 217-218 Central Markets, Smithfield, London EC1 Licences 613aec30 George Christopher Abrahams 131
1356 1356 member In 2018 Deloitte will occupy 1 New Street Square, London EC4 Licences 613aec30 Angus Knowles-Cutler 1943
1448 1448 member GROUND FLOOR, NICHOLAS HOUSE, 3 LAURENCE POUTNEY HILL, LONDON. Licences 613aec30 Alastair John Naisbitt King 269
1498 1498 member JDC Consultants Ltd. Ninth Floor, 40 Lime Street London EC3M 7AW Licences 613aec30 John Douglas Chapman 160
1715 1715 member Car parking space and store cupboards (x 2), Barbican Licences 613aec30 Vivienne Littlechild 287
1736 1736 member City of London Club (Freehold held) - Committee Member Licences 613aec30 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1737 1737 partner City of London Club (Freehold held) - Committee Member Licences 613aec30 Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511
1821 1821 member Ironmongers' Hall, Shaftesbury Place, London, EC2 Licences 613aec30 Dr Giles Robert Evelyn Shilson 383

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