items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
27 rows where record_id = "2013-06-24-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 |
---|---|---|---|---|---|---|---|
084342e15973a9ec1a8cab31a355954123e4c219 | Name of donor: Falkland Islands Government | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 0 | 2013-06-24-80ef1083-11455-0 |
81c57978d00b1ff157acd7c0a82699eafc72d998 | Address of donor: The Secretariat, Stanley, Falkland Islands FIQQ 1ZZ | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 1 | 2013-06-24-80ef1083-11455-0 |
28b6467402bc91e23ee5f280275ad91cdee28af5 | Amount of donation (or estimate of the probable value): £2,303 | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 2 | 2013-06-24-80ef1083-11455-0 |
5011f6e91780eeeae796bf478c697d424a454634 | Destination of visit: Falkland Islands | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 3 | 2013-06-24-80ef1083-11455-0 |
eb877a59c4132f3637f3a0a7ebf67a67b8a4f79b | Date of visit: 10-16 June 2012 | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 4 | 2013-06-24-80ef1083-11455-0 |
5ed4f183b8f40e9098fa1da6560f074f392a3c96 | Purpose of visit: attendance at 30th Anniversary of Falkland Islands Liberation | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 5 | 2013-06-24-80ef1083-11455-0 |
6fefd3d2286d6a1faa6759c8296a73eb1f09b5e5 | (Registered 3 July 2012) | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 6 | 2013-06-24-80ef1083-11455-0 |
4ffe60de189ec418ea15b144c20f760eb88a7c1a | Name of donor: Oxfam GB | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 7 | 2013-06-24-80ef1083-11455-0 |
8ef2c95268a18a4eeac26796f7014831f9118997 | Address of donor: Oxfam House, John Smith Drive, Cowley, Oxford OX4 2JY | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 8 | 2013-06-24-80ef1083-11455-0 |
79d9249440d010b11a6ddc2af4bc69fe4f5e0c76 | Amount of donation (or estimate of the probable value): flight, hotel, food, airport transport; total £1,304.19 | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 9 | 2013-06-24-80ef1083-11455-0 |
8782b94db8a72a5c94bd39c664182ccb73118433 | Destination of visit: New York | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 10 | 2013-06-24-80ef1083-11455-0 |
660fe9a707ea4e487c6b6242bd1ebfa119ceb73d | Date of visit: 1-4 July 2012 | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 11 | 2013-06-24-80ef1083-11455-0 |
288d9f349025f1a87f45058ecdb0860345da1a8f | 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-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 12 | 2013-06-24-80ef1083-11455-0 |
54227a246942f846fe9718ff4599d12a1445b4ae | (Registered 7 August 2012) | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 13 | 2013-06-24-80ef1083-11455-0 |
f08b8e714a3636f10fc3433dc9606e49cc82359b | Name of donor: | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 14 | 2013-06-24-80ef1083-11455-0 |
45f04d5eb536cfe1d5f84922d68e2d7d4ac7f030 | 1) WSPA (World Society for the Protection of Animals) | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 15 | 2013-06-24-80ef1083-11455-0 |
63a35a30e584631b395547c561dd37beb39eb68d | 2) Brittany Ferries | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 16 | 2013-06-24-80ef1083-11455-0 |
a8581eb93e89c12b6b78ccbddb810d74c0380443 | Address of donor: | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 17 | 2013-06-24-80ef1083-11455-0 |
12ebec98bd5d66c7616d8d2fc43118322451112a | 1) 222 Grays Inn Road, London WC1X 8HB | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 18 | 2013-06-24-80ef1083-11455-0 |
7840a721305d6571b67abf27e1c06fd521ddec25 | 2) Plymouth Port, Millbay, Plymouth, Devon PL1 3EW | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 19 | 2013-06-24-80ef1083-11455-0 |
eaf95c2e52a0be55575519cc6651d96218e3f891 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 20 | 2013-06-24-80ef1083-11455-0 |
6ec9af3c891968db02021a39a3e1d06ce15a7cd2 | 1) Travel and accommodation for two people; cost £650 | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 21 | 2013-06-24-80ef1083-11455-0 |
c0ff6bcb9afe4cd379f52515aa72fe46e7c8c703 | 2) Discount on travel and accommodation for two people; value £250 | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 22 | 2013-06-24-80ef1083-11455-0 |
8ed6e5c2a1c07d748071b89aa99ff312bece66c4 | Destination of visit: Bay of Biscay | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 23 | 2013-06-24-80ef1083-11455-0 |
95e038ae5555f1d1e46353554ab734afe8bbe465 | Date of visit: 17-19 July 2012 | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 24 | 2013-06-24-80ef1083-11455-0 |
c124f6ec4114c33ca7202534546b17a7a33bee61 | 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-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 25 | 2013-06-24-80ef1083-11455-0 |
496fd445f0bc0da916e00736e65976f9810b70d5 | (Registered 21 August 2012) | Overseas visits 80ef1083 | 2013-06-24 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 26 | 2013-06-24-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");