items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
48 rows where record_id = "2012-11-19-80ef1083-11455-0" sorted by date
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▼ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
e57eb5b811e3045a46cece5805547050a43e07cf | Name of donor: All Party Parliamentary China Group, sponsored by GKN plc, City of London, London Export Corporation (LEC), John Swire & Sons, GlaxoSmithKline, Astra Zeneca, Arup, University of Cambridge Local Examinations Syndicate, HSBC. | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 0 | 2012-11-19-80ef1083-11455-0 |
39de34bdbb2cfa4e76a88e5a68e840f695f154e4 | Address of donor: c/o Great Britain China Centre, 15 Belgrave Square, London SW1X 8PS | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 1 | 2012-11-19-80ef1083-11455-0 |
06d071d068832c49d9781221b8f03ecad1def5b7 | Amount of donation (or estimate of the probable value): £2,349.98; return flights to China, internal travel in China, accommodation and meals. I also received some meals and hospitality provided locally. | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 2 | 2012-11-19-80ef1083-11455-0 |
1013ebc20bd8766b4d92a8fd05d43d65b4f35501 | Destination of visit: China; Shanghai, Beijing and Chengdu | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 3 | 2012-11-19-80ef1083-11455-0 |
8fcbcc4fd53e638d45142dd9c146b5a474768198 | Date of visit: 16-23 December 2011 | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 4 | 2012-11-19-80ef1083-11455-0 |
cd20e62cb185bf3fe7595285c5d2001ffe9bb2cc | Purpose of visit: to maintain and strengthen relations between Parliament and the National People’s Congress of China; to learn about and support British businesses operating in China; and to deepen the knowledge and understanding of parliamentarians of China. | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 5 | 2012-11-19-80ef1083-11455-0 |
6db82b163af577a66e7f1f252fadf7925e718c35 | (Registered 4 January 2012) | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 6 | 2012-11-19-80ef1083-11455-0 |
5c463cf04c74a947d6ac700562aa06f161a2b85b | Name of donor: Justice for Colombia | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 7 | 2012-11-19-80ef1083-11455-0 |
19cfcfec26a4c9e4959d0364f490b2cd72073230 | Address of donor: 75 St John’s Street, London EC1M 4NN | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 8 | 2012-11-19-80ef1083-11455-0 |
2b2c73bc7298c09cab5dfb846a0b7f3cbbcf17f3 | Amount of donation (or estimate of the probable value): £2,200 | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 9 | 2012-11-19-80ef1083-11455-0 |
06becc734a983ecc53f91411147a854be1807d63 | Destination of visit: Colombia | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 10 | 2012-11-19-80ef1083-11455-0 |
6a13be654ea3acc1d681d36f333f223086aec7e3 | Date of visit: 26 February-3 March 2012 | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 11 | 2012-11-19-80ef1083-11455-0 |
40c0eb69727bd858c20a3d68c51ff0ba01b86c6e | Purpose of visit: visit organized by Parliamentary Friends of Colombia to explore the human rights situation in Colombia. | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 12 | 2012-11-19-80ef1083-11455-0 |
6407df00607b86bb87f14a549a93ab321cbe9673 | (Registered 11 April 2012) | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 13 | 2012-11-19-80ef1083-11455-0 |
d72832e79688d4d1c5af37c8ea27c2a9c47af8df | Name of donor: All-Party Parliamentary Jordan Group and the Jordanian House of Representatives | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 14 | 2012-11-19-80ef1083-11455-0 |
1d7f5b6a577cfdbff02cff98fb7e44fb3b07cdb9 | Address of donor: Al Umah Street, Amman, Jordan | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 15 | 2012-11-19-80ef1083-11455-0 |
1452c9951c97dd1c4782f2bac82afde33234a6e1 | Amount of donation (or estimate of the probable value): £2,029.45, covering travel costs, accommodation, subsistence and internal tours | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 16 | 2012-11-19-80ef1083-11455-0 |
2c0ccfe04aaca5d256a6b3d0b4520784344d188a | Destination of visit: Jordan | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 17 | 2012-11-19-80ef1083-11455-0 |
e7f8dbfe7db305edf54802457b91e477e5c46536 | Date of visit: 8-14 April 2012 | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 18 | 2012-11-19-80ef1083-11455-0 |
0485099c9f99179471502700de562bfb4d9f90fa | Purpose of visit: All-Party Parliamentary Jordan Group delegation | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 19 | 2012-11-19-80ef1083-11455-0 |
e36af4e3bbd428d0ab38596c953c44e4f3c68435 | (Registered 1 May 2012) | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 20 | 2012-11-19-80ef1083-11455-0 |
38036b44ed751f598335d791a5de42394aac832e | Name of donor: Falkland Islands Government | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 21 | 2012-11-19-80ef1083-11455-0 |
5184e0bee34bb371b57a1221a630a6c38189bb8d | Address of donor: The Secretariat, Stanley, Falkland Islands FIQQ 1ZZ | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 22 | 2012-11-19-80ef1083-11455-0 |
fb0e686c04d6e83cf39a9e32d01ba234412779fa | Amount of donation (or estimate of the probable value): £2,303 | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 23 | 2012-11-19-80ef1083-11455-0 |
d639d38959453c548df0c25d8b564078bcc7e865 | Destination of visit: Falkland Islands | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 24 | 2012-11-19-80ef1083-11455-0 |
c9611ef308183f7e9504067d8c77635189e9ff7f | Date of visit: 10-16 June 2012 | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 25 | 2012-11-19-80ef1083-11455-0 |
462a8820bb6f853a8243753cb799fed5e8109872 | Purpose of visit: attendance at 30th Anniversary of Falkland Islands Liberation | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 26 | 2012-11-19-80ef1083-11455-0 |
6645b1c22af0e2d66631ae6b5b912416d8296afe | (Registered 3 July 2012) | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 27 | 2012-11-19-80ef1083-11455-0 |
1d6ed11a9dc36c740c7958f3ec843b0906466596 | Name of donor: Oxfam GB | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 28 | 2012-11-19-80ef1083-11455-0 |
4623fd69ea22bbdea4aafeaa8f44c46555cf6cd8 | Address of donor: Oxfam House, John Smith Drive, Cowley, Oxford OX4 2JY | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 29 | 2012-11-19-80ef1083-11455-0 |
49689f2ec5277a21fbaa7e97d195ca4946bcebf6 | Amount of donation (or estimate of the probable value): flight, hotel, food, airport transport; total £1,304.19 | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 30 | 2012-11-19-80ef1083-11455-0 |
abb44df2d89a4c8c9de11e2bb3c8d6853efbd8f6 | Destination of visit: New York | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 31 | 2012-11-19-80ef1083-11455-0 |
0a3ed313b36c655cf75c0660523a3c23a87fc416 | Date of visit: 1-4 July 2012 | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 32 | 2012-11-19-80ef1083-11455-0 |
8fa661ba13bdac7109b6b8e6f4ce68b7e812e8a4 | Purpose of visit: to undertake lobby and media work at UN, as part of an Oxfam delegation, to support an Arms Trade Treaty. | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 33 | 2012-11-19-80ef1083-11455-0 |
50fb2e83909a8a0af2c1e3bc970ad8e0600da02b | (Registered 7 August 2012) | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 34 | 2012-11-19-80ef1083-11455-0 |
4145aec99d0bbade7ccdad3f929a6cad865491ac | Name of donor: | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 35 | 2012-11-19-80ef1083-11455-0 |
90ecf6bf6a6b182b57a995720e307058e399ea6e | 1) WSPA (World Society for the Protection of Animals) | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 36 | 2012-11-19-80ef1083-11455-0 |
9828d7df4055171f6e038b4580d695aa330ee1b1 | 2) Brittany Ferries | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 37 | 2012-11-19-80ef1083-11455-0 |
c589ca1255df648f8056c4af54e12e83fd6e55dc | Address of donor: | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 38 | 2012-11-19-80ef1083-11455-0 |
88a2db6b37102d8c20bcefc699b9ef5351d9ba9c | 1) 222 Grays Inn Road, London WC1X 8HB | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 39 | 2012-11-19-80ef1083-11455-0 |
d943931849c50564ef51bc15d6668f8ec0426ee2 | 2) Plymouth Port, Millbay, Plymouth, Devon PL1 3EW | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 40 | 2012-11-19-80ef1083-11455-0 |
66dc1bd5c0e8b2a1451097552643550815072535 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 41 | 2012-11-19-80ef1083-11455-0 |
1ad29b7775ac45d505bf0bfcc967c25895168343 | 1) Travel and accommodation for two people; cost £650 | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 42 | 2012-11-19-80ef1083-11455-0 |
5a1e3adb510381807cd95a08f419b167267e76b9 | 2) Discount on travel and accommodation for two people; value £250 | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 43 | 2012-11-19-80ef1083-11455-0 |
c0aa1d2d67431d1c278db932b528aa685970a570 | Destination of visit: Bay of Biscay | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 44 | 2012-11-19-80ef1083-11455-0 |
90ab48714076493de8aff6937846083e159fafb3 | Date of visit: 17-19 July 2012 | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 45 | 2012-11-19-80ef1083-11455-0 |
13256924ad528b8813af48ea76c986a19267f1df | Purpose of visit: whale watching visit in Bay of Biscay organized by ORCA and WSPA, highlighting challenges of marine and cetacean conservation | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 46 | 2012-11-19-80ef1083-11455-0 |
3bd75616535cce26dc6ecdc1128c336979e18ad0 | (Registered 21 August 2012) | Overseas visits 80ef1083 | 2012-11-19 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 47 | 2012-11-19-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");