items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2014-01-20-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 ▼ |
---|---|---|---|---|---|---|---|
7b5761a9755da0d60b7af4cc873080811e311b61 | Name of donor: | Overseas visits 80ef1083 | 2014-01-20 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 0 | 2014-01-20-80ef1083-24954-0 |
22f2c4c8181585fbf8c3ec5d87ee9e5e8c609dfb | 1) UK-China Forum (UKCF) Ltd, with sponsorship support from BP, Barclays and Rolls Royce. | Overseas visits 80ef1083 | 2014-01-20 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 1 | 2014-01-20-80ef1083-24954-0 |
4487efb4862878a91458d6f21757ccfc937ea273 | 2) International Department of Central Committee of the Communist Party of China (IDCPC) | Overseas visits 80ef1083 | 2014-01-20 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 2 | 2014-01-20-80ef1083-24954-0 |
01176fea2b6b14d22ee78ed553d2f179ea7c156f | Address of donor: | Overseas visits 80ef1083 | 2014-01-20 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 3 | 2014-01-20-80ef1083-24954-0 |
7f80124d4aed970503dd12f5accea7a3dbf66428 | 1) UKCF, 15 Belgrave Square, London SW1X 8PS | Overseas visits 80ef1083 | 2014-01-20 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 4 | 2014-01-20-80ef1083-24954-0 |
f906185f94f2c21296a29046f3ee57e97696e14d | 2) IDCPC, 4 Fuxing Lu, Beijing 100860, China | Overseas visits 80ef1083 | 2014-01-20 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 5 | 2014-01-20-80ef1083-24954-0 |
286d611d91cb8c847ab7a3957fe29416737e99b9 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2014-01-20 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 6 | 2014-01-20-80ef1083-24954-0 |
460c993809cd2bab9a96f7e9cbd8fe1f2ab9fe44 | 1) Business class flights paid by UKCF; cost £3,196 | Overseas visits 80ef1083 | 2014-01-20 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 7 | 2014-01-20-80ef1083-24954-0 |
a883c68888e2c2a7c93b50dbdd8ec1964a31dfca | 2) Hotel and meals paid by IDCPC; estimated cost £376 | Overseas visits 80ef1083 | 2014-01-20 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 8 | 2014-01-20-80ef1083-24954-0 |
0d1b749d902d09c5fbd0f4808d59bdb7fa8313ee | Destination of visit: Beijing, China | Overseas visits 80ef1083 | 2014-01-20 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 9 | 2014-01-20-80ef1083-24954-0 |
36b67cc1335eae3c518d50f177b2cd6f2e7db63c | Date of visit: 12-16 January 2013 | Overseas visits 80ef1083 | 2014-01-20 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 10 | 2014-01-20-80ef1083-24954-0 |
8b2e6748ae6e8ac828a02b33585e43e036acfbf4 | 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 | 2014-01-20 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 11 | 2014-01-20-80ef1083-24954-0 |
28e9542c376e8b287429819b9b9aae8e672708f1 | (Registered 29 January 2013) | Overseas visits 80ef1083 | 2014-01-20 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 12 | 2014-01-20-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");