items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where record_id = "2012-01-30-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 |
---|---|---|---|---|---|---|---|
4ab08cba5ddeea1bf78f3b2f379d87448696565c | Address: Guardian News and Media Ltd, Kings Place, 90 York Way, London N1 9GU. | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 0 | 2012-01-30-1f359ece-10162-0 |
3393ea091607e0b06bafe5e0b11318bb3474ff26 | Payment of £500 for article published in the Observer. Hours: 3 hrs. (Registered 18 July 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 1 | 2012-01-30-1f359ece-10162-0 |
1deb6a1612062c32d78838d3571f905affff9870 | 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-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 2 | 2012-01-30-1f359ece-10162-0 |
6378d0c1fc1c1efa41df301987d7f0c599804896 | Payment of £500 for article in The Times. Hours: 3hrs. (Registered 18 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 3 | 2012-01-30-1f359ece-10162-0 |
8a1052aec65f204dc5cf3910c75c20a11f0b9172 | Payment of £500 for article in The Times. Hours: 3hrs. (Registered 23 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 4 | 2012-01-30-1f359ece-10162-0 |
fa73c2d055943ebe5939a78634a63a42955b8c4f | Payment of £500 for article in The Times. Hours: 3hrs. (Registered 13 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 5 | 2012-01-30-1f359ece-10162-0 |
c00594f9320f5d6c09f644016627c6a0342fb99a | Payment of £500 for article in The Times. Hours: 3hrs. (Registered 15 August 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 6 | 2012-01-30-1f359ece-10162-0 |
4cab8e3b35ca415faa1d9e66f007860332174ecc | 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-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 7 | 2012-01-30-1f359ece-10162-0 |
722795133f66b802b344563817b60ae44ff6deb5 | 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-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 8 | 2012-01-30-1f359ece-10162-0 |
3af9ff2ef9b78285f2c7c3c403a73d1f157dd0cc | 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-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 9 | 2012-01-30-1f359ece-10162-0 |
35fffb6cbfaf4a68900fc43c0db001e7fed22ab4 | Payments from BBC, Address: BBC, 201 Wood Lane, London W1A 1AA.: | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 10 | 2012-01-30-1f359ece-10162-0 |
5bcc6a25ee085be6a4bb0cec1147064bd41b4c97 | 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-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 11 | 2012-01-30-1f359ece-10162-0 |
0e67e09ecbe606954bfe1d224f0991057b14b555 | Payment of £295.77 for one article for the Wall Street Journal. Address: 1211 Avenue of the Americas, New York, NY 10036, USA. Hours; 3 hrs. (Registered 4 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 12 | 2012-01-30-1f359ece-10162-0 |
217d14961b329867b2c4707eaa463596dfa555c5 | Payment of £50 from BBC for participation in Radio 4 programme. Hours: 2 hrs. Address of payer: BBC, PO Box 480, Manchester M14 0EL. (Registered 15 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 13 | 2012-01-30-1f359ece-10162-0 |
a9bc44daa25107493b71fcc09a1873e595ce86fa | Payment of £300 for article for Prospect Magazine. Address of payer: 2 Bloomsbury Place, London WC1A 2QA. Hours: 3 hrs. (Registered 15 April 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 14 | 2012-01-30-1f359ece-10162-0 |
d7ea46cf5ad383508c7e84d9dd24dcbfb8807b81 | 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-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 15 | 2012-01-30-1f359ece-10162-0 |
4896cb305e1223865250c9169214dcd89448e1c4 | Payments for speaking engagements made via Jeremy Lee Associates, 80 Great Portland Street, London W1W 7NW: | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 16 | 2012-01-30-1f359ece-10162-0 |
6c5e6301aa82e21651577665beb8dbaa279b8c74 | Payment of £4,250 for speaking engagement for AVIVA. Hours: 6 hrs. (Registered 11 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 17 | 2012-01-30-1f359ece-10162-0 |
dfb74a25da98ea447e1cd980f95ca85717e23102 | 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-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 18 | 2012-01-30-1f359ece-10162-0 |
d2162bf75b3a65d6599fa48395f3c64a1570bd9f | 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-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 19 | 2012-01-30-1f359ece-10162-0 |
8e17bd963e34cb57279b77d8e825cef00917b984 | 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-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 20 | 2012-01-30-1f359ece-10162-0 |
82be4392ab7275d2bd97f54dd7bc96fff160cba9 | Payment of £360 from Telegraph Media Group, 111 Buckingham Palace Road, London SW1W 0DT, for an article. Hours: 3 hrs. (Registered 10 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 21 | 2012-01-30-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");