Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

36 rows where member_id = "uk.org.publicwhip/member/1143" sorted by date descending

View and edit SQL

Suggested facets: item, category_id, date, sort_order, record_id, date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
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
8b72d87a615a6f944218598e49cf821f7c647550 Four appearances on the Wright Stuff television programme for Channel 5 since April 2003. (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 1 2005-04-11-1f359ece-10465-0
4148f4d3d20a62ad1c95e88e6115b5179d46434f May 2004, fee from Hello magazine for interview. (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 2 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
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
59dbfcffb2375936c644472f4a49d4a58aeb1e61 Four appearances on the Wright Stuff television programme for Channel 5 since April 2003. (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 1 2005-01-28-12405e8c-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
3e12d6b63414a27252c7bfb25f5d0597938c5a65 Four appearances on the Wright Stuff television programme for Channel 5 since April 2003. (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 1 2004-12-03-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
5ef4c9aa959420610674b42fbc309ace9f0fcdbe Four appearances on the Wright Stuff television programme for Channel 5 since April 2003. (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 1 2004-10-22-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
3e8aafb35b863c9eca80c24197d0950c503e7218 Four appearances on the Wright Stuff television programme for Channel 5 since April 2003. (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 1 2004-09-08-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
60e0ea00f2160e5007f48841360351298313aee4 Four appearances on the Wright Stuff television programme for Channel 5 since April 2003. (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 1 2004-07-16-1f359ece-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
752512fdab2ce81b68a24c10008bcd7b2965f988 Four appearances on the Wright Stuff television programme for Channel 5 since April 2003. (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 1 2004-05-21-1f359ece-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
6e9549598205ab307f9971244f35f7121d1a3089 Fees for appearing on BBC radio and television programmes. (Up to £5,000) Remunerated employment, office, profession etc 1f359ece 2004-01-31 Lembit Öpik uk.org.publicwhip/member/1143 Lembit Öpik uk.org.publicwhip/person/10465 1 2004-01-31-1f359ece-10465-0
f2c160145aaf5bded94a6e82259198fbc15476f7 Article for Hello! Magazine published on 21 January 2003. (Registered 27 February 2003) Remunerated employment, office, profession etc 1f359ece 2004-01-31 Lembit Öpik uk.org.publicwhip/member/1143 Lembit Öpik uk.org.publicwhip/person/10465 2 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
435bfe837b4833573860c5878aaeece91d27dcdb 18-21 February 2003, to Estonia accompanied by my partner. Flights and accommodation paid for by HTV. (Registered 27 February 2003) Overseas visits 80ef1083 2004-01-31 Lembit Öpik uk.org.publicwhip/member/1143 Lembit Öpik uk.org.publicwhip/person/10465 1 2004-01-31-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
9a7e7068b50e79de38907d4a17cb99180c51f773 Fees for appearing on BBC radio and television programmes. (Up to £5,000) Remunerated employment, office, profession etc 1f359ece 2003-12-04 Lembit Öpik uk.org.publicwhip/member/1143 Lembit Öpik uk.org.publicwhip/person/10465 1 2003-12-04-1f359ece-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
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
c42762c327b13f4e00c9e567ee3e1dd7f0c5e91b 18-21 February 2003, to Estonia accompanied by my partner. Flights and accommodation paid for by HTV. (Registered 27 February 2003) Overseas visits 80ef1083 2003-12-04 Lembit Öpik uk.org.publicwhip/member/1143 Lembit Öpik uk.org.publicwhip/person/10465 1 2003-12-04-80ef1083-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
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
92acf52717e26c4defaf18536e22e8675bac86fc Member of Harris Research Panel. (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2002-05-14 Lembit Öpik uk.org.publicwhip/member/1143 Lembit Öpik uk.org.publicwhip/person/10465 1 2002-05-14-1f359ece-10465-0
e55bcdce515a3eee9b407bf8de9ec92443da268b Fee from BBC for "Have I Got News for You" programme. (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 2 2002-05-14-1f359ece-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
c44b2a76962041e80740faf5dfe576ce338feb0d Payment from BBC for "Late Night Live", 5 Live programmes. (£1-£1,000) (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 4 2002-05-14-1f359ece-10465-0
3d421bdc765a264731e869b830e825727fb97220 Fee for training activity at Luther Pendragon. (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 5 2002-05-14-1f359ece-10465-0
60ec7b058d42dd3ef51ad0cf4735371d69503099 Fee for training activity with Midas Training Solutions Ltd. (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 6 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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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");