items

Table actions

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

3 rows where record_id = "2000-11-10-80ef1083-10407-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
5ba34e7a86e4990606679081fe9fc88eae94d584 17-19 April, to Yugoslavia, part of my expenses paid for by the Daily Mirror. I paid the remainder myself. (Registered 21 April 1999) Overseas visits 80ef1083 2000-11-10 Alice Mahon uk.org.publicwhip/member/407 Alice Mahon uk.org.publicwhip/person/10407 0 2000-11-10-80ef1083-10407-0
58fee0d8a3d7b77e032b1c80b477d41522694d5b 10-14 October 1999, to Bahrain, accompanied by my spouse, for study tour at the invitation and expense of the Gulf Centre for Strategic Studies. (Registered 10 November 1999) Overseas visits 80ef1083 2000-11-10 Alice Mahon uk.org.publicwhip/member/407 Alice Mahon uk.org.publicwhip/person/10407 1 2000-11-10-80ef1083-10407-0
be8b3bbdf7781e6ac8cbc047bd3aeb3e99263f85 20-27 April 2000, to Egypt, with my husband, at the invitation and expense of the Egyptian Government. (Registered 15 May 2000) Overseas visits 80ef1083 2000-11-10 Alice Mahon uk.org.publicwhip/member/407 Alice Mahon uk.org.publicwhip/person/10407 2 2000-11-10-80ef1083-10407-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");