items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
31 rows where record_id = "2014-01-20-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 |
---|---|---|---|---|---|---|---|
135e62c8dda2c7557b91357293f7f26792e216ef | Name of donor: Jamaica Tourist Board | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 0 | 2014-01-20-80ef1083-10051-0 |
808fa3695d18db65faffb6a830d50966f6ed2e19 | Address of donor: 1 - 2 Prince Consort Road, London SW7 2BZ | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 1 | 2014-01-20-80ef1083-10051-0 |
6ecf9a313d67273e7944797d1721f2208e57ba80 | Amount of donation (or estimate of the probable value): approximately £2,950 for air travel and accommodation | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 2 | 2014-01-20-80ef1083-10051-0 |
cad84c9604c6858b8f84838f8ff0034f9680b101 | Destination of visit: Kingston and St Elizabeth Parish, Jamaica | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 3 | 2014-01-20-80ef1083-10051-0 |
ee2b3ca3467138b481cc81d6e95820cf0626c7c0 | Date of visit: 14-21 February 2013 | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 4 | 2014-01-20-80ef1083-10051-0 |
e76cae98ff7a25b0a9d060406ba5ec2dd9230ca2 | 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 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 5 | 2014-01-20-80ef1083-10051-0 |
5e43b3f24a4b5880e0ed4e5e46e0ddc1e33a1cde | (Registered 13 March 2013) | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 6 | 2014-01-20-80ef1083-10051-0 |
34da9f92d7b825992e7e2b51ac32079628c2ebcf | Address of donor: private | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 8 | 2014-01-20-80ef1083-10051-0 |
e25bc6d0f48e14bfb57e062c5e4e859071f056e2 | Amount of donation (or estimate of the probable value): £4,730 covering costs of flights, | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 9 | 2014-01-20-80ef1083-10051-0 |
527115b313477e6f81356219b221c1ff41b16bc4 | Date of visit: 9-12 July 2013 | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 12 | 2014-01-20-80ef1083-10051-0 |
4c247591d7ed57cf7048e20f8c14d9ba3e10e6b0 | (Registered 16 July 2013) | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 14 | 2014-01-20-80ef1083-10051-0 |
2a803d7b55d2d24ff75f6f0ceaf4c30453140307 | Name of donor: Nael Farargy | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 15 | 2014-01-20-80ef1083-10051-0 |
acdf3811e2876702866a1b23f16f881d8c4d4c4d | Address of donor: private | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 16 | 2014-01-20-80ef1083-10051-0 |
7e9d3145b8a79736a9ab3d3b68421c1a0c5ecdff | Amount of donation (or estimate of the probable value): £2,886 covering costs of flights, | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 17 | 2014-01-20-80ef1083-10051-0 |
d6bf8dda39b62f78c2647787f17f78e7c4be9387 | Date of visit: 29 July-1 August 2013 | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 20 | 2014-01-20-80ef1083-10051-0 |
2f3378d2ddb72937c924d0bf1a385bcc7992b6f1 | (Registered 2 August 2013) | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 22 | 2014-01-20-80ef1083-10051-0 |
2f18c5cb2b58faabd0044eefd36007a225bed8a1 | Name of donor: Abercrombie and Kent Egypt | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 23 | 2014-01-20-80ef1083-10051-0 |
29ca6946bb5f219dac629d771440a4e752bd103e | Address of donor: 18 Youssel El-Guindy Street, El-Bustan Center, 10th Floor Cairo, Egypt | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 24 | 2014-01-20-80ef1083-10051-0 |
6ed2e0e73fd838755c44e5b31c9d4ebcc0f7c7f9 | Amount of donation (or estimate of the probable value): £2,500 covering costs of flights, | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 25 | 2014-01-20-80ef1083-10051-0 |
fc3812369c87c16b3161615cd7c2acc6f681b8f3 | accommodation, subsistence and road travel | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 26 | 2014-01-20-80ef1083-10051-0 |
ba685dc58c17e6242dafa5abcc212e36b7a7861e | Destination of visit: Cairo, Egypt | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 27 | 2014-01-20-80ef1083-10051-0 |
edf1e1a773c9a0df0c3d083075b06b2c8d8ed762 | Date of visit: 16 -20 September 2013 | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 28 | 2014-01-20-80ef1083-10051-0 |
b8b4b9bce1fd7646e8f4337ad133574d7ea8db97 | 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 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 29 | 2014-01-20-80ef1083-10051-0 |
66f100455173470bd1189df70f8a7d01e749ffc8 | (Registered 7 October 2013) | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 30 | 2014-01-20-80ef1083-10051-0 |
a8b8081fd0855d58bbdd793729ec054b6ec9d442 | Name of donor: Just Retirement | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 31 | 2014-01-20-80ef1083-10051-0 |
eb9e2399d1c00c1b8914ae014ebd074cb41663ae | Address of donor: Vale House, Roebuck Close, Bancroft Road, Reigate, Surrey, RH2 7RU. | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 32 | 2014-01-20-80ef1083-10051-0 |
0464d794c7ad62c1203674fb812d39c00f29a435 | Amount of donation (or estimate of the probable value): £1,900 including costs of flights, | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 33 | 2014-01-20-80ef1083-10051-0 |
64a15392a992805cdeea6d13e97996bf89d26811 | accommodation, subsistence and taxis to and from airports and in Brussels | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 34 | 2014-01-20-80ef1083-10051-0 |
128e2d5cd4355eb4dd5391f3246f8fd4798883d6 | Destination of visit: Brussels, Belgium | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 35 | 2014-01-20-80ef1083-10051-0 |
2d482e618dd0881847493682262bb98a9d79f2b8 | Date of visit: 25-28 September 2013 | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 36 | 2014-01-20-80ef1083-10051-0 |
2d398a5337c936b0d1417e577f1e4f9fc787ec0d | Purpose of visit: To make the case for changes to the proposed EU Solvency II regulations to the EU Parliament, EU Commission and national delegations to the EU Council of Ministers (Registered 1 November 2013) | Overseas visits 80ef1083 | 2014-01-20 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 37 | 2014-01-20-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");