items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where "date" is on date 2011-01-24 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 |
---|---|---|---|---|---|---|---|
7f069b070ef8a9f063624d6a210759a3fc7a3303 | Fees from the Centre for Management and Policy Studies for lectures given to civil servants. | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 0 | 2011-01-24-1f359ece-10022-0 |
f393933472445f2323f784ef502911e3261465be | Ongoing income from royalties for publication of book entitled ‘The Strange Death of David Kelly’: | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 1 | 2011-01-24-1f359ece-10022-0 |
f90201d5a39ec970cde85cc02bbdb30cd5adbb4b | 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 | 2011-01-24 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 2 | 2011-01-24-1f359ece-10022-0 |
9a4e444ba6535de290cc89a441331079b5ab8474 | 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 | 2011-01-24 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 3 | 2011-01-24-1f359ece-10022-0 |
fab91e04576b9f86a31ed822a6701ab59f724479 | 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 | 2011-01-24 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 4 | 2011-01-24-1f359ece-10022-0 |
cc6718e40ec282dafc794c4177c18d9bf61ce561 | 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 | 2011-01-24 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 5 | 2011-01-24-1f359ece-10022-0 |
105134e60b935b61a75f96ad01b30d558c5753e4 | 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 | 2011-01-24 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 6 | 2011-01-24-1f359ece-10022-0 |
1188c39f3a0e2321f4b2aef34318a4f054e85245 | 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 | 2011-01-24 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 7 | 2011-01-24-1f359ece-10022-0 |
85e720df1aec00fa1093b3d7fa37d6bd3619e663 | Received £150 on 2 March 2010. Hours: 1 hr. (Registered 5 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 8 | 2011-01-24-1f359ece-10022-0 |
8eaee87a39b3d71f64d87558f5d8d1ce0f007a68 | Received £150 plus £12 travel expenses on 2 March 2010. Hours: 1 hr. (Registered 5 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 9 | 2011-01-24-1f359ece-10022-0 |
87354ddbdcffc87da03786501a909ecdf228f77d | 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 | 2011-01-24 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 10 | 2011-01-24-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");