items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
27 rows where "date" is on date 2010-03-10 and person_id = "uk.org.publicwhip/person/10409" sorted by date descending
This data as json, CSV (advanced)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
764a684c09055d6371dbfc7befe699cbe7a0def6 | Recorder of the Crown Court (I sit as such from time to time). | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 0 | 2010-03-10-1f359ece-10409-0 |
7326d6d146c214e75db05c32de9d3edfdd55abe3 | £615 net payment for 4 hours work as Recorder at Reading Crown Court on 25 and 26 July. (Registered 26 July 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 1 | 2010-03-10-1f359ece-10409-0 |
5099162bf368eb6240a9eeb1155bc52e59e8ccee | £297.77 net payment for 3.5 hours worked as Recorder at Basildon Crown Court on 14 August 2009. Address: The Gore, Basildon, SS14 2BU. (Registered 29 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 2 | 2010-03-10-1f359ece-10409-0 |
d3633228d3f6b72add2fd7e4e12f3a16680735ed | £583 gross payment for 8 hours work as Recorder on 28 August 2009. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 3 | 2010-03-10-1f359ece-10409-0 |
c8a7b25b6a1ec4fe9b4f118c3912fe76e4a16b73 | £291.50 gross payment for 4 hours work as Recorder on 11 September 2009. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 4 | 2010-03-10-1f359ece-10409-0 |
a7d0371f27b1d9c1e1204a3036e3858760293dce | 18 November 2009, received £1166 gross for sitting at Chelmsford Crown Court on 5-6 November. Hours: 16 hrs. (7 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 5 | 2010-03-10-1f359ece-10409-0 |
bf753fb531e8618ebfb32bac1b794f9617d36064 | 4 December 2009, received £615 net for sitting in Crown Court on 19 and 20 November 2009. Hours: 16 hrs. (Registered 5 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 6 | 2010-03-10-1f359ece-10409-0 |
e14b60372ccf3b09e743fc2cb9408f7224337aa1 | 18 December 2009, received £297 net for sitting in Crown Court on 4 December 2009. Hours: 8 hrs. (Registered 5 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 7 | 2010-03-10-1f359ece-10409-0 |
47b95c2b5f70abdac055a022224018d27eb6d69f | 19 February 2010, received £583 gross (£297.77 net) for sitting as a Recorder. Hours: 1 day. (Registered 1 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 8 | 2010-03-10-1f359ece-10409-0 |
aa49cd6bbaa899a2d851a2ecd7c5f9b1c587bba2 | 26 February 2010, received £583 gross (£297.77 net) for sitting as a Recorder. Hours: 1 day. (Registered 1 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 9 | 2010-03-10-1f359ece-10409-0 |
ab84fb3a50f73aa2fec433c34530d7d025244976 | Acting District Judge (Magistrates Courts) (I sit as such from time to time). | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 10 | 2010-03-10-1f359ece-10409-0 |
ce8228f3cfb6ab1de56f26a13a67cae1f6a7fd5e | £1872 gross payment for sitting as Deputy District Judge on 17-19 August 2009 and 2 September 2009. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 11 | 2010-03-10-1f359ece-10409-0 |
7bcb4be0db066f048ac2ae4d4e1c368f67e0eaad | Received £250 for sitting as Deputy District Judge on 9 September 2009. Hours: 8 hrs. (Registered 6 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 12 | 2010-03-10-1f359ece-10409-0 |
f0227a1f88572a75e020d53011d4696df0f11b34 | £468 gross payment for sitting as Deputy District Judge on 9 September 2009. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 13 | 2010-03-10-1f359ece-10409-0 |
a1fecf38226b05fda68e2f1e71a59bd121028700 | 18 November 2009, received £468 gross for sitting at Woolwich Magistrates' Court on 27 October. Hours: 8 hrs. (7 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 14 | 2010-03-10-1f359ece-10409-0 |
4fc2c8d928789f24d04545b3192b249beff2a721 | 27 November 2009, received £468 gross for sitting at Redhill Magistrates' Court on 23 September. Hours: 8 hrs. (7 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 15 | 2010-03-10-1f359ece-10409-0 |
5eebb85538a7854497d3af1beefc9e20421a677f | 19 February 2010, received £468 gross (£250.02 net) for sitting as district judge. Hours: 1 day. (Registered 1 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 16 | 2010-03-10-1f359ece-10409-0 |
b9c2537e7fcdef9819a1333b7915d4b0b4a4c121 | Consultant to TWM, Solicitors (formerly Tuck and Mann), Sweech House, Gravel Hill, Leatherhead, Surrey. | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 17 | 2010-03-10-1f359ece-10409-0 |
c0200173a542a2f4d62e85c62483ffde06b39241 | Received retainer payment of £250. Hours: nil. (Registered 29 July 2009). | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 18 | 2010-03-10-1f359ece-10409-0 |
807f25f3b50c1338b5f9fded4a9267813eecee96 | Received retainer payment of £250. Hours: nil. (Registered 29 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 19 | 2010-03-10-1f359ece-10409-0 |
ea0553e79e0587b6dc3f173521d2deac1322e13f | Received retainer payment of £250 gross: Hours: nil. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 20 | 2010-03-10-1f359ece-10409-0 |
b590e4f6fc3deabc84697204881b0f577da0a6a1 | Received £250 consultancy fee. Hours: 3 hrs. (Registered 6 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 21 | 2010-03-10-1f359ece-10409-0 |
f6c1ef9c8b75a55f40ee49e5bf20241c5251b7b3 | Received £250 consultancy fee. Hours: nil. (7 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 22 | 2010-03-10-1f359ece-10409-0 |
55f55e81361c89486106db9e6de0e577bfadd92e | Received £250 consultancy fee. Hours: nil. (Registered 5 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 23 | 2010-03-10-1f359ece-10409-0 |
cf1aa833ea5834ed89a035cab6f8eb1c287daea5 | Received £250 consultancy fee. Hours: nil. (Registered 1 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 24 | 2010-03-10-1f359ece-10409-0 |
90f36ac4a9facecd4a0d451b816cf98e8e8db434 | Panellist for the General Medical Council, Regent's Place, 350 Euston Road, London NW1 5JN, in relation to disciplinary issues. | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 25 | 2010-03-10-1f359ece-10409-0 |
a02899cf8e0b21870d28688bb8daa7e834ae39d5 | Received £650 gross for work on 6 and 9 October 2009. Hours: 16 hrs. (Registered 6 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 26 | 2010-03-10-1f359ece-10409-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");