items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where person_id = "uk.org.publicwhip/person/10291" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, member_id, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
f4a22a12099ed115591ccec9caf988fa2e173c4c | (b) Shell Transport and Trading Company PLC. | Registrable shareholdings 3aff2389 | 2005-01-28 | Alan Howarth uk.org.publicwhip/member/975 | Alan Howarth uk.org.publicwhip/person/10291 | 0 | 2005-01-28-3aff2389-10291-0 |
49af43e3bff348b35a55563d362fc9d1615bdee0 | Shell Transport and Trading Company PLC. | Registrable shareholdings 3aff2389 | 2004-12-03 | Alan Howarth uk.org.publicwhip/member/975 | Alan Howarth uk.org.publicwhip/person/10291 | 0 | 2004-12-03-3aff2389-10291-0 |
0ad82e1da01a0247f198cc949f82d513a89da225 | Shell Transport and Trading Company PLC. | Registrable shareholdings 3aff2389 | 2004-10-22 | Alan Howarth uk.org.publicwhip/member/975 | Alan Howarth uk.org.publicwhip/person/10291 | 0 | 2004-10-22-3aff2389-10291-0 |
7285655fe1c7b99d2ecc59c5c66c5e052c191857 | Shell Transport and Trading Company PLC. | Registrable shareholdings 3aff2389 | 2004-09-08 | Alan Howarth uk.org.publicwhip/member/975 | Alan Howarth uk.org.publicwhip/person/10291 | 0 | 2004-09-08-3aff2389-10291-0 |
c83d1bde541e27517323cc84d5301945b0d509ef | Shell Transport and Trading Company PLC. | Registrable shareholdings 3aff2389 | 2004-07-16 | Alan Howarth uk.org.publicwhip/member/975 | Alan Howarth uk.org.publicwhip/person/10291 | 0 | 2004-07-16-3aff2389-10291-0 |
f35fc32487a220e498a2821a0ac919e8dd4ad1ba | Shell Transport and Trading Company PLC. | Registrable shareholdings 3aff2389 | 2004-05-21 | Alan Howarth uk.org.publicwhip/member/975 | Alan Howarth uk.org.publicwhip/person/10291 | 0 | 2004-05-21-3aff2389-10291-0 |
4e7e9428a47f48767b3d15c2a46aad6f8eb111a7 | Shell Transport and Trading Company PLC. | Registrable shareholdings 3aff2389 | 2004-01-31 | Alan Howarth uk.org.publicwhip/member/975 | Alan Howarth uk.org.publicwhip/person/10291 | 0 | 2004-01-31-3aff2389-10291-0 |
ead7f6a464b036928aed296d5e1061e679a77fe3 | Shell Transport and Trading Company PLC. | Registrable shareholdings 3aff2389 | 2003-12-04 | Alan Howarth uk.org.publicwhip/member/975 | Alan Howarth uk.org.publicwhip/person/10291 | 0 | 2003-12-04-3aff2389-10291-0 |
0a2aa6fea5970329657b9030b1ee5e6bae1cf78b | Member of Lloyd's. Ceased active underwriting on 31 December 1998. | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | Alan Howarth uk.org.publicwhip/member/975 | Alan Howarth uk.org.publicwhip/person/10291 | 0 | 2002-11-26-1f359ece-10291-0 |
09119b432e987606f90eabfec999fb5eb818059f | All categories of business underwritten. | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | Alan Howarth uk.org.publicwhip/member/975 | Alan Howarth uk.org.publicwhip/person/10291 | 1 | 2002-11-26-1f359ece-10291-0 |
40869831476e10273160f2ee3eda42e6d775a04e | Shell Transport and Trading Company PLC. | Registrable shareholdings 3aff2389 | 2002-11-26 | Alan Howarth uk.org.publicwhip/member/975 | Alan Howarth uk.org.publicwhip/person/10291 | 0 | 2002-11-26-3aff2389-10291-0 |
9aa52b50d52f9c5e29fdc46986e7322dfa612ad6 | Member of Lloyd's. Ceased active underwriting on 31 December 1998. | Remunerated employment, office, profession, etc. f3967f4d | 2002-05-14 | Alan Howarth uk.org.publicwhip/member/975 | Alan Howarth uk.org.publicwhip/person/10291 | 0 | 2002-05-14-f3967f4d-10291-0 |
b14c9d680fa73aeb0eb469b0ccafbd73887f4ce9 | All categories of business underwritten. | Remunerated employment, office, profession, etc. f3967f4d | 2002-05-14 | Alan Howarth uk.org.publicwhip/member/975 | Alan Howarth uk.org.publicwhip/person/10291 | 1 | 2002-05-14-f3967f4d-10291-0 |
749d39a858de7c5bba636ecec4abf6b99ae1512b | In my capacity as Minister for the Arts, between July 1998 and June 2001, I received many invitations to attend cultural events and the value of the hospitality extended to me by some organisations may have exceeded £250. | Gifts, benefits and hospitality (UK) 84642823 | 2002-05-14 | Alan Howarth uk.org.publicwhip/member/975 | Alan Howarth uk.org.publicwhip/person/10291 | 0 | 2002-05-14-84642823-10291-0 |
017b4799efc91704f3245c4211f621e9fc071ee7 | Member of Lloyd's (resigned 31 December 1998, three open years of account). | Remunerated employment, office, profession, etc. f3967f4d | 2001-05-14 | Alan Howarth uk.org.publicwhip/member/291 | Alan Howarth uk.org.publicwhip/person/10291 | 0 | 2001-05-14-f3967f4d-10291-0 |
282e9ece7ce85fb5df61340670df60cb11077a03 | All categories of business underwritten. | Remunerated employment, office, profession, etc. f3967f4d | 2001-05-14 | Alan Howarth uk.org.publicwhip/member/291 | Alan Howarth uk.org.publicwhip/person/10291 | 1 | 2001-05-14-f3967f4d-10291-0 |
3688320a67590dd0e15469464806ed28cb5f6c93 | In my capacity as Minister for the Arts I receive frequent invitations to attend arts and other cultural events and the value of the hospitality extended to me on some of these occasions may occasionally be greater than £235. | Gifts, benefits and hospitality (UK) 84642823 | 2001-05-14 | Alan Howarth uk.org.publicwhip/member/291 | Alan Howarth uk.org.publicwhip/person/10291 | 0 | 2001-05-14-84642823-10291-0 |
d679573c1cf56ab6b2fb3963a5f6fb3966ad4365 | Member of Lloyd's (resigned 31 December 1998, three open years of account). | Remunerated employment, office, profession, etc. f3967f4d | 2000-11-10 | Alan Howarth uk.org.publicwhip/member/291 | Alan Howarth uk.org.publicwhip/person/10291 | 0 | 2000-11-10-f3967f4d-10291-0 |
dcbcb5392e739ef0e039119b0656fe47d026abed | All categories of business underwritten. | Remunerated employment, office, profession, etc. f3967f4d | 2000-11-10 | Alan Howarth uk.org.publicwhip/member/291 | Alan Howarth uk.org.publicwhip/person/10291 | 1 | 2000-11-10-f3967f4d-10291-0 |
a32a19448fa7d84b3de951f199e3e09215ce1cf3 | In my capacity as Minister for the Arts I receive frequent invitations to attend arts and other cultural events and the value of the hospitality extended to me on some of these occasions may occasionally be greater than £235. | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Alan Howarth uk.org.publicwhip/member/291 | Alan Howarth uk.org.publicwhip/person/10291 | 0 | 2000-11-10-84642823-10291-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");