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

9 rows where member_id = 231

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
335 335 partner Self Employed Tutor working from home Employment, office, trade, profession or vocation e938d3aa David Andrew Graves 231
336 336 member Flat in Seddon House, Barbican,EC2 Land d9df90d8 David Andrew Graves 231
337 337 member Licences to use 1 x parking space and 1 x baggage store Land d9df90d8 David Andrew Graves 231
338 338 member Licences to use 1 x parking space and 1 x baggage store at Barbican, EC2 Licences 613aec30 David Andrew Graves 231
339 339 member Cripplegate Foundation Non-pecuniary interests e9002d25 David Andrew Graves 231
340 340 member St Paul's Cathedral Chorister Trust Non-pecuniary interests e9002d25 David Andrew Graves 231
341 341 member Cripplegate Ward Club Non-pecuniary interests e9002d25 David Andrew Graves 231
342 342 member Barbican Association Non-pecuniary interests e9002d25 David Andrew Graves 231
343 343 member Member of City Heritage Non-pecuniary interests e9002d25 David Andrew Graves 231

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