items

Table actions

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

3 rows where record_id = "2002-05-14-80ef1083-11003-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
c37c56eb0f4e3c0411f0f123970978f0402fbc5f 1 January 2002, I received a day return ticket to Amsterdam provided by KLM/Air UK as part of an event organised by North East in Europe to bring the first Euro notes to the North East of England. (Registered 10 January 2002) Overseas visits 80ef1083 2002-05-14 Kevan Jones uk.org.publicwhip/member/1003 Kevan Jones uk.org.publicwhip/person/11003 0 2002-05-14-80ef1083-11003-0
2c5583a1634e9110c7cf0d3d6a2bb86681bbc85d 14-22 February 2002, to the Falkland Islands, paid for by the Falkland Islands Government. (Registered 23 February 2002) Overseas visits 80ef1083 2002-05-14 Kevan Jones uk.org.publicwhip/member/1003 Kevan Jones uk.org.publicwhip/person/11003 1 2002-05-14-80ef1083-11003-0
70d4b3f7d66ae174aae787a443839ed606381071 17-23 March 2002, to USA. Seven nights' accommodation at The Capital Hotel, Little Rock, Arkansas, paid for by Little Rock Convention Tourist Bureau (Registered 19 April 2002) Overseas visits 80ef1083 2002-05-14 Kevan Jones uk.org.publicwhip/member/1003 Kevan Jones uk.org.publicwhip/person/11003 2 2002-05-14-80ef1083-11003-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");