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

6 rows where category_id = "d9d60c21"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ kind name category_id member_id
378 378 member Clockwork Retail Ltd Sponsorship d9d60c21 Dhruv Patel 1224
669 669 member 'NOTIONAL' EXPENDITURE TOWARDS MY ELECTION EXPENSES WAS INCURRED BY CHARLES GEE MANAGEMENT SERVICES LTD, GRAHAM PACKHAM CC, NIGEL CHALLIS CC,HENRIKA PRIEST CC. IN EACH CASE THE NOTIONAL EXPENDITURE WAS RECORDED IN MY RETURN OF ELECTION EXPENSES AND IN NO CASE DID MY SHARE OF THE VALUE OF THE NOTIONAL EXPENSE EXCEED £70. Sponsorship d9d60c21 Christopher Paul Boden 1219
742 742 member Support from the City of London Branch of the Labour Party for election expenses Sponsorship d9d60c21 Natasha Maria Cabrera Lloyd-Owen 2224
810 810 member City of London Labour Party Sponsorship d9d60c21 William Pimlott 1936
836 836 member Support from City of London Branch of the Labour Party for election expenses Sponsorship d9d60c21 Mary Durcan 1957
1055 1055 member Ten Trinity Square Club; Reignwood Group Sponsorship d9d60c21 Timothy Russell Hailes 1260

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