items

Table actions

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

3 rows where record_id = "2008-07-08-80ef1083-10070-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
15cb27eda3899f6b4d4975005423e33029fb9f6a 2-10 June 2007, to Burundi and Rwanda as a member of the All-Party Parliamentary Group on the Great Lakes Region of Africa. Flight and accommodation paid by funding provided by Christian Aid, Oxfam Novib, Action Aid and International Alert. (Registered 17 July 2007) Overseas visits 80ef1083 2008-07-08 Russell Brown uk.org.publicwhip/member/1969 Russell Brown uk.org.publicwhip/person/10070 0 2008-07-08-80ef1083-10070-0
baf54b33a4f4635838e2e3d2c575155adf0168a6 7-12 February 2008, to Ghana, to play a football match against the Ghanaian Parliament at their invitation to celebrate their 50 th anniversary of independence, to visit an SOS Villages project and a refugee camp at the invitation of PLAY Ghana, and to attend the African Nations Cup Final, with accommodation, food and local transport provided by the Parliament of Ghana and a contribution towards the air fare provide by our club sponsors National Grid,who also helped provide a charitable donation to SOS Villages. (Registered 12 June 2008) Overseas visits 80ef1083 2008-07-08 Russell Brown uk.org.publicwhip/member/1969 Russell Brown uk.org.publicwhip/person/10070 1 2008-07-08-80ef1083-10070-0
af7bc06371d176068f0d4d971550ea8ec254740f 15-16 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) Overseas visits 80ef1083 2008-07-08 Russell Brown uk.org.publicwhip/member/1969 Russell Brown uk.org.publicwhip/person/10070 2 2008-07-08-80ef1083-10070-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");