items

Table actions

Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

3 rows where record_id = "2015-03-30-9e46def6-11740-1" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
af4cae9354a809b78ecb07de2543e74f9b75ff0f Name of donor: Morley and Outwood CLP Sponsorship or financial or material support 9e46def6 2015-03-30 Edward Balls uk.org.publicwhip/member/40411 Edward Balls uk.org.publicwhip/person/11740 0 2015-03-30-9e46def6-11740-1
f1712ef9ec54d36370c716cb41bf538f083a992a Address of donor: c/o Morley Labour Rooms, Unity Hall, 2 Commercial Street, Morley, Leeds LS27 8HY Sponsorship or financial or material support 9e46def6 2015-03-30 Edward Balls uk.org.publicwhip/member/40411 Edward Balls uk.org.publicwhip/person/11740 1 2015-03-30-9e46def6-11740-1
5d0999ee7ed0b45fb341befd85652448877b96dd Amount of donation or nature and value if donation in kind: money raised at and following a London fundraising event on 25 February 2014 organised by and for the benefit of Morley and Outwood Labour Party and in support of Dover and Deal Constituency and other Constituency Labour Parties. The total raised was £56,885.56 of which Morley and Outwood CLP received £36,885.56, Dover and Deal CLP received £12,000, and eight other West Yorkshire CLPs each received £1,000. (Registered 10 April 2014) Sponsorship or financial or material support 9e46def6 2015-03-30 Edward Balls uk.org.publicwhip/member/40411 Edward Balls uk.org.publicwhip/person/11740 2 2015-03-30-9e46def6-11740-1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE items (
        hash VARCHAR(40) NOT NULL,
        item TEXT,
        category_id TEXT,
        date TEXT,
        member_id TEXT,
        person_id TEXT,
        sort_order INTEGER,
        record_id TEXT,
        PRIMARY KEY (hash),
        FOREIGN KEY ("category_id") REFERENCES [categories](id),
        FOREIGN KEY ("member_id") REFERENCES [members](id),
        FOREIGN KEY ("person_id") REFERENCES [people](id)
    );
CREATE INDEX items_date ON items("date");
CREATE INDEX items_category_id ON items("category_id");
CREATE INDEX items_member_id ON items("member_id");
CREATE INDEX items_person_id ON items("person_id");
CREATE INDEX items_record_id ON items("record_id");