items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
37 rows where "date" is on date 2012-11-19 and person_id = "uk.org.publicwhip/person/10357" sorted by record_id
This data as json, CSV (advanced)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
524a33711507080cd13ba9f699766d007d514024 | Name of donor: | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 0 | 2012-11-19-80ef1083-10357-0 |
3879285ac1a6cea0c08186b7ed1a7ca04b262746 | 1) The GAVI Alliance Secretariat | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 1 | 2012-11-19-80ef1083-10357-0 |
36281d8236f6d6f877d137c4b1be14acb43605e5 | 2) International Vaccine Access Centre (IVAC) | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 2 | 2012-11-19-80ef1083-10357-0 |
9452edf50b0d2f70ccb69e2f06fa98ef26d15659 | 3) Oxfam GB | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 3 | 2012-11-19-80ef1083-10357-0 |
27619b7996725100ca5cecd8dfaa7b96113e9c82 | Address of donor: | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 4 | 2012-11-19-80ef1083-10357-0 |
3374a16fd0f2cbfd5380c87ba64ef6a76bac827c | 1) 2 Chemin des Mines, CH-12-2, Geneva, Switzerland | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 5 | 2012-11-19-80ef1083-10357-0 |
226022352861e6e52f86b2f2bc8152c5ff4a9093 | 2) John Hopkins School of Public Health, John Hopkins University, 615 N. Wolfe Street, Baltimore, MD 21205 | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 6 | 2012-11-19-80ef1083-10357-0 |
f539dca5c5d67aeb2718cb033cf24388db7c7d94 | 3) John Smith House, Cowley, Oxfordshire OX4 2JY | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 7 | 2012-11-19-80ef1083-10357-0 |
058b1902aabc222d624ab6d6f1594a00c3353bfe | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 8 | 2012-11-19-80ef1083-10357-0 |
c93144450d01cc6897a00910af0aadb5cc1f597f | 1) Travel and accommodation for me; value £2,440 | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 9 | 2012-11-19-80ef1083-10357-0 |
b8a9cd95b0c44e3644eb207246cf3c153357e6d1 | 2) Travel and accommodation for a member of my staff; value £3,188 | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 10 | 2012-11-19-80ef1083-10357-0 |
d7653e1759d8de17a18ba052087cde41a148d026 | 3) Field visit in Bangladesh for me and a member of my staff; air and boat travel, food, accommodation and car hire; total value £263 | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 11 | 2012-11-19-80ef1083-10357-0 |
7327e87bf737aa1f82596f18004506a9cdef8517 | Destination of visit: Bangladesh | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 12 | 2012-11-19-80ef1083-10357-0 |
bad765ee1949f5e697626c618a5e5510c424f9e7 | Date of visit: 10-15 November 2011 | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 13 | 2012-11-19-80ef1083-10357-0 |
543d8c53ed79cd7b642880641fccf1f30b92ed85 | Purpose of visit: All-Party Parliamentary Group for Global Action Against Childhood Pneumonia visit, to inspect child health and pneumonia facilities in and around Dhaka in response to an invitation from the Bangladesh Ministry of Health. | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 14 | 2012-11-19-80ef1083-10357-0 |
fbedaa2f93c3e241298927bec90fde2b0bba25bd | (Registered 30 November 2011) | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 15 | 2012-11-19-80ef1083-10357-0 |
6fdc8324003c8a312c236baccd0d566d90b10ab9 | Name of donor: ActionAid UK | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 16 | 2012-11-19-80ef1083-10357-0 |
250fec6db43699627fe8580f9dc80a5516453c62 | Address of donor: 33-39 Bowling Green Lane, London EC1R 0BJ | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 17 | 2012-11-19-80ef1083-10357-0 |
00ea7652521b6c080dffa91e8c5666ca8593ab54 | 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-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 18 | 2012-11-19-80ef1083-10357-0 |
58ff1d9ddb458d8041cb2d8e00861f96fffafa3d | Destination of visit: Tanzania | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 19 | 2012-11-19-80ef1083-10357-0 |
24b1accee4e73cf0be729a83f926fa7cfe5e88cb | Date of visit: 26 January-1 February 2012 | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 20 | 2012-11-19-80ef1083-10357-0 |
1810e2b12c0c3f55ef5329acda27add9b356d7e4 | 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-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 21 | 2012-11-19-80ef1083-10357-0 |
fb80972b208b80a6bf4dbc382754050aedcb58c1 | (Registered 27 February 2012) | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 22 | 2012-11-19-80ef1083-10357-0 |
2eda1bb199846ed2a4b1bb57d5f7e880f1a46f14 | Name of donor: Oxfam GB | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 23 | 2012-11-19-80ef1083-10357-0 |
f69bd881426179a3999e262b27f32b78de045a9c | Address of donor: Oxfam House, John Smith Drive, Cowley, Oxford OX4 2JY | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 24 | 2012-11-19-80ef1083-10357-0 |
f9eba7c25c92c3d96ceb8c824db274ecd7bfe3dc | 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-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 25 | 2012-11-19-80ef1083-10357-0 |
a45443a35928b0afe46b245e721db13baa3c016e | Destination of visit: Chad | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 26 | 2012-11-19-80ef1083-10357-0 |
4d692e3f2d23d1c971ef10e1afc223c5ba2fefda | Date of visit: 27 February-3 March 2012 | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 27 | 2012-11-19-80ef1083-10357-0 |
da3adc27be4a63a45adaa26423b31ed2282f5679 | Purpose of visit: to investigate and discuss issues around food crisis and humanitarian response including field visit to Mangalme | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 28 | 2012-11-19-80ef1083-10357-0 |
633b5efd6422c8ca524ef86fff2890a7579d6399 | (Registered 29 March 2012) | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 29 | 2012-11-19-80ef1083-10357-0 |
54655ef03ae8918d1b1868913d5f7c4fd128a72a | Name of donor: UNICEF UK | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 30 | 2012-11-19-80ef1083-10357-0 |
fed03602da15c0fb0659bade0937c33bd90f452f | Address of donor: 30a Great Sutton Street, London EC1V 0DU | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 31 | 2012-11-19-80ef1083-10357-0 |
fdc31815cc9cb79c7a6f8f40a93ac45ad143782f | Amount of donation (or estimate of the probable value): £1,825.81 | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 32 | 2012-11-19-80ef1083-10357-0 |
2973f0d9840ef0bef5b5717f53fdd87b76176601 | Destination of visit: DRC and Burundi | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 33 | 2012-11-19-80ef1083-10357-0 |
b0c3356b729d34adaac5a45d863095c039865307 | Date of visit: 18-27 July 2012 | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 34 | 2012-11-19-80ef1083-10357-0 |
5de7b05a598deaee43569cbcf0da67f81818d96b | Purpose of visit: visiting UNICEF projects in the region and meetings with political leaders. | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 35 | 2012-11-19-80ef1083-10357-0 |
489dc0cf58627b2f2e4307b372dec5a63332bcb6 | (Registered 8 August 2012) | Overseas visits 80ef1083 | 2012-11-19 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 36 | 2012-11-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");