items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where record_id = "2011-11-16-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 |
---|---|---|---|---|---|---|---|
547f82d75bb32c683d228da8465c0599c087a626 | Name of donor: Great Britain China Centre | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-11-16-80ef1083-24913-0 |
70adff73b2531753f6dc78178cfd6b24d4b8c9bf | Address of donor: 15 Belgrave Square, London SW1X 8PS | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-11-16-80ef1083-24913-0 |
31162bc38f71a3abbf35a04338d8bb2e632a2344 | Amount of donation (or estimate of the probable value): £4,623 | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 2 | 2011-11-16-80ef1083-24913-0 |
56160e772416dd67554c7903ae85afb1eb5f18d4 | Destination of visit: Beijing, China | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2011-11-16-80ef1083-24913-0 |
c46dfc6b3543611b799e2555cbe90832c3dfbd5d | Date of visit: 13-17 September 2010 | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 4 | 2011-11-16-80ef1083-24913-0 |
1998306913cf0b1475f92e268b7b3dd60388259e | 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-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2011-11-16-80ef1083-24913-0 |
3cdcfe3bc8081f57d4933148c6b817bd9e91247e | (Registered 1 November 2010) | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 6 | 2011-11-16-80ef1083-24913-0 |
3131ac9157f9c2237e0b7feb59ea58c88d0e7813 | Name of donor: | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 7 | 2011-11-16-80ef1083-24913-0 |
b82f0afee74857f65959687140b9470aed21c289 | 8) Maurice Bennett | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2011-11-16-80ef1083-24913-0 |
ed854a679edcaaca817e7134e999976f73235e69 | 9) Huawei Technologies (UK) Ltd | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 9 | 2011-11-16-80ef1083-24913-0 |
604ac8e0d8cf6565ffca3d3be9191f202d230b7b | 10) International Department, Central Committee, Communist Party of China | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 10 | 2011-11-16-80ef1083-24913-0 |
8bb3681664122b32f794fb2f4002f646e565226b | Address of donor: | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2011-11-16-80ef1083-24913-0 |
08dd8bdc9f2c39f257e5a8417a9d9a032fd69e21 | 8) Private | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 12 | 2011-11-16-80ef1083-24913-0 |
95e3cf70f320f01513a8e57ae91f628aafc912a6 | 9) Viables 3, Jays Close, Basingstoke, Hampshire | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 13 | 2011-11-16-80ef1083-24913-0 |
1b888b8b2672ce7f9077b757ef140360df69aba9 | 10) 4 Flixing Road, Beijing | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 14 | 2011-11-16-80ef1083-24913-0 |
9a40ddda8729aba98caedf882b3b5c63e089632f | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 15 | 2011-11-16-80ef1083-24913-0 |
8a6842efbca500a3c79d61ac7952350b3117bb4a | 8) Flight from London to Hong Kong and flight from Beijing to London; value £650 | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 16 | 2011-11-16-80ef1083-24913-0 |
f4f675c313e9564af8dc12cab8e532a4a0a1a097 | 9) One night’s accommodation in Hong Kong; value £600 | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 17 | 2011-11-16-80ef1083-24913-0 |
fb32270a9989c6c023da10ea7ba8578ab4439c39 | 10) Flight from Shenzen to Guiyang, flight from Guiyang to Beijing, 6 nights accommodation and hospitality; value £1,000 | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 18 | 2011-11-16-80ef1083-24913-0 |
f1ee758b3e2a5623c629aa31ca1b3d1ef0944f95 | Destination of visit: Hong Kong and China | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 19 | 2011-11-16-80ef1083-24913-0 |
919bd64eb090c7e8c5153406b8f9c0a3a0a42c88 | Date of visit: 20-28 September 2011 | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 20 | 2011-11-16-80ef1083-24913-0 |
77830d3531710d289762be98ebec7d3bc5463cb3 | Purpose of visit: to meet representatives of Huawei Technologies Ltd and representatives of the Chinese Government. | Overseas visits 80ef1083 | 2011-11-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 21 | 2011-11-16-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");