items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where "date" is on date 2012-12-19 and person_id = "uk.org.publicwhip/person/10357" sorted by member_id
This data as json, CSV (advanced)
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
4a81cb1cbd71ea28fcb0dba9ba5e39540e7ebd54 | Name of donor: ActionAid UK | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 0 | 2012-12-19-80ef1083-10357-0 |
09bc019db5cf7a1b6cbc985baf8f88d1c2d7ce4f | Address of donor: 33-39 Bowling Green Lane, London EC1R 0BJ | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 1 | 2012-12-19-80ef1083-10357-0 |
c54d8062563d92c4fa1fdb77901f3b79d8270240 | Amount of donation (or estimate of the probable value): Air fare, transport, accommodation and costs associated with field visits and meetings for me and a member of my staff; value £2,800 | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 2 | 2012-12-19-80ef1083-10357-0 |
6d67aca8837c3be0d008715c4ef1292941eada09 | Destination of visit: Tanzania | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 3 | 2012-12-19-80ef1083-10357-0 |
87e4445446903fab77058941d6a93662c6bc51d1 | Date of visit: 26 January-1 February 2012 | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 4 | 2012-12-19-80ef1083-10357-0 |
8ba70d0f0d63d85f62b6a64455cb52642a3889e8 | Purpose of visit: to investigate and discuss issues around food security and land rights, including an immersion with a rural family in Kisarawe and field visits to Bagamoyo. | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 5 | 2012-12-19-80ef1083-10357-0 |
6cefaa1e863a6d776116ff8493cd2695b80f0bb0 | (Registered 27 February 2012) | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 6 | 2012-12-19-80ef1083-10357-0 |
610647ed5b80889daec87aebf0b05091a7672396 | Name of donor: Oxfam GB | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 7 | 2012-12-19-80ef1083-10357-0 |
4f46c9129bc130b19fc334c18c3c3af5f1f7b0f1 | Address of donor: Oxfam House, John Smith Drive, Cowley, Oxford OX4 2JY | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 8 | 2012-12-19-80ef1083-10357-0 |
6cd2ce604e7bba045a2a8f96714c4772ff813d5a | Amount of donation (or estimate of the probable value): air fare, transport, accommodation, visas and field visit for me and a member of my staff; total cost £3,397.38 | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 9 | 2012-12-19-80ef1083-10357-0 |
1b6805dcb575057319189c7aa95608417cab751d | Destination of visit: Chad | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 10 | 2012-12-19-80ef1083-10357-0 |
331514aaebd56533bd21575cc995b26bec24891e | Date of visit: 27 February-3 March 2012 | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 11 | 2012-12-19-80ef1083-10357-0 |
40cac59c2222e2f2ba362da544f86135546acc44 | Purpose of visit: to investigate and discuss issues around food crisis and humanitarian response including field visit to Mangalme | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 12 | 2012-12-19-80ef1083-10357-0 |
a87f7e8d5f7cd9854d52003bc085872aa4236d8b | (Registered 29 March 2012) | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 13 | 2012-12-19-80ef1083-10357-0 |
81dd38208a8781737ef5447da610e2d73b11cdb7 | Name of donor: UNICEF UK | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 14 | 2012-12-19-80ef1083-10357-0 |
3b6a1edf8edf1a0a3b4ca04b6737f9416e68361c | Address of donor: 30a Great Sutton Street, London EC1V 0DU | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 15 | 2012-12-19-80ef1083-10357-0 |
964c4d39550e0d58b559f85f5e411785b95d5299 | Amount of donation (or estimate of the probable value): £1,825.81 | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 16 | 2012-12-19-80ef1083-10357-0 |
5af657546b61a7218c839d0e8b83d5e814d02a6e | Destination of visit: DRC and Burundi | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 17 | 2012-12-19-80ef1083-10357-0 |
666b764200674722c1fdda7f0a9bfe37628666d1 | Date of visit: 18-27 July 2012 | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 18 | 2012-12-19-80ef1083-10357-0 |
7acfc07c61ca1215a1553c15aea746254e0a9249 | Purpose of visit: visiting UNICEF projects in the region and meetings with political leaders. | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 19 | 2012-12-19-80ef1083-10357-0 |
ad3e98ee65fc5d7ac7cb459d3965f8ad38a7b210 | (Registered 8 August 2012) | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 20 | 2012-12-19-80ef1083-10357-0 |
152575f61e5c9e58d63650b89af4b51c1253b376 | Name of donor: British Council | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 21 | 2012-12-19-80ef1083-10357-0 |
b3af95c9d2c6e302ee331eed2f284a7c0172799e | Address of donor: 10 Spring Gardens, London SW1A 2BN | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 22 | 2012-12-19-80ef1083-10357-0 |
8a262aad872b30f0a89e4d85190e38d9b1f949fd | Amount of donation (or estimate of the probable value): costs of visit for me and a member of my staff; total £867.66 | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 23 | 2012-12-19-80ef1083-10357-0 |
acb1d65abc3257df6855437a2981dd6075b5d041 | Destination of visit: Hammamet, Tunisia | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 24 | 2012-12-19-80ef1083-10357-0 |
800229bec1e2228f7f437c1547754af987cc2d62 | Date of visit: 15-18 November 2012 | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 25 | 2012-12-19-80ef1083-10357-0 |
451210cd5f993c31a8405a43d6ad22a670533299 | Purpose of visit: to attend the Hammamet Conference | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 26 | 2012-12-19-80ef1083-10357-0 |
bcb352b41e5f155b00c6182a10f1872398f9caec | (Registered 6 December 2012) | Overseas visits 80ef1083 | 2012-12-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 27 | 2012-12-19-80ef1083-10357-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");