items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
19 rows where record_id = "2014-01-20-1f359ece-10314-0" sorted by category_id
This data as json, CSV (advanced)
date (date) 1 ✖
- 2014-01-20 19
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
176b1ce43af15f747db805774fdc7ef0217e15d5 | Contributed to BBC TV and radio programmes. Address: BBC Broadcasting House, Portland Place, London W1A 1AA: | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2014-01-20-1f359ece-10314-0 |
936be10e4116024a60f5093c64b725c9a372ef69 | Received payment of £4,900 during the period 8 October 2012 to 24 January 2013. Hours: 17 hrs. (Registered 26 February 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 1 | 2014-01-20-1f359ece-10314-0 |
1e2ece179b9476c71e5ba1cc44a7cfba928c18a4 | Received payment of £3,500 during the period 7 March-9 May 2013. Hours: 9 hrs. (Registered 23 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 2 | 2014-01-20-1f359ece-10314-0 |
99754bbc242ef3834918adcf04b545537af33813 | Received payment of £300 on 5 March 2013. Hours: 2 hrs. (Registered 23 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 3 | 2014-01-20-1f359ece-10314-0 |
cddb8cb1f86b067e77bc38e43edd252a194e0e6c | Received payment of £2,800 during period 6 June to 18 July 2013. Hours: 8 hrs. (Registered 17 October 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 4 | 2014-01-20-1f359ece-10314-0 |
cd406ce3fb87320cf4c90c42dbad204715080840 | Received payment of £3,500 during period 10 October to 21 November 2013. Hours: 10 hrs. (Registered 18 December 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 5 | 2014-01-20-1f359ece-10314-0 |
52a9cea526d23e55c8337f9050b7ee9d672d8928 | Received payment of £1,400 during period 5-13 December 2013. (Registered 14 January 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 6 | 2014-01-20-1f359ece-10314-0 |
d563c3ef4049b431731dffb19a6a0f978e3862d6 | Contract with Transworld Publishers for writing a book. Address: The Random House Group, 61-63 Uxbridge Road, London W5 5SA: | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 7 | 2014-01-20-1f359ece-10314-0 |
74435cdf4089aa39212f27bac416276a2b1977f9 | Second payment of £9,500 for completion of book. Hours: 9 months. (Registered 5 March 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 8 | 2014-01-20-1f359ece-10314-0 |
46a93bc194bd02e7cc7ccd00c3f1051eedbf761a | Third payment of £18,450 upon publication of book. Hours: 9 months. (Registered 23 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 9 | 2014-01-20-1f359ece-10314-0 |
43dae8cc668d81dd388e88fcf55fa1252caa2dce | First payment of £18,450 upon agreement to write a second book. Hours: no hours worked. (Registered 18 December 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 10 | 2014-01-20-1f359ece-10314-0 |
e4016ebffedbda8e21c6f26727daa0008e4c9d34 | Payments from News International Trading, PO Box 151, Peterborough PE7 8YT: | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 11 | 2014-01-20-1f359ece-10314-0 |
3d5d0fe9a4c5c3cb8412b2947c75924c4f7891a9 | Payment of £225 received on 6 October 2012 for article in The Times. Hours: 2 hrs. (Registered 26 February 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 12 | 2014-01-20-1f359ece-10314-0 |
c2d80484e372a714db8d284433b99541982a901f | Payment of £500 for article. Hours: 2 hrs. (Registered 17 October 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 13 | 2014-01-20-1f359ece-10314-0 |
6e21b91e02a56fb0dc54f64382d808e18f375a77 | Payment of £250 received on 10 December 2012 from Telegraph Media Group, 111 Buckingham Palace Road, London SW1W 0DT, for article in Daily Telegraph. Hours: 2 hrs. (Registered 26 February 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 14 | 2014-01-20-1f359ece-10314-0 |
04eebc1c26a91e482a9a821bab925031f25aa7d2 | Payment of £500 received in April 2013 from News International Trading, PO Box 151, Peterborough PE7 8YT, for article in The Sun. Hours: 2 hrs. (Registered 23 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 15 | 2014-01-20-1f359ece-10314-0 |
7449c00a9f265619c64c1e721c0009270f4e01dd | Payment of £4,000 received on 1 May 2013 from Specialist Speakers, 8 Hawley Road, Hinkley, LE10 0PR for hosting an awards ceremony for the Rail Industry Association, 22 Headfort Place, London SW1X 7RY. (Registered 23 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 16 | 2014-01-20-1f359ece-10314-0 |
7927fc5764ce8a48f68a42dfeb0fd7c73becf0f1 | Payment of £1,000 received 12 September 2012 from Global Radio Services Ltd, 30 Leicester Square, London WC2H 7LA, for two radio programmes in August 2012. Hours: 10 hrs. (Registered 17 October 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 17 | 2014-01-20-1f359ece-10314-0 |
fe812232fb4e1d9fc3e9224debf54eb7debba5d4 | Payment of £300 received from Times Newspaper, 1 Virginia Street, London E98 1XY for a book review on 5 October 2013. Hours: 9 hrs. (Registered 18 December 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-01-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 18 | 2014-01-20-1f359ece-10314-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");