items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
23 rows where "date" is on date 2010-02-03 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 |
---|---|---|---|---|---|---|---|
b4a7ca29c3626e58524b9ad35bfd3f78b923c136 | Recorder of the Crown Court (I sit as such from time to time). | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 0 | 2010-02-03-1f359ece-10409-0 |
4dd894ce9cfe488ff64032f0e3940774688adc14 | £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-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 1 | 2010-02-03-1f359ece-10409-0 |
ad33bb16ba55e85e567102b05342a252ab15430b | £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-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 2 | 2010-02-03-1f359ece-10409-0 |
bd791dad62b45aa40af79212f3392194af806c63 | £583 gross payment for 8 hours work as Recorder on 28 August 2009. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 3 | 2010-02-03-1f359ece-10409-0 |
a9e6c5d2f43e43320a8b2e2e35530c77b5ccd7d4 | £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-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 4 | 2010-02-03-1f359ece-10409-0 |
280cc0527212c2f56b8b6517ff5bf637ff8b94c3 | 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-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 5 | 2010-02-03-1f359ece-10409-0 |
3d39c2fae63b9cb9029569efa7080ab9068f6603 | 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-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 6 | 2010-02-03-1f359ece-10409-0 |
b6ab31ce04127008b038fa8c19a00e83d0d68c50 | 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-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 7 | 2010-02-03-1f359ece-10409-0 |
03302568bec34eb58e27d990443540b0146dae3b | Acting District Judge (Magistrates Courts) (I sit as such from time to time). | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 8 | 2010-02-03-1f359ece-10409-0 |
b754b7731675a1613dc983de5522350a6e464cdd | £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-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 9 | 2010-02-03-1f359ece-10409-0 |
71f5a328aaefafff3e7287299cbc422dbdb0c959 | 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-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 10 | 2010-02-03-1f359ece-10409-0 |
76d298d6e28a063b23d929615c0175ca9e9a084f | £468 gross payment for sitting as Deputy District Judge on 9 September 2009. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 11 | 2010-02-03-1f359ece-10409-0 |
9abff158f57e1546efabe79e00b31792147f091a | 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-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 12 | 2010-02-03-1f359ece-10409-0 |
34d9c5a6aa30311092a22a67b39748765aab8317 | 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-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 13 | 2010-02-03-1f359ece-10409-0 |
0110332d9d279cab89ff4dcf7dc91f118f6509ab | Consultant to TWM, Solicitors (formerly Tuck and Mann), Sweech House, Gravel Hill, Leatherhead, Surrey. | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 14 | 2010-02-03-1f359ece-10409-0 |
75d48e36013c2c9b67b53ec268d242f35abca6e1 | Received retainer payment of £250. Hours: nil. (Registered 29 July 2009). | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 15 | 2010-02-03-1f359ece-10409-0 |
9e0e0a75e2f02604bdae4eecd764ba6b671e1b70 | Received retainer payment of £250. Hours: nil. (Registered 29 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 16 | 2010-02-03-1f359ece-10409-0 |
01291a5bb656441a2cb0b83e5c61d778471fba17 | Received retainer payment of £250 gross: Hours: nil. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 17 | 2010-02-03-1f359ece-10409-0 |
c11af391ac62d656324ab850d76b2ce61dcfe2c7 | Received £250 consultancy fee. Hours: 3 hrs. (Registered 6 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 18 | 2010-02-03-1f359ece-10409-0 |
628d0336a3eb3a084a098c8be914ced0ce7672ef | Received £250 consultancy fee. Hours: nil. (7 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 19 | 2010-02-03-1f359ece-10409-0 |
acda20d7d3f1d001b16b75032dbf14f6b3832e94 | Received £250 consultancy fee. Hours: nil. (Registered 5 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 20 | 2010-02-03-1f359ece-10409-0 |
9b62ea33b5958694670990cb4fc694072dcd428d | 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-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 21 | 2010-02-03-1f359ece-10409-0 |
dcab420d201cd5f7c1885b11392255ea194fc7e4 | 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-02-03 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 22 | 2010-02-03-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");