items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2013-05-20-1f359ece-10314-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 |
---|---|---|---|---|---|---|---|
af014a830cfd220ab412d13a0eb99c55fdf16306 | Contributed to BBC TV and radio programmes. Address: BBC Broadcasting House, Portland Place, London W1A 1AA: | Remunerated employment, office, profession etc 1f359ece | 2013-05-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2013-05-20-1f359ece-10314-0 |
116403be40275631456a064ae475a7151dd273f9 | 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-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 1 | 2013-05-20-1f359ece-10314-0 |
0893f000e0cd810abf9c7d57619987c3614af5d5 | 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-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 2 | 2013-05-20-1f359ece-10314-0 |
098d4699a7c1f07699f107f006e0e056e7532124 | 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-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 3 | 2013-05-20-1f359ece-10314-0 |
dd16f8bda38beaa40e9148dde376dae90f272fb7 | 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-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 4 | 2013-05-20-1f359ece-10314-0 |
a5d31218d7c1f3ad39cafd064998cf4a29488798 | Payment of £9,500 for completion of book. Hours: 9 months. (Registered 13 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-05-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 5 | 2013-05-20-1f359ece-10314-0 |
b0d062b1865f513ee68f4ad6c10da3d24556dd22 | Second payment of £9,500 for completion of book. Hours: 9 months. (Registered 5 March 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-05-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 6 | 2013-05-20-1f359ece-10314-0 |
0c4df8703f8abd2a9d0e64deba8aea5e84e419a6 | 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-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 7 | 2013-05-20-1f359ece-10314-0 |
f98cd889ca09158d2a8aa4c0599bf912a7817709 | 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-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 8 | 2013-05-20-1f359ece-10314-0 |
fbc5c0429f2ba27cd9014068ae9832b3112d9855 | 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-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 9 | 2013-05-20-1f359ece-10314-0 |
471bb694e4cc2cd7413d47423b3b7f321cbe40a3 | 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-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 10 | 2013-05-20-1f359ece-10314-0 |
d3292e223d9fd0daac204f441018e2d059f2bc5d | 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-20 | Alan Johnson uk.org.publicwhip/member/40346 | Alan Johnson uk.org.publicwhip/person/10314 | 11 | 2013-05-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");