items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
25 rows where member_id = "uk.org.publicwhip/member/1127" 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 |
---|---|---|---|---|---|---|---|
cbe2c524f48ec0f7cebe107cfe389a534d5abe61 | Royalties and film rights from four books written between 1982-7. | Remunerated employment, office, profession, etc. f3967f4d | 2005-04-11 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2005-04-11-f3967f4d-10451-0 |
fad0a897aad449f2bb4724f8168e96fa1df0bd78 | Income from rent on two flats, in London and Sunderland. | Land and Property 4f1e6359 | 2005-04-11 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2005-04-11-4f1e6359-10451-0 |
05033c80982fdc0bab189b229cb73fe350155268 | Royalties and film rights from four books written between 1982-7. | Remunerated employment, office, profession, etc.. dc69d097 | 2005-01-28 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2005-01-28-dc69d097-10451-0 |
ab2c98f3a239fdba76a91c2f1b9e6e93a258a8f2 | Income from rent on two flats, in London and Sunderland. | Land and Property 4f1e6359 | 2005-01-28 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2005-01-28-4f1e6359-10451-0 |
6e41f00d37618bb1719b901f91637a0c8ff3b88b | Royalties and film rights from four books written between 1982-7. | Remunerated employment, office, profession, etc. f3967f4d | 2004-12-03 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2004-12-03-f3967f4d-10451-0 |
a4a5df11108210b83317df33740b63c5125e7105 | Income from rent on two flats, in Kennington, London, and Sunderland. | Land and Property 4f1e6359 | 2004-12-03 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2004-12-03-4f1e6359-10451-0 |
23410f4c089b16a7084c10e1d4909bc6ba4f7434 | Royalties and film rights from four books written between 1982-7. | Remunerated employment, office, profession, etc. f3967f4d | 2004-10-22 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2004-10-22-f3967f4d-10451-0 |
b4770c33ee3801341ff1ba5b77c74cfea395c015 | Income from rent on two flats, in Kennington, London, and Sunderland. | Land and Property 4f1e6359 | 2004-10-22 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2004-10-22-4f1e6359-10451-0 |
d6570adb380cceef8e818d50ad7b8485307a5d3e | Royalties and film rights from four books written between 1982-7. | Remunerated employment, office, profession, etc. f3967f4d | 2004-09-08 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2004-09-08-f3967f4d-10451-0 |
f33c8b762dc45431bde4883c152fe026b942de33 | Income from rent on two flats, in Kennington, London, and Sunderland. | Land and Property 4f1e6359 | 2004-09-08 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2004-09-08-4f1e6359-10451-0 |
b43e495ed2b8aaada27db3b230472fba4c4f3b9b | Royalties and film rights from four books written between 1982-7. | Remunerated employment, office, profession, etc. f3967f4d | 2004-07-16 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2004-07-16-f3967f4d-10451-0 |
93f84771cc2cc4df2c9a9317b3c2e3cdcaff4414 | Income from rent on two flats, in Kennington, London, and Sunderland. | Land and Property 4f1e6359 | 2004-07-16 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2004-07-16-4f1e6359-10451-0 |
2e1abfe756277a33332d7d975d150ba38a650fa2 | Royalties and film rights from four books written between 1982-7. | Remunerated employment, office, profession, etc. f3967f4d | 2004-05-21 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2004-05-21-f3967f4d-10451-0 |
cef20664bbe946c181176347ff0185ed47b88484 | Income from rent on two flats, in Kennington, London, and Sunderland. | Land and Property 4f1e6359 | 2004-05-21 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2004-05-21-4f1e6359-10451-0 |
0e3b40eca2bb8e9330e0676f1b81ee8f270335ab | Royalties and film rights from four books written between 1982-7. | Remunerated employment, office, profession, etc. f3967f4d | 2004-01-31 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2004-01-31-f3967f4d-10451-0 |
53f099444a2098564603dade67028c58882dad27 | Royalties and film rights from four books written between 1982-7. | Remunerated employment, office, profession, etc. f3967f4d | 2003-12-04 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2003-12-04-f3967f4d-10451-0 |
69ce9aade5fdf6fb32f5751a44e051727e447e25 | Fortnightly column in the Sunderland Echo, who pay me £1,000 pa. (Up to £5,000) | Remunerated employment, office, profession, etc. f3967f4d | 2003-12-04 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 1 | 2003-12-04-f3967f4d-10451-0 |
2369669223103e83bf40044e3525040e65900bab | Royalties and film rights from four books written between 1982-7. | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2002-11-26-1f359ece-10451-0 |
be11058351760b5e10691f5c3ca6bd1db84d5244 | Fortnightly column in the Sunderland Echo. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 1 | 2002-11-26-1f359ece-10451-0 |
4d120138303fb0ac424a95327656132e63097540 | 18-22 September 2002, to Portugal, to attend a conference on European drug policy organised by the Network of European Foundations which was responsible for travel and expenses. (Registered 23 September 2002) | Overseas visits 80ef1083 | 2002-11-26 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2002-11-26-80ef1083-10451-0 |
e2dc09f26d7b72e5154512f01dfa3bc2fe18d8c2 | Journalist and author: | Remunerated employment, office, profession, etc. f3967f4d | 2002-05-14 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2002-05-14-f3967f4d-10451-0 |
5dc94aa8365a03d55e86546da1f67b437cb1fd83 | Occasional income from newspaper articles. | Remunerated employment, office, profession, etc. f3967f4d | 2002-05-14 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 1 | 2002-05-14-f3967f4d-10451-0 |
d885add457cb2a610aaf8bdd3dc24685a2102ab4 | Royalties and film rights from four books written between 1982-7. | Remunerated employment, office, profession, etc. f3967f4d | 2002-05-14 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 2 | 2002-05-14-f3967f4d-10451-0 |
9b00f1cf78d3f62895125653b655b3f9adbb5613 | Weekly column (except during summer recess) in the Sunderland Echo. (£1,001-£5,000) | Remunerated employment, office, profession, etc. f3967f4d | 2002-05-14 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 3 | 2002-05-14-f3967f4d-10451-0 |
e3ee3bb3e7a27d1cd9d59f5486f16159a6c6e97c | One bedroom flat in Sunderland from which a rental income is received. | Land and Property 4f1e6359 | 2002-05-14 | Chris Mullin uk.org.publicwhip/member/1127 | Chris Mullin uk.org.publicwhip/person/10451 | 0 | 2002-05-14-4f1e6359-10451-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");