items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
724 rows where person_id = "uk.org.publicwhip/person/10465" sorted by hash
This data as json, CSV (advanced)
Suggested facets: category_id, member_id, date (date)
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
009e072c92b1d726b5f00c7645f7333a6ab336dc | Training for the National School of Government. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2007-06-05 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2007-06-05-1f359ece-10465-0 |
013a70feeb32c39ddb70b6e5d0bca5fe395f011a | Journalism for the Daily Sport. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2009-06-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2009-06-10-1f359ece-10465-0 |
01cbf691fdb07fcaf84d399c3a291eb60e1a4f75 | Fees from BBC for appearances on Keith Barret Show and Mastermind. (Registered 7 September 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-05-12 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2006-05-12-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 |
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 |
02e7001c7a7093e8b45a3898f12f997dfffd3e1b | Fee from Hello Magazine which was donated entirely to the Motor Neurone Disease Association. (£10,001-£15,000) (Registered 28 March 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-12-04 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2007-12-04-1f359ece-10465-0 |
033fadad8a318804e81bbad238db7b89be6fe503 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2007-10-09 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-10-09-ead1ca87-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 |
03d238bb39b290294d497cb6c7ef68112c6e9d32 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2009-10-28 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2009-10-28-ead1ca87-10465-0 |
04b3a6be1f25444229637751beb249abb4fd30d9 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2007-02-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-02-06-ead1ca87-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 |
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 |
0538ace45655040d8a575fc4dbc8a7cc660c6541 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2007-03-13 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-03-13-ead1ca87-10465-0 |
05a3f77874c3495649c04cee4df1b350bee56f29 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2007-07-17 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-07-17-ead1ca87-10465-0 |
0625842227e8918e70c1925120d1fd81fb6479c2 | Fees from ITV for television appearances. (£5,001-£10,000) (Registered 25 March 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-03-25 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 5 | 2008-03-25-1f359ece-10465-0 |
06d5817c2324de41772e4fc5ff46dd608c45132d | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2009-06-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2009-06-24-3aff2389-10465-0 |
06e904423e2bebd0d31df392e62775a3fef78f4c | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2007-05-15 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-05-15-ead1ca87-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 |
0710d6592613056e17b8e5416aff59b11340edb7 | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2007-03-13 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-03-13-3aff2389-10465-0 |
07d8d4489c07d5ac6d8e5d826977383c21669615 | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2009-07-08 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2009-07-08-3aff2389-10465-0 |
07ef1095eb56354ad22e62747c36cdbd51464e1f | Training for the National School of Government. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2008-11-19 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2008-11-19-1f359ece-10465-0 |
085041683b9698b02d45a61f4f36e968fc993df7 | Member of Harris Research Panel. (£1-£1,000) | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Lembit Öpik uk.org.publicwhip/member/465 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2000-11-10-1f359ece-10465-0 |
0a5df88697b6852d6c011d096386142bd1997e4a | Loan of a Segway Personal Transporter from Segway. (Registered 19 November 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2008-12-17 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2008-12-17-84642823-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 |
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 |
0c9ae621f5ba63f4041484f406c339cb9dc5eda6 | Broadcasting fees from the BBC. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2009-04-22 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2009-04-22-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 |
0d1a43249f90ac813c676bf1c663ec69305c1227 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2009-09-02 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2009-09-02-ead1ca87-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 |
0dc8522a849839196591dfcbf190d190c0a3cc41 | Address of donor: 5 th Floor, Imperial House, 15-19 Kingsway, London WC2B 6UN | Sponsorships 8f616a6e | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2010-03-10-8f616a6e-10465-0 |
0e2232ec83780151de63bbb8f9f7b261029376f9 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2007-06-19 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-06-19-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 |
0e565a5a598a81022658b41bbdd9f488cedde18b | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2007-08-28 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-08-28-ead1ca87-10465-0 |
0e9c1b2567b42aa84514f28758b2a7ccfa23232e | Broadcasting fees from the BBC. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2008-10-22 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2008-10-22-1f359ece-10465-0 |
0eb8b378ebf9cd3ea5fa80d1b3937a0b6b41d292 | Training for the National School of Government. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2009-11-11 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2009-11-11-1f359ece-10465-0 |
0f188731bdf87ddfc5bce8b26f629eabbe7d71a6 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2008-03-11 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2008-03-11-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 |
0f5f8abed05ffcb12007ef2653aa7352d25c5638 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2007-11-20 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-11-20-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 |
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 |
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 |
1014052d5781840c6df8a2267708fc88dc190473 | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2007-10-23 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-10-23-3aff2389-10465-0 |
105e5ef625e3148fa3eeb6b2f1aa2473816a48e2 | Fee from Sunday Express for Election Diary. (Registered 30 October 2001) | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2002-05-14-1f359ece-10465-0 |
1137d03085c8f951434d3e827d92dee023bde9e9 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2008-04-23 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2008-04-23-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 |
12d7f6760f55bf04c581b5d17f6c1e1259818233 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2008-10-22 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2008-10-22-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 |
13178d473d336b52d5ce4cc771e2f39ac99e9d1a | Fees for appearing on BBC radio and television programmes. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2004-07-16 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2004-07-16-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 |
1407a0c98134d05403bcf34d745de55ea4d3e642 | Broadcasting fees from the BBC. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2009-11-25 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2009-11-25-1f359ece-10465-0 |
150f3acfe36070bdcf2d7087aac5a83b9da70acc | Training for the National School of Government. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2008-10-22 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2008-10-22-1f359ece-10465-0 |
153b20be3ae028be0d4e4b997c0ca857f7c5cc1b | 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-11-25 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2009-11-25-84642823-10465-0 |
154caeac8a755b1499d29024f1f5f6f37e3daa0b | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2007-05-01 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-05-01-ead1ca87-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 |
15a9806e43f548101f0b808c388de91288794a6a | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2006-12-11 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-12-11-3aff2389-10465-0 |
15c04f7ee3f508ab6392e16d24d1262ccd661e9b | 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-09-02 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2009-09-02-84642823-10465-0 |
15f93cfc5f8224af69aedf072e150ee6a08a3fc3 | Journalism for the Daily Sport. (Up to £5,000) (Registered 25 March 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-09-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2008-09-03-1f359ece-10465-0 |
16561e2dba34af274be5b24fdb6543ee541eac66 | Journalism for the Daily Sport. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2009-05-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2009-05-06-1f359ece-10465-0 |
1687a591420a24b1f9b1a56e25e9e5cca0d76fc5 | 6 November 1999, one ticket to the Rugby World Cup Final in Cardiff, paid for by British Gas. (Registered 22 November 1999) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Lembit Öpik uk.org.publicwhip/member/465 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2000-11-10-84642823-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 |
171032fd655359373ec52451fe4d733de40df0ce | Broadcasting fees from the BBC. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2007-05-15 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2007-05-15-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 |
1859bd93caaf6d4c7319ad51f05151a0829fde25 | Fees from ITV for television appearances. (£5,001-£10,000) (Registered 25 March 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-10-22 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2008-10-22-1f359ece-10465-0 |
187e524589de4d61cde68f47dcf3a6397de262f7 | Training for the National School of Government. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2009-02-25 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2009-02-25-1f359ece-10465-0 |
18d77c36eee922bc454d27aa4601faa5014d9b2c | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2006-11-27 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-11-27-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 |
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 |
1998d36392b93a739e62477e54ac4f9705b216fe | Training for the National School of Government. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2009-01-28 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2009-01-28-1f359ece-10465-0 |
1ab20c89fe59b02947e581dd6042d172fafdac5d | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2008-11-05 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2008-11-05-1f359ece-10465-0 |
1b009782b51a3aaa470ef64c871f7b2d9f6a1602 | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2009-09-02 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2009-09-02-3aff2389-10465-0 |
1bacb2b524299f63b271eba3fd906148a55a2f30 | March 2002, to Estonia, to attend Eurovision Song Contest. Two tickets for Eurovision Song Contest and overnight accommodation for two people provided by Tallinn City Council. (Registered 31 October 2002) | Overseas visits 80ef1083 | 2003-12-04 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2003-12-04-80ef1083-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 |
1cdc2228f30f15af9f293fe0f9ec53f342b15c98 | Training for the National School of Government. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2008-02-05 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2008-02-05-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 |
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 |
1e6704565eae39d7eae1bba72891e7e6e2166f1d | Fees from BBC for appearances on Keith Barret Show and Mastermind. (Registered 7 September 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-02-13 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2006-02-13-1f359ece-10465-0 |
1e894af8e4f15f7eb0baa56f6bd8925aa7fb8359 | Training for the National School of Government. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2009-07-08 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2009-07-08-1f359ece-10465-0 |
1ea7bd1dcd1be5223a7968d593ba670d68e37431 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2009-04-22 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2009-04-22-1f359ece-10465-0 |
1ee6355820529ff1cd049c04ea150b8380ff80f7 | Fee from Hello Magazine. (Registered 7 September 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-02-13 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-02-13-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 |
20821ec5803f48d7497ae2946879d5738afab6e1 | Fees for training work for Luther Pendragon. | Remunerated employment, office, profession etc 1f359ece | 2008-10-08 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 5 | 2008-10-08-1f359ece-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 |
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 |
21e8720f13c100a5f438a75a6cedb246e31c2cd8 | I received the use of a motor-home for the weekend of 28 July 2006 at the expense of the Caravan Club of Great Britain, in order to attend the CLA Game Fair. (Registered 8 August 2006) | Gifts, benefits and hospitality (UK) 84642823 | 2007-10-09 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-10-09-84642823-10465-0 |
223c6e9642290092d607b446e26f4d7f168de1a2 | Journalism for the Daily Sport. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2009-07-08 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2009-07-08-1f359ece-10465-0 |
22405edc537d333abd6249e5e69b9db07def5e32 | Fees for training work for Luther Pendragon. | Remunerated employment, office, profession etc 1f359ece | 2008-11-05 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 5 | 2008-11-05-1f359ece-10465-0 |
22744769549dff3aab2d257fa2eb73a6cbf06ce4 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2007-02-27 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-02-27-ead1ca87-10465-0 |
22c6abdda5421b778de66a5c1230ca6e5c08d789 | Journalism for the Daily Sport. (Up to £5,000) (Registered 25 March 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-07-08 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2008-07-08-1f359ece-10465-0 |
2318da07111cb3284dd86e21cec8e811bf3d3c8c | Training for the National School of Government. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2007-10-09 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2007-10-09-1f359ece-10465-0 |
2454474de9719ade884dd9c45276c17aa52ec004 | I received the use of a motor-home for the weekend of 28 July 2006 at the expense of the Caravan Club of Great Britain, in order to attend the CLA Game Fair. (Registered 8 August 2006) | Gifts, benefits and hospitality (UK) 84642823 | 2007-01-23 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-01-23-84642823-10465-0 |
248ec449854f792580a84c19f07109586d28683e | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2009-01-14 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2009-01-14-1f359ece-10465-0 |
24faa6e82c1c9ea4044b6706bc0386be9571a9b5 | Parliamentary adviser to the Chartered Institute of Marketing. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2007-03-26 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2007-03-26-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 |
2617aee47e8e6cec5db3a70c38821c22ec381cf9 | Fees from BBC for appearances on Keith Barret Show and Mastermind. (Registered 7 September 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-12-14 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2005-12-14-1f359ece-10465-0 |
2652043dc84953d5002c91578f393d24f3bc6027 | Broadcasting fees from the BBC. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2009-05-20 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2009-05-20-1f359ece-10465-0 |
2689246222ab73123b1342567d6f90f337500e20 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2008-01-22 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2008-01-22-ead1ca87-10465-0 |
26bb48aefee45bb980100a61c5938e7de3d00f62 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2007-11-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-11-06-ead1ca87-10465-0 |
270221eb6a40fab31145e6d13a87b7f3431fdce4 | 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-03-25 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2009-03-25-84642823-10465-0 |
27fd21b7fb42a4afc367c76f1390741f9359749d | Article for Hello! Magazine published on 21 January 2003. (Registered 27 February 2003) | Remunerated employment, office, profession etc 1f359ece | 2003-12-04 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2003-12-04-1f359ece-10465-0 |
27ff211ce62d68216d06aba70d4cfb2a03cc686d | I received the use of a motor-home for the weekend of 28 July 2006 at the expense of the Caravan Club of Great Britain, in order to attend the CLA Game Fair. (Registered 8 August 2006) | Gifts, benefits and hospitality (UK) 84642823 | 2007-07-17 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-07-17-84642823-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");