items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where record_id = "2011-12-13-80ef1083-24913-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
da75a8489b5c2f35bf52c3ed02620bf2a4ecb8a4 | Name of donor: Great Britain China Centre | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-12-13-80ef1083-24913-0 |
bd65b51e2c6d8614ec313946db3e6832cc9a5e66 | Address of donor: 15 Belgrave Square, London SW1X 8PS | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-12-13-80ef1083-24913-0 |
6a4352983d2afb30d426e91ec13ae18a05e40876 | Amount of donation (or estimate of the probable value): £4,623 | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 2 | 2011-12-13-80ef1083-24913-0 |
5947b5e0f59d6bac63b5a1bb3e4eeafe9f21b421 | Destination of visit: Beijing, China | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2011-12-13-80ef1083-24913-0 |
e725e95a2ddfdf47e48e6598f952e7be8bd29478 | Date of visit: 13-17 September 2010 | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 4 | 2011-12-13-80ef1083-24913-0 |
79cf4b4064d535260da24508b12dbbfd3831e421 | Purpose of visit: to attend annual Leadership Forum with the Chinese Communist Party for political leaders in China and UK and associated activities | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2011-12-13-80ef1083-24913-0 |
e3a68d1f7293f66fb00822372067b95f1669613a | (Registered 1 November 2010) | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 6 | 2011-12-13-80ef1083-24913-0 |
475f6b88bb9ef6de4102746afe5effaec961b0f7 | Name of donor: | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 7 | 2011-12-13-80ef1083-24913-0 |
9142fb6471747996c2af500cb455f35223ddf238 | 8) Maurice Bennett | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2011-12-13-80ef1083-24913-0 |
2ec78b806662a5eb4206056c07e36c782af272fc | 9) Huawei Technologies (UK) Ltd | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 9 | 2011-12-13-80ef1083-24913-0 |
c130644adef8b32db5ec8079b8ae3322c3f71a4c | 10) International Department, Central Committee, Communist Party of China | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 10 | 2011-12-13-80ef1083-24913-0 |
0378570035dcf0c79dcc8a1a70f912a1fb0414a2 | Address of donor: | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2011-12-13-80ef1083-24913-0 |
faf282c3053440e7a857697356d2f1ddb343b8ab | 8) Private | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 12 | 2011-12-13-80ef1083-24913-0 |
1e5a971261030c057bfca993165206ab59e973d5 | 9) Viables 3, Jays Close, Basingstoke, Hampshire | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 13 | 2011-12-13-80ef1083-24913-0 |
ee8b09d66c021577c9839011f33faefb0bde10b5 | 10) 4 Flixing Road, Beijing | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 14 | 2011-12-13-80ef1083-24913-0 |
62e613ad55c5ac7d7626740e38ab7a3497baf392 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 15 | 2011-12-13-80ef1083-24913-0 |
0d54facc72d7df564a4204d24800d16ff503fab1 | 8) Flight from London to Hong Kong and flight from Beijing to London; value £650 | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 16 | 2011-12-13-80ef1083-24913-0 |
f2e339ed055f3dadd558f5c3fe10e697c2e85b4a | 9) One night’s accommodation in Hong Kong; value £600 | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 17 | 2011-12-13-80ef1083-24913-0 |
d8d9bb50ae00ec4c0bc0a7d6daf11c3580d6a937 | 10) Flight from Shenzen to Guiyang, flight from Guiyang to Beijing, 6 nights accommodation and hospitality; value £1,000 | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 18 | 2011-12-13-80ef1083-24913-0 |
d3b7e3767f84262a358281c8e3ab6395a34710d3 | Destination of visit: Hong Kong and China | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 19 | 2011-12-13-80ef1083-24913-0 |
b7166e3941aa0f3d379c7a3b7c6982c21cb26710 | Date of visit: 20-28 September 2011 | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 20 | 2011-12-13-80ef1083-24913-0 |
d4fda07ea9efa6f735d697bfbac171f21f11002f | Purpose of visit: to meet representatives of Huawei Technologies Ltd and representatives of the Chinese Government. | Overseas visits 80ef1083 | 2011-12-13 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 21 | 2011-12-13-80ef1083-24913-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");