items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
41 rows where record_id = "2013-03-11-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 |
---|---|---|---|---|---|---|---|
bf6b1bd0138e9fc801877b8f9361ec5a44af4057 | Name of donor: Justice for Colombia | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 0 | 2013-03-11-80ef1083-11455-0 |
a6039bc33466ad459ac173e0bffbb490932babbd | Address of donor: 75 St John’s Street, London EC1M 4NN | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 1 | 2013-03-11-80ef1083-11455-0 |
23e4454d0fd86853644613eb2feca542b3ced0fd | Amount of donation (or estimate of the probable value): £2,200 | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 2 | 2013-03-11-80ef1083-11455-0 |
ef2d37d7f5622f6c603a192d354f5a246dc0c3ba | Destination of visit: Colombia | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 3 | 2013-03-11-80ef1083-11455-0 |
225f8b382c5b15be4433115e24c8429e46339bf8 | Date of visit: 26 February-3 March 2012 | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 4 | 2013-03-11-80ef1083-11455-0 |
6e6cd02fbdd806e73c1284be1c7e9fede2be3366 | Purpose of visit: visit organized by Parliamentary Friends of Colombia to explore the human rights situation in Colombia. | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 5 | 2013-03-11-80ef1083-11455-0 |
75e755bebf03f414f8f3e88d0410c4584aee90e2 | (Registered 11 April 2012) | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 6 | 2013-03-11-80ef1083-11455-0 |
83ddb5c9791a2718abc5515db292fbc8f60f28d6 | Name of donor: All-Party Parliamentary Jordan Group and the Jordanian House of Representatives | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 7 | 2013-03-11-80ef1083-11455-0 |
42cf8b6720fe5812cc9262e451a267b3a58dcc4a | Address of donor: Al Umah Street, Amman, Jordan | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 8 | 2013-03-11-80ef1083-11455-0 |
88797c0433e9ec52682ac6fece86b7006f97bab5 | Amount of donation (or estimate of the probable value): £2,029.45, covering travel costs, accommodation, subsistence and internal tours | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 9 | 2013-03-11-80ef1083-11455-0 |
ddd3c1e4b15c881a3603cdd4d26eabd8c932145e | Destination of visit: Jordan | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 10 | 2013-03-11-80ef1083-11455-0 |
b416be7fde5c5e2f8c3281e4f2eaf936b345c76f | Date of visit: 8-14 April 2012 | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 11 | 2013-03-11-80ef1083-11455-0 |
990576cadbcba79e392cf5fba6f193e88a1b4c3c | Purpose of visit: All-Party Parliamentary Jordan Group delegation | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 12 | 2013-03-11-80ef1083-11455-0 |
6c6211924bc0b622af8f43d0d60e0eb5e08b33c1 | (Registered 1 May 2012) | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 13 | 2013-03-11-80ef1083-11455-0 |
174440f16a9f459e655e737805de0d5ce9bcec82 | Name of donor: Falkland Islands Government | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 14 | 2013-03-11-80ef1083-11455-0 |
9428532b45fe9b2369db6ec3809319a535b39500 | Address of donor: The Secretariat, Stanley, Falkland Islands FIQQ 1ZZ | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 15 | 2013-03-11-80ef1083-11455-0 |
80963c42542748eca298221afbbd76b135a5e021 | Amount of donation (or estimate of the probable value): £2,303 | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 16 | 2013-03-11-80ef1083-11455-0 |
1371f2b3b935cca2a2e232ed4f3c0b45506cf3e7 | Destination of visit: Falkland Islands | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 17 | 2013-03-11-80ef1083-11455-0 |
cb06cd0ad334ff9b6169a1f243aaf012d3cac14d | Date of visit: 10-16 June 2012 | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 18 | 2013-03-11-80ef1083-11455-0 |
4fd64c4939abae6c0aeb8ac248783f3c8ef22fe7 | Purpose of visit: attendance at 30th Anniversary of Falkland Islands Liberation | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 19 | 2013-03-11-80ef1083-11455-0 |
19e60520ddc95e9a2cf7a51062c538f8e7fa9c88 | (Registered 3 July 2012) | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 20 | 2013-03-11-80ef1083-11455-0 |
4757b9bba9437c42de6b5f1c7687f26e7c3340d6 | Name of donor: Oxfam GB | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 21 | 2013-03-11-80ef1083-11455-0 |
62b880c0801832d25b9dc78a8e0d26810c400f7c | Address of donor: Oxfam House, John Smith Drive, Cowley, Oxford OX4 2JY | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 22 | 2013-03-11-80ef1083-11455-0 |
745ae4a67f0bc429c0b3108981368461ceda5da5 | Amount of donation (or estimate of the probable value): flight, hotel, food, airport transport; total £1,304.19 | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 23 | 2013-03-11-80ef1083-11455-0 |
bef9c13403f1441393d2cc83b76e379fb87b42d8 | Destination of visit: New York | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 24 | 2013-03-11-80ef1083-11455-0 |
820dabd68611d21694707e6f9ed264529235b216 | Date of visit: 1-4 July 2012 | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 25 | 2013-03-11-80ef1083-11455-0 |
901b8f09ae295850a28a0d6a2dd4d9e09ae9534f | 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-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 26 | 2013-03-11-80ef1083-11455-0 |
60ffde8f8aba30086a29170b3bf4094972e9a4ea | (Registered 7 August 2012) | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 27 | 2013-03-11-80ef1083-11455-0 |
ca0827c8f38252f29670344834f4a8e17ab871da | Name of donor: | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 28 | 2013-03-11-80ef1083-11455-0 |
70cb69c2e8c7e09eb9b23485ebc36cd1af057066 | 1) WSPA (World Society for the Protection of Animals) | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 29 | 2013-03-11-80ef1083-11455-0 |
fb83492d22d2973b2942f8d3aa337638b7f81800 | 2) Brittany Ferries | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 30 | 2013-03-11-80ef1083-11455-0 |
866ee4e93f9b1d6b6d6cbee5c540323d1696a197 | Address of donor: | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 31 | 2013-03-11-80ef1083-11455-0 |
413ac16c1b3dfc539da7ded22f7a1c8dfb9d0466 | 1) 222 Grays Inn Road, London WC1X 8HB | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 32 | 2013-03-11-80ef1083-11455-0 |
c436dd289f8249f274279f2f40108b39ace726d8 | 2) Plymouth Port, Millbay, Plymouth, Devon PL1 3EW | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 33 | 2013-03-11-80ef1083-11455-0 |
9b74df70103730207402f0981a5d8fee54267ee3 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 34 | 2013-03-11-80ef1083-11455-0 |
db862f74a6f08552c000666d526e5704b2b564ee | 1) Travel and accommodation for two people; cost £650 | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 35 | 2013-03-11-80ef1083-11455-0 |
01effdc31e42821b94c7e7b9e3496daf35022ae2 | 2) Discount on travel and accommodation for two people; value £250 | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 36 | 2013-03-11-80ef1083-11455-0 |
cc1400c710e6aebe4704ec81d9a639befe7fb90c | Destination of visit: Bay of Biscay | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 37 | 2013-03-11-80ef1083-11455-0 |
502dd8d7309420e52700017be52c96285b53e1cd | Date of visit: 17-19 July 2012 | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 38 | 2013-03-11-80ef1083-11455-0 |
7354ee5ba8f1ebdd2ddf36368935074aac0d8803 | 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-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 39 | 2013-03-11-80ef1083-11455-0 |
cffc86694a7a07886afd4a06c650fddfe1e12643 | (Registered 21 August 2012) | Overseas visits 80ef1083 | 2013-03-11 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 40 | 2013-03-11-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");