items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
39 rows where member_id = "uk.org.publicwhip/member/1855" 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 |
|---|---|---|---|---|---|---|---|
| b0d7eb0792c4013800111f1d18255b886b3a9902 | Received fee of £150 for completing survey for Ipsos MORI, 79-81 Borough Road, London, SE1 1FY. Hours: 1.5hrs. Fee donated to charity. (Registered 28 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2010-04-12-1f359ece-10189-0 |
| c742e8e611a056b94bc123953ceae394f1b3194e | ComRes, 4 Millbank, London SW1P 3JA. Fee of £75 received on 24 November 2009. Fee donated to charity. Hours: 35 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 1 | 2010-04-12-1f359ece-10189-0 |
| e43a2487e47e33cd3778270270b0016d9da09047 | Populus, Northburgh House, 10 Northburgh Street, London EC1V 0AT. Fee of £50 received. Fee donated to charity. Hours: 10 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 2 | 2010-04-12-1f359ece-10189-0 |
| 23dad9cd29c837b51b370826fa1a7023600f3f09 | ICM, Berkshire House, 168-173 High Holborn, London WC1V 7AA. Fee of £25 received. Fee donated to charity. Hours: 10 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 3 | 2010-04-12-1f359ece-10189-0 |
| e50edd4aacf4f95b11c5bb8fa200b7cb1c266e95 | Received fee of £150 for completing survey for Ipsos MORI, 79-81 Borough Road, London, SE1 1FY. Hours: 1.5hrs. Fee donated to charity. (Registered 28 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2010-03-24-1f359ece-10189-0 |
| d02442a4ad3c0ea548d3cda27d3a47ba7242d980 | ComRes, 4 Millbank, London SW1P 3JA. Fee of £75 received on 24 November 2009. Fee donated to charity. Hours: 35 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 1 | 2010-03-24-1f359ece-10189-0 |
| c997b3f5d4cd72c81ac24f88aa7e8bd9eb569d2f | Populus, Northburgh House, 10 Northburgh Street, London EC1V 0AT. Fee of £50 received. Fee donated to charity. Hours: 10 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 2 | 2010-03-24-1f359ece-10189-0 |
| 4a6af1ca23253b6badc4cde3a7f1a077271e0345 | ICM, Berkshire House, 168-173 High Holborn, London WC1V 7AA. Fee of £25 received. Fee donated to charity. Hours: 10 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 3 | 2010-03-24-1f359ece-10189-0 |
| a4525d39a29a5d82292ca7edd93f8193feda1c6c | Received fee of £150 for completing survey for Ipsos MORI, 79-81 Borough Road, London, SE1 1FY. Hours: 1.5hrs. Fee donated to charity. (Registered 28 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2010-03-10-1f359ece-10189-0 |
| bdbe5fa45094bd6da0eba4f7abd0d36b0263e6c8 | ComRes, 4 Millbank, London SW1P 3JA. Fee of £75 received on 24 November 2009. Fee donated to charity. Hours: 35 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 1 | 2010-03-10-1f359ece-10189-0 |
| 5438bbd133a5c7c5138d90154aa2a23f8fd94377 | Populus, Northburgh House, 10 Northburgh Street, London EC1V 0AT. Fee of £50 received. Fee donated to charity. Hours: 10 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 2 | 2010-03-10-1f359ece-10189-0 |
| e0b060aeb4a6df4f7aa439675f83dcd50835a189 | ICM, Berkshire House, 168-173 High Holborn, London WC1V 7AA. Fee of £25 received. Fee donated to charity. Hours: 10 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 3 | 2010-03-10-1f359ece-10189-0 |
| 7600768fa4907a100f7c4e2cdf0b5bdd3939996f | Received fee of £150 for completing survey for Ipsos MORI, 79-81 Borough Road, London, SE1 1FY. Hours: 1.5hrs. Fee donated to charity. (Registered 28 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2010-02-24-1f359ece-10189-0 |
| 04f9b68e2571aec8027d23d3fe1e986edfb34e32 | ComRes, 4 Millbank, London SW1P 3JA. Fee of £75 received on 24 November 2009. Fee donated to charity. Hours: 35 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 1 | 2010-02-24-1f359ece-10189-0 |
| b59b4b3e52be975c295fd3f2477c902ab1bbbe3c | Populus, Northburgh House, 10 Northburgh Street, London EC1V 0AT. Fee of £50 received. Fee donated to charity. Hours: 10 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 2 | 2010-02-24-1f359ece-10189-0 |
| 4c3418ba44d3958b1837740bca8db76e884c5269 | ICM, Berkshire House, 168-173 High Holborn, London WC1V 7AA. Fee of £25 received. Fee donated to charity. Hours: 10 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 3 | 2010-02-24-1f359ece-10189-0 |
| 8741028c43ecb41acc1bf07ed5302f09963e5393 | Received fee of £150 for completing survey for Ipsos MORI, 79-81 Borough Road, London, SE1 1FY. Hours: 1.5hrs. Fee donated to charity. (Registered 28 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2010-02-03-1f359ece-10189-0 |
| 8b5651641c699559acb5094994fc06ae0b6b42f5 | ComRes, 4 Millbank, London SW1P 3JA. Fee of £75 received on 24 November 2009. Fee donated to charity. Hours: 35 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 1 | 2010-02-03-1f359ece-10189-0 |
| 4d316fc197ca1e9cdab9b4485729cda1b1f0b284 | Populus, Northburgh House, 10 Northburgh Street, London EC1V 0AT. Fee of £50 received. Fee donated to charity. Hours: 10 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 2 | 2010-02-03-1f359ece-10189-0 |
| 18602de3e8af25446efac193b741cbee048b23a0 | ICM, Berkshire House, 168-173 High Holborn, London WC1V 7AA. Fee of £25 received. Fee donated to charity. Hours: 10 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 3 | 2010-02-03-1f359ece-10189-0 |
| 767273ced157ac1c34301ab2a099c0f72701e588 | Received fee of £150 for completing survey for Ipsos MORI, 79-81 Borough Road, London, SE1 1FY. Hours: 1.5hrs. Fee donated to charity. (Registered 28 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2010-01-06-1f359ece-10189-0 |
| c55f14d326a6494659479f8c03e661c4b2a7d5fd | ComRes, 4 Millbank, London SW1P 3JA. Fee of £75 received on 24 November 2009. Fee donated to charity. Hours: 35 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 1 | 2010-01-06-1f359ece-10189-0 |
| 2452df508a78fb2e542397e881ae1de0f61c6c06 | Populus, Northburgh House, 10 Northburgh Street, London EC1V 0AT. Fee of £50 received. Fee donated to charity. Hours: 10 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 2 | 2010-01-06-1f359ece-10189-0 |
| c58ad5b5b9d27e30cfff18a68b5d07918d774367 | ICM, Berkshire House, 168-173 High Holborn, London WC1V 7AA. Fee of £25 received. Fee donated to charity. Hours: 10 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 3 | 2010-01-06-1f359ece-10189-0 |
| fcbb2478f57d6389de652aef35eac75d1d5b5ad6 | Received fee of £150 for completing survey for Ipsos MORI, 79-81 Borough Road, London, SE1 1FY. Hours: 1.5hrs. Fee donated to charity. (Registered 28 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2009-12-10-1f359ece-10189-0 |
| e7c61e458172edb89eb405286c541f4c31acfaed | ComRes, 4 Millbank, London SW1P 3JA. Fee of £75 received on 24 November 2009. Fee donated to charity. Hours: 35 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 1 | 2009-12-10-1f359ece-10189-0 |
| 8b5179264ede994a80068e457738e0aab814009e | Populus, Northburgh House, 10 Northburgh Street, London EC1V 0AT. Fee of £50 received. Fee donated to charity. Hours: 10 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 2 | 2009-12-10-1f359ece-10189-0 |
| 7dd1f00a4fed85d6a6b19cd598895c32b751f3b4 | ICM, Berkshire House, 168-173 High Holborn, London WC1V 7AA. Fee of £25 received. Fee donated to charity. Hours: 10 mins. (Registered 4 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 3 | 2009-12-10-1f359ece-10189-0 |
| 40bff99e98adeae295567e03be54412bb3daaac9 | Received fee of £150 for completing survey for Ipsos MORI, 79-81 Borough Road, London, SE1 1FY. Hours: 1.5hrs. Fee donated to charity. (Registered 28 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-25 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2009-11-25-1f359ece-10189-0 |
| 60d3bd274f4722b9b2d5c6c78fc884201dc19312 | Received fee of £150 for completing survey for Ipsos MORI, 79-81 Borough Road, London, SE1 1FY. Hours: 1.5hrs. Fee donated to charity. (Registered 28 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-11 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2009-11-11-1f359ece-10189-0 |
| 817f37a155b9b0038bf970180395e1ab65b7b0cc | Received fee of £150 for completing survey for Ipsos MORI, 79-81 Borough Road, London, SE1 1FY. Hours: 1.5hrs. Fee donated to charity. (Registered 28 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-10-28 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2009-10-28-1f359ece-10189-0 |
| 54a01ea18574f780c354abbc0a603a64830776a4 | Received fee of £150 for completing survey for Ipsos MORI, 79-81 Borough Road, London, SE1 1FY. Hours: 1.5hrs. Fee donated to charity. (Registered 28 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-10-14 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2009-10-14-1f359ece-10189-0 |
| de022c90bb05251421f468a0f71d6c102b906c88 | Received fee of £150 for completing survey for Ipsos MORI, 79-81 Borough Road, London, SE1 1FY. Hours: TBC. Fee donated to charity. (Registered 28 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-09-02 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2009-09-02-1f359ece-10189-0 |
| f38e386e7c71483be47c3b7856ea16f5890c238d | Donation from RMT trade union to 2005 General Election fund. (Registered 8 June 2005) | Sponsorship or financial or material support 9e46def6 | 2006-05-12 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2006-05-12-9e46def6-10189-0 |
| f8fbaa613d876b6c5273818e09eec872f781a9f5 | Donation from RMT trade union to 2005 General Election fund. (Registered 8 June 2005) | Sponsorship or financial or material support 9e46def6 | 2006-03-24 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2006-03-24-9e46def6-10189-0 |
| 21044eb0084686ae9ad1da920e90d9907ce4e374 | Donation from RMT trade union to 2005 General Election fund. (Registered 8 June 2005) | Sponsorship or financial or material support 9e46def6 | 2006-02-14 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2006-02-14-9e46def6-10189-0 |
| ff6b7cabc4b10f157bf4c941689fc3a3189035c6 | Donation from RMT trade union to 2005 General Election fund. (Registered 8 June 2005) | Sponsorship or financial or material support 9e46def6 | 2006-02-13 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2006-02-13-9e46def6-10189-0 |
| d58c0364db30362ecbc3ed6589c5f42274ac3dee | Donation from RMT trade union to 2005 General Election fund. (Registered 8 June 2005) | Sponsorship or financial or material support 9e46def6 | 2005-12-14 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2005-12-14-9e46def6-10189-0 |
| 41686b940fd46792bc5e1b2f8193a1113e163fde | Donation from RMT trade union to 2005 General Election fund. (Registered 8 June 2005) | Sponsorship or financial or material support 9e46def6 | 2005-11-01 | Bill Etherington uk.org.publicwhip/member/1855 | Bill Etherington uk.org.publicwhip/person/10189 | 0 | 2005-11-01-9e46def6-10189-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");