items

Table actions

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

5 rows where record_id = "2002-05-14-80ef1083-10190-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
618ee1633d4f3a92850596baccff145c24e03a85 19-20 June 2001, Parliamentary Space Committee visit to the Paris Air Show. Travel and accommodation provided by the UK Industrial Space Committee and hospitality by the European Space Agency and EUTELSAT. (Registered 19 July 2001) Overseas visits 80ef1083 2002-05-14 Nigel Evans uk.org.publicwhip/member/878 Nigel Evans uk.org.publicwhip/person/10190 0 2002-05-14-80ef1083-10190-0
71ebead3ced55f7dc1659fb56b68f2db90ac6224 21-30 September 2001, to China on fact-finding visit. Flights and hotels paid for by Britain Club and Chinese Association of Friendship and International Understanding. International flights sponsored by BMC Properties and Management Ltd. (Registered 15 October 2001) Overseas visits 80ef1083 2002-05-14 Nigel Evans uk.org.publicwhip/member/878 Nigel Evans uk.org.publicwhip/person/10190 1 2002-05-14-80ef1083-10190-0
b85a2f4a3521021e54a87a6070d8c7d2bd76e830 8 November 2001, to Toulouse, paid for by Astrium to visit their satellite manufacturers. (Registered 18 December 2001) Overseas visits 80ef1083 2002-05-14 Nigel Evans uk.org.publicwhip/member/878 Nigel Evans uk.org.publicwhip/person/10190 2 2002-05-14-80ef1083-10190-0
20b18ccf5060c7bce61e0ebf9f6071f5afb1cfc3 14-18 February 2002, to Gibraltar as member of a parliamentary delegation, as a guest of the Government of Gibraltar. (Registered 4 March 2002) Overseas visits 80ef1083 2002-05-14 Nigel Evans uk.org.publicwhip/member/878 Nigel Evans uk.org.publicwhip/person/10190 3 2002-05-14-80ef1083-10190-0
c8eef085a166d99a606d9762c20fe0e85a9b76b9 1-4 February 2002, to Kuwait as a guest of the Kuwait Information Office. (Registered 4 March 2002) Overseas visits 80ef1083 2002-05-14 Nigel Evans uk.org.publicwhip/member/878 Nigel Evans uk.org.publicwhip/person/10190 4 2002-05-14-80ef1083-10190-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");