items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
19 rows where record_id = "2012-09-03-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 |
---|---|---|---|---|---|---|---|
a5f2f1c859c7494161d0aba1b70563e046205c4e | 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-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 0 | 2012-09-03-1f359ece-10162-0 |
95082d5c45a7ef4f6491e81a6e73b46424975013 | Payment of £500 for article in The Times. Hours: 3 hrs. (Registered 23 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 1 | 2012-09-03-1f359ece-10162-0 |
09dba59c9914606a27b3ddb8fdc046b93bad55a2 | Payment of £300 for article in The Times. Hours: 3 hrs. (Registered 23 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 2 | 2012-09-03-1f359ece-10162-0 |
bc2401099845600bc8f5462ca89f2d4df6032c26 | Payment of £500 for article in The Times. Hours: 3 hrs. (Registered 3 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 3 | 2012-09-03-1f359ece-10162-0 |
6be0f5792b299f01295e9ac1fc6ca1d0ad62161d | Payment of £500 for article in The Times. Hours: 3 hrs. (Registered 26 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 4 | 2012-09-03-1f359ece-10162-0 |
fb69bba8f1f922f8240a1e7cf4989daa024ce09d | 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-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 5 | 2012-09-03-1f359ece-10162-0 |
52ccc6db643bec53c0375b032083a51d97a073ad | Payment of £1,200 for article for Daily Mail. Hours: 3 hrs. (Registered 3 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 6 | 2012-09-03-1f359ece-10162-0 |
88565087855fae5b6b90856f4928c4b115283d87 | Payment of £1,200 for article for Mail on Sunday. Hours: 3 hrs. (Registered 7 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 8 | 2012-09-03-1f359ece-10162-0 |
9171d35471b92c9df8f403331ad758e36e39fad8 | 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-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 9 | 2012-09-03-1f359ece-10162-0 |
37ce491d908ab4257cdffcfd2aeec06d11ecf8d4 | Payment of £800 for article for Daily Mail. Hours: 3 hrs. (Registered 21 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 10 | 2012-09-03-1f359ece-10162-0 |
c10c0a5a394b23f1674632c4ac9e06c872820d59 | Payments from BBC, Address: BBC, 201 Wood Lane, London W1A 1AA.: | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 11 | 2012-09-03-1f359ece-10162-0 |
473ccf611a21899c2cf29e9c2bd05d5b8863d516 | 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-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 12 | 2012-09-03-1f359ece-10162-0 |
122a7ac6a868de75b667e583c66cd0f512c5a4de | Payments for speaking engagements made via Jeremy Lee Associates, 80 Great Portland Street, London W1W 7NW: | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 13 | 2012-09-03-1f359ece-10162-0 |
624b7b8fc51541c47d76eac06df1c7626127fa3a | 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-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 14 | 2012-09-03-1f359ece-10162-0 |
23197312f13583d57f1f4bd0b5894f60a80c6681 | Payment of £4,250 for speaking engagement for Civica. Hours: 6 hrs. (Registered 14 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 15 | 2012-09-03-1f359ece-10162-0 |
07a499f71b9e83592a0feb94b665096498e4ed10 | 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-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 16 | 2012-09-03-1f359ece-10162-0 |
ef8d96de2e849ac9835e8edf6e506f5bbb28626d | Payments from Telegraph Media Group, 111 Buckingham Palace Road, London SW1W 0DT: | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 17 | 2012-09-03-1f359ece-10162-0 |
bb67f587c64af490b80313a60bc4ca4c80604dc9 | Payment of £360 from for an article. Hours: 3 hrs. (Registered 10 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 18 | 2012-09-03-1f359ece-10162-0 |
f22dcad4b125f3f1f49a58593a4f5e9a22dde874 | January 2012, payment of £270 for article in Daily Telegraph. Hours: 3 hrs. (Registered 13 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | David Davis uk.org.publicwhip/member/40293 | David Davis uk.org.publicwhip/person/10162 | 19 | 2012-09-03-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");