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

26 rows where member_id = "uk.org.publicwhip/member/1050" 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
754ac5b641dfbcbca92d110e0805cb725d360009 JP Morgan Fleming Claverhouse Investment Trust PLC; investment in UK equities. Remunerated directorships ead1ca87 2005-04-11 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 0 2005-04-11-ead1ca87-10362-0
b37ffa824fadc0e619449d6383280b7a21edd993 i-documentsystem group plc (non-executive); document management software and systems (from 31 October 2002). Remunerated directorships ead1ca87 2005-04-11 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 1 2005-04-11-ead1ca87-10362-0
df821b402462b074fdb35b82749b6bb665040747 JP Morgan Fleming Claverhouse Investment Trust PLC; investment in UK equities. Remunerated directorships ead1ca87 2005-01-28 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 0 2005-01-28-ead1ca87-10362-0
ca46b3db617cae7dd88947c74bdb8781f799c34c i-documentsystem group plc (non-executive); document management software and systems (from 31 October 2002). Remunerated directorships ead1ca87 2005-01-28 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 1 2005-01-28-ead1ca87-10362-0
d4aea1e26ffccb7308b29dfc89a5f72cc38f56ba JP Morgan Fleming Claverhouse Investment Trust PLC; investment in UK equities. Remunerated directorships ead1ca87 2004-12-03 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 0 2004-12-03-ead1ca87-10362-0
376b68614d1b4d89e74feb1ae2c3a945d06a37cb i-documentsystem group plc (non-executive); document management software and systems (from 31 October 2002). Remunerated directorships ead1ca87 2004-12-03 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 1 2004-12-03-ead1ca87-10362-0
ba6e092c2e8ee54d141a67c31a96e4a3372f8977 JP Morgan Fleming Claverhouse Investment Trust PLC; investment in UK equities. Remunerated directorships ead1ca87 2004-10-22 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 0 2004-10-22-ead1ca87-10362-0
9d29788de8184b39d7c0ef22cf306520a22be1c8 i-documentsystem group plc (non-executive); document management software and systems (from 31 October 2002). Remunerated directorships ead1ca87 2004-10-22 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 1 2004-10-22-ead1ca87-10362-0
662d8aea071112e8d3068f8695530e71d97ddbc4 JP Morgan Fleming Claverhouse Investment Trust PLC; investment in UK equities. Remunerated directorships ead1ca87 2004-09-08 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 0 2004-09-08-ead1ca87-10362-0
722081396fb2b87d50b0d146e11f196eb4b20cd9 i-documentsystem group plc (non-executive); document management software and systems (from 31 October 2002). Remunerated directorships ead1ca87 2004-09-08 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 1 2004-09-08-ead1ca87-10362-0
9b15d42da9539fcfbf649a19832122b11df1530d JP Morgan Fleming Claverhouse Investment Trust PLC; investment in UK equities. Remunerated directorships ead1ca87 2004-07-16 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 0 2004-07-16-ead1ca87-10362-0
60c3c851d624771f4cf122a15c0e273ffd189370 i-documentsystem group plc (non-executive); document management software and systems (from 31 October 2002). Remunerated directorships ead1ca87 2004-07-16 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 1 2004-07-16-ead1ca87-10362-0
ab8176ba813213c1950d6bdc30978d8f288fa2c5 JP Morgan Fleming Claverhouse Investment Trust PLC; investment in UK equities. Remunerated directorships ead1ca87 2004-05-21 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 0 2004-05-21-ead1ca87-10362-0
7fd7e85ba34d187020c80eedf9e02ad2c2b68094 i-documentsystem group plc (non-executive); document management software and systems (from 31 October 2002). Remunerated directorships ead1ca87 2004-05-21 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 1 2004-05-21-ead1ca87-10362-0
d371fe54aa97e247fbf73634edb7b0c038203f8f JP Morgan Fleming Claverhouse Investment Trust PLC; investment in UK equities. Remunerated directorships ead1ca87 2004-01-31 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 0 2004-01-31-ead1ca87-10362-0
96eb44c463d838bc57b2b899dc06071c308d7f57 i-documentsystem group plc (non-executive); document management software and systems (from 31 October 2002). Remunerated directorships ead1ca87 2004-01-31 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 1 2004-01-31-ead1ca87-10362-0
09272018c69413a26998c7de2f4c41d52cd71aa4 The Fleming Claverhouse Investment Trust PLC; investment in UK equities. Remunerated directorships ead1ca87 2003-12-04 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 0 2003-12-04-ead1ca87-10362-0
816b8894515d8126a8087fd74e7e9f589aba28b9 i-documentsystem group plc (non-executive); document management software and systems (from 31 October 2002). Remunerated directorships ead1ca87 2003-12-04 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 1 2003-12-04-ead1ca87-10362-0
f48e0fe953e445a9f653f3ee182a15392c863a7f The Fleming Claverhouse Investment Trust PLC; investment in UK equities. Remunerated directorships ead1ca87 2002-11-26 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 0 2002-11-26-ead1ca87-10362-0
2ef43b7ecec80b793b3dac8ff863753a3d89290b i-documentsystem group plc (non-executive); document management software and systems (from 31 October 2002). Remunerated directorships ead1ca87 2002-11-26 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 1 2002-11-26-ead1ca87-10362-0
8cc146d1c1573552e01dbbb2fce759a3d6ad1a8a 21-22 May 2002, to France, to make speech on pensions policy. Travel and hotel paid for by Association France-GB. (Registered 19 September 2002) Overseas visits 80ef1083 2002-11-26 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 0 2002-11-26-80ef1083-10362-0
f7f311094d8ca96a711df649bec789b06115f60a 30 August 2002, to France, to make speech on role of state. Travel paid for by MEDEF (Mouvement des Enterprises de France). (Registered 19 September 2002) Overseas visits 80ef1083 2002-11-26 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 1 2002-11-26-80ef1083-10362-0
2085aaaabe917d5b3f750a53a215021d17600e83 2-3 October 2002, to France, to make speech on tax. Travel and hotel paid for by Contribuables Associes. (Registered 19 September) Overseas visits 80ef1083 2002-11-26 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 2 2002-11-26-80ef1083-10362-0
0a7e389a42f60188a57d3ac5b8ed0f67421511dd The Fleming Claverhouse Investment Trust PLC; investment. Remunerated directorships ead1ca87 2002-05-14 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 0 2002-05-14-ead1ca87-10362-0
954f5fcfdef8e185265a01a18a0a39e8f5ddd672 Chairman (non-executive), Sherborne Financial Services; a company providing financial information. Remunerated directorships ead1ca87 2002-05-14 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 1 2002-05-14-ead1ca87-10362-0
4d232ecca6385e9646565ff0a83249f7de85ad76 I receive fees for delivering lectures and speeches, and for broadcasting. Remunerated employment, office, profession etc 1f359ece 2002-05-14 Peter Lilley uk.org.publicwhip/member/1050 Peter Lilley uk.org.publicwhip/person/10362 0 2002-05-14-1f359ece-10362-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");