items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2011-01-24-1f359ece-11858-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 |
---|---|---|---|---|---|---|---|
9cccb359e510dbeedb9900c8cea376685a32e424 | Contract with Times Newspapers Limited to supply a set number of articles. Address: News International Limited, 1 Virginia Street, London, E98 1XY. (£60,001-£65,000) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 0 | 2011-01-24-1f359ece-11858-0 |
969ec4b2679edf2ca00fbb982da4b41db6e07128 | Contract from Harper Collins to write historical biography. | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 1 | 2011-01-24-1f359ece-11858-0 |
4909d8f38eec85844f0dc4c1a101e33d63762c02 | Fees from BBC. Address: BBC Television Centre, Wood Lane, London W12 7RJ. (£10,001–£15,000) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 2 | 2011-01-24-1f359ece-11858-0 |
11b98119420327adb8cf0e648d88fa863fd31fb6 | Received payments of £793.13 on 15 January 2010 and £176.25 on 3 February 2010 for appearing on BBC Newsnight Late Review. Hours: 4 hrs . (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 3 | 2011-01-24-1f359ece-11858-0 |
fe922c4326cb76b8156e20e21b40fda9dece836f | Associate Editor, The House Magazine. Address: Dods Parliamentary Communication Ltd, 3rd Floor, Westminster Tower, 3, Albert Embankment, London, SE1 7SP. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 4 | 2011-01-24-1f359ece-11858-0 |
33fb799ca5c541321f4eca4149b4247efcb4e72f | 15 January 2010, received £565.23 for work as Editor. Hours: 4 hrs. (Registered 19 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 5 | 2011-01-24-1f359ece-11858-0 |
4a57af5c67407ff13eaec68f1a20b307373814b0 | Income from publication of ‘Celsius 7/7’, published by Weidenfeld & Nicolson | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 6 | 2011-01-24-1f359ece-11858-0 |
7519554f44e7987ff0532530b844fa8751692d55 | Columnist, "Building Magazine", United Business Media, Ludgate House, 245 Blackfriars Road, London SE1 9UY.. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 7 | 2011-01-24-1f359ece-11858-0 |
595a5ba56fa19d332f758dcfbb7cc05c96f06173 | 15 March 2010, received payment of £2,300 for five articles in 2009 for Building Magazine. Hours: 5 hrs. (Registered 23 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 8 | 2011-01-24-1f359ece-11858-0 |
9bccaf6a7776842e87bf641bc0b6b966ab92c066 | Contributor to "Scotland on Sunday". Address of payer: The Scotsman Publications Ltd, Barclay House, 108 Holyrood Road, Edinburgh EH8 8AS. (£5,001–£10,000) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 9 | 2011-01-24-1f359ece-11858-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");