items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
48 rows where record_id = "2012-09-03-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 |
---|---|---|---|---|---|---|---|
101e17fa7b40dbf03c339b90087cbddc7aa0ab2e | 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-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 0 | 2012-09-03-80ef1083-11455-0 |
2f7bdff14a53f628e6e1746569933352f3c9ff2e | Address of donor: c/o Great Britain China Centre, 15 Belgrave Square, London SW1X 8PS | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 1 | 2012-09-03-80ef1083-11455-0 |
45b4444a2a55bfb8f055fe6dba1387f1d749cf56 | 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-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 2 | 2012-09-03-80ef1083-11455-0 |
ed66be2755e9a067bdde542d04084ea6788de3fd | Destination of visit: China; Shanghai, Beijing and Chengdu | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 3 | 2012-09-03-80ef1083-11455-0 |
20d58adedadefcee20ba6a267ae42d9a693752be | Date of visit: 16-23 December 2011 | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 4 | 2012-09-03-80ef1083-11455-0 |
ace7d6e70c216cfeb92c19d2f235edc44957d79e | 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-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 5 | 2012-09-03-80ef1083-11455-0 |
adce67784707137f1c562d3af51a56e27becaab4 | (Registered 4 January 2012) | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 6 | 2012-09-03-80ef1083-11455-0 |
869f5633e187d4735ef79d901745bd00e1d87043 | Name of donor: Justice for Colombia | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 7 | 2012-09-03-80ef1083-11455-0 |
b579ce7c571d1fd57fb31d2051adc51d302bc56d | Address of donor: 75 St John’s Street, London EC1M 4NN | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 8 | 2012-09-03-80ef1083-11455-0 |
ba8175ad5aa22b5594d41178649f9f6bd1947611 | Amount of donation (or estimate of the probable value): £2,200 | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 9 | 2012-09-03-80ef1083-11455-0 |
2f9c8402a9ba3e95e59666d3b3aaa50647b61537 | Destination of visit: Colombia | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 10 | 2012-09-03-80ef1083-11455-0 |
e03f0fba0867507b9dcd8b9e93106092e148d303 | Date of visit: 26 February-3 March 2012 | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 11 | 2012-09-03-80ef1083-11455-0 |
881deccc5ca6b05b5371996a23530a80467742bd | Purpose of visit: visit organized by Parliamentary Friends of Colombia to explore the human rights situation in Colombia. | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 12 | 2012-09-03-80ef1083-11455-0 |
cb8386a0617a4b5f06c9c3e5243084b45b5f5e0f | (Registered 11 April 2012) | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 13 | 2012-09-03-80ef1083-11455-0 |
ed001062e63aa831f9bd108b6fe5a1638697758d | Name of donor: All-Party Parliamentary Jordan Group and the Jordanian House of Representatives | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 14 | 2012-09-03-80ef1083-11455-0 |
2240938f8baf4423677920362e87ce35e82311b9 | Address of donor: Al Umah Street, Amman, Jordan | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 15 | 2012-09-03-80ef1083-11455-0 |
9dc937313f632a47010e64827a76ccff33837c83 | Amount of donation (or estimate of the probable value): £2,029.45, covering travel costs, accommodation, subsistence and internal tours | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 16 | 2012-09-03-80ef1083-11455-0 |
d686c86ee5d7128d82866cfbaad9cdc4ea376687 | Destination of visit: Jordan | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 17 | 2012-09-03-80ef1083-11455-0 |
f1f078394078f49ab3667abd3c0db247ab9b0c03 | Date of visit: 8-14 April 2012 | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 18 | 2012-09-03-80ef1083-11455-0 |
5769aecdd984459ad4346e59fa1b5d0b6f1636f4 | Purpose of visit: All-Party Parliamentary Jordan Group delegation | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 19 | 2012-09-03-80ef1083-11455-0 |
d8a02a63cecdba2c5d05ce7cd7e14ba2c89107a4 | (Registered 1 May 2012) | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 20 | 2012-09-03-80ef1083-11455-0 |
a143e27e7346472bd0728f7aebc47248e5bbaa68 | Name of donor: Falkland Islands Government | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 21 | 2012-09-03-80ef1083-11455-0 |
4ccf53b7a3ab99f52399c7796c386edd326972fc | Address of donor: The Secretariat, Stanley, Falkland Islands FIQQ 1ZZ | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 22 | 2012-09-03-80ef1083-11455-0 |
43ba5c67e0cdc20d548112174ac2dc02d81a4927 | Amount of donation (or estimate of the probable value): £2,303 | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 23 | 2012-09-03-80ef1083-11455-0 |
6b6b2d717ebc2347777277d58bb25cec695d8d6b | Destination of visit: Falkland Islands | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 24 | 2012-09-03-80ef1083-11455-0 |
6003bb4a35213270a60bd2e749efafb8cbcc1e96 | Date of visit: 10-16 June 2012 | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 25 | 2012-09-03-80ef1083-11455-0 |
1ac43c7256089ab70a7f94ae8f1b880ab99b877b | Purpose of visit: attendance at 30th Anniversary of Falkland Islands Liberation | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 26 | 2012-09-03-80ef1083-11455-0 |
ac66f64078a88d95d239105975cb6a2d43bab3a3 | (Registered 3 July 2012) | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 27 | 2012-09-03-80ef1083-11455-0 |
01f04b320a1c51bd8bed533dd74bd1e612128e4e | Name of donor: Oxfam GB | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 28 | 2012-09-03-80ef1083-11455-0 |
f03befdb94eea6831d12835fec5b462856d32a62 | Address of donor: Oxfam House, John Smith Drive, Cowley, Oxford OX4 2JY | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 29 | 2012-09-03-80ef1083-11455-0 |
c1caa29ee575b8ea0a887b88ecce20703922b680 | Amount of donation (or estimate of the probable value): flight, hotel, food, airport transport; total £1,304.19 | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 30 | 2012-09-03-80ef1083-11455-0 |
39b6a91bbe10aa4739de02707aecc6fbeb1ec885 | Destination of visit: New York | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 31 | 2012-09-03-80ef1083-11455-0 |
7e9a7b0c5745892925f44b136e7786f1d1748d04 | Date of visit: 1-4 July 2012 | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 32 | 2012-09-03-80ef1083-11455-0 |
41803c01d3a7ed9c4977d90730367ce5e79ba7d3 | 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-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 33 | 2012-09-03-80ef1083-11455-0 |
6fcfe00205af442e7f2871c5443f89f672834c05 | (Registered 7 August 2012) | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 34 | 2012-09-03-80ef1083-11455-0 |
df552c8c6b6143de6eed0662cd9d8b102766c131 | Name of donor: | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 35 | 2012-09-03-80ef1083-11455-0 |
4bf236173f29c2741a65cd5bd1aee285f34b38cf | 1) WSPA (World Society for the Protection of Animals) | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 36 | 2012-09-03-80ef1083-11455-0 |
1dd57379a1d5293d574e515c1ed043733903feef | 2) Brittany Ferries | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 37 | 2012-09-03-80ef1083-11455-0 |
1fb32991e038daa47dc3e73fade4e575b8a8c553 | Address of donor: | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 38 | 2012-09-03-80ef1083-11455-0 |
188c43baa4f79e44fb13da2c698b4ddbc5fea1f1 | 1) 222 Grays Inn Road, London WC1X 8HB | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 39 | 2012-09-03-80ef1083-11455-0 |
ab1a44e83e8a13d96a7af2b2129fcc7e76b4f22a | 2) Plymouth Port, Millbay, Plymouth, Devon PL1 3EW | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 40 | 2012-09-03-80ef1083-11455-0 |
92957164da56d90dd527fa1955e3afb3f2b4190a | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 41 | 2012-09-03-80ef1083-11455-0 |
4e4f0bfa02687f259e2ec15767daf93a821d9337 | 1) Travel and accommodation for two people; cost £650 | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 42 | 2012-09-03-80ef1083-11455-0 |
fd829e14828b123a61eaea8c24a6db1940feb2e7 | 2) Discount on travel and accommodation for two people; value £250 | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 43 | 2012-09-03-80ef1083-11455-0 |
fdfe6156113bc488a50c6361a362e2f708b09c24 | Destination of visit: Bay of Biscay | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 44 | 2012-09-03-80ef1083-11455-0 |
5c93ad9808b9351f862d01ee0a0355f79b550fe5 | Date of visit: 17-19 July 2012 | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 45 | 2012-09-03-80ef1083-11455-0 |
86e677295b45c6625bc65b73a0777a4c3e01454a | 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-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 46 | 2012-09-03-80ef1083-11455-0 |
7633092eaac24168ddc0db86b56e5fe35e288998 | (Registered 21 August 2012) | Overseas visits 80ef1083 | 2012-09-03 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 47 | 2012-09-03-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");