items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
35 rows where "date" is on date 2013-07-29 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 ▼ |
---|---|---|---|---|---|---|---|
53651a972ff460735f1dd909b55e370b71e669cb | Name of donor: UNICEF UK | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 0 | 2013-07-29-80ef1083-10357-0 |
90e9be01bd58b0befffad54ae588486310ddc370 | Address of donor: 30a Great Sutton Street, London EC1V 0DU | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 1 | 2013-07-29-80ef1083-10357-0 |
de192a5c849906999dedaa433ad7e4d9732197c0 | Amount of donation (or estimate of the probable value): £1,825.81 | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 2 | 2013-07-29-80ef1083-10357-0 |
ad27363a757dbad673420cd1994e58c47a015215 | Destination of visit: DRC and Burundi | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 3 | 2013-07-29-80ef1083-10357-0 |
40aa90414a4fe516f466916a5d75aad55bda1793 | Date of visit: 18-27 July 2012 | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 4 | 2013-07-29-80ef1083-10357-0 |
d464091ee012a2254836379942989fc451e7d0f0 | Purpose of visit: visiting UNICEF projects in the region and meetings with political leaders. | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 5 | 2013-07-29-80ef1083-10357-0 |
060e0d803405704ca84421f8f8c7b4f62f479ebd | (Registered 8 August 2012) | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 6 | 2013-07-29-80ef1083-10357-0 |
22215f95696b08f48f14fa272524fa2d4874280d | Name of donor: British Council | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 7 | 2013-07-29-80ef1083-10357-0 |
b6078075d16bbc6f663c1579f949e6aa039e3957 | Address of donor: 10 Spring Gardens, London SW1A 2BN | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 8 | 2013-07-29-80ef1083-10357-0 |
9a2acd597c7431939f64d6c07029e61028cf4199 | 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-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 9 | 2013-07-29-80ef1083-10357-0 |
c6c1c881cf399e90e69ff7b64ca71a70412b35fe | Destination of visit: Hammamet, Tunisia | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 10 | 2013-07-29-80ef1083-10357-0 |
074f0dc7e843521deb581dac570e6a020d88f359 | Date of visit: 15-18 November 2012 | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 11 | 2013-07-29-80ef1083-10357-0 |
cee80a7391dea76aa36af7a2b0b7b44f9f7fc231 | Purpose of visit: to attend the Hammamet Conference | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 12 | 2013-07-29-80ef1083-10357-0 |
9c0bdedc7ba9a06bc4a291784e3f925e0e3e57a5 | (Registered 6 December 2012) | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 13 | 2013-07-29-80ef1083-10357-0 |
7a27dc49da8d5268e87aad1a35341f487f0966bb | Name of donor: Burma Campaign UK | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 14 | 2013-07-29-80ef1083-10357-0 |
8f204297dc1ea9da0b3e23f0faa0f1d9e1566c81 | Address of donor: 28 Charles Square, London N1 6HT | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 15 | 2013-07-29-80ef1083-10357-0 |
c249a02c079dc5480ea1098e8ef0046f966ae016 | 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-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 16 | 2013-07-29-80ef1083-10357-0 |
0817604788989220dcdeb24ae2d504d1972e2272 | Destination of visit: Rangoon, Burma and Mae Sot, Thailand | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 17 | 2013-07-29-80ef1083-10357-0 |
833eb1a19edd58c9929687c1140975f631f6ab49 | Date of visit: 24 November-2 December 2012 | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 18 | 2013-07-29-80ef1083-10357-0 |
7faa72f05fa25b6d3e94cee89f80949d4a489c45 | Purpose of visit: to meet political leaders, civil society organizations and refugees in Burma and the Thai-Burma border. | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 19 | 2013-07-29-80ef1083-10357-0 |
fc656f6cb00e8f58eb4a65d4bcea4fe78327289f | (Registered 7 January 2013) | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 20 | 2013-07-29-80ef1083-10357-0 |
c0c10fa80a9665a240e8468a24f55f9ed8e89fd8 | Name of donor: World Vision UK | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 21 | 2013-07-29-80ef1083-10357-0 |
28c07ca9b36d2c20c0dc1e0e9b64873dffd527e7 | Address of donor: Opal Drive, Fox Milne, Milton Keynes, MK15 0ZR | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 22 | 2013-07-29-80ef1083-10357-0 |
bf66c23ac591230e15804637e4cadf83d4bff2cf | 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-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 23 | 2013-07-29-80ef1083-10357-0 |
69df22820a687cf77de4bce3dbeb5597c1f47f06 | Destination of visit: Gisenyi, Rwanda; and Goma, Eastern DRC | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 24 | 2013-07-29-80ef1083-10357-0 |
034e4cb64d951d25eb26a9c7d822ef9c44eca502 | Date of visit: 22-23 January 2013 | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 25 | 2013-07-29-80ef1083-10357-0 |
8c20a1305919ccc8e2f322b89414dcbdaabe0b6a | Purpose of visit: Visits to projects | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 26 | 2013-07-29-80ef1083-10357-0 |
0ced69980cb32558868b2e85184cbed6e7d2b891 | (Registered 4 April 2013 ) | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 27 | 2013-07-29-80ef1083-10357-0 |
3bb7d8bbacc42f34bdfebabdd89c38f21e96448e | Name of donor: Labour Friends of Israel | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 28 | 2013-07-29-80ef1083-10357-0 |
b80c282447c5de4d4507d4755e7e705dcdd9dbdb | Address of donor: BM LFI, London W1N 3XX | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 29 | 2013-07-29-80ef1083-10357-0 |
e640fd488a2f8c43cc6e49c74431195d69517817 | Amount of donation (or estimate of the probable value): costs of visit; £2,900 | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 30 | 2013-07-29-80ef1083-10357-0 |
b315a96fdf51a092b491f5d006c1b3dd2a461f78 | Destination of visit: Israel and the Palestinian Territories | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 31 | 2013-07-29-80ef1083-10357-0 |
a94c882f1eec214852cb68f31eeb6a32c9e18197 | Date of visit: 19-24 May 2013 | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 32 | 2013-07-29-80ef1083-10357-0 |
63e5fbd0492be6ce5c17e75da080e8f359ede42d | Purpose of visit: fact-finding visit to Israel and the Palestinian Territories | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 33 | 2013-07-29-80ef1083-10357-0 |
50862051123b1aa33b364f6029127c3f632d369b | (Registered 6 June 2013) | Overseas visits 80ef1083 | 2013-07-29 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 34 | 2013-07-29-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");