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

26 rows where category_id = "d9df90d8" and kind = "partner" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: member_id

kind 1 ✖

  • partner · 26 ✖

category_id 1 ✖

  • Land · 26 ✖
Link rowid kind name ▼ category_id member_id
1180 1180 partner 133 Cromwell Tower, Barbican, EC2Y 8DD Land d9df90d8 John Tomlinson 392
971 971 partner 2/4 SMITHFIELD Land d9df90d8 Paul Nicholas Martinelli 1217
1777 1777 partner 202 Cromwell Tower, Barbican, EC2 Land d9df90d8 Michael John Cassidy 141
973 973 partner 206 LONDON CENTRAL MARKETS Land d9df90d8 Paul Nicholas Martinelli 1217
975 975 partner 210-213 LONDON CENTRAL MARKETS Land d9df90d8 Paul Nicholas Martinelli 1217
969 969 partner 25 LCM, SMITHFIELD Land d9df90d8 Paul Nicholas Martinelli 1217
838 838 partner 48 Andrewes House, London EC2Y 8AX (leaseholder) Land d9df90d8 Mary Durcan 1957
1208 1208 partner Address at Wormwood Street, London EC2 Land d9df90d8 Simon D'Olier Duckworth 151
1105 1105 partner Andrewes House, Barbican, London. EC2Y 8AX Land d9df90d8 Ian David Luder 296
800 800 partner FLAT 5, 7 LOTHBURY CITY OF LONDON LONDON EC2R 7AP Land d9df90d8 Christopher Michael Hayward 1218
1842 1842 partner Flat 1, 43 Bartholomew Close, EC1A 7HN Land d9df90d8 Ann Holmes 1230
1195 1195 partner Flat 21 Tudor Rose Court, 35 Fann Street, London EC2Y 8DY Land d9df90d8 Peter Gordon Bennett 1888
472 472 partner Flat 81, 172 Aldersgate Street, EC1A 4HV Land d9df90d8 Sir David Hugh Wootton 397
563 563 partner Flat at Bartholomew Close, EC1 Land d9df90d8 Catherine McGuinness 373
561 561 partner Flat at Bryer Court, Barbican, EC2 Land d9df90d8 Catherine McGuinness 373
1031 1031 partner Flat within 14 Victoria House, EC4Y 0DD Land d9df90d8 Graham Packham 1221
622 622 partner Freehold Townhouse, EC2 Land d9df90d8 Nicholas Anstee 133
817 817 partner Leasehold property in London EC2 Land d9df90d8 Oliver Sells QC 1941
1504 1504 partner Lessee of property at Cromwell Tower, Barbican, EC2 Land d9df90d8 David John Bradshaw 137
327 327 partner Liveryman of Painter Stainers 9 Little Trinity Ln, London EC4V 2AD Land d9df90d8 Matthew Richardson 374
1467 1467 partner Long lease - Floor 409, Queen's Quay, Upper Thames Street, London EC4 Land d9df90d8 Ian Christopher Norman Seaton 402
1785 1785 partner Member of Skinners' Company which owns Skinners' Hall, Dowgate and other City Properties Land d9df90d8 Oliver Arthur Wynlayne Lodge 291
1301 1301 partner Owns flat in City Land d9df90d8 Henrika Johanna Sofia Priest 409
833 833 partner Queens Quay, EC4 Land d9df90d8 John David Absalom 132
744 744 partner Tenant at 301 Gilbert House, Barbican. London. EC2Y 8BD. Land d9df90d8 Natasha Maria Cabrera Lloyd-Owen 2224
816 816 partner Tenant of the Inner Temple, London EC4 Land d9df90d8 Oliver Sells QC 1941

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