items

Table actions

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

3 rows where record_id = "2009-06-10-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
ae58a909a892419c45025b40b27913984360752b 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-06-10 Alan Whitehead uk.org.publicwhip/member/1828 Alan Whitehead uk.org.publicwhip/person/10630 0 2009-06-10-80ef1083-10630-0
f52a857b9b40e779184cd11389cda87b7b9247ae 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-06-10 Alan Whitehead uk.org.publicwhip/member/1828 Alan Whitehead uk.org.publicwhip/person/10630 1 2009-06-10-80ef1083-10630-0
c6f482ec8cdad9682c98d12c2140c6eaa58e482d 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-06-10 Alan Whitehead uk.org.publicwhip/member/1828 Alan Whitehead uk.org.publicwhip/person/10630 2 2009-06-10-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");