items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
27 rows where record_id = "2013-07-08-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 |
---|---|---|---|---|---|---|---|
382761eeefd385d30c5f9bc3b1da5030f64da6a3 | Name of donor: Falkland Islands Government | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 0 | 2013-07-08-80ef1083-11455-0 |
57f05641c410f2e08753029f904b4eeb16330e97 | Address of donor: The Secretariat, Stanley, Falkland Islands FIQQ 1ZZ | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 1 | 2013-07-08-80ef1083-11455-0 |
3d371ecfe0f9d60cbdd907eaebc211fc7b15a73a | Amount of donation (or estimate of the probable value): £2,303 | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 2 | 2013-07-08-80ef1083-11455-0 |
11d37eeaecd91a34bd13614ea06e7237d4c78f53 | Destination of visit: Falkland Islands | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 3 | 2013-07-08-80ef1083-11455-0 |
9e9ed70b1c8cee5a8f4db6482409141d326cce9e | Date of visit: 10-16 June 2012 | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 4 | 2013-07-08-80ef1083-11455-0 |
197b8ea2845f29fc50387d4f609b53176ca55537 | Purpose of visit: attendance at 30th Anniversary of Falkland Islands Liberation | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 5 | 2013-07-08-80ef1083-11455-0 |
0c5aa4158add78360fcb4e40ecf1f0f9eaaa3c45 | (Registered 3 July 2012) | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 6 | 2013-07-08-80ef1083-11455-0 |
89c218d673096d99561485937577719d539e587a | Name of donor: Oxfam GB | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 7 | 2013-07-08-80ef1083-11455-0 |
c60cf5f5374d5e7f9d4b54b1546a1add5ddbd90f | Address of donor: Oxfam House, John Smith Drive, Cowley, Oxford OX4 2JY | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 8 | 2013-07-08-80ef1083-11455-0 |
331313c2b6a8a96c40a60865d9c10d683689ba63 | Amount of donation (or estimate of the probable value): flight, hotel, food, airport transport; total £1,304.19 | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 9 | 2013-07-08-80ef1083-11455-0 |
8f5a25ef1ff2b805f8e399d22cd9697407b9ad6e | Destination of visit: New York | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 10 | 2013-07-08-80ef1083-11455-0 |
7eea772f334f9092e02480e1752fb1d503c0c9e2 | Date of visit: 1-4 July 2012 | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 11 | 2013-07-08-80ef1083-11455-0 |
d1bdfbc62acaeceb8adf9a605f07a0f0598e68f1 | 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-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 12 | 2013-07-08-80ef1083-11455-0 |
b50d0117d6fcf21ee0c3d20003c559e7f8091480 | (Registered 7 August 2012) | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 13 | 2013-07-08-80ef1083-11455-0 |
739f39ae3e22d2502d61b24550a398d6e2d3f778 | Name of donor: | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 14 | 2013-07-08-80ef1083-11455-0 |
a2d4370a8a224e2a6c37fe08f89ed8825f29e3f5 | 1) WSPA (World Society for the Protection of Animals) | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 15 | 2013-07-08-80ef1083-11455-0 |
ffe9ca52c2fd411170e0e935630fa234c994b2c8 | 2) Brittany Ferries | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 16 | 2013-07-08-80ef1083-11455-0 |
360d6015da08d1ad569d0d5f89ae7c998564038d | Address of donor: | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 17 | 2013-07-08-80ef1083-11455-0 |
3dc806e515a8856c8ca2db9d7c1389c97cfadba6 | 1) 222 Grays Inn Road, London WC1X 8HB | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 18 | 2013-07-08-80ef1083-11455-0 |
ec5f0bdd73fa535b9e5dfb8675e36c00364125fc | 2) Plymouth Port, Millbay, Plymouth, Devon PL1 3EW | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 19 | 2013-07-08-80ef1083-11455-0 |
06e82d0013b74e5d6bc77cdff590b5e8bc083f63 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 20 | 2013-07-08-80ef1083-11455-0 |
fa00e335399be6558e1b894f667023f46f65b9fa | 1) Travel and accommodation for two people; cost £650 | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 21 | 2013-07-08-80ef1083-11455-0 |
90d063b94593d5e8f548d988d7724714dbd3c352 | 2) Discount on travel and accommodation for two people; value £250 | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 22 | 2013-07-08-80ef1083-11455-0 |
d6818f64e6f85a17bc78b86fc2f31930ca362601 | Destination of visit: Bay of Biscay | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 23 | 2013-07-08-80ef1083-11455-0 |
71a597d05728968b94644e1c58c14b1a285b705f | Date of visit: 17-19 July 2012 | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 24 | 2013-07-08-80ef1083-11455-0 |
c406a3bdd036f3e5e710594d5470aaf9e4df534e | 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-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 25 | 2013-07-08-80ef1083-11455-0 |
465dd479e3bef68612edae90498801428c1bdff4 | (Registered 21 August 2012) | Overseas visits 80ef1083 | 2013-07-08 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 26 | 2013-07-08-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");