items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
27 rows where record_id = "2014-10-13-80ef1083-11455-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
4eed2866701c79b4b03d13e2028668c85b6383ad | Name of donor: RESULTS UK | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 0 | 2014-10-13-80ef1083-11455-0 |
ae393ab6e47242cfe23fca13499e6a35b958ffb1 | Address of donor: Second Floor, 31-33 Bondway, London SW8 1SJ | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 1 | 2014-10-13-80ef1083-11455-0 |
78c30b411b75210e687c6a9678bd46c4f76e60f9 | Amount of donation (or estimate of the probable value): flights, £658; 4 nights’ accommodation, £440; in country transport, £30; meals, £95; total cost £1,223 | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 2 | 2014-10-13-80ef1083-11455-0 |
c0a88382357efc9c12e70f8ceddecb919acb9d5e | Destination of visit: Malawi | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 3 | 2014-10-13-80ef1083-11455-0 |
01a37a2c5106a6b023b8c7323e37abab111c3cd0 | Date of visit: 18-22 August 2013 | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 4 | 2014-10-13-80ef1083-11455-0 |
f890b97841488d8fe13e0c573c6d5d5412560791 | Purpose of visit: to examine key global health issues | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 5 | 2014-10-13-80ef1083-11455-0 |
c361cf887908eed39b748369052c6c51817ca541 | (Registered 23 October 2013) | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 6 | 2014-10-13-80ef1083-11455-0 |
679846a0e9b7e8cbb02eff617f0273dbafd780e4 | Name of donor: Government of Socialist Republic of Vietnam, with assistance from the Friends of Vietnam, an informal group of British and Vietnamese companies. Airfares paid by Vietnam airlines. | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 7 | 2014-10-13-80ef1083-11455-0 |
8c5f2afd9c7fe392156861e36738cd2cbdfc6cbd | Address of donor: 1 Ton That Dam, Hanoi, Vietnam | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 8 | 2014-10-13-80ef1083-11455-0 |
357077dd7a7f719ce7551930efc8d4275127e9f1 | Amount of donation (or estimate of the probable value): air fares, accommodation and other costs with a total value of approx £4,500. Destination of visit: Vietnam | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 9 | 2014-10-13-80ef1083-11455-0 |
cabfc644527a94919aed3033dd1683ca34d027a3 | Date of visit: 2-8 November 2013 | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 10 | 2014-10-13-80ef1083-11455-0 |
c0e9b378e57facf0c892cb4da6eb78837bc4bccf | Purpose of visit: Friends of Vietnam study mission | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 11 | 2014-10-13-80ef1083-11455-0 |
2292493f187973b4fb447f78cd96878c58aa0ab9 | (Registered 19 November 2013) | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 12 | 2014-10-13-80ef1083-11455-0 |
ae4fb3130bb83ce5a995f14535b5bd56cb568e1c | Name of donor: The Taipei Representative Office in the UK (TRO) | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 13 | 2014-10-13-80ef1083-11455-0 |
2a36120d2a3062c0a0a15ff522b48f3c30f18721 | Address of donor: 50 Grosvenor Gardens, London SW1W 0EB | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 14 | 2014-10-13-80ef1083-11455-0 |
f545803c60096edc46abe6d5308d8aaba350b71d | Amount of donation (or estimate of the probable value): the approximate amount includes accommodation £600, food £300 and return flights £2,400; total £3,300 | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 15 | 2014-10-13-80ef1083-11455-0 |
f70019776a56ebe71ddbea8d21b5a2ae340266c4 | Destination of visit: Taiwan | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 16 | 2014-10-13-80ef1083-11455-0 |
32d84923deb3bfc1a156e50b2978e28e101d178c | Date of visit: 26 July-2 August 2014 | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 17 | 2014-10-13-80ef1083-11455-0 |
13540315d13f60b1e51d7a4bd959bac8cfaffd8f | Purpose of visit: As part of the British-Taiwanese APPG, to promote the understanding of Taiwan and strengthen UK-Taiwan relations. | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 18 | 2014-10-13-80ef1083-11455-0 |
d22121cc29b2b0d62fb528b0e29061f7a3a733da | (Registered 11 August 2014) | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 19 | 2014-10-13-80ef1083-11455-0 |
96a9931a2ad01f171cb68cc7fc5869233aaf7847 | Name of donor: Christian Aid | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 20 | 2014-10-13-80ef1083-11455-0 |
d9a3650b3c4a72fe98b7c23924fb51d4b8c40759 | Address of donor: Christian Aid, 35 Lower Marsh, London SE1 7RL | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 21 | 2014-10-13-80ef1083-11455-0 |
b883bec731b94ab29be57be48ef7f2e8fa30e57f | Amount of donation (or estimate of probable value) : travel, accommodation, meals etc with a total value of £1,011.18 | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 22 | 2014-10-13-80ef1083-11455-0 |
d0dee44aca55869c50f4e581a135875fa5dd0cbd | Destination of visit: El Salvador | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 23 | 2014-10-13-80ef1083-11455-0 |
eb62f514f6c72cc60ef53f5a2a151f9f245927bf | Date of visit: 6-11 September 2014 | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 24 | 2014-10-13-80ef1083-11455-0 |
949022270fab97c17b2505d9bf8b296b6f853c6a | Purpose of visit: To visit communities in El Salvador directly affected by climate change, to meet Parliamentarians, officials and a Government Minister working on the issue, and to meet other Christian Aid partner organisations. | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 25 | 2014-10-13-80ef1083-11455-0 |
c5c3126f8bfe51213d65936cd74390b2c7809f22 | (Registered 17 September 2014) | Overseas visits 80ef1083 | 2014-10-13 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 26 | 2014-10-13-80ef1083-11455-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");