items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
31 rows where "date" is on date 2012-01-13 and person_id = "uk.org.publicwhip/person/10357" sorted by record_id
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
790925c88303133daff552dbcb1013d428a126e8 | Name of donor: | Overseas visits 80ef1083 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 0 | 2012-01-13-80ef1083-10357-0 |
1867d740b72dadd25c2a3c84732d1c7da072d2b2 | 2) The GAVI Alliance Secretariat | Overseas visits 80ef1083 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 1 | 2012-01-13-80ef1083-10357-0 |
5c84aad4f4436989e36e392047ac8f3ef81d7917 | 3) International Vaccine Access Centre (IVAC) | Overseas visits 80ef1083 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 2 | 2012-01-13-80ef1083-10357-0 |
157c378ab67461fb8fe6280cfa659844cf73cf9f | 4) Oxfam GB | Overseas visits 80ef1083 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 3 | 2012-01-13-80ef1083-10357-0 |
56e027478911e4a720ff85a7db966472f0f3b798 | Address of donor: | Overseas visits 80ef1083 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 4 | 2012-01-13-80ef1083-10357-0 |
4be674aa3e486c0f748ce4b82c95dc05a0ae2a02 | 2) 2 Chemin des Mines, CH-12-2, Geneva, Switzerland | Overseas visits 80ef1083 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 5 | 2012-01-13-80ef1083-10357-0 |
047a1e1b87d2e6c9553f3f26081368a568ec0cb7 | 3) John Hopkins School of Public Health, John Hopkins University, 615 N. Wolfe Street, Baltimore, MD 21205 | Overseas visits 80ef1083 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 6 | 2012-01-13-80ef1083-10357-0 |
296d9a508c770de955404bf54ef43145ec4c9f2a | 4) John Smith House, Cowley, Oxfordshire OX4 2JY | Overseas visits 80ef1083 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 7 | 2012-01-13-80ef1083-10357-0 |
3cc7854592e9c068b8186d3db2dd79bf75d04d67 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 8 | 2012-01-13-80ef1083-10357-0 |
3da940c81dc810a90c45d8f4afb45b1b4e5c89f7 | 1) Travel and accommodation for me; value £2,440 | Overseas visits 80ef1083 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 9 | 2012-01-13-80ef1083-10357-0 |
85f18f0df283f272c8e69b9b234d9a82cb74dd7a | 2) Travel and accommodation for a member of my staff; value £3,188 | Overseas visits 80ef1083 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 10 | 2012-01-13-80ef1083-10357-0 |
e4a6ede7ddec2e65fd16c985161f7e08c110403f | 3) Field visit in Bangladesh for me and a member of my staff; air and boat travel, food, accommodation and car hire; total value £263 | Overseas visits 80ef1083 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 11 | 2012-01-13-80ef1083-10357-0 |
533fc51a47347c7124b7945ba43d257f33ccf9cc | Destination of visit: Bangladesh | Overseas visits 80ef1083 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 12 | 2012-01-13-80ef1083-10357-0 |
b85383520cd7f2eb143a77aa7926cd1c5498afe8 | Date of visit: 10-15 November 2011 | Overseas visits 80ef1083 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 13 | 2012-01-13-80ef1083-10357-0 |
d4128129a24250fa9536f922b58a9f6648303998 | Purpose of visit: All-Party Parliamentary Group for Global Action Against Childhood Pneumonia visit, to inspect child health and pneumonia facilities in and around Dhaka in response to an invitation from the Bangladesh Ministry of Health. | Overseas visits 80ef1083 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 14 | 2012-01-13-80ef1083-10357-0 |
d9f3d76becb94140bbb2eb8f8bd7cff1eb536782 | (Registered 30 November 2011) | Overseas visits 80ef1083 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 15 | 2012-01-13-80ef1083-10357-0 |
2e09216c2a64bf1c11d885854eeeeeea4be5e9aa | Name of donor: Royal Opera House | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 0 | 2012-01-13-84642823-10357-0 |
4417b0e61249055d2bc4568e24b91fe42115c0e3 | Address of donor : Covent Garden, London WC2E 9DD | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 1 | 2012-01-13-84642823-10357-0 |
cc5b637f84a95e51e70e35f999d366d1be017689 | Amount of donation or nature and value if donation in kind: tickets for ballet; value £2,000 | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 2 | 2012-01-13-84642823-10357-0 |
757ae45cae84063b78b3864e83332f302ea43669 | Date of receipt of donation: 28 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 3 | 2012-01-13-84642823-10357-0 |
a6a27a54a7cc2ba5b2852c3da343f6c19c2aac7a | Date of acceptance of donation: 28 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 4 | 2012-01-13-84642823-10357-0 |
f20973b63f0e246113d0ae1cc0bdee165162826e | Donor status: charity | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 5 | 2012-01-13-84642823-10357-0 |
ac089b83f6abf1eb4099f2e8cdd36ed6ff56519d | (Registered 1 April 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 6 | 2012-01-13-84642823-10357-0 |
355f9e86a9bdfbd275aacd1fe1fc808dcf75b968 | (b) Support in the capacity as an MP: | Sponsorships 8f616a6e | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 0 | 2012-01-13-8f616a6e-10357-0 |
d230d6d23ebd35b3bdc3231f176c1362b3cdec74 | Name of donor: Creative Coalition Campaign Secretariat | Sponsorships 8f616a6e | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 1 | 2012-01-13-8f616a6e-10357-0 |
25f5953570fce52e5f7aa18773d4bca4d920acf5 | Address of donor: 198 High Holborn, London WC1V 7BD | Sponsorships 8f616a6e | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 2 | 2012-01-13-8f616a6e-10357-0 |
279386f01a8c8da42017688f75df10612517b948 | Amount of donation or nature and value if donation in kind: £3,510.18 to support the launch of Labour’s Creative Industries Network | Sponsorships 8f616a6e | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 3 | 2012-01-13-8f616a6e-10357-0 |
1a970d2b1ac26babe58a2285452aa98fba3df31d | Date of receipt: 7 September 2011 | Sponsorships 8f616a6e | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 4 | 2012-01-13-8f616a6e-10357-0 |
dd395c26dbc7aebe848e36bb4485ad1c5dc773ea | Date of acceptance: 7 September 2011 | Sponsorships 8f616a6e | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 5 | 2012-01-13-8f616a6e-10357-0 |
04e814d749967890471289f13eca56171b14933b | Donor status: unincorporated association | Sponsorships 8f616a6e | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 6 | 2012-01-13-8f616a6e-10357-0 |
9e27364d220a101d40b83e4ec241a84f94018076 | (Registered 13 October 2011) | Sponsorships 8f616a6e | 2012-01-13 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 7 | 2012-01-13-8f616a6e-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");