items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
41 rows where member_id = "uk.org.publicwhip/member/1033" sorted by person_id
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, sort_order
date (date) 11 ✖
- 2002-05-14 10
- 2003-12-04 4
- 2004-01-31 4
- 2004-05-21 4
- 2004-07-16 3
- 2004-09-08 3
- 2004-10-22 3
- 2004-12-03 3
- 2005-01-28 3
- 2005-04-11 3
- 2002-11-26 1
hash | item | category_id | date | member_id | person_id ▼ | sort_order | record_id |
---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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");