items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
35 rows where "date" is on date 2013-07-08 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 ▼ |
---|---|---|---|---|---|---|---|
d1f4a2aa163db59b50b224e3128ad39eb7cc7455 | Name of donor: UNICEF UK | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 0 | 2013-07-08-80ef1083-10357-0 |
c411b9ce63a06a9c37e42db8597c21a83100e9f1 | Address of donor: 30a Great Sutton Street, London EC1V 0DU | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 1 | 2013-07-08-80ef1083-10357-0 |
a55fed043aeff922e51444cf1e620f24b662b599 | Amount of donation (or estimate of the probable value): £1,825.81 | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 2 | 2013-07-08-80ef1083-10357-0 |
fa4184787034f6f942adf51808e6813cab459b24 | Destination of visit: DRC and Burundi | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 3 | 2013-07-08-80ef1083-10357-0 |
76a6c27addc2f3a7ae2d1e5bbf0d43b426be0741 | Date of visit: 18-27 July 2012 | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 4 | 2013-07-08-80ef1083-10357-0 |
8901148d1e71c97bbd0c92eb2eb72152d2bff55a | Purpose of visit: visiting UNICEF projects in the region and meetings with political leaders. | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 5 | 2013-07-08-80ef1083-10357-0 |
ec6dad57ccafb6a276053c966fe468fed46bb15b | (Registered 8 August 2012) | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 6 | 2013-07-08-80ef1083-10357-0 |
5c66169dd1311ad9e6524265a5d8610da59d4647 | Name of donor: British Council | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 7 | 2013-07-08-80ef1083-10357-0 |
0549c15ee5f8a7eaea5023b082dae8468a80bbeb | Address of donor: 10 Spring Gardens, London SW1A 2BN | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 8 | 2013-07-08-80ef1083-10357-0 |
de057b2bb2ba57724c1bfd4a7b24b403794bde83 | 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-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 9 | 2013-07-08-80ef1083-10357-0 |
83daed02757d8bb501b0df4c66f9d4b88938c95e | Destination of visit: Hammamet, Tunisia | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 10 | 2013-07-08-80ef1083-10357-0 |
7ca04f5e947e818d4063fd09b37bcc4239632f01 | Date of visit: 15-18 November 2012 | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 11 | 2013-07-08-80ef1083-10357-0 |
ea901c5b73b17a82c82bf98b01860772a0355491 | Purpose of visit: to attend the Hammamet Conference | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 12 | 2013-07-08-80ef1083-10357-0 |
d4ccb31705377f75288acea3fcd5a30935897428 | (Registered 6 December 2012) | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 13 | 2013-07-08-80ef1083-10357-0 |
0e016d5cea68ca156ae1aadd29891c4316b5917b | Name of donor: Burma Campaign UK | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 14 | 2013-07-08-80ef1083-10357-0 |
5842c32b10392cffa4d727bcafb2e095440669d8 | Address of donor: 28 Charles Square, London N1 6HT | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 15 | 2013-07-08-80ef1083-10357-0 |
58d0429a4d9a95082cc0cf81a44657097cc61d7a | 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-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 16 | 2013-07-08-80ef1083-10357-0 |
42ca9030f1e8f6e8ebde6a1479d184bcaaca2a6a | Destination of visit: Rangoon, Burma and Mae Sot, Thailand | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 17 | 2013-07-08-80ef1083-10357-0 |
379e20faf51b0797c987b67647edf5c534210f39 | Date of visit: 24 November-2 December 2012 | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 18 | 2013-07-08-80ef1083-10357-0 |
ab08f21981f3e95885a54cc87c58ae8acef541a4 | Purpose of visit: to meet political leaders, civil society organizations and refugees in Burma and the Thai-Burma border. | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 19 | 2013-07-08-80ef1083-10357-0 |
2bd8ae076fc9a570819bbd26bd882469bdd7ef05 | (Registered 7 January 2013) | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 20 | 2013-07-08-80ef1083-10357-0 |
6e5ed98a028f942c4c11fa4782f7030da849732f | Name of donor: World Vision UK | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 21 | 2013-07-08-80ef1083-10357-0 |
37d1f5bd8e271586ece2521b9d01c54d2e9002ad | Address of donor: Opal Drive, Fox Milne, Milton Keynes, MK15 0ZR | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 22 | 2013-07-08-80ef1083-10357-0 |
e4d15a14fca5927d9cadcb8d8a7aca41b8089d46 | 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-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 23 | 2013-07-08-80ef1083-10357-0 |
48356ab5f0aa92d852481b10bd960046a2681231 | Destination of visit: Gisenyi, Rwanda; and Goma, Eastern DRC | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 24 | 2013-07-08-80ef1083-10357-0 |
6a98e2778c7783b97fa0325ec5d095f46e01d475 | Date of visit: 22-23 January 2013 | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 25 | 2013-07-08-80ef1083-10357-0 |
75da2710726a359e650182637bec2cbd6539091e | Purpose of visit: Visits to projects | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 26 | 2013-07-08-80ef1083-10357-0 |
4448b1dbfb6d87f2027721f4587c0ddb3df62026 | (Registered 4 April 2013 ) | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 27 | 2013-07-08-80ef1083-10357-0 |
24a22af995b9d99385c3291555d7e02996009125 | Name of donor: Labour Friends of Israel | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 28 | 2013-07-08-80ef1083-10357-0 |
4d17858f2b75d8ab2cbf99dbb91e1c8bf7aa0415 | Address of donor: BM LFI, London W1N 3XX | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 29 | 2013-07-08-80ef1083-10357-0 |
74404223ab4eb18dd2bcaf67c29634f6c994122d | Amount of donation (or estimate of the probable value): costs of visit; £2,900 | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 30 | 2013-07-08-80ef1083-10357-0 |
506649000dfaf6d86a47a008218edf4d9e02a3d1 | Destination of visit: Israel and the Palestinian Territories | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 31 | 2013-07-08-80ef1083-10357-0 |
5e77824f9c9afdaf854dc321173e22aafc9ff349 | Date of visit: 19-24 May 2013 | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 32 | 2013-07-08-80ef1083-10357-0 |
cfc1d91423f55cc23884532a767df6aca6f00f37 | Purpose of visit: fact-finding visit to Israel and the Palestinian Territories | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 33 | 2013-07-08-80ef1083-10357-0 |
62fc0e0ea7bb6b19d9ae6559f5a2ac87dd851f52 | (Registered 6 June 2013) | Overseas visits 80ef1083 | 2013-07-08 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 34 | 2013-07-08-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");