items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
31 rows where record_id = "2011-11-16-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 |
---|---|---|---|---|---|---|---|
23ae5a07342399a43d5654f7d126e9e9200bd15e | Payments from News International Supply Co Ltd. Address: Cygnet Park, 200 Serpentine Way, Peterborough PE7 8FD: | Remunerated employment, office, profession etc 1f359ece | 2011-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 0 | 2011-11-16-1f359ece-10574-0 |
bd3452bbc91546071cf48ef5942a537b5adf97a7 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 1 | 2011-11-16-1f359ece-10574-0 |
2b99c9df7434972b379abbcc1fee65711f3b1117 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 2 | 2011-11-16-1f359ece-10574-0 |
148cd985b031777a159a98c56c031dfa50fcf2ce | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 3 | 2011-11-16-1f359ece-10574-0 |
c3151df8483d4f2999a80d0183a3fadf6c358414 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 4 | 2011-11-16-1f359ece-10574-0 |
4e52a4753f63de2eceaa2ce5d3cfbf09f9bfc172 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 5 | 2011-11-16-1f359ece-10574-0 |
7bb5e9a83c121c9f505ec7674142b0418ee5fd33 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 6 | 2011-11-16-1f359ece-10574-0 |
a97a1d2e5e2ed18f083e1ddf920eefb9e2364e65 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 7 | 2011-11-16-1f359ece-10574-0 |
5be5249c5b73e45c16490f55d4d51944ae44f915 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 8 | 2011-11-16-1f359ece-10574-0 |
ad38748771ce79dac6b5b7cf369ead06ea50ef8f | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 9 | 2011-11-16-1f359ece-10574-0 |
a1d572ae03d0a5375a5e43b3d98e52936d943245 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 10 | 2011-11-16-1f359ece-10574-0 |
8a53c5b89e0d3f286ca186453e2efd6133eb6bfe | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 11 | 2011-11-16-1f359ece-10574-0 |
757f06b965fd11aa69648bb809427223c855fdbe | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 12 | 2011-11-16-1f359ece-10574-0 |
ed21d267137d30ae1c378a79b8c650afc5916b76 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 13 | 2011-11-16-1f359ece-10574-0 |
2d0b7de25febb0aa3b84c800d47073cb287e2f33 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 14 | 2011-11-16-1f359ece-10574-0 |
fcfa346047c9423a3b968ced73143e643acdd69a | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 15 | 2011-11-16-1f359ece-10574-0 |
5d77022a9684e6e1d1d954417424146c47aa4f73 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 16 | 2011-11-16-1f359ece-10574-0 |
6b6a443455ced162a49fcf9be8b54ea14220dd9a | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 17 | 2011-11-16-1f359ece-10574-0 |
c0d15aacae4b7a6b092d2fa8e9d90775b3adf234 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 18 | 2011-11-16-1f359ece-10574-0 |
0494c06cd59129c22b51d3e7b9ab3794c8f14c57 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 19 | 2011-11-16-1f359ece-10574-0 |
4ff9c34d1dc84f4a9ab0091be23ee79711247f22 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 20 | 2011-11-16-1f359ece-10574-0 |
53665592c141031eff65cfe765fcc65c1b34d716 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 21 | 2011-11-16-1f359ece-10574-0 |
943d1bd72d54990f826b98f9adcb3b485ec2aced | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 22 | 2011-11-16-1f359ece-10574-0 |
5e0a79b307763f15b963f0042ac39ddeb7053e66 | Payments from Specialist Speakers, 18 Waxwell Lane, Harrow, London, HA5 3EN, UK | Remunerated employment, office, profession etc 1f359ece | 2011-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 23 | 2011-11-16-1f359ece-10574-0 |
b703f6f9d03671d3f2afb107e552cd79b970c455 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 24 | 2011-11-16-1f359ece-10574-0 |
b3444fbc58fdab2caa5574254980d88035956354 | 2 November 2011, fee of £4,000 for speaking engagement on 28 September 2011 for Crashworth Ltd (of Glebe View, Wolvey Lodge Farm, Cloudesley Bush Road, Wolvey, Leics, LE10 3 HB), The Commonwealth Club, London WC2N. Hours: 4 hrs. (Registered 16 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 25 | 2011-11-16-1f359ece-10574-0 |
031def6aafa5066c92db6dec29d1bc601289840b | 2 November 2011,fee of £4,500 in respect of speaking engagement on 12 October 2011for Inclusive Media Ltd (of 32-34 Broadwick St W1A 2HG) , publishers of Post Magazine at Victoria Plaza Hotel, London, SW1V 1EQ. Hours: 4 hrs. (Registered 16 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 26 | 2011-11-16-1f359ece-10574-0 |
4c62be168485b1d976ccebfdb634a3cf0438ba9c | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 27 | 2011-11-16-1f359ece-10574-0 |
c20388b6f019b19320e3ff15842e832384ef8948 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 28 | 2011-11-16-1f359ece-10574-0 |
bb88471163ecb9e8a997eda997be77d66a447fb4 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 29 | 2011-11-16-1f359ece-10574-0 |
0b5661ad1f3955c24aede3d1d10b344b0d72aac3 | 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-11-16 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 30 | 2011-11-16-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");