items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where "date" is on date 2009-11-11 and person_id = "uk.org.publicwhip/person/10409" sorted by record_id
This data as json, CSV (advanced)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
42af2233e8df102563bcb296206868595fdbba2f | Recorder of the Crown Court (I sit as such from time to time). | Remunerated employment, office, profession etc 1f359ece | 2009-11-11 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 0 | 2009-11-11-1f359ece-10409-0 |
5443904fb3dc4a9282f41d9a8d46355b09fbfdc5 | £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 | 2009-11-11 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 1 | 2009-11-11-1f359ece-10409-0 |
5d1029edf6c7bb5cd48711e28ab7da21a1936457 | £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 | 2009-11-11 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 2 | 2009-11-11-1f359ece-10409-0 |
feed98ea4d33c492e7847a2ba5aead21859a64eb | £583 gross payment for 8 hours work as Recorder on 28 August 2009. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-11 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 3 | 2009-11-11-1f359ece-10409-0 |
8d33eaee76d9d181b48457ac436bed194b7d3b3f | £291.50 gross payment for 4 hours work as Recorder on 11 September 2009. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-11 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 4 | 2009-11-11-1f359ece-10409-0 |
33617da540831286a8ad0d43bc04244a57301812 | Acting District Judge (Magistrates Courts) (I sit as such from time to time). | Remunerated employment, office, profession etc 1f359ece | 2009-11-11 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 5 | 2009-11-11-1f359ece-10409-0 |
10c9881801c15377b924c65dce216f41b8d9b88c | £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 | 2009-11-11 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 6 | 2009-11-11-1f359ece-10409-0 |
6a25a35ecfb3958128329746fddbb3fdde779cda | 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 | 2009-11-11 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 7 | 2009-11-11-1f359ece-10409-0 |
a6110fb607879a3b8a60b02e57719bfea1797559 | £468 gross payment for sitting as Deputy District Judge on 9 September 2009. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-11 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 8 | 2009-11-11-1f359ece-10409-0 |
05c8803b950fcfe3f78ce944731d90cd14a577d4 | Consultant to TWM, Solicitors (formerly Tuck and Mann), Sweech House, Gravel Hill, Leatherhead, Surrey. | Remunerated employment, office, profession etc 1f359ece | 2009-11-11 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 9 | 2009-11-11-1f359ece-10409-0 |
d08383e76785abace8bef077c8ef4de9371d0f27 | Received retainer payment of £250. Hours: nil. (Registered 29 July 2009) . | Remunerated employment, office, profession etc 1f359ece | 2009-11-11 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 10 | 2009-11-11-1f359ece-10409-0 |
78cfc5a9e0d835444c77164823a8a271a2de170b | Received retainer payment of £250. Hours: nil. (Registered 29 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-11 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 11 | 2009-11-11-1f359ece-10409-0 |
ed7d8ff1a44ecc936b6f71462e9cbebb72ab253b | Received retainer payment of £250 gross: Hours: nil. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-11 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 12 | 2009-11-11-1f359ece-10409-0 |
4ba15cd5d604b316f05b7b2111bc63a0005b5d6b | Received £250 consultancy fee. Hours: 3 hrs. (Registered 6 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-11 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 13 | 2009-11-11-1f359ece-10409-0 |
a09689b9941f596f635133904c0b59a6b27c80d4 | 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 | 2009-11-11 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 14 | 2009-11-11-1f359ece-10409-0 |
de89f2c669e230549a66932ffe601dc6528b759b | Received £650 gross for work on 6 and 9 October 2009. Hours: 16 hrs. (Registered 6 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-11 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 15 | 2009-11-11-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");