items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
35 rows where "date" is on date 2013-01-18 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 ▼ |
---|---|---|---|---|---|---|---|
ce7909b8e15531e853f869ff55357ffabd9636d6 | Name of donor: ActionAid UK | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 0 | 2013-01-18-80ef1083-10357-0 |
3977601562692fb506d0984d7846b16a958a8d85 | Address of donor: 33-39 Bowling Green Lane, London EC1R 0BJ | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 1 | 2013-01-18-80ef1083-10357-0 |
8aeaa9e0e3bab7bc180c60fcb0487a90082b5846 | 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 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 2 | 2013-01-18-80ef1083-10357-0 |
9a3b76e95668b26d40655763fd9459c30acf6bfd | Destination of visit: Tanzania | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 3 | 2013-01-18-80ef1083-10357-0 |
23eefbd219f32f890d94ed22f5ec814b842bdbb8 | Date of visit: 26 January-1 February 2012 | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 4 | 2013-01-18-80ef1083-10357-0 |
5754922689185b519cc4d81022e7fda6869ee233 | 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 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 5 | 2013-01-18-80ef1083-10357-0 |
bb25a0b5dc6274971bb439b679cabb15dfd50a26 | (Registered 27 February 2012) | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 6 | 2013-01-18-80ef1083-10357-0 |
a258c8ec61cb1e2fc324886f65b964804cef5e93 | Name of donor: Oxfam GB | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 7 | 2013-01-18-80ef1083-10357-0 |
05ff9344a24bf64fa8ded933cdf81826bcb182b4 | Address of donor: Oxfam House, John Smith Drive, Cowley, Oxford OX4 2JY | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 8 | 2013-01-18-80ef1083-10357-0 |
574888e9112849dbefa51cbfeb0c7215782a1578 | 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 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 9 | 2013-01-18-80ef1083-10357-0 |
7ea514cd2f9099f862ba0ab837395b02db02bb7d | Destination of visit: Chad | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 10 | 2013-01-18-80ef1083-10357-0 |
d75b98473c918dcc4be3d2ce8d89c59635bc8934 | Date of visit: 27 February-3 March 2012 | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 11 | 2013-01-18-80ef1083-10357-0 |
a73bcf5925f7c7e8ff34f8195685e846be4bb2f1 | Purpose of visit: to investigate and discuss issues around food crisis and humanitarian response including field visit to Mangalme | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 12 | 2013-01-18-80ef1083-10357-0 |
0983037a7d3b026f9d447a1b27c95334c42632bb | (Registered 29 March 2012) | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 13 | 2013-01-18-80ef1083-10357-0 |
2e0a6a0be858c0529addb0fbd27efc9f9b6d2632 | Name of donor: UNICEF UK | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 14 | 2013-01-18-80ef1083-10357-0 |
08a8af80d2b2b13b3141c81c4c98907a854eca80 | Address of donor: 30a Great Sutton Street, London EC1V 0DU | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 15 | 2013-01-18-80ef1083-10357-0 |
0a7ffc60c0373f80eafb2463d257d525417d3e68 | Amount of donation (or estimate of the probable value): £1,825.81 | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 16 | 2013-01-18-80ef1083-10357-0 |
52bdce1e1c7b45383bf9e5d09398038c125affbf | Destination of visit: DRC and Burundi | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 17 | 2013-01-18-80ef1083-10357-0 |
6fa91a0db92f1ecc13200a02b37bd57c1283891f | Date of visit: 18-27 July 2012 | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 18 | 2013-01-18-80ef1083-10357-0 |
52f59d8d21c93ee2d72bf04de1164bf98cc88520 | Purpose of visit: visiting UNICEF projects in the region and meetings with political leaders. | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 19 | 2013-01-18-80ef1083-10357-0 |
e024a493b3da12e2da3fba8c9039472951874bff | (Registered 8 August 2012) | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 20 | 2013-01-18-80ef1083-10357-0 |
651c1f1d1888bfd77568f20e2b2de92227261ecb | Name of donor: British Council | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 21 | 2013-01-18-80ef1083-10357-0 |
8228c523a6ea0e032ccac51a77e4654851ad1e99 | Address of donor: 10 Spring Gardens, London SW1A 2BN | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 22 | 2013-01-18-80ef1083-10357-0 |
ec578964bfb3e1c8a2f5168adc3ada3f9e788ea4 | 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 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 23 | 2013-01-18-80ef1083-10357-0 |
cf19dfe466e5e2afe4c387baec3de8a2365e7cc7 | Destination of visit: Hammamet, Tunisia | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 24 | 2013-01-18-80ef1083-10357-0 |
86e05a4f091470543bd143adb3e49e4d6ab43350 | Date of visit: 15-18 November 2012 | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 25 | 2013-01-18-80ef1083-10357-0 |
b18f1cf9be1c03dd9690ce4d9950479758a206f0 | Purpose of visit: to attend the Hammamet Conference | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 26 | 2013-01-18-80ef1083-10357-0 |
f5fca2d62974a1342a0fbc448fc1109aff6a2f0b | (Registered 6 December 2012) | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 27 | 2013-01-18-80ef1083-10357-0 |
b72a3fe83c8ca166365b0b1839122d9d1e211ea9 | Name of donor: Burma Campaign UK | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 28 | 2013-01-18-80ef1083-10357-0 |
2e56c738b9b62d47aab26a97fc522d22250b2573 | Address of donor: 28 Charles Square, London N1 6HT | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 29 | 2013-01-18-80ef1083-10357-0 |
1e72e81ee2c1d441130365132aeec5c3923fc7f7 | Amount of donation (or estimate of the probable value): flights, accommodation food and other costs for me and a member of my staff, with a total value of £3,637 | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 30 | 2013-01-18-80ef1083-10357-0 |
ccff8d4ae43b103a71e8353cae43cb7028263908 | Destination of visit: Rangoon, Burma and Mae Sot, Thailand | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 31 | 2013-01-18-80ef1083-10357-0 |
4bdc46f1b9d333a3f8c6970a6e5c5a6723bb7d21 | Date of visit: 24 November-2 December 2012 | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 32 | 2013-01-18-80ef1083-10357-0 |
8ddb0dd18f5adf7d2a520dc17887a988c1f9bf4d | Purpose of visit: to meet political leaders, civil society organizations and refugees in Burma and the Thai-Burma border. | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 33 | 2013-01-18-80ef1083-10357-0 |
28e0d4d74ecc4d9511f6895645bd5421fd5305ff | (Registered 7 January 2013) | Overseas visits 80ef1083 | 2013-01-18 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 34 | 2013-01-18-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");