items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
23 rows where "date" is on date 2010-01-06 and person_id = "uk.org.publicwhip/person/10409" sorted by sort_order
This data as json, CSV (advanced)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
b46c916bd0aa439a5a64bc69afd562bdae7b5dee | Recorder of the Crown Court (I sit as such from time to time). | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 0 | 2010-01-06-1f359ece-10409-0 |
debfd7661ab772ccd73a0be871e9d353bedbbb74 | £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-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 1 | 2010-01-06-1f359ece-10409-0 |
b9474f929821ef5182ce4485d0f6ad0b01915c83 | £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-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 2 | 2010-01-06-1f359ece-10409-0 |
42b12da9bd3a7b32ed2b65d768624b654b009a04 | £583 gross payment for 8 hours work as Recorder on 28 August 2009. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 3 | 2010-01-06-1f359ece-10409-0 |
af22621b84b30a1caa7da66c3698e237467b58e0 | £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-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 4 | 2010-01-06-1f359ece-10409-0 |
05f0b2791f7fb9e959250d89b6afa105184d681d | 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-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 5 | 2010-01-06-1f359ece-10409-0 |
0e8bdc04b2f4efbeee280e03138a21aef6036d64 | 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-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 6 | 2010-01-06-1f359ece-10409-0 |
e9e9d8208303b1a669ec5c381dc17ff45f74230e | 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-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 7 | 2010-01-06-1f359ece-10409-0 |
60e87ce0e658dd1820153fffe14690fb7b34fdfa | Acting District Judge (Magistrates Courts) (I sit as such from time to time). | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 8 | 2010-01-06-1f359ece-10409-0 |
dabac30b43cb85d7bc5ca01b6490d192ce43fccb | £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-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 9 | 2010-01-06-1f359ece-10409-0 |
a8f7e903ceeee317c10daef80c72c6231efc5f24 | 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-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 10 | 2010-01-06-1f359ece-10409-0 |
8f832bee8c6accc745e01c14eca4e80a6dd8ea5c | £468 gross payment for sitting as Deputy District Judge on 9 September 2009. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 11 | 2010-01-06-1f359ece-10409-0 |
2cf3c4e0d400bced172c32ae8158132eb0a1479f | 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-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 12 | 2010-01-06-1f359ece-10409-0 |
bd99294ffceb51e1bccbf4b4f971558ebd97bc98 | 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-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 13 | 2010-01-06-1f359ece-10409-0 |
fe3cc0d2443282133ad70ab3f3b485cfb3913b68 | Consultant to TWM, Solicitors (formerly Tuck and Mann), Sweech House, Gravel Hill, Leatherhead, Surrey. | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 14 | 2010-01-06-1f359ece-10409-0 |
78691890ec3c20b82abc88a4af0f2f61ef949293 | Received retainer payment of £250. Hours: nil. (Registered 29 July 2009). | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 15 | 2010-01-06-1f359ece-10409-0 |
8c126539f802d26c34b4ce09c61234cce2bec0eb | Received retainer payment of £250. Hours: nil. (Registered 29 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 16 | 2010-01-06-1f359ece-10409-0 |
325b1ebd41cf7edfd1d343ccd16236cf592511a1 | Received retainer payment of £250 gross: Hours: nil. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 17 | 2010-01-06-1f359ece-10409-0 |
bc4d67ff4b614f8cf9046a3f5f896fac96093ce5 | Received £250 consultancy fee. Hours: 3 hrs. (Registered 6 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 18 | 2010-01-06-1f359ece-10409-0 |
bcd72bae25176dff890297f9093301c39443c534 | Received £250 consultancy fee. Hours: nil. (7 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 19 | 2010-01-06-1f359ece-10409-0 |
115c769a9543fe21fbb86b7192a486fdc1fe04a0 | Received £250 consultancy fee. Hours: nil. (Registered 5 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 20 | 2010-01-06-1f359ece-10409-0 |
24b8935bbed9178a7bf1d69678d36924a9880041 | 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-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 21 | 2010-01-06-1f359ece-10409-0 |
6c96f9fd0634bc37d005d4d408d892ce376839c9 | 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-01-06 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 22 | 2010-01-06-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");