items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where record_id = "2011-10-17-1f359ece-10063-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
dff80e135046736be112e4784c7a76dfd89e5223 | Populus, Northburgh House, 10 Northburgh Street, London. EC1V 0AT. | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 0 | 2011-10-17-1f359ece-10063-0 |
dfdb58f27c90265a98cf5af79f477e601336a240 | 1 September 2010, received payment of £50 for completing a survey. Hours: 30 mins. Fee donated to charity. (Registered 7 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 1 | 2011-10-17-1f359ece-10063-0 |
449f8cbb72da721a5cc4ae058523a81c1b8ff8c2 | 16 December 2010, received payment of £50 for completing a survey. Hours: 15 mins. Fee donated to charity. (Registered 24 December 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 2 | 2011-10-17-1f359ece-10063-0 |
f9eb43840da2f3794d81ef592e6faa2dca407fa8 | 18 March 2011, received payment of £75 for completing survey in February 2011. Hours: 15 mins. Fee donated to charity. (Registered 14 April 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 3 | 2011-10-17-1f359ece-10063-0 |
d14a831ccc558812d17663a272b7b0db747b3cb4 | Dods, Westminster Tower, 3 Albert Embankment, London, SE1 7SP. | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 4 | 2011-10-17-1f359ece-10063-0 |
b85fddc88a87e9b191b9aa1871bcc000c6b3a54c | 31 August 2010, received payment of £150 for giving a speech. Hours: 50 mins. Fee donated to my local constituency party. (Registered 1 September 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 5 | 2011-10-17-1f359ece-10063-0 |
cf134f4e64e9efcece7f0aced76d96277929c2f8 | 22 February 2011, received payment of £150 for giving a speech. Hours: 1 hr. Fee donated to my local constituency party. (Registered 23 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 6 | 2011-10-17-1f359ece-10063-0 |
ec8eb8fe1ddd803b2c2c7929df4c4f96c61acd91 | 3 March 2011, received £150 for giving a speech. Hours: 1 hr. Fee donated to my local constituency party. (Registered 27 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 7 | 2011-10-17-1f359ece-10063-0 |
bc8fd4f845a6b30484bdf9415a1eae54b4e9ed98 | 23 March 2011 , received £150 for giving a speech. Hours: 1 hr. Fee donated to my local constituency party. (Registered 27 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 8 | 2011-10-17-1f359ece-10063-0 |
1738c0cfd15e190c178607aa96b5d238b293b66f | 30 March 2011 , received £150 for giving a speech. Hours: 1 hr. Fee donated to my local constituency party. (Registered 1 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 9 | 2011-10-17-1f359ece-10063-0 |
22dc533764a66f09795ef72a31dce969e87a8e53 | 10 May 2011 , received £150 for giving a speech. Hours: 1 hr. Fee donated to my local constituency party. (Registered 1 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 10 | 2011-10-17-1f359ece-10063-0 |
8a2f656715b21685669b918e133373f3f5899266 | 14 June 2011 , received £150 for giving a speech. Hours: 1 hr. Fee donated to my local constituency party. (Registered 1 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 11 | 2011-10-17-1f359ece-10063-0 |
bcc7d50d74cbdbb39923a7329c73027852ad3b0a | 6 September 2011, received £150 for giving a speech. Hours: 1 hr. Fee donated to my local constituency party. (Registered 6 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 12 | 2011-10-17-1f359ece-10063-0 |
793ec909e3ba762a1b9c7702f179e8f76b29f182 | ComRes, 4 Millbank, London. | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 13 | 2011-10-17-1f359ece-10063-0 |
40456668dd9cdfb7193ca69931458c0ec683ad2a | 25 June 2010, received payment of £75 for completing an opinion poll. Hours: 30 mins. Fee donated to my local constituency party. (Registered 1 September 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 14 | 2011-10-17-1f359ece-10063-0 |
13b9e9f5970091695fcb69504e6cd191fac9cbdf | 30 November 2010, received payment of £75 for survey. Hours: 30 mins. Fee donated to my local constituency party. (Registered 7 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 15 | 2011-10-17-1f359ece-10063-0 |
aebf8fc83ac8856148ed1ea1c733fa136a65f4ee | 20 January 2011, received payment of £75 for survey. Hours: 30 mins. Fee donated to my local constituency party. (Registered 24 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 16 | 2011-10-17-1f359ece-10063-0 |
205bf64544c974786ce75fc8d1f98edffd10cc72 | 21 March 2011, received payment of £75.00 for survey. Hours: 30 mins . Fee donated to my local constituency party. (Registered 27 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 17 | 2011-10-17-1f359ece-10063-0 |
100bd2050f13b1540ea6fde803ce11ca8d7320df | 17 June 2011, received payment of £75 for survey. Hours: 30 mins. Fee donated to Carshalton and Wallington Liberal Democrat Development Fund. (Registered 30 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 18 | 2011-10-17-1f359ece-10063-0 |
3201d481217a6726bb149bc7a6a5d1e7615d9fb3 | 14 July 2011, received payment of £75 for survey. Hours: 30 mins. Fee donated to Carshalton and Wallington Liberal Democrat Development Fund. (Registered 8 September 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Tom Brake uk.org.publicwhip/member/40152 | Tom Brake uk.org.publicwhip/person/10063 | 19 | 2011-10-17-1f359ece-10063-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");