items

Table actions

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

5 rows where record_id = "2001-05-14-80ef1083-10094-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
eec14dd766edad9373ad6ac694dd53eab2365287 18 February 2000, to Florence, Italy, to speak at a conference on Welfare Reform organised by the Institute Fratelli Roselli; travel and expenses paid by the Roselli Institute. (Registered 10 March 2000) Overseas visits 80ef1083 2001-05-14 Roger Casale uk.org.publicwhip/member/94 Roger Casale uk.org.publicwhip/person/10094 0 2001-05-14-80ef1083-10094-0
3e971e257df8671d25d485ec69afcae891b03561 22-24 March 2000, to Rome, Italy, as Chairman of the British-Italian Parliamentary Group to attend a conference on British-Italian Co-operation in the Field of Justice, Immigration and Home Affairs. Meals and overnight accommodation were provided by the Italian Parliament (Carrera dei Deputati). (Registered 4 May 2000) Overseas visits 80ef1083 2001-05-14 Roger Casale uk.org.publicwhip/member/94 Roger Casale uk.org.publicwhip/person/10094 1 2001-05-14-80ef1083-10094-0
0f4d82ef0d340e1d1d8a4966a9630b0d42b1384b 18-20 May 2000, to Apeldoorn, in The Netherlands, to take part in the first UK-Netherlands Apeldoorn bi-lateral conference. Overnight accommodation, meals and travel costs were paid for by the conference sponsors who included Shell, Unilever and the Dutch Foreign Office. (Registered 26 June 2000) Overseas visits 80ef1083 2001-05-14 Roger Casale uk.org.publicwhip/member/94 Roger Casale uk.org.publicwhip/person/10094 2 2001-05-14-80ef1083-10094-0
0f44a31c701286cf5b836465ce1b88bd2b8ad023 3-6 November 2000, to Rome, Italy, as Chairman of the All-Party British Italian Parliamentary Group and Head of the British delegation to the Jubilee celebrations for Parliamentarians. I travelled at the invitation of the organising Committee of the All-Party Parliamentary Group on Parliamentarians for the Jubilee Year in the Italian Senate, which also paid for my hotel accommodation in Rome. The All-Party British Italian Parliamentary Group paid for my travel costs. (Registered 6 December 2000) Overseas visits 80ef1083 2001-05-14 Roger Casale uk.org.publicwhip/member/94 Roger Casale uk.org.publicwhip/person/10094 3 2001-05-14-80ef1083-10094-0
13ccf79d529e8f4ea1beeb37afd83c6a60fc1834 19-22 November 2000, to Rome, Italy, to attend an international conference for Parliamentarians of Italian origin at the invitation of the Speaker of the Italian Chamber of Deputies. The Italian Parliament paid for my hotel accommodation in Rome and my travel expenses. (Registered 6 December 2000) Overseas visits 80ef1083 2001-05-14 Roger Casale uk.org.publicwhip/member/94 Roger Casale uk.org.publicwhip/person/10094 4 2001-05-14-80ef1083-10094-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");