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

23 rows where member_id = 394

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
1474 1474 member Partner, Venner Shipley LLP Employment, office, trade, profession or vocation e938d3aa James Richard Tumbridge 394
1475 1475 member Director of the five companies of the Kinetica Group of companies Employment, office, trade, profession or vocation e938d3aa James Richard Tumbridge 394
1476 1476 member Tribunal Chairman (Police) Employment, office, trade, profession or vocation e938d3aa James Richard Tumbridge 394
1477 1477 member Non Executive Director of Kanto Elect Employment, office, trade, profession or vocation e938d3aa James Richard Tumbridge 394
1478 1478 member American Bar Association (ABA) Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1479 1479 member Chartered Institute of Patent Attorneys (CIPA) Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1480 1480 member Chartered Institute of Trade Mark Attorneys (CITMA) Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1481 1481 member Clothworkers' Company Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1482 1482 member Conservative Party Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1483 1483 member Director of AIPPI UK Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1484 1484 member Director of the Kinetica Group of Companies Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1485 1485 member Elected councillor on Brentwood Borough Council Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1486 1486 member International Association for the Protection of Intellectual Property (AIPPI), UK Council Member Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1487 1487 member Police Tribunal Chairman Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1488 1488 member International Bar Association (IBA), ADR Committee Member Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1489 1489 member International Trade Mark Association (INTA), Committee Member Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1490 1490 member Member of Lincoln’s Inn Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1491 1491 member Member of the Chartered Institute of Arbitration (MCIArb.) Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1492 1492 member Member of the Honourable Society of the Middle Temple Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1493 1493 member Member of Tower Ward Club Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1494 1494 member Masonic Charitable Foundation Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1495 1495 member The Intellectual Property Lawyers’ Organisation (TIPLO) Non-pecuniary interests e9002d25 James Richard Tumbridge 394
1496 1496 member UNION of European Patent Attorneys Non-pecuniary interests e9002d25 James Richard Tumbridge 394

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