items

Table actions

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

3 rows where record_id = "2009-01-14-80ef1083-10630-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
f5497ecf43d452f746653b91e6dc5d927a682844 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 2009-01-14 Alan Whitehead uk.org.publicwhip/member/1828 Alan Whitehead uk.org.publicwhip/person/10630 0 2009-01-14-80ef1083-10630-0
923308f395a30feff50cd837aed3ace6e11ce38b 15-17 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 2009-01-14 Alan Whitehead uk.org.publicwhip/member/1828 Alan Whitehead uk.org.publicwhip/person/10630 1 2009-01-14-80ef1083-10630-0
3c981d1af42894a573e0412f0b5c1b22beaf38f0 28-29 October 2008, to Mexico City to promote the development of NISP Mexico. Flight and accommodation paid for by the National Industrial Symbiosis Programme. (Registered 16 December 2008) Overseas visits 80ef1083 2009-01-14 Alan Whitehead uk.org.publicwhip/member/1828 Alan Whitehead uk.org.publicwhip/person/10630 2 2009-01-14-80ef1083-10630-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");