items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
48 rows where record_id = "2012-10-01-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 |
---|---|---|---|---|---|---|---|
aa71908acc053e5b3f4eeb95fa6b209ddd1a4103 | 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-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 0 | 2012-10-01-80ef1083-11455-0 |
6d01e64c77bb1022c297665d671a8f079d74f16d | Address of donor: c/o Great Britain China Centre, 15 Belgrave Square, London SW1X 8PS | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 1 | 2012-10-01-80ef1083-11455-0 |
0f2292e08197660c5637aa7cad827218ccb6a4e1 | 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-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 2 | 2012-10-01-80ef1083-11455-0 |
acdc02fef305620ac2b4814fa246a9ba063d49eb | Destination of visit: China; Shanghai, Beijing and Chengdu | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 3 | 2012-10-01-80ef1083-11455-0 |
b817d0af2bbecc4a5ebeb80a21ef6d434310f757 | Date of visit: 16-23 December 2011 | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 4 | 2012-10-01-80ef1083-11455-0 |
ad65e642cc23866ab712099641471c90f202497f | 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-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 5 | 2012-10-01-80ef1083-11455-0 |
908e1a5946fd1bec55a47a693b08ab8bcfca3525 | (Registered 4 January 2012) | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 6 | 2012-10-01-80ef1083-11455-0 |
8b2383ba35fabb280dd5b2996aea8b21ca81b43c | Name of donor: Justice for Colombia | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 7 | 2012-10-01-80ef1083-11455-0 |
8a685e0a014838f8dddf7390505ef90c466b2938 | Address of donor: 75 St John’s Street, London EC1M 4NN | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 8 | 2012-10-01-80ef1083-11455-0 |
ac22d2deee8dbc7cc88b1a21452beabde19b7ad2 | Amount of donation (or estimate of the probable value): £2,200 | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 9 | 2012-10-01-80ef1083-11455-0 |
7ea15e54a5c18f86e27910370d3a2626940bc629 | Destination of visit: Colombia | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 10 | 2012-10-01-80ef1083-11455-0 |
4f513dfb8b971fe4848294c7fe00f325a759c1d4 | Date of visit: 26 February-3 March 2012 | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 11 | 2012-10-01-80ef1083-11455-0 |
89654931cd94bce178113790f886bb2699e3c6f4 | Purpose of visit: visit organized by Parliamentary Friends of Colombia to explore the human rights situation in Colombia. | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 12 | 2012-10-01-80ef1083-11455-0 |
92abaed70a46462abdda01de09a3f5d009700f4b | (Registered 11 April 2012) | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 13 | 2012-10-01-80ef1083-11455-0 |
5ceeb435b9edf0e7f36e636311a60d43388ef479 | Name of donor: All-Party Parliamentary Jordan Group and the Jordanian House of Representatives | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 14 | 2012-10-01-80ef1083-11455-0 |
ecb112aab6f716a3a5489b5c683595f49683aeb2 | Address of donor: Al Umah Street, Amman, Jordan | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 15 | 2012-10-01-80ef1083-11455-0 |
fdece51740d0b8c6717cf4ee53f9d294f67aceff | Amount of donation (or estimate of the probable value): £2,029.45, covering travel costs, accommodation, subsistence and internal tours | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 16 | 2012-10-01-80ef1083-11455-0 |
83f205866573dec84a25deee17576f8b23424e27 | Destination of visit: Jordan | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 17 | 2012-10-01-80ef1083-11455-0 |
8856309dbddb210a799ca686eff7202c558ead3e | Date of visit: 8-14 April 2012 | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 18 | 2012-10-01-80ef1083-11455-0 |
3308fa4acede3b19d9cfc44b34b5b81b11c7ae3a | Purpose of visit: All-Party Parliamentary Jordan Group delegation | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 19 | 2012-10-01-80ef1083-11455-0 |
5fc9f01556266afa101a6b4d5b5f701a5797dd8a | (Registered 1 May 2012) | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 20 | 2012-10-01-80ef1083-11455-0 |
9b46081644f34099be7eba6e41b2c6f721ec4c94 | Name of donor: Falkland Islands Government | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 21 | 2012-10-01-80ef1083-11455-0 |
6cd7b3ab6ab252fefff49ffa3aaabc6aebd5bac0 | Address of donor: The Secretariat, Stanley, Falkland Islands FIQQ 1ZZ | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 22 | 2012-10-01-80ef1083-11455-0 |
c31896aebf268b78f33e062709cc5a837def3281 | Amount of donation (or estimate of the probable value): £2,303 | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 23 | 2012-10-01-80ef1083-11455-0 |
5461f33e7d618957ae0eccbbc1508b059c54a69e | Destination of visit: Falkland Islands | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 24 | 2012-10-01-80ef1083-11455-0 |
50522ca14e6491b6acbb93d8062231bb51be325f | Date of visit: 10-16 June 2012 | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 25 | 2012-10-01-80ef1083-11455-0 |
3b054e262b3c0838625cb9e61bed87d39c818a9a | Purpose of visit: attendance at 30th Anniversary of Falkland Islands Liberation | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 26 | 2012-10-01-80ef1083-11455-0 |
42e8c581c792b273ca91615582265782c3c7985a | (Registered 3 July 2012) | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 27 | 2012-10-01-80ef1083-11455-0 |
d50553a0a1cbe74aa5c5cc558e2e54db2b32245c | Name of donor: Oxfam GB | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 28 | 2012-10-01-80ef1083-11455-0 |
17d3e4dfa8e2960fea3cc26c9324f0670230e5b9 | Address of donor: Oxfam House, John Smith Drive, Cowley, Oxford OX4 2JY | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 29 | 2012-10-01-80ef1083-11455-0 |
02bd0e784f50f8d412e16a63b9552604b9c3c061 | Amount of donation (or estimate of the probable value): flight, hotel, food, airport transport; total £1,304.19 | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 30 | 2012-10-01-80ef1083-11455-0 |
8220ec4200d24857a1c991173a2c00319350e018 | Destination of visit: New York | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 31 | 2012-10-01-80ef1083-11455-0 |
a803c627ab29862133a1775e96e4f8093980a305 | Date of visit: 1-4 July 2012 | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 32 | 2012-10-01-80ef1083-11455-0 |
6b16a04aa8c35aac988e1aa732cfded3edac329f | 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-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 33 | 2012-10-01-80ef1083-11455-0 |
d39a3695736089f6b53fd7c158c2e9b97106421b | (Registered 7 August 2012) | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 34 | 2012-10-01-80ef1083-11455-0 |
f019dc1f8764829b57316b72d47009ca4c8df254 | Name of donor: | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 35 | 2012-10-01-80ef1083-11455-0 |
7941e7ae91dd383e3053e88fed25cdbefaad4b7a | 1) WSPA (World Society for the Protection of Animals) | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 36 | 2012-10-01-80ef1083-11455-0 |
7a844d79ecb82e35e56178a0ea9edb6b89d8efa2 | 2) Brittany Ferries | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 37 | 2012-10-01-80ef1083-11455-0 |
d03dc6c28601fed12da6f0b5fa7882ad8b1a1b4d | Address of donor: | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 38 | 2012-10-01-80ef1083-11455-0 |
fcb534ac954db40b0cbfa7d51d78958794dca468 | 1) 222 Grays Inn Road, London WC1X 8HB | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 39 | 2012-10-01-80ef1083-11455-0 |
999d2e71d117974cf94630e4e910d470d071a296 | 2) Plymouth Port, Millbay, Plymouth, Devon PL1 3EW | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 40 | 2012-10-01-80ef1083-11455-0 |
ebccb493cb10b7834f06676902f5efe81ef3cb47 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 41 | 2012-10-01-80ef1083-11455-0 |
147355f8e2e6f0b24deffa74e55986a8acdc8068 | 1) Travel and accommodation for two people; cost £650 | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 42 | 2012-10-01-80ef1083-11455-0 |
ce62c91f8c253658e5bf94cae2420c79cb4dcb03 | 2) Discount on travel and accommodation for two people; value £250 | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 43 | 2012-10-01-80ef1083-11455-0 |
4b93b486ee728c5201d65dfa83882670cb32d27d | Destination of visit: Bay of Biscay | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 44 | 2012-10-01-80ef1083-11455-0 |
5b170ca8433f79720ff3fc0f2a77c12e248bde07 | Date of visit: 17-19 July 2012 | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 45 | 2012-10-01-80ef1083-11455-0 |
e54d5311c2a81fc2c2df268eb64158a1862a79a0 | 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-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 46 | 2012-10-01-80ef1083-11455-0 |
c656c28096ecab2fef60d2e481cfd1c1bc1f4ca6 | (Registered 21 August 2012) | Overseas visits 80ef1083 | 2012-10-01 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 47 | 2012-10-01-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");