items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where person_id = "uk.org.publicwhip/person/10139" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, member_id, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
2e8e545d3ab653739ace2c1254e0d9e2c9c4a712 | 9-18 May 2002, to China, as a member of a delegation from the All-Party China Group. Cost of hotels, hospitality and transport in China were met by the Chinese Government and Air China upgraded an economy fare to Business Class. (Registered 16 July 2002) | Overseas visits 80ef1083 | 2002-11-26 | James Cran uk.org.publicwhip/member/825 | James Cran uk.org.publicwhip/person/10139 | 0 | 2002-11-26-80ef1083-10139-0 |
a023335ed9bce34da68b2fca1c5dcd2f3f057463 | 2-7 June 2002, to Norway, as a member of the British-Norwegian All-Party Group, sponsored by the Norwegian Government and Storting, and including an off-shore visit to Oseberg platform courtesy of Norsk Hydro. (Registered 16 July 2002) | Overseas visits 80ef1083 | 2002-11-26 | James Cran uk.org.publicwhip/member/825 | James Cran uk.org.publicwhip/person/10139 | 1 | 2002-11-26-80ef1083-10139-0 |
5437970c115f94aae132c16be16fad039aa40bb7 | 24-29 September 2002, to Poland, to visit Polish parliamentarians in Warsaw. Hospitality, hotel and internal travel paid for by Adam Mickiewicz Institute. (Registered 30 September 2002) | Overseas visits 80ef1083 | 2002-11-26 | James Cran uk.org.publicwhip/member/825 | James Cran uk.org.publicwhip/person/10139 | 2 | 2002-11-26-80ef1083-10139-0 |
c3fd32cbceb5fd2ddc079b7e09eb97cafac8c477 | Various fees from television and lectures. | Remunerated employment, office, profession, etc. f3967f4d | 2001-05-14 | James Cran uk.org.publicwhip/member/139 | James Cran uk.org.publicwhip/person/10139 | 0 | 2001-05-14-f3967f4d-10139-0 |
f5eb4892f29faf57f1c7475b2bc207bd33fd5348 | Various fees from television and lectures. | Remunerated employment, office, profession, etc. f3967f4d | 2000-11-10 | James Cran uk.org.publicwhip/member/139 | James Cran uk.org.publicwhip/person/10139 | 0 | 2000-11-10-f3967f4d-10139-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");