items

Table actions

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

2 rows where record_id = "2009-01-14-80ef1083-10367-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
c71020cd7f1457285596e1faa40b4b316b4111b6 25-31 August 2007, to Colombia, on human rights issues including meetings with trade unions,representatives of civil society and the Colombian government. All costs were borne by thecampaigning organisation, Justice for Colombia. (Registered 11 March 2008) Overseas visits 80ef1083 2009-01-14 Tony Lloyd uk.org.publicwhip/member/1705 Tony Lloyd uk.org.publicwhip/person/10367 0 2009-01-14-80ef1083-10367-0
839d7b238c234d7470c45f8a2a68ad8da05a2488 5-10 November 2007, to Russia, to promote the Fellowships of the John Smith Trust. All costs of thevisit borne by the John Smith Trust. (Registered 11 March 2008) Overseas visits 80ef1083 2009-01-14 Tony Lloyd uk.org.publicwhip/member/1705 Tony Lloyd uk.org.publicwhip/person/10367 1 2009-01-14-80ef1083-10367-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");