items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
35 rows where "date" is on date 2013-06-10 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 |
---|---|---|---|---|---|---|---|
81efd9b36b5666c317ba4361f2509e9989a7ee45 | Name of donor: UNICEF UK | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 0 | 2013-06-10-80ef1083-10357-0 |
1e3301267180c180bb06b377d0b408d0b60a054a | Address of donor: 30a Great Sutton Street, London EC1V 0DU | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 1 | 2013-06-10-80ef1083-10357-0 |
bc0d728adeefd79aeb2d63f2190fbda238427a91 | Amount of donation (or estimate of the probable value): £1,825.81 | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 2 | 2013-06-10-80ef1083-10357-0 |
47f11010fc560f576ed6c6179b367eaa0e758f57 | Destination of visit: DRC and Burundi | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 3 | 2013-06-10-80ef1083-10357-0 |
856bae9f4ab6c5436933962a965cd68ce13d1c41 | Date of visit: 18-27 July 2012 | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 4 | 2013-06-10-80ef1083-10357-0 |
a56ce85c97b55243194d0765ff97d86511ae118d | Purpose of visit: visiting UNICEF projects in the region and meetings with political leaders. | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 5 | 2013-06-10-80ef1083-10357-0 |
89711bf33166d55cd3381ae6405aa4184e916062 | (Registered 8 August 2012) | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 6 | 2013-06-10-80ef1083-10357-0 |
b65b1e4a680ec91528741ce090e6e584b82d81f8 | Name of donor: British Council | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 7 | 2013-06-10-80ef1083-10357-0 |
81838f7b41636f159bcf91cc4f540b5ba42d0537 | Address of donor: 10 Spring Gardens, London SW1A 2BN | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 8 | 2013-06-10-80ef1083-10357-0 |
961cceb9d1ae8f4598cc7ac37f864e8cd8d00b6e | 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-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 9 | 2013-06-10-80ef1083-10357-0 |
f26b802d73ed38c49324ab21d0779dbc19135919 | Destination of visit: Hammamet, Tunisia | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 10 | 2013-06-10-80ef1083-10357-0 |
a2ff3390d248ed00a94f7dab9dadae4ab8f39898 | Date of visit: 15-18 November 2012 | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 11 | 2013-06-10-80ef1083-10357-0 |
415d11d19f4c23cd8ee67c219b51f7551adeb3c8 | Purpose of visit: to attend the Hammamet Conference | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 12 | 2013-06-10-80ef1083-10357-0 |
6969402808c017c577897a847330ca801752f683 | (Registered 6 December 2012) | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 13 | 2013-06-10-80ef1083-10357-0 |
60f832e1dc215cf8caff18e183538a1bc12bba56 | Name of donor: Burma Campaign UK | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 14 | 2013-06-10-80ef1083-10357-0 |
58ed987d9ae06a779c323fefb68e5bfdad773b0f | Address of donor: 28 Charles Square, London N1 6HT | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 15 | 2013-06-10-80ef1083-10357-0 |
09cca2241e6aa3000eb7bcc12445e46f39be555c | 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-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 16 | 2013-06-10-80ef1083-10357-0 |
6f3d5421d64d20758b982df982fa47c037ca16f2 | Destination of visit: Rangoon, Burma and Mae Sot, Thailand | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 17 | 2013-06-10-80ef1083-10357-0 |
9b0d7feb5efe929073ed376e5d093528401602e3 | Date of visit: 24 November-2 December 2012 | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 18 | 2013-06-10-80ef1083-10357-0 |
35aa5e6ca4bf8ca0bbc33d8152f9f013fbf601f5 | Purpose of visit: to meet political leaders, civil society organizations and refugees in Burma and the Thai-Burma border. | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 19 | 2013-06-10-80ef1083-10357-0 |
c9fa98a9e066b018ae3cf813b028c085d8bb4764 | (Registered 7 January 2013) | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 20 | 2013-06-10-80ef1083-10357-0 |
87efeeae5b2010256bed01c93bd8a0cd096b2216 | Name of donor: World Vision UK | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 21 | 2013-06-10-80ef1083-10357-0 |
d868be9dcbf677ee745bcb69b7975ef666051e07 | Address of donor: Opal Drive, Fox Milne, Milton Keynes, MK15 0ZR | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 22 | 2013-06-10-80ef1083-10357-0 |
706eb28e88920ae8d4f70d8cc85202c00903041c | Amount of donation (or estimate of the probable value): accommodation, food, transport and entry cards for myself and one member of staff, with a total value of £ 847.68 | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 23 | 2013-06-10-80ef1083-10357-0 |
103ccfbe2faef01841d3f944eb1ee3ea5a802d36 | Destination of visit: Gisenyi, Rwanda; and Goma, Eastern DRC | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 24 | 2013-06-10-80ef1083-10357-0 |
7ff7bc1c4c991c78365dc0f4831463534bae74ad | Date of visit: 22-23 January 2013 | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 25 | 2013-06-10-80ef1083-10357-0 |
88e3e43f558490fc89ca4fbf8404494fa5e41f7e | Purpose of visit: Visits to projects | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 26 | 2013-06-10-80ef1083-10357-0 |
d622a2f7920f01c4a6d1878773e4a170640c38ab | (Registered 4 April 2013 ) | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 27 | 2013-06-10-80ef1083-10357-0 |
4e429a79c48afa97f9bf3e1333df0f50337a42c6 | Name of donor: Labour Friends of Israel | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 28 | 2013-06-10-80ef1083-10357-0 |
95b9899603224b6a2e89007a16bfddc505bb9043 | Address of donor: BM LFI, London W1N 3XX | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 29 | 2013-06-10-80ef1083-10357-0 |
a61caa06e971c73a01d2ab3b3d0236713184e6a8 | Amount of donation (or estimate of the probable value): costs of visit; £2,900 | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 30 | 2013-06-10-80ef1083-10357-0 |
9423c19eb55c211e6e1f1c242310b8565af6aefd | Destination of visit: Israel and the Palestinian Territories | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 31 | 2013-06-10-80ef1083-10357-0 |
dde18ce43495a717340fcdbaf2e1b1ba1c9b7b3d | Date of visit: 19-24 May 2013 | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 32 | 2013-06-10-80ef1083-10357-0 |
11eb1ff5dd5c88b1d24e64636502a7e0f2ddb24d | Purpose of visit: fact-finding visit to Israel and the Palestinian Territories | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 33 | 2013-06-10-80ef1083-10357-0 |
4d0041575fc5e77f5a17697d6bcf30d067c6fbba | (Registered 6 June 2013) | Overseas visits 80ef1083 | 2013-06-10 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 34 | 2013-06-10-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");