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)
Suggested facets: category_id, member_id, sort_order, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
b16a8c2077ba74bde00fd9421985ec54ff8bda93 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-04-12-ead1ca87-10465-0 |
fc062daf2e8b7346a5469f6983e6aaee2406ff93 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-04-12-1f359ece-10465-0 |
b51f157de241041bab813889f3fc63bf499598ee | 16 January 2010, payment of £6000. Hours: 100 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2010-04-12-1f359ece-10465-0 |
1da78331fa6b2d71630c19b7864bf5778a2401ef | Training for the National School of Government. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2010-04-12-1f359ece-10465-0 |
9d488b9f56bc3b485ebcc855061704bbf8d50a56 | Broadcasting fees from the BBC. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2010-04-12-1f359ece-10465-0 |
82a41376f0d912d334b67770de56aa8ae9396f4c | Fees from ITV for television appearances. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2010-04-12-1f359ece-10465-0 |
b528ddb14a5246756c1223c0453440167328f398 | Fees for training work for Luther Pendragon. | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 5 | 2010-04-12-1f359ece-10465-0 |
abeae9a7cf4c916f51a79cd299c5a278d993efb0 | Journalism for the Daily Sport. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 6 | 2010-04-12-1f359ece-10465-0 |
168b62fa9ae500eda7973f63fa66ccd495e0f977 | July 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 7 | 2010-04-12-1f359ece-10465-0 |
0fb084e1a1481c3ede98eb35054db81178311b71 | August 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 8 | 2010-04-12-1f359ece-10465-0 |
9da28c0a47d1cd6b8d4249e086d23fbc66888e4b | September 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 9 | 2010-04-12-1f359ece-10465-0 |
2c92c19c4e33277bf69067e0d2bbd78f0fb99e77 | October 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 10 | 2010-04-12-1f359ece-10465-0 |
1310edd746f2cbe58453f366da2eef5d4b0005cd | November 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 11 | 2010-04-12-1f359ece-10465-0 |
2846b4695cf9e98b0881b8be857c66a8c47bf994 | December 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 12 | 2010-04-12-1f359ece-10465-0 |
6749001f66a2fe4d4080f5c52205cd28550aa7d3 | January 2010, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 13 | 2010-04-12-1f359ece-10465-0 |
0f96cce0ed0f12ac21bb0a5a7f6bd0530d95029b | Payments for articles for Mail on Sunday newspaper, Associated Newspapers Ltd, 2 Derry Street, London W8 5TT: | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 14 | 2010-04-12-1f359ece-10465-0 |
c021d260d25f787f2f55bfe646d5a438058912d8 | £1000, 13 August 2009. Hours: 6 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 15 | 2010-04-12-1f359ece-10465-0 |
b25e1b820e9022bb75f440b64d7cca545ef139f2 | £1000, 2 September 2009. Hours: 6 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 16 | 2010-04-12-1f359ece-10465-0 |
8d7ce963af8fc3175418f647cfd1fe69ff019fac | £20,000 received 9 March 2009. Hours: 40 hrs. (Registered 4 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 17 | 2010-04-12-1f359ece-10465-0 |
4d5f8958efdf86aa4abae7de38e6012d5ebb7347 | Television appearances arranged via Personal Appearances, 20 North Mount, 1147-1161 High Road, Whetstone, London N20 OPH: | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 18 | 2010-04-12-1f359ece-10465-0 |
a622e90c3ace75b97090f9c99ccbb5bebae7d859 | £1000, 'Cash in the Attic', 9 June 2009. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 19 | 2010-04-12-1f359ece-10465-0 |
4305c9db5f19e4f76ed689ef30662975b588afc7 | £984, 'The King is Dead', 31 July 2009. Hours: 3 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 20 | 2010-04-12-1f359ece-10465-0 |
c7934e17588baad43c0ac52d7ebe9e257caf934d | £400, 'Big Brothers Little Brother', 11 August 2009. Hours: 1 hr. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 21 | 2010-04-12-1f359ece-10465-0 |
778dc8bc02ed44aa8977680841594acf016cae02 | £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-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 22 | 2010-04-12-1f359ece-10465-0 |
207bdb6d42188450e13ec277204b9fea3e2c52b2 | 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-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 23 | 2010-04-12-1f359ece-10465-0 |
b56d8ad24dacdd8cdefdf37b3442600bb40f7ea5 | 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-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 24 | 2010-04-12-1f359ece-10465-0 |
9a4aa087e516f9a14c850d36e2f78538b3a2767a | 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-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 25 | 2010-04-12-1f359ece-10465-0 |
6480694a3572257c4677b50b69f5844ab0c89785 | Name of donor: Corporate Technology and Investments Ltd | Sponsorships 8f616a6e | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-04-12-8f616a6e-10465-0 |
0353b044424da35a040e90b803961f15cdc04c69 | Address of donor: 5 th Floor, Imperial House, 15-19 Kingsway, London WC2B 6UN | Sponsorships 8f616a6e | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2010-04-12-8f616a6e-10465-0 |
6fb91d578bf2efe12925f60fa40bfe15f58df92d | Amount of donation or nature and value if donation in kind: donation of £2500 to my constituency party | Sponsorships 8f616a6e | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2010-04-12-8f616a6e-10465-0 |
ba23c779693b9930f1263b79e6e1714fbf9ca26d | Donor status: company, registration number 0652257 | Sponsorships 8f616a6e | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2010-04-12-8f616a6e-10465-0 |
be58559c015ad935eef6fad3c5fa62d66b88716c | (Registered 2 February 2010) | Sponsorships 8f616a6e | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2010-04-12-8f616a6e-10465-0 |
520f33d05427ffa8bf1f0e1af32da2f999d96826 | Name of donor: Caravan Club Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-04-12-84642823-10465-0 |
d30504c56ea6e9b92724d541cd495d0fdc7e07f3 | Address of donor : East Grinstead House, East Grinstead, West Sussex RH19 1UA | Gifts, benefits and hospitality (UK) 84642823 | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2010-04-12-84642823-10465-0 |
2174a26223865eada6a6eca7018622686b5fe5c1 | 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-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2010-04-12-84642823-10465-0 |
8fcd75a44034d5e5699d63e266a053e6f82bfa73 | Date of receipt of donation: 23 July 2009 | Gifts, benefits and hospitality (UK) 84642823 | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2010-04-12-84642823-10465-0 |
f1be357c6be4105852bb17918529744c757a023d | Date of acceptance of donation: 23 July 2009 | Gifts, benefits and hospitality (UK) 84642823 | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2010-04-12-84642823-10465-0 |
a5b5318c61405784147b3e011cfa386427a0f3e5 | Donor status: company, registration number 646027 | Gifts, benefits and hospitality (UK) 84642823 | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 5 | 2010-04-12-84642823-10465-0 |
2ec5cb0178b1020036d43368563791717f024248 | (Registered 2 February 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 6 | 2010-04-12-84642823-10465-0 |
f6a263464d0406fd5b8fb1f7c5f629c7a59a46a4 | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2010-04-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-04-12-3aff2389-10465-0 |
9ef2359c2094838817e2cef444a37137cef12046 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-03-24-ead1ca87-10465-0 |
100b184f9c068649eeb677f26f4cb5eb54466acd | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-03-24-1f359ece-10465-0 |
35b058d9e3eeef40d977cc4e10cc68863193bcfc | 16 January 2010, payment of £6000. Hours: 100 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2010-03-24-1f359ece-10465-0 |
2ef20f6b8b16927fb9918bc808f3cd25d86b0740 | Training for the National School of Government. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2010-03-24-1f359ece-10465-0 |
6e7f7877677e048a9d0a310170940681bad91c1d | Broadcasting fees from the BBC. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2010-03-24-1f359ece-10465-0 |
79b7150e9fd58195bf968deff66778b92334b62f | Fees from ITV for television appearances. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2010-03-24-1f359ece-10465-0 |
2d5f75fcfba9bc621bb4d14ae3828877144fe9e8 | Fees for training work for Luther Pendragon. | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 5 | 2010-03-24-1f359ece-10465-0 |
82cf282a04f20e3e3cd09f001b73df9628af3483 | Journalism for the Daily Sport. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 6 | 2010-03-24-1f359ece-10465-0 |
a00f4d2d594e6205017f034502a46df28f6ee4e7 | July 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 7 | 2010-03-24-1f359ece-10465-0 |
7f5381bfee49412a58e6341414a43b92e05ee4c5 | August 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 8 | 2010-03-24-1f359ece-10465-0 |
708ead61dd328e8a1d6ec4d9908e2f4669d08fb4 | September 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 9 | 2010-03-24-1f359ece-10465-0 |
5bdbf2e2658871f579e6fa568bbdd8f7a799a76d | October 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 10 | 2010-03-24-1f359ece-10465-0 |
d8f32e0a32eb9c66d0d6ae7cc2c0e824d3694a71 | November 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 11 | 2010-03-24-1f359ece-10465-0 |
ae45270d71d6eadd7189dea22bb8d72c6b614ea0 | December 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 12 | 2010-03-24-1f359ece-10465-0 |
ba0916eb1539f623ee80ca890378e1b0fe41e03e | January 2010, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 13 | 2010-03-24-1f359ece-10465-0 |
3fb5e1d42e5e5cdb028d8d00bfca52fcc3330e3f | Payments for articles for Mail on Sunday newspaper, Associated Newspapers Ltd, 2 Derry Street, London W8 5TT: | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 14 | 2010-03-24-1f359ece-10465-0 |
9ae6135e4f3d2357f1b92a145116c8e49136a7e0 | £1000, 13 August 2009. Hours: 6 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 15 | 2010-03-24-1f359ece-10465-0 |
ac6b1a5c9d1ca37b4e585ccdc3281c59b472dff7 | £1000, 2 September 2009. Hours: 6 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 16 | 2010-03-24-1f359ece-10465-0 |
3118edb90c07f4d4ba624903158bae7ebbf34cd3 | £20,000 received 9 March 2009. Hours: 40 hrs. (Registered 4 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 17 | 2010-03-24-1f359ece-10465-0 |
18eb678aed3725dc51fb910c1c9602049f9dd296 | Television appearances arranged via Personal Appearances, 20 North Mount, 1147-1161 High Road, Whetstone, London N20 OPH: | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 18 | 2010-03-24-1f359ece-10465-0 |
17287abd8b9adfa9f5f04629f30e947f24356ce0 | £1000, 'Cash in the Attic', 9 June 2009. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 19 | 2010-03-24-1f359ece-10465-0 |
0d10b7b7589f66446097a0dedfb9074dee6b6302 | £984, 'The King is Dead', 31 July 2009. Hours: 3 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 20 | 2010-03-24-1f359ece-10465-0 |
dd62c89182d4bf9e819858776fbe2e14d1d8f83c | £400, 'Big Brothers Little Brother', 11 August 2009. Hours: 1 hr. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 21 | 2010-03-24-1f359ece-10465-0 |
a6fe9b6b25100d1848cb905a974c3db826c57739 | £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-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 22 | 2010-03-24-1f359ece-10465-0 |
b3fcb8755955fbd3c96bea1f1125a2c1317f4243 | 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-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 23 | 2010-03-24-1f359ece-10465-0 |
f349a117cac2af5c972f8a761ac06eadb3296414 | 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-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 24 | 2010-03-24-1f359ece-10465-0 |
2e1284b28c4a0a010e85f4edd338ae7abbe9f763 | 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-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 25 | 2010-03-24-1f359ece-10465-0 |
a9c96115c67bfaa46181325d442f1b2774d60ab9 | Name of donor: Corporate Technology and Investments Ltd | Sponsorships 8f616a6e | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-03-24-8f616a6e-10465-0 |
95f93816b49dd310027e5b044dbd5637d0b4bc65 | Address of donor: 5 th Floor, Imperial House, 15-19 Kingsway, London WC2B 6UN | Sponsorships 8f616a6e | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2010-03-24-8f616a6e-10465-0 |
864c790a2bcc60021306448f0af94b06f160d3d0 | Amount of donation or nature and value if donation in kind: donation of £2500 to my constituency party | Sponsorships 8f616a6e | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2010-03-24-8f616a6e-10465-0 |
2e020d24533f50ee7075b2f29f9923013ed0611c | Donor status: company, registration number 0652257 | Sponsorships 8f616a6e | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2010-03-24-8f616a6e-10465-0 |
cb629af6af775f6d24505f290f6a868264df4058 | (Registered 2 February 2010) | Sponsorships 8f616a6e | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2010-03-24-8f616a6e-10465-0 |
d3f8e1ae63a2e7af0f5084f6dc20e864cfc4878c | Name of donor: Caravan Club Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-03-24-84642823-10465-0 |
ab31525fc0dfff7faa8c682c8bb1b0b4d479261f | Address of donor : East Grinstead House, East Grinstead, West Sussex RH19 1UA | Gifts, benefits and hospitality (UK) 84642823 | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2010-03-24-84642823-10465-0 |
fc1da2d2f9827fc4297d6c6bf090a61e13b4ac2a | 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-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2010-03-24-84642823-10465-0 |
eff69f5efce2d7f0e3e2bee019b0a2d72cd55f47 | Date of receipt of donation: 23 July 2009 | Gifts, benefits and hospitality (UK) 84642823 | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2010-03-24-84642823-10465-0 |
1903f9118867f603e5064d452d3ddc2aac5a887e | Date of acceptance of donation: 23 July 2009 | Gifts, benefits and hospitality (UK) 84642823 | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2010-03-24-84642823-10465-0 |
8f97758449bd72bd6d67452060d2826da0a77a1d | Donor status: company, registration number 646027 | Gifts, benefits and hospitality (UK) 84642823 | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 5 | 2010-03-24-84642823-10465-0 |
2cb8ae1d65bbf84daec18e1de974cff906405893 | (Registered 2 February 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 6 | 2010-03-24-84642823-10465-0 |
5ec25136c0ee1316f30566fa6e8a4bac3b05e82d | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2010-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-03-24-3aff2389-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 |
3ae1095a082a780e60829d95e77c74f92fd9cdb9 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-03-10-1f359ece-10465-0 |
05212ca99253a6f02b7da2b28e3235df50f7e227 | 16 January 2010, payment of £6000. Hours: 100 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 | 1 | 2010-03-10-1f359ece-10465-0 |
28850f7fad315df8595beed93570621a979b0e35 | Training for the National School of Government. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2010-03-10-1f359ece-10465-0 |
12c53cd73d3d02bff7b59f106d38f785f3bcfa54 | Broadcasting fees from the BBC. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2010-03-10-1f359ece-10465-0 |
5940247cd18c7bdfd6fec727545f214e4818a120 | Fees from ITV for television appearances. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2010-03-10-1f359ece-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 |
1e340ff7dd7dea65d4c483d58c857fb629ba11fe | Journalism for the Daily Sport. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 6 | 2010-03-10-1f359ece-10465-0 |
b7812fdba96f26037d3488f10a9b278e289447ab | July 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 | 7 | 2010-03-10-1f359ece-10465-0 |
72ebcec9098e1ec4f9398882f0ba866f8f036d75 | August 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 | 8 | 2010-03-10-1f359ece-10465-0 |
ca4548490ab94a3c7b87515808dc05eb78b137a1 | September 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 | 9 | 2010-03-10-1f359ece-10465-0 |
36e33fb1d365020ad2c76e75e843e829167a71b6 | October 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 | 10 | 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 |
5580c02fb6a30cdff28cd3ff4d0c8e441afa72f2 | December 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 | 12 | 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 |
24fe82247c563c7a8f415758adbc2b3974401a2f | Payments for articles for Mail on Sunday newspaper, Associated Newspapers Ltd, 2 Derry Street, London W8 5TT: | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 14 | 2010-03-10-1f359ece-10465-0 |
39719c81061945fb93038526678a15febf76a4e7 | £1000, 13 August 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 | 15 | 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 |
2ab63d3501b780ca72b98b76ed1f46c38f560ce6 | £20,000 received 9 March 2009. Hours: 40 hrs. (Registered 4 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 17 | 2010-03-10-1f359ece-10465-0 |
d850e19082d18a54886b5dbc988d88073854e043 | Television appearances arranged via Personal Appearances, 20 North Mount, 1147-1161 High Road, Whetstone, London N20 OPH: | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 18 | 2010-03-10-1f359ece-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");