items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
31 rows where record_id = "2014-04-07-80ef1083-10051-0" sorted by record_id
This data as json, CSV (advanced)
date (date) 1 ✖
- 2014-04-07 31
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
06f05d5c60ff9722795fbab7f215a4d9dd235ab7 | Address of donor: private | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 1 | 2014-04-07-80ef1083-10051-0 |
3a10b0b6994669bb367d3c2f61ac1f39ac52abef | Amount of donation (or estimate of the probable value): £4,730 covering costs of flights, | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 2 | 2014-04-07-80ef1083-10051-0 |
40883cb4e78b0858fb0968655844a699aed646ec | Date of visit: 9-12 July 2013 | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 5 | 2014-04-07-80ef1083-10051-0 |
483e7a8c27b21e40e0722d11403d2f6f5357bc3a | (Registered 16 July 2013) | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 7 | 2014-04-07-80ef1083-10051-0 |
88ddb5eae59fa2cc2084494be4425b93a95e254a | Name of donor: Nael Farargy | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 8 | 2014-04-07-80ef1083-10051-0 |
ae5cf647d6243c2e4ee39c161ad2267d4be11210 | Address of donor: private | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 9 | 2014-04-07-80ef1083-10051-0 |
0cd125f85035964b2bf8f549ce74d15e3c3ad3c7 | Amount of donation (or estimate of the probable value): £2,886 covering costs of flights, | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 10 | 2014-04-07-80ef1083-10051-0 |
d584b62f489e6b812603b624194f2aa77ae31e6d | Date of visit: 29 July-1 August 2013 | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 13 | 2014-04-07-80ef1083-10051-0 |
80e4c381cc5b191e2be0431e9ea3b61219712766 | (Registered 2 August 2013) | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 15 | 2014-04-07-80ef1083-10051-0 |
2ad11b50e7d6893cc615a0d752ec29f5eeb07ac9 | Name of donor: Abercrombie and Kent Egypt | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 16 | 2014-04-07-80ef1083-10051-0 |
771a6de0bee7fed9bd0dbd0a3cf6ffe7390ea215 | Address of donor: 18 Youssel El-Guindy Street, El-Bustan Center, 10th Floor Cairo, Egypt | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 17 | 2014-04-07-80ef1083-10051-0 |
81d3e6a57fc8ff84517856ef77df36e5c81129e6 | Amount of donation (or estimate of the probable value): £2,500 covering costs of flights, | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 18 | 2014-04-07-80ef1083-10051-0 |
d7385738fb3281441df3826f90479328027e28dc | accommodation, subsistence and road travel | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 19 | 2014-04-07-80ef1083-10051-0 |
a89b1938aaafa42d1a350847541f0e408da20836 | Destination of visit: Cairo, Egypt | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 20 | 2014-04-07-80ef1083-10051-0 |
d830dab0bd76654f650371ccfe9383ea25989b2f | Date of visit: 16 -20 September 2013 | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 21 | 2014-04-07-80ef1083-10051-0 |
2550b7befc18289f4b0841dedc380b051c132b9c | 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-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 22 | 2014-04-07-80ef1083-10051-0 |
2e0686986e0540be91c9f6f1c21530ea2b4a3224 | (Registered 7 October 2013) | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 23 | 2014-04-07-80ef1083-10051-0 |
8883dbba0a20ff782d0030d3e26e5e7197d89a41 | Name of donor: Just Retirement | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 24 | 2014-04-07-80ef1083-10051-0 |
0d86c3ba44720ced7c8ae144495d2c0941929072 | Address of donor: Vale House, Roebuck Close, Bancroft Road, Reigate, Surrey, RH2 7RU. | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 25 | 2014-04-07-80ef1083-10051-0 |
dd139a6f42fc9f53022052ee1a807c07a663aadf | Amount of donation (or estimate of the probable value): £1,900 including costs of flights, | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 26 | 2014-04-07-80ef1083-10051-0 |
f723ef0cfe605483b9ccacd867b46a64a4408fa5 | accommodation, subsistence and taxis to and from airports and in Brussels | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 27 | 2014-04-07-80ef1083-10051-0 |
0562e9311598b235a1c49a7d43ff227cd1f386eb | Destination of visit: Brussels, Belgium | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 28 | 2014-04-07-80ef1083-10051-0 |
116c133b346d7897def9472b621e548f5b34663e | Date of visit: 25-28 September 2013 | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 29 | 2014-04-07-80ef1083-10051-0 |
c9d0baa3972158ea2316ee10df87c209e3fe4c29 | 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-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 30 | 2014-04-07-80ef1083-10051-0 |
4d959aae85af41cb74ee962a765e40475533d7d9 | Name of donor: Information International | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 31 | 2014-04-07-80ef1083-10051-0 |
779a724b261c9322df930c06f6458683809e97db | Address of donor: Al-Borj (An-Nahar) Bldg, 4th Floor, Martyrs Square, Beirut, Zip Code: 11-4353, Lebanon | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 32 | 2014-04-07-80ef1083-10051-0 |
4ca03e363e38677fc63c462d58cd4c6fd821da74 | Amount of donation (or estimate of the probable value): travel costs, accommodation and subsistence with a value of £1,700 | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 33 | 2014-04-07-80ef1083-10051-0 |
a5f2c5adc757f492efd761a68a94a08156de05e6 | Destination of visit: Lebanon | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 34 | 2014-04-07-80ef1083-10051-0 |
b0145e60fed66120b9b1d1de7363a1b5c65be7e4 | Date of visit: 26-29 January 2014 | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 35 | 2014-04-07-80ef1083-10051-0 |
fa9b17109efa4694e1fdbcdac4f7bb040dacda38 | Purpose of visit: Fact-finding delegation organised by the Council for Arab British Understanding | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 36 | 2014-04-07-80ef1083-10051-0 |
4c3bfb23218f69fd573a6100d02cc591632fae8b | (Registered 17 February 2014) | Overseas visits 80ef1083 | 2014-04-07 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 37 | 2014-04-07-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");