items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2013-12-09-80ef1083-24954-0" sorted by record_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
9b4dcb738971213815928db42c77843e9b6637c4 | Name of donor: | Overseas visits 80ef1083 | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 0 | 2013-12-09-80ef1083-24954-0 |
586fb469c094784d92557c25109de1962cc7764b | 1) UK-China Forum (UKCF) Ltd, with sponsorship support from BP, Barclays and Rolls Royce. | Overseas visits 80ef1083 | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 1 | 2013-12-09-80ef1083-24954-0 |
f9ffdd6b25efb3bfeaf6275973ba671eb171fb3d | 2) International Department of Central Committee of the Communist Party of China (IDCPC) | Overseas visits 80ef1083 | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 2 | 2013-12-09-80ef1083-24954-0 |
24e550b44dfabf3994f5d3e68e805643dd9f6313 | Address of donor: | Overseas visits 80ef1083 | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 3 | 2013-12-09-80ef1083-24954-0 |
bb191948709dad8000a26bb2a7c0c153b6186ce2 | 1) UKCF, 15 Belgrave Square, London SW1X 8PS | Overseas visits 80ef1083 | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 4 | 2013-12-09-80ef1083-24954-0 |
8eefd4b8d8a52cd6284e6ed85b985181a87af30f | 2) IDCPC, 4 Fuxing Lu, Beijing 100860, China | Overseas visits 80ef1083 | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 5 | 2013-12-09-80ef1083-24954-0 |
7cd76de1829c7df5fe91c0a390927affbef08e0b | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 6 | 2013-12-09-80ef1083-24954-0 |
03f642033109a0fef30b9ce66a32358fd3d38a48 | 1) Business class flights paid by UKCF; cost £3,196 | Overseas visits 80ef1083 | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 7 | 2013-12-09-80ef1083-24954-0 |
f01fbeedf96a12e08d99443219607442c53d25a0 | 2) Hotel and meals paid by IDCPC; estimated cost £376 | Overseas visits 80ef1083 | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 8 | 2013-12-09-80ef1083-24954-0 |
84ccf9fcaa67f0dc2840798788ee713690129892 | Destination of visit: Beijing, China | Overseas visits 80ef1083 | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 9 | 2013-12-09-80ef1083-24954-0 |
0072fa2a9f8a52e879cefec7cfef095349355cba | Date of visit: 12-16 January 2013 | Overseas visits 80ef1083 | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 10 | 2013-12-09-80ef1083-24954-0 |
b362d34046d0785d8e38f1cb34b0e0703be6d7ad | Purpose of visit: to attend the UK-China Leadership Forum, an annual event organised by the Great Britain-China Centre to further mutual understanding and strengthen UK-China relations. | Overseas visits 80ef1083 | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 11 | 2013-12-09-80ef1083-24954-0 |
8e15cddc03024224f4f3980b5d1bd26b49917180 | (Registered 29 January 2013) | Overseas visits 80ef1083 | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 12 | 2013-12-09-80ef1083-24954-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");