items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2013-11-25-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 |
---|---|---|---|---|---|---|---|
3556b706688cef388e961e45f3b2efdd5647ca99 | Name of donor: (1) UK-Korea Forum for the Future; (2) The Korea Foundation | Overseas visits 80ef1083 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 0 | 2013-11-25-80ef1083-11455-0 |
ccc8b8818d898a4ee582a377bcba71ac89220d1d | 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 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 1 | 2013-11-25-80ef1083-11455-0 |
b0af5c813fd56ccfaa1ab4043f3c46a725a3ad2c | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 2 | 2013-11-25-80ef1083-11455-0 |
12136b2cd9f15dc2570d5c3bcb3c22fab10cdf24 | (2) Flights: value £2,644; (2) Accommodation; value £999 | Overseas visits 80ef1083 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 3 | 2013-11-25-80ef1083-11455-0 |
aebd502e94bf76735c6ffae1f827322a56844e5a | Destination of visit: Seoul, Republic of Korea | Overseas visits 80ef1083 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 4 | 2013-11-25-80ef1083-11455-0 |
48f0806b3e892d2edd96b5e0966a14028757613c | Date of visit: 11-15 June 2013 | Overseas visits 80ef1083 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 5 | 2013-11-25-80ef1083-11455-0 |
0857c97dbc8a9cbd8784b23a5380c6ba7e23a0b1 | Purpose of visit: To attend the annual meeting of the UK-Korea Forum for the Future | Overseas visits 80ef1083 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 6 | 2013-11-25-80ef1083-11455-0 |
eed4bebd022a17f0d4794f145fb38bbe8052ea86 | (Registered 16 July 2013) | Overseas visits 80ef1083 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 7 | 2013-11-25-80ef1083-11455-0 |
d59a54bfd3dc1d59982d1a4e63c9e67aea4bfd14 | Name of donor: RESULTS UK | Overseas visits 80ef1083 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 8 | 2013-11-25-80ef1083-11455-0 |
5f18eafc833fbba727133ca25a44dd6bd2ef122a | Address of donor: Second Floor, 31-33 Bondway, London SW8 1SJ | Overseas visits 80ef1083 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 9 | 2013-11-25-80ef1083-11455-0 |
765ea16613c7b358da1ba1affdc13a26a013792d | 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 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 10 | 2013-11-25-80ef1083-11455-0 |
c78670defad76db31b72894d7f22216f71f41233 | Destination of visit: Malawi | Overseas visits 80ef1083 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 11 | 2013-11-25-80ef1083-11455-0 |
6555f1c4551199ed70e2c5f3d960ad9b1fa2a1f6 | Date of visit: 18-22 August 2013 | Overseas visits 80ef1083 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 12 | 2013-11-25-80ef1083-11455-0 |
f2e032ddbc3b1e9b6ec507e7cbe9f4b95bea228b | Purpose of visit: to examine key global health issues | Overseas visits 80ef1083 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 13 | 2013-11-25-80ef1083-11455-0 |
caed6152bed815b8a0f70296b7e8775bb3eda106 | (Registered 23 October 2013) | Overseas visits 80ef1083 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 14 | 2013-11-25-80ef1083-11455-0 |
ac845e613fcc6087b7f8ef9d170b5a97c750fd6a | 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 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 15 | 2013-11-25-80ef1083-11455-0 |
1c0f5c591159e23a5398d7d493e886d2d1773c80 | Address of donor: 1 Ton That Dam, Hanoi, Vietnam | Overseas visits 80ef1083 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 16 | 2013-11-25-80ef1083-11455-0 |
d4e7fcc2599463222161e99ce58d9ebda57ac5cf | 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 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 17 | 2013-11-25-80ef1083-11455-0 |
32e45756ac994dd694b7d6d9be1c0e198f2dc339 | Date of visit: 2-8 November 2013 | Overseas visits 80ef1083 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 18 | 2013-11-25-80ef1083-11455-0 |
e9a05a1b7f9e60b2b5533fffd150c780161fcfd4 | Purpose of visit: Friends of Vietnam study mission | Overseas visits 80ef1083 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 19 | 2013-11-25-80ef1083-11455-0 |
a311197f6f6aa2d076e589fe72527e07030bef5d | (Registered 19 November 2013) | Overseas visits 80ef1083 | 2013-11-25 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 20 | 2013-11-25-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");