items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
26 rows where record_id = "2013-09-09-80ef1083-10051-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 |
---|---|---|---|---|---|---|---|
22c074432653ebcebfb6544a539d6a99b029aa3b | Name of donor: Government of the United Arab Emirates | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 0 | 2013-09-09-80ef1083-10051-0 |
3d3e929a6a917feadc636be3f4a9ada5ed2b658b | Address of donor: c/o Embassy of the UAE, 30 Princes Gate, London SW7 1PT | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 1 | 2013-09-09-80ef1083-10051-0 |
bffe94572af1ce6b5fe5993ad0166487589bbd62 | Amount of donation (or estimate of the probable value): costs of visit; value £3,500 | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 2 | 2013-09-09-80ef1083-10051-0 |
05bab825e6b90cfba4ec870e9f1b89d5dfe87aa8 | Destination of visit: Abu Dhabi and Dubai, United Arab Emirates | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 3 | 2013-09-09-80ef1083-10051-0 |
e3408533534e404aa672c897e487b01cb4adae59 | Date of visit: 23-28 November 2012 | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 4 | 2013-09-09-80ef1083-10051-0 |
ead38b45f90704a6cc47f2a5990167ef1bd6c3c1 | Purpose of visit: to meet with Government ministers, Members of the Federal National Council, UK diplomatic and armed forces personnel, senior UK and Emirati business figures to better understand the regional security perspective, the state of the bilateral relationship and the scale of UK-UAE trade, investment, security and cultural ties, to strengthen the political relationship and identify opportunities to promote the trade and investment relationship. | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 5 | 2013-09-09-80ef1083-10051-0 |
def0b8557a4ebbf139cd8004f0144541586ed982 | (Registered 5 December 2012) | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 6 | 2013-09-09-80ef1083-10051-0 |
920efbccf6f585860cb19b3fbe381076c4a36fd3 | Name of donor: Jamaica Tourist Board | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 7 | 2013-09-09-80ef1083-10051-0 |
2af1472309965679569a2440c14a0c93ba918f7e | Address of donor: 1 - 2 Prince Consort Road, London SW7 2BZ | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 8 | 2013-09-09-80ef1083-10051-0 |
2a27cee5ea9faf38c06d33a5fe519b2f1f6cc405 | Amount of donation (or estimate of the probable value): approximately £2,950 for air travel and accommodation | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 9 | 2013-09-09-80ef1083-10051-0 |
a4893dbbd3defb2fc4b7be278cfa862bd89e3dc6 | Destination of visit: Kingston and St Elizabeth Parish, Jamaica | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 10 | 2013-09-09-80ef1083-10051-0 |
466063dfbe50306aee108af29cafa7b797578292 | Date of visit: 14-21 February 2013 | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 11 | 2013-09-09-80ef1083-10051-0 |
45b2df697846864ba4ac8985c33a3cbb33f3f84e | Purpose of visit: to officiate at the opening of the Lords and Commons Pavilion at the BREDS Foundation Community Project. Visit also included bilateral talks with the Jamaican Prime Minister and other ministers, prison visit, meeting with human rights organisation, cricket matches and youth coaching. | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 12 | 2013-09-09-80ef1083-10051-0 |
d2d40934c63b40916d2c8226b9f4b268daf1534a | (Registered 13 March 2013) | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 13 | 2013-09-09-80ef1083-10051-0 |
7e87379666186b90a0764de0b9d3ac8ea122bbb1 | Address of donor: private | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 15 | 2013-09-09-80ef1083-10051-0 |
644ef3656b6ee12da5962b38989e5c469d32c47d | Amount of donation (or estimate of the probable value): £4,730 covering costs of flights, | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 16 | 2013-09-09-80ef1083-10051-0 |
8a4114d6939af89cff0b98b1e8ed66f2734dba47 | Date of visit: 9-12 July 2013 | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 19 | 2013-09-09-80ef1083-10051-0 |
0efe5ad50601dfe4210b09503b9d5774e2325a36 | (Registered 16 July 2013) | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 21 | 2013-09-09-80ef1083-10051-0 |
592d7f6cf58ed4a886f362c0407b46f0c96c3d6c | Name of donor: Nael Farargy | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 22 | 2013-09-09-80ef1083-10051-0 |
21dc476ede5617472052de48e166dfb303039e8a | Address of donor: private | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 23 | 2013-09-09-80ef1083-10051-0 |
558d70bc9abe732526681d5e9b7a1ff716b94034 | Amount of donation (or estimate of the probable value): £2,886 covering costs of flights, | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 24 | 2013-09-09-80ef1083-10051-0 |
ec9184d687e8be0a286dc9730212250d61aef061 | accommodation, subsistence and road travel | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 25 | 2013-09-09-80ef1083-10051-0 |
aeabe8653e05b9b6ebafc98dc26415f946496721 | Destination of visit: Cairo, Egypt | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 26 | 2013-09-09-80ef1083-10051-0 |
e9479f1ea24b6a0d62fb92adcad863c834d5e265 | Date of visit: 29 July-1 August 2013 | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 27 | 2013-09-09-80ef1083-10051-0 |
9e65b973312ec918d41ed91979c83dd35ff3a141 | Purpose of visit: to meet political, public, security and diplomatic figures in the current Egyptian political crisis and to make an assessment of the situation. | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 28 | 2013-09-09-80ef1083-10051-0 |
dddfe4f6bca0153de24461d7dde49e3c4d10fa3a | (Registered 2 August 2013) | Overseas visits 80ef1083 | 2013-09-09 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 29 | 2013-09-09-80ef1083-10051-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");