items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2013-06-24-1f359ece-10314-0" sorted by record_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
d47b33e5741353fbde2d9837743c6ec819dbc97e | Contributed to BBC TV and radio programmes. Address: BBC Broadcasting House, Portland Place, London W1A 1AA: | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2013-06-24-1f359ece-10314-0 |
81c3c70d9102fb2e878d71777bef735efdaf33bc | Received payment of £4,300 during the period 21 June to 25 October 2012. Hours: 15 hrs. (Registered 9 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 1 | 2013-06-24-1f359ece-10314-0 |
dff97b13d0cc498548e744c877d3c11afc869310 | 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 | 2013-06-24 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 2 | 2013-06-24-1f359ece-10314-0 |
2f9064e0086be824a32feac4d943648ba6b347dd | 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 | 2013-06-24 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 3 | 2013-06-24-1f359ece-10314-0 |
dcf7412ac592be3dcd9ec7f212e9b9c9d9d6b103 | Received payment of £300 on 5 March 2013. Hours: 2 hrs. (Registered 23 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 4 | 2013-06-24-1f359ece-10314-0 |
120dfe2bfe4736e29c4e54add55aa064b8e6b513 | 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 | 2013-06-24 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 5 | 2013-06-24-1f359ece-10314-0 |
3b5116edda5ebf63f953924b90c902dacb3b56fe | Payment of £9,500 for completion of book. Hours: 9 months. (Registered 13 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 6 | 2013-06-24-1f359ece-10314-0 |
152d27868b542e7a44c7391e86f1e4e670eefce4 | Second payment of £9,500 for completion of book. Hours: 9 months. (Registered 5 March 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 7 | 2013-06-24-1f359ece-10314-0 |
8fdac65be7987350e4ad4577df786136543bf7a7 | Third payment of £18,450 upon publication of book. Hours: 9 months. (Registered 23 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 8 | 2013-06-24-1f359ece-10314-0 |
5bacea4c309be0ee82d7307adb4d5d449115efc4 | Payment of £225 received from the Times newspaper, 1 Virginia Street, London E98 1XY for a book review. Hours: 8 hrs. (Registered 9 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 9 | 2013-06-24-1f359ece-10314-0 |
9c90f8d8361db88813741c6d24975ae5b4190f30 | Payment of £225 received on 6 October 2012 from News International Trading, PO Box 151, Peterborough PE7 8YT, for article in The Times. Hours: 2 hrs. (Registered 26 February 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 10 | 2013-06-24-1f359ece-10314-0 |
032d3370318236d99770fc343ce919bbd2200ad3 | 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 | 2013-06-24 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 11 | 2013-06-24-1f359ece-10314-0 |
42430318659ea1990a72d8a1fa12dec382d63f7f | 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 | 2013-06-24 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 12 | 2013-06-24-1f359ece-10314-0 |
2a538a1b8da264884427416a08428b74f2451e53 | 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 | 2013-06-24 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 13 | 2013-06-24-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");