items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where member_id = "uk.org.publicwhip/member/678" and person_id = "uk.org.publicwhip/person/10678" sorted by date descending
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|
cf6e5ecdaa9660799d02234241a1dafb05c5d82a | Barrister (non-practising). | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | David Lammy uk.org.publicwhip/member/678 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2001-05-14-1f359ece-10678-0 |
fb184f3f446fbd85298d709e7a8513d3c004bb42 | Adviser on marketing to D J Freeman, Solicitors. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | David Lammy uk.org.publicwhip/member/678 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2001-05-14-1f359ece-10678-0 |
074dd79c58ffbe88cba4cc3eb1327a9b2ca80b51 | Research assistant provided by the Jack and Pat Mallabar Foundation. | Sponsorship or financial or material support 9e46def6 | 2001-05-14 | David Lammy uk.org.publicwhip/member/678 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2001-05-14-9e46def6-10678-0 |
5049cae760f1f8d7a1b62f9dba66ef6a18cfb5c7 | Two tickets and hospitality provided by Tottenham Hotspur Football Club. (Registered 13 February 2001) | Gifts, benefits and hospitality (UK) 84642823 | 2001-05-14 | David Lammy uk.org.publicwhip/member/678 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2001-05-14-84642823-10678-0 |
5e76b679a644881c52df17b1cd8ab6fb52776f5b | 23 July-2 August 2000, to Kenya, Rwanda, Burundi and Tanzania, on a fact-finding visit with the All-Party Parliamentary Group on the Great Lakes Region, paid for by Christian Aid. (Registered 20 September 2000) | Overseas visits 80ef1083 | 2001-05-14 | David Lammy uk.org.publicwhip/member/678 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2001-05-14-80ef1083-10678-0 |
ef2b6c28833737fcdd05cad16983eba6e948c7d5 | Director, Central Board of Finance of the Church of England. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lammy uk.org.publicwhip/member/678 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2001-05-14-265f2269-10678-0 |
70edbb6ec7e5383f1d7f7300ad3046b16a2273c1 | Trustee, Action Aid. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lammy uk.org.publicwhip/member/678 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2001-05-14-265f2269-10678-0 |
e2041817c0cecdb88d69aa4634fa5b076231c625 | Trustee, Broadwater Community Centre Trust. | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | David Lammy uk.org.publicwhip/member/678 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2001-05-14-265f2269-10678-0 |
c341113b933752b6384b6c5d867b5638f84a7064 | Barrister (non-practising). | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | David Lammy uk.org.publicwhip/member/678 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2000-11-10-1f359ece-10678-0 |
1d96900f73031f23e7e736a89a2e80e7e85aad35 | Adviser on marketing to D J Freeman, Solicitors. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | David Lammy uk.org.publicwhip/member/678 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2000-11-10-1f359ece-10678-0 |
61bd8da92f9a6a27d40432ead0f3c6011f0ba5c5 | 23 July-2 August 2000, to Kenya, Rwanda, Burundi and Tanzania, on a fact-finding visit with the All-Party Parliamentary Group on the Great Lakes Region, paid for by Christian Aid. (Registered 20 September 2000) | Overseas visits 80ef1083 | 2000-11-10 | David Lammy uk.org.publicwhip/member/678 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2000-11-10-80ef1083-10678-0 |
65349beedb8eaac622be1d1c57ac810c7347e114 | Director, Central Board of Finance of the Church of England. | Miscellaneous and unremunerated interests 265f2269 | 2000-11-10 | David Lammy uk.org.publicwhip/member/678 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2000-11-10-265f2269-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");