items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where record_id = "2010-11-08-1f359ece-10022-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
22bb5fc5e8b8f65a05178639e3918ec1962d7289 | Fees from the Centre for Management and Policy Studies for lectures given to civil servants. | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 0 | 2010-11-08-1f359ece-10022-0 |
50293c07928428963f99b76b6837ddf8cf82a184 | Ongoing income from royalties for publication of book entitled ‘The Strange Death of David Kelly’: | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 1 | 2010-11-08-1f359ece-10022-0 |
416ff64fbb3bd37bb3b541d09d1983a604ad541c | Royalty payment of £1,298.33 for the period 1 January 2009-31 December 2009 from Methuen Publishing Ltd, 8 Artillery Row, London SW1P 1RZ. (Registered 21 May 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 2 | 2010-11-08-1f359ece-10022-0 |
cb31ed3a40140472b9ce68b53bdd5ceb676081ab | Payments from Associated Newspapers Ltd for articles in Daily Mail and The Mail on Sunday, Northcliffe House, 2 Derry Street, Kensington, London W8 5TT: | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 3 | 2010-11-08-1f359ece-10022-0 |
ce58d9810fedd9210488c6ae1b50425716f5d5a3 | 10 March 2010, received payment of £1000 for an article published in The Mail on Sunday on 22 January 2010. Hours: 2 hrs. (Registered 12 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 4 | 2010-11-08-1f359ece-10022-0 |
76d47331782a0a420499589162300d0547ebf79d | 19 March 2010, received payment of £1000 for an article published in the Mail on Sunday. Hours: 1hr 30mins. (Registered 30 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 5 | 2010-11-08-1f359ece-10022-0 |
ccd59428a18df571b073aaed1f2f61849231d789 | 24 November 2009, received payment of £150 for taking part in survey of MPs for Ipsos MORI, 79-81 Borough Road, London SE1 1FY. Hours: 30 mins. (Registered 17 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 6 | 2010-11-08-1f359ece-10022-0 |
6b736e3ac9c2cb91d05f7f25ac06b94eb438b1dd | Payments for training sessions on parliamentary questions. Address of payer: National School of Government, Sunningdale Park, Larch Avenue, Ascot SL5 0QE. | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 7 | 2010-11-08-1f359ece-10022-0 |
5f5f0932c6ac12ac5990598a86984dc541d8ac5d | Received £150 on 2 March 2010. Hours: 1 hr. (Registered 5 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 8 | 2010-11-08-1f359ece-10022-0 |
82f333dbec4dad944e3ee8717e72f7006cc10d4e | Received £150 plus £12 travel expenses on 2 March 2010. Hours: 1 hr. (Registered 5 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 9 | 2010-11-08-1f359ece-10022-0 |
2ca5f08d01ba84e77cf0c66104560e3ba36fe1ad | 3 March 2010, received £150 for taking part in training sessions on parliamentary questions. Address: Dods Parliamentary Communications Ltd, 4 Grosvenor Place, London SW1X 7DL. Hours: 1 hr. (Registered 5 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 10 | 2010-11-08-1f359ece-10022-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");