items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2014-06-30-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 |
---|---|---|---|---|---|---|---|
3795548b2feb4d12bdcfc02c5b341e6234fbcccd | Name of donor: (1) UK-Korea Forum for the Future; (2) The Korea Foundation | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 0 | 2014-06-30-80ef1083-11455-0 |
8521fd7304951853824f0828234654046d65ea23 | Address of donor: (1) 14 Sandgate Lane, London SW18 3JP; (2) 10th floor, Diplomatic Center, 2558 Nambusunhwanno, Seochu-gu, Seoul 137-863 | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 1 | 2014-06-30-80ef1083-11455-0 |
c0501f940011236d32ae0bad7d7b8e4ca239fc29 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 2 | 2014-06-30-80ef1083-11455-0 |
d3df6751b10aeba1ec76c01d9a19099c0552616c | (2) Flights: value £2,644; (2) Accommodation; value £999 | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 3 | 2014-06-30-80ef1083-11455-0 |
2ca39b865d91bb8c1db30f35d299db8f1e9d45f6 | Destination of visit: Seoul, Republic of Korea | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 4 | 2014-06-30-80ef1083-11455-0 |
ec3f5c1484702a25eb14568e1f31e8b94832a8cb | Date of visit: 11-15 June 2013 | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 5 | 2014-06-30-80ef1083-11455-0 |
f87b2e887915459956503d89a56e1447ffb79b48 | Purpose of visit: To attend the annual meeting of the UK-Korea Forum for the Future | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 6 | 2014-06-30-80ef1083-11455-0 |
80fa7729f300064d0169cc70b08825a1c278372a | (Registered 16 July 2013) | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 7 | 2014-06-30-80ef1083-11455-0 |
1aa30dc61dd5b161c8a5aa5a90141ac736e71439 | Name of donor: RESULTS UK | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 8 | 2014-06-30-80ef1083-11455-0 |
070c25bf109731f5f0c6e0bb04449eef5603ab02 | Address of donor: Second Floor, 31-33 Bondway, London SW8 1SJ | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 9 | 2014-06-30-80ef1083-11455-0 |
de161725ac30a4b37ed70f02af9dc9998f29f890 | Amount of donation (or estimate of the probable value): flights, £658; 4 nights’ accommodation, £440; in country transport, £30; meals, £95; total cost £1,223 | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 10 | 2014-06-30-80ef1083-11455-0 |
51b9ee6d5cbea8f94befa0047c162fee5827461e | Destination of visit: Malawi | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 11 | 2014-06-30-80ef1083-11455-0 |
99a2a4e259a815c67991e1d163e677f9b1b86252 | Date of visit: 18-22 August 2013 | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 12 | 2014-06-30-80ef1083-11455-0 |
0c8b72c2d8105736dc943959fb90d014e3dcf87f | Purpose of visit: to examine key global health issues | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 13 | 2014-06-30-80ef1083-11455-0 |
af065825d3cb76b56e6b73a26aa487c38ba5505d | (Registered 23 October 2013) | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 14 | 2014-06-30-80ef1083-11455-0 |
8802d5d49d3d0da786b75ff6067ca5dd54880fa4 | Name of donor: Government of Socialist Republic of Vietnam, with assistance from the Friends of Vietnam, an informal group of British and Vietnamese companies. Airfares paid by Vietnam airlines. | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 15 | 2014-06-30-80ef1083-11455-0 |
c956027dbaddc338bfbe4a52a8bccf43fb936518 | Address of donor: 1 Ton That Dam, Hanoi, Vietnam | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 16 | 2014-06-30-80ef1083-11455-0 |
607837cfa12ad0ee233cdf75596ed091e2546591 | Amount of donation (or estimate of the probable value): air fares, accommodation and other costs with a total value of approx £4,500. Destination of visit: Vietnam | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 17 | 2014-06-30-80ef1083-11455-0 |
f7836b854718d5468f87b58ce4618bc624fe4296 | Date of visit: 2-8 November 2013 | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 18 | 2014-06-30-80ef1083-11455-0 |
c943da970cd339672b14bdffee9d9d277da50b1c | Purpose of visit: Friends of Vietnam study mission | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 19 | 2014-06-30-80ef1083-11455-0 |
7a86fe225e650519537e594e9679c3ed48d93cc9 | (Registered 19 November 2013) | Overseas visits 80ef1083 | 2014-06-30 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 20 | 2014-06-30-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");