items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where "date" is on date 2010-12-20 and person_id = "uk.org.publicwhip/person/10022" 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 |
---|---|---|---|---|---|---|---|
84ce7bf8802faebb6e0b624a6fb5846cec8d016b | Fees from the Centre for Management and Policy Studies for lectures given to civil servants. | Remunerated employment, office, profession etc 1f359ece | 2010-12-20 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 0 | 2010-12-20-1f359ece-10022-0 |
d101c5a38b6eb711ae5f8d66b2f1d7df9e680c21 | Ongoing income from royalties for publication of book entitled ‘The Strange Death of David Kelly’: | Remunerated employment, office, profession etc 1f359ece | 2010-12-20 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 1 | 2010-12-20-1f359ece-10022-0 |
1e4181d15dfe9be24b2c935344bd630c3829f615 | 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-12-20 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 2 | 2010-12-20-1f359ece-10022-0 |
b18a40372dd34c43d3dbc1499210aab09c832863 | 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-12-20 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 3 | 2010-12-20-1f359ece-10022-0 |
624b193501fdf66fab9eae903f71688bc6baddff | 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-12-20 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 4 | 2010-12-20-1f359ece-10022-0 |
7d83b8462e121973703285bb5044c9944035678a | 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-12-20 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 5 | 2010-12-20-1f359ece-10022-0 |
c6de457e58205efa5616e2b3781162de29d3cf65 | 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-12-20 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 6 | 2010-12-20-1f359ece-10022-0 |
d2cf464e968614d616d321de6f6a8fea6f5e6b7b | 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-12-20 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 7 | 2010-12-20-1f359ece-10022-0 |
031dd93571fc735cf89c7f570f5b7654ed452c6f | Received £150 on 2 March 2010. Hours: 1 hr. (Registered 5 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-12-20 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 8 | 2010-12-20-1f359ece-10022-0 |
d5489f685de65a87da3bb9ecbfe1374b771f680d | Received £150 plus £12 travel expenses on 2 March 2010. Hours: 1 hr. (Registered 5 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-12-20 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 9 | 2010-12-20-1f359ece-10022-0 |
7d701429ecce95bc4a96361913af68213e9e88f1 | 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-12-20 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 10 | 2010-12-20-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");