items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where record_id = "2010-11-22-1f359ece-10022-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
9495f1bb2df61949812ccff3dc4caa03c9281449 | Fees from the Centre for Management and Policy Studies for lectures given to civil servants. | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 0 | 2010-11-22-1f359ece-10022-0 |
64609444a7ee0e1033528e4e7e4408605e6daae1 | Ongoing income from royalties for publication of book entitled ‘The Strange Death of David Kelly’: | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 1 | 2010-11-22-1f359ece-10022-0 |
639924d36764b3848a6935b1087673053030f1e7 | 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-22 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 2 | 2010-11-22-1f359ece-10022-0 |
4637fea46d42c52ffe54a0a64020add21b90ba7c | 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-22 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 3 | 2010-11-22-1f359ece-10022-0 |
213354854f9a05d18261c409b658f0bc7af67cf9 | 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-22 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 4 | 2010-11-22-1f359ece-10022-0 |
ac50c6a2f96d595a8c35f2d28a2f72dc9ba59647 | 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-22 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 5 | 2010-11-22-1f359ece-10022-0 |
d5d757562cff18efc4e7d2a8b5249b9a579002c1 | 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-22 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 6 | 2010-11-22-1f359ece-10022-0 |
397851373e970a10c9c3488de6cd07e57202766f | 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-22 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 7 | 2010-11-22-1f359ece-10022-0 |
a6529de64561866f9004d2049bac5000660b7ce0 | Received £150 on 2 March 2010. Hours: 1 hr. (Registered 5 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 8 | 2010-11-22-1f359ece-10022-0 |
ad5f3213627be1f793685d118e8df52cfca2c31c | 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-22 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 9 | 2010-11-22-1f359ece-10022-0 |
3e6a60c254e4bd72ac80b1e747f6a7cb23ec8c64 | 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-22 | Norman Baker uk.org.publicwhip/member/40362 | Norman Baker uk.org.publicwhip/person/10022 | 10 | 2010-11-22-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");