items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
48 rows where record_id = "2013-01-18-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 |
---|---|---|---|---|---|---|---|
9a10e879b1efaf225777bfd91a49b8dfb2c1ac67 | 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 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 0 | 2013-01-18-80ef1083-11455-0 |
93a7e16e32ee7e670e30652742a10b8fb0fef4b0 | Address of donor: c/o Great Britain China Centre, 15 Belgrave Square, London SW1X 8PS | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 1 | 2013-01-18-80ef1083-11455-0 |
f8c47def76a05653cc8b153341baaf977cd91c1e | 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 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 2 | 2013-01-18-80ef1083-11455-0 |
0f04652c68ddbab25058558c10c123ca5cf175fa | Destination of visit: China; Shanghai, Beijing and Chengdu | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 3 | 2013-01-18-80ef1083-11455-0 |
fbd9b9d71838baa4a5d645080e0362ba7619c1f2 | Date of visit: 16-23 December 2011 | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 4 | 2013-01-18-80ef1083-11455-0 |
05c96b6ec47e8cdba862fb3aa5ebbce28c059ce0 | 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 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 5 | 2013-01-18-80ef1083-11455-0 |
c0e49d50e8dbae3eef984a5de58660f98d791012 | (Registered 4 January 2012) | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 6 | 2013-01-18-80ef1083-11455-0 |
9cbd10638d1f99ea13e028e444936033431febe0 | Name of donor: Justice for Colombia | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 7 | 2013-01-18-80ef1083-11455-0 |
5944d94a7b5754117533c835e84eb5052ce77821 | Address of donor: 75 St John’s Street, London EC1M 4NN | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 8 | 2013-01-18-80ef1083-11455-0 |
9425b83bd858e61e19262863ae01e2dc4f435686 | Amount of donation (or estimate of the probable value): £2,200 | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 9 | 2013-01-18-80ef1083-11455-0 |
b1c50be55c1ef084b7640639b3f280eef7ffc78b | Destination of visit: Colombia | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 10 | 2013-01-18-80ef1083-11455-0 |
fd4629ed79c4497be92709f500ee8f1131b6683f | Date of visit: 26 February-3 March 2012 | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 11 | 2013-01-18-80ef1083-11455-0 |
be46fc1d9f0369de8ab61510f3878c7cb0f9ceee | Purpose of visit: visit organized by Parliamentary Friends of Colombia to explore the human rights situation in Colombia. | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 12 | 2013-01-18-80ef1083-11455-0 |
441183d775345c539bd42ba543416bf7b4427900 | (Registered 11 April 2012) | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 13 | 2013-01-18-80ef1083-11455-0 |
893f79f17717fb4d1e0af5045c920f6652e91145 | Name of donor: All-Party Parliamentary Jordan Group and the Jordanian House of Representatives | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 14 | 2013-01-18-80ef1083-11455-0 |
58d03af5b801f53f8105bc32c2c69263e575f802 | Address of donor: Al Umah Street, Amman, Jordan | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 15 | 2013-01-18-80ef1083-11455-0 |
5e96e7c3f13b0d2459b379922aaaa67558dba73d | Amount of donation (or estimate of the probable value): £2,029.45, covering travel costs, accommodation, subsistence and internal tours | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 16 | 2013-01-18-80ef1083-11455-0 |
0de685c8b5cd7310c2761fabf0c7866a210abf84 | Destination of visit: Jordan | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 17 | 2013-01-18-80ef1083-11455-0 |
5213643b9e1ad60e0fa5352a499da69fd3938d39 | Date of visit: 8-14 April 2012 | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 18 | 2013-01-18-80ef1083-11455-0 |
52bd3a0e47399cb94bbb6948240d56cb28a3c62c | Purpose of visit: All-Party Parliamentary Jordan Group delegation | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 19 | 2013-01-18-80ef1083-11455-0 |
b98bd6636ce4323d92dbee761892ac75fb6c270e | (Registered 1 May 2012) | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 20 | 2013-01-18-80ef1083-11455-0 |
ed51ef230f3c7b0af5ece66b734ddc2f2718abcb | Name of donor: Falkland Islands Government | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 21 | 2013-01-18-80ef1083-11455-0 |
e5f03c6de08a1edea4cea1902c616d9a3a395ca1 | Address of donor: The Secretariat, Stanley, Falkland Islands FIQQ 1ZZ | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 22 | 2013-01-18-80ef1083-11455-0 |
e382c4abe626fe0a8e5bb15ef02ab4dca8c0e2bc | Amount of donation (or estimate of the probable value): £2,303 | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 23 | 2013-01-18-80ef1083-11455-0 |
b9c05fa9716d11d3c3bdadbf5b77606b3c421ab4 | Destination of visit: Falkland Islands | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 24 | 2013-01-18-80ef1083-11455-0 |
a442bc70c05d118b94273b858e402d00bb1fb338 | Date of visit: 10-16 June 2012 | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 25 | 2013-01-18-80ef1083-11455-0 |
359be866fd8967ede2038b09cbb8adad852b7c06 | Purpose of visit: attendance at 30th Anniversary of Falkland Islands Liberation | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 26 | 2013-01-18-80ef1083-11455-0 |
32e734abf42d2413921caff8ba0e7ee58c7df821 | (Registered 3 July 2012) | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 27 | 2013-01-18-80ef1083-11455-0 |
891c0289891c50f347761799a3df01bda81d4708 | Name of donor: Oxfam GB | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 28 | 2013-01-18-80ef1083-11455-0 |
50fb2c1e9caff485bca102aab3b573f8be6b96c1 | Address of donor: Oxfam House, John Smith Drive, Cowley, Oxford OX4 2JY | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 29 | 2013-01-18-80ef1083-11455-0 |
4e78cba410ea1206523c927882c81fbaf7967540 | Amount of donation (or estimate of the probable value): flight, hotel, food, airport transport; total £1,304.19 | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 30 | 2013-01-18-80ef1083-11455-0 |
70e01b1f9cdccdb1d72acce70afc9f6d987351da | Destination of visit: New York | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 31 | 2013-01-18-80ef1083-11455-0 |
f615c71a70248af13590a451d1df94718591cc70 | Date of visit: 1-4 July 2012 | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 32 | 2013-01-18-80ef1083-11455-0 |
9ff8a20109cd94e301a2adb409d6904a24905496 | 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 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 33 | 2013-01-18-80ef1083-11455-0 |
d5dbd9e06de836769ecc28eac57187abec1fe169 | (Registered 7 August 2012) | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 34 | 2013-01-18-80ef1083-11455-0 |
9123b9a9ee0a885ba1279be5e72144bade600312 | Name of donor: | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 35 | 2013-01-18-80ef1083-11455-0 |
3eeca391770ca970efc12ed337f3d0f2831ff786 | 1) WSPA (World Society for the Protection of Animals) | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 36 | 2013-01-18-80ef1083-11455-0 |
831c2513aa9c0c43438abeae1cf093f2b50800a3 | 2) Brittany Ferries | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 37 | 2013-01-18-80ef1083-11455-0 |
95e2779b7b2fe8a95aff9a2ef3fedb9f0f879858 | Address of donor: | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 38 | 2013-01-18-80ef1083-11455-0 |
8470cadc0fab1f614ee13b370332084f534e9d14 | 1) 222 Grays Inn Road, London WC1X 8HB | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 39 | 2013-01-18-80ef1083-11455-0 |
8805b2c218ef0660e291c2aa09a756a389402c49 | 2) Plymouth Port, Millbay, Plymouth, Devon PL1 3EW | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 40 | 2013-01-18-80ef1083-11455-0 |
9d0b75baadc1ebb2441fa41c7d17807331fce0a2 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 41 | 2013-01-18-80ef1083-11455-0 |
2fa31a0cbeba964300aa65381346705a357cf821 | 1) Travel and accommodation for two people; cost £650 | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 42 | 2013-01-18-80ef1083-11455-0 |
20712a466a6c97d56eba0257c4b64f8aac639768 | 2) Discount on travel and accommodation for two people; value £250 | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 43 | 2013-01-18-80ef1083-11455-0 |
e613f253e3be6d486502a7fc909b048606e76412 | Destination of visit: Bay of Biscay | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 44 | 2013-01-18-80ef1083-11455-0 |
52b874f21ea1bdd5ec8011068e829f629772d23f | Date of visit: 17-19 July 2012 | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 45 | 2013-01-18-80ef1083-11455-0 |
b042957e428ab67004173ba3dd2d088a38f3d5c6 | 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 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 46 | 2013-01-18-80ef1083-11455-0 |
84a3cf4903f9995c72543a897d159b400c7a6cd7 | (Registered 21 August 2012) | Overseas visits 80ef1083 | 2013-01-18 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 47 | 2013-01-18-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");