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 member_id = 1229

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
268 268 member DIRECTOR PARKWELL MANAGEMENT CONSULTANTS & SUBSIDIARY COMPEER LIMITED 8, LAURENCE POUNTNEY HILL LONDON EC4R 0BE Employment, office, trade, profession or vocation e938d3aa Mark Raymond Peter Henry Delano Wheatley 1229
269 269 partner PHYSIOTHERAPIST LEWISHAM & GREENWICH NHS TRUST HIGH STREET LEWISHAM LONDON SE13 6LH Employment, office, trade, profession or vocation e938d3aa Mark Raymond Peter Henry Delano Wheatley 1229
270 270 member EQUITY STAKE IN PARKWELL MANAGEMENT CONSULTANTS: 8 LAURENCE POUNTNEY HILL LONDON EC4R 0BE Securities 4bd97394 Mark Raymond Peter Henry Delano Wheatley 1229
271 271 member DIRECTOR, HEATHBANK MANAGEMENT Non-pecuniary interests e9002d25 Mark Raymond Peter Henry Delano Wheatley 1229
272 272 member DIRECTOR, BABY FUND TRADING LTD Non-pecuniary interests e9002d25 Mark Raymond Peter Henry Delano Wheatley 1229
273 273 member DIRECTOR, COMPEER Non-pecuniary interests e9002d25 Mark Raymond Peter Henry Delano Wheatley 1229
274 274 member MEMBER, CONSERVATIVE & UNIONIST PARTY Non-pecuniary interests e9002d25 Mark Raymond Peter Henry Delano Wheatley 1229
275 275 member FREEMASON OF TWO LODGES AND ONE CHAPTER Non-pecuniary interests e9002d25 Mark Raymond Peter Henry Delano Wheatley 1229
276 276 member MEMBER, SPECULATIVE SOCIETY OF EDINBURGH Non-pecuniary interests e9002d25 Mark Raymond Peter Henry Delano Wheatley 1229
277 277 member LIVERYMAN, DRAPERS' COMPANY Non-pecuniary interests e9002d25 Mark Raymond Peter Henry Delano Wheatley 1229
278 278 member MEMBER, VINTRY & DOWGATE WARD CLUBS Non-pecuniary interests e9002d25 Mark Raymond Peter Henry Delano Wheatley 1229
279 279 member MEMBER, BRITISH CZECH-SLOVAKIAN ASSOCIATION Non-pecuniary interests e9002d25 Mark Raymond Peter Henry Delano Wheatley 1229
280 280 member MEMBER, OGNISKIE POLSKIE Non-pecuniary interests e9002d25 Mark Raymond Peter Henry Delano Wheatley 1229
281 281 member MEMBER, ANGLO-CHILEAN SOCIETY Non-pecuniary interests e9002d25 Mark Raymond Peter Henry Delano Wheatley 1229
282 282 member MEMBER, OLD KIRKHAMIAN ASSOCIATION Non-pecuniary interests e9002d25 Mark Raymond Peter Henry Delano Wheatley 1229
283 283 member MENTOR, GREENWICH EDUCATIONAL TRUST Non-pecuniary interests e9002d25 Mark Raymond Peter Henry Delano Wheatley 1229
284 284 member COMMUNICANT MEMBER OF THE CHURCH OF ENGLAND Non-pecuniary interests e9002d25 Mark Raymond Peter Henry Delano Wheatley 1229
285 285 member TRUSTEE, CITY & METROPOLITAN CHARITY Non-pecuniary interests e9002d25 Mark Raymond Peter Henry Delano Wheatley 1229

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