items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2013-05-07-1f359ece-10314-0" sorted by category_id
This data as json, CSV (advanced)
date (date) 1 ✖
- 2013-05-07 12
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
f368e4448c7fd51ec7e34c26cf22f75fd0b7402a | Contributed to BBC TV and radio programmes. Address: BBC Broadcasting House, Portland Place, London W1A 1AA: | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2013-05-07-1f359ece-10314-0 |
9e8eac7fdedfb3e721ba40a2fb13400106706b6b | Received a payment of £2,800 during period 15 March-10 May 2012. Hours: 8 hrs. (Registered 30 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 1 | 2013-05-07-1f359ece-10314-0 |
bb6788f931fa58431ed1cfd0b320e3ac0f6ca7db | 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-05-07 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 2 | 2013-05-07-1f359ece-10314-0 |
14a4a10ede18a9f942b82154a61986ece6536689 | 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-05-07 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 3 | 2013-05-07-1f359ece-10314-0 |
14cc0d6dd06abed532707aabe052757a31b9f1e2 | 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-05-07 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 4 | 2013-05-07-1f359ece-10314-0 |
e0352a37b468663868ab24ef693e3ff1cf2d99fc | Payment of £9,500 for completion of book. Hours: 9 months. (Registered 13 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 5 | 2013-05-07-1f359ece-10314-0 |
a2fb6715e29a9a3ad045b24b05020dfc86dfadc3 | Second payment of £9,500 for completion of book. Hours: 9 months. (Registered 5 March 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 6 | 2013-05-07-1f359ece-10314-0 |
00283903071cdd9f70e974d7a9ffa9b3e5a27f7b | Payment of £6,158.40 received on 1 March 2012 for a speech at Birmingham University on 3 November 2011. Address of payer: Celebrity Speakers Ltd, 90 High Street, Burnham, Bucks, SL1 7JT. Hours: 7 hrs. (Registered 30 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 7 | 2013-05-07-1f359ece-10314-0 |
a7678fef5ab2fd758460b883118f9a1fd2c538db | Payment of £2,550 received on 1 May 2012 for participating in Ecobuild Conference at Excel Centre on 22 March 2012. Address of payer: JLA, 80 Great Portland Street, London W1W 7NW. Hours: 4 hrs. (Registered 30 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-07 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 8 | 2013-05-07-1f359ece-10314-0 |
3bb8d3d16220f13259d99d661ce8f9b6ad23a14a | 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-05-07 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 9 | 2013-05-07-1f359ece-10314-0 |
52e2c369158bf75cc60450156c808bfabd414bdc | 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-05-07 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 10 | 2013-05-07-1f359ece-10314-0 |
c2dac61c2bb704f7cbbe833b5a58fb94e489bc11 | 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-05-07 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 11 | 2013-05-07-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");