items

Table actions

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

5 rows where record_id = "2004-12-03-80ef1083-10115-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
92edf0ada23b136f613d272bdb8e97cc8ac2e597 22-27 April 2004, to Beijing, to participate in a DaimlerChrysler International Advisory Board meeting. Fee and travel and accommodation expenses for my wife and me paid by DaimlerChrysler. (Registered 5 May 2004) Overseas visits 80ef1083 2004-12-03 Kenneth Clarke uk.org.publicwhip/member/802 Kenneth Clarke uk.org.publicwhip/person/10115 0 2004-12-03-80ef1083-10115-0
02ad0947e2033ad7af5947f2efae473feaf6454a 27-31 May 2004, to Russia to take part in a seminar; travel and accommodation paid for by the Moscow School of Political Studies. (Registered 8 June 2004) Overseas visits 80ef1083 2004-12-03 Kenneth Clarke uk.org.publicwhip/member/802 Kenneth Clarke uk.org.publicwhip/person/10115 1 2004-12-03-80ef1083-10115-0
52373b2fb5484792d3a3996bfa1a9177f5d7ff25 3-6 June 2004, to Stresa, Italy, to attend Bilderberg Conference. I paid for my own air fare; the hotel accommodation for three nights was paid for by the organisers. (Registered 8 June 2004) Overseas visits 80ef1083 2004-12-03 Kenneth Clarke uk.org.publicwhip/member/802 Kenneth Clarke uk.org.publicwhip/person/10115 2 2004-12-03-80ef1083-10115-0
250b792f7b44946467300c4e7020e183519f22f6 3-8 September 2004, to Stockholm to speak at a seminar to celebrate the 50th anniversary of the British/Swedish Chamber of Commerce. Travel expenses for my wife and me paid by the British/Swedish Chamber of Commerce. (Registered 13 October 2004) Overseas visits 80ef1083 2004-12-03 Kenneth Clarke uk.org.publicwhip/member/802 Kenneth Clarke uk.org.publicwhip/person/10115 3 2004-12-03-80ef1083-10115-0
e8012df9c863934c9443b5495a8ef57f72b9528c 30 October-4 November 2004, to Botswana with the All-Party Parliamentary Group for Botswana. My flight from Johannesburg to Botswana and from Botswana to London Heathrow and all internal travel and accommodation in Botswana were paid for by the Government of Botswana. (Registered 16 November 2004) Overseas visits 80ef1083 2004-12-03 Kenneth Clarke uk.org.publicwhip/member/802 Kenneth Clarke uk.org.publicwhip/person/10115 4 2004-12-03-80ef1083-10115-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");