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 search matches "conservative"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, category_id, member_id

Link rowid ▼ kind name category_id member_id
127 127 member Member, Conservative Party Non-pecuniary interests e9002d25 Andrew Stratton McMurtrie 1225
274 274 member MEMBER, CONSERVATIVE & UNIONIST PARTY Non-pecuniary interests e9002d25 Mark Raymond Peter Henry Delano Wheatley 1229
663 663 member North East Cambridgeshire Conservative Association Employment, office, trade, profession or vocation e938d3aa Christopher Paul Boden 1219
671 671 member Member, Conservative Party Non-pecuniary interests e9002d25 Christopher Paul Boden 1219
731 731 member Member - Conservative Party Non-pecuniary interests e9002d25 Sophie Anne Fernandes 217
736 736 member Member, Hampstead and Kilburn Conservative Association Non-pecuniary interests e9002d25 Karina Dostalova 1222
805 805 member MEMBER, CONSERVATIVE PARTY Non-pecuniary interests e9002d25 Christopher Michael Hayward 1218
826 826 member Member - Conservative Party Non-pecuniary interests e9002d25 Oliver Sells QC 1941
827 827 member Think Tank - Conservative Policy Forum Non-pecuniary interests e9002d25 Oliver Sells QC 1941
1025 1025 member Member - Conservative Party Non-pecuniary interests e9002d25 James Henry George Pollard 408
1258 1258 member Member - Conservative Party Non-pecuniary interests e9002d25 Keith David Forbes Bottomley 1666
1278 1278 member Bexleyheath & Crayford Conservative Association Non-pecuniary interests e9002d25 Gregory Jones QC 1220
1317 1317 member Member, Conservative Party Non-pecuniary interests e9002d25 Jeremy Mayhew 370
1384 1384 member Member - Epping Forest Conservative Association Non-pecuniary interests e9002d25 Graeme Martyn Smith 1231
1482 1482 member Conservative Party Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1754 1754 member Conservative Party Business and Entrepreneurs Club 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
1855 1855 member Member, Conservative Party Non-pecuniary interests e9002d25 Alastair Michael Moss 1226

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