items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
29 rows where record_id = "2011-10-17-1f359ece-10574-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 |
---|---|---|---|---|---|---|---|
93231ac1097465088b39f389c62d7c3741c46ace | Payments from News International Supply Co Ltd. Address: Cygnet Park, 200 Serpentine Way, Peterborough PE7 8FD: | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 0 | 2011-10-17-1f359ece-10574-0 |
ef351b9dcf34a309a769add096c59382e5db8abd | Payment of £500 for article in The Times 30 July 2010. Hours: 4 hrs approx, plus unquantifiable thinking time. (Registered 18 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 1 | 2011-10-17-1f359ece-10574-0 |
00b69c11dd65e3ed7da655629f95bec95aafca17 | 8 November 2010, payment of £500 for article in The Times. Hours: 12 hrs, plus indeterminate amount of time researching the article. (Registered 7 December 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 2 | 2011-10-17-1f359ece-10574-0 |
d3aa73ee03182003f88a5bf9a5606c2e189ad71f | 6 December 2010, payment of £300 for article in The Times, 13 November 2010. Hours: 2 hrs, plus indeterminate amount of time researching the article. (Registered 29 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 3 | 2011-10-17-1f359ece-10574-0 |
3422d4105a296d81b87b74e99a13eae1dfb661bf | 7 March 2011, payment of £500 for article in The Times, 10 February 2011. Hours: 4 hrs, plus indeterminate amount of time researching the article. (Registered 29 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 4 | 2011-10-17-1f359ece-10574-0 |
f9d6836cac0a8ae86d26b6547f70b5d1c7a8a2c1 | 28 March 2011, payment of £700 for book review for The Times, 12 November 2010. Hours: approx 12-15 hrs. (Registered 29 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 5 | 2011-10-17-1f359ece-10574-0 |
473b316b57030c89606b6078ceece2326917bbe3 | 28 March 2011, payment of £650 for book review for The Times, 26 February 2010. Hours: approx 10-12 hrs. (Registered 29 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 6 | 2011-10-17-1f359ece-10574-0 |
6f7b49796a49b2b569101e86cef8144eca92823e | 28 March 2011, payment of £500 for article in The Times, 5 March 2011. Hours: 4-5 hrs, plus indeterminate amount of time researching the article. (Registered 29 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 7 | 2011-10-17-1f359ece-10574-0 |
ca26e4717ae8d7fd98cb884a4c813a7c6e086860 | 26 April 2011, payment of £500 for column in The Times, 28 March 2011. Hours: approx 4 hrs, plus an indeterminate time preparing and thinking about the article. (Registered 14 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 8 | 2011-10-17-1f359ece-10574-0 |
3e9edaf331447777ef3b6b8dbb691263b7a08007 | 15 May 2011, payment of £500 for column in The Times, 26 April 2011. Hours: approx 4 hrs, plus an indeterminate time preparing and thinking about the article. (Registered 14 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 9 | 2011-10-17-1f359ece-10574-0 |
571df569ca301a8ddd82d44f0d34b729096e1281 | 23 May 2011, payment of £500 for column in The Times, 4 May 2011. Hours: approx 4 hrs, plus an indeterminate time preparing and thinking about the article. (Registered 14 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 10 | 2011-10-17-1f359ece-10574-0 |
0258ffb74f83e5284806e7d9405051eaa86af16e | 6 June 2011, payment of £500 for column in The Sun, 19 May 2011. Hours: 3 hrs. (Registered 14 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 11 | 2011-10-17-1f359ece-10574-0 |
4470d6b9bbbacbce2826fcbf89d0edabfaa6cc0c | 13 June 2011, payment of £500 for book review for The Times, May 2011. Hours: 12 hrs. (Registered 14 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 12 | 2011-10-17-1f359ece-10574-0 |
e20a5f4d6544ca41b2205db0bbf8e9e87654b735 | 4 July 2011, payment of £500 for article for The Sun on car insurance. ours: 3 hrs. Hours: 3 hrs. (Registered 3 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 13 | 2011-10-17-1f359ece-10574-0 |
cf0afb962004a8dfecc4794ebb992a35b47b7c67 | 11 July 2011, payment of £500 for article for The Times on Turkey. Hours: 4 hrs. (Registered 3 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 14 | 2011-10-17-1f359ece-10574-0 |
41f510d0b857e171fbc7a8580cc71aedb0ad698d | 11 July 2011, payment of £500 for article for The Times on car insurance. Hours: 12 hrs. (Registered 3 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 15 | 2011-10-17-1f359ece-10574-0 |
00d4797fdc379a536753808426d9c3b0959cea1b | 1 August 2011, payment of £500 for article for The Times on press regulation Hours: 5 hrs. (Registered 3 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 16 | 2011-10-17-1f359ece-10574-0 |
9992509364543c0c0e2baf63212afca8e60fc504 | 19 October 2010, presentation on foreign policy for the Centre for Foreign Policy Studies, Paris. Fee received £8,000, plus travel provided for me and my wife who accompanied me. Hours: 36 hrs (including travel). (Registered 7 December 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 17 | 2011-10-17-1f359ece-10574-0 |
b9eb87ca17ae03015d8ebe317239ed5c436d48ca | 21 October 2010, launching the Nexis Lexis Middle East Law project in Dubai. Fee paid £5,525, plus travel and accommodation provided. Hours: 36 hrs. (Registered 7 December 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 18 | 2011-10-17-1f359ece-10574-0 |
fdbf3cfcf82c387f3f7e24dc9eb3b25dd5a244dd | 4 April 2011, payment of £500 for book review for Prospect Magazine, 2 Bloomsbury Place, London WC1A 2QA. Hours: approx 10-12 hrs. (Registered 4 April 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 19 | 2011-10-17-1f359ece-10574-0 |
6c68f28f1f9eecb9c8b8e868ec63f1e5c02373ee | 15 April 2011, received fee of £2,000 for participating in a Government of Turkey conference on foreign policy in Istanbul on 24 March 2011. I was accompanied by my wife. Our travel to Ankara and Istanbul and accommodation and meals from 23-28 March 2011 were paid by the Government of Turkey; total cost £2,910. Time taken, including travel and preparation, three days. (Registered 3 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 20 | 2011-10-17-1f359ece-10574-0 |
3135cf105544b3015bf69b047923c5a7f51ccaa7 | 15 April 2011, received fee of £6,000 for speaking at the ECOBuild Exhibition, London, on 3 March 2011. Address of payer: IBE Limited/Ecobuild, 1 Great Winchester Street, London EC2N 2DB. Hours: 10 hrs. (Registered 3 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 21 | 2011-10-17-1f359ece-10574-0 |
0e01def92b6f5b27d5d661b6501d4c05a7d68b0a | 2 August 2011, received payment of £750 from The Guardian, Kings Place, 90 York Way, London N1 9GU for book review of Alistair Campbell diaries. Hours: 8 hrs. (Registered 3 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 22 | 2011-10-17-1f359ece-10574-0 |
ce4c57d150f01cbd9b87fb5df4bc4f13dea0c7a0 | Payments from Specialist Speakers, 18 Waxwell Lane, Harrow, London, HA5 3EN, UK | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 23 | 2011-10-17-1f359ece-10574-0 |
a2b9fb8afef6bd15a7b0554f1e5db75d9d4bdf49 | May 2011, received £7,000 for speaking to conference organised by Permira, a private equity firm, on 12 May 2011. Hours: 12 hrs. (Registered 3 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 24 | 2011-10-17-1f359ece-10574-0 |
f7ad9a8f69d22521ccd313c94c66666358803993 | Consultant to ED & F MAN Holdings Ltd; commodity traders, advising the group and its senior executives on the international and national environment in which it operates and on other specific matters. Address: Cottons Centre, Hays Lane, London SE1 2QE (£25,001-£30,000) Payment received on a quarterly basis. | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 25 | 2011-10-17-1f359ece-10574-0 |
07d3fc9d13f668ce8284fec77f6e9cf2f95498fd | 9 June 2011, received £7,500 consultancy fee for quarter 1 April to 30 June 2011. Hours: approx 30 hrs. (Registered 17 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 26 | 2011-10-17-1f359ece-10574-0 |
72e2868c5f452a59623869e56ba01900ffdc4d3e | 2 August 2011, received £7,500 consultancy fee for quarter 1 July to 30 September 2011. Hours: approx 60 hrs. (Registered 3 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 27 | 2011-10-17-1f359ece-10574-0 |
061ae835051381ed5c805d65323264e9f451ab14 | On 22 and 23 September 2011 I travelled to Kiev on behalf of E D & F MAN for meeting with Prime Minister of Ukraine and others. Business class return fare: £1010; cars £200, hotel £400 approx. (Registered 17 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 28 | 2011-10-17-1f359ece-10574-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");