items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where "date" is on date 2009-10-28 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 |
---|---|---|---|---|---|---|---|
a5e15a6652d8f5874802ec346a21dd7c465f05b6 | Recorder of the Crown Court (I sit as such from time to time). | Remunerated employment, office, profession etc 1f359ece | 2009-10-28 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 0 | 2009-10-28-1f359ece-10409-0 |
c8dd0d54e6e5175ff689e2dcc419b616494508a1 | £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-10-28 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 1 | 2009-10-28-1f359ece-10409-0 |
c786f1590bedf9ccc2d12f0b64b5d2db608e30e8 | £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-10-28 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 2 | 2009-10-28-1f359ece-10409-0 |
86aca997f29aa85a583070273e58166acbf6fe3e | £583 gross payment for 8 hours work as Recorder on 28 August 2009. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-10-28 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 3 | 2009-10-28-1f359ece-10409-0 |
4929b128a2c9050dc024512dff749cf984a88068 | £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-10-28 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 4 | 2009-10-28-1f359ece-10409-0 |
1725f4c547021a6c15cd1629a011acc5507c9849 | Acting District Judge (Magistrates Courts) (I sit as such from time to time). | Remunerated employment, office, profession etc 1f359ece | 2009-10-28 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 5 | 2009-10-28-1f359ece-10409-0 |
fe34e802ac36f7676fa1f60ec07ec366e6332cbf | £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-10-28 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 6 | 2009-10-28-1f359ece-10409-0 |
4ed0dc0f80e2964d818310a291635e160f27c1b0 | £468 gross payment for sitting as Deputy District Judge on 9 September 2009. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-10-28 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 7 | 2009-10-28-1f359ece-10409-0 |
0d482e2c3221c565fca0d8ac685aed23cd4a3e1f | Consultant to TWM, Solicitors (formerly Tuck and Mann), Sweech House, Gravel Hill, Leatherhead, Surrey. | Remunerated employment, office, profession etc 1f359ece | 2009-10-28 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 8 | 2009-10-28-1f359ece-10409-0 |
b217facccaf258117e16ab5db7919ea832559bd0 | Received retainer payment of £250. Hours: nil. (Registered 29 July 2009). | Remunerated employment, office, profession etc 1f359ece | 2009-10-28 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 9 | 2009-10-28-1f359ece-10409-0 |
a29b948ddc9ce9b2a0bad1bc189ac224d29a2486 | Received retainer payment of £250. Hours: nil. (Registered 29 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-10-28 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 10 | 2009-10-28-1f359ece-10409-0 |
8a7ca9ce6093bc406cf87f0326210e6ddc9d9898 | Received retainer payment of £250 gross: Hours: nil. (Registered 1 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-10-28 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 11 | 2009-10-28-1f359ece-10409-0 |
7b73e8fd9fc13416b97b0ecb48979ace396387d6 | 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-10-28 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 12 | 2009-10-28-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");