items
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
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
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");