items

Table actions

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

6 rows where record_id = "2013-06-24-8f616a6e-10143-0" 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
8fac19d8ea59e0326c4837707c80de1e7ccbba5d Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: Sponsorships 8f616a6e 2013-06-24 John Cryer uk.org.publicwhip/member/40366 John Cryer uk.org.publicwhip/person/10143 0 2013-06-24-8f616a6e-10143-0
eded2a1f8c767e4bef76fff73d6204076be6d18c Name of donor: Leyton and Wanstead CLP Sponsorships 8f616a6e 2013-06-24 John Cryer uk.org.publicwhip/member/40366 John Cryer uk.org.publicwhip/person/10143 1 2013-06-24-8f616a6e-10143-0
c5d7568d515a5c5477fac34dab0d7cc8bd0298e9 Address of donor: c/o The Labour Party, One Brewers Green, Buckingham Gate, London SW1H 0RH Sponsorships 8f616a6e 2013-06-24 John Cryer uk.org.publicwhip/member/40366 John Cryer uk.org.publicwhip/person/10143 2 2013-06-24-8f616a6e-10143-0
f7a531918be7d0a1457d3e4014be405e470c9640 Amount of donation or nature and value if donation in kind: £2,731 net total raised at a fundraising event on 21 November 2012 for the benefit of Leyton and Wanstead CLP. No individual registrable donations were received. Sponsorships 8f616a6e 2013-06-24 John Cryer uk.org.publicwhip/member/40366 John Cryer uk.org.publicwhip/person/10143 3 2013-06-24-8f616a6e-10143-0
61c7ce2625e2720c667d41ac51bc532108590e3d Donor status: unincorporated association Sponsorships 8f616a6e 2013-06-24 John Cryer uk.org.publicwhip/member/40366 John Cryer uk.org.publicwhip/person/10143 4 2013-06-24-8f616a6e-10143-0
8d302e9b25632ca358e3e57bc91bb748b0c626e3 (Registered 9 January 2013) Sponsorships 8f616a6e 2013-06-24 John Cryer uk.org.publicwhip/member/40366 John Cryer uk.org.publicwhip/person/10143 5 2013-06-24-8f616a6e-10143-0

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