items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
724 rows where person_id = "uk.org.publicwhip/person/10465" sorted by date descending
This data as json, CSV (advanced)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
df136f02b80f6de734ef2aa1d29a08364ac5c004 | (Registered 2 February 2010) | Sponsorships 8f616a6e | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2010-03-10-8f616a6e-10465-0 |
e4a327b8784eca0a26456553d52979e9a6e90eca | £400, 'Big Brothers Little Brother', 11 August 2009. Hours: 1 hr. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 21 | 2010-03-10-1f359ece-10465-0 |
e7c918b1a8c8262eed0f6b3b5f37df337755cb0e | January 2010, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 13 | 2010-03-10-1f359ece-10465-0 |
eac0aebed1243cfa38670e57bd04f42164e17434 | £1000, 2 September 2009. Hours: 6 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 16 | 2010-03-10-1f359ece-10465-0 |
ed382325cdeb386db72a4c4c4af43a050baabf1a | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-03-10-ead1ca87-10465-0 |
f0cbcab90233c096590c69b9a86fb93434233c8d | Fees for training work for Luther Pendragon. | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 5 | 2010-03-10-1f359ece-10465-0 |
f3b12b22b7dcbbde253da520467fe3ff88bd74ad | November 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 11 | 2010-03-10-1f359ece-10465-0 |
02023220d62ddfe0a3ac9da3b7ed037e0eb38d5b | January 2010, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 13 | 2010-02-24-1f359ece-10465-0 |
0b47c3ddf6f8288ba79c671cf7f77ebafb8efdce | £1000, 13 August 2009. Hours: 6 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 15 | 2010-02-24-1f359ece-10465-0 |
0dbff4a71ba641ce500daeb3660d42d47b998586 | Payments for articles for Mail on Sunday newspaper, Associated Newspapers Ltd, 2 Derry Street, London W8 5TT: | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 14 | 2010-02-24-1f359ece-10465-0 |
13a7bf4416e9c73aedd840059d466fbcfb3f4b27 | Amount of donation or nature and value if donation in kind: loan of motor home during CLA Game Fair at Belvoir Castle, Leicestershire, 23-27 July 2009; approximate value £660 | Gifts, benefits and hospitality (UK) 84642823 | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2010-02-24-84642823-10465-0 |
1cc0a72c168cf9410c4bf14f7a93ef56255781a2 | Donor status: company, registration number 0652257 | Sponsorships 8f616a6e | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2010-02-24-8f616a6e-10465-0 |
28f59096f16d0a89e5bd224b4f38574004049fc9 | Name of donor: Caravan Club Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-02-24-84642823-10465-0 |
3afa7f6b0c4277c2ee1fc33d5a6a94ce7af99457 | August 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 8 | 2010-02-24-1f359ece-10465-0 |
4158d32e9faff3aaf783107fa2eb8aab2fa9163b | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-02-24-ead1ca87-10465-0 |
474b10bd3c8c4f476f4bee37dda8783f17656724 | Date of receipt of donation: 23 July 2009 | Gifts, benefits and hospitality (UK) 84642823 | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2010-02-24-84642823-10465-0 |
48b7b70d28b4fd2efacee5972363db3565dff7de | Name of donor: Corporate Technology and Investments Ltd | Sponsorships 8f616a6e | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-02-24-8f616a6e-10465-0 |
4f8a74f62b9711e3d0cb73b9217655fd1d3cda79 | 16 January 2010, payment of £6000. Hours: 100 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2010-02-24-1f359ece-10465-0 |
5090707f18f05f6e44a743f5b91b5cc3d6fa5682 | £984, 'The King is Dead', 31 July 2009. Hours: 3 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 19 | 2010-02-24-1f359ece-10465-0 |
50a1faacaac8ebe1d64cae3cfa7e21b0ec3597ae | (Registered 2 February 2010) | Sponsorships 8f616a6e | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2010-02-24-8f616a6e-10465-0 |
5107c9cf25c300478130b6bf29a7a90e1b16c849 | Broadcasting fees from the BBC. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2010-02-24-1f359ece-10465-0 |
691cf53ddb91e85cf88286759430a566d91a1562 | £1000, 2 September 2009. Hours: 6 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 16 | 2010-02-24-1f359ece-10465-0 |
6f0a762c537e29a510822f104aad192bf699d411 | Television appearances arranged via Personal Appearances, 20 North Mount, 1147-1161 High Road, Whetstone, London N20 OPH: | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 17 | 2010-02-24-1f359ece-10465-0 |
800bd72f050d7cdb2d215851d8e87d93306e9fef | (Registered 2 February 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 6 | 2010-02-24-84642823-10465-0 |
86efe8bb66ed6f623c436a8037bf26760d0ae4bf | Date of acceptance of donation: 23 July 2009 | Gifts, benefits and hospitality (UK) 84642823 | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2010-02-24-84642823-10465-0 |
88664416707b95a3288e142e533833b0df5928f6 | £1000, 'Cash in the Attic', 9 June 2009. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 18 | 2010-02-24-1f359ece-10465-0 |
8c2f66f8a83812f9b49fed40bf39205bfd61a7d0 | Address of donor: 5 th Floor, Imperial House, 15-19 Kingsway, London WC2B 6UN | Sponsorships 8f616a6e | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2010-02-24-8f616a6e-10465-0 |
8ef12c4022dac9c7279a94609aa92e7552af2670 | July 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 7 | 2010-02-24-1f359ece-10465-0 |
95415cc4e3a380612dcae8f77d32e80afb00f176 | Amount of donation or nature and value if donation in kind: donation of £2500 to my constituency party | Sponsorships 8f616a6e | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2010-02-24-8f616a6e-10465-0 |
aa56d5c2537a66464d2a655131cb1cb07eec3f2f | September 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 9 | 2010-02-24-1f359ece-10465-0 |
b2dcf8fbff686f16d098f3c11bbc26e94fbc60c5 | Speaking engagement for (Cunard) Carnival plc, 5 Gainsford Street, London SE1 2NE, 29 November-4 December 2009. Hospitality, accommodation and travel to the value of £5752. Hours: 10 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 24 | 2010-02-24-1f359ece-10465-0 |
b734b907d4081dda067aefc4cc1b6f7039ee0993 | Fees for training work for Luther Pendragon. | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 5 | 2010-02-24-1f359ece-10465-0 |
b78fd61c0fa13b8cf22d7074741ce8e7f5dd0886 | November 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 11 | 2010-02-24-1f359ece-10465-0 |
b7f836c029c049edfc6a5bd613cb897fcb7f2141 | December 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 12 | 2010-02-24-1f359ece-10465-0 |
bf1d9749c6d17accf31d7006662ca984a5b693c1 | Payment of £2000 (plus £390 food and accommodation) for after dinner speech and informal seminar for Avery Healthcare Ltd, 1b Basset Court, Loake Close, Grange Park, Northampton NN4 5EZ, 24 November 2009. Hours: 4 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 23 | 2010-02-24-1f359ece-10465-0 |
c2d9e4c943e23cd0f2a6fa89404db49fcc2529c4 | Training for the National School of Government. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2010-02-24-1f359ece-10465-0 |
c65babb894610b7b4debc647f9aaf7f3b6b61222 | Fees from ITV for television appearances. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2010-02-24-1f359ece-10465-0 |
cf6d43a49d6997a39b9a200334f0865a5f45e0db | £191.25, 'The End of the Year Show', 30 October 2009. Hours: 2 hrs. (Registered 9 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 21 | 2010-02-24-1f359ece-10465-0 |
df87352e2c25fc3b1f5ca751c7742b5874581f21 | Journalism for the Daily Sport. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 6 | 2010-02-24-1f359ece-10465-0 |
e3d198430f81682ab8bdfe1048bdcaaf97acb2bc | Donor status: company, registration number 646027 | Gifts, benefits and hospitality (UK) 84642823 | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 5 | 2010-02-24-84642823-10465-0 |
e8e2b07f9b638e81962c1cf7ae892a042fd4c3e8 | October 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 10 | 2010-02-24-1f359ece-10465-0 |
ed678626526eb362311fe2beb53d1428539a5fdb | Address of donor : East Grinstead House, East Grinstead, West Sussex RH19 1UA | Gifts, benefits and hospitality (UK) 84642823 | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2010-02-24-84642823-10465-0 |
f07ad90f653664697d1ae8b3270dad44bf596e67 | £400, 'Big Brothers Little Brother', 11 August 2009. Hours: 1 hr. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 20 | 2010-02-24-1f359ece-10465-0 |
f0d782c1f77f94916743339af07f2873a5c456a3 | Payment of £150 for political seminar for GovNet Communications, 3 rd Floor, St James Buildings, 79 Oxford Street, Manchester M1 6PP, 23 July 2009. Hours: 1 hr. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 22 | 2010-02-24-1f359ece-10465-0 |
f7e94f79923d5e112bb5631017744843aeb20e50 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-02-24-1f359ece-10465-0 |
fd98f75c46dab45e063b86fa97bc2e0aceb0799e | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2010-02-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-02-24-3aff2389-10465-0 |
026f46c9f31bccd7ce4dd84cc008c709851d815e | (Registered 2 February 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 7 | 2010-02-03-84642823-10465-0 |
04f89a5a0a4e4dbf5441df016392b6c6729fd697 | Name of donor: Corporate Technology and Investments Ltd | Sponsorships 8f616a6e | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-02-03-8f616a6e-10465-0 |
070878dd6f8c894b63499c6060131406d8e1290d | January 2010, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 13 | 2010-02-03-1f359ece-10465-0 |
0c2f133c99f0feb7b10afcf6095283ee34ed6850 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-02-03-ead1ca87-10465-0 |
0e47993e59786c8b1a7690b221d0cb9e4c18b099 | Loan of a Segway Personal Transporter from Segway, and subsequent purchase at a preferential rate. (Registered 19 November 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-02-03-84642823-10465-0 |
158d1f6f3df2566734436e76ac32d29aba306082 | Name of donor: Caravan Club Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2010-02-03-84642823-10465-0 |
2150c73db81035b789a894c2a492ea2194e67ec7 | (Registered 2 February 2010) | Sponsorships 8f616a6e | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2010-02-03-8f616a6e-10465-0 |
30038e1e5fb744a59d8e2f9812ec57848ca49bb4 | Payments for articles for Mail on Sunday newspaper, Associated Newspapers Ltd, 2 Derry Street, London W8 5TT: | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 14 | 2010-02-03-1f359ece-10465-0 |
37f14db829c95f3cb956b8a6a4212c4636ff1ef7 | £1000, 2 September 2009. Hours: 6 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 16 | 2010-02-03-1f359ece-10465-0 |
43521cdd0d6b25e8e60696ebf1e1118d086fa523 | £984, 'The King is Dead', 31 July 2009. Hours: 3 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 19 | 2010-02-03-1f359ece-10465-0 |
44bf67f8c6fbe05bedf343bd3f4ad42dad4938db | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-02-03-3aff2389-10465-0 |
5c0dadbfbf538a611784c9936068d9b56e54d82c | £1000, 'Cash in the Attic', 9 June 2009. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 18 | 2010-02-03-1f359ece-10465-0 |
5e06d2b8ff3bf23272dd00549120e848529452a3 | Payment of £150 for political seminar for GovNet Communications, 3 rd Floor, St James Buildings, 79 Oxford Street, Manchester M1 6PP, 23 July 2009. Hours: 1 hr. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 21 | 2010-02-03-1f359ece-10465-0 |
61c02f774659ad5fae27e7883d48f05321b46c61 | Payment of £2000 (plus £390 food and accommodation) for after dinner speech and informal seminar for Avery Healthcare Ltd, 1b Basset Court, Loake Close, Grange Park, Northampton NN4 5EZ, 24 November 2009. Hours: 4 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 22 | 2010-02-03-1f359ece-10465-0 |
777a88e320aac570e052877fa8c2df0711609194 | £400, 'Big Brothers Little Brother', 11 August 2009. Hours: 1 hr. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 20 | 2010-02-03-1f359ece-10465-0 |
7a7c9a4164413dce11346b97ed9f67d436e04c58 | November 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 11 | 2010-02-03-1f359ece-10465-0 |
7cca533643375f094c54d0adffe74710bb705fc7 | Amount of donation or nature and value if donation in kind: donation of £2500 to my constituency party | Sponsorships 8f616a6e | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2010-02-03-8f616a6e-10465-0 |
819177411983a501d3797cf22bbf3166b62fbdd7 | December 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 12 | 2010-02-03-1f359ece-10465-0 |
81cefe3c37f7bdafa3d949ac2e6ea13b45851beb | July 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 7 | 2010-02-03-1f359ece-10465-0 |
85d1e718cb00f0a8e086e53d4ce7887f3d4d382c | Television appearances arranged via Personal Appearances, 20 North Mount, 1147-1161 High Road, Whetstone, London N20 OPH: | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 17 | 2010-02-03-1f359ece-10465-0 |
8a11b25666c6cd770814c350aa1b77542a95a3b0 | Donor status: company, registration number 646027 | Gifts, benefits and hospitality (UK) 84642823 | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 6 | 2010-02-03-84642823-10465-0 |
8fd4ba4635e193ef7ab15369aa138bec1d421799 | September 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 9 | 2010-02-03-1f359ece-10465-0 |
9763fd309ed64e0421f92b3841de5b3f78cfcf8f | 16 January 2010, payment of £6000. Hours: 100 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2010-02-03-1f359ece-10465-0 |
9e6c1175ca2e7104ead10f941d7e2861bbcb69f5 | Broadcasting fees from the BBC. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2010-02-03-1f359ece-10465-0 |
abaec1f9ba57aa6ca2a1f145e8c93f4e4ba7eeff | £1000, 13 August 2009. Hours: 6 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 15 | 2010-02-03-1f359ece-10465-0 |
b004abb9ff5ad3e73cd94e674cfdb16b56791151 | Date of receipt of donation: 23 July 2009 | Gifts, benefits and hospitality (UK) 84642823 | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2010-02-03-84642823-10465-0 |
b1307adc52d4e9b390e96fceccade942bd0041a7 | Fees from ITV for television appearances. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2010-02-03-1f359ece-10465-0 |
b16a7463a3889e3ab929085349314a6c6177c753 | Journalism for the Daily Sport. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 6 | 2010-02-03-1f359ece-10465-0 |
b26c852ee4ad2c8c296674527c2add8518b4fb7f | Address of donor: 5 th Floor, Imperial House, 15-19 Kingsway, London WC2B 6UN | Sponsorships 8f616a6e | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2010-02-03-8f616a6e-10465-0 |
cb684035c1b39e16eebe8a13bb012cec719d8d62 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-02-03-1f359ece-10465-0 |
cc75ba37ea8c3017795a729896b9ffb29fb976d1 | Training for the National School of Government. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2010-02-03-1f359ece-10465-0 |
cef084e71508f9ade0df8c1be0d76c6b9fc1679a | Speaking engagement for (Cunard) Carnival plc, 5 Gainsford Street, London SE1 2NE, 29 November-4 December 2009. Hospitality, accommodation and travel to the value of £5752. Hours: 10 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 23 | 2010-02-03-1f359ece-10465-0 |
d4f1e639f5b71dd1aa6f7582647c07d1bc457b9e | Amount of donation or nature and value if donation in kind: loan of motor home during CLA Game Fair at Belvoir Castle, Leicestershire, 23-27 July 2009; approximate value £660 | Gifts, benefits and hospitality (UK) 84642823 | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2010-02-03-84642823-10465-0 |
d7538cada3cfd0dbdf7d99c8bcb94d729cb97bec | Address of donor : East Grinstead House, East Grinstead, West Sussex RH19 1UA | Gifts, benefits and hospitality (UK) 84642823 | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2010-02-03-84642823-10465-0 |
d8005784fede208de63fe5941bfed1e419070fec | October 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 10 | 2010-02-03-1f359ece-10465-0 |
e2eb479dd5d79d6774021e73d02c20a5e975573f | Date of acceptance of donation: 23 July 2009 | Gifts, benefits and hospitality (UK) 84642823 | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 5 | 2010-02-03-84642823-10465-0 |
e89a4cbdd08fc3c12a56c388daecb29483ffd06b | Donor status: company, registration number 0652257 | Sponsorships 8f616a6e | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2010-02-03-8f616a6e-10465-0 |
f1c79da4151a84a30f1e6693bb6aed4ea4a0beb1 | Fees for training work for Luther Pendragon. | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 5 | 2010-02-03-1f359ece-10465-0 |
fbe66838251d024c276dce8a81f18a90bf5d9a59 | August 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 8 | 2010-02-03-1f359ece-10465-0 |
0f2e44650d0487c11845eaf09348ce22491440f0 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-01-06-1f359ece-10465-0 |
41e9c4178495f1ed4ef73323f2ea963b2aca9342 | Training for the National School of Government. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2010-01-06-1f359ece-10465-0 |
46f82a36070be3b42ef730afe48fc9c01a7819d3 | Broadcasting fees from the BBC. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2010-01-06-1f359ece-10465-0 |
49f489982bf4ce3832534f61023ab9412d25ac94 | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2010-01-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-01-06-3aff2389-10465-0 |
4a48deb4bfba77cf5a2de20528402fba078cd4c5 | Loan of a Segway Personal Transporter from Segway, and subsequent purchase at a preferential rate. (Registered 19 November 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2010-01-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-01-06-84642823-10465-0 |
7b435713815fbe20fd2e611a0a9dd9ea2ccb31ff | Fees for training work for Luther Pendragon. | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 5 | 2010-01-06-1f359ece-10465-0 |
7bd3df9808414cd983577c53af569eaa9c833865 | Fees from ITV for television appearances. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2010-01-06-1f359ece-10465-0 |
8caff95114f753ea991f6fcdfde52a6ffe75f2c1 | Journalism for the Daily Sport. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2010-01-06-1f359ece-10465-0 |
d71a040715d9166943c2ab4d88e5a498d2dd2ed6 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2010-01-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-01-06-ead1ca87-10465-0 |
648067fa1d298acd966b9e5a367bc973756769d5 | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2009-12-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2009-12-10-3aff2389-10465-0 |
682fe06bb9c5f02f000179d8e07e7a33e0956f56 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2009-12-10-1f359ece-10465-0 |
7097c7f5f8284bb1cd4b801a8077d6cef6cf79e3 | Fees from ITV for television appearances. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2009-12-10-1f359ece-10465-0 |
8fc5bff3a543bff29dff86f4bda87a440d7aa7b5 | Journalism for the Daily Sport. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2009-12-10-1f359ece-10465-0 |
8ffabcb38adfe5b43066717ee2e92e774f64cd62 | Loan of a Segway Personal Transporter from Segway, and subsequent purchase at a preferential rate. (Registered 19 November 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2009-12-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2009-12-10-84642823-10465-0 |
9f3df6add0fa2cb9d894d74be777693a8b848f87 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2009-12-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2009-12-10-ead1ca87-10465-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");