items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where "date" is on date 2009-09-02 and person_id = "uk.org.publicwhip/person/10409" sorted by date
This data as json, CSV (advanced)
hash | item | category_id | date ▼ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
a66d30882c6a0f7a11cf0d0a873709e81b781b81 | Recorder of the Crown Court (I sit as such from time to time). | Remunerated employment, office, profession etc 1f359ece | 2009-09-02 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 0 | 2009-09-02-1f359ece-10409-0 |
4d0f36f091ec691dfbfc407e82f38a4f20526ac2 | £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-09-02 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 1 | 2009-09-02-1f359ece-10409-0 |
3bef357de09d5a4a52eb34fdb7743caf4b605725 | £297.77 net payment for a day's work 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-09-02 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 2 | 2009-09-02-1f359ece-10409-0 |
941bda3d105e3dc1787f7781d545274d0e0af14c | Acting District Judge (Magistrates Courts) (I sit as such from time to time). | Remunerated employment, office, profession etc 1f359ece | 2009-09-02 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 3 | 2009-09-02-1f359ece-10409-0 |
e1b7f0cbfc542a1a96893b76bf5a289cd7ad732a | Consultant to TWM, Solicitors (formerly Tuck and Mann), Sweech House, Gravel Hill, Leatherhead, Surrey. | Remunerated employment, office, profession etc 1f359ece | 2009-09-02 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 4 | 2009-09-02-1f359ece-10409-0 |
25988d26ccb38c200bb8bbffcbb2ad92feef1a6f | Received retainer payment of £250. Hours: nil. (Registered 29 July 2009). | Remunerated employment, office, profession etc 1f359ece | 2009-09-02 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 5 | 2009-09-02-1f359ece-10409-0 |
115b6537663fbaf5832a361f0e2067b5a906cc40 | Received retainer payment of £250. Hours: nil. (Registered 29 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-09-02 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 6 | 2009-09-02-1f359ece-10409-0 |
76f36fbc8e89423962953f1d42777dd3a7f888a3 | 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-09-02 | Humfrey Malins uk.org.publicwhip/member/1933 | Humfrey Malins uk.org.publicwhip/person/10409 | 7 | 2009-09-02-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");