items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where member_id = "uk.org.publicwhip/member/1045" 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 |
---|---|---|---|---|---|---|---|
c2750d897f7df4e5082fe9db8751b3d3a01edec8 | 8 January 2004, dinner and hospitality on board ship provided to me and a guest by Cunard on the occasion of the naming ceremony for the Queen Mary 2. (Registered 10 January 2004) | Gifts, benefits and hospitality (UK) 84642823 | 2004-12-03 | Julian Lewis uk.org.publicwhip/member/1045 | Julian Lewis uk.org.publicwhip/person/10358 | 0 | 2004-12-03-84642823-10358-0 |
15acf843719aaa67879ffb805867a7529dcc987e | 8 January 2004, dinner and hospitality on board ship provided to me and a guest by Cunard on the occasion of the naming ceremony for the Queen Mary 2. (Registered 10 January 2004) | Gifts, benefits and hospitality (UK) 84642823 | 2004-10-22 | Julian Lewis uk.org.publicwhip/member/1045 | Julian Lewis uk.org.publicwhip/person/10358 | 0 | 2004-10-22-84642823-10358-0 |
381046b512084924714b367ad1b473660534123b | 8 January 2004, dinner and hospitality on board ship provided to me and a guest by Cunard on the occasion of the naming ceremony for the Queen Mary 2. (Registered 10 January 2004) | Gifts, benefits and hospitality (UK) 84642823 | 2004-09-08 | Julian Lewis uk.org.publicwhip/member/1045 | Julian Lewis uk.org.publicwhip/person/10358 | 0 | 2004-09-08-84642823-10358-0 |
51053bc025b065494fcc43d731cfa4954305e334 | 8 January 2004, dinner and hospitality on board ship provided to me and a guest by Cunard on the occasion of the naming ceremony for the Queen Mary 2. (Registered 10 January 2004) | Gifts, benefits and hospitality (UK) 84642823 | 2004-07-16 | Julian Lewis uk.org.publicwhip/member/1045 | Julian Lewis uk.org.publicwhip/person/10358 | 0 | 2004-07-16-84642823-10358-0 |
64a7a2edc463df328290f9e65b3edca145b2dce1 | 8 January 2004, dinner and hospitality on board ship provided to me and a guest by Cunard on the occasion of the naming ceremony for the Queen Mary 2. (Registered 10 January 2004) | Gifts, benefits and hospitality (UK) 84642823 | 2004-05-21 | Julian Lewis uk.org.publicwhip/member/1045 | Julian Lewis uk.org.publicwhip/person/10358 | 0 | 2004-05-21-84642823-10358-0 |
db9e2223156ec307e851b5a1abc5718398031768 | Commonhold flat in Finchley, London N12, formerly my home | Land and Property 4f1e6359 | 2004-05-21 | Julian Lewis uk.org.publicwhip/member/1045 | Julian Lewis uk.org.publicwhip/person/10358 | 0 | 2004-05-21-4f1e6359-10358-0 |
fbe88195c3dd44f6c5d223b0ec2bee8420900394 | 8 January 2004, dinner and hospitality on board ship provided to me and a guest by Cunard on the occasion of the naming ceremony for the Queen Mary 2. (Registered 10 January 2004) | Gifts, benefits and hospitality (UK) 84642823 | 2004-01-31 | Julian Lewis uk.org.publicwhip/member/1045 | Julian Lewis uk.org.publicwhip/person/10358 | 0 | 2004-01-31-84642823-10358-0 |
76baef27308b99b8897e9398f6cd12d6588ee85f | Commonhold flat in Finchley, London N12, formerly my home. | Land and Property 4f1e6359 | 2004-01-31 | Julian Lewis uk.org.publicwhip/member/1045 | Julian Lewis uk.org.publicwhip/person/10358 | 0 | 2004-01-31-4f1e6359-10358-0 |
1a7ee8302b7605b5e84301ea4d2df88ffb9b2d66 | Commonhold flat in Finchley, London N12, formerly my home, now let to tenants. | Land and Property 4f1e6359 | 2003-12-04 | Julian Lewis uk.org.publicwhip/member/1045 | Julian Lewis uk.org.publicwhip/person/10358 | 0 | 2003-12-04-4f1e6359-10358-0 |
eaf1ec6e3c999ef5f46a870846a23fd6524c4884 | Commonhold flat in Finchley, London N12, formerly my home, now let to tenants. | Land and Property 4f1e6359 | 2002-11-26 | Julian Lewis uk.org.publicwhip/member/1045 | Julian Lewis uk.org.publicwhip/person/10358 | 0 | 2002-11-26-4f1e6359-10358-0 |
16bd828f774c0dd46e48e1af66ef170bf5a27443 | Occasional fees for media appearances and press articles. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Julian Lewis uk.org.publicwhip/member/1045 | Julian Lewis uk.org.publicwhip/person/10358 | 0 | 2002-05-14-1f359ece-10358-0 |
861b678aff07fdacb7ee9e363403d7b134b70cae | I receive a complimentary car parking pass from South West Trains (valid until June 2003). (Registered 12 July 2001) | Gifts, benefits and hospitality (UK) 84642823 | 2002-05-14 | Julian Lewis uk.org.publicwhip/member/1045 | Julian Lewis uk.org.publicwhip/person/10358 | 0 | 2002-05-14-84642823-10358-0 |
5f539cc69689827b51fb47f908c0fef7bbc17e00 | Leasehold flat in Finchley, London N12, formerly my home, now let to tenants. | Land and Property 4f1e6359 | 2002-05-14 | Julian Lewis uk.org.publicwhip/member/1045 | Julian Lewis uk.org.publicwhip/person/10358 | 0 | 2002-05-14-4f1e6359-10358-0 |
ce700ab282bdfc7b1b9ade7a2830902fcf18ea4b | Policy Research Associates Ltd. (non-trading company). | Registrable shareholdings 3aff2389 | 2002-05-14 | Julian Lewis uk.org.publicwhip/member/1045 | Julian Lewis uk.org.publicwhip/person/10358 | 0 | 2002-05-14-3aff2389-10358-0 |
7b37ce498456ce5d75021b53897d889ff141d3d7 | Policy Research Publications Ltd. (non-trading company). | Registrable shareholdings 3aff2389 | 2002-05-14 | Julian Lewis uk.org.publicwhip/member/1045 | Julian Lewis uk.org.publicwhip/person/10358 | 1 | 2002-05-14-3aff2389-10358-0 |
ae1f2211da2c4786f61a8618d6d5a3ec9d8244cc | Unremunerated director of Policy Research Associates Ltd. and Policy Research Publications Ltd. | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Julian Lewis uk.org.publicwhip/member/1045 | Julian Lewis uk.org.publicwhip/person/10358 | 0 | 2002-05-14-265f2269-10358-0 |
3f1dc43bff55a96523c751ec73d5e7d60225d28d | Trustee (unremunerated) of the British Military Powerboat Trust. | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Julian Lewis uk.org.publicwhip/member/1045 | Julian Lewis uk.org.publicwhip/person/10358 | 1 | 2002-05-14-265f2269-10358-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");