items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
35 rows where "date" is on date 2013-02-04 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 ▼ |
---|---|---|---|---|---|---|---|
83918d2fc7000e208bf62849fe66eb8df3bebdea | Name of donor: ActionAid UK | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 0 | 2013-02-04-80ef1083-10357-0 |
487d7ce025b7196281d56fa34f9fc1ef2da99898 | Address of donor: 33-39 Bowling Green Lane, London EC1R 0BJ | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 1 | 2013-02-04-80ef1083-10357-0 |
d05f5407a8903bb8cc91f2916189241ff18e6f2b | 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-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 2 | 2013-02-04-80ef1083-10357-0 |
bc77b17868388604218c6e5ac019acc164441ec2 | Destination of visit: Tanzania | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 3 | 2013-02-04-80ef1083-10357-0 |
01bf4bf365af5988f9dbf3add379f16540201016 | Date of visit: 26 January-1 February 2012 | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 4 | 2013-02-04-80ef1083-10357-0 |
e6ea9d43ac8a4a8af903f18e2f812d1b6005c71c | 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-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 5 | 2013-02-04-80ef1083-10357-0 |
f9f70c74c36abebe4f8a7170c2e82d96988068e6 | (Registered 27 February 2012) | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 6 | 2013-02-04-80ef1083-10357-0 |
7dc78331114a93127ea775b0ac3f5576178fb351 | Name of donor: Oxfam GB | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 7 | 2013-02-04-80ef1083-10357-0 |
35cb4ce16b60bf3e46e1a7d56e412d3cfa688c0b | Address of donor: Oxfam House, John Smith Drive, Cowley, Oxford OX4 2JY | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 8 | 2013-02-04-80ef1083-10357-0 |
e662870802a644ee2e6ca2c08491339629cc95b1 | 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-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 9 | 2013-02-04-80ef1083-10357-0 |
7861ef861dbf7b227895fffa8132aec0954305b0 | Destination of visit: Chad | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 10 | 2013-02-04-80ef1083-10357-0 |
1b7380eee9c7a72b0942c89c5fdf42d1c3b4f500 | Date of visit: 27 February-3 March 2012 | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 11 | 2013-02-04-80ef1083-10357-0 |
a26799adfaf66360c10e4f21f6c6372ede5ee21d | Purpose of visit: to investigate and discuss issues around food crisis and humanitarian response including field visit to Mangalme | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 12 | 2013-02-04-80ef1083-10357-0 |
a12d3ed81b6c15337eb4155756cd45af12a2eefe | (Registered 29 March 2012) | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 13 | 2013-02-04-80ef1083-10357-0 |
391f3bc3b5ac86a027b4ae2444b40527a74ee6bb | Name of donor: UNICEF UK | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 14 | 2013-02-04-80ef1083-10357-0 |
d164f7060a904af4c4d46b52bdf245aba5a020fb | Address of donor: 30a Great Sutton Street, London EC1V 0DU | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 15 | 2013-02-04-80ef1083-10357-0 |
8a3cfb0c12b09e501898da330ed18afde7b9085f | Amount of donation (or estimate of the probable value): £1,825.81 | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 16 | 2013-02-04-80ef1083-10357-0 |
78cb5e6636a74823653f336cccd2fd2417aeefaa | Destination of visit: DRC and Burundi | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 17 | 2013-02-04-80ef1083-10357-0 |
0e38b2f95cdcb249ea2d912ba48f03ffcce23d4a | Date of visit: 18-27 July 2012 | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 18 | 2013-02-04-80ef1083-10357-0 |
6baa17508e941c6708d4bc5e9fbb5a42a94679e3 | Purpose of visit: visiting UNICEF projects in the region and meetings with political leaders. | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 19 | 2013-02-04-80ef1083-10357-0 |
201d6e6b94ca3091cb60494bf368f1f71318eaab | (Registered 8 August 2012) | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 20 | 2013-02-04-80ef1083-10357-0 |
983d1ce47ff94b4261dfba7f8a6ba562284bcafd | Name of donor: British Council | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 21 | 2013-02-04-80ef1083-10357-0 |
ee841a311c9c2bea3b4945d74e1a11807f96fa86 | Address of donor: 10 Spring Gardens, London SW1A 2BN | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 22 | 2013-02-04-80ef1083-10357-0 |
75b37b650fe05408f5a7315e2e40de8a7fcdae98 | 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-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 23 | 2013-02-04-80ef1083-10357-0 |
20592d197278386b023762176b1658d01953a393 | Destination of visit: Hammamet, Tunisia | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 24 | 2013-02-04-80ef1083-10357-0 |
1050b32d907a015c6c0ec9fd44f16e057839324b | Date of visit: 15-18 November 2012 | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 25 | 2013-02-04-80ef1083-10357-0 |
b2cd8ca04027075410263f0915f6af14208aa368 | Purpose of visit: to attend the Hammamet Conference | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 26 | 2013-02-04-80ef1083-10357-0 |
01abf5f7af069aa7c6e0aba294dc0481ae3316e2 | (Registered 6 December 2012) | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 27 | 2013-02-04-80ef1083-10357-0 |
9701252bfd2b7ee5ca14d4874138ba9afc772b50 | Name of donor: Burma Campaign UK | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 28 | 2013-02-04-80ef1083-10357-0 |
85f8df3de4ce75fbea245fadfc99a9c3c71c242e | Address of donor: 28 Charles Square, London N1 6HT | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 29 | 2013-02-04-80ef1083-10357-0 |
d24a821c4ab6cbdce2868fcb46ba073e11a594b0 | 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-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 30 | 2013-02-04-80ef1083-10357-0 |
e383f90a45e88651ed861d086f264cb5e789ff06 | Destination of visit: Rangoon, Burma and Mae Sot, Thailand | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 31 | 2013-02-04-80ef1083-10357-0 |
8ddbbd8141ad45cfe996709ca15cc30ec76081ea | Date of visit: 24 November-2 December 2012 | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 32 | 2013-02-04-80ef1083-10357-0 |
bd34219c99bbe614d6fd0a213bb8cd2c5001c89b | Purpose of visit: to meet political leaders, civil society organizations and refugees in Burma and the Thai-Burma border. | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 33 | 2013-02-04-80ef1083-10357-0 |
8ac440a0632cd8b9d40989c56ef400ea7b37c67c | (Registered 7 January 2013) | Overseas visits 80ef1083 | 2013-02-04 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 34 | 2013-02-04-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");