items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
724 rows where person_id = "uk.org.publicwhip/person/10465" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: member_id, sort_order, date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
8e614f9def988094e3f056c0be811f590945000c | Occasional journalism. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Lembit Öpik uk.org.publicwhip/member/465 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2000-11-10-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 |
68dd7746c6f9238e84660be6134d5a025ae2299b | Occasional journalism. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Lembit Öpik uk.org.publicwhip/member/465 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2001-05-14-1f359ece-10465-0 |
69ef5e1f05b3e184c418a2e0b3669e31786afe4b | Occasional journalism. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2002-05-14-1f359ece-10465-0 |
e661a22545ec79332c82cc11d2b8e6ca82b5a937 | Summer 2001, use of flight simulator provided by Society of British Aerospace Companies. (Registered 30 October 2001) | Gifts, benefits and hospitality (UK) 84642823 | 2002-05-14 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2002-05-14-84642823-10465-0 |
666b41151e28b2c46e1b2e640e2f4c8e9f66eec1 | Fee for training activity at Luther Pendragon, 2002. (Registered 31 October 2002) | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2002-11-26-1f359ece-10465-0 |
eb4e0b25ef8b117145d61486c6e3c84852af4f1d | 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 | 2002-11-26 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2002-11-26-80ef1083-10465-0 |
f69d3c8d20f62a60152e4bd563e904cb69496861 | Fee for training activity at Luther Pendragon, 2002. (Registered 31 October 2002) | Remunerated employment, office, profession etc 1f359ece | 2003-12-04 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2003-12-04-1f359ece-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 |
e53581b1d9644cabb1bab357aa7637f5702cdd8d | Fee for training activity at Luther Pendragon, 2002. (Registered 31 October 2002) | Remunerated employment, office, profession etc 1f359ece | 2004-01-31 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2004-01-31-1f359ece-10465-0 |
d6191cf9e34333bce38261eb4f6826bb4b474fb9 | 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 | 2004-01-31 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2004-01-31-80ef1083-10465-0 |
7cb98897bb5c99b30f7d9c14adf75b259e860670 | Fees for appearing on BBC radio and television programmes. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2004-05-21 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2004-05-21-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 |
96c3ad29ac1f3d165c12e79c4a548711f7b99b3e | Fees for appearing on BBC radio and television programmes. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2004-09-08 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2004-09-08-1f359ece-10465-0 |
743e5d3d9bbed3677bcb5bb12cdd647e839f90db | Fees for appearing on BBC radio and television programmes. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2004-10-22-1f359ece-10465-0 |
551637f4ee0a3d320e71c25941f7f82cfe7efaee | Fees for appearing on BBC radio and television programmes. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2004-12-03 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2004-12-03-1f359ece-10465-0 |
bdef4bd592aa84cc7613cfa3165dbc540988669c | Fees for appearing on BBC radio and television programmes. (Up to £5,000) | Remunerated employment, office, profession etc.. 12405e8c | 2005-01-28 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2005-01-28-12405e8c-10465-0 |
b4d266ca8edbf4c51d355235023d6c53678e6516 | Fees for appearing on BBC radio and television programmes. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2005-04-11-1f359ece-10465-0 |
61848f083bf34ced598dbeec6e67310f83d1526f | 18 January 2005, to Toulouse for launch of Airbus A380, paid for by Airbus. (Registered 7 February 2005) | Overseas visits 80ef1083 | 2005-04-11 | Lembit Öpik uk.org.publicwhip/member/1143 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2005-04-11-80ef1083-10465-0 |
e19e732e4ff502ecefbcb9fc46c738163a876681 | May 2004, fee from Hello magazine for interview. (Up to £5,000) (Registered 10 February 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-11-01 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2005-11-01-1f359ece-10465-0 |
c57fa4ed9e97a5a0c71c7a9e9c441746fb9bcb79 | 18 January 2005, to Toulouse for launch of Airbus A380, paid for by Airbus. (Registered 7 February 2005) | Overseas visits 80ef1083 | 2005-11-01 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2005-11-01-80ef1083-10465-0 |
cf40f45828b1632dd46fb954e5d72c722dfa8fb4 | May 2004, fee from Hello magazine for interview. (Up to £5,000) (Registered 10 February 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-12-14 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2005-12-14-1f359ece-10465-0 |
b9846e3ff6c184f2b8f1f530447230955dcc720c | 18 January 2005, to Toulouse for launch of Airbus A380, paid for by Airbus. (Registered 7 February 2005) | Overseas visits 80ef1083 | 2005-12-14 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2005-12-14-80ef1083-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 |
3e70877ffda863505607e1c9cce24f6da1bc14bf | Fee from Hello Magazine. (Registered 7 September 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-02-14 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-02-14-1f359ece-10465-0 |
c2664cd8cd5bf1cfe9d1c94ad5d85cda79f20365 | Fee from Hello Magazine. (Registered 7 September 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-03-24 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-03-24-1f359ece-10465-0 |
f3f087727df3d7f2a7bbc5d425ec8375463ba9b6 | Fee from Hello Magazine. (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 | 0 | 2006-05-12-1f359ece-10465-0 |
88cd58ad18ddcf468be4c52904b19d4dd780d65e | Fee from Hello Magazine. (Registered 7 September 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-06-21 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-06-21-1f359ece-10465-0 |
d6e655ed64773ed973b32b3f330653bf2f3ad541 | Fee from Hello Magazine. (Registered 7 September 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-07-25 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-07-25-1f359ece-10465-0 |
65806b064305ccda876d57fb688eef0a1b319e08 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2006-09-19 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-09-19-ead1ca87-10465-0 |
8f39cd010a3175022368be4872f166ea11f1c06c | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2006-09-19 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-09-19-1f359ece-10465-0 |
fbe92f7c5ef6b1b72bdc0eec8dc7abf2b982843b | 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 | 2006-09-19 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-09-19-84642823-10465-0 |
51edc060b61eb3a8c1cc3176735a033dd4e58322 | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2006-09-19 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-09-19-3aff2389-10465-0 |
e7dab556bcb19791ac553e7dbd9df391d553de85 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2006-11-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-11-06-ead1ca87-10465-0 |
fd32bd1bbcc75686679d46aa5048d7ba6f36384a | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2006-11-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-11-06-1f359ece-10465-0 |
c2514f0e39fa8a5c372449a591db94a0c235370d | 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 | 2006-11-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-11-06-84642823-10465-0 |
958b22519429668db9f45441f312a73bcc766bbd | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2006-11-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-11-06-3aff2389-10465-0 |
f2d30626470006df7f9da92a0636959ac874f50d | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2006-11-27 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-11-27-ead1ca87-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 |
ea3367361dc41425de98befcb25255c6d475e05c | 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 | 2006-11-27 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-11-27-84642823-10465-0 |
b667dd35e02a9a42b239ca6accf7a5b7b0a47fb0 | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2006-11-27 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-11-27-3aff2389-10465-0 |
971d64eab3a063c132f5430cf268a3862801cd9c | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2006-12-11 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-12-11-ead1ca87-10465-0 |
e6da987a96664807ddf0e3cee703c5bd5a15010b | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-12-11-1f359ece-10465-0 |
42f78249a0b15b31e07bda433ec3eead39fc4581 | 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 | 2006-12-11 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2006-12-11-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 |
78dd4705fd05ad379b31b150a2beefd35cc145cd | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2007-01-09 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-01-09-ead1ca87-10465-0 |
cc4bdd40bf076b925e0178f5377f1f33621388c4 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2007-01-09 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-01-09-1f359ece-10465-0 |
b5e9a7ea2dbdb3483eb5b4b7505e6874902b5586 | 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-09 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-01-09-84642823-10465-0 |
b49bc9ab08d3167083148011d2d9f473b4668d0c | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2007-01-09 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-01-09-3aff2389-10465-0 |
3c3d1e4a02dbff719ec5f415b0b119e82e70b2bf | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2007-01-23 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-01-23-ead1ca87-10465-0 |
f76d6f962de2d16e746b100d28466cab88ec98d2 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2007-01-23 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-01-23-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 |
418a490f58342c88449a17d682aeaa0366465fa3 | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2007-01-23 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-01-23-3aff2389-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 |
6787fd0290f18d0e2b4ce5b2d20ba7fede643b03 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2007-02-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-02-06-1f359ece-10465-0 |
4706b53d5e17bb31a64250803a5003766c6b2943 | 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-02-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-02-06-84642823-10465-0 |
4f5629784cf0d501657d5364f741f31cc3c7a0e3 | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2007-02-06 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-02-06-3aff2389-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 |
cbd86c768d242b4b3042be49ad8540d4e7aed962 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2007-02-27 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-02-27-1f359ece-10465-0 |
8dc262379a0a4da8bfda2766bd3dd7944b856847 | 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-02-27 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-02-27-84642823-10465-0 |
bdbac9d6c753125473486c4b8eca6e8c849a7bc7 | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2007-02-27 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-02-27-3aff2389-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 |
d851d10928b82ae063c4d91c237034b1b2fd9921 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2007-03-13 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-03-13-1f359ece-10465-0 |
6775cd1e44c161881ccd78af37145d4bb772f26b | 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-03-13 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-03-13-84642823-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 |
b16bda0a5bf0f8ab5008fbc448d82fff0f4220d3 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2007-03-26 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-03-26-ead1ca87-10465-0 |
621c19ec30ad0ba289b67d973490b8c5e0114eda | Parliamentary adviser to the Caravan Club of Great Britain. (£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 | 0 | 2007-03-26-1f359ece-10465-0 |
ca1bb6136c1f2ef9b0bbf5eb36ae04cfbdbe345d | 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-03-26 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-03-26-84642823-10465-0 |
b101344c2622465be12e8ee37b7287113e3971a8 | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2007-03-26 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-03-26-3aff2389-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 |
47de9ad1b1e346d046b51ca011d9e4acc377cec5 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2007-05-01 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-05-01-1f359ece-10465-0 |
3c82a92616e352563c0ea27973653af4b91dbdcf | 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-05-01 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-05-01-84642823-10465-0 |
bf4725f8ab5f6b7d869084bb25193a4373e2c8da | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2007-05-01 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-05-01-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 |
b2e439cf7467719707f1be4bc1c3be98ce1f4b97 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2007-05-15 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-05-15-1f359ece-10465-0 |
cbee71495a420adee7bf586fe399fad022cad9c6 | 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-05-15 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-05-15-84642823-10465-0 |
281aa99a4e5a53249308584d097f2fa4c7ecd022 | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2007-05-15 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-05-15-3aff2389-10465-0 |
ff523850f1e2c2a6d4b5c17c6a31bad066703b7a | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2007-06-05 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-06-05-ead1ca87-10465-0 |
3c09da2478b5d8037f6a6a63a396b1ca23129061 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2007-06-05 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-06-05-1f359ece-10465-0 |
774877876cc7b43e2dd21c3ccfed3c6ce33c046e | 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-06-05 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-06-05-84642823-10465-0 |
41d56cc63cef649c3ba4d38ac9e72873fc654181 | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2007-06-05 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-06-05-3aff2389-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 |
863334cc983daf0bf5dbcfd00355cd8a59f9c6a8 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2007-06-19 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-06-19-1f359ece-10465-0 |
cc42dcb3d01af3377e1df1edb092cba1eea85bab | 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-06-19 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-06-19-84642823-10465-0 |
da73a4c7464234d17794d2bc9fb39904ea2910ef | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2007-06-19 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-06-19-3aff2389-10465-0 |
ae28dd7688c3eebef1fd654ed669d23ddcebfcf5 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2007-07-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-07-03-ead1ca87-10465-0 |
bffea8cedbcb8000d9e0f52926e36853032f9b40 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2007-07-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-07-03-1f359ece-10465-0 |
93fd76c74cb70a04feae23363e40635530460a28 | 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-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-07-03-84642823-10465-0 |
d641c97d4171b06fbdf59186b32018c72a69e34b | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2007-07-03 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-07-03-3aff2389-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 |
e774643625b9b1ae45dc56c9453a4464b58a9383 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2007-07-17 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-07-17-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 |
4abed46b5b1c2f89b340d44ba95aca528d431d10 | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2007-07-17 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-07-17-3aff2389-10465-0 |
c2d477410ff34e99d99ff7f7d83c62654ddf3df0 | West European Air Services Ltd; aircraft management services and brokerage for local air charter company. | Remunerated directorships ead1ca87 | 2007-07-30 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-07-30-ead1ca87-10465-0 |
77103368e9f61e0e85d1c36a48e2891f790325e9 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2007-07-30 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-07-30-1f359ece-10465-0 |
e89b0440b31f0140006785c55e0e16f170b0b697 | 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-30 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-07-30-84642823-10465-0 |
e6ff23dea53017901a1de569347d8f360b90ab1e | West European Air Services Ltd. | Registrable shareholdings 3aff2389 | 2007-07-30 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-07-30-3aff2389-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 |
edd5481825d083b98fc96c15f2074f026aa2b4eb | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2007-08-28 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-08-28-1f359ece-10465-0 |
2c926a2acfca4a064d56de1cad007bfb8850d2ed | 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-08-28 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2007-08-28-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");