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

41 rows where member_id = "uk.org.publicwhip/member/1033" sorted by date descending

View and edit SQL

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

hash item category_id date ▲ member_id person_id sort_order record_id
d8f28774b5b0940d970b04b84a583d90f6c4cc05 Barrister (non-practising). Remunerated employment, office, profession etc 1f359ece 2005-04-11 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2005-04-11-1f359ece-10678-0
84374ff9e30b621ded2878003f52f7b27627d962 Complimentary membership of Home House, Private Members' Club. Gifts, benefits and hospitality (UK) 84642823 2005-04-11 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2005-04-11-84642823-10678-0
3901f2d7d460e10609176c2e10ec8edab362b7b0 A flat in South London from which rental income is received. Land and Property 4f1e6359 2005-04-11 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2005-04-11-4f1e6359-10678-0
3885ccd3afc69663dbeb57796bfbdc68d2cd3eda Barrister (non-practising). Remunerated employment, office, profession etc.. 12405e8c 2005-01-28 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2005-01-28-12405e8c-10678-0
8a27f8a9bb834ef42e30dd09c28841e924ad41ca Complimentary membership of Home House, Private Members' Club. Gifts, benefits and hospitality (UK) 84642823 2005-01-28 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2005-01-28-84642823-10678-0
c3502e6905c07aacb8db75441ebf45dca8ea45ac A flat in South London from which rental income is received. Land and Property 4f1e6359 2005-01-28 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2005-01-28-4f1e6359-10678-0
58a5a2450472e6cbb67f4461f813f6d828239e7e Barrister (non-practising). Remunerated employment, office, profession etc 1f359ece 2004-12-03 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-12-03-1f359ece-10678-0
2aa86653f0da17d69569a45768e4c295811cd7e7 Complimentary membership of Home House, Private Members' Club. Gifts, benefits and hospitality (UK) 84642823 2004-12-03 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-12-03-84642823-10678-0
51d27af03ad4cec8551496854cc11fdc33b7dd13 A flat in South London from which rental income is received. Land and Property 4f1e6359 2004-12-03 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-12-03-4f1e6359-10678-0
bbbc9f9e0999b90c8e78b82a855a0333e9e6c192 Barrister (non-practising). Remunerated employment, office, profession etc 1f359ece 2004-10-22 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-10-22-1f359ece-10678-0
b6899c97338e2cce9ba3c39ae8de89d411b73ff3 Complimentary membership of Home House, Private Members' Club. Gifts, benefits and hospitality (UK) 84642823 2004-10-22 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-10-22-84642823-10678-0
383de8072be416477fe8a2ecdaff7c693b6cb5ed A flat in South London from which rental income is received. Land and Property 4f1e6359 2004-10-22 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-10-22-4f1e6359-10678-0
8563d6bf962fe3991119ceb02025124bd19d92ae Barrister (non-practising). Remunerated employment, office, profession etc 1f359ece 2004-09-08 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-09-08-1f359ece-10678-0
af83e0cf9c5076951c7498aca1b58602172a9763 Complimentary membership of Home House, Private Members' Club. Gifts, benefits and hospitality (UK) 84642823 2004-09-08 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-09-08-84642823-10678-0
a822edd836c7ff52d2d5a115d3dabc8b1b38b6c8 A flat in South London from which rental income is received. Land and Property 4f1e6359 2004-09-08 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-09-08-4f1e6359-10678-0
5aceccc90cb168a4c3d410d2af224c2344260de9 Barrister (non-practising). Remunerated employment, office, profession etc 1f359ece 2004-07-16 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-07-16-1f359ece-10678-0
1518b005f0ebe65436b3bffe467cad9bdd54c522 Complimentary membership of Home House, Private Members' Club. Gifts, benefits and hospitality (UK) 84642823 2004-07-16 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-07-16-84642823-10678-0
bc566799051d285c45df78af71c97c31fe8ff295 A flat in South London from which rental income is received. Land and Property 4f1e6359 2004-07-16 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-07-16-4f1e6359-10678-0
1f4e1627e65c8862e732a6c87345bca304a98910 Barrister (non-practising). Remunerated employment, office, profession etc 1f359ece 2004-05-21 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-05-21-1f359ece-10678-0
798f1d299d500a77f4b6c452c4d9d5efb1ba707a Complimentary membership of Home House, Private Members' Club. (Registered 8 July 2003) Gifts, benefits and hospitality (UK) 84642823 2004-05-21 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-05-21-84642823-10678-0
380bf842d18051f56ff399a21105159ed5df68f3 31 October-8 November 2002, to New Zealand as the guest of the Independent Schools of New Zealand (ISNZ) and the British Council. The cost of my airfare and accommodation were covered by the British Council and the ISNZ. (Registered 6 December 2002) Overseas visits 80ef1083 2004-05-21 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-05-21-80ef1083-10678-0
4d5de9525923f561114441bcbe559c67ad82ac44 A flat in South London from which rental income is received. Land and Property 4f1e6359 2004-05-21 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-05-21-4f1e6359-10678-0
46dfc916267cc4bd40fabfcf8d6f9a6362f27849 Barrister (non-practising). Remunerated employment, office, profession etc 1f359ece 2004-01-31 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-01-31-1f359ece-10678-0
4abfb3488e43af973c119c9dd4aa23adfd151308 Complimentary membership of Home House, Private Members' Club. (Registered 8 July 2003) Gifts, benefits and hospitality (UK) 84642823 2004-01-31 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-01-31-84642823-10678-0
924ba01a7b3fd2a119f20197f28b590550e42d6e 31 October-8 November 2002, to New Zealand as the guest of the Independent Schools of New Zealand (ISNZ) and the British Council. The cost of my airfare and accommodation were covered by the British Council and the ISNZ. (Registered 6 December 2002) Overseas visits 80ef1083 2004-01-31 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-01-31-80ef1083-10678-0
1fa3ea5d421f8ec49c6f5ec7686d9f3943ba2736 A flat in South London from which rental income is received. Land and Property 4f1e6359 2004-01-31 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2004-01-31-4f1e6359-10678-0
75a4d6e13f99249c0db80ffe80ee8a300b749ca2 Barrister (non-practising). Remunerated employment, office, profession etc 1f359ece 2003-12-04 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2003-12-04-1f359ece-10678-0
9ba759a3cc4fa3c7ec2714a69a36d52f112cb121 Complimentary membership of Home House, Private Members' Club. (Registered 8 July 2003) Gifts, benefits and hospitality (UK) 84642823 2003-12-04 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2003-12-04-84642823-10678-0
dd45ecc7dc0894ad781b9570c5968c369e88c559 31 October-8 November 2002, to New Zealand as the guest of the Independent Schools of New Zealand (ISNZ) and the British Council. The cost of my airfare and accommodation were covered by the British Council and the ISNZ. (Registered 6 December 2002) Overseas visits 80ef1083 2003-12-04 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2003-12-04-80ef1083-10678-0
bf546d081881c8087c17531e89a6f251eb45b5b5 A flat in South London from which rental income is received. Land and Property 4f1e6359 2003-12-04 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2003-12-04-4f1e6359-10678-0
0601469656508cbed242344f6fb18d31bebb2297 Barrister (non-practising). Remunerated employment, office, profession etc 1f359ece 2002-11-26 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2002-11-26-1f359ece-10678-0
1ca6bb76e8b028f10535cbe6f56be26e209f1a7e Barrister (non-practising). Remunerated employment, office, profession etc 1f359ece 2002-05-14 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2002-05-14-1f359ece-10678-0
ebbd4231dfca0a57f56c5a42ad86cd59eef5169e Adviser on marketing to D J Freeman, Solicitors. Remunerated employment, office, profession etc 1f359ece 2002-05-14 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 1 2002-05-14-1f359ece-10678-0
831fcd46865c285333e7f95e4a05c1a5709c8ffa Research assistant provided by the Jack and Pat Mallabar Foundation. Sponsorship or financial or material support 9e46def6 2002-05-14 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2002-05-14-9e46def6-10678-0
e9c8e7eaeda8a67a5c0583453d225c4648accaa7 Two tickets and hospitality provided by Tottenham Hotspur Football Club. (Registered 20 November 2001) Gifts, benefits and hospitality (UK) 84642823 2002-05-14 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2002-05-14-84642823-10678-0
305c088e9464e17f0d43d8e40ed79884a18fc6ee 1-7 August 2001, to the Congo with the All-Party Parliamentary Group on the Great Lakes Region, paid for by Christian Aid, Oxfam and Save the Children. (Registered 10 October 2001) Overseas visits 80ef1083 2002-05-14 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2002-05-14-80ef1083-10678-0
f6b58823e82ef5f4a12ba65733cd1628db5ba296 13-22 August 2001, to Sierra Leone as a Trustee of ActionAid, paid for by ActionAid. (Registered 10 October 2001) Overseas visits 80ef1083 2002-05-14 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 1 2002-05-14-80ef1083-10678-0
a51b13e684b3458fba8284bb095336dc86f9e403 1 November 2001, to Auschwitz, Poland for one day with students from schools across the country, paid for by the Holocaust Educational Trust. (Registered 8 November 2001) Overseas visits 80ef1083 2002-05-14 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 2 2002-05-14-80ef1083-10678-0
75b37e7fcae58d20e0021975203dc74b6d805cbc Director, Central Board of Finance of the Church of England. Miscellaneous and unremunerated interests 265f2269 2002-05-14 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 0 2002-05-14-265f2269-10678-0
1150787bfae92663fbc033228bda48f6522e3399 Trustee, ActionAid. Miscellaneous and unremunerated interests 265f2269 2002-05-14 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 1 2002-05-14-265f2269-10678-0
ddfefdf54b47fff04a5dc1507aed7919660c3525 Trustee, Broadwater Community Centre Trust. Miscellaneous and unremunerated interests 265f2269 2002-05-14 David Lammy uk.org.publicwhip/member/1033 David Lammy uk.org.publicwhip/person/10678 2 2002-05-14-265f2269-10678-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");