items

Table actions

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

7 rows where record_id = "2015-03-09-8f616a6e-10534-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
2bb9cddc6e7390374f58edb559b923c617f73e23 Name of donor: CARE Sponsorships 8f616a6e 2015-03-09 Barry Sheerman uk.org.publicwhip/member/40325 Barry Sheerman uk.org.publicwhip/person/10534 0 2015-03-09-8f616a6e-10534-1
87923b619c956d33fda4d8344e82e8df602f0322 Address of donor: 53 Romney Street, London SW1P 3RF Sponsorships 8f616a6e 2015-03-09 Barry Sheerman uk.org.publicwhip/member/40325 Barry Sheerman uk.org.publicwhip/person/10534 1 2015-03-09-8f616a6e-10534-1
19fdc03504e78193031a72cd7075501606ff91f1 Amount of donation or nature and value if donation in kind: services of a voluntary intern, for 4 days a week between 29 September 2014 and July 2015, who will receive a bursary of £650 per calendar month as a member of CARE’s educational Leadership Programme, total £6,500. Sponsorships 8f616a6e 2015-03-09 Barry Sheerman uk.org.publicwhip/member/40325 Barry Sheerman uk.org.publicwhip/person/10534 2 2015-03-09-8f616a6e-10534-1
a1c28f56261b2977307c78f9843c49dae2236c72 Date of receipt: 29 September 2014 Sponsorships 8f616a6e 2015-03-09 Barry Sheerman uk.org.publicwhip/member/40325 Barry Sheerman uk.org.publicwhip/person/10534 3 2015-03-09-8f616a6e-10534-1
6422a80d5be0e779c2836145e3ee36efd0ddfe6d Date of acceptance: 29 September 2014 Sponsorships 8f616a6e 2015-03-09 Barry Sheerman uk.org.publicwhip/member/40325 Barry Sheerman uk.org.publicwhip/person/10534 4 2015-03-09-8f616a6e-10534-1
d5d14dd80313b5e4a4a455fbb82e0f085d08d600 Donor status: charity, registration 292506 Sponsorships 8f616a6e 2015-03-09 Barry Sheerman uk.org.publicwhip/member/40325 Barry Sheerman uk.org.publicwhip/person/10534 5 2015-03-09-8f616a6e-10534-1
9c4cd23427913703ee8d0ba5e98681d51100d263 (Registered 20 October 2014) Sponsorships 8f616a6e 2015-03-09 Barry Sheerman uk.org.publicwhip/member/40325 Barry Sheerman uk.org.publicwhip/person/10534 6 2015-03-09-8f616a6e-10534-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");