items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
31 rows where record_id = "2014-06-16-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 |
---|---|---|---|---|---|---|---|
a81f8b175c779e028fe94b91b2b7d6b5ba499464 | Address of donor: private | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 1 | 2014-06-16-80ef1083-10051-0 |
405a17c8df296296ef35569d675f6ff1b757ff24 | Amount of donation (or estimate of the probable value): £4,730 covering costs of flights, | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 2 | 2014-06-16-80ef1083-10051-0 |
7b8a29f3f5931c6694e14f59826d4e2666f84651 | Date of visit: 9-12 July 2013 | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 5 | 2014-06-16-80ef1083-10051-0 |
3bfe3886becf52a3023a22b61fe4efc3a91a6559 | (Registered 16 July 2013) | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 7 | 2014-06-16-80ef1083-10051-0 |
c28a3372a0a4c329bfed3fd9177b0e6c5ae0d443 | Name of donor: Nael Farargy | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 8 | 2014-06-16-80ef1083-10051-0 |
5fc33213bc606f6a5fe16e284ac44c794980fee4 | Address of donor: private | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 9 | 2014-06-16-80ef1083-10051-0 |
df2e3d5bc1020b84c48f4916122690a3d1e712ab | Amount of donation (or estimate of the probable value): £2,886 covering costs of flights, | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 10 | 2014-06-16-80ef1083-10051-0 |
066b3fb05389431c3060f5664f20d5cf65c19319 | Date of visit: 29 July-1 August 2013 | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 13 | 2014-06-16-80ef1083-10051-0 |
b3100b88e599f82d1e84c4afcb9e5d314eca0f5c | (Registered 2 August 2013) | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 15 | 2014-06-16-80ef1083-10051-0 |
6d75efba7f4aca4c2279dfaef8a0812d6f95bb84 | Name of donor: Abercrombie and Kent Egypt | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 16 | 2014-06-16-80ef1083-10051-0 |
2fa15b1630984ba9f59a10aed6a4c3e6877c8fb5 | Address of donor: 18 Youssel El-Guindy Street, El-Bustan Center, 10th Floor Cairo, Egypt | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 17 | 2014-06-16-80ef1083-10051-0 |
f7223afea90c5c4b8fafb14a23a09e0e395d934f | Amount of donation (or estimate of the probable value): £2,500 covering costs of flights, | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 18 | 2014-06-16-80ef1083-10051-0 |
74a28cab955c13c19a761a9d53d6ba992aeb6333 | accommodation, subsistence and road travel | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 19 | 2014-06-16-80ef1083-10051-0 |
c4800bc0e0f1dda3f40f880eedbe565024cf451c | Destination of visit: Cairo, Egypt | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 20 | 2014-06-16-80ef1083-10051-0 |
4c84f5ba93ac725d1a24cc60a926efa6651c3155 | Date of visit: 16 -20 September 2013 | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 21 | 2014-06-16-80ef1083-10051-0 |
a3597305cf21f0170bf48e76275374b8097a1219 | 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-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 22 | 2014-06-16-80ef1083-10051-0 |
1b0749cc3c631abf8549314e38803f42d93ae3cb | (Registered 7 October 2013) | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 23 | 2014-06-16-80ef1083-10051-0 |
54ca6be31e645e432f8d7cc971cba2245aecef63 | Name of donor: Just Retirement | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 24 | 2014-06-16-80ef1083-10051-0 |
cf9a6635253c84acf4c76cc052a72714a82955f1 | Address of donor: Vale House, Roebuck Close, Bancroft Road, Reigate, Surrey, RH2 7RU. | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 25 | 2014-06-16-80ef1083-10051-0 |
1692b68d362195cdd59a2d6b6e4ebc5aef812c71 | Amount of donation (or estimate of the probable value): £1,900 including costs of flights, | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 26 | 2014-06-16-80ef1083-10051-0 |
a18b15146ede9fe1afba32bd4290066f4c05197d | accommodation, subsistence and taxis to and from airports and in Brussels | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 27 | 2014-06-16-80ef1083-10051-0 |
b19f043731feb13c04803be71047e4d775143412 | Destination of visit: Brussels, Belgium | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 28 | 2014-06-16-80ef1083-10051-0 |
55826fcfd1e1174f7755e2f7f722742de7502552 | Date of visit: 25-28 September 2013 | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 29 | 2014-06-16-80ef1083-10051-0 |
6180768cc59cc75be305dec7e6811752f2947a61 | 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-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 30 | 2014-06-16-80ef1083-10051-0 |
58687ac3c8fe701c6e49d5ed8883cd98f113e479 | Name of donor: Information International | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 31 | 2014-06-16-80ef1083-10051-0 |
4abd3564e61fca7f0799ca9f750dd0fcbaaa3f23 | Address of donor: Al-Borj (An-Nahar) Bldg, 4th Floor, Martyrs Square, Beirut, Zip Code: 11-4353, Lebanon | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 32 | 2014-06-16-80ef1083-10051-0 |
a6f60e0e0acd8639d3f8bb9b735de33da34d413d | Amount of donation (or estimate of the probable value): travel costs, accommodation and subsistence with a value of £1,700 | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 33 | 2014-06-16-80ef1083-10051-0 |
bfbb3c7437ccbcd8b5078a2ddf3d58ec401f46d1 | Destination of visit: Lebanon | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 34 | 2014-06-16-80ef1083-10051-0 |
56b120d73265a998a6ec292689094cc614d952b2 | Date of visit: 26-29 January 2014 | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 35 | 2014-06-16-80ef1083-10051-0 |
6d1a81c874cf9fee15ac9ae4d60bfccb31c8c204 | Purpose of visit: Fact-finding delegation organised by the Council for Arab British Understanding | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 36 | 2014-06-16-80ef1083-10051-0 |
211516bd948b7ec07ea04318431d45c6fbe5a868 | (Registered 17 February 2014) | Overseas visits 80ef1083 | 2014-06-16 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 37 | 2014-06-16-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");