items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
35 rows where record_id = "2012-04-30-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 |
---|---|---|---|---|---|---|---|
32c4eb668a6f17464c88df0ac424dd4ac8f3667d | Payments from News International Supply Co Ltd. Address: Cygnet Park, 200 Serpentine Way, Peterborough PE7 8FD: | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 0 | 2012-04-30-1f359ece-10574-0 |
bb5a93d877d73631fdb5230d30af6f7049480334 | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 1 | 2012-04-30-1f359ece-10574-0 |
f3c1d31d82bf49f2885fd891a9855c9a30cde2da | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 2 | 2012-04-30-1f359ece-10574-0 |
980d97f17c2f6b2cdf38402cffe2edd5e27fd876 | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 3 | 2012-04-30-1f359ece-10574-0 |
3d4cb5bd25a383c84cbe9d06a6c2d972d8ce1f18 | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 4 | 2012-04-30-1f359ece-10574-0 |
12ef3a74c4d22cb21fe9ec358ed393aa06ce8436 | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 5 | 2012-04-30-1f359ece-10574-0 |
a0941dbe5a6672751f8d57776071087060360c32 | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 6 | 2012-04-30-1f359ece-10574-0 |
c05ae4ffc3bbdab92ca576512261ef01a577bb59 | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 7 | 2012-04-30-1f359ece-10574-0 |
e87386c0286e25aa27667482b3c894cc96b4a387 | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 8 | 2012-04-30-1f359ece-10574-0 |
2918c5b66491de8faa9ff4e6f69afdbdced46b9c | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 9 | 2012-04-30-1f359ece-10574-0 |
916faa27e5642465faa097382085b6acfd422fad | 16 January 2012, payment of £500 for article in The Times on 4 January 2012. Hours: 3 hrs. (Registered 17 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 10 | 2012-04-30-1f359ece-10574-0 |
5abf5d154e61e13e1e3d35f63574a85ccb86a292 | 22 December 2011, received payment of £360 from the Daily Telegraph for article of 7 December 2011. Address: 111 Buckingham Palace Road, London SW1W 0DT. Hours: 2 hrs. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 11 | 2012-04-30-1f359ece-10574-0 |
10f455bfcf0f7c8e56597ae0d8728ae4c55a9e91 | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 12 | 2012-04-30-1f359ece-10574-0 |
59dbe8343e415ca400749a715e971fb2efcf17a2 | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 13 | 2012-04-30-1f359ece-10574-0 |
6bdaf39282749ab9f0c32aaf388d08e439d40e34 | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 14 | 2012-04-30-1f359ece-10574-0 |
9bb49524df529185629dde353e8e9ec8e626747f | Payments from Specialist Speakers, 18 Waxwell Lane, Harrow, London, HA5 3EN, UK | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 15 | 2012-04-30-1f359ece-10574-0 |
e0d5cbefe1a2ab49d33f1bd57d7874fcbc202cf4 | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 16 | 2012-04-30-1f359ece-10574-0 |
1732f907551a3b05f62f0e7bbc3408e36301d3c2 | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 17 | 2012-04-30-1f359ece-10574-0 |
c2bfde2799b04b924da9fbb2ed8dee37592c8d8d | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 18 | 2012-04-30-1f359ece-10574-0 |
fc0a153bd090b1e53b00466ff7caa87113f57072 | Flights costing £4,480 and sundries of £76.36 received in respect of speaking engagements for International Stability Operations Association, 1634 I Street NW, Washington DC 2006, USA, "Annual Summit", the Ronald Reagan Centre, Washington DC, USA from 24 to 26 October 2011. Hours: 3 days. (Registered 17 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 19 | 2012-04-30-1f359ece-10574-0 |
d5989eabe8080b1d1f1f80379fbb0f7b68ffc38c | 7 December 2011, received fee of £9,000 in respect of speaking engagement for International Stability Operations (see above). (Registered 11 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 20 | 2012-04-30-1f359ece-10574-0 |
835ba1df44cef64d0e5241897bcf84d4ff48739f | 25 November 2011, received fee of £4,000 in respect of speaking engagement on 10 November 2011 for Mobile Doctors Ltd (of 4 Bourne Court, Southend Road, Woodford Green, Essex IG8 8HD) at the Abode Hotel, 107 Piccadilly Manchester M1 2DB. Hours: 12 hrs (Registered 30 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 21 | 2012-04-30-1f359ece-10574-0 |
570b0524e4e5bf1d55cfd5cb4f160cb3e105799b | 25 November 2011, received fee of £4,000 in respect of speaking engagement on 1 November 2011 for a conference organised by ABP [AutoBodiesProfessional] Club Ltd (PO Box 8338, Kirby Muxloe, Leicestershire, LE9 2WW) in Warwickshire. Hours: 7 hrs (Registered 30 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 22 | 2012-04-30-1f359ece-10574-0 |
0d695d758e7e575b84b014b2be30d733743de3ec | 7 December 2011, received fee of £5,750 in respect of speaking engagement on 9 November 2011 for MSL Capital (of 81 Whitfield St, London W1T 4HG) at 10 Gresham St, London EC2V 7JD. Hours: 4 hrs. (Registered 11 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 23 | 2012-04-30-1f359ece-10574-0 |
cf2995f223b1902d613e763a281fd907e459e9c8 | 24 February 2012, received fee of £4,000 in respect of speaking engagement on 22 November 2011 for Brokerbility of AGM House, 3 Barton Close, Grove Park, Enderby, Leicester LE19 1SJ at Leicester Marriott Hotel. Hours: 7 hrs. (Registered 7 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 24 | 2012-04-30-1f359ece-10574-0 |
3e5e514525f1cd04d935a9f55be5216439b38196 | 24 February 2012, received fee of £3,000 in respect of speaking engagement on 24 November 2011 for Keoghs, Solicitors, of the Parklands, Bolton, BL6 4SE, at 1 Great George St, London SW1P 3AE. Hours: 3 hrs. (Registered 7 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 25 | 2012-04-30-1f359ece-10574-0 |
667c97b12a8e9f1a280e3dfe9f1ef03ab54118c2 | 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 (£55,001-£60,000) Payment received on a quarterly basis. | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 26 | 2012-04-30-1f359ece-10574-0 |
e566eb091b7ae6f9e5175869f1b5433745693a50 | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 27 | 2012-04-30-1f359ece-10574-0 |
5662c2366fdd56066b0f8b0dcca9b6e1ed90bbcd | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 28 | 2012-04-30-1f359ece-10574-0 |
d14dba1c5a940312d4d6d88dd6ca6509dd709360 | 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 | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 29 | 2012-04-30-1f359ece-10574-0 |
cabb70afa5ac2543c26f8ee72c03052a3a36c992 | 30 December 2011, received £15,000 consultancy fee for quarter 1 October to 31 December 2011. Hours: 45 hrs. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 30 | 2012-04-30-1f359ece-10574-0 |
1ae77f2101fe70bf9c79506f2930c1035c03f8d4 | 18 April 2012, received £15,000 consultancy fee for quarter 1 January to 31 March 2012. Hours; approx 30 hrs. (Registered 19 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 31 | 2012-04-30-1f359ece-10574-0 |
c59feefc5d6df4636f40b969a7eeee336f7876f1 | 25 November 2011, received from Forbes and Partners, Solicitors, six bottles of wine, approx value £75.00, in respect of a speech by me to a conference organised by Forbes in Manchester Town Hall on 4 November 2011. Address: Forbes and Partners, Solicitors, 4 Wellington Street, St John's, Blackburn BB1 8AF (Registered 30 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 32 | 2012-04-30-1f359ece-10574-0 |
f21981530f318e6ff570dead9e12e1d3a61df452 | 22 March 2012, received £30,750 as signature advance, ie 25% of the total eventually due, for the manuscript of a book, from Macmillans Publishers, via Capel & Land Ltd, Literary Agents (and net of their commission). Address of Macmillans: 20 New Wharf Road London N1 9RR. | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 33 | 2012-04-30-1f359ece-10574-0 |
8e28d087e90db08056fc1fa816580faf30e5833c | Time taken so far (since October 2011): at least 300 hours. (Registered 2 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 34 | 2012-04-30-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");