items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
24 rows where record_id = "2012-06-25-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 |
---|---|---|---|---|---|---|---|
d2174f80984ec3bdeb169a0f13b00a41f8212a89 | Address: Guardian News and Media Ltd, Kings Place, 90 York Way, London N1 9GU. | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 0 | 2012-06-25-1f359ece-10162-0 |
bfed4b1dbefd9ef915efb84ebb2eb10c60d47c62 | Payment of £500 for article published in the Observer. Hours: 3 hrs. (Registered 18 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 1 | 2012-06-25-1f359ece-10162-0 |
a6b8a06e0ea705158149118ba8da690489dae39d | 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-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 2 | 2012-06-25-1f359ece-10162-0 |
80b98d027c7e7716e0ecd7b6f5ae43600aa39b5b | Payment of £500 for article in The Times. Hours: 3hrs. (Registered 15 August 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 3 | 2012-06-25-1f359ece-10162-0 |
844aa489ab8108d82ca02d70dd32ca3e9784e1ae | Payment of £500 for article in The Times. Hours: 3 hrs. (Registered 23 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 4 | 2012-06-25-1f359ece-10162-0 |
fb3dcbdc81d3be59e3c78981dfa27c76b3f766cf | Payment of £300 for article in The Times. Hours: 3 hrs. (Registered 23 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 5 | 2012-06-25-1f359ece-10162-0 |
9b22c8b06a9a0de1fa804c3ff5465a99ab2bffe1 | Payment of £500 for article in The Times. Hours: 3 hrs. (Registered 3 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 6 | 2012-06-25-1f359ece-10162-0 |
ba4b8675892011bc87553a6925c61a7a8830e14e | 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-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 7 | 2012-06-25-1f359ece-10162-0 |
1a30e09aea018af648a754b04a519e230fa4277b | 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-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 8 | 2012-06-25-1f359ece-10162-0 |
96b9c88ae51f95a5e8374aabb9efa4e84fd646a8 | Payment of £1,200 for article for Daily Mail. Hours: 3 hrs. (Registered 3 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 9 | 2012-06-25-1f359ece-10162-0 |
9e75e720a1d655494ef4626fe53cc760457d428f | Payment of £1,200 for article for Mail on Sunday. Hours: 3 hrs. (Registered 7 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 11 | 2012-06-25-1f359ece-10162-0 |
ef2852f4049d941b4a2973c0e3c00ee56000af69 | 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-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 12 | 2012-06-25-1f359ece-10162-0 |
1dfe9f01e736bdb7a1e8f98e3e178e9d1a5ffc3f | Payment of £800 for article for Daily Mail. Hours: 3 hrs. (Registered 21 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 13 | 2012-06-25-1f359ece-10162-0 |
362902e00aae68961af29713169fe77c23676472 | Payments from BBC, Address: BBC, 201 Wood Lane, London W1A 1AA.: | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 14 | 2012-06-25-1f359ece-10162-0 |
a6c2ce2b47d0e06fe5f84274d911164d0a30b2a5 | 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-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 15 | 2012-06-25-1f359ece-10162-0 |
42e953e6ed353a4a05faf387d4b92b666740cd21 | 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-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 16 | 2012-06-25-1f359ece-10162-0 |
dc4a60f9f6b6a70f5039818966e5567355877d83 | Payments for speaking engagements made via Jeremy Lee Associates, 80 Great Portland Street, London W1W 7NW: | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 17 | 2012-06-25-1f359ece-10162-0 |
1650c724f7cd9ac22acbf7aa6aee639387b15b05 | 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-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 18 | 2012-06-25-1f359ece-10162-0 |
d93f007e66969f2b513e28725787e337768df935 | Payment of £4,250 for speaking engagement for Civica. Hours: 6 hrs. (Registered 14 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 19 | 2012-06-25-1f359ece-10162-0 |
6c9f1e2b6d0b717e46bed52cf99a1f4c041650e7 | 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-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 20 | 2012-06-25-1f359ece-10162-0 |
3641710d0aa6b7d090ad14994c762683ec112cd6 | 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-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 21 | 2012-06-25-1f359ece-10162-0 |
e8abc44685c22a5b19c46e25426745fe3567c56f | Payments from Telegraph Media Group, 111 Buckingham Palace Road, London SW1W 0DT: | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 22 | 2012-06-25-1f359ece-10162-0 |
9312d6f48d0bef72ec7626d198ba8f22dfb63d43 | Payment of £360 from for an article. Hours: 3 hrs. (Registered 10 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 23 | 2012-06-25-1f359ece-10162-0 |
fb3d9f1f4549c7105211385c669b939a645ead30 | January 2012, payment of £270 for article in Daily Telegraph. Hours: 3 hrs. (Registered 13 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 24 | 2012-06-25-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");