items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
23 rows where record_id = "2012-11-05-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 |
---|---|---|---|---|---|---|---|
3f8ac3aadea9e9f9d0a07106eae26f5a1a2dfb6e | Name of donor: | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2012-11-05-80ef1083-24913-0 |
34cd91cbd37c721de3dd1c6d16a48b3432928c27 | 1) Maurice Bennett | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2012-11-05-80ef1083-24913-0 |
0431459865e66db2841b2bb3ccd2143c2c420dfe | 2) Huawei Technologies (UK) Ltd | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 2 | 2012-11-05-80ef1083-24913-0 |
3a631f377cd18be4277bb818fe29d7488febb781 | 3) International Department, Central Committee, Communist Party of China | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2012-11-05-80ef1083-24913-0 |
f7525bbfdbb7863040f3dff7792715ca58835d07 | Address of donor: | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 4 | 2012-11-05-80ef1083-24913-0 |
35de066dafea176c1c06732105e6c62c0b60a157 | 1) Private | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2012-11-05-80ef1083-24913-0 |
7b74c8d38e58970f72ba4cb017fe792445ced98f | 2) Viables 3, Jays Close, Basingstoke, Hampshire | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 6 | 2012-11-05-80ef1083-24913-0 |
642db96575787cd38ef3a0a6059a2d4d9f4674a0 | 3) 4 Flixing Road, Beijing | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 7 | 2012-11-05-80ef1083-24913-0 |
b0391acd6751d255f04748fe2ae41e9dbe6e93dc | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2012-11-05-80ef1083-24913-0 |
a933b4deed70144f6bf42e32ab9a24f98e54f387 | 1) Flight from London to Hong Kong and flight from Beijing to London; value £650 | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 9 | 2012-11-05-80ef1083-24913-0 |
b7ec5f33878bbd659064c2b27ed7c2dad58d3887 | 2) One night’s accommodation in Hong Kong; value £600 | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 10 | 2012-11-05-80ef1083-24913-0 |
d12de07814393222ce4d3b234650e50270cd9f75 | 3) Flight from Shenzen to Guiyang, flight from Guiyang to Beijing, 6 nights accommodation and hospitality; value £1,000 | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2012-11-05-80ef1083-24913-0 |
6c0a218ff3b521ec846968cdbce6a4109fd7ac63 | Destination of visit: Hong Kong and China | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 12 | 2012-11-05-80ef1083-24913-0 |
47e46af4844b1a2fed08cb2c6135b59a545360d6 | Date of visit: 20-28 September 2011 | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 13 | 2012-11-05-80ef1083-24913-0 |
ed79fcbcddd5da2709674f06dfe7714eb7cb3091 | Purpose of visit: to meet representatives of Huawei Technologies Ltd and representatives of the Chinese Government. | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 14 | 2012-11-05-80ef1083-24913-0 |
9538a5e7b1aaf4c28b4546bcb11ea1dc0286dbac | (Registered 19 October 2011) | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 15 | 2012-11-05-80ef1083-24913-0 |
a791350ca77f6ce57fddd7f2549c3c5083390ad0 | Name of donor: Aberdeen Asset Management | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 16 | 2012-11-05-80ef1083-24913-0 |
fa5addde01c6dae279f22693d6f39defe9e3f505 | Address of donor: Bow Bells House, 1 Bread Street, London EC4M 9HH | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 17 | 2012-11-05-80ef1083-24913-0 |
16033cf19c8e8f85c110fec58945e4adcd099a81 | Amount of donation (or estimate of the probable value): cost of visit; £4,227.73 | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 18 | 2012-11-05-80ef1083-24913-0 |
1dc56d5cca047c4df777d127d8cfd7d415919f59 | Destination of visit: Singapore | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 19 | 2012-11-05-80ef1083-24913-0 |
94a942fc7faafe4491b1bfd089a2fc3fa32687a1 | Date of visit: 3-7 March 2012 | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 20 | 2012-11-05-80ef1083-24913-0 |
6eef5b7b78c34a83c0d02caf40d2345bb8ec3e3d | Purpose of visit: as part of the Industry and Parliament Trust Scheme for MPs: to gain a deeper understanding of what is needed to support growth; how universities and higher education institutions are supporting the private sector; sectors of interest are education, energy, financial services, manufacturing and mining. | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 21 | 2012-11-05-80ef1083-24913-0 |
3318c9a9e6c8781597c64749830d1882fd949c22 | (Registered 16 March 2012) | Overseas visits 80ef1083 | 2012-11-05 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 22 | 2012-11-05-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");