items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
26 rows where record_id = "2012-04-16-1f359ece-10162-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 |
---|---|---|---|---|---|---|---|
841c00327419569c4df11b1b20811b2944394080 | Address: Guardian News and Media Ltd, Kings Place, 90 York Way, London N1 9GU. | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 0 | 2012-04-16-1f359ece-10162-0 |
84abd31b1583a8ce482c3d3277af097fcc1b8f6f | Payment of £500 for article published in the Observer. Hours: 3 hrs. (Registered 18 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 1 | 2012-04-16-1f359ece-10162-0 |
5164e3c4a1e9a3ff8c98ff9feab8d7a5952248bd | Articles written for Times and Sunday Times. Address: News International Group, News International Ltd, 1 Virginia Street, London E98 1XY. | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 2 | 2012-04-16-1f359ece-10162-0 |
aa62e4adaf95f053384f596f6911cc95ee76a8c3 | Payment of £500 for article in The Times. Hours: 3hrs. (Registered 23 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 3 | 2012-04-16-1f359ece-10162-0 |
37580e3cc1df0290f56c4555f6dac4790e34d6ca | Payment of £500 for article in The Times. Hours: 3hrs. (Registered 13 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 4 | 2012-04-16-1f359ece-10162-0 |
2eb06ed815e7e221d03354d43a00cfa345e442e8 | Payment of £500 for article in The Times. Hours: 3hrs. (Registered 15 August 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 5 | 2012-04-16-1f359ece-10162-0 |
daac62be6f2dffcbd87262077295f38eefa22907 | Payment of £500 for article in The Times. Hours: 3 hrs. (Registered 23 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 6 | 2012-04-16-1f359ece-10162-0 |
cfeaf0ef49a5db30c7428d5c0002753442b18c4d | Payment of £300 for article in The Times. Hours: 3 hrs. (Registered 23 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 7 | 2012-04-16-1f359ece-10162-0 |
5024233a7cf4bff64f0da572f0a252cdcdc1b410 | Articles written for Daily Mail and Mail on Sunday. Address: Northcliffe House, 2 Derry Street, Kensington, London W8 5TT: | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 8 | 2012-04-16-1f359ece-10162-0 |
de3dfd51924c598f1d4874202c31be345d645991 | Payment of £1,200 for article for the Mail on Sunday. Hours: 3 hrs. (Registered 13 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 9 | 2012-04-16-1f359ece-10162-0 |
b7a1040532fe6c4c599bd8bcff075e742f41efec | Payment of £1,200 for article for the Mail on Sunday. Hours: 3 hrs. (Registered 15 August 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 10 | 2012-04-16-1f359ece-10162-0 |
a8ae3c58501f7d89b24a1bcd68782228ea6815d3 | Payment of £1,200 for article for Daily Mail. Hours: 3 hrs. (Registered 3 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 11 | 2012-04-16-1f359ece-10162-0 |
52a646dfb0e40bb798069b2187c66030a254a105 | Payment of £1,200 for article for Mail on Sunday. Hours: 3 hrs. (Registered 7 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 13 | 2012-04-16-1f359ece-10162-0 |
d582abee43ceda61baf51c3b520363acc67afbd0 | Cancellation fee of £500 for one article which did not run. Hours: 3 hrs. (Registered 23 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 14 | 2012-04-16-1f359ece-10162-0 |
50fbbcd6e0f7f3a9cea5d7f84e3439965caaa5ea | Payments from BBC, Address: BBC, 201 Wood Lane, London W1A 1AA.: | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 15 | 2012-04-16-1f359ece-10162-0 |
25c84516e337b6e417e5a9489e9a35eae5ba5ac4 | Payment of £150, received on 15 November 2011, for taking part in ‘Any Questions’ on Radio 4. The payment was made to my constituency association. (Registered 5 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 16 | 2012-04-16-1f359ece-10162-0 |
a7088d52be8542d3f002ed02677a1ff7e1348bd3 | Payment of £500 (made direct to the Haltemprice and Howden Conservative Association) for speech for Intelligence Squared, 6th Floor, Newcombe House, 45 Notting Hill Gate, London, W11 3LQ. Hours: 5 hours (Registered 8 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 17 | 2012-04-16-1f359ece-10162-0 |
0ba1c4f4311de69cb151c767aa75019da963f910 | Payments for speaking engagements made via Jeremy Lee Associates, 80 Great Portland Street, London W1W 7NW: | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 18 | 2012-04-16-1f359ece-10162-0 |
a2b7e1b7f608343cc0e30791ed46497ac53ba8a6 | Payment of £4,250 for speaking engagement for Royal Bank of Scotland. Hours: 6 hrs. Payment made directly to my parliamentary office. (Registered 22 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 19 | 2012-04-16-1f359ece-10162-0 |
419ae9ffaf196bfaace993c53b2bd393a84ad388 | Payment of £2,550 for speaking engagement for HSBC Prime Services. Hours: 6 hrs. (Registered 9 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 20 | 2012-04-16-1f359ece-10162-0 |
053b9808a7fb1ddd59f920f4220a897fe07a2ddd | Payment of £4,250 for speaking engagement for Civica. Hours: 6 hrs. (Registered 14 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 21 | 2012-04-16-1f359ece-10162-0 |
fb9c1146de50039a502c9c4f3594ce1c36c718c4 | Payment of £300 for article for Prospect Magazine, 2 Bloomsbury Place, London WC1A 2QA. Hours: 3 hrs. (Registered 15 August 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 22 | 2012-04-16-1f359ece-10162-0 |
3b224b4f68446fefa1748f5c27881a5d4f640a62 | I received a hamper, value £85, from Deloitte LLP, City House, 126-130 Hills Road, Cambridge CB2 1RY, for speaking in ‘The Great Debate’ on 5 October 2011. Hours: 6 hrs. (Registered 6 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 23 | 2012-04-16-1f359ece-10162-0 |
a18c63d2e31d77d9a9c121bc1791182d2c7d58f9 | Payments from Telegraph Media Group, 111 Buckingham Palace Road, London SW1W 0DT: | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 24 | 2012-04-16-1f359ece-10162-0 |
fb1d80de84bcec78e276896cd70623ad999ed293 | Payment of £360 from for an article. Hours: 3 hrs. (Registered 10 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 25 | 2012-04-16-1f359ece-10162-0 |
a1a2a3863874b7bd1a6120251561703a8e959375 | January 2012, payment of £270 for article in Daily Telegraph. Hours: 3 hrs. (Registered 13 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 26 | 2012-04-16-1f359ece-10162-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");