items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
29 rows where record_id = "2011-10-31-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 |
---|---|---|---|---|---|---|---|
aab557e29f802b0adb3db4304cb3179bf300ed41 | Payments from News International Supply Co Ltd. Address: Cygnet Park, 200 Serpentine Way, Peterborough PE7 8FD: | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 0 | 2011-10-31-1f359ece-10574-0 |
4c92341c7a6bd9b99895c6bb501dad6175be7ffe | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 1 | 2011-10-31-1f359ece-10574-0 |
97d8c9f3b08220c5e67c646566a54d8906ec3527 | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 2 | 2011-10-31-1f359ece-10574-0 |
c98b9c847dda405b025fed10933ca6ac0efe3669 | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 3 | 2011-10-31-1f359ece-10574-0 |
bf777f14b6eb9d2cd9baed780632024409cb3c77 | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 4 | 2011-10-31-1f359ece-10574-0 |
d3eec2967f833e11503e30167001872c844c00fd | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 5 | 2011-10-31-1f359ece-10574-0 |
ac59f8a783355e7978c16caf2ff3ad0b4bf1e521 | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 6 | 2011-10-31-1f359ece-10574-0 |
02bc5c84d24e98bb02b048f24af5925eb344a878 | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 7 | 2011-10-31-1f359ece-10574-0 |
d2ae7e47acdfe402f6206bd7d8b0e8c689b26144 | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 8 | 2011-10-31-1f359ece-10574-0 |
1895688016510d31333a402edf052aea2d32c04e | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 9 | 2011-10-31-1f359ece-10574-0 |
fa2c3badd4771d75a3cd11af8e4f042ff4da07ec | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 10 | 2011-10-31-1f359ece-10574-0 |
1f6898d3354867555a6721c58eea6d4a39bdec61 | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 11 | 2011-10-31-1f359ece-10574-0 |
947bc2caf3b3a2de746ed851dee957d91790bf2d | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 12 | 2011-10-31-1f359ece-10574-0 |
58c3894521cfe46df74b7e713b146844d35e1fcc | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 13 | 2011-10-31-1f359ece-10574-0 |
fc93fb930100bb6f7b4397f1f88886a8d5ad9871 | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 14 | 2011-10-31-1f359ece-10574-0 |
d89683bb62fbfb989a7b9c6ef3d7b1fe08e9ca56 | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 15 | 2011-10-31-1f359ece-10574-0 |
6df555c41612d440ee92de4a6dd12380cd085f86 | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 16 | 2011-10-31-1f359ece-10574-0 |
65ef075a438314af7b7b3d4f73384c0b21811118 | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 17 | 2011-10-31-1f359ece-10574-0 |
8d51de153377c85a54911fb8071e5bef10ea2ec5 | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 18 | 2011-10-31-1f359ece-10574-0 |
c8f1a6a7378c96e62e7bcd36cac8bee7968e4224 | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 19 | 2011-10-31-1f359ece-10574-0 |
290274d019162a55bb484429988ee16251c19b1a | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 20 | 2011-10-31-1f359ece-10574-0 |
24db481c693da79d82c438cb2bd2fe797400bb80 | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 21 | 2011-10-31-1f359ece-10574-0 |
dad8a009b0749476eefd366f39b09a9b1ef1009c | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 22 | 2011-10-31-1f359ece-10574-0 |
7a2a404da1962bd3d91e88c6a3b5bd5caa483646 | Payments from Specialist Speakers, 18 Waxwell Lane, Harrow, London, HA5 3EN, UK | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 23 | 2011-10-31-1f359ece-10574-0 |
736e920d8ddd8b3b23fee0cdceed2191c6388850 | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 24 | 2011-10-31-1f359ece-10574-0 |
cc65ecba2a87304f1f5cb2f331ffdff7f2e545aa | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 25 | 2011-10-31-1f359ece-10574-0 |
d9cfaf30333fdece001b6f8bcedb367887f4d7aa | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 26 | 2011-10-31-1f359ece-10574-0 |
9f38197272974d8b195ff182acacb9bc491689fe | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 27 | 2011-10-31-1f359ece-10574-0 |
8396af92311cf9f239cfaa0d9bc012f9a060c747 | 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-31 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 28 | 2011-10-31-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");